[Home] [Help]
390:
391: -- p_timecard_source <> 'Timecard Review' - added for 5137310
392: IF (p_timecard_source <> 'Timecard Review' AND o_return_code = 1) OR l_otm_error IS NOT NULL
393: THEN
394: hxc_time_entry_rules_utils_pkg.add_error_to_table
395: (p_message_table => p_messages,
396: p_message_name => 'HXT_TC_CANNOT_BE_CHANGED_TODAY',
397: p_message_token => NULL,
398: p_message_level => 'ERROR',
1057: THEN
1058: hr_utility.set_location (l_proc, 38);
1059: END IF;
1060:
1061: hxc_time_entry_rules_utils_pkg.add_error_to_table
1062: (p_message_table => p_messages,
1063: p_message_name => 'HR_52365_PTU_NO_PERSON_EXISTS',
1064: p_message_token => NULL,
1065: p_message_level => 'ERROR',
1362: IF g_otm_messages.COUNT > 0
1363: THEN
1364: FOR i IN g_otm_messages.FIRST .. g_otm_messages.LAST
1365: LOOP
1366: hxc_time_entry_rules_utils_pkg.add_error_to_table
1367: (p_message_table => p_messages,
1368: p_message_name => g_otm_messages (i).message_name,
1369: p_message_token => g_otm_messages (i).message_tokens,
1370: p_message_level => g_otm_messages (i).message_level,
1391: hr_utility.set_location (l_proc, 1000);
1392: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
1393: END IF;
1394:
1395: hxc_time_entry_rules_utils_pkg.add_error_to_table
1396: (p_message_table => p_messages,
1397: p_message_name => 'HXC_HXT_DEP_VAL_OTMERR',
1398: p_message_token => SUBSTR
1399: ( 'ERROR&'
1420: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error
1421: );
1422: END IF;
1423:
1424: hxc_time_entry_rules_utils_pkg.add_error_to_table
1425: (p_message_table => p_messages,
1426: p_message_name => 'HXC_HXT_DEP_VAL_ORAERR',
1427: p_message_token => 'ERROR&'
1428: || l_oracle_error,
1519: IF g_otm_messages.COUNT > 0
1520: THEN
1521: FOR i IN g_otm_messages.FIRST .. g_otm_messages.LAST
1522: LOOP
1523: hxc_time_entry_rules_utils_pkg.add_error_to_table
1524: (p_message_table => g_messages,
1525: p_message_name => g_otm_messages (i).message_name,
1526: p_message_token => g_otm_messages (i).message_tokens,
1527: p_message_level => g_otm_messages (i).message_level,
1548: hr_utility.set_location (l_proc, 2000);
1549: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
1550: END IF;
1551:
1552: hxc_time_entry_rules_utils_pkg.add_error_to_table
1553: (p_message_table => g_messages,
1554: p_message_name => 'HXC_HXT_DEP_VAL_OTMERR',
1555: p_message_token => SUBSTR
1556: ( 'ERROR&'
1584: hr_utility.set_location (l_proc, 2050);
1585: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);
1586: END IF;
1587:
1588: hxc_time_entry_rules_utils_pkg.add_error_to_table
1589: (p_message_table => g_messages,
1590: p_message_name => 'HXC_HXT_DEP_VAL_ORAERR',
1591: p_message_token => 'ERROR&'
1592: || l_oracle_error,
1724: CLOSE csr_get_app_sets;
1725:
1726: IF (p_otm_rtr_id IS NULL)
1727: THEN
1728: hxc_time_entry_rules_utils_pkg.add_error_to_table
1729: (p_message_table => p_messages,
1730: p_message_name => 'HR_6153_ALL_PROCEDURE_FAIL',
1731: p_application_short_name => 'PAY',
1732: p_message_token => 'PROCEDURE&no rtr id for rules evaluation&STEP&2',
1757: -- Now test to see if the retrieval rule group time recipients
1758: -- is at least a subset of the application set time recipients
1759: IF (test_aps_vs_rtr (t_rtr_tr, t_aps_tr))
1760: THEN
1761: hxc_time_entry_rules_utils_pkg.add_error_to_table
1762: (p_message_table => p_messages,
1763: p_message_name => 'HXC_VLD_APS_VS_RTR_GRP',
1764: p_message_token => NULL,
1765: p_message_level => 'ERROR',
2325: AND effective_end_date;
2326: EXCEPTION
2327: WHEN NO_DATA_FOUND
2328: THEN
2329: hxc_time_entry_rules_utils_pkg.add_error_to_table
2330: (p_message_table => g_messages,
2331: p_message_name => 'HR_52365_PTU_NO_PERSON_EXISTS',
2332: p_message_token => NULL,
2333: p_message_level => 'ERROR',
2524: hr_utility.set_location (l_proc, 61);
2525: END IF;
2526:
2527: -- Raise an error
2528: hxc_time_entry_rules_utils_pkg.add_error_to_table
2529: (p_message_table => g_messages,
2530: p_message_name => 'HXC_366384_NO_HRS_TYPE_ERR',
2531: p_message_token => NULL,
2532: p_message_level => 'ERROR',
2761: IF g_otm_messages.COUNT > 0
2762: THEN
2763: FOR i IN g_otm_messages.FIRST .. g_otm_messages.LAST
2764: LOOP
2765: hxc_time_entry_rules_utils_pkg.add_error_to_table
2766: (p_message_table => g_messages,
2767: p_message_name => g_otm_messages (i).message_name,
2768: p_message_token => g_otm_messages (i).message_tokens,
2769: p_message_level => g_otm_messages (i).message_level,
2790: hr_utility.set_location (l_proc, 74);
2791: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
2792: END IF;
2793:
2794: hxc_time_entry_rules_utils_pkg.add_error_to_table
2795: (p_message_table => g_messages,
2796: p_message_name => 'HXC_HXT_DEP_VAL_OTMERR',
2797: p_message_token => SUBSTR
2798: ( 'ERROR&'
2835: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error
2836: );
2837: END IF;
2838:
2839: hxc_time_entry_rules_utils_pkg.add_error_to_table
2840: (p_message_table => g_messages,
2841: p_message_name => 'HXC_HXT_DEP_VAL_ORAERR',
2842: p_message_token => 'ERROR&'
2843: || l_oracle_error,
3011: IF g_otm_messages.COUNT > 0
3012: THEN
3013: FOR i IN g_otm_messages.FIRST .. g_otm_messages.LAST
3014: LOOP
3015: hxc_time_entry_rules_utils_pkg.add_error_to_table
3016: (p_message_table => g_messages,
3017: p_message_name => g_otm_messages (i).message_name,
3018: p_message_token => g_otm_messages (i).message_tokens,
3019: p_message_level => g_otm_messages (i).message_level,
3040: hr_utility.set_location (l_proc, 2000);
3041: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
3042: END IF;
3043:
3044: hxc_time_entry_rules_utils_pkg.add_error_to_table
3045: (p_message_table => g_messages,
3046: p_message_name => 'HXC_HXT_DEP_VAL_OTMERR',
3047: p_message_token => SUBSTR
3048: ( 'ERROR&'
3076: hr_utility.set_location (l_proc, 2050);
3077: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);
3078: END IF;
3079:
3080: hxc_time_entry_rules_utils_pkg.add_error_to_table
3081: (p_message_table => g_messages,
3082: p_message_name => 'HXC_HXT_DEP_VAL_ORAERR',
3083: p_message_token => 'ERROR&'
3084: || l_oracle_error,