DBA Data[Home] [Help]

APPS.IGF_DB_AWD_DISB_DTL_PKG dependencies on FND_MESSAGE

Line 71: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

67: OPEN cur_old_ref_values;
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;

Line 146: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

142: ELSIF NOT igf_aw_awd_disb_pkg.get_pk_for_validation (
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:

Line 221: fnd_message.set_name ('IGF', 'IGF_DB_DDTL_AWDD_FK');

217: OPEN cur_rowid;
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;

Line 366: fnd_message.set_name ('IGF','IGF_DB_DUP_CR_NUM');

362: OPEN c_sf_credit_id(new_references.sf_credit_id);
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;

Line 380: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_CR_NUM');

376: OPEN c_spnsr_credit_id(new_references.spnsr_credit_id);
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;

Line 394: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_INV_NUM');

390: OPEN c_spnsr_charge_id(new_references.spnsr_charge_id);
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;

Line 408: fnd_message.set_name ('IGF','IGF_DB_DUP_INV_NUM');

404: OPEN c_sf_invoice_num (new_references.sf_invoice_num);
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;

Line 423: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

419: new_references.disb_num,
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;

Line 435: fnd_message.set_name ('IGF','IGF_DB_DUP_CR_NUM');

431: OPEN c_sf_credit_id(new_references.sf_credit_id);
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;

Line 449: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_CR_NUM');

445: OPEN c_spnsr_credit_id(new_references.spnsr_credit_id);
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;

Line 463: fnd_message.set_name ('IGF','IGF_DB_DUP_SP_INV_NUM');

459: OPEN c_spnsr_charge_id(new_references.spnsr_charge_id);
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;

Line 477: fnd_message.set_name ('IGF','IGF_DB_DUP_INV_NUM');

473: OPEN c_sf_invoice_num (new_references.sf_invoice_num);
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;

Line 498: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

494: new_references.disb_num,
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

Line 597: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

593: ELSE
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:

Line 815: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

811:
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;

Line 847: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

843: AND ((tlinfo.ld_sequence_number= x_ld_sequence_number) OR ((tlinfo.ld_sequence_number IS NULL) AND (x_ld_sequence_number IS NULL)))
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:

Line 923: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

919: IF (x_last_update_login IS NULL) THEN
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: