[Home] [Help]
3210: v_left_tr_quant NUMBER;
3211: v_sec_left_tr_quant NUMBER; --invconv kkillams
3212: v_sublvlctrl VARCHAR2(1) := '2';
3213: --Bug 2720653 fix
3214: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
3215: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3216: l_msg_count NUMBER;
3217: l_msg_data VARCHAR2(400);
3218: l_progress VARCHAR2(10);
4856: (lpns_generated_tb.count > 0) THEN
4857:
4858: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4859: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4860: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4861:
4862: l_return_status := fnd_api.g_ret_sts_success;
4863:
4864: inv_label.print_label
4860: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4861:
4862: l_return_status := fnd_api.g_ret_sts_success;
4863:
4864: inv_label.print_label
4865: (x_return_status => l_return_status
4866: , x_msg_count => l_msg_count
4867: , x_msg_data => l_msg_data
4868: , x_label_status => l_label_status
4870: , p_print_mode => 1
4871: , p_business_flow_code => 22
4872: , p_transaction_id => lpns_generated_tb
4873: );
4874: if (g_trace_on = 1) then log_event('wms_cartnzn_pub after inv_label.print_label '); END IF;
4875:
4876: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4877: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4878: FND_MSG_PUB.ADD;
4882: --x_msg_data := l_msg_data;
4883: --x_msg_count := l_msg_count;
4884: --END IF;
4885:
4886: 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;
4887: END IF;
4888: END IF; -- end packaging_mode in 1
4889:
4890: ELSE
5943: v_left_tr_quant NUMBER;
5944: v_sec_left_tr_quant NUMBER;
5945: v_sublvlctrl VARCHAR2(1) := '2';
5946: --Bug 2720653 fix
5947: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
5948: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5949: l_msg_count NUMBER;
5950: l_msg_data VARCHAR2(400);
5951: l_progress VARCHAR2(10);
7197: IF (lpns_generated_tb.COUNT > 0) THEN
7198:
7199: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7200: IF (g_trace_on = 1) THEN
7201: log_event('wms_cartnzn_pub before inv_label.print_label ');
7202: END IF;
7203: l_return_status := fnd_api.g_ret_sts_success;
7204:
7205: inv_label.print_label
7201: log_event('wms_cartnzn_pub before inv_label.print_label ');
7202: END IF;
7203: l_return_status := fnd_api.g_ret_sts_success;
7204:
7205: inv_label.print_label
7206: (
7207: x_return_status => l_return_status
7208: , x_msg_count => l_msg_count
7209: , x_msg_data => l_msg_data
7214: , p_transaction_id => lpns_generated_tb
7215: );
7216:
7217: IF (g_trace_on = 1) THEN
7218: log_event('wms_cartnzn_pub after inv_label.print_label ');
7219: END IF;
7220:
7221: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7222: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7221: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7222: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7223: FND_MSG_PUB.ADD;
7224: IF (g_trace_on = 1) THEN
7225: log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'));
7226: END IF;
7227: END IF;
7228: END IF; -- end packaging_mode in 1
7229: ELSE
7278: v_sec_left_tr_quant NUMBER;
7279: v_sublvlctrl VARCHAR2(1) := g_sublvlctrl; --Bug#7168367.Get form global variable.
7280: l_header_id NUMBER := NULL;
7281: --Bug 2720653 fix
7282: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
7283: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7284: l_msg_count NUMBER;
7285: l_msg_data VARCHAR2(400);
7286: l_progress VARCHAR2(10);