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

Line 1: PACKAGE BODY inv_label_pvt11 AS

1: PACKAGE BODY inv_label_pvt11 AS
2: /* $Header: INVLA11B.pls 120.2 2006/05/08 22:39:38 rahugupt noship $ */
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_INV_13');

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

27:
28: -- l_lpn_id NUMBER;
29: l_content_lpn_id NUMBER;
30: l_content_item_data LONG;
31: l_selected_fields inv_label.label_field_variable_tbl_type;
32: l_selected_fields_count NUMBER;
33: l_content_rec_index NUMBER := 0;
34: l_label_format_id NUMBER := 0;
35: l_label_format VARCHAR2(100);

Line 252: l_debug := inv_label.l_debug;

248:
249: BEGIN
250: -- Initialize return status as success
251: x_return_status := fnd_api.g_ret_sts_success;
252: l_debug := inv_label.l_debug;
253: l_label_status := INV_LABEL.G_SUCCESS;
254:
255: IF (l_debug = 1) THEN
256: TRACE('***** In PVT11: (GMO Label) ***********');

Line 253: l_label_status := INV_LABEL.G_SUCCESS;

249: BEGIN
250: -- Initialize return status as success
251: x_return_status := fnd_api.g_ret_sts_success;
252: l_debug := inv_label.l_debug;
253: l_label_status := INV_LABEL.G_SUCCESS;
254:
255: IF (l_debug = 1) THEN
256: TRACE('***** In PVT11: (GMO Label) ***********');
257: TRACE(

Line 269: inv_label.get_variables_for_format(

265: || p_label_type_info.label_type_id
266: );
267: END IF;
268:
269: inv_label.get_variables_for_format(
270: x_variables => l_selected_fields
271: , x_variables_count => l_selected_fields_count
272: , p_format_id => p_label_type_info.default_format_id
273: );

Line 314: if (p_transaction_identifier = inv_label.TRX_ID_DIS)

310: IF (l_debug = 1) THEN
311: TRACE('** in GMO PVT11.get_variable_data ** , start ' || l_label_index );
312: END IF;
313:
314: if (p_transaction_identifier = inv_label.TRX_ID_DIS)
315: THEN
316:
317: OPEN c_dispense_details;
318:

Line 365: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS) -- UNDISPENSIN transaction

361: l_hazard_class,
362: l_inventory_item_id;
363: close c_dispense_details;
364:
365: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS) -- UNDISPENSIN transaction
366: THEN
367: OPEN c_undispense_details;
368:
369: IF c_undispense_details%NOTFOUND

Line 447: if (p_transaction_identifier = inv_label.TRX_ID_DIS)

443:
444: IF ( p_label_type_info.label_type_id = 11)
445: -- Process Material label
446: THEN
447: if (p_transaction_identifier = inv_label.TRX_ID_DIS)
448: then
449:
450: open c_get_mode_meaning;
451: fetch c_get_mode_meaning into l_dispensing_mode;

Line 473: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS)

469: l_material_qty := l_actual_gross_weight - l_target_container_tare;
470: l_dispensed_container := l_source_container_item;
471: END IF;
472:
473: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS)
474: THEN
475: open c_get_mode_meaning;
476: fetch c_get_mode_meaning into l_undispensing_mode;
477: close c_get_mode_meaning;

Line 504: if (p_transaction_identifier = inv_label.TRX_ID_DIS)

500:
501: ELSIF ( p_label_type_info.label_type_id = 12) -- dispense material label
502: THEN
503:
504: if (p_transaction_identifier = inv_label.TRX_ID_DIS)
505: then
506: open c_get_mode_meaning;
507: fetch c_get_mode_meaning into l_dispensing_mode;
508: close c_get_mode_meaning;

Line 525: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS)

521: /* dispense qty */
522: l_dispensed_qty := GMO_DISPENSE_PVT.GET_NET_DISP_DISPENSED_QTY (P_DISPENSE_ID => l_dispense_id);
523:
524:
525: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS)
526: THEN
527: -- UNDISPENSIN transaction
528:
529: open c_get_mode_meaning;

Line 614: inv_label.get_format_with_rule(

610:
611: -- insert a record into wms_label_requests entity to
612: -- call the label rules engine to get appropriate label
613:
614: inv_label.get_format_with_rule(
615: p_document_id => p_label_type_info.label_type_id
616: , p_label_format_id => p_label_type_info.manual_format_id
617: , p_organization_id => l_organization_id
618: , p_inventory_item_id => l_inventory_item_id

Line 642: l_label_status := INV_LABEL.G_ERROR;

638: fnd_message.set_name('WMS', 'WMS_LABL_RULE_ENGINE_FAILED');
639: fnd_msg_pub.ADD;
640: l_label_format := p_label_type_info.default_format_id;
641: l_label_format_id := p_label_type_info.default_format_name;
642: l_label_status := INV_LABEL.G_ERROR;
643: END IF;
644:
645: IF (l_label_format_id IS NOT NULL) THEN
646: -- Derive the fields for the format either passed in or derived via the rules engine.

Line 652: inv_label.get_variables_for_format(

648: IF (l_debug = 1) THEN
649: TRACE(' Getting variables for new format '|| l_label_format);
650: END IF;
651:
652: inv_label.get_variables_for_format(
653: x_variables => l_selected_fields
654: , x_variables_count => l_selected_fields_count
655: , p_format_id => l_label_format_id
656: );

Line 768: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

764: END LOOP;
765:
766: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
769: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
770: fnd_msg_pub.ADD;
771: -- Fix for bug: 4179593 Start
772: --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 789: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

785: trace('Custom Labels Trace [INVLA11B.pls]: At Breadcrumb 3');
786: trace('Custom Labels Trace [INVLA11B.pls]: WARNING: No row returned by the Custom SQL query');
787: END IF;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
790: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
791: fnd_msg_pub.ADD;
792: -- Fix for bug: 4179593 Start
793: --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 1172: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

1168: ------------------------Start of changes for Custom Labels project code------------------
1169:
1170: -- Fix for bug: 4179593 Start
1171: IF (l_CustSqlWarnFlagSet) THEN
1172: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1173: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1174: END IF;
1175:
1176: IF (l_CustSqlErrFlagSet) THEN

Line 1214: , p_label_type_info IN inv_label.label_type_rec

1210: x_variable_content OUT NOCOPY LONG
1211: , x_msg_count OUT NOCOPY NUMBER
1212: , x_msg_data OUT NOCOPY VARCHAR2
1213: , x_return_status OUT NOCOPY VARCHAR2
1214: , p_label_type_info IN inv_label.label_type_rec
1215: , p_transaction_id IN NUMBER
1216: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
1217: , p_transaction_identifier IN NUMBER
1218: ) IS

Line 1219: l_variable_data_tbl inv_label.label_tbl_type;

1215: , p_transaction_id IN NUMBER
1216: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
1217: , p_transaction_identifier IN NUMBER
1218: ) IS
1219: l_variable_data_tbl inv_label.label_tbl_type;
1220: BEGIN
1221: get_variable_data(
1222: x_variable_content => l_variable_data_tbl
1223: , x_msg_count => x_msg_count

Line 1239: END inv_label_pvt11;

1235: x_variable_content || l_variable_data_tbl(i).label_content;
1236: END LOOP;
1237:
1238: END get_variable_data;
1239: END inv_label_pvt11;