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: SELECT header_id
54: INTO l_header_id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

647:
648:
649:
650: If l_debug_level > 0 Then
651: Oe_Debug_Pub.Add('Before end customer derivation for header2');
652: End If;
653:
654: If l_header_acks_rec.end_customer_contact_id Is Not Null Then
655: 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 662: Oe_Debug_Pub.Add('Before end customer derivation for header3');

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

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

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

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

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

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

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

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

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

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

848: );
849:
850:
851: If l_debug_level > 0 Then
852: Oe_Debug_Pub.Add('Before end customer derivation for lines2');
853: End If;
854:
855:
856: 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 860: Oe_Debug_Pub.Add('Before end customer derivation for lines3');

856: 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));
857:
858:
859: If l_debug_level > 0 Then
860: Oe_Debug_Pub.Add('Before end customer derivation for lines3');
861: End If;
862:
863: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_acks_rec.end_customer_site_use_id(i)
864: , x_end_customer_address1 => l_line_acks_rec.end_customer_address1(i)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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