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_USERID_PKG dependencies on FND_API

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 251: RAISE FND_API.G_EXC_ERROR;

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
255: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

517: x_unencrypted_password => l_user_password,
518: x_email_address => l_email_address,
519: x_person_party_id => l_party_id
520: );
521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: raise FND_API.G_EXC_ERROR;
523: END IF;
524:
525: -- This logic assigns responsibilities to the user depending on the person_types he is assigned.

Line 522: raise FND_API.G_EXC_ERROR;

518: x_email_address => l_email_address,
519: x_person_party_id => l_party_id
520: );
521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: raise FND_API.G_EXC_ERROR;
523: END IF;
524:
525: -- This logic assigns responsibilities to the user depending on the person_types he is assigned.
526:

Line 669: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

665: l_local_inst := FND_PROFILE.VALUE('IGS_OR_LOCAL_INST');
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 ;

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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:
675: -- Create a unique WF process key
676:
677: l_item_key := p_given_name||'.'|| p_surname||'.'||p_birth||'.'||NVL(p_alt_id,p_number)||'.'||p_gender;

Line 692: RAISE FND_API.G_EXC_ERROR;

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:
696: --Generate WF name

Line 763: WHEN FND_API.G_EXC_ERROR THEN

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
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,

Line 765: x_return_status := FND_API.G_RET_STS_ERROR;

761:
762: EXCEPTION
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:

Line 770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773:
774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: p_data => x_msg_data );
769:
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:

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

777: WHEN OTHERS THEN
778:
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;

Line 928: p_init_msg_list => Fnd_Api.G_FALSE,

924: --
925: -- Begin the processing of the users in the Group ID given
926: --
927: Process_Group_ID (p_api_version => l_api_version,
928: p_init_msg_list => Fnd_Api.G_FALSE,
929: p_commit => Fnd_Api.G_FALSE,
930: p_valid_lvl => Fnd_Api.G_VALID_LEVEL_FULL,
931: x_return_status => l_return_status,
932: p_person_group_id => p_group_id);

Line 929: p_commit => Fnd_Api.G_FALSE,

925: -- Begin the processing of the users in the Group ID given
926: --
927: Process_Group_ID (p_api_version => l_api_version,
928: p_init_msg_list => Fnd_Api.G_FALSE,
929: p_commit => Fnd_Api.G_FALSE,
930: p_valid_lvl => Fnd_Api.G_VALID_LEVEL_FULL,
931: x_return_status => l_return_status,
932: p_person_group_id => p_group_id);
933:

Line 930: p_valid_lvl => Fnd_Api.G_VALID_LEVEL_FULL,

926: --
927: Process_Group_ID (p_api_version => l_api_version,
928: p_init_msg_list => Fnd_Api.G_FALSE,
929: p_commit => Fnd_Api.G_FALSE,
930: p_valid_lvl => Fnd_Api.G_VALID_LEVEL_FULL,
931: x_return_status => l_return_status,
932: p_person_group_id => p_group_id);
933:
934: --

Line 937: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

933:
934: --
935: -- Determine if the processing of the group ID was successful
936: --
937: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
938: errbuf := FND_MESSAGE.GET_STRING('IGS', 'IGS_PE_NRML_CMPLTN_REQ');
939: retcode := 0;
940: ELSE
941: errbuf := FND_MESSAGE.GET_STRING('IGS', 'IGS_PE_ERR_ON_COMPLETION');

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 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 1077: l_init_msg_list := FND_API.G_FALSE;

1073: WHERE fnd.person_party_id = p_person_id;
1074:
1075: BEGIN
1076: -- use local variables instead of the parameters (since parameters cannot be initialised here)
1077: l_init_msg_list := FND_API.G_FALSE;
1078: IF p_commit IS NULL THEN
1079: l_commit := Fnd_Api.G_FALSE;
1080: ELSE
1081: l_commit := p_commit;

Line 1079: l_commit := Fnd_Api.G_FALSE;

1075: BEGIN
1076: -- use local variables instead of the parameters (since parameters cannot be initialised here)
1077: l_init_msg_list := FND_API.G_FALSE;
1078: IF p_commit IS NULL THEN
1079: l_commit := Fnd_Api.G_FALSE;
1080: ELSE
1081: l_commit := p_commit;
1082: END IF;
1083: IF p_valid_lvl IS NULL THEN

Line 1084: l_valid_lvl := Fnd_Api.G_VALID_LEVEL_FULL;

1080: ELSE
1081: l_commit := p_commit;
1082: END IF;
1083: IF p_valid_lvl IS NULL THEN
1084: l_valid_lvl := Fnd_Api.G_VALID_LEVEL_FULL;
1085: ELSE
1086: l_valid_lvl := p_valid_lvl;
1087: END IF;
1088:

Line 1126: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1122:
1123: --
1124: -- Set the return status as success for the api
1125: --
1126: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1127:
1128: --
1129: -- Savepoint initialization
1130: --

Line 1137: IF (NOT FND_API.Compatible_API_Call ( l_api_version,

1133: --
1134: -- Make sure that the appropriate version is being used and initialize
1135: -- the message stack if required.
1136: --
1137: IF (NOT FND_API.Compatible_API_Call ( l_api_version,
1138: p_api_version,
1139: l_api_name,
1140: 'IGS_PE_USERID_PKG' )) THEN
1141: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1141: raise FND_API.G_EXC_UNEXPECTED_ERROR ;

1137: IF (NOT FND_API.Compatible_API_Call ( l_api_version,
1138: p_api_version,
1139: l_api_name,
1140: 'IGS_PE_USERID_PKG' )) THEN
1141: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
1142: END IF;
1143:
1144: --
1145: -- Obtain all the user or members of the group ID given

Line 1187: p_init_msg_list => FND_API.G_TRUE,

1183: -- Call the appropriate procedure that will handle the user creation
1184: --
1185:
1186: Generate_User (p_api_version => l_api_version,
1187: p_init_msg_list => FND_API.G_TRUE,
1188: p_commit => FND_API.G_TRUE,
1189: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1190: x_return_status => l_return_status,
1191: x_msg_count => l_msg_count,

Line 1188: p_commit => FND_API.G_TRUE,

1184: --
1185:
1186: Generate_User (p_api_version => l_api_version,
1187: p_init_msg_list => FND_API.G_TRUE,
1188: p_commit => FND_API.G_TRUE,
1189: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1190: x_return_status => l_return_status,
1191: x_msg_count => l_msg_count,
1192: x_msg_data => l_msg_data,

Line 1189: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1185:
1186: Generate_User (p_api_version => l_api_version,
1187: p_init_msg_list => FND_API.G_TRUE,
1188: p_commit => FND_API.G_TRUE,
1189: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1190: x_return_status => l_return_status,
1191: x_msg_count => l_msg_count,
1192: x_msg_data => l_msg_data,
1193: p_title => l_member_rec.title,

Line 1210: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1206: p_email_format => l_email_format,
1207: p_email_address => l_email_address
1208: );
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

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 1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1279: -- Exception handler section for the Process_Group_ID procedure.
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;

Line 1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1289: CLOSE pgroup_refcur;
1290: END IF;
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;

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 1573: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1569: l_label := 'igs.plsql.igs_pe_userid_pkg.umx_business_logic: person_id IS NULL';
1570: l_debug_str := 'After Person Insert Call: l_return_status: '||l_return_status||'***l_person_id: '||l_person_id||'****l_msg_data/sqlerrm/l_msg_count:'||l_msg_data||'/'||l_msg_count;
1571: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1572: END IF;
1573: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1574: UMX_PUB.updateWfAttribute (p_event => p_event,
1575: P_ATTR_NAME => 'PERSON_PARTY_ID',
1576: P_ATTR_VALUE => l_person_id);
1577: END IF;

Line 1591: IF l_return_status IS NULL or l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1587: END IF;
1588:
1589: -- Check if contact point exist for the user.
1590:
1591: IF l_return_status IS NULL or l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1592: OPEN c_email(l_person_id);
1593: FETCH c_email INTO l_new_address;
1594: CLOSE c_email;
1595: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 1811: RAISE FND_API.G_EXC_ERROR;

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);
1815: FETCH c_dup_zip INTO l_zip_count, l_party_id;

Line 2009: RAISE FND_API.G_EXC_ERROR;

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
2013: -- initialize the parameter list.

Line 2037: RAISE FND_API.G_EXC_ERROR;

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';
2041: l_debug_str := 'Auto Generated Person Number is '||p_person_num;