649:
650: -- initialize the party record
651:
652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
650: -- initialize the party record
651:
652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
651:
652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
652: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
653: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
661:
654: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
655: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
661:
662: -- do not initialise the attribute 1.20 and do not pass global attributes 1.20
656: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
657: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
658: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
659: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
660: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
661:
662: -- do not initialise the attribute 1.20 and do not pass global attributes 1.20
663:
664: IF X_ACTION ='INSERT' THEN
687: fnd_message.set_name ('AR',Y_MSG_DATA);
688: --Code added by sbaliga as part of #2338473
689: IF z_msg_count > 1 THEN
690: FOR i IN 1..z_msg_count LOOP
691: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
692: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
693: END LOOP;
694: z_msg_data := l_tmp_var1;
695: END IF;
984: CLOSE PARTY_CUR;
985:
986:
987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
985:
986:
987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
986:
987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
987: LV_PERSON_REC_TYPE.PARTY_REC.PARTY_ID := X_PERSON_ID;
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
988: LV_PERSON_REC_TYPE.DECLARED_ETHNICITY := NVL(X_ETHNIC_ORIGIN_ID,FND_API.G_MISS_CHAR);
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
996:
989: LV_PERSON_REC_TYPE.MARITAL_STATUS := NVL(X_MARITAL_STATUS , FND_API.G_MISS_CHAR);
990: LV_PERSON_REC_TYPE.MARITAL_STATUS_EFFECTIVE_DATE := NVL(X_MARITAL_STAT_EFFECT_DT ,FND_API.G_MISS_DATE);
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
996:
997:
991: LV_PERSON_REC_TYPE.HOUSEHOLD_INCOME := NVL(X_ANN_FAMILY_INCOME,FND_API.G_MISS_NUM);
992: LV_PERSON_REC_TYPE.HOUSEHOLD_SIZE := NVL(X_NUMBER_IN_FAMILY,FND_API.G_MISS_NUM);
993: LV_PERSON_REC_TYPE.PLACE_OF_BIRTH := NVL(X_PLACE_OF_BIRTH,FND_API.G_MISS_CHAR);
994: LV_PERSON_REC_TYPE.CONTENT_SOURCE_TYPE := HZ_PARTY_V2PUB.G_MISS_CONTENT_SOURCE_TYPE;
995: LV_PERSON_REC_TYPE.INTERNAL_FLAG := NVL(X_INTERNAL_FLAG , FND_API.G_MISS_CHAR);
996:
997:
998: IF X_ACTION ='UPDATE' THEN
999:
1020: -- fnd_message.set_name ('AR', Y_MSG_DATA);
1021: --Code added by sbaliga as part of #2338473
1022: IF z_msg_count > 1 THEN
1023: FOR i IN 1..z_msg_count LOOP
1024: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1025: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
1026: END LOOP;
1027: z_msg_data := l_tmp_var1;
1028: END IF;