DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on JTA_SYNC_COMMON

Line 345: raise_application_error (-20100,jta_sync_common.get_messages);

341: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
342: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.IS_THIS_NEW_TASK');
343: fnd_msg_pub.add;
344:
345: raise_application_error (-20100,jta_sync_common.get_messages);
346: END IF;
347:
348: OPEN c_synctask;
349: FETCH c_synctask INTO l_task_id;

Line 530: raise_application_error (-20100,jta_sync_common.get_messages);

526: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
528: fnd_msg_pub.add;
529:
530: raise_application_error (-20100,jta_sync_common.get_messages);
531:
532: END IF;
533:
534: OPEN c_task_sync;

Line 548: raise_application_error (-20100,jta_sync_common.get_messages);

544: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
545: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
546: fnd_msg_pub.add;
547:
548: raise_application_error (-20100,jta_sync_common.get_messages);
549: ELSIF l_task_id IS NULL
550: THEN
551: CLOSE c_task_sync;
552:

Line 560: raise_application_error (-20100,jta_sync_common.get_messages);

556: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_TASKID');
557: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
558: fnd_msg_pub.add;
559:
560: raise_application_error (-20100,jta_sync_common.get_messages);
561: END IF;
562:
563: CLOSE c_task_sync;
564: RETURN l_task_id;

Line 592: raise_application_error (-20100,jta_sync_common.get_messages);

588: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
589: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
590: fnd_msg_pub.add;
591:
592: raise_application_error (-20100,jta_sync_common.get_messages);
593: END IF;
594:
595: CLOSE c_task;
596: RETURN l_task_id;

Line 624: raise_application_error (-20100,jta_sync_common.get_messages);

620: fnd_message.set_name('JTF', 'JTA_SYNC_TIMEZONEID_NOTFOUND');
621: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_TIMEZONE_ID');
622: fnd_msg_pub.add;
623:
624: raise_application_error (-20100,jta_sync_common.get_messages);
625:
626: END IF;
627:
628: CLOSE c_task_timezone;

Line 664: raise_application_error (-20100,jta_sync_common.get_messages);

660: fnd_message.set_name('JTF', 'JTA_SYNC_TASK_OVN_NOTFOUND');
661: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
662: fnd_msg_pub.add;
663:
664: raise_application_error (-20100,jta_sync_common.get_messages);
665: END IF;
666:
667: CLOSE c_tasks_ovn;
668: RETURN l_object_version_number;

Line 696: raise_application_error (-20100,jta_sync_common.get_messages);

692: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMT_OVN_NOTFOUND');
693: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OVN');
694: fnd_msg_pub.add;
695:
696: raise_application_error (-20100,jta_sync_common.get_messages);
697: END IF;
698:
699: CLOSE c_assignment_ovn;
700: RETURN l_object_version_number;

Line 728: raise_application_error (-20100,jta_sync_common.get_messages);

724: fnd_message.set_name('JTF', 'JTA_SYNC_RESOURCE_NOTFOUND');
725: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_RESOURCE_DETAILS');
726: fnd_msg_pub.add;
727:
728: raise_application_error (-20100,jta_sync_common.get_messages);
729: END IF;
730:
731: CLOSE c_resource;
732:

Line 1134: raise_application_error (-20100,jta_sync_common.get_messages);

1130: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_RECUR_RULE_ID');
1131: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1132: fnd_msg_pub.add;
1133:
1134: raise_application_error (-20100,jta_sync_common.get_messages);
1135: END IF;
1136:
1137: CLOSE c_recur_tasks;
1138:

Line 1148: raise_application_error (-20100,jta_sync_common.get_messages);

1144: fnd_message.set_name('JTF', 'JTA_SYNC_NULL_CALENDAR_ENDDATE');
1145: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_MAX_ENDDATE');
1146: fnd_msg_pub.add;
1147:
1148: raise_application_error (-20100,jta_sync_common.get_messages);
1149: END IF;
1150:
1151: RETURN l_date;
1152: END get_max_enddate;

Line 1530: raise_application_error (-20100,jta_sync_common.get_messages);

1526: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1527: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_ID');
1528: fnd_msg_pub.add;
1529:
1530: raise_application_error (-20100,jta_sync_common.get_messages);
1531: END IF;
1532:
1533: CLOSE c_assignment;
1534: RETURN l_task_assignment_id;

Line 1566: raise_application_error (-20100,jta_sync_common.get_messages);

1562: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGN_STSID_NOTFOUND');
1563: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_STATUS_ID');
1564: fnd_msg_pub.add;
1565:
1566: raise_application_error (-20100,jta_sync_common.get_messages);
1567: END IF;
1568:
1569: CLOSE c_assignment;
1570: RETURN l_assignment_status_id;

Line 1602: raise_application_error (-20100,jta_sync_common.get_messages);

1598: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1599: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_OWNER_INFO');
1600: fnd_msg_pub.add;
1601:
1602: raise_application_error (-20100,jta_sync_common.get_messages);
1603: END IF;
1604:
1605: CLOSE c_task;
1606: x_task_name := rec_task.task_name;

Line 1666: raise_application_error (-20100,jta_sync_common.get_messages);

1662: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1663: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ASSIGNMENT_INFO');
1664: fnd_msg_pub.add;
1665:
1666: raise_application_error (-20100,jta_sync_common.get_messages);
1667: END IF;
1668:
1669: CLOSE c_assignment;
1670:

Line 1720: raise_application_error (-20100,jta_sync_common.get_messages);

1716: fnd_message.set_name('JTF', 'JTA_SYNC_ACCESS_PRIV_NOTFOUND');
1717: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_ACCESS');
1718: fnd_msg_pub.add;
1719:
1720: raise_application_error (-20100,jta_sync_common.get_messages);
1721: END IF;
1722:
1723: CLOSE c_access;
1724: RETURN l_menu_name;

Line 1752: raise_application_error (-20100,jta_sync_common.get_messages);

1748: fnd_message.set_name('JTF', 'JTA_SYNC_NOTFOUND_TASKID');
1749: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SOURCE_OBJECT_TYPE');
1750: fnd_msg_pub.add;
1751:
1752: raise_application_error (-20100,jta_sync_common.get_messages);
1753: END IF;
1754:
1755: CLOSE c_source;
1756: RETURN l_source_object_type_code;

Line 1832: raise_application_error (-20100,jta_sync_common.get_messages);

1828: fnd_message.set_name('JTF', 'JTA_SYNC_ASSIGNMENT_NOTFOUND');
1829: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_SYNC_TYPE');
1830: fnd_msg_pub.add;
1831:
1832: raise_application_error (-20100,jta_sync_common.get_messages);
1833: END IF;
1834: CLOSE c_resource;
1835:
1836: END get_sync_info;

Line 2623: IF jta_sync_common.is_success (l_return_status)

2619: x_task_id => l_task_id
2620: );
2621: END IF;
2622:
2623: IF jta_sync_common.is_success (l_return_status)
2624: THEN
2625: --------------------------------------------
2626: -- Check whether it has a repeating information
2627: -- If it has, then create a recurrence

Line 2686: IF jta_sync_common.is_success (l_return_status)

2682: x_msg_data => l_msg_data
2683: );
2684:
2685:
2686: IF jta_sync_common.is_success (l_return_status)
2687: THEN
2688: -------------------------------------------------------
2689: -- Recurrences are successfully created.
2690: -------------------------------------------------------

Line 2703: jta_sync_common.put_messages_to_result (

2699: ELSE
2700: -------------------------------------------------------
2701: -- There are no exclusion tasks.
2702: -------------------------------------------------------
2703: jta_sync_common.put_messages_to_result (
2704: p_task_rec,
2705: p_status => g_sync_success,
2706: p_user_message => 'JTA_SYNC_SUCCESS'
2707: );

Line 2713: jta_sync_common.put_messages_to_result (

2709: ELSE
2710: -------------------------------------------------------
2711: -- Failed to create a task recurrence
2712: -------------------------------------------------------
2713: jta_sync_common.put_messages_to_result (
2714: p_task_rec,
2715: p_status => 2,
2716: p_user_message => 'JTA_RECURRENCE_CREATION_FAIL'
2717: );

Line 2724: jta_sync_common.put_messages_to_result (

2720: ELSE
2721: --------------------------------------------------------------------
2722: -- This is a Single Task and succeeded to create a single task
2723: --------------------------------------------------------------------
2724: jta_sync_common.put_messages_to_result (
2725: p_task_rec,
2726: p_status => g_sync_success,
2727: p_user_message => 'JTA_SYNC_SUCCESS'
2728: );

Line 2744: jta_sync_common.put_messages_to_result (

2740: ---------------------------------------------
2741: -- Failed to create a task
2742: ---------------------------------------------
2743:
2744: jta_sync_common.put_messages_to_result (
2745: p_task_rec,
2746: p_status => 2,
2747: p_user_message => 'JTA_SYNC_TASK_CREATION_FAILED'
2748: );

Line 2916: IF NOT jta_sync_common.is_success (l_return_status)

2912: x_msg_count => l_msg_count,
2913: x_msg_data => l_msg_data
2914: );
2915:
2916: IF NOT jta_sync_common.is_success (l_return_status)
2917: THEN-- Failed to update a task
2918: jta_sync_common.put_messages_to_result (
2919: p_task_rec,
2920: p_status => 2,

Line 2918: jta_sync_common.put_messages_to_result (

2914: );
2915:
2916: IF NOT jta_sync_common.is_success (l_return_status)
2917: THEN-- Failed to update a task
2918: jta_sync_common.put_messages_to_result (
2919: p_task_rec,
2920: p_status => 2,
2921: p_user_message => 'JTA_SYNC_UPDATE_RECUR_FAIL'
2922: );

Line 3002: IF NOT jta_sync_common.is_success (l_return_status)

2998: x_msg_data => l_msg_data
2999: );
3000: END IF;
3001:
3002: IF NOT jta_sync_common.is_success (l_return_status)
3003: THEN-- Failed to update a task
3004:
3005: jta_sync_common.put_messages_to_result (
3006: p_task_rec,

Line 3005: jta_sync_common.put_messages_to_result (

3001:
3002: IF NOT jta_sync_common.is_success (l_return_status)
3003: THEN-- Failed to update a task
3004:
3005: jta_sync_common.put_messages_to_result (
3006: p_task_rec,
3007: p_status => 2,
3008: p_user_message => 'JTA_SYNC_UPDATE_TASK_FAIL'
3009: ); -- l_return_status

Line 3037: IF NOT jta_sync_common.is_success (l_return_status)

3033: x_msg_count => l_msg_count,
3034: x_msg_data => l_msg_data
3035: );
3036:
3037: IF NOT jta_sync_common.is_success (l_return_status)
3038: THEN
3039: jta_sync_common.put_messages_to_result (
3040: p_task_rec,
3041: p_status => 2,

Line 3039: jta_sync_common.put_messages_to_result (

3035: );
3036:
3037: IF NOT jta_sync_common.is_success (l_return_status)
3038: THEN
3039: jta_sync_common.put_messages_to_result (
3040: p_task_rec,
3041: p_status => 2,
3042: p_user_message => 'JTA_SYNC_UPDATE_STS_FAIL'
3043: );

Line 3051: jta_sync_common.put_messages_to_result (

3047:
3048: -- Check the current status and update if it's succeeded
3049: IF nvl(p_task_rec.resultId,0) < 2
3050: THEN
3051: jta_sync_common.put_messages_to_result (
3052: p_task_rec,
3053: p_status => g_sync_success,
3054: p_user_message => 'JTA_SYNC_SUCCESS'
3055: );

Line 3099: IF jta_sync_common.is_success (l_return_status)

3095: x_msg_data => l_msg_data
3096: );
3097: END IF;
3098:
3099: IF jta_sync_common.is_success (l_return_status)
3100: THEN
3101: x_task_rec.syncanchor := convert_server_to_gmt (SYSDATE);
3102:
3103: jta_sync_common.put_messages_to_result (

Line 3103: jta_sync_common.put_messages_to_result (

3099: IF jta_sync_common.is_success (l_return_status)
3100: THEN
3101: x_task_rec.syncanchor := convert_server_to_gmt (SYSDATE);
3102:
3103: jta_sync_common.put_messages_to_result (
3104: x_task_rec,
3105: p_status => g_sync_success,
3106: p_user_message => 'JTA_SYNC_SUCCESS'
3107: );

Line 3109: jta_sync_common.put_messages_to_result (

3105: p_status => g_sync_success,
3106: p_user_message => 'JTA_SYNC_SUCCESS'
3107: );
3108: ELSE
3109: jta_sync_common.put_messages_to_result (
3110: x_task_rec,
3111: p_status => 2,
3112: p_user_message => 'JTA_SYNC_DELETE_EXCLUSION_FAIL'
3113: );

Line 3154: IF jta_sync_common.is_success (l_return_status)

3150: x_msg_data => l_msg_data
3151: );
3152: END IF;
3153:
3154: IF jta_sync_common.is_success (l_return_status)
3155: THEN
3156: p_task_rec.syncanchor := convert_server_to_gmt (SYSDATE + 1 / (24 * 60 * 60));
3157:
3158: IF p_delete_map_flag

Line 3165: jta_sync_common.put_messages_to_result (

3161: p_task_sync_id => p_task_rec.syncid
3162: );
3163: END IF;
3164:
3165: jta_sync_common.put_messages_to_result (
3166: p_task_rec,
3167: p_status => g_sync_success,
3168: p_user_message => 'JTA_SYNC_SUCCESS'
3169: );

Line 3171: jta_sync_common.put_messages_to_result (

3167: p_status => g_sync_success,
3168: p_user_message => 'JTA_SYNC_SUCCESS'
3169: );
3170: ELSE
3171: jta_sync_common.put_messages_to_result (
3172: p_task_rec,
3173: p_status => 2,
3174: p_user_message => 'JTA_SYNC_DELETE_TASK_FAILED'
3175: );

Line 3237: IF jta_sync_common.is_success (l_return_status)

3233: --p_enable_workflow => 'N',
3234: --p_abort_workflow => 'N'
3235: );
3236:
3237: IF jta_sync_common.is_success (l_return_status)
3238: THEN
3239: p_task_rec.syncanchor := convert_server_to_gmt(SYSDATE);
3240:
3241: jta_sync_common.put_messages_to_result (

Line 3241: jta_sync_common.put_messages_to_result (

3237: IF jta_sync_common.is_success (l_return_status)
3238: THEN
3239: p_task_rec.syncanchor := convert_server_to_gmt(SYSDATE);
3240:
3241: jta_sync_common.put_messages_to_result (
3242: p_task_rec,
3243: p_status => g_sync_success,
3244: p_user_message => 'JTA_SYNC_SUCCESS'
3245: );

Line 3249: jta_sync_common.put_messages_to_result (

3245: );
3246:
3247: jta_sync_task_map_pkg.delete_row(p_task_sync_id => p_task_rec.syncid);
3248: ELSE
3249: jta_sync_common.put_messages_to_result (
3250: p_task_rec,
3251: p_status => 2,
3252: p_user_message => 'JTA_SYNC_UPDATE_STS_FAIL'
3253: );

Line 3506: raise_application_error (-20100,jta_sync_common.get_messages);

3502: fnd_message.set_name('JTF', 'JTA_SYNC_INVALID_SYNCID');
3503: fnd_message.set_token('PROC_NAME','JTA_SYNC_TASK_COMMON.GET_TASK_ID');
3504: fnd_msg_pub.add;
3505:
3506: raise_application_error (-20100,jta_sync_common.get_messages);
3507: END IF;
3508: ---------------------------------
3509:
3510: OPEN c_mapping (p_syncid);