[Home] [Help]
657: request, there may be a case that all the lines of the Kit are not processed
658: leading to sure failure of this delayed request, which is incorrect. Hence, if
659: we happen to find this issue in future then we should introduce a new global and
660: set it to TRUE soon after the main big WHILE loop completes in
661: OE_Order_Pvt.Lines. Hence, ensure to check that global to TRUE before executing
662: this delayed request. If it is FALSE then reset the delayed request execution
663: (G_Delayed_Requests(p_request_ind).processed) to N. While this global is set
664: ensure to reset it to FALSE in the starting of the big WHILE Loop of the
665: OE_Order_Pvt.Lines and in the Exception block of it, and the Process_Request_Pvt
661: OE_Order_Pvt.Lines. Hence, ensure to check that global to TRUE before executing
662: this delayed request. If it is FALSE then reset the delayed request execution
663: (G_Delayed_Requests(p_request_ind).processed) to N. While this global is set
664: ensure to reset it to FALSE in the starting of the big WHILE Loop of the
665: OE_Order_Pvt.Lines and in the Exception block of it, and the Process_Request_Pvt
666: and Process_Delayed_Request procedures
667: */
668:
669: If l_debug_level > 0 then
2987: oe_debug_pub.add( 'EXIT PROCESS_REQUESTS_FOR_ENTITY' , 1 ) ;
2988: END IF;
2989: RETURN;
2990: END IF;
2991: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2992: p_In_out => 1);
2993:
2994:
2995: IF oe_globals.g_recursion_mode = 'N' THEN
3029: IF l_debug_level > 0 THEN
3030: oe_debug_pub.add('Exiting Process_Request_for_Entity ');
3031: END IF;
3032:
3033: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3034: p_In_out => 0);
3035: EXCEPTION
3036:
3037: WHEN FND_API.G_EXC_ERROR THEN
3034: p_In_out => 0);
3035: EXCEPTION
3036:
3037: WHEN FND_API.G_EXC_ERROR THEN
3038: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3039: p_In_out => 0);
3040: x_return_status := FND_API.G_RET_STS_ERROR;
3041:
3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3039: p_In_out => 0);
3040: x_return_status := FND_API.G_RET_STS_ERROR;
3041:
3042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3043: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3044: p_In_out => 0);
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3046:
3047: WHEN OTHERS THEN
3044: p_In_out => 0);
3045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3046:
3047: WHEN OTHERS THEN
3048: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3049: p_In_out => 0);
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3051:
3052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3090: END IF;
3091: RETURN;
3092: END IF;
3093:
3094: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3095: p_In_out => 1);
3096:
3097: --IF oe_globals.g_recursion_mode = 'N' THEN
3098: l_ind := G_Delayed_Requests.first;
3161: END LOOP;
3162:
3163: END IF;
3164: --END IF ; -- Recursion mode
3165: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3166: p_In_out => 0);
3167: IF l_debug_level > 0 THEN
3168: oe_debug_pub.add('leaving process_requenst_for_reqtype', 1);
3169: END IF;
3169: END IF;
3170: EXCEPTION
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3174: p_In_out => 0);
3175: oe_debug_pub.add('execution error', 1);
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177:
3175: oe_debug_pub.add('execution error', 1);
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177:
3178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3179: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3180: p_In_out => 0);
3181: oe_debug_pub.add('unexp error', 1);
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3183:
3181: oe_debug_pub.add('unexp error', 1);
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3183:
3184: WHEN OTHERS THEN
3185: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
3186: p_In_out => 0);
3187: oe_debug_pub.add('others error', 1);
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3189:
3218: oe_debug_pub.add( 'EXIT OE_Delayed_Requests_Pvt.Process_Delayed_Requests' , 1 ) ;
3219: END IF;
3220: RETURN;
3221: END IF;
3222: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3223: p_In_out => 1);
3224:
3225: -- Process requests as per the dependency
3226: -- Process a request to default header sales credit for
3982:
3983: -- clear the delayed request cache
3984: Clear_Request(x_return_status);
3985: END IF; -- Recursion mode
3986: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3987: p_In_out => 0);
3988:
3989: EXCEPTION
3990:
3988:
3989: EXCEPTION
3990:
3991: WHEN FND_API.G_EXC_ERROR THEN
3992: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3993: p_In_out => 0);
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995:
3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993: p_In_out => 0);
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995:
3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3997: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
3998: p_In_out => 0);
3999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4000:
4001: WHEN OTHERS THEN
3998: p_In_out => 0);
3999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4000:
4001: WHEN OTHERS THEN
4002: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
4003: p_In_out => 0);
4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005:
4006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4066:
4067: -- added for notification framework
4068: -- check code release leve first, notificaiont framework is at pack H
4069: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4070: oe_order_pvt.set_recursion_mode(p_Entity_Code => 10,
4071: p_In_out => 1);
4072: END IF;
4073:
4074: FOR i IN 1..p_x_request_tbl.COUNT LOOP
4723: END LOOP;
4724:
4725: -- added for notification framework
4726: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4727: oe_order_pvt.set_recursion_mode(p_Entity_Code => 10,
4728: p_In_out => 0);
4729: END IF;
4730: IF l_debug_level > 0 THEN
4731: oe_debug_pub.ADD('Exiting OE_ORDER_PUB.PROCESS_ORDER_ACTIONS', 1);