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_TXN_MANAGER_GRP dependencies on FND_FLEX_KEY_API

Line 877: kff fnd_flex_key_api.flexfield_type;

873: FUNCTION getacctid(x_acctid OUT NOCOPY NUMBER, p_orgid IN NUMBER, p_rowid IN VARCHAR2)
874: RETURN BOOLEAN
875: IS
876:
877: kff fnd_flex_key_api.flexfield_type;
878: str fnd_flex_key_api.structure_type;
879: seg fnd_flex_key_api.segment_type;
880: seg_list fnd_flex_key_api.segment_list;
881: j number;

Line 878: str fnd_flex_key_api.structure_type;

874: RETURN BOOLEAN
875: IS
876:
877: kff fnd_flex_key_api.flexfield_type;
878: str fnd_flex_key_api.structure_type;
879: seg fnd_flex_key_api.segment_type;
880: seg_list fnd_flex_key_api.segment_list;
881: j number;
882: i number;

Line 879: seg fnd_flex_key_api.segment_type;

875: IS
876:
877: kff fnd_flex_key_api.flexfield_type;
878: str fnd_flex_key_api.structure_type;
879: seg fnd_flex_key_api.segment_type;
880: seg_list fnd_flex_key_api.segment_list;
881: j number;
882: i number;
883: nsegs number;

Line 880: seg_list fnd_flex_key_api.segment_list;

876:
877: kff fnd_flex_key_api.flexfield_type;
878: str fnd_flex_key_api.structure_type;
879: seg fnd_flex_key_api.segment_type;
880: seg_list fnd_flex_key_api.segment_list;
881: j number;
882: i number;
883: nsegs number;
884: l_popul boolean;

Line 938: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');

934: FROM ORG_ORGANIZATION_DEFINITIONS
935: WHERE ORGANIZATION_ID = p_orgid;
936:
937:
938: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
939: str := fnd_flex_key_api.find_structure(kff, l_chart);
940: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
941:
942: /*

Line 939: str := fnd_flex_key_api.find_structure(kff, l_chart);

935: WHERE ORGANIZATION_ID = p_orgid;
936:
937:
938: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
939: str := fnd_flex_key_api.find_structure(kff, l_chart);
940: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
941:
942: /*
943: * When the flexfield is defined, the order the segments are displayed

Line 940: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);

936:
937:
938: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
939: str := fnd_flex_key_api.find_structure(kff, l_chart);
940: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
941:
942: /*
943: * When the flexfield is defined, the order the segments are displayed
944: * and the order of segment columns need not be the same. For example, a

Line 950: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));

946: * The following loop re-arranges the order of the flexfield segments
947: * so that the AOL routine can process it.
948: */
949: for i in 1..nsegs loop
950: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
951: j := 1;
952: while (j <= tmp_seg_arr.count) loop
953: if (seg.column_name = 'SEGMENT' || j) THEN
954: segarray(i) := tmp_seg_arr(j).colvalue;

Line 1006: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

1002: FND_MESSAGE.set_name('INV','INV-Database corrupt');
1003: FND_MESSAGE.set_token('ROUTINE','getacctid');
1004: RETURN FALSE;
1005: WHEN OTHERS THEN
1006: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
1007: IF (l_debug = 1) THEN
1008: inv_log_util.trace('Error in getacctid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
1009: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
1010: END IF;

Line 1027: l_seglist fnd_flex_key_api.segment_list;

1023: FUNCTION getitemid(x_itemid out NOCOPY NUMBER, p_orgid NUMBER, p_rowid VARCHAR2)
1024: RETURN BOOLEAN
1025: IS
1026: l_nseg NUMBER;
1027: l_seglist fnd_flex_key_api.segment_list;
1028: l_segs1 fnd_flex_ext.segmentarray;
1029: l_fftype fnd_flex_key_api.flexfield_type;
1030: l_ffstru fnd_flex_key_api.structure_type;
1031: l_segment_type fnd_flex_key_api.segment_type;

Line 1029: l_fftype fnd_flex_key_api.flexfield_type;

1025: IS
1026: l_nseg NUMBER;
1027: l_seglist fnd_flex_key_api.segment_list;
1028: l_segs1 fnd_flex_ext.segmentarray;
1029: l_fftype fnd_flex_key_api.flexfield_type;
1030: l_ffstru fnd_flex_key_api.structure_type;
1031: l_segment_type fnd_flex_key_api.segment_type;
1032: -- Local array to hold the data for getting the cancatenated segment.
1033: l_segmentarray fnd_flex_ext.segmentarray;

Line 1030: l_ffstru fnd_flex_key_api.structure_type;

1026: l_nseg NUMBER;
1027: l_seglist fnd_flex_key_api.segment_list;
1028: l_segs1 fnd_flex_ext.segmentarray;
1029: l_fftype fnd_flex_key_api.flexfield_type;
1030: l_ffstru fnd_flex_key_api.structure_type;
1031: l_segment_type fnd_flex_key_api.segment_type;
1032: -- Local array to hold the data for getting the cancatenated segment.
1033: l_segmentarray fnd_flex_ext.segmentarray;
1034: l_itemsegs VARCHAR2(32000);

Line 1031: l_segment_type fnd_flex_key_api.segment_type;

1027: l_seglist fnd_flex_key_api.segment_list;
1028: l_segs1 fnd_flex_ext.segmentarray;
1029: l_fftype fnd_flex_key_api.flexfield_type;
1030: l_ffstru fnd_flex_key_api.structure_type;
1031: l_segment_type fnd_flex_key_api.segment_type;
1032: -- Local array to hold the data for getting the cancatenated segment.
1033: l_segmentarray fnd_flex_ext.segmentarray;
1034: l_itemsegs VARCHAR2(32000);
1035: l_delim VARCHAR2(1);

Line 1085: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MSTK');

1081: FROM mtl_transactions_interface mti
1082: WHERE mti.rowid = p_rowid;
1083:
1084: -- find flex field type
1085: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MSTK');
1086:
1087: -- find flex structure type
1088: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
1089:

Line 1088: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);

1084: -- find flex field type
1085: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MSTK');
1086:
1087: -- find flex structure type
1088: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
1089:
1090: -- find segment list for the key flex field
1091: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1092:

Line 1091: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);

1087: -- find flex structure type
1088: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
1089:
1090: -- find segment list for the key flex field
1091: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1092:
1093: -- find segment delimiter
1094: l_delim := l_ffstru.segment_separator;
1095:

Line 1098: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(l_loop));

1094: l_delim := l_ffstru.segment_separator;
1095:
1096: -- get the corresponding column for all segments
1097: FOR l_loop IN 1..l_nseg LOOP
1098: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(l_loop));
1099: -- Bug Fix#4747090
1100: --l_segmentarray contains data in the order flexfield is defined. Used in creating cancatenated segments for validation.
1101: l_segmentarray(l_loop) := l_segs1(To_number(Substr(l_segment_type.column_name, 8)));
1102: END LOOP;

Line 1122: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

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');
1124: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
1125: end if;
1126: return l_result;

Line 1143: l_seglist fnd_flex_key_api.segment_list;

1139: FUNCTION getsrcid(x_trxsrc OUT NOCOPY NUMBER, p_srctype IN NUMBER, p_orgid IN NUMBER, p_rowid IN VARCHAR2)
1140: RETURN BOOLEAN
1141: IS
1142: l_nseg NUMBER;
1143: l_seglist fnd_flex_key_api.segment_list;
1144: l_fftype fnd_flex_key_api.flexfield_type;
1145: l_ffstru fnd_flex_key_api.structure_type;
1146: l_segment_type fnd_flex_key_api.segment_type;
1147: l_structure_list fnd_flex_key_api.structure_list;

Line 1144: l_fftype fnd_flex_key_api.flexfield_type;

1140: RETURN BOOLEAN
1141: IS
1142: l_nseg NUMBER;
1143: l_seglist fnd_flex_key_api.segment_list;
1144: l_fftype fnd_flex_key_api.flexfield_type;
1145: l_ffstru fnd_flex_key_api.structure_type;
1146: l_segment_type fnd_flex_key_api.segment_type;
1147: l_structure_list fnd_flex_key_api.structure_list;
1148: l_chart NUMBER;

Line 1145: l_ffstru fnd_flex_key_api.structure_type;

1141: IS
1142: l_nseg NUMBER;
1143: l_seglist fnd_flex_key_api.segment_list;
1144: l_fftype fnd_flex_key_api.flexfield_type;
1145: l_ffstru fnd_flex_key_api.structure_type;
1146: l_segment_type fnd_flex_key_api.segment_type;
1147: l_structure_list fnd_flex_key_api.structure_list;
1148: l_chart NUMBER;
1149: segarray fnd_flex_ext.segmentarray;

Line 1146: l_segment_type fnd_flex_key_api.segment_type;

1142: l_nseg NUMBER;
1143: l_seglist fnd_flex_key_api.segment_list;
1144: l_fftype fnd_flex_key_api.flexfield_type;
1145: l_ffstru fnd_flex_key_api.structure_type;
1146: l_segment_type fnd_flex_key_api.segment_type;
1147: l_structure_list fnd_flex_key_api.structure_list;
1148: l_chart NUMBER;
1149: segarray fnd_flex_ext.segmentarray;
1150: tmp_seg_arr seg_arr_type;

Line 1147: l_structure_list fnd_flex_key_api.structure_list;

1143: l_seglist fnd_flex_key_api.segment_list;
1144: l_fftype fnd_flex_key_api.flexfield_type;
1145: l_ffstru fnd_flex_key_api.structure_type;
1146: l_segment_type fnd_flex_key_api.segment_type;
1147: l_structure_list fnd_flex_key_api.structure_list;
1148: l_chart NUMBER;
1149: segarray fnd_flex_ext.segmentarray;
1150: tmp_seg_arr seg_arr_type;
1151: i NUMBER;

Line 1156: seg fnd_flex_key_api.segment_type;

1152: j NUMBER;
1153: l_app_shortname VARCHAR2(20);
1154: l_struct_number NUMBER;
1155: l_flex_code VARCHAR2(20);
1156: seg fnd_flex_key_api.segment_type;
1157: l_result boolean; -- Added for bug 3346767
1158:
1159: BEGIN
1160: SELECT DSP_SEGMENT1, DSP_SEGMENT2, DSP_SEGMENT3,

Line 1207: l_fftype := fnd_flex_key_api.find_flexfield(l_app_shortname,l_flex_code);

1203: END IF;
1204: END IF;
1205: END IF;
1206:
1207: l_fftype := fnd_flex_key_api.find_flexfield(l_app_shortname,l_flex_code);
1208: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, l_struct_number);
1209:
1210: -- find segment list for the key flex field
1211: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);

Line 1208: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, l_struct_number);

1204: END IF;
1205: END IF;
1206:
1207: l_fftype := fnd_flex_key_api.find_flexfield(l_app_shortname,l_flex_code);
1208: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, l_struct_number);
1209:
1210: -- find segment list for the key flex field
1211: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1212:

Line 1211: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);

1207: l_fftype := fnd_flex_key_api.find_flexfield(l_app_shortname,l_flex_code);
1208: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, l_struct_number);
1209:
1210: -- find segment list for the key flex field
1211: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1212:
1213: /*
1214: * When the flexfield is defined, the order the segments are displayed
1215: * and the order of segment columns need not be the same. For example, a

Line 1221: seg := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(i));

1217: * The following loop re-arranges the order of the flexfield segments
1218: * so that the AOL routine can process it.
1219: */
1220: for i in 1..l_nseg loop
1221: seg := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(i));
1222: j := 1;
1223: while (j <= tmp_seg_arr.count) loop
1224: if (seg.column_name = 'SEGMENT' || j) THEN
1225: segarray(i) := tmp_seg_arr(j).colvalue;

Line 1278: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

1274: end if;
1275:
1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
1279: IF (l_debug = 1) THEN
1280: inv_log_util.trace('Error in getsrcid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
1281: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
1282: END IF;

Line 2097: fnd_flex_key_api.set_session_mode('seed_data');

2093:
2094:
2095: /* commented logical validations fr inv_globals pre-req*/
2096: IF (l_validate_full) THEN --J-dev
2097: fnd_flex_key_api.set_session_mode('seed_data');
2098: derive_segment_ids(p_header_id, x_return_status ,x_msg_count, x_msg_data);
2099: END IF;
2100: loaderrmsg('INV_INT_TRXACTCODE', 'INV_INT_TRXACTCODE');
2101:

Line 5087: -- Uses FND_FLEX_KEY_API (AFFFKAIS/B.pls) and

5083: -- Function
5084: -- getloc
5085: -- Description
5086: -- Private function to get Locator id using Flex API's
5087: -- Uses FND_FLEX_KEY_API (AFFFKAIS/B.pls) and
5088: -- FND_FLEX_EXT (AFFFEXTS/B.pls)
5089: --
5090: -- Assumes that only Id's are populated in the MTI segments
5091: --

Line 5100: l_seglist fnd_flex_key_api.segment_list;

5096: ******************************************************************/
5097:
5098: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
5099: l_nseg NUMBER;
5100: l_seglist fnd_flex_key_api.segment_list;
5101: l_fftype fnd_flex_key_api.flexfield_type;
5102: l_ffstru fnd_flex_key_api.structure_type;
5103: l_segment_type fnd_flex_key_api.segment_type;
5104: l_locator VARCHAR2(32000);

Line 5101: l_fftype fnd_flex_key_api.flexfield_type;

5097:
5098: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
5099: l_nseg NUMBER;
5100: l_seglist fnd_flex_key_api.segment_list;
5101: l_fftype fnd_flex_key_api.flexfield_type;
5102: l_ffstru fnd_flex_key_api.structure_type;
5103: l_segment_type fnd_flex_key_api.segment_type;
5104: l_locator VARCHAR2(32000);
5105: l_error_exp VARCHAR2(250);

Line 5102: l_ffstru fnd_flex_key_api.structure_type;

5098: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
5099: l_nseg NUMBER;
5100: l_seglist fnd_flex_key_api.segment_list;
5101: l_fftype fnd_flex_key_api.flexfield_type;
5102: l_ffstru fnd_flex_key_api.structure_type;
5103: l_segment_type fnd_flex_key_api.segment_type;
5104: l_locator VARCHAR2(32000);
5105: l_error_exp VARCHAR2(250);
5106: l_structure_list fnd_flex_key_api.structure_list;

Line 5103: l_segment_type fnd_flex_key_api.segment_type;

5099: l_nseg NUMBER;
5100: l_seglist fnd_flex_key_api.segment_list;
5101: l_fftype fnd_flex_key_api.flexfield_type;
5102: l_ffstru fnd_flex_key_api.structure_type;
5103: l_segment_type fnd_flex_key_api.segment_type;
5104: l_locator VARCHAR2(32000);
5105: l_error_exp VARCHAR2(250);
5106: l_structure_list fnd_flex_key_api.structure_list;
5107: l_nstru NUMBER;

Line 5106: l_structure_list fnd_flex_key_api.structure_list;

5102: l_ffstru fnd_flex_key_api.structure_type;
5103: l_segment_type fnd_flex_key_api.segment_type;
5104: l_locator VARCHAR2(32000);
5105: l_error_exp VARCHAR2(250);
5106: l_structure_list fnd_flex_key_api.structure_list;
5107: l_nstru NUMBER;
5108: l_index NUMBER;
5109: l_locid NUMBER;
5110: l_delim VARCHAR2(1);

Line 5118: fnd_flex_key_api.set_session_mode('seed_data');

5114: -- Local array to hold the data for getting the cancatenated segment.
5115: l_segmentarray fnd_flex_ext.segmentarray;
5116: BEGIN
5117:
5118: fnd_flex_key_api.set_session_mode('seed_data');
5119:
5120: -- find flex field type
5121: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
5122:

Line 5121: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');

5117:
5118: fnd_flex_key_api.set_session_mode('seed_data');
5119:
5120: -- find flex field type
5121: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
5122:
5123: -- find flex structure type
5124: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
5125:

Line 5124: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);

5120: -- find flex field type
5121: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
5122:
5123: -- find flex structure type
5124: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
5125:
5126: -- find segment list for the key flex field
5127: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
5128:

Line 5127: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);

5123: -- find flex structure type
5124: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
5125:
5126: -- find segment list for the key flex field
5127: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
5128:
5129: -- find segment delimiter
5130: l_delim := l_ffstru.segment_separator;
5131:

Line 5141: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(l_loop));

5137: -- fetch the corresponding columns from segments array
5138: --
5139: FOR l_loop IN 1..l_nseg LOOP
5140:
5141: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(l_loop));
5142: -- Bug Fix#4747090
5143: --l_segmentarray contains data in the order flexfield is defined. Used in creating cancatenated segments for validation.
5144: l_segmentarray(l_loop) := p_segmentarray(To_number(Substr(l_segment_type.column_name, 8)));
5145: END LOOP;

Line 5183: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

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
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');

Line 5198: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

5194: EXCEPTION
5195:
5196: WHEN OTHERS THEN
5197:
5198: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5199: IF (l_debug = 1) THEN
5200: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5201: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
5202: END IF;

Line 5274: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

5270:
5271: EXCEPTION
5272:
5273: WHEN OTHERS THEN
5274: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5275: IF (l_debug = 1) THEN
5276: inv_log_util.trace('Error in getlocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5277: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
5278: END IF;

Line 5352: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

5348:
5349: EXCEPTION
5350:
5351: WHEN OTHERS THEN
5352: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5353: IF (l_debug = 1) THEN
5354: inv_log_util.trace('Error in getxlocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5355: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
5356: END IF;

Line 5435: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

5431:
5432: EXCEPTION
5433:
5434: WHEN OTHERS THEN
5435: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5436: IF (l_debug = 1) THEN
5437: inv_log_util.trace('Error in getplocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5438: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
5439: END IF;

Line 5518: l_error_exp := substr(fnd_flex_key_api.message(),1,240);

5514:
5515: EXCEPTION
5516:
5517: WHEN OTHERS THEN
5518: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5519: IF (l_debug = 1) THEN
5520: inv_log_util.trace('Error in getxplocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5521: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
5522: END IF;

Line 6473: fnd_flex_key_api.set_session_mode('seed_data');

6469: if ( l_debug is null) then
6470: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6471: end if;
6472:
6473: fnd_flex_key_api.set_session_mode('seed_data');
6474:
6475: FOR l_Line_rec_Type IN AA1 LOOP
6476: BEGIN
6477: savepoint line_validation_svpt;