DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_UTILS dependencies on PA_UTILS

Line 707: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

703: ELSE
704: l_status_change_allowed := 'N' ;
705: -- 4229934 Added code to populate error message if dlvr status change to cancel is
706: -- not allowed
707: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
708: p_msg_name => 'PA_DLV_STATUS_CHG_NOT_ALLOWED');
709: -- 4229934 end
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: END IF ;

Line 732: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

728: IF PA_DELIVERABLE_UTILS.GET_DLV_TYPE_CLASS_CODE(p_dlv_type_id) = 'DOCUMENT' THEN
729:
730: IF PA_DELIVERABLE_UTILS.IS_DLV_DOC_DEFINED(p_dlvr_item_id,p_dlvr_version_id) = 'N' THEN
731: l_status_change_allowed := 'N' ;
732: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
733: p_msg_name => 'PA_DLV_DOC_NOT_DEFINED');
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: ELSE
736: l_status_change_allowed := 'Y' ;

Line 743: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

739: ELSIF PA_DELIVERABLE_UTILS.GET_DLV_TYPE_CLASS_CODE(p_dlv_type_id) = 'ITEM' THEN
740:
741: IF OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_dlvr_version_id) = 'N' THEN
742: l_status_change_allowed := 'N' ;
743: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
744: p_msg_name => 'PA_DLV_ITEM_NOT_DEFINED');
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: ELSE
747: l_status_change_allowed := 'Y' ;

Line 759: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

755: IF c_complete_dlv_check%NOTFOUND THEN
756: l_status_change_allowed := 'Y' ;
757: ELSE
758: l_status_change_allowed := 'N' ;
759: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
760: p_msg_name => 'PA_DLV_WSH_REQ_NOT_INITIATED');
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: END IF ;
763: CLOSE c_complete_dlv_check ;

Line 773: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

769: IF c_complete_dlv_bill_check%NOTFOUND THEN
770: l_status_change_allowed := 'Y' ;
771: ELSE
772: l_status_change_allowed := 'N' ;
773: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
774: p_msg_name => 'PA_DLV_BILL_EVT_NOT_INITIATED');
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF ;
777: CLOSE c_complete_dlv_bill_check ;

Line 2774: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2770: FETCH cur_tsk_assoc INTO l_dummy;
2771: IF cur_tsk_assoc%FOUND THEN
2772: x_return_flag := 'N';
2773: x_return_status := FND_API.G_RET_STS_ERROR;
2774: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2775: p_msg_name => 'PA_DLV_TASK_ASSN_EXISTS' );
2776: CLOSE cur_tsk_assoc;
2777: return;
2778: ELSE

Line 2788: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2784: FETCH cur_dlvr_progress INTO l_dummy;
2785: IF cur_dlvr_progress%FOUND THEN
2786: x_return_flag := 'N';
2787: x_return_status := FND_API.G_RET_STS_ERROR;
2788: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2789: p_msg_name => 'PA_DLV_HAS_PROGRESS' );
2790: CLOSE cur_dlvr_progress;
2791: return;
2792: ELSE

Line 2801: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2797: FETCH cur_ship_or_proc INTO l_dummy;
2798: IF cur_ship_or_proc%FOUND THEN
2799: x_return_flag := 'N';
2800: x_return_status := FND_API.G_RET_STS_ERROR;
2801: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2802: p_msg_name => 'PA_DLV_ACTION_TXN_EXISTS' );
2803: CLOSE cur_ship_or_proc;
2804: return;
2805: ELSE

Line 2814: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2810: FETCH cur_billing_fn INTO l_dummy;
2811: IF cur_billing_fn%FOUND THEN
2812: x_return_flag := 'N';
2813: x_return_status := FND_API.G_RET_STS_ERROR;
2814: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2815: p_msg_name => 'PA_DLV_ACTION_TXN_EXISTS' );
2816: CLOSE cur_billing_fn;
2817: return;
2818: ELSE

Line 2824: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2820: END IF;
2821:
2822: -- x_return_flag := 'W';
2823: -- x_return_status := FND_API.G_RET_STS_ERROR;
2824: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2825: -- p_msg_name => 'PA_DLV_DEFINED' );
2826: return;
2827: END IF;
2828:

Line 2950: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2946: OPEN cur_check_cancel_possible;
2947: FETCH cur_check_cancel_possible INTO l_dummy;
2948: IF cur_check_cancel_possible%FOUND THEN
2949: x_return_status := FND_API.G_RET_STS_ERROR;
2950: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2951: p_msg_name => 'PA_TSK_DEL_TXN_EXISTS' );
2952: CLOSE cur_check_cancel_possible;
2953: return;
2954: ELSE

Line 3065: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

3061: OPEN cur_check_transaction_init;
3062: FETCH cur_check_transaction_init INTO l_dummy;
3063: IF cur_check_transaction_init%FOUND THEN
3064: x_return_status := FND_API.G_RET_STS_ERROR;
3065: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
3066: p_msg_name => 'PA_PS_WP_MAPPING_TXN_EXISTS' );
3067: END IF;
3068: CLOSE cur_check_transaction_init;
3069:

Line 3167: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

3163: OPEN cur_assoc_dlvr_has_prog;
3164: FETCH cur_assoc_dlvr_has_prog INTO l_dummy;
3165: IF cur_assoc_dlvr_has_prog%FOUND THEN
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
3168: p_msg_name => 'PA_TSK_PROGRESS_LOSE_WARN' );
3169: CLOSE cur_assoc_dlvr_has_prog;
3170: return;
3171: ELSIF */

Line 3183: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

3179: CLOSE cur_dlvr_assoc_exists;
3180:
3181: IF nvl(l_dummy,0)=1 THEN
3182: x_return_status := FND_API.G_RET_STS_ERROR;
3183: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
3184: p_msg_name => 'PA_TSK_PROGRESS_MTH_ERR' );
3185: /* CLOSE cur_assoc_dlvr_has_prog; Commented as Cursor not used*/
3186: END IF;
3187:

Line 3290: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

3286: OPEN cur_proj_txn_exists;
3287: FETCH cur_proj_txn_exists INTO l_return_flag;
3288: IF cur_proj_txn_exists%FOUND THEN
3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
3291: p_msg_name => 'PA_STR_SETUP_CHANGE_ERR' );
3292: ELSE
3293: l_return_flag := 'N';
3294: END IF;

Line 3787: l_person_id := PA_UTILS.GetEmpIdFromUser(p_user_id);

3783: l_person_id NUMBER := NULL;
3784:
3785: BEGIN
3786:
3787: l_person_id := PA_UTILS.GetEmpIdFromUser(p_user_id);
3788:
3789: OPEN c_dlvr_owner;
3790: FETCH c_dlvr_owner into l_dlvr_owner_id ;
3791: CLOSE c_dlvr_owner;

Line 3894: PA_UTILS.ADD_MESSAGE

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
3895: (p_app_short_name => 'PA',
3896: p_msg_name => 'PA_DLVR_VALID_ERR',
3897: p_token1 => 'PROJECT',
3898: p_value1 => l_project_number,

Line 3921: PA_UTILS.ADD_MESSAGE

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
3922: (p_app_short_name => 'PA',
3923: p_msg_name => 'PA_DLVR_VALID_ERR',
3924: p_token1 => 'PROJECT',
3925: p_value1 => l_project_number,

Line 3948: PA_UTILS.ADD_MESSAGE

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
3949: (p_app_short_name => 'PA',
3950: p_msg_name => 'PA_DLVR_VALID_ERR',
3951: p_token1 => 'PROJECT',
3952: p_value1 => l_project_number,

Line 3968: PA_UTILS.ADD_MESSAGE

3964: ELSE -- Deliverable type is not null, checking for valid value
3965: IF (Pa_Deliverable_Utils.IS_DLV_TYPE_ID_VALID(p_dlvr_type_id) = 'N') THEN
3966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3967: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_TYPE_INVALID') ;
3968: PA_UTILS.ADD_MESSAGE
3969: (p_app_short_name => 'PA',
3970: p_msg_name => 'PA_DLVR_VALID_ERR',
3971: p_token1 => 'PROJECT',
3972: p_value1 => l_project_number,

Line 4016: PA_UTILS.ADD_MESSAGE

4012: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4015: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_OWNER_INVALID') ;
4016: PA_UTILS.ADD_MESSAGE
4017: (p_app_short_name => 'PA',
4018: p_msg_name => 'PA_DLVR_VALID_ERR',
4019: p_token1 => 'PROJECT',
4020: p_value1 => l_project_number,

Line 4043: PA_UTILS.ADD_MESSAGE

4039:
4040: IF (px_status_code IS NOT NULL and l_status_code_valid = 'N') THEN
4041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4042: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_STATUS_INVALID') ;
4043: PA_UTILS.ADD_MESSAGE
4044: (p_app_short_name => 'PA',
4045: p_msg_name => 'PA_DLVR_VALID_ERR',
4046: p_token1 => 'PROJECT',
4047: p_value1 => l_project_number,

Line 4085: PA_UTILS.ADD_MESSAGE

4081: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4083: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4084: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_CARRYING_ORG_INVALID') ;
4085: PA_UTILS.ADD_MESSAGE
4086: (p_app_short_name => 'PA',
4087: p_msg_name => 'PA_DLVR_VALID_ERR',
4088: p_token1 => 'PROJECT',
4089: p_value1 => l_project_number,

Line 4354: PA_UTILS.ADD_MESSAGE

4350: IF l_dlvr_ref_csr%FOUND
4351: THEN
4352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4353: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DUP_DLVR_REFERENCE') ;
4354: PA_UTILS.ADD_MESSAGE
4355: (p_app_short_name => 'PA',
4356: p_msg_name => 'PA_DLVR_VALID_ERR',
4357: p_token1 => 'PROJECT',
4358: p_value1 => l_project_number,

Line 4379: PA_UTILS.ADD_MESSAGE

4375: ELSE
4376:
4377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4378: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_REF_AND_ID_MISSING') ;
4379: PA_UTILS.ADD_MESSAGE
4380: (p_app_short_name => 'PA',
4381: p_msg_name => 'PA_DLVR_VALID_ERR',
4382: p_token1 => 'PROJECT',
4383: p_value1 => l_project_number,

Line 4485: PA_UTILS.ADD_MESSAGE

4481: IF l_dlvr_id_csr%NOTFOUND
4482: THEN
4483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4484: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_ID_INVALID') ;
4485: PA_UTILS.ADD_MESSAGE
4486: (p_app_short_name => 'PA',
4487: p_msg_name => 'PA_DLVR_VALID_ERR',
4488: p_token1 => 'PROJECT',
4489: p_value1 => l_project_number,

Line 4517: PA_UTILS.ADD_MESSAGE

4513: IF l_dlvr_ref_csr%NOTFOUND
4514: THEN
4515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4516: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_REF_INVALID') ;
4517: PA_UTILS.ADD_MESSAGE
4518: (p_app_short_name => 'PA',
4519: p_msg_name => 'PA_DLVR_VALID_ERR',
4520: p_token1 => 'PROJECT',
4521: p_value1 => l_project_number,

Line 4539: PA_UTILS.ADD_MESSAGE

4535: p_out_deliverable_id := l_deliverable_id;
4536: ELSE
4537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4538: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_REF_AND_ID_MISSING') ;
4539: PA_UTILS.ADD_MESSAGE
4540: (p_app_short_name => 'PA',
4541: p_msg_name => 'PA_DLVR_VALID_ERR',
4542: p_token1 => 'PROJECT',
4543: p_value1 => l_project_number,

Line 4675: PA_UTILS.ADD_MESSAGE

4671:
4672: IF l_action_ref_csr%FOUND THEN
4673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4674: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_INVALID') ;
4675: PA_UTILS.ADD_MESSAGE
4676: (p_app_short_name => 'PA',
4677: p_msg_name => 'PA_ACTION_VALID_ERR',
4678: p_token1 => 'PROJECT',
4679: p_value1 => l_project_number,

Line 4699: PA_UTILS.ADD_MESSAGE

4695:
4696: ELSE -- p_action_reference IS NULL
4697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4698: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_AND_ID_MISSING') ;
4699: PA_UTILS.ADD_MESSAGE
4700: (p_app_short_name => 'PA',
4701: p_msg_name => 'PA_ACTION_VALID_ERR',
4702: p_token1 => 'PROJECT',
4703: p_value1 => l_project_number,

Line 4849: PA_UTILS.ADD_MESSAGE

4845: IF l_action_id_csr%NOTFOUND
4846: THEN
4847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4848: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_ID_INVALID') ;
4849: PA_UTILS.ADD_MESSAGE
4850: (p_app_short_name => 'PA',
4851: p_msg_name => 'PA_ACTION_VALID_ERR',
4852: p_token1 => 'PROJECT',
4853: p_value1 => l_project_number,

Line 4882: PA_UTILS.ADD_MESSAGE

4878: IF l_action_ref_csr%NOTFOUND
4879: THEN
4880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_INVALID') ;
4882: PA_UTILS.ADD_MESSAGE
4883: (p_app_short_name => 'PA',
4884: p_msg_name => 'PA_DLVR_VALID_ERR',
4885: p_token1 => 'PROJECT',
4886: p_value1 => l_project_number,

Line 4905: PA_UTILS.ADD_MESSAGE

4901: p_out_action_id := l_action_id;
4902: ELSE
4903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4904: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_AND_ID_MISSING') ;
4905: PA_UTILS.ADD_MESSAGE
4906: (p_app_short_name => 'PA',
4907: p_msg_name => 'PA_DLVR_VALID_ERR',
4908: p_token1 => 'PROJECT',
4909: p_value1 => l_project_number,