DBA Data[Home] [Help]

APPS.OPI_DBI_BOUNDS_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 1375: BIS_COLLECTION_UTILITIES.PUT_LINE(p_pkg_name ||'.'|| p_proc_name||': At statement '

1371: commit;
1372: */
1373: -- This API may be used to print other messages in addition to debug messages.Hence, the check is not done here.
1374: -- IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
1375: BIS_COLLECTION_UTILITIES.PUT_LINE(p_pkg_name ||'.'|| p_proc_name||': At statement '
1376: || p_stmt_no ||'#, '||p_debug_msg);
1377: -- END IF;
1378: END write;
1379:

Line 1416: bis_collection_utilities.put_line('Enter print_opi_org_bounds() '||

1412: AND log.load_type = p_load_type;
1413:
1414: BEGIN
1415:
1416: bis_collection_utilities.put_line('Enter print_opi_org_bounds() '||
1417: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1418:
1419: -- initialization block
1420: l_stmt_id := 0;

Line 1425: bis_collection_utilities.put_line (

1421:
1422: -- print the header
1423: l_stmt_id := 10;
1424:
1425: bis_collection_utilities.put_line (
1426: RPAD ('Organization Code', 20) ||
1427: RPAD ('Last Collected Txn Id', 25) ||
1428: RPAD ('Data Collected Until', 25) ||
1429: RPAD ('Reason Stopped', 20));

Line 1431: bis_collection_utilities.put_line (

1427: RPAD ('Last Collected Txn Id', 25) ||
1428: RPAD ('Data Collected Until', 25) ||
1429: RPAD ('Reason Stopped', 20));
1430:
1431: bis_collection_utilities.put_line (
1432: RPAD ('-----------------', 20) ||
1433: RPAD ('---------------------', 25) ||
1434: RPAD ('--------------------', 25) ||
1435: RPAD ('--------------', 20));

Line 1440: bis_collection_utilities.put_line (

1436: -- just print all the bounds
1437: l_stmt_id := 20;
1438: FOR opi_org_bounds_rec IN opi_org_bounds_csr
1439: LOOP
1440: bis_collection_utilities.put_line (
1441: RPAD (opi_org_bounds_rec.organization_code, 20) ||
1442: RPAD (opi_org_bounds_rec.to_bound_id, 25) ||
1443: RPAD (opi_org_bounds_rec.data_until, 25) ||
1444: RPAD (opi_org_bounds_rec.stop_reason, 20));

Line 1453: bis_collection_utilities.put_line(LPAD ('', 90, '-'));

1449: -- print table end
1450: l_stmt_id := 30;
1451:
1452:
1453: bis_collection_utilities.put_line(LPAD ('', 90, '-'));
1454:
1455: RETURN;
1456:
1457: bis_collection_utilities.put_line('Exit print_opi_org_bounds() '||

Line 1457: bis_collection_utilities.put_line('Exit print_opi_org_bounds() '||

1453: bis_collection_utilities.put_line(LPAD ('', 90, '-'));
1454:
1455: RETURN;
1456:
1457: bis_collection_utilities.put_line('Exit print_opi_org_bounds() '||
1458: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1459:
1460: EXCEPTION
1461:

Line 1466: bis_collection_utilities.put_line ('Error when printing org bounds.');

1462: WHEN OTHERS THEN
1463: --{
1464: rollback;
1465:
1466: bis_collection_utilities.put_line ('Error when printing org bounds.');
1467:
1468: RAISE; -- propagate exception to wrapper
1469: --}
1470:

Line 1500: bis_collection_utilities.put_line('Enter bounds_uncosted() '||

1496: l_warning NUMBER;
1497:
1498: BEGIN
1499:
1500: bis_collection_utilities.put_line('Enter bounds_uncosted() '||
1501: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1502:
1503: -- initialization block
1504: l_stmt_id := 0;

Line 1533: bis_collection_utilities.put_line('Exit bounds_uncosted() '||

1529: END IF;
1530:
1531: RETURN l_bounds_uncosted;
1532:
1533: bis_collection_utilities.put_line('Exit bounds_uncosted() '||
1534: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1535:
1536: END bounds_uncosted;
1537: