APPS.PA_BUDGET_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 484: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) AND

480:
481:
482: -- Both Budget Type Code and Fin Plan Type Id should not be null
483: IF ((p_budget_type_code IS NULL OR
484: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) AND
485: (px_fin_plan_type_name IS NULL) AND
486: (px_fin_plan_type_id IS NULL) )THEN
487:
488: PA_UTILS.ADD_MESSAGE

Line 504: p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

500:
501: -- Both Budget Type Code and Fin Plan Type Id should not be not null
502:
503: IF ((p_budget_type_code IS NOT NULL AND
504: p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND
505: ((px_fin_plan_type_name IS NOT NULL) OR
506: (px_fin_plan_type_id IS NOT NULL))) THEN
507:
508: PA_UTILS.ADD_MESSAGE

Line 524: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

520:
521: --dbms_output.put_line('After validating budget and finplan ids');
522:
523: --product_code is mandatory
524: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
525: OR p_pm_product_code IS NULL
526: THEN
527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN

Line 529: pa_interface_utils_pub.map_new_amg_msg

525: OR p_pm_product_code IS NULL
526: THEN
527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: pa_interface_utils_pub.map_new_amg_msg
530: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
531: ,p_msg_attribute => 'CHANGE'
532: ,p_resize_flag => 'N'
533: ,p_msg_context => 'GENERAL'

Line 566: pa_interface_utils_pub.map_new_amg_msg

562: IF l_pm_product_code <> 'X'
563: THEN
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
565: THEN
566: pa_interface_utils_pub.map_new_amg_msg
567: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
568: ,p_msg_attribute => 'CHANGE'
569: ,p_resize_flag => 'N'
570: ,p_msg_context => 'GENERAL'

Line 633: pa_interface_utils_pub.map_new_amg_msg

629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631:
632: IF l_function_allowed = 'N' THEN
633: pa_interface_utils_pub.map_new_amg_msg
634: ( p_old_message_code => 'PA_FUNCTION_SECURITY_ENFORCED'
635: ,p_msg_attribute => 'CHANGE'
636: ,p_resize_flag => 'Y'
637: ,p_msg_context => 'GENERAL'

Line 684: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := px_pa_project_id;

680: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
681:
682: END IF;
683:
684: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := px_pa_project_id;
685:
686: -- Now verify whether project security allows the user to update
687: -- the project
688: -- If a user does not have privileges to update the project, then

Line 699: pa_interface_utils_pub.map_new_amg_msg

695:
696: -- The user does not have query privileges on this project
697: -- Hence, cannot create a draft budget.Raise error
698:
699: pa_interface_utils_pub.map_new_amg_msg
700: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
701: ,p_msg_attribute => 'CHANGE'
702: ,p_resize_flag => 'Y'
703: ,p_msg_context => 'GENERAL'

Line 719: pa_interface_utils_pub.map_new_amg_msg

715:
716: -- The user does not have update privileges on this project
717: -- Hence , raise error
718:
719: pa_interface_utils_pub.map_new_amg_msg
720: ( p_old_message_code => 'PA_PROJECT_SECURITY_ENFORCED'
721: ,p_msg_attribute => 'CHANGE'
722: ,p_resize_flag => 'Y'
723: ,p_msg_context => 'GENERAL'

Line 754: p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

750: --dbms_output.put_line('Starting the budget type validations');
751:
752: -- Do the validations required for the budget model
753: IF (p_budget_type_code IS NOT NULL AND
754: p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
755:
756: --dbms_output.put_line('About to call the security api');
757: --Check for the security
758: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY (

Line 794: pa_interface_utils_pub.map_new_amg_msg

790: IF l_budget_amount_code_csr%NOTFOUND
791: THEN
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
793: THEN
794: pa_interface_utils_pub.map_new_amg_msg
795: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
796: ,p_msg_attribute => 'CHANGE'
797: ,p_resize_flag => 'N'
798: ,p_msg_context => 'BUDG'

Line 932: pa_interface_utils_pub.map_new_amg_msg

928: IF (nvl(l_fck_req_flag,'N') = 'Y')
929: THEN
930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
931: THEN
932: pa_interface_utils_pub.map_new_amg_msg
933: ( p_old_message_code => 'PA_BC_BGT_TYPE_IS_BAD_AMG'
934: ,p_msg_attribute => 'CHANGE'
935: ,p_resize_flag => 'N'
936: ,p_msg_context => 'BUDG'

Line 954: OR p_entry_method_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

950:
951: -- entry method code is mandatory
952:
953: IF p_entry_method_code IS NULL
954: OR p_entry_method_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
955: THEN
956:
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
958: THEN

Line 959: pa_interface_utils_pub.map_new_amg_msg

955: THEN
956:
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
958: THEN
959: pa_interface_utils_pub.map_new_amg_msg
960: ( p_old_message_code => 'PA_ENTRY_METHOD_IS_MISSING'
961: ,p_msg_attribute => 'CHANGE'
962: ,p_resize_flag => 'N'
963: ,p_msg_context => 'BUDG'

Line 991: pa_interface_utils_pub.map_new_amg_msg

987: THEN
988:
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
990: THEN
991: pa_interface_utils_pub.map_new_amg_msg
992: ( p_old_message_code => 'PA_ENTRY_METHOD_IS_INVALID'
993: ,p_msg_attribute => 'CHANGE'
994: ,p_resize_flag => 'N'
995: ,p_msg_context => 'BUDG'

Line 1029: pa_interface_utils_pub.map_new_amg_msg

1025: p_err_stack => l_err_stack );
1026:
1027: IF l_err_code <> 0 THEN
1028: IF NOT pa_project_pvt.check_valid_message(l_err_stage) THEN
1029: pa_interface_utils_pub.map_new_amg_msg
1030: ( p_old_message_code => 'PA_NO_UNCATEGORIZED_LIST'
1031: ,p_msg_attribute => 'CHANGE'
1032: ,p_resize_flag => 'N'
1033: ,p_msg_context => 'BUDG'

Line 1045: pa_interface_utils_pub.map_new_amg_msg

1041: pa_debug.g_err_stage:= 'Uncategorized res list is missing';
1042: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1043: END IF;
1044: ELSE
1045: pa_interface_utils_pub.map_new_amg_msg
1046: ( p_old_message_code => l_err_stage
1047: ,p_msg_attribute => 'CHANGE'
1048: ,p_resize_flag => 'N'
1049: ,p_msg_context => 'BUDG'

Line 1070: IF (px_resource_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1066: END IF; -- IF l_err_code <> 0 THEN
1067:
1068:
1069: ELSIF l_budget_entry_method_rec.categorization_code = 'R' THEN
1070: IF (px_resource_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1071: AND px_resource_list_name IS NOT NULL)
1072: OR (px_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1073: AND px_resource_list_id IS NOT NULL) THEN
1074: -- convert resource_list_name to resource_list_id

Line 1072: OR (px_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1068:
1069: ELSIF l_budget_entry_method_rec.categorization_code = 'R' THEN
1070: IF (px_resource_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1071: AND px_resource_list_name IS NOT NULL)
1072: OR (px_resource_list_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1073: AND px_resource_list_id IS NOT NULL) THEN
1074: -- convert resource_list_name to resource_list_id
1075: px_resource_list_id_in := px_resource_list_id;
1076: pa_resource_pub.Convert_List_name_to_id

Line 1149: pa_interface_utils_pub.map_new_amg_msg

1145: x_return_status := FND_API.G_RET_STS_ERROR; --AMG UT2
1146: l_any_error_occurred_flag := 'Y';
1147:
1148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1149: pa_interface_utils_pub.map_new_amg_msg
1150: ( p_old_message_code => 'PA_RESOURCE_LIST_IS_MISSING'
1151: ,p_msg_attribute => 'CHANGE'
1152: ,p_resize_flag => 'Y'
1153: ,p_msg_context => 'BUDG'

Line 1331: pa_interface_utils_pub.map_new_amg_msg

1327: IF l_budget_status_code = 'S'
1328: THEN
1329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1330: THEN
1331: pa_interface_utils_pub.map_new_amg_msg
1332: ( p_old_message_code => 'PA_BUDGET_IS_SUBMITTED'
1333: ,p_msg_attribute => 'CHANGE'
1334: ,p_resize_flag => 'N'
1335: ,p_msg_context => 'BUDG'

Line 1592: p_budget_version_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

1588:
1589: /* Bug 3133930- Version name validation is included */
1590:
1591: IF p_budget_version_name IS NULL OR
1592: p_budget_version_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1593: PA_UTILS.ADD_MESSAGE(
1594: p_app_short_name => 'PA'
1595: ,p_msg_name => 'PA_VERSION_NAME_IS_MISSING');
1596: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 1708: pa_interface_utils_pub.map_new_amg_msg

1704: p_err_stack => l_err_stack );
1705:
1706: IF l_err_code <> 0 THEN
1707: IF NOT pa_project_pvt.check_valid_message(l_err_stage) THEN
1708: pa_interface_utils_pub.map_new_amg_msg
1709: ( p_old_message_code => 'PA_NO_UNCATEGORIZED_LIST'
1710: ,p_msg_attribute => 'CHANGE'
1711: ,p_resize_flag => 'N'
1712: ,p_msg_context => 'BUDG'

Line 1724: pa_interface_utils_pub.map_new_amg_msg

1720: pa_debug.g_err_stage:= 'Uncategorized res list is missing';
1721: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1722: END IF;
1723: ELSE
1724: pa_interface_utils_pub.map_new_amg_msg
1725: ( p_old_message_code => l_err_stage
1726: ,p_msg_attribute => 'CHANGE'
1727: ,p_resize_flag => 'N'
1728: ,p_msg_context => 'BUDG'

Line 1748: px_resource_list_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )AND

1744: -- RAISE FND_API.G_EXC_ERROR;
1745: END IF; -- IF l_err_code <> 0 THEN
1746: ELSE
1747: IF( px_resource_list_name IS NULL OR
1748: px_resource_list_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )AND
1749: (px_resource_list_id IS NULL OR
1750: px_resource_list_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1751:
1752: IF l_debug_mode = 'Y' THEN

Line 1750: px_resource_list_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

1746: ELSE
1747: IF( px_resource_list_name IS NULL OR
1748: px_resource_list_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )AND
1749: (px_resource_list_id IS NULL OR
1750: px_resource_list_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
1751:
1752: IF l_debug_mode = 'Y' THEN
1753: pa_debug.g_err_stage := 'Defaulting Resource List Id from the plan type' ;
1754: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 2474: pa_interface_utils_pub.map_new_amg_msg

2470: pa_debug.g_err_stage := 'Version exists in submitted status';
2471: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2472: END IF;
2473:
2474: pa_interface_utils_pub.map_new_amg_msg
2475: ( p_old_message_code => 'PA_BUDGET_IS_SUBMITTED'
2476: ,p_msg_attribute => 'CHANGE'
2477: ,p_resize_flag => 'N'
2478: ,p_msg_context => 'BUDG'

Line 2522: p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

2518:
2519: -- check validity of the budget change reason code, passing NULL is OK
2520:
2521: IF (p_change_reason_code IS NOT NULL AND
2522: p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
2523:
2524: --dbms_output.put_line('In head p_change_reason_code is '||p_change_reason_code);
2525: OPEN l_budget_change_reason_csr( p_change_reason_code );
2526: FETCH l_budget_change_reason_csr INTO l_dummy;

Line 2528: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

2524: --dbms_output.put_line('In head p_change_reason_code is '||p_change_reason_code);
2525: OPEN l_budget_change_reason_csr( p_change_reason_code );
2526: FETCH l_budget_change_reason_csr INTO l_dummy;
2527: IF (p_budget_type_code IS NULL OR
2528: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
2529:
2530: l_context_info := l_fin_plan_type_name;
2531:
2532: ELSE

Line 2542: pa_interface_utils_pub.map_new_amg_msg

2538: CLOSE l_budget_change_reason_csr;
2539:
2540: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2541: THEN
2542: pa_interface_utils_pub.map_new_amg_msg
2543: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
2544: ,p_msg_attribute => 'CHANGE'
2545: ,p_resize_flag => 'N'
2546: ,p_msg_context => 'BUDG'

Line 2603: PA_INTERFACE_UTILS_PUB.get_messages

2599: l_msg_count := FND_MSG_PUB.count_msg;
2600: --dbms_output.put_line('MSG count in the stack ' || l_msg_count);
2601:
2602: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
2603: PA_INTERFACE_UTILS_PUB.get_messages
2604: (p_encoded => FND_API.G_TRUE,
2605: p_msg_index => 1,
2606: p_msg_count => l_msg_count,
2607: p_msg_data => l_msg_data,

Line 2903: IF px_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2899: END IF;
2900:
2901: --Convert following IN parameters from G_PA_MISS_XXX to null
2902:
2903: IF px_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2904: px_pa_project_id := NULL;
2905: END IF;
2906:
2907: IF px_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 2907: IF px_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2903: IF px_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2904: px_pa_project_id := NULL;
2905: END IF;
2906:
2907: IF px_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2908: px_budget_type_code := NULL;
2909: END IF;
2910:
2911: IF px_fin_plan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 2911: IF px_fin_plan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

2907: IF px_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2908: px_budget_type_code := NULL;
2909: END IF;
2910:
2911: IF px_fin_plan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2912: px_fin_plan_type_id := NULL;
2913: END IF;
2914:
2915: IF px_fin_plan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 2915: IF px_fin_plan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2911: IF px_fin_plan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2912: px_fin_plan_type_id := NULL;
2913: END IF;
2914:
2915: IF px_fin_plan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2916: px_fin_plan_type_name := NULL;
2917: END IF;
2918:
2919: IF px_version_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

Line 2919: IF px_version_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

2915: IF px_fin_plan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2916: px_fin_plan_type_name := NULL;
2917: END IF;
2918:
2919: IF px_version_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2920: px_version_type := NULL;
2921: END IF;
2922:
2923: -- Both Budget Type Code and Fin Plan Type Id should not be null

Line 2963: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

2959:
2960: END IF;
2961:
2962: --product_code is mandatory
2963: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2964: OR p_pm_product_code IS NULL
2965: THEN
2966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2967: THEN

Line 2968: PA_INTERFACE_UTILS_PUB.map_new_amg_msg

2964: OR p_pm_product_code IS NULL
2965: THEN
2966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2967: THEN
2968: PA_INTERFACE_UTILS_PUB.map_new_amg_msg
2969: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
2970: ,p_msg_attribute => 'CHANGE'
2971: ,p_resize_flag => 'N'
2972: ,p_msg_context => 'GENERAL'

Line 2996: pa_interface_utils_pub.map_new_amg_msg

2992: IF l_pm_product_code <> 'X'
2993: THEN
2994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2995: THEN
2996: pa_interface_utils_pub.map_new_amg_msg
2997: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
2998: ,p_msg_attribute => 'CHANGE'
2999: ,p_resize_flag => 'N'
3000: ,p_msg_context => 'GENERAL'

Line 3048: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := px_pa_project_id;

3044: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3045:
3046: END IF;
3047:
3048: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := px_pa_project_id;
3049:
3050: -- Get the segment 1 of the project so that it can be used in the
3051: -- later part of the code
3052: OPEN l_amg_project_csr( px_pa_project_id );

Line 3109: pa_interface_utils_pub.map_new_amg_msg

3105: THEN
3106: CLOSE l_budget_amount_code_csr;
3107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3108: THEN
3109: pa_interface_utils_pub.map_new_amg_msg
3110: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
3111: ,p_msg_attribute => 'CHANGE'
3112: ,p_resize_flag => 'N'
3113: ,p_msg_context => 'BUDG'

Line 3233: pa_interface_utils_pub.map_new_amg_msg

3229:
3230: /* Since PA.M, this rule no longer applies for bugetary control
3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3232: THEN
3233: pa_interface_utils_pub.map_new_amg_msg
3234: ( p_old_message_code => 'PA_BC_BGT_TYPE_IS_BAD_AMG'
3235: ,p_msg_attribute => 'CHANGE'
3236: ,p_resize_flag => 'N'
3237: ,p_msg_context => 'BUDG'

Line 3268: pa_interface_utils_pub.map_new_amg_msg

3264: IF l_budget_version_csr%NOTFOUND
3265: THEN
3266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3267: THEN
3268: pa_interface_utils_pub.map_new_amg_msg
3269: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
3270: ,p_msg_attribute => 'CHANGE'
3271: ,p_resize_flag => 'N'
3272: ,p_msg_context => 'BUDG'

Line 3289: OR x_budget_entry_method_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3285: CLOSE l_budget_version_csr;
3286:
3287: --entry method code is mandatory
3288: IF x_budget_entry_method_code IS NULL
3289: OR x_budget_entry_method_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3290: THEN
3291:
3292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3293: THEN

Line 3294: pa_interface_utils_pub.map_new_amg_msg

3290: THEN
3291:
3292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3293: THEN
3294: pa_interface_utils_pub.map_new_amg_msg
3295: (p_old_message_code => 'PA_ENTRY_METHOD_IS_MISSING'
3296: ,p_msg_attribute => 'CHANGE'
3297: ,p_resize_flag => 'N'
3298: ,p_msg_context => 'BUDG'

Line 3326: pa_interface_utils_pub.map_new_amg_msg

3322: THEN
3323: CLOSE l_budget_entry_method_csr;
3324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3325: THEN
3326: pa_interface_utils_pub.map_new_amg_msg
3327: ( p_old_message_code => 'PA_ENTRY_METHOD_IS_INVALID'
3328: ,p_msg_attribute => 'CHANGE'
3329: ,p_resize_flag => 'N'
3330: ,p_msg_context => 'BUDG'

Line 3450: AND p_budget_Version_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3446:
3447: --Derive the fin plan version id based on the unique combination of
3448: --project id, fin plan type id, version type and version number
3449: IF p_budget_version_number IS NOT NULL
3450: AND p_budget_Version_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3451: THEN
3452:
3453: OPEN l_finplan_version_id_csr( px_pa_project_id
3454: ,px_fin_plan_type_id

Line 3484: IF x_budget_version_id IS NULL OR x_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3480:
3481: END IF; --p_budget_version_number IS NOT NULL
3482:
3483: --If budget version id can't be found throw appropriate error message
3484: IF x_budget_version_id IS NULL OR x_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3485: THEN
3486: --Throw appropriate error message
3487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3488: PA_UTILS.ADD_MESSAGE

Line 3570: p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

3566:
3567:
3568: -- check validity of the budget change reason code, passing NULL is OK
3569: IF (p_change_reason_code IS NOT NULL AND
3570: p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3571: THEN
3572: OPEN l_budget_change_reason_csr( p_change_reason_code );
3573: FETCH l_budget_change_reason_csr INTO l_dummy1;
3574:

Line 3586: pa_interface_utils_pub.map_new_amg_msg

3582: CLOSE l_budget_change_reason_csr;
3583:
3584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3585: THEN
3586: pa_interface_utils_pub.map_new_amg_msg
3587: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
3588: ,p_msg_attribute => 'CHANGE'
3589: ,p_resize_flag => 'N'
3590: ,p_msg_context => 'BUDG'

Line 3676: IF (( px_raw_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3672: px_cost_rate_flag := NVL (px_cost_rate_flag,'N');
3673: px_burden_rate_flag := NVL (px_burden_rate_flag,'N');
3674:
3675: /* Skip the validations if all are passed as G_PA_MISS_CHAR */
3676: IF (( px_raw_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3677: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

Line 3677: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3673: px_burden_rate_flag := NVL (px_burden_rate_flag,'N');
3674:
3675: /* Skip the validations if all are passed as G_PA_MISS_CHAR */
3676: IF (( px_raw_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3677: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

Line 3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3674:
3675: /* Skip the validations if all are passed as G_PA_MISS_CHAR */
3676: IF (( px_raw_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3677: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

Line 3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3675: /* Skip the validations if all are passed as G_PA_MISS_CHAR */
3676: IF (( px_raw_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3677: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

Line 3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3676: IF (( px_raw_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3677: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3684: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN

Line 3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3677: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3684: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
3685:

Line 3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3678: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3684: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
3685:
3686: /*Get the existing plan amount entry flags for the plan version*/

Line 3683: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR

3679: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3684: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
3685:
3686: /*Get the existing plan amount entry flags for the plan version*/
3687: l_amount_set_id := PA_FIN_PLAN_UTILS.get_amount_set_id(x_budget_version_id);

Line 3684: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN

3680: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3684: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
3685:
3686: /*Get the existing plan amount entry flags for the plan version*/
3687: l_amount_set_id := PA_FIN_PLAN_UTILS.get_amount_set_id(x_budget_version_id);
3688:

Line 3710: IF ( px_raw_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3706: -- RAISE FND_API.G_EXC_ERROR;
3707: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3708: END IF;
3709:
3710: IF ( px_raw_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3711: px_raw_cost_flag := lx_raw_cost_flag;
3712: END IF ;
3713:
3714: IF ( px_burdened_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3714: IF ( px_burdened_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3710: IF ( px_raw_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3711: px_raw_cost_flag := lx_raw_cost_flag;
3712: END IF ;
3713:
3714: IF ( px_burdened_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3715: px_burdened_cost_flag := lx_burdened_cost_flag;
3716: END IF ;
3717:
3718: IF ( px_revenue_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3718: IF ( px_revenue_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3714: IF ( px_burdened_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3715: px_burdened_cost_flag := lx_burdened_cost_flag;
3716: END IF ;
3717:
3718: IF ( px_revenue_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3719: px_revenue_flag := lx_revenue_flag;
3720: END IF ;
3721:
3722: IF ( px_cost_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3722: IF ( px_cost_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3718: IF ( px_revenue_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3719: px_revenue_flag := lx_revenue_flag;
3720: END IF ;
3721:
3722: IF ( px_cost_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3723: px_cost_qty_flag := lx_cost_qty_flag;
3724: END IF ;
3725:
3726: IF ( px_revenue_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3726: IF ( px_revenue_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3722: IF ( px_cost_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3723: px_cost_qty_flag := lx_cost_qty_flag;
3724: END IF ;
3725:
3726: IF ( px_revenue_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3727: px_revenue_qty_flag := lx_revenue_qty_flag;
3728: END IF ;
3729:
3730: IF ( px_all_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3730: IF ( px_all_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3726: IF ( px_revenue_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3727: px_revenue_qty_flag := lx_revenue_qty_flag;
3728: END IF ;
3729:
3730: IF ( px_all_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3731: px_all_qty_flag := lx_all_qty_flag;
3732: END IF ;
3733:
3734: IF ( px_bill_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3734: IF ( px_bill_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3730: IF ( px_all_qty_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3731: px_all_qty_flag := lx_all_qty_flag;
3732: END IF ;
3733:
3734: IF ( px_bill_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3735: px_bill_rate_flag := lx_bill_rate_flag;
3736: END IF ;
3737:
3738: IF ( px_cost_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3738: IF ( px_cost_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3734: IF ( px_bill_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3735: px_bill_rate_flag := lx_bill_rate_flag;
3736: END IF ;
3737:
3738: IF ( px_cost_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3739: px_cost_rate_flag := lx_cost_rate_flag;
3740: END IF ;
3741:
3742: IF ( px_burden_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

Line 3742: IF ( px_burden_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

3738: IF ( px_cost_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3739: px_cost_rate_flag := lx_cost_rate_flag;
3740: END IF ;
3741:
3742: IF ( px_burden_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3743: px_burden_rate_flag := lx_burden_rate_flag;
3744: END IF ;
3745:
3746:

Line 3912: PA_INTERFACE_UTILS_PUB.get_messages

3908:
3909: x_msg_count := FND_MSG_PUB.count_msg;
3910:
3911: IF x_msg_count = 1 AND x_msg_data IS NULL THEN
3912: PA_INTERFACE_UTILS_PUB.get_messages
3913: (p_encoded => FND_API.G_TRUE,
3914: p_msg_index => 1,
3915: p_msg_count => x_msg_count,
3916: p_msg_data => x_msg_data,

Line 4000: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3996: -- to insert_budget_line API.
3997:
3998: PROCEDURE insert_budget_line
3999: ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4000: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4001: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4001: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3997:
3998: PROCEDURE insert_budget_line
3999: ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4000: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4001: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3998: PROCEDURE insert_budget_line
3999: ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4000: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4001: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3999: ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4000: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4001: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4000: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4001: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4001: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4002: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4003: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4004: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4005: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4006: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4007: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4008: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4009: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4010: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4011: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4012: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4013: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4014: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4015: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4016: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4017: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4018: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4019: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4020: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4021: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4022: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4023: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4024: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4025: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4026: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4027: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4028: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4029: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4030: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4038: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4031: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4038: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4039: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464

Line 4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4032: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4038: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4039: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4040:

Line 4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4033: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4038: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4039: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4040:
4041: IS

Line 4038: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4034: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4038: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4039: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4040:
4041: IS
4042:

Line 4039: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464

4035: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4038: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4039: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4040:
4041: IS
4042:
4043: l_return_status VARCHAR2(1);

Line 4148: pa_interface_utils_pub.map_new_amg_msg

4144: IF l_resource_csr%NOTFOUND
4145: THEN
4146: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4147: THEN
4148: pa_interface_utils_pub.map_new_amg_msg
4149: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
4150: ,p_msg_attribute => 'CHANGE'
4151: ,p_resize_flag => 'N'
4152: ,p_msg_context => 'BUDG'

Line 4175: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4171: This will be done in validate_budget_lines.
4172:
4173: -- bug 3062294
4174: --product_code is mandatory : this validation was missing altogether
4175: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4176: OR p_pm_product_code IS NULL
4177: THEN
4178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4179: THEN

Line 4180: pa_interface_utils_pub.map_new_amg_msg

4176: OR p_pm_product_code IS NULL
4177: THEN
4178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4179: THEN
4180: pa_interface_utils_pub.map_new_amg_msg
4181: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4182: ,p_msg_attribute => 'CHANGE'
4183: ,p_resize_flag => 'N'
4184: ,p_msg_context => 'GENERAL'

Line 4209: IF (p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

4205:
4206: --Get the task number
4207:
4208: --Fixed for bug 5060391
4209: IF (p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
4210: l_task_id := NULL;
4211: ELSE
4212: l_task_id := p_pa_task_id;
4213: END IF;

Line 4214: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

4210: l_task_id := NULL;
4211: ELSE
4212: l_task_id := p_pa_task_id;
4213: END IF;
4214: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
4215: ( p_task_number=> ''
4216: ,p_task_reference => p_pm_task_reference
4217: ,p_task_id => l_task_id);
4218:

Line 4220: IF p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4216: ,p_task_reference => p_pm_task_reference
4217: ,p_task_id => l_task_id);
4218:
4219: --When descriptive flex fields are not passed set them to NULL
4220: IF p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4221: THEN
4222: l_attribute_category := NULL;
4223: ELSE
4224: l_attribute_category := p_attribute_category;

Line 4227: IF p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4223: ELSE
4224: l_attribute_category := p_attribute_category;
4225: END IF;
4226:
4227: IF p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4228: THEN
4229: l_attribute1 := NULL;
4230: ELSE
4231: l_attribute1 := p_attribute1;

Line 4234: IF p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4230: ELSE
4231: l_attribute1 := p_attribute1;
4232: END IF;
4233:
4234: IF p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4235: THEN
4236: l_attribute2 := NULL;
4237: ELSE
4238: l_attribute2 := p_attribute2;

Line 4241: IF p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4237: ELSE
4238: l_attribute2 := p_attribute2;
4239: END IF;
4240:
4241: IF p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4242: THEN
4243: l_attribute3 := NULL;
4244: ELSE
4245: l_attribute3 := p_attribute3;

Line 4248: IF p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4244: ELSE
4245: l_attribute3 := p_attribute3;
4246: END IF;
4247:
4248: IF p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4249: THEN
4250: l_attribute4 := NULL;
4251: ELSE
4252: l_attribute4 := p_attribute4;

Line 4255: IF p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4251: ELSE
4252: l_attribute4 := p_attribute4;
4253: END IF;
4254:
4255: IF p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4256: THEN
4257: l_attribute5 := NULL;
4258: ELSE
4259: l_attribute5 := p_attribute5;

Line 4262: IF p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4258: ELSE
4259: l_attribute5 := p_attribute5;
4260: END IF;
4261:
4262: IF p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4263: THEN
4264: l_attribute6 := NULL;
4265: ELSE
4266: l_attribute6 := p_attribute6;

Line 4269: IF p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4265: ELSE
4266: l_attribute6 := p_attribute6;
4267: END IF;
4268:
4269: IF p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4270: THEN
4271: l_attribute7 := NULL;
4272: ELSE
4273: l_attribute7 := p_attribute7;

Line 4276: IF p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4272: ELSE
4273: l_attribute7 := p_attribute7;
4274: END IF;
4275:
4276: IF p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4277: THEN
4278: l_attribute8 := NULL;
4279: ELSE
4280: l_attribute8 := p_attribute8;

Line 4283: IF p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4279: ELSE
4280: l_attribute8 := p_attribute8;
4281: END IF;
4282:
4283: IF p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4284: THEN
4285: l_attribute9 := NULL;
4286: ELSE
4287: l_attribute9 := p_attribute9;

Line 4290: IF p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4286: ELSE
4287: l_attribute9 := p_attribute9;
4288: END IF;
4289:
4290: IF p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4291: THEN
4292: l_attribute10 := NULL;
4293: ELSE
4294: l_attribute10 := p_attribute10;

Line 4297: IF p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4293: ELSE
4294: l_attribute10 := p_attribute10;
4295: END IF;
4296:
4297: IF p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4298: THEN
4299: l_attribute11 := NULL;
4300: ELSE
4301: l_attribute11 := p_attribute11;

Line 4304: IF p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4300: ELSE
4301: l_attribute11 := p_attribute11;
4302: END IF;
4303:
4304: IF p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4305: THEN
4306: l_attribute12 := NULL;
4307: ELSE
4308: l_attribute12 := p_attribute12;

Line 4311: IF p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4307: ELSE
4308: l_attribute12 := p_attribute12;
4309: END IF;
4310:
4311: IF p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4312: THEN
4313: l_attribute13 := NULL;
4314: ELSE
4315: l_attribute13 := p_attribute13;

Line 4318: IF p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4314: ELSE
4315: l_attribute13 := p_attribute13;
4316: END IF;
4317:
4318: IF p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4319: THEN
4320: l_attribute14:= NULL;
4321: ELSE
4322: l_attribute14:= p_attribute14;

Line 4325: IF p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4321: ELSE
4322: l_attribute14:= p_attribute14;
4323: END IF;
4324:
4325: IF p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4326: THEN
4327: l_attribute15 := NULL;
4328: ELSE
4329: l_attribute15 := p_attribute15;

Line 4336: IF p_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4332:
4333: --Remove big numbers in case parameters were not passed, default to NULL; Assign Valid
4334: --Values to local variables.
4335:
4336: IF p_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4337: THEN
4338: l_quantity := null;
4339: ELSE
4340: l_quantity := p_quantity;

Line 4343: IF p_raw_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4339: ELSE
4340: l_quantity := p_quantity;
4341: END IF;
4342:
4343: IF p_raw_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4344: THEN
4345: l_raw_cost := null;
4346: ELSE
4347: l_raw_cost := p_raw_cost;

Line 4350: IF p_burdened_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4346: ELSE
4347: l_raw_cost := p_raw_cost;
4348: END IF;
4349:
4350: IF p_burdened_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4351: THEN
4352: l_burdened_cost := null;
4353: ELSE
4354: l_burdened_cost := p_burdened_cost;

Line 4357: IF p_revenue = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4353: ELSE
4354: l_burdened_cost := p_burdened_cost;
4355: END IF;
4356:
4357: IF p_revenue = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4358: THEN
4359: l_revenue := null;
4360: ELSE
4361: l_revenue := p_revenue;

Line 4367: IF p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4363: -- extending this null assignment to all other parameters passed as part
4364: -- of p_budget_lines_rec (as defined in pa_budget_pub)
4365: -- Added for bug 3062294 :
4366:
4367: IF p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4368: THEN
4369: l_pa_task_id := null;
4370: ELSE
4371: l_pa_task_id := p_pa_task_id;

Line 4374: IF p_pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4370: ELSE
4371: l_pa_task_id := p_pa_task_id;
4372: END IF;
4373:
4374: IF p_pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4375: THEN
4376: l_pm_task_ref := null;
4377: ELSE
4378: l_pm_task_ref := p_pm_task_reference;

Line 4381: IF p_resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4377: ELSE
4378: l_pm_task_ref := p_pm_task_reference;
4379: END IF;
4380:
4381: IF p_resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4382: THEN
4383: l_resource_alias := null;
4384: ELSE
4385: l_resource_alias := p_resource_alias;

Line 4388: IF p_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4384: ELSE
4385: l_resource_alias := p_resource_alias;
4386: END IF;
4387:
4388: IF p_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4389: THEN
4390: l_rlm_id := null;
4391: ELSE
4392: l_rlm_id := p_member_id;

Line 4395: IF p_budget_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4391: ELSE
4392: l_rlm_id := p_member_id;
4393: END IF;
4394:
4395: IF p_budget_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4396: THEN
4397: l_budget_start_date := null;
4398: ELSE
4399: l_budget_start_date := p_budget_start_date;

Line 4402: IF p_budget_end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4398: ELSE
4399: l_budget_start_date := p_budget_start_date;
4400: END IF;
4401:
4402: IF p_budget_end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4403: THEN
4404: l_budget_end_date := null;
4405: ELSE
4406: l_budget_end_date := p_budget_end_date;

Line 4409: IF p_period_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4405: ELSE
4406: l_budget_end_date := p_budget_end_date;
4407: END IF;
4408:
4409: IF p_period_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4410: THEN
4411: l_period_name := null;
4412: ELSE
4413: l_period_name := p_period_name;

Line 4416: IF p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4412: ELSE
4413: l_period_name := p_period_name;
4414: END IF;
4415:
4416: IF p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4417: THEN
4418: l_description := null;
4419: ELSE
4420: l_description := p_description;

Line 4423: IF p_pm_budget_line_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4419: ELSE
4420: l_description := p_description;
4421: END IF;
4422:
4423: IF p_pm_budget_line_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4424: THEN
4425: l_pm_budget_line_reference := null;
4426: ELSE
4427: l_pm_budget_line_reference := p_pm_budget_line_reference;

Line 4431: IF p_change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4427: l_pm_budget_line_reference := p_pm_budget_line_reference;
4428: END IF;
4429:
4430: --Bug 4224464
4431: IF p_change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4432: THEN
4433: l_change_reason_code := NULL;
4434: ELSE
4435: l_change_reason_code := p_change_reason_code;

Line 4438: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4434: ELSE
4435: l_change_reason_code := p_change_reason_code;
4436: END IF;
4437:
4438: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4439: THEN
4440: l_pm_product_code := NULL;
4441: ELSE
4442: l_pm_product_code := p_pm_product_code;

Line 4520: IF p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4516:
4517: --Bug 4224464: FP.M Changes for Validate_Budget_Lines
4518: --Send the budget version id to validate_budget_lines API for
4519: --actuals on FORECAST check
4520: IF p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4521: l_version_info_rec.x_budget_version_id := null;
4522: ELSE
4523: l_version_info_rec.x_budget_version_id := p_budget_version_id;
4524: END IF;

Line 4640: pa_interface_utils_pub.map_new_amg_msg

4636: THEN
4637:
4638: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4639: THEN
4640: pa_interface_utils_pub.map_new_amg_msg
4641: ( p_old_message_code => 'PA_CREATE_LINE_FAILED'
4642: ,p_msg_attribute => 'CHANGE'
4643: ,p_resize_flag => 'N'
4644: ,p_msg_context => 'BUDG'

Line 4651: pa_interface_utils_pub.map_new_amg_msg

4647: ,p_attribute3 => p_budget_type_code
4648: ,p_attribute4 => ''
4649: ,p_attribute5 => to_char(p_budget_start_date));
4650: ELSE
4651: pa_interface_utils_pub.map_new_amg_msg
4652: ( p_old_message_code => l_err_stage
4653: ,p_msg_attribute => 'CHANGE'
4654: ,p_resize_flag => 'N'
4655: ,p_msg_context => 'BUDG'

Line 4674: pa_interface_utils_pub.map_new_amg_msg

4670: IF l_err_code = -1 --special handling of duplicate line error
4671: THEN
4672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4673: THEN
4674: pa_interface_utils_pub.map_new_amg_msg
4675: ( p_old_message_code => 'PA_BUDGET_LINE_ALREADY_EXISTS'
4676: ,p_msg_attribute => 'CHANGE'
4677: ,p_resize_flag => 'Y'
4678: ,p_msg_context => 'BUDG'

Line 6252: pa_interface_utils_pub.map_new_amg_msg

6248: p_err_stack => l_err_stack );
6249:
6250: IF l_err_code <> 0 THEN
6251: IF NOT pa_project_pvt.check_valid_message(l_err_stage) THEN
6252: pa_interface_utils_pub.map_new_amg_msg
6253: ( p_old_message_code => 'PA_NO_UNCATEGORIZED_LIST'
6254: ,p_msg_attribute => 'CHANGE'
6255: ,p_resize_flag => 'N'
6256: ,p_msg_context => 'BUDG'

Line 6263: pa_interface_utils_pub.map_new_amg_msg

6259: ,p_attribute3 => p_budget_type_code
6260: ,p_attribute4 => ''
6261: ,p_attribute5 => '');
6262: ELSE
6263: pa_interface_utils_pub.map_new_amg_msg
6264: ( p_old_message_code => l_err_stage
6265: ,p_msg_attribute => 'CHANGE'
6266: ,p_resize_flag => 'N'
6267: ,p_msg_context => 'BUDG'

Line 6390: IF px_budget_lines_in(i).pm_product_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

6386:
6387:
6388: /* Bug 3218822 - PM_PRODUCT_CODE could be Null. We need valid it if it is NOT NULL */
6389:
6390: IF px_budget_lines_in(i).pm_product_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6391: OR px_budget_lines_in(i).pm_product_code IS NOT NULL
6392: THEN
6393:
6394: /* Validating as done in bug# 2413400 */

Line 6402: pa_interface_utils_pub.map_new_amg_msg

6398: IF l_pm_product_code <> 'X'
6399: THEN
6400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6401: THEN
6402: pa_interface_utils_pub.map_new_amg_msg
6403: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
6404: ,p_msg_attribute => 'CHANGE'
6405: ,p_resize_flag => 'N'
6406: ,p_msg_context => 'GENERAL'

Line 6461: IF(px_budget_lines_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND

6457: --pa_task_id or pm_task_reference. The rule is pa_task_id is honoured if both are passed to the API
6458: --otherwise whichever value is passed that value is honoured by the API.
6459: --Also note while preparing the index we are prepending 'TSKID' or 'TSKREF' before the actual values.
6460: --The index would always be in this format.
6461: IF(px_budget_lines_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
6462: px_budget_lines_in(i).pa_task_id is not null)
6463: THEN
6464: --Prepending the word 'TSKID' before the pa_task_id value while preparing the index.
6465: l_distinct_tskid_idx := 'TSKID' || px_budget_lines_in(i).pa_task_id;

Line 6466: ELSIF( px_budget_lines_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND

6462: px_budget_lines_in(i).pa_task_id is not null)
6463: THEN
6464: --Prepending the word 'TSKID' before the pa_task_id value while preparing the index.
6465: l_distinct_tskid_idx := 'TSKID' || px_budget_lines_in(i).pa_task_id;
6466: ELSIF( px_budget_lines_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
6467: px_budget_lines_in(i).pm_task_reference is not null)
6468: THEN
6469: --Prepending the word 'TSKREF' before the pm_task_reference value while preparing the index.
6470: l_distinct_tskid_idx := 'TSKREF' || px_budget_lines_in(i).pm_task_reference;

Line 6549: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

6545: -- get the task number. This task number is required as input to map_new_amg_msg API.
6546:
6547: IF px_budget_lines_in(i).pa_task_id <> 0 THEN
6548:
6549: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
6550: ( p_task_number=> ''
6551: ,p_task_reference => px_budget_lines_in(i).pm_task_reference
6552: ,p_task_id => px_budget_lines_in(i).pa_task_id);
6553: /* Bug 3124283: Added substr below */

Line 6568: pa_interface_utils_pub.map_new_amg_msg

6564:
6565: IF p_entry_level_code = 'T' THEN -- then check whether it is top task
6566: IF px_budget_lines_in(i).pa_task_id <> pa_task_utils.get_top_task_id( px_budget_lines_in(i).pa_task_id ) THEN
6567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6568: pa_interface_utils_pub.map_new_amg_msg
6569: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6570: ,p_msg_attribute => 'CHANGE'
6571: ,p_resize_flag => 'N'
6572: ,p_msg_context => 'TASK'

Line 6593: pa_interface_utils_pub.map_new_amg_msg

6589: px_budget_lines_in(i).pa_task_id);
6590: IF l_return_status_task <> 0 THEN
6591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6592: THEN
6593: pa_interface_utils_pub.map_new_amg_msg
6594: ( p_old_message_code => 'PA_TASK_IS_NOT_LOWEST'
6595: ,p_msg_attribute => 'CHANGE'
6596: ,p_resize_flag => 'N'
6597: ,p_msg_context => 'TASK'

Line 6631: pa_interface_utils_pub.map_new_amg_msg

6627: , px_budget_lines_in(i).pa_task_id);
6628: IF l_return_status_task <> 0 THEN
6629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6630: THEN
6631: pa_interface_utils_pub.map_new_amg_msg
6632: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP_OR_LOWEST'
6633: ,p_msg_attribute => 'CHANGE'
6634: ,p_resize_flag => 'Y'
6635: ,p_msg_context => 'TASK'

Line 6673: l_amg_top_task_number := pa_interface_utils_pub.get_task_number_amg

6669:
6670: IF (l_temp IS NOT NULL) THEN
6671: IF l_top_task_planning_level <> l_top_tasks_tbl(l_temp).value THEN
6672:
6673: l_amg_top_task_number := pa_interface_utils_pub.get_task_number_amg
6674: ( p_task_number=> ''
6675: ,p_task_reference => NULL
6676: ,p_task_id => l_top_task_id);
6677:

Line 6725: pa_interface_utils_pub.map_new_amg_msg

6721: l_webadi_err_amt_type_tbl.extend(1);
6722: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
6723: ELSE
6724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6725: pa_interface_utils_pub.map_new_amg_msg
6726: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6727: ,p_msg_attribute => 'CHANGE'
6728: ,p_resize_flag => 'N'
6729: ,p_msg_context => 'TASK'

Line 7004: px_budget_lines_in(i).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

7000: --is not uncategorized
7001: IF (nvl(l_uncategorized_res_list_id,-99) = p_resource_list_id) THEN
7002:
7003: px_budget_lines_in(i).resource_list_member_id :=l_uncategorized_rlmid;
7004: px_budget_lines_in(i).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
7005:
7006: IF p_calling_context = 'UPDATE_PLANNING_ELEMENT_ATTR' then
7007: l_valid_rlmid := 'Y';
7008: END IF ;

Line 7018: IF (px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

7014: -- and resource member is (passed and not NULL)
7015: -- then we convert the alias to the id
7016: -- else we default to the uncategorized resource member
7017:
7018: IF (px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7019: AND px_budget_lines_in(i).resource_alias IS NOT NULL)
7020: OR (px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7021: AND px_budget_lines_in(i).resource_list_member_id IS NOT NULL)
7022: THEN

Line 7020: OR (px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

7016: -- else we default to the uncategorized resource member
7017:
7018: IF (px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7019: AND px_budget_lines_in(i).resource_alias IS NOT NULL)
7020: OR (px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7021: AND px_budget_lines_in(i).resource_list_member_id IS NOT NULL)
7022: THEN
7023:
7024: --Selecting the index if it will be based on rlm_id or resource_alias. This index is decided on the

Line 7034: IF(px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

7030:
7031: --Also didnt included the null check in below if's to decide the index because it has already been
7032: --taken care of in the last if before this. See above. We wont reach here if any one of rlm_id or
7033: --resource_alias is null
7034: IF(px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
7035: THEN
7036: --Prepending the word 'RLMID' before the rlm_id value while preparing the index.
7037: l_distinct_rlmid_idx := 'RLMID' || px_budget_lines_in(i).resource_list_member_id;
7038: ELSIF( px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

Line 7038: ELSIF( px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

7034: IF(px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
7035: THEN
7036: --Prepending the word 'RLMID' before the rlm_id value while preparing the index.
7037: l_distinct_rlmid_idx := 'RLMID' || px_budget_lines_in(i).resource_list_member_id;
7038: ELSIF( px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
7039: THEN
7040: --Prepending the word 'RALIAS' before the reasource_alias value while preparing the index.
7041: l_distinct_rlmid_idx := 'RALIAS' || px_budget_lines_in(i).resource_alias;
7042: END IF;

Line 7067: (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN -- Old Bugdets Model -- Bug 3801891

7063: THEN
7064: -- Initialise valid rlmid variable to Y
7065: l_valid_rlmid := 'Y';
7066: IF((p_budget_type_code IS NOT NULL) AND
7067: (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN -- Old Bugdets Model -- Bug 3801891
7068: --get unit_of_measure and track_as_labor_flag associated to
7069: --the resource member and check whether this is a valid member for this list
7070: OPEN l_resource_csr( px_budget_lines_in(i).resource_list_member_id
7071: ,p_resource_list_id );

Line 7077: pa_interface_utils_pub.map_new_amg_msg

7073: IF l_resource_csr%NOTFOUND THEN
7074: l_context_info := p_budget_type_code;
7075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7076: THEN
7077: pa_interface_utils_pub.map_new_amg_msg
7078: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7079: ,p_msg_attribute => 'CHANGE'
7080: ,p_resize_flag => 'N'
7081: ,p_msg_context => 'BUDG'

Line 7130: pa_interface_utils_pub.map_new_amg_msg

7126: l_webadi_err_amt_type_tbl.extend(1);
7127: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
7128: ELSE
7129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7130: pa_interface_utils_pub.map_new_amg_msg
7131: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7132: ,p_msg_attribute => 'CHANGE'
7133: ,p_resize_flag => 'N'
7134: ,p_msg_context => 'BUDG'

Line 7180: (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN -- 4504585 For old budget model only

7176:
7177: END IF; -- Bug 3801891
7178:
7179: IF((p_budget_type_code IS NOT NULL) AND
7180: (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN -- 4504585 For old budget model only
7181:
7182: IF l_valid_rlmid='Y' THEN
7183:
7184: SELECT parent_member_id

Line 7277: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

7273: END IF; --IF( NOT(l_rlm_id_tbl.exists(l_distinct_rlmid_idx) ) )
7274:
7275: ELSE
7276: IF (p_budget_type_code IS NULL OR
7277: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
7278: l_context_info := l_fin_plan_type_name;
7279: ELSE
7280: l_context_info := p_budget_type_code;
7281: END IF;

Line 7284: pa_interface_utils_pub.map_new_amg_msg

7280: l_context_info := p_budget_type_code;
7281: END IF;
7282:
7283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7284: pa_interface_utils_pub.map_new_amg_msg
7285: ( p_old_message_code => 'PA_RESOURCE_IS_MISSING'
7286: ,p_msg_attribute => 'CHANGE'
7287: ,p_resize_flag => 'N'
7288: ,p_msg_context => 'BUDG'

Line 7711: (p_calling_context <> 'WEBADI' AND px_budget_lines_in(i).change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))) THEN

7707: THEN
7708: --Validate the change reason code. This validation is added for Fin plan model in FP L
7709: IF (px_budget_lines_in(i).change_reason_code IS NOT NULL AND
7710: ((p_calling_context = 'WEBADI' AND px_budget_lines_in(i).change_reason_code <> FND_API.G_MISS_CHAR) OR
7711: (p_calling_context <> 'WEBADI' AND px_budget_lines_in(i).change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))) THEN
7712:
7713: OPEN l_budget_change_reason_csr( px_budget_lines_in(i).change_reason_code );
7714: FETCH l_budget_change_reason_csr INTO l_dummy;
7715: IF l_budget_change_reason_csr%NOTFOUND THEN

Line 7720: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

7716: CLOSE l_budget_change_reason_csr;
7717:
7718: IF p_calling_context <> 'WEBADI' THEN
7719: IF (p_budget_type_code IS NULL OR
7720: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
7721:
7722: l_context_info := l_fin_plan_type_name;
7723: /* Bug 3133930- set the return status to the new output variable */
7724: x_budget_lines_out(i).return_status := x_return_status;

Line 8488: PA_INTERFACE_UTILS_PUB.get_messages

8484:
8485: l_msg_count := FND_MSG_PUB.count_msg;
8486:
8487: IF l_msg_count = 1 and x_msg_data IS NULL THEN
8488: PA_INTERFACE_UTILS_PUB.get_messages
8489: (p_encoded => FND_API.G_TRUE
8490: ,p_msg_index => 1
8491: ,p_msg_count => l_msg_count
8492: ,p_msg_data => l_msg_data