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_ROI_INTEGRATION_GRP dependencies on FND_API

Line 106: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,

102: x_return_status OUT NOCOPY VARCHAR2 ,
103: x_msg_data OUT NOCOPY VARCHAR2 ,
104: x_msg_count OUT NOCOPY NUMBER ,
105: p_api_version IN NUMBER DEFAULT 1.0 ,
106: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
107: p_mtlt_rowid IN ROWID ,
108: p_transaction_type_id IN VARCHAR2 ,
109: p_new_lot IN VARCHAR2 ,
110: p_item_id IN NUMBER ,

Line 213: IF NOT fnd_api.compatible_api_call(

209:
210: BEGIN
211:
212: -- Standard call to check for call compatibility.
213: IF NOT fnd_api.compatible_api_call(
214: l_api_version,
215: p_api_version,
216: l_api_name,
217: 'INV_ROI_INTEGRATION_GRP'

Line 220: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT: '||l_progress, 1);

216: l_api_name,
217: 'INV_ROI_INTEGRATION_GRP'
218: ) THEN
219: IF (g_debug = 1) THEN
220: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT: '||l_progress, 1);
221: END IF;
222: RAISE fnd_api.g_exc_unexpected_error;
223: END IF;
224:

Line 222: RAISE fnd_api.g_exc_unexpected_error;

218: ) THEN
219: IF (g_debug = 1) THEN
220: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT: '||l_progress, 1);
221: END IF;
222: RAISE fnd_api.g_exc_unexpected_error;
223: END IF;
224:
225: l_progress := '002';
226:

Line 228: IF fnd_api.to_boolean(p_init_msg_lst) THEN

224:
225: l_progress := '002';
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF fnd_api.to_boolean(p_init_msg_lst) THEN
229: fnd_msg_pub.initialize;
230: END IF;
231:
232: --Initialize the return status

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229: fnd_msg_pub.initialize;
230: END IF;
231:
232: --Initialize the return status
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: /*Defaulting of origination type to 'Purchasing' to be done
236: in INV_RCV_INTEGRATION_PVT.MOVE_LOT_SERIAL_INFO */
237:

Line 450: p_init_msg_list =>FND_API.G_FALSE ,

446: x_return_status =>l_return_status ,
447: x_msg_data =>l_msg_data ,
448: x_msg_count =>l_msg_count ,
449: p_api_version =>1.0 ,
450: p_init_msg_list =>FND_API.G_FALSE ,
451: p_item_id =>p_item_id ,
452: p_lot_number =>p_lot_number ,
453: p_oe_order_header_id =>p_OE_ORDER_HEADER_ID ,
454: p_oe_order_line_id =>p_OE_ORDER_LINE_ID ,

Line 485: IF l_return_status = fnd_api.g_ret_sts_error THEN

481: END IF;
482:
483: l_progress := '007' ;
484:
485: IF l_return_status = fnd_api.g_ret_sts_error THEN
486: IF g_debug = 1 THEN
487: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a user defined exception '|| l_progress, 1);
488: END IF;
489: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 496: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

492: RAISE g_exc_error;
493:
494: l_progress := '008' ;
495:
496: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
497: IF g_debug = 1 THEN
498: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a Unexpected exception ' || l_progress , 1);
499: END IF;
500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 522: x_return_status := FND_API.G_RET_STS_SUCCESS;

518: lot or create new lot and no quantity validation required.
519: Take RMA validation as Success: ' || l_progress, 1);
520: END IF;
521:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: END IF;--------IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(
524:
525: END IF;--------IF l_enforce_rma_lot_value = 'R' THEN
526:

Line 561: IF l_return_status = fnd_api.g_ret_sts_error THEN

557: IF g_debug = 1 THEN
558: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);
559: END IF;
560:
561: IF l_return_status = fnd_api.g_ret_sts_error THEN
562: IF g_debug = 1 THEN
563: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
564: END IF;
565: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;

Line 571: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

567: FND_MSG_PUB.ADD;
568: RAISE g_exc_error;
569: END IF;
570:
571: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
572: IF g_debug = 1 THEN
573: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
574: END IF;
575: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 587: x_return_status := fnd_api.g_ret_sts_error;

583: print_debug(' Item is not lot controlled ', 9);
584: END IF;
585: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
586: fnd_msg_pub.ADD;
587: x_return_status := fnd_api.g_ret_sts_error;
588: RAISE g_exc_error;
589: END IF ;
590:
591: IF (l_child_lot_cont = FALSE AND p_parent_lot_number IS NOT NULL) THEN

Line 597: x_return_status := fnd_api.g_ret_sts_error;

593: print_debug(' Item is not Child lot controlled ', 9);
594: END IF;
595: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
596: fnd_msg_pub.ADD;
597: x_return_status := fnd_api.g_ret_sts_error;
598: RAISE g_exc_error;
599: END IF ;
600:
601:

Line 633: , p_init_msg_list => FND_API.G_FALSE

629:
630: print_debug('Calling inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
631: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (
632: p_api_version => 1.0
633: , p_init_msg_list => FND_API.G_FALSE
634: , p_commit => FND_API.G_FALSE
635: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
636: , p_rti_id => p_rti_id
637: , p_transaction_type_id => p_transaction_type_id

Line 634: , p_commit => FND_API.G_FALSE

630: print_debug('Calling inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
631: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (
632: p_api_version => 1.0
633: , p_init_msg_list => FND_API.G_FALSE
634: , p_commit => FND_API.G_FALSE
635: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
636: , p_rti_id => p_rti_id
637: , p_transaction_type_id => p_transaction_type_id
638: , p_lot_number => p_lot_number

Line 635: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

631: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (
632: p_api_version => 1.0
633: , p_init_msg_list => FND_API.G_FALSE
634: , p_commit => FND_API.G_FALSE
635: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
636: , p_rti_id => p_rti_id
637: , p_transaction_type_id => p_transaction_type_id
638: , p_lot_number => p_lot_number
639: , p_lot_quantity => p_lot_primary_qty

Line 648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

644: , x_msg_count => l_msg_count
645: , x_msg_data => l_msg_data
646: );
647:
648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
649: print_debug('Lot Indivisiblity check failure in inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: END IF;

Line 650: RAISE FND_API.G_EXC_ERROR;

646: );
647:
648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
649: print_debug('Lot Indivisiblity check failure in inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: END IF;
653:
654: -- END Bug# 4233182

Line 766: ,p_init_msg_list =>FND_API.G_FALSE

762: -----IF l_lot_ind_call = 'Y' THEN
763:
764: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
765: p_api_version =>1.0
766: ,p_init_msg_list =>FND_API.G_FALSE
767: ,p_commit =>FND_API.G_FALSE
768: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
769: ,p_transaction_type_id =>l_transaction_type_id
770: ,p_organization_id =>p_to_organization_id

Line 767: ,p_commit =>FND_API.G_FALSE

763:
764: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
765: p_api_version =>1.0
766: ,p_init_msg_list =>FND_API.G_FALSE
767: ,p_commit =>FND_API.G_FALSE
768: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
769: ,p_transaction_type_id =>l_transaction_type_id
770: ,p_organization_id =>p_to_organization_id
771: ,p_inventory_item_id =>p_item_id

Line 768: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL

764: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
765: p_api_version =>1.0
766: ,p_init_msg_list =>FND_API.G_FALSE
767: ,p_commit =>FND_API.G_FALSE
768: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
769: ,p_transaction_type_id =>l_transaction_type_id
770: ,p_organization_id =>p_to_organization_id
771: ,p_inventory_item_id =>p_item_id
772: ,p_revision =>p_revision

Line 794: IF ((l_return_status <> FND_API.G_RET_STS_SUCCESS) AND l_transaction_type IN ('RETURN TO RECEIVING','RETURN TO VENDOR','RETURN TO CUSTOMER')) THEN

790:
791: /* Enhancement #4019704. Allow Return transactions even if lot indivisibility fails but the
792: transaction quantity is equal to the received quantity. Punit Kumar. 02-Dec-2004. */
793: /*I
794: IF ((l_return_status <> FND_API.G_RET_STS_SUCCESS) AND l_transaction_type IN ('RETURN TO RECEIVING','RETURN TO VENDOR','RETURN TO CUSTOMER')) THEN
795:
796: l_progress := '101';
797:
798: l_lot_qty := p_lot_quantity ;

Line 877: l_return_status := FND_API.G_RET_STS_SUCCESS ;

873: IF g_debug = 1 THEN
874: print_debug('l_return_status'|| l_return_status, 9);
875: END IF;
876:
877: l_return_status := FND_API.G_RET_STS_SUCCESS ;
878:
879: IF g_debug = 1 THEN
880: print_debug('l_return_status'|| l_return_status, 9);
881: print_debug('set return status of validate_lot_indivisible to true'|| l_progress, 9);

Line 890: IF l_return_status = fnd_api.g_ret_sts_error THEN

886: END IF; -------- IF (l_transaction_type IN ('RETURN TO RECEIVING'
887:
888: /* end , enhancement */
889: /* I
890: IF l_return_status = fnd_api.g_ret_sts_error THEN
891: IF g_debug = 1 THEN
892: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);
893: END IF;
894:

Line 900: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

896: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
897: fnd_msg_pub.ADD;
898: RAISE g_exc_error;
899:
900: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
901: l_progress := '012' ;
902: IF g_debug = 1 THEN
903: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);
904: END IF;

Line 910: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN

906: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
907: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
908: fnd_msg_pub.ADD;
909: RAISE g_exc_unexpected_error;
910: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
911:
912: END IF; ----IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
913:
914: IF g_debug = 1 THEN

Line 1340: x_return_status := fnd_api.g_ret_sts_error;

1336:
1337: EXCEPTION
1338:
1339: WHEN NO_DATA_FOUND THEN
1340: x_return_status := fnd_api.g_ret_sts_error;
1341: fnd_msg_pub.count_and_get(
1342: p_encoded => fnd_api.g_false ,
1343: p_count => x_msg_count ,
1344: p_data => x_msg_data

Line 1342: p_encoded => fnd_api.g_false ,

1338:
1339: WHEN NO_DATA_FOUND THEN
1340: x_return_status := fnd_api.g_ret_sts_error;
1341: fnd_msg_pub.count_and_get(
1342: p_encoded => fnd_api.g_false ,
1343: p_count => x_msg_count ,
1344: p_data => x_msg_data
1345: );
1346: IF( x_msg_count > 1 ) THEN

Line 1349: FND_API.G_FALSE

1345: );
1346: IF( x_msg_count > 1 ) THEN
1347: x_msg_data := fnd_msg_pub.get(
1348: x_msg_count ,
1349: FND_API.G_FALSE
1350: );
1351: END IF ;
1352: IF g_debug = 1 THEN
1353: print_debug('Exitting INV_VALIDATE_LOT - No data found error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 1360: x_return_status := fnd_api.g_ret_sts_error;

1356:
1357: WHEN INVALID_ITEM THEN
1358: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1359: FND_MSG_PUB.ADD;
1360: x_return_status := fnd_api.g_ret_sts_error;
1361: fnd_msg_pub.count_and_get(
1362: p_encoded => fnd_api.g_false ,
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data

Line 1362: p_encoded => fnd_api.g_false ,

1358: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1359: FND_MSG_PUB.ADD;
1360: x_return_status := fnd_api.g_ret_sts_error;
1361: fnd_msg_pub.count_and_get(
1362: p_encoded => fnd_api.g_false ,
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data
1365: );
1366: IF( x_msg_count > 1 ) THEN

Line 1369: FND_API.G_FALSE

1365: );
1366: IF( x_msg_count > 1 ) THEN
1367: x_msg_data := fnd_msg_pub.get(
1368: x_msg_count ,
1369: FND_API.G_FALSE
1370: );
1371: END IF ;
1372:
1373: IF g_debug = 1 THEN

Line 1380: x_return_status := fnd_api.g_ret_sts_error;

1376: END IF;
1377:
1378:
1379: WHEN g_exc_error THEN
1380: x_return_status := fnd_api.g_ret_sts_error;
1381: fnd_msg_pub.count_and_get(
1382: p_encoded => fnd_api.g_false ,
1383: p_count => x_msg_count ,
1384: p_data => x_msg_data

Line 1382: p_encoded => fnd_api.g_false ,

1378:
1379: WHEN g_exc_error THEN
1380: x_return_status := fnd_api.g_ret_sts_error;
1381: fnd_msg_pub.count_and_get(
1382: p_encoded => fnd_api.g_false ,
1383: p_count => x_msg_count ,
1384: p_data => x_msg_data
1385: );
1386: IF( x_msg_count > 1 ) THEN

Line 1389: FND_API.G_FALSE

1385: );
1386: IF( x_msg_count > 1 ) THEN
1387: x_msg_data := fnd_msg_pub.get(
1388: x_msg_count ,
1389: FND_API.G_FALSE
1390: );
1391: END IF;
1392:
1393: IF g_debug = 1 THEN

Line 1400: x_return_status := fnd_api.g_ret_sts_unexp_error;

1396: END IF;
1397:
1398:
1399: WHEN g_exc_unexpected_error THEN
1400: x_return_status := fnd_api.g_ret_sts_unexp_error;
1401: fnd_msg_pub.count_and_get(
1402: p_encoded => fnd_api.g_false ,
1403: p_count => x_msg_count ,
1404: p_data => x_msg_data

Line 1402: p_encoded => fnd_api.g_false ,

1398:
1399: WHEN g_exc_unexpected_error THEN
1400: x_return_status := fnd_api.g_ret_sts_unexp_error;
1401: fnd_msg_pub.count_and_get(
1402: p_encoded => fnd_api.g_false ,
1403: p_count => x_msg_count ,
1404: p_data => x_msg_data
1405: );
1406: IF( x_msg_count > 1 ) THEN

Line 1409: FND_API.G_FALSE

1405: );
1406: IF( x_msg_count > 1 ) THEN
1407: x_msg_data := fnd_msg_pub.get(
1408: x_msg_count ,
1409: FND_API.G_FALSE
1410: );
1411: END IF ;
1412:
1413: IF g_debug = 1 THEN

Line 1419: x_return_status := fnd_api.g_ret_sts_unexp_error;

1415: --------print_stacked_messages;
1416: END IF;
1417:
1418: WHEN OTHERS THEN
1419: x_return_status := fnd_api.g_ret_sts_unexp_error;
1420: fnd_msg_pub.count_and_get(
1421: p_encoded => fnd_api.g_false ,
1422: p_count => x_msg_count ,
1423: p_data => x_msg_data

Line 1421: p_encoded => fnd_api.g_false ,

1417:
1418: WHEN OTHERS THEN
1419: x_return_status := fnd_api.g_ret_sts_unexp_error;
1420: fnd_msg_pub.count_and_get(
1421: p_encoded => fnd_api.g_false ,
1422: p_count => x_msg_count ,
1423: p_data => x_msg_data
1424: );
1425: IF( x_msg_count > 1 ) THEN

Line 1428: FND_API.G_FALSE);

1424: );
1425: IF( x_msg_count > 1 ) THEN
1426: x_msg_data := fnd_msg_pub.get(
1427: x_msg_count ,
1428: FND_API.G_FALSE);
1429: END IF;
1430:
1431: IF g_debug = 1 THEN
1432: print_debug('Exitting INV_VALIDATE_LOT - In others error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 1472: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,

1468: x_return_status OUT NOCOPY VARCHAR2 ,
1469: x_msg_count OUT NOCOPY NUMBER ,
1470: x_msg_data OUT NOCOPY VARCHAR2 ,
1471: p_api_version IN NUMBER DEFAULT 1.0 ,
1472: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
1473: p_source_document_code IN VARCHAR2 ,
1474: p_item_id IN NUMBER ,
1475: p_from_organization_id IN NUMBER ,
1476: p_to_organization_id IN NUMBER ,

Line 1531: IF NOT fnd_api.compatible_api_call(

1527:
1528: l_progress := '024';
1529:
1530: -- Standard call to check for call compatibility.
1531: IF NOT fnd_api.compatible_api_call(
1532: l_api_version ,
1533: p_api_version ,
1534: l_api_name ,
1535: 'INV_ROI_INTEGRATION_GRP'

Line 1538: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);

1534: l_api_name ,
1535: 'INV_ROI_INTEGRATION_GRP'
1536: ) THEN
1537: IF (g_debug = 1) THEN
1538: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);
1539: END IF;
1540: RAISE fnd_api.g_exc_unexpected_error;
1541: END IF;
1542:

Line 1540: RAISE fnd_api.g_exc_unexpected_error;

1536: ) THEN
1537: IF (g_debug = 1) THEN
1538: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);
1539: END IF;
1540: RAISE fnd_api.g_exc_unexpected_error;
1541: END IF;
1542:
1543: /* Initialize message list if p_init_msg_list is set to TRUE. */
1544: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1544: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1540: RAISE fnd_api.g_exc_unexpected_error;
1541: END IF;
1542:
1543: /* Initialize message list if p_init_msg_list is set to TRUE. */
1544: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1545: fnd_msg_pub.initialize;
1546: END IF;
1547:
1548: /*Initialize the return status */

Line 1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

1545: fnd_msg_pub.initialize;
1546: END IF;
1547:
1548: /*Initialize the return status */
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;
1550:
1551: /* Checking for Inter-Org transfer */
1552:
1553: IF p_source_document_code IN ( 'INVENTORY','REQ') THEN

Line 1665: , p_commit => fnd_api.g_false

1661: , p_copy_lot_attribute_flag => 'N'
1662: , p_source => l_source
1663: , p_api_version => l_api_version
1664: , p_init_msg_list => p_init_msg_lst
1665: , p_commit => fnd_api.g_false
1666: , x_child_lot_rec => l_lot_rec
1667: , x_return_status => l_return_status
1668: , x_msg_count => l_msg_count
1669: , x_msg_data => l_msg_data

Line 1674: if l_return_status = fnd_api.g_ret_sts_error then

1670: );
1671: if g_debug = 1 then
1672: print_debug('Program IINV_LOT_API_PKG.Populate_Lot_Records return ' || x_return_status, 9);
1673: end if;
1674: if l_return_status = fnd_api.g_ret_sts_error then
1675: if g_debug = 1 then
1676: print_debug('Program IINV_LOT_API_PKG.Populate_Lot_Records failed with a user defined exception', 9);
1677: end if;
1678: RAISE g_exc_unexpected_error;

Line 1679: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

1675: if g_debug = 1 then
1676: print_debug('Program IINV_LOT_API_PKG.Populate_Lot_Records failed with a user defined exception', 9);
1677: end if;
1678: RAISE g_exc_unexpected_error;
1679: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
1680: if g_debug = 1 then
1681: print_debug('Program INV_LOT_API_PKG.POPULATE_LOT_RECORDS has failed with a Unexpected exception', 9);
1682: end if;
1683: RAISE g_exc_unexpected_error;

Line 1812: p_init_msg_list => fnd_api.g_false ,

1808: x_lot_rec => x_lot_rec ,
1809: p_lot_rec => l_lot_rec ,
1810: p_source => l_source ,
1811: p_api_version => l_api_version ,
1812: p_init_msg_list => fnd_api.g_false ,
1813: p_commit => fnd_api.g_false ,
1814: p_validation_level => fnd_api.g_valid_level_full ,
1815: p_origin_txn_id => p_to_organization_id
1816: );

Line 1813: p_commit => fnd_api.g_false ,

1809: p_lot_rec => l_lot_rec ,
1810: p_source => l_source ,
1811: p_api_version => l_api_version ,
1812: p_init_msg_list => fnd_api.g_false ,
1813: p_commit => fnd_api.g_false ,
1814: p_validation_level => fnd_api.g_valid_level_full ,
1815: p_origin_txn_id => p_to_organization_id
1816: );
1817: l_progress := '272';

Line 1814: p_validation_level => fnd_api.g_valid_level_full ,

1810: p_source => l_source ,
1811: p_api_version => l_api_version ,
1812: p_init_msg_list => fnd_api.g_false ,
1813: p_commit => fnd_api.g_false ,
1814: p_validation_level => fnd_api.g_valid_level_full ,
1815: p_origin_txn_id => p_to_organization_id
1816: );
1817: l_progress := '272';
1818:

Line 1871: IF l_return_status = fnd_api.g_ret_sts_error THEN

1867: print_debug('x_lot_rec.EXPIRATION_ACTION_CODE:'|| x_lot_rec.EXPIRATION_ACTION_CODE ||':'|| l_progress, 1);
1868: print_debug('x_lot_rec.HOLD_DATE :'||x_lot_rec.HOLD_DATE ||':'|| l_progress, 1);
1869: END IF;
1870:
1871: IF l_return_status = fnd_api.g_ret_sts_error THEN
1872: IF g_debug = 1 THEN
1873: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a user defined exception : ' || l_progress, 9);
1874: END IF;
1875: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1877: fnd_msg_pub.ADD;
1878: RAISE g_exc_error;
1879:
1880: l_progress := '028' ;
1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1882: IF g_debug = 1 THEN
1883: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a Unexpected exception :'|| l_progress, 9);
1884: END IF;
1885: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 2161: p_init_msg_list =>FND_API.G_FALSE ,

2157:
2158:
2159: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2160: p_api_version =>1.0 ,
2161: p_init_msg_list =>FND_API.G_FALSE ,
2162: p_commit =>FND_API.G_TRUE ,
2163: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,
2164: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2165: p_update_type_indicator =>5 ,

Line 2162: p_commit =>FND_API.G_TRUE ,

2158:
2159: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2160: p_api_version =>1.0 ,
2161: p_init_msg_list =>FND_API.G_FALSE ,
2162: p_commit =>FND_API.G_TRUE ,
2163: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,
2164: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2165: p_update_type_indicator =>5 ,
2166: p_reason_id =>p_reason_id ,

Line 2163: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,

2159: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2160: p_api_version =>1.0 ,
2161: p_init_msg_list =>FND_API.G_FALSE ,
2162: p_commit =>FND_API.G_TRUE ,
2163: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,
2164: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2165: p_update_type_indicator =>5 ,
2166: p_reason_id =>p_reason_id ,
2167: p_batch_id =>NULL /*(Since we are not updating batch quantities)*/ ,

Line 2168: p_process_data =>'Y', -- Bug 4019726 FND_API.G_TRUE ,

2164: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2165: p_update_type_indicator =>5 ,
2166: p_reason_id =>p_reason_id ,
2167: p_batch_id =>NULL /*(Since we are not updating batch quantities)*/ ,
2168: p_process_data =>'Y', -- Bug 4019726 FND_API.G_TRUE ,
2169: p_lot_uom_conv_rec =>p_lot_uom_conv_rec ,
2170: p_qty_update_tbl =>l_qty_update_tbl ,
2171: x_return_status =>l_return_status ,
2172: x_msg_count =>l_msg_count ,

Line 2195: IF l_return_status = fnd_api.g_ret_sts_error THEN

2191: print_debug('x_return_status:'||l_return_status, 1);
2192: print_debug('x_msg_count:'||l_msg_count, 1);
2193: END IF;
2194:
2195: IF l_return_status = fnd_api.g_ret_sts_error THEN
2196: IF g_debug = 1 THEN
2197: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2198: END IF;
2199: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 2206: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2202: RAISE g_exc_error;
2203:
2204: l_progress := '036';
2205:
2206: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2207: IF g_debug = 1 THEN
2208: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2209: END IF;
2210: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 2227: x_return_status := fnd_api.g_ret_sts_error;

2223:
2224: EXCEPTION
2225:
2226: WHEN NO_DATA_FOUND THEN
2227: x_return_status := fnd_api.g_ret_sts_error;
2228: /*
2229: IF l_progress = '002' THEN
2230: ROLLBACK TO inv_new_lot_save2;
2231: ELSIF l_progress = '006' THEN

Line 2236: p_encoded => fnd_api.g_false ,

2232: ROLLBACK TO inv_new_lot_save6;
2233: END IF;
2234: */
2235: fnd_msg_pub.count_and_get(
2236: p_encoded => fnd_api.g_false ,
2237: p_count => x_msg_count ,
2238: p_data => x_msg_data
2239: );
2240:

Line 2244: FND_API.G_FALSE

2240:
2241: IF( x_msg_count > 1 ) THEN
2242: x_msg_data := fnd_msg_pub.get(
2243: x_msg_count ,
2244: FND_API.G_FALSE
2245: );
2246: END IF ;
2247: IF g_debug = 1 THEN
2248: print_debug('Exitting INV_NEW_LOT - No data found error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2253: x_return_status := fnd_api.g_ret_sts_error;

2249: print_stacked_messages;
2250: END IF;
2251:
2252: WHEN g_exc_error THEN
2253: x_return_status := fnd_api.g_ret_sts_error;
2254: /*
2255: IF l_progress = '002' THEN
2256: ROLLBACK TO inv_new_lot_save2;
2257: ELSIF l_progress = '006' THEN

Line 2262: p_encoded => fnd_api.g_false ,

2258: ROLLBACK TO inv_new_lot_save6;
2259: END IF;
2260: */
2261: fnd_msg_pub.count_and_get(
2262: p_encoded => fnd_api.g_false ,
2263: p_count => x_msg_count ,
2264: p_data => x_msg_data
2265: );
2266:

Line 2270: FND_API.G_FALSE

2266:
2267: IF( x_msg_count > 1 ) THEN
2268: x_msg_data := fnd_msg_pub.get(
2269: x_msg_count ,
2270: FND_API.G_FALSE
2271: );
2272: END IF;
2273:
2274: IF g_debug = 1 THEN

Line 2280: x_return_status := fnd_api.g_ret_sts_unexp_error;

2276: print_stacked_messages;
2277: END IF;
2278:
2279: WHEN g_exc_unexpected_error THEN
2280: x_return_status := fnd_api.g_ret_sts_unexp_error;
2281: /*
2282: IF l_progress = '002' THEN
2283: ROLLBACK TO inv_new_lot_save2;
2284: ELSIF l_progress = '006' THEN

Line 2289: p_encoded => fnd_api.g_false ,

2285: ROLLBACK TO inv_new_lot_save6;
2286: END IF;
2287: */
2288: fnd_msg_pub.count_and_get(
2289: p_encoded => fnd_api.g_false ,
2290: p_count => x_msg_count ,
2291: p_data => x_msg_data
2292: );
2293:

Line 2297: FND_API.G_FALSE);

2293:
2294: IF( x_msg_count > 1 ) THEN
2295: x_msg_data := fnd_msg_pub.get(
2296: x_msg_count ,
2297: FND_API.G_FALSE);
2298: END IF ;
2299:
2300: IF g_debug = 1 THEN
2301: print_debug('Exitting INV_NEW_LOT - g_exc_unexpected_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2306: x_return_status := fnd_api.g_ret_sts_unexp_error;

2302: print_stacked_messages;
2303: END IF;
2304:
2305: WHEN OTHERS THEN
2306: x_return_status := fnd_api.g_ret_sts_unexp_error;
2307: /*
2308: IF l_progress = '002' THEN
2309: ROLLBACK TO inv_new_lot_save2;
2310: ELSIF l_progress = '006' THEN

Line 2315: p_encoded => fnd_api.g_false ,

2311: ROLLBACK TO inv_new_lot_save6;
2312: END IF;
2313: */
2314: fnd_msg_pub.count_and_get(
2315: p_encoded => fnd_api.g_false ,
2316: p_count => x_msg_count ,
2317: p_data => x_msg_data
2318: );
2319:

Line 2323: FND_API.G_FALSE);

2319:
2320: IF( x_msg_count > 1 ) THEN
2321: x_msg_data := fnd_msg_pub.get(
2322: x_msg_count ,
2323: FND_API.G_FALSE);
2324: END IF;
2325:
2326: IF g_debug = 1 THEN
2327: print_debug('Exitting INV_NEW_LOT - OTHERS error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2370: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,

2366: x_msg_count OUT NOCOPY NUMBER ,
2367: x_sum_sourcedoc_quantity OUT NOCOPY NUMBER ,
2368: x_sum_rti_secondary_quantity OUT NOCOPY NUMBER ,
2369: p_api_version IN NUMBER DEFAULT 1.0 ,
2370: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
2371: p_inventory_item_id IN NUMBER ,
2372: p_to_organization_id IN NUMBER ,
2373: p_lot_number IN VARCHAR2 ,
2374: p_transaction_unit_of_measure IN VARCHAR2 ,

Line 2399: IF NOT fnd_api.compatible_api_call(

2395:
2396: l_progress :='037';
2397:
2398: -- Standard call to check for call compatibility.
2399: IF NOT fnd_api.compatible_api_call(
2400: l_api_version,
2401: p_api_version,
2402: l_api_name,
2403: 'INV_ROI_INTEGRATION_GRP'

Line 2406: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);

2402: l_api_name,
2403: 'INV_ROI_INTEGRATION_GRP'
2404: ) THEN
2405: IF (g_debug = 1) THEN
2406: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);
2407: END IF;
2408: RAISE fnd_api.g_exc_unexpected_error;
2409: END IF;
2410:

Line 2408: RAISE fnd_api.g_exc_unexpected_error;

2404: ) THEN
2405: IF (g_debug = 1) THEN
2406: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);
2407: END IF;
2408: RAISE fnd_api.g_exc_unexpected_error;
2409: END IF;
2410:
2411: -- Initialize message list if p_init_msg_list is set to TRUE.
2412: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 2412: IF fnd_api.to_boolean(p_init_msg_lst) THEN

2408: RAISE fnd_api.g_exc_unexpected_error;
2409: END IF;
2410:
2411: -- Initialize message list if p_init_msg_list is set to TRUE.
2412: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2413: fnd_msg_pub.initialize;
2414: END IF;
2415:
2416: --Initialize the return status

Line 2417: x_return_status := FND_API.G_RET_STS_SUCCESS;

2413: fnd_msg_pub.initialize;
2414: END IF;
2415:
2416: --Initialize the return status
2417: x_return_status := FND_API.G_RET_STS_SUCCESS;
2418:
2419: BEGIN
2420: l_progress :='038';
2421:

Line 2446: RAISE fnd_api.g_exc_error;

2442: WHEN OTHERS THEN
2443: IF g_debug = 1 THEN
2444: print_debug('Fetching uom class failed in synch_secondary_quantity:' || l_progress, 1);
2445: END IF;
2446: RAISE fnd_api.g_exc_error;
2447: END;
2448:
2449: l_progress:='039';
2450:

Line 2539: x_return_status := fnd_api.g_ret_sts_unexp_error;

2535: */
2536: EXCEPTION
2537:
2538: WHEN g_exc_unexpected_error THEN
2539: x_return_status := fnd_api.g_ret_sts_unexp_error;
2540: fnd_msg_pub.count_and_get(
2541: p_encoded => fnd_api.g_false ,
2542: p_count => x_msg_count ,
2543: p_data => x_msg_data

Line 2541: p_encoded => fnd_api.g_false ,

2537:
2538: WHEN g_exc_unexpected_error THEN
2539: x_return_status := fnd_api.g_ret_sts_unexp_error;
2540: fnd_msg_pub.count_and_get(
2541: p_encoded => fnd_api.g_false ,
2542: p_count => x_msg_count ,
2543: p_data => x_msg_data
2544: );
2545: IF( x_msg_count > 1 ) THEN

Line 2548: FND_API.G_FALSE

2544: );
2545: IF( x_msg_count > 1 ) THEN
2546: x_msg_data := fnd_msg_pub.get(
2547: x_msg_count ,
2548: FND_API.G_FALSE
2549: );
2550: END IF ;
2551:
2552: IF g_debug = 1 THEN

Line 2558: x_return_status := fnd_api.g_ret_sts_unexp_error;

2554: print_stacked_messages;
2555: END IF;
2556:
2557: WHEN OTHERS THEN
2558: x_return_status := fnd_api.g_ret_sts_unexp_error;
2559: fnd_msg_pub.count_and_get(
2560: p_encoded => fnd_api.g_false ,
2561: p_count => x_msg_count ,
2562: p_data => x_msg_data

Line 2560: p_encoded => fnd_api.g_false ,

2556:
2557: WHEN OTHERS THEN
2558: x_return_status := fnd_api.g_ret_sts_unexp_error;
2559: fnd_msg_pub.count_and_get(
2560: p_encoded => fnd_api.g_false ,
2561: p_count => x_msg_count ,
2562: p_data => x_msg_data
2563: );
2564: IF( x_msg_count > 1 ) THEN

Line 2567: FND_API.G_FALSE);

2563: );
2564: IF( x_msg_count > 1 ) THEN
2565: x_msg_data := fnd_msg_pub.get(
2566: x_msg_count ,
2567: FND_API.G_FALSE);
2568: END IF;
2569:
2570: IF g_debug = 1 THEN
2571: print_debug('Exitting INV_Synch_Quantities - Others error :'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2636: RAISE fnd_api.g_exc_error;

2632: WHEN OTHERS THEN
2633: IF g_debug = 1 THEN
2634: print_debug('Fetching RMA lot inside inv_roi_integration_grp.inv_rma_lot_info_exists failed:' || l_progress, 1);
2635: END IF;
2636: RAISE fnd_api.g_exc_error;
2637: END;
2638: l_progress :='062';
2639:
2640: IF x_count_rma_lots = 0 THEN

Line 2657: p_encoded => fnd_api.g_false,

2653: EXCEPTION
2654:
2655: WHEN g_exc_error THEN
2656: fnd_msg_pub.count_and_get(
2657: p_encoded => fnd_api.g_false,
2658: p_count => x_msg_count,
2659: p_data => x_msg_data);
2660: IF( x_msg_count > 1 ) THEN
2661: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 2661: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2657: p_encoded => fnd_api.g_false,
2658: p_count => x_msg_count,
2659: p_data => x_msg_data);
2660: IF( x_msg_count > 1 ) THEN
2661: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2662: END IF ;
2663:
2664: IF g_debug = 1 THEN
2665: print_debug('Exitting inv_rma_lot_info_exists - g_exc_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2673: p_encoded => fnd_api.g_false,

2669: RETURN FALSE;
2670:
2671: WHEN OTHERS THEN
2672: fnd_msg_pub.count_and_get(
2673: p_encoded => fnd_api.g_false,
2674: p_count => x_msg_count,
2675: p_data => x_msg_data);
2676: IF( x_msg_count > 1 ) THEN
2677: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 2677: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2673: p_encoded => fnd_api.g_false,
2674: p_count => x_msg_count,
2675: p_data => x_msg_data);
2676: IF( x_msg_count > 1 ) THEN
2677: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2678: END IF ;
2679:
2680: IF g_debug = 1 THEN
2681: print_debug('Exitting inv_rma_lot_info_exists - OTHERS error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

2714: x_return_status OUT NOCOPY VARCHAR2 ,
2715: x_msg_data OUT NOCOPY VARCHAR2 ,
2716: x_msg_count OUT NOCOPY NUMBER ,
2717: p_api_version IN NUMBER DEFAULT 1.0 ,
2718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2719: p_item_id IN NUMBER ,
2720: p_lot_number IN VARCHAR2 ,
2721: p_oe_order_header_id IN NUMBER ,
2722: p_oe_order_line_id IN NUMBER ,

Line 2810: IF NOT fnd_api.compatible_api_call(

2806: BEGIN
2807: l_progress :='063';
2808:
2809: -- Standard call to check for call compatibility.
2810: IF NOT fnd_api.compatible_api_call(
2811: l_api_version,
2812: p_api_version,
2813: l_api_name,
2814: 'INV_ROI_INTEGRATION_GRP'

Line 2817: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);

2813: l_api_name,
2814: 'INV_ROI_INTEGRATION_GRP'
2815: ) THEN
2816: IF (g_debug = 1) THEN
2817: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);
2818: END IF;
2819: RAISE fnd_api.g_exc_unexpected_error;
2820: END IF;
2821:

Line 2819: RAISE fnd_api.g_exc_unexpected_error;

2815: ) THEN
2816: IF (g_debug = 1) THEN
2817: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);
2818: END IF;
2819: RAISE fnd_api.g_exc_unexpected_error;
2820: END IF;
2821:
2822: -- Initialize message list if p_init_msg_list is set to TRUE.
2823: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2823: IF fnd_api.to_boolean(p_init_msg_list) THEN

2819: RAISE fnd_api.g_exc_unexpected_error;
2820: END IF;
2821:
2822: -- Initialize message list if p_init_msg_list is set to TRUE.
2823: IF fnd_api.to_boolean(p_init_msg_list) THEN
2824: fnd_msg_pub.initialize;
2825: END IF;
2826:
2827: --Initialize the return status

Line 2828: x_return_status := FND_API.G_RET_STS_SUCCESS;

2824: fnd_msg_pub.initialize;
2825: END IF;
2826:
2827: --Initialize the return status
2828: x_return_status := FND_API.G_RET_STS_SUCCESS;
2829:
2830:
2831: --SAVEPOINT val_rma_quant1;
2832: l_progress := '001';

Line 2849: x_return_status := FND_API.G_RET_STS_SUCCESS;

2845: print_debug('Parameter values p_item_id ,p_oe_order_header_id,p_oe_order_line_id and p_trx_unit_of_measure
2846: are:' || p_item_id || ':'|| p_oe_order_header_id || ':' ||p_oe_order_line_id || ':'||p_trx_unit_of_measure||':'|| l_progress, 1);
2847: END IF;
2848: X_allowed := 'Y';
2849: x_return_status := FND_API.G_RET_STS_SUCCESS;
2850: RETURN;
2851:
2852: END IF;
2853: l_trx_unit_of_measure := p_trx_unit_of_measure;--bug11734602,the variable not setted with the right value

Line 3163: x_return_status := fnd_api.g_ret_sts_error;

3159:
3160: EXCEPTION
3161:
3162: WHEN NO_DATA_FOUND THEN
3163: x_return_status := fnd_api.g_ret_sts_error;
3164: fnd_msg_pub.count_and_get(
3165: p_encoded => fnd_api.g_false ,
3166: p_count => x_msg_count ,
3167: p_data => x_msg_data

Line 3165: p_encoded => fnd_api.g_false ,

3161:
3162: WHEN NO_DATA_FOUND THEN
3163: x_return_status := fnd_api.g_ret_sts_error;
3164: fnd_msg_pub.count_and_get(
3165: p_encoded => fnd_api.g_false ,
3166: p_count => x_msg_count ,
3167: p_data => x_msg_data
3168: );
3169:

Line 3173: FND_API.G_FALSE

3169:
3170: IF( x_msg_count > 1 ) THEN
3171: x_msg_data := fnd_msg_pub.get(
3172: x_msg_count ,
3173: FND_API.G_FALSE
3174: );
3175: END IF ;
3176:
3177: IF g_debug = 1 THEN

Line 3183: x_return_status := fnd_api.g_ret_sts_error;

3179: print_stacked_messages;
3180: END IF;
3181:
3182: WHEN g_exc_error THEN
3183: x_return_status := fnd_api.g_ret_sts_error;
3184:
3185: fnd_msg_pub.count_and_get(
3186: p_encoded => fnd_api.g_false ,
3187: p_count => x_msg_count ,

Line 3186: p_encoded => fnd_api.g_false ,

3182: WHEN g_exc_error THEN
3183: x_return_status := fnd_api.g_ret_sts_error;
3184:
3185: fnd_msg_pub.count_and_get(
3186: p_encoded => fnd_api.g_false ,
3187: p_count => x_msg_count ,
3188: p_data => x_msg_data
3189: );
3190:

Line 3194: FND_API.G_FALSE

3190:
3191: IF( x_msg_count > 1 ) THEN
3192: x_msg_data := fnd_msg_pub.get(
3193: x_msg_count ,
3194: FND_API.G_FALSE
3195: );
3196: END IF;
3197: IF g_debug = 1 THEN
3198: print_debug('Exitting Inv_Validate_rma_quantity - g_exc_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 3203: x_return_status := fnd_api.g_ret_sts_unexp_error;

3199: print_stacked_messages;
3200: END IF;
3201:
3202: WHEN g_exc_unexpected_error THEN
3203: x_return_status := fnd_api.g_ret_sts_unexp_error;
3204:
3205: fnd_msg_pub.count_and_get(
3206: p_encoded => fnd_api.g_false ,
3207: p_count => x_msg_count ,

Line 3206: p_encoded => fnd_api.g_false ,

3202: WHEN g_exc_unexpected_error THEN
3203: x_return_status := fnd_api.g_ret_sts_unexp_error;
3204:
3205: fnd_msg_pub.count_and_get(
3206: p_encoded => fnd_api.g_false ,
3207: p_count => x_msg_count ,
3208: p_data => x_msg_data
3209: );
3210:

Line 3214: FND_API.G_FALSE);

3210:
3211: IF( x_msg_count > 1 ) THEN
3212: x_msg_data := fnd_msg_pub.get(
3213: x_msg_count ,
3214: FND_API.G_FALSE);
3215: END IF ;
3216: IF g_debug = 1 THEN
3217: print_debug('Exitting Inv_Validate_rma_quantity - g_exc_unexpected_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);
3218: print_stacked_messages;

Line 3222: x_return_status := fnd_api.g_ret_sts_unexp_error;

3218: print_stacked_messages;
3219: END IF;
3220:
3221: WHEN OTHERS THEN
3222: x_return_status := fnd_api.g_ret_sts_unexp_error;
3223:
3224: fnd_msg_pub.count_and_get(
3225: p_encoded => fnd_api.g_false ,
3226: p_count => x_msg_count ,

Line 3225: p_encoded => fnd_api.g_false ,

3221: WHEN OTHERS THEN
3222: x_return_status := fnd_api.g_ret_sts_unexp_error;
3223:
3224: fnd_msg_pub.count_and_get(
3225: p_encoded => fnd_api.g_false ,
3226: p_count => x_msg_count ,
3227: p_data => x_msg_data
3228: );
3229:

Line 3233: FND_API.G_FALSE);

3229:
3230: IF( x_msg_count > 1 ) THEN
3231: x_msg_data := fnd_msg_pub.get(
3232: x_msg_count ,
3233: FND_API.G_FALSE);
3234: END IF;
3235: IF g_debug = 1 THEN
3236: print_debug('Exitting Inv_Validate_rma_quantity - others error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);
3237: print_stacked_messages;

Line 3287: x_return_status := fnd_api.g_ret_sts_success;

3283: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;
3284:
3285: BEGIN
3286:
3287: x_return_status := fnd_api.g_ret_sts_success;
3288:
3289: /******************* START Item validation ********************/
3290:
3291: /* Check item attributes in Mtl_system_items Table */

Line 3304: x_return_status := fnd_api.g_ret_sts_error;

3300: END IF;
3301:
3302: x_lot_cont := FALSE ;
3303: x_child_lot_cont := FALSE ;
3304: x_return_status := fnd_api.g_ret_sts_error;
3305: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
3306: fnd_msg_pub.ADD;
3307: RAISE fnd_api.g_exc_error;
3308:

Line 3307: RAISE fnd_api.g_exc_error;

3303: x_child_lot_cont := FALSE ;
3304: x_return_status := fnd_api.g_ret_sts_error;
3305: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
3306: fnd_msg_pub.ADD;
3307: RAISE fnd_api.g_exc_error;
3308:
3309: ELSE
3310:
3311: CLOSE c_chk_msi_attr;

Line 3345: x_return_status := fnd_api.g_ret_sts_error;

3341: /******************* End Item validation ********************/
3342: EXCEPTION
3343:
3344: WHEN NO_DATA_FOUND THEN
3345: x_return_status := fnd_api.g_ret_sts_error;
3346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3347: IF( x_msg_count > 1 ) THEN
3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3349: END IF;

Line 3346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3342: EXCEPTION
3343:
3344: WHEN NO_DATA_FOUND THEN
3345: x_return_status := fnd_api.g_ret_sts_error;
3346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3347: IF( x_msg_count > 1 ) THEN
3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3349: END IF;
3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);

Line 3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3344: WHEN NO_DATA_FOUND THEN
3345: x_return_status := fnd_api.g_ret_sts_error;
3346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3347: IF( x_msg_count > 1 ) THEN
3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3349: END IF;
3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3351:
3352: WHEN fnd_api.g_exc_error THEN

Line 3352: WHEN fnd_api.g_exc_error THEN

3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3349: END IF;
3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3351:
3352: WHEN fnd_api.g_exc_error THEN
3353: x_return_status := fnd_api.g_ret_sts_error;
3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3355: IF( x_msg_count > 1 ) THEN
3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 3353: x_return_status := fnd_api.g_ret_sts_error;

3349: END IF;
3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3351:
3352: WHEN fnd_api.g_exc_error THEN
3353: x_return_status := fnd_api.g_ret_sts_error;
3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3355: IF( x_msg_count > 1 ) THEN
3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3357: END IF;

Line 3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3351:
3352: WHEN fnd_api.g_exc_error THEN
3353: x_return_status := fnd_api.g_ret_sts_error;
3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3355: IF( x_msg_count > 1 ) THEN
3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3357: END IF;
3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);

Line 3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3352: WHEN fnd_api.g_exc_error THEN
3353: x_return_status := fnd_api.g_ret_sts_error;
3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3355: IF( x_msg_count > 1 ) THEN
3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3357: END IF;
3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3359:
3360: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3360: WHEN fnd_api.g_exc_unexpected_error THEN

3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3357: END IF;
3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3359:
3360: WHEN fnd_api.g_exc_unexpected_error THEN
3361: x_return_status := fnd_api.g_ret_sts_unexp_error;
3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3363: IF( x_msg_count > 1 ) THEN
3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 3361: x_return_status := fnd_api.g_ret_sts_unexp_error;

3357: END IF;
3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3359:
3360: WHEN fnd_api.g_exc_unexpected_error THEN
3361: x_return_status := fnd_api.g_ret_sts_unexp_error;
3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3363: IF( x_msg_count > 1 ) THEN
3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3365: END IF ;

Line 3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3359:
3360: WHEN fnd_api.g_exc_unexpected_error THEN
3361: x_return_status := fnd_api.g_ret_sts_unexp_error;
3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3363: IF( x_msg_count > 1 ) THEN
3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3365: END IF ;
3366: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);

Line 3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3360: WHEN fnd_api.g_exc_unexpected_error THEN
3361: x_return_status := fnd_api.g_ret_sts_unexp_error;
3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3363: IF( x_msg_count > 1 ) THEN
3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3365: END IF ;
3366: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3367:
3368: WHEN OTHERS THEN

Line 3369: x_return_status := fnd_api.g_ret_sts_unexp_error;

3365: END IF ;
3366: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3367:
3368: WHEN OTHERS THEN
3369: x_return_status := fnd_api.g_ret_sts_unexp_error;
3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3371: IF( x_msg_count > 1 ) THEN
3372: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3373: END IF;

Line 3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3366: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3367:
3368: WHEN OTHERS THEN
3369: x_return_status := fnd_api.g_ret_sts_unexp_error;
3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3371: IF( x_msg_count > 1 ) THEN
3372: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3373: END IF;
3374: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);

Line 3372: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3368: WHEN OTHERS THEN
3369: x_return_status := fnd_api.g_ret_sts_unexp_error;
3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3371: IF( x_msg_count > 1 ) THEN
3372: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3373: END IF;
3374: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);
3375:
3376: END Check_Item_Attributes;