APPS.PER_SSHR_CHANGE_PAY dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package Varchar2(30) := 'per_sshr_change_pay.';
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: type t_tx_name is table of varchar2(30) index by binary_integer;
12: type t_tx_char is table of varchar2(2000) index by binary_integer;
13: type t_tx_num is table of number index by binary_integer;

Line 64: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);

60: l_txn_grade_ladder_id number;
61: Begin
62: l_txn_grade_ladder_id := -1;
63: if g_debug then
64: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
65: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
66: hr_utility.set_location('p_effective_date '||p_effective_date,3);
67: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
68: end if;

Line 65: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);

61: Begin
62: l_txn_grade_ladder_id := -1;
63: if g_debug then
64: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
65: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
66: hr_utility.set_location('p_effective_date '||p_effective_date,3);
67: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
68: end if;
69:

Line 66: hr_utility.set_location('p_effective_date '||p_effective_date,3);

62: l_txn_grade_ladder_id := -1;
63: if g_debug then
64: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
65: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
66: hr_utility.set_location('p_effective_date '||p_effective_date,3);
67: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
68: end if;
69:
70: Open csr_gsp_ladder_id;

Line 67: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);

63: if g_debug then
64: hr_utility.set_location('Enter Check_GSP_Manual_Override ', 1);
65: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
66: hr_utility.set_location('p_effective_date '||p_effective_date,3);
67: hr_utility.set_location('p_transaction_id '||p_transaction_id,4);
68: end if;
69:
70: Open csr_gsp_ladder_id;
71: Fetch csr_gsp_ladder_id into l_txn_grade_ladder_id ;

Line 75: hr_utility.set_location('In GSP_CHECK l_txn_grade_ladder_id '||l_txn_grade_ladder_id, 5);

71: Fetch csr_gsp_ladder_id into l_txn_grade_ladder_id ;
72: Close csr_gsp_ladder_id;
73:
74: if g_debug then
75: hr_utility.set_location('In GSP_CHECK l_txn_grade_ladder_id '||l_txn_grade_ladder_id, 5);
76: end if;
77:
78: if l_txn_grade_ladder_id is null or l_txn_grade_ladder_id = -1 then
79: Open csr_assignment_check;

Line 83: hr_utility.set_location('In GSP_CHECK_AST l_Status '||l_Status, 6);

79: Open csr_assignment_check;
80: Fetch csr_assignment_check into l_Status;
81: Close csr_assignment_check;
82: if g_debug then
83: hr_utility.set_location('In GSP_CHECK_AST l_Status '||l_Status, 6);
84: end if;
85: else
86: Open csr_transaction_check(l_txn_grade_ladder_id);
87: Fetch csr_transaction_check into l_Status;

Line 90: hr_utility.set_location('In GSP_CHECK_TXN l_Status '||l_Status, 7);

86: Open csr_transaction_check(l_txn_grade_ladder_id);
87: Fetch csr_transaction_check into l_Status;
88: Close csr_transaction_check;
89: if g_debug then
90: hr_utility.set_location('In GSP_CHECK_TXN l_Status '||l_Status, 7);
91: end if;
92: end if;
93: RETURN l_Status;
94: End;

Line 163: hr_utility.set_location('Enter check_base_salary_profile ', 1);

159: --
160: BEGIN
161: --
162: if g_debug then
163: hr_utility.set_location('Enter check_base_salary_profile ', 1);
164: end if;
165: --
166: -- Get the transaction_step_id of the assignment step.
167: --

Line 173: hr_utility.set_location('l_transaction_id '||l_transaction_id, 2);

169: Fetch asg_step into l_transaction_id,l_transaction_step_id;
170: Close asg_step;
171: --
172: if g_debug then
173: hr_utility.set_location('l_transaction_id '||l_transaction_id, 2);
174: hr_utility.set_location('l_transaction_step_id '||l_transaction_step_id, 3);
175: end if;
176: --
177: -- There exists an assignment step, Hence get the pay basis from the txn table.

Line 174: hr_utility.set_location('l_transaction_step_id '||l_transaction_step_id, 3);

170: Close asg_step;
171: --
172: if g_debug then
173: hr_utility.set_location('l_transaction_id '||l_transaction_id, 2);
174: hr_utility.set_location('l_transaction_step_id '||l_transaction_step_id, 3);
175: end if;
176: --
177: -- There exists an assignment step, Hence get the pay basis from the txn table.
178: -- Note, If new hire flow, there will be an assignment txn step.

Line 223: hr_utility.set_message(800,'PER_33490_CHGPAY_PROPOSAL_REQD');

219: Fetch csr_prop into l_change_date;
220: Close csr_prop ;
221: -- If no row returned above, raise error
222: if l_change_date is null then
223: hr_utility.set_message(800,'PER_33490_CHGPAY_PROPOSAL_REQD');
224: hr_utility.raise_error;
225: end if;
226: --
227: End if;

Line 224: hr_utility.raise_error;

220: Close csr_prop ;
221: -- If no row returned above, raise error
222: if l_change_date is null then
223: hr_utility.set_message(800,'PER_33490_CHGPAY_PROPOSAL_REQD');
224: hr_utility.raise_error;
225: end if;
226: --
227: End if;
228: --

Line 1302: --hr_utility.trace_on(null, 'TIGER');

1298: Begin
1299: p_allow_change_date := 'YES';
1300: p_allow_basis_change := 'YES';
1301:
1302: --hr_utility.trace_on(null, 'TIGER');
1303: --g_debug := TRUE;
1304:
1305: if g_debug then
1306: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);

Line 1306: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);

1302: --hr_utility.trace_on(null, 'TIGER');
1303: --g_debug := TRUE;
1304:
1305: if g_debug then
1306: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1307: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1308: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1309: hr_utility.set_location('p_item_key '||p_item_key, 4);
1310: end if;

Line 1307: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);

1303: --g_debug := TRUE;
1304:
1305: if g_debug then
1306: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1307: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1308: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1309: hr_utility.set_location('p_item_key '||p_item_key, 4);
1310: end if;
1311:

Line 1308: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);

1304:
1305: if g_debug then
1306: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1307: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1308: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1309: hr_utility.set_location('p_item_key '||p_item_key, 4);
1310: end if;
1311:
1312: Open csr_asg_basis_change_date;

Line 1309: hr_utility.set_location('p_item_key '||p_item_key, 4);

1305: if g_debug then
1306: hr_utility.set_location('Enter check_Salary_Basis_Change ', 1);
1307: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
1308: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
1309: hr_utility.set_location('p_item_key '||p_item_key, 4);
1310: end if;
1311:
1312: Open csr_asg_basis_change_date;
1313: Fetch csr_asg_basis_change_date into l_date;

Line 1318: hr_utility.set_location('ASG_BASIS ', 5);

1314: if l_date is not null then
1315: p_allow_basis_change := 'ASG_BASIS';
1316: p_allow_change_date := 'NO';
1317: if g_debug then
1318: hr_utility.set_location('ASG_BASIS ', 5);
1319: end if;
1320: return;
1321: end if;
1322: Close csr_asg_basis_change_date;

Line 1330: hr_utility.set_location('F_BASIS ', 6);

1326: if l_date is not null then
1327: p_allow_basis_change := 'F_BASIS';
1328: p_allow_change_date := 'NO';
1329: if g_debug then
1330: hr_utility.set_location('F_BASIS ', 6);
1331: end if;
1332: end if;
1333: Close csr_txn_basis_change_date;
1334:

Line 1571: --hr_utility.trace_on(null, 'TIGER');

1567: l_newhire number :=0;
1568: --
1569: begin
1570: --
1571: --hr_utility.trace_on(null, 'TIGER');
1572: --g_debug := TRUE;
1573: --
1574: if g_debug then
1575: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1575: hr_utility.set_location('Entering:'|| l_proc, 10);

1571: --hr_utility.trace_on(null, 'TIGER');
1572: --g_debug := TRUE;
1573: --
1574: if g_debug then
1575: hr_utility.set_location('Entering:'|| l_proc, 10);
1576: end if;
1577: --
1578: if g_debug then
1579: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);

Line 1579: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);

1575: hr_utility.set_location('Entering:'|| l_proc, 10);
1576: end if;
1577: --
1578: if g_debug then
1579: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);
1580: hr_utility.set_location('transStepId:'||p_transaction_step_id||'itemKey:'||p_item_key||'itemtype:'||p_item_type, 10);
1581: hr_utility.set_location('nextChangedt:'||p_next_change_date||'currChangedt:'||p_changedt_curr||'lastChangedt:'||p_changedt_last, 10);
1582: end if;
1583: --

Line 1580: hr_utility.set_location('transStepId:'||p_transaction_step_id||'itemKey:'||p_item_key||'itemtype:'||p_item_type, 10);

1576: end if;
1577: --
1578: if g_debug then
1579: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);
1580: hr_utility.set_location('transStepId:'||p_transaction_step_id||'itemKey:'||p_item_key||'itemtype:'||p_item_type, 10);
1581: hr_utility.set_location('nextChangedt:'||p_next_change_date||'currChangedt:'||p_changedt_curr||'lastChangedt:'||p_changedt_last, 10);
1582: end if;
1583: --
1584: l_count := 0;

Line 1581: hr_utility.set_location('nextChangedt:'||p_next_change_date||'currChangedt:'||p_changedt_curr||'lastChangedt:'||p_changedt_last, 10);

1577: --
1578: if g_debug then
1579: hr_utility.set_location('assgnid:'||p_assgn_id||'effDate:'||p_effective_dt||'transId:'||p_transaction_id, 10);
1580: hr_utility.set_location('transStepId:'||p_transaction_step_id||'itemKey:'||p_item_key||'itemtype:'||p_item_type, 10);
1581: hr_utility.set_location('nextChangedt:'||p_next_change_date||'currChangedt:'||p_changedt_curr||'lastChangedt:'||p_changedt_last, 10);
1582: end if;
1583: --
1584: l_count := 0;
1585: --

Line 1589: hr_utility.set_location('Entering if p_changedt_last:'|| l_proc, 20);

1585: --
1586: if p_changedt_last is null then
1587: --
1588: if g_debug then
1589: hr_utility.set_location('Entering if p_changedt_last:'|| l_proc, 20);
1590: end if;
1591: --
1592: l_changedt_last := p_changedt_curr;
1593: --

Line 1597: hr_utility.set_location('Entering else p_changedt_last:'|| l_proc, 30);

1593: --
1594: else
1595: --
1596: if g_debug then
1597: hr_utility.set_location('Entering else p_changedt_last:'|| l_proc, 30);
1598: end if;
1599: --
1600: l_changedt_last := p_changedt_last;
1601: --

Line 1640: hr_utility.set_location('Process new hire ', 35);

1636: and transaction_id=p_transaction_id;
1637:
1638: if l_newhire > 0
1639: then
1640: hr_utility.set_location('Process new hire ', 35);
1641: process_new_hire(p_transaction_step_id,p_item_key,p_item_type);
1642: end if;
1643:
1644: for delete_recs in csr_delete_recs(p_effective_dt, p_assgn_id, p_changedt_curr, l_changedt_last, p_transaction_id) loop

Line 1648: hr_utility.set_location('roll back new hire ', 35);

1644: for delete_recs in csr_delete_recs(p_effective_dt, p_assgn_id, p_changedt_curr, l_changedt_last, p_transaction_id) loop
1645: --
1646: if l_newhire > 0
1647: then
1648: hr_utility.set_location('roll back new hire ', 35);
1649: ROLLBACK TO apply_change_pay_hire_txn;
1650: end if;
1651: --
1652: if g_debug then

Line 1653: hr_utility.set_location(l_proc, 40);

1649: ROLLBACK TO apply_change_pay_hire_txn;
1650: end if;
1651: --
1652: if g_debug then
1653: hr_utility.set_location(l_proc, 40);
1654: end if;
1655: --
1656: if l_count = 0 then
1657: --

Line 1659: hr_utility.set_location('Entering l_count 0:'|| l_proc, 50);

1655: --
1656: if l_count = 0 then
1657: --
1658: if g_debug then
1659: hr_utility.set_location('Entering l_count 0:'|| l_proc, 50);
1660: end if;
1661: --
1662: --
1663: l_last_rec_from := delete_recs.from_tab;

Line 1673: hr_utility.set_location('Entering when last date NULL:'|| l_proc, 60);

1669: if l_changedt_last = p_changedt_curr then
1670: --
1671: --
1672: if g_debug then
1673: hr_utility.set_location('Entering when last date NULL:'|| l_proc, 60);
1674: end if;
1675: --
1676: if delete_recs.from_tab = 'TRANSACTION' then
1677: --

Line 1703: hr_utility.set_location('Inserting when p_changedt_last NULL:'|| l_proc, 70);

1699: else
1700: --
1701: --
1702: if g_debug then
1703: hr_utility.set_location('Inserting when p_changedt_last NULL:'|| l_proc, 70);
1704: end if;
1705: --
1706: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;
1707: --

Line 1918: hr_utility.set_location('Entering l_count 1:'|| l_proc, 80);

1914: --
1915: elsif l_count = 1 then
1916: --
1917: if g_debug then
1918: hr_utility.set_location('Entering l_count 1:'|| l_proc, 80);
1919: end if;
1920: --
1921: l_curr_rec_from := delete_recs.from_tab;
1922: --

Line 1930: hr_utility.set_location('Entering last rec TRANS:'|| l_proc, 90);

1926: --
1927: if l_last_rec_from = 'TRANSACTION' then
1928: --
1929: if g_debug then
1930: hr_utility.set_location('Entering last rec TRANS:'|| l_proc, 90);
1931: end if;
1932: --
1933: --
1934: --update the last record with current recs date_to

Line 1943: hr_utility.set_location('Inserting last rec from PROPO:'|| l_proc, 120);

1939: else
1940: --
1941: --
1942: if g_debug then
1943: hr_utility.set_location('Inserting last rec from PROPO:'|| l_proc, 120);
1944: end if;
1945: --
1946: --
1947: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;--replace by Seq number

Line 2160: hr_utility.set_location('Entering curr rec from TRANS:'|| l_proc, 100);

2156: if delete_recs.from_tab = 'TRANSACTION' then
2157: --
2158: --
2159: if g_debug then
2160: hr_utility.set_location('Entering curr rec from TRANS:'|| l_proc, 100);
2161: end if;
2162: --
2163:
2164: if delete_recs.pay_proposal_id is null then

Line 2196: hr_utility.set_location('Inserting curr rec PROPOSAL:'|| l_proc, 110);

2192: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual; --replace by Seq number
2193: --
2194: --
2195: if g_debug then
2196: hr_utility.set_location('Inserting curr rec PROPOSAL:'|| l_proc, 110);
2197: end if;
2198: --
2199: l_last_change_date_curr := delete_recs.last_change_date;
2200: --

Line 2412: hr_utility.set_location('Incrementing l_count'|| l_proc, 55);

2408: end if;
2409: --
2410: --
2411: if g_debug then
2412: hr_utility.set_location('Incrementing l_count'|| l_proc, 55);
2413: end if;
2414: --
2415: l_count := l_count + 1;
2416: --

Line 2479: hr_utility.set_location('Entering:'|| l_proc, 10);

2475: --
2476: begin
2477: --
2478: if g_debug then
2479: hr_utility.set_location('Entering:'|| l_proc, 10);
2480: end if;
2481: --
2482: --
2483: --hr_utility.trace_on(null, 'TIGER');

Line 2483: --hr_utility.trace_on(null, 'TIGER');

2479: hr_utility.set_location('Entering:'|| l_proc, 10);
2480: end if;
2481: --
2482: --
2483: --hr_utility.trace_on(null, 'TIGER');
2484: --g_debug := TRUE;
2485: --
2486: l_change_amount_comp := 0 ;
2487: --

Line 2497: hr_utility.set_location('Entering:l_change amount'||l_change_amount_comp||l_proc, 10);

2493: l_change_amount_comp := l_change_amount_comp + (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100);
2494: --
2495: --
2496: if g_debug then
2497: hr_utility.set_location('Entering:l_change amount'||l_change_amount_comp||l_proc, 10);
2498: hr_utility.set_location('Entering:prior PROPOSED_SALARY_N'||p_prior_proposed_salary||l_proc, 10);
2499: end if;
2500: --
2501: if p_update_prior = 'Y' then

Line 2498: hr_utility.set_location('Entering:prior PROPOSED_SALARY_N'||p_prior_proposed_salary||l_proc, 10);

2494: --
2495: --
2496: if g_debug then
2497: hr_utility.set_location('Entering:l_change amount'||l_change_amount_comp||l_proc, 10);
2498: hr_utility.set_location('Entering:prior PROPOSED_SALARY_N'||p_prior_proposed_salary||l_proc, 10);
2499: end if;
2500: --
2501: if p_update_prior = 'Y' then
2502: --

Line 2505: hr_utility.set_location('Entering: prior Update:p_prior_transaction_id'||p_prior_transaction_id, 10);

2501: if p_update_prior = 'Y' then
2502: --
2503: --
2504: if g_debug then
2505: hr_utility.set_location('Entering: prior Update:p_prior_transaction_id'||p_prior_transaction_id, 10);
2506: end if;
2507: --
2508: update per_pay_transactions
2509: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100),

Line 2521: hr_utility.set_location('Entering: Else of prior Update'||l_proc, 10);

2517: --
2518: else
2519: --
2520: if g_debug then
2521: hr_utility.set_location('Entering: Else of prior Update'||l_proc, 10);
2522: end if;
2523: --
2524: update per_pay_transactions
2525: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100)

Line 2614: hr_utility.set_location('Entering:'|| l_proc, 10);

2610: --
2611: begin
2612: --
2613: if g_debug then
2614: hr_utility.set_location('Entering:'|| l_proc, 10);
2615: end if;
2616: --
2617: --
2618: --hr_utility.trace_on(null, 'TIGER');

Line 2618: --hr_utility.trace_on(null, 'TIGER');

2614: hr_utility.set_location('Entering:'|| l_proc, 10);
2615: end if;
2616: --
2617: --
2618: --hr_utility.trace_on(null, 'TIGER');
2619: --g_debug := TRUE;
2620: --
2621: l_count := 0;
2622: --

Line 2630: hr_utility.set_location(l_proc, 25);

2626: --
2627: for update_recs in csr_update_recs(p_assgn_id, p_changedate_curr, p_transaction_id) loop
2628: --
2629: if g_debug then
2630: hr_utility.set_location(l_proc, 25);
2631: end if;
2632: --
2633: l_change_amount := 0;
2634: --

Line 2638: hr_utility.set_location(l_proc||'l_count 0', 25);

2634: --
2635: if l_count = 0 then
2636: --
2637: if g_debug then
2638: hr_utility.set_location(l_proc||'l_count 0', 25);
2639: end if;
2640: --
2641: --
2642: l_prior_trans_id := update_recs.pay_transaction_id;

Line 2657: hr_utility.set_location('when last_change_date is null'||l_proc, 30);

2653: --
2654: if p_last_change_date is null then
2655: --
2656: if g_debug then
2657: hr_utility.set_location('when last_change_date is null'||l_proc, 30);
2658: hr_utility.set_location('l_prior_trans_id'||l_prior_trans_id||l_proc, 30);
2659: end if;
2660: --need to change prior record as well
2661: --when deleting only rec from PPP

Line 2658: hr_utility.set_location('l_prior_trans_id'||l_prior_trans_id||l_proc, 30);

2654: if p_last_change_date is null then
2655: --
2656: if g_debug then
2657: hr_utility.set_location('when last_change_date is null'||l_proc, 30);
2658: hr_utility.set_location('l_prior_trans_id'||l_prior_trans_id||l_proc, 30);
2659: end if;
2660: --need to change prior record as well
2661: --when deleting only rec from PPP
2662: update per_pay_transactions

Line 2684: hr_utility.set_location(l_proc||'l_count 1', 25);

2680: --immediate record to last record
2681: --to be updated in case of UPD/DEL
2682: --
2683: if g_debug then
2684: hr_utility.set_location(l_proc||'l_count 1', 25);
2685: end if;
2686: --
2687: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2688: --

Line 2690: hr_utility.set_location('No MULTIPLE_COMPONENTS '||l_prior_proposed_sal||l_proc, 25);

2686: --
2687: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2688: --
2689: if g_debug then
2690: hr_utility.set_location('No MULTIPLE_COMPONENTS '||l_prior_proposed_sal||l_proc, 25);
2691: end if;
2692: --
2693: if l_last_currency <> update_recs.input_currency_code then
2694: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate

Line 2738: hr_utility.set_location('l_change_amt'||l_change_amount, 25);

2734: l_xchg_rate);
2735:
2736: --
2737: if g_debug then
2738: hr_utility.set_location('l_change_amt'||l_change_amount, 25);
2739: end if;
2740: ----
2741: --Update only change amount , % remains same
2742: update per_pay_transactions

Line 2761: hr_utility.set_location(l_proc||'l_count :'||l_count, 25);

2757: elsif l_count > 1 then
2758: --
2759: --
2760: if g_debug then
2761: hr_utility.set_location(l_proc||'l_count :'||l_count, 25);
2762: end if;
2763: --
2764: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2765: --

Line 2767: hr_utility.set_location(l_proc||'No MULTIPLE_COMPONENTS'||l_count, 25);

2763: --
2764: if update_recs.MULTIPLE_COMPONENTS = 'N' then
2765: --
2766: if g_debug then
2767: hr_utility.set_location(l_proc||'No MULTIPLE_COMPONENTS'||l_count, 25);
2768: end if;
2769: --
2770: if l_last_currency <> update_recs.input_currency_code then
2771: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate

Line 2789: hr_utility.set_location('Multiple Comp'||l_proc, 25);

2785: --
2786: else
2787: --
2788: if g_debug then
2789: hr_utility.set_location('Multiple Comp'||l_proc, 25);
2790: end if;
2791: --
2792: if l_last_currency <> update_recs.input_currency_code then
2793: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate

Line 2889: hr_utility.set_location('Entering:'|| l_proc, 10);

2885: --
2886: p_status := 'N';
2887: --
2888: if g_debug then
2889: hr_utility.set_location('Entering:'|| l_proc, 10);
2890: end if;
2891: --
2892: open csr_rows_to_be_deleted(p_item_type, p_item_key, p_assignment_id);
2893: fetch csr_rows_to_be_deleted into l_pay_basis_id, l_pay_trans_id;

Line 3006: hr_utility.set_location('Entering '||l_proc,10);

3002: l_proc varchar2(61) := 'get_pay_transaction' ;
3003: --
3004: Begin
3005: --
3006: hr_utility.set_location('Entering '||l_proc,10);
3007: --
3008: p_update_mode := true;
3009: -- get the transaction id
3010: l_transaction_id := hr_transaction_ss.get_transaction_id

Line 3104: hr_utility.set_location('Leaving '||l_proc,99);

3100: --
3101: p_transaction_id := l_transaction_id;
3102: p_transaction_step_id := l_transaction_step_id;
3103: --
3104: hr_utility.set_location('Leaving '||l_proc,99);
3105: exception
3106: when others then
3107: hr_utility.set_location('Exception Raised',420);
3108: raise;

Line 3107: hr_utility.set_location('Exception Raised',420);

3103: --
3104: hr_utility.set_location('Leaving '||l_proc,99);
3105: exception
3106: when others then
3107: hr_utility.set_location('Exception Raised',420);
3108: raise;
3109: End get_pay_transaction;
3110: --
3111: ---------------------- process_salary_basis_change --------------------------------------

Line 3130: hr_utility.set_location('Entering '||l_proc,10);

3126: l_proc varchar2(61) := 'process_salary_basis_change' ;
3127: --
3128: Begin
3129: --
3130: hr_utility.set_location('Entering '||l_proc,10);
3131: --
3132: for csr_sel in csr_sel_item loop
3133: --
3134: hr_transaction_ss.process_web_api_call

Line 3141: hr_utility.set_location('Leaving '||l_proc,99);

3137: ,p_validate => false);
3138: end loop;
3139: --
3140: --
3141: hr_utility.set_location('Leaving '||l_proc,99);
3142: exception
3143: when others then
3144: hr_utility.set_location('Exception Raised',420);
3145: raise;

Line 3144: hr_utility.set_location('Exception Raised',420);

3140: --
3141: hr_utility.set_location('Leaving '||l_proc,99);
3142: exception
3143: when others then
3144: hr_utility.set_location('Exception Raised',420);
3145: raise;
3146: End process_salary_basis_change;
3147: --
3148: --

Line 3198: hr_utility.set_location('Entering '||l_proc,10);

3194: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;
3195: --
3196: Begin
3197: --
3198: hr_utility.set_location('Entering '||l_proc,10);
3199: --
3200: --
3201: --
3202: Open csr_eff_date;

Line 3213: hr_utility.set_location('Getting global assignment id = ' ||to_char(l_g_assignment_id),20);

3209: -- Set the Assignment Id to the one just created, don't use the
3210: -- transaction table.
3211:
3212: l_g_assignment_id := hr_process_person_ss.g_assignment_id;
3213: hr_utility.set_location('Getting global assignment id = ' ||to_char(l_g_assignment_id),20);
3214: --
3215: END IF;
3216: --
3217: -- query insert pay actions.

Line 3327: hr_utility.set_location('Leaving '||l_proc,99);

3323: p_validate => FALSE);
3324:
3325: End loop;
3326: --
3327: hr_utility.set_location('Leaving '||l_proc,99);
3328: exception
3329: when others then
3330: hr_utility.set_location('Exception Raised',420);
3331: raise;

Line 3330: hr_utility.set_location('Exception Raised',420);

3326: --
3327: hr_utility.set_location('Leaving '||l_proc,99);
3328: exception
3329: when others then
3330: hr_utility.set_location('Exception Raised',420);
3331: raise;
3332: --
3333: End process_create_pay_action;
3334: --

Line 3369: hr_utility.set_location('Entering '||l_proc,10);

3365: l_proc varchar2(61) := 'process_update_pay_action' ;
3366: --
3367: Begin
3368: --
3369: hr_utility.set_location('Entering '||l_proc,10);
3370: --
3371: per_pyp_bus.g_validate_ss_change_pay := 'Y';
3372: For l_pay_rec in csr_update_pay loop
3373: --

Line 3466: hr_utility.set_location('Leaving '||l_proc,99);

3462: p_validate => FALSE);
3463: --
3464: End loop;
3465: --
3466: hr_utility.set_location('Leaving '||l_proc,99);
3467: exception
3468: when others then
3469: per_pyp_bus.g_validate_ss_change_pay := 'N';
3470: hr_utility.set_location('Exception Raised',420);

Line 3470: hr_utility.set_location('Exception Raised',420);

3466: hr_utility.set_location('Leaving '||l_proc,99);
3467: exception
3468: when others then
3469: per_pyp_bus.g_validate_ss_change_pay := 'N';
3470: hr_utility.set_location('Exception Raised',420);
3471: raise;
3472: --
3473: End process_update_pay_action;
3474: --

Line 3502: hr_utility.set_location('Entering '||l_proc,10);

3498: l_proc varchar2(61) := 'process_delete_pay_action' ;
3499: --
3500: Begin
3501: --
3502: hr_utility.set_location('Entering '||l_proc,10);
3503: --
3504: For l_comp_rec in csr_delete_comp loop
3505: --
3506: Select object_version_number into l_comp_ovn

Line 3529: hr_utility.set_location('Leaving '||l_proc,99);

3525: ,p_validate => FALSE
3526: ,p_salary_warning => l_salary_warning);
3527: End loop;
3528:
3529: hr_utility.set_location('Leaving '||l_proc,99);
3530: exception
3531: when others then
3532: hr_utility.set_location('Exception Raised',420);
3533: raise;

Line 3532: hr_utility.set_location('Exception Raised',420);

3528:
3529: hr_utility.set_location('Leaving '||l_proc,99);
3530: exception
3531: when others then
3532: hr_utility.set_location('Exception Raised',420);
3533: raise;
3534: --
3535: End process_delete_pay_action;
3536:

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

3553: begin
3554:
3555: savepoint apply_change_pay_hire_txn;
3556: --
3557: hr_utility.set_location('Entering :'||l_proc,5);
3558: hr_utility.set_location('p_transaction_step_id :'||p_transaction_step_id,5);
3559: hr_utility.set_location('p_item_key :'||p_item_key,5);
3560: hr_utility.set_location('p_item_type :'||p_item_type,5);
3561: --

Line 3558: hr_utility.set_location('p_transaction_step_id :'||p_transaction_step_id,5);

3554:
3555: savepoint apply_change_pay_hire_txn;
3556: --
3557: hr_utility.set_location('Entering :'||l_proc,5);
3558: hr_utility.set_location('p_transaction_step_id :'||p_transaction_step_id,5);
3559: hr_utility.set_location('p_item_key :'||p_item_key,5);
3560: hr_utility.set_location('p_item_type :'||p_item_type,5);
3561: --
3562: Open csr_sel_item;

Line 3559: hr_utility.set_location('p_item_key :'||p_item_key,5);

3555: savepoint apply_change_pay_hire_txn;
3556: --
3557: hr_utility.set_location('Entering :'||l_proc,5);
3558: hr_utility.set_location('p_transaction_step_id :'||p_transaction_step_id,5);
3559: hr_utility.set_location('p_item_key :'||p_item_key,5);
3560: hr_utility.set_location('p_item_type :'||p_item_type,5);
3561: --
3562: Open csr_sel_item;
3563: Fetch csr_sel_item into l_item_type,l_item_key;

Line 3560: hr_utility.set_location('p_item_type :'||p_item_type,5);

3556: --
3557: hr_utility.set_location('Entering :'||l_proc,5);
3558: hr_utility.set_location('p_transaction_step_id :'||p_transaction_step_id,5);
3559: hr_utility.set_location('p_item_key :'||p_item_key,5);
3560: hr_utility.set_location('p_item_type :'||p_item_type,5);
3561: --
3562: Open csr_sel_item;
3563: Fetch csr_sel_item into l_item_type,l_item_key;
3564: Close csr_sel_item;

Line 3571: hr_utility.set_location('l_item_key :'||l_item_key,15);

3567: then
3568: l_item_type := p_item_type;
3569: l_item_key := p_item_key;
3570:
3571: hr_utility.set_location('l_item_key :'||l_item_key,15);
3572: hr_utility.set_location('l_item_type :'||l_item_type,15);
3573: end if;
3574:
3575: hr_new_user_reg_ss.process_selected_transaction

Line 3572: hr_utility.set_location('l_item_type :'||l_item_type,15);

3568: l_item_type := p_item_type;
3569: l_item_key := p_item_key;
3570:
3571: hr_utility.set_location('l_item_key :'||l_item_key,15);
3572: hr_utility.set_location('l_item_type :'||l_item_type,15);
3573: end if;
3574:
3575: hr_new_user_reg_ss.process_selected_transaction
3576: (p_item_type => l_item_type,

Line 3579: hr_utility.set_location('Exiting :'||l_proc,99);

3575: hr_new_user_reg_ss.process_selected_transaction
3576: (p_item_type => l_item_type,
3577: p_item_key => l_item_key);
3578:
3579: hr_utility.set_location('Exiting :'||l_proc,99);
3580: exception
3581: when others then
3582: --
3583: ROLLBACK TO apply_change_pay_hire_txn;

Line 3585: hr_utility.set_location('Exception Raised',420);

3581: when others then
3582: --
3583: ROLLBACK TO apply_change_pay_hire_txn;
3584: --
3585: hr_utility.set_location('Exception Raised',420);
3586: raise;
3587: end;
3588: --
3589: --

Line 3610: hr_utility.set_location('Entering '||l_proc,10);

3606: Begin
3607: --
3608:
3609: --
3610: hr_utility.set_location('Entering '||l_proc,10);
3611: --
3612: savepoint apply_change_pay_txn;
3613: --
3614: -- gsp support changes --vkodedal 6141175

Line 3639: hr_utility.set_location('Profile check done '||l_proc,12);

3635: --
3636: -- BUG 6002700. Check for "HR Base Salary Required"
3637: check_base_salary_profile(p_transaction_step_id,p_item_key,p_item_type,p_effective_date,p_assignment_id);
3638: --
3639: hr_utility.set_location('Profile check done '||l_proc,12);
3640:
3641:
3642: --
3643: process_delete_pay_action(

Line 3646: hr_utility.set_location('After Deletes '||l_proc,10);

3642: --
3643: process_delete_pay_action(
3644: p_transaction_step_id => p_transaction_step_id);
3645: --
3646: hr_utility.set_location('After Deletes '||l_proc,10);
3647: --
3648: process_update_pay_action(
3649: p_transaction_step_id => p_transaction_step_id);
3650: --

Line 3651: hr_utility.set_location('After Updates '||l_proc,10);

3647: --
3648: process_update_pay_action(
3649: p_transaction_step_id => p_transaction_step_id);
3650: --
3651: hr_utility.set_location('After Updates '||l_proc,10);
3652: --
3653: process_create_pay_action(
3654: p_transaction_step_id => p_transaction_step_id);
3655: --

Line 3657: hr_utility.set_location('After Inserts '||l_proc,10);

3653: process_create_pay_action(
3654: p_transaction_step_id => p_transaction_step_id);
3655: --
3656: --
3657: hr_utility.set_location('After Inserts '||l_proc,10);
3658: --
3659: if nvl(p_validate,'N') = 'Y' then
3660: hr_utility.set_location('validate mode '||p_validate,10);
3661: raise hr_api.validate_enabled;

Line 3660: hr_utility.set_location('validate mode '||p_validate,10);

3656: --
3657: hr_utility.set_location('After Inserts '||l_proc,10);
3658: --
3659: if nvl(p_validate,'N') = 'Y' then
3660: hr_utility.set_location('validate mode '||p_validate,10);
3661: raise hr_api.validate_enabled;
3662: Else
3663: --
3664: -- Purge data from transaction tables.

Line 3671: hr_utility.set_location('Leaving '||l_proc,99);

3667: where transaction_step_id = p_transaction_step_id;
3668: --
3669: end if;
3670: --
3671: hr_utility.set_location('Leaving '||l_proc,99);
3672: --
3673: exception
3674: when hr_api.validate_enabled then
3675: --

Line 3681: hr_utility.set_location('Leaving after Rollback'||l_proc,99);

3677: -- we must rollback to the savepoint
3678: --
3679: ROLLBACK TO apply_change_pay_txn;
3680: --
3681: hr_utility.set_location('Leaving after Rollback'||l_proc,99);
3682: --
3683: when others then
3684: --
3685: ROLLBACK TO apply_change_pay_txn;

Line 3687: hr_utility.set_location('Exception Raised',420);

3683: when others then
3684: --
3685: ROLLBACK TO apply_change_pay_txn;
3686: --
3687: hr_utility.set_location('Exception Raised',420);
3688: raise;
3689: End;
3690: --
3691: --

Line 3714: hr_utility.set_location('Entering '||l_proc,10);

3710: l_return_status varchar2(1);
3711: --
3712: Begin
3713: --
3714: hr_utility.set_location('Entering '||l_proc,10);
3715: --
3716: savepoint apply_change_pay_txn1;
3717: --
3718: --10331318, 9857930 vkodedal 01-Dec-2010 delete the step created to show proposal on review page

Line 3749: hr_utility.set_location('After Deletes '||l_proc,10);

3745: --
3746: process_delete_pay_action(
3747: p_transaction_step_id => p_transaction_step_id);
3748: --
3749: hr_utility.set_location('After Deletes '||l_proc,10);
3750: --
3751: process_update_pay_action(
3752: p_transaction_step_id => p_transaction_step_id);
3753: --

Line 3754: hr_utility.set_location('After Updates '||l_proc,10);

3750: --
3751: process_update_pay_action(
3752: p_transaction_step_id => p_transaction_step_id);
3753: --
3754: hr_utility.set_location('After Updates '||l_proc,10);
3755: --
3756: process_create_pay_action(
3757: p_transaction_step_id => p_transaction_step_id);
3758: --

Line 3759: hr_utility.set_location('After Inserts '||l_proc,10);

3755: --
3756: process_create_pay_action(
3757: p_transaction_step_id => p_transaction_step_id);
3758: --
3759: hr_utility.set_location('After Inserts '||l_proc,10);
3760: --
3761: if p_validate then
3762: hr_utility.set_location('validate mode '||l_proc,10);
3763: raise hr_api.validate_enabled;

Line 3762: hr_utility.set_location('validate mode '||l_proc,10);

3758: --
3759: hr_utility.set_location('After Inserts '||l_proc,10);
3760: --
3761: if p_validate then
3762: hr_utility.set_location('validate mode '||l_proc,10);
3763: raise hr_api.validate_enabled;
3764: Else
3765: --
3766: --------vkodedal 09-Jul-2009 ER 4384022

Line 3767: hr_utility.set_location('Get the assignment id '||l_proc,10);

3763: raise hr_api.validate_enabled;
3764: Else
3765: --
3766: --------vkodedal 09-Jul-2009 ER 4384022
3767: hr_utility.set_location('Get the assignment id '||l_proc,10);
3768:
3769: Select DISTINCT ASSIGNMENT_ID into l_asg_id
3770: from per_pay_transactions
3771: where transaction_step_id =p_transaction_step_id;

Line 3774: hr_utility.set_location('Call HR_UTIL_MISC_SS.merge_attachments for asg id:'||l_asg_id,10);

3770: from per_pay_transactions
3771: where transaction_step_id =p_transaction_step_id;
3772: --
3773: /* start of code change for bug 11065050
3774: hr_utility.set_location('Call HR_UTIL_MISC_SS.merge_attachments for asg id:'||l_asg_id,10);
3775:
3776: HR_UTIL_MISC_SS.merge_attachments ( p_dest_entity_name => 'PER_ASSIGNMENTS_F',
3777: p_dest_pk1_value => l_asg_id,
3778: p_return_status =>l_return_status

Line 3794: hr_utility.set_location('Leaving '||l_proc,99);

3790: --
3791: */
3792: end if;
3793: --
3794: hr_utility.set_location('Leaving '||l_proc,99);
3795: --
3796: exception
3797: when hr_api.validate_enabled then
3798: --

Line 3804: hr_utility.set_location('Leaving after Rollback'||l_proc,99);

3800: -- we must rollback to the savepoint
3801: --
3802: ROLLBACK TO apply_change_pay_txn1;
3803: --
3804: hr_utility.set_location('Leaving after Rollback'||l_proc,99);
3805: --
3806: when others then
3807: --
3808: ROLLBACK TO apply_change_pay_txn1;

Line 3810: hr_utility.set_location('Exception Raised',420);

3806: when others then
3807: --
3808: ROLLBACK TO apply_change_pay_txn1;
3809: --
3810: hr_utility.set_location('Exception Raised',420);
3811: raise;
3812: --
3813: End process_api;
3814: --

Line 3979: -- hr_utility.trace_on(null, 'TIGER');

3975: --
3976: Begin
3977: --
3978: --
3979: -- hr_utility.trace_on(null, 'TIGER');
3980: -- g_debug := TRUE;
3981:
3982: l_proposals_exists := 'YES';
3983: l_payroll_attached := 'YES';

Line 3993: hr_utility.set_location('Enter get_create_date ', 1);

3989: p_default_salary_basis_id := null;
3990: p_basis_default_min_date := null;
3991: --
3992: if g_debug then
3993: hr_utility.set_location('Enter get_create_date ', 1);
3994: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3995: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3996: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3997: end if;

Line 3994: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);

3990: p_basis_default_min_date := null;
3991: --
3992: if g_debug then
3993: hr_utility.set_location('Enter get_create_date ', 1);
3994: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3995: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3996: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3997: end if;
3998:

Line 3995: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);

