[Home] [Help]
785: l_count := 0;
786: IF ((p_int_val_rec.parent_id IS NOT NULL) AND (p_int_val_rec.parent_id <> fnd_api.g_miss_num)) THEN
787: BEGIN
788: SELECT count(interaction_id) into l_count
789: FROM jtf_ih_interactions
790: WHERE interaction_id = p_int_val_rec.parent_id;
791: IF (l_count <= 0) THEN
792: x_return_status := fnd_api.g_ret_sts_error;
793: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.parent_id),
977:
978: IF ((p_act_val_rec.interaction_id IS NOT NULL) AND (p_act_val_rec.interaction_id <> fnd_api.g_miss_num)) THEN
979: BEGIN
980: SELECT count(interaction_id) into l_count
981: FROM jtf_ih_interactions
982: WHERE interaction_id = p_act_val_rec.interaction_id;
983: IF (l_count <= 0) THEN
984: x_return_status := fnd_api.g_ret_sts_error;
985: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.interaction_id),
1546: BEGIN
1547: IF (n_interaction_id IS NOT NULL) AND (n_interaction_id <> fnd_api.g_miss_num) THEN
1548: -- Check activity value in the JTF_IH_ACTIVITIES table.
1549: BEGIN
1550: SELECT interaction_id INTO n_Return FROM jtf_ih_interactions WHERE interaction_id = n_interaction_id;
1551: -- If value is presend then return an error (invalid activity_id)
1552: IF n_Return IS NOT NULL THEN
1553: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_INTER_ID');
1554: FND_MESSAGE.SET_TOKEN('VALUE', n_interaction_id);
1561: RETURN n_interaction_id;
1562: END;
1563: ELSIF ((n_interaction_id IS NULL) OR (n_interaction_id = fnd_api.g_miss_num)) THEN
1564: LOOP
1565: SELECT jtf_ih_interactions_s1.NEXTVAL INTO n_Return FROM dual;
1566: BEGIN
1567: SELECT interaction_id INTO n_Dummy FROM jtf_ih_interactions WHERE interaction_id = n_Return;
1568: EXCEPTION
1569: WHEN NO_DATA_FOUND THEN
1563: ELSIF ((n_interaction_id IS NULL) OR (n_interaction_id = fnd_api.g_miss_num)) THEN
1564: LOOP
1565: SELECT jtf_ih_interactions_s1.NEXTVAL INTO n_Return FROM dual;
1566: BEGIN
1567: SELECT interaction_id INTO n_Dummy FROM jtf_ih_interactions WHERE interaction_id = n_Return;
1568: EXCEPTION
1569: WHEN NO_DATA_FOUND THEN
1570: EXIT;
1571: END;
2921: END IF;
2922:
2923: -- Bug# 2817083
2924: --IF ((p_interaction_rec.interaction_id IS NULL) OR (p_interaction_rec.interaction_id = fnd_api.g_miss_num)) THEN
2925: -- SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;
2926: --END IF;
2927: l_int_val_rec.interaction_id := Get_Interaction_ID(p_interaction_rec.interaction_id);
2928: IF l_int_val_rec.interaction_id = -1 THEN
2929: RAISE fnd_api.g_exc_error;
2934: RAISE fnd_api.g_exc_error;
2935: END IF;
2936:
2937: -- Perf fix for literal Usage
2938: INSERT INTO jtf_ih_Interactions
2939: (
2940: CREATED_BY,
2941: REFERENCE_FORM,
2942: CREATION_DATE,
3049: decode( l_int_val_rec.contact_rel_party_id, fnd_api.g_miss_num, null, l_int_val_rec.contact_rel_party_id),
3050: decode( l_int_val_rec.contact_party_id, fnd_api.g_miss_num, null, l_int_val_rec.contact_party_id)
3051: );
3052:
3053: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB.Create_Interaction');
3054: --1791550
3055: --
3056: for idx in 1 .. l_activities.count loop
3057: l_activities(idx).interaction_id := l_int_val_rec.interaction_id;
3842: END IF;
3843: END IF;
3844:
3845: SELECT count(*) into interactionCount
3846: FROM jtf_ih_Interactions
3847: where outcome_id = p_outcome_id
3848: and result_id = p_result_id
3849: and reason_id = p_reason_id
3850: -- and (attribute1 = p_attribute1) -- or (p_attribute1 is NULL and attribute1 is NULL))
4139: END IF;
4140: END IF;
4141: --l_test_msg := '5';
4142:
4143: --SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;
4144: --l_test_msg := '6';
4145:
4146: -- Bug# 2817083
4147: --l_interaction_id := Get_Interaction_ID(NULL);
4154: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
4155: RAISE fnd_api.g_exc_error;
4156: END IF;
4157:
4158: INSERT INTO jtf_ih_interactions
4159: (
4160: CREATED_BY,
4161: REFERENCE_FORM,
4162: CREATION_DATE,
4266: decode( l_interaction_rec.contact_rel_party_id, fnd_api.g_miss_num, null, l_interaction_rec.contact_rel_party_id),
4267: decode( l_interaction_rec.contact_party_id, fnd_api.g_miss_num, null, l_interaction_rec.contact_party_id)
4268: );
4269: --l_test_msg := '7';
4270: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB.Open_Interaction');
4271:
4272:
4273: IF ((p_interaction_rec.parent_id IS NOT NULL) AND (p_interaction_rec.parent_id <> fnd_api.g_miss_num)) THEN
4274: INSERT INTO jtf_ih_interaction_inters
4453: l_contact_party_id NUMBER;
4454: l_profile_id VARCHAR2(20); --profile option id check to update closed interaction
4455: CURSOR c_Interaction_csr IS
4456: SELECT *
4457: FROM JTF_IH_INTERACTIONS
4458: WHERE interaction_id = p_interaction_rec.interaction_id
4459: FOR UPDATE;
4460: l_Interaction_rec c_Interaction_csr%ROWTYPE;
4461:
5134: RAISE fnd_api.g_exc_error;
5135: END IF;
5136:
5137: --
5138: -- Update table JTF_IH_INTERACTIONS
5139: --
5140: IF (p_interaction_rec.interaction_id IS NULL) THEN
5141: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'interaction_id');
5142: RAISE fnd_api.g_exc_error;
5142: RAISE fnd_api.g_exc_error;
5143: ELSE
5144: l_count := 0;
5145: SELECT count(*) into l_count
5146: FROM jtf_ih_interactions
5147: WHERE interaction_id = p_interaction_rec.interaction_id;
5148: IF(l_count <> 1) THEN
5149: x_return_status := fnd_api.g_ret_sts_error;
5150: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.interaction_id),
5155: p_data => x_msg_data );
5156: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5157: RETURN;
5158: ELSE
5159: UPDATE JTF_IH_INTERACTIONS
5160: SET
5161: REFERENCE_FORM = l_int_rec.reference_form,
5162: LAST_UPDATED_BY = p_user_id,
5163: DURATION = l_int_rec.duration,
5210: Close c_Interaction_csr;
5211: --
5212: END IF;
5213: END IF;
5214: -- DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_interactions in JTF_IH_PUB.Update_Interaction');
5215:
5216: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB.Update_Interaction');
5217:
5218: -- Post processing Call
5470:
5471: -- DBMS_OUTPUT.PUT_LINE('PAST validate at least one Activity per Interaction in JTF_IH_PUB.Close_Interaction');
5472: --SELECT outcome_id into l_outcome_id
5473: SELECT outcome_id into l_interaction_rec.outcome_id
5474: FROM jtf_ih_interactions
5475: WHERE interaction_id = p_interaction_rec.interaction_id;
5476: IF (l_interaction_rec.outcome_id IS NULL) or (l_interaction_rec.outcome_id = fnd_api.g_miss_num) THEN
5477: x_return_status := fnd_api.g_ret_sts_error;
5478: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),
5490: --into l_end_date_time, l_start_date_time, l_duration
5491: into l_interaction_rec.end_date_time,
5492: l_interaction_rec.start_date_time,
5493: l_interaction_rec.duration
5494: FROM jtf_ih_interactions
5495: WHERE interaction_id = p_interaction_rec.interaction_id;
5496:
5497: -- Added by IAleshin 21-MAY-2002
5498: --
5666: -- DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB.Close_Interaction');
5667:
5668: -- Changed location by IAleshin
5669: -- Bug# 2418028
5670: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
5671: --
5672: -- Check if end_date_time is currently 'null' or 'fnd_api.g_miss_date'
5673: -- If either of the above is true, then set end_date_time to sysdate
5674: --
5673: -- If either of the above is true, then set end_date_time to sysdate
5674: --
5675:
5676: -- Perf fix for literal Usage
5677: UPDATE jtf_ih_interactions
5678: SET ACTIVE = l_active_perf,
5679: START_DATE_TIME = l_interaction_rec.start_date_time,
5680: end_date_time = l_interaction_rec.end_date_time,
5681: duration = l_interaction_rec.duration
5888: -- If Activity added to closed interaction active status = 'N'
5889:
5890: SELECT active
5891: INTO l_inter_active
5892: FROM JTF_IH_INTERACTIONS
5893: WHERE interaction_id = p_activity_rec.interaction_id;
5894:
5895: IF l_inter_active = 'Y' THEN
5896: l_active := 'Y';
5952: l_activity_rec.resource_id := p_activity_rec.resource_id;
5953: ELSE
5954: -- If resource_id is null or g_miss_num, then get value from parent interaction
5955: SELECT resource_id INTO l_activity_rec.resource_id
5956: FROM jtf_ih_interactions WHERE interaction_id = p_activity_rec.interaction_id;
5957: END IF;*/
5958:
5959: -- Bug 2817083
5960: --l_activity_id := Get_Activity_ID(NULL);
6329: END IF;
6330: -- DBMS_OUTPUT.PUT_LINE('PAST Validate_Activity_Record in JTF_IH_PUB.Update_Activity');
6331:
6332: --
6333: -- Update table JTF_IH_INTERACTIONS
6334: --
6335: IF (p_activity_rec.activity_id IS NULL) THEN
6336: jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');
6337: RAISE fnd_api.g_exc_error;
7021: -- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Close_Interaction_2');
7022:
7023: SELECT outcome_id, end_date_time, start_date_time, duration
7024: INTO l_outcome_id, l_end_date_time, l_start_date_time, l_duration
7025: FROM jtf_ih_interactions
7026: WHERE interaction_id = p_interaction_id;
7027: IF ((l_outcome_id IS NULL) OR (l_outcome_id = fnd_api.g_miss_num)) THEN
7028: x_return_status := fnd_api.g_ret_sts_error;
7029: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
7031: RETURN;
7032: END IF;
7033:
7034: -- SELECT end_date_time, start_date_time into l_end_date_time, l_start_date_time
7035: -- FROM jtf_ih_interactions
7036: -- WHERE interaction_id = p_interaction_id;
7037:
7038: IF ((l_end_date_time IS NULL) OR (l_end_date_time = FND_API.G_MISS_DATE)) THEN
7039: l_end_date_time := SYSDATE;
7161: -- DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB.Close_Interaction_2');
7162:
7163: -- Bug# 2418345
7164: --
7165: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
7166: --
7167: -- Perf fix for literal Usage
7168: UPDATE jtf_ih_interactions SET ACTIVE = l_active_perf,end_date_time =l_end_date_time,
7169: duration = decode(l_duration, fnd_api.g_miss_num, l_duration_perf, l_duration)
7164: --
7165: -- Set active to 'N' for jtf_ih_interactions and related jtf_ih_activities
7166: --
7167: -- Perf fix for literal Usage
7168: UPDATE jtf_ih_interactions SET ACTIVE = l_active_perf,end_date_time =l_end_date_time,
7169: duration = decode(l_duration, fnd_api.g_miss_num, l_duration_perf, l_duration)
7170: WHERE interaction_id = p_interaction_id;
7171:
7172: -- Post processing Call