DBA Data[Home] [Help]

APPS.JTF_QUALIFIER_PUB dependencies on FND_MSG_PUB

Line 110: FND_MSG_PUB.initialize;

106:
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF FND_API.to_Boolean( p_init_msg_list )
109: THEN
110: FND_MSG_PUB.initialize;
111: END IF;
112:
113: -- Debug Message
114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

110: FND_MSG_PUB.initialize;
111: END IF;
112:
113: -- Debug Message
114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
115: THEN
116: FND_MESSAGE.Set_Name('JTF', 'Pub Qual API: Start');
117: FND_MSG_PUB.Add;
118: END IF;

Line 117: FND_MSG_PUB.Add;

113: -- Debug Message
114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
115: THEN
116: FND_MESSAGE.Set_Name('JTF', 'Pub Qual API: Start');
117: FND_MSG_PUB.Add;
118: END IF;
119:
120: -------------------------------------------------------------------------------------------------------
121: -- Start of API body.

Line 164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

160: COMMIT WORK;
161: END IF;
162:
163: -- Debug Message
164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
165: THEN
166: FND_MESSAGE.Set_Name('JTF', 'Pub Qualifier API: End');
167: FND_MSG_PUB.Add;
168: END IF;

Line 167: FND_MSG_PUB.Add;

163: -- Debug Message
164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
165: THEN
166: FND_MESSAGE.Set_Name('JTF', 'Pub Qualifier API: End');
167: FND_MSG_PUB.Add;
168: END IF;
169:
170: -- Standard call to get message count and if count is 1, get message info.
171: FND_MSG_PUB.Count_And_Get

Line 171: FND_MSG_PUB.Count_And_Get

167: FND_MSG_PUB.Add;
168: END IF;
169:
170: -- Standard call to get message count and if count is 1, get message info.
171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );
175: ----plsdbg.put('QUALPUB.CREATE_QUALIFIER: END');

Line 184: FND_MSG_PUB.Count_And_Get

180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO CREATE_QUALIFIER_PUB;
182: x_return_status := FND_API.G_RET_STS_ERROR ;
183:
184: FND_MSG_PUB.Count_And_Get
185: ( p_count => x_msg_count,
186: p_data => x_msg_data
187: );
188:

Line 193: FND_MSG_PUB.Count_And_Get

189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: ROLLBACK TO CREATE_QUALIFIER_PUB;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192:
193: FND_MSG_PUB.Count_And_Get
194: ( p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197:

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

199: WHEN OTHERS THEN
200: ROLLBACK TO CREATE_QUALIFIER_PUB;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202:
203: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
205: END IF;
206:
207: FND_MSG_PUB.Count_And_Get

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

200: ROLLBACK TO CREATE_QUALIFIER_PUB;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202:
203: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
205: END IF;
206:
207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count,

Line 207: FND_MSG_PUB.Count_And_Get

203: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
205: END IF;
206:
207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211:

Line 296: FND_MSG_PUB.initialize;

292:
293: -- Initialize message list if p_init_msg_list is set to TRUE.
294: IF FND_API.to_Boolean( p_init_msg_list )
295: THEN
296: FND_MSG_PUB.initialize;
297: END IF;
298:
299: -- Debug Message
300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

296: FND_MSG_PUB.initialize;
297: END IF;
298:
299: -- Debug Message
300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
301: THEN
302: FND_MESSAGE.Set_Name('JTF', 'Pub Qual API: Start');
303: FND_MSG_PUB.Add;
304: END IF;

Line 303: FND_MSG_PUB.Add;

299: -- Debug Message
300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
301: THEN
302: FND_MESSAGE.Set_Name('JTF', 'Pub Qual API: Start');
303: FND_MSG_PUB.Add;
304: END IF;
305:
306: -------------------------------------------------------------------------------------------------------
307: -- Start of API body.

Line 350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

346: COMMIT WORK;
347: END IF;
348:
349: -- Debug Message
350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
351: THEN
352: FND_MESSAGE.Set_Name('JTF', 'Pub Qualifier API: End');
353: FND_MSG_PUB.Add;
354: END IF;

Line 353: FND_MSG_PUB.Add;

349: -- Debug Message
350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
351: THEN
352: FND_MESSAGE.Set_Name('JTF', 'Pub Qualifier API: End');
353: FND_MSG_PUB.Add;
354: END IF;
355:
356: -- Standard call to get message count and if count is 1, get message info.
357: FND_MSG_PUB.Count_And_Get

Line 357: FND_MSG_PUB.Count_And_Get

353: FND_MSG_PUB.Add;
354: END IF;
355:
356: -- Standard call to get message count and if count is 1, get message info.
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data
360: );
361:

Line 369: FND_MSG_PUB.Count_And_Get

365: WHEN FND_API.G_EXC_ERROR THEN
366: ROLLBACK TO UPDATE_QUALIFIER_PUB;
367: x_return_status := FND_API.G_RET_STS_ERROR ;
368:
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373:

Line 378: FND_MSG_PUB.Count_And_Get

374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: ROLLBACK TO UPDATE_QUALIFIER_PUB;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377:
378: FND_MSG_PUB.Count_And_Get
379: ( p_count => x_msg_count,
380: p_data => x_msg_data
381: );
382:

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

384: WHEN OTHERS THEN
385: ROLLBACK TO UPDATE_QUALIFIER_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387:
388: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
390: END IF;
391:
392: FND_MSG_PUB.Count_And_Get

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

385: ROLLBACK TO UPDATE_QUALIFIER_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387:
388: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
390: END IF;
391:
392: FND_MSG_PUB.Count_And_Get
393: ( p_count => x_msg_count,

Line 392: FND_MSG_PUB.Count_And_Get

388: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
390: END IF;
391:
392: FND_MSG_PUB.Count_And_Get
393: ( p_count => x_msg_count,
394: p_data => x_msg_data
395: );
396:

Line 470: FND_MSG_PUB.initialize;

466:
467: -- Initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean( p_init_msg_list )
469: THEN
470: FND_MSG_PUB.initialize;
471: END IF;
472:
473: -- Debug Message
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

470: FND_MSG_PUB.initialize;
471: END IF;
472:
473: -- Debug Message
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
475: THEN
476: FND_MESSAGE.Set_Name('JTF', 'Pub Qual API: Start');
477: FND_MSG_PUB.Add;
478: END IF;

Line 477: FND_MSG_PUB.Add;

473: -- Debug Message
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
475: THEN
476: FND_MESSAGE.Set_Name('JTF', 'Pub Qual API: Start');
477: FND_MSG_PUB.Add;
478: END IF;
479:
480: -------------------------------------------------------------------------------------------------------
481: -- Start of API body.

Line 521: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

517: COMMIT WORK;
518: END IF;
519:
520: -- Debug Message
521: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
522: THEN
523: FND_MESSAGE.Set_Name('JTF', 'Pub Qualifier API: End');
524: FND_MSG_PUB.Add;
525: END IF;

Line 524: FND_MSG_PUB.Add;

520: -- Debug Message
521: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
522: THEN
523: FND_MESSAGE.Set_Name('JTF', 'Pub Qualifier API: End');
524: FND_MSG_PUB.Add;
525: END IF;
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get

Line 528: FND_MSG_PUB.Count_And_Get

524: FND_MSG_PUB.Add;
525: END IF;
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get
529: ( p_count => x_msg_count,
530: p_data => x_msg_data
531: );
532:

Line 540: FND_MSG_PUB.Count_And_Get

536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO DELETE_QUALIFIER_PUB;
538: x_return_status := FND_API.G_RET_STS_ERROR ;
539:
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:

Line 549: FND_MSG_PUB.Count_And_Get

545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO DELETE_QUALIFIER_PUB;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: FND_MSG_PUB.Count_And_Get
550: ( p_count => x_msg_count,
551: p_data => x_msg_data
552: );
553:

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

555: WHEN OTHERS THEN
556: ROLLBACK TO DELETE_QUALIFIER_PUB;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558:
559: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
561: END IF;
562:
563: FND_MSG_PUB.Count_And_Get

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

556: ROLLBACK TO DELETE_QUALIFIER_PUB;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558:
559: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
561: END IF;
562:
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,

Line 563: FND_MSG_PUB.Count_And_Get

559: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
560: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
561: END IF;
562:
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567: