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.5 2011/02/01 06:34:00 ksivasa 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_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 253: l_debug := inv_label.l_debug;

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

Line 254: l_label_status := INV_LABEL.G_SUCCESS;

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

Line 270: inv_label.get_variables_for_format(

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

Line 315: if (p_transaction_identifier = inv_label.TRX_ID_DIS)

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

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

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

Line 448: if (p_transaction_identifier = inv_label.TRX_ID_DIS)

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

Line 474: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS)

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

Line 505: if (p_transaction_identifier = inv_label.TRX_ID_DIS)

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

Line 526: ELSIF (p_transaction_identifier = inv_label.TRX_ID_UNDIS)

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

Line 615: inv_label.get_format_with_rule(

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

Line 643: l_label_status := INV_LABEL.G_ERROR;

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

Line 653: inv_label.get_variables_for_format(

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

Line 769: l_custom_sql_ret_status := INV_LABEL.G_WARNING;

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

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

1175: ------------------------Start of changes for Custom Labels project code------------------
1176:
1177: -- Fix for bug: 4179593 Start
1178: IF (l_CustSqlWarnFlagSet) THEN
1179: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1180: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1181: END IF;
1182:
1183: IF (l_CustSqlErrFlagSet) THEN

Line 1221: , p_label_type_info IN inv_label.label_type_rec

1217: x_variable_content OUT NOCOPY LONG
1218: , x_msg_count OUT NOCOPY NUMBER
1219: , x_msg_data OUT NOCOPY VARCHAR2
1220: , x_return_status OUT NOCOPY VARCHAR2
1221: , p_label_type_info IN inv_label.label_type_rec
1222: , p_transaction_id IN NUMBER
1223: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
1224: , p_transaction_identifier IN NUMBER
1225: ) IS

Line 1226: l_variable_data_tbl inv_label.label_tbl_type;

1222: , p_transaction_id IN NUMBER
1223: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
1224: , p_transaction_identifier IN NUMBER
1225: ) IS
1226: l_variable_data_tbl inv_label.label_tbl_type;
1227: BEGIN
1228: get_variable_data(
1229: x_variable_content => l_variable_data_tbl
1230: , x_msg_count => x_msg_count

Line 1246: END inv_label_pvt11;

1242: x_variable_content || l_variable_data_tbl(i).label_content;
1243: END LOOP;
1244:
1245: END get_variable_data;
1246: END inv_label_pvt11;