DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_LOV dependencies on INV_TRX_UTIL_PUB

Line 52: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_TASk_LOV Unload ER Changes - p_page_type type' || p_page_type || 'p_unload Receiving -' || p_unload_receiving , '~~~~ ', 1);

48: l_wms_po_j_or_higher := 1;
49: END IF;
50:
51: --Unload ER
52: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_TASk_LOV Unload ER Changes - p_page_type type' || p_page_type || 'p_unload Receiving -' || p_unload_receiving , '~~~~ ', 1);
53:
54:
55:
56: IF p_page_type = 'SYSTEM_DROP'

Line 962: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_REASONS_LOV - p_reason type' || p_reason_type || 'p_concat_segments -' || p_concat_segments , '~~~~ ', 1); --/* Bug 9448490 Lot Substitution Project */

958: p_concat_segments IN VARCHAR2) IS
959:
960:
961: BEGIN
962: inv_trx_util_pub.trace( 'WMS_Task_Dispatch_LOV - GET_REASONS_LOV - p_reason type' || p_reason_type || 'p_concat_segments -' || p_concat_segments , '~~~~ ', 1); --/* Bug 9448490 Lot Substitution Project */
963:
964: OPEN x_reasons FOR
965: SELECT reason_name,description, reason_id
966: FROM mtl_transaction_reasons

Line 1479: inv_trx_util_pub.trace( 'WMSTSKLB ~getreasonlov 2 - entered overloaded proc -p_reason_type-'|| p_reason_type ||'-p_reason_contexts-'||p_reason_contexts||'-p_concat_segments-'||p_concat_segments , 'wms_alloc_gtmp_trigger', 1);

1475: l_context VARCHAR2(2);
1476: l_reason_count NUMBER := 0;
1477: BEGIN
1478: /* Bug 9448490 Lot Substitution Project */
1479: inv_trx_util_pub.trace( 'WMSTSKLB ~getreasonlov 2 - entered overloaded proc -p_reason_type-'|| p_reason_type ||'-p_reason_contexts-'||p_reason_contexts||'-p_concat_segments-'||p_concat_segments , 'wms_alloc_gtmp_trigger', 1);
1480:
1481: WHILE l_context_count < Length(p_reason_contexts) LOOP
1482: l_context := Substr(p_reason_contexts, l_context_count, 2);
1483: