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

Line 48: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

44: BEGIN
45: --
46: l_proc_name := 'pay_cn_ext.initialize_globals';
47:
48: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
49:
50: l_request_id := fnd_global.conc_request_id;
51:
52: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);

Line 52: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);

48: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
49:
50: l_request_id := fnd_global.conc_request_id;
51:
52: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
53:
54: hr_utility.set_location('China : Inserting into pay_action_information ', 30);
55:
56: -- Insert the parameters into pay_action_information table so that

Line 54: hr_utility.set_location('China : Inserting into pay_action_information ', 30);

50: l_request_id := fnd_global.conc_request_id;
51:
52: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
53:
54: hr_utility.set_location('China : Inserting into pay_action_information ', 30);
55:
56: -- Insert the parameters into pay_action_information table so that
57: -- the parameters are available to other threads based on the request ID
58: --

Line 93: hr_utility.set_location('China : Inserted into pay_action_information ', 40);

89:
90:
91: COMMIT;
92:
93: hr_utility.set_location('China : Inserted into pay_action_information ', 40);
94:
95: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
96:
97: EXCEPTION

Line 95: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);

91: COMMIT;
92:
93: hr_utility.set_location('China : Inserted into pay_action_information ', 40);
94:
95: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);

Line 99: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);

95: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);
100: RAISE;
101:
102: END initialize_globals;
103:

Line 131: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

127: BEGIN
128: --
129: l_proc_name := 'pay_cn_ext.delete_globals';
130:
131: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
132:
133: l_request_id := fnd_global.conc_request_id;
134:
135: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);

Line 135: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);

131: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
132:
133: l_request_id := fnd_global.conc_request_id;
134:
135: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
136:
137: hr_utility.set_location('China : Deleting row pay_action_information ', 30);
138:
139: -- Delete from Pay_action_information

Line 137: hr_utility.set_location('China : Deleting row pay_action_information ', 30);

133: l_request_id := fnd_global.conc_request_id;
134:
135: hr_utility.set_location('China : Request ID -> '||l_request_id, 20);
136:
137: hr_utility.set_location('China : Deleting row pay_action_information ', 30);
138:
139: -- Delete from Pay_action_information
140: --
141: DELETE FROM pay_action_information

Line 148: hr_utility.set_location('China : Deleted from pay_action_information ', 40);

144: AND action_information_category = 'EXT_INFO';
145:
146: COMMIT;
147:
148: hr_utility.set_location('China : Deleted from pay_action_information ', 40);
149:
150: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
151:
152: EXCEPTION

Line 150: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);

146: COMMIT;
147:
148: hr_utility.set_location('China : Deleted from pay_action_information ', 40);
149:
150: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);

Line 154: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);

150: hr_utility.set_location('China : Leaving -> '||l_proc_name, 10);
151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);
155: RAISE;
156:
157: END delete_globals;
158:

Line 253: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

249: BEGIN
250: --
251: l_proc_name := 'pay_cn_ext.get_globals';
252:
253: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
254:
255: l_request_id := fnd_global.conc_request_id;
256:
257: hr_utility.set_location('China : Process Request ID -> '||l_request_id, 20);

Line 257: hr_utility.set_location('China : Process Request ID -> '||l_request_id, 20);

253: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
254:
255: l_request_id := fnd_global.conc_request_id;
256:
257: hr_utility.set_location('China : Process Request ID -> '||l_request_id, 20);
258:
259: -- Get parent request id
260: --
261: OPEN csr_parent_req_id (l_request_id);

Line 266: hr_utility.set_location('China : Parent Request ID -> '||l_parent_id, 30);

262: FETCH csr_parent_req_id
263: INTO l_parent_id;
264: CLOSE csr_parent_req_id;
265:
266: hr_utility.set_location('China : Parent Request ID -> '||l_parent_id, 30);
267:
268: hr_utility.set_location('China : Before csr_ext_info ', 40);
269:
270: -- Get Parameter Values

Line 268: hr_utility.set_location('China : Before csr_ext_info ', 40);

264: CLOSE csr_parent_req_id;
265:
266: hr_utility.set_location('China : Parent Request ID -> '||l_parent_id, 30);
267:
268: hr_utility.set_location('China : Before csr_ext_info ', 40);
269:
270: -- Get Parameter Values
271: --
272: OPEN csr_ext_info (l_request_id

Line 287: hr_utility.set_location('China : After csr_ext_info ', 50);

283: ,l_report_type;
284:
285: CLOSE csr_ext_info;
286:
287: hr_utility.set_location('China : After csr_ext_info ', 50);
288:
289: -- Copy the local variables into OUT parameters
290: --
291: p_phf_si_type := l_phf_si_type;

Line 301: hr_utility.set_location('China : Leaving -> '||l_proc_name, 60);

297: p_contribution_year := l_contribution_year;
298: p_filling_date := l_filling_date;
299: p_report_type := l_report_type;
300:
301: hr_utility.set_location('China : Leaving -> '||l_proc_name, 60);
302:
303: EXCEPTION
304: WHEN OTHERS THEN
305: IF csr_ext_info%ISOPEN THEN

Line 343: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

339: BEGIN
340: --
341: l_proc_name := 'pay_cn_ext.get_element_name';
342:
343: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
344:
345: -- Set l_element_name depending on the value of l_phf_si_type
346: --
347: IF p_phf_si_type = 'INJURY' THEN

Line 386: hr_utility.set_location('China : l_phf_si_type -> ' || p_phf_si_type , 20);

382:
383: --
384: END IF;
385:
386: hr_utility.set_location('China : l_phf_si_type -> ' || p_phf_si_type , 20);
387: hr_utility.set_location('China : l_element_name -> ' || l_element_name , 30);
388: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 40);
389:
390: RETURN l_element_name;

Line 387: hr_utility.set_location('China : l_element_name -> ' || l_element_name , 30);

383: --
384: END IF;
385:
386: hr_utility.set_location('China : l_phf_si_type -> ' || p_phf_si_type , 20);
387: hr_utility.set_location('China : l_element_name -> ' || l_element_name , 30);
388: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 40);
389:
390: RETURN l_element_name;
391: --

Line 388: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 40);

384: END IF;
385:
386: hr_utility.set_location('China : l_phf_si_type -> ' || p_phf_si_type , 20);
387: hr_utility.set_location('China : l_element_name -> ' || l_element_name , 30);
388: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 40);
389:
390: RETURN l_element_name;
391: --
392: END get_element_name;

Line 498: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

494: BEGIN
495: --
496: l_proc_name := 'pay_cn_ext.cb_extract_process';
497:
498: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
499:
500: hr_utility.set_location('China : Before csr_extract_def_id ', 20);
501:
502: -- Fetch Extract Definition Id

Line 500: hr_utility.set_location('China : Before csr_extract_def_id ', 20);

496: l_proc_name := 'pay_cn_ext.cb_extract_process';
497:
498: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
499:
500: hr_utility.set_location('China : Before csr_extract_def_id ', 20);
501:
502: -- Fetch Extract Definition Id
503: --
504: OPEN csr_extract_def_id;

Line 511: hr_utility.set_location('China : Extract Definition not Found ' , 30);

507:
508: -- If Extract Definition does not exist return
509: IF csr_extract_def_id%NOTFOUND THEN
510: --
511: hr_utility.set_location('China : Extract Definition not Found ' , 30);
512: CLOSE csr_extract_def_id;
513: RETURN;
514: --
515: END IF;

Line 520: hr_utility.set_location('China : After csr_extract_def_id ', 40);

516: --
517:
518: CLOSE csr_extract_def_id;
519:
520: hr_utility.set_location('China : After csr_extract_def_id ', 40);
521:
522: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);

Line 522: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);

518: CLOSE csr_extract_def_id;
519:
520: hr_utility.set_location('China : After csr_extract_def_id ', 40);
521:
522: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);

Line 523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);

519:
520: hr_utility.set_location('China : After csr_extract_def_id ', 40);
521:
522: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);

Line 524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);

520: hr_utility.set_location('China : After csr_extract_def_id ', 40);
521:
522: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);

Line 525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);

521:
522: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
529: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);

Line 526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);

522: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
529: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
530:

Line 527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);

523: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
529: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
530:
531: hr_utility.set_location('China : Before csr_start_month ', 50);

Line 528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);

524: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
529: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
530:
531: hr_utility.set_location('China : Before csr_start_month ', 50);
532:

Line 529: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);

525: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
526: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
529: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
530:
531: hr_utility.set_location('China : Before csr_start_month ', 50);
532:
533: -- Calculation of the start_date

Line 531: hr_utility.set_location('China : Before csr_start_month ', 50);

527: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
528: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
529: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
530:
531: hr_utility.set_location('China : Before csr_start_month ', 50);
532:
533: -- Calculation of the start_date
534: --
535: OPEN csr_start_month;

Line 543: hr_utility.set_location('China : Switch Period Month not found ' , 55);

539: -- If Switch month is not found
540: --
541: IF csr_start_month%NOTFOUND THEN
542: --
543: hr_utility.set_location('China : Switch Period Month not found ' , 55);
544: CLOSE csr_start_month;
545: RETURN;
546: --
547: END IF;

Line 552: hr_utility.set_location('China : After csr_start_month ', 60);

548: --
549:
550: CLOSE csr_start_month;
551:
552: hr_utility.set_location('China : After csr_start_month ', 60);
553:
554: -- Set the first Day of the Switch Month as the Start Date for the report
555: l_start_date := TO_DATE( '01-'||l_start_month||'-'||p_contribution_year , 'DD-MM-YYYY');
556:

Line 557: hr_utility.set_location('China : l_start_date -> '|| l_start_date , 70);

553:
554: -- Set the first Day of the Switch Month as the Start Date for the report
555: l_start_date := TO_DATE( '01-'||l_start_month||'-'||p_contribution_year , 'DD-MM-YYYY');
556:
557: hr_utility.set_location('China : l_start_date -> '|| l_start_date , 70);
558:
559: -- Add 11 months to the start date to get the end date
560: l_end_date := LAST_DAY(ADD_MONTHS(l_start_date,11));
561:

Line 562: hr_utility.set_location('China : l_end_date -> '|| l_end_date , 80);

558:
559: -- Add 11 months to the start date to get the end date
560: l_end_date := LAST_DAY(ADD_MONTHS(l_start_date,11));
561:
562: hr_utility.set_location('China : l_end_date -> '|| l_end_date , 80);
563:
564: -- Set Global Variables
565: --
566:

Line 579: hr_utility.set_location('China : Check whether Legal Employer has fixed amount for given Contribution Area ', 85);

575: , p_report_type => 'CB'
576: );
577: --
578:
579: hr_utility.set_location('China : Check whether Legal Employer has fixed amount for given Contribution Area ', 85);
580:
581: --
582: -- Bug 3593118
583: -- Enterprise Annuity - Added new parameter p_assignment_id in call to

Line 610: hr_utility.set_location('China : Legal Employer has fixed amount for given Contribution Area ', 90);

606: IF l_message = 'SUCCESS' THEN
607: --
608: IF (l_er_rate_type <> 'PERCENTAGE') OR (l_ee_rate_type <> 'PERCENTAGE') THEN
609: --
610: hr_utility.set_location('China : Legal Employer has fixed amount for given Contribution Area ', 90);
611: RETURN;
612: --
613: END IF;
614: --

Line 617: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 100);

613: END IF;
614: --
615: END IF;
616:
617: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 100);
618:
619:
620: -- Call the Extract Process
621: --

Line 634: hr_utility.set_location('China : Leaving -> '|| l_proc_name, 120);

630: -- Delete the globals stored in the table
631: --
632: delete_globals;
633:
634: hr_utility.set_location('China : Leaving -> '|| l_proc_name, 120);
635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: delete_globals;

Line 647: hr_utility.set_location('China Exception, Leaving: '||l_proc_name, 130);

643: IF csr_start_month%ISOPEN THEN
644: CLOSE csr_start_month;
645: END IF;
646:
647: hr_utility.set_location('China Exception, Leaving: '||l_proc_name, 130);
648: RAISE;
649: END cb_extract_process;
650:
651: ----------------------------------------------------------------------------

Line 717: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

713: BEGIN
714: --
715: l_proc_name := 'pay_cn_ext.ca_extract_process';
716:
717: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
718:
719: hr_utility.set_location('China : Before csr_extract_def_id ', 20);
720:
721: -- Fetch Extract Definition Id

Line 719: hr_utility.set_location('China : Before csr_extract_def_id ', 20);

715: l_proc_name := 'pay_cn_ext.ca_extract_process';
716:
717: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
718:
719: hr_utility.set_location('China : Before csr_extract_def_id ', 20);
720:
721: -- Fetch Extract Definition Id
722: --
723: OPEN csr_extract_def_id;

Line 730: hr_utility.set_location('China : Extract Definition not Found ' , 30);

726:
727: -- If Extract Definition does not exist return
728: IF csr_extract_def_id%NOTFOUND THEN
729: --
730: hr_utility.set_location('China : Extract Definition not Found ' , 30);
731: CLOSE csr_extract_def_id;
732: RETURN;
733: --
734: END IF;

Line 739: hr_utility.set_location('China : After csr_extract_def_id ', 40);

735: --
736:
737: CLOSE csr_extract_def_id;
738:
739: hr_utility.set_location('China : After csr_extract_def_id ', 40);
740:
741: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);

Line 741: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);

737: CLOSE csr_extract_def_id;
738:
739: hr_utility.set_location('China : After csr_extract_def_id ', 40);
740:
741: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);

Line 742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);

738:
739: hr_utility.set_location('China : After csr_extract_def_id ', 40);
740:
741: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);

Line 743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);

739: hr_utility.set_location('China : After csr_extract_def_id ', 40);
740:
741: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
747: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);

Line 744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);

740:
741: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
747: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
748: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);

Line 745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);

741: hr_utility.set_location('China : l_extract_def_id -> ' || l_extract_def_id , 45);
742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
747: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
748: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
749:

Line 746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);

742: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 45);
743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
747: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
748: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
749:
750: -- Calculation of the start_date and end_date

Line 747: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);

743: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 45);
744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
747: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
748: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
749:
750: -- Calculation of the start_date and end_date
751:

Line 748: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);

744: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 45);
745: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 45);
746: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 45);
747: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 45);
748: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 45);
749:
750: -- Calculation of the start_date and end_date
751:
752: l_start_date := to_date( ('01-'||p_contribution_month||'-'||p_contribution_year) , 'DD-MM-YYYY');

Line 753: hr_utility.set_location('China : l_start_date -> '|| l_start_date , 50);

749:
750: -- Calculation of the start_date and end_date
751:
752: l_start_date := to_date( ('01-'||p_contribution_month||'-'||p_contribution_year) , 'DD-MM-YYYY');
753: hr_utility.set_location('China : l_start_date -> '|| l_start_date , 50);
754:
755: l_end_date := LAST_DAY(l_start_date);
756: hr_utility.set_location('China : l_end_date -> '|| l_end_date , 50);
757:

Line 756: hr_utility.set_location('China : l_end_date -> '|| l_end_date , 50);

752: l_start_date := to_date( ('01-'||p_contribution_month||'-'||p_contribution_year) , 'DD-MM-YYYY');
753: hr_utility.set_location('China : l_start_date -> '|| l_start_date , 50);
754:
755: l_end_date := LAST_DAY(l_start_date);
756: hr_utility.set_location('China : l_end_date -> '|| l_end_date , 50);
757:
758: -- Set Global Variables
759: --
760:

Line 772: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);

768: , p_filling_date => null
769: , p_report_type => 'CA'
770: );
771:
772: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);
773:
774: -- Call the Extract Process
775: --
776: ben_ext_thread.process ( errbuf => l_errbuf

Line 788: hr_utility.set_location('China : Leaving -> '|| l_proc_name, 70);

784: -- Delete the globals stored in the table
785: --
786: delete_globals;
787:
788: hr_utility.set_location('China : Leaving -> '|| l_proc_name, 70);
789: --
790: EXCEPTION
791: --
792: WHEN OTHERS THEN

Line 798: hr_utility.set_location('China Exception, Leaving: '||l_proc_name, 80);

794: IF csr_extract_def_id%ISOPEN THEN
795: CLOSE csr_extract_def_id;
796: END IF;
797:
798: hr_utility.set_location('China Exception, Leaving: '||l_proc_name, 80);
799: RAISE;
800:
801: END ca_extract_process;
802:

Line 869: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

865: BEGIN
866: --
867: l_proc_name := 'pay_cn_ext.em_extract_process';
868:
869: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
870:
871: hr_utility.set_location('China : Before csr_extract_def_id ', 20);
872:
873: -- Fetch Extract Definition Id

Line 871: hr_utility.set_location('China : Before csr_extract_def_id ', 20);

867: l_proc_name := 'pay_cn_ext.em_extract_process';
868:
869: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
870:
871: hr_utility.set_location('China : Before csr_extract_def_id ', 20);
872:
873: -- Fetch Extract Definition Id
874: --
875: OPEN csr_extract_def_id;

Line 882: hr_utility.set_location('China : Extract Definition not Found ' , 30);

878:
879: -- If Extract Definition does not exist return
880: IF csr_extract_def_id%NOTFOUND THEN
881: --
882: hr_utility.set_location('China : Extract Definition not Found ' , 30);
883: CLOSE csr_extract_def_id;
884: RETURN;
885: --
886: END IF;

Line 892: hr_utility.set_location('China : p_extract_def_id -> ' || l_extract_def_id , 40);

888: -- Bug 3448316 caused this change
889: l_filling_date:=fnd_date.canonical_to_date(p_filling_date);
890: --
891:
892: hr_utility.set_location('China : p_extract_def_id -> ' || l_extract_def_id , 40);
893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);
894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);
895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);

Line 893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);

889: l_filling_date:=fnd_date.canonical_to_date(p_filling_date);
890: --
891:
892: hr_utility.set_location('China : p_extract_def_id -> ' || l_extract_def_id , 40);
893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);
894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);
895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);

Line 894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);

890: --
891:
892: hr_utility.set_location('China : p_extract_def_id -> ' || l_extract_def_id , 40);
893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);
894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);
895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);
898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);

Line 895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);

891:
892: hr_utility.set_location('China : p_extract_def_id -> ' || l_extract_def_id , 40);
893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);
894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);
895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);
898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);
899: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 40);

Line 896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);

892: hr_utility.set_location('China : p_extract_def_id -> ' || l_extract_def_id , 40);
893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);
894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);
895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);
898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);
899: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 40);
900: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 40);

Line 897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);

893: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 40);
894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);
895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);
898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);
899: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 40);
900: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 40);
901:

Line 898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);

894: hr_utility.set_location('China : p_start_date -> ' || l_start_date , 40);
895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);
898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);
899: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 40);
900: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 40);
901:
902: -- Calculation of the start_date and end_date

Line 899: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 40);

895: hr_utility.set_location('China : p_end_date -> ' || l_end_date , 40);
896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);
898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);
899: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 40);
900: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 40);
901:
902: -- Calculation of the start_date and end_date
903:

Line 900: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 40);

896: hr_utility.set_location('China : p_legal_employer_id -> ' || p_legal_employer_id , 40);
897: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 40);
898: hr_utility.set_location('China : p_filling_date -> ' || l_filling_date , 40);
899: hr_utility.set_location('China : p_contribution_area -> ' || p_contribution_area , 40);
900: hr_utility.set_location('China : p_contribution_year -> ' || p_contribution_year , 40);
901:
902: -- Calculation of the start_date and end_date
903:
904: l_start_date := TO_DATE( ('01-'||p_contribution_month||'-'||p_contribution_year) , 'DD-MM-YYYY');

Line 905: hr_utility.set_location('China l_start_date -> '|| l_start_date , 50);

901:
902: -- Calculation of the start_date and end_date
903:
904: l_start_date := TO_DATE( ('01-'||p_contribution_month||'-'||p_contribution_year) , 'DD-MM-YYYY');
905: hr_utility.set_location('China l_start_date -> '|| l_start_date , 50);
906:
907: l_end_date := LAST_DAY(l_start_date);
908: hr_utility.set_location('China l_end_date -> '|| l_end_date , 50);
909:

Line 908: hr_utility.set_location('China l_end_date -> '|| l_end_date , 50);

904: l_start_date := TO_DATE( ('01-'||p_contribution_month||'-'||p_contribution_year) , 'DD-MM-YYYY');
905: hr_utility.set_location('China l_start_date -> '|| l_start_date , 50);
906:
907: l_end_date := LAST_DAY(l_start_date);
908: hr_utility.set_location('China l_end_date -> '|| l_end_date , 50);
909:
910: -- Set Global Variables
911: --
912:

Line 925: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);

921: -- bug 3448316 caused change from p_filling_date to l_filling_date
922: , p_report_type => 'EM'
923:
924: );
925: hr_utility.set_location('China : Calling -> ben_ext_thread.process', 60);
926:
927: ben_ext_thread.process ( errbuf => l_errbuf
928: , retcode => l_retcode
929: , p_benefit_action_id => NULL

Line 939: hr_utility.set_location('China : Leaving -> '|| l_proc_name, 70);

935: -- Delete the globals stored in the table
936: --
937: delete_globals;
938:
939: hr_utility.set_location('China : Leaving -> '|| l_proc_name, 70);
940: --
941: EXCEPTION
942: --
943: WHEN OTHERS THEN

Line 949: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 80);

945: IF csr_extract_def_id%ISOPEN THEN
946: CLOSE csr_extract_def_id;
947: END IF;
948:
949: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 80);
950: RAISE;
951: --
952: END em_extract_process;
953:

Line 1033: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

1029: l_expat_indicator := 'Y';
1030: l_proc_name := 'pay_cn_ext.cb_criteria_profile';
1031: l_return_value := 'N';
1032:
1033: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1034:
1035:
1036: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1037: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);

Line 1036: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);

1032:
1033: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1034:
1035:
1036: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1037: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1038: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1039:
1040: -- Get Globals

Line 1037: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);

1033: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1034:
1035:
1036: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1037: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1038: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1039:
1040: -- Get Globals
1041: --

Line 1038: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);

1034:
1035:
1036: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1037: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1038: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1039:
1040: -- Get Globals
1041: --
1042: get_globals ( p_phf_si_type => l_phf_si_type

Line 1058: hr_utility.set_location('China : Business Group does not match' , 30);

1054: -- business group id. If not return 'N'
1055: --
1056: IF (p_business_group_id <> l_business_group_id) THEN
1057: --
1058: hr_utility.set_location('China : Business Group does not match' , 30);
1059: RETURN l_return_value;
1060: --
1061: END IF;
1062: --

Line 1072: hr_utility.set_location('China : Assignment not valid' , 40);

1068: -- Check for valid assignment
1069: --
1070: IF csr_valid_assignment%NOTFOUND THEN
1071: -- Assignment is not live
1072: hr_utility.set_location('China : Assignment not valid' , 40);
1073: CLOSE csr_valid_assignment;
1074: RETURN l_return_value;
1075: --
1076: ELSE

Line 1085: hr_utility.set_location('China : Legal Employer/Expat Ind mismatch', 50);

1081: -- then the assignment is not be included
1082: --
1083: IF (l_expat_indicator = 'Y') OR (l_assg_legal_employer <> l_legal_employer_id) THEN
1084: --
1085: hr_utility.set_location('China : Legal Employer/Expat Ind mismatch', 50);
1086: CLOSE csr_valid_assignment;
1087: RETURN l_return_value;
1088: --
1089: END IF;

Line 1098: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);

1094: CLOSE csr_valid_assignment;
1095:
1096: -- 3411840, Check the assignment's Override Contribution area is same as the concurrent parameter
1097: l_element_name := get_element_name(l_phf_si_type);
1098: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);
1099:
1100: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1101: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1102:

Line 1101: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);

1097: l_element_name := get_element_name(l_phf_si_type);
1098: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);
1099:
1100: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1101: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1102:
1103: IF l_cont_area IS NULL THEN
1104: -- Check the assignment's Contribution area is same as the concurrent parameter
1105: -- Set the contexts

Line 1112: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);

1108:
1109: -- Run the DBI
1110: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1111:
1112: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);
1113:
1114: END IF;
1115:
1116: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);

Line 1116: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);

1112: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);
1113:
1114: END IF;
1115:
1116: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1117: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 60);
1118:
1119: IF l_cont_area <> l_contribution_area THEN
1120: --

Line 1117: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 60);

1113:
1114: END IF;
1115:
1116: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1117: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 60);
1118:
1119: IF l_cont_area <> l_contribution_area THEN
1120: --
1121: hr_utility.set_location('China : Cont Area does not match' , 90);

Line 1121: hr_utility.set_location('China : Cont Area does not match' , 90);

1117: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 60);
1118:
1119: IF l_cont_area <> l_contribution_area THEN
1120: --
1121: hr_utility.set_location('China : Cont Area does not match' , 90);
1122: RETURN l_return_value;
1123: --
1124: END IF;
1125: --

Line 1139: hr_utility.set_location('China : Element Entry not found ', 70);

1135: -- If element entry for the given PHF/SI Type does not exist for the assignment
1136: -- then the assignment is not eligible
1137: IF l_value = 'N' THEN
1138: --
1139: hr_utility.set_location('China : Element Entry not found ', 70);
1140: RETURN l_return_value;
1141: --
1142: END IF;
1143:

Line 1145: hr_utility.set_location('China : Check for PREV_MONTH ', 90);

1141: --
1142: END IF;
1143:
1144: --Bug 3411273, Check whether assignment action exist for PREV_MONTH
1145: hr_utility.set_location('China : Check for PREV_MONTH ', 90);
1146:
1147: l_mod_start_date := TRUNC(TRUNC(l_start_date,'MM')-1,'MM');
1148: l_mod_end_date := LAST_DAY(l_mod_start_date);
1149:

Line 1150: hr_utility.set_location('China : PREV_MONTH, l_mod_start_date '|| l_mod_start_date , 90);

1146:
1147: l_mod_start_date := TRUNC(TRUNC(l_start_date,'MM')-1,'MM');
1148: l_mod_end_date := LAST_DAY(l_mod_start_date);
1149:
1150: hr_utility.set_location('China : PREV_MONTH, l_mod_start_date '|| l_mod_start_date , 90);
1151: hr_utility.set_location('China : PREV_MONTH, l_mod_end_date '|| l_mod_end_date , 90);
1152:
1153: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_mod_start_date,l_mod_end_date);
1154: IF l_value = 'N' THEN

Line 1151: hr_utility.set_location('China : PREV_MONTH, l_mod_end_date '|| l_mod_end_date , 90);

1147: l_mod_start_date := TRUNC(TRUNC(l_start_date,'MM')-1,'MM');
1148: l_mod_end_date := LAST_DAY(l_mod_start_date);
1149:
1150: hr_utility.set_location('China : PREV_MONTH, l_mod_start_date '|| l_mod_start_date , 90);
1151: hr_utility.set_location('China : PREV_MONTH, l_mod_end_date '|| l_mod_end_date , 90);
1152:
1153: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_mod_start_date,l_mod_end_date);
1154: IF l_value = 'N' THEN
1155: hr_utility.set_location('China : Assignment Actions not found ', 90);

Line 1155: hr_utility.set_location('China : Assignment Actions not found ', 90);

1151: hr_utility.set_location('China : PREV_MONTH, l_mod_end_date '|| l_mod_end_date , 90);
1152:
1153: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_mod_start_date,l_mod_end_date);
1154: IF l_value = 'N' THEN
1155: hr_utility.set_location('China : Assignment Actions not found ', 90);
1156: RETURN l_return_value;
1157: END IF;
1158:
1159:

Line 1162: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 110);

1158:
1159:
1160: -- Assignment should be included
1161: l_return_value := 'Y';
1162: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 110);
1163:
1164: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);
1165:
1166: RETURN l_return_value;

Line 1164: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);

1160: -- Assignment should be included
1161: l_return_value := 'Y';
1162: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 110);
1163:
1164: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);
1165:
1166: RETURN l_return_value;
1167:
1168: --

Line 1178: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 130);

1174: CLOSE csr_valid_assignment;
1175: --
1176: END IF;
1177:
1178: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 130);
1179: RAISE;
1180: --
1181: END cb_criteria_profile;
1182:

Line 1264: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

1260: l_expat_indicator := 'Y';
1261: l_return_value := 'N';
1262: l_proc_name := 'pay_cn_ext.ca_criteria_profile';
1263:
1264: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1265:
1266: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1267: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1268: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);

Line 1266: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);

1262: l_proc_name := 'pay_cn_ext.ca_criteria_profile';
1263:
1264: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1265:
1266: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1267: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1268: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1269:
1270: -- Get Globals

Line 1267: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);

1263:
1264: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1265:
1266: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1267: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1268: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1269:
1270: -- Get Globals
1271: --

Line 1268: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);

1264: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1265:
1266: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1267: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1268: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1269:
1270: -- Get Globals
1271: --
1272: get_globals ( p_phf_si_type => l_phf_si_type

Line 1288: hr_utility.set_location('China : Business Group does not match' , 30);

1284: -- business group id. If not return 'N'
1285: --
1286: IF (p_business_group_id <> l_business_group_id) THEN
1287: --
1288: hr_utility.set_location('China : Business Group does not match' , 30);
1289: RETURN l_return_value;
1290: --
1291: END IF;
1292: --

Line 1304: hr_utility.set_location('China : Assignment not valid' , 40);

1300: INTO l_expat_indicator,l_assg_legal_employer ;
1301:
1302: IF csr_valid_assignment%NOTFOUND THEN
1303: -- Assignment is not live
1304: hr_utility.set_location('China : Assignment not valid' , 40);
1305: CLOSE csr_valid_assignment;
1306: RETURN l_return_value;
1307: --
1308: ELSE

Line 1317: hr_utility.set_location('China : Legal Employer/Expat Ind mismatch', 50);

1313: -- then the assignment is not be included
1314: --
1315: IF (l_expat_indicator = 'Y') OR (l_assg_legal_employer <> l_legal_employer_id) THEN
1316: --
1317: hr_utility.set_location('China : Legal Employer/Expat Ind mismatch', 50);
1318: CLOSE csr_valid_assignment;
1319: RETURN l_return_value;
1320: --
1321: END IF;

Line 1331: hr_utility.set_location('China : l_element_name ->'|| l_element_name , 90);

1327:
1328: -- 3411840, Check the assignment's Override Contribution area is same as the concurrent parameter
1329: l_element_name := get_element_name(l_phf_si_type);
1330:
1331: hr_utility.set_location('China : l_element_name ->'|| l_element_name , 90);
1332:
1333: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1334:
1335: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);

Line 1335: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);

1331: hr_utility.set_location('China : l_element_name ->'|| l_element_name , 90);
1332:
1333: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1334:
1335: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);
1336:
1337: IF l_cont_area IS NULL THEN
1338: -- Check the assignment's Contribution area is same as the concurrent parameter
1339: -- Set the contexts

Line 1346: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);

1342:
1343: -- Run the DBI
1344: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1345:
1346: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);
1347:
1348: END IF;
1349:
1350: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);

Line 1350: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);

1346: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 80);
1347:
1348: END IF;
1349:
1350: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);
1351: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area , 90);
1352:
1353: IF l_cont_area <> l_contribution_area THEN
1354: --

Line 1351: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area , 90);

1347:
1348: END IF;
1349:
1350: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);
1351: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area , 90);
1352:
1353: IF l_cont_area <> l_contribution_area THEN
1354: --
1355: hr_utility.set_location('China : Cont Area does not match' , 90);

Line 1355: hr_utility.set_location('China : Cont Area does not match' , 90);

1351: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area , 90);
1352:
1353: IF l_cont_area <> l_contribution_area THEN
1354: --
1355: hr_utility.set_location('China : Cont Area does not match' , 90);
1356: RETURN l_return_value;
1357: --
1358: END IF;
1359: --

Line 1372: hr_utility.set_location('China : Element Entry not found ', 70);

1368: -- If element entry for the given PHF/SI Type does not exist for the assignment
1369: -- then the assignment is not eligible
1370: IF l_value = 'N' THEN
1371: --
1372: hr_utility.set_location('China : Element Entry not found ', 70);
1373: RETURN l_return_value;
1374: --
1375: END IF;
1376:

Line 1380: hr_utility.set_location('China : Assignment Actions not found ', 80);

1376:
1377: -- Bug 3411273, Check whether assignment action ids exist
1378: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_start_date,l_end_date);
1379: IF l_value = 'N' THEN
1380: hr_utility.set_location('China : Assignment Actions not found ', 80);
1381: RETURN l_return_value;
1382: END IF;
1383:
1384: -- Assignment should be included

Line 1386: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 110);

1382: END IF;
1383:
1384: -- Assignment should be included
1385: l_return_value :='Y';
1386: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 110);
1387:
1388: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);
1389:
1390: RETURN l_return_value;

Line 1388: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);

1384: -- Assignment should be included
1385: l_return_value :='Y';
1386: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 110);
1387:
1388: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);
1389:
1390: RETURN l_return_value;
1391: --
1392: EXCEPTION

Line 1401: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 80);

1397: CLOSE csr_valid_assignment;
1398: --
1399: END IF;
1400:
1401: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 80);
1402: RAISE;
1403: --
1404: END ca_criteria_profile;
1405:

Line 1568: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

1564: l_proc_name := 'pay_cn_ext.em_criteria_profile';
1565: l_expat_indicator := 'Y';
1566: l_return_value := 'N';
1567:
1568: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1569:
1570: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1571: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1572: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);

Line 1570: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);

1566: l_return_value := 'N';
1567:
1568: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1569:
1570: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1571: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1572: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1573:
1574: -- Get Globals

Line 1571: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);

1567:
1568: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1569:
1570: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1571: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1572: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1573:
1574: -- Get Globals
1575: --

Line 1572: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);

1568: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1569:
1570: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);
1571: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 20);
1572: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 20);
1573:
1574: -- Get Globals
1575: --
1576: get_globals ( p_phf_si_type => l_phf_si_type

Line 1591: hr_utility.set_location('China : business grp mismtach ' || l_end_date , 10);

1587: -- Check whether the assignment's business group id is same as the concurrent program
1588: -- business group id. If not return 'N'
1589: IF (p_business_group_id <> l_business_group_id) THEN
1590: --
1591: hr_utility.set_location('China : business grp mismtach ' || l_end_date , 10);
1592: RETURN l_return_value;
1593: --
1594: END IF;
1595: --

Line 1608: hr_utility.set_location('China : Assignment not valid' , 40);

1604:
1605: IF csr_valid_assignment%NOTFOUND THEN
1606: --
1607: -- Assignment is not live
1608: hr_utility.set_location('China : Assignment not valid' , 40);
1609: CLOSE csr_valid_assignment;
1610: RETURN l_return_value;
1611: --
1612: ELSE

Line 1621: hr_utility.set_location('China : Legal Employer/Expat Ind mismatch', 50);

1617: -- then the assignment is not be included
1618: --
1619: IF (l_expat_indicator = 'Y') OR (l_assg_legal_employer <> l_legal_employer_id) THEN
1620: --
1621: hr_utility.set_location('China : Legal Employer/Expat Ind mismatch', 50);
1622: CLOSE csr_valid_assignment;
1623: RETURN l_return_value;
1624: --
1625: END IF;

Line 1634: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);

1630: CLOSE csr_valid_assignment;
1631:
1632: -- 3411840, Check the assignment's Override Contribution area is same as the concurrent parameter
1633: l_element_name := get_element_name(l_phf_si_type);
1634: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);
1635:
1636: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1637: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1638:

Line 1637: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);

1633: l_element_name := get_element_name(l_phf_si_type);
1634: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);
1635:
1636: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1637: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1638:
1639: IF l_cont_area IS NULL THEN
1640: -- Check the assignment's Contribution area is same as the concurrent parameter
1641: -- Set the contexts

Line 1648: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 70);

1644:
1645: -- Run the DBI
1646: l_cont_area := pay_balance_pkg.run_db_item('SCL_ASG_CN_SIC_AREA',p_business_group_id,'CN');
1647:
1648: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 70);
1649:
1650: END IF;
1651:
1652: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 80);

Line 1652: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 80);

1648: hr_utility.set_location('China : l_cont_area -> '|| l_cont_area, 70);
1649:
1650: END IF;
1651:
1652: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 80);
1653: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 80);
1654:
1655: IF l_cont_area <> l_contribution_area THEN
1656: --

Line 1653: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 80);

1649:
1650: END IF;
1651:
1652: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 80);
1653: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 80);
1654:
1655: IF l_cont_area <> l_contribution_area THEN
1656: --
1657: hr_utility.set_location('China : Cont Area does not match' , 85);

Line 1657: hr_utility.set_location('China : Cont Area does not match' , 85);

1653: hr_utility.set_location('China : l_contribution_area ->'|| l_contribution_area, 80);
1654:
1655: IF l_cont_area <> l_contribution_area THEN
1656: --
1657: hr_utility.set_location('China : Cont Area does not match' , 85);
1658: RETURN l_return_value;
1659: --
1660: END IF;
1661: --

Line 1672: hr_utility.set_location('China : Element Entry not found ', 90);

1668: -- If element entry for the given PHF/SI Type does not exist for the assignment
1669: -- then the assignment is not eligible
1670: IF l_value = 'N' THEN
1671: --
1672: hr_utility.set_location('China : Element Entry not found ', 90);
1673: RETURN l_return_value;
1674: --
1675: END IF;
1676: --

Line 1694: hr_utility.set_location('China : Acct status not found' || l_end_date , 100);

1690: -- Check whether account status exist
1691: --
1692: IF csr_acct_status%NOTFOUND THEN
1693: --
1694: hr_utility.set_location('China : Acct status not found' || l_end_date , 100);
1695: CLOSE csr_acct_status;
1696: RETURN l_return_value;
1697: --
1698: -- Check whether account status is OPEN, CLOSED, TRANSFER IN or TRANSFER OUT

Line 1713: hr_utility.set_location('China : Acct status same as prev month' || l_end_date , 110);

1709: IF ((csr_prev_acct_status%FOUND) AND (l_prev_acct_status = l_acct_status)) THEN
1710: --
1711: -- Account status is same as previous month. Hence no need to report this
1712: -- assignment
1713: hr_utility.set_location('China : Acct status same as prev month' || l_end_date , 110);
1714: CLOSE csr_prev_acct_status;
1715: RETURN l_return_value;
1716: --
1717: END IF;

Line 1728: hr_utility.set_location('China : Reason Of Change' ||l_reason_of_change , 115);

1724:
1725: OPEN csr_acct_status( l_element_name, 'Status Change Reason',l_start_date,l_end_date);
1726: FETCH csr_acct_status
1727: INTO l_reason_of_change;
1728: hr_utility.set_location('China : Reason Of Change' ||l_reason_of_change , 115);
1729: --
1730: IF (l_reason_of_change IS NULL) OR (l_reason_of_change = '11') THEN
1731: --
1732: hr_utility.set_location('China :Reason of change is Others ' , 120);

Line 1732: hr_utility.set_location('China :Reason of change is Others ' , 120);

1728: hr_utility.set_location('China : Reason Of Change' ||l_reason_of_change , 115);
1729: --
1730: IF (l_reason_of_change IS NULL) OR (l_reason_of_change = '11') THEN
1731: --
1732: hr_utility.set_location('China :Reason of change is Others ' , 120);
1733: l_return_value := 'N';
1734: CLOSE csr_acct_status;
1735: RETURN l_return_value;
1736: --

Line 1739: hr_utility.set_location('China : Valid acct Status' , 125);

1735: RETURN l_return_value;
1736: --
1737: ELSE
1738: --
1739: hr_utility.set_location('China : Valid acct Status' , 125);
1740: l_return_value := 'Y';
1741: CLOSE csr_acct_status;
1742: --
1743: END IF;

Line 1754: hr_utility.set_location('China : Reason Of Change' ||l_reason_of_change , 130);

1750: CLOSE csr_acct_status;
1751: OPEN csr_acct_status( l_element_name, 'Status Change Reason',l_start_date,l_end_date);
1752: FETCH csr_acct_status
1753: INTO l_reason_of_change;
1754: hr_utility.set_location('China : Reason Of Change' ||l_reason_of_change , 130);
1755: --
1756: IF l_reason_of_change = '10' THEN
1757: --
1758: hr_utility.set_location('China : Dead ' , 140);

Line 1758: hr_utility.set_location('China : Dead ' , 140);

1754: hr_utility.set_location('China : Reason Of Change' ||l_reason_of_change , 130);
1755: --
1756: IF l_reason_of_change = '10' THEN
1757: --
1758: hr_utility.set_location('China : Dead ' , 140);
1759: l_return_value := 'Y';
1760: --
1761: ELSE
1762: --

Line 1777: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 150);

1773: --
1774:
1775: -- Assignment should be included
1776: l_return_value :='Y';
1777: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 150);
1778: hr_utility.set_location('China : China Leaving -> ' || l_proc_name , 160);
1779:
1780: RETURN l_return_value;
1781: --

Line 1778: hr_utility.set_location('China : China Leaving -> ' || l_proc_name , 160);

1774:
1775: -- Assignment should be included
1776: l_return_value :='Y';
1777: hr_utility.set_location('China : l_return_value -> ' || l_return_value , 150);
1778: hr_utility.set_location('China : China Leaving -> ' || l_proc_name , 160);
1779:
1780: RETURN l_return_value;
1781: --
1782: EXCEPTION

Line 1796: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 180);

1792: CLOSE csr_acct_status;
1793: --
1794: END IF;
1795:
1796: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 180);
1797: RAISE;
1798: --
1799: END em_criteria_profile;
1800:

Line 1946: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

1942: --
1943: l_proc_name := 'pay_cn_ext.get_employer_info';
1944: l_return_value:= NULL;
1945:
1946: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1947: hr_utility.set_location('China : Info Type-> '||p_info_type, 10);
1948:
1949: -- Get Globals
1950: --

Line 1947: hr_utility.set_location('China : Info Type-> '||p_info_type, 10);

1943: l_proc_name := 'pay_cn_ext.get_employer_info';
1944: l_return_value:= NULL;
1945:
1946: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1947: hr_utility.set_location('China : Info Type-> '||p_info_type, 10);
1948:
1949: -- Get Globals
1950: --
1951: get_globals ( p_phf_si_type => l_phf_si_type

Line 1968: hr_utility.set_location('China : Filling Date -> '||l_return_value, 20);

1964: IF p_info_type = 'FILING_DATE' THEN
1965: --
1966: l_filing_date := NVL(l_filling_date,l_start_date);
1967: l_return_value := TO_CHAR(l_filing_date,'YYYY/MM/DD');
1968: hr_utility.set_location('China : Filling Date -> '||l_return_value, 20);
1969: RETURN l_return_value;
1970: --
1971: END IF;
1972:

Line 1978: hr_utility.set_location('China : Insurance Type Code -> '||l_return_value, 30);

1974: --
1975: IF p_info_type = 'INSURANCE_TYPE_CODE' THEN
1976: --
1977: l_return_value := l_phf_si_type;
1978: hr_utility.set_location('China : Insurance Type Code -> '||l_return_value, 30);
1979: RETURN l_return_value;
1980: --
1981: END IF;
1982:

Line 1990: hr_utility.set_location('China : Insurance Type -> '||l_return_value, 40);

1986: --
1987: l_return_value := hr_general.decode_lookup(p_lookup_type => 'CN_PHF_SI_CODE'
1988: ,p_lookup_code => l_phf_si_type
1989: );
1990: hr_utility.set_location('China : Insurance Type -> '||l_return_value, 40);
1991: return l_return_value;
1992: --
1993: END IF;
1994:

Line 2003: hr_utility.set_location('China : Employer Name -> '||l_return_value, 50);

1999: OPEN csr_legal_employer_name(l_legal_employer_id);
2000: FETCH csr_legal_employer_name
2001: INTO l_return_value;
2002: CLOSE csr_legal_employer_name;
2003: hr_utility.set_location('China : Employer Name -> '||l_return_value, 50);
2004: RETURN l_return_value;
2005: --
2006: END IF;
2007:

Line 2016: hr_utility.set_location('China : Employer Name -> '||l_return_value, 60);

2012: OPEN csr_ent_org_code(l_legal_employer_id);
2013: FETCH csr_ent_org_code
2014: INTO l_return_value;
2015: CLOSE csr_ent_org_code;
2016: hr_utility.set_location('China : Employer Name -> '||l_return_value, 60);
2017: RETURN l_return_value;
2018: --
2019: END IF;
2020:

Line 2028: hr_utility.set_location('China : Enterprise Org Category -> '||l_return_value, 70);

2024: --
2025: OPEN csr_ent_org_category(l_legal_employer_id);
2026: FETCH csr_ent_org_category
2027: INTO l_return_value;
2028: hr_utility.set_location('China : Enterprise Org Category -> '||l_return_value, 70);
2029: CLOSE csr_ent_org_category;
2030: RETURN l_return_value;
2031: --
2032: END IF;

Line 2048: hr_utility.set_location('China : Enterprise Org Category -> '||l_return_value, 80);

2044: --
2045: l_return_value := TO_CHAR(l_start_date,'YYYY/MM/DD') ||'-'|| TO_CHAR(l_end_date,'YYYY/MM/DD');
2046: --
2047: END IF;
2048: hr_utility.set_location('China : Enterprise Org Category -> '||l_return_value, 80);
2049: RETURN l_return_value;
2050: --
2051: END IF;
2052:

Line 2061: hr_utility.set_location('China : Org Currency -> '||l_return_value, 90);

2057: OPEN csr_org_currency(l_business_group_id);
2058: FETCH csr_org_currency
2059: INTO l_return_value;
2060: CLOSE csr_org_currency;
2061: hr_utility.set_location('China : Org Currency -> '||l_return_value, 90);
2062: RETURN l_return_value;
2063: --
2064: END IF;
2065:

Line 2114: hr_utility.set_location('China : PHF/SI Reg Num -> '||l_return_value, 100);

2110: --
2111: END IF;
2112:
2113: --
2114: hr_utility.set_location('China : PHF/SI Reg Num -> '||l_return_value, 100);
2115: RETURN l_return_value;
2116: --
2117: END IF;
2118:

Line 2163: hr_utility.set_location('China : ER Cont Percent -> '||l_return_value, 110);

2159: --
2160: IF l_er_rate_type = 'PERCENTAGE' THEN
2161: --
2162: l_return_value := l_er_rate;
2163: hr_utility.set_location('China : ER Cont Percent -> '||l_return_value, 110);
2164: RETURN l_return_value;
2165: --
2166: END IF;
2167: --

Line 2178: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);

2174: END IF;
2175:
2176: -- No Info Type Matches
2177: --
2178: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 120);
2179: RETURN l_return_value;
2180: --
2181: EXCEPTION
2182: --

Line 2213: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 180);

2209: CLOSE csr_phf_si_reg_num;
2210: --
2211: END IF;
2212:
2213: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 180);
2214: RAISE;
2215: --
2216: END get_employer_info;
2217:

Line 2361: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

2357: --
2358: l_proc_name := 'pay_cn_ext.get_employee_info';
2359: l_return_value := NULL;
2360:
2361: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
2362: hr_utility.set_location('China : Assignment ID -> '||p_assignment_id, 10);
2363: hr_utility.set_location('China : Date Earned -> '||p_date_earned, 10);
2364: hr_utility.set_location('China : Info Type -> '||p_info_type, 10);
2365:

Line 2362: hr_utility.set_location('China : Assignment ID -> '||p_assignment_id, 10);

2358: l_proc_name := 'pay_cn_ext.get_employee_info';
2359: l_return_value := NULL;
2360:
2361: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
2362: hr_utility.set_location('China : Assignment ID -> '||p_assignment_id, 10);
2363: hr_utility.set_location('China : Date Earned -> '||p_date_earned, 10);
2364: hr_utility.set_location('China : Info Type -> '||p_info_type, 10);
2365:
2366: -- Get Globals

Line 2363: hr_utility.set_location('China : Date Earned -> '||p_date_earned, 10);

2359: l_return_value := NULL;
2360:
2361: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
2362: hr_utility.set_location('China : Assignment ID -> '||p_assignment_id, 10);
2363: hr_utility.set_location('China : Date Earned -> '||p_date_earned, 10);
2364: hr_utility.set_location('China : Info Type -> '||p_info_type, 10);
2365:
2366: -- Get Globals
2367: --

Line 2364: hr_utility.set_location('China : Info Type -> '||p_info_type, 10);

2360:
2361: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
2362: hr_utility.set_location('China : Assignment ID -> '||p_assignment_id, 10);
2363: hr_utility.set_location('China : Date Earned -> '||p_date_earned, 10);
2364: hr_utility.set_location('China : Info Type -> '||p_info_type, 10);
2365:
2366: -- Get Globals
2367: --
2368: get_globals ( p_phf_si_type => l_phf_si_type

Line 2423: hr_utility.set_location('China : Employee Cont Percent -> '||l_return_value, 20);

2419: --
2420: IF l_ee_rate_type = 'PERCENTAGE' THEN
2421: --
2422: l_return_value := l_ee_rate;
2423: hr_utility.set_location('China : Employee Cont Percent -> '||l_return_value, 20);
2424: RETURN l_return_value;
2425: --
2426: END IF;
2427: --

Line 2444: hr_utility.set_location('China : Ethnic Group -> '||l_return_value, 30);

2440: OPEN csr_ethnic_group;
2441: FETCH csr_ethnic_group
2442: INTO l_return_value;
2443: CLOSE csr_ethnic_group;
2444: hr_utility.set_location('China : Ethnic Group -> '||l_return_value, 30);
2445: RETURN l_return_value;
2446: --
2447: END IF;
2448:

Line 2457: hr_utility.set_location('China : Hukou Type -> '||l_return_value, 40);

2453: OPEN csr_hukou_type;
2454: FETCH csr_hukou_type
2455: INTO l_return_value;
2456: CLOSE csr_hukou_type;
2457: hr_utility.set_location('China : Hukou Type -> '||l_return_value, 40);
2458: RETURN l_return_value;
2459: --
2460: END IF;
2461:

Line 2477: hr_utility.set_location('China : Work Life Start Date -> '||l_return_value, 50);

2473: --
2474: END IF;
2475: CLOSE csr_work_life_start_date;
2476: l_return_value := TO_CHAR(TO_DATE(l_work_life_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD');
2477: hr_utility.set_location('China : Work Life Start Date -> '||l_return_value, 50);
2478: RETURN l_return_value;
2479: --
2480: END IF;
2481:

Line 2496: hr_utility.set_location('China : Job Category -> '||l_return_value, 50);

2492: RETURN l_return_value;
2493: --
2494: END IF;
2495: CLOSE csr_job_category;
2496: hr_utility.set_location('China : Job Category -> '||l_return_value, 50);
2497: RETURN l_return_value;
2498: --
2499: END IF;
2500: --

Line 2505: hr_utility.set_location('China Leaving -> '|| l_proc_name , 60);

2501:
2502: -- No Info Type Matches
2503: --
2504:
2505: hr_utility.set_location('China Leaving -> '|| l_proc_name , 60);
2506: RETURN l_return_value;
2507: --
2508: EXCEPTION
2509: --

Line 2534: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 80);

2530: CLOSE csr_job_category;
2531: --
2532: END IF;
2533:
2534: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 80);
2535: RAISE;
2536: --
2537: END get_employee_info;
2538:

Line 2661: hr_utility.set_location('China Entering -> ' || l_proc_name , 10);

2657: --
2658: l_proc_name := 'pay_cn_ext.get_balance_value';
2659: l_bal_value :=0;
2660:
2661: hr_utility.set_location('China Entering -> ' || l_proc_name , 10);
2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);
2663: hr_utility.set_location('China p_business_group_id -> ' || p_business_group_id , 10);
2664: hr_utility.set_location('China p_balance_name -> ' || p_balance_name , 10);
2665: hr_utility.set_location('China p_balance_dimension -> ' || p_balance_dimension , 10);

Line 2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);

2658: l_proc_name := 'pay_cn_ext.get_balance_value';
2659: l_bal_value :=0;
2660:
2661: hr_utility.set_location('China Entering -> ' || l_proc_name , 10);
2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);
2663: hr_utility.set_location('China p_business_group_id -> ' || p_business_group_id , 10);
2664: hr_utility.set_location('China p_balance_name -> ' || p_balance_name , 10);
2665: hr_utility.set_location('China p_balance_dimension -> ' || p_balance_dimension , 10);
2666: hr_utility.set_location('China p_info_type -> ' || p_info_type , 10);

Line 2663: hr_utility.set_location('China p_business_group_id -> ' || p_business_group_id , 10);

2659: l_bal_value :=0;
2660:
2661: hr_utility.set_location('China Entering -> ' || l_proc_name , 10);
2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);
2663: hr_utility.set_location('China p_business_group_id -> ' || p_business_group_id , 10);
2664: hr_utility.set_location('China p_balance_name -> ' || p_balance_name , 10);
2665: hr_utility.set_location('China p_balance_dimension -> ' || p_balance_dimension , 10);
2666: hr_utility.set_location('China p_info_type -> ' || p_info_type , 10);
2667:

Line 2664: hr_utility.set_location('China p_balance_name -> ' || p_balance_name , 10);

2660:
2661: hr_utility.set_location('China Entering -> ' || l_proc_name , 10);
2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);
2663: hr_utility.set_location('China p_business_group_id -> ' || p_business_group_id , 10);
2664: hr_utility.set_location('China p_balance_name -> ' || p_balance_name , 10);
2665: hr_utility.set_location('China p_balance_dimension -> ' || p_balance_dimension , 10);
2666: hr_utility.set_location('China p_info_type -> ' || p_info_type , 10);
2667:
2668: -- Get Globals

Line 2665: hr_utility.set_location('China p_balance_dimension -> ' || p_balance_dimension , 10);

2661: hr_utility.set_location('China Entering -> ' || l_proc_name , 10);
2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);
2663: hr_utility.set_location('China p_business_group_id -> ' || p_business_group_id , 10);
2664: hr_utility.set_location('China p_balance_name -> ' || p_balance_name , 10);
2665: hr_utility.set_location('China p_balance_dimension -> ' || p_balance_dimension , 10);
2666: hr_utility.set_location('China p_info_type -> ' || p_info_type , 10);
2667:
2668: -- Get Globals
2669: --

Line 2666: hr_utility.set_location('China p_info_type -> ' || p_info_type , 10);

2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);
2663: hr_utility.set_location('China p_business_group_id -> ' || p_business_group_id , 10);
2664: hr_utility.set_location('China p_balance_name -> ' || p_balance_name , 10);
2665: hr_utility.set_location('China p_balance_dimension -> ' || p_balance_dimension , 10);
2666: hr_utility.set_location('China p_info_type -> ' || p_info_type , 10);
2667:
2668: -- Get Globals
2669: --
2670: get_globals ( p_phf_si_type => l_phf_si_type

Line 2688: hr_utility.set_location('China : Defined Balance not found', 20);

2684: FETCH csr_defined_balance
2685: INTO l_defined_balance_id;
2686: IF csr_defined_balance%NOTFOUND THEN
2687: --
2688: hr_utility.set_location('China : Defined Balance not found', 20);
2689: CLOSE csr_defined_balance;
2690: RETURN l_bal_value;
2691: --
2692: END IF;

Line 2695: hr_utility.set_location('China l_defined_balance_id -> ' || l_defined_balance_id , 30);

2691: --
2692: END IF;
2693: CLOSE csr_defined_balance;
2694:
2695: hr_utility.set_location('China l_defined_balance_id -> ' || l_defined_balance_id , 30);
2696:
2697: IF p_info_type = 'PREV_MONTH' THEN
2698: l_mod_start_date := TRUNC(TRUNC(l_start_date,'MM')-1,'MM');
2699: l_mod_end_date := LAST_DAY(l_mod_start_date);

Line 2711: hr_utility.set_location('China : Assignment action id -> ' || l_assignment_action_id, 50);

2707: OPEN csr_assg_act(l_mod_start_date,l_mod_end_date);
2708: FETCH csr_assg_act INTO l_assignment_action_id;
2709:
2710: IF csr_assg_act%FOUND THEN
2711: hr_utility.set_location('China : Assignment action id -> ' || l_assignment_action_id, 50);
2712:
2713: OPEN csr_date_earned(l_assignment_action_id);
2714: FETCH csr_date_earned INTO l_date_earned;
2715: CLOSE csr_date_earned;

Line 2717: hr_utility.set_location('China : Date Earned ->' || l_date_earned, 60);

2713: OPEN csr_date_earned(l_assignment_action_id);
2714: FETCH csr_date_earned INTO l_date_earned;
2715: CLOSE csr_date_earned;
2716:
2717: hr_utility.set_location('China : Date Earned ->' || l_date_earned, 60);
2718:
2719: -- Set context
2720: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));
2721:

Line 2727: hr_utility.set_location('China : Assignment action id -> ' || l_assignment_action_id, 55);

2723: l_bal_value := pay_balance_pkg.get_value ( p_defined_balance_id => l_defined_balance_id
2724: , p_assignment_action_id => l_assignment_action_id);
2725:
2726: ELSE
2727: hr_utility.set_location('China : Assignment action id -> ' || l_assignment_action_id, 55);
2728: END IF;
2729:
2730: CLOSE csr_assg_act;
2731:

Line 2738: hr_utility.set_location('China : Fetch Assignment action id ', 100);

2734: -- If the Info Type is Previous Year
2735: --
2736: IF p_info_type = 'PREV_YEAR' THEN
2737: --
2738: hr_utility.set_location('China : Fetch Assignment action id ', 100);
2739:
2740: -- Fetch Assignment Action ID of previous month
2741: --
2742: l_prev_month := TRUNC(TRUNC(l_start_date,'MM')-1,'MM');

Line 2750: hr_utility.set_location('China : Assignment action id -> ' || l_assignment_action_id, 110);

2746: INTO l_assignment_action_id;
2747:
2748: IF csr_assg_act%FOUND THEN
2749: --
2750: hr_utility.set_location('China : Assignment action id -> ' || l_assignment_action_id, 110);
2751:
2752: -- Get Date Earned context
2753: --
2754: OPEN csr_date_earned(l_assignment_action_id);

Line 2759: hr_utility.set_location('China : Date Earned ->', 60);

2755: FETCH csr_date_earned
2756: INTO l_date_earned;
2757: CLOSE csr_date_earned;
2758:
2759: hr_utility.set_location('China : Date Earned ->', 60);
2760:
2761: -- Set context
2762: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_date_earned));
2763:

Line 2774: hr_utility.set_location('China : Balance Prev Year ->' || l_bal_value, 120);

2770:
2771: -- Fetch Number of runs in Previous Year
2772: --
2773: l_no_of_runs := pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN');
2774: hr_utility.set_location('China : Balance Prev Year ->' || l_bal_value, 120);
2775: hr_utility.set_location('China : Number of runs ->' || l_no_of_runs, 120);
2776: l_bal_value := l_bal_value/l_no_of_runs;
2777: --
2778: ELSE

Line 2775: hr_utility.set_location('China : Number of runs ->' || l_no_of_runs, 120);

2771: -- Fetch Number of runs in Previous Year
2772: --
2773: l_no_of_runs := pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN');
2774: hr_utility.set_location('China : Balance Prev Year ->' || l_bal_value, 120);
2775: hr_utility.set_location('China : Number of runs ->' || l_no_of_runs, 120);
2776: l_bal_value := l_bal_value/l_no_of_runs;
2777: --
2778: ELSE
2779: --

Line 2780: hr_utility.set_location('China : Assignment action id not Found', 110);

2776: l_bal_value := l_bal_value/l_no_of_runs;
2777: --
2778: ELSE
2779: --
2780: hr_utility.set_location('China : Assignment action id not Found', 110);
2781: --
2782: END IF;
2783: CLOSE csr_assg_act;
2784: --

Line 2787: hr_utility.set_location('China l_bal_value -> ' || l_bal_value , 130);

2783: CLOSE csr_assg_act;
2784: --
2785: END IF;
2786:
2787: hr_utility.set_location('China l_bal_value -> ' || l_bal_value , 130);
2788: hr_utility.set_location('China Leaving -> '|| l_proc_name , 130);
2789:
2790: --
2791: -- Bug 3475437

Line 2788: hr_utility.set_location('China Leaving -> '|| l_proc_name , 130);

2784: --
2785: END IF;
2786:
2787: hr_utility.set_location('China l_bal_value -> ' || l_bal_value , 130);
2788: hr_utility.set_location('China Leaving -> '|| l_proc_name , 130);
2789:
2790: --
2791: -- Bug 3475437
2792: -- Modified Return l_bal_value to Return round(l_bal_valu2,2)

Line 2809: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 140);

2805: IF csr_date_earned%ISOPEN THEN
2806: CLOSE csr_date_earned;
2807: END IF;
2808:
2809: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 140);
2810: RAISE;
2811:
2812: END get_balance_value;
2813:

Line 2883: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);

2879: --
2880: l_proc_name := 'pay_cn_ext.get_element_entry';
2881: l_return_value := 'N';
2882:
2883: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
2884: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
2885: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
2886: hr_utility.set_location('China : p_effective_date -> ' || p_effective_date , 10);
2887: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 10);

Line 2884: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);

2880: l_proc_name := 'pay_cn_ext.get_element_entry';
2881: l_return_value := 'N';
2882:
2883: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
2884: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
2885: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
2886: hr_utility.set_location('China : p_effective_date -> ' || p_effective_date , 10);
2887: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 10);
2888:

Line 2885: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);

2881: l_return_value := 'N';
2882:
2883: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
2884: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
2885: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
2886: hr_utility.set_location('China : p_effective_date -> ' || p_effective_date , 10);
2887: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 10);
2888:
2889:

Line 2886: hr_utility.set_location('China : p_effective_date -> ' || p_effective_date , 10);

2882:
2883: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
2884: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
2885: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
2886: hr_utility.set_location('China : p_effective_date -> ' || p_effective_date , 10);
2887: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 10);
2888:
2889:
2890: -- Get Element Name

Line 2887: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 10);

2883: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
2884: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
2885: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
2886: hr_utility.set_location('China : p_effective_date -> ' || p_effective_date , 10);
2887: hr_utility.set_location('China : p_phf_si_type -> ' || p_phf_si_type , 10);
2888:
2889:
2890: -- Get Element Name
2891: l_element_name := get_element_name(p_phf_si_type);

Line 2893: hr_utility.set_location('China l_element_name -> '|| l_element_name , 20);

2889:
2890: -- Get Element Name
2891: l_element_name := get_element_name(p_phf_si_type);
2892:
2893: hr_utility.set_location('China l_element_name -> '|| l_element_name , 20);
2894:
2895: -- Fetch the count of entries
2896: -- Bug 3415164
2897: -- Passing only p_end_date and element_name

Line 2917: hr_utility.set_location('China l_return_value -> '|| l_return_value , 30);

2913: l_return_value := 'N';
2914: --
2915: END IF;
2916:
2917: hr_utility.set_location('China l_return_value -> '|| l_return_value , 30);
2918: hr_utility.set_location('China Leaving -> '|| l_proc_name , 40);
2919:
2920: RETURN l_return_value;
2921: --

Line 2918: hr_utility.set_location('China Leaving -> '|| l_proc_name , 40);

2914: --
2915: END IF;
2916:
2917: hr_utility.set_location('China l_return_value -> '|| l_return_value , 30);
2918: hr_utility.set_location('China Leaving -> '|| l_proc_name , 40);
2919:
2920: RETURN l_return_value;
2921: --
2922: EXCEPTION

Line 2931: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);

2927: CLOSE csr_element_entry;
2928: --
2929: END IF;
2930:
2931: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);
2932: RAISE;
2933: --
2934: END get_element_entry;
2935:

Line 2999: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);

2995: BEGIN
2996: --
2997: l_proc_name := 'pay_cn_ext.get_override_sic_code';
2998:
2999: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3000: hr_utility.set_location('China : p_element_name -> ' || p_element_name , 10);
3001: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
3002: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 10);
3003:

Line 3000: hr_utility.set_location('China : p_element_name -> ' || p_element_name , 10);

2996: --
2997: l_proc_name := 'pay_cn_ext.get_override_sic_code';
2998:
2999: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3000: hr_utility.set_location('China : p_element_name -> ' || p_element_name , 10);
3001: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
3002: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 10);
3003:
3004: -- Fetch the Override SIC Code

Line 3001: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);

2997: l_proc_name := 'pay_cn_ext.get_override_sic_code';
2998:
2999: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3000: hr_utility.set_location('China : p_element_name -> ' || p_element_name , 10);
3001: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
3002: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 10);
3003:
3004: -- Fetch the Override SIC Code
3005: OPEN csr_override_sic_code( p_element_name

Line 3002: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 10);

2998:
2999: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3000: hr_utility.set_location('China : p_element_name -> ' || p_element_name , 10);
3001: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
3002: hr_utility.set_location('China : p_date_earned -> ' || p_date_earned , 10);
3003:
3004: -- Fetch the Override SIC Code
3005: OPEN csr_override_sic_code( p_element_name
3006: , p_assignment_id

Line 3018: hr_utility.set_location('China : l_return_value -> '|| NVL(l_return_value,'NULL') , 30);

3014: END IF;
3015:
3016: CLOSE csr_override_sic_code;
3017:
3018: hr_utility.set_location('China : l_return_value -> '|| NVL(l_return_value,'NULL') , 30);
3019: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 40);
3020:
3021: RETURN l_return_value;
3022:

Line 3019: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 40);

3015:
3016: CLOSE csr_override_sic_code;
3017:
3018: hr_utility.set_location('China : l_return_value -> '|| NVL(l_return_value,'NULL') , 30);
3019: hr_utility.set_location('China : Leaving -> '|| l_proc_name , 40);
3020:
3021: RETURN l_return_value;
3022:
3023: EXCEPTION

Line 3029: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);

3025: IF csr_override_sic_code%ISOPEN THEN
3026: CLOSE csr_override_sic_code;
3027: END IF;
3028:
3029: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);
3030: RAISE;
3031:
3032: END get_override_sic_code;
3033:

Line 3097: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);

3093:
3094: l_proc_name := 'pay_cn_ext.get_assignment_action';
3095: l_return_value := 'N';
3096:
3097: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3098: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
3099: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
3100:
3101: -- Fetch the assignment action

Line 3098: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);

3094: l_proc_name := 'pay_cn_ext.get_assignment_action';
3095: l_return_value := 'N';
3096:
3097: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3098: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
3099: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
3100:
3101: -- Fetch the assignment action
3102: OPEN csr_assg_act(p_start_date,p_end_date);

Line 3099: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);

3095: l_return_value := 'N';
3096:
3097: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3098: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);
3099: hr_utility.set_location('China : p_business_group_id -> ' || p_business_group_id , 10);
3100:
3101: -- Fetch the assignment action
3102: OPEN csr_assg_act(p_start_date,p_end_date);
3103: FETCH csr_assg_act INTO l_assignment_action_id;

Line 3106: hr_utility.set_location('China : l_assignment_action_id -> ' || l_assignment_action_id , 20);

3102: OPEN csr_assg_act(p_start_date,p_end_date);
3103: FETCH csr_assg_act INTO l_assignment_action_id;
3104: CLOSE csr_assg_act;
3105:
3106: hr_utility.set_location('China : l_assignment_action_id -> ' || l_assignment_action_id , 20);
3107:
3108: --In case the assignment actions don't exist, return N
3109: IF NVL(l_assignment_action_id,0) = 0 THEN
3110: l_return_value := 'N';

Line 3115: hr_utility.set_location('China l_return_value -> '|| l_return_value , 30);

3111: ELSE
3112: l_return_value := 'Y';
3113: END IF;
3114:
3115: hr_utility.set_location('China l_return_value -> '|| l_return_value , 30);
3116: hr_utility.set_location('China Leaving -> '|| l_proc_name , 40);
3117:
3118: RETURN l_return_value;
3119:

Line 3116: hr_utility.set_location('China Leaving -> '|| l_proc_name , 40);

3112: l_return_value := 'Y';
3113: END IF;
3114:
3115: hr_utility.set_location('China l_return_value -> '|| l_return_value , 30);
3116: hr_utility.set_location('China Leaving -> '|| l_proc_name , 40);
3117:
3118: RETURN l_return_value;
3119:
3120: EXCEPTION

Line 3126: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);

3122: IF csr_assg_act%ISOPEN THEN
3123: CLOSE csr_assg_act;
3124: END IF;
3125:
3126: hr_utility.set_location('China : Exception, Leaving: '||l_proc_name, 50);
3127: RAISE;
3128:
3129: END get_assignment_action;
3130: