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

Line 27: RAISE FND_API.G_EXC_ERROR;

23: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
24: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
25: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
26: IGS_GE_MSG_STACK.ADD;
27: RAISE FND_API.G_EXC_ERROR;
28:
29:
30: ELSIF l_col_length.column_type ='N' AND p_param_length > l_col_length.precision THEN
31: -- DBMS_OUTPUT.PUT_LINE('failure ' || l_col_length.precision);

Line 36: RAISE FND_API.G_EXC_ERROR;

32: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
33: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
34: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision);
35: IGS_GE_MSG_STACK.ADD;
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:
39: END check_length;
40:

Line 45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

41: PROCEDURE rec_pgm_approval
42: (
43: --Standard Parameters Start
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
46: p_commit IN VARCHAR2 default FND_API.G_FALSE,
47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,

Line 46: p_commit IN VARCHAR2 default FND_API.G_FALSE,

42: (
43: --Standard Parameters Start
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
46: p_commit IN VARCHAR2 default FND_API.G_FALSE,
47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,

Line 47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

43: --Standard Parameters Start
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
46: p_commit IN VARCHAR2 default FND_API.G_FALSE,
47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: --Standard parameter ends

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

78: lv_rowid ROWID;
79: l_appl_pgmapprv_id NUMBER;
80:
81: BEGIN
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: SAVEPOINT Rec_Pgm_Approval_PUB;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

Line 86: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: SAVEPOINT Rec_Pgm_Approval_PUB;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 87: RAISE FND_API.G_EXC_ERROR;

83:
84: SAVEPOINT Rec_Pgm_Approval_PUB;
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean( p_init_msg_list ) THEN
91: FND_MSG_PUB.initialize;

Line 90: IF FND_API.to_Boolean( p_init_msg_list ) THEN

86: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean( p_init_msg_list ) THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93: l_msg_index := igs_ge_msg_stack.count_msg;
94:

Line 150: IF FND_API.To_Boolean( p_commit ) THEN

146:
147: --DBMS_OUTPUT.PUT_LINE('EXCEPTION BLOCK : After extracting XDATA :-' );
148:
149: -- Standard check of p_commit.
150: IF FND_API.To_Boolean( p_commit ) THEN
151: COMMIT;
152: END IF;
153: -- End of Procedure
154: EXCEPTION

Line 155: WHEN FND_API.G_EXC_ERROR THEN

151: COMMIT;
152: END IF;
153: -- End of Procedure
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: ROLLBACK TO Rec_Pgm_Approval_PUB;
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: -- Add message to API message list.
159: igs_ad_gen_016.extract_msg_from_stack (

Line 157: x_return_status := FND_API.G_RET_STS_ERROR ;

153: -- End of Procedure
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: ROLLBACK TO Rec_Pgm_Approval_PUB;
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: -- Add message to API message list.
159: igs_ad_gen_016.extract_msg_from_stack (
160: p_msg_at_index => l_msg_index,
161: p_return_status => l_return_status,

Line 170: x_return_status := FND_API.G_RET_STS_ERROR ;

166: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-1).text;
167:
168:
169: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
170: x_return_status := FND_API.G_RET_STS_ERROR ;
171: ELSE
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: END IF;
174:

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168:
169: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
170: x_return_status := FND_API.G_RET_STS_ERROR ;
171: ELSE
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: END IF;
174:
175: WHEN OTHERS THEN
176: ROLLBACK TO Rec_Pgm_Approval_PUB;

Line 177: x_return_status := FND_API.G_RET_STS_ERROR ;

173: END IF;
174:
175: WHEN OTHERS THEN
176: ROLLBACK TO Rec_Pgm_Approval_PUB;
177: x_return_status := FND_API.G_RET_STS_ERROR ;
178: -- Add message to API message list.
179: igs_ad_gen_016.extract_msg_from_stack (
180: p_msg_at_index => l_msg_index,
181: p_return_status => l_return_status,

Line 186: x_return_status := FND_API.G_RET_STS_ERROR ;

182: p_msg_count => x_msg_count,
183: p_msg_data => x_msg_data,
184: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
185: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: ELSE
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: END IF;
190: END rec_pgm_approval;

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

184: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
185: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: ELSE
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: END IF;
190: END rec_pgm_approval;
191:
192: PROCEDURE ASSIGN_EVALUATORS_TO_AI (

Line 195: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

191:
192: PROCEDURE ASSIGN_EVALUATORS_TO_AI (
193: --Standard Parameters Start
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
196: p_commit IN VARCHAR2 default FND_API.G_FALSE,
197: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
198:
199: --Standard parameter ends

Line 196: p_commit IN VARCHAR2 default FND_API.G_FALSE,

192: PROCEDURE ASSIGN_EVALUATORS_TO_AI (
193: --Standard Parameters Start
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
196: p_commit IN VARCHAR2 default FND_API.G_FALSE,
197: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
198:
199: --Standard parameter ends
200:

Line 197: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

193: --Standard Parameters Start
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
196: p_commit IN VARCHAR2 default FND_API.G_FALSE,
197: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
198:
199: --Standard parameter ends
200:
201: p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,

Line 362: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

358:
359: SAVEPOINT ASSIGN_EVALUATORS_TO_AI_PUB;
360: l_msg_index := igs_ge_msg_stack.count_msg;
361: -- Standard call to check for call compatibility.
362: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
363: RAISE FND_API.G_EXC_ERROR ;
364: END IF;
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 363: RAISE FND_API.G_EXC_ERROR ;

359: SAVEPOINT ASSIGN_EVALUATORS_TO_AI_PUB;
360: l_msg_index := igs_ge_msg_stack.count_msg;
361: -- Standard call to check for call compatibility.
362: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
363: RAISE FND_API.G_EXC_ERROR ;
364: END IF;
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF FND_API.to_Boolean( p_init_msg_list ) THEN
367: FND_MSG_PUB.initialize;

Line 366: IF FND_API.to_Boolean( p_init_msg_list ) THEN

362: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
363: RAISE FND_API.G_EXC_ERROR ;
364: END IF;
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF FND_API.to_Boolean( p_init_msg_list ) THEN
367: FND_MSG_PUB.initialize;
368: END IF;
369:
370: -- P_PERSON_ID

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380: -- P_APPL_REVPROF_REVGR_ID
381: check_length('APPL_REVPROF_REVGR_ID', 'IGS_AD_APPL_ARP', length(p_appl_revprof_revgr_id));
382:
383: -- Initialize API return status to success
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: -- Check whether any application is available in OSS to update outcome status
386: -- if the corresponding application is not there , then update the interface record with appropriate error code
387: OPEN c_aplinst_cur;
388: FETCH c_aplinst_cur

Line 395: RAISE FND_API.G_EXC_ERROR;

391: IF l_c_aplinst_cur.person_id IS NULL THEN
392: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
394: IGS_GE_MSG_STACK.ADD;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: --Get the Evaluation Type associated with the entered Application Review Profile Name
398: OPEN eval_type_cur(p_appl_rev_profile_id);
399: FETCH eval_type_cur INTO l_modif_eval_type;

Line 415: RAISE FND_API.G_EXC_ERROR;

411:
412: IF l_exist_arp.appl_rev_profile_id IS NOT NULL THEN
413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_REV_PRF_EXISTS');
414: IGS_GE_MSG_STACK.ADD;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417:
418: /* The following code is to handle the update of the recview profile record.
419: OPEN eval_type_cur(l_exist_arp.appl_rev_profile_id);

Line 428: RAISE FND_API.G_EXC_ERROR;

424: -- Review Group and Review Profile is already attached and evaluation type is
425: IF l_exist_eval_type IS NOT NULL AND l_exist_eval_type <> l_modif_eval_type THEN
426: fnd_message.set_name('IGS', 'IGS_AD_DIFF_EVAL_TYPE');
427: IGS_GE_MSG_STACK.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: ELSIF l_exist_eval_type IS NOT NULL THEN
430: OPEN get_rating_cur(
431: p_person_id,
432: p_admission_appl_number,

Line 442: RAISE FND_API.G_EXC_ERROR;

438: IF (get_rating_cur%FOUND) THEN
439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_CANT_UPD_RAT_PRSNT');
440: IGS_GE_MSG_STACK.ADD;
441: CLOSE get_rating_cur;
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444: CLOSE get_rating_cur;
445: ELSE -- Evaluation Type is null
446: -- This cursor fetches the current evaluators that are assigned

Line 462: RAISE FND_API.G_EXC_ERROR;

458: IF l_get_current_eval IS NOT NULL THEN
459: IF (l_modif_eval_type = 'S') THEN
460: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DIFF_EVAL_TYPE');
461: IGS_GE_MSG_STACK.ADD;
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464: END IF;
465: END IF; */
466: /* Get the System Doc Status associated with the Application Instance */

Line 480: RAISE FND_API.G_EXC_ERROR;

476: -- The following to check the documentation status is satisfied or NOT.
477: IF l_adm_doc <> 'SATISFIED' THEN
478: FND_MESSAGE.SET_NAME('IGS','IGS_AD_OTCM_DOC_STAT');
479: IGS_GE_MSG_STACK.ADD;
480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
482:
483: BEGIN
484: IF l_exist_eval_type IS NULL THEN

Line 552: x_return_status := FND_API.G_RET_STS_ERROR ;

548: p_msg_count => x_msg_count,
549: p_msg_data => x_msg_data,
550: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
551: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
552: x_return_status := FND_API.G_RET_STS_ERROR ;
553: ELSE
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: END IF;
556: END;

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

550: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
551: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
552: x_return_status := FND_API.G_RET_STS_ERROR ;
553: ELSE
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: END IF;
556: END;
557:
558:

Line 566: WHEN FND_API.G_EXC_ERROR THEN

562:
563:
564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
568: x_return_status := FND_API.G_RET_STS_ERROR ;
569: ROLLBACK TO ASSIGN_EVALUATORS_TO_AI_PUB;
570: igs_ad_gen_016.extract_msg_from_stack (

Line 567: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);

563:
564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
568: x_return_status := FND_API.G_RET_STS_ERROR ;
569: ROLLBACK TO ASSIGN_EVALUATORS_TO_AI_PUB;
570: igs_ad_gen_016.extract_msg_from_stack (
571: p_msg_at_index => l_msg_index,

Line 568: x_return_status := FND_API.G_RET_STS_ERROR ;

564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
568: x_return_status := FND_API.G_RET_STS_ERROR ;
569: ROLLBACK TO ASSIGN_EVALUATORS_TO_AI_PUB;
570: igs_ad_gen_016.extract_msg_from_stack (
571: p_msg_at_index => l_msg_index,
572: p_return_status => l_return_status,

Line 577: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);

573: p_msg_count => x_msg_count,
574: p_msg_data => x_msg_data,
575: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
576: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-2).text;
577: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);
578:
579: WHEN OTHERS THEN
580: ROLLBACK TO ASSIGN_EVALUATORS_TO_AI_PUB;
581: igs_ad_gen_016.extract_msg_from_stack (

Line 588: x_return_status := FND_API.G_RET_STS_ERROR ;

584: p_msg_count => x_msg_count,
585: p_msg_data => x_msg_data,
586: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
587: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
588: x_return_status := FND_API.G_RET_STS_ERROR ;
589: ELSE
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: END IF;
592:

Line 590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

586: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
587: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
588: x_return_status := FND_API.G_RET_STS_ERROR ;
589: ELSE
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: END IF;
592:
593: END ASSIGN_EVALUATORS_TO_AI;
594: