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_HE_SUSA_LGCY_PUB dependencies on FND_MSG_PUB

Line 27: FND_MSG_PUB.ADD;

23: -- Mandatory parameter check
24: IF p_hesa_susa_rec.person_number IS NULL THEN
25: -- Add excep to stack
26: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');
27: FND_MSG_PUB.ADD;
28: l_valid_params := FALSE;
29: END IF;
30:
31: -- Mandatory parameter check

Line 35: FND_MSG_PUB.ADD;

31: -- Mandatory parameter check
32: IF p_hesa_susa_rec.program_cd IS NULL THEN
33: -- Add excep to stack
34: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');
35: FND_MSG_PUB.ADD;
36: l_valid_params := FALSE;
37: END IF;
38:
39: -- Mandatory parameter check

Line 43: FND_MSG_PUB.ADD;

39: -- Mandatory parameter check
40: IF p_hesa_susa_rec.unit_set_cd IS NULL THEN
41: -- Add excep to stack
42: FND_MESSAGE.SET_NAME('IGS','IGS_HE_UNIT_SET_MAND');
43: FND_MSG_PUB.ADD;
44: l_valid_params := FALSE;
45: END IF;
46:
47: RETURN l_valid_params;

Line 93: FND_MSG_PUB.ADD;

89: x_sequence_number => p_sequence_number
90: ) THEN
91: -- Add excep to stack
92: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUSA_DTLS_EXIST');
93: FND_MSG_PUB.ADD;
94: RETURN 'W';
95: END IF;
96:
97: -- Foreign Key validations -----------------------------

Line 106: FND_MSG_PUB.ADD;

102: x_sequence_number => p_sequence_number
103: ) THEN
104: -- Add excep to stack
105: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUSA_REC_NEX');
106: FND_MSG_PUB.ADD;
107: l_ret_value := 'E';
108: END IF;
109:
110: -- Check if the New HE Entrant exists

Line 117: FND_MSG_PUB.ADD;

113: x_value => p_hesa_susa_rec.new_he_entrant_cd
114: ) THEN
115: -- Add excep to stack
116: FND_MESSAGE.SET_NAME('IGS','IGS_HE_NEW_HE_ENTRN_NEX');
117: FND_MSG_PUB.ADD;
118: l_ret_value := 'E';
119: END IF;
120: END IF;
121:

Line 129: FND_MSG_PUB.ADD;

125: x_value => p_hesa_susa_rec.term_time_accom
126: ) THEN
127: -- Add excep to stack
128: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TRM_ACCOMNEX');
129: FND_MSG_PUB.ADD;
130: l_ret_value := 'E';
131: END IF;
132: END IF;
133:

Line 141: FND_MSG_PUB.ADD;

137: x_value => p_hesa_susa_rec.disability_allow
138: ) THEN
139: -- Add excep to stack
140: FND_MESSAGE.SET_NAME('IGS','IGS_HE_DISB_ALLW_NEX');
141: FND_MSG_PUB.ADD;
142: l_ret_value := 'E';
143: END IF;
144: END IF;
145:

Line 153: FND_MSG_PUB.ADD;

149: x_value => p_hesa_susa_rec.additional_sup_band
150: ) THEN
151: -- ADD excep to stack
152: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ADD_SUP_BAND_NEX');
153: FND_MSG_PUB.ADD;
154: l_ret_value := 'E';
155: END IF;
156: END IF;
157:

Line 165: FND_MSG_PUB.ADD;

161: x_value => p_hesa_susa_rec.sldd_discrete_prov
162: ) THEN
163: -- Add excep to stack
164: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SLDD_DISCR_NEX');
165: FND_MSG_PUB.ADD;
166: l_ret_value := 'E';
167: END IF;
168: END IF;
169:

Line 177: FND_MSG_PUB.ADD;

173: x_value => p_hesa_susa_rec.study_mode
174: ) THEN
175: -- ADD excep to stack
176: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STUDY_MODE_NEX');
177: FND_MSG_PUB.ADD;
178: l_ret_value := 'E';
179: END IF;
180: END IF;
181:

Line 189: FND_MSG_PUB.ADD;

185: x_value => p_hesa_susa_rec.study_location
186: ) THEN
187: -- ADD excep to stack
188: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STUDY_LOC_NEX');
189: FND_MSG_PUB.ADD;
190: l_ret_value := 'E';
191: END IF;
192: END IF;
193:

Line 201: FND_MSG_PUB.ADD;

197: x_value => p_hesa_susa_rec.franchising_activity
198: ) THEN
199: -- ADD excep to stack
200: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FRANCH_ACT_NEX');
201: FND_MSG_PUB.ADD;
202: l_ret_value := 'E';
203: END IF;
204: END IF;
205:

