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

Line 1: PACKAGE BODY INV_LABEL_PVT6 AS

1: PACKAGE BODY INV_LABEL_PVT6 AS
2: /* $Header: INVLAP6B.pls 120.3 2005/08/25 19:23:59 satkumar ship $ */
3:
4: LABEL_B CONSTANT VARCHAR2(50) := ' 5: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);

Line 13: INV_LABEL.trace(p_message, 'LABEL_LOCATION');

9: l_debug number;
10:
11: PROCEDURE trace(p_message IN VARCHAR2) iS
12: BEGIN
13: INV_LABEL.trace(p_message, 'LABEL_LOCATION');
14: END trace;
15:
16: PROCEDURE get_variable_data(
17: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type

Line 17: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type

13: INV_LABEL.trace(p_message, 'LABEL_LOCATION');
14: END trace;
15:
16: PROCEDURE get_variable_data(
17: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
18: , x_msg_count OUT NOCOPY NUMBER
19: , x_msg_data OUT NOCOPY VARCHAR2
20: , x_return_status OUT NOCOPY VARCHAR2
21: , p_label_type_info IN INV_LABEL.label_type_rec

Line 21: , p_label_type_info IN INV_LABEL.label_type_rec

17: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
18: , x_msg_count OUT NOCOPY NUMBER
19: , x_msg_data OUT NOCOPY VARCHAR2
20: , x_return_status OUT NOCOPY VARCHAR2
21: , p_label_type_info IN INV_LABEL.label_type_rec
22: , p_transaction_id IN NUMBER
23: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
24: , p_transaction_identifier IN NUMBER
25: ) IS

Line 152: l_selected_fields INV_LABEL.label_field_variable_tbl_type;

148:
149:
150: l_location_data LONG;
151:
152: l_selected_fields INV_LABEL.label_field_variable_tbl_type;
153: l_selected_fields_count NUMBER;
154:
155: l_content_rec_index NUMBER := 0;
156:

Line 187: l_debug := INV_LABEL.l_debug;

183:
184: -- a list of columns that are selected for format
185: l_column_name_list LONG;
186: BEGIN
187: l_debug := INV_LABEL.l_debug;
188: IF (l_debug = 1) THEN
189: trace('**In PVT6: Location label**');
190: trace(' Business_flow: '||p_label_type_info.business_flow_code);
191: trace(' Transaction ID:'||p_transaction_id);

Line 344: INV_LABEL.GET_FORMAT_WITH_RULE

340: END IF;
341:
342: /* insert a record into wms_label_requests entity to
343: call the label rules engine to get appropriate label */
344: INV_LABEL.GET_FORMAT_WITH_RULE
345: ( p_document_id =>p_label_type_info.label_type_id,
346: P_LABEL_FORMAT_ID => p_label_type_info.manual_format_id,
347: p_organization_id =>v_location.organization_id,
348: p_subinventory_code =>v_location.subinventory_code,

Line 435: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

431: THEN --l_prev_format_id initial value is -999
432: IF (l_debug = 1) THEN
433: trace(' Getting variables for new format ' || l_label_format);
434: END IF;
435: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
436: x_variables => l_selected_fields
437: , x_variables_count => l_selected_fields_count
438: , p_format_id => l_label_format_id);
439:

Line 530: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

526: END LOOP;
527:
528: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
531: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --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 551: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

547: trace('Custom Labels Trace [INVLAP6B.pls]: At Breadcrumb 3');
548: trace('Custom Labels Trace [INVLAP6B.pls]: WARNING: No row returned by the Custom SQL query');
549: END IF;
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
552: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
553: fnd_msg_pub.ADD;
554: /* Replaced following statement for Bug 4207625: Anupam Jain*/
555: /*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 617: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;

613: trace('Custom Labels Trace [INVLAP6B.pls]: After assigning it to l_location_data');
614: trace('Custom Labels Trace [INVLAP6B.pls]: --------------------------REPORT END-------------------------------------');
615: END IF;
616: ------------------------End of this change for Custom Labels project code--------------------
617: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
618: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
619: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
620: ELSIF LOWER(l_selected_fields(i).column_name) = 'organization' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.organization || VARIABLE_E;
621: ELSIF LOWER(l_selected_fields(i).column_name) = 'subinventory_code' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.subinventory_code || VARIABLE_E;

Line 618: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;

614: trace('Custom Labels Trace [INVLAP6B.pls]: --------------------------REPORT END-------------------------------------');
615: END IF;
616: ------------------------End of this change for Custom Labels project code--------------------
617: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
618: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
619: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
620: ELSIF LOWER(l_selected_fields(i).column_name) = 'organization' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.organization || VARIABLE_E;
621: ELSIF LOWER(l_selected_fields(i).column_name) = 'subinventory_code' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.subinventory_code || VARIABLE_E;
622: ELSIF LOWER(l_selected_fields(i).column_name) = 'subinventory_description' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.subinventory_description || VARIABLE_E;

Line 619: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;

615: END IF;
616: ------------------------End of this change for Custom Labels project code--------------------
617: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
618: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
619: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
620: ELSIF LOWER(l_selected_fields(i).column_name) = 'organization' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.organization || VARIABLE_E;
621: ELSIF LOWER(l_selected_fields(i).column_name) = 'subinventory_code' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.subinventory_code || VARIABLE_E;
622: ELSIF LOWER(l_selected_fields(i).column_name) = 'subinventory_description' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.subinventory_description || VARIABLE_E;
623: ELSIF LOWER(l_selected_fields(i).column_name) = 'subinventory_status' THEN l_location_data := l_location_data || VARIABLE_B || l_selected_fields(i).variable_name || '">' || v_location.subinventory_status || VARIABLE_E;

Line 682: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

678:
679: ------------------------Start of changes for Custom Labels project code------------------
680: -- Fix for bug: 4179593 Start
681: IF (l_CustSqlWarnFlagSet) THEN
682: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
683: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
684: END IF;
685:
686: IF (l_CustSqlErrFlagSet) THEN

Line 757: , p_label_type_info IN INV_LABEL.label_type_rec

753: x_variable_content OUT NOCOPY LONG
754: , x_msg_count OUT NOCOPY NUMBER
755: , x_msg_data OUT NOCOPY VARCHAR2
756: , x_return_status OUT NOCOPY VARCHAR2
757: , p_label_type_info IN INV_LABEL.label_type_rec
758: , p_transaction_id IN NUMBER
759: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
760: , p_transaction_identifier IN NUMBER
761: ) IS

Line 762: l_variable_data_tbl INV_LABEL.label_tbl_type;

758: , p_transaction_id IN NUMBER
759: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
760: , p_transaction_identifier IN NUMBER
761: ) IS
762: l_variable_data_tbl INV_LABEL.label_tbl_type;
763: BEGIN
764: get_variable_data(
765: x_variable_content => l_variable_data_tbl
766: , x_msg_count => x_msg_count

Line 784: END INV_LABEL_PVT6;

780:
781: END get_variable_data;
782:
783:
784: END INV_LABEL_PVT6;