DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on FND_MSG_PUB

Line 321: FND_MSG_PUB.initialize;

317: ) IS
318: l_debug_prefix VARCHAR2(30) := '';
319: BEGIN
320: savepoint load_addresses_pvt;
321: FND_MSG_PUB.initialize;
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323:
324: --enable_debug;
325: -- Debug info.

Line 382: FND_MSG_PUB.Count_And_Get(

378: ROLLBACK TO load_addresses_pvt;
379: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading addresses');
380: FND_FILE.put_line(fnd_file.log, SQLERRM);
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get(
383: p_encoded => FND_API.G_FALSE,
384: p_count => x_msg_count,
385: p_data => x_msg_data);
386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 407: FND_MSG_PUB.ADD;

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,
411: p_data => x_msg_data);

Line 408: FND_MSG_PUB.Count_And_Get(

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,
411: p_data => x_msg_data);
412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 441: FND_MSG_PUB.ADD;

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,
445: p_data => x_msg_data);

Line 442: FND_MSG_PUB.Count_And_Get(

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,
445: p_data => x_msg_data);
446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1196: FND_MSG_PUB.ADD;

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

Line 1209: FND_MSG_PUB.ADD;

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

Line 1969: FND_MSG_PUB.initialize;

1965: p_msg_level=>fnd_log.level_procedure);
1966: END IF;
1967:
1968: savepoint process_update_addresses_pvt;
1969: FND_MSG_PUB.initialize;
1970: --Initialize API return status to success.
1971: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972: open_update_cursor(c_update_cursor, P_DML_RECORD);
1973:

Line 3027: FND_MSG_PUB.ADD;

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