eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_DELAYED_REQUESTS_PVT

Line 1: PACKAGE BODY OE_Delayed_Requests_PVT AS

1: PACKAGE BODY OE_Delayed_Requests_PVT AS
2: /* $Header: OEXVREQB.pls 120.25.12010000.5 2008/11/20 14:00:36 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Delayed_Requests_PVT';

2: /* $Header: OEXVREQB.pls 120.25.12010000.5 2008/11/20 14:00:36 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Delayed_Requests_PVT';
7:
8: g_requesting_entities OE_Order_PUB.Requesting_Entity_Tbl_Type;
9: G_MAX_REQUESTS NUMBER := 10000;
10:

Line 68: oe_debug_pub.add('Entering Procedure Check_for_Request in Package OE_Delayed_Requests_Pvt');

64: BEGIN
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: x_result := FND_API.G_FALSE;
67: IF l_debug_level > 0 THEN
68: oe_debug_pub.add('Entering Procedure Check_for_Request in Package OE_Delayed_Requests_Pvt');
69: END IF;
70: -- l_ind to l_max_ind is the range of index positions that can
71: -- hold requests for this entity id - for e.g. if entity_id is
72: -- 2341 and G_MAX_REQUESTS is 10000 then the range would be:

Line 1948: oe_debug_pub.add('Entering Procedure Log_Request in Package OE_Delayed_Requests_Pvt, entity id: '||p_entity_id||', request type:'||p_request_type);

1944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1945: BEGIN
1946:
1947: IF l_debug_level > 0 THEN
1948: oe_debug_pub.add('Entering Procedure Log_Request in Package OE_Delayed_Requests_Pvt, entity id: '||p_entity_id||', request type:'||p_request_type);
1949: END IF;
1950:
1951: -- Initialize the request_record
1952: l_request.request_type := p_request_type;

Line 2424: oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');

2420: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2421: --
2422: BEGIN
2423: IF l_debug_level > 0 THEN
2424: oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
2425: END IF;
2426: x_return_status := FND_API.G_RET_STS_SUCCESS;
2427:
2428: Check_for_Request( p_entity_code => p_entity_code

Line 2499: oe_debug_pub.add('Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt');

2495: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2496: --
2497: BEGIN
2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add('Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt');
2500: END IF;
2501:
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;
2503:

Line 2557: oe_debug_pub.add('Entering Procedure Process_Request in Package OE_Delayed_Requests_Pvt');

2553: --
2554: Begin
2555: x_return_status := FND_API.G_RET_STS_SUCCESS;
2556: IF l_debug_level > 0 THEN
2557: oe_debug_pub.add('Entering Procedure Process_Request in Package OE_Delayed_Requests_Pvt');
2558: END IF;
2559: Check_for_Request( p_entity_code => p_entity_code
2560: ,p_entity_id => p_entity_id
2561: ,p_request_type => p_request_type

Line 2631: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Request_for_Entity',1);

2627: p_In_out => 1);
2628:
2629: x_return_status := FND_API.G_RET_STS_SUCCESS;
2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Request_for_Entity',1);
2632: END IF;
2633: IF oe_globals.g_recursion_mode = 'N' THEN
2634:
2635:

Line 2719: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package OE_Delayed_Requests_Pvt');

2715: x_return_status := FND_API.G_RET_STS_SUCCESS;
2716: oe_order_pvt.set_recursion_mode(p_Entity_Code => 11,
2717: p_In_out => 1);
2718: IF l_debug_level > 0 THEN
2719: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package OE_Delayed_Requests_Pvt');
2720: END IF;
2721: --IF oe_globals.g_recursion_mode = 'N' THEN
2722: l_ind := G_Delayed_Requests.first;
2723: l_count := 0;

Line 2827: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Delayed_Requests');

2823: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2824: --
2825: Begin
2826: IF l_debug_level > 0 THEN
2827: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Delayed_Requests');
2828: END IF;
2829: oe_order_pvt.set_recursion_mode(p_Entity_Code => 9,
2830: p_In_out => 1);
2831:

Line 3095: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3091: END IF;
3092: /* End of changes done for bug 5925600 */
3093:
3094: -- bug 5717671/5736696, need to execute copy header adj
3095: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3096: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3097: ,p_delete => FND_API.G_TRUE
3098: ,x_return_status => l_return_status
3099: );

Line 3109: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3105:
3106:
3107: -- bug 1834260, moved this block of code from after processing
3108: -- for request type G_PRICE_LINE to before it.
3109: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3110: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3111: ,p_delete => FND_API.G_TRUE
3112: ,x_return_status => l_return_status
3113: );

Line 3121: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3117: RAISE FND_API.G_EXC_ERROR;
3118: END IF;
3119:
3120: -- Process Requests for Freight Rating.
3121: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3122: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3123: ,p_delete => FND_API.G_TRUE
3124: ,x_return_status => l_return_status
3125: );

Line 3137: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3133: /* Renga- copy_freight_charges delayed request should be executed
3134: right after copy_adjustments - please do not put any delayed
3135: request in between copy_adjustments and copy_freight_charges */
3136:
3137: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3138: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3139: ,p_delete => FND_API.G_TRUE
3140: ,x_return_status => l_return_status
3141: );

Line 3150: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3146: END IF;
3147:
3148:
3149: -- Process Requests for Pricing
3150: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3151: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3152: ,p_delete => FND_API.G_TRUE
3153: ,x_return_status => l_return_status
3154: );

Line 3164: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3160:
3161:
3162: -- Renga - added freight_for_included items call
3163: -- Process Requests for Freight For included items.
3164: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3165: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3166: ,p_delete => FND_API.G_TRUE
3167: ,x_return_status => l_return_status
3168: );

Line 3178: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3174:
3175: -- Renga - done for freight for included items.
3176:
3177:
3178: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3179: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3180: ,p_delete => FND_API.G_TRUE
3181: ,x_return_status => l_return_status
3182: );

Line 3189: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3186: RAISE FND_API.G_EXC_ERROR;
3187: END IF;
3188:
3189: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3190: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3191: ,p_delete => FND_API.G_TRUE
3192: ,x_return_status => l_return_status
3193: );

Line 3201: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3197: RAISE FND_API.G_EXC_ERROR;
3198: END IF;
3199:
3200: -- added by lkxu
3201: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3202: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3203: ,p_delete => FND_API.G_TRUE
3204: ,x_return_status => l_return_status
3205: );

Line 3212: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3209: RAISE FND_API.G_EXC_ERROR;
3210: END IF;
3211:
3212: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3213: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3214: ,p_delete => FND_API.G_TRUE
3215: ,x_return_status => l_return_status
3216: );

Line 3331: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3327: RAISE FND_API.G_EXC_ERROR;
3328: END IF;
3329:
3330: -- Process Request to create automatic attachments
3331: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3332: (p_request_type =>OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
3333: ,p_delete => FND_API.G_TRUE
3334: ,x_return_status => l_return_status
3335: );

Line 3343: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3339: RAISE FND_API.G_EXC_ERROR;
3340: END IF;
3341:
3342: -- Process Request to copy attachments
3343: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3344: (p_request_type =>OE_GLOBALS.G_COPY_ATCHMT
3345: ,p_delete => FND_API.G_TRUE
3346: ,x_return_status => l_return_status
3347: );

Line 3356: oe_debug_pub.add(' Entering Procedure process_Delayed_Requests in Package OE_Delayed_Requests_Pvt');

3352: END IF;
3353:
3354: --added by MShenoy for Spares Management ikon project - Create internal req.
3355: IF l_debug_level > 0 THEN
3356: oe_debug_pub.add(' Entering Procedure process_Delayed_Requests in Package OE_Delayed_Requests_Pvt');
3357: END IF;
3358:
3359: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3360: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ

Line 3359: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3355: IF l_debug_level > 0 THEN
3356: oe_debug_pub.add(' Entering Procedure process_Delayed_Requests in Package OE_Delayed_Requests_Pvt');
3357: END IF;
3358:
3359: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3360: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ
3361: ,p_delete => FND_API.G_TRUE
3362: ,x_return_status => l_return_status);
3363: IF l_debug_level > 0 THEN

Line 3365: OE_Delayed_Requests_Pvt ret status '||l_return_status);

3361: ,p_delete => FND_API.G_TRUE
3362: ,x_return_status => l_return_status);
3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3365: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3366: END IF;
3367: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3374: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3370: RAISE FND_API.G_EXC_ERROR;
3371: END IF;
3372:
3373: -- B2013611 reverse promotional limits
3374: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3375: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3376: ,p_delete => FND_API.G_TRUE
3377: ,x_return_status => l_return_status
3378: );

Line 3386: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3382: RAISE FND_API.G_EXC_ERROR;
3383: END IF;
3384:
3385: --MRG BGN
3386: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3387: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3388: ,p_delete => FND_API.G_TRUE
3389: ,x_return_status => l_return_status
3390: );

Line 3405: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');

3401: ----------
3402:
3403: --MRG BGN
3404: IF l_debug_level > 0 THEN
3405: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3406: END IF;
3407: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3408: (p_request_type => OE_GLOBALS.G_GET_COST
3409: ,p_delete => FND_API.G_TRUE

Line 3407: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3403: --MRG BGN
3404: IF l_debug_level > 0 THEN
3405: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3406: END IF;
3407: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3408: (p_request_type => OE_GLOBALS.G_GET_COST
3409: ,p_delete => FND_API.G_TRUE
3410: ,x_return_status => l_return_status
3411: );

Line 3420: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3416: END IF;
3417: --MRG END
3418:
3419:
3420: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3421: (p_request_type =>OE_GLOBALS.G_DEL_CHG_LINES
3422: ,p_delete => FND_API.G_TRUE
3423: ,x_return_status => l_return_status
3424: );

Line 3434: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3430:
3431:
3432: --process delayed requests for xml generation
3433:
3434: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3435: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3436: ,p_delete => FND_API.G_TRUE
3437: ,x_return_status => l_return_status
3438: );

Line 3484: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3480: -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
3481:
3482:
3483: -- Process Request to Update the Internal Requisition
3484: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3485: ( p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
3486: , p_delete => FND_API.G_TRUE
3487: , x_return_status => l_return_status
3488: );

Line 3502: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3498:
3499:
3500: --process delayed requests for cancel workflow
3501:
3502: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3503: (p_request_type =>OE_GLOBALS.G_CANCEL_WF
3504: ,p_delete => FND_API.G_TRUE
3505: ,x_return_status => l_return_status
3506: );

Line 3538: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3534: l_ind := G_Delayed_Requests.Next(l_ind);
3535: END LOOP;
3536:
3537: -- Process Request to Complete workflow activity
3538: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3539: (p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
3540: ,p_delete => FND_API.G_TRUE
3541: ,x_return_status => l_return_status
3542: );

Line 5119: oe_debug_pub.add('Exiting procedure OE_Delayed_Requests_Pvt.Check_Pricing_Request', 1);

5115: /* End of New code added to fix the fp bug 3498435 */
5116:
5117:
5118: IF l_debug_level > 0 THEN
5119: oe_debug_pub.add('Exiting procedure OE_Delayed_Requests_Pvt.Check_Pricing_Request', 1);
5120: END IF;
5121:
5122: END Check_Pricing_Request;
5123:

Line 5124: END OE_Delayed_Requests_Pvt;

5120: END IF;
5121:
5122: END Check_Pricing_Request;
5123:
5124: END OE_Delayed_Requests_Pvt;