DBA Data[Home] [Help]

APPS.XDP_INTERFACES dependencies on XDP_ENGINE

Line 2646: x_parameter_value := XDP_ENGINE.Get_Order_Param_Value(p_order_id,p_parameter_name);

2642: x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
2643: )
2644: IS
2645: BEGIN
2646: x_parameter_value := XDP_ENGINE.Get_Order_Param_Value(p_order_id,p_parameter_name);
2647: x_RETURN_CODE := 0;
2648: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;
2649: EXCEPTION
2650: WHEN OTHERS THEN

Line 2664: ) RETURN XDP_ENGINE.PARAMETER_LIST

2660: FUNCTION Get_Order_Param_List(
2661: p_order_id IN NUMBER,
2662: x_RETURN_CODE OUT NOCOPY NUMBER,
2663: x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
2664: ) RETURN XDP_ENGINE.PARAMETER_LIST
2665: IS
2666: BEGIN
2667: x_return_code := 0;
2668: x_error_description := FND_API.G_RET_STS_SUCCESS;

Line 2669: RETURN XDP_ENGINE.Get_Order_Param_List(p_order_id);

2665: IS
2666: BEGIN
2667: x_return_code := 0;
2668: x_error_description := FND_API.G_RET_STS_SUCCESS;
2669: RETURN XDP_ENGINE.Get_Order_Param_List(p_order_id);
2670: EXCEPTION
2671: WHEN OTHERS THEN
2672: x_return_code := -191266;
2673: FND_MESSAGE.SET_NAME('XDP', 'XDP_API_WHEN_OTHERS');

Line 2696: x_parameter_value := XDP_ENGINE.Get_Line_Param_Value(l_line_item_id,p_parameter_name);

2692: FROM xdp_order_line_items
2693: WHERE order_id = p_order_id
2694: AND NVL(LINE_NUMBER,0) = NVL(p_line_number,0);
2695:
2696: x_parameter_value := XDP_ENGINE.Get_Line_Param_Value(l_line_item_id,p_parameter_name);
2697: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;
2698: x_return_code := 0;
2699: EXCEPTION
2700: WHEN OTHERS THEN

Line 2717: x_fulfillment_status := UPPER(XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS'));

2713: x_ERROR_DESCRIPTION OUT NOCOPY VARCHAR2
2714: ) IS
2715: BEGIN
2716: BEGIN
2717: x_fulfillment_status := UPPER(XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS'));
2718: EXCEPTION
2719: WHEN NO_DATA_FOUND THEN
2720: x_fulfillment_status := UPPER('Success');
2721: END;

Line 2723: x_fulfillment_result := XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_RESULT');

2719: WHEN NO_DATA_FOUND THEN
2720: x_fulfillment_status := UPPER('Success');
2721: END;
2722: BEGIN
2723: x_fulfillment_result := XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_RESULT');
2724: EXCEPTION
2725: WHEN NO_DATA_FOUND THEN
2726: x_fulfillment_result := '';
2727: END;

Line 2749: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS',p_fulfillment_status);

2745: )
2746: IS
2747: BEGIN
2748: IF (p_fulfillment_status IS NOT NULL) THEN
2749: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS',p_fulfillment_status);
2750: END IF;
2751:
2752: IF (p_fulfillment_result IS NOT NULL) THEN
2753: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_RESULT',p_fulfillment_result);

Line 2753: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_RESULT',p_fulfillment_result);

2749: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS',p_fulfillment_status);
2750: END IF;
2751:
2752: IF (p_fulfillment_result IS NOT NULL) THEN
2753: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_RESULT',p_fulfillment_result);
2754: END IF;
2755: x_RETURN_CODE := 0;
2756: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;
2757: EXCEPTION

Line 3059: x_order_status.fulfillment_status := XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS');

3055: FROM XDP_ORDER_HEADERS
3056: WHERE order_id = p_order_id;
3057:
3058: BEGIN
3059: x_order_status.fulfillment_status := XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS');
3060: EXCEPTION
3061: WHEN NO_DATA_FOUND THEN
3062: x_order_status.fulfillment_status := NULL;
3063: END;

Line 3065: x_order_status.fulfillment_result := XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_RESULT');

3061: WHEN NO_DATA_FOUND THEN
3062: x_order_status.fulfillment_status := NULL;
3063: END;
3064: BEGIN
3065: x_order_status.fulfillment_result := XDP_ENGINE.Get_Order_Param_Value(p_order_id,'FULFILLMENT_RESULT');
3066: EXCEPTION
3067: WHEN NO_DATA_FOUND THEN
3068: x_order_status.fulfillment_result := NULL;
3069: END;

Line 3852: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS',p_status);

3848: cancel_provisioning_date = sysdate
3849: WHERE order_id = p_order_id ;
3850:
3851: IF UPPER(p_status) = 'CANCELLED' THEN
3852: XDP_ENGINE.Set_Order_Param_Value(p_order_id,'FULFILLMENT_STATUS',p_status);
3853: END IF;
3854:
3855: EXCEPTION
3856: WHEN OTHERS THEN

Line 4034: XDP_ENGINE.Set_Line_Param_Value(p_line_item_id,'FULFILLMENT_STATUS',p_fulfillment_status,null);

4030: )
4031: IS
4032: BEGIN
4033: IF (p_fulfillment_status IS NOT NULL) THEN
4034: XDP_ENGINE.Set_Line_Param_Value(p_line_item_id,'FULFILLMENT_STATUS',p_fulfillment_status,null);
4035: END IF;
4036:
4037: x_RETURN_CODE := 0;
4038: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;

Line 4071: XDP_ENGINE.Set_Line_Param_Value(l_line_item_id,'FULFILLMENT_STATUS',p_fulfillment_status,null);

4067: null;
4068: END;
4069:
4070: IF (p_fulfillment_status IS NOT NULL) THEN
4071: XDP_ENGINE.Set_Line_Param_Value(l_line_item_id,'FULFILLMENT_STATUS',p_fulfillment_status,null);
4072: END IF;
4073:
4074: x_RETURN_CODE := 0;
4075: x_ERROR_DESCRIPTION := FND_API.G_RET_STS_SUCCESS;

Line 4096: x_fulfillment_status := UPPER(XDP_ENGINE.Get_Line_Param_Value(p_line_item_id,'FULFILLMENT_STATUS'))

4092: ) IS
4093: l_item_line_id NUMBER:=NULL;
4094: BEGIN
4095: BEGIN
4096: x_fulfillment_status := UPPER(XDP_ENGINE.Get_Line_Param_Value(p_line_item_id,'FULFILLMENT_STATUS'))
4097: ;
4098: EXCEPTION
4099: WHEN NO_DATA_FOUND THEN
4100: x_fulfillment_status := UPPER('Success');

Line 4137: x_fulfillment_status := UPPER(XDP_ENGINE.Get_Line_Param_Value(l_line_item_id,'FULFILLMENT_STATUS'))

4133: null;
4134: END;
4135:
4136: BEGIN
4137: x_fulfillment_status := UPPER(XDP_ENGINE.Get_Line_Param_Value(l_line_item_id,'FULFILLMENT_STATUS'))
4138: ;
4139: EXCEPTION
4140: WHEN NO_DATA_FOUND THEN
4141: x_fulfillment_status := UPPER('Success');