DBA Data[Home] [Help]

APPS.CSD_FLWSTS_TRAN_MILES_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_Mile;
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_Mile;
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_Mile;
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 350: FND_MSG_PUB.Count_And_Get

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

Line 366: FND_MSG_PUB.add;

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

Line 368: FND_MSG_PUB.Count_And_Get

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

Line 381: FND_MSG_PUB.Count_And_Get

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

Line 395: IF FND_MSG_PUB.Check_Msg_Level

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

Line 396: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

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

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

Line 402: FND_MSG_PUB.Add_Exc_Msg

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

Line 407: FND_MSG_PUB.Count_And_Get

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

Line 422: IF FND_MSG_PUB.Check_Msg_Level

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

Line 423: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

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

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

Line 429: FND_MSG_PUB.Add_Exc_Msg

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

Line 434: FND_MSG_PUB.Count_And_Get

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

Line 490: FND_MSG_PUB.initialize;

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

Line 542: FND_MSG_PUB.Count_And_Get

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

Line 558: FND_MSG_PUB.Count_And_Get

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

Line 573: IF FND_MSG_PUB.Check_Msg_Level

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

Line 574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

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

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

Line 580: FND_MSG_PUB.Add_Exc_Msg

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

Line 585: FND_MSG_PUB.Count_And_Get

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

Line 601: IF FND_MSG_PUB.Check_Msg_Level

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

Line 602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

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

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

Line 608: FND_MSG_PUB.Add_Exc_Msg

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

Line 613: FND_MSG_PUB.Count_And_Get

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

Line 670: FND_MSG_PUB.initialize;

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

Line 730: FND_MSG_PUB.Count_And_Get

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

Line 745: FND_MSG_PUB.Count_And_Get

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

Line 759: IF FND_MSG_PUB.Check_Msg_Level

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

Line 760: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

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

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

Line 766: FND_MSG_PUB.Add_Exc_Msg

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

Line 771: FND_MSG_PUB.Count_And_Get

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

Line 786: IF FND_MSG_PUB.Check_Msg_Level

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

Line 787: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

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

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

Line 793: FND_MSG_PUB.Add_Exc_Msg

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

Line 798: FND_MSG_PUB.Count_And_Get

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