APPS.XDPCORE_FA dependencies on XDP_UTILITIES

Line 241: lv_fa_status := XDP_UTILITIES.g_system_hold;

237:
238:
239:
240: IF p_system_hold = 'Y' THEN
241: lv_fa_status := XDP_UTILITIES.g_system_hold;
242: ELSE
243: lv_fa_status := XDP_UTILITIES.g_wait_for_resource;
244: END IF;
245: -- Change FA Instance status...

Line 243: lv_fa_status := XDP_UTILITIES.g_wait_for_resource;

239:
240: IF p_system_hold = 'Y' THEN
241: lv_fa_status := XDP_UTILITIES.g_system_hold;
242: ELSE
243: lv_fa_status := XDP_UTILITIES.g_wait_for_resource;
244: END IF;
245: -- Change FA Instance status...
246:
247: UPDATE xdp_fa_runtime_list

Line 1377: XDP_UTILITIES.CallFAMapProc (P_PROCEDURE_NAME => l_FAListProc,

1373: * Found a FA runtime mapping procedure.
1374: * Need to execute it dynamically to populate all the FA's
1375: */
1376:
1377: XDP_UTILITIES.CallFAMapProc (P_PROCEDURE_NAME => l_FAListProc,
1378: P_ORDER_ID => l_OrderID,
1379: P_LINE_ITEM_ID => l_LineItemID,
1380: P_WI_INSTANCE_ID => l_WIInstanceID,
1381: P_RETURN_CODE => l_ErrCode,

Line 1795: XDP_UTILITIES.CallFERoutingProc ( P_PROCEDURE_NAME => l_LocateFEProc,

1791: /*
1792: dynamically execute the Locate FE procedure and get the FE into l_FeName
1793: */
1794:
1795: XDP_UTILITIES.CallFERoutingProc ( P_PROCEDURE_NAME => l_LocateFEProc,
1796: P_ORDER_ID => l_OrderID,
1797: P_LINE_ITEM_ID => l_LineItemID,
1798: P_WI_INSTANCE_ID => l_WIInstanceID,
1799: P_FA_INSTANCE_ID => l_FAInstanceID,

Line 2404: XDP_UTILITIES.CALLFULFILLMENTPROC (P_PROCEDURE_NAME => l_FPName,

2400:
2401: /* Need to dynamically execute the FP with te above parameters */
2402:
2403:
2404: XDP_UTILITIES.CALLFULFILLMENTPROC (P_PROCEDURE_NAME => l_FPName,
2405: P_ORDER_ID => l_OrderID,
2406: P_LINE_ITEM_ID => l_LineItemID,
2407: P_WI_INSTANCE_ID => l_WIInstanceID,
2408: P_FA_INSTANCE_ID => l_FAInstanceID,

Line 5007: XDP_UTILITIES.Call_NEConnection_Proc(l_DisConnectProc,

5003: XDP_ENGINE.GET_FE_CONNECTIONPROC( FeName,
5004: l_ConnectProc,
5005: l_DisconnectProc);
5006:
5007: XDP_UTILITIES.Call_NEConnection_Proc(l_DisConnectProc,
5008: FeName,
5009: ChannelName,
5010: ErrCode,
5011: ErrStr);

Line 5348: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;

5344: CURSOR cur_error_count IS
5345: SELECT error_count
5346: FROM xdp_error_count
5347: WHERE object_key = p_fp_name
5348: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;
5349:
5350: BEGIN
5351:
5352: -- get the threshold..

Line 5434: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;

5430: CURSOR cur_error_count IS
5431: SELECT error_count
5432: FROM xdp_error_count
5433: WHERE object_key = p_fp_name
5434: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;
5435:
5436: BEGIN
5437:
5438: -- get the threshold..

Line 5493: XDP_UTILITIES.g_fp_object_type,

5489: last_update_date,
5490: last_update_login
5491: )
5492: VALUES (
5493: XDP_UTILITIES.g_fp_object_type,
5494: p_fp_name,
5495: 1,
5496: FND_GLOBAL.USER_ID,
5497: sysdate,

Line 5527: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;

5523: CURSOR cur_error_count IS
5524: SELECT error_count
5525: FROM xdp_error_count
5526: WHERE object_key = p_fp_name
5527: AND object_type = XDP_UTILITIES.g_fp_object_type FOR UPDATE;
5528:
5529: BEGIN
5530: -- get the threshold..
5531: IF( fnd_profile.defined( g_xdp_fp_error_threshold) ) THEN

Line 5554: AND status_code = XDP_UTILITIES.g_system_hold );

5550: last_update_login = FND_GLOBAL.USER_ID
5551: WHERE fa_instance_id in ( SELECT fa_instance_id
5552: FROM xdp_fa_runtime_list
5553: WHERE proc_name = p_fp_name
5554: AND status_code = XDP_UTILITIES.g_system_hold );
5555: UPDATE xdp_fa_runtime_list
5556: SET status_code = XDP_UTILITIES.g_wait_for_resource,
5557: last_updated_by = FND_GLOBAL.USER_ID,
5558: last_update_date = sysdate,

Line 5556: SET status_code = XDP_UTILITIES.g_wait_for_resource,

5552: FROM xdp_fa_runtime_list
5553: WHERE proc_name = p_fp_name
5554: AND status_code = XDP_UTILITIES.g_system_hold );
5555: UPDATE xdp_fa_runtime_list
5556: SET status_code = XDP_UTILITIES.g_wait_for_resource,
5557: last_updated_by = FND_GLOBAL.USER_ID,
5558: last_update_date = sysdate,
5559: last_update_login = FND_GLOBAL.USER_ID
5560: WHERE proc_name = p_fp_name

Line 5561: AND status_code = XDP_UTILITIES.g_system_hold;

5557: last_updated_by = FND_GLOBAL.USER_ID,
5558: last_update_date = sysdate,
5559: last_update_login = FND_GLOBAL.USER_ID
5560: WHERE proc_name = p_fp_name
5561: AND status_code = XDP_UTILITIES.g_system_hold;
5562: END IF;
5563:
5564: -- finally set the error count to Zero..
5565: UPDATE xdp_error_count