DBA Data[Home] [Help]

APPS.JTF_TASK_ASSIGNMENTS_PKG dependencies on FND_API

Line 111: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

107: jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
108:
109: jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
110:
111: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
112: THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;

Line 113: x_return_status := fnd_api.g_ret_sts_unexp_error;

109: jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
110:
111: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
112: THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
116: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
117: IF(l_enable_audit = 'Y') THEN

Line 114: RAISE fnd_api.g_exc_unexpected_error;

110:
111: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
112: THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
116: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
117: IF(l_enable_audit = 'Y') THEN
118: jtf_task_assignment_audit_pkg.create_task_assignment_audit(

Line 120: p_init_msg_list => fnd_api.g_false,

116: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
117: IF(l_enable_audit = 'Y') THEN
118: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
119: p_api_version => 1,
120: p_init_msg_list => fnd_api.g_false,
121: p_commit => fnd_api.g_false,
122: p_object_version_number => 1,
123: p_task_id => x_task_id,
124: p_task_assignment_id => x_task_assignment_id,

Line 121: p_commit => fnd_api.g_false,

117: IF(l_enable_audit = 'Y') THEN
118: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
119: p_api_version => 1,
120: p_init_msg_list => fnd_api.g_false,
121: p_commit => fnd_api.g_false,
122: p_object_version_number => 1,
123: p_task_id => x_task_id,
124: p_task_assignment_id => x_task_assignment_id,
125: p_new_resource_type_code => x_resource_type_code,

Line 280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

276: close c;
277:
278: jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: RAISE fnd_api.g_exc_unexpected_error;
284: END IF;

Line 282: x_return_status := fnd_api.g_ret_sts_unexp_error;

278: jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: RAISE fnd_api.g_exc_unexpected_error;
284: END IF;
285:
286:

Line 283: RAISE fnd_api.g_exc_unexpected_error;

279:
280: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281: THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: RAISE fnd_api.g_exc_unexpected_error;
284: END IF;
285:
286:
287: end INSERT_ROW;

Line 385: if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then

381: l_enable_audit varchar2(5);
382: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
383: := x_assignee_role;
384: begin
385: if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then
386: l_assignee_role := 'ASSIGNEE';
387: end if;
388:
389: -- Added by SBARAT on 27/01/2006 for bug# 4661006

Line 426: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

422: jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
423:
424: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
425:
426: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
427: THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: RAISE fnd_api.g_exc_unexpected_error;
430: END IF;

Line 428: x_return_status := fnd_api.g_ret_sts_unexp_error;

424: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
425:
426: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
427: THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: RAISE fnd_api.g_exc_unexpected_error;
430: END IF;
431:
432: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));

Line 429: RAISE fnd_api.g_exc_unexpected_error;

425:
426: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
427: THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: RAISE fnd_api.g_exc_unexpected_error;
430: END IF;
431:
432: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
433: IF(l_enable_audit = 'Y') THEN

Line 436: p_init_msg_list => fnd_api.g_false,

432: l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
433: IF(l_enable_audit = 'Y') THEN
434: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
435: p_api_version => 1,
436: p_init_msg_list => fnd_api.g_false,
437: p_commit => fnd_api.g_false,
438: p_object_version_number => 1,
439: p_task_id => x_task_id,
440: p_task_assignment_id => x_task_assignment_id,

Line 437: p_commit => fnd_api.g_false,

433: IF(l_enable_audit = 'Y') THEN
434: jtf_task_assignment_audit_pkg.create_task_assignment_audit(
435: p_api_version => 1,
436: p_init_msg_list => fnd_api.g_false,
437: p_commit => fnd_api.g_false,
438: p_object_version_number => 1,
439: p_task_id => x_task_id,
440: p_task_assignment_id => x_task_assignment_id,
441: p_new_resource_type_code => x_resource_type_code,

Line 519: SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),

515: RESOURCE_TERRITORY_ID = X_RESOURCE_TERRITORY_ID,
516: ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
517: SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID,
518: ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
519: SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
520: CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
521: FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
522: BOOKING_START_DATE = X_BOOKING_START_DATE,
523: BOOKING_END_DATE = X_BOOKING_END_DATE,

Line 520: CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),

516: ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
517: SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID,
518: ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
519: SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
520: CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
521: FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
522: BOOKING_START_DATE = X_BOOKING_START_DATE,
523: BOOKING_END_DATE = X_BOOKING_END_DATE,
524: OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID

Line 533: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

529: end if;
530:
531: jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
532:
533: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
534: THEN
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;

Line 535: x_return_status := fnd_api.g_ret_sts_unexp_error;

531: jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
532:
533: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
534: THEN
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:
539:

Line 536: RAISE fnd_api.g_exc_unexpected_error;

532:
533: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
534: THEN
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:
539:
540: end UPDATE_ROW;

Line 554: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

550: jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
551:
552: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
553: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
554: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
555: THEN
556: x_return_status := fnd_api.g_ret_sts_unexp_error;
557: RAISE fnd_api.g_exc_unexpected_error;
558: END IF;

Line 556: x_return_status := fnd_api.g_ret_sts_unexp_error;

552: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
553: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
554: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
555: THEN
556: x_return_status := fnd_api.g_ret_sts_unexp_error;
557: RAISE fnd_api.g_exc_unexpected_error;
558: END IF;
559: delete from jtf_task_all_assignments
560: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;

Line 557: RAISE fnd_api.g_exc_unexpected_error;

553: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
554: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
555: THEN
556: x_return_status := fnd_api.g_ret_sts_unexp_error;
557: RAISE fnd_api.g_exc_unexpected_error;
558: END IF;
559: delete from jtf_task_all_assignments
560: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
561:

Line 574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

570: );
571: END IF;
572:
573: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
575: THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;

Line 576: x_return_status := fnd_api.g_ret_sts_unexp_error;

572:
573: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
575: THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;
579:
580: end DELETE_ROW;

Line 577: RAISE fnd_api.g_exc_unexpected_error;

573: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
574: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
575: THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;
579:
580: end DELETE_ROW;
581: end ;