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 171: asn_debug.put_line('RVTTHIns(p_rti_id:' || p_rti_id

167: l_fob_point number;
168: /*Bug 5517289-End*/
169:
170: BEGIN
171: asn_debug.put_line('RVTTHIns(p_rti_id:' || p_rti_id
172: || ', p_transaction_type: ' || p_transaction_type
173: || ', p_shipment_header_id: ' || p_shipment_header_id
174: || ', p_shipment_line_id: ' || p_shipment_line_id
175: || ', p_primary_unit_of_measure: ' || p_primary_unit_of_measure

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

321: from po_line_locations_archive
322: where line_location_id = l_rti_row.po_line_location_id
323: and nvl(latest_external_flag,'N') = 'Y';
324: --
325: asn_debug.put_line('PO Unit Price from pll_archive :' || l_rt_row.po_unit_price);
326: --
327: end if;
328: exception
329: when others then

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

326: --
327: end if;
328: exception
329: when others then
330: asn_debug.put_line('Fetching from pll_archive failed : ' || SQLERRM);
331: l_rt_row.po_unit_price := NULL;
332: end;
333: --
334: if (l_rt_row.po_unit_price is null) then

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

333: --
334: if (l_rt_row.po_unit_price is null) then
335: l_rt_row.po_unit_price := l_rti_row.po_unit_price;
336: end if;
337: asn_debug.put_line('PO Unit Price is :' || l_rt_row.po_unit_price);
338: --
339: -- Bug 6265149 : End
340:
341: IF l_rti_row.currency_code IS NULL THEN

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

508: OPEN c_fob_point(l_rti_row.from_organization_id,l_rti_row.to_organization_id);
509: FETCH c_fob_point INTO l_fob_point;
510: CLOSE c_fob_point;
511:
512: asn_debug.put_line('FOB Point is :' || l_fob_point);
513:
514: BEGIN
515:
516: IF (l_fob_point = 2) THEN

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

513:
514: BEGIN
515:
516: IF (l_fob_point = 2) THEN
517: asn_debug.put_line('Validating the INV accouting period for Organization :'||l_rti_row.from_organization_id);
518: IF (RCV_TRANSACTION_PROCESSOR.get_acct_period_status(p_trx_date => l_rti_row.transaction_date,
519: p_org_id => l_rti_row.from_organization_id)
520: NOT IN ('O', 'F')) THEN
521: asn_debug.put_line('INV accounting period is not opened for the source organization :'|| l_rti_row.from_organization_id);

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

517: asn_debug.put_line('Validating the INV accouting period for Organization :'||l_rti_row.from_organization_id);
518: IF (RCV_TRANSACTION_PROCESSOR.get_acct_period_status(p_trx_date => l_rti_row.transaction_date,
519: p_org_id => l_rti_row.from_organization_id)
520: NOT IN ('O', 'F')) THEN
521: asn_debug.put_line('INV accounting period is not opened for the source organization :'|| l_rti_row.from_organization_id);
522: x_error_message := 'PO_INV_NO_OPEN_PERIOD';
523: RETURN;
524: END IF;
525: END IF;

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

524: END IF;
525: END IF;
526: EXCEPTION
527: WHEN OTHERS THEN
528: asn_debug.put_line('unexpected error in get_acct_period_status');
529: x_error_message := 'PO_INV_NO_OPEN_PERIOD';
530: RETURN;
531: END;
532: END IF;

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

535: /* Bug 5842219:
536: source_transaction_num provided in the rti table has to be
537: maintained in the rt table. */
538: l_rt_row.source_transaction_num := l_rti_row.source_transaction_num;
539: asn_debug.put_line('source_transaction_num:' || l_rt_row.source_transaction_num);
540:
541: /* lcm changes */
542: l_rt_row.lcm_shipment_line_id := l_rti_row.lcm_shipment_line_id;
543: l_rt_row.unit_landed_cost := l_rti_row.unit_landed_cost;

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

540:
541: /* lcm changes */
542: l_rt_row.lcm_shipment_line_id := l_rti_row.lcm_shipment_line_id;
543: l_rt_row.unit_landed_cost := l_rti_row.unit_landed_cost;
544: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
545: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
546:
547: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
548: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id

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

541: /* lcm changes */
542: l_rt_row.lcm_shipment_line_id := l_rti_row.lcm_shipment_line_id;
543: l_rt_row.unit_landed_cost := l_rti_row.unit_landed_cost;
544: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
545: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
546:
547: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
548: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id
549: || ' parent_transaction_id: ' || l_rt_row.parent_transaction_id

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

543: l_rt_row.unit_landed_cost := l_rti_row.unit_landed_cost;
544: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
545: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
546:
547: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
548: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id
549: || ' parent_transaction_id: ' || l_rt_row.parent_transaction_id
550: || ' interface_transaction_id: ' || l_rt_row.interface_transaction_id
551: || ' group_id: ' || l_rt_row.group_id

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

544: asn_debug.put_line('lcm_shipment_line_id is ' || l_rt_row.lcm_shipment_line_id);
545: asn_debug.put_line('unit_landed_cost is ' || l_rt_row.unit_landed_cost);
546:
547: asn_debug.put_line('Inserting RT row (' || l_rt_row.transaction_type || ')...');
548: asn_debug.put_line('transaction_id: ' || l_rt_row.transaction_id
549: || ' parent_transaction_id: ' || l_rt_row.parent_transaction_id
550: || ' interface_transaction_id: ' || l_rt_row.interface_transaction_id
551: || ' group_id: ' || l_rt_row.group_id
552: || ' request_id: ' || l_rt_row.request_id

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

802: l_rt_row.lcm_shipment_line_id, -- lcm changes
803: l_rt_row.unit_landed_cost); -- lcm changes
804: EXCEPTION --Bug: 6487371
805: when others then
806: asn_debug.put_line('Error occured while inserting into rcv_transactions...'||sqlerrm);
807: x_error_message := substr(sqlerrm,1,200);
808: RETURN;
809: END;--Bug: 6487371
810:

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

810:
811: x_rt_id := l_rt_row.transaction_id;
812:
813: BEGIN
814: asn_debug.put_line('Updating child RTI rows');
815:
816: /* FPJ FASTFORWARD START.
817: * If this rti row is a parent of any rti rows, then
818: * we need to update the parent_transaction_id of

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

833: NULL;
834: END;
835:
836: IF NVL(l_rti_row.qa_collection_id,0) <> 0 THEN
837: asn_debug.put_line('Enabling Quality Inspection Results');
838:
839: DECLARE
840: l_return_status VARCHAR2(1);
841: l_msg_count NUMBER := 0;

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

852: , l_msg_data
853: );
854:
855: IF l_msg_count IS NULL OR l_msg_count = -1 THEN
856: asn_debug.put_line('QA Actions Failed: ' || l_msg_data);
857: x_error_message := 'QA_ACTIONS_FAILED';
858: RETURN;
859: END IF;
860: EXCEPTION

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

858: RETURN;
859: END IF;
860: EXCEPTION
861: WHEN OTHERS THEN
862: asn_debug.put_line('QA Actions Failed: ' || SQLERRM);
863: x_error_message := 'QA_ACTIONS_FAILED';
864: RETURN;
865: END;
866: END IF;

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

903: , FND_API.G_TRUE
904: );
905:
906: IF l_return_status <> 'S' THEN
907: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed with return status: ' || l_return_status);
908: IF l_msg_count > 0 THEN
909: asn_debug.put_line(l_msg_data);
910: END IF;
911:

Line 909: asn_debug.put_line(l_msg_data);

905:
906: IF l_return_status <> 'S' THEN
907: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed with return status: ' || l_return_status);
908: IF l_msg_count > 0 THEN
909: asn_debug.put_line(l_msg_data);
910: END IF;
911:
912: x_error_message := 'EDR_SEND_ACKN_FAILED';
913: RETURN;

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

913: RETURN;
914: END IF;
915: EXCEPTION
916: WHEN OTHERS THEN
917: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed');
918: IF l_msg_count > 0 THEN
919: asn_debug.put_line(l_msg_data);
920: END IF;
921:

Line 919: asn_debug.put_line(l_msg_data);

915: EXCEPTION
916: WHEN OTHERS THEN
917: asn_debug.put_line('QA_EDR_STANDARD.SEND_ACKN failed');
918: IF l_msg_count > 0 THEN
919: asn_debug.put_line(l_msg_data);
920: END IF;
921:
922: asn_debug.put_line(SQLERRM);
923:

Line 922: asn_debug.put_line(SQLERRM);

918: IF l_msg_count > 0 THEN
919: asn_debug.put_line(l_msg_data);
920: END IF;
921:
922: asn_debug.put_line(SQLERRM);
923:
924: x_error_message := 'EDR_SEND_ACKN_FAILED';
925: RETURN;
926: END;

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

929: IF get_product_install_status('CSE') = 'I' THEN
930: DECLARE
931: l_return_status VARCHAR2(1);
932: BEGIN
933: asn_debug.put_line('Calling CSE post transaction exit');
934: CSE_RCVTXN_PKG.PostTransaction_Exit
935: ( l_rt_row.transaction_id
936: , l_rti_row.interface_transaction_id
937: , l_return_status

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

947: gml_po_for_process.check_po_for_proc;
948:
949: IF l_common_receiving THEN
950: BEGIN
951: asn_debug.put_line('Performing Common Receiving quality event');
952: gml_rcv_db_common.raise_quality_event
953: ( l_rt_row.transaction_id
954: , l_rti_row.item_id
955: , l_rti_row.to_organization_id

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

959: NULL;
960: END;
961: END IF;
962:
963: asn_debug.put_line('Updating PO Note References');
964:
965: DECLARE
966: l_row_id NUMBER;
967: BEGIN

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

1049: AND foreign_id = p_receive_id;
1050: END IF;
1051: EXCEPTION--Bug: 6487371
1052: when others then
1053: asn_debug.put_line('Error while inserting into po_note_references...'||sqlerrm);
1054: x_error_message := substr(sqlerrm,1,200);
1055: RETURN;--Bug: 6487371
1056: END;
1057: EXCEPTION--Bug: 6487371

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

1055: RETURN;--Bug: 6487371
1056: END;
1057: EXCEPTION--Bug: 6487371
1058: when others then
1059: asn_debug.put_line('Unexpected error occured...'||sqlerrm);
1060: x_error_message := substr(sqlerrm,1,200);
1061: RETURN;--Bug: 6487371
1062:
1063: asn_debug.put_line('Done with RVTTHIns');

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

1059: asn_debug.put_line('Unexpected error occured...'||sqlerrm);
1060: x_error_message := substr(sqlerrm,1,200);
1061: RETURN;--Bug: 6487371
1062:
1063: asn_debug.put_line('Done with RVTTHIns');
1064: END RVTTHIns;
1065:
1066: END RCV_TRANSACTION_PROCESSOR;