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.HR_PROCESS_ASSIGNMENT_SS dependencies on HR_UTILITY

Line 63: hr_utility.set_location('Entering:'||l_proc, 5);

59: l_proc varchar2(72) := g_package||'get_asg_from_tt';
60:
61: begin
62: --dbms_output.put_line(' ');
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: p_assignment_rec.assignment_id:=
65: hr_transaction_api.get_number_value
66: (p_transaction_step_id => p_transaction_step_id
67: ,p_name => 'P_ASSIGNMENT_ID');

Line 514: hr_utility.set_location('Exiting:'||l_proc, 15);

510: hr_transaction_api.get_date_value
511: (p_transaction_step_id => p_transaction_step_id
512: ,p_name => 'P_PROJ_ASGN_END');
513:
514: hr_utility.set_location('Exiting:'||l_proc, 15);
515: end get_asg_from_tt;
516: --
517: procedure get_assignment_from_tt
518: (p_item_type in varchar2

Line 712: hr_utility.set_location('Entering:'||l_proc, 5);

708:
709: begin
710:
711:
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: if p_transaction_step_id is null then
714:
715: hr_utility.set_location('if p_transaction_step_id is null then:'||l_proc,10);
716: hr_assignment_common_save_web.get_step

Line 715: hr_utility.set_location('if p_transaction_step_id is null then:'||l_proc,10);

711:
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: if p_transaction_step_id is null then
714:
715: hr_utility.set_location('if p_transaction_step_id is null then:'||l_proc,10);
716: hr_assignment_common_save_web.get_step
717: (p_item_type => p_item_type
718: ,p_item_key => p_item_key
719: ,p_api_name => g_api_name

Line 727: hr_utility.set_location('l_transaction_step_id is null thenExiting:'||l_proc, 15);

723: l_transaction_step_id := to_number(p_transaction_step_id);
724: end if;
725:
726: if l_transaction_step_id is null then
727: hr_utility.set_location('l_transaction_step_id is null thenExiting:'||l_proc, 15);
728: return;
729: end if;
730: --
731: p_assignment_id:= to_char(

Line 1243: hr_utility.set_location('Exiting:'||l_proc, 20);

1239: -- (p_transaction_step_id => l_transaction_step_id
1240: -- ,p_name => 'P_SUPERVISOR_ASSIGNMENT_ID'));
1241: --
1242:
1243: hr_utility.set_location('Exiting:'||l_proc, 20);
1244: end get_assignment_from_tt;
1245:
1246: procedure get_assignment_from_tt
1247: (p_transaction_step_id in number

Line 1348: hr_utility.set_location('Entering:'||l_proc, 5);

1344: l_proc varchar2(72) := g_package||'get_assignment_from_tt';
1345:
1346: begin
1347: --
1348: hr_utility.set_location('Entering:'||l_proc, 5);
1349: p_assignment_id:=
1350: hr_transaction_api.get_number_value
1351: (p_transaction_step_id => p_transaction_step_id
1352: ,p_name => 'P_ASSIGNMENT_ID');

Line 1821: hr_utility.set_location('Exiting:'||l_proc, 15);

1817: hr_transaction_api.get_date_value
1818: (p_transaction_step_id => p_transaction_step_id
1819: ,p_name => 'P_PROJ_ASGN_END');
1820:
1821: hr_utility.set_location('Exiting:'||l_proc, 15);
1822: end get_assignment_from_tt;
1823:
1824: procedure process_save
1825: (p_save_mode in varchar2 default null

Line 1958: hr_utility.set_location('Entering:'||l_proc, 5);

1954: ) is
1955: l_proc varchar2(72) := g_package||'process_save';
1956: begin
1957:
1958: hr_utility.set_location('Entering:'||l_proc, 5);
1959: process_save
1960: (p_save_mode => p_save_mode
1961: ,p_item_type => p_item_type
1962: ,p_item_key => p_item_key

Line 2094: hr_utility.set_location('Exiting:'||l_proc, 15);

2090: ,p_vendor_site_id => to_number(p_vendor_site_id)
2091: ,p_proj_asgn_end => p_projected_asgn_end
2092:
2093: );
2094: hr_utility.set_location('Exiting:'||l_proc, 15);
2095:
2096: end process_save;
2097:
2098: -- This code is for applying several workflow steps of assignment data in

Line 2426: hr_utility.set_location('Entering:'||l_proc, 5);

2422:
2423: --
2424: begin
2425:
2426: hr_utility.set_location('Entering:'||l_proc, 5);
2427: l_object_version_number := p_object_version_number;
2428:
2429: -- first check if this is being called for registration.
2430: if p_flow_mode is not null and

Line 2433: hr_utility.set_location('p_flow_mode = hr_process_assignment_ss.g_new_hire_registration:'||l_proc,10);

2429: -- first check if this is being called for registration.
2430: if p_flow_mode is not null and
2431: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
2432: then
2433: hr_utility.set_location('p_flow_mode = hr_process_assignment_ss.g_new_hire_registration:'||l_proc,10);
2434: g_registration := true;
2435: end if;
2436:
2437: -- validate seesion

Line 2445: hr_utility.set_location(' if g_registration then:'||l_proc,15);

2441: l_activity_id := p_actid;
2442:
2443: --Validate the p_assignment_id
2444: if g_registration then
2445: hr_utility.set_location(' if g_registration then:'||l_proc,15);
2446: open csr_assignment;
2447: fetch csr_assignment into l_assignment_id;
2448: if csr_assignment%notfound then
2449: hr_utility.set_location(' if csr_assignment%notfound then:'||l_proc,20);

Line 2449: hr_utility.set_location(' if csr_assignment%notfound then:'||l_proc,20);

2445: hr_utility.set_location(' if g_registration then:'||l_proc,15);
2446: open csr_assignment;
2447: fetch csr_assignment into l_assignment_id;
2448: if csr_assignment%notfound then
2449: hr_utility.set_location(' if csr_assignment%notfound then:'||l_proc,20);
2450: hr_api.legislation_hooks('DISABLE'); -- bug 6405208
2451: hr_new_user_reg_ss.processNewUserTransaction
2452: (WfItemType => l_item_type
2453: ,WfItemKey => l_item_key

Line 2476: hr_utility.set_location('Exception:Others'||l_proc,555);

2472: l_effective_date :=to_date(p_effective_date, g_date_format);
2473: exception
2474: when others then
2475: --Should add page level error
2476: hr_utility.set_location('Exception:Others'||l_proc,555);
2477: hr_utility.raise_error;
2478: /*hr_errors_api.addErrorToTable
2479: (p_errorfield => null
2480: ,p_errorcode => to_char(SQLCODE)

Line 2477: hr_utility.raise_error;

2473: exception
2474: when others then
2475: --Should add page level error
2476: hr_utility.set_location('Exception:Others'||l_proc,555);
2477: hr_utility.raise_error;
2478: /*hr_errors_api.addErrorToTable
2479: (p_errorfield => null
2480: ,p_errorcode => to_char(SQLCODE)
2481: ,p_errormsg => sqlerrm

Line 2553: hr_utility.set_location('IF l_transaction_step_id is null then:'||l_proc,25);

2549: --
2550: -- look for the last change date so that we can work out what date track
2551: -- update mode we are using
2552: --
2553: hr_utility.set_location('IF l_transaction_step_id is null then:'||l_proc,25);
2554: open last_change_date;
2555: fetch last_change_date into l_last_change_date;
2556: if last_change_date%notfound then
2557: close last_change_date;

Line 2563: hr_utility.raise_error;

2559: -- if we cannot find this assignment record then there must be an error
2560: --
2561: --Should add page level error
2562: fnd_message.set_name('PER','HR_ASG_NOT_FOUND');
2563: hr_utility.raise_error;
2564: /*hr_errors_api.addErrorToTable
2565: (p_errorfield => null
2566: ,p_errormsg => fnd_message.get);*/
2567: else

Line 2576: hr_utility.set_location('l_effective_date>l_last_change_date then:'||l_proc,30);

2572: --
2573: -- if the effective date is after the date of the last change then we
2574: -- are doing an update
2575: --
2576: hr_utility.set_location('l_effective_date>l_last_change_date then:'||l_proc,30);
2577: l_datetrack_update_mode:='UPDATE';
2578:
2579: -- registration always need this as Correction.
2580: if p_flow_mode is not null and

Line 2584: hr_utility.set_location('p_flow_mode is not null and: NewHireReg'||l_proc,35);

2580: if p_flow_mode is not null and
2581:
2582: p_flow_mode = hr_process_assignment_ss.g_new_hire_registration
2583: then
2584: hr_utility.set_location('p_flow_mode is not null and: NewHireReg'||l_proc,35);
2585: l_datetrack_update_mode := 'CORRECTION';
2586: end if;
2587:
2588: else

Line 2597: hr_utility.set_location('if correction_date%FOUND then:'||l_proc,40);

2593: -- if the effective date is equal an existing assignment
2594: -- start date then we
2595: -- are doing a correction
2596: --
2597: hr_utility.set_location('if correction_date%FOUND then:'||l_proc,40);
2598: l_datetrack_update_mode:='CORRECTION';
2599: else
2600: --
2601: IF ( fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND')

Line 2603: hr_utility.set_location('Approve only:'||l_proc,45);

2599: else
2600: --
2601: IF ( fnd_profile.value('PQH_DT_RULE_FUTUR_CHANGE_FOUND')
2602: = 'APPROVE_ONLY') THEN
2603: hr_utility.set_location('Approve only:'||l_proc,45);
2604: l_datetrack_update_mode:='UPDATE_CHANGE_INSERT';
2605: ELSE
2606: --Throw error if date track profile is turned off and
2607: --future dated change is found

Line 2609: hr_utility.raise_error;

2605: ELSE
2606: --Throw error if date track profile is turned off and
2607: --future dated change is found
2608: fnd_message.set_name('PER','HR_DATE_TOO_EARLY');
2609: hr_utility.raise_error;
2610: END IF;
2611: --
2612: end if;
2613:

Line 2662: hr_utility.raise_error;

2658: ,g_date_format))
2659: then
2660: --Should add page level error
2661: fnd_message.set_name('PER','HR_EFF_DATE_CHANGED');
2662: hr_utility.raise_error;
2663: /*hr_errors_api.addErrorToTable
2664: (p_errorfield => null
2665: ,p_errormsg => fnd_message.get);*/
2666: end if;

Line 4639: hr_utility.raise_error;

4635: (p_item_type => l_item_type
4636: ,p_item_key => l_item_key);
4637: if l_transaction_id is null then
4638: fnd_message.set_name('PER', 'HR_CREATE_TRANSACTION_ID_ERR');
4639: hr_utility.raise_error;
4640: end if;
4641: end if;
4642: --
4643: -- create a transaction step

Line 5567: hr_utility.trace('p_salary_change_warning' || p_salary_change_warning);

5563: -- ignore salary change warning
5564:
5565: if(p_salary_change_warning <> 'IGNORE') then
5566: p_salary_change_warning := 'WARNING';
5567: hr_utility.trace('p_salary_change_warning' || p_salary_change_warning);
5568: end if;
5569:
5570: p_gsp_salary_effective_date := ltt_salary_data(1).salary_effective_date;
5571:

Line 5718: when hr_utility.hr_error then

5714: end if;
5715:
5716:
5717: EXCEPTION
5718: when hr_utility.hr_error then
5719: hr_message.provide_error;
5720: p_page_error := hr_message.last_message_app;
5721: --p_page_error_msg := hr_message.last_message_name;
5722: p_page_error_msg := hr_message.get_message_text;

Line 5745: hr_utility.set_location('Exiting:'||l_proc, 40);

5741: rollback to applicant_hire;
5742: g_applicant_hire := false;
5743: end if;
5744: raise;
5745: hr_utility.set_location('Exiting:'||l_proc, 40);
5746: end process_save;
5747:
5748: procedure update_object_version
5749: (p_transaction_step_id in number

Line 5766: hr_utility.set_location('Entering:'||l_proc, 5);

5762: l_proc varchar2(72) := g_package||'update_object_version';
5763:
5764: begin
5765:
5766: hr_utility.set_location('Entering:'||l_proc, 5);
5767: l_assignment_id :=
5768: hr_transaction_api.get_number_value
5769: (p_transaction_step_id => p_transaction_step_id
5770: ,p_name => 'P_ASSIGNMENT_ID');

Line 5782: hr_utility.set_location('if l_old_object_number <> l_new_object_number then:'||l_proc,10);

5778: (p_transaction_step_id => p_transaction_step_id
5779: ,p_name => 'P_OBJECT_VERSION_NUMBER');
5780:
5781: if l_old_object_number <> l_new_object_number then
5782: hr_utility.set_location('if l_old_object_number <> l_new_object_number then:'||l_proc,10);
5783: hr_transaction_api.set_number_value
5784: (p_transaction_step_id => p_transaction_step_id
5785: ,p_person_id => p_login_person_id
5786: ,p_name => 'P_OBJECT_VERSION_NUMBER'

Line 5790: hr_utility.set_location('Exiting:'||l_proc, 15);

5786: ,p_name => 'P_OBJECT_VERSION_NUMBER'
5787: ,p_value => l_new_object_number);
5788: end if;
5789:
5790: hr_utility.set_location('Exiting:'||l_proc, 15);
5791: end update_object_version;
5792: --
5793: --This procedure is to recover all of the assignment data from the transaction
5794: -- tables and save the data into database.

Line 5865: hr_utility.set_location('Entering:'||l_proc, 5);

5861: --
5862: -- recover all of the assignment values
5863: --
5864: --
5865: hr_utility.set_location('Entering:'||l_proc, 5);
5866: if (p_effective_date is not null) then
5867: hr_utility.set_location(' if (p_effective_date is not null) then:'||l_proc,10);
5868: l_effective_date:= to_date(p_effective_date,g_date_format);
5869: else

Line 5867: hr_utility.set_location(' if (p_effective_date is not null) then:'||l_proc,10);

5863: --
5864: --
5865: hr_utility.set_location('Entering:'||l_proc, 5);
5866: if (p_effective_date is not null) then
5867: hr_utility.set_location(' if (p_effective_date is not null) then:'||l_proc,10);
5868: l_effective_date:= to_date(p_effective_date,g_date_format);
5869: else
5870: l_effective_date:= to_date(
5871: hr_transaction_ss.get_wf_effective_date

Line 5898: hr_utility.set_location('session id is ICX_SEC.G_SESSION_ID:'||l_proc,15);

5894: -- adding the session id check to avoid connection pooling problems.
5895: if (( hr_process_person_ss.g_assignment_id is not null) and
5896: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID))
5897: then
5898: hr_utility.set_location('session id is ICX_SEC.G_SESSION_ID:'||l_proc,15);
5899: l_assignment_rec.person_id := hr_process_person_ss.g_person_id;
5900: l_assignment_rec.assignment_id := hr_process_person_ss.g_assignment_id;
5901: l_assignment_rec.object_version_number:=hr_process_person_ss.g_asg_object_version_number;
5902: -- Hard code ovn to 1 for the new user registration process

Line 5916: hr_utility.set_location('Applicaant ICX_SEC.G_SESSION_ID:'||l_proc,20);

5912: -- latest object version
5913: -- number of the applicant who has became employee in BD page
5914: if (hr_process_person_ss.g_is_applicant and
5915: (hr_process_person_ss.g_session_id= ICX_SEC.G_SESSION_ID)) then
5916: hr_utility.set_location('Applicaant ICX_SEC.G_SESSION_ID:'||l_proc,20);
5917: open asg_applicant_rec(l_assignment_rec.assignment_id, l_effective_date);
5918: fetch asg_applicant_rec into l_assignment_rec.object_version_number
5919: ,l_appl_assignment_type
5920: ,l_assignment_rec.assignment_status_type_id;

Line 5927: hr_utility.set_location('if l_new_hire_appl_hire = Y then:'||l_proc,25);

5923: end if;
5924: -- end registration
5925:
5926: if l_new_hire_appl_hire = 'Y' then
5927: hr_utility.set_location('if l_new_hire_appl_hire = Y then:'||l_proc,25);
5928: l_login_person_id:=
5929: hr_transaction_api.get_number_value
5930: (p_transaction_step_id => p_transaction_step_id
5931: ,p_name => 'P_LOGIN_PERSON_ID');

Line 6474: hr_utility.set_location('Entering:'||l_proc, 5);

6470: l_entries_changed varchar2(250);
6471:
6472: begin
6473:
6474: hr_utility.set_location('Entering:'||l_proc, 5);
6475: l_effective_date :=trunc(p_effective_date);
6476:
6477: l_validate_start_date := p_effective_start_date;
6478: l_validate_end_date := p_effective_end_date;

Line 6525: hr_utility.set_location('if p_assignment_type = C then:'||l_proc,25);

6521: -- find the scl hide flag logic in order to set the default values for gre and
6522: -- workschedule segments Bug fix for 3116369
6523: l_scl_hide_flag := 'N';
6524: if p_assignment_type = 'C' then
6525: hr_utility.set_location('if p_assignment_type = C then:'||l_proc,25);
6526: OPEN csr_cwk_scl_idsel(l_legislation_code);
6527: FETCH csr_cwk_scl_idsel INTO l_flex_num;
6528: IF csr_cwk_scl_idsel%NOTFOUND THEN
6529: l_scl_hide_flag := 'Y';

Line 6597: hr_utility.set_location('if p_assignment_type = C then:'||l_proc,30);

6593: l_object_version_number:=p_object_version_number;
6594: l_validate := p_validate;
6595:
6596: if p_assignment_type = 'C' then
6597: hr_utility.set_location('if p_assignment_type = C then:'||l_proc,30);
6598: l_add_struct_k.extend(1);
6599: l_add_struct_k(l_add_struct_k.count) := 'SCL';
6600: hr_kflex_utility.create_ignore_kf_validation(p_rec => l_add_struct_k);
6601: --

Line 6904: hr_utility.set_location('if p_element_changed is null then:'||l_proc,35);

6900: --
6901: -- since p_element_changed is null, the warning has not already been
6902: -- raised, so raise it
6903: --
6904: hr_utility.set_location('if p_element_changed is null then:'||l_proc,35);
6905: p_element_changed:='W';
6906: --fnd_message.set_name('PER', 'HR_ELEMENT_CHANGED_WARNING_WEB');
6907: --hr_utility.raise_error;
6908: -- Should add page level warning

Line 6907: --hr_utility.raise_error;

6903: --
6904: hr_utility.set_location('if p_element_changed is null then:'||l_proc,35);
6905: p_element_changed:='W';
6906: --fnd_message.set_name('PER', 'HR_ELEMENT_CHANGED_WARNING_WEB');
6907: --hr_utility.raise_error;
6908: -- Should add page level warning
6909: /*hr_errors_api.addErrorToTable
6910: (p_errorfield => null
6911: ,p_errorcode => to_char(SQLCODE)

Line 6928: hr_utility.raise_error;

6924: -- we want a error, so raise one.
6925: --
6926: -- Should add page level warning
6927: fnd_message.set_name('PER', 'HR_ELEMENT_CHANGED_WEB');
6928: hr_utility.raise_error;
6929: /*hr_errors_api.addErrorToTable
6930: (p_errorfield => null
6931: ,p_errorcode => to_char(SQLCODE)
6932: ,p_errormsg => hr_util_misc_web.return_msg_text

Line 6992: -- hr_utility.raise_error;

6988: ,p_application_id => 'PER')
6989: );*/
6990: -- l_validate:=TRUE;
6991: -- fnd_message.set_name('PER', 'HR_JOB_CHANGES_WC_RATE_WEB');
6992: -- hr_utility.raise_error;
6993: -- end if;
6994: -- end if; --end check wc_code
6995: --
6996: -- if there is no manager in the organization now then raise a warning

Line 7001: hr_utility.raise_error;

6997: --
6998: /*if (l_org_now_no_manager_warning) then
6999: --Should add page level warning
7000: fnd_message.set_name('PER','HR_51124_MMV_NO_MGR_EXIST_ORG');
7001: hr_utility.raise_error;
7002: hr_errors_api.addErrorToTable
7003: (p_errorfield => null
7004: ,p_errormsg => fnd_message.get
7005: ,p_warningflag => TRUE);

Line 7013: hr_utility.raise_error;

7009: --
7010: /*if (l_other_manager_warning) then
7011: --Should add page level warning
7012: fnd_message.set_name('PER','HR_51125_MMV_MRE_MRG_EXIST_ORG');
7013: hr_utility.raise_error;
7014: hr_errors_api.addErrorToTable
7015: (p_errorfield => null
7016: ,p_errormsg => fnd_message.get
7017: ,p_warningflag => TRUE);

Line 7165: --hr_utility.raise_error;

7161: --
7162: /*if(l_org_now_no_manager_warning) then
7163: --Should add page level warning
7164: --fnd_message.set_name('PER','HR_51124_MMV_NO_MGR_EXIST_ORG');
7165: --hr_utility.raise_error;
7166: hr_errors_api.addErrorToTable
7167: (p_errorfield => null
7168: ,p_errormsg => fnd_message.get
7169: ,p_warningflag => TRUE);

Line 7174: --hr_utility.raise_error;

7170: end if;
7171: if(l_other_manager_warning) then
7172: --Should add page level warning
7173: --fnd_message.set_name('PER','HR_51125_MMV_MRE_MRG_EXIST_ORG');
7174: --hr_utility.raise_error;
7175: hr_errors_api.addErrorToTable
7176: (p_errorfield => null
7177: ,p_errormsg => fnd_message.get
7178: ,p_warningflag => TRUE);

Line 7223: hr_utility.set_location('if l_assignment_status_type=ACTIVE_ASSIGN then:'||l_proc,40);

7219: if l_assignment_status_type='ACTIVE_ASSIGN' then
7220: --
7221: -- active emp assignment
7222: --
7223: hr_utility.set_location('if l_assignment_status_type=ACTIVE_ASSIGN then:'||l_proc,40);
7224: hr_assignment_api.activate_emp_asg
7225: (p_effective_date => l_effective_date
7226: ,p_datetrack_update_mode => 'CORRECTION'
7227: ,p_assignment_id => p_assignment_id

Line 7286: hr_utility.set_location('if(lb_grd_ldr_exists_flag) then:'||l_proc,45);

7282: p_effective_date => l_effective_date,
7283: p_grd_ldr_exists_flag => lb_grd_ldr_exists_flag);
7284: -- may be required to add grade or step or ladder change condition
7285: if(lb_grd_ldr_exists_flag) then
7286: hr_utility.set_location('if(lb_grd_ldr_exists_flag) then:'||l_proc,45);
7287: hr_pay_rate_gsp_ss.get_employee_salary(
7288: p_assignment_id => p_assignment_id,
7289: P_effective_date => l_effective_date,
7290: p_ltt_salary_data => p_ltt_salary_data);

Line 7302: hr_utility.set_location('if l_validate=TRUE then:rollback'||l_proc,50);

7298: --
7299: -- if we are in validate only mode, rollback
7300: --
7301: if l_validate=TRUE then
7302: hr_utility.set_location('if l_validate=TRUE then:rollback'||l_proc,50);
7303: rollback to validate_assignment;
7304: end if;
7305:
7306: --

Line 7311: hr_utility.set_location('Exception:Others'||l_proc,555);

7307: -- handle any errors that are raised.
7308: --
7309: exception
7310: when others then
7311: hr_utility.set_location('Exception:Others'||l_proc,555);
7312: rollback to validate_assignment;
7313: --hr_utility.raise_error;
7314: raise;
7315: --hr_message.provide_error;

Line 7313: --hr_utility.raise_error;

7309: exception
7310: when others then
7311: hr_utility.set_location('Exception:Others'||l_proc,555);
7312: rollback to validate_assignment;
7313: --hr_utility.raise_error;
7314: raise;
7315: --hr_message.provide_error;
7316: --Should add page level error
7317: /*hr_errors_api.addErrorToTable

Line 7337: hr_utility.set_location('Entering:'||l_proc, 5);

7333: l_old_pay_basis_id number;
7334: l_old_grade_id number;
7335:
7336: begin
7337: hr_utility.set_location('Entering:'||l_proc, 5);
7338:
7339: -- Fetch Original Manager Flag
7340: l_old_mgr_flag := hr_transaction_api.get_original_varchar2_value(p_transaction_step_id,'P_MANAGER_FLAG');
7341: -- Fetch Original Labour Union Flag

Line 7352: hr_utility.set_location('IF (asgRec.name.count < 108) THEN:'||l_proc,10);

7348: (p_transaction_step_id => p_transaction_step_id
7349: ,p_transaction_data => asgRec);
7350:
7351: IF (asgRec.name.count < 108) THEN
7352: hr_utility.set_location('IF (asgRec.name.count < 108) THEN:'||l_proc,10);
7353: BEGIN
7354: hr_utility.set_location('Entering For Loop:'||l_proc,15);
7355: FOR I in asgRec.name.count+1 .. 108 LOOP
7356: asgRec.name(I) := null;

Line 7354: hr_utility.set_location('Entering For Loop:'||l_proc,15);

7350:
7351: IF (asgRec.name.count < 108) THEN
7352: hr_utility.set_location('IF (asgRec.name.count < 108) THEN:'||l_proc,10);
7353: BEGIN
7354: hr_utility.set_location('Entering For Loop:'||l_proc,15);
7355: FOR I in asgRec.name.count+1 .. 108 LOOP
7356: asgRec.name(I) := null;
7357: asgRec.number_value(I) := null;
7358: asgRec.varchar2_value(I) := null;

Line 7361: hr_utility.set_location('Exiting For Loop:'||l_proc,15);

7357: asgRec.number_value(I) := null;
7358: asgRec.varchar2_value(I) := null;
7359: asgRec.date_value(I) := null;
7360: END LOOP;
7361: hr_utility.set_location('Exiting For Loop:'||l_proc,15);
7362: END;
7363: END IF;
7364:
7365: open csr for

Line 7530: hr_utility.set_location('Exiting:'||l_proc, 20);

7526: and (trunc(sysdate) between nvl(hl_bargaining_unit.start_date_active(+), trunc(sysdate))
7527: and nvl(hl_bargaining_unit.end_date_active(+), trunc(sysdate)));
7528:
7529:
7530: hr_utility.set_location('Exiting:'||l_proc, 20);
7531: return csr;
7532: END;
7533:
7534: FUNCTION get_rec_cnt

Line 7538: hr_utility.set_location('Entering:get_rec_cnt', 5);

7534: FUNCTION get_rec_cnt
7535: RETURN NUMBER IS
7536: Cnt NUMBER:= 1;
7537: BEGIN
7538: hr_utility.set_location('Entering:get_rec_cnt', 5);
7539: hr_utility.set_location('Exiting:get_rec_cnt', 10);
7540: RETURN Cnt;
7541: END;
7542: --

Line 7539: hr_utility.set_location('Exiting:get_rec_cnt', 10);

7535: RETURN NUMBER IS
7536: Cnt NUMBER:= 1;
7537: BEGIN
7538: hr_utility.set_location('Entering:get_rec_cnt', 5);
7539: hr_utility.set_location('Exiting:get_rec_cnt', 10);
7540: RETURN Cnt;
7541: END;
7542: --
7543:

Line 7590: hr_utility.set_location('Entering:'||l_proc, 5);

7586: l_po_number po_temp_labor_headers_v.po_number%TYPE;
7587: l_proc varchar2(72) := g_package||'get_po_number';
7588:
7589: BEGIN
7590: hr_utility.set_location('Entering:'||l_proc, 5);
7591: open csr_po_number(p_po_header_id);
7592: fetch csr_po_number into l_po_number;
7593: close csr_po_number;
7594:

Line 7595: hr_utility.set_location('Exiting:'||l_proc, 15);

7591: open csr_po_number(p_po_header_id);
7592: fetch csr_po_number into l_po_number;
7593: close csr_po_number;
7594:
7595: hr_utility.set_location('Exiting:'||l_proc, 15);
7596: return l_po_number;
7597: END;
7598:
7599: FUNCTION get_po_line_nuber(p_po_line_id in number)

Line 7610: hr_utility.set_location('Entering:'||l_proc, 5);

7606: l_po_line_number number;
7607: l_proc varchar2(72) := g_package||'get_po_line_nuber';
7608:
7609: BEGIN
7610: hr_utility.set_location('Entering:'||l_proc, 5);
7611: open csr_po_line_number(p_po_line_id);
7612: fetch csr_po_line_number into l_po_line_number;
7613: close csr_po_line_number;
7614:

Line 7616: hr_utility.set_location('Exiting:'||l_proc, 15);

7612: fetch csr_po_line_number into l_po_line_number;
7613: close csr_po_line_number;
7614:
7615:
7616: hr_utility.set_location('Exiting:'||l_proc, 15);
7617: return l_po_line_number;
7618: END;
7619:
7620: FUNCTION get_vend_site_name(p_vendor_site_id in number)

Line 7631: hr_utility.set_location('Entering:'||l_proc, 5);

7627: l_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
7628: l_proc varchar2(72) := g_package||'get_vend_site_name';
7629:
7630: BEGIN
7631: hr_utility.set_location('Entering:'||l_proc, 5);
7632: open csr_vendor_site_name(p_vendor_site_id);
7633: fetch csr_vendor_site_name into l_vendor_site_name;
7634: close csr_vendor_site_name;
7635:

Line 7637: hr_utility.set_location('Exiting:'||l_proc, 15);

7633: fetch csr_vendor_site_name into l_vendor_site_name;
7634: close csr_vendor_site_name;
7635:
7636:
7637: hr_utility.set_location('Exiting:'||l_proc, 15);
7638: return l_vendor_site_name;
7639: END;
7640:
7641: -- End of NTF change