APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXC_GENERIC_RETRIEVAL_UTILS

Line 4293: hxc_generic_retrieval_utils.set_parent_statuses;

4289:
4290: --
4291: --------------- Update Transaction in OTC for whole process ---------------
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);

Line 4399: hxc_generic_retrieval_utils.set_parent_statuses;

4395: EXCEPTION
4396: WHEN e_retrieval_error
4397: THEN
4398: --
4399: hxc_generic_retrieval_utils.set_parent_statuses;
4400: --
4401: hxc_generic_retrieval_pkg.update_transaction_status
4402: (p_process => l_process_name,
4403: p_status => g_status,

Line 4431: hxc_generic_retrieval_utils.set_parent_statuses;

4427: --
4428: IF SQLERRM NOT LIKE '%HXC%'
4429: THEN
4430: --
4431: hxc_generic_retrieval_utils.set_parent_statuses;
4432: --
4433: hxc_generic_retrieval_pkg.update_transaction_status
4434: (p_process => l_process_name,
4435: p_status => g_status,

Line 4449: hxc_generic_retrieval_utils.set_parent_statuses;

4445: IF ( (SQLERRM LIKE '%HXC%')
4446: AND (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'BOTH')
4447: )
4448: THEN
4449: hxc_generic_retrieval_utils.set_parent_statuses;
4450: hxc_generic_retrieval_pkg.update_transaction_status
4451: (p_process => l_process_name,
4452: p_status => 'ERRORS',
4453: p_exception_description => g_exception_description,

Line 4465: hxc_generic_retrieval_utils.set_parent_statuses;

4461: p_no_otm := 'Y';
4462: END IF;
4463: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')
4464: THEN
4465: hxc_generic_retrieval_utils.set_parent_statuses;
4466: --
4467: hxc_generic_retrieval_pkg.update_transaction_status
4468: (p_process => l_process_name,
4469: p_status => 'ERRORS',