125:
126: l_msg_count :=0;
127: --gmaheswa: HZ_API ia changed to HZ_PERSON_INFOR_V2PUB from HZ_PER_INFO_PUB.
128: Hz_Person_Info_V2Pub.create_person_interest(
129: p_init_msg_list => FND_API.G_TRUE,
130: p_person_interest_rec => p_per_interest_rec,
131: x_person_interest_id => l_person_interest_id,
132: x_return_status => l_return_status,
133: x_msg_count => l_msg_count,
140:
141: IF l_return_status IN ('E','U') THEN
142: IF l_msg_count > 1 THEN
143: FOR i IN 1..l_msg_count LOOP
144: tmp_var := fnd_msg_pub.get(p_msg_index =>i, p_encoded => fnd_api.g_false);
145: tmp_var1 := tmp_var1 || ' '|| tmp_var;
146: END LOOP;
147: x_msg_data := tmp_var1;
148: ELSE
296: END IF;
297:
298:
299: p_per_interest_rec.person_interest_id := x_person_interest_id;
300: p_per_interest_rec.level_of_interest := NVL(x_level_of_interest,FND_API.G_MISS_CHAR);
301: p_per_interest_rec.level_of_participation := NVL(x_level_of_Participation,FND_API.G_MISS_CHAR);
302: p_per_interest_rec.interest_type_code := NVL(x_interest_type_code,FND_API.G_MISS_CHAR);
303: p_per_interest_rec.party_id := x_person_id;
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
297:
298:
299: p_per_interest_rec.person_interest_id := x_person_interest_id;
300: p_per_interest_rec.level_of_interest := NVL(x_level_of_interest,FND_API.G_MISS_CHAR);
301: p_per_interest_rec.level_of_participation := NVL(x_level_of_Participation,FND_API.G_MISS_CHAR);
302: p_per_interest_rec.interest_type_code := NVL(x_interest_type_code,FND_API.G_MISS_CHAR);
303: p_per_interest_rec.party_id := x_person_id;
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
298:
299: p_per_interest_rec.person_interest_id := x_person_interest_id;
300: p_per_interest_rec.level_of_interest := NVL(x_level_of_interest,FND_API.G_MISS_CHAR);
301: p_per_interest_rec.level_of_participation := NVL(x_level_of_Participation,FND_API.G_MISS_CHAR);
302: p_per_interest_rec.interest_type_code := NVL(x_interest_type_code,FND_API.G_MISS_CHAR);
303: p_per_interest_rec.party_id := x_person_id;
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
306: p_per_interest_rec.comments := NVL(x_Comments,FND_API.G_MISS_CHAR);
300: p_per_interest_rec.level_of_interest := NVL(x_level_of_interest,FND_API.G_MISS_CHAR);
301: p_per_interest_rec.level_of_participation := NVL(x_level_of_Participation,FND_API.G_MISS_CHAR);
302: p_per_interest_rec.interest_type_code := NVL(x_interest_type_code,FND_API.G_MISS_CHAR);
303: p_per_interest_rec.party_id := x_person_id;
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
306: p_per_interest_rec.comments := NVL(x_Comments,FND_API.G_MISS_CHAR);
307: p_per_interest_rec.sub_interest_type_code := NVL(x_Sub_Interest_Type_Code,FND_API.G_MISS_CHAR);
308: p_per_interest_rec.team := NVL(x_team,FND_API.G_MISS_CHAR);
301: p_per_interest_rec.level_of_participation := NVL(x_level_of_Participation,FND_API.G_MISS_CHAR);
302: p_per_interest_rec.interest_type_code := NVL(x_interest_type_code,FND_API.G_MISS_CHAR);
303: p_per_interest_rec.party_id := x_person_id;
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
306: p_per_interest_rec.comments := NVL(x_Comments,FND_API.G_MISS_CHAR);
307: p_per_interest_rec.sub_interest_type_code := NVL(x_Sub_Interest_Type_Code,FND_API.G_MISS_CHAR);
308: p_per_interest_rec.team := NVL(x_team,FND_API.G_MISS_CHAR);
309: p_per_interest_rec.since := NVL(x_Start_Date,FND_API.G_MISS_DATE);
302: p_per_interest_rec.interest_type_code := NVL(x_interest_type_code,FND_API.G_MISS_CHAR);
303: p_per_interest_rec.party_id := x_person_id;
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
306: p_per_interest_rec.comments := NVL(x_Comments,FND_API.G_MISS_CHAR);
307: p_per_interest_rec.sub_interest_type_code := NVL(x_Sub_Interest_Type_Code,FND_API.G_MISS_CHAR);
308: p_per_interest_rec.team := NVL(x_team,FND_API.G_MISS_CHAR);
309: p_per_interest_rec.since := NVL(x_Start_Date,FND_API.G_MISS_DATE);
310:
303: p_per_interest_rec.party_id := x_person_id;
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
306: p_per_interest_rec.comments := NVL(x_Comments,FND_API.G_MISS_CHAR);
307: p_per_interest_rec.sub_interest_type_code := NVL(x_Sub_Interest_Type_Code,FND_API.G_MISS_CHAR);
308: p_per_interest_rec.team := NVL(x_team,FND_API.G_MISS_CHAR);
309: p_per_interest_rec.since := NVL(x_Start_Date,FND_API.G_MISS_DATE);
310:
311: --gmaheswa: HZ_API ia changed to HZ_PERSON_INFOR_V2PUB from HZ_PER_INFO_PUB.
304: p_per_interest_rec.sport_indicator := NVL(x_Sport_Indicator,FND_API.G_MISS_CHAR);
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
306: p_per_interest_rec.comments := NVL(x_Comments,FND_API.G_MISS_CHAR);
307: p_per_interest_rec.sub_interest_type_code := NVL(x_Sub_Interest_Type_Code,FND_API.G_MISS_CHAR);
308: p_per_interest_rec.team := NVL(x_team,FND_API.G_MISS_CHAR);
309: p_per_interest_rec.since := NVL(x_Start_Date,FND_API.G_MISS_DATE);
310:
311: --gmaheswa: HZ_API ia changed to HZ_PERSON_INFOR_V2PUB from HZ_PER_INFO_PUB.
312: Hz_Person_Info_V2Pub.Update_person_interest(
305: p_per_interest_rec.interest_name := NVL(x_Interest_Name,FND_API.G_MISS_CHAR);
306: p_per_interest_rec.comments := NVL(x_Comments,FND_API.G_MISS_CHAR);
307: p_per_interest_rec.sub_interest_type_code := NVL(x_Sub_Interest_Type_Code,FND_API.G_MISS_CHAR);
308: p_per_interest_rec.team := NVL(x_team,FND_API.G_MISS_CHAR);
309: p_per_interest_rec.since := NVL(x_Start_Date,FND_API.G_MISS_DATE);
310:
311: --gmaheswa: HZ_API ia changed to HZ_PERSON_INFOR_V2PUB from HZ_PER_INFO_PUB.
312: Hz_Person_Info_V2Pub.Update_person_interest(
313: p_init_msg_list => FND_API.G_TRUE,
309: p_per_interest_rec.since := NVL(x_Start_Date,FND_API.G_MISS_DATE);
310:
311: --gmaheswa: HZ_API ia changed to HZ_PERSON_INFOR_V2PUB from HZ_PER_INFO_PUB.
312: Hz_Person_Info_V2Pub.Update_person_interest(
313: p_init_msg_list => FND_API.G_TRUE,
314: p_person_interest_rec => p_per_interest_rec,
315: p_object_version_number => x_object_version_number,
316: x_return_status => l_return_status,
317: x_msg_count => l_msg_count,
324: IF l_return_status IN ('E','U') THEN
325:
326: IF l_msg_count > 1 THEN
327: FOR i IN 1..l_msg_count LOOP
328: tmp_var := fnd_msg_pub.get(p_msg_index =>i, p_encoded => fnd_api.g_false);
329: tmp_var1 := tmp_var1 || ' '|| tmp_var;
330: END LOOP;
331: x_msg_data := tmp_var1;
332: ELSE