DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on FND_FLEX_KEYVAL

Line 826: IF fnd_flex_keyval.validate_ccid ( APPL_SHORT_NAME => 'SQLGL'

822: IF (l_debug = 1) THEN
823: inv_log_util.trace('chart_of_accounts_id:'|| to_char(l_chart), 'INV_TXN_MANAGER_GRP','1');
824: END IF;
825:
826: IF fnd_flex_keyval.validate_ccid ( APPL_SHORT_NAME => 'SQLGL'
827: ,KEY_FLEX_CODE => 'GL#'
828: ,STRUCTURE_NUMBER => l_chart
829: ,COMBINATION_ID => p_acctid )
830: THEN

Line 831: catsegs := fnd_flex_keyval.concatenated_values;

827: ,KEY_FLEX_CODE => 'GL#'
828: ,STRUCTURE_NUMBER => l_chart
829: ,COMBINATION_ID => p_acctid )
830: THEN
831: catsegs := fnd_flex_keyval.concatenated_values;
832: IF fnd_flex_keyval.validate_segs ( OPERATION => 'CHECK_COMBINATION'
833: ,APPL_SHORT_NAME => 'SQLGL'
834: ,KEY_FLEX_CODE => 'GL#'
835: ,STRUCTURE_NUMBER => l_chart

Line 832: IF fnd_flex_keyval.validate_segs ( OPERATION => 'CHECK_COMBINATION'

828: ,STRUCTURE_NUMBER => l_chart
829: ,COMBINATION_ID => p_acctid )
830: THEN
831: catsegs := fnd_flex_keyval.concatenated_values;
832: IF fnd_flex_keyval.validate_segs ( OPERATION => 'CHECK_COMBINATION'
833: ,APPL_SHORT_NAME => 'SQLGL'
834: ,KEY_FLEX_CODE => 'GL#'
835: ,STRUCTURE_NUMBER => l_chart
836: ,CONCAT_SEGMENTS => catsegs

Line 846: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);

842: inv_log_util.trace('Distribution acct id : ' || p_acctid || ' is valid', 'INV_TXN_MANAGER_GRP','1');
843: END IF;
844: RETURN TRUE;
845: ELSE
846: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);
847: IF (l_debug = 1) THEN
848: inv_log_util.trace('Distribution acct id is invalid '|| l_error_exp, 'INV_TXN_MANAGER_GRP','1');
849: END IF;
850: RETURN FALSE;

Line 853: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);

849: END IF;
850: RETURN FALSE;
851: END IF;
852: ELSE
853: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);
854: IF (l_debug = 1) THEN
855: inv_log_util.trace('Distribution acct id Validation Error '|| l_error_exp, 'INV_TXN_MANAGER_GRP','1');
856: END IF;
857: RETURN FALSE;

Line 862: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);

858: END IF ;
859:
860: EXCEPTION
861: WHEN OTHERS THEN
862: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);
863: IF (l_debug = 1) THEN
864: inv_log_util.trace('Error in validate_acctid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
865: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
866: END IF;

Line 1108: l_result := FND_FLEX_KEYVAL.Validate_Segs(

1104: -- Gets the encoded cancatenated string
1105: l_itemsegs := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,
1106: segments => l_segmentarray,
1107: delimiter => l_delim);
1108: l_result := FND_FLEX_KEYVAL.Validate_Segs(
1109: OPERATION => 'FIND_COMBINATION',
1110: APPL_SHORT_NAME => 'INV',
1111: KEY_FLEX_CODE => 'MSTK',
1112: STRUCTURE_NUMBER => 101,

Line 1119: x_itemid := fnd_flex_keyval.combination_id;

1115: DATA_SET => p_orgid,
1116: SELECT_COMB_FROM_VIEW => 'MTL_SYSTEM_ITEMS_FVL') ;
1117:
1118: if l_result then
1119: x_itemid := fnd_flex_keyval.combination_id;
1120: else
1121: x_itemid := NULL;
1122: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
1123: inv_log_util.trace('Error in getitemid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');

Line 5160: call FND_FLEX_KEYVAL.Validate_Segs with 'CREATE_COMBINATION' operation*/

5156: * if it does not already exist else just check if it exists.
5157: */
5158: if p_locctrl = DYNAMIC then
5159: /*Bug#5044059, if the profile 'INV_CREATE_LOC_AT' is set to 'YES',
5160: call FND_FLEX_KEYVAL.Validate_Segs with 'CREATE_COMBINATION' operation*/
5161: IF (g_create_loc_at = 1) then
5162: l_operation := 'CREATE_COMBINATION';
5163: ELSE
5164: l_operation := 'CREATE_COMB_NO_AT';

Line 5170: l_val := FND_FLEX_KEYVAL.Validate_Segs(

5166: else
5167: l_operation := 'FIND_COMBINATION';
5168: end if;
5169:
5170: l_val := FND_FLEX_KEYVAL.Validate_Segs(
5171: OPERATION => l_operation,
5172: APPL_SHORT_NAME => 'INV',
5173: KEY_FLEX_CODE => 'MTLL',
5174: STRUCTURE_NUMBER => 101,

Line 5180: x_locid := fnd_flex_keyval.combination_id;

5176: VALUES_OR_IDS => 'I',
5177: DATA_SET => p_org_id ) ;
5178:
5179: if l_val then
5180: x_locid := fnd_flex_keyval.combination_id;
5181: else
5182: x_locid := NULL;
5183: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5184: IF (l_debug = 1) THEN

Line 5186: inv_log_util.trace('Error in getloc : error_segment :' || FND_FLEX_KEYVAL.error_segment , 'INV_TXN_MANAGER_GRP','1');

5182: x_locid := NULL;
5183: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5184: IF (l_debug = 1) THEN
5185: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5186: inv_log_util.trace('Error in getloc : error_segment :' || FND_FLEX_KEYVAL.error_segment , 'INV_TXN_MANAGER_GRP','1');
5187: inv_log_util.trace('Error in getloc : error_message :' || FND_FLEX_KEYVAL.error_message , 'INV_TXN_MANAGER_GRP','1');
5188: inv_log_util.trace('Error in getloc : encoded_error_message :' || FND_FLEX_KEYVAL.encoded_error_message , 'INV_TXN_MANAGER_GRP','1');
5189: END IF;
5190: end if;

Line 5187: inv_log_util.trace('Error in getloc : error_message :' || FND_FLEX_KEYVAL.error_message , 'INV_TXN_MANAGER_GRP','1');

5183: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5184: IF (l_debug = 1) THEN
5185: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5186: inv_log_util.trace('Error in getloc : error_segment :' || FND_FLEX_KEYVAL.error_segment , 'INV_TXN_MANAGER_GRP','1');
5187: inv_log_util.trace('Error in getloc : error_message :' || FND_FLEX_KEYVAL.error_message , 'INV_TXN_MANAGER_GRP','1');
5188: inv_log_util.trace('Error in getloc : encoded_error_message :' || FND_FLEX_KEYVAL.encoded_error_message , 'INV_TXN_MANAGER_GRP','1');
5189: END IF;
5190: end if;
5191:

Line 5188: inv_log_util.trace('Error in getloc : encoded_error_message :' || FND_FLEX_KEYVAL.encoded_error_message , 'INV_TXN_MANAGER_GRP','1');

5184: IF (l_debug = 1) THEN
5185: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5186: inv_log_util.trace('Error in getloc : error_segment :' || FND_FLEX_KEYVAL.error_segment , 'INV_TXN_MANAGER_GRP','1');
5187: inv_log_util.trace('Error in getloc : error_message :' || FND_FLEX_KEYVAL.error_message , 'INV_TXN_MANAGER_GRP','1');
5188: inv_log_util.trace('Error in getloc : encoded_error_message :' || FND_FLEX_KEYVAL.encoded_error_message , 'INV_TXN_MANAGER_GRP','1');
5189: END IF;
5190: end if;
5191:
5192: return l_val;