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_PVT2 dependencies on INV_LABEL

Line 1: PACKAGE BODY inv_label_pvt2 AS

1: PACKAGE BODY inv_label_pvt2 AS
2: /* $Header: INVLAP2B.pls 120.20.12010000.2 2008/07/29 13:40:38 ptkumar ship $ */
3: label_b CONSTANT VARCHAR2(50) := ' 4: label_e CONSTANT VARCHAR2(50) := '' || fnd_global.local_chr(10);
5: variable_b CONSTANT VARCHAR2(50) := '' || inv_label.g_date || variable_e;

2496: trace('Custom Labels Trace [INVLAP2B.pls]: --------------------------REPORT END-------------------------------------');
2497: END IF;
2498: ------------------------End of this changes for Custom Labels project code--------------------
2499: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
2500: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
2501: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2502: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
2503: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2504: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;

Line 2502: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;

2498: ------------------------End of this changes for Custom Labels project code--------------------
2499: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
2500: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
2501: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2502: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
2503: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2504: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;
2505: ELSIF LOWER(l_selected_fields(i).column_name) = 'item' THEN
2506: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || serial_rec.item || variable_e;

Line 2504: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;

2500: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
2501: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2502: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
2503: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2504: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;
2505: ELSIF LOWER(l_selected_fields(i).column_name) = 'item' THEN
2506: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || serial_rec.item || variable_e;
2507: ELSIF LOWER(l_selected_fields(i).column_name) = 'item_description' THEN
2508: l_serial_data :=

Line 3053: l_label_status := INV_LABEL.G_ERROR;

3049: || variable_e;
3050:
3051: l_label_err_msg := l_epc_ret_msg;
3052: IF l_epc_ret_status = 'U' THEN
3053: l_label_status := INV_LABEL.G_ERROR;
3054: ELSIF l_epc_ret_status = 'E' THEN
3055: l_label_status := INV_LABEL.G_WARNING;
3056:
3057: END IF;

Line 3055: l_label_status := INV_LABEL.G_WARNING;

3051: l_label_err_msg := l_epc_ret_msg;
3052: IF l_epc_ret_status = 'U' THEN
3053: l_label_status := INV_LABEL.G_ERROR;
3054: ELSIF l_epc_ret_status = 'E' THEN
3055: l_label_status := INV_LABEL.G_WARNING;
3056:
3057: END IF;
3058:
3059: END IF;

Line 3070: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3066: ------------------------Start of changes for Custom Labels project code------------------
3067:
3068: -- Fix for bug: 4179593 Start
3069: IF (l_CustSqlWarnFlagSet) THEN
3070: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3071: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3072: END IF;
3073:
3074: IF (l_CustSqlErrFlagSet) THEN

Line 3226: inv_label.get_number_between_range(

3222:
3223: l_serial_number := NULL;
3224: ELSE
3225: -- getting range serial numbers
3226: inv_label.get_number_between_range(
3227: fm_x_number => l_fm_serial_number
3228: , to_x_number => l_to_serial_number
3229: , x_return_status => l_return_status
3230: , x_number_table => l_serial_numbers_table

Line 3285: inv_label.get_number_between_range(

3281: IF (l_debug = 1) THEN
3282: TRACE(' Found Serial Number for the given ID: ' || p_transaction_id||'; l_serial_number: '||l_serial_number||'; l_fm_serial_number: '||l_fm_serial_number||'; l_to_serial_number: '||l_to_serial_number);
3283: END IF;
3284: -- getting range serial numbers
3285: inv_label.get_number_between_range(
3286: fm_x_number => l_fm_serial_number
3287: , to_x_number => l_to_serial_number
3288: , x_return_status => l_return_status
3289: , x_number_table => l_serial_numbers_table);

Line 3343: inv_label.get_number_between_range(

3339: IF (l_debug = 1) THEN
3340: TRACE(' Before call to GET_NUMBER_BETWEEN_RANGE ');
3341: END IF;
3342:
3343: inv_label.get_number_between_range(
3344: fm_x_number => l_fm_serial_number
3345: , to_x_number => l_to_serial_number
3346: , x_return_status => l_return_status
3347: , x_number_table => l_serial_numbers_table

Line 3481: inv_label.get_number_between_range(

3477: END IF;
3478: CLOSE wip_attributes_cur;
3479: END IF;
3480:
3481: inv_label.get_number_between_range(
3482: fm_x_number => l_fm_serial_number
3483: , to_x_number => l_to_serial_number
3484: , x_return_status => l_return_status
3485: , x_number_table => l_serial_numbers_table

Line 3531: inv_label.get_number_between_range(

3527:
3528: CLOSE flow_serial_curs_mti;
3529: -- RETURN;
3530: ELSE
3531: inv_label.get_number_between_range(
3532: fm_x_number => l_fm_serial_number
3533: , to_x_number => l_to_serial_number
3534: , x_return_status => l_return_status
3535: , x_number_table => l_serial_numbers_table

Line 3578: inv_label.get_number_between_range(

3574:
3575: CLOSE flow_serial_curs_mol;
3576: --RETURN;
3577: ELSE
3578: inv_label.get_number_between_range(
3579: fm_x_number => l_fm_serial_number
3580: , to_x_number => l_to_serial_number
3581: , x_return_status => l_return_status
3582: , x_number_table => l_serial_numbers_table

Line 3689: , p_label_type_info IN inv_label.label_type_rec

3685: x_variable_content OUT NOCOPY LONG
3686: , x_msg_count OUT NOCOPY NUMBER
3687: , x_msg_data OUT NOCOPY VARCHAR2
3688: , x_return_status OUT NOCOPY VARCHAR2
3689: , p_label_type_info IN inv_label.label_type_rec
3690: , p_transaction_id IN NUMBER
3691: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
3692: , p_transaction_identifier IN NUMBER
3693: ) IS

Line 3694: l_variable_data_tbl inv_label.label_tbl_type;

3690: , p_transaction_id IN NUMBER
3691: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
3692: , p_transaction_identifier IN NUMBER
3693: ) IS
3694: l_variable_data_tbl inv_label.label_tbl_type;
3695: BEGIN
3696: get_variable_data(
3697: x_variable_content => l_variable_data_tbl
3698: , x_msg_count => x_msg_count

Line 3712: END inv_label_pvt2;

3708: FOR i IN 1 .. l_variable_data_tbl.COUNT() LOOP
3709: x_variable_content := x_variable_content || l_variable_data_tbl(i).label_content;
3710: END LOOP;
3711: END get_variable_data;
3712: END inv_label_pvt2;