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_DELIVERABLE_UTILS dependencies on PA_INTERFACE_UTILS_PUB

Line 3813: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3809:
3810: Procedure Validate_Deliverable
3811: (
3812: p_deliverable_id IN NUMBER
3813: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
3817: , p_dlvr_owner_name IN VARCHAR2 := NULL

Line 3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3810: Procedure Validate_Deliverable
3811: (
3812: p_deliverable_id IN NUMBER
3813: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
3817: , p_dlvr_owner_name IN VARCHAR2 := NULL
3818: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3811: (
3812: p_deliverable_id IN NUMBER
3813: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
3817: , p_dlvr_owner_name IN VARCHAR2 := NULL
3818: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3819: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 3818: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
3817: , p_dlvr_owner_name IN VARCHAR2 := NULL
3818: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3819: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
3820: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
3821: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
3822: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3822: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3818: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3819: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
3820: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
3821: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
3822: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3823: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
3824: , p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
3825: , p_calling_mode IN VARCHAR2 := 'INSERT'
3826: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3859: IF px_dlvr_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

3855: IF l_debug_mode = 'Y' THEN
3856: PA_DEBUG.set_curr_function( p_function => 'VALIDATE_DELIVERABLE', p_debug_mode => l_debug_mode );
3857: END IF;
3858:
3859: IF px_dlvr_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3860: l_dlvr_owner_id := NULL;
3861: ELSE
3862: l_dlvr_owner_id := px_dlvr_owner_id;
3863: END IF;

Line 3865: IF p_carrying_out_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

3861: ELSE
3862: l_dlvr_owner_id := px_dlvr_owner_id;
3863: END IF;
3864:
3865: IF p_carrying_out_org_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3866: l_carrying_out_org_id := NULL;
3867: ELSE
3868: l_carrying_out_org_id := p_carrying_out_org_id;
3869: END IF;

Line 3872: IF (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

3868: l_carrying_out_org_id := p_carrying_out_org_id;
3869: END IF;
3870:
3871: -- Fetching Task Name , Project Name to use as token in Error Messages.
3872: IF (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3873: SELECT name INTO l_task_number
3874: FROM Pa_Proj_Elements
3875: WHERE proj_element_id = p_task_id;
3876: ELSE

Line 3890: OR p_dlvr_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

3886: END IF;
3887:
3888: -- Validating deliverable_name - not null
3889: IF p_dlvr_name IS NULL
3890: OR p_dlvr_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3891:
3892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3893: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_NAME_MISSING') ;
3894: PA_UTILS.ADD_MESSAGE

Line 3917: OR p_dlvr_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

3913: END IF;
3914:
3915: -- Validating deliverable_short_name - not null
3916: IF p_dlvr_number IS NULL
3917: OR p_dlvr_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3918:
3919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3920: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_NUMBER_MISSING') ;
3921: PA_UTILS.ADD_MESSAGE

Line 3944: OR p_dlvr_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

3940: END IF;
3941:
3942: -- Validating Deliverable Type Id - not null, valid value
3943: IF p_dlvr_type_id IS NULL
3944: OR p_dlvr_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3945:
3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3947: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_TYPE_MISSING') ;
3948: PA_UTILS.ADD_MESSAGE

Line 4316: (p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4312: --History:
4313: -- 19-AUG-1996 Puneet Created
4314: --
4315: PROCEDURE is_dlvr_reference_unique
4316: (p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4317: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4318: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4319: ,x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
4320:

Line 4317: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4313: -- 19-AUG-1996 Puneet Created
4314: --
4315: PROCEDURE is_dlvr_reference_unique
4316: (p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4317: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4318: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4319: ,x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
4320:
4321: IS

Line 4344: IF p_deliverable_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4340: BEGIN
4341:
4342: x_return_status := FND_API.G_RET_STS_SUCCESS;
4343:
4344: IF p_deliverable_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4345: AND p_deliverable_reference IS NOT NULL
4346: THEN
4347: OPEN l_dlvr_ref_csr;
4348: FETCH l_dlvr_ref_csr INTO l_deliverable_id, l_project_number;

Line 4395: END IF; -- If p_deliverable_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4391: END IF;
4392: x_unique_flag := Null;
4393: RAISE FND_API.G_EXC_ERROR;
4394:
4395: END IF; -- If p_deliverable_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4396:
4397:
4398: EXCEPTION
4399: WHEN FND_API.G_EXC_ERROR THEN

Line 4430: (p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4426: --History:
4427: -- 19-AUG-1996 Puneet Created
4428: --
4429: PROCEDURE Convert_pm_dlvrref_to_id
4430: (p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4431: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4432: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4433: ,p_out_deliverable_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4434: ,p_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 4431: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4427: -- 19-AUG-1996 Puneet Created
4428: --
4429: PROCEDURE Convert_pm_dlvrref_to_id
4430: (p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4431: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4432: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4433: ,p_out_deliverable_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4434: ,p_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
4435:

Line 4432: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4428: --
4429: PROCEDURE Convert_pm_dlvrref_to_id
4430: (p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4431: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4432: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4433: ,p_out_deliverable_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4434: ,p_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
4435:
4436: IS

Line 4473: IF p_deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4469: OPEN proj_num;
4470: FETCH proj_num INTO l_project_number;
4471: CLOSE proj_num;
4472:
4473: IF p_deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4474: AND p_deliverable_id IS NOT NULL
4475: THEN
4476:
4477: --check validity of this ID

Line 4505: ELSIF p_deliverable_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4501:
4502: CLOSE l_dlvr_id_csr;
4503: p_out_deliverable_id := p_deliverable_id;
4504:
4505: ELSIF p_deliverable_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4506: AND p_deliverable_reference IS NOT NULL
4507: THEN
4508:
4509: --check validity of this reference

Line 4552: END IF; -- If p_deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4548: );
4549: END IF;
4550: RAISE FND_API.G_EXC_ERROR;
4551:
4552: END IF; -- If p_deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4553:
4554: EXCEPTION
4555: WHEN FND_API.G_EXC_ERROR THEN
4556: p_return_status := FND_API.G_RET_STS_ERROR;

Line 4622: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4618: -- Assumptions : None
4619:
4620: PROCEDURE is_action_reference_unique
4621: (
4622: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4623: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4624: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4625: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4626: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4623: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4619:
4620: PROCEDURE is_action_reference_unique
4621: (
4622: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4623: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4624: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4625: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4626: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4627: )

Line 4624: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4620: PROCEDURE is_action_reference_unique
4621: (
4622: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4623: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4624: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4625: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4626: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4627: )
4628: IS

Line 4666: IF p_action_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4662: OPEN proj_num;
4663: FETCH proj_num INTO l_project_number, l_deliverable_name;
4664: CLOSE proj_num;
4665:
4666: IF p_action_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4667: AND p_action_reference IS NOT NULL
4668: THEN
4669: OPEN l_action_ref_csr;
4670: FETCH l_action_ref_csr INTO l_dummy; -- 3749462 changed from l_action_id to l_dummy

Line 4779: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4775: -- an action ID.
4776:
4777: PROCEDURE Convert_pm_actionref_to_id
4778: (
4779: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4780: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4781: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4782: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4783: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4780: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4776:
4777: PROCEDURE Convert_pm_actionref_to_id
4778: (
4779: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4780: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4781: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4782: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4783: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4784: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4781: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4777: PROCEDURE Convert_pm_actionref_to_id
4778: (
4779: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4780: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4781: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4782: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4783: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4784: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4785: )

Line 4782: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4778: (
4779: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4780: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4781: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4782: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4783: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4784: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4785: )
4786: IS

Line 4837: IF p_action_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4833: OPEN proj_num;
4834: FETCH proj_num INTO l_project_number, l_deliverable_name;
4835: CLOSE proj_num;
4836:
4837: IF p_action_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4838: AND p_action_id IS NOT NULL
4839: THEN
4840:
4841: --check validity of this ID

Line 4870: ELSIF p_action_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4866:
4867: CLOSE l_action_id_csr;
4868: p_out_action_id := p_action_id;
4869:
4870: ELSIF p_action_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4871: AND p_action_reference IS NOT NULL
4872: THEN
4873:
4874: --check validity of this reference

Line 4920: END IF; -- If p_action_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4916: );
4917: END IF;
4918: RAISE FND_API.G_EXC_ERROR;
4919:
4920: END IF; -- If p_action_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4921:
4922: EXCEPTION
4923: WHEN FND_API.G_EXC_ERROR THEN
4924: p_return_status := FND_API.G_RET_STS_ERROR;

Line 4958: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4954: -- N User Value User Value Null
4955:
4956: PROCEDURE Progress_Enabled_Validation
4957: (
4958: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4959: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4960: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4961: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
4962: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895

Line 4959: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4955:
4956: PROCEDURE Progress_Enabled_Validation
4957: (
4958: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4959: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4960: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4961: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
4962: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
4963: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895

Line 4960: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4956: PROCEDURE Progress_Enabled_Validation
4957: (
4958: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4959: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4960: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4961: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
4962: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
4963: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
4964: , p_calling_Mode IN VARCHAR2 := 'INSERT'

Line 5178: PA_INTERFACE_UTILS_PUB.get_messages

5174: x_return_status := FND_API.G_RET_STS_ERROR;
5175: x_msg_count := FND_MSG_PUB.count_msg;
5176:
5177: IF x_msg_count = 1 THEN
5178: PA_INTERFACE_UTILS_PUB.get_messages
5179: (p_encoded => FND_API.G_FALSE,
5180: p_msg_index => 1,
5181: p_msg_count => x_msg_count,
5182: p_msg_data => x_msg_data,

Line 5205: PA_INTERFACE_UTILS_PUB.get_messages

5201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5202: x_msg_count := FND_MSG_PUB.count_msg;
5203:
5204: IF x_msg_count = 1 THEN
5205: PA_INTERFACE_UTILS_PUB.get_messages
5206: (p_encoded => FND_API.G_FALSE,
5207: p_msg_index => 1,
5208: p_msg_count => x_msg_count,
5209: p_msg_data => x_msg_data,