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.HXC_DATA_SET dependencies on FND_FILE

Line 40: fnd_file.put_line(fnd_file.LOG,'--- >The Start Date of the Data Set cannot be greater than the End Date ');

36: BEGIN
37:
38: -- check the date first
39: IF p_start_date >= p_stop_date THEN
40: fnd_file.put_line(fnd_file.LOG,'--- >The Start Date of the Data Set cannot be greater than the End Date ');
41: RETURN FALSE;
42: END IF;
43:
44:

Line 52: fnd_file.put_line(fnd_file.LOG,'--- >There is an existing Data Set whose range overlaps with the '

48: FETCH c_check_range_exists INTO l_dummy;
49: IF c_check_range_exists%found THEN
50:
51: CLOSE c_check_range_exists;
52: fnd_file.put_line(fnd_file.LOG,'--- >There is an existing Data Set whose range overlaps with the '
53: ||'period specified');
54: RETURN FALSE;
55:
56: END IF;

Line 59: fnd_file.put_line(fnd_file.LOG,'--- >After checking the valid Data Set range');

55:
56: END IF;
57: CLOSE c_check_range_exists;
58:
59: fnd_file.put_line(fnd_file.LOG,'--- >After checking the valid Data Set range');
60:
61: OPEN c_check_name_exists(p_data_set_name);
62: FETCH c_check_name_exists INTO l_dummy;
63: IF c_check_name_exists%found THEN

Line 66: fnd_file.put_line(fnd_file.LOG,'--- >Data Set name is already used');

62: FETCH c_check_name_exists INTO l_dummy;
63: IF c_check_name_exists%found THEN
64:
65: close c_check_name_exists;
66: fnd_file.put_line(fnd_file.LOG,'--- >Data Set name is already used');
67: RETURN FALSE;
68:
69: END IF;
70: CLOSE c_check_name_exists;

Line 72: fnd_file.put_line(fnd_file.LOG,'--- >After checking the unique name');

68:
69: END IF;
70: CLOSE c_check_name_exists;
71:
72: fnd_file.put_line(fnd_file.LOG,'--- >After checking the unique name');
73:
74: RETURN TRUE;
75: END validate_data_set_range;
76:

Line 95: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');

91:
92:
93: BEGIN
94:
95: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
96: fnd_file.put_line(fnd_file.LOG,'----------- EXISTING DATA SETS -----------');
97: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
98:
99: FOR crs_data_sets in c_data_sets LOOP

Line 96: fnd_file.put_line(fnd_file.LOG,'----------- EXISTING DATA SETS -----------');

92:
93: BEGIN
94:
95: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
96: fnd_file.put_line(fnd_file.LOG,'----------- EXISTING DATA SETS -----------');
97: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
98:
99: FOR crs_data_sets in c_data_sets LOOP
100:

Line 97: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');

93: BEGIN
94:
95: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
96: fnd_file.put_line(fnd_file.LOG,'----------- EXISTING DATA SETS -----------');
97: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
98:
99: FOR crs_data_sets in c_data_sets LOOP
100:
101: fnd_file.put_line(fnd_file.LOG,' --> Data Set Id: '||crs_data_sets.data_set_id);

Line 101: fnd_file.put_line(fnd_file.LOG,' --> Data Set Id: '||crs_data_sets.data_set_id);

97: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
98:
99: FOR crs_data_sets in c_data_sets LOOP
100:
101: fnd_file.put_line(fnd_file.LOG,' --> Data Set Id: '||crs_data_sets.data_set_id);
102: fnd_file.put_line(fnd_file.LOG,' --> Data Set Name: '||crs_data_sets.data_set_name);
103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);
104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);

Line 102: fnd_file.put_line(fnd_file.LOG,' --> Data Set Name: '||crs_data_sets.data_set_name);

98:
99: FOR crs_data_sets in c_data_sets LOOP
100:
101: fnd_file.put_line(fnd_file.LOG,' --> Data Set Id: '||crs_data_sets.data_set_id);
102: fnd_file.put_line(fnd_file.LOG,' --> Data Set Name: '||crs_data_sets.data_set_name);
103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);
104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);
106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);

Line 103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);

99: FOR crs_data_sets in c_data_sets LOOP
100:
101: fnd_file.put_line(fnd_file.LOG,' --> Data Set Id: '||crs_data_sets.data_set_id);
102: fnd_file.put_line(fnd_file.LOG,' --> Data Set Name: '||crs_data_sets.data_set_name);
103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);
104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);
106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);
107: fnd_file.put_line(fnd_file.LOG,' --> Validation Status: '||crs_data_sets.validation_status);

Line 104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);

100:
101: fnd_file.put_line(fnd_file.LOG,' --> Data Set Id: '||crs_data_sets.data_set_id);
102: fnd_file.put_line(fnd_file.LOG,' --> Data Set Name: '||crs_data_sets.data_set_name);
103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);
104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);
106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);
107: fnd_file.put_line(fnd_file.LOG,' --> Validation Status: '||crs_data_sets.validation_status);
108: fnd_file.put_line(fnd_file.LOG,' ---------');

Line 105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);

101: fnd_file.put_line(fnd_file.LOG,' --> Data Set Id: '||crs_data_sets.data_set_id);
102: fnd_file.put_line(fnd_file.LOG,' --> Data Set Name: '||crs_data_sets.data_set_name);
103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);
104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);
106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);
107: fnd_file.put_line(fnd_file.LOG,' --> Validation Status: '||crs_data_sets.validation_status);
108: fnd_file.put_line(fnd_file.LOG,' ---------');
109:

Line 106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);

102: fnd_file.put_line(fnd_file.LOG,' --> Data Set Name: '||crs_data_sets.data_set_name);
103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);
104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);
106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);
107: fnd_file.put_line(fnd_file.LOG,' --> Validation Status: '||crs_data_sets.validation_status);
108: fnd_file.put_line(fnd_file.LOG,' ---------');
109:
110:

Line 107: fnd_file.put_line(fnd_file.LOG,' --> Validation Status: '||crs_data_sets.validation_status);

103: fnd_file.put_line(fnd_file.LOG,' --> Description: '||crs_data_sets.description);
104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);
106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);
107: fnd_file.put_line(fnd_file.LOG,' --> Validation Status: '||crs_data_sets.validation_status);
108: fnd_file.put_line(fnd_file.LOG,' ---------');
109:
110:
111:

Line 108: fnd_file.put_line(fnd_file.LOG,' ---------');

104: fnd_file.put_line(fnd_file.LOG,' --> Data Set Status: '||crs_data_sets.status);
105: fnd_file.put_line(fnd_file.LOG,' --> Date From: '||crs_data_sets.start_date);
106: fnd_file.put_line(fnd_file.LOG,' --> Date To: '||crs_data_sets.end_date);
107: fnd_file.put_line(fnd_file.LOG,' --> Validation Status: '||crs_data_sets.validation_status);
108: fnd_file.put_line(fnd_file.LOG,' ---------');
109:
110:
111:
112: END LOOP;

Line 114: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');

110:
111:
112: END LOOP;
113:
114: fnd_file.put_line(fnd_file.LOG,'------------------------------------------------');
115:
116:
117: END show_data_set;
118:

Line 205: fnd_file.put_line(fnd_file.LOG,'================================================================');

201: -- we take 100 timecard ids within the given range per iteration
202: -- and mark the corresponding records in the base tables
203: FETCH c_tbb_id bulk collect INTO l_tbb_id_tab limit l_chunk_size;
204:
205: fnd_file.put_line(fnd_file.LOG,'================================================================');
206: fnd_file.put_line(fnd_file.LOG,'Entering in a new chunk l_tbb_id_tab.count '||l_tbb_id_tab.count);
207: fnd_file.put_line(fnd_file.LOG,'================================================================');
208:
209: IF l_tbb_id_tab.count = 0 THEN

Line 206: fnd_file.put_line(fnd_file.LOG,'Entering in a new chunk l_tbb_id_tab.count '||l_tbb_id_tab.count);

202: -- and mark the corresponding records in the base tables
203: FETCH c_tbb_id bulk collect INTO l_tbb_id_tab limit l_chunk_size;
204:
205: fnd_file.put_line(fnd_file.LOG,'================================================================');
206: fnd_file.put_line(fnd_file.LOG,'Entering in a new chunk l_tbb_id_tab.count '||l_tbb_id_tab.count);
207: fnd_file.put_line(fnd_file.LOG,'================================================================');
208:
209: IF l_tbb_id_tab.count = 0 THEN
210: CLOSE c_tbb_id;

Line 207: fnd_file.put_line(fnd_file.LOG,'================================================================');

203: FETCH c_tbb_id bulk collect INTO l_tbb_id_tab limit l_chunk_size;
204:
205: fnd_file.put_line(fnd_file.LOG,'================================================================');
206: fnd_file.put_line(fnd_file.LOG,'Entering in a new chunk l_tbb_id_tab.count '||l_tbb_id_tab.count);
207: fnd_file.put_line(fnd_file.LOG,'================================================================');
208:
209: IF l_tbb_id_tab.count = 0 THEN
210: CLOSE c_tbb_id;
211: EXIT;

Line 237: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');

233: (data_set_id,id, scope)
234: VALUES
235: (p_data_set_id,l_tbb_id_tab(x),'TIMECARD');
236:
237: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
238: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD INSERT INTO TEMP table for this chunk: '||sql%rowcount);
239:
240: -- after just DELETE the bulk table
241: l_tbb_id_tab.DELETE;

Line 238: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD INSERT INTO TEMP table for this chunk: '||sql%rowcount);

234: VALUES
235: (p_data_set_id,l_tbb_id_tab(x),'TIMECARD');
236:
237: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
238: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD INSERT INTO TEMP table for this chunk: '||sql%rowcount);
239:
240: -- after just DELETE the bulk table
241: l_tbb_id_tab.DELETE;
242:

Line 252: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD UPDATE for this chunk: '||sql%rowcount);

248: FROM hxc_temp_timecard_chunks temp
249: WHERE temp.data_set_id = p_data_set_id
250: AND temp.scope = 'TIMECARD');
251:
252: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD UPDATE for this chunk: '||sql%rowcount);
253:
254: -- Bug 7358756
255: -- The following lines of code commented out, we no longer need it.
256:

Line 347: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');

343: FROM hxc_temp_timecard_chunks temp
344: WHERE temp.data_set_id = p_data_set_id
345: AND temp.scope = 'TIMECARD');
346:
347: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
348: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD SUMMARY for this chunk: '||sql%rowcount);
349:
350:
351: COMMIT;

Line 348: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD SUMMARY for this chunk: '||sql%rowcount);

344: WHERE temp.data_set_id = p_data_set_id
345: AND temp.scope = 'TIMECARD');
346:
347: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
348: fnd_file.put_line(fnd_file.LOG,'--- >Count of TIMECARD SUMMARY for this chunk: '||sql%rowcount);
349:
350:
351: COMMIT;
352:

Line 436: fnd_file.put_line(fnd_file.LOG,'Error during undo data set: '||sqlerrm);

432: /*
433: EXCEPTION
434: WHEN OTHERS THEN
435:
436: fnd_file.put_line(fnd_file.LOG,'Error during undo data set: '||sqlerrm);
437: ROLLBACK;
438: p_retcode:=2;
439:
440: IF (nvl(fnd_profile.value('AFLOG_ENABLED'),'N')='Y') THEN

Line 825: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

821: --Start all the validations
822: --for each validation error we need to add that to the log file
823:
824: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
825: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
826: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
827:
828: OPEN c_get_bee_retrieval;
829: FETCH c_get_bee_retrieval INTO l_bee_retrieval;

Line 826: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

822: --for each validation error we need to add that to the log file
823:
824: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
825: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
826: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
827:
828: OPEN c_get_bee_retrieval;
829: FETCH c_get_bee_retrieval INTO l_bee_retrieval;
830: CLOSE c_get_bee_retrieval;

Line 870: fnd_file.put_line(fnd_file.LOG,' ');

866:
867:
868: if(l_approved_count=1 and l_unretrieved_tc.approval_status='APPROVED') then
869:
870: fnd_file.put_line(fnd_file.LOG,' ');
871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

Line 871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

867:
868: if(l_approved_count=1 and l_unretrieved_tc.approval_status='APPROVED') then
869:
870: fnd_file.put_line(fnd_file.LOG,' ');
871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

Line 873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

869:
870: fnd_file.put_line(fnd_file.LOG,' ');
871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
877: end if;

Line 874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

870: fnd_file.put_line(fnd_file.LOG,' ');
871: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
877: end if;
878:

Line 876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

872: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
873: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
874: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
875: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
876: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
877: end if;
878:
879: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
880:

Line 881: fnd_file.put_line(fnd_file.LOG,' ');

877: end if;
878:
879: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
880:
881: fnd_file.put_line(fnd_file.LOG,' ');
882: fnd_file.put_line(fnd_file.LOG,' ');
883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

Line 882: fnd_file.put_line(fnd_file.LOG,' ');

878:
879: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
880:
881: fnd_file.put_line(fnd_file.LOG,' ');
882: fnd_file.put_line(fnd_file.LOG,' ');
883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

Line 883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

879: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
880:
881: fnd_file.put_line(fnd_file.LOG,' ');
882: fnd_file.put_line(fnd_file.LOG,' ');
883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

Line 885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

881: fnd_file.put_line(fnd_file.LOG,' ');
882: fnd_file.put_line(fnd_file.LOG,' ');
883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
889: end if;

Line 886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

882: fnd_file.put_line(fnd_file.LOG,' ');
883: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
889: end if;
890:

Line 888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

884: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
885: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
886: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
887: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
888: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
889: end if;
890:
891:
892: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then

Line 894: fnd_file.put_line(fnd_file.LOG,' ');

890:
891:
892: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then
893:
894: fnd_file.put_line(fnd_file.LOG,' ');
895: fnd_file.put_line(fnd_file.LOG,' ');
896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

Line 895: fnd_file.put_line(fnd_file.LOG,' ');

891:
892: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then
893:
894: fnd_file.put_line(fnd_file.LOG,' ');
895: fnd_file.put_line(fnd_file.LOG,' ');
896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

Line 896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

892: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then
893:
894: fnd_file.put_line(fnd_file.LOG,' ');
895: fnd_file.put_line(fnd_file.LOG,' ');
896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

Line 898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

894: fnd_file.put_line(fnd_file.LOG,' ');
895: fnd_file.put_line(fnd_file.LOG,' ');
896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
902: end if;

Line 899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

895: fnd_file.put_line(fnd_file.LOG,' ');
896: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
902: end if;
903:

Line 901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

897: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
898: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
899: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
900: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
901: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
902: end if;
903:
904: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
905:

Line 906: fnd_file.put_line(fnd_file.LOG,' ');

902: end if;
903:
904: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
905:
906: fnd_file.put_line(fnd_file.LOG,' ');
907: fnd_file.put_line(fnd_file.LOG,' ');
908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

Line 907: fnd_file.put_line(fnd_file.LOG,' ');

903:
904: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
905:
906: fnd_file.put_line(fnd_file.LOG,' ');
907: fnd_file.put_line(fnd_file.LOG,' ');
908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

Line 908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

904: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
905:
906: fnd_file.put_line(fnd_file.LOG,' ');
907: fnd_file.put_line(fnd_file.LOG,' ');
908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

Line 910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

906: fnd_file.put_line(fnd_file.LOG,' ');
907: fnd_file.put_line(fnd_file.LOG,' ');
908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
914: end if;

Line 911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

907: fnd_file.put_line(fnd_file.LOG,' ');
908: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
914: end if;
915:

Line 913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

909: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
910: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
911: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
912: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
913: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
914: end if;
915:
916:
917:

Line 918: fnd_file.put_line(fnd_file.LOG,l_unretrieved_tc.start_time||'-'||l_unretrieved_tc.stop_time||' '||l_unretrieved_tc.resource_id||' - '||l_unretrieved_tc.employee_number||' - '||l_unretrieved_tc.full_name);

914: end if;
915:
916:
917:
918: fnd_file.put_line(fnd_file.LOG,l_unretrieved_tc.start_time||'-'||l_unretrieved_tc.stop_time||' '||l_unretrieved_tc.resource_id||' - '||l_unretrieved_tc.employee_number||' - '||l_unretrieved_tc.full_name);
919:
920: p_error_count := p_error_count + 1;
921:
922: IF (hxc_archive_restore_utils.check_max_errors(p_error_count) and p_all_errors=false )

Line 946: fnd_file.put_line(fnd_file.LOG,' ');

942: l_validation_status := 'E';
943: l_count:=l_count+1;
944:
945: if(l_count=1) then
946: fnd_file.put_line(fnd_file.LOG,' ');
947: fnd_file.put_line(fnd_file.LOG,' ');
948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

Line 947: fnd_file.put_line(fnd_file.LOG,' ');

943: l_count:=l_count+1;
944:
945: if(l_count=1) then
946: fnd_file.put_line(fnd_file.LOG,' ');
947: fnd_file.put_line(fnd_file.LOG,' ');
948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

Line 948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

944:
945: if(l_count=1) then
946: fnd_file.put_line(fnd_file.LOG,' ');
947: fnd_file.put_line(fnd_file.LOG,' ');
948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

Line 950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

946: fnd_file.put_line(fnd_file.LOG,' ');
947: fnd_file.put_line(fnd_file.LOG,' ');
948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
954: end if;

Line 951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

947: fnd_file.put_line(fnd_file.LOG,' ');
948: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
954: end if;
955:

Line 953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

949: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
950: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
951: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
952: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
954: end if;
955:
956:
957: fnd_file.put_line(fnd_file.LOG,l_err_tc.start_time||'-'||l_err_tc.stop_time||' '||l_err_tc.resource_id||' - '||l_err_tc.employee_number||' - '||l_err_tc.full_name);

Line 957: fnd_file.put_line(fnd_file.LOG,l_err_tc.start_time||'-'||l_err_tc.stop_time||' '||l_err_tc.resource_id||' - '||l_err_tc.employee_number||' - '||l_err_tc.full_name);

953: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
954: end if;
955:
956:
957: fnd_file.put_line(fnd_file.LOG,l_err_tc.start_time||'-'||l_err_tc.stop_time||' '||l_err_tc.resource_id||' - '||l_err_tc.employee_number||' - '||l_err_tc.full_name);
958:
959: p_error_count := p_error_count + 1;
960:
961: IF (hxc_archive_restore_utils.check_max_errors(p_error_count) and p_all_errors=false )

Line 997: fnd_file.put_line(fnd_file.LOG,' ');

993: l_count:=l_count+1;
994:
995: if(l_count=1)
996: then
997: fnd_file.put_line(fnd_file.LOG,' ');
998: fnd_file.put_line(fnd_file.LOG,' ');
999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

Line 998: fnd_file.put_line(fnd_file.LOG,' ');

994:
995: if(l_count=1)
996: then
997: fnd_file.put_line(fnd_file.LOG,' ');
998: fnd_file.put_line(fnd_file.LOG,' ');
999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

Line 999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

995: if(l_count=1)
996: then
997: fnd_file.put_line(fnd_file.LOG,' ');
998: fnd_file.put_line(fnd_file.LOG,' ');
999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

Line 1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

997: fnd_file.put_line(fnd_file.LOG,' ');
998: fnd_file.put_line(fnd_file.LOG,' ');
999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
1005: end if;

Line 1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

998: fnd_file.put_line(fnd_file.LOG,' ');
999: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
1005: end if;
1006:

Line 1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

1000: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
1001: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
1002: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
1005: end if;
1006:
1007: fnd_file.put_line(fnd_file.LOG,
1008: l_timecard_notifications.start_time||'-'||l_timecard_notifications.stop_time||' '||l_timecard_notifications.resource_id||' - '||l_timecard_notifications.employee_number||' - '||l_timecard_notifications.full_name);

Line 1007: fnd_file.put_line(fnd_file.LOG,

1003: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
1004: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
1005: end if;
1006:
1007: fnd_file.put_line(fnd_file.LOG,
1008: l_timecard_notifications.start_time||'-'||l_timecard_notifications.stop_time||' '||l_timecard_notifications.resource_id||' - '||l_timecard_notifications.employee_number||' - '||l_timecard_notifications.full_name);
1009: p_error_count := p_error_count + 1;
1010:
1011: IF (hxc_archive_restore_utils.check_max_errors(p_error_count) and p_all_errors=false)

Line 1075: --fnd_file.put_line(fnd_file.LOG,l_messages(l_messages.first).message_name);

1071: p_row_lock_id => l_row_lock_id,
1072: p_locked_success => l_lock_success
1073: );
1074:
1075: --fnd_file.put_line(fnd_file.LOG,l_messages(l_messages.first).message_name);
1076:
1077: IF not(l_lock_success) THEN
1078:
1079: -- before returning let's unlock all the timecards that were locked

Line 1087: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );

1083: p_transaction_lock_id => p_data_set_id,
1084: p_released_success => l_released_success
1085: );
1086:
1087: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
1088: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1089: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1090: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1091:

Line 1088: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );

1084: p_released_success => l_released_success
1085: );
1086:
1087: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
1088: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1089: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1090: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1091:
1092: RETURN;

Line 1089: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');

1085: );
1086:
1087: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
1088: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1089: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1090: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1091:
1092: RETURN;
1093:

Line 1090: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);

1086:
1087: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
1088: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1089: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1090: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1091:
1092: RETURN;
1093:
1094: END IF;