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_ITEM_COST_IMPORT_INTERFACE dependencies on FND_FILE

Line 25: fnd_file.put_line(fnd_file.log, '---------start of the concurrent program for validating CICDI-------------');

21: /* This part populates the Organization_id if it has not been provided by
22: the user.There will be a check done to see if the user has not entered both of t
23: hem */
24:
25: fnd_file.put_line(fnd_file.log, '---------start of the concurrent program for validating CICDI-------------');
26:
27: l_stmt_no := 10;
28:
29: Update CST_ITEM_CST_DTLS_INTERFACE ct

Line 55: fnd_file.put_line(fnd_file.log, 'after checking for organization_id validity');

51: );
52:
53: l_stmt_no := 30;
54:
55: fnd_file.put_line(fnd_file.log, 'after checking for organization_id validity');
56:
57: /* Select the corresponding organization_id from mtl_parameters given the
58: organization code.*/
59:

Line 110: fnd_file.put_line(fnd_file.log,'after assigning the transaction_id');

106:
107: commit;
108:
109: l_stmt_no := 60;
110: fnd_file.put_line(fnd_file.log,'after assigning the transaction_id');
111:
112: /* check for the organization to be a costing organization */
113:
114: UPDATE CST_ITEM_CST_DTLS_INTERFACE ct

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

121: WHERE mp.cost_organization_id <> mp.organization_id
122: AND mp.organization_id = ct.organization_id );
123:
124: l_stmt_no := 61;
125: fnd_file.put_line(fnd_file.log,'done checking for the org to be costing org');
126:
127: /* check to see if the user has input a valid inventory_item_id */
128: Update CST_ITEM_CST_DTLS_INTERFACE ct set
129: error_flag = 'E',

Line 138: fnd_file.put_line(fnd_file.log,'done checking for null item_id');

134: AND inventory_item_id is null;
135:
136: l_stmt_no := 62;
137:
138: fnd_file.put_line(fnd_file.log,'done checking for null item_id');
139:
140: /* check to see if the user has input a valid inventory_item_id */
141: Update CST_ITEM_CST_DTLS_INTERFACE ct set
142: error_flag = 'E',

Line 151: fnd_file.put_line(fnd_file.log,'done checking for invalid inventory_item_id');

147: AND NOT EXISTS (select 1 from mtl_system_items msi
148: where ct.organization_id = msi.organization_id
149: AND ct.inventory_item_id = msi.inventory_item_id
150: );
151: fnd_file.put_line(fnd_file.log,'done checking for invalid inventory_item_id');
152: l_stmt_no := 63;
153:
154: /* Now call the function to set the defaults for the CIC flags */
155:

Line 178: fnd_file.put_line(fnd_file.log,'done checking for the inventory_asset flag');

174: and msi.inventory_asset_flag = 'N'
175: ));
176:
177: l_stmt_no := 66;
178: fnd_file.put_line(fnd_file.log,'done checking for the inventory_asset flag');
179:
180:
181: l_stmt_no := 70;
182:

Line 196: fnd_file.put_line(fnd_file.log,'after checking for cost element for null');

192: AND error_flag is null;
193:
194: l_stmt_no := 90;
195:
196: fnd_file.put_line(fnd_file.log,'after checking for cost element for null');
197:
198:
199: /* Check to see if a valid cost_element has been provided.If only the cost_element_name is provided then, fill up the id */
200:

Line 222: fnd_file.put_line(fnd_file.log,'done checking for cost elements validity and picking up the cost element id if it has not been defined');

218: AND ct.error_flag is null;
219:
220: l_stmt_no := 150;
221:
222: fnd_file.put_line(fnd_file.log,'done checking for cost elements validity and picking up the cost element id if it has not been defined');
223:
224:
225: /*----------Checking for sub elements validity--------------------------*/
226: /* There is a special case when checking for the resource id validation.*/

Line 262: fnd_file.put_line(fnd_file.log,'done checking for validity of resource_id and picking it up if it has not been supplied');

258:
259:
260: l_stmt_no := 170;
261:
262: fnd_file.put_line(fnd_file.log,'done checking for validity of resource_id and picking it up if it has not been supplied');
263:
264: /* Checking for the validity of Activity ID and Activity name if provided */
265:
266: Update CST_ITEM_CST_DTLS_INTERFACE ct set

Line 289: fnd_file.put_line(fnd_file.log,'done checking for activity ID and assigning it');

285: AND ct.activity is not null
286: AND ct.error_flag is null
287: AND ct.group_id = SEQ_NEXTVAL;
288:
289: fnd_file.put_line(fnd_file.log,'done checking for activity ID and assigning it');
290:
291: l_stmt_no := 180;
292:
293:

Line 305: fnd_file.put_line(fnd_file.log,'done assigning default sub elements');

301: AND (ct.resource_id is null AND ct.resource_code is null);
302:
303: l_stmt_no := 190;
304:
305: fnd_file.put_line(fnd_file.log,'done assigning default sub elements');
306:
307: /* if the resource_id is still null,then that means the user has not provided
308: a default sub element that is necessary */
309:

Line 334: fnd_file.put_line(fnd_file.log,'done checking for the disable_date and allow_costs_flag for the resource');

330: AND bm.cost_element_id = ct.cost_element_id
331: AND bm.resource_id = ct.resource_id
332: AND ((sysdate >= NVL(bm.disable_date,sysdate+1)) OR (bm.allow_costs_flag = 2)));
333:
334: fnd_file.put_line(fnd_file.log,'done checking for the disable_date and allow_costs_flag for the resource');
335: l_stmt_no := 205;
336:
337: /* at this point we have validated org_id,cost_type,cost element,resource
338: ,inventory_item.We will now have to check if the functional currency flag =1

Line 357: fnd_file.put_line(fnd_file.log,'done checking for functional currency flag');

353: );
354:
355: l_stmt_no := 210;
356:
357: fnd_file.put_line(fnd_file.log,'done checking for functional currency flag');
358:
359:
360: /* set The process_flag to 2 */
361:

Line 370: fnd_file.put_line(fnd_file.log,'done with validations for first phase of CICDI');

366: AND process_flag = 2;
367:
368: l_stmt_no := 230;
369:
370: fnd_file.put_line(fnd_file.log,'done with validations for first phase of CICDI');
371:
372: COMMIT;
373:
374: EXCEPTION

Line 379: fnd_file.put_line(fnd_file.log,'CICDI validate_phase1(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));

375:
376: when others then
377: rollback;
378: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
379: fnd_file.put_line(fnd_file.log,'CICDI validate_phase1(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
380: Error_number := 1;
381:
382: END validate_phase1;
383:

Line 394: fnd_file.put_line(fnd_file.log,'------------Start of the second phase for CICDI-----------');

390: BEGIN
391:
392: Error_number := 0;
393:
394: fnd_file.put_line(fnd_file.log,'------------Start of the second phase for CICDI-----------');
395:
396:
397: SEQ_NEXTVAL := i_group_id;
398: /* This statement will check for the rollup_source_type flag to be 1 */

Line 421: fnd_file.put_line(fnd_file.log,'done checking for level_type flag to be 1 ');

417: where level_type <> 1
418: AND ct.error_flag is null
419: AND ct.group_id = SEQ_NEXTVAL;
420:
421: fnd_file.put_line(fnd_file.log,'done checking for level_type flag to be 1 ');
422:
423: l_stmt_no := 11;
424:
425: /* checking for the Usage rate or amount to be not null */

Line 434: fnd_file.put_line(fnd_file.log,'done checking for null usage rate');

430: where error_flag is null
431: AND Usage_rate_or_amount is null
432: AND group_id = SEQ_NEXTVAL;
433:
434: fnd_file.put_line(fnd_file.log,'done checking for null usage rate');
435:
436: /*This statement checks for the validity of basis types.
437: FOr any other basis type other than material overhead, the only basis types allowed are item and lot.
438: But for material Overhead all 6 basis types allowed.This is inkeeping with the way the form works today.

Line 451: fnd_file.put_line(fnd_file.log,'done checking for basis types');

447: where ((ct.cost_element_id IN (1,3,4,5,6) AND ct.basis_type NOT IN (1,2)) OR (ct.cost_element_id = 2 AND (ct.basis_type <= 0 OR ct.basis_type > 6)))
448: AND ct.error_flag is null
449: AND ct.group_id = SEQ_NEXTVAL;
450:
451: fnd_file.put_line(fnd_file.log,'done checking for basis types');
452:
453: /* If the basis type is activity, then check if the item_units and activity_units are provided */
454:
455: l_stmt_no := 13;

Line 466: fnd_file.put_line(fnd_file.log,'done checking for item units and activity units');

462: AND (ct.activity_units is null OR ct.item_units is null OR ct.item_units = 0)
463: AND ct.error_flag is null
464: AND ct.group_id = SEQ_NEXTVAL;
465:
466: fnd_file.put_line(fnd_file.log,'done checking for item units and activity units');
467:
468: l_stmt_no := 14;
469: /*this statement checks for the shrinkage rate value to be between 0 and 1 */
470:

Line 479: fnd_file.put_line(fnd_file.log,'done checking for shrinkage rate to be between 0 and 1');

475: where (ct.shrinkage_rate < 0 OR ct.shrinkage_rate >= 1)
476: AND ct.error_flag is null
477: AND ct.group_id = SEQ_NEXTVAL;
478:
479: fnd_file.put_line(fnd_file.log,'done checking for shrinkage rate to be between 0 and 1');
480: l_stmt_no := 15;
481:
482: /* check for the lot_size to be > 0 */
483: Update CST_ITEM_CST_DTLS_INTERFACE ct set

Line 501: fnd_file.put_line(fnd_file.log,'done checking for based on rollup flag');

497: AND ct.error_flag is null
498: AND ct.group_id = SEQ_NEXTVAL;
499:
500: l_stmt_no := 16;
501: fnd_file.put_line(fnd_file.log,'done checking for based on rollup flag');
502:
503: /* this checks for the inventory asset flag to be 1 or 2 */
504: Update CST_ITEM_CST_DTLS_INTERFACE ct set
505: error_flag = 'E',

Line 513: fnd_file.put_line(fnd_file.log,'done checking for inv asset flag to be 1 or 2');

509: AND ct.error_flag is null
510: AND ct.group_id = SEQ_NEXTVAL;
511:
512: l_stmt_no := 18;
513: fnd_file.put_line(fnd_file.log,'done checking for inv asset flag to be 1 or 2');
514:
515: UPDATE CST_ITEM_CST_DTLS_INTERFACE set
516: error_flag = 'E',
517: error_code = 'CST_INVALID_RESRATE',

Line 523: fnd_file.put_line(fnd_file.log, 'done checking for resource rate to be 1 or null');

519: where error_flag is null
520: AND group_id = SEQ_NEXTVAL
521: AND ((resource_rate <> 1) AND (resource_rate is not null));
522:
523: fnd_file.put_line(fnd_file.log, 'done checking for resource rate to be 1 or null');
524:
525: /* this statement checks for the based_on_rollup flag to be set if there is a shrinkage rate mentioned*/
526:
527: Update CST_ITEM_CST_DTLS_INTERFACE ct set

Line 536: fnd_file.put_line(fnd_file.log,'done checking for the based on rollup flag and shrinkage rate');

532: AND ct.shrinkage_rate <> 0
533: AND ct.error_flag is null
534: AND ct.group_id = SEQ_NEXTVAL;
535:
536: fnd_file.put_line(fnd_file.log,'done checking for the based on rollup flag and shrinkage rate');
537:
538: l_stmt_no := 20;
539: /* this statement checks for the same "based_on_rollup_flag, shrinkage_rate,inventory_asset_flag" to be populated for all the rows of the same item,org,cost type combo */
540:

Line 561: fnd_file.put_line(fnd_file.log,'done checking for the 4 flags to match for all the rows of the same item,org,cost type combo');

557: AND ct1.error_flag is null;
558:
559: l_stmt_no := 30;
560:
561: fnd_file.put_line(fnd_file.log,'done checking for the 4 flags to match for all the rows of the same item,org,cost type combo');
562:
563: /* Error out all those rows for that particular item,org,cost type combination
564: that already have rows that are errored out */
565:

Line 580: fnd_file.put_line(fnd_file.log,'done erroring out rows for the same item,org,cost type combo if even one of them has errored out');

576: AND ct2.group_id = SEQ_NEXTVAL)
577: AND ct1.error_flag is null
578: AND ct1.group_id = SEQ_NEXTVAL;
579:
580: fnd_file.put_line(fnd_file.log,'done erroring out rows for the same item,org,cost type combo if even one of them has errored out');
581:
582: l_stmt_no := 40;
583:
584: Update CST_ITEM_CST_DTLS_INTERFACE set

Line 596: fnd_file.put_line(fnd_file.log,'CICDI table validate_phase2(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));

592: EXCEPTION
593:
594: when others then
595: rollback;
596: fnd_file.put_line(fnd_file.log,'CICDI table validate_phase2(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
597:
598: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
599: Error_number := 1;
600:

Line 621: fnd_file.put_line(fnd_file.log,'-------------at the start of insert_csttype_and_def procedure-----------');

617: l_stmt_no := 10;
618:
619: Error_number := 0;
620:
621: fnd_file.put_line(fnd_file.log,'-------------at the start of insert_csttype_and_def procedure-----------');
622:
623: Select default_cost_type_id into l_def_cost_type_id from cst_cost_types
624: where cost_type = i_new_csttype;
625:

Line 640: fnd_file.put_line(fnd_file.log,'done updating the interface table with the new cost type');

636: ct.cost_type = i_new_csttype
637: where error_flag is null
638: and group_id = SEQ_NEXTVAL;
639:
640: fnd_file.put_line(fnd_file.log,'done updating the interface table with the new cost type');
641: l_stmt_no := 30;
642:
643: /*check for the default cost type to be valid for all the or/item combo */
644: Update CST_ITEM_CST_DTLS_INTERFACE ct set

Line 657: fnd_file.put_line(fnd_file.log,'done checking for the default cost type to be valid');

653: and cic.cost_type_id = l_def_cost_type_id
654: and ct.inventory_item_id = cic.inventory_item_id)
655: AND (ct.lot_size is null OR ct.based_on_rollup_flag is null OR shrinkage_rate is null OR inventory_asset_flag is null) ;
656:
657: fnd_file.put_line(fnd_file.log,'done checking for the default cost type to be valid');
658: l_stmt_no := 40;
659:
660: /* now set the defaults for rollup_src_type,basis_type,resource_rate and level_type */
661:

Line 671: fnd_file.put_line(fnd_file.log,'done setting the defaults for the first level ');

667: where error_flag is null
668: and group_id= SEQ_NEXTVAL
669: and (rollup_source_type is null OR basis_type is null OR resource_rate is null OR level_type is null);
670:
671: fnd_file.put_line(fnd_file.log,'done setting the defaults for the first level ');
672: l_stmt_no := 50;
673:
674: /* now set the defaults from cic for the CIC columns */
675:

Line 690: fnd_file.put_line(fnd_file.log,'done setting the defaults for the CIC columns');

686: WHERE ct.error_flag is null
687: AND ct.group_id = SEQ_NEXTVAL
688: AND (ct.lot_size is null OR ct.based_on_rollup_flag is null OR ct.inventory_asset_flag is null OR ct.shrinkage_rate is null);
689:
690: fnd_file.put_line(fnd_file.log,'done setting the defaults for the CIC columns');
691:
692: EXCEPTION
693: when others then
694: rollback;

Line 695: fnd_file.put_line(fnd_file.log,'CICDI insert_csttype_and_def('|| to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));

691:
692: EXCEPTION
693: when others then
694: rollback;
695: fnd_file.put_line(fnd_file.log,'CICDI insert_csttype_and_def('|| to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
696:
697: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
698: Error_number := 1;
699:

Line 720: fnd_file.put_line(fnd_file.log,'---------------entered the insert_cic_cicd procedure-----------------');

716: Error_number := 0;
717:
718: /*first get the net_yield and basis_factor and update the interface tables */
719:
720: fnd_file.put_line(fnd_file.log,'---------------entered the insert_cic_cicd procedure-----------------');
721:
722: /* The following statement sets the basis factor and net_yield_or_shrinkage_factor.
723: The basis factor will be set to values like the form does today in the applications */
724:

Line 733: fnd_file.put_line(fnd_file.log,'done setting the basis factor for basis type 1,2 and 6');

729: and basis_type IN (1,2,6);
730:
731: l_stmt_no := 11;
732:
733: fnd_file.put_line(fnd_file.log,'done setting the basis factor for basis type 1,2 and 6');
734:
735: /* Updating the basis factor for mat overhead cost element, sub element "resource unit"*/
736:
737: Update CST_ITEM_CST_DTLS_INTERFACE cicdi1 set

Line 757: fnd_file.put_line(fnd_file.log,'done setting the basis factor for basis type of 3 (resource unit)');

753: AND cicdi1.cost_element_id=2;
754:
755: l_stmt_no := 12;
756:
757: fnd_file.put_line(fnd_file.log,'done setting the basis factor for basis type of 3 (resource unit)');
758:
759:
760: Update CST_ITEM_CST_DTLS_INTERFACE CICDI set
761: net_yield_or_shrinkage_factor = Decode(basis_type,1,(1/(1-shrinkage_rate)),2,(1/(1-shrinkage_rate)),3,(1/(1-shrinkage_rate)),1)

Line 765: fnd_file.put_line(fnd_file.log,'done setting shrinkage factor');

761: net_yield_or_shrinkage_factor = Decode(basis_type,1,(1/(1-shrinkage_rate)),2,(1/(1-shrinkage_rate)),3,(1/(1-shrinkage_rate)),1)
762: where error_flag is null
763: and group_id = SEQ_NEXTVAL;
764:
765: fnd_file.put_line(fnd_file.log,'done setting shrinkage factor');
766: l_stmt_no :=20;
767:
768: /* now calculate the item cost for each row for basis */
769:

Line 778: fnd_file.put_line(fnd_file.log,'done setting the item cost for basis types 1,2,3 and 6');

774: and group_id = SEQ_NEXTVAL;
775:
776: l_stmt_no := 22;
777:
778: fnd_file.put_line(fnd_file.log,'done setting the item cost for basis types 1,2,3 and 6');
779:
780: /*Now calculate the basis factor and item cost for resource value */
781:
782: Update CST_ITEM_CST_DTLS_INTERFACE cicdi1

Line 802: fnd_file.put_line(fnd_file.log,'done setting the basis factor and item cost for basis type resource value ');

798: AND cicdi1.basis_type = 4
799: AND cicdi1.cost_element_id = 2;
800:
801: l_stmt_no := 23;
802: fnd_file.put_line(fnd_file.log,'done setting the basis factor and item cost for basis type resource value ');
803:
804: /* Now calculate the basis factor and item cost for total value based */
805:
806: Update CST_ITEM_CST_DTLS_INTERFACE cicdi1

Line 822: fnd_file.put_line(fnd_file.log,'done calculating the item cost and basis factor for total value basis type');

818: AND cicdi1.basis_type = 5
819: AND cicdi1.cost_element_id = 2;
820:
821:
822: fnd_file.put_line(fnd_file.log,'done calculating the item cost and basis factor for total value basis type');
823: l_stmt_no := 30;
824: /* Now insert first into cst_item_costs */
825:
826: /* here we check for the run option.If it is insert only mode, we error out those rows for which rows already exist in CIC for the same item,org,cost type combo.For rem and replace mode, we just delete off all the existing rows and proceed */

Line 858: fnd_file.put_line(fnd_file.log,'done checking for the run option and deleting or erroring out rows accordingly');

854: AND ct.cost_type_id = cic.cost_type_id
855: AND ct.inventory_item_id = cic.inventory_item_id);
856: END IF;
857:
858: fnd_file.put_line(fnd_file.log,'done checking for the run option and deleting or erroring out rows accordingly');
859:
860: l_stmt_no := 35;
861:
862: Insert into CST_ITEM_COSTS (Inventory_item_id,

Line 939: fnd_file.put_line(fnd_file.log,'after the insert into CIC');

935: WHERE error_flag is null
936: AND group_id = SEQ_NEXTVAL
937: group by organization_id,inventory_item_id,cost_type_id,based_on_rollup_flag,shrinkage_rate,lot_size,inventory_asset_flag;
938:
939: fnd_file.put_line(fnd_file.log,'after the insert into CIC');
940: fnd_file.put_line(fnd_file.log,'sucessfully completed inserting ' || to_char(SQL%ROWCOUNT)|| ' rows into cic');
941: l_stmt_no := 40;
942:
943: /* Now insert into CICD */

Line 940: fnd_file.put_line(fnd_file.log,'sucessfully completed inserting ' || to_char(SQL%ROWCOUNT)|| ' rows into cic');

936: AND group_id = SEQ_NEXTVAL
937: group by organization_id,inventory_item_id,cost_type_id,based_on_rollup_flag,shrinkage_rate,lot_size,inventory_asset_flag;
938:
939: fnd_file.put_line(fnd_file.log,'after the insert into CIC');
940: fnd_file.put_line(fnd_file.log,'sucessfully completed inserting ' || to_char(SQL%ROWCOUNT)|| ' rows into cic');
941: l_stmt_no := 40;
942:
943: /* Now insert into CICD */
944:

Line 1031: fnd_file.put_line(fnd_file.log,'sucessfully completed inserting ' || to_char(SQL%ROWCOUNT)|| ' rows into cicd');

1027: FROM CST_ITEM_CST_DTLS_INTERFACE ct
1028: WHERE ct.error_flag is null
1029: and ct.group_id = SEQ_NEXTVAL;
1030:
1031: fnd_file.put_line(fnd_file.log,'sucessfully completed inserting ' || to_char(SQL%ROWCOUNT)|| ' rows into cicd');
1032:
1033: l_stmt_no := 50;
1034:
1035: Update CST_ITEM_CST_DTLS_INTERFACE ct set

Line 1041: fnd_file.put_line(fnd_file.log,'after updating the process flag to 5');

1037: WHERE error_flag is null
1038: AND group_id = SEQ_NEXTVAL
1039: AND process_flag = 4;
1040:
1041: fnd_file.put_line(fnd_file.log,'after updating the process flag to 5');
1042:
1043:
1044: IF i_del_option = 1 then
1045: delete from CST_ITEM_CST_DTLS_INTERFACE

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

1045: delete from CST_ITEM_CST_DTLS_INTERFACE
1046: WHERE error_flag is null
1047: AND process_flag = 5
1048: AND group_id = SEQ_NEXTVAL;
1049: fnd_file.put_line(fnd_file.log,'done deleting ' || to_char(SQL%ROWCOUNT) || ' processed rows');
1050: END IF;
1051:
1052: commit;
1053:

Line 1057: fnd_file.put_line(fnd_file.log,'CICD/CICDI table insert_cic_cicd(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));

1053:
1054: EXCEPTION
1055: when others then
1056: rollback;
1057: fnd_file.put_line(fnd_file.log,'CICD/CICDI table insert_cic_cicd(' || to_char(l_stmt_no) || '),' || to_char(SQLCODE) || ',' || substr(SQLERRM,1,180));
1058:
1059: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',(fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')));
1060: Error_number := 1;
1061:

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

1098: AND cicdi.process_flag = 1
1099: AND rownum = 1;
1100:
1101: If l_cicdi_count = 0 then
1102: fnd_file.put_line(fnd_file.log,'no rows to process in CST_ITEM_CST_DTLS_INTERFACE,quitting....');
1103: return;
1104: end If;
1105:
1106: validate_phase1(Err,i_cost_type,i_grp_id);

Line 1129: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));

1125: where group_id = i_grp_id
1126: and error_flag = 'E';
1127:
1128: If (i_count > 0) then
1129: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));
1130: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1131: END IF;
1132:
1133: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');

Line 1133: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');

1129: fnd_file.put_line(fnd_file.log,(fnd_message.get_string('BOM','CST_MSG_CICDI')));
1130: CONC_REQUEST := fnd_concurrent.set_completion_status('WARNING',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1131: END IF;
1132:
1133: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');
1134: EXCEPTION
1135: when others then
1136: rollback;
1137: fnd_file.put_line(fnd_file.log,'Start_item_cost_import_process(), Invalid Exception Occured');

Line 1137: fnd_file.put_line(fnd_file.log,'Start_item_cost_import_process(), Invalid Exception Occured');

1133: fnd_file.put_line(fnd_file.log,'done with item costs import, quitting');
1134: EXCEPTION
1135: when others then
1136: rollback;
1137: fnd_file.put_line(fnd_file.log,'Start_item_cost_import_process(), Invalid Exception Occured');
1138:
1139: CONC_REQUEST := fnd_concurrent.set_completion_status('ERROR',substrb((fnd_message.get_string('BOM','CST_EXCEPTION_OCCURED')),1,240));
1140: Error_number := 1;
1141: END Start_item_cost_import_process;