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.ITG_SYNCPOINBOUND_PVT dependencies on FND_API

Line 46: RAISE FND_API.G_EXC_ERROR;

42: END IF;
43: EXCEPTION
44: WHEN NO_DATA_FOUND THEN
45: ITG_MSG.no_po_found(p_po_code, p_org_id);
46: RAISE FND_API.G_EXC_ERROR;
47: END lookup_po_header;
48:
49: PROCEDURE Update_PoLine(
50: x_return_status OUT NOCOPY VARCHAR2,

Line 311: RAISE FND_API.G_EXC_ERROR;

307: /* Added if-else block to check whether Invoice and Inspection qty is more than allowable qty, to fix 4882347 bug*/
308: IF p_doc_type = 'INVOICE' THEN
309: IF ( l_tot_rec_qty - l_tot_bill_qty ) < l_qty THEN
310: ITG_MSG.inv_qty_larg_than_exp;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: ELSIF p_doc_type = 'INSPECTION' THEN
314: IF ( l_tot_rec_qty - l_tot_insp_qty ) < l_qty THEN
315: ITG_MSG.insp_qty_larg_than_exp;

Line 316: RAISE FND_API.G_EXC_ERROR;

312: END IF;
313: ELSIF p_doc_type = 'INSPECTION' THEN
314: IF ( l_tot_rec_qty - l_tot_insp_qty ) < l_qty THEN
315: ITG_MSG.insp_qty_larg_than_exp;
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318: END IF;
319:
320: l_last := -1;

Line 380: RAISE FND_API.G_EXC_ERROR;

376: */
377: IF l_qty < 0 THEN
378: /* Trying to RETURN or CREDIT more than received or billed. */
379: ITG_MSG.allocship_toomany_rtn;
380: RAISE FND_API.G_EXC_ERROR;
381: ELSIF l_qty > 0 THEN
382: ITG_Debug.msg('AALL', 'More quantity', l_qty);
383: /* Still have more? Lets try put those in the last shipment line.
384: * We need to worry about the tolerance level while trying to

Line 391: RAISE FND_API.G_EXC_ERROR;

387: * line.
388: */
389: IF l_last < 0 THEN
390: ITG_MSG.no_line_locs_found;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393: l_tmp := l_lltab(l_last);
394: l_tmp_qty := ROUND(l_base_qty * NVL(l_tmp.qty_rcv_tolerance, 0) / 100);
395:

Line 566: RAISE FND_API.G_EXC_ERROR;

562: /* Trying to distribute a RETURN and more is needed to RETURN than
563: * was initially distributed. This should NOT be able to happen.
564: */
565: ITG_MSG.allocdist_toomany_rtn;
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568:
569: /* Ok time to update the table.. */
570: ITG_Debug.msg('AAD', 'Update po_distributions_all ...');

Line 718: RAISE FND_API.G_EXC_ERROR;

714: /* Trying to distribute a RETURN and more is needed to RETURN than
715: * was initially distributed. This should NOT be able to happen.
716: */
717: ITG_MSG.allocreqn_toomany_rtn;
718: RAISE FND_API.G_EXC_ERROR;
719: END IF;
720:
721: /* Time to update the table */
722: ITG_Debug.msg('ARL', 'Updating po_requisition_lines_all ...');

Line 752: RAISE FND_API.G_EXC_ERROR;

748: ITG_Debug.msg('PRD', 'Entering...');
749: IF p_quantity > 0 AND (l_rec.closed_code = 'CLOSED FOR RECEIVING' OR
750: l_rec.closed_code = 'CLOSED') THEN
751: ITG_MSG.poline_closed_rcv;
752: RAISE FND_API.G_EXC_ERROR;
753: /*Added p_quantiyy < 0 to fix bug 5438268 */
754: ELSIF p_quantity < 0 THEN
755: ITG_MSG.poline_negqty_rcv;
756: RAISE FND_API.G_EXC_ERROR;

Line 756: RAISE FND_API.G_EXC_ERROR;

752: RAISE FND_API.G_EXC_ERROR;
753: /*Added p_quantiyy < 0 to fix bug 5438268 */
754: ELSIF p_quantity < 0 THEN
755: ITG_MSG.poline_negqty_rcv;
756: RAISE FND_API.G_EXC_ERROR;
757: ELSIF p_quantity = 0 THEN
758: ITG_MSG.poline_zeroqty_rcv;
759: RAISE FND_API.G_EXC_ERROR;
760:

Line 759: RAISE FND_API.G_EXC_ERROR;

755: ITG_MSG.poline_negqty_rcv;
756: RAISE FND_API.G_EXC_ERROR;
757: ELSIF p_quantity = 0 THEN
758: ITG_MSG.poline_zeroqty_rcv;
759: RAISE FND_API.G_EXC_ERROR;
760:
761: ELSE
762: /* processReceipt */
763: IF aa_llocs(l_lltab) THEN

Line 765: RAISE FND_API.G_EXC_ERROR;

761: ELSE
762: /* processReceipt */
763: IF aa_llocs(l_lltab) THEN
764: ITG_MSG.receipt_tol_exceeded;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: IF l_release_id IS NULL THEN
769: l_doc_type := 'PO';

Line 823: RAISE FND_API.G_EXC_ERROR;

819: ) THEN
820: ITG_Debug.msg('PRD', 'Close PO failed...');
821: ITG_Debug.msg('PRD', 'return code', l_return_code);
822: ITG_MSG.receipt_closepo_fail(l_return_code);
823: RAISE FND_API.G_EXC_ERROR;
824: ELSE
825: ITG_Debug.msg('PRD', 'Close PO succeded');
826: ITG_Debug.msg('PRD', 'return code', l_return_code);
827: END IF;

Line 843: RAISE FND_API.G_EXC_ERROR;

839: ) THEN
840: ITG_Debug.msg('PRD', 'Close Release failed...');
841: ITG_Debug.msg('PRD', 'return code', l_return_code);
842: ITG_MSG.receipt_closerelease_fail(l_return_code);
843: RAISE FND_API.G_EXC_ERROR;
844: ELSE
845: ITG_Debug.msg('PRD', 'Close Release succeded');
846: ITG_Debug.msg('PRD', 'return code', l_return_code);
847: END IF;

Line 865: RAISE FND_API.G_EXC_ERROR;

861: IF p_quantity > 0 THEN
862: /* processInspection */
863: IF aa_llocs(l_lltab) THEN
864: ITG_MSG.inspect_tol_exceeded;
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:
868: FOR i IN 1 .. l_lltab.count LOOP
869: UPDATE po_line_locations_all

Line 882: RAISE FND_API.G_EXC_ERROR;

878: l_lltab(i).line_location_id);
879: END LOOP;
880: ELSIF p_quantity < 0 THEN
881: ITG_MSG.poline_negqty_ins;
882: RAISE FND_API.G_EXC_ERROR;
883: ELSE
884: ITG_MSG.poline_zeroqty_ins;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;

Line 885: RAISE FND_API.G_EXC_ERROR;

881: ITG_MSG.poline_negqty_ins;
882: RAISE FND_API.G_EXC_ERROR;
883: ELSE
884: ITG_MSG.poline_zeroqty_ins;
885: RAISE FND_API.G_EXC_ERROR;
886: END IF;
887: END process_inspection_doc;
888:
889: /* ~processInvoice */

Line 903: RAISE FND_API.G_EXC_ERROR;

899: g_action := 'processing invoice information';
900: ITG_Debug.msg('PI', 'Entering...');
901: IF p_amount = 0 THEN
902: ITG_MSG.poline_zeroamt_inv;
903: RAISE FND_API.G_EXC_ERROR;
904: ELSIF SIGN(p_quantity) <> SIGN(p_amount) AND
905: SIGN(p_quantity) <> 0 THEN
906: ITG_MSG.poline_badsign_inv;
907: RAISE FND_API.G_EXC_ERROR;

Line 907: RAISE FND_API.G_EXC_ERROR;

903: RAISE FND_API.G_EXC_ERROR;
904: ELSIF SIGN(p_quantity) <> SIGN(p_amount) AND
905: SIGN(p_quantity) <> 0 THEN
906: ITG_MSG.poline_badsign_inv;
907: RAISE FND_API.G_EXC_ERROR;
908: ELSIF l_rec.closed_code = 'CLOSED FOR INVOICE' OR
909: l_rec.closed_code = 'CLOSED' THEN
910: ITG_MSG.poline_closed_inv;
911: RAISE FND_API.G_EXC_ERROR;

Line 911: RAISE FND_API.G_EXC_ERROR;

907: RAISE FND_API.G_EXC_ERROR;
908: ELSIF l_rec.closed_code = 'CLOSED FOR INVOICE' OR
909: l_rec.closed_code = 'CLOSED' THEN
910: ITG_MSG.poline_closed_inv;
911: RAISE FND_API.G_EXC_ERROR;
912: ELSE
913: /* processInvoice */
914: IF aa_llocs(l_lltab) THEN
915: /* If there more stuff to allocate, then we got a problem, send a

Line 919: RAISE FND_API.G_EXC_ERROR;

915: /* If there more stuff to allocate, then we got a problem, send a
916: * message: 'Receipt Tolerance Exceeded'
917: */
918: ITG_MSG.invoice_tol_exceeded;
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921:
922: /* Process the distributions */
923: FOR i IN 1 .. l_lltab.COUNT LOOP

Line 976: RAISE FND_API.G_EXC_ERROR;

972: ) THEN
973: ITG_Debug.msg('PI', 'Close PO failed ...');
974: ITG_Debug.msg('PI', 'return_code', l_return_code);
975: ITG_MSG.invoice_closepo_fail(l_return_code);
976: RAISE FND_API.G_EXC_ERROR;
977: ELSE
978: ITG_Debug.msg('PI', 'Close PO succeded');
979: ITG_Debug.msg('PI', 'return_code', l_return_code);
980: END IF;

Line 996: RAISE FND_API.G_EXC_ERROR;

992: ) THEN
993: ITG_Debug.msg('PI', 'Close Release failed ...');
994: ITG_Debug.msg('PI', 'return_code', l_return_code);
995: ITG_MSG.invoice_closerelease_fail(l_return_code);
996: RAISE FND_API.G_EXC_ERROR;
997: ELSE
998: ITG_Debug.msg('PI', 'Close Release succeded');
999: ITG_Debug.msg('PI', 'return_code', l_return_code);
1000: END IF;

Line 1011: x_return_status := FND_API.G_RET_STS_SUCCESS;

1007: END process_invoice_doc;
1008:
1009: BEGIN
1010: /* Initialize return status */
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012: g_action :='updating PO line';
1013:
1014: BEGIN
1015: SAVEPOINT Update_PoLine_PVT;

Line 1023: RAISE FND_API.G_EXC_ERROR;

1019: MO_GLOBAL.set_policy_context('S', p_org_id); -- MOAC
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: itg_msg.invalid_org(p_org_id);
1023: RAISE FND_API.G_EXC_ERROR;
1024: END;
1025:
1026: ITG_Debug.setup(
1027: p_reset => TRUE,

Line 1044: RAISE FND_API.G_EXC_ERROR;

1040: IF l_doc_typ = 'BLANKET' THEN
1041: -- Release no is a must for blanket PO
1042: itg_debug.msg('UPL','No po line found.');
1043: itg_msg.no_po_line(p_org_id,p_po_code || ':' ||p_release_id,p_line_num);
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046: ELSE
1047: OPEN po_relid_csr(g_po_id,p_org_id,p_release_id);
1048: FETCH po_relid_csr INTO l_release_id;

Line 1053: RAISE FND_API.G_EXC_ERROR;

1049: l_notfound := po_relid_csr%NOTFOUND;
1050: IF l_notfound THEN
1051: itg_debug.msg('UPL','No po line found.');
1052: itg_msg.no_po_line(p_org_id,p_po_code || ':' ||p_release_id,p_line_num);
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: END IF;
1056:
1057: OPEN po_line_csr;

Line 1064: RAISE FND_API.G_EXC_ERROR;

1060: CLOSE po_line_csr;
1061: IF l_notfound THEN
1062: ITG_Debug.msg('UPL', 'No po line found.');
1063: itg_msg.no_po_line(p_org_id,p_po_code || ':' ||p_release_id,p_line_num);
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066:
1067: ITG_Debug.msg('UPL', 'PO Code', p_po_code);
1068: ITG_Debug.msg('UPL', 'Org ID', p_org_id);

Line 1080: RAISE FND_API.G_EXC_ERROR;

1076: ITG_Debug.msg('UPL', 'PO Line Amount', p_amount);
1077:
1078: IF l_rec.closed_code = 'FINALLY CLOSED' THEN
1079: ITG_MSG.poline_closed_final;
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;
1082:
1083: IF upper(p_doc_type) = 'RECEIPT' THEN
1084: process_receipt_doc;

Line 1091: RAISE FND_API.G_EXC_ERROR;

1087: ELSIF upper(p_doc_type) = 'INVOICE' THEN
1088: process_invoice_doc;
1089: ELSE
1090: ITG_MSG.poline_invalid_doctype;
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094: COMMIT WORK;
1095: ITG_Debug.msg('UPL', 'Done.');

Line 1098: WHEN FND_API.G_EXC_ERROR THEN

1094: COMMIT WORK;
1095: ITG_Debug.msg('UPL', 'Done.');
1096:
1097: EXCEPTION
1098: WHEN FND_API.G_EXC_ERROR THEN
1099: ROLLBACK TO Update_PoLine_PVT;
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: ITG_msg.checked_error(g_action);
1102:

Line 1100: x_return_status := FND_API.G_RET_STS_ERROR;

1096:
1097: EXCEPTION
1098: WHEN FND_API.G_EXC_ERROR THEN
1099: ROLLBACK TO Update_PoLine_PVT;
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: ITG_msg.checked_error(g_action);
1102:
1103:
1104: WHEN OTHERS THEN

Line 1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1102:
1103:
1104: WHEN OTHERS THEN
1105: ROLLBACK TO Update_PoLine_PVT;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: itg_debug.msg('Unexpected error (PO sync) - ' || substr(SQLERRM,1,255),true);
1108: ITG_msg.unexpected_error(g_action);
1109: END;
1110: