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_ADVERTISEMENTS_PUB dependencies on FND_API

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set', x_Log_Level => 6);
157: END IF;
158:
159: --initialize the return status.
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162: -- Initialise the error stack
163: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set');
164:

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: -- If there are any messages in the stack then set x_return_status
322:
323: IF FND_MSG_PUB.Count_Msg > 0 THEN
324:
325: x_return_status := FND_API.G_RET_STS_ERROR;
326:
327: END IF;
328:
329: -- Put any message text from message stack into the Message ARRAY

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

333: -- Set the excetption Message and the stack
334: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Prepare_Adv_Action_Set'
335: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
336: --
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
338: RAISE; -- This is optional depending on the needs
339:
340: END Process_Action_Set;
341:

Line 553: AND l_return_status = FND_API.G_RET_STS_ERROR THEN

549: x_action_line_result_code := pa_action_set_utils.G_REVERSED_CUSTOM_AUDIT;
550: ELSIF (p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_EMAIL' OR
551: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' OR
552: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
553: AND l_return_status = FND_API.G_RET_STS_ERROR THEN
554: x_action_line_result_code := pa_action_set_utils.G_REVERSED_CUSTOM_AUDIT;
555: ELSE
556: x_action_line_result_code := pa_action_set_utils.G_REVERSED_DEFAULT_AUDIT;
557: END IF;

Line 567: AND l_return_status = FND_API.G_RET_STS_ERROR THEN

563: x_action_line_result_code := pa_action_set_utils.G_UPDATED_CUSTOM_AUDIT;
564: ELSIF (p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_EMAIL' OR
565: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_PERSON' OR
566: p_action_set_line_rec.action_code = 'ADVERTISEMENT_SEND_NTF_ROLE')
567: AND l_return_status = FND_API.G_RET_STS_ERROR THEN
568: x_action_line_result_code := pa_action_set_utils.G_UPDATED_CUSTOM_AUDIT;
569: ELSE
570: x_action_line_result_code := pa_action_set_utils.G_UPDATED_DEFAULT_AUDIT;
571: END IF;

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

608: PROCEDURE Reevaluate_Adv_Action_Set (
609: p_object_id IN pa_action_sets.object_id%TYPE
610: , p_object_type IN pa_action_sets.object_type%TYPE
611: , p_new_object_start_date IN DATE
612: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
613: , p_api_version IN NUMBER := 1.0
614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
615: , p_commit IN VARCHAR2 := FND_API.G_FALSE
616: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

610: , p_object_type IN pa_action_sets.object_type%TYPE
611: , p_new_object_start_date IN DATE
612: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
613: , p_api_version IN NUMBER := 1.0
614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
615: , p_commit IN VARCHAR2 := FND_API.G_FALSE
616: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
617: ) IS
618:

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

611: , p_new_object_start_date IN DATE
612: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
613: , p_api_version IN NUMBER := 1.0
614: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
615: , p_commit IN VARCHAR2 := FND_API.G_FALSE
616: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
617: ) IS
618:
619: l_return_status VARCHAR2(1);

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: PA_DEBUG.WRITE_LOG(x_Module => 'pa.plsql.PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set.begin',x_Msg => 'in PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set', x_Log_Level => 6);
654: END IF;
655:
656: --initialize the return status.
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: -- Initialise the error stack
660: PA_DEBUG.init_err_stack('PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set');
661:

Line 688: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

684: , p_action_set_status_code => l_adv_action_set_status_code
685: , p_action_set_actual_start_date => l_adv_action_set_start_date
686: , x_return_status => l_return_status
687: );
688: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: END IF;
691:
692: -- get all completed action lines whose conditions are no longer met

Line 689: x_return_status := FND_API.G_RET_STS_ERROR;

685: , p_action_set_actual_start_date => l_adv_action_set_start_date
686: , x_return_status => l_return_status
687: );
688: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: END IF;
691:
692: -- get all completed action lines whose conditions are no longer met
693: SELECT asl.action_set_line_id, 'UPDATE_PENDING', aslc.condition_date, aslc.action_set_line_condition_id

Line 708: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

704: p_action_set_line_id_tbl => l_action_set_line_id_tbl
705: ,p_line_status_tbl => l_action_status_code_tbl
706: ,x_return_status => l_return_status
707: );
708: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711:
712: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

Line 709: x_return_status := FND_API.G_RET_STS_ERROR;

705: ,p_line_status_tbl => l_action_status_code_tbl
706: ,x_return_status => l_return_status
707: );
708: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: END IF;
711:
712: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
713: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl

Line 717: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

713: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl
714: ,p_condition_date_tbl => l_condition_date_tbl
715: ,x_return_status => l_return_status
716: );
717: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: END IF;
720:
721: -- reset the plsql tables

Line 718: x_return_status := FND_API.G_RET_STS_ERROR;

714: ,p_condition_date_tbl => l_condition_date_tbl
715: ,x_return_status => l_return_status
716: );
717: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: END IF;
720:
721: -- reset the plsql tables
722: l_action_set_line_id_tbl.DELETE;

Line 748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

744: p_action_set_line_id_tbl => l_action_set_line_id_tbl
745: ,p_line_status_tbl => l_action_status_code_tbl
746: ,x_return_status => l_return_status
747: );
748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: END IF;
751:
752: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(

Line 749: x_return_status := FND_API.G_RET_STS_ERROR;

745: ,p_line_status_tbl => l_action_status_code_tbl
746: ,x_return_status => l_return_status
747: );
748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: END IF;
751:
752: PA_ACTION_SETS_PVT.Bulk_Update_Condition_Date(
753: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl

Line 757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

753: p_action_line_condition_id_tbl => l_action_line_cond_id_tbl
754: ,p_condition_date_tbl => l_condition_date_tbl
755: ,x_return_status => l_return_status
756: );
757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: END IF;
760:
761: -- call generic action set API to perform the action set again

Line 758: x_return_status := FND_API.G_RET_STS_ERROR;

754: ,p_condition_date_tbl => l_condition_date_tbl
755: ,x_return_status => l_return_status
756: );
757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: END IF;
760:
761: -- call generic action set API to perform the action set again
762: PA_ACTION_SETS_PUB.Perform_Single_Action_Set(

Line 769: ,p_init_msg_list => FND_API.G_FALSE

765: ,p_object_id => p_object_id
766: ,p_object_type => 'OPEN_ASSIGNMENT'
767: ,p_validate_only => p_validate_only
768: ,p_commit => p_commit
769: ,p_init_msg_list => FND_API.G_FALSE
770: ,x_return_status => l_return_status
771: ,x_msg_count => l_msg_count
772: ,x_msg_data => l_msg_data);
773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

769: ,p_init_msg_list => FND_API.G_FALSE
770: ,x_return_status => l_return_status
771: ,x_msg_count => l_msg_count
772: ,x_msg_data => l_msg_data);
773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: END IF;
776:
777: END IF;

Line 774: x_return_status := FND_API.G_RET_STS_ERROR;

770: ,x_return_status => l_return_status
771: ,x_msg_count => l_msg_count
772: ,x_msg_data => l_msg_data);
773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: END IF;
776:
777: END IF;
778:

Line 786: x_return_status := FND_API.G_RET_STS_ERROR;

782: -- If there are any messages in the stack then set x_return_status
783:
784: IF FND_MSG_PUB.Count_Msg > 0 THEN
785:
786: x_return_status := FND_API.G_RET_STS_ERROR;
787:
788: END IF;
789:
790: -- Put any message text from message stack into the Message ARRAY

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

794: -- Set the excetption Message and the stack
795: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ADVERTISEMENTS_PUB.Reevaluate_Adv_Action_Set'
796: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
797: --
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
799: RAISE; -- This is optional depending on the needs
800:
801: END Reevaluate_Adv_Action_Set;
802: