APPS.PA_FP_FCST_GEN_AMT_UTILS dependencies on PA_FP_GEN_AMOUNT_UTILS

Line 60: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

56: l_msg_data VARCHAR2(1000);
57: l_msg_index_out NUMBER;
58:
59: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
60: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
61: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
62: BEGIN
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64: x_msg_count := 0;

Line 61: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

57: l_msg_index_out NUMBER;
58:
59: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;
60: l_fp_cols_rec_target PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
61: l_fp_cols_rec_src PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
62: BEGIN
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64: x_msg_count := 0;
65:

Line 99: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

95: END IF;
96:
97: /* CAll API to get Target data into l_fp_cols_rec_target. */
98: IF p_pa_debug_mode = 'Y' THEN
99: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
100: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
101: p_module_name => l_module_name,
102: p_log_level => l_log_level );
103: END IF;

Line 100: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

96:
97: /* CAll API to get Target data into l_fp_cols_rec_target. */
98: IF p_pa_debug_mode = 'Y' THEN
99: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
100: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
101: p_module_name => l_module_name,
102: p_log_level => l_log_level );
103: END IF;
104: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,

Line 104: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,

100: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
101: p_module_name => l_module_name,
102: p_log_level => l_log_level );
103: END IF;
104: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,
105: p_budget_version_id => p_fp_target_plan_ver_id,
106: x_fp_cols_rec => l_fp_cols_rec_target,
107: x_return_status => x_return_status,
108: x_msg_count => x_msg_count,

Line 111: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

107: x_return_status => x_return_status,
108: x_msg_count => x_msg_count,
109: x_msg_data => x_msg_data );
110: IF p_pa_debug_mode = 'Y' THEN
111: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
112: ( p_msg => 'Status after calling
113: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
114: || x_return_status,
115: p_module_name => l_module_name,

Line 113: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

109: x_msg_data => x_msg_data );
110: IF p_pa_debug_mode = 'Y' THEN
111: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
112: ( p_msg => 'Status after calling
113: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
114: || x_return_status,
115: p_module_name => l_module_name,
116: p_log_level => l_log_level );
117: END IF;

Line 130: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

126: IF p_wp_src_plan_ver_id IS NOT NULL THEN
127:
128: /* CAll API to get Source data into l_fp_cols_rec_src */
129: IF p_pa_debug_mode = 'Y' THEN
130: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
131: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
132: p_module_name => l_module_name,
133: p_log_level => l_log_level );
134: END IF;

Line 131: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

127:
128: /* CAll API to get Source data into l_fp_cols_rec_src */
129: IF p_pa_debug_mode = 'Y' THEN
130: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
131: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
132: p_module_name => l_module_name,
133: p_log_level => l_log_level );
134: END IF;
135: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,

Line 135: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,

131: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
132: p_module_name => l_module_name,
133: p_log_level => l_log_level );
134: END IF;
135: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,
136: p_budget_version_id => p_wp_src_plan_ver_id,
137: x_fp_cols_rec => l_fp_cols_rec_src,
138: x_return_status => x_return_status,
139: x_msg_count => x_msg_count,

Line 142: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

138: x_return_status => x_return_status,
139: x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data );
141: IF p_pa_debug_mode = 'Y' THEN
142: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
143: ( p_msg => 'Status after calling
144: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
145: || x_return_status,
146: p_module_name => l_module_name,

Line 144: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

140: x_msg_data => x_msg_data );
141: IF p_pa_debug_mode = 'Y' THEN
142: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
143: ( p_msg => 'Status after calling
144: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
145: || x_return_status,
146: p_module_name => l_module_name,
147: p_log_level => l_log_level );
148: END IF;

Line 175: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

171: IF p_fp_src_plan_ver_id IS NOT NULL THEN
172:
173: /* CAll API to get Source data into l_fp_cols_rec_src */
174: IF p_pa_debug_mode = 'Y' THEN
175: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
176: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
177: p_module_name => l_module_name,
178: p_log_level => l_log_level );
179: END IF;

Line 176: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',

172:
173: /* CAll API to get Source data into l_fp_cols_rec_src */
174: IF p_pa_debug_mode = 'Y' THEN
175: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
176: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
177: p_module_name => l_module_name,
178: p_log_level => l_log_level );
179: END IF;
180: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,

Line 180: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,

176: ( p_msg => 'Before calling PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS',
177: p_module_name => l_module_name,
178: p_log_level => l_log_level );
179: END IF;
180: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS( p_project_id => p_project_id,
181: p_budget_version_id => p_fp_src_plan_ver_id,
182: x_fp_cols_rec => l_fp_cols_rec_src,
183: x_return_status => x_return_status,
184: x_msg_count => x_msg_count,

Line 187: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

183: x_return_status => x_return_status,
184: x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data );
186: IF p_pa_debug_mode = 'Y' THEN
187: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
188: ( p_msg => 'Status after calling
189: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
190: || x_return_status,
191: p_module_name => l_module_name,

Line 189: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '

185: x_msg_data => x_msg_data );
186: IF p_pa_debug_mode = 'Y' THEN
187: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
188: ( p_msg => 'Status after calling
189: PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DTLS: '
190: || x_return_status,
191: p_module_name => l_module_name,
192: p_log_level => l_log_level );
193: END IF;

Line 235: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

231: ROLLBACK;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: IF p_pa_debug_mode = 'Y' THEN
235: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
236: ( p_msg => 'Invalid Arguments Passed',
237: p_module_name => l_module_name,
238: p_log_level => l_log_level );
239: PA_DEBUG.RESET_CURR_FUNCTION;

Line 253: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

249: p_procedure_name => 'COMPARE_ETC_SRC_TARGET_FP_OPT',
250: p_error_text => substr(sqlerrm,1,240) );
251:
252: IF P_PA_DEBUG_MODE = 'Y' THEN
253: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
254: ( p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
255: p_module_name => l_module_name,
256: p_log_level => l_log_level );
257: PA_DEBUG.RESET_CURR_FUNCTION;