DBA Data[Home] [Help]

APPS.AP_TCA_SUPPLIER_SYNC_PKG dependencies on FND_MESSAGE

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

170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: IF (SQLCODE <> -20001) THEN
174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
176: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
177: FND_MSG_PUB.Add;
178: END IF;

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

171: EXCEPTION
172: WHEN OTHERS THEN
173: IF (SQLCODE <> -20001) THEN
174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
176: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
177: FND_MSG_PUB.Add;
178: END IF;
179: x_return_status := fnd_api.g_ret_sts_error;

Line 176: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);

172: WHEN OTHERS THEN
173: IF (SQLCODE <> -20001) THEN
174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
176: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party ID = '|| x_party_id);
177: FND_MSG_PUB.Add;
178: END IF;
179: x_return_status := fnd_api.g_ret_sts_error;
180: FND_MSG_PUB.Count_And_Get

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

428: EXCEPTION
429:
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;

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

429:
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;
437: END IF;

Line 434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);

430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;
437: END IF;
438: x_return_status := fnd_api.g_ret_sts_error;

Line 435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);

431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
435: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
436: FND_MSG_PUB.Add;
437: END IF;
438: x_return_status := fnd_api.g_ret_sts_error;
439: FND_MSG_PUB.Count_And_Get