DBA Data[Home] [Help]

APPS.AP_VENDORS_PKG dependencies on FND_MSG_PUB

Line 517: FND_MSG_PUB.ADD;

513: EXCEPTION
514: WHEN OTHERS THEN
515: IF (SQLCODE <> -20001) THEN
516: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
517: FND_MSG_PUB.ADD;
518: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
519: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
520: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
521: ', VENDOR_ID = ' || x_Vendor_Id);

Line 867: FND_MSG_PUB.ADD;

863: EXCEPTION
864: WHEN OTHERS THEN
865: IF (SQLCODE <> -20001) THEN
866: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
867: FND_MSG_PUB.ADD;
868: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
869: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
870: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || x_Rowid ||
871: ', VENDOR_ID = ' || x_vendor_Id);

Line 1181: FND_MSG_PUB.ADD;

1177: EXCEPTION
1178: WHEN OTHERS THEN
1179: IF (SQLCODE <> -20001) THEN
1180: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1181: FND_MSG_PUB.ADD;
1182: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1183: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1184: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1185: ', VENDOR_ID = ' || x_Vendor_Id);

Line 1370: FND_MSG_PUB.ADD;

1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: IF (SQLCODE <> -20001) THEN
1369: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1370: FND_MSG_PUB.ADD;
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_Vendor_Id);
1374: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 1540: FND_MSG_PUB.ADD;

1536: if (C%NOTFOUND) then
1537: debug_info := 'Close cursor C- DATA NOTFOUND';
1538: CLOSE C;
1539: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1540: FND_MSG_PUB.ADD;
1541: APP_EXCEPTION.Raise_Exception;
1542: end if;
1543: debug_info := 'Close cursor C';
1544: CLOSE C;

Line 1696: FND_MSG_PUB.ADD;

1692: then
1693: null;
1694: else
1695: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
1696: FND_MSG_PUB.ADD;
1697: APP_EXCEPTION.Raise_Exception;
1698: end if;
1699: --
1700: if (

Line 1856: FND_MSG_PUB.ADD;

1852: then
1853: null;
1854: else
1855: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
1856: FND_MSG_PUB.ADD;
1857: APP_EXCEPTION.Raise_Exception;
1858: end if;
1859: --
1860: if (

Line 1929: FND_MSG_PUB.ADD;

1925: then
1926: return;
1927: else
1928: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
1929: FND_MSG_PUB.ADD;
1930: APP_EXCEPTION.Raise_Exception;
1931: end if;
1932:
1933: EXCEPTION

Line 1938: FND_MSG_PUB.ADD;

1934: WHEN OTHERS THEN
1935: IF (SQLCODE <> -20001) THEN
1936: IF (SQLCODE = -54) THEN
1937: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1938: FND_MSG_PUB.ADD;
1939: ELSE
1940: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1941: FND_MSG_PUB.ADD;
1942: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 1941: FND_MSG_PUB.ADD;

1937: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1938: FND_MSG_PUB.ADD;
1939: ELSE
1940: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1941: FND_MSG_PUB.ADD;
1942: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1943: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1944: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1945: ', VENDOR_ID = ' || x_Vendor_Id);

Line 1983: FND_MSG_PUB.ADD;

1979: AND UPPER(vendor_name) = UPPER(p_vendor_name);
1980:
1981: if (L_overlap_count >= 1 ) then
1982: fnd_message.set_name('SQLAP','AP_VEN_DUPLICATE_NAME');
1983: FND_MSG_PUB.ADD;
1984: app_exception.raise_exception;
1985: end if;
1986: --
1987: --

Line 1992: FND_MSG_PUB.ADD;

1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: IF (SQLCODE <> -20001) THEN
1991: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1992: FND_MSG_PUB.ADD;
1993: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1994: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1995: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||
1996: ', VENDOR_NAME = ' || p_vendor_name);

Line 2034: FND_MSG_PUB.ADD;

2030: --
2031: --
2032: if (L_overlap_count >= 1 ) then
2033: fnd_message.set_name('SQLAP','AP_VENDOR_INV_SELECTED');
2034: FND_MSG_PUB.ADD;
2035: p_warning_flag := 'W';
2036: end if;
2037: --
2038: EXCEPTION

Line 2042: FND_MSG_PUB.ADD;

2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: IF (SQLCODE <> -20001) THEN
2041: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2042: FND_MSG_PUB.ADD;
2043: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2044: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2045: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||
2046: ', WARNING_FLAG = ' || p_warning_flag);

Line 2093: FND_MSG_PUB.ADD;

2089: --
2090: if (L_overlap_count >= 1 ) then
2091: fnd_message.set_name('SQLAP','AP_VEN_DUPLICATE_VEN_NUM');
2092: -- Bug 6940256 udhenuko Message set needs to be added to the stack.
2093: FND_MSG_PUB.ADD;
2094: -- Bug 6940256 udhenuko End
2095: app_exception.raise_exception;
2096: end if;
2097: --

Line 2103: FND_MSG_PUB.ADD;

2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: IF (SQLCODE <> -20001) THEN
2102: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2103: FND_MSG_PUB.ADD;
2104: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2105: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2106: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||
2107: ', VENDOR_NUMBER = ' || p_vendor_number);

Line 2137: FND_MSG_PUB.ADD;

2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: IF (SQLCODE <> -20001) THEN
2136: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2137: FND_MSG_PUB.ADD;
2138: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2140: FND_MESSAGE.SET_TOKEN('PARAMETERS','RETURN_COUNT = ' ||
2141: x_return_count ||

Line 2171: FND_MSG_PUB.ADD;

2167: AND employee_id = p_employee_id;
2168:
2169: if (L_Duplicate_count > 0 ) then
2170: fnd_message.set_name('SQLAP','AP_EMPLOYEE_ASSIGNED');
2171: FND_MSG_PUB.ADD;
2172: app_exception.raise_exception;
2173: end if;
2174:
2175: EXCEPTION

Line 2179: FND_MSG_PUB.ADD;

2175: EXCEPTION
2176: WHEN OTHERS THEN
2177: IF (SQLCODE <> -20001) THEN
2178: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2179: FND_MSG_PUB.ADD;
2180: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2181: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2182: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_rowid ||
2183: ', EMPLOYEE_ID = ' || p_employee_id);

Line 2227: FND_MSG_PUB.ADD;

2223: x_employee_number := '';
2224: WHEN OTHERS THEN
2225: IF (SQLCODE <> -20001) THEN
2226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2227: FND_MSG_PUB.ADD;
2228: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2229: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2230: FND_MESSAGE.SET_TOKEN('PARAMETERS',', EMPLOYEE_ID = ' || x_employee_id);
2231: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);