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.WMS_STRATEGY_PVT dependencies on INV_PP_DEBUG

Line 334: IF inv_pp_debug.is_debug_mode THEN

330:
331: /* --
332: -- debugging portion
333: -- can be commented ut for final code
334: IF inv_pp_debug.is_debug_mode THEN
335: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
336: END IF;
337: -- end of debugging section
338: --

Line 335: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

331: /* --
332: -- debugging portion
333: -- can be commented ut for final code
334: IF inv_pp_debug.is_debug_mode THEN
335: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
336: END IF;
337: -- end of debugging section
338: --
339: -- Get txn detail line input parameters

Line 451: IF inv_pp_debug.is_debug_mode THEN

447:
448: --
449: -- debugging portion
450: -- can be commented ut for final code
451: IF inv_pp_debug.is_debug_mode THEN
452: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
453: END IF;
454: -- end of debugging section
455: -- */

Line 452: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

448: --
449: -- debugging portion
450: -- can be commented ut for final code
451: IF inv_pp_debug.is_debug_mode THEN
452: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
453: END IF;
454: -- end of debugging section
455: -- */
456: If (l_debug = 1) then

Line 464: IF inv_pp_debug.is_debug_mode THEN

460: when others then
461: /* --
462: -- debugging portion
463: -- can be commented ut for final code
464: IF inv_pp_debug.is_debug_mode THEN
465: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
466: -- the message retrieved here since it is no longer on the stack
467: inv_pp_debug.set_last_error_message(Sqlerrm);
468: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 467: inv_pp_debug.set_last_error_message(Sqlerrm);

463: -- can be commented ut for final code
464: IF inv_pp_debug.is_debug_mode THEN
465: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
466: -- the message retrieved here since it is no longer on the stack
467: inv_pp_debug.set_last_error_message(Sqlerrm);
468: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
469: inv_pp_debug.send_last_error_message;
470: END IF;
471: -- end of debugging section

Line 468: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

464: IF inv_pp_debug.is_debug_mode THEN
465: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
466: -- the message retrieved here since it is no longer on the stack
467: inv_pp_debug.set_last_error_message(Sqlerrm);
468: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
469: inv_pp_debug.send_last_error_message;
470: END IF;
471: -- end of debugging section
472: -- */

Line 469: inv_pp_debug.send_last_error_message;

465: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
466: -- the message retrieved here since it is no longer on the stack
467: inv_pp_debug.set_last_error_message(Sqlerrm);
468: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
469: inv_pp_debug.send_last_error_message;
470: END IF;
471: -- end of debugging section
472: -- */
473: /* if inphead%isopen then

Line 559: IF inv_pp_debug.is_debug_mode THEN

555: /*--
556: --
557: -- debugging portion
558: -- can be commented ut for final code
559: IF inv_pp_debug.is_debug_mode THEN
560: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
561: END IF;
562: -- end of debugging section
563: -- */

Line 560: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

556: --
557: -- debugging portion
558: -- can be commented ut for final code
559: IF inv_pp_debug.is_debug_mode THEN
560: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
561: END IF;
562: -- end of debugging section
563: -- */
564: -- Initialize API return status to success

Line 614: IF inv_pp_debug.is_debug_mode THEN

610: /*
611: --
612: -- debugging portion
613: -- can be commented ut for final code
614: IF inv_pp_debug.is_debug_mode THEN
615: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
616: END IF;
617: -- end of debugging section
618: -- */

Line 615: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

611: --
612: -- debugging portion
613: -- can be commented ut for final code
614: IF inv_pp_debug.is_debug_mode THEN
615: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
616: END IF;
617: -- end of debugging section
618: -- */
619: If (l_debug = 1) then

Line 628: IF inv_pp_debug.is_debug_mode THEN

624: when others then
625: /* --
626: -- debugging portion
627: -- can be commented ut for final code
628: IF inv_pp_debug.is_debug_mode THEN
629: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
630: -- the message retrieved here since it is no longer on the stack
631: inv_pp_debug.set_last_error_message(Sqlerrm);
632: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 631: inv_pp_debug.set_last_error_message(Sqlerrm);

627: -- can be commented ut for final code
628: IF inv_pp_debug.is_debug_mode THEN
629: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
630: -- the message retrieved here since it is no longer on the stack
631: inv_pp_debug.set_last_error_message(Sqlerrm);
632: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
633: inv_pp_debug.send_last_error_message;
634: END IF;
635: -- end of debugging section

Line 632: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

628: IF inv_pp_debug.is_debug_mode THEN
629: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
630: -- the message retrieved here since it is no longer on the stack
631: inv_pp_debug.set_last_error_message(Sqlerrm);
632: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
633: inv_pp_debug.send_last_error_message;
634: END IF;
635: -- end of debugging section
636: -- */

Line 633: inv_pp_debug.send_last_error_message;

629: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
630: -- the message retrieved here since it is no longer on the stack
631: inv_pp_debug.set_last_error_message(Sqlerrm);
632: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
633: inv_pp_debug.send_last_error_message;
634: END IF;
635: -- end of debugging section
636: -- */
637: if rules%isopen then

Line 723: IF inv_pp_debug.is_debug_mode THEN

719: End if;
720: /*--
721: -- debugging portion
722: -- can be commented ut for final code
723: IF inv_pp_debug.is_debug_mode THEN
724: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
725: END IF;
726: -- end of debugging section
727: -- */

Line 724: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

720: /*--
721: -- debugging portion
722: -- can be commented ut for final code
723: IF inv_pp_debug.is_debug_mode THEN
724: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
725: END IF;
726: -- end of debugging section
727: -- */
728: open iteminfo;

Line 816: IF inv_pp_debug.is_debug_mode THEN

812: 'Created quantity tree in exclusive mode');
813: End if;
814: /* -- debugging portion
815: -- can be commented ut for final code
816: IF inv_pp_debug.is_debug_mode THEN
817: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
818: END IF;
819: -- end of debugging section */
820: If (l_debug = 1) then

Line 817: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

813: End if;
814: /* -- debugging portion
815: -- can be commented ut for final code
816: IF inv_pp_debug.is_debug_mode THEN
817: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
818: END IF;
819: -- end of debugging section */
820: If (l_debug = 1) then
821: log_procedure(l_api_name, 'end', 'End InitQtyTree');

Line 829: IF inv_pp_debug.is_debug_mode THEN

825: when others then
826: /* --
827: -- debugging portion
828: -- can be commented ut for final code
829: IF inv_pp_debug.is_debug_mode THEN
830: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
831: -- the message retrieved here since it is no longer on the stack
832: inv_pp_debug.set_last_error_message(Sqlerrm);
833: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 832: inv_pp_debug.set_last_error_message(Sqlerrm);

828: -- can be commented ut for final code
829: IF inv_pp_debug.is_debug_mode THEN
830: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
831: -- the message retrieved here since it is no longer on the stack
832: inv_pp_debug.set_last_error_message(Sqlerrm);
833: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
834: inv_pp_debug.send_last_error_message;
835: END IF;
836: -- end of debugging section

Line 833: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

829: IF inv_pp_debug.is_debug_mode THEN
830: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
831: -- the message retrieved here since it is no longer on the stack
832: inv_pp_debug.set_last_error_message(Sqlerrm);
833: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
834: inv_pp_debug.send_last_error_message;
835: END IF;
836: -- end of debugging section
837: -- */

Line 834: inv_pp_debug.send_last_error_message;

830: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
831: -- the message retrieved here since it is no longer on the stack
832: inv_pp_debug.set_last_error_message(Sqlerrm);
833: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
834: inv_pp_debug.send_last_error_message;
835: END IF;
836: -- end of debugging section
837: -- */
838: if iteminfo%isopen then

Line 867: IF inv_pp_debug.is_debug_mode THEN

863: begin
864: /* --
865: -- debugging portion
866: -- can be commented ut for final code
867: IF inv_pp_debug.is_debug_mode THEN
868: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
869: END IF;
870: -- end of debugging section
871: -- */

Line 868: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

864: /* --
865: -- debugging portion
866: -- can be commented ut for final code
867: IF inv_pp_debug.is_debug_mode THEN
868: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
869: END IF;
870: -- end of debugging section
871: -- */
872: Wms_re_common_pvt.InitInputTable;

Line 877: IF inv_pp_debug.is_debug_mode THEN

873: Wms_re_common_pvt.InitRulesTable;
874: /* --
875: -- debugging portion
876: -- can be commented ut for final code
877: IF inv_pp_debug.is_debug_mode THEN
878: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
879: END IF;
880: -- end of debugging section
881: -- */

Line 878: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

874: /* --
875: -- debugging portion
876: -- can be commented ut for final code
877: IF inv_pp_debug.is_debug_mode THEN
878: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
879: END IF;
880: -- end of debugging section
881: -- */
882: end FreeGlobals;

Line 1071: IF inv_pp_debug.is_debug_mode THEN

1067: log_procedure(l_api_name, 'start', 'Start Search');
1068: End if;
1069: /*-- debugging portion
1070: -- can be commented ut for final code
1071: IF inv_pp_debug.is_debug_mode THEN
1072: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1073: END IF;
1074: -- end of debugging section
1075: -- */

Line 1072: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

1068: End if;
1069: /*-- debugging portion
1070: -- can be commented ut for final code
1071: IF inv_pp_debug.is_debug_mode THEN
1072: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1073: END IF;
1074: -- end of debugging section
1075: -- */
1076: -- Standard call to check for call compatibility

Line 1377: --inv_pp_debug.send_long_to_pipe(l_stmt);

1373: -- remark: ordering of records is not necessary, because one effective
1374: -- strategy of one type ( pick OR put away )is allowed per object
1375: -- only !
1376: l_stmt := l_select || l_from || l_where || l_order_by;
1377: --inv_pp_debug.send_long_to_pipe(l_stmt);
1378: If (g_debug = 1) then
1379: log_event(l_api_name, 'Dynamic SQL STMT for Stg Search Order', l_stmt);
1380: End if;
1381:

Line 1430: --inv_pp_debug.send_message_to_pipe('no search order defined for this org');

1426: -- we don't want to raise error. calling function will have to
1427: -- use some sort of default. We should create a log message, though.
1428: if l_hierarchy = 0 then
1429: fnd_message.set_name('WMS','WMS_SEARCH_ORDER_EMPTY');
1430: --inv_pp_debug.send_message_to_pipe('no search order defined for this org');
1431: -- Strategy search object hierarchy contains no entry
1432: --fnd_msg_pub.add;
1433: If (g_debug = 1) then
1434: log_event(l_api_name, 'no_hierarchy',

Line 1441: -- inv_pp_debug.send_message_to_pipe('no strategy assigned');

1437: --raise fnd_api.g_exc_error;
1438: end if;
1439: if l_strategy_id is null then
1440: fnd_message.set_name('WMS','WMS_NO_STRATEGY_ASSIGN');
1441: -- inv_pp_debug.send_message_to_pipe('no strategy assigned');
1442: --No active strategy assignment detected according to provided input
1443: --fnd_msg_pub.add;
1444: If (g_debug = 1) then
1445: log_event(l_api_name, 'no_strategy',

Line 1498: IF inv_pp_debug.is_debug_mode THEN

1494:
1495: -- Standard call to get message count and if count is 1, get message info
1496: fnd_msg_pub.count_and_get( p_count => x_msg_count
1497: ,p_data => x_msg_data );
1498: IF inv_pp_debug.is_debug_mode THEN
1499: inv_pp_debug.send_message_to_pipe('strategy id found '||l_strategy_id);
1500: END IF;
1501: --
1502: -- debugging portion

Line 1499: inv_pp_debug.send_message_to_pipe('strategy id found '||l_strategy_id);

1495: -- Standard call to get message count and if count is 1, get message info
1496: fnd_msg_pub.count_and_get( p_count => x_msg_count
1497: ,p_data => x_msg_data );
1498: IF inv_pp_debug.is_debug_mode THEN
1499: inv_pp_debug.send_message_to_pipe('strategy id found '||l_strategy_id);
1500: END IF;
1501: --
1502: -- debugging portion
1503: -- can be commented ut for final code

Line 1504: IF inv_pp_debug.is_debug_mode THEN

1500: END IF;
1501: --
1502: -- debugging portion
1503: -- can be commented ut for final code
1504: IF inv_pp_debug.is_debug_mode THEN
1505: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1506: END IF;
1507: -- end of debugging section
1508: If (g_debug = 1) then

Line 1505: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

1501: --
1502: -- debugging portion
1503: -- can be commented ut for final code
1504: IF inv_pp_debug.is_debug_mode THEN
1505: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1506: END IF;
1507: -- end of debugging section
1508: If (g_debug = 1) then
1509: log_procedure(l_api_name, 'end', 'End Search');

Line 1519: IF inv_pp_debug.is_debug_mode THEN

1515: when fnd_api.g_exc_error then
1516: --
1517: -- debugging portion
1518: -- can be commented ut for final code
1519: IF inv_pp_debug.is_debug_mode THEN
1520: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1521: -- the message retrieved here since it is no longer on the stack
1522: inv_pp_debug.set_last_error_message(Sqlerrm);
1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

Line 1522: inv_pp_debug.set_last_error_message(Sqlerrm);

1518: -- can be commented ut for final code
1519: IF inv_pp_debug.is_debug_mode THEN
1520: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1521: -- the message retrieved here since it is no longer on the stack
1522: inv_pp_debug.set_last_error_message(Sqlerrm);
1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1524: --changed by jcearley on 11/22/99 because call was causing error
1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

1519: IF inv_pp_debug.is_debug_mode THEN
1520: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1521: -- the message retrieved here since it is no longer on the stack
1522: inv_pp_debug.set_last_error_message(Sqlerrm);
1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1524: --changed by jcearley on 11/22/99 because call was causing error
1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1527: inv_pp_debug.send_last_error_message;

Line 1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);

1521: -- the message retrieved here since it is no longer on the stack
1522: inv_pp_debug.set_last_error_message(Sqlerrm);
1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1524: --changed by jcearley on 11/22/99 because call was causing error
1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1527: inv_pp_debug.send_last_error_message;
1528: -- inv_pp_debug.send_last_dynamic_sql;
1529: inv_pp_debug.send_last_error_position;

Line 1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

1522: inv_pp_debug.set_last_error_message(Sqlerrm);
1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1524: --changed by jcearley on 11/22/99 because call was causing error
1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1527: inv_pp_debug.send_last_error_message;
1528: -- inv_pp_debug.send_last_dynamic_sql;
1529: inv_pp_debug.send_last_error_position;
1530: END IF;

Line 1527: inv_pp_debug.send_last_error_message;

1523: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1524: --changed by jcearley on 11/22/99 because call was causing error
1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1527: inv_pp_debug.send_last_error_message;
1528: -- inv_pp_debug.send_last_dynamic_sql;
1529: inv_pp_debug.send_last_error_position;
1530: END IF;
1531: -- end of debugging section

Line 1528: -- inv_pp_debug.send_last_dynamic_sql;

1524: --changed by jcearley on 11/22/99 because call was causing error
1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1527: inv_pp_debug.send_last_error_message;
1528: -- inv_pp_debug.send_last_dynamic_sql;
1529: inv_pp_debug.send_last_error_position;
1530: END IF;
1531: -- end of debugging section
1532: --

Line 1529: inv_pp_debug.send_last_error_position;

1525: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1526: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1527: inv_pp_debug.send_last_error_message;
1528: -- inv_pp_debug.send_last_dynamic_sql;
1529: inv_pp_debug.send_last_error_position;
1530: END IF;
1531: -- end of debugging section
1532: --
1533: inv_sql_binding_pvt.InitBindTables;

Line 1547: IF inv_pp_debug.is_debug_mode THEN

1543: when fnd_api.g_exc_unexpected_error then
1544: --
1545: -- debugging portion
1546: -- can be commented ut for final code
1547: IF inv_pp_debug.is_debug_mode THEN
1548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1549: -- the message retrieved here since it is no longer on the stack
1550: inv_pp_debug.set_last_error_message(Sqlerrm);
1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

Line 1550: inv_pp_debug.set_last_error_message(Sqlerrm);

1546: -- can be commented ut for final code
1547: IF inv_pp_debug.is_debug_mode THEN
1548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1549: -- the message retrieved here since it is no longer on the stack
1550: inv_pp_debug.set_last_error_message(Sqlerrm);
1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1554: inv_pp_debug.send_last_error_message;

Line 1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

1547: IF inv_pp_debug.is_debug_mode THEN
1548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1549: -- the message retrieved here since it is no longer on the stack
1550: inv_pp_debug.set_last_error_message(Sqlerrm);
1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1554: inv_pp_debug.send_last_error_message;
1555: -- inv_pp_debug.send_last_dynamic_sql;

Line 1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);

1548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1549: -- the message retrieved here since it is no longer on the stack
1550: inv_pp_debug.set_last_error_message(Sqlerrm);
1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1554: inv_pp_debug.send_last_error_message;
1555: -- inv_pp_debug.send_last_dynamic_sql;
1556: inv_pp_debug.send_last_error_position;

Line 1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

1549: -- the message retrieved here since it is no longer on the stack
1550: inv_pp_debug.set_last_error_message(Sqlerrm);
1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1554: inv_pp_debug.send_last_error_message;
1555: -- inv_pp_debug.send_last_dynamic_sql;
1556: inv_pp_debug.send_last_error_position;
1557: END IF;

Line 1554: inv_pp_debug.send_last_error_message;

1550: inv_pp_debug.set_last_error_message(Sqlerrm);
1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1554: inv_pp_debug.send_last_error_message;
1555: -- inv_pp_debug.send_last_dynamic_sql;
1556: inv_pp_debug.send_last_error_position;
1557: END IF;
1558: -- end of debugging section

Line 1555: -- inv_pp_debug.send_last_dynamic_sql;

1551: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1554: inv_pp_debug.send_last_error_message;
1555: -- inv_pp_debug.send_last_dynamic_sql;
1556: inv_pp_debug.send_last_error_position;
1557: END IF;
1558: -- end of debugging section
1559: --

Line 1556: inv_pp_debug.send_last_error_position;

1552: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1553: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1554: inv_pp_debug.send_last_error_message;
1555: -- inv_pp_debug.send_last_dynamic_sql;
1556: inv_pp_debug.send_last_error_position;
1557: END IF;
1558: -- end of debugging section
1559: --
1560: inv_sql_binding_pvt.InitBindTables;

Line 1574: IF inv_pp_debug.is_debug_mode THEN

1570: when others then
1571: --
1572: -- debugging portion
1573: -- can be commented ut for final code
1574: IF inv_pp_debug.is_debug_mode THEN
1575: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1576: -- the message retrieved here since it is no longer on the stack
1577: inv_pp_debug.set_last_error_message(Sqlerrm);
1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

Line 1577: inv_pp_debug.set_last_error_message(Sqlerrm);

1573: -- can be commented ut for final code
1574: IF inv_pp_debug.is_debug_mode THEN
1575: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1576: -- the message retrieved here since it is no longer on the stack
1577: inv_pp_debug.set_last_error_message(Sqlerrm);
1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1581: inv_pp_debug.send_last_error_message;

Line 1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

1574: IF inv_pp_debug.is_debug_mode THEN
1575: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1576: -- the message retrieved here since it is no longer on the stack
1577: inv_pp_debug.set_last_error_message(Sqlerrm);
1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1581: inv_pp_debug.send_last_error_message;
1582: -- inv_pp_debug.send_last_dynamic_sql;

Line 1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);

1575: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1576: -- the message retrieved here since it is no longer on the stack
1577: inv_pp_debug.set_last_error_message(Sqlerrm);
1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1581: inv_pp_debug.send_last_error_message;
1582: -- inv_pp_debug.send_last_dynamic_sql;
1583: inv_pp_debug.send_last_error_position;

Line 1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

1576: -- the message retrieved here since it is no longer on the stack
1577: inv_pp_debug.set_last_error_message(Sqlerrm);
1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1581: inv_pp_debug.send_last_error_message;
1582: -- inv_pp_debug.send_last_dynamic_sql;
1583: inv_pp_debug.send_last_error_position;
1584: END IF;

Line 1581: inv_pp_debug.send_last_error_message;

1577: inv_pp_debug.set_last_error_message(Sqlerrm);
1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1581: inv_pp_debug.send_last_error_message;
1582: -- inv_pp_debug.send_last_dynamic_sql;
1583: inv_pp_debug.send_last_error_position;
1584: END IF;
1585: -- end of debugging section

Line 1582: -- inv_pp_debug.send_last_dynamic_sql;

1578: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1581: inv_pp_debug.send_last_error_message;
1582: -- inv_pp_debug.send_last_dynamic_sql;
1583: inv_pp_debug.send_last_error_position;
1584: END IF;
1585: -- end of debugging section
1586: --

Line 1583: inv_pp_debug.send_last_error_position;

1579: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1580: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1581: inv_pp_debug.send_last_error_message;
1582: -- inv_pp_debug.send_last_dynamic_sql;
1583: inv_pp_debug.send_last_error_position;
1584: END IF;
1585: -- end of debugging section
1586: --
1587: inv_sql_binding_pvt.InitBindTables;

Line 2036: IF inv_pp_debug.is_debug_mode THEN

2032:
2033: -- Bug 2286454
2034: l_allow_non_partial_rules := p_allow_non_partial_rules;
2035:
2036: IF inv_pp_debug.is_debug_mode THEN
2037: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2038: END IF;
2039: -- end of debugging section
2040: --

Line 2037: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

2033: -- Bug 2286454
2034: l_allow_non_partial_rules := p_allow_non_partial_rules;
2035:
2036: IF inv_pp_debug.is_debug_mode THEN
2037: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2038: END IF;
2039: -- end of debugging section
2040: --
2041: -- Standard start of API savepoint

Line 2772: IF inv_pp_debug.is_debug_mode THEN

2768: ,p_data => x_msg_data );
2769: /* --
2770: -- debugging portion
2771: -- can be commented ut for final code
2772: IF inv_pp_debug.is_debug_mode THEN
2773: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2774: END IF;
2775: -- end of debugging section */
2776: If (l_debug = 1) then

Line 2773: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

2769: /* --
2770: -- debugging portion
2771: -- can be commented ut for final code
2772: IF inv_pp_debug.is_debug_mode THEN
2773: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2774: END IF;
2775: -- end of debugging section */
2776: If (l_debug = 1) then
2777: log_procedure(l_api_name, 'end', 'End Apply');

Line 2786: IF inv_pp_debug.is_debug_mode THEN

2782: when fnd_api.g_exc_error then
2783: /* --
2784: -- debugging portion
2785: -- can be commented ut for final code
2786: IF inv_pp_debug.is_debug_mode THEN
2787: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2788: -- the message retrieved here since it is no longer on the stack
2789: inv_pp_debug.set_last_error_message(Sqlerrm);
2790: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2789: inv_pp_debug.set_last_error_message(Sqlerrm);

2785: -- can be commented ut for final code
2786: IF inv_pp_debug.is_debug_mode THEN
2787: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2788: -- the message retrieved here since it is no longer on the stack
2789: inv_pp_debug.set_last_error_message(Sqlerrm);
2790: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2791: inv_pp_debug.send_last_error_message;
2792: END IF;
2793: -- end of debugging section

Line 2790: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2786: IF inv_pp_debug.is_debug_mode THEN
2787: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2788: -- the message retrieved here since it is no longer on the stack
2789: inv_pp_debug.set_last_error_message(Sqlerrm);
2790: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2791: inv_pp_debug.send_last_error_message;
2792: END IF;
2793: -- end of debugging section
2794: -- */

Line 2791: inv_pp_debug.send_last_error_message;

2787: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2788: -- the message retrieved here since it is no longer on the stack
2789: inv_pp_debug.set_last_error_message(Sqlerrm);
2790: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2791: inv_pp_debug.send_last_error_message;
2792: END IF;
2793: -- end of debugging section
2794: -- */
2795: rollback to ApplyStrategySP;

Line 2808: IF inv_pp_debug.is_debug_mode THEN

2804: when fnd_api.g_exc_unexpected_error then
2805: /*--
2806: -- debugging portion
2807: -- can be commented ut for final code
2808: IF inv_pp_debug.is_debug_mode THEN
2809: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2810: -- the message retrieved here since it is no longer on the stack
2811: inv_pp_debug.set_last_error_message(Sqlerrm);
2812: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2811: inv_pp_debug.set_last_error_message(Sqlerrm);

2807: -- can be commented ut for final code
2808: IF inv_pp_debug.is_debug_mode THEN
2809: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2810: -- the message retrieved here since it is no longer on the stack
2811: inv_pp_debug.set_last_error_message(Sqlerrm);
2812: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2813: inv_pp_debug.send_last_error_message;
2814: END IF;
2815: -- end of debugging section

Line 2812: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2808: IF inv_pp_debug.is_debug_mode THEN
2809: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2810: -- the message retrieved here since it is no longer on the stack
2811: inv_pp_debug.set_last_error_message(Sqlerrm);
2812: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2813: inv_pp_debug.send_last_error_message;
2814: END IF;
2815: -- end of debugging section
2816: -- */

Line 2813: inv_pp_debug.send_last_error_message;

2809: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2810: -- the message retrieved here since it is no longer on the stack
2811: inv_pp_debug.set_last_error_message(Sqlerrm);
2812: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2813: inv_pp_debug.send_last_error_message;
2814: END IF;
2815: -- end of debugging section
2816: -- */
2817: rollback to ApplyStrategySP;

Line 2832: IF inv_pp_debug.is_debug_mode THEN

2828: when others then
2829: /*--
2830: -- debugging portion
2831: -- can be commented ut for final code
2832: IF inv_pp_debug.is_debug_mode THEN
2833: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2834: -- the message retrieved here since it is no longer on the stack
2835: inv_pp_debug.set_last_error_message(Sqlerrm);
2836: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2835: inv_pp_debug.set_last_error_message(Sqlerrm);

2831: -- can be commented ut for final code
2832: IF inv_pp_debug.is_debug_mode THEN
2833: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2834: -- the message retrieved here since it is no longer on the stack
2835: inv_pp_debug.set_last_error_message(Sqlerrm);
2836: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2837: inv_pp_debug.send_last_error_message;
2838: END IF;
2839: -- end of debugging section

Line 2836: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2832: IF inv_pp_debug.is_debug_mode THEN
2833: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2834: -- the message retrieved here since it is no longer on the stack
2835: inv_pp_debug.set_last_error_message(Sqlerrm);
2836: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2837: inv_pp_debug.send_last_error_message;
2838: END IF;
2839: -- end of debugging section
2840: -- */

Line 2837: inv_pp_debug.send_last_error_message;

2833: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2834: -- the message retrieved here since it is no longer on the stack
2835: inv_pp_debug.set_last_error_message(Sqlerrm);
2836: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2837: inv_pp_debug.send_last_error_message;
2838: END IF;
2839: -- end of debugging section
2840: -- */
2841: rollback to ApplyStrategySP;