[Home] [Help]
3230: v_left_tr_quant NUMBER;
3231: v_sec_left_tr_quant NUMBER; --invconv kkillams
3232: v_sublvlctrl VARCHAR2(1) := '2';
3233: --Bug 2720653 fix
3234: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
3235: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3236: l_msg_count NUMBER;
3237: l_msg_data VARCHAR2(400);
3238: l_progress VARCHAR2(10);
4863: (lpns_generated_tb.count > 0) THEN
4864:
4865: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4866: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4867: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4868:
4869: l_return_status := fnd_api.g_ret_sts_success;
4870:
4871: inv_label.print_label
4867: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4868:
4869: l_return_status := fnd_api.g_ret_sts_success;
4870:
4871: inv_label.print_label
4872: (x_return_status => l_return_status
4873: , x_msg_count => l_msg_count
4874: , x_msg_data => l_msg_data
4875: , x_label_status => l_label_status
4877: , p_print_mode => 1
4878: , p_business_flow_code => 22
4879: , p_transaction_id => lpns_generated_tb
4880: );
4881: if (g_trace_on = 1) then log_event('wms_cartnzn_pub after inv_label.print_label '); END IF;
4882:
4883: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4884: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4885: FND_MSG_PUB.ADD;
4889: --x_msg_data := l_msg_data;
4890: --x_msg_count := l_msg_count;
4891: --END IF;
4892:
4893: if (g_trace_on = 1) then log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS')); END IF;
4894: END IF;
4895: END IF; -- end packaging_mode in 1
4896:
4897: ELSE
5904: v_left_tr_quant NUMBER;
5905: v_sec_left_tr_quant NUMBER;
5906: v_sublvlctrl VARCHAR2(1) := '2';
5907: --Bug 2720653 fix
5908: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
5909: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5910: l_msg_count NUMBER;
5911: l_msg_data VARCHAR2(400);
5912: l_progress VARCHAR2(10);
7117: IF (lpns_generated_tb.COUNT > 0) THEN
7118:
7119: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7120: IF (g_trace_on = 1) THEN
7121: log_event('wms_cartnzn_pub before inv_label.print_label ');
7122: END IF;
7123: l_return_status := fnd_api.g_ret_sts_success;
7124:
7125: inv_label.print_label
7121: log_event('wms_cartnzn_pub before inv_label.print_label ');
7122: END IF;
7123: l_return_status := fnd_api.g_ret_sts_success;
7124:
7125: inv_label.print_label
7126: (
7127: x_return_status => l_return_status
7128: , x_msg_count => l_msg_count
7129: , x_msg_data => l_msg_data
7134: , p_transaction_id => lpns_generated_tb
7135: );
7136:
7137: IF (g_trace_on = 1) THEN
7138: log_event('wms_cartnzn_pub after inv_label.print_label ');
7139: END IF;
7140:
7141: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7142: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7141: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7142: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7143: FND_MSG_PUB.ADD;
7144: IF (g_trace_on = 1) THEN
7145: log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'));
7146: END IF;
7147: END IF;
7148: END IF; -- end packaging_mode in 1
7149: ELSE
7198: v_sec_left_tr_quant NUMBER;
7199: v_sublvlctrl VARCHAR2(1) := g_sublvlctrl; --Bug#7168367.Get form global variable.
7200: l_header_id NUMBER := NULL;
7201: --Bug 2720653 fix
7202: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
7203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7204: l_msg_count NUMBER;
7205: l_msg_data VARCHAR2(400);
7206: l_progress VARCHAR2(10);