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.PSP_LABOR_DIST dependencies on FND_FILE

Line 334: --#fnd_file.put_line(fnd_file.log,'asg id, payroll_sub_line_id ='|| payroll_Rec.assignment_id||','||payroll_rec.payroll_sub_line_id);

330: l_sub_line_dist_amount := 0;
331: g_tot_dist_amount := 0;
332: FETCH payroll_cur INTO payroll_rec;
333: hr_utility.trace('CDL procedure: payroll_rec='|| payroll_control_rec.payroll_control_id);
334: --#fnd_file.put_line(fnd_file.log,'asg id, payroll_sub_line_id ='|| payroll_Rec.assignment_id||','||payroll_rec.payroll_sub_line_id);
335:
336: IF payroll_cur%NOTFOUND
337: THEN
338: -- dbms_output.put_line('in ayroll_cur');

Line 415: fnd_file.put_line (fnd_file.LOG,'Entering begin inside loop3');

411: end if;
412:
413: -- Introduced BEGIN, EXCEPTION, END for bug 7041286
414: BEGIN
415: fnd_file.put_line (fnd_file.LOG,'Entering begin inside loop3');
416:
417: if payroll_rec.payroll_action_type <> 'R' and l_count > 0 then --- only for non regular runs and pre-adjusted
418: hr_utility.trace('l_count = '||l_count);
419: open get_adjusted_percentages;

Line 595: fnd_file.put_line (fnd_file.LOG,

591: EXCEPTION ---- Introduced BEGIN, EXCEPTION, END for bug 7041286
592:
593: WHEN ZERO_DIVIDE
594: THEN
595: fnd_file.put_line (fnd_file.LOG,
596: 'Calling Get_distribution_lines for sub line id - '
597: || payroll_rec.payroll_sub_line_id );
598:
599: get_distribution_lines (

Line 641: psp_message_s.print_error(p_mode => FND_FILE.LOG,

637: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
638: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
639: fnd_msg_pub.add;
640: retcode := 2;
641: psp_message_s.print_error(p_mode => FND_FILE.LOG,
642: p_print_header => FND_API.G_TRUE);
643: raise;
644: END; -- Introduced BEGIN, EXCEPTION, END for bug 7041286
645:

Line 782: psp_message_s.print_error(p_mode => FND_FILE.LOG,

778: ** Added by Bijoy - 08/06/99 to display error in consurrent log
779: *******************************************************************/
780: fnd_msg_pub.add;
781: retcode := 2;
782: psp_message_s.print_error(p_mode => FND_FILE.LOG,
783: p_print_header => FND_API.G_TRUE);
784: -- l_dist_message := fnd_message.get;
785:
786: -- errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230);

Line 806: psp_message_s.print_error(p_mode => FND_FILE.LOG,

802: -- l_dist_message := fnd_message.get;
803:
804: -- errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230);
805: retcode := 2;
806: psp_message_s.print_error(p_mode => FND_FILE.LOG,
807: p_print_header => FND_API.G_TRUE);
808:
809: raise; --- for nih sal cap 4304623
810: WHEN OTHERS THEN

Line 826: psp_message_s.print_error(p_mode => FND_FILE.LOG,

822: -- l_dist_message := fnd_message.get;
823:
824: /* errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230); */
825: retcode := 2;
826: psp_message_s.print_error(p_mode => FND_FILE.LOG,
827: p_print_header => FND_API.G_TRUE);
828: raise; --- for nih sal cap 4304623
829: END;
830:

Line 5992: --#fnd_file.put_line(fnd_file.log,'autopop is ON and control_id ='||l_payroll_control_id);

5988: open get_control_id;
5989: fetch get_control_id into l_payroll_control_id;
5990: close get_control_id;
5991:
5992: --#fnd_file.put_line(fnd_file.log,'autopop is ON and control_id ='||l_payroll_control_id);
5993: if g_asg_autopop = 'Y' or g_asg_element_autopop = 'Y' or g_asg_ele_group_autopop = 'Y' then
5994: update_dist_schedule_autopop(p_payroll_control_id =>l_payroll_control_id,
5995: p_business_group_id=>p_business_group_id,
5996: p_set_of_books_id=>p_Set_of_books_id,

Line 6176: --#fnd_file.put_line(fnd_file.log,'autopop for sched lines exp type, glccid, psob, pbg ='|| autopop_exc_rec.expenditure_type||','||autopop_exc_rec.gl_code_combination_id||','|| p_set_of_books_id||','||p_business_group_id);

6172: end if;
6173: autopop_exc_rec.element_type_id := g_retro_parent_element_id;
6174: hr_utility.trace(' 201 Parent element id = '||autopop_exc_rec.element_type_id);
6175: end if;
6176: --#fnd_file.put_line(fnd_file.log,'autopop for sched lines exp type, glccid, psob, pbg ='|| autopop_exc_rec.expenditure_type||','||autopop_exc_rec.gl_code_combination_id||','|| p_set_of_books_id||','||p_business_group_id);
6177: if autopop_exc_rec.gl_code_combination_id is null then
6178: l_acct_type:='E';
6179: else
6180: l_acct_type:='N';

Line 6211: --#fnd_file.put_line(fnd_file.log,'autopop status='|| l_auto_pop_status);

6207: ret_expenditure_type => l_new_expenditure_type,
6208: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6209: retcode => l_auto_pop_status);
6210:
6211: --#fnd_file.put_line(fnd_file.log,'autopop status='|| l_auto_pop_status);
6212: --insert into psp_stout values(1, 'after autopop call');
6213:
6214: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6215: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN

Line 7074: --#fnd_file.put_line(fnd_file.log,

7070:
7071: hr_utility.trace('CDL program --> apply_salary_cap cap_rec.sponsor_id, cap_rec.project_id, cap_rec.start_date, cap_rec.enc_date, cap_rec.annual_salary_cap , daily_cap_rate = '||
7072: cap_rec.sponsor_id||','||cap_rec.project_id||','|| cap_rec.start_date||','|| cap_rec.end_date||','|| cap_rec.annual_salary_cap||' , '||cap_rec.daily_cap_rate);
7073:
7074: --#fnd_file.put_line(fnd_file.log,
7075: ---'CDL program --> apply_salary_cap cap_rec.sponsor_id, cap_rec.project_id, cap_rec.start_date, cap_rec.enc_date, cap_rec.annual_salary_cap , daily_cap_rate , l_no_units_per_year , l_tp_no_of_work_days= '
7076: ---|| cap_rec.sponsor_id||','||cap_rec.project_id||','|| cap_rec.start_date||','|| cap_rec.end_date||','|| cap_rec.annual_salary_cap||' , '||cap_rec.daily_cap_rate||' , '||l_no_units_per_year ||' , '||l_tp_no_of_work_days);
7077:
7078: --- removed hard coded strings and replaced with parameters. 5530231

Line 7231: --#fnd_file.put_line(fnd_file.log,'l_sql_str0 ='||l_sql_str);

7227: and pdl.distribution_date between over.start_date and over.end_date)';
7228: end if;
7229:
7230: hr_utility.trace('CDL program --> After the dist line string is built');
7231: --#fnd_file.put_line(fnd_file.log,'l_sql_str0 ='||l_sql_str);
7232: if psp_salary_cap_custom.g_parent_sponsor_field is null then
7233: -- by default gms.funding_source_id has sponsor.
7234: l_parent_sponsor_sql_str :=
7235: ' AND awd.funding_source_id = '||cap_rec.sponsor_id;

Line 7277: --#fnd_file.put_line(fnd_file.log,' before exec immediate l_sql_str ='||l_sql_str);

7273: if substr(l_sql_str,3401,200) is not null then
7274: hr_utility.trace(substr(l_sql_str,3401,200));
7275: end if;
7276:
7277: --#fnd_file.put_line(fnd_file.log,' before exec immediate l_sql_str ='||l_sql_str);
7278: execute immediate l_sql_str
7279: using out t_dist_line_id,
7280: out t_dist_date,
7281: out t_dist_amount,

Line 8009: ---fnd_file.put_line(fnd_file.log, 'before suspense cursor');

8005: t_cost_id;
8006:
8007: close org_default_account_cur;
8008: else
8009: ---fnd_file.put_line(fnd_file.log, 'before suspense cursor');
8010: open suspense_account_cur;
8011: fetch suspense_account_cur bulk collect into t_payroll_sub_line_id,
8012: t_effective_date ,
8013: t_person_id ,

Line 8055: ---#fnd_file.put_line(fnd_file.log, 'Suspense sql string l_dist_sql_string='||l_dist_sql_string||', count='||t_payroll_sub_line_id.count);

8051: pdl.distribution_amount
8052: from psp_distribution_lines pdl
8053: where pdl.payroll_sub_line_id = :1
8054: and pdl.suspense_org_account_id = :2';
8055: ---#fnd_file.put_line(fnd_file.log, 'Suspense sql string l_dist_sql_string='||l_dist_sql_string||', count='||t_payroll_sub_line_id.count);
8056: end if;
8057: end if;
8058: for i in 1..t_payroll_sub_line_id.count
8059: loop

Line 8072: ---fnd_file.put_line(fnd_file.log, 'Generic_account_autopop.. Suspense.. before autopop call');

8068: g_retro_parent_element_id := nvl(get_retro_parent_element_id(t_cost_id(i)), t_element_type_id(i));
8069: end if;
8070: t_element_type_id(i) := g_retro_parent_element_id;
8071: end if;
8072: ---fnd_file.put_line(fnd_file.log, 'Generic_account_autopop.. Suspense.. before autopop call');
8073: psp_autopop.main(
8074: p_acct_type => l_acct_type,
8075: p_person_id => t_person_id(i),
8076: p_assignment_id => t_assignment_id(i),

Line 8090: ---fnd_file.put_line(fnd_file.log, 'Generic_account_autopop.. Suspense.. After autopop call');

8086: p_business_group_id => p_business_group_id,
8087: ret_expenditure_type => l_new_expenditure_type,
8088: ret_gl_code_combination_id => l_new_gl_code_combination_id,
8089: retcode => l_auto_pop_status);
8090: ---fnd_file.put_line(fnd_file.log, 'Generic_account_autopop.. Suspense.. After autopop call');
8091:
8092: IF (l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
8093: (l_auto_pop_status = FND_API.G_RET_STS_ERROR) THEN
8094: IF l_auto_pop_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 8104: ----fnd_file.put_line(fnd_file.log,'error in autopop main in generic_account_autopop code='||l_auto_status||' sched type='||p_Schedule_type);

8100: ELSIF l_auto_pop_status = FND_API.G_RET_STS_ERROR THEN
8101: l_auto_status := 'AUTO_POP_NO_VALUE';
8102: END IF;
8103:
8104: ----fnd_file.put_line(fnd_file.log,'error in autopop main in generic_account_autopop code='||l_auto_status||' sched type='||p_Schedule_type);
8105: open dist_line_cur for l_dist_sql_string using t_payroll_sub_line_id(i), t_account_id(i);
8106: loop
8107: fetch dist_line_cur into l_dist_line_id, l_effective_date, l_dist_amount;
8108: if dist_line_cur%notfound then exit;

Line 8161: ----fnd_file.put_line(fnd_file.log,'SUCCESS in autopop main in generic_account_autopop code='||l_auto_status);

8157: end loop;
8158: close dist_line_cur;
8159:
8160: else --- autopop is successful
8161: ----fnd_file.put_line(fnd_file.log,'SUCCESS in autopop main in generic_account_autopop code='||l_auto_status);
8162: if l_acct_type= 'E' then
8163: open dist_line_cur for l_dist_sql_string using t_payroll_sub_line_id(i), t_account_id(i);
8164: loop
8165: fetch dist_line_cur into l_dist_line_id, l_effective_date, l_dist_amount;

Line 8209: ---fnd_file.put_line(fnd_file.log,'failure in _autopop code='||l_auto_status||' person_id, asgid, edate='||

8205: (l_award_status is not null ) THEN
8206: open get_person_details(t_person_id(i), t_assignment_id(i), l_effective_date);
8207: fetch get_person_details into l_employee_name, l_asg_num, l_organization_name;
8208: close get_person_details;
8209: ---fnd_file.put_line(fnd_file.log,'failure in _autopop code='||l_auto_status||' person_id, asgid, edate='||
8210: ---t_person_id(i)||' , '|| t_assignment_id(i)||' , '|| l_effective_date);
8211:
8212: if p_schedule_type = 'SUSPENSE' then
8213: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');

Line 8263: ----fnd_file.put_line(fnd_file.log,'SUCCESS-NA in autopop main in generic_account_autopop code='||l_auto_status);

8259: end loop;
8260: close dist_line_cur;
8261:
8262: else -- if natural account then
8263: ----fnd_file.put_line(fnd_file.log,'SUCCESS-NA in autopop main in generic_account_autopop code='||l_auto_status);
8264: if p_schedule_type = 'SUSPENSE' then
8265: update psp_distribution_lines
8266: set suspense_auto_glccid = l_new_gl_code_combination_id
8267: where payroll_sub_line_id = t_payroll_sub_line_id(i)

Line 8300: ---fnd_file.put_line(fnd_file.log,'Xiting generic_account_autop');

8296: t_gl_code_combination_id.delete;
8297: t_account_id.delete;
8298: t_payroll_action_type.delete;
8299: t_cost_id.delete;
8300: ---fnd_file.put_line(fnd_file.log,'Xiting generic_account_autop');
8301: exception
8302: when suspense_autopop_fail then
8303: t_payroll_sub_line_id.delete;
8304: t_effective_date.delete;

Line 8416: --#fnd_file.put_line(fnd_file.log,'########CDL_INIT#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');

8412: end if;
8413:
8414: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8415: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8416: --#fnd_file.put_line(fnd_file.log,'########CDL_INIT#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8417: --#fnd_file.put_line(fnd_file.log, p_payroll_action_id||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8418:
8419: -- moved from archive part .. 4744285, commented for 5080403 and introduced below cursor
8420: ---g_auto_population := FND_PROFILE.value('PSP_USE_AUTO_POPULATION');

Line 8417: --#fnd_file.put_line(fnd_file.log, p_payroll_action_id||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);

8413:
8414: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8415: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8416: --#fnd_file.put_line(fnd_file.log,'########CDL_INIT#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8417: --#fnd_file.put_line(fnd_file.log, p_payroll_action_id||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8418:
8419: -- moved from archive part .. 4744285, commented for 5080403 and introduced below cursor
8420: ---g_auto_population := FND_PROFILE.value('PSP_USE_AUTO_POPULATION');
8421: open autopop_config_cur;

Line 8540: --#fnd_file.put_line(fnd_file.log,'########ENTERED RangeCode#######pactid, g_source_code='||pactid||','|| g_source_code);

8536: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8537: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8538:
8539:
8540: --#fnd_file.put_line(fnd_file.log,'########ENTERED RangeCode#######pactid, g_source_code='||pactid||','|| g_source_code);
8541: open get_control_ids;
8542: loop
8543: fetch get_control_ids into l_payroll_control_id;
8544: if get_control_ids%notfound then

Line 8566: --fnd_file.put_line(fnd_file.log,' l_begin_dist_date = '||l_begin_dist_date||' , l_end_dist_date='||l_end_dist_date);

8562: open get_min_max_dist_date;
8563: fetch get_min_max_dist_date into l_begin_dist_date, l_end_dist_date;
8564: close get_min_max_dist_date;
8565:
8566: --fnd_file.put_line(fnd_file.log,' l_begin_dist_date = '||l_begin_dist_date||' , l_end_dist_date='||l_end_dist_date);
8567: hr_utility.trace('CDL process --> range_code --> l_begin_dist_date = '||l_begin_dist_date);
8568:
8569: l_gen_excess_org_id := -- 4744285
8570: psp_general.get_configuration_option_value(g_business_group_id,

Line 8651: psp_message_s.print_error(p_mode => FND_FILE.LOG,

8647: end if;
8648: end loop;
8649:
8650: if l_error_flag = 'Y' then
8651: psp_message_s.print_error(p_mode => FND_FILE.LOG,
8652: p_print_header => FND_API.G_TRUE);
8653: rollback;
8654: raise fnd_api.g_exc_unexpected_error;
8655: end if;

Line 8669: --- fnd_file.put_line(fnd_file.log,' sqlstr ='||sqlstr);

8665: and ppc.cdl_payroll_action_id = :payroll_action_id
8666: order by ppl.assignment_id';
8667:
8668: --- comment it
8669: --- fnd_file.put_line(fnd_file.log,' sqlstr ='||sqlstr);
8670: else
8671: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','RANGE_CODE-NO RECORDS');
8672: psp_message_s.print_error(p_mode => FND_FILE.LOG,
8673: p_print_header => FND_API.G_TRUE);

Line 8672: psp_message_s.print_error(p_mode => FND_FILE.LOG,

8668: --- comment it
8669: --- fnd_file.put_line(fnd_file.log,' sqlstr ='||sqlstr);
8670: else
8671: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','RANGE_CODE-NO RECORDS');
8672: psp_message_s.print_error(p_mode => FND_FILE.LOG,
8673: p_print_header => FND_API.G_TRUE);
8674: raise fnd_api.g_exc_unexpected_error;
8675: end if;
8676:

Line 8720: --#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg);

8716: from pay_temp_object_actions
8717: where payroll_action_id = p_payroll_action_id
8718: and chunk_number = p_chunk_number;
8719:
8720: --#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg);
8721: ---#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg||' chunk_number='||p_chunk_number);
8722:
8723: /*
8724: --- #fnd_file.put_line(fnd_file.log,'########START_ARCHIVE##### g_source_type, g_source_code, g_payroll_id, g_time_period_id, g_batch_name, g_business_group_id, l_chunk_status)='|| g_source_type||','||

Line 8721: ---#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg||' chunk_number='||p_chunk_number);

8717: where payroll_action_id = p_payroll_action_id
8718: and chunk_number = p_chunk_number;
8719:
8720: --#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg);
8721: ---#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg||' chunk_number='||p_chunk_number);
8722:
8723: /*
8724: --- #fnd_file.put_line(fnd_file.log,'########START_ARCHIVE##### g_source_type, g_source_code, g_payroll_id, g_time_period_id, g_batch_name, g_business_group_id, l_chunk_status)='|| g_source_type||','||
8725: g_source_code||','||

Line 8724: --- #fnd_file.put_line(fnd_file.log,'########START_ARCHIVE##### g_source_type, g_source_code, g_payroll_id, g_time_period_id, g_batch_name, g_business_group_id, l_chunk_status)='|| g_source_type||','||

8720: --#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg);
8721: ---#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg||' chunk_number='||p_chunk_number);
8722:
8723: /*
8724: --- #fnd_file.put_line(fnd_file.log,'########START_ARCHIVE##### g_source_type, g_source_code, g_payroll_id, g_time_period_id, g_batch_name, g_business_group_id, l_chunk_status)='|| g_source_type||','||
8725: g_source_code||','||
8726: g_payroll_id||','||
8727: g_time_period_id||','||
8728: g_batch_name||','||

Line 8790: --#fnd_file.put_line(fnd_file.log,'########AssignCode2#######');

8786: from pay_payroll_actions ppa
8787: where ppa.payroll_action_id = p_pactid;
8788:
8789: if g_time_period_id is not null and g_payroll_id is null then
8790: --#fnd_file.put_line(fnd_file.log,'########AssignCode2#######');
8791: select payroll_id
8792: into g_payroll_id
8793: from per_time_periods
8794: where time_period_id = g_time_period_id;

Line 8798: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');

8794: where time_period_id = g_time_period_id;
8795: end if;
8796: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8797: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8798: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8799: --#fnd_file.put_line(fnd_file.log,p_pactid||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8800:
8801: open get_assignments(p_pactid, stasg, endasg, psp_labor_dist.g_time_period_id);
8802: fetch get_assignments bulk collect into t_asg_array;

Line 8799: --#fnd_file.put_line(fnd_file.log,p_pactid||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);

8795: end if;
8796: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8797: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8798: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, g_business_group_id, g_set_of_books_id ,g_source_type, g_time_period_id, g_batch_name=');
8799: --#fnd_file.put_line(fnd_file.log,p_pactid||','|| g_business_group_id||','|| g_set_of_books_id ||','||g_source_type||','|| psp_labor_dist.g_time_period_id||','|| g_batch_name);
8800:
8801: open get_assignments(p_pactid, stasg, endasg, psp_labor_dist.g_time_period_id);
8802: fetch get_assignments bulk collect into t_asg_array;
8803: close get_assignments;

Line 8806: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, asg_id='||p_pactid||','|| t_asg_array(i));

8802: fetch get_assignments bulk collect into t_asg_array;
8803: close get_assignments;
8804: for i in 1..t_asg_array.count
8805: loop
8806: --#fnd_file.put_line(fnd_file.log,'########asg_action_code#######PACTID, asg_id='||p_pactid||','|| t_asg_array(i));
8807: select pay_assignment_actions_s.nextval into l_asgactid from dual;
8808:
8809: hr_nonrun_asact.insact( l_asgactid ,
8810: pactid => p_pactid,

Line 8816: --#fnd_file.put_line(fnd_file.log,'leaving asg action');

8812: object_id => t_asg_array(i),
8813: object_type => 'ASG',
8814: p_transient_action => TRUE);
8815: end loop;
8816: --#fnd_file.put_line(fnd_file.log,'leaving asg action');
8817:
8818: end;
8819:
8820: procedure deinit_code(pactid in number) as

Line 8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);

8844: where ppa.payroll_action_id = pactid;
8845:
8846: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);
8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);
8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);

Line 8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);

8845:
8846: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);
8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);
8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);
8853: --#fnd_file.put_line(fnd_file.log,'DEINIT set_of_books ='||g_business_group_id);

Line 8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);

8846: g_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);
8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);
8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);
8853: --#fnd_file.put_line(fnd_file.log,'DEINIT set_of_books ='||g_business_group_id);
8854: --#fnd_file.put_line(fnd_file.log,'DEINIT bg_id ='||g_set_of_books_id);

Line 8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);

8847: g_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);
8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);
8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);
8853: --#fnd_file.put_line(fnd_file.log,'DEINIT set_of_books ='||g_business_group_id);
8854: --#fnd_file.put_line(fnd_file.log,'DEINIT bg_id ='||g_set_of_books_id);
8855:

Line 8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);

8848: --#fnd_file.put_line(fnd_file.log,'DEINIT source_type ='||g_source_type);
8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);
8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);
8853: --#fnd_file.put_line(fnd_file.log,'DEINIT set_of_books ='||g_business_group_id);
8854: --#fnd_file.put_line(fnd_file.log,'DEINIT bg_id ='||g_set_of_books_id);
8855:
8856:

Line 8853: --#fnd_file.put_line(fnd_file.log,'DEINIT set_of_books ='||g_business_group_id);

8849: --#fnd_file.put_line(fnd_file.log,'DEINIT source_code ='||g_source_code);
8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);
8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);
8853: --#fnd_file.put_line(fnd_file.log,'DEINIT set_of_books ='||g_business_group_id);
8854: --#fnd_file.put_line(fnd_file.log,'DEINIT bg_id ='||g_set_of_books_id);
8855:
8856:
8857: select count(*)

Line 8854: --#fnd_file.put_line(fnd_file.log,'DEINIT bg_id ='||g_set_of_books_id);

8850: --#fnd_file.put_line(fnd_file.log,'DEINIT batch_name ='||g_batch_name);
8851: --#fnd_file.put_line(fnd_file.log,'DEINIT payroll_id ='||g_payroll_id);
8852: --#fnd_file.put_line(fnd_file.log,'DEINIT time_period_id ='||g_time_period_id);
8853: --#fnd_file.put_line(fnd_file.log,'DEINIT set_of_books ='||g_business_group_id);
8854: --#fnd_file.put_line(fnd_file.log,'DEINIT bg_id ='||g_set_of_books_id);
8855:
8856:
8857: select count(*)
8858: into l_count_fail_actions

Line 8874: --#fnd_file.put_line(fnd_file.log,'########entered deinit#######');

8870:
8871: end if;
8872:
8873:
8874: --#fnd_file.put_line(fnd_file.log,'########entered deinit#######');
8875: hr_utility.trace('CDL process --> deinit action_status ='||l_count_fail_actions);
8876:
8877: if l_count_fail_actions = 0 then
8878: open payroll_control_cur;