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.7.12010000.2 2008/07/29 13:41:02 ptkumar 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 403: l_selected_fields INV_LABEL.label_field_variable_tbl_type;

399:
400: l_delivery_data LONG;
401: l_sales_order_header_id NUMBER; -- Introduced for bug: 5740331
402:
403: l_selected_fields INV_LABEL.label_field_variable_tbl_type;
404: l_selected_fields_count NUMBER;
405:
406: l_delivery_rec_index NUMBER := 0;
407:

Line 453: l_debug := INV_LABEL.l_debug;

449: -- Delivery ID is obtained from MMTT and joining mmtt.move_order_line_id
450: -- to wdd.move_order_line_id.. All the MMTT record with that header_id
451: -- has the same move_order_line_id
452:
453: l_debug := INV_LABEL.l_debug;
454: IF (l_debug = 1) THEN
455: trace('**In Shipping label**');
456: trace(' Business_flow: '||p_label_type_info.business_flow_code);
457: trace(' Transaction ID:'||p_transaction_id);

Line 625: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

621: IF (l_debug = 1) THEN
622: trace(' Getting selected fields ');
623: END IF;
624:
625: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
626: x_variables => l_selected_fields
627: , x_variables_count => l_selected_fields_count
628: , p_format_id => p_label_type_info.default_format_id);
629:

Line 683: INV_LABEL.GET_FORMAT_WITH_RULE

679: END IF;
680:
681: /* insert a record into wms_label_requests entity to
682: call the label rules engine to get appropriate label */
683: INV_LABEL.GET_FORMAT_WITH_RULE
684: ( p_document_id =>p_label_type_info.label_type_id,
685: P_LABEL_FORMAT_ID => p_label_type_info.manual_format_id,
686: p_delivery_id =>l_delivery_id,
687: --p_printer_name =>l_printer,-- Removed in R12: 4396558

Line 778: INV_LABEL.GET_VARIABLES_FOR_FORMAT(

774: IF l_label_format_id <> nvl(l_prev_format_id, -999) THEN
775: IF (l_debug = 1) THEN
776: trace(' Getting variables for new format ' || l_label_format);
777: END IF;
778: INV_LABEL.GET_VARIABLES_FOR_FORMAT(
779: x_variables => l_selected_fields
780: , x_variables_count => l_selected_fields_count
781: , p_format_id => l_label_format_id);
782:

Line 875: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

871: END LOOP;
872:
873: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
876: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
877: fnd_msg_pub.ADD;
878: -- Fix for bug: 4179593 Start
879: --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 896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

892: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 3');
893: trace('Custom Labels Trace [INVLAP7B.pls]: WARNING: No row returned by the Custom SQL query');
894: END IF;
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_NO_DATA_FOUND');
898: fnd_msg_pub.ADD;
899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*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 964: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;

960: END IF;
961: ------------------------End of this change for Custom Labels project code--------------------
962: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_date' THEN
963: l_delivery_data := l_delivery_data || VARIABLE_B ||
964: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
965: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
966: l_delivery_data := l_delivery_data || VARIABLE_B ||
967: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
968: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN

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

963: l_delivery_data := l_delivery_data || VARIABLE_B ||
964: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_DATE || VARIABLE_E;
965: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
966: l_delivery_data := l_delivery_data || VARIABLE_B ||
967: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
968: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
969: l_delivery_data := l_delivery_data || VARIABLE_B ||
970: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
971: ELSIF LOWER(l_selected_fields(i).column_name) = 'airbill' THEN

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

966: l_delivery_data := l_delivery_data || VARIABLE_B ||
967: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_TIME || VARIABLE_E;
968: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
969: l_delivery_data := l_delivery_data || VARIABLE_B ||
970: l_selected_fields(i).variable_name || '">' || INV_LABEL.G_USER || VARIABLE_E;
971: ELSIF LOWER(l_selected_fields(i).column_name) = 'airbill' THEN
972: l_delivery_data := l_delivery_data || VARIABLE_B ||
973: l_selected_fields(i).variable_name || '">' || v_delivery.airbill || VARIABLE_E;
974: ELSIF LOWER(l_selected_fields(i).column_name) = 'bill_of_lading' THEN

Line 1242: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

1238: ------------------------Start of changes for Custom Labels project code------------------
1239:
1240: -- Fix for bug: 4179593 Start
1241: IF (l_CustSqlWarnFlagSet) THEN
1242: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1243: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1244: END IF;
1245:
1246: IF (l_CustSqlErrFlagSet) THEN

Line 1299: , p_label_type_info IN INV_LABEL.label_type_rec

1295: x_variable_content OUT NOCOPY LONG
1296: , x_msg_count OUT NOCOPY NUMBER
1297: , x_msg_data OUT NOCOPY VARCHAR2
1298: , x_return_status OUT NOCOPY VARCHAR2
1299: , p_label_type_info IN INV_LABEL.label_type_rec
1300: , p_transaction_id IN NUMBER
1301: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
1302: , p_transaction_identifier IN NUMBER
1303: ) IS

Line 1304: l_variable_data_tbl INV_LABEL.label_tbl_type;

1300: , p_transaction_id IN NUMBER
1301: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
1302: , p_transaction_identifier IN NUMBER
1303: ) IS
1304: l_variable_data_tbl INV_LABEL.label_tbl_type;
1305: BEGIN
1306: get_variable_data(
1307: x_variable_content => l_variable_data_tbl
1308: , x_msg_count => x_msg_count

Line 1326: END INV_LABEL_PVT7;

1322:
1323: END get_variable_data;
1324:
1325:
1326: END INV_LABEL_PVT7;