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.HXC_GENERIC_RETRIEVAL_PKG dependencies on FND_MESSAGE

Line 1180: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1176:
1177: IF (l_cnt > 60)
1178: THEN
1179: -- after 60 attempts (30 minutes)
1180: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1181: fnd_message.set_token ('PROCEDURE', l_proc);
1182: fnd_message.set_token ('STEP', 'cannot maintain ranges');
1183: fnd_message.raise_error;
1184: END IF;

Line 1181: fnd_message.set_token ('PROCEDURE', l_proc);

1177: IF (l_cnt > 60)
1178: THEN
1179: -- after 60 attempts (30 minutes)
1180: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1181: fnd_message.set_token ('PROCEDURE', l_proc);
1182: fnd_message.set_token ('STEP', 'cannot maintain ranges');
1183: fnd_message.raise_error;
1184: END IF;
1185:

Line 1182: fnd_message.set_token ('STEP', 'cannot maintain ranges');

1178: THEN
1179: -- after 60 attempts (30 minutes)
1180: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1181: fnd_message.set_token ('PROCEDURE', l_proc);
1182: fnd_message.set_token ('STEP', 'cannot maintain ranges');
1183: fnd_message.raise_error;
1184: END IF;
1185:
1186: IF g_debug

Line 1183: fnd_message.raise_error;

1179: -- after 60 attempts (30 minutes)
1180: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1181: fnd_message.set_token ('PROCEDURE', l_proc);
1182: fnd_message.set_token ('STEP', 'cannot maintain ranges');
1183: fnd_message.raise_error;
1184: END IF;
1185:
1186: IF g_debug
1187: THEN

Line 1437: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');

1433: || l_not_exists
1434: || l_app_set
1435: || l_ret_criteria_clause;
1436: ELSE
1437: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
1438: fnd_message.raise_error;
1439: END IF;
1440: ELSE
1441: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');

Line 1438: fnd_message.raise_error;

1434: || l_app_set
1435: || l_ret_criteria_clause;
1436: ELSE
1437: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
1438: fnd_message.raise_error;
1439: END IF;
1440: ELSE
1441: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');
1442: fnd_message.raise_error;

Line 1441: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');

1437: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
1438: fnd_message.raise_error;
1439: END IF;
1440: ELSE
1441: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');
1442: fnd_message.raise_error;
1443: END IF;
1444:
1445: IF g_debug

Line 1442: fnd_message.raise_error;

1438: fnd_message.raise_error;
1439: END IF;
1440: ELSE
1441: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');
1442: fnd_message.raise_error;
1443: END IF;
1444:
1445: IF g_debug
1446: THEN

Line 5352: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');

5348: p_description => 'HXC_0012_GNRET_NO_TIMECARDS'
5349: );
5350: END IF;
5351:
5352: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');
5353: fnd_message.raise_error;
5354: WHEN e_no_bld_blks_to_transfer
5355: THEN
5356: t_bb.DELETE;

Line 5353: fnd_message.raise_error;

5349: );
5350: END IF;
5351:
5352: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');
5353: fnd_message.raise_error;
5354: WHEN e_no_bld_blks_to_transfer
5355: THEN
5356: t_bb.DELETE;
5357: hxc_generic_retrieval_utils.g_resources.DELETE;

Line 5380: fnd_message.set_name ('HXC', 'HXC_0013_GNRET_NO_BLD_BLKS');

5376: p_description => 'HXC_0013_GNRET_NO_BLD_BLKS'
5377: );
5378: END IF;
5379:
5380: fnd_message.set_name ('HXC', 'HXC_0013_GNRET_NO_BLD_BLKS');
5381: fnd_message.raise_error;
5382: WHEN OTHERS
5383: THEN
5384: audit_transaction

Line 5381: fnd_message.raise_error;

5377: );
5378: END IF;
5379:
5380: fnd_message.set_name ('HXC', 'HXC_0013_GNRET_NO_BLD_BLKS');
5381: fnd_message.raise_error;
5382: WHEN OTHERS
5383: THEN
5384: audit_transaction
5385: (p_mode => 'I' -- Insert

Line 5766: fnd_message.set_name ('HXC', 'HXC_TMP_BLD_BLKS_NOT_TMP');

5762: IF gaz_chk_tmp_table%FOUND
5763: THEN
5764: CLOSE gaz_chk_tmp_table;
5765:
5766: fnd_message.set_name ('HXC', 'HXC_TMP_BLD_BLKS_NOT_TMP');
5767: fnd_message.raise_error;
5768: END IF;
5769:
5770: CLOSE gaz_chk_tmp_table;

Line 5767: fnd_message.raise_error;

5763: THEN
5764: CLOSE gaz_chk_tmp_table;
5765:
5766: fnd_message.set_name ('HXC', 'HXC_TMP_BLD_BLKS_NOT_TMP');
5767: fnd_message.raise_error;
5768: END IF;
5769:
5770: CLOSE gaz_chk_tmp_table;
5771:

Line 6526: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');

6522: ELSIF (g_params.p_clusive = 'IN')
6523: THEN
6524: l_time_store_query := l_time_in || l_day || l_detail;
6525: ELSE
6526: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
6527: fnd_message.raise_error;
6528: END IF;
6529: ELSIF (g_params.p_scope = 'DAY')
6530: THEN

Line 6527: fnd_message.raise_error;

6523: THEN
6524: l_time_store_query := l_time_in || l_day || l_detail;
6525: ELSE
6526: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
6527: fnd_message.raise_error;
6528: END IF;
6529: ELSIF (g_params.p_scope = 'DAY')
6530: THEN
6531: IF (g_params.p_clusive = 'EX')

Line 6540: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');

6536: THEN
6537: l_time_store_query := l_time || l_day || l_detail;
6538: l_inline_day := l_inline_day_in;
6539: ELSE
6540: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
6541: fnd_message.raise_error;
6542: END IF;
6543: ELSIF (g_params.p_scope = 'DETAIL')
6544: THEN

Line 6541: fnd_message.raise_error;

6537: l_time_store_query := l_time || l_day || l_detail;
6538: l_inline_day := l_inline_day_in;
6539: ELSE
6540: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
6541: fnd_message.raise_error;
6542: END IF;
6543: ELSIF (g_params.p_scope = 'DETAIL')
6544: THEN
6545: IF (g_params.p_clusive = 'EX')

Line 6554: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');

6550: THEN
6551: l_time_store_query := l_time || l_day || l_detail;
6552: l_inline_day := l_inline_day_in;
6553: ELSE
6554: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
6555: fnd_message.raise_error;
6556: END IF;
6557: ELSE
6558: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');

Line 6555: fnd_message.raise_error;

6551: l_time_store_query := l_time || l_day || l_detail;
6552: l_inline_day := l_inline_day_in;
6553: ELSE
6554: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
6555: fnd_message.raise_error;
6556: END IF;
6557: ELSE
6558: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');
6559: fnd_message.raise_error;

Line 6558: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');

6554: fnd_message.set_name ('HXC', 'HXC_0014_GNRET_INVLD_P_CLUSIVE');
6555: fnd_message.raise_error;
6556: END IF;
6557: ELSE
6558: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');
6559: fnd_message.raise_error;
6560: END IF;
6561:
6562: IF (g_params.p_rerun_flag = 'N')

Line 6559: fnd_message.raise_error;

6555: fnd_message.raise_error;
6556: END IF;
6557: ELSE
6558: fnd_message.set_name ('HXC', 'HXC_0015_GNRET_INVLD_P_SCOPE');
6559: fnd_message.raise_error;
6560: END IF;
6561:
6562: IF (g_params.p_rerun_flag = 'N')
6563: THEN

Line 6615: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

6611: || p_where_clause_att
6612: || l_not_exists
6613: || l_order_by;
6614: ELSE
6615: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6616: fnd_message.set_token ('PROCEDURE', 'Integration catch');
6617: fnd_message.set_token ('STEP', ': whereclause');
6618: fnd_message.raise_error;
6619: END IF;

Line 6616: fnd_message.set_token ('PROCEDURE', 'Integration catch');

6612: || l_not_exists
6613: || l_order_by;
6614: ELSE
6615: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6616: fnd_message.set_token ('PROCEDURE', 'Integration catch');
6617: fnd_message.set_token ('STEP', ': whereclause');
6618: fnd_message.raise_error;
6619: END IF;
6620: ELSE

Line 6617: fnd_message.set_token ('STEP', ': whereclause');

6613: || l_order_by;
6614: ELSE
6615: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6616: fnd_message.set_token ('PROCEDURE', 'Integration catch');
6617: fnd_message.set_token ('STEP', ': whereclause');
6618: fnd_message.raise_error;
6619: END IF;
6620: ELSE
6621: l_time_store_query :=

Line 6618: fnd_message.raise_error;

6614: ELSE
6615: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6616: fnd_message.set_token ('PROCEDURE', 'Integration catch');
6617: fnd_message.set_token ('STEP', ': whereclause');
6618: fnd_message.raise_error;
6619: END IF;
6620: ELSE
6621: l_time_store_query :=
6622: l_select

Line 6749: fnd_message.set_name ('HXC', 'HXC_RET_NO_RANGES');

6745: l_cnt := l_cnt + 1;
6746:
6747: IF (l_cnt > 100000)
6748: THEN
6749: fnd_message.set_name ('HXC', 'HXC_RET_NO_RANGES');
6750: fnd_message.set_token ('TERM_TIME', l_dummy);
6751: fnd_message.raise_error;
6752: END IF;
6753: ELSE

Line 6750: fnd_message.set_token ('TERM_TIME', l_dummy);

6746:
6747: IF (l_cnt > 100000)
6748: THEN
6749: fnd_message.set_name ('HXC', 'HXC_RET_NO_RANGES');
6750: fnd_message.set_token ('TERM_TIME', l_dummy);
6751: fnd_message.raise_error;
6752: END IF;
6753: ELSE
6754: IF g_debug

Line 6751: fnd_message.raise_error;

6747: IF (l_cnt > 100000)
6748: THEN
6749: fnd_message.set_name ('HXC', 'HXC_RET_NO_RANGES');
6750: fnd_message.set_token ('TERM_TIME', l_dummy);
6751: fnd_message.raise_error;
6752: END IF;
6753: ELSE
6754: IF g_debug
6755: THEN

Line 6842: fnd_message.set_name ('HXC', 'HXC_RET_ARCHIVE_DATA');

6838: INTO l_message_text;
6839:
6840: IF (chk_a_and_r_overlap%FOUND)
6841: THEN
6842: fnd_message.set_name ('HXC', 'HXC_RET_ARCHIVE_DATA');
6843: l_message_text := SUBSTR (fnd_message.get (), 1, 2000);
6844: fnd_file.put_line (fnd_file.LOG, l_message_text);
6845: END IF;
6846:

Line 6843: l_message_text := SUBSTR (fnd_message.get (), 1, 2000);

6839:
6840: IF (chk_a_and_r_overlap%FOUND)
6841: THEN
6842: fnd_message.set_name ('HXC', 'HXC_RET_ARCHIVE_DATA');
6843: l_message_text := SUBSTR (fnd_message.get (), 1, 2000);
6844: fnd_file.put_line (fnd_file.LOG, l_message_text);
6845: END IF;
6846:
6847: CLOSE chk_a_and_r_overlap;

Line 6906: fnd_message.set_name ('HXC', 'HXC_0016_GNRET_NO_MAPPINGS');

6902: INTO l_mapping_record;
6903:
6904: IF csr_get_mappings%NOTFOUND
6905: THEN
6906: fnd_message.set_name ('HXC', 'HXC_0016_GNRET_NO_MAPPINGS');
6907: fnd_message.raise_error;
6908:
6909: CLOSE csr_get_mappings;
6910: END IF;

Line 6907: fnd_message.raise_error;

6903:
6904: IF csr_get_mappings%NOTFOUND
6905: THEN
6906: fnd_message.set_name ('HXC', 'HXC_0016_GNRET_NO_MAPPINGS');
6907: fnd_message.raise_error;
6908:
6909: CLOSE csr_get_mappings;
6910: END IF;
6911:

Line 7053: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

7049: IF (csr_get_tr_id%NOTFOUND)
7050: THEN
7051: CLOSE csr_get_tr_id;
7052:
7053: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7054: fnd_message.set_token ('PROCEDURE', l_proc);
7055: fnd_message.set_token ('STEP', 'no HR Time Recipient ID');
7056: fnd_message.raise_error;
7057: END IF;

Line 7054: fnd_message.set_token ('PROCEDURE', l_proc);

7050: THEN
7051: CLOSE csr_get_tr_id;
7052:
7053: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7054: fnd_message.set_token ('PROCEDURE', l_proc);
7055: fnd_message.set_token ('STEP', 'no HR Time Recipient ID');
7056: fnd_message.raise_error;
7057: END IF;
7058:

Line 7055: fnd_message.set_token ('STEP', 'no HR Time Recipient ID');

7051: CLOSE csr_get_tr_id;
7052:
7053: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7054: fnd_message.set_token ('PROCEDURE', l_proc);
7055: fnd_message.set_token ('STEP', 'no HR Time Recipient ID');
7056: fnd_message.raise_error;
7057: END IF;
7058:
7059: CLOSE csr_get_tr_id;

Line 7056: fnd_message.raise_error;

7052:
7053: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7054: fnd_message.set_token ('PROCEDURE', l_proc);
7055: fnd_message.set_token ('STEP', 'no HR Time Recipient ID');
7056: fnd_message.raise_error;
7057: END IF;
7058:
7059: CLOSE csr_get_tr_id;
7060:

Line 7596: fnd_message.raise_error;

7592: );
7593: END IF;
7594:
7595: -- this is the last chunk and there have been no timecards
7596: fnd_message.raise_error;
7597: -- GPM v115.41
7598: EXIT;
7599: ELSE
7600: -- last chunk and there were timecards but just not in this

Line 7730: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

7726: END IF;
7727:
7728: IF (hxc_generic_retrieval_utils.chk_terminated (g_conc_request_id))
7729: THEN
7730: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7731: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
7732: fnd_message.set_token ('STEP', ': Process Terminated');
7733: fnd_message.raise_error;
7734: END IF;

Line 7731: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');

7727:
7728: IF (hxc_generic_retrieval_utils.chk_terminated (g_conc_request_id))
7729: THEN
7730: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7731: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
7732: fnd_message.set_token ('STEP', ': Process Terminated');
7733: fnd_message.raise_error;
7734: END IF;
7735: EXCEPTION

Line 7732: fnd_message.set_token ('STEP', ': Process Terminated');

7728: IF (hxc_generic_retrieval_utils.chk_terminated (g_conc_request_id))
7729: THEN
7730: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7731: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
7732: fnd_message.set_token ('STEP', ': Process Terminated');
7733: fnd_message.raise_error;
7734: END IF;
7735: EXCEPTION
7736: WHEN e_retrieval_not_registered

Line 7733: fnd_message.raise_error;

7729: THEN
7730: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
7731: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
7732: fnd_message.set_token ('STEP', ': Process Terminated');
7733: fnd_message.raise_error;
7734: END IF;
7735: EXCEPTION
7736: WHEN e_retrieval_not_registered
7737: THEN

Line 7738: fnd_message.set_name ('HXC', 'HXC_0011_GNRET_NOT_REGISTERED');

7734: END IF;
7735: EXCEPTION
7736: WHEN e_retrieval_not_registered
7737: THEN
7738: fnd_message.set_name ('HXC', 'HXC_0011_GNRET_NOT_REGISTERED');
7739: fnd_message.raise_error;
7740: WHEN e_process_already_running
7741: THEN
7742: fnd_message.set_name ('HXC', 'HXC_0017_GNRET_PROCESS_RUNNING');

Line 7739: fnd_message.raise_error;

7735: EXCEPTION
7736: WHEN e_retrieval_not_registered
7737: THEN
7738: fnd_message.set_name ('HXC', 'HXC_0011_GNRET_NOT_REGISTERED');
7739: fnd_message.raise_error;
7740: WHEN e_process_already_running
7741: THEN
7742: fnd_message.set_name ('HXC', 'HXC_0017_GNRET_PROCESS_RUNNING');
7743: fnd_message.raise_error;

Line 7742: fnd_message.set_name ('HXC', 'HXC_0017_GNRET_PROCESS_RUNNING');

7738: fnd_message.set_name ('HXC', 'HXC_0011_GNRET_NOT_REGISTERED');
7739: fnd_message.raise_error;
7740: WHEN e_process_already_running
7741: THEN
7742: fnd_message.set_name ('HXC', 'HXC_0017_GNRET_PROCESS_RUNNING');
7743: fnd_message.raise_error;
7744: WHEN e_no_ranges
7745: THEN
7746: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');

Line 7743: fnd_message.raise_error;

7739: fnd_message.raise_error;
7740: WHEN e_process_already_running
7741: THEN
7742: fnd_message.set_name ('HXC', 'HXC_0017_GNRET_PROCESS_RUNNING');
7743: fnd_message.raise_error;
7744: WHEN e_no_ranges
7745: THEN
7746: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');
7747: fnd_message.raise_error;

Line 7746: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');

7742: fnd_message.set_name ('HXC', 'HXC_0017_GNRET_PROCESS_RUNNING');
7743: fnd_message.raise_error;
7744: WHEN e_no_ranges
7745: THEN
7746: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');
7747: fnd_message.raise_error;
7748: WHEN OTHERS
7749: THEN
7750: audit_transaction

Line 7747: fnd_message.raise_error;

7743: fnd_message.raise_error;
7744: WHEN e_no_ranges
7745: THEN
7746: fnd_message.set_name ('HXC', 'HXC_0012_GNRET_NO_TIMECARDS');
7747: fnd_message.raise_error;
7748: WHEN OTHERS
7749: THEN
7750: audit_transaction
7751: (p_mode => 'I' -- Insert

Line 8178: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

8174: (fnd_profile.VALUE ('CONC_REQUEST_ID')
8175: )
8176: )
8177: THEN
8178: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8179: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
8180: fnd_message.set_token ('STEP', ': Process Terminated');
8181: fnd_message.raise_error;
8182: END IF;

Line 8179: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');

8175: )
8176: )
8177: THEN
8178: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8179: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
8180: fnd_message.set_token ('STEP', ': Process Terminated');
8181: fnd_message.raise_error;
8182: END IF;
8183:

Line 8180: fnd_message.set_token ('STEP', ': Process Terminated');

8176: )
8177: THEN
8178: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8179: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
8180: fnd_message.set_token ('STEP', ': Process Terminated');
8181: fnd_message.raise_error;
8182: END IF;
8183:
8184:

Line 8181: fnd_message.raise_error;

8177: THEN
8178: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
8179: fnd_message.set_token ('PROCEDURE', 'Generic Retrieval');
8180: fnd_message.set_token ('STEP', ': Process Terminated');
8181: fnd_message.raise_error;
8182: END IF;
8183:
8184:
8185: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE)