APPS.HXT_TIME_COLLECTION dependencies on FND_MESSAGE

Line 17: g_intg_error VARCHAR2(4000) := fnd_message.get_string('HXC','HXC_PROJ_PAY_NO_OTLR');

13: g_cache BOOLEAN := TRUE;
14: g_max_tc_allowed PLS_INTEGER := fnd_profile.VALUE ('HXT_BATCH_SIZE');
15:
16: -- Bug 12850901
17: g_intg_error VARCHAR2(4000) := fnd_message.get_string('HXC','HXC_PROJ_PAY_NO_OTLR');
18:
19: TYPE batch_info_rec IS RECORD (
20: batch_id pay_batch_headers.batch_id%TYPE,
21: batch_ref pay_batch_headers.batch_reference%TYPE,

Line 2056: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');

2052: THEN
2053: hr_utility.set_location (l_proc, 1140);
2054: END IF;
2055:
2056: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;
2059: otm_error := l_otm_error;
2060: oracle_error := SQLERRM;

Line 2057: fnd_message.set_token ('EMP_NUMBER', employee_number);

2053: hr_utility.set_location (l_proc, 1140);
2054: END IF;
2055:
2056: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;
2059: otm_error := l_otm_error;
2060: oracle_error := SQLERRM;
2061: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2058: l_otm_error := fnd_message.get;

2054: END IF;
2055:
2056: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;
2059: otm_error := l_otm_error;
2060: oracle_error := SQLERRM;
2061: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2062: --2278400

Line 2071: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');

2067: THEN
2068: hr_utility.set_location (l_proc, 1150);
2069: END IF;
2070:
2071: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');
2072: fnd_message.set_token ('EMP_NUMBER', employee_number);
2073: l_otm_error := fnd_message.get;
2074: otm_error := l_otm_error;
2075: oracle_error := SQLERRM;

Line 2072: fnd_message.set_token ('EMP_NUMBER', employee_number);

2068: hr_utility.set_location (l_proc, 1150);
2069: END IF;
2070:
2071: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');
2072: fnd_message.set_token ('EMP_NUMBER', employee_number);
2073: l_otm_error := fnd_message.get;
2074: otm_error := l_otm_error;
2075: oracle_error := SQLERRM;
2076: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2073: l_otm_error := fnd_message.get;

2069: END IF;
2070:
2071: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');
2072: fnd_message.set_token ('EMP_NUMBER', employee_number);
2073: l_otm_error := fnd_message.get;
2074: otm_error := l_otm_error;
2075: oracle_error := SQLERRM;
2076: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2077: --2278400

Line 2086: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');

2082: THEN
2083: hr_utility.set_location (l_proc, 1160);
2084: END IF;
2085:
2086: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');
2087: fnd_message.set_token ('APP_NUMBER', approver_number);
2088: l_otm_error := fnd_message.get;
2089: otm_error := l_otm_error;
2090: oracle_error := SQLERRM;

Line 2087: fnd_message.set_token ('APP_NUMBER', approver_number);

2083: hr_utility.set_location (l_proc, 1160);
2084: END IF;
2085:
2086: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');
2087: fnd_message.set_token ('APP_NUMBER', approver_number);
2088: l_otm_error := fnd_message.get;
2089: otm_error := l_otm_error;
2090: oracle_error := SQLERRM;
2091: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2088: l_otm_error := fnd_message.get;

2084: END IF;
2085:
2086: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');
2087: fnd_message.set_token ('APP_NUMBER', approver_number);
2088: l_otm_error := fnd_message.get;
2089: otm_error := l_otm_error;
2090: oracle_error := SQLERRM;
2091: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2092: --2278400

Line 2101: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');

2097: THEN
2098: hr_utility.set_location (l_proc, 1170);
2099: END IF;
2100:
2101: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');
2102: fnd_message.set_token ('APP_NUMBER', approver_number);
2103: l_otm_error := fnd_message.get;
2104: otm_error := l_otm_error;
2105: oracle_error := SQLERRM;

Line 2102: fnd_message.set_token ('APP_NUMBER', approver_number);

2098: hr_utility.set_location (l_proc, 1170);
2099: END IF;
2100:
2101: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');
2102: fnd_message.set_token ('APP_NUMBER', approver_number);
2103: l_otm_error := fnd_message.get;
2104: otm_error := l_otm_error;
2105: oracle_error := SQLERRM;
2106: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2103: l_otm_error := fnd_message.get;

2099: END IF;
2100:
2101: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');
2102: fnd_message.set_token ('APP_NUMBER', approver_number);
2103: l_otm_error := fnd_message.get;
2104: otm_error := l_otm_error;
2105: oracle_error := SQLERRM;
2106: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2107: --2278400

Line 2116: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');

2112: THEN
2113: hr_utility.set_location (l_proc, 1180);
2114: END IF;
2115:
2116: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2117: fnd_message.set_token ('FIRST_NAME', l_first_name);
2118: fnd_message.set_token ('LAST_NAME', l_last_name);
2119: fnd_message.set_token ('EMP_NUMBER', employee_number);
2120: l_otm_error := fnd_message.get;

Line 2117: fnd_message.set_token ('FIRST_NAME', l_first_name);

2113: hr_utility.set_location (l_proc, 1180);
2114: END IF;
2115:
2116: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2117: fnd_message.set_token ('FIRST_NAME', l_first_name);
2118: fnd_message.set_token ('LAST_NAME', l_last_name);
2119: fnd_message.set_token ('EMP_NUMBER', employee_number);
2120: l_otm_error := fnd_message.get;
2121: otm_error := l_otm_error;

Line 2118: fnd_message.set_token ('LAST_NAME', l_last_name);

2114: END IF;
2115:
2116: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2117: fnd_message.set_token ('FIRST_NAME', l_first_name);
2118: fnd_message.set_token ('LAST_NAME', l_last_name);
2119: fnd_message.set_token ('EMP_NUMBER', employee_number);
2120: l_otm_error := fnd_message.get;
2121: otm_error := l_otm_error;
2122: oracle_error := SQLERRM;

Line 2119: fnd_message.set_token ('EMP_NUMBER', employee_number);

2115:
2116: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2117: fnd_message.set_token ('FIRST_NAME', l_first_name);
2118: fnd_message.set_token ('LAST_NAME', l_last_name);
2119: fnd_message.set_token ('EMP_NUMBER', employee_number);
2120: l_otm_error := fnd_message.get;
2121: otm_error := l_otm_error;
2122: oracle_error := SQLERRM;
2123: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2120: l_otm_error := fnd_message.get;

2116: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2117: fnd_message.set_token ('FIRST_NAME', l_first_name);
2118: fnd_message.set_token ('LAST_NAME', l_last_name);
2119: fnd_message.set_token ('EMP_NUMBER', employee_number);
2120: l_otm_error := fnd_message.get;
2121: otm_error := l_otm_error;
2122: oracle_error := SQLERRM;
2123: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2124: --2278400

Line 2133: fnd_message.set_name ('HXT', 'HXT_39319_ERR_GET_ASSIGN');

2129: THEN
2130: hr_utility.set_location (l_proc, 1190);
2131: END IF;
2132:
2133: fnd_message.set_name ('HXT', 'HXT_39319_ERR_GET_ASSIGN');
2134: l_otm_error := fnd_message.get;
2135: otm_error := l_otm_error;
2136: oracle_error := SQLERRM;
2137: call_hxthxc_gen_error ('HXT', 'HXT_39319_ERR_GET_ASSIGN', NULL);

Line 2134: l_otm_error := fnd_message.get;

2130: hr_utility.set_location (l_proc, 1190);
2131: END IF;
2132:
2133: fnd_message.set_name ('HXT', 'HXT_39319_ERR_GET_ASSIGN');
2134: l_otm_error := fnd_message.get;
2135: otm_error := l_otm_error;
2136: oracle_error := SQLERRM;
2137: call_hxthxc_gen_error ('HXT', 'HXT_39319_ERR_GET_ASSIGN', NULL);
2138: --2278400

Line 2147: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');

2143: THEN
2144: hr_utility.set_location (l_proc, 1200);
2145: END IF;
2146:
2147: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');
2148: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));
2149: l_otm_error := fnd_message.get;
2150: otm_error := l_otm_error;
2151: oracle_error := SQLERRM;

Line 2148: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));

2144: hr_utility.set_location (l_proc, 1200);
2145: END IF;
2146:
2147: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');
2148: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));
2149: l_otm_error := fnd_message.get;
2150: otm_error := l_otm_error;
2151: oracle_error := SQLERRM;
2152: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2149: l_otm_error := fnd_message.get;

2145: END IF;
2146:
2147: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');
2148: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));
2149: l_otm_error := fnd_message.get;
2150: otm_error := l_otm_error;
2151: oracle_error := SQLERRM;
2152: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2153: --2278400

Line 2162: fnd_message.set_name ('HXT', 'HXT_39323_ERR_DATE_WRKED');

2158: THEN
2159: hr_utility.set_location (l_proc, 1210);
2160: END IF;
2161:
2162: fnd_message.set_name ('HXT', 'HXT_39323_ERR_DATE_WRKED');
2163: l_otm_error := fnd_message.get;
2164: otm_error := l_otm_error;
2165: oracle_error := SQLERRM;
2166: call_hxthxc_gen_error ('HXT', 'HXT_39323_ERR_DATE_WRKED', NULL);

Line 2163: l_otm_error := fnd_message.get;

2159: hr_utility.set_location (l_proc, 1210);
2160: END IF;
2161:
2162: fnd_message.set_name ('HXT', 'HXT_39323_ERR_DATE_WRKED');
2163: l_otm_error := fnd_message.get;
2164: otm_error := l_otm_error;
2165: oracle_error := SQLERRM;
2166: call_hxthxc_gen_error ('HXT', 'HXT_39323_ERR_DATE_WRKED', NULL);
2167: --2278400

Line 2176: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');

2172: THEN
2173: hr_utility.set_location (l_proc, 1220);
2174: END IF;
2175:
2176: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');
2177: fnd_message.set_token ('WAGE_CODE', wage_code);
2178: l_error_text := fnd_message.get;
2179: otm_error := l_error_text;
2180: oracle_error := SQLERRM;

Line 2177: fnd_message.set_token ('WAGE_CODE', wage_code);

2173: hr_utility.set_location (l_proc, 1220);
2174: END IF;
2175:
2176: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');
2177: fnd_message.set_token ('WAGE_CODE', wage_code);
2178: l_error_text := fnd_message.get;
2179: otm_error := l_error_text;
2180: oracle_error := SQLERRM;
2181: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);

Line 2178: l_error_text := fnd_message.get;

2174: END IF;
2175:
2176: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');
2177: fnd_message.set_token ('WAGE_CODE', wage_code);
2178: l_error_text := fnd_message.get;
2179: otm_error := l_error_text;
2180: oracle_error := SQLERRM;
2181: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
2182: --2278400

Line 2191: fnd_message.set_name ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR');

2187: THEN
2188: hr_utility.set_location (l_proc, 1230);
2189: END IF;
2190:
2191: fnd_message.set_name ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR');
2192: l_error_text := fnd_message.get;
2193: otm_error := l_error_text;
2194: oracle_error := SQLERRM;
2195: call_hxthxc_gen_error ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR', NULL);

Line 2192: l_error_text := fnd_message.get;

2188: hr_utility.set_location (l_proc, 1230);
2189: END IF;
2190:
2191: fnd_message.set_name ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR');
2192: l_error_text := fnd_message.get;
2193: otm_error := l_error_text;
2194: oracle_error := SQLERRM;
2195: call_hxthxc_gen_error ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR', NULL);
2196: --2278400

Line 2205: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');

2201: THEN
2202: hr_utility.set_location (l_proc, 1240);
2203: END IF;
2204:
2205: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');
2206: fnd_message.set_token ('HRS_TYPE', hours_type);
2207: l_otm_error := fnd_message.get;
2208: otm_error := l_otm_error;
2209: oracle_error := SQLERRM;

Line 2206: fnd_message.set_token ('HRS_TYPE', hours_type);

2202: hr_utility.set_location (l_proc, 1240);
2203: END IF;
2204:
2205: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');
2206: fnd_message.set_token ('HRS_TYPE', hours_type);
2207: l_otm_error := fnd_message.get;
2208: otm_error := l_otm_error;
2209: oracle_error := SQLERRM;
2210: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);

Line 2207: l_otm_error := fnd_message.get;

2203: END IF;
2204:
2205: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');
2206: fnd_message.set_token ('HRS_TYPE', hours_type);
2207: l_otm_error := fnd_message.get;
2208: otm_error := l_otm_error;
2209: oracle_error := SQLERRM;
2210: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
2211: --2278400

Line 2220: fnd_message.set_name ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR');

2216: THEN
2217: hr_utility.set_location (l_proc, 1250);
2218: END IF;
2219:
2220: fnd_message.set_name ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR');
2221: l_otm_error := fnd_message.get;
2222: otm_error := l_otm_error;
2223: oracle_error := SQLERRM;
2224: call_hxthxc_gen_error ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR', NULL);

Line 2221: l_otm_error := fnd_message.get;

2217: hr_utility.set_location (l_proc, 1250);
2218: END IF;
2219:
2220: fnd_message.set_name ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR');
2221: l_otm_error := fnd_message.get;
2222: otm_error := l_otm_error;
2223: oracle_error := SQLERRM;
2224: call_hxthxc_gen_error ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR', NULL);
2225: --2278400

Line 2234: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');

2230: THEN
2231: hr_utility.set_location (l_proc, 1260);
2232: END IF;
2233:
2234: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');
2235: fnd_message.set_token ('HRS_TYPE', hours_type);
2236: l_otm_error := fnd_message.get;
2237: otm_error := l_otm_error;
2238: oracle_error := SQLERRM;

Line 2235: fnd_message.set_token ('HRS_TYPE', hours_type);

2231: hr_utility.set_location (l_proc, 1260);
2232: END IF;
2233:
2234: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');
2235: fnd_message.set_token ('HRS_TYPE', hours_type);
2236: l_otm_error := fnd_message.get;
2237: otm_error := l_otm_error;
2238: oracle_error := SQLERRM;
2239: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2236: l_otm_error := fnd_message.get;

2232: END IF;
2233:
2234: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');
2235: fnd_message.set_token ('HRS_TYPE', hours_type);
2236: l_otm_error := fnd_message.get;
2237: otm_error := l_otm_error;
2238: oracle_error := SQLERRM;
2239: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2240: --2278400

Line 2249: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_SYS_ERR');

2245: THEN
2246: hr_utility.set_location (l_proc, 1270);
2247: END IF;
2248:
2249: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_SYS_ERR');
2250: l_otm_error := fnd_message.get;
2251: otm_error := l_otm_error;
2252: oracle_error := SQLERRM;
2253: call_hxthxc_gen_error ('HXT', 'HXT_ELEM_LINK_SYS_ERR', NULL);

Line 2250: l_otm_error := fnd_message.get;

2246: hr_utility.set_location (l_proc, 1270);
2247: END IF;
2248:
2249: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_SYS_ERR');
2250: l_otm_error := fnd_message.get;
2251: otm_error := l_otm_error;
2252: oracle_error := SQLERRM;
2253: call_hxthxc_gen_error ('HXT', 'HXT_ELEM_LINK_SYS_ERR', NULL);
2254: --2278400

Line 2263: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');

2259: THEN
2260: hr_utility.set_location (l_proc, 1280);
2261: END IF;
2262:
2263: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');
2264: fnd_message.set_token ('TASK_NUMBER', task_number);
2265: l_otm_error := fnd_message.get;
2266: otm_error := l_otm_error;
2267: oracle_error := SQLERRM;

Line 2264: fnd_message.set_token ('TASK_NUMBER', task_number);

2260: hr_utility.set_location (l_proc, 1280);
2261: END IF;
2262:
2263: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');
2264: fnd_message.set_token ('TASK_NUMBER', task_number);
2265: l_otm_error := fnd_message.get;
2266: otm_error := l_otm_error;
2267: oracle_error := SQLERRM;
2268: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2265: l_otm_error := fnd_message.get;

2261: END IF;
2262:
2263: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');
2264: fnd_message.set_token ('TASK_NUMBER', task_number);
2265: l_otm_error := fnd_message.get;
2266: otm_error := l_otm_error;
2267: oracle_error := SQLERRM;
2268: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2269: --2278400

Line 2278: fnd_message.set_name ('HXT', 'HXT_39537_TASK_ID_SYS_ERR');

2274: THEN
2275: hr_utility.set_location (l_proc, 1290);
2276: END IF;
2277:
2278: fnd_message.set_name ('HXT', 'HXT_39537_TASK_ID_SYS_ERR');
2279: l_otm_error := fnd_message.get;
2280: otm_error := l_otm_error;
2281: oracle_error := SQLERRM;
2282: RETURN;

Line 2279: l_otm_error := fnd_message.get;

2275: hr_utility.set_location (l_proc, 1290);
2276: END IF;
2277:
2278: fnd_message.set_name ('HXT', 'HXT_39537_TASK_ID_SYS_ERR');
2279: l_otm_error := fnd_message.get;
2280: otm_error := l_otm_error;
2281: oracle_error := SQLERRM;
2282: RETURN;
2283: WHEN l_locn_id_data_err

Line 2290: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');

2286: THEN
2287: hr_utility.set_location (l_proc, 1300);
2288: END IF;
2289:
2290: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');
2291: fnd_message.set_token ('LOC_CODE', location_code);
2292: l_otm_error := fnd_message.get;
2293: otm_error := l_otm_error;
2294: oracle_error := SQLERRM;

Line 2291: fnd_message.set_token ('LOC_CODE', location_code);

2287: hr_utility.set_location (l_proc, 1300);
2288: END IF;
2289:
2290: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');
2291: fnd_message.set_token ('LOC_CODE', location_code);
2292: l_otm_error := fnd_message.get;
2293: otm_error := l_otm_error;
2294: oracle_error := SQLERRM;
2295: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2292: l_otm_error := fnd_message.get;

2288: END IF;
2289:
2290: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');
2291: fnd_message.set_token ('LOC_CODE', location_code);
2292: l_otm_error := fnd_message.get;
2293: otm_error := l_otm_error;
2294: oracle_error := SQLERRM;
2295: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2296: --2278400

Line 2305: fnd_message.set_name ('HXT', 'HXT_39539_LOC_ID_SYS_ERR');

2301: THEN
2302: hr_utility.set_location (l_proc, 1310);
2303: END IF;
2304:
2305: fnd_message.set_name ('HXT', 'HXT_39539_LOC_ID_SYS_ERR');
2306: l_otm_error := fnd_message.get;
2307: otm_error := l_otm_error;
2308: oracle_error := SQLERRM;
2309: call_hxthxc_gen_error ('HXT', 'HXT_39539_LOC_ID_SYS_ERR', NULL);

Line 2306: l_otm_error := fnd_message.get;

2302: hr_utility.set_location (l_proc, 1310);
2303: END IF;
2304:
2305: fnd_message.set_name ('HXT', 'HXT_39539_LOC_ID_SYS_ERR');
2306: l_otm_error := fnd_message.get;
2307: otm_error := l_otm_error;
2308: oracle_error := SQLERRM;
2309: call_hxthxc_gen_error ('HXT', 'HXT_39539_LOC_ID_SYS_ERR', NULL);
2310: --2278400

Line 2319: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');

2315: THEN
2316: hr_utility.set_location (l_proc, 1320);
2317: END IF;
2318:
2319: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');
2320: fnd_message.set_token ('PRJ_NUMBER', project);
2321: l_otm_error := fnd_message.get;
2322: otm_error := l_otm_error;
2323: oracle_error := SQLERRM;

Line 2320: fnd_message.set_token ('PRJ_NUMBER', project);

2316: hr_utility.set_location (l_proc, 1320);
2317: END IF;
2318:
2319: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');
2320: fnd_message.set_token ('PRJ_NUMBER', project);
2321: l_otm_error := fnd_message.get;
2322: otm_error := l_otm_error;
2323: oracle_error := SQLERRM;
2324: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2321: l_otm_error := fnd_message.get;

2317: END IF;
2318:
2319: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');
2320: fnd_message.set_token ('PRJ_NUMBER', project);
2321: l_otm_error := fnd_message.get;
2322: otm_error := l_otm_error;
2323: oracle_error := SQLERRM;
2324: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2325: --2278400

Line 2334: fnd_message.set_name ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR');

2330: THEN
2331: hr_utility.set_location (l_proc, 1330);
2332: END IF;
2333:
2334: fnd_message.set_name ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR');
2335: l_otm_error := fnd_message.get;
2336: otm_error := l_otm_error;
2337: oracle_error := SQLERRM;
2338: call_hxthxc_gen_error ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR', NULL);

Line 2335: l_otm_error := fnd_message.get;

2331: hr_utility.set_location (l_proc, 1330);
2332: END IF;
2333:
2334: fnd_message.set_name ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR');
2335: l_otm_error := fnd_message.get;
2336: otm_error := l_otm_error;
2337: oracle_error := SQLERRM;
2338: call_hxthxc_gen_error ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR', NULL);
2339: --2278400

Line 2348: fnd_message.set_name ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE');

2344: THEN
2345: hr_utility.set_location (l_proc, 1340);
2346: END IF;
2347:
2348: fnd_message.set_name ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE');
2349: l_otm_error := fnd_message.get;
2350: otm_error := l_otm_error;
2351: oracle_error := SQLERRM;
2352: call_hxthxc_gen_error ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE', NULL);

Line 2349: l_otm_error := fnd_message.get;

2345: hr_utility.set_location (l_proc, 1340);
2346: END IF;
2347:
2348: fnd_message.set_name ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE');
2349: l_otm_error := fnd_message.get;
2350: otm_error := l_otm_error;
2351: oracle_error := SQLERRM;
2352: call_hxthxc_gen_error ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE', NULL);
2353: --2278400

Line 2362: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');

2358: THEN
2359: hr_utility.set_location (l_proc, 1350);
2360: END IF;
2361:
2362: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');
2363: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);
2364: l_otm_error := fnd_message.get;
2365: otm_error := l_otm_error;
2366: oracle_error := SQLERRM;

Line 2363: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);

2359: hr_utility.set_location (l_proc, 1350);
2360: END IF;
2361:
2362: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');
2363: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);
2364: l_otm_error := fnd_message.get;
2365: otm_error := l_otm_error;
2366: oracle_error := SQLERRM;
2367: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2364: l_otm_error := fnd_message.get;

2360: END IF;
2361:
2362: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');
2363: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);
2364: l_otm_error := fnd_message.get;
2365: otm_error := l_otm_error;
2366: oracle_error := SQLERRM;
2367: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2368: --2278400

Line 2377: fnd_message.set_name ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR');

2373: THEN
2374: hr_utility.set_location (l_proc, 1360);
2375: END IF;
2376:
2377: fnd_message.set_name ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR');
2378: l_otm_error := fnd_message.get;
2379: otm_error := l_otm_error;
2380: oracle_error := SQLERRM;
2381: call_hxthxc_gen_error ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR', NULL);

Line 2378: l_otm_error := fnd_message.get;

2374: hr_utility.set_location (l_proc, 1360);
2375: END IF;
2376:
2377: fnd_message.set_name ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR');
2378: l_otm_error := fnd_message.get;
2379: otm_error := l_otm_error;
2380: oracle_error := SQLERRM;
2381: call_hxthxc_gen_error ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR', NULL);
2382: --2278400

Line 2391: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');

2387: THEN
2388: hr_utility.set_location (l_proc, 1370);
2389: END IF;
2390:
2391: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');
2392: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);
2393: l_otm_error := fnd_message.get;
2394: otm_error := l_otm_error;
2395: oracle_error := SQLERRM;

Line 2392: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);

2388: hr_utility.set_location (l_proc, 1370);
2389: END IF;
2390:
2391: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');
2392: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);
2393: l_otm_error := fnd_message.get;
2394: otm_error := l_otm_error;
2395: oracle_error := SQLERRM;
2396: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2393: l_otm_error := fnd_message.get;

2389: END IF;
2390:
2391: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');
2392: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);
2393: l_otm_error := fnd_message.get;
2394: otm_error := l_otm_error;
2395: oracle_error := SQLERRM;
2396: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2397: --2278400

Line 2406: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');

2402: THEN
2403: hr_utility.set_location (l_proc, 1380);
2404: END IF;
2405:
2406: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2407: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2408: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2409: l_otm_error := fnd_message.get;
2410: otm_error := l_otm_error;

Line 2407: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));

2403: hr_utility.set_location (l_proc, 1380);
2404: END IF;
2405:
2406: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2407: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2408: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2409: l_otm_error := fnd_message.get;
2410: otm_error := l_otm_error;
2411: oracle_error := SQLERRM;

Line 2408: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));

2404: END IF;
2405:
2406: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2407: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2408: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2409: l_otm_error := fnd_message.get;
2410: otm_error := l_otm_error;
2411: oracle_error := SQLERRM;
2412: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2409: l_otm_error := fnd_message.get;

2405:
2406: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2407: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2408: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2409: l_otm_error := fnd_message.get;
2410: otm_error := l_otm_error;
2411: oracle_error := SQLERRM;
2412: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2413: --2278400

Line 2422: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');

2418: THEN
2419: hr_utility.set_location (l_proc, 1390);
2420: END IF;
2421:
2422: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');
2423: fnd_message.set_token ('SQLERR', SQLERRM);
2424: l_otm_error := fnd_message.get;
2425: otm_error := l_otm_error;
2426: oracle_error := SQLERRM;

Line 2423: fnd_message.set_token ('SQLERR', SQLERRM);

2419: hr_utility.set_location (l_proc, 1390);
2420: END IF;
2421:
2422: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');
2423: fnd_message.set_token ('SQLERR', SQLERRM);
2424: l_otm_error := fnd_message.get;
2425: otm_error := l_otm_error;
2426: oracle_error := SQLERRM;
2427: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2424: l_otm_error := fnd_message.get;

2420: END IF;
2421:
2422: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');
2423: fnd_message.set_token ('SQLERR', SQLERRM);
2424: l_otm_error := fnd_message.get;
2425: otm_error := l_otm_error;
2426: oracle_error := SQLERRM;
2427: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2428: --2278400

Line 2437: fnd_message.set_name ('HXT', 'HXT_39298_ERR_GET_TIMCARD');

2433: THEN
2434: hr_utility.set_location (l_proc, 1400);
2435: END IF;
2436:
2437: fnd_message.set_name ('HXT', 'HXT_39298_ERR_GET_TIMCARD');
2438: l_otm_error := fnd_message.get;
2439: otm_error := l_otm_error;
2440: oracle_error := SQLERRM;
2441: call_hxthxc_gen_error ('HXT', 'HXT_39298_ERR_GET_TIMCARD', NULL);

Line 2438: l_otm_error := fnd_message.get;

2434: hr_utility.set_location (l_proc, 1400);
2435: END IF;
2436:
2437: fnd_message.set_name ('HXT', 'HXT_39298_ERR_GET_TIMCARD');
2438: l_otm_error := fnd_message.get;
2439: otm_error := l_otm_error;
2440: oracle_error := SQLERRM;
2441: call_hxthxc_gen_error ('HXT', 'HXT_39298_ERR_GET_TIMCARD', NULL);
2442: --2278400

Line 2451: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');

2447: THEN
2448: hr_utility.set_location (l_proc, 1410);
2449: END IF;
2450:
2451: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2452: fnd_message.set_token ('FIRST_NAME', l_first_name);
2453: fnd_message.set_token ('LAST_NAME', l_last_name);
2454: fnd_message.set_token ('EMP_NUMBER', employee_number);
2455: l_otm_error := fnd_message.get;

Line 2452: fnd_message.set_token ('FIRST_NAME', l_first_name);

2448: hr_utility.set_location (l_proc, 1410);
2449: END IF;
2450:
2451: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2452: fnd_message.set_token ('FIRST_NAME', l_first_name);
2453: fnd_message.set_token ('LAST_NAME', l_last_name);
2454: fnd_message.set_token ('EMP_NUMBER', employee_number);
2455: l_otm_error := fnd_message.get;
2456: otm_error := l_otm_error;

Line 2453: fnd_message.set_token ('LAST_NAME', l_last_name);

2449: END IF;
2450:
2451: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2452: fnd_message.set_token ('FIRST_NAME', l_first_name);
2453: fnd_message.set_token ('LAST_NAME', l_last_name);
2454: fnd_message.set_token ('EMP_NUMBER', employee_number);
2455: l_otm_error := fnd_message.get;
2456: otm_error := l_otm_error;
2457: oracle_error := SQLERRM;

Line 2454: fnd_message.set_token ('EMP_NUMBER', employee_number);

2450:
2451: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2452: fnd_message.set_token ('FIRST_NAME', l_first_name);
2453: fnd_message.set_token ('LAST_NAME', l_last_name);
2454: fnd_message.set_token ('EMP_NUMBER', employee_number);
2455: l_otm_error := fnd_message.get;
2456: otm_error := l_otm_error;
2457: oracle_error := SQLERRM;
2458: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2455: l_otm_error := fnd_message.get;

2451: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2452: fnd_message.set_token ('FIRST_NAME', l_first_name);
2453: fnd_message.set_token ('LAST_NAME', l_last_name);
2454: fnd_message.set_token ('EMP_NUMBER', employee_number);
2455: l_otm_error := fnd_message.get;
2456: otm_error := l_otm_error;
2457: oracle_error := SQLERRM;
2458: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2459: --2278400

Line 2468: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');

2464: THEN
2465: hr_utility.set_location (l_proc, 1420);
2466: END IF;
2467:
2468: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2469: fnd_message.set_token ('FIRST_NAME', l_first_name);
2470: fnd_message.set_token ('LAST_NAME', l_last_name);
2471: fnd_message.set_token ('EMP_NUMBER', employee_number);
2472: l_otm_error := fnd_message.get;

Line 2469: fnd_message.set_token ('FIRST_NAME', l_first_name);

2465: hr_utility.set_location (l_proc, 1420);
2466: END IF;
2467:
2468: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2469: fnd_message.set_token ('FIRST_NAME', l_first_name);
2470: fnd_message.set_token ('LAST_NAME', l_last_name);
2471: fnd_message.set_token ('EMP_NUMBER', employee_number);
2472: l_otm_error := fnd_message.get;
2473: otm_error := l_otm_error;

Line 2470: fnd_message.set_token ('LAST_NAME', l_last_name);

2466: END IF;
2467:
2468: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2469: fnd_message.set_token ('FIRST_NAME', l_first_name);
2470: fnd_message.set_token ('LAST_NAME', l_last_name);
2471: fnd_message.set_token ('EMP_NUMBER', employee_number);
2472: l_otm_error := fnd_message.get;
2473: otm_error := l_otm_error;
2474: oracle_error := SQLERRM;

Line 2471: fnd_message.set_token ('EMP_NUMBER', employee_number);

2467:
2468: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2469: fnd_message.set_token ('FIRST_NAME', l_first_name);
2470: fnd_message.set_token ('LAST_NAME', l_last_name);
2471: fnd_message.set_token ('EMP_NUMBER', employee_number);
2472: l_otm_error := fnd_message.get;
2473: otm_error := l_otm_error;
2474: oracle_error := SQLERRM;
2475: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2472: l_otm_error := fnd_message.get;

2468: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2469: fnd_message.set_token ('FIRST_NAME', l_first_name);
2470: fnd_message.set_token ('LAST_NAME', l_last_name);
2471: fnd_message.set_token ('EMP_NUMBER', employee_number);
2472: l_otm_error := fnd_message.get;
2473: otm_error := l_otm_error;
2474: oracle_error := SQLERRM;
2475: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2476: --2278400

Line 2485: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');

2481: THEN
2482: hr_utility.set_location (l_proc, 1430);
2483: END IF;
2484:
2485: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2486: fnd_message.set_token ('FIRST_NAME', l_first_name);
2487: fnd_message.set_token ('LAST_NAME', l_last_name);
2488: fnd_message.set_token ('EMP_NUMBER', employee_number);
2489: l_otm_error := fnd_message.get;

Line 2486: fnd_message.set_token ('FIRST_NAME', l_first_name);

2482: hr_utility.set_location (l_proc, 1430);
2483: END IF;
2484:
2485: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2486: fnd_message.set_token ('FIRST_NAME', l_first_name);
2487: fnd_message.set_token ('LAST_NAME', l_last_name);
2488: fnd_message.set_token ('EMP_NUMBER', employee_number);
2489: l_otm_error := fnd_message.get;
2490: l_oracle_error := SQLERRM;

Line 2487: fnd_message.set_token ('LAST_NAME', l_last_name);

2483: END IF;
2484:
2485: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2486: fnd_message.set_token ('FIRST_NAME', l_first_name);
2487: fnd_message.set_token ('LAST_NAME', l_last_name);
2488: fnd_message.set_token ('EMP_NUMBER', employee_number);
2489: l_otm_error := fnd_message.get;
2490: l_oracle_error := SQLERRM;
2491: otm_error := l_otm_error;

Line 2488: fnd_message.set_token ('EMP_NUMBER', employee_number);

2484:
2485: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2486: fnd_message.set_token ('FIRST_NAME', l_first_name);
2487: fnd_message.set_token ('LAST_NAME', l_last_name);
2488: fnd_message.set_token ('EMP_NUMBER', employee_number);
2489: l_otm_error := fnd_message.get;
2490: l_oracle_error := SQLERRM;
2491: otm_error := l_otm_error;
2492: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2489: l_otm_error := fnd_message.get;

2485: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2486: fnd_message.set_token ('FIRST_NAME', l_first_name);
2487: fnd_message.set_token ('LAST_NAME', l_last_name);
2488: fnd_message.set_token ('EMP_NUMBER', employee_number);
2489: l_otm_error := fnd_message.get;
2490: l_oracle_error := SQLERRM;
2491: otm_error := l_otm_error;
2492: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2493: --2278400

Line 2503: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');

2499: THEN
2500: hr_utility.set_location (l_proc, 1440);
2501: END IF;
2502:
2503: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2504: fnd_message.set_token ('FIRST_NAME', l_first_name);
2505: fnd_message.set_token ('LAST_NAME', l_last_name);
2506: fnd_message.set_token ('EMP_NUMBER', employee_number);
2507: l_otm_error := fnd_message.get;

Line 2504: fnd_message.set_token ('FIRST_NAME', l_first_name);

2500: hr_utility.set_location (l_proc, 1440);
2501: END IF;
2502:
2503: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2504: fnd_message.set_token ('FIRST_NAME', l_first_name);
2505: fnd_message.set_token ('LAST_NAME', l_last_name);
2506: fnd_message.set_token ('EMP_NUMBER', employee_number);
2507: l_otm_error := fnd_message.get;
2508: otm_error := l_otm_error;

Line 2505: fnd_message.set_token ('LAST_NAME', l_last_name);

2501: END IF;
2502:
2503: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2504: fnd_message.set_token ('FIRST_NAME', l_first_name);
2505: fnd_message.set_token ('LAST_NAME', l_last_name);
2506: fnd_message.set_token ('EMP_NUMBER', employee_number);
2507: l_otm_error := fnd_message.get;
2508: otm_error := l_otm_error;
2509: oracle_error := SQLERRM;

Line 2506: fnd_message.set_token ('EMP_NUMBER', employee_number);

2502:
2503: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2504: fnd_message.set_token ('FIRST_NAME', l_first_name);
2505: fnd_message.set_token ('LAST_NAME', l_last_name);
2506: fnd_message.set_token ('EMP_NUMBER', employee_number);
2507: l_otm_error := fnd_message.get;
2508: otm_error := l_otm_error;
2509: oracle_error := SQLERRM;
2510: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2507: l_otm_error := fnd_message.get;

2503: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2504: fnd_message.set_token ('FIRST_NAME', l_first_name);
2505: fnd_message.set_token ('LAST_NAME', l_last_name);
2506: fnd_message.set_token ('EMP_NUMBER', employee_number);
2507: l_otm_error := fnd_message.get;
2508: otm_error := l_otm_error;
2509: oracle_error := SQLERRM;
2510: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2511: --2278400

Line 2520: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');

2516: THEN
2517: hr_utility.set_location (l_proc, 1450);
2518: END IF;
2519:
2520: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2521: fnd_message.set_token ('FIRST_NAME', l_first_name);
2522: fnd_message.set_token ('LAST_NAME', l_last_name);
2523: fnd_message.set_token ('EMP_NUMBER', employee_number);
2524: l_otm_error := fnd_message.get;

Line 2521: fnd_message.set_token ('FIRST_NAME', l_first_name);

2517: hr_utility.set_location (l_proc, 1450);
2518: END IF;
2519:
2520: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2521: fnd_message.set_token ('FIRST_NAME', l_first_name);
2522: fnd_message.set_token ('LAST_NAME', l_last_name);
2523: fnd_message.set_token ('EMP_NUMBER', employee_number);
2524: l_otm_error := fnd_message.get;
2525: otm_error := l_otm_error;

Line 2522: fnd_message.set_token ('LAST_NAME', l_last_name);

2518: END IF;
2519:
2520: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2521: fnd_message.set_token ('FIRST_NAME', l_first_name);
2522: fnd_message.set_token ('LAST_NAME', l_last_name);
2523: fnd_message.set_token ('EMP_NUMBER', employee_number);
2524: l_otm_error := fnd_message.get;
2525: otm_error := l_otm_error;
2526: oracle_error := SQLERRM;

Line 2523: fnd_message.set_token ('EMP_NUMBER', employee_number);

2519:
2520: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2521: fnd_message.set_token ('FIRST_NAME', l_first_name);
2522: fnd_message.set_token ('LAST_NAME', l_last_name);
2523: fnd_message.set_token ('EMP_NUMBER', employee_number);
2524: l_otm_error := fnd_message.get;
2525: otm_error := l_otm_error;
2526: oracle_error := SQLERRM;
2527: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2524: l_otm_error := fnd_message.get;

2520: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2521: fnd_message.set_token ('FIRST_NAME', l_first_name);
2522: fnd_message.set_token ('LAST_NAME', l_last_name);
2523: fnd_message.set_token ('EMP_NUMBER', employee_number);
2524: l_otm_error := fnd_message.get;
2525: otm_error := l_otm_error;
2526: oracle_error := SQLERRM;
2527: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2528: --2278400

Line 2542: fnd_message.set_name ('HXT', 'HXT_39293_REC_HRS_ERR');

2538: -- there is no point writing over a specific system error
2539: -- with a generic translated error
2540: IF (l_otm_error IS NULL)
2541: THEN
2542: fnd_message.set_name ('HXT', 'HXT_39293_REC_HRS_ERR');
2543: l_otm_error := fnd_message.get;
2544: END IF;
2545:
2546: otm_error := l_otm_error;

Line 2543: l_otm_error := fnd_message.get;

2539: -- with a generic translated error
2540: IF (l_otm_error IS NULL)
2541: THEN
2542: fnd_message.set_name ('HXT', 'HXT_39293_REC_HRS_ERR');
2543: l_otm_error := fnd_message.get;
2544: END IF;
2545:
2546: otm_error := l_otm_error;
2547:

Line 2570: fnd_message.set_name ('HXT', 'HXT_39321_ERR_REC_HRS');

2566: -- there is no point writing over a specific system error
2567: -- with a generic translated error
2568: IF (l_otm_error IS NULL)
2569: THEN
2570: fnd_message.set_name ('HXT', 'HXT_39321_ERR_REC_HRS');
2571: l_otm_error := fnd_message.get;
2572: END IF;
2573:
2574: otm_error := l_otm_error;

Line 2571: l_otm_error := fnd_message.get;

2567: -- with a generic translated error
2568: IF (l_otm_error IS NULL)
2569: THEN
2570: fnd_message.set_name ('HXT', 'HXT_39321_ERR_REC_HRS');
2571: l_otm_error := fnd_message.get;
2572: END IF;
2573:
2574: otm_error := l_otm_error;
2575:

Line 2583: l_otm_error := fnd_message.get;

2579: ELSE
2580: oracle_error := l_oracle_error;
2581: END IF;
2582:
2583: l_otm_error := fnd_message.get;
2584: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2585: --2278400
2586: RETURN;
2587: WHEN l_hours_amount_data_err

Line 2594: fnd_message.set_name ('HXT', 'HXT_39527_HRS_REQ_IF_AMT');

2590: THEN
2591: hr_utility.set_location (l_proc, 1480);
2592: END IF;
2593:
2594: fnd_message.set_name ('HXT', 'HXT_39527_HRS_REQ_IF_AMT');
2595: l_otm_error := fnd_message.get;
2596: otm_error := l_otm_error;
2597: oracle_error := SQLERRM;
2598: call_hxthxc_gen_error ('HXT', 'HXT_39527_HRS_REQ_IF_AMT', NULL);

Line 2595: l_otm_error := fnd_message.get;

2591: hr_utility.set_location (l_proc, 1480);
2592: END IF;
2593:
2594: fnd_message.set_name ('HXT', 'HXT_39527_HRS_REQ_IF_AMT');
2595: l_otm_error := fnd_message.get;
2596: otm_error := l_otm_error;
2597: oracle_error := SQLERRM;
2598: call_hxthxc_gen_error ('HXT', 'HXT_39527_HRS_REQ_IF_AMT', NULL);
2599: --2278400

Line 2608: fnd_message.set_name ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP');

2604: THEN
2605: hr_utility.set_location (l_proc, 1490);
2606: END IF;
2607:
2608: fnd_message.set_name ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP');
2609: l_otm_error := fnd_message.get;
2610: otm_error := l_otm_error;
2611: oracle_error := SQLERRM;
2612: call_hxthxc_gen_error ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP', NULL);

Line 2609: l_otm_error := fnd_message.get;

2605: hr_utility.set_location (l_proc, 1490);
2606: END IF;
2607:
2608: fnd_message.set_name ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP');
2609: l_otm_error := fnd_message.get;
2610: otm_error := l_otm_error;
2611: oracle_error := SQLERRM;
2612: call_hxthxc_gen_error ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP', NULL);
2613: --2278400

Line 2622: fnd_message.set_name ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT');

2618: THEN
2619: hr_utility.set_location (l_proc, 1500);
2620: END IF;
2621:
2622: fnd_message.set_name ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT');
2623: l_otm_error := fnd_message.get;
2624: otm_error := l_otm_error;
2625: oracle_error := SQLERRM;
2626: call_hxthxc_gen_error ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT', NULL);

Line 2623: l_otm_error := fnd_message.get;

2619: hr_utility.set_location (l_proc, 1500);
2620: END IF;
2621:
2622: fnd_message.set_name ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT');
2623: l_otm_error := fnd_message.get;
2624: otm_error := l_otm_error;
2625: oracle_error := SQLERRM;
2626: call_hxthxc_gen_error ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT', NULL);
2627: --2278400

Line 2636: fnd_message.set_name ('HXT', 'HXT_39547_START_END_REQ');

2632: THEN
2633: hr_utility.set_location (l_proc, 1510);
2634: END IF;
2635:
2636: fnd_message.set_name ('HXT', 'HXT_39547_START_END_REQ');
2637: l_otm_error := fnd_message.get;
2638: otm_error := l_otm_error;
2639: oracle_error := SQLERRM;
2640: call_hxthxc_gen_error ('HXT', 'HXT_39547_START_END_REQ', NULL);

Line 2637: l_otm_error := fnd_message.get;

2633: hr_utility.set_location (l_proc, 1510);
2634: END IF;
2635:
2636: fnd_message.set_name ('HXT', 'HXT_39547_START_END_REQ');
2637: l_otm_error := fnd_message.get;
2638: otm_error := l_otm_error;
2639: oracle_error := SQLERRM;
2640: call_hxthxc_gen_error ('HXT', 'HXT_39547_START_END_REQ', NULL);
2641: --2278400

Line 2650: fnd_message.set_name ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK');

2646: THEN
2647: hr_utility.set_location (l_proc, 1520);
2648: END IF;
2649:
2650: fnd_message.set_name ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK');
2651: l_otm_error := fnd_message.get;
2652: otm_error := l_otm_error;
2653: oracle_error := SQLERRM;
2654: call_hxthxc_gen_error ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK', NULL);

Line 2651: l_otm_error := fnd_message.get;

2647: hr_utility.set_location (l_proc, 1520);
2648: END IF;
2649:
2650: fnd_message.set_name ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK');
2651: l_otm_error := fnd_message.get;
2652: otm_error := l_otm_error;
2653: oracle_error := SQLERRM;
2654: call_hxthxc_gen_error ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK', NULL);
2655: --2278400

Line 2664: fnd_message.set_name ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ');

2660: THEN
2661: hr_utility.set_location (l_proc, 1530);
2662: END IF;
2663:
2664: fnd_message.set_name ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ');
2665: l_otm_error := fnd_message.get;
2666: otm_error := l_otm_error;
2667: oracle_error := SQLERRM;
2668: call_hxthxc_gen_error ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ', NULL);

Line 2665: l_otm_error := fnd_message.get;

2661: hr_utility.set_location (l_proc, 1530);
2662: END IF;
2663:
2664: fnd_message.set_name ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ');
2665: l_otm_error := fnd_message.get;
2666: otm_error := l_otm_error;
2667: oracle_error := SQLERRM;
2668: call_hxthxc_gen_error ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ', NULL);
2669: --2278400

Line 2678: fnd_message.set_name ('HXT', 'HXT_39550_TIM_SRC_NF');

2674: THEN
2675: hr_utility.set_location (l_proc, 1540);
2676: END IF;
2677:
2678: fnd_message.set_name ('HXT', 'HXT_39550_TIM_SRC_NF');
2679: l_otm_error := fnd_message.get;
2680: otm_error := l_otm_error;
2681: oracle_error := SQLERRM;
2682: call_hxthxc_gen_error ('HXT', 'HXT_39550_TIM_SRC_NF', NULL);

Line 2679: l_otm_error := fnd_message.get;

2675: hr_utility.set_location (l_proc, 1540);
2676: END IF;
2677:
2678: fnd_message.set_name ('HXT', 'HXT_39550_TIM_SRC_NF');
2679: l_otm_error := fnd_message.get;
2680: otm_error := l_otm_error;
2681: oracle_error := SQLERRM;
2682: call_hxthxc_gen_error ('HXT', 'HXT_39550_TIM_SRC_NF', NULL);
2683: --2278400

Line 2692: fnd_message.set_name ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR');

2688: THEN
2689: hr_utility.set_location (l_proc, 1550);
2690: END IF;
2691:
2692: fnd_message.set_name ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR');
2693: l_otm_error := fnd_message.get;
2694: otm_error := l_otm_error;
2695: oracle_error := SQLERRM;
2696: call_hxthxc_gen_error ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR', NULL);

Line 2693: l_otm_error := fnd_message.get;

2689: hr_utility.set_location (l_proc, 1550);
2690: END IF;
2691:
2692: fnd_message.set_name ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR');
2693: l_otm_error := fnd_message.get;
2694: otm_error := l_otm_error;
2695: oracle_error := SQLERRM;
2696: call_hxthxc_gen_error ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR', NULL);
2697: --2278400

Line 2706: fnd_message.set_name ('HXT', 'HXT_39552_TIM_SUM_ID_NF');

2702: THEN
2703: hr_utility.set_location (l_proc, 1560);
2704: END IF;
2705:
2706: fnd_message.set_name ('HXT', 'HXT_39552_TIM_SUM_ID_NF');
2707: l_otm_error := fnd_message.get;
2708: otm_error := l_otm_error;
2709: oracle_error := SQLERRM;
2710: call_hxthxc_gen_error ('HXT', 'HXT_39552_TIM_SUM_ID_NF', NULL);

Line 2707: l_otm_error := fnd_message.get;

2703: hr_utility.set_location (l_proc, 1560);
2704: END IF;
2705:
2706: fnd_message.set_name ('HXT', 'HXT_39552_TIM_SUM_ID_NF');
2707: l_otm_error := fnd_message.get;
2708: otm_error := l_otm_error;
2709: oracle_error := SQLERRM;
2710: call_hxthxc_gen_error ('HXT', 'HXT_39552_TIM_SUM_ID_NF', NULL);
2711: --2278400

Line 2720: fnd_message.set_name ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR');

2716: THEN
2717: hr_utility.set_location (l_proc, 1570);
2718: END IF;
2719:
2720: fnd_message.set_name ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR');
2721: l_otm_error := fnd_message.get;
2722: otm_error := l_otm_error;
2723: oracle_error := SQLERRM;
2724: call_hxthxc_gen_error ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR', NULL);

Line 2721: l_otm_error := fnd_message.get;

2717: hr_utility.set_location (l_proc, 1570);
2718: END IF;
2719:
2720: fnd_message.set_name ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR');
2721: l_otm_error := fnd_message.get;
2722: otm_error := l_otm_error;
2723: oracle_error := SQLERRM;
2724: call_hxthxc_gen_error ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR', NULL);
2725: --2278400

Line 2734: fnd_message.set_name ('HXT', 'HXT_39554_ERN_POL_NF');

2730: THEN
2731: hr_utility.set_location (l_proc, 1580);
2732: END IF;
2733:
2734: fnd_message.set_name ('HXT', 'HXT_39554_ERN_POL_NF');
2735: l_otm_error := fnd_message.get;
2736: otm_error := l_otm_error;
2737: oracle_error := SQLERRM;
2738: call_hxthxc_gen_error ('HXT', 'HXT_39554_ERN_POL_NF', NULL);

Line 2735: l_otm_error := fnd_message.get;

2731: hr_utility.set_location (l_proc, 1580);
2732: END IF;
2733:
2734: fnd_message.set_name ('HXT', 'HXT_39554_ERN_POL_NF');
2735: l_otm_error := fnd_message.get;
2736: otm_error := l_otm_error;
2737: oracle_error := SQLERRM;
2738: call_hxthxc_gen_error ('HXT', 'HXT_39554_ERN_POL_NF', NULL);
2739: --2278400

Line 2748: fnd_message.set_name ('HXT', 'HXT_39555_ERN_POL_SYS_ERR');

2744: THEN
2745: hr_utility.set_location (l_proc, 1590);
2746: END IF;
2747:
2748: fnd_message.set_name ('HXT', 'HXT_39555_ERN_POL_SYS_ERR');
2749: l_otm_error := fnd_message.get;
2750: otm_error := l_otm_error;
2751: oracle_error := SQLERRM;
2752: call_hxthxc_gen_error ('HXT', 'HXT_39555_ERN_POL_SYS_ERR', NULL);

Line 2749: l_otm_error := fnd_message.get;

2745: hr_utility.set_location (l_proc, 1590);
2746: END IF;
2747:
2748: fnd_message.set_name ('HXT', 'HXT_39555_ERN_POL_SYS_ERR');
2749: l_otm_error := fnd_message.get;
2750: otm_error := l_otm_error;
2751: oracle_error := SQLERRM;
2752: call_hxthxc_gen_error ('HXT', 'HXT_39555_ERN_POL_SYS_ERR', NULL);
2753: --2278400

Line 2762: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

2758: THEN
2759: hr_utility.set_location (l_proc, 1600);
2760: END IF;
2761:
2762: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
2763: l_otm_error := fnd_message.get;
2764: otm_error := l_otm_error;
2765: oracle_error := SQLERRM;
2766: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);

Line 2763: l_otm_error := fnd_message.get;

2759: hr_utility.set_location (l_proc, 1600);
2760: END IF;
2761:
2762: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
2763: l_otm_error := fnd_message.get;
2764: otm_error := l_otm_error;
2765: oracle_error := SQLERRM;
2766: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);
2767: --2278400

Line 2776: fnd_message.set_name ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK');

2772: THEN
2773: hr_utility.set_location (l_proc, 1610);
2774: END IF;
2775:
2776: fnd_message.set_name ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK');
2777: l_otm_error := fnd_message.get;
2778: otm_error := l_otm_error;
2779: oracle_error := SQLERRM;
2780: call_hxthxc_gen_error ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK', NULL);

Line 2777: l_otm_error := fnd_message.get;

2773: hr_utility.set_location (l_proc, 1610);
2774: END IF;
2775:
2776: fnd_message.set_name ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK');
2777: l_otm_error := fnd_message.get;
2778: otm_error := l_otm_error;
2779: oracle_error := SQLERRM;
2780: call_hxthxc_gen_error ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK', NULL);
2781: --2278400

Line 2790: fnd_message.set_name ('HXT', 'HXT_39558_ERR_IN_DSR');

2786: THEN
2787: hr_utility.set_location (l_proc, 1620);
2788: END IF;
2789:
2790: fnd_message.set_name ('HXT', 'HXT_39558_ERR_IN_DSR');
2791: l_otm_error := fnd_message.get;
2792: otm_error := l_otm_error;
2793: oracle_error := SQLERRM;
2794: -- Removed for bug 3868006

Line 2791: l_otm_error := fnd_message.get;

2787: hr_utility.set_location (l_proc, 1620);
2788: END IF;
2789:
2790: fnd_message.set_name ('HXT', 'HXT_39558_ERR_IN_DSR');
2791: l_otm_error := fnd_message.get;
2792: otm_error := l_otm_error;
2793: oracle_error := SQLERRM;
2794: -- Removed for bug 3868006
2795: -- call_hxthxc_gen_error ('HXT', 'HXT_39558_ERR_IN_DSR', NULL); --2278400

Line 2813: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');

2809: THEN
2810: hr_utility.set_location (l_proc, 1640);
2811: END IF;
2812:
2813: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');
2814: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);
2815: l_otm_error := fnd_message.get;
2816: otm_error := l_otm_error;
2817: oracle_error := '';

Line 2814: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);

2810: hr_utility.set_location (l_proc, 1640);
2811: END IF;
2812:
2813: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');
2814: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);
2815: l_otm_error := fnd_message.get;
2816: otm_error := l_otm_error;
2817: oracle_error := '';
2818: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2815: l_otm_error := fnd_message.get;

2811: END IF;
2812:
2813: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');
2814: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);
2815: l_otm_error := fnd_message.get;
2816: otm_error := l_otm_error;
2817: oracle_error := '';
2818: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2819: --2278400

Line 2829: fnd_message.set_name ('HXT', 'HXT_39560_DT_UPD_MODE_NULL');

2825: THEN
2826: hr_utility.set_location (l_proc, 1650);
2827: END IF;
2828:
2829: fnd_message.set_name ('HXT', 'HXT_39560_DT_UPD_MODE_NULL');
2830: l_otm_error := fnd_message.get;
2831: otm_error := l_otm_error;
2832: oracle_error := '';
2833: call_hxthxc_gen_error ('HXT', 'HXT_39560_DT_UPD_MODE_NULL', NULL);

Line 2830: l_otm_error := fnd_message.get;

2826: hr_utility.set_location (l_proc, 1650);
2827: END IF;
2828:
2829: fnd_message.set_name ('HXT', 'HXT_39560_DT_UPD_MODE_NULL');
2830: l_otm_error := fnd_message.get;
2831: otm_error := l_otm_error;
2832: oracle_error := '';
2833: call_hxthxc_gen_error ('HXT', 'HXT_39560_DT_UPD_MODE_NULL', NULL);
2834: --2278400

Line 2847: fnd_message.set_name ('HXC', 'HXC_SELECTED_ARCHIVED_PERIOD');

2843: hr_utility.set_location (l_proc, 1655);
2844: hr_utility.trace('The timecard is archived ');
2845: END IF;
2846:
2847: fnd_message.set_name ('HXC', 'HXC_SELECTED_ARCHIVED_PERIOD');
2848: l_otm_error := fnd_message.get;
2849: otm_error := l_otm_error;
2850: oracle_error := '';
2851: call_hxthxc_gen_error ('HXC', 'HXC_SELECTED_ARCHIVED_PERIOD', NULL);

Line 2848: l_otm_error := fnd_message.get;

2844: hr_utility.trace('The timecard is archived ');
2845: END IF;
2846:
2847: fnd_message.set_name ('HXC', 'HXC_SELECTED_ARCHIVED_PERIOD');
2848: l_otm_error := fnd_message.get;
2849: otm_error := l_otm_error;
2850: oracle_error := '';
2851: call_hxthxc_gen_error ('HXC', 'HXC_SELECTED_ARCHIVED_PERIOD', NULL);
2852: RETURN;

Line 2866: fnd_message.set_name ('HXT', 'HXT_39406_EXCP_REC_TIME');

2862:
2863: -- GPM v115.23
2864: IF (l_otm_error IS NULL)
2865: THEN
2866: fnd_message.set_name ('HXT', 'HXT_39406_EXCP_REC_TIME');
2867: l_otm_error := fnd_message.get;
2868: END IF;
2869:
2870: otm_error := l_otm_error;

Line 2867: l_otm_error := fnd_message.get;

2863: -- GPM v115.23
2864: IF (l_otm_error IS NULL)
2865: THEN
2866: fnd_message.set_name ('HXT', 'HXT_39406_EXCP_REC_TIME');
2867: l_otm_error := fnd_message.get;
2868: END IF;
2869:
2870: otm_error := l_otm_error;
2871:

Line 3294: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');

3290: END LOOP;
3291: EXCEPTION
3292: WHEN l_tim_not_found_err
3293: THEN
3294: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');
3295: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));
3296: otm_error := fnd_message.get;
3297: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3298: --2278400

Line 3295: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));

3291: EXCEPTION
3292: WHEN l_tim_not_found_err
3293: THEN
3294: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');
3295: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));
3296: otm_error := fnd_message.get;
3297: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3298: --2278400
3299: WHEN l_rec_hours_data_err

Line 3296: otm_error := fnd_message.get;

3292: WHEN l_tim_not_found_err
3293: THEN
3294: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');
3295: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));
3296: otm_error := fnd_message.get;
3297: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3298: --2278400
3299: WHEN l_rec_hours_data_err
3300: THEN

Line 3301: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');

3297: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3298: --2278400
3299: WHEN l_rec_hours_data_err
3300: THEN
3301: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3302: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3303: otm_error := fnd_message.get;
3304: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3305: WHEN l_rec_hours_sys_err

Line 3302: fnd_message.set_token ('ERR_TEXT', l_otm_error);

3298: --2278400
3299: WHEN l_rec_hours_data_err
3300: THEN
3301: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3302: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3303: otm_error := fnd_message.get;
3304: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3305: WHEN l_rec_hours_sys_err
3306: THEN

Line 3303: otm_error := fnd_message.get;

3299: WHEN l_rec_hours_data_err
3300: THEN
3301: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3302: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3303: otm_error := fnd_message.get;
3304: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3305: WHEN l_rec_hours_sys_err
3306: THEN
3307: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');

Line 3307: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');

3303: otm_error := fnd_message.get;
3304: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3305: WHEN l_rec_hours_sys_err
3306: THEN
3307: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3308: fnd_message.set_token ('ERR_TEXT', l_oracle_error);
3309: oracle_error := fnd_message.get;
3310: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3311: --begin SIR334

Line 3308: fnd_message.set_token ('ERR_TEXT', l_oracle_error);

3304: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3305: WHEN l_rec_hours_sys_err
3306: THEN
3307: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3308: fnd_message.set_token ('ERR_TEXT', l_oracle_error);
3309: oracle_error := fnd_message.get;
3310: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3311: --begin SIR334
3312: WHEN l_delete_details_err

Line 3309: oracle_error := fnd_message.get;

3305: WHEN l_rec_hours_sys_err
3306: THEN
3307: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3308: fnd_message.set_token ('ERR_TEXT', l_oracle_error);
3309: oracle_error := fnd_message.get;
3310: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3311: --begin SIR334
3312: WHEN l_delete_details_err
3313: THEN

Line 3314: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');

3310: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3311: --begin SIR334
3312: WHEN l_delete_details_err
3313: THEN
3314: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
3315: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3316: otm_error := fnd_message.get;
3317: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3318: WHEN l_sess_date_err

Line 3315: fnd_message.set_token ('ERR_TEXT', l_otm_error);

3311: --begin SIR334
3312: WHEN l_delete_details_err
3313: THEN
3314: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
3315: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3316: otm_error := fnd_message.get;
3317: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3318: WHEN l_sess_date_err
3319: THEN

Line 3316: otm_error := fnd_message.get;

3312: WHEN l_delete_details_err
3313: THEN
3314: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
3315: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3316: otm_error := fnd_message.get;
3317: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3318: WHEN l_sess_date_err
3319: THEN
3320: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

Line 3320: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

3316: otm_error := fnd_message.get;
3317: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3318: WHEN l_sess_date_err
3319: THEN
3320: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
3321: otm_error := fnd_message.get;
3322: oracle_error := SQLERRM;
3323: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3324: --2278400

Line 3321: otm_error := fnd_message.get;

3317: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3318: WHEN l_sess_date_err
3319: THEN
3320: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
3321: otm_error := fnd_message.get;
3322: oracle_error := SQLERRM;
3323: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3324: --2278400
3325: --end SIR334

Line 3329: fnd_message.set_name ('HXT', 'HXT_39564_EXCP_IN_RET');

3325: --end SIR334
3326: WHEN OTHERS
3327: THEN
3328: hr_utility.trace(dbms_utility.format_error_backtrace);
3329: fnd_message.set_name ('HXT', 'HXT_39564_EXCP_IN_RET');
3330: otm_error := fnd_message.get;
3331: oracle_error := SQLERRM;
3332: call_hxthxc_gen_error ('HXT', 'HXT_39564_EXCP_IN_RET', NULL);
3333: --2278400

Line 3330: otm_error := fnd_message.get;

3326: WHEN OTHERS
3327: THEN
3328: hr_utility.trace(dbms_utility.format_error_backtrace);
3329: fnd_message.set_name ('HXT', 'HXT_39564_EXCP_IN_RET');
3330: otm_error := fnd_message.get;
3331: oracle_error := SQLERRM;
3332: call_hxthxc_gen_error ('HXT', 'HXT_39564_EXCP_IN_RET', NULL);
3333: --2278400
3334: END re_explode_timecard;

Line 3821: fnd_message.set_name ('HXT', 'HXT_39409_CREATE_BATCH');

3817: RETURN 0;
3818: EXCEPTION
3819: WHEN l_batch_id_error
3820: THEN
3821: fnd_message.set_name ('HXT', 'HXT_39409_CREATE_BATCH');
3822: call_hxthxc_gen_error ('HXT', 'HXT_39409_CREATE_BATCH', NULL);
3823: --2278400
3824: RETURN 2;
3825: WHEN l_reference_num_error

Line 3827: fnd_message.set_name ('HXT', 'HXT_39410_CREATE_REF_FUNC');

3823: --2278400
3824: RETURN 2;
3825: WHEN l_reference_num_error
3826: THEN
3827: fnd_message.set_name ('HXT', 'HXT_39410_CREATE_REF_FUNC');
3828: call_hxthxc_gen_error ('HXT', 'HXT_39410_CREATE_REF_FUNC', NULL);
3829: --2278400
3830: RETURN l_retcode;
3831: WHEN l_batch_name_error

Line 3833: fnd_message.set_name ('HXT', 'HXT_39484_CREATE_BATCH_NAME');

3829: --2278400
3830: RETURN l_retcode;
3831: WHEN l_batch_name_error
3832: THEN
3833: fnd_message.set_name ('HXT', 'HXT_39484_CREATE_BATCH_NAME');
3834: call_hxthxc_gen_error ('HXT', 'HXT_39484_CREATE_BATCH_NAME', NULL);
3835: --2278400
3836: RETURN l_retcode;
3837: WHEN OTHERS

Line 3840: fnd_message.set_name ('HXT', 'HXT_39411_CREATE_BATCH_FUNC');

3836: RETURN l_retcode;
3837: WHEN OTHERS
3838: THEN
3839: hr_utility.trace(dbms_utility.format_error_backtrace);
3840: fnd_message.set_name ('HXT', 'HXT_39411_CREATE_BATCH_FUNC');
3841: call_hxthxc_gen_error ('HXT', 'HXT_39411_CREATE_BATCH_FUNC', NULL);
3842: --2278400
3843: RETURN 2;
3844: END create_batch;

Line 3936: fnd_message.set_name ('HXT', 'HXT_39412_FIND_BATCH_FUNC');

3932: EXCEPTION
3933: WHEN OTHERS
3934: THEN
3935: hr_utility.trace(dbms_utility.format_error_backtrace);
3936: fnd_message.set_name ('HXT', 'HXT_39412_FIND_BATCH_FUNC');
3937: call_hxthxc_gen_error ('HXT', 'HXT_39412_FIND_BATCH_FUNC', NULL);
3938: RETURN NULL;
3939: END find_existing_batch;
3940:

Line 4280: fnd_message.set_name ('HXT', 'HXT_39565_ERR_IN_CHH');

4276: THEN
4277: hr_utility.set_location (l_proc, 190);
4278: END IF;
4279:
4280: fnd_message.set_name ('HXT', 'HXT_39565_ERR_IN_CHH');
4281: o_otm_error := fnd_message.get;
4282: o_oracle_error := SQLERRM;
4283: call_hxthxc_gen_error ('HXT', 'HXT_39565_ERR_IN_CHH', NULL);
4284: --2278400

Line 4281: o_otm_error := fnd_message.get;

4277: hr_utility.set_location (l_proc, 190);
4278: END IF;
4279:
4280: fnd_message.set_name ('HXT', 'HXT_39565_ERR_IN_CHH');
4281: o_otm_error := fnd_message.get;
4282: o_oracle_error := SQLERRM;
4283: call_hxthxc_gen_error ('HXT', 'HXT_39565_ERR_IN_CHH', NULL);
4284: --2278400
4285: RETURN 1;

Line 4294: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');

4290: THEN
4291: hr_utility.set_location (l_proc, 200);
4292: END IF;
4293:
4294: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');
4295: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
4296: o_otm_error := fnd_message.get;
4297: o_oracle_error := SQLERRM;
4298: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);

Line 4295: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));

4291: hr_utility.set_location (l_proc, 200);
4292: END IF;
4293:
4294: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');
4295: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
4296: o_otm_error := fnd_message.get;
4297: o_oracle_error := SQLERRM;
4298: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
4299: --2278400

Line 4296: o_otm_error := fnd_message.get;

4292: END IF;
4293:
4294: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');
4295: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
4296: o_otm_error := fnd_message.get;
4297: o_oracle_error := SQLERRM;
4298: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
4299: --2278400
4300: RETURN 2;

Line 4509: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');

4505: THEN
4506: hr_utility.set_location (l_proc, 120);
4507: END IF;
4508:
4509: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');
4510: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4511: p_otm_error := fnd_message.get;
4512: WHEN error_in_shift_info
4513: THEN

Line 4510: fnd_message.set_token ('ORA_ERROR', SQLERRM);

4506: hr_utility.set_location (l_proc, 120);
4507: END IF;
4508:
4509: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');
4510: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4511: p_otm_error := fnd_message.get;
4512: WHEN error_in_shift_info
4513: THEN
4514: IF g_debug

Line 4511: p_otm_error := fnd_message.get;

4507: END IF;
4508:
4509: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');
4510: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4511: p_otm_error := fnd_message.get;
4512: WHEN error_in_shift_info
4513: THEN
4514: IF g_debug
4515: THEN

Line 4519: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');

4515: THEN
4516: hr_utility.set_location (l_proc, 130);
4517: END IF;
4518:
4519: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');
4520: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4521: p_otm_error := fnd_message.get;
4522: /*
4523: WHEN error_in_check_hol THEN

Line 4520: fnd_message.set_token ('ORA_ERROR', SQLERRM);

4516: hr_utility.set_location (l_proc, 130);
4517: END IF;
4518:
4519: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');
4520: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4521: p_otm_error := fnd_message.get;
4522: /*
4523: WHEN error_in_check_hol THEN
4524: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');

Line 4521: p_otm_error := fnd_message.get;

4517: END IF;
4518:
4519: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');
4520: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4521: p_otm_error := fnd_message.get;
4522: /*
4523: WHEN error_in_check_hol THEN
4524: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4525: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);

Line 4524: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');

4520: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4521: p_otm_error := fnd_message.get;
4522: /*
4523: WHEN error_in_check_hol THEN
4524: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4525: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);
4526: p_otm_error := fnd_message.get;
4527: */
4528: END load_policies;

Line 4525: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);

4521: p_otm_error := fnd_message.get;
4522: /*
4523: WHEN error_in_check_hol THEN
4524: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4525: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);
4526: p_otm_error := fnd_message.get;
4527: */
4528: END load_policies;
4529:

Line 4526: p_otm_error := fnd_message.get;

4522: /*
4523: WHEN error_in_check_hol THEN
4524: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4525: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);
4526: p_otm_error := fnd_message.get;
4527: */
4528: END load_policies;
4529:
4530: /*************************************************************************

Line 5652: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');

5648: hr_utility.set_location (l_proc, 380);
5649: END IF;
5650: hr_utility.trace(dbms_utility.format_error_backtrace);
5651:
5652: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
5653: fnd_message.set_token ('ERR_TEXT', SQLERRM);
5654: o_error_message := fnd_message.get;
5655: call_hxthxc_gen_error ('HXC',
5656: 'HXC_HXT_DEP_VAL_OTMERR',

Line 5653: fnd_message.set_token ('ERR_TEXT', SQLERRM);

5649: END IF;
5650: hr_utility.trace(dbms_utility.format_error_backtrace);
5651:
5652: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
5653: fnd_message.set_token ('ERR_TEXT', SQLERRM);
5654: o_error_message := fnd_message.get;
5655: call_hxthxc_gen_error ('HXC',
5656: 'HXC_HXT_DEP_VAL_OTMERR',
5657: o_error_message

Line 5654: o_error_message := fnd_message.get;

5650: hr_utility.trace(dbms_utility.format_error_backtrace);
5651:
5652: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
5653: fnd_message.set_token ('ERR_TEXT', SQLERRM);
5654: o_error_message := fnd_message.get;
5655: call_hxthxc_gen_error ('HXC',
5656: 'HXC_HXT_DEP_VAL_OTMERR',
5657: o_error_message
5658: ); --2278400

Line 5830: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');

5826: THEN
5827: hr_utility.set_location (l_proc, 450);
5828: END IF;
5829:
5830: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');
5831: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5832: o_otm_error := fnd_message.get;
5833: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5834: --2278400

Line 5831: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));

5827: hr_utility.set_location (l_proc, 450);
5828: END IF;
5829:
5830: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');
5831: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5832: o_otm_error := fnd_message.get;
5833: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5834: --2278400
5835: RETURN 1;

Line 5832: o_otm_error := fnd_message.get;

5828: END IF;
5829:
5830: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');
5831: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5832: o_otm_error := fnd_message.get;
5833: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5834: --2278400
5835: RETURN 1;
5836: WHEN l_details_system_error

Line 5843: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');

5839: THEN
5840: hr_utility.set_location (l_proc, 460);
5841: END IF;
5842:
5843: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');
5844: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5845: o_otm_error := fnd_message.get;
5846: o_oracle_error := SQLERRM;
5847: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);

Line 5844: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));

5840: hr_utility.set_location (l_proc, 460);
5841: END IF;
5842:
5843: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');
5844: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5845: o_otm_error := fnd_message.get;
5846: o_oracle_error := SQLERRM;
5847: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5848: --2278400

Line 5845: o_otm_error := fnd_message.get;

5841: END IF;
5842:
5843: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');
5844: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5845: o_otm_error := fnd_message.get;
5846: o_oracle_error := SQLERRM;
5847: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5848: --2278400
5849: RETURN 2;

Line 5857: fnd_message.set_name ('HXT', 'HXT_39445_CHG_DATE');

5853: THEN
5854: hr_utility.set_location (l_proc, 470);
5855: END IF;
5856:
5857: fnd_message.set_name ('HXT', 'HXT_39445_CHG_DATE');
5858: o_otm_error := fnd_message.get;
5859: o_oracle_error := SQLERRM;
5860: call_hxthxc_gen_error ('HXT', 'HXT_39445_CHG_DATE', NULL); --2278400
5861: RETURN 1;

Line 5858: o_otm_error := fnd_message.get;

5854: hr_utility.set_location (l_proc, 470);
5855: END IF;
5856:
5857: fnd_message.set_name ('HXT', 'HXT_39445_CHG_DATE');
5858: o_otm_error := fnd_message.get;
5859: o_oracle_error := SQLERRM;
5860: call_hxthxc_gen_error ('HXT', 'HXT_39445_CHG_DATE', NULL); --2278400
5861: RETURN 1;
5862: WHEN l_hours_worked_id_error

Line 5869: fnd_message.set_name ('HXT', 'HXT_39416_GET_HRW_ID');

5865: THEN
5866: hr_utility.set_location (l_proc, 480);
5867: END IF;
5868:
5869: fnd_message.set_name ('HXT', 'HXT_39416_GET_HRW_ID');
5870: o_otm_error := fnd_message.get;
5871: o_oracle_error := SQLERRM;
5872: call_hxthxc_gen_error ('HXT', 'HXT_39416_GET_HRW_ID', NULL);
5873: --2278400

Line 5870: o_otm_error := fnd_message.get;

5866: hr_utility.set_location (l_proc, 480);
5867: END IF;
5868:
5869: fnd_message.set_name ('HXT', 'HXT_39416_GET_HRW_ID');
5870: o_otm_error := fnd_message.get;
5871: o_oracle_error := SQLERRM;
5872: call_hxthxc_gen_error ('HXT', 'HXT_39416_GET_HRW_ID', NULL);
5873: --2278400
5874: RETURN 2;

Line 5882: --fnd_message.set_name ('HXT', 'HXT_39417_PROB_GEN_DET');

5878: THEN
5879: hr_utility.set_location (l_proc, 490);
5880: END IF;
5881:
5882: --fnd_message.set_name ('HXT', 'HXT_39417_PROB_GEN_DET');
5883: o_otm_error := fnd_message.get;
5884: --call_hxthxc_gen_error('HXT', 'HXT_39417_PROB_GEN_DET',NULL); --2278400
5885: RETURN 2;
5886: WHEN l_inc_tim_hr_entry_err

Line 5883: o_otm_error := fnd_message.get;

5879: hr_utility.set_location (l_proc, 490);
5880: END IF;
5881:
5882: --fnd_message.set_name ('HXT', 'HXT_39417_PROB_GEN_DET');
5883: o_otm_error := fnd_message.get;
5884: --call_hxthxc_gen_error('HXT', 'HXT_39417_PROB_GEN_DET',NULL); --2278400
5885: RETURN 2;
5886: WHEN l_inc_tim_hr_entry_err
5887: THEN

Line 5893: fnd_message.set_name ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES');

5889: THEN
5890: hr_utility.set_location (l_proc, 495);
5891: END IF;
5892:
5893: fnd_message.set_name ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES');
5894: o_otm_error := fnd_message.get;
5895: call_hxthxc_gen_error ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES', NULL);
5896: --2278400
5897: RETURN 2;

Line 5894: o_otm_error := fnd_message.get;

5890: hr_utility.set_location (l_proc, 495);
5891: END IF;
5892:
5893: fnd_message.set_name ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES');
5894: o_otm_error := fnd_message.get;
5895: call_hxthxc_gen_error ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES', NULL);
5896: --2278400
5897: RETURN 2;
5898: WHEN l_seq_num_error

Line 5905: fnd_message.set_name ('HXT', 'HXT_39418_GET_HRW_SEQ');

5901: THEN
5902: hr_utility.set_location (l_proc, 500);
5903: END IF;
5904:
5905: fnd_message.set_name ('HXT', 'HXT_39418_GET_HRW_SEQ');
5906: o_otm_error := fnd_message.get;
5907: o_oracle_error := SQLERRM;
5908: call_hxthxc_gen_error ('HXT', 'HXT_39418_GET_HRW_SEQ', NULL);
5909: --2278400

Line 5906: o_otm_error := fnd_message.get;

5902: hr_utility.set_location (l_proc, 500);
5903: END IF;
5904:
5905: fnd_message.set_name ('HXT', 'HXT_39418_GET_HRW_SEQ');
5906: o_otm_error := fnd_message.get;
5907: o_oracle_error := SQLERRM;
5908: call_hxthxc_gen_error ('HXT', 'HXT_39418_GET_HRW_SEQ', NULL);
5909: --2278400
5910: RETURN 2;

Line 5918: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');

5914: THEN
5915: hr_utility.set_location (l_proc, 510);
5916: END IF;
5917:
5918: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
5919: fnd_message.set_token ('ERR_TEXT', l_otm_error);
5920: o_otm_error := fnd_message.get;
5921: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5922: --2278400

Line 5919: fnd_message.set_token ('ERR_TEXT', l_otm_error);

5915: hr_utility.set_location (l_proc, 510);
5916: END IF;
5917:
5918: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
5919: fnd_message.set_token ('ERR_TEXT', l_otm_error);
5920: o_otm_error := fnd_message.get;
5921: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5922: --2278400
5923: WHEN l_sess_date_err

Line 5920: o_otm_error := fnd_message.get;

5916: END IF;
5917:
5918: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
5919: fnd_message.set_token ('ERR_TEXT', l_otm_error);
5920: o_otm_error := fnd_message.get;
5921: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5922: --2278400
5923: WHEN l_sess_date_err
5924: THEN

Line 5930: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

5926: THEN
5927: hr_utility.set_location (l_proc, 520);
5928: END IF;
5929:
5930: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
5931: o_otm_error := fnd_message.get;
5932: o_oracle_error := SQLERRM;
5933: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);
5934: --2278400

Line 5931: o_otm_error := fnd_message.get;

5927: hr_utility.set_location (l_proc, 520);
5928: END IF;
5929:
5930: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
5931: o_otm_error := fnd_message.get;
5932: o_oracle_error := SQLERRM;
5933: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);
5934: --2278400
5935: WHEN l_retro_edit_err

Line 5974: fnd_message.set_name ('HXT', 'HXT_39419_SYSERR_RECFUNC');

5970: THEN
5971: hr_utility.set_location (l_proc, 540);
5972: END IF;
5973:
5974: fnd_message.set_name ('HXT', 'HXT_39419_SYSERR_RECFUNC');
5975: o_otm_error := fnd_message.get;
5976: o_oracle_error := SQLERRM;
5977: call_hxthxc_gen_error ('HXT', 'HXT_39419_SYSERR_RECFUNC', NULL);
5978: --2278400

Line 5975: o_otm_error := fnd_message.get;

5971: hr_utility.set_location (l_proc, 540);
5972: END IF;
5973:
5974: fnd_message.set_name ('HXT', 'HXT_39419_SYSERR_RECFUNC');
5975: o_otm_error := fnd_message.get;
5976: o_oracle_error := SQLERRM;
5977: call_hxthxc_gen_error ('HXT', 'HXT_39419_SYSERR_RECFUNC', NULL);
5978: --2278400
5979: RETURN 2;

Line 6118: fnd_message.set_name ('HXT', 'HXT_39566_ERR_IN_CAE');

6114: o_oracle_error := SQLERRM;
6115: WHEN OTHERS
6116: THEN
6117: hr_utility.trace(dbms_utility.format_error_backtrace);
6118: fnd_message.set_name ('HXT', 'HXT_39566_ERR_IN_CAE');
6119: l_otm_error := fnd_message.get;
6120: o_otm_error := l_otm_error;
6121: o_oracle_error := SQLERRM;
6122: call_hxthxc_gen_error ('HXT', 'HXT_39566_ERR_IN_CAE', NULL);

Line 6119: l_otm_error := fnd_message.get;

6115: WHEN OTHERS
6116: THEN
6117: hr_utility.trace(dbms_utility.format_error_backtrace);
6118: fnd_message.set_name ('HXT', 'HXT_39566_ERR_IN_CAE');
6119: l_otm_error := fnd_message.get;
6120: o_otm_error := l_otm_error;
6121: o_oracle_error := SQLERRM;
6122: call_hxthxc_gen_error ('HXT', 'HXT_39566_ERR_IN_CAE', NULL);
6123: --2278400

Line 6391: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');

6387: EXCEPTION
6388: WHEN OTHERS
6389: THEN
6390: hr_utility.trace(dbms_utility.format_error_backtrace);
6391: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
6392: fnd_message.set_token ('ERR_TEXT', SQLERRM);
6393: o_error_message := fnd_message.get;
6394: call_hxthxc_gen_error ('HXC',
6395: 'HXC_HXT_DEP_VAL_OTMERR',

Line 6392: fnd_message.set_token ('ERR_TEXT', SQLERRM);

6388: WHEN OTHERS
6389: THEN
6390: hr_utility.trace(dbms_utility.format_error_backtrace);
6391: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
6392: fnd_message.set_token ('ERR_TEXT', SQLERRM);
6393: o_error_message := fnd_message.get;
6394: call_hxthxc_gen_error ('HXC',
6395: 'HXC_HXT_DEP_VAL_OTMERR',
6396: o_error_message

Line 6393: o_error_message := fnd_message.get;

6389: THEN
6390: hr_utility.trace(dbms_utility.format_error_backtrace);
6391: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
6392: fnd_message.set_token ('ERR_TEXT', SQLERRM);
6393: o_error_message := fnd_message.get;
6394: call_hxthxc_gen_error ('HXC',
6395: 'HXC_HXT_DEP_VAL_OTMERR',
6396: o_error_message
6397: ); --2278400

Line 7072: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');

7068: THEN
7069: hr_utility.set_location (l_proc, 210);
7070: END IF;
7071:
7072: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
7073: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
7074: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
7075: fnd_message.set_token ('DT_WRK',
7076: TO_CHAR (p_date_worked, 'DD-MON-YYYY')

Line 7073: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));

7069: hr_utility.set_location (l_proc, 210);
7070: END IF;
7071:
7072: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
7073: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
7074: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
7075: fnd_message.set_token ('DT_WRK',
7076: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
7077: );

Line 7074: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));

7070: END IF;
7071:
7072: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
7073: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
7074: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
7075: fnd_message.set_token ('DT_WRK',
7076: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
7077: );
7078: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));

Line 7075: fnd_message.set_token ('DT_WRK',

7071:
7072: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
7073: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
7074: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
7075: fnd_message.set_token ('DT_WRK',
7076: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
7077: );
7078: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
7079: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));

Line 7078: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));

7074: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
7075: fnd_message.set_token ('DT_WRK',
7076: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
7077: );
7078: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
7079: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));
7080: p_error := fnd_message.get;
7081: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
7082: --2278400

Line 7079: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));

7075: fnd_message.set_token ('DT_WRK',
7076: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
7077: );
7078: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
7079: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));
7080: p_error := fnd_message.get;
7081: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
7082: --2278400
7083: p_code := 1;

Line 7080: p_error := fnd_message.get;

7076: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
7077: );
7078: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
7079: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));
7080: p_error := fnd_message.get;
7081: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
7082: --2278400
7083: p_code := 1;
7084: RETURN;

Line 7136: fnd_message.set_name ('HXT', 'HXT_39600_INVALID_ENTRIES');

7132: THEN
7133: hr_utility.set_location (l_proc, 220);
7134: END IF;
7135:
7136: fnd_message.set_name ('HXT', 'HXT_39600_INVALID_ENTRIES');
7137: p_error := fnd_message.get;
7138: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
7139: --2278400
7140: p_code := 1;

Line 7137: p_error := fnd_message.get;

7133: hr_utility.set_location (l_proc, 220);
7134: END IF;
7135:
7136: fnd_message.set_name ('HXT', 'HXT_39600_INVALID_ENTRIES');
7137: p_error := fnd_message.get;
7138: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
7139: --2278400
7140: p_code := 1;
7141: RETURN;