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

Line 88: RAISE FND_API.G_EXC_ERROR;

84: AND ROWNUM < 2;
85: EXCEPTION
86: WHEN OTHERS THEN
87: print_debug('Error while retrieving project and task. SQLCODE:'||SQLCODE||' SQLERRM:'||Sqlerrm,1);
88: RAISE FND_API.G_EXC_ERROR;
89: END ;
90:
91:
92: --Truncate the transaction_date to store only the date part

Line 340: , DECODE(p_rcv_transaction_rec.sec_transaction_quantity, FND_API.G_MISS_NUM, NULL)

336: , p_rcv_transaction_rec.primary_quantity --primary_quantity
337: , p_rcv_transaction_rec.primary_uom --primary_unit_of_measure
338: , g_transfer_uom_code --uom_code
339: -- OPM COnvergence
340: , DECODE(p_rcv_transaction_rec.sec_transaction_quantity, FND_API.G_MISS_NUM, NULL)
341: , p_rcv_transaction_rec.secondary_uom
342: , p_rcv_transaction_rec.secondary_uom_code
343: , p_rcv_transaction_rec.item_id --item_id
344: , p_rcv_transaction_rec.item_revision --item_revision

Line 390: RAISE FND_API.G_EXC_ERROR;

386: );
387: EXCEPTION
388: WHEN OTHERS THEN
389: print_debug('Error inserting into RTI. SQLCODE:'||SQLCODE||' SQLERRM:'||Sqlerrm,1);
390: RAISE FND_API.G_EXC_ERROR;
391: END;
392:
393: IF (l_debug = 1) THEN
394: print_debug('insert_interface_code completed successfully. Generated RTID: ' || l_interface_transaction_id, 4);

Line 474: x_return_status := FND_API.G_RET_STS_SUCCESS;

470: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
471: BEGIN
472:
473: --Initialize the return status to success
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
475:
476: l_progress := 10;
477:
478: IF (l_debug = 1) THEN

Line 668: RAISE FND_API.G_EXC_ERROR;

664: IF (l_interface_txn_id = -9999) THEN
665: IF (l_debug = 1) THEN
666: print_debug('Progress: ' || l_progress || '. Failure in RTI creation for Transfer', 4);
667: END IF;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670: END IF;
671:
672: --Update the lots and serials interface records with the RTID that was

Line 750: WHEN FND_API.G_EXC_ERROR THEN

746: print_debug('***populate_transfer_rti_values completed successfully***', 4);
747: END IF;
748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: fnd_msg_pub.count_and_get (
753: p_encoded => FND_API.G_FALSE
754: , p_count => x_msg_count

Line 751: x_return_status := FND_API.G_RET_STS_ERROR;

747: END IF;
748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: fnd_msg_pub.count_and_get (
753: p_encoded => FND_API.G_FALSE
754: , p_count => x_msg_count
755: , p_data => x_msg_data );

Line 753: p_encoded => FND_API.G_FALSE

749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: fnd_msg_pub.count_and_get (
753: p_encoded => FND_API.G_FALSE
754: , p_count => x_msg_count
755: , p_data => x_msg_data );
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

752: fnd_msg_pub.count_and_get (
753: p_encoded => FND_API.G_FALSE
754: , p_count => x_msg_count
755: , p_data => x_msg_data );
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: fnd_msg_pub.count_and_get (
759: p_encoded => FND_API.G_FALSE
760: , p_count => x_msg_count

Line 757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

753: p_encoded => FND_API.G_FALSE
754: , p_count => x_msg_count
755: , p_data => x_msg_data );
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: fnd_msg_pub.count_and_get (
759: p_encoded => FND_API.G_FALSE
760: , p_count => x_msg_count
761: , p_data => x_msg_data );

Line 759: p_encoded => FND_API.G_FALSE

755: , p_data => x_msg_data );
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: fnd_msg_pub.count_and_get (
759: p_encoded => FND_API.G_FALSE
760: , p_count => x_msg_count
761: , p_data => x_msg_data );
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

759: p_encoded => FND_API.G_FALSE
760: , p_count => x_msg_count
761: , p_data => x_msg_data );
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: fnd_msg_pub.count_and_get (
765: p_encoded => FND_API.G_FALSE
766: , p_count => x_msg_count
767: , p_data => x_msg_data );

Line 765: p_encoded => FND_API.G_FALSE

761: , p_data => x_msg_data );
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: fnd_msg_pub.count_and_get (
765: p_encoded => FND_API.G_FALSE
766: , p_count => x_msg_count
767: , p_data => x_msg_data );
768: IF SQLCODE IS NOT NULL THEN
769: inv_mobile_helper_functions.sql_error (

Line 839: x_return_status := FND_API.G_RET_STS_SUCCESS;

835: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
836:
837: BEGIN
838: --Initizlize the return status to success
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841: l_progress := 10;
842:
843: IF (l_debug = 1) THEN

Line 863: RAISE FND_API.G_EXC_ERROR;

859: print_debug('MOL LPN not matching!!!', 4);
860: END IF;
861: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
862: fnd_msg_pub.add;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865:
866: EXCEPTION
867: WHEN OTHERS THEN

Line 870: RAISE FND_API.G_EXC_ERROR;

866: EXCEPTION
867: WHEN OTHERS THEN
868: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
869: fnd_msg_pub.add;
870: RAISE FND_API.G_EXC_ERROR;
871: END;
872: END IF; --END IF p_lpn_id is NOT NULL
873:
874: l_progress := 20;

Line 894: RAISE FND_API.G_EXC_ERROR;

890: print_debug('Lot Number not matching!!!', 4);
891: END IF;
892: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
893: fnd_msg_pub.add;
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896:
897: EXCEPTION
898: WHEN OTHERS THEN

Line 901: RAISE FND_API.G_EXC_ERROR;

897: EXCEPTION
898: WHEN OTHERS THEN
899: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
900: fnd_msg_pub.add;
901: RAISE FND_API.G_EXC_ERROR;
902: END;
903: END IF; --END IF p_lot_number is NOT NULL
904:
905: l_parent_txn_id := p_parent_txn_id;

Line 967: RAISE FND_API.G_EXC_ERROR;

963: print_debug('get_avail_quantity_to_transfer: There is no quantity available to transfer: ', 4);
964: END IF;
965: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
966: fnd_msg_pub.add;
967: RAISE FND_API.G_EXC_ERROR;
968: ELSIF (p_transfer_quantity > l_rcvqty_txn_uom) THEN
969: IF (l_debug = 1) THEN
970: print_debug('Transfer qty ' || p_transfer_quantity || ' exceeds ' ||
971: ' available quantity ' || l_rcvqty_txn_uom, 4);

Line 975: RAISE FND_API.G_EXC_ERROR;

971: ' available quantity ' || l_rcvqty_txn_uom, 4);
972: END IF;
973: fnd_message.set_name('INV', 'INV_RCV_QTY_OVER_TOLERANCE');
974: fnd_msg_pub.add;
975: RAISE FND_API.G_EXC_ERROR;
976: ELSIF (p_transfer_quantity < l_rcvqty_txn_uom) THEN
977: l_avail_transfer_qty := p_transfer_quantity;
978: ELSE
979: l_avail_transfer_qty := l_rcvqty_txn_uom;

Line 1011: WHEN FND_API.G_EXC_ERROR THEN

1007: print_debug('get_avail_quantity_to_transfer completed successfully', 4);
1008: END IF;
1009:
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: fnd_msg_pub.count_and_get (
1014: p_encoded => FND_API.G_FALSE
1015: , p_count => x_msg_count

Line 1012: x_return_status := FND_API.G_RET_STS_ERROR;

1008: END IF;
1009:
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: fnd_msg_pub.count_and_get (
1014: p_encoded => FND_API.G_FALSE
1015: , p_count => x_msg_count
1016: , p_data => x_msg_data );

Line 1014: p_encoded => FND_API.G_FALSE

1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: fnd_msg_pub.count_and_get (
1014: p_encoded => FND_API.G_FALSE
1015: , p_count => x_msg_count
1016: , p_data => x_msg_data );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: fnd_msg_pub.count_and_get (
1014: p_encoded => FND_API.G_FALSE
1015: , p_count => x_msg_count
1016: , p_data => x_msg_data );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: fnd_msg_pub.count_and_get (
1020: p_encoded => FND_API.G_FALSE
1021: , p_count => x_msg_count

Line 1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1014: p_encoded => FND_API.G_FALSE
1015: , p_count => x_msg_count
1016: , p_data => x_msg_data );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: fnd_msg_pub.count_and_get (
1020: p_encoded => FND_API.G_FALSE
1021: , p_count => x_msg_count
1022: , p_data => x_msg_data );

Line 1020: p_encoded => FND_API.G_FALSE

1016: , p_data => x_msg_data );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: fnd_msg_pub.count_and_get (
1020: p_encoded => FND_API.G_FALSE
1021: , p_count => x_msg_count
1022: , p_data => x_msg_data );
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1020: p_encoded => FND_API.G_FALSE
1021: , p_count => x_msg_count
1022: , p_data => x_msg_data );
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: fnd_msg_pub.count_and_get (
1026: p_encoded => FND_API.G_FALSE
1027: , p_count => x_msg_count
1028: , p_data => x_msg_data );

Line 1026: p_encoded => FND_API.G_FALSE

1022: , p_data => x_msg_data );
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: fnd_msg_pub.count_and_get (
1026: p_encoded => FND_API.G_FALSE
1027: , p_count => x_msg_count
1028: , p_data => x_msg_data );
1029: IF SQLCODE IS NOT NULL THEN
1030: inv_mobile_helper_functions.sql_error (

Line 1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

1235:
1236: BEGIN
1237:
1238: --Initialize the return status to success
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;
1240:
1241: l_progress := 10;
1242:
1243: IF (l_debug = 1) THEN

Line 1305: RAISE FND_API.G_EXC_ERROR;

1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: fnd_message.set_name('INV', 'INV-NO ITEM UOM');
1304: fnd_msg_pub.add;
1305: RAISE FND_API.G_EXC_ERROR;
1306: END;
1307:
1308: l_progress := 30;
1309:

Line 1349: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1345: , p_primary_uom_code => l_primary_uom_code
1346: , x_avail_transfer_qty => l_um_transfer_qty
1347: , x_avail_primary_qty => l_primary_qty);
1348:
1349: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1350: IF (l_debug = 1) THEN
1351: print_debug('Failure in create_po_transfer_rec at progress level '
1352: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
1353: END IF;

Line 1352: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);

1348:
1349: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1350: IF (l_debug = 1) THEN
1351: print_debug('Failure in create_po_transfer_rec at progress level '
1352: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
1353: END IF;
1354: RAISE FND_API.G_EXC_ERROR;
1355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: IF (l_debug = 1) THEN

Line 1354: RAISE FND_API.G_EXC_ERROR;

1350: IF (l_debug = 1) THEN
1351: print_debug('Failure in create_po_transfer_rec at progress level '
1352: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
1353: END IF;
1354: RAISE FND_API.G_EXC_ERROR;
1355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: IF (l_debug = 1) THEN
1357: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1358: || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 1355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1351: print_debug('Failure in create_po_transfer_rec at progress level '
1352: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
1353: END IF;
1354: RAISE FND_API.G_EXC_ERROR;
1355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: IF (l_debug = 1) THEN
1357: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1358: || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);
1359: END IF;

Line 1358: || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);

1354: RAISE FND_API.G_EXC_ERROR;
1355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: IF (l_debug = 1) THEN
1357: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1358: || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);
1359: END IF;
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362:

Line 1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1356: IF (l_debug = 1) THEN
1357: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1358: || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);
1359: END IF;
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362:
1363: /* OPM Convergence. Obtain the seondary available to transfer quantity
1364: using the qty available to transfer in primary uom

Line 1419: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1415: , p_lpn_id => p_lpn_id
1416: , p_transfer_lpn_id => p_transfer_lpn_id
1417: , p_doc_type => 'PO');
1418:
1419: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1420: IF (l_debug = 1) THEN
1421: print_debug('Failure in create_po_transfer_rec at progress level '
1422: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1423: END IF;

Line 1422: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);

1418:
1419: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1420: IF (l_debug = 1) THEN
1421: print_debug('Failure in create_po_transfer_rec at progress level '
1422: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1423: END IF;
1424: RAISE FND_API.G_EXC_ERROR;
1425: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: IF (l_debug = 1) THEN

Line 1424: RAISE FND_API.G_EXC_ERROR;

1420: IF (l_debug = 1) THEN
1421: print_debug('Failure in create_po_transfer_rec at progress level '
1422: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1423: END IF;
1424: RAISE FND_API.G_EXC_ERROR;
1425: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: IF (l_debug = 1) THEN
1427: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1428: || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 1425: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1421: print_debug('Failure in create_po_transfer_rec at progress level '
1422: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1423: END IF;
1424: RAISE FND_API.G_EXC_ERROR;
1425: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: IF (l_debug = 1) THEN
1427: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1428: || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
1429: END IF;

Line 1428: || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);

1424: RAISE FND_API.G_EXC_ERROR;
1425: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: IF (l_debug = 1) THEN
1427: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1428: || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
1429: END IF;
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: END IF;
1432:

Line 1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1426: IF (l_debug = 1) THEN
1427: print_debug('Failure in create_po_transfer_rec at progress level ' || l_progress
1428: || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
1429: END IF;
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: END IF;
1432:
1433: l_progress := 70;
1434: IF (l_debug = 1) THEN

Line 1439: WHEN FND_API.G_EXC_ERROR THEN

1435: print_debug('***create_po_transfer_rec completed successfully***', 4);
1436: END IF;
1437:
1438: EXCEPTION
1439: WHEN FND_API.G_EXC_ERROR THEN
1440: print_debug('Exception in create_po_transfer_rec ', 4);
1441: IF c_rcvtxn_detail%ISOPEN THEN
1442: CLOSE c_rcvtxn_detail;
1443: END IF;

Line 1444: x_return_status := FND_API.G_RET_STS_ERROR;

1440: print_debug('Exception in create_po_transfer_rec ', 4);
1441: IF c_rcvtxn_detail%ISOPEN THEN
1442: CLOSE c_rcvtxn_detail;
1443: END IF;
1444: x_return_status := FND_API.G_RET_STS_ERROR;
1445: fnd_msg_pub.count_and_get (
1446: p_encoded => FND_API.G_FALSE
1447: , p_count => x_msg_count
1448: , p_data => x_msg_data );

Line 1446: p_encoded => FND_API.G_FALSE

1442: CLOSE c_rcvtxn_detail;
1443: END IF;
1444: x_return_status := FND_API.G_RET_STS_ERROR;
1445: fnd_msg_pub.count_and_get (
1446: p_encoded => FND_API.G_FALSE
1447: , p_count => x_msg_count
1448: , p_data => x_msg_data );
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: print_debug('Unexpected Exception in create_po_transfer_rec ', 4);

Line 1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1445: fnd_msg_pub.count_and_get (
1446: p_encoded => FND_API.G_FALSE
1447: , p_count => x_msg_count
1448: , p_data => x_msg_data );
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: print_debug('Unexpected Exception in create_po_transfer_rec ', 4);
1451: IF c_rcvtxn_detail%ISOPEN THEN
1452: CLOSE c_rcvtxn_detail;
1453: END IF;

Line 1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1450: print_debug('Unexpected Exception in create_po_transfer_rec ', 4);
1451: IF c_rcvtxn_detail%ISOPEN THEN
1452: CLOSE c_rcvtxn_detail;
1453: END IF;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: fnd_msg_pub.count_and_get (
1456: p_encoded => FND_API.G_FALSE
1457: , p_count => x_msg_count
1458: , p_data => x_msg_data );

Line 1456: p_encoded => FND_API.G_FALSE

1452: CLOSE c_rcvtxn_detail;
1453: END IF;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: fnd_msg_pub.count_and_get (
1456: p_encoded => FND_API.G_FALSE
1457: , p_count => x_msg_count
1458: , p_data => x_msg_data );
1459: WHEN OTHERS THEN
1460: print_debug('Other Exception in create_po_transfer_rec '||SQLERRM, 4);

Line 1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1460: print_debug('Other Exception in create_po_transfer_rec '||SQLERRM, 4);
1461: IF c_rcvtxn_detail%ISOPEN THEN
1462: CLOSE c_rcvtxn_detail;
1463: END IF;
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: fnd_msg_pub.count_and_get (
1466: p_encoded => FND_API.G_FALSE
1467: , p_count => x_msg_count
1468: , p_data => x_msg_data );

Line 1466: p_encoded => FND_API.G_FALSE

1462: CLOSE c_rcvtxn_detail;
1463: END IF;
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: fnd_msg_pub.count_and_get (
1466: p_encoded => FND_API.G_FALSE
1467: , p_count => x_msg_count
1468: , p_data => x_msg_data );
1469: IF SQLCODE IS NOT NULL THEN
1470: inv_mobile_helper_functions.sql_error (

Line 1670: x_return_status := FND_API.G_RET_STS_SUCCESS;

1666:
1667: l_progress := 10;
1668:
1669: --Initialize the return status to success
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;
1671:
1672: IF (l_debug = 1) THEN
1673: print_debug('Entered create_int_ship_transfer_rec: ' || l_progress || ' ' ||
1674: TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 3);

Line 1728: RAISE FND_API.G_EXC_ERROR;

1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: fnd_message.set_name('INV', 'INV-NO ITEM UOM');
1727: fnd_msg_pub.add;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END;
1730:
1731: l_progress := 30;
1732:

Line 1771: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1767: , p_primary_uom_code => l_primary_uom_code
1768: , x_avail_transfer_qty => l_um_transfer_qty
1769: , x_avail_primary_qty => l_primary_qty);
1770:
1771: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1772: IF (l_debug = 1) THEN
1773: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1774: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_ERROR', 9);
1775: END IF;

Line 1774: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_ERROR', 9);

1770:
1771: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1772: IF (l_debug = 1) THEN
1773: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1774: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_ERROR', 9);
1775: END IF;
1776: RAISE FND_API.G_EXC_ERROR;
1777: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1778: IF (l_debug = 1) THEN

Line 1776: RAISE FND_API.G_EXC_ERROR;

1772: IF (l_debug = 1) THEN
1773: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1774: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_ERROR', 9);
1775: END IF;
1776: RAISE FND_API.G_EXC_ERROR;
1777: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1778: IF (l_debug = 1) THEN
1779: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1780: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_UNEXPECTED_ERROR', 4);

Line 1777: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1773: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1774: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_ERROR', 9);
1775: END IF;
1776: RAISE FND_API.G_EXC_ERROR;
1777: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1778: IF (l_debug = 1) THEN
1779: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1780: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_UNEXPECTED_ERROR', 4);
1781: END IF;

Line 1780: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_UNEXPECTED_ERROR', 4);

1776: RAISE FND_API.G_EXC_ERROR;
1777: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1778: IF (l_debug = 1) THEN
1779: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1780: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_UNEXPECTED_ERROR', 4);
1781: END IF;
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: END IF;
1784:

Line 1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1778: IF (l_debug = 1) THEN
1779: print_debug('Failure in create_int_ship_transfer_rec at progress: ' ||
1780: l_progress || '. get_avail_quantity_to_transfer returned FND_API.G_EXC_UNEXPECTED_ERROR', 4);
1781: END IF;
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783: END IF;
1784:
1785: /* OPM Convergence. Obtain the seondary available to transfer quantity
1786: using the qty available to transfer in primary uom

Line 1838: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1834: , p_lpn_id => p_lpn_id
1835: , p_transfer_lpn_id => p_transfer_lpn_id
1836: , p_doc_type => 'INTSHIP');
1837:
1838: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1839: IF (l_debug = 1) THEN
1840: print_debug('Failure in create_int_ship_transfer_rec at progress level '
1841: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1842: END IF;

Line 1841: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);

1837:
1838: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1839: IF (l_debug = 1) THEN
1840: print_debug('Failure in create_int_ship_transfer_rec at progress level '
1841: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1842: END IF;
1843: RAISE FND_API.G_EXC_ERROR;
1844: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1845: IF (l_debug = 1) THEN

Line 1843: RAISE FND_API.G_EXC_ERROR;

1839: IF (l_debug = 1) THEN
1840: print_debug('Failure in create_int_ship_transfer_rec at progress level '
1841: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1842: END IF;
1843: RAISE FND_API.G_EXC_ERROR;
1844: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1845: IF (l_debug = 1) THEN
1846: print_debug('Failure in create_int_ship_transfer_rec at progress level '
1847: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 1844: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1840: print_debug('Failure in create_int_ship_transfer_rec at progress level '
1841: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
1842: END IF;
1843: RAISE FND_API.G_EXC_ERROR;
1844: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1845: IF (l_debug = 1) THEN
1846: print_debug('Failure in create_int_ship_transfer_rec at progress level '
1847: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
1848: END IF;

Line 1847: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);

1843: RAISE FND_API.G_EXC_ERROR;
1844: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1845: IF (l_debug = 1) THEN
1846: print_debug('Failure in create_int_ship_transfer_rec at progress level '
1847: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
1848: END IF;
1849: END IF;
1850:
1851: l_progress := 60;

Line 1858: WHEN FND_API.G_EXC_ERROR THEN

1854: print_debug('***create_int_ship_transfer_rec completed succesfully ***', 4);
1855: END IF;
1856:
1857: EXCEPTION
1858: WHEN FND_API.G_EXC_ERROR THEN
1859: IF c_rcvtxn_detail%ISOPEN THEN
1860: CLOSE c_rcvtxn_detail;
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1862: x_return_status := FND_API.G_RET_STS_ERROR;

1858: WHEN FND_API.G_EXC_ERROR THEN
1859: IF c_rcvtxn_detail%ISOPEN THEN
1860: CLOSE c_rcvtxn_detail;
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: fnd_msg_pub.count_and_get (
1864: p_encoded => FND_API.G_FALSE
1865: , p_count => x_msg_count
1866: , p_data => x_msg_data );

Line 1864: p_encoded => FND_API.G_FALSE

1860: CLOSE c_rcvtxn_detail;
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: fnd_msg_pub.count_and_get (
1864: p_encoded => FND_API.G_FALSE
1865: , p_count => x_msg_count
1866: , p_data => x_msg_data );
1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1868: IF c_rcvtxn_detail%ISOPEN THEN

Line 1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1863: fnd_msg_pub.count_and_get (
1864: p_encoded => FND_API.G_FALSE
1865: , p_count => x_msg_count
1866: , p_data => x_msg_data );
1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1868: IF c_rcvtxn_detail%ISOPEN THEN
1869: CLOSE c_rcvtxn_detail;
1870: END IF;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1868: IF c_rcvtxn_detail%ISOPEN THEN
1869: CLOSE c_rcvtxn_detail;
1870: END IF;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: fnd_msg_pub.count_and_get (
1873: p_encoded => FND_API.G_FALSE
1874: , p_count => x_msg_count
1875: , p_data => x_msg_data );

Line 1873: p_encoded => FND_API.G_FALSE

1869: CLOSE c_rcvtxn_detail;
1870: END IF;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: fnd_msg_pub.count_and_get (
1873: p_encoded => FND_API.G_FALSE
1874: , p_count => x_msg_count
1875: , p_data => x_msg_data );
1876: WHEN OTHERS THEN
1877: IF c_rcvtxn_detail%ISOPEN THEN

Line 1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1876: WHEN OTHERS THEN
1877: IF c_rcvtxn_detail%ISOPEN THEN
1878: CLOSE c_rcvtxn_detail;
1879: END IF;
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1881: fnd_msg_pub.count_and_get (
1882: p_encoded => FND_API.G_FALSE
1883: , p_count => x_msg_count
1884: , p_data => x_msg_data );

Line 1882: p_encoded => FND_API.G_FALSE

1878: CLOSE c_rcvtxn_detail;
1879: END IF;
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1881: fnd_msg_pub.count_and_get (
1882: p_encoded => FND_API.G_FALSE
1883: , p_count => x_msg_count
1884: , p_data => x_msg_data );
1885: IF SQLCODE IS NOT NULL THEN
1886: inv_mobile_helper_functions.sql_error (

Line 2086: x_return_status := FND_API.G_RET_STS_SUCCESS;

2082:
2083: BEGIN
2084:
2085: --Initialize the return status to succes
2086: x_return_status := FND_API.G_RET_STS_SUCCESS;
2087:
2088: l_progress := 10;
2089:
2090: IF (l_debug = 1) THEN

Line 2146: RAISE FND_API.G_EXC_ERROR;

2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: fnd_message.set_name('INV', 'INV-NO ITEM UOM');
2145: fnd_msg_pub.add;
2146: RAISE FND_API.G_EXC_ERROR;
2147: END;
2148:
2149: l_progress := 30;
2150:

Line 2190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2186: , p_primary_uom_code => l_primary_uom_code
2187: , x_avail_transfer_qty => l_um_transfer_qty
2188: , x_avail_primary_qty => l_primary_qty);
2189:
2190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF (l_debug = 1) THEN
2192: print_debug('Failure in create_rma_transfer_rec at progress level '
2193: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
2194: END IF;

Line 2193: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);

2189:
2190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF (l_debug = 1) THEN
2192: print_debug('Failure in create_rma_transfer_rec at progress level '
2193: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
2194: END IF;
2195: RAISE FND_API.G_EXC_ERROR;
2196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: IF (l_debug = 1) THEN

Line 2195: RAISE FND_API.G_EXC_ERROR;

2191: IF (l_debug = 1) THEN
2192: print_debug('Failure in create_rma_transfer_rec at progress level '
2193: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
2194: END IF;
2195: RAISE FND_API.G_EXC_ERROR;
2196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: IF (l_debug = 1) THEN
2198: print_debug('Failure in create_rma_transfer_rec at progress level '
2199: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 2196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2192: print_debug('Failure in create_rma_transfer_rec at progress level '
2193: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_ERROR', 4);
2194: END IF;
2195: RAISE FND_API.G_EXC_ERROR;
2196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: IF (l_debug = 1) THEN
2198: print_debug('Failure in create_rma_transfer_rec at progress level '
2199: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);
2200: END IF;

Line 2199: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);

2195: RAISE FND_API.G_EXC_ERROR;
2196: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2197: IF (l_debug = 1) THEN
2198: print_debug('Failure in create_rma_transfer_rec at progress level '
2199: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);
2200: END IF;
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203: /* OPM Convergence. Obtain the seondary available to transfer quantity

Line 2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2197: IF (l_debug = 1) THEN
2198: print_debug('Failure in create_rma_transfer_rec at progress level '
2199: || l_progress || ' . get_avail_quantity_to_transfer raised FND_API.G_EXC_UNEXP_ERROR', 4);
2200: END IF;
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203: /* OPM Convergence. Obtain the seondary available to transfer quantity
2204: using the qty available to transfer in primary uom
2205: */

Line 2257: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2253: , p_lpn_id => p_lpn_id
2254: , p_transfer_lpn_id => p_transfer_lpn_id
2255: , p_doc_type => 'RMA');
2256:
2257: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2258: IF (l_debug = 1) THEN
2259: print_debug('Failure in create_rma_transfer_rec at progress level '
2260: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
2261: END IF;

Line 2260: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);

2256:
2257: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2258: IF (l_debug = 1) THEN
2259: print_debug('Failure in create_rma_transfer_rec at progress level '
2260: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
2261: END IF;
2262: RAISE FND_API.G_EXC_ERROR;
2263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2264: IF (l_debug = 1) THEN

Line 2262: RAISE FND_API.G_EXC_ERROR;

2258: IF (l_debug = 1) THEN
2259: print_debug('Failure in create_rma_transfer_rec at progress level '
2260: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
2261: END IF;
2262: RAISE FND_API.G_EXC_ERROR;
2263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2264: IF (l_debug = 1) THEN
2265: print_debug('Failure in create_rma_transfer_rec at progress level '
2266: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 2263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2259: print_debug('Failure in create_rma_transfer_rec at progress level '
2260: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_ERROR', 4);
2261: END IF;
2262: RAISE FND_API.G_EXC_ERROR;
2263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2264: IF (l_debug = 1) THEN
2265: print_debug('Failure in create_rma_transfer_rec at progress level '
2266: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
2267: END IF;

Line 2266: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);

2262: RAISE FND_API.G_EXC_ERROR;
2263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2264: IF (l_debug = 1) THEN
2265: print_debug('Failure in create_rma_transfer_rec at progress level '
2266: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
2267: END IF;
2268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2269: END IF;
2270:

Line 2268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2264: IF (l_debug = 1) THEN
2265: print_debug('Failure in create_rma_transfer_rec at progress level '
2266: || l_progress || ' . populate_transfer_rti_values raised FND_API.G_EXC_UNEXP_ERROR', 4);
2267: END IF;
2268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2269: END IF;
2270:
2271: l_progress := 70;
2272: IF (l_debug = 1) THEN

Line 2277: WHEN FND_API.G_EXC_ERROR THEN

2273: print_debug('***create_rma_transfer_rec completed successfully***', 4);
2274: END IF;
2275:
2276: EXCEPTION
2277: WHEN FND_API.G_EXC_ERROR THEN
2278: IF c_rcvtxn_detail%ISOPEN THEN
2279: CLOSE c_rcvtxn_detail;
2280: END IF;
2281: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2281: x_return_status := FND_API.G_RET_STS_ERROR;

2277: WHEN FND_API.G_EXC_ERROR THEN
2278: IF c_rcvtxn_detail%ISOPEN THEN
2279: CLOSE c_rcvtxn_detail;
2280: END IF;
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282: fnd_msg_pub.count_and_get (
2283: p_encoded => FND_API.G_FALSE
2284: , p_count => x_msg_count
2285: , p_data => x_msg_data );

Line 2283: p_encoded => FND_API.G_FALSE

2279: CLOSE c_rcvtxn_detail;
2280: END IF;
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282: fnd_msg_pub.count_and_get (
2283: p_encoded => FND_API.G_FALSE
2284: , p_count => x_msg_count
2285: , p_data => x_msg_data );
2286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2287: IF c_rcvtxn_detail%ISOPEN THEN

Line 2286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2282: fnd_msg_pub.count_and_get (
2283: p_encoded => FND_API.G_FALSE
2284: , p_count => x_msg_count
2285: , p_data => x_msg_data );
2286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2287: IF c_rcvtxn_detail%ISOPEN THEN
2288: CLOSE c_rcvtxn_detail;
2289: END IF;
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2287: IF c_rcvtxn_detail%ISOPEN THEN
2288: CLOSE c_rcvtxn_detail;
2289: END IF;
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2291: fnd_msg_pub.count_and_get (
2292: p_encoded => FND_API.G_FALSE
2293: , p_count => x_msg_count
2294: , p_data => x_msg_data );

Line 2292: p_encoded => FND_API.G_FALSE

2288: CLOSE c_rcvtxn_detail;
2289: END IF;
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2291: fnd_msg_pub.count_and_get (
2292: p_encoded => FND_API.G_FALSE
2293: , p_count => x_msg_count
2294: , p_data => x_msg_data );
2295: WHEN OTHERS THEN
2296: IF c_rcvtxn_detail%ISOPEN THEN

Line 2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2295: WHEN OTHERS THEN
2296: IF c_rcvtxn_detail%ISOPEN THEN
2297: CLOSE c_rcvtxn_detail;
2298: END IF;
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2300: fnd_msg_pub.count_and_get (
2301: p_encoded => FND_API.G_FALSE
2302: , p_count => x_msg_count
2303: , p_data => x_msg_data );

Line 2301: p_encoded => FND_API.G_FALSE

2297: CLOSE c_rcvtxn_detail;
2298: END IF;
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2300: fnd_msg_pub.count_and_get (
2301: p_encoded => FND_API.G_FALSE
2302: , p_count => x_msg_count
2303: , p_data => x_msg_data );
2304: IF SQLCODE IS NOT NULL THEN
2305: inv_mobile_helper_functions.sql_error (

Line 2392: x_return_status := FND_API.G_RET_STS_SUCCESS;

2388:
2389: BEGIN
2390:
2391: --Initialize the return status
2392: x_return_status := FND_API.G_RET_STS_SUCCESS;
2393:
2394: IF (l_debug = 1) THEN
2395: print_debug('Entered create_transfer_rcvtxn_rec 10: ' ||
2396: to_char(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 2457: RAISE FND_API.G_EXC_ERROR;

2453: END IF;
2454: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2455: fnd_msg_pub.add;
2456:
2457: RAISE FND_API.G_EXC_ERROR;
2458: END;
2459:
2460: --First check if the transaction date satisfies the validation.
2461: --If the transaction date is invalid then error out the transaction

Line 2482: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2478: , x_return_status => x_return_status
2479: , x_error_code => l_message
2480: );
2481:
2482: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2483: RETURN;
2484: END IF;
2485:
2486: l_progress := 20;

Line 2528: RAISE fnd_api.g_exc_error;

2524: IF (l_debug = 1) THEN
2525: print_debug('create_transfer_rcvtxn_rec 20: Error retrieving po info.',1);
2526: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||Sqlerrm,1);
2527: END IF;
2528: RAISE fnd_api.g_exc_error;
2529: END;
2530:
2531: IF (l_debug = 1) THEN
2532: print_debug('Current Progress: ' || l_progress || '. Calling create_po_transfer_rec', 4);

Line 2562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2558: , p_sec_transfer_quantity => p_sec_transfer_quantity --OPM Convergence
2559: , p_sec_transfer_uom_code => l_sec_uom_code ); --OPM Convergence
2560:
2561: --Check the return status
2562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2563: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL');
2564: fnd_msg_pub.add;
2565:
2566: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2566: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2563: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL');
2564: fnd_msg_pub.add;
2565:
2566: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2567: IF (l_debug = 1) THEN
2568: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2569: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2570: END IF;

Line 2569: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_ERROR', 4);

2565:
2566: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2567: IF (l_debug = 1) THEN
2568: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2569: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2570: END IF;
2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2573: IF (l_debug = 1) THEN

Line 2571: RAISE FND_API.G_EXC_ERROR;

2567: IF (l_debug = 1) THEN
2568: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2569: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2570: END IF;
2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2573: IF (l_debug = 1) THEN
2574: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2575: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 2572: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2568: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2569: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2570: END IF;
2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2573: IF (l_debug = 1) THEN
2574: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2575: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2576: END IF;

Line 2575: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);

2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2573: IF (l_debug = 1) THEN
2574: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2575: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2576: END IF;
2577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2578: END IF;
2579: END IF; --END IF check return status

Line 2577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2573: IF (l_debug = 1) THEN
2574: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2575: || l_progress || ' . create_po_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2576: END IF;
2577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2578: END IF;
2579: END IF; --END IF check return status
2580:
2581: IF l_debug = 1 THEN

Line 2630: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2626: , p_sec_transfer_quantity => p_sec_transfer_quantity --OPM Convergence
2627: , p_sec_transfer_uom_code => l_sec_uom_code ); --OPM Convergence
2628:
2629: --Check the return status
2630: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2631: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL');
2632: fnd_msg_pub.add;
2633:
2634: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2634: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2630: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2631: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL');
2632: fnd_msg_pub.add;
2633:
2634: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2635: IF (l_debug = 1) THEN
2636: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2637: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2638: END IF;

Line 2637: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_ERROR', 4);

2633:
2634: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2635: IF (l_debug = 1) THEN
2636: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2637: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2638: END IF;
2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2641: IF (l_debug = 1) THEN

Line 2639: RAISE FND_API.G_EXC_ERROR;

2635: IF (l_debug = 1) THEN
2636: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2637: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2638: END IF;
2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2641: IF (l_debug = 1) THEN
2642: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2643: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 2640: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2636: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2637: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2638: END IF;
2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2641: IF (l_debug = 1) THEN
2642: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2643: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2644: END IF;

Line 2643: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);

2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2641: IF (l_debug = 1) THEN
2642: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2643: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2644: END IF;
2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2646: END IF;
2647: END IF; --END IF check return status

Line 2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2641: IF (l_debug = 1) THEN
2642: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2643: || l_progress || ' . create_int_ship_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2644: END IF;
2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2646: END IF;
2647: END IF; --END IF check return status
2648:
2649: IF l_debug = 1 THEN

Line 2693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2689: , p_sec_transfer_quantity => p_sec_transfer_quantity --OPM Convergence
2690: , p_sec_transfer_uom_code => l_sec_uom_code ); --OPM Convergence
2691:
2692: --Check the return status
2693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2694: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL');
2695: fnd_msg_pub.add;
2696:
2697: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2697: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2694: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL');
2695: fnd_msg_pub.add;
2696:
2697: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2698: IF (l_debug = 1) THEN
2699: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2700: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2701: END IF;

Line 2700: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_ERROR', 4);

2696:
2697: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2698: IF (l_debug = 1) THEN
2699: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2700: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2701: END IF;
2702: RAISE FND_API.G_EXC_ERROR;
2703: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2704: IF (l_debug = 1) THEN

Line 2702: RAISE FND_API.G_EXC_ERROR;

2698: IF (l_debug = 1) THEN
2699: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2700: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2701: END IF;
2702: RAISE FND_API.G_EXC_ERROR;
2703: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2704: IF (l_debug = 1) THEN
2705: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2706: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);

Line 2703: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2699: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2700: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_ERROR', 4);
2701: END IF;
2702: RAISE FND_API.G_EXC_ERROR;
2703: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2704: IF (l_debug = 1) THEN
2705: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2706: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2707: END IF;

Line 2706: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);

2702: RAISE FND_API.G_EXC_ERROR;
2703: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2704: IF (l_debug = 1) THEN
2705: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2706: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2707: END IF;
2708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2709: END IF;
2710: END IF; --END IF check return status

Line 2708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2704: IF (l_debug = 1) THEN
2705: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '
2706: || l_progress || ' . create_rma_transfer_rec raised FND_API.G_EXC_UNEXP_ERROR', 4);
2707: END IF;
2708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2709: END IF;
2710: END IF; --END IF check return status
2711:
2712: IF l_debug = 1 THEN

Line 2722: RAISE FND_API.G_EXC_ERROR;

2718: print_debug('Failed at : ' || l_progress || ' . Invalid Reference passed : '
2719: || p_reference_type_code, 4);
2720: fnd_message.set_name('INV', 'INV-BAD SOURCE TYPE');
2721: fnd_msg_pub.add;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:
2725: l_progress := 60;
2726:

Line 2733: WHEN FND_API.G_EXC_ERROR THEN

2729: ' . :-) create_transfer_rcvtxn_rec completed successfully! :-)', 4);
2730: END IF;
2731:
2732: EXCEPTION
2733: WHEN FND_API.G_EXC_ERROR THEN
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: fnd_msg_pub.count_and_get (
2736: p_encoded => FND_API.G_FALSE
2737: , p_count => x_msg_count

Line 2734: x_return_status := FND_API.G_RET_STS_ERROR;

2730: END IF;
2731:
2732: EXCEPTION
2733: WHEN FND_API.G_EXC_ERROR THEN
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: fnd_msg_pub.count_and_get (
2736: p_encoded => FND_API.G_FALSE
2737: , p_count => x_msg_count
2738: , p_data => x_msg_data );

Line 2736: p_encoded => FND_API.G_FALSE

2732: EXCEPTION
2733: WHEN FND_API.G_EXC_ERROR THEN
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: fnd_msg_pub.count_and_get (
2736: p_encoded => FND_API.G_FALSE
2737: , p_count => x_msg_count
2738: , p_data => x_msg_data );
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2735: fnd_msg_pub.count_and_get (
2736: p_encoded => FND_API.G_FALSE
2737: , p_count => x_msg_count
2738: , p_data => x_msg_data );
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: fnd_msg_pub.count_and_get (
2742: p_encoded => FND_API.G_FALSE
2743: , p_count => x_msg_count

Line 2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2736: p_encoded => FND_API.G_FALSE
2737: , p_count => x_msg_count
2738: , p_data => x_msg_data );
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: fnd_msg_pub.count_and_get (
2742: p_encoded => FND_API.G_FALSE
2743: , p_count => x_msg_count
2744: , p_data => x_msg_data );

Line 2742: p_encoded => FND_API.G_FALSE

2738: , p_data => x_msg_data );
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: fnd_msg_pub.count_and_get (
2742: p_encoded => FND_API.G_FALSE
2743: , p_count => x_msg_count
2744: , p_data => x_msg_data );
2745: WHEN OTHERS THEN
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2742: p_encoded => FND_API.G_FALSE
2743: , p_count => x_msg_count
2744: , p_data => x_msg_data );
2745: WHEN OTHERS THEN
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: fnd_msg_pub.count_and_get (
2748: p_encoded => FND_API.G_FALSE
2749: , p_count => x_msg_count
2750: , p_data => x_msg_data );

Line 2748: p_encoded => FND_API.G_FALSE

2744: , p_data => x_msg_data );
2745: WHEN OTHERS THEN
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: fnd_msg_pub.count_and_get (
2748: p_encoded => FND_API.G_FALSE
2749: , p_count => x_msg_count
2750: , p_data => x_msg_data );
2751: IF SQLCODE IS NOT NULL THEN
2752: inv_mobile_helper_functions.sql_error (

Line 2839: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2835: ,x_msg_data => l_msg_data
2836: ,p_sec_qty => p_secondary_quantity
2837: );
2838:
2839: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2840: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
2841: IF (l_debug = 1) THEN
2842: print_debug('insert_mtli_helper: Error occurred while creating interface lots: ' || l_msg_data,1);
2843: END IF;

Line 2916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2912: , p_product_code => l_prod_code
2913: , p_att_exist => l_yes
2914: , p_update_msn => l_no);
2915:
2916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2917: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
2918: IF (l_debug = 1) THEN
2919: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
2920: END IF;

Line 3160: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;

3156: l_result Boolean;
3157: l_reference VARCHAR2(240);
3158: l_reference_type_code NUMBER;
3159: l_reference_id NUMBER;
3160: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;
3161: l_msg_count NUMBER;
3162: l_msg_data VARCHAR2(4000);
3163: L_matched_index NUMBER;
3164: l_ser_txn_temp_id NUMBER;

Line 3204: x_return_status := FND_API.G_RET_STS_SUCCESS;

3200:
3201: BEGIN
3202:
3203: --Initialize the return status
3204: x_return_status := FND_API.G_RET_STS_SUCCESS;
3205:
3206: SAVEPOINT match_rti_ss;
3207:
3208: IF (l_debug = 1) THEN

Line 3431: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3427: print_debug('Returned from split_mmtt',1);
3428: print_debug('x_return_status: '||l_return_status,1);
3429: END IF;
3430:
3431: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3432: IF (l_debug = 1) THEN
3433: print_debug('x_msg_data: '||l_msg_data,1);
3434: print_debug('x_msg_count: '||l_msg_count,1);
3435: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);

Line 3439: RAISE fnd_api.g_exc_unexpected_error;

3435: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);
3436: print_debug('Raising Exception!!!',1);
3437: END IF;
3438: l_progress := '@@@';
3439: RAISE fnd_api.g_exc_unexpected_error;
3440: END IF;
3441: END IF;--END IF (p_original_temp_id IS NOT NULL) THEN
3442:
3443: IF (p_lot_control_code = 2) THEN

Line 3480: , p_init_msg_lst => FND_API.G_FALSE

3476: END IF;
3477:
3478: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial
3479: (p_api_version => 1.0
3480: , p_init_msg_lst => FND_API.G_FALSE
3481: , x_return_status => l_return_status
3482: , x_msg_count => l_msg_count
3483: , x_msg_data => l_msg_data
3484: , p_new_rti_info => l_new_rti_info);

Line 3495: RAISE FND_API.G_EXC_ERROR;

3491: IF ( NOT l_split_lot_serial_ok) THEN
3492: IF (l_debug = 1) THEN
3493: print_debug(' MATCH_TRANSFER_INTF_REC: Failure in split_lot_serial ', 4);
3494: END IF;
3495: RAISE FND_API.G_EXC_ERROR;
3496: END IF;
3497: END IF;
3498:
3499: ELSE

Line 3548: RAISE fnd_api.g_exc_error;

3544: print_debug('REFERENCE INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
3545: END IF;
3546: fnd_message.set_name('INV', 'INV_FAILED');
3547: fnd_msg_pub.ADD;
3548: RAISE fnd_api.g_exc_error;
3549: END IF;
3550:
3551: IF (l_debug = 1) THEN
3552: print_debug('REFERENCE = '||L_REFERENCE , 1);

Line 3606: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3602: IF (l_debug = 1) THEN
3603: print_debug('AFTER CALLING THE TRANSFER API: STATUS = '|| l_return_status, 1);
3604: END IF;
3605:
3606: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3607: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3608: fnd_msg_pub.ADD;
3609: RAISE fnd_api.g_exc_unexpected_error;
3610: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 3609: RAISE fnd_api.g_exc_unexpected_error;

3605:
3606: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3607: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3608: fnd_msg_pub.ADD;
3609: RAISE fnd_api.g_exc_unexpected_error;
3610: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3611: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3612: fnd_msg_pub.ADD;
3613: RAISE fnd_api.g_exc_error;

Line 3610: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3606: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3607: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3608: fnd_msg_pub.ADD;
3609: RAISE fnd_api.g_exc_unexpected_error;
3610: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3611: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3612: fnd_msg_pub.ADD;
3613: RAISE fnd_api.g_exc_error;
3614: END IF;

Line 3613: RAISE fnd_api.g_exc_error;

3609: RAISE fnd_api.g_exc_unexpected_error;
3610: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3611: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3612: fnd_msg_pub.ADD;
3613: RAISE fnd_api.g_exc_error;
3614: END IF;
3615:
3616: <>
3617: NULL;

Line 3635: RAISE FND_API.g_exc_error;

3631:
3632: -- Unable to match RS with quantity.
3633: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3634: fnd_msg_pub.ADD;
3635: RAISE FND_API.g_exc_error;
3636:
3637: END IF;
3638: --Bug 5331779-Begin Change
3639: --Instead of an else block we need to have

Line 3746: RAISE fnd_api.g_exc_error;

3742: print_debug('REF INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
3743: END IF;
3744: fnd_message.set_name('INV', 'INV_FAILED');
3745: fnd_msg_pub.ADD;
3746: RAISE fnd_api.g_exc_error;
3747: END IF;
3748:
3749: IF (l_debug = 1) THEN
3750: print_debug('REFERENCE = ' ||l_rti_tb(l_txn_id)(l_lot_num).reference , 1);

Line 3769: RAISE fnd_api.g_exc_unexpected_error;

3765: IF NOT l_result THEN
3766: IF (l_debug = 1) THEN
3767: print_debug('Failure while Inserting MSNI records - lot and serial controlled item',1);
3768: END IF;
3769: RAISE fnd_api.g_exc_unexpected_error;
3770: END IF; -- END IF check l_result
3771:
3772: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3773: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

Line 3772: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3768: END IF;
3769: RAISE fnd_api.g_exc_unexpected_error;
3770: END IF; -- END IF check l_result
3771:
3772: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3773: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3774: IF (l_debug = 1) THEN
3775: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
3776: END IF;

Line 3777: RAISE fnd_api.g_exc_error;

3773: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3774: IF (l_debug = 1) THEN
3775: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
3776: END IF;
3777: RAISE fnd_api.g_exc_error;
3778: END IF;
3779: END LOOP; -- End of serial cursor Loop here
3780:
3781: -- Start changes for bug 14269755

Line 3860: RAISE fnd_api.g_exc_error;

3856: print_debug('REF INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
3857: END IF;
3858: fnd_message.set_name('INV', 'INV_FAILED');
3859: fnd_msg_pub.ADD;
3860: RAISE fnd_api.g_exc_error;
3861: END IF;
3862:
3863: IF (l_debug = 1) THEN
3864: print_debug('REFERENCE = ' ||l_rti_tb(l_txn_id)(l_lot_num).reference , 1);

Line 3883: RAISE fnd_api.g_exc_unexpected_error;

3879: IF NOT l_result THEN
3880: IF (l_debug = 1) THEN
3881: print_debug('Failure while Inserting MSNI records - lot and serial controlled item',1);
3882: END IF;
3883: RAISE fnd_api.g_exc_unexpected_error;
3884: END IF; -- END IF check l_result
3885:
3886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3887: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

Line 3886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3882: END IF;
3883: RAISE fnd_api.g_exc_unexpected_error;
3884: END IF; -- END IF check l_result
3885:
3886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3887: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3888: IF (l_debug = 1) THEN
3889: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
3890: END IF;

Line 3891: RAISE fnd_api.g_exc_error;

3887: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3888: IF (l_debug = 1) THEN
3889: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
3890: END IF;
3891: RAISE fnd_api.g_exc_error;
3892: END IF;
3893:
3894: END LOOP;
3895:

Line 3964: RAISE fnd_api.g_exc_error;

3960: print_debug('Avaiable Qty is less than Txn Qty ' , 1);
3961: END IF;
3962: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3963: fnd_msg_pub.ADD;
3964: RAISE fnd_api.g_exc_error;
3965: END IF;
3966:
3967: IF (l_rti_tb(k)(l).quantity < l_remaining_prim_qty) THEN
3968:

Line 3989: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3985: print_debug('Returned from split_mmtt',1);
3986: print_debug('x_return_status: '||l_return_status,1);
3987: END IF;
3988:
3989: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3990: IF (l_debug = 1) THEN
3991: print_debug('x_msg_data: '||l_msg_data,1);
3992: print_debug('x_msg_count: '||l_msg_count,1);
3993: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);

Line 3997: RAISE fnd_api.g_exc_unexpected_error;

3993: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);
3994: print_debug('Raising Exception!!!',1);
3995: END IF;
3996: l_progress := '@@@';
3997: RAISE fnd_api.g_exc_unexpected_error;
3998: END IF;
3999: END IF;--END IF (p_original_temp_id IS NOT NULL) THEN
4000:
4001: l_remaining_prim_qty := l_remaining_prim_qty-l_rti_tb(k)(l).quantity;

Line 4062: RAISE fnd_api.g_exc_unexpected_error;

4058: IF NOT l_result THEN
4059: IF (l_debug = 1) THEN
4060: print_debug('Failure while Inserting MTLI records - lot and serial controlled item',1);
4061: END IF;
4062: RAISE fnd_api.g_exc_unexpected_error;
4063: END IF; --END IF check l_result
4064: END IF; --IF P_LOT_NUMBER IS NOT NULL THEN
4065:
4066: -- CALL TO RTI HERE

Line 4113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4109: IF (l_debug = 1) THEN
4110: print_debug('AFTER CALLING THE TRANSFER API: STATUS = '||l_return_status, 1);
4111: END IF;
4112:
4113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4114: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
4115: fnd_msg_pub.ADD;
4116: RAISE fnd_api.g_exc_unexpected_error;
4117: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 4116: RAISE fnd_api.g_exc_unexpected_error;

4112:
4113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4114: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
4115: fnd_msg_pub.ADD;
4116: RAISE fnd_api.g_exc_unexpected_error;
4117: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4118: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
4119: fnd_msg_pub.ADD;
4120: RAISE fnd_api.g_exc_error;

Line 4117: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

4113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4114: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
4115: fnd_msg_pub.ADD;
4116: RAISE fnd_api.g_exc_unexpected_error;
4117: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4118: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
4119: fnd_msg_pub.ADD;
4120: RAISE fnd_api.g_exc_error;
4121: END IF;

Line 4120: RAISE fnd_api.g_exc_error;

4116: RAISE fnd_api.g_exc_unexpected_error;
4117: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4118: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
4119: fnd_msg_pub.ADD;
4120: RAISE fnd_api.g_exc_error;
4121: END IF;
4122:
4123: l := l_rti_tb(k).next(l);
4124: END LOOP;

Line 4135: WHEN FND_API.G_EXC_ERROR THEN

4131: print_debug('MATCH TRANSFER RETURNING WITH SUCCESS RETUN STATUS = ' ||x_return_status, 1);
4132: END IF;
4133:
4134: EXCEPTION
4135: WHEN FND_API.G_EXC_ERROR THEN
4136: rollback to match_rti_ss;
4137: x_return_status := FND_API.G_RET_STS_ERROR;
4138: fnd_msg_pub.count_and_get (
4139: p_encoded => FND_API.G_FALSE

Line 4137: x_return_status := FND_API.G_RET_STS_ERROR;

4133:
4134: EXCEPTION
4135: WHEN FND_API.G_EXC_ERROR THEN
4136: rollback to match_rti_ss;
4137: x_return_status := FND_API.G_RET_STS_ERROR;
4138: fnd_msg_pub.count_and_get (
4139: p_encoded => FND_API.G_FALSE
4140: , p_count => x_msg_count
4141: , p_data => x_msg_data );

Line 4139: p_encoded => FND_API.G_FALSE

4135: WHEN FND_API.G_EXC_ERROR THEN
4136: rollback to match_rti_ss;
4137: x_return_status := FND_API.G_RET_STS_ERROR;
4138: fnd_msg_pub.count_and_get (
4139: p_encoded => FND_API.G_FALSE
4140: , p_count => x_msg_count
4141: , p_data => x_msg_data );
4142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4143: rollback to match_rti_ss;

Line 4142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4138: fnd_msg_pub.count_and_get (
4139: p_encoded => FND_API.G_FALSE
4140: , p_count => x_msg_count
4141: , p_data => x_msg_data );
4142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4143: rollback to match_rti_ss;
4144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4145: fnd_msg_pub.count_and_get (
4146: p_encoded => FND_API.G_FALSE

Line 4144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4140: , p_count => x_msg_count
4141: , p_data => x_msg_data );
4142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4143: rollback to match_rti_ss;
4144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4145: fnd_msg_pub.count_and_get (
4146: p_encoded => FND_API.G_FALSE
4147: , p_count => x_msg_count
4148: , p_data => x_msg_data );

Line 4146: p_encoded => FND_API.G_FALSE

4142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4143: rollback to match_rti_ss;
4144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4145: fnd_msg_pub.count_and_get (
4146: p_encoded => FND_API.G_FALSE
4147: , p_count => x_msg_count
4148: , p_data => x_msg_data );
4149: WHEN OTHERS THEN
4150: rollback to match_rti_ss;

Line 4151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4147: , p_count => x_msg_count
4148: , p_data => x_msg_data );
4149: WHEN OTHERS THEN
4150: rollback to match_rti_ss;
4151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4152: fnd_msg_pub.count_and_get (
4153: p_encoded => FND_API.G_FALSE
4154: , p_count => x_msg_count
4155: , p_data => x_msg_data );

Line 4153: p_encoded => FND_API.G_FALSE

4149: WHEN OTHERS THEN
4150: rollback to match_rti_ss;
4151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4152: fnd_msg_pub.count_and_get (
4153: p_encoded => FND_API.G_FALSE
4154: , p_count => x_msg_count
4155: , p_data => x_msg_data );
4156: IF SQLCODE IS NOT NULL THEN
4157: inv_mobile_helper_functions.sql_error (