DBA Data[Home] [Help]

APPS.PAY_IP_UTILITY dependencies on PAY_IP_STARTUP_UTIL

Line 237: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

233: ,p_flexfield_name => p_dff_name
234: ,p_context_code => lv_new_context_name
235: );
236: IF lv_context_exists THEN
237: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
238: pay_ip_startup_util.write_log('LOG','PAY_34073_IP_UPD_FLEX_CONTEXT',lv_new_context_name, NULL);
239:
240: hr_utility.trace('Updating the context '||lv_new_context_name );
241: fnd_flex_dsc_api.update_context(

Line 238: pay_ip_startup_util.write_log('LOG','PAY_34073_IP_UPD_FLEX_CONTEXT',lv_new_context_name, NULL);

234: ,p_context_code => lv_new_context_name
235: );
236: IF lv_context_exists THEN
237: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
238: pay_ip_startup_util.write_log('LOG','PAY_34073_IP_UPD_FLEX_CONTEXT',lv_new_context_name, NULL);
239:
240: hr_utility.trace('Updating the context '||lv_new_context_name );
241: fnd_flex_dsc_api.update_context(
242: p_appl_short_name => p_appl_short_name

Line 254: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

250: ELSE
251: hr_utility.trace('Creating Context');
252: hr_utility.trace('language '||lv_language );
253: hr_utility.trace('get_context_rec.DESCRIPTION '||lv_description);
254: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
255: pay_ip_startup_util.write_log('LOG','PAY_34072_IP_INS_FLEX_CONTEXT',lv_new_context_name, NULL);
256:
257: fnd_flex_dsc_api.create_context(
258: appl_short_name => p_appl_short_name

Line 255: pay_ip_startup_util.write_log('LOG','PAY_34072_IP_INS_FLEX_CONTEXT',lv_new_context_name, NULL);

251: hr_utility.trace('Creating Context');
252: hr_utility.trace('language '||lv_language );
253: hr_utility.trace('get_context_rec.DESCRIPTION '||lv_description);
254: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
255: pay_ip_startup_util.write_log('LOG','PAY_34072_IP_INS_FLEX_CONTEXT',lv_new_context_name, NULL);
256:
257: fnd_flex_dsc_api.create_context(
258: appl_short_name => p_appl_short_name
259: ,flexfield_name => lv_desc_flexfield_name

Line 289: pay_ip_startup_util.write_log('LOG','PAY_34075_IP_UPD_FLEX_SEGMENT',get_segments_rec.END_USER_COLUMN_NAME, NULL);

285: );
286:
287: IF lv_segment_exists THEN
288: hr_utility.trace('segments exists TRUE');
289: pay_ip_startup_util.write_log('LOG','PAY_34075_IP_UPD_FLEX_SEGMENT',get_segments_rec.END_USER_COLUMN_NAME, NULL);
290:
291:
292: fnd_flex_dsc_api.modify_segment
293: (

Line 320: pay_ip_startup_util.write_log('LOG','PAY_34074_IP_INS_FLEX_SEGMENT',get_segments_rec.END_USER_COLUMN_NAME, NULL);

316:
317:
318: ELSE
319: hr_utility.trace('segments exists FALSE');
320: pay_ip_startup_util.write_log('LOG','PAY_34074_IP_INS_FLEX_SEGMENT',get_segments_rec.END_USER_COLUMN_NAME, NULL);
321: fnd_flex_dsc_api.create_segment(
322: appl_short_name => p_appl_short_name,
323: flexfield_name => p_dff_name,
324: context_name => lv_new_context_name,

Line 345: pay_ip_startup_util.write_log('LOG','PAY_34015_IP_UPD_TABLE','FND_DESCR_FLEX_COL_USAGE_TL for the Context '||lv_new_context_name,NULL);

341: RANGE => NULL);
342:
343: END IF;
344: END LOOP; --c_get_segments
345: pay_ip_startup_util.write_log('LOG','PAY_34015_IP_UPD_TABLE','FND_DESCR_FLEX_COL_USAGE_TL for the Context '||lv_new_context_name,NULL);
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;

Line 816: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);

812: l_func_name VARCHAR2(80);
813: l_application_id fnd_application.application_id%TYPE;
814: BEGIN
815: l_func_name := g_package_name || 'get_application_id(short_name)';
816: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);
817: SELECT application_id
818: INTO l_application_id
819: FROM fnd_application
820: WHERE application_short_name = p_application_short_name;

Line 844: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);

840:
841: BEGIN
842: l_func_name := g_package_name || 'get_dff_flx(F)';
843: hr_utility.trace('get_dff_flx :p_descriptive_flexfield_name '||p_descriptive_flexfield_name);
844: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);
845:
846: SELECT *
847: INTO x_dff_flx
848: FROM fnd_descriptive_flexs

Line 878: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);

874: hr_utility.trace('get_kff_str : ');
875: l_func_name := g_package_name || 'get_kff_str(code,F)';
876: hr_utility.trace('get_kff_str :p_application_id '||p_application_id);
877: hr_utility.trace('get_kff_str :p_id_flex_structure_code '||p_id_flex_structure_code);
878: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',l_func_name,NULL);
879: SELECT *
880: INTO x_kff_str
881: FROM fnd_id_flex_structures
882: WHERE application_id = p_application_id

Line 1174: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

1170: END IF;
1171: END IF;
1172:
1173: IF (l_request_id_vc2 = '0') THEN
1174: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1175: pay_ip_startup_util.write_log('LOG','PAY_34078_IP_FLEX_COMP_ERROR',l_description, l_request_id_vc2);
1176: ELSE
1177: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1178: pay_ip_startup_util.write_log('LOG','PAY_34079_IP_FLEX_COMP_SUBMIT',l_description, l_request_id_vc2);

Line 1175: pay_ip_startup_util.write_log('LOG','PAY_34078_IP_FLEX_COMP_ERROR',l_description, l_request_id_vc2);

1171: END IF;
1172:
1173: IF (l_request_id_vc2 = '0') THEN
1174: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1175: pay_ip_startup_util.write_log('LOG','PAY_34078_IP_FLEX_COMP_ERROR',l_description, l_request_id_vc2);
1176: ELSE
1177: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1178: pay_ip_startup_util.write_log('LOG','PAY_34079_IP_FLEX_COMP_SUBMIT',l_description, l_request_id_vc2);
1179: END IF;

Line 1177: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

1173: IF (l_request_id_vc2 = '0') THEN
1174: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1175: pay_ip_startup_util.write_log('LOG','PAY_34078_IP_FLEX_COMP_ERROR',l_description, l_request_id_vc2);
1176: ELSE
1177: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1178: pay_ip_startup_util.write_log('LOG','PAY_34079_IP_FLEX_COMP_SUBMIT',l_description, l_request_id_vc2);
1179: END IF;
1180:
1181: --

Line 1178: pay_ip_startup_util.write_log('LOG','PAY_34079_IP_FLEX_COMP_SUBMIT',l_description, l_request_id_vc2);

1174: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1175: pay_ip_startup_util.write_log('LOG','PAY_34078_IP_FLEX_COMP_ERROR',l_description, l_request_id_vc2);
1176: ELSE
1177: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1178: pay_ip_startup_util.write_log('LOG','PAY_34079_IP_FLEX_COMP_SUBMIT',l_description, l_request_id_vc2);
1179: END IF;
1180:
1181: --
1182: -- Generate the view.

Line 1288: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Element Classification', rec.classification_name);

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);
1291:
1292: END LOOP;

Line 1313: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Type', rec.balance_name);

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);
1316:
1317: END LOOP;

Line 1338: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Dimension', rec.dimension_name);

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);
1341:
1342: END LOOP;

Line 1369: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Defined Balance', rec.def_bal_name);

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);
1372:
1373: END LOOP;

Line 1405: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Route', rec.route_name);

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);
1408:
1409: END LOOP;

Line 1431: pay_ip_startup_util.write_log ('LOG','PAY_34013_IP_INS_OWNERSHIP', 'Balance Category', rec.category_name);

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);
1433: insert_ownership('BALANCE_CATEGORY_ID','PER',rec.balance_category_id);
1434:
1435: END LOOP;

Line 1452: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

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
1455: ins_element_class_ownership;
1456:

Line 1500: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',lv_func_name,NULL);

1496: hr_utility.trace('check_patch_exists :p_patch_name ' || p_patch_name);
1497: hr_utility.trace('check_patch_exists :p_patch_status ' || p_patch_status);
1498: hr_utility.trace('check_patch_exists :p_appl_release ' || p_appl_release);
1499: hr_utility.trace('check_patch_exists :p_leg_code ' || p_leg_code);
1500: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',lv_func_name,NULL);
1501:
1502: SELECT status
1503: INTO lv_patch_status
1504: FROM pay_patch_status

Line 1593: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

1589: resp_id => p_resp_id,
1590: resp_appl_id => p_resp_appl_id);
1591:
1592:
1593: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1594: pay_ip_startup_util.write_log('LOG','PAY_34082_IP_BULK_COMP_SUBMIT',null, null);
1595: ln_req_id := fnd_request.submit_request(application => 'FF',
1596: program => 'BULKCOMPILE',
1597: argument1 => '-W',

Line 1594: pay_ip_startup_util.write_log('LOG','PAY_34082_IP_BULK_COMP_SUBMIT',null, null);

1590: resp_appl_id => p_resp_appl_id);
1591:
1592:
1593: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);
1594: pay_ip_startup_util.write_log('LOG','PAY_34082_IP_BULK_COMP_SUBMIT',null, null);
1595: ln_req_id := fnd_request.submit_request(application => 'FF',
1596: program => 'BULKCOMPILE',
1597: argument1 => '-W',
1598: argument2 => '%',

Line 1605: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

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;
1609:

Line 1606: pay_ip_startup_util.write_log('LOG','PAY_34084_IP_BULK_COMP_SUB_ERR',null, null);

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;
1609:
1610: COMMIT;

Line 1626: pay_ip_startup_util.write_log('LOG',NULL,NULL,NULL);

1622: hr_utility.trace('lv_dev_status: ' ||lv_dev_status);
1623: hr_utility.trace('message: ' ||lv_message);
1624:
1625: IF(lv_dev_phase = 'COMPLETE' AND lv_dev_status <> 'NORMAL') THEN
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);

Line 1627: pay_ip_startup_util.write_log('LOG','PAY_34083_IP_BULK_COMP_ERROR',null, null);

1623: hr_utility.trace('message: ' ||lv_message);
1624:
1625: IF(lv_dev_phase = 'COMPLETE' AND lv_dev_status <> 'NORMAL') THEN
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:

Line 1651: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',lv_func_name,NULL);

1647: lv_rbr_enabled VARCHAR2(5);
1648: BEGIN
1649: lv_func_name := g_package_name || 'check_run_balance_enabled(F)';
1650:
1651: pay_ip_startup_util.write_log('LOG','PAY_34016_IP_CALL_PROC',lv_func_name,NULL);
1652:
1653: SELECT 'Y'
1654: INTO lv_rbr_enabled
1655: FROM pay_legislation_rules