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.PA_PROJ_STAT_ACTSET dependencies on FND_API

Line 16: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

12: l_line_number_tbl pa_action_set_utils.number_tbl_type;
13: l_line_id_tbl pa_action_set_utils.number_tbl_type;
14: l_line_cond_id_tbl pa_action_set_utils.number_tbl_type;
15: l_line_cond_date_tbl pa_action_set_utils.date_tbl_type;
16: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
17: l_loop_cnt NUMBER;
18:
19: BEGIN
20: --initialize error stack

Line 78: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then

74: -- p_action_line_condition_id_tbl => l_line_cond_id_tbl
75: -- ,p_condition_date_tbl => l_line_cond_date_tbl
76: -- ,x_return_status => l_return_status
77: -- );
78: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then
79: -- x_return_status := FND_API.G_RET_STS_ERROR;
80: -- end if;
81: -- END IF;
82:

Line 79: -- x_return_status := FND_API.G_RET_STS_ERROR;

75: -- ,p_condition_date_tbl => l_line_cond_date_tbl
76: -- ,x_return_status => l_return_status
77: -- );
78: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then
79: -- x_return_status := FND_API.G_RET_STS_ERROR;
80: -- end if;
81: -- END IF;
82:
83: PA_DEBUG.RESET_ERR_STACK;

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

87: WHEN OTHERS THEN
88: -- Set the excetption Message and the stack
89: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.process_action_set'
90: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
92: RAISE;
93:
94: END process_action_set;
95:

Line 427: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

423:
424: -- Set the exception Message and the stack
425: --FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_proj_stat_actset.perform_selected_action'
426: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack );
427: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: -- x_msg_count := 1;
429: -- x_msg_data := substr(SQLERRM,1,2000);
430: END perform_selected_action;
431:

Line 481: x_return_status := fnd_api.g_ret_sts_success;

477: l_commit_flag VARCHAR2(1) := 'Y';
478:
479: BEGIN
480:
481: x_return_status := fnd_api.g_ret_sts_success;
482: PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.copy_action_sets');
483: savepoint copy_proj_action_sets;
484:
485:

Line 496: ,p_validate_only => FND_API.G_FALSE

492: pa_action_sets_pub.apply_action_set
493: (p_action_set_id => c_action_set_rec.action_set_id
494: ,p_object_type => 'PA_PROJ_STATUS_REPORTS'
495: ,p_object_id => cp_layout_id.object_page_layout_id
496: ,p_validate_only => FND_API.G_FALSE
497: ,x_new_action_set_id => l_new_action_set_id
498: ,x_return_status => x_return_status
499: ,x_msg_count => x_msg_count
500: ,x_msg_data => x_msg_data);

Line 503: if x_return_status <> fnd_api.g_ret_sts_success then

499: ,x_msg_count => x_msg_count
500: ,x_msg_data => x_msg_data);
501:
502: close c_new_proj_layout_ids;
503: if x_return_status <> fnd_api.g_ret_sts_success then
504: l_commit_flag := 'N';
505: end if;
506: else
507: close c_new_proj_layout_ids;

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

522: ROLLBACK TO copy_proj_action_sets;
523: -- Set the exception Message and the stack
524: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_proj_stat_actset.copy_action_sets'
525: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527: RAISE;
528:
529: END copy_action_sets;
530:

Line 538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

534: ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
535: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
537: ,p_api_version IN NUMBER := 1.0
538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
540: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
541: ,x_return_status OUT NOCOPY VARCHAR2
542: ,x_msg_count OUT NOCOPY NUMBER

Line 539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

535: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
537: ,p_api_version IN NUMBER := 1.0
538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
540: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
541: ,x_return_status OUT NOCOPY VARCHAR2
542: ,x_msg_count OUT NOCOPY NUMBER
543: ,x_msg_data OUT NOCOPY VARCHAR2

Line 540: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

536: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
537: ,p_api_version IN NUMBER := 1.0
538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
540: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
541: ,x_return_status OUT NOCOPY VARCHAR2
542: ,x_msg_count OUT NOCOPY NUMBER
543: ,x_msg_data OUT NOCOPY VARCHAR2
544: ) IS

Line 599: ,p_init_msg_list => FND_API.G_TRUE

595: (p_action_set_id => l_action_set_id
596: ,p_action_set_type_code => p_action_set_type_code
597: ,p_object_type => p_object_type
598: ,p_object_id => p_object_id
599: ,p_init_msg_list => FND_API.G_TRUE
600: ,p_record_version_number => l_record_version_number
601: ,p_commit => p_commit
602: ,p_validate_only => p_validate_only
603: ,x_return_status => x_return_status

Line 617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

613: WHEN OTHERS THEN
614: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.delete_action_set'
615: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618: RAISE;
619:
620: END delete_action_set;
621:

Line 632: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

628: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
629: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
630: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
631: ,p_api_version IN NUMBER := 1.0
632: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
633: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
634: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
635: ,x_new_action_set_id OUT NOCOPY NUMBER
636: ,x_return_status OUT NOCOPY VARCHAR2

Line 633: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

629: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
630: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
631: ,p_api_version IN NUMBER := 1.0
632: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
633: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
634: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
635: ,x_new_action_set_id OUT NOCOPY NUMBER
636: ,x_return_status OUT NOCOPY VARCHAR2
637: ,x_msg_count OUT NOCOPY NUMBER

Line 634: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

630: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
631: ,p_api_version IN NUMBER := 1.0
632: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
633: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
634: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
635: ,x_new_action_set_id OUT NOCOPY NUMBER
636: ,x_return_status OUT NOCOPY VARCHAR2
637: ,x_msg_count OUT NOCOPY NUMBER
638: ,x_msg_data OUT NOCOPY VARCHAR2

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

740: WHEN OTHERS THEN
741: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJ_STAT_ACTSET.update_action_set'
742: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
743:
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: RAISE;
746:
747: END update_action_set;
748: