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

Line 1: PACKAGE BODY inv_label_pvt3 AS

1: PACKAGE BODY inv_label_pvt3 AS
2: /* $Header: INVLAP3B.pls 120.11 2006/02/23 01:48:21 dchithir 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_LPN');

9: l_debug NUMBER;
10:
11: PROCEDURE TRACE(p_message VARCHAR2) IS
12: BEGIN
13: inv_label.TRACE(p_message, 'LABEL_LPN');
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_LPN');
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 474: l_selected_fields inv_label.label_field_variable_tbl_type;

470: l_transfer_lpn_id NUMBER;
471: l_from_lpn_id NUMBER;
472: l_purchase_order po_headers_all.segment1%TYPE;
473: l_content_item_data LONG;
474: l_selected_fields inv_label.label_field_variable_tbl_type;
475: l_selected_fields_count NUMBER;
476: l_content_rec_index NUMBER := 0;
477: l_label_format_set_id NUMBER := 0;
478: l_label_format_id NUMBER;

Line 488: l_lpn_table inv_label.lpn_table_type;

484: l_error_message VARCHAR2(240);
485: l_msg_count NUMBER;
486: l_api_status VARCHAR2(240);
487: l_msg_data VARCHAR2(240);
488: l_lpn_table inv_label.lpn_table_type;
489: l_rcv_lpn_table inv_label_pvt3.rcv_lpn_table_type;
490: -- Bug 2515486
491: l_transaction_type_id NUMBER := 0;
492: l_transaction_action_id NUMBER := 0;

Line 489: l_rcv_lpn_table inv_label_pvt3.rcv_lpn_table_type;

485: l_msg_count NUMBER;
486: l_api_status VARCHAR2(240);
487: l_msg_data VARCHAR2(240);
488: l_lpn_table inv_label.lpn_table_type;
489: l_rcv_lpn_table inv_label_pvt3.rcv_lpn_table_type;
490: -- Bug 2515486
491: l_transaction_type_id NUMBER := 0;
492: l_transaction_action_id NUMBER := 0;
493: i NUMBER;

Line 534: l_debug := inv_label.l_debug;

530:
531: BEGIN
532: -- Initialize return status as success
533: x_return_status := fnd_api.g_ret_sts_success;
534: l_debug := inv_label.l_debug;
535:
536: IF (l_debug = 1) THEN
537: TRACE('**In PVT3: LPN label**');
538: TRACE(

Line 611: ELSIF p_label_type_info.business_flow_code = INV_LABEL.WMS_BF_IMPORT_ASN AND

607: l_lpn_table(i) := v_wdd_lpn.lpn_id;
608: i := i + 1;
609: END LOOP;
610: /* bug 3841820 */
611: ELSIF p_label_type_info.business_flow_code = INV_LABEL.WMS_BF_IMPORT_ASN AND
612: p_transaction_identifier = INV_LABEL.TRX_ID_RSH THEN
613: trace('business flow code is asn import and txnid is 6');
614: -- New Architecture for ASN : Get LPN details from RSH :J-DEV
615: -- Applicable with DM.J and IProc.J

Line 612: p_transaction_identifier = INV_LABEL.TRX_ID_RSH THEN

608: i := i + 1;
609: END LOOP;
610: /* bug 3841820 */
611: ELSIF p_label_type_info.business_flow_code = INV_LABEL.WMS_BF_IMPORT_ASN AND
612: p_transaction_identifier = INV_LABEL.TRX_ID_RSH THEN
613: trace('business flow code is asn import and txnid is 6');
614: -- New Architecture for ASN : Get LPN details from RSH :J-DEV
615: -- Applicable with DM.J and IProc.J
616: -- First retrieve the header level info

Line 986: l_label_status := INV_LABEL.G_SUCCESS;

982: FOR v_lpn_content IN c_lpn(l_lpn_id) LOOP
983: l_content_rec_index := l_content_rec_index + 1;
984: -- Bug 4238729, 10+ CU2 bug
985: -- Moved set label status and message here.
986: l_label_status := INV_LABEL.G_SUCCESS;
987: l_label_err_msg := NULL;
988:
989: IF (l_debug = 1) THEN
990: TRACE(' In Loop '|| l_content_rec_index);

Line 1011: inv_label.get_format_with_rule

1007: call the label rules engine to get appropriate label
1008: In this call if this happens to be for the label-set, the record
1009: from wms_label_request will be deleted inside following API*/
1010:
1011: inv_label.get_format_with_rule
1012: (
1013: p_document_id => p_label_type_info.label_type_id
1014: , p_label_format_id => p_label_type_info.manual_format_id
1015: , p_organization_id => v_lpn_content.organization_id

Line 1082: inv_label.get_format_with_rule

1078: --In R12 call this API for the format AGAIN without calling Rules ENGINE
1079: /* insert a record into wms_label_requests entity */
1080:
1081:
1082: inv_label.get_format_with_rule
1083: (
1084: p_document_id => p_label_type_info.label_type_id
1085: , p_label_format_id => l_label_formats_in_set.label_format_id --considers manual printer also
1086: , p_organization_id => v_lpn_content.organization_id

Line 1213: inv_label.get_variables_for_format

1209: * table to get RFID related information
1210: * Otherwise, it does not need to do that
1211: */
1212:
1213: inv_label.get_variables_for_format
1214: (
1215: x_variables => l_selected_fields
1216: , x_variables_count => l_selected_fields_count
1217: , x_is_variable_exist => l_is_epc_exist

Line 1275: p_group_id => inv_label.epc_group_id,

1271:
1272: WMS_EPC_PVT.generate_epc
1273: (p_org_id => v_lpn_content.organization_id,
1274: p_label_type_id => p_label_type_info.label_type_id, -- 3
1275: p_group_id => inv_label.epc_group_id,
1276: p_label_format_id => l_label_format_id,
1277: p_label_request_id => l_label_request_id,
1278: p_business_flow_code => p_label_type_info.business_flow_code,
1279: x_epc => l_epc,

Line 1286: trace('p_lpn_id='||v_lpn_content.lpn_id||',p_group_id='||inv_label.epc_group_id);

1282: );
1283:
1284: IF (l_debug = 1) THEN
1285: trace('Called generate_epc with ');
1286: trace('p_lpn_id='||v_lpn_content.lpn_id||',p_group_id='||inv_label.epc_group_id);
1287: trace('l_label_format_id='||l_label_format_id||',p_user_id='||fnd_global.user_id);
1288: trace('p_org_id='||v_lpn_content.organization_id);
1289: trace('l_label_request_id= '||l_label_request_id);
1290: trace('x_epc='||l_epc);

Line 1417: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

1413: END LOOP;
1414:
1415: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
1416: x_return_status := FND_API.G_RET_STS_SUCCESS;
1417: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1418: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1419: fnd_msg_pub.ADD;
1420: -- Fix for bug: 4179593 Start
1421: --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 1438: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

1434: trace('Custom Labels Trace [INVLAP3B.pls]: At Breadcrumb 3');
1435: trace('Custom Labels Trace [INVLAP3B.pls]: WARNING: No row returned by the Custom SQL query');
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_SUCCESS;
1438: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1439: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1440: fnd_msg_pub.ADD;
1441: -- Fix for bug: 4179593 Start
1442: --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 1505: || inv_label.g_date

1501: l_content_item_data := l_content_item_data
1502: || variable_b
1503: || l_selected_fields(i).variable_name
1504: || '">'
1505: || inv_label.g_date
1506: || variable_e;
1507: ELSIF LOWER(l_selected_fields(i).column_name) = 'current_time' THEN
1508: l_content_item_data := l_content_item_data
1509: || variable_b

Line 1512: || inv_label.g_time

1508: l_content_item_data := l_content_item_data
1509: || variable_b
1510: || l_selected_fields(i).variable_name
1511: || '">'
1512: || inv_label.g_time
1513: || variable_e;
1514: ELSIF LOWER(l_selected_fields(i).column_name) = 'request_user' THEN
1515: l_content_item_data := l_content_item_data
1516: || variable_b

Line 1519: || inv_label.g_user

1515: l_content_item_data := l_content_item_data
1516: || variable_b
1517: || l_selected_fields(i).variable_name
1518: || '">'
1519: || inv_label.g_user
1520: || variable_e;
1521: ELSIF LOWER(l_selected_fields(i).column_name) = 'lpn' THEN
1522: l_content_item_data := l_content_item_data
1523: || variable_b

Line 1846: l_label_status := INV_LABEL.G_ERROR;

1842: || l_epc
1843: || variable_e;
1844: l_label_err_msg := l_epc_ret_msg;
1845: IF l_epc_ret_status = 'U' THEN
1846: l_label_status := INV_LABEL.G_ERROR;
1847: ELSIF l_epc_ret_status = 'E' THEN
1848: l_label_status := INV_LABEL.G_WARNING;
1849: END IF;
1850:

Line 1848: l_label_status := INV_LABEL.G_WARNING;

1844: l_label_err_msg := l_epc_ret_msg;
1845: IF l_epc_ret_status = 'U' THEN
1846: l_label_status := INV_LABEL.G_ERROR;
1847: ELSIF l_epc_ret_status = 'E' THEN
1848: l_label_status := INV_LABEL.G_WARNING;
1849: END IF;
1850:
1851: END IF;
1852: END LOOP;

Line 1864: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

1860: ------------------------Start of changes for Custom Labels project code------------------
1861:
1862: -- Fix for bug: 4179593 Start
1863: IF (l_CustSqlWarnFlagSet) THEN
1864: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1865: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1866: END IF;
1867:
1868: IF (l_CustSqlErrFlagSet) THEN

Line 1921: , p_label_type_info IN inv_label.label_type_rec

1917: x_variable_content OUT NOCOPY LONG
1918: , x_msg_count OUT NOCOPY NUMBER
1919: , x_msg_data OUT NOCOPY VARCHAR2
1920: , x_return_status OUT NOCOPY VARCHAR2
1921: , p_label_type_info IN inv_label.label_type_rec
1922: , p_transaction_id IN NUMBER
1923: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
1924: , p_transaction_identifier IN NUMBER
1925: ) IS

Line 1926: l_variable_data_tbl inv_label.label_tbl_type;

1922: , p_transaction_id IN NUMBER
1923: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
1924: , p_transaction_identifier IN NUMBER
1925: ) IS
1926: l_variable_data_tbl inv_label.label_tbl_type;
1927: BEGIN
1928: get_variable_data(
1929: x_variable_content => l_variable_data_tbl
1930: , x_msg_count => x_msg_count

Line 1945: END inv_label_pvt3;

1941: x_variable_content :=
1942: x_variable_content || l_variable_data_tbl(i).label_content;
1943: END LOOP;
1944: END get_variable_data;
1945: END inv_label_pvt3;