DBA Data[Home] [Help]

APPS.GL_CRM_UTILITIES_PKG dependencies on GL_CRM_UTILITIES_PKG

Line 1: PACKAGE BODY GL_CRM_UTILITIES_PKG AS

1: PACKAGE BODY GL_CRM_UTILITIES_PKG AS
2: /* $Header: glcrmutb.pls 120.12.12010000.2 2008/08/13 12:00:43 kmotepal ship $ */
3: PROCEDURE change_flag(
4: flag BOOLEAN) IS
5: BEGIN

Line 476: -- GL_CRM_UTILITIES_PKG.DEBUG_MODE := TRUE;

472: --
473: -- If there is any error, an appropriate error_code will be set.
474: gl_message.func_ent('Daily Rates Import');
475:
476: -- GL_CRM_UTILITIES_PKG.DEBUG_MODE := TRUE;
477:
478: UPDATE gl_daily_rates_interface ri
479: SET ERROR_CODE =
480: (SELECT DECODE

Line 705: gl_crm_utilities_pkg.print_report_title;

701: WHERE mode_flag IN('X', 'F');
702:
703: FOR i IN 1 .. daily_rate_validation_failure.r_from_curr.COUNT LOOP
704: IF page_line_count = 1 THEN
705: gl_crm_utilities_pkg.print_report_title;
706: gl_crm_utilities_pkg.print_validation_failure;
707: END IF;
708:
709: page_line_count := page_line_count + 1;

Line 706: gl_crm_utilities_pkg.print_validation_failure;

702:
703: FOR i IN 1 .. daily_rate_validation_failure.r_from_curr.COUNT LOOP
704: IF page_line_count = 1 THEN
705: gl_crm_utilities_pkg.print_report_title;
706: gl_crm_utilities_pkg.print_validation_failure;
707: END IF;
708:
709: page_line_count := page_line_count + 1;
710: fnd_file.put_line

Line 817: gl_crm_utilities_pkg.print_report_title;

813: END IF;
814:
815: FOR i IN 1 .. sys_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
816: IF page_line_count = 1 THEN
817: gl_crm_utilities_pkg.print_report_title;
818: gl_crm_utilities_pkg.print_delete_user_rate_warning;
819: ELSIF i = 1 THEN
820: gl_crm_utilities_pkg.print_delete_user_rate_warning;
821: END IF;

Line 818: gl_crm_utilities_pkg.print_delete_user_rate_warning;

814:
815: FOR i IN 1 .. sys_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
816: IF page_line_count = 1 THEN
817: gl_crm_utilities_pkg.print_report_title;
818: gl_crm_utilities_pkg.print_delete_user_rate_warning;
819: ELSIF i = 1 THEN
820: gl_crm_utilities_pkg.print_delete_user_rate_warning;
821: END IF;
822:

Line 820: gl_crm_utilities_pkg.print_delete_user_rate_warning;

816: IF page_line_count = 1 THEN
817: gl_crm_utilities_pkg.print_report_title;
818: gl_crm_utilities_pkg.print_delete_user_rate_warning;
819: ELSIF i = 1 THEN
820: gl_crm_utilities_pkg.print_delete_user_rate_warning;
821: END IF;
822:
823: page_line_count := page_line_count + 1;
824: fnd_file.put_line

Line 887: gl_crm_utilities_pkg.print_report_title;

883: AND dr.conversion_type = gldct.conversion_type;
884:
885: FOR i IN 1 .. sys_daily_rate_cannot_override.r_from_curr.COUNT LOOP
886: IF page_line_count = 1 THEN
887: gl_crm_utilities_pkg.print_report_title;
888: gl_crm_utilities_pkg.print_override_user_rate_warn;
889: ELSIF i = 1 THEN
890: gl_crm_utilities_pkg.print_override_user_rate_warn;
891: END IF;

Line 888: gl_crm_utilities_pkg.print_override_user_rate_warn;

884:
885: FOR i IN 1 .. sys_daily_rate_cannot_override.r_from_curr.COUNT LOOP
886: IF page_line_count = 1 THEN
887: gl_crm_utilities_pkg.print_report_title;
888: gl_crm_utilities_pkg.print_override_user_rate_warn;
889: ELSIF i = 1 THEN
890: gl_crm_utilities_pkg.print_override_user_rate_warn;
891: END IF;
892:

Line 890: gl_crm_utilities_pkg.print_override_user_rate_warn;

886: IF page_line_count = 1 THEN
887: gl_crm_utilities_pkg.print_report_title;
888: gl_crm_utilities_pkg.print_override_user_rate_warn;
889: ELSIF i = 1 THEN
890: gl_crm_utilities_pkg.print_override_user_rate_warn;
891: END IF;
892:
893: page_line_count := page_line_count + 1;
894: fnd_file.put_line

Line 1391: gl_crm_utilities_pkg.print_report_title;

1387: + 1;
1388:
1389: FOR i IN 1 .. usr_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
1390: IF page_line_count = 1 THEN
1391: gl_crm_utilities_pkg.print_report_title;
1392: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1393: ELSIF i = 1 THEN
1394: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1395: END IF;

Line 1392: gl_crm_utilities_pkg.print_delete_sys_rate_warning;

1388:
1389: FOR i IN 1 .. usr_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
1390: IF page_line_count = 1 THEN
1391: gl_crm_utilities_pkg.print_report_title;
1392: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1393: ELSIF i = 1 THEN
1394: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1395: END IF;
1396:

Line 1394: gl_crm_utilities_pkg.print_delete_sys_rate_warning;

1390: IF page_line_count = 1 THEN
1391: gl_crm_utilities_pkg.print_report_title;
1392: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1393: ELSIF i = 1 THEN
1394: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1395: END IF;
1396:
1397: page_line_count := page_line_count + 1;
1398: fnd_file.put_line

Line 1464: gl_crm_utilities_pkg.print_report_title;

1460: + 1;
1461:
1462: FOR i IN 1 .. usr_daily_rate_cannot_override.r_from_curr.COUNT LOOP
1463: IF page_line_count = 1 THEN
1464: gl_crm_utilities_pkg.print_report_title;
1465: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1466: ELSIF i = 1 THEN
1467: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1468: END IF;

Line 1465: gl_crm_utilities_pkg.print_override_sys_rate_warn;

1461:
1462: FOR i IN 1 .. usr_daily_rate_cannot_override.r_from_curr.COUNT LOOP
1463: IF page_line_count = 1 THEN
1464: gl_crm_utilities_pkg.print_report_title;
1465: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1466: ELSIF i = 1 THEN
1467: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1468: END IF;
1469:

Line 1467: gl_crm_utilities_pkg.print_override_sys_rate_warn;

1463: IF page_line_count = 1 THEN
1464: gl_crm_utilities_pkg.print_report_title;
1465: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1466: ELSIF i = 1 THEN
1467: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1468: END IF;
1469:
1470: page_line_count := page_line_count + 1;
1471: fnd_file.put_line

Line 1809: gl_crm_utilities_pkg.print_validation_failure_codes;

1805: '', '');
1806: END IF;
1807:
1808: IF page_count * page_line_count > 1 THEN
1809: gl_crm_utilities_pkg.print_validation_failure_codes;
1810: set_completion_status_result :=
1811: fnd_concurrent.set_completion_status
1812: ('WARNING',
1813: 'Exceptions occurs, please check the output for details.');

Line 1841: END GL_CRM_UTILITIES_PKG;

1837: '', '', '', '', '', '', '', '', '', '',
1838: '');
1839: RETURN(RESULT);
1840: END submit_conc_request;
1841: END GL_CRM_UTILITIES_PKG;