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

Line 77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

73:
74:
75: procedure ADD_CONTROL_ITEM(
76: p_api_version IN NUMBER := 1.0
77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
78: ,p_commit IN VARCHAR2 := FND_API.g_false
79: ,p_validate_only IN VARCHAR2 := FND_API.g_true
80: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
81:

Line 78: ,p_commit IN VARCHAR2 := FND_API.g_false

74:
75: procedure ADD_CONTROL_ITEM(
76: p_api_version IN NUMBER := 1.0
77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
78: ,p_commit IN VARCHAR2 := FND_API.g_false
79: ,p_validate_only IN VARCHAR2 := FND_API.g_true
80: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
81:
82: ,p_ci_type_id IN NUMBER

Line 79: ,p_validate_only IN VARCHAR2 := FND_API.g_true

75: procedure ADD_CONTROL_ITEM(
76: p_api_version IN NUMBER := 1.0
77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
78: ,p_commit IN VARCHAR2 := FND_API.g_false
79: ,p_validate_only IN VARCHAR2 := FND_API.g_true
80: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
81:
82: ,p_ci_type_id IN NUMBER
83: ,p_summary IN VARCHAR2

Line 80: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

76: p_api_version IN NUMBER := 1.0
77: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
78: ,p_commit IN VARCHAR2 := FND_API.g_false
79: ,p_validate_only IN VARCHAR2 := FND_API.g_true
80: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
81:
82: ,p_ci_type_id IN NUMBER
83: ,p_summary IN VARCHAR2
84: ,p_status_code IN VARCHAR2

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

170: -- Initialize the Error Stack
171: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.Add_Control_Item');
172:
173: -- Initialize the return status to success
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: --Clear the global PL/SQL message table
177: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
178: FND_MSG_PUB.initialize;

Line 177: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

173: -- Initialize the return status to success
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: --Clear the global PL/SQL message table
177: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
178: FND_MSG_PUB.initialize;
179: END IF;
180: --get hz_parties.party_id of the logged in user
181: -- l_last_modified_by_id := nvl(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id);

Line 344: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

340: -- IF the number of messages is 1 then fetch the message code from the stack
341: -- and return its text
342: x_msg_count := FND_MSG_PUB.Count_Msg;
343: IF x_msg_count = 1 THEN
344: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
345: ,p_msg_index => 1
346: ,p_data => x_msg_data
347: ,p_msg_index_out => l_msg_index_out
348: );

Line 362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

358: -- Set the excetption Message and the stack
359: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.ADD_CONTROL_ITEM'
360: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
361:
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: RAISE;
364:
365: end ADD_CONTROL_ITEM;
366:

Line 369: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

365: end ADD_CONTROL_ITEM;
366:
367: procedure UPDATE_CONTROL_ITEM (
368: p_api_version IN NUMBER := 1.0
369: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
370: ,p_commit IN VARCHAR2 := FND_API.g_false
371: ,p_validate_only IN VARCHAR2 := FND_API.g_true
372: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
373: ,p_ci_id IN NUMBER

Line 370: ,p_commit IN VARCHAR2 := FND_API.g_false

366:
367: procedure UPDATE_CONTROL_ITEM (
368: p_api_version IN NUMBER := 1.0
369: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
370: ,p_commit IN VARCHAR2 := FND_API.g_false
371: ,p_validate_only IN VARCHAR2 := FND_API.g_true
372: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
373: ,p_ci_id IN NUMBER
374: ,p_ci_type_id IN NUMBER

Line 371: ,p_validate_only IN VARCHAR2 := FND_API.g_true

367: procedure UPDATE_CONTROL_ITEM (
368: p_api_version IN NUMBER := 1.0
369: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
370: ,p_commit IN VARCHAR2 := FND_API.g_false
371: ,p_validate_only IN VARCHAR2 := FND_API.g_true
372: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
373: ,p_ci_id IN NUMBER
374: ,p_ci_type_id IN NUMBER
375: ,p_summary IN VARCHAR2

Line 372: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

368: p_api_version IN NUMBER := 1.0
369: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
370: ,p_commit IN VARCHAR2 := FND_API.g_false
371: ,p_validate_only IN VARCHAR2 := FND_API.g_true
372: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
373: ,p_ci_id IN NUMBER
374: ,p_ci_type_id IN NUMBER
375: ,p_summary IN VARCHAR2
376: ,p_status_code IN VARCHAR2 := NULL

Line 467: x_return_status := FND_API.G_RET_STS_SUCCESS;

463: -- Initialize the Error Stack
464: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM');
465:
466: -- Initialize the return status to success
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: --Clear the global PL/SQL message table
470: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
471: FND_MSG_PUB.initialize;

Line 470: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

466: -- Initialize the return status to success
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: --Clear the global PL/SQL message table
470: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
471: FND_MSG_PUB.initialize;
472: END IF;
473:
474: --get hz_parties.party_id of the logged in user

Line 652: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

648: -- IF the number of messaages is 1 then fetch the message code from the stack
649: -- and return its text
650: x_msg_count := FND_MSG_PUB.Count_Msg;
651: IF x_msg_count = 1 THEN
652: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
653: ,p_msg_index => 1
654: ,p_data => x_msg_data
655: ,p_msg_index_out => l_msg_index_out
656: );

Line 670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

666: -- Set the excetption Message and the stack
667: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM'
668: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
669:
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
671: RAISE;
672: end UPDATE_CONTROL_ITEM;
673:
674:

Line 678: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

674:
675:
676: procedure DELETE_CONTROL_ITEM (
677: p_api_version IN NUMBER := 1.0
678: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
679: ,p_commit IN VARCHAR2 := FND_API.g_false
680: ,p_validate_only IN VARCHAR2 := FND_API.g_true
681: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
682:

Line 679: ,p_commit IN VARCHAR2 := FND_API.g_false

675:
676: procedure DELETE_CONTROL_ITEM (
677: p_api_version IN NUMBER := 1.0
678: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
679: ,p_commit IN VARCHAR2 := FND_API.g_false
680: ,p_validate_only IN VARCHAR2 := FND_API.g_true
681: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
682:
683: ,p_ci_id IN NUMBER

Line 680: ,p_validate_only IN VARCHAR2 := FND_API.g_true

676: procedure DELETE_CONTROL_ITEM (
677: p_api_version IN NUMBER := 1.0
678: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
679: ,p_commit IN VARCHAR2 := FND_API.g_false
680: ,p_validate_only IN VARCHAR2 := FND_API.g_true
681: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
682:
683: ,p_ci_id IN NUMBER
684: ,p_record_version_number IN NUMBER

Line 681: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

677: p_api_version IN NUMBER := 1.0
678: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
679: ,p_commit IN VARCHAR2 := FND_API.g_false
680: ,p_validate_only IN VARCHAR2 := FND_API.g_true
681: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
682:
683: ,p_ci_id IN NUMBER
684: ,p_record_version_number IN NUMBER
685: ,x_return_status OUT NOCOPY VARCHAR2

Line 705: x_return_status := FND_API.G_RET_STS_SUCCESS;

701: -- Initialize the Error Stack
702: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.DELETE_CONTROL_ITEM');
703:
704: -- Initialize the return status to success
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706:
707: --Clear the global PL/SQL message table
708: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
709: FND_MSG_PUB.initialize;

Line 708: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

704: -- Initialize the return status to success
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706:
707: --Clear the global PL/SQL message table
708: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711: /*
712: open valid_ci;

Line 719: x_return_status := FND_API.G_RET_STS_ERROR;

715: if (valid_ci%notfound) then
716: --- invalid ci_id error
717: PA_UTILS.Add_Message( p_app_short_name => 'PA'
718: ,p_msg_name => 'PA_CI_INVALID_ITEM');
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: else
721: if (l_status_code <> 'CI_DRAFT') then
722: --- invalid status error
723: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

721: if (l_status_code <> 'CI_DRAFT') then
722: --- invalid status error
723: PA_UTILS.Add_Message( p_app_short_name => 'PA'
724: ,p_msg_name => 'PA_CI_ONLY_DRAFT_DEL');
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: end if;
727: end if;
728: close valid_ci;
729:

Line 753: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

749: -- IF the number of messaages is 1 then fetch the message code from the stack
750: -- and return its text
751: x_msg_count := FND_MSG_PUB.Count_Msg;
752: IF x_msg_count = 1 THEN
753: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
754: ,p_msg_index => 1
755: ,p_data => x_msg_data
756: ,p_msg_index_out => l_msg_index_out
757: );

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

768: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.DELETE_CONTROL_ITEM'
769: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
770:
771:
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
773: RAISE;
774: end DELETE_CONTROL_ITEM;
775:
776: procedure COPY_CONTROL_ITEM (

Line 778: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

774: end DELETE_CONTROL_ITEM;
775:
776: procedure COPY_CONTROL_ITEM (
777: p_api_version IN NUMBER := 1.0
778: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
779: ,p_commit IN VARCHAR2 := FND_API.g_false
780: ,p_validate_only IN VARCHAR2 := FND_API.g_true
781: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
782:

Line 779: ,p_commit IN VARCHAR2 := FND_API.g_false

775:
776: procedure COPY_CONTROL_ITEM (
777: p_api_version IN NUMBER := 1.0
778: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
779: ,p_commit IN VARCHAR2 := FND_API.g_false
780: ,p_validate_only IN VARCHAR2 := FND_API.g_true
781: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
782:
783: ,p_project_id IN NUMBER

Line 780: ,p_validate_only IN VARCHAR2 := FND_API.g_true

776: procedure COPY_CONTROL_ITEM (
777: p_api_version IN NUMBER := 1.0
778: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
779: ,p_commit IN VARCHAR2 := FND_API.g_false
780: ,p_validate_only IN VARCHAR2 := FND_API.g_true
781: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
782:
783: ,p_project_id IN NUMBER
784: ,p_ci_id_from IN NUMBER -- copy from this

Line 781: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

777: p_api_version IN NUMBER := 1.0
778: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
779: ,p_commit IN VARCHAR2 := FND_API.g_false
780: ,p_validate_only IN VARCHAR2 := FND_API.g_true
781: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
782:
783: ,p_project_id IN NUMBER
784: ,p_ci_id_from IN NUMBER -- copy from this
785: ,p_ci_type_id IN NUMBER -- copy to this

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802: -- Initialize the Error Stack
803: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.COPY_CONTROL_ITEM');
804:
805: -- Initialize the return status to success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: --Clear the global PL/SQL message table
809: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;

Line 809: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

805: -- Initialize the return status to success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: --Clear the global PL/SQL message table
809: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812:
813: pa_control_items_pvt.COPY_CONTROL_ITEM (

Line 834: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

830: -- IF the number of messages is 1 then fetch the message code from the stack
831: -- and return its text
832: x_msg_count := FND_MSG_PUB.Count_Msg;
833: IF x_msg_count = 1 THEN
834: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
835: ,p_msg_index => 1
836: ,p_data => x_msg_data
837: ,p_msg_index_out => l_msg_index_out
838: );

Line 857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

853: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.COPY_CONTROL_ITEM'
854: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
855:
856:
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
858: RAISE;
859: end COPY_CONTROL_ITEM;
860:
861: procedure INCLUDE_CONTROL_ITEM(

Line 863: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

859: end COPY_CONTROL_ITEM;
860:
861: procedure INCLUDE_CONTROL_ITEM(
862: p_api_version IN NUMBER := 1.0
863: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
864: ,p_commit IN VARCHAR2 := FND_API.g_false
865: ,p_validate_only IN VARCHAR2 := FND_API.g_true
866: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
867:

Line 864: ,p_commit IN VARCHAR2 := FND_API.g_false

860:
861: procedure INCLUDE_CONTROL_ITEM(
862: p_api_version IN NUMBER := 1.0
863: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
864: ,p_commit IN VARCHAR2 := FND_API.g_false
865: ,p_validate_only IN VARCHAR2 := FND_API.g_true
866: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
867:
868: ,p_from_ci_id IN NUMBER

Line 865: ,p_validate_only IN VARCHAR2 := FND_API.g_true

861: procedure INCLUDE_CONTROL_ITEM(
862: p_api_version IN NUMBER := 1.0
863: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
864: ,p_commit IN VARCHAR2 := FND_API.g_false
865: ,p_validate_only IN VARCHAR2 := FND_API.g_true
866: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
867:
868: ,p_from_ci_id IN NUMBER
869: ,p_to_ci_id IN NUMBER

Line 866: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

862: p_api_version IN NUMBER := 1.0
863: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
864: ,p_commit IN VARCHAR2 := FND_API.g_false
865: ,p_validate_only IN VARCHAR2 := FND_API.g_true
866: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
867:
868: ,p_from_ci_id IN NUMBER
869: ,p_to_ci_id IN NUMBER
870: ,p_record_version_number_to IN NUMBER

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: -- Initialize the Error Stack
883: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.INCLUDE_CONTROL_ITEM');
884:
885: -- Initialize the return status to success
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: --Clear the global PL/SQL message table
889: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
890: FND_MSG_PUB.initialize;

Line 889: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

885: -- Initialize the return status to success
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: --Clear the global PL/SQL message table
889: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
890: FND_MSG_PUB.initialize;
891: END IF;
892:
893: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

Line 893: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

889: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
890: FND_MSG_PUB.initialize;
891: END IF;
892:
893: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
894: PA_CONTROL_ITEMS_PVT.INCLUDE_CONTROL_ITEM(
895: p_api_version => p_api_version
896: ,p_init_msg_list => p_init_msg_list
897: ,p_commit => p_commit

Line 913: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

909: -- IF the number of messaages is 1 then fetch the message code from the stack
910: -- and return its text
911: x_msg_count := FND_MSG_PUB.Count_Msg;
912: IF x_msg_count = 1 THEN
913: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
914: ,p_msg_index => 1
915: ,p_data => x_msg_data
916: ,p_msg_index_out => l_msg_index_out
917: );

Line 936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

932: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.INCLUDE_CONTROL_ITEM'
933: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
934:
935:
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: RAISE;
938: end INCLUDE_CONTROL_ITEM;
939:
940:

Line 952: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true

948:
949: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
950: procedure LOCK_CONTROL_ITEM (
951: p_api_version IN NUMBER := 1.0
952: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
953: ,p_commit IN VARCHAR2 := FND_API.g_false
954: ,p_validate_only IN VARCHAR2 := FND_API.g_true
955: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
956: ,p_ci_id IN NUMBER

Line 953: ,p_commit IN VARCHAR2 := FND_API.g_false

949: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
950: procedure LOCK_CONTROL_ITEM (
951: p_api_version IN NUMBER := 1.0
952: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
953: ,p_commit IN VARCHAR2 := FND_API.g_false
954: ,p_validate_only IN VARCHAR2 := FND_API.g_true
955: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
956: ,p_ci_id IN NUMBER
957: ,x_return_status OUT NOCOPY VARCHAR2

Line 954: ,p_validate_only IN VARCHAR2 := FND_API.g_true

950: procedure LOCK_CONTROL_ITEM (
951: p_api_version IN NUMBER := 1.0
952: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
953: ,p_commit IN VARCHAR2 := FND_API.g_false
954: ,p_validate_only IN VARCHAR2 := FND_API.g_true
955: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
956: ,p_ci_id IN NUMBER
957: ,x_return_status OUT NOCOPY VARCHAR2
958: ,x_msg_count OUT NOCOPY NUMBER

Line 955: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

951: p_api_version IN NUMBER := 1.0
952: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
953: ,p_commit IN VARCHAR2 := FND_API.g_false
954: ,p_validate_only IN VARCHAR2 := FND_API.g_true
955: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
956: ,p_ci_id IN NUMBER
957: ,x_return_status OUT NOCOPY VARCHAR2
958: ,x_msg_count OUT NOCOPY NUMBER
959: ,x_msg_data OUT NOCOPY VARCHAR2

Line 970: x_return_status := FND_API.G_RET_STS_SUCCESS;

966: -- Initialize the Error Stack
967: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.LOCK_CONTROL_ITEM');
968:
969: -- Initialize the return status to success
970: x_return_status := FND_API.G_RET_STS_SUCCESS;
971:
972: --Clear the global PL/SQL message table
973: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
974: FND_MSG_PUB.initialize;

Line 973: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

969: -- Initialize the return status to success
970: x_return_status := FND_API.G_RET_STS_SUCCESS;
971:
972: --Clear the global PL/SQL message table
973: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
974: FND_MSG_PUB.initialize;
975: END IF;
976:
977: -- Issue API savepoint if the transaction is to be committed

Line 978: IF p_commit = FND_API.G_TRUE THEN

974: FND_MSG_PUB.initialize;
975: END IF;
976:
977: -- Issue API savepoint if the transaction is to be committed
978: IF p_commit = FND_API.G_TRUE THEN
979: SAVEPOINT lock_control_item;
980: END IF;
981:
982:

Line 999: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

995: -- IF the number of messaages is 1 then fetch the message code from the stack
996: -- and return its text
997: x_msg_count := FND_MSG_PUB.Count_Msg;
998: IF x_msg_count = 1 THEN
999: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1000: ,p_msg_index => 1
1001: ,p_data => x_msg_data
1002: ,p_msg_index_out => l_msg_index_out
1003: );

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1015: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.LOCK_CONTROL_ITEM'
1016: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1017:
1018:
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: RAISE;
1021: end LOCK_CONTROL_ITEM;
1022: -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
1023: