309: *** End R12 }} ***/
310:
311: /*** {{ R12 Enhanced reservations code changes ***/
312: IF (g_debug IS NULL) THEN
313: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
314: END IF;
315:
316: l_debug := g_debug;
317:
444: BEGIN
445:
446: /*** {{ R12 Enhanced reservations code changes ***/
447: IF (g_debug IS NULL) THEN
448: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
449: END IF;
450:
451: l_debug := g_debug;
452:
542:
543: BEGIN
544:
545: IF (g_debug IS NULL) THEN
546: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
547: END IF;
548:
549: l_debug := g_debug;
550:
646: l_valid_status VARCHAR2(1);
647: BEGIN
648:
649: IF (g_debug IS NULL) THEN
650: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
651: END IF;
652:
653: l_debug := g_debug;
654:
765: l_valid_status VARCHAR2(1);
766: BEGIN
767:
768: IF (g_debug IS NULL) THEN
769: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
770: END IF;
771:
772: l_debug := g_debug;
773:
900: l_valid_status VARCHAR2(1);
901: BEGIN
902:
903: IF (g_debug IS NULL) THEN
904: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
905: END IF;
906:
907: l_debug := g_debug;
908:
1018: l_debug NUMBER;
1019: BEGIN
1020:
1021: IF (g_debug IS NULL) THEN
1022: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1023: END IF;
1024:
1025: l_debug := g_debug;
1026:
1125: l_debug NUMBER;
1126: BEGIN
1127:
1128: IF (g_debug IS NULL) THEN
1129: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1130: END IF;
1131:
1132: l_debug := g_debug;
1133:
1252: l_debug NUMBER;
1253: BEGIN
1254:
1255: IF (g_debug IS NULL) THEN
1256: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1257: END IF;
1258:
1259: l_debug := g_debug;
1260:
1381: l_debug NUMBER;
1382: BEGIN
1383:
1384: IF (g_debug IS NULL) THEN
1385: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1386: END IF;
1387:
1388: l_debug := g_debug;
1389:
1511: l_debug NUMBER;
1512: BEGIN
1513:
1514: IF (g_debug IS NULL) THEN
1515: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1516: END IF;
1517:
1518: l_debug := g_debug;
1519:
1615:
1616: BEGIN
1617:
1618: IF (g_debug IS NULL) THEN
1619: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1620: END IF;
1621:
1622: l_debug := g_debug;
1623:
1702:
1703: BEGIN
1704:
1705: IF (g_debug IS NULL) THEN
1706: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1707: END IF;
1708:
1709: l_debug := g_debug;
1710:
1809:
1810: BEGIN
1811:
1812: IF (g_debug IS NULL) THEN
1813: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1814: END IF;
1815:
1816: l_debug := g_debug;
1817:
1917:
1918: BEGIN
1919:
1920: IF (g_debug IS NULL) THEN
1921: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1922: END IF;
1923:
1924: l_debug := g_debug;
1925:
2661: BEGIN
2662: --
2663: /*** {{ R12 Enhanced reservations code changes ***/
2664: IF (g_debug IS NULL) THEN
2665: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2666: END IF;
2667:
2668: l_debug := g_debug;
2669:
3557: BEGIN
3558: --
3559: /*** {{ R12 Enhanced reservations code changes ***/
3560: IF (g_debug IS NULL) THEN
3561: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3562: END IF;
3563:
3564: l_debug := g_debug;
3565:
3919:
3920: BEGIN
3921:
3922: IF (g_debug IS NULL) THEN
3923: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3924: END IF;
3925:
3926: l_debug := g_debug;
3927:
3998:
3999: BEGIN
4000:
4001: IF (g_debug IS NULL) THEN
4002: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4003: END IF;
4004:
4005: l_debug := g_debug;
4006:
4077:
4078: BEGIN
4079:
4080: IF (g_debug IS NULL) THEN
4081: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4082: END IF;
4083:
4084: l_debug := g_debug;
4085:
4154:
4155: BEGIN
4156:
4157: IF (g_debug IS NULL) THEN
4158: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4159: END IF;
4160:
4161: l_debug := g_debug;
4162:
4230:
4231: BEGIN
4232:
4233: IF (g_debug IS NULL) THEN
4234: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4235: END IF;
4236:
4237: l_debug := g_debug;
4238:
4319: l_qty_modified NUMBER := 0;
4320: BEGIN
4321:
4322: IF (g_debug IS NULL) THEN
4323: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4324: END IF;
4325:
4326: l_debug := g_debug;
4327:
4644:
4645: BEGIN
4646:
4647: IF (g_debug IS NULL) THEN
4648: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4649: END IF;
4650:
4651: l_debug := g_debug;
4652:
5574: -- listed reservation action. If not error out right away.
5575: --
5576:
5577: IF (g_debug IS NULL) THEN
5578: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5579: END IF;
5580:
5581: l_debug := g_debug;
5582: