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 325: IF inv_pp_debug.is_debug_mode THEN

321:
322: /* --
323: -- debugging portion
324: -- can be commented ut for final code
325: IF inv_pp_debug.is_debug_mode THEN
326: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
327: END IF;
328: -- end of debugging section
329: --

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

322: /* --
323: -- debugging portion
324: -- can be commented ut for final code
325: IF inv_pp_debug.is_debug_mode THEN
326: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
327: END IF;
328: -- end of debugging section
329: --
330: -- Get txn detail line input parameters

Line 442: IF inv_pp_debug.is_debug_mode THEN

438:
439: --
440: -- debugging portion
441: -- can be commented ut for final code
442: IF inv_pp_debug.is_debug_mode THEN
443: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
444: END IF;
445: -- end of debugging section
446: -- */

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

439: --
440: -- debugging portion
441: -- can be commented ut for final code
442: IF inv_pp_debug.is_debug_mode THEN
443: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
444: END IF;
445: -- end of debugging section
446: -- */
447: If (l_debug = 1) then

Line 455: IF inv_pp_debug.is_debug_mode THEN

451: when others then
452: /* --
453: -- debugging portion
454: -- can be commented ut for final code
455: IF inv_pp_debug.is_debug_mode THEN
456: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
457: -- the message retrieved here since it is no longer on the stack
458: inv_pp_debug.set_last_error_message(Sqlerrm);
459: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 458: inv_pp_debug.set_last_error_message(Sqlerrm);

454: -- can be commented ut for final code
455: IF inv_pp_debug.is_debug_mode THEN
456: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
457: -- the message retrieved here since it is no longer on the stack
458: inv_pp_debug.set_last_error_message(Sqlerrm);
459: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
460: inv_pp_debug.send_last_error_message;
461: END IF;
462: -- end of debugging section

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

455: IF inv_pp_debug.is_debug_mode THEN
456: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
457: -- the message retrieved here since it is no longer on the stack
458: inv_pp_debug.set_last_error_message(Sqlerrm);
459: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
460: inv_pp_debug.send_last_error_message;
461: END IF;
462: -- end of debugging section
463: -- */

Line 460: inv_pp_debug.send_last_error_message;

456: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
457: -- the message retrieved here since it is no longer on the stack
458: inv_pp_debug.set_last_error_message(Sqlerrm);
459: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
460: inv_pp_debug.send_last_error_message;
461: END IF;
462: -- end of debugging section
463: -- */
464: /* if inphead%isopen then

Line 547: IF inv_pp_debug.is_debug_mode THEN

543: /*--
544: --
545: -- debugging portion
546: -- can be commented ut for final code
547: IF inv_pp_debug.is_debug_mode THEN
548: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
549: END IF;
550: -- end of debugging section
551: -- */

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

544: --
545: -- debugging portion
546: -- can be commented ut for final code
547: IF inv_pp_debug.is_debug_mode THEN
548: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
549: END IF;
550: -- end of debugging section
551: -- */
552: -- Initialize API return status to success

Line 590: IF inv_pp_debug.is_debug_mode THEN

586: /*
587: --
588: -- debugging portion
589: -- can be commented ut for final code
590: IF inv_pp_debug.is_debug_mode THEN
591: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
592: END IF;
593: -- end of debugging section
594: -- */

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

587: --
588: -- debugging portion
589: -- can be commented ut for final code
590: IF inv_pp_debug.is_debug_mode THEN
591: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
592: END IF;
593: -- end of debugging section
594: -- */
595: If (l_debug = 1) then

Line 604: IF inv_pp_debug.is_debug_mode THEN

600: when others then
601: /* --
602: -- debugging portion
603: -- can be commented ut for final code
604: IF inv_pp_debug.is_debug_mode THEN
605: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
606: -- the message retrieved here since it is no longer on the stack
607: inv_pp_debug.set_last_error_message(Sqlerrm);
608: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 607: inv_pp_debug.set_last_error_message(Sqlerrm);

603: -- can be commented ut for final code
604: IF inv_pp_debug.is_debug_mode THEN
605: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
606: -- the message retrieved here since it is no longer on the stack
607: inv_pp_debug.set_last_error_message(Sqlerrm);
608: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
609: inv_pp_debug.send_last_error_message;
610: END IF;
611: -- end of debugging section

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

604: IF inv_pp_debug.is_debug_mode THEN
605: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
606: -- the message retrieved here since it is no longer on the stack
607: inv_pp_debug.set_last_error_message(Sqlerrm);
608: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
609: inv_pp_debug.send_last_error_message;
610: END IF;
611: -- end of debugging section
612: -- */

Line 609: inv_pp_debug.send_last_error_message;

605: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
606: -- the message retrieved here since it is no longer on the stack
607: inv_pp_debug.set_last_error_message(Sqlerrm);
608: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
609: inv_pp_debug.send_last_error_message;
610: END IF;
611: -- end of debugging section
612: -- */
613: if rules%isopen then

Line 697: IF inv_pp_debug.is_debug_mode THEN

693: End if;
694: /*--
695: -- debugging portion
696: -- can be commented ut for final code
697: IF inv_pp_debug.is_debug_mode THEN
698: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
699: END IF;
700: -- end of debugging section
701: -- */

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

694: /*--
695: -- debugging portion
696: -- can be commented ut for final code
697: IF inv_pp_debug.is_debug_mode THEN
698: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
699: END IF;
700: -- end of debugging section
701: -- */
702: open iteminfo;

Line 778: IF inv_pp_debug.is_debug_mode THEN

774: 'Created quantity tree in exclusive mode');
775: End if;
776: /* -- debugging portion
777: -- can be commented ut for final code
778: IF inv_pp_debug.is_debug_mode THEN
779: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
780: END IF;
781: -- end of debugging section */
782: If (l_debug = 1) then

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

775: End if;
776: /* -- debugging portion
777: -- can be commented ut for final code
778: IF inv_pp_debug.is_debug_mode THEN
779: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
780: END IF;
781: -- end of debugging section */
782: If (l_debug = 1) then
783: log_procedure(l_api_name, 'end', 'End InitQtyTree');

Line 791: IF inv_pp_debug.is_debug_mode THEN

787: when others then
788: /* --
789: -- debugging portion
790: -- can be commented ut for final code
791: IF inv_pp_debug.is_debug_mode THEN
792: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
793: -- the message retrieved here since it is no longer on the stack
794: inv_pp_debug.set_last_error_message(Sqlerrm);
795: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 794: inv_pp_debug.set_last_error_message(Sqlerrm);

790: -- can be commented ut for final code
791: IF inv_pp_debug.is_debug_mode THEN
792: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
793: -- the message retrieved here since it is no longer on the stack
794: inv_pp_debug.set_last_error_message(Sqlerrm);
795: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
796: inv_pp_debug.send_last_error_message;
797: END IF;
798: -- end of debugging section

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

791: IF inv_pp_debug.is_debug_mode THEN
792: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
793: -- the message retrieved here since it is no longer on the stack
794: inv_pp_debug.set_last_error_message(Sqlerrm);
795: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
796: inv_pp_debug.send_last_error_message;
797: END IF;
798: -- end of debugging section
799: -- */

Line 796: inv_pp_debug.send_last_error_message;

792: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
793: -- the message retrieved here since it is no longer on the stack
794: inv_pp_debug.set_last_error_message(Sqlerrm);
795: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
796: inv_pp_debug.send_last_error_message;
797: END IF;
798: -- end of debugging section
799: -- */
800: if iteminfo%isopen then

Line 829: IF inv_pp_debug.is_debug_mode THEN

825: begin
826: /* --
827: -- debugging portion
828: -- can be commented ut for final code
829: IF inv_pp_debug.is_debug_mode THEN
830: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
831: END IF;
832: -- end of debugging section
833: -- */

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

826: /* --
827: -- debugging portion
828: -- can be commented ut for final code
829: IF inv_pp_debug.is_debug_mode THEN
830: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
831: END IF;
832: -- end of debugging section
833: -- */
834: Wms_re_common_pvt.InitInputTable;

Line 839: IF inv_pp_debug.is_debug_mode THEN

835: Wms_re_common_pvt.InitRulesTable;
836: /* --
837: -- debugging portion
838: -- can be commented ut for final code
839: IF inv_pp_debug.is_debug_mode THEN
840: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
841: END IF;
842: -- end of debugging section
843: -- */

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

836: /* --
837: -- debugging portion
838: -- can be commented ut for final code
839: IF inv_pp_debug.is_debug_mode THEN
840: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
841: END IF;
842: -- end of debugging section
843: -- */
844: end FreeGlobals;

Line 1033: IF inv_pp_debug.is_debug_mode THEN

1029: log_procedure(l_api_name, 'start', 'Start Search');
1030: End if;
1031: /*-- debugging portion
1032: -- can be commented ut for final code
1033: IF inv_pp_debug.is_debug_mode THEN
1034: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1035: END IF;
1036: -- end of debugging section
1037: -- */

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

1030: End if;
1031: /*-- debugging portion
1032: -- can be commented ut for final code
1033: IF inv_pp_debug.is_debug_mode THEN
1034: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1035: END IF;
1036: -- end of debugging section
1037: -- */
1038: -- Standard call to check for call compatibility

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

1335: -- remark: ordering of records is not necessary, because one effective
1336: -- strategy of one type ( pick OR put away )is allowed per object
1337: -- only !
1338: l_stmt := l_select || l_from || l_where || l_order_by;
1339: --inv_pp_debug.send_long_to_pipe(l_stmt);
1340: If (g_debug = 1) then
1341: log_event(l_api_name, 'Dynamic SQL STMT for Stg Search Order', l_stmt);
1342: End if;
1343:

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

1388: -- we don't want to raise error. calling function will have to
1389: -- use some sort of default. We should create a log message, though.
1390: if l_hierarchy = 0 then
1391: fnd_message.set_name('WMS','WMS_SEARCH_ORDER_EMPTY');
1392: --inv_pp_debug.send_message_to_pipe('no search order defined for this org');
1393: -- Strategy search object hierarchy contains no entry
1394: --fnd_msg_pub.add;
1395: If (g_debug = 1) then
1396: log_event(l_api_name, 'no_hierarchy',

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

1399: --raise fnd_api.g_exc_error;
1400: end if;
1401: if l_strategy_id is null then
1402: fnd_message.set_name('WMS','WMS_NO_STRATEGY_ASSIGN');
1403: -- inv_pp_debug.send_message_to_pipe('no strategy assigned');
1404: --No active strategy assignment detected according to provided input
1405: --fnd_msg_pub.add;
1406: If (g_debug = 1) then
1407: log_event(l_api_name, 'no_strategy',

Line 1460: IF inv_pp_debug.is_debug_mode THEN

1456:
1457: -- Standard call to get message count and if count is 1, get message info
1458: fnd_msg_pub.count_and_get( p_count => x_msg_count
1459: ,p_data => x_msg_data );
1460: IF inv_pp_debug.is_debug_mode THEN
1461: inv_pp_debug.send_message_to_pipe('strategy id found '||l_strategy_id);
1462: END IF;
1463: --
1464: -- debugging portion

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

1457: -- Standard call to get message count and if count is 1, get message info
1458: fnd_msg_pub.count_and_get( p_count => x_msg_count
1459: ,p_data => x_msg_data );
1460: IF inv_pp_debug.is_debug_mode THEN
1461: inv_pp_debug.send_message_to_pipe('strategy id found '||l_strategy_id);
1462: END IF;
1463: --
1464: -- debugging portion
1465: -- can be commented ut for final code

Line 1466: IF inv_pp_debug.is_debug_mode THEN

1462: END IF;
1463: --
1464: -- debugging portion
1465: -- can be commented ut for final code
1466: IF inv_pp_debug.is_debug_mode THEN
1467: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1468: END IF;
1469: -- end of debugging section
1470: If (g_debug = 1) then

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

1463: --
1464: -- debugging portion
1465: -- can be commented ut for final code
1466: IF inv_pp_debug.is_debug_mode THEN
1467: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1468: END IF;
1469: -- end of debugging section
1470: If (g_debug = 1) then
1471: log_procedure(l_api_name, 'end', 'End Search');

Line 1481: IF inv_pp_debug.is_debug_mode THEN

1477: when fnd_api.g_exc_error then
1478: --
1479: -- debugging portion
1480: -- can be commented ut for final code
1481: IF inv_pp_debug.is_debug_mode THEN
1482: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1483: -- the message retrieved here since it is no longer on the stack
1484: inv_pp_debug.set_last_error_message(Sqlerrm);
1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

Line 1484: inv_pp_debug.set_last_error_message(Sqlerrm);

1480: -- can be commented ut for final code
1481: IF inv_pp_debug.is_debug_mode THEN
1482: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1483: -- the message retrieved here since it is no longer on the stack
1484: inv_pp_debug.set_last_error_message(Sqlerrm);
1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1486: --changed by jcearley on 11/22/99 because call was causing error
1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

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

1481: IF inv_pp_debug.is_debug_mode THEN
1482: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1483: -- the message retrieved here since it is no longer on the stack
1484: inv_pp_debug.set_last_error_message(Sqlerrm);
1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1486: --changed by jcearley on 11/22/99 because call was causing error
1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1489: inv_pp_debug.send_last_error_message;

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

1483: -- the message retrieved here since it is no longer on the stack
1484: inv_pp_debug.set_last_error_message(Sqlerrm);
1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1486: --changed by jcearley on 11/22/99 because call was causing error
1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1489: inv_pp_debug.send_last_error_message;
1490: -- inv_pp_debug.send_last_dynamic_sql;
1491: inv_pp_debug.send_last_error_position;

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

1484: inv_pp_debug.set_last_error_message(Sqlerrm);
1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1486: --changed by jcearley on 11/22/99 because call was causing error
1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1489: inv_pp_debug.send_last_error_message;
1490: -- inv_pp_debug.send_last_dynamic_sql;
1491: inv_pp_debug.send_last_error_position;
1492: END IF;

Line 1489: inv_pp_debug.send_last_error_message;

1485: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1486: --changed by jcearley on 11/22/99 because call was causing error
1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1489: inv_pp_debug.send_last_error_message;
1490: -- inv_pp_debug.send_last_dynamic_sql;
1491: inv_pp_debug.send_last_error_position;
1492: END IF;
1493: -- end of debugging section

Line 1490: -- inv_pp_debug.send_last_dynamic_sql;

1486: --changed by jcearley on 11/22/99 because call was causing error
1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1489: inv_pp_debug.send_last_error_message;
1490: -- inv_pp_debug.send_last_dynamic_sql;
1491: inv_pp_debug.send_last_error_position;
1492: END IF;
1493: -- end of debugging section
1494: --

Line 1491: inv_pp_debug.send_last_error_position;

1487: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1488: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1489: inv_pp_debug.send_last_error_message;
1490: -- inv_pp_debug.send_last_dynamic_sql;
1491: inv_pp_debug.send_last_error_position;
1492: END IF;
1493: -- end of debugging section
1494: --
1495: inv_sql_binding_pvt.InitBindTables;

Line 1509: IF inv_pp_debug.is_debug_mode THEN

1505: when fnd_api.g_exc_unexpected_error then
1506: --
1507: -- debugging portion
1508: -- can be commented ut for final code
1509: IF inv_pp_debug.is_debug_mode THEN
1510: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1511: -- the message retrieved here since it is no longer on the stack
1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

Line 1512: inv_pp_debug.set_last_error_message(Sqlerrm);

1508: -- can be commented ut for final code
1509: IF inv_pp_debug.is_debug_mode THEN
1510: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1511: -- the message retrieved here since it is no longer on the stack
1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;

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

1509: IF inv_pp_debug.is_debug_mode THEN
1510: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1511: -- the message retrieved here since it is no longer on the stack
1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;
1517: -- inv_pp_debug.send_last_dynamic_sql;

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

1510: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1511: -- the message retrieved here since it is no longer on the stack
1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;
1517: -- inv_pp_debug.send_last_dynamic_sql;
1518: inv_pp_debug.send_last_error_position;

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

1511: -- the message retrieved here since it is no longer on the stack
1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;
1517: -- inv_pp_debug.send_last_dynamic_sql;
1518: inv_pp_debug.send_last_error_position;
1519: END IF;

Line 1516: inv_pp_debug.send_last_error_message;

1512: inv_pp_debug.set_last_error_message(Sqlerrm);
1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;
1517: -- inv_pp_debug.send_last_dynamic_sql;
1518: inv_pp_debug.send_last_error_position;
1519: END IF;
1520: -- end of debugging section

Line 1517: -- inv_pp_debug.send_last_dynamic_sql;

1513: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;
1517: -- inv_pp_debug.send_last_dynamic_sql;
1518: inv_pp_debug.send_last_error_position;
1519: END IF;
1520: -- end of debugging section
1521: --

Line 1518: inv_pp_debug.send_last_error_position;

1514: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1515: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1516: inv_pp_debug.send_last_error_message;
1517: -- inv_pp_debug.send_last_dynamic_sql;
1518: inv_pp_debug.send_last_error_position;
1519: END IF;
1520: -- end of debugging section
1521: --
1522: inv_sql_binding_pvt.InitBindTables;

Line 1536: IF inv_pp_debug.is_debug_mode THEN

1532: when others then
1533: --
1534: -- debugging portion
1535: -- can be commented ut for final code
1536: IF inv_pp_debug.is_debug_mode THEN
1537: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1538: -- the message retrieved here since it is no longer on the stack
1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);

Line 1539: inv_pp_debug.set_last_error_message(Sqlerrm);

1535: -- can be commented ut for final code
1536: IF inv_pp_debug.is_debug_mode THEN
1537: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1538: -- the message retrieved here since it is no longer on the stack
1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;

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

1536: IF inv_pp_debug.is_debug_mode THEN
1537: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1538: -- the message retrieved here since it is no longer on the stack
1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;
1544: -- inv_pp_debug.send_last_dynamic_sql;

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

1537: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
1538: -- the message retrieved here since it is no longer on the stack
1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;
1544: -- inv_pp_debug.send_last_dynamic_sql;
1545: inv_pp_debug.send_last_error_position;

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

1538: -- the message retrieved here since it is no longer on the stack
1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;
1544: -- inv_pp_debug.send_last_dynamic_sql;
1545: inv_pp_debug.send_last_error_position;
1546: END IF;

Line 1543: inv_pp_debug.send_last_error_message;

1539: inv_pp_debug.set_last_error_message(Sqlerrm);
1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;
1544: -- inv_pp_debug.send_last_dynamic_sql;
1545: inv_pp_debug.send_last_error_position;
1546: END IF;
1547: -- end of debugging section

Line 1544: -- inv_pp_debug.send_last_dynamic_sql;

1540: inv_pp_debug.set_last_error_position(dbms_sql.last_error_position);
1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;
1544: -- inv_pp_debug.send_last_dynamic_sql;
1545: inv_pp_debug.send_last_error_position;
1546: END IF;
1547: -- end of debugging section
1548: --

Line 1545: inv_pp_debug.send_last_error_position;

1541: -- inv_pp_debug.set_last_dynamic_sql(l_stmt);
1542: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
1543: inv_pp_debug.send_last_error_message;
1544: -- inv_pp_debug.send_last_dynamic_sql;
1545: inv_pp_debug.send_last_error_position;
1546: END IF;
1547: -- end of debugging section
1548: --
1549: inv_sql_binding_pvt.InitBindTables;

Line 1883: IF inv_pp_debug.is_debug_mode THEN

1879:
1880: -- Bug 2286454
1881: l_allow_non_partial_rules := p_allow_non_partial_rules;
1882:
1883: IF inv_pp_debug.is_debug_mode THEN
1884: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1885: END IF;
1886: -- end of debugging section
1887: --

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

1880: -- Bug 2286454
1881: l_allow_non_partial_rules := p_allow_non_partial_rules;
1882:
1883: IF inv_pp_debug.is_debug_mode THEN
1884: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1885: END IF;
1886: -- end of debugging section
1887: --
1888: -- Standard start of API savepoint

Line 2533: IF inv_pp_debug.is_debug_mode THEN

2529: ,p_data => x_msg_data );
2530: /* --
2531: -- debugging portion
2532: -- can be commented ut for final code
2533: IF inv_pp_debug.is_debug_mode THEN
2534: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2535: END IF;
2536: -- end of debugging section */
2537: If (l_debug = 1) then

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

2530: /* --
2531: -- debugging portion
2532: -- can be commented ut for final code
2533: IF inv_pp_debug.is_debug_mode THEN
2534: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2535: END IF;
2536: -- end of debugging section */
2537: If (l_debug = 1) then
2538: log_procedure(l_api_name, 'end', 'End Apply');

Line 2547: IF inv_pp_debug.is_debug_mode THEN

2543: when fnd_api.g_exc_error then
2544: /* --
2545: -- debugging portion
2546: -- can be commented ut for final code
2547: IF inv_pp_debug.is_debug_mode THEN
2548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2549: -- the message retrieved here since it is no longer on the stack
2550: inv_pp_debug.set_last_error_message(Sqlerrm);
2551: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2550: inv_pp_debug.set_last_error_message(Sqlerrm);

2546: -- can be commented ut for final code
2547: IF inv_pp_debug.is_debug_mode THEN
2548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2549: -- the message retrieved here since it is no longer on the stack
2550: inv_pp_debug.set_last_error_message(Sqlerrm);
2551: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2552: inv_pp_debug.send_last_error_message;
2553: END IF;
2554: -- end of debugging section

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

2547: IF inv_pp_debug.is_debug_mode THEN
2548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2549: -- the message retrieved here since it is no longer on the stack
2550: inv_pp_debug.set_last_error_message(Sqlerrm);
2551: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2552: inv_pp_debug.send_last_error_message;
2553: END IF;
2554: -- end of debugging section
2555: -- */

Line 2552: inv_pp_debug.send_last_error_message;

2548: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2549: -- the message retrieved here since it is no longer on the stack
2550: inv_pp_debug.set_last_error_message(Sqlerrm);
2551: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2552: inv_pp_debug.send_last_error_message;
2553: END IF;
2554: -- end of debugging section
2555: -- */
2556: rollback to ApplyStrategySP;

Line 2569: IF inv_pp_debug.is_debug_mode THEN

2565: when fnd_api.g_exc_unexpected_error then
2566: /*--
2567: -- debugging portion
2568: -- can be commented ut for final code
2569: IF inv_pp_debug.is_debug_mode THEN
2570: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2571: -- the message retrieved here since it is no longer on the stack
2572: inv_pp_debug.set_last_error_message(Sqlerrm);
2573: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2572: inv_pp_debug.set_last_error_message(Sqlerrm);

2568: -- can be commented ut for final code
2569: IF inv_pp_debug.is_debug_mode THEN
2570: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2571: -- the message retrieved here since it is no longer on the stack
2572: inv_pp_debug.set_last_error_message(Sqlerrm);
2573: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2574: inv_pp_debug.send_last_error_message;
2575: END IF;
2576: -- end of debugging section

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

2569: IF inv_pp_debug.is_debug_mode THEN
2570: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2571: -- the message retrieved here since it is no longer on the stack
2572: inv_pp_debug.set_last_error_message(Sqlerrm);
2573: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2574: inv_pp_debug.send_last_error_message;
2575: END IF;
2576: -- end of debugging section
2577: -- */

Line 2574: inv_pp_debug.send_last_error_message;

2570: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2571: -- the message retrieved here since it is no longer on the stack
2572: inv_pp_debug.set_last_error_message(Sqlerrm);
2573: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2574: inv_pp_debug.send_last_error_message;
2575: END IF;
2576: -- end of debugging section
2577: -- */
2578: rollback to ApplyStrategySP;

Line 2593: IF inv_pp_debug.is_debug_mode THEN

2589: when others then
2590: /*--
2591: -- debugging portion
2592: -- can be commented ut for final code
2593: IF inv_pp_debug.is_debug_mode THEN
2594: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2595: -- the message retrieved here since it is no longer on the stack
2596: inv_pp_debug.set_last_error_message(Sqlerrm);
2597: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2596: inv_pp_debug.set_last_error_message(Sqlerrm);

2592: -- can be commented ut for final code
2593: IF inv_pp_debug.is_debug_mode THEN
2594: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2595: -- the message retrieved here since it is no longer on the stack
2596: inv_pp_debug.set_last_error_message(Sqlerrm);
2597: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2598: inv_pp_debug.send_last_error_message;
2599: END IF;
2600: -- end of debugging section

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

2593: IF inv_pp_debug.is_debug_mode THEN
2594: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2595: -- the message retrieved here since it is no longer on the stack
2596: inv_pp_debug.set_last_error_message(Sqlerrm);
2597: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2598: inv_pp_debug.send_last_error_message;
2599: END IF;
2600: -- end of debugging section
2601: -- */

Line 2598: inv_pp_debug.send_last_error_message;

2594: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2595: -- the message retrieved here since it is no longer on the stack
2596: inv_pp_debug.set_last_error_message(Sqlerrm);
2597: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2598: inv_pp_debug.send_last_error_message;
2599: END IF;
2600: -- end of debugging section
2601: -- */
2602: rollback to ApplyStrategySP;