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.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.22.12020000.2 2012/08/28 20:58:53 phmullap ship $ */
3: p_from_currency VARCHAR2(240);
4: p_to_currency VARCHAR2(240);
5: p_from_conversion_date DATE;

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

487: --
488: -- If there is any error, an appropriate error_code will be set.
489: gl_message.func_ent('Daily Rates Import');
490:
491: -- GL_CRM_UTILITIES_PKG.DEBUG_MODE := TRUE;
492: /*If the Batch Number is NULL, it'll process only the records with Batch Number NULL records in the GL_DAILY_RATES_INTERFACE Table.*/
493: /* Updating BATCH_NUMNER '-99999' in the Interface table if Batch Number Parameter is NULL*/
494: IF l_batch_number IS NULL THEN
495: UPDATE gl_daily_rates_interface ri

Line 883: gl_crm_utilities_pkg.print_report_title;

879: AND batch_number = l_batch_number;
880:
881: FOR i IN 1 .. daily_rate_validation_failure.r_from_curr.COUNT LOOP
882: IF page_line_count = 1 THEN
883: gl_crm_utilities_pkg.print_report_title;
884: gl_crm_utilities_pkg.print_validation_failure;
885: END IF;
886:
887: page_line_count := page_line_count + 1;

Line 884: gl_crm_utilities_pkg.print_validation_failure;

880:
881: FOR i IN 1 .. daily_rate_validation_failure.r_from_curr.COUNT LOOP
882: IF page_line_count = 1 THEN
883: gl_crm_utilities_pkg.print_report_title;
884: gl_crm_utilities_pkg.print_validation_failure;
885: END IF;
886:
887: page_line_count := page_line_count + 1;
888: fnd_file.put_line

Line 996: gl_crm_utilities_pkg.print_report_title;

992: END IF;
993:
994: FOR i IN 1 .. sys_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
995: IF page_line_count = 1 THEN
996: gl_crm_utilities_pkg.print_report_title;
997: gl_crm_utilities_pkg.print_delete_user_rate_warning;
998: ELSIF i = 1 THEN
999: gl_crm_utilities_pkg.print_delete_user_rate_warning;
1000: END IF;

Line 997: gl_crm_utilities_pkg.print_delete_user_rate_warning;

993:
994: FOR i IN 1 .. sys_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
995: IF page_line_count = 1 THEN
996: gl_crm_utilities_pkg.print_report_title;
997: gl_crm_utilities_pkg.print_delete_user_rate_warning;
998: ELSIF i = 1 THEN
999: gl_crm_utilities_pkg.print_delete_user_rate_warning;
1000: END IF;
1001:

Line 999: gl_crm_utilities_pkg.print_delete_user_rate_warning;

995: IF page_line_count = 1 THEN
996: gl_crm_utilities_pkg.print_report_title;
997: gl_crm_utilities_pkg.print_delete_user_rate_warning;
998: ELSIF i = 1 THEN
999: gl_crm_utilities_pkg.print_delete_user_rate_warning;
1000: END IF;
1001:
1002: page_line_count := page_line_count + 1;
1003: fnd_file.put_line

Line 1067: gl_crm_utilities_pkg.print_report_title;

1063: AND ri.batch_number = l_batch_number;
1064:
1065: FOR i IN 1 .. sys_daily_rate_cannot_override.r_from_curr.COUNT LOOP
1066: IF page_line_count = 1 THEN
1067: gl_crm_utilities_pkg.print_report_title;
1068: gl_crm_utilities_pkg.print_override_user_rate_warn;
1069: ELSIF i = 1 THEN
1070: gl_crm_utilities_pkg.print_override_user_rate_warn;
1071: END IF;

Line 1068: gl_crm_utilities_pkg.print_override_user_rate_warn;

1064:
1065: FOR i IN 1 .. sys_daily_rate_cannot_override.r_from_curr.COUNT LOOP
1066: IF page_line_count = 1 THEN
1067: gl_crm_utilities_pkg.print_report_title;
1068: gl_crm_utilities_pkg.print_override_user_rate_warn;
1069: ELSIF i = 1 THEN
1070: gl_crm_utilities_pkg.print_override_user_rate_warn;
1071: END IF;
1072:

Line 1070: gl_crm_utilities_pkg.print_override_user_rate_warn;

1066: IF page_line_count = 1 THEN
1067: gl_crm_utilities_pkg.print_report_title;
1068: gl_crm_utilities_pkg.print_override_user_rate_warn;
1069: ELSIF i = 1 THEN
1070: gl_crm_utilities_pkg.print_override_user_rate_warn;
1071: END IF;
1072:
1073: page_line_count := page_line_count + 1;
1074: fnd_file.put_line

Line 1600: gl_crm_utilities_pkg.print_report_title;

1596: + 1;
1597:
1598: FOR i IN 1 .. usr_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
1599: IF page_line_count = 1 THEN
1600: gl_crm_utilities_pkg.print_report_title;
1601: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1602: ELSIF i = 1 THEN
1603: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1604: END IF;

Line 1601: gl_crm_utilities_pkg.print_delete_sys_rate_warning;

1597:
1598: FOR i IN 1 .. usr_daily_rate_cannot_delete.r_from_curr.COUNT LOOP
1599: IF page_line_count = 1 THEN
1600: gl_crm_utilities_pkg.print_report_title;
1601: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1602: ELSIF i = 1 THEN
1603: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1604: END IF;
1605:

Line 1603: gl_crm_utilities_pkg.print_delete_sys_rate_warning;

1599: IF page_line_count = 1 THEN
1600: gl_crm_utilities_pkg.print_report_title;
1601: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1602: ELSIF i = 1 THEN
1603: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1604: END IF;
1605:
1606: page_line_count := page_line_count + 1;
1607: fnd_file.put_line

Line 1673: gl_crm_utilities_pkg.print_report_title;

1669: + 1;
1670:
1671: FOR i IN 1 .. usr_daily_rate_cannot_override.r_from_curr.COUNT LOOP
1672: IF page_line_count = 1 THEN
1673: gl_crm_utilities_pkg.print_report_title;
1674: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1675: ELSIF i = 1 THEN
1676: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1677: END IF;

Line 1674: gl_crm_utilities_pkg.print_override_sys_rate_warn;

1670:
1671: FOR i IN 1 .. usr_daily_rate_cannot_override.r_from_curr.COUNT LOOP
1672: IF page_line_count = 1 THEN
1673: gl_crm_utilities_pkg.print_report_title;
1674: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1675: ELSIF i = 1 THEN
1676: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1677: END IF;
1678:

Line 1676: gl_crm_utilities_pkg.print_override_sys_rate_warn;

1672: IF page_line_count = 1 THEN
1673: gl_crm_utilities_pkg.print_report_title;
1674: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1675: ELSIF i = 1 THEN
1676: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1677: END IF;
1678:
1679: page_line_count := page_line_count + 1;
1680: fnd_file.put_line

Line 2036: gl_crm_utilities_pkg.print_validation_failure_codes;

2032: '', '');
2033: END IF;
2034:
2035: IF page_count * page_line_count > 1 THEN
2036: gl_crm_utilities_pkg.print_validation_failure_codes;
2037: set_completion_status_result :=
2038: fnd_concurrent.set_completion_status
2039: ('WARNING',
2040: 'Exceptions occurs, please check the output for details.');

Line 2084: END GL_CRM_UTILITIES_PKG;

2080: '', '', '', '', '', '', '', '', '', '',
2081: '');
2082: RETURN(RESULT);
2083: END submit_conc_request;
2084: END GL_CRM_UTILITIES_PKG;