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 849: FND_MSG_PUB.ADD;

845: EXCEPTION
846: WHEN OTHERS THEN
847: IF (SQLCODE <> -20001) THEN
848: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
849: FND_MSG_PUB.ADD;
850: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
851: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
852: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || x_Rowid ||
853: ', VENDOR_ID = ' || x_vendor_Id);

Line 1163: FND_MSG_PUB.ADD;

1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: IF (SQLCODE <> -20001) THEN
1162: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1163: FND_MSG_PUB.ADD;
1164: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1165: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1166: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1167: ', VENDOR_ID = ' || x_Vendor_Id);

Line 1344: FND_MSG_PUB.ADD;

1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: IF (SQLCODE <> -20001) THEN
1343: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1344: FND_MSG_PUB.ADD;
1345: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1346: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1347: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_Vendor_Id);
1348: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 1514: FND_MSG_PUB.ADD;

1510: if (C%NOTFOUND) then
1511: debug_info := 'Close cursor C- DATA NOTFOUND';
1512: CLOSE C;
1513: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1514: FND_MSG_PUB.ADD;
1515: APP_EXCEPTION.Raise_Exception;
1516: end if;
1517: debug_info := 'Close cursor C';
1518: CLOSE C;

Line 1670: FND_MSG_PUB.ADD;

1666: then
1667: null;
1668: else
1669: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
1670: FND_MSG_PUB.ADD;
1671: APP_EXCEPTION.Raise_Exception;
1672: end if;
1673: --
1674: if (

Line 1830: FND_MSG_PUB.ADD;

1826: then
1827: null;
1828: else
1829: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
1830: FND_MSG_PUB.ADD;
1831: APP_EXCEPTION.Raise_Exception;
1832: end if;
1833: --
1834: if (

Line 1903: FND_MSG_PUB.ADD;

1899: then
1900: return;
1901: else
1902: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
1903: FND_MSG_PUB.ADD;
1904: APP_EXCEPTION.Raise_Exception;
1905: end if;
1906:
1907: EXCEPTION

Line 1912: FND_MSG_PUB.ADD;

1908: WHEN OTHERS THEN
1909: IF (SQLCODE <> -20001) THEN
1910: IF (SQLCODE = -54) THEN
1911: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1912: FND_MSG_PUB.ADD;
1913: ELSE
1914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1915: FND_MSG_PUB.ADD;
1916: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 1915: FND_MSG_PUB.ADD;

1911: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1912: FND_MSG_PUB.ADD;
1913: ELSE
1914: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1915: FND_MSG_PUB.ADD;
1916: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1917: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1918: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || X_Rowid ||
1919: ', VENDOR_ID = ' || x_Vendor_Id);

Line 1957: FND_MSG_PUB.ADD;

1953: AND UPPER(vendor_name) = UPPER(p_vendor_name);
1954:
1955: if (L_overlap_count >= 1 ) then
1956: fnd_message.set_name('SQLAP','AP_VEN_DUPLICATE_NAME');
1957: FND_MSG_PUB.ADD;
1958: app_exception.raise_exception;
1959: end if;
1960: --
1961: --

Line 1966: FND_MSG_PUB.ADD;

1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1966: FND_MSG_PUB.ADD;
1967: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1968: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1969: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||
1970: ', VENDOR_NAME = ' || p_vendor_name);

Line 2008: FND_MSG_PUB.ADD;

2004: --
2005: --
2006: if (L_overlap_count >= 1 ) then
2007: fnd_message.set_name('SQLAP','AP_VENDOR_INV_SELECTED');
2008: FND_MSG_PUB.ADD;
2009: p_warning_flag := 'W';
2010: end if;
2011: --
2012: EXCEPTION

Line 2016: FND_MSG_PUB.ADD;

2012: EXCEPTION
2013: WHEN OTHERS THEN
2014: IF (SQLCODE <> -20001) THEN
2015: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2016: FND_MSG_PUB.ADD;
2017: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2018: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2019: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||
2020: ', WARNING_FLAG = ' || p_warning_flag);

Line 2067: FND_MSG_PUB.ADD;

2063: --
2064: if (L_overlap_count >= 1 ) then
2065: fnd_message.set_name('SQLAP','AP_VEN_DUPLICATE_VEN_NUM');
2066: -- Bug 6940256 udhenuko Message set needs to be added to the stack.
2067: FND_MSG_PUB.ADD;
2068: -- Bug 6940256 udhenuko End
2069: app_exception.raise_exception;
2070: end if;
2071: --

Line 2077: FND_MSG_PUB.ADD;

2073: EXCEPTION
2074: WHEN OTHERS THEN
2075: IF (SQLCODE <> -20001) THEN
2076: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2077: FND_MSG_PUB.ADD;
2078: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2079: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2080: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'VENDOR_ID = ' || p_vendor_id ||
2081: ', VENDOR_NUMBER = ' || p_vendor_number);

Line 2111: FND_MSG_PUB.ADD;

2107: EXCEPTION
2108: WHEN OTHERS THEN
2109: IF (SQLCODE <> -20001) THEN
2110: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2111: FND_MSG_PUB.ADD;
2112: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2113: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2114: FND_MESSAGE.SET_TOKEN('PARAMETERS','RETURN_COUNT = ' ||
2115: x_return_count ||

Line 2145: FND_MSG_PUB.ADD;

2141: AND employee_id = p_employee_id;
2142:
2143: if (L_Duplicate_count > 0 ) then
2144: fnd_message.set_name('SQLAP','AP_EMPLOYEE_ASSIGNED');
2145: FND_MSG_PUB.ADD;
2146: app_exception.raise_exception;
2147: end if;
2148:
2149: EXCEPTION

Line 2153: FND_MSG_PUB.ADD;

2149: EXCEPTION
2150: WHEN OTHERS THEN
2151: IF (SQLCODE <> -20001) THEN
2152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2153: FND_MSG_PUB.ADD;
2154: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('PARAMETERS','ROWID = ' || p_rowid ||
2157: ', EMPLOYEE_ID = ' || p_employee_id);

Line 2201: FND_MSG_PUB.ADD;

2197: x_employee_number := '';
2198: WHEN OTHERS THEN
2199: IF (SQLCODE <> -20001) THEN
2200: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2201: FND_MSG_PUB.ADD;
2202: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2203: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2204: FND_MESSAGE.SET_TOKEN('PARAMETERS',', EMPLOYEE_ID = ' || x_employee_id);
2205: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);