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.47.12020000.7 2013/04/09 08:01:59 spothula 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.47.12020000.7 2013/04/09 08:01:59 spothula ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Delayed_Requests_PVT';
7: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8233604
8:
9: g_requesting_entities OE_Order_PUB.Requesting_Entity_Tbl_Type;
10: G_MAX_REQUESTS NUMBER := 10000;

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

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

Line 415: OE_delayed_requests_Pvt.log_request(

411:
412: IF l_current_event >= l_tax_calculation_event_code THEN
413:
414: IF (OE_GLOBALS.G_UI_FLAG) AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN
415: OE_delayed_requests_Pvt.log_request(
416: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
417: p_entity_id => l_request_rec.entity_id,
418: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
419: p_requesting_entity_id => l_request_rec.entity_id,

Line 423: OE_delayed_requests_Pvt.log_request(

419: p_requesting_entity_id => l_request_rec.entity_id,
420: p_request_type => OE_GLOBALS.g_tax_line,
421: x_return_status => l_return_status);
422: ELSE
423: OE_delayed_requests_Pvt.log_request(
424: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
425: p_entity_id => l_request_rec.entity_id,
426: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
427: p_requesting_entity_id => l_request_rec.entity_id,

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

2268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2269: BEGIN
2270:
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add('Entering Procedure Log_Request in Package OE_Delayed_Requests_Pvt, entity id: '||p_entity_id||', request type:'||p_request_type);
2273: END IF;
2274:
2275: -- Initialize the request_record
2276: l_request.request_type := p_request_type;

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

2775: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2776: --
2777: BEGIN
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
2780: END IF;
2781: x_return_status := FND_API.G_RET_STS_SUCCESS;
2782:
2783: Check_for_Request( p_entity_code => p_entity_code

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

2850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2851: --
2852: BEGIN
2853: IF l_debug_level > 0 THEN
2854: oe_debug_pub.add('Entering Procedure Clear_Request in Package OE_Delayed_Requests_Pvt');
2855: END IF;
2856:
2857: x_return_status := FND_API.G_RET_STS_SUCCESS;
2858:

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

2908: --
2909: Begin
2910: x_return_status := FND_API.G_RET_STS_SUCCESS;
2911: IF l_debug_level > 0 THEN
2912: oe_debug_pub.add('Entering Procedure Process_Request in Package OE_Delayed_Requests_Pvt');
2913: END IF;
2914: Check_for_Request( p_entity_code => p_entity_code
2915: ,p_entity_id => p_entity_id
2916: ,p_request_type => p_request_type

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

2979: --
2980: Begin
2981: x_return_status := FND_API.G_RET_STS_SUCCESS;
2982: IF l_debug_level > 0 THEN
2983: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Request_for_Entity',1);
2984: END IF;
2985: IF NOT oe_globals.g_call_process_req THEN --9354229
2986: IF l_debug_level > 0 THEN
2987: oe_debug_pub.add( 'EXIT PROCESS_REQUESTS_FOR_ENTITY' , 1 ) ;

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

3080: --
3081: BEGIN
3082: x_return_status := FND_API.G_RET_STS_SUCCESS;
3083: IF l_debug_level > 0 THEN
3084: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package OE_Delayed_Requests_Pvt');
3085: END IF;
3086:
3087: IF NOT oe_globals.g_call_process_req THEN --9354229
3088: IF l_debug_level > 0 THEN

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

3207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3208: --
3209: Begin
3210: IF l_debug_level > 0 THEN
3211: oe_debug_pub.add('Enter OE_Delayed_Requests_Pvt.Process_Delayed_Requests');
3212: END IF;
3213:
3214: x_return_status := FND_API.G_RET_STS_SUCCESS;
3215:

Line 3218: oe_debug_pub.add( 'EXIT OE_Delayed_Requests_Pvt.Process_Delayed_Requests' , 1 ) ;

3214: x_return_status := FND_API.G_RET_STS_SUCCESS;
3215:
3216: IF NOT oe_globals.g_call_process_req THEN --9354229
3217: IF l_debug_level > 0 THEN
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,

Line 3526: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3522: END IF;
3523: /* End of changes done for bug 5925600 */
3524:
3525: -- bug 5717671/5736696, need to execute copy header adj
3526: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3527: (p_request_type =>OE_GLOBALS.G_COPY_HEADER_ADJUSTMENTS
3528: ,p_delete => FND_API.G_TRUE
3529: ,x_return_status => l_return_status
3530: );

Line 3540: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3536:
3537:
3538: -- bug 1834260, moved this block of code from after processing
3539: -- for request type G_PRICE_LINE to before it.
3540: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3541: (p_request_type =>OE_GLOBALS.G_COPY_ADJUSTMENTS
3542: ,p_delete => FND_API.G_TRUE
3543: ,x_return_status => l_return_status
3544: );

Line 3552: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3548: RAISE FND_API.G_EXC_ERROR;
3549: END IF;
3550:
3551: -- Process Requests for Freight Rating.
3552: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3553: (p_request_type =>OE_GLOBALS.G_FREIGHT_RATING
3554: ,p_delete => FND_API.G_TRUE
3555: ,x_return_status => l_return_status
3556: );

Line 3568: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3564: /* Renga- copy_freight_charges delayed request should be executed
3565: right after copy_adjustments - please do not put any delayed
3566: request in between copy_adjustments and copy_freight_charges */
3567:
3568: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3569: (p_request_type =>OE_GLOBALS.G_COPY_FREIGHT_CHARGES
3570: ,p_delete => FND_API.G_TRUE
3571: ,x_return_status => l_return_status
3572: );

Line 3581: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3577: END IF;
3578:
3579:
3580: -- Process Requests for Pricing
3581: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3582: (p_request_type =>OE_GLOBALS.G_PRICE_LINE
3583: ,p_delete => FND_API.G_TRUE
3584: ,x_return_status => l_return_status
3585: );

Line 3595: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3591:
3592:
3593: -- Renga - added freight_for_included items call
3594: -- Process Requests for Freight For included items.
3595: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3596: (p_request_type =>OE_GLOBALS.G_FREIGHT_FOR_INCLUDED
3597: ,p_delete => FND_API.G_TRUE
3598: ,x_return_status => l_return_status
3599: );

Line 3609: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3605:
3606: -- Renga - done for freight for included items.
3607:
3608:
3609: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3610: (p_request_type =>OE_GLOBALS.G_PRICE_ORDER
3611: ,p_delete => FND_API.G_TRUE
3612: ,x_return_status => l_return_status
3613: );

Line 3620: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3616: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3617: RAISE FND_API.G_EXC_ERROR;
3618: END IF;
3619:
3620: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3621: (p_request_type =>OE_GLOBALS.G_PRICE_ADJ
3622: ,p_delete => FND_API.G_TRUE
3623: ,x_return_status => l_return_status
3624: );

Line 3632: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3628: RAISE FND_API.G_EXC_ERROR;
3629: END IF;
3630:
3631: -- added by lkxu
3632: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3633: (p_request_type =>OE_GLOBALS.G_COPY_PRICING_ATTRIBUTES
3634: ,p_delete => FND_API.G_TRUE
3635: ,x_return_status => l_return_status
3636: );

Line 3643: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3639: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3640: RAISE FND_API.G_EXC_ERROR;
3641: END IF;
3642:
3643: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3644: (p_request_type =>OE_GLOBALS.G_COPY_MODEL_PATTR
3645: ,p_delete => FND_API.G_TRUE
3646: ,x_return_status => l_return_status
3647: );

Line 3762: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;
3760:
3761: -- Process Request to create automatic attachments
3762: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3763: (p_request_type =>OE_GLOBALS.G_APPLY_AUTOMATIC_ATCHMT
3764: ,p_delete => FND_API.G_TRUE
3765: ,x_return_status => l_return_status
3766: );

Line 3774: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3770: RAISE FND_API.G_EXC_ERROR;
3771: END IF;
3772:
3773: -- Process Request to copy attachments
3774: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3775: (p_request_type =>OE_GLOBALS.G_COPY_ATCHMT
3776: ,p_delete => FND_API.G_TRUE
3777: ,x_return_status => l_return_status
3778: );

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

3783: END IF;
3784:
3785: --added by MShenoy for Spares Management ikon project - Create internal req.
3786: IF l_debug_level > 0 THEN
3787: oe_debug_pub.add(' Entering Procedure process_Delayed_Requests in Package OE_Delayed_Requests_Pvt');
3788: END IF;
3789:
3790: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3791: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ

Line 3790: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3786: IF l_debug_level > 0 THEN
3787: oe_debug_pub.add(' Entering Procedure process_Delayed_Requests in Package OE_Delayed_Requests_Pvt');
3788: END IF;
3789:
3790: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3791: (p_request_type =>OE_GLOBALS.G_CREATE_INTERNAL_REQ
3792: ,p_delete => FND_API.G_TRUE
3793: ,x_return_status => l_return_status);
3794: IF l_debug_level > 0 THEN

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

3792: ,p_delete => FND_API.G_TRUE
3793: ,x_return_status => l_return_status);
3794: IF l_debug_level > 0 THEN
3795: oe_debug_pub.add(' leaving Procedure process_Delayed_Requests in Package
3796: OE_Delayed_Requests_Pvt ret status '||l_return_status);
3797: END IF;
3798: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3805: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3801: RAISE FND_API.G_EXC_ERROR;
3802: END IF;
3803:
3804: -- B2013611 reverse promotional limits
3805: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3806: (p_request_type =>OE_GLOBALS.G_REVERSE_LIMITS
3807: ,p_delete => FND_API.G_TRUE
3808: ,x_return_status => l_return_status
3809: );

Line 3817: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3813: RAISE FND_API.G_EXC_ERROR;
3814: END IF;
3815:
3816: --MRG BGN
3817: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3818: (p_request_type => OE_GLOBALS.G_MARGIN_HOLD
3819: ,p_delete => FND_API.G_TRUE
3820: ,x_return_status => l_return_status
3821: );

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

3832: ----------
3833:
3834: --MRG BGN
3835: IF l_debug_level > 0 THEN
3836: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3837: END IF;
3838: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3839: (p_request_type => OE_GLOBALS.G_GET_COST
3840: ,p_delete => FND_API.G_TRUE

Line 3838: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3834: --MRG BGN
3835: IF l_debug_level > 0 THEN
3836: oe_debug_pub.add('before call to OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype in process_delayed_requests');
3837: END IF;
3838: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3839: (p_request_type => OE_GLOBALS.G_GET_COST
3840: ,p_delete => FND_API.G_TRUE
3841: ,x_return_status => l_return_status
3842: );

Line 3851: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3847: END IF;
3848: --MRG END
3849:
3850:
3851: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3852: (p_request_type =>OE_GLOBALS.G_DEL_CHG_LINES
3853: ,p_delete => FND_API.G_TRUE
3854: ,x_return_status => l_return_status
3855: );

Line 3865: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3861:
3862:
3863: --process delayed requests for xml generation
3864:
3865: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3866: (p_request_type =>OE_GLOBALS.G_GENERATE_XML_REQ_HDR
3867: ,p_delete => FND_API.G_TRUE
3868: ,x_return_status => l_return_status
3869: );

Line 3915: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3911: -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
3912:
3913:
3914: -- Process Request to Update the Internal Requisition
3915: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3916: ( p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
3917: , p_delete => FND_API.G_TRUE
3918: , x_return_status => l_return_status
3919: );

Line 3933: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3929:
3930:
3931: --process delayed requests for cancel workflow
3932:
3933: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3934: (p_request_type =>OE_GLOBALS.G_CANCEL_WF
3935: ,p_delete => FND_API.G_TRUE
3936: ,x_return_status => l_return_status
3937: );

Line 3969: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

3965: l_ind := G_Delayed_Requests.Next(l_ind);
3966: END LOOP;
3967:
3968: -- Process Request to Complete workflow activity
3969: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
3970: (p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
3971: ,p_delete => FND_API.G_TRUE
3972: ,x_return_status => l_return_status
3973: );

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

5567: /* End of New code added to fix the fp bug 3498435 */
5568:
5569:
5570: IF l_debug_level > 0 THEN
5571: oe_debug_pub.add('Exiting procedure OE_Delayed_Requests_Pvt.Check_Pricing_Request', 1);
5572: END IF;
5573:
5574: END Check_Pricing_Request;
5575:

Line 5576: END OE_Delayed_Requests_Pvt;

5572: END IF;
5573:
5574: END Check_Pricing_Request;
5575:
5576: END OE_Delayed_Requests_Pvt;