DBA Data[Home] [Help]

APPS.IGF_SE_PAYMENT_PKG dependencies on APP_EXCEPTION

Line 89: app_exception.raise_exception;

85: CLOSE cur_old_ref_values;
86: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
87:
88: igs_ge_msg_stack.add;
89: app_exception.raise_exception;
90: RETURN;
91: END IF;
92: CLOSE cur_old_ref_values;
93:

Line 137: app_exception.raise_exception;

133: new_references.person_id
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: END check_parent_existance;
141:

Line 213: app_exception.raise_exception;

209: IF (cur_rowid%FOUND) THEN
210: CLOSE cur_rowid;
211: fnd_message.set_name ('IGF', 'IGF_SE_SEP_HP_FK');
212: igs_ge_msg_stack.add;
213: app_exception.raise_exception;
214: RETURN;
215: END IF;
216: CLOSE cur_rowid;
217:

Line 282: app_exception.raise_exception;

278:
279: IF new_references.payroll_date IS NULL THEN
280: fnd_message.set_name('IGF','IGF_SE_PAY_DT_INVALID');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284:
285: IF new_references.auth_id IS NULL THEN
286: fnd_message.set_name('IGF','IGF_SE_AUTH_ID_NULL');

Line 288: app_exception.raise_exception;

284:
285: IF new_references.auth_id IS NULL THEN
286: fnd_message.set_name('IGF','IGF_SE_AUTH_ID_NULL');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: END IF;
290:
291: IF new_references.person_id IS NULL THEN
292: fnd_message.set_name('IGF','IGF_SE_PERSON_ID_NULL');

Line 294: app_exception.raise_exception;

290:
291: IF new_references.person_id IS NULL THEN
292: fnd_message.set_name('IGF','IGF_SE_PERSON_ID_NULL');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296:
297: IF new_references.paid_amount IS NULL THEN
298: fnd_message.set_name('IGF','IGF_SE_PAID_AMT_NULL');

Line 300: app_exception.raise_exception;

296:
297: IF new_references.paid_amount IS NULL THEN
298: fnd_message.set_name('IGF','IGF_SE_PAID_AMT_NULL');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: END IF;
302:
303: IF new_references.source IS NULL THEN
304: fnd_message.set_name('IGF','IGF_SE_SOURCE_INVALID');

Line 306: app_exception.raise_exception;

302:
303: IF new_references.source IS NULL THEN
304: fnd_message.set_name('IGF','IGF_SE_SOURCE_INVALID');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308:
309: OPEN c_auth(new_references.auth_id,new_references.person_id);
310: FETCH c_auth INTO l_auth;

Line 322: app_exception.raise_exception;

318: FETCH c_pers_num INTO l_pers_num;
319: CLOSE c_pers_num;
320: fnd_message.set_token('PERSON_NUM',l_pers_num);
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324: CLOSE c_auth;
325:
326: l_fund := NULL;

Line 338: app_exception.raise_exception;

334: FETCH c_pers_num INTO l_pers_num;
335: CLOSE c_pers_num;
336: fnd_message.set_token('PERSON_NUM',l_pers_num);
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340:
341: OPEN c_lookup('IGF_SE_SOURCE',new_references.source);
342: FETCH c_lookup INTO l_lookup;

Line 347: app_exception.raise_exception;

343: IF c_lookup%NOTFOUND THEN
344: CLOSE c_lookup;
345: fnd_message.set_name('IGF','IGF_SE_SOURCE_INVALID');
346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348: END IF;
349:
350: END check_constraints;
351:

Line 412: app_exception.raise_exception;

408: ) THEN
409:
410: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414: check_parent_existance;
415: check_constraints;
416: ELSIF (p_action = 'UPDATE') THEN

Line 429: app_exception.raise_exception;

425: ) THEN
426:
427: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
428: igs_ge_msg_stack.add;
429: app_exception.raise_exception;
430: END IF;
431: END IF;
432:
433: END before_dml;

Line 522: app_exception.raise_exception;

518: END IF;
519: ELSE
520: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
521: igs_ge_msg_stack.add;
522: app_exception.raise_exception;
523: END IF;
524:
525: SELECT igf_se_payment_s.NEXTVAL
526: INTO x_transaction_id

Line 643: app_exception.raise_exception;

639: EXCEPTION
640: WHEN OTHERS THEN
641: fnd_message.set_name('IGF','IGF_SE_ERR_PAYINT_UPD');
642: igs_ge_msg_stack.add;
643: app_exception.raise_exception;
644: END;
645:
646: ELSE
647: CLOSE c_payment_int;

Line 695: app_exception.raise_exception;

691: WHEN OTHERS THEN
692:
693: fnd_message.set_name('IGF','IGF_SE_ERR_PAYINT_UPD');
694: igs_ge_msg_stack.add;
695: app_exception.raise_exception;
696: END;
697:
698: ELSE
699: CLOSE c_payment_int;

Line 715: app_exception.raise_exception;

711:
712: FND_MESSAGE.SET_NAME('IGF', 'IGF_SE_ERR_PAY_ADJ');
713: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
714: igs_ge_msg_stack.add;
715: app_exception.raise_exception;
716:
717:
718: END IF;
719: END; -- exception of calling adjustment

Line 769: app_exception.raise_exception;

765: IF (c1%notfound) THEN
766: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
767: igs_ge_msg_stack.add;
768: CLOSE c1;
769: app_exception.raise_exception;
770: RETURN;
771: END IF;
772: CLOSE c1;
773:

Line 788: app_exception.raise_exception;

784: NULL;
785: ELSE
786: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
787: igs_ge_msg_stack.add;
788: app_exception.raise_exception;
789: END IF;
790:
791: RETURN;
792:

Line 867: app_exception.raise_exception;

863: END IF;
864: ELSE
865: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
866: igs_ge_msg_stack.add;
867: app_exception.raise_exception;
868: END IF;
869:
870: before_dml(
871: p_action => 'UPDATE',

Line 968: app_exception.raise_exception;

964: EXCEPTION
965: WHEN OTHERS THEN
966: fnd_message.set_name('IGF','IGF_SE_ERR_PAYINT_UPD');
967: igs_ge_msg_stack.add;
968: app_exception.raise_exception;
969: END; -- new payroll not null
970: ELSE
971: CLOSE c_payment_int;
972: END IF;

Line 1017: app_exception.raise_exception;

1013: EXCEPTION
1014: WHEN OTHERS THEN
1015: fnd_message.set_name('IGF','IGF_SE_ERR_PAYINT_UPD');
1016: igs_ge_msg_stack.add;
1017: app_exception.raise_exception;
1018: END;
1019: ELSE
1020: CLOSE c_payment_int;
1021: ROLLBACK TO se_payment_upd;

Line 1037: app_exception.raise_exception;

1033:
1034: FND_MESSAGE.SET_NAME('IGF', 'IGF_SE_ERR_PAY_ADJ');
1035: FND_MESSAGE.SET_TOKEN('ERROR',l_error_meaming);
1036: igs_ge_msg_stack.add;
1037: app_exception.raise_exception;
1038:
1039: END IF;
1040: END; -- exception of calling adjustment
1041: END update_row;