[Home] [Help]
1: PACKAGE BODY PSP_LABOR_DIST as
2: /* $Header: PSPLDCDB.pls 120.33.12010000.4 2008/10/17 07:48:08 aniagarw ship $ */
3:
4: g_dist_line_id NUMBER;
5: /* Following variables are added for bug 2374680 */
441: raise fnd_api.g_exc_unexpected_error;
442: end if;
443: exception
444: when others then
445: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','ADJUSTED_PERCENTAGES');
446: raise;
447: end;
448: hr_utility.trace('Close get_adjusted_percentages array_size='||project_id_array.count);
449: l_sum_adj_amount := 0;
632:
633: WHEN OTHERS THEN
634: ROLLBACK;
635:
636: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
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;
809: raise; --- for nih sal cap 4304623
810: WHEN OTHERS THEN
811: ROLLBACK;
812: -- g_error_api_path := SUBSTR('CREATE_LINES:'||g_error_api_path,1,230);
813: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
814: /* fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
815: p_encoded => FND_API.G_FALSE,
816: p_data => l_msg_data,
817: p_msg_index_out => l_msg_count); */
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;
8729: g_business_group_id||','||
8730: g_set_of_books_id||','||
8731: g_set_of_books_id||','||l_chunk_status); */
8732:
8733: psp_labor_dist.g_payroll_action_id := p_payroll_Action_id;
8734: psp_labor_dist.create_lines(errbuf ,
8735: retcode ,
8736: g_source_type,
8737: g_source_code,
8730: g_set_of_books_id||','||
8731: g_set_of_books_id||','||l_chunk_status); */
8732:
8733: psp_labor_dist.g_payroll_action_id := p_payroll_Action_id;
8734: psp_labor_dist.create_lines(errbuf ,
8735: retcode ,
8736: g_source_type,
8737: g_source_code,
8738: g_payroll_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;
8803: close get_assignments;
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;
8804: for i in 1..t_asg_array.count
8805: loop
8933: return g_retro_parent_element_id;
8934: end get_retro_parent_element_id;
8935:
8936:
8937: END PSP_LABOR_DIST;