DBA Data[Home] [Help]

APPS.CAC_TASK_PURGE_PUB dependencies on FND_MSG_PUB

Line 85: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

81:
82:
83: END IF;--for IF l_tab_task_ids.COUNT > 0
84:
85: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
86:
87: EXCEPTION
88: WHEN fnd_api.g_exc_unexpected_error
89: THEN

Line 92: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

88: WHEN fnd_api.g_exc_unexpected_error
89: THEN
90: ROLLBACK TO purge_task_attach;
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
93: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
94: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_return_status= '||x_return_status);
95: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_data= '||x_msg_data);
96: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_count= '||x_msg_count);

Line 104: fnd_msg_pub.add;

100: THEN
101: ROLLBACK TO purge_task_attach;
102: fnd_message.set_name ('JTF', 'JTF_ATTACHMENT_PURGE_EXCEP');
103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
104: fnd_msg_pub.add;
105: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
106: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_return_status= '||x_return_status);
107: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_data= '||x_msg_data);
108: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_count= '||x_msg_count);

Line 112: fnd_msg_pub.count_and_get (

108: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_count= '||x_msg_count);
109: end if;
110:
111: x_return_status := fnd_api.g_ret_sts_unexp_error;
112: fnd_msg_pub.count_and_get (
113: p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116:

Line 166: fnd_msg_pub.initialize;

162: END IF;
163:
164: IF fnd_api.to_boolean (p_init_msg_list)
165: THEN
166: fnd_msg_pub.initialize;
167: END IF;
168: --Logging input parameters
169:
170: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 397: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

393: THEN
394: COMMIT WORK;
395: END IF;
396:
397: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
398:
399:
400: EXCEPTION
401: WHEN fnd_api.g_exc_unexpected_error

Line 405: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

401: WHEN fnd_api.g_exc_unexpected_error
402: THEN
403: ROLLBACK TO purge_tasks;
404: x_return_status := fnd_api.g_ret_sts_unexp_error;
405: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
406: if (get_tasks_ids%ISOPEN) then
407: Close get_tasks_ids;
408: END IF;
409: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 411: FND_MSG_PUB.Count_Msg > 0

407: Close get_tasks_ids;
408: END IF;
409: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
410: IF
411: FND_MSG_PUB.Count_Msg > 0
412: THEN
413: FOR
414: i IN 1..FND_MSG_PUB.Count_Msg
415: LOOP

Line 414: i IN 1..FND_MSG_PUB.Count_Msg

410: IF
411: FND_MSG_PUB.Count_Msg > 0
412: THEN
413: FOR
414: i IN 1..FND_MSG_PUB.Count_Msg
415: LOOP
416: FND_MSG_PUB.Get
417: (
418: p_msg_index => i

Line 416: FND_MSG_PUB.Get

412: THEN
413: FOR
414: i IN 1..FND_MSG_PUB.Count_Msg
415: LOOP
416: FND_MSG_PUB.Get
417: (
418: p_msg_index => i
419: , p_encoded => 'F'
420: , p_data => x_msg_data

Line 438: fnd_msg_pub.add;

434: THEN
435: ROLLBACK TO purge_tasks;
436: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
437: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
438: fnd_msg_pub.add;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: if (get_tasks_ids%ISOPEN) then
441: Close get_tasks_ids;
442: END IF;

Line 443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: if (get_tasks_ids%ISOPEN) then
441: Close get_tasks_ids;
442: END IF;
443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
444: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
445: IF
446: FND_MSG_PUB.Count_Msg > 0
447: THEN

Line 446: FND_MSG_PUB.Count_Msg > 0

442: END IF;
443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
444: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
445: IF
446: FND_MSG_PUB.Count_Msg > 0
447: THEN
448: FOR
449: i IN 1..FND_MSG_PUB.Count_Msg
450: LOOP

Line 449: i IN 1..FND_MSG_PUB.Count_Msg

445: IF
446: FND_MSG_PUB.Count_Msg > 0
447: THEN
448: FOR
449: i IN 1..FND_MSG_PUB.Count_Msg
450: LOOP
451: FND_MSG_PUB.Get
452: (
453: p_msg_index => i

Line 451: FND_MSG_PUB.Get

447: THEN
448: FOR
449: i IN 1..FND_MSG_PUB.Count_Msg
450: LOOP
451: FND_MSG_PUB.Get
452: (
453: p_msg_index => i
454: , p_encoded => 'F'
455: , p_data => x_msg_data

Line 519: fnd_msg_pub.initialize;

515: END IF;
516:
517: IF fnd_api.to_boolean (p_init_msg_list)
518: THEN
519: fnd_msg_pub.initialize;
520: END IF;
521: --Logging input parameters
522:
523: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 632: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

628: THEN
629: COMMIT WORK;
630: END IF;
631:
632: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
633:
634: EXCEPTION
635: WHEN fnd_api.g_exc_unexpected_error
636: THEN

Line 642: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

638: if (tasks_ids%ISOPEN) then
639: CLOSE tasks_ids;
640: end if;
641: x_return_status := fnd_api.g_ret_sts_unexp_error;
642: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
643:
644:
645: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
646: IF

Line 647: FND_MSG_PUB.Count_Msg > 0

643:
644:
645: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
646: IF
647: FND_MSG_PUB.Count_Msg > 0
648: THEN
649: FOR
650: i IN 1..FND_MSG_PUB.Count_Msg
651: LOOP

Line 650: i IN 1..FND_MSG_PUB.Count_Msg

646: IF
647: FND_MSG_PUB.Count_Msg > 0
648: THEN
649: FOR
650: i IN 1..FND_MSG_PUB.Count_Msg
651: LOOP
652: FND_MSG_PUB.Get
653: (
654: p_msg_index => i

Line 652: FND_MSG_PUB.Get

648: THEN
649: FOR
650: i IN 1..FND_MSG_PUB.Count_Msg
651: LOOP
652: FND_MSG_PUB.Get
653: (
654: p_msg_index => i
655: , p_encoded => 'F'
656: , p_data => x_msg_data

Line 677: fnd_msg_pub.add;

673: CLOSE tasks_ids;
674: end if;
675: fnd_message.set_name ('JTF', 'JTF_TASK_VALID_UNKNOWN_ERR');
676: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
677: fnd_msg_pub.add;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:
680: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
681: IF FND_MSG_PUB.Count_Msg > 0

Line 681: IF FND_MSG_PUB.Count_Msg > 0

677: fnd_msg_pub.add;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:
680: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
681: IF FND_MSG_PUB.Count_Msg > 0
682: THEN
683: FOR
684: i IN 1..FND_MSG_PUB.Count_Msg
685: LOOP

Line 684: i IN 1..FND_MSG_PUB.Count_Msg

680: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
681: IF FND_MSG_PUB.Count_Msg > 0
682: THEN
683: FOR
684: i IN 1..FND_MSG_PUB.Count_Msg
685: LOOP
686: FND_MSG_PUB.Get
687: (
688: p_msg_index => i

Line 686: FND_MSG_PUB.Get

682: THEN
683: FOR
684: i IN 1..FND_MSG_PUB.Count_Msg
685: LOOP
686: FND_MSG_PUB.Get
687: (
688: p_msg_index => i
689: , p_encoded => 'F'
690: , p_data => x_msg_data