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

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

44: (
45: p_api_version_number IN NUMBER := 1.0
46: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
47: , p_commit IN VARCHAR2 := FND_API.G_FALSE
48: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: , p_update_plan_type IN VARCHAR2
52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

45: p_api_version_number IN NUMBER := 1.0
46: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
47: , p_commit IN VARCHAR2 := FND_API.G_FALSE
48: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: , p_update_plan_type IN VARCHAR2
52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 50: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

46: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
47: , p_commit IN VARCHAR2 := FND_API.G_FALSE
48: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: , p_update_plan_type IN VARCHAR2
52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: , p_version_type IN PA_BUDGET_VERSIONS.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

48: , p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: , p_update_plan_type IN VARCHAR2
52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: , p_version_type IN PA_BUDGET_VERSIONS.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: , p_finplan_type_id IN PA_BUDGET_VERSIONS.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_finplan_type_name IN PA_FIN_PLAN_TYPES_VL.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

49: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
50: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: , p_update_plan_type IN VARCHAR2
52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: , p_version_type IN PA_BUDGET_VERSIONS.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: , p_finplan_type_id IN PA_BUDGET_VERSIONS.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_finplan_type_name IN PA_FIN_PLAN_TYPES_VL.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 54: , p_version_type IN PA_BUDGET_VERSIONS.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

50: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51: , p_update_plan_type IN VARCHAR2
52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: , p_version_type IN PA_BUDGET_VERSIONS.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: , p_finplan_type_id IN PA_BUDGET_VERSIONS.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_finplan_type_name IN PA_FIN_PLAN_TYPES_VL.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
58: , p_resource_asgn_id_tab IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

Line 55: , p_finplan_type_id IN PA_BUDGET_VERSIONS.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

51: , p_update_plan_type IN VARCHAR2
52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: , p_version_type IN PA_BUDGET_VERSIONS.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: , p_finplan_type_id IN PA_BUDGET_VERSIONS.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_finplan_type_name IN PA_FIN_PLAN_TYPES_VL.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
58: , p_resource_asgn_id_tab IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
59: , p_txn_curr_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE()

Line 56: , p_finplan_type_name IN PA_FIN_PLAN_TYPES_VL.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

52: , p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: , p_budget_version_number IN PA_BUDGET_VERSIONS.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
54: , p_version_type IN PA_BUDGET_VERSIONS.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55: , p_finplan_type_id IN PA_BUDGET_VERSIONS.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_finplan_type_name IN PA_FIN_PLAN_TYPES_VL.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_resource_class_code_tab IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
58: , p_resource_asgn_id_tab IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
59: , p_txn_curr_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
60: , p_refresh_cost_bill_rates_flag IN VARCHAR2 := 'N'

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

58: , p_resource_asgn_id_tab IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
59: , p_txn_curr_code_tab IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
60: , p_refresh_cost_bill_rates_flag IN VARCHAR2 := 'N'
61: , p_refresh_conv_rates_flag IN VARCHAR2 := 'N'
62: , p_budget_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
63: , x_return_status OUT VARCHAR2
64: , x_msg_count OUT NUMBER
65: , x_msg_data OUT VARCHAR2
66: )

Line 94: l_budget_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

90: l_plan_in_multi_curr_flag VARCHAR2(1);
91: l_budget_amount_code VARCHAR2(30);
92: l_categorization_code VARCHAR2(30);
93: l_project_number VARCHAR2(25);
94: l_budget_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
95: l_change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
96:
97: l_txn_curr_passed_flag VARCHAR2(1) := 'N';
98: l_resource_asgn_id NUMBER := null;

Line 95: l_change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

91: l_budget_amount_code VARCHAR2(30);
92: l_categorization_code VARCHAR2(30);
93: l_project_number VARCHAR2(25);
94: l_budget_type_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
95: l_change_reason_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
96:
97: l_txn_curr_passed_flag VARCHAR2(1) := 'N';
98: l_resource_asgn_id NUMBER := null;
99: l_valid VARCHAR2(1) := 'X';

Line 113: l_pa_miss_char varchar2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

109: l_debug_level3 CONSTANT NUMBER := 3;
110: l_debug_level4 CONSTANT NUMBER := 4;
111: l_debug_level5 CONSTANT NUMBER := 5;
112: --Added for bug 6378555 to pass G_PA_MISS_CHAR
113: l_pa_miss_char varchar2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
114:
115: CURSOR c_validate_res_asgn_id
116: ( l_project_id NUMBER , l_budget_version_id NUMBER
117: , l_resource_assignment_id NUMBER

Line 245: IF ( ( p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND

241: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
242: l_debug_level3);
243: END IF;
244:
245: IF ( ( p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
246: ( p_pm_project_reference IS NULL
247: OR p_pm_project_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
248: )
249: THEN

Line 247: OR p_pm_project_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )

243: END IF;
244:
245: IF ( ( p_project_id IS NULL OR p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
246: ( p_pm_project_reference IS NULL
247: OR p_pm_project_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
248: )
249: THEN
250: IF l_debug_mode = 'Y' THEN
251: Pa_Debug.g_err_stage := 'PA_FP_CALC_PLAN_PUB : REFRESH_RATES : Both Project_id and Project_reference are null';

Line 275: ( p_structure_version_id is null or p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND

271: RAISE Invalid_Arg_Exc_WP;
272: END IF;
273:
274: IF ( p_update_plan_type = 'WORKPLAN' AND
275: ( p_structure_version_id is null or p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
276: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
277: ) THEN
278: IF l_debug_mode = 'Y' THEN
279: Pa_Debug.g_err_stage:= 'PA_FP_CALC_PLAN_PUB : REFRESH_RATES : p_update_plan_type is WORKPLAN but str version id is not passed';

Line 276: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

272: END IF;
273:
274: IF ( p_update_plan_type = 'WORKPLAN' AND
275: ( p_structure_version_id is null or p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
276: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
277: ) THEN
278: IF l_debug_mode = 'Y' THEN
279: Pa_Debug.g_err_stage:= 'PA_FP_CALC_PLAN_PUB : REFRESH_RATES : p_update_plan_type is WORKPLAN but str version id is not passed';
280: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);

Line 282: pa_interface_utils_pub.map_new_amg_msg

278: IF l_debug_mode = 'Y' THEN
279: Pa_Debug.g_err_stage:= 'PA_FP_CALC_PLAN_PUB : REFRESH_RATES : p_update_plan_type is WORKPLAN but str version id is not passed';
280: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
281: END IF;
282: pa_interface_utils_pub.map_new_amg_msg
283: ( p_old_message_code => 'PA_PS_STRUC_BV_VER_REQ'
284: ,p_msg_attribute => 'CHANGE'
285: ,p_resize_flag => 'N'
286: ,p_msg_context => 'GENERAL'

Line 297: ( p_budget_version_number is null or p_budget_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND

293: END IF;
294:
295: IF ( p_update_plan_type = 'FINPLAN' AND
296: (
297: ( p_budget_version_number is null or p_budget_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
298: ( p_finplan_type_id is null or p_finplan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
299: ( p_finplan_type_name is null or p_finplan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ) AND
301: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

Line 298: ( p_finplan_type_id is null or p_finplan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND

294:
295: IF ( p_update_plan_type = 'FINPLAN' AND
296: (
297: ( p_budget_version_number is null or p_budget_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
298: ( p_finplan_type_id is null or p_finplan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
299: ( p_finplan_type_name is null or p_finplan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ) AND
301: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
302: ) THEN

Line 299: ( p_finplan_type_name is null or p_finplan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)

295: IF ( p_update_plan_type = 'FINPLAN' AND
296: (
297: ( p_budget_version_number is null or p_budget_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
298: ( p_finplan_type_id is null or p_finplan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
299: ( p_finplan_type_name is null or p_finplan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ) AND
301: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
302: ) THEN
303: IF l_debug_mode = 'Y' THEN

Line 301: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

297: ( p_budget_version_number is null or p_budget_version_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
298: ( p_finplan_type_id is null or p_finplan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND
299: ( p_finplan_type_name is null or p_finplan_type_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
300: ) AND
301: ( p_budget_version_id is null or p_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
302: ) THEN
303: IF l_debug_mode = 'Y' THEN
304: Pa_Debug.g_err_stage:= 'PA_FP_CALC_PLAN_PUB : REFRESH_RATES : p_update_plan_type is FINPLAN but params not passed';
305: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);

Line 344: IF ( p_budget_version_id is not null AND p_budget_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) THEN

340:
341: --Invoke check_edit_task_ok
342: IF (p_update_plan_type = 'WORKPLAN') THEN
343:
344: IF ( p_budget_version_id is not null AND p_budget_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) THEN
345: l_budget_version_id := p_budget_version_id;
346: ELSE
347: l_budget_version_id := null;
348: END IF;

Line 383: IF (p_budget_version_id is not null and p_budget_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN

379: RAISE FND_API.G_EXC_ERROR;
380: END IF;
381:
382: ELSIF (p_update_plan_type = 'FINPLAN') THEN
383: IF (p_budget_version_id is not null and p_budget_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
384: OPEN C_VALIDATE_FP_BUDGET_VERSION(p_budget_version_id, l_project_id);
385: FETCH C_VALIDATE_FP_BUDGET_VERSION INTO l_finplan_type_id, l_version_type, l_budget_version_number;
386: IF (C_VALIDATE_FP_BUDGET_VERSION%NOTFOUND) THEN
387: PA_UTILS.ADD_MESSAGE(

Line 498: p_txn_curr_code_tab(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

494: CLOSE c_validate_res_asgn_id;
495:
496: IF ( l_txn_curr_passed_flag = 'Y') THEN
497: IF ( p_txn_curr_code_tab(i) IS NULL OR
498: p_txn_curr_code_tab(i) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
499: /*--Raise Error
500: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
501: p_msg_name => 'PA_PASS_TXN_CURR_CODE');
502: RAISE FND_API.G_EXC_ERROR;*/

Line 687: Pa_Interface_Utils_Pub.get_messages

683: END IF;
684:
685: IF l_msg_count = 1 AND x_msg_data IS NULL
686: THEN
687: Pa_Interface_Utils_Pub.get_messages
688: ( p_encoded => Fnd_Api.G_TRUE
689: , p_msg_index => 1
690: , p_msg_count => l_msg_count
691: , p_msg_data => l_msg_data