DBA Data[Home] [Help]

APPS.AP_AIL_TABLE_HANDLER_PKG dependencies on FND_MESSAGE

Line 50: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');

46: AND ((p_ROWID is null) OR
47: (rowid <> p_ROWID));
48:
49: IF (dummy >= 1) THEN
50: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
51: app_exception.raise_exception;
52: END IF;
53:
54: EXCEPTION

Line 57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID

Line 58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

54: EXCEPTION
55: WHEN OTHERS THEN
56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||

Line 59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

55: WHEN OTHERS THEN
56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||
63: p_line_number);

Line 60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID

56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||
63: p_line_number);
64: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

Line 64: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||
63: p_line_number);
64: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
65: END IF;
66: APP_EXCEPTION.RAISE_EXCEPTION;
67: END CHECK_UNIQUE;
68:

Line 631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

627:
628: EXCEPTION
629: WHEN OTHERS THEN
630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;

Line 632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

628: EXCEPTION
629: WHEN OTHERS THEN
630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;
636: APP_EXCEPTION.RAISE_EXCEPTION;

Line 633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

629: WHEN OTHERS THEN
630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;
636: APP_EXCEPTION.RAISE_EXCEPTION;
637:

Line 634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;
636: APP_EXCEPTION.RAISE_EXCEPTION;
637:
638: END Insert_Row;

Line 999: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

995: FETCH C INTO Recinfo;
996: IF (C%NOTFOUND) THEN
997: debug_info := 'Close cursor C - ROW NOTFOUND';
998: CLOSE C;
999: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1000: APP_EXCEPTION.Raise_Exception;
1001: END IF;
1002: debug_info := 'Close cursor C';
1003: CLOSE C;

Line 1073: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

1069: OR ( (Recinfo.attribute13 IS NULL)
1070: AND (P_Attribute13 IS NULL)))) THEN
1071: NULL;
1072: ELSE
1073: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1074: APP_EXCEPTION.Raise_Exception;
1075: END IF;
1076: IF (
1077: ( (Recinfo.attribute14 = P_Attribute14)

Line 1190: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

1186: OR ( (Recinfo.country_of_supply IS NULL)
1187: AND (P_Country_Of_Supply IS NULL)))) THEN
1188: NULL;
1189: ELSE
1190: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1191: APP_EXCEPTION.Raise_Exception;
1192: END IF;
1193: IF (
1194: ( (Recinfo.global_attribute_category =

Line 1496: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

1492: AND (P_TAX_CLASSIFICATION_CODE IS NULL)))
1493: ) THEN
1494: RETURN;
1495: ELSE
1496: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1497: APP_EXCEPTION.Raise_Exception;
1498: END IF;
1499:
1500: EXCEPTION

Line 1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');

1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: IF (SQLCODE <> -20001) THEN
1503: IF (SQLCODE = -54) THEN
1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

Line 1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1502: IF (SQLCODE <> -20001) THEN
1503: IF (SQLCODE = -54) THEN
1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;

Line 1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1503: IF (SQLCODE = -54) THEN
1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;
1511: END IF;

Line 1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;
1511: END IF;
1512: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;
1511: END IF;
1512: APP_EXCEPTION.RAISE_EXCEPTION;
1513:

Line 1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1880:
1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;

Line 1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;
1889: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1882: WHEN OTHERS THEN
1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890:

Line 1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890:
1891: END Update_Row;

Line 1947: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_TAX_LINE_DEL_FAIL');

1943: P_error_code => l_error_code,
1944: P_calling_sequence => current_calling_sequence);
1945:
1946: IF(not l_success) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_TAX_LINE_DEL_FAIL');
1948: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1949: APP_EXCEPTION.RAISE_EXCEPTION;
1950: END IF;
1951: END IF;

Line 1948: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);

1944: P_calling_sequence => current_calling_sequence);
1945:
1946: IF(not l_success) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_TAX_LINE_DEL_FAIL');
1948: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1949: APP_EXCEPTION.RAISE_EXCEPTION;
1950: END IF;
1951: END IF;
1952: --End of Bug9295867

Line 1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;

Line 1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;
1970: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

1963: WHEN OTHERS THEN
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;
1970: APP_EXCEPTION.RAISE_EXCEPTION;
1971:

Line 1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;
1970: APP_EXCEPTION.RAISE_EXCEPTION;
1971:
1972: END Delete_Row;