DBA Data[Home] [Help]

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.41.12020000.10 2013/05/23 14:28:45 nilegupt 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.41.12020000.10 2013/05/23 14:28:45 nilegupt 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,
82: p_header_id => p_header_id);
83:

Line 84: oe_debug_pub.add('Exiting 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,
82: p_header_id => p_header_id);
83:
84: oe_debug_pub.add('Exiting OE_DELAYED_REQUESTS_UTIL.VALIDATE_HSC_QUOTA_TOTAL', 1);
85:
86: EXCEPTION
87:
88: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2157: OE_Debug_PUB.Add('Hold released',1);
2158: END IF;
2159:
2160: x_request_rec := l_request_rec;
2161: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Release_Hold',1);
2162: EXCEPTION
2163:
2164: WHEN FND_API.G_EXC_ERROR THEN
2165:

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

2823:
2824: -- bug 4741573
2825: OE_MSG_PUB.reset_msg_context('LINE');
2826:
2827: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Update_Shipping',1);
2828: EXCEPTION
2829: WHEN OTHERS THEN
2830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2831:

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

2854: l_process_id NUMBER;
2855: l_shipping_index NUMBER :=0 ;
2856: BEGIN
2857:
2858: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Ship_Confirmation'||p_process_type||p_process_id,1);
2859:
2860: l_process_id := to_number(p_process_id);
2861: l_shipping_index := p_ship_confirmation_tbl.First;
2862: oe_debug_pub.add('P_line_id :'||to_char(p_line_id),2);

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

2891: p_process_id => l_process_id,
2892: p_process_type => p_process_type,
2893: x_return_status => x_return_status
2894: );
2895: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Ship_Confirmation',1);
2896:
2897: EXCEPTION
2898: WHEN OTHERS THEN
2899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3036: l_line_rec OE_ORDER_PUB.line_rec_type;
3037: l_return_status VARCHAR2(1);
3038: BEGIN
3039:
3040: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Group_Schedule',1);
3041:
3042: oe_debug_pub.add('Entity is :' || p_request_rec.param3,2);
3043: oe_debug_pub.add('Action is :' || p_request_rec.param4,2);
3044:

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

3897: l_lin_line_id NUMBER; -- Bug 5754554
3898: l_fulfillment_base VARCHAR2(1);--ER#14763609
3899:
3900: BEGIN
3901: oe_debug_pub.add('Entering oe_delayed_requests_util.Validate_Line_Set',1);
3902: oe_line_util.query_rows(p_line_set_id => p_line_set_id,
3903: x_line_tbl => l_line_tbl);
3904:
3905: -- Start for bug 5754554

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

4029: END IF;
4030: END IF; -- For Bug 5754554
4031: END LOOP;
4032: END IF;
4033: oe_debug_pub.add('Exiting oe_delayed_requests_util.Validate_Line_Set',1);
4034: EXCEPTION
4035: WHEN FND_API.G_EXC_ERROR THEN
4036:
4037: OE_MSG_PUB.reset_msg_context('SPLIT');

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

4087: --serla end
4088: Begin
4089:
4090:
4091: oe_debug_pub.add('Entering oe_delayed_requests_util.Process_adjustments',1);
4092: FOR I IN 1..(p_adjust_tbl.COUNT) LOOP
4093:
4094: oe_debug_pub.add('I in p_adjust_tbl is : ' || I,2);
4095:

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

4172: end if; /* if l_adj_tbl.count >= 1 */
4173:
4174: oe_debug_pub.add('no error in process order ',2);
4175: x_return_status := l_return_status;
4176: oe_debug_pub.add('Exiting oe_delayed_requests_util.Process_adjustments',1);
4177:
4178:
4179: EXCEPTION
4180:

Line 4881: OE_DEBUG_PUB.Add('Enter OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 0.5); --debug level changed to 0.5 for bug 13435459

4877: l_msg_count NUMBER;
4878: l_msg_data VARCHAR2(2000);
4879: BEGIN
4880:
4881: OE_DEBUG_PUB.Add('Enter OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 0.5); --debug level changed to 0.5 for bug 13435459
4882:
4883: x_return_status := FND_API.G_RET_STS_SUCCESS;
4884:
4885: OE_Atchmt_Util.Apply_Automatic_Attachments

Line 4900: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 0.5); --debug level changed to 0.5 for bug 13435459

4896: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4897: RAISE FND_API.G_EXC_ERROR;
4898: END IF;
4899:
4900: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Apply_Automatic_Attachments', 0.5); --debug level changed to 0.5 for bug 13435459
4901:
4902: EXCEPTION
4903: WHEN FND_API.G_EXC_ERROR THEN
4904: x_return_status := FND_API.G_RET_STS_ERROR;

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

4925: )
4926: IS
4927: BEGIN
4928:
4929: OE_DEBUG_PUB.Add('Enter OE_DELAYED_REQUESTS_UTIL.Copy_Attachments, manual only'||
4930: p_manual_attachments_only, 0.5); --debug level changed to 0.5 for bug 13435459
4931:
4932: x_return_status := FND_API.G_RET_STS_SUCCESS;
4933:

Line 4947: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Copy_Attachments', 0.5); --debug level changed to 0.5 for bug 13435459

4943: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4944: RAISE FND_API.G_EXC_ERROR;
4945: END IF;
4946:
4947: OE_DEBUG_PUB.Add('Exit OE_DELAYED_REQUESTS_UTIL.Copy_Attachments', 0.5); --debug level changed to 0.5 for bug 13435459
4948:
4949: EXCEPTION
4950: WHEN FND_API.G_EXC_ERROR THEN
4951: x_return_status := FND_API.G_RET_STS_ERROR;

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

4987: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
4988: l_group_sch_required BOOLEAN := TRUE;
4989: BEGIN
4990:
4991: oe_debug_pub.add('Entering OE_Delayed_Requests_UTIL.Schedule_Line',1);
4992:
4993: OE_ORDER_SCH_UTIL.OESCH_PERFORM_GRP_SCHEDULING := 'N';
4994:
4995: FOR I in 1..p_sch_set_tbl.count LOOP

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

5324:
5325: END LOOP;
5326: OE_ORDER_SCH_UTIL.OESCH_PERFORM_GRP_SCHEDULING := 'Y';
5327:
5328: oe_debug_pub.add('Exiting OE_Delayed_Requests_UTIL.Schedule_Line');
5329: EXCEPTION
5330:
5331: WHEN FND_API.G_EXC_ERROR THEN
5332: x_return_status := FND_API.G_RET_STS_ERROR;

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

6246: --bug #7491829
6247:
6248: BEGIN
6249:
6250: OE_Debug_PUB.Add('Entering OE_Delayed_Requests_Util.Reverse_Limits', 1);
6251: OE_Debug_PUB.Add('BOTTOM LEVEL before QP call', 1);
6252: x_return_status := FND_API.G_RET_STS_SUCCESS;
6253:
6254: -- BUG 2670775 Reverse Limits Begin

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

6343: where line_id = p_line_id;
6344: END IF;
6345: --bug 7491829
6346:
6347: OE_Debug_PUB.Add('Exiting OE_Delayed_Requests_Util.Reverse_Limits with status of '|| x_return_status, 1);
6348:
6349: EXCEPTION
6350: WHEN FND_API.G_EXC_ERROR THEN
6351:

Line 6422: oe_debug_pub.add( 'EXITING oe_delayed_requests_util.Process_XML_Delayed_Request,header not created' , 1 ) ;

6418: WHERE header_id=l_header_id;
6419: EXCEPTION
6420: WHEN NO_DATA_FOUND THEN
6421: IF l_debug_level > 0 THEN
6422: oe_debug_pub.add( 'EXITING oe_delayed_requests_util.Process_XML_Delayed_Request,header not created' , 1 ) ;
6423: END IF;
6424: RETURN;
6425: END; --exception added for bug16586206
6426:

Line 7006: oe_debug_pub.add(' Entering OE_Delayed_Requests_Util.Process_Pre_Exploded_Kits',1);

7002: --
7003: BEGIN
7004:
7005: if l_debug_level > 0 then
7006: oe_debug_pub.add(' Entering OE_Delayed_Requests_Util.Process_Pre_Exploded_Kits',1);
7007: oe_debug_pub.add(' Top Model Line_id is : '||p_top_model_line_id,5);
7008: oe_debug_pub.add(' Explosion Date is : '||p_explosion_date,5);
7009: end if;
7010:

Line 7025: oe_debug_pub.add(' Exiting OE_Delayed_Requests_Util.Process_Pre_Exploded_Kits',1);

7021: RAISE FND_API.G_EXC_ERROR;
7022: END IF;
7023:
7024: if l_debug_level > 0 then
7025: oe_debug_pub.add(' Exiting OE_Delayed_Requests_Util.Process_Pre_Exploded_Kits',1);
7026: end if;
7027:
7028: EXCEPTION
7029: WHEN FND_API.G_EXC_ERROR THEN

Line 7046: END OE_Delayed_Requests_UTIL;

7042: -- End DOO Pre Exploded Kit ER 9339742
7043:
7044:
7045:
7046: END OE_Delayed_Requests_UTIL;