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 133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

129: x_contact_hz_id OUT NOCOPY NUMBER,
130: x_contact_number OUT NOCOPY VARCHAR2)
131: IS
132:
133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
134:
135: BEGIN
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add('OEXVITMB.pls: Inside Get_Contact_name, contact_id='||p_contact_id,3);

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

133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
134:
135: BEGIN
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add('OEXVITMB.pls: Inside Get_Contact_name, contact_id='||p_contact_id,3);
138: END IF;
139:
140: SELECT PARTY.PARTY_NAME, party.party_id, party.party_number
141: INTO x_contact_name, x_contact_hz_id, x_contact_number --Bug 9583024

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

155: AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID;
156:
157:
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('OEXVITMB.pls: Contact name ='||x_contact_name,5);
160: oe_debug_pub.add('OEXVITMB.pls: Contact Hz id ='||x_contact_hz_id,5);
161: oe_debug_pub.add('OEXVITMB.pls: Contact Hz number ='||x_contact_number,5);
162: oe_debug_pub.add('Exiting Get_Contact_name',3);
163: END IF;

Line 160: oe_debug_pub.add('OEXVITMB.pls: Contact Hz id ='||x_contact_hz_id,5);

156:
157:
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('OEXVITMB.pls: Contact name ='||x_contact_name,5);
160: oe_debug_pub.add('OEXVITMB.pls: Contact Hz id ='||x_contact_hz_id,5);
161: oe_debug_pub.add('OEXVITMB.pls: Contact Hz number ='||x_contact_number,5);
162: oe_debug_pub.add('Exiting Get_Contact_name',3);
163: END IF;
164:

Line 161: oe_debug_pub.add('OEXVITMB.pls: Contact Hz number ='||x_contact_number,5);

157:
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('OEXVITMB.pls: Contact name ='||x_contact_name,5);
160: oe_debug_pub.add('OEXVITMB.pls: Contact Hz id ='||x_contact_hz_id,5);
161: oe_debug_pub.add('OEXVITMB.pls: Contact Hz number ='||x_contact_number,5);
162: oe_debug_pub.add('Exiting Get_Contact_name',3);
163: END IF;
164:
165:

Line 162: oe_debug_pub.add('Exiting Get_Contact_name',3);

158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add('OEXVITMB.pls: Contact name ='||x_contact_name,5);
160: oe_debug_pub.add('OEXVITMB.pls: Contact Hz id ='||x_contact_hz_id,5);
161: oe_debug_pub.add('OEXVITMB.pls: Contact Hz number ='||x_contact_number,5);
162: oe_debug_pub.add('Exiting Get_Contact_name',3);
163: END IF;
164:
165:
166: EXCEPTION

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

165:
166: EXCEPTION
167: WHEN NO_DATA_FOUND THEN
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add('OEXVITMB: NO_DATA_FOUND exception..',3 );
170: END IF;
171: Raise;
172: WHEN OTHERS THEN
173: IF l_debug_level > 0 THEN

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

170: END IF;
171: Raise;
172: WHEN OTHERS THEN
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add('OEXVITMB: OTHERS exception in Get_Contact_name...',3 );
175: END IF;
176: Raise;
177: END Get_Contact_name;
178:

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

351: l_contact_name HZ_PARTIES.PARTY_NAME%TYPE;
352: l_contact_hz_id HZ_PARTIES.PARTY_ID%TYPE;
353: l_contact_number HZ_PARTIES.PARTY_NUMBER%TYPE;
354: --
355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
356: --
357: BEGIN
358:
359: IF l_debug_level > 0 THEN

Line 360: 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

356: --
357: BEGIN
358:
359: IF l_debug_level > 0 THEN
360: 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
361: END IF;
362:
363: IF (p_source_type IN ('INTERMED_SHIP_TO','SHIP_TO',
364: 'BILL_TO','DELIVER_TO', 'END_CUSTOMER')) THEN --Bug 9583024

Line 390: oe_debug_pub.add('Before calling Get_Contact_name...' ) ;

386:
387: -- Bug 9583024 : START
388: IF p_contact_id IS NOT NULL THEN --bug5140692
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add('Before calling Get_Contact_name...' ) ;
391: END IF;
392:
393: Get_Contact_name(p_contact_id, l_contact_name , l_contact_hz_id, l_contact_number);
394:

Line 396: OE_DEBUG_PUB.Add('After calling Get_Contact_name ...');

392:
393: Get_Contact_name(p_contact_id, l_contact_name , l_contact_hz_id, l_contact_number);
394:
395: IF l_debug_level > 0 THEN
396: OE_DEBUG_PUB.Add('After calling Get_Contact_name ...');
397: END IF;
398:
399: x_contact_person := l_contact_name;
400: x_contact_hz_party_id := l_contact_hz_id;

Line 455: oe_debug_pub.add('Before calling Get_Contact_name...' ) ;

451: IF p_contact_id IS NOT NULL THEN --bug5140692
452:
453: -- Bug 9583024 : START
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add('Before calling Get_Contact_name...' ) ;
456: END IF;
457:
458: Get_Contact_name(p_contact_id, l_contact_name , l_contact_hz_id, l_contact_number);
459:

Line 461: OE_DEBUG_PUB.Add('After calling Get_Contact_name ...');

457:
458: Get_Contact_name(p_contact_id, l_contact_name , l_contact_hz_id, l_contact_number);
459:
460: IF l_debug_level > 0 THEN
461: OE_DEBUG_PUB.Add('After calling Get_Contact_name ...');
462: END IF;
463:
464: x_contact_person := l_contact_name;
465: x_contact_hz_party_id := l_contact_hz_id;

Line 494: oe_debug_pub.add('Before calling Get_Contact_name...' ) ;

490: IF p_contact_id IS NOT NULL THEN --bug5140692
491:
492: -- Bug 9583024 : START
493: IF l_debug_level > 0 THEN
494: oe_debug_pub.add('Before calling Get_Contact_name...' ) ;
495: END IF;
496:
497: Get_Contact_name(p_contact_id, l_contact_name , l_contact_hz_id, l_contact_number);
498:

Line 500: OE_DEBUG_PUB.Add('After calling Get_Contact_name ...');

496:
497: Get_Contact_name(p_contact_id, l_contact_name , l_contact_hz_id, l_contact_number);
498:
499: IF l_debug_level > 0 THEN
500: OE_DEBUG_PUB.Add('After calling Get_Contact_name ...');
501: END IF;
502: x_contact_person := l_contact_name;
503:
504: x_contact_hz_party_id := l_contact_hz_id;

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

513: END IF;
514: END IF;
515:
516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add('Exiting get_address',4);
518: END IF;
519: EXCEPTION
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

548: l_request_control_id_list WSH_ITM_UTIL.CONTROL_ID_LIST;
549: x_return_status VARCHAR2(30);
550:
551: --
552: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
553: --
554: BEGIN
555:
556: IF l_debug_level > 0 THEN

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

553: --
554: BEGIN
555:
556: IF l_debug_level > 0 THEN
557: oe_debug_pub.add('Entering update process flag..' , 4 ) ;
558: END IF;
559:
560: SELECT request_control_id
561: BULK COLLECT

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

575: END IF;
576:
577:
578: IF l_debug_level > 0 THEN
579: oe_debug_pub.add('Update process flag returned with ..'|| x_return_status ,1);
580: oe_debug_pub.add('Exiting update process flag..',4 ) ;
581: END IF;
582:
583: Exception

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

576:
577:
578: IF l_debug_level > 0 THEN
579: oe_debug_pub.add('Update process flag returned with ..'|| x_return_status ,1);
580: oe_debug_pub.add('Exiting update process flag..',4 ) ;
581: END IF;
582:
583: Exception
584: WHEN NO_DATA_FOUND THEN

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

597: PROCEDURE Init_Address_Table
598: IS
599: I INTEGER;
600: --
601: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
602: --
603: BEGIN
604:
605: FOR I in 1..Address_Table.COUNT

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

698: -- 4380792 Commented the below unused type code variable
699: -- and added term name variable
700: --l_payment_type_code VARCHAR2(30);
701: l_payment_term_name VARCHAR2(15);
702: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
703: l_sold_to_contact_id NUMBER; -- BUG 5140692
704:
705: l_product_code VARCHAR2(100); -- BUG 5408161
706: l_Item_type VARCHAR2(80); -- BUG 5408161

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

718: BEGIN
719:
720: l_Generic_Service_Flag := 'N';
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add('Start creating request...' ) ;
723: END IF;
724:
725:
726: -- Update Process Flag for requests with Errors

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

737: p_line_rec.ship_to_org_id IS NULL
738: THEN
739:
740: IF l_debug_level > 0 THEN
741: oe_debug_pub.add('Ship from and ship to orgid are mandatory' , 1 ) ;
742: END IF;
743:
744: FND_MESSAGE.SET_NAME('ONT','OE_ECS_MISSING_SRC_DEST');
745:

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

761: -- Check whether Additional Country Check is needed
762: -- Get the Service type Code
763: -- Moved this call before building the address table for bug 5009103
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add('Before calling get service details...' ) ;
766: END IF;
767:
768: WSH_ITM_UTIL.Get_Service_Details(660,
769: p_master_organization_id,

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

772: x_supports_combination_flag,
773: l_return_status);
774:
775: IF l_debug_level > 0 THEN
776: OE_DEBUG_PUB.Add('Get service details returned with ...'|| l_return_status);
777: END IF;
778:
779: -- Check for Denied Party Service
780:

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

797: END LOOP;
798: -- Return if service is not available.
799: IF G_Dp_service_flag = 'N' AND l_Generic_Service_Flag = 'N'THEN
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('No Service is Available...');
802: END IF;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: RETURN;
805: END IF;

Line 816: oe_debug_pub.add('GTM Integration enabled ' || l_itm_intg_gtm);

812: FETCH cur_check_gtm_flows into l_itm_intg_gtm;
813: CLOSE cur_check_gtm_flows;
814:
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add('GTM Integration enabled ' || l_itm_intg_gtm);
817: oe_debug_pub.add('end_customer_id '||to_char(p_line_rec.end_customer_id));
818: oe_debug_pub.add('end_customer_site_use_id '||to_char(p_line_rec.end_customer_site_use_id));
819: oe_debug_pub.add('end_customer_contact_id '||to_char(p_line_rec.end_customer_contact_id));
820: END IF;

Line 817: oe_debug_pub.add('end_customer_id '||to_char(p_line_rec.end_customer_id));

813: CLOSE cur_check_gtm_flows;
814:
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add('GTM Integration enabled ' || l_itm_intg_gtm);
817: oe_debug_pub.add('end_customer_id '||to_char(p_line_rec.end_customer_id));
818: oe_debug_pub.add('end_customer_site_use_id '||to_char(p_line_rec.end_customer_site_use_id));
819: oe_debug_pub.add('end_customer_contact_id '||to_char(p_line_rec.end_customer_contact_id));
820: END IF;
821:

Line 818: oe_debug_pub.add('end_customer_site_use_id '||to_char(p_line_rec.end_customer_site_use_id));

814:
815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add('GTM Integration enabled ' || l_itm_intg_gtm);
817: oe_debug_pub.add('end_customer_id '||to_char(p_line_rec.end_customer_id));
818: oe_debug_pub.add('end_customer_site_use_id '||to_char(p_line_rec.end_customer_site_use_id));
819: oe_debug_pub.add('end_customer_contact_id '||to_char(p_line_rec.end_customer_contact_id));
820: END IF;
821:
822: -- Fill Address table with Source types

Line 819: oe_debug_pub.add('end_customer_contact_id '||to_char(p_line_rec.end_customer_contact_id));

815: IF l_debug_level > 0 THEN
816: oe_debug_pub.add('GTM Integration enabled ' || l_itm_intg_gtm);
817: oe_debug_pub.add('end_customer_id '||to_char(p_line_rec.end_customer_id));
818: oe_debug_pub.add('end_customer_site_use_id '||to_char(p_line_rec.end_customer_site_use_id));
819: oe_debug_pub.add('end_customer_contact_id '||to_char(p_line_rec.end_customer_contact_id));
820: END IF;
821:
822: -- Fill Address table with Source types
823: Address_table(1).add_source_type := 'SHIP_FROM';

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

944: Address_Table(I).add_contact_hz_party_number := x_contact_hz_party_number ;
945:
946:
947: IF l_debug_level > 0 THEN
948: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||'_country code:'||x_party_country,3);
949: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' party:'||x_party_name,3);
950: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' state:'||x_party_state,3);-- bug 5009103
951: END IF;
952: END LOOP; -- Loop for getting Address details

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

945:
946:
947: IF l_debug_level > 0 THEN
948: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||'_country code:'||x_party_country,3);
949: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' party:'||x_party_name,3);
950: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' state:'||x_party_state,3);-- bug 5009103
951: END IF;
952: END LOOP; -- Loop for getting Address details
953:

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

946:
947: IF l_debug_level > 0 THEN
948: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||'_country code:'||x_party_country,3);
949: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' party:'||x_party_name,3);
950: OE_DEBUG_PUB.Add(Address_table(i).add_source_type ||' state:'||x_party_state,3);-- bug 5009103
951: END IF;
952: END LOOP; -- Loop for getting Address details
953:
954: -- Check For Ship From and Ship To Party names

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

