DBA Data[Home] [Help]

APPS.HR_PROCESS_EIT_SS dependencies on HR_PROCESS_EIT_SS

Line 1: Package Body HR_PROCESS_EIT_SS as

1: Package Body HR_PROCESS_EIT_SS as
2: /* $Header: hreitwrs.pkb 120.0.12020000.3 2012/11/06 07:07:28 sudedas ship $ */
3: --
4: -- Package Variables
5: --

Line 12: g_package varchar2(31) := 'HR_PROCESS_EIT_SS';

8: l_count INTEGER := 0;
9: l_praddr_ovrlap VARCHAR2(2);
10: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
11: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
12: g_package varchar2(31) := 'HR_PROCESS_EIT_SS';
13: g_data_error exception;
14: l_message_number VARCHAR2(10);
15: p_trans_rec_count integer;
16:

Line 62: hr_utility.trace( 'hr_process_eit_ss.save_transaction_data' ||

58: l_transaction_id := hr_transaction_ss.get_transaction_id
59: (p_item_type => p_item_type
60: ,p_item_key => p_item_key);
61:
62: hr_utility.trace( 'hr_process_eit_ss.save_transaction_data' ||
63: ' l_transaction_id: '|| l_transaction_id);
64:
65: --
66: IF l_transaction_id is null THEN

Line 85: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

81: END IF;
82: --
83: -- Create a transaction step
84: --
85: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
86: ' l_transaction_id: '||l_transaction_id);
87:
88:
89: hr_transaction_api.get_transaction_step_info

Line 98: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

94: ,p_object_version_number => l_trs_object_version_number);
95:
96: if(hr_utility.debug_enabled) then
97:
98: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
99: ' l_transaction_id: '||l_transaction_id||
100: ' p_Item_Type: '||p_Item_Type||
101: ' p_Item_Key: '||p_Item_Key||
102: ' p_activity_id: '||p_activity_id||

Line 125: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

121: ,p_transaction_step_id => l_transaction_step_id
122: ,p_object_version_number => l_trs_object_version_number);
123: END IF;
124:
125: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
126: ' l_transaction_step_id: '||l_transaction_step_id
127: );
128:
129:

Line 186: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||

182: l_transaction_table(l_count).param_data_type := 'NUMBER';
183:
184: if(hr_utility.debug_enabled) then
185:
186: hr_utility.trace('hr_process_eit_ss.save_transaction_data' ||
187: ' p_person_id: '||p_person_id||
188: ' p_login_person_id: '||p_login_person_id||
189: ' p_eit_type: '||p_eit_type||
190: ' p_eit_number: '||p_eit_number);

Line 513: hr_utility.trace('hr_process_eit_ss.get_eit_data_from_tt' ||

509: hr_utility.set_location('Exception:Others'||l_proc,555);
510: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
511: p_error_message => p_error_message);
512:
513: hr_utility.trace('hr_process_eit_ss.get_eit_data_from_tt' ||
514: ' p_error_message: '||p_error_message);
515:
516:
517:

Line 561: 'hr_process_eit_ss.get_eit_data_from_tt' ||

557: -- to make further changes or to correct errors.
558: -----------------------------------------------------------------------------
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: hr_utility.trace(
561: 'hr_process_eit_ss.get_eit_data_from_tt' ||
562: ' p_item_type: '||p_item_type||
563: ' p_item_key: '||p_item_key||
564: ' p_activity_id: '||p_activity_id);
565:

Line 574: 'hr_process_eit_ss.get_eit_data_from_tt' ||

570: ,p_transaction_step_id => l_trans_step_id
571: ,p_object_version_number => l_trans_obj_vers_num);
572:
573: hr_utility.trace(
574: 'hr_process_eit_ss.get_eit_data_from_tt' ||
575: ' l_trans_step_id: '||l_trans_step_id||
576: ' l_trans_obj_vers_num: '||l_trans_obj_vers_num);
577:
578:

Line 612: 'hr_process_eit_ss.get_eit_data_from_tt' ||

608: ,p_active_row_id => p_active_row_id
609: );
610:
611: hr_utility.trace(
612: 'hr_process_eit_ss.get_eit_data_from_tt' ||
613: ' p_error_message: '||p_error_message);
614:
615: p_trans_rec_count := l_trans_rec_count;
616: hr_utility.set_location('Exiting:Funtion'||l_proc, 25);

Line 625: 'hr_process_eit_ss.get_eit_data_from_tt' ||

621: hr_utility.set_location('Exception:Others'||l_proc,555);
622: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
623: p_error_message => p_error_message);
624: hr_utility.trace(
625: 'hr_process_eit_ss.get_eit_data_from_tt' ||
626: ' p_error_message: '||p_error_message);
627:
628:
629: END get_eit_data_from_tt;

Line 658: 'hr_process_eit_ss.get_eit_data_from_tt' ||

654: begin
655:
656: hr_utility.set_location('Entering:'||l_proc, 5);
657: hr_utility.trace(
658: 'hr_process_eit_ss.get_eit_data_from_tt' ||
659: ' p_transaction_step_id: '||p_transaction_step_id);
660:
661:
662: p_person_id := hr_transaction_api.get_number_value

Line 718: 'hr_process_eit_ss.get_eit_data_from_tt' ||

714:
715: if(hr_utility.debug_enabled) then
716:
717: hr_utility.trace(
718: 'hr_process_eit_ss.get_eit_data_from_tt' ||
719: ' p_person_id: '||p_person_id||
720: ' p_login_person_id: '||p_login_person_id||
721: ' p_eit_type: '||p_eit_type||
722: ' p_eit_type_id: '||p_eit_type_id||

Line 739: -- 'hr_process_eit_ss.get_eit_data_from_tt' ||

735: --
736: l_eit_table.extend;
737:
738: -- hr_utility.trace(
739: -- 'hr_process_eit_ss.get_eit_data_from_tt' ||
740: -- ' i : '||i);
741: --
742: l_eit_table(i) := HR_EIT_STRUCTURE_TYPE
743: (

Line 1072: 'hr_process_eit_ss.del_transaction_data' ||

1068: end if;
1069: if(hr_utility.debug_enabled) then
1070:
1071: hr_utility.trace(
1072: 'hr_process_eit_ss.del_transaction_data' ||
1073: ' p_item_type: '||p_item_type||
1074: ' p_item_key: '||p_item_key||
1075: ' p_activity_id: '||p_activity_id||
1076: ' p_login_person_id: '||p_login_person_id);

Line 1124: 'hr_process_eit_ss.process_api' ||

1120: BEGIN
1121:
1122: hr_utility.set_location('Entering:'||l_proc, 5);
1123: hr_utility.trace(
1124: 'hr_process_eit_ss.process_api' ||
1125: ' p_transaction_step_id: ');--||p_transaction_step_id);
1126:
1127: --insert session because some flex uses the session effective date.
1128: if p_effective_date is not null then

Line 1157: 'hr_process_eit_ss.process_api' ||

1153: --debug
1154: if(hr_utility.debug_enabled)then
1155:
1156: hr_utility.trace(
1157: 'hr_process_eit_ss.process_api' ||
1158: ' p_person_id: '||l_person_id||
1159: ' p_login_person_id: '||l_login_person_id||
1160: ' p_eit_type: '||l_eit_type||
1161: ' p_eit_type_id: '||l_eit_type_id||

Line 1179: 'hr_process_eit_ss.process_api' ||

1175:
1176: hr_utility.trace('End of FOR '||l_proc);
1177:
1178: hr_utility.trace(
1179: 'hr_process_eit_ss.process_api' ||
1180: ' l_index: '||l_index);
1181:
1182: IF j = 1 AND l_eit_table(l_index).action = 'DELETE_ROW'
1183: OR j = 2 and l_eit_table(l_index).action <> 'DELETE_ROW' THEN

Line 1190: -- 'hr_process_eit_ss.process_api' ||

1186: IF l_eit_table(l_index).action = 'NEW_ROW' THEN
1187: -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
1188:
1189: -- hr_utility.trace(
1190: -- 'hr_process_eit_ss.process_api' ||
1191: -- ' create a row: ');
1192:
1193: create_eit
1194: (p_validate => 0

Line 1266: -- 'hr_process_eit_ss.process_api' ||

1262: ,p_error_message => l_error_message
1263: );
1264:
1265: -- hr_utility.trace(
1266: -- 'hr_process_eit_ss.process_api' ||
1267: -- ' create a row with extra info type id'||l_extra_info_id);
1268:
1269:
1270: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN

Line 1274: -- 'hr_process_eit_ss.process_api' ||

1270: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
1271: -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
1272:
1273: -- hr_utility.trace(
1274: -- 'hr_process_eit_ss.process_api' ||
1275: -- ' update a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1276:
1277: update_eit
1278: (p_validate => 0

Line 1353: -- 'hr_process_eit_ss.process_api' ||

1349: ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
1350:
1351: -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
1352: -- hr_utility.trace(
1353: -- 'hr_process_eit_ss.process_api' ||
1354: -- ' delete a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1355:
1356: delete_eit
1357: (p_validate => 0

Line 1380: -- 'hr_process_eit_ss.process_api' ||

1376: END IF;
1377: END IF;
1378:
1379: -- hr_utility.trace(
1380: -- 'hr_process_eit_ss.process_api' ||
1381: -- ' l_error_message: '||l_error_message);
1382:
1383: l_index := l_eit_table.next(l_index);
1384:

Line 1526: 'hr_process_eit_ss.create_eit' ||

1522: hr_utility.set_location('Entering:'||l_proc, 5);
1523: if(hr_utility.debug_enabled) then
1524:
1525: hr_utility.trace(
1526: 'hr_process_eit_ss.create_eit' ||
1527: ' arrive '||
1528: 'p_validate '||p_validate||
1529: ' p_login_person_id '||p_login_person_id||
1530: ' p_eit_type '||p_eit_type||

Line 1647: 'hr_process_eit_ss.create_eit' ||

1643:
1644: if p_eit_type = 'PERSON' then
1645: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);
1646: hr_utility.trace(
1647: 'hr_process_eit_ss.create_eit' ||
1648: ' p_eit_type '||p_eit_type);
1649:
1650: hr_person_extra_info_api.create_person_extra_info
1651: (p_validate => hr_java_conv_util_ss.get_boolean (

Line 1716: 'hr_process_eit_ss.create_eit' ||

1712: p_object_version_number := l_object_version_number;
1713: p_extra_info_id := l_extra_info_id;
1714:
1715: hr_utility.trace(
1716: 'hr_process_eit_ss.create_eit' ||
1717: ' out nocopy create params '||
1718: ' p_person_extra_info_id '||l_extra_info_id||
1719: ' p_object_version_number '||l_object_version_number);
1720:

Line 1724: 'hr_process_eit_ss.create_eit' ||

1720:
1721: elsif p_eit_type = 'ASSIGNMENT' then
1722: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
1723: hr_utility.trace(
1724: 'hr_process_eit_ss.create_eit' ||
1725: ' p_eit_type '||p_eit_type);
1726:
1727: hr_assignment_extra_info_api.create_assignment_extra_info
1728: (p_validate => hr_java_conv_util_ss.get_boolean (

Line 1794: 'hr_process_eit_ss.create_eit' ||

1790: p_extra_info_id := l_extra_info_id;
1791:
1792: if(hr_utility.debug_enabled) then
1793: hr_utility.trace(
1794: 'hr_process_eit_ss.create_eit' ||
1795: ' out nocopy create params '||
1796: ' p_person_extra_info_id '||l_extra_info_id||
1797: ' p_object_version_number '||l_object_version_number);
1798: end if;

Line 1821: 'hr_process_eit_ss.create_eit' ||

1817: hr_utility.set_location('Exception:Others'||l_proc,555);
1818: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1819: p_error_message => p_error_message);
1820: hr_utility.trace(
1821: 'hr_process_eit_ss.create_eit' ||
1822: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
1823: --
1824: -- A validation or unexpected error has occurred
1825: --

Line 1936: 'hr_process_eit_ss.create_eit' ||

1932:
1933: if(hr_utility.debug_enabled) then
1934:
1935: hr_utility.trace(
1936: 'hr_process_eit_ss.create_eit' ||
1937: ' arrive '||
1938: 'p_validate '||p_validate||
1939: ' p_login_person_id '||p_login_person_id||
1940: ' p_eit_type '||p_eit_type||

Line 2149: 'hr_process_eit_ss.create_eit' ||

2145: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2146: p_error_message => p_error_message);
2147:
2148: hr_utility.trace(
2149: 'hr_process_eit_ss.create_eit' ||
2150: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
2151:
2152: --
2153: -- A validation or unexpected error has occurred

Line 2251: 'hr_process_eit_ss.dump_eit_table' ||

2247:
2248: if(hr_utility.debug_enabled) then
2249:
2250: hr_utility.trace(
2251: 'hr_process_eit_ss.dump_eit_table' ||
2252: ' l_index :'||l_index||
2253: ' Action :'||p_eit_table(l_index).action||
2254: ' extra_info_id: '||p_eit_table(l_index).extra_info_id||
2255: ' object_version_number :'||p_eit_table(l_index).object_version_number||

Line 2320: end hr_process_eit_ss;

2316:
2317: END dump_eit_table;
2318:
2319:
2320: end hr_process_eit_ss;