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_TASK_UTL dependencies on JTF_TASK_UTL

Line 1: PACKAGE BODY jtf_task_utl AS

1: PACKAGE BODY jtf_task_utl AS
2: /* $Header: jtfptklb.pls 120.13 2011/12/12 17:21:48 anangupt ship $ */
3:
4: /******** Start of addition by SBARAT on 29/12/2005 for bug# 4866066 ********/
5: FUNCTION g_yes

Line 25: SELECT jtf_task_utl.get_owner (esc.owner_type_code, esc.owner_id)

21: RETURN VARCHAR2
22: IS
23: l_owner VARCHAR2(120);
24: BEGIN
25: SELECT jtf_task_utl.get_owner (esc.owner_type_code, esc.owner_id)
26: INTO
27: l_owner
28: FROM jtf_tasks_b esc
29: WHERE task_id IN (SELECT task_id

Line 650: jtf_task_utl.currency_code (p_currency_code)

646: ELSIF ( p_costs IS NOT NULL
647: AND p_currency_code IS NOT NULL)
648: THEN
649: IF NOT fnd_api.to_boolean (
650: jtf_task_utl.currency_code (p_currency_code)
651: )
652: THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: END IF;

Line 901: IF x = jtf_task_utl.g_yes

897: FUNCTION to_boolean (x VARCHAR2)
898: RETURN BOOLEAN
899: IS
900: BEGIN
901: IF x = jtf_task_utl.g_yes
902: THEN
903: RETURN TRUE;
904: ELSIF x = jtf_task_utl.g_no
905: THEN

Line 904: ELSIF x = jtf_task_utl.g_no

900: BEGIN
901: IF x = jtf_task_utl.g_yes
902: THEN
903: RETURN TRUE;
904: ELSIF x = jtf_task_utl.g_no
905: THEN
906: RETURN FALSE;
907: ELSE
908: RETURN NULL;

Line 1014: IF NOT ( p_flag_value IN (jtf_task_utl.g_yes, jtf_task_utl.g_no)

1010: IS
1011: BEGIN
1012: x_return_status := fnd_api.g_ret_sts_success;
1013:
1014: IF NOT ( p_flag_value IN (jtf_task_utl.g_yes, jtf_task_utl.g_no)
1015: OR p_flag_value IS NULL)
1016: THEN
1017: x_return_status := fnd_api.g_ret_sts_unexp_error;
1018: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');

Line 1047: IF p_template_flag = jtf_task_utl.g_yes

1043: WHERE task_template_id = p_task_id);
1044: BEGIN
1045: x_return_status := fnd_api.g_ret_sts_success;
1046:
1047: IF p_template_flag = jtf_task_utl.g_yes
1048: THEN
1049: OPEN c_template_object_details;
1050: FETCH c_template_object_details INTO x_source_object_code;
1051:

Line 1264: jtf_task_utl.validate_cust_account (

1260: x_address_id IN OUT NOCOPY NUMBER -- Fixed from OUT to IN OUT
1261: )
1262: IS
1263: BEGIN
1264: jtf_task_utl.validate_cust_account (
1265: p_cust_account_id => p_cust_account_id,
1266: p_cust_account_number => p_cust_account_number,
1267: x_return_status => x_return_status,
1268: x_cust_account_id => x_cust_account_id

Line 1277: jtf_task_utl.validate_party (

1273: x_return_status := fnd_api.g_ret_sts_unexp_error;
1274: RAISE fnd_api.g_exc_unexpected_error;
1275: END IF;
1276:
1277: jtf_task_utl.validate_party (
1278: p_party_id => p_customer_id,
1279: p_party_number => p_customer_number,
1280: x_return_status => x_return_status,
1281: x_party_id => x_customer_id

Line 1290: jtf_task_utl.validate_party_site (

1286: x_return_status := fnd_api.g_ret_sts_unexp_error;
1287: RAISE fnd_api.g_exc_unexpected_error;
1288: END IF;
1289:
1290: jtf_task_utl.validate_party_site (
1291: p_party_site_id => p_address_id,
1292: p_party_site_number => p_address_number,
1293: x_return_status => x_return_status,
1294: x_party_site_id => x_address_id

Line 1306: jtf_task_utl.validate_party_site_acct (

1302: /* removing fix for bug #1628560
1303: ----
1304: ---- Cross-validate customer/address/account
1305: ----
1306: jtf_task_utl.validate_party_site_acct (
1307: p_party_id => p_customer_id,
1308: p_party_site_id => p_address_id,
1309: p_cust_account_id => p_cust_account_id,
1310: x_return_status => x_return_status

Line 1735: IF NOT fnd_api.to_boolean (jtf_task_utl.validate_time_uom(l_effort_uom))

1731: fnd_message.set_token ('P_TAG', p_tag);
1732: fnd_msg_pub.add;
1733: END IF;
1734:
1735: IF NOT fnd_api.to_boolean (jtf_task_utl.validate_time_uom(l_effort_uom))
1736: THEN
1737: x_return_status := fnd_api.g_ret_sts_unexp_error;
1738: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_UOM');
1739: fnd_message.set_token ('P_UOM_CODE', l_effort_uom); -- Fix Bug 2118718

Line 1875: jtf_task_utl.validate_status (

1871:
1872: ---
1873: --- call new procedure to validate the status, to fix bug #1878669
1874: ---
1875: jtf_task_utl.validate_status (
1876: p_status_id => x_task_status_id,
1877: p_type => p_validation_type,
1878: x_return_status => x_return_status);
1879:

Line 2103: jtf_task_utl.validate_flag (

2099: FROM per_all_people_f
2100: WHERE person_id = p_owner_id;
2101: BEGIN
2102: x_return_status := fnd_api.g_ret_sts_success;
2103: jtf_task_utl.validate_flag (
2104: p_api_name => NULL,
2105: p_init_msg_list => fnd_api.g_false,
2106: x_return_status => x_return_status,
2107: p_flag_name => 'Escalation Flag',

Line 2117: IF ( jtf_task_utl.to_boolean (p_escalation_flag) = FALSE

2113: x_return_status := fnd_api.g_ret_sts_unexp_error;
2114: RAISE fnd_api.g_exc_unexpected_error;
2115: END IF;
2116:
2117: IF ( jtf_task_utl.to_boolean (p_escalation_flag) = FALSE
2118: OR p_escalation_flag IS NULL)
2119: THEN
2120: IF (p_owner_id IS NOT NULL)
2121: OR (p_terr_id IS NOT NULL)

Line 2161: jtf_task_utl.validate_territory (

2157:
2158: IF ( p_terr_id IS NOT NULL
2159: OR p_terr_name IS NOT NULL)
2160: THEN
2161: jtf_task_utl.validate_territory (
2162: p_terr_id => p_terr_id,
2163: p_terr_name => p_terr_name,
2164: x_return_status => x_return_status,
2165: x_terr_id => x_terr_id

Line 2263: jtf_task_utl.validate_object_type (

2259: FROM jtf_objects_b
2260: WHERE object_code = l_owner_type_code;
2261: BEGIN
2262: x_return_status := fnd_api.g_ret_sts_success;
2263: jtf_task_utl.validate_object_type (
2264: p_object_code => p_owner_type_code,
2265: p_object_type_name => p_owner_type_name,
2266: p_object_type_tag => 'Owner',
2267: p_object_usage => 'RESOURCES',

Line 2516: jtf_task_utl.validate_flag (

2512: l_period_uom jtf_tasks_b.notification_period_uom%TYPE
2513: := p_notification_period_uom;
2514: BEGIN
2515: x_return_status := fnd_api.g_ret_sts_success;
2516: jtf_task_utl.validate_flag (
2517: x_return_status => x_return_status,
2518: p_flag_name => 'Notification
2519: Flag',
2520: p_flag_value => p_notification_flag

Line 2541: --jtf_task_utl.validate_effort (

2537: --END IF;
2538: -----------------------------------------------------
2539:
2540: --------- Fixed bug 2137765 --------------------------
2541: --jtf_task_utl.validate_effort (
2542: -- x_return_status => x_return_status,
2543: -- p_effort => l_period,
2544: -- p_effort_uom => l_period_uom
2545: --);

Line 2546: jtf_task_utl.validate_effort (

2542: -- x_return_status => x_return_status,
2543: -- p_effort => l_period,
2544: -- p_effort_uom => l_period_uom
2545: --);
2546: jtf_task_utl.validate_effort (
2547: p_tag => jtf_task_utl.get_translated_lookup (
2548: 'JTF_TASK_TRANSLATED_MESSAGES',
2549: 'NOTIFICATION_PERIOD'
2550: ),

Line 2547: p_tag => jtf_task_utl.get_translated_lookup (

2543: -- p_effort => l_period,
2544: -- p_effort_uom => l_period_uom
2545: --);
2546: jtf_task_utl.validate_effort (
2547: p_tag => jtf_task_utl.get_translated_lookup (
2548: 'JTF_TASK_TRANSLATED_MESSAGES',
2549: 'NOTIFICATION_PERIOD'
2550: ),
2551: p_tag_uom => jtf_task_utl.get_translated_lookup (

Line 2551: p_tag_uom => jtf_task_utl.get_translated_lookup (

2547: p_tag => jtf_task_utl.get_translated_lookup (
2548: 'JTF_TASK_TRANSLATED_MESSAGES',
2549: 'NOTIFICATION_PERIOD'
2550: ),
2551: p_tag_uom => jtf_task_utl.get_translated_lookup (
2552: 'JTF_TASK_TRANSLATED_MESSAGES',
2553: 'NOTIFICATION_PERIOD_UOM'
2554: ),
2555: x_return_status => x_return_status,

Line 2608: jtf_task_utl.validate_flag (

2604: ----
2605:
2606: BEGIN
2607: x_return_status := fnd_api.g_ret_sts_success;
2608: jtf_task_utl.validate_flag (
2609: x_return_status => x_return_status,
2610: p_flag_name => 'Alarm Flag',
2611: p_flag_value => l_alarm_on
2612: );

Line 2619: IF jtf_task_utl.to_boolean (p_alarm_on)

2615: THEN
2616: RAISE fnd_api.g_exc_unexpected_error;
2617: END IF;
2618:
2619: IF jtf_task_utl.to_boolean (p_alarm_on)
2620: THEN
2621: IF (l_alarm_start IS NULL)
2622: OR (l_alarm_start_uom IS NULL)
2623: OR (l_alarm_count IS NULL)

Line 2633: jtf_task_utl.validate_effort (

2629: x_return_status := fnd_api.g_ret_sts_unexp_error;
2630: RAISE fnd_api.g_exc_unexpected_error;
2631: END IF;
2632:
2633: jtf_task_utl.validate_effort (
2634: x_return_status => x_return_status,
2635: p_effort => l_alarm_start,
2636: p_effort_uom => l_alarm_start_uom
2637: );

Line 2650: jtf_task_utl.validate_effort (

2646:
2647: /*** Fixed Bug 2118582 ***********/
2648: --IF is_not_null
2649: --THEN
2650: jtf_task_utl.validate_effort (
2651: x_return_status => x_return_status,
2652: p_effort => l_alarm_interval,
2653: p_effort_uom => l_alarm_interval_uom
2654: );

Line 2802: jtf_task_utl.get_owner (x_owner_type_code, x_owner_id);

2798: IF profile_set
2799: THEN
2800: BEGIN
2801: x_owner_name :=
2802: jtf_task_utl.get_owner (x_owner_type_code, x_owner_id);
2803: EXCEPTION
2804: WHEN NO_DATA_FOUND
2805: THEN
2806: profile_set := FALSE;

Line 2837: jtf_task_utl.get_owner (x_owner_type_code, x_owner_id);

2833: INTO x_owner_type_code_name
2834: FROM jtf_objects_vl
2835: WHERE object_code = x_owner_type_code;
2836: x_owner_name :=
2837: jtf_task_utl.get_owner (x_owner_type_code, x_owner_id);
2838: EXCEPTION
2839: WHEN NO_DATA_FOUND
2840: THEN
2841: NULL;

Line 2856: RETURN jtf_task_utl.g_uom_time_class;

2852: FUNCTION get_uom_time_class
2853: RETURN VARCHAR2
2854: IS
2855: BEGIN
2856: RETURN jtf_task_utl.g_uom_time_class;
2857: END;
2858:
2859: -----------------------------
2860: ----------------------------

Line 3183: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char

3179:
3180: BEGIN
3181:
3182: x_return_status := fnd_api.g_ret_sts_success;
3183: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char
3184: THEN
3185:
3186: -- select the owner info from task table for this task id
3187: SELECT owner_id, owner_type_code, private_flag

Line 3237: IF l_private_flag = jtf_task_utl.g_no_char or l_private_flag is null

3233: IF SQL%FOUND THEN
3234: x_return_status := fnd_api.g_ret_sts_success;
3235: ELSE
3236: -- check to see if the user has the privilege when private flag is set to 'N'
3237: IF l_private_flag = jtf_task_utl.g_no_char or l_private_flag is null
3238: THEN
3239: SELECT function_name into l_privilege
3240: FROM fnd_form_functions fff, fnd_menu_entries fme
3241: WHERE fff.function_id = fme.function_id

Line 3251: AND function_name = jtf_task_utl.g_tasks_full_privelege;

3247: and fg.object_id = (select object_id from fnd_objects
3248: where obj_name = 'JTF_TASK_RESOURCE'
3249: )
3250: )
3251: AND function_name = jtf_task_utl.g_tasks_full_privelege;
3252:
3253: IF SQL%FOUND THEN
3254: x_return_status := fnd_api.g_ret_sts_success;
3255: ELSE

Line 3351: AND function_name = jtf_task_utl.g_tasks_full_privelege;

3347: FROM fnd_objects
3348: WHERE obj_name = 'JTF_TASK_RESOURCE'
3349: )
3350: )
3351: AND function_name = jtf_task_utl.g_tasks_full_privelege;
3352:
3353: rec_grant c_grant%ROWTYPE;
3354:
3355: BEGIN

Line 3358: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char

3354:
3355: BEGIN
3356: x_return_status := fnd_api.g_ret_sts_success;
3357:
3358: IF fnd_profile.value('JTF_TASK_CHECK_SECURITY') = jtf_task_utl.g_yes_char
3359: THEN
3360: OPEN c_task_owner;
3361: FETCH c_task_owner INTO rec_task_owner;
3362: IF c_task_owner%NOTFOUND

Line 3404: IF rec_task_owner.private_flag = jtf_task_utl.g_no_char or

3400: FETCH c_assignee_or_owner INTO rec_assignee_or_owner;
3401: IF c_assignee_or_owner%NOTFOUND
3402: THEN
3403: -- check to see if the user has the privilege when private flag is set to 'N'
3404: IF rec_task_owner.private_flag = jtf_task_utl.g_no_char or
3405: rec_task_owner.private_flag is null
3406: THEN
3407: OPEN c_grant (rec_task_owner.owner_id,
3408: rec_task_owner.owner_type_code,

Line 3647: l_category_name := jtf_task_utl.get_category_name(l_category_id);

3643: and rownum < 2 ;
3644:
3645: -- For fix bug 2540722
3646: -- If l_category_id is null, return the translated message for "Unfiled"
3647: l_category_name := jtf_task_utl.get_category_name(l_category_id);
3648:
3649: return l_category_name;
3650:
3651: EXCEPTION

Line 3653: l_category_name := jtf_task_utl.get_category_name(null);

3649: return l_category_name;
3650:
3651: EXCEPTION
3652: when no_data_found then
3653: l_category_name := jtf_task_utl.get_category_name(null);
3654: return l_category_name;
3655: END;
3656:
3657:

Line 3697: jtf_task_utl_ext.set_calendar_dates (

3693: x_return_status OUT NOCOPY VARCHAR2
3694: )
3695: is
3696: begin
3697: jtf_task_utl_ext.set_calendar_dates (
3698: p_show_on_calendar => p_show_on_calendar ,
3699: p_date_selected => p_date_selected ,
3700: p_planned_start_date => p_planned_start_date ,
3701: p_planned_end_date => p_planned_end_date ,

Line 3743: IF p_type = 'TASK' AND l_task_status_flag = jtf_task_utl.g_yes_char

3739: FROM jtf_task_statuses_b
3740: WHERE task_status_id = p_status_id;
3741:
3742: IF SQL%FOUND THEN
3743: IF p_type = 'TASK' AND l_task_status_flag = jtf_task_utl.g_yes_char
3744: THEN
3745: x_return_status := fnd_api.g_ret_sts_success;
3746: ELSE
3747: IF p_type = 'ASSIGNMENT' AND l_assignment_status_flag = jtf_task_utl.g_yes_char

Line 3747: IF p_type = 'ASSIGNMENT' AND l_assignment_status_flag = jtf_task_utl.g_yes_char

3743: IF p_type = 'TASK' AND l_task_status_flag = jtf_task_utl.g_yes_char
3744: THEN
3745: x_return_status := fnd_api.g_ret_sts_success;
3746: ELSE
3747: IF p_type = 'ASSIGNMENT' AND l_assignment_status_flag = jtf_task_utl.g_yes_char
3748: THEN
3749: x_return_status := fnd_api.g_ret_sts_success;
3750: ELSE
3751: IF p_type = 'ESCALATION' AND l_usage = 'ESCALATION'

Line 3756: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));

3752: THEN
3753: x_return_status := fnd_api.g_ret_sts_success;
3754: ELSE
3755: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
3756: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));
3757: fnd_msg_pub.add;
3758: x_return_status := fnd_api.g_ret_sts_unexp_error;
3759: END IF;
3760: END IF;

Line 3768: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));

3764: EXCEPTION
3765: WHEN OTHERS
3766: THEN
3767: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
3768: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));
3769: fnd_msg_pub.add;
3770: x_return_status := fnd_api.g_ret_sts_unexp_error;
3771: END;
3772: -------------