DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on FND_FILE

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

1530: --NVL(sd.project_number,'-99') = nvl(p_project_id, NVL(sd.project_number, '-99')) and
1531: --NVL(sd.task_number, '-99') = nvl(p_task_id, NVL(sd.task_number, '-99'));
1532:
1533: l_row := SQL%ROWCOUNT;
1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
1535:
1536: ELSIF p_overwrite = 2 THEN
1537: delete from msc_sup_dem_entries sd
1538: where sd.publisher_order_type = 3 and

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

1573: --NVL(sd.task_number, '-99') = nvl(p_task_id, NVL(sd.task_number, '-99')) and
1574: sd.ship_date between NVL(p_horizon_start, sd.ship_date) and NVL(p_horizon_end, sd.ship_date);
1575:
1576: l_row := SQL%ROWCOUNT;
1577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
1578: END IF;
1579:
1580: EXCEPTION
1581: WHEN OTHERS THEN

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

1588: p_string IN VARCHAR2
1589: ) IS
1590: BEGIN
1591: IF fnd_global.conc_request_id > 0 THEN
1592: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);
1593: ELSE
1594: --DBMS_OUTPUT.PUT_LINE( p_string);
1595: null;
1596: END IF;

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

1628: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
1629:
1630: BEGIN
1631: IF ( g_msc_cp_debug= '1' OR g_msc_cp_debug = '2') THEN
1632: FND_FILE.PUT_LINE(FND_FILE.LOG, p_debug_info);
1633: END IF;
1634: --dbms_output.put_line(p_debug_info); -- ut
1635: EXCEPTION
1636: WHEN OTHERS THEN

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

1641: PROCEDURE print_user_info(
1642: p_user_info IN VARCHAR2
1643: )IS
1644: BEGIN
1645: FND_FILE.PUT_LINE(FND_FILE.LOG, p_user_info);
1646: -- dbms_output.put_line(p_user_info); -- ut
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: RAISE;