[Home] [Help]
342: BEGIN
343: IF (l_debug = 1) THEN
344: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');
345: END IF;
346: -- Standard Start of API savepoint
347: SAVEPOINT apiinsertlot_apipub;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT fnd_api.compatible_api_call ( l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
345: END IF;
346: -- Standard Start of API savepoint
347: SAVEPOINT apiinsertlot_apipub;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT fnd_api.compatible_api_call ( l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
351: RAISE fnd_api.g_exc_unexpected_error;
352: END IF;
353:
1418: END IF;
1419: END IF;
1420:
1421: -- End of API body.
1422: -- Standard check of p_commit.
1423: IF (l_debug = 1) THEN
1424: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inserted the Lot ' || p_lot_number, 'INV_LOT_API_PUB');
1425: END IF;
1426:
1427: IF fnd_api.to_boolean ( p_commit ) THEN
1428: COMMIT WORK;
1429: END IF;
1430:
1431: -- Standard call to get message count and if count is 1, get message info.
1432: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1433: --x_return_status := l_return_status;
1434:
1435: --print_debug('end insertlot', 4);
1562: WHERE lot_number = p_lot_number
1563: AND transaction_temp_id = p_trx_temp_id;
1564: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1565: BEGIN
1566: -- Standard Start of API savepoint
1567: SAVEPOINT apiinsertlot_apipub;
1568:
1569: -- Standard call to check for call compatibility.
1570: IF NOT fnd_api.compatible_api_call (
1565: BEGIN
1566: -- Standard Start of API savepoint
1567: SAVEPOINT apiinsertlot_apipub;
1568:
1569: -- Standard call to check for call compatibility.
1570: IF NOT fnd_api.compatible_api_call (
1571: l_api_version,
1572: p_api_version,
1573: l_api_name,
2269: THEN
2270: COMMIT;
2271: END IF;
2272:
2273: -- Standard call to get message count and if count is 1, get message info.
2274: fnd_msg_pub.count_and_get (
2275: p_encoded => fnd_api.g_false,
2276: p_count => x_msg_count,
2277: p_data => x_msg_data
2764:
2765:
2766:
2767: BEGIN
2768: -- Standard Start of API savepoint
2769: SAVEPOINT apiauto_gen_lot_apipub;
2770: IF (l_debug = 1) THEN
2771: print_debug('in auto_gen_lot',9);
2772: END IF;
2769: SAVEPOINT apiauto_gen_lot_apipub;
2770: IF (l_debug = 1) THEN
2771: print_debug('in auto_gen_lot',9);
2772: END IF;
2773: -- Standard call to check for call compatibility.
2774:
2775: IF NOT fnd_api.compatible_api_call (
2776: l_api_version,
2777: p_api_version,
2795:
2796: /*================================================
2797: Joe DiIorio 05/17/2004 OPM Convergence.
2798: Added logic upfront to deal with parent_lot.
2799: Standard lot generation will bypass this
2800: and proceed as usual. Entry of parent lot
2801: means you want to generate a child lot.
2802: ==============================================*/
2803: IF (p_parent_lot_number IS NOT NULL) THEN
7915: IF FND_API.to_boolean(p_init_msg_list) THEN
7916: FND_MSG_PUB.Initialize;
7917: END IF;
7918:
7919: -- Standard call to check for call compatibility.
7920: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
7921: p_api_version ,
7922: l_api_name ,
7923: G_PKG_NAME ) THEN
8371: IF FND_API.to_boolean(p_init_msg_list) THEN
8372: FND_MSG_PUB.Initialize;
8373: END IF;
8374:
8375: -- Standard call to check for call compatibility.
8376: IF NOT FND_API.Compatible_API_Call( l_api_version
8377: , p_api_version
8378: , l_api_name
8379: , G_PKG_NAME)
9845:
9846:
9847: BEGIN
9848:
9849: -- Standard call to check for call compatibility.
9850: IF NOT fnd_api.compatible_api_call(
9851: l_api_version,
9852: p_api_version,
9853: l_api_name,
10239: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
10240: FND_MSG_PUB.Initialize;
10241: END IF;
10242:
10243: -- Standard call to check for call compatibility.
10244: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version
10245: , p_api_version
10246: , l_api_name
10247: , G_PKG_NAME)