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_COST_RATE_PUB dependencies on PA_CC_UTILS

Line 70: if pa_cc_utils.g_debug_mode then

66:
67: begin
68:
69: ----------------- initializaton ------------------------------
70: if pa_cc_utils.g_debug_mode then
71: l_debug_mode := 'Y';
72: else
73: l_debug_mode := 'N';
74: end if;

Line 84: pa_cc_utils.set_curr_function('PA_COST_RATE_PUB.get_labor_rate');

80: IF ( l_debug_mode = 'Y' ) THEN
81: pa_debug.set_process( x_process => 'PLSQL'
82: ,x_debug_mode => l_debug_mode
83: );
84: pa_cc_utils.set_curr_function('PA_COST_RATE_PUB.get_labor_rate');
85: -- pa_cc_utils.log_message('Start ');
86: END IF;
87:
88: l_stage := 'Input person_id [' || to_char(p_person_id) || '] job_id ['

Line 85: -- pa_cc_utils.log_message('Start ');

81: pa_debug.set_process( x_process => 'PLSQL'
82: ,x_debug_mode => l_debug_mode
83: );
84: pa_cc_utils.set_curr_function('PA_COST_RATE_PUB.get_labor_rate');
85: -- pa_cc_utils.log_message('Start ');
86: END IF;
87:
88: l_stage := 'Input person_id [' || to_char(p_person_id) || '] job_id ['
89: || to_char(x_job_id) || '] txn_date ['

Line 93: pa_cc_utils.log_message(l_stage);

89: || to_char(x_job_id) || '] txn_date ['
90: || to_char(p_txn_date) || '] organization_id [' || to_char(x_organization_id) || ']';
91: if ( l_debug_mode = 'Y' )
92: then
93: pa_cc_utils.log_message(l_stage);
94: end if;
95:
96: /* Bug 9913685: If p_org_id is passed through the concurrent program, then that should be assigned to l_curr_org_id. In case
97: it is not passed then it needs to be derived using pa_moac_utils.get_current_org_id. This API would return

Line 116: pa_cc_utils.reset_curr_function;

112: (x_job_id is null or x_organization_id is null ) )
113: then
114: x_err_code := 'NO_JOB_ID' ;
115: /*Bug fix:3089560 Plsql numeric value error causes without resetting stack*/
116: pa_cc_utils.reset_curr_function;
117: return;
118: end if;
119:
120: /*2879644 Commented for bug 7158405

Line 140: pa_cc_utils.log_message(l_stage);

136: then
137: l_stage := 'Selecting Functional Currency, l_curr_org_id: ' || l_curr_org_id ||', p_org_id: ' || p_org_id;
138: if ( l_debug_mode = 'Y' )
139: then
140: pa_cc_utils.log_message(l_stage);
141: end if;
142: select nvl(p_org_id, imp.org_id)
143: ,sob.currency_code
144: into g_ou_id

Line 157: pa_cc_utils.log_message(l_stage);

153:
154: l_stage := 'Org Id [' || to_char(g_ou_id) || '] Func Curr [' || g_func_curr || ']';
155: if ( l_debug_mode = 'Y' )
156: then
157: pa_cc_utils.log_message(l_stage);
158: end if;
159: end if; /* g_func_curr is null */
160:
161: /*====================================================================+

Line 170: pa_cc_utils.log_message(l_stage);

166: then
167: l_stage := 'Selecting Organization and Job Ids';
168: if ( l_debug_mode = 'Y' )
169: then
170: pa_cc_utils.log_message(l_stage);
171: end if;
172:
173: /* cwk changes : Modified stmt to derive the Organization Id, Job Id
174: for a Person Id of a contingent worker also*/

Line 193: pa_cc_utils.log_message(l_stage);

189: exception
190: when no_data_found then
191: l_stage := 'No records found while fetching job id';
192: if ( l_debug_mode = 'Y' ) then
193: pa_cc_utils.log_message(l_stage);
194: end if;
195: end;
196:
197: l_stage := 'Organization Id [' || to_char(x_organization_id) || '] Job Id [' || to_char(x_job_id) || ']';

Line 200: pa_cc_utils.log_message(l_stage);

196:
197: l_stage := 'Organization Id [' || to_char(x_organization_id) || '] Job Id [' || to_char(x_job_id) || ']';
198: if ( l_debug_mode = 'Y' )
199: then
200: pa_cc_utils.log_message(l_stage);
201: end if;
202: end if; /* x_organization_id is null */
203: ----------------- initializaton end ------------------------------
204: /*======================================+

Line 239: pa_cc_utils.reset_curr_function;

235: x_ot_project_id := g_rt_ot_project_id ;
236: x_ot_task_id := g_rt_ot_task_id ;
237: x_err_stage := g_rt_err_stage ;
238: x_err_code := g_rt_err_code ;
239: pa_cc_utils.reset_curr_function;
240: return;
241: end if;
242:
243: if ( p_calling_module <> 'REQUIREMENT' )

Line 252: pa_cc_utils.log_message(l_stage);

248: l_override_flag := 'Y' ;
249: l_stage := 'Selecting Override';
250: if ( l_debug_mode = 'Y' )
251: then
252: pa_cc_utils.log_message(l_stage);
253: end if;
254: begin
255: select detail.compensation_rule_set
256: ,detail.hourly_cost_rate

Line 319: pa_cc_utils.log_message(l_stage);

315: || '] end [' || to_char(x_end_date_active)
316: || ']';
317: if ( l_debug_mode = 'Y' )
318: then
319: pa_cc_utils.log_message(l_stage);
320: end if;
321: /*
322: * If the compensation rule available at the override level
323: * and if the costing method id 'Extension', set rate to null

Line 330: pa_cc_utils.log_message(l_stage);

326: if ( x_costing_rule is not null )
327: then
328: l_stage := 'selecting costing method from rule [' || x_costing_rule || ']';
329: if ( l_debug_mode = 'Y' ) then
330: pa_cc_utils.log_message(l_stage);
331: end if;
332:
333: /* 12.2 payroll intg .. bug 10253400. changes for 12.2:
334: costing method holds 2 values:

Line 344: pa_cc_utils.log_message('l_costing_method '||l_costing_method);

340: from pa_compensation_rule_sets rule
341: where rule.compensation_rule_set = x_costing_rule
342: ;
343: if ( l_debug_mode = 'Y' ) then
344: pa_cc_utils.log_message('l_costing_method '||l_costing_method);
345: end if;
346:
347: -- 12.2 payroll intg .. verify against the rate source
348: --if ( l_costing_method = 'LABOR_COST_EXTN' )

Line 377: pa_cc_utils.log_message(l_stage);

373: '] p_person_id [' || to_char(p_person_id) ||
374: '] x_job_id [' || to_char(x_job_id) || ']';
375: if ( l_debug_mode = 'Y' )
376: then
377: pa_cc_utils.log_message(l_stage);
378: end if;
379: begin
380: pa_cost_rate_pub.get_orgn_level_costing_info
381: ( p_org_id => nvl(p_org_id, g_ou_id) --7158405

Line 405: pa_cc_utils.log_message('when others error '||substr(SQLERRM,1,300));

401: );
402: exception
403: when others then
404: if ( l_debug_mode = 'Y' ) then
405: pa_cc_utils.log_message('when others error '||substr(SQLERRM,1,300));
406: end if;
407: end;
408:
409: if ( x_err_code is not null )

Line 432: pa_cc_utils.log_message(l_stage);

428: costing method holds 2 values: 'STANDARD_COSTING', 'ACTUAL'.
429: The rate source would hold the source of the rates. */
430:
431: l_stage := 'selecting costing method from rule [' || x_costing_rule || ']';
432: pa_cc_utils.log_message(l_stage);
433:
434: select rule.costing_method, rule.rate_source_code
435: into l_costing_method, l_rate_source_code
436: from pa_compensation_rule_sets rule

Line 440: pa_cc_utils.log_message('l_costing_method '||l_costing_method);

436: from pa_compensation_rule_sets rule
437: where rule.compensation_rule_set = x_costing_rule;
438:
439: if ( l_debug_mode = 'Y' ) then
440: pa_cc_utils.log_message('l_costing_method '||l_costing_method);
441: end if;
442:
443: if ( x_rate_sch_id is null and l_rate_source_code = 'PROJECT_RATES')
444: then

Line 491: pa_cc_utils.log_message(l_stage);

487: */
488: l_stage := 'Reading Rate Schedule information for [' || to_char(x_rate_sch_id) || ']';
489: if ( l_debug_mode = 'Y' )
490: then
491: pa_cc_utils.log_message(l_stage);
492: end if;
493: select rate_sch.schedule_type
494: ,rate_sch.rate_sch_currency_code
495: ,rate_sch.job_group_id

Line 506: pa_cc_utils.log_message(l_stage);

502: l_stage := 'sch type [' || l_sch_type || '] crcc [' || x_cost_rate_curr_code || '] job group [' ||
503: to_char(l_job_group_id) || ']';
504: if ( l_debug_mode = 'Y' )
505: then
506: pa_cc_utils.log_message(l_stage);
507: end if;
508:
509: if ( l_sch_type = 'EMPLOYEE')
510: then

Line 514: pa_cc_utils.log_message(l_stage);

510: then
511: l_stage := 'Getting rate from this employee type schedule';
512: if ( l_debug_mode = 'Y' )
513: then
514: pa_cc_utils.log_message(l_stage);
515: end if;
516:
517: begin
518: select bill_rates.rate

Line 538: pa_cc_utils.log_message(l_stage);

534: else
535: l_stage := 'Job mapping for [' || to_char(x_job_id) || ']';
536: if ( l_debug_mode = 'Y' )
537: then
538: pa_cc_utils.log_message(l_stage);
539: end if;
540: l_dest_job_id := pa_cross_business_grp.IsMappedToJob(x_job_id, l_job_group_id);
541:
542: l_stage := 'Getting rate for job id [' || to_char(l_dest_job_id) || ']';

Line 545: pa_cc_utils.log_message(l_stage);

541:
542: l_stage := 'Getting rate for job id [' || to_char(l_dest_job_id) || ']';
543: if ( l_debug_mode = 'Y' )
544: then
545: pa_cc_utils.log_message(l_stage);
546: end if;
547: begin
548: select bill_rates.rate
549: ,bill_rates.start_date_active

Line 573: pa_cc_utils.log_message(l_stage);

569:
570: l_stage := 'Rate is [' || to_char(x_cost_rate) || ']';
571: if ( l_debug_mode = 'Y' )
572: then
573: pa_cc_utils.log_message(l_stage);
574: end if;
575:
576: /* commented for bug 7423839
577:

Line 580: pa_cc_utils.log_message('END');

576: /* commented for bug 7423839
577:
578: if ( l_debug_mode = 'Y' )
579: then
580: pa_cc_utils.log_message('END');
581: end if;
582: */
583: pa_cc_utils.reset_curr_function;
584: exception

Line 583: pa_cc_utils.reset_curr_function;

579: then
580: pa_cc_utils.log_message('END');
581: end if;
582: */
583: pa_cc_utils.reset_curr_function;
584: exception
585: when USER_EXCEPTION
586: then
587: g_rt_calling_module := p_calling_module;

Line 605: pa_cc_utils.log_message('p_calling_module '||p_calling_module);

601: g_rt_err_code := x_err_code;
602: if ( l_debug_mode = 'Y' ) --skkoppul
603: then
604: /*
605: pa_cc_utils.log_message('p_calling_module '||p_calling_module);
606: pa_cc_utils.log_message('x_organization_id '||x_organization_id);
607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);
608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));

Line 606: pa_cc_utils.log_message('x_organization_id '||x_organization_id);

602: if ( l_debug_mode = 'Y' ) --skkoppul
603: then
604: /*
605: pa_cc_utils.log_message('p_calling_module '||p_calling_module);
606: pa_cc_utils.log_message('x_organization_id '||x_organization_id);
607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);
608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);

Line 607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);

603: then
604: /*
605: pa_cc_utils.log_message('p_calling_module '||p_calling_module);
606: pa_cc_utils.log_message('x_organization_id '||x_organization_id);
607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);
608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);

Line 608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));

604: /*
605: pa_cc_utils.log_message('p_calling_module '||p_calling_module);
606: pa_cc_utils.log_message('x_organization_id '||x_organization_id);
607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);
608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);

Line 609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));

605: pa_cc_utils.log_message('p_calling_module '||p_calling_module);
606: pa_cc_utils.log_message('x_organization_id '||x_organization_id);
607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);
608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);

Line 610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);

606: pa_cc_utils.log_message('x_organization_id '||x_organization_id);
607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);
608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);

Line 611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);

607: pa_cc_utils.log_message('x_cost_rate '||x_cost_rate);
608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);

Line 612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);

608: pa_cc_utils.log_message('x_start_date_active '||to_char(x_start_date_active));
609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);

Line 613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);

609: pa_cc_utils.log_message('x_end_date_active '||to_char(x_end_date_active));
610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);

Line 614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);

610: pa_cc_utils.log_message('x_costing_rule '||x_costing_rule);
611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);
618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);

Line 615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);

611: pa_cc_utils.log_message('x_rate_sch_id '||x_rate_sch_id);
612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);
618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);
619: pa_cc_utils.log_message('x_err_code '||x_err_code);

Line 616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);

612: pa_cc_utils.log_message('x_cost_rate_curr_code '||x_cost_rate_curr_code);
613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);
618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);
619: pa_cc_utils.log_message('x_err_code '||x_err_code);
620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));

Line 617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);

613: pa_cc_utils.log_message('x_acct_rate_type '||x_acct_rate_type);
614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);
618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);
619: pa_cc_utils.log_message('x_err_code '||x_err_code);
620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));
621: */

Line 618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);

614: pa_cc_utils.log_message('x_acct_rate_date_code '||x_acct_rate_date_code);
615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);
618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);
619: pa_cc_utils.log_message('x_err_code '||x_err_code);
620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));
621: */
622: pa_cc_utils.log_message('x_err_stage '||x_err_stage||' x_err_code '||x_err_code||' Error '||substr(SQLERRM,1,300));

Line 619: pa_cc_utils.log_message('x_err_code '||x_err_code);

615: pa_cc_utils.log_message('x_acct_exch_rate '||x_acct_exch_rate);
616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);
618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);
619: pa_cc_utils.log_message('x_err_code '||x_err_code);
620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));
621: */
622: pa_cc_utils.log_message('x_err_stage '||x_err_stage||' x_err_code '||x_err_code||' Error '||substr(SQLERRM,1,300));
623: end if;

Line 620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));

616: pa_cc_utils.log_message('x_ot_project_id '||x_ot_project_id);
617: pa_cc_utils.log_message('x_ot_task_id '||x_ot_task_id);
618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);
619: pa_cc_utils.log_message('x_err_code '||x_err_code);
620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));
621: */
622: pa_cc_utils.log_message('x_err_stage '||x_err_stage||' x_err_code '||x_err_code||' Error '||substr(SQLERRM,1,300));
623: end if;
624: pa_cc_utils.reset_curr_function;

Line 622: pa_cc_utils.log_message('x_err_stage '||x_err_stage||' x_err_code '||x_err_code||' Error '||substr(SQLERRM,1,300));

618: pa_cc_utils.log_message('x_err_stage '||x_err_stage);
619: pa_cc_utils.log_message('x_err_code '||x_err_code);
620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));
621: */
622: pa_cc_utils.log_message('x_err_stage '||x_err_stage||' x_err_code '||x_err_code||' Error '||substr(SQLERRM,1,300));
623: end if;
624: pa_cc_utils.reset_curr_function;
625: when others then
626: if ( l_debug_mode = 'Y' )

Line 624: pa_cc_utils.reset_curr_function;

620: pa_cc_utils.log_message('Error '||substr(SQLERRM,1,300));
621: */
622: pa_cc_utils.log_message('x_err_stage '||x_err_stage||' x_err_code '||x_err_code||' Error '||substr(SQLERRM,1,300));
623: end if;
624: pa_cc_utils.reset_curr_function;
625: when others then
626: if ( l_debug_mode = 'Y' )
627: then
628: pa_cc_utils.log_message('In when others exception '||substr(SQLERRM,1,300));

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

624: pa_cc_utils.reset_curr_function;
625: when others then
626: if ( l_debug_mode = 'Y' )
627: then
628: pa_cc_utils.log_message('In when others exception '||substr(SQLERRM,1,300));
629: end if;
630: /*Bug fix:3089560 Plsql numeric value error causes without resetting stack*/
631: pa_cc_utils.reset_curr_function;
632: raise;

Line 631: pa_cc_utils.reset_curr_function;

627: then
628: pa_cc_utils.log_message('In when others exception '||substr(SQLERRM,1,300));
629: end if;
630: /*Bug fix:3089560 Plsql numeric value error causes without resetting stack*/
631: pa_cc_utils.reset_curr_function;
632: raise;
633: end get_labor_rate;
634: ---------------------------------------------------------------------------------------------
635: PROCEDURE get_orgn_level_costing_info

Line 768: if pa_cc_utils.g_debug_mode then

764: ,assign.organization_id
765: ,assign.org_id;
766:
767: begin
768: if pa_cc_utils.g_debug_mode then
769: l_debug_mode := 'Y';
770: else
771: l_debug_mode := 'N';
772: end if;

Line 778: pa_cc_utils.set_curr_function('get_orgn_level_costing_info');

774: IF ( l_debug_mode = 'Y' ) THEN
775: pa_debug.set_process( x_process => 'PLSQL'
776: ,x_debug_mode => l_debug_mode
777: );
778: pa_cc_utils.set_curr_function('get_orgn_level_costing_info');
779: --pa_cc_utils.log_message('Start ');
780: END IF;
781:
782: l_stage := 'org_id [' || to_char(p_org_id) || '] organization_id [' || to_char(p_organization_id) || ']';

Line 779: --pa_cc_utils.log_message('Start ');

775: pa_debug.set_process( x_process => 'PLSQL'
776: ,x_debug_mode => l_debug_mode
777: );
778: pa_cc_utils.set_curr_function('get_orgn_level_costing_info');
779: --pa_cc_utils.log_message('Start ');
780: END IF;
781:
782: l_stage := 'org_id [' || to_char(p_org_id) || '] organization_id [' || to_char(p_organization_id) || ']';
783: if ( l_debug_mode = 'Y' )

Line 785: pa_cc_utils.log_message(l_stage);

781:
782: l_stage := 'org_id [' || to_char(p_org_id) || '] organization_id [' || to_char(p_organization_id) || ']';
783: if ( l_debug_mode = 'Y' )
784: then
785: pa_cc_utils.log_message(l_stage);
786: end if;
787:
788: /* commented for bug 7423839
789:

Line 793: pa_cc_utils.log_message(l_stage);

789:
790: l_stage := 'opening assignment';
791: if ( l_debug_mode = 'Y' )
792: then
793: pa_cc_utils.log_message(l_stage);
794: end if;
795: */
796: /* added for 12.2 .. payroll intg. Evaluate the organization level rules setup.
797: Based on the costing rule found, find the costing method and rate source.

Line 805: pa_cc_utils.log_message('opening org costing rule');

801:
802: l_rate_source_code := NULL;
803: l_costing_method := NULL;
804:
805: pa_cc_utils.log_message('opening org costing rule');
806:
807: open org_costing_rule (p_org_id,p_organization_id,p_person_id,p_job_id,p_txn_date,p_calling_module);
808:
809: fetch org_costing_rule

Line 821: pa_cc_utils.log_message('Fetched org costing rule .. costing_rule is: ' || l_costing_rule);

817: ,l_acct_exch_rate
818: ,l_base_hours
819: ,l_rbc_elem_type_id;
820:
821: pa_cc_utils.log_message('Fetched org costing rule .. costing_rule is: ' || l_costing_rule);
822:
823: if org_costing_rule%FOUND then
824: begin
825: select costing_method, rate_source_code

Line 835: pa_cc_utils.log_message('Fetched comp rule .. costing_method is: ' || l_costing_method ||', rate source: ' || l_rate_source_code);

831: l_rate_source_code := NULL;
832: end;
833: end if;
834:
835: pa_cc_utils.log_message('Fetched comp rule .. costing_method is: ' || l_costing_method ||', rate source: ' || l_rate_source_code);
836:
837: --close org_costing_rule;
838:
839: if ((org_costing_rule%NOTFOUND) OR (l_rate_source_code = 'PROJECT_RATES')) then

Line 847: pa_cc_utils.log_message(l_stage);

843:
844: l_stage := 'fetching assignment';
845: if ( l_debug_mode = 'Y' )
846: then
847: pa_cc_utils.log_message(l_stage);
848: end if;
849:
850: */
851: fetch assignment

Line 863: pa_cc_utils.log_message('Fetched assignment rule .. costing_rule is: ' || l_costing_rule);

859: ,l_acct_exch_rate
860: ,l_base_hours
861: ,l_rbc_elem_type_id;
862:
863: pa_cc_utils.log_message('Fetched assignment rule .. costing_rule is: ' || l_costing_rule);
864:
865: if ( assignment%NOTFOUND )
866: then
867: l_stage := 'assignment not found for organization ';

Line 870: pa_cc_utils.log_message(l_stage);

866: then
867: l_stage := 'assignment not found for organization ';
868: if ( l_debug_mode = 'Y' )
869: then
870: pa_cc_utils.log_message(l_stage);
871: end if;
872: /*
873: * This means - neither this organization nor any of its parent
874: * organizations have an assignment. See if there is any assigmnent

Line 904: pa_cc_utils.log_message(l_stage);

900: begin
901: l_stage := 'Getting OU level assignment for [' || to_char(p_org_id) || ']';
902: if ( l_debug_mode = 'Y' )
903: then
904: pa_cc_utils.log_message(l_stage);
905: end if;
906: select assign.org_id
907: ,assign.org_labor_sch_rule_id
908: ,decode(p_calling_module ,'REQUIREMENT'

Line 938: pa_cc_utils.log_message(l_stage);

934: exception
935: when no_data_found then
936: l_stage := 'assignment not found at the OU level !!!!!!';
937: if ( l_debug_mode = 'Y' ) then
938: pa_cc_utils.log_message(l_stage);
939: end if;
940: x_err_code := 'NO_RATE';
941: when others then
942: raise;

Line 972: pa_cc_utils.log_message(l_stage);

968: '] l_acct_exch_rate [' || to_char( l_acct_exch_rate) ||
969: '] x_err_code [' || x_err_code || ']';
970: if ( l_debug_mode = 'Y' )
971: then
972: pa_cc_utils.log_message(l_stage);
973: end if;
974:
975: /*
976: * Move local variables to out parameters.

Line 993: pa_cc_utils.log_message(l_stage);

989: /* commented for bug 7423839
990: l_stage := 'Closing Cursor';
991: if ( l_debug_mode = 'Y' )
992: then
993: pa_cc_utils.log_message(l_stage);
994: end if;
995:
996: */
997: if assignment%ISOPEN then

Line 1005: pa_cc_utils.log_message(l_stage);

1001: /* commented for bug 7423839
1002: l_stage := 'END';
1003: if ( l_debug_mode = 'Y' )
1004: then
1005: pa_cc_utils.log_message(l_stage);
1006: end if;
1007: */
1008: pa_cc_utils.reset_curr_function;
1009:

Line 1008: pa_cc_utils.reset_curr_function;

1004: then
1005: pa_cc_utils.log_message(l_stage);
1006: end if;
1007: */
1008: pa_cc_utils.reset_curr_function;
1009:
1010: exception
1011: when others
1012: then

Line 1015: pa_cc_utils.log_message('inside others excpn get_orgn_level_costing_info');

1011: when others
1012: then
1013: if ( l_debug_mode = 'Y' )
1014: then
1015: pa_cc_utils.log_message('inside others excpn get_orgn_level_costing_info');
1016: end if;
1017: pa_cc_utils.reset_curr_function;
1018: RAISE;
1019: end get_orgn_level_costing_info;

Line 1017: pa_cc_utils.reset_curr_function;

1013: if ( l_debug_mode = 'Y' )
1014: then
1015: pa_cc_utils.log_message('inside others excpn get_orgn_level_costing_info');
1016: end if;
1017: pa_cc_utils.reset_curr_function;
1018: RAISE;
1019: end get_orgn_level_costing_info;
1020:
1021: /*----------------------------------------------------------------------------*/

Line 1077: --pa_cc_utils.log_message('In Getempcost rate');

1073: l_numerator number;
1074: l_denominator number;
1075: Begin
1076:
1077: --pa_cc_utils.log_message('In Getempcost rate');
1078: IF (P_Called_From <> 'R') AND /* Added for 3405326 */
1079: P_person_id = nvl(G_EMP_PERSON_ID,-99) AND
1080: nvl(P_job_id,-99) = nvl(G_EMP_JOB_ID,-99) AND
1081: nvl(P_organization_id,-99) = nvl(G_EMP_ORGANIZATION_ID,-99) AND

Line 1084: -- pa_cc_utils.log_message('Getting the Rate from Cache');

1080: nvl(P_job_id,-99) = nvl(G_EMP_JOB_ID,-99) AND
1081: nvl(P_organization_id,-99) = nvl(G_EMP_ORGANIZATION_ID,-99) AND
1082: P_effective_date BETWEEN G_EMP_RATE_START_DATE AND nvl(G_EMP_RATE_END_DATE,SYSDATE) THEN
1083: NULL; --Do nothing. Values are in the Cache.
1084: -- pa_cc_utils.log_message('Getting the Rate from Cache');
1085: ELSE
1086:
1087: --pa_cc_utils.log_message('Deriving the Rate');
1088: --- Call the api to derive rate and attributes.

Line 1087: --pa_cc_utils.log_message('Deriving the Rate');

1083: NULL; --Do nothing. Values are in the Cache.
1084: -- pa_cc_utils.log_message('Getting the Rate from Cache');
1085: ELSE
1086:
1087: --pa_cc_utils.log_message('Deriving the Rate');
1088: --- Call the api to derive rate and attributes.
1089:
1090: l_job_id := P_job_id; --IN OUT parameter
1091: l_organization_id := P_organization_id; --IN OUT parameter.

Line 1140: -- pa_cc_utils.log_message('Deriving the Functional Rate');

1136: G_EMP_RATE_END_DATE := l_end_date_active;
1137:
1138: IF P_Rate_Type = 'FUNC' THEN --Return the Functional Rate
1139:
1140: -- pa_cc_utils.log_message('Deriving the Functional Rate');
1141: -- Get the Functional Currency code
1142: l_acct_currency_code := PA_CURRENCY.get_currency_code;
1143:
1144: --Check if the denom and functional currencies are different

Line 1186: --pa_cc_utils.log_message('before return rate = '||l_return_rate);

1182: --Return the Transaction Rate
1183: l_return_rate := G_EMP_COST_RATE;
1184: END IF;
1185:
1186: --pa_cc_utils.log_message('before return rate = '||l_return_rate);
1187: Return l_return_rate;
1188:
1189: End GetEmpCostRate;
1190:

Line 1243: --pa_cc_utils.log_message('In Getempcostrateinfo...');

1239: l_err_stage number;
1240: l_return_value varchar2(100);
1241: Begin
1242:
1243: --pa_cc_utils.log_message('In Getempcostrateinfo...');
1244: IF (P_Called_From <> 'R') AND /* Added for 3405326 */
1245: P_person_id = nvl(G_EMP_PERSON_ID,-99) AND
1246: nvl(P_job_id,-99) = nvl(G_EMP_JOB_ID,-99) AND
1247: nvl(P_organization_id,-99) = nvl(G_EMP_ORGANIZATION_ID,-99) AND

Line 1250: --pa_cc_utils.log_message('Getting the Rate Attributes from Cache');

1246: nvl(P_job_id,-99) = nvl(G_EMP_JOB_ID,-99) AND
1247: nvl(P_organization_id,-99) = nvl(G_EMP_ORGANIZATION_ID,-99) AND
1248: P_effective_date BETWEEN G_EMP_RATE_START_DATE AND nvl(G_EMP_RATE_END_DATE,SYSDATE) THEN
1249: NULL; --Don't do anything. The values are cached already.
1250: --pa_cc_utils.log_message('Getting the Rate Attributes from Cache');
1251: ELSE
1252:
1253: --pa_cc_utils.log_message('Deriving the Rate Attributes');
1254: --- Call the api to derive rate and attributes.

Line 1253: --pa_cc_utils.log_message('Deriving the Rate Attributes');

1249: NULL; --Don't do anything. The values are cached already.
1250: --pa_cc_utils.log_message('Getting the Rate Attributes from Cache');
1251: ELSE
1252:
1253: --pa_cc_utils.log_message('Deriving the Rate Attributes');
1254: --- Call the api to derive rate and attributes.
1255:
1256: l_job_id := P_job_id; --IN OUT parameter
1257: l_organization_id := P_organization_id; --IN OUT parameter.

Line 1343: if pa_cc_utils.g_debug_mode then

1339: l_stage varchar2(500);
1340: l_debug_mode varchar2(1) := 'Y';
1341: begin
1342:
1343: if pa_cc_utils.g_debug_mode then
1344: l_debug_mode := 'Y';
1345: else
1346: l_debug_mode := 'N';
1347: end if;

Line 1352: pa_cc_utils.set_curr_function('get_orgn_lvl_cst_info_set');

1348: IF ( l_debug_mode = 'Y' ) THEN
1349: pa_debug.set_process( x_process => 'PLSQL'
1350: ,x_debug_mode => l_debug_mode
1351: );
1352: pa_cc_utils.set_curr_function('get_orgn_lvl_cst_info_set');
1353: pa_cc_utils.log_message('Start ');
1354: END IF;
1355:
1356: l_count := p_organization_id_tab.count ;

Line 1353: pa_cc_utils.log_message('Start ');

1349: pa_debug.set_process( x_process => 'PLSQL'
1350: ,x_debug_mode => l_debug_mode
1351: );
1352: pa_cc_utils.set_curr_function('get_orgn_lvl_cst_info_set');
1353: pa_cc_utils.log_message('Start ');
1354: END IF;
1355:
1356: l_count := p_organization_id_tab.count ;
1357: l_stage := 'count [' || to_char(l_count) || ']';

Line 1360: pa_cc_utils.log_message(l_stage);

1356: l_count := p_organization_id_tab.count ;
1357: l_stage := 'count [' || to_char(l_count) || ']';
1358: if ( l_debug_mode = 'Y')
1359: then
1360: pa_cc_utils.log_message(l_stage);
1361: end if;
1362: for i in 1 .. l_count
1363: loop
1364: if ( p_override_type_tab(i) is null or x_costing_rule_tab(i) is null )

Line 1382: pa_cc_utils.log_message(l_stage);

1378: '] aer [' || x_acct_exch_rate_tab(i) ||
1379: ']';
1380: if ( l_debug_mode = 'Y' )
1381: then
1382: pa_cc_utils.log_message(l_stage);
1383: end if;
1384:
1385: /*
1386: * GSCC: Handled File.Date.5 for p_txn_date_tab(i).

Line 1414: pa_cc_utils.log_message('others err in get_orgn_lvl_cst_info_set '||substr(SQLERRM,1,300));

1410: );
1411: exception
1412: when others then
1413: if ( l_debug_mode = 'Y' ) then
1414: pa_cc_utils.log_message('others err in get_orgn_lvl_cst_info_set '||substr(SQLERRM,1,300));
1415: end if;
1416: end;
1417:
1418:

Line 1435: pa_cc_utils.log_message(l_stage);

1431: '] err code [' || x_err_code_tab(i) ||
1432: ']';
1433: if ( l_debug_mode = 'Y' )
1434: then
1435: pa_cc_utils.log_message(l_stage);
1436: end if;
1437: end if; /* override type */
1438: end loop;
1439: pa_cc_utils.reset_curr_function;

Line 1439: pa_cc_utils.reset_curr_function;

1435: pa_cc_utils.log_message(l_stage);
1436: end if;
1437: end if; /* override type */
1438: end loop;
1439: pa_cc_utils.reset_curr_function;
1440: exception
1441: when others
1442: then
1443: if ( l_debug_mode = 'Y' ) then

Line 1444: pa_cc_utils.log_message('final others err '||substr(SQLERRM,1,300));

1440: exception
1441: when others
1442: then
1443: if ( l_debug_mode = 'Y' ) then
1444: pa_cc_utils.log_message('final others err '||substr(SQLERRM,1,300));
1445: end if;
1446: pa_cc_utils.reset_curr_function;
1447: raise;
1448: end get_orgn_lvl_cst_info_set;

Line 1446: pa_cc_utils.reset_curr_function;

1442: then
1443: if ( l_debug_mode = 'Y' ) then
1444: pa_cc_utils.log_message('final others err '||substr(SQLERRM,1,300));
1445: end if;
1446: pa_cc_utils.reset_curr_function;
1447: raise;
1448: end get_orgn_lvl_cst_info_set;
1449: --------------------------------
1450: