DBA Data[Home] [Help]

APPS.PER_IN_PERQUISITE_PKG dependencies on HR_GENERAL

Line 199: l_get_migrator_status:=hr_general.g_data_migrator_mode;

195:
196: p_message_name := 'SUCCESS';
197: pay_in_utils.null_message(p_token_name, p_token_value);
198:
199: l_get_migrator_status:=hr_general.g_data_migrator_mode;
200: hr_general.g_data_migrator_mode:='Y';
201: pay_in_utils.set_location(g_debug,l_procedure,20);
202:
203: /* Default the benefit Start date to element Entry Start Date */

Line 200: hr_general.g_data_migrator_mode:='Y';

196: p_message_name := 'SUCCESS';
197: pay_in_utils.null_message(p_token_name, p_token_value);
198:
199: l_get_migrator_status:=hr_general.g_data_migrator_mode;
200: hr_general.g_data_migrator_mode:='Y';
201: pay_in_utils.set_location(g_debug,l_procedure,20);
202:
203: /* Default the benefit Start date to element Entry Start Date */
204: OPEN c_curr_entry_value(p_element_entry_id,'Benefit Start Date',l_element_type_id);

Line 218: hr_general.g_data_migrator_mode:=l_get_migrator_status;

214: WHERE element_entry_value_id =l_entry_value_id
215: AND effective_start_date =p_effective_start_date;
216: END IF;
217: pay_in_utils.set_location(g_debug,l_procedure,40);
218: hr_general.g_data_migrator_mode:=l_get_migrator_status;
219: CLOSE c_curr_entry_value;
220:
221: pay_in_utils.set_location(g_debug,l_procedure,50);
222:

Line 523: l_get_migrator_status := hr_general.g_data_migrator_mode;

519: -- start - Check if exemption limit is exceeded
520: --
521:
522:
523: l_get_migrator_status := hr_general.g_data_migrator_mode;
524: hr_general.g_data_migrator_mode := 'Y';
525:
526: IF l_principal_amt_in_tax_yr > l_gbl_value then
527: /* Update the Taxable Flag to 'Y' when limit is exceeded */

Line 524: hr_general.g_data_migrator_mode := 'Y';

520: --
521:
522:
523: l_get_migrator_status := hr_general.g_data_migrator_mode;
524: hr_general.g_data_migrator_mode := 'Y';
525:
526: IF l_principal_amt_in_tax_yr > l_gbl_value then
527: /* Update the Taxable Flag to 'Y' when limit is exceeded */
528: FOR j IN 0 .. P_CNT - 1 LOOP

Line 560: hr_general.g_data_migrator_mode := l_get_migrator_status;

556: END LOOP;
557:
558: END IF;
559:
560: hr_general.g_data_migrator_mode := l_get_migrator_status;
561: --
562: -- End - Check if exemption limit is exceeded
563: --
564: /* delete the PL/SQL table */

Line 786: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','MOTOR_CAR');

782: IF l_first_count <> 0 THEN
783: pay_in_utils.set_location(g_debug,'Invalid entry Motor Car More than one entry : '||l_procedure,100);
784: p_message_name := 'PER_IN_INVALID_ELEMENT_ENTRY';
785: p_token_name(1) := 'TOKEN';
786: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','MOTOR_CAR');
787: RETURN;
788: END IF;
789: l_first_count := l_first_count +1;
790: ELSIF (l_element_entry_value(0) = 'CAR' and l_element_entry_value(1) = 'OWN_EMPLOYER' AND l_element_entry_value(2) = 'EMPLOYER' AND l_element_entry_value(3) ='PRIVATE') THEN

Line 797: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','MOTOR_CAR');

793: /* Raise an error for all other combination of values */
794: pay_in_utils.set_location(g_debug,'Invalid entry motor car : '||l_procedure,110);
795: p_message_name := 'PER_IN_INVALID_ELEMENT_ENTRY';
796: p_token_name(1) := 'TOKEN';
797: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','MOTOR_CAR');
798: RETURN;
799: END IF;
800:
801: END LOOP;

Line 808: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','MOTOR_CAR');

804: IF l_first_count <>1 THEN
805: pay_in_utils.set_location(g_debug,'Invalid entry in car entry : '||l_procedure,120);
806: p_message_name := 'PER_IN_INVALID_ELEMENT_ENTRY';
807: p_token_name(1) := 'TOKEN';
808: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','MOTOR_CAR');
809: RETURN;
810: END IF;
811:
812:

Line 1160: l_get_migrator_status:=hr_general.g_data_migrator_mode;

1156:
1157: p_message_name := 'SUCCESS';
1158: pay_in_utils.null_message(p_token_name, p_token_value);
1159:
1160: l_get_migrator_status:=hr_general.g_data_migrator_mode;
1161: -- Get the Element Name
1162:
1163: OPEN c_perquisite_name;
1164: FETCH c_perquisite_name INTO l_element_name,l_element_Type_id,l_assignment_id;

Line 1292: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RENT_EMPLOLYER');

1288: IF l_dep_value2 IS NULL or l_dep_value2 = 0 THEN
1289: pay_in_utils.null_message(p_token_name, p_token_value);
1290: p_message_name := 'PER_IN_ENTRY_VALUE_ZERO';
1291: p_token_name(1) := 'TOKEN1';
1292: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RENT_EMPLOLYER');
1293: p_token_name(2) := 'TOKEN2';
1294: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PROPERTY');
1295: p_token_name(3) := 'TOKEN3';
1296: p_token_value(3) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','LEASED');

Line 1294: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PROPERTY');

1290: p_message_name := 'PER_IN_ENTRY_VALUE_ZERO';
1291: p_token_name(1) := 'TOKEN1';
1292: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RENT_EMPLOLYER');
1293: p_token_name(2) := 'TOKEN2';
1294: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PROPERTY');
1295: p_token_name(3) := 'TOKEN3';
1296: p_token_value(3) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','LEASED');
1297:
1298: pay_in_utils.set_location(g_debug,'Company Accommodation '||l_procedure,25);

Line 1296: p_token_value(3) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','LEASED');

1292: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','RENT_EMPLOLYER');
1293: p_token_name(2) := 'TOKEN2';
1294: p_token_value(2) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','PROPERTY');
1295: p_token_name(3) := 'TOKEN3';
1296: p_token_value(3) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','LEASED');
1297:
1298: pay_in_utils.set_location(g_debug,'Company Accommodation '||l_procedure,25);
1299: RETURN;
1300: END IF;

Line 1318: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','COMP_ACC');

1314: IF l_dep_value2 IS NOT NULL AND l_dep_value2 <> 0 THEN
1315: pay_in_utils.null_message(p_token_name, p_token_value);
1316: p_message_name := 'PER_IN_INVALID_ELEMENT_ENTRY';
1317: p_token_name(1) := 'TOKEN';
1318: p_token_value(1):= hr_general.decode_lookup('IN_MESSAGE_TOKENS','COMP_ACC');
1319: pay_in_utils.set_location(g_debug,'Company Accommodation '||l_procedure,28);
1320: RETURN;
1321: END IF;
1322: