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

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

125: l_transaction_type VARCHAR2(20) := 'DELIVER';
126: l_total_primary_qty NUMBER := 0;
127:
128: l_msg_count NUMBER;
129: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
130:
131: l_group_id NUMBER;
132: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
133:

Line 289: x_status := fnd_api.g_ret_sts_success;

285: AND NVL(MSI.ORGANIZATION_ID,POLL.SHIP_TO_ORGANIZATION_ID) = POLL.SHIP_TO_ORGANIZATION_ID
286: AND MSI.INVENTORY_ITEM_ID (+) = POL.ITEM_ID;
287: BEGIN
288:
289: x_status := fnd_api.g_ret_sts_success;
290: SAVEPOINT crt_po_rti_sp;
291: l_progress := '10';
292:
293: -- query po_startup_value

Line 384: IF x_status = fnd_api.g_ret_sts_error THEN

380: p_shipment_header_id => NULL,
381: p_lpn_id => NULL
382: );
383: -- x_status is not successful if there is any execution error in matching.
384: IF x_status = fnd_api.g_ret_sts_error THEN
385: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
386: FND_MSG_PUB.ADD;
387: RAISE fnd_api.g_exc_error;
388: END IF;

Line 387: RAISE fnd_api.g_exc_error;

383: -- x_status is not successful if there is any execution error in matching.
384: IF x_status = fnd_api.g_ret_sts_error THEN
385: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
386: FND_MSG_PUB.ADD;
387: RAISE fnd_api.g_exc_error;
388: END IF;
389:
390: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
391: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');

Line 390: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

386: FND_MSG_PUB.ADD;
387: RAISE fnd_api.g_exc_error;
388: END IF;
389:
390: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
391: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
392: FND_MSG_PUB.ADD;
393: RAISE fnd_api.g_exc_unexpected_error;
394: END IF;

Line 393: RAISE fnd_api.g_exc_unexpected_error;

389:
390: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
391: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
392: FND_MSG_PUB.ADD;
393: RAISE fnd_api.g_exc_unexpected_error;
394: END IF;
395:
396: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
397: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 400: RAISE fnd_api.g_exc_error;

396: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
397: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
398: FND_MESSAGE.SET_NAME('INV', l_err_message);
399: FND_MSG_PUB.ADD;
400: RAISE fnd_api.g_exc_error;
401: END IF;
402:
403: l_err_message := '@@@';
404: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

Line 485: IF l_return_status <> fnd_api.g_ret_sts_success THEN

481: x_return_status => l_return_status,
482: x_msg_count => l_msg_count,
483: x_msg_data => x_message);
484:
485: IF l_return_status <> fnd_api.g_ret_sts_success THEN
486: x_status := l_return_status;
487: END IF;
488:
489: l_progress := '70';

Line 496: WHEN fnd_api.g_exc_error THEN

492: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
493:
494:
495: EXCEPTION
496: WHEN fnd_api.g_exc_error THEN
497: ROLLBACK TO crt_po_rti_sp;
498: x_status := fnd_api.g_ret_sts_error;
499:
500: IF l_curs_rcpt_detail%isopen THEN

Line 498: x_status := fnd_api.g_ret_sts_error;

494:
495: EXCEPTION
496: WHEN fnd_api.g_exc_error THEN
497: ROLLBACK TO crt_po_rti_sp;
498: x_status := fnd_api.g_ret_sts_error;
499:
500: IF l_curs_rcpt_detail%isopen THEN
501: CLOSE l_curs_rcpt_detail;
502: END IF;

Line 505: (p_encoded => FND_API.g_false,

501: CLOSE l_curs_rcpt_detail;
502: END IF;
503:
504: fnd_msg_pub.count_and_get
505: (p_encoded => FND_API.g_false,
506: p_count => l_msg_count,
507: p_data => x_message
508: );
509:

Line 510: WHEN fnd_api.g_exc_unexpected_error THEN

506: p_count => l_msg_count,
507: p_data => x_message
508: );
509:
510: WHEN fnd_api.g_exc_unexpected_error THEN
511: ROLLBACK TO crt_po_rti_sp;
512: x_status := fnd_api.g_ret_sts_unexp_error ;
513: IF l_curs_rcpt_detail%isopen THEN
514: CLOSE l_curs_rcpt_detail;

Line 512: x_status := fnd_api.g_ret_sts_unexp_error ;

508: );
509:
510: WHEN fnd_api.g_exc_unexpected_error THEN
511: ROLLBACK TO crt_po_rti_sp;
512: x_status := fnd_api.g_ret_sts_unexp_error ;
513: IF l_curs_rcpt_detail%isopen THEN
514: CLOSE l_curs_rcpt_detail;
515: END IF;
516:

Line 518: (p_encoded => FND_API.g_false,

514: CLOSE l_curs_rcpt_detail;
515: END IF;
516:
517: fnd_msg_pub.count_and_get
518: (p_encoded => FND_API.g_false,
519: p_count => l_msg_count,
520: p_data => x_message
521: );
522:

Line 526: x_status := fnd_api.g_ret_sts_unexp_error ;

522:
523:
524: WHEN OTHERS THEN
525: ROLLBACK TO crt_po_rti_sp;
526: x_status := fnd_api.g_ret_sts_unexp_error ;
527: IF l_curs_rcpt_detail%isopen THEN
528: CLOSE l_curs_rcpt_detail;
529: END IF;
530: fnd_msg_pub.count_and_get

Line 531: (p_encoded => FND_API.g_false,

527: IF l_curs_rcpt_detail%isopen THEN
528: CLOSE l_curs_rcpt_detail;
529: END IF;
530: fnd_msg_pub.count_and_get
531: (p_encoded => FND_API.g_false,
532: p_count => l_msg_count,
533: p_data => x_message
534: );
535:

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

577: l_transaction_type VARCHAR2(20) := 'DELIVER';
578: l_total_primary_qty NUMBER := 0;
579:
580: l_msg_count NUMBER;
581: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
582:
583: l_group_id NUMBER;
584: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
585: --l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;

Line 752: x_status := fnd_api.g_ret_sts_success;

748: )
749: and ( p_task_id is null or pod.task_id = p_task_id );
750: BEGIN
751:
752: x_status := fnd_api.g_ret_sts_success;
753: SAVEPOINT crt_po_rti_sp;
754: l_progress := '10';
755:
756: -- query po_startup_value

Line 850: IF x_status = fnd_api.g_ret_sts_error THEN

846: p_lpn_id => NULL
847: );
848:
849: -- x_status is not successful if there is any execution error in matching.
850: IF x_status = fnd_api.g_ret_sts_error THEN
851: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
852: FND_MSG_PUB.ADD;
853: RAISE fnd_api.g_exc_error;
854: END IF;

Line 853: RAISE fnd_api.g_exc_error;

849: -- x_status is not successful if there is any execution error in matching.
850: IF x_status = fnd_api.g_ret_sts_error THEN
851: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
852: FND_MSG_PUB.ADD;
853: RAISE fnd_api.g_exc_error;
854: END IF;
855:
856: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
857: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');

Line 856: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

852: FND_MSG_PUB.ADD;
853: RAISE fnd_api.g_exc_error;
854: END IF;
855:
856: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
857: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
858: FND_MSG_PUB.ADD;
859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;

Line 859: RAISE fnd_api.g_exc_unexpected_error;

855:
856: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
857: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
858: FND_MSG_PUB.ADD;
859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;
861:
862: IF gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
863: l_err_message := gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 866: RAISE fnd_api.g_exc_error;

862: IF gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
863: l_err_message := gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
864: FND_MESSAGE.SET_NAME('INV', l_err_message);
865: FND_MSG_PUB.ADD;
866: RAISE fnd_api.g_exc_error;
867: END IF;
868:
869:
870: l_err_message := '@@@';

Line 1003: , p_init_msg_lst => FND_API.G_FALSE

999: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1000:
1001: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
1002: p_api_version => 1.0
1003: , p_init_msg_lst => FND_API.G_FALSE
1004: , x_return_status => l_return_status
1005: , x_msg_count => l_msg_count
1006: , x_msg_data => x_message
1007: , p_new_rti_info => l_new_rti_info);

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: , x_msg_data => x_message
1007: , p_new_rti_info => l_new_rti_info);
1008:
1009: IF (NOT l_split_lot_serial_ok) THEN
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012:
1013:
1014: l_progress := '90';

Line 1027: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1023: x_return_status => l_return_status,
1024: x_msg_count => l_msg_count,
1025: x_msg_data => x_message);
1026:
1027: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1028: x_status := l_return_status;
1029: END IF;
1030: */
1031: l_progress := '100';

Line 1039: WHEN fnd_api.g_exc_error THEN

1035: gml_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1036:
1037:
1038: EXCEPTION
1039: WHEN fnd_api.g_exc_error THEN
1040: ROLLBACK TO crt_po_rti_sp;
1041: x_status := fnd_api.g_ret_sts_error;
1042:
1043: IF l_curs_rcpt_detail%isopen THEN

Line 1041: x_status := fnd_api.g_ret_sts_error;

1037:
1038: EXCEPTION
1039: WHEN fnd_api.g_exc_error THEN
1040: ROLLBACK TO crt_po_rti_sp;
1041: x_status := fnd_api.g_ret_sts_error;
1042:
1043: IF l_curs_rcpt_detail%isopen THEN
1044: CLOSE l_curs_rcpt_detail;
1045: END IF;

Line 1048: (p_encoded => FND_API.g_false,

1044: CLOSE l_curs_rcpt_detail;
1045: END IF;
1046:
1047: fnd_msg_pub.count_and_get
1048: (p_encoded => FND_API.g_false,
1049: p_count => l_msg_count,
1050: p_data => x_message
1051: );
1052:

Line 1053: WHEN fnd_api.g_exc_unexpected_error THEN

1049: p_count => l_msg_count,
1050: p_data => x_message
1051: );
1052:
1053: WHEN fnd_api.g_exc_unexpected_error THEN
1054: ROLLBACK TO crt_po_rti_sp;
1055: x_status := fnd_api.g_ret_sts_unexp_error ;
1056: IF l_curs_rcpt_detail%isopen THEN
1057: CLOSE l_curs_rcpt_detail;

Line 1055: x_status := fnd_api.g_ret_sts_unexp_error ;

1051: );
1052:
1053: WHEN fnd_api.g_exc_unexpected_error THEN
1054: ROLLBACK TO crt_po_rti_sp;
1055: x_status := fnd_api.g_ret_sts_unexp_error ;
1056: IF l_curs_rcpt_detail%isopen THEN
1057: CLOSE l_curs_rcpt_detail;
1058: END IF;
1059:

Line 1061: (p_encoded => FND_API.g_false,

1057: CLOSE l_curs_rcpt_detail;
1058: END IF;
1059:
1060: fnd_msg_pub.count_and_get
1061: (p_encoded => FND_API.g_false,
1062: p_count => l_msg_count,
1063: p_data => x_message
1064: );
1065:

Line 1070: x_status := fnd_api.g_ret_sts_unexp_error ;

1066:
1067: WHEN OTHERS THEN
1068: x_message := SQLERRM;
1069: ROLLBACK TO crt_po_rti_sp;
1070: x_status := fnd_api.g_ret_sts_unexp_error ;
1071: IF l_curs_rcpt_detail%isopen THEN
1072: CLOSE l_curs_rcpt_detail;
1073: END IF;
1074: fnd_msg_pub.count_and_get

Line 1075: (p_encoded => FND_API.g_false,

1071: IF l_curs_rcpt_detail%isopen THEN
1072: CLOSE l_curs_rcpt_detail;
1073: END IF;
1074: fnd_msg_pub.count_and_get
1075: (p_encoded => FND_API.g_false,
1076: p_count => l_msg_count,
1077: p_data => x_message
1078: );
1079:

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

1114: l_transaction_type VARCHAR2(20) := 'DELIVER';
1115: l_total_primary_qty NUMBER := 0;
1116:
1117: l_msg_count NUMBER;
1118: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1119:
1120: l_group_id NUMBER;
1121:
1122: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

Line 1296: x_status := fnd_api.g_ret_sts_success;

1292: )
1293: )or rsl.source_document_code <> 'REQ'
1294: );
1295: BEGIN
1296: x_status := fnd_api.g_ret_sts_success;
1297: l_progress := '10';
1298: SAVEPOINT crt_intship_rti_sp;
1299:
1300: -- query po_startup_value

Line 1383: IF x_status = fnd_api.g_ret_sts_error THEN

1379: );
1380: */
1381:
1382: -- x_status is not successful if there is any execution error in matching.
1383: IF x_status = fnd_api.g_ret_sts_error THEN
1384: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1385: FND_MSG_PUB.ADD;
1386: RAISE fnd_api.g_exc_error;
1387: END IF;

Line 1386: RAISE fnd_api.g_exc_error;

1382: -- x_status is not successful if there is any execution error in matching.
1383: IF x_status = fnd_api.g_ret_sts_error THEN
1384: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1385: FND_MSG_PUB.ADD;
1386: RAISE fnd_api.g_exc_error;
1387: END IF;
1388:
1389: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1390: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');

Line 1389: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

1385: FND_MSG_PUB.ADD;
1386: RAISE fnd_api.g_exc_error;
1387: END IF;
1388:
1389: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1390: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1391: FND_MSG_PUB.ADD;
1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;

Line 1392: RAISE fnd_api.g_exc_unexpected_error;

1388:
1389: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1390: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1391: FND_MSG_PUB.ADD;
1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;
1394:
1395: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1396: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 1399: RAISE fnd_api.g_exc_error;

1395: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1396: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1397: FND_MESSAGE.SET_NAME('INV', l_err_message);
1398: FND_MSG_PUB.ADD;
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: l_err_message := '@@@';
1403: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

Line 1521: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1517: x_return_status => l_return_status,
1518: x_msg_count => l_msg_count,
1519: x_msg_data => x_message);
1520:
1521: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1522: x_status := l_return_status;
1523: END IF;
1524:
1525: l_progress := '100';

Line 1532: WHEN fnd_api.g_exc_error THEN

1528: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1529:
1530:
1531: EXCEPTION
1532: WHEN fnd_api.g_exc_error THEN
1533: ROLLBACK TO crt_intship_rti_sp;
1534: x_status := fnd_api.g_ret_sts_error;
1535:
1536: IF l_curs_rcpt_detail%isopen THEN

Line 1534: x_status := fnd_api.g_ret_sts_error;

1530:
1531: EXCEPTION
1532: WHEN fnd_api.g_exc_error THEN
1533: ROLLBACK TO crt_intship_rti_sp;
1534: x_status := fnd_api.g_ret_sts_error;
1535:
1536: IF l_curs_rcpt_detail%isopen THEN
1537: CLOSE l_curs_rcpt_detail;
1538: END IF;

Line 1541: (p_encoded => FND_API.g_false,

1537: CLOSE l_curs_rcpt_detail;
1538: END IF;
1539:
1540: fnd_msg_pub.count_and_get
1541: (p_encoded => FND_API.g_false,
1542: p_count => l_msg_count,
1543: p_data => x_message
1544: );
1545:

Line 1546: WHEN fnd_api.g_exc_unexpected_error THEN

1542: p_count => l_msg_count,
1543: p_data => x_message
1544: );
1545:
1546: WHEN fnd_api.g_exc_unexpected_error THEN
1547: ROLLBACK TO crt_intship_rti_sp;
1548: x_status := fnd_api.g_ret_sts_unexp_error ;
1549: IF l_curs_rcpt_detail%isopen THEN
1550: CLOSE l_curs_rcpt_detail;

Line 1548: x_status := fnd_api.g_ret_sts_unexp_error ;

1544: );
1545:
1546: WHEN fnd_api.g_exc_unexpected_error THEN
1547: ROLLBACK TO crt_intship_rti_sp;
1548: x_status := fnd_api.g_ret_sts_unexp_error ;
1549: IF l_curs_rcpt_detail%isopen THEN
1550: CLOSE l_curs_rcpt_detail;
1551: END IF;
1552:

Line 1554: (p_encoded => FND_API.g_false,

1550: CLOSE l_curs_rcpt_detail;
1551: END IF;
1552:
1553: fnd_msg_pub.count_and_get
1554: (p_encoded => FND_API.g_false,
1555: p_count => l_msg_count,
1556: p_data => x_message
1557: );
1558:

Line 1562: x_status := fnd_api.g_ret_sts_unexp_error ;

1558:
1559:
1560: WHEN OTHERS THEN
1561: ROLLBACK TO crt_intship_rti_sp;
1562: x_status := fnd_api.g_ret_sts_unexp_error ;
1563: IF l_curs_rcpt_detail%isopen THEN
1564: CLOSE l_curs_rcpt_detail;
1565: END IF;
1566: fnd_msg_pub.count_and_get

Line 1567: (p_encoded => FND_API.g_false,

1563: IF l_curs_rcpt_detail%isopen THEN
1564: CLOSE l_curs_rcpt_detail;
1565: END IF;
1566: fnd_msg_pub.count_and_get
1567: (p_encoded => FND_API.g_false,
1568: p_count => l_msg_count,
1569: p_data => x_message
1570: );
1571:

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

1604: l_transaction_type VARCHAR2(20) := 'DELIVER';
1605: l_total_primary_qty NUMBER := 0;
1606:
1607: l_msg_count NUMBER;
1608: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1609:
1610: l_group_id NUMBER;
1611:
1612: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

Line 1772: x_status := fnd_api.g_ret_sts_success;

1768: )
1769: and ( p_task_id is null or OEL.task_id = p_task_id );
1770:
1771: BEGIN
1772: x_status := fnd_api.g_ret_sts_success;
1773: l_progress := '10';
1774: SAVEPOINT crt_rma_rti_sp;
1775:
1776: -- query po_startup_value

Line 1839: IF x_status = fnd_api.g_ret_sts_error THEN

1835: p_lpn_id => NULL
1836: );
1837:
1838: -- x_status is not successful if there is any execution error in matching.
1839: IF x_status = fnd_api.g_ret_sts_error THEN
1840: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE fnd_api.g_exc_error;
1843: END IF;

Line 1842: RAISE fnd_api.g_exc_error;

1838: -- x_status is not successful if there is any execution error in matching.
1839: IF x_status = fnd_api.g_ret_sts_error THEN
1840: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE fnd_api.g_exc_error;
1843: END IF;
1844:
1845: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1846: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');

Line 1845: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

1841: FND_MSG_PUB.ADD;
1842: RAISE fnd_api.g_exc_error;
1843: END IF;
1844:
1845: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1846: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE fnd_api.g_exc_unexpected_error;
1849: END IF;

Line 1848: RAISE fnd_api.g_exc_unexpected_error;

1844:
1845: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1846: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE fnd_api.g_exc_unexpected_error;
1849: END IF;
1850:
1851: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1852: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 1855: RAISE fnd_api.g_exc_error;

1851: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1852: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1853: FND_MESSAGE.SET_NAME('INV', l_err_message);
1854: FND_MSG_PUB.ADD;
1855: RAISE fnd_api.g_exc_error;
1856: END IF;
1857:
1858: l_err_message := '@@@';
1859: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

Line 1950: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1946: x_return_status => l_return_status,
1947: x_msg_count => l_msg_count,
1948: x_msg_data => x_message);
1949:
1950: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1951: x_status := l_return_status;
1952: END IF;
1953:
1954: l_progress := '100';

Line 1961: WHEN fnd_api.g_exc_error THEN

1957: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1958:
1959:
1960: EXCEPTION
1961: WHEN fnd_api.g_exc_error THEN
1962: ROLLBACK TO crt_rma_rti_sp;
1963: x_status := fnd_api.g_ret_sts_error;
1964:
1965: IF l_curs_rcpt_detail%isopen THEN

Line 1963: x_status := fnd_api.g_ret_sts_error;

1959:
1960: EXCEPTION
1961: WHEN fnd_api.g_exc_error THEN
1962: ROLLBACK TO crt_rma_rti_sp;
1963: x_status := fnd_api.g_ret_sts_error;
1964:
1965: IF l_curs_rcpt_detail%isopen THEN
1966: CLOSE l_curs_rcpt_detail;
1967: END IF;

Line 1970: (p_encoded => FND_API.g_false,

1966: CLOSE l_curs_rcpt_detail;
1967: END IF;
1968:
1969: fnd_msg_pub.count_and_get
1970: (p_encoded => FND_API.g_false,
1971: p_count => l_msg_count,
1972: p_data => x_message
1973: );
1974:

Line 1975: WHEN fnd_api.g_exc_unexpected_error THEN

1971: p_count => l_msg_count,
1972: p_data => x_message
1973: );
1974:
1975: WHEN fnd_api.g_exc_unexpected_error THEN
1976: ROLLBACK TO crt_rma_rti_sp;
1977: x_status := fnd_api.g_ret_sts_unexp_error ;
1978: IF l_curs_rcpt_detail%isopen THEN
1979: CLOSE l_curs_rcpt_detail;

Line 1977: x_status := fnd_api.g_ret_sts_unexp_error ;

1973: );
1974:
1975: WHEN fnd_api.g_exc_unexpected_error THEN
1976: ROLLBACK TO crt_rma_rti_sp;
1977: x_status := fnd_api.g_ret_sts_unexp_error ;
1978: IF l_curs_rcpt_detail%isopen THEN
1979: CLOSE l_curs_rcpt_detail;
1980: END IF;
1981:

Line 1983: (p_encoded => FND_API.g_false,

1979: CLOSE l_curs_rcpt_detail;
1980: END IF;
1981:
1982: fnd_msg_pub.count_and_get
1983: (p_encoded => FND_API.g_false,
1984: p_count => l_msg_count,
1985: p_data => x_message
1986: );
1987:

Line 1990: x_status := fnd_api.g_ret_sts_unexp_error ;

1986: );
1987:
1988: WHEN OTHERS THEN
1989: ROLLBACK TO crt_rma_rti_sp;
1990: x_status := fnd_api.g_ret_sts_unexp_error ;
1991: IF l_curs_rcpt_detail%isopen THEN
1992: CLOSE l_curs_rcpt_detail;
1993: END IF;
1994: fnd_msg_pub.count_and_get

Line 1995: (p_encoded => FND_API.g_false,

1991: IF l_curs_rcpt_detail%isopen THEN
1992: CLOSE l_curs_rcpt_detail;
1993: END IF;
1994: fnd_msg_pub.count_and_get
1995: (p_encoded => FND_API.g_false,
1996: p_count => l_msg_count,
1997: p_data => x_message
1998: );
1999:

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

2034: l_match_type VARCHAR2(20);
2035:
2036: l_msg_count NUMBER;
2037: l_msg_data VARCHAR2(400);
2038: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2039:
2040: l_group_id NUMBER;
2041:
2042: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

Line 2383: x_status := FND_API.G_RET_STS_SUCCESS;

2379:
2380: BEGIN
2381:
2382: SAVEPOINT crt_asn_con_rti_sp;
2383: x_status := FND_API.G_RET_STS_SUCCESS;
2384: l_progress := '10';
2385:
2386: -- query po_startup_value
2387: Begin

Line 2410: RAISE fnd_api.g_exc_error ;

2406: Exception
2407: when NO_DATA_FOUND then
2408: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
2409: FND_MSG_PUB.ADD;
2410: RAISE fnd_api.g_exc_error ;
2411: End;
2412:
2413: -- default header level non-DB items in rcv_transaction block
2414: -- and default other values need to be insert into RTI

Line 2520: IF l_return_status = fnd_api.g_ret_sts_error THEN

2516: );
2517:
2518: */
2519:
2520: IF l_return_status = fnd_api.g_ret_sts_error THEN
2521: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
2522: FND_MSG_PUB.ADD;
2523: RAISE fnd_api.g_exc_error;
2524: END IF;

Line 2523: RAISE fnd_api.g_exc_error;

2519:
2520: IF l_return_status = fnd_api.g_ret_sts_error THEN
2521: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
2522: FND_MSG_PUB.ADD;
2523: RAISE fnd_api.g_exc_error;
2524: END IF;
2525:
2526: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2527: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');

Line 2526: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2522: FND_MSG_PUB.ADD;
2523: RAISE fnd_api.g_exc_error;
2524: END IF;
2525:
2526: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2527: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
2528: FND_MSG_PUB.ADD;
2529: RAISE fnd_api.g_exc_unexpected_error;
2530: END IF;

Line 2529: RAISE fnd_api.g_exc_unexpected_error;

2525:
2526: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2527: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
2528: FND_MSG_PUB.ADD;
2529: RAISE fnd_api.g_exc_unexpected_error;
2530: END IF;
2531:
2532: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2533: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 2536: RAISE fnd_api.g_exc_error;

2532: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2533: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
2534: FND_MESSAGE.SET_NAME('INV', l_err_message);
2535: FND_MSG_PUB.ADD;
2536: RAISE fnd_api.g_exc_error;
2537: END IF;
2538:
2539: l_err_message := '@@@';
2540: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

Line 2676: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2672: x_return_status => l_return_status,
2673: x_msg_count => l_msg_count,
2674: x_msg_data => x_message);
2675:
2676: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2677: x_status := l_return_status;
2678: END IF;
2679:
2680: l_progress := '130';

Line 2694: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2690: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb,
2691: to_number(null),
2692: l_return_status,
2693: l_msg_data );
2694: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2695: x_status := l_return_status;
2696: END IF;
2697:
2698: */

Line 2708: WHEN fnd_api.g_exc_error THEN

2704:
2705:
2706: EXCEPTION
2707:
2708: WHEN fnd_api.g_exc_error THEN
2709: ROLLBACK TO crt_asn_con_rti_sp;
2710: x_status := fnd_api.g_ret_sts_error;
2711: IF l_curs_rcpt_detail%isopen THEN
2712: CLOSE l_curs_rcpt_detail;

Line 2710: x_status := fnd_api.g_ret_sts_error;

2706: EXCEPTION
2707:
2708: WHEN fnd_api.g_exc_error THEN
2709: ROLLBACK TO crt_asn_con_rti_sp;
2710: x_status := fnd_api.g_ret_sts_error;
2711: IF l_curs_rcpt_detail%isopen THEN
2712: CLOSE l_curs_rcpt_detail;
2713: END IF;
2714:

Line 2716: (p_encoded => FND_API.g_false,

2712: CLOSE l_curs_rcpt_detail;
2713: END IF;
2714:
2715: fnd_msg_pub.count_and_get
2716: (p_encoded => FND_API.g_false,
2717: p_count => l_msg_count,
2718: p_data => x_message
2719: );
2720:

Line 2721: WHEN fnd_api.g_exc_unexpected_error THEN

2717: p_count => l_msg_count,
2718: p_data => x_message
2719: );
2720:
2721: WHEN fnd_api.g_exc_unexpected_error THEN
2722: ROLLBACK TO crt_asn_con_rti_sp;
2723: x_status := fnd_api.g_ret_sts_unexp_error ;
2724: IF l_curs_rcpt_detail%isopen THEN
2725: CLOSE l_curs_rcpt_detail;

Line 2723: x_status := fnd_api.g_ret_sts_unexp_error ;

2719: );
2720:
2721: WHEN fnd_api.g_exc_unexpected_error THEN
2722: ROLLBACK TO crt_asn_con_rti_sp;
2723: x_status := fnd_api.g_ret_sts_unexp_error ;
2724: IF l_curs_rcpt_detail%isopen THEN
2725: CLOSE l_curs_rcpt_detail;
2726: END IF;
2727:

Line 2729: (p_encoded => FND_API.g_false,

2725: CLOSE l_curs_rcpt_detail;
2726: END IF;
2727:
2728: fnd_msg_pub.count_and_get
2729: (p_encoded => FND_API.g_false,
2730: p_count => l_msg_count,
2731: p_data => x_message
2732: );
2733:

Line 2737: x_status := fnd_api.g_ret_sts_unexp_error ;

2733:
2734:
2735: WHEN OTHERS THEN
2736: ROLLBACK TO crt_asn_con_rti_sp;
2737: x_status := fnd_api.g_ret_sts_unexp_error ;
2738: IF l_curs_rcpt_detail%isopen THEN
2739: CLOSE l_curs_rcpt_detail;
2740: END IF;
2741:

Line 2744: (p_encoded => FND_API.g_false,

2740: END IF;
2741:
2742:
2743: fnd_msg_pub.count_and_get
2744: (p_encoded => FND_API.g_false,
2745: p_count => l_msg_count,
2746: p_data => x_message
2747: );
2748:

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

2862: l_po_header_id NUMBER;
2863: l_lot_number VARCHAR2(30);
2864: l_lot_expiration_date DATE;
2865:
2866: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2867: l_msg_count NUMBER;
2868: l_msg_data VARCHAR2(400);
2869: l_progress VARCHAR2(10);
2870:

Line 2883: x_status := fnd_api.g_ret_sts_success;

2879:
2880: l_label_status VARCHAR2(500);
2881: BEGIN
2882:
2883: x_status := fnd_api.g_ret_sts_success;
2884:
2885: l_progress := '10';
2886:
2887: OPEN l_curs_asn_lpn_content;

Line 2915: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2911: x_return_status => l_return_status,
2912: x_msg_count => l_msg_count,
2913: x_msg_data => l_msg_data);
2914:
2915: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2916: RAISE fnd_api.g_exc_error;
2917: END IF;
2918:
2919: l_progress := '35';

Line 2916: RAISE fnd_api.g_exc_error;

2912: x_msg_count => l_msg_count,
2913: x_msg_data => l_msg_data);
2914:
2915: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2916: RAISE fnd_api.g_exc_error;
2917: END IF;
2918:
2919: l_progress := '35';
2920: SELECT unit_of_measure

Line 2941: RAISE fnd_api.g_exc_error;

2937:
2938: IF l_uom_conv_ratio = -99999 THEN -- uom conversion failure
2939: FND_MESSAGE.SET_NAME('INV', 'INV_INT_UOMCONVCODE');
2940: FND_MSG_PUB.ADD;
2941: RAISE fnd_api.g_exc_error;
2942: END IF;
2943:
2944: l_primary_qty := l_quantity * l_uom_conv_ratio;
2945:

Line 2958: IF l_return_status = FND_API.g_ret_sts_error THEN

2954: x_serial_transaction_temp_id => l_serial_txn_temp_id,
2955: x_return_status => l_return_status,
2956: x_msg_data => l_msg_data);
2957:
2958: IF l_return_status = FND_API.g_ret_sts_error THEN
2959: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
2960: FND_MSG_PUB.ADD;
2961: RAISE FND_API.G_EXC_ERROR;
2962: END IF;

Line 2961: RAISE FND_API.G_EXC_ERROR;

2957:
2958: IF l_return_status = FND_API.g_ret_sts_error THEN
2959: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
2960: FND_MSG_PUB.ADD;
2961: RAISE FND_API.G_EXC_ERROR;
2962: END IF;
2963:
2964: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2965: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

Line 2964: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2960: FND_MSG_PUB.ADD;
2961: RAISE FND_API.G_EXC_ERROR;
2962: END IF;
2963:
2964: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2965: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
2966: FND_MSG_PUB.ADD;
2967: RAISE FND_API.g_exc_unexpected_error;
2968: END IF;

Line 2967: RAISE FND_API.g_exc_unexpected_error;

2963:
2964: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2965: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
2966: FND_MSG_PUB.ADD;
2967: RAISE FND_API.g_exc_unexpected_error;
2968: END IF;
2969:
2970: END IF;
2971:

Line 3077: IF l_return_status = FND_API.g_ret_sts_error THEN

3073: p_project_id => p_project_id,
3074: p_task_id => p_task_id
3075: );
3076:
3077: IF l_return_status = FND_API.g_ret_sts_error THEN
3078: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;

Line 3080: RAISE FND_API.G_EXC_ERROR;

3076:
3077: IF l_return_status = FND_API.g_ret_sts_error THEN
3078: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082:
3083: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3084: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

Line 3083: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082:
3083: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3084: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
3085: FND_MSG_PUB.ADD;
3086: RAISE FND_API.g_exc_unexpected_error;
3087: END IF;

Line 3086: RAISE FND_API.g_exc_unexpected_error;

3082:
3083: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3084: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
3085: FND_MSG_PUB.ADD;
3086: RAISE FND_API.g_exc_unexpected_error;
3087: END IF;
3088:
3089:
3090: END LOOP;

Line 3130: WHEN fnd_api.g_exc_error THEN

3126:
3127:
3128: EXCEPTION
3129:
3130: WHEN fnd_api.g_exc_error THEN
3131: x_status := fnd_api.g_ret_sts_error;
3132: IF l_curs_asn_lpn_content%isopen THEN
3133: CLOSE l_curs_asn_lpn_content;
3134: END IF;

Line 3131: x_status := fnd_api.g_ret_sts_error;

3127:
3128: EXCEPTION
3129:
3130: WHEN fnd_api.g_exc_error THEN
3131: x_status := fnd_api.g_ret_sts_error;
3132: IF l_curs_asn_lpn_content%isopen THEN
3133: CLOSE l_curs_asn_lpn_content;
3134: END IF;
3135:

Line 3137: (p_encoded => FND_API.g_false,

3133: CLOSE l_curs_asn_lpn_content;
3134: END IF;
3135:
3136: fnd_msg_pub.count_and_get
3137: (p_encoded => FND_API.g_false,
3138: p_count => l_msg_count,
3139: p_data => x_message
3140: );
3141:

Line 3142: WHEN fnd_api.g_exc_unexpected_error THEN

3138: p_count => l_msg_count,
3139: p_data => x_message
3140: );
3141:
3142: WHEN fnd_api.g_exc_unexpected_error THEN
3143: x_status := fnd_api.g_ret_sts_unexp_error ;
3144: IF l_curs_asn_lpn_content%isopen THEN
3145: CLOSE l_curs_asn_lpn_content;
3146: END IF;

Line 3143: x_status := fnd_api.g_ret_sts_unexp_error ;

3139: p_data => x_message
3140: );
3141:
3142: WHEN fnd_api.g_exc_unexpected_error THEN
3143: x_status := fnd_api.g_ret_sts_unexp_error ;
3144: IF l_curs_asn_lpn_content%isopen THEN
3145: CLOSE l_curs_asn_lpn_content;
3146: END IF;
3147:

Line 3149: (p_encoded => FND_API.g_false,

3145: CLOSE l_curs_asn_lpn_content;
3146: END IF;
3147:
3148: fnd_msg_pub.count_and_get
3149: (p_encoded => FND_API.g_false,
3150: p_count => l_msg_count,
3151: p_data => x_message
3152: );
3153:

Line 3156: x_status := fnd_api.g_ret_sts_unexp_error ;

3152: );
3153:
3154:
3155: WHEN OTHERS THEN
3156: x_status := fnd_api.g_ret_sts_unexp_error ;
3157: IF l_curs_asn_lpn_content%isopen THEN
3158: CLOSE l_curs_asn_lpn_content;
3159: END IF;
3160:

Line 3163: (p_encoded => FND_API.g_false,

3159: END IF;
3160:
3161:
3162: fnd_msg_pub.count_and_get
3163: (p_encoded => FND_API.g_false,
3164: p_count => l_msg_count,
3165: p_data => x_message
3166: );
3167:

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

3184: x_status OUT NOCOPY VARCHAR2,
3185: x_message OUT NOCOPY VARCHAR2
3186: )
3187: IS
3188: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3189: l_msg_count NUMBER;
3190: l_msg_data VARCHAR2(400);
3191: l_label_status VARCHAR2(500);
3192: l_progress VARCHAR2(10);

Line 3207: x_status := fnd_api.g_ret_sts_success;

3203: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3204: GROUP BY decode(p_source_type, 'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;
3205: -- GROUP BY rti.lpn_id;
3206: BEGIN
3207: x_status := fnd_api.g_ret_sts_success;
3208: l_progress := '10';
3209:
3210: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3211: select ood.set_of_books_id

Line 3227: IF x_status <> fnd_api.g_ret_sts_success THEN

3223: p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id,
3224: x_return_status => x_status,
3225: x_error_code => x_message);
3226:
3227: IF x_status <> fnd_api.g_ret_sts_success THEN
3228: RETURN;
3229: END IF;
3230:
3231: IF p_po_header_id IS NULL AND p_item_id IS NULL THEN

Line 3232: x_status := fnd_api.g_ret_sts_error;

3228: RETURN;
3229: END IF;
3230:
3231: IF p_po_header_id IS NULL AND p_item_id IS NULL THEN
3232: x_status := fnd_api.g_ret_sts_error;
3233: RETURN;
3234: END IF;
3235:
3236: l_progress := '30';

Line 3255: IF l_return_status = FND_API.g_ret_sts_error THEN

3251: p_revision => p_revision,
3252: x_status => l_return_status,
3253: x_message => x_message);
3254:
3255: IF l_return_status = FND_API.g_ret_sts_error THEN
3256: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: END IF;

Line 3258: RAISE FND_API.G_EXC_ERROR;

3254:
3255: IF l_return_status = FND_API.g_ret_sts_error THEN
3256: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: END IF;
3260: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3261: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3262: FND_MSG_PUB.ADD;

Line 3260: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3256: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: END IF;
3260: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3261: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3262: FND_MSG_PUB.ADD;
3263: RAISE FND_API.g_exc_unexpected_error;
3264: END IF;

Line 3263: RAISE FND_API.g_exc_unexpected_error;

3259: END IF;
3260: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3261: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3262: FND_MSG_PUB.ADD;
3263: RAISE FND_API.g_exc_unexpected_error;
3264: END IF;
3265:
3266: l_progress := '40';
3267: x_status := l_return_status; -- l_return_status can be 'W', we want to carry that over

Line 3270: IF l_return_status <> FND_API.g_ret_sts_error THEN

3266: l_progress := '40';
3267: x_status := l_return_status; -- l_return_status can be 'W', we want to carry that over
3268:
3269: -- calling label printing API
3270: IF l_return_status <> FND_API.g_ret_sts_error THEN
3271: l_progress := '40';
3272:
3273: l_counter := 1;
3274: OPEN c_rti_txn_id;

Line 3294: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3290: , p_business_flow_code => 1
3291: , p_transaction_id => l_txn_id_tbl
3292: );
3293:
3294: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3295: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
3296: FND_MSG_PUB.ADD;
3297: x_status := 'W';
3298: END IF;

Line 3303: WHEN fnd_api.g_exc_error THEN

