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.RCV_TRANSACTION_PROCESSOR dependencies on ASN_DEBUG

Line 181: asn_debug.put_line('RVTTHIns(p_rti_id:' || p_rti_id

177: l_fob_point number;
178: /*Bug 5517289-End*/
179:
180: BEGIN
181: asn_debug.put_line('RVTTHIns(p_rti_id:' || p_rti_id
182: || ', p_transaction_type: ' || p_transaction_type
183: || ', p_shipment_header_id: ' || p_shipment_header_id
184: || ', p_shipment_line_id: ' || p_shipment_line_id
185: || ', p_primary_unit_of_measure: ' || p_primary_unit_of_measure

Line 383: asn_debug.put_line('PO Unit Price from pll_archive :' || l_rt_row.po_unit_price);

379: from po_line_locations_archive
380: where line_location_id = l_rti_row.po_line_location_id
381: and nvl(latest_external_flag,'N') = 'Y';
382: --
383: asn_debug.put_line('PO Unit Price from pll_archive :' || l_rt_row.po_unit_price);
384: --
385: else
386: l_rt_row.po_unit_price := NULL;
387: end if;

Line 391: asn_debug.put_line('Fetching from pll_archive failed : ' || SQLERRM);

387: end if;
388: end if;
389: exception
390: when others then
391: asn_debug.put_line('Fetching from pll_archive failed : ' || SQLERRM);
392: l_rt_row.po_unit_price := NULL;
393: end;
394: --
395: if (l_rt_row.po_unit_price is null) then

Line 398: asn_debug.put_line('PO Unit Price is :' || l_rt_row.po_unit_price);

394: --
395: if (l_rt_row.po_unit_price is null) then
396: l_rt_row.po_unit_price := l_rti_row.po_unit_price;
397: end if;
398: asn_debug.put_line('PO Unit Price is :' || l_rt_row.po_unit_price);
399: --
400: -- Bug 6265149 : End
401:
402: IF l_rti_row.currency_code IS NULL THEN

Line 581: asn_debug.put_line('FOB Point is :' || l_fob_point);

577: OPEN c_fob_point(l_rti_row.from_organization_id,l_rti_row.to_organization_id);
578: FETCH c_fob_point INTO l_fob_point;
579: CLOSE c_fob_point;
580:
581: asn_debug.put_line('FOB Point is :' || l_fob_point);
582:
583: BEGIN
584:
585: IF (l_fob_point = 2) THEN

Line 586: asn_debug.put_line('Validating the INV accouting period for Organization :'||l_rti_row.from_organization_id);

582:
583: BEGIN
584:
585: IF (l_fob_point = 2) THEN
586: asn_debug.put_line('Validating the INV accouting period for Organization :'||l_rti_row.from_organization_id);
587: IF (RCV_TRANSACTION_PROCESSOR.get_acct_period_status(p_trx_date => l_rti_row.transaction_date,
588: p_org_id => l_rti_row.from_organization_id)
589: NOT IN ('O', 'F')) THEN
590: asn_debug.put_line('INV accounting period is not opened for the source organization :'|| l_rti_row.from_organization_id);

Line 590: asn_debug.put_line('INV accounting period is not opened for the source organization :'|| l_rti_row.from_organization_id);

586: asn_debug.put_line('Validating the INV accouting period for Organization :'||l_rti_row.from_organization_id);
587: IF (RCV_TRANSACTION_PROCESSOR.get_acct_period_status(p_trx_date => l_rti_row.transaction_date,
588: p_org_id => l_rti_row.from_organization_id)
589: NOT IN ('O', 'F')) THEN
590: asn_debug.put_line('INV accounting period is not opened for the source organization :'|| l_rti_row.from_organization_id);
591: x_error_message := 'PO_INV_NO_OPEN_PERIOD';
592: RETURN;
593: END IF;
594: END IF;

Line 597: asn_debug.put_line('unexpected error in get_acct_period_status');

593: END IF;
594: END IF;
595: EXCEPTION
596: WHEN OTHERS THEN
597: asn_debug.put_line('unexpected error in get_acct_period_status');
598: x_error_message := 'PO_INV_NO_OPEN_PERIOD';
599: RETURN;
600: END;
601: END IF;

Line 608: asn_debug.put_line('source_transaction_num:' || l_rt_row.source_transaction_num);

604: /* Bug 5842219:
605: source_transaction_num provided in the rti table has to be
606: maintained in the rt table. */
607: l_rt_row.source_transaction_num := l_rti_row.source_transaction_num;
608: asn_debug.put_line('source_transaction_num:' || l_rt_row.source_transaction_num);
609:
610: /* lcm changes */
611: l_rt_row.lcm_shipment_line_id := l_rti_row.lcm_shipment_line_id;
612: l_rt_row.unit_landed_cost := l_rti_row.unit_landed_cost;

Line 615: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);

611: l_rt_row.lcm_shipment_line_id := l_rti_row.lcm_shipment_line_id;
612: l_rt_row.unit_landed_cost := l_rti_row.unit_landed_cost;
613: l_rt_row.lcm_adjustment_num := l_rti_row.lcm_adjustment_num; --Changes for LCM-OPM integration project
614:
615: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
616: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
617: asn_debug.put_line('lcm_adjustment_num is ' || l_rt_row.lcm_adjustment_num); --Changes for LCM-OPM integration project
618:
619: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');

Line 616: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);

612: l_rt_row.unit_landed_cost := l_rti_row.unit_landed_cost;
613: l_rt_row.lcm_adjustment_num := l_rti_row.lcm_adjustment_num; --Changes for LCM-OPM integration project
614:
615: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
616: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
617: asn_debug.put_line('lcm_adjustment_num is ' || l_rt_row.lcm_adjustment_num); --Changes for LCM-OPM integration project
618:
619: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
620: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id

Line 617: asn_debug.put_line('lcm_adjustment_num is ' || l_rt_row.lcm_adjustment_num); --Changes for LCM-OPM integration project

613: l_rt_row.lcm_adjustment_num := l_rti_row.lcm_adjustment_num; --Changes for LCM-OPM integration project
614:
615: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
616: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
617: asn_debug.put_line('lcm_adjustment_num is ' || l_rt_row.lcm_adjustment_num); --Changes for LCM-OPM integration project
618:
619: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
620: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id
621: || ' parent_transaction_id: ' || l_rt_row.parent_transaction_id

Line 619: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');

615: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
616: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
617: asn_debug.put_line('lcm_adjustment_num is ' || l_rt_row.lcm_adjustment_num); --Changes for LCM-OPM integration project
618:
619: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
620: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id
621: || ' parent_transaction_id: ' || l_rt_row.parent_transaction_id
622: || ' interface_transaction_id: ' || l_rt_row.interface_transaction_id
623: || ' group_id: ' || l_rt_row.group_id

Line 620: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id

616: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
617: asn_debug.put_line('lcm_adjustment_num is ' || l_rt_row.lcm_adjustment_num); --Changes for LCM-OPM integration project
618:
619: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
620: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id
621: || ' parent_transaction_id: ' || l_rt_row.parent_transaction_id
622: || ' interface_transaction_id: ' || l_rt_row.interface_transaction_id
623: || ' group_id: ' || l_rt_row.group_id
624: || ' request_id: ' || l_rt_row.request_id

Line 882: asn_debug.put_line('Error occured while inserting into rcv_transactions...'||sqlerrm);

878: l_rt_row.unit_landed_cost, -- lcm changes
879: decode(l_rt_row.lcm_shipment_line_id, null, null,nvl(l_rt_row.lcm_adjustment_num,0)) );--changes for LCM-OPM integration project
880: EXCEPTION --Bug: 6487371
881: when others then
882: asn_debug.put_line('Error occured while inserting into rcv_transactions...'||sqlerrm);
883: x_error_message := substr(sqlerrm,1,200);
884: RETURN;
885: END;--Bug: 6487371
886:

Line 890: asn_debug.put_line('Updating child RTI rows');

886:
887: x_rt_id := l_rt_row.transaction_id;
888:
889: BEGIN
890: asn_debug.put_line('Updating child RTI rows');
891:
892: /* FPJ FASTFORWARD START.
893: * If this rti row is a parent of any rti rows, then
894: * we need to update the parent_transaction_id of

Line 913: asn_debug.put_line('Enabling Quality Inspection Results');

909: NULL;
910: END;
911:
912: IF NVL(l_rti_row.qa_collection_id,0) <> 0 THEN
913: asn_debug.put_line('Enabling Quality Inspection Results');
914:
915: DECLARE
916: l_return_status VARCHAR2(1);
917: l_msg_count NUMBER := 0;

Line 932: asn_debug.put_line('QA Actions Failed: ' || l_msg_data);

928: , l_msg_data
929: );
930:
931: IF l_msg_count IS NULL OR l_msg_count = -1 THEN
932: asn_debug.put_line('QA Actions Failed: ' || l_msg_data);
933: x_error_message := 'QA_ACTIONS_FAILED';
934: RETURN;
935: END IF;
936: EXCEPTION

Line 938: asn_debug.put_line('QA Actions Failed: ' || SQLERRM);

934: RETURN;
935: END IF;
936: EXCEPTION
937: WHEN OTHERS THEN
938: asn_debug.put_line('QA Actions Failed: ' || SQLERRM);
939: x_error_message := 'QA_ACTIONS_FAILED';
940: RETURN;
941: END;
942: END IF;

Line 983: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed with return status: ' || l_return_status);

979: , FND_API.G_TRUE
980: );
981:
982: IF l_return_status <> 'S' THEN
983: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed with return status: ' || l_return_status);
984: IF l_msg_count > 0 THEN
985: asn_debug.put_line(l_msg_data);
986: END IF;
987:

Line 985: asn_debug.put_line(l_msg_data);

981:
982: IF l_return_status <> 'S' THEN
983: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed with return status: ' || l_return_status);
984: IF l_msg_count > 0 THEN
985: asn_debug.put_line(l_msg_data);
986: END IF;
987:
988: x_error_message := 'EDR_SEND_ACKN_FAILED';
989: RETURN;

Line 993: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed');

989: RETURN;
990: END IF;
991: EXCEPTION
992: WHEN OTHERS THEN
993: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed');
994: IF l_msg_count > 0 THEN
995: asn_debug.put_line(l_msg_data);
996: END IF;
997:

Line 995: asn_debug.put_line(l_msg_data);

991: EXCEPTION
992: WHEN OTHERS THEN
993: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed');
994: IF l_msg_count > 0 THEN
995: asn_debug.put_line(l_msg_data);
996: END IF;
997:
998: asn_debug.put_line(SQLERRM);
999:

Line 998: asn_debug.put_line(SQLERRM);

994: IF l_msg_count > 0 THEN
995: asn_debug.put_line(l_msg_data);
996: END IF;
997:
998: asn_debug.put_line(SQLERRM);
999:
1000: x_error_message := 'EDR_SEND_ACKN_FAILED';
1001: RETURN;
1002: END;

Line 1009: asn_debug.put_line('Calling CSE post transaction exit');

1005: IF get_product_install_status('CSE') = 'I' THEN
1006: DECLARE
1007: l_return_status VARCHAR2(1);
1008: BEGIN
1009: asn_debug.put_line('Calling CSE post transaction exit');
1010: CSE_RCVTXN_PKG.PostTransaction_Exit
1011: ( l_rt_row.transaction_id
1012: , l_rti_row.interface_transaction_id
1013: , l_return_status

Line 1027: asn_debug.put_line('Performing Common Receiving quality event');

1023: gml_po_for_process.check_po_for_proc;
1024:
1025: IF l_common_receiving THEN
1026: BEGIN
1027: asn_debug.put_line('Performing Common Receiving quality event');
1028: gml_rcv_db_common.raise_quality_event
1029: ( l_rt_row.transaction_id
1030: , l_rti_row.item_id
1031: , l_rti_row.to_organization_id

Line 1039: asn_debug.put_line('Updating PO Note References');

1035: NULL;
1036: END;
1037: END IF;
1038:
1039: asn_debug.put_line('Updating PO Note References');
1040:
1041: DECLARE
1042: l_row_id NUMBER;
1043: BEGIN

Line 1129: asn_debug.put_line('Error while inserting into po_note_references...'||sqlerrm);

1125: AND foreign_id = p_receive_id;
1126: END IF;
1127: EXCEPTION--Bug: 6487371
1128: when others then
1129: asn_debug.put_line('Error while inserting into po_note_references...'||sqlerrm);
1130: x_error_message := substr(sqlerrm,1,200);
1131: RETURN;--Bug: 6487371
1132: END;
1133: EXCEPTION--Bug: 6487371

Line 1135: asn_debug.put_line('Unexpected error occured...'||sqlerrm);

1131: RETURN;--Bug: 6487371
1132: END;
1133: EXCEPTION--Bug: 6487371
1134: when others then
1135: asn_debug.put_line('Unexpected error occured...'||sqlerrm);
1136: x_error_message := substr(sqlerrm,1,200);
1137: RETURN;--Bug: 6487371
1138:
1139: asn_debug.put_line('Done with RVTTHIns');

Line 1139: asn_debug.put_line('Done with RVTTHIns');

1135: asn_debug.put_line('Unexpected error occured...'||sqlerrm);
1136: x_error_message := substr(sqlerrm,1,200);
1137: RETURN;--Bug: 6487371
1138:
1139: asn_debug.put_line('Done with RVTTHIns');
1140: END RVTTHIns;
1141:
1142: END RCV_TRANSACTION_PROCESSOR;