DBA Data[Home] [Help]

APPS.PSB_PAY_ELEMENT_OPTIONS_PVT dependencies on FND_MSG_PUB

Line 57: FND_MSG_PUB.initialize;

53:
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55:
56: if FND_API.to_Boolean (p_init_msg_list) then
57: FND_MSG_PUB.initialize;
58: end if;
59:
60: -- Initialize API return status to success
61:

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

105: end if;
106:
107: -- Standard call to get message count and if count is 1, get message info.
108:
109: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
110: p_data => p_msg_data);
111:
112: EXCEPTION
113:

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

116: rollback to INSERT_ROW_PVT;
117:
118: p_return_status := FND_API.G_RET_STS_ERROR;
119:
120: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
121: p_data => p_msg_data);
122:
123:
124: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

126: rollback to INSERT_ROW_PVT;
127:
128: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129:
130: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
131: p_data => p_msg_data);
132:
133:
134: when OTHERS then

Line 140: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

136: rollback to INSERT_ROW_PVT;
137:
138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139:
140: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
141:
142: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
143: l_api_name);
144: end if;

Line 142: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139:
140: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
141:
142: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
143: l_api_name);
144: end if;
145:
146: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

142: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
143: l_api_name);
144: end if;
145:
146: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
147: p_data => p_msg_data);
148:
149: END INSERT_ROW;
150:

Line 192: FND_MSG_PUB.initialize;

188:
189: -- Initialize message list if p_init_msg_list is set to TRUE.
190:
191: if FND_API.to_Boolean (p_init_msg_list) then
192: FND_MSG_PUB.initialize;
193: end if;
194:
195: -- Initialize API return status to success
196:

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

220: end if;
221:
222: -- Standard call to get message count and if count is 1, get message info.
223:
224: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
225: p_data => p_msg_data);
226:
227: EXCEPTION
228:

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

231: rollback to UPDATE_ROW_PVT;
232:
233: p_return_status := FND_API.G_RET_STS_ERROR;
234:
235: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
236: p_data => p_msg_data);
237:
238:
239: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

241: rollback to UPDATE_ROW_PVT;
242:
243: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244:
245: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
246: p_data => p_msg_data);
247:
248:
249: when OTHERS then

Line 255: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

251: rollback to UPDATE_ROW_PVT;
252:
253: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254:
255: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
256:
257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
258: l_api_name);
259: end if;

Line 257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

253: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254:
255: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
256:
257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
258: l_api_name);
259: end if;
260:
261: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
258: l_api_name);
259: end if;
260:
261: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
262: p_data => p_msg_data);
263:
264: END UPDATE_ROW;
265:

Line 302: FND_MSG_PUB.initialize;

298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300:
301: if FND_API.to_Boolean (p_init_msg_list) then
302: FND_MSG_PUB.initialize;
303: end if;
304:
305: --Deleting detail record from psb_pay_element_options and
306: --from psb_pay_element_rates to maintain the isolated delete

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

321: end if;
322:
323: -- Standard call to get message count and if count is 1, get message info.
324:
325: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
326: p_data => p_msg_data);
327:
328: -- Standard check of p_commit.
329:

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

339: rollback to DELETE_ROW_PVT;
340:
341: p_return_status := FND_API.G_RET_STS_ERROR;
342:
343: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
344: p_data => p_msg_data);
345:
346:
347: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

349: rollback to DELETE_ROW_PVT;
350:
351: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352:
353: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
354: p_data => p_msg_data);
355:
356:
357: when OTHERS then

Line 363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

359: rollback to DELETE_ROW_PVT;
360:
361: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
364:
365: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
366: l_api_name);
367: end if;

Line 365: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

361: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
364:
365: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
366: l_api_name);
367: end if;
368:
369: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

365: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
366: l_api_name);
367: end if;
368:
369: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
370: p_data => p_msg_data);
371: END DELETE_ROW;
372:
373: PROCEDURE LOCK_ROW(

Line 417: FND_MSG_PUB.initialize ;

413: END IF;
414: --
415:
416: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
417: FND_MSG_PUB.initialize ;
418: END IF;
419: --
420: p_return_status := FND_API.G_RET_STS_SUCCESS ;
421: p_row_locked := FND_API.G_TRUE ;

Line 429: FND_MSG_PUB.Add;

425: FETCH C INTO Recinfo;
426: IF (C%NOTFOUND) then
427: CLOSE C;
428: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR ;
431: END IF;
432:
433: IF

Line 455: FND_MSG_PUB.Add;

451: THEN
452: Null;
453: ELSE
454: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
455: FND_MSG_PUB.Add;
456: RAISE FND_API.G_EXC_ERROR ;
457: END IF;
458:
459: --

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

460: IF FND_API.To_Boolean ( p_commit ) THEN
461: COMMIT WORK;
462: END iF;
463: --
464: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
465: p_data => p_msg_data );
466: --
467: EXCEPTION
468: --

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

470: --
471: ROLLBACK TO Lock_Row_Pvt ;
472: p_row_locked := FND_API.G_FALSE;
473: p_return_status := FND_API.G_RET_STS_ERROR;
474: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
475: p_data => p_msg_data );
476: --
477: WHEN FND_API.G_EXC_ERROR THEN
478: --

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

477: WHEN FND_API.G_EXC_ERROR THEN
478: --
479: ROLLBACK TO Lock_Row_Pvt ;
480: p_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
482: p_data => p_msg_data );
483: --
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: --

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

484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: --
486: ROLLBACK TO Lock_Row_Pvt ;
487: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
489: p_data => p_msg_data );
490: --
491: WHEN OTHERS THEN
492: --

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

492: --
493: ROLLBACK TO Lock_Row_Pvt ;
494: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: --
496: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
497: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
498: l_api_name);
499: END if;
500: --

Line 497: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

493: ROLLBACK TO Lock_Row_Pvt ;
494: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: --
496: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
497: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
498: l_api_name);
499: END if;
500: --
501: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

497: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
498: l_api_name);
499: END if;
500: --
501: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
502: p_data => p_msg_data );
503: END LOCK_ROW;
504:
505:

Line 559: FND_MSG_PUB.initialize ;

555: END IF;
556: --
557:
558: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
559: FND_MSG_PUB.initialize ;
560: END IF;
561: --
562: p_return_status := FND_API.G_RET_STS_SUCCESS ;
563: --

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

582: IF FND_API.To_Boolean ( p_commit ) THEN
583: COMMIT WORK;
584: END iF;
585: --
586: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
587: p_data => p_msg_data );
588: --
589: EXCEPTION
590: --

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

591: WHEN FND_API.G_EXC_ERROR THEN
592: --
593: ROLLBACK TO Check_Unique_Pvt ;
594: p_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
596: p_data => p_msg_data );
597: --
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: --

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

598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: --
600: ROLLBACK TO Check_Unique_Pvt ;
601: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
603: p_data => p_msg_data );
604: --
605: WHEN OTHERS THEN
606: --

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

606: --
607: ROLLBACK TO Check_Unique_Pvt ;
608: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: --
610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
611: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
612: l_api_name);
613: END if;
614: --

Line 611: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

607: ROLLBACK TO Check_Unique_Pvt ;
608: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: --
610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
611: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
612: l_api_name);
613: END if;
614: --
615: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

611: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
612: l_api_name);
613: END if;
614: --
615: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
616: p_data => p_msg_data );
617: --
618: END Check_Unique;
619:

Line 670: FND_MSG_PUB.initialize ;

666: END IF;
667: --
668:
669: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
670: FND_MSG_PUB.initialize ;
671: END IF;
672: --
673: p_return_status := FND_API.G_RET_STS_SUCCESS ;
674: --

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

694: IF FND_API.To_Boolean ( p_commit ) THEN
695: COMMIT WORK;
696: END iF;
697: --
698: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
699: p_data => p_msg_data );
700:
701: EXCEPTION
702: --

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

703: WHEN FND_API.G_EXC_ERROR THEN
704: --
705: ROLLBACK TO Check_References_Pvt ;
706: p_return_status := FND_API.G_RET_STS_ERROR;
707: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
708: p_data => p_msg_data );
709: --
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: --

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

710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: --
712: ROLLBACK TO Check_References_Pvt ;
713: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
715: p_data => p_msg_data );
716: --
717: WHEN OTHERS THEN
718: --

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

718: --
719: ROLLBACK TO Check_References_Pvt ;
720: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: --
722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
723: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
724: l_api_name);
725: END if;
726: --

Line 723: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

719: ROLLBACK TO Check_References_Pvt ;
720: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: --
722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
723: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
724: l_api_name);
725: END if;
726: --
727: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

723: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
724: l_api_name);
725: END if;
726: --
727: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
728: p_data => p_msg_data );
729: --
730: END Check_References;
731: