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.PAY_IP_UTILITY dependencies on PAY_IP_UTILITY

Line 1: PACKAGE BODY pay_ip_utility AS

1: PACKAGE BODY pay_ip_utility AS
2: /* $Header: payiputil.pkb 120.9.12020000.7 2013/03/18 12:22:49 rmugloo noship $ */
3:
4: --
5: -- Global Variables

Line 190: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',10);

186: lv_segment_exists BOOLEAN;
187: lv_new_context_name VARCHAR2(50);
188: lv_val_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
189: BEGIN
190: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',10);
191: /*hr_utility.trace_on(null,'DFF_FLEX'); */
192: fnd_flex_dsc_api.set_session_mode('seed_data');
193:
194: lv_sql_stmt := 'select fdfc.application_id,

Line 228: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',20);

224: ,lv_description
225: ,lv_language ;
226: EXIT WHEN cv_get_context%NOTFOUND;
227:
228: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',20);
229: lv_new_context_name := p_legislation_code||substr(lv_desc_flex_context_code,3);
230: hr_utility.trace('lv_new_context_name '||lv_new_context_name );
231: lv_context_exists := fnd_flex_dsc_api.context_exists(
232: p_appl_short_name => p_appl_short_name

Line 271: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',30);

267: END IF;
268:
269: FOR get_segments_rec IN c_get_segments(lv_desc_flex_context_code)
270: LOOP
271: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',30);
272: hr_utility.trace('segments start');
273: OPEN c_get_val_set_name(get_segments_rec.FLEX_VALUE_SET_ID);
274: FETCH c_get_val_set_name INTO lv_val_set_name;
275: IF c_get_val_set_name%NOTFOUND THEN

Line 279: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',40);

275: IF c_get_val_set_name%NOTFOUND THEN
276: lv_val_set_name :=NULL;
277: END IF;
278: CLOSE c_get_val_set_name;
279: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',40);
280: lv_segment_exists := fnd_flex_dsc_api.segment_exists(
281: p_appl_short_name => p_appl_short_name
282: ,p_segment_name => get_segments_rec.END_USER_COLUMN_NAME
283: ,p_flexfield_name => p_dff_name

Line 350: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',50);

346: update_flex_col_usages_tl(lv_desc_flex_context_code,lv_new_context_name,p_dff_name);
347:
348: END LOOP;--get_context_rec
349: CLOSE cv_get_context;
350: hr_utility.set_location('pay_ip_utility.create_ele_info_dff_ctxt ',50);
351:
352: END create_ele_info_dff_ctxt;
353: -- ---------------------------------------------------------------------
354: -- Procedure to modify flex field structure for languages other than

Line 382: hr_utility.trace('Entered pay_ip_utility.update_flex_col_usages_tl');

378: AND b.descriptive_flex_context_code = cp_context_code;
379:
380: BEGIN
381:
382: hr_utility.trace('Entered pay_ip_utility.update_flex_col_usages_tl');
383:
384: FOR rec in c_get_segments_ol(P_SOURCE_CONTEXT_CODE)
385: LOOP
386:

Line 387: hr_utility.trace('Entered pay_ip_utility.update_flex_col_usages_tl --For Loop');

383:
384: FOR rec in c_get_segments_ol(P_SOURCE_CONTEXT_CODE)
385: LOOP
386:
387: hr_utility.trace('Entered pay_ip_utility.update_flex_col_usages_tl --For Loop');
388: UPDATE fnd_descr_flex_col_usage_tl SET
389: FORM_LEFT_PROMPT = rec.FORM_LEFT_PROMPT
390: ,FORM_ABOVE_PROMPT = rec.FORM_ABOVE_PROMPT
391: ,DESCRIPTION = rec.DESCRIPTION

Line 1286: hr_utility.set_location('pay_ip_utility.ins_element_class_ownership',10);

1282: FROM pay_element_classifications
1283: WHERE legislation_code = 'ZZ';
1284:
1285: BEGIN
1286: hr_utility.set_location('pay_ip_utility.ins_element_class_ownership',10);
1287: FOR rec IN get_element_class_csr LOOP
1288: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Element Classification', rec.classification_name);
1289: insert_ownership('CLASSIFICATION_ID','PAY',rec.classification_id);
1290: insert_ownership('CLASSIFICATION_ID','PER',rec.classification_id);

Line 1294: hr_utility.set_location('pay_ip_utility.ins_element_class_ownership',20);

1290: insert_ownership('CLASSIFICATION_ID','PER',rec.classification_id);
1291:
1292: END LOOP;
1293:
1294: hr_utility.set_location('pay_ip_utility.ins_element_class_ownership',20);
1295:
1296: END ins_element_class_ownership;
1297:
1298: -- ---------------------------------------------------------------------

Line 1311: hr_utility.set_location('pay_ip_utility.ins_bal_type_ownership',10);

1307: FROM pay_balance_types
1308: WHERE legislation_code = 'ZZ';
1309:
1310: BEGIN
1311: hr_utility.set_location('pay_ip_utility.ins_bal_type_ownership',10);
1312: FOR rec IN get_balance_type_csr LOOP
1313: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Type', rec.balance_name);
1314: insert_ownership('BALANCE_TYPE_ID','PAY',rec.balance_type_id);
1315: insert_ownership('BALANCE_TYPE_ID','PER',rec.balance_type_id);

Line 1319: hr_utility.set_location('pay_ip_utility.ins_bal_type_ownership',20);

1315: insert_ownership('BALANCE_TYPE_ID','PER',rec.balance_type_id);
1316:
1317: END LOOP;
1318:
1319: hr_utility.set_location('pay_ip_utility.ins_bal_type_ownership',20);
1320:
1321: END ins_bal_type_ownership;
1322:
1323: -- ---------------------------------------------------------------------

Line 1336: hr_utility.set_location('pay_ip_utility.ins_bal_dim_ownership',10);

1332: FROM pay_balance_dimensions
1333: WHERE legislation_code = 'ZZ';
1334:
1335: BEGIN
1336: hr_utility.set_location('pay_ip_utility.ins_bal_dim_ownership',10);
1337: FOR rec IN get_balance_dimension_csr LOOP
1338: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Dimension', rec.dimension_name);
1339: insert_ownership('BALANCE_DIMENSION_ID','PAY',rec.balance_dimension_id);
1340: insert_ownership('BALANCE_DIMENSION_ID','PER',rec.balance_dimension_id);

Line 1344: hr_utility.set_location('pay_ip_utility.ins_bal_dim_ownership',20);

1340: insert_ownership('BALANCE_DIMENSION_ID','PER',rec.balance_dimension_id);
1341:
1342: END LOOP;
1343:
1344: hr_utility.set_location('pay_ip_utility.ins_bal_dim_ownership',20);
1345:
1346: END ins_bal_dim_ownership;
1347:
1348: -- ---------------------------------------------------------------------

Line 1367: hr_utility.set_location('pay_ip_utility.ins_def_bal_ownership',10);

1363: AND pdb.balance_dimension_id = pbd.balance_dimension_id
1364: AND pdb.legislation_code = pbd.legislation_code;
1365:
1366: BEGIN
1367: hr_utility.set_location('pay_ip_utility.ins_def_bal_ownership',10);
1368: FOR rec IN get_defined_balance_csr LOOP
1369: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Defined Balance', rec.def_bal_name);
1370: insert_ownership('DEFINED_BALANCE_ID','PAY',rec.defined_balance_id);
1371: insert_ownership('DEFINED_BALANCE_ID','PER',rec.defined_balance_id);

Line 1375: hr_utility.set_location('pay_ip_utility.ins_def_bal_ownership',20);

1371: insert_ownership('DEFINED_BALANCE_ID','PER',rec.defined_balance_id);
1372:
1373: END LOOP;
1374:
1375: hr_utility.set_location('pay_ip_utility.ins_def_bal_ownership',20);
1376:
1377: END ins_def_bal_ownership;
1378:
1379: -- ---------------------------------------------------------------------

Line 1403: hr_utility.set_location('pay_ip_utility.ins_route_ownership',10);

1399: AND pbd.balance_dimension_id = pdr.balance_dimension_id
1400: AND pdr.route_id = route.route_id;
1401:
1402: BEGIN
1403: hr_utility.set_location('pay_ip_utility.ins_route_ownership',10);
1404: FOR rec IN get_route_csr LOOP
1405: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Route', rec.route_name);
1406: insert_ownership('ROUTE_ID','PAY',rec.route_id);
1407: insert_ownership('ROUTE_ID','PER',rec.route_id);

Line 1411: hr_utility.set_location('pay_ip_utility.ins_route_ownership',20);

1407: insert_ownership('ROUTE_ID','PER',rec.route_id);
1408:
1409: END LOOP;
1410:
1411: hr_utility.set_location('pay_ip_utility.ins_route_ownership',20);
1412:
1413: END ins_route_ownership;
1414:
1415: -- ---------------------------------------------------------------------

Line 1428: hr_utility.set_location('pay_ip_utility.ins_bal_cat_ownership',10);

1424: FROM pay_balance_categories_f
1425: WHERE legislation_code = 'ZZ';
1426:
1427: BEGIN
1428: hr_utility.set_location('pay_ip_utility.ins_bal_cat_ownership',10);
1429:
1430: FOR rec IN get_bal_cat_csr LOOP
1431: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Category', rec.category_name);
1432: insert_ownership('BALANCE_CATEGORY_ID','PAY',rec.balance_category_id);

Line 1437: hr_utility.set_location('pay_ip_utility.ins_bal_cat_ownership',20);

1433: insert_ownership('BALANCE_CATEGORY_ID','PER',rec.balance_category_id);
1434:
1435: END LOOP;
1436:
1437: hr_utility.set_location('pay_ip_utility.ins_bal_cat_ownership',20);
1438:
1439: END ins_bal_cat_ownership;
1440:
1441:

Line 1450: hr_utility.set_location('pay_ip_utility.insert_all_ownerships',10);

1446: -- ---------------------------------------------------------------------
1447: PROCEDURE insert_all_ownerships IS
1448:
1449: BEGIN
1450: hr_utility.set_location('pay_ip_utility.insert_all_ownerships',10);
1451:
1452: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1453:
1454: --Insert Element Classification Ownerships

Line 1472: hr_utility.set_location('pay_ip_utility.insert_all_ownerships',20);

1468:
1469: --Insert Balance Category Ownerships
1470: ins_bal_cat_ownership;
1471:
1472: hr_utility.set_location('pay_ip_utility.insert_all_ownerships',20);
1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: RAISE_APPLICATION_ERROR(-20001, SQLERRM);

Line 1534: hr_utility.set_location('Entering... pay_ip_utility.insert_patch',10);

1530: )
1531: IS
1532:
1533: BEGIN
1534: hr_utility.set_location('Entering... pay_ip_utility.insert_patch',10);
1535: INSERT INTO pay_patch_status
1536: (ID,
1537: PATCH_NUMBER,
1538: PATCH_NAME,

Line 1556: hr_utility.set_location('Leaving... pay_ip_utility.insert_patch',20);

1552: decode(p_appl_release,'ANY',null,p_appl_release),
1553: p_leg_code
1554: );
1555:
1556: hr_utility.set_location('Leaving... pay_ip_utility.insert_patch',20);
1557:
1558: END insert_patch_status;
1559:
1560: /**********************************************************************

Line 1582: hr_utility.set_location('Entering... pay_ip_utility.compile_formulas',10);

1578: req_data VARCHAR2(240) := NULL;
1579:
1580: l_wait_outcome BOOLEAN;
1581: BEGIN
1582: hr_utility.set_location('Entering... pay_ip_utility.compile_formulas',10);
1583: hr_utility.trace('p_user_id: ' || p_user_id);
1584: hr_utility.trace('p_resp_id: ' || p_resp_id);
1585: hr_utility.trace('p_resp_appl_id: ' || p_resp_appl_id);
1586:

Line 1604: hr_utility.set_location('pay_ip_utility.compile_formulas',15);

1600: sub_request => FALSE);
1601:
1602: hr_utility.trace('ln_req_id: ' || ln_req_id);
1603: IF(ln_req_id = 0) THEN
1604: hr_utility.set_location('pay_ip_utility.compile_formulas',15);
1605: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1606: pay_ip_startup_util.write_log('LOG','PAY_34084_IP_BULK_COMP_SUB_ERR',null, null);
1607: hr_utility.raise_error;
1608: END IF;

Line 1611: hr_utility.set_location('pay_ip_utility.compile_formulas',20);

1607: hr_utility.raise_error;
1608: END IF;
1609:
1610: COMMIT;
1611: hr_utility.set_location('pay_ip_utility.compile_formulas',20);
1612: hr_utility.trace('Waiting for request ' || ln_req_id || ' to complete');
1613:
1614: l_wait_outcome := fnd_concurrent.wait_for_request(
1615: request_id => ln_req_id,

Line 1630: hr_utility.set_location('Leaving... pay_ip_utility.complie_formulas',30);

1626: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1627: pay_ip_startup_util.write_log('LOG','PAY_34083_IP_BULK_COMP_ERROR',null, null);
1628: END IF;
1629:
1630: hr_utility.set_location('Leaving... pay_ip_utility.complie_formulas',30);
1631:
1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: RAISE_APPLICATION_ERROR(-20001, SQLERRM);

Line 1671: g_package_name := 'pay_ip_utility.';

1667: END check_run_balance_enabled;
1668:
1669: BEGIN
1670:
1671: g_package_name := 'pay_ip_utility.';
1672: g_debug := hr_utility.debug_enabled;
1673:
1674: END pay_ip_utility;

Line 1674: END pay_ip_utility;

1670:
1671: g_package_name := 'pay_ip_utility.';
1672: g_debug := hr_utility.debug_enabled;
1673:
1674: END pay_ip_utility;