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_ENTRY_PKG dependencies on FND_LOG

Line 99: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

95: l_start_cal_period_id := to_number(p_start_cal_period_id);
96:
97: SAVEPOINT gcs_import_hier_grp_start;
98:
99: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
100: fnd_log.STRING(fnd_log.level_procedure,
101: g_pkg_name || '.' || l_api_name,
102: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
103: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 100: fnd_log.STRING(fnd_log.level_procedure,

96:
97: SAVEPOINT gcs_import_hier_grp_start;
98:
99: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
100: fnd_log.STRING(fnd_log.level_procedure,
101: g_pkg_name || '.' || l_api_name,
102: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
103: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
104: END IF;

Line 106: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

102: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
103: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
104: END IF;
105:
106: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
107: fnd_log.STRING(fnd_log.level_statement,
108: g_pkg_name || '.' || l_api_name,
109: 'SELECT net_to_re_flag' || g_nl ||
110: 'INTO l_net_to_re_flag' || g_nl ||

Line 107: fnd_log.STRING(fnd_log.level_statement,

103: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
104: END IF;
105:
106: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
107: fnd_log.STRING(fnd_log.level_statement,
108: g_pkg_name || '.' || l_api_name,
109: 'SELECT net_to_re_flag' || g_nl ||
110: 'INTO l_net_to_re_flag' || g_nl ||
111: 'FROM gcs_categories_b' || g_nl ||

Line 120: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

116: INTO l_net_to_re_flag
117: FROM gcs_categories_b
118: WHERE category_code = p_category_code;
119:
120: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
121: fnd_log.STRING(fnd_log.level_procedure,
122: g_pkg_name || '.' || l_api_name,
123: 'SELECT CASE fcpa_start_year.number_assign_value
124: WHEN NVL (fcpa_end_year.number_assign_value, 0)

Line 121: fnd_log.STRING(fnd_log.level_procedure,

117: FROM gcs_categories_b
118: WHERE category_code = p_category_code;
119:
120: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
121: fnd_log.STRING(fnd_log.level_procedure,
122: g_pkg_name || '.' || l_api_name,
123: 'SELECT CASE fcpa_start_year.number_assign_value
124: WHEN NVL (fcpa_end_year.number_assign_value, 0)
125: THEN NULL

Line 309: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

305: USING l_entry_id(l_counter),
306: p_entry_id
307: ;
308:
309: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
310: fnd_log.STRING(fnd_log.level_procedure,
311: g_pkg_name || '.' || l_api_name,
312: 'SELECT decode(start_cal_period_id, end_cal_period_id, ''ONE_TIME'',
313: ''RECURRING''), year_to_apply_re, hierarchy_id, balance_type_code,

Line 310: fnd_log.STRING(fnd_log.level_procedure,

306: p_entry_id
307: ;
308:
309: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
310: fnd_log.STRING(fnd_log.level_procedure,
311: g_pkg_name || '.' || l_api_name,
312: 'SELECT decode(start_cal_period_id, end_cal_period_id, ''ONE_TIME'',
313: ''RECURRING''), year_to_apply_re, hierarchy_id, balance_type_code,
314: entity_id, NVL (minimum_accountable_unit, POWER (10, -PRECISION))' || g_nl ||

Line 422: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

418: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
419: g_pkg_name || '.' || l_api_name ||
420: ' ERROR : ' || SQLERRM);
421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
422: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
423: fnd_log.STRING(fnd_log.level_error,
424: g_pkg_name || '.' || l_api_name,
425: ' wf_event.raise failed ' || ' ' ||
426: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 423: fnd_log.STRING(fnd_log.level_error,

419: g_pkg_name || '.' || l_api_name ||
420: ' ERROR : ' || SQLERRM);
421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
422: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
423: fnd_log.STRING(fnd_log.level_error,
424: g_pkg_name || '.' || l_api_name,
425: ' wf_event.raise failed ' || ' ' ||
426: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
427: END IF;

Line 439: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

435:
436: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
437:
438: -- Write the appropriate information to the execution report
439: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
440: fnd_log.STRING(fnd_log.level_procedure,
441: g_pkg_name || '.' || l_api_name,
442: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
443: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 440: fnd_log.STRING(fnd_log.level_procedure,

436: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
437:
438: -- Write the appropriate information to the execution report
439: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
440: fnd_log.STRING(fnd_log.level_procedure,
441: g_pkg_name || '.' || l_api_name,
442: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
443: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
444: END IF;

Line 453: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

449: ROLLBACK TO gcs_import_hier_grp_start;
450: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
451: -- Write the appropriate information to the execution report
452:
453: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
454: fnd_log.STRING(fnd_log.level_error,
455: g_pkg_name || '.' || l_api_name,
456: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
457: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 454: fnd_log.STRING(fnd_log.level_error,

450: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
451: -- Write the appropriate information to the execution report
452:
453: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
454: fnd_log.STRING(fnd_log.level_error,
455: g_pkg_name || '.' || l_api_name,
456: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
457: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
458: fnd_log.STRING(fnd_log.level_error,

Line 458: fnd_log.STRING(fnd_log.level_error,

454: fnd_log.STRING(fnd_log.level_error,
455: g_pkg_name || '.' || l_api_name,
456: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
457: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
458: fnd_log.STRING(fnd_log.level_error,
459: g_pkg_name || '.' || l_api_name,
460: gcs_utility_pkg.g_module_failure || ' ' ||
461: l_api_name || '() ' ||
462: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 507: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

503: l_start_cal_period_id := to_number(p_start_cal_period_id);
504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
505: g_pkg_name || '.' || l_api_name || ' ENTER');
506: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
507: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
508: fnd_log.STRING(fnd_log.level_procedure,
509: g_pkg_name || '.' || l_api_name,
510: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
511: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 508: fnd_log.STRING(fnd_log.level_procedure,

504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
505: g_pkg_name || '.' || l_api_name || ' ENTER');
506: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
507: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
508: fnd_log.STRING(fnd_log.level_procedure,
509: g_pkg_name || '.' || l_api_name,
510: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
511: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
512: END IF;

Line 517: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

513: -- In case of an error, we will roll back to this point in time.
514: SAVEPOINT gcs_entry_upload_headers_start;
515: -- Bug fix 3805520
516: -- only when end-start cross year end boundary
517: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
518: fnd_log.STRING(fnd_log.level_procedure,
519: g_pkg_name || '.' || l_api_name,
520: 'SELECT CASE fcpa_start_year.number_assign_value
521: WHEN NVL (fcpa_end_year.number_assign_value, 0)

Line 518: fnd_log.STRING(fnd_log.level_procedure,

514: SAVEPOINT gcs_entry_upload_headers_start;
515: -- Bug fix 3805520
516: -- only when end-start cross year end boundary
517: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
518: fnd_log.STRING(fnd_log.level_procedure,
519: g_pkg_name || '.' || l_api_name,
520: 'SELECT CASE fcpa_start_year.number_assign_value
521: WHEN NVL (fcpa_end_year.number_assign_value, 0)
522: THEN NULL

Line 543: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

539: AND fcpa_end_year.version_id(+) = fcpa_start_year.version_id');
540: END IF;
541: /***
542: -- determine the balance type
543: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
544: fnd_log.STRING(fnd_log.level_statement,
545: g_pkg_name || '.' || l_api_name,
546: 'SELECT DECODE (COUNT (entry_id), 0, ''ACTUAL'', ''ADB'')'
547: || g_nl

Line 544: fnd_log.STRING(fnd_log.level_statement,

540: END IF;
541: /***
542: -- determine the balance type
543: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN
544: fnd_log.STRING(fnd_log.level_statement,
545: g_pkg_name || '.' || l_api_name,
546: 'SELECT DECODE (COUNT (entry_id), 0, ''ACTUAL'', ''ADB'')'
547: || g_nl
548: || 'INTO l_balance_type_code'

Line 639: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

635: FROM gcs_cons_eng_run_dtls gcerd
636: WHERE gcerd.entry_id = p_entry_id);
637: EXCEPTION
638: WHEN NO_DATA_FOUND THEN
639: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
640: fnd_log.STRING(fnd_log.level_error,
641: g_pkg_name || '.' || l_api_name,
642: 'UPDATE gcs_entry_headers' || g_nl ||
643: 'SET balance_type_code = ' ||

Line 640: fnd_log.STRING(fnd_log.level_error,

636: WHERE gcerd.entry_id = p_entry_id);
637: EXCEPTION
638: WHEN NO_DATA_FOUND THEN
639: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
640: fnd_log.STRING(fnd_log.level_error,
641: g_pkg_name || '.' || l_api_name,
642: 'UPDATE gcs_entry_headers' || g_nl ||
643: 'SET balance_type_code = ' ||
644: p_balance_type_code || ',' || g_nl ||

Line 677: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

673: last_update_date = SYSDATE,
674: last_updated_by = fnd_global.user_id
675: WHERE entry_id = p_entry_id;
676: -- delete old entry lines and flag new lines as loaded
677: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
678: fnd_log.STRING(fnd_log.level_procedure,
679: g_pkg_name || '.' || l_api_name,
680: 'DELETE FROM gcs_entry_lines' || g_nl ||
681: 'WHERE entry_id = ' || p_entry_id);

Line 678: fnd_log.STRING(fnd_log.level_procedure,

674: last_updated_by = fnd_global.user_id
675: WHERE entry_id = p_entry_id;
676: -- delete old entry lines and flag new lines as loaded
677: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
678: fnd_log.STRING(fnd_log.level_procedure,
679: g_pkg_name || '.' || l_api_name,
680: 'DELETE FROM gcs_entry_lines' || g_nl ||
681: 'WHERE entry_id = ' || p_entry_id);
682: END IF;

Line 684: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

680: 'DELETE FROM gcs_entry_lines' || g_nl ||
681: 'WHERE entry_id = ' || p_entry_id);
682: END IF;
683: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
684: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
685: fnd_log.STRING(fnd_log.level_procedure,
686: g_pkg_name || '.' || l_api_name,
687: 'UPDATE gcs_entry_lines' || g_nl ||
688: 'set entry_id = ' || p_entry_id || g_nl ||

Line 685: fnd_log.STRING(fnd_log.level_procedure,

681: 'WHERE entry_id = ' || p_entry_id);
682: END IF;
683: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
684: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
685: fnd_log.STRING(fnd_log.level_procedure,
686: g_pkg_name || '.' || l_api_name,
687: 'UPDATE gcs_entry_lines' || g_nl ||
688: 'set entry_id = ' || p_entry_id || g_nl ||
689: 'WHERE entry_id = ' || p_new_entry_id);

Line 701: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

697: END IF; -- end of case 2
698: -- case 3: update an existing entry which has been process before
699: -- we disable the existing entry and create a new one
700: IF l_processed_entry_flag = 'Y' THEN
701: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
702: fnd_log.STRING(fnd_log.level_procedure,
703: g_pkg_name || '.' || l_api_name,
704: 'UPDATE gcs_entry_headers' || g_nl ||
705: 'SET disabled_flag = ''Y'', entry_name = substr(entry_name, 0, 55) || '' OLD -'' || ' ||

Line 702: fnd_log.STRING(fnd_log.level_procedure,

698: -- case 3: update an existing entry which has been process before
699: -- we disable the existing entry and create a new one
700: IF l_processed_entry_flag = 'Y' THEN
701: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
702: fnd_log.STRING(fnd_log.level_procedure,
703: g_pkg_name || '.' || l_api_name,
704: 'UPDATE gcs_entry_headers' || g_nl ||
705: 'SET disabled_flag = ''Y'', entry_name = substr(entry_name, 0, 55) || '' OLD -'' || ' ||
706: p_new_entry_id || g_nl || 'WHERE entry_id = ' ||

Line 735: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

731: p_entry_lines_id := p_new_entry_id;
732: p_orig_entry_id := p_entry_id;
733: END IF; -- end of case 3
734: -- Write the appropriate information to the execution report
735: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
736: fnd_log.STRING(fnd_log.level_procedure,
737: g_pkg_name || '.' || l_api_name,
738: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
739: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 736: fnd_log.STRING(fnd_log.level_procedure,

732: p_orig_entry_id := p_entry_id;
733: END IF; -- end of case 3
734: -- Write the appropriate information to the execution report
735: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
736: fnd_log.STRING(fnd_log.level_procedure,
737: g_pkg_name || '.' || l_api_name,
738: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
739: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
740: END IF;

Line 749: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

745: WHEN OTHERS THEN
746: ROLLBACK TO gcs_entry_upload_headers_start;
747: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
748: -- Write the appropriate information to the execution report
749: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
750: fnd_log.STRING(fnd_log.level_error,
751: g_pkg_name || '.' || l_api_name,
752: gcs_utility_pkg.g_module_failure || ' ' ||
753: l_api_name || '() ' ||

Line 750: fnd_log.STRING(fnd_log.level_error,

746: ROLLBACK TO gcs_entry_upload_headers_start;
747: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
748: -- Write the appropriate information to the execution report
749: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
750: fnd_log.STRING(fnd_log.level_error,
751: g_pkg_name || '.' || l_api_name,
752: gcs_utility_pkg.g_module_failure || ' ' ||
753: l_api_name || '() ' ||
754: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 786: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

782: l_entry_description VARCHAR2(240);
783: l_temp VARCHAR2(1);
784: l_api_name VARCHAR2(30) := 'GET_ENTRY_HEADER';
785: BEGIN
786: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
787: fnd_log.STRING(fnd_log.level_procedure,
788: g_pkg_name || '.' || l_api_name,
789: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
790: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 787: fnd_log.STRING(fnd_log.level_procedure,

783: l_temp VARCHAR2(1);
784: l_api_name VARCHAR2(30) := 'GET_ENTRY_HEADER';
785: BEGIN
786: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
787: fnd_log.STRING(fnd_log.level_procedure,
788: g_pkg_name || '.' || l_api_name,
789: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
790: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
791: END IF;

Line 792: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

788: g_pkg_name || '.' || l_api_name,
789: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
790: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
791: END IF;
792: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
793: fnd_log.STRING(fnd_log.level_procedure,
794: g_pkg_name || '.' || l_api_name,
795: 'SELECT entity_name INTO l_entity_name ' ||
796: ' FROM fem_entities_vl WHERE entity_id = ' ||

Line 793: fnd_log.STRING(fnd_log.level_procedure,

789: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
790: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
791: END IF;
792: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
793: fnd_log.STRING(fnd_log.level_procedure,
794: g_pkg_name || '.' || l_api_name,
795: 'SELECT entity_name INTO l_entity_name ' ||
796: ' FROM fem_entities_vl WHERE entity_id = ' ||
797: p_entity_id);

Line 817: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

813: ELSIF (p_category_code = 'AGGREGATION') THEN
814: l_entry_description := 'Aggregation of ' || l_entity_name;
815: ELSIF (p_rule_id is not null) THEN
816: BEGIN
817: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
818: fnd_log.STRING(fnd_log.level_procedure,
819: g_pkg_name || '.' || l_api_name,
820: 'SELECT rule_name INTO l_rule_name ' ||
821: ' FROM gcs_elim_rules_vl WHERE rule_id = ' ||

Line 818: fnd_log.STRING(fnd_log.level_procedure,

814: l_entry_description := 'Aggregation of ' || l_entity_name;
815: ELSIF (p_rule_id is not null) THEN
816: BEGIN
817: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
818: fnd_log.STRING(fnd_log.level_procedure,
819: g_pkg_name || '.' || l_api_name,
820: 'SELECT rule_name INTO l_rule_name ' ||
821: ' FROM gcs_elim_rules_vl WHERE rule_id = ' ||
822: p_rule_id);

Line 839: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

835: 239);
836: END IF;
837: p_entry_header.NAME := p_entry_id;
838: p_entry_header.description := l_entry_description;
839: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
840: fnd_log.STRING(fnd_log.level_procedure,
841: g_pkg_name || '.' || l_api_name,
842: 'return p_entry_header.name = ' || p_entry_id ||
843: ' and p_entry_header.description = ' ||

Line 840: fnd_log.STRING(fnd_log.level_procedure,

836: END IF;
837: p_entry_header.NAME := p_entry_id;
838: p_entry_header.description := l_entry_description;
839: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
840: fnd_log.STRING(fnd_log.level_procedure,
841: g_pkg_name || '.' || l_api_name,
842: 'return p_entry_header.name = ' || p_entry_id ||
843: ' and p_entry_header.description = ' ||
844: l_entry_description);

Line 846: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

842: 'return p_entry_header.name = ' || p_entry_id ||
843: ' and p_entry_header.description = ' ||
844: l_entry_description);
845: END IF;
846: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
847: fnd_log.STRING(fnd_log.level_procedure,
848: g_pkg_name || '.' || l_api_name,
849: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
850: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 847: fnd_log.STRING(fnd_log.level_procedure,

843: ' and p_entry_header.description = ' ||
844: l_entry_description);
845: END IF;
846: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
847: fnd_log.STRING(fnd_log.level_procedure,
848: g_pkg_name || '.' || l_api_name,
849: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
850: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
851: END IF;

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

869: p_period_init_entry_flag IN VARCHAR2 DEFAULT 'N') IS
870: l_api_name VARCHAR2(30) := 'INSERT_ENTRY_HEADER';
871: BEGIN
872: SAVEPOINT gcs_insert_header_start;
873: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
874: fnd_log.STRING(fnd_log.level_procedure,
875: g_pkg_name || '.' || l_api_name,
876: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
877: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 874: fnd_log.STRING(fnd_log.level_procedure,

870: l_api_name VARCHAR2(30) := 'INSERT_ENTRY_HEADER';
871: BEGIN
872: SAVEPOINT gcs_insert_header_start;
873: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
874: fnd_log.STRING(fnd_log.level_procedure,
875: g_pkg_name || '.' || l_api_name,
876: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
877: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
878: END IF;

Line 879: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

875: g_pkg_name || '.' || l_api_name,
876: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
877: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
878: END IF;
879: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
880: fnd_log.STRING(fnd_log.level_procedure,
881: g_pkg_name || '.' || l_api_name,
882: 'INSERT INTO gcs_entry_headers' || g_nl ||
883: '(entry_id, entry_name, hierarchy_id, disabled_flag,' || g_nl ||

Line 880: fnd_log.STRING(fnd_log.level_procedure,

876: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
877: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
878: END IF;
879: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
880: fnd_log.STRING(fnd_log.level_procedure,
881: g_pkg_name || '.' || l_api_name,
882: 'INSERT INTO gcs_entry_headers' || g_nl ||
883: '(entry_id, entry_name, hierarchy_id, disabled_flag,' || g_nl ||
884: 'entity_id, currency_code, balance_type_code,' || g_nl ||

Line 950: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

946: fnd_global.user_id,
947: fnd_global.login_id,
948: p_period_init_entry_flag);
949: x_retcode := fnd_api.g_ret_sts_success;
950: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
951: fnd_log.STRING(fnd_log.level_procedure,
952: g_pkg_name || '.' || l_api_name,
953: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
954: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 951: fnd_log.STRING(fnd_log.level_procedure,

947: fnd_global.login_id,
948: p_period_init_entry_flag);
949: x_retcode := fnd_api.g_ret_sts_success;
950: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
951: fnd_log.STRING(fnd_log.level_procedure,
952: g_pkg_name || '.' || l_api_name,
953: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
954: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
955: END IF;

Line 963: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

959: fnd_message.set_name('GCS', 'GCS_INVALID_ENTRY_ID');
960: x_errbuf := fnd_message.get;
961: x_retcode := fnd_api.g_ret_sts_error;
962: -- Write the appropriate information to the execution report
963: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
964: fnd_log.STRING(fnd_log.level_error,
965: g_pkg_name || '.' || l_api_name,
966: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
967: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 964: fnd_log.STRING(fnd_log.level_error,

960: x_errbuf := fnd_message.get;
961: x_retcode := fnd_api.g_ret_sts_error;
962: -- Write the appropriate information to the execution report
963: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
964: fnd_log.STRING(fnd_log.level_error,
965: g_pkg_name || '.' || l_api_name,
966: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
967: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
968: END IF;

Line 990: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

986: l_header_info r_entry_header;
987: l_api_name VARCHAR2(30) := 'CREATE_ENTRY_HEADER';
988: BEGIN
989: SAVEPOINT gcs_create_header_start;
990: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
991: fnd_log.STRING(fnd_log.level_procedure,
992: g_pkg_name || '.' || l_api_name,
993: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
994: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 991: fnd_log.STRING(fnd_log.level_procedure,

987: l_api_name VARCHAR2(30) := 'CREATE_ENTRY_HEADER';
988: BEGIN
989: SAVEPOINT gcs_create_header_start;
990: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
991: fnd_log.STRING(fnd_log.level_procedure,
992: g_pkg_name || '.' || l_api_name,
993: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
994: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
995: END IF;

Line 1022: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1018: p_category_code => p_category_code,
1019: x_errbuf => x_errbuf,
1020: x_retcode => x_retcode,
1021: p_period_init_entry_flag => p_period_init_entry_flag);
1022: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1023: fnd_log.STRING(fnd_log.level_procedure,
1024: g_pkg_name || '.' || l_api_name,
1025: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1026: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1023: fnd_log.STRING(fnd_log.level_procedure,

1019: x_errbuf => x_errbuf,
1020: x_retcode => x_retcode,
1021: p_period_init_entry_flag => p_period_init_entry_flag);
1022: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1023: fnd_log.STRING(fnd_log.level_procedure,
1024: g_pkg_name || '.' || l_api_name,
1025: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1026: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1027: END IF;

Line 1035: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1031: fnd_message.set_name('GCS', 'GCS_INVALID_ENTITY_ERR');
1032: x_errbuf := fnd_message.get;
1033: x_retcode := fnd_api.g_ret_sts_unexp_error;
1034: -- Write the appropriate information to the execution report
1035: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1036: fnd_log.STRING(fnd_log.level_error,
1037: g_pkg_name || '.' || l_api_name,
1038: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1039: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1036: fnd_log.STRING(fnd_log.level_error,

1032: x_errbuf := fnd_message.get;
1033: x_retcode := fnd_api.g_ret_sts_unexp_error;
1034: -- Write the appropriate information to the execution report
1035: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1036: fnd_log.STRING(fnd_log.level_error,
1037: g_pkg_name || '.' || l_api_name,
1038: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1039: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1040: END IF;

Line 1047: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1043: fnd_message.set_name('GCS', 'GCS_INVALID_RULE_ERR');
1044: x_errbuf := fnd_message.get;
1045: x_retcode := fnd_api.g_ret_sts_unexp_error;
1046: -- Write the appropriate information to the execution report
1047: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1048: fnd_log.STRING(fnd_log.level_error,
1049: g_pkg_name || '.' || l_api_name,
1050: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1051: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1048: fnd_log.STRING(fnd_log.level_error,

1044: x_errbuf := fnd_message.get;
1045: x_retcode := fnd_api.g_ret_sts_unexp_error;
1046: -- Write the appropriate information to the execution report
1047: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1048: fnd_log.STRING(fnd_log.level_error,
1049: g_pkg_name || '.' || l_api_name,
1050: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1051: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1052: END IF;

Line 1059: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1055: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
1056: x_errbuf := fnd_message.get;
1057: x_retcode := fnd_api.g_ret_sts_unexp_error;
1058: -- Write the appropriate information to the execution report
1059: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1060: fnd_log.STRING(fnd_log.level_error,
1061: g_pkg_name || '.' || l_api_name,
1062: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1063: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1060: fnd_log.STRING(fnd_log.level_error,

1056: x_errbuf := fnd_message.get;
1057: x_retcode := fnd_api.g_ret_sts_unexp_error;
1058: -- Write the appropriate information to the execution report
1059: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1060: fnd_log.STRING(fnd_log.level_error,
1061: g_pkg_name || '.' || l_api_name,
1062: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1063: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1064: END IF;

Line 1116: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1112: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1113: g_pkg_name || '.' || l_api_name || ' ENTER');
1114: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1115:
1116: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1117: fnd_log.STRING(fnd_log.level_procedure,
1118: g_pkg_name || '.' || l_api_name,
1119: gcs_utility_pkg.g_module_enter || ' p_entry_id = ' ||
1120: p_entry_id || ' p_end_cal_period_id = ' ||

Line 1117: fnd_log.STRING(fnd_log.level_procedure,

1113: g_pkg_name || '.' || l_api_name || ' ENTER');
1114: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1115:
1116: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1117: fnd_log.STRING(fnd_log.level_procedure,
1118: g_pkg_name || '.' || l_api_name,
1119: gcs_utility_pkg.g_module_enter || ' p_entry_id = ' ||
1120: p_entry_id || ' p_end_cal_period_id = ' ||
1121: p_end_cal_period_id || ' p_hierarchy_id = ' ||

Line 1174: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1170: p_balance_type_code,
1171: p_new_entry_id,
1172: l_entry_id,
1173: l_orig_entry_id);
1174: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1175: fnd_log.STRING(fnd_log.level_procedure,
1176: g_pkg_name || '.' || l_api_name,
1177: 'SELECT decode(start_cal_period_id, end_cal_period_id, ''ONE_TIME'',
1178: ''RECURRING''), year_to_apply_re, hierarchy_id, balance_type_code,

Line 1175: fnd_log.STRING(fnd_log.level_procedure,

1171: p_new_entry_id,
1172: l_entry_id,
1173: l_orig_entry_id);
1174: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1175: fnd_log.STRING(fnd_log.level_procedure,
1176: g_pkg_name || '.' || l_api_name,
1177: 'SELECT decode(start_cal_period_id, end_cal_period_id, ''ONE_TIME'',
1178: ''RECURRING''), year_to_apply_re, hierarchy_id, balance_type_code,
1179: entity_id, NVL (minimum_accountable_unit, POWER (10, -PRECISION))' || g_nl ||

Line 1208: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1204: AND geh.entry_id = l_entry_id;
1205:
1206: IF (l_entry_type_code = 'RECURRING') THEN
1207: -- update the line_type_code for recurring entry lines
1208: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1209: fnd_log.STRING(fnd_log.level_procedure,
1210: g_pkg_name || '.' || l_api_name,
1211: 'UPDATE gcs_entry_lines' || g_nl ||
1212: 'SET ytd_debit_balance_e = ROUND (ytd_debit_balance_e / l_precision)

Line 1209: fnd_log.STRING(fnd_log.level_procedure,

1205:
1206: IF (l_entry_type_code = 'RECURRING') THEN
1207: -- update the line_type_code for recurring entry lines
1208: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1209: fnd_log.STRING(fnd_log.level_procedure,
1210: g_pkg_name || '.' || l_api_name,
1211: 'UPDATE gcs_entry_lines' || g_nl ||
1212: 'SET ytd_debit_balance_e = ROUND (ytd_debit_balance_e / l_precision)
1213: * l_precision, ' || g_nl ||

Line 1290: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1286: p_bal_type_code => l_balance_code,
1287: p_entity_id => l_entity_id);
1288: END IF;
1289: ELSE
1290: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1291: fnd_log.STRING(fnd_log.level_procedure,
1292: g_pkg_name || '.' || l_api_name,
1293: 'UPDATE gcs_entry_lines' || g_nl ||
1294: 'SET ytd_debit_balance_e = ROUND (ytd_debit_balance_e / l_precision) * l_precision, ' || g_nl ||

Line 1291: fnd_log.STRING(fnd_log.level_procedure,

1287: p_entity_id => l_entity_id);
1288: END IF;
1289: ELSE
1290: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1291: fnd_log.STRING(fnd_log.level_procedure,
1292: g_pkg_name || '.' || l_api_name,
1293: 'UPDATE gcs_entry_lines' || g_nl ||
1294: 'SET ytd_debit_balance_e = ROUND (ytd_debit_balance_e / l_precision) * l_precision, ' || g_nl ||
1295: 'ytd_credit_balance_e = ROUND (ytd_credit_balance_e / l_precision) * l_precision, ' || g_nl ||

Line 1328: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1325: g_pkg_name || '.' || l_api_name || 'EXIT');
1326: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1327:
1328: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1329: fnd_log.STRING(fnd_log.level_procedure,
1330: g_pkg_name || '.' || l_api_name,
1331: gcs_utility_pkg.g_module_success || ' ' ||
1332: l_api_name || '() ' ||

Line 1329: fnd_log.STRING(fnd_log.level_procedure,

1325: g_pkg_name || '.' || l_api_name || 'EXIT');
1326: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1327:
1328: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1329: fnd_log.STRING(fnd_log.level_procedure,
1330: g_pkg_name || '.' || l_api_name,
1331: gcs_utility_pkg.g_module_success || ' ' ||
1332: l_api_name || '() ' ||
1333: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 1359: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1356: g_pkg_name || '.' || l_api_name ||
1357: ' ERROR : ' || SQLERRM);
1358: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1359: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1360: fnd_log.STRING(fnd_log.level_error,
1361: g_pkg_name || '.' || l_api_name,
1362: ' wf_event.raise failed ' || ' ' ||
1363: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1360: fnd_log.STRING(fnd_log.level_error,

1356: g_pkg_name || '.' || l_api_name ||
1357: ' ERROR : ' || SQLERRM);
1358: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1359: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1360: fnd_log.STRING(fnd_log.level_error,
1361: g_pkg_name || '.' || l_api_name,
1362: ' wf_event.raise failed ' || ' ' ||
1363: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1364: END IF;

Line 1390: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1386:
1387: END IF;
1388:
1389: END IF;
1390: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1391: fnd_log.STRING(fnd_log.level_procedure,
1392: g_pkg_name || '.' || l_api_name,
1393: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1394: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1391: fnd_log.STRING(fnd_log.level_procedure,

1387: END IF;
1388:
1389: END IF;
1390: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1391: fnd_log.STRING(fnd_log.level_procedure,
1392: g_pkg_name || '.' || l_api_name,
1393: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1394: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1395: END IF;

Line 1407: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1403: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1404: SQLERRM);
1405: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1406: -- Write the appropriate information to the execution report
1407: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1408: fnd_log.STRING(fnd_log.level_error,
1409: g_pkg_name || '.' || l_api_name,
1410: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
1411: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1408: fnd_log.STRING(fnd_log.level_error,

1404: SQLERRM);
1405: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1406: -- Write the appropriate information to the execution report
1407: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1408: fnd_log.STRING(fnd_log.level_error,
1409: g_pkg_name || '.' || l_api_name,
1410: gcs_utility_pkg.g_module_failure || ' ' || SQLERRM || ' ' ||
1411: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1412: END IF;

Line 1453: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1449: x_retcode OUT NOCOPY VARCHAR2) IS
1450: l_api_name VARCHAR2(30) := 'DELETE_ENTRY';
1451: BEGIN
1452: SAVEPOINT gcs_delete_entry_start;
1453: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1454: fnd_log.STRING(fnd_log.level_procedure,
1455: g_pkg_name || '.' || l_api_name,
1456: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
1457: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1454: fnd_log.STRING(fnd_log.level_procedure,

1450: l_api_name VARCHAR2(30) := 'DELETE_ENTRY';
1451: BEGIN
1452: SAVEPOINT gcs_delete_entry_start;
1453: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1454: fnd_log.STRING(fnd_log.level_procedure,
1455: g_pkg_name || '.' || l_api_name,
1456: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
1457: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1458: END IF;

Line 1459: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1455: g_pkg_name || '.' || l_api_name,
1456: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
1457: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1458: END IF;
1459: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1460: fnd_log.STRING(fnd_log.level_procedure,
1461: g_pkg_name || '.' || l_api_name,
1462: 'DELETE FROM gcs_entry_headers' || g_nl ||
1463: 'WHERE entry_id = ' || p_entry_id);

Line 1460: fnd_log.STRING(fnd_log.level_procedure,

1456: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
1457: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1458: END IF;
1459: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1460: fnd_log.STRING(fnd_log.level_procedure,
1461: g_pkg_name || '.' || l_api_name,
1462: 'DELETE FROM gcs_entry_headers' || g_nl ||
1463: 'WHERE entry_id = ' || p_entry_id);
1464: END IF;

Line 1469: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1465: /*
1466: DELETE FROM gcs_entry_headers
1467: WHERE entry_id = p_entry_id;
1468: */
1469: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1470: fnd_log.STRING(fnd_log.level_procedure,
1471: g_pkg_name || '.' || l_api_name,
1472: 'DELETE FROM gcs_entry_lines' || g_nl ||
1473: 'WHERE entry_id = ' || p_entry_id);

Line 1470: fnd_log.STRING(fnd_log.level_procedure,

1466: DELETE FROM gcs_entry_headers
1467: WHERE entry_id = p_entry_id;
1468: */
1469: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1470: fnd_log.STRING(fnd_log.level_procedure,
1471: g_pkg_name || '.' || l_api_name,
1472: 'DELETE FROM gcs_entry_lines' || g_nl ||
1473: 'WHERE entry_id = ' || p_entry_id);
1474: END IF;

Line 1477: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

1473: 'WHERE entry_id = ' || p_entry_id);
1474: END IF;
1475: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
1476: x_retcode := fnd_api.g_ret_sts_success;
1477: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1478: fnd_log.STRING(fnd_log.level_procedure,
1479: g_pkg_name || '.' || l_api_name,
1480: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1481: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1478: fnd_log.STRING(fnd_log.level_procedure,

1474: END IF;
1475: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
1476: x_retcode := fnd_api.g_ret_sts_success;
1477: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1478: fnd_log.STRING(fnd_log.level_procedure,
1479: g_pkg_name || '.' || l_api_name,
1480: gcs_utility_pkg.g_module_success || ' ' || l_api_name ||
1481: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1482: END IF;

Line 1490: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1486: fnd_message.set_name('GCS', 'GCS_INVALID_ENTRY_ID');
1487: x_errbuf := fnd_message.get;
1488: x_retcode := fnd_api.g_ret_sts_error;
1489: -- Write the appropriate information to the execution report
1490: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1491: fnd_log.STRING(fnd_log.level_error,
1492: g_pkg_name || '.' || l_api_name,
1493: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1494: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1491: fnd_log.STRING(fnd_log.level_error,

1487: x_errbuf := fnd_message.get;
1488: x_retcode := fnd_api.g_ret_sts_error;
1489: -- Write the appropriate information to the execution report
1490: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1491: fnd_log.STRING(fnd_log.level_error,
1492: g_pkg_name || '.' || l_api_name,
1493: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1494: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1495: END IF;

Line 1502: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1498: fnd_message.set_name('GCS', 'GCS_ENTRY_UNEXPECTED_ERR');
1499: x_errbuf := fnd_message.get;
1500: x_retcode := fnd_api.g_ret_sts_unexp_error;
1501: -- Write the appropriate information to the execution report
1502: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1503: fnd_log.STRING(fnd_log.level_error,
1504: g_pkg_name || '.' || l_api_name,
1505: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1506: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1503: fnd_log.STRING(fnd_log.level_error,

1499: x_errbuf := fnd_message.get;
1500: x_retcode := fnd_api.g_ret_sts_unexp_error;
1501: -- Write the appropriate information to the execution report
1502: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1503: fnd_log.STRING(fnd_log.level_error,
1504: g_pkg_name || '.' || l_api_name,
1505: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
1506: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1507: END IF;

Line 1556: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

1552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1553: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1554: SQLERRM);
1555: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1556: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1557: fnd_log.STRING(fnd_log.level_error,
1558: g_pkg_name || '.' || l_api_name,
1559: ' wf_event.raise failed ' || ' ' ||
1560: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 1557: fnd_log.STRING(fnd_log.level_error,

1553: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1554: SQLERRM);
1555: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
1556: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1557: fnd_log.STRING(fnd_log.level_error,
1558: g_pkg_name || '.' || l_api_name,
1559: ' wf_event.raise failed ' || ' ' ||
1560: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1561: END IF;