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

Line 1: PACKAGE BODY INV_LABEL_PVT5 AS

1: PACKAGE BODY INV_LABEL_PVT5 AS
2: /* $Header: INVLAP5B.pls 120.22.12010000.2 2008/07/29 13:40:51 ptkumar ship $ */
3:
4: -- Bug 2795525 : This mask is used to mask all date fields.
5: G_DATE_FORMAT_MASK VARCHAR2(100) := INV_LABEL.G_DATE_FORMAT_MASK;

Line 5: G_DATE_FORMAT_MASK VARCHAR2(100) := INV_LABEL.G_DATE_FORMAT_MASK;

1: PACKAGE BODY INV_LABEL_PVT5 AS
2: /* $Header: INVLAP5B.pls 120.22.12010000.2 2008/07/29 13:40:51 ptkumar ship $ */
3:
4: -- Bug 2795525 : This mask is used to mask all date fields.
5: G_DATE_FORMAT_MASK VARCHAR2(100) := INV_LABEL.G_DATE_FORMAT_MASK;
6:
7: LABEL_B CONSTANT VARCHAR2(50) := ' 8: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
9: VARIABLE_B CONSTANT VARCHAR2(50) := '' || INV_LABEL.G_DATE || VARIABLE_E;

2608:
2609: l_variable_name := get_variable_name('current_date', row_index_per_label-1, l_label_format_id);
2610: IF l_variable_name IS NOT NULL THEN
2611: l_content_item_data := l_content_item_data || VARIABLE_B ||
2612: l_variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
2613: END IF;
2614: l_variable_name := get_variable_name('current_time', row_index_per_label-1, l_label_format_id);
2615: IF l_variable_name IS NOT NULL THEN
2616: l_content_item_data := l_content_item_data || VARIABLE_B ||

Line 2617: l_variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;

2613: END IF;
2614: l_variable_name := get_variable_name('current_time', row_index_per_label-1, l_label_format_id);
2615: IF l_variable_name IS NOT NULL THEN
2616: l_content_item_data := l_content_item_data || VARIABLE_B ||
2617: l_variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
2618: END IF;
2619: l_variable_name := get_variable_name('request_user', row_index_per_label-1, l_label_format_id);
2620: IF l_variable_name IS NOT NULL THEN
2621: l_content_item_data := l_content_item_data || VARIABLE_B ||

Line 2622: l_variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;

2618: END IF;
2619: l_variable_name := get_variable_name('request_user', row_index_per_label-1, l_label_format_id);
2620: IF l_variable_name IS NOT NULL THEN
2621: l_content_item_data := l_content_item_data || VARIABLE_B ||
2622: l_variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
2623: END IF;
2624: l_variable_name := get_variable_name('lpn', row_index_per_label-1, l_label_format_id);
2625: IF l_variable_name IS NOT NULL THEN
2626: l_content_item_data := l_content_item_data || VARIABLE_B ||

Line 3529: l_label_status := INV_LABEL.G_ERROR;

3525: l_content_item_data := l_content_item_data || variable_b ||
3526: l_variable_name || '">' || l_epc || variable_e;
3527: l_label_err_msg := l_epc_ret_msg;
3528: IF l_epc_ret_status = 'U' THEN
3529: l_label_status := INV_LABEL.G_ERROR;
3530: ELSIF l_epc_ret_status = 'E' THEN
3531: l_label_status := INV_LABEL.G_WARNING;
3532: END IF;
3533:

Line 3531: l_label_status := INV_LABEL.G_WARNING;

3527: l_label_err_msg := l_epc_ret_msg;
3528: IF l_epc_ret_status = 'U' THEN
3529: l_label_status := INV_LABEL.G_ERROR;
3530: ELSIF l_epc_ret_status = 'E' THEN
3531: l_label_status := INV_LABEL.G_WARNING;
3532: END IF;
3533:
3534: END IF;
3535:

Line 3557: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3553: ------------------------Start of changes for Custom Labels project code------------------
3554:
3555: -- Fix for bug: 4179593 Start
3556: IF (l_CustSqlWarnFlagSet) THEN
3557: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3558: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3559: END IF;
3560:
3561: IF (l_CustSqlErrFlagSet) THEN

Line 3780: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3776:
3777: ------------------------Start of changes for Custom Labels project code------------------
3778: -- Fix for bug: 4179593 Start
3779: IF (l_CustSqlWarnFlagSet) THEN
3780: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3781: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3782: END IF;
3783:
3784: IF (l_CustSqlErrFlagSet) THEN

Line 3861: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3857: ------------------------Start of changes for Custom Labels project code------------------
3858:
3859: -- Fix for bug: 4179593 Start
3860: IF (l_CustSqlWarnFlagSet) THEN
3861: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3862: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3863: END IF;
3864:
3865: IF (l_CustSqlErrFlagSet) THEN

Line 3952: , p_label_type_info IN INV_LABEL.label_type_rec

3948: x_variable_content OUT NOCOPY LONG
3949: , x_msg_count OUT NOCOPY NUMBER
3950: , x_msg_data OUT NOCOPY VARCHAR2
3951: , x_return_status OUT NOCOPY VARCHAR2
3952: , p_label_type_info IN INV_LABEL.label_type_rec
3953: , p_transaction_id IN NUMBER
3954: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3955: , p_lpn_id IN NUMBER
3956: , p_transaction_identifier IN NUMBER

Line 3958: l_variable_data_tbl INV_LABEL.label_tbl_type;

3954: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3955: , p_lpn_id IN NUMBER
3956: , p_transaction_identifier IN NUMBER
3957: ) IS
3958: l_variable_data_tbl INV_LABEL.label_tbl_type;
3959: BEGIN
3960: get_variable_data(
3961: x_variable_content => l_variable_data_tbl
3962: , x_msg_count => x_msg_count

Line 3980: END INV_LABEL_PVT5;

3976: END LOOP;
3977:
3978: END get_variable_data;
3979:
3980: END INV_LABEL_PVT5;