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 594: print_debug('Calling inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY' , 1);

590: ) THEN
591: -- its a Inventory transaction
592: -- Call check lot indivisible API.
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

Line 595: inv_lot_api_pub.CHECK_LOT_INDIVISIBILITY (

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

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

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

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

616: END IF;
617:
618: -- END Bug# 4233182
619:
620: /*Moving the lot indiv call from here to INV_LOT_API_PUB.PO_CHECK_INDIVISIBILITY
621: Punit Kumar, 08-02-2005 */
622:
623: /*I
624:

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

637:
638: /*Call lot indivisibility procedure to check if whether in case of indivisible
639: lots we are transacting a quantity less than that specified for that lot.
640:
641: Call INV_LOT_API_PUB.validate_lot_indivisible (@ INVPLOTB.pls) */
642: /*I
643: IF g_debug = 1 THEN
644: print_debug('p_transaction_type_id is ' || p_transaction_type_id, 9);
645: print_debug('l_transaction_type is ' || l_transaction_type, 9);

Line 728: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(

724: END IF;
725:
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

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

746: ))THEN
747:
748: ------IF qoh and atr are passed as NULL THEN quantity tree is called in the API.
749: IF g_debug = 1 THEN
750: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return FALSE ' || l_return_status || 'and '|| l_progress, 9);
751: END IF;
752:
753: l_progress := '100' ;
754:

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

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

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

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

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

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

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

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

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

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

875:
876: END IF; ----IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
877:
878: IF g_debug = 1 THEN
879: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE ' || l_return_status || 'and '|| l_progress, 9);
880: END IF;
881:
882: -------- END IF ; ----------IF l_lot_ind_call = 'Y' THEN
883:

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

1642:
1643: l_progress := '027';
1644:
1645: IF g_debug = 1 THEN
1646: print_debug('Printing the values of p_lot_rec before calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);
1647: print_debug('l_lot_rec.INVENTORY_ITEM_ID: '|| l_lot_rec.INVENTORY_ITEM_ID||':'||l_progress, 1);
1648: print_debug('l_lot_rec.ORGANIZATION_ID '|| l_lot_rec.ORGANIZATION_ID||':'||l_progress, 1);
1649: print_debug('l_lot_rec.LOT_NUMBER :'|| l_lot_rec.LOT_NUMBER ||':'|| l_progress, 1);
1650: print_debug('l_lot_rec.PARENT_LOT_NUMBER :'|| l_lot_rec.PARENT_LOT_NUMBER ||':'|| l_progress, 1);

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

1694: END IF;
1695:
1696: l_progress := '271';
1697:
1698: /* Call Lot Create API INV_LOT_API_PUB.CREATE_INV_LOT to create the new lot.
1699: This shall also validate the attributes before creating the new Lot. */
1700:
1701: inv_lot_api_pub.Create_Inv_lot(
1702: x_return_status => l_return_status ,

Line 1701: inv_lot_api_pub.Create_Inv_lot(

1697:
1698: /* Call Lot Create API INV_LOT_API_PUB.CREATE_INV_LOT to create the new lot.
1699: This shall also validate the attributes before creating the new Lot. */
1700:
1701: inv_lot_api_pub.Create_Inv_lot(
1702: x_return_status => l_return_status ,
1703: x_msg_count => l_msg_count ,
1704: x_msg_data => l_msg_data ,
1705: x_row_id => l_row_id ,

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

1714: );
1715: l_progress := '272';
1716:
1717: IF g_debug = 1 THEN
1718: print_debug('Program inv_lot_api_pub.Create_Inv_lot return ' || l_return_status || ':' || l_progress, 1);
1719: print_debug('Printing the values of x_lot_rec after calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);
1720: print_debug('x_lot_rec.INVENTORY_ITEM_ID: '|| x_lot_rec.INVENTORY_ITEM_ID||':'||l_progress, 1);
1721: print_debug('x_lot_rec.ORGANIZATION_ID '|| x_lot_rec.ORGANIZATION_ID||':'||l_progress, 1);
1722: print_debug('x_lot_rec.LOT_NUMBER :'|| x_lot_rec.LOT_NUMBER ||':'|| l_progress, 1);

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

1715: l_progress := '272';
1716:
1717: IF g_debug = 1 THEN
1718: print_debug('Program inv_lot_api_pub.Create_Inv_lot return ' || l_return_status || ':' || l_progress, 1);
1719: print_debug('Printing the values of x_lot_rec after calling inv_lot_api_pub.Create_Inv_lot '|| l_progress, 1);
1720: print_debug('x_lot_rec.INVENTORY_ITEM_ID: '|| x_lot_rec.INVENTORY_ITEM_ID||':'||l_progress, 1);
1721: print_debug('x_lot_rec.ORGANIZATION_ID '|| x_lot_rec.ORGANIZATION_ID||':'||l_progress, 1);
1722: print_debug('x_lot_rec.LOT_NUMBER :'|| x_lot_rec.LOT_NUMBER ||':'|| l_progress, 1);
1723: print_debug('x_lot_rec.LAST_UPDATE_DATE:'|| x_lot_rec.LAST_UPDATE_DATE||':'|| l_progress, 1);

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

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

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

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');
1774: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1775: fnd_msg_pub.ADD;
1776: RAISE g_exc_error;
1777:
1778: l_progress := '028' ;

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

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

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

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');
1784: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1785: fnd_msg_pub.ADD;
1786: RAISE g_exc_unexpected_error;
1787: END IF;
1788:

Line 1870: 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);

1866:
1867: EXCEPTION
1868: WHEN OTHERS THEN
1869: IF g_debug = 1 THEN
1870: 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);
1871: END IF;
1872: RAISE g_exc_unexpected_error;
1873: END;
1874: