DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APINT dependencies on FND_MESSAGE

Line 274: fnd_message.set_name('IGS','IGS_FI_HZ_NO_PAY_ADD');

270: -- condition
271: IF l_n_hz_cntr = 0 THEN
272: fnd_file.put_line(fnd_file.log,
273: g_v_lbl_status||' : '||g_v_lbl_todo);
274: fnd_message.set_name('IGS','IGS_FI_HZ_NO_PAY_ADD');
275: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
276: fnd_file.put_line(fnd_file.log,
277: fnd_message.get);
278: p_b_status := FALSE;

Line 275: fnd_message.set_token('PAYEE_NUM',p_v_party_number);

271: IF l_n_hz_cntr = 0 THEN
272: fnd_file.put_line(fnd_file.log,
273: g_v_lbl_status||' : '||g_v_lbl_todo);
274: fnd_message.set_name('IGS','IGS_FI_HZ_NO_PAY_ADD');
275: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
276: fnd_file.put_line(fnd_file.log,
277: fnd_message.get);
278: p_b_status := FALSE;
279: RETURN;

Line 277: fnd_message.get);

273: g_v_lbl_status||' : '||g_v_lbl_todo);
274: fnd_message.set_name('IGS','IGS_FI_HZ_NO_PAY_ADD');
275: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
276: fnd_file.put_line(fnd_file.log,
277: fnd_message.get);
278: p_b_status := FALSE;
279: RETURN;
280: END IF;
281:

Line 288: fnd_message.set_name('IGS','IGS_FI_HZ_UNQ_PAY_ADD');

284: -- condition
285: IF l_n_hz_cntr > 1 THEN
286: fnd_file.put_line(fnd_file.log,
287: g_v_lbl_status||' : '||g_v_lbl_todo);
288: fnd_message.set_name('IGS','IGS_FI_HZ_UNQ_PAY_ADD');
289: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
290: fnd_file.put_line(fnd_file.log,
291: fnd_message.get);
292: p_b_status := FALSE;

Line 289: fnd_message.set_token('PAYEE_NUM',p_v_party_number);

285: IF l_n_hz_cntr > 1 THEN
286: fnd_file.put_line(fnd_file.log,
287: g_v_lbl_status||' : '||g_v_lbl_todo);
288: fnd_message.set_name('IGS','IGS_FI_HZ_UNQ_PAY_ADD');
289: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
290: fnd_file.put_line(fnd_file.log,
291: fnd_message.get);
292: p_b_status := FALSE;
293: RETURN;

Line 291: fnd_message.get);

287: g_v_lbl_status||' : '||g_v_lbl_todo);
288: fnd_message.set_name('IGS','IGS_FI_HZ_UNQ_PAY_ADD');
289: fnd_message.set_token('PAYEE_NUM',p_v_party_number);
290: fnd_file.put_line(fnd_file.log,
291: fnd_message.get);
292: p_b_status := FALSE;
293: RETURN;
294: END IF;
295:

Line 397: fnd_message.set_name ( 'IGS', l_v_message_name );

393: -- If this value is NULL or OTHER then this process should error out.
394: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
395: p_v_message_name => l_v_message_name );
396: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
397: fnd_message.set_name ( 'IGS', l_v_message_name );
398: -- mark that process shouldn't run anymore.
399: l_b_run_process := FALSE;
400: END IF;
401:

Line 482: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

478: fnd_file.new_line(fnd_file.log);
479:
480: -- If Manage Accounts validation fails then log the message and return false
481: IF NOT l_b_run_process THEN
482: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
483: RETURN FALSE;
484: END IF;
485:
486: -- get the refund destination

Line 492: fnd_message.set_name('IGS',

488:
489: -- If the Refund Destination is OTHER or is NULL then log the error message
490: IF l_v_rfnd_destination = g_v_other OR l_v_rfnd_destination IS NULL THEN
491: l_b_val_parm := FALSE;
492: fnd_message.set_name('IGS',
493: 'IGS_FI_RFND_DST_PAY');
494: fnd_file.put_line(fnd_file.log,
495: fnd_message.get);
496: l_b_val_parm := FALSE;

Line 495: fnd_message.get);

491: l_b_val_parm := FALSE;
492: fnd_message.set_name('IGS',
493: 'IGS_FI_RFND_DST_PAY');
494: fnd_file.put_line(fnd_file.log,
495: fnd_message.get);
496: l_b_val_parm := FALSE;
497: RETURN l_b_val_parm;
498: END IF;
499:

Line 505: fnd_message.set_name('IGS',

501: OPEN c_ctrl;
502: FETCH c_ctrl INTO g_n_org_id, g_v_dflt_sup_site;
503: IF c_ctrl%NOTFOUND THEN
504: l_b_val_parm := FALSE;
505: fnd_message.set_name('IGS',
506: 'IGS_FI_SYSTEM_OPT_SETUP');
507: fnd_file.put_line(fnd_file.log,
508: fnd_message.get);
509: END IF;

Line 508: fnd_message.get);

504: l_b_val_parm := FALSE;
505: fnd_message.set_name('IGS',
506: 'IGS_FI_SYSTEM_OPT_SETUP');
507: fnd_file.put_line(fnd_file.log,
508: fnd_message.get);
509: END IF;
510: CLOSE c_ctrl;
511:
512: -- If the payables operating unit is not set up, then check if the

Line 523: fnd_message.set_name('IGS',

519: CLOSE c_fnd_prod;
520:
521: IF l_c_fnd_prod.multi_org_flag = 'Y' THEN
522: l_b_val_parm := FALSE;
523: fnd_message.set_name('IGS',
524: 'IGS_FI_AP_ORG_ID_NOTSETUP');
525: fnd_file.put_line(fnd_file.log,
526: fnd_message.get);
527: END IF;

Line 526: fnd_message.get);

522: l_b_val_parm := FALSE;
523: fnd_message.set_name('IGS',
524: 'IGS_FI_AP_ORG_ID_NOTSETUP');
525: fnd_file.put_line(fnd_file.log,
526: fnd_message.get);
527: END IF;
528: END IF;
529:
530: -- Set the Org Id

Line 537: fnd_message.set_name('IGS',

533: -- If the create supplier parameter is Null or the test run parameter is null or
534: -- Invoice Payment Term parameter is NULL, then log an error message in the log file
535: IF p_v_create_supplier IS NULL OR p_v_test_run IS NULL OR p_n_inv_pay_term IS NULL THEN
536: l_b_val_parm := FALSE;
537: fnd_message.set_name('IGS',
538: 'IGS_FI_PARAMETER_NULL');
539: fnd_file.put_line(fnd_file.log,
540: fnd_message.get);
541: END IF;

Line 540: fnd_message.get);

536: l_b_val_parm := FALSE;
537: fnd_message.set_name('IGS',
538: 'IGS_FI_PARAMETER_NULL');
539: fnd_file.put_line(fnd_file.log,
540: fnd_message.get);
541: END IF;
542:
543: -- If the Supplier Type parameter is not null but the create supplier parameter
544: -- has value as N, then error message should be logged.

Line 547: fnd_message.set_name('IGS',

543: -- If the Supplier Type parameter is not null but the create supplier parameter
544: -- has value as N, then error message should be logged.
545: IF p_v_supplier_type IS NOT NULL and p_v_create_supplier = 'N' THEN
546: l_b_val_parm := FALSE;
547: fnd_message.set_name('IGS',
548: 'IGS_FI_INV_SUP_TYPE');
549: fnd_file.put_line(fnd_file.log,
550: fnd_message.get);
551: END IF;

Line 550: fnd_message.get);

546: l_b_val_parm := FALSE;
547: fnd_message.set_name('IGS',
548: 'IGS_FI_INV_SUP_TYPE');
549: fnd_file.put_line(fnd_file.log,
550: fnd_message.get);
551: END IF;
552:
553: -- If party validation has failed earlier
554: IF NOT l_b_party_flag THEN

Line 555: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

551: END IF;
552:
553: -- If party validation has failed earlier
554: IF NOT l_b_party_flag THEN
555: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
556: fnd_message.set_token('PARAMETER',g_v_lbl_party);
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558: END IF;
559:

Line 556: fnd_message.set_token('PARAMETER',g_v_lbl_party);

552:
553: -- If party validation has failed earlier
554: IF NOT l_b_party_flag THEN
555: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
556: fnd_message.set_token('PARAMETER',g_v_lbl_party);
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558: END IF;
559:
560: -- If the person group validation has failed earlier or the person group

Line 557: fnd_file.put_line(fnd_file.log, fnd_message.get);

553: -- If party validation has failed earlier
554: IF NOT l_b_party_flag THEN
555: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
556: fnd_message.set_token('PARAMETER',g_v_lbl_party);
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558: END IF;
559:
560: -- If the person group validation has failed earlier or the person group
561: -- is closed, then error message is logged

Line 563: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

559:
560: -- If the person group validation has failed earlier or the person group
561: -- is closed, then error message is logged
562: IF NOT l_b_pers_grp_flag OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
563: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
564: fnd_message.set_token('PARAMETER',g_v_lbl_person_group);
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: END IF;
567:

Line 564: fnd_message.set_token('PARAMETER',g_v_lbl_person_group);

560: -- If the person group validation has failed earlier or the person group
561: -- is closed, then error message is logged
562: IF NOT l_b_pers_grp_flag OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
563: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
564: fnd_message.set_token('PARAMETER',g_v_lbl_person_group);
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: END IF;
567:
568: -- If the Supplier Type validation has failed earlier or the inactive date of the

Line 565: fnd_file.put_line(fnd_file.log, fnd_message.get);

561: -- is closed, then error message is logged
562: IF NOT l_b_pers_grp_flag OR NVL(l_c_pers_id_grp.closed_ind,'N') = 'Y' THEN
563: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
564: fnd_message.set_token('PARAMETER',g_v_lbl_person_group);
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: END IF;
567:
568: -- If the Supplier Type validation has failed earlier or the inactive date of the
569: -- supplier type is less than System Date, then error message is logged

Line 571: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

567:
568: -- If the Supplier Type validation has failed earlier or the inactive date of the
569: -- supplier type is less than System Date, then error message is logged
570: IF (NOT l_b_sup_type_flag) OR NOT (TRUNC(NVL(l_c_sup_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
571: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
572: fnd_message.set_token('PARAMETER',g_v_lbl_suppl_type);
573: fnd_file.put_line(fnd_file.log, fnd_message.get);
574: END IF;
575:

Line 572: fnd_message.set_token('PARAMETER',g_v_lbl_suppl_type);

568: -- If the Supplier Type validation has failed earlier or the inactive date of the
569: -- supplier type is less than System Date, then error message is logged
570: IF (NOT l_b_sup_type_flag) OR NOT (TRUNC(NVL(l_c_sup_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
571: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
572: fnd_message.set_token('PARAMETER',g_v_lbl_suppl_type);
573: fnd_file.put_line(fnd_file.log, fnd_message.get);
574: END IF;
575:
576: -- The Invoice Pay group parameter validation has failed earlier or the inactive date of the

Line 573: fnd_file.put_line(fnd_file.log, fnd_message.get);

569: -- supplier type is less than System Date, then error message is logged
570: IF (NOT l_b_sup_type_flag) OR NOT (TRUNC(NVL(l_c_sup_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
571: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
572: fnd_message.set_token('PARAMETER',g_v_lbl_suppl_type);
573: fnd_file.put_line(fnd_file.log, fnd_message.get);
574: END IF;
575:
576: -- The Invoice Pay group parameter validation has failed earlier or the inactive date of the
577: -- Invoice Pay group is less than the current date, then error message is logged

Line 579: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

575:
576: -- The Invoice Pay group parameter validation has failed earlier or the inactive date of the
577: -- Invoice Pay group is less than the current date, then error message is logged
578: IF (NOT l_b_inv_pay_grp_flag) OR NOT (TRUNC(NVL(l_c_grp_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
579: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
580: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
581: fnd_file.put_line(fnd_file.log, fnd_message.get);
582: END IF;
583:

Line 580: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);

576: -- The Invoice Pay group parameter validation has failed earlier or the inactive date of the
577: -- Invoice Pay group is less than the current date, then error message is logged
578: IF (NOT l_b_inv_pay_grp_flag) OR NOT (TRUNC(NVL(l_c_grp_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
579: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
580: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
581: fnd_file.put_line(fnd_file.log, fnd_message.get);
582: END IF;
583:
584: -- If the Term Id passed as input parameter does not exist

Line 581: fnd_file.put_line(fnd_file.log, fnd_message.get);

577: -- Invoice Pay group is less than the current date, then error message is logged
578: IF (NOT l_b_inv_pay_grp_flag) OR NOT (TRUNC(NVL(l_c_grp_type.inactive_date,sysdate)) >= TRUNC(sysdate)) THEN
579: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
580: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
581: fnd_file.put_line(fnd_file.log, fnd_message.get);
582: END IF;
583:
584: -- If the Term Id passed as input parameter does not exist
585: IF NOT l_b_term_flag THEN

Line 586: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

582: END IF;
583:
584: -- If the Term Id passed as input parameter does not exist
585: IF NOT l_b_term_flag THEN
586: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
587: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
588: fnd_file.put_line(fnd_file.log, fnd_message.get);
589: END IF;
590:

Line 587: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);

583:
584: -- If the Term Id passed as input parameter does not exist
585: IF NOT l_b_term_flag THEN
586: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
587: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
588: fnd_file.put_line(fnd_file.log, fnd_message.get);
589: END IF;
590:
591: -- If the sysdate is not within the Start date active and end date active

Line 588: fnd_file.put_line(fnd_file.log, fnd_message.get);

584: -- If the Term Id passed as input parameter does not exist
585: IF NOT l_b_term_flag THEN
586: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
587: fnd_message.set_token('PARAMETER',g_v_lbl_pay_grp);
588: fnd_file.put_line(fnd_file.log, fnd_message.get);
589: END IF;
590:
591: -- If the sysdate is not within the Start date active and end date active
592: -- of the Term passed as input, log an error message in the log file

Line 596: fnd_message.set_name('IGS','IGS_FI_AP_TERM_INACTIVE');

592: -- of the Term passed as input, log an error message in the log file
593: IF NOT (TRUNC(sysdate) BETWEEN TRUNC(NVL(l_c_ap_term.start_date_active, sysdate)) AND
594: TRUNC(NVL(l_c_ap_term.end_date_active, sysdate))) THEN
595: l_b_val_parm := FALSE;
596: fnd_message.set_name('IGS','IGS_FI_AP_TERM_INACTIVE');
597: fnd_message.set_token('TERM_NAME',l_c_ap_term.name);
598: fnd_file.put_line(fnd_file.log,
599: fnd_message.get);
600: END IF;

Line 597: fnd_message.set_token('TERM_NAME',l_c_ap_term.name);

593: IF NOT (TRUNC(sysdate) BETWEEN TRUNC(NVL(l_c_ap_term.start_date_active, sysdate)) AND
594: TRUNC(NVL(l_c_ap_term.end_date_active, sysdate))) THEN
595: l_b_val_parm := FALSE;
596: fnd_message.set_name('IGS','IGS_FI_AP_TERM_INACTIVE');
597: fnd_message.set_token('TERM_NAME',l_c_ap_term.name);
598: fnd_file.put_line(fnd_file.log,
599: fnd_message.get);
600: END IF;
601:

Line 599: fnd_message.get);

595: l_b_val_parm := FALSE;
596: fnd_message.set_name('IGS','IGS_FI_AP_TERM_INACTIVE');
597: fnd_message.set_token('TERM_NAME',l_c_ap_term.name);
598: fnd_file.put_line(fnd_file.log,
599: fnd_message.get);
600: END IF;
601:
602: -- If the create supplier parameter is not in Y/N, then log the
603: -- error message in the log file

Line 606: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

602: -- If the create supplier parameter is not in Y/N, then log the
603: -- error message in the log file
604: IF p_v_create_supplier NOT IN ('Y','N') THEN
605: l_b_val_parm := FALSE;
606: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
607: fnd_message.set_token('PARAMETER',g_v_lbl_create_suppl);
608: fnd_file.put_line(fnd_file.log,
609: fnd_message.get);
610: END IF;

Line 607: fnd_message.set_token('PARAMETER',g_v_lbl_create_suppl);

603: -- error message in the log file
604: IF p_v_create_supplier NOT IN ('Y','N') THEN
605: l_b_val_parm := FALSE;
606: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
607: fnd_message.set_token('PARAMETER',g_v_lbl_create_suppl);
608: fnd_file.put_line(fnd_file.log,
609: fnd_message.get);
610: END IF;
611:

Line 609: fnd_message.get);

605: l_b_val_parm := FALSE;
606: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
607: fnd_message.set_token('PARAMETER',g_v_lbl_create_suppl);
608: fnd_file.put_line(fnd_file.log,
609: fnd_message.get);
610: END IF;
611:
612: -- If the test run parameter is not in Y/N, then log the
613: -- error message in the log file

Line 616: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

612: -- If the test run parameter is not in Y/N, then log the
613: -- error message in the log file
614: IF p_v_test_run NOT IN ('Y','N') THEN
615: l_b_val_parm := FALSE;
616: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
617: fnd_message.set_token('PARAMETER',g_v_lbl_test_run);
618: fnd_file.put_line(fnd_file.log,
619: fnd_message.get);
620: END IF;

Line 617: fnd_message.set_token('PARAMETER',g_v_lbl_test_run);

613: -- error message in the log file
614: IF p_v_test_run NOT IN ('Y','N') THEN
615: l_b_val_parm := FALSE;
616: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
617: fnd_message.set_token('PARAMETER',g_v_lbl_test_run);
618: fnd_file.put_line(fnd_file.log,
619: fnd_message.get);
620: END IF;
621:

Line 619: fnd_message.get);

615: l_b_val_parm := FALSE;
616: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
617: fnd_message.set_token('PARAMETER',g_v_lbl_test_run);
618: fnd_file.put_line(fnd_file.log,
619: fnd_message.get);
620: END IF;
621:
622: -- call the procedure for getting the currency code
623: igs_fi_gen_gl.finp_get_cur(g_v_cur_code,

Line 631: fnd_message.set_name('IGS',l_v_message_name);

627: -- If the currency code is not null, then log the
628: -- error message in the log file
629: IF g_v_cur_code IS NULL THEN
630: l_b_val_parm := FALSE;
631: fnd_message.set_name('IGS',l_v_message_name);
632: fnd_file.put_line(fnd_file.log,
633: fnd_message.get);
634: END IF;
635:

Line 633: fnd_message.get);

629: IF g_v_cur_code IS NULL THEN
630: l_b_val_parm := FALSE;
631: fnd_message.set_name('IGS',l_v_message_name);
632: fnd_file.put_line(fnd_file.log,
633: fnd_message.get);
634: END IF;
635:
636: -- Get the value of the Supplier Number parameter
637: g_v_sup_num := fnd_profile.value('IGS_FI_SUPPLIER_NUMBER');

Line 651: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NUM_NOT_SET');

647: -- Automatic. If yes, then log error message in the log file.
648: IF g_v_sup_num IS NULL THEN
649: IF NVL(g_v_ven_num_code,g_v_automatic) <> g_v_automatic THEN
650: l_b_val_parm := FALSE;
651: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NUM_NOT_SET');
652: fnd_file.put_line(fnd_file.log,
653: fnd_message.get);
654: END IF;
655: END IF;

Line 653: fnd_message.get);

649: IF NVL(g_v_ven_num_code,g_v_automatic) <> g_v_automatic THEN
650: l_b_val_parm := FALSE;
651: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NUM_NOT_SET');
652: fnd_file.put_line(fnd_file.log,
653: fnd_message.get);
654: END IF;
655: END IF;
656:
657: -- Get the value of the Supplier Name profile.

Line 664: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NAME_NOT_SET');

660: -- If the profile value for the supplier name is not set up
661: -- then log the error message in the log file.
662: IF g_v_sup_name IS NULL THEN
663: l_b_val_parm := FALSE;
664: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NAME_NOT_SET');
665: fnd_file.put_line(fnd_file.log,
666: fnd_message.get);
667: END IF;
668:

Line 666: fnd_message.get);

662: IF g_v_sup_name IS NULL THEN
663: l_b_val_parm := FALSE;
664: fnd_message.set_name('IGS','IGS_FI_PROFL_SUP_NAME_NOT_SET');
665: fnd_file.put_line(fnd_file.log,
666: fnd_message.get);
667: END IF;
668:
669: -- Get the value of the profile 'Student Finance Pay Voucher Alone'
670: g_v_pay_rfnd_vchr := fnd_profile.value('IGS_FI_PAY_RFND_VOUCHER');

Line 676: fnd_message.set_name('IGS','IGS_FI_PROFL_PAY_RFND_NOT_SET');

672: -- If the value of the profile is not set up, then log error message
673: -- in the log file
674: IF g_v_pay_rfnd_vchr IS NULL THEN
675: l_b_val_parm := FALSE;
676: fnd_message.set_name('IGS','IGS_FI_PROFL_PAY_RFND_NOT_SET');
677: fnd_file.put_line(fnd_file.log,
678: fnd_message.get);
679: END IF;
680:

Line 678: fnd_message.get);

674: IF g_v_pay_rfnd_vchr IS NULL THEN
675: l_b_val_parm := FALSE;
676: fnd_message.set_name('IGS','IGS_FI_PROFL_PAY_RFND_NOT_SET');
677: fnd_file.put_line(fnd_file.log,
678: fnd_message.get);
679: END IF;
680:
681: -- If the Party Id and the Person Group both are passed as input to
682: -- the process, then log error message

Line 685: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');

681: -- If the Party Id and the Person Group both are passed as input to
682: -- the process, then log error message
683: IF p_n_party_id IS NOT NULL AND p_n_person_group_id IS NOT NULL THEN
684: l_b_val_parm := FALSE;
685: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
686: fnd_file.put_line(fnd_file.log,
687: fnd_message.get);
688: END IF;
689:

Line 687: fnd_message.get);

683: IF p_n_party_id IS NOT NULL AND p_n_person_group_id IS NOT NULL THEN
684: l_b_val_parm := FALSE;
685: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
686: fnd_file.put_line(fnd_file.log,
687: fnd_message.get);
688: END IF;
689:
690: -- If any of the validations has failed, then RETURN False
691: IF l_b_term_flag AND l_b_party_flag AND l_b_pers_grp_flag AND

Line 920: fnd_message.set_name('IGS','IGS_FI_SUPPLIER_INACTIVE');

916: IF c_po_active%NOTFOUND THEN
917: p_b_status := FALSE;
918: fnd_file.put_line(fnd_file.log,
919: g_v_lbl_status||' : '||g_v_lbl_todo);
920: fnd_message.set_name('IGS','IGS_FI_SUPPLIER_INACTIVE');
921: fnd_file.put_line(fnd_file.log,
922: fnd_message.get);
923: END IF;
924: CLOSE c_po_active;

Line 922: fnd_message.get);

918: fnd_file.put_line(fnd_file.log,
919: g_v_lbl_status||' : '||g_v_lbl_todo);
920: fnd_message.set_name('IGS','IGS_FI_SUPPLIER_INACTIVE');
921: fnd_file.put_line(fnd_file.log,
922: fnd_message.get);
923: END IF;
924: CLOSE c_po_active;
925:
926: IF NOT p_b_status THEN

Line 992: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_UPD');

988: g_v_lbl_status||' : '||g_v_lbl_todo);
989: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
990: END;
991: IF l_v_site_status <> 'S' THEN
992: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_UPD');
993: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
994: fnd_file.put_line(fnd_file.log, fnd_message.get);
995: p_b_status := FALSE;
996: RETURN;

Line 993: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);

989: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
990: END;
991: IF l_v_site_status <> 'S' THEN
992: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_UPD');
993: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
994: fnd_file.put_line(fnd_file.log, fnd_message.get);
995: p_b_status := FALSE;
996: RETURN;
997: END IF;

Line 994: fnd_file.put_line(fnd_file.log, fnd_message.get);

990: END;
991: IF l_v_site_status <> 'S' THEN
992: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_UPD');
993: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
994: fnd_file.put_line(fnd_file.log, fnd_message.get);
995: p_b_status := FALSE;
996: RETURN;
997: END IF;
998: ELSE

Line 1040: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');

1036: g_v_lbl_status||' : '||g_v_lbl_todo);
1037: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1038: END;
1039: IF l_v_site_status <> 'S' THEN
1040: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1041: fnd_message.set_name('PARTY_NUM',l_c_hz_party.party_number);
1042: fnd_file.put_line(fnd_file.log, fnd_message.get);
1043: p_b_status := FALSE;
1044: RETURN;

Line 1041: fnd_message.set_name('PARTY_NUM',l_c_hz_party.party_number);

1037: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1038: END;
1039: IF l_v_site_status <> 'S' THEN
1040: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1041: fnd_message.set_name('PARTY_NUM',l_c_hz_party.party_number);
1042: fnd_file.put_line(fnd_file.log, fnd_message.get);
1043: p_b_status := FALSE;
1044: RETURN;
1045: END IF;

Line 1042: fnd_file.put_line(fnd_file.log, fnd_message.get);

1038: END;
1039: IF l_v_site_status <> 'S' THEN
1040: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1041: fnd_message.set_name('PARTY_NUM',l_c_hz_party.party_number);
1042: fnd_file.put_line(fnd_file.log, fnd_message.get);
1043: p_b_status := FALSE;
1044: RETURN;
1045: END IF;
1046:

Line 1061: fnd_message.set_name('IGS','IGS_FI_CREATE_SUPL_NO');

1057: -- create supplier parameter is N, then exit
1058: IF g_v_create_supplier = 'N' THEN
1059: fnd_file.put_line(fnd_file.log,
1060: g_v_lbl_status||' : '||g_v_lbl_todo);
1061: fnd_message.set_name('IGS','IGS_FI_CREATE_SUPL_NO');
1062: fnd_message.set_token('PAYEE_NUM',l_c_hz_party.party_number);
1063: fnd_file.put_line(fnd_file.log, fnd_message.get);
1064: p_b_status := FALSE;
1065: RETURN;

Line 1062: fnd_message.set_token('PAYEE_NUM',l_c_hz_party.party_number);

1058: IF g_v_create_supplier = 'N' THEN
1059: fnd_file.put_line(fnd_file.log,
1060: g_v_lbl_status||' : '||g_v_lbl_todo);
1061: fnd_message.set_name('IGS','IGS_FI_CREATE_SUPL_NO');
1062: fnd_message.set_token('PAYEE_NUM',l_c_hz_party.party_number);
1063: fnd_file.put_line(fnd_file.log, fnd_message.get);
1064: p_b_status := FALSE;
1065: RETURN;
1066: END IF;

Line 1063: fnd_file.put_line(fnd_file.log, fnd_message.get);

1059: fnd_file.put_line(fnd_file.log,
1060: g_v_lbl_status||' : '||g_v_lbl_todo);
1061: fnd_message.set_name('IGS','IGS_FI_CREATE_SUPL_NO');
1062: fnd_message.set_token('PAYEE_NUM',l_c_hz_party.party_number);
1063: fnd_file.put_line(fnd_file.log, fnd_message.get);
1064: p_b_status := FALSE;
1065: RETURN;
1066: END IF;
1067:

Line 1105: fnd_message.set_name('IGS','IGS_FI_SUP_NUM_NOT_DERIVED');

1101: -- If the vendor number cannot be derived, then exit.
1102: IF NOT l_b_status THEN
1103: fnd_file.put_line(fnd_file.log,
1104: g_v_lbl_status||' : '||g_v_lbl_todo);
1105: fnd_message.set_name('IGS','IGS_FI_SUP_NUM_NOT_DERIVED');
1106: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1107: fnd_file.put_line(fnd_file.log,
1108: fnd_message.get);
1109: p_b_status := FALSE;

Line 1106: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);

1102: IF NOT l_b_status THEN
1103: fnd_file.put_line(fnd_file.log,
1104: g_v_lbl_status||' : '||g_v_lbl_todo);
1105: fnd_message.set_name('IGS','IGS_FI_SUP_NUM_NOT_DERIVED');
1106: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1107: fnd_file.put_line(fnd_file.log,
1108: fnd_message.get);
1109: p_b_status := FALSE;
1110: RETURN;

Line 1108: fnd_message.get);

1104: g_v_lbl_status||' : '||g_v_lbl_todo);
1105: fnd_message.set_name('IGS','IGS_FI_SUP_NUM_NOT_DERIVED');
1106: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1107: fnd_file.put_line(fnd_file.log,
1108: fnd_message.get);
1109: p_b_status := FALSE;
1110: RETURN;
1111: END IF;
1112:

Line 1138: fnd_message.set_name('IGS','IGS_FI_VENDOR_NOT_CREATED');

1134: g_v_lbl_status||' : '||g_v_lbl_todo);
1135: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1136: END;
1137: IF l_v_vendor_status <> 'S' THEN
1138: fnd_message.set_name('IGS','IGS_FI_VENDOR_NOT_CREATED');
1139: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1140: fnd_file.put_line(fnd_file.log, fnd_message.get);
1141: p_b_status := FALSE;
1142: RETURN;

Line 1139: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);

1135: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1136: END;
1137: IF l_v_vendor_status <> 'S' THEN
1138: fnd_message.set_name('IGS','IGS_FI_VENDOR_NOT_CREATED');
1139: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1140: fnd_file.put_line(fnd_file.log, fnd_message.get);
1141: p_b_status := FALSE;
1142: RETURN;
1143: END IF;

Line 1140: fnd_file.put_line(fnd_file.log, fnd_message.get);

1136: END;
1137: IF l_v_vendor_status <> 'S' THEN
1138: fnd_message.set_name('IGS','IGS_FI_VENDOR_NOT_CREATED');
1139: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1140: fnd_file.put_line(fnd_file.log, fnd_message.get);
1141: p_b_status := FALSE;
1142: RETURN;
1143: END IF;
1144:

Line 1183: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');

1179: g_v_lbl_status||' : '||g_v_lbl_todo);
1180: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1181: END;
1182: IF l_v_site_status <> 'S' THEN
1183: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1184: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1185: fnd_file.put_line(fnd_file.log, fnd_message.get);
1186: p_b_status := FALSE;
1187: RETURN;

Line 1184: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);

1180: fnd_file.put_line(fnd_file.log, l_v_msg||sqlerrm);
1181: END;
1182: IF l_v_site_status <> 'S' THEN
1183: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1184: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1185: fnd_file.put_line(fnd_file.log, fnd_message.get);
1186: p_b_status := FALSE;
1187: RETURN;
1188: END IF;

Line 1185: fnd_file.put_line(fnd_file.log, fnd_message.get);

1181: END;
1182: IF l_v_site_status <> 'S' THEN
1183: fnd_message.set_name('IGS','IGS_FI_VEN_SITE_NOT_CREATED');
1184: fnd_message.set_token('PARTY_NUM',l_c_hz_party.party_number);
1185: fnd_file.put_line(fnd_file.log, fnd_message.get);
1186: p_b_status := FALSE;
1187: RETURN;
1188: END IF;
1189:

Line 1614: fnd_message.set_name('IGS',

1610: -- If the test run parameter = 'Y', then rollback all the transactions
1611: -- and exit.
1612: IF (p_v_test_run = 'Y' AND g_b_data_found) THEN
1613: ROLLBACK TO SP_TRANSFER;
1614: fnd_message.set_name('IGS',
1615: 'IGS_FI_PRC_TEST_RUN');
1616: fnd_file.put_line(fnd_file.log,
1617: fnd_message.get);
1618: ELSE

Line 1617: fnd_message.get);

1613: ROLLBACK TO SP_TRANSFER;
1614: fnd_message.set_name('IGS',
1615: 'IGS_FI_PRC_TEST_RUN');
1616: fnd_file.put_line(fnd_file.log,
1617: fnd_message.get);
1618: ELSE
1619: COMMIT;
1620: END IF;
1621:

Line 1624: fnd_message.set_name('IGS',

1620: END IF;
1621:
1622: -- If there are no records found then log the message No Data Found
1623: IF NOT g_b_data_found THEN
1624: fnd_message.set_name('IGS',
1625: 'IGS_GE_NO_DATA_FOUND');
1626: fnd_file.put_line(fnd_file.log,
1627: fnd_message.get);
1628: END IF;

Line 1627: fnd_message.get);

1623: IF NOT g_b_data_found THEN
1624: fnd_message.set_name('IGS',
1625: 'IGS_GE_NO_DATA_FOUND');
1626: fnd_file.put_line(fnd_file.log,
1627: fnd_message.get);
1628: END IF;
1629:
1630: EXCEPTION
1631: WHEN e_resource_busy THEN

Line 1633: fnd_message.set_name('IGS',

1629:
1630: EXCEPTION
1631: WHEN e_resource_busy THEN
1632: retcode := 2;
1633: fnd_message.set_name('IGS',
1634: 'IGS_FI_RFND_REC_LOCK');
1635: fnd_file.put_line(fnd_file.log, fnd_message.get);
1636: WHEN OTHERS THEN
1637: retcode := 2;

Line 1635: fnd_file.put_line(fnd_file.log, fnd_message.get);

1631: WHEN e_resource_busy THEN
1632: retcode := 2;
1633: fnd_message.set_name('IGS',
1634: 'IGS_FI_RFND_REC_LOCK');
1635: fnd_file.put_line(fnd_file.log, fnd_message.get);
1636: WHEN OTHERS THEN
1637: retcode := 2;
1638: ROLLBACK TO SP_TRANSFER;
1639: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 1639: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1635: fnd_file.put_line(fnd_file.log, fnd_message.get);
1636: WHEN OTHERS THEN
1637: retcode := 2;
1638: ROLLBACK TO SP_TRANSFER;
1639: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1640: fnd_file.put_line(fnd_file.log,
1641: fnd_message.get||' - '||sqlerrm);
1642: END transfer;
1643:

Line 1641: fnd_message.get||' - '||sqlerrm);

1637: retcode := 2;
1638: ROLLBACK TO SP_TRANSFER;
1639: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1640: fnd_file.put_line(fnd_file.log,
1641: fnd_message.get||' - '||sqlerrm);
1642: END transfer;
1643:
1644: END igs_fi_prc_apint;