DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on FND_FLEX_KEYVAL

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

812: INTO l_chart
813: FROM ORG_ORGANIZATION_DEFINITIONS
814: WHERE ORGANIZATION_ID = p_orgid;
815:
816: IF fnd_flex_keyval.validate_ccid ( APPL_SHORT_NAME => 'SQLGL'
817: ,KEY_FLEX_CODE => 'GL#'
818: ,STRUCTURE_NUMBER => l_chart
819: ,COMBINATION_ID => p_acctid )
820: THEN

Line 821: catsegs := fnd_flex_keyval.concatenated_values;

817: ,KEY_FLEX_CODE => 'GL#'
818: ,STRUCTURE_NUMBER => l_chart
819: ,COMBINATION_ID => p_acctid )
820: THEN
821: catsegs := fnd_flex_keyval.concatenated_values;
822: IF fnd_flex_keyval.validate_segs ( OPERATION => 'CHECK_COMBINATION'
823: ,APPL_SHORT_NAME => 'SQLGL'
824: ,KEY_FLEX_CODE => 'GL#'
825: ,STRUCTURE_NUMBER => l_chart

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

818: ,STRUCTURE_NUMBER => l_chart
819: ,COMBINATION_ID => p_acctid )
820: THEN
821: catsegs := fnd_flex_keyval.concatenated_values;
822: IF fnd_flex_keyval.validate_segs ( OPERATION => 'CHECK_COMBINATION'
823: ,APPL_SHORT_NAME => 'SQLGL'
824: ,KEY_FLEX_CODE => 'GL#'
825: ,STRUCTURE_NUMBER => l_chart
826: ,CONCAT_SEGMENTS => catsegs

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

832: inv_log_util.trace('Distribution acct id : ' || p_acctid || ' is valid', 'INV_TXN_MANAGER_GRP','1');
833: END IF;
834: RETURN TRUE;
835: ELSE
836: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);
837: IF (l_debug = 1) THEN
838: inv_log_util.trace('Distribution acct id is invalid '|| l_error_exp, 'INV_TXN_MANAGER_GRP','1');
839: END IF;
840: RETURN FALSE;

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

839: END IF;
840: RETURN FALSE;
841: END IF;
842: ELSE
843: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);
844: IF (l_debug = 1) THEN
845: inv_log_util.trace('Distribution acct id Validation Error '|| l_error_exp, 'INV_TXN_MANAGER_GRP','1');
846: END IF;
847: RETURN FALSE;

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

848: END IF ;
849:
850: EXCEPTION
851: WHEN OTHERS THEN
852: l_error_exp := substr(fnd_flex_keyval.error_message,1,240);
853: IF (l_debug = 1) THEN
854: inv_log_util.trace('Error in validate_acctid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
855: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
856: END IF;

Line 1098: l_result := FND_FLEX_KEYVAL.Validate_Segs(

1094: -- Gets the encoded cancatenated string
1095: l_itemsegs := fnd_flex_ext.concatenate_segments(n_segments => l_nseg,
1096: segments => l_segmentarray,
1097: delimiter => l_delim);
1098: l_result := FND_FLEX_KEYVAL.Validate_Segs(
1099: OPERATION => 'FIND_COMBINATION',
1100: APPL_SHORT_NAME => 'INV',
1101: KEY_FLEX_CODE => 'MSTK',
1102: STRUCTURE_NUMBER => 101,

Line 1109: x_itemid := fnd_flex_keyval.combination_id;

1105: DATA_SET => p_orgid,
1106: SELECT_COMB_FROM_VIEW => 'MTL_SYSTEM_ITEMS_FVL') ;
1107:
1108: if l_result then
1109: x_itemid := fnd_flex_keyval.combination_id;
1110: else
1111: x_itemid := NULL;
1112: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
1113: inv_log_util.trace('Error in getitemid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');

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

4779: * if it does not already exist else just check if it exists.
4780: */
4781: if p_locctrl = DYNAMIC then
4782: /*Bug#5044059, if the profile 'INV_CREATE_LOC_AT' is set to 'YES',
4783: call FND_FLEX_KEYVAL.Validate_Segs with 'CREATE_COMBINATION' operation*/
4784: IF (g_create_loc_at = 1) then
4785: l_operation := 'CREATE_COMBINATION';
4786: ELSE
4787: l_operation := 'CREATE_COMB_NO_AT';

Line 4793: l_val := FND_FLEX_KEYVAL.Validate_Segs(

4789: else
4790: l_operation := 'FIND_COMBINATION';
4791: end if;
4792:
4793: l_val := FND_FLEX_KEYVAL.Validate_Segs(
4794: OPERATION => l_operation,
4795: APPL_SHORT_NAME => 'INV',
4796: KEY_FLEX_CODE => 'MTLL',
4797: STRUCTURE_NUMBER => 101,

Line 4803: x_locid := fnd_flex_keyval.combination_id;

4799: VALUES_OR_IDS => 'I',
4800: DATA_SET => p_org_id ) ;
4801:
4802: if l_val then
4803: x_locid := fnd_flex_keyval.combination_id;
4804: else
4805: x_locid := NULL;
4806: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
4807: IF (l_debug = 1) THEN

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

4805: x_locid := NULL;
4806: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
4807: IF (l_debug = 1) THEN
4808: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
4809: inv_log_util.trace('Error in getloc : error_segment :' || FND_FLEX_KEYVAL.error_segment , 'INV_TXN_MANAGER_GRP','1');
4810: inv_log_util.trace('Error in getloc : error_message :' || FND_FLEX_KEYVAL.error_message , 'INV_TXN_MANAGER_GRP','1');
4811: inv_log_util.trace('Error in getloc : encoded_error_message :' || FND_FLEX_KEYVAL.encoded_error_message , 'INV_TXN_MANAGER_GRP','1');
4812: END IF;
4813: end if;

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

4806: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
4807: IF (l_debug = 1) THEN
4808: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
4809: inv_log_util.trace('Error in getloc : error_segment :' || FND_FLEX_KEYVAL.error_segment , 'INV_TXN_MANAGER_GRP','1');
4810: inv_log_util.trace('Error in getloc : error_message :' || FND_FLEX_KEYVAL.error_message , 'INV_TXN_MANAGER_GRP','1');
4811: inv_log_util.trace('Error in getloc : encoded_error_message :' || FND_FLEX_KEYVAL.encoded_error_message , 'INV_TXN_MANAGER_GRP','1');
4812: END IF;
4813: end if;
4814:

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

4807: IF (l_debug = 1) THEN
4808: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
4809: inv_log_util.trace('Error in getloc : error_segment :' || FND_FLEX_KEYVAL.error_segment , 'INV_TXN_MANAGER_GRP','1');
4810: inv_log_util.trace('Error in getloc : error_message :' || FND_FLEX_KEYVAL.error_message , 'INV_TXN_MANAGER_GRP','1');
4811: inv_log_util.trace('Error in getloc : encoded_error_message :' || FND_FLEX_KEYVAL.encoded_error_message , 'INV_TXN_MANAGER_GRP','1');
4812: END IF;
4813: end if;
4814:
4815: return l_val;