2442: v_attch_id := fnd_log.message_with_attachment(
2443: log_level=>fnd_log.level_unexpected,
2444: module=>MODULE||'.Alert_Long_Running_Requests',
2445: pop_message=>false);
2446: fnd_log_attachment.writeln(
2447: pattachment_id => v_attch_id,
2448: pmessage => fnd_message.get);
2449: fnd_log_attachment.writeln(
2450: pattachment_id => v_attch_id,
2445: pop_message=>false);
2446: fnd_log_attachment.writeln(
2447: pattachment_id => v_attch_id,
2448: pmessage => fnd_message.get);
2449: fnd_log_attachment.writeln(
2450: pattachment_id => v_attch_id,
2451: pmessage => ' ');
2452: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2453: -- write info to attachment about each request.
2450: pattachment_id => v_attch_id,
2451: pmessage => ' ');
2452: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2453: -- write info to attachment about each request.
2454: fnd_log_attachment.writeln(
2455: pattachment_id => v_attch_id,
2456: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2457: v_req_list_rec.display_name(i));
2458: end loop;
2455: pattachment_id => v_attch_id,
2456: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2457: v_req_list_rec.display_name(i));
2458: end loop;
2459: fnd_log_attachment.close(
2460: pattachment_id => v_attch_id);
2461: end if;
2462: end if;
2463: end if; -- if(v_lng_run_req_alert_enable ='Y') then
2635: v_attch_id := fnd_log.message_with_attachment(
2636: log_level=>fnd_log.level_unexpected,
2637: module=>MODULE||'.Alert_Long_Pending_Requests',
2638: pop_message=>false);
2639: fnd_log_attachment.writeln(
2640: pattachment_id => v_attch_id,
2641: pmessage => fnd_message.get);
2642: fnd_log_attachment.writeln(
2643: pattachment_id => v_attch_id,
2638: pop_message=>false);
2639: fnd_log_attachment.writeln(
2640: pattachment_id => v_attch_id,
2641: pmessage => fnd_message.get);
2642: fnd_log_attachment.writeln(
2643: pattachment_id => v_attch_id,
2644: pmessage => ' ');
2645: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2646: -- write info to attachment about each request.
2643: pattachment_id => v_attch_id,
2644: pmessage => ' ');
2645: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2646: -- write info to attachment about each request.
2647: fnd_log_attachment.writeln(
2648: pattachment_id => v_attch_id,
2649: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2650: v_req_list_rec.display_name(i));
2651: end loop;
2648: pattachment_id => v_attch_id,
2649: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2650: v_req_list_rec.display_name(i));
2651: end loop;
2652: fnd_log_attachment.close(
2653: pattachment_id => v_attch_id);
2654: end if;
2655: end if;
2656: end if; -- if(v_lng_pend_req_alert_enable ='Y') then