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_RULE_PVT dependencies on INV_PP_DEBUG

Line 8909: -- inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');

8905: RAISE fnd_api.g_exc_error;
8906: END IF;
8907: END IF;
8908:
8909: -- inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');
8910: --
8911: -- backup qty tree
8912: IF p_type_code = 2 THEN
8913: IF l_debug = 1 THEN

Line 14118: --inv_pp_debug.send_message_to_pipe('finished validations');

14114: END IF;
14115: RAISE fnd_api.g_exc_error;
14116: END IF;
14117: END IF;
14118: --inv_pp_debug.send_message_to_pipe('finished validations');
14119:
14120: --
14121: -- make sure, everything is clean
14122: FreeGlobals;

Line 15282: --inv_pp_debug.send_long_to_pipe(g_base_from_serial);

15278:
15279: --
15280:
15281:
15282: --inv_pp_debug.send_long_to_pipe(g_base_from_serial);
15283:
15284: --build the sql portion of the cursor for lot-controlled items
15285: IF (l_type_code = 2) THEN --pick only
15286:

Line 15289: --inv_pp_debug.send_long_to_pipe(g_base_from_serial);

15285: IF (l_type_code = 2) THEN --pick only
15286:
15287: g_rule_from := g_rule_from || g_line_feed || ' MTL_LOT_NUMBERS mlna , ' || g_line_feed;
15288:
15289: --inv_pp_debug.send_long_to_pipe(g_base_from_serial);
15290:
15291: IF (g_input_where IS NULL AND g_rule_where IS NULL) THEN
15292: g_rule_where := g_rule_where
15293: ||' mlna.ORGANIZATION_ID (+) = base.ORGANIZATION_ID ' || g_line_feed

Line 15305: IF inv_pp_debug.is_debug_mode THEN

15301: ||' and mlna.LOT_NUMBER (+) = base.LOT_NUMBER ' || g_line_feed
15302: ||' and ( mlna.EXPIRATION_DATE is NULL OR mlna.EXPIRATION_DATE > sysdate OR wms_rule_pvt.g_allow_expired_lot_txn = ''Y'' ) ' ;
15303: END IF;
15304:
15305: IF inv_pp_debug.is_debug_mode THEN
15306: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
15307: -- the message retrieved here since it is no longer on the stack
15308: inv_pp_debug.set_last_error_message(SQLERRM);
15309: inv_pp_debug.send_message_to_pipe(g_base_from_serial);

Line 15308: inv_pp_debug.set_last_error_message(SQLERRM);

15304:
15305: IF inv_pp_debug.is_debug_mode THEN
15306: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
15307: -- the message retrieved here since it is no longer on the stack
15308: inv_pp_debug.set_last_error_message(SQLERRM);
15309: inv_pp_debug.send_message_to_pipe(g_base_from_serial);
15310: inv_pp_debug.send_last_error_message;
15311: END IF;
15312:

Line 15309: inv_pp_debug.send_message_to_pipe(g_base_from_serial);

15305: IF inv_pp_debug.is_debug_mode THEN
15306: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
15307: -- the message retrieved here since it is no longer on the stack
15308: inv_pp_debug.set_last_error_message(SQLERRM);
15309: inv_pp_debug.send_message_to_pipe(g_base_from_serial);
15310: inv_pp_debug.send_last_error_message;
15311: END IF;
15312:
15313: --inv_pp_debug.send_long_to_pipe(g_rule_from);

Line 15310: inv_pp_debug.send_last_error_message;

15306: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
15307: -- the message retrieved here since it is no longer on the stack
15308: inv_pp_debug.set_last_error_message(SQLERRM);
15309: inv_pp_debug.send_message_to_pipe(g_base_from_serial);
15310: inv_pp_debug.send_last_error_message;
15311: END IF;
15312:
15313: --inv_pp_debug.send_long_to_pipe(g_rule_from);
15314: --inv_pp_debug.send_long_to_pipe(g_rule_where);

Line 15313: --inv_pp_debug.send_long_to_pipe(g_rule_from);

15309: inv_pp_debug.send_message_to_pipe(g_base_from_serial);
15310: inv_pp_debug.send_last_error_message;
15311: END IF;
15312:
15313: --inv_pp_debug.send_long_to_pipe(g_rule_from);
15314: --inv_pp_debug.send_long_to_pipe(g_rule_where);
15315: --g_rule_from
15316:
15317: g_stmt_serial := 'select '

Line 15314: --inv_pp_debug.send_long_to_pipe(g_rule_where);

15310: inv_pp_debug.send_last_error_message;
15311: END IF;
15312:
15313: --inv_pp_debug.send_long_to_pipe(g_rule_from);
15314: --inv_pp_debug.send_long_to_pipe(g_rule_where);
15315: --g_rule_from
15316:
15317: g_stmt_serial := 'select '
15318: || g_base_select

Line 15369: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);

15365: g_stmt_serial_validate := g_stmt_serial_validate || ' order by ' || g_rule_order_new; -- Added for Bug 13448337
15366: g_stmt_serial_detail := g_stmt_serial_detail || ' order by ' || g_rule_order;
15367: g_stmt_serial_detail_new := g_stmt_serial_detail_new || ' order by ' || g_rule_order;
15368: END IF;
15369: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
15370: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
15371:
15372: ELSE
15373: --if not pick, we don't need these cursors, so we set them to

Line 15370: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);

15366: g_stmt_serial_detail := g_stmt_serial_detail || ' order by ' || g_rule_order;
15367: g_stmt_serial_detail_new := g_stmt_serial_detail_new || ' order by ' || g_rule_order;
15368: END IF;
15369: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
15370: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
15371:
15372: ELSE
15373: --if not pick, we don't need these cursors, so we set them to
15374: -- dummy values. Used only so package will compile.

Line 15405: --inv_pp_debug.send_long_to_pipe(l_pack_sql);

15401:
15402: end '
15403: || l_package_name
15404: || ';';
15405: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15406: --open cursor
15407: --l_cursor := dbms_sql.open_cursor;
15408: --parse cursor
15409: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

Line 15424: --inv_pp_debug.send_long_to_pipe(g_stmt);

15420: END IF;
15421:
15422: --re initialize global variables
15423: initbuildpackage;
15424: --inv_pp_debug.send_long_to_pipe(g_stmt);
15425:
15426: --assemble the dynamic package creation statment
15427: l_pack_body_sql :=
15428: 'CREATE OR REPLACE PACKAGE BODY '

Line 15472: --inv_pp_debug.send_long_to_pipe(l_pack_sql);

15468:
15469: end '
15470: || l_package_name
15471: || ';';
15472: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15473: --open cursor
15474: --l_cursor := dbms_sql.open_cursor;
15475: --parse cursor
15476: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

Line 15489: --inv_pp_debug.send_long_to_pipe(g_stmt);

15485: RAISE fnd_api.g_exc_error;
15486: END IF;
15487:
15488: initbuildpackage;
15489: --inv_pp_debug.send_long_to_pipe(g_stmt);
15490:
15491: --assemble the dynamic package creation statment
15492: l_pack_body_sql :=
15493: 'CREATE OR REPLACE PACKAGE BODY '

Line 15536: --inv_pp_debug.send_long_to_pipe(l_pack_sql);

15532:
15533: end '
15534: || l_package_name
15535: || ';';
15536: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15537: --open cursor
15538: --l_cursor := dbms_sql.open_cursor;
15539: --parse cursor
15540: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

Line 15553: --inv_pp_debug.send_long_to_pipe(g_stmt);

15549: RAISE fnd_api.g_exc_error;
15550: END IF;
15551:
15552: initbuildpackage;
15553: --inv_pp_debug.send_long_to_pipe(g_stmt);
15554:
15555: --assemble the dynamic package creation statment
15556: l_pack_body_sql :=
15557: 'CREATE OR REPLACE PACKAGE BODY '

Line 15603: --inv_pp_debug.send_long_to_pipe(l_pack_sql);

15599:
15600: end '
15601: || l_package_name
15602: || ';';
15603: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15604: --open cursor
15605: --l_cursor := dbms_sql.open_cursor;
15606: --parse cursor
15607: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

Line 15620: --inv_pp_debug.send_long_to_pipe(g_stmt);

15616: RAISE fnd_api.g_exc_error;
15617: END IF;
15618:
15619: initbuildpackage;
15620: --inv_pp_debug.send_long_to_pipe(g_stmt);
15621:
15622: --assemble the dynamic package creation statment
15623: l_pack_body_sql :=
15624: 'CREATE OR REPLACE PACKAGE BODY '

Line 15672: --inv_pp_debug.send_long_to_pipe('g_base_from : ' || g_base_from);

15668: --build the sql portion of the cursor for non-serial-controlled items
15669: log_procedure(l_api_name, '=>', '********************* 200');
15670: g_stmt :=
15671: 'select ' || g_base_select || ' from ' || g_rule_from || g_base_from || ' where ' || g_input_where || g_rule_where;
15672: --inv_pp_debug.send_long_to_pipe('g_base_from : ' || g_base_from);
15673:
15674: log_procedure(l_api_name, '=>', '********************* 199');
15675:
15676: --assemble create package statement

Line 15709: --inv_pp_debug.send_long_to_pipe(l_pack_sql);

15705: end '
15706: || l_package_name
15707: || ';';
15708: log_procedure(l_api_name, '=>', '********************* 198');
15709: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
15710: --open cursor
15711: --l_cursor := dbms_sql.open_cursor;
15712: --parse cursor
15713: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

Line 15726: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);

15722: RAISE fnd_api.g_exc_error;
15723: END IF;
15724:
15725: initbuildpackage;
15726: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
15727: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
15728: --assemble the dynamic package creation statment
15729: log_procedure(l_api_name, '=>', '********************* 197');
15730: l_pack_body_sql :=

Line 15727: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);

15723: END IF;
15724:
15725: initbuildpackage;
15726: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
15727: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
15728: --assemble the dynamic package creation statment
15729: log_procedure(l_api_name, '=>', '********************* 197');
15730: l_pack_body_sql :=
15731: 'CREATE OR REPLACE PACKAGE BODY '

Line 16002: --inv_pp_debug.send_long_to_pipe('g_base_from : ' || g_base_from);

15998: || g_base_group_by
15999: || g_rule_group_by;
16000: END IF;
16001:
16002: --inv_pp_debug.send_long_to_pipe('g_base_from : ' || g_base_from);
16003:
16004: IF g_rule_order IS NOT NULL THEN
16005: g_stmt := g_stmt || ' order by ' || g_rule_order;
16006: END IF;

Line 16064: --inv_pp_debug.send_long_to_pipe(l_pack_sql);

16060:
16061: end '
16062: || l_package_name
16063: || ';';
16064: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
16065: --open cursor
16066: --l_cursor := dbms_sql.open_cursor;
16067: --parse cursor
16068: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

Line 16081: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);

16077: RAISE fnd_api.g_exc_error;
16078: END IF;
16079:
16080: initbuildpackage;
16081: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
16082: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
16083: --assemble the dynamic package creation statment
16084:
16085: l_pack_body_sql :=

Line 16082: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);

16078: END IF;
16079:
16080: initbuildpackage;
16081: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
16082: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
16083: --assemble the dynamic package creation statment
16084:
16085: l_pack_body_sql :=
16086: 'CREATE OR REPLACE PACKAGE BODY '

Line 16300: -- inv_pp_debug.send_long_to_pipe(l_pack_body_sql);

16296: RAISE fnd_api.g_exc_error;
16297: END IF;
16298:
16299: initbuildpackage;
16300: -- inv_pp_debug.send_long_to_pipe(l_pack_body_sql);
16301: /*
16302: --open cursor
16303:
16304: l_cursor := dbms_sql.open_cursor;

Line 16336: IF inv_pp_debug.is_debug_mode THEN

16332: WHEN fnd_api.g_exc_error THEN
16333: --
16334: -- debugging portion
16335: -- can be commented ut for final code
16336: IF inv_pp_debug.is_debug_mode THEN
16337: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16338: -- the message retrieved here since it is no longer on the stack
16339: inv_pp_debug.set_last_error_message(SQLERRM);
16340: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 16339: inv_pp_debug.set_last_error_message(SQLERRM);

16335: -- can be commented ut for final code
16336: IF inv_pp_debug.is_debug_mode THEN
16337: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16338: -- the message retrieved here since it is no longer on the stack
16339: inv_pp_debug.set_last_error_message(SQLERRM);
16340: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16341: inv_pp_debug.send_last_error_message;
16342: END IF;
16343:

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

16336: IF inv_pp_debug.is_debug_mode THEN
16337: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16338: -- the message retrieved here since it is no longer on the stack
16339: inv_pp_debug.set_last_error_message(SQLERRM);
16340: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16341: inv_pp_debug.send_last_error_message;
16342: END IF;
16343:
16344: -- end of debugging section

Line 16341: inv_pp_debug.send_last_error_message;

16337: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16338: -- the message retrieved here since it is no longer on the stack
16339: inv_pp_debug.set_last_error_message(SQLERRM);
16340: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16341: inv_pp_debug.send_last_error_message;
16342: END IF;
16343:
16344: -- end of debugging section
16345: --

Line 16359: IF inv_pp_debug.is_debug_mode THEN

16355: WHEN fnd_api.g_exc_unexpected_error THEN
16356: --
16357: -- debugging portion
16358: -- can be commented ut for final code
16359: IF inv_pp_debug.is_debug_mode THEN
16360: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16361: -- the message retrieved here since it is no longer on the stack
16362: inv_pp_debug.set_last_error_message(SQLERRM);
16363: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 16362: inv_pp_debug.set_last_error_message(SQLERRM);

16358: -- can be commented ut for final code
16359: IF inv_pp_debug.is_debug_mode THEN
16360: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16361: -- the message retrieved here since it is no longer on the stack
16362: inv_pp_debug.set_last_error_message(SQLERRM);
16363: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16364: inv_pp_debug.send_last_error_message;
16365: END IF;
16366:

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

16359: IF inv_pp_debug.is_debug_mode THEN
16360: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16361: -- the message retrieved here since it is no longer on the stack
16362: inv_pp_debug.set_last_error_message(SQLERRM);
16363: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16364: inv_pp_debug.send_last_error_message;
16365: END IF;
16366:
16367: -- end of debugging section

Line 16364: inv_pp_debug.send_last_error_message;

16360: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16361: -- the message retrieved here since it is no longer on the stack
16362: inv_pp_debug.set_last_error_message(SQLERRM);
16363: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16364: inv_pp_debug.send_last_error_message;
16365: END IF;
16366:
16367: -- end of debugging section
16368: --

Line 16384: IF inv_pp_debug.is_debug_mode THEN

16380: WHEN OTHERS THEN
16381: --
16382: -- debugging portion
16383: -- can be commented ut for final code
16384: IF inv_pp_debug.is_debug_mode THEN
16385: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16386: -- the message retrieved here since it is no longer on the stack
16387: inv_pp_debug.set_last_error_message(SQLERRM);
16388: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 16387: inv_pp_debug.set_last_error_message(SQLERRM);

16383: -- can be commented ut for final code
16384: IF inv_pp_debug.is_debug_mode THEN
16385: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16386: -- the message retrieved here since it is no longer on the stack
16387: inv_pp_debug.set_last_error_message(SQLERRM);
16388: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16389: inv_pp_debug.send_last_error_message;
16390: END IF;
16391:

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

16384: IF inv_pp_debug.is_debug_mode THEN
16385: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16386: -- the message retrieved here since it is no longer on the stack
16387: inv_pp_debug.set_last_error_message(SQLERRM);
16388: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16389: inv_pp_debug.send_last_error_message;
16390: END IF;
16391:
16392: -- end of debugging section

Line 16389: inv_pp_debug.send_last_error_message;

16385: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16386: -- the message retrieved here since it is no longer on the stack
16387: inv_pp_debug.set_last_error_message(SQLERRM);
16388: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16389: inv_pp_debug.send_last_error_message;
16390: END IF;
16391:
16392: -- end of debugging section
16393: --

Line 18566: IF inv_pp_debug.is_debug_mode THEN

18562: log_event(l_api_name, 'Check if Pick Release', 'False');
18563: End if;
18564: l_consider_staging_capacity := TRUE;
18565: end if;
18566: IF inv_pp_debug.is_debug_mode THEN
18567: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.'
18568: || l_api_name);
18569: END IF;
18570: IF l_debug = 1 THEN

Line 18567: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.'

18563: End if;
18564: l_consider_staging_capacity := TRUE;
18565: end if;
18566: IF inv_pp_debug.is_debug_mode THEN
18567: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.'
18568: || l_api_name);
18569: END IF;
18570: IF l_debug = 1 THEN
18571: log_procedure(l_api_name, 'start', 'Start Apply');

Line 18741: --inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');

18737: RAISE fnd_api.g_exc_error;
18738: END IF;
18739: END IF;
18740:
18741: --inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');
18742:
18743: --
18744: -- backup qty tree
18745: IF p_type_code = 2 THEN

Line 19003: --inv_pp_debug.send_message_to_pipe('Calling pick_open_curs wms_rule_pick_pkg1.execute');

18999: -- open_curs opens the appropriate cursor for the rule;
19000: -- this call has to be dynamic because of the name of the rule package
19001: IF p_type_code = 2 THEN
19002: --pick_open_curs
19003: --inv_pp_debug.send_message_to_pipe('Calling **pick_open_curs ** wms_rule_pick_pkg1.execute');
19004: IF (l_revision IS NULL) THEN
19005: --gmi_reservation_util.println('l_revision is null');
19006: l_revision := '-99';
19007: END IF;

Line 19110: IF inv_pp_debug.is_debug_mode THEN

19106: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
19107:
19108: -- debugging portion
19109: -- can be commented ut for final code
19110: IF inv_pp_debug.is_debug_mode THEN
19111: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19112: -- the message retrieved here since it is no longer on the stack
19113: inv_pp_debug.set_last_error_message(SQLERRM);
19114: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 19113: inv_pp_debug.set_last_error_message(SQLERRM);

19109: -- can be commented ut for final code
19110: IF inv_pp_debug.is_debug_mode THEN
19111: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19112: -- the message retrieved here since it is no longer on the stack
19113: inv_pp_debug.set_last_error_message(SQLERRM);
19114: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19115: inv_pp_debug.send_last_error_message;
19116: END IF;
19117: -- end of debugging section

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

19110: IF inv_pp_debug.is_debug_mode THEN
19111: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19112: -- the message retrieved here since it is no longer on the stack
19113: inv_pp_debug.set_last_error_message(SQLERRM);
19114: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19115: inv_pp_debug.send_last_error_message;
19116: END IF;
19117: -- end of debugging section
19118: END get_available_inventory;

Line 19115: inv_pp_debug.send_last_error_message;

19111: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19112: -- the message retrieved here since it is no longer on the stack
19113: inv_pp_debug.set_last_error_message(SQLERRM);
19114: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19115: inv_pp_debug.send_last_error_message;
19116: END IF;
19117: -- end of debugging section
19118: END get_available_inventory;
19119:

Line 19148: IF inv_pp_debug.is_debug_mode THEN

19144:
19145: --
19146: -- debugging portion
19147: -- can be commented ut for final code
19148: IF inv_pp_debug.is_debug_mode THEN
19149: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.' || l_api_name);
19150: END IF;
19151:
19152: log_procedure(l_api_name, 'start', 'Start FetchCursorrows');

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

19145: --
19146: -- debugging portion
19147: -- can be commented ut for final code
19148: IF inv_pp_debug.is_debug_mode THEN
19149: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.' || l_api_name);
19150: END IF;
19151:
19152: log_procedure(l_api_name, 'start', 'Start FetchCursorrows');
19153: -- end of debugging section

Line 19192: IF inv_pp_debug.is_debug_mode THEN

19188: , x_return_status
19189: );
19190: END IF;
19191:
19192: IF inv_pp_debug.is_debug_mode THEN
19193: inv_pp_debug.send_message_to_pipe('exit '|| g_pkg_name || '.' || l_api_name);
19194: END IF;
19195: -- end of debugging section
19196: log_procedure(l_api_name, 'end', 'End FetchCursorrows');

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

19189: );
19190: END IF;
19191:
19192: IF inv_pp_debug.is_debug_mode THEN
19193: inv_pp_debug.send_message_to_pipe('exit '|| g_pkg_name || '.' || l_api_name);
19194: END IF;
19195: -- end of debugging section
19196: log_procedure(l_api_name, 'end', 'End FetchCursorrows');
19197: --

Line 19221: IF inv_pp_debug.is_debug_mode THEN

19217: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
19218:
19219: -- debugging portion
19220: -- can be commented ut for final code
19221: IF inv_pp_debug.is_debug_mode THEN
19222: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19223: -- the message retrieved here since it is no longer on the stack
19224: inv_pp_debug.set_last_error_message(SQLERRM);
19225: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 19224: inv_pp_debug.set_last_error_message(SQLERRM);

19220: -- can be commented ut for final code
19221: IF inv_pp_debug.is_debug_mode THEN
19222: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19223: -- the message retrieved here since it is no longer on the stack
19224: inv_pp_debug.set_last_error_message(SQLERRM);
19225: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19226: inv_pp_debug.send_last_error_message;
19227: END IF;
19228: -- end of debugging section

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

19221: IF inv_pp_debug.is_debug_mode THEN
19222: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19223: -- the message retrieved here since it is no longer on the stack
19224: inv_pp_debug.set_last_error_message(SQLERRM);
19225: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19226: inv_pp_debug.send_last_error_message;
19227: END IF;
19228: -- end of debugging section
19229: END FetchCursorRows;

Line 19226: inv_pp_debug.send_last_error_message;

19222: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
19223: -- the message retrieved here since it is no longer on the stack
19224: inv_pp_debug.set_last_error_message(SQLERRM);
19225: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
19226: inv_pp_debug.send_last_error_message;
19227: END IF;
19228: -- end of debugging section
19229: END FetchCursorRows;
19230: -- end LG convergence