DBA Data[Home] [Help]

APPS.PSB_SET_RELATION_PVT dependencies on FND_MSG_PUB

Line 78: FND_MSG_PUB.initialize ;

74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
75: END IF;
76: --
77: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize ;
79: END IF;
80: --
81: p_return_status := FND_API.G_RET_STS_SUCCESS ;
82: --

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

173: IF FND_API.To_Boolean ( p_commit ) THEN
174: COMMIT WORK;
175: END iF;
176: --
177: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
178: p_data => p_msg_data );
179: --
180: EXCEPTION
181: --

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

182: WHEN FND_API.G_EXC_ERROR THEN
183: --
184: ROLLBACK TO Insert_Row_Pvt ;
185: p_return_status := FND_API.G_RET_STS_ERROR;
186: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
187: p_data => p_msg_data );
188: --
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: --

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

189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: --
191: ROLLBACK TO Insert_Row_Pvt ;
192: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
194: p_data => p_msg_data );
195: --
196: WHEN OTHERS THEN
197: --

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

197: --
198: ROLLBACK TO Insert_Row_Pvt ;
199: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: --
201: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
202: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
203: l_api_name);
204: END if;
205: --

Line 202: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

198: ROLLBACK TO Insert_Row_Pvt ;
199: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: --
201: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
202: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
203: l_api_name);
204: END if;
205: --
206: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

202: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
203: l_api_name);
204: END if;
205: --
206: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
207: p_data => p_msg_data );
208: --
209: END Insert_Row;
210: /* ----------------------------------------------------------------------- */

Line 275: FND_MSG_PUB.initialize ;

271: END IF;
272: --
273:
274: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
275: FND_MSG_PUB.initialize ;
276: END IF;
277: --
278: p_return_status := FND_API.G_RET_STS_SUCCESS ;
279: p_row_locked := FND_API.G_TRUE ;

Line 295: FND_MSG_PUB.Add;

291: --
292: IF (C%NOTFOUND) THEN
293: CLOSE C;
294: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
295: FND_MSG_PUB.Add;
296: RAISE FND_API.G_EXC_ERROR ;
297: END IF;
298: --
299: CLOSE C;

Line 361: FND_MSG_PUB.Add;

357: THEN
358: Null;
359: ELSE
360: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
361: FND_MSG_PUB.Add;
362: RAISE FND_API.G_EXC_ERROR ;
363: END IF;
364: --
365: IF FND_API.To_Boolean ( p_commit ) THEN

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

365: IF FND_API.To_Boolean ( p_commit ) THEN
366: COMMIT WORK;
367: END iF;
368: --
369: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
370: p_data => p_msg_data );
371: --
372: EXCEPTION
373: --

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

375: --
376: ROLLBACK TO Lock_Row_Pvt ;
377: p_row_locked := FND_API.G_FALSE;
378: p_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
380: p_data => p_msg_data );
381: --
382: WHEN FND_API.G_EXC_ERROR THEN
383: --

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

382: WHEN FND_API.G_EXC_ERROR THEN
383: --
384: ROLLBACK TO Lock_Row_Pvt ;
385: p_return_status := FND_API.G_RET_STS_ERROR;
386: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
387: p_data => p_msg_data );
388: --
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: --

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

389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: --
391: ROLLBACK TO Lock_Row_Pvt ;
392: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
394: p_data => p_msg_data );
395: --
396: WHEN OTHERS THEN
397: --

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

397: --
398: ROLLBACK TO Lock_Row_Pvt ;
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: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
403: l_api_name);
404: END if;
405: --

Line 402: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

398: ROLLBACK TO Lock_Row_Pvt ;
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: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
403: l_api_name);
404: END if;
405: --
406: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

402: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
403: l_api_name);
404: END if;
405: --
406: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
407: p_data => p_msg_data );
408: --
409: END Lock_Row;
410: /* ----------------------------------------------------------------------- */

Line 473: FND_MSG_PUB.initialize ;

469: END IF;
470: --
471:
472: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
473: FND_MSG_PUB.initialize ;
474: END IF;
475: --
476: p_return_status := FND_API.G_RET_STS_SUCCESS ;
477:

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

529: IF FND_API.To_Boolean ( p_commit ) THEN
530: COMMIT WORK;
531: END iF;
532: --
533: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
534: p_data => p_msg_data );
535: --
536: EXCEPTION
537: --

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

538: WHEN FND_API.G_EXC_ERROR THEN
539: --
540: ROLLBACK TO Update_Row_Pvt ;
541: p_return_status := FND_API.G_RET_STS_ERROR;
542: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
543: p_data => p_msg_data );
544: --
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: --

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

545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: --
547: ROLLBACK TO Update_Row_Pvt ;
548: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
550: p_data => p_msg_data );
551: --
552: WHEN OTHERS THEN
553: --

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

553: --
554: ROLLBACK TO Update_Row_Pvt ;
555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: --
557: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
558: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
559: l_api_name);
560: END if;
561: --

Line 558: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

554: ROLLBACK TO Update_Row_Pvt ;
555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: --
557: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
558: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
559: l_api_name);
560: END if;
561: --
562: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

558: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
559: l_api_name);
560: END if;
561: --
562: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
563: p_data => p_msg_data );
564: --
565: END Update_Row;
566: /* ----------------------------------------------------------------------- */

Line 603: FND_MSG_PUB.initialize ;

599: END IF;
600: --
601:
602: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
603: FND_MSG_PUB.initialize ;
604: END IF;
605: --
606: p_return_status := FND_API.G_RET_STS_SUCCESS ;
607: --

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

617: IF FND_API.To_Boolean ( p_commit ) THEN
618: COMMIT WORK;
619: END iF;
620: --
621: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
622: p_data => p_msg_data );
623:
624: EXCEPTION
625: --

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

626: WHEN FND_API.G_EXC_ERROR THEN
627: --
628: ROLLBACK TO Delete_Row_Pvt ;
629: p_return_status := FND_API.G_RET_STS_ERROR;
630: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
631: p_data => p_msg_data );
632: --
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: --

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

633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: --
635: ROLLBACK TO Delete_Row_Pvt ;
636: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
638: p_data => p_msg_data );
639: --
640: WHEN OTHERS THEN
641: --

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

641: --
642: ROLLBACK TO Delete_Row_Pvt ;
643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: --
645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
647: l_api_name);
648: END if;
649: --

Line 646: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

642: ROLLBACK TO Delete_Row_Pvt ;
643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: --
645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
647: l_api_name);
648: END if;
649: --
650: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

646: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
647: l_api_name);
648: END if;
649: --
650: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
651: p_data => p_msg_data );
652: --
653: END Delete_Row;
654: /* ----------------------------------------------------------------------- */

Line 693: FND_MSG_PUB.initialize ;

689: END IF;
690: --
691:
692: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
693: FND_MSG_PUB.initialize ;
694: END IF;
695: --
696: p_return_status := FND_API.G_RET_STS_SUCCESS ;
697: --

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

777: IF FND_API.To_Boolean ( p_commit ) THEN
778: COMMIT WORK;
779: END iF;
780: --
781: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
782: p_data => p_msg_data );
783: --
784: EXCEPTION
785: --

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

786: WHEN FND_API.G_EXC_ERROR THEN
787: --
788: ROLLBACK TO Delete_Entity_Relation_Pvt ;
789: p_return_status := FND_API.G_RET_STS_ERROR;
790: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
791: p_data => p_msg_data );
792: --
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: --

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

793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: --
795: ROLLBACK TO Delete_Entity_Relation_Pvt ;
796: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
798: p_data => p_msg_data );
799: --
800: WHEN OTHERS THEN
801: --

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

801: --
802: ROLLBACK TO Delete_Entity_Relation_Pvt ;
803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: --
805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
806: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
807: l_api_name);
808: END if;
809: --

Line 806: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

802: ROLLBACK TO Delete_Entity_Relation_Pvt ;
803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: --
805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
806: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
807: l_api_name);
808: END if;
809: --
810: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

806: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
807: l_api_name);
808: END if;
809: --
810: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
811: p_data => p_msg_data );
812: --
813:
814:

Line 913: FND_MSG_PUB.initialize ;

909: END IF;
910: --
911:
912: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
913: FND_MSG_PUB.initialize ;
914: END IF;
915: --
916: p_return_status := FND_API.G_RET_STS_SUCCESS ;
917: --

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

947: IF FND_API.To_Boolean ( p_commit ) THEN
948: COMMIT WORK;
949: END iF;
950: --
951: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
952: p_data => p_msg_data );
953: --
954: EXCEPTION
955: --

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

956: WHEN FND_API.G_EXC_ERROR THEN
957: --
958: ROLLBACK TO Check_Unique_Pvt ;
959: p_return_status := FND_API.G_RET_STS_ERROR;
960: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
961: p_data => p_msg_data );
962: --
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: --

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

963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: --
965: ROLLBACK TO Check_Unique_Pvt ;
966: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
968: p_data => p_msg_data );
969: --
970: WHEN OTHERS THEN
971: --

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

971: --
972: ROLLBACK TO Check_Unique_Pvt ;
973: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: --
975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
977: l_api_name);
978: END if;
979: --

Line 976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

972: ROLLBACK TO Check_Unique_Pvt ;
973: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: --
975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
977: l_api_name);
978: END if;
979: --
980: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

976: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
977: l_api_name);
978: END if;
979: --
980: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
981: p_data => p_msg_data );
982: --
983: END Check_Unique;
984: /* ----------------------------------------------------------------------- */