DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on INV_PP_DEBUG

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

6964: RAISE fnd_api.g_exc_error;
6965: END IF;
6966: END IF;
6967:
6968: --inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');
6969: --
6970: -- backup qty tree
6971: IF p_type_code = 2 THEN
6972: IF l_debug = 1 THEN

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

11530: END IF;
11531: RAISE fnd_api.g_exc_error;
11532: END IF;
11533: END IF;
11534: --inv_pp_debug.send_message_to_pipe('finished validations');
11535:
11536: --
11537: -- make sure, everything is clean
11538: FreeGlobals;

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

12666:
12667: --
12668:
12669:
12670: --inv_pp_debug.send_long_to_pipe(g_base_from_serial);
12671:
12672: --build the sql portion of the cursor for lot-controlled items
12673: IF (l_type_code = 2) THEN --pick only
12674: g_stmt_serial := 'select '

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

12722: g_stmt_serial_validate := g_stmt_serial_validate || ' order by ' || g_rule_order;
12723: g_stmt_serial_detail := g_stmt_serial_detail || ' order by ' || g_rule_order;
12724: g_stmt_serial_detail_new := g_stmt_serial_detail_new || ' order by ' || g_rule_order;
12725: END IF;
12726: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
12727: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
12728:
12729: ELSE
12730: --if not pick, we don't need these cursors, so we set them to

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

12723: g_stmt_serial_detail := g_stmt_serial_detail || ' order by ' || g_rule_order;
12724: g_stmt_serial_detail_new := g_stmt_serial_detail_new || ' order by ' || g_rule_order;
12725: END IF;
12726: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
12727: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
12728:
12729: ELSE
12730: --if not pick, we don't need these cursors, so we set them to
12731: -- dummy values. Used only so package will compile.

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

12758:
12759: end '
12760: || l_package_name
12761: || ';';
12762: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12763: --open cursor
12764: --l_cursor := dbms_sql.open_cursor;
12765: --parse cursor
12766: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

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

12777: END IF;
12778:
12779: --re initialize global variables
12780: initbuildpackage;
12781: --inv_pp_debug.send_long_to_pipe(g_stmt);
12782:
12783: --assemble the dynamic package creation statment
12784: l_pack_body_sql :=
12785: 'CREATE OR REPLACE PACKAGE BODY '

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

12825:
12826: end '
12827: || l_package_name
12828: || ';';
12829: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12830: --open cursor
12831: --l_cursor := dbms_sql.open_cursor;
12832: --parse cursor
12833: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

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

12842: RAISE fnd_api.g_exc_error;
12843: END IF;
12844:
12845: initbuildpackage;
12846: --inv_pp_debug.send_long_to_pipe(g_stmt);
12847:
12848: --assemble the dynamic package creation statment
12849: l_pack_body_sql :=
12850: 'CREATE OR REPLACE PACKAGE BODY '

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

12889:
12890: end '
12891: || l_package_name
12892: || ';';
12893: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12894: --open cursor
12895: --l_cursor := dbms_sql.open_cursor;
12896: --parse cursor
12897: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

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

12906: RAISE fnd_api.g_exc_error;
12907: END IF;
12908:
12909: initbuildpackage;
12910: --inv_pp_debug.send_long_to_pipe(g_stmt);
12911:
12912: --assemble the dynamic package creation statment
12913: l_pack_body_sql :=
12914: 'CREATE OR REPLACE PACKAGE BODY '

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

12956:
12957: end '
12958: || l_package_name
12959: || ';';
12960: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
12961: --open cursor
12962: --l_cursor := dbms_sql.open_cursor;
12963: --parse cursor
12964: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

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

12973: RAISE fnd_api.g_exc_error;
12974: END IF;
12975:
12976: initbuildpackage;
12977: --inv_pp_debug.send_long_to_pipe(g_stmt);
12978:
12979: --assemble the dynamic package creation statment
12980: l_pack_body_sql :=
12981: 'CREATE OR REPLACE PACKAGE BODY '

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

13025: --build the sql portion of the cursor for non-serial-controlled items
13026: log_procedure(l_api_name, '=>', '********************* 200');
13027: g_stmt :=
13028: 'select ' || g_base_select || ' from ' || g_rule_from || g_base_from || ' where ' || g_input_where || g_rule_where;
13029: --inv_pp_debug.send_long_to_pipe('g_base_from : ' || g_base_from);
13030:
13031: log_procedure(l_api_name, '=>', '********************* 199');
13032:
13033: --assemble create package statement

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

13062: end '
13063: || l_package_name
13064: || ';';
13065: log_procedure(l_api_name, '=>', '********************* 198');
13066: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
13067: --open cursor
13068: --l_cursor := dbms_sql.open_cursor;
13069: --parse cursor
13070: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

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

13079: RAISE fnd_api.g_exc_error;
13080: END IF;
13081:
13082: initbuildpackage;
13083: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
13084: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
13085: --assemble the dynamic package creation statment
13086: log_procedure(l_api_name, '=>', '********************* 197');
13087: l_pack_body_sql :=

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

13080: END IF;
13081:
13082: initbuildpackage;
13083: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
13084: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
13085: --assemble the dynamic package creation statment
13086: log_procedure(l_api_name, '=>', '********************* 197');
13087: l_pack_body_sql :=
13088: 'CREATE OR REPLACE PACKAGE BODY '

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

13355: || g_base_group_by
13356: || g_rule_group_by;
13357: END IF;
13358:
13359: --inv_pp_debug.send_long_to_pipe('g_base_from : ' || g_base_from);
13360:
13361: IF g_rule_order IS NOT NULL THEN
13362: g_stmt := g_stmt || ' order by ' || g_rule_order;
13363: END IF;

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

13417:
13418: end '
13419: || l_package_name
13420: || ';';
13421: --inv_pp_debug.send_long_to_pipe(l_pack_sql);
13422: --open cursor
13423: --l_cursor := dbms_sql.open_cursor;
13424: --parse cursor
13425: --dbms_sql.parse(l_cursor, l_pack_sql, dbms_sql.native);

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

13434: RAISE fnd_api.g_exc_error;
13435: END IF;
13436:
13437: initbuildpackage;
13438: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
13439: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
13440: --assemble the dynamic package creation statment
13441:
13442: l_pack_body_sql :=

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

13435: END IF;
13436:
13437: initbuildpackage;
13438: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial_detail);
13439: -- inv_pp_debug.send_long_to_pipe(g_stmt_serial);
13440: --assemble the dynamic package creation statment
13441:
13442: l_pack_body_sql :=
13443: 'CREATE OR REPLACE PACKAGE BODY '

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

13632: RAISE fnd_api.g_exc_error;
13633: END IF;
13634:
13635: initbuildpackage;
13636: -- inv_pp_debug.send_long_to_pipe(l_pack_body_sql);
13637: /*
13638: --open cursor
13639:
13640: l_cursor := dbms_sql.open_cursor;

Line 13672: IF inv_pp_debug.is_debug_mode THEN

13668: WHEN fnd_api.g_exc_error THEN
13669: --
13670: -- debugging portion
13671: -- can be commented ut for final code
13672: IF inv_pp_debug.is_debug_mode THEN
13673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13674: -- the message retrieved here since it is no longer on the stack
13675: inv_pp_debug.set_last_error_message(SQLERRM);
13676: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 13675: inv_pp_debug.set_last_error_message(SQLERRM);

13671: -- can be commented ut for final code
13672: IF inv_pp_debug.is_debug_mode THEN
13673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13674: -- the message retrieved here since it is no longer on the stack
13675: inv_pp_debug.set_last_error_message(SQLERRM);
13676: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13677: inv_pp_debug.send_last_error_message;
13678: END IF;
13679:

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

13672: IF inv_pp_debug.is_debug_mode THEN
13673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13674: -- the message retrieved here since it is no longer on the stack
13675: inv_pp_debug.set_last_error_message(SQLERRM);
13676: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13677: inv_pp_debug.send_last_error_message;
13678: END IF;
13679:
13680: -- end of debugging section

Line 13677: inv_pp_debug.send_last_error_message;

13673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13674: -- the message retrieved here since it is no longer on the stack
13675: inv_pp_debug.set_last_error_message(SQLERRM);
13676: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13677: inv_pp_debug.send_last_error_message;
13678: END IF;
13679:
13680: -- end of debugging section
13681: --

Line 13695: IF inv_pp_debug.is_debug_mode THEN

13691: WHEN fnd_api.g_exc_unexpected_error THEN
13692: --
13693: -- debugging portion
13694: -- can be commented ut for final code
13695: IF inv_pp_debug.is_debug_mode THEN
13696: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13697: -- the message retrieved here since it is no longer on the stack
13698: inv_pp_debug.set_last_error_message(SQLERRM);
13699: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 13698: inv_pp_debug.set_last_error_message(SQLERRM);

13694: -- can be commented ut for final code
13695: IF inv_pp_debug.is_debug_mode THEN
13696: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13697: -- the message retrieved here since it is no longer on the stack
13698: inv_pp_debug.set_last_error_message(SQLERRM);
13699: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13700: inv_pp_debug.send_last_error_message;
13701: END IF;
13702:

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

13695: IF inv_pp_debug.is_debug_mode THEN
13696: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13697: -- the message retrieved here since it is no longer on the stack
13698: inv_pp_debug.set_last_error_message(SQLERRM);
13699: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13700: inv_pp_debug.send_last_error_message;
13701: END IF;
13702:
13703: -- end of debugging section

Line 13700: inv_pp_debug.send_last_error_message;

13696: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13697: -- the message retrieved here since it is no longer on the stack
13698: inv_pp_debug.set_last_error_message(SQLERRM);
13699: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13700: inv_pp_debug.send_last_error_message;
13701: END IF;
13702:
13703: -- end of debugging section
13704: --

Line 13720: IF inv_pp_debug.is_debug_mode THEN

13716: WHEN OTHERS THEN
13717: --
13718: -- debugging portion
13719: -- can be commented ut for final code
13720: IF inv_pp_debug.is_debug_mode THEN
13721: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13722: -- the message retrieved here since it is no longer on the stack
13723: inv_pp_debug.set_last_error_message(SQLERRM);
13724: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 13723: inv_pp_debug.set_last_error_message(SQLERRM);

13719: -- can be commented ut for final code
13720: IF inv_pp_debug.is_debug_mode THEN
13721: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13722: -- the message retrieved here since it is no longer on the stack
13723: inv_pp_debug.set_last_error_message(SQLERRM);
13724: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13725: inv_pp_debug.send_last_error_message;
13726: END IF;
13727:

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

13720: IF inv_pp_debug.is_debug_mode THEN
13721: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13722: -- the message retrieved here since it is no longer on the stack
13723: inv_pp_debug.set_last_error_message(SQLERRM);
13724: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13725: inv_pp_debug.send_last_error_message;
13726: END IF;
13727:
13728: -- end of debugging section

Line 13725: inv_pp_debug.send_last_error_message;

13721: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
13722: -- the message retrieved here since it is no longer on the stack
13723: inv_pp_debug.set_last_error_message(SQLERRM);
13724: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
13725: inv_pp_debug.send_last_error_message;
13726: END IF;
13727:
13728: -- end of debugging section
13729: --

Line 15926: IF inv_pp_debug.is_debug_mode THEN

15922: log_event(l_api_name, 'Check if Pick Release', 'False');
15923: End if;
15924: l_consider_staging_capacity := TRUE;
15925: end if;
15926: IF inv_pp_debug.is_debug_mode THEN
15927: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.'
15928: || l_api_name);
15929: END IF;
15930: IF l_debug = 1 THEN

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

15923: End if;
15924: l_consider_staging_capacity := TRUE;
15925: end if;
15926: IF inv_pp_debug.is_debug_mode THEN
15927: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.'
15928: || l_api_name);
15929: END IF;
15930: IF l_debug = 1 THEN
15931: log_procedure(l_api_name, 'start', 'Start Apply');

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

16096: RAISE fnd_api.g_exc_error;
16097: END IF;
16098: END IF;
16099:
16100: --inv_pp_debug.send_message_to_pipe('finished validations and qty tree init');
16101:
16102: --
16103: -- backup qty tree
16104: IF p_type_code = 2 THEN

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

16357: -- open_curs opens the appropriate cursor for the rule;
16358: -- this call has to be dynamic because of the name of the rule package
16359: IF p_type_code = 2 THEN
16360: --pick_open_curs
16361: --inv_pp_debug.send_message_to_pipe('Calling **pick_open_curs ** wms_rule_pick_pkg1.execute');
16362: IF (l_revision IS NULL) THEN
16363: --gmi_reservation_util.println('l_revision is null');
16364: l_revision := '-99';
16365: END IF;

Line 16468: IF inv_pp_debug.is_debug_mode THEN

16464: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
16465:
16466: -- debugging portion
16467: -- can be commented ut for final code
16468: IF inv_pp_debug.is_debug_mode THEN
16469: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16470: -- the message retrieved here since it is no longer on the stack
16471: inv_pp_debug.set_last_error_message(SQLERRM);
16472: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 16471: inv_pp_debug.set_last_error_message(SQLERRM);

16467: -- can be commented ut for final code
16468: IF inv_pp_debug.is_debug_mode THEN
16469: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16470: -- the message retrieved here since it is no longer on the stack
16471: inv_pp_debug.set_last_error_message(SQLERRM);
16472: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16473: inv_pp_debug.send_last_error_message;
16474: END IF;
16475: -- end of debugging section

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

16468: IF inv_pp_debug.is_debug_mode THEN
16469: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16470: -- the message retrieved here since it is no longer on the stack
16471: inv_pp_debug.set_last_error_message(SQLERRM);
16472: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16473: inv_pp_debug.send_last_error_message;
16474: END IF;
16475: -- end of debugging section
16476: END get_available_inventory;

Line 16473: inv_pp_debug.send_last_error_message;

16469: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16470: -- the message retrieved here since it is no longer on the stack
16471: inv_pp_debug.set_last_error_message(SQLERRM);
16472: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16473: inv_pp_debug.send_last_error_message;
16474: END IF;
16475: -- end of debugging section
16476: END get_available_inventory;
16477:

Line 16506: IF inv_pp_debug.is_debug_mode THEN

16502:
16503: --
16504: -- debugging portion
16505: -- can be commented ut for final code
16506: IF inv_pp_debug.is_debug_mode THEN
16507: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.' || l_api_name);
16508: END IF;
16509:
16510: log_procedure(l_api_name, 'start', 'Start FetchCursorrows');

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

16503: --
16504: -- debugging portion
16505: -- can be commented ut for final code
16506: IF inv_pp_debug.is_debug_mode THEN
16507: inv_pp_debug.send_message_to_pipe('enter '|| g_pkg_name || '.' || l_api_name);
16508: END IF;
16509:
16510: log_procedure(l_api_name, 'start', 'Start FetchCursorrows');
16511: -- end of debugging section

Line 16550: IF inv_pp_debug.is_debug_mode THEN

16546: , x_return_status
16547: );
16548: END IF;
16549:
16550: IF inv_pp_debug.is_debug_mode THEN
16551: inv_pp_debug.send_message_to_pipe('exit '|| g_pkg_name || '.' || l_api_name);
16552: END IF;
16553: -- end of debugging section
16554: log_procedure(l_api_name, 'end', 'End FetchCursorrows');

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

16547: );
16548: END IF;
16549:
16550: IF inv_pp_debug.is_debug_mode THEN
16551: inv_pp_debug.send_message_to_pipe('exit '|| g_pkg_name || '.' || l_api_name);
16552: END IF;
16553: -- end of debugging section
16554: log_procedure(l_api_name, 'end', 'End FetchCursorrows');
16555: --

Line 16579: IF inv_pp_debug.is_debug_mode THEN

16575: log_error(l_api_name, 'other_error', 'Other error - ' || x_msg_data);
16576:
16577: -- debugging portion
16578: -- can be commented ut for final code
16579: IF inv_pp_debug.is_debug_mode THEN
16580: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16581: -- the message retrieved here since it is no longer on the stack
16582: inv_pp_debug.set_last_error_message(SQLERRM);
16583: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);

Line 16582: inv_pp_debug.set_last_error_message(SQLERRM);

16578: -- can be commented ut for final code
16579: IF inv_pp_debug.is_debug_mode THEN
16580: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16581: -- the message retrieved here since it is no longer on the stack
16582: inv_pp_debug.set_last_error_message(SQLERRM);
16583: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16584: inv_pp_debug.send_last_error_message;
16585: END IF;
16586: -- end of debugging section

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

16579: IF inv_pp_debug.is_debug_mode THEN
16580: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16581: -- the message retrieved here since it is no longer on the stack
16582: inv_pp_debug.set_last_error_message(SQLERRM);
16583: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16584: inv_pp_debug.send_last_error_message;
16585: END IF;
16586: -- end of debugging section
16587: END FetchCursorRows;

Line 16584: inv_pp_debug.send_last_error_message;

16580: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
16581: -- the message retrieved here since it is no longer on the stack
16582: inv_pp_debug.set_last_error_message(SQLERRM);
16583: inv_pp_debug.send_message_to_pipe('exception in '|| l_api_name);
16584: inv_pp_debug.send_last_error_message;
16585: END IF;
16586: -- end of debugging section
16587: END FetchCursorRows;
16588: -- end LG convergence