eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_SCHEDULER_PVT dependencies on FND_API

Line 65: RETURN FND_API.g_false ;

61: FETCH c_target_det INTO l_dummy ;
62: CLOSE c_target_det ;
63:
64: IF l_dummy IS NULL THEN
65: RETURN FND_API.g_false ;
66: ELSE
67: RETURN FND_API.g_true;
68: END IF;
69:

Line 67: RETURN FND_API.g_true;

63:
64: IF l_dummy IS NULL THEN
65: RETURN FND_API.g_false ;
66: ELSE
67: RETURN FND_API.g_true;
68: END IF;
69:
70: END Target_Group_Exist ;
71:

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: l_msg_data VARCHAR2(2000);
99: l_debug_mode VARCHAR2(30);
100: --
101: BEGIN
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: l_api_name :='Schedule_Repeat';
104: l_last_run_date := p_last_run_date;
105: l_frequency := p_frequency;
106: l_frequency_type := p_frequency_type;

Line 137: WHEN FND_API.G_EXC_ERROR THEN

133:
134: WRITE_LOG (l_api_name, 'Schedule_Repeat: Success'||'.'||p_last_run_date);
135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.count_and_get (
140: p_count => x_msg_count,
141: p_data => x_msg_data,

Line 138: x_return_status := FND_API.G_RET_STS_ERROR ;

134: WRITE_LOG (l_api_name, 'Schedule_Repeat: Success'||'.'||p_last_run_date);
135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.count_and_get (
140: p_count => x_msg_count,
141: p_data => x_msg_data,
142: p_encoded => FND_API.G_FALSE

Line 142: p_encoded => FND_API.G_FALSE

138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.count_and_get (
140: p_count => x_msg_count,
141: p_data => x_msg_data,
142: p_encoded => FND_API.G_FALSE
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.count_and_get (

Line 144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

140: p_count => x_msg_count,
141: p_data => x_msg_data,
142: p_encoded => FND_API.G_FALSE
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.count_and_get (
147: p_count => x_msg_count,
148: p_data => x_msg_data,

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

141: p_data => x_msg_data,
142: p_encoded => FND_API.G_FALSE
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.count_and_get (
147: p_count => x_msg_count,
148: p_data => x_msg_data,
149: p_encoded => FND_API.G_FALSE

Line 149: p_encoded => FND_API.G_FALSE

145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.count_and_get (
147: p_count => x_msg_count,
148: p_data => x_msg_data,
149: p_encoded => FND_API.G_FALSE
150: );
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: FND_MSG_PUB.count_and_get (

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

148: p_data => x_msg_data,
149: p_encoded => FND_API.G_FALSE
150: );
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: FND_MSG_PUB.count_and_get (
154: p_count => x_msg_count,
155: p_data => x_msg_data,
156: p_encoded => FND_API.G_FALSE

Line 156: p_encoded => FND_API.G_FALSE

152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: FND_MSG_PUB.count_and_get (
154: p_count => x_msg_count,
155: p_data => x_msg_data,
156: p_encoded => FND_API.G_FALSE
157: );
158: END Schedule_Repeat;
159:
160: --=============================================================================================================

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: l_content_item_id NUMBER;
246:
247:
248: BEGIN
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250: l_api_name :='Create_Next_Schedule';
251:
252: l_parent_sched_id := p_parent_sched_id;
253: l_child_sched_st_date := p_child_sched_st_date;

Line 415: p_init_msg_list => FND_API.G_FALSE,

411: CLOSE c_max_sch_det;
412:
413: AMS_Camp_Schedule_PVT.Create_Camp_Schedule(
414: p_api_version_number => 1.0,
415: p_init_msg_list => FND_API.G_FALSE,
416: p_commit => FND_API.G_FALSE,
417: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
418: x_return_status => l_return_status,
419: x_msg_count => l_msg_count,

Line 416: p_commit => FND_API.G_FALSE,

412:
413: AMS_Camp_Schedule_PVT.Create_Camp_Schedule(
414: p_api_version_number => 1.0,
415: p_init_msg_list => FND_API.G_FALSE,
416: p_commit => FND_API.G_FALSE,
417: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
418: x_return_status => l_return_status,
419: x_msg_count => l_msg_count,
420: x_msg_data => l_msg_data,

Line 417: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

413: AMS_Camp_Schedule_PVT.Create_Camp_Schedule(
414: p_api_version_number => 1.0,
415: p_init_msg_list => FND_API.G_FALSE,
416: p_commit => FND_API.G_FALSE,
417: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
418: x_return_status => l_return_status,
419: x_msg_count => l_msg_count,
420: x_msg_data => l_msg_data,
421: p_schedule_rec => l_schedule_rec,

Line 424: IF l_return_status <> FND_API.g_ret_sts_success

420: x_msg_data => l_msg_data,
421: p_schedule_rec => l_schedule_rec,
422: x_schedule_id => l_new_sched_id);
423:
424: IF l_return_status <> FND_API.g_ret_sts_success
425: THEN
426: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After create schedule'||l_return_status||'New Schedule name '||l_schedule_rec.schedule_name);
427: l_return_status := FND_API.g_ret_sts_error;
428:

Line 427: l_return_status := FND_API.g_ret_sts_error;

423:
424: IF l_return_status <> FND_API.g_ret_sts_success
425: THEN
426: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After create schedule'||l_return_status||'New Schedule name '||l_schedule_rec.schedule_name);
427: l_return_status := FND_API.g_ret_sts_error;
428:
429: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
430: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
431: END LOOP;

Line 430: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));

426: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After create schedule'||l_return_status||'New Schedule name '||l_schedule_rec.schedule_name);
427: l_return_status := FND_API.g_ret_sts_error;
428:
429: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
430: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
431: END LOOP;
432:
433: -- schedule creation was not successful
434: x_child_sched_id := null;

Line 454: IF FND_API.G_TRUE = Target_Group_Exist(p_parent_sched_id)

450: FETCH c_get_assoc INTO l_content_item_id;
451: CLOSE c_get_assoc;
452:
453:
454: IF FND_API.G_TRUE = Target_Group_Exist(p_parent_sched_id)
455: THEN
456: -- this if statement added by soagrawa on 23-mar-2004
457: IF l_content_item_id IS NOT null
458: THEN

Line 469: IF l_return_status <> FND_API.g_ret_sts_success

465: x_msg_count => l_msg_count,
466: x_msg_data => l_msg_data
467: );
468:
469: IF l_return_status <> FND_API.g_ret_sts_success
470: THEN
471: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After content association'||l_return_status||'New Schedule name '||l_schedule_rec.schedule_name);
472: l_return_status := FND_API.g_ret_sts_error;
473:

Line 472: l_return_status := FND_API.g_ret_sts_error;

468:
469: IF l_return_status <> FND_API.g_ret_sts_success
470: THEN
471: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After content association'||l_return_status||'New Schedule name '||l_schedule_rec.schedule_name);
472: l_return_status := FND_API.g_ret_sts_error;
473:
474: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
475: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
476: END LOOP;

Line 475: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));

471: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After content association'||l_return_status||'New Schedule name '||l_schedule_rec.schedule_name);
472: l_return_status := FND_API.g_ret_sts_error;
473:
474: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
475: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
476: END LOOP;
477:
478: -- association creation was not successful
479: x_child_sched_id := null;

Line 515: p_init_msg_list => FND_API.G_FALSE,

511: -- copy metrices
512: WRITE_LOG(l_api_name, 'Create_Next_Schedule: Start Copy metrics for New Schedule name '||l_schedule_rec.schedule_name);
513: Ams_ActMetric_Pvt.copy_act_metrics (
514: p_api_version => 1.0,
515: p_init_msg_list => FND_API.G_FALSE,
516: p_commit => FND_API.G_FALSE,
517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
518: p_source_object_type => 'CSCH',
519: p_source_object_id => l_parent_rec.schedule_id,

Line 516: p_commit => FND_API.G_FALSE,

512: WRITE_LOG(l_api_name, 'Create_Next_Schedule: Start Copy metrics for New Schedule name '||l_schedule_rec.schedule_name);
513: Ams_ActMetric_Pvt.copy_act_metrics (
514: p_api_version => 1.0,
515: p_init_msg_list => FND_API.G_FALSE,
516: p_commit => FND_API.G_FALSE,
517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
518: p_source_object_type => 'CSCH',
519: p_source_object_id => l_parent_rec.schedule_id,
520: p_target_object_id => l_new_sched_id,

Line 517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

513: Ams_ActMetric_Pvt.copy_act_metrics (
514: p_api_version => 1.0,
515: p_init_msg_list => FND_API.G_FALSE,
516: p_commit => FND_API.G_FALSE,
517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
518: p_source_object_type => 'CSCH',
519: p_source_object_id => l_parent_rec.schedule_id,
520: p_target_object_id => l_new_sched_id,
521: x_return_status => l_return_status,

Line 525: IF l_return_status <> FND_API.g_ret_sts_success

521: x_return_status => l_return_status,
522: x_msg_count => l_msg_count,
523: x_msg_data => l_msg_data);
524:
525: IF l_return_status <> FND_API.g_ret_sts_success
526: THEN
527: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy metrics'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
528: l_return_status := FND_API.g_ret_sts_error;
529: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP

Line 528: l_return_status := FND_API.g_ret_sts_error;

524:
525: IF l_return_status <> FND_API.g_ret_sts_success
526: THEN
527: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy metrics'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
528: l_return_status := FND_API.g_ret_sts_error;
529: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
530: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
531: END LOOP;
532:

Line 530: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));

526: THEN
527: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy metrics'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
528: l_return_status := FND_API.g_ret_sts_error;
529: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
530: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
531: END LOOP;
532:
533: -- metrics copying was not successful
534: x_child_sched_id := null;

Line 546: IF FND_API.G_TRUE = Target_Group_Exist(p_parent_sched_id)

542: END IF;
543:
544: WRITE_LOG (l_api_name, 'Create_Next_Schedule: Before copying TGRP, being copied from CSCH id '||l_tgrp_copy_from_csch_id);
545:
546: IF FND_API.G_TRUE = Target_Group_Exist(p_parent_sched_id)
547: THEN
548: -- copy target group
549: AMS_ACT_LIST_PVT.copy_target_group(
550: p_from_schedule_id => l_tgrp_copy_from_csch_id,

Line 554: p_repeat_flag => FND_API.G_TRUE,

550: p_from_schedule_id => l_tgrp_copy_from_csch_id,
551: p_to_schedule_id => l_new_sched_id,
552: p_list_used_by => 'CSCH',
553: -- soagrawa made this change on 21-apr-2003 for bug# 3570234
554: p_repeat_flag => FND_API.G_TRUE,
555: x_msg_count => l_msg_count,
556: x_msg_data => l_msg_data,
557: x_return_status => l_return_status
558: ) ;

Line 560: IF l_return_status <> FND_API.g_ret_sts_success

556: x_msg_data => l_msg_data,
557: x_return_status => l_return_status
558: ) ;
559:
560: IF l_return_status <> FND_API.g_ret_sts_success
561: THEN
562: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy target group'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
563: l_return_status := FND_API.g_ret_sts_error;
564: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP

Line 563: l_return_status := FND_API.g_ret_sts_error;

559:
560: IF l_return_status <> FND_API.g_ret_sts_success
561: THEN
562: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy target group'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
563: l_return_status := FND_API.g_ret_sts_error;
564: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
565: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
566: END LOOP;
567:

Line 565: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));

561: THEN
562: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy target group'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
563: l_return_status := FND_API.g_ret_sts_error;
564: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
565: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
566: END LOOP;
567:
568: -- target group copying was not successful
569: x_child_sched_id := null;

Line 637: x_return_status := FND_API.G_RET_STS_SUCCESS;

633:
634:
635: BEGIN
636:
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638:
639: OPEN c_id;
640: FETCH c_id INTO l_scheduler_id;
641: CLOSE c_id;