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.PO_UDA_TEMPLATES_UTIL dependencies on PO_LOG

Line 4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_UDA_TEMPLATES_UTIL');

1: PACKAGE BODY PO_UDA_TEMPLATES_UTIL AS
2: /* $Header: PO_UDA_TEMPLATES_UTIL.plb 120.22.12020000.5 2013/04/22 23:24:42 rarajar ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('PO_UDA_TEMPLATES_UTIL');
5: d_appln_short_name CONSTANT VARCHAR2(20) := 'PO';
6:
7: -------------------------------------------------------------------------------
8: --- Start of Comments

Line 522: IF (PO_LOG.d_proc) THEN

518: d_progress := 10;
519:
520:
521:
522: IF (PO_LOG.d_proc) THEN
523: PO_LOG.proc_begin(d_module);
524: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
525: END IF;
526:

Line 523: PO_LOG.proc_begin(d_module);

519:
520:
521:
522: IF (PO_LOG.d_proc) THEN
523: PO_LOG.proc_begin(d_module);
524: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
525: END IF;
526:
527:

Line 524: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

520:
521:
522: IF (PO_LOG.d_proc) THEN
523: PO_LOG.proc_begin(d_module);
524: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
525: END IF;
526:
527:
528:

Line 691: IF (PO_LOG.d_proc) THEN

687:
688:
689:
690: BEGIN
691: IF (PO_LOG.d_proc) THEN
692: PO_LOG.proc_begin(d_module);
693: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
694: END IF;
695:

Line 692: PO_LOG.proc_begin(d_module);

688:
689:
690: BEGIN
691: IF (PO_LOG.d_proc) THEN
692: PO_LOG.proc_begin(d_module);
693: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
694: END IF;
695:
696: d_progress := 180;

Line 693: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

689:
690: BEGIN
691: IF (PO_LOG.d_proc) THEN
692: PO_LOG.proc_begin(d_module);
693: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
694: END IF;
695:
696: d_progress := 180;
697:

Line 1167: IF (PO_LOG.d_proc) THEN

1163: AND pt.template_id = p_template_id;
1164:
1165: BEGIN
1166:
1167: IF (PO_LOG.d_proc) THEN
1168: PO_LOG.proc_begin(d_module);
1169: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
1170: END IF;
1171:

Line 1168: PO_LOG.proc_begin(d_module);

1164:
1165: BEGIN
1166:
1167: IF (PO_LOG.d_proc) THEN
1168: PO_LOG.proc_begin(d_module);
1169: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
1170: END IF;
1171:
1172: OPEN c_prod_table(p_template_id);

Line 1169: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

1165: BEGIN
1166:
1167: IF (PO_LOG.d_proc) THEN
1168: PO_LOG.proc_begin(d_module);
1169: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
1170: END IF;
1171:
1172: OPEN c_prod_table(p_template_id);
1173: FETCH c_prod_table INTO l_prod_table;

Line 1180: IF PO_LOG.d_stmt THEN

1176: l_template_column := 'UDA_TEMPLATE_ID';
1177:
1178: d_progress := 10;
1179:
1180: IF PO_LOG.d_stmt THEN
1181: PO_LOG.stmt(d_module, d_progress, 'l_prod_table', l_prod_table);
1182: PO_LOG.stmt(d_module, d_progress, 'l_template_column', l_template_column);
1183: END IF;
1184:

Line 1181: PO_LOG.stmt(d_module, d_progress, 'l_prod_table', l_prod_table);

1177:
1178: d_progress := 10;
1179:
1180: IF PO_LOG.d_stmt THEN
1181: PO_LOG.stmt(d_module, d_progress, 'l_prod_table', l_prod_table);
1182: PO_LOG.stmt(d_module, d_progress, 'l_template_column', l_template_column);
1183: END IF;
1184:
1185: l_stmt := 'SELECT ''Y'' from '|| l_prod_table ||

Line 1182: PO_LOG.stmt(d_module, d_progress, 'l_template_column', l_template_column);

1178: d_progress := 10;
1179:
1180: IF PO_LOG.d_stmt THEN
1181: PO_LOG.stmt(d_module, d_progress, 'l_prod_table', l_prod_table);
1182: PO_LOG.stmt(d_module, d_progress, 'l_template_column', l_template_column);
1183: END IF;
1184:
1185: l_stmt := 'SELECT ''Y'' from '|| l_prod_table ||
1186: ' WHERE '|| l_template_column||' = '|| p_template_id || ' AND ROWNUM < 2';

Line 1194: IF PO_LOG.d_stmt THEN

1190: CLOSE c_document_exists;
1191:
1192: d_progress := 20;
1193:
1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_module, d_progress, 'l_stmt', l_stmt);
1196: PO_LOG.stmt(d_module, d_progress, 'l_temp_exists', l_temp_exists);
1197: END IF;
1198:

Line 1195: PO_LOG.stmt(d_module, d_progress, 'l_stmt', l_stmt);

1191:
1192: d_progress := 20;
1193:
1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_module, d_progress, 'l_stmt', l_stmt);
1196: PO_LOG.stmt(d_module, d_progress, 'l_temp_exists', l_temp_exists);
1197: END IF;
1198:
1199: IF l_temp_exists ='Y' THEN

Line 1196: PO_LOG.stmt(d_module, d_progress, 'l_temp_exists', l_temp_exists);

1192: d_progress := 20;
1193:
1194: IF PO_LOG.d_stmt THEN
1195: PO_LOG.stmt(d_module, d_progress, 'l_stmt', l_stmt);
1196: PO_LOG.stmt(d_module, d_progress, 'l_temp_exists', l_temp_exists);
1197: END IF;
1198:
1199: IF l_temp_exists ='Y' THEN
1200: RETURN 'false';

Line 1208: IF PO_LOG.d_stmt THEN

1204:
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: d_progress := 30;
1208: IF PO_LOG.d_stmt THEN
1209: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
1210: END IF;
1211: END can_update_delete;
1212:

Line 1209: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: d_progress := 30;
1208: IF PO_LOG.d_stmt THEN
1209: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
1210: END IF;
1211: END can_update_delete;
1212:
1213:

Line 1247: IF (PO_LOG.d_proc) THEN

1243: BEGIN
1244:
1245: d_progress := 10;
1246:
1247: IF (PO_LOG.d_proc) THEN
1248: PO_LOG.proc_begin(d_module);
1249: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1250: PO_LOG.proc_begin(d_module, 'p_attribute_group_name', p_attribute_group_name);
1251: END IF;

Line 1248: PO_LOG.proc_begin(d_module);

1244:
1245: d_progress := 10;
1246:
1247: IF (PO_LOG.d_proc) THEN
1248: PO_LOG.proc_begin(d_module);
1249: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1250: PO_LOG.proc_begin(d_module, 'p_attribute_group_name', p_attribute_group_name);
1251: END IF;
1252:

Line 1249: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);

1245: d_progress := 10;
1246:
1247: IF (PO_LOG.d_proc) THEN
1248: PO_LOG.proc_begin(d_module);
1249: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1250: PO_LOG.proc_begin(d_module, 'p_attribute_group_name', p_attribute_group_name);
1251: END IF;
1252:
1253: SELECT ATTR_GROUP_ID

Line 1250: PO_LOG.proc_begin(d_module, 'p_attribute_group_name', p_attribute_group_name);

1246:
1247: IF (PO_LOG.d_proc) THEN
1248: PO_LOG.proc_begin(d_module);
1249: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1250: PO_LOG.proc_begin(d_module, 'p_attribute_group_name', p_attribute_group_name);
1251: END IF;
1252:
1253: SELECT ATTR_GROUP_ID
1254: INTO l_attr_grp_id

Line 1262: IF PO_LOG.d_stmt THEN

1258: AND ROWNUM < 2;
1259:
1260: d_progress := 20;
1261:
1262: IF PO_LOG.d_stmt THEN
1263: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_id', l_attr_grp_id);
1264: END IF;
1265:
1266: -- Fetched the attribute group ID and calling the overloaded sync api

Line 1263: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_id', l_attr_grp_id);

1259:
1260: d_progress := 20;
1261:
1262: IF PO_LOG.d_stmt THEN
1263: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_id', l_attr_grp_id);
1264: END IF;
1265:
1266: -- Fetched the attribute group ID and calling the overloaded sync api
1267: PO_UDA_TEMPLATES_UTIL.sync_attribute_group(

Line 1279: IF PO_LOG.d_stmt THEN

1275: );
1276:
1277: d_progress := 30;
1278:
1279: IF PO_LOG.d_stmt THEN
1280: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1281: END IF;
1282:
1283: IF (PO_LOG.d_exc) THEN

Line 1280: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

1276:
1277: d_progress := 30;
1278:
1279: IF PO_LOG.d_stmt THEN
1280: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1281: END IF;
1282:
1283: IF (PO_LOG.d_exc) THEN
1284: PO_LOG.exc(d_module, d_progress, x_return_status );

Line 1283: IF (PO_LOG.d_exc) THEN

1279: IF PO_LOG.d_stmt THEN
1280: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1281: END IF;
1282:
1283: IF (PO_LOG.d_exc) THEN
1284: PO_LOG.exc(d_module, d_progress, x_return_status );
1285: PO_LOG.proc_end(d_module);
1286: END IF;
1287:

Line 1284: PO_LOG.exc(d_module, d_progress, x_return_status );

1280: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1281: END IF;
1282:
1283: IF (PO_LOG.d_exc) THEN
1284: PO_LOG.exc(d_module, d_progress, x_return_status );
1285: PO_LOG.proc_end(d_module);
1286: END IF;
1287:
1288: EXCEPTION

Line 1285: PO_LOG.proc_end(d_module);

1281: END IF;
1282:
1283: IF (PO_LOG.d_exc) THEN
1284: PO_LOG.exc(d_module, d_progress, x_return_status );
1285: PO_LOG.proc_end(d_module);
1286: END IF;
1287:
1288: EXCEPTION
1289: when no_data_found then

Line 1309: IF (PO_LOG.d_exc) THEN

1305:
1306: WHEN OTHERS THEN
1307: d_progress := 40;
1308:
1309: IF (PO_LOG.d_exc) THEN
1310: PO_LOG.exc(d_module, d_progress, x_return_status );
1311: PO_LOG.proc_end(d_module);
1312: END IF;
1313: END sync_attribute_group;

Line 1310: PO_LOG.exc(d_module, d_progress, x_return_status );

1306: WHEN OTHERS THEN
1307: d_progress := 40;
1308:
1309: IF (PO_LOG.d_exc) THEN
1310: PO_LOG.exc(d_module, d_progress, x_return_status );
1311: PO_LOG.proc_end(d_module);
1312: END IF;
1313: END sync_attribute_group;
1314:

Line 1311: PO_LOG.proc_end(d_module);

1307: d_progress := 40;
1308:
1309: IF (PO_LOG.d_exc) THEN
1310: PO_LOG.exc(d_module, d_progress, x_return_status );
1311: PO_LOG.proc_end(d_module);
1312: END IF;
1313: END sync_attribute_group;
1314:
1315: PROCEDURE sync_attribute_group

Line 1341: IF (PO_LOG.d_proc) THEN

1337: BEGIN
1338:
1339: d_progress := 10;
1340:
1341: IF (PO_LOG.d_proc) THEN
1342: PO_LOG.proc_begin(d_module);
1343: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
1344: END IF;
1345:

Line 1342: PO_LOG.proc_begin(d_module);

1338:
1339: d_progress := 10;
1340:
1341: IF (PO_LOG.d_proc) THEN
1342: PO_LOG.proc_begin(d_module);
1343: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
1344: END IF;
1345:
1346: -- Query to check if it is a total dummy delete case

Line 1343: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);

1339: d_progress := 10;
1340:
1341: IF (PO_LOG.d_proc) THEN
1342: PO_LOG.proc_begin(d_module);
1343: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
1344: END IF;
1345:
1346: -- Query to check if it is a total dummy delete case
1347: SELECT 1

Line 1353: IF PO_LOG.d_stmt THEN

1349: FROM ego_fnd_dsc_flx_ctx_ext
1350: WHERE ATTR_GROUP_ID = p_attribute_group_id
1351: AND ROWNUM < 2;
1352:
1353: IF PO_LOG.d_stmt THEN
1354: PO_LOG.stmt(d_module, d_progress, 'l_total_delete', l_total_delete);
1355: END IF;
1356:
1357: d_progress := 20;

Line 1354: PO_LOG.stmt(d_module, d_progress, 'l_total_delete', l_total_delete);

1350: WHERE ATTR_GROUP_ID = p_attribute_group_id
1351: AND ROWNUM < 2;
1352:
1353: IF PO_LOG.d_stmt THEN
1354: PO_LOG.stmt(d_module, d_progress, 'l_total_delete', l_total_delete);
1355: END IF;
1356:
1357: d_progress := 20;
1358:

Line 1377: IF PO_LOG.d_stmt THEN

1373: l_true_false := sync_real_attribute_groups(p_glb_api_version, p_glb_application_id, p_attribute_group_id, 'PON_BID_PRICES_EXT_ATTRS');
1374:
1375: d_progress := 40;
1376:
1377: IF PO_LOG.d_stmt THEN
1378: PO_LOG.stmt(d_module, d_progress, 'l_true_false', l_true_false);
1379: END IF;
1380:
1381: END IF;

Line 1378: PO_LOG.stmt(d_module, d_progress, 'l_true_false', l_true_false);

1374:
1375: d_progress := 40;
1376:
1377: IF PO_LOG.d_stmt THEN
1378: PO_LOG.stmt(d_module, d_progress, 'l_true_false', l_true_false);
1379: END IF;
1380:
1381: END IF;
1382:

Line 1385: IF (PO_LOG.d_exc) THEN

1381: END IF;
1382:
1383: d_progress := 50;
1384:
1385: IF (PO_LOG.d_exc) THEN
1386: PO_LOG.exc(d_module, d_progress, l_true_false );
1387: PO_LOG.proc_end(d_module);
1388: END IF;
1389:

Line 1386: PO_LOG.exc(d_module, d_progress, l_true_false );

1382:
1383: d_progress := 50;
1384:
1385: IF (PO_LOG.d_exc) THEN
1386: PO_LOG.exc(d_module, d_progress, l_true_false );
1387: PO_LOG.proc_end(d_module);
1388: END IF;
1389:
1390: EXCEPTION

Line 1387: PO_LOG.proc_end(d_module);

1383: d_progress := 50;
1384:
1385: IF (PO_LOG.d_exc) THEN
1386: PO_LOG.exc(d_module, d_progress, l_true_false );
1387: PO_LOG.proc_end(d_module);
1388: END IF;
1389:
1390: EXCEPTION
1391: WHEN OTHERS THEN -- Total delete case for dummy

Line 1445: IF (PO_LOG.d_exc) THEN

1441: WHERE dummy_attribute_group_id = p_attribute_group_id;
1442:
1443: d_progress := 100;
1444:
1445: IF (PO_LOG.d_exc) THEN
1446: PO_LOG.exc(d_module, d_progress, p_attribute_group_id );
1447: PO_LOG.proc_end(d_module);
1448: END IF;
1449:

Line 1446: PO_LOG.exc(d_module, d_progress, p_attribute_group_id );

1442:
1443: d_progress := 100;
1444:
1445: IF (PO_LOG.d_exc) THEN
1446: PO_LOG.exc(d_module, d_progress, p_attribute_group_id );
1447: PO_LOG.proc_end(d_module);
1448: END IF;
1449:
1450: END sync_attribute_group;

Line 1447: PO_LOG.proc_end(d_module);

1443: d_progress := 100;
1444:
1445: IF (PO_LOG.d_exc) THEN
1446: PO_LOG.exc(d_module, d_progress, p_attribute_group_id );
1447: PO_LOG.proc_end(d_module);
1448: END IF;
1449:
1450: END sync_attribute_group;
1451:

Line 1478: IF (PO_LOG.d_proc) THEN

1474: BEGIN
1475:
1476: d_progress := 10;
1477:
1478: IF (PO_LOG.d_proc) THEN
1479: PO_LOG.proc_begin(d_module);
1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);
1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);
1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);

Line 1479: PO_LOG.proc_begin(d_module);

1475:
1476: d_progress := 10;
1477:
1478: IF (PO_LOG.d_proc) THEN
1479: PO_LOG.proc_begin(d_module);
1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);
1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);
1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);
1483: PO_LOG.proc_begin(d_module, 'p_data_level_name', p_data_level_name);

Line 1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);

1476: d_progress := 10;
1477:
1478: IF (PO_LOG.d_proc) THEN
1479: PO_LOG.proc_begin(d_module);
1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);
1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);
1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);
1483: PO_LOG.proc_begin(d_module, 'p_data_level_name', p_data_level_name);
1484: PO_LOG.proc_begin(d_module, 'p_user_data_level_name', p_user_data_level_name);

Line 1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);

1477:
1478: IF (PO_LOG.d_proc) THEN
1479: PO_LOG.proc_begin(d_module);
1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);
1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);
1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);
1483: PO_LOG.proc_begin(d_module, 'p_data_level_name', p_data_level_name);
1484: PO_LOG.proc_begin(d_module, 'p_user_data_level_name', p_user_data_level_name);
1485: END IF;

Line 1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);

1478: IF (PO_LOG.d_proc) THEN
1479: PO_LOG.proc_begin(d_module);
1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);
1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);
1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);
1483: PO_LOG.proc_begin(d_module, 'p_data_level_name', p_data_level_name);
1484: PO_LOG.proc_begin(d_module, 'p_user_data_level_name', p_user_data_level_name);
1485: END IF;
1486:

Line 1483: PO_LOG.proc_begin(d_module, 'p_data_level_name', p_data_level_name);

1479: PO_LOG.proc_begin(d_module);
1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);
1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);
1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);
1483: PO_LOG.proc_begin(d_module, 'p_data_level_name', p_data_level_name);
1484: PO_LOG.proc_begin(d_module, 'p_user_data_level_name', p_user_data_level_name);
1485: END IF;
1486:
1487: SELECT DATA_LEVEL_ID

Line 1484: PO_LOG.proc_begin(d_module, 'p_user_data_level_name', p_user_data_level_name);

1480: PO_LOG.proc_begin(d_module, 'p_dummy_attr_group_id', p_dummy_attr_group_id);
1481: PO_LOG.proc_begin(d_module, 'p_real_attr_group_id', p_real_attr_group_id);
1482: PO_LOG.proc_begin(d_module, 'p_attr_group_type', p_attr_group_type);
1483: PO_LOG.proc_begin(d_module, 'p_data_level_name', p_data_level_name);
1484: PO_LOG.proc_begin(d_module, 'p_user_data_level_name', p_user_data_level_name);
1485: END IF;
1486:
1487: SELECT DATA_LEVEL_ID
1488: INTO l_data_level_id

Line 1495: IF PO_LOG.d_stmt THEN

1491: AND DATA_LEVEL_NAME = p_data_level_name;
1492:
1493: d_progress := 20;
1494:
1495: IF PO_LOG.d_stmt THEN
1496: PO_LOG.stmt(d_module, d_progress, 'l_data_level_id', l_data_level_id);
1497: END IF;
1498:
1499: -- Assigning base data level to the real attribute group

Line 1496: PO_LOG.stmt(d_module, d_progress, 'l_data_level_id', l_data_level_id);

1492:
1493: d_progress := 20;
1494:
1495: IF PO_LOG.d_stmt THEN
1496: PO_LOG.stmt(d_module, d_progress, 'l_data_level_id', l_data_level_id);
1497: END IF;
1498:
1499: -- Assigning base data level to the real attribute group
1500: sync_data_level_attr_group(

Line 1511: IF PO_LOG.d_stmt THEN

1507: );
1508:
1509: d_progress := 30;
1510:
1511: IF PO_LOG.d_stmt THEN
1512: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1513: END IF;
1514:
1515:

Line 1512: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

1508:
1509: d_progress := 30;
1510:
1511: IF PO_LOG.d_stmt THEN
1512: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1513: END IF;
1514:
1515:
1516: SELECT DATA_LEVEL_ID

Line 1524: IF PO_LOG.d_stmt THEN

1520: AND DATA_LEVEL_NAME = p_data_level_name || '_ARCHIVE';
1521:
1522: d_progress := 40;
1523:
1524: IF PO_LOG.d_stmt THEN
1525: PO_LOG.stmt(d_module, d_progress, 'l_data_level_id', l_data_level_id);
1526: END IF;
1527:
1528: -- Assigning archive data level to the real attribute group

Line 1525: PO_LOG.stmt(d_module, d_progress, 'l_data_level_id', l_data_level_id);

1521:
1522: d_progress := 40;
1523:
1524: IF PO_LOG.d_stmt THEN
1525: PO_LOG.stmt(d_module, d_progress, 'l_data_level_id', l_data_level_id);
1526: END IF;
1527:
1528: -- Assigning archive data level to the real attribute group
1529: sync_data_level_attr_group(

Line 1540: IF PO_LOG.d_stmt THEN

1536: );
1537:
1538: d_progress := 50;
1539:
1540: IF PO_LOG.d_stmt THEN
1541: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1542: END IF;
1543:
1544: -- Following if statement populates PO_UDA_MAPPINGS to refresh the latest dummy data

Line 1541: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

1537:
1538: d_progress := 50;
1539:
1540: IF PO_LOG.d_stmt THEN
1541: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1542: END IF;
1543:
1544: -- Following if statement populates PO_UDA_MAPPINGS to refresh the latest dummy data
1545:

Line 1792: IF PO_LOG.d_stmt THEN

1788: );
1789: END IF;
1790: d_progress := 60;
1791:
1792: IF PO_LOG.d_stmt THEN
1793: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
1794: END IF;
1795: ELSE
1796: IF p_attr_group_type = 'PO_HEADER_EXT_ATTRS' THEN

Line 1793: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);

1789: END IF;
1790: d_progress := 60;
1791:
1792: IF PO_LOG.d_stmt THEN
1793: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
1794: END IF;
1795: ELSE
1796: IF p_attr_group_type = 'PO_HEADER_EXT_ATTRS' THEN
1797: UPDATE PO_UDA_MAPPINGS

Line 1843: IF PO_LOG.d_stmt THEN

1839: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1840: END IF;
1841: d_progress := 70;
1842:
1843: IF PO_LOG.d_stmt THEN
1844: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
1845: END IF;
1846: END IF;
1847: IF (PO_LOG.d_exc) THEN

Line 1844: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);

1840: END IF;
1841: d_progress := 70;
1842:
1843: IF PO_LOG.d_stmt THEN
1844: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
1845: END IF;
1846: END IF;
1847: IF (PO_LOG.d_exc) THEN
1848: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );

Line 1847: IF (PO_LOG.d_exc) THEN

1843: IF PO_LOG.d_stmt THEN
1844: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
1845: END IF;
1846: END IF;
1847: IF (PO_LOG.d_exc) THEN
1848: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );
1849: PO_LOG.proc_end(d_module);
1850: END IF;
1851: EXCEPTION

Line 1848: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );

1844: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
1845: END IF;
1846: END IF;
1847: IF (PO_LOG.d_exc) THEN
1848: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );
1849: PO_LOG.proc_end(d_module);
1850: END IF;
1851: EXCEPTION
1852: WHEN OTHERS THEN

Line 1849: PO_LOG.proc_end(d_module);

1845: END IF;
1846: END IF;
1847: IF (PO_LOG.d_exc) THEN
1848: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );
1849: PO_LOG.proc_end(d_module);
1850: END IF;
1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: d_progress := 80;

Line 1854: IF (PO_LOG.d_exc) THEN

1850: END IF;
1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: d_progress := 80;
1854: IF (PO_LOG.d_exc) THEN
1855: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );
1856: PO_LOG.proc_end(d_module);
1857: END IF;
1858: END sync_real_data_levels;

Line 1855: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );

1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: d_progress := 80;
1854: IF (PO_LOG.d_exc) THEN
1855: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );
1856: PO_LOG.proc_end(d_module);
1857: END IF;
1858: END sync_real_data_levels;
1859:

Line 1856: PO_LOG.proc_end(d_module);

1852: WHEN OTHERS THEN
1853: d_progress := 80;
1854: IF (PO_LOG.d_exc) THEN
1855: PO_LOG.exc(d_module, d_progress, p_real_attr_group_id );
1856: PO_LOG.proc_end(d_module);
1857: END IF;
1858: END sync_real_data_levels;
1859:
1860: PROCEDURE sync_data_level_attr_group

Line 1875: IF (PO_LOG.d_proc) THEN

1871: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
1872: d_progress NUMBER;
1873: BEGIN
1874:
1875: IF (PO_LOG.d_proc) THEN
1876: PO_LOG.proc_begin(d_module);
1877: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
1878: PO_LOG.proc_begin(d_module, 'p_data_level_id', p_data_level_id);
1879: END IF;

Line 1876: PO_LOG.proc_begin(d_module);

1872: d_progress NUMBER;
1873: BEGIN
1874:
1875: IF (PO_LOG.d_proc) THEN
1876: PO_LOG.proc_begin(d_module);
1877: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
1878: PO_LOG.proc_begin(d_module, 'p_data_level_id', p_data_level_id);
1879: END IF;
1880:

Line 1877: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);

1873: BEGIN
1874:
1875: IF (PO_LOG.d_proc) THEN
1876: PO_LOG.proc_begin(d_module);
1877: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
1878: PO_LOG.proc_begin(d_module, 'p_data_level_id', p_data_level_id);
1879: END IF;
1880:
1881:

Line 1878: PO_LOG.proc_begin(d_module, 'p_data_level_id', p_data_level_id);

1874:
1875: IF (PO_LOG.d_proc) THEN
1876: PO_LOG.proc_begin(d_module);
1877: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
1878: PO_LOG.proc_begin(d_module, 'p_data_level_id', p_data_level_id);
1879: END IF;
1880:
1881:
1882: d_progress := 10;

Line 1905: IF (PO_LOG.d_exc) THEN

1901: ,FND_GLOBAL.Login_Id
1902: );
1903: d_progress := 20;
1904:
1905: IF (PO_LOG.d_exc) THEN
1906: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1907: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1908: PO_LOG.proc_end(d_module);
1909: END IF;

Line 1906: PO_LOG.exc(d_module, d_progress, p_attr_group_id );

1902: );
1903: d_progress := 20;
1904:
1905: IF (PO_LOG.d_exc) THEN
1906: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1907: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1908: PO_LOG.proc_end(d_module);
1909: END IF;
1910:

Line 1907: PO_LOG.exc(d_module, d_progress, p_data_level_id );

1903: d_progress := 20;
1904:
1905: IF (PO_LOG.d_exc) THEN
1906: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1907: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1908: PO_LOG.proc_end(d_module);
1909: END IF;
1910:
1911: EXCEPTION

Line 1908: PO_LOG.proc_end(d_module);

1904:
1905: IF (PO_LOG.d_exc) THEN
1906: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1907: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1908: PO_LOG.proc_end(d_module);
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN

Line 1913: IF (PO_LOG.d_exc) THEN

1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: IF (PO_LOG.d_exc) THEN
1914: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1915: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1916: PO_LOG.proc_end(d_module);
1917: END IF;

Line 1914: PO_LOG.exc(d_module, d_progress, p_attr_group_id );

1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: IF (PO_LOG.d_exc) THEN
1914: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1915: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1916: PO_LOG.proc_end(d_module);
1917: END IF;
1918: END sync_data_level_attr_group;

Line 1915: PO_LOG.exc(d_module, d_progress, p_data_level_id );

1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: IF (PO_LOG.d_exc) THEN
1914: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1915: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1916: PO_LOG.proc_end(d_module);
1917: END IF;
1918: END sync_data_level_attr_group;
1919:

Line 1916: PO_LOG.proc_end(d_module);

1912: WHEN OTHERS THEN
1913: IF (PO_LOG.d_exc) THEN
1914: PO_LOG.exc(d_module, d_progress, p_attr_group_id );
1915: PO_LOG.exc(d_module, d_progress, p_data_level_id );
1916: PO_LOG.proc_end(d_module);
1917: END IF;
1918: END sync_data_level_attr_group;
1919:
1920: FUNCTION sync_real_attribute_groups

Line 1961: IF (PO_LOG.d_proc) THEN

1957: d_progress NUMBER;
1958:
1959: BEGIN
1960:
1961: IF (PO_LOG.d_proc) THEN
1962: PO_LOG.proc_begin(d_module);
1963: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
1964: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1965: END IF;

Line 1962: PO_LOG.proc_begin(d_module);

1958:
1959: BEGIN
1960:
1961: IF (PO_LOG.d_proc) THEN
1962: PO_LOG.proc_begin(d_module);
1963: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
1964: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1965: END IF;
1966:

Line 1963: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);

1959: BEGIN
1960:
1961: IF (PO_LOG.d_proc) THEN
1962: PO_LOG.proc_begin(d_module);
1963: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
1964: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1965: END IF;
1966:
1967: d_progress := 10;

Line 1964: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);

1960:
1961: IF (PO_LOG.d_proc) THEN
1962: PO_LOG.proc_begin(d_module);
1963: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
1964: PO_LOG.proc_begin(d_module, 'p_attribute_group_type', p_attribute_group_type);
1965: END IF;
1966:
1967: d_progress := 10;
1968:

Line 1973: IF PO_LOG.d_stmt THEN

1969: -- Condition to check if the data level is present
1970: IF is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name) = 'true' THEN
1971:
1972: d_progress := 20;
1973: IF PO_LOG.d_stmt THEN
1974: PO_LOG.stmt(d_module, d_progress, 'is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name)', is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name));
1975: END IF;
1976: -- Condition to check the mapping table for the specific attribute group exits
1977: IF get_map_table_details(p_attribute_group_id, p_attribute_group_type) IS NULL THEN

Line 1974: PO_LOG.stmt(d_module, d_progress, 'is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name)', is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name));

1970: IF is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name) = 'true' THEN
1971:
1972: d_progress := 20;
1973: IF PO_LOG.d_stmt THEN
1974: PO_LOG.stmt(d_module, d_progress, 'is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name)', is_data_level_present(p_attribute_group_id, p_attribute_group_type, l_internal_name));
1975: END IF;
1976: -- Condition to check the mapping table for the specific attribute group exits
1977: IF get_map_table_details(p_attribute_group_id, p_attribute_group_type) IS NULL THEN
1978:

Line 1981: IF PO_LOG.d_stmt THEN

1977: IF get_map_table_details(p_attribute_group_id, p_attribute_group_type) IS NULL THEN
1978:
1979: d_progress := 30;
1980:
1981: IF PO_LOG.d_stmt THEN
1982: PO_LOG.stmt(d_module, d_progress, 'get_map_table_details(p_attribute_group_id, p_attribute_group_type)', get_map_table_details(p_attribute_group_id, p_attribute_group_type));
1983: END IF;
1984:
1985: -- Fetching the data from dummy to create the real attribute group

Line 1982: PO_LOG.stmt(d_module, d_progress, 'get_map_table_details(p_attribute_group_id, p_attribute_group_type)', get_map_table_details(p_attribute_group_id, p_attribute_group_type));

1978:
1979: d_progress := 30;
1980:
1981: IF PO_LOG.d_stmt THEN
1982: PO_LOG.stmt(d_module, d_progress, 'get_map_table_details(p_attribute_group_id, p_attribute_group_type)', get_map_table_details(p_attribute_group_id, p_attribute_group_type));
1983: END IF;
1984:
1985: -- Fetching the data from dummy to create the real attribute group
1986: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME,

Line 2024: IF PO_LOG.d_stmt THEN

2020: AND FL_CTX_TL.LANGUAGE = userenv('LANG');
2021:
2022: d_progress := 40;
2023:
2024: IF PO_LOG.d_stmt THEN
2025: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_display_name);
2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);
2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);

Line 2025: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_display_name);

2021:
2022: d_progress := 40;
2023:
2024: IF PO_LOG.d_stmt THEN
2025: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_display_name);
2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);
2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);

Line 2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);

2022: d_progress := 40;
2023:
2024: IF PO_LOG.d_stmt THEN
2025: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_display_name);
2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);
2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);

Line 2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);

2023:
2024: IF PO_LOG.d_stmt THEN
2025: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_display_name);
2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);
2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);

Line 2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);

2024: IF PO_LOG.d_stmt THEN
2025: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_display_name);
2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);
2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);

Line 2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);

2025: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_display_name);
2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);
2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);

Line 2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);

2026: PO_LOG.stmt(d_module, d_progress, 'l_attr_group_desc', l_attr_group_desc);
2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);

Line 2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);

2027: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);

Line 2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);

2028: PO_LOG.stmt(d_module, d_progress, 'l_multi_row_attrib_group', l_multi_row_attrib_group);
2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);

Line 2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);

2029: PO_LOG.stmt(d_module, d_progress, 'l_variant_attrib_group', l_variant_attrib_group);
2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2037: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);

Line 2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);

2030: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2037: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2038: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);

Line 2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);

2031: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2037: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2038: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2039: END IF;

Line 2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);

2032: PO_LOG.stmt(d_module, d_progress, 'l_owning_company_id', l_owning_company_id);
2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2037: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2038: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2039: END IF;
2040:

Line 2037: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);

2033: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2037: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2038: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2039: END IF;
2040:
2041: -- Public api to create the real attribute group

Line 2038: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);

2034: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2035: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2036: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2037: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2038: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2039: END IF;
2040:
2041: -- Public api to create the real attribute group
2042: ego_ext_fwk_pub.create_attribute_group(

Line 2073: IF PO_LOG.d_stmt THEN

2069: );
2070:
2071: d_progress := 50;
2072:
2073: IF PO_LOG.d_stmt THEN
2074: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2075: END IF;
2076:
2077: -- Getting the datalevels depending on the ext table

Line 2074: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

2070:
2071: d_progress := 50;
2072:
2073: IF PO_LOG.d_stmt THEN
2074: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2075: END IF;
2076:
2077: -- Getting the datalevels depending on the ext table
2078: IF p_attribute_group_type = 'PO_HEADER_EXT_ATTRS' THEN

Line 2115: IF PO_LOG.d_stmt THEN

2111: END IF;
2112:
2113: d_progress := 60;
2114:
2115: IF PO_LOG.d_stmt THEN
2116: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level', l_real_data_level);
2117: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level_name', l_real_data_level_name);
2118: END IF;
2119:

Line 2116: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level', l_real_data_level);

2112:
2113: d_progress := 60;
2114:
2115: IF PO_LOG.d_stmt THEN
2116: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level', l_real_data_level);
2117: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level_name', l_real_data_level_name);
2118: END IF;
2119:
2120: -- Syncing or linking the datalevels and the real attribute groups

Line 2117: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level_name', l_real_data_level_name);

2113: d_progress := 60;
2114:
2115: IF PO_LOG.d_stmt THEN
2116: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level', l_real_data_level);
2117: PO_LOG.stmt(d_module, d_progress, 'l_real_data_level_name', l_real_data_level_name);
2118: END IF;
2119:
2120: -- Syncing or linking the datalevels and the real attribute groups
2121: sync_real_data_levels(

Line 2137: IF PO_LOG.d_stmt THEN

2133: );
2134:
2135: d_progress := 70;
2136:
2137: IF PO_LOG.d_stmt THEN
2138: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2139: END IF;
2140:
2141: END IF;

Line 2138: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

2134:
2135: d_progress := 70;
2136:
2137: IF PO_LOG.d_stmt THEN
2138: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2139: END IF;
2140:
2141: END IF;
2142:

Line 2184: IF PO_LOG.d_stmt THEN

2180: END IF;
2181:
2182: d_progress := 90;
2183:
2184: IF PO_LOG.d_stmt THEN
2185: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
2186: END IF;
2187:
2188: ELSIF get_map_table_details(p_attribute_group_id, p_attribute_group_type) IS NOT NULL THEN

Line 2185: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);

2181:
2182: d_progress := 90;
2183:
2184: IF PO_LOG.d_stmt THEN
2185: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
2186: END IF;
2187:
2188: ELSIF get_map_table_details(p_attribute_group_id, p_attribute_group_type) IS NOT NULL THEN
2189:

Line 2200: IF PO_LOG.d_stmt THEN

2196: WHERE ATTR_GROUP_ID = get_map_table_details(p_attribute_group_id, p_attribute_group_type);
2197:
2198: d_progress := 110;
2199:
2200: IF PO_LOG.d_stmt THEN
2201: PO_LOG.stmt(d_module, d_progress, 'get_map_table_details(p_attribute_group_id, p_attribute_group_type)', get_map_table_details(p_attribute_group_id, p_attribute_group_type));
2202: END IF;
2203:
2204: l_true_false := update_map_table(p_attribute_group_id, p_attribute_group_type);

Line 2201: PO_LOG.stmt(d_module, d_progress, 'get_map_table_details(p_attribute_group_id, p_attribute_group_type)', get_map_table_details(p_attribute_group_id, p_attribute_group_type));

2197:
2198: d_progress := 110;
2199:
2200: IF PO_LOG.d_stmt THEN
2201: PO_LOG.stmt(d_module, d_progress, 'get_map_table_details(p_attribute_group_id, p_attribute_group_type)', get_map_table_details(p_attribute_group_id, p_attribute_group_type));
2202: END IF;
2203:
2204: l_true_false := update_map_table(p_attribute_group_id, p_attribute_group_type);
2205:

Line 2225: IF PO_LOG.d_stmt THEN

2221: -- real attribute group is deleted and there are no real attribute groups
2222: -- left with the dummy
2223: d_progress := 120;
2224:
2225: IF PO_LOG.d_stmt THEN
2226: PO_LOG.stmt(d_module, d_progress, 'p_attribute_group_id', p_attribute_group_id);
2227: END IF;
2228:
2229:

Line 2226: PO_LOG.stmt(d_module, d_progress, 'p_attribute_group_id', p_attribute_group_id);

2222: -- left with the dummy
2223: d_progress := 120;
2224:
2225: IF PO_LOG.d_stmt THEN
2226: PO_LOG.stmt(d_module, d_progress, 'p_attribute_group_id', p_attribute_group_id);
2227: END IF;
2228:
2229:
2230: END IF;

Line 2236: IF (PO_LOG.d_exc) THEN

2232: d_progress := 130;
2233:
2234: END IF;
2235:
2236: IF (PO_LOG.d_exc) THEN
2237: PO_LOG.exc(d_module, d_progress, 'true' );
2238: PO_LOG.proc_end(d_module);
2239: END IF;
2240:

Line 2237: PO_LOG.exc(d_module, d_progress, 'true' );

2233:
2234: END IF;
2235:
2236: IF (PO_LOG.d_exc) THEN
2237: PO_LOG.exc(d_module, d_progress, 'true' );
2238: PO_LOG.proc_end(d_module);
2239: END IF;
2240:
2241: RETURN 'true';

Line 2238: PO_LOG.proc_end(d_module);

2234: END IF;
2235:
2236: IF (PO_LOG.d_exc) THEN
2237: PO_LOG.exc(d_module, d_progress, 'true' );
2238: PO_LOG.proc_end(d_module);
2239: END IF;
2240:
2241: RETURN 'true';
2242: EXCEPTION

Line 2244: IF (PO_LOG.d_exc) THEN

2240:
2241: RETURN 'true';
2242: EXCEPTION
2243: WHEN OTHERS THEN
2244: IF (PO_LOG.d_exc) THEN
2245: PO_LOG.exc(d_module, d_progress, 'false' );
2246: PO_LOG.proc_end(d_module);
2247: END IF;
2248: END sync_real_attribute_groups;

Line 2245: PO_LOG.exc(d_module, d_progress, 'false' );

2241: RETURN 'true';
2242: EXCEPTION
2243: WHEN OTHERS THEN
2244: IF (PO_LOG.d_exc) THEN
2245: PO_LOG.exc(d_module, d_progress, 'false' );
2246: PO_LOG.proc_end(d_module);
2247: END IF;
2248: END sync_real_attribute_groups;
2249:

Line 2246: PO_LOG.proc_end(d_module);

2242: EXCEPTION
2243: WHEN OTHERS THEN
2244: IF (PO_LOG.d_exc) THEN
2245: PO_LOG.exc(d_module, d_progress, 'false' );
2246: PO_LOG.proc_end(d_module);
2247: END IF;
2248: END sync_real_attribute_groups;
2249:
2250: PROCEDURE delete_real_attr_group

Line 2268: IF (PO_LOG.d_proc) THEN

2264:
2265: BEGIN
2266: d_progress := 10;
2267:
2268: IF (PO_LOG.d_proc) THEN
2269: PO_LOG.proc_begin(d_module);
2270: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2271: END IF;
2272:

Line 2269: PO_LOG.proc_begin(d_module);

2265: BEGIN
2266: d_progress := 10;
2267:
2268: IF (PO_LOG.d_proc) THEN
2269: PO_LOG.proc_begin(d_module);
2270: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2271: END IF;
2272:
2273: EGO_EXT_FWK_PUB.Delete_Attribute_Group(

Line 2270: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);

2266: d_progress := 10;
2267:
2268: IF (PO_LOG.d_proc) THEN
2269: PO_LOG.proc_begin(d_module);
2270: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2271: END IF;
2272:
2273: EGO_EXT_FWK_PUB.Delete_Attribute_Group(
2274: p_api_version => p_glb_api_version

Line 2285: IF (PO_LOG.d_exc) THEN

2281: ,x_msg_data => l_msg_data
2282: );
2283:
2284: d_progress := 20;
2285: IF (PO_LOG.d_exc) THEN
2286: PO_LOG.exc(d_module, d_progress, l_return_status );
2287: PO_LOG.proc_end(d_module);
2288: END IF;
2289: EXCEPTION

Line 2286: PO_LOG.exc(d_module, d_progress, l_return_status );

2282: );
2283:
2284: d_progress := 20;
2285: IF (PO_LOG.d_exc) THEN
2286: PO_LOG.exc(d_module, d_progress, l_return_status );
2287: PO_LOG.proc_end(d_module);
2288: END IF;
2289: EXCEPTION
2290: WHEN OTHERS THEN

Line 2287: PO_LOG.proc_end(d_module);

2283:
2284: d_progress := 20;
2285: IF (PO_LOG.d_exc) THEN
2286: PO_LOG.exc(d_module, d_progress, l_return_status );
2287: PO_LOG.proc_end(d_module);
2288: END IF;
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: IF (PO_LOG.d_exc) THEN

Line 2291: IF (PO_LOG.d_exc) THEN

2287: PO_LOG.proc_end(d_module);
2288: END IF;
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: IF (PO_LOG.d_exc) THEN
2292: PO_LOG.exc(d_module, d_progress, l_return_status );
2293: PO_LOG.proc_end(d_module);
2294: END IF;
2295: END delete_real_attr_group;

Line 2292: PO_LOG.exc(d_module, d_progress, l_return_status );

2288: END IF;
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: IF (PO_LOG.d_exc) THEN
2292: PO_LOG.exc(d_module, d_progress, l_return_status );
2293: PO_LOG.proc_end(d_module);
2294: END IF;
2295: END delete_real_attr_group;
2296:

Line 2293: PO_LOG.proc_end(d_module);

2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: IF (PO_LOG.d_exc) THEN
2292: PO_LOG.exc(d_module, d_progress, l_return_status );
2293: PO_LOG.proc_end(d_module);
2294: END IF;
2295: END delete_real_attr_group;
2296:
2297: PROCEDURE update_real_meta_attr_group

Line 2391: IF (PO_LOG.d_proc) THEN

2387: BEGIN
2388:
2389: d_progress := 10;
2390:
2391: IF (PO_LOG.d_proc) THEN
2392: PO_LOG.proc_begin(d_module);
2393: PO_LOG.proc_begin(d_module, 'p_dummy_attribute_group_id', p_dummy_attribute_group_id);
2394: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2395: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_type', p_real_attribute_group_type);

Line 2392: PO_LOG.proc_begin(d_module);

2388:
2389: d_progress := 10;
2390:
2391: IF (PO_LOG.d_proc) THEN
2392: PO_LOG.proc_begin(d_module);
2393: PO_LOG.proc_begin(d_module, 'p_dummy_attribute_group_id', p_dummy_attribute_group_id);
2394: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2395: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_type', p_real_attribute_group_type);
2396: END IF;

Line 2393: PO_LOG.proc_begin(d_module, 'p_dummy_attribute_group_id', p_dummy_attribute_group_id);

2389: d_progress := 10;
2390:
2391: IF (PO_LOG.d_proc) THEN
2392: PO_LOG.proc_begin(d_module);
2393: PO_LOG.proc_begin(d_module, 'p_dummy_attribute_group_id', p_dummy_attribute_group_id);
2394: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2395: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_type', p_real_attribute_group_type);
2396: END IF;
2397: -- Fetching the data from Dummy Attribute Group (For Attributes)

Line 2394: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);

2390:
2391: IF (PO_LOG.d_proc) THEN
2392: PO_LOG.proc_begin(d_module);
2393: PO_LOG.proc_begin(d_module, 'p_dummy_attribute_group_id', p_dummy_attribute_group_id);
2394: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2395: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_type', p_real_attribute_group_type);
2396: END IF;
2397: -- Fetching the data from Dummy Attribute Group (For Attributes)
2398: SELECT SECURITY_TYPE, MULTI_ROW, BUSINESS_EVENT_FLAG,

Line 2395: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_type', p_real_attribute_group_type);

2391: IF (PO_LOG.d_proc) THEN
2392: PO_LOG.proc_begin(d_module);
2393: PO_LOG.proc_begin(d_module, 'p_dummy_attribute_group_id', p_dummy_attribute_group_id);
2394: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_id', p_real_attribute_group_id);
2395: PO_LOG.proc_begin(d_module, 'p_real_attribute_group_type', p_real_attribute_group_type);
2396: END IF;
2397: -- Fetching the data from Dummy Attribute Group (For Attributes)
2398: SELECT SECURITY_TYPE, MULTI_ROW, BUSINESS_EVENT_FLAG,
2399: PRE_BUSINESS_EVENT_FLAG, NUM_OF_COLS, NUM_OF_ROWS, VARIANT,

Line 2409: IF PO_LOG.d_stmt THEN

2405: WHERE ATTR_GROUP_ID = p_dummy_attribute_group_id;
2406:
2407: d_progress := 20;
2408:
2409: IF PO_LOG.d_stmt THEN
2410: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);
2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);

Line 2410: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);

2406:
2407: d_progress := 20;
2408:
2409: IF PO_LOG.d_stmt THEN
2410: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);
2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);

Line 2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);

2407: d_progress := 20;
2408:
2409: IF PO_LOG.d_stmt THEN
2410: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);
2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);

Line 2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);

2408:
2409: IF PO_LOG.d_stmt THEN
2410: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);
2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);

Line 2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);

2409: IF PO_LOG.d_stmt THEN
2410: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);
2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);

Line 2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);

2410: PO_LOG.stmt(d_module, d_progress, 'l_security_type', l_security_type);
2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);
2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);
2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);

Line 2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);

2411: PO_LOG.stmt(d_module, d_progress, 'l_multi_row', l_multi_row);
2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);
2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2419: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);

Line 2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);

2412: PO_LOG.stmt(d_module, d_progress, 'l_business_event_flag', l_business_event_flag);
2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);
2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2419: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2420: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);

Line 2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);

2413: PO_LOG.stmt(d_module, d_progress, 'l_pre_business_event_flag', l_pre_business_event_flag);
2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);
2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2419: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2420: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2421: END IF;

Line 2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);

2414: PO_LOG.stmt(d_module, d_progress, 'l_num_of_cols', l_num_of_cols);
2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);
2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2419: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2420: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2421: END IF;
2422:

Line 2419: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);

2415: PO_LOG.stmt(d_module, d_progress, 'l_num_of_rows', l_num_of_rows);
2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);
2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2419: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2420: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2421: END IF;
2422:
2423: l_real_attr_grp_type := p_real_attribute_group_type;

Line 2420: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);

2416: PO_LOG.stmt(d_module, d_progress, 'l_variant', l_variant);
2417: PO_LOG.stmt(d_module, d_progress, 'l_owning_party_id', l_owning_party_id);
2418: PO_LOG.stmt(d_module, d_progress, 'l_region_code', l_region_code);
2419: PO_LOG.stmt(d_module, d_progress, 'l_view_privilege_id', l_view_privilege_id);
2420: PO_LOG.stmt(d_module, d_progress, 'l_edit_privilege_id', l_edit_privilege_id);
2421: END IF;
2422:
2423: l_real_attr_grp_type := p_real_attribute_group_type;
2424:

Line 2433: IF PO_LOG.d_stmt THEN

2429: WHERE ATTR_GROUP_ID = p_dummy_attribute_group_id;
2430:
2431: d_progress := 30;
2432:
2433: IF PO_LOG.d_stmt THEN
2434: PO_LOG.stmt(d_module, d_progress, 'l_internal_name', l_internal_name);
2435: END IF;
2436:
2437: -- Fetching the display name and desc from Dummy Attribute Group (For Attributes)

Line 2434: PO_LOG.stmt(d_module, d_progress, 'l_internal_name', l_internal_name);

2430:
2431: d_progress := 30;
2432:
2433: IF PO_LOG.d_stmt THEN
2434: PO_LOG.stmt(d_module, d_progress, 'l_internal_name', l_internal_name);
2435: END IF;
2436:
2437: -- Fetching the display name and desc from Dummy Attribute Group (For Attributes)
2438: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME, DESCRIPTION

Line 2454: IF PO_LOG.d_stmt THEN

2450: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
2451:
2452: d_progress := 40;
2453:
2454: IF PO_LOG.d_stmt THEN
2455: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_internal_name);
2456: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_desc', l_attr_grp_desc);
2457: END IF;
2458:

Line 2455: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_internal_name);

2451:
2452: d_progress := 40;
2453:
2454: IF PO_LOG.d_stmt THEN
2455: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_internal_name);
2456: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_desc', l_attr_grp_desc);
2457: END IF;
2458:
2459: -- Updating the real attribute group depending on the data from the dummy attribute group

Line 2456: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_desc', l_attr_grp_desc);

2452: d_progress := 40;
2453:
2454: IF PO_LOG.d_stmt THEN
2455: PO_LOG.stmt(d_module, d_progress, 'l_display_name', l_internal_name);
2456: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_desc', l_attr_grp_desc);
2457: END IF;
2458:
2459: -- Updating the real attribute group depending on the data from the dummy attribute group
2460: ego_ext_fwk_pub.update_attribute_group(

Line 2486: IF PO_LOG.d_stmt THEN

2482: );
2483:
2484: d_progress := 50;
2485:
2486: IF PO_LOG.d_stmt THEN
2487: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2488: END IF;
2489:
2490: -- Fetching the attributes to delete

Line 2487: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

2483:
2484: d_progress := 50;
2485:
2486: IF PO_LOG.d_stmt THEN
2487: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2488: END IF;
2489:
2490: -- Fetching the attributes to delete
2491:

Line 2521: IF PO_LOG.d_stmt THEN

2517: CLOSE c_get_attributes_to_delete;
2518:
2519: d_progress := 60;
2520:
2521: IF PO_LOG.d_stmt THEN
2522: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2523: END IF;
2524:
2525: -- Fetching the attributes to create

Line 2522: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

2518:
2519: d_progress := 60;
2520:
2521: IF PO_LOG.d_stmt THEN
2522: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2523: END IF;
2524:
2525: -- Fetching the attributes to create
2526: OPEN c_get_attributes_to_create

Line 2535: IF PO_LOG.d_stmt THEN

2531: LOOP
2532: FETCH c_get_attributes_to_create INTO l_attribute_name;
2533: EXIT WHEN c_get_attributes_to_create%NOTFOUND;
2534:
2535: IF PO_LOG.d_stmt THEN
2536: PO_LOG.stmt(d_module, d_progress, 'l_internal_name', l_internal_name);
2537: END IF;
2538: --Bug 15893437 adding exception
2539: BEGIN

Line 2536: PO_LOG.stmt(d_module, d_progress, 'l_internal_name', l_internal_name);

2532: FETCH c_get_attributes_to_create INTO l_attribute_name;
2533: EXIT WHEN c_get_attributes_to_create%NOTFOUND;
2534:
2535: IF PO_LOG.d_stmt THEN
2536: PO_LOG.stmt(d_module, d_progress, 'l_internal_name', l_internal_name);
2537: END IF;
2538: --Bug 15893437 adding exception
2539: BEGIN
2540: -- Fetching the data from dummy attributes to create real attributes

Line 2604: IF PO_LOG.d_stmt THEN

2600: AND CL.END_USER_COLUMN_NAME = l_attribute_name;
2601:
2602: d_progress := 70;
2603:
2604: IF PO_LOG.d_stmt THEN
2605: PO_LOG.stmt(d_module, d_progress, 'l_attr_display_name', l_attr_display_name);
2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);
2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);

Line 2605: PO_LOG.stmt(d_module, d_progress, 'l_attr_display_name', l_attr_display_name);

2601:
2602: d_progress := 70;
2603:
2604: IF PO_LOG.d_stmt THEN
2605: PO_LOG.stmt(d_module, d_progress, 'l_attr_display_name', l_attr_display_name);
2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);
2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);

Line 2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);

2602: d_progress := 70;
2603:
2604: IF PO_LOG.d_stmt THEN
2605: PO_LOG.stmt(d_module, d_progress, 'l_attr_display_name', l_attr_display_name);
2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);
2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);

Line 2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);

2603:
2604: IF PO_LOG.d_stmt THEN
2605: PO_LOG.stmt(d_module, d_progress, 'l_attr_display_name', l_attr_display_name);
2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);
2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);

Line 2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);

2604: IF PO_LOG.d_stmt THEN
2605: PO_LOG.stmt(d_module, d_progress, 'l_attr_display_name', l_attr_display_name);
2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);
2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);

Line 2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);

2605: PO_LOG.stmt(d_module, d_progress, 'l_attr_display_name', l_attr_display_name);
2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);
2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);

Line 2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);

2606: PO_LOG.stmt(d_module, d_progress, 'l_description', l_description);
2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);

Line 2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);

2607: PO_LOG.stmt(d_module, d_progress, 'l_sequence', l_sequence);
2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);

Line 2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);

2608: PO_LOG.stmt(d_module, d_progress, 'l_data_type', l_data_type);
2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);

Line 2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);

2609: PO_LOG.stmt(d_module, d_progress, 'l_required', l_required);
2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);

Line 2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);

2610: PO_LOG.stmt(d_module, d_progress, 'l_searchable', l_searchable);
2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);

Line 2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);

2611: PO_LOG.stmt(d_module, d_progress, 'l_read_only_flag', l_read_only_flag);
2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);

Line 2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);

2612: PO_LOG.stmt(d_module, d_progress, 'l_column', l_column);
2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);

Line 2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);

2613: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id', l_value_set_id);
2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);

Line 2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);

2614: PO_LOG.stmt(d_module, d_progress, 'l_info_1', l_info_1);
2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);

Line 2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);

2615: PO_LOG.stmt(d_module, d_progress, 'l_default_value', l_default_value);
2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);

Line 2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);

2616: PO_LOG.stmt(d_module, d_progress, 'l_unique_key_flag', l_unique_key_flag);
2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);
2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);

Line 2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);

2617: PO_LOG.stmt(d_module, d_progress, 'l_enabled', l_enabled);
2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);
2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);
2625: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);

Line 2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);

2618: PO_LOG.stmt(d_module, d_progress, 'l_display', l_display);
2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);
2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);
2625: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2626: PO_LOG.stmt(d_module, d_progress, 'l_lud', l_lud);

Line 2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);

2619: PO_LOG.stmt(d_module, d_progress, 'l_uom_class', l_uom_class);
2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);
2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);
2625: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2626: PO_LOG.stmt(d_module, d_progress, 'l_lud', l_lud);
2627: END IF;

Line 2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);

2620: PO_LOG.stmt(d_module, d_progress, 'l_control_level', l_control_level);
2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);
2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);
2625: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2626: PO_LOG.stmt(d_module, d_progress, 'l_lud', l_lud);
2627: END IF;
2628:

Line 2625: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);

2621: PO_LOG.stmt(d_module, d_progress, 'l_attribute_code', l_attribute_code);
2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);
2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);
2625: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2626: PO_LOG.stmt(d_module, d_progress, 'l_lud', l_lud);
2627: END IF;
2628:
2629: --bug15893437, commented the sql%found condition as it is not necessary and is inhibiting the call to ego_ext_fwk_pub.update_attribute or ego_ext_fwk_pub.create_attribute

Line 2626: PO_LOG.stmt(d_module, d_progress, 'l_lud', l_lud);

2622: PO_LOG.stmt(d_module, d_progress, 'l_view_in_hierarchy_code', l_view_in_hierarchy_code);
2623: PO_LOG.stmt(d_module, d_progress, 'l_edit_in_hierarchy_code', l_edit_in_hierarchy_code);
2624: PO_LOG.stmt(d_module, d_progress, 'l_customization_level', l_customization_level);
2625: PO_LOG.stmt(d_module, d_progress, 'l_owner', l_owner);
2626: PO_LOG.stmt(d_module, d_progress, 'l_lud', l_lud);
2627: END IF;
2628:
2629: --bug15893437, commented the sql%found condition as it is not necessary and is inhibiting the call to ego_ext_fwk_pub.update_attribute or ego_ext_fwk_pub.create_attribute
2630: --IF SQL%FOUND THEN

Line 2634: IF PO_LOG.d_stmt THEN

2630: --IF SQL%FOUND THEN
2631:
2632: d_progress := 80;
2633:
2634: IF PO_LOG.d_stmt THEN
2635: PO_LOG.stmt(d_module, d_progress, 'FOUND', 'FOUND');
2636: END IF;
2637:
2638: IF is_attribute_present(l_real_attr_grp_type, l_internal_name, l_attribute_name) = 'true' THEN

Line 2635: PO_LOG.stmt(d_module, d_progress, 'FOUND', 'FOUND');

2631:
2632: d_progress := 80;
2633:
2634: IF PO_LOG.d_stmt THEN
2635: PO_LOG.stmt(d_module, d_progress, 'FOUND', 'FOUND');
2636: END IF;
2637:
2638: IF is_attribute_present(l_real_attr_grp_type, l_internal_name, l_attribute_name) = 'true' THEN
2639:

Line 2682: IF PO_LOG.d_stmt THEN

2678: );
2679:
2680: d_progress := 90;
2681:
2682: IF PO_LOG.d_stmt THEN
2683: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2684: END IF;
2685:
2686: ELSE

Line 2683: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

2679:
2680: d_progress := 90;
2681:
2682: IF PO_LOG.d_stmt THEN
2683: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2684: END IF;
2685:
2686: ELSE
2687:

Line 2729: IF PO_LOG.d_stmt THEN

2725: );
2726:
2727: d_progress := 100;
2728:
2729: IF PO_LOG.d_stmt THEN
2730: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2731: END IF;
2732:
2733: END IF;

Line 2730: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

2726:
2727: d_progress := 100;
2728:
2729: IF PO_LOG.d_stmt THEN
2730: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
2731: END IF;
2732:
2733: END IF;
2734: --END IF;

Line 2739: IF (PO_LOG.d_exc) THEN

2735: --Bug 15893437 adding exception
2736: EXCEPTION
2737: WHEN OTHERS THEN
2738: d_progress := 101;
2739: IF (PO_LOG.d_exc) THEN
2740: PO_LOG.exc(d_module, d_progress, l_return_status );
2741: PO_LOG.proc_end(d_module);
2742: END IF;
2743: END;

Line 2740: PO_LOG.exc(d_module, d_progress, l_return_status );

2736: EXCEPTION
2737: WHEN OTHERS THEN
2738: d_progress := 101;
2739: IF (PO_LOG.d_exc) THEN
2740: PO_LOG.exc(d_module, d_progress, l_return_status );
2741: PO_LOG.proc_end(d_module);
2742: END IF;
2743: END;
2744: END LOOP;

Line 2741: PO_LOG.proc_end(d_module);

2737: WHEN OTHERS THEN
2738: d_progress := 101;
2739: IF (PO_LOG.d_exc) THEN
2740: PO_LOG.exc(d_module, d_progress, l_return_status );
2741: PO_LOG.proc_end(d_module);
2742: END IF;
2743: END;
2744: END LOOP;
2745: CLOSE c_get_attributes_to_create;

Line 2748: IF (PO_LOG.d_exc) THEN

2744: END LOOP;
2745: CLOSE c_get_attributes_to_create;
2746: d_progress := 100;
2747:
2748: IF (PO_LOG.d_exc) THEN
2749: PO_LOG.exc(d_module, d_progress, l_return_status );
2750: PO_LOG.proc_end(d_module);
2751: END IF;
2752: EXCEPTION

Line 2749: PO_LOG.exc(d_module, d_progress, l_return_status );

2745: CLOSE c_get_attributes_to_create;
2746: d_progress := 100;
2747:
2748: IF (PO_LOG.d_exc) THEN
2749: PO_LOG.exc(d_module, d_progress, l_return_status );
2750: PO_LOG.proc_end(d_module);
2751: END IF;
2752: EXCEPTION
2753: WHEN OTHERS THEN

Line 2750: PO_LOG.proc_end(d_module);

2746: d_progress := 100;
2747:
2748: IF (PO_LOG.d_exc) THEN
2749: PO_LOG.exc(d_module, d_progress, l_return_status );
2750: PO_LOG.proc_end(d_module);
2751: END IF;
2752: EXCEPTION
2753: WHEN OTHERS THEN
2754: IF (PO_LOG.d_exc) THEN

Line 2754: IF (PO_LOG.d_exc) THEN

2750: PO_LOG.proc_end(d_module);
2751: END IF;
2752: EXCEPTION
2753: WHEN OTHERS THEN
2754: IF (PO_LOG.d_exc) THEN
2755: PO_LOG.exc(d_module, d_progress, l_return_status );
2756: PO_LOG.proc_end(d_module);
2757: END IF;
2758: END update_real_meta_attr_group;

Line 2755: PO_LOG.exc(d_module, d_progress, l_return_status );

2751: END IF;
2752: EXCEPTION
2753: WHEN OTHERS THEN
2754: IF (PO_LOG.d_exc) THEN
2755: PO_LOG.exc(d_module, d_progress, l_return_status );
2756: PO_LOG.proc_end(d_module);
2757: END IF;
2758: END update_real_meta_attr_group;
2759:

Line 2756: PO_LOG.proc_end(d_module);

2752: EXCEPTION
2753: WHEN OTHERS THEN
2754: IF (PO_LOG.d_exc) THEN
2755: PO_LOG.exc(d_module, d_progress, l_return_status );
2756: PO_LOG.proc_end(d_module);
2757: END IF;
2758: END update_real_meta_attr_group;
2759:
2760: FUNCTION is_attribute_present(p_real_attr_grp_type IN VARCHAR2, p_real_internal_name IN VARCHAR2, p_attribute_name IN VARCHAR2)

Line 2773: IF (PO_LOG.d_proc) THEN

2769: BEGIN
2770:
2771: d_progress := 10;
2772:
2773: IF (PO_LOG.d_proc) THEN
2774: PO_LOG.proc_begin(d_module);
2775: PO_LOG.proc_begin(d_module, 'p_real_attr_grp_type', p_real_attr_grp_type);
2776: PO_LOG.proc_begin(d_module, 'p_real_internal_name', p_real_internal_name);
2777: PO_LOG.proc_begin(d_module, 'p_attribute_name', p_attribute_name);

Line 2774: PO_LOG.proc_begin(d_module);

2770:
2771: d_progress := 10;
2772:
2773: IF (PO_LOG.d_proc) THEN
2774: PO_LOG.proc_begin(d_module);
2775: PO_LOG.proc_begin(d_module, 'p_real_attr_grp_type', p_real_attr_grp_type);
2776: PO_LOG.proc_begin(d_module, 'p_real_internal_name', p_real_internal_name);
2777: PO_LOG.proc_begin(d_module, 'p_attribute_name', p_attribute_name);
2778: END IF;

Line 2775: PO_LOG.proc_begin(d_module, 'p_real_attr_grp_type', p_real_attr_grp_type);

2771: d_progress := 10;
2772:
2773: IF (PO_LOG.d_proc) THEN
2774: PO_LOG.proc_begin(d_module);
2775: PO_LOG.proc_begin(d_module, 'p_real_attr_grp_type', p_real_attr_grp_type);
2776: PO_LOG.proc_begin(d_module, 'p_real_internal_name', p_real_internal_name);
2777: PO_LOG.proc_begin(d_module, 'p_attribute_name', p_attribute_name);
2778: END IF;
2779:

Line 2776: PO_LOG.proc_begin(d_module, 'p_real_internal_name', p_real_internal_name);

2772:
2773: IF (PO_LOG.d_proc) THEN
2774: PO_LOG.proc_begin(d_module);
2775: PO_LOG.proc_begin(d_module, 'p_real_attr_grp_type', p_real_attr_grp_type);
2776: PO_LOG.proc_begin(d_module, 'p_real_internal_name', p_real_internal_name);
2777: PO_LOG.proc_begin(d_module, 'p_attribute_name', p_attribute_name);
2778: END IF;
2779:
2780: SELECT 1

Line 2777: PO_LOG.proc_begin(d_module, 'p_attribute_name', p_attribute_name);

2773: IF (PO_LOG.d_proc) THEN
2774: PO_LOG.proc_begin(d_module);
2775: PO_LOG.proc_begin(d_module, 'p_real_attr_grp_type', p_real_attr_grp_type);
2776: PO_LOG.proc_begin(d_module, 'p_real_internal_name', p_real_internal_name);
2777: PO_LOG.proc_begin(d_module, 'p_attribute_name', p_attribute_name);
2778: END IF;
2779:
2780: SELECT 1
2781: INTO l_present

Line 2789: IF (PO_LOG.d_exc) THEN

2785: AND END_USER_COLUMN_NAME = p_attribute_name
2786: AND ROWNUM < 2;
2787:
2788: IF l_present = 1 THEN
2789: IF (PO_LOG.d_exc) THEN
2790: PO_LOG.exc(d_module, d_progress, 'true' );
2791: PO_LOG.proc_end(d_module);
2792: END IF;
2793: RETURN 'true';

Line 2790: PO_LOG.exc(d_module, d_progress, 'true' );

2786: AND ROWNUM < 2;
2787:
2788: IF l_present = 1 THEN
2789: IF (PO_LOG.d_exc) THEN
2790: PO_LOG.exc(d_module, d_progress, 'true' );
2791: PO_LOG.proc_end(d_module);
2792: END IF;
2793: RETURN 'true';
2794: END IF;

Line 2791: PO_LOG.proc_end(d_module);

2787:
2788: IF l_present = 1 THEN
2789: IF (PO_LOG.d_exc) THEN
2790: PO_LOG.exc(d_module, d_progress, 'true' );
2791: PO_LOG.proc_end(d_module);
2792: END IF;
2793: RETURN 'true';
2794: END IF;
2795: EXCEPTION

Line 2797: IF (PO_LOG.d_exc) THEN

2793: RETURN 'true';
2794: END IF;
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: IF (PO_LOG.d_exc) THEN
2798: PO_LOG.exc(d_module, d_progress, 'false' );
2799: PO_LOG.proc_end(d_module);
2800: END IF;
2801: RETURN 'false';

Line 2798: PO_LOG.exc(d_module, d_progress, 'false' );

2794: END IF;
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: IF (PO_LOG.d_exc) THEN
2798: PO_LOG.exc(d_module, d_progress, 'false' );
2799: PO_LOG.proc_end(d_module);
2800: END IF;
2801: RETURN 'false';
2802: END is_attribute_present;

Line 2799: PO_LOG.proc_end(d_module);

2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: IF (PO_LOG.d_exc) THEN
2798: PO_LOG.exc(d_module, d_progress, 'false' );
2799: PO_LOG.proc_end(d_module);
2800: END IF;
2801: RETURN 'false';
2802: END is_attribute_present;
2803:

Line 2815: IF (PO_LOG.d_proc) THEN

2811: BEGIN
2812:
2813: d_progress := 10;
2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module);
2817: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2818: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2819: END IF;

Line 2816: PO_LOG.proc_begin(d_module);

2812:
2813: d_progress := 10;
2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module);
2817: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2818: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2819: END IF;
2820:

Line 2817: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);

2813: d_progress := 10;
2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module);
2817: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2818: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2819: END IF;
2820:
2821: IF p_data_level_type = 'PO_HEADER_EXT_ATTRS' THEN

Line 2818: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);

2814:
2815: IF (PO_LOG.d_proc) THEN
2816: PO_LOG.proc_begin(d_module);
2817: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2818: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2819: END IF;
2820:
2821: IF p_data_level_type = 'PO_HEADER_EXT_ATTRS' THEN
2822: UPDATE PO_UDA_MAPPINGS

Line 2867: IF (PO_LOG.d_exc) THEN

2863: SET BID_ITEM_PRICE_GROUP_ID = NULL
2864: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2865: END IF;
2866:
2867: IF (PO_LOG.d_exc) THEN
2868: PO_LOG.exc(d_module, d_progress, 'true' );
2869: PO_LOG.proc_end(d_module);
2870: END IF;
2871:

Line 2868: PO_LOG.exc(d_module, d_progress, 'true' );

2864: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2865: END IF;
2866:
2867: IF (PO_LOG.d_exc) THEN
2868: PO_LOG.exc(d_module, d_progress, 'true' );
2869: PO_LOG.proc_end(d_module);
2870: END IF;
2871:
2872: RETURN 'true';

Line 2869: PO_LOG.proc_end(d_module);

2865: END IF;
2866:
2867: IF (PO_LOG.d_exc) THEN
2868: PO_LOG.exc(d_module, d_progress, 'true' );
2869: PO_LOG.proc_end(d_module);
2870: END IF;
2871:
2872: RETURN 'true';
2873: EXCEPTION

Line 2875: IF (PO_LOG.d_exc) THEN

2871:
2872: RETURN 'true';
2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: IF (PO_LOG.d_exc) THEN
2876: PO_LOG.exc(d_module, d_progress, 'false' );
2877: PO_LOG.proc_end(d_module);
2878: END IF;
2879: RETURN 'false';

Line 2876: PO_LOG.exc(d_module, d_progress, 'false' );

2872: RETURN 'true';
2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: IF (PO_LOG.d_exc) THEN
2876: PO_LOG.exc(d_module, d_progress, 'false' );
2877: PO_LOG.proc_end(d_module);
2878: END IF;
2879: RETURN 'false';
2880: END update_map_table;

Line 2877: PO_LOG.proc_end(d_module);

2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: IF (PO_LOG.d_exc) THEN
2876: PO_LOG.exc(d_module, d_progress, 'false' );
2877: PO_LOG.proc_end(d_module);
2878: END IF;
2879: RETURN 'false';
2880: END update_map_table;
2881:

Line 2905: IF (PO_LOG.d_proc) THEN

2901: BEGIN
2902:
2903: d_progress := 10;
2904:
2905: IF (PO_LOG.d_proc) THEN
2906: PO_LOG.proc_begin(d_module);
2907: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2908: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2909: END IF;

Line 2906: PO_LOG.proc_begin(d_module);

2902:
2903: d_progress := 10;
2904:
2905: IF (PO_LOG.d_proc) THEN
2906: PO_LOG.proc_begin(d_module);
2907: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2908: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2909: END IF;
2910:

Line 2907: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);

2903: d_progress := 10;
2904:
2905: IF (PO_LOG.d_proc) THEN
2906: PO_LOG.proc_begin(d_module);
2907: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2908: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2909: END IF;
2910:
2911: BEGIN

Line 2908: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);

2904:
2905: IF (PO_LOG.d_proc) THEN
2906: PO_LOG.proc_begin(d_module);
2907: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
2908: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2909: END IF;
2910:
2911: BEGIN
2912:

Line 2943: IF (PO_LOG.d_exc) THEN

2939:
2940: EXCEPTION
2941: WHEN NO_DATA_FOUND THEN
2942: d_progress := 30;
2943: IF (PO_LOG.d_exc) THEN
2944: PO_LOG.exc(d_module, d_progress, 'NULL' );
2945: PO_LOG.proc_end(d_module);
2946: END IF;
2947: RETURN NULL;

Line 2944: PO_LOG.exc(d_module, d_progress, 'NULL' );

2940: EXCEPTION
2941: WHEN NO_DATA_FOUND THEN
2942: d_progress := 30;
2943: IF (PO_LOG.d_exc) THEN
2944: PO_LOG.exc(d_module, d_progress, 'NULL' );
2945: PO_LOG.proc_end(d_module);
2946: END IF;
2947: RETURN NULL;
2948: END;

Line 2945: PO_LOG.proc_end(d_module);

2941: WHEN NO_DATA_FOUND THEN
2942: d_progress := 30;
2943: IF (PO_LOG.d_exc) THEN
2944: PO_LOG.exc(d_module, d_progress, 'NULL' );
2945: PO_LOG.proc_end(d_module);
2946: END IF;
2947: RETURN NULL;
2948: END;
2949:

Line 2982: IF (PO_LOG.d_exc) THEN

2978: d_progress := 50;
2979: EXCEPTION
2980: WHEN OTHERS THEN
2981: d_progress := 60;
2982: IF (PO_LOG.d_exc) THEN
2983: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );
2984: PO_LOG.proc_end(d_module);
2985: END IF;
2986: END get_map_table_details;

Line 2983: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );

2979: EXCEPTION
2980: WHEN OTHERS THEN
2981: d_progress := 60;
2982: IF (PO_LOG.d_exc) THEN
2983: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );
2984: PO_LOG.proc_end(d_module);
2985: END IF;
2986: END get_map_table_details;
2987:

Line 2984: PO_LOG.proc_end(d_module);

2980: WHEN OTHERS THEN
2981: d_progress := 60;
2982: IF (PO_LOG.d_exc) THEN
2983: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );
2984: PO_LOG.proc_end(d_module);
2985: END IF;
2986: END get_map_table_details;
2987:
2988:

Line 3007: IF (PO_LOG.d_proc) THEN

3003: BEGIN
3004:
3005: d_progress := 10;
3006:
3007: IF (PO_LOG.d_proc) THEN
3008: PO_LOG.proc_begin(d_module);
3009: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
3010: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
3011: END IF;

Line 3008: PO_LOG.proc_begin(d_module);

3004:
3005: d_progress := 10;
3006:
3007: IF (PO_LOG.d_proc) THEN
3008: PO_LOG.proc_begin(d_module);
3009: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
3010: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
3011: END IF;
3012:

Line 3009: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);

3005: d_progress := 10;
3006:
3007: IF (PO_LOG.d_proc) THEN
3008: PO_LOG.proc_begin(d_module);
3009: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
3010: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
3011: END IF;
3012:
3013: BEGIN

Line 3010: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);

3006:
3007: IF (PO_LOG.d_proc) THEN
3008: PO_LOG.proc_begin(d_module);
3009: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
3010: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
3011: END IF;
3012:
3013: BEGIN
3014: SELECT 1, dummy_def.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 3027: IF (PO_LOG.d_exc) THEN

3023: AND levels.DATA_LEVEL_NAME = p_data_level;
3024: EXCEPTION
3025: WHEN NO_DATA_FOUND THEN
3026: d_progress := 20;
3027: IF (PO_LOG.d_exc) THEN
3028: PO_LOG.exc(d_module, d_progress, 'false' );
3029: PO_LOG.proc_end(d_module);
3030: END IF;
3031: RETURN 'false';

Line 3028: PO_LOG.exc(d_module, d_progress, 'false' );

3024: EXCEPTION
3025: WHEN NO_DATA_FOUND THEN
3026: d_progress := 20;
3027: IF (PO_LOG.d_exc) THEN
3028: PO_LOG.exc(d_module, d_progress, 'false' );
3029: PO_LOG.proc_end(d_module);
3030: END IF;
3031: RETURN 'false';
3032: END;

Line 3029: PO_LOG.proc_end(d_module);

3025: WHEN NO_DATA_FOUND THEN
3026: d_progress := 20;
3027: IF (PO_LOG.d_exc) THEN
3028: PO_LOG.exc(d_module, d_progress, 'false' );
3029: PO_LOG.proc_end(d_module);
3030: END IF;
3031: RETURN 'false';
3032: END;
3033: d_progress := 30;

Line 3034: IF (PO_LOG.d_exc) THEN

3030: END IF;
3031: RETURN 'false';
3032: END;
3033: d_progress := 30;
3034: IF (PO_LOG.d_exc) THEN
3035: PO_LOG.exc(d_module, d_progress, 'true' );
3036: PO_LOG.proc_end(d_module);
3037: END IF;
3038: RETURN 'true';

Line 3035: PO_LOG.exc(d_module, d_progress, 'true' );

3031: RETURN 'false';
3032: END;
3033: d_progress := 30;
3034: IF (PO_LOG.d_exc) THEN
3035: PO_LOG.exc(d_module, d_progress, 'true' );
3036: PO_LOG.proc_end(d_module);
3037: END IF;
3038: RETURN 'true';
3039: EXCEPTION

Line 3036: PO_LOG.proc_end(d_module);

3032: END;
3033: d_progress := 30;
3034: IF (PO_LOG.d_exc) THEN
3035: PO_LOG.exc(d_module, d_progress, 'true' );
3036: PO_LOG.proc_end(d_module);
3037: END IF;
3038: RETURN 'true';
3039: EXCEPTION
3040: WHEN OTHERS THEN

Line 3042: IF (PO_LOG.d_exc) THEN

3038: RETURN 'true';
3039: EXCEPTION
3040: WHEN OTHERS THEN
3041: d_progress := 40;
3042: IF (PO_LOG.d_exc) THEN
3043: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );
3044: PO_LOG.proc_end(d_module);
3045: END IF;
3046: END is_data_level_present;

Line 3043: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );

3039: EXCEPTION
3040: WHEN OTHERS THEN
3041: d_progress := 40;
3042: IF (PO_LOG.d_exc) THEN
3043: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );
3044: PO_LOG.proc_end(d_module);
3045: END IF;
3046: END is_data_level_present;
3047:

Line 3044: PO_LOG.proc_end(d_module);

3040: WHEN OTHERS THEN
3041: d_progress := 40;
3042: IF (PO_LOG.d_exc) THEN
3043: PO_LOG.exc(d_module, d_progress, 'EXCEPTION' );
3044: PO_LOG.proc_end(d_module);
3045: END IF;
3046: END is_data_level_present;
3047:
3048: PROCEDURE DELETE_TEMP_USAGES

Line 3073: IF (PO_LOG.d_proc) THEN

3069: WHERE template_id = p_template_id;
3070:
3071: BEGIN
3072:
3073: IF (PO_LOG.d_proc) THEN
3074: PO_LOG.proc_begin(d_module);
3075: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3076: END IF;
3077:

Line 3074: PO_LOG.proc_begin(d_module);

3070:
3071: BEGIN
3072:
3073: IF (PO_LOG.d_proc) THEN
3074: PO_LOG.proc_begin(d_module);
3075: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3076: END IF;
3077:
3078: j := 0;

Line 3075: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

3071: BEGIN
3072:
3073: IF (PO_LOG.d_proc) THEN
3074: PO_LOG.proc_begin(d_module);
3075: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3076: END IF;
3077:
3078: j := 0;
3079: d_progress := 10;

Line 3098: IF PO_LOG.d_stmt THEN

3094:
3095: DELETE FROM PO_UDA_AG_TEMPLATE_USAGES
3096: WHERE association_id = association_ids_rec.association_id;
3097:
3098: IF PO_LOG.d_stmt THEN
3099: PO_LOG.stmt(d_module, d_progress, 'Deleted association and usages for association_id:', association_ids_rec.association_id);
3100: END IF;
3101:
3102: ELSE

Line 3099: PO_LOG.stmt(d_module, d_progress, 'Deleted association and usages for association_id:', association_ids_rec.association_id);

3095: DELETE FROM PO_UDA_AG_TEMPLATE_USAGES
3096: WHERE association_id = association_ids_rec.association_id;
3097:
3098: IF PO_LOG.d_stmt THEN
3099: PO_LOG.stmt(d_module, d_progress, 'Deleted association and usages for association_id:', association_ids_rec.association_id);
3100: END IF;
3101:
3102: ELSE
3103: x_return_status := l_return_status;

Line 3107: IF PO_LOG.d_stmt THEN

3103: x_return_status := l_return_status;
3104: x_msg_count := l_msg_count;
3105: x_msg_data := l_msg_data;
3106:
3107: IF PO_LOG.d_stmt THEN
3108: PO_LOG.stmt(d_module, d_progress, 'Status Error when deleting association_id:', association_ids_rec.association_id);
3109: END IF;
3110:
3111: RETURN;

Line 3108: PO_LOG.stmt(d_module, d_progress, 'Status Error when deleting association_id:', association_ids_rec.association_id);

3104: x_msg_count := l_msg_count;
3105: x_msg_data := l_msg_data;
3106:
3107: IF PO_LOG.d_stmt THEN
3108: PO_LOG.stmt(d_module, d_progress, 'Status Error when deleting association_id:', association_ids_rec.association_id);
3109: END IF;
3110:
3111: RETURN;
3112: END IF;

Line 3125: IF PO_LOG.d_stmt THEN

3121: x_return_status := l_return_status;
3122: x_msg_count := l_msg_count;
3123: x_msg_data := l_msg_data;
3124:
3125: IF PO_LOG.d_stmt THEN
3126: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
3127: END IF;
3128:
3129: EXCEPTION

Line 3126: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

3122: x_msg_count := l_msg_count;
3123: x_msg_data := l_msg_data;
3124:
3125: IF PO_LOG.d_stmt THEN
3126: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
3127: END IF;
3128:
3129: EXCEPTION
3130: WHEN OTHERS THEN

Line 3133: IF PO_LOG.d_stmt THEN

3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: d_progress := 30;
3132: x_return_status := 'U';
3133: IF PO_LOG.d_stmt THEN
3134: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3135: END IF;
3136:
3137: END DELETE_TEMP_USAGES;

Line 3134: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3130: WHEN OTHERS THEN
3131: d_progress := 30;
3132: x_return_status := 'U';
3133: IF PO_LOG.d_stmt THEN
3134: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3135: END IF;
3136:
3137: END DELETE_TEMP_USAGES;
3138:

Line 3160: IF (PO_LOG.d_proc) THEN

3156: AND ATTRIBUTE_CATEGORY = p_usage_name ;
3157:
3158: BEGIN
3159:
3160: IF (PO_LOG.d_proc) THEN
3161: PO_LOG.proc_begin(d_module);
3162: PO_LOG.proc_begin(d_module, 'p_usage_name', p_usage_name);
3163: END IF;
3164:

Line 3161: PO_LOG.proc_begin(d_module);

3157:
3158: BEGIN
3159:
3160: IF (PO_LOG.d_proc) THEN
3161: PO_LOG.proc_begin(d_module);
3162: PO_LOG.proc_begin(d_module, 'p_usage_name', p_usage_name);
3163: END IF;
3164:
3165: FOR c_get_usage_id_rec IN c_get_usage_id(p_template_id,p_usage_name) LOOP

Line 3162: PO_LOG.proc_begin(d_module, 'p_usage_name', p_usage_name);

3158: BEGIN
3159:
3160: IF (PO_LOG.d_proc) THEN
3161: PO_LOG.proc_begin(d_module);
3162: PO_LOG.proc_begin(d_module, 'p_usage_name', p_usage_name);
3163: END IF;
3164:
3165: FOR c_get_usage_id_rec IN c_get_usage_id(p_template_id,p_usage_name) LOOP
3166:

Line 3182: IF PO_LOG.d_stmt THEN

3178: END LOOP ;
3179:
3180: COMMIT ;
3181:
3182: IF PO_LOG.d_stmt THEN
3183: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3184: END IF;
3185:
3186: END DELETE_TEMP_SINGLE_USAGE;

Line 3183: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3179:
3180: COMMIT ;
3181:
3182: IF PO_LOG.d_stmt THEN
3183: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3184: END IF;
3185:
3186: END DELETE_TEMP_SINGLE_USAGE;
3187:

Line 3227: IF (PO_LOG.d_proc) THEN

3223: WHERE template_id = p_template_id;
3224:
3225: BEGIN
3226:
3227: IF (PO_LOG.d_proc) THEN
3228: PO_LOG.proc_begin(d_module);
3229: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3230: END IF;
3231:

Line 3228: PO_LOG.proc_begin(d_module);

3224:
3225: BEGIN
3226:
3227: IF (PO_LOG.d_proc) THEN
3228: PO_LOG.proc_begin(d_module);
3229: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3230: END IF;
3231:
3232: OPEN get_entity_code( p_template_id);

Line 3229: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

3225: BEGIN
3226:
3227: IF (PO_LOG.d_proc) THEN
3228: PO_LOG.proc_begin(d_module);
3229: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3230: END IF;
3231:
3232: OPEN get_entity_code( p_template_id);
3233: FETCH get_entity_code INTO l_entity_code;

Line 3260: IF PO_LOG.d_stmt THEN

3256: IF (l_select_columns IS NOT NULL AND l_select_query IS NOT NULL) THEN
3257:
3258: l_create_view := 'CREATE OR REPLACE VIEW ' || l_view_name || '('|| l_select_columns ||' ) AS ( '|| l_select_query ||' )' ;
3259:
3260: IF PO_LOG.d_stmt THEN
3261: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3262: END IF;
3263:
3264: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */

Line 3261: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);

3257:
3258: l_create_view := 'CREATE OR REPLACE VIEW ' || l_view_name || '('|| l_select_columns ||' ) AS ( '|| l_select_query ||' )' ;
3259:
3260: IF PO_LOG.d_stmt THEN
3261: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3262: END IF;
3263:
3264: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */
3265: -- get the APPLSYS schema name

Line 3284: IF PO_LOG.d_stmt THEN

3280: WHERE template_id = p_template_id;
3281:
3282: x_template_view_name := l_view_name;
3283:
3284: IF PO_LOG.d_stmt THEN
3285: PO_LOG.stmt(d_module, d_progress, 'l_view_name', l_view_name);
3286: END IF;
3287:
3288: d_progress := 20;

Line 3285: PO_LOG.stmt(d_module, d_progress, 'l_view_name', l_view_name);

3281:
3282: x_template_view_name := l_view_name;
3283:
3284: IF PO_LOG.d_stmt THEN
3285: PO_LOG.stmt(d_module, d_progress, 'l_view_name', l_view_name);
3286: END IF;
3287:
3288: d_progress := 20;
3289:

Line 3314: IF PO_LOG.d_stmt THEN

3310: IF (l_select_columns IS NOT NULL AND l_select_query IS NOT NULL) THEN
3311:
3312: l_create_view := 'CREATE OR REPLACE VIEW ' || l_hist_view_name || '('|| l_select_columns ||' ) AS ( '|| l_select_query ||' )' ;
3313:
3314: IF PO_LOG.d_stmt THEN
3315: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3316: END IF;
3317:
3318: /* 12.2 online patching project impact: use ad_ddl instead of execute immediate */

Line 3315: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);

3311:
3312: l_create_view := 'CREATE OR REPLACE VIEW ' || l_hist_view_name || '('|| l_select_columns ||' ) AS ( '|| l_select_query ||' )' ;
3313:
3314: IF PO_LOG.d_stmt THEN
3315: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3316: END IF;
3317:
3318: /* 12.2 online patching project impact: use ad_ddl instead of execute immediate */
3319: ad_ddl.do_ddl (applsys_schema => l_applsys_schema,

Line 3331: IF PO_LOG.d_stmt THEN

3327: END IF;
3328:
3329: x_return_status := 'S';
3330:
3331: IF PO_LOG.d_stmt THEN
3332: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
3333: END IF;
3334:
3335: EXCEPTION

Line 3332: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);

3328:
3329: x_return_status := 'S';
3330:
3331: IF PO_LOG.d_stmt THEN
3332: PO_LOG.stmt(d_module, d_progress, 'l_return_status', l_return_status);
3333: END IF;
3334:
3335: EXCEPTION
3336: WHEN OTHERS THEN

Line 3339: IF PO_LOG.d_stmt THEN

3335: EXCEPTION
3336: WHEN OTHERS THEN
3337: d_progress := 30;
3338: x_return_status := 'U';
3339: IF PO_LOG.d_stmt THEN
3340: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3341: END IF;
3342:
3343:

Line 3340: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3336: WHEN OTHERS THEN
3337: d_progress := 30;
3338: x_return_status := 'U';
3339: IF PO_LOG.d_stmt THEN
3340: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3341: END IF;
3342:
3343:
3344: END generate_template_view;

Line 3379: IF (PO_LOG.d_proc) THEN

3375:
3376:
3377: BEGIN
3378:
3379: IF (PO_LOG.d_proc) THEN
3380: PO_LOG.proc_begin(d_module);
3381: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3382: END IF;
3383:

Line 3380: PO_LOG.proc_begin(d_module);

3376:
3377: BEGIN
3378:
3379: IF (PO_LOG.d_proc) THEN
3380: PO_LOG.proc_begin(d_module);
3381: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3382: END IF;
3383:
3384: l_entity_view_name := p_entity_code ||'_V';

Line 3381: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);

3377: BEGIN
3378:
3379: IF (PO_LOG.d_proc) THEN
3380: PO_LOG.proc_begin(d_module);
3381: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3382: END IF;
3383:
3384: l_entity_view_name := p_entity_code ||'_V';
3385:

Line 3388: IF PO_LOG.d_stmt THEN

3384: l_entity_view_name := p_entity_code ||'_V';
3385:
3386: d_progress := 10;
3387:
3388: IF PO_LOG.d_stmt THEN
3389: PO_LOG.stmt(d_module, d_progress, 'p_entity_code', p_entity_code);
3390: END IF;
3391:
3392: -- Creates the query of the view(l_select_query) and the view columns names(l_select_columns)

Line 3389: PO_LOG.stmt(d_module, d_progress, 'p_entity_code', p_entity_code);

3385:
3386: d_progress := 10;
3387:
3388: IF PO_LOG.d_stmt THEN
3389: PO_LOG.stmt(d_module, d_progress, 'p_entity_code', p_entity_code);
3390: END IF;
3391:
3392: -- Creates the query of the view(l_select_query) and the view columns names(l_select_columns)
3393: get_query_for_entity_view(p_api_version => 1.0,

Line 3404: IF PO_LOG.d_stmt THEN

3400:
3401: IF (l_select_columns IS NOT NULL AND l_select_query IS NOT NULL) THEN
3402: l_create_view := 'CREATE OR REPLACE VIEW ' || l_view_name || '('|| l_select_columns ||' ) AS ( '|| l_select_query ||' )' ;
3403:
3404: IF PO_LOG.d_stmt THEN
3405: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3406: END IF;
3407:
3408:

Line 3405: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);

3401: IF (l_select_columns IS NOT NULL AND l_select_query IS NOT NULL) THEN
3402: l_create_view := 'CREATE OR REPLACE VIEW ' || l_view_name || '('|| l_select_columns ||' ) AS ( '|| l_select_query ||' )' ;
3403:
3404: IF PO_LOG.d_stmt THEN
3405: PO_LOG.stmt(d_module, d_progress, 'l_create_view', l_create_view);
3406: END IF;
3407:
3408:
3409: /* 12.2 Online patching project impact: Use ad_ddl instead of execute immediate */

Line 3426: IF PO_LOG.d_stmt THEN

3422:
3423: x_template_view_name := l_entity_view_name;
3424:
3425: d_progress := 20;
3426: IF PO_LOG.d_stmt THEN
3427: PO_LOG.stmt(d_module, d_progress, 'l_view_name', l_view_name);
3428: END IF;
3429:
3430: EXCEPTION

Line 3427: PO_LOG.stmt(d_module, d_progress, 'l_view_name', l_view_name);

3423: x_template_view_name := l_entity_view_name;
3424:
3425: d_progress := 20;
3426: IF PO_LOG.d_stmt THEN
3427: PO_LOG.stmt(d_module, d_progress, 'l_view_name', l_view_name);
3428: END IF;
3429:
3430: EXCEPTION
3431: WHEN OTHERS THEN

Line 3434: IF PO_LOG.d_stmt THEN

3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: d_progress := 30;
3433: x_return_status := 'U';
3434: IF PO_LOG.d_stmt THEN
3435: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3436: END IF;
3437:
3438: END generate_entity_view;

Line 3435: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3431: WHEN OTHERS THEN
3432: d_progress := 30;
3433: x_return_status := 'U';
3434: IF PO_LOG.d_stmt THEN
3435: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3436: END IF;
3437:
3438: END generate_entity_view;
3439:

Line 3469: IF (PO_LOG.d_proc) THEN

3465:
3466:
3467: BEGIN
3468:
3469: IF (PO_LOG.d_proc) THEN
3470: PO_LOG.proc_begin(d_module);
3471: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3472: END IF;
3473:

Line 3470: PO_LOG.proc_begin(d_module);

3466:
3467: BEGIN
3468:
3469: IF (PO_LOG.d_proc) THEN
3470: PO_LOG.proc_begin(d_module);
3471: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3472: END IF;
3473:
3474: d_progress := 10;

Line 3471: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

3467: BEGIN
3468:
3469: IF (PO_LOG.d_proc) THEN
3470: PO_LOG.proc_begin(d_module);
3471: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3472: END IF;
3473:
3474: d_progress := 10;
3475:

Line 3503: IF PO_LOG.d_stmt THEN

3499:
3500: x_template_view_name := x_template_view_name || l_revision;
3501: x_return_status := 'S';
3502:
3503: IF PO_LOG.d_stmt THEN
3504: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);
3505: END IF;
3506:
3507: EXCEPTION

Line 3504: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);

3500: x_template_view_name := x_template_view_name || l_revision;
3501: x_return_status := 'S';
3502:
3503: IF PO_LOG.d_stmt THEN
3504: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);
3505: END IF;
3506:
3507: EXCEPTION
3508: WHEN OTHERS THEN

Line 3511: IF PO_LOG.d_stmt THEN

3507: EXCEPTION
3508: WHEN OTHERS THEN
3509: d_progress := 30;
3510: x_return_status := 'U';
3511: IF PO_LOG.d_stmt THEN
3512: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3513: END IF;
3514:
3515: END get_template_view_name;

Line 3512: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3508: WHEN OTHERS THEN
3509: d_progress := 30;
3510: x_return_status := 'U';
3511: IF PO_LOG.d_stmt THEN
3512: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3513: END IF;
3514:
3515: END get_template_view_name;
3516:

Line 3537: IF (PO_LOG.d_proc) THEN

3533: l_entity_code VARCHAR2(300);
3534:
3535: BEGIN
3536:
3537: IF (PO_LOG.d_proc) THEN
3538: PO_LOG.proc_begin(d_module);
3539: PO_LOG.proc_begin(d_module, 'p_template_code', p_template_code);
3540: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3541: END IF;

Line 3538: PO_LOG.proc_begin(d_module);

3534:
3535: BEGIN
3536:
3537: IF (PO_LOG.d_proc) THEN
3538: PO_LOG.proc_begin(d_module);
3539: PO_LOG.proc_begin(d_module, 'p_template_code', p_template_code);
3540: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3541: END IF;
3542:

Line 3539: PO_LOG.proc_begin(d_module, 'p_template_code', p_template_code);

3535: BEGIN
3536:
3537: IF (PO_LOG.d_proc) THEN
3538: PO_LOG.proc_begin(d_module);
3539: PO_LOG.proc_begin(d_module, 'p_template_code', p_template_code);
3540: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3541: END IF;
3542:
3543: l_entity_code := replace(p_entity_code, 'EXT_ATTRS');

Line 3540: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);

3536:
3537: IF (PO_LOG.d_proc) THEN
3538: PO_LOG.proc_begin(d_module);
3539: PO_LOG.proc_begin(d_module, 'p_template_code', p_template_code);
3540: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3541: END IF;
3542:
3543: l_entity_code := replace(p_entity_code, 'EXT_ATTRS');
3544:

Line 3547: IF PO_LOG.d_stmt THEN

3543: l_entity_code := replace(p_entity_code, 'EXT_ATTRS');
3544:
3545: x_template_view_name := l_entity_code||p_template_code;
3546:
3547: IF PO_LOG.d_stmt THEN
3548: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);
3549: END IF;
3550:
3551: EXCEPTION

Line 3548: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);

3544:
3545: x_template_view_name := l_entity_code||p_template_code;
3546:
3547: IF PO_LOG.d_stmt THEN
3548: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);
3549: END IF;
3550:
3551: EXCEPTION
3552: WHEN OTHERS THEN

Line 3555: IF PO_LOG.d_stmt THEN

3551: EXCEPTION
3552: WHEN OTHERS THEN
3553: d_progress := 30;
3554: x_return_status := 'U';
3555: IF PO_LOG.d_stmt THEN
3556: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3557: END IF;
3558: END get_template_view_name;
3559:

Line 3556: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3552: WHEN OTHERS THEN
3553: d_progress := 30;
3554: x_return_status := 'U';
3555: IF PO_LOG.d_stmt THEN
3556: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3557: END IF;
3558: END get_template_view_name;
3559:
3560: /*

Line 3634: IF (PO_LOG.d_proc) THEN

3630: WHERE eb.OBJECT_ID = fo.object_id
3631: AND eb.EXT_TABLE_NAME = l_prod_ext_tl_table;
3632:
3633: BEGIN
3634: IF (PO_LOG.d_proc) THEN
3635: PO_LOG.proc_begin(d_module);
3636: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3637: PO_LOG.proc_begin(d_module, 'p_hist_view', p_hist_view);
3638: END IF;

Line 3635: PO_LOG.proc_begin(d_module);

3631: AND eb.EXT_TABLE_NAME = l_prod_ext_tl_table;
3632:
3633: BEGIN
3634: IF (PO_LOG.d_proc) THEN
3635: PO_LOG.proc_begin(d_module);
3636: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3637: PO_LOG.proc_begin(d_module, 'p_hist_view', p_hist_view);
3638: END IF;
3639:

Line 3636: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

3632:
3633: BEGIN
3634: IF (PO_LOG.d_proc) THEN
3635: PO_LOG.proc_begin(d_module);
3636: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3637: PO_LOG.proc_begin(d_module, 'p_hist_view', p_hist_view);
3638: END IF;
3639:
3640: OPEN c_table_name(p_template_id);

Line 3637: PO_LOG.proc_begin(d_module, 'p_hist_view', p_hist_view);

3633: BEGIN
3634: IF (PO_LOG.d_proc) THEN
3635: PO_LOG.proc_begin(d_module);
3636: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
3637: PO_LOG.proc_begin(d_module, 'p_hist_view', p_hist_view);
3638: END IF;
3639:
3640: OPEN c_table_name(p_template_id);
3641: FETCH c_table_name INTO l_entity_code, l_prod_ext_table, l_prod_ext_tl_table;

Line 3654: IF PO_LOG.d_stmt THEN

3650: END IF;
3651:
3652: d_progress := 20;
3653:
3654: IF PO_LOG.d_stmt THEN
3655: PO_LOG.stmt(d_module, d_progress, 'l_entity_code', l_entity_code);
3656: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3657: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3658: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );

Line 3655: PO_LOG.stmt(d_module, d_progress, 'l_entity_code', l_entity_code);

3651:
3652: d_progress := 20;
3653:
3654: IF PO_LOG.d_stmt THEN
3655: PO_LOG.stmt(d_module, d_progress, 'l_entity_code', l_entity_code);
3656: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3657: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3658: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3659: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );

Line 3656: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );

3652: d_progress := 20;
3653:
3654: IF PO_LOG.d_stmt THEN
3655: PO_LOG.stmt(d_module, d_progress, 'l_entity_code', l_entity_code);
3656: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3657: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3658: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3659: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3660: END IF;

Line 3657: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);

3653:
3654: IF PO_LOG.d_stmt THEN
3655: PO_LOG.stmt(d_module, d_progress, 'l_entity_code', l_entity_code);
3656: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3657: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3658: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3659: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3660: END IF;
3661:

Line 3658: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );

3654: IF PO_LOG.d_stmt THEN
3655: PO_LOG.stmt(d_module, d_progress, 'l_entity_code', l_entity_code);
3656: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3657: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3658: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3659: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3660: END IF;
3661:
3662: /*

Line 3659: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );

3655: PO_LOG.stmt(d_module, d_progress, 'l_entity_code', l_entity_code);
3656: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3657: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3658: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3659: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3660: END IF;
3661:
3662: /*
3663: l_attr_appl_name will be the column name of uda attribute in the ext table. The actual column for this will be

Line 3728: IF PO_LOG.d_stmt THEN

3724: END IF;
3725:
3726: d_progress := 30;
3727:
3728: IF PO_LOG.d_stmt THEN
3729: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);
3730: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);
3731: END IF;
3732:

Line 3729: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);

3725:
3726: d_progress := 30;
3727:
3728: IF PO_LOG.d_stmt THEN
3729: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);
3730: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);
3731: END IF;
3732:
3733: EXCEPTION

Line 3730: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);

3726: d_progress := 30;
3727:
3728: IF PO_LOG.d_stmt THEN
3729: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);
3730: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);
3731: END IF;
3732:
3733: EXCEPTION
3734: WHEN OTHERS THEN

Line 3737: IF PO_LOG.d_stmt THEN

3733: EXCEPTION
3734: WHEN OTHERS THEN
3735: d_progress := 40;
3736: x_return_status := 'U';
3737: IF PO_LOG.d_stmt THEN
3738: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3739: END IF;
3740: END get_query_for_temp_view;
3741:

Line 3738: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3734: WHEN OTHERS THEN
3735: d_progress := 40;
3736: x_return_status := 'U';
3737: IF PO_LOG.d_stmt THEN
3738: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3739: END IF;
3740: END get_query_for_temp_view;
3741:
3742: /*

Line 3808: IF (PO_LOG.d_proc) THEN

3804: AND eb.EXT_TABLE_NAME = l_prod_ext_tl_table;
3805:
3806:
3807: BEGIN
3808: IF (PO_LOG.d_proc) THEN
3809: PO_LOG.proc_begin(d_module);
3810: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3811: END IF;
3812:

Line 3809: PO_LOG.proc_begin(d_module);

3805:
3806:
3807: BEGIN
3808: IF (PO_LOG.d_proc) THEN
3809: PO_LOG.proc_begin(d_module);
3810: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3811: END IF;
3812:
3813: OPEN c_table_name(p_entity_code);

Line 3810: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);

3806:
3807: BEGIN
3808: IF (PO_LOG.d_proc) THEN
3809: PO_LOG.proc_begin(d_module);
3810: PO_LOG.proc_begin(d_module, 'p_entity_code', p_entity_code);
3811: END IF;
3812:
3813: OPEN c_table_name(p_entity_code);
3814: FETCH c_table_name INTO l_prod_ext_table, l_prod_ext_tl_table;

Line 3823: IF PO_LOG.d_stmt THEN

3819: CLOSE c_actual_table_name;
3820:
3821: d_progress := 20;
3822:
3823: IF PO_LOG.d_stmt THEN
3824: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3825: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3826: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3827: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );

Line 3824: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );

3820:
3821: d_progress := 20;
3822:
3823: IF PO_LOG.d_stmt THEN
3824: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3825: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3826: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3827: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3828: END IF;

Line 3825: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);

3821: d_progress := 20;
3822:
3823: IF PO_LOG.d_stmt THEN
3824: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3825: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3826: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3827: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3828: END IF;
3829:

Line 3826: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );

3822:
3823: IF PO_LOG.d_stmt THEN
3824: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3825: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3826: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3827: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3828: END IF;
3829:
3830: /*

Line 3827: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );

3823: IF PO_LOG.d_stmt THEN
3824: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_table',l_prod_ext_table );
3825: PO_LOG.stmt(d_module, d_progress, 'l_prod_ext_tl_table', l_prod_ext_tl_table);
3826: PO_LOG.stmt(d_module, d_progress, 'l_prod_table',l_prod_table );
3827: PO_LOG.stmt(d_module, d_progress, 'l_pk_col_name',l_pk_col_name );
3828: END IF;
3829:
3830: /*
3831: l_attr_appl_name will be the column name of uda attribute in the ext table. The actual column for this will be

Line 3890: IF PO_LOG.d_stmt THEN

3886:
3887: END IF;
3888: d_progress := 30;
3889:
3890: IF PO_LOG.d_stmt THEN
3891: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);
3892: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);
3893: END IF;
3894:

Line 3891: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);

3887: END IF;
3888: d_progress := 30;
3889:
3890: IF PO_LOG.d_stmt THEN
3891: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);
3892: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);
3893: END IF;
3894:
3895: EXCEPTION

Line 3892: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);

3888: d_progress := 30;
3889:
3890: IF PO_LOG.d_stmt THEN
3891: PO_LOG.stmt(d_module, d_progress, 'x_select_query', x_select_query);
3892: PO_LOG.stmt(d_module, d_progress, 'x_user_col_name', x_user_col_name);
3893: END IF;
3894:
3895: EXCEPTION
3896: WHEN OTHERS THEN

Line 3899: IF PO_LOG.d_stmt THEN

3895: EXCEPTION
3896: WHEN OTHERS THEN
3897: d_progress := 40;
3898: x_return_status := 'U';
3899: IF PO_LOG.d_stmt THEN
3900: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3901: END IF;
3902:
3903: END get_query_for_entity_view;

Line 3900: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

3896: WHEN OTHERS THEN
3897: d_progress := 40;
3898: x_return_status := 'U';
3899: IF PO_LOG.d_stmt THEN
3900: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
3901: END IF;
3902:
3903: END get_query_for_entity_view;
3904:

Line 3931: IF (PO_LOG.d_proc) THEN

3927: AND Upper(fdfcu.APPLICATION_COLUMN_NAME) = Upper(P_APP_COL_NAME);
3928:
3929: BEGIN
3930:
3931: IF (PO_LOG.d_proc) THEN
3932: PO_LOG.proc_begin(d_module);
3933: PO_LOG.proc_begin(d_module, 'P_APP_COL_NAME', P_APP_COL_NAME);
3934: PO_LOG.proc_begin(d_module, 'P_ATTR_GRP_ID', P_ATTR_GRP_ID);
3935: END IF;

Line 3932: PO_LOG.proc_begin(d_module);

3928:
3929: BEGIN
3930:
3931: IF (PO_LOG.d_proc) THEN
3932: PO_LOG.proc_begin(d_module);
3933: PO_LOG.proc_begin(d_module, 'P_APP_COL_NAME', P_APP_COL_NAME);
3934: PO_LOG.proc_begin(d_module, 'P_ATTR_GRP_ID', P_ATTR_GRP_ID);
3935: END IF;
3936:

Line 3933: PO_LOG.proc_begin(d_module, 'P_APP_COL_NAME', P_APP_COL_NAME);

3929: BEGIN
3930:
3931: IF (PO_LOG.d_proc) THEN
3932: PO_LOG.proc_begin(d_module);
3933: PO_LOG.proc_begin(d_module, 'P_APP_COL_NAME', P_APP_COL_NAME);
3934: PO_LOG.proc_begin(d_module, 'P_ATTR_GRP_ID', P_ATTR_GRP_ID);
3935: END IF;
3936:
3937: OPEN l_attr_disp_col_name;

Line 3934: PO_LOG.proc_begin(d_module, 'P_ATTR_GRP_ID', P_ATTR_GRP_ID);

3930:
3931: IF (PO_LOG.d_proc) THEN
3932: PO_LOG.proc_begin(d_module);
3933: PO_LOG.proc_begin(d_module, 'P_APP_COL_NAME', P_APP_COL_NAME);
3934: PO_LOG.proc_begin(d_module, 'P_ATTR_GRP_ID', P_ATTR_GRP_ID);
3935: END IF;
3936:
3937: OPEN l_attr_disp_col_name;
3938: FETCH l_attr_disp_col_name INTO l_app_col_name, l_col_name, l_attr_grp_internal_name;

Line 3943: IF PO_LOG.d_stmt THEN

3939: close l_attr_disp_col_name;
3940:
3941: d_progress := 20;
3942:
3943: IF PO_LOG.d_stmt THEN
3944: PO_LOG.stmt(d_module, d_progress, 'l_app_col_name', l_app_col_name);
3945: PO_LOG.stmt(d_module, d_progress, 'l_col_name', l_col_name);
3946: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_internal_name', l_attr_grp_internal_name);
3947: END IF;

Line 3944: PO_LOG.stmt(d_module, d_progress, 'l_app_col_name', l_app_col_name);

3940:
3941: d_progress := 20;
3942:
3943: IF PO_LOG.d_stmt THEN
3944: PO_LOG.stmt(d_module, d_progress, 'l_app_col_name', l_app_col_name);
3945: PO_LOG.stmt(d_module, d_progress, 'l_col_name', l_col_name);
3946: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_internal_name', l_attr_grp_internal_name);
3947: END IF;
3948:

Line 3945: PO_LOG.stmt(d_module, d_progress, 'l_col_name', l_col_name);

3941: d_progress := 20;
3942:
3943: IF PO_LOG.d_stmt THEN
3944: PO_LOG.stmt(d_module, d_progress, 'l_app_col_name', l_app_col_name);
3945: PO_LOG.stmt(d_module, d_progress, 'l_col_name', l_col_name);
3946: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_internal_name', l_attr_grp_internal_name);
3947: END IF;
3948:
3949: --l_col_name := substr( l_col_name, 1, 14 );

Line 3946: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_internal_name', l_attr_grp_internal_name);

3942:
3943: IF PO_LOG.d_stmt THEN
3944: PO_LOG.stmt(d_module, d_progress, 'l_app_col_name', l_app_col_name);
3945: PO_LOG.stmt(d_module, d_progress, 'l_col_name', l_col_name);
3946: PO_LOG.stmt(d_module, d_progress, 'l_attr_grp_internal_name', l_attr_grp_internal_name);
3947: END IF;
3948:
3949: --l_col_name := substr( l_col_name, 1, 14 );
3950: --l_attr_grp_internal_name := substr( l_attr_grp_internal_name, 1,14 );

Line 3953: IF PO_LOG.d_stmt THEN

3949: --l_col_name := substr( l_col_name, 1, 14 );
3950: --l_attr_grp_internal_name := substr( l_attr_grp_internal_name, 1,14 );
3951: l_col_name := l_attr_grp_internal_name||g_delimiter|| l_col_name;
3952:
3953: IF PO_LOG.d_stmt THEN
3954: PO_LOG.stmt(d_module, d_progress, 'l_final_col_name', l_col_name);
3955: END IF;
3956:
3957: RETURN l_col_name;

Line 3954: PO_LOG.stmt(d_module, d_progress, 'l_final_col_name', l_col_name);

3950: --l_attr_grp_internal_name := substr( l_attr_grp_internal_name, 1,14 );
3951: l_col_name := l_attr_grp_internal_name||g_delimiter|| l_col_name;
3952:
3953: IF PO_LOG.d_stmt THEN
3954: PO_LOG.stmt(d_module, d_progress, 'l_final_col_name', l_col_name);
3955: END IF;
3956:
3957: RETURN l_col_name;
3958:

Line 3962: IF PO_LOG.d_stmt THEN

3958:
3959: EXCEPTION
3960: WHEN OTHERS THEN
3961: d_progress := 30;
3962: IF PO_LOG.d_stmt THEN
3963: PO_LOG.stmt(d_module, d_progress, 'Exception block');
3964: END IF;
3965:
3966: END ATTR_DISP_COL_NAME;

Line 3963: PO_LOG.stmt(d_module, d_progress, 'Exception block');

3959: EXCEPTION
3960: WHEN OTHERS THEN
3961: d_progress := 30;
3962: IF PO_LOG.d_stmt THEN
3963: PO_LOG.stmt(d_module, d_progress, 'Exception block');
3964: END IF;
3965:
3966: END ATTR_DISP_COL_NAME;
3967:

Line 4133: IF (PO_LOG.d_proc) THEN

4129: WHERE template_id = p_template_id;
4130:
4131: BEGIN
4132:
4133: IF (PO_LOG.d_proc) THEN
4134: PO_LOG.proc_begin(d_module);
4135: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
4136: END IF;
4137:

Line 4134: PO_LOG.proc_begin(d_module);

4130:
4131: BEGIN
4132:
4133: IF (PO_LOG.d_proc) THEN
4134: PO_LOG.proc_begin(d_module);
4135: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
4136: END IF;
4137:
4138: d_progress := 10;

Line 4135: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

4131: BEGIN
4132:
4133: IF (PO_LOG.d_proc) THEN
4134: PO_LOG.proc_begin(d_module);
4135: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
4136: END IF;
4137:
4138: d_progress := 10;
4139:

Line 4166: IF PO_LOG.d_stmt THEN

4162: END IF;
4163:
4164: x_template_view_name := x_template_view_name || l_revision || '_H';
4165: x_return_status := 'S';
4166: IF PO_LOG.d_stmt THEN
4167: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);
4168: END IF;
4169:
4170: EXCEPTION

Line 4167: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);

4163:
4164: x_template_view_name := x_template_view_name || l_revision || '_H';
4165: x_return_status := 'S';
4166: IF PO_LOG.d_stmt THEN
4167: PO_LOG.stmt(d_module, d_progress, 'x_template_view_name', x_template_view_name);
4168: END IF;
4169:
4170: EXCEPTION
4171: WHEN OTHERS THEN

Line 4174: IF PO_LOG.d_stmt THEN

4170: EXCEPTION
4171: WHEN OTHERS THEN
4172: d_progress := 30;
4173: x_return_status := 'U';
4174: IF PO_LOG.d_stmt THEN
4175: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
4176: END IF;
4177:
4178: END get_template_hist_view_name;

Line 4175: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

4171: WHEN OTHERS THEN
4172: d_progress := 30;
4173: x_return_status := 'U';
4174: IF PO_LOG.d_stmt THEN
4175: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
4176: END IF;
4177:
4178: END get_template_hist_view_name;
4179:

Line 4237: IF (PO_LOG.d_proc) THEN

4233: c_value_meaning ref_cursor;
4234:
4235: BEGIN
4236:
4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4240: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4241: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);

Line 4238: PO_LOG.proc_begin(d_module);

4234:
4235: BEGIN
4236:
4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4240: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4241: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4242: END IF;

Line 4239: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);

4235: BEGIN
4236:
4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4240: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4241: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4242: END IF;
4243:

Line 4240: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);

4236:
4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4240: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4241: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4242: END IF;
4243:
4244: --cursor fetches the flex value set id for this usage and column combination

Line 4241: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);

4237: IF (PO_LOG.d_proc) THEN
4238: PO_LOG.proc_begin(d_module);
4239: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4240: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4241: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4242: END IF;
4243:
4244: --cursor fetches the flex value set id for this usage and column combination
4245: OPEN c_get_value_set_id(p_usage_id, p_attr_col);

Line 4251: IF PO_LOG.d_stmt THEN

4247: CLOSE c_get_value_set_id;
4248:
4249: d_progress := 10;
4250:
4251: IF PO_LOG.d_stmt THEN
4252: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );
4253: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);
4254: END IF;
4255:

Line 4252: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );

4248:
4249: d_progress := 10;
4250:
4251: IF PO_LOG.d_stmt THEN
4252: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );
4253: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);
4254: END IF;
4255:
4256: /*If value set is of table type fetch the query, execute it

Line 4253: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);

4249: d_progress := 10;
4250:
4251: IF PO_LOG.d_stmt THEN
4252: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );
4253: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);
4254: END IF;
4255:
4256: /*If value set is of table type fetch the query, execute it
4257: and find the meaning. Else if the value set is of type validation

Line 4284: IF PO_LOG.d_stmt THEN

4280: ' as id_column from ' || l_application_table_name || l_additional_where_clause || ' ) where id_column '
4281: || ' = ' ||'''' || p_attr_value || '''';
4282: END IF;
4283:
4284: IF PO_LOG.d_stmt THEN
4285: PO_LOG.stmt(d_module, d_progress, 'l_query',l_query);
4286: END IF;
4287:
4288: d_progress := 20;

Line 4285: PO_LOG.stmt(d_module, d_progress, 'l_query',l_query);

4281: || ' = ' ||'''' || p_attr_value || '''';
4282: END IF;
4283:
4284: IF PO_LOG.d_stmt THEN
4285: PO_LOG.stmt(d_module, d_progress, 'l_query',l_query);
4286: END IF;
4287:
4288: d_progress := 20;
4289: OPEN c_value_meaning FOR l_query;

Line 4307: IF PO_LOG.d_stmt THEN

4303: END IF;
4304:
4305: x_return_status := 'S';
4306:
4307: IF PO_LOG.d_stmt THEN
4308: PO_LOG.stmt(d_module, d_progress, 'x_attr_meaning', x_attr_meaning);
4309: END IF;
4310:
4311: EXCEPTION

Line 4308: PO_LOG.stmt(d_module, d_progress, 'x_attr_meaning', x_attr_meaning);

4304:
4305: x_return_status := 'S';
4306:
4307: IF PO_LOG.d_stmt THEN
4308: PO_LOG.stmt(d_module, d_progress, 'x_attr_meaning', x_attr_meaning);
4309: END IF;
4310:
4311: EXCEPTION
4312: WHEN OTHERS THEN

Line 4315: IF PO_LOG.d_stmt THEN

4311: EXCEPTION
4312: WHEN OTHERS THEN
4313: d_progress := 50;
4314: x_return_status := 'U';
4315: IF PO_LOG.d_stmt THEN
4316: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
4317: END IF;
4318: END decode_value_set_meaning;
4319:

Line 4316: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);

4312: WHEN OTHERS THEN
4313: d_progress := 50;
4314: x_return_status := 'U';
4315: IF PO_LOG.d_stmt THEN
4316: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
4317: END IF;
4318: END decode_value_set_meaning;
4319:
4320: FUNCTION get_flex_segment_meaning(

Line 4367: IF (PO_LOG.d_proc) THEN

4363: c_value_meaning ref_cursor;
4364:
4365: BEGIN
4366:
4367: IF (PO_LOG.d_proc) THEN
4368: PO_LOG.proc_begin(d_module);
4369: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4370: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4371: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);

Line 4368: PO_LOG.proc_begin(d_module);

4364:
4365: BEGIN
4366:
4367: IF (PO_LOG.d_proc) THEN
4368: PO_LOG.proc_begin(d_module);
4369: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4370: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4371: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4372: END IF;

Line 4369: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);

4365: BEGIN
4366:
4367: IF (PO_LOG.d_proc) THEN
4368: PO_LOG.proc_begin(d_module);
4369: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4370: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4371: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4372: END IF;
4373:

Line 4370: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);

4366:
4367: IF (PO_LOG.d_proc) THEN
4368: PO_LOG.proc_begin(d_module);
4369: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4370: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4371: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4372: END IF;
4373:
4374:

Line 4371: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);

4367: IF (PO_LOG.d_proc) THEN
4368: PO_LOG.proc_begin(d_module);
4369: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4370: PO_LOG.proc_begin(d_module, 'p_attr_col', p_attr_col);
4371: PO_LOG.proc_begin(d_module, 'p_attr_value', p_attr_value);
4372: END IF;
4373:
4374:
4375: IF p_attr_value IS NULL THEN

Line 4385: IF PO_LOG.d_stmt THEN

4381: CLOSE c_get_value_set_id;
4382:
4383: d_progress := 10;
4384:
4385: IF PO_LOG.d_stmt THEN
4386: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );
4387: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);
4388: END IF;
4389:

Line 4386: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );

4382:
4383: d_progress := 10;
4384:
4385: IF PO_LOG.d_stmt THEN
4386: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );
4387: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);
4388: END IF;
4389:
4390: /*If value set is of table type fetch the query, execute it

Line 4387: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);

4383: d_progress := 10;
4384:
4385: IF PO_LOG.d_stmt THEN
4386: PO_LOG.stmt(d_module, d_progress, 'l_value_set_id',l_value_set_id );
4387: PO_LOG.stmt(d_module, d_progress, 'l_validation_type', l_validation_type);
4388: END IF;
4389:
4390: /*If value set is of table type fetch the query, execute it
4391: and find the meaning. Else if the value set is of type validation

Line 4412: IF PO_LOG.d_stmt THEN

4408: ' from ' || l_application_table_name ||' where ' || l_additional_where_clause || ' ) where '
4409: || l_id_column_name || ' = ' ||'''' || p_attr_value || '''';
4410: END IF;
4411:
4412: IF PO_LOG.d_stmt THEN
4413: PO_LOG.stmt(d_module, d_progress, 'l_query',l_query);
4414: END IF;
4415:
4416: d_progress := 20;

Line 4413: PO_LOG.stmt(d_module, d_progress, 'l_query',l_query);

4409: || l_id_column_name || ' = ' ||'''' || p_attr_value || '''';
4410: END IF;
4411:
4412: IF PO_LOG.d_stmt THEN
4413: PO_LOG.stmt(d_module, d_progress, 'l_query',l_query);
4414: END IF;
4415:
4416: d_progress := 20;
4417: OPEN c_value_meaning FOR l_query;

Line 4433: IF PO_LOG.d_stmt THEN

4429: IF l_attr_meaning IS NULL THEN
4430: l_attr_meaning := 'Null' ;
4431: END IF ;
4432:
4433: IF PO_LOG.d_stmt THEN
4434: PO_LOG.stmt(d_module, d_progress, 'l_attr_meaning', l_attr_meaning);
4435: END IF;
4436:
4437: RETURN l_attr_meaning ;

Line 4434: PO_LOG.stmt(d_module, d_progress, 'l_attr_meaning', l_attr_meaning);

4430: l_attr_meaning := 'Null' ;
4431: END IF ;
4432:
4433: IF PO_LOG.d_stmt THEN
4434: PO_LOG.stmt(d_module, d_progress, 'l_attr_meaning', l_attr_meaning);
4435: END IF;
4436:
4437: RETURN l_attr_meaning ;
4438:

Line 4442: IF PO_LOG.d_stmt THEN

4438:
4439: EXCEPTION
4440: WHEN OTHERS THEN
4441: d_progress := 50;
4442: IF PO_LOG.d_stmt THEN
4443: PO_LOG.stmt(d_module, d_progress,SQLERRM );
4444: END IF;
4445: RETURN 'Null' ;
4446:

Line 4443: PO_LOG.stmt(d_module, d_progress,SQLERRM );

4439: EXCEPTION
4440: WHEN OTHERS THEN
4441: d_progress := 50;
4442: IF PO_LOG.d_stmt THEN
4443: PO_LOG.stmt(d_module, d_progress,SQLERRM );
4444: END IF;
4445: RETURN 'Null' ;
4446:
4447:

Line 4483: IF (PO_LOG.d_proc) THEN

4479: AND Nvl(document_style_id, -1) = Nvl(p_document_style_id,-1)
4480: AND document_level = p_document_level);
4481:
4482: BEGIN
4483: IF (PO_LOG.d_proc) THEN
4484: PO_LOG.proc_begin(d_module);
4485: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4486: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4487: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);

Line 4484: PO_LOG.proc_begin(d_module);

4480: AND document_level = p_document_level);
4481:
4482: BEGIN
4483: IF (PO_LOG.d_proc) THEN
4484: PO_LOG.proc_begin(d_module);
4485: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4486: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4487: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4488: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

Line 4485: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);

4481:
4482: BEGIN
4483: IF (PO_LOG.d_proc) THEN
4484: PO_LOG.proc_begin(d_module);
4485: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4486: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4487: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4488: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4489:

Line 4486: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);

4482: BEGIN
4483: IF (PO_LOG.d_proc) THEN
4484: PO_LOG.proc_begin(d_module);
4485: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4486: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4487: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4488: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4489:
4490: END IF;

Line 4487: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);

4483: IF (PO_LOG.d_proc) THEN
4484: PO_LOG.proc_begin(d_module);
4485: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4486: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4487: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4488: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4489:
4490: END IF;
4491:

Line 4488: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

4484: PO_LOG.proc_begin(d_module);
4485: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4486: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4487: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4488: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4489:
4490: END IF;
4491:
4492: g_action_template_id(p_functional_area||p_document_type||p_document_style_id||p_document_level) := NULL;

Line 4507: IF PO_LOG.d_stmt THEN

4503: END IF;
4504: END IF ;
4505:
4506:
4507: IF PO_LOG.d_stmt THEN
4508: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4509: PO_LOG.stmt(d_module, d_progress, 'l_effective_from', l_effective_from);
4510: END IF;
4511:

Line 4508: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);

4504: END IF ;
4505:
4506:
4507: IF PO_LOG.d_stmt THEN
4508: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4509: PO_LOG.stmt(d_module, d_progress, 'l_effective_from', l_effective_from);
4510: END IF;
4511:
4512: IF l_effective_from IS NULL THEN

Line 4509: PO_LOG.stmt(d_module, d_progress, 'l_effective_from', l_effective_from);

4505:
4506:
4507: IF PO_LOG.d_stmt THEN
4508: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4509: PO_LOG.stmt(d_module, d_progress, 'l_effective_from', l_effective_from);
4510: END IF;
4511:
4512: IF l_effective_from IS NULL THEN
4513: l_action_type := 'UPDATE';

Line 4525: IF PO_LOG.d_stmt THEN

4521:
4522: g_action_template_id(p_functional_area||p_document_type||p_document_style_id||p_document_level) := l_template_id;
4523:
4524: d_progress := 20;
4525: IF PO_LOG.d_stmt THEN
4526: PO_LOG.stmt(d_module, d_progress, 'l_action_type', l_action_type);
4527: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4528: END IF;
4529:

Line 4526: PO_LOG.stmt(d_module, d_progress, 'l_action_type', l_action_type);

4522: g_action_template_id(p_functional_area||p_document_type||p_document_style_id||p_document_level) := l_template_id;
4523:
4524: d_progress := 20;
4525: IF PO_LOG.d_stmt THEN
4526: PO_LOG.stmt(d_module, d_progress, 'l_action_type', l_action_type);
4527: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4528: END IF;
4529:
4530: RETURN l_action_type;

Line 4527: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);

4523:
4524: d_progress := 20;
4525: IF PO_LOG.d_stmt THEN
4526: PO_LOG.stmt(d_module, d_progress, 'l_action_type', l_action_type);
4527: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4528: END IF;
4529:
4530: RETURN l_action_type;
4531:

Line 4535: IF PO_LOG.d_stmt THEN

4531:
4532: EXCEPTION
4533: WHEN OTHERS THEN
4534: d_progress := 30;
4535: IF PO_LOG.d_stmt THEN
4536: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4537: END IF;
4538: END get_action_type;
4539:

Line 4536: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

4532: EXCEPTION
4533: WHEN OTHERS THEN
4534: d_progress := 30;
4535: IF PO_LOG.d_stmt THEN
4536: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4537: END IF;
4538: END get_action_type;
4539:
4540: FUNCTION get_view_template_id(p_functional_area VARCHAR2,

Line 4562: IF (PO_LOG.d_proc) THEN

4558: AND document_level = p_document_level
4559: AND (SYSDATE BETWEEN effective_from AND nvl(effective_to,sysdate+1) );
4560:
4561: BEGIN
4562: IF (PO_LOG.d_proc) THEN
4563: PO_LOG.proc_begin(d_module);
4564: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4565: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4566: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);

Line 4563: PO_LOG.proc_begin(d_module);

4559: AND (SYSDATE BETWEEN effective_from AND nvl(effective_to,sysdate+1) );
4560:
4561: BEGIN
4562: IF (PO_LOG.d_proc) THEN
4563: PO_LOG.proc_begin(d_module);
4564: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4565: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4566: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4567: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

Line 4564: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);

4560:
4561: BEGIN
4562: IF (PO_LOG.d_proc) THEN
4563: PO_LOG.proc_begin(d_module);
4564: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4565: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4566: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4567: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4568:

Line 4565: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);

4561: BEGIN
4562: IF (PO_LOG.d_proc) THEN
4563: PO_LOG.proc_begin(d_module);
4564: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4565: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4566: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4567: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4568:
4569: END IF;

Line 4566: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);

4562: IF (PO_LOG.d_proc) THEN
4563: PO_LOG.proc_begin(d_module);
4564: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4565: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4566: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4567: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4568:
4569: END IF;
4570:

Line 4567: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

4563: PO_LOG.proc_begin(d_module);
4564: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4565: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4566: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4567: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4568:
4569: END IF;
4570:
4571: OPEN c_get_template_ids(p_functional_area, p_document_type, p_document_style_id, p_document_level) ;

Line 4580: IF PO_LOG.d_stmt THEN

4576: l_view_template_id := get_action_template_id(p_functional_area, p_document_type, p_document_style_id, p_document_level);
4577: END IF;
4578:
4579: d_progress := 20;
4580: IF PO_LOG.d_stmt THEN
4581: PO_LOG.stmt(d_module, d_progress, 'l_view_template_id', l_view_template_id);
4582: END IF;
4583:
4584: RETURN l_view_template_id;

Line 4581: PO_LOG.stmt(d_module, d_progress, 'l_view_template_id', l_view_template_id);

4577: END IF;
4578:
4579: d_progress := 20;
4580: IF PO_LOG.d_stmt THEN
4581: PO_LOG.stmt(d_module, d_progress, 'l_view_template_id', l_view_template_id);
4582: END IF;
4583:
4584: RETURN l_view_template_id;
4585:

Line 4589: IF PO_LOG.d_stmt THEN

4585:
4586: EXCEPTION
4587: WHEN OTHERS THEN
4588: d_progress := 30;
4589: IF PO_LOG.d_stmt THEN
4590: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4591: END IF;
4592: END get_view_template_id;
4593:

Line 4590: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

4586: EXCEPTION
4587: WHEN OTHERS THEN
4588: d_progress := 30;
4589: IF PO_LOG.d_stmt THEN
4590: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4591: END IF;
4592: END get_view_template_id;
4593:
4594: FUNCTION get_action_template_id(p_functional_area VARCHAR2,

Line 4608: IF (PO_LOG.d_proc) THEN

4604: l_action_type VARCHAR2(50);
4605: l_action_template_id number;
4606:
4607: BEGIN
4608: IF (PO_LOG.d_proc) THEN
4609: PO_LOG.proc_begin(d_module);
4610: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4611: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4612: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);

Line 4609: PO_LOG.proc_begin(d_module);

4605: l_action_template_id number;
4606:
4607: BEGIN
4608: IF (PO_LOG.d_proc) THEN
4609: PO_LOG.proc_begin(d_module);
4610: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4611: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4612: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4613: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

Line 4610: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);

4606:
4607: BEGIN
4608: IF (PO_LOG.d_proc) THEN
4609: PO_LOG.proc_begin(d_module);
4610: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4611: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4612: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4613: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4614: END IF;

Line 4611: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);

4607: BEGIN
4608: IF (PO_LOG.d_proc) THEN
4609: PO_LOG.proc_begin(d_module);
4610: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4611: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4612: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4613: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4614: END IF;
4615:

Line 4612: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);

4608: IF (PO_LOG.d_proc) THEN
4609: PO_LOG.proc_begin(d_module);
4610: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4611: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4612: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4613: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4614: END IF;
4615:
4616: begin

Line 4613: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

4609: PO_LOG.proc_begin(d_module);
4610: PO_LOG.proc_begin(d_module, 'p_functional_area', p_functional_area);
4611: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
4612: PO_LOG.proc_begin(d_module, 'p_document_style_id', p_document_style_id);
4613: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
4614: END IF;
4615:
4616: begin
4617: l_action_template_id := g_action_template_id(p_functional_area||p_document_type||p_document_style_id||p_document_level);

Line 4625: IF PO_LOG.d_stmt THEN

4621: g_action_template_id(p_functional_area||p_document_type||p_document_style_id||p_document_level) := null;
4622: end;
4623:
4624: d_progress := 20;
4625: IF PO_LOG.d_stmt THEN
4626: PO_LOG.stmt(d_module, d_progress, 'l_action_template_id', l_action_template_id);
4627: END IF;
4628:
4629: IF(l_action_template_id is NULL) THEN

Line 4626: PO_LOG.stmt(d_module, d_progress, 'l_action_template_id', l_action_template_id);

4622: end;
4623:
4624: d_progress := 20;
4625: IF PO_LOG.d_stmt THEN
4626: PO_LOG.stmt(d_module, d_progress, 'l_action_template_id', l_action_template_id);
4627: END IF;
4628:
4629: IF(l_action_template_id is NULL) THEN
4630: l_action_type := get_action_type(p_functional_area, p_document_type, p_document_style_id, p_document_level);

Line 4640: IF PO_LOG.d_stmt THEN

4636:
4637: EXCEPTION
4638: WHEN OTHERS THEN
4639: d_progress := 30;
4640: IF PO_LOG.d_stmt THEN
4641: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4642: END IF;
4643:
4644: END get_action_template_id;

Line 4641: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

4637: EXCEPTION
4638: WHEN OTHERS THEN
4639: d_progress := 30;
4640: IF PO_LOG.d_stmt THEN
4641: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4642: END IF;
4643:
4644: END get_action_template_id;
4645:

Line 4688: IF (PO_LOG.d_proc) THEN

4684: AND classification_code = p_template_id
4685: AND attr_group_id = p_attribute_group_id;
4686:
4687: BEGIN
4688: IF (PO_LOG.d_proc) THEN
4689: PO_LOG.proc_begin(d_module);
4690: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4691: END IF;
4692:

Line 4689: PO_LOG.proc_begin(d_module);

4685: AND attr_group_id = p_attribute_group_id;
4686:
4687: BEGIN
4688: IF (PO_LOG.d_proc) THEN
4689: PO_LOG.proc_begin(d_module);
4690: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4691: END IF;
4692:
4693: OPEN c_get_association_id(p_usage_id);

Line 4690: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);

4686:
4687: BEGIN
4688: IF (PO_LOG.d_proc) THEN
4689: PO_LOG.proc_begin(d_module);
4690: PO_LOG.proc_begin(d_module, 'p_usage_id', p_usage_id);
4691: END IF;
4692:
4693: OPEN c_get_association_id(p_usage_id);
4694: FETCH c_get_association_id INTO l_association_id, l_attribute_group_id, l_template_id, l_object_id;

Line 4698: IF PO_LOG.d_stmt THEN

4694: FETCH c_get_association_id INTO l_association_id, l_attribute_group_id, l_template_id, l_object_id;
4695: CLOSE c_get_association_id;
4696:
4697: d_progress := 20;
4698: IF PO_LOG.d_stmt THEN
4699: PO_LOG.stmt(d_module, d_progress, 'l_association_id', l_association_id);
4700: PO_LOG.stmt(d_module, d_progress, 'l_attribute_group_id', l_attribute_group_id);
4701: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4702: PO_LOG.stmt(d_module, d_progress, 'l_object_id', l_object_id);

Line 4699: PO_LOG.stmt(d_module, d_progress, 'l_association_id', l_association_id);

4695: CLOSE c_get_association_id;
4696:
4697: d_progress := 20;
4698: IF PO_LOG.d_stmt THEN
4699: PO_LOG.stmt(d_module, d_progress, 'l_association_id', l_association_id);
4700: PO_LOG.stmt(d_module, d_progress, 'l_attribute_group_id', l_attribute_group_id);
4701: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4702: PO_LOG.stmt(d_module, d_progress, 'l_object_id', l_object_id);
4703: END IF;

Line 4700: PO_LOG.stmt(d_module, d_progress, 'l_attribute_group_id', l_attribute_group_id);

4696:
4697: d_progress := 20;
4698: IF PO_LOG.d_stmt THEN
4699: PO_LOG.stmt(d_module, d_progress, 'l_association_id', l_association_id);
4700: PO_LOG.stmt(d_module, d_progress, 'l_attribute_group_id', l_attribute_group_id);
4701: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4702: PO_LOG.stmt(d_module, d_progress, 'l_object_id', l_object_id);
4703: END IF;
4704:

Line 4701: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);

4697: d_progress := 20;
4698: IF PO_LOG.d_stmt THEN
4699: PO_LOG.stmt(d_module, d_progress, 'l_association_id', l_association_id);
4700: PO_LOG.stmt(d_module, d_progress, 'l_attribute_group_id', l_attribute_group_id);
4701: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4702: PO_LOG.stmt(d_module, d_progress, 'l_object_id', l_object_id);
4703: END IF;
4704:
4705:

Line 4702: PO_LOG.stmt(d_module, d_progress, 'l_object_id', l_object_id);

4698: IF PO_LOG.d_stmt THEN
4699: PO_LOG.stmt(d_module, d_progress, 'l_association_id', l_association_id);
4700: PO_LOG.stmt(d_module, d_progress, 'l_attribute_group_id', l_attribute_group_id);
4701: PO_LOG.stmt(d_module, d_progress, 'l_template_id', l_template_id);
4702: PO_LOG.stmt(d_module, d_progress, 'l_object_id', l_object_id);
4703: END IF;
4704:
4705:
4706: -- Check if any other usage shares the same attr group information.If so , association and actions are not deleted.

Line 4736: IF PO_LOG.d_stmt THEN

4732:
4733: FOR c_get_action_id_rec IN c_get_action_id(l_object_id, l_template_id, l_attribute_group_id) LOOP
4734: d_progress := 30;
4735:
4736: IF PO_LOG.d_stmt THEN
4737: PO_LOG.stmt(d_module, d_progress, 'Delete Association succesful. x_return_status: ', x_return_status);
4738: PO_LOG.stmt(d_module, d_progress, 'action_id', c_get_action_id_rec.action_id);
4739: PO_LOG.stmt(d_module, d_progress, 'function_id', c_get_action_id_rec.function_id);
4740: END IF;

Line 4737: PO_LOG.stmt(d_module, d_progress, 'Delete Association succesful. x_return_status: ', x_return_status);

4733: FOR c_get_action_id_rec IN c_get_action_id(l_object_id, l_template_id, l_attribute_group_id) LOOP
4734: d_progress := 30;
4735:
4736: IF PO_LOG.d_stmt THEN
4737: PO_LOG.stmt(d_module, d_progress, 'Delete Association succesful. x_return_status: ', x_return_status);
4738: PO_LOG.stmt(d_module, d_progress, 'action_id', c_get_action_id_rec.action_id);
4739: PO_LOG.stmt(d_module, d_progress, 'function_id', c_get_action_id_rec.function_id);
4740: END IF;
4741:

Line 4738: PO_LOG.stmt(d_module, d_progress, 'action_id', c_get_action_id_rec.action_id);

4734: d_progress := 30;
4735:
4736: IF PO_LOG.d_stmt THEN
4737: PO_LOG.stmt(d_module, d_progress, 'Delete Association succesful. x_return_status: ', x_return_status);
4738: PO_LOG.stmt(d_module, d_progress, 'action_id', c_get_action_id_rec.action_id);
4739: PO_LOG.stmt(d_module, d_progress, 'function_id', c_get_action_id_rec.function_id);
4740: END IF;
4741:
4742: ego_ext_fwk_pub.Delete_Action (

Line 4739: PO_LOG.stmt(d_module, d_progress, 'function_id', c_get_action_id_rec.function_id);

4735:
4736: IF PO_LOG.d_stmt THEN
4737: PO_LOG.stmt(d_module, d_progress, 'Delete Association succesful. x_return_status: ', x_return_status);
4738: PO_LOG.stmt(d_module, d_progress, 'action_id', c_get_action_id_rec.action_id);
4739: PO_LOG.stmt(d_module, d_progress, 'function_id', c_get_action_id_rec.function_id);
4740: END IF;
4741:
4742: ego_ext_fwk_pub.Delete_Action (
4743: p_api_version => 1.0

Line 4755: IF PO_LOG.d_stmt THEN

4751:
4752: IF (l_return_status = 'S' ) THEN
4753:
4754: d_progress := 40;
4755: IF PO_LOG.d_stmt THEN
4756: PO_LOG.stmt(d_module, d_progress, 'Delete Action successful. x_return_status: ', x_return_status);
4757: END IF;
4758:
4759: ego_ext_fwk_pub.Delete_Action_Display (

Line 4756: PO_LOG.stmt(d_module, d_progress, 'Delete Action successful. x_return_status: ', x_return_status);

4752: IF (l_return_status = 'S' ) THEN
4753:
4754: d_progress := 40;
4755: IF PO_LOG.d_stmt THEN
4756: PO_LOG.stmt(d_module, d_progress, 'Delete Action successful. x_return_status: ', x_return_status);
4757: END IF;
4758:
4759: ego_ext_fwk_pub.Delete_Action_Display (
4760: p_api_version => 1.0

Line 4772: IF PO_LOG.d_stmt THEN

4768:
4769: IF (l_return_status = 'S' ) THEN
4770:
4771: d_progress := 50;
4772: IF PO_LOG.d_stmt THEN
4773: PO_LOG.stmt(d_module, d_progress, 'Delete_Action_Display successful. x_return_status: ', x_return_status);
4774: END IF;
4775:
4776: ego_ext_fwk_pub.Delete_Func_Mapping (

Line 4773: PO_LOG.stmt(d_module, d_progress, 'Delete_Action_Display successful. x_return_status: ', x_return_status);

4769: IF (l_return_status = 'S' ) THEN
4770:
4771: d_progress := 50;
4772: IF PO_LOG.d_stmt THEN
4773: PO_LOG.stmt(d_module, d_progress, 'Delete_Action_Display successful. x_return_status: ', x_return_status);
4774: END IF;
4775:
4776: ego_ext_fwk_pub.Delete_Func_Mapping (
4777: p_api_version => 1.0

Line 4798: IF PO_LOG.d_stmt THEN

4794: END IF;
4795:
4796: IF l_return_status <> 'S' THEN
4797: ROLLBACK;
4798: IF PO_LOG.d_stmt THEN
4799: PO_LOG.stmt(d_module, d_progress, 'Delete failed. Rollback happened. x_return_status: ', x_return_status);
4800: END IF;
4801: END IF;
4802:

Line 4799: PO_LOG.stmt(d_module, d_progress, 'Delete failed. Rollback happened. x_return_status: ', x_return_status);

4795:
4796: IF l_return_status <> 'S' THEN
4797: ROLLBACK;
4798: IF PO_LOG.d_stmt THEN
4799: PO_LOG.stmt(d_module, d_progress, 'Delete failed. Rollback happened. x_return_status: ', x_return_status);
4800: END IF;
4801: END IF;
4802:
4803: x_return_status := l_return_status;

Line 4809: IF PO_LOG.d_stmt THEN

4805: EXCEPTION
4806: WHEN OTHERS THEN
4807: d_progress := 60;
4808: x_return_status := 'U';
4809: IF PO_LOG.d_stmt THEN
4810: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4811: END IF;
4812: END DELETE_USAGE;
4813:

Line 4810: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

4806: WHEN OTHERS THEN
4807: d_progress := 60;
4808: x_return_status := 'U';
4809: IF PO_LOG.d_stmt THEN
4810: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
4811: END IF;
4812: END DELETE_USAGE;
4813:
4814: PROCEDURE copy_uda_temp_usages(p_api_version IN NUMBER,

Line 4864: IF (PO_LOG.d_proc) THEN

4860: SELECT PO_UDA_AG_TEMPLATE_USAGES_S.NEXTVAL
4861: FROM dual;
4862:
4863: BEGIN
4864: IF (PO_LOG.d_proc) THEN
4865: PO_LOG.proc_begin(d_module);
4866: PO_LOG.proc_begin(d_module, 'p_new_template_id', p_new_template_id);
4867: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
4868: END IF;

Line 4865: PO_LOG.proc_begin(d_module);

4861: FROM dual;
4862:
4863: BEGIN
4864: IF (PO_LOG.d_proc) THEN
4865: PO_LOG.proc_begin(d_module);
4866: PO_LOG.proc_begin(d_module, 'p_new_template_id', p_new_template_id);
4867: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
4868: END IF;
4869:

Line 4866: PO_LOG.proc_begin(d_module, 'p_new_template_id', p_new_template_id);

4862:
4863: BEGIN
4864: IF (PO_LOG.d_proc) THEN
4865: PO_LOG.proc_begin(d_module);
4866: PO_LOG.proc_begin(d_module, 'p_new_template_id', p_new_template_id);
4867: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
4868: END IF;
4869:
4870: l_user_id := Fnd_Global.user_id;

Line 4867: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);

4863: BEGIN
4864: IF (PO_LOG.d_proc) THEN
4865: PO_LOG.proc_begin(d_module);
4866: PO_LOG.proc_begin(d_module, 'p_new_template_id', p_new_template_id);
4867: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
4868: END IF;
4869:
4870: l_user_id := Fnd_Global.user_id;
4871: l_login_id := Fnd_Global.login_id;

Line 5007: IF PO_LOG.d_stmt THEN

5003: EXCEPTION
5004: WHEN OTHERS THEN
5005: d_progress := 60;
5006: x_return_status := 'U';
5007: IF PO_LOG.d_stmt THEN
5008: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5009: END IF;
5010:
5011: END copy_uda_temp_usages;

Line 5008: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

5004: WHEN OTHERS THEN
5005: d_progress := 60;
5006: x_return_status := 'U';
5007: IF PO_LOG.d_stmt THEN
5008: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5009: END IF;
5010:
5011: END copy_uda_temp_usages;
5012:

Line 5068: IF (PO_LOG.d_proc) THEN

5064: FROM dual;
5065:
5066:
5067: BEGIN
5068: IF (PO_LOG.d_proc) THEN
5069: PO_LOG.proc_begin(d_module);
5070: PO_LOG.proc_begin(d_module, 'p_dest_template_id', p_dest_template_id);
5071: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5072: END IF;

Line 5069: PO_LOG.proc_begin(d_module);

5065:
5066:
5067: BEGIN
5068: IF (PO_LOG.d_proc) THEN
5069: PO_LOG.proc_begin(d_module);
5070: PO_LOG.proc_begin(d_module, 'p_dest_template_id', p_dest_template_id);
5071: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5072: END IF;
5073:

Line 5070: PO_LOG.proc_begin(d_module, 'p_dest_template_id', p_dest_template_id);

5066:
5067: BEGIN
5068: IF (PO_LOG.d_proc) THEN
5069: PO_LOG.proc_begin(d_module);
5070: PO_LOG.proc_begin(d_module, 'p_dest_template_id', p_dest_template_id);
5071: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5072: END IF;
5073:
5074: l_user_id := Fnd_Global.user_id;

Line 5071: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);

5067: BEGIN
5068: IF (PO_LOG.d_proc) THEN
5069: PO_LOG.proc_begin(d_module);
5070: PO_LOG.proc_begin(d_module, 'p_dest_template_id', p_dest_template_id);
5071: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5072: END IF;
5073:
5074: l_user_id := Fnd_Global.user_id;
5075: l_login_id := Fnd_Global.login_id;

Line 5089: IF (PO_LOG.d_exc) THEN

5085: WHERE template_id = p_dest_template_id
5086: AND ATTRIBUTE_CATEGORY = p_usage_name ;
5087: EXCEPTION
5088: WHEN No_Data_Found THEN
5089: IF (PO_LOG.d_exc) THEN
5090: PO_LOG.exc(d_module, d_progress, 'No Sequence number found' );
5091: PO_LOG.proc_end(d_module);
5092: END IF;
5093:

Line 5090: PO_LOG.exc(d_module, d_progress, 'No Sequence number found' );

5086: AND ATTRIBUTE_CATEGORY = p_usage_name ;
5087: EXCEPTION
5088: WHEN No_Data_Found THEN
5089: IF (PO_LOG.d_exc) THEN
5090: PO_LOG.exc(d_module, d_progress, 'No Sequence number found' );
5091: PO_LOG.proc_end(d_module);
5092: END IF;
5093:
5094: END;

Line 5091: PO_LOG.proc_end(d_module);

5087: EXCEPTION
5088: WHEN No_Data_Found THEN
5089: IF (PO_LOG.d_exc) THEN
5090: PO_LOG.exc(d_module, d_progress, 'No Sequence number found' );
5091: PO_LOG.proc_end(d_module);
5092: END IF;
5093:
5094: END;
5095:

Line 5242: IF PO_LOG.d_stmt THEN

5238: EXCEPTION
5239: WHEN OTHERS THEN
5240: d_progress := 60;
5241: x_return_status := 'U';
5242: IF PO_LOG.d_stmt THEN
5243: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5244: END IF;
5245:
5246: END copy_uda_temp_single_usage;

Line 5243: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

5239: WHEN OTHERS THEN
5240: d_progress := 60;
5241: x_return_status := 'U';
5242: IF PO_LOG.d_stmt THEN
5243: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5244: END IF;
5245:
5246: END copy_uda_temp_single_usage;
5247:

Line 5283: IF (PO_LOG.d_proc) THEN

5279: CURSOR c_gen_template_seq IS
5280: SELECT PO_UDA_AG_TEMPLATES_S.NEXTVAL FROM dual;
5281:
5282: BEGIN
5283: IF (PO_LOG.d_proc) THEN
5284: PO_LOG.proc_begin(d_module);
5285: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5286: END IF;
5287:

Line 5284: PO_LOG.proc_begin(d_module);

5280: SELECT PO_UDA_AG_TEMPLATES_S.NEXTVAL FROM dual;
5281:
5282: BEGIN
5283: IF (PO_LOG.d_proc) THEN
5284: PO_LOG.proc_begin(d_module);
5285: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5286: END IF;
5287:
5288: l_user_id := Fnd_Global.user_id;

Line 5285: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);

5281:
5282: BEGIN
5283: IF (PO_LOG.d_proc) THEN
5284: PO_LOG.proc_begin(d_module);
5285: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5286: END IF;
5287:
5288: l_user_id := Fnd_Global.user_id;
5289: l_login_id := Fnd_Global.login_id;

Line 5353: IF PO_LOG.d_stmt THEN

5349: EXCEPTION
5350: WHEN OTHERS THEN
5351: d_progress := 60;
5352: x_return_status := 'U';
5353: IF PO_LOG.d_stmt THEN
5354: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5355: END IF;
5356: END copy_uda_temp_header;
5357:

Line 5354: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

5350: WHEN OTHERS THEN
5351: d_progress := 60;
5352: x_return_status := 'U';
5353: IF PO_LOG.d_stmt THEN
5354: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5355: END IF;
5356: END copy_uda_temp_header;
5357:
5358: PROCEDURE validate_usages(p_api_version IN NUMBER,

Line 5401: IF (PO_LOG.d_proc) THEN

5397: '.'||attribute9||'.'|| attribute10||'.'||attribute11||'.'|| attribute12||'.'||attribute13||'.'|| attribute14||'.'||attribute15||'.'|| attribute16||
5398: '.'||attribute17||'.'|| attribute18||'.'||attribute19 ||'.'||attribute20 ||'.' = p_concatenated_segments;
5399:
5400: BEGIN
5401: IF (PO_LOG.d_proc) THEN
5402: PO_LOG.proc_begin(d_module);
5403: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5404: PO_LOG.proc_begin(d_module, 'p_attribute_category', p_attribute_category);
5405: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);

Line 5402: PO_LOG.proc_begin(d_module);

5398: '.'||attribute17||'.'|| attribute18||'.'||attribute19 ||'.'||attribute20 ||'.' = p_concatenated_segments;
5399:
5400: BEGIN
5401: IF (PO_LOG.d_proc) THEN
5402: PO_LOG.proc_begin(d_module);
5403: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5404: PO_LOG.proc_begin(d_module, 'p_attribute_category', p_attribute_category);
5405: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
5406: PO_LOG.proc_begin(d_module, 'p_sequence', p_sequence);

Line 5403: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

5399:
5400: BEGIN
5401: IF (PO_LOG.d_proc) THEN
5402: PO_LOG.proc_begin(d_module);
5403: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5404: PO_LOG.proc_begin(d_module, 'p_attribute_category', p_attribute_category);
5405: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
5406: PO_LOG.proc_begin(d_module, 'p_sequence', p_sequence);
5407: END IF;

Line 5404: PO_LOG.proc_begin(d_module, 'p_attribute_category', p_attribute_category);

5400: BEGIN
5401: IF (PO_LOG.d_proc) THEN
5402: PO_LOG.proc_begin(d_module);
5403: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5404: PO_LOG.proc_begin(d_module, 'p_attribute_category', p_attribute_category);
5405: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
5406: PO_LOG.proc_begin(d_module, 'p_sequence', p_sequence);
5407: END IF;
5408:

Line 5405: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);

5401: IF (PO_LOG.d_proc) THEN
5402: PO_LOG.proc_begin(d_module);
5403: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5404: PO_LOG.proc_begin(d_module, 'p_attribute_category', p_attribute_category);
5405: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
5406: PO_LOG.proc_begin(d_module, 'p_sequence', p_sequence);
5407: END IF;
5408:
5409: OPEN c_get_usage_ctx_ag_unique(p_template_id, p_attribute_category, p_attribute_group_id, p_concatenated_segments);

Line 5406: PO_LOG.proc_begin(d_module, 'p_sequence', p_sequence);

5402: PO_LOG.proc_begin(d_module);
5403: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5404: PO_LOG.proc_begin(d_module, 'p_attribute_category', p_attribute_category);
5405: PO_LOG.proc_begin(d_module, 'p_attribute_group_id', p_attribute_group_id);
5406: PO_LOG.proc_begin(d_module, 'p_sequence', p_sequence);
5407: END IF;
5408:
5409: OPEN c_get_usage_ctx_ag_unique(p_template_id, p_attribute_category, p_attribute_group_id, p_concatenated_segments);
5410: FETCH c_get_usage_ctx_ag_unique into l_uctxag_yn;

Line 5424: IF PO_LOG.d_stmt THEN

5420: EXCEPTION
5421: WHEN OTHERS THEN
5422: d_progress := 60;
5423: x_return_status := 'U';
5424: IF PO_LOG.d_stmt THEN
5425: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5426: END IF;
5427:
5428: END validate_usages;

Line 5425: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

5421: WHEN OTHERS THEN
5422: d_progress := 60;
5423: x_return_status := 'U';
5424: IF PO_LOG.d_stmt THEN
5425: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5426: END IF;
5427:
5428: END validate_usages;
5429:

Line 5534: IF (PO_LOG.d_proc) THEN

5530: AND attribute_category NOT IN (p_attribute_category1,p_attribute_category2,p_attribute_category3))
5531: GROUP BY attribute_category,attribute_group_id,context ;
5532:
5533: BEGIN
5534: IF (PO_LOG.d_proc) THEN
5535: PO_LOG.proc_begin(d_module);
5536: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5537: END IF ;
5538:

Line 5535: PO_LOG.proc_begin(d_module);

5531: GROUP BY attribute_category,attribute_group_id,context ;
5532:
5533: BEGIN
5534: IF (PO_LOG.d_proc) THEN
5535: PO_LOG.proc_begin(d_module);
5536: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5537: END IF ;
5538:
5539: x_msg_count := 0 ;

Line 5536: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);

5532:
5533: BEGIN
5534: IF (PO_LOG.d_proc) THEN
5535: PO_LOG.proc_begin(d_module);
5536: PO_LOG.proc_begin(d_module, 'p_template_id', p_template_id);
5537: END IF ;
5538:
5539: x_msg_count := 0 ;
5540: x_return_status := 'S' ;

Line 5599: IF PO_LOG.d_stmt THEN

5595: fnd_msg_pub.ADD;
5596: x_msg_count := x_msg_count +1 ;
5597: x_return_status := 'E' ;
5598: EXCEPTION WHEN No_Data_Found THEN
5599: IF PO_LOG.d_stmt THEN
5600: PO_LOG.stmt(d_module, d_progress, 'no data found ');
5601: END IF;
5602: END ;
5603:

Line 5600: PO_LOG.stmt(d_module, d_progress, 'no data found ');

5596: x_msg_count := x_msg_count +1 ;
5597: x_return_status := 'E' ;
5598: EXCEPTION WHEN No_Data_Found THEN
5599: IF PO_LOG.d_stmt THEN
5600: PO_LOG.stmt(d_module, d_progress, 'no data found ');
5601: END IF;
5602: END ;
5603:
5604: END IF ;

Line 5634: IF PO_LOG.d_stmt THEN

5630: x_msg_count := x_msg_count +1 ;
5631: x_return_status := 'E' ;
5632:
5633: EXCEPTION WHEN No_Data_Found THEN
5634: IF PO_LOG.d_stmt THEN
5635: PO_LOG.stmt(d_module, d_progress, 'no data found ');
5636: END IF;
5637: END ;
5638: END IF ;

Line 5635: PO_LOG.stmt(d_module, d_progress, 'no data found ');

5631: x_return_status := 'E' ;
5632:
5633: EXCEPTION WHEN No_Data_Found THEN
5634: IF PO_LOG.d_stmt THEN
5635: PO_LOG.stmt(d_module, d_progress, 'no data found ');
5636: END IF;
5637: END ;
5638: END IF ;
5639:

Line 5645: IF PO_LOG.d_stmt THEN

5641:
5642: EXCEPTION
5643: WHEN OTHERS THEN
5644: x_return_status := 'U';
5645: IF PO_LOG.d_stmt THEN
5646: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5647: END IF;
5648:
5649: END validate_template;

Line 5646: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');

5642: EXCEPTION
5643: WHEN OTHERS THEN
5644: x_return_status := 'U';
5645: IF PO_LOG.d_stmt THEN
5646: PO_LOG.stmt(d_module, d_progress, 'entered Exception block ');
5647: END IF;
5648:
5649: END validate_template;
5650:

Line 5685: IF (PO_LOG.d_proc) THEN

5681:
5682:
5683: BEGIN
5684:
5685: IF (PO_LOG.d_proc) THEN
5686: PO_LOG.proc_begin(d_module);
5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);

Line 5686: PO_LOG.proc_begin(d_module);

5682:
5683: BEGIN
5684:
5685: IF (PO_LOG.d_proc) THEN
5686: PO_LOG.proc_begin(d_module);
5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);
5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);

Line 5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);

5683: BEGIN
5684:
5685: IF (PO_LOG.d_proc) THEN
5686: PO_LOG.proc_begin(d_module);
5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);
5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);
5691: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);

Line 5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);

5684:
5685: IF (PO_LOG.d_proc) THEN
5686: PO_LOG.proc_begin(d_module);
5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);
5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);
5691: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
5692: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);

Line 5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);

5685: IF (PO_LOG.d_proc) THEN
5686: PO_LOG.proc_begin(d_module);
5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);
5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);
5691: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
5692: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
5693: END IF;

Line 5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);

5686: PO_LOG.proc_begin(d_module);
5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);
5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);
5691: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
5692: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
5693: END IF;
5694:

Line 5691: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);

5687: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);
5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);
5691: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
5692: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
5693: END IF;
5694:
5695: --Create association for the real attribute..no chnage in parameters

Line 5692: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);

5688: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5689: PO_LOG.proc_begin(d_module, 'p_object_id', p_object_id);
5690: PO_LOG.proc_begin(d_module, 'p_classification_code', p_classification_code);
5691: PO_LOG.proc_begin(d_module, 'p_data_level', p_data_level);
5692: PO_LOG.proc_begin(d_module, 'p_attr_group_id', p_attr_group_id);
5693: END IF;
5694:
5695: --Create association for the real attribute..no chnage in parameters
5696:

Line 5782: IF PO_LOG.d_stmt THEN

5778:
5779: EXCEPTION
5780: WHEN OTHERS THEN
5781: x_return_status := 'U';
5782: IF PO_LOG.d_stmt THEN
5783: PO_LOG.stmt(d_module, d_progress, 'Entered Exception block ');
5784: END IF;
5785:
5786: END Create_Association;

Line 5783: PO_LOG.stmt(d_module, d_progress, 'Entered Exception block ');

5779: EXCEPTION
5780: WHEN OTHERS THEN
5781: x_return_status := 'U';
5782: IF PO_LOG.d_stmt THEN
5783: PO_LOG.stmt(d_module, d_progress, 'Entered Exception block ');
5784: END IF;
5785:
5786: END Create_Association;
5787:

Line 5815: IF (PO_LOG.d_proc) THEN

5811: l_real_data_level varchar2(100);
5812:
5813: BEGIN
5814:
5815: IF (PO_LOG.d_proc) THEN
5816: PO_LOG.proc_begin(d_module);
5817: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5818: END IF ;
5819:

Line 5816: PO_LOG.proc_begin(d_module);

5812:
5813: BEGIN
5814:
5815: IF (PO_LOG.d_proc) THEN
5816: PO_LOG.proc_begin(d_module);
5817: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5818: END IF ;
5819:
5820: --Get the real attribute group id

Line 5817: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);

5813: BEGIN
5814:
5815: IF (PO_LOG.d_proc) THEN
5816: PO_LOG.proc_begin(d_module);
5817: PO_LOG.proc_begin(d_module, 'p_association_id', p_association_id);
5818: END IF ;
5819:
5820: --Get the real attribute group id
5821: SELECT attr_group_id,classification_code

Line 5892: IF (PO_LOG.d_exc) THEN

5888: x_errorcode => x_errorcode, -- OUT NOCOPY NUMBER
5889: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
5890: x_msg_data => x_msg_data); -- OUT NOCOPY VARCHAR2
5891:
5892: IF (PO_LOG.d_exc) THEN
5893: PO_LOG.exc(d_module, d_progress, x_return_status );
5894: PO_LOG.proc_end(d_module);
5895: END IF;
5896:

Line 5893: PO_LOG.exc(d_module, d_progress, x_return_status );

5889: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
5890: x_msg_data => x_msg_data); -- OUT NOCOPY VARCHAR2
5891:
5892: IF (PO_LOG.d_exc) THEN
5893: PO_LOG.exc(d_module, d_progress, x_return_status );
5894: PO_LOG.proc_end(d_module);
5895: END IF;
5896:
5897: EXCEPTION

Line 5894: PO_LOG.proc_end(d_module);

5890: x_msg_data => x_msg_data); -- OUT NOCOPY VARCHAR2
5891:
5892: IF (PO_LOG.d_exc) THEN
5893: PO_LOG.exc(d_module, d_progress, x_return_status );
5894: PO_LOG.proc_end(d_module);
5895: END IF;
5896:
5897: EXCEPTION
5898: WHEN OTHERS THEN

Line 5900: IF PO_LOG.d_stmt THEN

5896:
5897: EXCEPTION
5898: WHEN OTHERS THEN
5899: x_return_status := 'U';
5900: IF PO_LOG.d_stmt THEN
5901: PO_LOG.stmt(d_module, d_progress, 'Entered Exception block ');
5902: END IF;
5903: END Delete_Association;
5904:

Line 5901: PO_LOG.stmt(d_module, d_progress, 'Entered Exception block ');

5897: EXCEPTION
5898: WHEN OTHERS THEN
5899: x_return_status := 'U';
5900: IF PO_LOG.d_stmt THEN
5901: PO_LOG.stmt(d_module, d_progress, 'Entered Exception block ');
5902: END IF;
5903: END Delete_Association;
5904:
5905: