APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXC_GENERIC_RETRIEVAL_UTILS

Line 3519: hxc_generic_retrieval_utils.set_parent_statuses;

3515:
3516: --
3517: --------------- Update Transaction in OTC for whole process ---------------
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);

Line 3612: hxc_generic_retrieval_utils.set_parent_statuses;

3608: EXCEPTION
3609: WHEN e_retrieval_error
3610: THEN
3611: --
3612: hxc_generic_retrieval_utils.set_parent_statuses;
3613: --
3614: hxc_generic_retrieval_pkg.update_transaction_status
3615: (p_process => l_process_name,
3616: p_status => g_status,

Line 3643: hxc_generic_retrieval_utils.set_parent_statuses;

3639: --
3640: IF SQLERRM NOT LIKE '%HXC%'
3641: THEN
3642: --
3643: hxc_generic_retrieval_utils.set_parent_statuses;
3644: --
3645: hxc_generic_retrieval_pkg.update_transaction_status
3646: (p_process => l_process_name,
3647: p_status => g_status,

Line 3661: hxc_generic_retrieval_utils.set_parent_statuses;

3657: IF ( (SQLERRM LIKE '%HXC%')
3658: AND (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'BOTH')
3659: )
3660: THEN
3661: hxc_generic_retrieval_utils.set_parent_statuses;
3662: hxc_generic_retrieval_pkg.update_transaction_status
3663: (p_process => l_process_name,
3664: p_status => 'ERRORS',
3665: p_exception_description => g_exception_description,

Line 3677: hxc_generic_retrieval_utils.set_parent_statuses;

3673: p_no_otm := 'Y';
3674: END IF;
3675: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')
3676: THEN
3677: hxc_generic_retrieval_utils.set_parent_statuses;
3678: --
3679: hxc_generic_retrieval_pkg.update_transaction_status
3680: (p_process => l_process_name,
3681: p_status => 'ERRORS',