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_FILE

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER');

90: l_retcode VARCHAR2 (1);
91: l_processed_entry_flag VARCHAR2 (1);
92: l_api_name VARCHAR2 (30) := 'IMPORT_HEADER';
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

Line 95: FND_FILE.NEW_LINE(FND_FILE.LOG);

91: l_processed_entry_flag VARCHAR2 (1);
92: l_api_name VARCHAR2 (30) := 'IMPORT_HEADER';
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,

Line 157: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' CREATE ENTRY');

153:
154:
155: IF l_entry_id IS NULL
156: THEN
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

Line 158: FND_FILE.NEW_LINE(FND_FILE.LOG);

154:
155: IF l_entry_id IS NULL
156: THEN
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

Line 231: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' UPDATE EXISTING ENTRY');

227: WHERE gcerd.entry_id = l_entry_id);
228: EXCEPTION
229: WHEN NO_DATA_FOUND
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

Line 232: FND_FILE.NEW_LINE(FND_FILE.LOG);

228: EXCEPTION
229: WHEN NO_DATA_FOUND
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,

Line 293: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' DISABLE EXISTING ENTRY AND CREATE A NEW ONE');

289: -- case 3: update an existing entry which has been process before
290: -- we disable the existing entry and create a new one
291: IF l_processed_entry_flag = 'Y'
292: THEN
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

Line 294: FND_FILE.NEW_LINE(FND_FILE.LOG);

290: -- we disable the existing entry and create a new one
291: IF l_processed_entry_flag = 'Y'
292: THEN
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

Line 382: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT');

378: WHERE ad_transaction_id = p_xns_id;
379:
380: END IF; -- end of case 3
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

Line 383: FND_FILE.NEW_LINE(FND_FILE.LOG);

379:
380: END IF; -- end of case 3
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,

Line 404: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || SQLERRM);

400: WHEN NO_DATA_FOUND
401: THEN
402: fnd_message.set_name ('GCS', 'GCS_AD_TB_INVALID_ID');
403:
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

Line 405: FND_FILE.NEW_LINE(FND_FILE.LOG);

401: THEN
402: fnd_message.set_name ('GCS', 'GCS_AD_TB_INVALID_ID');
403:
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

Line 424: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || SQLERRM);

420: WHEN OTHERS
421: THEN
422: fnd_message.set_name ('GCS', SQLERRM);
423:
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

Line 425: FND_FILE.NEW_LINE(FND_FILE.LOG);

421: THEN
422: fnd_message.set_name ('GCS', SQLERRM);
423:
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

Line 511: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER');

507: l_basic_acct_type_version NUMBER :=
508: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
509: BEGIN
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

Line 512: FND_FILE.NEW_LINE(FND_FILE.LOG);

508: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
509: BEGIN
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,

Line 704: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling entry XML Gen ');

700: last_update_date = sysdate
701: WHERE ad_transaction_id = p_xns_id;
702: /*
703: BEGIN
704: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling entry XML Gen ');
705: FND_FILE.NEW_LINE(FND_FILE.LOG);
706:
707: gcs_xml_gen_pkg.generate_entry_xml( p_entry_id => l_entry_id,
708: p_category_code => 'ACQ_DISP',

Line 705: FND_FILE.NEW_LINE(FND_FILE.LOG);

701: WHERE ad_transaction_id = p_xns_id;
702: /*
703: BEGIN
704: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling entry XML Gen ');
705: FND_FILE.NEW_LINE(FND_FILE.LOG);
706:
707: gcs_xml_gen_pkg.generate_entry_xml( p_entry_id => l_entry_id,
708: p_category_code => 'ACQ_DISP',
709: p_cons_rule_flag => 'N');

Line 713: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Generate XML error : ' || SQLERRM);

709: p_cons_rule_flag => 'N');
710: EXCEPTION
711: WHEN OTHERS
712: THEN
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

Line 714: FND_FILE.NEW_LINE(FND_FILE.LOG);

710: EXCEPTION
711: WHEN OTHERS
712: THEN
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

Line 752: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' RAISE WF_EVENT');

748: wf_event.addparametertolist( p_name => 'ORIG_ENTRY_ID',
749: p_value => l_orig_entry_id,
750: p_parameterlist => l_parameter_list
751: );
752: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' RAISE WF_EVENT');
753: FND_FILE.NEW_LINE(FND_FILE.LOG);
754:
755: wf_event.RAISE( p_event_name => l_event_name,
756: p_event_key => l_event_key,

Line 753: FND_FILE.NEW_LINE(FND_FILE.LOG);

749: p_value => l_orig_entry_id,
750: p_parameterlist => l_parameter_list
751: );
752: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' RAISE WF_EVENT');
753: FND_FILE.NEW_LINE(FND_FILE.LOG);
754:
755: wf_event.RAISE( p_event_name => l_event_name,
756: p_event_key => l_event_key,
757: p_parameters => l_parameter_list

Line 764: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Raise impact error : ' || SQLERRM);

760:
761: EXCEPTION
762: WHEN OTHERS
763: THEN
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

Line 765: FND_FILE.NEW_LINE(FND_FILE.LOG);

761: EXCEPTION
762: WHEN OTHERS
763: THEN
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

Line 795: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT');

791: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
792: );
793: END IF;
794:
795: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT');
796: FND_FILE.NEW_LINE(FND_FILE.LOG);
797:
798: EXCEPTION
799: WHEN import_header_error

Line 796: FND_FILE.NEW_LINE(FND_FILE.LOG);

792: );
793: END IF;
794:
795: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT');
796: FND_FILE.NEW_LINE(FND_FILE.LOG);
797:
798: EXCEPTION
799: WHEN import_header_error
800: THEN

Line 804: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ERROR : ' || x_errbuf);

800: THEN
801: x_errbuf := fnd_message.get;
802: x_retcode := '2';
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

Line 805: FND_FILE.NEW_LINE(FND_FILE.LOG);

801: x_errbuf := fnd_message.get;
802: x_retcode := '2';
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,

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ERROR : ' || x_errbuf);

820: fnd_message.set_name ('GCS', SQLERRM);
821: x_errbuf := fnd_message.get;
822: x_retcode := '2';
823:
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

Line 825: FND_FILE.NEW_LINE(FND_FILE.LOG);

821: x_errbuf := fnd_message.get;
822: x_retcode := '2';
823:
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

Line 870: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ENTER');

866: l_elim_entity_id NUMBER;
867: l_balance_type_code VARCHAR2 (30);
868: p_xns_id NUMBER(15) := TO_NUMBER(p_xns_id_char) ;
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

Line 871: FND_FILE.NEW_LINE(FND_FILE.LOG);

867: l_balance_type_code VARCHAR2 (30);
868: p_xns_id NUMBER(15) := TO_NUMBER(p_xns_id_char) ;
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,

Line 994: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling trial balance XML Gen ');

990: last_update_date = sysdate
991: WHERE ad_transaction_id = -1;
992: /*
993: BEGIN
994: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling trial balance XML Gen ');
995: FND_FILE.NEW_LINE(FND_FILE.LOG);
996:
997: gcs_xml_gen_pkg.generate_ad_xml( p_ad_transaction_id => p_xns_id);
998:

Line 995: FND_FILE.NEW_LINE(FND_FILE.LOG);

991: WHERE ad_transaction_id = -1;
992: /*
993: BEGIN
994: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling trial balance XML Gen ');
995: FND_FILE.NEW_LINE(FND_FILE.LOG);
996:
997: gcs_xml_gen_pkg.generate_ad_xml( p_ad_transaction_id => p_xns_id);
998:
999: EXCEPTION

Line 1002: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Generate trial balance XML error : ' || SQLERRM);

998:
999: EXCEPTION
1000: WHEN OTHERS
1001: THEN
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

Line 1003: FND_FILE.NEW_LINE(FND_FILE.LOG);

999: EXCEPTION
1000: WHEN OTHERS
1001: THEN
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

Line 1020: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' CALL AD_ENGINE');

1016: END IF;
1017: END;
1018: */
1019: -- invoke ad engine
1020: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' CALL AD_ENGINE');
1021: FND_FILE.NEW_LINE(FND_FILE.LOG);
1022:
1023: gcs_ad_engine.process_transaction (errbuf => x_errbuf,
1024: retcode => x_retcode,

Line 1021: FND_FILE.NEW_LINE(FND_FILE.LOG);

1017: END;
1018: */
1019: -- invoke ad engine
1020: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' CALL AD_ENGINE');
1021: FND_FILE.NEW_LINE(FND_FILE.LOG);
1022:
1023: gcs_ad_engine.process_transaction (errbuf => x_errbuf,
1024: retcode => x_retcode,
1025: p_transaction_id => p_xns_id

Line 1029: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' AD_ENGINE FAILED: ' || x_errbuf);

1025: p_transaction_id => p_xns_id
1026: );
1027: -- bug fix 3870797
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

Line 1030: FND_FILE.NEW_LINE(FND_FILE.LOG);

1026: );
1027: -- bug fix 3870797
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,

Line 1043: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling entry XML Gen ');

1039: );
1040: END IF;
1041: ELSE
1042: /* BEGIN
1043: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling entry XML Gen ');
1044: FND_FILE.NEW_LINE(FND_FILE.LOG);
1045:
1046: gcs_xml_gen_pkg.generate_entry_xml( p_entry_id => l_entry_id,
1047: p_category_code => 'ACQ_DISP',

Line 1044: FND_FILE.NEW_LINE(FND_FILE.LOG);

1040: END IF;
1041: ELSE
1042: /* BEGIN
1043: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Calling entry XML Gen ');
1044: FND_FILE.NEW_LINE(FND_FILE.LOG);
1045:
1046: gcs_xml_gen_pkg.generate_entry_xml( p_entry_id => l_entry_id,
1047: p_category_code => 'ACQ_DISP',
1048: p_cons_rule_flag => 'N');

Line 1052: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Generate entry XML error : ' || SQLERRM);

1048: p_cons_rule_flag => 'N');
1049: EXCEPTION
1050: WHEN OTHERS
1051: THEN
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

Line 1053: FND_FILE.NEW_LINE(FND_FILE.LOG);

1049: EXCEPTION
1050: WHEN OTHERS
1051: THEN
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

Line 1070: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Raise Impact Analysis Event');

1066: END IF;
1067: END;*/
1068:
1069: BEGIN
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Raise Impact Analysis Event');
1071: FND_FILE.NEW_LINE(FND_FILE.LOG);
1072:
1073: IF (l_orig_entry_id <> l_entry_id) THEN
1074:

Line 1071: FND_FILE.NEW_LINE(FND_FILE.LOG);

1067: END;*/
1068:
1069: BEGIN
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Raise Impact Analysis Event');
1071: FND_FILE.NEW_LINE(FND_FILE.LOG);
1072:
1073: IF (l_orig_entry_id <> l_entry_id) THEN
1074:
1075: IF (l_orig_entry_id IS NULL) THEN

Line 1103: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' Raise impact error : ' || SQLERRM);

1099:
1100: EXCEPTION
1101: WHEN OTHERS
1102: THEN
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

Line 1104: FND_FILE.NEW_LINE(FND_FILE.LOG);

1100: EXCEPTION
1101: WHEN OTHERS
1102: THEN
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

Line 1122: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' EXIT');

1118: END;
1119:
1120: x_retcode := fnd_api.g_ret_sts_success;
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

Line 1123: FND_FILE.NEW_LINE(FND_FILE.LOG);

1119:
1120: x_retcode := fnd_api.g_ret_sts_success;
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,

Line 1145: FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' ERROR : ' || x_errbuf);

1141: fnd_message.set_name ('GCS', SQLERRM);
1142: x_errbuf := fnd_message.get;
1143: x_retcode := '2';
1144:
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

Line 1146: FND_FILE.NEW_LINE(FND_FILE.LOG);

1142: x_errbuf := fnd_message.get;
1143: x_retcode := '2';
1144:
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