DBA Data[Home] [Help]

APPS.AP_VENDORS_PKG dependencies on FND_MESSAGE

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

512:
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 ||

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

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);
522: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
522: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
523: END IF;

Line 520: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

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);
522: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
523: END IF;
524: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
522: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
523: END IF;
524: APP_EXCEPTION.RAISE_EXCEPTION;
525:
526: END Insert_Row;

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

862:
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 ||

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

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);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
873: END IF;

Line 870: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || x_Rowid ||

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);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
873: END IF;
874: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
872: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
873: END IF;
874: APP_EXCEPTION.RAISE_EXCEPTION;
875:
876: END Insert_Row;

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

1176:
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 ||

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

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);
1186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
1186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1187: END IF;

Line 1184: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

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);
1186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1187: END IF;
1188: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
1186: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1187: END IF;
1188: APP_EXCEPTION.RAISE_EXCEPTION;
1189:
1190: END Update_Row;

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

1365:
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);

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

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);
1375: END IF;

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

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);
1375: END IF;
1376: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1373: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_Vendor_Id);

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);
1375: END IF;
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377:

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

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);
1375: END IF;
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377:
1378:

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

1535: FETCH C INTO Recinfo;
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';

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

1691: )
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: --

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

1851: )
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: --

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

1924: )
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:

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

1933: EXCEPTION
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;

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

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);
1943: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1944: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

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

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);
1946: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
1946: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1947: END IF;

Line 1944: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||

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);
1946: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1947: END IF;
1948: END IF;

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

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);
1946: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1947: END IF;
1948: END IF;
1949: APP_EXCEPTION.RAISE_EXCEPTION;
1950:

Line 1982: fnd_message.set_name('SQLAP','AP_VEN_DUPLICATE_NAME');

1978: UPPER(SUBSTR(p_vendor_name,2,1))||'%')
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: --

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

1987: --
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 ||

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

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);
1997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
1997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1998: END IF;

Line 1995: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||

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);
1997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1998: END IF;
1999: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
1997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1998: END IF;
1999: APP_EXCEPTION.RAISE_EXCEPTION;
2000:
2001: END check_unique_vendor_name;

Line 2033: fnd_message.set_name('SQLAP','AP_VENDOR_INV_SELECTED');

2029: AND i.vendor_site_id = s.vendor_site_id;
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: --

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

2037: --
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 ||

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

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);
2047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
2047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2048: END IF;

Line 2045: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||

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);
2047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2048: END IF;
2049: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
2047: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2048: END IF;
2049: APP_EXCEPTION.RAISE_EXCEPTION;
2050:
2051: end check_denormalized_vendor_name;

Line 2091: fnd_message.set_name('SQLAP','AP_VEN_DUPLICATE_VEN_NUM');

2087: end if;
2088: --
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;

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

2098: --
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 ||

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

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);
2108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
2108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2109: END IF;

Line 2106: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||

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);
2108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2109: END IF;
2110: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
2108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2109: END IF;
2110: APP_EXCEPTION.RAISE_EXCEPTION;
2111: --
2112: --

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

2132:
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 = ' ||

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

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 ||
2142: ', VENDOR_ID = ' || x_vendor_id);

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

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 ||
2142: ', VENDOR_ID = ' || x_vendor_id);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 2140: FND_MESSAGE.SET_TOKEN('PARAMETERS','RETURN_COUNT = ' ||

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 ||
2142: ', VENDOR_ID = ' || x_vendor_id);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2144: END IF;

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

2139: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2140: FND_MESSAGE.SET_TOKEN('PARAMETERS','RETURN_COUNT = ' ||
2141: x_return_count ||
2142: ', VENDOR_ID = ' || x_vendor_id);
2143: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2144: END IF;
2145: APP_EXCEPTION.RAISE_EXCEPTION;
2146:
2147:

Line 2170: fnd_message.set_name('SQLAP','AP_EMPLOYEE_ASSIGNED');

2166: WHERE (p_rowid IS NULL OR rowid <> p_rowid)
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:

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

2174:
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 ||

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

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);
2184: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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);
2184: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2185: END IF;

Line 2182: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_rowid ||

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);
2184: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2185: END IF;
2186: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
2184: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2185: END IF;
2186: APP_EXCEPTION.RAISE_EXCEPTION;
2187:
2188: end Check_Duplicate_Employee;

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

2222: x_employee_name := '';
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);

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

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);
2232: END IF;

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

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);
2232: END IF;
2233: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2230: FND_MESSAGE.SET_TOKEN('PARAMETERS',', EMPLOYEE_ID = ' || x_employee_id);

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);
2232: END IF;
2233: APP_EXCEPTION.RAISE_EXCEPTION;
2234:

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

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);
2232: END IF;
2233: APP_EXCEPTION.RAISE_EXCEPTION;
2234:
2235: end Resolve_employee;

Line 2243: x_message_text := fnd_message.get_string( x_application,

2239: x_message_name in varchar2,
2240: x_message_text in out NOCOPY varchar2) is
2241:
2242: begin
2243: x_message_text := fnd_message.get_string( x_application,
2244: x_message_name);
2245: if x_message_text is null then
2246: x_message_text := x_message_name;
2247: end if;