DBA Data[Home] [Help]

APPS.CSD_FLWSTS_TRAN_RESPS_PVT dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 128: FND_MSG_PUB.Count_And_Get

124: COMMIT WORK;
125: END IF;
126:
127: -- Standard call to get message count and IF count is get message info.
128: FND_MSG_PUB.Count_And_Get
129: (p_count => x_msg_count,
130: p_data => x_msg_data );
131:
132: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 144: FND_MSG_PUB.add;

140: x_return_status := FND_API.G_RET_STS_ERROR;
141:
142: -- The definition already exists. No duplicates are allowed.
143: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
144: FND_MSG_PUB.add;
145:
146: FND_MSG_PUB.Count_And_Get
147: (p_count => x_msg_count,
148: p_data => x_msg_data );

Line 146: FND_MSG_PUB.Count_And_Get

142: -- The definition already exists. No duplicates are allowed.
143: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
144: FND_MSG_PUB.add;
145:
146: FND_MSG_PUB.Count_And_Get
147: (p_count => x_msg_count,
148: p_data => x_msg_data );
149:
150: -- save message in debug log

Line 159: FND_MSG_PUB.Count_And_Get

155: WHEN FND_API.G_EXC_ERROR THEN
156: ROLLBACK TO Create_Flwsts_Tran_Resp;
157: x_return_status := FND_API.G_RET_STS_ERROR;
158:
159: FND_MSG_PUB.Count_And_Get
160: (p_count => x_msg_count,
161: p_data => x_msg_data );
162:
163: -- save message in debug log

Line 174: IF FND_MSG_PUB.Check_Msg_Level

170: ROLLBACK TO Create_Flwsts_Tran_Resp;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: -- save message in fnd stack
174: IF FND_MSG_PUB.Check_Msg_Level
175: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
176: THEN
177: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 175: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: -- save message in fnd stack
174: IF FND_MSG_PUB.Check_Msg_Level
175: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
176: THEN
177: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
179: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 179: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

175: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
176: THEN
177: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
179: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
180: end if;
181: FND_MSG_PUB.Add_Exc_Msg
182: (G_PKG_NAME ,
183: lc_api_name );

Line 181: FND_MSG_PUB.Add_Exc_Msg

177: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
179: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
180: end if;
181: FND_MSG_PUB.Add_Exc_Msg
182: (G_PKG_NAME ,
183: lc_api_name );
184: END IF;
185:

Line 186: FND_MSG_PUB.Count_And_Get

182: (G_PKG_NAME ,
183: lc_api_name );
184: END IF;
185:
186: FND_MSG_PUB.Count_And_Get
187: ( p_count => x_msg_count,
188: p_data => x_msg_data );
189:
190: -- save message in debug log

Line 201: IF FND_MSG_PUB.Check_Msg_Level

197: ROLLBACK TO Create_Flwsts_Tran_Resp;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199:
200: -- save message in fnd stack
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199:
200: -- save message in fnd stack
201: IF FND_MSG_PUB.Check_Msg_Level
202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
206: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 206: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

202: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
206: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
207: end if;
208: FND_MSG_PUB.Add_Exc_Msg
209: (G_PKG_NAME ,
210: lc_api_name );

Line 208: FND_MSG_PUB.Add_Exc_Msg

204: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
206: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
207: end if;
208: FND_MSG_PUB.Add_Exc_Msg
209: (G_PKG_NAME ,
210: lc_api_name );
211: END IF;
212:

Line 213: FND_MSG_PUB.Count_And_Get

209: (G_PKG_NAME ,
210: lc_api_name );
211: END IF;
212:
213: FND_MSG_PUB.Count_And_Get
214: (p_count => x_msg_count,
215: p_data => x_msg_data );
216:
217: -- save message in debug log

Line 280: FND_MSG_PUB.initialize;

276: END IF;
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean( p_init_msg_list ) THEN
280: FND_MSG_PUB.initialize;
281: END IF;
282:
283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 351: FND_MSG_PUB.Count_And_Get

347: COMMIT WORK;
348: END IF;
349:
350: -- Standard call to get message count and IF count is get message info.
351: FND_MSG_PUB.Count_And_Get
352: (p_count => x_msg_count,
353: p_data => x_msg_data );
354:
355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 367: FND_MSG_PUB.add;

363: x_return_status := FND_API.G_RET_STS_ERROR;
364:
365: -- The definition already exists. No duplicates are allowed.
366: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
367: FND_MSG_PUB.add;
368:
369: FND_MSG_PUB.Count_And_Get
370: (p_count => x_msg_count,
371: p_data => x_msg_data );

Line 369: FND_MSG_PUB.Count_And_Get

365: -- The definition already exists. No duplicates are allowed.
366: FND_MESSAGE.set_name('CSD', 'CSD_FLEX_DEFN_EXISTS');
367: FND_MSG_PUB.add;
368:
369: FND_MSG_PUB.Count_And_Get
370: (p_count => x_msg_count,
371: p_data => x_msg_data );
372:
373: -- save message in debug log

Line 382: FND_MSG_PUB.Count_And_Get

378: WHEN FND_API.G_EXC_ERROR THEN
379: ROLLBACK TO Update_Flwsts_Tran_Resp;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381:
382: FND_MSG_PUB.Count_And_Get
383: (p_count => x_msg_count,
384: p_data => x_msg_data );
385:
386: -- save message in debug log

Line 396: IF FND_MSG_PUB.Check_Msg_Level

392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: ROLLBACK TO Update_Flwsts_Tran_Resp;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: IF FND_MSG_PUB.Check_Msg_Level
397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
400: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

393: ROLLBACK TO Update_Flwsts_Tran_Resp;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: IF FND_MSG_PUB.Check_Msg_Level
397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
400: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
401: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 401: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
400: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
401: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
402: end if;
403: FND_MSG_PUB.Add_Exc_Msg
404: (G_PKG_NAME ,
405: lc_api_name );

Line 403: FND_MSG_PUB.Add_Exc_Msg

399: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
400: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
401: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
402: end if;
403: FND_MSG_PUB.Add_Exc_Msg
404: (G_PKG_NAME ,
405: lc_api_name );
406: END IF;
407:

Line 408: FND_MSG_PUB.Count_And_Get

404: (G_PKG_NAME ,
405: lc_api_name );
406: END IF;
407:
408: FND_MSG_PUB.Count_And_Get
409: ( p_count => x_msg_count,
410: p_data => x_msg_data );
411:
412: -- save message in debug log

Line 423: IF FND_MSG_PUB.Check_Msg_Level

419: ROLLBACK TO Update_Flwsts_Tran_Resp;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421:
422: -- save message in fnd stack
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421:
422: -- save message in fnd stack
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
428: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 428: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
428: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
429: end if;
430: FND_MSG_PUB.Add_Exc_Msg
431: (G_PKG_NAME ,
432: lc_api_name );

Line 430: FND_MSG_PUB.Add_Exc_Msg

426: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
428: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
429: end if;
430: FND_MSG_PUB.Add_Exc_Msg
431: (G_PKG_NAME ,
432: lc_api_name );
433: END IF;
434:

Line 435: FND_MSG_PUB.Count_And_Get

431: (G_PKG_NAME ,
432: lc_api_name );
433: END IF;
434:
435: FND_MSG_PUB.Count_And_Get
436: (p_count => x_msg_count,
437: p_data => x_msg_data );
438:
439: -- save message in debug log

Line 491: FND_MSG_PUB.initialize;

487: END IF;
488:
489: -- Initialize message list if p_init_msg_list is set to TRUE.
490: IF FND_API.to_Boolean( p_init_msg_list ) THEN
491: FND_MSG_PUB.initialize;
492: END IF;
493:
494: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 543: FND_MSG_PUB.Count_And_Get

539: COMMIT WORK;
540: END IF;
541:
542: -- Standard call to get message count and IF count is get message info.
543: FND_MSG_PUB.Count_And_Get
544: (p_count => x_msg_count,
545: p_data => x_msg_data );
546:
547: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 559: FND_MSG_PUB.Count_And_Get

555: ROLLBACK TO Delete_Flwsts_Tran_Resp;
556:
557: x_return_status := FND_API.G_RET_STS_ERROR;
558:
559: FND_MSG_PUB.Count_And_Get
560: (p_count => x_msg_count,
561: p_data => x_msg_data );
562:
563: -- save message in debug log

Line 574: IF FND_MSG_PUB.Check_Msg_Level

570: ROLLBACK TO Delete_Flwsts_Tran_Resp;
571:
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573:
574: IF FND_MSG_PUB.Check_Msg_Level
575: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
576: THEN
577: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 575: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

571:
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573:
574: IF FND_MSG_PUB.Check_Msg_Level
575: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
576: THEN
577: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
579: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 579: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

575: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
576: THEN
577: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
579: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
580: end if;
581: FND_MSG_PUB.Add_Exc_Msg
582: (G_PKG_NAME ,
583: lc_api_name );

Line 581: FND_MSG_PUB.Add_Exc_Msg

577: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
579: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
580: end if;
581: FND_MSG_PUB.Add_Exc_Msg
582: (G_PKG_NAME ,
583: lc_api_name );
584: END IF;
585:

Line 586: FND_MSG_PUB.Count_And_Get

582: (G_PKG_NAME ,
583: lc_api_name );
584: END IF;
585:
586: FND_MSG_PUB.Count_And_Get
587: ( p_count => x_msg_count,
588: p_data => x_msg_data );
589:
590: -- save message in debug log

Line 602: IF FND_MSG_PUB.Check_Msg_Level

598:
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: -- save message in fnd stack
602: IF FND_MSG_PUB.Check_Msg_Level
603: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 603: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: -- save message in fnd stack
602: IF FND_MSG_PUB.Check_Msg_Level
603: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
607: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 607: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

603: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
607: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
608: end if;
609: FND_MSG_PUB.Add_Exc_Msg
610: (G_PKG_NAME ,
611: lc_api_name );

Line 609: FND_MSG_PUB.Add_Exc_Msg

605: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
607: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
608: end if;
609: FND_MSG_PUB.Add_Exc_Msg
610: (G_PKG_NAME ,
611: lc_api_name );
612: END IF;
613:

Line 614: FND_MSG_PUB.Count_And_Get

610: (G_PKG_NAME ,
611: lc_api_name );
612: END IF;
613:
614: FND_MSG_PUB.Count_And_Get
615: (p_count => x_msg_count,
616: p_data => x_msg_data );
617:
618: -- save message in debug log

Line 671: FND_MSG_PUB.initialize;

667: END IF;
668:
669: -- Initialize message list if p_init_msg_list is set to TRUE.
670: IF FND_API.to_Boolean( p_init_msg_list ) THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, lc_mod_name || '.BEGIN',

Line 731: FND_MSG_PUB.Count_And_Get

727: COMMIT WORK;
728: END IF;
729:
730: -- Standard call to get message count and IF count is get message info.
731: FND_MSG_PUB.Count_And_Get
732: (p_count => x_msg_count,
733: p_data => x_msg_data );
734:
735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 746: FND_MSG_PUB.Count_And_Get

742: WHEN FND_API.G_EXC_ERROR THEN
743: ROLLBACK TO Lock_Flwsts_Tran_Resp;
744: x_return_status := FND_API.G_RET_STS_ERROR;
745:
746: FND_MSG_PUB.Count_And_Get
747: (p_count => x_msg_count,
748: p_data => x_msg_data );
749:
750: -- save message in debug log

Line 760: IF FND_MSG_PUB.Check_Msg_Level

756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: ROLLBACK TO Lock_Flwsts_Tran_Resp;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759:
760: IF FND_MSG_PUB.Check_Msg_Level
761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

757: ROLLBACK TO Lock_Flwsts_Tran_Resp;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759:
760: IF FND_MSG_PUB.Check_Msg_Level
761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
765: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 765: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

761: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
765: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
766: end if;
767: FND_MSG_PUB.Add_Exc_Msg
768: (G_PKG_NAME ,
769: lc_api_name );

Line 767: FND_MSG_PUB.Add_Exc_Msg

763: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
765: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
766: end if;
767: FND_MSG_PUB.Add_Exc_Msg
768: (G_PKG_NAME ,
769: lc_api_name );
770: END IF;
771:

Line 772: FND_MSG_PUB.Count_And_Get

768: (G_PKG_NAME ,
769: lc_api_name );
770: END IF;
771:
772: FND_MSG_PUB.Count_And_Get
773: ( p_count => x_msg_count,
774: p_data => x_msg_data );
775:
776: -- save message in debug log

Line 787: IF FND_MSG_PUB.Check_Msg_Level

783: ROLLBACK TO Lock_Flwsts_Tran_Resp;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785:
786: -- save message in fnd stack
787: IF FND_MSG_PUB.Check_Msg_Level
788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
791: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,

Line 788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785:
786: -- save message in fnd stack
787: IF FND_MSG_PUB.Check_Msg_Level
788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
791: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
792: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 792: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
791: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
792: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
793: end if;
794: FND_MSG_PUB.Add_Exc_Msg
795: (G_PKG_NAME ,
796: lc_api_name );

Line 794: FND_MSG_PUB.Add_Exc_Msg

790: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
791: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name,
792: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
793: end if;
794: FND_MSG_PUB.Add_Exc_Msg
795: (G_PKG_NAME ,
796: lc_api_name );
797: END IF;
798:

Line 799: FND_MSG_PUB.Count_And_Get

795: (G_PKG_NAME ,
796: lc_api_name );
797: END IF;
798:
799: FND_MSG_PUB.Count_And_Get
800: (p_count => x_msg_count,
801: p_data => x_msg_data );
802:
803: -- save message in debug log