APPS.PSB_VALIDATE_DATA_EXTRACT_PVT dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.initialize;

78:
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80:
81: if FND_API.to_Boolean (p_init_msg_list) then
82: FND_MSG_PUB.initialize;
83: end if;
84:
85: -- Initialize API return status to success
86:

Line 154: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

150:
151: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
152: l_userid := FND_GLOBAL.USER_ID;
153:
154: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
155: p_data => l_msg_data );
156: IF l_msg_count > 0 THEN
157:
158: l_msg_data := FND_MSG_PUB.Get

Line 158: l_msg_data := FND_MSG_PUB.Get

154: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
155: p_data => l_msg_data );
156: IF l_msg_count > 0 THEN
157:
158: l_msg_data := FND_MSG_PUB.Get
159: (p_msg_index => FND_MSG_PUB.G_NEXT,
160: p_encoded => FND_API.G_FALSE);
161:
162: PSB_MESSAGE_S.INSERT_ERROR

Line 159: (p_msg_index => FND_MSG_PUB.G_NEXT,

155: p_data => l_msg_data );
156: IF l_msg_count > 0 THEN
157:
158: l_msg_data := FND_MSG_PUB.Get
159: (p_msg_index => FND_MSG_PUB.G_NEXT,
160: p_encoded => FND_API.G_FALSE);
161:
162: PSB_MESSAGE_S.INSERT_ERROR
163: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 194: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

190: end if;
191:
192: -- Standard call to get message count and if count is 1, get message info.
193:
194: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
195: p_data => p_msg_data);
196:
197: EXCEPTION
198:

Line 205: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

201: rollback to Data_Extract_Summary;
202:
203: p_return_status := FND_API.G_RET_STS_ERROR;
204:
205: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
206: p_data => p_msg_data);
207:
208:
209: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 215: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

211: rollback to Data_Extract_Summary;
212:
213: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214:
215: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
216: p_data => p_msg_data);
217:
218:
219: when OTHERS then

Line 225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

221: rollback to Data_Extract_Summary;
222:
223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224:
225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
226:
227: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
228: l_api_name);
229: end if;

Line 227: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224:
225: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
226:
227: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
228: l_api_name);
229: end if;
230:
231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

227: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
228: l_api_name);
229: end if;
230:
231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
232: p_data => p_msg_data);
233:
234: END Data_Extract_Summary;
235: /*---------------------------------------------------------------------------*/

Line 300: FND_MSG_PUB.initialize;

296: end if;
297:
298: -- Initialize message list if p_init_msg_list is set to TRUE.
299: if FND_API.to_Boolean (p_init_msg_list) then
300: FND_MSG_PUB.initialize;
301: end if;
302:
303: -- Initialize API return status to success
304: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 409: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

405: commit work;
406: end if;
407:
408: -- Standard call to get message count and if count is 1, get message info.
409: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
410: p_data => p_msg_data);
411: EXCEPTION
412: --
413: when FND_API.G_EXC_ERROR then

Line 416: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

412: --
413: when FND_API.G_EXC_ERROR then
414: rollback to Validate_Data_Extract;
415: p_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
417: p_data => p_msg_data);
418: --
419: when FND_API.G_EXC_UNEXPECTED_ERROR then
420: rollback to Validate_Data_Extract;

Line 422: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

418: --
419: when FND_API.G_EXC_UNEXPECTED_ERROR then
420: rollback to Validate_Data_Extract;
421: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
423: p_data => p_msg_data);
424: --
425: when OTHERS then
426: rollback to Validate_Data_Extract;

Line 428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

424: --
425: when OTHERS then
426: rollback to Validate_Data_Extract;
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
430: l_api_name);
431: end if;
432: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

425: when OTHERS then
426: rollback to Validate_Data_Extract;
427: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
430: l_api_name);
431: end if;
432: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
433: p_data => p_msg_data);

Line 432: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
430: l_api_name);
431: end if;
432: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
433: p_data => p_msg_data);
434: --
435: END Validate_Data_Extract;
436: /* ----------------------------------------------------------------------- */

Line 481: FND_MSG_PUB.Add;

477: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
478: end loop;
479: end if;
480:
481: FND_MSG_PUB.Add;
482:
483: end if;
484:
485: -- Clear Message Token stack