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;
163: EXCEPTION
164: WHEN NO_DATA_FOUND THEN
165: RETURN FALSE;
166: WHEN OTHERS THEN
167: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetAPSysCUrrencySetupInfo' );
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: RETURN FALSE;
170:
171: END GetAPSysCurrencySetupInfo;
185: EXCEPTION
186: WHEN NO_DATA_FOUND THEN
187: null;
188: WHEN OTHERS THEN
189: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetDefaultExchange' );
190: APP_EXCEPTION.RAISE_EXCEPTION;
191:
192: END GetDefaultExchange;
193:
280: WHEN NO_DATA_FOUND THEN
281: RETURN FALSE;
282:
283: WHEN OTHERS THEN
284: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorInfoOfEmp' );
285: APP_EXCEPTION.RAISE_EXCEPTION;
286: RETURN FALSE;
287:
288: END GetVendorInfoOfEmp;
311: WHEN NO_DATA_FOUND THEN
312: RETURN FALSE;
313:
314: WHEN OTHERS THEN
315: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorAWTSetupForExpRpt' );
316: APP_EXCEPTION.RAISE_EXCEPTION;
317: RETURN FALSE;
318:
319: END GetVendorAWTSetupForExpRpt;
337: WHEN NO_DATA_FOUND THEN
338: RETURN FALSE;
339:
340: WHEN OTHERS THEN
341: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorID' );
342: APP_EXCEPTION.RAISE_EXCEPTION;
343: RETURN FALSE;
344: END GetVendorID;
345:
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: RETURN FALSE;
363: WHEN OTHERS THEN
364: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorSitesCodeCombID' );
365: APP_EXCEPTION.RAISE_EXCEPTION;
366: RETURN FALSE;
367: END GetVendorSitesCodeCombID;
368:
383: EXCEPTION
384: WHEN NO_DATA_FOUND THEN
385: RETURN FALSE;
386: WHEN OTHERS THEN
387: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVendorCodeCombID' );
388: APP_EXCEPTION.RAISE_EXCEPTION;
389: RETURN FALSE;
390: END GetVendorCodeCombID;
391:
409: WHEN NO_DATA_FOUND THEN
410: RETURN FALSE;
411:
412: WHEN OTHERS THEN
413: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetPayGroupLookupCode' );
414: APP_EXCEPTION.RAISE_EXCEPTION;
415: RETURN FALSE;
416: END GetPayGroupLookupCode;
417:
430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN
432: return FALSE;
433: WHEN OTHERS THEN
434: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextInvoiceId');
435: APP_EXCEPTION.RAISE_EXCEPTION;
436: return FALSE;
437: END GetNextInvoiceId;
438:
448: EXCEPTION
449: WHEN NO_DATA_FOUND THEN
450: return FALSE;
451: WHEN OTHERS THEN
452: AP_WEB_DB_UTIL_PKG.RaiseException('GetNextInvoiceLineId');
453: APP_EXCEPTION.RAISE_EXCEPTION;
454: return FALSE;
455: END GetNextInvoiceLineId;
456:
571: WHEN NO_DATA_FOUND THEN
572: RETURN FALSE;
573:
574: WHEN OTHERS THEN
575: AP_WEB_DB_UTIL_PKG.RaiseException( 'ApproverHasAuthority');
576: APP_EXCEPTION.RAISE_EXCEPTION;
577: return FALSE;
578:
579: END ApproverHasAuthority;
716: p_valid := FALSE;
717: RETURN FALSE;
718:
719: WHEN OTHERS THEN
720: AP_WEB_DB_UTIL_PKG.RaiseException( 'CostCenterValid' );
721: APP_EXCEPTION.RAISE_EXCEPTION;
722: return FALSE;
723:
724: END CostCenterValid;
891:
892: RETURN TRUE;
893: EXCEPTION
894: WHEN AP_WEB_OA_MAINFLOW_PKG.G_EXC_ERROR THEN
895: AP_WEB_DB_UTIL_PKG.RaiseException(nvl(FND_MESSAGE.Get,l_debug_info));
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: return FALSE;
898: WHEN OTHERS THEN
899: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpenseClearingCCID' );
895: AP_WEB_DB_UTIL_PKG.RaiseException(nvl(FND_MESSAGE.Get,l_debug_info));
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: return FALSE;
898: WHEN OTHERS THEN
899: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpenseClearingCCID' );
900: APP_EXCEPTION.RAISE_EXCEPTION;
901: return FALSE;
902:
903: END GetExpenseClearingCCID;
917: WHEN NO_DATA_FOUND THEN
918: RETURN FALSE;
919:
920: WHEN OTHERS THEN
921: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetRoundingErrorCCID' );
922: APP_EXCEPTION.RAISE_EXCEPTION;
923: return FALSE;
924:
925: END GetRoundingErrorCCID;
959: WHEN NO_DATA_FOUND THEN
960: RETURN FALSE;
961:
962: WHEN OTHERS THEN
963: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetAvailablePrepayments' );
964: APP_EXCEPTION.RAISE_EXCEPTION;
965: return FALSE;
966:
967: END GetAvailablePrepayments;
1027: WHEN NO_DATA_FOUND THEN
1028: RETURN FALSE;
1029:
1030: WHEN OTHERS THEN
1031: AP_WEB_DB_UTIL_PKG.RaiseException( 'UpdateInvoiceInterface' );
1032: APP_EXCEPTION.RAISE_EXCEPTION;
1033: return FALSE;
1034:
1035: END InsertInvoiceInterface;
1078: WHEN NO_DATA_FOUND THEN
1079: RETURN FALSE;
1080:
1081: WHEN OTHERS THEN
1082: AP_WEB_DB_UTIL_PKG.RaiseException( 'InsertInvoiceLinesInerface' );
1083: APP_EXCEPTION.RAISE_EXCEPTION;
1084: return FALSE;
1085:
1086: END InsertInvoiceLinesInterface;
1115: WHEN NO_DATA_FOUND THEN
1116: RETURN FALSE;
1117:
1118: WHEN OTHERS THEN
1119: AP_WEB_DB_UTIL_PKG.RaiseException( 'IsTaxCodeWebEnabled' );
1120: APP_EXCEPTION.RAISE_EXCEPTION;
1121: return FALSE;
1122:
1123: END IsTaxCodeWebEnabled;
1136:
1137: EXCEPTION
1138:
1139: WHEN OTHERS THEN
1140: AP_WEB_DB_UTIL_PKG.RaiseException( 'AP_WEB_DB_AP_INT_PKG.GenTaxFunctions' );
1141: APP_EXCEPTION.RAISE_EXCEPTION;
1142:
1143: END GenTaxFunctions;
1144:
1167: WHEN NO_DATA_FOUND THEN
1168: RETURN FALSE;
1169:
1170: WHEN OTHERS THEN
1171: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetInvoiceAmt' );
1172: APP_EXCEPTION.RAISE_EXCEPTION;
1173: return FALSE;
1174:
1175: END GetInvoiceAmt;
1191: EXCEPTION
1192: WHEN NO_DATA_FOUND THEN
1193: return FALSE;
1194: WHEN OTHERS THEN
1195: AP_WEB_DB_UTIL_PKG.RaiseException( 'SetInvoiceAmount' );
1196: APP_EXCEPTION.RAISE_EXCEPTION;
1197: return FALSE;
1198:
1199: END SetInvoiceAmount;
1220: WHEN NO_DATA_FOUND THEN
1221: RETURN FALSE;
1222:
1223: WHEN OTHERS THEN
1224: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetVatCode' );
1225: APP_EXCEPTION.RAISE_EXCEPTION;
1226: return FALSE;
1227:
1228: END GetVatCode;
1249: WHEN NO_DATA_FOUND THEN
1250: RETURN FALSE;
1251:
1252: WHEN OTHERS THEN
1253: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTaxCodeID' );
1254: APP_EXCEPTION.RAISE_EXCEPTION;
1255: return FALSE;
1256:
1257: END GetTaxCodeID;
1283: WHEN NO_DATA_FOUND THEN
1284: RETURN FALSE;
1285:
1286: WHEN OTHERS THEN
1287: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetTaxCodeID' );
1288: APP_EXCEPTION.RAISE_EXCEPTION;
1289: return FALSE;
1290:
1291: END GetTaxCodeID;
1354: return l_cc_exist;
1355:
1356: EXCEPTION
1357: when others then
1358: AP_WEB_DB_UTIL_PKG.RaiseException('isCostCenterExistOnTemplate');
1359: APP_EXCEPTION.RAISE_EXCEPTION;
1360: return l_cc_exist;
1361: END isCostCenterExistOnTemplate;
1362:
1389:
1390: RETURN l_ccid;
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetExpenseClearingCCID' );
1394: APP_EXCEPTION.RAISE_EXCEPTION;
1395: return 0;
1396:
1397: END GetExpenseClearingCCID;