DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on FND_MESSAGE

Line 405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

401: ROLLBACK TO load_addresses_pvt;
402: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
403: FND_FILE.put_line(fnd_file.log, SQLERRM);
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
407: FND_MSG_PUB.ADD;
408: FND_MSG_PUB.Count_And_Get(
409: p_encoded => FND_API.G_FALSE,

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

402: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
403: FND_FILE.put_line(fnd_file.log, SQLERRM);
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
407: FND_MSG_PUB.ADD;
408: FND_MSG_PUB.Count_And_Get(
409: p_encoded => FND_API.G_FALSE,
410: p_count => x_msg_count,

Line 439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

435: ROLLBACK TO load_addresses_pvt;
436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
437: FND_FILE.put_line(fnd_file.log, SQLERRM);
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
440: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
441: FND_MSG_PUB.ADD;
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,

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

436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
437: FND_FILE.put_line(fnd_file.log, SQLERRM);
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
440: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
441: FND_MSG_PUB.ADD;
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,

Line 1194: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1190:
1191: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193:
1194: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1196: FND_MSG_PUB.ADD;
1197: when others then
1198: ----dbms_output.put_line('===================other exception');

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

1191: populate_error_table(P_DML_RECORD, 'Y', sqlerrm);
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193:
1194: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1196: FND_MSG_PUB.ADD;
1197: when others then
1198: ----dbms_output.put_line('===================other exception');
1199: ----dbms_output.put_line(sqlerrm);

Line 1207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1203:
1204: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206:
1207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1208: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1209: FND_MSG_PUB.ADD;
1210:
1211: end process_insert_addresses;

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

1204: populate_error_table(P_DML_RECORD, 'N', sqlerrm);
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206:
1207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1208: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1209: FND_MSG_PUB.ADD;
1210:
1211: end process_insert_addresses;
1212:

Line 3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

3021:
3022: ROLLBACK to process_update_addresses_pvt;
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024:
3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3027: FND_MSG_PUB.ADD;
3028:
3029: end process_update_addresses;

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

3022: ROLLBACK to process_update_addresses_pvt;
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024:
3025: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3027: FND_MSG_PUB.ADD;
3028:
3029: end process_update_addresses;
3030: