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 209: IF NOT fnd_api.compatible_api_call(

205:
206: BEGIN
207:
208: -- Standard call to check for call compatibility.
209: IF NOT fnd_api.compatible_api_call(
210: l_api_version,
211: p_api_version,
212: l_api_name,
213: 'INV_ROI_INTEGRATION_GRP'

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

212: l_api_name,
213: 'INV_ROI_INTEGRATION_GRP'
214: ) THEN
215: IF (g_debug = 1) THEN
216: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT: '||l_progress, 1);
217: END IF;
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:

Line 218: RAISE fnd_api.g_exc_unexpected_error;

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

Line 224: IF fnd_api.to_boolean(p_init_msg_lst) THEN

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

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 414: p_init_msg_list =>FND_API.G_FALSE ,

410: x_return_status =>l_return_status ,
411: x_msg_data =>l_msg_data ,
412: x_msg_count =>l_msg_count ,
413: p_api_version =>1.0 ,
414: p_init_msg_list =>FND_API.G_FALSE ,
415: p_item_id =>p_item_id ,
416: p_lot_number =>p_lot_number ,
417: p_oe_order_header_id =>p_OE_ORDER_HEADER_ID ,
418: p_oe_order_line_id =>p_OE_ORDER_LINE_ID ,

Line 449: IF l_return_status = fnd_api.g_ret_sts_error THEN

445: END IF;
446:
447: l_progress := '007' ;
448:
449: IF l_return_status = fnd_api.g_ret_sts_error THEN
450: IF g_debug = 1 THEN
451: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a user defined exception '|| l_progress, 1);
452: END IF;
453: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 460: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

456: RAISE g_exc_error;
457:
458: l_progress := '008' ;
459:
460: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
461: IF g_debug = 1 THEN
462: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a Unexpected exception ' || l_progress , 1);
463: END IF;
464: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: lot or create new lot and no quantity validation required.
483: Take RMA validation as Success: ' || l_progress, 1);
484: END IF;
485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: END IF;--------IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(
488:
489: END IF;--------IF l_enforce_rma_lot_value = 'R' THEN
490:

Line 525: IF l_return_status = fnd_api.g_ret_sts_error THEN

521: IF g_debug = 1 THEN
522: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);
523: END IF;
524:
525: IF l_return_status = fnd_api.g_ret_sts_error THEN
526: IF g_debug = 1 THEN
527: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
528: END IF;
529: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;

Line 535: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

531: FND_MSG_PUB.ADD;
532: RAISE g_exc_error;
533: END IF;
534:
535: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
536: IF g_debug = 1 THEN
537: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
538: END IF;
539: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 551: x_return_status := fnd_api.g_ret_sts_error;

547: print_debug(' Item is not lot controlled ', 9);
548: END IF;
549: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
550: fnd_msg_pub.ADD;
551: x_return_status := fnd_api.g_ret_sts_error;
552: RAISE g_exc_error;
553: END IF ;
554:
555: IF (l_child_lot_cont = FALSE AND p_parent_lot_number IS NOT NULL) THEN

Line 561: x_return_status := fnd_api.g_ret_sts_error;

557: print_debug(' Item is not Child lot controlled ', 9);
558: END IF;
559: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
560: fnd_msg_pub.ADD;
561: x_return_status := fnd_api.g_ret_sts_error;
562: RAISE g_exc_error;
563: END IF ;
564:
565:

Line 597: , p_init_msg_list => FND_API.G_FALSE

593:
594: print_debug('Calling inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
595: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (
596: p_api_version => 1.0
597: , p_init_msg_list => FND_API.G_FALSE
598: , p_commit => FND_API.G_FALSE
599: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
600: , p_rti_id => p_rti_id
601: , p_transaction_type_id => p_transaction_type_id

Line 598: , p_commit => FND_API.G_FALSE

594: print_debug('Calling inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
595: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (
596: p_api_version => 1.0
597: , p_init_msg_list => FND_API.G_FALSE
598: , p_commit => FND_API.G_FALSE
599: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
600: , p_rti_id => p_rti_id
601: , p_transaction_type_id => p_transaction_type_id
602: , p_lot_number => p_lot_number

Line 599: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

595: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (
596: p_api_version => 1.0
597: , p_init_msg_list => FND_API.G_FALSE
598: , p_commit => FND_API.G_FALSE
599: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
600: , p_rti_id => p_rti_id
601: , p_transaction_type_id => p_transaction_type_id
602: , p_lot_number => p_lot_number
603: , p_lot_quantity => p_lot_primary_qty

Line 612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

608: , x_msg_count => l_msg_count
609: , x_msg_data => l_msg_data
610: );
611:
612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: print_debug('Lot Indivisiblity check failure in inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616: END IF;

Line 614: RAISE FND_API.G_EXC_ERROR;

610: );
611:
612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: print_debug('Lot Indivisiblity check failure in inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616: END IF;
617:
618: -- END Bug# 4233182

Line 730: ,p_init_msg_list =>FND_API.G_FALSE

726: -----IF l_lot_ind_call = 'Y' THEN
727:
728: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
729: p_api_version =>1.0
730: ,p_init_msg_list =>FND_API.G_FALSE
731: ,p_commit =>FND_API.G_FALSE
732: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
733: ,p_transaction_type_id =>l_transaction_type_id
734: ,p_organization_id =>p_to_organization_id

Line 731: ,p_commit =>FND_API.G_FALSE

727:
728: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
729: p_api_version =>1.0
730: ,p_init_msg_list =>FND_API.G_FALSE
731: ,p_commit =>FND_API.G_FALSE
732: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
733: ,p_transaction_type_id =>l_transaction_type_id
734: ,p_organization_id =>p_to_organization_id
735: ,p_inventory_item_id =>p_item_id

Line 732: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL

728: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
729: p_api_version =>1.0
730: ,p_init_msg_list =>FND_API.G_FALSE
731: ,p_commit =>FND_API.G_FALSE
732: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
733: ,p_transaction_type_id =>l_transaction_type_id
734: ,p_organization_id =>p_to_organization_id
735: ,p_inventory_item_id =>p_item_id
736: ,p_revision =>p_revision

Line 758: 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

754:
755: /* Enhancement #4019704. Allow Return transactions even if lot indivisibility fails but the
756: transaction quantity is equal to the received quantity. Punit Kumar. 02-Dec-2004. */
757: /*I
758: 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
759:
760: l_progress := '101';
761:
762: l_lot_qty := p_lot_quantity ;

Line 841: l_return_status := FND_API.G_RET_STS_SUCCESS ;

837: IF g_debug = 1 THEN
838: print_debug('l_return_status'|| l_return_status, 9);
839: END IF;
840:
841: l_return_status := FND_API.G_RET_STS_SUCCESS ;
842:
843: IF g_debug = 1 THEN
844: print_debug('l_return_status'|| l_return_status, 9);
845: print_debug('set return status of validate_lot_indivisible to true'|| l_progress, 9);

Line 854: IF l_return_status = fnd_api.g_ret_sts_error THEN

850: END IF; -------- IF (l_transaction_type IN ('RETURN TO RECEIVING'
851:
852: /* end , enhancement */
853: /* I
854: IF l_return_status = fnd_api.g_ret_sts_error THEN
855: IF g_debug = 1 THEN
856: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);
857: END IF;
858:

Line 864: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

860: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
861: fnd_msg_pub.ADD;
862: RAISE g_exc_error;
863:
864: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
865: l_progress := '012' ;
866: IF g_debug = 1 THEN
867: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);
868: END IF;

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

870: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
871: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
872: fnd_msg_pub.ADD;
873: RAISE g_exc_unexpected_error;
874: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
875:
876: END IF; ----IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
877:
878: IF g_debug = 1 THEN

Line 1303: x_return_status := fnd_api.g_ret_sts_error;

1299:
1300: EXCEPTION
1301:
1302: WHEN NO_DATA_FOUND THEN
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: fnd_msg_pub.count_and_get(
1305: p_encoded => fnd_api.g_false ,
1306: p_count => x_msg_count ,
1307: p_data => x_msg_data

Line 1305: p_encoded => fnd_api.g_false ,

1301:
1302: WHEN NO_DATA_FOUND THEN
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: fnd_msg_pub.count_and_get(
1305: p_encoded => fnd_api.g_false ,
1306: p_count => x_msg_count ,
1307: p_data => x_msg_data
1308: );
1309: IF( x_msg_count > 1 ) THEN

Line 1312: FND_API.G_FALSE

1308: );
1309: IF( x_msg_count > 1 ) THEN
1310: x_msg_data := fnd_msg_pub.get(
1311: x_msg_count ,
1312: FND_API.G_FALSE
1313: );
1314: END IF ;
1315: IF g_debug = 1 THEN
1316: print_debug('Exitting INV_VALIDATE_LOT - No data found error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 1323: x_return_status := fnd_api.g_ret_sts_error;

1319:
1320: WHEN INVALID_ITEM THEN
1321: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1322: FND_MSG_PUB.ADD;
1323: x_return_status := fnd_api.g_ret_sts_error;
1324: fnd_msg_pub.count_and_get(
1325: p_encoded => fnd_api.g_false ,
1326: p_count => x_msg_count ,
1327: p_data => x_msg_data

Line 1325: p_encoded => fnd_api.g_false ,

1321: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1322: FND_MSG_PUB.ADD;
1323: x_return_status := fnd_api.g_ret_sts_error;
1324: fnd_msg_pub.count_and_get(
1325: p_encoded => fnd_api.g_false ,
1326: p_count => x_msg_count ,
1327: p_data => x_msg_data
1328: );
1329: IF( x_msg_count > 1 ) THEN

Line 1332: FND_API.G_FALSE

1328: );
1329: IF( x_msg_count > 1 ) THEN
1330: x_msg_data := fnd_msg_pub.get(
1331: x_msg_count ,
1332: FND_API.G_FALSE
1333: );
1334: END IF ;
1335:
1336: IF g_debug = 1 THEN

Line 1343: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1345: p_encoded => fnd_api.g_false ,

1341:
1342: WHEN g_exc_error THEN
1343: x_return_status := fnd_api.g_ret_sts_error;
1344: fnd_msg_pub.count_and_get(
1345: p_encoded => fnd_api.g_false ,
1346: p_count => x_msg_count ,
1347: p_data => x_msg_data
1348: );
1349: IF( x_msg_count > 1 ) THEN

Line 1352: FND_API.G_FALSE

1348: );
1349: IF( x_msg_count > 1 ) THEN
1350: x_msg_data := fnd_msg_pub.get(
1351: x_msg_count ,
1352: FND_API.G_FALSE
1353: );
1354: END IF;
1355:
1356: IF g_debug = 1 THEN

Line 1363: x_return_status := fnd_api.g_ret_sts_unexp_error;

1359: END IF;
1360:
1361:
1362: WHEN g_exc_unexpected_error THEN
1363: x_return_status := fnd_api.g_ret_sts_unexp_error;
1364: fnd_msg_pub.count_and_get(
1365: p_encoded => fnd_api.g_false ,
1366: p_count => x_msg_count ,
1367: p_data => x_msg_data

Line 1365: p_encoded => fnd_api.g_false ,

1361:
1362: WHEN g_exc_unexpected_error THEN
1363: x_return_status := fnd_api.g_ret_sts_unexp_error;
1364: fnd_msg_pub.count_and_get(
1365: p_encoded => fnd_api.g_false ,
1366: p_count => x_msg_count ,
1367: p_data => x_msg_data
1368: );
1369: IF( x_msg_count > 1 ) THEN

Line 1372: FND_API.G_FALSE

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

Line 1382: x_return_status := fnd_api.g_ret_sts_unexp_error;

1378: --------print_stacked_messages;
1379: END IF;
1380:
1381: WHEN OTHERS THEN
1382: x_return_status := fnd_api.g_ret_sts_unexp_error;
1383: fnd_msg_pub.count_and_get(
1384: p_encoded => fnd_api.g_false ,
1385: p_count => x_msg_count ,
1386: p_data => x_msg_data

Line 1384: p_encoded => fnd_api.g_false ,

1380:
1381: WHEN OTHERS THEN
1382: x_return_status := fnd_api.g_ret_sts_unexp_error;
1383: fnd_msg_pub.count_and_get(
1384: p_encoded => fnd_api.g_false ,
1385: p_count => x_msg_count ,
1386: p_data => x_msg_data
1387: );
1388: IF( x_msg_count > 1 ) THEN

Line 1391: FND_API.G_FALSE);

1387: );
1388: IF( x_msg_count > 1 ) THEN
1389: x_msg_data := fnd_msg_pub.get(
1390: x_msg_count ,
1391: FND_API.G_FALSE);
1392: END IF;
1393:
1394: IF g_debug = 1 THEN
1395: print_debug('Exitting INV_VALIDATE_LOT - In others error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

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

1431: x_return_status OUT NOCOPY VARCHAR2 ,
1432: x_msg_count OUT NOCOPY NUMBER ,
1433: x_msg_data OUT NOCOPY VARCHAR2 ,
1434: p_api_version IN NUMBER DEFAULT 1.0 ,
1435: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
1436: p_source_document_code IN VARCHAR2 ,
1437: p_item_id IN NUMBER ,
1438: p_from_organization_id IN NUMBER ,
1439: p_to_organization_id IN NUMBER ,

Line 1493: IF NOT fnd_api.compatible_api_call(

1489:
1490: l_progress := '024';
1491:
1492: -- Standard call to check for call compatibility.
1493: IF NOT fnd_api.compatible_api_call(
1494: l_api_version ,
1495: p_api_version ,
1496: l_api_name ,
1497: 'INV_ROI_INTEGRATION_GRP'

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

1496: l_api_name ,
1497: 'INV_ROI_INTEGRATION_GRP'
1498: ) THEN
1499: IF (g_debug = 1) THEN
1500: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);
1501: END IF;
1502: RAISE fnd_api.g_exc_unexpected_error;
1503: END IF;
1504:

Line 1502: RAISE fnd_api.g_exc_unexpected_error;

1498: ) THEN
1499: IF (g_debug = 1) THEN
1500: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);
1501: END IF;
1502: RAISE fnd_api.g_exc_unexpected_error;
1503: END IF;
1504:
1505: /* Initialize message list if p_init_msg_list is set to TRUE. */
1506: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1506: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1502: RAISE fnd_api.g_exc_unexpected_error;
1503: END IF;
1504:
1505: /* Initialize message list if p_init_msg_list is set to TRUE. */
1506: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1507: fnd_msg_pub.initialize;
1508: END IF;
1509:
1510: /*Initialize the return status */

Line 1511: x_return_status := FND_API.G_RET_STS_SUCCESS;

1507: fnd_msg_pub.initialize;
1508: END IF;
1509:
1510: /*Initialize the return status */
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: /* Checking for Inter-Org transfer */
1514:
1515: IF p_source_document_code IN ( 'INVENTORY','REQ') THEN

Line 1710: p_init_msg_list => fnd_api.g_false ,

1706: x_lot_rec => x_lot_rec ,
1707: p_lot_rec => l_lot_rec ,
1708: p_source => l_source ,
1709: p_api_version => l_api_version ,
1710: p_init_msg_list => fnd_api.g_false ,
1711: p_commit => fnd_api.g_false ,
1712: p_validation_level => fnd_api.g_valid_level_full ,
1713: p_origin_txn_id => p_to_organization_id
1714: );

Line 1711: p_commit => fnd_api.g_false ,

1707: p_lot_rec => l_lot_rec ,
1708: p_source => l_source ,
1709: p_api_version => l_api_version ,
1710: p_init_msg_list => fnd_api.g_false ,
1711: p_commit => fnd_api.g_false ,
1712: p_validation_level => fnd_api.g_valid_level_full ,
1713: p_origin_txn_id => p_to_organization_id
1714: );
1715: l_progress := '272';

Line 1712: p_validation_level => fnd_api.g_valid_level_full ,

1708: p_source => l_source ,
1709: p_api_version => l_api_version ,
1710: p_init_msg_list => fnd_api.g_false ,
1711: p_commit => fnd_api.g_false ,
1712: p_validation_level => fnd_api.g_valid_level_full ,
1713: p_origin_txn_id => p_to_organization_id
1714: );
1715: l_progress := '272';
1716:

Line 1769: IF l_return_status = fnd_api.g_ret_sts_error THEN

1765: print_debug('x_lot_rec.EXPIRATION_ACTION_CODE:'|| x_lot_rec.EXPIRATION_ACTION_CODE ||':'|| l_progress, 1);
1766: print_debug('x_lot_rec.HOLD_DATE :'||x_lot_rec.HOLD_DATE ||':'|| l_progress, 1);
1767: END IF;
1768:
1769: IF l_return_status = fnd_api.g_ret_sts_error THEN
1770: IF g_debug = 1 THEN
1771: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a user defined exception : ' || l_progress, 9);
1772: END IF;
1773: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 1779: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1775: fnd_msg_pub.ADD;
1776: RAISE g_exc_error;
1777:
1778: l_progress := '028' ;
1779: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1780: IF g_debug = 1 THEN
1781: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a Unexpected exception :'|| l_progress, 9);
1782: END IF;
1783: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 2056: p_init_msg_list =>FND_API.G_FALSE ,

2052:
2053:
2054: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2055: p_api_version =>1.0 ,
2056: p_init_msg_list =>FND_API.G_FALSE ,
2057: p_commit =>FND_API.G_TRUE ,
2058: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,
2059: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2060: p_update_type_indicator =>5 ,

Line 2057: p_commit =>FND_API.G_TRUE ,

2053:
2054: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2055: p_api_version =>1.0 ,
2056: p_init_msg_list =>FND_API.G_FALSE ,
2057: p_commit =>FND_API.G_TRUE ,
2058: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,
2059: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2060: p_update_type_indicator =>5 ,
2061: p_reason_id =>p_reason_id ,

Line 2058: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,

2054: MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion(
2055: p_api_version =>1.0 ,
2056: p_init_msg_list =>FND_API.G_FALSE ,
2057: p_commit =>FND_API.G_TRUE ,
2058: p_validation_level =>FND_API.G_VALID_LEVEL_FULL ,
2059: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2060: p_update_type_indicator =>5 ,
2061: p_reason_id =>p_reason_id ,
2062: p_batch_id =>NULL /*(Since we are not updating batch quantities)*/ ,

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

2059: p_action_type =>'I' /*Database action type ('I' for insert or 'U' for update)*/ ,
2060: p_update_type_indicator =>5 ,
2061: p_reason_id =>p_reason_id ,
2062: p_batch_id =>NULL /*(Since we are not updating batch quantities)*/ ,
2063: p_process_data =>'Y', -- Bug 4019726 FND_API.G_TRUE ,
2064: p_lot_uom_conv_rec =>p_lot_uom_conv_rec ,
2065: p_qty_update_tbl =>l_qty_update_tbl ,
2066: x_return_status =>l_return_status ,
2067: x_msg_count =>l_msg_count ,

Line 2090: IF l_return_status = fnd_api.g_ret_sts_error THEN

2086: print_debug('x_return_status:'||l_return_status, 1);
2087: print_debug('x_msg_count:'||l_msg_count, 1);
2088: END IF;
2089:
2090: IF l_return_status = fnd_api.g_ret_sts_error THEN
2091: IF g_debug = 1 THEN
2092: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2093: END IF;
2094: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 2101: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2097: RAISE g_exc_error;
2098:
2099: l_progress := '036';
2100:
2101: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2102: IF g_debug = 1 THEN
2103: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2104: END IF;
2105: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 2122: x_return_status := fnd_api.g_ret_sts_error;

2118:
2119: EXCEPTION
2120:
2121: WHEN NO_DATA_FOUND THEN
2122: x_return_status := fnd_api.g_ret_sts_error;
2123: /*
2124: IF l_progress = '002' THEN
2125: ROLLBACK TO inv_new_lot_save2;
2126: ELSIF l_progress = '006' THEN

Line 2131: p_encoded => fnd_api.g_false ,

2127: ROLLBACK TO inv_new_lot_save6;
2128: END IF;
2129: */
2130: fnd_msg_pub.count_and_get(
2131: p_encoded => fnd_api.g_false ,
2132: p_count => x_msg_count ,
2133: p_data => x_msg_data
2134: );
2135:

Line 2139: FND_API.G_FALSE

2135:
2136: IF( x_msg_count > 1 ) THEN
2137: x_msg_data := fnd_msg_pub.get(
2138: x_msg_count ,
2139: FND_API.G_FALSE
2140: );
2141: END IF ;
2142: IF g_debug = 1 THEN
2143: print_debug('Exitting INV_NEW_LOT - No data found error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2148: x_return_status := fnd_api.g_ret_sts_error;

2144: print_stacked_messages;
2145: END IF;
2146:
2147: WHEN g_exc_error THEN
2148: x_return_status := fnd_api.g_ret_sts_error;
2149: /*
2150: IF l_progress = '002' THEN
2151: ROLLBACK TO inv_new_lot_save2;
2152: ELSIF l_progress = '006' THEN

Line 2157: p_encoded => fnd_api.g_false ,

2153: ROLLBACK TO inv_new_lot_save6;
2154: END IF;
2155: */
2156: fnd_msg_pub.count_and_get(
2157: p_encoded => fnd_api.g_false ,
2158: p_count => x_msg_count ,
2159: p_data => x_msg_data
2160: );
2161:

Line 2165: FND_API.G_FALSE

2161:
2162: IF( x_msg_count > 1 ) THEN
2163: x_msg_data := fnd_msg_pub.get(
2164: x_msg_count ,
2165: FND_API.G_FALSE
2166: );
2167: END IF;
2168:
2169: IF g_debug = 1 THEN

Line 2175: x_return_status := fnd_api.g_ret_sts_unexp_error;

2171: print_stacked_messages;
2172: END IF;
2173:
2174: WHEN g_exc_unexpected_error THEN
2175: x_return_status := fnd_api.g_ret_sts_unexp_error;
2176: /*
2177: IF l_progress = '002' THEN
2178: ROLLBACK TO inv_new_lot_save2;
2179: ELSIF l_progress = '006' THEN

Line 2184: p_encoded => fnd_api.g_false ,

2180: ROLLBACK TO inv_new_lot_save6;
2181: END IF;
2182: */
2183: fnd_msg_pub.count_and_get(
2184: p_encoded => fnd_api.g_false ,
2185: p_count => x_msg_count ,
2186: p_data => x_msg_data
2187: );
2188:

Line 2192: FND_API.G_FALSE);

2188:
2189: IF( x_msg_count > 1 ) THEN
2190: x_msg_data := fnd_msg_pub.get(
2191: x_msg_count ,
2192: FND_API.G_FALSE);
2193: END IF ;
2194:
2195: IF g_debug = 1 THEN
2196: print_debug('Exitting INV_NEW_LOT - g_exc_unexpected_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2201: x_return_status := fnd_api.g_ret_sts_unexp_error;

2197: print_stacked_messages;
2198: END IF;
2199:
2200: WHEN OTHERS THEN
2201: x_return_status := fnd_api.g_ret_sts_unexp_error;
2202: /*
2203: IF l_progress = '002' THEN
2204: ROLLBACK TO inv_new_lot_save2;
2205: ELSIF l_progress = '006' THEN

Line 2210: p_encoded => fnd_api.g_false ,

2206: ROLLBACK TO inv_new_lot_save6;
2207: END IF;
2208: */
2209: fnd_msg_pub.count_and_get(
2210: p_encoded => fnd_api.g_false ,
2211: p_count => x_msg_count ,
2212: p_data => x_msg_data
2213: );
2214:

Line 2218: FND_API.G_FALSE);

2214:
2215: IF( x_msg_count > 1 ) THEN
2216: x_msg_data := fnd_msg_pub.get(
2217: x_msg_count ,
2218: FND_API.G_FALSE);
2219: END IF;
2220:
2221: IF g_debug = 1 THEN
2222: print_debug('Exitting INV_NEW_LOT - OTHERS error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

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

2261: x_msg_count OUT NOCOPY NUMBER ,
2262: x_sum_sourcedoc_quantity OUT NOCOPY NUMBER ,
2263: x_sum_rti_secondary_quantity OUT NOCOPY NUMBER ,
2264: p_api_version IN NUMBER DEFAULT 1.0 ,
2265: p_init_msg_lst IN VARCHAR2 := FND_API.G_FALSE ,
2266: p_inventory_item_id IN NUMBER ,
2267: p_to_organization_id IN NUMBER ,
2268: p_lot_number IN VARCHAR2 ,
2269: p_transaction_unit_of_measure IN VARCHAR2 ,

Line 2294: IF NOT fnd_api.compatible_api_call(

2290:
2291: l_progress :='037';
2292:
2293: -- Standard call to check for call compatibility.
2294: IF NOT fnd_api.compatible_api_call(
2295: l_api_version,
2296: p_api_version,
2297: l_api_name,
2298: 'INV_ROI_INTEGRATION_GRP'

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

2297: l_api_name,
2298: 'INV_ROI_INTEGRATION_GRP'
2299: ) THEN
2300: IF (g_debug = 1) THEN
2301: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);
2302: END IF;
2303: RAISE fnd_api.g_exc_unexpected_error;
2304: END IF;
2305:

Line 2303: RAISE fnd_api.g_exc_unexpected_error;

2299: ) THEN
2300: IF (g_debug = 1) THEN
2301: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);
2302: END IF;
2303: RAISE fnd_api.g_exc_unexpected_error;
2304: END IF;
2305:
2306: -- Initialize message list if p_init_msg_list is set to TRUE.
2307: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 2307: IF fnd_api.to_boolean(p_init_msg_lst) THEN

2303: RAISE fnd_api.g_exc_unexpected_error;
2304: END IF;
2305:
2306: -- Initialize message list if p_init_msg_list is set to TRUE.
2307: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2308: fnd_msg_pub.initialize;
2309: END IF;
2310:
2311: --Initialize the return status

Line 2312: x_return_status := FND_API.G_RET_STS_SUCCESS;

2308: fnd_msg_pub.initialize;
2309: END IF;
2310:
2311: --Initialize the return status
2312: x_return_status := FND_API.G_RET_STS_SUCCESS;
2313:
2314: BEGIN
2315: l_progress :='038';
2316:

Line 2341: RAISE fnd_api.g_exc_error;

2337: WHEN OTHERS THEN
2338: IF g_debug = 1 THEN
2339: print_debug('Fetching uom class failed in synch_secondary_quantity:' || l_progress, 1);
2340: END IF;
2341: RAISE fnd_api.g_exc_error;
2342: END;
2343:
2344: l_progress:='039';
2345:

Line 2432: x_return_status := fnd_api.g_ret_sts_unexp_error;

2428: */
2429: EXCEPTION
2430:
2431: WHEN g_exc_unexpected_error THEN
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433: fnd_msg_pub.count_and_get(
2434: p_encoded => fnd_api.g_false ,
2435: p_count => x_msg_count ,
2436: p_data => x_msg_data

Line 2434: p_encoded => fnd_api.g_false ,

2430:
2431: WHEN g_exc_unexpected_error THEN
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433: fnd_msg_pub.count_and_get(
2434: p_encoded => fnd_api.g_false ,
2435: p_count => x_msg_count ,
2436: p_data => x_msg_data
2437: );
2438: IF( x_msg_count > 1 ) THEN

Line 2441: FND_API.G_FALSE

2437: );
2438: IF( x_msg_count > 1 ) THEN
2439: x_msg_data := fnd_msg_pub.get(
2440: x_msg_count ,
2441: FND_API.G_FALSE
2442: );
2443: END IF ;
2444:
2445: IF g_debug = 1 THEN

Line 2451: x_return_status := fnd_api.g_ret_sts_unexp_error;

2447: print_stacked_messages;
2448: END IF;
2449:
2450: WHEN OTHERS THEN
2451: x_return_status := fnd_api.g_ret_sts_unexp_error;
2452: fnd_msg_pub.count_and_get(
2453: p_encoded => fnd_api.g_false ,
2454: p_count => x_msg_count ,
2455: p_data => x_msg_data

Line 2453: p_encoded => fnd_api.g_false ,

2449:
2450: WHEN OTHERS THEN
2451: x_return_status := fnd_api.g_ret_sts_unexp_error;
2452: fnd_msg_pub.count_and_get(
2453: p_encoded => fnd_api.g_false ,
2454: p_count => x_msg_count ,
2455: p_data => x_msg_data
2456: );
2457: IF( x_msg_count > 1 ) THEN

Line 2460: FND_API.G_FALSE);

2456: );
2457: IF( x_msg_count > 1 ) THEN
2458: x_msg_data := fnd_msg_pub.get(
2459: x_msg_count ,
2460: FND_API.G_FALSE);
2461: END IF;
2462:
2463: IF g_debug = 1 THEN
2464: print_debug('Exitting INV_Synch_Quantities - Others error :'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2529: RAISE fnd_api.g_exc_error;

2525: WHEN OTHERS THEN
2526: IF g_debug = 1 THEN
2527: print_debug('Fetching RMA lot inside inv_roi_integration_grp.inv_rma_lot_info_exists failed:' || l_progress, 1);
2528: END IF;
2529: RAISE fnd_api.g_exc_error;
2530: END;
2531: l_progress :='062';
2532:
2533: IF x_count_rma_lots = 0 THEN

Line 2550: p_encoded => fnd_api.g_false,

2546: EXCEPTION
2547:
2548: WHEN g_exc_error THEN
2549: fnd_msg_pub.count_and_get(
2550: p_encoded => fnd_api.g_false,
2551: p_count => x_msg_count,
2552: p_data => x_msg_data);
2553: IF( x_msg_count > 1 ) THEN
2554: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

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

2550: p_encoded => fnd_api.g_false,
2551: p_count => x_msg_count,
2552: p_data => x_msg_data);
2553: IF( x_msg_count > 1 ) THEN
2554: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2555: END IF ;
2556:
2557: IF g_debug = 1 THEN
2558: print_debug('Exitting inv_rma_lot_info_exists - g_exc_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2566: p_encoded => fnd_api.g_false,

2562: RETURN FALSE;
2563:
2564: WHEN OTHERS THEN
2565: fnd_msg_pub.count_and_get(
2566: p_encoded => fnd_api.g_false,
2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: IF( x_msg_count > 1 ) THEN
2570: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

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

2566: p_encoded => fnd_api.g_false,
2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: IF( x_msg_count > 1 ) THEN
2570: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2571: END IF ;
2572:
2573: IF g_debug = 1 THEN
2574: print_debug('Exitting inv_rma_lot_info_exists - OTHERS error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

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

2607: x_return_status OUT NOCOPY VARCHAR2 ,
2608: x_msg_data OUT NOCOPY VARCHAR2 ,
2609: x_msg_count OUT NOCOPY NUMBER ,
2610: p_api_version IN NUMBER DEFAULT 1.0 ,
2611: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2612: p_item_id IN NUMBER ,
2613: p_lot_number IN VARCHAR2 ,
2614: p_oe_order_header_id IN NUMBER ,
2615: p_oe_order_line_id IN NUMBER ,

Line 2701: IF NOT fnd_api.compatible_api_call(

2697: BEGIN
2698: l_progress :='063';
2699:
2700: -- Standard call to check for call compatibility.
2701: IF NOT fnd_api.compatible_api_call(
2702: l_api_version,
2703: p_api_version,
2704: l_api_name,
2705: 'INV_ROI_INTEGRATION_GRP'

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

2704: l_api_name,
2705: 'INV_ROI_INTEGRATION_GRP'
2706: ) THEN
2707: IF (g_debug = 1) THEN
2708: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);
2709: END IF;
2710: RAISE fnd_api.g_exc_unexpected_error;
2711: END IF;
2712:

Line 2710: RAISE fnd_api.g_exc_unexpected_error;

2706: ) THEN
2707: IF (g_debug = 1) THEN
2708: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);
2709: END IF;
2710: RAISE fnd_api.g_exc_unexpected_error;
2711: END IF;
2712:
2713: -- Initialize message list if p_init_msg_list is set to TRUE.
2714: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2714: IF fnd_api.to_boolean(p_init_msg_list) THEN

2710: RAISE fnd_api.g_exc_unexpected_error;
2711: END IF;
2712:
2713: -- Initialize message list if p_init_msg_list is set to TRUE.
2714: IF fnd_api.to_boolean(p_init_msg_list) THEN
2715: fnd_msg_pub.initialize;
2716: END IF;
2717:
2718: --Initialize the return status

Line 2719: x_return_status := FND_API.G_RET_STS_SUCCESS;

2715: fnd_msg_pub.initialize;
2716: END IF;
2717:
2718: --Initialize the return status
2719: x_return_status := FND_API.G_RET_STS_SUCCESS;
2720:
2721:
2722: --SAVEPOINT val_rma_quant1;
2723: l_progress := '001';

Line 2740: x_return_status := FND_API.G_RET_STS_SUCCESS;

2736: print_debug('Parameter values p_item_id ,p_oe_order_header_id,p_oe_order_line_id and p_trx_unit_of_measure
2737: are:' || p_item_id || ':'|| p_oe_order_header_id || ':' ||p_oe_order_line_id || ':'||p_trx_unit_of_measure||':'|| l_progress, 1);
2738: END IF;
2739: X_allowed := 'Y';
2740: x_return_status := FND_API.G_RET_STS_SUCCESS;
2741: RETURN;
2742:
2743: END IF;
2744:

Line 3054: x_return_status := fnd_api.g_ret_sts_error;

3050:
3051: EXCEPTION
3052:
3053: WHEN NO_DATA_FOUND THEN
3054: x_return_status := fnd_api.g_ret_sts_error;
3055: fnd_msg_pub.count_and_get(
3056: p_encoded => fnd_api.g_false ,
3057: p_count => x_msg_count ,
3058: p_data => x_msg_data

Line 3056: p_encoded => fnd_api.g_false ,

3052:
3053: WHEN NO_DATA_FOUND THEN
3054: x_return_status := fnd_api.g_ret_sts_error;
3055: fnd_msg_pub.count_and_get(
3056: p_encoded => fnd_api.g_false ,
3057: p_count => x_msg_count ,
3058: p_data => x_msg_data
3059: );
3060:

Line 3064: FND_API.G_FALSE

3060:
3061: IF( x_msg_count > 1 ) THEN
3062: x_msg_data := fnd_msg_pub.get(
3063: x_msg_count ,
3064: FND_API.G_FALSE
3065: );
3066: END IF ;
3067:
3068: IF g_debug = 1 THEN

Line 3074: x_return_status := fnd_api.g_ret_sts_error;

3070: print_stacked_messages;
3071: END IF;
3072:
3073: WHEN g_exc_error THEN
3074: x_return_status := fnd_api.g_ret_sts_error;
3075:
3076: fnd_msg_pub.count_and_get(
3077: p_encoded => fnd_api.g_false ,
3078: p_count => x_msg_count ,

Line 3077: p_encoded => fnd_api.g_false ,

3073: WHEN g_exc_error THEN
3074: x_return_status := fnd_api.g_ret_sts_error;
3075:
3076: fnd_msg_pub.count_and_get(
3077: p_encoded => fnd_api.g_false ,
3078: p_count => x_msg_count ,
3079: p_data => x_msg_data
3080: );
3081:

Line 3085: FND_API.G_FALSE

3081:
3082: IF( x_msg_count > 1 ) THEN
3083: x_msg_data := fnd_msg_pub.get(
3084: x_msg_count ,
3085: FND_API.G_FALSE
3086: );
3087: END IF;
3088: IF g_debug = 1 THEN
3089: print_debug('Exitting Inv_Validate_rma_quantity - g_exc_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 3094: x_return_status := fnd_api.g_ret_sts_unexp_error;

3090: print_stacked_messages;
3091: END IF;
3092:
3093: WHEN g_exc_unexpected_error THEN
3094: x_return_status := fnd_api.g_ret_sts_unexp_error;
3095:
3096: fnd_msg_pub.count_and_get(
3097: p_encoded => fnd_api.g_false ,
3098: p_count => x_msg_count ,

Line 3097: p_encoded => fnd_api.g_false ,

3093: WHEN g_exc_unexpected_error THEN
3094: x_return_status := fnd_api.g_ret_sts_unexp_error;
3095:
3096: fnd_msg_pub.count_and_get(
3097: p_encoded => fnd_api.g_false ,
3098: p_count => x_msg_count ,
3099: p_data => x_msg_data
3100: );
3101:

Line 3105: FND_API.G_FALSE);

3101:
3102: IF( x_msg_count > 1 ) THEN
3103: x_msg_data := fnd_msg_pub.get(
3104: x_msg_count ,
3105: FND_API.G_FALSE);
3106: END IF ;
3107: IF g_debug = 1 THEN
3108: print_debug('Exitting Inv_Validate_rma_quantity - g_exc_unexpected_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);
3109: print_stacked_messages;

Line 3113: x_return_status := fnd_api.g_ret_sts_unexp_error;

3109: print_stacked_messages;
3110: END IF;
3111:
3112: WHEN OTHERS THEN
3113: x_return_status := fnd_api.g_ret_sts_unexp_error;
3114:
3115: fnd_msg_pub.count_and_get(
3116: p_encoded => fnd_api.g_false ,
3117: p_count => x_msg_count ,

Line 3116: p_encoded => fnd_api.g_false ,

3112: WHEN OTHERS THEN
3113: x_return_status := fnd_api.g_ret_sts_unexp_error;
3114:
3115: fnd_msg_pub.count_and_get(
3116: p_encoded => fnd_api.g_false ,
3117: p_count => x_msg_count ,
3118: p_data => x_msg_data
3119: );
3120:

Line 3124: FND_API.G_FALSE);

3120:
3121: IF( x_msg_count > 1 ) THEN
3122: x_msg_data := fnd_msg_pub.get(
3123: x_msg_count ,
3124: FND_API.G_FALSE);
3125: END IF;
3126: IF g_debug = 1 THEN
3127: print_debug('Exitting Inv_Validate_rma_quantity - others error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);
3128: print_stacked_messages;

Line 3178: x_return_status := fnd_api.g_ret_sts_success;

3174: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;
3175:
3176: BEGIN
3177:
3178: x_return_status := fnd_api.g_ret_sts_success;
3179:
3180: /******************* START Item validation ********************/
3181:
3182: /* Check item attributes in Mtl_system_items Table */

Line 3195: x_return_status := fnd_api.g_ret_sts_error;

3191: END IF;
3192:
3193: x_lot_cont := FALSE ;
3194: x_child_lot_cont := FALSE ;
3195: x_return_status := fnd_api.g_ret_sts_error;
3196: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
3197: fnd_msg_pub.ADD;
3198: RAISE fnd_api.g_exc_error;
3199:

Line 3198: RAISE fnd_api.g_exc_error;

3194: x_child_lot_cont := FALSE ;
3195: x_return_status := fnd_api.g_ret_sts_error;
3196: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
3197: fnd_msg_pub.ADD;
3198: RAISE fnd_api.g_exc_error;
3199:
3200: ELSE
3201:
3202: CLOSE c_chk_msi_attr;

Line 3236: x_return_status := fnd_api.g_ret_sts_error;

3232: /******************* End Item validation ********************/
3233: EXCEPTION
3234:
3235: WHEN NO_DATA_FOUND THEN
3236: x_return_status := fnd_api.g_ret_sts_error;
3237: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3238: IF( x_msg_count > 1 ) THEN
3239: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3240: END IF;

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

3233: EXCEPTION
3234:
3235: WHEN NO_DATA_FOUND THEN
3236: x_return_status := fnd_api.g_ret_sts_error;
3237: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3238: IF( x_msg_count > 1 ) THEN
3239: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3240: END IF;
3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);

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

3235: WHEN NO_DATA_FOUND THEN
3236: x_return_status := fnd_api.g_ret_sts_error;
3237: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3238: IF( x_msg_count > 1 ) THEN
3239: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3240: END IF;
3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3242:
3243: WHEN fnd_api.g_exc_error THEN

Line 3243: WHEN fnd_api.g_exc_error THEN

3239: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3240: END IF;
3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3242:
3243: WHEN fnd_api.g_exc_error THEN
3244: x_return_status := fnd_api.g_ret_sts_error;
3245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3246: IF( x_msg_count > 1 ) THEN
3247: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 3244: x_return_status := fnd_api.g_ret_sts_error;

3240: END IF;
3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3242:
3243: WHEN fnd_api.g_exc_error THEN
3244: x_return_status := fnd_api.g_ret_sts_error;
3245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3246: IF( x_msg_count > 1 ) THEN
3247: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3248: END IF;

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

3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3242:
3243: WHEN fnd_api.g_exc_error THEN
3244: x_return_status := fnd_api.g_ret_sts_error;
3245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3246: IF( x_msg_count > 1 ) THEN
3247: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3248: END IF;
3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);

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

3243: WHEN fnd_api.g_exc_error THEN
3244: x_return_status := fnd_api.g_ret_sts_error;
3245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3246: IF( x_msg_count > 1 ) THEN
3247: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3248: END IF;
3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3250:
3251: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3251: WHEN fnd_api.g_exc_unexpected_error THEN

3247: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3248: END IF;
3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3250:
3251: WHEN fnd_api.g_exc_unexpected_error THEN
3252: x_return_status := fnd_api.g_ret_sts_unexp_error;
3253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3254: IF( x_msg_count > 1 ) THEN
3255: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

Line 3252: x_return_status := fnd_api.g_ret_sts_unexp_error;

3248: END IF;
3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3250:
3251: WHEN fnd_api.g_exc_unexpected_error THEN
3252: x_return_status := fnd_api.g_ret_sts_unexp_error;
3253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3254: IF( x_msg_count > 1 ) THEN
3255: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3256: END IF ;

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

3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3250:
3251: WHEN fnd_api.g_exc_unexpected_error THEN
3252: x_return_status := fnd_api.g_ret_sts_unexp_error;
3253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3254: IF( x_msg_count > 1 ) THEN
3255: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3256: END IF ;
3257: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);

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

3251: WHEN fnd_api.g_exc_unexpected_error THEN
3252: x_return_status := fnd_api.g_ret_sts_unexp_error;
3253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3254: IF( x_msg_count > 1 ) THEN
3255: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3256: END IF ;
3257: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3258:
3259: WHEN OTHERS THEN

Line 3260: x_return_status := fnd_api.g_ret_sts_unexp_error;

3256: END IF ;
3257: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3258:
3259: WHEN OTHERS THEN
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;
3261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3262: IF( x_msg_count > 1 ) THEN
3263: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3264: END IF;

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

3257: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3258:
3259: WHEN OTHERS THEN
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;
3261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3262: IF( x_msg_count > 1 ) THEN
3263: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3264: END IF;
3265: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);

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

3259: WHEN OTHERS THEN
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;
3261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3262: IF( x_msg_count > 1 ) THEN
3263: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3264: END IF;
3265: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);
3266:
3267: END Check_Item_Attributes;