APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on FND_FILE

Line 1498: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);

1494: --NVL(sd.project_number,'-99') = nvl(p_project_id, NVL(sd.project_number, '-99')) and
1495: --NVL(sd.task_number, '-99') = nvl(p_task_id, NVL(sd.task_number, '-99'));
1496:
1497: l_row := SQL%ROWCOUNT;
1498: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
1499:
1500: ELSIF p_overwrite = 2 THEN
1501: delete from msc_sup_dem_entries sd
1502: where sd.publisher_order_type = 3 and

Line 1541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);

1537: --NVL(sd.task_number, '-99') = nvl(p_task_id, NVL(sd.task_number, '-99')) and
1538: sd.ship_date between NVL(p_horizon_start, sd.ship_date) and NVL(p_horizon_end, sd.ship_date);
1539:
1540: l_row := SQL%ROWCOUNT;
1541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
1542: END IF;
1543:
1544: EXCEPTION
1545: WHEN OTHERS THEN

Line 1555: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);

1551: p_string IN VARCHAR2
1552: ) IS
1553: BEGIN
1554: IF fnd_global.conc_request_id > 0 THEN
1555: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);
1556: ELSE
1557: --DBMS_OUTPUT.PUT_LINE( p_string);
1558: null;
1559: END IF;

Line 1595: FND_FILE.PUT_LINE(FND_FILE.LOG, p_debug_info);

1591: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
1592:
1593: BEGIN
1594: IF ( g_msc_cp_debug= '1' OR g_msc_cp_debug = '2') THEN
1595: FND_FILE.PUT_LINE(FND_FILE.LOG, p_debug_info);
1596: END IF;
1597: --dbms_output.put_line(p_debug_info); -- ut
1598: EXCEPTION
1599: WHEN OTHERS THEN

Line 1608: FND_FILE.PUT_LINE(FND_FILE.LOG, p_user_info);

1604: PROCEDURE print_user_info(
1605: p_user_info IN VARCHAR2
1606: )IS
1607: BEGIN
1608: FND_FILE.PUT_LINE(FND_FILE.LOG, p_user_info);
1609: -- dbms_output.put_line(p_user_info); -- ut
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: RAISE;