375:
376: EXCEPTION
377: WHEN OTHERS THEN
378: IF (SQLCODE <> -20001) THEN
379: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
380: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
381: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
382: current_calling_sequence);
383: FND_MESSAGE.SET_TOKEN('PARAMETERS',
376: EXCEPTION
377: WHEN OTHERS THEN
378: IF (SQLCODE <> -20001) THEN
379: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
380: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
381: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
382: current_calling_sequence);
383: FND_MESSAGE.SET_TOKEN('PARAMETERS',
384: 'X_Rowid = '||X_Rowid
377: WHEN OTHERS THEN
378: IF (SQLCODE <> -20001) THEN
379: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
380: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
381: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
382: current_calling_sequence);
383: FND_MESSAGE.SET_TOKEN('PARAMETERS',
384: 'X_Rowid = '||X_Rowid
385: ||', X_invoice_id = '||X_invoice_id
379: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
380: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
381: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
382: current_calling_sequence);
383: FND_MESSAGE.SET_TOKEN('PARAMETERS',
384: 'X_Rowid = '||X_Rowid
385: ||', X_invoice_id = '||X_invoice_id
386: );
387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
383: FND_MESSAGE.SET_TOKEN('PARAMETERS',
384: 'X_Rowid = '||X_Rowid
385: ||', X_invoice_id = '||X_invoice_id
386: );
387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
388: END IF;
389: APP_EXCEPTION.RAISE_EXCEPTION;
390:
391:
1202: AND (x_remit_msg3 IS NULL)))
1203: ) then
1204: RETURN;
1205: ELSE
1206: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1207: APP_EXCEPTION.RAISE_EXCEPTION;
1208: END IF;
1209:
1210: EXCEPTION
1212: RETURN;
1213: WHEN OTHERS THEN
1214: IF (SQLCODE <> -20001) THEN
1215: IF (SQLCODE = -54) THEN
1216: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1217: ELSE
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1214: IF (SQLCODE <> -20001) THEN
1215: IF (SQLCODE = -54) THEN
1216: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1217: ELSE
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1221: current_calling_sequence);
1222: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1215: IF (SQLCODE = -54) THEN
1216: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1217: ELSE
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1221: current_calling_sequence);
1222: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1223: 'X_Rowid = '||X_Rowid
1216: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1217: ELSE
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1221: current_calling_sequence);
1222: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1223: 'X_Rowid = '||X_Rowid
1224: ||', X_invoice_id = '||X_invoice_id
1218: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1219: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1220: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1221: current_calling_sequence);
1222: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1223: 'X_Rowid = '||X_Rowid
1224: ||', X_invoice_id = '||X_invoice_id
1225: );
1226: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1222: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1223: 'X_Rowid = '||X_Rowid
1224: ||', X_invoice_id = '||X_invoice_id
1225: );
1226: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1227: END IF;
1228: END IF;
1229: APP_EXCEPTION.RAISE_EXCEPTION;
1230:
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: IF (SQLCODE <> -20001) THEN
1415: IF (SQLCODE = -54) THEN
1416: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1417: ELSE
1418: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1419: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1420: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1414: IF (SQLCODE <> -20001) THEN
1415: IF (SQLCODE = -54) THEN
1416: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1417: ELSE
1418: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1419: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1420: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1421: current_calling_sequence);
1422: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1415: IF (SQLCODE = -54) THEN
1416: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1417: ELSE
1418: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1419: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1420: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1421: current_calling_sequence);
1422: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1423: 'X_invoice_id = '||X_invoice_id
1416: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1417: ELSE
1418: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1419: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1420: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1421: current_calling_sequence);
1422: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1423: 'X_invoice_id = '||X_invoice_id
1424: );
1418: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1419: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1420: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1421: current_calling_sequence);
1422: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1423: 'X_invoice_id = '||X_invoice_id
1424: );
1425: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1426: END IF;
1421: current_calling_sequence);
1422: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1423: 'X_invoice_id = '||X_invoice_id
1424: );
1425: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1426: END IF;
1427: END IF;
1428: APP_EXCEPTION.RAISE_EXCEPTION;
1429:
1807:
1808: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1809: NULL;
1810: ELSE
1811: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1812: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1813: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1814: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Rowid = '||X_Rowid||', X_invoice_id = '||X_invoice_id);
1815: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1808: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1809: NULL;
1810: ELSE
1811: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1812: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1813: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1814: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Rowid = '||X_Rowid||', X_invoice_id = '||X_invoice_id);
1815: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1816:
1809: NULL;
1810: ELSE
1811: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1812: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1813: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1814: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Rowid = '||X_Rowid||', X_invoice_id = '||X_invoice_id);
1815: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1816:
1817: APP_EXCEPTION.RAISE_EXCEPTION;
1810: ELSE
1811: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1812: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1813: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1814: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Rowid = '||X_Rowid||', X_invoice_id = '||X_invoice_id);
1815: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1816:
1817: APP_EXCEPTION.RAISE_EXCEPTION;
1818: END IF;
1811: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1812: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1813: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1814: FND_MESSAGE.SET_TOKEN('PARAMETERS','X_Rowid = '||X_Rowid||', X_invoice_id = '||X_invoice_id);
1815: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1816:
1817: APP_EXCEPTION.RAISE_EXCEPTION;
1818: END IF;
1819: /* END IF; */
1863:
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: IF (SQLCODE <> -20001) THEN
1867: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1868: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1869: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1870: current_calling_sequence);
1871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: IF (SQLCODE <> -20001) THEN
1867: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1868: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1869: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1870: current_calling_sequence);
1871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1872: 'X_Rowid = '||X_Rowid
1865: WHEN OTHERS THEN
1866: IF (SQLCODE <> -20001) THEN
1867: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1868: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1869: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1870: current_calling_sequence);
1871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1872: 'X_Rowid = '||X_Rowid
1873: ||', X_invoice_id = '||X_invoice_id
1867: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1868: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1869: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1870: current_calling_sequence);
1871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1872: 'X_Rowid = '||X_Rowid
1873: ||', X_invoice_id = '||X_invoice_id
1874: );
1875: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1872: 'X_Rowid = '||X_Rowid
1873: ||', X_invoice_id = '||X_invoice_id
1874: );
1875: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1876: END IF;
1877: APP_EXCEPTION.RAISE_EXCEPTION;
1878:
1879: END Update_Row;
1959: l_message_name := 'AP_INV_DEL_RET_RELEASE';
1960: END IF;
1961:
1962: IF (l_message_name is not null) THEN
1963: FND_MESSAGE.Set_Name('SQLAP', l_message_name);
1964: APP_EXCEPTION.RAISE_EXCEPTION;
1965: END IF;
1966:
1967: AP_AI_TABLE_HANDLER_PKG.Delete_Row(
1970:
1971: EXCEPTION
1972: WHEN OTHERS THEN
1973: IF (SQLCODE <> -20001) THEN
1974: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1975: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1976: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1977: current_calling_sequence);
1978: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1971: EXCEPTION
1972: WHEN OTHERS THEN
1973: IF (SQLCODE <> -20001) THEN
1974: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1975: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1976: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1977: current_calling_sequence);
1978: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1979: 'X_Rowid = '||X_Rowid
1972: WHEN OTHERS THEN
1973: IF (SQLCODE <> -20001) THEN
1974: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1975: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1976: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1977: current_calling_sequence);
1978: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1979: 'X_Rowid = '||X_Rowid
1980: );
1974: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1975: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1976: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1977: current_calling_sequence);
1978: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1979: 'X_Rowid = '||X_Rowid
1980: );
1981: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1982: END IF;
1977: current_calling_sequence);
1978: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1979: 'X_Rowid = '||X_Rowid
1980: );
1981: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1982: END IF;
1983: APP_EXCEPTION.RAISE_EXCEPTION;
1984:
1985: END Delete_Row;