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.INV_LABEL_PVT4 dependencies on INV_LABEL

Line 1: PACKAGE BODY INV_LABEL_PVT4 AS

1: PACKAGE BODY INV_LABEL_PVT4 AS
2: /* $Header: INVLAP4B.pls 120.58.12020000.10 2013/03/26 10:06:11 blavu ship $ */
3:
4: LABEL_B CONSTANT VARCHAR2(50) := ' 5: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);

Line 9: l_debug number := inv_label.l_debug;--Conf Label ER

5: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
6: VARIABLE_B CONSTANT VARCHAR2(50) := '

Line 3414: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3410: END LOOP;
3411:
3412: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3413: x_return_status := FND_API.G_RET_STS_SUCCESS;
3414: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3415: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3416: fnd_msg_pub.ADD;
3417: -- Fix for bug: 4179593 Start
3418: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

Line 3435: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3431: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 3');
3432: trace('Custom Labels Trace [INVLAP4B.pls]: WARNING: No row returned by the Custom SQL query');
3433: END IF;
3434: x_return_status := FND_API.G_RET_STS_SUCCESS;
3435: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3436: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3437: fnd_msg_pub.ADD;
3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/

Line 3503: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;

3499: END IF;
3500: ------------------------End of this changes for Custom Labels project code--------------------
3501: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
3502: l_content_item_data := l_content_item_data || VARIABLE_B ||
3503: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
3504: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
3505: l_content_item_data := l_content_item_data || VARIABLE_B ||
3506: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
3507: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN

Line 3506: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;

3502: l_content_item_data := l_content_item_data || VARIABLE_B ||
3503: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
3504: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
3505: l_content_item_data := l_content_item_data || VARIABLE_B ||
3506: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
3507: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
3508: l_content_item_data := l_content_item_data || VARIABLE_B ||
3509: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
3510: ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn' THEN

Line 3509: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;

3505: l_content_item_data := l_content_item_data || VARIABLE_B ||
3506: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
3507: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
3508: l_content_item_data := l_content_item_data || VARIABLE_B ||
3509: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
3510: ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn' THEN
3511: l_content_item_data := l_content_item_data || VARIABLE_B ||
3512: l_selected_fields(i).variable_name || '">' || l_lpn_info.lpn || VARIABLE_E;
3513: ELSIF LOWER(l_selected_fields(i).column_name) = 'parent_lpn' THEN

Line 4320: l_label_status := INV_LABEL.G_ERROR;

4316: l_content_item_data := l_content_item_data || variable_b ||
4317: l_selected_fields(i).variable_name || '">' || l_epc || variable_e;
4318: l_label_err_msg := l_epc_ret_msg;
4319: IF l_epc_ret_status = 'U' THEN
4320: l_label_status := INV_LABEL.G_ERROR;
4321: ELSIF l_epc_ret_status = 'E' THEN
4322: l_label_status := INV_LABEL.G_WARNING;
4323:
4324: END IF;

Line 4322: l_label_status := INV_LABEL.G_WARNING;

4318: l_label_err_msg := l_epc_ret_msg;
4319: IF l_epc_ret_status = 'U' THEN
4320: l_label_status := INV_LABEL.G_ERROR;
4321: ELSIF l_epc_ret_status = 'E' THEN
4322: l_label_status := INV_LABEL.G_WARNING;
4323:
4324: END IF;
4325: -- INVCONV changes start
4326:

Line 4384: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

4380: ------------------------Start of changes for Custom Labels project code------------------
4381:
4382: -- Fix for bug: 4179593 Start
4383: IF (l_CustSqlWarnFlagSet) THEN
4384: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
4385: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
4386: END IF;
4387:
4388: IF (l_CustSqlErrFlagSet) THEN

Line 4498: INV_LABEL.GET_DEFAULT_FORMAT

4494: -- get default format
4495: l_summary_format_id := null;
4496: l_summary_format := null;
4497:
4498: INV_LABEL.GET_DEFAULT_FORMAT
4499: (p_label_type_id => 5,
4500: p_label_format => l_summary_format,
4501: p_label_format_id => l_summary_format_id);
4502: IF l_summary_format_id IS NOT NULL THEN

Line 4527: trace('calling inv_label_pvt5 with lpn_id ' || v_child_lpn.lpn_id);

4523: l_label_type_child_lpn.default_no_of_copies := p_label_type_info.default_no_of_copies;
4524:
4525: FOR v_child_lpn IN c_child_lpns(l_lpn_id) LOOP
4526: IF l_debug = 1 THEN
4527: trace('calling inv_label_pvt5 with lpn_id ' || v_child_lpn.lpn_id);
4528: END IF;
4529: INV_LABEL_PVT5.get_variable_data(
4530: x_variable_content => l_child_lpn_summary
4531: , x_msg_count => l_msg_count

Line 4529: INV_LABEL_PVT5.get_variable_data(

4525: FOR v_child_lpn IN c_child_lpns(l_lpn_id) LOOP
4526: IF l_debug = 1 THEN
4527: trace('calling inv_label_pvt5 with lpn_id ' || v_child_lpn.lpn_id);
4528: END IF;
4529: INV_LABEL_PVT5.get_variable_data(
4530: x_variable_content => l_child_lpn_summary
4531: , x_msg_count => l_msg_count
4532: , x_msg_data => l_msg_data
4533: , x_return_status => l_return_status

Line 4552: g_req_cnt := inv_label.g_label_request_tbl.count();

4548: x_variable_content(l_label_index).label_content := l_child_lpn_summary(i).label_content;
4549: x_variable_content(l_label_index).label_request_id := l_child_lpn_summary(i).label_request_id;
4550: x_variable_content(l_label_index).label_status := l_child_lpn_summary(i).label_status;
4551: x_variable_content(l_label_index).error_message := l_child_lpn_summary(i).error_message;
4552: g_req_cnt := inv_label.g_label_request_tbl.count();
4553: IF l_debug = 1 THEN
4554: trace('g_req_cnt ' || g_req_cnt);
4555: END IF;
4556: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;

Line 4556: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;

4552: g_req_cnt := inv_label.g_label_request_tbl.count();
4553: IF l_debug = 1 THEN
4554: trace('g_req_cnt ' || g_req_cnt);
4555: END IF;
4556: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
4557: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
4558: IF l_debug = 1 THEN
4559: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
4560: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);

Line 4557: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;

4553: IF l_debug = 1 THEN
4554: trace('g_req_cnt ' || g_req_cnt);
4555: END IF;
4556: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
4557: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
4558: IF l_debug = 1 THEN
4559: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
4560: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);
4561: END IF;

Line 4559: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);

4555: END IF;
4556: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
4557: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
4558: IF l_debug = 1 THEN
4559: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
4560: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);
4561: END IF;
4562:
4563: l_label_index := l_label_index + 1;

Line 4560: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);

4556: inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id := l_child_lpn_summary(i).label_request_id;
4557: inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id := 5;
4558: IF l_debug = 1 THEN
4559: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_request_id);
4560: trace('inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id ' || inv_label.g_label_request_tbl(g_req_cnt+1).label_type_id);
4561: END IF;
4562:
4563: l_label_index := l_label_index + 1;
4564: END LOOP;

Line 4750: , p_label_type_info IN INV_LABEL.label_type_rec

4746: , x_msg_count OUT NOCOPY NUMBER
4747: , x_msg_data OUT NOCOPY VARCHAR2
4748: , x_return_status OUT NOCOPY VARCHAR2
4749: , x_var_content IN LONG DEFAULT NULL
4750: , p_label_type_info IN INV_LABEL.label_type_rec
4751: , p_transaction_id IN NUMBER
4752: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
4753: , p_transaction_identifier IN NUMBER
4754: ) IS

Line 4755: l_variable_data_tbl INV_LABEL.label_tbl_type;

4751: , p_transaction_id IN NUMBER
4752: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
4753: , p_transaction_identifier IN NUMBER
4754: ) IS
4755: l_variable_data_tbl INV_LABEL.label_tbl_type;
4756: BEGIN
4757: get_variable_data(
4758: x_variable_content => l_variable_data_tbl
4759: , x_msg_count => x_msg_count

Line 4777: END INV_LABEL_PVT4;

4773: END LOOP;
4774:
4775: END get_variable_data;
4776:
4777: END INV_LABEL_PVT4;