3991: --
3992: if g_debug then
3993: hr_utility.set_location('Enter get_create_date ', 1);
3994: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3995: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3996: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3997: end if;
3998:
3999: open csr_assgn_exists;

Line 3996: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);

3992: if g_debug then
3993: hr_utility.set_location('Enter get_create_date ', 1);
3994: hr_utility.set_location('p_assignment_id '||p_assignment_id, 2);
3995: hr_utility.set_location('p_effective_date: '||p_effective_date, 3);
3996: hr_utility.set_location('p_transaction_id '||p_transaction_id, 4);
3997: end if;
3998:
3999: open csr_assgn_exists;
4000: Fetch csr_assgn_exists into l_assgn_exists;

Line 4007: hr_utility.set_location('l_asst_on_gsp '||l_asst_on_gsp, 5);

4003: if l_assgn_exists is null then
4004:
4005: l_asst_on_gsp := PER_SSHR_CHANGE_PAY.Check_GSP_Manual_Override(p_assignment_id,p_effective_date,p_transaction_id);
4006: if g_debug then
4007: hr_utility.set_location('l_asst_on_gsp '||l_asst_on_gsp, 5);
4008: end if;
4009: if l_asst_on_gsp = 'N' then
4010: p_allow_create := 'Y_GSP';
4011: p_create_date := p_effective_date;

Line 4013: hr_utility.set_location('GSP EXISTS ', 6);

4009: if l_asst_on_gsp = 'N' then
4010: p_allow_create := 'Y_GSP';
4011: p_create_date := p_effective_date;
4012: if g_debug then
4013: hr_utility.set_location('GSP EXISTS ', 6);
4014: end if;
4015: return;
4016: end if;
4017:

Line 4026: hr_utility.set_location('New Hire and N_BASIS ', 5);

4022: close csr_txn_basis_id;
4023:
4024: if p_default_salary_basis_id is null then
4025: if g_debug then
4026: hr_utility.set_location('New Hire and N_BASIS ', 5);
4027: end if;
4028: p_create_date := sysdate;
4029: p_allow_create := 'N_BASIS';
4030: return;

Line 4048: hr_utility.set_location('New Hire and p_create_date '||p_create_date, 6);

4044: --p_basis_default_date
4045: --p_basis_default_min_date
4046: --p_orig_salary_basis_id
4047: if g_debug then
4048: hr_utility.set_location('New Hire and p_create_date '||p_create_date, 6);
4049: end if;
4050: else
4051: if p_effective_date > l_last_change_date then
4052: p_create_date := p_effective_date;

Line 4066: hr_utility.set_location('New Hire and p_create_date '||p_create_date, 7);

4062: --p_basis_default_date
4063: --p_basis_default_min_date
4064: --p_orig_salary_basis_id
4065: if g_debug then
4066: hr_utility.set_location('New Hire and p_create_date '||p_create_date, 7);
4067: end if;
4068: end if;
4069:
4070: return;

Line 4092: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);

4088: l_proposals_exists := 'NO';
4089: end if;
4090: --
4091: if g_debug then
4092: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
4093: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4094: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
4095: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
4096: end if;

Line 4093: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);

4089: end if;
4090: --
4091: if g_debug then
4092: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
4093: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4094: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
4095: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
4096: end if;
4097:

Line 4094: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);

4090: --
4091: if g_debug then
4092: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
4093: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4094: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
4095: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
4096: end if;
4097:
4098: --

Line 4095: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);

4091: if g_debug then
4092: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
4093: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4094: hr_utility.set_location('l_last_change_date '||l_last_change_date, 16);
4095: hr_utility.set_location('l_proposals_exists: '||l_proposals_exists, 17);
4096: end if;
4097:
4098: --
4099: -- CASE 1,2,3,4

Line 4126: hr_utility.set_location('l_max_create_date '||l_max_create_date, 18);

4122: l_min_create_date := l_last_payroll_run_date + 1;
4123: l_max_create_date_src := 'PAYROLL';
4124: end if;
4125: if g_debug then
4126: hr_utility.set_location('l_max_create_date '||l_max_create_date, 18);
4127: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 19);
4128: end if;
4129:
4130: --

Line 4127: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 19);

4123: l_max_create_date_src := 'PAYROLL';
4124: end if;
4125: if g_debug then
4126: hr_utility.set_location('l_max_create_date '||l_max_create_date, 18);
4127: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 19);
4128: end if;
4129:
4130: --
4131: if l_max_create_date_src = 'EFFECTIVEDATE' then

Line 4139: hr_utility.set_location('l_max_create_date '||l_max_create_date, 20);

4135: else
4136: l_min_create_date := l_last_change_date + 1;
4137: end if;
4138: if g_debug then
4139: hr_utility.set_location('l_max_create_date '||l_max_create_date, 20);
4140: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 21);
4141: end if;
4142: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4143: l_min_create_date := l_last_payroll_run_date + 1;

Line 4140: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 21);

4136: l_min_create_date := l_last_change_date + 1;
4137: end if;
4138: if g_debug then
4139: hr_utility.set_location('l_max_create_date '||l_max_create_date, 20);
4140: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 21);
4141: end if;
4142: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4143: l_min_create_date := l_last_payroll_run_date + 1;
4144: if g_debug then

Line 4145: hr_utility.set_location('l_max_create_date '||l_max_create_date, 22);

4141: end if;
4142: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4143: l_min_create_date := l_last_payroll_run_date + 1;
4144: if g_debug then
4145: hr_utility.set_location('l_max_create_date '||l_max_create_date, 22);
4146: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 23);
4147: end if;
4148: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4149: l_min_create_date := l_last_change_date + 1;

Line 4146: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 23);

4142: elsif l_payroll_attached = 'YES' and l_payroll_attached = 'NO' then
4143: l_min_create_date := l_last_payroll_run_date + 1;
4144: if g_debug then
4145: hr_utility.set_location('l_max_create_date '||l_max_create_date, 22);
4146: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 23);
4147: end if;
4148: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4149: l_min_create_date := l_last_change_date + 1;
4150: if g_debug then

Line 4151: hr_utility.set_location('l_max_create_date '||l_max_create_date, 24);

4147: end if;
4148: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4149: l_min_create_date := l_last_change_date + 1;
4150: if g_debug then
4151: hr_utility.set_location('l_max_create_date '||l_max_create_date, 24);
4152: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 25);
4153: end if;
4154: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'NO' then
4155: Open csr_asst_start_date;

Line 4152: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 25);

4148: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'YES' then
4149: l_min_create_date := l_last_change_date + 1;
4150: if g_debug then
4151: hr_utility.set_location('l_max_create_date '||l_max_create_date, 24);
4152: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 25);
4153: end if;
4154: elsif l_payroll_attached = 'NO' and l_proposals_exists = 'NO' then
4155: Open csr_asst_start_date;
4156: Fetch csr_asst_start_date into l_min_create_date;

Line 4162: hr_utility.set_location('l_max_create_date '||l_max_create_date, 26);

4158: if l_min_create_date is null then
4159: l_min_create_date := l_max_create_date;
4160: end if;
4161: if g_debug then
4162: hr_utility.set_location('l_max_create_date '||l_max_create_date, 26);
4163: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 27);
4164: end if;
4165: end if;
4166: end if;

Line 4163: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 27);

4159: l_min_create_date := l_max_create_date;
4160: end if;
4161: if g_debug then
4162: hr_utility.set_location('l_max_create_date '||l_max_create_date, 26);
4163: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 27);
4164: end if;
4165: end if;
4166: end if;
4167:

Line 4173: hr_utility.set_location('l_future_asst_change_max '||l_future_asst_change_max, 28);

4169:
4170: Open csr_future_asst_change_max(l_min_create_date,l_max_create_date);
4171: Fetch csr_future_asst_change_max into l_future_asst_change_max;
4172: if g_debug then
4173: hr_utility.set_location('l_future_asst_change_max '||l_future_asst_change_max, 28);
4174: end if;
4175: Close csr_future_asst_change_max;
4176:
4177: if l_future_asst_change_max is not null then

Line 4180: hr_utility.set_location('l_min_create_date '||l_min_create_date, 29);

4176:
4177: if l_future_asst_change_max is not null then
4178: l_min_create_date := l_future_asst_change_max;
4179: if g_debug then
4180: hr_utility.set_location('l_min_create_date '||l_min_create_date, 29);
4181: end if;
4182: end if;
4183: --
4184: p_create_date := l_max_create_date;

Line 4187: hr_utility.set_location('p_create_date '||p_create_date, 30);

4183: --
4184: p_create_date := l_max_create_date;
4185: p_min_create_date := l_min_create_date;
4186: if g_debug then
4187: hr_utility.set_location('p_create_date '||p_create_date, 30);
4188: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 35);
4189: end if;
4190: --
4191: Open csr_asst_change_date(l_max_create_date);

Line 4188: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 35);

4184: p_create_date := l_max_create_date;
4185: p_min_create_date := l_min_create_date;
4186: if g_debug then
4187: hr_utility.set_location('p_create_date '||p_create_date, 30);
4188: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 35);
4189: end if;
4190: --
4191: Open csr_asst_change_date(l_max_create_date);
4192: Fetch csr_asst_change_date into l_asst_change_date;

Line 4217: hr_utility.set_location('p_create_date '||p_create_date, 38);

4213: if (l_asst_change_date is not null and l_csr_asst_chg_count >1) then
4214: p_allow_create := 'M_BASIS';
4215: p_status := 5;
4216: if g_debug then
4217: hr_utility.set_location('p_create_date '||p_create_date, 38);
4218: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 39);
4219: end if;
4220: end if;
4221: --

Line 4218: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 39);

4214: p_allow_create := 'M_BASIS';
4215: p_status := 5;
4216: if g_debug then
4217: hr_utility.set_location('p_create_date '||p_create_date, 38);
4218: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 39);
4219: end if;
4220: end if;
4221: --
4222: -- CASE 5,6,7,8

Line 4236: hr_utility.set_location('p_create_date '||p_create_date, 40);

4232: p_allow_basis_change := 'YES';
4233: p_allow_date_change := 'YES';
4234: p_status := 1;
4235: if g_debug then
4236: hr_utility.set_location('p_create_date '||p_create_date, 40);
4237: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 45);
4238: end if;
4239: end if;
4240: end if;

Line 4237: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 45);

4233: p_allow_date_change := 'YES';
4234: p_status := 1;
4235: if g_debug then
4236: hr_utility.set_location('p_create_date '||p_create_date, 40);
4237: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 45);
4238: end if;
4239: end if;
4240: end if;
4241: --

Line 4252: hr_utility.set_location('p_create_date '||p_create_date, 47);

4248: p_allow_basis_change := 'NO';
4249: p_allow_date_change := 'YES';
4250: p_status := 1;
4251: if g_debug then
4252: hr_utility.set_location('p_create_date '||p_create_date, 47);
4253: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 48);
4254: end if;
4255: end if;
4256: end if;

Line 4253: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 48);

4249: p_allow_date_change := 'YES';
4250: p_status := 1;
4251: if g_debug then
4252: hr_utility.set_location('p_create_date '||p_create_date, 47);
4253: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 48);
4254: end if;
4255: end if;
4256: end if;
4257: --

Line 4270: hr_utility.set_location('p_create_date '||p_create_date, 50);

4266: p_allow_basis_change := 'YES';
4267: p_allow_date_change := 'YES';
4268: p_status := 2;
4269: if g_debug then
4270: hr_utility.set_location('p_create_date '||p_create_date, 50);
4271: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 55);
4272: end if;
4273: end if;
4274: end if;

Line 4271: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 55);

4267: p_allow_date_change := 'YES';
4268: p_status := 2;
4269: if g_debug then
4270: hr_utility.set_location('p_create_date '||p_create_date, 50);
4271: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 55);
4272: end if;
4273: end if;
4274: end if;
4275: --

Line 4288: hr_utility.set_location('p_create_date '||p_create_date, 60);

4284: p_allow_basis_change := 'YES';
4285: p_allow_date_change := 'YES';
4286: p_status := 3;
4287: if g_debug then
4288: hr_utility.set_location('p_create_date '||p_create_date, 60);
4289: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 65);
4290: end if;
4291: end if;
4292: --

Line 4289: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 65);

4285: p_allow_date_change := 'YES';
4286: p_status := 3;
4287: if g_debug then
4288: hr_utility.set_location('p_create_date '||p_create_date, 60);
4289: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 65);
4290: end if;
4291: end if;
4292: --
4293: -- CASE 17,18,19,20

Line 4305: hr_utility.set_location('p_create_date '||p_create_date, 70);

4301: p_allow_basis_change := 'YES';
4302: p_allow_date_change := 'YES';
4303: p_status := 4;
4304: if g_debug then
4305: hr_utility.set_location('p_create_date '||p_create_date, 70);
4306: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 75);
4307: end if;
4308: end if;
4309: --

Line 4306: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 75);

4302: p_allow_date_change := 'YES';
4303: p_status := 4;
4304: if g_debug then
4305: hr_utility.set_location('p_create_date '||p_create_date, 70);
4306: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 75);
4307: end if;
4308: end if;
4309: --
4310: -- CASE 21,22,23,24

Line 4325: hr_utility.set_location('p_create_date '||p_create_date, 80);

4321: p_allow_basis_change := 'YES';
4322: p_allow_date_change := 'YES';
4323: p_status := 4;
4324: if g_debug then
4325: hr_utility.set_location('p_create_date '||p_create_date, 80);
4326: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 85);
4327: end if;
4328: end if;
4329: --

Line 4326: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 85);

4322: p_allow_date_change := 'YES';
4323: p_status := 4;
4324: if g_debug then
4325: hr_utility.set_location('p_create_date '||p_create_date, 80);
4326: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 85);
4327: end if;
4328: end if;
4329: --
4330: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)

Line 4342: hr_utility.set_location('p_create_date '||p_create_date, 87);

4338: p_allow_basis_change := 'NO';
4339: p_allow_date_change := 'YES';
4340: p_status := 4;
4341: if g_debug then
4342: hr_utility.set_location('p_create_date '||p_create_date, 87);
4343: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 88);
4344: end if;
4345: end if;
4346: --

Line 4343: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 88);

4339: p_allow_date_change := 'YES';
4340: p_status := 4;
4341: if g_debug then
4342: hr_utility.set_location('p_create_date '||p_create_date, 87);
4343: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 88);
4344: end if;
4345: end if;
4346: --
4347: -- CASE 25 to 28

Line 4354: hr_utility.set_location('p_create_date '||p_create_date, 90);

4350: if (l_csr_asst_basis_chg_count > 1) then
4351: p_allow_create := 'M_BASIS';
4352: p_status := 5;
4353: if g_debug then
4354: hr_utility.set_location('p_create_date '||p_create_date, 90);
4355: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 95);
4356: end if;
4357: elsif (l_csr_asst_basis_chg_count = 1) then
4358: p_create_date := l_asst_basis_change_date;

Line 4355: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 95);

4351: p_allow_create := 'M_BASIS';
4352: p_status := 5;
4353: if g_debug then
4354: hr_utility.set_location('p_create_date '||p_create_date, 90);
4355: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 95);
4356: end if;
4357: elsif (l_csr_asst_basis_chg_count = 1) then
4358: p_create_date := l_asst_basis_change_date;
4359: p_min_create_date := l_asst_basis_change_date;

Line 4367: hr_utility.set_location('p_create_date '||p_create_date, 100);

4363: p_allow_basis_change := 'NO';
4364: p_allow_date_change := 'NO';
4365: p_status := 0;
4366: if g_debug then
4367: hr_utility.set_location('p_create_date '||p_create_date, 100);
4368: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 105);
4369: end if;
4370: end if;
4371: end if;

Line 4368: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 105);

4364: p_allow_date_change := 'NO';
4365: p_status := 0;
4366: if g_debug then
4367: hr_utility.set_location('p_create_date '||p_create_date, 100);
4368: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 105);
4369: end if;
4370: end if;
4371: end if;
4372: --

Line 4379: hr_utility.set_location('p_create_date '||p_create_date, 110);

4375: OR (l_csr_asst_basis_chg_count > 1)) then
4376: p_allow_create := 'M_BASIS';
4377: p_status := 5;
4378: if g_debug then
4379: hr_utility.set_location('p_create_date '||p_create_date, 110);
4380: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 115);
4381: end if;
4382: end if;
4383: --

Line 4380: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 115);

4376: p_allow_create := 'M_BASIS';
4377: p_status := 5;
4378: if g_debug then
4379: hr_utility.set_location('p_create_date '||p_create_date, 110);
4380: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 115);
4381: end if;
4382: end if;
4383: --
4384: l_asst_on_gsp := PER_SSHR_CHANGE_PAY.Check_GSP_Manual_Override(p_assignment_id,p_create_date,p_transaction_id);

Line 4388: hr_utility.set_location('GSP EXISTS ', 120);

4384: l_asst_on_gsp := PER_SSHR_CHANGE_PAY.Check_GSP_Manual_Override(p_assignment_id,p_create_date,p_transaction_id);
4385: if l_asst_on_gsp = 'N' then
4386: p_allow_create := 'Y_GSP';
4387: if g_debug then
4388: hr_utility.set_location('GSP EXISTS ', 120);
4389: end if;
4390: return;
4391: end if;
4392: --

Line 4406: hr_utility.set_location('p_default_salary_basis_id '||p_default_salary_basis_id, 130);

4402: Close csr_pay_basis_exists;
4403: end if;
4404:
4405: if g_debug then
4406: hr_utility.set_location('p_default_salary_basis_id '||p_default_salary_basis_id, 130);
4407: end if;
4408: end if;
4409:
4410: if p_default_salary_basis_id is null then

Line 4415: hr_utility.set_location('p_default_salary_basis_id '||p_default_salary_basis_id, 140);

4411: Open csr_txn_basis_id;
4412: fetch csr_txn_basis_id into p_default_salary_basis_id, p_orig_salary_basis_id;
4413: Close csr_txn_basis_id;
4414: if g_debug then
4415: hr_utility.set_location('p_default_salary_basis_id '||p_default_salary_basis_id, 140);
4416: end if;
4417: end if;
4418:
4419:

Line 4525: --hr_utility.trace_on(null, 'TIGER');

4521: --
4522: --
4523: Begin
4524: --
4525: --hr_utility.trace_on(null, 'TIGER');
4526: g_debug := TRUE;
4527: --
4528: if g_debug then
4529: hr_utility.set_location('Entering '||'get_Create_Date', 5);

Line 4529: hr_utility.set_location('Entering '||'get_Create_Date', 5);

4525: --hr_utility.trace_on(null, 'TIGER');
4526: g_debug := TRUE;
4527: --
4528: if g_debug then
4529: hr_utility.set_location('Entering '||'get_Create_Date', 5);
4530: end if;
4531: p_create_date := p_effective_date;
4532: p_allow_date_change := 'YES';
4533: p_allow_basis_change := 'YES';

Line 4540: hr_utility.set_location('Selected p_effective_date '||p_effective_date, 10);

4536:
4537: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4538:
4539: if g_debug then
4540: hr_utility.set_location('Selected p_effective_date '||p_effective_date, 10);
4541: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4542: end if;
4543:
4544: if(l_last_payroll_run_date is null) then

Line 4541: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);

4537: l_last_payroll_run_date := PER_SALADMIN_UTILITY.get_last_payroll_dt(p_assignment_id);
4538:
4539: if g_debug then
4540: hr_utility.set_location('Selected p_effective_date '||p_effective_date, 10);
4541: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
4542: end if;
4543:
4544: if(l_last_payroll_run_date is null) then
4545: l_last_payroll_run_date := p_effective_date;

Line 4548: hr_utility.set_location('l_last_payroll_run_date is null and set to '||l_last_payroll_run_date,20);

4544: if(l_last_payroll_run_date is null) then
4545: l_last_payroll_run_date := p_effective_date;
4546: l_payroll_attached := 'NO';
4547: if g_debug then
4548: hr_utility.set_location('l_last_payroll_run_date is null and set to '||l_last_payroll_run_date,20);
4549: end if;
4550: end if;
4551:
4552: Open csr_last_change_date;

Line 4561: hr_utility.set_location('l_last_change_date '||l_last_change_date, 25);

4557: Fetch csr_txn_basis_change_date into l_txn_basis_change_date,l_default_txn_salary_basis_id;
4558: Close csr_txn_basis_change_date;
4559:
4560: if g_debug then
4561: hr_utility.set_location('l_last_change_date '||l_last_change_date, 25);
4562: hr_utility.set_location('l_txn_basis_change_date '||l_txn_basis_change_date, 27);
4563: end if;
4564:
4565: if l_last_change_date is null then

Line 4562: hr_utility.set_location('l_txn_basis_change_date '||l_txn_basis_change_date, 27);

4558: Close csr_txn_basis_change_date;
4559:
4560: if g_debug then
4561: hr_utility.set_location('l_last_change_date '||l_last_change_date, 25);
4562: hr_utility.set_location('l_txn_basis_change_date '||l_txn_basis_change_date, 27);
4563: end if;
4564:
4565: if l_last_change_date is null then
4566: l_last_change_date := l_last_payroll_run_date;

Line 4569: hr_utility.set_location('l_last_change_date is null and set to '||l_last_change_date, 30);

4565: if l_last_change_date is null then
4566: l_last_change_date := l_last_payroll_run_date;
4567: l_proposals_exists := 'NO';
4568: if g_debug then
4569: hr_utility.set_location('l_last_change_date is null and set to '||l_last_change_date, 30);
4570: end if;
4571: end if;
4572:
4573: Open csr_last_asst_change_date(l_last_change_date);

Line 4579: hr_utility.set_location('l_csr_last_asst_chg_dt_count: '||l_csr_last_asst_chg_dt_count, 35);

4575: l_csr_last_asst_chg_dt_count:= csr_last_asst_change_date%ROWCOUNT;
4576: Close csr_last_asst_change_date;
4577:
4578: if g_debug then
4579: hr_utility.set_location('l_csr_last_asst_chg_dt_count: '||l_csr_last_asst_chg_dt_count, 35);
4580: hr_utility.set_location('l_last_assignment_change_date: '||l_last_assignment_change_date, 38);
4581: hr_utility.set_location('l_default_asst_salary_basis_id: '||l_default_asst_salary_basis_id, 39);
4582: end if;
4583: --

Line 4580: hr_utility.set_location('l_last_assignment_change_date: '||l_last_assignment_change_date, 38);

4576: Close csr_last_asst_change_date;
4577:
4578: if g_debug then
4579: hr_utility.set_location('l_csr_last_asst_chg_dt_count: '||l_csr_last_asst_chg_dt_count, 35);
4580: hr_utility.set_location('l_last_assignment_change_date: '||l_last_assignment_change_date, 38);
4581: hr_utility.set_location('l_default_asst_salary_basis_id: '||l_default_asst_salary_basis_id, 39);
4582: end if;
4583: --
4584: --

Line 4581: hr_utility.set_location('l_default_asst_salary_basis_id: '||l_default_asst_salary_basis_id, 39);

4577:
4578: if g_debug then
4579: hr_utility.set_location('l_csr_last_asst_chg_dt_count: '||l_csr_last_asst_chg_dt_count, 35);
4580: hr_utility.set_location('l_last_assignment_change_date: '||l_last_assignment_change_date, 38);
4581: hr_utility.set_location('l_default_asst_salary_basis_id: '||l_default_asst_salary_basis_id, 39);
4582: end if;
4583: --
4584: --
4585: if( (l_txn_basis_change_date is not null and l_last_assignment_change_date is not null and l_txn_basis_change_date <> l_last_assignment_change_date)

Line 4591: hr_utility.set_location('l_csr_last_asst_chg_dt_count>1:: M_BASIS::return ',40);

4587: (l_csr_last_asst_chg_dt_count >1)
4588: ) then
4589: p_allow_create := 'M_BASIS';
4590: if g_debug then
4591: hr_utility.set_location('l_csr_last_asst_chg_dt_count>1:: M_BASIS::return ',40);
4592: end if;
4593: return;
4594: else
4595: if g_debug then

Line 4596: hr_utility.set_location('l_csr_last_asst_chg_dt_count<1:: p_allow_create = Y ',43);

4592: end if;
4593: return;
4594: else
4595: if g_debug then
4596: hr_utility.set_location('l_csr_last_asst_chg_dt_count<1:: p_allow_create = Y ',43);
4597: end if;
4598: p_allow_create := 'Y';
4599: end if;
4600: --

Line 4607: hr_utility.set_location('TXN_SAL_BASIS_EXISTS and l_last_change_date = l_txn_basis_change_date',45);

4603: if (l_last_change_date = l_txn_basis_change_date) then
4604: p_allow_basis_change := 'NO';
4605:
4606: if g_debug then
4607: hr_utility.set_location('TXN_SAL_BASIS_EXISTS and l_last_change_date = l_txn_basis_change_date',45);
4608: end if;
4609:
4610: if (l_last_payroll_run_date > l_last_change_date) then
4611:

Line 4616: hr_utility.set_location('p_create_date '||p_create_date,46);

4612: if(l_payroll_attached = 'NO') then
4613: p_create_date := p_effective_date;
4614: p_min_create_date := l_last_change_date;
4615: if g_debug then
4616: hr_utility.set_location('p_create_date '||p_create_date,46);
4617: hr_utility.set_location('p_min_create_date '||p_min_create_date,47);
4618: end if;
4619: else
4620: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);

Line 4617: hr_utility.set_location('p_min_create_date '||p_min_create_date,47);

4613: p_create_date := p_effective_date;
4614: p_min_create_date := l_last_change_date;
4615: if g_debug then
4616: hr_utility.set_location('p_create_date '||p_create_date,46);
4617: hr_utility.set_location('p_min_create_date '||p_min_create_date,47);
4618: end if;
4619: else
4620: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4621: Fetch csr_get_next_payroll_date into p_create_date;

Line 4625: hr_utility.set_location('p_create_date '||p_create_date,48);

4621: Fetch csr_get_next_payroll_date into p_create_date;
4622: Close csr_get_next_payroll_date;
4623: p_min_create_date := l_last_payroll_run_date;
4624: if g_debug then
4625: hr_utility.set_location('p_create_date '||p_create_date,48);
4626: hr_utility.set_location('p_min_create_date '||p_min_create_date,49);
4627: end if;
4628: end if;
4629:

Line 4626: hr_utility.set_location('p_min_create_date '||p_min_create_date,49);

4622: Close csr_get_next_payroll_date;
4623: p_min_create_date := l_last_payroll_run_date;
4624: if g_debug then
4625: hr_utility.set_location('p_create_date '||p_create_date,48);
4626: hr_utility.set_location('p_min_create_date '||p_min_create_date,49);
4627: end if;
4628: end if;
4629:
4630: elsif (l_last_payroll_run_date = l_last_change_date) then

Line 4636: hr_utility.set_location('p_create_date '||p_create_date,50);

4632: if(l_payroll_attached = 'NO' and l_proposals_exists = 'YES') then
4633: p_create_date := l_last_change_date+1;
4634: p_min_create_date := l_last_change_date;
4635: if g_debug then
4636: hr_utility.set_location('p_create_date '||p_create_date,50);
4637: hr_utility.set_location('p_min_create_date '||p_min_create_date,51);
4638: end if;
4639: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4640: p_create_date := p_effective_date;

Line 4637: hr_utility.set_location('p_min_create_date '||p_min_create_date,51);

4633: p_create_date := l_last_change_date+1;
4634: p_min_create_date := l_last_change_date;
4635: if g_debug then
4636: hr_utility.set_location('p_create_date '||p_create_date,50);
4637: hr_utility.set_location('p_min_create_date '||p_min_create_date,51);
4638: end if;
4639: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4640: p_create_date := p_effective_date;
4641: p_min_create_date := p_effective_date;

Line 4643: hr_utility.set_location('p_create_date '||p_create_date,52);

4639: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4640: p_create_date := p_effective_date;
4641: p_min_create_date := p_effective_date;
4642: if g_debug then
4643: hr_utility.set_location('p_create_date '||p_create_date,52);
4644: hr_utility.set_location('p_min_create_date '||p_min_create_date,53);
4645: end if;
4646: else
4647: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);

Line 4644: hr_utility.set_location('p_min_create_date '||p_min_create_date,53);

4640: p_create_date := p_effective_date;
4641: p_min_create_date := p_effective_date;
4642: if g_debug then
4643: hr_utility.set_location('p_create_date '||p_create_date,52);
4644: hr_utility.set_location('p_min_create_date '||p_min_create_date,53);
4645: end if;
4646: else
4647: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4648: Fetch csr_get_next_payroll_date into p_create_date;

Line 4652: hr_utility.set_location('p_create_date '||p_create_date,54);

4648: Fetch csr_get_next_payroll_date into p_create_date;
4649: Close csr_get_next_payroll_date;
4650: p_min_create_date := l_last_change_date+1;
4651: if g_debug then
4652: hr_utility.set_location('p_create_date '||p_create_date,54);
4653: hr_utility.set_location('p_min_create_date '||p_min_create_date,55);
4654: end if;
4655: end if;
4656:

Line 4653: hr_utility.set_location('p_min_create_date '||p_min_create_date,55);

4649: Close csr_get_next_payroll_date;
4650: p_min_create_date := l_last_change_date+1;
4651: if g_debug then
4652: hr_utility.set_location('p_create_date '||p_create_date,54);
4653: hr_utility.set_location('p_min_create_date '||p_min_create_date,55);
4654: end if;
4655: end if;
4656:
4657: elsif (l_last_payroll_run_date < l_last_change_date) then

Line 4663: hr_utility.set_location('p_create_date '||p_create_date,56);

4659: if(l_payroll_attached = 'NO') then
4660: p_create_date := l_last_change_date+1;
4661: p_min_create_date := l_last_change_date;
4662: if g_debug then
4663: hr_utility.set_location('p_create_date '||p_create_date,56);
4664: hr_utility.set_location('p_min_create_date '||p_min_create_date,57);
4665: end if;
4666: else
4667: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);

Line 4664: hr_utility.set_location('p_min_create_date '||p_min_create_date,57);

4660: p_create_date := l_last_change_date+1;
4661: p_min_create_date := l_last_change_date;
4662: if g_debug then
4663: hr_utility.set_location('p_create_date '||p_create_date,56);
4664: hr_utility.set_location('p_min_create_date '||p_min_create_date,57);
4665: end if;
4666: else
4667: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4668: Fetch csr_get_next_payroll_date into p_create_date;

Line 4672: hr_utility.set_location('p_create_date '||p_create_date,61);

4668: Fetch csr_get_next_payroll_date into p_create_date;
4669: Close csr_get_next_payroll_date;
4670: p_min_create_date := l_last_change_date;
4671: if g_debug then
4672: hr_utility.set_location('p_create_date '||p_create_date,61);
4673: hr_utility.set_location('p_min_create_date '||p_min_create_date,63);
4674: end if;
4675: end if;
4676:

Line 4673: hr_utility.set_location('p_min_create_date '||p_min_create_date,63);

4669: Close csr_get_next_payroll_date;
4670: p_min_create_date := l_last_change_date;
4671: if g_debug then
4672: hr_utility.set_location('p_create_date '||p_create_date,61);
4673: hr_utility.set_location('p_min_create_date '||p_min_create_date,63);
4674: end if;
4675: end if;
4676:
4677: end if;

Line 4695: hr_utility.set_location('l_txn_basis_change_date >= l_last_payroll_run_date l_last_change_date ',66);

4691: p_create_date := l_txn_basis_change_date;
4692: p_min_create_date := l_txn_basis_change_date;
4693: p_allow_date_change := 'NO';
4694: if g_debug then
4695: hr_utility.set_location('l_txn_basis_change_date >= l_last_payroll_run_date l_last_change_date ',66);
4696: hr_utility.set_location('p_create_date '||p_create_date,67);
4697: hr_utility.set_location('p_min_create_date '||p_min_create_date,68);
4698: end if;
4699: else

Line 4696: hr_utility.set_location('p_create_date '||p_create_date,67);

4692: p_min_create_date := l_txn_basis_change_date;
4693: p_allow_date_change := 'NO';
4694: if g_debug then
4695: hr_utility.set_location('l_txn_basis_change_date >= l_last_payroll_run_date l_last_change_date ',66);
4696: hr_utility.set_location('p_create_date '||p_create_date,67);
4697: hr_utility.set_location('p_min_create_date '||p_min_create_date,68);
4698: end if;
4699: else
4700: p_create_date := null;

Line 4697: hr_utility.set_location('p_min_create_date '||p_min_create_date,68);

4693: p_allow_date_change := 'NO';
4694: if g_debug then
4695: hr_utility.set_location('l_txn_basis_change_date >= l_last_payroll_run_date l_last_change_date ',66);
4696: hr_utility.set_location('p_create_date '||p_create_date,67);
4697: hr_utility.set_location('p_min_create_date '||p_min_create_date,68);
4698: end if;
4699: else
4700: p_create_date := null;
4701: if g_debug then

Line 4702: hr_utility.set_location('p_create_date is set to null ', 69);

4698: end if;
4699: else
4700: p_create_date := null;
4701: if g_debug then
4702: hr_utility.set_location('p_create_date is set to null ', 69);
4703: end if;
4704: end if;
4705: end if;
4706: --

Line 4713: hr_utility.set_location('AST_SAL_BASIS_CHG_EXISTS', 70);

4709: if (l_last_change_date = l_last_assignment_change_date) then
4710: --p_allow_basis_change := 'NO';
4711:
4712: if g_debug then
4713: hr_utility.set_location('AST_SAL_BASIS_CHG_EXISTS', 70);
4714: end if;
4715:
4716: if (l_last_payroll_run_date > l_last_change_date) then
4717:

Line 4722: hr_utility.set_location('p_create_date '||p_create_date,71);

4718: if(l_payroll_attached = 'NO') then
4719: p_create_date := p_effective_date;
4720: p_min_create_date := l_last_change_date;
4721: if g_debug then
4722: hr_utility.set_location('p_create_date '||p_create_date,71);
4723: hr_utility.set_location('p_min_create_date '||p_min_create_date,72);
4724: end if;
4725: else
4726: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);

Line 4723: hr_utility.set_location('p_min_create_date '||p_min_create_date,72);

4719: p_create_date := p_effective_date;
4720: p_min_create_date := l_last_change_date;
4721: if g_debug then
4722: hr_utility.set_location('p_create_date '||p_create_date,71);
4723: hr_utility.set_location('p_min_create_date '||p_min_create_date,72);
4724: end if;
4725: else
4726: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4727: Fetch csr_get_next_payroll_date into p_create_date;

Line 4731: hr_utility.set_location('p_create_date '||p_create_date,73);

4727: Fetch csr_get_next_payroll_date into p_create_date;
4728: Close csr_get_next_payroll_date;
4729: p_min_create_date := l_last_payroll_run_date;
4730: if g_debug then
4731: hr_utility.set_location('p_create_date '||p_create_date,73);
4732: hr_utility.set_location('p_min_create_date '||p_min_create_date,74);
4733: end if;
4734: end if;
4735:

Line 4732: hr_utility.set_location('p_min_create_date '||p_min_create_date,74);

4728: Close csr_get_next_payroll_date;
4729: p_min_create_date := l_last_payroll_run_date;
4730: if g_debug then
4731: hr_utility.set_location('p_create_date '||p_create_date,73);
4732: hr_utility.set_location('p_min_create_date '||p_min_create_date,74);
4733: end if;
4734: end if;
4735:
4736: elsif (l_last_payroll_run_date = l_last_change_date) then

Line 4742: hr_utility.set_location('p_create_date '||p_create_date,75);

4738: if(l_payroll_attached = 'NO' and l_proposals_exists = 'YES') then
4739: p_create_date := l_last_change_date+1;
4740: p_min_create_date := l_last_change_date;
4741: if g_debug then
4742: hr_utility.set_location('p_create_date '||p_create_date,75);
4743: hr_utility.set_location('p_min_create_date '||p_min_create_date,76);
4744: end if;
4745: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4746: p_create_date := p_effective_date;

Line 4743: hr_utility.set_location('p_min_create_date '||p_min_create_date,76);

4739: p_create_date := l_last_change_date+1;
4740: p_min_create_date := l_last_change_date;
4741: if g_debug then
4742: hr_utility.set_location('p_create_date '||p_create_date,75);
4743: hr_utility.set_location('p_min_create_date '||p_min_create_date,76);
4744: end if;
4745: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4746: p_create_date := p_effective_date;
4747: p_min_create_date := p_effective_date;

Line 4749: hr_utility.set_location('p_create_date '||p_create_date,77);

4745: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4746: p_create_date := p_effective_date;
4747: p_min_create_date := p_effective_date;
4748: if g_debug then
4749: hr_utility.set_location('p_create_date '||p_create_date,77);
4750: hr_utility.set_location('p_min_create_date '||p_min_create_date,78);
4751: end if;
4752: else
4753: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);

Line 4750: hr_utility.set_location('p_min_create_date '||p_min_create_date,78);

4746: p_create_date := p_effective_date;
4747: p_min_create_date := p_effective_date;
4748: if g_debug then
4749: hr_utility.set_location('p_create_date '||p_create_date,77);
4750: hr_utility.set_location('p_min_create_date '||p_min_create_date,78);
4751: end if;
4752: else
4753: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4754: Fetch csr_get_next_payroll_date into p_create_date;

Line 4758: hr_utility.set_location('p_create_date '||p_create_date,79);

4754: Fetch csr_get_next_payroll_date into p_create_date;
4755: Close csr_get_next_payroll_date;
4756: p_min_create_date := l_last_change_date;
4757: if g_debug then
4758: hr_utility.set_location('p_create_date '||p_create_date,79);
4759: hr_utility.set_location('p_min_create_date '||p_min_create_date,80);
4760: end if;
4761: end if;
4762:

Line 4759: hr_utility.set_location('p_min_create_date '||p_min_create_date,80);

4755: Close csr_get_next_payroll_date;
4756: p_min_create_date := l_last_change_date;
4757: if g_debug then
4758: hr_utility.set_location('p_create_date '||p_create_date,79);
4759: hr_utility.set_location('p_min_create_date '||p_min_create_date,80);
4760: end if;
4761: end if;
4762:
4763: elsif (l_last_payroll_run_date < l_last_change_date) then

Line 4769: hr_utility.set_location('p_create_date '||p_create_date,83);

4765: if(l_payroll_attached = 'NO') then
4766: p_create_date := l_last_change_date+1;
4767: p_min_create_date := l_last_change_date;
4768: if g_debug then
4769: hr_utility.set_location('p_create_date '||p_create_date,83);
4770: hr_utility.set_location('p_min_create_date '||p_min_create_date,84);
4771: end if;
4772: else
4773: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);

Line 4770: hr_utility.set_location('p_min_create_date '||p_min_create_date,84);

4766: p_create_date := l_last_change_date+1;
4767: p_min_create_date := l_last_change_date;
4768: if g_debug then
4769: hr_utility.set_location('p_create_date '||p_create_date,83);
4770: hr_utility.set_location('p_min_create_date '||p_min_create_date,84);
4771: end if;
4772: else
4773: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4774: Fetch csr_get_next_payroll_date into p_create_date;

Line 4778: hr_utility.set_location('p_create_date '||p_create_date,87);

4774: Fetch csr_get_next_payroll_date into p_create_date;
4775: Close csr_get_next_payroll_date;
4776: p_min_create_date := l_last_change_date;
4777: if g_debug then
4778: hr_utility.set_location('p_create_date '||p_create_date,87);
4779: hr_utility.set_location('p_min_create_date '||p_min_create_date,88);
4780: end if;
4781: end if;
4782:

Line 4779: hr_utility.set_location('p_min_create_date '||p_min_create_date,88);

4775: Close csr_get_next_payroll_date;
4776: p_min_create_date := l_last_change_date;
4777: if g_debug then
4778: hr_utility.set_location('p_create_date '||p_create_date,87);
4779: hr_utility.set_location('p_min_create_date '||p_min_create_date,88);
4780: end if;
4781: end if;
4782:
4783: end if;

Line 4800: hr_utility.set_location('l_last_assignment_change_date > l_last_payroll_run_date ',90);

4796: p_create_date := l_last_assignment_change_date;
4797: p_min_create_date := l_txn_basis_change_date;
4798: p_allow_date_change := 'NO';
4799: if g_debug then
4800: hr_utility.set_location('l_last_assignment_change_date > l_last_payroll_run_date ',90);
4801: hr_utility.set_location('p_create_date '||p_create_date,95);
4802: hr_utility.set_location('p_min_create_date '||p_min_create_date,96);
4803: end if;
4804: else

Line 4801: hr_utility.set_location('p_create_date '||p_create_date,95);

4797: p_min_create_date := l_txn_basis_change_date;
4798: p_allow_date_change := 'NO';
4799: if g_debug then
4800: hr_utility.set_location('l_last_assignment_change_date > l_last_payroll_run_date ',90);
4801: hr_utility.set_location('p_create_date '||p_create_date,95);
4802: hr_utility.set_location('p_min_create_date '||p_min_create_date,96);
4803: end if;
4804: else
4805: p_create_date := null;

Line 4802: hr_utility.set_location('p_min_create_date '||p_min_create_date,96);

4798: p_allow_date_change := 'NO';
4799: if g_debug then
4800: hr_utility.set_location('l_last_assignment_change_date > l_last_payroll_run_date ',90);
4801: hr_utility.set_location('p_create_date '||p_create_date,95);
4802: hr_utility.set_location('p_min_create_date '||p_min_create_date,96);
4803: end if;
4804: else
4805: p_create_date := null;
4806: if g_debug then

Line 4807: hr_utility.set_location('p_create_date is set null ', 100);

4803: end if;
4804: else
4805: p_create_date := null;
4806: if g_debug then
4807: hr_utility.set_location('p_create_date is set null ', 100);
4808: end if;
4809: end if;
4810: end if;
4811: --

Line 4815: hr_utility.set_location('NO_SAL_BASIS_CHG ', 101);

4811: --
4812: --
4813: else
4814: if g_debug then
4815: hr_utility.set_location('NO_SAL_BASIS_CHG ', 101);
4816: end if;
4817: p_allow_basis_change := 'YES';
4818:
4819: if (l_last_payroll_run_date > l_last_change_date) then

Line 4825: hr_utility.set_location('p_create_date: '||p_create_date, 101);

4821: if(l_payroll_attached = 'NO') then
4822: p_create_date := p_effective_date;
4823: p_min_create_date := l_last_change_date;
4824: if g_debug then
4825: hr_utility.set_location('p_create_date: '||p_create_date, 101);
4826: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 102);
4827: end if;
4828: else
4829: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);

Line 4826: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 102);

4822: p_create_date := p_effective_date;
4823: p_min_create_date := l_last_change_date;
4824: if g_debug then
4825: hr_utility.set_location('p_create_date: '||p_create_date, 101);
4826: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 102);
4827: end if;
4828: else
4829: Open csr_get_next_payroll_date(p_assignment_id,l_last_payroll_run_date);
4830: Fetch csr_get_next_payroll_date into p_create_date;

Line 4834: hr_utility.set_location('p_create_date: '||p_create_date, 103);

4830: Fetch csr_get_next_payroll_date into p_create_date;
4831: Close csr_get_next_payroll_date;
4832: p_min_create_date := l_last_payroll_run_date;
4833: if g_debug then
4834: hr_utility.set_location('p_create_date: '||p_create_date, 103);
4835: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 104);
4836: end if;
4837: end if;
4838:

Line 4835: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 104);

4831: Close csr_get_next_payroll_date;
4832: p_min_create_date := l_last_payroll_run_date;
4833: if g_debug then
4834: hr_utility.set_location('p_create_date: '||p_create_date, 103);
4835: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 104);
4836: end if;
4837: end if;
4838:
4839: elsif (l_last_payroll_run_date = l_last_change_date) then

Line 4845: hr_utility.set_location('p_create_date: '||p_create_date, 105);

4841: if(l_payroll_attached = 'NO' and l_proposals_exists = 'YES' ) then
4842: p_create_date := l_last_change_date+1;
4843: p_min_create_date := p_effective_date;
4844: if g_debug then
4845: hr_utility.set_location('p_create_date: '||p_create_date, 105);
4846: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 106);
4847: end if;
4848: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4849: p_create_date := p_effective_date;

Line 4846: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 106);

4842: p_create_date := l_last_change_date+1;
4843: p_min_create_date := p_effective_date;
4844: if g_debug then
4845: hr_utility.set_location('p_create_date: '||p_create_date, 105);
4846: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 106);
4847: end if;
4848: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4849: p_create_date := p_effective_date;
4850: p_min_create_date := p_effective_date;

Line 4852: hr_utility.set_location('p_create_date '||p_create_date,107);

4848: elsif(l_payroll_attached = 'NO' and l_proposals_exists = 'NO') then
4849: p_create_date := p_effective_date;
4850: p_min_create_date := p_effective_date;
4851: if g_debug then
4852: hr_utility.set_location('p_create_date '||p_create_date,107);
4853: hr_utility.set_location('p_min_create_date '||p_min_create_date,108);
4854: end if;
4855: else
4856: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);

Line 4853: hr_utility.set_location('p_min_create_date '||p_min_create_date,108);

4849: p_create_date := p_effective_date;
4850: p_min_create_date := p_effective_date;
4851: if g_debug then
4852: hr_utility.set_location('p_create_date '||p_create_date,107);
4853: hr_utility.set_location('p_min_create_date '||p_min_create_date,108);
4854: end if;
4855: else
4856: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4857: Fetch csr_get_next_payroll_date into p_create_date;

Line 4861: hr_utility.set_location('p_create_date: '||p_create_date, 109);

4857: Fetch csr_get_next_payroll_date into p_create_date;
4858: Close csr_get_next_payroll_date;
4859: p_min_create_date := l_last_change_date+1;
4860: if g_debug then
4861: hr_utility.set_location('p_create_date: '||p_create_date, 109);
4862: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 110);
4863: end if;
4864: end if;
4865:

Line 4862: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 110);

4858: Close csr_get_next_payroll_date;
4859: p_min_create_date := l_last_change_date+1;
4860: if g_debug then
4861: hr_utility.set_location('p_create_date: '||p_create_date, 109);
4862: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 110);
4863: end if;
4864: end if;
4865:
4866: elsif (l_last_payroll_run_date < l_last_change_date) then

Line 4872: hr_utility.set_location('p_create_date: '||p_create_date, 111);

4868: if(l_payroll_attached = 'NO') then
4869: p_create_date := l_last_change_date+1;
4870: p_min_create_date := l_last_change_date;
4871: if g_debug then
4872: hr_utility.set_location('p_create_date: '||p_create_date, 111);
4873: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 112);
4874: end if;
4875: else
4876: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);

Line 4873: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 112);

4869: p_create_date := l_last_change_date+1;
4870: p_min_create_date := l_last_change_date;
4871: if g_debug then
4872: hr_utility.set_location('p_create_date: '||p_create_date, 111);
4873: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 112);
4874: end if;
4875: else
4876: Open csr_get_next_payroll_date(p_assignment_id,l_last_change_date);
4877: Fetch csr_get_next_payroll_date into p_create_date;

Line 4881: hr_utility.set_location('p_create_date: '||p_create_date, 117);

4877: Fetch csr_get_next_payroll_date into p_create_date;
4878: Close csr_get_next_payroll_date;
4879: p_min_create_date := l_last_change_date;
4880: if g_debug then
4881: hr_utility.set_location('p_create_date: '||p_create_date, 117);
4882: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 118);
4883: end if;
4884: end if;
4885:

Line 4882: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 118);

4878: Close csr_get_next_payroll_date;
4879: p_min_create_date := l_last_change_date;
4880: if g_debug then
4881: hr_utility.set_location('p_create_date: '||p_create_date, 117);
4882: hr_utility.set_location('p_min_create_date: '||p_min_create_date, 118);
4883: end if;
4884: end if;
4885:
4886: end if;

Line 4915: hr_utility.set_location('csr_pay_basis_exists : '||l_pay_basis_id, 120);

4911: end if;
4912: --
4913: --
4914: if g_debug then
4915: hr_utility.set_location('csr_pay_basis_exists : '||l_pay_basis_id, 120);
4916: hr_utility.set_location('p_allow_create : '||p_allow_create, 121);
4917: end if;
4918: --
4919: --

Line 4916: hr_utility.set_location('p_allow_create : '||p_allow_create, 121);

4912: --
4913: --
4914: if g_debug then
4915: hr_utility.set_location('csr_pay_basis_exists : '||l_pay_basis_id, 120);
4916: hr_utility.set_location('p_allow_create : '||p_allow_create, 121);
4917: end if;
4918: --
4919: --
4920: if l_default_txn_salary_basis_id is not null then

Line 4923: hr_utility.set_location('l_default_txn_salary_basis_id is not null ', 122);

4919: --
4920: if l_default_txn_salary_basis_id is not null then
4921: p_default_salary_basis_id := l_default_txn_salary_basis_id;
4922: if g_debug then
4923: hr_utility.set_location('l_default_txn_salary_basis_id is not null ', 122);
4924: end if;
4925: elsif l_default_asst_salary_basis_id is not null then
4926: p_default_salary_basis_id := l_default_asst_salary_basis_id;
4927: if g_debug then

Line 4928: hr_utility.set_location('l_default_asst_salary_basis_id is not null ', 124);

4924: end if;
4925: elsif l_default_asst_salary_basis_id is not null then
4926: p_default_salary_basis_id := l_default_asst_salary_basis_id;
4927: if g_debug then
4928: hr_utility.set_location('l_default_asst_salary_basis_id is not null ', 124);
4929: end if;
4930: end if;
4931: --
4932: --

Line 4939: hr_utility.set_location('p_min_create_date is not null '||p_min_create_date, 130);

4935: Open csr_curr_asst_change_date(p_create_date);
4936: Fetch csr_curr_asst_change_date into p_min_create_date;
4937: Close csr_curr_asst_change_date;
4938: if g_debug then
4939: hr_utility.set_location('p_min_create_date is not null '||p_min_create_date, 130);
4940: end if;
4941: else
4942: p_min_create_date := l_last_payroll_run_date;
4943: if g_debug then

Line 4944: hr_utility.set_location('p_min_create_date is not null '||p_min_create_date, 140);

4940: end if;
4941: else
4942: p_min_create_date := l_last_payroll_run_date;
4943: if g_debug then
4944: hr_utility.set_location('p_min_create_date is not null '||p_min_create_date, 140);
4945: end if;
4946: end if;
4947: end if;
4948: --

Line 4951: hr_utility.set_location('Leaving: '||'get_Create_Date', 150);

4947: end if;
4948: --
4949: --
4950: if g_debug then
4951: hr_utility.set_location('Leaving: '||'get_Create_Date', 150);
4952: end if;
4953: --
4954: --
4955: End get_Create_Date_old;

Line 5102: hr_utility.set_location('get_update_param ', 5);

5098: l_payroll_attached := 'NO';
5099: end if;
5100: --
5101: if g_debug then
5102: hr_utility.set_location('get_update_param ', 5);
5103: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
5104: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
5105: end if;
5106: l_max_create_date := p_previous_date;

Line 5103: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);

5099: end if;
5100: --
5101: if g_debug then
5102: hr_utility.set_location('get_update_param ', 5);
5103: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
5104: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
5105: end if;
5106: l_max_create_date := p_previous_date;
5107: l_min_create_date := p_previous_date;

Line 5104: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);

5100: --
5101: if g_debug then
5102: hr_utility.set_location('get_update_param ', 5);
5103: hr_utility.set_location('l_payroll_attached '||l_payroll_attached, 10);
5104: hr_utility.set_location('l_last_payroll_run_date: '||l_last_payroll_run_date, 15);
5105: end if;
5106: l_max_create_date := p_previous_date;
5107: l_min_create_date := p_previous_date;
5108: l_max_create_date_src := 'EFFECTIVEDATE';

Line 5137: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);

5133:
5134: p_min_update_date := l_min_create_date;
5135:
5136: if g_debug then
5137: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5138: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5139: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5140: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5141:

Line 5138: hr_utility.set_location('p_current_date: '||p_current_date, 26);

5134: p_min_update_date := l_min_create_date;
5135:
5136: if g_debug then
5137: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5138: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5139: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5140: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5141:
5142: end if;

Line 5139: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);

5135:
5136: if g_debug then
5137: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5138: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5139: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5140: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5141:
5142: end if;
5143: --

Line 5140: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);

5136: if g_debug then
5137: hr_utility.set_location('l_max_create_date '||l_max_create_date, 25);
5138: hr_utility.set_location('p_current_date: '||p_current_date, 26);
5139: hr_utility.set_location('l_min_create_date: '||l_min_create_date, 30);
5140: hr_utility.set_location('l_max_create_date_src: '||l_max_create_date_src, 31);
5141:
5142: end if;
5143: --
5144: Open csr_asst_change_date(l_max_create_date);

Line 5164: hr_utility.set_location('l_txn_asst_change_date '||l_txn_asst_change_date, 32);

5160: Close csr_txn_basis_change_date;
5161: --
5162: if (l_txn_asst_change_date is not null and l_txn_asst_change_date = p_current_date and l_asst_change_date is not null) then
5163: if g_debug then
5164: hr_utility.set_location('l_txn_asst_change_date '||l_txn_asst_change_date, 32);
5165: end if;
5166: l_txn_asst_change_date := null;
5167: end if;
5168:

Line 5171: hr_utility.set_location('l_txn_asst_change_date '||l_txn_asst_change_date, 33);

5167: end if;
5168:
5169: if (l_txn_basis_change_date is not null and l_txn_basis_change_date = p_current_date) then
5170: if g_debug then
5171: hr_utility.set_location('l_txn_asst_change_date '||l_txn_asst_change_date, 33);
5172: end if;
5173: l_txn_basis_change_date := null;
5174: end if;
5175: --

Line 5177: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);

5173: l_txn_basis_change_date := null;
5174: end if;
5175: --
5176: if g_debug then
5177: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5178: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5179: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5180: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5181: end if;

Line 5178: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);

5174: end if;
5175: --
5176: if g_debug then
5177: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5178: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5179: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5180: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5181: end if;
5182: --

Line 5179: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);

5175: --
5176: if g_debug then
5177: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5178: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5179: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5180: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5181: end if;
5182: --
5183: if (l_txn_basis_change_date is not null and l_asst_basis_change_date is null) then

Line 5180: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);

5176: if g_debug then
5177: hr_utility.set_location('l_asst_change_date '||l_asst_change_date, 36);
5178: hr_utility.set_location('l_asst_basis_change_date: '||l_asst_basis_change_date, 37);
5179: hr_utility.set_location('l_txn_asst_change_date: '||l_txn_asst_change_date, 38);
5180: hr_utility.set_location('l_txn_basis_change_date: '||l_txn_basis_change_date, 39);
5181: end if;
5182: --
5183: if (l_txn_basis_change_date is not null and l_asst_basis_change_date is null) then
5184: if (l_csr_asst_chg_count = 0 and

Line 5192: hr_utility.set_location('p_min_update_date '||p_min_update_date, 40);

5188: p_allow_basis_change := 'YES';
5189: p_allow_date_change := 'YES';
5190: p_status := 1;
5191: if g_debug then
5192: hr_utility.set_location('p_min_update_date '||p_min_update_date, 40);
5193: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 50);
5194: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 51);
5195: end if;
5196: end if;

Line 5193: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 50);

5189: p_allow_date_change := 'YES';
5190: p_status := 1;
5191: if g_debug then
5192: hr_utility.set_location('p_min_update_date '||p_min_update_date, 40);
5193: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 50);
5194: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 51);
5195: end if;
5196: end if;
5197: end if;

Line 5194: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 51);

5190: p_status := 1;
5191: if g_debug then
5192: hr_utility.set_location('p_min_update_date '||p_min_update_date, 40);
5193: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 50);
5194: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 51);
5195: end if;
5196: end if;
5197: end if;
5198: --

Line 5207: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 50);

5203: p_allow_basis_change := 'NO';
5204: p_allow_date_change := 'YES';
5205: p_status := 1;
5206: if g_debug then
5207: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 50);
5208: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 60);
5209: end if;
5210: end if;
5211: end if;

Line 5208: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 60);

5204: p_allow_date_change := 'YES';
5205: p_status := 1;
5206: if g_debug then
5207: hr_utility.set_location('p_allow_date_change '||p_allow_date_change, 50);
5208: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 60);
5209: end if;
5210: end if;
5211: end if;
5212: --

Line 5222: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);

5218: p_allow_basis_change := 'YES';
5219: p_allow_date_change := 'YES';
5220: p_status := 2;
5221: if g_debug then
5222: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5223: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5224: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5225: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5226: end if;

Line 5223: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);

5219: p_allow_date_change := 'YES';
5220: p_status := 2;
5221: if g_debug then
5222: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5223: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5224: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5225: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5226: end if;
5227: end if;

Line 5224: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);

5220: p_status := 2;
5221: if g_debug then
5222: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5223: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5224: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5225: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5226: end if;
5227: end if;
5228: end if;

Line 5225: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);

5221: if g_debug then
5222: hr_utility.set_location('p_min_update_date '||p_min_update_date, 65);
5223: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 70);
5224: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 71);
5225: hr_utility.set_location('p_allow_basis_change '||p_allow_basis_change, 72);
5226: end if;
5227: end if;
5228: end if;
5229: --

Line 5239: hr_utility.set_location('p_min_update_date '||p_min_update_date, 75);

5235: p_allow_basis_change := 'YES';
5236: p_allow_date_change := 'YES';
5237: p_status := 3;
5238: if g_debug then
5239: hr_utility.set_location('p_min_update_date '||p_min_update_date, 75);
5240: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 80);
5241: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 81);
5242: end if;
5243: end if;

Line 5240: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 80);

5236: p_allow_date_change := 'YES';
5237: p_status := 3;
5238: if g_debug then
5239: hr_utility.set_location('p_min_update_date '||p_min_update_date, 75);
5240: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 80);
5241: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 81);
5242: end if;
5243: end if;
5244: --

Line 5241: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 81);

5237: p_status := 3;
5238: if g_debug then
5239: hr_utility.set_location('p_min_update_date '||p_min_update_date, 75);
5240: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 80);
5241: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 81);
5242: end if;
5243: end if;
5244: --
5245: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)

Line 5254: hr_utility.set_location('p_min_update_date '||p_min_update_date, 85);

5250: p_allow_basis_change := 'YES';
5251: p_allow_date_change := 'YES';
5252: p_status := 4;
5253: if g_debug then
5254: hr_utility.set_location('p_min_update_date '||p_min_update_date, 85);
5255: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 90);
5256: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 91);
5257: end if;
5258: end if;

Line 5255: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 90);

5251: p_allow_date_change := 'YES';
5252: p_status := 4;
5253: if g_debug then
5254: hr_utility.set_location('p_min_update_date '||p_min_update_date, 85);
5255: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 90);
5256: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 91);
5257: end if;
5258: end if;
5259: --

Line 5256: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 91);

5252: p_status := 4;
5253: if g_debug then
5254: hr_utility.set_location('p_min_update_date '||p_min_update_date, 85);
5255: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 90);
5256: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 91);
5257: end if;
5258: end if;
5259: --
5260: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)

Line 5270: hr_utility.set_location('p_min_update_date '||p_min_update_date, 95);

5266: p_allow_basis_change := 'YES';
5267: p_allow_date_change := 'YES';
5268: p_status := 4;
5269: if g_debug then
5270: hr_utility.set_location('p_min_update_date '||p_min_update_date, 95);
5271: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5272: end if;
5273: end if;
5274: --

Line 5271: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);

5267: p_allow_date_change := 'YES';
5268: p_status := 4;
5269: if g_debug then
5270: hr_utility.set_location('p_min_update_date '||p_min_update_date, 95);
5271: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5272: end if;
5273: end if;
5274: --
5275: if ((l_asst_basis_change_date is null and l_asst_change_date is not null)

Line 5285: hr_utility.set_location('p_min_update_date '||p_min_update_date, 105);

5281: p_allow_basis_change := 'NO';
5282: p_allow_date_change := 'YES';
5283: p_status := 4;
5284: if g_debug then
5285: hr_utility.set_location('p_min_update_date '||p_min_update_date, 105);
5286: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5287: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 101);
5288: end if;
5289: end if;

Line 5286: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);

5282: p_allow_date_change := 'YES';
5283: p_status := 4;
5284: if g_debug then
5285: hr_utility.set_location('p_min_update_date '||p_min_update_date, 105);
5286: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5287: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 101);
5288: end if;
5289: end if;
5290: --

Line 5287: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 101);

5283: p_status := 4;
5284: if g_debug then
5285: hr_utility.set_location('p_min_update_date '||p_min_update_date, 105);
5286: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 100);
5287: hr_utility.set_location('p_basis_default_min_date '||p_basis_default_min_date, 101);
5288: end if;
5289: end if;
5290: --
5291: if (l_asst_basis_change_date is not null and l_txn_basis_change_date is null) then

Line 5299: hr_utility.set_location('p_min_update_date '||p_min_update_date, 115);

5295: p_allow_basis_change := 'NO';
5296: p_allow_date_change := 'NO';
5297: p_status := 0;
5298: if g_debug then
5299: hr_utility.set_location('p_min_update_date '||p_min_update_date, 115);
5300: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 120);
5301: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 121);
5302: end if;
5303: end if;

Line 5300: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 120);

5296: p_allow_date_change := 'NO';
5297: p_status := 0;
5298: if g_debug then
5299: hr_utility.set_location('p_min_update_date '||p_min_update_date, 115);
5300: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 120);
5301: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 121);
5302: end if;
5303: end if;
5304: end if;

Line 5301: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 121);

5297: p_status := 0;
5298: if g_debug then
5299: hr_utility.set_location('p_min_update_date '||p_min_update_date, 115);
5300: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 120);
5301: hr_utility.set_location('p_basis_default_date '||p_basis_default_date, 121);
5302: end if;
5303: end if;
5304: end if;
5305: --

Line 5424: hr_utility.set_location('get_fte_factor ', 5);

5420: --
5421: BEGIN
5422: --
5423: if g_debug then
5424: hr_utility.set_location('get_fte_factor ', 5);
5425: end if;
5426:
5427: if (l_fte_profile_value = 'NHBGWH') then
5428: open get_asg_hours;

Line 5469: hr_utility.set_location('-1-', 20);

5465: close get_pos_hrs;
5466: end if;
5467:
5468: if (l_hours is null or l_frequency is null or l_org_id is not null ) then
5469: hr_utility.set_location('-1-', 20);
5470: open get_org_hrs(l_org_id);
5471: fetch get_org_hrs into l_hours, l_frequency;
5472: close get_org_hrs;
5473: end if;

Line 5476: hr_utility.set_location('-2-', 20);

5472: close get_org_hrs;
5473: end if;
5474:
5475: if (l_hours is null or l_frequency is null or l_bg_id is not null) then
5476: hr_utility.set_location('-2-', 20);
5477: open get_bus_hrs(l_bg_id);
5478: fetch get_bus_hrs into l_hours, l_frequency;
5479: close get_bus_hrs;
5480: end if;