eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_PROCCERT_REMINDER_PKG dependencies on FND_FILE

Line 256: fnd_file.put_line(fnd_file.LOG, 'Starting to Fetch all Certification which are active and a reminder need to send from cursor Get_Certi_for_Reminders');

252: l_exists BOOLEAN;
253:
254: begin
255:
256: fnd_file.put_line(fnd_file.LOG, 'Starting to Fetch all Certification which are active and a reminder need to send from cursor Get_Certi_for_Reminders');
257:
258:
259: --------------------------------------------
260: -- Main cursor loop

Line 264: fnd_file.put_line(fnd_file.LOG,

260: -- Main cursor loop
261: --------------------------------------------
262:
263: for cert_rec in Get_Certi_for_Reminders loop
264: fnd_file.put_line(fnd_file.LOG,
265: 'Fetching Certification ID: '||to_number(cert_rec.certification_id));
266:
267: l_owner_tbl.delete;
268: g_ownerlist_tbl.delete; /* hyuen bug 5098058 */

Line 322: fnd_file.put_line(fnd_file.LOG,

318: end loop;
319:
320: EXCEPTION
321: WHEN OTHERS THEN
322: fnd_file.put_line(fnd_file.LOG,
323: 'unexpected error in send_reminder_to_all_owners: '||sqlerrm);
324: END send_reminder_to_all_owners;
325:
326:

Line 333: fnd_file.put_line(fnd_file.LOG,

329:
330: PROCEDURE update_lastreminder_date(p_certificaion_id IN number, x_return_status OUT NOCOPY VARCHAR2)
331: is
332: begin
333: fnd_file.put_line(fnd_file.LOG,
334: 'Going to update LAST_REMINDER_DATE for '||p_certificaion_id);
335:
336: update amw_certification_b
337: set LAST_REMINDER_DATE= sysdate

Line 342: fnd_file.put_line(fnd_file.LOG,

338: where CERTIFICATION_ID = p_certificaion_id;
339:
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341:
342: fnd_file.put_line(fnd_file.LOG,
343: 'Updates LAST_REMINDER_DATE for '||p_certificaion_id);
344: EXCEPTION
345: WHEN OTHERS THEN
346: fnd_file.put_line(fnd_file.LOG,

Line 346: fnd_file.put_line(fnd_file.LOG,

342: fnd_file.put_line(fnd_file.LOG,
343: 'Updates LAST_REMINDER_DATE for '||p_certificaion_id);
344: EXCEPTION
345: WHEN OTHERS THEN
346: fnd_file.put_line(fnd_file.LOG,
347: 'unexpected error in update_lastreminder_date: '||sqlerrm);
348: END update_lastreminder_date;
349:
350:

Line 383: fnd_file.put_line(fnd_file.LOG, 'send_reminder_to_owner begin');

379: l_from_emp_id NUMBER := FND_GLOBAL.employee_id;
380:
381: begin
382:
383: fnd_file.put_line(fnd_file.LOG, 'send_reminder_to_owner begin');
384: fnd_file.put_line(fnd_file.LOG, 'certification_id:'||to_char(p_certification_id));
385: fnd_file.put_line(fnd_file.LOG, 'process_owner_id:'||to_char(p_process_owner_id));
386: fnd_file.put_line(fnd_file.LOG, 'organization_id:'||p_organization_id);
387: fnd_file.put_line(fnd_file.LOG, 'process_id:'||p_process_id);

Line 384: fnd_file.put_line(fnd_file.LOG, 'certification_id:'||to_char(p_certification_id));

380:
381: begin
382:
383: fnd_file.put_line(fnd_file.LOG, 'send_reminder_to_owner begin');
384: fnd_file.put_line(fnd_file.LOG, 'certification_id:'||to_char(p_certification_id));
385: fnd_file.put_line(fnd_file.LOG, 'process_owner_id:'||to_char(p_process_owner_id));
386: fnd_file.put_line(fnd_file.LOG, 'organization_id:'||p_organization_id);
387: fnd_file.put_line(fnd_file.LOG, 'process_id:'||p_process_id);
388:

Line 385: fnd_file.put_line(fnd_file.LOG, 'process_owner_id:'||to_char(p_process_owner_id));

381: begin
382:
383: fnd_file.put_line(fnd_file.LOG, 'send_reminder_to_owner begin');
384: fnd_file.put_line(fnd_file.LOG, 'certification_id:'||to_char(p_certification_id));
385: fnd_file.put_line(fnd_file.LOG, 'process_owner_id:'||to_char(p_process_owner_id));
386: fnd_file.put_line(fnd_file.LOG, 'organization_id:'||p_organization_id);
387: fnd_file.put_line(fnd_file.LOG, 'process_id:'||p_process_id);
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 386: fnd_file.put_line(fnd_file.LOG, 'organization_id:'||p_organization_id);

382:
383: fnd_file.put_line(fnd_file.LOG, 'send_reminder_to_owner begin');
384: fnd_file.put_line(fnd_file.LOG, 'certification_id:'||to_char(p_certification_id));
385: fnd_file.put_line(fnd_file.LOG, 'process_owner_id:'||to_char(p_process_owner_id));
386: fnd_file.put_line(fnd_file.LOG, 'organization_id:'||p_organization_id);
387: fnd_file.put_line(fnd_file.LOG, 'process_id:'||p_process_id);
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:

Line 387: fnd_file.put_line(fnd_file.LOG, 'process_id:'||p_process_id);

383: fnd_file.put_line(fnd_file.LOG, 'send_reminder_to_owner begin');
384: fnd_file.put_line(fnd_file.LOG, 'certification_id:'||to_char(p_certification_id));
385: fnd_file.put_line(fnd_file.LOG, 'process_owner_id:'||to_char(p_process_owner_id));
386: fnd_file.put_line(fnd_file.LOG, 'organization_id:'||p_organization_id);
387: fnd_file.put_line(fnd_file.LOG, 'process_id:'||p_process_id);
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: open c_certification(p_certification_id);

Line 420: fnd_file.put_line(fnd_file.LOG, 'to_role is null');

416: IF l_to_role_name IS NULL THEN
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: FND_MESSAGE.set_name('AMW','AMW_APPR_INVALID_ROLE');
419: FND_MSG_PUB.ADD;
420: fnd_file.put_line(fnd_file.LOG, 'to_role is null');
421: ELSE
422:
423: WF_DIRECTORY.getrolename
424: (p_orig_system => 'PER',

Line 434: fnd_file.put_line(fnd_file.LOG, 'notification_id:'||l_notif_id||'--'||l_subject);

430: (role => l_to_role_name,
431: msg_type => p_item_type,
432: msg_name => p_message_name);
433:
434: fnd_file.put_line(fnd_file.LOG, 'notification_id:'||l_notif_id||'--'||l_subject);
435:
436: WF_NOTIFICATION.SetAttrText
437: (l_notif_id,
438: 'MSG_SUBJECT',

Line 472: fnd_file.put_line(fnd_file.LOG,

468: end if;
469:
470: EXCEPTION
471: WHEN OTHERS THEN
472: fnd_file.put_line(fnd_file.LOG,
473: 'unexpected error in send_reminder_to_owner: '||sqlerrm);
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: END send_reminder_to_owner;
476:

Line 553: fnd_file.put_line(fnd_file.LOG, 'Getting Data from Cursor Get_Proc_Owner_To_Notify ');

549: l_owner_tbl t_owner_tbl;
550: l_exists BOOLEAN;
551:
552: begin
553: fnd_file.put_line(fnd_file.LOG, 'Getting Data from Cursor Get_Proc_Owner_To_Notify ');
554:
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556:
557: g_proc_owner_tbl.delete;

Line 608: fnd_file.put_line(fnd_file.LOG,

604: commit;
605:
606: EXCEPTION
607: WHEN OTHERS THEN
608: fnd_file.put_line(fnd_file.LOG,
609: 'unexpected error in send_reminder_to_owner: '||sqlerrm);
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: END send_reminder_selected_procs;
612: