[Home] [Help]
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;
77:
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;
152:
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;
227:
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;
372: END IF;
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;
386: END IF;
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;
400: END IF;
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;
414: END IF;
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
429: -- Check for uniqueness of Credit Number
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;
441: END IF;
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;
455: END IF;
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;
469: END IF;
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;
483: END IF;
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;
504: END IF;
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(
603: p_action => 'INSERT',
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;
821: CLOSE c1;
822:
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;
853:
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(
929: p_action => 'UPDATE',