DBA Data[Home] [Help]

APPS.INV_CR_ASN_DETAILS dependencies on FND_PROFILE

Line 10: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

6:
7: PROCEDURE print_debug(p_err_msg VARCHAR2,
8: p_level NUMBER)
9: IS
10: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11: BEGIN
12:
13: IF (l_debug = 1) THEN
14: inv_mobile_helper_functions.tracelog

Line 28: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

24: IS
25: l_userid NUMBER;
26: l_loginid NUMBER;
27:
28: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
29: BEGIN
30: l_userid := fnd_global.user_id;
31: l_loginid := fnd_global.login_id;
32:

Line 98: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

94: l_exists varchar2(10);
95: l_userid NUMBER;
96: l_loginid NUMBER;
97:
98: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
99: BEGIN
100:
101: l_userid := fnd_global.user_id;
102: l_loginid := fnd_global.login_id;

Line 140: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

136: l_exists varchar2(10);
137: l_userid NUMBER;
138: l_loginid NUMBER;
139:
140: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
141: BEGIN
142:
143: l_userid := fnd_global.user_id;
144: l_loginid := fnd_global.login_id;

Line 175: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

171:
172:
173: PROCEDURE initialize_details(p_create_asn_details_rec IN OUT nocopy asn_details_rec_tp )
174: IS
175: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
176: Begin
177: -- p_create_asn_details_rec.GROUP_ID := to_number(null);
178: -- p_create_asn_details_rec.SHIPMENT_NUM := null;
179: -- p_create_asn_details_rec.ORGANIZATION_ID := to_number(null);

Line 207: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

203: IS
204:
205: l_exists varchar2(10);
206:
207: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
208: BEGIN
209:
210: Begin
211: select 1 into l_exists

Line 238: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

234: IS
235:
236: l_exists varchar2(10);
237:
238: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
239: BEGIN
240:
241: Begin
242: select 1 into l_exists

Line 269: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

265: l_exists varchar2(10);
266: l_userid NUMBER;
267: l_loginid NUMBER;
268:
269: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
270: BEGIN
271:
272: Begin
273: select 1 into l_exists

Line 313: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

309: l_exists varchar2(10);
310: l_userid NUMBER;
311: l_loginid NUMBER;
312:
313: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
314: BEGIN
315:
316: -- LOT is already there update the quantity
317: -- Bug 2096130

Line 362: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

358:
359: PROCEDURE insert_asn_ser_details_exp(p_create_asn_details_rec IN OUT nocopy asn_details_rec_tp )
360: IS
361: l_exists varchar2(10);
362: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
363: BEGIN
364:
365: Begin
366: select 1 into l_exists

Line 390: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

386:
387: PROCEDURE insert_asn_ser_details_act(p_create_asn_details_rec IN OUT nocopy asn_details_rec_tp )
388: IS
389: l_exists varchar2(10);
390: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
391: BEGIN
392:
393: Begin
394: select 1 into l_exists

Line 421: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

417: )
418: return boolean
419: IS
420: l_exists number;
421: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
422: Begin
423: For c_item_details in ( select * from WMS_ASN_DETAILS
424: where shipment_num = p_shipment_num
425: and organization_id = p_organization_id

Line 550: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

546: p_lot_number varchar2(80);
547: p_num_lots number;
548: p_lot_quantity number;
549:
550: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
551: BEGIN
552:
553: SAVEPOINT crt_asn_details;
554: x_status := FND_API.G_RET_STS_SUCCESS;

Line 909: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

905:
906: l_vendor_id number;
907: l_vendor_site_id number;
908:
909: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
910: BEGIN
911:
912: SAVEPOINT crt_asn_details_interface;
913: x_status := FND_API.G_RET_STS_SUCCESS;