eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PARTIES_PVT dependencies on FND_MSG_PUB

Line 134: FND_MSG_PUB.initialize;

130: END IF;
131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133: IF FND_API.to_Boolean(p_init_msg_list) THEN
134: FND_MSG_PUB.initialize;
135: END IF;
136:
137: -- Initialize API return status to success
138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 336: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

332: COMMIT WORK;
333: END IF;
334:
335: -- Standard call to get message count and IF count is get message info.
336: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
337: p_data => x_msg_data );
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO Create_Customer_Pvt;

Line 342: FND_MSG_PUB.Count_And_Get

338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO Create_Customer_Pvt;
341: x_return_status := FND_API.G_RET_STS_ERROR ;
342: FND_MSG_PUB.Count_And_Get
343: (p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 349: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

345: );
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO Create_Customer_Pvt;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
350: p_data => x_msg_data );
351: WHEN OTHERS THEN
352: ROLLBACK TO Create_Customer_Pvt;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

350: p_data => x_msg_data );
351: WHEN OTHERS THEN
352: ROLLBACK TO Create_Customer_Pvt;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
357: l_api_name );
358: END IF;

Line 356: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

352: ROLLBACK TO Create_Customer_Pvt;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
357: l_api_name );
358: END IF;
359: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
360: p_data => x_msg_data );

Line 359: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

355: THEN
356: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
357: l_api_name );
358: END IF;
359: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
360: p_data => x_msg_data );
361:
362: END Create_Customer;
363:

Line 430: FND_MSG_PUB.initialize;

426: END IF;
427:
428: -- Initialize message list if p_init_msg_list is set to TRUE.
429: IF FND_API.to_Boolean(p_init_msg_list) THEN
430: FND_MSG_PUB.initialize;
431: END IF;
432:
433: -- Initialize API return status to success
434: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 505: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

501: COMMIT WORK;
502: END IF;
503:
504: -- Standard call to get message count and IF count is get message info.
505: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
506: p_data => x_msg_data );
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO Create_Contact_Pvt;

Line 516: FND_MSG_PUB.Count_And_Get

512: x_party_number := '';
513: x_phone_id := NULL;
514: x_email_id := NULL;
515: x_url_id := NULL;
516: FND_MSG_PUB.Count_And_Get
517: (p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 528: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

524: x_party_number := '';
525: x_phone_id := NULL;
526: x_email_id := NULL;
527: x_url_id := NULL;
528: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
529: p_data => x_msg_data );
530: WHEN OTHERS THEN
531: ROLLBACK TO Create_Contact_Pvt;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

534: x_party_number := '';
535: x_phone_id := NULL;
536: x_email_id := NULL;
537: x_url_id := NULL;
538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
541: l_api_name );
542: END IF;

Line 540: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

536: x_email_id := NULL;
537: x_url_id := NULL;
538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
541: l_api_name );
542: END IF;
543: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
544: p_data => x_msg_data );

Line 543: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

539: THEN
540: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
541: l_api_name );
542: END IF;
543: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
544: p_data => x_msg_data );
545: END Create_Contact;
546:
547:

Line 597: FND_MSG_PUB.initialize;

593: END IF;
594:
595: -- Initialize message list if p_init_msg_list is set to TRUE.
596: IF FND_API.to_Boolean(p_init_msg_list) THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600: -- Initialize API return status to success
601: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 639: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

635: COMMIT WORK;
636: END IF;
637:
638: -- Standard call to get message count and IF count is get message info.
639: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
640: p_data => x_msg_data );
641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: ROLLBACK TO Create_Person_Pvt;

Line 645: FND_MSG_PUB.Count_And_Get

641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: ROLLBACK TO Create_Person_Pvt;
644: x_return_status := FND_API.G_RET_STS_ERROR ;
645: FND_MSG_PUB.Count_And_Get
646: (p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 652: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

648: );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Create_Person_Pvt;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
653: p_data => x_msg_data );
654: WHEN OTHERS THEN
655: ROLLBACK TO Create_Person_Pvt;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

653: p_data => x_msg_data );
654: WHEN OTHERS THEN
655: ROLLBACK TO Create_Person_Pvt;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
658: THEN
659: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
660: l_api_name );
661: END IF;

Line 659: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

655: ROLLBACK TO Create_Person_Pvt;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
658: THEN
659: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
660: l_api_name );
661: END IF;
662: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
663: p_data => x_msg_data );

Line 662: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

658: THEN
659: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
660: l_api_name );
661: END IF;
662: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
663: p_data => x_msg_data );
664: END Create_Person;
665:
666: /*----------------------------------------------------------------*/

Line 714: FND_MSG_PUB.initialize;

710: END IF;
711:
712: -- Initialize message list if p_init_msg_list is set to TRUE.
713: IF FND_API.to_Boolean(p_init_msg_list) THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:
717: -- Initialize API return status to success
718: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 758: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

754: COMMIT WORK;
755: END IF;
756:
757: -- Standard call to get message count and IF count is get message info.
758: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
759: p_data => x_msg_data );
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO Create_Organization_Pvt;

Line 764: FND_MSG_PUB.Count_And_Get

760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO Create_Organization_Pvt;
763: x_return_status := FND_API.G_RET_STS_ERROR ;
764: FND_MSG_PUB.Count_And_Get
765: (p_count => x_msg_count,
766: p_data => x_msg_data
767: );
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 771: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

767: );
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769: ROLLBACK TO Create_Organization_Pvt;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
771: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
772: p_data => x_msg_data );
773: WHEN OTHERS THEN
774: ROLLBACK TO Create_Organization_Pvt;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

772: p_data => x_msg_data );
773: WHEN OTHERS THEN
774: ROLLBACK TO Create_Organization_Pvt;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
777: THEN
778: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
779: l_api_name );
780: END IF;

Line 778: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

774: ROLLBACK TO Create_Organization_Pvt;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
777: THEN
778: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
779: l_api_name );
780: END IF;
781: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
782: p_data => x_msg_data );

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

777: THEN
778: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
779: l_api_name );
780: END IF;
781: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
782: p_data => x_msg_data );
783: END Create_Organization;
784:
785: /*----------------------------------------------------------------*/

Line 839: FND_MSG_PUB.initialize;

835: END IF;
836:
837: -- Initialize message list if p_init_msg_list is set to TRUE.
838: IF FND_API.to_Boolean(p_init_msg_list) THEN
839: FND_MSG_PUB.initialize;
840: END IF;
841:
842: -- Initialize API return status to success
843: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 890: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

886: COMMIT WORK;
887: END IF;
888:
889: -- Standard call to get message count and IF count is get message info.
890: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
891: p_data => x_msg_data );
892: EXCEPTION
893: WHEN FND_API.G_EXC_ERROR THEN
894: ROLLBACK TO Create_Account_Pvt;

Line 896: FND_MSG_PUB.Count_And_Get

892: EXCEPTION
893: WHEN FND_API.G_EXC_ERROR THEN
894: ROLLBACK TO Create_Account_Pvt;
895: x_return_status := FND_API.G_RET_STS_ERROR ;
896: FND_MSG_PUB.Count_And_Get
897: (p_count => x_msg_count,
898: p_data => x_msg_data
899: );
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 903: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

899: );
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: ROLLBACK TO Create_Account_Pvt;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
904: p_data => x_msg_data );
905: WHEN OTHERS THEN
906: ROLLBACK TO Create_Account_Pvt;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

904: p_data => x_msg_data );
905: WHEN OTHERS THEN
906: ROLLBACK TO Create_Account_Pvt;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
911: l_api_name );
912: END IF;

Line 910: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

906: ROLLBACK TO Create_Account_Pvt;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
911: l_api_name );
912: END IF;
913: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
914: p_data => x_msg_data );

Line 913: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

909: THEN
910: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
911: l_api_name );
912: END IF;
913: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
914: p_data => x_msg_data );
915: END Create_Account;
916:
917:

Line 973: FND_MSG_PUB.initialize;

969: END IF;
970:
971: -- Initialize message list if p_init_msg_list is set to TRUE.
972: IF FND_API.to_Boolean(p_init_msg_list) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975:
976: -- Initialize API return status to success
977: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1025: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1021: COMMIT WORK;
1022: END IF;
1023:
1024: -- Standard call to get message count and IF count is get message info.
1025: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1026: p_data => x_msg_data );
1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO Create_Account_Pvt;

Line 1031: FND_MSG_PUB.Count_And_Get

1027: EXCEPTION
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO Create_Account_Pvt;
1030: x_return_status := FND_API.G_RET_STS_ERROR ;
1031: FND_MSG_PUB.Count_And_Get
1032: (p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1038: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1034: );
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: ROLLBACK TO Create_Account_Pvt;
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1038: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1039: p_data => x_msg_data );
1040: WHEN OTHERS THEN
1041: ROLLBACK TO Create_Account_Pvt;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1039: p_data => x_msg_data );
1040: WHEN OTHERS THEN
1041: ROLLBACK TO Create_Account_Pvt;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1044: THEN
1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1046: l_api_name );
1047: END IF;

Line 1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1041: ROLLBACK TO Create_Account_Pvt;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1043: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1044: THEN
1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1046: l_api_name );
1047: END IF;
1048: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1049: p_data => x_msg_data );

Line 1048: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1044: THEN
1045: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1046: l_api_name );
1047: END IF;
1048: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1049: p_data => x_msg_data );
1050: END Create_Account;
1051:
1052:

Line 1126: FND_MSG_PUB.initialize;

1122: END IF;
1123:
1124: -- Initialize message list if p_init_msg_list is set to TRUE.
1125: IF FND_API.to_Boolean(p_init_msg_list) THEN
1126: FND_MSG_PUB.initialize;
1127: END IF;
1128:
1129: -- Initialize API return status to success
1130: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1232: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1228: COMMIT WORK;
1229: END IF;
1230:
1231: -- Standard call to get message count and IF count is get message info.
1232: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1233: p_data => x_msg_data );
1234: EXCEPTION
1235: WHEN FND_API.G_EXC_ERROR THEN
1236: ROLLBACK TO Create_ContactPoints_Pvt;

Line 1241: FND_MSG_PUB.Count_And_Get

1237: x_return_status := FND_API.G_RET_STS_ERROR ;
1238: x_phone_id := NULL;
1239: x_email_id := NULL;
1240: x_url_id := NULL;
1241: FND_MSG_PUB.Count_And_Get
1242: (p_count => x_msg_count,
1243: p_data => x_msg_data
1244: );
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1251: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: x_phone_id := NULL;
1249: x_email_id := NULL;
1250: x_url_id := NULL;
1251: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1252: p_data => x_msg_data );
1253: WHEN OTHERS THEN
1254: ROLLBACK TO Create_ContactPoints_Pvt;
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1256: x_phone_id := NULL;
1257: x_email_id := NULL;
1258: x_url_id := NULL;
1259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1260: THEN
1261: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1262: l_api_name );
1263: END IF;

Line 1261: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1257: x_email_id := NULL;
1258: x_url_id := NULL;
1259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1260: THEN
1261: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1262: l_api_name );
1263: END IF;
1264: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1265: p_data => x_msg_data );

Line 1264: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1260: THEN
1261: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1262: l_api_name );
1263: END IF;
1264: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1265: p_data => x_msg_data );
1266: END Create_ContactPoints;
1267:
1268:

Line 1329: FND_MSG_PUB.initialize;

1325: END IF;
1326:
1327: -- Initialize message list if p_init_msg_list is set to TRUE.
1328: IF FND_API.to_Boolean(p_init_msg_list) THEN
1329: FND_MSG_PUB.initialize;
1330: END IF;
1331:
1332: -- Initialize API return status to success
1333: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1428: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1424: COMMIT WORK;
1425: END IF;
1426:
1427: -- Standard call to get message count and IF count is get message info.
1428: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1429: p_data => x_msg_data );
1430: EXCEPTION
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO Create_AddressRecords_Pvt;

Line 1438: FND_MSG_PUB.Count_And_Get

1434: x_location_id := NULL;
1435: x_party_site_id := NULL;
1436: x_party_site_number := NULL;
1437: x_party_site_use_id := NULL;
1438: FND_MSG_PUB.Count_And_Get
1439: (p_count => x_msg_count,
1440: p_data => x_msg_data
1441: );
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1449: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1445: x_location_id := NULL;
1446: x_party_site_id := NULL;
1447: x_party_site_number := NULL;
1448: x_party_site_use_id := NULL;
1449: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1450: p_data => x_msg_data );
1451: WHEN OTHERS THEN
1452: ROLLBACK TO Create_AddressRecords_Pvt;
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1454: x_location_id := NULL;
1455: x_party_site_id := NULL;
1456: x_party_site_number := NULL;
1457: x_party_site_use_id := NULL;
1458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1459: THEN
1460: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1461: l_api_name );
1462: END IF;

Line 1460: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1456: x_party_site_number := NULL;
1457: x_party_site_use_id := NULL;
1458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1459: THEN
1460: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1461: l_api_name );
1462: END IF;
1463: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1464: p_data => x_msg_data );

Line 1463: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1459: THEN
1460: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1461: l_api_name );
1462: END IF;
1463: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1464: p_data => x_msg_data );
1465: END Create_AddressRecords;
1466:
1467: /*----------------------------------------------------------------*/

Line 1514: FND_MSG_PUB.initialize;

1510: END IF;
1511:
1512: -- Initialize message list if p_init_msg_list is set to TRUE.
1513: IF FND_API.to_Boolean(p_init_msg_list) THEN
1514: FND_MSG_PUB.initialize;
1515: END IF;
1516:
1517: -- Initialize API return status to success
1518: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1596: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1592: COMMIT WORK;
1593: END IF;
1594:
1595: -- Standard call to get message count and IF count is get message info.
1596: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1597: p_data => x_msg_data );
1598: EXCEPTION
1599: WHEN FND_API.G_EXC_ERROR THEN
1600: ROLLBACK TO Create_Address_Pvt;

Line 1602: FND_MSG_PUB.Count_And_Get

1598: EXCEPTION
1599: WHEN FND_API.G_EXC_ERROR THEN
1600: ROLLBACK TO Create_Address_Pvt;
1601: x_return_status := FND_API.G_RET_STS_ERROR ;
1602: FND_MSG_PUB.Count_And_Get
1603: (p_count => x_msg_count,
1604: p_data => x_msg_data
1605: );
1606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1609: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1605: );
1606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1607: ROLLBACK TO Create_Address_Pvt;
1608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1609: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1610: p_data => x_msg_data );
1611: WHEN OTHERS THEN
1612: ROLLBACK TO Create_Address_Pvt;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1610: p_data => x_msg_data );
1611: WHEN OTHERS THEN
1612: ROLLBACK TO Create_Address_Pvt;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1617: l_api_name );
1618: END IF;

Line 1616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1612: ROLLBACK TO Create_Address_Pvt;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1617: l_api_name );
1618: END IF;
1619: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1620: p_data => x_msg_data );

Line 1619: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1615: THEN
1616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1617: l_api_name );
1618: END IF;
1619: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1620: p_data => x_msg_data );
1621: END Create_Address;
1622:
1623: /*----------------------------------------------------------------*/

Line 1670: FND_MSG_PUB.initialize;

1666: END IF;
1667:
1668: -- Initialize message list if p_init_msg_list is set to TRUE.
1669: IF FND_API.to_Boolean(p_init_msg_list) THEN
1670: FND_MSG_PUB.initialize;
1671: END IF;
1672:
1673: -- Initialize API return status to success
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1716: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1712: COMMIT WORK;
1713: END IF;
1714:
1715: -- Standard call to get message count and IF count is get message info.
1716: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1717: p_data => x_msg_data );
1718: EXCEPTION
1719: WHEN FND_API.G_EXC_ERROR THEN
1720: ROLLBACK TO Create_Relationship_Pvt;

Line 1722: FND_MSG_PUB.Count_And_Get

1718: EXCEPTION
1719: WHEN FND_API.G_EXC_ERROR THEN
1720: ROLLBACK TO Create_Relationship_Pvt;
1721: x_return_status := FND_API.G_RET_STS_ERROR ;
1722: FND_MSG_PUB.Count_And_Get
1723: (p_count => x_msg_count,
1724: p_data => x_msg_data
1725: );
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1729: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1725: );
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: ROLLBACK TO Create_Relationship_Pvt;
1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1729: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1730: p_data => x_msg_data );
1731: WHEN OTHERS THEN
1732: ROLLBACK TO Create_Relationship_Pvt;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1730: p_data => x_msg_data );
1731: WHEN OTHERS THEN
1732: ROLLBACK TO Create_Relationship_Pvt;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1735: THEN
1736: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1737: l_api_name );
1738: END IF;

Line 1736: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1732: ROLLBACK TO Create_Relationship_Pvt;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1735: THEN
1736: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1737: l_api_name );
1738: END IF;
1739: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1740: p_data => x_msg_data );

Line 1739: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1735: THEN
1736: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1737: l_api_name );
1738: END IF;
1739: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1740: p_data => x_msg_data );
1741: END Create_Relationship;
1742:
1743:

Line 1795: FND_MSG_PUB.initialize;

1791: END IF;
1792:
1793: -- Initialize message list if p_init_msg_list is set to TRUE.
1794: IF FND_API.to_Boolean(p_init_msg_list) THEN
1795: FND_MSG_PUB.initialize;
1796: END IF;
1797:
1798: -- Initialize API return status to success
1799: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1858: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1854: COMMIT WORK;
1855: END IF;
1856:
1857: -- Standard call to get message count and IF count is get message info.
1858: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1859: p_data => x_msg_data );
1860: EXCEPTION
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: ROLLBACK TO Update_Party_Pvt;

Line 1864: FND_MSG_PUB.Count_And_Get

1860: EXCEPTION
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: ROLLBACK TO Update_Party_Pvt;
1863: x_return_status := FND_API.G_RET_STS_ERROR ;
1864: FND_MSG_PUB.Count_And_Get
1865: (p_count => x_msg_count,
1866: p_data => x_msg_data
1867: );
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1871: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1867: );
1868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1869: ROLLBACK TO Update_Party_Pvt;
1870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1871: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1872: p_data => x_msg_data );
1873: WHEN OTHERS THEN
1874: ROLLBACK TO Update_Party_Pvt;
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1876: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1872: p_data => x_msg_data );
1873: WHEN OTHERS THEN
1874: ROLLBACK TO Update_Party_Pvt;
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1876: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1877: THEN
1878: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1879: l_api_name );
1880: END IF;

Line 1878: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1874: ROLLBACK TO Update_Party_Pvt;
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1876: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1877: THEN
1878: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1879: l_api_name );
1880: END IF;
1881: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1882: p_data => x_msg_data );

Line 1881: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1877: THEN
1878: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1879: l_api_name );
1880: END IF;
1881: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1882: p_data => x_msg_data );
1883: END Update_Party;
1884:
1885: /*----------------------------------------------------------------*/

Line 1933: FND_MSG_PUB.initialize;

1929: END IF;
1930:
1931: -- Initialize message list if p_init_msg_list is set to TRUE.
1932: IF FND_API.to_Boolean(p_init_msg_list) THEN
1933: FND_MSG_PUB.initialize;
1934: END IF;
1935:
1936: -- Initialize API return status to success
1937: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1974: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1970: COMMIT WORK;
1971: END IF;
1972:
1973: -- Standard call to get message count and IF count is get message info.
1974: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1975: p_data => x_msg_data );
1976: EXCEPTION
1977: WHEN FND_API.G_EXC_ERROR THEN
1978: ROLLBACK TO Update_Person_Pvt;

Line 1980: FND_MSG_PUB.Count_And_Get

1976: EXCEPTION
1977: WHEN FND_API.G_EXC_ERROR THEN
1978: ROLLBACK TO Update_Person_Pvt;
1979: x_return_status := FND_API.G_RET_STS_ERROR ;
1980: FND_MSG_PUB.Count_And_Get
1981: (p_count => x_msg_count,
1982: p_data => x_msg_data
1983: );
1984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1987: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1983: );
1984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1985: ROLLBACK TO Update_Person_Pvt;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1987: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1988: p_data => x_msg_data );
1989: WHEN OTHERS THEN
1990: ROLLBACK TO Update_Person_Pvt;
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1988: p_data => x_msg_data );
1989: WHEN OTHERS THEN
1990: ROLLBACK TO Update_Person_Pvt;
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1993: THEN
1994: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1995: l_api_name );
1996: END IF;

Line 1994: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

1990: ROLLBACK TO Update_Person_Pvt;
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1993: THEN
1994: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1995: l_api_name );
1996: END IF;
1997: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1998: p_data => x_msg_data );

Line 1997: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1993: THEN
1994: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
1995: l_api_name );
1996: END IF;
1997: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1998: p_data => x_msg_data );
1999:
2000: END Update_Person;
2001:

Line 2051: FND_MSG_PUB.initialize;

2047: END IF;
2048:
2049: -- Initialize message list if p_init_msg_list is set to TRUE.
2050: IF FND_API.to_Boolean(p_init_msg_list) THEN
2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:
2054: -- Initialize API return status to success
2055: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2092: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2088: COMMIT WORK;
2089: END IF;
2090:
2091: -- Standard call to get message count and IF count is get message info.
2092: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2093: p_data => x_msg_data );
2094: EXCEPTION
2095: WHEN FND_API.G_EXC_ERROR THEN
2096: ROLLBACK TO Update_Organization_Pvt;

Line 2098: FND_MSG_PUB.Count_And_Get

2094: EXCEPTION
2095: WHEN FND_API.G_EXC_ERROR THEN
2096: ROLLBACK TO Update_Organization_Pvt;
2097: x_return_status := FND_API.G_RET_STS_ERROR ;
2098: FND_MSG_PUB.Count_And_Get
2099: (p_count => x_msg_count,
2100: p_data => x_msg_data
2101: );
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2105: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2101: );
2102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2103: ROLLBACK TO Update_Organization_Pvt;
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2105: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2106: p_data => x_msg_data );
2107: WHEN OTHERS THEN
2108: ROLLBACK TO Update_Organization_Pvt;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2106: p_data => x_msg_data );
2107: WHEN OTHERS THEN
2108: ROLLBACK TO Update_Organization_Pvt;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2111: THEN
2112: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2113: l_api_name );
2114: END IF;

Line 2112: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

2108: ROLLBACK TO Update_Organization_Pvt;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2110: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2111: THEN
2112: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2113: l_api_name );
2114: END IF;
2115: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2116: p_data => x_msg_data );

Line 2115: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2111: THEN
2112: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2113: l_api_name );
2114: END IF;
2115: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2116: p_data => x_msg_data );
2117:
2118: END Update_Organization;
2119:

Line 2168: FND_MSG_PUB.initialize;

2164: END IF;
2165:
2166: -- Initialize message list if p_init_msg_list is set to TRUE.
2167: IF FND_API.to_Boolean(p_init_msg_list) THEN
2168: FND_MSG_PUB.initialize;
2169: END IF;
2170:
2171: -- Initialize API return status to success
2172: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2205: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2201: COMMIT WORK;
2202: END IF;
2203:
2204: -- Standard call to get message count and IF count is get message info.
2205: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2206: p_data => x_msg_data );
2207: EXCEPTION
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: ROLLBACK TO Update_Account_Pvt;

Line 2211: FND_MSG_PUB.Count_And_Get

2207: EXCEPTION
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: ROLLBACK TO Update_Account_Pvt;
2210: x_return_status := FND_API.G_RET_STS_ERROR ;
2211: FND_MSG_PUB.Count_And_Get
2212: (p_count => x_msg_count,
2213: p_data => x_msg_data
2214: );
2215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2218: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2214: );
2215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2216: ROLLBACK TO Update_Account_Pvt;
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2218: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2219: p_data => x_msg_data );
2220: WHEN OTHERS THEN
2221: ROLLBACK TO Update_Account_Pvt;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2219: p_data => x_msg_data );
2220: WHEN OTHERS THEN
2221: ROLLBACK TO Update_Account_Pvt;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2224: THEN
2225: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2226: l_api_name );
2227: END IF;

Line 2225: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

2221: ROLLBACK TO Update_Account_Pvt;
2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2224: THEN
2225: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2226: l_api_name );
2227: END IF;
2228: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2229: p_data => x_msg_data );

Line 2228: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2224: THEN
2225: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2226: l_api_name );
2227: END IF;
2228: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2229: p_data => x_msg_data );
2230: END Update_Account;
2231:
2232: /*----------------------------------------------------------------*/

Line 2318: FND_MSG_PUB.initialize;

2314: END IF;
2315:
2316: -- Initialize message list if p_init_msg_list is set to TRUE.
2317: IF FND_API.to_Boolean(p_init_msg_list) THEN
2318: FND_MSG_PUB.initialize;
2319: END IF;
2320:
2321: -- Initialize API return status to success
2322: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2426: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2422: COMMIT WORK;
2423: END IF;
2424:
2425: -- Standard call to get message count and IF count is get message info.
2426: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2427: p_data => x_msg_data );
2428: EXCEPTION
2429: WHEN FND_API.G_EXC_ERROR THEN
2430: ROLLBACK TO Update_ContactPoints_Pvt;

Line 2435: FND_MSG_PUB.Count_And_Get

2431: x_return_status := FND_API.G_RET_STS_ERROR ;
2432: x_phone_obj_ver_num := p_phone_obj_ver_num;
2433: x_email_obj_ver_num := p_email_obj_ver_num;
2434: x_url_obj_ver_num := p_url_obj_ver_num;
2435: FND_MSG_PUB.Count_And_Get
2436: (p_count => x_msg_count,
2437: p_data => x_msg_data
2438: );
2439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2445: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2442: x_phone_obj_ver_num := p_phone_obj_ver_num;
2443: x_email_obj_ver_num := p_email_obj_ver_num;
2444: x_url_obj_ver_num := p_url_obj_ver_num;
2445: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2446: p_data => x_msg_data );
2447: WHEN OTHERS THEN
2448: ROLLBACK TO Update_ContactPoints_Pvt;
2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2450: x_phone_obj_ver_num := p_phone_obj_ver_num;
2451: x_email_obj_ver_num := p_email_obj_ver_num;
2452: x_url_obj_ver_num := p_url_obj_ver_num;
2453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2454: THEN
2455: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2456: l_api_name );
2457: END IF;

Line 2455: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

2451: x_email_obj_ver_num := p_email_obj_ver_num;
2452: x_url_obj_ver_num := p_url_obj_ver_num;
2453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2454: THEN
2455: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2456: l_api_name );
2457: END IF;
2458: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2459: p_data => x_msg_data );

Line 2458: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2454: THEN
2455: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2456: l_api_name );
2457: END IF;
2458: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2459: p_data => x_msg_data );
2460: END Update_ContactPoints;
2461:
2462: /*----------------------------------------------------------------*/

Line 2518: FND_MSG_PUB.initialize;

2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE.
2517: IF FND_API.to_Boolean(p_init_msg_list) THEN
2518: FND_MSG_PUB.initialize;
2519: END IF;
2520:
2521: -- Initialize API return status to success
2522: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2581: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2577: COMMIT WORK;
2578: END IF;
2579:
2580: -- Standard call to get message count and IF count is get message info.
2581: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2582: p_data => x_msg_data );
2583: EXCEPTION
2584: WHEN FND_API.G_EXC_ERROR THEN
2585: ROLLBACK TO Update_AddressRecords_Pvt;

Line 2587: FND_MSG_PUB.Count_And_Get

2583: EXCEPTION
2584: WHEN FND_API.G_EXC_ERROR THEN
2585: ROLLBACK TO Update_AddressRecords_Pvt;
2586: x_return_status := FND_API.G_RET_STS_ERROR ;
2587: FND_MSG_PUB.Count_And_Get
2588: (p_count => x_msg_count,
2589: p_data => x_msg_data
2590: );
2591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2594: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2590: );
2591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2592: ROLLBACK TO Update_AddressRecords_Pvt;
2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2594: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2595: p_data => x_msg_data );
2596: WHEN OTHERS THEN
2597: ROLLBACK TO Update_AddressRecords_Pvt;
2598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2599: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2595: p_data => x_msg_data );
2596: WHEN OTHERS THEN
2597: ROLLBACK TO Update_AddressRecords_Pvt;
2598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2599: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2602: l_api_name );
2603: END IF;

Line 2601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

2597: ROLLBACK TO Update_AddressRecords_Pvt;
2598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2599: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2602: l_api_name );
2603: END IF;
2604: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2605: p_data => x_msg_data );

Line 2604: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2600: THEN
2601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2602: l_api_name );
2603: END IF;
2604: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2605: p_data => x_msg_data );
2606: END Update_AddressRecords;
2607:
2608: /*----------------------------------------------------------------*/

Line 2661: FND_MSG_PUB.initialize;

2657: END IF;
2658:
2659: -- Initialize message list if p_init_msg_list is set to TRUE.
2660: IF FND_API.to_Boolean(p_init_msg_list) THEN
2661: FND_MSG_PUB.initialize;
2662: END IF;
2663:
2664: -- Initialize API return status to success
2665: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2742: COMMIT WORK;
2743: END IF;
2744:
2745: -- Standard call to get message count and IF count is get message info.
2746: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2747: p_data => x_msg_data );
2748: EXCEPTION
2749: WHEN FND_API.G_EXC_ERROR THEN
2750: ROLLBACK TO Update_Address_Pvt;

Line 2752: FND_MSG_PUB.Count_And_Get

2748: EXCEPTION
2749: WHEN FND_API.G_EXC_ERROR THEN
2750: ROLLBACK TO Update_Address_Pvt;
2751: x_return_status := FND_API.G_RET_STS_ERROR ;
2752: FND_MSG_PUB.Count_And_Get
2753: (p_count => x_msg_count,
2754: p_data => x_msg_data
2755: );
2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2759: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2755: );
2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2757: ROLLBACK TO Update_Address_Pvt;
2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2759: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2760: p_data => x_msg_data );
2761: WHEN OTHERS THEN
2762: ROLLBACK TO Update_Address_Pvt;
2763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2764: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2760: p_data => x_msg_data );
2761: WHEN OTHERS THEN
2762: ROLLBACK TO Update_Address_Pvt;
2763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2764: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2765: THEN
2766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2767: l_api_name );
2768: END IF;

Line 2766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

2762: ROLLBACK TO Update_Address_Pvt;
2763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2764: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2765: THEN
2766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2767: l_api_name );
2768: END IF;
2769: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2770: p_data => x_msg_data );

Line 2769: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

2765: THEN
2766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
2767: l_api_name );
2768: END IF;
2769: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2770: p_data => x_msg_data );
2771: END Update_Address;
2772:
2773: