eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 848: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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

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

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

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

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

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

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);
854: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
855: END IF;
856: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
854: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
855: END IF;
856: APP_EXCEPTION.RAISE_EXCEPTION;
857:
858: END Insert_Row;

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

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

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

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

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

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

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

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);
1168: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1169: END IF;
1170: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
1168: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1169: END IF;
1170: APP_EXCEPTION.RAISE_EXCEPTION;
1171:
1172: END Update_Row;

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

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

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

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

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

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

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

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);
1349: END IF;
1350: APP_EXCEPTION.RAISE_EXCEPTION;
1351:

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

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);
1349: END IF;
1350: APP_EXCEPTION.RAISE_EXCEPTION;
1351:
1352:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);
1920: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1921: END IF;
1922: END IF;
1923: APP_EXCEPTION.RAISE_EXCEPTION;
1924:

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

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

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_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 ||

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

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

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

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

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

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);
1971: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1972: END IF;
1973: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
1971: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1972: END IF;
1973: APP_EXCEPTION.RAISE_EXCEPTION;
1974:
1975: END check_unique_vendor_name;

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

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

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

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

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

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

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

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

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

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);
2021: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2022: END IF;
2023: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
2021: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2022: END IF;
2023: APP_EXCEPTION.RAISE_EXCEPTION;
2024:
2025: end check_denormalized_vendor_name;

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

2061: end if;
2062: --
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;

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

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

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

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

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

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

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

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);
2082: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2083: END IF;
2084: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
2082: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2083: END IF;
2084: APP_EXCEPTION.RAISE_EXCEPTION;
2085: --
2086: --

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

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

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

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

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

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

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

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

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

2113: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2114: FND_MESSAGE.SET_TOKEN('PARAMETERS','RETURN_COUNT = ' ||
2115: x_return_count ||
2116: ', VENDOR_ID = ' || x_vendor_id);
2117: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2118: END IF;
2119: APP_EXCEPTION.RAISE_EXCEPTION;
2120:
2121:

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

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

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

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

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

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

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

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

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

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);
2158: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2159: END IF;
2160: APP_EXCEPTION.RAISE_EXCEPTION;

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

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);
2158: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2159: END IF;
2160: APP_EXCEPTION.RAISE_EXCEPTION;
2161:
2162: end Check_Duplicate_Employee;

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

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

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

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

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

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

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

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);
2206: END IF;
2207: APP_EXCEPTION.RAISE_EXCEPTION;
2208:

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

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);
2206: END IF;
2207: APP_EXCEPTION.RAISE_EXCEPTION;
2208:
2209: end Resolve_employee;

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

2213: x_message_name in varchar2,
2214: x_message_text in out NOCOPY varchar2) is
2215:
2216: begin
2217: x_message_text := fnd_message.get_string( x_application,
2218: x_message_name);
2219: if x_message_text is null then
2220: x_message_text := x_message_name;
2221: end if;