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

Line 1: PACKAGE BODY INV_LABEL_PVT10 AS

1: PACKAGE BODY INV_LABEL_PVT10 AS
2: /* $Header: INVLA10B.pls 120.5.12020000.3 2012/07/17 06:04:19 yintang ship $ */
3:
4: LABEL_B CONSTANT VARCHAR2(50) := ' 5: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);

Line 21: G_DATE_FORMAT_MASK VARCHAR2(20) := INV_LABEL.G_DATE_FORMAT_MASK;

17: MTI_TYPE CONSTANT NUMBER := 2;
18: MTRL_TYPE CONSTANT NUMBER := 3;
19: WFS_TYPE CONSTANT NUMBER := 4;
20:
21: G_DATE_FORMAT_MASK VARCHAR2(20) := INV_LABEL.G_DATE_FORMAT_MASK;
22:
23: TYPE output_rec is RECORD
24: (
25: datbuf VARCHAR2(240)

Line 32: INV_LABEL.trace(p_message, 'LABEL_FLOW_CONT');

28: TYPE output_tbl_type IS TABLE OF output_rec INDEX BY BINARY_INTEGER;
29:
30: PROCEDURE trace(p_message VARCHAR2) IS
31: BEGIN
32: INV_LABEL.trace(p_message, 'LABEL_FLOW_CONT');
33: END trace;
34:
35: PROCEDURE get_data(
36: x_out_tbl IN OUT NOCOPY output_tbl_type,

Line 141: l_debug := INV_LABEL.l_debug;

137: WHERE wip_entity_id = p_wip_entity_id ;
138:
139:
140: BEGIN
141: l_debug := INV_LABEL.l_debug;
142: IF (l_debug = 1) THEN
143: trace('**In get_data() **.');
144: trace(' p_schedule_number : ' || p_schedule_number);
145: trace(' p_wip_entity_Id : ' || p_wip_entity_id);

Line 1763: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type

1759: * Main Procedure *
1760: *=================================================================*
1761: */
1762: PROCEDURE get_variable_data(
1763: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
1764: ,x_msg_count OUT NOCOPY NUMBER
1765: ,x_msg_data OUT NOCOPY VARCHAR2
1766: ,x_return_status OUT NOCOPY VARCHAR2
1767: ,p_label_type_info IN INV_LABEL.label_type_rec

Line 1767: ,p_label_type_info IN INV_LABEL.label_type_rec

1763: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
1764: ,x_msg_count OUT NOCOPY NUMBER
1765: ,x_msg_data OUT NOCOPY VARCHAR2
1766: ,x_return_status OUT NOCOPY VARCHAR2
1767: ,p_label_type_info IN INV_LABEL.label_type_rec
1768: ,p_transaction_id IN NUMBER
1769: ,p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
1770: ,p_transaction_identifier IN NUMBER
1771: ) IS

Line 1818: l_serial_numbers_table inv_label.serial_tab_type;

1814: l_prev_in_tbl inptype;
1815: l_out_tbl output_tbl_type;
1816: l_counter INTEGER;
1817: l_in_rec inptype;
1818: l_serial_numbers_table inv_label.serial_tab_type;
1819: l_transaction_identifier NUMBER;
1820: l_serial_not_found BOOLEAN;
1821:
1822: ---------------------------------------------------------------------------------------------

Line 2266: l_selected_fields INV_LABEL.label_field_variable_tbl_type;

2262: l_uom VARCHAR2(3) := null;
2263: l_subinventory_code mtl_material_transactions_temp.subinventory_code%TYPE;
2264: l_locator_id NUMBER := null; -- Added for bug13781065
2265:
2266: l_selected_fields INV_LABEL.label_field_variable_tbl_type;
2267: l_selected_fields_count NUMBER;
2268:
2269: l_label_format_id NUMBER := 0 ;
2270: l_label_format VARCHAR2(100);

Line 2296: l_debug := INV_LABEL.l_debug;

2292: --so that get_printer is not called if the subinventory is the same
2293: l_prev_sub VARCHAR2(30);
2294:
2295: BEGIN
2296: l_debug := INV_LABEL.l_debug;
2297:
2298: -- Initialize return status as success
2299: x_return_status := FND_API.G_RET_STS_SUCCESS;
2300: IF (l_debug = 1) THEN

Line 2474: INV_LABEL.GET_NUMBER_BETWEEN_RANGE(

2470: IF (l_debug = 1) THEN
2471: trace(' Before call to GET_SERIALS_BETWEEN_RANGE');
2472: END IF;
2473: IF (l_in_rec.serial_number_start) <> (l_in_rec.serial_number_end) THEN
2474: INV_LABEL.GET_NUMBER_BETWEEN_RANGE(
2475: fm_x_number => l_in_rec.serial_number_start
2476: ,to_x_number => l_in_rec.serial_number_end
2477: ,x_return_status => l_return_status
2478: ,x_number_table => l_serial_numbers_table);

Line 2620: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

2616:
2617: IF (l_debug = 1) THEN
2618: trace(' Getting default format selected fields ');
2619: END IF;
2620: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
2621: x_variables => l_selected_fields
2622: ,x_variables_count => l_selected_fields_count
2623: ,p_format_id => p_label_type_info.default_format_id);
2624:

Line 2774: INV_LABEL.get_format_with_rule

2770: trace('Apply Rules engine for format, printer=' || l_printer ||',manual_format_id='||p_label_type_info.manual_format_id ||',manual_format_name='||p_label_type_info.manual_format_name);
2771: END IF;
2772:
2773:
2774: INV_LABEL.get_format_with_rule
2775: (
2776: p_document_id => p_label_type_info.label_type_id,
2777: P_LABEL_FORMAT_ID => p_label_type_info.manual_format_id,
2778: p_organization_id => l_in_tbl(i).organization_id,

Line 2864: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

2860: IF l_label_format_id <> nvl(l_prev_label_format_id, -999) THEN
2861: IF (l_debug = 1) THEN
2862: trace(' Getting variables for new format ' || l_label_format);
2863: END IF;
2864: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
2865: x_variables => l_selected_fields
2866: , x_variables_count => l_selected_fields_count
2867: , p_format_id => l_label_format_id);
2868:

Line 2955: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

2951: END LOOP;
2952:
2953: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2954: x_return_status := FND_API.G_RET_STS_SUCCESS;
2955: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2956: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2957: fnd_msg_pub.ADD;
2958: -- Fix for bug: 4179593 Start
2959: --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 2977: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

2973: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 3');
2974: trace('Custom Labels Trace [INVLA10B.pls]: WARNING: No row returned by the Custom SQL query');
2975: END IF;
2976: x_return_status := FND_API.G_RET_STS_SUCCESS;
2977: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2978: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2979: fnd_msg_pub.ADD;
2980: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2981: /*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 3046: '">' || INV_LABEL.G_DATE || VARIABLE_E;

3042: ------------------------End of this change for Custom Labels project code--------------------
3043: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
3044: l_content_item_data := l_content_item_data || VARIABLE_B ||
3045: l_selected_fields(i).variable_name ||
3046: '">' || INV_LABEL.G_DATE || VARIABLE_E;
3047: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
3048: l_content_item_data := l_content_item_data || VARIABLE_B ||
3049: l_selected_fields(i).variable_name ||
3050: '">' || INV_LABEL.G_TIME || VARIABLE_E;

Line 3050: '">' || INV_LABEL.G_TIME || VARIABLE_E;

3046: '">' || INV_LABEL.G_DATE || VARIABLE_E;
3047: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
3048: l_content_item_data := l_content_item_data || VARIABLE_B ||
3049: l_selected_fields(i).variable_name ||
3050: '">' || INV_LABEL.G_TIME || VARIABLE_E;
3051: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
3052: l_content_item_data := l_content_item_data || VARIABLE_B ||
3053: l_selected_fields(i).variable_name ||
3054: '">' || INV_LABEL.G_USER || VARIABLE_E;

Line 3054: '">' || INV_LABEL.G_USER || VARIABLE_E;

3050: '">' || INV_LABEL.G_TIME || VARIABLE_E;
3051: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
3052: l_content_item_data := l_content_item_data || VARIABLE_B ||
3053: l_selected_fields(i).variable_name ||
3054: '">' || INV_LABEL.G_USER || VARIABLE_E;
3055: ELSE
3056: l_field_value := '';
3057: --trace(' Finished writing variables ');
3058: IF (l_out_tbl.EXISTS(l_field_id) ) THEN

Line 3078: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

3074: ------------------------Start of changes for Custom Labels project code------------------
3075:
3076: -- Fix for bug: 4179593 Start
3077: IF (l_CustSqlWarnFlagSet) THEN
3078: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3079: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3080: END IF;
3081:
3082: IF (l_CustSqlErrFlagSet) THEN

Line 3126: END INV_LABEL_PVT10;

3122:
3123:
3124: END get_variable_data;
3125:
3126: END INV_LABEL_PVT10;