[Home] [Help]
453: BEGIN
454: IF (l_debug = 1) THEN
455: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');
456: END IF;
457: -- Standard Start of API savepoint
458: SAVEPOINT apiinsertlot_apipub;
459:
460: -- Standard call to check for call compatibility.
461: IF NOT fnd_api.compatible_api_call ( l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
456: END IF;
457: -- Standard Start of API savepoint
458: SAVEPOINT apiinsertlot_apipub;
459:
460: -- Standard call to check for call compatibility.
461: IF NOT fnd_api.compatible_api_call ( l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
462: RAISE fnd_api.g_exc_unexpected_error;
463: END IF;
464:
1537: END IF;
1538: END IF;
1539:
1540: -- End of API body.
1541: -- Standard check of p_commit.
1542: IF (l_debug = 1) THEN
1543: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inserted the Lot ' || p_lot_number, 'INV_LOT_API_PUB');
1544: END IF;
1545:
1546: IF fnd_api.to_boolean ( p_commit ) THEN
1547: COMMIT WORK;
1548: END IF;
1549:
1550: -- Standard call to get message count and if count is 1, get message info.
1551: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1552: --x_return_status := l_return_status;
1553:
1554: --print_debug('end insertlot', 4);
1681: WHERE lot_number = p_lot_number
1682: AND transaction_temp_id = p_trx_temp_id;
1683: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1684: BEGIN
1685: -- Standard Start of API savepoint
1686: SAVEPOINT apiinsertlot_apipub;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT fnd_api.compatible_api_call (
1684: BEGIN
1685: -- Standard Start of API savepoint
1686: SAVEPOINT apiinsertlot_apipub;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT fnd_api.compatible_api_call (
1690: l_api_version,
1691: p_api_version,
1692: l_api_name,
2388: THEN
2389: COMMIT;
2390: END IF;
2391:
2392: -- Standard call to get message count and if count is 1, get message info.
2393: fnd_msg_pub.count_and_get (
2394: p_encoded => fnd_api.g_false,
2395: p_count => x_msg_count,
2396: p_data => x_msg_data
2911:
2912:
2913:
2914: BEGIN
2915: -- Standard Start of API savepoint
2916: SAVEPOINT apiauto_gen_lot_apipub;
2917: IF (l_debug = 1) THEN
2918: print_debug('in auto_gen_lot',9);
2919: END IF;
2916: SAVEPOINT apiauto_gen_lot_apipub;
2917: IF (l_debug = 1) THEN
2918: print_debug('in auto_gen_lot',9);
2919: END IF;
2920: -- Standard call to check for call compatibility.
2921:
2922: IF NOT fnd_api.compatible_api_call (
2923: l_api_version,
2924: p_api_version,
2942:
2943: /*================================================
2944: Joe DiIorio 05/17/2004 OPM Convergence.
2945: Added logic upfront to deal with parent_lot.
2946: Standard lot generation will bypass this
2947: and proceed as usual. Entry of parent lot
2948: means you want to generate a child lot.
2949: ==============================================*/
2950: IF (p_parent_lot_number IS NOT NULL) THEN
8268: IF FND_API.to_boolean(p_init_msg_list) THEN
8269: FND_MSG_PUB.Initialize;
8270: END IF;
8271:
8272: -- Standard call to check for call compatibility.
8273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
8274: p_api_version ,
8275: l_api_name ,
8276: G_PKG_NAME ) THEN
8748: IF FND_API.to_boolean(p_init_msg_list) THEN
8749: FND_MSG_PUB.Initialize;
8750: END IF;
8751:
8752: -- Standard call to check for call compatibility.
8753: IF NOT FND_API.Compatible_API_Call( l_api_version
8754: , p_api_version
8755: , l_api_name
8756: , G_PKG_NAME)
10322:
10323:
10324: BEGIN
10325:
10326: -- Standard call to check for call compatibility.
10327: IF NOT fnd_api.compatible_api_call(
10328: l_api_version,
10329: p_api_version,
10330: l_api_name,
10716: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
10717: FND_MSG_PUB.Initialize;
10718: END IF;
10719:
10720: -- Standard call to check for call compatibility.
10721: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version
10722: , p_api_version
10723: , l_api_name
10724: , G_PKG_NAME)