eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_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 2905: IF px_pa_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

Line 2909: IF px_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

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

Line 2913: IF px_fin_plan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

Line 2917: IF px_fin_plan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

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

Line 2921: IF px_version_type = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

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

Line 2965: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

Line 2970: PA_INTERFACE_UTILS_PUB.map_new_amg_msg

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

Line 2998: pa_interface_utils_pub.map_new_amg_msg

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

Line 3050: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := px_pa_project_id;

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

Line 3111: pa_interface_utils_pub.map_new_amg_msg

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

Line 3235: pa_interface_utils_pub.map_new_amg_msg

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

Line 3270: pa_interface_utils_pub.map_new_amg_msg

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

Line 3291: OR x_budget_entry_method_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

Line 3296: pa_interface_utils_pub.map_new_amg_msg

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

Line 3328: pa_interface_utils_pub.map_new_amg_msg

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

Line 3454: AND p_budget_Version_number <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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

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

Line 3574: p_change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

Line 3590: pa_interface_utils_pub.map_new_amg_msg

3586: CLOSE l_budget_change_reason_csr;
3587:
3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3589: THEN
3590: pa_interface_utils_pub.map_new_amg_msg
3591: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
3592: ,p_msg_attribute => 'CHANGE'
3593: ,p_resize_flag => 'N'
3594: ,p_msg_context => 'BUDG'

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

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

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

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

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

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

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

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

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

3680: IF (( px_raw_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3681: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3684: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3685: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3686: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3687: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3688: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN

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

3681: ( px_burdened_cost_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3682: ( px_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3683: ( px_cost_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3684: ( px_revenue_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3685: ( px_all_qty_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3686: ( px_bill_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3687: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3688: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
3689:

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

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

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

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

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

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

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

3710: -- RAISE FND_API.G_EXC_ERROR;
3711: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3712: END IF;
3713:
3714: IF ( px_raw_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3715: px_raw_cost_flag := lx_raw_cost_flag;
3716: END IF ;
3717:
3718: IF ( px_burdened_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3742: IF ( px_cost_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3743: px_cost_rate_flag := lx_cost_rate_flag;
3744: END IF ;
3745:
3746: IF ( px_burden_rate_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3747: px_burden_rate_flag := lx_burden_rate_flag;
3748: END IF ;
3749:
3750:

Line 3916: PA_INTERFACE_UTILS_PUB.get_messages

3912:
3913: x_msg_count := FND_MSG_PUB.count_msg;
3914:
3915: IF x_msg_count = 1 AND x_msg_data IS NULL THEN
3916: PA_INTERFACE_UTILS_PUB.get_messages
3917: (p_encoded => FND_API.G_TRUE,
3918: p_msg_index => 1,
3919: p_msg_count => x_msg_count,
3920: p_msg_data => x_msg_data,

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

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

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

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

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

4002: PROCEDURE insert_budget_line
4003: ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4004: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4005: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4006: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4007: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4008: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes

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

4003: ( p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4004: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4005: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4006: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4007: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4008: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

4004: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4005: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4006: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4007: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4008: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

4005: ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4006: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4007: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4008: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes

4006: ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4007: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4008: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4007: ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4008: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4008: ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4009: ,p_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4010: ,p_cbs_element_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug 16604257 : CBS RBS Phase 2 API changes
4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4011: ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4012: ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4013: ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4014: ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4015: ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4016: ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4017: ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4018: ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4019: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4020: ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4021: ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4022: ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4023: ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4024: ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4025: ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4026: ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4027: ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4028: ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4029: ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4030: ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4031: ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4032: ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4033: ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4034: ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4042: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4035: ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4042: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4043: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4036: ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4042: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4043: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4044: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464

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

4037: ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4042: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4043: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4044: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4045:

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

4038: ,p_time_phased_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4042: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4043: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4044: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4045:
4046: IS

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

4039: ,p_entry_level_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4042: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4043: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4044: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4045:
4046: IS
4047:

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

4040: ,p_budget_amount_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4041: ,p_budget_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4042: ,p_categorization_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4043: ,p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4044: ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )--Bug 4224464
4045:
4046: IS
4047:
4048: l_return_status VARCHAR2(1);

Line 4154: pa_interface_utils_pub.map_new_amg_msg

4150: IF l_resource_csr%NOTFOUND
4151: THEN
4152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4153: THEN
4154: pa_interface_utils_pub.map_new_amg_msg
4155: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
4156: ,p_msg_attribute => 'CHANGE'
4157: ,p_resize_flag => 'N'
4158: ,p_msg_context => 'BUDG'

Line 4181: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4177: This will be done in validate_budget_lines.
4178:
4179: -- bug 3062294
4180: --product_code is mandatory : this validation was missing altogether
4181: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4182: OR p_pm_product_code IS NULL
4183: THEN
4184: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4185: THEN

Line 4186: pa_interface_utils_pub.map_new_amg_msg

4182: OR p_pm_product_code IS NULL
4183: THEN
4184: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4185: THEN
4186: pa_interface_utils_pub.map_new_amg_msg
4187: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4188: ,p_msg_attribute => 'CHANGE'
4189: ,p_resize_flag => 'N'
4190: ,p_msg_context => 'GENERAL'

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

4211:
4212: --Get the task number
4213:
4214: --Fixed for bug 5060391
4215: IF (p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
4216: l_task_id := NULL;
4217: ELSE
4218: l_task_id := p_pa_task_id;
4219: END IF;

Line 4220: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

4216: l_task_id := NULL;
4217: ELSE
4218: l_task_id := p_pa_task_id;
4219: END IF;
4220: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
4221: ( p_task_number=> ''
4222: ,p_task_reference => p_pm_task_reference
4223: ,p_task_id => l_task_id);
4224:

Line 4226: IF p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4222: ,p_task_reference => p_pm_task_reference
4223: ,p_task_id => l_task_id);
4224:
4225: --When descriptive flex fields are not passed set them to NULL
4226: IF p_attribute_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4227: THEN
4228: l_attribute_category := NULL;
4229: ELSE
4230: l_attribute_category := p_attribute_category;

Line 4233: IF p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4229: ELSE
4230: l_attribute_category := p_attribute_category;
4231: END IF;
4232:
4233: IF p_attribute1 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4234: THEN
4235: l_attribute1 := NULL;
4236: ELSE
4237: l_attribute1 := p_attribute1;

Line 4240: IF p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4236: ELSE
4237: l_attribute1 := p_attribute1;
4238: END IF;
4239:
4240: IF p_attribute2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4241: THEN
4242: l_attribute2 := NULL;
4243: ELSE
4244: l_attribute2 := p_attribute2;

Line 4247: IF p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4243: ELSE
4244: l_attribute2 := p_attribute2;
4245: END IF;
4246:
4247: IF p_attribute3 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4248: THEN
4249: l_attribute3 := NULL;
4250: ELSE
4251: l_attribute3 := p_attribute3;

Line 4254: IF p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4250: ELSE
4251: l_attribute3 := p_attribute3;
4252: END IF;
4253:
4254: IF p_attribute4 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4255: THEN
4256: l_attribute4 := NULL;
4257: ELSE
4258: l_attribute4 := p_attribute4;

Line 4261: IF p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4257: ELSE
4258: l_attribute4 := p_attribute4;
4259: END IF;
4260:
4261: IF p_attribute5 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4262: THEN
4263: l_attribute5 := NULL;
4264: ELSE
4265: l_attribute5 := p_attribute5;

Line 4268: IF p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4264: ELSE
4265: l_attribute5 := p_attribute5;
4266: END IF;
4267:
4268: IF p_attribute6 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4269: THEN
4270: l_attribute6 := NULL;
4271: ELSE
4272: l_attribute6 := p_attribute6;

Line 4275: IF p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4271: ELSE
4272: l_attribute6 := p_attribute6;
4273: END IF;
4274:
4275: IF p_attribute7 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4276: THEN
4277: l_attribute7 := NULL;
4278: ELSE
4279: l_attribute7 := p_attribute7;

Line 4282: IF p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4278: ELSE
4279: l_attribute7 := p_attribute7;
4280: END IF;
4281:
4282: IF p_attribute8 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4283: THEN
4284: l_attribute8 := NULL;
4285: ELSE
4286: l_attribute8 := p_attribute8;

Line 4289: IF p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4285: ELSE
4286: l_attribute8 := p_attribute8;
4287: END IF;
4288:
4289: IF p_attribute9 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4290: THEN
4291: l_attribute9 := NULL;
4292: ELSE
4293: l_attribute9 := p_attribute9;

Line 4296: IF p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4292: ELSE
4293: l_attribute9 := p_attribute9;
4294: END IF;
4295:
4296: IF p_attribute10 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4297: THEN
4298: l_attribute10 := NULL;
4299: ELSE
4300: l_attribute10 := p_attribute10;

Line 4303: IF p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4299: ELSE
4300: l_attribute10 := p_attribute10;
4301: END IF;
4302:
4303: IF p_attribute11 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4304: THEN
4305: l_attribute11 := NULL;
4306: ELSE
4307: l_attribute11 := p_attribute11;

Line 4310: IF p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4306: ELSE
4307: l_attribute11 := p_attribute11;
4308: END IF;
4309:
4310: IF p_attribute12 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4311: THEN
4312: l_attribute12 := NULL;
4313: ELSE
4314: l_attribute12 := p_attribute12;

Line 4317: IF p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4313: ELSE
4314: l_attribute12 := p_attribute12;
4315: END IF;
4316:
4317: IF p_attribute13 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4318: THEN
4319: l_attribute13 := NULL;
4320: ELSE
4321: l_attribute13 := p_attribute13;

Line 4324: IF p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4320: ELSE
4321: l_attribute13 := p_attribute13;
4322: END IF;
4323:
4324: IF p_attribute14 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4325: THEN
4326: l_attribute14:= NULL;
4327: ELSE
4328: l_attribute14:= p_attribute14;

Line 4331: IF p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4327: ELSE
4328: l_attribute14:= p_attribute14;
4329: END IF;
4330:
4331: IF p_attribute15 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4332: THEN
4333: l_attribute15 := NULL;
4334: ELSE
4335: l_attribute15 := p_attribute15;

Line 4342: IF p_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4338:
4339: --Remove big numbers in case parameters were not passed, default to NULL; Assign Valid
4340: --Values to local variables.
4341:
4342: IF p_quantity = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4343: THEN
4344: l_quantity := null;
4345: ELSE
4346: l_quantity := p_quantity;

Line 4349: IF p_raw_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4345: ELSE
4346: l_quantity := p_quantity;
4347: END IF;
4348:
4349: IF p_raw_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4350: THEN
4351: l_raw_cost := null;
4352: ELSE
4353: l_raw_cost := p_raw_cost;

Line 4356: IF p_burdened_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4352: ELSE
4353: l_raw_cost := p_raw_cost;
4354: END IF;
4355:
4356: IF p_burdened_cost = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4357: THEN
4358: l_burdened_cost := null;
4359: ELSE
4360: l_burdened_cost := p_burdened_cost;

Line 4363: IF p_revenue = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4359: ELSE
4360: l_burdened_cost := p_burdened_cost;
4361: END IF;
4362:
4363: IF p_revenue = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4364: THEN
4365: l_revenue := null;
4366: ELSE
4367: l_revenue := p_revenue;

Line 4373: IF p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4369: -- extending this null assignment to all other parameters passed as part
4370: -- of p_budget_lines_rec (as defined in pa_budget_pub)
4371: -- Added for bug 3062294 :
4372:
4373: IF p_pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4374: THEN
4375: l_pa_task_id := null;
4376: ELSE
4377: l_pa_task_id := p_pa_task_id;

Line 4380: IF p_pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4376: ELSE
4377: l_pa_task_id := p_pa_task_id;
4378: END IF;
4379:
4380: IF p_pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4381: THEN
4382: l_pm_task_ref := null;
4383: ELSE
4384: l_pm_task_ref := p_pm_task_reference;

Line 4387: IF p_resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4383: ELSE
4384: l_pm_task_ref := p_pm_task_reference;
4385: END IF;
4386:
4387: IF p_resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4388: THEN
4389: l_resource_alias := null;
4390: ELSE
4391: l_resource_alias := p_resource_alias;

Line 4394: IF p_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4390: ELSE
4391: l_resource_alias := p_resource_alias;
4392: END IF;
4393:
4394: IF p_member_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4395: THEN
4396: l_rlm_id := null;
4397: ELSE
4398: l_rlm_id := p_member_id;

Line 4402: IF p_cbs_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4398: l_rlm_id := p_member_id;
4399: END IF;
4400:
4401:
4402: IF p_cbs_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4403: THEN
4404: l_cbs_element_id := null;
4405: ELSE
4406: l_cbs_element_id := p_cbs_element_id;

Line 4409: IF p_budget_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4405: ELSE
4406: l_cbs_element_id := p_cbs_element_id;
4407: END IF;
4408:
4409: IF p_budget_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4410: THEN
4411: l_budget_start_date := null;
4412: ELSE
4413: l_budget_start_date := p_budget_start_date;

Line 4416: IF p_budget_end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4412: ELSE
4413: l_budget_start_date := p_budget_start_date;
4414: END IF;
4415:
4416: IF p_budget_end_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4417: THEN
4418: l_budget_end_date := null;
4419: ELSE
4420: l_budget_end_date := p_budget_end_date;

Line 4423: IF p_period_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4419: ELSE
4420: l_budget_end_date := p_budget_end_date;
4421: END IF;
4422:
4423: IF p_period_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4424: THEN
4425: l_period_name := null;
4426: ELSE
4427: l_period_name := p_period_name;

Line 4430: IF p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4426: ELSE
4427: l_period_name := p_period_name;
4428: END IF;
4429:
4430: IF p_description = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4431: THEN
4432: l_description := null;
4433: ELSE
4434: l_description := p_description;

Line 4437: IF p_pm_budget_line_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4433: ELSE
4434: l_description := p_description;
4435: END IF;
4436:
4437: IF p_pm_budget_line_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4438: THEN
4439: l_pm_budget_line_reference := null;
4440: ELSE
4441: l_pm_budget_line_reference := p_pm_budget_line_reference;

Line 4445: IF p_change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4441: l_pm_budget_line_reference := p_pm_budget_line_reference;
4442: END IF;
4443:
4444: --Bug 4224464
4445: IF p_change_reason_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4446: THEN
4447: l_change_reason_code := NULL;
4448: ELSE
4449: l_change_reason_code := p_change_reason_code;

Line 4452: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4448: ELSE
4449: l_change_reason_code := p_change_reason_code;
4450: END IF;
4451:
4452: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4453: THEN
4454: l_pm_product_code := NULL;
4455: ELSE
4456: l_pm_product_code := p_pm_product_code;

Line 4536: IF p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

4532:
4533: --Bug 4224464: FP.M Changes for Validate_Budget_Lines
4534: --Send the budget version id to validate_budget_lines API for
4535: --actuals on FORECAST check
4536: IF p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
4537: l_version_info_rec.x_budget_version_id := null;
4538: ELSE
4539: l_version_info_rec.x_budget_version_id := p_budget_version_id;
4540: END IF;

Line 4657: pa_interface_utils_pub.map_new_amg_msg

4653: THEN
4654:
4655: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4656: THEN
4657: pa_interface_utils_pub.map_new_amg_msg
4658: ( p_old_message_code => 'PA_CREATE_LINE_FAILED'
4659: ,p_msg_attribute => 'CHANGE'
4660: ,p_resize_flag => 'N'
4661: ,p_msg_context => 'BUDG'

Line 4668: pa_interface_utils_pub.map_new_amg_msg

4664: ,p_attribute3 => p_budget_type_code
4665: ,p_attribute4 => ''
4666: ,p_attribute5 => to_char(p_budget_start_date));
4667: ELSE
4668: pa_interface_utils_pub.map_new_amg_msg
4669: ( p_old_message_code => l_err_stage
4670: ,p_msg_attribute => 'CHANGE'
4671: ,p_resize_flag => 'N'
4672: ,p_msg_context => 'BUDG'

Line 4691: pa_interface_utils_pub.map_new_amg_msg

4687: IF l_err_code = -1 --special handling of duplicate line error
4688: THEN
4689: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4690: THEN
4691: pa_interface_utils_pub.map_new_amg_msg
4692: ( p_old_message_code => 'PA_BUDGET_LINE_ALREADY_EXISTS'
4693: ,p_msg_attribute => 'CHANGE'
4694: ,p_resize_flag => 'Y'
4695: ,p_msg_context => 'BUDG'

Line 6279: pa_interface_utils_pub.map_new_amg_msg

6275: p_err_stack => l_err_stack );
6276:
6277: IF l_err_code <> 0 THEN
6278: IF NOT pa_project_pvt.check_valid_message(l_err_stage) THEN
6279: pa_interface_utils_pub.map_new_amg_msg
6280: ( p_old_message_code => 'PA_NO_UNCATEGORIZED_LIST'
6281: ,p_msg_attribute => 'CHANGE'
6282: ,p_resize_flag => 'N'
6283: ,p_msg_context => 'BUDG'

Line 6290: pa_interface_utils_pub.map_new_amg_msg

6286: ,p_attribute3 => p_budget_type_code
6287: ,p_attribute4 => ''
6288: ,p_attribute5 => '');
6289: ELSE
6290: pa_interface_utils_pub.map_new_amg_msg
6291: ( p_old_message_code => l_err_stage
6292: ,p_msg_attribute => 'CHANGE'
6293: ,p_resize_flag => 'N'
6294: ,p_msg_context => 'BUDG'

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

6413:
6414:
6415: /* Bug 3218822 - PM_PRODUCT_CODE could be Null. We need valid it if it is NOT NULL */
6416:
6417: IF px_budget_lines_in(i).pm_product_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6418: OR px_budget_lines_in(i).pm_product_code IS NOT NULL
6419: THEN
6420:
6421: /* Validating as done in bug# 2413400 */

Line 6429: pa_interface_utils_pub.map_new_amg_msg

6425: IF l_pm_product_code <> 'X'
6426: THEN
6427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6428: THEN
6429: pa_interface_utils_pub.map_new_amg_msg
6430: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
6431: ,p_msg_attribute => 'CHANGE'
6432: ,p_resize_flag => 'N'
6433: ,p_msg_context => 'GENERAL'

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

6486: --pa_task_id or pm_task_reference. The rule is pa_task_id is honoured if both are passed to the API
6487: --otherwise whichever value is passed that value is honoured by the API.
6488: --Also note while preparing the index we are prepending 'TSKID' or 'TSKREF' before the actual values.
6489: --The index would always be in this format.
6490: IF(px_budget_lines_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND
6491: px_budget_lines_in(i).pa_task_id is not null)
6492: THEN
6493: --Prepending the word 'TSKID' before the pa_task_id value while preparing the index.
6494: l_distinct_tskid_idx := 'TSKID' || px_budget_lines_in(i).pa_task_id;

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

6491: px_budget_lines_in(i).pa_task_id is not null)
6492: THEN
6493: --Prepending the word 'TSKID' before the pa_task_id value while preparing the index.
6494: l_distinct_tskid_idx := 'TSKID' || px_budget_lines_in(i).pa_task_id;
6495: ELSIF( px_budget_lines_in(i).pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
6496: px_budget_lines_in(i).pm_task_reference is not null)
6497: THEN
6498: --Prepending the word 'TSKREF' before the pm_task_reference value while preparing the index.
6499: l_distinct_tskid_idx := 'TSKREF' || px_budget_lines_in(i).pm_task_reference;

Line 6578: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg

6574: -- get the task number. This task number is required as input to map_new_amg_msg API.
6575:
6576: IF px_budget_lines_in(i).pa_task_id <> 0 THEN
6577:
6578: l_amg_task_number := pa_interface_utils_pub.get_task_number_amg
6579: ( p_task_number=> ''
6580: ,p_task_reference => px_budget_lines_in(i).pm_task_reference
6581: ,p_task_id => px_budget_lines_in(i).pa_task_id);
6582: /* Bug 3124283: Added substr below */

Line 6597: pa_interface_utils_pub.map_new_amg_msg

6593:
6594: IF p_entry_level_code = 'T' THEN -- then check whether it is top task
6595: 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
6596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6597: pa_interface_utils_pub.map_new_amg_msg
6598: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6599: ,p_msg_attribute => 'CHANGE'
6600: ,p_resize_flag => 'N'
6601: ,p_msg_context => 'TASK'

Line 6622: pa_interface_utils_pub.map_new_amg_msg

6618: px_budget_lines_in(i).pa_task_id);
6619: IF l_return_status_task <> 0 THEN
6620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6621: THEN
6622: pa_interface_utils_pub.map_new_amg_msg
6623: ( p_old_message_code => 'PA_TASK_IS_NOT_LOWEST'
6624: ,p_msg_attribute => 'CHANGE'
6625: ,p_resize_flag => 'N'
6626: ,p_msg_context => 'TASK'

Line 6660: pa_interface_utils_pub.map_new_amg_msg

6656: , px_budget_lines_in(i).pa_task_id);
6657: IF l_return_status_task <> 0 THEN
6658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6659: THEN
6660: pa_interface_utils_pub.map_new_amg_msg
6661: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP_OR_LOWEST'
6662: ,p_msg_attribute => 'CHANGE'
6663: ,p_resize_flag => 'Y'
6664: ,p_msg_context => 'TASK'

Line 6702: l_amg_top_task_number := pa_interface_utils_pub.get_task_number_amg

6698:
6699: IF (l_temp IS NOT NULL) THEN
6700: IF l_top_task_planning_level <> l_top_tasks_tbl(l_temp).value THEN
6701:
6702: l_amg_top_task_number := pa_interface_utils_pub.get_task_number_amg
6703: ( p_task_number=> ''
6704: ,p_task_reference => NULL
6705: ,p_task_id => l_top_task_id);
6706:

Line 6754: pa_interface_utils_pub.map_new_amg_msg

6750: l_webadi_err_amt_type_tbl.extend(1);
6751: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
6752: ELSE
6753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6754: pa_interface_utils_pub.map_new_amg_msg
6755: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6756: ,p_msg_attribute => 'CHANGE'
6757: ,p_resize_flag => 'N'
6758: ,p_msg_context => 'TASK'

Line 6786: px_budget_lines_in(i).cbs_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

6782: --Bug 16604257 : CBS RBS Phase 2 API changes
6783: IF l_cbs_enabled_project = 'Y' THEN
6784:
6785: IF px_budget_lines_in(i).cbs_element_id IS NULL OR
6786: px_budget_lines_in(i).cbs_element_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
6787:
6788: px_budget_lines_in(i).cbs_element_id := PA_ALTERNATE_TASK_PVT.convert_cost_code_to_id(
6789: px_budget_lines_in(i).cost_code ,p_pa_project_id );
6790: END IF;

Line 6793: px_budget_lines_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

6789: px_budget_lines_in(i).cost_code ,p_pa_project_id );
6790: END IF;
6791:
6792: IF px_budget_lines_in(i).cbs_element_id IS NOT NULL AND
6793: px_budget_lines_in(i).cbs_element_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
6794:
6795: PA_ALTERNATE_TASK_PVT.Is_Cost_Element_Valid(
6796: p_Cbs_Element_Id =>px_budget_lines_in(i).cbs_element_id,
6797: p_Task_Id =>px_budget_lines_in(i).pa_task_id,

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

7077: --is not uncategorized
7078: IF (nvl(l_uncategorized_res_list_id,-99) = p_resource_list_id) THEN
7079:
7080: px_budget_lines_in(i).resource_list_member_id :=l_uncategorized_rlmid;
7081: px_budget_lines_in(i).resource_alias := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
7082:
7083: IF p_calling_context = 'UPDATE_PLANNING_ELEMENT_ATTR' then
7084: l_valid_rlmid := 'Y';
7085: END IF ;

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

7091: -- and resource member is (passed and not NULL)
7092: -- then we convert the alias to the id
7093: -- else we default to the uncategorized resource member
7094:
7095: IF (px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7096: AND px_budget_lines_in(i).resource_alias IS NOT NULL)
7097: OR (px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7098: AND px_budget_lines_in(i).resource_list_member_id IS NOT NULL)
7099: THEN

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

7093: -- else we default to the uncategorized resource member
7094:
7095: IF (px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7096: AND px_budget_lines_in(i).resource_alias IS NOT NULL)
7097: OR (px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7098: AND px_budget_lines_in(i).resource_list_member_id IS NOT NULL)
7099: THEN
7100:
7101: --Selecting the index if it will be based on rlm_id or resource_alias. This index is decided on the

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

7107:
7108: --Also didnt included the null check in below if's to decide the index because it has already been
7109: --taken care of in the last if before this. See above. We wont reach here if any one of rlm_id or
7110: --resource_alias is null
7111: IF(px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
7112: THEN
7113: --Prepending the word 'RLMID' before the rlm_id value while preparing the index.
7114: l_distinct_rlmid_idx := 'RLMID' || px_budget_lines_in(i).resource_list_member_id;
7115: ELSIF( px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

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

7111: IF(px_budget_lines_in(i).resource_list_member_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
7112: THEN
7113: --Prepending the word 'RLMID' before the rlm_id value while preparing the index.
7114: l_distinct_rlmid_idx := 'RLMID' || px_budget_lines_in(i).resource_list_member_id;
7115: ELSIF( px_budget_lines_in(i).resource_alias <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
7116: THEN
7117: --Prepending the word 'RALIAS' before the reasource_alias value while preparing the index.
7118: l_distinct_rlmid_idx := 'RALIAS' || px_budget_lines_in(i).resource_alias;
7119: END IF;

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

7140: THEN
7141: -- Initialise valid rlmid variable to Y
7142: l_valid_rlmid := 'Y';
7143: IF((p_budget_type_code IS NOT NULL) AND
7144: (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN -- Old Bugdets Model -- Bug 3801891
7145: --get unit_of_measure and track_as_labor_flag associated to
7146: --the resource member and check whether this is a valid member for this list
7147: OPEN l_resource_csr( px_budget_lines_in(i).resource_list_member_id
7148: ,p_resource_list_id );

Line 7154: pa_interface_utils_pub.map_new_amg_msg

7150: IF l_resource_csr%NOTFOUND THEN
7151: l_context_info := p_budget_type_code;
7152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7153: THEN
7154: pa_interface_utils_pub.map_new_amg_msg
7155: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7156: ,p_msg_attribute => 'CHANGE'
7157: ,p_resize_flag => 'N'
7158: ,p_msg_context => 'BUDG'

Line 7207: pa_interface_utils_pub.map_new_amg_msg

7203: l_webadi_err_amt_type_tbl.extend(1);
7204: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
7205: ELSE
7206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7207: pa_interface_utils_pub.map_new_amg_msg
7208: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7209: ,p_msg_attribute => 'CHANGE'
7210: ,p_resize_flag => 'N'
7211: ,p_msg_context => 'BUDG'

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

7253:
7254: END IF; -- Bug 3801891
7255:
7256: IF((p_budget_type_code IS NOT NULL) AND
7257: (p_budget_type_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN -- 4504585 For old budget model only
7258:
7259: IF l_valid_rlmid='Y' THEN
7260:
7261: SELECT parent_member_id

Line 7354: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

7350: END IF; --IF( NOT(l_rlm_id_tbl.exists(l_distinct_rlmid_idx) ) )
7351:
7352: ELSE
7353: IF (p_budget_type_code IS NULL OR
7354: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
7355: l_context_info := l_fin_plan_type_name;
7356: ELSE
7357: l_context_info := p_budget_type_code;
7358: END IF;

Line 7361: pa_interface_utils_pub.map_new_amg_msg

7357: l_context_info := p_budget_type_code;
7358: END IF;
7359:
7360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7361: pa_interface_utils_pub.map_new_amg_msg
7362: ( p_old_message_code => 'PA_RESOURCE_IS_MISSING'
7363: ,p_msg_attribute => 'CHANGE'
7364: ,p_resize_flag => 'N'
7365: ,p_msg_context => 'BUDG'

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

7785: THEN
7786: --Validate the change reason code. This validation is added for Fin plan model in FP L
7787: IF (px_budget_lines_in(i).change_reason_code IS NOT NULL AND
7788: ((p_calling_context = 'WEBADI' AND px_budget_lines_in(i).change_reason_code <> FND_API.G_MISS_CHAR) OR
7789: (p_calling_context <> 'WEBADI' AND px_budget_lines_in(i).change_reason_code <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))) THEN
7790:
7791: OPEN l_budget_change_reason_csr( px_budget_lines_in(i).change_reason_code );
7792: FETCH l_budget_change_reason_csr INTO l_dummy;
7793: IF l_budget_change_reason_csr%NOTFOUND THEN

Line 7798: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

7794: CLOSE l_budget_change_reason_csr;
7795:
7796: IF p_calling_context <> 'WEBADI' THEN
7797: IF (p_budget_type_code IS NULL OR
7798: p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
7799:
7800: l_context_info := l_fin_plan_type_name;
7801: /* Bug 3133930- set the return status to the new output variable */
7802: x_budget_lines_out(i).return_status := x_return_status;

Line 8606: PA_INTERFACE_UTILS_PUB.get_messages

8602:
8603: l_msg_count := FND_MSG_PUB.count_msg;
8604:
8605: IF l_msg_count = 1 and x_msg_data IS NULL THEN
8606: PA_INTERFACE_UTILS_PUB.get_messages
8607: (p_encoded => FND_API.G_TRUE
8608: ,p_msg_index => 1
8609: ,p_msg_count => l_msg_count
8610: ,p_msg_data => l_msg_data