APPS.INV_LABEL_PVT3 dependencies on INV_LABEL

Line 1: PACKAGE BODY inv_label_pvt3 AS

1: PACKAGE BODY inv_label_pvt3 AS
2: /* $Header: INVLAP3B.pls 120.13.12020000.3 2013/02/28 08:11:07 srsomasu 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) := ''
1867: || inv_label.g_date
1868: || variable_e;
1869: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
1870: l_content_item_data := l_content_item_data
1871: || variable_b

Line 1874: || inv_label.g_time

1870: l_content_item_data := l_content_item_data
1871: || variable_b
1872: || l_selected_fields(i).variable_name
1873: || '">'
1874: || inv_label.g_time
1875: || variable_e;
1876: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
1877: l_content_item_data := l_content_item_data
1878: || variable_b

Line 1881: || inv_label.g_user

1877: l_content_item_data := l_content_item_data
1878: || variable_b
1879: || l_selected_fields(i).variable_name
1880: || '">'
1881: || inv_label.g_user
1882: || variable_e;
1883: ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn' THEN
1884: l_content_item_data := l_content_item_data
1885: || variable_b

Line 2208: l_label_status := INV_LABEL.G_ERROR;

2204: || l_epc
2205: || variable_e;
2206: l_label_err_msg := l_epc_ret_msg;
2207: IF l_epc_ret_status = 'U' THEN
2208: l_label_status := INV_LABEL.G_ERROR;
2209: ELSIF l_epc_ret_status = 'E' THEN
2210: l_label_status := INV_LABEL.G_WARNING;
2211: END IF;
2212:

Line 2210: l_label_status := INV_LABEL.G_WARNING;

2206: l_label_err_msg := l_epc_ret_msg;
2207: IF l_epc_ret_status = 'U' THEN
2208: l_label_status := INV_LABEL.G_ERROR;
2209: ELSIF l_epc_ret_status = 'E' THEN
2210: l_label_status := INV_LABEL.G_WARNING;
2211: END IF;
2212:
2213: END IF;
2214: END LOOP;

Line 2226: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

2222: ------------------------Start of changes for Custom Labels project code------------------
2223:
2224: -- Fix for bug: 4179593 Start
2225: IF (l_CustSqlWarnFlagSet) THEN
2226: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2227: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
2228: END IF;
2229:
2230: IF (l_CustSqlErrFlagSet) THEN

Line 2283: , p_label_type_info IN inv_label.label_type_rec

2279: x_variable_content OUT NOCOPY LONG
2280: , x_msg_count OUT NOCOPY NUMBER
2281: , x_msg_data OUT NOCOPY VARCHAR2
2282: , x_return_status OUT NOCOPY VARCHAR2
2283: , p_label_type_info IN inv_label.label_type_rec
2284: , p_transaction_id IN NUMBER
2285: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
2286: , p_transaction_identifier IN NUMBER
2287: ) IS

Line 2288: l_variable_data_tbl inv_label.label_tbl_type;

2284: , p_transaction_id IN NUMBER
2285: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
2286: , p_transaction_identifier IN NUMBER
2287: ) IS
2288: l_variable_data_tbl inv_label.label_tbl_type;
2289: BEGIN
2290: get_variable_data(
2291: x_variable_content => l_variable_data_tbl
2292: , x_msg_count => x_msg_count

Line 2307: END inv_label_pvt3;

2303: x_variable_content :=
2304: x_variable_content || l_variable_data_tbl(i).label_content;
2305: END LOOP;
2306: END get_variable_data;
2307: END inv_label_pvt3;