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 506: p_init_msg_list => FND_API.G_FALSE,

502: -- copy metrices
503: WRITE_LOG(l_api_name, 'Create_Next_Schedule: Start Copy metrics for New Schedule name '||l_schedule_rec.schedule_name);
504: Ams_ActMetric_Pvt.copy_act_metrics (
505: p_api_version => 1.0,
506: p_init_msg_list => FND_API.G_FALSE,
507: p_commit => FND_API.G_FALSE,
508: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
509: p_source_object_type => 'CSCH',
510: p_source_object_id => l_parent_rec.schedule_id,

Line 507: p_commit => FND_API.G_FALSE,

503: WRITE_LOG(l_api_name, 'Create_Next_Schedule: Start Copy metrics for New Schedule name '||l_schedule_rec.schedule_name);
504: Ams_ActMetric_Pvt.copy_act_metrics (
505: p_api_version => 1.0,
506: p_init_msg_list => FND_API.G_FALSE,
507: p_commit => FND_API.G_FALSE,
508: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
509: p_source_object_type => 'CSCH',
510: p_source_object_id => l_parent_rec.schedule_id,
511: p_target_object_id => l_new_sched_id,

Line 508: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

504: Ams_ActMetric_Pvt.copy_act_metrics (
505: p_api_version => 1.0,
506: p_init_msg_list => FND_API.G_FALSE,
507: p_commit => FND_API.G_FALSE,
508: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
509: p_source_object_type => 'CSCH',
510: p_source_object_id => l_parent_rec.schedule_id,
511: p_target_object_id => l_new_sched_id,
512: x_return_status => l_return_status,

Line 516: IF l_return_status <> FND_API.g_ret_sts_success

512: x_return_status => l_return_status,
513: x_msg_count => l_msg_count,
514: x_msg_data => l_msg_data);
515:
516: IF l_return_status <> FND_API.g_ret_sts_success
517: THEN
518: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy metrics'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
519: l_return_status := FND_API.g_ret_sts_error;
520: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP

Line 519: l_return_status := FND_API.g_ret_sts_error;

515:
516: IF l_return_status <> FND_API.g_ret_sts_success
517: THEN
518: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy metrics'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
519: l_return_status := FND_API.g_ret_sts_error;
520: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
521: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
522: END LOOP;
523:

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

517: THEN
518: WRITE_LOG(l_api_name, 'Create_Next_Schedule: ERROR: After copy metrics'||l_return_status||'for new schedule name '||l_schedule_rec.schedule_name);
519: l_return_status := FND_API.g_ret_sts_error;
520: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
521: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
522: END LOOP;
523:
524: -- metrics copying was not successful
525: x_child_sched_id := null;

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

533: END IF;
534:
535: WRITE_LOG (l_api_name, 'Create_Next_Schedule: Before copying TGRP, being copied from CSCH id '||l_tgrp_copy_from_csch_id);
536:
537: IF FND_API.G_TRUE = Target_Group_Exist(p_parent_sched_id)
538: THEN
539: -- copy target group
540: AMS_ACT_LIST_PVT.copy_target_group(
541: p_from_schedule_id => l_tgrp_copy_from_csch_id,

Line 545: p_repeat_flag => FND_API.G_TRUE,

541: p_from_schedule_id => l_tgrp_copy_from_csch_id,
542: p_to_schedule_id => l_new_sched_id,
543: p_list_used_by => 'CSCH',
544: -- soagrawa made this change on 21-apr-2003 for bug# 3570234
545: p_repeat_flag => FND_API.G_TRUE,
546: x_msg_count => l_msg_count,
547: x_msg_data => l_msg_data,
548: x_return_status => l_return_status
549: ) ;

Line 551: IF l_return_status <> FND_API.g_ret_sts_success

547: x_msg_data => l_msg_data,
548: x_return_status => l_return_status
549: ) ;
550:
551: IF l_return_status <> FND_API.g_ret_sts_success
552: THEN
553: 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);
554: l_return_status := FND_API.g_ret_sts_error;
555: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP

Line 554: l_return_status := FND_API.g_ret_sts_error;

550:
551: IF l_return_status <> FND_API.g_ret_sts_success
552: THEN
553: 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);
554: l_return_status := FND_API.g_ret_sts_error;
555: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
556: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
557: END LOOP;
558:

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

552: THEN
553: 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);
554: l_return_status := FND_API.g_ret_sts_error;
555: FOR i IN 1 .. FND_MSG_PUB.count_msg LOOP
556: WRITE_LOG(l_api_name, 'Create_Next_Schedule : (' || i || ') ' || FND_MSG_PUB.get(i, FND_API.g_false));
557: END LOOP;
558:
559: -- target group copying was not successful
560: x_child_sched_id := null;

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624:
625:
626: BEGIN
627:
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: OPEN c_id;
631: FETCH c_id INTO l_scheduler_id;
632: CLOSE c_id;