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.XLA_XLAABACR_XMLP_PKG dependencies on XLA_UTILITY_PKG

Line 118: XLA_UTILITY_PKG.ACTIVATE('SRS_DBP'

114: L_COMPILE_STATUS_CODE VARCHAR2(1);
115: L_HASH_ID INTEGER;
116: BEGIN
117: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
118: XLA_UTILITY_PKG.ACTIVATE('SRS_DBP'
119: ,'XLAABACR');
120: XLA_ENVIRONMENT_PKG.REFRESH;
121: SET_REPORT_CONSTANTS;
122: IF (P_REPORT_ONLY_MODE < 'Y') THEN

Line 125: XLA_UTILITY_PKG.TRACE('use c_aad1'

121: SET_REPORT_CONSTANTS;
122: IF (P_REPORT_ONLY_MODE < 'Y') THEN
123: IF (P_LEDGER_ID IS NULL) THEN
124: IF (P_APPLICATION_ID IS NULL) THEN
125: XLA_UTILITY_PKG.TRACE('use c_aad1'
126: ,30);
127: OPEN C_AAD1;
128: LOOP
129: FETCH C_AAD1

Line 136: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID

132: ,L_AMB_CONTEXT_CODE
133: ,L_PROD_RULE_TYPE_CODE
134: ,L_PROD_RULE_CODE;
135: EXIT WHEN C_AAD1%NOTFOUND;
136: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
137: ,30);
138: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
139: ,30);
140: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

Line 138: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE

134: ,L_PROD_RULE_CODE;
135: EXIT WHEN C_AAD1%NOTFOUND;
136: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
137: ,30);
138: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
139: ,30);
140: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
141: ,30);
142: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

Line 140: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

136: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
137: ,30);
138: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
139: ,30);
140: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
141: ,30);
142: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
143: ,30);
144: UPDATE

Line 142: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

138: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
139: ,30);
140: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
141: ,30);
142: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
143: ,30);
144: UPDATE
145: XLA_PRODUCT_RULES_B
146: SET

Line 176: XLA_UTILITY_PKG.TRACE('use c_aad2'

172: AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
173: END LOOP;
174: CLOSE C_AAD1;
175: ELSIF (P_PRODUCT_RULE_CODE IS NULL) THEN
176: XLA_UTILITY_PKG.TRACE('use c_aad2'
177: ,30);
178: OPEN C_AAD2;
179: LOOP
180: FETCH C_AAD2

Line 187: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID

183: ,L_AMB_CONTEXT_CODE
184: ,L_PROD_RULE_TYPE_CODE
185: ,L_PROD_RULE_CODE;
186: EXIT WHEN C_AAD2%NOTFOUND;
187: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
188: ,30);
189: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
190: ,30);
191: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

Line 189: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE

185: ,L_PROD_RULE_CODE;
186: EXIT WHEN C_AAD2%NOTFOUND;
187: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
188: ,30);
189: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
190: ,30);
191: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
192: ,30);
193: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

Line 191: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

187: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
188: ,30);
189: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
190: ,30);
191: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
192: ,30);
193: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
194: ,30);
195: UPDATE

Line 193: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

189: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
190: ,30);
191: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
192: ,30);
193: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
194: ,30);
195: UPDATE
196: XLA_PRODUCT_RULES_B
197: SET

Line 227: XLA_UTILITY_PKG.TRACE('use c_aad3'

223: AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
224: END LOOP;
225: CLOSE C_AAD2;
226: ELSE
227: XLA_UTILITY_PKG.TRACE('use c_aad3'
228: ,30);
229: OPEN C_AAD3;
230: LOOP
231: FETCH C_AAD3

Line 238: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID

234: ,L_AMB_CONTEXT_CODE
235: ,L_PROD_RULE_TYPE_CODE
236: ,L_PROD_RULE_CODE;
237: EXIT WHEN C_AAD3%NOTFOUND;
238: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
239: ,30);
240: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
241: ,30);
242: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

Line 240: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE

236: ,L_PROD_RULE_CODE;
237: EXIT WHEN C_AAD3%NOTFOUND;
238: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
239: ,30);
240: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
241: ,30);
242: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
243: ,30);
244: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

Line 242: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

238: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
239: ,30);
240: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
241: ,30);
242: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
243: ,30);
244: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
245: ,30);
246: UPDATE

Line 244: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

240: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
241: ,30);
242: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
243: ,30);
244: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
245: ,30);
246: UPDATE
247: XLA_PRODUCT_RULES_B
248: SET

Line 280: XLA_UTILITY_PKG.TRACE('use c_aad5'

276: CLOSE C_AAD3;
277: END IF;
278: ELSE
279: IF (CP_LEDGER_CATEGORY = 'SECONDARY') THEN
280: XLA_UTILITY_PKG.TRACE('use c_aad5'
281: ,30);
282: OPEN C_AAD5;
283: LOOP
284: FETCH C_AAD5

Line 291: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID

287: ,L_AMB_CONTEXT_CODE
288: ,L_PROD_RULE_TYPE_CODE
289: ,L_PROD_RULE_CODE;
290: EXIT WHEN C_AAD5%NOTFOUND;
291: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
292: ,30);
293: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
294: ,30);
295: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

Line 293: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE

289: ,L_PROD_RULE_CODE;
290: EXIT WHEN C_AAD5%NOTFOUND;
291: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
292: ,30);
293: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
294: ,30);
295: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
296: ,30);
297: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

Line 295: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

291: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
292: ,30);
293: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
294: ,30);
295: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
296: ,30);
297: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
298: ,30);
299: UPDATE

Line 297: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

293: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
294: ,30);
295: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
296: ,30);
297: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
298: ,30);
299: UPDATE
300: XLA_PRODUCT_RULES_B
301: SET

Line 331: XLA_UTILITY_PKG.TRACE('use c_aad4'

327: AND PRODUCT_RULE_CODE = L_PROD_RULE_CODE;
328: END LOOP;
329: CLOSE C_AAD5;
330: ELSE
331: XLA_UTILITY_PKG.TRACE('use c_aad4'
332: ,30);
333: OPEN C_AAD4;
334: LOOP
335: FETCH C_AAD4

Line 342: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID

338: ,L_AMB_CONTEXT_CODE
339: ,L_PROD_RULE_TYPE_CODE
340: ,L_PROD_RULE_CODE;
341: EXIT WHEN C_AAD4%NOTFOUND;
342: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
343: ,30);
344: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
345: ,30);
346: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

Line 344: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE

340: ,L_PROD_RULE_CODE;
341: EXIT WHEN C_AAD4%NOTFOUND;
342: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
343: ,30);
344: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
345: ,30);
346: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
347: ,30);
348: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

Line 346: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE

342: XLA_UTILITY_PKG.TRACE('l_application_id = ' || L_APPLICATION_ID
343: ,30);
344: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
345: ,30);
346: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
347: ,30);
348: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
349: ,30);
350: UPDATE

Line 348: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE

344: XLA_UTILITY_PKG.TRACE('l_amb_context_code = ' || L_AMB_CONTEXT_CODE
345: ,30);
346: XLA_UTILITY_PKG.TRACE('l_prod_rule_type_code = ' || L_PROD_RULE_TYPE_CODE
347: ,30);
348: XLA_UTILITY_PKG.TRACE('l_prod_rule_code = ' || L_PROD_RULE_CODE
349: ,30);
350: UPDATE
351: XLA_PRODUCT_RULES_B
352: SET

Line 399: XLA_UTILITY_PKG.TRACE('> XLA_XLAABACR_XMLP_PKG.set_report_constants'

395: FROM
396: XLA_GL_LEDGERS_V
397: WHERE LEDGER_ID = P_LEDGER_ID;
398: BEGIN
399: XLA_UTILITY_PKG.TRACE('> XLA_XLAABACR_XMLP_PKG.set_report_constants'
400: ,20);
401: CP_DEBUG_FLAG := NVL(FND_PROFILE.VALUE('XLA_DEBUG_TRACE')
402: ,'N');
403: CP_DEFAULT_MODULE := 'xla.reports.XLAABACR';

Line 637: XLA_UTILITY_PKG.TRACE('CP_QUERY = ' || CP_QUERY

633: and amr.accounting_method_code = le.sla_accounting_method_code
634: and le.ledger_id = ' || P_LEDGER_ID;
635: END IF;
636: END IF;
637: XLA_UTILITY_PKG.TRACE('CP_QUERY = ' || CP_QUERY
638: ,30);
639: XLA_UTILITY_PKG.TRACE('CP_AAD_QUERY = ' || CP_AAD_QUERY
640: ,30);
641: XLA_UTILITY_PKG.TRACE('CP_AAD_WHERE = ' || CP_AAD_WHERE

Line 639: XLA_UTILITY_PKG.TRACE('CP_AAD_QUERY = ' || CP_AAD_QUERY

635: END IF;
636: END IF;
637: XLA_UTILITY_PKG.TRACE('CP_QUERY = ' || CP_QUERY
638: ,30);
639: XLA_UTILITY_PKG.TRACE('CP_AAD_QUERY = ' || CP_AAD_QUERY
640: ,30);
641: XLA_UTILITY_PKG.TRACE('CP_AAD_WHERE = ' || CP_AAD_WHERE
642: ,30);
643: XLA_UTILITY_PKG.TRACE('< XLA_XLAABACR_XMLP_PKG.set_report_constants'

Line 641: XLA_UTILITY_PKG.TRACE('CP_AAD_WHERE = ' || CP_AAD_WHERE

637: XLA_UTILITY_PKG.TRACE('CP_QUERY = ' || CP_QUERY
638: ,30);
639: XLA_UTILITY_PKG.TRACE('CP_AAD_QUERY = ' || CP_AAD_QUERY
640: ,30);
641: XLA_UTILITY_PKG.TRACE('CP_AAD_WHERE = ' || CP_AAD_WHERE
642: ,30);
643: XLA_UTILITY_PKG.TRACE('< XLA_XLAABACR_XMLP_PKG.set_report_constants'
644: ,20);
645: EXCEPTION

Line 643: XLA_UTILITY_PKG.TRACE('< XLA_XLAABACR_XMLP_PKG.set_report_constants'

639: XLA_UTILITY_PKG.TRACE('CP_AAD_QUERY = ' || CP_AAD_QUERY
640: ,30);
641: XLA_UTILITY_PKG.TRACE('CP_AAD_WHERE = ' || CP_AAD_WHERE
642: ,30);
643: XLA_UTILITY_PKG.TRACE('< XLA_XLAABACR_XMLP_PKG.set_report_constants'
644: ,20);
645: EXCEPTION
646: WHEN OTHERS THEN
647: RAISE_APPLICATION_ERROR(-20101

Line 655: XLA_UTILITY_PKG.TRACE('setting completion status to WARNING'

651: FUNCTION AFTERREPORT RETURN BOOLEAN IS
652: L_TEMP BOOLEAN;
653: BEGIN
654: IF CP_RET_CODE = 1 OR P_REPORT_ONLY_MODE = 'Y' THEN
655: XLA_UTILITY_PKG.TRACE('setting completion status to WARNING'
656: ,30);
657: L_TEMP := FND_CONCURRENT.SET_COMPLETION_STATUS(STATUS => 'WARNING'
658: ,MESSAGE => NULL);
659: ELSIF CP_RET_CODE = 0 THEN

Line 662: XLA_UTILITY_PKG.TRACE('setting completion status to ERROR'

658: ,MESSAGE => NULL);
659: ELSIF CP_RET_CODE = 0 THEN
660: NULL;
661: ELSE
662: XLA_UTILITY_PKG.TRACE('setting completion status to ERROR'
663: ,30);
664: L_TEMP := FND_CONCURRENT.SET_COMPLETION_STATUS(STATUS => 'ERROR'
665: ,MESSAGE => NULL);
666: END IF;

Line 667: XLA_UTILITY_PKG.DEACTIVATE('XLAABACR');

663: ,30);
664: L_TEMP := FND_CONCURRENT.SET_COMPLETION_STATUS(STATUS => 'ERROR'
665: ,MESSAGE => NULL);
666: END IF;
667: XLA_UTILITY_PKG.DEACTIVATE('XLAABACR');
668: RETURN (TRUE);
669: EXCEPTION
670: WHEN OTHERS THEN
671: XLA_UTILITY_PKG.DEACTIVATE('XLAABACR');

Line 671: XLA_UTILITY_PKG.DEACTIVATE('XLAABACR');

667: XLA_UTILITY_PKG.DEACTIVATE('XLAABACR');
668: RETURN (TRUE);
669: EXCEPTION
670: WHEN OTHERS THEN
671: XLA_UTILITY_PKG.DEACTIVATE('XLAABACR');
672: RAISE_APPLICATION_ERROR(-20101
673: ,NULL);
674: END AFTERREPORT;
675: