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 STANDARD

Line 1734: -- Standard start of API savepoint

1730: l_active_perf := 'N';
1731: l_ao_update_pending_perf := 'N';
1732: l_soft_closed_perf := 'N';
1733:
1734: -- Standard start of API savepoint
1735: SAVEPOINT create_media_pub;
1736:
1737: -- Standard call to check for call compatibility
1738: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

Line 1737: -- Standard call to check for call compatibility

1733:
1734: -- Standard start of API savepoint
1735: SAVEPOINT create_media_pub;
1736:
1737: -- Standard call to check for call compatibility
1738: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1739: l_api_name, g_pkg_name) THEN
1740: RAISE fnd_api.g_exc_unexpected_error;
1741: END IF;

Line 2016: -- Standard check of p_commit

2012: );
2013: END loop;
2014:
2015:
2016: -- Standard check of p_commit
2017: IF fnd_api.to_boolean(p_commit) THEN
2018: COMMIT WORK;
2019: END IF;
2020:

Line 2021: -- Standard call to get message count and if count is 1, get message info

2017: IF fnd_api.to_boolean(p_commit) THEN
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

Line 2120: -- Standard start of API savepoint

2116: l_ao_update_pending_perf VARCHAR2(1);
2117: l_soft_closed_perf VARCHAR2(1);
2118:
2119: BEGIN
2120: -- Standard start of API savepoint
2121: SAVEPOINT create_media_pub;
2122:
2123: -- Perf variables
2124: l_duration_perf := 0;

Line 2157: -- Standard call to check for call compatibility

2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;
2155: END IF;
2156:
2157: -- Standard call to check for call compatibility
2158: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2159: l_api_name, g_pkg_name) THEN
2160: RAISE fnd_api.g_exc_unexpected_error;
2161: END IF;

Line 2379: -- Standard check of p_commit

2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: END IF;
2377: END IF;
2378:
2379: -- Standard check of p_commit
2380: IF fnd_api.to_boolean(p_commit) THEN
2381: COMMIT WORK;
2382: END IF;
2383:

Line 2384: -- Standard call to get message count and if count is 1, get message info

2380: IF fnd_api.to_boolean(p_commit) THEN
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

Line 2467: -- Standard start of API savepoint

2463: l_duration_perf NUMBER;
2464: l_active_perf VARCHAR2(1);
2465:
2466: BEGIN
2467: -- Standard start of API savepoint
2468: SAVEPOINT create_media_lc_pub;
2469:
2470: -- Perf variables
2471: l_duration_perf := 0;

Line 2503: -- Standard call to check for call compatibility

2499: END IF;
2500: END IF;
2501:
2502:
2503: -- Standard call to check for call compatibility
2504: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2505: l_api_name, g_pkg_name) THEN
2506: RAISE fnd_api.g_exc_unexpected_error;
2507: END IF;

Line 2686: -- Standard check of p_commit

2682: END IF;
2683: END IF;
2684:
2685:
2686: -- Standard check of p_commit
2687: IF fnd_api.to_boolean(p_commit) THEN
2688: COMMIT WORK;
2689: END IF;
2690:

Line 2691: -- Standard call to get message count and if count is 1, get message info

2687: IF fnd_api.to_boolean(p_commit) THEN
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

Line 2794: -- Standard start of API savepoint

2790: -- Perf variables
2791: l_duration_perf := 0;
2792: l_active_perf := 'N';
2793:
2794: -- Standard start of API savepoint
2795: SAVEPOINT create_interaction_pub;
2796:
2797: -- Preprocessing Call
2798: --l_interaction_rec := p_interaction_rec;

Line 2840: -- Standard call to check for call compatibility

2836: END IF;
2837: END IF;
2838:
2839:
2840: -- Standard call to check for call compatibility
2841: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2842: l_api_name, g_pkg_name) THEN
2843: RAISE fnd_api.g_exc_unexpected_error;
2844: END IF;

Line 3311: -- Standard check of p_commit

3307: END IF;
3308: END IF;
3309:
3310:
3311: -- Standard check of p_commit
3312: IF fnd_api.to_boolean(p_commit) THEN
3313: COMMIT WORK;
3314: END IF;
3315:

Line 3316: -- Standard call to get message count and if count is 1, get message info

3312: IF fnd_api.to_boolean(p_commit) THEN
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:

Line 3695: -- Standard call to get message count and if count is 1, get message info

3691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3899: -- Standard call to get message count and if count is 1, get message info

3895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 3983: -- Standard start of API savepoint

3979: BEGIN
3980: -- local variables initialization to remove GSCC warnings
3981: l_active := 'Y';
3982:
3983: -- Standard start of API savepoint
3984: SAVEPOINT open_interaction_pub;
3985:
3986: -- Preprocessing Call
3987: l_interaction_rec := p_interaction_rec;

Line 4013: -- Standard call to check for call compatibility

4009: END IF;
4010: END IF;
4011:
4012:
4013: -- Standard call to check for call compatibility
4014: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
4015: l_api_name, g_pkg_name) THEN
4016: x_return_status := fnd_api.g_ret_sts_error;
4017: jtf_ih_core_util_pvt.add_invalid_argument_msg(l_api_name_full,

Line 4330: -- Standard check of p_commit

4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4327: END IF;
4328: END IF;
4329:
4330: -- Standard check of p_commit
4331: IF fnd_api.to_boolean(p_commit) THEN
4332: COMMIT WORK;
4333: END IF;
4334:

Line 4335: -- Standard call to get message count and if count is 1, get message info

4331: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 4466: -- Standard start of API savepoint

4462: BEGIN
4463: -- local variables initialization to remove GSCC warning
4464: l_int_rec := p_interaction_rec;
4465:
4466: -- Standard start of API savepoint
4467: SAVEPOINT update_interaction_pub;
4468:
4469: -- Preprocessing Call
4470: --l_interaction_rec_hk := p_interaction_rec;

Line 4499: -- Standard call to check for call compatibility

4495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4496: END IF;
4497: END IF;
4498:
4499: -- Standard call to check for call compatibility
4500: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
4501: l_api_name, g_pkg_name) THEN
4502: RAISE fnd_api.g_exc_unexpected_error;
4503: END IF;

Line 5249: -- Standard check of p_commit

5245: END IF;
5246: END IF;
5247:
5248:
5249: -- Standard check of p_commit
5250: IF fnd_api.to_boolean(p_commit) THEN
5251: COMMIT WORK;
5252: END IF;
5253:

Line 5254: -- Standard call to get message count and if count is 1, get message info

5250: IF fnd_api.to_boolean(p_commit) THEN
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

Line 5386: -- Standard call to check for call compatibility

5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END IF;
5384: END IF;
5385:
5386: -- Standard call to check for call compatibility
5387: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
5388: l_api_name, g_pkg_name) THEN
5389: RAISE fnd_api.g_exc_unexpected_error;
5390: END IF;

Line 5711: -- Standard check of p_commit

5707: END IF;
5708: END IF;
5709:
5710:
5711: -- Standard check of p_commit
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

Line 5715: -- Standard call to get message count and if count is 1, get message info

5711: -- Standard check of p_commit
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;

Line 5803: -- Standard start of API savepoint

5799: BEGIN
5800: -- local variables initialization to remove GSCC warning
5801: -- l_active := 'Y';
5802:
5803: -- Standard start of API savepoint
5804: SAVEPOINT add_activity_pub;
5805: -- Preprocessing Call
5806: l_activity_rec := p_activity_rec;
5807: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'ADD_ACTIVITY', 'B', 'C') THEN

Line 5832: -- Standard call to check for call compatibility

5828: END IF;
5829: END IF;
5830:
5831:
5832: -- Standard call to check for call compatibility
5833: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
5834: l_api_name, g_pkg_name) THEN
5835: RAISE fnd_api.g_exc_unexpected_error;
5836: END IF;

Line 6110: -- Standard check of p_commit

6106:
6107:
6108:
6109:
6110: -- Standard check of p_commit
6111: IF fnd_api.to_boolean(p_commit) THEN
6112: COMMIT WORK;
6113: END IF;
6114:

Line 6115: -- Standard call to get message count and if count is 1, get message info

6111: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 6280: -- Standard call to check for call compatibility

6276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6277: END IF;
6278: END IF;
6279:
6280: -- Standard call to check for call compatibility
6281: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
6282: l_api_name, g_pkg_name) THEN
6283: RAISE fnd_api.g_exc_unexpected_error;
6284: END IF;

Line 6857: -- Standard check of p_commit

6853: END IF;
6854: END IF;
6855:
6856:
6857: -- Standard check of p_commit
6858: IF fnd_api.to_boolean(p_commit) THEN
6859: COMMIT WORK;
6860: END IF;
6861:

Line 6862: -- Standard call to get message count and if count is 1, get message info

6858: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 6986: -- Standard call to check for call compatibility

6982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6983: END IF;
6984: END IF;
6985:
6986: -- Standard call to check for call compatibility
6987: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
6988: l_api_name, g_pkg_name) THEN
6989: RAISE fnd_api.g_exc_unexpected_error;
6990: END IF;

Line 7200: -- Standard check of p_commit

7196: END IF;
7197:
7198:
7199:
7200: -- Standard check of p_commit
7201: IF fnd_api.to_boolean(p_commit) THEN
7202: COMMIT WORK;
7203: END IF;
7204:

Line 7205: -- Standard call to get message count and if count is 1, get message info

7201: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 7283: -- Standard start of API savepoint

7279: l_active VARCHAR2(1) := NULL;
7280: l_recalc_duration BOOLEAN := TRUE;
7281: BEGIN
7282:
7283: -- Standard start of API savepoint
7284: SAVEPOINT update_activityDuration;
7285:
7286: -- No Activity ID - No Update possible
7287: IF (p_activity_id IS NULL) THEN

Line 7340: -- Standard call to check for call compatibility

7336: END IF;
7337: END IF;
7338:
7339:
7340: -- Standard call to check for call compatibility
7341: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
7342: l_api_name, g_pkg_name) THEN
7343: RAISE fnd_api.g_exc_unexpected_error;
7344: END IF;

Line 7467: -- Standard check of p_commit

7463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7464: END IF;
7465: END IF;
7466:
7467: -- Standard check of p_commit
7468: IF fnd_api.to_boolean(p_commit) THEN
7469: COMMIT WORK;
7470: END IF;
7471:

Line 7472: -- Standard call to get message count and if count is 1, get message info

7468: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 7566: -- Standard start of API savepoint

7562: -- Perf variables
7563: l_ao_update_pending_perf := 'N';
7564: l_soft_closed_perf := 'N';
7565:
7566: -- Standard start of API savepoint
7567: SAVEPOINT open_mediaitem_pub;
7568:
7569: -- Preprocessing Call
7570: l_media_rec := p_media_rec;

Line 7596: -- Standard call to check for call compatibility

7592: END IF;
7593: END IF;
7594:
7595:
7596: -- Standard call to check for call compatibility
7597: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
7598: l_api_name, g_pkg_name) THEN
7599: RAISE fnd_api.g_exc_unexpected_error;
7600: END IF;

Line 7814: -- Standard check of p_commit

7810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7811: END IF;
7812: END IF;
7813:
7814: -- Standard check of p_commit
7815: IF fnd_api.to_boolean(p_commit) THEN
7816: COMMIT WORK;
7817: END IF;
7818:

Line 7819: -- Standard call to get message count and if count is 1, get message info

7815: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 7926: -- Standard start of API savepoint

7922:
7923: -- local variables initialization to remove GSCC warnings
7924: l_media_rec := p_media_rec;
7925:
7926: -- Standard start of API savepoint
7927: SAVEPOINT update_mediaitem_pub;
7928:
7929: -- Preprocessing Call
7930: --l_media_rec_hk := p_media_rec;

Line 7961: -- Standard call to check for call compatibility

7957: END IF;
7958:
7959:
7960:
7961: -- Standard call to check for call compatibility
7962: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
7963: l_api_name, g_pkg_name) THEN
7964: RAISE fnd_api.g_exc_unexpected_error;
7965: END IF;

Line 8331: -- Standard check of p_commit

8327: END IF;
8328: END IF;
8329:
8330:
8331: -- Standard check of p_commit
8332: --
8333: IF fnd_api.to_boolean(p_commit) THEN
8334: COMMIT WORK;
8335: END IF;

Line 8337: -- Standard call to get message count and if count is 1, get message info

8333: IF fnd_api.to_boolean(p_commit) THEN
8334: COMMIT WORK;
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

Line 8438: -- Standard start of API savepoint

8434: SELECT *
8435: FROM jtf_ih_media_item_lc_segs
8436: WHERE media_id = p_media_rec.media_id;
8437: BEGIN
8438: -- Standard start of API savepoint
8439: SAVEPOINT close_mediaitem_pub1;
8440:
8441: -- Perf variables
8442: l_active_perf := 'N';

Line 8474: -- Standard call to check for call compatibility

8470: END IF;
8471: END IF;
8472:
8473:
8474: -- Standard call to check for call compatibility
8475: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
8476: l_api_name, g_pkg_name) THEN
8477: RAISE fnd_api.g_exc_unexpected_error;
8478: END IF;

Line 8627: -- Standard check of p_commit

8623: END IF;
8624: END IF;
8625:
8626:
8627: -- Standard check of p_commit
8628: IF fnd_api.to_boolean(p_commit) THEN
8629: COMMIT WORK;
8630: END IF;
8631: --

Line 8632: -- Standard check of p_commit

8628: IF fnd_api.to_boolean(p_commit) THEN
8629: COMMIT WORK;
8630: END IF;
8631: --
8632: -- Standard check of p_commit
8633: --
8634: IF fnd_api.to_boolean(p_commit) THEN
8635: COMMIT WORK;
8636: END IF;

Line 8638: -- Standard call to get message count and if count is 1, get message info

8634: IF fnd_api.to_boolean(p_commit) THEN
8635: COMMIT WORK;
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

Line 8721: -- Standard start of API savepoint

8717: l_active := 'Y';
8718: l_media_lc_rec := p_media_lc_rec;
8719:
8720: --
8721: -- Standard start of API savepoint
8722: --
8723: SAVEPOINT open_medialifecycle_pub;
8724:
8725: -- Preprocessing Call

Line 8756: -- Standard call to check for call compatibility

8752: END IF;
8753: END IF;
8754:
8755: --
8756: -- Standard call to check for call compatibility
8757: --
8758: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
8759: l_api_name, g_pkg_name) THEN
8760: RAISE fnd_api.g_exc_unexpected_error;

Line 8959: -- Standard check of p_commit

8955: END IF;
8956:
8957:
8958:
8959: -- Standard check of p_commit
8960: IF fnd_api.to_boolean(p_commit) THEN
8961: COMMIT WORK;
8962: END IF;
8963:

Line 8964: -- Standard call to get message count and if count is 1, get message info

8960: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 9068: -- Standard start of API savepoint

9064: l_resource_id :=fnd_api.g_miss_num;
9065: l_active :=NULL;
9066: l_media_lc_rec :=p_media_lc_rec;
9067:
9068: -- Standard start of API savepoint
9069: SAVEPOINT update_medialifecycle_pub;
9070:
9071: -- Preprocessing Call
9072: --l_media_lc_rec_hk := p_media_lc_rec;

Line 9101: -- Standard call to check for call compatibility

9097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9098: END IF;
9099: END IF;
9100:
9101: -- Standard call to check for call compatibility
9102: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
9103: l_api_name, g_pkg_name) THEN
9104: RAISE fnd_api.g_exc_unexpected_error;
9105: END IF;

Line 9387: -- Standard check of p_commit

9383: END IF;
9384:
9385:
9386:
9387: -- Standard check of p_commit
9388: IF fnd_api.to_boolean(p_commit) THEN
9389: COMMIT WORK;
9390: END IF;
9391:

Line 9392: -- Standard call to get message count and if count is 1, get message info

9388: IF fnd_api.to_boolean(p_commit) THEN
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;