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 INV_LOT_API_PUB

Line 85: # Check lot indivisibility. (Call INV_LOT_API_PUB.validate_lot_indivisible )

81: # If lot secondary quantity is not null then check item level deviation.
82: # If lot secondary quantity is null then check if item is dual uom cotrolled, if yes then
83: # default the lot secondary quantity.
84: # For an existing lot :
85: # Check lot indivisibility. (Call INV_LOT_API_PUB.validate_lot_indivisible )
86: # If lot secondary quantity is not null then check lot level deviation.
87: # If lot secondary quantity is null then check if item is dual uom cotrolled, if yes then
88: # default the lot secondary quantity .
89: #

Line 96: # 08-Feb-2005 Punit Kumar Moved the lot indivisibility check to INV_LOT_API_PUB.PO_CHECK_INDIVISIBILITY.

92: # Inventory%20Convergence-Public/Design/Oracle%20Purchasing/TDD/PO_ROI_TDD.zip
93: #
94: # MODIFICATION HISTORY
95: # 10-AUG-2004 Punit Kumar Created
96: # 08-Feb-2005 Punit Kumar Moved the lot indivisibility check to INV_LOT_API_PUB.PO_CHECK_INDIVISIBILITY.
97: #
98: #########################################################################*/
99:
100:

Line 630: print_debug('Calling inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);

626: ) THEN
627: -- its a Inventory transaction
628: -- Call check lot indivisible API.
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

Line 631: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (

627: -- its a Inventory transaction
628: -- Call check lot indivisible API.
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

Line 649: print_debug('Lot Indivisiblity check failure in inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);

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;
653:

Line 656: /*Moving the lot indiv call from here to INV_LOT_API_PUB.PO_CHECK_INDIVISIBILITY

652: END IF;
653:
654: -- END Bug# 4233182
655:
656: /*Moving the lot indiv call from here to INV_LOT_API_PUB.PO_CHECK_INDIVISIBILITY
657: Punit Kumar, 08-02-2005 */
658:
659: /*I
660:

Line 677: Call INV_LOT_API_PUB.validate_lot_indivisible (@ INVPLOTB.pls) */

673:
674: /*Call lot indivisibility procedure to check if whether in case of indivisible
675: lots we are transacting a quantity less than that specified for that lot.
676:
677: Call INV_LOT_API_PUB.validate_lot_indivisible (@ INVPLOTB.pls) */
678: /*I
679: IF g_debug = 1 THEN
680: print_debug('p_transaction_type_id is ' || p_transaction_type_id, 9);
681: print_debug('l_transaction_type is ' || l_transaction_type, 9);

Line 764: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(

760: END IF;
761:
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

Line 786: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return FALSE ' || l_return_status || 'and '|| l_progress, 9);

782: ))THEN
783:
784: ------IF qoh and atr are passed as NULL THEN quantity tree is called in the API.
785: IF g_debug = 1 THEN
786: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return FALSE ' || l_return_status || 'and '|| l_progress, 9);
787: END IF;
788:
789: l_progress := '100' ;
790:

Line 892: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);

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:
895: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
896: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

Line 896: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

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:
895: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
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

Line 903: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);

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;
905:
906: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
907: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

Line 907: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

903: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);
904: END IF;
905:
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:

Line 912: END IF; ----IF NOT (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
915: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE ' || l_return_status || 'and '|| l_progress, 9);
916: END IF;

Line 915: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE ' || l_return_status || 'and '|| l_progress, 9);

911:
912: END IF; ----IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
913:
914: IF g_debug = 1 THEN
915: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE ' || l_return_status || 'and '|| l_progress, 9);
916: END IF;
917:
918: -------- END IF ; ----------IF l_lot_ind_call = 'Y' THEN
919:

Line 1748: print_debug('Printing the values of p_lot_rec before calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);

1744:
1745: l_progress := '027';
1746:
1747: IF g_debug = 1 THEN
1748: print_debug('Printing the values of p_lot_rec before calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);
1749: print_debug('l_lot_rec.INVENTORY_ITEM_ID: '|| l_lot_rec.INVENTORY_ITEM_ID||':'||l_progress, 1);
1750: print_debug('l_lot_rec.ORGANIZATION_ID '|| l_lot_rec.ORGANIZATION_ID||':'||l_progress, 1);
1751: print_debug('l_lot_rec.LOT_NUMBER :'|| l_lot_rec.LOT_NUMBER ||':'|| l_progress, 1);
1752: print_debug('l_lot_rec.PARENT_LOT_NUMBER :'|| l_lot_rec.PARENT_LOT_NUMBER ||':'|| l_progress, 1);

Line 1800: /* Call Lot Create API INV_LOT_API_PUB.CREATE_INV_LOT to create the new lot.

1796: END IF;
1797:
1798: l_progress := '271';
1799:
1800: /* Call Lot Create API INV_LOT_API_PUB.CREATE_INV_LOT to create the new lot.
1801: This shall also validate the attributes before creating the new Lot. */
1802:
1803: inv_lot_api_pub.Create_Inv_lot(
1804: x_return_status => l_return_status ,

Line 1803: inv_lot_api_pub.Create_Inv_lot(

1799:
1800: /* Call Lot Create API INV_LOT_API_PUB.CREATE_INV_LOT to create the new lot.
1801: This shall also validate the attributes before creating the new Lot. */
1802:
1803: inv_lot_api_pub.Create_Inv_lot(
1804: x_return_status => l_return_status ,
1805: x_msg_count => l_msg_count ,
1806: x_msg_data => l_msg_data ,
1807: x_row_id => l_row_id ,

Line 1820: print_debug('Program inv_lot_api_pub.Create_Inv_lot return ' || l_return_status || ':' || l_progress, 1);

1816: );
1817: l_progress := '272';
1818:
1819: IF g_debug = 1 THEN
1820: print_debug('Program inv_lot_api_pub.Create_Inv_lot return ' || l_return_status || ':' || l_progress, 1);
1821: print_debug('Printing the values of x_lot_rec after calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);
1822: print_debug('x_lot_rec.INVENTORY_ITEM_ID: '|| x_lot_rec.INVENTORY_ITEM_ID||':'||l_progress, 1);
1823: print_debug('x_lot_rec.ORGANIZATION_ID '|| x_lot_rec.ORGANIZATION_ID||':'||l_progress, 1);
1824: print_debug('x_lot_rec.LOT_NUMBER :'|| x_lot_rec.LOT_NUMBER ||':'|| l_progress, 1);

Line 1821: print_debug('Printing the values of x_lot_rec after calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);

1817: l_progress := '272';
1818:
1819: IF g_debug = 1 THEN
1820: print_debug('Program inv_lot_api_pub.Create_Inv_lot return ' || l_return_status || ':' || l_progress, 1);
1821: print_debug('Printing the values of x_lot_rec after calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);
1822: print_debug('x_lot_rec.INVENTORY_ITEM_ID: '|| x_lot_rec.INVENTORY_ITEM_ID||':'||l_progress, 1);
1823: print_debug('x_lot_rec.ORGANIZATION_ID '|| x_lot_rec.ORGANIZATION_ID||':'||l_progress, 1);
1824: print_debug('x_lot_rec.LOT_NUMBER :'|| x_lot_rec.LOT_NUMBER ||':'|| l_progress, 1);
1825: print_debug('x_lot_rec.LAST_UPDATE_DATE:'|| x_lot_rec.LAST_UPDATE_DATE||':'|| l_progress, 1);

Line 1873: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a user defined exception : ' || l_progress, 9);

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');
1876: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1877: fnd_msg_pub.ADD;

Line 1876: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');

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');
1876: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1877: fnd_msg_pub.ADD;
1878: RAISE g_exc_error;
1879:
1880: l_progress := '028' ;

Line 1883: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a Unexpected exception :'|| l_progress, 9);

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');
1886: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1887: fnd_msg_pub.ADD;

Line 1886: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');

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');
1886: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1887: fnd_msg_pub.ADD;
1888: RAISE g_exc_unexpected_error;
1889: END IF;
1890:

Line 1972: print_debug('Updating MTLT with x_lot_rec(inv_lot_api_pub.Create_Inv_lot) has failed with a Unexpected exception in INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'|| l_progress, 1);

1968:
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: IF g_debug = 1 THEN
1972: print_debug('Updating MTLT with x_lot_rec(inv_lot_api_pub.Create_Inv_lot) has failed with a Unexpected exception in INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'|| l_progress, 1);
1973: END IF;
1974: RAISE g_exc_unexpected_error;
1975: END;
1976: