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_XML_PROCESS_UTIL dependencies on OE_DEBUG_PUB

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

8:
9: )
10: IS
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: Begin
15:
16: OUT_String := String1 || String2;

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

24: )
25: IS
26: l_site_use_id Number;
27: --
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30: Begin
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_TO_ORG_ID' ) ;

Line 32: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_TO_ORG_ID' ) ;

28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30: Begin
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_TO_ORG_ID' ) ;
33: END IF;
34: SELECT site_use_id
35: INTO l_site_use_id
36: FROM hz_cust_site_uses_all a, hz_cust_acct_sites_all b

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

58: )
59: IS
60: l_site_use_id Number;
61: --
62: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
63: --
64: Begin
65: IF l_debug_level > 0 THEN
66: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_BILL_TO_ORG_ID' ) ;

Line 66: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_BILL_TO_ORG_ID' ) ;

62: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
63: --
64: Begin
65: IF l_debug_level > 0 THEN
66: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_BILL_TO_ORG_ID' ) ;
67: END IF;
68:
69: SELECT site_use_id
70: INTO l_site_use_id

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

92: )
93: IS
94: l_sold_to_org_id Number;
95: --
96: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
97: --
98: Begin
99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_ORG_ID' ) ;

Line 100: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_ORG_ID' ) ;

96: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
97: --
98: Begin
99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_ORG_ID' ) ;
101: END IF;
102:
103: SELECT cust_account_id
104: INTO l_sold_to_org_id

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

124:
125: )
126: IS
127: --
128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
129: --
130: Begin
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_EDI_LOC' ) ;

Line 132: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_EDI_LOC' ) ;

128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
129: --
130: Begin
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_EDI_LOC' ) ;
133: END IF;
134:
135: Select /* MOAC_SQL_CHANGE */ a.ece_tp_location_code, c.party_name
136: Into x_edi_location_code, x_sold_to_name

Line 149: oe_debug_pub.add( 'EXITING OE_XML_PROCESS_UTIL.GET_SOLD_TO_EDI_LOC' ) ;

145: And a.cust_account_id = d.cust_account_id
146: And d.party_id = c.party_id;
147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'EXITING OE_XML_PROCESS_UTIL.GET_SOLD_TO_EDI_LOC' ) ;
150: END IF;
151: Exception
152: When Others Then
153: x_edi_location_code := Null;

Line 181: l_debug_level Constant Number := Oe_Debug_Pub.g_debug_level;

177: x_customer_name Out NOCOPY Varchar2,
178: x_return_status Out NOCOPY Varchar2
179: )
180: Is
181: l_debug_level Constant Number := Oe_Debug_Pub.g_debug_level;
182: Begin
183:
184: If l_debug_level > 0 Then
185: Oe_Debug_Pub.Add('Entering get_address_details');

Line 185: Oe_Debug_Pub.Add('Entering get_address_details');

181: l_debug_level Constant Number := Oe_Debug_Pub.g_debug_level;
182: Begin
183:
184: If l_debug_level > 0 Then
185: Oe_Debug_Pub.Add('Entering get_address_details');
186: Oe_Debug_Pub.Add('Site Use Id = '||p_site_use_id);
187: Oe_Debug_Pub.Add('Site Use Code = '||p_site_use_code);
188: End If;
189:

Line 186: Oe_Debug_Pub.Add('Site Use Id = '||p_site_use_id);

182: Begin
183:
184: If l_debug_level > 0 Then
185: Oe_Debug_Pub.Add('Entering get_address_details');
186: Oe_Debug_Pub.Add('Site Use Id = '||p_site_use_id);
187: Oe_Debug_Pub.Add('Site Use Code = '||p_site_use_code);
188: End If;
189:
190: If p_site_use_code = 'SHIP_FROM' Then

Line 187: Oe_Debug_Pub.Add('Site Use Code = '||p_site_use_code);

183:
184: If l_debug_level > 0 Then
185: Oe_Debug_Pub.Add('Entering get_address_details');
186: Oe_Debug_Pub.Add('Site Use Id = '||p_site_use_id);
187: Oe_Debug_Pub.Add('Site Use Code = '||p_site_use_code);
188: End If;
189:
190: If p_site_use_code = 'SHIP_FROM' Then
191:

Line 259: Oe_Debug_Pub.Add('Exiting get_address_details');

255:
256: End If;
257:
258: If l_debug_level > 0 Then
259: Oe_Debug_Pub.Add('Exiting get_address_details');
260: End If;
261:
262: Exception
263:

Line 266: Oe_Debug_Pub.Add('Unable to derive address values for Ack');

262: Exception
263:
264: When Others Then
265: If l_debug_level > 0 Then
266: Oe_Debug_Pub.Add('Unable to derive address values for Ack');
267: End If;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269:
270: End Get_Address_Details;

Line 280: l_debug_level Constant Number := Oe_Debug_Pub.g_debug_level;

276: x_last_name Out NOCOPY Varchar2,
277: x_return_status Out NOCOPY Varchar2)
278: Is
279:
280: l_debug_level Constant Number := Oe_Debug_Pub.g_debug_level;
281:
282: Begin
283:
284: If l_debug_level > 0 Then

Line 285: Oe_Debug_Pub.Add('Entering Get_Contact_Details');

281:
282: Begin
283:
284: If l_debug_level > 0 Then
285: Oe_Debug_Pub.Add('Entering Get_Contact_Details');
286: Oe_Debug_Pub.Add('Contact Id = '||p_contact_id);
287: Oe_Debug_Pub.Add('Cust Acct Id = '||p_cust_acct_id);
288: End If;
289:

Line 286: Oe_Debug_Pub.Add('Contact Id = '||p_contact_id);

282: Begin
283:
284: If l_debug_level > 0 Then
285: Oe_Debug_Pub.Add('Entering Get_Contact_Details');
286: Oe_Debug_Pub.Add('Contact Id = '||p_contact_id);
287: Oe_Debug_Pub.Add('Cust Acct Id = '||p_cust_acct_id);
288: End If;
289:
290: Select a.person_first_name, a.person_last_name

Line 287: Oe_Debug_Pub.Add('Cust Acct Id = '||p_cust_acct_id);

283:
284: If l_debug_level > 0 Then
285: Oe_Debug_Pub.Add('Entering Get_Contact_Details');
286: Oe_Debug_Pub.Add('Contact Id = '||p_contact_id);
287: Oe_Debug_Pub.Add('Cust Acct Id = '||p_cust_acct_id);
288: End If;
289:
290: Select a.person_first_name, a.person_last_name
291: Into x_first_name, x_last_name

Line 308: Oe_Debug_Pub.Add('Unable to derive Contact info for Ack '||sqlerrm);

304: Exception
305:
306: When Others Then
307: If l_debug_level > 0 Then
308: Oe_Debug_Pub.Add('Unable to derive Contact info for Ack '||sqlerrm);
309: End If;
310: x_return_status := FND_API.G_RET_STS_ERROR;
311:
312: End Get_Contact_Details;

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

318:
319: )
320: IS
321: --
322: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
323: --
324: Begin
325: IF l_debug_level > 0 THEN
326: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_FROM_EDI_LOC' ) ;

Line 326: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_FROM_EDI_LOC' ) ;

322: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
323: --
324: Begin
325: IF l_debug_level > 0 THEN
326: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_FROM_EDI_LOC' ) ;
327: END IF;
328:
329: Select hl.ece_tp_location_code
330: Into x_edi_location_code

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

352: )
353: IS
354: l_order_line_total NUMBER := 0;
355: --
356: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
357: --
358: BEGIN
359: l_order_line_total := oe_totals_grp.get_order_total
360: ( p_header_id => p_header_id,

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

424: l_orig_sys_document_ref Varchar2(50);
425: l_orig_sys_line_ref Varchar2(50);
426:
427: --
428: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
429: --
430: BEGIN
431:
432: IF l_debug_level > 0 THEN

Line 433: oe_debug_pub.add( 'ENTERING GET_PROCESSING_MSGS' ) ;

429: --
430: BEGIN
431:
432: IF l_debug_level > 0 THEN
433: oe_debug_pub.add( 'ENTERING GET_PROCESSING_MSGS' ) ;
434: END IF;
435:
436: -- { Start If p_ack_code
437: /* If p_ack_code = '0' Then

Line 441: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH ACCEPTED' ) ;

437: /* If p_ack_code = '0' Then
438: x_error_text := 'Accepted';
439: x_result := FND_API.G_RET_STS_SUCCESS;
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH ACCEPTED' ) ;
442: END IF;
443: Return;
444: End If;*/
445: -- End If p_ack_code }

Line 464: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH REJECTED HEADER' ) ;

460: ||' '||l_message_text, 1, 4000);
461: END LOOP;
462: CLOSE l_msg_cursor_hdr;
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH REJECTED HEADER' ) ;
465: oe_debug_pub.add( L_ERROR_TEXT ) ;
466: END IF;
467: Else
468: OPEN l_msg_cursor_line;

Line 465: oe_debug_pub.add( L_ERROR_TEXT ) ;

461: END LOOP;
462: CLOSE l_msg_cursor_hdr;
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH REJECTED HEADER' ) ;
465: oe_debug_pub.add( L_ERROR_TEXT ) ;
466: END IF;
467: Else
468: OPEN l_msg_cursor_line;
469: LOOP

Line 485: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH REJECTED LINE' ) ;

481: ||' '||l_message_text, 1, 4000);
482: END LOOP;
483: CLOSE l_msg_cursor_line;
484: IF l_debug_level > 0 THEN
485: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH REJECTED LINE' ) ;
486: oe_debug_pub.add( L_ERROR_TEXT ) ;
487: END IF;
488: End If;
489: -- End of if p_orig_sys_line_ref }

Line 486: oe_debug_pub.add( L_ERROR_TEXT ) ;

482: END LOOP;
483: CLOSE l_msg_cursor_line;
484: IF l_debug_level > 0 THEN
485: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS WITH REJECTED LINE' ) ;
486: oe_debug_pub.add( L_ERROR_TEXT ) ;
487: END IF;
488: End If;
489: -- End of if p_orig_sys_line_ref }
490:

Line 504: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS' ) ;

500: End If;
501: x_error_text := l_error_text;
502: x_result := FND_API.G_RET_STS_SUCCESS;
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS' ) ;
505: END IF;
506: Exception
507: When Others Then
508: IF l_debug_level > 0 THEN

Line 509: oe_debug_pub.add( 'OTHERS ERROR IN GETTING ERROR MESSAGE. SQLERR: ' || SQLERRM ) ;

505: END IF;
506: Exception
507: When Others Then
508: IF l_debug_level > 0 THEN
509: oe_debug_pub.add( 'OTHERS ERROR IN GETTING ERROR MESSAGE. SQLERR: ' || SQLERRM ) ;
510: END IF;
511: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS' ) ;

Line 513: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS' ) ;

509: oe_debug_pub.add( 'OTHERS ERROR IN GETTING ERROR MESSAGE. SQLERR: ' || SQLERRM ) ;
510: END IF;
511: x_result := FND_API.G_RET_STS_UNEXP_ERROR;
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add( 'EXITING GET_PROCESSING_MSGS' ) ;
514: END IF;
515: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
516: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'get_processing_msgs');
517: End if;

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

524:
525: )
526: IS
527: --
528: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
529: --
530: Begin
531: IF l_debug_level > 0 THEN
532: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SALES_PERSON' ) ;

Line 532: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SALES_PERSON' ) ;

528: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
529: --
530: Begin
531: IF l_debug_level > 0 THEN
532: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SALES_PERSON' ) ;
533: END IF;
534: x_salesrep := Oe_Id_To_Value.Salesrep(p_salesrep_id => p_salesrep_id);
535:
536: Exception

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

556:
557: l_customer_key_profile VARCHAR2(1) := 'N';
558:
559: --
560: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
561: --
562: Begin
563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY' ) ;

Line 564: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY' ) ;

560: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
561: --
562: Begin
563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY' ) ;
565: END IF;
566:
567: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
568: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

Line 571: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

567: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
568: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
569: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
570: IF l_debug_level > 0 THEN
571: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
572: END IF;
573: End If;
574:
575: select ordered_quantity

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

610:
611: l_customer_key_profile VARCHAR2(1) := 'N';
612:
613: --
614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
615: --
616: Begin
617: IF l_debug_level > 0 THEN
618: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY_UOM' ) ;

Line 618: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY_UOM' ) ;

614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
615: --
616: Begin
617: IF l_debug_level > 0 THEN
618: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY_UOM' ) ;
619: END IF;
620:
621:
622: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then

Line 626: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

622: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
623: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
624: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
625: IF l_debug_level > 0 THEN
626: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
627: END IF;
628: End If;
629:
630:

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

665:
666: l_customer_key_profile VARCHAR2(1) := 'N';
667:
668: --
669: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
670: --
671: begin
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.SET_CANCELLED_FLAG' ) ;

Line 673: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.SET_CANCELLED_FLAG' ) ;

669: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
670: --
671: begin
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.SET_CANCELLED_FLAG' ) ;
674: END IF;
675:
676:
677:

Line 682: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

678: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
679: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
680: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
683: END IF;
684: End If;
685:
686:

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

718:
719: l_customer_key_profile VARCHAR2(1) := 'N';
720:
721: --
722: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
723: --
724: begin
725:
726: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then

Line 730: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

726: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
727: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
728: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
729: IF l_debug_level > 0 THEN
730: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
731: END IF;
732: End If;
733:
734: Delete from OE_HEADER_ACKS

Line 745: oe_debug_pub.add( 'DELETED OE_HEADER_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||

741: And nvl(change_sequence, ' ')
742: = nvl(p_change_sequence, ' ')
743: And request_id = p_request_id;
744: IF l_debug_level > 0 THEN
745: oe_debug_pub.add( 'DELETED OE_HEADER_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||
746: ' AND ACKNOWLEDGMENT_TYPE => ' || P_ACK_TYPE || ' AND REQUEST_ID => ' || P_REQUEST_ID ||
747: ' AND SOLD_TO_ORG_ID => ' || P_SOLD_TO_ORG_ID ||
748: ' AND CHANGE_SEQUENCE => ' || P_CHANGE_SEQUENCE);
749: END IF;

Line 763: oe_debug_pub.add( 'DELETED OE_LINE_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||

759: And nvl(change_sequence, ' ')
760: = nvl(p_change_sequence, ' ')
761: And request_id = p_request_id;
762: IF l_debug_level > 0 THEN
763: oe_debug_pub.add( 'DELETED OE_LINE_ACKS ENTRIES FOR ORIG_SYS_DOCUMENT_REF => ' || P_ORIG_SYS_DOCUMENT_REF ||
764: ' AND ACKNOWLEDGMENT_TYPE => ' || P_ACK_TYPE || ' AND REQUEST_ID => ' || P_REQUEST_ID ||
765: ' AND SOLD_TO_ORG_ID => ' || P_SOLD_TO_ORG_ID ||
766: ' AND CHANGE_SEQUENCE => ' || P_CHANGE_SEQUENCE);
767: END IF;

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

790: l_customer_key_profile VARCHAR2(1) := 'N';
791:
792:
793: --
794: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
795: --
796:
797: Begin
798:

Line 804: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

800: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
801: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
802: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
803: IF l_debug_level > 0 THEN
804: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
805: END IF;
806: End If;
807:
808:

Line 832: oe_debug_pub.add( 'operation code is '|| x_operation_code ||' for orig_sys_document_ref ' || p_orig_sys_document_ref ||

828: x_operation_code := NULL;
829: End;
830:
831: IF l_debug_level > 0 THEN
832: oe_debug_pub.add( 'operation code is '|| x_operation_code ||' for orig_sys_document_ref ' || p_orig_sys_document_ref ||
833: ' orig_sys_line_ref ' || p_orig_sys_line_ref ||
834: ' orig_sys_shipment_ref ' || p_orig_sys_shipment_ref);
835: END IF;
836: