DBA Data[Home] [Help]

APPS.PA_COST dependencies on PA_CC_UTILS

Line 110: pa_cc_utils.log_message('p_person_id = '||p_person_id||' P_Item_date = '||to_char(trunc(P_Item_date),'DD-MON-YY'));

106:
107: l_expend_organization_id := P_expend_organization_id;
108: l_exp_org_id := P_expenditure_org_id; /*2879644*/
109:
110: pa_cc_utils.log_message('p_person_id = '||p_person_id||' P_Item_date = '||to_char(trunc(P_Item_date),'DD-MON-YY'));
111: pa_cc_utils.log_message('l_expend_organization_id = '||l_expend_organization_id||' l_exp_org_id = '||l_exp_org_id);
112:
113: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>P_person_id
114: ,p_txn_date =>P_Item_date

Line 111: pa_cc_utils.log_message('l_expend_organization_id = '||l_expend_organization_id||' l_exp_org_id = '||l_exp_org_id);

107: l_expend_organization_id := P_expend_organization_id;
108: l_exp_org_id := P_expenditure_org_id; /*2879644*/
109:
110: pa_cc_utils.log_message('p_person_id = '||p_person_id||' P_Item_date = '||to_char(trunc(P_Item_date),'DD-MON-YY'));
111: pa_cc_utils.log_message('l_expend_organization_id = '||l_expend_organization_id||' l_exp_org_id = '||l_exp_org_id);
112:
113: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>P_person_id
114: ,p_txn_date =>P_Item_date
115: ,p_calling_module =>'STAFFED'

Line 136: pa_cc_utils.log_message('Error Occured in stage'||l_err_stage||' with err code '||l_err_code);

132: ,x_err_code =>l_err_code
133: );
134:
135: If l_err_code is NOT NULL THEN
136: pa_cc_utils.log_message('Error Occured in stage'||l_err_stage||' with err code '||l_err_code);
137: pa_cc_utils.log_message('Error '||SQLERRM);
138: RAISE user_exception;
139: END IF;
140:

Line 137: pa_cc_utils.log_message('Error '||SQLERRM);

133: );
134:
135: If l_err_code is NOT NULL THEN
136: pa_cc_utils.log_message('Error Occured in stage'||l_err_stage||' with err code '||l_err_code);
137: pa_cc_utils.log_message('Error '||SQLERRM);
138: RAISE user_exception;
139: END IF;
140:
141: pa_cc_utils.log_message('Converting from transaction currency to functional currency');

Line 141: pa_cc_utils.log_message('Converting from transaction currency to functional currency');

137: pa_cc_utils.log_message('Error '||SQLERRM);
138: RAISE user_exception;
139: END IF;
140:
141: pa_cc_utils.log_message('Converting from transaction currency to functional currency');
142: -- Get the Functional Currency code
143: ----------------------------------------------------------------------
144: -- If Input expenditure functional currency code is null then call the
145: -- procedure get_curr_code to get the currency code

Line 155: pa_cc_utils.log_message('px_exp_func_curr_code '||px_exp_func_curr_code);

151: px_exp_func_curr_code := get_curr_code(p_expenditure_org_id);
152:
153: END IF;
154:
155: pa_cc_utils.log_message('px_exp_func_curr_code '||px_exp_func_curr_code);
156:
157: IF (px_exp_func_curr_code IS NULL) THEN
158:
159: RAISE l_exp_func_curr_code_null;

Line 163: pa_cc_utils.log_message('l_cost_rate_curr_code '||l_cost_rate_curr_code);

159: RAISE l_exp_func_curr_code_null;
160:
161: END IF;
162:
163: pa_cc_utils.log_message('l_cost_rate_curr_code '||l_cost_rate_curr_code);
164:
165: --Check if the denom and functional currencies are different
166:
167: IF px_exp_func_curr_code <> l_cost_rate_curr_code THEN

Line 171: pa_cc_utils.log_message('Before calling pa_multi_currency.convert_amount'); -- Bug 7423839

167: IF px_exp_func_curr_code <> l_cost_rate_curr_code THEN
168:
169: l_conversion_date := P_Item_date;
170:
171: pa_cc_utils.log_message('Before calling pa_multi_currency.convert_amount'); -- Bug 7423839
172:
173: begin
174: pa_multi_currency.convert_amount( P_from_currency =>l_cost_rate_curr_code,
175: P_to_currency =>px_exp_func_curr_code,

Line 188: pa_cc_utils.log_message('Inside when others exception '||substr(SQLERRM,1,300));

184: P_rate =>l_acct_exch_rate,
185: X_status =>l_err_code ) ;
186: exception
187: when others then
188: pa_cc_utils.log_message('Inside when others exception '||substr(SQLERRM,1,300));
189: RAISE;
190: end;
191:
192: IF l_err_code is NOT NULL THEN

Line 193: pa_cc_utils.log_message('Error occured in conversion stage '||l_err_code);

189: RAISE;
190: end;
191:
192: IF l_err_code is NOT NULL THEN
193: pa_cc_utils.log_message('Error occured in conversion stage '||l_err_code);
194: RAISE user_exception;
195: END IF;
196: ELSE
197: pa_cc_utils.log_message('l_acct_cost_rate '||l_acct_cost_rate||' l_labor_cost_rate '||l_labor_cost_rate);

Line 197: pa_cc_utils.log_message('l_acct_cost_rate '||l_acct_cost_rate||' l_labor_cost_rate '||l_labor_cost_rate);

193: pa_cc_utils.log_message('Error occured in conversion stage '||l_err_code);
194: RAISE user_exception;
195: END IF;
196: ELSE
197: pa_cc_utils.log_message('l_acct_cost_rate '||l_acct_cost_rate||' l_labor_cost_rate '||l_labor_cost_rate);
198: l_acct_cost_rate := l_labor_cost_rate; /*When denom and functional are same*/
199: END IF;
200: /***End of LCE changes ***/
201:

Line 210: pa_cc_utils.log_message('P_labor_Cost_Mult_Name '||P_labor_Cost_Mult_Name);

206:
207:
208: IF P_labor_Cost_Mult_Name IS NOT NULL THEN
209:
210: pa_cc_utils.log_message('P_labor_Cost_Mult_Name '||P_labor_Cost_Mult_Name);
211:
212: BEGIN
213:
214: SELECT multiplier

Line 226: pa_cc_utils.log_message('l_cost_multiplier '||l_cost_multiplier);

222: WHEN NO_DATA_FOUND THEN
223: l_cost_multiplier := NULL;
224:
225: END;
226: pa_cc_utils.log_message('l_cost_multiplier '||l_cost_multiplier);
227:
228: END IF;
229:
230:

Line 241: pa_cc_utils.log_message('l_x_raw_cost_rate '||l_x_raw_cost_rate||' l_x_Raw_cost '||l_x_Raw_cost);

237:
238: l_x_Raw_cost := pa_currency.round_trans_currency_amt(
239: l_x_raw_cost_rate * NVL(p_quantity,0), px_exp_func_curr_code);
240:
241: pa_cc_utils.log_message('l_x_raw_cost_rate '||l_x_raw_cost_rate||' l_x_Raw_cost '||l_x_Raw_cost);
242:
243: -------------------------------------------------
244: -- Checking If Calculated raw cost is null or not
245: -------------------------------------------------

Line 272: pa_cc_utils.log_message('inside l_exp_func_curr_code_null exception ');

268:
269:
270: EXCEPTION
271: WHEN l_exp_func_curr_code_null THEN
272: pa_cc_utils.log_message('inside l_exp_func_curr_code_null exception ');
273: /* Checking error condition. Added for bug 2218386 */
274: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
275: PA_UTILS.add_message('PA', 'PA_FCST_EXP_CURR_CODE_NULL');
276: END IF;

Line 282: pa_cc_utils.log_message('inside NO_DATA_FOUND exception ');

278: x_msg_count := 1;
279: x_msg_data := 'PA_FCST_EXP_CURR_CODE_NULL';
280:
281: WHEN NO_DATA_FOUND THEN
282: pa_cc_utils.log_message('inside NO_DATA_FOUND exception ');
283:
284: x_raw_cost_rate := 0;
285: x_raw_cost := 0;
286: /* Checking error condition. Added for bug 2218386 */

Line 295: pa_cc_utils.log_message('inside l_raw_cost_null exception ');

291: x_msg_count := 1;
292: x_msg_data := 'PA_FCST_NO_COST_RATE';
293:
294: WHEN l_raw_cost_null THEN
295: pa_cc_utils.log_message('inside l_raw_cost_null exception ');
296:
297: x_raw_cost_rate := 0;
298: x_raw_cost := 0;
299: /* Checking error condition. Added for bug 2218386 */

Line 309: pa_cc_utils.log_message('inside user_exception exception ');

305: x_msg_data := 'PA_FCST_NO_COST_RATE';
306:
307: /*LCE changes*/
308: WHEN user_exception THEN
309: pa_cc_utils.log_message('inside user_exception exception ');
310:
311: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
312: PA_UTILS.add_message('PA',l_err_code);
313: END IF;

Line 320: pa_cc_utils.log_message('inside others exception '||SUBSTR(SQLERRM,1,300));

316: x_msg_data := l_err_code;
317: /*End of LCE changes*/
318:
319: WHEN OTHERS THEN
320: pa_cc_utils.log_message('inside others exception '||SUBSTR(SQLERRM,1,300));
321:
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: x_msg_count := 1;
324: x_msg_data := SUBSTR(SQLERRM,1,30);

Line 2189: pa_cc_utils.log_message('Error Occured in stage'||l_err_stage);

2185: ']l_err_stage['||l_err_stage||']l_err_code['||l_err_code||']');
2186:
2187:
2188: IF l_err_code is NOT NULL THEN
2189: pa_cc_utils.log_message('Error Occured in stage'||l_err_stage);
2190: RAISE user_exception;
2191: END IF;
2192:
2193: pa_cc_utils.log_message('Converting from transaction currency to functional currency');

Line 2193: pa_cc_utils.log_message('Converting from transaction currency to functional currency');

2189: pa_cc_utils.log_message('Error Occured in stage'||l_err_stage);
2190: RAISE user_exception;
2191: END IF;
2192:
2193: pa_cc_utils.log_message('Converting from transaction currency to functional currency');
2194: -- Get the Functional Currency code
2195:
2196: l_acct_currency_code := get_curr_code(p_org_id);
2197:

Line 2232: pa_cc_utils.log_message('Error occured in conversion stage');

2228: ']l_acct_exch_rate['||l_acct_exch_rate||']l_err_code['||l_err_code||
2229: ']l_x_raw_cost_rate['||l_x_raw_cost_rate||']');
2230:
2231: IF l_err_code is NOT NULL THEN
2232: pa_cc_utils.log_message('Error occured in conversion stage');
2233: RAISE user_exception;
2234: END IF;
2235:
2236: ELSE