eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_DATA_UTIL dependencies on HR_UTILITY

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

44: l_target_id number ;
45: begin
46:
47: l_proc := g_package || 'get_mapping_target' ;
48: hr_utility.set_location('Entering:'||l_proc, 5);
49: open c1 ;
50: fetch c1 into l_target_id ;
51: if c1%notfound then
52: close c1 ;

Line 58: hr_utility.set_location(' Leaving:'||l_proc, 10);

54: fnd_message.raise_error;
55: end if ;
56: close c1 ;
57: return l_target_id ;
58: hr_utility.set_location(' Leaving:'||l_proc, 10);
59: Exception
60: when others then
61: hr_utility.set_location(' exception :'||substr(sqlerrm ,1, 100), 30);
62: ben_dm_utility.message('INFO',' get_mapping_target ' || substr(sqlerrm ,1, 100) ,140);

Line 61: hr_utility.set_location(' exception :'||substr(sqlerrm ,1, 100), 30);

57: return l_target_id ;
58: hr_utility.set_location(' Leaving:'||l_proc, 10);
59: Exception
60: when others then
61: hr_utility.set_location(' exception :'||substr(sqlerrm ,1, 100), 30);
62: ben_dm_utility.message('INFO',' get_mapping_target ' || substr(sqlerrm ,1, 100) ,140);
63: raise ;
64: End get_mapping_target ;
65:

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

98:
99: begin
100:
101: l_proc := g_package || 'get_mapping_target' ;
102: hr_utility.set_location('Entering:'||l_proc, 5);
103:
104: if p_source_id = hr_api.g_number then
105: return p_source_id ;
106: end if ;

Line 114: hr_utility.set_location('Target Id not found for : ' ||p_table_name||'.'||p_source_column||

110: l_target_id := g_fk_maping_tbl(l_key);
111: end if;
112:
113: if l_target_id is null then
114: hr_utility.set_location('Target Id not found for : ' ||p_table_name||'.'||p_source_column||
115: '.'||p_source_id , 5);
116: ben_dm_utility.message('INFO',' Target ID Error ' ||p_table_name||'.'||p_source_column||
117: '.'||p_source_id ,5) ;
118: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

Line 124: hr_utility.set_location(' Leaving:'||l_proc, 10);

120:
121: end if ;
122:
123:
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: Return l_target_id ;
126:
127: Exception
128: when others then

Line 129: hr_utility.set_location(' exception :'||substr(sqlerrm ,1, 100), 30);

125: Return l_target_id ;
126:
127: Exception
128: when others then
129: hr_utility.set_location(' exception :'||substr(sqlerrm ,1, 100), 30);
130: ben_dm_utility.message('INFO',' get_mapping_target ' || substr(sqlerrm ,1, 100) ,140);
131: raise ;
132: End get_mapping_target ;
133:

Line 168: hr_utility.set_location('new id :'|| l_target_id , 5);

164:
165: if g_pk_maping_tbl.exists(l_key) then
166: l_target_id := g_pk_maping_tbl(l_key);
167: end if;
168: hr_utility.set_location('new id :'|| l_target_id , 5);
169:
170: Return l_target_id ;
171:
172: Exception

Line 174: hr_utility.set_location(' exception :'||substr(sqlerrm , 1,100), 30);

170: Return l_target_id ;
171:
172: Exception
173: when others then
174: hr_utility.set_location(' exception :'||substr(sqlerrm , 1,100), 30);
175: ben_dm_utility.message('INFO',' get_cache_target ' || substr(sqlerrm ,1, 100) ,140);
176: raise ;
177: End get_cache_target ;
178:

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

197: l_key varchar2(255);
198: l_proc varchar2(75) ;
199: Begin
200: l_proc := g_package||'create_pk_cache' ;
201: hr_utility.set_location(' Entering:'||l_proc, 10);
202:
203:
204: hr_utility.set_location('table :'||p_table_name , 5);
205: hr_utility.set_location('column :'||p_source_column , 5);

Line 204: hr_utility.set_location('table :'||p_table_name , 5);

200: l_proc := g_package||'create_pk_cache' ;
201: hr_utility.set_location(' Entering:'||l_proc, 10);
202:
203:
204: hr_utility.set_location('table :'||p_table_name , 5);
205: hr_utility.set_location('column :'||p_source_column , 5);
206: hr_utility.set_location('old id :'||p_source_id , 5);
207: hr_utility.set_location('new id :'||p_target_id , 5);
208: hr_utility.set_location('bg :'||p_business_group_name , 5);

Line 205: hr_utility.set_location('column :'||p_source_column , 5);

201: hr_utility.set_location(' Entering:'||l_proc, 10);
202:
203:
204: hr_utility.set_location('table :'||p_table_name , 5);
205: hr_utility.set_location('column :'||p_source_column , 5);
206: hr_utility.set_location('old id :'||p_source_id , 5);
207: hr_utility.set_location('new id :'||p_target_id , 5);
208: hr_utility.set_location('bg :'||p_business_group_name , 5);
209:

Line 206: hr_utility.set_location('old id :'||p_source_id , 5);

202:
203:
204: hr_utility.set_location('table :'||p_table_name , 5);
205: hr_utility.set_location('column :'||p_source_column , 5);
206: hr_utility.set_location('old id :'||p_source_id , 5);
207: hr_utility.set_location('new id :'||p_target_id , 5);
208: hr_utility.set_location('bg :'||p_business_group_name , 5);
209:
210: l_key := p_table_name||','||p_source_column||','||p_source_id||','||p_business_group_name;

Line 207: hr_utility.set_location('new id :'||p_target_id , 5);

203:
204: hr_utility.set_location('table :'||p_table_name , 5);
205: hr_utility.set_location('column :'||p_source_column , 5);
206: hr_utility.set_location('old id :'||p_source_id , 5);
207: hr_utility.set_location('new id :'||p_target_id , 5);
208: hr_utility.set_location('bg :'||p_business_group_name , 5);
209:
210: l_key := p_table_name||','||p_source_column||','||p_source_id||','||p_business_group_name;
211:

Line 208: hr_utility.set_location('bg :'||p_business_group_name , 5);

204: hr_utility.set_location('table :'||p_table_name , 5);
205: hr_utility.set_location('column :'||p_source_column , 5);
206: hr_utility.set_location('old id :'||p_source_id , 5);
207: hr_utility.set_location('new id :'||p_target_id , 5);
208: hr_utility.set_location('bg :'||p_business_group_name , 5);
209:
210: l_key := p_table_name||','||p_source_column||','||p_source_id||','||p_business_group_name;
211:
212: g_pk_maping_tbl(l_key) := p_target_id ;

Line 214: hr_utility.set_location(' Leaving:'||l_proc, 10);

210: l_key := p_table_name||','||p_source_column||','||p_source_id||','||p_business_group_name;
211:
212: g_pk_maping_tbl(l_key) := p_target_id ;
213:
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End ;
216:
217: ------------------------------------- create_fk_cache ------------------------
218: --- This procedure called from upload master package

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

235: where target_id is not null
236: ;
237: Begin
238: l_proc := g_package||'create_fk_cache' ;
239: hr_utility.set_location(' Entering:'||l_proc, 10);
240:
241:
242: g_fk_maping_tbl.delete ;
243: l_number := 1 ;

Line 252: hr_utility.set_location(' Leaving:'||l_proc, 10);

248: l_key := i.table_name||','||i.column_name||','||i.source_id||','||i.business_group_name;
249: g_fk_maping_tbl(l_key) := i.target_id ;
250: End Loop ;
251:
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End ;
254: -------------------------------- update_pk_mapping ---------------------------
255: -- This procedure update the target_id into ben_resolve_mappings
256: -- this can be called with three type of parameter set

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

321:
322: begin
323:
324: l_proc := g_package || 'update_pk_mapping' ;
325: hr_utility.set_location('Entering:'||l_proc, 5);
326:
327: if p_target_id is not null then
328: if p_resolve_mapping_id is not null then
329: l_resolve_mapping_id := p_resolve_mapping_id ;

Line 389: hr_utility.set_location(' Leaving:'||l_proc, 10);

385: set target_id = p_target_id
386: where resolve_mapping_id = l_resolve_mapping_id ;
387: end if ;
388: end if ;
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390:
391: Exception
392: when others then
393: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);

Line 393: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);

389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390:
391: Exception
392: when others then
393: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);
394: ben_dm_utility.message('INFO',' update_pk_mapping ' || substr(sqlerrm ,1, 100) ,140);
395: raise ;
396: end update_pk_mapping ;
397:

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

447:
448: begin
449:
450: l_proc := g_package || 'create_pk_mapping' ;
451: hr_utility.set_location('Entering:'||l_proc, 5);
452:
453: -- error if table_id and table name is null
454: if p_table_name is null and p_table_id is null then
455: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

Line 460: hr_utility.set_location('table_name:'||l_table_name, 5);

456: fnd_message.raise_error;
457: end if ;
458:
459: l_table_name := p_table_name ;
460: hr_utility.set_location('table_name:'||l_table_name, 5);
461: -- get the table name from the id
462: if p_table_name is null and p_table_id is not null then
463: open c1 ;
464: fetch c1 into l_table_name ;

Line 467: hr_utility.set_location('error on table_id :'|| p_table_id , 10);

463: open c1 ;
464: fetch c1 into l_table_name ;
465: if c1%notfound then
466: close c1 ;
467: hr_utility.set_location('error on table_id :'|| p_table_id , 10);
468: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
469: fnd_message.raise_error;
470: end if ;
471: close c1 ;

Line 493: hr_utility.set_location(' Leaving:'||l_proc, 15);

489: fetch c2 into l_resolve_mapping_id;
490: if c2%found then
491: close c2 ;
492: -- since the key found do nothing and return
493: hr_utility.set_location(' Leaving:'||l_proc, 15);
494: p_resolve_mapping_id := l_resolve_mapping_id;
495: Return ;
496: end if ;
497: close c2 ;

Line 498: hr_utility.set_location(' Inserting the value :'||l_proc, 20);

494: p_resolve_mapping_id := l_resolve_mapping_id;
495: Return ;
496: end if ;
497: close c2 ;
498: hr_utility.set_location(' Inserting the value :'||l_proc, 20);
499: -- get the pk key
500: select BEN_DM_RESOLVE_MAPPINGS_S.nextval
501: into p_resolve_mapping_id from dual ;
502:

Line 555: hr_utility.set_location(' Leaving:'||l_proc, 10);

551: g_resolve_mapping_cache(l_count).column_name := p_column_name;
552: g_resolve_mapping_cache(l_count).business_group_name := p_business_group_name;
553: g_resolve_mapping_cache(l_count).resolve_mapping_id := p_resolve_mapping_id;
554:
555: hr_utility.set_location(' Leaving:'||l_proc, 10);
556: Exception
557: when others then
558: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);
559: ben_dm_utility.message('INFO',' create_pk_mapping ' || substr(sqlerrm ,1, 100) ,140);

Line 558: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);

554:
555: hr_utility.set_location(' Leaving:'||l_proc, 10);
556: Exception
557: when others then
558: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);
559: ben_dm_utility.message('INFO',' create_pk_mapping ' || substr(sqlerrm ,1, 100) ,140);
560: raise ;
561:
562: end create_pk_mapping;

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

825: l_dummy varchar2(1) ;
826: begin
827:
828: l_proc := g_package || 'create_entity_result' ;
829: hr_utility.set_location('Entering:'||l_proc, 5);
830:
831:
832: -- ths procedure not validating any FK, assume everything is validated
833: -- before cal to the procedure

Line 1091: hr_utility.set_location(' Leaving:'||l_proc, 10);

1087: to_char(p_INFORMATION245,'dd-mon-rrrr');
1088:
1089: utl_file.put_line(ben_dm_gen_master.g_file_handle,l_text);
1090:
1091: hr_utility.set_location(' Leaving:'||l_proc, 10);
1092: Exception
1093: when others then
1094: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);
1095: raise ;

Line 1094: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);

1090:
1091: hr_utility.set_location(' Leaving:'||l_proc, 10);
1092: Exception
1093: when others then
1094: hr_utility.set_location(' exception :'||substr(sqlerrm , 100), 30);
1095: raise ;
1096: End create_entity_result ;
1097:
1098: function get_bg_id(p_business_group_name in VARCHAR2) Return Number is

Line 1112: hr_utility.set_location(' exception : no bg found', 30);

1108: return l_bg_id;
1109:
1110: exception
1111: when no_data_found then
1112: hr_utility.set_location(' exception : no bg found', 30);
1113: ben_dm_utility.message('INFO','bg not found:'||p_business_group_name , 5);
1114: raise;
1115:
1116: end get_bg_id;

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

1141: l_proc varchar2(75) ;
1142: begin
1143:
1144: l_proc := g_package ||'get_generator_version' ;
1145: hr_utility.set_location('Entering:'||l_proc, 5);
1146:
1147: ben_dm_utility.message('ROUT','entry: ' || l_proc , 5);
1148:
1149: -- get the version of download generator

Line 1222: hr_utility.set_location('Leaving :'||l_proc, 15);

1218: ben_dm_utility.message('PARA','(p_generator_version - ' ||
1219: p_generator_version || ')', 30);
1220: ben_dm_utility.message('ROUT','exit: ' || l_proc , 25);
1221:
1222: hr_utility.set_location('Leaving :'||l_proc, 15);
1223: exception
1224: when others then
1225: ben_dm_utility.error(SQLCODE,l_proc, '(p_generator_version - ' || p_generator_version ||
1226: ')','R');

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

1266: --
1267: -- Initialize PL/SQL table that will store the person id's that will
1268: -- be deleted if they exist in the target for a given group.
1269: --
1270: hr_utility.set_location('Entering:'||l_proc, 5);
1271: l_counter := 0;
1272: l_person_table.delete;
1273: --
1274: for x in csr_get_inf loop

Line 1328: hr_utility.set_location(' Leaving:'||l_proc, 10);

1324: hr_person_delete.delete_a_person(l_person_table(i), FALSE, SYSDATE);
1325:
1326: end loop;
1327:
1328: hr_utility.set_location(' Leaving:'||l_proc, 10);
1329: -- debug messages
1330: exception
1331: when others then
1332: hr_utility.set_location(' Exception :'||l_proc, 10);

Line 1332: hr_utility.set_location(' Exception :'||l_proc, 10);

1328: hr_utility.set_location(' Leaving:'||l_proc, 10);
1329: -- debug messages
1330: exception
1331: when others then
1332: hr_utility.set_location(' Exception :'||l_proc, 10);
1333: raise;
1334: end;
1335:
1336: Procedure Load_table ( p_table_name in varchar2

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

1355: l_table_id number ;
1356: l_proc varchar2(70) ;
1357: Begin
1358: l_proc := g_package || 'Load_table' ;
1359: hr_utility.set_location('Entering:'||l_proc, 5);
1360: ----ptilak(l_proc) ;
1361: open c1 ;
1362: fetch c1 into l_table_id ;
1363: if c1%found then

Line 1364: hr_utility.set_location(' Insert :'||p_table_name, 10);

1360: ----ptilak(l_proc) ;
1361: open c1 ;
1362: fetch c1 into l_table_id ;
1363: if c1%found then
1364: hr_utility.set_location(' Insert :'||p_table_name, 10);
1365: update ben_dm_tables
1366: set table_name = p_table_name
1367: ,upload_table_name = p_upload_table_name
1368: ,table_alias = p_table_alias

Line 1380: hr_utility.set_location(' Update :'||p_table_name, 10);

1376: ,last_update_login = fnd_global.login_id
1377: where table_id = l_table_id ;
1378:
1379: else
1380: hr_utility.set_location(' Update :'||p_table_name, 10);
1381: insert into ben_dm_tables
1382: ( table_id
1383: ,table_name
1384: ,upload_table_name

Line 1416: hr_utility.set_location(' Leaving:'||l_proc, 10);

1412: ) ;
1413: end if ;
1414: close c1 ;
1415:
1416: hr_utility.set_location(' Leaving:'||l_proc, 10);
1417: exception
1418: when others then
1419: raise ;
1420: end Load_table ;

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

1447: l_proc varchar2(70) ;
1448: Begin
1449: l_proc := g_package || 'load_table_order' ;
1450: --ptilak(l_proc) ;
1451: hr_utility.set_location('Entering:'||l_proc, 5);
1452:
1453: open c1 ;
1454: fetch c1 into l_table_id ;
1455: if c1%notfound then

Line 1466: hr_utility.set_location(' Insert :'||p_table_name, 10);

1462: open c2 ;
1463: fetch c2 into l_table_order_id ;
1464: if c2%found then
1465:
1466: hr_utility.set_location(' Insert :'||p_table_name, 10);
1467: update ben_dm_table_order
1468: set table_order = p_table_order
1469: ,last_update_date = sysdate
1470: ,last_updated_by = fnd_global.user_id

Line 1475: hr_utility.set_location(' Update :'||p_table_name, 10);

1471: ,last_update_login = fnd_global.login_id
1472: where table_order_id = l_table_order_id
1473: ;
1474: else
1475: hr_utility.set_location(' Update :'||p_table_name, 10);
1476: insert into ben_dm_table_order
1477: (table_order_id
1478: ,table_id
1479: ,table_order

Line 1499: hr_utility.set_location(' Leaving:'||l_proc, 10);

1495: end if ;
1496: close c2 ;
1497:
1498:
1499: hr_utility.set_location(' Leaving:'||l_proc, 10);
1500: exception
1501: when others then
1502: raise ;
1503:

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

1531:
1532: l_proc varchar2(70) ;
1533: Begin
1534: l_proc := g_package || 'load_hierarchy' ;
1535: hr_utility.set_location('Entering:'||l_proc, 5);
1536:
1537: open c1 ;
1538: fetch c1 into l_table_id ;
1539: if c1%notfound then

Line 1551: hr_utility.set_location(' Insert :'||p_table_name, 10);

1547: open c2 ;
1548: fetch c2 into l_hierarchy_id ;
1549: if c2%found then
1550:
1551: hr_utility.set_location(' Insert :'||p_table_name, 10);
1552: update ben_dm_hierarchies
1553: set parent_table_name = p_parent_table_name
1554: ,parent_column_name = p_parent_column_name
1555: ,parent_id_column_name = p_parent_id_column_name

Line 1562: hr_utility.set_location(' Update :'||p_table_name, 10);

1558: ,last_update_login = fnd_global.login_id
1559: where hierarchy_id = l_hierarchy_id
1560: ;
1561: else
1562: hr_utility.set_location(' Update :'||p_table_name, 10);
1563: insert into ben_dm_hierarchies
1564: ( hierarchy_id
1565: ,hierarchy_type
1566: ,table_id

Line 1594: hr_utility.set_location(' Leaving:'||l_proc, 10);

1590: end if ;
1591: close c2 ;
1592:
1593:
1594: hr_utility.set_location(' Leaving:'||l_proc, 10);
1595: exception
1596: when others then
1597: raise ;
1598:

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

1622:
1623: l_proc varchar2(70) ;
1624: Begin
1625: l_proc := g_package || 'load_mappings' ;
1626: hr_utility.set_location('Entering:'||l_proc, 5);
1627:
1628: open c1 ;
1629: fetch c1 into l_table_id ;
1630: if c1%notfound then

Line 1642: hr_utility.set_location(' Insert :'||p_table_name, 10);

1638: open c2 ;
1639: fetch c2 into l_column_mapping_id ;
1640: if c2%found then
1641:
1642: hr_utility.set_location(' Insert :'||p_table_name, 10);
1643: update ben_dm_column_mappings
1644: set entity_result_column_name = entity_result_column_name
1645: where column_mapping_id = l_column_mapping_id
1646: ;

Line 1648: hr_utility.set_location(' Update :'||p_table_name, 10);

1644: set entity_result_column_name = entity_result_column_name
1645: where column_mapping_id = l_column_mapping_id
1646: ;
1647: else
1648: hr_utility.set_location(' Update :'||p_table_name, 10);
1649: insert into ben_dm_column_mappings
1650: ( column_mapping_id
1651: ,table_id
1652: ,column_name

Line 1673: hr_utility.set_location(' Leaving:'||l_proc, 10);

1669: ) ;
1670: end if ;
1671: close c2 ;
1672:
1673: hr_utility.set_location(' Leaving:'||l_proc, 10);
1674: exception
1675: when others then
1676: raise ;
1677: END load_mappings ;

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

1700:
1701: l_proc varchar2(70) ;
1702: Begin
1703: l_proc := g_package || 'load_HR_PHASE_RULE' ;
1704: hr_utility.set_location('Entering:'||l_proc, 5);
1705:
1706: open c1 ;
1707: fetch c1 into l_dummy ;
1708: if c1%notfound then

Line 1740: hr_utility.set_location(' Leaving:'||l_proc, 10);

1736:
1737: end if ;
1738: close c1 ;
1739:
1740: hr_utility.set_location(' Leaving:'||l_proc, 10);
1741: exception
1742: when others then
1743: raise ;
1744: END load_HR_PHASE_RULE ;

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

1748: ) is
1749: l_proc varchar2(75) ;
1750: Begin
1751: l_proc := g_package || 'update_gen_version' ;
1752: hr_utility.set_location('Entering :'||l_proc, 5);
1753:
1754: update ben_dm_tables
1755: set GENERATOR_VERSION = replace(replace (p_version,' $Header:',''),' - ',':')
1756: , LAST_GENERATED_DATE = sysdate

Line 1759: hr_utility.set_location('Leaving:'||l_proc, 10);

1755: set GENERATOR_VERSION = replace(replace (p_version,' $Header:',''),' - ',':')
1756: , LAST_GENERATED_DATE = sysdate
1757: where table_id = p_table_id ;
1758:
1759: hr_utility.set_location('Leaving:'||l_proc, 10);
1760: end ;
1761: --
1762: function get_dm_flag return varchar2 as
1763: l_return varchar2(30) ;