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 867: kff fnd_flex_key_api.flexfield_type;

863: FUNCTION getacctid(x_acctid OUT NOCOPY NUMBER, p_orgid IN NUMBER, p_rowid IN VARCHAR2)
864: RETURN BOOLEAN
865: IS
866:
867: kff fnd_flex_key_api.flexfield_type;
868: str fnd_flex_key_api.structure_type;
869: seg fnd_flex_key_api.segment_type;
870: seg_list fnd_flex_key_api.segment_list;
871: j number;

Line 868: str fnd_flex_key_api.structure_type;

864: RETURN BOOLEAN
865: IS
866:
867: kff fnd_flex_key_api.flexfield_type;
868: str fnd_flex_key_api.structure_type;
869: seg fnd_flex_key_api.segment_type;
870: seg_list fnd_flex_key_api.segment_list;
871: j number;
872: i number;

Line 869: seg fnd_flex_key_api.segment_type;

865: IS
866:
867: kff fnd_flex_key_api.flexfield_type;
868: str fnd_flex_key_api.structure_type;
869: seg fnd_flex_key_api.segment_type;
870: seg_list fnd_flex_key_api.segment_list;
871: j number;
872: i number;
873: nsegs number;

Line 870: seg_list fnd_flex_key_api.segment_list;

866:
867: kff fnd_flex_key_api.flexfield_type;
868: str fnd_flex_key_api.structure_type;
869: seg fnd_flex_key_api.segment_type;
870: seg_list fnd_flex_key_api.segment_list;
871: j number;
872: i number;
873: nsegs number;
874: l_popul boolean;

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

924: FROM ORG_ORGANIZATION_DEFINITIONS
925: WHERE ORGANIZATION_ID = p_orgid;
926:
927:
928: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
929: str := fnd_flex_key_api.find_structure(kff, l_chart);
930: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
931:
932: /*

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

925: WHERE ORGANIZATION_ID = p_orgid;
926:
927:
928: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
929: str := fnd_flex_key_api.find_structure(kff, l_chart);
930: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
931:
932: /*
933: * When the flexfield is defined, the order the segments are displayed

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

926:
927:
928: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
929: str := fnd_flex_key_api.find_structure(kff, l_chart);
930: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
931:
932: /*
933: * When the flexfield is defined, the order the segments are displayed
934: * and the order of segment columns need not be the same. For example, a

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

936: * The following loop re-arranges the order of the flexfield segments
937: * so that the AOL routine can process it.
938: */
939: for i in 1..nsegs loop
940: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
941: j := 1;
942: while (j <= tmp_seg_arr.count) loop
943: if (seg.column_name = 'SEGMENT' || j) THEN
944: segarray(i) := tmp_seg_arr(j).colvalue;

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

992: FND_MESSAGE.set_name('INV','INV-Database corrupt');
993: FND_MESSAGE.set_token('ROUTINE','getacctid');
994: RETURN FALSE;
995: WHEN OTHERS THEN
996: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
997: IF (l_debug = 1) THEN
998: inv_log_util.trace('Error in getacctid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
999: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
1000: END IF;

Line 1017: l_seglist fnd_flex_key_api.segment_list;

1013: FUNCTION getitemid(x_itemid out NOCOPY NUMBER, p_orgid NUMBER, p_rowid VARCHAR2)
1014: RETURN BOOLEAN
1015: IS
1016: l_nseg NUMBER;
1017: l_seglist fnd_flex_key_api.segment_list;
1018: l_segs1 fnd_flex_ext.segmentarray;
1019: l_fftype fnd_flex_key_api.flexfield_type;
1020: l_ffstru fnd_flex_key_api.structure_type;
1021: l_segment_type fnd_flex_key_api.segment_type;

Line 1019: l_fftype fnd_flex_key_api.flexfield_type;

1015: IS
1016: l_nseg NUMBER;
1017: l_seglist fnd_flex_key_api.segment_list;
1018: l_segs1 fnd_flex_ext.segmentarray;
1019: l_fftype fnd_flex_key_api.flexfield_type;
1020: l_ffstru fnd_flex_key_api.structure_type;
1021: l_segment_type fnd_flex_key_api.segment_type;
1022: -- Local array to hold the data for getting the cancatenated segment.
1023: l_segmentarray fnd_flex_ext.segmentarray;

Line 1020: l_ffstru fnd_flex_key_api.structure_type;

1016: l_nseg NUMBER;
1017: l_seglist fnd_flex_key_api.segment_list;
1018: l_segs1 fnd_flex_ext.segmentarray;
1019: l_fftype fnd_flex_key_api.flexfield_type;
1020: l_ffstru fnd_flex_key_api.structure_type;
1021: l_segment_type fnd_flex_key_api.segment_type;
1022: -- Local array to hold the data for getting the cancatenated segment.
1023: l_segmentarray fnd_flex_ext.segmentarray;
1024: l_itemsegs VARCHAR2(32000);

Line 1021: l_segment_type fnd_flex_key_api.segment_type;

1017: l_seglist fnd_flex_key_api.segment_list;
1018: l_segs1 fnd_flex_ext.segmentarray;
1019: l_fftype fnd_flex_key_api.flexfield_type;
1020: l_ffstru fnd_flex_key_api.structure_type;
1021: l_segment_type fnd_flex_key_api.segment_type;
1022: -- Local array to hold the data for getting the cancatenated segment.
1023: l_segmentarray fnd_flex_ext.segmentarray;
1024: l_itemsegs VARCHAR2(32000);
1025: l_delim VARCHAR2(1);

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

1071: FROM mtl_transactions_interface mti
1072: WHERE mti.rowid = p_rowid;
1073:
1074: -- find flex field type
1075: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MSTK');
1076:
1077: -- find flex structure type
1078: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
1079:

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

1074: -- find flex field type
1075: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MSTK');
1076:
1077: -- find flex structure type
1078: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
1079:
1080: -- find segment list for the key flex field
1081: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1082:

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

1077: -- find flex structure type
1078: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
1079:
1080: -- find segment list for the key flex field
1081: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1082:
1083: -- find segment delimiter
1084: l_delim := l_ffstru.segment_separator;
1085:

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

1084: l_delim := l_ffstru.segment_separator;
1085:
1086: -- get the corresponding column for all segments
1087: FOR l_loop IN 1..l_nseg LOOP
1088: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(l_loop));
1089: -- Bug Fix#4747090
1090: --l_segmentarray contains data in the order flexfield is defined. Used in creating cancatenated segments for validation.
1091: l_segmentarray(l_loop) := l_segs1(To_number(Substr(l_segment_type.column_name, 8)));
1092: END LOOP;

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

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

Line 1133: l_seglist fnd_flex_key_api.segment_list;

1129: FUNCTION getsrcid(x_trxsrc OUT NOCOPY NUMBER, p_srctype IN NUMBER, p_orgid IN NUMBER, p_rowid IN VARCHAR2)
1130: RETURN BOOLEAN
1131: IS
1132: l_nseg NUMBER;
1133: l_seglist fnd_flex_key_api.segment_list;
1134: l_fftype fnd_flex_key_api.flexfield_type;
1135: l_ffstru fnd_flex_key_api.structure_type;
1136: l_segment_type fnd_flex_key_api.segment_type;
1137: l_structure_list fnd_flex_key_api.structure_list;

Line 1134: l_fftype fnd_flex_key_api.flexfield_type;

1130: RETURN BOOLEAN
1131: IS
1132: l_nseg NUMBER;
1133: l_seglist fnd_flex_key_api.segment_list;
1134: l_fftype fnd_flex_key_api.flexfield_type;
1135: l_ffstru fnd_flex_key_api.structure_type;
1136: l_segment_type fnd_flex_key_api.segment_type;
1137: l_structure_list fnd_flex_key_api.structure_list;
1138: l_chart NUMBER;

Line 1135: l_ffstru fnd_flex_key_api.structure_type;

1131: IS
1132: l_nseg NUMBER;
1133: l_seglist fnd_flex_key_api.segment_list;
1134: l_fftype fnd_flex_key_api.flexfield_type;
1135: l_ffstru fnd_flex_key_api.structure_type;
1136: l_segment_type fnd_flex_key_api.segment_type;
1137: l_structure_list fnd_flex_key_api.structure_list;
1138: l_chart NUMBER;
1139: segarray fnd_flex_ext.segmentarray;

Line 1136: l_segment_type fnd_flex_key_api.segment_type;

1132: l_nseg NUMBER;
1133: l_seglist fnd_flex_key_api.segment_list;
1134: l_fftype fnd_flex_key_api.flexfield_type;
1135: l_ffstru fnd_flex_key_api.structure_type;
1136: l_segment_type fnd_flex_key_api.segment_type;
1137: l_structure_list fnd_flex_key_api.structure_list;
1138: l_chart NUMBER;
1139: segarray fnd_flex_ext.segmentarray;
1140: tmp_seg_arr seg_arr_type;

Line 1137: l_structure_list fnd_flex_key_api.structure_list;

1133: l_seglist fnd_flex_key_api.segment_list;
1134: l_fftype fnd_flex_key_api.flexfield_type;
1135: l_ffstru fnd_flex_key_api.structure_type;
1136: l_segment_type fnd_flex_key_api.segment_type;
1137: l_structure_list fnd_flex_key_api.structure_list;
1138: l_chart NUMBER;
1139: segarray fnd_flex_ext.segmentarray;
1140: tmp_seg_arr seg_arr_type;
1141: i NUMBER;

Line 1146: seg fnd_flex_key_api.segment_type;

1142: j NUMBER;
1143: l_app_shortname VARCHAR2(20);
1144: l_struct_number NUMBER;
1145: l_flex_code VARCHAR2(20);
1146: seg fnd_flex_key_api.segment_type;
1147: l_result boolean; -- Added for bug 3346767
1148:
1149: BEGIN
1150: SELECT DSP_SEGMENT1, DSP_SEGMENT2, DSP_SEGMENT3,

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

1193: END IF;
1194: END IF;
1195: END IF;
1196:
1197: l_fftype := fnd_flex_key_api.find_flexfield(l_app_shortname,l_flex_code);
1198: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, l_struct_number);
1199:
1200: -- find segment list for the key flex field
1201: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);

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

1194: END IF;
1195: END IF;
1196:
1197: l_fftype := fnd_flex_key_api.find_flexfield(l_app_shortname,l_flex_code);
1198: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, l_struct_number);
1199:
1200: -- find segment list for the key flex field
1201: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1202:

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

1197: l_fftype := fnd_flex_key_api.find_flexfield(l_app_shortname,l_flex_code);
1198: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, l_struct_number);
1199:
1200: -- find segment list for the key flex field
1201: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
1202:
1203: /*
1204: * When the flexfield is defined, the order the segments are displayed
1205: * and the order of segment columns need not be the same. For example, a

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

1207: * The following loop re-arranges the order of the flexfield segments
1208: * so that the AOL routine can process it.
1209: */
1210: for i in 1..l_nseg loop
1211: seg := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(i));
1212: j := 1;
1213: while (j <= tmp_seg_arr.count) loop
1214: if (seg.column_name = 'SEGMENT' || j) THEN
1215: segarray(i) := tmp_seg_arr(j).colvalue;

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

1264: end if;
1265:
1266: EXCEPTION
1267: WHEN OTHERS THEN
1268: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
1269: IF (l_debug = 1) THEN
1270: inv_log_util.trace('Error in getsrcid : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
1271: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
1272: END IF;

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

2001:
2002:
2003: /* commented logical validations fr inv_globals pre-req*/
2004: IF (l_validate_full) THEN --J-dev
2005: fnd_flex_key_api.set_session_mode('seed_data');
2006: derive_segment_ids(p_header_id, x_return_status ,x_msg_count, x_msg_data);
2007: END IF;
2008: loaderrmsg('INV_INT_TRXACTCODE', 'INV_INT_TRXACTCODE');
2009:

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

4706: -- Function
4707: -- getloc
4708: -- Description
4709: -- Private function to get Locator id using Flex API's
4710: -- Uses FND_FLEX_KEY_API (AFFFKAIS/B.pls) and
4711: -- FND_FLEX_EXT (AFFFEXTS/B.pls)
4712: --
4713: -- Assumes that only Id's are populated in the MTI segments
4714: --

Line 4723: l_seglist fnd_flex_key_api.segment_list;

4719: ******************************************************************/
4720:
4721: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
4722: l_nseg NUMBER;
4723: l_seglist fnd_flex_key_api.segment_list;
4724: l_fftype fnd_flex_key_api.flexfield_type;
4725: l_ffstru fnd_flex_key_api.structure_type;
4726: l_segment_type fnd_flex_key_api.segment_type;
4727: l_locator VARCHAR2(32000);

Line 4724: l_fftype fnd_flex_key_api.flexfield_type;

4720:
4721: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
4722: l_nseg NUMBER;
4723: l_seglist fnd_flex_key_api.segment_list;
4724: l_fftype fnd_flex_key_api.flexfield_type;
4725: l_ffstru fnd_flex_key_api.structure_type;
4726: l_segment_type fnd_flex_key_api.segment_type;
4727: l_locator VARCHAR2(32000);
4728: l_error_exp VARCHAR2(250);

Line 4725: l_ffstru fnd_flex_key_api.structure_type;

4721: FUNCTION getloc(x_locid OUT NOCOPY NUMBER, p_org_id NUMBER, p_locctrl NUMBER, p_segmentarray fnd_flex_ext.segmentarray) return BOOLEAN is
4722: l_nseg NUMBER;
4723: l_seglist fnd_flex_key_api.segment_list;
4724: l_fftype fnd_flex_key_api.flexfield_type;
4725: l_ffstru fnd_flex_key_api.structure_type;
4726: l_segment_type fnd_flex_key_api.segment_type;
4727: l_locator VARCHAR2(32000);
4728: l_error_exp VARCHAR2(250);
4729: l_structure_list fnd_flex_key_api.structure_list;

Line 4726: l_segment_type fnd_flex_key_api.segment_type;

4722: l_nseg NUMBER;
4723: l_seglist fnd_flex_key_api.segment_list;
4724: l_fftype fnd_flex_key_api.flexfield_type;
4725: l_ffstru fnd_flex_key_api.structure_type;
4726: l_segment_type fnd_flex_key_api.segment_type;
4727: l_locator VARCHAR2(32000);
4728: l_error_exp VARCHAR2(250);
4729: l_structure_list fnd_flex_key_api.structure_list;
4730: l_nstru NUMBER;

Line 4729: l_structure_list fnd_flex_key_api.structure_list;

4725: l_ffstru fnd_flex_key_api.structure_type;
4726: l_segment_type fnd_flex_key_api.segment_type;
4727: l_locator VARCHAR2(32000);
4728: l_error_exp VARCHAR2(250);
4729: l_structure_list fnd_flex_key_api.structure_list;
4730: l_nstru NUMBER;
4731: l_index NUMBER;
4732: l_locid NUMBER;
4733: l_delim VARCHAR2(1);

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

4737: -- Local array to hold the data for getting the cancatenated segment.
4738: l_segmentarray fnd_flex_ext.segmentarray;
4739: BEGIN
4740:
4741: fnd_flex_key_api.set_session_mode('seed_data');
4742:
4743: -- find flex field type
4744: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
4745:

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

4740:
4741: fnd_flex_key_api.set_session_mode('seed_data');
4742:
4743: -- find flex field type
4744: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
4745:
4746: -- find flex structure type
4747: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
4748:

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

4743: -- find flex field type
4744: l_fftype := fnd_flex_key_api.find_flexfield('INV', 'MTLL');
4745:
4746: -- find flex structure type
4747: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
4748:
4749: -- find segment list for the key flex field
4750: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
4751:

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

4746: -- find flex structure type
4747: l_ffstru := fnd_flex_key_api.find_structure(l_fftype, 101);
4748:
4749: -- find segment list for the key flex field
4750: fnd_flex_key_api.get_segments(l_fftype, l_ffstru, TRUE, l_nseg, l_seglist);
4751:
4752: -- find segment delimiter
4753: l_delim := l_ffstru.segment_separator;
4754:

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

4760: -- fetch the corresponding columns from segments array
4761: --
4762: FOR l_loop IN 1..l_nseg LOOP
4763:
4764: l_segment_type := fnd_flex_key_api.find_segment(l_fftype, l_ffstru, l_seglist(l_loop));
4765: -- Bug Fix#4747090
4766: --l_segmentarray contains data in the order flexfield is defined. Used in creating cancatenated segments for validation.
4767: l_segmentarray(l_loop) := p_segmentarray(To_number(Substr(l_segment_type.column_name, 8)));
4768: END LOOP;

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

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

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

4817: EXCEPTION
4818:
4819: WHEN OTHERS THEN
4820:
4821: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
4822: IF (l_debug = 1) THEN
4823: inv_log_util.trace('Error in getloc : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
4824: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
4825: END IF;

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

4893:
4894: EXCEPTION
4895:
4896: WHEN OTHERS THEN
4897: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
4898: IF (l_debug = 1) THEN
4899: inv_log_util.trace('Error in getlocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
4900: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
4901: END IF;

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

4971:
4972: EXCEPTION
4973:
4974: WHEN OTHERS THEN
4975: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
4976: IF (l_debug = 1) THEN
4977: inv_log_util.trace('Error in getxlocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
4978: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
4979: END IF;

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

5053:
5054: EXCEPTION
5055:
5056: WHEN OTHERS THEN
5057: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5058: IF (l_debug = 1) THEN
5059: inv_log_util.trace('Error in getplocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5060: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
5061: END IF;

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

5136:
5137: EXCEPTION
5138:
5139: WHEN OTHERS THEN
5140: l_error_exp := substr(fnd_flex_key_api.message(),1,240);
5141: IF (l_debug = 1) THEN
5142: inv_log_util.trace('Error in getxplocId : ' || l_error_exp, 'INV_TXN_MANAGER_GRP','1');
5143: inv_log_util.trace('Error:'||substr(sqlerrm,1,250),'INV_TXN_MANAGER_GRP',1);
5144: END IF;

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

6090: if ( l_debug is null) then
6091: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6092: end if;
6093:
6094: fnd_flex_key_api.set_session_mode('seed_data');
6095:
6096: FOR l_Line_rec_Type IN AA1 LOOP
6097: BEGIN
6098: savepoint line_validation_svpt;