362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: IF (SQLCODE <> -20001) THEN
366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
370: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
363: EXCEPTION
364: WHEN OTHERS THEN
365: IF (SQLCODE <> -20001) THEN
366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
370: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
371: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
364: WHEN OTHERS THEN
365: IF (SQLCODE <> -20001) THEN
366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
370: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
371: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
372: END IF;
365: IF (SQLCODE <> -20001) THEN
366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
370: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
371: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
372: END IF;
373: APP_EXCEPTION.RAISE_EXCEPTION;
367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
369: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
370: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
371: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
372: END IF;
373: APP_EXCEPTION.RAISE_EXCEPTION;
374:
375: END Insert_Row;
683:
684: if (C%NOTFOUND) then
685: debug_info := 'Close cursor C - ROW NOTFOUND';
686: CLOSE C;
687: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
688: APP_EXCEPTION.Raise_Exception;
689: end if;
690: debug_info := 'Close cursor C';
691: CLOSE C;
1054: )
1055: then
1056: return;
1057: else
1058: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1059: APP_EXCEPTION.Raise_Exception;
1060: end if;
1061: /* Added for bug#6976792 End */
1062: /* return; commented for bug#6976792 */
1060: end if;
1061: /* Added for bug#6976792 End */
1062: /* return; commented for bug#6976792 */
1063: else
1064: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1065: APP_EXCEPTION.Raise_Exception;
1066: end if;
1067: else
1068: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1064: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1065: APP_EXCEPTION.Raise_Exception;
1066: end if;
1067: else
1068: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1069: APP_EXCEPTION.Raise_Exception;
1070: end if;
1071:
1072: EXCEPTION
1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: IF (SQLCODE <> -20001) THEN
1075: IF (SQLCODE = -54) THEN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1077: ELSE
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1074: IF (SQLCODE <> -20001) THEN
1075: IF (SQLCODE = -54) THEN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1077: ELSE
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1081: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1082: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1075: IF (SQLCODE = -54) THEN
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1077: ELSE
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1081: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1082: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1083: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1076: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1077: ELSE
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1081: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1082: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1083: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1084: END IF;
1077: ELSE
1078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1081: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1082: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1083: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1084: END IF;
1085: END IF;
1079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1081: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1082: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1083: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1084: END IF;
1085: END IF;
1086: APP_EXCEPTION.RAISE_EXCEPTION;
1087:
1451:
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454: IF (SQLCODE <> -20001) THEN
1455: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1457: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1458: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1459: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454: IF (SQLCODE <> -20001) THEN
1455: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1457: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1458: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1459: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1460: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1453: WHEN OTHERS THEN
1454: IF (SQLCODE <> -20001) THEN
1455: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1457: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1458: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1459: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1460: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1461: END IF;
1454: IF (SQLCODE <> -20001) THEN
1455: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1457: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1458: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1459: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1460: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1461: END IF;
1462: APP_EXCEPTION.RAISE_EXCEPTION;
1456: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1457: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1458: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1459: ', CHECK_ID = ' || TO_CHAR(X_Check_Id));
1460: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1461: END IF;
1462: APP_EXCEPTION.RAISE_EXCEPTION;
1463:
1464: END Update_Row;
1480:
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483: IF (SQLCODE <> -20001) THEN
1484: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1485: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1486: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1487: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1488: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483: IF (SQLCODE <> -20001) THEN
1484: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1485: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1486: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1487: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1488: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1489: END IF;
1482: WHEN OTHERS THEN
1483: IF (SQLCODE <> -20001) THEN
1484: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1485: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1486: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1487: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1488: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1489: END IF;
1490: APP_EXCEPTION.RAISE_EXCEPTION;
1483: IF (SQLCODE <> -20001) THEN
1484: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1485: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1486: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1487: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1488: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1489: END IF;
1490: APP_EXCEPTION.RAISE_EXCEPTION;
1491:
1484: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1485: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1486: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1487: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid);
1488: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1489: END IF;
1490: APP_EXCEPTION.RAISE_EXCEPTION;
1491:
1492: END Delete_Row;
1567:
1568: EXCEPTION
1569: WHEN OTHERS THEN
1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1568: EXCEPTION
1569: WHEN OTHERS THEN
1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1576: END IF;
1569: WHEN OTHERS THEN
1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1576: END IF;
1577: APP_EXCEPTION.RAISE_EXCEPTION;
1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1576: END IF;
1577: APP_EXCEPTION.RAISE_EXCEPTION;
1578: END is_maturity_accounted;
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1576: END IF;
1577: APP_EXCEPTION.RAISE_EXCEPTION;
1578: END is_maturity_accounted;
1579:
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1619: END IF;
1612: WHEN OTHERS THEN
1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1619: END IF;
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1619: END IF;
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1621: END is_payment_matured;
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(X_check_id));
1618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1619: END IF;
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1621: END is_payment_matured;
1622:
1795: EXCEPTION
1796:
1797: WHEN OTHERS THEN
1798: IF (SQLCODE <> -20001) THEN
1799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1802: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1803: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1796:
1797: WHEN OTHERS THEN
1798: IF (SQLCODE <> -20001) THEN
1799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1802: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1803: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1804: END IF;
1797: WHEN OTHERS THEN
1798: IF (SQLCODE <> -20001) THEN
1799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1802: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1803: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1804: END IF;
1805:
1798: IF (SQLCODE <> -20001) THEN
1799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1802: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1803: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1804: END IF;
1805:
1806: /* Start - BUG 14364091 - Logging */
1799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1802: FND_MESSAGE.SET_TOKEN('PARAMETERS','check_id = ' || to_char(P_Check_ID));
1803: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1804: END IF;
1805:
1806: /* Start - BUG 14364091 - Logging */
1807: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR Code : ' || SQLCODE);