222: FND_VSET.get_value_end(P_ValueSetInfo);
223: EXCEPTION
224: WHEN OTHERS THEN
225: BEGIN
226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
223: EXCEPTION
224: WHEN OTHERS THEN
225: BEGIN
226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
231: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
224: WHEN OTHERS THEN
225: BEGIN
226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
231: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
232: END;
225: BEGIN
226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
231: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
232: END;
233:
226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
231: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
232: END;
233:
234: END GetIndepSegmentEnabledValues;
227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
229: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
230: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
231: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
232: END;
233:
234: END GetIndepSegmentEnabledValues;
235:
421: RETURN V_DefaultValue;
422: EXCEPTION
423: WHEN OTHERS THEN
424: BEGIN
425: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
426: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
427: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
428: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
422: EXCEPTION
423: WHEN OTHERS THEN
424: BEGIN
425: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
426: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
427: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
428: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
430: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
423: WHEN OTHERS THEN
424: BEGIN
425: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
426: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
427: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
428: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
430: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
431: END;
424: BEGIN
425: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
426: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
427: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
428: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
430: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
431: END;
432:
425: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
426: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
427: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
428: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
430: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
431: END;
432:
433: END GetSegmentDefault;
426: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
427: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
428: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
429: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
430: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
431: END;
432:
433: END GetSegmentDefault;
434:
662: END IF;
663: EXCEPTION
664: WHEN OTHERS THEN
665: BEGIN
666: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
667: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
668: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
669: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
663: EXCEPTION
664: WHEN OTHERS THEN
665: BEGIN
666: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
667: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
668: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
669: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
671: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
664: WHEN OTHERS THEN
665: BEGIN
666: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
667: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
668: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
669: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
671: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
672: END;
665: BEGIN
666: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
667: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
668: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
669: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
671: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
672: END;
673:
666: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
667: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
668: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
669: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
671: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
672: END;
673:
674: END GetSegmentType;
667: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
668: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
669: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
671: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
672: END;
673:
674: END GetSegmentType;
675:
725:
726: EXCEPTION
727: WHEN OTHERS THEN
728: BEGIN
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
732: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
733: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
726: EXCEPTION
727: WHEN OTHERS THEN
728: BEGIN
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
732: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
733: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
734: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
727: WHEN OTHERS THEN
728: BEGIN
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
732: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
733: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
734: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
735: END;
728: BEGIN
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
732: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
733: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
734: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
735: END;
736:
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
732: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
733: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
734: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
735: END;
736:
737: END GenSegmentDefaultValue;
730: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
732: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
733: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
734: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
735: END;
736:
737: END GenSegmentDefaultValue;
738:
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: BEGIN
1126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1129: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: BEGIN
1126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1129: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1131: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1124: WHEN OTHERS THEN
1125: BEGIN
1126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1129: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1131: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1132: END;
1125: BEGIN
1126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1129: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1131: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1132: END;
1133:
1126: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1129: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1131: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1132: END;
1133:
1134: END PopulateCustomDefaultValues;
1127: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1128: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1129: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1131: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1132: END;
1133:
1134: END PopulateCustomDefaultValues;
1135:
1186:
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: BEGIN
1190: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1192: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1193: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: BEGIN
1190: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1192: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1193: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1195: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1188: WHEN OTHERS THEN
1189: BEGIN
1190: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1192: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1193: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1195: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1196: END;
1189: BEGIN
1190: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1192: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1193: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1195: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1196: END;
1197:
1190: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1192: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1193: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1195: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1196: END;
1197:
1198: END PopulatePseudoDefaultValues;
1191: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1192: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
1193: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
1194: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
1195: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1196: END;
1197:
1198: END PopulatePseudoDefaultValues;
1199:
1250: END IF;
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1255: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1256: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1257: l_curr_calling_sequence);
1258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1255: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1256: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1257: l_curr_calling_sequence);
1258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1259: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1255: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1256: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1257: l_curr_calling_sequence);
1258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1259: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1260: END GetExpenseLineDFlexInfo;
1254: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1255: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1256: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1257: l_curr_calling_sequence);
1258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1259: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1260: END GetExpenseLineDFlexInfo;
1261:
1262: -----------------------------------------------------------------------------
1255: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1256: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1257: l_curr_calling_sequence);
1258: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1259: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1260: END GetExpenseLineDFlexInfo;
1261:
1262: -----------------------------------------------------------------------------
1263: PROCEDURE GetDFlexContextSegments(p_flexfield IN FND_DFLEX.DFLEX_R,
1278: p_segments, TRUE);
1279:
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1285: l_curr_calling_sequence);
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1279:
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1285: l_curr_calling_sequence);
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1287: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1285: l_curr_calling_sequence);
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1287: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1288: END GetDFlexContextSegments;
1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1285: l_curr_calling_sequence);
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1287: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1288: END GetDFlexContextSegments;
1289:
1290:
1283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1285: l_curr_calling_sequence);
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1287: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1288: END GetDFlexContextSegments;
1289:
1290:
1291: -----------------------------------------------------------------------------
1312: p_index := NULL;
1313:
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1319: l_curr_calling_sequence);
1320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1313:
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1319: l_curr_calling_sequence);
1320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1321: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1319: l_curr_calling_sequence);
1320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1321: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1322: END GetDFlexContextIndex;
1316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1319: l_curr_calling_sequence);
1320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1321: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1322: END GetDFlexContextIndex;
1323:
1324: -----------------------------------------------------------------------------
1317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1319: l_curr_calling_sequence);
1320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1321: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1322: END GetDFlexContextIndex;
1323:
1324: -----------------------------------------------------------------------------
1325: PROCEDURE GetIndexRefOrderedArray(p_sequence_array IN FND_DFLEX.SEQUENCE_A,
1352: END LOOP;
1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1357: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1359: l_curr_calling_sequence);
1360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1357: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1359: l_curr_calling_sequence);
1360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1361: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1357: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1359: l_curr_calling_sequence);
1360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1361: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1362: END GetIndexRefOrderedArray;
1356: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1357: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1359: l_curr_calling_sequence);
1360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1361: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1362: END GetIndexRefOrderedArray;
1363:
1364: -----------------------------------------------------------------------------
1357: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1358: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1359: l_curr_calling_sequence);
1360: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1361: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1362: END GetIndexRefOrderedArray;
1363:
1364: -----------------------------------------------------------------------------
1365: FUNCTION GetNumOfEnabledSegments(P_Segments IN FND_DFLEX.SEGMENTS_DR) RETURN NUMBER
1383: RETURN V_NumOfEnabledSegments;
1384:
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1388: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1389: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1390: l_curr_calling_sequence);
1391: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1384:
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1388: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1389: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1390: l_curr_calling_sequence);
1391: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1392: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1388: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1389: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1390: l_curr_calling_sequence);
1391: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1392: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1393: END GetNumOfEnabledSegments;
1387: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1388: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1389: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1390: l_curr_calling_sequence);
1391: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1392: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1393: END GetNumOfEnabledSegments;
1394:
1395: ---------------------------------------------------------------------------
1388: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1389: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1390: l_curr_calling_sequence);
1391: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1392: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1393: END GetNumOfEnabledSegments;
1394:
1395: ---------------------------------------------------------------------------
1396: PROCEDURE GetReceiptCustomFields(
1509: END;
1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1516: l_curr_calling_sequence);
1517: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1516: l_curr_calling_sequence);
1517: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1518: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1516: l_curr_calling_sequence);
1517: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1518: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1519: END GetReceiptCustomFields;
1513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1516: l_curr_calling_sequence);
1517: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1518: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1519: END GetReceiptCustomFields;
1520:
1521: ---------------------------------------------------------------------------
1514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1516: l_curr_calling_sequence);
1517: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1518: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1519: END GetReceiptCustomFields;
1520:
1521: ---------------------------------------------------------------------------
1522: PROCEDURE PropogateReceiptCustFldsInfo(
1635: END;
1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1640: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1641: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1642: l_curr_calling_sequence);
1643: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1640: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1641: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1642: l_curr_calling_sequence);
1643: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1644: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1640: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1641: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1642: l_curr_calling_sequence);
1643: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1644: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1645: END PropogateReceiptCustFldsInfo;
1639: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1640: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1641: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1642: l_curr_calling_sequence);
1643: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1644: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1645: END PropogateReceiptCustFldsInfo;
1646:
1647: ---------------------------------------------------------------------------
1640: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1641: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1642: l_curr_calling_sequence);
1643: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1644: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1645: END PropogateReceiptCustFldsInfo;
1646:
1647: ---------------------------------------------------------------------------
1648: PROCEDURE AssocCustFieldPromptsToValues(
1699:
1700: END LOOP;
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1704: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1705: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1706: l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1700: END LOOP;
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1704: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1705: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1706: l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1708: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1704: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1705: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1706: l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1708: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1709: END AssocCustFieldPromptsToValues;
1703: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1704: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1705: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1706: l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1708: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1709: END AssocCustFieldPromptsToValues;
1710:
1711: ---------------------------------------------------------------------------
1704: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1705: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1706: l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1708: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1709: END AssocCustFieldPromptsToValues;
1710:
1711: ---------------------------------------------------------------------------
1712: FUNCTION GetCustomFieldValue(p_prompt IN VARCHAR2,
1726: END LOOP;
1727:
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1731: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1732: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1733: l_curr_calling_sequence);
1734: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1727:
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1731: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1732: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1733: l_curr_calling_sequence);
1734: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1735: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1731: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1732: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1733: l_curr_calling_sequence);
1734: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1735: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1736: END GetCustomFieldValue;
1730: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1731: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1732: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1733: l_curr_calling_sequence);
1734: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1735: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1736: END GetCustomFieldValue;
1737:
1738: ------------------------------------------------------------------------------
1731: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1732: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1733: l_curr_calling_sequence);
1734: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1735: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1736: END GetCustomFieldValue;
1737:
1738: ------------------------------------------------------------------------------
1739: PROCEDURE ProcessDFlexError(
1780: END IF;
1781:
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1785: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1786: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1787: l_curr_calling_sequence);
1788: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1781:
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1785: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1786: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1787: l_curr_calling_sequence);
1788: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1789: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1782: EXCEPTION
1783: WHEN OTHERS THEN
1784: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1785: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1786: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1787: l_curr_calling_sequence);
1788: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1789: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1790: END ProcessDFlexError;
1784: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1785: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1786: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1787: l_curr_calling_sequence);
1788: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1789: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1790: END ProcessDFlexError;
1791:
1792: ------------------------------------------------------------------------------
1785: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1786: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1787: l_curr_calling_sequence);
1788: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1789: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1790: END ProcessDFlexError;
1791:
1792: ------------------------------------------------------------------------------
1793: PROCEDURE CoreValidateDFlexValues(
1860:
1861:
1862: EXCEPTION
1863: WHEN OTHERS THEN
1864: FND_MESSAGE.SET_NAME('SQLAemacs P','AP_DEBUG');
1865: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1866: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1867: l_curr_calling_sequence);
1868: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1861:
1862: EXCEPTION
1863: WHEN OTHERS THEN
1864: FND_MESSAGE.SET_NAME('SQLAemacs P','AP_DEBUG');
1865: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1866: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1867: l_curr_calling_sequence);
1868: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1869: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1862: EXCEPTION
1863: WHEN OTHERS THEN
1864: FND_MESSAGE.SET_NAME('SQLAemacs P','AP_DEBUG');
1865: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1866: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1867: l_curr_calling_sequence);
1868: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1869: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1870: END CoreValidateDFlexValues;
1864: FND_MESSAGE.SET_NAME('SQLAemacs P','AP_DEBUG');
1865: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1866: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1867: l_curr_calling_sequence);
1868: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1869: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1870: END CoreValidateDFlexValues;
1871:
1872: ------------------------------------------------------------------------------
1865: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1866: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1867: l_curr_calling_sequence);
1868: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1869: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1870: END CoreValidateDFlexValues;
1871:
1872: ------------------------------------------------------------------------------
1873: PROCEDURE ValidateDFlexValues(
1978:
1979:
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1983: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1984: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1985: l_curr_calling_sequence);
1986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1979:
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1983: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1984: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1985: l_curr_calling_sequence);
1986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1987: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1980: EXCEPTION
1981: WHEN OTHERS THEN
1982: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1983: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1984: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1985: l_curr_calling_sequence);
1986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1987: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1988: END ValidateDFlexValues;
1982: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1983: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1984: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1985: l_curr_calling_sequence);
1986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1987: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1988: END ValidateDFlexValues;
1989:
1990: -----------------------------------------------------------------------------
1983: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1984: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1985: l_curr_calling_sequence);
1986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1987: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
1988: END ValidateDFlexValues;
1989:
1990: -----------------------------------------------------------------------------
1991: PROCEDURE PopulateExpTypeInLineRec(p_exp_line_info IN OUT NOCOPY ExpReportLineRec)
2000: p_exp_line_info.expense_type := l_exp_prompt;
2001: END IF;
2002: EXCEPTION
2003: WHEN OTHERS THEN
2004: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2005: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2006: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2007: l_curr_calling_sequence);
2008: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2001: END IF;
2002: EXCEPTION
2003: WHEN OTHERS THEN
2004: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2005: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2006: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2007: l_curr_calling_sequence);
2008: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2009: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2002: EXCEPTION
2003: WHEN OTHERS THEN
2004: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2005: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2006: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2007: l_curr_calling_sequence);
2008: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2009: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2010: END PopulateExpTypeInLineRec;
2004: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2005: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2006: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2007: l_curr_calling_sequence);
2008: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2009: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2010: END PopulateExpTypeInLineRec;
2011:
2012: ------------------------------------------------------------------------------
2005: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2006: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2007: l_curr_calling_sequence);
2008: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2009: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2010: END PopulateExpTypeInLineRec;
2011:
2012: ------------------------------------------------------------------------------
2013: PROCEDURE PopulateCustomFieldsInfo(
2135: END IF; -- l_context_index IS NOT NULL
2136:
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2142: l_curr_calling_sequence);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2136:
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2142: l_curr_calling_sequence);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2144: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2142: l_curr_calling_sequence);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2144: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2145: END PopulateCustomFieldsInfo;
2139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2142: l_curr_calling_sequence);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2144: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2145: END PopulateCustomFieldsInfo;
2146:
2147:
2140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2142: l_curr_calling_sequence);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2144: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2145: END PopulateCustomFieldsInfo;
2146:
2147:
2148:
2266: END IF;
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2273: l_curr_calling_sequence);
2274: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2273: l_curr_calling_sequence);
2274: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2275: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2273: l_curr_calling_sequence);
2274: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2275: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2276: END ValidateReceiptCustomFields;
2270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2273: l_curr_calling_sequence);
2274: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2275: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2276: END ValidateReceiptCustomFields;
2277:
2278: ----------------------------------------------------------------------------
2271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2273: l_curr_calling_sequence);
2274: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2275: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2276: END ValidateReceiptCustomFields;
2277:
2278: ----------------------------------------------------------------------------
2279: PROCEDURE PopulateCustomFieldsInfoAll(
2376: END LOOP;
2377:
2378: EXCEPTION
2379: WHEN OTHERS THEN
2380: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2383: l_curr_calling_sequence);
2384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2377:
2378: EXCEPTION
2379: WHEN OTHERS THEN
2380: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2383: l_curr_calling_sequence);
2384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2385: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2378: EXCEPTION
2379: WHEN OTHERS THEN
2380: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2383: l_curr_calling_sequence);
2384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2385: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2386: END PopulateCustomFieldsInfoAll;
2380: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2383: l_curr_calling_sequence);
2384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2385: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2386: END PopulateCustomFieldsInfoAll;
2387:
2388:
2381: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2382: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2383: l_curr_calling_sequence);
2384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2385: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
2386: END PopulateCustomFieldsInfoAll;
2387:
2388:
2389: PROCEDURE SetExpReportLineInfo(P_ExpReportLineInfo OUT NOCOPY ExpReportLineRec,
2452:
2453: EXCEPTION
2454: WHEN OTHERS THEN
2455: BEGIN
2456: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2457: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2458: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2459: current_calling_sequence);
2460: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2453: EXCEPTION
2454: WHEN OTHERS THEN
2455: BEGIN
2456: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2457: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2458: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2459: current_calling_sequence);
2460: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2461: 'amount = ' || P_amount ||
2454: WHEN OTHERS THEN
2455: BEGIN
2456: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2457: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2458: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2459: current_calling_sequence);
2460: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2461: 'amount = ' || P_amount ||
2462: 'currency_code = ' || P_currency_code ||
2456: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2457: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2458: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2459: current_calling_sequence);
2460: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2461: 'amount = ' || P_amount ||
2462: 'currency_code = ' || P_currency_code ||
2463: 'receipt_amount = ' || P_receipt_amount ||
2464: 'rate = ' || P_rate ||
2463: 'receipt_amount = ' || P_receipt_amount ||
2464: 'rate = ' || P_rate ||
2465: 'parameter_id = ' || P_parameter_id
2466: );
2467: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2468: APP_EXCEPTION.RAISE_EXCEPTION;
2469: END;
2470:
2471: END SetExpReportLineInfo;
2510:
2511: EXCEPTION
2512: WHEN OTHERS THEN
2513: BEGIN
2514: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2515: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2516: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2517: current_calling_sequence);
2518: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2511: EXCEPTION
2512: WHEN OTHERS THEN
2513: BEGIN
2514: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2515: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2516: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2517: current_calling_sequence);
2518: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2519: 'employee_id = ' || P_employee_id
2512: WHEN OTHERS THEN
2513: BEGIN
2514: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2515: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2516: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2517: current_calling_sequence);
2518: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2519: 'employee_id = ' || P_employee_id
2520: );
2514: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2515: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2516: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2517: current_calling_sequence);
2518: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2519: 'employee_id = ' || P_employee_id
2520: );
2521: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2522: APP_EXCEPTION.RAISE_EXCEPTION;
2517: current_calling_sequence);
2518: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2519: 'employee_id = ' || P_employee_id
2520: );
2521: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2522: APP_EXCEPTION.RAISE_EXCEPTION;
2523: END;
2524:
2525: