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 532: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');

528: -- verify that.
529: IF g_intg_pref_tab.EXISTS(p_tc_bb_id)
530: AND g_intg_pref_tab(p_tc_bb_id) = 1
531: THEN
532: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');
533: g_intg_error := fnd_message.get;
534: l_is_retrievable := FALSE;
535: RETURN l_is_retrievable;
536: ELSIF g_intg_pref_tab.EXISTS(p_tc_bb_id)

Line 533: g_intg_error := fnd_message.get;

529: IF g_intg_pref_tab.EXISTS(p_tc_bb_id)
530: AND g_intg_pref_tab(p_tc_bb_id) = 1
531: THEN
532: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');
533: g_intg_error := fnd_message.get;
534: l_is_retrievable := FALSE;
535: RETURN l_is_retrievable;
536: ELSIF g_intg_pref_tab.EXISTS(p_tc_bb_id)
537: AND g_intg_pref_tab(p_tc_bb_id) = 0

Line 612: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');

608:
609: -- Set the integration error, and return.
610: IF g_intg_pref_tab(p_tc_bb_id) = 1
611: THEN
612: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');
613: g_intg_error := fnd_message.get;
614: l_is_retrievable := FALSE;
615: RETURN l_is_retrievable;
616: END IF;

Line 613: g_intg_error := fnd_message.get;

609: -- Set the integration error, and return.
610: IF g_intg_pref_tab(p_tc_bb_id) = 1
611: THEN
612: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');
613: g_intg_error := fnd_message.get;
614: l_is_retrievable := FALSE;
615: RETURN l_is_retrievable;
616: END IF;
617: END IF;

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

698: WHEN NO_DATA_FOUND
699: THEN
700: --
701: g_status := 'ERRORS';
702: fnd_message.set_name ('HXC', 'HXC_HXT_RET_NO_EMP_NUMBER');
703: fnd_message.set_token ('PERSON_NAME', g_full_name);
704: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
705: RAISE e_record_error;
706: --

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

699: THEN
700: --
701: g_status := 'ERRORS';
702: fnd_message.set_name ('HXC', 'HXC_HXT_RET_NO_EMP_NUMBER');
703: fnd_message.set_token ('PERSON_NAME', g_full_name);
704: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
705: RAISE e_record_error;
706: --
707: RETURN (NULL);

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

700: --
701: g_status := 'ERRORS';
702: fnd_message.set_name ('HXC', 'HXC_HXT_RET_NO_EMP_NUMBER');
703: fnd_message.set_token ('PERSON_NAME', g_full_name);
704: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
705: RAISE e_record_error;
706: --
707: RETURN (NULL);
708: END;

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

749: EXCEPTION
750: WHEN NO_DATA_FOUND
751: THEN
752: g_status := 'ERRORS';
753: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
754: fnd_message.set_token ('PERSON_NAME', g_full_name);
755: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
756: RAISE e_record_error;
757: RETURN;

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

750: WHEN NO_DATA_FOUND
751: THEN
752: g_status := 'ERRORS';
753: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
754: fnd_message.set_token ('PERSON_NAME', g_full_name);
755: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
756: RAISE e_record_error;
757: RETURN;
758: END;

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

751: THEN
752: g_status := 'ERRORS';
753: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
754: fnd_message.set_token ('PERSON_NAME', g_full_name);
755: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
756: RAISE e_record_error;
757: RETURN;
758: END;
759: --

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

810: p_time_sum_start_date := NULL;
811: p_time_sum_end_date := NULL;
812: --
813: -- g_status := 'ERRORS';
814: -- fnd_message.set_name('HXC', 'HXC_HXT_RET_NO_TIMECARD');
815: -- fnd_message.set_token('PERSON_NAME', g_full_name);
816: -- g_exception_description := SUBSTR(fnd_message.get,1,2000);
817: -- raise e_record_error;
818: --

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

811: p_time_sum_end_date := NULL;
812: --
813: -- g_status := 'ERRORS';
814: -- fnd_message.set_name('HXC', 'HXC_HXT_RET_NO_TIMECARD');
815: -- fnd_message.set_token('PERSON_NAME', g_full_name);
816: -- g_exception_description := SUBSTR(fnd_message.get,1,2000);
817: -- raise e_record_error;
818: --
819: WHEN TOO_MANY_ROWS

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

812: --
813: -- g_status := 'ERRORS';
814: -- fnd_message.set_name('HXC', 'HXC_HXT_RET_NO_TIMECARD');
815: -- fnd_message.set_token('PERSON_NAME', g_full_name);
816: -- g_exception_description := SUBSTR(fnd_message.get,1,2000);
817: -- raise e_record_error;
818: --
819: WHEN TOO_MANY_ROWS
820: THEN

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

818: --
819: WHEN TOO_MANY_ROWS
820: THEN
821: g_status := 'ERRORS';
822: fnd_message.set_name ('HXC', 'HXC_HXT_CANNOT_UPDATE');
823: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
824: RAISE e_record_error;
825: RETURN;
826: END;

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

819: WHEN TOO_MANY_ROWS
820: THEN
821: g_status := 'ERRORS';
822: fnd_message.set_name ('HXC', 'HXC_HXT_CANNOT_UPDATE');
823: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
824: RAISE e_record_error;
825: RETURN;
826: END;
827: --

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

927: -- sanity check to make sure we are in sync
928: --
929: IF (l_bld_blk_id <> p_bb_id)
930: THEN
931: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
932: fnd_message.set_token ('PROCEDURE', 'get_attribute');
933: fnd_message.set_token ('STEP', 'bld blk mismatch');
934: fnd_message.raise_error;
935: END IF;

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

928: --
929: IF (l_bld_blk_id <> p_bb_id)
930: THEN
931: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
932: fnd_message.set_token ('PROCEDURE', 'get_attribute');
933: fnd_message.set_token ('STEP', 'bld blk mismatch');
934: fnd_message.raise_error;
935: END IF;
936:

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

929: IF (l_bld_blk_id <> p_bb_id)
930: THEN
931: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
932: fnd_message.set_token ('PROCEDURE', 'get_attribute');
933: fnd_message.set_token ('STEP', 'bld blk mismatch');
934: fnd_message.raise_error;
935: END IF;
936:
937: --

Line 934: fnd_message.raise_error;

930: THEN
931: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
932: fnd_message.set_token ('PROCEDURE', 'get_attribute');
933: fnd_message.set_token ('STEP', 'bld blk mismatch');
934: fnd_message.raise_error;
935: END IF;
936:
937: --
938: IF p_att_table.COUNT <> 0

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

1032: EXCEPTION
1033: WHEN NO_DATA_FOUND
1034: THEN
1035: g_status := 'ERRORS';
1036: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_NAME');
1037: fnd_message.set_token ('ELE_TYPE_ID', p_ele_type_id);
1038: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1039: RAISE e_record_error;
1040: RETURN (NULL);

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

1033: WHEN NO_DATA_FOUND
1034: THEN
1035: g_status := 'ERRORS';
1036: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_NAME');
1037: fnd_message.set_token ('ELE_TYPE_ID', p_ele_type_id);
1038: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1039: RAISE e_record_error;
1040: RETURN (NULL);
1041: END;

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

1034: THEN
1035: g_status := 'ERRORS';
1036: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_NAME');
1037: fnd_message.set_token ('ELE_TYPE_ID', p_ele_type_id);
1038: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
1039: RAISE e_record_error;
1040: RETURN (NULL);
1041: END;
1042:

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

2059: WHEN NO_DATA_FOUND
2060: THEN
2061: --
2062: g_status := 'ERRORS';
2063: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_TYPE_ID');
2064: fnd_message.set_token ('ELE_NAME', p_element_name);
2065: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2066: RAISE e_record_error;
2067: --

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

2060: THEN
2061: --
2062: g_status := 'ERRORS';
2063: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_TYPE_ID');
2064: fnd_message.set_token ('ELE_NAME', p_element_name);
2065: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2066: RAISE e_record_error;
2067: --
2068: RETURN (NULL);

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

2061: --
2062: g_status := 'ERRORS';
2063: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ELE_TYPE_ID');
2064: fnd_message.set_token ('ELE_NAME', p_element_name);
2065: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2066: RAISE e_record_error;
2067: --
2068: RETURN (NULL);
2069: END;

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

2254: IF l_otm_error IS NOT NULL
2255: THEN
2256: --
2257: g_status := 'ERRORS';
2258: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_OTMERR');
2259: fnd_message.set_token ('ERROR', l_otm_error);
2260: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2261: RAISE e_record_error;
2262: --

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

2255: THEN
2256: --
2257: g_status := 'ERRORS';
2258: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_OTMERR');
2259: fnd_message.set_token ('ERROR', l_otm_error);
2260: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2261: RAISE e_record_error;
2262: --
2263: END IF;

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

2256: --
2257: g_status := 'ERRORS';
2258: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_OTMERR');
2259: fnd_message.set_token ('ERROR', l_otm_error);
2260: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2261: RAISE e_record_error;
2262: --
2263: END IF;
2264:

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

2266: IF l_oracle_error IS NOT NULL
2267: THEN
2268: --
2269: g_status := 'ERRORS';
2270: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_ORAERR');
2271: fnd_message.set_token ('ERROR', l_oracle_error);
2272: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2273: RAISE e_record_error;
2274: --

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

2267: THEN
2268: --
2269: g_status := 'ERRORS';
2270: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_ORAERR');
2271: fnd_message.set_token ('ERROR', l_oracle_error);
2272: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2273: RAISE e_record_error;
2274: --
2275: END IF;

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

2268: --
2269: g_status := 'ERRORS';
2270: fnd_message.set_name ('HXC', 'HXC_HXT_DEP_VAL_ORAERR');
2271: fnd_message.set_token ('ERROR', l_oracle_error);
2272: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2273: RAISE e_record_error;
2274: --
2275: END IF;
2276:

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

2516: WHEN OTHERS
2517: THEN
2518: hr_utility.trace(dbms_utility.format_error_backtrace);
2519: g_status := 'ERRORS';
2520: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_BATCH_HDR_API');
2521: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2522: RAISE e_retrieval_error;
2523: END create_batch;
2524:

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

2517: THEN
2518: hr_utility.trace(dbms_utility.format_error_backtrace);
2519: g_status := 'ERRORS';
2520: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_BATCH_HDR_API');
2521: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2522: RAISE e_retrieval_error;
2523: END create_batch;
2524:
2525: --

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

2548: EXCEPTION
2549: WHEN NO_DATA_FOUND
2550: THEN
2551: g_status := 'ERRORS';
2552: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
2553: fnd_message.set_token ('PERSON_NAME', g_full_name);
2554: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2555: RAISE e_record_error;
2556: RETURN;

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

2549: WHEN NO_DATA_FOUND
2550: THEN
2551: g_status := 'ERRORS';
2552: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
2553: fnd_message.set_token ('PERSON_NAME', g_full_name);
2554: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2555: RAISE e_record_error;
2556: RETURN;
2557: END;

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

2550: THEN
2551: g_status := 'ERRORS';
2552: fnd_message.set_name ('HXC', 'HXC_HRPAY_RET_NO_ASSIGN');
2553: fnd_message.set_token ('PERSON_NAME', g_full_name);
2554: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
2555: RAISE e_record_error;
2556: RETURN;
2557: END;
2558: --

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

2721: IF (hxc_generic_retrieval_pkg.t_tx_detail_bb_id (p_bb_index) <>
2722: p_bb_id
2723: )
2724: THEN
2725: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2726: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2727: fnd_message.set_token ('STEP', 'status bb id mismatch');
2728: fnd_message.raise_error;
2729: END IF;

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

2722: p_bb_id
2723: )
2724: THEN
2725: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2726: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2727: fnd_message.set_token ('STEP', 'status bb id mismatch');
2728: fnd_message.raise_error;
2729: END IF;
2730:

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

2723: )
2724: THEN
2725: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2726: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2727: fnd_message.set_token ('STEP', 'status bb id mismatch');
2728: fnd_message.raise_error;
2729: END IF;
2730:
2731: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;

Line 2728: fnd_message.raise_error;

2724: THEN
2725: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2726: fnd_message.set_token ('PROCEDURE', 'set_transaction');
2727: fnd_message.set_token ('STEP', 'status bb id mismatch');
2728: fnd_message.raise_error;
2729: END IF;
2730:
2731: hxc_generic_retrieval_pkg.t_tx_detail_status (p_bb_index) := p_status;
2732: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_bb_index) :=

Line 3335: fnd_message.set_name

3331: hr_utility.TRACE
3332: ('in old bb id exception!!!');
3333: END IF;
3334:
3335: fnd_message.set_name
3336: ('PAY',
3337: 'HR_6153_ALL_PROCEDURE_FAIL'
3338: );
3339: fnd_message.set_token ('PROCEDURE',

Line 3339: fnd_message.set_token ('PROCEDURE',

3335: fnd_message.set_name
3336: ('PAY',
3337: 'HR_6153_ALL_PROCEDURE_FAIL'
3338: );
3339: fnd_message.set_token ('PROCEDURE',
3340: 'transfer to otm'
3341: );
3342: fnd_message.set_token ('STEP',
3343: 'bld blk mismatch'

Line 3342: fnd_message.set_token ('STEP',

3338: );
3339: fnd_message.set_token ('PROCEDURE',
3340: 'transfer to otm'
3341: );
3342: fnd_message.set_token ('STEP',
3343: 'bld blk mismatch'
3344: );
3345: fnd_message.raise_error;
3346: END IF;

Line 3345: fnd_message.raise_error;

3341: );
3342: fnd_message.set_token ('STEP',
3343: 'bld blk mismatch'
3344: );
3345: fnd_message.raise_error;
3346: END IF;
3347:
3348: --
3349: IF g_debug

Line 3929: fnd_message.set_name ('HXC',

3925: --
3926: -- TRANSACTION_STATUS: S (Success), E (Errors), W (Warnings)
3927: --
3928: g_status := 'SUCCESS';
3929: fnd_message.set_name ('HXC',
3930: 'HXC_HXT_RET_REC_SUCCESS');
3931: g_exception_description :=
3932: SUBSTR (fnd_message.get, 1, 2000);
3933: --

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

3928: g_status := 'SUCCESS';
3929: fnd_message.set_name ('HXC',
3930: 'HXC_HXT_RET_REC_SUCCESS');
3931: g_exception_description :=
3932: SUBSTR (fnd_message.get, 1, 2000);
3933: --
3934: set_transaction (p_bb_id => l_bb_id,
3935: p_bb_index => l_cnt,
3936: p_status => g_status,

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

4062: THEN
4063: hr_utility.set_location (c_proc, 666);
4064: END IF;
4065:
4066: fnd_message.set_name ('HXT', 'HXT_39443_HRS_AMT_EDIT');
4067: g_status := 'ERRORS';
4068: g_exception_description :=
4069: SUBSTR (fnd_message.get, 1, 2000);
4070:

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

4065:
4066: fnd_message.set_name ('HXT', 'HXT_39443_HRS_AMT_EDIT');
4067: g_status := 'ERRORS';
4068: g_exception_description :=
4069: SUBSTR (fnd_message.get, 1, 2000);
4070:
4071: IF g_debug
4072: THEN
4073: hr_utility.TRACE ( 'g_exception_description is : '

Line 4124: fnd_message.raise_error;

4120: THEN
4121: hr_utility.set_location (c_proc, 666.5);
4122: END IF;
4123:
4124: fnd_message.raise_error;
4125: RETURN;
4126: WHEN e_not_retrievable
4127: THEN
4128: IF g_debug

Line 4138: fnd_message.set_name ('HXT',

4134: IF g_intg_error IS NULL
4135: -- This means we got an exception to raise an Edit error.
4136: THEN
4137:
4138: fnd_message.set_name ('HXT',
4139: 'HXT_TC_CANNOT_BE_CHANGED_TODAY'
4140: );
4141: g_status := 'ERRORS';
4142: g_exception_description :=

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

4139: 'HXT_TC_CANNOT_BE_CHANGED_TODAY'
4140: );
4141: g_status := 'ERRORS';
4142: g_exception_description :=
4143: SUBSTR (fnd_message.get, 1, 2000);
4144:
4145: ELSE
4146: -- This means we got an exception to raise an error for
4147: -- Pay- PA integration.

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

4292: --
4293: hxc_generic_retrieval_utils.set_parent_statuses;
4294: --
4295: g_status := 'SUCCESS';
4296: fnd_message.set_name ('HXC', 'HXC_HXT_RET_PROC_SUCCESS');
4297: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
4298:
4299:
4300: -- Bug 12919783

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

4293: hxc_generic_retrieval_utils.set_parent_statuses;
4294: --
4295: g_status := 'SUCCESS';
4296: fnd_message.set_name ('HXC', 'HXC_HXT_RET_PROC_SUCCESS');
4297: g_exception_description := SUBSTR (fnd_message.get, 1, 2000);
4298:
4299:
4300: -- Bug 12919783
4301: -- There might be held batches for this chunk.

Line 4440: fnd_message.raise_error;

4436: p_exception_description => g_exception_description,
4437: p_rollback => FALSE
4438: );
4439: --
4440: fnd_message.raise_error;
4441: --
4442: END IF;
4443:
4444: --

Line 4459: fnd_message.raise_error;

4455: );
4456:
4457: IF (SQLERRM LIKE '%HXC_0017_GNRET_PROCESS_RUNNING%')
4458: THEN
4459: fnd_message.raise_error;
4460: ELSE
4461: p_no_otm := 'Y';
4462: END IF;
4463: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')

Line 4474: fnd_message.raise_error;

4470: p_exception_description => g_exception_description,
4471: p_rollback => FALSE
4472: );
4473: --
4474: fnd_message.raise_error;
4475: END IF;
4476:
4477: --
4478: RETURN;