[Home] [Help]
6: --Bug No: 5246626:Added the procedures Print_debug and GET_RCV_SHP_FLEX_DETAILS
7:
8: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
9:
10: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11:
12: BEGIN
13: IF (l_debug = 1) THEN
14: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'inv_ui_rcv_lovs', p_level => p_level);
1072: FROM mtl_transaction_reasons
1073: WHERE NVL(disable_date,SYSDATE + 1) > SYSDATE
1074: AND reason_name LIKE (p_reason_code)
1075: -- nsrivast, invconv , transaction reason security
1076: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1077: OR
1078: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1079: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1080: AND
3309:
3310: IS
3311: -- Changes for GTIN CrossRef Type
3312: --
3313: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
3314: g_gtin_code_length NUMBER := 14;
3315: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
3316: l_from_lpn_id VARCHAR2(400) := p_from_lpn_id;
3317: l_append varchar2(2):='';
8226: x_Items OUT NOCOPY t_genref,
8227: p_Organization_Id IN NUMBER default null ,
8228: p_Concatenated_Segments IN VARCHAR2 default null )
8229: IS
8230: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
8231: g_gtin_code_length NUMBER := 14;
8232: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
8233: l_append varchar2(2):='';
8234: BEGIN
8545: )
8546:
8547: IS
8548:
8549: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
8550: g_gtin_code_length NUMBER := 14;
8551: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
8552: l_append varchar2(2):='';
8553: