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

Line 1: PACKAGE BODY INV_LABEL_PVT7 AS

1: PACKAGE BODY INV_LABEL_PVT7 AS
2: /* $Header: INVLAP7B.pls 120.11.12020000.3 2013/01/19 13:25:24 blavu ship $ */
3:
4: LABEL_B CONSTANT VARCHAR2(50) := ' 5: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);

Line 14: inv_label.trace(p_message, 'LABEL_SHIPPING');

10:
11:
12: PROCEDURE trace(p_message IN VARCHAR2) iS
13: BEGIN
14: inv_label.trace(p_message, 'LABEL_SHIPPING');
15: END trace;
16:
17: FUNCTION get_total_number_of_lpns(p_delivery_id IN NUMBER) RETURN NUMBER
18: IS

Line 55: l_debug NUMBER := INV_LABEL.l_debug;

51: AND wda.delivery_detail_id = wdd.delivery_detail_id
52: AND ROWNUM<2;
53:
54: l_dup_label VARCHAR2(1):= 'N';
55: l_debug NUMBER := INV_LABEL.l_debug;
56: BEGIN
57: IF (l_debug = 1) THEN
58: trace('In duplicate label check for del:'|| p_delivery_id||'tranxid:'||p_transaction_id);
59: End if;

Line 74: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type

70: END check_duplicate_label;
71: --End of fix for Bug# 5051977
72:
73: PROCEDURE get_variable_data(
74: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
75: , x_msg_count OUT NOCOPY NUMBER
76: , x_msg_data OUT NOCOPY VARCHAR2
77: , x_return_status OUT NOCOPY VARCHAR2
78: , p_label_type_info IN INV_LABEL.label_type_rec

Line 78: , p_label_type_info IN INV_LABEL.label_type_rec

74: x_variable_content OUT NOCOPY INV_LABEL.label_tbl_type
75: , x_msg_count OUT NOCOPY NUMBER
76: , x_msg_data OUT NOCOPY VARCHAR2
77: , x_return_status OUT NOCOPY VARCHAR2
78: , p_label_type_info IN INV_LABEL.label_type_rec
79: , p_transaction_id IN NUMBER
80: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
81: , p_transaction_identifier IN NUMBER
82: ) IS

Line 423: l_selected_fields INV_LABEL.label_field_variable_tbl_type;

419:
420: l_delivery_data LONG;
421: l_sales_order_header_id NUMBER; -- Introduced for bug: 5740331
422:
423: l_selected_fields INV_LABEL.label_field_variable_tbl_type;
424: l_selected_fields_count NUMBER;
425:
426: l_delivery_rec_index NUMBER := 0;
427:

Line 473: l_debug := INV_LABEL.l_debug;

469: -- Delivery ID is obtained from MMTT and joining mmtt.move_order_line_id
470: -- to wdd.move_order_line_id.. All the MMTT record with that header_id
471: -- has the same move_order_line_id
472:
473: l_debug := INV_LABEL.l_debug;
474: IF (l_debug = 1) THEN
475: trace('**In Shipping label**');
476: trace(' Business_flow: '||p_label_type_info.business_flow_code);
477: trace(' Transaction ID:'||p_transaction_id);

Line 645: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

641: IF (l_debug = 1) THEN
642: trace(' Getting selected fields ');
643: END IF;
644:
645: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
646: x_variables => l_selected_fields
647: , x_variables_count => l_selected_fields_count
648: , p_format_id => p_label_type_info.default_format_id);
649:

Line 703: INV_LABEL.GET_FORMAT_WITH_RULE

699: END IF;
700:
701: /* insert a record into wms_label_requests entity to
702: call the label rules engine to get appropriate label */
703: INV_LABEL.GET_FORMAT_WITH_RULE
704: ( p_document_id =>p_label_type_info.label_type_id,
705: P_LABEL_FORMAT_ID => p_label_type_info.manual_format_id,
706: p_delivery_id =>l_delivery_id,
707: --p_printer_name =>l_printer,-- Removed in R12: 4396558

Line 799: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

795: IF l_label_format_id <> nvl(l_prev_format_id, -999) THEN
796: IF (l_debug = 1) THEN
797: trace(' Getting variables for new format ' || l_label_format);
798: END IF;
799: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
800: x_variables => l_selected_fields
801: , x_variables_count => l_selected_fields_count
802: , p_format_id => l_label_format_id);
803:

Line 896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

892: END LOOP;
893:
894: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
895: x_return_status := FND_API.G_RET_STS_SUCCESS;
896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
897: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
898: fnd_msg_pub.ADD;
899: -- Fix for bug: 4179593 Start
900: --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 917: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

913: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 3');
914: trace('Custom Labels Trace [INVLAP7B.pls]: WARNING: No row returned by the Custom SQL query');
915: END IF;
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
918: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
919: fnd_msg_pub.ADD;
920: /* Replaced following statement for Bug 4207625: Anupam Jain*/
921: /*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 985: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;

981: END IF;
982: ------------------------End of this change for Custom Labels project code--------------------
983: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
984: l_delivery_data := l_delivery_data || VARIABLE_B ||
985: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
986: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
987: l_delivery_data := l_delivery_data || VARIABLE_B ||
988: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
989: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN

Line 988: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;

984: l_delivery_data := l_delivery_data || VARIABLE_B ||
985: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
986: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
987: l_delivery_data := l_delivery_data || VARIABLE_B ||
988: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
989: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
990: l_delivery_data := l_delivery_data || VARIABLE_B ||
991: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
992: ELSIF LOWER(l_selected_fields(i).column_name) = 'airbill' THEN

Line 991: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;

987: l_delivery_data := l_delivery_data || VARIABLE_B ||
988: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
989: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
990: l_delivery_data := l_delivery_data || VARIABLE_B ||
991: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
992: ELSIF LOWER(l_selected_fields(i).column_name) = 'airbill' THEN
993: l_delivery_data := l_delivery_data || VARIABLE_B ||
994: l_selected_fields(i).variable_name || '">' || v_delivery.airbill || VARIABLE_E;
995: ELSIF LOWER(l_selected_fields(i).column_name) = 'bill_of_lading' THEN

Line 1263: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

1259: ------------------------Start of changes for Custom Labels project code------------------
1260:
1261: -- Fix for bug: 4179593 Start
1262: IF (l_CustSqlWarnFlagSet) THEN
1263: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1264: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1265: END IF;
1266:
1267: IF (l_CustSqlErrFlagSet) THEN

Line 1320: , p_label_type_info IN INV_LABEL.label_type_rec

1316: x_variable_content OUT NOCOPY LONG
1317: , x_msg_count OUT NOCOPY NUMBER
1318: , x_msg_data OUT NOCOPY VARCHAR2
1319: , x_return_status OUT NOCOPY VARCHAR2
1320: , p_label_type_info IN INV_LABEL.label_type_rec
1321: , p_transaction_id IN NUMBER
1322: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
1323: , p_transaction_identifier IN NUMBER
1324: ) IS

Line 1325: l_variable_data_tbl INV_LABEL.label_tbl_type;

1321: , p_transaction_id IN NUMBER
1322: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
1323: , p_transaction_identifier IN NUMBER
1324: ) IS
1325: l_variable_data_tbl INV_LABEL.label_tbl_type;
1326: BEGIN
1327: get_variable_data(
1328: x_variable_content => l_variable_data_tbl
1329: , x_msg_count => x_msg_count

Line 1347: END INV_LABEL_PVT7;

1343:
1344: END get_variable_data;
1345:
1346:
1347: END INV_LABEL_PVT7;