6167: END IF;
6168:
6169: IF SQLCODE IS NOT NULL THEN
6170: l_progress := 100;
6171: inv_mobile_helper_functions.sql_error('validate_nested_lpns', l_progress, SQLCODE);
6172: END IF;
6173: END check_lpn_validity_wrapper;
6174:
6175:
6343: -- Get rid of the folloiwng, as it appends a junk message to the
6344: -- error message stack
6345: -- IF SQLCODE IS NOT NULL AND l_no_lines <> 1 THEN
6346: -- l_progress := 100;
6347: -- inv_mobile_helper_functions.sql_error('suggestions_pub_wrapper', l_progress, SQLCODE);
6348: -- END IF;
6349: END suggestions_pub_wrapper;
6350:
6351: /**
6470: debug(SQLCODE, 1);
6471:
6472: IF SQLCODE IS NOT NULL THEN
6473: l_progress := 100;
6474: inv_mobile_helper_functions.sql_error('Pack Unpack Lpn', l_progress, SQLCODE);
6475: END IF;
6476: END;
6477:
6478:
7112: -- error message stack
7113: -- IF SQLCODE IS NOT NULL THEN
7114: -- l_progress := 100;
7115: -- debug('Exception in load_lpn : ' || SQLCODE);
7116: -- inv_mobile_helper_functions.sql_error('load_lpn', l_progress, SQLCODE);
7117: -- END IF;
7118: END;
7119:
7120:
7731: END IF;
7732:
7733: IF SQLCODE IS NOT NULL THEN
7734: l_progress := 100;
7735: inv_mobile_helper_functions.sql_error('pre_process_lpn', l_progress, SQLCODE);
7736: END IF;
7737:
7738: END pre_process_lpn;
7739:
7861: END IF;
7862:
7863: IF SQLCODE IS NOT NULL THEN
7864: l_progress := 100;
7865: inv_mobile_helper_functions.sql_error('post_process_lpn', l_progress, SQLCODE);
7866: END IF;
7867:
7868: END post_process_lpn;
7869:
11282:
11283: --Get message count and data
11284: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
11285: IF SQLCODE IS NOT NULL THEN
11286: inv_mobile_helper_functions.sql_error('wms_putaway_utils_pvt.complete_putaway_wrapper',l_progress, SQLCODE);
11287: END IF;
11288:
11289: END complete_putaway_wrapper;
11290:
12891: END IF;
12892:
12893: IF SQLCODE IS NOT NULL THEN
12894: l_progress := 220;
12895: inv_mobile_helper_functions.sql_error('Cleanup_LPN_Crossdock_Wrapper', l_progress, SQLCODE);
12896: END IF;
12897: END Cleanup_LPN_Crossdock_Wrapper;
12898:
12899: END WMS_PUTAWAY_UTILS; --End of Package