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 736: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

732: --Start all the validations
733: --for each validation error we need to add that to the log file
734:
735: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
736: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
737: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
738:
739: OPEN c_get_bee_retrieval;
740: FETCH c_get_bee_retrieval INTO l_bee_retrieval;

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

733: --for each validation error we need to add that to the log file
734:
735: fnd_message.set_name('HXC', 'HXC_VALIDATION_WARNINGS');
736: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
737: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
738:
739: OPEN c_get_bee_retrieval;
740: FETCH c_get_bee_retrieval INTO l_bee_retrieval;
741: CLOSE c_get_bee_retrieval;

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

777:
778:
779: if(l_approved_count=1 and l_unretrieved_tc.approval_status='APPROVED') then
780:
781: fnd_file.put_line(fnd_file.LOG,' ');
782: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

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

778:
779: if(l_approved_count=1 and l_unretrieved_tc.approval_status='APPROVED') then
780:
781: fnd_file.put_line(fnd_file.LOG,' ');
782: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

780:
781: fnd_file.put_line(fnd_file.LOG,' ');
782: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
788: end if;

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

781: fnd_file.put_line(fnd_file.LOG,' ');
782: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
788: end if;
789:

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

783: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_APPROVED_TC');
784: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
785: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
786: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
787: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
788: end if;
789:
790: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
791:

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

788: end if;
789:
790: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
791:
792: fnd_file.put_line(fnd_file.LOG,' ');
793: fnd_file.put_line(fnd_file.LOG,' ');
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

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

789:
790: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
791:
792: fnd_file.put_line(fnd_file.LOG,' ');
793: fnd_file.put_line(fnd_file.LOG,' ');
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

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

790: if(l_rejected_count=1 and l_unretrieved_tc.approval_status='REJECTED') then
791:
792: fnd_file.put_line(fnd_file.LOG,' ');
793: fnd_file.put_line(fnd_file.LOG,' ');
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

792: fnd_file.put_line(fnd_file.LOG,' ');
793: fnd_file.put_line(fnd_file.LOG,' ');
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
800: end if;

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

793: fnd_file.put_line(fnd_file.LOG,' ');
794: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
800: end if;
801:

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

795: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_REJECTED_TC');
796: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
797: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
798: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
800: end if;
801:
802:
803: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then

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

801:
802:
803: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then
804:
805: fnd_file.put_line(fnd_file.LOG,' ');
806: fnd_file.put_line(fnd_file.LOG,' ');
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

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

802:
803: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then
804:
805: fnd_file.put_line(fnd_file.LOG,' ');
806: fnd_file.put_line(fnd_file.LOG,' ');
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

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

803: if(l_submitted_count=1 and l_unretrieved_tc.approval_status='SUBMITTED') then
804:
805: fnd_file.put_line(fnd_file.LOG,' ');
806: fnd_file.put_line(fnd_file.LOG,' ');
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

805: fnd_file.put_line(fnd_file.LOG,' ');
806: fnd_file.put_line(fnd_file.LOG,' ');
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
813: end if;

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

806: fnd_file.put_line(fnd_file.LOG,' ');
807: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
813: end if;
814:

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

808: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_SUBMITTED_TC');
809: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
810: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
811: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
812: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
813: end if;
814:
815: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
816:

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

813: end if;
814:
815: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
816:
817: fnd_file.put_line(fnd_file.LOG,' ');
818: fnd_file.put_line(fnd_file.LOG,' ');
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

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

814:
815: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
816:
817: fnd_file.put_line(fnd_file.LOG,' ');
818: fnd_file.put_line(fnd_file.LOG,' ');
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

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

815: if(l_working_count=1 and l_unretrieved_tc.approval_status='WORKING') then
816:
817: fnd_file.put_line(fnd_file.LOG,' ');
818: fnd_file.put_line(fnd_file.LOG,' ');
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

817: fnd_file.put_line(fnd_file.LOG,' ');
818: fnd_file.put_line(fnd_file.LOG,' ');
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
825: end if;

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

818: fnd_file.put_line(fnd_file.LOG,' ');
819: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
825: end if;
826:

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

820: fnd_message.set_name('HXC', 'HXC_UNRETRIEVED_WORKING_TC');
821: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
822: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
823: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
824: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
825: end if;
826:
827:
828:

Line 829: 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);

825: end if;
826:
827:
828:
829: 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);
830:
831: p_error_count := p_error_count + 1;
832:
833: IF (hxc_archive_restore_utils.check_max_errors(p_error_count) and p_all_errors=false )

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

853: l_validation_status := 'E';
854: l_count:=l_count+1;
855:
856: if(l_count=1) then
857: fnd_file.put_line(fnd_file.LOG,' ');
858: fnd_file.put_line(fnd_file.LOG,' ');
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

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

854: l_count:=l_count+1;
855:
856: if(l_count=1) then
857: fnd_file.put_line(fnd_file.LOG,' ');
858: fnd_file.put_line(fnd_file.LOG,' ');
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

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

855:
856: if(l_count=1) then
857: fnd_file.put_line(fnd_file.LOG,' ');
858: fnd_file.put_line(fnd_file.LOG,' ');
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

857: fnd_file.put_line(fnd_file.LOG,' ');
858: fnd_file.put_line(fnd_file.LOG,' ');
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
865: end if;

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

858: fnd_file.put_line(fnd_file.LOG,' ');
859: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
865: end if;
866:

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

860: fnd_message.set_name('HXC', 'HXC_LIST_ERROR_TC');
861: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
862: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
863: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
865: end if;
866:
867:
868: 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 868: 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);

864: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
865: end if;
866:
867:
868: 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);
869:
870: p_error_count := p_error_count + 1;
871:
872: IF (hxc_archive_restore_utils.check_max_errors(p_error_count) and p_all_errors=false )

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

904: l_count:=l_count+1;
905:
906: if(l_count=1)
907: then
908: fnd_file.put_line(fnd_file.LOG,' ');
909: fnd_file.put_line(fnd_file.LOG,' ');
910: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);

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

905:
906: if(l_count=1)
907: then
908: fnd_file.put_line(fnd_file.LOG,' ');
909: fnd_file.put_line(fnd_file.LOG,' ');
910: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
913: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');

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

906: if(l_count=1)
907: then
908: fnd_file.put_line(fnd_file.LOG,' ');
909: fnd_file.put_line(fnd_file.LOG,' ');
910: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
913: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');

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

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

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

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

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

911: fnd_message.set_name('HXC', 'HXC_LIST_NOT_NOTIFIED_TC');
912: fnd_file.put_line(fnd_file.LOG,' '||fnd_message.get);
913: fnd_file.put_line(fnd_file.LOG,'-------------------------------------------------------------- ');
914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
915: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
916: end if;
917:
918: fnd_file.put_line(fnd_file.LOG,
919: 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 918: fnd_file.put_line(fnd_file.LOG,

914: fnd_message.set_name('HXC', 'HXC_LISTING_HEADER_LINE');
915: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
916: end if;
917:
918: fnd_file.put_line(fnd_file.LOG,
919: 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);
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 986: --fnd_file.put_line(fnd_file.LOG,l_messages(l_messages.first).message_name);

982: p_row_lock_id => l_row_lock_id,
983: p_locked_success => l_lock_success
984: );
985:
986: --fnd_file.put_line(fnd_file.LOG,l_messages(l_messages.first).message_name);
987:
988: IF not(l_lock_success) THEN
989:
990: -- before returning let's unlock all the timecards that were locked

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

994: p_transaction_lock_id => p_data_set_id,
995: p_released_success => l_released_success
996: );
997:
998: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
999: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1000: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1001: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1002:

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

995: p_released_success => l_released_success
996: );
997:
998: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
999: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1000: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1001: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1002:
1003: RETURN;

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

996: );
997:
998: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
999: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1000: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1001: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1002:
1003: RETURN;
1004:

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

997:
998: fnd_file.put_line(fnd_file.LOG,'========== PROCESS STOPPED ================' );
999: fnd_file.put_line(fnd_file.LOG,'========== TIMECARD LOCKED ================' );
1000: fnd_file.put_line(fnd_file.LOG,'==> The resource id '||crs_lock_resource.resource_id||' has timecards locked for ');
1001: fnd_file.put_line(fnd_file.LOG,'==> the period from '||p_start_date||' to '||p_stop_date);
1002:
1003: RETURN;
1004:
1005: END IF;