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.ONT_ITM_PKG dependencies on OE_DEBUG_PUB

Line 31: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

27: l_return_status VARCHAR2(1000);
28: l_result_out VARCHAR2(2400);
29:
30: --
31: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
32: --
33: BEGIN
34: SAVEPOINT CREATE_REQUEST_PUB;
35:

Line 37: OE_DEBUG_PUB.ADD('Starting process_itm_request...'||'for line id:'||p_line_rec.line_id);

33: BEGIN
34: SAVEPOINT CREATE_REQUEST_PUB;
35:
36: IF l_debug_level > 0 THEN
37: OE_DEBUG_PUB.ADD('Starting process_itm_request...'||'for line id:'||p_line_rec.line_id);
38: END IF;
39:
40: SELECT master_organization_id
41: INTO l_master_organization_id

Line 58: OE_DEBUG_PUB.Add('Before calling update flow status to...'|| 'AWAITING EXPORT SCREENING' ) ;

54:
55: -- The Flow Status is updated to Export Compliance Screening
56:
57: IF l_debug_level > 0 THEN
58: OE_DEBUG_PUB.Add('Before calling update flow status to...'|| 'AWAITING EXPORT SCREENING' ) ;
59: END IF;
60:
61: OE_ORDER_WF_UTIL.Update_Flow_Status_Code
62: (p_line_id => p_line_rec.line_id

Line 68: OE_DEBUG_PUB.Add('Return status from flow status api '|| l_return_status,1);

64: ,x_return_status => l_return_status
65: );
66:
67: IF l_debug_level > 0 THEN
68: OE_DEBUG_PUB.Add('Return status from flow status api '|| l_return_status,1);
69: END IF;
70:
71: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
72: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

Line 79: oe_debug_pub.add( 'NOT ABLE TO CREATE REQUEST...' , 1 ) ;

75: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
76: x_return_status := FND_API.G_RET_STS_ERROR;
77:
78: IF l_debug_level > 0 THEN
79: oe_debug_pub.add( 'NOT ABLE TO CREATE REQUEST...' , 1 ) ;
80: END IF;
81:
82: -- The Flow Status is updated to Export Compliance Screening
83:

Line 91: OE_DEBUG_PUB.Add('Return status from flow status api '|| l_return_status,1);

87: ,x_return_status => l_return_status
88: );
89:
90: IF l_debug_level > 0 THEN
91: OE_DEBUG_PUB.Add('Return status from flow status api '|| l_return_status,1);
92: END IF;
93:
94: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
95: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

Line 105: OE_DEBUG_PUB.Add('Ending process_itm_request...'|| 'for line id:'||p_line_rec.line_id);

101:
102: END IF; -- End of checking l_return_status
103:
104: IF l_debug_level > 0 THEN
105: OE_DEBUG_PUB.Add('Ending process_itm_request...'|| 'for line id:'||p_line_rec.line_id);
106: END IF;
107:
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN

Line 127: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

123: -- Function added for bug5140692
124: FUNCTION Get_Contact_name(p_contact_id IN NUMBER)
125: RETURN VARCHAR2 IS
126:
127: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
128: x_contact_name VARCHAR2(360);
129:
130: BEGIN
131: IF l_debug_level > 0 THEN

Line 132: oe_debug_pub.add('OEXVITMB.pls: Inside Get_Contact_name, contact_id='||p_contact_id,3);

128: x_contact_name VARCHAR2(360);
129:
130: BEGIN
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add('OEXVITMB.pls: Inside Get_Contact_name, contact_id='||p_contact_id,3);
133: END IF;
134:
135: SELECT PARTY.PARTY_NAME INTO x_contact_name
136: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

Line 152: oe_debug_pub.add('OEXVITMB.pls: Contact name ='||x_contact_name,3);

148: AND REL.OBJECT_ID = ACCT.PARTY_ID
149: AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID;
150:
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add('OEXVITMB.pls: Contact name ='||x_contact_name,3);
153: END IF;
154: Return x_contact_name;
155:
156: EXCEPTION

Line 159: oe_debug_pub.add('OEXVITMB: NO_DATA_FOUND exception..',3 );

155:
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('OEXVITMB: NO_DATA_FOUND exception..',3 );
160: END IF;
161: Raise;
162: WHEN OTHERS THEN
163: IF l_debug_level > 0 THEN

Line 164: oe_debug_pub.add('OEXVITMB: OTHERS exception in Get_Contact_name...',3 );

160: END IF;
161: Raise;
162: WHEN OTHERS THEN
163: IF l_debug_level > 0 THEN
164: oe_debug_pub.add('OEXVITMB: OTHERS exception in Get_Contact_name...',3 );
165: END IF;
166: Raise;
167: END Get_Contact_name;
168:

Line 325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

321: AND hp.party_id(+) = party.party_id -- bug 4231894
322: AND rownum = 1;
323:
324: --
325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
326: --
327: BEGIN
328:
329: IF l_debug_level > 0 THEN

Line 330: oe_debug_pub.add('Inside get address , source_type_code is '||p_source_type||' ,p_source_id='||p_source_id||' ,p_contact_id='||p_contact_id,4); -- bug 4231894

326: --
327: BEGIN
328:
329: IF l_debug_level > 0 THEN
330: oe_debug_pub.add('Inside get address , source_type_code is '||p_source_type||' ,p_source_id='||p_source_id||' ,p_contact_id='||p_contact_id,4); -- bug 4231894
331: END IF;
332:
333: IF (p_source_type IN ('INTERMED_SHIP_TO','SHIP_TO',
334: 'BILL_TO','DELIVER_TO')) THEN

Line 403: oe_debug_pub.add('Exiting get_address',4);

399: END LOOP;
400: END IF;
401:
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add('Exiting get_address',4);
404: END IF;
405: EXCEPTION
406: WHEN OTHERS THEN
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

432: l_request_control_id_list WSH_ITM_UTIL.CONTROL_ID_LIST;
433: x_return_status VARCHAR2(30);
434:
435: --
436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
437: --
438: BEGIN
439:
440: IF l_debug_level > 0 THEN

Line 441: oe_debug_pub.add('Entering update process flag..' , 4 ) ;

437: --
438: BEGIN
439:
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add('Entering update process flag..' , 4 ) ;
442: END IF;
443:
444: SELECT request_control_id
445: BULK COLLECT

Line 462: oe_debug_pub.add('Update process flag returned with ..'|| x_return_status ,1);

458: END IF;
459:
460:
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add('Update process flag returned with ..'|| x_return_status ,1);
463: oe_debug_pub.add('Exiting update process flag..',4 ) ;
464: END IF;
465:
466: Exception

Line 463: oe_debug_pub.add('Exiting update process flag..',4 ) ;

459:
460:
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add('Update process flag returned with ..'|| x_return_status ,1);
463: oe_debug_pub.add('Exiting update process flag..',4 ) ;
464: END IF;
465:
466: Exception
467: WHEN NO_DATA_FOUND THEN

Line 484: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

480: PROCEDURE Init_Address_Table
481: IS
482: I INTEGER;
483: --
484: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
485: --
486: BEGIN
487:
488: FOR I in 1..Address_Table.COUNT

Line 573: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

569: -- 4380792 Commented the below unused type code variable
570: -- and added term name variable
571: --l_payment_type_code VARCHAR2(30);
572: l_payment_term_name VARCHAR2(15);
573: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
574: l_sold_to_contact_id NUMBER; -- BUG 5140692
575:
576: l_product_code VARCHAR2(100); -- BUG 5408161
577: l_Item_type VARCHAR2(80); -- BUG 5408161

Line 585: oe_debug_pub.add('Start creating request...' ) ;

581: BEGIN
582:
583: l_Generic_Service_Flag := 'N';
584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add('Start creating request...' ) ;
586: END IF;
587:
588:
589: -- Update Process Flag for requests with Errors

Line 604: oe_debug_pub.add('Ship from and ship to orgid are mandatory' , 1 ) ;

600: p_line_rec.ship_to_org_id IS NULL
601: THEN
602:
603: IF l_debug_level > 0 THEN
604: oe_debug_pub.add('Ship from and ship to orgid are mandatory' , 1 ) ;
605: END IF;
606:
607: FND_MESSAGE.SET_NAME('ONT','OE_ECS_MISSING_SRC_DEST');
608:

Line 628: oe_debug_pub.add('Before calling get service details...' ) ;

624: -- Check whether Additional Country Check is needed
625: -- Get the Service type Code
626: -- Moved this call before building the address table for bug 5009103
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add('Before calling get service details...' ) ;
629: END IF;
630:
631: WSH_ITM_UTIL.Get_Service_Details(660,
632: p_master_organization_id,

Line 639: OE_DEBUG_PUB.Add('Get service details returned with ...'|| l_return_status);

635: x_supports_combination_flag,
636: l_return_status);
637:
638: IF l_debug_level > 0 THEN
639: OE_DEBUG_PUB.Add('Get service details returned with ...'|| l_return_status);
640: END IF;
641:
642: -- Check for Denied Party Service
643:

Line 664: oe_debug_pub.add('No Service is Available...');

660: END LOOP;
661: -- Return if service is not available.
662: IF G_Dp_service_flag = 'N' AND l_Generic_Service_Flag = 'N'THEN
663: IF l_debug_level > 0 THEN
664: oe_debug_pub.add('No Service is Available...');
665: END IF;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: RETURN;
668: END IF;

Line 768: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||'_country code:'||x_party_country,3);

764: Address_table(I).add_party_contact_name := x_contact_name;
765:
766:
767: IF l_debug_level > 0 THEN
768: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||'_country code:'||x_party_country,3);
769: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' party:'||x_party_name,3);
770: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' state:'||x_party_state,3);-- bug 5009103
771: END IF;
772: END LOOP; -- Loop for getting Address details

Line 769: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' party:'||x_party_name,3);

765:
766:
767: IF l_debug_level > 0 THEN
768: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||'_country code:'||x_party_country,3);
769: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' party:'||x_party_name,3);
770: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' state:'||x_party_state,3);-- bug 5009103
771: END IF;
772: END LOOP; -- Loop for getting Address details
773:

Line 770: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' state:'||x_party_state,3);-- bug 5009103

766:
767: IF l_debug_level > 0 THEN
768: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||'_country code:'||x_party_country,3);
769: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' party:'||x_party_name,3);
770: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' state:'||x_party_state,3);-- bug 5009103
771: END IF;
772: END LOOP; -- Loop for getting Address details
773:
774: -- Check For Ship From and Ship To Party names

Line 796: oe_debug_pub.add('Ship from and customer party name are mandatory' , 1 ) ;

792:
793: OE_MSG_PUB.Add;
794:
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add('Ship from and customer party name are mandatory' , 1 ) ;
797: END IF;
798:
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: RETURN;

Line 815: oe_debug_pub.add('Addl country name:'||l_addl_country_name);

811: SELECT wsh_itm_request_set_s.NEXTVAL
812: INTO l_request_set_id
813: FROM dual;
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add('Addl country name:'||l_addl_country_name);
816: END IF;
817: ELSE
818: l_rec_count := 1;
819: END IF;

Line 1046: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;

1042:
1043: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1049: END IF;
1050:

Line 1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;

1043: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1049: END IF;
1050:
1051: -- BUG 5408161

Line 1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;

1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1049: END IF;
1050:
1051: -- BUG 5408161
1052: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)

Line 1106: oe_debug_pub.add('Inserted record in to wsh_itm_items...' , 1 ) ;

1102: FND_GLOBAL.USER_ID
1103: );
1104:
1105: IF l_debug_level > 0 THEN
1106: oe_debug_pub.add('Inserted record in to wsh_itm_items...' , 1 ) ;
1107: END IF;
1108:
1109: END IF;
1110:

Line 1245: oe_debug_pub.add( 'INSERTED '||J||' RECORDS IN TO WSH_ITM_PARTIES...' ) ;

1241: FND_GLOBAL.USER_ID
1242: );
1243:
1244: IF l_debug_level > 0 THEN
1245: oe_debug_pub.add( 'INSERTED '||J||' RECORDS IN TO WSH_ITM_PARTIES...' ) ;
1246: END IF;
1247:
1248: END IF; -- Check for Org id
1249:

Line 1256: oe_debug_pub.add( 'END CREATING REQUEST...' ) ;

1252: END LOOP; -- Loop for inserting records in to Request Control
1253:
1254:
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'END CREATING REQUEST...' ) ;
1257: END IF;
1258: x_return_status := FND_API.G_RET_STS_SUCCESS;
1259:
1260: EXCEPTION

Line 1263: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;

1259:
1260: EXCEPTION
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1267: WHEN OTHERS THEN

Line 1266: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;

1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1267: WHEN OTHERS THEN
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1270: FND_MSG_PUB.Add_Exc_Msg

Line 1275: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;

1271: (G_PKG_NAME,
1272: l_api_name
1273: );
1274: END IF;
1275: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1276:
1277: END Create_Request;
1278:
1279: /*-----------------------------------------------------+

Line 1347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1343: l_dummy VARCHAR2(10);
1344: l_org_id NUMBER;
1345: l_serv INTEGER;
1346: --
1347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1348: --
1349: BEGIN
1350:
1351: OE_DEBUG_PUB.Add('Entering WSH_ITM_ONT...');

Line 1351: OE_DEBUG_PUB.Add('Entering WSH_ITM_ONT...');

1347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1348: --
1349: BEGIN
1350:
1351: OE_DEBUG_PUB.Add('Entering WSH_ITM_ONT...');
1352:
1353: SAVEPOINT RESPONSE_API;
1354:
1355: -- Get the Line Id

Line 1403: oe_debug_pub.add('OEXVITMB.pls: unable to lock the line',1);

1399: FOR UPDATE; --Commented for bug 6415831 --nowait;
1400: EXCEPTION
1401: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1402: IF l_debug_level > 0 THEN
1403: oe_debug_pub.add('OEXVITMB.pls: unable to lock the line',1);
1404: END IF;
1405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1406: OE_MSG_PUB.set_msg_context(
1407: p_entity_code => 'LINE'

Line 1427: oe_debug_pub.add('The line '||to_char(l_line_id)||'is already cancelled.',1);

1423: -- Check whether the Line is cancelled
1424:
1425: IF l_line_rec.cancelled_flag = 'Y' THEN
1426: IF l_debug_level > 0 THEN
1427: oe_debug_pub.add('The line '||to_char(l_line_id)||'is already cancelled.',1);
1428: END IF;
1429: RETURN;
1430: END IF;
1431:

Line 1453: oe_debug_pub.add('Override screening for line id:'||l_line_id,3);

1449:
1450: IF p_status_code = 'OVERRIDE' THEN
1451:
1452: IF l_debug_level > 0 THEN
1453: oe_debug_pub.add('Override screening for line id:'||l_line_id,3);
1454: END IF;
1455:
1456: -- Update Work flow Status Code
1457:

Line 1500: OE_DEBUG_PUB.Add('Response analyser return status :'|| l_return_status,1);

1496:
1497:
1498:
1499: IF l_debug_level > 0 THEN
1500: OE_DEBUG_PUB.Add('Response analyser return status :'|| l_return_status,1);
1501: END IF;
1502:
1503: -- Check for System or Data errors.
1504:

Line 1556: OE_DEBUG_PUB.Add('Party Name:'||c_resplines.party_name||',denied');

1552: FND_MESSAGE.SET_TOKEN('DENIEDPARTY',
1553: c_resplines.party_name);
1554: OE_MSG_PUB.Add;
1555: IF l_debug_level > 0 THEN
1556: OE_DEBUG_PUB.Add('Party Name:'||c_resplines.party_name||',denied');
1557: END IF;
1558: END IF;
1559: END;
1560: END LOOP;

Line 1568: OE_DEBUG_PUB.Add('Service Result'||l_services(l_serv).Service_Result,1);

1564:
1565: FOR l_serv IN 1..l_services.COUNT
1566: LOOP
1567: IF l_debug_level > 0 THEN
1568: OE_DEBUG_PUB.Add('Service Result'||l_services(l_serv).Service_Result,1);
1569: END IF;
1570:
1571: IF l_services(l_serv).Service_Type = 'DP' THEN
1572: l_dp_hold_flag := l_services(l_serv).Service_Result;

Line 1591: oe_debug_pub.add('Progress Work Flow to Next Stage...',1);

1587:
1588: -- Progress Work Flow to Next Stage
1589:
1590: IF l_debug_level > 0 THEN
1591: oe_debug_pub.add('Progress Work Flow to Next Stage...',1);
1592: END IF;
1593:
1594:
1595: -- If one response has system error and other has data error we

Line 1624: OE_DEBUG_PUB.Add('Generic Hold!!!');

1620:
1621: ELSIF l_gen_hold_flag = 'Y' AND
1622: OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1623:
1624: OE_DEBUG_PUB.Add('Generic Hold!!!');
1625:
1626: -- The Hold_Id of the Generic Hold has been
1627: -- seeded as 23.
1628:

Line 1650: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);

1646: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1649: IF l_debug_level > 0 THEN
1650: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);
1651: END IF;
1652: END IF;
1653:
1654: OE_Order_WF_Util.Update_Flow_Status_Code

Line 1699: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);

1695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);
1700: END IF;
1701: END IF;
1702:
1703: OE_Order_WF_Util.Update_Flow_Status_Code

Line 1745: oe_debug_pub.add('Exiting response api',1);

1741:
1742: OE_MSG_PUB.SAVE_MESSAGES(l_line_rec.line_id);
1743:
1744: IF l_debug_level > 0 THEN
1745: oe_debug_pub.add('Exiting response api',1);
1746: END IF;
1747:
1748: EXCEPTION
1749: WHEN OTHERS THEN