DBA Data[Home] [Help]

APPS.IGS_FI_PRC_IMPCLC_ANC_CHGS dependencies on FND_MESSAGE

Line 379: vvutukur 06-Jan-2003 Bug#2737714.Used fnd_message.set_encoded to encode the message after charges api call,if charges api returns an error.

375: is updated with the concatenated error message texts.
376: shtatiko 29-APR-2003 Enh# 2831569, Added check for Manage Accounts System Option. If its value is NULL then
377: this process cannot be run.
378: vvutukur 23-Jan-20033 Bug#2750566.Modified the code to update the error_msg column in Interface record with appropriate message text.
379: vvutukur 06-Jan-2003 Bug#2737714.Used fnd_message.set_encoded to encode the message after charges api call,if charges api returns an error.
380: Also shown the no. of successfully imported records instead of showing no. of records processsed from interface table.
381: pathipat 20-NOV-2002 Enh#2584986 - GL Interface build
382: 1. Removed override account columns from calls to insert_row of IGS_FI_IMP_CHGS and
383: IGS_FI_IMPCHGS_LINES and update_row of IGS_FI_ANC_INT.

Line 544: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_LOG_PARM');

540:
541: l_rec_installed := IGS_FI_GEN_005.finp_get_receivables_inst;
542: -- Logging the Paramteres in the Log File
543:
544: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_LOG_PARM');
545: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
546:
547: IF p_person_id IS NOT NULL THEN
548: l_person_number := Get_Person_Number(p_person_id);

Line 545: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);

541: l_rec_installed := IGS_FI_GEN_005.finp_get_receivables_inst;
542: -- Logging the Paramteres in the Log File
543:
544: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_LOG_PARM');
545: FND_FILE.Put_Line(FND_FILE.Log,FND_MESSAGE.Get);
546:
547: IF p_person_id IS NOT NULL THEN
548: l_person_number := Get_Person_Number(p_person_id);
549: END IF;

Line 552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');

548: l_person_number := Get_Person_Number(p_person_id);
549: END IF;
550:
551: -- Removed usage of lookup_desc, instead used generic function to get the lookup description
552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
553: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
554: p_v_lookup_code => 'PERSON')
555: );
556: fnd_message.set_token('PARM_CODE',l_person_number);

Line 553: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

549: END IF;
550:
551: -- Removed usage of lookup_desc, instead used generic function to get the lookup description
552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
553: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
554: p_v_lookup_code => 'PERSON')
555: );
556: fnd_message.set_token('PARM_CODE',l_person_number);
557: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 556: fnd_message.set_token('PARM_CODE',l_person_number);

552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
553: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
554: p_v_lookup_code => 'PERSON')
555: );
556: fnd_message.set_token('PARM_CODE',l_person_number);
557: fnd_file.put_line(fnd_file.log,fnd_message.get);
558:
559: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

553: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
554: p_v_lookup_code => 'PERSON')
555: );
556: fnd_message.set_token('PARM_CODE',l_person_number);
557: fnd_file.put_line(fnd_file.log,fnd_message.get);
558:
559: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
561: p_v_lookup_code => 'PERSON_ID_TYPE')

Line 559: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');

555: );
556: fnd_message.set_token('PARM_CODE',l_person_number);
557: fnd_file.put_line(fnd_file.log,fnd_message.get);
558:
559: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
561: p_v_lookup_code => 'PERSON_ID_TYPE')
562: );
563: fnd_message.set_token('PARM_CODE',p_person_id_type);

Line 560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

556: fnd_message.set_token('PARM_CODE',l_person_number);
557: fnd_file.put_line(fnd_file.log,fnd_message.get);
558:
559: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
561: p_v_lookup_code => 'PERSON_ID_TYPE')
562: );
563: fnd_message.set_token('PARM_CODE',p_person_id_type);
564: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 563: fnd_message.set_token('PARM_CODE',p_person_id_type);

559: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
561: p_v_lookup_code => 'PERSON_ID_TYPE')
562: );
563: fnd_message.set_token('PARM_CODE',p_person_id_type);
564: fnd_file.put_line(fnd_file.log,fnd_message.get);
565:
566: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
561: p_v_lookup_code => 'PERSON_ID_TYPE')
562: );
563: fnd_message.set_token('PARM_CODE',p_person_id_type);
564: fnd_file.put_line(fnd_file.log,fnd_message.get);
565:
566: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
568: p_v_lookup_code => 'ALTERNATE_PERSON_ID')

Line 566: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');

562: );
563: fnd_message.set_token('PARM_CODE',p_person_id_type);
564: fnd_file.put_line(fnd_file.log,fnd_message.get);
565:
566: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
568: p_v_lookup_code => 'ALTERNATE_PERSON_ID')
569: );
570: fnd_message.set_token('PARM_CODE',p_api_person_id);

Line 567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

563: fnd_message.set_token('PARM_CODE',p_person_id_type);
564: fnd_file.put_line(fnd_file.log,fnd_message.get);
565:
566: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
568: p_v_lookup_code => 'ALTERNATE_PERSON_ID')
569: );
570: fnd_message.set_token('PARM_CODE',p_api_person_id);
571: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 570: fnd_message.set_token('PARM_CODE',p_api_person_id);

566: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
568: p_v_lookup_code => 'ALTERNATE_PERSON_ID')
569: );
570: fnd_message.set_token('PARM_CODE',p_api_person_id);
571: fnd_file.put_line(fnd_file.log,fnd_message.get);
572:
573: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
568: p_v_lookup_code => 'ALTERNATE_PERSON_ID')
569: );
570: fnd_message.set_token('PARM_CODE',p_api_person_id);
571: fnd_file.put_line(fnd_file.log,fnd_message.get);
572:
573: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
575: p_v_lookup_code => 'FEE_TYPE')

Line 573: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');

569: );
570: fnd_message.set_token('PARM_CODE',p_api_person_id);
571: fnd_file.put_line(fnd_file.log,fnd_message.get);
572:
573: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
575: p_v_lookup_code => 'FEE_TYPE')
576: );
577: fnd_message.set_token('PARM_CODE',p_fee_type);

Line 574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

570: fnd_message.set_token('PARM_CODE',p_api_person_id);
571: fnd_file.put_line(fnd_file.log,fnd_message.get);
572:
573: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
575: p_v_lookup_code => 'FEE_TYPE')
576: );
577: fnd_message.set_token('PARM_CODE',p_fee_type);
578: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 577: fnd_message.set_token('PARM_CODE',p_fee_type);

573: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
575: p_v_lookup_code => 'FEE_TYPE')
576: );
577: fnd_message.set_token('PARM_CODE',p_fee_type);
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579:
580: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

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

574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
575: p_v_lookup_code => 'FEE_TYPE')
576: );
577: fnd_message.set_token('PARM_CODE',p_fee_type);
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579:
580: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
582: p_v_lookup_code => 'FEE_CAL_TYPE')

Line 580: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');

576: );
577: fnd_message.set_token('PARM_CODE',p_fee_type);
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579:
580: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
582: p_v_lookup_code => 'FEE_CAL_TYPE')
583: );
584: fnd_message.set_token('PARM_CODE',p_fee_cal_type);

Line 581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',

577: fnd_message.set_token('PARM_CODE',p_fee_type);
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579:
580: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
582: p_v_lookup_code => 'FEE_CAL_TYPE')
583: );
584: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
585: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 584: fnd_message.set_token('PARM_CODE',p_fee_cal_type);

580: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
582: p_v_lookup_code => 'FEE_CAL_TYPE')
583: );
584: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
585: fnd_file.put_line(fnd_file.log,fnd_message.get);
586:
587: -- Get the value of "Manage Accounts" System Option value.
588: -- If this value is NULL then this process should error out.

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

