DBA Data[Home] [Help]

APPS.IGS_PE_WF_GEN dependencies on FND_MESSAGE

Line 143: fnd_message.set_name('IGS','IGS_PE_RES_CHG_MES_SUBJ');

139: l_message VARCHAR2(2000);
140: res_dtl_rec res_dtl_cur%ROWTYPE;
141: BEGIN
142:
143: fnd_message.set_name('IGS','IGS_PE_RES_CHG_MES_SUBJ');
144: l_message := fnd_message.get;
145:
146: -- Getting the paremeter values from the workflow
147:

Line 144: l_message := fnd_message.get;

140: res_dtl_rec res_dtl_cur%ROWTYPE;
141: BEGIN
142:
143: fnd_message.set_name('IGS','IGS_PE_RES_CHG_MES_SUBJ');
144: l_message := fnd_message.get;
145:
146: -- Getting the paremeter values from the workflow
147:
148: l_res_dtls_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'RES_DTLS_ID');

Line 385: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');

381: IF (get_location_dets%FOUND) THEN
382:
383: -- set the workflow parameters.
384:
385: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');
386: l_message := fnd_message.get;
387:
388: Wf_Engine.SetItemAttrText(
389: ItemType => itemtype,

Line 386: l_message := fnd_message.get;

382:
383: -- set the workflow parameters.
384:
385: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');
386: l_message := fnd_message.get;
387:
388: Wf_Engine.SetItemAttrText(
389: ItemType => itemtype,
390: ItemKey => itemkey,

Line 510: fnd_message.set_name('IGS','IGS_PR_PERSON_ID');

506: avalue => l_message
507: );
508: IF (cur_get_party_id_rec.party_type='PERSON') THEN
509: l_message:=null;
510: fnd_message.set_name('IGS','IGS_PR_PERSON_ID');
511: l_message := fnd_message.get;
512:
513: ELSE
514: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='I'))THEN

Line 511: l_message := fnd_message.get;

507: );
508: IF (cur_get_party_id_rec.party_type='PERSON') THEN
509: l_message:=null;
510: fnd_message.set_name('IGS','IGS_PR_PERSON_ID');
511: l_message := fnd_message.get;
512:
513: ELSE
514: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='I'))THEN
515: l_message:=null;

Line 516: fnd_message.set_name('IGS','IGS_OR_INSTITUTION_CODE');

512:
513: ELSE
514: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='I'))THEN
515: l_message:=null;
516: fnd_message.set_name('IGS','IGS_OR_INSTITUTION_CODE');
517: l_message := fnd_message.get;
518:
519: ELSE
520: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='O')) THEN

Line 517: l_message := fnd_message.get;

513: ELSE
514: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='I'))THEN
515: l_message:=null;
516: fnd_message.set_name('IGS','IGS_OR_INSTITUTION_CODE');
517: l_message := fnd_message.get;
518:
519: ELSE
520: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='O')) THEN
521: l_message:=null;

Line 522: fnd_message.set_name('IGS','IGS_RE_ORG_UNIT_CD');

518:
519: ELSE
520: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='O')) THEN
521: l_message:=null;
522: fnd_message.set_name('IGS','IGS_RE_ORG_UNIT_CD');
523: l_message := fnd_message.get;
524:
525: END IF;
526: END IF;

Line 523: l_message := fnd_message.get;

519: ELSE
520: IF ((cur_get_party_id_rec.party_type='ORGANIZATION') AND (chk_oss_party_rec.inst_org_ind='O')) THEN
521: l_message:=null;
522: fnd_message.set_name('IGS','IGS_RE_ORG_UNIT_CD');
523: l_message := fnd_message.get;
524:
525: END IF;
526: END IF;
527: END IF;

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

627:
628: CLOSE chk_oss_party;
629: --If the identifying_address_flag = 'Y' then it's a primary address. Set the parameter P_PRIM_ADDR_MSG with the message IGS_PE_PRIM_ADDR_MSG
630: IF rec_chk_oss_party.identifying_address_flag = 'Y' THEN
631: fnd_message.set_name('IGS','IGS_PE_PRIM_ADDR_MSG');
632: l_message := fnd_message.get;
633:
634: Wf_Engine.SetItemAttrText(
635: ItemType => itemtype,

Line 632: l_message := fnd_message.get;

628: CLOSE chk_oss_party;
629: --If the identifying_address_flag = 'Y' then it's a primary address. Set the parameter P_PRIM_ADDR_MSG with the message IGS_PE_PRIM_ADDR_MSG
630: IF rec_chk_oss_party.identifying_address_flag = 'Y' THEN
631: fnd_message.set_name('IGS','IGS_PE_PRIM_ADDR_MSG');
632: l_message := fnd_message.get;
633:
634: Wf_Engine.SetItemAttrText(
635: ItemType => itemtype,
636: ItemKey => itemkey,

Line 799: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');

795: aname => 'OLD_POSTAL_CODE',
796: avalue => rec_old_addr_dtls.POSTAL_CODE
797: );
798: -- Set the SUBJECT with message IGS_PE_ADDR_CHG_MES_SUBJ -Address Change Notification
799: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');
800: l_message := fnd_message.get;
801: Wf_Engine.SetItemAttrText(
802: ItemType => itemtype,
803: ItemKey => itemkey,

Line 800: l_message := fnd_message.get;

796: avalue => rec_old_addr_dtls.POSTAL_CODE
797: );
798: -- Set the SUBJECT with message IGS_PE_ADDR_CHG_MES_SUBJ -Address Change Notification
799: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');
800: l_message := fnd_message.get;
801: Wf_Engine.SetItemAttrText(
802: ItemType => itemtype,
803: ItemKey => itemkey,
804: aname => 'SUBJECT',

Line 823: fnd_message.set_name('IGS','IGS_PR_PERSON_ID');

819:
820: --Set PARTY_TYPE and PERSON_NUMBER as per the INST_ORG_IND. INST_ORG_IND is null for PERSON. INST_ORG_IND is 'I' for INSTITUTION. INST_ORG_IND is 'O' for ORGANIZATION.
821: IF rec_chk_oss_party.inst_org_ind IS NULL THEN
822:
823: fnd_message.set_name('IGS','IGS_PR_PERSON_ID');
824: l_message := fnd_message.get;
825: Wf_Engine.SetItemAttrText(
826: ItemType => itemtype,
827: ItemKey => itemkey,

Line 824: l_message := fnd_message.get;

820: --Set PARTY_TYPE and PERSON_NUMBER as per the INST_ORG_IND. INST_ORG_IND is null for PERSON. INST_ORG_IND is 'I' for INSTITUTION. INST_ORG_IND is 'O' for ORGANIZATION.
821: IF rec_chk_oss_party.inst_org_ind IS NULL THEN
822:
823: fnd_message.set_name('IGS','IGS_PR_PERSON_ID');
824: l_message := fnd_message.get;
825: Wf_Engine.SetItemAttrText(
826: ItemType => itemtype,
827: ItemKey => itemkey,
828: aname => 'PARTY_TYPE',

Line 838: fnd_message.set_name('IGS','IGS_OR_INSTITUTION_CODE');

834: aname => 'PERSON_NUMBER',
835: avalue => rec_chk_oss_party.PARTY_NUMBER
836: );
837: ELSIF rec_chk_oss_party.inst_org_ind = 'I' THEN
838: fnd_message.set_name('IGS','IGS_OR_INSTITUTION_CODE');
839: l_message := fnd_message.get;
840:
841: Wf_Engine.SetItemAttrText(
842: ItemType => itemtype,

Line 839: l_message := fnd_message.get;

835: avalue => rec_chk_oss_party.PARTY_NUMBER
836: );
837: ELSIF rec_chk_oss_party.inst_org_ind = 'I' THEN
838: fnd_message.set_name('IGS','IGS_OR_INSTITUTION_CODE');
839: l_message := fnd_message.get;
840:
841: Wf_Engine.SetItemAttrText(
842: ItemType => itemtype,
843: ItemKey => itemkey,

Line 854: fnd_message.set_name('IGS','IGS_RE_ORG_UNIT_CD');

850: aname => 'PERSON_NUMBER',
851: avalue => rec_chk_oss_party.OSS_ORG_UNIT_CD
852: );
853: ELSIF rec_chk_oss_party.inst_org_ind = 'O' THEN
854: fnd_message.set_name('IGS','IGS_RE_ORG_UNIT_CD');
855: l_message := fnd_message.get;
856:
857: Wf_Engine.SetItemAttrText(
858: ItemType => itemtype,

Line 855: l_message := fnd_message.get;

851: avalue => rec_chk_oss_party.OSS_ORG_UNIT_CD
852: );
853: ELSIF rec_chk_oss_party.inst_org_ind = 'O' THEN
854: fnd_message.set_name('IGS','IGS_RE_ORG_UNIT_CD');
855: l_message := fnd_message.get;
856:
857: Wf_Engine.SetItemAttrText(
858: ItemType => itemtype,
859: ItemKey => itemkey,