eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_IH_PUB dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.Add;

94: --jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'),'end_date_time');
95: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_END_DATE');
96: FND_MESSAGE.SET_TOKEN('END_DATE', to_char(p_end_date_time, 'DD-MON-RRRR HH:MI:SS'));
97: FND_MESSAGE.SET_TOKEN('START_DATE', to_char(p_start_date_time, 'DD-MON-RRRR HH:MI:SS'));
98: FND_MSG_PUB.Add;
99: END IF;
100: END Validate_StartEnd_Date;
101:
102:

Line 190: FND_MSG_PUB.Add;

186: WHEN NO_DATA_FOUND THEN
187: x_return_status := fnd_api.g_ret_sts_error;
188: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY_RELATIONSHIP');
189: FND_MESSAGE.SET_TOKEN('PARTY', p_Party_ID);
190: FND_MSG_PUB.Add;
191: RETURN;
192: END;
193:
194: --

Line 223: FND_MSG_PUB.Add;

219: IF s_Party_Type IS NULL THEN
220: x_return_status := fnd_api.g_ret_sts_error;
221: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
222: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
223: FND_MSG_PUB.Add;
224: RETURN;
225: END IF;
226:
227: -- Case# 1 - Person as customer - Same person Contac

Line 275: FND_MSG_PUB.Add;

271: ELSE
272: x_return_status := fnd_api.g_ret_sts_error;
273: FND_MESSAGE.SET_NAME('JTF','JTF_IH_WRONG_PARTY_REL');
274: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);
275: FND_MSG_PUB.Add;
276: RETURN;
277: END IF;
278: END IF;
279: END IF;

Line 307: FND_MSG_PUB.Add;

303: IF p_int_val_rec.primary_party_id IS NULL THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305: FND_MESSAGE.SET_NAME('JTF','JTF_IH_REQ_ITEM_MSG');
306: FND_MESSAGE.SET_TOKEN('FIELDNAME', 'Primary_Party_ID');
307: FND_MSG_PUB.Add;
308: RETURN;
309: END IF;
310:
311: -- Check valid combination for Contact_Party_ID and Primary_Party_Id and Contact_Rel_Party_ID

Line 318: FND_MSG_PUB.Add;

314: p_int_val_rec.Primary_Party_Id IS NOT NULL
315: AND p_int_val_rec.Contact_Rel_Party_ID IS NOT NULL THEN
316: x_return_status := fnd_api.g_ret_sts_error;
317: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PARTY_COMB');
318: FND_MSG_PUB.Add;
319: RETURN;
320: END IF;
321:
322: -- If the Party_Id is not equals to one of the other party id values them it must be validated separately - Case #5 and #6

Line 333: FND_MSG_PUB.Add;

329: IF s_Party_Type IS NULL THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
332: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
333: FND_MSG_PUB.Add;
334: RETURN;
335: END IF;
336:
337: IF s_Party_Type <> 'ORGANIZATION' THEN

Line 341: FND_MSG_PUB.Add;

337: IF s_Party_Type <> 'ORGANIZATION' THEN
338: x_return_status := fnd_api.g_ret_sts_error;
339: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PARTIES_NOT_EQUAL');
340: FND_MESSAGE.SET_TOKEN('PARTY_ID', p_int_val_rec.party_id);
341: FND_MSG_PUB.Add;
342: RETURN;
343: END IF;
344: END IF;
345: -- Validate cases no contact_rel_party_id is passed Case#1, Case#3, Case#5

Line 354: FND_MSG_PUB.Add;

350: x_return_status := fnd_api.g_ret_sts_error;
351: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
352: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.party_id);
353: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
354: FND_MSG_PUB.Add;
355: RETURN;
356: END IF;
357:
358: -- Get Contact Party Type

Line 365: FND_MSG_PUB.Add;

361: IF s_Party_Type IS NULL THEN
362: x_return_status := fnd_api.g_ret_sts_error;
363: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
364: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.contact_party_id);
365: FND_MSG_PUB.Add;
366: RETURN;
367: END IF;
368: IF s_Party_Type <> 'PERSON' THEN
369: x_return_status := fnd_api.g_ret_sts_error;

Line 372: FND_MSG_PUB.Add;

368: IF s_Party_Type <> 'PERSON' THEN
369: x_return_status := fnd_api.g_ret_sts_error;
370: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
371: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
372: FND_MSG_PUB.Add;
373: RETURN;
374: END IF;
375: x_return_status := fnd_api.g_ret_sts_success;
376: RETURN;

Line 385: FND_MSG_PUB.Add;

381: IF s_Party_Type IS NULL THEN
382: x_return_status := fnd_api.g_ret_sts_error;
383: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
384: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.primary_party_id);
385: FND_MSG_PUB.Add;
386: RETURN;
387: END IF;
388: IF s_Party_Type <> 'ORGANIZATION' THEN
389: x_return_status := fnd_api.g_ret_sts_error;

Line 393: FND_MSG_PUB.Add;

389: x_return_status := fnd_api.g_ret_sts_error;
390: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PERSON_PARTY');
391: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
392: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
393: FND_MSG_PUB.Add;
394: RETURN;
395: END IF;
396: x_return_status := fnd_api.g_ret_sts_success;
397: RETURN;

Line 423: FND_MSG_PUB.Add;

419: IF s_Object_Type <> 'PERSON' THEN
420: x_return_status := fnd_api.g_ret_sts_error;
421: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
422: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
423: FND_MSG_PUB.Add;
424: RETURN;
425: END IF;
426:
427: -- Validate the primary

Line 438: FND_MSG_PUB.Add;

434: -- The primary is not a PERSON or an ORGANIZATION
435: x_return_status := fnd_api.g_ret_sts_error;
436: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');
437: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
438: FND_MSG_PUB.Add;
439: RETURN;
440: END IF;
441: ELSE
442: -- The primary_Id is not part of the relationship

Line 447: FND_MSG_PUB.Add;

443: x_return_status := fnd_api.g_ret_sts_error;
444: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
445: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
446: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
447: FND_MSG_PUB.Add;
448: RETURN;
449: END IF;
450: ELSE
451: -- Is contact_party_id the subject?

Line 459: FND_MSG_PUB.Add;

455: -- The contact is not a Person
456: x_return_status := fnd_api.g_ret_sts_error;
457: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NON_PERSON_CONTACT');
458: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
459: FND_MSG_PUB.Add;
460: RETURN;
461: END IF;
462: IF p_int_val_rec.primary_party_id = n_Object_id THEN
463: IF s_Object_Type IN ('PERSON','ORGANIZATION') THEN

Line 471: FND_MSG_PUB.Add;

467: -- The Primary is not part of the relatioship
468: x_return_status := fnd_api.g_ret_sts_error;
469: FND_MESSAGE.SET_NAME('JTF','JTF_IH_INVALID_PRIMARY_ID');
470: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
471: FND_MSG_PUB.Add;
472: RETURN;
473: END IF;
474: ELSE
475: -- The Primary is not part of the relatioship

Line 480: FND_MSG_PUB.Add;

476: x_return_status := fnd_api.g_ret_sts_error;
477: FND_MESSAGE.SET_NAME('JTF','JTF_IH_PRIMARY_IS_NOT_REL');
478: FND_MESSAGE.SET_TOKEN('P_PARTY_ID', p_int_val_rec.primary_party_id);
479: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
480: FND_MSG_PUB.Add;
481: RETURN;
482: END IF;
483: ELSE
484: -- The Contact is not part of the relationship

Line 489: FND_MSG_PUB.Add;

485: x_return_status := fnd_api.g_ret_sts_error;
486: FND_MESSAGE.SET_NAME('JTF','JTF_IH_CONTACT_IS_NOT_REL');
487: FND_MESSAGE.SET_TOKEN('C_PARTY_ID', p_int_val_rec.contact_party_id);
488: FND_MESSAGE.SET_TOKEN('R_PARTY_ID', p_int_val_rec.contact_rel_party_id);
489: FND_MSG_PUB.Add;
490: RETURN;
491: END IF;
492: END IF;
493: x_return_status := fnd_api.g_ret_sts_success;

Line 541: FND_MSG_PUB.Add;

537: IF p_int_val_rec.party_id IS NULL THEN
538: x_return_status := fnd_api.g_ret_sts_error;
539: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_PARTY');
540: FND_MESSAGE.SET_TOKEN('PARTY', p_int_val_rec.party_id);
541: FND_MSG_PUB.Add;
542: RETURN;
543: ELSE
544:
545: IF( p_int_val_rec.primary_party_id = fnd_api.g_miss_num) THEN

Line 1512: FND_MSG_PUB.Add;

1508: -- If value is presend then return an error (invalid activity_id)
1509: IF n_Return IS NOT NULL THEN
1510: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_ACTIV_ID');
1511: fnd_message.set_token('VALUE', n_activity_id);
1512: FND_MSG_PUB.Add;
1513: RETURN -1;
1514: END IF;
1515: EXCEPTION
1516: -- If value is not presend then use it for currect activity.

Line 1555: FND_MSG_PUB.Add;

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);
1555: FND_MSG_PUB.Add;
1556: RETURN -1;
1557: END IF;
1558: EXCEPTION
1559: -- If value is not presend then use it for currect activity.

Line 1597: FND_MSG_PUB.Add;

1593: -- If value is presend then return an error (invalid activity_id)
1594: IF n_Return IS NOT NULL THEN
1595: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MEDIA_ID');
1596: FND_MESSAGE.SET_TOKEN('VALUE', n_media_id);
1597: FND_MSG_PUB.Add;
1598: RETURN -1;
1599: END IF;
1600: EXCEPTION
1601: -- If value is not presend then use it for currect activity.

Line 1640: FND_MSG_PUB.Add;

1636: -- If value is presend then return an error (invalid activity_id)
1637: IF n_Return IS NOT NULL THEN
1638: FND_MESSAGE.SET_NAME('JTF','JTF_IH_API_INVALID_MILCS_ID');
1639: FND_MESSAGE.SET_TOKEN('VALUE', n_milcs_id);
1640: FND_MSG_PUB.Add;
1641: RETURN -1;
1642: END IF;
1643: EXCEPTION
1644: -- If value is not presend then use it for currect activity.

Line 1745: fnd_msg_pub.initialize;

1741: END IF;
1742:
1743: -- Initialize message list if p_init_msg_list is set to TRUE
1744: IF fnd_api.to_boolean(p_init_msg_list) THEN
1745: fnd_msg_pub.initialize;
1746: END IF;
1747:
1748: -- Initialize API return status to success
1749: x_return_status := fnd_api.g_ret_sts_success;

Line 2022: fnd_msg_pub.count_and_get

2018: COMMIT WORK;
2019: END IF;
2020:
2021: -- Standard call to get message count and if count is 1, get message info
2022: fnd_msg_pub.count_and_get
2023: ( p_count => x_msg_count,
2024: p_data => x_msg_data );
2025: EXCEPTION
2026: WHEN fnd_api.g_exc_error THEN

Line 2029: fnd_msg_pub.count_and_get

2025: EXCEPTION
2026: WHEN fnd_api.g_exc_error THEN
2027: ROLLBACK TO create_media_pub;
2028: x_return_status := fnd_api.g_ret_sts_error;
2029: fnd_msg_pub.count_and_get
2030: ( p_count => x_msg_count,
2031: p_data => x_msg_data );
2032: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2033:

Line 2032: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2028: x_return_status := fnd_api.g_ret_sts_error;
2029: fnd_msg_pub.count_and_get
2030: ( p_count => x_msg_count,
2031: p_data => x_msg_data );
2032: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2033:
2034: WHEN fnd_api.g_exc_unexpected_error THEN
2035: ROLLBACK TO create_media_pub;
2036: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2037: fnd_msg_pub.count_and_get

2033:
2034: WHEN fnd_api.g_exc_unexpected_error THEN
2035: ROLLBACK TO create_media_pub;
2036: x_return_status := fnd_api.g_ret_sts_unexp_error;
2037: fnd_msg_pub.count_and_get
2038: ( p_count => x_msg_count,
2039: p_data => x_msg_data );
2040: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2041:

Line 2040: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2036: x_return_status := fnd_api.g_ret_sts_unexp_error;
2037: fnd_msg_pub.count_and_get
2038: ( p_count => x_msg_count,
2039: p_data => x_msg_data );
2040: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2041:
2042: WHEN OTHERS THEN
2043: ROLLBACK TO create_media_pub;
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2041:
2042: WHEN OTHERS THEN
2043: ROLLBACK TO create_media_pub;
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2047: END IF;
2048: fnd_msg_pub.count_and_get
2049: ( p_count => x_msg_count,

Line 2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2042: WHEN OTHERS THEN
2043: ROLLBACK TO create_media_pub;
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2047: END IF;
2048: fnd_msg_pub.count_and_get
2049: ( p_count => x_msg_count,
2050: p_data => x_msg_data );

Line 2048: fnd_msg_pub.count_and_get

2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2047: END IF;
2048: fnd_msg_pub.count_and_get
2049: ( p_count => x_msg_count,
2050: p_data => x_msg_data );
2051: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2052:

Line 2051: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2047: END IF;
2048: fnd_msg_pub.count_and_get
2049: ( p_count => x_msg_count,
2050: p_data => x_msg_data );
2051: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2052:
2053: END Create_MediaItem;
2054:
2055: --

Line 2166: fnd_msg_pub.initialize;

2162: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Create_MediaItem');
2163:
2164: -- Initialize message list if p_init_msg_list is set to TRUE
2165: IF fnd_api.to_boolean(p_init_msg_list) THEN
2166: fnd_msg_pub.initialize;
2167: END IF;
2168:
2169: -- Initialize API return status to success
2170: x_return_status := fnd_api.g_ret_sts_success;

Line 2385: fnd_msg_pub.count_and_get

2381: COMMIT WORK;
2382: END IF;
2383:
2384: -- Standard call to get message count and if count is 1, get message info
2385: fnd_msg_pub.count_and_get
2386: ( p_count => x_msg_count,
2387: p_data => x_msg_data );
2388: EXCEPTION
2389: WHEN fnd_api.g_exc_error THEN

Line 2392: fnd_msg_pub.count_and_get

2388: EXCEPTION
2389: WHEN fnd_api.g_exc_error THEN
2390: ROLLBACK TO create_media_pub;
2391: x_return_status := fnd_api.g_ret_sts_error;
2392: fnd_msg_pub.count_and_get
2393: ( p_count => x_msg_count,
2394: p_data => x_msg_data );
2395: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2396: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2395: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2391: x_return_status := fnd_api.g_ret_sts_error;
2392: fnd_msg_pub.count_and_get
2393: ( p_count => x_msg_count,
2394: p_data => x_msg_data );
2395: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2396: WHEN fnd_api.g_exc_unexpected_error THEN
2397: ROLLBACK TO create_media_pub;
2398: x_return_status := fnd_api.g_ret_sts_unexp_error;
2399: fnd_msg_pub.count_and_get

Line 2399: fnd_msg_pub.count_and_get

2395: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2396: WHEN fnd_api.g_exc_unexpected_error THEN
2397: ROLLBACK TO create_media_pub;
2398: x_return_status := fnd_api.g_ret_sts_unexp_error;
2399: fnd_msg_pub.count_and_get
2400: ( p_count => x_msg_count,
2401: p_data => x_msg_data );
2402: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2403: WHEN OTHERS THEN

Line 2402: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2398: x_return_status := fnd_api.g_ret_sts_unexp_error;
2399: fnd_msg_pub.count_and_get
2400: ( p_count => x_msg_count,
2401: p_data => x_msg_data );
2402: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2403: WHEN OTHERS THEN
2404: ROLLBACK TO create_media_pub;
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2402: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2403: WHEN OTHERS THEN
2404: ROLLBACK TO create_media_pub;
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2408: END IF;
2409: fnd_msg_pub.count_and_get
2410: ( p_count => x_msg_count,

Line 2407: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2403: WHEN OTHERS THEN
2404: ROLLBACK TO create_media_pub;
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2408: END IF;
2409: fnd_msg_pub.count_and_get
2410: ( p_count => x_msg_count,
2411: p_data => x_msg_data );

Line 2409: fnd_msg_pub.count_and_get

2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2408: END IF;
2409: fnd_msg_pub.count_and_get
2410: ( p_count => x_msg_count,
2411: p_data => x_msg_data );
2412: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2413: END Create_MediaItem;

Line 2412: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2408: END IF;
2409: fnd_msg_pub.count_and_get
2410: ( p_count => x_msg_count,
2411: p_data => x_msg_data );
2412: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2413: END Create_MediaItem;
2414:
2415:
2416: --

Line 2511: fnd_msg_pub.initialize;

2507: END IF;
2508: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Create_MediaLifecycle');
2509: -- Initialize message list if p_init_msg_list is set to TRUE
2510: IF fnd_api.to_boolean(p_init_msg_list) THEN
2511: fnd_msg_pub.initialize;
2512: END IF;
2513:
2514: -- Initialize API return status to success
2515: x_return_status := fnd_api.g_ret_sts_success;

Line 2692: fnd_msg_pub.count_and_get

2688: COMMIT WORK;
2689: END IF;
2690:
2691: -- Standard call to get message count and if count is 1, get message info
2692: fnd_msg_pub.count_and_get
2693: ( p_count => x_msg_count,
2694: p_data => x_msg_data );
2695: EXCEPTION
2696: WHEN fnd_api.g_exc_error THEN

Line 2699: fnd_msg_pub.count_and_get

2695: EXCEPTION
2696: WHEN fnd_api.g_exc_error THEN
2697: ROLLBACK TO create_media_lc_pub;
2698: x_return_status := fnd_api.g_ret_sts_error;
2699: fnd_msg_pub.count_and_get
2700: ( p_encoded => FND_API.g_false,
2701: p_count => x_msg_count,
2702: p_data => x_msg_data );
2703: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

Line 2703: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2699: fnd_msg_pub.count_and_get
2700: ( p_encoded => FND_API.g_false,
2701: p_count => x_msg_count,
2702: p_data => x_msg_data );
2703: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2704: WHEN fnd_api.g_exc_unexpected_error THEN
2705: ROLLBACK TO create_media_lc_pub;
2706: x_return_status := fnd_api.g_ret_sts_unexp_error;
2707: fnd_msg_pub.count_and_get

Line 2707: fnd_msg_pub.count_and_get

2703: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2704: WHEN fnd_api.g_exc_unexpected_error THEN
2705: ROLLBACK TO create_media_lc_pub;
2706: x_return_status := fnd_api.g_ret_sts_unexp_error;
2707: fnd_msg_pub.count_and_get
2708: ( p_encoded => FND_API.g_false,
2709: p_count => x_msg_count,
2710: p_data => x_msg_data );
2711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

Line 2711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2707: fnd_msg_pub.count_and_get
2708: ( p_encoded => FND_API.g_false,
2709: p_count => x_msg_count,
2710: p_data => x_msg_data );
2711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2712: WHEN OTHERS THEN
2713: ROLLBACK TO create_media_lc_pub;
2714: x_return_status := fnd_api.g_ret_sts_unexp_error;
2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2712: WHEN OTHERS THEN
2713: ROLLBACK TO create_media_lc_pub;
2714: x_return_status := fnd_api.g_ret_sts_unexp_error;
2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2717: END IF;
2718: fnd_msg_pub.count_and_get
2719: ( p_encoded => FND_API.g_false,

Line 2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

2712: WHEN OTHERS THEN
2713: ROLLBACK TO create_media_lc_pub;
2714: x_return_status := fnd_api.g_ret_sts_unexp_error;
2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2717: END IF;
2718: fnd_msg_pub.count_and_get
2719: ( p_encoded => FND_API.g_false,
2720: p_count => x_msg_count,

Line 2718: fnd_msg_pub.count_and_get

2714: x_return_status := fnd_api.g_ret_sts_unexp_error;
2715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2716: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2717: END IF;
2718: fnd_msg_pub.count_and_get
2719: ( p_encoded => FND_API.g_false,
2720: p_count => x_msg_count,
2721: p_data => x_msg_data );
2722: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

Line 2722: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

2718: fnd_msg_pub.count_and_get
2719: ( p_encoded => FND_API.g_false,
2720: p_count => x_msg_count,
2721: p_data => x_msg_data );
2722: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
2723: END Create_MediaLifecycle;
2724:
2725: --
2726: -- HISTORY

Line 2803: FND_MSG_PUB.Add;

2799: --l_activities_hk := p_activities;
2800:
2801: IF l_activities.count = 0 THEN
2802: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_ACTIVITY');
2803: FND_MSG_PUB.Add;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END IF;
2806:
2807: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'CREATE_INTERACTION', 'B', 'C') THEN

Line 2849: fnd_msg_pub.initialize;

2845: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Create_Interaction');
2846:
2847: -- Initialize message list if p_init_msg_list is set to TRUE
2848: IF fnd_api.to_boolean(p_init_msg_list) THEN
2849: fnd_msg_pub.initialize;
2850: END IF;
2851:
2852: -- Initialize API return status to success
2853: x_return_status := fnd_api.g_ret_sts_success;

Line 3317: fnd_msg_pub.count_and_get

3313: COMMIT WORK;
3314: END IF;
3315:
3316: -- Standard call to get message count and if count is 1, get message info
3317: fnd_msg_pub.count_and_get
3318: ( p_count => x_msg_count,
3319: p_data => x_msg_data );
3320:
3321: EXCEPTION

Line 3325: fnd_msg_pub.count_and_get

3321: EXCEPTION
3322: WHEN fnd_api.g_exc_error THEN
3323: ROLLBACK TO create_interaction_pub;
3324: x_return_status := fnd_api.g_ret_sts_error;
3325: fnd_msg_pub.count_and_get
3326: ( p_count => x_msg_count,
3327: p_data => x_msg_data );
3328: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3329:

Line 3328: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3324: x_return_status := fnd_api.g_ret_sts_error;
3325: fnd_msg_pub.count_and_get
3326: ( p_count => x_msg_count,
3327: p_data => x_msg_data );
3328: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3329:
3330: WHEN fnd_api.g_exc_unexpected_error THEN
3331: ROLLBACK TO create_interaction_pub;
3332: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3333: fnd_msg_pub.count_and_get

3329:
3330: WHEN fnd_api.g_exc_unexpected_error THEN
3331: ROLLBACK TO create_interaction_pub;
3332: x_return_status := fnd_api.g_ret_sts_unexp_error;
3333: fnd_msg_pub.count_and_get
3334: ( p_count => x_msg_count,
3335: p_data => x_msg_data );
3336: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3337:

Line 3336: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3332: x_return_status := fnd_api.g_ret_sts_unexp_error;
3333: fnd_msg_pub.count_and_get
3334: ( p_count => x_msg_count,
3335: p_data => x_msg_data );
3336: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3337:
3338: WHEN OTHERS THEN
3339: ROLLBACK TO create_interaction_pub;
3340: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3337:
3338: WHEN OTHERS THEN
3339: ROLLBACK TO create_interaction_pub;
3340: x_return_status := fnd_api.g_ret_sts_unexp_error;
3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3342: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3343: END IF;
3344: fnd_msg_pub.count_and_get
3345: ( p_count => x_msg_count,

Line 3342: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3338: WHEN OTHERS THEN
3339: ROLLBACK TO create_interaction_pub;
3340: x_return_status := fnd_api.g_ret_sts_unexp_error;
3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3342: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3343: END IF;
3344: fnd_msg_pub.count_and_get
3345: ( p_count => x_msg_count,
3346: p_data => x_msg_data );

Line 3344: fnd_msg_pub.count_and_get

3340: x_return_status := fnd_api.g_ret_sts_unexp_error;
3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3342: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3343: END IF;
3344: fnd_msg_pub.count_and_get
3345: ( p_count => x_msg_count,
3346: p_data => x_msg_data );
3347: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3348: END Create_Interaction;

Line 3347: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3343: END IF;
3344: fnd_msg_pub.count_and_get
3345: ( p_count => x_msg_count,
3346: p_data => x_msg_data );
3347: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3348: END Create_Interaction;
3349:
3350:
3351: --

Line 3442: fnd_msg_pub.initialize;

3438: END IF;
3439:
3440: -- Initialize message list if p_init_msg_list is set to TRUE
3441: IF fnd_api.to_boolean(p_init_msg_list) THEN
3442: fnd_msg_pub.initialize;
3443: END IF;
3444:
3445: -- Initialize API return status to success
3446: x_return_status := fnd_api.g_ret_sts_success;

Line 3696: fnd_msg_pub.count_and_get

3692: END IF;
3693: END IF;
3694:
3695: -- Standard call to get message count and if count is 1, get message info
3696: fnd_msg_pub.count_and_get
3697: ( p_count => x_msg_count,
3698: p_data => x_msg_data );
3699: EXCEPTION
3700: WHEN fnd_api.g_exc_error THEN

Line 3702: fnd_msg_pub.count_and_get

3698: p_data => x_msg_data );
3699: EXCEPTION
3700: WHEN fnd_api.g_exc_error THEN
3701: x_return_status := fnd_api.g_ret_sts_error;
3702: fnd_msg_pub.count_and_get
3703: ( p_count => x_msg_count,
3704: p_data => x_msg_data );
3705: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3706: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3705: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3701: x_return_status := fnd_api.g_ret_sts_error;
3702: fnd_msg_pub.count_and_get
3703: ( p_count => x_msg_count,
3704: p_data => x_msg_data );
3705: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3706: WHEN fnd_api.g_exc_unexpected_error THEN
3707: x_return_status := fnd_api.g_ret_sts_unexp_error;
3708: fnd_msg_pub.count_and_get
3709: ( p_count => x_msg_count,

Line 3708: fnd_msg_pub.count_and_get

3704: p_data => x_msg_data );
3705: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3706: WHEN fnd_api.g_exc_unexpected_error THEN
3707: x_return_status := fnd_api.g_ret_sts_unexp_error;
3708: fnd_msg_pub.count_and_get
3709: ( p_count => x_msg_count,
3710: p_data => x_msg_data );
3711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3712: WHEN OTHERS THEN

Line 3711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3707: x_return_status := fnd_api.g_ret_sts_unexp_error;
3708: fnd_msg_pub.count_and_get
3709: ( p_count => x_msg_count,
3710: p_data => x_msg_data );
3711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3712: WHEN OTHERS THEN
3713: x_return_status := fnd_api.g_ret_sts_unexp_error;
3714: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3715: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3714: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3710: p_data => x_msg_data );
3711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3712: WHEN OTHERS THEN
3713: x_return_status := fnd_api.g_ret_sts_unexp_error;
3714: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3715: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3716: END IF;
3717: fnd_msg_pub.count_and_get
3718: ( p_count => x_msg_count,

Line 3715: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3711: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3712: WHEN OTHERS THEN
3713: x_return_status := fnd_api.g_ret_sts_unexp_error;
3714: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3715: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3716: END IF;
3717: fnd_msg_pub.count_and_get
3718: ( p_count => x_msg_count,
3719: p_data => x_msg_data );

Line 3717: fnd_msg_pub.count_and_get

3713: x_return_status := fnd_api.g_ret_sts_unexp_error;
3714: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3715: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3716: END IF;
3717: fnd_msg_pub.count_and_get
3718: ( p_count => x_msg_count,
3719: p_data => x_msg_data );
3720: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3721: END Get_InteractionActivityCount;

Line 3720: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3716: END IF;
3717: fnd_msg_pub.count_and_get
3718: ( p_count => x_msg_count,
3719: p_data => x_msg_data );
3720: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3721: END Get_InteractionActivityCount;
3722:
3723: --
3724: -- HISTORY

Line 3818: fnd_msg_pub.initialize;

3814: END IF;
3815:
3816: -- Initialize message list if p_init_msg_list is set to TRUE
3817: IF fnd_api.to_boolean(p_init_msg_list) THEN
3818: fnd_msg_pub.initialize;
3819: END IF;
3820:
3821: -- Initialize API return status to success
3822: x_return_status := fnd_api.g_ret_sts_success;

Line 3900: fnd_msg_pub.count_and_get

3896: END IF;
3897: END IF;
3898:
3899: -- Standard call to get message count and if count is 1, get message info
3900: fnd_msg_pub.count_and_get
3901: ( p_count => x_msg_count,
3902: p_data => x_msg_data );
3903: EXCEPTION
3904: WHEN fnd_api.g_exc_error THEN

Line 3906: fnd_msg_pub.count_and_get

3902: p_data => x_msg_data );
3903: EXCEPTION
3904: WHEN fnd_api.g_exc_error THEN
3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get
3907: ( p_count => x_msg_count,
3908: p_data => x_msg_data );
3909: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3910: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3909: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get
3907: ( p_count => x_msg_count,
3908: p_data => x_msg_data );
3909: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3910: WHEN fnd_api.g_exc_unexpected_error THEN
3911: x_return_status := fnd_api.g_ret_sts_unexp_error;
3912: fnd_msg_pub.count_and_get
3913: ( p_count => x_msg_count,

Line 3912: fnd_msg_pub.count_and_get

3908: p_data => x_msg_data );
3909: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3910: WHEN fnd_api.g_exc_unexpected_error THEN
3911: x_return_status := fnd_api.g_ret_sts_unexp_error;
3912: fnd_msg_pub.count_and_get
3913: ( p_count => x_msg_count,
3914: p_data => x_msg_data );
3915: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3916: WHEN OTHERS THEN

Line 3915: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3911: x_return_status := fnd_api.g_ret_sts_unexp_error;
3912: fnd_msg_pub.count_and_get
3913: ( p_count => x_msg_count,
3914: p_data => x_msg_data );
3915: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3916: WHEN OTHERS THEN
3917: x_return_status := fnd_api.g_ret_sts_unexp_error;
3918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3919: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3914: p_data => x_msg_data );
3915: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3916: WHEN OTHERS THEN
3917: x_return_status := fnd_api.g_ret_sts_unexp_error;
3918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3919: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3920: END IF;
3921: fnd_msg_pub.count_and_get
3922: ( p_count => x_msg_count,

Line 3919: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3915: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3916: WHEN OTHERS THEN
3917: x_return_status := fnd_api.g_ret_sts_unexp_error;
3918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3919: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3920: END IF;
3921: fnd_msg_pub.count_and_get
3922: ( p_count => x_msg_count,
3923: p_data => x_msg_data );

Line 3921: fnd_msg_pub.count_and_get

3917: x_return_status := fnd_api.g_ret_sts_unexp_error;
3918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3919: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3920: END IF;
3921: fnd_msg_pub.count_and_get
3922: ( p_count => x_msg_count,
3923: p_data => x_msg_data );
3924: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3925: END Get_InteractionCount;

Line 3924: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

3920: END IF;
3921: fnd_msg_pub.count_and_get
3922: ( p_count => x_msg_count,
3923: p_data => x_msg_data );
3924: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
3925: END Get_InteractionCount;
3926: --
3927: -- HISTORY
3928: --

Line 4027: fnd_msg_pub.initialize;

4023: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Open_Interaction');
4024:
4025: -- Initialize message list if p_init_msg_list is set to TRUE
4026: IF fnd_api.to_boolean(p_init_msg_list) THEN
4027: fnd_msg_pub.initialize;
4028: END IF;
4029:
4030: -- Initialize API return status to success
4031: x_return_status := fnd_api.g_ret_sts_success;

Line 4130: fnd_msg_pub.count_and_get

4126: x_return_status := fnd_api.g_ret_sts_error;
4127: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,
4128: to_char(p_interaction_rec.non_productive_time_amount),'non_productive_time_amount');
4129: -- # 1937894
4130: fnd_msg_pub.count_and_get
4131: ( p_count => x_msg_count,
4132: p_data => x_msg_data );
4133: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4134: RETURN;

Line 4133: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

4129: -- # 1937894
4130: fnd_msg_pub.count_and_get
4131: ( p_count => x_msg_count,
4132: p_data => x_msg_data );
4133: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4134: RETURN;
4135: END IF;
4136: ELSE
4137: --l_productive_time_amount := l_duration;

Line 4336: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

4332: COMMIT WORK;
4333: END IF;
4334:
4335: -- Standard call to get message count and if count is 1, get message info
4336: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
4337: EXCEPTION
4338: WHEN fnd_api.g_exc_error THEN
4339: ROLLBACK TO open_interaction_pub;
4340: x_return_status := fnd_api.g_ret_sts_error;

Line 4341: fnd_msg_pub.count_and_get

4337: EXCEPTION
4338: WHEN fnd_api.g_exc_error THEN
4339: ROLLBACK TO open_interaction_pub;
4340: x_return_status := fnd_api.g_ret_sts_error;
4341: fnd_msg_pub.count_and_get
4342: ( p_count => x_msg_count,
4343: p_data => x_msg_data );
4344: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4345: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4344: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

4340: x_return_status := fnd_api.g_ret_sts_error;
4341: fnd_msg_pub.count_and_get
4342: ( p_count => x_msg_count,
4343: p_data => x_msg_data );
4344: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4345: WHEN fnd_api.g_exc_unexpected_error THEN
4346: ROLLBACK TO open_interaction_pub;
4347: x_return_status := fnd_api.g_ret_sts_unexp_error;
4348: fnd_msg_pub.count_and_get

Line 4348: fnd_msg_pub.count_and_get

4344: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4345: WHEN fnd_api.g_exc_unexpected_error THEN
4346: ROLLBACK TO open_interaction_pub;
4347: x_return_status := fnd_api.g_ret_sts_unexp_error;
4348: fnd_msg_pub.count_and_get
4349: ( p_count => x_msg_count,
4350: p_data => x_msg_data );
4351: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4352: WHEN OTHERS THEN

Line 4351: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

4347: x_return_status := fnd_api.g_ret_sts_unexp_error;
4348: fnd_msg_pub.count_and_get
4349: ( p_count => x_msg_count,
4350: p_data => x_msg_data );
4351: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4352: WHEN OTHERS THEN
4353: ROLLBACK TO open_interaction_pub;
4354: x_return_status := fnd_api.g_ret_sts_unexp_error;
4355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4351: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4352: WHEN OTHERS THEN
4353: ROLLBACK TO open_interaction_pub;
4354: x_return_status := fnd_api.g_ret_sts_unexp_error;
4355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4356: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4357: END IF;
4358: fnd_msg_pub.count_and_get
4359: ( p_count => x_msg_count,

Line 4356: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

4352: WHEN OTHERS THEN
4353: ROLLBACK TO open_interaction_pub;
4354: x_return_status := fnd_api.g_ret_sts_unexp_error;
4355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4356: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4357: END IF;
4358: fnd_msg_pub.count_and_get
4359: ( p_count => x_msg_count,
4360: p_data => x_msg_data );

Line 4358: fnd_msg_pub.count_and_get

4354: x_return_status := fnd_api.g_ret_sts_unexp_error;
4355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4356: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4357: END IF;
4358: fnd_msg_pub.count_and_get
4359: ( p_count => x_msg_count,
4360: p_data => x_msg_data );
4361: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4362: END Open_Interaction;

Line 4361: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

4357: END IF;
4358: fnd_msg_pub.count_and_get
4359: ( p_count => x_msg_count,
4360: p_data => x_msg_data );
4361: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4362: END Open_Interaction;
4363:
4364: --
4365: --

Line 4508: fnd_msg_pub.initialize;

4504: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Update_Interaction');
4505:
4506: -- Initialize message list if p_init_msg_list is set to TRUE
4507: IF fnd_api.to_boolean(p_init_msg_list) THEN
4508: fnd_msg_pub.initialize;
4509: END IF;
4510:
4511: -- Initialize API return status to success
4512: x_return_status := fnd_api.g_ret_sts_success;

Line 4560: fnd_msg_pub.count_and_get

4556: x_return_status := fnd_api.g_ret_sts_error;
4557: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),
4558: 'Interaction_id');
4559: -- # 1937894
4560: fnd_msg_pub.count_and_get
4561: ( p_count => x_msg_count,
4562: p_data => x_msg_data );
4563: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4564: RETURN;

Line 4563: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

4559: -- # 1937894
4560: fnd_msg_pub.count_and_get
4561: ( p_count => x_msg_count,
4562: p_data => x_msg_data );
4563: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
4564: RETURN;
4565: END IF;
4566:
4567: --

Line 4587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

4583: IF nvl(l_profile_id,'N') <> 'Y' THEN
4584: --x_return_status := fnd_api.g_ret_sts_error;
4585: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_Interaction_rec.interaction_id),'Active set to N for interaction');
4586: --Bug# 4477761 new error msg
4587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4588: fnd_message.set_name('JTF', 'JTF_IH_INT_UPDATE_NOT_ALLOW');
4589: fnd_message.set_token('INT_ID', to_char(p_Interaction_rec.interaction_id));
4590: fnd_msg_pub.add;
4591: END IF;

Line 4590: fnd_msg_pub.add;

4586: --Bug# 4477761 new error msg
4587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4588: fnd_message.set_name('JTF', 'JTF_IH_INT_UPDATE_NOT_ALLOW');
4589: fnd_message.set_token('INT_ID', to_char(p_Interaction_rec.interaction_id));
4590: fnd_msg_pub.add;
4591: END IF;
4592: RAISE fnd_api.g_exc_error;
4593: END IF;
4594: END IF;

Line 5153: fnd_msg_pub.count_and_get

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),
5151: 'interaction_id');
5152: -- # 1937894
5153: fnd_msg_pub.count_and_get
5154: ( p_count => x_msg_count,
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;

Line 5156: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5152: -- # 1937894
5153: fnd_msg_pub.count_and_get
5154: ( p_count => x_msg_count,
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

Line 5255: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

5251: COMMIT WORK;
5252: END IF;
5253:
5254: -- Standard call to get message count and if count is 1, get message info
5255: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
5256:
5257: EXCEPTION
5258: WHEN fnd_api.g_exc_error THEN
5259: ROLLBACK TO update_interaction_pub;

Line 5261: fnd_msg_pub.count_and_get

5257: EXCEPTION
5258: WHEN fnd_api.g_exc_error THEN
5259: ROLLBACK TO update_interaction_pub;
5260: x_return_status := fnd_api.g_ret_sts_error;
5261: fnd_msg_pub.count_and_get
5262: ( p_count => x_msg_count,
5263: p_data => x_msg_data );
5264: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5265: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5264: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5260: x_return_status := fnd_api.g_ret_sts_error;
5261: fnd_msg_pub.count_and_get
5262: ( p_count => x_msg_count,
5263: p_data => x_msg_data );
5264: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5265: WHEN fnd_api.g_exc_unexpected_error THEN
5266: ROLLBACK TO update_interaction_pub;
5267: x_return_status := fnd_api.g_ret_sts_unexp_error;
5268: fnd_msg_pub.count_and_get

Line 5268: fnd_msg_pub.count_and_get

5264: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5265: WHEN fnd_api.g_exc_unexpected_error THEN
5266: ROLLBACK TO update_interaction_pub;
5267: x_return_status := fnd_api.g_ret_sts_unexp_error;
5268: fnd_msg_pub.count_and_get
5269: ( p_count => x_msg_count,
5270: p_data => x_msg_data );
5271: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5272: WHEN OTHERS THEN

Line 5271: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5267: x_return_status := fnd_api.g_ret_sts_unexp_error;
5268: fnd_msg_pub.count_and_get
5269: ( p_count => x_msg_count,
5270: p_data => x_msg_data );
5271: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5272: WHEN OTHERS THEN
5273: ROLLBACK TO update_interaction_pub;
5274: x_return_status := fnd_api.g_ret_sts_unexp_error;
5275: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 5275: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

5271: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5272: WHEN OTHERS THEN
5273: ROLLBACK TO update_interaction_pub;
5274: x_return_status := fnd_api.g_ret_sts_unexp_error;
5275: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5276: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5277: END IF;
5278: fnd_msg_pub.count_and_get
5279: ( p_count => x_msg_count,

Line 5276: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

5272: WHEN OTHERS THEN
5273: ROLLBACK TO update_interaction_pub;
5274: x_return_status := fnd_api.g_ret_sts_unexp_error;
5275: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5276: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5277: END IF;
5278: fnd_msg_pub.count_and_get
5279: ( p_count => x_msg_count,
5280: p_data => x_msg_data );

Line 5278: fnd_msg_pub.count_and_get

5274: x_return_status := fnd_api.g_ret_sts_unexp_error;
5275: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5276: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5277: END IF;
5278: fnd_msg_pub.count_and_get
5279: ( p_count => x_msg_count,
5280: p_data => x_msg_data );
5281: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5282: END Update_Interaction;

Line 5281: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5277: END IF;
5278: fnd_msg_pub.count_and_get
5279: ( p_count => x_msg_count,
5280: p_data => x_msg_data );
5281: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5282: END Update_Interaction;
5283:
5284: --
5285: --

Line 5395: fnd_msg_pub.initialize;

5391: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Close_Interaction');
5392:
5393: -- Initialize message list if p_init_msg_list is set to TRUE
5394: IF fnd_api.to_boolean(p_init_msg_list) THEN
5395: fnd_msg_pub.initialize;
5396: END IF;
5397:
5398: -- Initialize API return status to success
5399: x_return_status := fnd_api.g_ret_sts_success;

Line 5432: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

5428: -- DBMS_OUTPUT.PUT_LINE('x_return_status = ' || x_return_status);
5429: -- Bug# 1937894
5430: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name, to_char(p_interaction_rec.interaction_id),
5431: -- 'activity_id');
5432: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
5433: fnd_message.set_name('JTF', 'JTF_IH_NO_ACTIVITY');
5434: fnd_message.set_token('API_NAME', l_api_name);
5435: fnd_msg_pub.add;
5436: END IF;

Line 5435: fnd_msg_pub.add;

5431: -- 'activity_id');
5432: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
5433: fnd_message.set_name('JTF', 'JTF_IH_NO_ACTIVITY');
5434: fnd_message.set_token('API_NAME', l_api_name);
5435: fnd_msg_pub.add;
5436: END IF;
5437:
5438: -- DBMS_OUTPUT.PUT_LINE('Yes');
5439: fnd_msg_pub.count_and_get

Line 5439: fnd_msg_pub.count_and_get

5435: fnd_msg_pub.add;
5436: END IF;
5437:
5438: -- DBMS_OUTPUT.PUT_LINE('Yes');
5439: fnd_msg_pub.count_and_get
5440: ( p_count => x_msg_count,
5441: p_data => x_msg_data );
5442: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5443:

Line 5442: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5438: -- DBMS_OUTPUT.PUT_LINE('Yes');
5439: fnd_msg_pub.count_and_get
5440: ( p_count => x_msg_count,
5441: p_data => x_msg_data );
5442: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5443:
5444: RETURN;
5445: END IF;
5446:

Line 5482: fnd_msg_pub.count_and_get

5478: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),
5479: 'outcome_id');
5480: -- # 1937894
5481: --
5482: fnd_msg_pub.count_and_get
5483: ( p_count => x_msg_count,
5484: p_data => x_msg_data );
5485: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5486: RETURN;

Line 5485: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5481: --
5482: fnd_msg_pub.count_and_get
5483: ( p_count => x_msg_count,
5484: p_data => x_msg_data );
5485: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5486: RETURN;
5487: END IF;
5488:
5489: SELECT end_date_time, start_date_time, duration

Line 5574: fnd_msg_pub.count_and_get

5570: -- Bug# 3779487 added by nchouras 4-AUG-2004
5571: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,
5572: la_out_act_list);
5573:
5574: fnd_msg_pub.count_and_get
5575: ( p_count => x_msg_count,
5576: p_data => x_msg_data );
5577: RETURN;
5578: END IF;

Line 5624: fnd_msg_pub.count_and_get

5620: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
5621: 'outcome_id');
5622: -- # 1937894
5623: --
5624: fnd_msg_pub.count_and_get
5625: ( p_count => x_msg_count,
5626: p_data => x_msg_data );
5627: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5628: RETURN;

Line 5627: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5623: --
5624: fnd_msg_pub.count_and_get
5625: ( p_count => x_msg_count,
5626: p_data => x_msg_data );
5627: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5628: RETURN;
5629: END IF;
5630:
5631: IF (l_action_item_id IS NULL) THEN

Line 5636: fnd_msg_pub.count_and_get

5632: x_return_status := fnd_api.g_ret_sts_error;
5633: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_action_item_id),
5634: 'action_item_id');
5635: -- # 2281489
5636: fnd_msg_pub.count_and_get
5637: ( p_count => x_msg_count,
5638: p_data => x_msg_data );
5639: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5640: RETURN;

Line 5639: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5635: -- # 2281489
5636: fnd_msg_pub.count_and_get
5637: ( p_count => x_msg_count,
5638: p_data => x_msg_data );
5639: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5640: RETURN;
5641: END IF;
5642:
5643: SELECT end_date_time, outcome_id

Line 5653: fnd_msg_pub.count_and_get

5649: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_interaction_rec.outcome_id),
5650: 'outcome_id');
5651: -- Bug# 1937894
5652: --
5653: fnd_msg_pub.count_and_get
5654: ( p_count => x_msg_count,
5655: p_data => x_msg_data );
5656: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5657: RETURN;

Line 5656: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5652: --
5653: fnd_msg_pub.count_and_get
5654: ( p_count => x_msg_count,
5655: p_data => x_msg_data );
5656: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5657: RETURN;
5658: END IF;
5659:
5660: IF(l_end_date_time IS NULL) or (l_end_date_time = fnd_api.g_miss_date) THEN

Line 5716: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

5712: IF fnd_api.to_boolean(p_commit) THEN
5713: COMMIT WORK;
5714: END IF;
5715: -- Standard call to get message count and if count is 1, get message info
5716: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
5717: EXCEPTION
5718: WHEN fnd_api.g_exc_error THEN
5719: ROLLBACK TO close_interaction_pub1;
5720: x_return_status := fnd_api.g_ret_sts_error;

Line 5721: fnd_msg_pub.count_and_get

5717: EXCEPTION
5718: WHEN fnd_api.g_exc_error THEN
5719: ROLLBACK TO close_interaction_pub1;
5720: x_return_status := fnd_api.g_ret_sts_error;
5721: fnd_msg_pub.count_and_get
5722: ( p_count => x_msg_count,
5723: p_data => x_msg_data );
5724: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5725: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5724: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5720: x_return_status := fnd_api.g_ret_sts_error;
5721: fnd_msg_pub.count_and_get
5722: ( p_count => x_msg_count,
5723: p_data => x_msg_data );
5724: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5725: WHEN fnd_api.g_exc_unexpected_error THEN
5726: ROLLBACK TO close_interaction_pub1;
5727: x_return_status := fnd_api.g_ret_sts_unexp_error;
5728: fnd_msg_pub.count_and_get

Line 5728: fnd_msg_pub.count_and_get

5724: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5725: WHEN fnd_api.g_exc_unexpected_error THEN
5726: ROLLBACK TO close_interaction_pub1;
5727: x_return_status := fnd_api.g_ret_sts_unexp_error;
5728: fnd_msg_pub.count_and_get
5729: ( p_count => x_msg_count,
5730: p_data => x_msg_data );
5731: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5732: WHEN OTHERS THEN

Line 5731: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5727: x_return_status := fnd_api.g_ret_sts_unexp_error;
5728: fnd_msg_pub.count_and_get
5729: ( p_count => x_msg_count,
5730: p_data => x_msg_data );
5731: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5732: WHEN OTHERS THEN
5733: ROLLBACK TO close_interaction_pub1;
5734: x_return_status := fnd_api.g_ret_sts_unexp_error;
5735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 5735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

5731: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5732: WHEN OTHERS THEN
5733: ROLLBACK TO close_interaction_pub1;
5734: x_return_status := fnd_api.g_ret_sts_unexp_error;
5735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5736: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5737: END IF;
5738: fnd_msg_pub.count_and_get
5739: ( p_count => x_msg_count,

Line 5736: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

5732: WHEN OTHERS THEN
5733: ROLLBACK TO close_interaction_pub1;
5734: x_return_status := fnd_api.g_ret_sts_unexp_error;
5735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5736: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5737: END IF;
5738: fnd_msg_pub.count_and_get
5739: ( p_count => x_msg_count,
5740: p_data => x_msg_data );

Line 5738: fnd_msg_pub.count_and_get

5734: x_return_status := fnd_api.g_ret_sts_unexp_error;
5735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5736: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5737: END IF;
5738: fnd_msg_pub.count_and_get
5739: ( p_count => x_msg_count,
5740: p_data => x_msg_data );
5741: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5742:

Line 5741: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

5737: END IF;
5738: fnd_msg_pub.count_and_get
5739: ( p_count => x_msg_count,
5740: p_data => x_msg_data );
5741: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
5742:
5743: END Close_Interaction;
5744:
5745: --

Line 5841: fnd_msg_pub.initialize;

5837: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Add_Activity');
5838:
5839: -- Initialize message list if p_init_msg_list is set to TRUE
5840: IF fnd_api.to_boolean(p_init_msg_list) THEN
5841: fnd_msg_pub.initialize;
5842: END IF;
5843:
5844: -- Initialize API return status to success
5845: x_return_status := fnd_api.g_ret_sts_success;

Line 6116: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

6112: COMMIT WORK;
6113: END IF;
6114:
6115: -- Standard call to get message count and if count is 1, get message info
6116: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
6117: EXCEPTION
6118: WHEN fnd_api.g_exc_error THEN
6119: ROLLBACK TO add_activity_pub;
6120: x_return_status := fnd_api.g_ret_sts_error;

Line 6121: fnd_msg_pub.count_and_get

6117: EXCEPTION
6118: WHEN fnd_api.g_exc_error THEN
6119: ROLLBACK TO add_activity_pub;
6120: x_return_status := fnd_api.g_ret_sts_error;
6121: fnd_msg_pub.count_and_get
6122: ( p_count => x_msg_count,
6123: p_data => x_msg_data );
6124: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6125: WHEN fnd_api.g_exc_unexpected_error THEN

Line 6124: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

6120: x_return_status := fnd_api.g_ret_sts_error;
6121: fnd_msg_pub.count_and_get
6122: ( p_count => x_msg_count,
6123: p_data => x_msg_data );
6124: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6125: WHEN fnd_api.g_exc_unexpected_error THEN
6126: ROLLBACK TO add_activity_pub;
6127: x_return_status := fnd_api.g_ret_sts_unexp_error;
6128: fnd_msg_pub.count_and_get

Line 6128: fnd_msg_pub.count_and_get

6124: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6125: WHEN fnd_api.g_exc_unexpected_error THEN
6126: ROLLBACK TO add_activity_pub;
6127: x_return_status := fnd_api.g_ret_sts_unexp_error;
6128: fnd_msg_pub.count_and_get
6129: ( p_count => x_msg_count,
6130: p_data => x_msg_data );
6131: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6132: WHEN OTHERS THEN

Line 6131: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

6127: x_return_status := fnd_api.g_ret_sts_unexp_error;
6128: fnd_msg_pub.count_and_get
6129: ( p_count => x_msg_count,
6130: p_data => x_msg_data );
6131: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6132: WHEN OTHERS THEN
6133: ROLLBACK TO add_activity_pub;
6134: x_return_status := fnd_api.g_ret_sts_unexp_error;
6135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 6135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6131: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6132: WHEN OTHERS THEN
6133: ROLLBACK TO add_activity_pub;
6134: x_return_status := fnd_api.g_ret_sts_unexp_error;
6135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6136: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6137: END IF;
6138: fnd_msg_pub.count_and_get
6139: ( p_count => x_msg_count,

Line 6136: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

6132: WHEN OTHERS THEN
6133: ROLLBACK TO add_activity_pub;
6134: x_return_status := fnd_api.g_ret_sts_unexp_error;
6135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6136: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6137: END IF;
6138: fnd_msg_pub.count_and_get
6139: ( p_count => x_msg_count,
6140: p_data => x_msg_data );

Line 6138: fnd_msg_pub.count_and_get

6134: x_return_status := fnd_api.g_ret_sts_unexp_error;
6135: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6136: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6137: END IF;
6138: fnd_msg_pub.count_and_get
6139: ( p_count => x_msg_count,
6140: p_data => x_msg_data );
6141: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6142: END Add_Activity;

Line 6141: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

6137: END IF;
6138: fnd_msg_pub.count_and_get
6139: ( p_count => x_msg_count,
6140: p_data => x_msg_data );
6141: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6142: END Add_Activity;
6143:
6144:
6145: --

Line 6289: fnd_msg_pub.initialize;

6285: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Update_Activity');
6286:
6287: -- Initialize message list if p_init_msg_list is set to TRUE
6288: IF fnd_api.to_boolean(p_init_msg_list) THEN
6289: fnd_msg_pub.initialize;
6290: END IF;
6291:
6292: -- Initialize API return status to success
6293: x_return_status := fnd_api.g_ret_sts_success;

Line 6819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

6815: ELSE
6816: --jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(p_activity_rec.activity_id),
6817: -- 'activity is currently set to N');
6818: --Bug# 4477761 new error msg
6819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6820: fnd_message.set_name('JTF', 'JTF_IH_ACT_UPDATE_NOT_ALLOW');
6821: fnd_message.set_token('ACT_ID', to_char(p_activity_rec.activity_id));
6822: fnd_msg_pub.add;
6823: END IF;

Line 6822: fnd_msg_pub.add;

6818: --Bug# 4477761 new error msg
6819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6820: fnd_message.set_name('JTF', 'JTF_IH_ACT_UPDATE_NOT_ALLOW');
6821: fnd_message.set_token('ACT_ID', to_char(p_activity_rec.activity_id));
6822: fnd_msg_pub.add;
6823: END IF;
6824: RAISE fnd_api.g_exc_error ;
6825: END IF;
6826: END IF;

Line 6863: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

6859: COMMIT WORK;
6860: END IF;
6861:
6862: -- Standard call to get message count and if count is 1, get message info
6863: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
6864: EXCEPTION
6865: WHEN fnd_api.g_exc_error THEN
6866: ROLLBACK TO update_activity_pub;
6867: x_return_status := fnd_api.g_ret_sts_error;

Line 6868: fnd_msg_pub.count_and_get

6864: EXCEPTION
6865: WHEN fnd_api.g_exc_error THEN
6866: ROLLBACK TO update_activity_pub;
6867: x_return_status := fnd_api.g_ret_sts_error;
6868: fnd_msg_pub.count_and_get
6869: ( p_count => x_msg_count,
6870: p_data => x_msg_data );
6871: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6872: WHEN fnd_api.g_exc_unexpected_error THEN

Line 6871: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

6867: x_return_status := fnd_api.g_ret_sts_error;
6868: fnd_msg_pub.count_and_get
6869: ( p_count => x_msg_count,
6870: p_data => x_msg_data );
6871: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6872: WHEN fnd_api.g_exc_unexpected_error THEN
6873: ROLLBACK TO update_activity_pub;
6874: x_return_status := fnd_api.g_ret_sts_unexp_error;
6875: fnd_msg_pub.count_and_get

Line 6875: fnd_msg_pub.count_and_get

6871: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6872: WHEN fnd_api.g_exc_unexpected_error THEN
6873: ROLLBACK TO update_activity_pub;
6874: x_return_status := fnd_api.g_ret_sts_unexp_error;
6875: fnd_msg_pub.count_and_get
6876: ( p_count => x_msg_count,
6877: p_data => x_msg_data );
6878: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6879: WHEN OTHERS THEN

Line 6878: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

6874: x_return_status := fnd_api.g_ret_sts_unexp_error;
6875: fnd_msg_pub.count_and_get
6876: ( p_count => x_msg_count,
6877: p_data => x_msg_data );
6878: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6879: WHEN OTHERS THEN
6880: ROLLBACK TO update_activity_pub;
6881: x_return_status := fnd_api.g_ret_sts_unexp_error;
6882: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 6882: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6878: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6879: WHEN OTHERS THEN
6880: ROLLBACK TO update_activity_pub;
6881: x_return_status := fnd_api.g_ret_sts_unexp_error;
6882: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6883: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6884: END IF;
6885: fnd_msg_pub.count_and_get
6886: ( p_count => x_msg_count,

Line 6883: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

6879: WHEN OTHERS THEN
6880: ROLLBACK TO update_activity_pub;
6881: x_return_status := fnd_api.g_ret_sts_unexp_error;
6882: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6883: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6884: END IF;
6885: fnd_msg_pub.count_and_get
6886: ( p_count => x_msg_count,
6887: p_data => x_msg_data );

Line 6885: fnd_msg_pub.count_and_get

6881: x_return_status := fnd_api.g_ret_sts_unexp_error;
6882: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6883: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6884: END IF;
6885: fnd_msg_pub.count_and_get
6886: ( p_count => x_msg_count,
6887: p_data => x_msg_data );
6888: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6889: END Update_Activity;

Line 6888: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

6884: END IF;
6885: fnd_msg_pub.count_and_get
6886: ( p_count => x_msg_count,
6887: p_data => x_msg_data );
6888: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
6889: END Update_Activity;
6890:
6891: --
6892: --

Line 6995: fnd_msg_pub.initialize;

6991: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Close_Interaction_2');
6992:
6993: -- Initialize message list if p_init_msg_list is set to TRUE
6994: IF fnd_api.to_boolean(p_init_msg_list) THEN
6995: fnd_msg_pub.initialize;
6996: END IF;
6997:
6998: -- Initialize API return status to success
6999: x_return_status := fnd_api.g_ret_sts_success;

Line 7088: fnd_msg_pub.count_and_get

7084: -- jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full, to_char(l_outcome_id),
7085: -- 'outcome_id');
7086: jtf_ih_core_util_pvt.add_invalid_argument_msg_gen( msg_code,
7087: la_out_act_list);
7088: fnd_msg_pub.count_and_get
7089: ( p_count => x_msg_count,
7090: p_data => x_msg_data );
7091: RETURN;
7092: END IF;

Line 7206: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

7202: COMMIT WORK;
7203: END IF;
7204:
7205: -- Standard call to get message count and if count is 1, get message info
7206: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
7207: EXCEPTION
7208: WHEN fnd_api.g_exc_error THEN
7209: ROLLBACK TO close_interaction_pub2;
7210: x_return_status := fnd_api.g_ret_sts_error;

Line 7211: fnd_msg_pub.count_and_get

7207: EXCEPTION
7208: WHEN fnd_api.g_exc_error THEN
7209: ROLLBACK TO close_interaction_pub2;
7210: x_return_status := fnd_api.g_ret_sts_error;
7211: fnd_msg_pub.count_and_get
7212: ( p_count => x_msg_count,
7213: p_data => x_msg_data );
7214: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7215: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7214: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7210: x_return_status := fnd_api.g_ret_sts_error;
7211: fnd_msg_pub.count_and_get
7212: ( p_count => x_msg_count,
7213: p_data => x_msg_data );
7214: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7215: WHEN fnd_api.g_exc_unexpected_error THEN
7216: ROLLBACK TO close_interaction_pub2;
7217: x_return_status := fnd_api.g_ret_sts_unexp_error;
7218: fnd_msg_pub.count_and_get

Line 7218: fnd_msg_pub.count_and_get

7214: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7215: WHEN fnd_api.g_exc_unexpected_error THEN
7216: ROLLBACK TO close_interaction_pub2;
7217: x_return_status := fnd_api.g_ret_sts_unexp_error;
7218: fnd_msg_pub.count_and_get
7219: ( p_count => x_msg_count,
7220: p_data => x_msg_data );
7221: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7222: WHEN OTHERS THEN

Line 7221: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7217: x_return_status := fnd_api.g_ret_sts_unexp_error;
7218: fnd_msg_pub.count_and_get
7219: ( p_count => x_msg_count,
7220: p_data => x_msg_data );
7221: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7222: WHEN OTHERS THEN
7223: ROLLBACK TO close_interaction_pub2;
7224: x_return_status := fnd_api.g_ret_sts_unexp_error;
7225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 7225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

7221: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7222: WHEN OTHERS THEN
7223: ROLLBACK TO close_interaction_pub2;
7224: x_return_status := fnd_api.g_ret_sts_unexp_error;
7225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7227: END IF;
7228: fnd_msg_pub.count_and_get
7229: ( p_count => x_msg_count,

Line 7226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

7222: WHEN OTHERS THEN
7223: ROLLBACK TO close_interaction_pub2;
7224: x_return_status := fnd_api.g_ret_sts_unexp_error;
7225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7227: END IF;
7228: fnd_msg_pub.count_and_get
7229: ( p_count => x_msg_count,
7230: p_data => x_msg_data );

Line 7228: fnd_msg_pub.count_and_get

7224: x_return_status := fnd_api.g_ret_sts_unexp_error;
7225: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7227: END IF;
7228: fnd_msg_pub.count_and_get
7229: ( p_count => x_msg_count,
7230: p_data => x_msg_data );
7231: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7232: END Close_Interaction;

Line 7231: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7227: END IF;
7228: fnd_msg_pub.count_and_get
7229: ( p_count => x_msg_count,
7230: p_data => x_msg_data );
7231: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7232: END Close_Interaction;
7233:
7234:
7235: --

Line 7298: FND_MSG_PUB.Add;

7294: -- Bug# 2656975
7295: IF ((p_duration IS NULL) OR (p_duration = fnd_api.g_miss_num)) AND
7296: ((p_end_date_time IS NULL) OR (p_end_date_time = fnd_api.g_miss_date )) THEN
7297: FND_MESSAGE.SET_NAME('JTF','JTF_IH_NO_DURATION_END_DATE');
7298: FND_MSG_PUB.Add;
7299: RAISE fnd_api.g_exc_error;
7300: END IF;
7301:
7302: -- set the local variables

Line 7349: fnd_msg_pub.initialize;

7345: --DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Update_ActivityDuration');
7346:
7347: -- Initialize message list if p_init_msg_list is set to TRUE
7348: IF fnd_api.to_boolean(p_init_msg_list) THEN
7349: fnd_msg_pub.initialize;
7350: END IF;
7351:
7352: -- Initialize API return status to success
7353: x_return_status := fnd_api.g_ret_sts_success;

Line 7473: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

7469: COMMIT WORK;
7470: END IF;
7471:
7472: -- Standard call to get message count and if count is 1, get message info
7473: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
7474: EXCEPTION
7475: WHEN fnd_api.g_exc_error THEN
7476: ROLLBACK TO update_activityDuration;
7477: x_return_status := fnd_api.g_ret_sts_error;

Line 7478: fnd_msg_pub.count_and_get

7474: EXCEPTION
7475: WHEN fnd_api.g_exc_error THEN
7476: ROLLBACK TO update_activityDuration;
7477: x_return_status := fnd_api.g_ret_sts_error;
7478: fnd_msg_pub.count_and_get
7479: ( p_count => x_msg_count,
7480: p_data => x_msg_data );
7481: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7482: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7481: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7477: x_return_status := fnd_api.g_ret_sts_error;
7478: fnd_msg_pub.count_and_get
7479: ( p_count => x_msg_count,
7480: p_data => x_msg_data );
7481: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7482: WHEN fnd_api.g_exc_unexpected_error THEN
7483: ROLLBACK TO update_activityDuration;
7484: x_return_status := fnd_api.g_ret_sts_unexp_error;
7485: fnd_msg_pub.count_and_get

Line 7485: fnd_msg_pub.count_and_get

7481: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7482: WHEN fnd_api.g_exc_unexpected_error THEN
7483: ROLLBACK TO update_activityDuration;
7484: x_return_status := fnd_api.g_ret_sts_unexp_error;
7485: fnd_msg_pub.count_and_get
7486: ( p_count => x_msg_count,
7487: p_data => x_msg_data );
7488: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7489: WHEN OTHERS THEN

Line 7488: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7484: x_return_status := fnd_api.g_ret_sts_unexp_error;
7485: fnd_msg_pub.count_and_get
7486: ( p_count => x_msg_count,
7487: p_data => x_msg_data );
7488: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7489: WHEN OTHERS THEN
7490: ROLLBACK TO update_activityDuration;
7491: x_return_status := fnd_api.g_ret_sts_unexp_error;
7492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 7492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

7488: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7489: WHEN OTHERS THEN
7490: ROLLBACK TO update_activityDuration;
7491: x_return_status := fnd_api.g_ret_sts_unexp_error;
7492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7493: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7494: END IF;
7495: fnd_msg_pub.count_and_get
7496: ( p_count => x_msg_count,

Line 7493: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

7489: WHEN OTHERS THEN
7490: ROLLBACK TO update_activityDuration;
7491: x_return_status := fnd_api.g_ret_sts_unexp_error;
7492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7493: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7494: END IF;
7495: fnd_msg_pub.count_and_get
7496: ( p_count => x_msg_count,
7497: p_data => x_msg_data );

Line 7495: fnd_msg_pub.count_and_get

7491: x_return_status := fnd_api.g_ret_sts_unexp_error;
7492: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7493: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7494: END IF;
7495: fnd_msg_pub.count_and_get
7496: ( p_count => x_msg_count,
7497: p_data => x_msg_data );
7498: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7499: END Update_ActivityDuration;

Line 7498: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7494: END IF;
7495: fnd_msg_pub.count_and_get
7496: ( p_count => x_msg_count,
7497: p_data => x_msg_data );
7498: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7499: END Update_ActivityDuration;
7500:
7501:
7502: --

Line 7605: fnd_msg_pub.initialize;

7601: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Open_MediaItem');
7602:
7603: -- Initialize message list if p_init_msg_list is set to TRUE
7604: IF fnd_api.to_boolean(p_init_msg_list) THEN
7605: fnd_msg_pub.initialize;
7606: END IF;
7607:
7608: -- Initialize API return status to success
7609: x_return_status := fnd_api.g_ret_sts_success;

Line 7820: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

7816: COMMIT WORK;
7817: END IF;
7818:
7819: -- Standard call to get message count and if count is 1, get message info
7820: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
7821: EXCEPTION
7822: WHEN fnd_api.g_exc_error THEN
7823: ROLLBACK TO open_mediaitem_pub;
7824: x_return_status := fnd_api.g_ret_sts_error;

Line 7825: fnd_msg_pub.count_and_get

7821: EXCEPTION
7822: WHEN fnd_api.g_exc_error THEN
7823: ROLLBACK TO open_mediaitem_pub;
7824: x_return_status := fnd_api.g_ret_sts_error;
7825: fnd_msg_pub.count_and_get
7826: ( p_count => x_msg_count,
7827: p_data => x_msg_data );
7828: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7829: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7828: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7824: x_return_status := fnd_api.g_ret_sts_error;
7825: fnd_msg_pub.count_and_get
7826: ( p_count => x_msg_count,
7827: p_data => x_msg_data );
7828: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7829: WHEN fnd_api.g_exc_unexpected_error THEN
7830: ROLLBACK TO open_mediaitem_pub;
7831: x_return_status := fnd_api.g_ret_sts_unexp_error;
7832: fnd_msg_pub.count_and_get

Line 7832: fnd_msg_pub.count_and_get

7828: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7829: WHEN fnd_api.g_exc_unexpected_error THEN
7830: ROLLBACK TO open_mediaitem_pub;
7831: x_return_status := fnd_api.g_ret_sts_unexp_error;
7832: fnd_msg_pub.count_and_get
7833: ( p_count => x_msg_count,
7834: p_data => x_msg_data );
7835: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7836: WHEN OTHERS THEN

Line 7835: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7831: x_return_status := fnd_api.g_ret_sts_unexp_error;
7832: fnd_msg_pub.count_and_get
7833: ( p_count => x_msg_count,
7834: p_data => x_msg_data );
7835: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7836: WHEN OTHERS THEN
7837: ROLLBACK TO open_mediaitem_pub;
7838: x_return_status := fnd_api.g_ret_sts_unexp_error;
7839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 7839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

7835: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7836: WHEN OTHERS THEN
7837: ROLLBACK TO open_mediaitem_pub;
7838: x_return_status := fnd_api.g_ret_sts_unexp_error;
7839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7840: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7841: END IF;
7842: fnd_msg_pub.count_and_get
7843: ( p_count => x_msg_count,

Line 7840: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

7836: WHEN OTHERS THEN
7837: ROLLBACK TO open_mediaitem_pub;
7838: x_return_status := fnd_api.g_ret_sts_unexp_error;
7839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7840: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7841: END IF;
7842: fnd_msg_pub.count_and_get
7843: ( p_count => x_msg_count,
7844: p_data => x_msg_data );

Line 7842: fnd_msg_pub.count_and_get

7838: x_return_status := fnd_api.g_ret_sts_unexp_error;
7839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7840: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
7841: END IF;
7842: fnd_msg_pub.count_and_get
7843: ( p_count => x_msg_count,
7844: p_data => x_msg_data );
7845: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7846: END Open_MediaItem;

Line 7845: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

7841: END IF;
7842: fnd_msg_pub.count_and_get
7843: ( p_count => x_msg_count,
7844: p_data => x_msg_data );
7845: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
7846: END Open_MediaItem;
7847:
7848:
7849: --

Line 7970: fnd_msg_pub.initialize;

7966: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Update_MediaItem');
7967:
7968: -- Initialize message list if p_init_msg_list is set to TRUE
7969: IF fnd_api.to_boolean(p_init_msg_list) THEN
7970: fnd_msg_pub.initialize;
7971: END IF;
7972:
7973: -- Initialize API return status to success
7974: x_return_status := fnd_api.g_ret_sts_success;

Line 8339: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

8335: END IF;
8336: --
8337: -- Standard call to get message count and if count is 1, get message info
8338: --
8339: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
8340: EXCEPTION
8341: WHEN fnd_api.g_exc_error THEN
8342: ROLLBACK TO Update_mediaitem_pub;
8343: x_return_status := fnd_api.g_ret_sts_error;

Line 8344: fnd_msg_pub.count_and_get

8340: EXCEPTION
8341: WHEN fnd_api.g_exc_error THEN
8342: ROLLBACK TO Update_mediaitem_pub;
8343: x_return_status := fnd_api.g_ret_sts_error;
8344: fnd_msg_pub.count_and_get
8345: ( p_count => x_msg_count,
8346: p_data => x_msg_data );
8347: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8348: WHEN fnd_api.g_exc_unexpected_error THEN

Line 8347: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8343: x_return_status := fnd_api.g_ret_sts_error;
8344: fnd_msg_pub.count_and_get
8345: ( p_count => x_msg_count,
8346: p_data => x_msg_data );
8347: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8348: WHEN fnd_api.g_exc_unexpected_error THEN
8349: ROLLBACK TO Update_mediaitem_pub;
8350: x_return_status := fnd_api.g_ret_sts_unexp_error;
8351: fnd_msg_pub.count_and_get

Line 8351: fnd_msg_pub.count_and_get

8347: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8348: WHEN fnd_api.g_exc_unexpected_error THEN
8349: ROLLBACK TO Update_mediaitem_pub;
8350: x_return_status := fnd_api.g_ret_sts_unexp_error;
8351: fnd_msg_pub.count_and_get
8352: ( p_count => x_msg_count,
8353: p_data => x_msg_data );
8354: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8355: WHEN OTHERS THEN

Line 8354: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8350: x_return_status := fnd_api.g_ret_sts_unexp_error;
8351: fnd_msg_pub.count_and_get
8352: ( p_count => x_msg_count,
8353: p_data => x_msg_data );
8354: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8355: WHEN OTHERS THEN
8356: ROLLBACK TO Update_mediaitem_pub;
8357: x_return_status := fnd_api.g_ret_sts_unexp_error;
8358: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 8358: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

8354: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8355: WHEN OTHERS THEN
8356: ROLLBACK TO Update_mediaitem_pub;
8357: x_return_status := fnd_api.g_ret_sts_unexp_error;
8358: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8359: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8360: END IF;
8361: fnd_msg_pub.count_and_get
8362: ( p_count => x_msg_count,

Line 8359: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

8355: WHEN OTHERS THEN
8356: ROLLBACK TO Update_mediaitem_pub;
8357: x_return_status := fnd_api.g_ret_sts_unexp_error;
8358: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8359: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8360: END IF;
8361: fnd_msg_pub.count_and_get
8362: ( p_count => x_msg_count,
8363: p_data => x_msg_data );

Line 8361: fnd_msg_pub.count_and_get

8357: x_return_status := fnd_api.g_ret_sts_unexp_error;
8358: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8359: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8360: END IF;
8361: fnd_msg_pub.count_and_get
8362: ( p_count => x_msg_count,
8363: p_data => x_msg_data );
8364: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8365: END Update_MediaItem;

Line 8364: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8360: END IF;
8361: fnd_msg_pub.count_and_get
8362: ( p_count => x_msg_count,
8363: p_data => x_msg_data );
8364: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8365: END Update_MediaItem;
8366:
8367:
8368: --

Line 8483: fnd_msg_pub.initialize;

8479: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Close_MediaItem');
8480:
8481: -- Initialize message list if p_init_msg_list is set to TRUE
8482: IF fnd_api.to_boolean(p_init_msg_list) THEN
8483: fnd_msg_pub.initialize;
8484: END IF;
8485:
8486: -- Initialize API return status to success
8487: x_return_status := fnd_api.g_ret_sts_success;

Line 8640: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

8636: END IF;
8637: --
8638: -- Standard call to get message count and if count is 1, get message info
8639: --
8640: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
8641: EXCEPTION
8642: WHEN fnd_api.g_exc_error THEN
8643: ROLLBACK TO close_mediaitem_pub1;
8644: x_return_status := fnd_api.g_ret_sts_error;

Line 8645: fnd_msg_pub.count_and_get

8641: EXCEPTION
8642: WHEN fnd_api.g_exc_error THEN
8643: ROLLBACK TO close_mediaitem_pub1;
8644: x_return_status := fnd_api.g_ret_sts_error;
8645: fnd_msg_pub.count_and_get
8646: ( p_count => x_msg_count,
8647: p_data => x_msg_data );
8648: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8649: WHEN fnd_api.g_exc_unexpected_error THEN

Line 8648: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8644: x_return_status := fnd_api.g_ret_sts_error;
8645: fnd_msg_pub.count_and_get
8646: ( p_count => x_msg_count,
8647: p_data => x_msg_data );
8648: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8649: WHEN fnd_api.g_exc_unexpected_error THEN
8650: ROLLBACK TO close_mediaitem_pub1;
8651: x_return_status := fnd_api.g_ret_sts_unexp_error;
8652: fnd_msg_pub.count_and_get

Line 8652: fnd_msg_pub.count_and_get

8648: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8649: WHEN fnd_api.g_exc_unexpected_error THEN
8650: ROLLBACK TO close_mediaitem_pub1;
8651: x_return_status := fnd_api.g_ret_sts_unexp_error;
8652: fnd_msg_pub.count_and_get
8653: ( p_count => x_msg_count,
8654: p_data => x_msg_data );
8655: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8656: WHEN OTHERS THEN

Line 8655: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8651: x_return_status := fnd_api.g_ret_sts_unexp_error;
8652: fnd_msg_pub.count_and_get
8653: ( p_count => x_msg_count,
8654: p_data => x_msg_data );
8655: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8656: WHEN OTHERS THEN
8657: ROLLBACK TO close_mediaitem_pub1;
8658: x_return_status := fnd_api.g_ret_sts_unexp_error;
8659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 8659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

8655: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8656: WHEN OTHERS THEN
8657: ROLLBACK TO close_mediaitem_pub1;
8658: x_return_status := fnd_api.g_ret_sts_unexp_error;
8659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8660: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8661: END IF;
8662: fnd_msg_pub.count_and_get
8663: ( p_count => x_msg_count,

Line 8660: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

8656: WHEN OTHERS THEN
8657: ROLLBACK TO close_mediaitem_pub1;
8658: x_return_status := fnd_api.g_ret_sts_unexp_error;
8659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8660: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8661: END IF;
8662: fnd_msg_pub.count_and_get
8663: ( p_count => x_msg_count,
8664: p_data => x_msg_data );

Line 8662: fnd_msg_pub.count_and_get

8658: x_return_status := fnd_api.g_ret_sts_unexp_error;
8659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8660: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8661: END IF;
8662: fnd_msg_pub.count_and_get
8663: ( p_count => x_msg_count,
8664: p_data => x_msg_data );
8665: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8666: END Close_MediaItem;

Line 8665: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8661: END IF;
8662: fnd_msg_pub.count_and_get
8663: ( p_count => x_msg_count,
8664: p_data => x_msg_data );
8665: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8666: END Close_MediaItem;
8667:
8668: --
8669: -- HISTORY

Line 8767: fnd_msg_pub.initialize;

8763: --
8764: -- Initialize message list if p_init_msg_list is set to TRUE
8765: --
8766: IF fnd_api.to_boolean(p_init_msg_list) THEN
8767: fnd_msg_pub.initialize;
8768: END IF;
8769: --
8770: -- Initialize API return status to success
8771: --

Line 8965: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

8961: COMMIT WORK;
8962: END IF;
8963:
8964: -- Standard call to get message count and if count is 1, get message info
8965: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
8966: EXCEPTION
8967: WHEN fnd_api.g_exc_error THEN
8968: ROLLBACK TO open_medialifecycle_pub;
8969: x_return_status := fnd_api.g_ret_sts_error;

Line 8970: fnd_msg_pub.count_and_get

8966: EXCEPTION
8967: WHEN fnd_api.g_exc_error THEN
8968: ROLLBACK TO open_medialifecycle_pub;
8969: x_return_status := fnd_api.g_ret_sts_error;
8970: fnd_msg_pub.count_and_get
8971: ( p_count => x_msg_count,
8972: p_data => x_msg_data );
8973: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8974: WHEN fnd_api.g_exc_unexpected_error THEN

Line 8973: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8969: x_return_status := fnd_api.g_ret_sts_error;
8970: fnd_msg_pub.count_and_get
8971: ( p_count => x_msg_count,
8972: p_data => x_msg_data );
8973: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8974: WHEN fnd_api.g_exc_unexpected_error THEN
8975: ROLLBACK TO open_medialifecycle_pub;
8976: x_return_status := fnd_api.g_ret_sts_unexp_error;
8977: fnd_msg_pub.count_and_get

Line 8977: fnd_msg_pub.count_and_get

8973: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8974: WHEN fnd_api.g_exc_unexpected_error THEN
8975: ROLLBACK TO open_medialifecycle_pub;
8976: x_return_status := fnd_api.g_ret_sts_unexp_error;
8977: fnd_msg_pub.count_and_get
8978: ( p_count => x_msg_count,
8979: p_data => x_msg_data );
8980: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8981: WHEN OTHERS THEN

Line 8980: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8976: x_return_status := fnd_api.g_ret_sts_unexp_error;
8977: fnd_msg_pub.count_and_get
8978: ( p_count => x_msg_count,
8979: p_data => x_msg_data );
8980: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8981: WHEN OTHERS THEN
8982: ROLLBACK TO open_medialifecycle_pub;
8983: x_return_status := fnd_api.g_ret_sts_unexp_error;
8984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 8984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

8980: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8981: WHEN OTHERS THEN
8982: ROLLBACK TO open_medialifecycle_pub;
8983: x_return_status := fnd_api.g_ret_sts_unexp_error;
8984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8986: END IF;
8987: fnd_msg_pub.count_and_get
8988: ( p_count => x_msg_count,

Line 8985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

8981: WHEN OTHERS THEN
8982: ROLLBACK TO open_medialifecycle_pub;
8983: x_return_status := fnd_api.g_ret_sts_unexp_error;
8984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8986: END IF;
8987: fnd_msg_pub.count_and_get
8988: ( p_count => x_msg_count,
8989: p_data => x_msg_data );

Line 8987: fnd_msg_pub.count_and_get

8983: x_return_status := fnd_api.g_ret_sts_unexp_error;
8984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8985: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8986: END IF;
8987: fnd_msg_pub.count_and_get
8988: ( p_count => x_msg_count,
8989: p_data => x_msg_data );
8990: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8991: END Add_MediaLifecycle;

Line 8990: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

8986: END IF;
8987: fnd_msg_pub.count_and_get
8988: ( p_count => x_msg_count,
8989: p_data => x_msg_data );
8990: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
8991: END Add_MediaLifecycle;
8992:
8993: --
8994: -- HISTORY

Line 9110: fnd_msg_pub.initialize;

9106: -- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Update_MediaLifecycle');
9107:
9108: -- Initialize message list if p_init_msg_list is set to TRUE
9109: IF fnd_api.to_boolean(p_init_msg_list) THEN
9110: fnd_msg_pub.initialize;
9111: END IF;
9112:
9113: -- Initialize API return status to success
9114: x_return_status := fnd_api.g_ret_sts_success;

Line 9393: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );

9389: COMMIT WORK;
9390: END IF;
9391:
9392: -- Standard call to get message count and if count is 1, get message info
9393: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
9394: EXCEPTION
9395: WHEN fnd_api.g_exc_error THEN
9396: ROLLBACK TO update_medialifecycle_pub;
9397: x_return_status := fnd_api.g_ret_sts_error;

Line 9398: fnd_msg_pub.count_and_get

9394: EXCEPTION
9395: WHEN fnd_api.g_exc_error THEN
9396: ROLLBACK TO update_medialifecycle_pub;
9397: x_return_status := fnd_api.g_ret_sts_error;
9398: fnd_msg_pub.count_and_get
9399: ( p_count => x_msg_count,
9400: p_data => x_msg_data );
9401: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9402: WHEN fnd_api.g_exc_unexpected_error THEN

Line 9401: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

9397: x_return_status := fnd_api.g_ret_sts_error;
9398: fnd_msg_pub.count_and_get
9399: ( p_count => x_msg_count,
9400: p_data => x_msg_data );
9401: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9402: WHEN fnd_api.g_exc_unexpected_error THEN
9403: ROLLBACK TO update_medialifecycle_pub;
9404: x_return_status := fnd_api.g_ret_sts_unexp_error;
9405: fnd_msg_pub.count_and_get

Line 9405: fnd_msg_pub.count_and_get

9401: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9402: WHEN fnd_api.g_exc_unexpected_error THEN
9403: ROLLBACK TO update_medialifecycle_pub;
9404: x_return_status := fnd_api.g_ret_sts_unexp_error;
9405: fnd_msg_pub.count_and_get
9406: ( p_count => x_msg_count,
9407: p_data => x_msg_data );
9408: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9409: WHEN OTHERS THEN

Line 9408: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

9404: x_return_status := fnd_api.g_ret_sts_unexp_error;
9405: fnd_msg_pub.count_and_get
9406: ( p_count => x_msg_count,
9407: p_data => x_msg_data );
9408: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9409: WHEN OTHERS THEN
9410: ROLLBACK TO update_medialifecycle_pub;
9411: x_return_status := fnd_api.g_ret_sts_unexp_error;
9412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 9412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

9408: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9409: WHEN OTHERS THEN
9410: ROLLBACK TO update_medialifecycle_pub;
9411: x_return_status := fnd_api.g_ret_sts_unexp_error;
9412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9413: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9414: END IF;
9415: fnd_msg_pub.count_and_get
9416: ( p_count => x_msg_count,

Line 9413: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

9409: WHEN OTHERS THEN
9410: ROLLBACK TO update_medialifecycle_pub;
9411: x_return_status := fnd_api.g_ret_sts_unexp_error;
9412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9413: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9414: END IF;
9415: fnd_msg_pub.count_and_get
9416: ( p_count => x_msg_count,
9417: p_data => x_msg_data );

Line 9415: fnd_msg_pub.count_and_get

9411: x_return_status := fnd_api.g_ret_sts_unexp_error;
9412: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9413: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9414: END IF;
9415: fnd_msg_pub.count_and_get
9416: ( p_count => x_msg_count,
9417: p_data => x_msg_data );
9418: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9419: END Update_MediaLifecycle;

Line 9418: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

9414: END IF;
9415: fnd_msg_pub.count_and_get
9416: ( p_count => x_msg_count,
9417: p_data => x_msg_data );
9418: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
9419: END Update_MediaLifecycle;
9420:
9421:
9422: