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_ASSIGNMENTS_PKG dependencies on FND_API

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

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

Line 110: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 111: RAISE fnd_api.g_exc_unexpected_error;

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

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

237: close c;
238:
239: jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
240:
241: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
242: THEN
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;

Line 243: x_return_status := fnd_api.g_ret_sts_unexp_error;

239: jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
240:
241: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
242: THEN
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;
246:
247:

Line 244: RAISE fnd_api.g_exc_unexpected_error;

240:
241: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
242: THEN
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;
246:
247:
248: end INSERT_ROW;

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

339: x_return_status varchar2(1);
340: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
341: := x_assignee_role;
342: begin
343: if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then
344: l_assignee_role := 'ASSIGNEE';
345: end if;
346:
347: -- Added by SBARAT on 27/01/2006 for bug# 4661006

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

380: jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
381:
382: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
383:
384: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: RAISE fnd_api.g_exc_unexpected_error;
388: END IF;

Line 386: x_return_status := fnd_api.g_ret_sts_unexp_error;

382: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
383:
384: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: RAISE fnd_api.g_exc_unexpected_error;
388: END IF;
389:
390: update jtf_task_all_assignments set

Line 387: RAISE fnd_api.g_exc_unexpected_error;

383:
384: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: RAISE fnd_api.g_exc_unexpected_error;
388: END IF;
389:
390: update jtf_task_all_assignments set
391: SCHED_TRAVEL_DURATION_UOM = X_SCHED_TRAVEL_DURATION_UOM,

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

433: RESOURCE_TERRITORY_ID = X_RESOURCE_TERRITORY_ID,
434: ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
435: SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID,
436: ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
437: SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
438: CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
439: FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
440: BOOKING_START_DATE = X_BOOKING_START_DATE,
441: BOOKING_END_DATE = X_BOOKING_END_DATE,

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

434: ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
435: SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID,
436: ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
437: SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
438: CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
439: FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
440: BOOKING_START_DATE = X_BOOKING_START_DATE,
441: BOOKING_END_DATE = X_BOOKING_END_DATE,
442: OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID

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

447: end if;
448:
449: jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
450:
451: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
452: THEN
453: x_return_status := fnd_api.g_ret_sts_unexp_error;
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;

Line 453: x_return_status := fnd_api.g_ret_sts_unexp_error;

449: jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
450:
451: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
452: THEN
453: x_return_status := fnd_api.g_ret_sts_unexp_error;
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:
457:

Line 454: RAISE fnd_api.g_exc_unexpected_error;

450:
451: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
452: THEN
453: x_return_status := fnd_api.g_ret_sts_unexp_error;
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:
457:
458: end UPDATE_ROW;

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

467: jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
468:
469: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
470: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
471: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
472: THEN
473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;

Line 473: x_return_status := fnd_api.g_ret_sts_unexp_error;

469: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
470: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
471: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
472: THEN
473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;
476: delete from jtf_task_all_assignments
477: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;

Line 474: RAISE fnd_api.g_exc_unexpected_error;

470: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
471: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
472: THEN
473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;
476: delete from jtf_task_all_assignments
477: where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
478:

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

479: if (sql%notfound) then
480: raise no_data_found;
481: end if;
482: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
483: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
484: THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: RAISE fnd_api.g_exc_unexpected_error;
487: END IF;

Line 485: x_return_status := fnd_api.g_ret_sts_unexp_error;

481: end if;
482: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
483: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
484: THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: RAISE fnd_api.g_exc_unexpected_error;
487: END IF;
488:
489: end DELETE_ROW;

Line 486: RAISE fnd_api.g_exc_unexpected_error;

482: jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
483: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
484: THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: RAISE fnd_api.g_exc_unexpected_error;
487: END IF;
488:
489: end DELETE_ROW;
490: end ;