972:
973: OE_MSG_PUB.Add;
974:
975: IF l_debug_level > 0 THEN
976: oe_debug_pub.add('Ship from and customer party name are mandatory' , 1 ) ;
977: END IF;
978:
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: RETURN;

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

991: SELECT wsh_itm_request_set_s.NEXTVAL
992: INTO l_request_set_id
993: FROM dual;
994: IF l_debug_level > 0 THEN
995: oe_debug_pub.add('Addl country name:'||l_addl_country_name);
996: END IF;
997: ELSE
998: l_rec_count := 1;
999: END IF;

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

1234:
1235: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1239: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1241: END IF;
1242:

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

1235: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1239: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1241: END IF;
1242:
1243: -- BUG 5408161

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

1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1239: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1241: END IF;
1242:
1243: -- BUG 5408161
1244: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)

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

1294: FND_GLOBAL.USER_ID
1295: );
1296:
1297: IF l_debug_level > 0 THEN
1298: oe_debug_pub.add('Inserted record in to wsh_itm_items...' , 1 ) ;
1299: END IF;
1300:
1301: END IF;
1302:

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

1445: Address_Table(J).add_contact_hz_party_number
1446: );
1447:
1448: IF l_debug_level > 0 THEN
1449: oe_debug_pub.add( 'INSERTED '||J||' RECORDS IN TO WSH_ITM_PARTIES...' ) ;
1450: END IF;
1451:
1452: END IF; -- Check for Org id
1453:

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

1456: END LOOP; -- Loop for inserting records in to Request Control
1457:
1458:
1459: IF l_debug_level > 0 THEN
1460: oe_debug_pub.add( 'END CREATING REQUEST...' ) ;
1461: END IF;
1462: x_return_status := FND_API.G_RET_STS_SUCCESS;
1463:
1464: EXCEPTION

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

1463:
1464: EXCEPTION
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1471: WHEN OTHERS THEN

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

1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1471: WHEN OTHERS THEN
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1474: FND_MSG_PUB.Add_Exc_Msg

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

1475: (G_PKG_NAME,
1476: l_api_name
1477: );
1478: END IF;
1479: oe_debug_pub.add( 'END CREATING REQUEST...'||sqlerrm ) ;
1480:
1481: END Create_Request;
1482:
1483: /*-----------------------------------------------------+

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

1561: l_activity VARCHAR2(250);
1562: l_interpreted_value VARCHAR2(30);
1563:
1564: --
1565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1566: --
1567: BEGIN
1568:
1569: SAVEPOINT RESPONSE_API;

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

1567: BEGIN
1568:
1569: SAVEPOINT RESPONSE_API;
1570:
1571: OE_DEBUG_PUB.Add('Entering WSH_ITM_ONT...');
1572:
1573: -- Begin : 8762350
1574: /* This API will now be used only to notify the workflow that ITM request
1575: has been completed. The actual updation of line with the screening

Line 1584: Oe_debug_pub.ADD('Req control ID / Req set ID / Status code : ' ||

1580: Line will not be progressed from the export_screening_compliance if
1581: it is in system error.
1582: */
1583:
1584: Oe_debug_pub.ADD('Req control ID / Req set ID / Status code : ' ||
1585: p_request_control_id || '/' || p_request_set_id ||
1586: '/' || p_status_code);
1587:
1588: -- Get the line and header ID

Line 1609: oe_debug_pub.add('Overriding export compliance screening.');

1605:
1606: IF p_status_code = 'OVERRIDE' THEN
1607:
1608: IF l_debug_level > 0 THEN
1609: oe_debug_pub.add('Overriding export compliance screening.');
1610: END IF;
1611:
1612: -- Bug 7688120
1613: SELECT wpa.activity_name -- Bug 10361575

Line 1629: oe_debug_pub.add('No action taken, notified activity is '||l_activity||'.'); -- Bug 10361575

1625: l_activity,
1626: 'OVERRIDE' );
1627: ELSE
1628: IF l_debug_level > 0 THEN
1629: oe_debug_pub.add('No action taken, notified activity is '||l_activity||'.'); -- Bug 10361575
1630: END IF;
1631: END IF;
1632:
1633: RETURN;

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

1648: x_return_status => l_return_status
1649: );
1650:
1651: IF l_debug_level > 0 THEN
1652: OE_DEBUG_PUB.Add('Response analyser return status :' || l_return_status, 1);
1653: OE_DEBUG_PUB.Add('Response Interpreted value :' || l_interpreted_value, 1);
1654: END IF;
1655:
1656: -- Do not progress the workflow if the line is in system error.

Line 1653: OE_DEBUG_PUB.Add('Response Interpreted value :' || l_interpreted_value, 1);

1649: );
1650:
1651: IF l_debug_level > 0 THEN
1652: OE_DEBUG_PUB.Add('Response analyser return status :' || l_return_status, 1);
1653: OE_DEBUG_PUB.Add('Response Interpreted value :' || l_interpreted_value, 1);
1654: END IF;
1655:
1656: -- Do not progress the workflow if the line is in system error.
1657:

Line 1694: OE_DEBUG_PUB.Add('Leaving WSH_ITM_ONT...');

1690: to_char(l_line_id),
1691: 'EXPORT_COMPLIANCE_SCREENING',
1692: 'COMPLETE' );
1693:
1694: OE_DEBUG_PUB.Add('Leaving WSH_ITM_ONT...');
1695:
1696: /*
1697:
1698: -- This select statement is used to lock the Top Model Line.

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

1723: FOR UPDATE; --Commented for bug 6415831 --nowait;
1724: EXCEPTION
1725: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1726: IF l_debug_level > 0 THEN
1727: oe_debug_pub.add('OEXVITMB.pls: unable to lock the line',1);
1728: END IF;
1729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1730: OE_MSG_PUB.set_msg_context(
1731: p_entity_code => 'LINE'

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

1747: -- Check whether the Line is cancelled
1748:
1749: IF l_line_rec.cancelled_flag = 'Y' THEN
1750: IF l_debug_level > 0 THEN
1751: oe_debug_pub.add('The line '||to_char(l_line_id)||'is already cancelled.',1);
1752: END IF;
1753: RETURN;
1754: END IF;
1755:

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

1773:
1774: IF p_status_code = 'OVERRIDE' THEN
1775:
1776: IF l_debug_level > 0 THEN
1777: oe_debug_pub.add('Override screening for line id:'||l_line_id,3);
1778: END IF;
1779:
1780: -- Update Work flow Status Code
1781:

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

1828:
1829:
1830:
1831: IF l_debug_level > 0 THEN
1832: OE_DEBUG_PUB.Add('Response analyser return status :'|| l_return_status,1);
1833: END IF;
1834:
1835: -- Check for System or Data errors.
1836:

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

1884: FND_MESSAGE.SET_TOKEN('DENIEDPARTY',
1885: c_resplines.party_name);
1886: OE_MSG_PUB.Add;
1887: IF l_debug_level > 0 THEN
1888: OE_DEBUG_PUB.Add('Party Name:'||c_resplines.party_name||',denied');
1889: END IF;
1890: END IF;
1891: END;
1892: END LOOP;

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

1896:
1897: FOR l_serv IN 1..l_services.COUNT
1898: LOOP
1899: IF l_debug_level > 0 THEN
1900: OE_DEBUG_PUB.Add('Service Result'||l_services(l_serv).Service_Result,1);
1901: END IF;
1902:
1903: IF l_services(l_serv).Service_Type = 'DP' THEN
1904: l_dp_hold_flag := l_services(l_serv).Service_Result;

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

1919:
1920: -- Progress Work Flow to Next Stage
1921:
1922: IF l_debug_level > 0 THEN
1923: oe_debug_pub.add('Progress Work Flow to Next Stage...',1);
1924: END IF;
1925:
1926:
1927: -- If one response has system error and other has data error we

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

1952:
1953: ELSIF l_gen_hold_flag = 'Y' AND
1954: OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1955:
1956: OE_DEBUG_PUB.Add('Generic Hold!!!');
1957:
1958: -- The Hold_Id of the Generic Hold has been
1959: -- seeded as 23.
1960:

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

1978: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add('Applied Generic hold on line:'|| l_line_rec.line_id,1);
1983: END IF;
1984: END IF;
1985:
1986: OE_Order_WF_Util.Update_Flow_Status_Code

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

2027: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2029: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2030: IF l_debug_level > 0 THEN
2031: oe_debug_pub.add('Applied denied party hold on line:'|| l_line_rec.line_id,1);
2032: END IF;
2033: END IF;
2034:
2035: OE_Order_WF_Util.Update_Flow_Status_Code

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

2073:
2074: OE_MSG_PUB.SAVE_MESSAGES(l_line_rec.line_id);
2075:
2076: IF l_debug_level > 0 THEN
2077: oe_debug_pub.add('Exiting response api',1);
2078: END IF; */
2079:
2080: -- End : 8762350
2081: