[Home] [Help]
1: PACKAGE BODY jtf_task_assignments_pub AS
2: /* $Header: jtfptkab.pls 120.1 2005/07/02 00:58:27 appldev ship $ */
3: PROCEDURE create_task_assignment (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_task_assignment_id IN NUMBER DEFAULT NULL,
8: p_task_id IN NUMBER DEFAULT NULL,
9: p_task_number IN VARCHAR2 DEFAULT NULL,
2: /* $Header: jtfptkab.pls 120.1 2005/07/02 00:58:27 appldev ship $ */
3: PROCEDURE create_task_assignment (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_task_assignment_id IN NUMBER DEFAULT NULL,
8: p_task_id IN NUMBER DEFAULT NULL,
9: p_task_number IN VARCHAR2 DEFAULT NULL,
10: p_task_name IN VARCHAR2 DEFAULT NULL,
130: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
131:
132: BEGIN
133: SAVEPOINT create_task_assignment_pub;
134: x_return_status := fnd_api.g_ret_sts_success;
135:
136: IF NOT fnd_api.compatible_api_call (
137: l_api_version,
138: p_api_version,
132: BEGIN
133: SAVEPOINT create_task_assignment_pub;
134: x_return_status := fnd_api.g_ret_sts_success;
135:
136: IF NOT fnd_api.compatible_api_call (
137: l_api_version,
138: p_api_version,
139: l_api_name,
140: g_pkg_name
139: l_api_name,
140: g_pkg_name
141: )
142: THEN
143: RAISE fnd_api.g_exc_unexpected_error;
144: END IF;
145:
146: IF fnd_api.to_boolean (p_init_msg_list)
147: THEN
142: THEN
143: RAISE fnd_api.g_exc_unexpected_error;
144: END IF;
145:
146: IF fnd_api.to_boolean (p_init_msg_list)
147: THEN
148: fnd_msg_pub.initialize;
149: END IF;
150:
181:
182:
183: jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
184:
185: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
186: THEN
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: RAISE fnd_api.g_exc_unexpected_error;
189: END IF;
183: jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
184:
185: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
186: THEN
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: RAISE fnd_api.g_exc_unexpected_error;
189: END IF;
190: */
191: -------------
184:
185: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
186: THEN
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: RAISE fnd_api.g_exc_unexpected_error;
189: END IF;
190: */
191: -------------
192: -------------
203: p_task_number => l_task_number,
204: x_task_id => l_task_id
205: );
206:
207: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
208: THEN
209: x_return_status := fnd_api.g_ret_sts_unexp_error;
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
205: );
206:
207: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
208: THEN
209: x_return_status := fnd_api.g_ret_sts_unexp_error;
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
212:
213: IF l_task_id IS NULL
206:
207: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
208: THEN
209: x_return_status := fnd_api.g_ret_sts_unexp_error;
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
212:
213: IF l_task_id IS NULL
214: THEN
211: END IF;
212:
213: IF l_task_id IS NULL
214: THEN
215: x_return_status := fnd_api.g_ret_sts_unexp_error;
216: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
217: fnd_msg_pub.add;
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
214: THEN
215: x_return_status := fnd_api.g_ret_sts_unexp_error;
216: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
217: fnd_msg_pub.add;
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:
221: -----
222: ----- Validate the assigned resource.
228: x_owner_id => l_resource_id,
229: x_owner_type_code => l_resource_type_code
230: );
231:
232: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
233: THEN
234: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
235: fnd_msg_pub.add;
236: RAISE fnd_api.g_exc_unexpected_error;
232: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
233: THEN
234: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
235: fnd_msg_pub.add;
236: RAISE fnd_api.g_exc_unexpected_error;
237: END IF;
238:
239: IF l_resource_type_code IS NULL
240: THEN
237: END IF;
238:
239: IF l_resource_type_code IS NULL
240: THEN
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
243: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
244: fnd_msg_pub.add;
245: RAISE fnd_api.g_exc_unexpected_error;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
243: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
244: fnd_msg_pub.add;
245: RAISE fnd_api.g_exc_unexpected_error;
246: END IF;
247:
248: IF l_resource_id IS NULL
249: THEN
246: END IF;
247:
248: IF l_resource_id IS NULL
249: THEN
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_RES_ID');
252: fnd_msg_pub.add;
253: RAISE fnd_api.g_exc_unexpected_error;
254: END IF;
249: THEN
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_RES_ID');
252: fnd_msg_pub.add;
253: RAISE fnd_api.g_exc_unexpected_error;
254: END IF;
255:
256: -----
257: ----- Validate Assignment Status Id
267: IF l_assignment_status_id IS NULL
268: THEN
269: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK_STATUS');
270: fnd_msg_pub.add;
271: RAISE fnd_api.g_exc_unexpected_error;
272: END IF;
273:
274: -------
275: ------- Validate actual effort
287: p_effort => l_act_eff,
288: p_effort_uom => l_act_eff_uom
289: );
290:
291: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
292: THEN
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
289: );
290:
291: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
292: THEN
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296:
297: -------
290:
291: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
292: THEN
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296:
297: -------
298: ------- Validate Sched. Travel Duration
310: p_effort => l_sched_travel_duration,
311: p_effort_uom => l_sched_travel_dur_uom
312: );
313:
314: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
315: THEN
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: RAISE fnd_api.g_exc_unexpected_error;
318: END IF;
312: );
313:
314: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
315: THEN
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: RAISE fnd_api.g_exc_unexpected_error;
318: END IF;
319:
320: -------
313:
314: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
315: THEN
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: RAISE fnd_api.g_exc_unexpected_error;
318: END IF;
319:
320: -------
321: ------- Validate Actual Travel Duration
333: p_effort => l_actual_travel_duration,
334: p_effort_uom => l_actual_travel_dur_uom
335: );
336:
337: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
338: THEN
339: x_return_status := fnd_api.g_ret_sts_unexp_error;
340: RAISE fnd_api.g_exc_unexpected_error;
341: END IF;
335: );
336:
337: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
338: THEN
339: x_return_status := fnd_api.g_ret_sts_unexp_error;
340: RAISE fnd_api.g_exc_unexpected_error;
341: END IF;
342:
343: -------
336:
337: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
338: THEN
339: x_return_status := fnd_api.g_ret_sts_unexp_error;
340: RAISE fnd_api.g_exc_unexpected_error;
341: END IF;
342:
343: -------
344: ------- Validate Actual Travel Distance
351: ),
352: x_return_status => x_return_status
353: );
354:
355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
356: THEN
357: x_return_status := fnd_api.g_ret_sts_unexp_error;
358: RAISE fnd_api.g_exc_unexpected_error;
359: END IF;
353: );
354:
355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
356: THEN
357: x_return_status := fnd_api.g_ret_sts_unexp_error;
358: RAISE fnd_api.g_exc_unexpected_error;
359: END IF;
360:
361: -------
354:
355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
356: THEN
357: x_return_status := fnd_api.g_ret_sts_unexp_error;
358: RAISE fnd_api.g_exc_unexpected_error;
359: END IF;
360:
361: -------
362: ------- Validate Schedule Travel Distance
369: ),
370: x_return_status => x_return_status
371: );
372:
373: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
371: );
372:
373: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379: -------
372:
373: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378:
379: -------
380: ------- Validate Schedule Flag
387: ),
388: p_flag_value => l_schedule_flag
389: );
390:
391: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
392: THEN
393: x_return_status := fnd_api.g_ret_sts_unexp_error;
394: RAISE fnd_api.g_exc_unexpected_error;
395: END IF;
389: );
390:
391: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
392: THEN
393: x_return_status := fnd_api.g_ret_sts_unexp_error;
394: RAISE fnd_api.g_exc_unexpected_error;
395: END IF;
396:
397: -------
390:
391: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
392: THEN
393: x_return_status := fnd_api.g_ret_sts_unexp_error;
394: RAISE fnd_api.g_exc_unexpected_error;
395: END IF;
396:
397: -------
398: ------- Validate Alarm Type Code and Alarm Contact FND_LOOKUPS
403: p_alarm_type_code => l_alarm_type_code,
404: x_return_status => x_return_status
405: );
406:
407: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
408: THEN
409: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_TYPE');
410: fnd_message.set_token ('ALARM_TYPE_CODE', p_alarm_type_code);
411: fnd_msg_pub.add;
408: THEN
409: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_TYPE');
410: fnd_message.set_token ('ALARM_TYPE_CODE', p_alarm_type_code);
411: fnd_msg_pub.add;
412: RAISE fnd_api.g_exc_unexpected_error;
413: END IF;
414: ELSIF l_alarm_type_code IS NULL
415: AND l_alarm_contact IS NOT NULL
416: THEN
413: END IF;
414: ELSIF l_alarm_type_code IS NULL
415: AND l_alarm_contact IS NOT NULL
416: THEN
417: x_return_status := fnd_api.g_ret_sts_unexp_error;
418: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_CON');
419: fnd_message.set_token ('ALARM_CONTACT', p_alarm_contact);
420: fnd_msg_pub.add;
421: RAISE fnd_api.g_exc_unexpected_error;
417: x_return_status := fnd_api.g_ret_sts_unexp_error;
418: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_CON');
419: fnd_message.set_token ('ALARM_CONTACT', p_alarm_contact);
420: fnd_msg_pub.add;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423: */
424: -------
425: ------- Validate the flags.
432: ),
433: p_flag_value => l_palm_flag
434: );
435:
436: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
437: THEN
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: RAISE fnd_api.g_exc_unexpected_error;
440: END IF;
434: );
435:
436: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
437: THEN
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: RAISE fnd_api.g_exc_unexpected_error;
440: END IF;
441:
442: jtf_task_utl.validate_flag (
435:
436: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
437: THEN
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: RAISE fnd_api.g_exc_unexpected_error;
440: END IF;
441:
442: jtf_task_utl.validate_flag (
443: x_return_status => x_return_status,
447: ),
448: p_flag_value => l_wince_flag
449: );
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;
449: );
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: jtf_task_utl.validate_flag (
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: jtf_task_utl.validate_flag (
458: x_return_status => x_return_status,
462: ),
463: p_flag_value => l_laptop_flag
464: );
465:
466: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
467: THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
464: );
465:
466: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
467: THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471:
472: jtf_task_utl.validate_flag (
465:
466: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
467: THEN
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471:
472: jtf_task_utl.validate_flag (
473: x_return_status => x_return_status,
477: ),
478: p_flag_value => l_device1_flag
479: );
480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
482: THEN
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
479: );
480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
482: THEN
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486:
487: jtf_task_utl.validate_flag (
480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
482: THEN
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486:
487: jtf_task_utl.validate_flag (
488: x_return_status => x_return_status,
492: ),
493: p_flag_value => l_device2_flag
494: );
495:
496: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
497: THEN
498: x_return_status := fnd_api.g_ret_sts_unexp_error;
499: RAISE fnd_api.g_exc_unexpected_error;
500: END IF;
494: );
495:
496: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
497: THEN
498: x_return_status := fnd_api.g_ret_sts_unexp_error;
499: RAISE fnd_api.g_exc_unexpected_error;
500: END IF;
501:
502: jtf_task_utl.validate_flag (
495:
496: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
497: THEN
498: x_return_status := fnd_api.g_ret_sts_unexp_error;
499: RAISE fnd_api.g_exc_unexpected_error;
500: END IF;
501:
502: jtf_task_utl.validate_flag (
503: x_return_status => x_return_status,
507: ),
508: p_flag_value => l_device3_flag
509: );
510:
511: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
512: THEN
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514: RAISE fnd_api.g_exc_unexpected_error;
515: END IF;
509: );
510:
511: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
512: THEN
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514: RAISE fnd_api.g_exc_unexpected_error;
515: END IF;
516:
517: -- Validate the code in ON_SHOW_CALENDAR
510:
511: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
512: THEN
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514: RAISE fnd_api.g_exc_unexpected_error;
515: END IF;
516:
517: -- Validate the code in ON_SHOW_CALENDAR
518: jtf_task_utl.validate_flag (
523: ),
524: p_flag_value => l_show_on_calendar
525: );
526:
527: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
528: THEN
529: x_return_status := fnd_api.g_ret_sts_unexp_error;
530: RAISE fnd_api.g_exc_unexpected_error;
531: END IF;
525: );
526:
527: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
528: THEN
529: x_return_status := fnd_api.g_ret_sts_unexp_error;
530: RAISE fnd_api.g_exc_unexpected_error;
531: END IF;
532:
533: -- Validate the value in category_id
526:
527: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
528: THEN
529: x_return_status := fnd_api.g_ret_sts_unexp_error;
530: RAISE fnd_api.g_exc_unexpected_error;
531: END IF;
532:
533: -- Validate the value in category_id
534: IF jtf_task_utl.g_validate_category = TRUE
537: p_category_id => l_category_id,
538: x_return_status => x_return_status
539: );
540:
541: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
542: THEN
543: x_return_status := fnd_api.g_ret_sts_unexp_error;
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
539: );
540:
541: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
542: THEN
543: x_return_status := fnd_api.g_ret_sts_unexp_error;
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: END IF;
547:
540:
541: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
542: THEN
543: x_return_status := fnd_api.g_ret_sts_unexp_error;
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: END IF;
547:
548: -----
558: 'JTF_TASK_TRANSLATED_MESSAGES',
559: 'SHIFT_CONSTRUCT_ID')
560: );
561: fnd_msg_pub.add;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564: END IF;
565:
566: ----
576: p_end_date => l_actual_end_date,
577: x_return_status => x_return_status
578: );
579:
580: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
581: THEN
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
578: );
579:
580: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
581: THEN
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
585:
586: ------
579:
580: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
581: THEN
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
585:
586: ------
587: ------ Call the private api.
587: ------ Call the private api.
588: ------
589: jtf_task_assignments_pvt.create_task_assignment (
590: p_api_version => l_api_version,
591: p_init_msg_list => fnd_api.g_false,
592: p_commit => fnd_api.g_false,
593: p_task_assignment_id => p_task_assignment_id,
594: p_task_id => l_task_id,
595: p_resource_type_code => l_resource_type_code,
588: ------
589: jtf_task_assignments_pvt.create_task_assignment (
590: p_api_version => l_api_version,
591: p_init_msg_list => fnd_api.g_false,
592: p_commit => fnd_api.g_false,
593: p_task_assignment_id => p_task_assignment_id,
594: p_task_id => l_task_id,
595: p_resource_type_code => l_resource_type_code,
596: p_resource_id => l_resource_id,
644: p_free_busy_type => p_free_busy_type,
645: p_object_capacity_id => p_object_capacity_id
646: );
647:
648: IF (x_return_status = fnd_api.g_ret_sts_error)
649: THEN
650: RAISE fnd_api.g_exc_error;
651: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
652: THEN
646: );
647:
648: IF (x_return_status = fnd_api.g_ret_sts_error)
649: THEN
650: RAISE fnd_api.g_exc_error;
651: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
652: THEN
653: RAISE fnd_api.g_exc_unexpected_error;
654: END IF;
647:
648: IF (x_return_status = fnd_api.g_ret_sts_error)
649: THEN
650: RAISE fnd_api.g_exc_error;
651: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
652: THEN
653: RAISE fnd_api.g_exc_unexpected_error;
654: END IF;
655:
649: THEN
650: RAISE fnd_api.g_exc_error;
651: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
652: THEN
653: RAISE fnd_api.g_exc_unexpected_error;
654: END IF;
655:
656: p_task_assignments_user_hooks.task_assignment_id :=
657: x_task_assignment_id;
657: x_task_assignment_id;
658:
659: /*--jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
660:
661: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
662: THEN
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: RAISE fnd_api.g_exc_unexpected_error;
665: END IF;
659: /*--jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
660:
661: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
662: THEN
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: RAISE fnd_api.g_exc_unexpected_error;
665: END IF;
666: */
667: IF fnd_api.to_boolean (p_commit)
660:
661: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
662: THEN
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: RAISE fnd_api.g_exc_unexpected_error;
665: END IF;
666: */
667: IF fnd_api.to_boolean (p_commit)
668: THEN
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: RAISE fnd_api.g_exc_unexpected_error;
665: END IF;
666: */
667: IF fnd_api.to_boolean (p_commit)
668: THEN
669: COMMIT WORK;
670: END IF;
671:
670: END IF;
671:
672: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
673: EXCEPTION
674: WHEN fnd_api.g_exc_error
675: THEN
676: ROLLBACK TO create_task_assignment_pub;
677: x_return_status := fnd_api.g_ret_sts_error;
678: fnd_msg_pub.count_and_get (
673: EXCEPTION
674: WHEN fnd_api.g_exc_error
675: THEN
676: ROLLBACK TO create_task_assignment_pub;
677: x_return_status := fnd_api.g_ret_sts_error;
678: fnd_msg_pub.count_and_get (
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
678: fnd_msg_pub.count_and_get (
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
682: WHEN fnd_api.g_exc_unexpected_error
683: THEN
684: ROLLBACK TO create_task_assignment_pub;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: fnd_msg_pub.count_and_get (
681: );
682: WHEN fnd_api.g_exc_unexpected_error
683: THEN
684: ROLLBACK TO create_task_assignment_pub;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: fnd_msg_pub.count_and_get (
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );
689: );
690: WHEN OTHERS
691: THEN
692: ROLLBACK TO create_task_assignment_pub;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: /* if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
695: then
696: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name) ;
697: end if ;*/
704:
705:
706: PROCEDURE create_task_assignment (
707: p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
709: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
710: p_task_assignment_id IN NUMBER DEFAULT NULL,
711: p_task_id IN NUMBER DEFAULT NULL,
712: p_task_number IN VARCHAR2 DEFAULT NULL,
705:
706: PROCEDURE create_task_assignment (
707: p_api_version IN NUMBER,
708: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
709: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
710: p_task_assignment_id IN NUMBER DEFAULT NULL,
711: p_task_id IN NUMBER DEFAULT NULL,
712: p_task_number IN VARCHAR2 DEFAULT NULL,
713: p_task_name IN VARCHAR2 DEFAULT NULL,
831:
832: --overloading create procedure
833: PROCEDURE create_task_assignment (
834: p_api_version IN NUMBER,
835: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
836: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
837: p_task_assignment_id IN NUMBER DEFAULT NULL,
838: p_task_id IN NUMBER DEFAULT NULL,
839: p_task_number IN VARCHAR2 DEFAULT NULL,
832: --overloading create procedure
833: PROCEDURE create_task_assignment (
834: p_api_version IN NUMBER,
835: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
836: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
837: p_task_assignment_id IN NUMBER DEFAULT NULL,
838: p_task_id IN NUMBER DEFAULT NULL,
839: p_task_number IN VARCHAR2 DEFAULT NULL,
840: p_task_name IN VARCHAR2 DEFAULT NULL,
953:
954: --overloading create procedure
955: PROCEDURE create_task_assignment (
956: p_api_version IN NUMBER,
957: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
958: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
959: p_task_assignment_id IN NUMBER DEFAULT NULL,
960: p_task_id IN NUMBER DEFAULT NULL,
961: p_task_number IN VARCHAR2 DEFAULT NULL,
954: --overloading create procedure
955: PROCEDURE create_task_assignment (
956: p_api_version IN NUMBER,
957: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
958: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
959: p_task_assignment_id IN NUMBER DEFAULT NULL,
960: p_task_id IN NUMBER DEFAULT NULL,
961: p_task_number IN VARCHAR2 DEFAULT NULL,
962: p_task_name IN VARCHAR2 DEFAULT NULL,
1072:
1073:
1074: PROCEDURE lock_task_assignment (
1075: p_api_version IN NUMBER,
1076: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1077: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1078: p_task_assignment_id IN NUMBER,
1079: p_object_version_number IN NUMBER,
1080: x_return_status OUT NOCOPY VARCHAR2,
1073:
1074: PROCEDURE lock_task_assignment (
1075: p_api_version IN NUMBER,
1076: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1077: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1078: p_task_assignment_id IN NUMBER,
1079: p_object_version_number IN NUMBER,
1080: x_return_status OUT NOCOPY VARCHAR2,
1081: x_msg_data OUT NOCOPY VARCHAR2,
1087: resource_locked EXCEPTION;
1088: PRAGMA EXCEPTION_INIT (resource_locked, -54);
1089: BEGIN
1090: SAVEPOINT lock_task_assignment_pub;
1091: x_return_status := fnd_api.g_ret_sts_success;
1092:
1093: IF NOT fnd_api.compatible_api_call (
1094: l_api_version,
1095: p_api_version,
1089: BEGIN
1090: SAVEPOINT lock_task_assignment_pub;
1091: x_return_status := fnd_api.g_ret_sts_success;
1092:
1093: IF NOT fnd_api.compatible_api_call (
1094: l_api_version,
1095: p_api_version,
1096: l_api_name,
1097: g_pkg_name
1096: l_api_name,
1097: g_pkg_name
1098: )
1099: THEN
1100: RAISE fnd_api.g_exc_unexpected_error;
1101: END IF;
1102:
1103: IF fnd_api.to_boolean (p_init_msg_list)
1104: THEN
1099: THEN
1100: RAISE fnd_api.g_exc_unexpected_error;
1101: END IF;
1102:
1103: IF fnd_api.to_boolean (p_init_msg_list)
1104: THEN
1105: fnd_msg_pub.initialize;
1106: END IF;
1107:
1104: THEN
1105: fnd_msg_pub.initialize;
1106: END IF;
1107:
1108: x_return_status := fnd_api.g_ret_sts_success;
1109: jtf_task_assignments_pkg.lock_row (
1110: x_task_assignment_id => p_task_assignment_id,
1111: x_object_version_number => p_object_version_number
1112: );
1117: ROLLBACK TO lock_task_assignment_pub;
1118: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
1119: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Assignments');
1120: fnd_msg_pub.add;
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122: fnd_msg_pub.count_and_get (
1123: p_count => x_msg_count,
1124: p_data => x_msg_data
1125: );
1122: fnd_msg_pub.count_and_get (
1123: p_count => x_msg_count,
1124: p_data => x_msg_data
1125: );
1126: WHEN fnd_api.g_exc_unexpected_error
1127: THEN
1128: ROLLBACK TO lock_task_assignment_pub;
1129: x_return_status := fnd_api.g_ret_sts_unexp_error;
1130: fnd_msg_pub.count_and_get (
1125: );
1126: WHEN fnd_api.g_exc_unexpected_error
1127: THEN
1128: ROLLBACK TO lock_task_assignment_pub;
1129: x_return_status := fnd_api.g_ret_sts_unexp_error;
1130: fnd_msg_pub.count_and_get (
1131: p_count => x_msg_count,
1132: p_data => x_msg_data
1133: );
1136: ROLLBACK TO lock_task_assignment_pub;
1137: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1138: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1139: fnd_msg_pub.add;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141: fnd_msg_pub.count_and_get (
1142: p_count => x_msg_count,
1143: p_data => x_msg_data
1144: );
1146:
1147: PROCEDURE update_task_assignment (
1148: p_api_version IN NUMBER,
1149: p_object_version_number IN OUT NOCOPY NUMBER,
1150: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1151: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1152: p_task_assignment_id IN NUMBER,
1153: p_task_id IN NUMBER
1154: DEFAULT fnd_api.g_miss_num,
1147: PROCEDURE update_task_assignment (
1148: p_api_version IN NUMBER,
1149: p_object_version_number IN OUT NOCOPY NUMBER,
1150: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1151: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1152: p_task_assignment_id IN NUMBER,
1153: p_task_id IN NUMBER
1154: DEFAULT fnd_api.g_miss_num,
1155: p_task_number IN VARCHAR2
1150: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1151: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1152: p_task_assignment_id IN NUMBER,
1153: p_task_id IN NUMBER
1154: DEFAULT fnd_api.g_miss_num,
1155: p_task_number IN VARCHAR2
1156: DEFAULT fnd_api.g_miss_char,
1157: p_task_name IN VARCHAR2
1158: DEFAULT fnd_api.g_miss_char,
1152: p_task_assignment_id IN NUMBER,
1153: p_task_id IN NUMBER
1154: DEFAULT fnd_api.g_miss_num,
1155: p_task_number IN VARCHAR2
1156: DEFAULT fnd_api.g_miss_char,
1157: p_task_name IN VARCHAR2
1158: DEFAULT fnd_api.g_miss_char,
1159: p_resource_type_code IN VARCHAR2
1160: DEFAULT fnd_api.g_miss_char,
1154: DEFAULT fnd_api.g_miss_num,
1155: p_task_number IN VARCHAR2
1156: DEFAULT fnd_api.g_miss_char,
1157: p_task_name IN VARCHAR2
1158: DEFAULT fnd_api.g_miss_char,
1159: p_resource_type_code IN VARCHAR2
1160: DEFAULT fnd_api.g_miss_char,
1161: p_resource_id IN NUMBER
1162: DEFAULT fnd_api.g_miss_num,
1156: DEFAULT fnd_api.g_miss_char,
1157: p_task_name IN VARCHAR2
1158: DEFAULT fnd_api.g_miss_char,
1159: p_resource_type_code IN VARCHAR2
1160: DEFAULT fnd_api.g_miss_char,
1161: p_resource_id IN NUMBER
1162: DEFAULT fnd_api.g_miss_num,
1163: p_resource_name IN VARCHAR2
1164: DEFAULT fnd_api.g_miss_char,
1158: DEFAULT fnd_api.g_miss_char,
1159: p_resource_type_code IN VARCHAR2
1160: DEFAULT fnd_api.g_miss_char,
1161: p_resource_id IN NUMBER
1162: DEFAULT fnd_api.g_miss_num,
1163: p_resource_name IN VARCHAR2
1164: DEFAULT fnd_api.g_miss_char,
1165: p_actual_effort IN NUMBER
1166: DEFAULT fnd_api.g_miss_num,
1160: DEFAULT fnd_api.g_miss_char,
1161: p_resource_id IN NUMBER
1162: DEFAULT fnd_api.g_miss_num,
1163: p_resource_name IN VARCHAR2
1164: DEFAULT fnd_api.g_miss_char,
1165: p_actual_effort IN NUMBER
1166: DEFAULT fnd_api.g_miss_num,
1167: p_actual_effort_uom IN VARCHAR2
1168: DEFAULT fnd_api.g_miss_char,
1162: DEFAULT fnd_api.g_miss_num,
1163: p_resource_name IN VARCHAR2
1164: DEFAULT fnd_api.g_miss_char,
1165: p_actual_effort IN NUMBER
1166: DEFAULT fnd_api.g_miss_num,
1167: p_actual_effort_uom IN VARCHAR2
1168: DEFAULT fnd_api.g_miss_char,
1169: p_schedule_flag IN VARCHAR2
1170: DEFAULT fnd_api.g_miss_char,
1164: DEFAULT fnd_api.g_miss_char,
1165: p_actual_effort IN NUMBER
1166: DEFAULT fnd_api.g_miss_num,
1167: p_actual_effort_uom IN VARCHAR2
1168: DEFAULT fnd_api.g_miss_char,
1169: p_schedule_flag IN VARCHAR2
1170: DEFAULT fnd_api.g_miss_char,
1171: p_alarm_type_code IN VARCHAR2
1172: DEFAULT fnd_api.g_miss_char,
1166: DEFAULT fnd_api.g_miss_num,
1167: p_actual_effort_uom IN VARCHAR2
1168: DEFAULT fnd_api.g_miss_char,
1169: p_schedule_flag IN VARCHAR2
1170: DEFAULT fnd_api.g_miss_char,
1171: p_alarm_type_code IN VARCHAR2
1172: DEFAULT fnd_api.g_miss_char,
1173: p_alarm_contact IN VARCHAR2
1174: DEFAULT fnd_api.g_miss_char,
1168: DEFAULT fnd_api.g_miss_char,
1169: p_schedule_flag IN VARCHAR2
1170: DEFAULT fnd_api.g_miss_char,
1171: p_alarm_type_code IN VARCHAR2
1172: DEFAULT fnd_api.g_miss_char,
1173: p_alarm_contact IN VARCHAR2
1174: DEFAULT fnd_api.g_miss_char,
1175: p_sched_travel_distance IN NUMBER
1176: DEFAULT fnd_api.g_miss_num,
1170: DEFAULT fnd_api.g_miss_char,
1171: p_alarm_type_code IN VARCHAR2
1172: DEFAULT fnd_api.g_miss_char,
1173: p_alarm_contact IN VARCHAR2
1174: DEFAULT fnd_api.g_miss_char,
1175: p_sched_travel_distance IN NUMBER
1176: DEFAULT fnd_api.g_miss_num,
1177: p_sched_travel_duration IN NUMBER
1178: DEFAULT fnd_api.g_miss_num,
1172: DEFAULT fnd_api.g_miss_char,
1173: p_alarm_contact IN VARCHAR2
1174: DEFAULT fnd_api.g_miss_char,
1175: p_sched_travel_distance IN NUMBER
1176: DEFAULT fnd_api.g_miss_num,
1177: p_sched_travel_duration IN NUMBER
1178: DEFAULT fnd_api.g_miss_num,
1179: p_sched_travel_duration_uom IN VARCHAR2
1180: DEFAULT fnd_api.g_miss_char,
1174: DEFAULT fnd_api.g_miss_char,
1175: p_sched_travel_distance IN NUMBER
1176: DEFAULT fnd_api.g_miss_num,
1177: p_sched_travel_duration IN NUMBER
1178: DEFAULT fnd_api.g_miss_num,
1179: p_sched_travel_duration_uom IN VARCHAR2
1180: DEFAULT fnd_api.g_miss_char,
1181: p_actual_travel_distance IN NUMBER
1182: DEFAULT fnd_api.g_miss_num,
1176: DEFAULT fnd_api.g_miss_num,
1177: p_sched_travel_duration IN NUMBER
1178: DEFAULT fnd_api.g_miss_num,
1179: p_sched_travel_duration_uom IN VARCHAR2
1180: DEFAULT fnd_api.g_miss_char,
1181: p_actual_travel_distance IN NUMBER
1182: DEFAULT fnd_api.g_miss_num,
1183: p_actual_travel_duration IN NUMBER
1184: DEFAULT fnd_api.g_miss_num,
1178: DEFAULT fnd_api.g_miss_num,
1179: p_sched_travel_duration_uom IN VARCHAR2
1180: DEFAULT fnd_api.g_miss_char,
1181: p_actual_travel_distance IN NUMBER
1182: DEFAULT fnd_api.g_miss_num,
1183: p_actual_travel_duration IN NUMBER
1184: DEFAULT fnd_api.g_miss_num,
1185: p_actual_travel_duration_uom IN VARCHAR2
1186: DEFAULT fnd_api.g_miss_char,
1180: DEFAULT fnd_api.g_miss_char,
1181: p_actual_travel_distance IN NUMBER
1182: DEFAULT fnd_api.g_miss_num,
1183: p_actual_travel_duration IN NUMBER
1184: DEFAULT fnd_api.g_miss_num,
1185: p_actual_travel_duration_uom IN VARCHAR2
1186: DEFAULT fnd_api.g_miss_char,
1187: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1188: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1182: DEFAULT fnd_api.g_miss_num,
1183: p_actual_travel_duration IN NUMBER
1184: DEFAULT fnd_api.g_miss_num,
1185: p_actual_travel_duration_uom IN VARCHAR2
1186: DEFAULT fnd_api.g_miss_char,
1187: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1188: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1189: p_palm_flag IN VARCHAR2
1190: DEFAULT fnd_api.g_miss_char,
1183: p_actual_travel_duration IN NUMBER
1184: DEFAULT fnd_api.g_miss_num,
1185: p_actual_travel_duration_uom IN VARCHAR2
1186: DEFAULT fnd_api.g_miss_char,
1187: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1188: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1189: p_palm_flag IN VARCHAR2
1190: DEFAULT fnd_api.g_miss_char,
1191: p_wince_flag IN VARCHAR2
1184: DEFAULT fnd_api.g_miss_num,
1185: p_actual_travel_duration_uom IN VARCHAR2
1186: DEFAULT fnd_api.g_miss_char,
1187: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1188: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1189: p_palm_flag IN VARCHAR2
1190: DEFAULT fnd_api.g_miss_char,
1191: p_wince_flag IN VARCHAR2
1192: DEFAULT fnd_api.g_miss_char,
1186: DEFAULT fnd_api.g_miss_char,
1187: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
1188: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1189: p_palm_flag IN VARCHAR2
1190: DEFAULT fnd_api.g_miss_char,
1191: p_wince_flag IN VARCHAR2
1192: DEFAULT fnd_api.g_miss_char,
1193: p_laptop_flag IN VARCHAR2
1194: DEFAULT fnd_api.g_miss_char,
1188: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
1189: p_palm_flag IN VARCHAR2
1190: DEFAULT fnd_api.g_miss_char,
1191: p_wince_flag IN VARCHAR2
1192: DEFAULT fnd_api.g_miss_char,
1193: p_laptop_flag IN VARCHAR2
1194: DEFAULT fnd_api.g_miss_char,
1195: p_device1_flag IN VARCHAR2
1196: DEFAULT fnd_api.g_miss_char,
1190: DEFAULT fnd_api.g_miss_char,
1191: p_wince_flag IN VARCHAR2
1192: DEFAULT fnd_api.g_miss_char,
1193: p_laptop_flag IN VARCHAR2
1194: DEFAULT fnd_api.g_miss_char,
1195: p_device1_flag IN VARCHAR2
1196: DEFAULT fnd_api.g_miss_char,
1197: p_device2_flag IN VARCHAR2
1198: DEFAULT fnd_api.g_miss_char,
1192: DEFAULT fnd_api.g_miss_char,
1193: p_laptop_flag IN VARCHAR2
1194: DEFAULT fnd_api.g_miss_char,
1195: p_device1_flag IN VARCHAR2
1196: DEFAULT fnd_api.g_miss_char,
1197: p_device2_flag IN VARCHAR2
1198: DEFAULT fnd_api.g_miss_char,
1199: p_device3_flag IN VARCHAR2
1200: DEFAULT fnd_api.g_miss_char,
1194: DEFAULT fnd_api.g_miss_char,
1195: p_device1_flag IN VARCHAR2
1196: DEFAULT fnd_api.g_miss_char,
1197: p_device2_flag IN VARCHAR2
1198: DEFAULT fnd_api.g_miss_char,
1199: p_device3_flag IN VARCHAR2
1200: DEFAULT fnd_api.g_miss_char,
1201: p_resource_territory_id IN NUMBER
1202: DEFAULT fnd_api.g_miss_num,
1196: DEFAULT fnd_api.g_miss_char,
1197: p_device2_flag IN VARCHAR2
1198: DEFAULT fnd_api.g_miss_char,
1199: p_device3_flag IN VARCHAR2
1200: DEFAULT fnd_api.g_miss_char,
1201: p_resource_territory_id IN NUMBER
1202: DEFAULT fnd_api.g_miss_num,
1203: p_assignment_status_id IN NUMBER
1204: DEFAULT fnd_api.g_miss_num,
1198: DEFAULT fnd_api.g_miss_char,
1199: p_device3_flag IN VARCHAR2
1200: DEFAULT fnd_api.g_miss_char,
1201: p_resource_territory_id IN NUMBER
1202: DEFAULT fnd_api.g_miss_num,
1203: p_assignment_status_id IN NUMBER
1204: DEFAULT fnd_api.g_miss_num,
1205: p_shift_construct_id IN NUMBER
1206: DEFAULT fnd_api.g_miss_num,
1200: DEFAULT fnd_api.g_miss_char,
1201: p_resource_territory_id IN NUMBER
1202: DEFAULT fnd_api.g_miss_num,
1203: p_assignment_status_id IN NUMBER
1204: DEFAULT fnd_api.g_miss_num,
1205: p_shift_construct_id IN NUMBER
1206: DEFAULT fnd_api.g_miss_num,
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1202: DEFAULT fnd_api.g_miss_num,
1203: p_assignment_status_id IN NUMBER
1204: DEFAULT fnd_api.g_miss_num,
1205: p_shift_construct_id IN NUMBER
1206: DEFAULT fnd_api.g_miss_num,
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,
1210: p_attribute1 IN VARCHAR2
1255: := 1.0;
1256: l_api_name CONSTANT VARCHAR(30)
1257: := 'Update_Task_Assignment';
1258: l_return_status VARCHAR2(1)
1259: := fnd_api.g_ret_sts_success;
1260: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1261: := p_task_assignment_id;
1262: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1263: := p_resource_type_code;
1323: IS
1324: SELECT task_id,
1325: DECODE (
1326: p_resource_id,
1327: fnd_api.g_miss_num, resource_id,
1328: p_resource_id
1329: ) resource_id,
1330: DECODE (
1331: p_resource_type_code,
1328: p_resource_id
1329: ) resource_id,
1330: DECODE (
1331: p_resource_type_code,
1332: fnd_api.g_miss_char, resource_type_code,
1333: p_resource_type_code
1334: ) resource_type_code,
1335: DECODE (
1336: p_assignment_status_id,
1333: p_resource_type_code
1334: ) resource_type_code,
1335: DECODE (
1336: p_assignment_status_id,
1337: fnd_api.g_miss_num, assignment_status_id,
1338: p_assignment_status_id
1339: ) assignment_status_id,
1340: DECODE (
1341: p_actual_effort,
1338: p_assignment_status_id
1339: ) assignment_status_id,
1340: DECODE (
1341: p_actual_effort,
1342: fnd_api.g_miss_num, actual_effort,
1343: p_actual_effort
1344: ) actual_effort,
1345: DECODE (
1346: p_actual_effort_uom,
1343: p_actual_effort
1344: ) actual_effort,
1345: DECODE (
1346: p_actual_effort_uom,
1347: fnd_api.g_miss_char, actual_effort_uom,
1348: p_actual_effort_uom
1349: ) actual_effort_uom,
1350: DECODE (
1351: p_alarm_type_code,
1348: p_actual_effort_uom
1349: ) actual_effort_uom,
1350: DECODE (
1351: p_alarm_type_code,
1352: fnd_api.g_miss_char, alarm_type_code,
1353: p_alarm_type_code
1354: ) alarm_type_code,
1355: DECODE (
1356: p_alarm_contact,
1353: p_alarm_type_code
1354: ) alarm_type_code,
1355: DECODE (
1356: p_alarm_contact,
1357: fnd_api.g_miss_char, alarm_contact,
1358: p_alarm_contact
1359: ) alarm_contact,
1360: DECODE (
1361: p_sched_travel_distance,
1358: p_alarm_contact
1359: ) alarm_contact,
1360: DECODE (
1361: p_sched_travel_distance,
1362: fnd_api.g_miss_num, sched_travel_distance,
1363: p_sched_travel_distance
1364: ) sched_travel_distance,
1365: DECODE (
1366: p_sched_travel_duration,
1363: p_sched_travel_distance
1364: ) sched_travel_distance,
1365: DECODE (
1366: p_sched_travel_duration,
1367: fnd_api.g_miss_num, sched_travel_duration,
1368: p_sched_travel_duration
1369: ) sched_travel_duration,
1370: DECODE (
1371: p_sched_travel_duration_uom,
1368: p_sched_travel_duration
1369: ) sched_travel_duration,
1370: DECODE (
1371: p_sched_travel_duration_uom,
1372: fnd_api.g_miss_char, sched_travel_duration_uom,
1373: p_sched_travel_duration_uom
1374: ) sched_travel_dur_uom,
1375: DECODE (
1376: p_actual_travel_distance,
1373: p_sched_travel_duration_uom
1374: ) sched_travel_dur_uom,
1375: DECODE (
1376: p_actual_travel_distance,
1377: fnd_api.g_miss_num, actual_travel_distance,
1378: p_actual_travel_distance
1379: ) actual_travel_distance,
1380: DECODE (
1381: p_actual_travel_duration,
1378: p_actual_travel_distance
1379: ) actual_travel_distance,
1380: DECODE (
1381: p_actual_travel_duration,
1382: fnd_api.g_miss_num, actual_travel_duration,
1383: p_actual_travel_duration
1384: ) actual_travel_duration,
1385: DECODE (
1386: p_resource_territory_id,
1383: p_actual_travel_duration
1384: ) actual_travel_duration,
1385: DECODE (
1386: p_resource_territory_id,
1387: fnd_api.g_miss_num, resource_territory_id,
1388: p_resource_territory_id
1389: ) resource_territory_id,
1390: DECODE (
1391: p_shift_construct_id,
1388: p_resource_territory_id
1389: ) resource_territory_id,
1390: DECODE (
1391: p_shift_construct_id,
1392: fnd_api.g_miss_num, shift_construct_id,
1393: p_shift_construct_id
1394: ) shift_construct_id,
1395: DECODE (
1396: p_actual_travel_duration_uom,
1393: p_shift_construct_id
1394: ) shift_construct_id,
1395: DECODE (
1396: p_actual_travel_duration_uom,
1397: fnd_api.g_miss_char, actual_travel_duration_uom,
1398: p_actual_travel_duration_uom
1399: ) actual_travel_dur_uom,
1400: DECODE (
1401: p_schedule_flag,
1398: p_actual_travel_duration_uom
1399: ) actual_travel_dur_uom,
1400: DECODE (
1401: p_schedule_flag,
1402: fnd_api.g_miss_char, schedule_flag,
1403: p_schedule_flag
1404: ) schedule_flag,
1405: DECODE (
1406: p_actual_start_date,
1403: p_schedule_flag
1404: ) schedule_flag,
1405: DECODE (
1406: p_actual_start_date,
1407: fnd_api.g_miss_date, actual_start_date,
1408: p_actual_start_date
1409: ) actual_start_date,
1410: DECODE (
1411: p_actual_end_date,
1408: p_actual_start_date
1409: ) actual_start_date,
1410: DECODE (
1411: p_actual_end_date,
1412: fnd_api.g_miss_date, actual_end_date,
1413: p_actual_end_date
1414: ) actual_end_date,
1415: DECODE (
1416: p_palm_flag,
1413: p_actual_end_date
1414: ) actual_end_date,
1415: DECODE (
1416: p_palm_flag,
1417: fnd_api.g_miss_char, palm_flag,
1418: p_palm_flag
1419: ) palm_flag,
1420: DECODE (
1421: p_wince_flag,
1418: p_palm_flag
1419: ) palm_flag,
1420: DECODE (
1421: p_wince_flag,
1422: fnd_api.g_miss_char, wince_flag,
1423: p_wince_flag
1424: ) wince_flag,
1425: DECODE (
1426: p_laptop_flag,
1423: p_wince_flag
1424: ) wince_flag,
1425: DECODE (
1426: p_laptop_flag,
1427: fnd_api.g_miss_char, laptop_flag,
1428: p_laptop_flag
1429: ) laptop_flag,
1430: DECODE (
1431: p_device1_flag,
1428: p_laptop_flag
1429: ) laptop_flag,
1430: DECODE (
1431: p_device1_flag,
1432: fnd_api.g_miss_char, device1_flag,
1433: p_device1_flag
1434: ) device1_flag,
1435: DECODE (
1436: p_device2_flag,
1433: p_device1_flag
1434: ) device1_flag,
1435: DECODE (
1436: p_device2_flag,
1437: fnd_api.g_miss_char, device2_flag,
1438: p_device2_flag
1439: ) device2_flag,
1440: DECODE (
1441: p_device3_flag,
1438: p_device2_flag
1439: ) device2_flag,
1440: DECODE (
1441: p_device3_flag,
1442: fnd_api.g_miss_char, device3_flag,
1443: p_device3_flag
1444: ) device3_flag,
1445: DECODE (
1446: p_show_on_calendar,
1443: p_device3_flag
1444: ) device3_flag,
1445: DECODE (
1446: p_show_on_calendar,
1447: fnd_api.g_miss_char, show_on_calendar,
1448: p_show_on_calendar
1449: ) show_on_calendar,
1450: DECODE (
1451: p_category_id,
1448: p_show_on_calendar
1449: ) show_on_calendar,
1450: DECODE (
1451: p_category_id,
1452: fnd_api.g_miss_num, category_id,
1453: p_category_id
1454: ) category_id,
1455: DECODE (
1456: p_attribute1,
1453: p_category_id
1454: ) category_id,
1455: DECODE (
1456: p_attribute1,
1457: fnd_api.g_miss_char, attribute1,
1458: p_attribute1
1459: ) attribute1,
1460: DECODE (
1461: p_attribute2,
1458: p_attribute1
1459: ) attribute1,
1460: DECODE (
1461: p_attribute2,
1462: fnd_api.g_miss_char, attribute2,
1463: p_attribute2
1464: ) attribute2,
1465: DECODE (
1466: p_attribute3,
1463: p_attribute2
1464: ) attribute2,
1465: DECODE (
1466: p_attribute3,
1467: fnd_api.g_miss_char, attribute3,
1468: p_attribute3
1469: ) attribute3,
1470: DECODE (
1471: p_attribute4,
1468: p_attribute3
1469: ) attribute3,
1470: DECODE (
1471: p_attribute4,
1472: fnd_api.g_miss_char, attribute4,
1473: p_attribute4
1474: ) attribute4,
1475: DECODE (
1476: p_attribute5,
1473: p_attribute4
1474: ) attribute4,
1475: DECODE (
1476: p_attribute5,
1477: fnd_api.g_miss_char, attribute5,
1478: p_attribute5
1479: ) attribute5,
1480: DECODE (
1481: p_attribute6,
1478: p_attribute5
1479: ) attribute5,
1480: DECODE (
1481: p_attribute6,
1482: fnd_api.g_miss_char, attribute6,
1483: p_attribute6
1484: ) attribute6,
1485: DECODE (
1486: p_attribute7,
1483: p_attribute6
1484: ) attribute6,
1485: DECODE (
1486: p_attribute7,
1487: fnd_api.g_miss_char, attribute7,
1488: p_attribute7
1489: ) attribute7,
1490: DECODE (
1491: p_attribute8,
1488: p_attribute7
1489: ) attribute7,
1490: DECODE (
1491: p_attribute8,
1492: fnd_api.g_miss_char, attribute8,
1493: p_attribute8
1494: ) attribute8,
1495: DECODE (
1496: p_attribute9,
1493: p_attribute8
1494: ) attribute8,
1495: DECODE (
1496: p_attribute9,
1497: fnd_api.g_miss_char, attribute9,
1498: p_attribute9
1499: ) attribute9,
1500: DECODE (
1501: p_attribute10,
1498: p_attribute9
1499: ) attribute9,
1500: DECODE (
1501: p_attribute10,
1502: fnd_api.g_miss_char, attribute10,
1503: p_attribute10
1504: ) attribute10,
1505: DECODE (
1506: p_attribute11,
1503: p_attribute10
1504: ) attribute10,
1505: DECODE (
1506: p_attribute11,
1507: fnd_api.g_miss_char, attribute11,
1508: p_attribute11
1509: ) attribute11,
1510: DECODE (
1511: p_attribute12,
1508: p_attribute11
1509: ) attribute11,
1510: DECODE (
1511: p_attribute12,
1512: fnd_api.g_miss_char, attribute12,
1513: p_attribute12
1514: ) attribute12,
1515: DECODE (
1516: p_attribute13,
1513: p_attribute12
1514: ) attribute12,
1515: DECODE (
1516: p_attribute13,
1517: fnd_api.g_miss_char, attribute13,
1518: p_attribute13
1519: ) attribute13,
1520: DECODE (
1521: p_attribute14,
1518: p_attribute13
1519: ) attribute13,
1520: DECODE (
1521: p_attribute14,
1522: fnd_api.g_miss_char, attribute14,
1523: p_attribute14
1524: ) attribute14,
1525: DECODE (
1526: p_attribute15,
1523: p_attribute14
1524: ) attribute14,
1525: DECODE (
1526: p_attribute15,
1527: fnd_api.g_miss_char, attribute15,
1528: p_attribute15
1529: ) attribute15,
1530: DECODE (
1531: p_attribute_category,
1528: p_attribute15
1529: ) attribute15,
1530: DECODE (
1531: p_attribute_category,
1532: fnd_api.g_miss_char, attribute_category,
1533: p_attribute_category
1534: ) attribute_category
1535: FROM jtf_task_all_assignments
1536: WHERE task_assignment_id = l_task_assignment_id;
1537:
1538: task_ass_rec task_ass_u%ROWTYPE;
1539: BEGIN
1540: SAVEPOINT update_task_assignment_pub;
1541: x_return_status := fnd_api.g_ret_sts_success;
1542:
1543: IF NOT fnd_api.compatible_api_call (
1544: l_api_version,
1545: p_api_version,
1539: BEGIN
1540: SAVEPOINT update_task_assignment_pub;
1541: x_return_status := fnd_api.g_ret_sts_success;
1542:
1543: IF NOT fnd_api.compatible_api_call (
1544: l_api_version,
1545: p_api_version,
1546: l_api_name,
1547: g_pkg_name
1546: l_api_name,
1547: g_pkg_name
1548: )
1549: THEN
1550: RAISE fnd_api.g_exc_unexpected_error;
1551: END IF;
1552:
1553: IF fnd_api.to_boolean (p_init_msg_list)
1554: THEN
1549: THEN
1550: RAISE fnd_api.g_exc_unexpected_error;
1551: END IF;
1552:
1553: IF fnd_api.to_boolean (p_init_msg_list)
1554: THEN
1555: fnd_msg_pub.initialize;
1556: END IF;
1557:
1589:
1590:
1591: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
1592:
1593: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1594: THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error;
1596: RAISE fnd_api.g_exc_unexpected_error;
1597: END IF;
1591: jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
1592:
1593: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1594: THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error;
1596: RAISE fnd_api.g_exc_unexpected_error;
1597: END IF;
1598:
1599: */
1592:
1593: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1594: THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error;
1596: RAISE fnd_api.g_exc_unexpected_error;
1597: END IF;
1598:
1599: */
1600: OPEN task_ass_u (l_task_assignment_id);
1604: THEN
1605: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
1606: fnd_message.set_token ('TASK_ASSIGNMENT_ID', p_task_assignment_id);
1607: fnd_msg_pub.add;
1608: x_return_status := fnd_api.g_ret_sts_unexp_error;
1609: RAISE fnd_api.g_exc_unexpected_error;
1610: END IF;
1611:
1612: -----
1605: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
1606: fnd_message.set_token ('TASK_ASSIGNMENT_ID', p_task_assignment_id);
1607: fnd_msg_pub.add;
1608: x_return_status := fnd_api.g_ret_sts_unexp_error;
1609: RAISE fnd_api.g_exc_unexpected_error;
1610: END IF;
1611:
1612: -----
1613: ----- Validate Assignment Status Id
1624: IF l_assignment_status_id IS NULL
1625: THEN
1626: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK_STATUS');
1627: fnd_msg_pub.add;
1628: RAISE fnd_api.g_exc_unexpected_error;
1629: END IF;
1630:
1631: -----
1632: ----- Validate the assigned resource.
1640: x_owner_id => l_resource_id,
1641: x_owner_type_code => l_resource_type_code
1642: );
1643:
1644: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1645: THEN
1646: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
1647: fnd_msg_pub.add;
1648: RAISE fnd_api.g_exc_unexpected_error;
1644: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1645: THEN
1646: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
1647: fnd_msg_pub.add;
1648: RAISE fnd_api.g_exc_unexpected_error;
1649: END IF;
1650:
1651: IF l_resource_type_code IS NULL
1652: THEN
1649: END IF;
1650:
1651: IF l_resource_type_code IS NULL
1652: THEN
1653: x_return_status := fnd_api.g_ret_sts_unexp_error;
1654: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
1655: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
1656: fnd_msg_pub.add;
1657: RAISE fnd_api.g_exc_unexpected_error;
1653: x_return_status := fnd_api.g_ret_sts_unexp_error;
1654: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
1655: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
1656: fnd_msg_pub.add;
1657: RAISE fnd_api.g_exc_unexpected_error;
1658: END IF;
1659:
1660: IF l_resource_id IS NULL
1661: THEN
1658: END IF;
1659:
1660: IF l_resource_id IS NULL
1661: THEN
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_RES_ID');
1664: fnd_msg_pub.add;
1665: RAISE fnd_api.g_exc_unexpected_error;
1666: END IF;
1661: THEN
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_RES_ID');
1664: fnd_msg_pub.add;
1665: RAISE fnd_api.g_exc_unexpected_error;
1666: END IF;
1667:
1668: -------
1669: ------- Validate actual effort
1683: p_effort => l_act_eff,
1684: p_effort_uom => l_act_eff_uom
1685: );
1686:
1687: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1688: THEN
1689: x_return_status := fnd_api.g_ret_sts_unexp_error;
1690: RAISE fnd_api.g_exc_unexpected_error;
1691: END IF;
1685: );
1686:
1687: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1688: THEN
1689: x_return_status := fnd_api.g_ret_sts_unexp_error;
1690: RAISE fnd_api.g_exc_unexpected_error;
1691: END IF;
1692:
1693: l_shift_construct_id := task_ass_rec.shift_construct_id;
1686:
1687: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1688: THEN
1689: x_return_status := fnd_api.g_ret_sts_unexp_error;
1690: RAISE fnd_api.g_exc_unexpected_error;
1691: END IF;
1692:
1693: l_shift_construct_id := task_ass_rec.shift_construct_id;
1694:
1702: 'JTF_TASK_TRANSLATED_MESSAGES',
1703: 'SHIFT_CONSTRUCT_ID')
1704: );
1705: fnd_msg_pub.add;
1706: RAISE fnd_api.g_exc_unexpected_error;
1707: END IF;
1708: END IF;
1709:
1710: ------
1730: p_effort => l_sched_travel_duration,
1731: p_effort_uom => l_sched_travel_dur_uom
1732: );
1733:
1734: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1735: THEN
1736: x_return_status := fnd_api.g_ret_sts_unexp_error;
1737: RAISE fnd_api.g_exc_unexpected_error;
1738: END IF;
1732: );
1733:
1734: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1735: THEN
1736: x_return_status := fnd_api.g_ret_sts_unexp_error;
1737: RAISE fnd_api.g_exc_unexpected_error;
1738: END IF;
1739:
1740: -------
1733:
1734: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1735: THEN
1736: x_return_status := fnd_api.g_ret_sts_unexp_error;
1737: RAISE fnd_api.g_exc_unexpected_error;
1738: END IF;
1739:
1740: -------
1741: ------- Validate Actual Travel Duration
1755: p_effort => l_actual_travel_duration,
1756: p_effort_uom => l_actual_travel_dur_uom
1757: );
1758:
1759: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1760: THEN
1761: x_return_status := fnd_api.g_ret_sts_unexp_error;
1762: RAISE fnd_api.g_exc_unexpected_error;
1763: END IF;
1757: );
1758:
1759: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1760: THEN
1761: x_return_status := fnd_api.g_ret_sts_unexp_error;
1762: RAISE fnd_api.g_exc_unexpected_error;
1763: END IF;
1764:
1765: -------
1758:
1759: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1760: THEN
1761: x_return_status := fnd_api.g_ret_sts_unexp_error;
1762: RAISE fnd_api.g_exc_unexpected_error;
1763: END IF;
1764:
1765: -------
1766: ------- Validate Actual Travel Distance
1774: ),
1775: x_return_status => x_return_status
1776: );
1777:
1778: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1779: THEN
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;
1781: RAISE fnd_api.g_exc_unexpected_error;
1782: END IF;
1776: );
1777:
1778: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1779: THEN
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;
1781: RAISE fnd_api.g_exc_unexpected_error;
1782: END IF;
1783:
1784: -------
1777:
1778: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1779: THEN
1780: x_return_status := fnd_api.g_ret_sts_unexp_error;
1781: RAISE fnd_api.g_exc_unexpected_error;
1782: END IF;
1783:
1784: -------
1785: ------- Validate Schedule Travel Distance
1790: p_distance_tag => 'Schedule Travel Distance',
1791: x_return_status => x_return_status
1792: );
1793:
1794: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1795: THEN
1796: x_return_status := fnd_api.g_ret_sts_unexp_error;
1797: RAISE fnd_api.g_exc_unexpected_error;
1798: END IF;
1792: );
1793:
1794: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1795: THEN
1796: x_return_status := fnd_api.g_ret_sts_unexp_error;
1797: RAISE fnd_api.g_exc_unexpected_error;
1798: END IF;
1799:
1800: ------
1793:
1794: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1795: THEN
1796: x_return_status := fnd_api.g_ret_sts_unexp_error;
1797: RAISE fnd_api.g_exc_unexpected_error;
1798: END IF;
1799:
1800: ------
1801: ------ Palm flag.
1809: ),
1810: p_flag_value => l_palm_flag
1811: );
1812:
1813: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1814: THEN
1815: x_return_status := fnd_api.g_ret_sts_unexp_error;
1816: RAISE fnd_api.g_exc_unexpected_error;
1817: END IF;
1811: );
1812:
1813: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1814: THEN
1815: x_return_status := fnd_api.g_ret_sts_unexp_error;
1816: RAISE fnd_api.g_exc_unexpected_error;
1817: END IF;
1818:
1819: ------
1812:
1813: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1814: THEN
1815: x_return_status := fnd_api.g_ret_sts_unexp_error;
1816: RAISE fnd_api.g_exc_unexpected_error;
1817: END IF;
1818:
1819: ------
1820: ------ Wince flag.
1828: ),
1829: p_flag_value => l_wince_flag
1830: );
1831:
1832: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1833: THEN
1834: x_return_status := fnd_api.g_ret_sts_unexp_error;
1835: RAISE fnd_api.g_exc_unexpected_error;
1836: END IF;
1830: );
1831:
1832: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1833: THEN
1834: x_return_status := fnd_api.g_ret_sts_unexp_error;
1835: RAISE fnd_api.g_exc_unexpected_error;
1836: END IF;
1837:
1838: ------
1831:
1832: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1833: THEN
1834: x_return_status := fnd_api.g_ret_sts_unexp_error;
1835: RAISE fnd_api.g_exc_unexpected_error;
1836: END IF;
1837:
1838: ------
1839: ------ Laptop flag.
1847: ),
1848: p_flag_value => l_laptop_flag
1849: );
1850:
1851: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1852: THEN
1853: x_return_status := fnd_api.g_ret_sts_unexp_error;
1854: RAISE fnd_api.g_exc_unexpected_error;
1855: END IF;
1849: );
1850:
1851: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1852: THEN
1853: x_return_status := fnd_api.g_ret_sts_unexp_error;
1854: RAISE fnd_api.g_exc_unexpected_error;
1855: END IF;
1856:
1857: ------
1850:
1851: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1852: THEN
1853: x_return_status := fnd_api.g_ret_sts_unexp_error;
1854: RAISE fnd_api.g_exc_unexpected_error;
1855: END IF;
1856:
1857: ------
1858: ------ Device1 flag.
1866: ),
1867: p_flag_value => l_device1_flag
1868: );
1869:
1870: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1871: THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error;
1873: RAISE fnd_api.g_exc_unexpected_error;
1874: END IF;
1868: );
1869:
1870: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1871: THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error;
1873: RAISE fnd_api.g_exc_unexpected_error;
1874: END IF;
1875:
1876: ------
1869:
1870: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1871: THEN
1872: x_return_status := fnd_api.g_ret_sts_unexp_error;
1873: RAISE fnd_api.g_exc_unexpected_error;
1874: END IF;
1875:
1876: ------
1877: ------ Device2 flag.
1885: ),
1886: p_flag_value => l_device2_flag
1887: );
1888:
1889: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1890: THEN
1891: x_return_status := fnd_api.g_ret_sts_unexp_error;
1892: RAISE fnd_api.g_exc_unexpected_error;
1893: END IF;
1887: );
1888:
1889: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1890: THEN
1891: x_return_status := fnd_api.g_ret_sts_unexp_error;
1892: RAISE fnd_api.g_exc_unexpected_error;
1893: END IF;
1894:
1895: ------
1888:
1889: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1890: THEN
1891: x_return_status := fnd_api.g_ret_sts_unexp_error;
1892: RAISE fnd_api.g_exc_unexpected_error;
1893: END IF;
1894:
1895: ------
1896: ------ Device3 flag.
1904: ),
1905: p_flag_value => l_device3_flag
1906: );
1907:
1908: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1909: THEN
1910: x_return_status := fnd_api.g_ret_sts_unexp_error;
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;
1906: );
1907:
1908: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1909: THEN
1910: x_return_status := fnd_api.g_ret_sts_unexp_error;
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;
1913:
1914: l_resource_territory_id := task_ass_rec.resource_territory_id;
1907:
1908: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1909: THEN
1910: x_return_status := fnd_api.g_ret_sts_unexp_error;
1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;
1913:
1914: l_resource_territory_id := task_ass_rec.resource_territory_id;
1915: ------
1921: p_flag_name => 'Schedule Flag',
1922: p_flag_value => l_schedule_flag
1923: );
1924:
1925: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1926: THEN
1927: x_return_status := fnd_api.g_ret_sts_unexp_error;
1928: RAISE fnd_api.g_exc_unexpected_error;
1929: END IF;
1923: );
1924:
1925: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1926: THEN
1927: x_return_status := fnd_api.g_ret_sts_unexp_error;
1928: RAISE fnd_api.g_exc_unexpected_error;
1929: END IF;
1930:
1931: ----
1924:
1925: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1926: THEN
1927: x_return_status := fnd_api.g_ret_sts_unexp_error;
1928: RAISE fnd_api.g_exc_unexpected_error;
1929: END IF;
1930:
1931: ----
1932: ---- Validate dates
1943: p_end_date => l_actual_end_date,
1944: x_return_status => x_return_status
1945: );
1946:
1947: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1948: THEN
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;
1950: RAISE fnd_api.g_exc_unexpected_error;
1951: END IF;
1945: );
1946:
1947: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1948: THEN
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;
1950: RAISE fnd_api.g_exc_unexpected_error;
1951: END IF;
1952:
1953: -- Validate the value in SHOW_ON_CALENDAR
1946:
1947: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1948: THEN
1949: x_return_status := fnd_api.g_ret_sts_unexp_error;
1950: RAISE fnd_api.g_exc_unexpected_error;
1951: END IF;
1952:
1953: -- Validate the value in SHOW_ON_CALENDAR
1954: l_show_on_calendar := task_ass_rec.show_on_calendar;
1960: ),
1961: p_flag_value => l_show_on_calendar
1962: );
1963:
1964: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1965: THEN
1966: x_return_status := fnd_api.g_ret_sts_unexp_error;
1967: RAISE fnd_api.g_exc_unexpected_error;
1968: END IF;
1962: );
1963:
1964: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1965: THEN
1966: x_return_status := fnd_api.g_ret_sts_unexp_error;
1967: RAISE fnd_api.g_exc_unexpected_error;
1968: END IF;
1969:
1970: -- Validate the value in category_id
1963:
1964: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1965: THEN
1966: x_return_status := fnd_api.g_ret_sts_unexp_error;
1967: RAISE fnd_api.g_exc_unexpected_error;
1968: END IF;
1969:
1970: -- Validate the value in category_id
1971: l_category_id := task_ass_rec.category_id;
1975: p_category_id => l_category_id,
1976: x_return_status => x_return_status
1977: );
1978:
1979: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1980: THEN
1981: x_return_status := fnd_api.g_ret_sts_unexp_error;
1982: RAISE fnd_api.g_exc_unexpected_error;
1983: END IF;
1977: );
1978:
1979: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1980: THEN
1981: x_return_status := fnd_api.g_ret_sts_unexp_error;
1982: RAISE fnd_api.g_exc_unexpected_error;
1983: END IF;
1984: END IF;
1985:
1978:
1979: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1980: THEN
1981: x_return_status := fnd_api.g_ret_sts_unexp_error;
1982: RAISE fnd_api.g_exc_unexpected_error;
1983: END IF;
1984: END IF;
1985:
1986: -- Validate the code in status id
1989: p_type => l_type,
1990: x_return_status => x_return_status
1991: );
1992:
1993: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1994: THEN
1995: x_return_status := fnd_api.g_ret_sts_unexp_error;
1996: RAISE fnd_api.g_exc_unexpected_error;
1997: END IF;
1991: );
1992:
1993: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1994: THEN
1995: x_return_status := fnd_api.g_ret_sts_unexp_error;
1996: RAISE fnd_api.g_exc_unexpected_error;
1997: END IF;
1998:
1999: jtf_task_assignments_pub.lock_task_assignment (
1992:
1993: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1994: THEN
1995: x_return_status := fnd_api.g_ret_sts_unexp_error;
1996: RAISE fnd_api.g_exc_unexpected_error;
1997: END IF;
1998:
1999: jtf_task_assignments_pub.lock_task_assignment (
2000: p_api_version => 1.0,
1997: END IF;
1998:
1999: jtf_task_assignments_pub.lock_task_assignment (
2000: p_api_version => 1.0,
2001: p_init_msg_list => fnd_api.g_false,
2002: p_commit => fnd_api.g_false,
2003: p_task_assignment_id => p_task_assignment_id,
2004: p_object_version_number => p_object_version_number,
2005: x_return_status => x_return_status,
1998:
1999: jtf_task_assignments_pub.lock_task_assignment (
2000: p_api_version => 1.0,
2001: p_init_msg_list => fnd_api.g_false,
2002: p_commit => fnd_api.g_false,
2003: p_task_assignment_id => p_task_assignment_id,
2004: p_object_version_number => p_object_version_number,
2005: x_return_status => x_return_status,
2006: x_msg_data => x_msg_data,
2006: x_msg_data => x_msg_data,
2007: x_msg_count => x_msg_count
2008: );
2009:
2010: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2011: THEN
2012: x_return_status := fnd_api.g_ret_sts_unexp_error;
2013: RAISE fnd_api.g_exc_unexpected_error;
2014: END IF;
2008: );
2009:
2010: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2011: THEN
2012: x_return_status := fnd_api.g_ret_sts_unexp_error;
2013: RAISE fnd_api.g_exc_unexpected_error;
2014: END IF;
2015:
2016:
2009:
2010: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2011: THEN
2012: x_return_status := fnd_api.g_ret_sts_unexp_error;
2013: RAISE fnd_api.g_exc_unexpected_error;
2014: END IF;
2015:
2016:
2017:
2017:
2018: jtf_task_assignments_pvt.update_task_assignment (
2019: p_api_version => l_api_version,
2020: p_object_version_number => p_object_version_number,
2021: p_init_msg_list => fnd_api.g_false,
2022: p_commit => fnd_api.g_false,
2023: p_task_assignment_id => l_task_assignment_id,
2024: p_sched_travel_duration_uom => l_sched_travel_dur_uom,
2025: p_actual_travel_distance => l_actual_travel_distance,
2018: jtf_task_assignments_pvt.update_task_assignment (
2019: p_api_version => l_api_version,
2020: p_object_version_number => p_object_version_number,
2021: p_init_msg_list => fnd_api.g_false,
2022: p_commit => fnd_api.g_false,
2023: p_task_assignment_id => l_task_assignment_id,
2024: p_sched_travel_duration_uom => l_sched_travel_dur_uom,
2025: p_actual_travel_distance => l_actual_travel_distance,
2026: p_actual_travel_duration => l_actual_travel_duration,
2067: p_show_on_calendar => l_show_on_calendar,
2068: p_category_id => l_category_id,
2069: p_enable_workflow => l_enable_workflow,
2070: p_abort_workflow => l_abort_workflow,
2071: p_free_busy_type => fnd_api.g_miss_char,
2072: p_object_capacity_id => p_object_capacity_id
2073: );
2074:
2075: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2071: p_free_busy_type => fnd_api.g_miss_char,
2072: p_object_capacity_id => p_object_capacity_id
2073: );
2074:
2075: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2076: THEN
2077: x_return_status := fnd_api.g_ret_sts_unexp_error;
2078: RAISE fnd_api.g_exc_unexpected_error;
2079: END IF;
2073: );
2074:
2075: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2076: THEN
2077: x_return_status := fnd_api.g_ret_sts_unexp_error;
2078: RAISE fnd_api.g_exc_unexpected_error;
2079: END IF;
2080:
2081: p_task_assignments_user_hooks.task_assignment_id :=
2074:
2075: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2076: THEN
2077: x_return_status := fnd_api.g_ret_sts_unexp_error;
2078: RAISE fnd_api.g_exc_unexpected_error;
2079: END IF;
2080:
2081: p_task_assignments_user_hooks.task_assignment_id :=
2082: p_task_assignment_id;
2082: p_task_assignment_id;
2083:
2084: /* jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
2085:
2086: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2087: THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: RAISE fnd_api.g_exc_unexpected_error;
2090: END IF;
2084: /* jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
2085:
2086: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2087: THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: RAISE fnd_api.g_exc_unexpected_error;
2090: END IF;
2091:
2092: */
2085:
2086: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2087: THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: RAISE fnd_api.g_exc_unexpected_error;
2090: END IF;
2091:
2092: */
2093: IF fnd_api.to_boolean (p_commit)
2089: RAISE fnd_api.g_exc_unexpected_error;
2090: END IF;
2091:
2092: */
2093: IF fnd_api.to_boolean (p_commit)
2094: THEN
2095: COMMIT WORK;
2096: END IF;
2097:
2101: END IF;
2102:
2103: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2104: EXCEPTION
2105: WHEN fnd_api.g_exc_error
2106: THEN
2107: ROLLBACK TO update_task_assignment_pub;
2108:
2109: IF task_ass_u%ISOPEN
2110: THEN
2111: CLOSE task_ass_u;
2112: END IF;
2113:
2114: x_return_status := fnd_api.g_ret_sts_error;
2115: fnd_msg_pub.count_and_get (
2116: p_count => x_msg_count,
2117: p_data => x_msg_data
2118: );
2115: fnd_msg_pub.count_and_get (
2116: p_count => x_msg_count,
2117: p_data => x_msg_data
2118: );
2119: WHEN fnd_api.g_exc_unexpected_error
2120: THEN
2121: ROLLBACK TO update_task_assignment_pub;
2122:
2123: IF task_ass_u%ISOPEN
2124: THEN
2125: CLOSE task_ass_u;
2126: END IF;
2127:
2128: x_return_status := fnd_api.g_ret_sts_unexp_error;
2129: fnd_msg_pub.count_and_get (
2130: p_count => x_msg_count,
2131: p_data => x_msg_data
2132: );
2138: THEN
2139: CLOSE task_ass_u;
2140: END IF;
2141:
2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143:
2144: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2145: THEN
2146: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2155: --overloading update procedure
2156: PROCEDURE update_task_assignment (
2157: p_api_version IN NUMBER,
2158: p_object_version_number IN OUT NOCOPY NUMBER,
2159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2161: p_task_assignment_id IN NUMBER,
2162: p_task_id IN NUMBER
2163: DEFAULT fnd_api.g_miss_num,
2156: PROCEDURE update_task_assignment (
2157: p_api_version IN NUMBER,
2158: p_object_version_number IN OUT NOCOPY NUMBER,
2159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2161: p_task_assignment_id IN NUMBER,
2162: p_task_id IN NUMBER
2163: DEFAULT fnd_api.g_miss_num,
2164: p_task_number IN VARCHAR2
2159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2161: p_task_assignment_id IN NUMBER,
2162: p_task_id IN NUMBER
2163: DEFAULT fnd_api.g_miss_num,
2164: p_task_number IN VARCHAR2
2165: DEFAULT fnd_api.g_miss_char,
2166: p_task_name IN VARCHAR2
2167: DEFAULT fnd_api.g_miss_char,
2161: p_task_assignment_id IN NUMBER,
2162: p_task_id IN NUMBER
2163: DEFAULT fnd_api.g_miss_num,
2164: p_task_number IN VARCHAR2
2165: DEFAULT fnd_api.g_miss_char,
2166: p_task_name IN VARCHAR2
2167: DEFAULT fnd_api.g_miss_char,
2168: p_resource_type_code IN VARCHAR2
2169: DEFAULT fnd_api.g_miss_char,
2163: DEFAULT fnd_api.g_miss_num,
2164: p_task_number IN VARCHAR2
2165: DEFAULT fnd_api.g_miss_char,
2166: p_task_name IN VARCHAR2
2167: DEFAULT fnd_api.g_miss_char,
2168: p_resource_type_code IN VARCHAR2
2169: DEFAULT fnd_api.g_miss_char,
2170: p_resource_id IN NUMBER
2171: DEFAULT fnd_api.g_miss_num,
2165: DEFAULT fnd_api.g_miss_char,
2166: p_task_name IN VARCHAR2
2167: DEFAULT fnd_api.g_miss_char,
2168: p_resource_type_code IN VARCHAR2
2169: DEFAULT fnd_api.g_miss_char,
2170: p_resource_id IN NUMBER
2171: DEFAULT fnd_api.g_miss_num,
2172: p_resource_name IN VARCHAR2
2173: DEFAULT fnd_api.g_miss_char,
2167: DEFAULT fnd_api.g_miss_char,
2168: p_resource_type_code IN VARCHAR2
2169: DEFAULT fnd_api.g_miss_char,
2170: p_resource_id IN NUMBER
2171: DEFAULT fnd_api.g_miss_num,
2172: p_resource_name IN VARCHAR2
2173: DEFAULT fnd_api.g_miss_char,
2174: p_actual_effort IN NUMBER
2175: DEFAULT fnd_api.g_miss_num,
2169: DEFAULT fnd_api.g_miss_char,
2170: p_resource_id IN NUMBER
2171: DEFAULT fnd_api.g_miss_num,
2172: p_resource_name IN VARCHAR2
2173: DEFAULT fnd_api.g_miss_char,
2174: p_actual_effort IN NUMBER
2175: DEFAULT fnd_api.g_miss_num,
2176: p_actual_effort_uom IN VARCHAR2
2177: DEFAULT fnd_api.g_miss_char,
2171: DEFAULT fnd_api.g_miss_num,
2172: p_resource_name IN VARCHAR2
2173: DEFAULT fnd_api.g_miss_char,
2174: p_actual_effort IN NUMBER
2175: DEFAULT fnd_api.g_miss_num,
2176: p_actual_effort_uom IN VARCHAR2
2177: DEFAULT fnd_api.g_miss_char,
2178: p_schedule_flag IN VARCHAR2
2179: DEFAULT fnd_api.g_miss_char,
2173: DEFAULT fnd_api.g_miss_char,
2174: p_actual_effort IN NUMBER
2175: DEFAULT fnd_api.g_miss_num,
2176: p_actual_effort_uom IN VARCHAR2
2177: DEFAULT fnd_api.g_miss_char,
2178: p_schedule_flag IN VARCHAR2
2179: DEFAULT fnd_api.g_miss_char,
2180: p_alarm_type_code IN VARCHAR2
2181: DEFAULT fnd_api.g_miss_char,
2175: DEFAULT fnd_api.g_miss_num,
2176: p_actual_effort_uom IN VARCHAR2
2177: DEFAULT fnd_api.g_miss_char,
2178: p_schedule_flag IN VARCHAR2
2179: DEFAULT fnd_api.g_miss_char,
2180: p_alarm_type_code IN VARCHAR2
2181: DEFAULT fnd_api.g_miss_char,
2182: p_alarm_contact IN VARCHAR2
2183: DEFAULT fnd_api.g_miss_char,
2177: DEFAULT fnd_api.g_miss_char,
2178: p_schedule_flag IN VARCHAR2
2179: DEFAULT fnd_api.g_miss_char,
2180: p_alarm_type_code IN VARCHAR2
2181: DEFAULT fnd_api.g_miss_char,
2182: p_alarm_contact IN VARCHAR2
2183: DEFAULT fnd_api.g_miss_char,
2184: p_sched_travel_distance IN NUMBER
2185: DEFAULT fnd_api.g_miss_num,
2179: DEFAULT fnd_api.g_miss_char,
2180: p_alarm_type_code IN VARCHAR2
2181: DEFAULT fnd_api.g_miss_char,
2182: p_alarm_contact IN VARCHAR2
2183: DEFAULT fnd_api.g_miss_char,
2184: p_sched_travel_distance IN NUMBER
2185: DEFAULT fnd_api.g_miss_num,
2186: p_sched_travel_duration IN NUMBER
2187: DEFAULT fnd_api.g_miss_num,
2181: DEFAULT fnd_api.g_miss_char,
2182: p_alarm_contact IN VARCHAR2
2183: DEFAULT fnd_api.g_miss_char,
2184: p_sched_travel_distance IN NUMBER
2185: DEFAULT fnd_api.g_miss_num,
2186: p_sched_travel_duration IN NUMBER
2187: DEFAULT fnd_api.g_miss_num,
2188: p_sched_travel_duration_uom IN VARCHAR2
2189: DEFAULT fnd_api.g_miss_char,
2183: DEFAULT fnd_api.g_miss_char,
2184: p_sched_travel_distance IN NUMBER
2185: DEFAULT fnd_api.g_miss_num,
2186: p_sched_travel_duration IN NUMBER
2187: DEFAULT fnd_api.g_miss_num,
2188: p_sched_travel_duration_uom IN VARCHAR2
2189: DEFAULT fnd_api.g_miss_char,
2190: p_actual_travel_distance IN NUMBER
2191: DEFAULT fnd_api.g_miss_num,
2185: DEFAULT fnd_api.g_miss_num,
2186: p_sched_travel_duration IN NUMBER
2187: DEFAULT fnd_api.g_miss_num,
2188: p_sched_travel_duration_uom IN VARCHAR2
2189: DEFAULT fnd_api.g_miss_char,
2190: p_actual_travel_distance IN NUMBER
2191: DEFAULT fnd_api.g_miss_num,
2192: p_actual_travel_duration IN NUMBER
2193: DEFAULT fnd_api.g_miss_num,
2187: DEFAULT fnd_api.g_miss_num,
2188: p_sched_travel_duration_uom IN VARCHAR2
2189: DEFAULT fnd_api.g_miss_char,
2190: p_actual_travel_distance IN NUMBER
2191: DEFAULT fnd_api.g_miss_num,
2192: p_actual_travel_duration IN NUMBER
2193: DEFAULT fnd_api.g_miss_num,
2194: p_actual_travel_duration_uom IN VARCHAR2
2195: DEFAULT fnd_api.g_miss_char,
2189: DEFAULT fnd_api.g_miss_char,
2190: p_actual_travel_distance IN NUMBER
2191: DEFAULT fnd_api.g_miss_num,
2192: p_actual_travel_duration IN NUMBER
2193: DEFAULT fnd_api.g_miss_num,
2194: p_actual_travel_duration_uom IN VARCHAR2
2195: DEFAULT fnd_api.g_miss_char,
2196: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2197: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2191: DEFAULT fnd_api.g_miss_num,
2192: p_actual_travel_duration IN NUMBER
2193: DEFAULT fnd_api.g_miss_num,
2194: p_actual_travel_duration_uom IN VARCHAR2
2195: DEFAULT fnd_api.g_miss_char,
2196: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2197: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2198: p_palm_flag IN VARCHAR2
2199: DEFAULT fnd_api.g_miss_char,
2192: p_actual_travel_duration IN NUMBER
2193: DEFAULT fnd_api.g_miss_num,
2194: p_actual_travel_duration_uom IN VARCHAR2
2195: DEFAULT fnd_api.g_miss_char,
2196: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2197: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2198: p_palm_flag IN VARCHAR2
2199: DEFAULT fnd_api.g_miss_char,
2200: p_wince_flag IN VARCHAR2
2193: DEFAULT fnd_api.g_miss_num,
2194: p_actual_travel_duration_uom IN VARCHAR2
2195: DEFAULT fnd_api.g_miss_char,
2196: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2197: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2198: p_palm_flag IN VARCHAR2
2199: DEFAULT fnd_api.g_miss_char,
2200: p_wince_flag IN VARCHAR2
2201: DEFAULT fnd_api.g_miss_char,
2195: DEFAULT fnd_api.g_miss_char,
2196: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2197: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2198: p_palm_flag IN VARCHAR2
2199: DEFAULT fnd_api.g_miss_char,
2200: p_wince_flag IN VARCHAR2
2201: DEFAULT fnd_api.g_miss_char,
2202: p_laptop_flag IN VARCHAR2
2203: DEFAULT fnd_api.g_miss_char,
2197: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2198: p_palm_flag IN VARCHAR2
2199: DEFAULT fnd_api.g_miss_char,
2200: p_wince_flag IN VARCHAR2
2201: DEFAULT fnd_api.g_miss_char,
2202: p_laptop_flag IN VARCHAR2
2203: DEFAULT fnd_api.g_miss_char,
2204: p_device1_flag IN VARCHAR2
2205: DEFAULT fnd_api.g_miss_char,
2199: DEFAULT fnd_api.g_miss_char,
2200: p_wince_flag IN VARCHAR2
2201: DEFAULT fnd_api.g_miss_char,
2202: p_laptop_flag IN VARCHAR2
2203: DEFAULT fnd_api.g_miss_char,
2204: p_device1_flag IN VARCHAR2
2205: DEFAULT fnd_api.g_miss_char,
2206: p_device2_flag IN VARCHAR2
2207: DEFAULT fnd_api.g_miss_char,
2201: DEFAULT fnd_api.g_miss_char,
2202: p_laptop_flag IN VARCHAR2
2203: DEFAULT fnd_api.g_miss_char,
2204: p_device1_flag IN VARCHAR2
2205: DEFAULT fnd_api.g_miss_char,
2206: p_device2_flag IN VARCHAR2
2207: DEFAULT fnd_api.g_miss_char,
2208: p_device3_flag IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2203: DEFAULT fnd_api.g_miss_char,
2204: p_device1_flag IN VARCHAR2
2205: DEFAULT fnd_api.g_miss_char,
2206: p_device2_flag IN VARCHAR2
2207: DEFAULT fnd_api.g_miss_char,
2208: p_device3_flag IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_territory_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2205: DEFAULT fnd_api.g_miss_char,
2206: p_device2_flag IN VARCHAR2
2207: DEFAULT fnd_api.g_miss_char,
2208: p_device3_flag IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_territory_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2212: p_assignment_status_id IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2207: DEFAULT fnd_api.g_miss_char,
2208: p_device3_flag IN VARCHAR2
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_territory_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2212: p_assignment_status_id IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2214: p_shift_construct_id IN NUMBER
2215: DEFAULT fnd_api.g_miss_num,
2209: DEFAULT fnd_api.g_miss_char,
2210: p_resource_territory_id IN NUMBER
2211: DEFAULT fnd_api.g_miss_num,
2212: p_assignment_status_id IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2214: p_shift_construct_id IN NUMBER
2215: DEFAULT fnd_api.g_miss_num,
2216: x_return_status OUT NOCOPY VARCHAR2,
2217: x_msg_count OUT NOCOPY NUMBER,
2211: DEFAULT fnd_api.g_miss_num,
2212: p_assignment_status_id IN NUMBER
2213: DEFAULT fnd_api.g_miss_num,
2214: p_shift_construct_id IN NUMBER
2215: DEFAULT fnd_api.g_miss_num,
2216: x_return_status OUT NOCOPY VARCHAR2,
2217: x_msg_count OUT NOCOPY NUMBER,
2218: x_msg_data OUT NOCOPY VARCHAR2,
2219: p_attribute1 IN VARCHAR2
2313: p_show_on_calendar => p_show_on_calendar,
2314: p_category_id => p_category_id,
2315: p_enable_workflow => p_enable_workflow,
2316: p_abort_workflow => p_abort_workflow,
2317: p_object_capacity_id => fnd_api.g_miss_num
2318: );
2319: END;
2320:
2321: --overloading update procedure
2321: --overloading update procedure
2322: PROCEDURE update_task_assignment (
2323: p_api_version IN NUMBER,
2324: p_object_version_number IN OUT NOCOPY NUMBER,
2325: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2326: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2327: p_task_assignment_id IN NUMBER,
2328: p_task_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2322: PROCEDURE update_task_assignment (
2323: p_api_version IN NUMBER,
2324: p_object_version_number IN OUT NOCOPY NUMBER,
2325: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2326: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2327: p_task_assignment_id IN NUMBER,
2328: p_task_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2330: p_task_number IN VARCHAR2
2325: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2326: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2327: p_task_assignment_id IN NUMBER,
2328: p_task_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2330: p_task_number IN VARCHAR2
2331: DEFAULT fnd_api.g_miss_char,
2332: p_task_name IN VARCHAR2
2333: DEFAULT fnd_api.g_miss_char,
2327: p_task_assignment_id IN NUMBER,
2328: p_task_id IN NUMBER
2329: DEFAULT fnd_api.g_miss_num,
2330: p_task_number IN VARCHAR2
2331: DEFAULT fnd_api.g_miss_char,
2332: p_task_name IN VARCHAR2
2333: DEFAULT fnd_api.g_miss_char,
2334: p_resource_type_code IN VARCHAR2
2335: DEFAULT fnd_api.g_miss_char,
2329: DEFAULT fnd_api.g_miss_num,
2330: p_task_number IN VARCHAR2
2331: DEFAULT fnd_api.g_miss_char,
2332: p_task_name IN VARCHAR2
2333: DEFAULT fnd_api.g_miss_char,
2334: p_resource_type_code IN VARCHAR2
2335: DEFAULT fnd_api.g_miss_char,
2336: p_resource_id IN NUMBER
2337: DEFAULT fnd_api.g_miss_num,
2331: DEFAULT fnd_api.g_miss_char,
2332: p_task_name IN VARCHAR2
2333: DEFAULT fnd_api.g_miss_char,
2334: p_resource_type_code IN VARCHAR2
2335: DEFAULT fnd_api.g_miss_char,
2336: p_resource_id IN NUMBER
2337: DEFAULT fnd_api.g_miss_num,
2338: p_resource_name IN VARCHAR2
2339: DEFAULT fnd_api.g_miss_char,
2333: DEFAULT fnd_api.g_miss_char,
2334: p_resource_type_code IN VARCHAR2
2335: DEFAULT fnd_api.g_miss_char,
2336: p_resource_id IN NUMBER
2337: DEFAULT fnd_api.g_miss_num,
2338: p_resource_name IN VARCHAR2
2339: DEFAULT fnd_api.g_miss_char,
2340: p_actual_effort IN NUMBER
2341: DEFAULT fnd_api.g_miss_num,
2335: DEFAULT fnd_api.g_miss_char,
2336: p_resource_id IN NUMBER
2337: DEFAULT fnd_api.g_miss_num,
2338: p_resource_name IN VARCHAR2
2339: DEFAULT fnd_api.g_miss_char,
2340: p_actual_effort IN NUMBER
2341: DEFAULT fnd_api.g_miss_num,
2342: p_actual_effort_uom IN VARCHAR2
2343: DEFAULT fnd_api.g_miss_char,
2337: DEFAULT fnd_api.g_miss_num,
2338: p_resource_name IN VARCHAR2
2339: DEFAULT fnd_api.g_miss_char,
2340: p_actual_effort IN NUMBER
2341: DEFAULT fnd_api.g_miss_num,
2342: p_actual_effort_uom IN VARCHAR2
2343: DEFAULT fnd_api.g_miss_char,
2344: p_schedule_flag IN VARCHAR2
2345: DEFAULT fnd_api.g_miss_char,
2339: DEFAULT fnd_api.g_miss_char,
2340: p_actual_effort IN NUMBER
2341: DEFAULT fnd_api.g_miss_num,
2342: p_actual_effort_uom IN VARCHAR2
2343: DEFAULT fnd_api.g_miss_char,
2344: p_schedule_flag IN VARCHAR2
2345: DEFAULT fnd_api.g_miss_char,
2346: p_alarm_type_code IN VARCHAR2
2347: DEFAULT fnd_api.g_miss_char,
2341: DEFAULT fnd_api.g_miss_num,
2342: p_actual_effort_uom IN VARCHAR2
2343: DEFAULT fnd_api.g_miss_char,
2344: p_schedule_flag IN VARCHAR2
2345: DEFAULT fnd_api.g_miss_char,
2346: p_alarm_type_code IN VARCHAR2
2347: DEFAULT fnd_api.g_miss_char,
2348: p_alarm_contact IN VARCHAR2
2349: DEFAULT fnd_api.g_miss_char,
2343: DEFAULT fnd_api.g_miss_char,
2344: p_schedule_flag IN VARCHAR2
2345: DEFAULT fnd_api.g_miss_char,
2346: p_alarm_type_code IN VARCHAR2
2347: DEFAULT fnd_api.g_miss_char,
2348: p_alarm_contact IN VARCHAR2
2349: DEFAULT fnd_api.g_miss_char,
2350: p_sched_travel_distance IN NUMBER
2351: DEFAULT fnd_api.g_miss_num,
2345: DEFAULT fnd_api.g_miss_char,
2346: p_alarm_type_code IN VARCHAR2
2347: DEFAULT fnd_api.g_miss_char,
2348: p_alarm_contact IN VARCHAR2
2349: DEFAULT fnd_api.g_miss_char,
2350: p_sched_travel_distance IN NUMBER
2351: DEFAULT fnd_api.g_miss_num,
2352: p_sched_travel_duration IN NUMBER
2353: DEFAULT fnd_api.g_miss_num,
2347: DEFAULT fnd_api.g_miss_char,
2348: p_alarm_contact IN VARCHAR2
2349: DEFAULT fnd_api.g_miss_char,
2350: p_sched_travel_distance IN NUMBER
2351: DEFAULT fnd_api.g_miss_num,
2352: p_sched_travel_duration IN NUMBER
2353: DEFAULT fnd_api.g_miss_num,
2354: p_sched_travel_duration_uom IN VARCHAR2
2355: DEFAULT fnd_api.g_miss_char,
2349: DEFAULT fnd_api.g_miss_char,
2350: p_sched_travel_distance IN NUMBER
2351: DEFAULT fnd_api.g_miss_num,
2352: p_sched_travel_duration IN NUMBER
2353: DEFAULT fnd_api.g_miss_num,
2354: p_sched_travel_duration_uom IN VARCHAR2
2355: DEFAULT fnd_api.g_miss_char,
2356: p_actual_travel_distance IN NUMBER
2357: DEFAULT fnd_api.g_miss_num,
2351: DEFAULT fnd_api.g_miss_num,
2352: p_sched_travel_duration IN NUMBER
2353: DEFAULT fnd_api.g_miss_num,
2354: p_sched_travel_duration_uom IN VARCHAR2
2355: DEFAULT fnd_api.g_miss_char,
2356: p_actual_travel_distance IN NUMBER
2357: DEFAULT fnd_api.g_miss_num,
2358: p_actual_travel_duration IN NUMBER
2359: DEFAULT fnd_api.g_miss_num,
2353: DEFAULT fnd_api.g_miss_num,
2354: p_sched_travel_duration_uom IN VARCHAR2
2355: DEFAULT fnd_api.g_miss_char,
2356: p_actual_travel_distance IN NUMBER
2357: DEFAULT fnd_api.g_miss_num,
2358: p_actual_travel_duration IN NUMBER
2359: DEFAULT fnd_api.g_miss_num,
2360: p_actual_travel_duration_uom IN VARCHAR2
2361: DEFAULT fnd_api.g_miss_char,
2355: DEFAULT fnd_api.g_miss_char,
2356: p_actual_travel_distance IN NUMBER
2357: DEFAULT fnd_api.g_miss_num,
2358: p_actual_travel_duration IN NUMBER
2359: DEFAULT fnd_api.g_miss_num,
2360: p_actual_travel_duration_uom IN VARCHAR2
2361: DEFAULT fnd_api.g_miss_char,
2362: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2363: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2357: DEFAULT fnd_api.g_miss_num,
2358: p_actual_travel_duration IN NUMBER
2359: DEFAULT fnd_api.g_miss_num,
2360: p_actual_travel_duration_uom IN VARCHAR2
2361: DEFAULT fnd_api.g_miss_char,
2362: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2363: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2364: p_palm_flag IN VARCHAR2
2365: DEFAULT fnd_api.g_miss_char,
2358: p_actual_travel_duration IN NUMBER
2359: DEFAULT fnd_api.g_miss_num,
2360: p_actual_travel_duration_uom IN VARCHAR2
2361: DEFAULT fnd_api.g_miss_char,
2362: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2363: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2364: p_palm_flag IN VARCHAR2
2365: DEFAULT fnd_api.g_miss_char,
2366: p_wince_flag IN VARCHAR2
2359: DEFAULT fnd_api.g_miss_num,
2360: p_actual_travel_duration_uom IN VARCHAR2
2361: DEFAULT fnd_api.g_miss_char,
2362: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2363: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2364: p_palm_flag IN VARCHAR2
2365: DEFAULT fnd_api.g_miss_char,
2366: p_wince_flag IN VARCHAR2
2367: DEFAULT fnd_api.g_miss_char,
2361: DEFAULT fnd_api.g_miss_char,
2362: p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
2363: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2364: p_palm_flag IN VARCHAR2
2365: DEFAULT fnd_api.g_miss_char,
2366: p_wince_flag IN VARCHAR2
2367: DEFAULT fnd_api.g_miss_char,
2368: p_laptop_flag IN VARCHAR2
2369: DEFAULT fnd_api.g_miss_char,
2363: p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
2364: p_palm_flag IN VARCHAR2
2365: DEFAULT fnd_api.g_miss_char,
2366: p_wince_flag IN VARCHAR2
2367: DEFAULT fnd_api.g_miss_char,
2368: p_laptop_flag IN VARCHAR2
2369: DEFAULT fnd_api.g_miss_char,
2370: p_device1_flag IN VARCHAR2
2371: DEFAULT fnd_api.g_miss_char,
2365: DEFAULT fnd_api.g_miss_char,
2366: p_wince_flag IN VARCHAR2
2367: DEFAULT fnd_api.g_miss_char,
2368: p_laptop_flag IN VARCHAR2
2369: DEFAULT fnd_api.g_miss_char,
2370: p_device1_flag IN VARCHAR2
2371: DEFAULT fnd_api.g_miss_char,
2372: p_device2_flag IN VARCHAR2
2373: DEFAULT fnd_api.g_miss_char,
2367: DEFAULT fnd_api.g_miss_char,
2368: p_laptop_flag IN VARCHAR2
2369: DEFAULT fnd_api.g_miss_char,
2370: p_device1_flag IN VARCHAR2
2371: DEFAULT fnd_api.g_miss_char,
2372: p_device2_flag IN VARCHAR2
2373: DEFAULT fnd_api.g_miss_char,
2374: p_device3_flag IN VARCHAR2
2375: DEFAULT fnd_api.g_miss_char,
2369: DEFAULT fnd_api.g_miss_char,
2370: p_device1_flag IN VARCHAR2
2371: DEFAULT fnd_api.g_miss_char,
2372: p_device2_flag IN VARCHAR2
2373: DEFAULT fnd_api.g_miss_char,
2374: p_device3_flag IN VARCHAR2
2375: DEFAULT fnd_api.g_miss_char,
2376: p_resource_territory_id IN NUMBER
2377: DEFAULT fnd_api.g_miss_num,
2371: DEFAULT fnd_api.g_miss_char,
2372: p_device2_flag IN VARCHAR2
2373: DEFAULT fnd_api.g_miss_char,
2374: p_device3_flag IN VARCHAR2
2375: DEFAULT fnd_api.g_miss_char,
2376: p_resource_territory_id IN NUMBER
2377: DEFAULT fnd_api.g_miss_num,
2378: p_assignment_status_id IN NUMBER
2379: DEFAULT fnd_api.g_miss_num,
2373: DEFAULT fnd_api.g_miss_char,
2374: p_device3_flag IN VARCHAR2
2375: DEFAULT fnd_api.g_miss_char,
2376: p_resource_territory_id IN NUMBER
2377: DEFAULT fnd_api.g_miss_num,
2378: p_assignment_status_id IN NUMBER
2379: DEFAULT fnd_api.g_miss_num,
2380: p_shift_construct_id IN NUMBER
2381: DEFAULT fnd_api.g_miss_num,
2375: DEFAULT fnd_api.g_miss_char,
2376: p_resource_territory_id IN NUMBER
2377: DEFAULT fnd_api.g_miss_num,
2378: p_assignment_status_id IN NUMBER
2379: DEFAULT fnd_api.g_miss_num,
2380: p_shift_construct_id IN NUMBER
2381: DEFAULT fnd_api.g_miss_num,
2382: x_return_status OUT NOCOPY VARCHAR2,
2383: x_msg_count OUT NOCOPY NUMBER,
2377: DEFAULT fnd_api.g_miss_num,
2378: p_assignment_status_id IN NUMBER
2379: DEFAULT fnd_api.g_miss_num,
2380: p_shift_construct_id IN NUMBER
2381: DEFAULT fnd_api.g_miss_num,
2382: x_return_status OUT NOCOPY VARCHAR2,
2383: x_msg_count OUT NOCOPY NUMBER,
2384: x_msg_data OUT NOCOPY VARCHAR2,
2385: p_attribute1 IN VARCHAR2
2484: --Procedure to Delete the Task Assignment
2485: PROCEDURE delete_task_assignment (
2486: p_api_version IN NUMBER,
2487: p_object_version_number IN NUMBER,
2488: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2489: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2490: p_task_assignment_id IN NUMBER,
2491: x_return_status OUT NOCOPY VARCHAR2,
2492: x_msg_count OUT NOCOPY NUMBER,
2485: PROCEDURE delete_task_assignment (
2486: p_api_version IN NUMBER,
2487: p_object_version_number IN NUMBER,
2488: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2489: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2490: p_task_assignment_id IN NUMBER,
2491: x_return_status OUT NOCOPY VARCHAR2,
2492: x_msg_count OUT NOCOPY NUMBER,
2493: x_msg_data OUT NOCOPY VARCHAR2,
2501: := 1.0;
2502: l_api_name CONSTANT VARCHAR2(30)
2503: := 'Delete_Task_Assignment';
2504: l_return_status VARCHAR2(1)
2505: := fnd_api.g_ret_sts_success;
2506: l_msg_data VARCHAR2(2000);
2507: l_msg_count NUMBER;
2508: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
2509: := p_task_assignment_id;
2518:
2519: x CHAR;
2520: BEGIN
2521: SAVEPOINT delete_task_assignment_pub;
2522: x_return_status := fnd_api.g_ret_sts_success;
2523:
2524: IF NOT fnd_api.compatible_api_call (
2525: l_api_version,
2526: p_api_version,
2520: BEGIN
2521: SAVEPOINT delete_task_assignment_pub;
2522: x_return_status := fnd_api.g_ret_sts_success;
2523:
2524: IF NOT fnd_api.compatible_api_call (
2525: l_api_version,
2526: p_api_version,
2527: l_api_name,
2528: g_pkg_name
2527: l_api_name,
2528: g_pkg_name
2529: )
2530: THEN
2531: RAISE fnd_api.g_exc_unexpected_error;
2532: END IF;
2533:
2534: IF fnd_api.to_boolean (p_init_msg_list)
2535: THEN
2530: THEN
2531: RAISE fnd_api.g_exc_unexpected_error;
2532: END IF;
2533:
2534: IF fnd_api.to_boolean (p_init_msg_list)
2535: THEN
2536: fnd_msg_pub.initialize;
2537: END IF;
2538:
2542: -------------
2543: /*p_task_assignments_user_hooks.task_assignment_id := p_task_assignment_id ;
2544: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
2545:
2546: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2547: THEN
2548: x_return_status := fnd_api.g_ret_sts_unexp_error;
2549: RAISE fnd_api.g_exc_unexpected_error;
2550: END IF;
2544: jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
2545:
2546: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2547: THEN
2548: x_return_status := fnd_api.g_ret_sts_unexp_error;
2549: RAISE fnd_api.g_exc_unexpected_error;
2550: END IF;
2551: */ -------------
2552: -------------
2545:
2546: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2547: THEN
2548: x_return_status := fnd_api.g_ret_sts_unexp_error;
2549: RAISE fnd_api.g_exc_unexpected_error;
2550: END IF;
2551: */ -------------
2552: -------------
2553: -------------
2558: IF (l_task_assignment_id IS NULL)
2559: THEN
2560: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_TK_ASS');
2561: fnd_msg_pub.add;
2562: x_return_status := fnd_api.g_ret_sts_unexp_error;
2563: RAISE fnd_api.g_exc_unexpected_error;
2564: END IF;
2565:
2566: jtf_task_assignments_pub.lock_task_assignment (
2559: THEN
2560: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_TK_ASS');
2561: fnd_msg_pub.add;
2562: x_return_status := fnd_api.g_ret_sts_unexp_error;
2563: RAISE fnd_api.g_exc_unexpected_error;
2564: END IF;
2565:
2566: jtf_task_assignments_pub.lock_task_assignment (
2567: p_api_version => 1.0,
2564: END IF;
2565:
2566: jtf_task_assignments_pub.lock_task_assignment (
2567: p_api_version => 1.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_task_assignment_id => p_task_assignment_id,
2571: p_object_version_number => p_object_version_number,
2572: x_return_status => x_return_status,
2565:
2566: jtf_task_assignments_pub.lock_task_assignment (
2567: p_api_version => 1.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_task_assignment_id => p_task_assignment_id,
2571: p_object_version_number => p_object_version_number,
2572: x_return_status => x_return_status,
2573: x_msg_data => x_msg_data,
2573: x_msg_data => x_msg_data,
2574: x_msg_count => x_msg_count
2575: );
2576:
2577: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2578: THEN
2579: x_return_status := fnd_api.g_ret_sts_unexp_error;
2580: RAISE fnd_api.g_exc_unexpected_error;
2581: END IF;
2575: );
2576:
2577: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2578: THEN
2579: x_return_status := fnd_api.g_ret_sts_unexp_error;
2580: RAISE fnd_api.g_exc_unexpected_error;
2581: END IF;
2582:
2583: ---- if task Assignment is NOT valid, then it is an error
2576:
2577: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2578: THEN
2579: x_return_status := fnd_api.g_ret_sts_unexp_error;
2580: RAISE fnd_api.g_exc_unexpected_error;
2581: END IF;
2582:
2583: ---- if task Assignment is NOT valid, then it is an error
2584: /* OPEN ra_d;
2587: IF ra_d%NOTFOUND
2588: THEN
2589: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2590: fnd_msg_pub.add;
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: RAISE fnd_api.g_exc_unexpected_error;
2593: ELSE
2594: jtf_task_assignments_pub.lock_task_assignment (
2595: p_api_version => 1.0,
2588: THEN
2589: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2590: fnd_msg_pub.add;
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: RAISE fnd_api.g_exc_unexpected_error;
2593: ELSE
2594: jtf_task_assignments_pub.lock_task_assignment (
2595: p_api_version => 1.0,
2596: p_init_msg_list => fnd_api.g_false,
2592: RAISE fnd_api.g_exc_unexpected_error;
2593: ELSE
2594: jtf_task_assignments_pub.lock_task_assignment (
2595: p_api_version => 1.0,
2596: p_init_msg_list => fnd_api.g_false,
2597: p_commit => fnd_api.g_false,
2598: p_task_assignment_id => l_task_assignment_id,
2599: p_object_version_number => p_object_version_number,
2600: x_return_status => x_return_status,
2593: ELSE
2594: jtf_task_assignments_pub.lock_task_assignment (
2595: p_api_version => 1.0,
2596: p_init_msg_list => fnd_api.g_false,
2597: p_commit => fnd_api.g_false,
2598: p_task_assignment_id => l_task_assignment_id,
2599: p_object_version_number => p_object_version_number,
2600: x_return_status => x_return_status,
2601: x_msg_data => x_msg_data,
2601: x_msg_data => x_msg_data,
2602: x_msg_count => x_msg_count
2603: );
2604:
2605: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2606: THEN
2607: x_return_status := fnd_api.g_ret_sts_unexp_error;
2608: RAISE fnd_api.g_exc_unexpected_error;
2609: END IF;*/
2603: );
2604:
2605: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2606: THEN
2607: x_return_status := fnd_api.g_ret_sts_unexp_error;
2608: RAISE fnd_api.g_exc_unexpected_error;
2609: END IF;*/
2610: jtf_task_assignments_pvt.delete_task_assignment (
2611: p_api_version => l_api_version,
2604:
2605: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2606: THEN
2607: x_return_status := fnd_api.g_ret_sts_unexp_error;
2608: RAISE fnd_api.g_exc_unexpected_error;
2609: END IF;*/
2610: jtf_task_assignments_pvt.delete_task_assignment (
2611: p_api_version => l_api_version,
2612: p_object_version_number => p_object_version_number,
2609: END IF;*/
2610: jtf_task_assignments_pvt.delete_task_assignment (
2611: p_api_version => l_api_version,
2612: p_object_version_number => p_object_version_number,
2613: p_init_msg_list => fnd_api.g_false,
2614: p_commit => fnd_api.g_false,
2615: p_task_assignment_id => l_task_assignment_id,
2616: x_return_status => x_return_status,
2617: x_msg_count => l_msg_count,
2610: jtf_task_assignments_pvt.delete_task_assignment (
2611: p_api_version => l_api_version,
2612: p_object_version_number => p_object_version_number,
2613: p_init_msg_list => fnd_api.g_false,
2614: p_commit => fnd_api.g_false,
2615: p_task_assignment_id => l_task_assignment_id,
2616: x_return_status => x_return_status,
2617: x_msg_count => l_msg_count,
2618: x_msg_data => l_msg_data,
2619: p_enable_workflow => l_enable_workflow,
2620: p_abort_workflow => l_abort_workflow
2621: );
2622:
2623: IF (x_return_status = fnd_api.g_ret_sts_error)
2624: THEN
2625: RAISE fnd_api.g_exc_error;
2626: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2627: THEN
2621: );
2622:
2623: IF (x_return_status = fnd_api.g_ret_sts_error)
2624: THEN
2625: RAISE fnd_api.g_exc_error;
2626: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2627: THEN
2628: RAISE fnd_api.g_exc_unexpected_error;
2629: END IF;
2622:
2623: IF (x_return_status = fnd_api.g_ret_sts_error)
2624: THEN
2625: RAISE fnd_api.g_exc_error;
2626: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2627: THEN
2628: RAISE fnd_api.g_exc_unexpected_error;
2629: END IF;
2630:
2624: THEN
2625: RAISE fnd_api.g_exc_error;
2626: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2627: THEN
2628: RAISE fnd_api.g_exc_unexpected_error;
2629: END IF;
2630:
2631: -- END IF;
2632:
2642: -------------
2643:
2644: /*jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
2645:
2646: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2647: THEN
2648: x_return_status := fnd_api.g_ret_sts_unexp_error;
2649: RAISE fnd_api.g_exc_unexpected_error;
2650: END IF;
2644: /*jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
2645:
2646: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2647: THEN
2648: x_return_status := fnd_api.g_ret_sts_unexp_error;
2649: RAISE fnd_api.g_exc_unexpected_error;
2650: END IF;
2651: */ -------------
2652: -------------
2645:
2646: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2647: THEN
2648: x_return_status := fnd_api.g_ret_sts_unexp_error;
2649: RAISE fnd_api.g_exc_unexpected_error;
2650: END IF;
2651: */ -------------
2652: -------------
2653: -------------
2651: */ -------------
2652: -------------
2653: -------------
2654: -------------
2655: IF fnd_api.to_boolean (p_commit)
2656: THEN
2657: COMMIT WORK;
2658: END IF;
2659:
2658: END IF;
2659:
2660: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2661: EXCEPTION
2662: WHEN fnd_api.g_exc_error
2663: THEN
2664: ROLLBACK TO delete_task_assignment_pub;
2665: /* IF ra_d%ISOPEN
2666: THEN
2666: THEN
2667: CLOSE ra_d;
2668: END IF;
2669: */
2670: x_return_status := fnd_api.g_ret_sts_error;
2671: fnd_msg_pub.count_and_get (
2672: p_count => x_msg_count,
2673: p_data => x_msg_data
2674: );
2671: fnd_msg_pub.count_and_get (
2672: p_count => x_msg_count,
2673: p_data => x_msg_data
2674: );
2675: WHEN fnd_api.g_exc_unexpected_error
2676: THEN
2677: ROLLBACK TO delete_task_assignment_pub;
2678: /* IF ra_d%ISOPEN
2679: THEN
2680: CLOSE ra_d;
2681: END IF;
2682:
2683: */
2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685: fnd_msg_pub.count_and_get (
2686: p_count => x_msg_count,
2687: p_data => x_msg_data
2688: );
2693: THEN
2694: CLOSE ra_d;
2695: END IF;
2696: */
2697: x_return_status := fnd_api.g_ret_sts_unexp_error;
2698: fnd_msg_pub.count_and_get (
2699: p_count => x_msg_count,
2700: p_data => x_msg_data
2701: );
2705: --overloading delete procedure
2706: PROCEDURE delete_task_assignment (
2707: p_api_version IN NUMBER,
2708: p_object_version_number IN NUMBER,
2709: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2710: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2711: p_task_assignment_id IN NUMBER,
2712: x_return_status OUT NOCOPY VARCHAR2,
2713: x_msg_count OUT NOCOPY NUMBER,
2706: PROCEDURE delete_task_assignment (
2707: p_api_version IN NUMBER,
2708: p_object_version_number IN NUMBER,
2709: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2710: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2711: p_task_assignment_id IN NUMBER,
2712: x_return_status OUT NOCOPY VARCHAR2,
2713: x_msg_count OUT NOCOPY NUMBER,
2714: x_msg_data OUT NOCOPY VARCHAR2