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.IGS_PE_PERSON_SS_PKG dependencies on FND_MSG_PUB

Line 32: | FND_MSG_PUB.initialize called in every procedure

28: | new columns are added.
29: | asbala 12-nov-03 3227107: address changes - signature of igs_pe_person_addr_pkg.insert_row and update_row changed
30: | signature of igs_pe_person_ss_pkg.update_address now includes 3 new parameters
31: | ssaleem 11-dec-03 3311720: Problem with error message display in SS Pages
32: | FND_MSG_PUB.initialize called in every procedure
33: | pkpatel 18-JUL-2005 Bug 4327807 (Person SS Enhancement)
34: | Added new procedures and modify existing procedures as per the new enhancement
35: | gamheswa 24-Aug-05 Bug 4327807 (Person SS Enhancement) modified CREATEUPDATE_RELATIONSHIP
36: | pkpatel 9-sep-2005 Bug 4327807 (Person SS Enhancement)

Line 111: FND_MSG_PUB.initialize;

107: END IF;
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: IF FND_API.to_Boolean (p_init_msg_list) THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113: -- Bug # 3311720
114: FND_MSG_PUB.initialize;
115:

Line 114: FND_MSG_PUB.initialize;

110: IF FND_API.to_Boolean (p_init_msg_list) THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113: -- Bug # 3311720
114: FND_MSG_PUB.initialize;
115:
116: -- API body
117: OPEN data_group_cur(p_data_group_id);
118: FETCH data_group_cur INTO l_data_group,l_lvl;

Line 185: FND_MSG_PUB.Count_And_Get

181: IF FND_API.To_Boolean( p_commit ) THEN
182: COMMIT WORK;
183: END IF;
184: -- Standard call to get message count and if count is 1, get message info.
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => x_msg_count ,
187: p_data => x_msg_data
188: );
189: EXCEPTION

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

189: EXCEPTION
190: WHEN apps_exception THEN
191: ROLLBACK TO Update_Privacy;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
194: p_data => x_msg_data );
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Update_Privacy;
197: x_return_status := FND_API.G_RET_STS_ERROR;

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

194: p_data => x_msg_data );
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Update_Privacy;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
199: p_data => x_msg_data );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Update_Privacy;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

199: p_data => x_msg_data );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Update_Privacy;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
204: p_data => x_msg_data );
205: WHEN OTHERS THEN
206: ROLLBACK TO Update_Privacy;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

204: p_data => x_msg_data );
205: WHEN OTHERS THEN
206: ROLLBACK TO Update_Privacy;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
209: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
210: END IF;
211: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
212: p_data => x_msg_data );

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

205: WHEN OTHERS THEN
206: ROLLBACK TO Update_Privacy;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
209: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
210: END IF;
211: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
212: p_data => x_msg_data );
213: END Update_Privacy;

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

207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
209: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
210: END IF;
211: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
212: p_data => x_msg_data );
213: END Update_Privacy;
214:
215: PROCEDURE Update_Person(

Line 307: FND_MSG_PUB.initialize;

303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: FND_MSG_PUB.initialize;
308: -- API body
309: /* 1. Get the Preferred Person Id Type
310: 2. Retrieve current row values to be passed to the procedure.
311: 3. Call IGS_PE_PERSON_PKG.UPDATE_ROW procedure

Line 388: FND_MSG_PUB.Count_And_Get

384: END LOOP;
385: -- End of API body.
386:
387: -- Standard call to get message count and if count is 1, get message info.
388: FND_MSG_PUB.Count_And_Get
389: ( p_count => x_msg_count ,
390: p_data => x_msg_data
391: );
392: EXCEPTION

Line 399: FND_MSG_PUB.initialize ;

395:
396: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
397:
398: IF l_message_name = 'IGS_PE_UNIQUE_PID' THEN
399: FND_MSG_PUB.initialize ;
400: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_UNIQUE_PID_SS');
401: FND_MESSAGE.SET_TOKEN('ALT_ID_DESC1', pref_id_rec.description);
402: FND_MESSAGE.SET_TOKEN('ALT_ID_DESC2', pref_id_rec.description);
403: IGS_GE_MSG_STACK.ADD;

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

403: IGS_GE_MSG_STACK.ADD;
404: END IF;
405:
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
408: p_data => x_msg_data );
409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO Update_Person;

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

409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO Update_Person;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
414: p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Update_Person;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

414: p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Update_Person;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
419: p_data => x_msg_data );
420: WHEN OTHERS THEN
421: ROLLBACK TO Update_Person;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

419: p_data => x_msg_data );
420: WHEN OTHERS THEN
421: ROLLBACK TO Update_Person;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
424: p_data => x_msg_data );
425: END Update_Person;
426:
427: PROCEDURE Update_Contact(

Line 533: FND_MSG_PUB.initialize;

529: END IF;
530: -- Initialize message list if p_init_msg_list is set to TRUE.
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532: IF FND_API.to_Boolean (p_init_msg_list) THEN
533: FND_MSG_PUB.initialize;
534: END IF;
535:
536: FND_MSG_PUB.initialize;
537:

Line 536: FND_MSG_PUB.initialize;

532: IF FND_API.to_Boolean (p_init_msg_list) THEN
533: FND_MSG_PUB.initialize;
534: END IF;
535:
536: FND_MSG_PUB.initialize;
537:
538: -- API body
539: -- Retrive existing information to be passed to the API.
540: -- Call IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP procedure

Line 713: FND_MSG_PUB.Count_And_Get

709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get
714: ( p_count => x_msg_count ,
715: p_data => x_msg_data
716: );
717: EXCEPTION

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

717: EXCEPTION
718: WHEN apps_exception THEN
719: ROLLBACK TO Update_Phone;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
722: p_data => x_msg_data );
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO Update_Phone;
725: x_return_status := FND_API.G_RET_STS_ERROR;

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

722: p_data => x_msg_data );
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO Update_Phone;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
727: p_data => x_msg_data );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Update_Person;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

727: p_data => x_msg_data );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Update_Person;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
732: p_data => x_msg_data );
733: WHEN OTHERS THEN
734: ROLLBACK TO Update_Phone;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

732: p_data => x_msg_data );
733: WHEN OTHERS THEN
734: ROLLBACK TO Update_Phone;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
737: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
738: END IF;
739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
740: p_data => x_msg_data );

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

733: WHEN OTHERS THEN
734: ROLLBACK TO Update_Phone;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
737: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
738: END IF;
739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
740: p_data => x_msg_data );
741: END Update_Contact;

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

735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
737: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
738: END IF;
739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
740: p_data => x_msg_data );
741: END Update_Contact;
742:
743: PROCEDURE Update_Address(

Line 847: FND_MSG_PUB.initialize;

843: END IF;
844: -- Initialize message list if p_init_msg_list is set to TRUE.
845: x_return_status := FND_API.G_RET_STS_SUCCESS;
846: IF FND_API.to_Boolean (p_init_msg_list) THEN
847: FND_MSG_PUB.initialize;
848: END IF;
849:
850: FND_MSG_PUB.initialize;
851:

Line 850: FND_MSG_PUB.initialize;

846: IF FND_API.to_Boolean (p_init_msg_list) THEN
847: FND_MSG_PUB.initialize;
848: END IF;
849:
850: FND_MSG_PUB.initialize;
851:
852: -- API body
853: -- Retrieve current row values to be passed to the procedure.
854: -- Call IGS_PE_PARTY_SITE_USE_PKG.HZ_PARTY_SITE_USES_AK procedure

Line 895: FND_MSG_PUB.Count_And_Get

891: IF FND_API.To_Boolean( p_commit ) THEN
892: COMMIT WORK;
893: END IF;
894: -- Standard call to get message count and if count is 1, get message info.
895: FND_MSG_PUB.Count_And_Get
896: ( p_count => x_msg_count ,
897: p_data => x_msg_data
898: );
899: EXCEPTION

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

899: EXCEPTION
900: WHEN apps_exception THEN
901: ROLLBACK TO Update_Usage;
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
904: p_data => x_msg_data );
905: WHEN FND_API.G_EXC_ERROR THEN
906: ROLLBACK TO Update_Usage;
907: x_return_status := FND_API.G_RET_STS_ERROR;

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

904: p_data => x_msg_data );
905: WHEN FND_API.G_EXC_ERROR THEN
906: ROLLBACK TO Update_Usage;
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
909: p_data => x_msg_data );
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Update_Usage;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

909: p_data => x_msg_data );
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Update_Usage;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
914: p_data => x_msg_data );
915: WHEN OTHERS THEN
916: ROLLBACK TO Update_Usage;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

914: p_data => x_msg_data );
915: WHEN OTHERS THEN
916: ROLLBACK TO Update_Usage;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
920: END IF;
921: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
922: p_data => x_msg_data );

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

915: WHEN OTHERS THEN
916: ROLLBACK TO Update_Usage;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
920: END IF;
921: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
922: p_data => x_msg_data );
923: END Update_Usage;

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

917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
920: END IF;
921: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
922: p_data => x_msg_data );
923: END Update_Usage;
924:
925: PROCEDURE Update_Employment(

Line 986: FND_MSG_PUB.initialize;

982: END IF;
983: -- Initialize message list if p_init_msg_list is set to TRUE.
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985: IF FND_API.to_Boolean (p_init_msg_list) THEN
986: FND_MSG_PUB.initialize;
987: END IF;
988:
989: FND_MSG_PUB.initialize;
990:

Line 989: FND_MSG_PUB.initialize;

985: IF FND_API.to_Boolean (p_init_msg_list) THEN
986: FND_MSG_PUB.initialize;
987: END IF;
988:
989: FND_MSG_PUB.initialize;
990:
991: -- API body
992: -- If mode='INSERT' call igs_ad_emp_dtl_pkg.INSERT_ROW
993: -- If mode='UPDATE': retrieve current row values to be passed to the procedure and call igs_ad_emp_dtl_pkg.UPDATE_ROW

Line 1083: FND_MSG_PUB.Count_And_Get

1079: IF FND_API.To_Boolean( p_commit ) THEN
1080: COMMIT WORK;
1081: END IF;
1082: -- Standard call to get message count and if count is 1, get message info.
1083: FND_MSG_PUB.Count_And_Get
1084: ( p_count => x_msg_count ,
1085: p_data => x_msg_data
1086: );
1087: EXCEPTION

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

1087: EXCEPTION
1088: WHEN apps_exception THEN
1089: ROLLBACK TO Update_Employment;
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1092: p_data => x_msg_data );
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: ROLLBACK TO Update_Employment;
1095: x_return_status := FND_API.G_RET_STS_ERROR;

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

1092: p_data => x_msg_data );
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: ROLLBACK TO Update_Employment;
1095: x_return_status := FND_API.G_RET_STS_ERROR;
1096: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1097: p_data => x_msg_data );
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: ROLLBACK TO Update_Employment;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1097: p_data => x_msg_data );
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: ROLLBACK TO Update_Employment;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1102: p_data => x_msg_data );
1103: WHEN OTHERS THEN
1104: ROLLBACK TO Update_Employment;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1102: p_data => x_msg_data );
1103: WHEN OTHERS THEN
1104: ROLLBACK TO Update_Employment;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1108: END IF;
1109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1110: p_data => x_msg_data );

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

1103: WHEN OTHERS THEN
1104: ROLLBACK TO Update_Employment;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1108: END IF;
1109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1110: p_data => x_msg_data );
1111: END Update_Employment;

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

1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1108: END IF;
1109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1110: p_data => x_msg_data );
1111: END Update_Employment;
1112:
1113: PROCEDURE Update_Emergency(

Line 1185: FND_MSG_PUB.initialize;

1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: -- Initialize message list if p_init_msg_list is set to TRUE.
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;
1185: FND_MSG_PUB.initialize;
1186:
1187: IF P_ACTION = 'LOCK' THEN
1188: FOR l_stdnt_ps_attempt_dtls_rec IN c_get_stdnt_ps_att_dtls(p_person_id, p_course_cd) LOOP
1189: IGS_EN_STDNT_PS_ATT_PKG.LOCK_ROW(

Line 1354: FND_MSG_PUB.Count_And_Get

1350: IF FND_API.To_Boolean( p_commit ) THEN
1351: COMMIT WORK;
1352: END IF;
1353: -- Standard call to get message count and if count is 1, get message info.
1354: FND_MSG_PUB.Count_And_Get
1355: ( p_count => x_msg_count ,
1356: p_data => x_msg_data
1357: );
1358: EXCEPTION

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

1358: EXCEPTION
1359: WHEN apps_exception THEN
1360: ROLLBACK TO Update_Dates;
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1363: p_data => x_msg_data );
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: ROLLBACK TO Update_Dates;
1366: x_return_status := FND_API.G_RET_STS_ERROR;

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

1363: p_data => x_msg_data );
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: ROLLBACK TO Update_Dates;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1368: p_data => x_msg_data );
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: ROLLBACK TO Update_Dates;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1368: p_data => x_msg_data );
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: ROLLBACK TO Update_Dates;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1373: p_data => x_msg_data );
1374: WHEN OTHERS THEN
1375: ROLLBACK TO Update_Dates;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1373: p_data => x_msg_data );
1374: WHEN OTHERS THEN
1375: ROLLBACK TO Update_Dates;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1378: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1379: END IF;
1380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1381: p_data => x_msg_data );

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

1374: WHEN OTHERS THEN
1375: ROLLBACK TO Update_Dates;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1378: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1379: END IF;
1380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1381: p_data => x_msg_data );
1382: END Update_Dates;

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

1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1378: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1379: END IF;
1380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1381: p_data => x_msg_data );
1382: END Update_Dates;
1383:
1384: FUNCTION Get_Relationship_type RETURN VARCHAR2 IS

Line 1525: FND_MSG_PUB.initialize;

1521: BEGIN
1522: SAVEPOINT Update_Biographic;
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1525: FND_MSG_PUB.initialize;
1526:
1527: -- API body
1528:
1529: IF p_marital_status_date IS NOT NULL THEN

Line 1803: FND_MSG_PUB.initialize;

1799: BEGIN
1800:
1801: -- Initialize message list if p_init_msg_list is set to TRUE.
1802: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1803: FND_MSG_PUB.initialize;
1804:
1805: l_api_person_id := UPPER(p_api_person_id);
1806:
1807: IF P_ACTION = 'INSERT' THEN

Line 1944: FND_MSG_PUB.initialize ;

1940: OPEN c_alt_id_desc(P_PERSON_ID_TYPE);
1941: FETCH c_alt_id_desc INTO l_alt_id_desc;
1942: CLOSE c_alt_id_desc;
1943:
1944: FND_MSG_PUB.initialize ;
1945: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_UNIQUE_PID_SS');
1946: FND_MESSAGE.SET_TOKEN('ALT_ID_DESC1', l_alt_id_desc);
1947: FND_MESSAGE.SET_TOKEN('ALT_ID_DESC2', l_alt_id_desc);
1948: IGS_GE_MSG_STACK.ADD;

Line 1986: FND_MSG_PUB.initialize;

1982: record_info_rec record_info_cur%ROWTYPE;
1983: l_test_date DATE;
1984: BEGIN
1985: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1986: FND_MSG_PUB.initialize;
1987:
1988: /*
1989: IF for the P_TEST_RESULT_ID and P_TEST_SEGMENT_ID combination there are no records,
1990: then if Test score is entered, INSERT should happen.

Line 2415: FND_MSG_PUB.initialize;

2411: L_FOUND VARCHAR2(1);
2412:
2413: l_relationship_id NUMBER;
2414: BEGIN
2415: FND_MSG_PUB.initialize;
2416: SAVEPOINT CreateUpdate_Relationship;
2417: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2418:
2419: OPEN c_existing_rel(p_first_name,p_last_name,p_subject_id,p_rel_code);