DBA Data[Home] [Help]

APPS.IGC_CC_APPROVAL_PROCESS dependencies on FND_MSG_PUB

Line 84: Put_Debug_Msg(l_full_path, 'Raising an execution exception: '||fnd_msg_pub.get(1,FND_API.G_FALSE));

80:
81: IGC_MSGS_PKG.add_message (p_appname => appname,
82: p_msgname => msgname);
83: IF (g_debug_mode = 'Y') THEN
84: Put_Debug_Msg(l_full_path, 'Raising an execution exception: '||fnd_msg_pub.get(1,FND_API.G_FALSE));
85: END IF;
86:
87: END add_message;
88:

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

100: IF (g_debug_mode = 'Y') THEN
101: Put_Debug_Msg(l_full_path, 'Error during the execution ');
102: END IF;
103:
104: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
105: p_data => l_msg_data );
106:
107: IF l_msg_count >0 THEN
108: l_msg_data :='';

Line 111: -- l_msg_data :=l_msg_data||' Mes No'||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);

107: IF l_msg_count >0 THEN
108: l_msg_data :='';
109:
110: FOR l_cur IN 1..l_msg_count LOOP
111: -- l_msg_data :=l_msg_data||' Mes No'||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
112: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
113: IF(g_error_level >= g_debug_level) THEN
114: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);
115: END IF;

Line 112: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);

108: l_msg_data :='';
109:
110: FOR l_cur IN 1..l_msg_count LOOP
111: -- l_msg_data :=l_msg_data||' Mes No'||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
112: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
113: IF(g_error_level >= g_debug_level) THEN
114: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);
115: END IF;
116: END LOOP;

Line 194: FND_MSG_PUB.initialize;

190: END IF;
191:
192: -- Initialize message list if p_init_msg_list is set to TRUE.
193: IF FND_API.to_Boolean( p_init_msg_list ) THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196:
197: -- Initialize API return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 227: FND_MSG_PUB.ADD;

223: CLOSE c_org_name;
224:
225: FND_MESSAGE.SET_TOKEN ('ORG_ID',l_value);
226:
227: FND_MSG_PUB.ADD;
228: raise FND_API.G_EXC_ERROR;
229: END IF;
230:
231: CLOSE c_setup_opt;

Line 244: FND_MSG_PUB.Count_And_Get

240: COMMIT WORK;
241: END IF;
242:
243: -- Standard call to get message count and if count is 1, get message info.
244: FND_MSG_PUB.Count_And_Get
245: ( p_count => x_msg_count ,
246: p_data => x_msg_data
247: );
248: EXCEPTION

Line 254: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

250: ROLLBACK to Preparer_Can_Approve;
251:
252: x_return_status := FND_API.G_RET_STS_ERROR;
253:
254: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
255: p_data => x_msg_data);
256: IF (g_excep_level >= g_debug_level ) THEN
257: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
258: END IF;

Line 264: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

260: ROLLBACK to Preparer_Can_Approve;
261:
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263:
264: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
265: p_data => x_msg_data);
266: IF (g_excep_level >= g_debug_level ) THEN
267: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
268: END IF;

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

270: ROLLBACK to Preparer_Can_Approve;
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273:
274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
276: l_api_name);
277: END IF;
278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

Line 275: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273:
274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
276: l_api_name);
277: END IF;
278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
279: p_data => x_msg_data);

Line 278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
276: l_api_name);
277: END IF;
278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
279: p_data => x_msg_data);
280: IF ( g_unexp_level >= g_debug_level ) THEN
281: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
282: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

Line 363: FND_MSG_PUB.initialize;

359: END IF;
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.
362: IF FND_API.to_Boolean( p_init_msg_list ) THEN
363: FND_MSG_PUB.initialize;
364: END IF;
365:
366: -- Initialize API return status to success
367: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

536: COMMIT WORK;
537: END IF;
538:
539:
540: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count ,
541: p_data => p_msg_data );
542: p_msg_count := l_msg_count;
543:
544: IF (g_debug_mode = 'Y') THEN

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

551: p_return_status := FND_API.G_RET_STS_ERROR;
552:
553: Generate_Message;
554:
555: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count ,
556: p_data => p_msg_data );
557: IF (g_excep_level >= g_debug_level ) THEN
558: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
559: END IF;

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

562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: Generate_Message;
565:
566: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count ,
567: p_data => p_msg_data );
568: IF (g_excep_level >= g_debug_level ) THEN
569: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
570: END IF;

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

570: END IF;
571: WHEN OTHERS THEN
572: ROLLBACK to Approved_By_Preparer;
573: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
575: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
576: l_api_name);
577: END IF;
578:

Line 575: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

571: WHEN OTHERS THEN
572: ROLLBACK to Approved_By_Preparer;
573: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
575: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
576: l_api_name);
577: END IF;
578:
579: Generate_Message;

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

577: END IF;
578:
579: Generate_Message;
580:
581: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count ,
582: p_data => p_msg_data );
583: IF ( g_unexp_level >= g_debug_level ) THEN
584: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
585: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

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

764: /*WHEN FND_API.G_EXC_ERROR THEN
765: RETURN;*/
766:
767: WHEN OTHERS THEN
768: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
769: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
770: END IF;
771: NULL;
772: RETURN;

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

765: RETURN;*/
766:
767: WHEN OTHERS THEN
768: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
769: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
770: END IF;
771: NULL;
772: RETURN;
773: