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_LOT_API_PKG dependencies on INV_LOT_API_PKG

Line 1: PACKAGE BODY INV_LOT_API_PKG

1: PACKAGE BODY INV_LOT_API_PKG
2: /* $Header: INVVLTPB.pls 120.4.12010000.2 2008/07/29 13:48:35 ptkumar ship $ */
3: AS
4:
5: -- Global constant holding the package name

Line 6: g_pkg_name CONSTANT VARCHAR2 ( 30 ) := 'INV_LOT_API_PKG';

2: /* $Header: INVVLTPB.pls 120.4.12010000.2 2008/07/29 13:48:35 ptkumar ship $ */
3: AS
4:
5: -- Global constant holding the package name
6: g_pkg_name CONSTANT VARCHAR2 ( 30 ) := 'INV_LOT_API_PKG';
7:
8:
9: PROCEDURE print_debug ( p_err_msg VARCHAR2, p_level NUMBER DEFAULT 1)
10: IS

Line 15: p_module => 'INV_LOT_API_PKG',

11: BEGIN
12: IF (g_debug = 1) THEN
13: inv_mobile_helper_functions.tracelog (
14: p_err_msg => p_err_msg,
15: p_module => 'INV_LOT_API_PKG',
16: p_level => p_level
17: );
18:
19: END IF;

Line 212: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);

208: , p_organization_id => p_lot_rec.organization_id
209: ) ;
210:
211: IF g_debug = 1 THEN
212: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);
213: END IF;
214:
215: IF l_return_status = fnd_api.g_ret_sts_error THEN
216: IF g_debug = 1 THEN

Line 217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);

213: END IF;
214:
215: IF l_return_status = fnd_api.g_ret_sts_error THEN
216: IF g_debug = 1 THEN
217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
218: END IF;
219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
221: FND_MSG_PUB.ADD;

Line 220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

216: IF g_debug = 1 THEN
217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
218: END IF;
219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
221: FND_MSG_PUB.ADD;
222: RAISE fnd_api.g_exc_error;
223: END IF;
224:

Line 227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);

223: END IF;
224:
225: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
226: IF g_debug = 1 THEN
227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
228: END IF;
229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
231: fnd_msg_pub.ADD;

Line 230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

226: IF g_debug = 1 THEN
227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
228: END IF;
229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
231: fnd_msg_pub.ADD;
232: RAISE fnd_api.g_exc_unexpected_error;
233: END IF;
234:

Line 418: Inv_Lot_Api_Pkg.Set_Msi_Default_Attr(

414:
415: ELSE
416:
417: /* Default Missing Attributes from Item Master by calling Set_Msi_Default_Attr API */
418: Inv_Lot_Api_Pkg.Set_Msi_Default_Attr(
419: p_lot_rec => x_child_lot_rec
420: , x_return_status => l_return_status
421: , x_msg_count => l_msg_count
422: , x_msg_data => l_msg_data

Line 426: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr return ' || l_return_status, 9);

422: , x_msg_data => l_msg_data
423: ) ;
424:
425: IF g_debug = 1 THEN
426: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr return ' || l_return_status, 9);
427: END IF;
428: IF l_return_status = fnd_api.g_ret_sts_error THEN
429: IF g_debug = 1 THEN
430: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a user defined exception', 9);

Line 430: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a user defined exception', 9);

426: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr return ' || l_return_status, 9);
427: END IF;
428: IF l_return_status = fnd_api.g_ret_sts_error THEN
429: IF g_debug = 1 THEN
430: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a user defined exception', 9);
431: END IF;
432: RAISE fnd_api.g_exc_error;
433: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
434: IF g_debug = 1 THEN

Line 435: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a Unexpected exception', 9);

431: END IF;
432: RAISE fnd_api.g_exc_error;
433: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
434: IF g_debug = 1 THEN
435: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a Unexpected exception', 9);
436: END IF;
437: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
438: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_Lot_Api_Pkg.Set_Msi_Default_Attr');
439: FND_MSG_PUB.ADD;

Line 438: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_Lot_Api_Pkg.Set_Msi_Default_Attr');

434: IF g_debug = 1 THEN
435: print_debug('Program Inv_Lot_Api_Pkg.Set_Msi_Default_Attr has failed with a Unexpected exception', 9);
436: END IF;
437: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
438: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_Lot_Api_Pkg.Set_Msi_Default_Attr');
439: FND_MSG_PUB.ADD;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442:

Line 484: INV_LOT_API_PKG.Validate_Lot_Attributes (

480: RAISE fnd_api.g_exc_unexpected_error;
481: END IF;
482: END IF ; --parent lot check
483: /* Validate parent lot record x_parent_lot_rec by calling VALIDATE_LOT_ATTRIBUTES API */
484: INV_LOT_API_PKG.Validate_Lot_Attributes (
485: x_lot_rec => x_child_lot_rec
486: , p_source => l_source
487: , x_return_status => l_return_status
488: , x_msg_data => l_msg_data

Line 492: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES return ' || l_return_status, 9);

488: , x_msg_data => l_msg_data
489: , x_msg_count => l_msg_count
490: ) ;
491: IF g_debug = 1 THEN
492: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES return ' || l_return_status, 9);
493: END IF;
494: IF l_return_status = fnd_api.g_ret_sts_error THEN
495: IF g_debug = 1 THEN
496: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a user defined exception', 9);

Line 496: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a user defined exception', 9);

492: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES return ' || l_return_status, 9);
493: END IF;
494: IF l_return_status = fnd_api.g_ret_sts_error THEN
495: IF g_debug = 1 THEN
496: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a user defined exception', 9);
497: END IF;
498: RAISE fnd_api.g_exc_error;
499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
500: IF g_debug = 1 THEN

Line 501: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a Unexpected exception', 9);

497: END IF;
498: RAISE fnd_api.g_exc_error;
499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
500: IF g_debug = 1 THEN
501: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a Unexpected exception', 9);
502: END IF;
503: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
504: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES');
505: FND_MSG_PUB.ADD;

Line 504: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES');

500: IF g_debug = 1 THEN
501: print_debug('Program INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES has failed with a Unexpected exception', 9);
502: END IF;
503: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
504: FND_MESSAGE.SET_TOKEN('PROG_NAME','INV_LOT_API_PKG.VALIDATE_LOT_ATTRIBUTES');
505: FND_MSG_PUB.ADD;
506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;
508:

Line 510: print_debug('Program INV_LOT_API_PKG.Populate_Lot_Records Ends ' , 9);

506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;
508:
509:
510: print_debug('Program INV_LOT_API_PKG.Populate_Lot_Records Ends ' , 9);
511:
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN
514: x_return_status := fnd_api.g_ret_sts_error;

Line 649: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);

645: , p_organization_id => p_lot_rec.organization_id
646: ) ;
647:
648: IF g_debug = 1 THEN
649: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);
650: END IF;
651:
652: IF l_return_status = fnd_api.g_ret_sts_error THEN
653: IF g_debug = 1 THEN

Line 654: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);

650: END IF;
651:
652: IF l_return_status = fnd_api.g_ret_sts_error THEN
653: IF g_debug = 1 THEN
654: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
655: END IF;
656: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
657: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
658: FND_MSG_PUB.ADD;

Line 657: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

653: IF g_debug = 1 THEN
654: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
655: END IF;
656: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
657: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
658: FND_MSG_PUB.ADD;
659: RAISE fnd_api.g_exc_error;
660: END IF;
661:

Line 664: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);

660: END IF;
661:
662: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
663: IF g_debug = 1 THEN
664: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
665: END IF;
666: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
667: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
668: fnd_msg_pub.ADD;

Line 667: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

663: IF g_debug = 1 THEN
664: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
665: END IF;
666: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
667: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
668: fnd_msg_pub.ADD;
669: RAISE fnd_api.g_exc_unexpected_error;
670: END IF;
671:

Line 1139: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);

1135: , p_organization_id => p_organization_id
1136: ) ;
1137:
1138: IF g_debug = 1 THEN
1139: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);
1140: END IF;
1141:
1142: IF l_return_status = fnd_api.g_ret_sts_error THEN
1143: IF g_debug = 1 THEN

Line 1144: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);

1140: END IF;
1141:
1142: IF l_return_status = fnd_api.g_ret_sts_error THEN
1143: IF g_debug = 1 THEN
1144: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1145: END IF;
1146: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1147: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1148: FND_MSG_PUB.ADD;

Line 1147: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1143: IF g_debug = 1 THEN
1144: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1145: END IF;
1146: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1147: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1148: FND_MSG_PUB.ADD;
1149: RAISE fnd_api.g_exc_error;
1150: END IF;
1151:

Line 1154: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);

1150: END IF;
1151:
1152: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1153: IF g_debug = 1 THEN
1154: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1155: END IF;
1156: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1157: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1158: fnd_msg_pub.ADD;

Line 1157: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1153: IF g_debug = 1 THEN
1154: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1155: END IF;
1156: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1157: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1158: fnd_msg_pub.ADD;
1159: RAISE fnd_api.g_exc_unexpected_error;
1160: END IF;
1161:

Line 1684: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);

1680: , p_organization_id => p_organization_id
1681: ) ;
1682:
1683: IF g_debug = 1 THEN
1684: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);
1685: END IF;
1686:
1687: IF l_return_status = fnd_api.g_ret_sts_error THEN
1688: IF g_debug = 1 THEN

Line 1689: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);

1685: END IF;
1686:
1687: IF l_return_status = fnd_api.g_ret_sts_error THEN
1688: IF g_debug = 1 THEN
1689: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1690: END IF;
1691: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1692: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1693: FND_MSG_PUB.ADD;

Line 1692: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1688: IF g_debug = 1 THEN
1689: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
1690: END IF;
1691: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
1692: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1693: FND_MSG_PUB.ADD;
1694: RAISE fnd_api.g_exc_error;
1695: END IF;
1696:

Line 1699: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);

1695: END IF;
1696:
1697: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1698: IF g_debug = 1 THEN
1699: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1700: END IF;
1701: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1702: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1703: fnd_msg_pub.ADD;

Line 1702: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

1698: IF g_debug = 1 THEN
1699: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
1700: END IF;
1701: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1702: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
1703: fnd_msg_pub.ADD;
1704: RAISE fnd_api.g_exc_unexpected_error;
1705: END IF;
1706:

Line 2212: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);

2208: , p_organization_id => p_organization_id
2209: ) ;
2210:
2211: IF g_debug = 1 THEN
2212: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes return ' || l_return_status, 9);
2213: END IF;
2214:
2215: IF l_return_status = fnd_api.g_ret_sts_error THEN
2216: IF g_debug = 1 THEN

Line 2217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);

2213: END IF;
2214:
2215: IF l_return_status = fnd_api.g_ret_sts_error THEN
2216: IF g_debug = 1 THEN
2217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
2218: END IF;
2219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
2220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2221: FND_MSG_PUB.ADD;

Line 2220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

2216: IF g_debug = 1 THEN
2217: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
2218: END IF;
2219: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
2220: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2221: FND_MSG_PUB.ADD;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:

Line 2227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);

2223: END IF;
2224:
2225: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2226: IF g_debug = 1 THEN
2227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
2228: END IF;
2229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2231: fnd_msg_pub.ADD;

Line 2230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');

2226: IF g_debug = 1 THEN
2227: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
2228: END IF;
2229: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2230: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
2231: fnd_msg_pub.ADD;
2232: RAISE fnd_api.g_exc_unexpected_error;
2233: END IF;
2234:

Line 2374: END INV_LOT_API_PKG ;

2370: END CHECK_EXISTING_LOT_DB;
2371:
2372: /** INVCONV ANTHIYAG 04-Nov-2004 End **/
2373:
2374: END INV_LOT_API_PKG ;