DBA Data[Home] [Help]

APPS.MSC_X_REPLENISH dependencies on FND_FILE

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

3090: p_debug_info IN VARCHAR2
3091: )IS
3092: BEGIN
3093: IF ( g_msc_cp_debug= '1' OR g_msc_cp_debug = '2') THEN
3094: FND_FILE.PUT_LINE(FND_FILE.LOG, p_debug_info);
3095: END IF;
3096: -- dbms_output.put_line(p_debug_info); --ut
3097: EXCEPTION
3098: WHEN OTHERS THEN

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

3103: PROCEDURE print_user_info(
3104: p_user_info IN VARCHAR2
3105: )IS
3106: BEGIN
3107: FND_FILE.PUT_LINE(FND_FILE.LOG, p_user_info);
3108: -- dbms_output.put_line(p_user_info); --ut
3109: EXCEPTION
3110: WHEN OTHERS THEN
3111: RAISE;

Line 3578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_suppliers_temp: ' || l_cnt);

3574: AND its.vmi_flag = 1
3575: AND its.enable_vmi_auto_replenish_flag = 'Y';
3576:
3577: l_cnt := SQL%ROWCOUNT;
3578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_suppliers_temp: ' || l_cnt);
3579: -- Create Temp table for Item Supplier Orgs
3580:
3581: Insert into MSC_X_ITEM_ORGS_GTT(
3582: company_key,

Line 3599: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_orgs_temp: ' || l_cnt);

3595: AND its.vmi_flag = 1
3596: AND its.enable_vmi_auto_replenish_flag = 'Y';
3597:
3598: l_cnt := SQL%ROWCOUNT;
3599: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_orgs_temp: ' || l_cnt);
3600:
3601: -- Create Temp table for Item Supplier Sites
3602:
3603: Insert into MSC_X_ITEM_SITES_GTT(

Line 3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_sites_temp: ' || l_cnt);

3613: AND its.vmi_flag = 1
3614: AND its.enable_vmi_auto_replenish_flag = 'Y';
3615:
3616: l_cnt := SQL%ROWCOUNT;
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rows inserted into msc_item_sites_temp: ' || l_cnt);
3618:
3619: commit;
3620:
3621: EXCEPTION