51: l_party_type VARCHAR2(30);
52: l_contact_party_id NUMBER;
53: l_contact_party_type VARCHAR2(30);
54: l_media_id NUMBER;
55: l_media_rec JTF_IH_PUB.media_rec_type;
56: l_mlcs_rec_tbl JTF_IH_PUB.mlcs_tbl_type;
57: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
58: l_activity_rec_tbl JTF_IH_PUB.activity_tbl_type;
59:
52: l_contact_party_id NUMBER;
53: l_contact_party_type VARCHAR2(30);
54: l_media_id NUMBER;
55: l_media_rec JTF_IH_PUB.media_rec_type;
56: l_mlcs_rec_tbl JTF_IH_PUB.mlcs_tbl_type;
57: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
58: l_activity_rec_tbl JTF_IH_PUB.activity_tbl_type;
59:
60: CURSOR c1 IS SELECT jtf_ih_media_items_s1.nextval FROM dual;
53: l_contact_party_type VARCHAR2(30);
54: l_media_id NUMBER;
55: l_media_rec JTF_IH_PUB.media_rec_type;
56: l_mlcs_rec_tbl JTF_IH_PUB.mlcs_tbl_type;
57: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
58: l_activity_rec_tbl JTF_IH_PUB.activity_tbl_type;
59:
60: CURSOR c1 IS SELECT jtf_ih_media_items_s1.nextval FROM dual;
61:
54: l_media_id NUMBER;
55: l_media_rec JTF_IH_PUB.media_rec_type;
56: l_mlcs_rec_tbl JTF_IH_PUB.mlcs_tbl_type;
57: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
58: l_activity_rec_tbl JTF_IH_PUB.activity_tbl_type;
59:
60: CURSOR c1 IS SELECT jtf_ih_media_items_s1.nextval FROM dual;
61:
62: CURSOR c_party_type(l_party_id NUMBER) IS
167: -- Log Debug Messages Before Calling Create_MediaItem Method.
168: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
169: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
170: MODULE => l_module,
171: MESSAGE => 'Before Calling JTF_IH_PUB.Create_MediaItem... Parameters: ' ||'p_resp_appl_id: ' || FND_GLOBAL.resp_appl_id ||
172: ' p_resp_id: ' || FND_GLOBAL.resp_id || ' p_user_id: ' || FND_GLOBAL.user_id ||
173: ' p_object_type: ' || p_object_type || ' p_object_id: ' || p_object_id ||
174: ' p_login_id: ' || FND_GLOBAL.login_id || ' l_media_id: ' || l_media_id ||
175: ' l_media_item_type: ' || l_media_item_type);
175: ' l_media_item_type: ' || l_media_item_type);
176: END IF;
177:
178: --
179: -- Call JTF_IH_PUB.Create_MediaItem API
180: --
181: JTF_IH_PUB.Create_MediaItem
182: (
183: p_api_version => 1.0,
177:
178: --
179: -- Call JTF_IH_PUB.Create_MediaItem API
180: --
181: JTF_IH_PUB.Create_MediaItem
182: (
183: p_api_version => 1.0,
184: p_init_msg_list => FND_API.G_FALSE,
185: p_commit => FND_API.G_FALSE,
198: -- Log Debug Messages After Calling Create_MediaItem Method.
199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
200: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
201: MODULE => l_module,
202: MESSAGE => 'After Calling JTF_IH_PUB.Create_MediaItem...Out Parameters: ' ||'x_return_status: ' || x_return_status ||
203: ' x_msg_count: ' || x_msg_count || ' x_msg_data: ' || x_msg_data);
204: END IF;
205:
206: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
234: l_activity_rec_tbl(1).doc_id := p_object_id;
235: l_activity_rec_tbl(1).doc_ref := p_object_type;
236:
237: --
238: -- Call JTF_IH_PUB.Create_Interaction API
239: --
240:
241: OPEN c_party_type(p_party_id);
242: FETCH c_party_type INTO l_party_type;
277: -- Log Debug Messages Before Calling Create_Interaction Method.
278: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
279: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
280: MODULE => l_module,
281: MESSAGE => 'Before Calling JTF_IH_PUB.Create_Interaction...');
282: END IF;
283:
284: JTF_IH_PUB.Create_Interaction
285: (
280: MODULE => l_module,
281: MESSAGE => 'Before Calling JTF_IH_PUB.Create_Interaction...');
282: END IF;
283:
284: JTF_IH_PUB.Create_Interaction
285: (
286: p_api_version => 1.0,
287: p_init_msg_list => FND_API.G_FALSE,
288: p_commit => FND_API.G_FALSE,
300: -- Log Debug Messages After Calling Create_Interaction Method.
301: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
302: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
303: MODULE => l_module,
304: MESSAGE => 'After Calling JTF_IH_PUB.Create_Interaction...Out Parameters: ' ||'x_return_status: ' || x_return_status ||
305: ' x_msg_count: ' || x_msg_count || ' x_msg_data: ' || x_msg_data);
306: END IF;
307:
308: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
318: -- Log Debug Messages Before Calling Create_Interaction Method.
319: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
320: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
321: MODULE => l_module,
322: MESSAGE => 'Before Calling JTF_IH_PUB.Create_Interaction...');
323: END IF;
324:
325: l_interaction_rec.contact_party_id := p_party_id;
326: JTF_IH_PUB.Create_Interaction
322: MESSAGE => 'Before Calling JTF_IH_PUB.Create_Interaction...');
323: END IF;
324:
325: l_interaction_rec.contact_party_id := p_party_id;
326: JTF_IH_PUB.Create_Interaction
327: (
328: p_api_version => 1.0,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_commit => FND_API.G_FALSE,
342: -- Log Debug Messages After Calling Create_Interaction Method.
343: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
344: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
345: MODULE => l_module,
346: MESSAGE => 'After Calling JTF_IH_PUB.Create_Interaction...Out Parameters: ' ||'x_return_status: ' || x_return_status ||
347: ' x_msg_count: ' || x_msg_count || ' x_msg_data: ' || x_msg_data);
348: END IF;
349:
350: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN