DBA Data[Home] [Help]

APPS.PSB_ALLOCRULE_PERCENTS_PVT dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60:
61: if FND_API.to_Boolean (p_init_msg_list) then
62: FND_MSG_PUB.initialize;
63: end if;
64:
65: -- Initialize API return status to success
66:

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

200: end if;
201:
202: -- Standard call to get message count and if count is 1, get message info.
203:
204: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
205: p_data => p_msg_data);
206:
207: EXCEPTION
208:

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

211: rollback to Insert_Row_Pvt;
212:
213: p_return_status := FND_API.G_RET_STS_ERROR;
214:
215: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
216: p_data => p_msg_data);
217:
218:
219: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

221: rollback to Insert_Row_Pvt;
222:
223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224:
225: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
226: p_data => p_msg_data);
227:
228:
229: when OTHERS then

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

231: rollback to Insert_Row_Pvt;
232:
233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234:
235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
236:
237: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
238: l_api_name);
239: end if;

Line 237: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

233: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234:
235: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
236:
237: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
238: l_api_name);
239: end if;
240:
241: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

237: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
238: l_api_name);
239: end if;
240:
241: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
242: p_data => p_msg_data);
243:
244: END Insert_Row;
245:

Line 292: FND_MSG_PUB.initialize;

288:
289: -- Initialize message list if p_init_msg_list is set to TRUE.
290:
291: if FND_API.to_Boolean (p_init_msg_list) then
292: FND_MSG_PUB.initialize;
293: end if;
294:
295: -- Initialize API return status to success
296:

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

366: end if;
367:
368: -- Standard call to get message count and if count is 1, get message info.
369:
370: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
371: p_data => p_msg_data);
372:
373: EXCEPTION
374:

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

377: rollback to Update_Row_Pvt;
378:
379: p_return_status := FND_API.G_RET_STS_ERROR;
380:
381: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
382: p_data => p_msg_data);
383:
384:
385: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

387: rollback to Update_Row_Pvt;
388:
389: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390:
391: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
392: p_data => p_msg_data);
393:
394:
395: when OTHERS then

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

397: rollback to Update_Row_Pvt;
398:
399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400:
401: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
402:
403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
404: l_api_name);
405: end if;

Line 403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400:
401: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
402:
403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
404: l_api_name);
405: end if;
406:
407: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
404: l_api_name);
405: end if;
406:
407: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
408: p_data => p_msg_data);
409:
410: END Update_Row;
411:

Line 448: FND_MSG_PUB.initialize;

444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446:
447: if FND_API.to_Boolean (p_init_msg_list) then
448: FND_MSG_PUB.initialize;
449: end if;
450:
451: -- Initialize API return status to success
452:

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

471: end if;
472:
473: -- Standard call to get message count and if count is 1, get message info.
474:
475: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
476: p_data => p_msg_data);
477:
478: EXCEPTION
479:

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

482: rollback to Delete_Row_Pvt;
483:
484: p_return_status := FND_API.G_RET_STS_ERROR;
485:
486: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
487: p_data => p_msg_data);
488:
489:
490: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

492: rollback to Delete_Row_Pvt;
493:
494: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495:
496: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
497: p_data => p_msg_data);
498:
499:
500: when OTHERS then

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

502: rollback to Delete_Row_Pvt;
503:
504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505:
506: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
507:
508: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
509: l_api_name);
510: end if;

Line 508: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

504: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505:
506: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
507:
508: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
509: l_api_name);
510: end if;
511:
512: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

508: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
509: l_api_name);
510: end if;
511:
512: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
513: p_data => p_msg_data);
514:
515: END Delete_Row;
516:

Line 571: FND_MSG_PUB.initialize;

567:
568: -- Initialize message list if p_init_msg_list is set to TRUE.
569:
570: if FND_API.to_Boolean (p_init_msg_list) then
571: FND_MSG_PUB.initialize;
572: end if;
573:
574: -- Initialize API return status to success
575:

Line 588: FND_MSG_PUB.Add;

584:
585: IF (C%NOTFOUND) THEN
586: CLOSE C;
587: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
588: FND_MSG_PUB.Add;
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: IF ((Recinfo.allocation_rule_id = P_ALLOCATION_RULE_ID) AND

Line 602: FND_MSG_PUB.Add;

598: ((Recinfo.percent IS NULL ) AND (P_SEMI_ANNUAL IS NULL)))) THEN
599: l_lock_row1 := 1;
600: ELSE
601: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
602: FND_MSG_PUB.Add;
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605:
606: FETCH C INTO Recinfo;

Line 611: FND_MSG_PUB.Add;

607:
608: IF (C%NOTFOUND) THEN
609: CLOSE C;
610: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
611: FND_MSG_PUB.Add;
612: RAISE FND_API.G_EXC_ERROR;
613: END IF;
614:
615: IF ((Recinfo.allocation_rule_id = P_ALLOCATION_RULE_ID) AND

Line 625: FND_MSG_PUB.Add;

621: ((Recinfo.percent IS NULL ) AND (P_QUARTERLY IS NULL)))) THEN
622: l_lock_row2 := 1;
623: ELSE
624: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
625: FND_MSG_PUB.Add;
626: RAISE FND_API.G_EXC_ERROR;
627: END IF;
628:
629: FETCH C INTO Recinfo;

Line 634: FND_MSG_PUB.Add;

630:
631: IF (C%NOTFOUND) THEN
632: CLOSE C;
633: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
634: FND_MSG_PUB.Add;
635: RAISE FND_API.G_EXC_ERROR;
636: END IF;
637:
638: IF ((Recinfo.allocation_rule_id = P_ALLOCATION_RULE_ID) AND

Line 648: FND_MSG_PUB.Add;

644: ((Recinfo.percent IS NULL ) AND (P_MONTHLY IS NULL)))) THEN
645: l_lock_row3 := 1;
646: ELSE
647: FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
648: FND_MSG_PUB.Add;
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651:
652:

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

661: end if;
662:
663: -- Standard call to get message count and if count is 1, get message info.
664:
665: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
666: p_data => p_msg_data);
667:
668: EXCEPTION
669:

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

672: rollback to Lock_Row_Pvt;
673:
674: p_return_status := FND_API.G_RET_STS_ERROR;
675:
676: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
677: p_data => p_msg_data);
678:
679:
680: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

682: rollback to Lock_Row_Pvt;
683:
684: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685:
686: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
687: p_data => p_msg_data);
688:
689:
690: when OTHERS then

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

692: rollback to Lock_Row_Pvt;
693:
694: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695:
696: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
697:
698: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
699: l_api_name);
700: end if;

Line 698: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

694: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695:
696: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
697:
698: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
699: l_api_name);
700: end if;
701:
702: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

698: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
699: l_api_name);
700: end if;
701:
702: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
703: p_data => p_msg_data);
704:
705: END Lock_Row;
706: