DBA Data[Home] [Help]

APPS.AP_TCA_SUPPLIER_SYNC_PKG dependencies on FND_MESSAGE

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

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

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

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

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

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

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

464: EXCEPTION
465:
466: WHEN OTHERS THEN
467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;

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

465:
466: WHEN OTHERS THEN
467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;
473: END IF;

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

466: WHEN OTHERS THEN
467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;
473: END IF;
474: x_return_status := fnd_api.g_ret_sts_error;

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

467: IF (SQLCODE <> -20001) THEN
468: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
469: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
470: FND_MESSAGE.SET_TOKEN('PARAMETERS','Party Site ID = '|| x_party_site_id);
471: FND_MESSAGE.SET_TOKEN('PARAMETERS','Location ID = '|| x_location_id);
472: FND_MSG_PUB.Add;
473: END IF;
474: x_return_status := fnd_api.g_ret_sts_error;
475: FND_MSG_PUB.Count_And_Get