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

Line 34: fnd_file.put_line(fnd_file.log,'no rows to process in CST_DEPT_OVERHEADS_INTERFACE, quiting....');

30: AND cdoi.process_flag = 1
31: AND rownum = 1;
32:
33: If l_cdoi_count = 0 then
34: fnd_file.put_line(fnd_file.log,'no rows to process in CST_DEPT_OVERHEADS_INTERFACE, quiting....');
35: return;
36: end If;
37:
38: fnd_file.put_line(fnd_file.log,'---------at the start of validating CST_DEPT_OVERHEADS_INTERFACE-------------');

Line 38: fnd_file.put_line(fnd_file.log,'---------at the start of validating CST_DEPT_OVERHEADS_INTERFACE-------------');

34: fnd_file.put_line(fnd_file.log,'no rows to process in CST_DEPT_OVERHEADS_INTERFACE, quiting....');
35: return;
36: end If;
37:
38: fnd_file.put_line(fnd_file.log,'---------at the start of validating CST_DEPT_OVERHEADS_INTERFACE-------------');
39:
40: /* check for both the organization_id and code to be null */
41: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
42: SET error_flag = 'E',

Line 50: fnd_file.put_line(fnd_file.log,'done checking for null org id and code');

46: AND cdoi.error_flag is null
47: AND cdoi.group_id = SEQ_NEXTVAL;
48:
49: l_stmt_no:=20;
50: fnd_file.put_line(fnd_file.log,'done checking for null org id and code');
51:
52: /* check to see if the input organization_id or code is valid */
53:
54: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 65: fnd_file.put_line(fnd_file.log,'done checking for invalid org id and code ');

61: where NVL(cdoi.organization_id,mp.organization_id) = mp.organization_id
62: AND NVL(cdoi.organization_code,mp.organization_code) = mp.organization_code);
63:
64: l_stmt_no := 30;
65: fnd_file.put_line(fnd_file.log,'done checking for invalid org id and code ');
66:
67: /*Get the Organization_id from the code */
68:
69: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 102: fnd_file.put_line(fnd_file.log,'done getting the org_id from the code if it is not provided');

98: ;
99: /* End OPM INVCONV changes */
100:
101: l_stmt_no := 40;
102: fnd_file.put_line(fnd_file.log,'done getting the org_id from the code if it is not provided');
103:
104: /* Set the unique transaction_id for each row */
105:
106: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 122: fnd_file.put_line(fnd_file.log,'done setting the transaction_id');

118:
119: COMMIT;
120:
121: l_stmt_no := 60;
122: fnd_file.put_line(fnd_file.log,'done setting the transaction_id');
123:
124: /* Now check for the organization to be a costing org */
125:
126: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 137: fnd_file.put_line(fnd_file.log,'done checking for the org to be a costing org');

133: WHERE mp.cost_organization_id <> mp.organization_id
134: AND mp.organization_id = cdoi.organization_id);
135:
136: l_stmt_no := 65;
137: fnd_file.put_line(fnd_file.log,'done checking for the org to be a costing org');
138:
139:
140:
141: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 150: fnd_file.put_line(fnd_file.log,'done setting the cost type ');

146: WHERE cdoi.group_id = SEQ_NEXTVAL
147: AND cdoi.error_flag is null;
148:
149: l_stmt_no := 70;
150: fnd_file.put_line(fnd_file.log,'done setting the cost type ');
151:
152: /* check for both department and department_id to be null */
153:
154: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 163: fnd_file.put_line(fnd_file.log,'done checking for null department ID and code');

159: AND cdoi.group_id = SEQ_NEXTVAL
160: AND (cdoi.department_id is null AND cdoi.department_code is null);
161:
162: l_stmt_no := 80;
163: fnd_file.put_line(fnd_file.log,'done checking for null department ID and code');
164:
165: /* check for overhead_id and overhead to be null */
166:
167: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 176: fnd_file.put_line(fnd_file.log,'done checking for overhead Id and code to be null');

172: AND cdoi.group_id = SEQ_NEXTVAL
173: AND (cdoi.overhead_id is null AND cdoi.overhead is null);
174:
175: l_stmt_no := 90;
176: fnd_file.put_line(fnd_file.log,'done checking for overhead Id and code to be null');
177:
178: l_stmt_no := 110;
179:
180: /* check for the entered department_id and department to be valid */

Line 195: fnd_file.put_line(fnd_file.log,'done checking for invalid department Id and code ');

191: AND cdoi.organization_id = bd.organization_id
192: );
193:
194: l_stmt_no := 120;
195: fnd_file.put_line(fnd_file.log,'done checking for invalid department Id and code ');
196:
197: /* Get the department_id from the department_code */
198:
199: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 209: fnd_file.put_line(fnd_file.log,'done setting the department ID from the department code if it has not been provided');

205: and cdoi.department_id is null
206: and cdoi.group_id = SEQ_NEXTVAL;
207:
208: l_stmt_no := 130;
209: fnd_file.put_line(fnd_file.log,'done setting the department ID from the department code if it has not been provided');
210:
211: /* check if the entered overhead_id or code is actually valid */
212: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set
213: error_flag = 'E',

Line 226: fnd_file.put_line(fnd_file.log,'done checking for invalid overhead ID and overhead');

222: AND cdoi.organization_id = bm.organization_id
223: );
224:
225: l_stmt_no := 140;
226: fnd_file.put_line(fnd_file.log,'done checking for invalid overhead ID and overhead');
227:
228: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
229: set cdoi.overhead_id = (select bm.resource_id from bom_resources bm
230: WHERE cdoi.overhead = bm.resource_code

Line 239: fnd_file.put_line(fnd_file.log,'done setting the overhead ID from the code if it has not been provided');

235: and cdoi.overhead_id is null
236: and cdoi.group_id = SEQ_NEXTVAL;
237:
238: l_stmt_no := 150;
239: fnd_file.put_line(fnd_file.log,'done setting the overhead ID from the code if it has not been provided');
240:
241: /* check for the overhead_id to be within the validity date */
242:
243: Update CST_DEPT_OVERHEADS_INTERFACE cdoi

Line 255: fnd_file.put_line(fnd_file.log,'done checking for the validity date and allow costs flag of the overhead');

251: AND bm.resource_id = cdoi.overhead_id
252: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));
253:
254:
255: fnd_file.put_line(fnd_file.log,'done checking for the validity date and allow costs flag of the overhead');
256:
257: l_stmt_no := 155;
258:
259: /* check for the basis type to be between 1 and 6 */

Line 270: fnd_file.put_line(fnd_file.log,'done checking for the basis type flag to be valid');

266: AND cdoi.group_id = SEQ_NEXTVAL
267: AND (cdoi.basis_type < 1 OR cdoi.basis_type > 4);
268:
269: l_stmt_no := 160;
270: fnd_file.put_line(fnd_file.log,'done checking for the basis type flag to be valid');
271:
272: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set
273: error_flag = 'E',
274: error_code = 'CST_INVALID_RESRATE',

Line 281: fnd_file.put_line(fnd_file.log,'done checking for null resource rates');

277: and cdoi.group_id = SEQ_NEXTVAL
278: and cdoi.rate_or_amount is null;
279:
280: l_stmt_no := 170;
281: fnd_file.put_line(fnd_file.log,'done checking for null resource rates');
282:
283: /* checking for the validity of activity id and name if provided */
284:
285: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set

Line 309: fnd_file.put_line(fnd_file.log,'done checking for validity of activity id');

305: and cdoi.activity is not null
306: and cdoi.error_flag is null
307: AND cdoi.group_id = SEQ_NEXTVAL;
308:
309: fnd_file.put_line(fnd_file.log,'done checking for validity of activity id');
310: l_stmt_no := 180;
311:
312:
313: Update CST_DEPT_OVERHEADS_INTERFACE

Line 337: fnd_file.put_line(fnd_file.log,'done checking for duplicate rows');

333: AND cdoi2.overhead_id = cdoi.overhead_id
334: AND cdoi2.group_id = SEQ_NEXTVAL
335: AND cdoi2.rowid <> cdoi.rowid);
336:
337: fnd_file.put_line(fnd_file.log,'done checking for duplicate rows');
338:
339: Update CST_DEPT_OVERHEADS_INTERFACE
340: set process_flag = 4
341: where process_flag = 3

Line 382: fnd_file.put_line(fnd_file.log,'done deleting or erroring out rows as per run option');

378: AND cdoi.group_id = SEQ_NEXTVAL
379: );
380: end if;
381:
382: fnd_file.put_line(fnd_file.log,'done deleting or erroring out rows as per run option');
383:
384: l_stmt_no := 195;
385:
386: INSERT INTO CST_DEPARTMENT_OVERHEADS(Department_id,

Line 451: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) || ' rows into the base table CST_DEPARTMENT_OVERHEADS');

447: sysdate
448: FROM CST_DEPT_OVERHEADS_INTERFACE cdoi
449: WHERE cdoi.error_flag is null
450: AND cdoi.group_id = SEQ_NEXTVAL;
451: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) || ' rows into the base table CST_DEPARTMENT_OVERHEADS');
452:
453: l_stmt_no := 200;
454:
455: Update CST_DEPT_OVERHEADS_INTERFACE set

Line 467: fnd_file.put_line(fnd_file.log,'done deleting ' || to_char(SQL%ROWCOUNT) ||' rows that were sucessfully processed');

463: WHERE error_flag is null
464: AND group_id = SEQ_NEXTVAL
465: AND process_flag = 5;
466:
467: fnd_file.put_line(fnd_file.log,'done deleting ' || to_char(SQL%ROWCOUNT) ||' rows that were sucessfully processed');
468: END IF;
469:
470: COMMIT;
471:

Line 475: fnd_file.put_line(fnd_file.log,'Validate_department_overheads('|| to_char(l_stmt_no) || '),'|| to_char(SQLCODE) || ',' || substr(SQLERRM,1.180));

471:
472: EXCEPTION
473: when others then
474: rollback;
475: fnd_file.put_line(fnd_file.log,'Validate_department_overheads('|| to_char(l_stmt_no) || '),'|| to_char(SQLCODE) || ',' || substr(SQLERRM,1.180));
476:
477: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
478: Error_number := 1;
479: END Validate_Department_overheads;

Line 512: fnd_file.put_line(fnd_file.log,'no rows to process in CST_RES_OVERHEADS_INTERFACE, quitting.........');

508: AND croi.process_flag = 1
509: AND rownum = 1;
510:
511: If l_croi_count = 0 then
512: fnd_file.put_line(fnd_file.log,'no rows to process in CST_RES_OVERHEADS_INTERFACE, quitting.........');
513: return;
514: end IF;
515:
516: /* check for both the organization_id and code to be null */

Line 518: fnd_file.put_line(fnd_file.log,'--------at the start of validating CST_RES_OVERHEADS_INTERFACE table-------');

514: end IF;
515:
516: /* check for both the organization_id and code to be null */
517:
518: fnd_file.put_line(fnd_file.log,'--------at the start of validating CST_RES_OVERHEADS_INTERFACE table-------');
519:
520: Update CST_RES_OVERHEADS_INTERFACE croi
521: SET error_flag = 'E',
522: error_code = 'CST_NULL_ORGANIZATION',

Line 529: fnd_file.put_line(fnd_file.log,'done checking for null org Id and code ');

525: AND error_flag is null
526: AND croi.group_id = SEQ_NEXTVAL;
527:
528: l_stmt_no := 20;
529: fnd_file.put_line(fnd_file.log,'done checking for null org Id and code ');
530:
531: /* check to see if the input organization_id or code is valid */
532:
533: Update CST_RES_OVERHEADS_INTERFACE croi

Line 544: fnd_file.put_line(fnd_file.log,'done checking for invalid organization ID and code');

540: where NVL(croi.organization_id,mp.organization_id) = mp.organization_id
541: AND NVL(croi.organization_code,mp.organization_code) = mp.organization_code);
542:
543: l_stmt_no := 30;
544: fnd_file.put_line(fnd_file.log,'done checking for invalid organization ID and code');
545:
546: /*Get the Organization_id from the code */
547:
548: Update CST_RES_OVERHEADS_INTERFACE croi

Line 559: fnd_file.put_line(fnd_file.log,'done setting the organization_ID from the code if it has not been set already');

555: AND croi.error_flag is null
556: AND croi.group_id = SEQ_NEXTVAL;
557:
558: l_stmt_no := 40;
559: fnd_file.put_line(fnd_file.log,'done setting the organization_ID from the code if it has not been set already');
560:
561: /* Set the unique transaction_id for each row */
562:
563: Update CST_RES_OVERHEADS_INTERFACE croi

Line 577: fnd_file.put_line(fnd_file.log,'done setting the transaction ID');

573: AND croi.process_flag = 1
574: AND group_id=SEQ_NEXTVAL;
575:
576: l_stmt_no := 70;
577: fnd_file.put_line(fnd_file.log,'done setting the transaction ID');
578:
579: COMMIT;
580: l_stmt_no := 75;
581: /* Now check for the organization to be a costing org */

Line 596: fnd_file.put_line(fnd_file.log,'done checking for the org to be costing org or not');

592:
593: /* Insert the new cost type into cst_cost_types and assign the new cost types to all the rows */
594:
595: l_stmt_no := 77;
596: fnd_file.put_line(fnd_file.log,'done checking for the org to be costing org or not');
597:
598:
599: Update CST_RES_OVERHEADS_INTERFACE croi
600: SET croi.cost_type_id = (select cost_type_id from CST_COST_TYPES cct

Line 608: fnd_file.put_line(fnd_file.log,'done setting the cost type');

604: WHERE croi.group_id = SEQ_NEXTVAL
605: AND croi.error_flag is null;
606:
607: l_stmt_no := 80;
608: fnd_file.put_line(fnd_file.log,'done setting the cost type');
609:
610: /* check for overhead_id and overhead to be null */
611:
612: Update CST_RES_OVERHEADS_INTERFACE croi

Line 621: fnd_file.put_line(fnd_file.log,'done checking for the overhead ID and code to be null');

617: AND croi.group_id = SEQ_NEXTVAL
618: AND (croi.overhead_id is null AND croi.overhead is null);
619:
620: l_stmt_no := 90;
621: fnd_file.put_line(fnd_file.log,'done checking for the overhead ID and code to be null');
622:
623: /* check for resource_id and reource_codes to be null */
624:
625: Update CST_RES_OVERHEADS_INTERFACE croi

Line 634: fnd_file.put_line(fnd_file.log,'done checking for the subelement ID and code to be null');

630: AND croi.group_id = SEQ_NEXTVAL
631: AND (croi.resource_id is null AND croi.resource_code is null);
632:
633: l_stmt_no := 100;
634: fnd_file.put_line(fnd_file.log,'done checking for the subelement ID and code to be null');
635:
636: /* check if the entered resource_id or code is actually valid */
637: Update CST_RES_OVERHEADS_INTERFACE croi set
638: error_flag = 'E',

Line 651: fnd_file.put_line(fnd_file.log,'done checking for the sub element to be valid or not');

647: AND croi.organization_id = bm.organization_id
648: );
649:
650: l_stmt_no := 130;
651: fnd_file.put_line(fnd_file.log,'done checking for the sub element to be valid or not');
652:
653: /* Get the resource_id from the resource_code */
654:
655: Update CST_RES_OVERHEADS_INTERFACE croi

Line 666: fnd_file.put_line(fnd_file.log,'done setting the subelement ID from the code if it has not been provided');

662: and croi.resource_id is null
663: and croi.group_id = SEQ_NEXTVAL;
664:
665: l_stmt_no := 140;
666: fnd_file.put_line(fnd_file.log,'done setting the subelement ID from the code if it has not been provided');
667:
668: /* check for the validty_date for the resource_id */
669: Update CST_RES_OVERHEADS_INTERFACE croi
670: set croi.error_flag = 'E',

Line 680: fnd_file.put_line(fnd_file.log,'done checking for the validity date and allow costs flag of resource ID');

676: WHERE bm.organization_id = croi.organization_id
677: AND bm.resource_id = croi.resource_id
678: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));
679:
680: fnd_file.put_line(fnd_file.log,'done checking for the validity date and allow costs flag of resource ID');
681: l_stmt_no := 145;
682: /* check if the entered overhead_id or overhead is actually valid */
683: Update CST_RES_OVERHEADS_INTERFACE croi set
684: error_flag = 'E',

Line 697: fnd_file.put_line(fnd_file.log,'done checking for invalid overhead');

693: AND croi.organization_id = bm.organization_id
694: );
695:
696: l_stmt_no := 150;
697: fnd_file.put_line(fnd_file.log,'done checking for invalid overhead');
698:
699: /* Get the overhead_id from the overhead */
700:
701: Update CST_RES_OVERHEADS_INTERFACE croi

Line 712: fnd_file.put_line(fnd_file.log,'done getting the overhead id from the overhead if it has not been provided');

708: and croi.overhead_id is null
709: and croi.group_id = SEQ_NEXTVAL;
710:
711: l_stmt_no := 160;
712: fnd_file.put_line(fnd_file.log,'done getting the overhead id from the overhead if it has not been provided');
713:
714: /* now check for the validity date of the overhead */
715: Update CST_RES_OVERHEADS_INTERFACE croi
716: set croi.error_flag='E',

Line 726: fnd_file.put_line(fnd_file.log,'done checking for the validity date and allow costs flag of the overhead');

722: WHERE bm.organization_id = croi.organization_id
723: AND bm.resource_id = croi.overhead_id
724: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2))) ;
725:
726: fnd_file.put_line(fnd_file.log,'done checking for the validity date and allow costs flag of the overhead');
727: l_stmt_no := 165;
728: /*end of phase 1 so commit */
729:
730: Update CST_RES_OVERHEADS_INTERFACE croi

Line 755: fnd_file.put_line(fnd_file.log,'done checking for the duplicate rows');

751: AND croi2.rowid <> croi.rowid
752: AND croi2.group_id = SEQ_NEXTVAL
753: );
754:
755: fnd_file.put_line(fnd_file.log,'done checking for the duplicate rows');
756:
757: Update CST_RES_OVERHEADS_INTERFACE croi
758: set croi.process_flag = 4
759: where croi.process_flag = 3

Line 798: fnd_file.put_line(fnd_file.log,'done deleting or erroring out rows as per run option');

794: AND croi.group_id = SEQ_NEXTVAL
795: );
796: end if;
797:
798: fnd_file.put_line(fnd_file.log,'done deleting or erroring out rows as per run option');
799:
800: l_stmt_no := 175;
801:
802: INSERT INTO CST_RESOURCE_OVERHEADS(cost_type_id,

Line 861: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) || ' rows into CST_RESOURCE_OVERHEADS');

857: attribute15
858: FROM CST_RES_OVERHEADS_INTERFACE croi
859: where croi.error_flag is null
860: AND group_id = SEQ_NEXTVAL;
861: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) || ' rows into CST_RESOURCE_OVERHEADS');
862:
863: l_stmt_no := 180;
864:
865: Update CST_RES_OVERHEADS_INTERFACE croi

Line 877: fnd_file.put_line(fnd_file.log,'done deleting ' || to_char(SQL%ROWCOUNT) || ' row that were sucessfully processed' );

873: WHERE error_flag is null
874: AND group_id = SEQ_NEXTVAL
875: AND process_flag = 5;
876:
877: fnd_file.put_line(fnd_file.log,'done deleting ' || to_char(SQL%ROWCOUNT) || ' row that were sucessfully processed' );
878: END IF;
879: COMMIT;
880:
881: fnd_file.put_line(fnd_file.log,'-------done, quitting validate resource overheads----------');

Line 881: fnd_file.put_line(fnd_file.log,'-------done, quitting validate resource overheads----------');

877: fnd_file.put_line(fnd_file.log,'done deleting ' || to_char(SQL%ROWCOUNT) || ' row that were sucessfully processed' );
878: END IF;
879: COMMIT;
880:
881: fnd_file.put_line(fnd_file.log,'-------done, quitting validate resource overheads----------');
882:
883: EXCEPTION
884: when others then
885: rollback;

Line 886: fnd_file.put_line(fnd_file.log,'Validate_resource_overheads('|| to_char(l_stmt_no)|| '),'||to_char(SQLCODE)||',' || substr(SQLERRM,1,180));

882:
883: EXCEPTION
884: when others then
885: rollback;
886: fnd_file.put_line(fnd_file.log,'Validate_resource_overheads('|| to_char(l_stmt_no)|| '),'||to_char(SQLCODE)||',' || substr(SQLERRM,1,180));
887: Error_number := 1;
888:
889: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
890: END Validate_Resource_overheads;

Line 940: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CDOI')));

936: where group_id = i_grp_id
937: and error_flag = 'E';
938:
939: if i_count > 0 then
940: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CDOI')));
941: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
942: END IF;
943:
944: Select count(*) into i_count from CST_RES_OVERHEADS_INTERFACE

Line 949: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CROI')));

945: where group_id = i_grp_id
946: and error_flag = 'E';
947:
948: if i_count > 0 then
949: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CROI')));
950: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
951: END IF;
952:
953: EXCEPTION

Line 956: fnd_file.put_line(fnd_file.log,'Start_process() Exception Occured');

952:
953: EXCEPTION
954: when others then
955: rollback;
956: fnd_file.put_line(fnd_file.log,'Start_process() Exception Occured');
957: Error_number := 1;
958:
959: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
960: