DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_PVT dependencies on FND_MSG_PUB

Line 147: FND_MSG_PUB.initialize;

143: END IF;
144:
145: -- Initialize message list if p_init_msg_list is set to TRUE.
146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
147: FND_MSG_PUB.initialize;
148: END IF;
149:
150: -- Initialize API return status to success
151: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

221: COMMIT WORK;
222: END IF;
223:
224: -- Standard call to get message count and if count is 1, get message info.
225: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
226:
227: -- end debug log
228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

239: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
240: END IF;
241:
242: x_return_status := G_RET_STS_ERROR ;
243: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

249: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
250: END IF;
251:
252: x_return_status := G_RET_STS_UNEXP_ERROR ;
253: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
254:
255: WHEN OTHERS THEN
256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
257: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

259: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
260: END IF;
261:
262: x_return_status := G_RET_STS_UNEXP_ERROR ;
263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
265: END IF;
266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
267:

Line 264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

260: END IF;
261:
262: x_return_status := G_RET_STS_UNEXP_ERROR ;
263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
265: END IF;
266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
267:
268:

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

262: x_return_status := G_RET_STS_UNEXP_ERROR ;
263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
265: END IF;
266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
267:
268:
269: END import_template;
270:

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

416:
417: END IF;
418:
419: -- Standard call to get message count and if count is 1, get message info
420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
421:
422: -- end debug log
423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

434: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
435: END IF;
436:
437: x_return_status := G_RET_STS_ERROR ;
438: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

444: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
445: END IF;
446:
447: x_return_status := G_RET_STS_UNEXP_ERROR ;
448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
449:
450: WHEN OTHERS THEN
451: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
452: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

454: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
455: END IF;
456:
457: x_return_status := G_RET_STS_UNEXP_ERROR ;
458: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
460: END IF;
461: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
462:

Line 459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

455: END IF;
456:
457: x_return_status := G_RET_STS_UNEXP_ERROR ;
458: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
460: END IF;
461: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
462:
463:

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

457: x_return_status := G_RET_STS_UNEXP_ERROR ;
458: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
460: END IF;
461: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
462:
463:
464: END sync_templates;
465:

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

1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;
1289:
1290: -- Standard call to get message count and if count is 1, get message info.
1291: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1292:
1293: -- end debug log
1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1511: G_MODULE||l_api_name,
1512: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1513: END IF;
1514:
1515: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1516: retcode := 2;
1517: errbuf := x_msg_data;
1518: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1519: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

1525: G_MODULE||l_api_name,
1526: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1527: END IF;
1528:
1529: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1530: retcode := 2;
1531: errbuf := x_msg_data;
1532: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1533: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

1539: G_MODULE||l_api_name,
1540: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1541: END IF;
1542:
1543: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1544: retcode := 2;
1545: errbuf := SQLERRM;
1546: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1547: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

2168:
2169:
2170:
2171: -- Standard call to get message count and if count is 1, get message info.
2172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2173:
2174: -- end debug log
2175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2295: G_MODULE||l_api_name,
2296: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2297: END IF;
2298:
2299: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2300: retcode := 2;
2301: errbuf := x_msg_data;
2302: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2303: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

2309: G_MODULE||l_api_name,
2310: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2311: END IF;
2312:
2313: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2314: retcode := 2;
2315: errbuf := x_msg_data;
2316: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2317: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

2323: G_MODULE||l_api_name,
2324: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2325: END IF;
2326:
2327: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2328: retcode := 2;
2329: errbuf := SQLERRM;
2330: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2331: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

2525:
2526:
2527:
2528: -- Standard call to get message count and if count is 1, get message info.
2529: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2530:
2531: -- end debug log
2532: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2543: G_MODULE||l_api_name,
2544: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2545: END IF;
2546:
2547: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2548: retcode := 2;
2549: errbuf := x_msg_data;
2550: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2551: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

2557: G_MODULE||l_api_name,
2558: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2559: END IF;
2560:
2561: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2562: retcode := 2;
2563: errbuf := x_msg_data;
2564: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2565: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

2571: G_MODULE||l_api_name,
2572: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2573: END IF;
2574:
2575: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2576: retcode := 2;
2577: errbuf := SQLERRM;
2578: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2579: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

2995: END IF;
2996:
2997:
2998: -- Standard call to get message count and if count is 1, get message info.
2999: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3000:
3001: -- end debug log
3002: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3003: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

3040: G_MODULE||l_api_name,
3041: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3042: END IF;
3043:
3044: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3045: retcode := 2;
3046: errbuf := x_msg_data;
3047: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
3048: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

3054: G_MODULE||l_api_name,
3055: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3056: END IF;
3057:
3058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3059: retcode := 2;
3060: errbuf := x_msg_data;
3061: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
3062: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

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

3068: G_MODULE||l_api_name,
3069: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3070: END IF;
3071:
3072: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3073: retcode := 2;
3074: errbuf := SQLERRM;
3075: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
3076: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);