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

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

65: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
66:
67: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
68: (p_api_version IN NUMBER :=1.0
69: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
70: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
71: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
72: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
73: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

66:
67: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
68: (p_api_version IN NUMBER :=1.0
69: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
70: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
71: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
72: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
73: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
74: ,p_debug_mode IN VARCHAR2 :='N'

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

67: PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
68: (p_api_version IN NUMBER :=1.0
69: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
70: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
71: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
72: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
73: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
74: ,p_debug_mode IN VARCHAR2 :='N'
75: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 72: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

68: (p_api_version IN NUMBER :=1.0
69: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
70: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
71: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
72: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
73: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
74: ,p_debug_mode IN VARCHAR2 :='N'
75: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 126: x_return_status := FND_API.G_RET_STS_SUCCESS;

122: i NUMBER;
123: l_pm_source_reference_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); -- added for 3574730
124: BEGIN
125: x_msg_count := 0;
126: x_return_status := FND_API.G_RET_STS_SUCCESS;
127:
128: IF p_debug_mode = 'Y' THEN
129: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_ACTIONS_IN_BULK'
130: ,p_debug_mode => p_debug_mode );

Line 135: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

131: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
132: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
133: END IF;
134:
135: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
136: FND_MSG_PUB.initialize;
137: END IF;
138:
139: IF p_debug_mode = 'Y' THEN

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

413: END IF;
414:
415: EXCEPTION
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: x_msg_count := 1;
419: x_msg_data := SQLERRM;
420: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
421: ,p_procedure_name => 'CREATE_DLV_ACTIONS_IN_BULK');

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

480: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
481:
482: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
483: (p_api_version IN NUMBER :=1.0
484: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
485: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
486: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
487: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
488: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

481:
482: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
483: (p_api_version IN NUMBER :=1.0
484: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
485: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
486: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
487: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
488: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
489: ,p_debug_mode IN VARCHAR2 :='N'

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

482: PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
483: (p_api_version IN NUMBER :=1.0
484: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
485: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
486: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
487: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
488: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
489: ,p_debug_mode IN VARCHAR2 :='N'
490: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 487: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

483: (p_api_version IN NUMBER :=1.0
484: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
485: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
486: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
487: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
488: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
489: ,p_debug_mode IN VARCHAR2 :='N'
490: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
491: ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: l_msg_index_out NUMBER;
533: BEGIN
534:
535: x_msg_count := 0;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: IF p_debug_mode = 'Y' THEN
539: PA_DEBUG.set_curr_function( p_function => 'CR_DLV_ACTIONS_IN_BULK'
540: ,p_debug_mode => p_debug_mode );

Line 545: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

541: pa_debug.g_err_stage:= 'Inside UPDATE_DLV_ACTIONS_IN_BULK ';
542: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
543: END IF;
544:
545: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:
549: -- Update attributes related to proj element table.

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629: END IF;
630:
631: EXCEPTION
632: WHEN OTHERS THEN
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: x_msg_count := 1;
635: x_msg_data := SQLERRM;
636: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
637: ,p_procedure_name => 'UPDATE_DLV_ACTIONS_IN_BULK');

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

671: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
672:
673: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
674: (p_api_version IN NUMBER :=1.0
675: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
676: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
677: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
678: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
679: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

672:
673: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
674: (p_api_version IN NUMBER :=1.0
675: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
676: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
677: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
678: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
679: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
680: ,p_debug_mode IN VARCHAR2 :='N'

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

673: PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
674: (p_api_version IN NUMBER :=1.0
675: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
676: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
677: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
678: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
679: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
680: ,p_debug_mode IN VARCHAR2 :='N'
681: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 678: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

674: (p_api_version IN NUMBER :=1.0
675: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
676: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
677: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
678: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
679: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
680: ,p_debug_mode IN VARCHAR2 :='N'
681: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
682: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE

Line 709: x_return_status := FND_API.G_RET_STS_SUCCESS;

705: -- Bug 3614361
706: l_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
707: BEGIN
708: x_msg_count := 0;
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711: IF p_debug_mode = 'Y' THEN
712: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ACTIONS_IN_BULK'
713: ,p_debug_mode => p_debug_mode );

Line 718: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

714: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTIONS_IN_BULK ';
715: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
716: END IF;
717:
718: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: IF nvl(p_proj_element_id_tbl.LAST,0)=0 THEN

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

827: END IF;
828:
829: EXCEPTION
830: WHEN OTHERS THEN
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: x_msg_count := 1;
833: x_msg_data := SQLERRM;
834: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
835: ,p_procedure_name => 'DELETE_DLV_ACTIONS_IN_BULK');

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

860: -- p_action_ver_id IN VARCHAR2 Y ACtion Ver Id.
861:
862: PROCEDURE DELETE_DLV_ACTION
863: (p_api_version IN NUMBER :=1.0
864: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
865: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
866: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
867: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
868: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

861:
862: PROCEDURE DELETE_DLV_ACTION
863: (p_api_version IN NUMBER :=1.0
864: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
865: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
866: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
867: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
868: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
869: ,p_debug_mode IN VARCHAR2 :='N'

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

862: PROCEDURE DELETE_DLV_ACTION
863: (p_api_version IN NUMBER :=1.0
864: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
865: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
866: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
867: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
868: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
869: ,p_debug_mode IN VARCHAR2 :='N'
870: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 867: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

863: (p_api_version IN NUMBER :=1.0
864: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
865: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
866: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
867: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
868: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
869: ,p_debug_mode IN VARCHAR2 :='N'
870: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

901: AND object_type = 'PA_ACTIONS';
902:
903: BEGIN
904: x_msg_count := 0;
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: IF p_debug_mode = 'Y' THEN
908: PA_DEBUG.set_curr_function( p_function => 'PA_DELETE_DLV_ACTION'
909: ,p_debug_mode => p_debug_mode );

Line 914: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

910: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTION ';
911: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
912: END IF;
913:
914: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: PA_ACTIONS_PVT.IS_DELETE_ACTION_ALLOWED

Line 920: ,p_init_msg_list => FND_API.G_FALSE

916: END IF;
917:
918: PA_ACTIONS_PVT.IS_DELETE_ACTION_ALLOWED
919: (p_api_version => p_api_version
920: ,p_init_msg_list => FND_API.G_FALSE
921: ,p_commit => p_commit
922: ,p_validate_only => p_validate_only
923: ,p_validation_level => p_validation_level
924: ,p_calling_module => p_calling_module

Line 939: IF (l_action_del_allowed = 'N' OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

935: ,x_msg_count => x_msg_count
936: ,x_msg_data => x_msg_data
937: ) ;
938:
939: IF (l_action_del_allowed = 'N' OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
940: RAISE Invalid_Arg_Exc_Dlv ;
941: END IF ;
942:
943: OPEN c_action_info(p_action_id) ;

Line 966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

962: IF p_debug_mode = 'Y' THEN
963: pa_debug.write(g_module_name,'Returned from PA_BILLING_WRKBNCH_EVENTS.DELETE_DELV_EVENT ['||x_return_status||']',3) ;
964: END IF;
965:
966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
967: RAISE Invalid_Arg_Exc_Dlv ;
968: END IF ;
969:
970: END IF ;

Line 993: -- IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

989: IF p_debug_mode = 'Y' THEN
990: pa_debug.write(g_module_name,'Returned from OKE_DELIVERABLE_UTILS_PUB.DELETE_ACTION ['||x_return_status||']',3) ;
991: END IF;
992:
993: -- IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
994: -- RAISE Invalid_Arg_Exc_Dlv ;
995: -- END IF ;
996:
997: ELSIF (p_calling_module = 'AMG' and l_function_code = g_procurement) THEN

Line 1003: , p_init_msg_list => FND_API.G_FALSE

999: l_dlv_req_action_rec.pa_action_id := p_action_ver_id;
1000:
1001: oke_amg_grp.manage_dlv_action
1002: ( p_api_version => p_api_version
1003: , p_init_msg_list => FND_API.G_FALSE
1004: , p_commit => p_commit
1005: , p_action => 'DELETE'
1006: -- 3732873 earlier l_function_code was passed for p_dlv_action_type
1007: -- and the value will be 'PROCUREMENT', but OKE expects this value to be 'REQ' for procurement

Line 1023: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1019: IF p_debug_mode = 'Y' THEN
1020: pa_debug.write(g_module_name,'Returned from oke_amg_grp.manage_dlv_action['||l_function_code||'] ['||x_return_status||']',3) ;
1021: END IF;
1022:
1023: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1024: RAISE Invalid_Arg_Exc_Dlv ;
1025: END IF ;
1026:
1027: ELSIF (p_calling_module = 'AMG' and l_function_code = g_shipping) THEN

Line 1033: , p_init_msg_list => FND_API.G_FALSE

1029: l_dlv_ship_action_rec.pa_action_id := p_action_ver_id;
1030:
1031: oke_amg_grp.manage_dlv_action
1032: ( p_api_version => p_api_version
1033: , p_init_msg_list => FND_API.G_FALSE
1034: , p_commit => p_commit
1035: , p_action => 'DELETE'
1036: -- 3732873 earlier l_function_code was passed for p_dlv_action_type
1037: -- and the value will be 'SHIPPING', but OKE expects this value to be 'WSH' for shipping

Line 1053: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1049: IF p_debug_mode = 'Y' THEN
1050: pa_debug.write(g_module_name,'Returned from oke_amg_grp.manage_dlv_action['||l_function_code||'] ['||x_return_status||']',3) ;
1051: END IF;
1052:
1053: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1054: RAISE Invalid_Arg_Exc_Dlv ;
1055: END IF ;
1056:
1057: END IF; --p_calling_module = 'AMG'

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR;

1083: END IF;
1084:
1085: EXCEPTION
1086: WHEN Invalid_Arg_Exc_Dlv THEN
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: l_msg_count := FND_MSG_PUB.count_msg;
1089: IF p_debug_mode = 'Y' THEN
1090: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ACTION';
1091: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 1096: (p_encoded => FND_API.G_FALSE,

1092: END IF;
1093:
1094: IF x_msg_count = 1 THEN
1095: PA_INTERFACE_UTILS_PUB.get_messages
1096: (p_encoded => FND_API.G_FALSE,
1097: p_msg_index => 1,
1098: p_msg_count => l_msg_count,
1099: p_msg_data => l_msg_data,
1100: p_data => l_data,

Line 1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1108: pa_debug.reset_curr_function;
1109: END IF ;
1110: RETURN;
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1113: x_msg_count := 1;
1114: x_msg_data := SQLERRM;
1115:
1116: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'

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

1125: END DELETE_DLV_ACTION ;
1126:
1127: PROCEDURE IS_DELETE_ACTION_ALLOWED
1128: (p_api_version IN NUMBER :=1.0
1129: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1130: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1131: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1132: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1133: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

1126:
1127: PROCEDURE IS_DELETE_ACTION_ALLOWED
1128: (p_api_version IN NUMBER :=1.0
1129: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1130: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1131: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1132: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1133: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1134: ,p_debug_mode IN VARCHAR2 :='N'

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

1127: PROCEDURE IS_DELETE_ACTION_ALLOWED
1128: (p_api_version IN NUMBER :=1.0
1129: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1130: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1131: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1132: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1133: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1134: ,p_debug_mode IN VARCHAR2 :='N'
1135: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1132: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

1128: (p_api_version IN NUMBER :=1.0
1129: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1130: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1131: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1132: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1133: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1134: ,p_debug_mode IN VARCHAR2 :='N'
1135: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1136: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

Line 1154: x_return_status := FND_API.G_RET_STS_SUCCESS;

1150: l_proc_initiated VARCHAR2(1) := 'N' ;
1151:
1152: BEGIN
1153: x_msg_count := 0;
1154: x_return_status := FND_API.G_RET_STS_SUCCESS;
1155:
1156: IF p_debug_mode = 'Y' THEN
1157: PA_DEBUG.set_curr_function( p_function => 'IS_DELETE_ACTION_ALLOWED'
1158: ,p_debug_mode => p_debug_mode );

Line 1163: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

1159: pa_debug.g_err_stage:= 'Inside IS_DELETE_ACTION_ALLOWED ';
1160: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1161: END IF;
1162:
1163: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1164: FND_MSG_PUB.initialize;
1165: END IF;
1166:
1167: --Bug 3512346 The Following Check (CHECK_DELV_EVENT_PROCESSED) has been uncommented.Also,passing p_Action_ver_id for the API

Line 1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1236: END IF;
1237:
1238: EXCEPTION
1239: WHEN OTHERS THEN
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241: x_msg_count := 1;
1242: x_msg_data := SQLERRM;
1243:
1244: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'

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

1281: -- x_msg_data OUT VARCHAR2 N Mandatory Out Parameter
1282:
1283: PROCEDURE COPY_ACTIONS
1284: (p_api_version IN NUMBER :=1.0
1285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

1282:
1283: PROCEDURE COPY_ACTIONS
1284: (p_api_version IN NUMBER :=1.0
1285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1290: ,p_debug_mode IN VARCHAR2 :='N'

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

1283: PROCEDURE COPY_ACTIONS
1284: (p_api_version IN NUMBER :=1.0
1285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1290: ,p_debug_mode IN VARCHAR2 :='N'
1291: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

1284: (p_api_version IN NUMBER :=1.0
1285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
1286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
1287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
1288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1290: ,p_debug_mode IN VARCHAR2 :='N'
1291: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1292: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE

Line 1442: x_return_status := FND_API.G_RET_STS_SUCCESS;

1438: AND template_flag = 'Y';
1439: BEGIN
1440:
1441: x_msg_count := 0;
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443:
1444: IF p_debug_mode = 'Y' THEN
1445: PA_DEBUG.set_curr_function( p_function => 'COPY_ACTIONS'
1446: ,p_debug_mode => p_debug_mode );

Line 1451: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

1447: pa_debug.g_err_stage:= 'Inside COPY_ACTIONS ';
1448: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1449: END IF;
1450:
1451: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1452: FND_MSG_PUB.initialize;
1453: END IF;
1454:
1455: OPEN get_project_mode ;

Line 1610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1606: ) ;
1607:
1608: END IF ;
1609:
1610: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1611: RAISE Invalid_Arg_Exc_Dlv ;
1612: END IF ;
1613:
1614: --Start Bug # 3431156

Line 1653: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1649: , P_Target_Action_Date => l_due_date_tbl(i) -- 3612702 added new parameter
1650: , X_Return_Status => x_return_status
1651: , X_Msg_Count => x_msg_count
1652: , X_Msg_Data => x_msg_data );
1653: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1654: RAISE Invalid_Arg_Exc_Dlv ;
1655: END IF ;
1656:
1657: END LOOP ;

Line 1666: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1662: END IF;
1663:
1664: END IF ;
1665:
1666: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1667: RAISE Invalid_Arg_Exc_Dlv ;
1668: END IF ;
1669:
1670: -- 3573134 added else if statement for deliverable type

Line 1757: x_return_status := FND_API.G_RET_STS_ERROR;

1753: END IF;
1754:
1755: EXCEPTION
1756: WHEN Invalid_Arg_Exc_Dlv THEN
1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: l_msg_count := FND_MSG_PUB.count_msg;
1759: IF l_debug_mode = 'Y' THEN
1760: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_ACTIONS';
1761: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 1766: (p_encoded => FND_API.G_TRUE,

1762: END IF;
1763:
1764: IF l_msg_count = 1 THEN
1765: PA_INTERFACE_UTILS_PUB.get_messages
1766: (p_encoded => FND_API.G_TRUE,
1767: p_msg_index => 1,
1768: p_msg_count => l_msg_count,
1769: p_msg_data => l_msg_data,
1770: p_data => l_data,

Line 1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1778: pa_debug.reset_curr_function;
1779: END IF ;
1780: RETURN;
1781: WHEN OTHERS THEN
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1783: x_msg_count := 1;
1784: x_msg_data := SQLERRM;
1785:
1786: IF get_source_actions%ISOPEN THEN