59: WHEN NO_DATA_FOUND THEN
60: RETURN FALSE;
61:
62: WHEN OTHERS THEN
63: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCurrNameForCurrCode' );
64: APP_EXCEPTION.RAISE_EXCEPTION;
65: RETURN FALSE;
66: END GetCurrNameForCurrCode;
67:
83: WHEN NO_DATA_FOUND THEN
84: RETURN FALSE;
85:
86: WHEN OTHERS THEN
87: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetBaseCurrInfo' );
88: APP_EXCEPTION.RAISE_EXCEPTION;
89: RETURN FALSE;
90:
91: END GetBaseCurrInfo;
109: WHEN NO_DATA_FOUND THEN
110: RETURN FALSE;
111:
112: WHEN OTHERS THEN
113: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSOB' );
114: APP_EXCEPTION.RAISE_EXCEPTION;
115: RETURN FALSE;
116:
117: END GetSOB;
135: WHEN NO_DATA_FOUND THEN
136: RETURN FALSE;
137:
138: WHEN OTHERS THEN
139: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetCOAOfSOB' );
140: APP_EXCEPTION.RAISE_EXCEPTION;
141: RETURN FALSE;
142:
143: END GetCOAofSOB;
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: RETURN FALSE;
170: WHEN OTHERS THEN
171: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetAPSysCUrrencySetupInfo' );
172: APP_EXCEPTION.RAISE_EXCEPTION;
173: RETURN FALSE;
174:
175: END GetAPSysCurrencySetupInfo;
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202: null;
203: WHEN OTHERS THEN
204: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDefaultExchange' );
205: APP_EXCEPTION.RAISE_EXCEPTION;
206: END;
207:
208: WHEN OTHERS THEN
205: APP_EXCEPTION.RAISE_EXCEPTION;
206: END;
207:
208: WHEN OTHERS THEN
209: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDefaultExchange' );
210: APP_EXCEPTION.RAISE_EXCEPTION;
211:
212: END GetDefaultExchange;
213:
301: WHEN NO_DATA_FOUND THEN
302: RETURN FALSE;
303:
304: WHEN OTHERS THEN
305: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorInfoOfEmp' );
306: APP_EXCEPTION.RAISE_EXCEPTION;
307: RETURN FALSE;
308:
309: END GetVendorInfoOfEmp;
332: WHEN NO_DATA_FOUND THEN
333: RETURN FALSE;
334:
335: WHEN OTHERS THEN
336: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorAWTSetupForExpRpt' );
337: APP_EXCEPTION.RAISE_EXCEPTION;
338: RETURN FALSE;
339:
340: END GetVendorAWTSetupForExpRpt;
358: WHEN NO_DATA_FOUND THEN
359: RETURN FALSE;
360:
361: WHEN OTHERS THEN
362: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorID' );
363: APP_EXCEPTION.RAISE_EXCEPTION;
364: RETURN FALSE;
365: END GetVendorID;
366:
381: EXCEPTION
382: WHEN NO_DATA_FOUND THEN
383: RETURN FALSE;
384: WHEN OTHERS THEN
385: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorSitesCodeCombID' );
386: APP_EXCEPTION.RAISE_EXCEPTION;
387: RETURN FALSE;
388: END GetVendorSitesCodeCombID;
389:
404: EXCEPTION
405: WHEN NO_DATA_FOUND THEN
406: RETURN FALSE;
407: WHEN OTHERS THEN
408: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorCodeCombID' );
409: APP_EXCEPTION.RAISE_EXCEPTION;
410: RETURN FALSE;
411: END GetVendorCodeCombID;
412:
430: WHEN NO_DATA_FOUND THEN
431: RETURN FALSE;
432:
433: WHEN OTHERS THEN
434: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetPayGroupLookupCode' );
435: APP_EXCEPTION.RAISE_EXCEPTION;
436: RETURN FALSE;
437: END GetPayGroupLookupCode;
438:
451: EXCEPTION
452: WHEN NO_DATA_FOUND THEN
453: return FALSE;
454: WHEN OTHERS THEN
455: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextInvoiceId');
456: APP_EXCEPTION.RAISE_EXCEPTION;
457: return FALSE;
458: END GetNextInvoiceId;
459:
469: EXCEPTION
470: WHEN NO_DATA_FOUND THEN
471: return FALSE;
472: WHEN OTHERS THEN
473: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextInvoiceLineId');
474: APP_EXCEPTION.RAISE_EXCEPTION;
475: return FALSE;
476: END GetNextInvoiceLineId;
477:
594: WHEN NO_DATA_FOUND THEN
595: RETURN FALSE;
596:
597: WHEN OTHERS THEN
598: AP_WEB_DB_UTIL_PKG.RaiseException( 'ApproverHasAuthority');
599: APP_EXCEPTION.RAISE_EXCEPTION;
600: return FALSE;
601:
602: END ApproverHasAuthority;
739: p_valid := FALSE;
740: RETURN FALSE;
741:
742: WHEN OTHERS THEN
743: AP_WEB_DB_UTIL_PKG.RaiseException( 'CostCenterValid' );
744: APP_EXCEPTION.RAISE_EXCEPTION;
745: return FALSE;
746:
747: END CostCenterValid;
917:
918: RETURN TRUE;
919: EXCEPTION
920: WHEN AP_WEB_OA_MAINFLOW_PKG.G_EXC_ERROR THEN
921: AP_WEB_DB_UTIL_PKG.RaiseException(nvl(FND_MESSAGE.Get,l_debug_info));
922: APP_EXCEPTION.RAISE_EXCEPTION;
923: return FALSE;
924: WHEN OTHERS THEN
925: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpenseClearingCCID' );
921: AP_WEB_DB_UTIL_PKG.RaiseException(nvl(FND_MESSAGE.Get,l_debug_info));
922: APP_EXCEPTION.RAISE_EXCEPTION;
923: return FALSE;
924: WHEN OTHERS THEN
925: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpenseClearingCCID' );
926: APP_EXCEPTION.RAISE_EXCEPTION;
927: return FALSE;
928:
929: END GetExpenseClearingCCID;
943: WHEN NO_DATA_FOUND THEN
944: RETURN FALSE;
945:
946: WHEN OTHERS THEN
947: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetRoundingErrorCCID' );
948: APP_EXCEPTION.RAISE_EXCEPTION;
949: return FALSE;
950:
951: END GetRoundingErrorCCID;
985: WHEN NO_DATA_FOUND THEN
986: RETURN FALSE;
987:
988: WHEN OTHERS THEN
989: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetAvailablePrepayments' );
990: APP_EXCEPTION.RAISE_EXCEPTION;
991: return FALSE;
992:
993: END GetAvailablePrepayments;
1069: WHEN NO_DATA_FOUND THEN
1070: RETURN FALSE;
1071:
1072: WHEN OTHERS THEN
1073: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateInvoiceInterface' );
1074: APP_EXCEPTION.RAISE_EXCEPTION;
1075: return FALSE;
1076:
1077: END InsertInvoiceInterface;
1120: WHEN NO_DATA_FOUND THEN
1121: RETURN FALSE;
1122:
1123: WHEN OTHERS THEN
1124: AP_WEB_DB_UTIL_PKG.RaiseException( 'InsertInvoiceLinesInerface' );
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: return FALSE;
1127:
1128: END InsertInvoiceLinesInterface;
1157: WHEN NO_DATA_FOUND THEN
1158: RETURN FALSE;
1159:
1160: WHEN OTHERS THEN
1161: AP_WEB_DB_UTIL_PKG.RaiseException( 'IsTaxCodeWebEnabled' );
1162: APP_EXCEPTION.RAISE_EXCEPTION;
1163: return FALSE;
1164:
1165: END IsTaxCodeWebEnabled;
1178:
1179: EXCEPTION
1180:
1181: WHEN OTHERS THEN
1182: AP_WEB_DB_UTIL_PKG.RaiseException( 'AP_WEB_DB_AP_INT_PKG.GenTaxFunctions' );
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184:
1185: END GenTaxFunctions;
1186:
1209: WHEN NO_DATA_FOUND THEN
1210: RETURN FALSE;
1211:
1212: WHEN OTHERS THEN
1213: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetInvoiceAmt' );
1214: APP_EXCEPTION.RAISE_EXCEPTION;
1215: return FALSE;
1216:
1217: END GetInvoiceAmt;
1233: EXCEPTION
1234: WHEN NO_DATA_FOUND THEN
1235: return FALSE;
1236: WHEN OTHERS THEN
1237: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetInvoiceAmount' );
1238: APP_EXCEPTION.RAISE_EXCEPTION;
1239: return FALSE;
1240:
1241: END SetInvoiceAmount;
1262: WHEN NO_DATA_FOUND THEN
1263: RETURN FALSE;
1264:
1265: WHEN OTHERS THEN
1266: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVatCode' );
1267: APP_EXCEPTION.RAISE_EXCEPTION;
1268: return FALSE;
1269:
1270: END GetVatCode;
1291: WHEN NO_DATA_FOUND THEN
1292: RETURN FALSE;
1293:
1294: WHEN OTHERS THEN
1295: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTaxCodeID' );
1296: APP_EXCEPTION.RAISE_EXCEPTION;
1297: return FALSE;
1298:
1299: END GetTaxCodeID;
1325: WHEN NO_DATA_FOUND THEN
1326: RETURN FALSE;
1327:
1328: WHEN OTHERS THEN
1329: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTaxCodeID' );
1330: APP_EXCEPTION.RAISE_EXCEPTION;
1331: return FALSE;
1332:
1333: END GetTaxCodeID;
1396: return l_cc_exist;
1397:
1398: EXCEPTION
1399: when others then
1400: AP_WEB_DB_UTIL_PKG.RaiseException('isCostCenterExistOnTemplate');
1401: APP_EXCEPTION.RAISE_EXCEPTION;
1402: return l_cc_exist;
1403: END isCostCenterExistOnTemplate;
1404:
1431:
1432: RETURN l_ccid;
1433: EXCEPTION
1434: WHEN OTHERS THEN
1435: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpenseClearingCCID' );
1436: APP_EXCEPTION.RAISE_EXCEPTION;
1437: return 0;
1438:
1439: END GetExpenseClearingCCID;
1483: EXCEPTION
1484: WHEN NO_DATA_FOUND THEN
1485: null;
1486: WHEN OTHERS THEN
1487: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDefaultExchangeRates' );
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1490: END GetDefaultExchangeRates;
1491: