DBA Data[Home] [Help]

APPS.OKC_XPRT_TMPL_RULE_ASSNS_PVT dependencies on FND_MSG_PUB

Line 110: FND_MSG_PUB.initialize;

106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: IF FND_API.to_Boolean( p_init_msg_list ) THEN
110: FND_MSG_PUB.initialize;
111: END IF;
112:
113: x_return_status := G_RET_STS_SUCCESS;
114:

Line 235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

231: COMMIT WORK;
232: END IF;
233:
234: -- Standard call to get message count and if count is 1, get message info.
235: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
236:
237: -- end debug log
238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

250: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
251: END IF;
252:
253: x_return_status := G_RET_STS_ERROR;
254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

261: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
262: END IF;
263:
264: x_return_status := G_RET_STS_UNEXP_ERROR;
265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
266:
267: WHEN OTHERS THEN
268:
269: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

278: p_token1_value => sqlcode,
279: p_token2 => G_SQLERRM_TOKEN,
280: p_token2_value => sqlerrm);
281: x_return_status := G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
283:
284: END copy_template_rule_assns;
285:
286:

Line 318: FND_MSG_PUB.initialize;

314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320: x_return_status := G_RET_STS_SUCCESS;
321:
322: -- delete template rules

Line 337: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

333: COMMIT WORK;
334: END IF;
335:
336: -- Standard call to get message count and if count is 1, get message info.
337: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
338:
339: -- end debug log
340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

352: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
353: END IF;
354:
355: x_return_status := G_RET_STS_ERROR;
356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359:
360: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

363: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
364: END IF;
365:
366: x_return_status := G_RET_STS_UNEXP_ERROR;
367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
368:
369: WHEN OTHERS THEN
370:
371: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 384: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

380: p_token1_value => sqlcode,
381: p_token2 => G_SQLERRM_TOKEN,
382: p_token2_value => sqlerrm);
383: x_return_status := G_RET_STS_UNEXP_ERROR;
384: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
385:
386: END delete_template_rule_assns;
387:
388: PROCEDURE merge_template_rule_assns

Line 426: FND_MSG_PUB.initialize;

422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424:
425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: x_return_status := G_RET_STS_SUCCESS;
430:

Line 481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

477: COMMIT WORK;
478: END IF;
479:
480: -- Standard call to get message count and if count is 1, get message info.
481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
482:
483: -- end debug log
484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 500: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

496: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
497: END IF;
498:
499: x_return_status := G_RET_STS_ERROR;
500: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 511: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

507: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
508: END IF;
509:
510: x_return_status := G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
512:
513: WHEN OTHERS THEN
514:
515: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 528: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

524: p_token1_value => sqlcode,
525: p_token2 => G_SQLERRM_TOKEN,
526: p_token2_value => sqlerrm);
527: x_return_status := G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
529:
530: END merge_template_rule_assns;
531:
532: