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

Line 50: oe_debug_pub.add('When Others excep=> ' || sqlerrm);

46: end if;
47:
48: Exception
49: When Others then
50: oe_debug_pub.add('When Others excep=> ' || sqlerrm);
51: End;
52: -- Lock the Header Table before Updating for bug 4505695
53: -- Changing oe_order_headers to oe_order_headers_all for bug#13831068
54: SELECT header_id

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

384: Where Header_id = p_header_id
385: And Acknowledgment_Flag Is Null
386: For Update;
387:
388: l_debug_level Constant Number := Oe_Debug_Pub.g_debug_level;
389: l_return_status Varchar2(1) := FND_API.g_ret_sts_success;
390:
391: l_sold_to_site_use_id Number;
392: l_sold_to_location Varchar2(40);

Line 408: Oe_Debug_Pub.Add('Entering OE_Update_Ack_Util.write_ack_data_values');

404:
405: Begin
406:
407: If l_debug_level > 0 Then
408: Oe_Debug_Pub.Add('Entering OE_Update_Ack_Util.write_ack_data_values');
409: Oe_Debug_Pub.Add('Header_id: ||p_header_id');
410: End If;
411:
412: Open Header_Acks_Cur;

Line 409: Oe_Debug_Pub.Add('Header_id: ||p_header_id');

405: Begin
406:
407: If l_debug_level > 0 Then
408: Oe_Debug_Pub.Add('Entering OE_Update_Ack_Util.write_ack_data_values');
409: Oe_Debug_Pub.Add('Header_id: ||p_header_id');
410: End If;
411:
412: Open Header_Acks_Cur;
413: Fetch Header_Acks_Cur

Line 489: Oe_Debug_Pub.Add('Error in getting sold to info '||sqlerrm);

485:
486: Exception
487: When Others Then
488: If l_debug_level > 0 Then
489: Oe_Debug_Pub.Add('Error in getting sold to info '||sqlerrm);
490: End If;
491: End;
492:
493: -- Get Ship To info

Line 524: Oe_Debug_Pub.Add('Error in getting ship to info '||sqlerrm);

520:
521: Exception
522: When Others Then
523: If l_debug_level > 0 Then
524: Oe_Debug_Pub.Add('Error in getting ship to info '||sqlerrm);
525: End If;
526: End;
527:
528: -- Get Invoice To info

Line 558: Oe_Debug_Pub.Add('Error in getting invoice to info '||sqlerrm);

554: End If;
555: Exception
556: When Others Then
557: If l_debug_level > 0 Then
558: Oe_Debug_Pub.Add('Error in getting invoice to info '||sqlerrm);
559: End If;
560: End;
561:
562: -- Get Ship From info

Line 584: Oe_Debug_Pub.Add('Error in getting Ship From info '||sqlerrm);

580: End If;
581: Exception
582: When Others Then
583: If l_debug_level > 0 Then
584: Oe_Debug_Pub.Add('Error in getting Ship From info '||sqlerrm);
585: End If;
586: End;
587:
588: -- Get Order Type, Price List, Salesrep, FOB, tax

Line 638: Oe_Debug_Pub.Add('Before end customer derivation for header1');

634: (p_invoicing_rule_id => l_header_acks_rec.invoicing_rule_id);
635: End If;
636: --added for bug 40344441 start
637: If l_debug_level > 0 Then
638: Oe_Debug_Pub.Add('Before end customer derivation for header1');
639: End If;
640:
641: If l_header_acks_rec.end_customer_id Is Not Null Then
642: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_header_acks_rec.end_customer_id

Line 652: Oe_Debug_Pub.Add('Before end customer derivation for header2');

648:
649:
650:
651: If l_debug_level > 0 Then
652: Oe_Debug_Pub.Add('Before end customer derivation for header2');
653: End If;
654:
655: If l_header_acks_rec.end_customer_contact_id Is Not Null Then
656: l_header_acks_rec.end_customer_contact := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_header_acks_rec.end_customer_contact_id);

Line 663: Oe_Debug_Pub.Add('Before end customer derivation for header3');

659:
660:
661:
662: If l_debug_level > 0 Then
663: Oe_Debug_Pub.Add('Before end customer derivation for header3');
664: End If;
665:
666:
667:

Line 686: Oe_Debug_Pub.Add('Before ship to customer name derviation for header');

682: --added for bug 40344441 end
683: -- start of changes for bug 4489065
684:
685: If l_debug_level > 0 Then
686: Oe_Debug_Pub.Add('Before ship to customer name derviation for header');
687: End If;
688:
689: If l_header_acks_rec.ship_to_org_id Is Not Null Then
690: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_acks_rec.ship_to_org_id,

Line 695: Oe_Debug_Pub.Add('Before invoice to customer name derviation for header');

691: x_ship_to_customer_name => l_header_acks_rec.ship_to_customer);
692: End If;
693:
694: If l_debug_level > 0 Then
695: Oe_Debug_Pub.Add('Before invoice to customer name derviation for header');
696: End If;
697:
698: If l_header_acks_rec.invoice_to_org_id Is Not Null Then
699: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_acks_rec.invoice_to_org_id,

Line 711: Oe_Debug_Pub.Add('Error in getting other ids '||sqlerrm);

707: Exception
708:
709: When Others Then
710: If l_debug_level > 0 Then
711: Oe_Debug_Pub.Add('Error in getting other ids '||sqlerrm);
712: End If;
713:
714: End;
715:

Line 842: Oe_Debug_Pub.Add('Before end customer derivation for lines1');

838: l_line_acks_rec.payment_term(i) := OE_Id_To_Value.payment_term
839: (p_payment_term_id => l_line_acks_rec.payment_term_id(i));
840:
841: If l_debug_level > 0 Then
842: Oe_Debug_Pub.Add('Before end customer derivation for lines1');
843: End If;
844:
845:
846: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_acks_rec.end_customer_id(i)

Line 853: Oe_Debug_Pub.Add('Before end customer derivation for lines2');

849: );
850:
851:
852: If l_debug_level > 0 Then
853: Oe_Debug_Pub.Add('Before end customer derivation for lines2');
854: End If;
855:
856:
857: l_line_acks_rec.end_customer_contact(i) := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_acks_rec.end_customer_contact_id(i));

Line 861: Oe_Debug_Pub.Add('Before end customer derivation for lines3');

857: l_line_acks_rec.end_customer_contact(i) := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_acks_rec.end_customer_contact_id(i));
858:
859:
860: If l_debug_level > 0 Then
861: Oe_Debug_Pub.Add('Before end customer derivation for lines3');
862: End If;
863:
864: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_acks_rec.end_customer_site_use_id(i)
865: , x_end_customer_address1 => l_line_acks_rec.end_customer_address1(i)

Line 877: Oe_Debug_Pub.Add('after end customer derivation for lines');

873: , x_end_customer_country => l_line_acks_rec.end_customer_country(i)
874: );
875:
876: If l_debug_level > 0 Then
877: Oe_Debug_Pub.Add('after end customer derivation for lines');
878: End If;
879:
880:
881: -- Get address info for lines here

Line 914: Oe_Debug_Pub.Add('Error in getting ship to info line'||sqlerrm);

910:
911: Exception
912: When Others Then
913: If l_debug_level > 0 Then
914: Oe_Debug_Pub.Add('Error in getting ship to info line'||sqlerrm);
915: End If;
916: End;
917:
918: /*

Line 942: Oe_Debug_Pub.Add('Error in getting invoice to info line'||sqlerrm);

938:
939: Exception
940: When Others Then
941: If l_debug_level > 0 Then
942: Oe_Debug_Pub.Add('Error in getting invoice to info line'||sqlerrm);
943: End If;
944:
945: End;
946: */

Line 970: Oe_Debug_Pub.Add('Error in getting Ship From info line'||sqlerrm);

966: End If;
967: Exception
968: When Others Then
969: If l_debug_level > 0 Then
970: Oe_Debug_Pub.Add('Error in getting Ship From info line'||sqlerrm);
971: End If;
972: End;
973:
974: End If;

Line 1097: Oe_Debug_Pub.Add('Exiting OE_Update_Ack_Util.write_ack_data_values');

1093:
1094: x_return_status := FND_API.G_RET_STS_SUCCESS;
1095:
1096: If l_debug_level > 0 Then
1097: Oe_Debug_Pub.Add('Exiting OE_Update_Ack_Util.write_ack_data_values');
1098: End If;
1099:
1100: Exception
1101:

Line 1104: Oe_Debug_Pub.Add('More than 1 ack header in Ack tables which is not acknowledged');

1100: Exception
1101:
1102: When Too_Many_Rows Then
1103: If l_debug_level > 0 Then
1104: Oe_Debug_Pub.Add('More than 1 ack header in Ack tables which is not acknowledged');
1105: End If;
1106:
1107: When Others Then
1108: If l_debug_level > 0 Then

Line 1109: Oe_Debug_Pub.Add('Others Exception in write_ack_data_values '||sqlerrm);

1105: End If;
1106:
1107: When Others Then
1108: If l_debug_level > 0 Then
1109: Oe_Debug_Pub.Add('Others Exception in write_ack_data_values '||sqlerrm);
1110: End If;
1111:
1112: x_return_status := FND_API.G_RET_STS_ERROR;
1113:

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

1127: l_transaction_type Varchar2(4);
1128: l_transaction_subtype Varchar2(4);
1129: l_return_status Varchar2(1);
1130:
1131: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1132: l_user_key Varchar2(240);
1133: l_orig_sys_document_ref Varchar2(50);
1134: l_change_sequence Varchar2(50);
1135: l_sold_to_org_id Number;

Line 1146: Oe_Debug_Pub.Add('In Derive_Ack_Values');

1142:
1143: Begin
1144:
1145: If l_debug_level > 0 Then
1146: Oe_Debug_Pub.Add('In Derive_Ack_Values');
1147: End If;
1148:
1149: Oe_Standard_Wf.Set_Msg_Context(p_actid);
1150:

Line 1230: Oe_Debug_Pub.Add('Header Id = '||l_header_id);

1226: itemkey => p_itemkey,
1227: userkey => l_user_key);
1228:
1229: If l_debug_level > 0 Then
1230: Oe_Debug_Pub.Add('Header Id = '||l_header_id);
1231: End If;
1232:
1233: write_ack_data_values
1234: (p_header_id => l_header_id,

Line 1269: Oe_Debug_Pub.Add('End Derive_Ack_Values');

1265: --OE_STANDARD_WF.Save_Messages;
1266: --OE_STANDARD_WF.Clear_Msg_Context;
1267:
1268: If l_debug_level > 0 Then
1269: Oe_Debug_Pub.Add('End Derive_Ack_Values');
1270: End If;
1271:
1272: Exception
1273:

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

1303: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1304: l_event_name Varchar2(50);
1305: l_itemkey Number;
1306:
1307: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1308: --Pragma AUTONOMOUS_TRANSACTION;
1309: l_return_status Varchar2(1);
1310:
1311:

Line 1315: Oe_Debug_Pub.Add('In Raise_Derive_Ack_Data_event');

1311:
1312: Begin
1313:
1314: If l_debug_level > 0 Then
1315: Oe_Debug_Pub.Add('In Raise_Derive_Ack_Data_event');
1316: End If;
1317:
1318: l_event_name := 'oracle.apps.ont.oi.edi_ack_values.create';
1319:

Line 1400: Oe_Debug_Pub.Add('End Raise_Derive_Ack_Data_event');

1396: x_return_status => l_return_status);
1397: */
1398:
1399: If l_debug_level > 0 Then
1400: Oe_Debug_Pub.Add('End Raise_Derive_Ack_Data_event');
1401: End If;
1402:
1403: Exception
1404:

Line 1408: Oe_Debug_Pub.Add('Others exception in Raise_Derive_Ack_Data_event');

1404:
1405: When Others Then
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: If l_debug_level > 0 Then
1408: Oe_Debug_Pub.Add('Others exception in Raise_Derive_Ack_Data_event');
1409: Oe_Debug_Pub.Add('Error: '||sqlerrm);
1410: End If;
1411:
1412: End Raise_Derive_Ack_Data_event;

Line 1409: Oe_Debug_Pub.Add('Error: '||sqlerrm);

1405: When Others Then
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: If l_debug_level > 0 Then
1408: Oe_Debug_Pub.Add('Others exception in Raise_Derive_Ack_Data_event');
1409: Oe_Debug_Pub.Add('Error: '||sqlerrm);
1410: End If;
1411:
1412: End Raise_Derive_Ack_Data_event;
1413:

Line 1424: l_debug_level Constant Number := oe_debug_pub.g_debug_level;

1420: p_x_result in out Nocopy varchar2
1421: )
1422: Is
1423:
1424: l_debug_level Constant Number := oe_debug_pub.g_debug_level;
1425: l_user_id Number ;
1426: l_resp_appl_id Number ;
1427: l_resp_id Number ;
1428: l_org_id Number;

Line 1446: oe_debug_pub.add('l_org_id =>' || l_org_id);

1442: , p_itemkey
1443: , 'ORG_ID'
1444: );
1445: If l_debug_level > 0 Then
1446: oe_debug_pub.add('l_org_id =>' || l_org_id);
1447: End If;
1448:
1449: mo_global.set_policy_context(p_access_mode => 'S', p_org_id=>l_Org_Id);
1450: p_x_result := 'COMPLETE';