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 2005/05/31 00:05:15 appldev noship $ */
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 1116: 'hr_process_eit_ss.process_api' ||

1112: BEGIN
1113:
1114: hr_utility.set_location('Entering:'||l_proc, 5);
1115: hr_utility.trace(
1116: 'hr_process_eit_ss.process_api' ||
1117: ' p_transaction_step_id: ');--||p_transaction_step_id);
1118:
1119: --insert session because some flex uses the session effective date.
1120: if p_effective_date is not null then

Line 1145: 'hr_process_eit_ss.process_api' ||

1141: --debug
1142: if(hr_utility.debug_enabled)then
1143:
1144: hr_utility.trace(
1145: 'hr_process_eit_ss.process_api' ||
1146: ' p_person_id: '||l_person_id||
1147: ' p_login_person_id: '||l_login_person_id||
1148: ' p_eit_type: '||l_eit_type||
1149: ' p_eit_type_id: '||l_eit_type_id||

Line 1167: 'hr_process_eit_ss.process_api' ||

1163:
1164: hr_utility.trace('End of FOR '||l_proc);
1165:
1166: hr_utility.trace(
1167: 'hr_process_eit_ss.process_api' ||
1168: ' l_index: '||l_index);
1169:
1170: IF j = 1 AND l_eit_table(l_index).action = 'DELETE_ROW'
1171: OR j = 2 and l_eit_table(l_index).action <> 'DELETE_ROW' THEN

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

1174: IF l_eit_table(l_index).action = 'NEW_ROW' THEN
1175: -- hr_utility.trace('l_eit_table(l_index).action=NEW ROW'||l_proc);
1176:
1177: -- hr_utility.trace(
1178: -- 'hr_process_eit_ss.process_api' ||
1179: -- ' create a row: ');
1180:
1181: create_eit
1182: (p_validate => 0

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

1250: ,p_error_message => l_error_message
1251: );
1252:
1253: -- hr_utility.trace(
1254: -- 'hr_process_eit_ss.process_api' ||
1255: -- ' create a row with extra info type id'||l_extra_info_id);
1256:
1257:
1258: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN

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

1258: ELSIF l_eit_table(l_index).action = 'UPDATE_ROW' THEN
1259: -- hr_utility.trace('l_eit_table(l_index).action=UPDATE_ROW'||l_proc);
1260:
1261: -- hr_utility.trace(
1262: -- 'hr_process_eit_ss.process_api' ||
1263: -- ' update a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1264:
1265: update_eit
1266: (p_validate => 0

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

1337: ELSIF l_eit_table(l_index).action = 'DELETE_ROW' THEN
1338:
1339: -- hr_utility.trace('l_eit_table(l_index).action=DELETE_ROW:'||l_proc);
1340: -- hr_utility.trace(
1341: -- 'hr_process_eit_ss.process_api' ||
1342: -- ' delete a row with extra info type id'||l_eit_table(l_index).extra_info_id);
1343:
1344: delete_eit
1345: (p_validate => 0

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

1364: END IF;
1365: END IF;
1366:
1367: -- hr_utility.trace(
1368: -- 'hr_process_eit_ss.process_api' ||
1369: -- ' l_error_message: '||l_error_message);
1370:
1371: l_index := l_eit_table.next(l_index);
1372:

Line 1505: 'hr_process_eit_ss.create_eit' ||

1501: hr_utility.set_location('Entering:'||l_proc, 5);
1502: if(hr_utility.debug_enabled) then
1503:
1504: hr_utility.trace(
1505: 'hr_process_eit_ss.create_eit' ||
1506: ' arrive '||
1507: 'p_validate '||p_validate||
1508: ' p_login_person_id '||p_login_person_id||
1509: ' p_eit_type '||p_eit_type||

Line 1602: 'hr_process_eit_ss.create_eit' ||

1598:
1599: if p_eit_type = 'PERSON' then
1600: hr_utility.trace('if p_eit_type=PERSON:'||l_proc);
1601: hr_utility.trace(
1602: 'hr_process_eit_ss.create_eit' ||
1603: ' p_eit_type '||p_eit_type);
1604:
1605: hr_person_extra_info_api.create_person_extra_info
1606: (p_validate => hr_java_conv_util_ss.get_boolean (

Line 1671: 'hr_process_eit_ss.create_eit' ||

1667: p_object_version_number := l_object_version_number;
1668: p_extra_info_id := l_extra_info_id;
1669:
1670: hr_utility.trace(
1671: 'hr_process_eit_ss.create_eit' ||
1672: ' out nocopy create params '||
1673: ' p_person_extra_info_id '||l_extra_info_id||
1674: ' p_object_version_number '||l_object_version_number);
1675:

Line 1679: 'hr_process_eit_ss.create_eit' ||

1675:
1676: elsif p_eit_type = 'ASSIGNMENT' then
1677: hr_utility.trace('p_eit_type=ASSIGNMENT:'||l_proc);
1678: hr_utility.trace(
1679: 'hr_process_eit_ss.create_eit' ||
1680: ' p_eit_type '||p_eit_type);
1681:
1682: hr_assignment_extra_info_api.create_assignment_extra_info
1683: (p_validate => hr_java_conv_util_ss.get_boolean (

Line 1749: 'hr_process_eit_ss.create_eit' ||

1745: p_extra_info_id := l_extra_info_id;
1746:
1747: if(hr_utility.debug_enabled) then
1748: hr_utility.trace(
1749: 'hr_process_eit_ss.create_eit' ||
1750: ' out nocopy create params '||
1751: ' p_person_extra_info_id '||l_extra_info_id||
1752: ' p_object_version_number '||l_object_version_number);
1753: end if;

Line 1776: 'hr_process_eit_ss.create_eit' ||

1772: hr_utility.set_location('Exception:Others'||l_proc,555);
1773: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1774: p_error_message => p_error_message);
1775: hr_utility.trace(
1776: 'hr_process_eit_ss.create_eit' ||
1777: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
1778: --
1779: -- A validation or unexpected error has occurred
1780: --

Line 1891: 'hr_process_eit_ss.create_eit' ||

1887:
1888: if(hr_utility.debug_enabled) then
1889:
1890: hr_utility.trace(
1891: 'hr_process_eit_ss.create_eit' ||
1892: ' arrive '||
1893: 'p_validate '||p_validate||
1894: ' p_login_person_id '||p_login_person_id||
1895: ' p_eit_type '||p_eit_type||

Line 2104: 'hr_process_eit_ss.create_eit' ||

2100: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2101: p_error_message => p_error_message);
2102:
2103: hr_utility.trace(
2104: 'hr_process_eit_ss.create_eit' ||
2105: ' l_error_message: '||p_error_message ||' '|| sqlerrm );
2106:
2107: --
2108: -- A validation or unexpected error has occurred

Line 2206: 'hr_process_eit_ss.dump_eit_table' ||

2202:
2203: if(hr_utility.debug_enabled) then
2204:
2205: hr_utility.trace(
2206: 'hr_process_eit_ss.dump_eit_table' ||
2207: ' l_index :'||l_index||
2208: ' Action :'||p_eit_table(l_index).action||
2209: ' extra_info_id: '||p_eit_table(l_index).extra_info_id||
2210: ' object_version_number :'||p_eit_table(l_index).object_version_number||

Line 2275: end hr_process_eit_ss;

2271:
2272: END dump_eit_table;
2273:
2274:
2275: end hr_process_eit_ss;