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.26 2011/04/19 09:05:35 ssrikaku 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;

2518: trace('Custom Labels Trace [INVLAP2B.pls]: --------------------------REPORT END-------------------------------------');
2519: END IF;
2520: ------------------------End of this changes for Custom Labels project code--------------------
2521: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
2522: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
2523: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2524: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
2525: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2526: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;

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

2520: ------------------------End of this changes for Custom Labels project code--------------------
2521: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
2522: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
2523: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2524: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
2525: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2526: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;
2527: ELSIF LOWER(l_selected_fields(i).column_name) = 'item' THEN
2528: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || serial_rec.item || variable_e;

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

2522: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_date || variable_e;
2523: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
2524: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_time || variable_e;
2525: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
2526: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || inv_label.g_user || variable_e;
2527: ELSIF LOWER(l_selected_fields(i).column_name) = 'item' THEN
2528: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || serial_rec.item || variable_e;
2529: ELSIF LOWER(l_selected_fields(i).column_name) = 'client_item' THEN -- Added for LSP Project, bug 9087971
2530: l_serial_data := l_serial_data || variable_b || l_selected_fields(i).variable_name || '">' || serial_rec.client_item || variable_e;

Line 3077: l_label_status := INV_LABEL.G_ERROR;

3073: || variable_e;
3074:
3075: l_label_err_msg := l_epc_ret_msg;
3076: IF l_epc_ret_status = 'U' THEN
3077: l_label_status := INV_LABEL.G_ERROR;
3078: ELSIF l_epc_ret_status = 'E' THEN
3079: l_label_status := INV_LABEL.G_WARNING;
3080:
3081: END IF;

Line 3079: l_label_status := INV_LABEL.G_WARNING;

3075: l_label_err_msg := l_epc_ret_msg;
3076: IF l_epc_ret_status = 'U' THEN
3077: l_label_status := INV_LABEL.G_ERROR;
3078: ELSIF l_epc_ret_status = 'E' THEN
3079: l_label_status := INV_LABEL.G_WARNING;
3080:
3081: END IF;
3082:
3083: END IF;

Line 3094: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3090: ------------------------Start of changes for Custom Labels project code------------------
3091:
3092: -- Fix for bug: 4179593 Start
3093: IF (l_CustSqlWarnFlagSet) THEN
3094: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3095: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3096: END IF;
3097:
3098: IF (l_CustSqlErrFlagSet) THEN

Line 3250: inv_label.get_number_between_range(

3246:
3247: l_serial_number := NULL;
3248: ELSE
3249: -- getting range serial numbers
3250: inv_label.get_number_between_range(
3251: fm_x_number => l_fm_serial_number
3252: , to_x_number => l_to_serial_number
3253: , x_return_status => l_return_status
3254: , x_number_table => l_serial_numbers_table

Line 3309: inv_label.get_number_between_range(

3305: IF (l_debug = 1) THEN
3306: 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);
3307: END IF;
3308: -- getting range serial numbers
3309: inv_label.get_number_between_range(
3310: fm_x_number => l_fm_serial_number
3311: , to_x_number => l_to_serial_number
3312: , x_return_status => l_return_status
3313: , x_number_table => l_serial_numbers_table);

Line 3367: inv_label.get_number_between_range(

3363: IF (l_debug = 1) THEN
3364: TRACE(' Before call to GET_NUMBER_BETWEEN_RANGE ');
3365: END IF;
3366:
3367: inv_label.get_number_between_range(
3368: fm_x_number => l_fm_serial_number
3369: , to_x_number => l_to_serial_number
3370: , x_return_status => l_return_status
3371: , x_number_table => l_serial_numbers_table

Line 3521: inv_label.get_number_between_range(

3517: trace( ' No records returned by wip_attributes_cur cursor');
3518: end;
3519: END IF;
3520:
3521: inv_label.get_number_between_range(
3522: fm_x_number => l_fm_serial_number
3523: , to_x_number => l_to_serial_number
3524: , x_return_status => l_return_status
3525: , x_number_table => l_serial_numbers_table

Line 3571: inv_label.get_number_between_range(

3567:
3568: CLOSE flow_serial_curs_mti;
3569: -- RETURN;
3570: ELSE
3571: inv_label.get_number_between_range(
3572: fm_x_number => l_fm_serial_number
3573: , to_x_number => l_to_serial_number
3574: , x_return_status => l_return_status
3575: , x_number_table => l_serial_numbers_table

Line 3618: inv_label.get_number_between_range(

3614:
3615: CLOSE flow_serial_curs_mol;
3616: --RETURN;
3617: ELSE
3618: inv_label.get_number_between_range(
3619: fm_x_number => l_fm_serial_number
3620: , to_x_number => l_to_serial_number
3621: , x_return_status => l_return_status
3622: , x_number_table => l_serial_numbers_table

Line 3729: , p_label_type_info IN inv_label.label_type_rec

3725: x_variable_content OUT NOCOPY LONG
3726: , x_msg_count OUT NOCOPY NUMBER
3727: , x_msg_data OUT NOCOPY VARCHAR2
3728: , x_return_status OUT NOCOPY VARCHAR2
3729: , p_label_type_info IN inv_label.label_type_rec
3730: , p_transaction_id IN NUMBER
3731: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
3732: , p_transaction_identifier IN NUMBER
3733: ) IS

Line 3734: l_variable_data_tbl inv_label.label_tbl_type;

3730: , p_transaction_id IN NUMBER
3731: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
3732: , p_transaction_identifier IN NUMBER
3733: ) IS
3734: l_variable_data_tbl inv_label.label_tbl_type;
3735: BEGIN
3736: get_variable_data(
3737: x_variable_content => l_variable_data_tbl
3738: , x_msg_count => x_msg_count

Line 3752: END inv_label_pvt2;

3748: FOR i IN 1 .. l_variable_data_tbl.COUNT() LOOP
3749: x_variable_content := x_variable_content || l_variable_data_tbl(i).label_content;
3750: END LOOP;
3751: END get_variable_data;
3752: END inv_label_pvt2;