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.MSD_DEM_COLLECT_BOM_DATA dependencies on MSD_DEM_COMMON_UTILITIES

Line 157: * msd_dem_common_utilities.uom_conv(msi.sr_instance_id, msi.uom_code,msi.sr_inventory_item_id) usage_quantity,

153: abs(mbc.usage_quantity)),
154: 1,
155: (mbc.usage_quantity * mbc.Component_Yield_Factor),
156: (mbc.usage_quantity / mbc.Component_Yield_Factor))
157: * msd_dem_common_utilities.uom_conv(msi.sr_instance_id, msi.uom_code,msi.sr_inventory_item_id) usage_quantity,
158: mbc.disable_date disable_date
159: FROM msc_system_items msi,
160: msc_bom_components mbc
161: WHERE msi.plan_id = -1

Line 181: msd_dem_common_utilities.log_debug ('msd_dem_collect_bom_data.get_all_parents - endPos is null');

177: endPos := endPos + 1;
178:
179: IF (endPos IS NULL)
180: THEN
181: msd_dem_common_utilities.log_debug ('msd_dem_collect_bom_data.get_all_parents - endPos is null');
182: END IF;
183:
184: p_parents(endPos).item_id := c_token.using_assembly_id;
185: p_parents(endPos).planning_factor := (p_planning_factor * c_token.planning_factor) / 100;

Line 279: * msd_dem_common_utilities.uom_conv(ascp_comp.sr_instance_id, ascp_comp.uom_code, ascp_comp.inventory_item_id) usage_quantity,

275: abs(mbc.usage_quantity)),
276: 1,
277: (mbc.usage_quantity * mbc.Component_Yield_Factor),
278: (mbc.usage_quantity / mbc.Component_Yield_Factor))
279: * msd_dem_common_utilities.uom_conv(ascp_comp.sr_instance_id, ascp_comp.uom_code, ascp_comp.inventory_item_id) usage_quantity,
280: mbc.planning_factor,
281: mb.bill_sequence_id,
282: mbc.optional_component
283: FROM msc_boms mb,

Line 354: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

350:
351:
352: BEGIN
353:
354: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
355:
356: retcode := 0;
357: /* Log the parameters */
358: msd_dem_common_utilities.log_debug (' Instance ID - ' || to_char(p_sr_instance_id));

Line 358: msd_dem_common_utilities.log_debug (' Instance ID - ' || to_char(p_sr_instance_id));

354: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
355:
356: retcode := 0;
357: /* Log the parameters */
358: msd_dem_common_utilities.log_debug (' Instance ID - ' || to_char(p_sr_instance_id));
359:
360: /* The procedure should only execute if profile MSD_DEM: Include Dependent Demand is set to yes. */
361: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 2)
362: THEN

Line 363: msd_dem_common_utilities.log_message ('In msd_dem_collect_bom_data.collect_bom_data - '

359:
360: /* The procedure should only execute if profile MSD_DEM: Include Dependent Demand is set to yes. */
361: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 2)
362: THEN
363: msd_dem_common_utilities.log_message ('In msd_dem_collect_bom_data.collect_bom_data - '
364: || 'Profile MSD_DEM: Include Dependent Demand is set to No. '
365: || 'Hence no action taken. Exiting Normally.');
366: retcode := 0;
367: RETURN;

Line 374: msd_dem_common_utilities.log_message ('In msd_dem_collect_bom_data.collect_bom_data - '

370: /* The procedure should only execute if profile MSD_DEM: Calculate Planning Percentage
371: * is set to Collect Consume and Derive Options Only. */
372: IF (fnd_profile.value('MSD_DEM_PLANNING_PERCENTAGE') <> 2)
373: THEN
374: msd_dem_common_utilities.log_message ('In msd_dem_collect_bom_data.collect_bom_data - '
375: || 'Profile MSD_DEM: Calculate Planning Percentage is not set to Collect Options Only. '
376: || 'Hence no action taken. Exiting Normally.');
377: retcode := 0;
378: RETURN;

Line 381: msd_dem_common_utilities.log_message ('Truncating table MSD_DEM_BOM_COMPONENTS');

377: retcode := 0;
378: RETURN;
379: END IF;
380:
381: msd_dem_common_utilities.log_message ('Truncating table MSD_DEM_BOM_COMPONENTS');
382: msd_dem_query_utilities.truncate_table (
383: errbuf,
384: retcode,
385: 'MSD_DEM_BOM_COMPONENTS',

Line 390: msd_dem_common_utilities.log_message ('Error(1) in msd_dem_collect_bom_data.collect_bom_data - '

386: 2,
387: 1);
388: IF (retcode = -1)
389: THEN
390: msd_dem_common_utilities.log_message ('Error(1) in msd_dem_collect_bom_data.collect_bom_data - '
391: || 'Error in call to msd_dem_query_utilities.truncate_table');
392: msd_dem_common_utilities.log_message(errbuf);
393: RETURN;
394: END IF;

Line 392: msd_dem_common_utilities.log_message(errbuf);

388: IF (retcode = -1)
389: THEN
390: msd_dem_common_utilities.log_message ('Error(1) in msd_dem_collect_bom_data.collect_bom_data - '
391: || 'Error in call to msd_dem_query_utilities.truncate_table');
392: msd_dem_common_utilities.log_message(errbuf);
393: RETURN;
394: END IF;
395:
396: IF (to_number(fnd_profile.value('MSD_DEM_EXPLODE_DEMAND_METHOD')) = 2)

Line 398: x_master_org := msd_dem_common_utilities.get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');

394: END IF;
395:
396: IF (to_number(fnd_profile.value('MSD_DEM_EXPLODE_DEMAND_METHOD')) = 2)
397: THEN
398: x_master_org := msd_dem_common_utilities.get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');
399: END IF;
400:
401: msd_dem_common_utilities.log_debug ('Select Valid Components from MSC');
402: OPEN c1 (x_master_org);

Line 401: msd_dem_common_utilities.log_debug ('Select Valid Components from MSC');

397: THEN
398: x_master_org := msd_dem_common_utilities.get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');
399: END IF;
400:
401: msd_dem_common_utilities.log_debug ('Select Valid Components from MSC');
402: OPEN c1 (x_master_org);
403: FETCH c1 BULK COLLECT INTO
404: L_INSTANCE,
405: L_ORG_SR_PKS,

Line 418: msd_dem_common_utilities.log_message ('Error(2) in msd_dem_collect_bom_data.collect_bom_data - '

414:
415: IF (c1%ROWCOUNT = 0)
416: THEN
417: CLOSE c1;
418: msd_dem_common_utilities.log_message ('Error(2) in msd_dem_collect_bom_data.collect_bom_data - '
419: || 'No rows found in c1 cursor');
420: retcode := -1;
421: RETURN;
422: END IF;

Line 426: msd_dem_common_utilities.log_debug ('Begin looping through all components.');

422: END IF;
423:
424: CLOSE c1;
425:
426: msd_dem_common_utilities.log_debug ('Begin looping through all components.');
427:
428: FOR j IN L_COMPONENT_SR_PKS.FIRST..L_COMPONENT_SR_PKS.LAST
429: LOOP
430:

Line 433: msd_dem_common_utilities.log_debug('Row: ' || icount);

429: LOOP
430:
431: mo_parents.delete;
432:
433: msd_dem_common_utilities.log_debug('Row: ' || icount);
434: msd_dem_common_utilities.log_debug(' Instance: ' || icount);
435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));
436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));

Line 434: msd_dem_common_utilities.log_debug(' Instance: ' || icount);

430:
431: mo_parents.delete;
432:
433: msd_dem_common_utilities.log_debug('Row: ' || icount);
434: msd_dem_common_utilities.log_debug(' Instance: ' || icount);
435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));
436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));
438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));

Line 435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));

431: mo_parents.delete;
432:
433: msd_dem_common_utilities.log_debug('Row: ' || icount);
434: msd_dem_common_utilities.log_debug(' Instance: ' || icount);
435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));
436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));
438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));
439: msd_dem_common_utilities.log_debug(' Bill Sequence Id: ' || L_BILL_SEQUENCE_ID(j));

Line 436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));

432:
433: msd_dem_common_utilities.log_debug('Row: ' || icount);
434: msd_dem_common_utilities.log_debug(' Instance: ' || icount);
435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));
436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));
438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));
439: msd_dem_common_utilities.log_debug(' Bill Sequence Id: ' || L_BILL_SEQUENCE_ID(j));
440: msd_dem_common_utilities.log_debug(' Optional Flag : ' || L_OPTIONAL_FLAG(j));

Line 437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));

433: msd_dem_common_utilities.log_debug('Row: ' || icount);
434: msd_dem_common_utilities.log_debug(' Instance: ' || icount);
435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));
436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));
438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));
439: msd_dem_common_utilities.log_debug(' Bill Sequence Id: ' || L_BILL_SEQUENCE_ID(j));
440: msd_dem_common_utilities.log_debug(' Optional Flag : ' || L_OPTIONAL_FLAG(j));
441:

Line 438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));

434: msd_dem_common_utilities.log_debug(' Instance: ' || icount);
435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));
436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));
438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));
439: msd_dem_common_utilities.log_debug(' Bill Sequence Id: ' || L_BILL_SEQUENCE_ID(j));
440: msd_dem_common_utilities.log_debug(' Optional Flag : ' || L_OPTIONAL_FLAG(j));
441:
442: icount := icount + 1;

Line 439: msd_dem_common_utilities.log_debug(' Bill Sequence Id: ' || L_BILL_SEQUENCE_ID(j));

435: msd_dem_common_utilities.log_debug(' Organization Sr Pk: ' || L_ORG_SR_PKS(j));
436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));
438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));
439: msd_dem_common_utilities.log_debug(' Bill Sequence Id: ' || L_BILL_SEQUENCE_ID(j));
440: msd_dem_common_utilities.log_debug(' Optional Flag : ' || L_OPTIONAL_FLAG(j));
441:
442: icount := icount + 1;
443:

Line 440: msd_dem_common_utilities.log_debug(' Optional Flag : ' || L_OPTIONAL_FLAG(j));

436: msd_dem_common_utilities.log_debug(' Assembly Pk: ' || L_ASSEMBLY_ASCP_PKS(j));
437: msd_dem_common_utilities.log_debug(' Component SrPk: ' || L_COMPONENT_SR_PKS(j));
438: msd_dem_common_utilities.log_debug(' Effective Date: ' || L_EFFECTIVE_DATES(j));
439: msd_dem_common_utilities.log_debug(' Bill Sequence Id: ' || L_BILL_SEQUENCE_ID(j));
440: msd_dem_common_utilities.log_debug(' Optional Flag : ' || L_OPTIONAL_FLAG(j));
441:
442: icount := icount + 1;
443:
444: get_bom_item_type(

Line 479: msd_dem_common_utilities.log_debug('compLastIndex is null in method bom_collections');

475: compLastIndex := oc_parents.last;
476:
477: IF compLastIndex IS NULL
478: THEN
479: msd_dem_common_utilities.log_debug('compLastIndex is null in method bom_collections');
480: END IF;
481:
482: get_bom_item_type(
483: p_answer => p_bom_item_type,

Line 623: msd_dem_common_utilities.log_debug ('There is no data to insert - ' || to_char(C_INSTANCE.LAST));

619:
620:
621: IF (C_INSTANCE(1) = C_INIT_VARCHAR2)
622: THEN
623: msd_dem_common_utilities.log_debug ('There is no data to insert - ' || to_char(C_INSTANCE.LAST));
624: ELSE
625:
626: -- INSERT THE DATA
627: FORALL k IN 1..C_INSTANCE.LAST

Line 659: msd_dem_common_utilities.log_debug ('The number of rows inserted is : ' || to_char(numInsert - 1));

655: fnd_global.user_id,
656: fnd_global.user_id,
657: C_OPTIONAL_FLAG(k) );
658:
659: msd_dem_common_utilities.log_debug ('The number of rows inserted is : ' || to_char(numInsert - 1));
660:
661:
662: -- Remove the duplicates
663: i := 0;

Line 668: msd_dem_common_utilities.log_debug (to_char(i) || '. Duplicate - Instance/Organization/Parent/Child - '

664: FOR c_token IN c3
665: LOOP
666:
667: i := i + 1;
668: msd_dem_common_utilities.log_debug (to_char(i) || '. Duplicate - Instance/Organization/Parent/Child - '
669: || to_char(c_token.sr_instance_id) || '/'
670: || to_char(c_token.sr_organization_id) || '/'
671: || to_char(c_token.sr_assembly_item_id) || '/'
672: || to_char(c_token.sr_component_item_id));

Line 680: msd_dem_common_utilities.log_debug ('Number of rows deleted : ' || to_char(SQL%ROWCOUNT));

676: AND sr_organization_id = c_token.sr_organization_id
677: AND sr_assembly_item_id = c_token.sr_assembly_item_id
678: AND sr_component_item_id = c_token.sr_component_item_id;
679:
680: msd_dem_common_utilities.log_debug ('Number of rows deleted : ' || to_char(SQL%ROWCOUNT));
681:
682: INSERT INTO MSD_DEM_BOM_COMPONENTS (
683: sr_instance_id,
684: sr_organization_id,

Line 713: msd_dem_common_utilities.log_debug ('Number of rows inserted : ' || to_char(SQL%ROWCOUNT));

709: fnd_global.user_id,
710: fnd_global.user_id,
711: c_token.optional_flag);
712:
713: msd_dem_common_utilities.log_debug ('Number of rows inserted : ' || to_char(SQL%ROWCOUNT));
714:
715: END LOOP;
716:
717: COMMIT;

Line 724: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

720: msd_dem_collect_history_data.analyze_table(x_errbuf, x_retcode, 'MSD_DEM_BOM_COMPONENTS');
721:
722: END IF;
723:
724: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
725:
726: retcode := 0;
727:
728: EXCEPTION

Line 733: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

729: WHEN OTHERS THEN
730: errbuf := substr(SQLERRM,1,150);
731: retcode := -1;
732:
733: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
734: msd_dem_common_utilities.log_message (errbuf);
735: RETURN;
736:
737: END COLLECT_BOM_DATA;

Line 734: msd_dem_common_utilities.log_message (errbuf);

730: errbuf := substr(SQLERRM,1,150);
731: retcode := -1;
732:
733: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_collect_bom_data.collect_bom_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
734: msd_dem_common_utilities.log_message (errbuf);
735: RETURN;
736:
737: END COLLECT_BOM_DATA;
738: