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_UTIL dependencies on OE_DELAYED_REQUESTS_UTIL

Line 1: PACKAGE BODY OE_Delayed_Requests_UTIL AS

1: PACKAGE BODY OE_Delayed_Requests_UTIL AS
2: /* $Header: OEXUREQB.pls 120.23.12010000.4 2008/11/19 10:59:21 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXUREQB.pls 120.23.12010000.4 2008/11/19 10:59:21 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Delayed_Requests_UTIL';
7:
8: -- Procedure to validate quota percent total
9:
10: PROCEDURE Validate_LSC_QUOTA_TOTAL

Line 27: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.VALIDATE_LSC_QUOTA_TOTAL', 1);

23: And sct.quota_flag = 'Y';
24:
25: BEGIN
26:
27: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.VALIDATE_LSC_QUOTA_TOTAL', 1);
28:
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30: OPEN C_LSC_Quota_Total(p_line_id);
31: FETCH C_LSC_Quota_Total

Line 45: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.VALIDATE_LSC_QUOTA_TOTAL', 1);

41: OE_MSG_PUB.Add;
42: x_return_status := FND_API.G_RET_STS_ERROR;
43: END IF;
44:
45: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.VALIDATE_LSC_QUOTA_TOTAL', 1);
46:
47: EXCEPTION
48:
49: WHEN FND_API.G_EXC_ERROR THEN

Line 79: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.VALIDATE_HSC_QUOTA_TOTAL', 1);

75: ) IS
76:
77: BEGIN
78:
79: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.VALIDATE_HSC_QUOTA_TOTAL', 1);
80:
81: OE_Validate_Header_Scredit.Validate_HSC_QUOTA_TOTAL(x_return_status => x_return_status, p_header_id => p_header_id);
82:
83: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.VALIDATE_HSC_QUOTA_TOTAL', 1);

Line 83: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.VALIDATE_HSC_QUOTA_TOTAL', 1);

79: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.VALIDATE_HSC_QUOTA_TOTAL', 1);
80:
81: OE_Validate_Header_Scredit.Validate_HSC_QUOTA_TOTAL(x_return_status => x_return_status, p_header_id => p_header_id);
82:
83: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.VALIDATE_HSC_QUOTA_TOTAL', 1);
84:
85: EXCEPTION
86:
87: WHEN OTHERS THEN

Line 122: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.DFLT_HSCREDIT_PRIMARY_SREP', 1);

118: x_msg_count NUMBER;
119: x_msg_data VARCHAR2(2000);
120: Begin
121:
122: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.DFLT_HSCREDIT_PRIMARY_SREP', 1);
123: OE_HEADER_SCREDIT_UTIL.DFLT_Hscredit_Primary_Srep
124: ( p_header_id =>p_header_id
125: ,p_SalesRep_id =>p_SalesRep_id
126: ,x_return_status=>x_return_status);

Line 127: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.DFLT_HSCREDIT_PRIMARY_SREP', 1);

123: OE_HEADER_SCREDIT_UTIL.DFLT_Hscredit_Primary_Srep
124: ( p_header_id =>p_header_id
125: ,p_SalesRep_id =>p_SalesRep_id
126: ,x_return_status=>x_return_status);
127: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.DFLT_HSCREDIT_PRIMARY_SREP', 1);
128:
129: EXCEPTION
130:
131: WHEN OTHERS THEN

Line 201: OE_DEBUG_PUB.Add('Entering OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit',1);

197:
198:
199: BEGIN
200:
201: OE_DEBUG_PUB.Add('Entering OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit',1);
202: l_line_id := p_request_rec.param8;
203: l_new_salesrep_id := p_request_rec.param1;
204: l_old_salesrep_id := p_request_rec.param2;
205: l_new_sales_credit_type_id := p_request_rec.param3;

Line 468: OE_DEBUG_PUB.Add('Exiting OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit',1);

464: l_Line_Scredit_tbl.DELETE;
465:
466: END IF; -- l_count.
467:
468: OE_DEBUG_PUB.Add('Exiting OE_DELAYED_REQUESTS_UTIL.Cascade_Service_Scredit',1);
469: x_return_status := l_return_status;
470:
471: EXCEPTION
472:

Line 527: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE', 1);

523: DUPLICATE_DISCOUNT EXCEPTION;
524:
525: BEGIN
526:
527: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE', 1);
528:
529: l_entity_id := p_request_rec.entity_id;
530: l_entity_code := p_request_rec.entity_code;
531: l_discount_id := To_number(p_request_rec.param1);

Line 600: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE', 1);

596:
597:
598: x_return_status := l_return_status;
599:
600: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CHECK_DUPLICATE', 1);
601:
602: EXCEPTION
603:
604: WHEN NO_DATA_FOUND OR DUPLICATE_DISCOUNT

Line 661: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CHECK_FIXED_PRICE', 1);

657:
658:
659: BEGIN
660:
661: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CHECK_FIXED_PRICE', 1);
662:
663: l_entity_id := p_request_rec.entity_id;
664: l_entity_code := p_request_rec.entity_code;
665: l_discount_line_id := To_number(p_request_rec.param1);

Line 783: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CHECK_FIXED_PRICE', 1);

779:
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CHECK_FIXED_PRICE', 1);
784:
785: EXCEPTION
786:
787: WHEN NO_DATA_FOUND OR FIXED_PRICE

Line 868: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CHECK_PERCENTAGE', 1);

864:
865:
866: BEGIN
867:
868: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CHECK_PERCENTAGE', 1);
869:
870: l_entity_code := p_request_rec.entity_code;
871:
872: oe_debug_pub.ADD('OEXSRLNB: Check Percentage. '||

Line 991: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CHECK_PERCENTAGE', 1);

987:
988:
989: x_return_status := l_return_status;
990:
991: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CHECK_PERCENTAGE', 1);
992:
993: EXCEPTION
994:
995: WHEN PERCENTAGE_EXCEEDED

Line 1060: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CREATE_CONFIG_ITEM', 1);

1056: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1057: req_ind NUMBER;
1058: BEGIN
1059:
1060: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.CREATE_CONFIG_ITEM', 1);
1061:
1062:
1063: oe_debug_pub.add('In procedure Create_Config', 2);
1064:

Line 1127: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CREATE_CONFIG_ITEM', 1);

1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125: */
1126:
1127: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.CREATE_CONFIG_ITEM', 1);
1128:
1129: EXCEPTION
1130:
1131: WHEN FND_API.G_EXC_ERROR THEN

Line 1160: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.INS_INCLUDED_ITEMS', 1);

1156: )
1157: IS
1158: BEGIN
1159:
1160: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.INS_INCLUDED_ITEMS', 1);
1161:
1162: OE_DEBUG_PUB.ADD('Inserting Included Items', 2);
1163:
1164: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.INS_INCLUDED_ITEMS', 1);

Line 1164: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.INS_INCLUDED_ITEMS', 1);

1160: oe_debug_pub.add('Entering OE_DELAYED_REQUESTS_UTIL.INS_INCLUDED_ITEMS', 1);
1161:
1162: OE_DEBUG_PUB.ADD('Inserting Included Items', 2);
1163:
1164: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.INS_INCLUDED_ITEMS', 1);
1165: Null;
1166: END;
1167:
1168: PROCEDURE verify_payment

Line 1765: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.split_Hold',1);

1761: l_msg_data VARCHAR2(2000);
1762:
1763: BEGIN
1764:
1765: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.split_Hold',1);
1766: -- call the oe_holds_pub to split the line
1767: OE_Holds_pvt.split_hold (
1768: p_line_id => p_entity_id
1769: , p_split_from_line_id => p_split_from_line_id

Line 1783: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.split_Hold',2);

1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1780: END IF;
1781: END IF; -- if split hold was successful
1782:
1783: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.split_Hold',2);
1784:
1785: EXCEPTION
1786:
1787: WHEN FND_API.G_EXC_ERROR THEN

Line 1900: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Apply_Hold',1);

1896: l_msg_data VARCHAR2(2000) := NULL;
1897: l_line_rec OE_Order_PUB.Line_Rec_Type;
1898: BEGIN
1899:
1900: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Apply_Hold',1);
1901:
1902: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
1903: -- Indicates Header Level action
1904: --l_header_id := l_request_rec.entity_id;

Line 2006: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Apply_Hold',1);

2002: END IF;
2003:
2004: x_request_rec := l_request_rec;
2005:
2006: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Apply_Hold',1);
2007: EXCEPTION
2008:
2009: WHEN FND_API.G_EXC_ERROR THEN
2010:

Line 2061: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Release_Hold',1);

2057: l_hold_release_rec OE_HOLDS_PVT.Hold_Release_Rec_Type;
2058: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2059: BEGIN
2060:
2061: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Release_Hold',1);
2062:
2063: IF l_request_rec.entity_code = OE_Globals.G_ENTITY_HEADER THEN
2064: -- Indicates Header Level action
2065:

Line 2157: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Release_Hold',1);

2153: OE_Debug_PUB.Add('Hold released',1);
2154: END IF;
2155:
2156: x_request_rec := l_request_rec;
2157: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Release_Hold',1);
2158: EXCEPTION
2159:
2160: WHEN FND_API.G_EXC_ERROR THEN
2161:

Line 2606: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Update_Shipping',1);

2602:
2603: -- bug 4741573
2604: OE_MSG_PUB.reset_msg_context('LINE');
2605:
2606: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Update_Shipping',1);
2607: EXCEPTION
2608: WHEN OTHERS THEN
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610:

Line 2637: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Ship_Confirmation'||p_process_type||p_process_id,1);

2633: l_process_id NUMBER;
2634: l_shipping_index NUMBER :=0 ;
2635: BEGIN
2636:
2637: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Ship_Confirmation'||p_process_type||p_process_id,1);
2638:
2639: l_process_id := to_number(p_process_id);
2640: l_shipping_index := p_ship_confirmation_tbl.First;
2641: oe_debug_pub.add('P_line_id :'||to_char(p_line_id),2);

Line 2674: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Ship_Confirmation',1);

2670: p_process_id => l_process_id,
2671: p_process_type => p_process_type,
2672: x_return_status => x_return_status
2673: );
2674: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Ship_Confirmation',1);
2675:
2676: EXCEPTION
2677: WHEN OTHERS THEN
2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2819: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Group_Schedule',1);

2815: l_line_rec OE_ORDER_PUB.line_rec_type;
2816: l_return_status VARCHAR2(1);
2817: BEGIN
2818:
2819: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Group_Schedule',1);
2820:
2821: oe_debug_pub.add('Entity is :' || p_request_rec.param3,2);
2822: oe_debug_pub.add('Action is :' || p_request_rec.param4,2);
2823:

Line 3635: oe_debug_pub.add('Entering oe_delayed_requests_util.Validate_Line_Set',1);

3631: l_task_id NUMBER;
3632: l_lin_line_id NUMBER; -- Bug 5754554
3633:
3634: BEGIN
3635: oe_debug_pub.add('Entering oe_delayed_requests_util.Validate_Line_Set',1);
3636: oe_line_util.query_rows(p_line_set_id => p_line_set_id,
3637: x_line_tbl => l_line_tbl);
3638:
3639: -- Start for bug 5754554

Line 3755: oe_debug_pub.add('Exiting oe_delayed_requests_util.Validate_Line_Set',1);

3751: END IF;
3752: END IF; -- For Bug 5754554
3753: END LOOP;
3754: END IF;
3755: oe_debug_pub.add('Exiting oe_delayed_requests_util.Validate_Line_Set',1);
3756: EXCEPTION
3757: WHEN FND_API.G_EXC_ERROR THEN
3758:
3759: OE_MSG_PUB.reset_msg_context('SPLIT');

Line 3813: oe_debug_pub.add('Entering oe_delayed_requests_util.Process_adjustments',1);

3809: --serla end
3810: Begin
3811:
3812:
3813: oe_debug_pub.add('Entering oe_delayed_requests_util.Process_adjustments',1);
3814: FOR I IN 1..(p_adjust_tbl.COUNT) LOOP
3815:
3816: oe_debug_pub.add('I in p_adjust_tbl is : ' || I,2);
3817:

Line 3898: oe_debug_pub.add('Exiting oe_delayed_requests_util.Process_adjustments',1);

3894: end if; /* if l_adj_tbl.count >= 1 */
3895:
3896: oe_debug_pub.add('no error in process order ',2);
3897: x_return_status := l_return_status;
3898: oe_debug_pub.add('Exiting oe_delayed_requests_util.Process_adjustments',1);
3899:
3900:
3901: EXCEPTION
3902:

Line 4506: OE_DEBUG_PUB.Add('Enter OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 1);

4502: l_msg_count NUMBER;
4503: l_msg_data VARCHAR2(2000);
4504: BEGIN
4505:
4506: OE_DEBUG_PUB.Add('Enter OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 1);
4507:
4508: x_return_status := FND_API.G_RET_STS_SUCCESS;
4509:
4510: OE_Atchmt_Util.Apply_Automatic_Attachments

Line 4525: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 1);

4521: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4522: RAISE FND_API.G_EXC_ERROR;
4523: END IF;
4524:
4525: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 1);
4526:
4527: EXCEPTION
4528: WHEN FND_API.G_EXC_ERROR THEN
4529: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4554: OE_DEBUG_PUB.Add('Enter OE_DELAYED_REQUESTS_UTIL.Copy_Attachments, manual only'||

4550: )
4551: IS
4552: BEGIN
4553:
4554: OE_DEBUG_PUB.Add('Enter OE_DELAYED_REQUESTS_UTIL.Copy_Attachments, manual only'||
4555: p_manual_attachments_only, 1);
4556:
4557: x_return_status := FND_API.G_RET_STS_SUCCESS;
4558:

Line 4572: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Copy_Attachments', 1);

4568: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4569: RAISE FND_API.G_EXC_ERROR;
4570: END IF;
4571:
4572: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Copy_Attachments', 1);
4573:
4574: EXCEPTION
4575: WHEN FND_API.G_EXC_ERROR THEN
4576: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4616: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Schedule_Line',1);

4612: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
4613: l_group_sch_required BOOLEAN := TRUE;
4614: BEGIN
4615:
4616: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Schedule_Line',1);
4617:
4618: OE_ORDER_SCH_UTIL.OESCH_PERFORM_GRP_SCHEDULING := 'N';
4619:
4620: FOR I in 1..p_sch_set_tbl.count LOOP

Line 4950: oe_debug_pub.add('Exiting OE_Delayed_Requests_UTIL.Schedule_Line');

4946:
4947: END LOOP;
4948: OE_ORDER_SCH_UTIL.OESCH_PERFORM_GRP_SCHEDULING := 'Y';
4949:
4950: oe_debug_pub.add('Exiting OE_Delayed_Requests_UTIL.Schedule_Line');
4951: EXCEPTION
4952:
4953: WHEN FND_API.G_EXC_ERROR THEN
4954: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5893: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Reverse_Limits', 1);

5889: --bug #7491829
5890:
5891: BEGIN
5892:
5893: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Reverse_Limits', 1);
5894: OE_Debug_PUB.Add('BOTTOM LEVEL before QP call', 1);
5895: x_return_status := FND_API.G_RET_STS_SUCCESS;
5896:
5897: -- BUG 2670775 Reverse Limits Begin

Line 5990: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Reverse_Limits with status of '|| x_return_status, 1);

5986: where line_id = p_line_id;
5987: END IF;
5988: --bug 7491829
5989:
5990: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Reverse_Limits with status of '|| x_return_status, 1);
5991:
5992: EXCEPTION
5993: WHEN FND_API.G_EXC_ERROR THEN
5994:

Line 6627: END OE_Delayed_Requests_UTIL;

6623: /* ============================= */
6624: /* IR ISO Change Management Ends */
6625:
6626:
6627: END OE_Delayed_Requests_UTIL;