DBA Data[Home] [Help]

APPS.IEU_WR_CON_PVT dependencies on FND_FILE

Line 173: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

169: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_PURGE_INP_PARAMS');
170: FND_MESSAGE.SET_TOKEN('WS_CODE', p_ws_code);
171: FND_MESSAGE.SET_TOKEN('LU_DATE', p_last_update_date);
172: l_message := FND_MESSAGE.GET;
173: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
174:
175: BEGIN
176:
177: SELECT WS_B.WS_ID, WS_B.WS_TYPE, WS_A.DIST_ST_BASED_ON_PARENT_FLAG,

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

268:
269: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_PURGE_PARENT_WI');
270: FND_MESSAGE.SET_TOKEN('WS_CODE', l_parent_ws_code);
271: l_message := FND_MESSAGE.GET;
272: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
273:
274: RAISE fnd_api.g_exc_error;
275: END IF;
276:

Line 304: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

300: /* FOR i IN 1..l_task_det_rec.l_workitem_pk_id_list.COUNT loop
301: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_PURGED_WI_DETAILS');
302: FND_MESSAGE.SET_TOKEN('WI_PK_ID', l_task_det_rec.l_workitem_pk_id_list(i));
303: l_message := FND_MESSAGE.GET;
304: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
305: END LOOP;*/
306: /* --** Audit logging starts here ** --
307: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
308: l_action_key := 'WORKITEM_PURGE';

Line 474: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

470: FND_MESSAGE.SET_TOKEN('WI_PK_ID', l_task_det_rec.l_workitem_pk_id_list(i));
471: FND_MESSAGE.SET_TOKEN('PARENT_WI_PK_ID', l_task_det_rec.l_source_object_id_list(i));
472: FND_MESSAGE.SET_TOKEN('PARENT_WI_OBJ_CODE',l_task_det_rec.l_source_object_type_code_list(i));
473: l_message := FND_MESSAGE.GET;
474: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
475: END LOOP;
476:
477: --** delete all associate work items where parent work items are closed **--
478: delete

Line 541: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

537:
538: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_PURGED_WI_DETAILS');
539: FND_MESSAGE.SET_TOKEN('WI_PK_ID', l_task_det_rec.l_workitem_pk_id_list(i));
540: l_message := FND_MESSAGE.GET;
541: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
542:
543: END LOOP;*/
544:
545: /* --** Audit logging starts here ** --

Line 711: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

707: FND_MESSAGE.SET_TOKEN('WI_PK_ID', l_task_det_rec.l_workitem_pk_id_list(i));
708: FND_MESSAGE.SET_TOKEN('CHILD_WI_PK_ID', l_task_det_rec.l_source_object_id_list(i));
709: FND_MESSAGE.SET_TOKEN('CHILD_WI_OBJ_CODE', l_task_det_rec.l_source_object_type_Code_list(i));
710: l_message := FND_MESSAGE.GET;
711: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
712: END LOOP;
713: END IF; -- l_assct_ws_id
714:
715: IF (l_assct_ws_id is not null)

Line 760: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

756:
757: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_PURGED_WI_DETAILS');
758: FND_MESSAGE.SET_TOKEN('WI_PK_ID', l_task_det_rec.l_workitem_pk_id_list(i));
759: l_message := FND_MESSAGE.GET;
760: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
761: END LOOP;*/
762:
763: /* --** Audit logging starts here ** --
764: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

Line 941: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

937:
938: WHEN OTHERS THEN
939: errbuf := sqlcode||' '||sqlerrm;
940: l_message := sqlcode||' '||sqlerrm;
941: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
942: retcode := 2;
943:
944: END PURGE_WR_DATA;
945:

Line 964: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

960: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_AUDIT_PURGE_INP_PARAMS');
961: FND_MESSAGE.SET_TOKEN('OBJECT_CODE', p_obj_code);
962: FND_MESSAGE.SET_TOKEN('CR_DATE', p_creation_date);
963: l_message := FND_MESSAGE.GET;
964: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
965:
966: IF ( (p_creation_date IS not null) AND (p_obj_code IS not null) )
967: THEN
968:

Line 988: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);

984:
985: errbuf := sqlcode||' '||sqlerrm;
986: retcode := 2;
987: l_message := sqlcode || ' '||sqlerrm;
988: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
989:
990: END PURGE_WR_AUDIT_DATA;
991:
992: END IEU_WR_CON_PVT;