[Home] [Help]
80: ELSE
81: l_ERROR_MSG := p_ERROR_MSG;
82: END IF;
83:
84: insert into hxt_errors_f(id, error_msg, creation_date, location,--ORA135
85: created_by, err_type, PPB_ID, TIM_ID, HRW_ID, PTP_ID, ora_message
86: ,EFFECTIVE_START_DATE
87: ,EFFECTIVE_END_DATE
88: ,PERSON_ID
107: -- Bug 12919783
108: hr_utility.trace(dbms_utility.format_error_backtrace);
109: FND_MESSAGE.SET_NAME('HXT','HXT_39469_ERR_INS_HXT_ERR');
110: l_error := SQLERRM;
111: insert into hxt_errors_f(id, error_msg, creation_date, location,
112: created_by, err_type, PPB_ID, TIM_ID, HRW_ID, PTP_ID, ora_message
113: ,EFFECTIVE_START_DATE
114: ,EFFECTIVE_END_DATE)
115: values(l_EXCEP_seqno,
178: ELSE
179: l_ERROR_MSG := p_ERROR_MSG;
180: END IF;
181: BEGIN
182: insert into hxt_errors_f(id, error_msg, creation_date, location,--ORA135
183: created_by, err_type, TIM_ID, HRW_ID, PTP_ID, ora_message
184: ,EFFECTIVE_START_DATE
185: ,EFFECTIVE_END_DATE
186: ,PERSON_ID --ER230
203: -- Bug 12919783
204: hr_utility.trace(dbms_utility.format_error_backtrace);
205: FND_MESSAGE.SET_NAME('HXT','HXT_39469_ERR_INS_HXT_ERR');
206: l_error := SQLERRM;
207: insert into hxt_errors_f(id, error_msg, creation_date, location,
208: created_by, err_type, TIM_ID, HRW_ID, PTP_ID, ora_message
209: ,EFFECTIVE_START_DATE
210: ,EFFECTIVE_END_DATE)
211: values(l_EXCEP_seqno,
2164: l_person_id := GetPersonID(p_TIM_ID); -- ER230
2165: l_payroll_id := GetPayrollID(p_PTP_ID); -- ER230
2166:
2167:
2168: insert into hxt_errors_f(
2169: id,
2170: error_msg,
2171: creation_date,
2172: location,
2209: hr_utility.trace(dbms_utility.format_error_backtrace);
2210: l_error := SQLERRM;
2211:
2212: FND_MESSAGE.SET_NAME('HXT','HXT_39469_ERR_INS_HXT_ERR');
2213: insert into hxt_errors_f(
2214: id,
2215: error_msg,
2216: creation_date,
2217: location,