DBA Data[Home] [Help]

APPS.IGS_PE_USERID_PKG dependencies on FND_MSG_PUB

Line 73: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

69:
70: BEGIN
71:
72:
73: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
74: p_data => l_msg_data );
75:
76: IF l_msg_count >0 THEN
77: l_msg_data :='';

Line 80: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);

76: IF l_msg_count >0 THEN
77: l_msg_data :='';
78:
79: FOR l_cur IN 1..l_msg_count LOOP
80: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
81: END LOOP;
82: ELSE
83: l_msg_data := FND_MESSAGE.GET_STRING('IGS', 'IGS_PE_ERR_STACK_NO_DATA');
84: END IF;

Line 250: FND_MSG_PUB.Add;

246: END LOOP;
247:
248: IF (l_count > 100) THEN
249: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_UNAME_GEN_FAIL');
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253:
254: IF l_party_id IS NULL THEN

Line 670: FND_MSG_PUB.initialize ;

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

Line 691: FND_MSG_PUB.Add;

687:
688: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_WF_EXISTS');
689: FND_MESSAGE.SET_TOKEN('GIVEN_NAME', p_given_name);
690: FND_MESSAGE.SET_TOKEN('LAST_NAME', p_surname);
691: FND_MSG_PUB.Add;
692: RAISE FND_API.G_EXC_ERROR;
693:
694: END IF;
695:

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

755:
756: COMMIT WORK;
757:
758:
759: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
760: p_data => x_msg_data );
761:
762: EXCEPTION
763: WHEN FND_API.G_EXC_ERROR THEN

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

763: WHEN FND_API.G_EXC_ERROR THEN
764: Rollback to Generate_User;
765: x_return_status := FND_API.G_RET_STS_ERROR;
766:
767: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
768: p_data => x_msg_data );
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: Rollback to Generate_User;

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

770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: Rollback to Generate_User;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
775: p_data => x_msg_data );
776:
777: WHEN OTHERS THEN
778:

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

779:
780: Rollback to Generate_User;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
784: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
785: END IF;
786:
787: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 784: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);

780: Rollback to Generate_User;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
784: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
785: END IF;
786:
787: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
788: p_data => x_msg_data );

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

783: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
784: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
785: END IF;
786:
787: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
788: p_data => x_msg_data );
789:
790: END Generate_User ;
791:

Line 900: Fnd_Msg_Pub.Initialize;

896: l_api_version := 1.0;
897: --
898: -- Initialize the message stack for any messages that could be created prior to the processing
899: --
900: Fnd_Msg_Pub.Initialize;
901:
902: -- If as per customer setup User provisioning(user creation/updation) is not allowed in any instances in any of the
903: -- product interfaces then log the error message in the log file and return
904: IF NOT FND_SSO_MANAGER.IsUserCreateUpdateAllowed THEN

Line 953: Fnd_Msg_Pub.ADD;

949: --
950: CLOSE c_person_id_group;
951: Fnd_Message.SET_NAME ('IGS','IGS_PE_NO_GROUP_ID');
952: Fnd_Message.SET_TOKEN('PERSON_GROUP_ID',p_group_id);
953: Fnd_Msg_Pub.ADD;
954:
955: END IF;
956:
957: --

Line 961: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

957: --
958: -- Determine if there are messages that need to be output into the request log file
959: -- for the user to view.
960: --
961: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
962: p_data => l_msg_data );
963:
964: IF (l_msg_count > 0 AND retcode <> 0 ) THEN
965:

Line 968: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

964: IF (l_msg_count > 0 AND retcode <> 0 ) THEN
965:
966: l_error_text := '';
967: FOR l_cur IN 1..l_msg_count LOOP
968: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
969: fnd_file.put_line (FND_FILE.LOG, l_error_text);
970: END LOOP;
971:
972: END IF;

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

983: retcode := 2;
984: IF (c_person_id_group%ISOPEN) THEN
985: CLOSE c_person_id_group;
986: END IF;
987: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
988: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG',
989: l_api_name);
990: END IF;
991:

Line 988: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG',

984: IF (c_person_id_group%ISOPEN) THEN
985: CLOSE c_person_id_group;
986: END IF;
987: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
988: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG',
989: l_api_name);
990: END IF;
991:
992: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

Line 992: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

988: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG',
989: l_api_name);
990: END IF;
991:
992: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
993: p_data => l_msg_data );
994:
995: IF (l_msg_count > 0) THEN
996:

Line 999: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

995: IF (l_msg_count > 0) THEN
996:
997: l_error_text := '';
998: FOR l_cur IN 1..l_msg_count LOOP
999: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
1000: fnd_file.put_line (FND_FILE.LOG, l_error_text);
1001: END LOOP;
1002:
1003: END IF;

Line 1158: FND_MSG_PUB.initialize;

1154: LOOP
1155: FETCH pgroup_refcur INTO l_member_rec;
1156: EXIT WHEN pgroup_refcur%NOTFOUND;
1157:
1158: FND_MSG_PUB.initialize;
1159: --
1160: -- Check to determine if the person already has a user name assigned in fnd_user
1161: --
1162: l_user_name := NULL;

Line 1213: Fnd_Msg_Pub.ADD;

1209:
1210: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1211: Fnd_Message.SET_NAME ('IGS','IGS_PE_PRSN_ACCT_NOT_CREATED');
1212: Fnd_Message.SET_TOKEN('USERNAME', l_member_rec.full_name);
1213: Fnd_Msg_Pub.ADD;
1214: ELSE
1215: Fnd_Message.SET_NAME ('IGS','IGS_PE_PRSN_ACCT_CREATED');
1216: Fnd_Message.SET_TOKEN('USERNAME', l_member_rec.full_name);
1217: Fnd_Message.SET_TOKEN('GRP_DESCRIPTION', grp_desc_rec.description);

Line 1218: Fnd_Msg_Pub.ADD;

1214: ELSE
1215: Fnd_Message.SET_NAME ('IGS','IGS_PE_PRSN_ACCT_CREATED');
1216: Fnd_Message.SET_TOKEN('USERNAME', l_member_rec.full_name);
1217: Fnd_Message.SET_TOKEN('GRP_DESCRIPTION', grp_desc_rec.description);
1218: Fnd_Msg_Pub.ADD;
1219: END IF;
1220:
1221: ELSE
1222: Fnd_Message.SET_NAME ('IGS','IGS_PE_PRSN_NO_EMAIL_INFO');

Line 1224: Fnd_Msg_Pub.ADD;

1220:
1221: ELSE
1222: Fnd_Message.SET_NAME ('IGS','IGS_PE_PRSN_NO_EMAIL_INFO');
1223: Fnd_Message.SET_TOKEN('USERNAME', l_member_rec.full_name);
1224: Fnd_Msg_Pub.ADD;
1225: END IF;
1226:
1227: ELSE
1228: -- this section for user account found

Line 1233: FND_MSG_PUB.ADD;

1229: -- if the user account has been inactivated for any reasons indicate in the log
1230: IF l_user_end_date IS NOT NULL AND l_user_end_date < sysdate THEN
1231: FND_MESSAGE.SET_NAME('IGS','IGS_PE_USERID_EXIST_INACTIVE');
1232: FND_MESSAGE.SET_TOKEN('USERNAME',l_member_rec.full_name);
1233: FND_MSG_PUB.ADD;
1234: ELSE
1235: -- the user account exists and is active as on the date this job is run
1236: -- so the user is not re-processed
1237: Fnd_Message.SET_NAME ('IGS','IGS_PE_USERID_NOT_PROCESSED');

Line 1240: Fnd_Msg_Pub.ADD;

1236: -- so the user is not re-processed
1237: Fnd_Message.SET_NAME ('IGS','IGS_PE_USERID_NOT_PROCESSED');
1238: Fnd_Message.SET_TOKEN('USERNAME', l_member_rec.full_name);
1239: Fnd_Message.SET_TOKEN('GRP_DESCRIPTION', grp_desc_rec.description);
1240: Fnd_Msg_Pub.ADD;
1241: END IF;
1242: END IF;
1243:
1244: --

Line 1248: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

1244: --
1245: -- Make sure that all messages are taken from the stack to be output to the log file.
1246: -- The message stack is initialized for each loop iteration.
1247: --
1248: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1249: p_data => l_msg_data );
1250:
1251:
1252: IF (l_msg_count > 0) THEN

Line 1256: l_error_text := ' ' || FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

1252: IF (l_msg_count > 0) THEN
1253:
1254: l_error_text := '';
1255: FOR l_cur IN 1..l_msg_count LOOP
1256: l_error_text := ' ' || FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
1257: fnd_file.put_line (FND_FILE.LOG, l_error_text);
1258: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1259: END LOOP;
1260:

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

1280: --
1281: EXCEPTION
1282: WHEN NO_DATA_FOUND THEN
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1284: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1285: fnd_message.set_name('IGS','IGS_PE_PERSID_GROUP_EXP');
1286: fnd_file.put_line (FND_FILE.LOG,fnd_message.get);
1287: END IF;
1288: IF (pgroup_refcur%ISOPEN) THEN

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

1291: RETURN;
1292: WHEN OTHERS THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: ROLLBACK TO Process_Group_ID_PVT;
1295: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1296: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
1297: END IF;
1298: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1299: p_data => l_msg_data );

Line 1296: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);

1292: WHEN OTHERS THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: ROLLBACK TO Process_Group_ID_PVT;
1295: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1296: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
1297: END IF;
1298: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1299: p_data => l_msg_data );
1300:

Line 1298: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

1294: ROLLBACK TO Process_Group_ID_PVT;
1295: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1296: FND_MSG_PUB.Add_Exc_Msg ('IGS_PE_USERID_PKG', l_api_name);
1297: END IF;
1298: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1299: p_data => l_msg_data );
1300:
1301: IF (l_msg_count > 0) THEN
1302:

Line 1305: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

1301: IF (l_msg_count > 0) THEN
1302:
1303: l_error_text := '';
1304: FOR l_cur IN 1..l_msg_count LOOP
1305: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
1306: fnd_file.put_line (FND_FILE.LOG, l_error_text);
1307: END LOOP;
1308:
1309: END IF;

Line 1810: FND_MSG_PUB.Add;

1806: -- Too many users
1807: IF p_Zipcode IS NULL THEN
1808: x_return_status := 'E';
1809: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_ENTER_ZIPCODE');
1810: FND_MSG_PUB.Add;
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSE
1813: OPEN c_dup_zip(p_first_name, p_last_name, p_birth_date,
1814: p_pref_alt_id, p_person_num, p_gender, p_zipcode);

Line 1971: FND_MSG_PUB.INITIALIZE;

1967: l_wf_name VARCHAR2(8) ;
1968: ln_seq_val NUMBER;
1969:
1970: BEGIN
1971: FND_MSG_PUB.INITIALIZE;
1972: Dup_Person_Check(
1973: p_first_name,
1974: p_last_name,
1975: p_birth_date,

Line 2008: FND_MSG_PUB.Add;

2004:
2005: IF TRUNC(p_birth_date) > TRUNC(SYSDATE) THEN
2006: x_return_status := 'E';
2007: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_BIRTH_DT');
2008: FND_MSG_PUB.Add;
2009: RAISE FND_API.G_EXC_ERROR;
2010: END IF;
2011:
2012: IF (p_isApplicant = 'APPLICANT_YES') AND (FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N') THEN

Line 2036: FND_MSG_PUB.Add;

2032: l_parameter_list_t.delete;
2033: IF (p_person_num IS NULL) THEN
2034: x_return_status := 'E';
2035: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_ACCREQ_SETUP_N_COMPL');
2036: FND_MSG_PUB.Add;
2037: RAISE FND_API.G_EXC_ERROR;
2038: END IF;
2039: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
2040: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person';