Line 213: FND_MSG_PUB.ADD;

209: x_value => p_hesa_susa_rec.completion_status
210: ) THEN
211: -- ADD excep to stack
212: FND_MESSAGE.SET_NAME('IGS','IGS_HE_COMP_STATUS_NEX');
213: FND_MSG_PUB.ADD;
214: l_ret_value := 'E';
215: END IF;
216: END IF;
217:

Line 225: FND_MSG_PUB.ADD;

221: x_value => p_hesa_susa_rec.good_stand_marker
222: ) THEN
223: -- ADD excep to stack
224: FND_MESSAGE.SET_NAME('IGS','IGS_HE_GOOD_STAND_NEX');
225: FND_MSG_PUB.ADD;
226: l_ret_value := 'E';
227: END IF;
228: END IF;
229:

Line 237: FND_MSG_PUB.ADD;

233: x_value => p_hesa_susa_rec.complete_pyr_study_cd
234: ) THEN
235: -- ADD excep to stack
236: FND_MESSAGE.SET_NAME('IGS','IGS_HE_COMP_PYR_STUDY_NEX');
237: FND_MSG_PUB.ADD;
238: l_ret_value := 'E';
239: END IF;
240: END IF;
241:

Line 249: FND_MSG_PUB.ADD;

245: x_value => p_hesa_susa_rec.fundability_code
246: ) THEN
247: -- ADD excep to stack
248: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FUNDB_CODE_NEX');
249: FND_MSG_PUB.ADD;
250: l_ret_value := 'E';
251: END IF;
252: END IF;
253:

Line 261: FND_MSG_PUB.ADD;

257: x_value => p_hesa_susa_rec.fee_eligibility
258: ) THEN
259: -- ADD excep to stack
260: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FEE_ELGBL_NEX');
261: FND_MSG_PUB.ADD;
262: l_ret_value := 'E';
263: END IF;
264: END IF;
265:

Line 273: FND_MSG_PUB.ADD;

269: x_value => p_hesa_susa_rec.fee_band
270: ) THEN
271: -- ADD excep to stack
272: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FEE_BAND_NEX');
273: FND_MSG_PUB.ADD;
274: l_ret_value := 'E';
275: END IF;
276: END IF;
277:

Line 285: FND_MSG_PUB.ADD;

281: x_value => p_hesa_susa_rec.non_payment_reason
282: ) THEN
283: -- ADD excep to stack
284: FND_MESSAGE.SET_NAME('IGS','IGS_HE_NOPAY_REASON_NEX');
285: FND_MSG_PUB.ADD;
286: l_ret_value := 'E';
287: END IF;
288: END IF;
289:

Line 297: FND_MSG_PUB.ADD;

293: x_value => p_hesa_susa_rec.student_fee
294: ) THEN
295: -- ADD excep to stack
296: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STUD_FEE_NEX');
297: FND_MSG_PUB.ADD;
298: l_ret_value := 'E';
299: END IF;
300: END IF;
301:

Line 309: FND_MSG_PUB.ADD;

305: x_value => p_hesa_susa_rec.type_of_year
306: ) THEN
307: -- ADD excep to stack
308: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TYPE_OF_YEAR_NEX');
309: FND_MSG_PUB.ADD;
310: l_ret_value := 'E';
311: END IF;
312: END IF;
313:

Line 321: FND_MSG_PUB.ADD;

317: x_value => p_hesa_susa_rec.enh_fund_elig_cd
318: ) THEN
319: -- ADD excep to stack
320: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ELIG_ENH_FUND_NEX');
321: FND_MSG_PUB.ADD;
322: l_ret_value := 'E';
323: END IF;
324: END IF;
325:

Line 331: FND_MSG_PUB.ADD;

327: IF p_hesa_susa_rec.credit_level_achieved1 IS NOT NULL THEN
328: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved1) THEN
329: -- ADD excep to stack
330: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD1_NEX');
331: FND_MSG_PUB.ADD;
332: l_ret_value := 'E';
333: END IF;
334: END IF;
335:

Line 341: FND_MSG_PUB.ADD;

337: IF p_hesa_susa_rec.credit_level_achieved2 IS NOT NULL THEN
338: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved2) THEN
339: -- ADD excep to stack
340: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD2_NEX');
341: FND_MSG_PUB.ADD;
342: l_ret_value := 'E';
343: END IF;
344: END IF;
345:

Line 351: FND_MSG_PUB.ADD;

347: IF p_hesa_susa_rec.credit_level_achieved3 IS NOT NULL THEN
348: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved3) THEN
349: -- ADD excep to stack
350: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD3_NEX');
351: FND_MSG_PUB.ADD;
352: l_ret_value := 'E';
353: END IF;
354: END IF;
355:

Line 361: FND_MSG_PUB.ADD;

357: IF p_hesa_susa_rec.credit_level_achieved4 IS NOT NULL THEN
358: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved4) THEN
359: -- ADD excep to stack
360: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD4_NEX');
361: FND_MSG_PUB.ADD;
362: l_ret_value := 'E';
363: END IF;
364: END IF;
365:

Line 371: FND_MSG_PUB.ADD;

367: IF p_hesa_susa_rec.credit_level1 IS NOT NULL THEN
368: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level1) THEN
369: -- ADD excep to stack
370: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL1_NEX');
371: FND_MSG_PUB.ADD;
372: l_ret_value := 'E';
373: END IF;
374: END IF;
375:

Line 381: FND_MSG_PUB.ADD;

377: IF p_hesa_susa_rec.credit_level2 IS NOT NULL THEN
378: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level2) THEN
379: -- ADD excep to stack
380: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL2_NEX');
381: FND_MSG_PUB.ADD;
382: l_ret_value := 'E';
383: END IF;
384: END IF;
385:

Line 391: FND_MSG_PUB.ADD;

387: IF p_hesa_susa_rec.credit_level3 IS NOT NULL THEN
388: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level3) THEN
389: -- ADD excep to stack
390: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL3_NEX');
391: FND_MSG_PUB.ADD;
392: l_ret_value := 'E';
393: END IF;
394: END IF;
395:

Line 401: FND_MSG_PUB.ADD;

397: IF p_hesa_susa_rec.credit_level4 IS NOT NULL THEN
398: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level4) THEN
399: -- ADD excep to stack
400: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL4_NEX');
401: FND_MSG_PUB.ADD;
402: l_ret_value := 'E';
403: END IF;
404: END IF;
405:

Line 412: FND_MSG_PUB.ADD;

408: -- is within range 0 to 999 (inclusive)
409: IF p_hesa_susa_rec.credit_value_yop1 IS NOT NULL THEN
410: IF NOT p_hesa_susa_rec.credit_value_yop1 between 0 and 999 THEN
411: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CV_YOP1_RANGE_INVALID');
412: FND_MSG_PUB.ADD;
413: l_ret_value := 'E';
414: END IF;
415: END IF;
416:

Line 423: FND_MSG_PUB.ADD;

419: -- is within range 0 to 999 (inclusive)
420: IF p_hesa_susa_rec.credit_value_yop2 IS NOT NULL THEN
421: IF NOT p_hesa_susa_rec.credit_value_yop2 between 0 and 999 THEN
422: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CV_YOP2_RANGE_INVALID');
423: FND_MSG_PUB.ADD;
424: l_ret_value := 'E';
425: END IF;
426: END IF;
427:

Line 433: FND_MSG_PUB.ADD;

429: -- is within range 0 to 999 (inclusive)
430: IF p_hesa_susa_rec.credit_value_yop3 IS NOT NULL THEN
431: IF NOT p_hesa_susa_rec.credit_value_yop3 between 0 and 999 THEN
432: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CV_YOP3_RANGE_INVALID');
433: FND_MSG_PUB.ADD;
434: l_ret_value := 'E';
435: END IF;
436: END IF;
437:

Line 443: FND_MSG_PUB.ADD;

439: -- is within range 0 to 999 (inclusive)
440: IF p_hesa_susa_rec.credit_value_yop4 IS NOT NULL THEN
441: IF NOT p_hesa_susa_rec.credit_value_yop4 between 0 and 999 THEN
442: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CV_YOP4_RANGE_INVALID');
443: FND_MSG_PUB.ADD;
444: l_ret_value := 'E';
445: END IF;
446: END IF;
447:

Line 452: FND_MSG_PUB.ADD;

448: -- Check whether the Year Of Student field is within range 0 to 39 (inclusive)
449: IF p_hesa_susa_rec.year_stu IS NOT NULL THEN
450: IF NOT p_hesa_susa_rec.year_stu between 0 and 39 THEN
451: FND_MESSAGE.SET_NAME('IGS','IGS_HE_YEAR_STU_INVALID');
452: FND_MSG_PUB.ADD;
453: l_ret_value := 'E';
454: END IF;
455: END IF;
456:

Line 463: FND_MSG_PUB.ADD;

459: -- is within range 0 to 999 (inclusive)
460: IF p_hesa_susa_rec.credit_pt_achieved1 IS NOT NULL THEN
461: IF NOT p_hesa_susa_rec.credit_pt_achieved1 between 0 and 999 THEN
462: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CP_ACH1_INVALID');
463: FND_MSG_PUB.ADD;
464: l_ret_value := 'E';
465: END IF;
466: END IF;
467:

Line 474: FND_MSG_PUB.ADD;

470: -- is within range 0 to 999 (inclusive)
471: IF p_hesa_susa_rec.credit_pt_achieved2 IS NOT NULL THEN
472: IF NOT p_hesa_susa_rec.credit_pt_achieved2 between 0 and 999 THEN
473: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CP_ACH2_INVALID');
474: FND_MSG_PUB.ADD;
475: l_ret_value := 'E';
476: END IF;
477: END IF;
478:

Line 484: FND_MSG_PUB.ADD;

480: -- is within range 0 to 999 (inclusive)
481: IF p_hesa_susa_rec.credit_pt_achieved3 IS NOT NULL THEN
482: IF NOT p_hesa_susa_rec.credit_pt_achieved3 between 0 and 999 THEN
483: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CP_ACH3_INVALID');
484: FND_MSG_PUB.ADD;
485: l_ret_value := 'E';
486: END IF;
487: END IF;
488:

Line 494: FND_MSG_PUB.ADD;

490: -- is within range 0 to 999 (inclusive)
491: IF p_hesa_susa_rec.credit_pt_achieved4 IS NOT NULL THEN
492: IF NOT p_hesa_susa_rec.credit_pt_achieved4 between 0 and 999 THEN
493: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CP_ACH4_INVALID');
494: FND_MSG_PUB.ADD;
495: l_ret_value := 'E';
496: END IF;
497: END IF;
498:

Line 505: FND_MSG_PUB.ADD;

501: -- is within the range 0 to 100 (inclusive)
502: IF p_hesa_susa_rec.pro_not_taught IS NOT NULL THEN
503: IF NOT p_hesa_susa_rec.pro_not_taught between 0 and 100 THEN
504: FND_MESSAGE.SET_NAME('IGS','IGS_HE_PRO_NOT_TAUGHT_INVALID');
505: FND_MSG_PUB.ADD;
506: l_ret_value := 'E';
507: END IF;
508: END IF;
509:

Line 515: FND_MSG_PUB.ADD;

511: -- Check whether the FTE Intensity field is within range 0 to 300 (inclusive)
512: IF p_hesa_susa_rec.fte_intensity IS NOT NULL THEN
513: IF NOT p_hesa_susa_rec.fte_intensity between 0 and 300 THEN
514: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FTE_INTENSITY_INVALID');
515: FND_MSG_PUB.ADD;
516: l_ret_value := 'E';
517: END IF;
518: END IF;
519:

Line 528: FND_MSG_PUB.ADD;

524: OPEN c_fte_calc_type;
525: FETCH c_fte_calc_type INTO l_dummy;
526: IF c_fte_calc_type%NOTFOUND THEN
527: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FTE_CTYPE_RANGE_NEX');
528: FND_MSG_PUB.ADD;
529: l_ret_value := 'E';
530: END IF;
531: CLOSE c_fte_calc_type;
532: END IF;

Line 539: FND_MSG_PUB.ADD;

535: -- Check whether the FTE Intensity field is within range 0 to 300 (inclusive)
536: IF p_hesa_susa_rec.fte_perc_override IS NOT NULL THEN
537: IF NOT p_hesa_susa_rec.fte_perc_override between 0 and 300 THEN
538: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FTE_PERC_OVR_INVALID');
539: FND_MSG_PUB.ADD;
540: l_ret_value := 'E';
541: END IF;
542: END IF;
543:

Line 548: FND_MSG_PUB.ADD;

544: -- Check whether the Additional Support Cost field is within range 0 to 999999 (inclusive)
545: IF p_hesa_susa_rec.additional_sup_cost IS NOT NULL THEN
546: IF NOT p_hesa_susa_rec.additional_sup_cost between 0 and 999999 THEN
547: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ADD_SUPP_COST_INVALID');
548: FND_MSG_PUB.ADD;
549: l_ret_value := 'E';
550: END IF;
551: END IF;
552:

Line 558: FND_MSG_PUB.ADD;

554: -- range 0.0000 to 9.9999 (inclusive)
555: IF p_hesa_susa_rec.disadv_uplift_factor IS NOT NULL THEN
556: IF NOT p_hesa_susa_rec.disadv_uplift_factor between 0.0000 and 9.9999 THEN
557: FND_MESSAGE.SET_NAME('IGS','IGS_HE_DIS_UPLIFT_FTR_INVALID');
558: FND_MSG_PUB.ADD;
559: l_ret_value := 'E';
560: END IF;
561: END IF;
562:

Line 571: FND_MSG_PUB.ADD;

567: p_unit_set_cd => p_hesa_susa_rec.unit_set_cd,
568: p_grad_sch_grade => p_hesa_susa_rec.grad_sch_grade) THEN
569: -- ADD excep to stack
570: FND_MESSAGE.SET_NAME('IGS','IGS_HE_GRD_SCH_GRADE_NEX');
571: FND_MSG_PUB.ADD;
572: l_ret_value := 'E';
573: END IF;
574: END IF;
575:

Line 581: FND_MSG_PUB.ADD;

577: IF p_hesa_susa_rec.teaching_inst1 IS NOT NULL THEN
578: IF NOT igs_en_hesa_pkg.check_teach_inst (p_teaching_inst => p_hesa_susa_rec.teaching_inst1) THEN
579: -- ADD excep to stack
580: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TCH_INST1_POSTSEC_NEX');
581: FND_MSG_PUB.ADD;
582: l_ret_value := 'E';
583: END IF;
584: END IF;
585:

Line 591: FND_MSG_PUB.ADD;

587: IF p_hesa_susa_rec.teaching_inst2 IS NOT NULL THEN
588: IF NOT igs_en_hesa_pkg.check_teach_inst (p_teaching_inst => p_hesa_susa_rec.teaching_inst2) THEN
589: -- ADD excep to stack
590: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TCH_INST2_POSTSEC_NEX');
591: FND_MSG_PUB.ADD;
592: l_ret_value := 'E';
593: END IF;
594: END IF;
595:

Line 621: FND_MSG_PUB.ADD;

617: IF 'PRENRL_YR' <> igs_en_hesa_pkg.get_unit_set_cat (p_unit_set_cd => p_hesa_susa_rec.unit_set_cd,
618: p_us_version_number => p_us_version_number) THEN
619: -- ADD excep to stack
620: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUSA_PRE_YEAR_US');
621: FND_MSG_PUB.ADD;
622: l_br_val_failed := TRUE;
623: END IF;
624:
625: -- Check whether any validation failed, if yes then return FALSE otherwise return TRUE

Line 688: FND_MSG_PUB.INITIALIZE;

684: END IF;
685:
686: -- If the calling program has passed the parameter for initializing the message list
687: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
688: FND_MSG_PUB.INITIALIZE;
689: END IF;
690:
691: -- Set the return status to success
692: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 698: FND_MSG_PUB.ADD;

694:
695: -- Check whether the country profile value is GB
696: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'NONE') <> 'GB' THEN
697: FND_MESSAGE.SET_NAME ('IGS','IGS_UC_HE_NOT_ENABLED');
698: FND_MSG_PUB.ADD;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: l_insert_flag := FALSE;
701: END IF;
702:

Line 722: FND_MSG_PUB.ADD;

718:
719: IF l_person_id IS NULL THEN
720: -- ADD excep to stack
721: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
722: FND_MSG_PUB.ADD;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: l_insert_flag := FALSE;
725: END IF;
726: END IF;

Line 739: FND_MSG_PUB.ADD;

735:
736: IF l_us_version_number IS NULL OR l_sequence_number IS NULL THEN
737: -- ADD excep to stack
738: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SUSA_REC_NEX');
739: FND_MSG_PUB.ADD;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: l_insert_flag := FALSE;
742: END IF;
743: END IF;

Line 931: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

927: COMMIT WORK;
928: END IF;
929:
930:
931: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
932: p_data => x_msg_data);
933:
934:
935: EXCEPTION

Line 939: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN
937: ROLLBACK TO create_hesa_susa_pub;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
940: p_data => x_msg_data);
941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
942: ROLLBACK TO create_hesa_susa_pub;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 944: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

940: p_data => x_msg_data);
941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
942: ROLLBACK TO create_hesa_susa_pub;
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
945: p_data => x_msg_data);
946: WHEN OTHERS THEN
947: ROLLBACK TO create_hesa_susa_pub;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 949: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

945: p_data => x_msg_data);
946: WHEN OTHERS THEN
947: ROLLBACK TO create_hesa_susa_pub;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
950: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
951: l_api_name);
952: END IF;
953: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 950: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,

946: WHEN OTHERS THEN
947: ROLLBACK TO create_hesa_susa_pub;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
950: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
951: l_api_name);
952: END IF;
953: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
954: p_data => x_msg_data);

Line 953: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

949: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
950: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
951: l_api_name);
952: END IF;
953: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
954: p_data => x_msg_data);
955:
956:
957: END create_hesa_susa;