275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: IF (SQLCODE <> -20001) THEN
279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
282: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
283: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
276: EXCEPTION
277: WHEN OTHERS THEN
278: IF (SQLCODE <> -20001) THEN
279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
282: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
283: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
284: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
277: WHEN OTHERS THEN
278: IF (SQLCODE <> -20001) THEN
279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
282: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
283: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
284: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
285: END IF;
278: IF (SQLCODE <> -20001) THEN
279: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
282: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
283: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
284: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
285: END IF;
286: APP_EXCEPTION.RAISE_EXCEPTION;
280: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
281: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
282: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
283: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
284: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
285: END IF;
286: APP_EXCEPTION.RAISE_EXCEPTION;
287:
288: END Insert_Row;
588: FETCH C INTO Recinfo;
589: if (C%NOTFOUND) then
590: debug_info := 'Close cursor C - ROW NOTFOUND';
591: CLOSE C;
592: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
593: APP_EXCEPTION.Raise_Exception;
594: end if;
595: debug_info := 'Close cursor C';
596: CLOSE C;
942: AND (x_paycard_reference_id IS NULL)))
943: ) then
944: return;
945: else
946: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
947: APP_EXCEPTION.Raise_Exception;
948: end if;
949: else
950: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
946: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
947: APP_EXCEPTION.Raise_Exception;
948: end if;
949: else
950: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
951: APP_EXCEPTION.Raise_Exception;
952: end if;
953:
954: EXCEPTION
954: EXCEPTION
955: WHEN OTHERS THEN
956: IF (SQLCODE <> -20001) THEN
957: IF (SQLCODE = -54) THEN
958: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
959: ELSE
960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
956: IF (SQLCODE <> -20001) THEN
957: IF (SQLCODE = -54) THEN
958: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
959: ELSE
960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
963: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
964: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
957: IF (SQLCODE = -54) THEN
958: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
959: ELSE
960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
963: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
964: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
965: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
958: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
959: ELSE
960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
963: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
964: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
965: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
966: END IF;
959: ELSE
960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
963: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
964: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
965: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
966: END IF;
967: END IF;
961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
963: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
964: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
965: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
966: END IF;
967: END IF;
968: APP_EXCEPTION.RAISE_EXCEPTION;
969:
1333:
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: IF (SQLCODE <> -20001) THEN
1337: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1338: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1339: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1340: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1341: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: IF (SQLCODE <> -20001) THEN
1337: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1338: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1339: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1340: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1341: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1342: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1335: WHEN OTHERS THEN
1336: IF (SQLCODE <> -20001) THEN
1337: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1338: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1339: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1340: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1341: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1342: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1343: END IF;
1336: IF (SQLCODE <> -20001) THEN
1337: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1338: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1339: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1340: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1341: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1342: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1343: END IF;
1344: APP_EXCEPTION.RAISE_EXCEPTION;
1338: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1339: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1340: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1341: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1342: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1343: END IF;
1344: APP_EXCEPTION.RAISE_EXCEPTION;
1345:
1346: END Update_Row;
1362:
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF (SQLCODE <> -20001) THEN
1366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF (SQLCODE <> -20001) THEN
1366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1371: END IF;
1364: WHEN OTHERS THEN
1365: IF (SQLCODE <> -20001) THEN
1366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1371: END IF;
1372: APP_EXCEPTION.RAISE_EXCEPTION;
1365: IF (SQLCODE <> -20001) THEN
1366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1371: END IF;
1372: APP_EXCEPTION.RAISE_EXCEPTION;
1373:
1366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1371: END IF;
1372: APP_EXCEPTION.RAISE_EXCEPTION;
1373:
1374: END Delete_Row;
1449:
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: IF (SQLCODE <> -20001) THEN
1453: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1454: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1455: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1456: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: IF (SQLCODE <> -20001) THEN
1453: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1454: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1455: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1456: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1458: END IF;
1451: WHEN OTHERS THEN
1452: IF (SQLCODE <> -20001) THEN
1453: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1454: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1455: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1456: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1458: END IF;
1459: APP_EXCEPTION.RAISE_EXCEPTION;
1452: IF (SQLCODE <> -20001) THEN
1453: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1454: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1455: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1456: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1458: END IF;
1459: APP_EXCEPTION.RAISE_EXCEPTION;
1460: END is_maturity_accounted;
1453: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1454: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1455: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1456: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1458: END IF;
1459: APP_EXCEPTION.RAISE_EXCEPTION;
1460: END is_maturity_accounted;
1461:
1492:
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: IF (SQLCODE <> -20001) THEN
1496: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1497: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1498: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1499: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1500: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1493: EXCEPTION
1494: WHEN OTHERS THEN
1495: IF (SQLCODE <> -20001) THEN
1496: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1497: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1498: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1499: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1500: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1501: END IF;
1494: WHEN OTHERS THEN
1495: IF (SQLCODE <> -20001) THEN
1496: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1497: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1498: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1499: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1500: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1501: END IF;
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1495: IF (SQLCODE <> -20001) THEN
1496: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1497: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1498: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1499: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1500: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1501: END IF;
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1503: END is_payment_matured;
1496: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1497: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1498: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1499: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1500: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1501: END IF;
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1503: END is_payment_matured;
1504:
1677: EXCEPTION
1678:
1679: WHEN OTHERS THEN
1680: IF (SQLCODE <> -20001) THEN
1681: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1682: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1683: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1684: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1678:
1679: WHEN OTHERS THEN
1680: IF (SQLCODE <> -20001) THEN
1681: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1682: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1683: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1684: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1686: END IF;
1679: WHEN OTHERS THEN
1680: IF (SQLCODE <> -20001) THEN
1681: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1682: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1683: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1684: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1686: END IF;
1687: APP_EXCEPTION.RAISE_EXCEPTION;
1680: IF (SQLCODE <> -20001) THEN
1681: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1682: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1683: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1684: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1686: END IF;
1687: APP_EXCEPTION.RAISE_EXCEPTION;
1688:
1681: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1682: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1683: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1684: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1686: END IF;
1687: APP_EXCEPTION.RAISE_EXCEPTION;
1688:
1689: END Subscribe_To_Payment_Event;