eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_TP_STMT_PKG dependencies on ARP_UTIL

Line 78: arp_util.debug('gc_reporting_entity : ' || gc_reporting_entity);

74: gc_org_id := ' AND rct.legal_entity_id = :P_REPORTING_ENTITY_ID ';
75: gc_rcpt_org_id := ' AND acr.legal_entity_id = :P_REPORTING_ENTITY_ID ';
76: END IF;
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_util.debug('gc_reporting_entity : ' || gc_reporting_entity);
79: arp_util.debug('gc_org_id : ' || gc_org_id);
80: arp_util.debug('gc_rcpt_org_id : ' || gc_rcpt_org_id);
81: END IF;
82: --****************************************************

Line 79: arp_util.debug('gc_org_id : ' || gc_org_id);

75: gc_rcpt_org_id := ' AND acr.legal_entity_id = :P_REPORTING_ENTITY_ID ';
76: END IF;
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_util.debug('gc_reporting_entity : ' || gc_reporting_entity);
79: arp_util.debug('gc_org_id : ' || gc_org_id);
80: arp_util.debug('gc_rcpt_org_id : ' || gc_rcpt_org_id);
81: END IF;
82: --****************************************************
83: -- Based on P_CUST_CLASS the data will be filtered

Line 80: arp_util.debug('gc_rcpt_org_id : ' || gc_rcpt_org_id);

76: END IF;
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_util.debug('gc_reporting_entity : ' || gc_reporting_entity);
79: arp_util.debug('gc_org_id : ' || gc_org_id);
80: arp_util.debug('gc_rcpt_org_id : ' || gc_rcpt_org_id);
81: END IF;
82: --****************************************************
83: -- Based on P_CUST_CLASS the data will be filtered
84: -- else we will fetch all the Customers of any Customer Class

Line 90: arp_util.debug('gc_cust_class : ' || gc_cust_class);

86: IF P_CUST_CLASS IS NOT NULL THEN
87: gc_cust_class := ' AND hca.customer_class_code = :P_CUST_CLASS ';
88: END IF;
89: IF PG_DEBUG in ('Y', 'C') THEN
90: arp_util.debug('gc_cust_class : ' || gc_cust_class);
91: END IF;
92: --****************************************************
93: -- Based on P_CUST_CATEGORY the data will be filtered
94: -- else we will fetch all the Customers of any Customer Category

Line 100: arp_util.debug('gc_cust_category : ' || gc_cust_category);

96: IF P_CUST_CATEGORY IS NOT NULL THEN
97: gc_cust_category := ' AND hpar.category_code = :P_CUST_CATEGORY ';
98: END IF;
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_util.debug('gc_cust_category : ' || gc_cust_category);
101: END IF;
102: --****************************************************
103: -- Based on P_CURRENCY the data will be filtered
104: -- else we receive the information for all Currencies

Line 111: arp_util.debug('gc_currency : ' || gc_currency);

107: gc_currency := ' AND rct.invoice_currency_code = :P_CURRENCY ';
108: gc_rcpt_currency := ' AND acr.currency_code = :P_CURRENCY ';
109: END IF;
110: IF PG_DEBUG in ('Y', 'C') THEN
111: arp_util.debug('gc_currency : ' || gc_currency);
112: arp_util.debug('gc_rcpt_currency : ' || gc_rcpt_currency);
113: END IF;
114: --****************************************************
115: -- Based on P_ACCOUNTED the data will be filtered

Line 112: arp_util.debug('gc_rcpt_currency : ' || gc_rcpt_currency);

108: gc_rcpt_currency := ' AND acr.currency_code = :P_CURRENCY ';
109: END IF;
110: IF PG_DEBUG in ('Y', 'C') THEN
111: arp_util.debug('gc_currency : ' || gc_currency);
112: arp_util.debug('gc_rcpt_currency : ' || gc_rcpt_currency);
113: END IF;
114: --****************************************************
115: -- Based on P_ACCOUNTED the data will be filtered
116: -- for 'Accounted' --> Only Accounted Records will be fetched

Line 132: arp_util.debug('gc_accounted : ' || gc_accounted);

128: gc_adj_accounted := ' AND aa.posting_control_id = -3 ';
129: gc_app_accounted := ' AND ara.posting_control_id = -3 ';
130: END IF;
131: IF PG_DEBUG in ('Y', 'C') THEN
132: arp_util.debug('gc_accounted : ' || gc_accounted);
133: arp_util.debug('gc_rcpt_accounted : ' || gc_rcpt_accounted);
134: arp_util.debug('gc_adj_accounted : ' || gc_adj_accounted);
135: arp_util.debug('gc_app_accounted : ' || gc_app_accounted);
136: END IF;

Line 133: arp_util.debug('gc_rcpt_accounted : ' || gc_rcpt_accounted);

129: gc_app_accounted := ' AND ara.posting_control_id = -3 ';
130: END IF;
131: IF PG_DEBUG in ('Y', 'C') THEN
132: arp_util.debug('gc_accounted : ' || gc_accounted);
133: arp_util.debug('gc_rcpt_accounted : ' || gc_rcpt_accounted);
134: arp_util.debug('gc_adj_accounted : ' || gc_adj_accounted);
135: arp_util.debug('gc_app_accounted : ' || gc_app_accounted);
136: END IF;
137: --****************************************************

Line 134: arp_util.debug('gc_adj_accounted : ' || gc_adj_accounted);

130: END IF;
131: IF PG_DEBUG in ('Y', 'C') THEN
132: arp_util.debug('gc_accounted : ' || gc_accounted);
133: arp_util.debug('gc_rcpt_accounted : ' || gc_rcpt_accounted);
134: arp_util.debug('gc_adj_accounted : ' || gc_adj_accounted);
135: arp_util.debug('gc_app_accounted : ' || gc_app_accounted);
136: END IF;
137: --****************************************************
138: -- Based on P_INCOMPLETE_TRX the data will be filtered

Line 135: arp_util.debug('gc_app_accounted : ' || gc_app_accounted);

131: IF PG_DEBUG in ('Y', 'C') THEN
132: arp_util.debug('gc_accounted : ' || gc_accounted);
133: arp_util.debug('gc_rcpt_accounted : ' || gc_rcpt_accounted);
134: arp_util.debug('gc_adj_accounted : ' || gc_adj_accounted);
135: arp_util.debug('gc_app_accounted : ' || gc_app_accounted);
136: END IF;
137: --****************************************************
138: -- Based on P_INCOMPLETE_TRX the data will be filtered
139: -- for 'Y' --> Pick all Transactions (Complete/Incomplete)

Line 146: arp_util.debug('gc_incomplete_trx : ' || gc_incomplete_trx);

142: IF P_INCOMPLETE_TRX = 'N' THEN
143: gc_incomplete_trx := ' AND rct.complete_flag = ''Y'' ';
144: END IF;
145: IF PG_DEBUG in ('Y', 'C') THEN
146: arp_util.debug('gc_incomplete_trx : ' || gc_incomplete_trx);
147: END IF;
148: END set_to_receivables;
149: --**********************************************************
150: -- Before Report function used to obtain the Dynamic Queries

Line 157: arp_util.debug('P_REPORTING_LEVEL : '||P_REPORTING_LEVEL);

153: FUNCTION beforereport RETURN BOOLEAN
154: IS
155: BEGIN
156: IF PG_DEBUG in ('Y', 'C') THEN
157: arp_util.debug('P_REPORTING_LEVEL : '||P_REPORTING_LEVEL);
158: arp_util.debug('P_REPORTING_ENTITY_ID : '||P_REPORTING_ENTITY_ID);
159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);
160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);

Line 158: arp_util.debug('P_REPORTING_ENTITY_ID : '||P_REPORTING_ENTITY_ID);

154: IS
155: BEGIN
156: IF PG_DEBUG in ('Y', 'C') THEN
157: arp_util.debug('P_REPORTING_LEVEL : '||P_REPORTING_LEVEL);
158: arp_util.debug('P_REPORTING_ENTITY_ID : '||P_REPORTING_ENTITY_ID);
159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);
160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);

Line 159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);

155: BEGIN
156: IF PG_DEBUG in ('Y', 'C') THEN
157: arp_util.debug('P_REPORTING_LEVEL : '||P_REPORTING_LEVEL);
158: arp_util.debug('P_REPORTING_ENTITY_ID : '||P_REPORTING_ENTITY_ID);
159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);
160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);

Line 160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);

156: IF PG_DEBUG in ('Y', 'C') THEN
157: arp_util.debug('P_REPORTING_LEVEL : '||P_REPORTING_LEVEL);
158: arp_util.debug('P_REPORTING_ENTITY_ID : '||P_REPORTING_ENTITY_ID);
159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);
160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);

Line 161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);

157: arp_util.debug('P_REPORTING_LEVEL : '||P_REPORTING_LEVEL);
158: arp_util.debug('P_REPORTING_ENTITY_ID : '||P_REPORTING_ENTITY_ID);
159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);
160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);

Line 162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);

158: arp_util.debug('P_REPORTING_ENTITY_ID : '||P_REPORTING_ENTITY_ID);
159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);
160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);

Line 163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);

159: arp_util.debug('P_REPORTING_ENTITY_NAME : '||P_REPORTING_ENTITY_NAME);
160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);

Line 164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);

160: arp_util.debug('P_FROM_DOC_DATE : '||P_FROM_DOC_DATE);
161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);
168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);

Line 165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);

161: arp_util.debug('P_TO_DOC_DATE : '||P_TO_DOC_DATE);
162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);
168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);
169: arp_util.debug('P_INCOMPLETE_TRX : '||P_INCOMPLETE_TRX);

Line 166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);

162: arp_util.debug('P_FROM_GL_DATE : '||P_FROM_GL_DATE);
163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);
168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);
169: arp_util.debug('P_INCOMPLETE_TRX : '||P_INCOMPLETE_TRX);
170: arp_util.debug('P_ACCOUNTED : '||P_ACCOUNTED);

Line 167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);

163: arp_util.debug('P_TO_GL_DATE : '||P_TO_GL_DATE);
164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);
168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);
169: arp_util.debug('P_INCOMPLETE_TRX : '||P_INCOMPLETE_TRX);
170: arp_util.debug('P_ACCOUNTED : '||P_ACCOUNTED);
171: END IF;

Line 168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);

164: arp_util.debug('P_FROM_CUST_NAME : '||P_FROM_CUST_NAME);
165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);
168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);
169: arp_util.debug('P_INCOMPLETE_TRX : '||P_INCOMPLETE_TRX);
170: arp_util.debug('P_ACCOUNTED : '||P_ACCOUNTED);
171: END IF;
172: set_to_receivables();

Line 169: arp_util.debug('P_INCOMPLETE_TRX : '||P_INCOMPLETE_TRX);

165: arp_util.debug('P_TO_CUST_NAME : '||P_TO_CUST_NAME);
166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);
168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);
169: arp_util.debug('P_INCOMPLETE_TRX : '||P_INCOMPLETE_TRX);
170: arp_util.debug('P_ACCOUNTED : '||P_ACCOUNTED);
171: END IF;
172: set_to_receivables();
173: --****************************************************

Line 170: arp_util.debug('P_ACCOUNTED : '||P_ACCOUNTED);

166: arp_util.debug('P_CURRENCY : '||P_CURRENCY);
167: arp_util.debug('P_CUST_CATEGORY : '||P_CUST_CATEGORY);
168: arp_util.debug('P_CUST_CLASS : '||P_CUST_CLASS);
169: arp_util.debug('P_INCOMPLETE_TRX : '||P_INCOMPLETE_TRX);
170: arp_util.debug('P_ACCOUNTED : '||P_ACCOUNTED);
171: END IF;
172: set_to_receivables();
173: --****************************************************
174: -- Based on P_FROM_CUST_NAME and P_TO_CUST_NAME the

Line 189: arp_util.debug('gc_customer_name : ' || gc_customer_name);

185: ELSE
186: gc_customer_name := ' AND 1 = 1 ';
187: END IF;
188: IF PG_DEBUG in ('Y', 'C') THEN
189: arp_util.debug('gc_customer_name : ' || gc_customer_name);
190: END IF;
191: RETURN (TRUE);
192: END beforereport;
193: --**********************************************************