3299:
3300: END IF;
3301:
3302: EXCEPTION
3303: WHEN fnd_api.g_exc_error THEN
3304: x_status := fnd_api.g_ret_sts_error;
3305: fnd_msg_pub.count_and_get
3306: (p_encoded => FND_API.g_false,
3307: p_count => l_msg_count,

Line 3304: x_status := fnd_api.g_ret_sts_error;

3300: END IF;
3301:
3302: EXCEPTION
3303: WHEN fnd_api.g_exc_error THEN
3304: x_status := fnd_api.g_ret_sts_error;
3305: fnd_msg_pub.count_and_get
3306: (p_encoded => FND_API.g_false,
3307: p_count => l_msg_count,
3308: p_data => x_message

Line 3306: (p_encoded => FND_API.g_false,

3302: EXCEPTION
3303: WHEN fnd_api.g_exc_error THEN
3304: x_status := fnd_api.g_ret_sts_error;
3305: fnd_msg_pub.count_and_get
3306: (p_encoded => FND_API.g_false,
3307: p_count => l_msg_count,
3308: p_data => x_message
3309: );
3310:

Line 3311: WHEN fnd_api.g_exc_unexpected_error THEN

3307: p_count => l_msg_count,
3308: p_data => x_message
3309: );
3310:
3311: WHEN fnd_api.g_exc_unexpected_error THEN
3312: x_status := fnd_api.g_ret_sts_unexp_error ;
3313: fnd_msg_pub.count_and_get
3314: (p_encoded => FND_API.g_false,
3315: p_count => l_msg_count,

Line 3312: x_status := fnd_api.g_ret_sts_unexp_error ;

3308: p_data => x_message
3309: );
3310:
3311: WHEN fnd_api.g_exc_unexpected_error THEN
3312: x_status := fnd_api.g_ret_sts_unexp_error ;
3313: fnd_msg_pub.count_and_get
3314: (p_encoded => FND_API.g_false,
3315: p_count => l_msg_count,
3316: p_data => x_message

Line 3314: (p_encoded => FND_API.g_false,

3310:
3311: WHEN fnd_api.g_exc_unexpected_error THEN
3312: x_status := fnd_api.g_ret_sts_unexp_error ;
3313: fnd_msg_pub.count_and_get
3314: (p_encoded => FND_API.g_false,
3315: p_count => l_msg_count,
3316: p_data => x_message
3317: );
3318:

Line 3320: x_status := fnd_api.g_ret_sts_unexp_error ;

3316: p_data => x_message
3317: );
3318:
3319: WHEN OTHERS THEN
3320: x_status := fnd_api.g_ret_sts_unexp_error ;
3321: fnd_msg_pub.count_and_get
3322: (p_encoded => FND_API.g_false,
3323: p_count => l_msg_count,
3324: p_data => x_message

Line 3322: (p_encoded => FND_API.g_false,

3318:
3319: WHEN OTHERS THEN
3320: x_status := fnd_api.g_ret_sts_unexp_error ;
3321: fnd_msg_pub.count_and_get
3322: (p_encoded => FND_API.g_false,
3323: p_count => l_msg_count,
3324: p_data => x_message
3325: );
3326:

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

3359: p_task_id IN NUMBER default null,
3360: p_country_code IN VARCHAR2 DEFAULT NULL
3361: )
3362: IS
3363: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3364: l_msg_count NUMBER;
3365: l_msg_data VARCHAR2(400);
3366: l_label_status VARCHAR2(500);
3367: l_progress VARCHAR2(10);

Line 3385: x_status := fnd_api.g_ret_sts_success;

3381: WHERE rti.group_id = INV_rcv_common_apis.g_rcv_global_var.interface_group_id
3382: GROUP BY decode(p_source_type, 'ASNEXP',rti.interface_transaction_id,'SHIPMENTEXP',rti.interface_transaction_id,null) ;
3383: -- GROUP BY rti.lpn_id;
3384: BEGIN
3385: x_status := fnd_api.g_ret_sts_success;
3386: l_progress := '10';
3387:
3388: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3389: select ood.set_of_books_id

Line 3405: IF x_status <> fnd_api.g_ret_sts_success THEN

3401: p_sob_id => inv_rcv_common_apis.g_po_startup_value.sob_id,
3402: x_return_status => x_status,
3403: x_error_code => x_message);
3404:
3405: IF x_status <> fnd_api.g_ret_sts_success THEN
3406: RETURN;
3407: END IF;
3408: IF p_shipment_header_id IS NULL THEN -- Added this check to fix bug no. 2159179
3409: IF p_po_header_id IS NULL AND p_item_id IS NULL THEN

Line 3410: x_status := fnd_api.g_ret_sts_error;

3406: RETURN;
3407: END IF;
3408: IF p_shipment_header_id IS NULL THEN -- Added this check to fix bug no. 2159179
3409: IF p_po_header_id IS NULL AND p_item_id IS NULL THEN
3410: x_status := fnd_api.g_ret_sts_error;
3411: RETURN;
3412: END IF;
3413: END IF;
3414:

Line 3422: x_status := fnd_api.g_ret_sts_error;

3418: AND p_source_type <> 'ASNCONFM' -- bug fix 2129249
3419: THEN
3420: l_progress := '40';
3421: IF p_item_id IS NULL AND p_item_desc IS NULL THEN
3422: x_status := fnd_api.g_ret_sts_error;
3423: RETURN;
3424: END IF;
3425: l_subinventory := p_subinventory;
3426: l_locator_id := p_locator_id;

Line 3463: IF l_return_status = FND_API.g_ret_sts_error THEN

3459: p_project_id => p_project_id,
3460: p_task_id => p_task_id,
3461: p_country_code => p_country_code);
3462:
3463: IF l_return_status = FND_API.g_ret_sts_error THEN
3464: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3465: FND_MSG_PUB.ADD;
3466: RAISE FND_API.G_EXC_ERROR;
3467: END IF;

Line 3466: RAISE FND_API.G_EXC_ERROR;

3462:
3463: IF l_return_status = FND_API.g_ret_sts_error THEN
3464: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3465: FND_MSG_PUB.ADD;
3466: RAISE FND_API.G_EXC_ERROR;
3467: END IF;
3468: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3469: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3470: FND_MSG_PUB.ADD;

Line 3468: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3464: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3465: FND_MSG_PUB.ADD;
3466: RAISE FND_API.G_EXC_ERROR;
3467: END IF;
3468: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3469: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3470: FND_MSG_PUB.ADD;
3471: RAISE FND_API.g_exc_unexpected_error;
3472: END IF;

Line 3471: RAISE FND_API.g_exc_unexpected_error;

3467: END IF;
3468: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3469: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3470: FND_MSG_PUB.ADD;
3471: RAISE FND_API.g_exc_unexpected_error;
3472: END IF;
3473:
3474: ELSIF p_shipment_header_id IS NOT NULL THEN
3475: l_progress := '50';

Line 3501: IF l_return_status = FND_API.g_ret_sts_error THEN

3497: p_task_id => p_task_id,
3498: p_country_code => p_country_code
3499: );
3500:
3501: IF l_return_status = FND_API.g_ret_sts_error THEN
3502: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
3503: FND_MSG_PUB.ADD;
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;

Line 3504: RAISE FND_API.G_EXC_ERROR;

3500:
3501: IF l_return_status = FND_API.g_ret_sts_error THEN
3502: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
3503: FND_MSG_PUB.ADD;
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;
3506:
3507:
3508: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3508: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;
3506:
3507:
3508: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3509: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.g_exc_unexpected_error;
3512: END IF;

Line 3511: RAISE FND_API.g_exc_unexpected_error;

3507:
3508: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3509: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.g_exc_unexpected_error;
3512: END IF;
3513: ELSE
3514: l_progress := '50';
3515:

Line 3533: IF l_return_status = FND_API.g_ret_sts_error THEN

3529: p_task_id => p_task_id,
3530: p_country_code => p_country_code
3531: );
3532:
3533: IF l_return_status = FND_API.g_ret_sts_error THEN
3534: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3535: FND_MSG_PUB.ADD;
3536: RAISE FND_API.G_EXC_ERROR;
3537: END IF;

Line 3536: RAISE FND_API.G_EXC_ERROR;

3532:
3533: IF l_return_status = FND_API.g_ret_sts_error THEN
3534: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3535: FND_MSG_PUB.ADD;
3536: RAISE FND_API.G_EXC_ERROR;
3537: END IF;
3538:
3539:
3540: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3540: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3536: RAISE FND_API.G_EXC_ERROR;
3537: END IF;
3538:
3539:
3540: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3541: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3542: FND_MSG_PUB.ADD;
3543: RAISE FND_API.g_exc_unexpected_error;
3544: END IF;

Line 3543: RAISE FND_API.g_exc_unexpected_error;

3539:
3540: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3541: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3542: FND_MSG_PUB.ADD;
3543: RAISE FND_API.g_exc_unexpected_error;
3544: END IF;
3545:
3546: END IF;
3547:

Line 3576: IF l_return_status = FND_API.g_ret_sts_error THEN

3572: p_country_code => p_country_code,
3573: p_item_desc => p_item_desc
3574: );
3575:
3576: IF l_return_status = FND_API.g_ret_sts_error THEN
3577: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD
3578: FND_MSG_PUB.ADD;
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;

Line 3579: RAISE FND_API.G_EXC_ERROR;

3575:
3576: IF l_return_status = FND_API.g_ret_sts_error THEN
3577: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD
3578: FND_MSG_PUB.ADD;
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581:
3582:
3583: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3583: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581:
3582:
3583: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3584: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3585: FND_MSG_PUB.ADD;
3586: RAISE FND_API.g_exc_unexpected_error;
3587: END IF;

Line 3586: RAISE FND_API.g_exc_unexpected_error;

3582:
3583: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3584: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3585: FND_MSG_PUB.ADD;
3586: RAISE FND_API.g_exc_unexpected_error;
3587: END IF;
3588:
3589:
3590: ELSE

Line 3612: IF l_return_status = FND_API.g_ret_sts_error THEN

3608: p_task_id => p_task_id,
3609: x_status => l_return_status,
3610: x_message => x_message,
3611: p_country_code => p_country_code);
3612: IF l_return_status = FND_API.g_ret_sts_error THEN
3613: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;

Line 3615: RAISE FND_API.G_EXC_ERROR;

3611: p_country_code => p_country_code);
3612: IF l_return_status = FND_API.g_ret_sts_error THEN
3613: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;
3617: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3618: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3619: FND_MSG_PUB.ADD;

Line 3617: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3613: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;
3617: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3618: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3619: FND_MSG_PUB.ADD;
3620: RAISE FND_API.g_exc_unexpected_error;
3621: END IF;

Line 3620: RAISE FND_API.g_exc_unexpected_error;

3616: END IF;
3617: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3618: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3619: FND_MSG_PUB.ADD;
3620: RAISE FND_API.g_exc_unexpected_error;
3621: END IF;
3622:
3623: END IF;
3624:

Line 3649: IF l_return_status = FND_API.g_ret_sts_error THEN

3645: x_message => x_message,
3646: p_project_id => p_project_id,
3647: p_task_id => p_task_id,
3648: p_country_code => p_country_code );
3649: IF l_return_status = FND_API.g_ret_sts_error THEN
3650: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3651: FND_MSG_PUB.ADD;
3652: RAISE FND_API.G_EXC_ERROR;
3653: END IF;

Line 3652: RAISE FND_API.G_EXC_ERROR;

3648: p_country_code => p_country_code );
3649: IF l_return_status = FND_API.g_ret_sts_error THEN
3650: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3651: FND_MSG_PUB.ADD;
3652: RAISE FND_API.G_EXC_ERROR;
3653: END IF;
3654: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3655: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3656: FND_MSG_PUB.ADD;

Line 3654: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3650: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3651: FND_MSG_PUB.ADD;
3652: RAISE FND_API.G_EXC_ERROR;
3653: END IF;
3654: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3655: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3656: FND_MSG_PUB.ADD;
3657: RAISE FND_API.g_exc_unexpected_error;
3658: END IF;

Line 3657: RAISE FND_API.g_exc_unexpected_error;

3653: END IF;
3654: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3655: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3656: FND_MSG_PUB.ADD;
3657: RAISE FND_API.g_exc_unexpected_error;
3658: END IF;
3659: END IF;
3660:
3661: l_progress := '80';

Line 3665: IF l_return_status <> FND_API.g_ret_sts_error THEN

3661: l_progress := '80';
3662: x_status := l_return_status; -- l_return_status can be 'W', we want to carry that over
3663:
3664: -- calling label printing API
3665: IF l_return_status <> FND_API.g_ret_sts_error THEN
3666: l_progress := '80';
3667:
3668:
3669: l_counter := 1;

Line 3690: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3686: , p_business_flow_code => 1
3687: , p_transaction_id => l_txn_id_tbl
3688: );
3689:
3690: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3691: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
3692: FND_MSG_PUB.ADD;
3693: x_status := 'W';
3694: END IF;

Line 3700: WHEN fnd_api.g_exc_error THEN

3696: END IF;
3697:
3698:
3699: EXCEPTION
3700: WHEN fnd_api.g_exc_error THEN
3701: x_status := fnd_api.g_ret_sts_error;
3702: fnd_msg_pub.count_and_get
3703: (p_encoded => FND_API.g_false,
3704: p_count => l_msg_count,

Line 3701: x_status := fnd_api.g_ret_sts_error;

3697:
3698:
3699: EXCEPTION
3700: WHEN fnd_api.g_exc_error THEN
3701: x_status := fnd_api.g_ret_sts_error;
3702: fnd_msg_pub.count_and_get
3703: (p_encoded => FND_API.g_false,
3704: p_count => l_msg_count,
3705: p_data => x_message

Line 3703: (p_encoded => FND_API.g_false,

3699: EXCEPTION
3700: WHEN fnd_api.g_exc_error THEN
3701: x_status := fnd_api.g_ret_sts_error;
3702: fnd_msg_pub.count_and_get
3703: (p_encoded => FND_API.g_false,
3704: p_count => l_msg_count,
3705: p_data => x_message
3706: );
3707:

Line 3708: WHEN fnd_api.g_exc_unexpected_error THEN

3704: p_count => l_msg_count,
3705: p_data => x_message
3706: );
3707:
3708: WHEN fnd_api.g_exc_unexpected_error THEN
3709: x_status := fnd_api.g_ret_sts_unexp_error ;
3710: fnd_msg_pub.count_and_get
3711: (p_encoded => FND_API.g_false,
3712: p_count => l_msg_count,

Line 3709: x_status := fnd_api.g_ret_sts_unexp_error ;

3705: p_data => x_message
3706: );
3707:
3708: WHEN fnd_api.g_exc_unexpected_error THEN
3709: x_status := fnd_api.g_ret_sts_unexp_error ;
3710: fnd_msg_pub.count_and_get
3711: (p_encoded => FND_API.g_false,
3712: p_count => l_msg_count,
3713: p_data => x_message

Line 3711: (p_encoded => FND_API.g_false,

3707:
3708: WHEN fnd_api.g_exc_unexpected_error THEN
3709: x_status := fnd_api.g_ret_sts_unexp_error ;
3710: fnd_msg_pub.count_and_get
3711: (p_encoded => FND_API.g_false,
3712: p_count => l_msg_count,
3713: p_data => x_message
3714: );
3715:

Line 3717: x_status := fnd_api.g_ret_sts_unexp_error ;

3713: p_data => x_message
3714: );
3715:
3716: WHEN OTHERS THEN
3717: x_status := fnd_api.g_ret_sts_unexp_error ;
3718: fnd_msg_pub.count_and_get
3719: (p_encoded => FND_API.g_false,
3720: p_count => l_msg_count,
3721: p_data => x_message

Line 3719: (p_encoded => FND_API.g_false,

3715:
3716: WHEN OTHERS THEN
3717: x_status := fnd_api.g_ret_sts_unexp_error ;
3718: fnd_msg_pub.count_and_get
3719: (p_encoded => FND_API.g_false,
3720: p_count => l_msg_count,
3721: p_data => x_message
3722: );
3723: