eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on FND_MESSAGE

Line 201: fnd_message.set_name ('HXC', 'HXC_HXT_RET_NO_EMP_NUMBER');

197: WHEN NO_DATA_FOUND
198: THEN
199: --
200: g_status := 'ERRORS';
201: fnd_message.set_name ('HXC', 'HXC_HXT_RET_NO_EMP_NUMBER');
202: fnd_message.set_token ('PERSON_NAME', g_full_name);
203: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
204: RAISE e_record_error;
205: --

Line 202: fnd_message.set_token ('PERSON_NAME', g_full_name);

198: THEN
199: --
200: g_status := 'ERRORS';
201: fnd_message.set_name ('HXC', 'HXC_HXT_RET_NO_EMP_NUMBER');
202: fnd_message.set_token ('PERSON_NAME', g_full_name);
203: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
204: RAISE e_record_error;
205: --
206: RETURN (NULL);

Line 203: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

199: --
200: g_status := 'ERRORS';
201: fnd_message.set_name ('HXC', 'HXC_HXT_RET_NO_EMP_NUMBER');
202: fnd_message.set_token ('PERSON_NAME', g_full_name);
203: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
204: RAISE e_record_error;
205: --
206: RETURN (NULL);
207: END;

Line 252: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');

248: EXCEPTION
249: WHEN NO_DATA_FOUND
250: THEN
251: g_status := 'ERRORS';
252: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
253: fnd_message.set_token ('PERSON_NAME', g_full_name);
254: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
255: RAISE e_record_error;
256: RETURN;

Line 253: fnd_message.set_token ('PERSON_NAME', g_full_name);

249: WHEN NO_DATA_FOUND
250: THEN
251: g_status := 'ERRORS';
252: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
253: fnd_message.set_token ('PERSON_NAME', g_full_name);
254: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
255: RAISE e_record_error;
256: RETURN;
257: END;

Line 254: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

250: THEN
251: g_status := 'ERRORS';
252: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
253: fnd_message.set_token ('PERSON_NAME', g_full_name);
254: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
255: RAISE e_record_error;
256: RETURN;
257: END;
258: --

Line 313: -- fnd_message.set_name('HXC', 'HXC_HXT_RET_NO_TIMECARD');

309: p_time_sum_start_date := NULL;
310: p_time_sum_end_date := NULL;
311: --
312: -- g_status := 'ERRORS';
313: -- fnd_message.set_name('HXC', 'HXC_HXT_RET_NO_TIMECARD');
314: -- fnd_message.set_token('PERSON_NAME', g_full_name);
315: -- g_exception_description := SUBSTR(fnd_message.get,1,2000);
316: -- raise e_record_error;
317: --

Line 314: -- fnd_message.set_token('PERSON_NAME', g_full_name);

310: p_time_sum_end_date := NULL;
311: --
312: -- g_status := 'ERRORS';
313: -- fnd_message.set_name('HXC', 'HXC_HXT_RET_NO_TIMECARD');
314: -- fnd_message.set_token('PERSON_NAME', g_full_name);
315: -- g_exception_description := SUBSTR(fnd_message.get,1,2000);
316: -- raise e_record_error;
317: --
318: WHEN TOO_MANY_ROWS

Line 315: -- g_exception_description := SUBSTR(fnd_message.get,1,2000);

311: --
312: -- g_status := 'ERRORS';
313: -- fnd_message.set_name('HXC', 'HXC_HXT_RET_NO_TIMECARD');
314: -- fnd_message.set_token('PERSON_NAME', g_full_name);
315: -- g_exception_description := SUBSTR(fnd_message.get,1,2000);
316: -- raise e_record_error;
317: --
318: WHEN TOO_MANY_ROWS
319: THEN

Line 321: fnd_message.set_name ('HXC', 'HXC_HXT_CANNOT_UPDATE');

317: --
318: WHEN TOO_MANY_ROWS
319: THEN
320: g_status := 'ERRORS';
321: fnd_message.set_name ('HXC', 'HXC_HXT_CANNOT_UPDATE');
322: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
323: RAISE e_record_error;
324: RETURN;
325: END;

Line 322: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

318: WHEN TOO_MANY_ROWS
319: THEN
320: g_status := 'ERRORS';
321: fnd_message.set_name ('HXC', 'HXC_HXT_CANNOT_UPDATE');
322: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
323: RAISE e_record_error;
324: RETURN;
325: END;
326: --

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

425: -- sanity check to make sure we are in sync
426: --
427: IF (l_bld_blk_id <> p_bb_id)
428: THEN
429: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token ('PROCEDURE', 'get_attribute');
431: fnd_message.set_token ('STEP', 'bld blk mismatch');
432: fnd_message.raise_error;
433: END IF;

Line 430: fnd_message.set_token ('PROCEDURE', 'get_attribute');

426: --
427: IF (l_bld_blk_id <> p_bb_id)
428: THEN
429: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token ('PROCEDURE', 'get_attribute');
431: fnd_message.set_token ('STEP', 'bld blk mismatch');
432: fnd_message.raise_error;
433: END IF;
434:

Line 431: fnd_message.set_token ('STEP', 'bld blk mismatch');

427: IF (l_bld_blk_id <> p_bb_id)
428: THEN
429: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token ('PROCEDURE', 'get_attribute');
431: fnd_message.set_token ('STEP', 'bld blk mismatch');
432: fnd_message.raise_error;
433: END IF;
434:
435: --

Line 432: fnd_message.raise_error;

428: THEN
429: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token ('PROCEDURE', 'get_attribute');
431: fnd_message.set_token ('STEP', 'bld blk mismatch');
432: fnd_message.raise_error;
433: END IF;
434:
435: --
436: IF p_att_table.COUNT <> 0

Line 534: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_NAME');

530: EXCEPTION
531: WHEN NO_DATA_FOUND
532: THEN
533: g_status := 'ERRORS';
534: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_NAME');
535: fnd_message.set_token ('ELE_TYPE_ID', p_ele_type_id);
536: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
537: RAISE e_record_error;
538: RETURN (NULL);

Line 535: fnd_message.set_token ('ELE_TYPE_ID', p_ele_type_id);

531: WHEN NO_DATA_FOUND
532: THEN
533: g_status := 'ERRORS';
534: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_NAME');
535: fnd_message.set_token ('ELE_TYPE_ID', p_ele_type_id);
536: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
537: RAISE e_record_error;
538: RETURN (NULL);
539: END;

Line 536: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

532: THEN
533: g_status := 'ERRORS';
534: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_NAME');
535: fnd_message.set_token ('ELE_TYPE_ID', p_ele_type_id);
536: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
537: RAISE e_record_error;
538: RETURN (NULL);
539: END;
540:

Line 1468: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_TYPE_ID');

1464: WHEN NO_DATA_FOUND
1465: THEN
1466: --
1467: g_status := 'ERRORS';
1468: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_TYPE_ID');
1469: fnd_message.set_token ('ELE_NAME', p_element_name);
1470: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1471: RAISE e_record_error;
1472: --

Line 1469: fnd_message.set_token ('ELE_NAME', p_element_name);

1465: THEN
1466: --
1467: g_status := 'ERRORS';
1468: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_TYPE_ID');
1469: fnd_message.set_token ('ELE_NAME', p_element_name);
1470: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1471: RAISE e_record_error;
1472: --
1473: RETURN (NULL);

Line 1470: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

1466: --
1467: g_status := 'ERRORS';
1468: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_TYPE_ID');
1469: fnd_message.set_token ('ELE_NAME', p_element_name);
1470: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1471: RAISE e_record_error;
1472: --
1473: RETURN (NULL);
1474: END;

Line 1663: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_OTMERR');

1659: IF l_otm_error IS NOT NULL
1660: THEN
1661: --
1662: g_status := 'ERRORS';
1663: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_OTMERR');
1664: fnd_message.set_token ('ERROR', l_otm_error);
1665: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1666: RAISE e_record_error;
1667: --

Line 1664: fnd_message.set_token ('ERROR', l_otm_error);

1660: THEN
1661: --
1662: g_status := 'ERRORS';
1663: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_OTMERR');
1664: fnd_message.set_token ('ERROR', l_otm_error);
1665: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1666: RAISE e_record_error;
1667: --
1668: END IF;

Line 1665: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

1661: --
1662: g_status := 'ERRORS';
1663: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_OTMERR');
1664: fnd_message.set_token ('ERROR', l_otm_error);
1665: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1666: RAISE e_record_error;
1667: --
1668: END IF;
1669:

Line 1675: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_ORAERR');

1671: IF l_oracle_error IS NOT NULL
1672: THEN
1673: --
1674: g_status := 'ERRORS';
1675: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_ORAERR');
1676: fnd_message.set_token ('ERROR', l_oracle_error);
1677: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1678: RAISE e_record_error;
1679: --

Line 1676: fnd_message.set_token ('ERROR', l_oracle_error);

1672: THEN
1673: --
1674: g_status := 'ERRORS';
1675: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_ORAERR');
1676: fnd_message.set_token ('ERROR', l_oracle_error);
1677: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1678: RAISE e_record_error;
1679: --
1680: END IF;

Line 1677: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

1673: --
1674: g_status := 'ERRORS';
1675: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_ORAERR');
1676: fnd_message.set_token ('ERROR', l_oracle_error);
1677: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1678: RAISE e_record_error;
1679: --
1680: END IF;
1681:

Line 1866: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_BATCH_HDR_API');

1862: EXCEPTION
1863: WHEN OTHERS
1864: THEN
1865: g_status := 'ERRORS';
1866: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_BATCH_HDR_API');
1867: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1868: RAISE e_retrieval_error;
1869: END create_batch;
1870:

Line 1867: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

1863: WHEN OTHERS
1864: THEN
1865: g_status := 'ERRORS';
1866: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_BATCH_HDR_API');
1867: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1868: RAISE e_retrieval_error;
1869: END create_batch;
1870:
1871: --

Line 1898: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');

1894: EXCEPTION
1895: WHEN NO_DATA_FOUND
1896: THEN
1897: g_status := 'ERRORS';
1898: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
1899: fnd_message.set_token ('PERSON_NAME', g_full_name);
1900: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1901: RAISE e_record_error;
1902: RETURN;

Line 1899: fnd_message.set_token ('PERSON_NAME', g_full_name);

1895: WHEN NO_DATA_FOUND
1896: THEN
1897: g_status := 'ERRORS';
1898: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
1899: fnd_message.set_token ('PERSON_NAME', g_full_name);
1900: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1901: RAISE e_record_error;
1902: RETURN;
1903: END;

Line 1900: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

1896: THEN
1897: g_status := 'ERRORS';
1898: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
1899: fnd_message.set_token ('PERSON_NAME', g_full_name);
1900: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1901: RAISE e_record_error;
1902: RETURN;
1903: END;
1904: --

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

2067: IF (hxc_generic_retrieval_pkg.t_tx_detail_bb_id (p_bb_index) <>
2068: p_bb_id
2069: )
2070: THEN
2071: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2072: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2073: fnd_message.set_token ('STEP', 'status bb id mismatch');
2074: fnd_message.raise_error;
2075: END IF;

Line 2072: fnd_message.set_token ('PROCEDURE', 'set_transaction');

2068: p_bb_id
2069: )
2070: THEN
2071: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2072: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2073: fnd_message.set_token ('STEP', 'status bb id mismatch');
2074: fnd_message.raise_error;
2075: END IF;
2076:

Line 2073: fnd_message.set_token ('STEP', 'status bb id mismatch');

2069: )
2070: THEN
2071: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2072: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2073: fnd_message.set_token ('STEP', 'status bb id mismatch');
2074: fnd_message.raise_error;
2075: END IF;
2076:
2077: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;

Line 2074: fnd_message.raise_error;

2070: THEN
2071: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2072: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2073: fnd_message.set_token ('STEP', 'status bb id mismatch');
2074: fnd_message.raise_error;
2075: END IF;
2076:
2077: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;
2078: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=

Line 2661: fnd_message.set_name

2657: hr_utility.TRACE
2658: ('in old bb id exception!!!');
2659: END IF;
2660:
2661: fnd_message.set_name
2662: ('PAY',
2663: 'HR_6153_ALL_PROCEDURE_FAIL'
2664: );
2665: fnd_message.set_token ('PROCEDURE',

Line 2665: fnd_message.set_token ('PROCEDURE',

2661: fnd_message.set_name
2662: ('PAY',
2663: 'HR_6153_ALL_PROCEDURE_FAIL'
2664: );
2665: fnd_message.set_token ('PROCEDURE',
2666: 'transfer to otm'
2667: );
2668: fnd_message.set_token ('STEP',
2669: 'bld blk mismatch'

Line 2668: fnd_message.set_token ('STEP',

2664: );
2665: fnd_message.set_token ('PROCEDURE',
2666: 'transfer to otm'
2667: );
2668: fnd_message.set_token ('STEP',
2669: 'bld blk mismatch'
2670: );
2671: fnd_message.raise_error;
2672: END IF;

Line 2671: fnd_message.raise_error;

2667: );
2668: fnd_message.set_token ('STEP',
2669: 'bld blk mismatch'
2670: );
2671: fnd_message.raise_error;
2672: END IF;
2673:
2674: --
2675: IF g_debug

Line 3222: fnd_message.set_name ('HXC',

3218: --
3219: -- TRANSACTION_STATUS: S (Success), E (Errors), W (Warnings)
3220: --
3221: g_status := 'SUCCESS';
3222: fnd_message.set_name ('HXC',
3223: 'HXC_HXT_RET_REC_SUCCESS');
3224: g_exception_description :=
3225: SUBSTR (fnd_message.get, 1, 2000);
3226: --

Line 3225: SUBSTR (fnd_message.get, 1, 2000);

3221: g_status := 'SUCCESS';
3222: fnd_message.set_name ('HXC',
3223: 'HXC_HXT_RET_REC_SUCCESS');
3224: g_exception_description :=
3225: SUBSTR (fnd_message.get, 1, 2000);
3226: --
3227: set_transaction (p_bb_id => l_bb_id,
3228: p_bb_index => l_cnt,
3229: p_status => g_status,

Line 3331: fnd_message.set_name ('HXT', 'HXT_39443_HRS_AMT_EDIT');

3327: THEN
3328: hr_utility.set_location (c_proc, 666);
3329: END IF;
3330:
3331: fnd_message.set_name ('HXT', 'HXT_39443_HRS_AMT_EDIT');
3332: g_status := 'ERRORS';
3333: g_exception_description :=
3334: SUBSTR (fnd_message.get, 1, 2000);
3335:

Line 3334: SUBSTR (fnd_message.get, 1, 2000);

3330:
3331: fnd_message.set_name ('HXT', 'HXT_39443_HRS_AMT_EDIT');
3332: g_status := 'ERRORS';
3333: g_exception_description :=
3334: SUBSTR (fnd_message.get, 1, 2000);
3335:
3336: IF g_debug
3337: THEN
3338: hr_utility.TRACE ( 'g_exception_description is : '

Line 3382: fnd_message.raise_error;

3378: THEN
3379: hr_utility.set_location (c_proc, 666.5);
3380: END IF;
3381:
3382: fnd_message.raise_error;
3383: RETURN;
3384: WHEN e_not_retrievable
3385: THEN
3386: IF g_debug

Line 3391: fnd_message.set_name ('HXT',

3387: THEN
3388: hr_utility.set_location (c_proc, 700);
3389: END IF;
3390:
3391: fnd_message.set_name ('HXT',
3392: 'HXT_TC_CANNOT_BE_CHANGED_TODAY'
3393: );
3394: g_status := 'ERRORS';
3395: g_exception_description :=

Line 3396: SUBSTR (fnd_message.get, 1, 2000);

3392: 'HXT_TC_CANNOT_BE_CHANGED_TODAY'
3393: );
3394: g_status := 'ERRORS';
3395: g_exception_description :=
3396: SUBSTR (fnd_message.get, 1, 2000);
3397:
3398: IF g_debug
3399: THEN
3400: hr_utility.TRACE ( 'g_exception_description is : '

Line 3522: fnd_message.set_name ('HXC', 'HXC_HXT_RET_PROC_SUCCESS');

3518: --
3519: hxc_generic_retrieval_utils.set_parent_statuses;
3520: --
3521: g_status := 'SUCCESS';
3522: fnd_message.set_name ('HXC', 'HXC_HXT_RET_PROC_SUCCESS');
3523: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
3524: --
3525: hxc_generic_retrieval_pkg.update_transaction_status
3526: (p_process => l_process_name,

Line 3523: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);

3519: hxc_generic_retrieval_utils.set_parent_statuses;
3520: --
3521: g_status := 'SUCCESS';
3522: fnd_message.set_name ('HXC', 'HXC_HXT_RET_PROC_SUCCESS');
3523: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
3524: --
3525: hxc_generic_retrieval_pkg.update_transaction_status
3526: (p_process => l_process_name,
3527: p_status => g_status,

Line 3652: fnd_message.raise_error;

3648: p_exception_description => g_exception_description,
3649: p_rollback => FALSE
3650: );
3651: --
3652: fnd_message.raise_error;
3653: --
3654: END IF;
3655:
3656: --

Line 3671: fnd_message.raise_error;

3667: );
3668:
3669: IF (SQLERRM LIKE '%HXC_0017_GNRET_PROCESS_RUNNING%')
3670: THEN
3671: fnd_message.raise_error;
3672: ELSE
3673: p_no_otm := 'Y';
3674: END IF;
3675: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')

Line 3686: fnd_message.raise_error;

3682: p_exception_description => g_exception_description,
3683: p_rollback => FALSE
3684: );
3685: --
3686: fnd_message.raise_error;
3687: END IF;
3688:
3689: --
3690: RETURN;