DBA Data[Home] [Help]

APPS.IGF_DB_AWD_DISB_DTL_PKG dependencies on IGS_GE_MSG_STACK

Line 72: igs_ge_msg_stack.add;

68: FETCH cur_old_ref_values INTO old_references;
69: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
70: CLOSE cur_old_ref_values;
71: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
72: igs_ge_msg_stack.add;
73: app_exception.raise_exception;
74: RETURN;
75: END IF;
76: CLOSE cur_old_ref_values;

Line 147: igs_ge_msg_stack.add;

143: new_references.award_id,
144: new_references.disb_num
145: ) THEN
146: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150:
151: END check_parent_existance;

Line 222: igs_ge_msg_stack.add;

218: FETCH cur_rowid INTO lv_rowid;
219: IF (cur_rowid%FOUND) THEN
220: CLOSE cur_rowid;
221: fnd_message.set_name ('IGF', 'IGF_DB_DDTL_AWDD_FK');
222: igs_ge_msg_stack.add;
223: app_exception.raise_exception;
224: RETURN;
225: END IF;
226: CLOSE cur_rowid;

Line 367: igs_ge_msg_stack.add;

363: FETCH c_sf_credit_id INTO l_sf_credit_id;
364: IF c_sf_credit_id%FOUND THEN
365: CLOSE c_sf_credit_id;
366: fnd_message.set_name ('IGF','IGF_DB_DUP_CR_NUM');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: ELSE
370: CLOSE c_sf_credit_id;
371: END IF;

Line 381: igs_ge_msg_stack.add;

377: FETCH c_spnsr_credit_id INTO l_spnsr_credit_id;
378: IF c_spnsr_credit_id%FOUND THEN
379: CLOSE c_spnsr_credit_id;
380: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_CR_NUM');
381: igs_ge_msg_stack.add;
382: app_exception.raise_exception;
383: ELSE
384: CLOSE c_spnsr_credit_id;
385: END IF;

Line 395: igs_ge_msg_stack.add;

391: FETCH c_spnsr_charge_id INTO l_spnsr_charge_id;
392: IF c_spnsr_charge_id%FOUND THEN
393: CLOSE c_spnsr_charge_id;
394: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_INV_NUM');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: ELSE
398: CLOSE c_spnsr_charge_id;
399: END IF;

Line 409: igs_ge_msg_stack.add;

405: FETCH c_sf_invoice_num INTO l_sf_invoice_num;
406: IF c_sf_invoice_num%FOUND THEN
407: CLOSE c_sf_invoice_num;
408: fnd_message.set_name ('IGF','IGF_DB_DUP_INV_NUM');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: ELSE
412: CLOSE c_sf_invoice_num;
413: END IF;

Line 424: igs_ge_msg_stack.add;

420: new_references.disb_seq_num
421: )
422: ) THEN
423: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
424: igs_ge_msg_stack.add;
425: app_exception.raise_exception;
426: END IF;
427: check_parent_existance;
428: ELSIF (p_action = 'UPDATE') THEN

Line 436: igs_ge_msg_stack.add;

432: FETCH c_sf_credit_id INTO l_sf_credit_id;
433: IF c_sf_credit_id%FOUND THEN
434: CLOSE c_sf_credit_id;
435: fnd_message.set_name ('IGF','IGF_DB_DUP_CR_NUM');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: ELSE
439: CLOSE c_sf_credit_id;
440: END IF;

Line 450: igs_ge_msg_stack.add;

446: FETCH c_spnsr_credit_id INTO l_spnsr_credit_id;
447: IF c_spnsr_credit_id%FOUND THEN
448: CLOSE c_spnsr_credit_id;
449: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_CR_NUM');
450: igs_ge_msg_stack.add;
451: app_exception.raise_exception;
452: ELSE
453: CLOSE c_spnsr_credit_id;
454: END IF;

Line 464: igs_ge_msg_stack.add;

460: FETCH c_spnsr_charge_id INTO l_spnsr_charge_id;
461: IF c_spnsr_charge_id%FOUND THEN
462: CLOSE c_spnsr_charge_id;
463: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_INV_NUM');
464: igs_ge_msg_stack.add;
465: app_exception.raise_exception;
466: ELSE
467: CLOSE c_spnsr_charge_id;
468: END IF;

Line 478: igs_ge_msg_stack.add;

474: FETCH c_sf_invoice_num INTO l_sf_invoice_num;
475: IF c_sf_invoice_num%FOUND THEN
476: CLOSE c_sf_invoice_num;
477: fnd_message.set_name ('IGF','IGF_DB_DUP_INV_NUM');
478: igs_ge_msg_stack.add;
479: app_exception.raise_exception;
480: ELSE
481: CLOSE c_sf_invoice_num;
482: END IF;

Line 499: igs_ge_msg_stack.add;

495: new_references.disb_seq_num
496: )
497: ) THEN
498: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
499: igs_ge_msg_stack.add;
500: app_exception.raise_exception;
501: END IF;
502: ELSIF (p_action = 'VALIDATE_DELETE') THEN
503: null;

Line 598: igs_ge_msg_stack.add;

594: x_program_update_date := SYSDATE;
595: END IF;
596: ELSE
597: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
598: igs_ge_msg_stack.add;
599: app_exception.raise_exception;
600: END IF;
601:
602: before_dml(

Line 816: igs_ge_msg_stack.add;

812: OPEN c1;
813: FETCH c1 INTO tlinfo;
814: IF (c1%notfound) THEN
815: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
816: igs_ge_msg_stack.add;
817: CLOSE c1;
818: app_exception.raise_exception;
819: RETURN;
820: END IF;

Line 848: igs_ge_msg_stack.add;

844: ) THEN
845: NULL;
846: ELSE
847: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
848: igs_ge_msg_stack.add;
849: app_exception.raise_exception;
850: END IF;
851:
852: RETURN;

Line 924: igs_ge_msg_stack.add;

920: x_last_update_login := -1;
921: END IF;
922: ELSE
923: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
924: igs_ge_msg_stack.add;
925: app_exception.raise_exception;
926: END IF;
927:
928: before_dml(