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.GCS_AD_TRIALBALANCE_PKG dependencies on FND_LOG

Line 51: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

47: EXCEPTION
48: WHEN OTHERS
49: THEN
50: -- Write the appropriate information to the execution report
51: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
52: THEN
53: fnd_log.STRING (fnd_log.level_error,
54: g_pkg_name || '.' || l_api_name,
55: gcs_utility_pkg.g_module_failure

Line 53: fnd_log.STRING (fnd_log.level_error,

49: THEN
50: -- Write the appropriate information to the execution report
51: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
52: THEN
53: fnd_log.STRING (fnd_log.level_error,
54: g_pkg_name || '.' || l_api_name,
55: gcs_utility_pkg.g_module_failure
56: || ' '
57: || SQLERRM

Line 97: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

93: BEGIN
94: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER');
95: FND_FILE.NEW_LINE(FND_FILE.LOG);
96:
97: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
98: THEN
99: fnd_log.STRING (fnd_log.level_procedure,
100: g_pkg_name || '.' || l_api_name,
101: gcs_utility_pkg.g_module_enter

Line 99: fnd_log.STRING (fnd_log.level_procedure,

95: FND_FILE.NEW_LINE(FND_FILE.LOG);
96:
97: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
98: THEN
99: fnd_log.STRING (fnd_log.level_procedure,
100: g_pkg_name || '.' || l_api_name,
101: gcs_utility_pkg.g_module_enter
102: || ' p_xns_id = '
103: || p_xns_id

Line 124: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

120: );
121: END IF;
122:
123: -- select assoc_entry_id from gcs_ad_transactions table
124: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
125: THEN
126: fnd_log.STRING (fnd_log.level_statement,
127: g_pkg_name || '.' || l_api_name,
128: 'SELECT gat.assoc_entry_id, gat.cal_period_id, fcpa.number_assign_value + 1 '

Line 126: fnd_log.STRING (fnd_log.level_statement,

122:
123: -- select assoc_entry_id from gcs_ad_transactions table
124: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
125: THEN
126: fnd_log.STRING (fnd_log.level_statement,
127: g_pkg_name || '.' || l_api_name,
128: 'SELECT gat.assoc_entry_id, gat.cal_period_id, fcpa.number_assign_value + 1 '
129: || g_nl
130: || 'INTO l_entry_id, l_cal_period_id, l_year_to_apply_re '

Line 161: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

157: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' CREATE ENTRY');
158: FND_FILE.NEW_LINE(FND_FILE.LOG);
159:
160: -- create an entry header if not exists
161: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
162: THEN
163: fnd_log.STRING (fnd_log.level_statement,
164: g_pkg_name || '.' || l_api_name,
165: 'SELECT gcs_entry_headers_s.NEXTVAL'

Line 163: fnd_log.STRING (fnd_log.level_statement,

159:
160: -- create an entry header if not exists
161: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
162: THEN
163: fnd_log.STRING (fnd_log.level_statement,
164: g_pkg_name || '.' || l_api_name,
165: 'SELECT gcs_entry_headers_s.NEXTVAL'
166: || g_nl
167: || 'INTO l_entry_id'

Line 195: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

191: x_errbuf => l_errbuf,
192: x_retcode => l_retcode
193: );
194:
195: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
196: THEN
197: fnd_log.STRING (fnd_log.level_statement,
198: g_pkg_name || '.' || l_api_name,
199: 'UPDATE gcs_ad_transactions'

Line 197: fnd_log.STRING (fnd_log.level_statement,

193: );
194:
195: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
196: THEN
197: fnd_log.STRING (fnd_log.level_statement,
198: g_pkg_name || '.' || l_api_name,
199: 'UPDATE gcs_ad_transactions'
200: || g_nl
201: || 'SET ASSOC_ENTRY_ID = '

Line 234: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

230: THEN
231: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' UPDATE EXISTING ENTRY');
232: FND_FILE.NEW_LINE(FND_FILE.LOG);
233:
234: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
235: THEN
236: fnd_log.STRING (fnd_log.level_statement,
237: g_pkg_name || '.' || l_api_name,
238: 'UPDATE gcs_entry_headers'

Line 236: fnd_log.STRING (fnd_log.level_statement,

232: FND_FILE.NEW_LINE(FND_FILE.LOG);
233:
234: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
235: THEN
236: fnd_log.STRING (fnd_log.level_statement,
237: g_pkg_name || '.' || l_api_name,
238: 'UPDATE gcs_entry_headers'
239: || g_nl
240: || 'SET entry_name = '

Line 265: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

261: END;
262:
263: IF p_consideration_amount is not null THEN
264: -- update total_consideration in gcs_ad_transactions table
265: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
266: THEN
267: fnd_log.STRING (fnd_log.level_statement,
268: g_pkg_name || '.' || l_api_name,
269: 'UPDATE gcs_ad_transactions'

Line 267: fnd_log.STRING (fnd_log.level_statement,

263: IF p_consideration_amount is not null THEN
264: -- update total_consideration in gcs_ad_transactions table
265: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
266: THEN
267: fnd_log.STRING (fnd_log.level_statement,
268: g_pkg_name || '.' || l_api_name,
269: 'UPDATE gcs_ad_transactions'
270: || g_nl
271: || 'SET total_consideration = '

Line 297: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

293: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' DISABLE EXISTING ENTRY AND CREATE A NEW ONE');
294: FND_FILE.NEW_LINE(FND_FILE.LOG);
295:
296: -- create a new entry header
297: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
298: THEN
299: fnd_log.STRING (fnd_log.level_statement,
300: g_pkg_name || '.' || l_api_name,
301: 'SELECT gcs_entry_headers_s.NEXTVAL'

Line 299: fnd_log.STRING (fnd_log.level_statement,

295:
296: -- create a new entry header
297: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
298: THEN
299: fnd_log.STRING (fnd_log.level_statement,
300: g_pkg_name || '.' || l_api_name,
301: 'SELECT gcs_entry_headers_s.NEXTVAL'
302: || g_nl
303: || 'INTO l_new_entry_id'

Line 313: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

309: SELECT gcs_entry_headers_s.NEXTVAL
310: INTO l_new_entry_id
311: FROM DUAL;
312:
313: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
314: THEN
315: fnd_log.STRING (fnd_log.level_statement,
316: g_pkg_name || '.' || l_api_name,
317: 'UPDATE gcs_entry_headers'

Line 315: fnd_log.STRING (fnd_log.level_statement,

311: FROM DUAL;
312:
313: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
314: THEN
315: fnd_log.STRING (fnd_log.level_statement,
316: g_pkg_name || '.' || l_api_name,
317: 'UPDATE gcs_entry_headers'
318: || g_nl
319: || 'SET disabled_flag = ''Y'''

Line 356: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

352: x_errbuf => l_errbuf,
353: x_retcode => l_retcode
354: );
355:
356: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
357: THEN
358: fnd_log.STRING (fnd_log.level_statement,
359: g_pkg_name || '.' || l_api_name,
360: 'UPDATE gcs_ad_transactions'

Line 358: fnd_log.STRING (fnd_log.level_statement,

354: );
355:
356: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
357: THEN
358: fnd_log.STRING (fnd_log.level_statement,
359: g_pkg_name || '.' || l_api_name,
360: 'UPDATE gcs_ad_transactions'
361: || g_nl
362: || 'SET ASSOC_ENTRY_ID = '

Line 385: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

381:
382: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT');
383: FND_FILE.NEW_LINE(FND_FILE.LOG);
384:
385: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
386: THEN
387: fnd_log.STRING (fnd_log.level_procedure,
388: g_pkg_name || '.' || l_api_name,
389: gcs_utility_pkg.g_module_success

Line 387: fnd_log.STRING (fnd_log.level_procedure,

383: FND_FILE.NEW_LINE(FND_FILE.LOG);
384:
385: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
386: THEN
387: fnd_log.STRING (fnd_log.level_procedure,
388: g_pkg_name || '.' || l_api_name,
389: gcs_utility_pkg.g_module_success
390: || ' '
391: || l_api_name

Line 408: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

404: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || SQLERRM);
405: FND_FILE.NEW_LINE(FND_FILE.LOG);
406:
407: -- Write the appropriate information to the execution report
408: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
409: THEN
410: fnd_log.STRING (fnd_log.level_error,
411: g_pkg_name || '.' || l_api_name,
412: gcs_utility_pkg.g_module_failure

Line 410: fnd_log.STRING (fnd_log.level_error,

406:
407: -- Write the appropriate information to the execution report
408: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
409: THEN
410: fnd_log.STRING (fnd_log.level_error,
411: g_pkg_name || '.' || l_api_name,
412: gcs_utility_pkg.g_module_failure
413: || ' '
414: || l_api_name

Line 428: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

424: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || SQLERRM);
425: FND_FILE.NEW_LINE(FND_FILE.LOG);
426:
427: -- Write the appropriate information to the execution report
428: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
429: THEN
430: fnd_log.STRING (fnd_log.level_error,
431: g_pkg_name || '.' || l_api_name,
432: gcs_utility_pkg.g_module_failure

Line 430: fnd_log.STRING (fnd_log.level_error,

426:
427: -- Write the appropriate information to the execution report
428: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
429: THEN
430: fnd_log.STRING (fnd_log.level_error,
431: g_pkg_name || '.' || l_api_name,
432: gcs_utility_pkg.g_module_failure
433: || ' '
434: || l_api_name

Line 514: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

510:
511: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER');
512: FND_FILE.NEW_LINE(FND_FILE.LOG);
513:
514: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
515: THEN
516: fnd_log.STRING (fnd_log.level_procedure,
517: g_pkg_name || '.' || l_api_name,
518: gcs_utility_pkg.g_module_enter

Line 516: fnd_log.STRING (fnd_log.level_procedure,

512: FND_FILE.NEW_LINE(FND_FILE.LOG);
513:
514: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
515: THEN
516: fnd_log.STRING (fnd_log.level_procedure,
517: g_pkg_name || '.' || l_api_name,
518: gcs_utility_pkg.g_module_enter
519: || ' p_xns_id = '
520: || p_xns_id

Line 538: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

534: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
535: );
536: END IF;
537:
538: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
539: THEN
540: fnd_log.STRING (fnd_log.level_statement,
541: g_pkg_name || '.' || l_api_name,
542: 'select assoc_entry_id into l_orig_entry_id from gcs_ad_transactions

Line 540: fnd_log.STRING (fnd_log.level_statement,

536: END IF;
537:
538: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
539: THEN
540: fnd_log.STRING (fnd_log.level_statement,
541: g_pkg_name || '.' || l_api_name,
542: 'select assoc_entry_id into l_orig_entry_id from gcs_ad_transactions
543: where ad_transaction_id = '
544: || p_xns_id

Line 553: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

549: into l_orig_entry_id
550: from gcs_ad_transactions
551: where ad_transaction_id = p_xns_id;
552:
553: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
554: THEN
555: fnd_log.STRING (fnd_log.level_statement,
556: g_pkg_name || '.' || l_api_name,
557: 'select decode(count(entry_id), 0, ''ACTUAL'', ''ADB'') into l_balance_type_code

Line 555: fnd_log.STRING (fnd_log.level_statement,

551: where ad_transaction_id = p_xns_id;
552:
553: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
554: THEN
555: fnd_log.STRING (fnd_log.level_statement,
556: g_pkg_name || '.' || l_api_name,
557: 'select decode(count(entry_id), 0, ''ACTUAL'', ''ADB'') into l_balance_type_code
558: from gcs_entry_lines where entry_id = -1 and financial_elem_id = 140'
559: );

Line 584: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

580: IF l_entry_id < 0 THEN
581: RAISE import_header_error;
582: END IF;
583:
584: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
585: THEN
586: fnd_log.STRING (fnd_log.level_statement,
587: g_pkg_name || '.' || l_api_name,
588: 'delete from gcs_entry_lines'

Line 586: fnd_log.STRING (fnd_log.level_statement,

582: END IF;
583:
584: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
585: THEN
586: fnd_log.STRING (fnd_log.level_statement,
587: g_pkg_name || '.' || l_api_name,
588: 'delete from gcs_entry_lines'
589: || g_nl
590: || 'where entry_id = '

Line 599: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

595: DELETE FROM gcs_entry_lines
596: WHERE entry_id = l_entry_id;
597:
598:
599: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
600: THEN
601: fnd_log.STRING (fnd_log.level_statement,
602: g_pkg_name || '.' || l_api_name,
603: 'update gcs_entry_lines'

Line 601: fnd_log.STRING (fnd_log.level_statement,

597:
598:
599: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
600: THEN
601: fnd_log.STRING (fnd_log.level_statement,
602: g_pkg_name || '.' || l_api_name,
603: 'update gcs_entry_lines'
604: || g_nl
605: || 'set entry_id = '

Line 653: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

649: )
650: WHERE entry_id = -1;
651:
652: --Bugfix 4411633 : retained earnings should write to child base org
653: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
654: THEN
655: fnd_log.STRING (fnd_log.level_statement,
656: g_pkg_name || '.' || l_api_name,
657: 'SELECT org_output_code INTO l_org_code '

Line 655: fnd_log.STRING (fnd_log.level_statement,

651:
652: --Bugfix 4411633 : retained earnings should write to child base org
653: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
654: THEN
655: fnd_log.STRING (fnd_log.level_statement,
656: g_pkg_name || '.' || l_api_name,
657: 'SELECT org_output_code INTO l_org_code '
658: || 'FROM gcs_categories_b WHERE category_code = ''ACQ_DISP'''
659: );

Line 684: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

680: );
681: END IF;
682: --end of Bugfix 4411633
683:
684: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
685: THEN
686: fnd_log.STRING (fnd_log.level_statement,
687: g_pkg_name || '.' || l_api_name,
688: 'update gcs_ad_transactions'

Line 686: fnd_log.STRING (fnd_log.level_statement,

682: --end of Bugfix 4411633
683:
684: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
685: THEN
686: fnd_log.STRING (fnd_log.level_statement,
687: g_pkg_name || '.' || l_api_name,
688: 'update gcs_ad_transactions'
689: || g_nl
690: || 'set request_id = '

Line 717: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

713: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Generate XML error : ' || SQLERRM);
714: FND_FILE.NEW_LINE(FND_FILE.LOG);
715:
716: -- Write the appropriate information to the execution report
717: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
718: THEN
719: fnd_log.STRING (fnd_log.level_error,
720: g_pkg_name || '.' || l_api_name,
721: gcs_utility_pkg.g_module_failure

Line 719: fnd_log.STRING (fnd_log.level_error,

715:
716: -- Write the appropriate information to the execution report
717: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
718: THEN
719: fnd_log.STRING (fnd_log.level_error,
720: g_pkg_name || '.' || l_api_name,
721: gcs_utility_pkg.g_module_failure
722: || ' entry XML Gen failed: '
723: || SQLERRM

Line 768: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

764: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Raise impact error : ' || SQLERRM);
765: FND_FILE.NEW_LINE(FND_FILE.LOG);
766:
767: -- Write the appropriate information to the execution report
768: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
769: THEN
770: fnd_log.STRING (fnd_log.level_error,
771: g_pkg_name || '.' || l_api_name,
772: gcs_utility_pkg.g_module_failure

Line 770: fnd_log.STRING (fnd_log.level_error,

766:
767: -- Write the appropriate information to the execution report
768: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
769: THEN
770: fnd_log.STRING (fnd_log.level_error,
771: g_pkg_name || '.' || l_api_name,
772: gcs_utility_pkg.g_module_failure
773: || ' '
774: || SQLERRM

Line 783: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

779: END;
780:
781: x_retcode := fnd_api.g_ret_sts_success;
782:
783: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
784: THEN
785: fnd_log.STRING (fnd_log.level_procedure,
786: g_pkg_name || '.' || l_api_name,
787: gcs_utility_pkg.g_module_success

Line 785: fnd_log.STRING (fnd_log.level_procedure,

781: x_retcode := fnd_api.g_ret_sts_success;
782:
783: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
784: THEN
785: fnd_log.STRING (fnd_log.level_procedure,
786: g_pkg_name || '.' || l_api_name,
787: gcs_utility_pkg.g_module_success
788: || ' '
789: || l_api_name

Line 807: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

803:
804: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ERROR : ' || x_errbuf);
805: FND_FILE.NEW_LINE(FND_FILE.LOG);
806: -- Write the appropriate information to the execution report
807: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
808: THEN
809: fnd_log.STRING (fnd_log.level_error,
810: g_pkg_name || '.' || l_api_name,
811: gcs_utility_pkg.g_module_failure

Line 809: fnd_log.STRING (fnd_log.level_error,

805: FND_FILE.NEW_LINE(FND_FILE.LOG);
806: -- Write the appropriate information to the execution report
807: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
808: THEN
809: fnd_log.STRING (fnd_log.level_error,
810: g_pkg_name || '.' || l_api_name,
811: gcs_utility_pkg.g_module_failure
812: || ' '
813: || x_errbuf

Line 828: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

824: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ERROR : ' || x_errbuf);
825: FND_FILE.NEW_LINE(FND_FILE.LOG);
826:
827: -- Write the appropriate information to the execution report
828: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
829: THEN
830: fnd_log.STRING (fnd_log.level_error,
831: g_pkg_name || '.' || l_api_name,
832: gcs_utility_pkg.g_module_failure

Line 830: fnd_log.STRING (fnd_log.level_error,

826:
827: -- Write the appropriate information to the execution report
828: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
829: THEN
830: fnd_log.STRING (fnd_log.level_error,
831: g_pkg_name || '.' || l_api_name,
832: gcs_utility_pkg.g_module_failure
833: || ' '
834: || x_errbuf

Line 873: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

869: BEGIN
870: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER');
871: FND_FILE.NEW_LINE(FND_FILE.LOG);
872:
873: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
874: THEN
875: fnd_log.STRING (fnd_log.level_procedure,
876: g_pkg_name || '.' || l_api_name,
877: gcs_utility_pkg.g_module_enter

Line 875: fnd_log.STRING (fnd_log.level_procedure,

871: FND_FILE.NEW_LINE(FND_FILE.LOG);
872:
873: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
874: THEN
875: fnd_log.STRING (fnd_log.level_procedure,
876: g_pkg_name || '.' || l_api_name,
877: gcs_utility_pkg.g_module_enter
878: || ' p_xns_id = '
879: || p_xns_id

Line 902: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

898: into l_orig_entry_id
899: from gcs_ad_transactions
900: where ad_transaction_id = p_xns_id;
901:
902: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
903: THEN
904: fnd_log.STRING (fnd_log.level_statement,
905: g_pkg_name || '.' || l_api_name,
906: 'Original entry id = ' || l_orig_entry_id

Line 904: fnd_log.STRING (fnd_log.level_statement,

900: where ad_transaction_id = p_xns_id;
901:
902: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
903: THEN
904: fnd_log.STRING (fnd_log.level_statement,
905: g_pkg_name || '.' || l_api_name,
906: 'Original entry id = ' || l_orig_entry_id
907: );
908: END IF;

Line 916: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

912: from gcs_ad_trial_balances
913: where ad_transaction_id = -1
914: and financial_elem_id = 140;
915:
916: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
917: THEN
918: fnd_log.STRING (fnd_log.level_statement,
919: g_pkg_name || '.' || l_api_name,
920: 'Balance type code is ' || l_balance_type_code

Line 918: fnd_log.STRING (fnd_log.level_statement,

914: and financial_elem_id = 140;
915:
916: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
917: THEN
918: fnd_log.STRING (fnd_log.level_statement,
919: g_pkg_name || '.' || l_api_name,
920: 'Balance type code is ' || l_balance_type_code
921: );
922: END IF;

Line 926: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

922: END IF;
923:
924: l_elim_entity_id := get_elim_entity_id(p_consolidation_entity_id => p_consolidation_entity_id);
925:
926: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
927: THEN
928: fnd_log.STRING (fnd_log.level_statement,
929: g_pkg_name || '.' || l_api_name,
930: 'Elimination entity id = ' || l_elim_entity_id

Line 928: fnd_log.STRING (fnd_log.level_statement,

924: l_elim_entity_id := get_elim_entity_id(p_consolidation_entity_id => p_consolidation_entity_id);
925:
926: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
927: THEN
928: fnd_log.STRING (fnd_log.level_statement,
929: g_pkg_name || '.' || l_api_name,
930: 'Elimination entity id = ' || l_elim_entity_id
931: );
932: END IF;

Line 946: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

942: p_balance_type_code => l_balance_type_code,
943: p_entry_type_code => 'AUTOMATIC'
944: );
945:
946: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
947: THEN
948: fnd_log.STRING (fnd_log.level_statement,
949: g_pkg_name || '.' || l_api_name,
950: 'New entry id = ' || l_entry_id

Line 948: fnd_log.STRING (fnd_log.level_statement,

944: );
945:
946: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
947: THEN
948: fnd_log.STRING (fnd_log.level_statement,
949: g_pkg_name || '.' || l_api_name,
950: 'New entry id = ' || l_entry_id
951: );
952: END IF;

Line 959: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

955: RAISE import_header_error;
956: END IF;
957:
958: -- Delete the existing trial balances
959: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
960: THEN
961: fnd_log.STRING (fnd_log.level_statement,
962: g_pkg_name || '.' || l_api_name,
963: 'DELETE FROM GCS_AD_TRIAL_BALANCES'

Line 961: fnd_log.STRING (fnd_log.level_statement,

957:
958: -- Delete the existing trial balances
959: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
960: THEN
961: fnd_log.STRING (fnd_log.level_statement,
962: g_pkg_name || '.' || l_api_name,
963: 'DELETE FROM GCS_AD_TRIAL_BALANCES'
964: || g_nl
965: || 'WHERE AD_TRANSACTION_ID = '

Line 974: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

970: DELETE FROM gcs_ad_trial_balances
971: WHERE ad_transaction_id = p_xns_id;
972:
973: -- Update the new load
974: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
975: THEN
976: fnd_log.STRING (fnd_log.level_statement,
977: g_pkg_name || '.' || l_api_name,
978: 'UPDATE GCS_AD_TRIAL_BALANCES'

Line 976: fnd_log.STRING (fnd_log.level_statement,

972:
973: -- Update the new load
974: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
975: THEN
976: fnd_log.STRING (fnd_log.level_statement,
977: g_pkg_name || '.' || l_api_name,
978: 'UPDATE GCS_AD_TRIAL_BALANCES'
979: || g_nl
980: || 'SET ad_transaction_id = '

Line 1006: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

1002: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Generate trial balance XML error : ' || SQLERRM);
1003: FND_FILE.NEW_LINE(FND_FILE.LOG);
1004:
1005: -- Write the appropriate information to the execution report
1006: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1007: THEN
1008: fnd_log.STRING (fnd_log.level_error,
1009: g_pkg_name || '.' || l_api_name,
1010: gcs_utility_pkg.g_module_failure

Line 1008: fnd_log.STRING (fnd_log.level_error,

1004:
1005: -- Write the appropriate information to the execution report
1006: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1007: THEN
1008: fnd_log.STRING (fnd_log.level_error,
1009: g_pkg_name || '.' || l_api_name,
1010: gcs_utility_pkg.g_module_failure
1011: || ' XML Gen failed: '
1012: || SQLERRM

Line 1032: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1028: IF (x_retcode = '2') THEN
1029: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' AD_ENGINE FAILED: ' || x_errbuf);
1030: FND_FILE.NEW_LINE(FND_FILE.LOG);
1031: -- Write the appropriate information to the execution report
1032: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.STRING (fnd_log.level_procedure,
1035: g_pkg_name || '.' || l_api_name,
1036: gcs_utility_pkg.g_module_failure

Line 1034: fnd_log.STRING (fnd_log.level_procedure,

1030: FND_FILE.NEW_LINE(FND_FILE.LOG);
1031: -- Write the appropriate information to the execution report
1032: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1033: THEN
1034: fnd_log.STRING (fnd_log.level_procedure,
1035: g_pkg_name || '.' || l_api_name,
1036: gcs_utility_pkg.g_module_failure
1037: || ' AD_ENGINE failed '
1038: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1056: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

1052: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Generate entry XML error : ' || SQLERRM);
1053: FND_FILE.NEW_LINE(FND_FILE.LOG);
1054:
1055: -- Write the appropriate information to the execution report
1056: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1057: THEN
1058: fnd_log.STRING (fnd_log.level_error,
1059: g_pkg_name || '.' || l_api_name,
1060: gcs_utility_pkg.g_module_failure

Line 1058: fnd_log.STRING (fnd_log.level_error,

1054:
1055: -- Write the appropriate information to the execution report
1056: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1057: THEN
1058: fnd_log.STRING (fnd_log.level_error,
1059: g_pkg_name || '.' || l_api_name,
1060: gcs_utility_pkg.g_module_failure
1061: || ' XML Gen failed: '
1062: || SQLERRM

Line 1107: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

1103: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Raise impact error : ' || SQLERRM);
1104: FND_FILE.NEW_LINE(FND_FILE.LOG);
1105:
1106: -- Write the appropriate information to the execution report
1107: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1108: THEN
1109: fnd_log.STRING (fnd_log.level_error,
1110: g_pkg_name || '.' || l_api_name,
1111: gcs_utility_pkg.g_module_failure

Line 1109: fnd_log.STRING (fnd_log.level_error,

1105:
1106: -- Write the appropriate information to the execution report
1107: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1108: THEN
1109: fnd_log.STRING (fnd_log.level_error,
1110: g_pkg_name || '.' || l_api_name,
1111: gcs_utility_pkg.g_module_failure
1112: || ' '
1113: || SQLERRM

Line 1125: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1121:
1122: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT');
1123: FND_FILE.NEW_LINE(FND_FILE.LOG);
1124: -- Write the appropriate information to the execution report
1125: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1126: THEN
1127: fnd_log.STRING (fnd_log.level_procedure,
1128: g_pkg_name || '.' || l_api_name,
1129: gcs_utility_pkg.g_module_success

Line 1127: fnd_log.STRING (fnd_log.level_procedure,

1123: FND_FILE.NEW_LINE(FND_FILE.LOG);
1124: -- Write the appropriate information to the execution report
1125: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1126: THEN
1127: fnd_log.STRING (fnd_log.level_procedure,
1128: g_pkg_name || '.' || l_api_name,
1129: gcs_utility_pkg.g_module_success
1130: || ' '
1131: || l_api_name

Line 1149: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

1145: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ERROR : ' || x_errbuf);
1146: FND_FILE.NEW_LINE(FND_FILE.LOG);
1147:
1148: -- Write the appropriate information to the execution report
1149: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1150: THEN
1151: fnd_log.STRING (fnd_log.level_error,
1152: g_pkg_name || '.' || l_api_name,
1153: gcs_utility_pkg.g_module_failure

Line 1151: fnd_log.STRING (fnd_log.level_error,

1147:
1148: -- Write the appropriate information to the execution report
1149: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1150: THEN
1151: fnd_log.STRING (fnd_log.level_error,
1152: g_pkg_name || '.' || l_api_name,
1153: gcs_utility_pkg.g_module_failure
1154: || ' '
1155: || x_errbuf

Line 1190: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1186: l_event_key VARCHAR2 (100) := NULL;
1187: l_parameter_list wf_parameter_list_t;
1188: l_api_name VARCHAR2 (30) := 'UNDO_ELIM_ADJ';
1189: BEGIN
1190: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1191: THEN
1192: fnd_log.STRING (fnd_log.level_procedure,
1193: g_pkg_name || '.' || l_api_name,
1194: gcs_utility_pkg.g_module_enter

Line 1192: fnd_log.STRING (fnd_log.level_procedure,

1188: l_api_name VARCHAR2 (30) := 'UNDO_ELIM_ADJ';
1189: BEGIN
1190: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1191: THEN
1192: fnd_log.STRING (fnd_log.level_procedure,
1193: g_pkg_name || '.' || l_api_name,
1194: gcs_utility_pkg.g_module_enter
1195: || ' p_xns_id = '
1196: || p_xns_id

Line 1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1203: fetch undo_c into l_processed_flag, l_entry_id;
1204: close undo_c;
1205:
1206: if (l_processed_flag = 'Y') then
1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1208: THEN
1209: fnd_log.STRING (fnd_log.level_statement,
1210: g_pkg_name || '.' || l_api_name,
1211: 'UPDATE gcs_entry_headers set disabled_flag = ''Y'' WHERE entry_id = '

Line 1209: fnd_log.STRING (fnd_log.level_statement,

1205:
1206: if (l_processed_flag = 'Y') then
1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1208: THEN
1209: fnd_log.STRING (fnd_log.level_statement,
1210: g_pkg_name || '.' || l_api_name,
1211: 'UPDATE gcs_entry_headers set disabled_flag = ''Y'' WHERE entry_id = '
1212: || l_entry_id
1213: );

Line 1216: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1212: || l_entry_id
1213: );
1214: END IF;
1215: update gcs_entry_headers set disabled_flag = 'Y' where entry_id = l_entry_id;
1216: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1217: THEN
1218: fnd_log.STRING (fnd_log.level_statement,
1219: g_pkg_name || '.' || l_api_name,
1220: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '

Line 1218: fnd_log.STRING (fnd_log.level_statement,

1214: END IF;
1215: update gcs_entry_headers set disabled_flag = 'Y' where entry_id = l_entry_id;
1216: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1217: THEN
1218: fnd_log.STRING (fnd_log.level_statement,
1219: g_pkg_name || '.' || l_api_name,
1220: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
1221: || p_xns_id
1222: );

Line 1245: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1241: null;
1242: END;
1243:
1244: elsif (l_processed_flag = 'N' and l_entry_id is not null) then
1245: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1246: THEN
1247: fnd_log.STRING (fnd_log.level_statement,
1248: g_pkg_name || '.' || l_api_name,
1249: 'DELETE FROM gcs_entry_headers WHERE entry_id = '

Line 1247: fnd_log.STRING (fnd_log.level_statement,

1243:
1244: elsif (l_processed_flag = 'N' and l_entry_id is not null) then
1245: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1246: THEN
1247: fnd_log.STRING (fnd_log.level_statement,
1248: g_pkg_name || '.' || l_api_name,
1249: 'DELETE FROM gcs_entry_headers WHERE entry_id = '
1250: || l_entry_id
1251: );

Line 1254: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1250: || l_entry_id
1251: );
1252: END IF;
1253: delete from gcs_entry_headers where entry_id = l_entry_id;
1254: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1255: THEN
1256: fnd_log.STRING (fnd_log.level_statement,
1257: g_pkg_name || '.' || l_api_name,
1258: 'DELETE FROM gcs_entry_lines WHERE entry_id = '

Line 1256: fnd_log.STRING (fnd_log.level_statement,

1252: END IF;
1253: delete from gcs_entry_headers where entry_id = l_entry_id;
1254: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1255: THEN
1256: fnd_log.STRING (fnd_log.level_statement,
1257: g_pkg_name || '.' || l_api_name,
1258: 'DELETE FROM gcs_entry_lines WHERE entry_id = '
1259: || l_entry_id
1260: );

Line 1263: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1259: || l_entry_id
1260: );
1261: END IF;
1262: delete from gcs_entry_lines where entry_id = l_entry_id;
1263: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1264: THEN
1265: fnd_log.STRING (fnd_log.level_statement,
1266: g_pkg_name || '.' || l_api_name,
1267: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '

Line 1265: fnd_log.STRING (fnd_log.level_statement,

1261: END IF;
1262: delete from gcs_entry_lines where entry_id = l_entry_id;
1263: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1264: THEN
1265: fnd_log.STRING (fnd_log.level_statement,
1266: g_pkg_name || '.' || l_api_name,
1267: 'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
1268: || p_xns_id
1269: );

Line 1273: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

1269: );
1270: END IF;
1271: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;
1272: ELSE
1273: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1274: THEN
1275: fnd_log.STRING (fnd_log.level_statement,
1276: g_pkg_name || '.' || l_api_name,
1277: 'UPDATE gcs_ad_transactions set request_id = null WHERE ad_transaction_id = '

Line 1275: fnd_log.STRING (fnd_log.level_statement,

1271: update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;
1272: ELSE
1273: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
1274: THEN
1275: fnd_log.STRING (fnd_log.level_statement,
1276: g_pkg_name || '.' || l_api_name,
1277: 'UPDATE gcs_ad_transactions set request_id = null WHERE ad_transaction_id = '
1278: || p_xns_id
1279: );

Line 1284: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

1280: END IF;
1281: update gcs_ad_transactions set request_id = null where ad_transaction_id = p_xns_id;
1282: end if;
1283:
1284: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1285: THEN
1286: fnd_log.STRING (fnd_log.level_procedure,
1287: g_pkg_name || '.' || l_api_name,
1288: gcs_utility_pkg.g_module_success

Line 1286: fnd_log.STRING (fnd_log.level_procedure,

1282: end if;
1283:
1284: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1285: THEN
1286: fnd_log.STRING (fnd_log.level_procedure,
1287: g_pkg_name || '.' || l_api_name,
1288: gcs_utility_pkg.g_module_success
1289: || ' '
1290: || l_api_name

Line 1302: IF fnd_log.g_current_runtime_level <= fnd_log.level_error

1298: x_errbuf := SQLERRM;
1299: x_retcode := fnd_api.g_ret_sts_unexp_error;
1300:
1301: -- Write the appropriate information to the execution report
1302: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1303: THEN
1304: fnd_log.STRING (fnd_log.level_error,
1305: g_pkg_name || '.' || l_api_name,
1306: gcs_utility_pkg.g_module_failure

Line 1304: fnd_log.STRING (fnd_log.level_error,

1300:
1301: -- Write the appropriate information to the execution report
1302: IF fnd_log.g_current_runtime_level <= fnd_log.level_error
1303: THEN
1304: fnd_log.STRING (fnd_log.level_error,
1305: g_pkg_name || '.' || l_api_name,
1306: gcs_utility_pkg.g_module_failure
1307: || ' '
1308: || x_errbuf