DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_FINNUMBERS_PKG dependencies on FND_MESSAGE

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

117: ROLLBACK TO load_finnumbers_pvt;
118: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial numbers');
119: FND_FILE.put_line(fnd_file.log, SQLERRM);
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
122: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
123: FND_MSG_PUB.ADD;
124: FND_MSG_PUB.Count_And_Get(
125: p_encoded => FND_API.G_FALSE,

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

118: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial numbers');
119: FND_FILE.put_line(fnd_file.log, SQLERRM);
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
122: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
123: FND_MSG_PUB.ADD;
124: FND_MSG_PUB.Count_And_Get(
125: p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,

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

140: ROLLBACK TO load_finnumbers_pvt;
141: FND_FILE.put_line(fnd_file.log,'Unexpected other errors occurs while loading financial numbers');
142: FND_FILE.put_line(fnd_file.log, SQLERRM);
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
146: FND_MSG_PUB.ADD;
147: FND_MSG_PUB.Count_And_Get(
148: p_encoded => FND_API.G_FALSE,

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

141: FND_FILE.put_line(fnd_file.log,'Unexpected other errors occurs while loading financial numbers');
142: FND_FILE.put_line(fnd_file.log, SQLERRM);
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
146: FND_MSG_PUB.ADD;
147: FND_MSG_PUB.Count_And_Get(
148: p_encoded => FND_API.G_FALSE,
149: p_count => x_msg_count,

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

434:
435: populate_error_table(P_DML_RECORD, 'Y');
436: x_return_status := FND_API.G_RET_STS_ERROR;
437:
438: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
440: FND_MSG_PUB.ADD;
441: WHEN OTHERS THEN
442:

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

435: populate_error_table(P_DML_RECORD, 'Y');
436: x_return_status := FND_API.G_RET_STS_ERROR;
437:
438: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
440: FND_MSG_PUB.ADD;
441: WHEN OTHERS THEN
442:
443: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert finnumbers other exception: ' || SQLERRM);

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

445:
446: populate_error_table(P_DML_RECORD, 'N');
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
450: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
451: FND_MSG_PUB.ADD;
452: END process_insert_finnumbers;
453:

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

446: populate_error_table(P_DML_RECORD, 'N');
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
450: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
451: FND_MSG_PUB.ADD;
452: END process_insert_finnumbers;
453:
454:

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

602:
603: ROLLBACK to process_update_finnumbers_pvt;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605:
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609:
610: END process_update_finnumbers;

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

603: ROLLBACK to process_update_finnumbers_pvt;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605:
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609:
610: END process_update_finnumbers;
611: