DBA Data[Home] [Help]

APPS.GMP_CALENDAR_PKG dependencies on FND_FILE

Line 100: Fnd_File.Put_Line( Fnd_File.Log, Pbuff);

96: insert_stmt varchar2(8000);
97:
98: BEGIN
99: IF fnd_global.conc_request_id > 0 THEN
100: Fnd_File.Put_Line( Fnd_File.Log, Pbuff);
101: /* B13866449 Rajesh Patangya */
102: /* Insert_Stmt := 'insert into gmp_collection_messages'
103: ||' (msg_no, '
104: ||' message, '

Line 1970: Fnd_File.Put_Line( Fnd_File.Log,'sql_stmt1 : '||sql_stmt1);

1966: || ' AND rt.rsum <> 0 '
1967: || ' AND rt.assigned_qty>rsum) '
1968: || ' ORDER BY 2,6,5 ';
1969:
1970: Fnd_File.Put_Line( Fnd_File.Log,'sql_stmt1 : '||sql_stmt1);
1971: log_message('V_FROM_RSRC: '||V_FROM_RSRC||'** V_TO_RSRC: '||V_TO_RSRC ||
1972: ' p_org_id='|| p_org_id || ' g_calendar_code='|| g_calendar_code || ' p_calendar_code=' || p_calendar_code);
1973:
1974: IF (v_from_rsrc IS NOT NULL AND v_to_rsrc IS NOT NULL) THEN

Line 2894: Fnd_File.Put_Line( Fnd_File.Log,'sql_stmt1 : '||sql_stmt1);

2890: || ' (rt.assigned_qty - nvl(rt.rsum,0))) > 0 '
2891: || ' ORDER BY rt.resource_id ,rt.instance_id, '
2892: || ' rt.interval_date,rt.shift_num ' ;
2893:
2894: Fnd_File.Put_Line( Fnd_File.Log,'sql_stmt1 : '||sql_stmt1);
2895: log_message('V_FROM_RSRC: '||V_FROM_RSRC||'** V_TO_RSRC: '||V_TO_RSRC ||
2896: ' p_org_id='|| p_org_id || ' g_calendar_code='|| g_calendar_code || ' p_calendar_code=' || p_calendar_code);
2897:
2898: