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_PS dependencies on STANDARD

Line 774: -- Standard start of API savepoint

770: l_milcs_id NUMBER;
771: l_mlcs mlcs_tbl_type := p_mlcs;
772:
773: BEGIN
774: -- Standard start of API savepoint
775: SAVEPOINT create_media_pub;
776:
777: -- Standard call to check for call compatibility
778: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

773: BEGIN
774: -- Standard start of API savepoint
775: SAVEPOINT create_media_pub;
776:
777: -- Standard call to check for call compatibility
778: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
779: l_api_name, g_pkg_name) THEN
780: RAISE fnd_api.g_exc_unexpected_error;
781: END IF;

Line 918: -- Standard check of p_commit

914: );
915: END loop;
916:
917:
918: -- Standard check of p_commit
919: IF fnd_api.to_boolean(p_commit) THEN
920: COMMIT WORK;
921: END IF;
922:

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

919: IF fnd_api.to_boolean(p_commit) THEN
920: COMMIT WORK;
921: END IF;
922:
923: -- Standard call to get message count and if count is 1, get message info
924: fnd_msg_pub.count_and_get
925: ( p_count => x_msg_count,
926: p_data => x_msg_data );
927: EXCEPTION

Line 978: -- Standard start of API savepoint

974: l_return_status VARCHAR2(1);
975: l_media_id NUMBER := NULL;
976:
977: BEGIN
978: -- Standard start of API savepoint
979: SAVEPOINT create_media_pub;
980:
981: -- Standard call to check for call compatibility
982: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

977: BEGIN
978: -- Standard start of API savepoint
979: SAVEPOINT create_media_pub;
980:
981: -- Standard call to check for call compatibility
982: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
983: l_api_name, g_pkg_name) THEN
984: RAISE fnd_api.g_exc_unexpected_error;
985: END IF;

Line 1077: -- Standard check of p_commit

1073: -- Output
1074: -- --
1075: x_media_id := l_media_id;
1076:
1077: -- Standard check of p_commit
1078: IF fnd_api.to_boolean(p_commit) THEN
1079: COMMIT WORK;
1080: END IF;
1081:

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

1078: IF fnd_api.to_boolean(p_commit) THEN
1079: COMMIT WORK;
1080: END IF;
1081:
1082: -- Standard call to get message count and if count is 1, get message info
1083: fnd_msg_pub.count_and_get
1084: ( p_count => x_msg_count,
1085: p_data => x_msg_data );
1086: EXCEPTION

Line 1134: -- Standard start of API savepoint

1130: l_return_status VARCHAR2(1);
1131: l_milcs_id NUMBER := NULL;
1132:
1133: BEGIN
1134: -- Standard start of API savepoint
1135: SAVEPOINT create_media_lc_pub;
1136:
1137: -- Standard call to check for call compatibility
1138: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

1133: BEGIN
1134: -- Standard start of API savepoint
1135: SAVEPOINT create_media_lc_pub;
1136:
1137: -- Standard call to check for call compatibility
1138: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1139: l_api_name, g_pkg_name) THEN
1140: RAISE fnd_api.g_exc_unexpected_error;
1141: END IF;

Line 1224: -- Standard check of p_commit

1220: p_login_id
1221: );
1222: --DBMS_OUTPUT.PUT_LINE('PAST insert data in JTF_IH_PUB_PS.Create_MediaLifecycle');
1223:
1224: -- Standard check of p_commit
1225: IF fnd_api.to_boolean(p_commit) THEN
1226: COMMIT WORK;
1227: END IF;
1228:

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

1225: IF fnd_api.to_boolean(p_commit) THEN
1226: COMMIT WORK;
1227: END IF;
1228:
1229: -- Standard call to get message count and if count is 1, get message info
1230: fnd_msg_pub.count_and_get
1231: ( p_count => x_msg_count,
1232: p_data => x_msg_data );
1233: EXCEPTION

Line 1283: -- Standard start of API savepoint

1279: l_activities activity_tbl_type := p_activities;
1280:
1281: BEGIN
1282:
1283: -- Standard start of API savepoint
1284: SAVEPOINT create_interaction_pub;
1285:
1286: -- Standard call to check for call compatibility
1287: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

1282:
1283: -- Standard start of API savepoint
1284: SAVEPOINT create_interaction_pub;
1285:
1286: -- Standard call to check for call compatibility
1287: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1288: l_api_name, g_pkg_name) THEN
1289: RAISE fnd_api.g_exc_unexpected_error;
1290: END IF;

Line 1541: -- Standard check of p_commit

1537: -- Set OUT value
1538: --
1539: --x_interaction_id := l_int_val_rec.interaction_id;
1540:
1541: -- Standard check of p_commit
1542: IF fnd_api.to_boolean(p_commit) THEN
1543: COMMIT WORK;
1544: END IF;
1545:

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

1542: IF fnd_api.to_boolean(p_commit) THEN
1543: COMMIT WORK;
1544: END IF;
1545:
1546: -- Standard call to get message count and if count is 1, get message info
1547: fnd_msg_pub.count_and_get
1548: ( p_count => x_msg_count,
1549: p_data => x_msg_data );
1550: EXCEPTION

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

1642: and reason_id = p_reason_id
1643: and media_id = p_media_id
1644: ;
1645: x_activity_count := actionCount;
1646: -- Standard call to get message count and if count is 1, get message info
1647: fnd_msg_pub.count_and_get
1648: ( p_count => x_msg_count,
1649: p_data => x_msg_data );
1650: EXCEPTION

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

1765: and ((attribute15 = p_attribute15) or (p_attribute15 is NULL and attribute15 is NULL))
1766: and ((p_attribute_category = p_attribute_category) or (p_attribute_category is NULL and p_attribute_category is NULL))
1767: ;
1768: x_interaction_count := interactionCount;
1769: -- Standard call to get message count and if count is 1, get message info
1770: fnd_msg_pub.count_and_get
1771: ( p_count => x_msg_count,
1772: p_data => x_msg_data );
1773: EXCEPTION

Line 1821: -- Standard start of API savepoint

1817: l_active VARCHAR2(1) := 'Y';
1818: l_duration NUMBER := NULL;
1819: l_productive_time_amount NUMBER := NULL;
1820: BEGIN
1821: -- Standard start of API savepoint
1822: SAVEPOINT open_interaction_pub;
1823:
1824: -- Standard call to check for call compatibility
1825: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

1820: BEGIN
1821: -- Standard start of API savepoint
1822: SAVEPOINT open_interaction_pub;
1823:
1824: -- Standard call to check for call compatibility
1825: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1826: l_api_name, g_pkg_name) THEN
1827: RAISE fnd_api.g_exc_unexpected_error;
1828: END IF;

Line 2047: -- Standard check of p_commit

2043: -- Set OUT value
2044: --
2045: x_interaction_id := l_interaction_id;
2046:
2047: -- Standard check of p_commit
2048: IF fnd_api.to_boolean(p_commit) THEN
2049: COMMIT WORK;
2050: END IF;
2051:

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

2048: IF fnd_api.to_boolean(p_commit) THEN
2049: COMMIT WORK;
2050: END IF;
2051:
2052: -- Standard call to get message count and if count is 1, get message info
2053: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2054: EXCEPTION
2055: WHEN fnd_api.g_exc_error THEN
2056: ROLLBACK TO open_interaction_pub;

Line 2104: -- Standard start of API savepoint

2100: l_active VARCHAR2(1) := NULL;
2101: l_duration NUMBER := NULL;
2102: l_productive_time_amount NUMBER := NULL;
2103: BEGIN
2104: -- Standard start of API savepoint
2105: SAVEPOINT update_interaction_pub;
2106:
2107: -- Standard call to check for call compatibility
2108: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

2103: BEGIN
2104: -- Standard start of API savepoint
2105: SAVEPOINT update_interaction_pub;
2106:
2107: -- Standard call to check for call compatibility
2108: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2109: l_api_name, g_pkg_name) THEN
2110: RAISE fnd_api.g_exc_unexpected_error;
2111: END IF;

Line 2397: -- Standard check of p_commit

2393: END IF;
2394: END IF;
2395: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB_PS.Update_Interaction');
2396:
2397: -- Standard check of p_commit
2398: IF fnd_api.to_boolean(p_commit) THEN
2399: COMMIT WORK;
2400: END IF;
2401:

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

2398: IF fnd_api.to_boolean(p_commit) THEN
2399: COMMIT WORK;
2400: END IF;
2401:
2402: -- Standard call to get message count and if count is 1, get message info
2403: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2404:
2405: EXCEPTION
2406: WHEN fnd_api.g_exc_error THEN

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

2453: WHERE interaction_id = p_interaction_rec.interaction_id;
2454: BEGIN
2455: SAVEPOINT close_interaction_pub1;
2456:
2457: -- Standard call to check for call compatibility
2458: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2459: l_api_name, g_pkg_name) THEN
2460: RAISE fnd_api.g_exc_unexpected_error;
2461: END IF;

Line 2567: -- Standard check of p_commit

2563: WHERE interaction_id = p_interaction_rec.interaction_id;
2564: END LOOP;
2565: --DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB_PS.Close_Interaction');
2566:
2567: -- Standard check of p_commit
2568: IF fnd_api.to_boolean(p_commit) THEN
2569: COMMIT WORK;
2570: END IF;
2571:

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

2568: IF fnd_api.to_boolean(p_commit) THEN
2569: COMMIT WORK;
2570: END IF;
2571:
2572: -- Standard call to get message count and if count is 1, get message info
2573: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2574: EXCEPTION
2575: WHEN fnd_api.g_exc_error THEN
2576: ROLLBACK TO close_interaction_pub1;

Line 2624: -- Standard start of API savepoint

2620: l_duration NUMBER := NULL;
2621: l_start_date_time DATE;
2622: l_active VARCHAR2(1) := 'Y';
2623: BEGIN
2624: -- Standard start of API savepoint
2625: SAVEPOINT add_activity_pub;
2626:
2627: -- Standard call to check for call compatibility
2628: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

2623: BEGIN
2624: -- Standard start of API savepoint
2625: SAVEPOINT add_activity_pub;
2626:
2627: -- Standard call to check for call compatibility
2628: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2629: l_api_name, g_pkg_name) THEN
2630: RAISE fnd_api.g_exc_unexpected_error;
2631: END IF;

Line 2772: -- Standard check of p_commit

2768: -- Set OUT value
2769: --
2770: x_activity_id := l_activity_id;
2771:
2772: -- Standard check of p_commit
2773: IF fnd_api.to_boolean(p_commit) THEN
2774: COMMIT WORK;
2775: END IF;
2776:

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

2773: IF fnd_api.to_boolean(p_commit) THEN
2774: COMMIT WORK;
2775: END IF;
2776:
2777: -- Standard call to get message count and if count is 1, get message info
2778: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
2779: EXCEPTION
2780: WHEN fnd_api.g_exc_error THEN
2781: ROLLBACK TO add_activity_pub;

Line 2827: -- Standard start of API savepoint

2823: l_duration NUMBER := NULL;
2824: l_count NUMBER := 0;
2825: l_active VARCHAR2(1) := NULL;
2826: BEGIN
2827: -- Standard start of API savepoint
2828: SAVEPOINT update_activity_pub;
2829:
2830: -- Standard call to check for call compatibility
2831: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

2826: BEGIN
2827: -- Standard start of API savepoint
2828: SAVEPOINT update_activity_pub;
2829:
2830: -- Standard call to check for call compatibility
2831: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
2832: l_api_name, g_pkg_name) THEN
2833: RAISE fnd_api.g_exc_unexpected_error;
2834: END IF;

Line 3011: -- Standard check of p_commit

3007: END IF;
3008: END IF;
3009: --DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_activities in JTF_IH_PUB_PS.Update_Activity');
3010:
3011: -- Standard check of p_commit
3012: IF fnd_api.to_boolean(p_commit) THEN
3013: COMMIT WORK;
3014: END IF;
3015:

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

3012: IF fnd_api.to_boolean(p_commit) THEN
3013: COMMIT WORK;
3014: END IF;
3015:
3016: -- Standard call to get message count and if count is 1, get message info
3017: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
3018: EXCEPTION
3019: WHEN fnd_api.g_exc_error THEN
3020: ROLLBACK TO update_activity_pub;

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

3066: WHERE interaction_id = p_interaction_id;
3067: BEGIN
3068: SAVEPOINT close_interaction_pub2;
3069:
3070: -- Standard call to check for call compatibility
3071: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
3072: l_api_name, g_pkg_name) THEN
3073: RAISE fnd_api.g_exc_unexpected_error;
3074: END IF;

Line 3164: -- Standard check of p_commit

3160: END LOOP;
3161: --DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB_PS.Close_Interaction_2');
3162:
3163:
3164: -- Standard check of p_commit
3165: IF fnd_api.to_boolean(p_commit) THEN
3166: COMMIT WORK;
3167: END IF;
3168:

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

3165: IF fnd_api.to_boolean(p_commit) THEN
3166: COMMIT WORK;
3167: END IF;
3168:
3169: -- Standard call to get message count and if count is 1, get message info
3170: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
3171: EXCEPTION
3172: WHEN fnd_api.g_exc_error THEN
3173: ROLLBACK TO close_interaction_pub2;

Line 3221: -- Standard start of API savepoint

3217: l_return_status VARCHAR2(1);
3218: l_start_date_time DATE;
3219: BEGIN
3220:
3221: -- Standard start of API savepoint
3222: SAVEPOINT update_activityDuration;
3223:
3224: -- Standard call to check for call compatibility
3225: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

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

3220:
3221: -- Standard start of API savepoint
3222: SAVEPOINT update_activityDuration;
3223:
3224: -- Standard call to check for call compatibility
3225: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
3226: l_api_name, g_pkg_name) THEN
3227: RAISE fnd_api.g_exc_unexpected_error;
3228: END IF;

Line 3292: -- Standard check of p_commit

3288:
3289: --DBMS_OUTPUT.PUT_LINE('PAST update end_date_time and duration in JTF_IH_PUB_PS.Update_ActivityDuration');
3290: END IF;
3291:
3292: -- Standard check of p_commit
3293: IF fnd_api.to_boolean(p_commit) THEN
3294: COMMIT WORK;
3295: END IF;
3296:

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

3293: IF fnd_api.to_boolean(p_commit) THEN
3294: COMMIT WORK;
3295: END IF;
3296:
3297: -- Standard call to get message count and if count is 1, get message info
3298: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
3299: EXCEPTION
3300: WHEN fnd_api.g_exc_error THEN
3301: ROLLBACK TO update_activityDuration;