18: WHEN NO_DATA_FOUND THEN
19: return FALSE;
20: WHEN OTHERS THEN
21: AP_WEB_DB_UTIL_PKG.RaiseException('GetWebEnabledTemplatesCursor');
22: APP_EXCEPTION.RAISE_EXCEPTION;
23: return FALSE;
24: END GetWebEnabledTemplatesCursor;
25:
26: --------------------------------------------------------------------------------
51: WHEN NO_DATA_FOUND THEN
52: return FALSE;
53: WHEN OTHERS THEN
54: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpTypesOfTemplateCursor');
55: APP_EXCEPTION.RAISE_EXCEPTION;
56: return FALSE;
57: END GetExpTypesOfTemplateCursor;
58:
59: --------------------------------------------------------------------------------
73: WHEN NO_DATA_FOUND THEN
74: return FALSE;
75: WHEN OTHERS THEN
76: AP_WEB_DB_UTIL_PKG.RaiseException('GetAllExpenseTypesCursor');
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: return FALSE;
79: END GetAllExpenseTypesCursor;
80:
81: --------------------------------------------------------------------------------
108: WHEN NO_DATA_FOUND THEN
109: return FALSE;
110: WHEN OTHERS THEN
111: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpTypesCursor');
112: APP_EXCEPTION.RAISE_EXCEPTION;
113: return FALSE;
114: END GetExpTypesCursor;
115:
116: --------------------------------------------------------------------------------
140: WHEN NO_DATA_FOUND THEN
141: return FALSE;
142: WHEN OTHERS THEN
143: AP_WEB_DB_UTIL_PKG.RaiseException('GetWebExpTypesCursor');
144: APP_EXCEPTION.RAISE_EXCEPTION;
145: return FALSE;
146: END GetWebExpTypesCursor;
147:
148:
162: WHEN NO_DATA_FOUND THEN
163: return FALSE;
164: WHEN OTHERS THEN
165: AP_WEB_DB_UTIL_PKG.RaiseException('GetJustifReqdExpTypesCursor');
166: APP_EXCEPTION.RAISE_EXCEPTION;
167: return FALSE;
168: END GetJustifReqdExpTypesCursor;
169:
170:
190: WHEN NO_DATA_FOUND THEN
191: return FALSE;
192: WHEN OTHERS THEN
193: AP_WEB_DB_UTIL_PKG.RaiseException('GetTemplateName');
194: APP_EXCEPTION.RAISE_EXCEPTION;
195: return FALSE;
196: END GetTemplateName;
197:
198:
237: WHEN NO_DATA_FOUND THEN
238: return FALSE;
239: WHEN OTHERS THEN
240: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpTemplateId');
241: APP_EXCEPTION.RAISE_EXCEPTION;
242: return FALSE;
243: END GetExpTemplateId;
244:
245: -------------------------------------------------------------------
259: WHEN NO_DATA_FOUND THEN
260: return FALSE;
261: WHEN OTHERS THEN
262: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpTypePrompt');
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: return FALSE;
265: END GetExpTypePrompt;
266:
267: -------------------------------------------------------------------
280: WHEN NO_DATA_FOUND THEN
281: return FALSE;
282: WHEN OTHERS THEN
283: AP_WEB_DB_UTIL_PKG.RaiseException('GetPersonalParamID');
284: APP_EXCEPTION.RAISE_EXCEPTION;
285: return FALSE;
286: END GetPersonalParamID;
287:
288: -------------------------------------------------------------------
314: WHEN NO_DATA_FOUND THEN
315: return FALSE;
316: WHEN OTHERS THEN
317: AP_WEB_DB_UTIL_PKG.RaiseException('GetExpTypeInfo', l_debug_info);
318: APP_EXCEPTION.RAISE_EXCEPTION;
319: return FALSE;
320: END GetExpTypeInfo;
321:
322:
369: WHEN NO_DATA_FOUND THEN
370: return 'N';
371: WHEN OTHERS THEN
372: AP_WEB_DB_UTIL_PKG.RaiseException('IsExpTemplateWebEnabled');
373: APP_EXCEPTION.RAISE_EXCEPTION;
374: return 'N';
375: END IsExpTemplateWebEnabled;
376:
377: -------------------------------------------------------------------
392: p_count := 0;
393: return FALSE;
394: WHEN OTHERS THEN
395: AP_WEB_DB_UTIL_PKG.RaiseException('GetNumWebEnabledExpTemplates');
396: APP_EXCEPTION.RAISE_EXCEPTION;
397: return FALSE;
398: END GetNumWebEnabledExpTemplates;
399:
400:
428: WHEN NO_DATA_FOUND THEN
429: RETURN FALSE;
430: WHEN OTHERS THEN
431: AP_WEB_DB_UTIL_PKG.RaiseException('Get_ItemDesc_LookupCode');
432: APP_EXCEPTION.RAISE_EXCEPTION;
433: return FALSE;
434:
435: END Get_ItemDesc_LookupCode;
436:
454: p_default_template_id := null;
455: return FALSE;
456: WHEN OTHERS THEN
457: AP_WEB_DB_UTIL_PKG.RaiseException('GetDefaultTemplateId');
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: return FALSE;
460: END GetDefaultTemplateId;
461:
462:
503: 'IsCustomCalculateEnabled');
504: FND_MESSAGE.SET_TOKEN('PARAMETERS',
505: 'None passed.');
506: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
507: APP_EXCEPTION.RAISE_EXCEPTION;
508: ELSE
509: -- Do not need to set the token since it has been done in the
510: -- child process
511: RAISE;
541: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
542: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
543: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetRequireReceiptAmt');
544: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
545: APP_EXCEPTION.RAISE_EXCEPTION;
546: ELSE
547: -- Do not need to set the token since it has been done in the
548: -- child process
549: RAISE;
565: WHEN NO_DATA_FOUND THEN
566: return FALSE;
567: WHEN OTHERS THEN
568: AP_WEB_DB_UTIL_PKG.RaiseException('GetRoundingParamID');
569: APP_EXCEPTION.RAISE_EXCEPTION;
570: return FALSE;
571: END GetRoundingParamID;
572: /* jrautiai ADJ Fix End */
573: