APPS.EAM_GENEALOGY_IMPORT_PUB dependencies on FND_MSG_PUB

Line 65: fnd_msg_pub.initialize;

61:
62: SAVEPOINT import_genealogy_PUB;
63:
64: -- Initialize message list
65: fnd_msg_pub.initialize;
66:
67: -- Initialize API return status to success
68: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', l_error_message);
69:

Line 99: fnd_msg_pub.initialize;

95: -- process each row in the cursor at a time
96:
97: FOR genealogy_rec in genealogy_cur LOOP
98:
99: fnd_msg_pub.initialize;
100:
101: declare
102:
103: incorrect_genealogy exception;

Line 124: FND_MSG_PUB.ADD;

120: and msi.organization_id = msn.current_organization_id;
121:
122: if (l_dummy <> 1 and l_dummy <> 3) then
123: FND_MESSAGE.SET_NAME('EAM', 'EAM_GEN_INVALID_ITEM_TYPE');
124: FND_MSG_PUB.ADD;
125: RAISE incorrect_genealogy;
126: end if;
127:
128: exception

Line 131: FND_MSG_PUB.ADD;

127:
128: exception
129: when others then
130: FND_MESSAGE.SET_NAME('EAM', 'EAM_GEN_INVALID_ITEM_TYPE');
131: FND_MSG_PUB.ADD;
132: RAISE incorrect_genealogy;
133: end;
134:
135: -- if the import mode is 0 then insert a row in the MOG table

Line 141: FND_MSG_PUB.ADD;

137: IF genealogy_rec.import_mode = 0 THEN
138:
139: if genealogy_rec.start_date_active is null then
140: FND_MESSAGE.SET_NAME('EAM', 'EAM_GEN_NULL_START_DATE');
141: FND_MSG_PUB.ADD;
142: RAISE incorrect_genealogy;
143: end if;
144:
145: if l_dummy = 1 then

Line 197: FND_MSG_PUB.ADD;

193: ELSIF genealogy_rec.import_mode = 1 THEN
194:
195: if genealogy_rec.end_date_active is null then
196: FND_MESSAGE.SET_NAME('EAM', 'EAM_GEN_NULL_END_DATE');
197: FND_MSG_PUB.ADD;
198: RAISE incorrect_genealogy;
199: end if;
200:
201: if l_dummy = 3 then

Line 204: FND_MSG_PUB.ADD;

200:
201: if l_dummy = 3 then
202: if genealogy_rec.end_date_active > sysdate then
203: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_REBUILD_FUTURE_TXN');
204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206: end if;
207: end if;
208:

Line 245: FND_MSG_PUB.Count_And_Get

241: when incorrect_genealogy then
242:
243: l_return_status := FND_API.G_RET_STS_ERROR ;
244:
245: FND_MSG_PUB.Count_And_Get
246: (p_encoded => FND_API.G_FALSE,
247: p_count => l_msg_count,
248: p_data => l_msg_data
249: );

Line 260: FND_MSG_PUB.Count_And_Get

256: when others then
257:
258: l_return_status := FND_API.G_RET_STS_ERROR ;
259:
260: FND_MSG_PUB.Count_And_Get
261: (p_encoded => FND_API.G_FALSE,
262: p_count => l_msg_count,
263: p_data => l_msg_data
264: );

Line 301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

297: ROLLBACK TO import_genealogy_PUB;
298:
299: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_error_message);
300:
301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
303: END IF;
304:
305: FND_MSG_PUB.Count_And_Get

Line 302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

298:
299: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_error_message);
300:
301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
303: END IF;
304:
305: FND_MSG_PUB.Count_And_Get
306: (p_encoded => FND_API.G_FALSE,

Line 305: FND_MSG_PUB.Count_And_Get

301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
303: END IF;
304:
305: FND_MSG_PUB.Count_And_Get
306: (p_encoded => FND_API.G_FALSE,
307: p_count => l_msg_count,
308: p_data => l_msg_data
309: );