DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_FINNUMBERS_PKG dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.initialize;

71: IS
72: l_debug_prefix VARCHAR2(30) := '';
73: BEGIN
74: savepoint load_finnumbers_pvt;
75: FND_MSG_PUB.initialize;
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: --enable_debug;
79: -- Debug info.

Line 109: FND_MSG_PUB.Count_And_Get(

105: ROLLBACK TO load_finnumbers_pvt;
106: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial numbers');
107: FND_FILE.put_line(fnd_file.log, SQLERRM);
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: FND_MSG_PUB.Count_And_Get(
110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data);
113:

Line 123: FND_MSG_PUB.ADD;

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

Line 124: FND_MSG_PUB.Count_And_Get(

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

Line 146: FND_MSG_PUB.ADD;

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

Line 147: FND_MSG_PUB.Count_And_Get(

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

Line 440: FND_MSG_PUB.ADD;

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);
444: ROLLBACK to process_insert_finnumbers_pvt;

Line 451: FND_MSG_PUB.ADD;

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:
455: PROCEDURE populate_error_table(

Line 546: FND_MSG_PUB.initialize;

542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545: savepoint process_update_finnumbers_pvt;
546: FND_MSG_PUB.initialize;
547: --Initialize API return status to success.
548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549:
550: open_update_cursor(c_update_cursor, P_DML_RECORD);

Line 608: FND_MSG_PUB.ADD;

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