581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
582: p_v_lookup_code => 'FEE_CAL_TYPE')
583: );
584: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
585: fnd_file.put_line(fnd_file.log,fnd_message.get);
586:
587: -- Get the value of "Manage Accounts" System Option value.
588: -- If this value is NULL then this process should error out.
589: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,

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

588: -- If this value is NULL then this process should error out.
589: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
590: p_v_message_name => l_v_message_name );
591: IF l_v_manage_accounts IS NULL THEN
592: fnd_message.set_name ( 'IGS', l_v_message_name );
593: fnd_file.put_line(fnd_file.log,fnd_message.get);
594: RAISE l_exception;
595: END IF;
596:

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

589: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
590: p_v_message_name => l_v_message_name );
591: IF l_v_manage_accounts IS NULL THEN
592: fnd_message.set_name ( 'IGS', l_v_message_name );
593: fnd_file.put_line(fnd_file.log,fnd_message.get);
594: RAISE l_exception;
595: END IF;
596:
597: -- If the Person Id is not null then

Line 604: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_INFO_NOT_NULL');

600: -- Person Id Type and Alternate Person Id cannot be specified
601: -- If the Person Id Type and the Alternate Person Id are input to the process
602: -- then raise an error
603: IF ((p_person_id_type IS NOT NULL) OR (p_api_person_id IS NOT NULL)) THEN
604: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_INFO_NOT_NULL');
605: FND_MESSAGE.Set_Token('PERSON_ID', l_person_number);
606: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
607: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
608: l_message := FND_MESSAGE.Get;

Line 605: FND_MESSAGE.Set_Token('PERSON_ID', l_person_number);

601: -- If the Person Id Type and the Alternate Person Id are input to the process
602: -- then raise an error
603: IF ((p_person_id_type IS NOT NULL) OR (p_api_person_id IS NOT NULL)) THEN
604: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_INFO_NOT_NULL');
605: FND_MESSAGE.Set_Token('PERSON_ID', l_person_number);
606: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
607: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
608: l_message := FND_MESSAGE.Get;
609: FND_FILE.Put_Line(FND_FILE.Log, l_message);

Line 606: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);

602: -- then raise an error
603: IF ((p_person_id_type IS NOT NULL) OR (p_api_person_id IS NOT NULL)) THEN
604: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_INFO_NOT_NULL');
605: FND_MESSAGE.Set_Token('PERSON_ID', l_person_number);
606: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
607: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
608: l_message := FND_MESSAGE.Get;
609: FND_FILE.Put_Line(FND_FILE.Log, l_message);
610: APP_EXCEPTION.Raise_Exception;

Line 607: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);

603: IF ((p_person_id_type IS NOT NULL) OR (p_api_person_id IS NOT NULL)) THEN
604: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_INFO_NOT_NULL');
605: FND_MESSAGE.Set_Token('PERSON_ID', l_person_number);
606: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
607: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
608: l_message := FND_MESSAGE.Get;
609: FND_FILE.Put_Line(FND_FILE.Log, l_message);
610: APP_EXCEPTION.Raise_Exception;
611: END IF;

Line 608: l_message := FND_MESSAGE.Get;

604: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_INFO_NOT_NULL');
605: FND_MESSAGE.Set_Token('PERSON_ID', l_person_number);
606: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
607: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
608: l_message := FND_MESSAGE.Get;
609: FND_FILE.Put_Line(FND_FILE.Log, l_message);
610: APP_EXCEPTION.Raise_Exception;
611: END IF;
612: ELSE

Line 618: FND_MESSAGE.Set_Name('IGS','IGS_FI_API_PERS_ID_NULL');

614: -- If the Person Id is null
615: -- And the Person Id Type is NOT NULL and Api Person Id IS NULL
616: -- then log an error message and exit
617: IF ((p_person_id_type IS NOT NULL) AND (p_api_person_id IS NULL)) THEN
618: FND_MESSAGE.Set_Name('IGS','IGS_FI_API_PERS_ID_NULL');
619: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
620: l_message := FND_MESSAGE.Get;
621: FND_FILE.Put_Line(FND_FILE.Log, l_message);
622: APP_EXCEPTION.Raise_Exception;

Line 619: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);

615: -- And the Person Id Type is NOT NULL and Api Person Id IS NULL
616: -- then log an error message and exit
617: IF ((p_person_id_type IS NOT NULL) AND (p_api_person_id IS NULL)) THEN
618: FND_MESSAGE.Set_Name('IGS','IGS_FI_API_PERS_ID_NULL');
619: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
620: l_message := FND_MESSAGE.Get;
621: FND_FILE.Put_Line(FND_FILE.Log, l_message);
622: APP_EXCEPTION.Raise_Exception;
623:

Line 620: l_message := FND_MESSAGE.Get;

616: -- then log an error message and exit
617: IF ((p_person_id_type IS NOT NULL) AND (p_api_person_id IS NULL)) THEN
618: FND_MESSAGE.Set_Name('IGS','IGS_FI_API_PERS_ID_NULL');
619: FND_MESSAGE.Set_Token('PERS_ID_TYPE', p_person_id_type);
620: l_message := FND_MESSAGE.Get;
621: FND_FILE.Put_Line(FND_FILE.Log, l_message);
622: APP_EXCEPTION.Raise_Exception;
623:
624: -- Else if the Person Id Type is NULL and the API Person Id is NOT NULL then

Line 627: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_ID_TYPE_NULL');

623:
624: -- Else if the Person Id Type is NULL and the API Person Id is NOT NULL then
625: -- Log this as an error
626: ELSIF ((p_person_id_type IS NULL) AND (p_api_person_id IS NOT NULL)) THEN
627: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_ID_TYPE_NULL');
628: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
629: l_message := FND_MESSAGE.Get;
630: FND_FILE.Put_Line(FND_FILE.Log, l_message);
631: APP_EXCEPTION.Raise_Exception;

Line 628: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);

624: -- Else if the Person Id Type is NULL and the API Person Id is NOT NULL then
625: -- Log this as an error
626: ELSIF ((p_person_id_type IS NULL) AND (p_api_person_id IS NOT NULL)) THEN
627: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_ID_TYPE_NULL');
628: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
629: l_message := FND_MESSAGE.Get;
630: FND_FILE.Put_Line(FND_FILE.Log, l_message);
631: APP_EXCEPTION.Raise_Exception;
632: END IF;

Line 629: l_message := FND_MESSAGE.Get;

625: -- Log this as an error
626: ELSIF ((p_person_id_type IS NULL) AND (p_api_person_id IS NOT NULL)) THEN
627: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_PERS_ID_TYPE_NULL');
628: FND_MESSAGE.Set_Token('API_PERS_ID', p_api_person_id);
629: l_message := FND_MESSAGE.Get;
630: FND_FILE.Put_Line(FND_FILE.Log, l_message);
631: APP_EXCEPTION.Raise_Exception;
632: END IF;
633: END IF;

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

637: p_v_curr_desc => l_v_curr_desc,
638: p_v_message_name => l_v_message_name
639: );
640: IF l_v_message_name IS NOT NULL THEN
641: fnd_message.set_name('IGS',l_v_message_name);
642: fnd_file.put_line(fnd_file.Log,fnd_message.get);
643: app_exception.raise_exception;
644: ELSE
645: l_v_local_currency := l_n_curr_cd;

Line 642: fnd_file.put_line(fnd_file.Log,fnd_message.get);

638: p_v_message_name => l_v_message_name
639: );
640: IF l_v_message_name IS NOT NULL THEN
641: fnd_message.set_name('IGS',l_v_message_name);
642: fnd_file.put_line(fnd_file.Log,fnd_message.get);
643: app_exception.raise_exception;
644: ELSE
645: l_v_local_currency := l_n_curr_cd;
646: END IF;

Line 680: FND_MESSAGE.Set_name('IGS','IGS_FI_ANC_REC_DTLS');

676: l_person_number := Get_Person_Number(l_person_id);
677:
678: -- Log the record Details
679: fnd_file.new_line(fnd_file.log);
680: FND_MESSAGE.Set_name('IGS','IGS_FI_ANC_REC_DTLS');
681: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
682:
683: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC1');
684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);

Line 681: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

677:
678: -- Log the record Details
679: fnd_file.new_line(fnd_file.log);
680: FND_MESSAGE.Set_name('IGS','IGS_FI_ANC_REC_DTLS');
681: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
682:
683: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC1');
684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);
685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

Line 683: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC1');

679: fnd_file.new_line(fnd_file.log);
680: FND_MESSAGE.Set_name('IGS','IGS_FI_ANC_REC_DTLS');
681: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
682:
683: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC1');
684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);
685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
686:
687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');

Line 684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);

680: FND_MESSAGE.Set_name('IGS','IGS_FI_ANC_REC_DTLS');
681: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
682:
683: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC1');
684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);
685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
686:
687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');
688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);

Line 685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

681: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
682:
683: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC1');
684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);
685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
686:
687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');
688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);
689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

Line 687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');

683: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC1');
684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);
685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
686:
687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');
688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);
689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
690:
691: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC3');

Line 688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);

684: FND_MESSAGE.Set_Token('TOKEN',l_person_number);
685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
686:
687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');
688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);
689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
690:
691: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC3');
692: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_type);

Line 689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

685: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
686:
687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');
688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);
689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
690:
691: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC3');
692: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_type);
693: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

Line 691: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC3');

687: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC2');
688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);
689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
690:
691: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC3');
692: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_type);
693: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
694:
695: -- If the validation flag is set to N then

Line 692: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_type);

688: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_cal_type);
689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
690:
691: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC3');
692: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_type);
693: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
694:
695: -- If the validation flag is set to N then
696: IF NVL(ancrec.validation_flag,'N') = 'N' THEN

Line 693: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

689: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
690:
691: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC3');
692: FND_MESSAGE.Set_Token('TOKEN', ancrec.fee_type);
693: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
694:
695: -- If the validation flag is set to N then
696: IF NVL(ancrec.validation_flag,'N') = 'N' THEN
697:

Line 707: fnd_message.set_name('IGS',l_error_msg);

703: p_person_id_type => ancrec.person_id_type,
704: p_api_person_id => ancrec.api_person_id,
705: p_err_msg_name => l_error_msg);
706: IF NOT l_validate THEN
707: fnd_message.set_name('IGS',l_error_msg);
708: l_msg := fnd_message.get;
709: fnd_file.put_line(fnd_file.log,l_msg);
710: ancrec.error_msg := l_msg;
711: ancrec.status := g_error;

Line 708: l_msg := fnd_message.get;

704: p_api_person_id => ancrec.api_person_id,
705: p_err_msg_name => l_error_msg);
706: IF NOT l_validate THEN
707: fnd_message.set_name('IGS',l_error_msg);
708: l_msg := fnd_message.get;
709: fnd_file.put_line(fnd_file.log,l_msg);
710: ancrec.error_msg := l_msg;
711: ancrec.status := g_error;
712: END IF;

Line 744: fnd_message.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');

740:
741: IF NOT l_dff_validate THEN
742: l_validate := FALSE;
743: ancrec.status := g_error;
744: fnd_message.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');
745: l_msg := fnd_message.get;
746: fnd_file.put_line(fnd_file.log,l_msg);
747: ancrec.error_msg := ancrec.error_msg||'.'||l_msg;
748: END IF;

Line 745: l_msg := fnd_message.get;

741: IF NOT l_dff_validate THEN
742: l_validate := FALSE;
743: ancrec.status := g_error;
744: fnd_message.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');
745: l_msg := fnd_message.get;
746: fnd_file.put_line(fnd_file.log,l_msg);
747: ancrec.error_msg := ancrec.error_msg||'.'||l_msg;
748: END IF;
749: END IF;

Line 780: fnd_message.set_name('IGS','IGS_FI_ANCRATE_NOT_FOUND');

776: -- The record should be updated to error with the error message
777: -- and the concurrent manager's log file should be updated
778: l_validate := FALSE;
779: ancrec.status := g_error;
780: fnd_message.set_name('IGS','IGS_FI_ANCRATE_NOT_FOUND');
781: l_msg := fnd_message.get;
782: fnd_file.put_line(fnd_file.log,l_msg);
783: ancrec.error_msg := ancrec.error_msg||'.'||l_msg;
784: END IF;

Line 781: l_msg := fnd_message.get;

777: -- and the concurrent manager's log file should be updated
778: l_validate := FALSE;
779: ancrec.status := g_error;
780: fnd_message.set_name('IGS','IGS_FI_ANCRATE_NOT_FOUND');
781: l_msg := fnd_message.get;
782: fnd_file.put_line(fnd_file.log,l_msg);
783: ancrec.error_msg := ancrec.error_msg||'.'||l_msg;
784: END IF;
785:

Line 825: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC4');

821:
822: l_rowid := NULL;
823: l_impchgs_lines_id := NULL;
824:
825: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC4');
826: FND_MESSAGE.Set_Token('TOKEN',to_char(l_ancillary_chg_rate));
827: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
828:
829: -- Call the TBH for creating a record in the Import Charges Lines table

Line 826: FND_MESSAGE.Set_Token('TOKEN',to_char(l_ancillary_chg_rate));

822: l_rowid := NULL;
823: l_impchgs_lines_id := NULL;
824:
825: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC4');
826: FND_MESSAGE.Set_Token('TOKEN',to_char(l_ancillary_chg_rate));
827: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
828:
829: -- Call the TBH for creating a record in the Import Charges Lines table
830:

Line 827: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

823: l_impchgs_lines_id := NULL;
824:
825: FND_MESSAGE.Set_Name('IGS','IGS_FI_ANC_CHG_REC4');
826: FND_MESSAGE.Set_Token('TOKEN',to_char(l_ancillary_chg_rate));
827: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
828:
829: -- Call the TBH for creating a record in the Import Charges Lines table
830:
831: -- Passed l_v_local_currency derived to the currency_cd field (part of enh bug 2584986)

Line 887: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_ANC_CHG_REC4');

883: -- The records need to be created in the Import Charges Lines table
884: l_rowid := NULL;
885: l_impchgs_lines_id := NULL;
886:
887: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_ANC_CHG_REC4');
888: FND_MESSAGE.Set_Token('TOKEN', to_char(l_ancillary_chg_rate));
889: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
890:
891:

Line 888: FND_MESSAGE.Set_Token('TOKEN', to_char(l_ancillary_chg_rate));

884: l_rowid := NULL;
885: l_impchgs_lines_id := NULL;
886:
887: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_ANC_CHG_REC4');
888: FND_MESSAGE.Set_Token('TOKEN', to_char(l_ancillary_chg_rate));
889: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
890:
891:
892: -- Call the TBH for creating a record in the Import Charges Lines table

Line 889: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);

885: l_impchgs_lines_id := NULL;
886:
887: FND_MESSAGE.Set_Name('IGS', 'IGS_FI_ANC_CHG_REC4');
888: FND_MESSAGE.Set_Token('TOKEN', to_char(l_ancillary_chg_rate));
889: FND_FILE.Put_Line(FND_FILE.Log, FND_MESSAGE.Get);
890:
891:
892: -- Call the TBH for creating a record in the Import Charges Lines table
893:

Line 1049: fnd_message.set_encoded(l_msg_data);

1045: -- Error and this must be logged.
1046: IF l_return_status <> 'S' THEN
1047: l_exception_flag := 'Y';
1048: IF l_msg_count = 1 THEN
1049: fnd_message.set_encoded(l_msg_data);
1050: ancrec.error_msg := fnd_message.get;
1051: ELSE
1052: FOR l_var IN 1..l_msg_count LOOP
1053: fnd_message.parse_encoded(fnd_msg_pub.get, l_appl_name, l_msg_name);

Line 1050: ancrec.error_msg := fnd_message.get;

1046: IF l_return_status <> 'S' THEN
1047: l_exception_flag := 'Y';
1048: IF l_msg_count = 1 THEN
1049: fnd_message.set_encoded(l_msg_data);
1050: ancrec.error_msg := fnd_message.get;
1051: ELSE
1052: FOR l_var IN 1..l_msg_count LOOP
1053: fnd_message.parse_encoded(fnd_msg_pub.get, l_appl_name, l_msg_name);
1054: fnd_message.set_name(l_appl_name, l_msg_name);

Line 1053: fnd_message.parse_encoded(fnd_msg_pub.get, l_appl_name, l_msg_name);

1049: fnd_message.set_encoded(l_msg_data);
1050: ancrec.error_msg := fnd_message.get;
1051: ELSE
1052: FOR l_var IN 1..l_msg_count LOOP
1053: fnd_message.parse_encoded(fnd_msg_pub.get, l_appl_name, l_msg_name);
1054: fnd_message.set_name(l_appl_name, l_msg_name);
1055: ancrec.error_msg := ancrec.error_msg||'.'||fnd_message.get;
1056: END LOOP;
1057: END IF;

Line 1054: fnd_message.set_name(l_appl_name, l_msg_name);

1050: ancrec.error_msg := fnd_message.get;
1051: ELSE
1052: FOR l_var IN 1..l_msg_count LOOP
1053: fnd_message.parse_encoded(fnd_msg_pub.get, l_appl_name, l_msg_name);
1054: fnd_message.set_name(l_appl_name, l_msg_name);
1055: ancrec.error_msg := ancrec.error_msg||'.'||fnd_message.get;
1056: END LOOP;
1057: END IF;
1058: END IF;

Line 1055: ancrec.error_msg := ancrec.error_msg||'.'||fnd_message.get;

1051: ELSE
1052: FOR l_var IN 1..l_msg_count LOOP
1053: fnd_message.parse_encoded(fnd_msg_pub.get, l_appl_name, l_msg_name);
1054: fnd_message.set_name(l_appl_name, l_msg_name);
1055: ancrec.error_msg := ancrec.error_msg||'.'||fnd_message.get;
1056: END LOOP;
1057: END IF;
1058: END IF;
1059:

Line 1075: l_msg := fnd_message.get;

1071: IF l_exception_flag = 'Y' THEN
1072: l_exception_flag := 'N';
1073: ancrec.status := g_error;
1074: IF ancrec.error_msg IS NULL THEN
1075: l_msg := fnd_message.get;
1076: IF l_msg IS NULL THEN
1077: fnd_message.set_name('IGS','IGS_FI_RECORD_IN_ERROR');
1078: ancrec.error_msg := fnd_message.get;
1079: ELSE

Line 1077: fnd_message.set_name('IGS','IGS_FI_RECORD_IN_ERROR');

1073: ancrec.status := g_error;
1074: IF ancrec.error_msg IS NULL THEN
1075: l_msg := fnd_message.get;
1076: IF l_msg IS NULL THEN
1077: fnd_message.set_name('IGS','IGS_FI_RECORD_IN_ERROR');
1078: ancrec.error_msg := fnd_message.get;
1079: ELSE
1080: ancrec.error_msg := l_msg;
1081: END IF;

Line 1078: ancrec.error_msg := fnd_message.get;

1074: IF ancrec.error_msg IS NULL THEN
1075: l_msg := fnd_message.get;
1076: IF l_msg IS NULL THEN
1077: fnd_message.set_name('IGS','IGS_FI_RECORD_IN_ERROR');
1078: ancrec.error_msg := fnd_message.get;
1079: ELSE
1080: ancrec.error_msg := l_msg;
1081: END IF;
1082: l_msg := NULL;

Line 1091: fnd_message.set_name('IGS','IGS_FI_ANC_REC_SUCCESS');

1087:
1088: -- If the Ancillary Record Status is TODO then no error has occured
1089: -- and should be updated to SUCCESS
1090: IF ancrec.status <> g_error THEN
1091: fnd_message.set_name('IGS','IGS_FI_ANC_REC_SUCCESS');
1092: fnd_file.put_line(fnd_file.log,fnd_message.get);
1093: ancrec.status := g_success;
1094: ancrec.error_msg:= null;
1095: l_rec_cntr := NVL(l_rec_cntr,0) + 1;

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

1088: -- If the Ancillary Record Status is TODO then no error has occured
1089: -- and should be updated to SUCCESS
1090: IF ancrec.status <> g_error THEN
1091: fnd_message.set_name('IGS','IGS_FI_ANC_REC_SUCCESS');
1092: fnd_file.put_line(fnd_file.log,fnd_message.get);
1093: ancrec.status := g_success;
1094: ancrec.error_msg:= null;
1095: l_rec_cntr := NVL(l_rec_cntr,0) + 1;
1096: ELSE

Line 1097: fnd_message.set_name('IGS', 'IGS_FI_ANC_REC_IN_ERROR');

1093: ancrec.status := g_success;
1094: ancrec.error_msg:= null;
1095: l_rec_cntr := NVL(l_rec_cntr,0) + 1;
1096: ELSE
1097: fnd_message.set_name('IGS', 'IGS_FI_ANC_REC_IN_ERROR');
1098: fnd_file.put_line(fnd_file.log,fnd_message.get);
1099: END IF;
1100:
1101:

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

1094: ancrec.error_msg:= null;
1095: l_rec_cntr := NVL(l_rec_cntr,0) + 1;
1096: ELSE
1097: fnd_message.set_name('IGS', 'IGS_FI_ANC_REC_IN_ERROR');
1098: fnd_file.put_line(fnd_file.log,fnd_message.get);
1099: END IF;
1100:
1101:
1102: -- The Record in the Ancillary Interface table to be updated with

Line 1156: fnd_file.put_line(fnd_file.log,fnd_message.get_string ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(l_rec_cntr));

1152: x_validation_flag => ancrec.validation_flag,
1153: x_mode => 'R');
1154: COMMIT;
1155: END LOOP;
1156: fnd_file.put_line(fnd_file.log,fnd_message.get_string ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(l_rec_cntr));
1157: retcode :=0;
1158:
1159: EXCEPTION
1160: WHEN l_exception THEN

Line 1164: fnd_message.set_name('IGS','IGS_FI_ANC_REC_IN_ERROR');

1160: WHEN l_exception THEN
1161: retcode := 2;
1162: WHEN OTHERS THEN
1163: retcode := 2;
1164: fnd_message.set_name('IGS','IGS_FI_ANC_REC_IN_ERROR');
1165: errbuf := fnd_message.Get;
1166: igs_ge_msg_stack.conc_exception_hndl;
1167: END finp_imp_calc_anc_charges;
1168:

Line 1165: errbuf := fnd_message.Get;

1161: retcode := 2;
1162: WHEN OTHERS THEN
1163: retcode := 2;
1164: fnd_message.set_name('IGS','IGS_FI_ANC_REC_IN_ERROR');
1165: errbuf := fnd_message.Get;
1166: igs_ge_msg_stack.conc_exception_hndl;
1167: END finp_imp_calc_anc_charges;
1168:
1169: FUNCTION Check_Person_Id(p_person_id IN igs_pe_person.person_id%TYPE,