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.BOM_COPY_BILL dependencies on BOM_GLOBALS

Line 1443: bom_globals.g_skip_bomtbicx := 'Y';

1439: END LOOP;
1440: END IF;
1441: END IF;
1442: --turn off the trigger BOMTBICX
1443: bom_globals.g_skip_bomtbicx := 'Y';
1444:
1445: IF l_from_eff_ctrl = 1 AND l_to_eff_ctrl = 1 THEN -- Date - Date
1446:
1447:

Line 3614: bom_globals.g_skip_bomtbicx := 'N';

3610: END IF;
3611:
3612:
3613: --Turn on the trigger BOMTBICX
3614: bom_globals.g_skip_bomtbicx := 'N';
3615:
3616: /*
3617: --find list of actually copied comps
3618: l_comp_ctr := 1;

Line 4035: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

4031: from_org_id,
4032: rev_date
4033: ),
4034: GET_MESSAGE ('BOM_COPY_ERR_ENG_COMP_MFG_BILL',
4035: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4036: bom_globals.get_item_name(to_item_id, from_org_id)
4037: ),
4038: 'BOM_COPY',
4039: SYSDATE,

Line 4036: bom_globals.get_item_name(to_item_id, from_org_id)

4032: rev_date
4033: ),
4034: GET_MESSAGE ('BOM_COPY_ERR_ENG_COMP_MFG_BILL',
4035: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4036: bom_globals.get_item_name(to_item_id, from_org_id)
4037: ),
4038: 'BOM_COPY',
4039: SYSDATE,
4040: user_id,

Line 4124: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

4120: from_org_id,
4121: rev_date
4122: ),
4123: GET_MESSAGE ('BOM_COPY_ERR_COMP_FOR_WIP_JOB',
4124: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4125: bom_globals.get_item_name(to_item_id, from_org_id)
4126: ),
4127: 'BOM_COPY',
4128: SYSDATE,

Line 4125: bom_globals.get_item_name(to_item_id, from_org_id)

4121: rev_date
4122: ),
4123: GET_MESSAGE ('BOM_COPY_ERR_COMP_FOR_WIP_JOB',
4124: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4125: bom_globals.get_item_name(to_item_id, from_org_id)
4126: ),
4127: 'BOM_COPY',
4128: SYSDATE,
4129: user_id,

Line 4263: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

4259: from_org_id,
4260: rev_date
4261: ),
4262: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',
4263: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4264: bom_globals.get_item_name(to_item_id, from_org_id)
4265: ),
4266: 'BOM_COPY',
4267: SYSDATE,

Line 4264: bom_globals.get_item_name(to_item_id, from_org_id)

4260: rev_date
4261: ),
4262: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',
4263: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4264: bom_globals.get_item_name(to_item_id, from_org_id)
4265: ),
4266: 'BOM_COPY',
4267: SYSDATE,
4268: user_id,

Line 4446: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

4442: rev_date
4443: ),
4444: GET_MESSAGE (
4445: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
4446: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4447: bom_globals.get_item_name(to_item_id, from_org_id)
4448: ),
4449: 'BOM_COPY',
4450: SYSDATE,

Line 4447: bom_globals.get_item_name(to_item_id, from_org_id)

4443: ),
4444: GET_MESSAGE (
4445: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
4446: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4447: bom_globals.get_item_name(to_item_id, from_org_id)
4448: ),
4449: 'BOM_COPY',
4450: SYSDATE,
4451: user_id,

Line 4465: bom_globals.check_change_policy_range(

4461: WHERE bcb.bill_sequence_id = to_sequence_id
4462: AND bcb.component_item_id = msib.inventory_item_id
4463: AND msib.organization_id = to_org_id
4464: AND 'Y' <>
4465: bom_globals.check_change_policy_range(
4466: to_item_id,
4467: to_org_id,
4468: NULL, -- p_start_revision
4469: NULL, -- p_end_revision

Line 4474: bom_globals.get_change_policy_val(to_item_id, to_org_id,

4470: NULL, -- p_start_rev_id
4471: NULL, -- p_end_rev_id
4472: bcb.effectivity_date, -- p_effective_date
4473: bcb.disable_date, -- p_disable_date
4474: bom_globals.get_change_policy_val(to_item_id, to_org_id,
4475: BOM_Revisions.Get_Item_Revision_Id_Fn('ALL','ALL',to_org_id,
4476: to_item_id, NVL(x_effectivity_date, trgt_comps_eff_date)),
4477: null, -- rev id
4478: p_trgt_str_type_id), -- p_current_chg_pol

Line 4511: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

4507: rev_date
4508: ),
4509: GET_MESSAGE (
4510: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
4511: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4512: bom_globals.get_item_name(to_item_id, from_org_id)
4513: ),
4514: 'BOM_COPY',
4515: SYSDATE,

Line 4512: bom_globals.get_item_name(to_item_id, from_org_id)

4508: ),
4509: GET_MESSAGE (
4510: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
4511: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4512: bom_globals.get_item_name(to_item_id, from_org_id)
4513: ),
4514: 'BOM_COPY',
4515: SYSDATE,
4516: user_id,

Line 4530: bom_globals.check_change_policy_range(

4526: WHERE bcb.bill_sequence_id = to_sequence_id
4527: AND bcb.component_item_id = msib.inventory_item_id
4528: AND msib.organization_id = to_org_id
4529: AND 'Y' <>
4530: bom_globals.check_change_policy_range(
4531: to_item_id,
4532: to_org_id,
4533: NULL, -- p_start_revision
4534: NULL, -- p_end_revision

Line 4539: bom_globals.get_change_policy_val(to_item_id, to_org_id,

4535: bcb.from_end_item_rev_id, -- p_start_rev_id
4536: bcb.to_end_item_rev_id, -- p_end_rev_id
4537: NULL, -- p_effective_date
4538: NULL, -- p_disable_date
4539: bom_globals.get_change_policy_val(to_item_id, to_org_id,
4540: NVL(eco_end_item_rev_id, trgt_comps_end_item_rev_id),
4541: null, -- rev id
4542: p_trgt_str_type_id), -- p_current_chg_pol
4543: p_trgt_str_type_id, -- p_structure_type_id

Line 4581: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

4577: rev_date
4578: ),
4579: GET_MESSAGE
4580: ('BOM_COPY_ERR_COMP_REV_DIFF',
4581: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4582: bom_globals.get_item_name(to_item_id, from_org_id),
4583: get_current_item_rev (bcb.component_item_id,
4584: from_org_id,
4585: rev_date

Line 4582: bom_globals.get_item_name(to_item_id, from_org_id),

4578: ),
4579: GET_MESSAGE
4580: ('BOM_COPY_ERR_COMP_REV_DIFF',
4581: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4582: bom_globals.get_item_name(to_item_id, from_org_id),
4583: get_current_item_rev (bcb.component_item_id,
4584: from_org_id,
4585: rev_date
4586: )

Line 5009: bom_globals.g_skip_bomtbicx := 'Y';

5005: END;
5006:
5007: BEGIN
5008: --Turn off trigger BOMTBICX
5009: bom_globals.g_skip_bomtbicx := 'Y';
5010:
5011: IF (to_rtg_seq_id = -1)
5012: THEN
5013: sql_stmt_num := 30;

Line 5032: bom_globals.g_skip_bomtbicx := 'N';

5028: AND bos.operation_seq_num = bic.operation_seq_num);
5029: END IF;
5030:
5031: --Turn on trigger BOMTBICX
5032: bom_globals.g_skip_bomtbicx := 'N';
5033: EXCEPTION
5034: WHEN DUP_VAL_ON_INDEX
5035: THEN
5036: RAISE overlap_error;

Line 5219: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

5215: from_org_id,
5216: rev_date
5217: ),
5218: GET_MESSAGE ('BOM_COPY_ERR_NO_PLANNING_COMPS',
5219: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5220: bom_globals.get_item_name(to_item_id, from_org_id)
5221: ),
5222: 'BOM_COPY',
5223: SYSDATE,

Line 5220: bom_globals.get_item_name(to_item_id, from_org_id)

5216: rev_date
5217: ),
5218: GET_MESSAGE ('BOM_COPY_ERR_NO_PLANNING_COMPS',
5219: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5220: bom_globals.get_item_name(to_item_id, from_org_id)
5221: ),
5222: 'BOM_COPY',
5223: SYSDATE,
5224: user_id,

Line 5272: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

5268: from_org_id,
5269: rev_date
5270: ),
5271: GET_MESSAGE ('BOM_COPY_ERR_NO_OPT_MODEL_COMP',
5272: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5273: bom_globals.get_item_name(to_item_id, from_org_id)
5274: ),
5275: 'BOM_COPY',
5276: SYSDATE,

Line 5273: bom_globals.get_item_name(to_item_id, from_org_id)

5269: rev_date
5270: ),
5271: GET_MESSAGE ('BOM_COPY_ERR_NO_OPT_MODEL_COMP',
5272: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5273: bom_globals.get_item_name(to_item_id, from_org_id)
5274: ),
5275: 'BOM_COPY',
5276: SYSDATE,
5277: user_id,

Line 5329: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

5325: from_org_id,
5326: rev_date
5327: ),
5328: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_OPT_COMPS',
5329: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5330: bom_globals.get_item_name(to_item_id, from_org_id)
5331: ),
5332: 'BOM_COPY',
5333: SYSDATE,

Line 5330: bom_globals.get_item_name(to_item_id, from_org_id)

5326: rev_date
5327: ),
5328: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_OPT_COMPS',
5329: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5330: bom_globals.get_item_name(to_item_id, from_org_id)
5331: ),
5332: 'BOM_COPY',
5333: SYSDATE,
5334: user_id,

Line 5383: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

5379: from_org_id,
5380: rev_date
5381: ),
5382: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_STD_COMPS',
5383: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5384: bom_globals.get_item_name(to_item_id, from_org_id)
5385: ),
5386: 'BOM_COPY',
5387: SYSDATE,

Line 5384: bom_globals.get_item_name(to_item_id, from_org_id)

5380: rev_date
5381: ),
5382: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_STD_COMPS',
5383: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5384: bom_globals.get_item_name(to_item_id, from_org_id)
5385: ),
5386: 'BOM_COPY',
5387: SYSDATE,
5388: user_id,

Line 5440: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

5436: from_org_id,
5437: rev_date
5438: ),
5439: GET_MESSAGE ('BOM_COPY_ERR_NO_PTO_COMPS',
5440: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5441: bom_globals.get_item_name(to_item_id, from_org_id)
5442: ),
5443: 'BOM_COPY',
5444: SYSDATE,

Line 5441: bom_globals.get_item_name(to_item_id, from_org_id)

5437: rev_date
5438: ),
5439: GET_MESSAGE ('BOM_COPY_ERR_NO_PTO_COMPS',
5440: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
5441: bom_globals.get_item_name(to_item_id, from_org_id)
5442: ),
5443: 'BOM_COPY',
5444: SYSDATE,
5445: user_id,

Line 5506: bom_globals.g_skip_bomtbicx := 'Y';

5502:
5503: copy_comps := copy_comps - SQL%ROWCOUNT;
5504: sql_stmt_num := 43;
5505: --Turn off trigger BOMTBICX
5506: bom_globals.g_skip_bomtbicx := 'Y';
5507:
5508: UPDATE bom_components_b bic
5509: SET bic.wip_supply_type = phantom
5510: WHERE bic.bill_sequence_id = to_sequence_id

Line 5521: bom_globals.g_skip_bomtbicx := 'N';

5517: AND msi2.organization_id = to_org_id
5518: AND msi1.inventory_item_id = to_item_id
5519: AND msi1.organization_id = to_org_id);
5520:
5521: bom_globals.g_skip_bomtbicx := 'N';
5522: sql_stmt_num := 44;
5523: bom_globals.g_skip_bomtbicx := 'Y';
5524:
5525: UPDATE bom_components_b bic

Line 5523: bom_globals.g_skip_bomtbicx := 'Y';

5519: AND msi1.organization_id = to_org_id);
5520:
5521: bom_globals.g_skip_bomtbicx := 'N';
5522: sql_stmt_num := 44;
5523: bom_globals.g_skip_bomtbicx := 'Y';
5524:
5525: UPDATE bom_components_b bic
5526: SET bic.optional = 1
5527: WHERE bic.bill_sequence_id = to_sequence_id

Line 5563: bom_globals.g_skip_bomtbicx := 'N';

5559: AND msi1.organization_id = to_org_id);
5560:
5561:
5562: --Turn on trigger BOMTBICX
5563: bom_globals.g_skip_bomtbicx := 'N';
5564: sql_stmt_num := 46;
5565:
5566: IF specific_copy_flag = 'Y'
5567: THEN

Line 6237: bom_globals.g_skip_bomtbicx := 'Y';

6233: -- Update the created by column only when specific copy flag is no..
6234: -- If specific copy flag is 'Y', then after copy_bill, call update_created_by.
6235: IF specific_copy_flag = 'N' THEN
6236: --Turn off trigger BOMTBICX
6237: bom_globals.g_skip_bomtbicx := 'Y';
6238:
6239: UPDATE bom_components_b bic
6240: SET created_by = user_id
6241: WHERE bic.bill_sequence_id = to_sequence_id;

Line 6244: bom_globals.g_skip_bomtbicx := 'N';

6240: SET created_by = user_id
6241: WHERE bic.bill_sequence_id = to_sequence_id;
6242:
6243: --Turn on trigger BOMTBICX
6244: bom_globals.g_skip_bomtbicx := 'N';
6245: END IF;
6246: sql_stmt_num := 85;
6247:
6248: SELECT COUNT (*)

Line 6275: bom_globals.g_skip_bomtbicx := 'N';

6271: -- dbms_profiler.stop_profiler();
6272: EXCEPTION
6273: WHEN overlap_error
6274: THEN
6275: bom_globals.g_skip_bomtbicx := 'N';
6276: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');
6277:
6278: IF specific_copy_flag = 'Y'
6279: THEN

Line 6324: bom_globals.g_skip_bomtbicx := 'N';

6320: app_exception.raise_exception;
6321: END IF;
6322: WHEN common_error
6323: THEN
6324: bom_globals.g_skip_bomtbicx := 'N';
6325: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');
6326:
6327: IF specific_copy_flag = 'Y'
6328: THEN

Line 6373: bom_globals.g_skip_bomtbicx := 'N';

6369: app_exception.raise_exception;
6370: END IF;
6371: WHEN OTHERS
6372: THEN
6373: bom_globals.g_skip_bomtbicx := 'N';
6374: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
6375: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6376: fnd_message.set_token ('ENTITY', err_msg);
6377: ROLLBACK TO begin_bill_copy;

Line 6857: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)

6853: WHEN EXISTS ( SELECT 1
6854: FROM bom_structures_b bsb
6855: WHERE bsb.organization_id = oav.organization_id
6856: AND bsb.assembly_item_id = p_item_id
6857: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6858: AND bsb.bill_sequence_id = bsb.common_bill_sequence_id
6859: ) THEN
6860: 1 -- Structure already exists
6861: WHEN EXISTS ( SELECT 1

Line 6865: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)

6861: WHEN EXISTS ( SELECT 1
6862: FROM bom_structures_b bsb
6863: WHERE bsb.organization_id = oav.organization_id
6864: AND bsb.assembly_item_id = p_item_id
6865: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6866: AND bsb.bill_sequence_id <> bsb.common_bill_sequence_id
6867: ) THEN
6868: 2 -- Structure already exists and it is common structure
6869: ELSE

Line 6876: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)

6872: NVL((SELECT assembly_type
6873: FROM bom_structures_b bsb
6874: WHERE bsb.organization_id = x_org_list_tbl(l_index)
6875: AND bsb.assembly_item_id = p_item_id
6876: AND NVL(bsb.alternate_bom_designator,bom_globals.get_primary_ui) = NVL(p_structure_name,bom_globals.get_primary_ui)
6877: ),2) AS assembly_type,
6878: (SELECT revision
6879: FROM (SELECT revision
6880: FROM mtl_item_revisions_b mir

Line 6991: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

6987: bom_copy_structure_request bcsr
6988: WHERE bsb.assembly_item_id = cp_item_id
6989: AND bcsr.copy_request_id = cp_copy_request_id
6990: AND bsb.organization_id = bcol.organization_id
6991: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
6992: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui)
6993: AND bcol.copy_request_id = bcsr.copy_request_id
6994: AND bcol.organization_id = mp.organization_id;
6995:

Line 6992: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui)

6988: WHERE bsb.assembly_item_id = cp_item_id
6989: AND bcsr.copy_request_id = cp_copy_request_id
6990: AND bsb.organization_id = bcol.organization_id
6991: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
6992: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui)
6993: AND bcol.copy_request_id = bcsr.copy_request_id
6994: AND bcol.organization_id = mp.organization_id;
6995:
6996: l_count NUMBER := 0;

Line 7036: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

7032: WHERE bsb.bill_sequence_id <> bsb.source_bill_sequence_id
7033: AND bsb.assembly_item_id = cp_item_id
7034: AND bcsr.copy_request_id = cp_copy_request_id
7035: AND bsb.organization_id = bcol.organization_id
7036: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
7037: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui)
7038: AND bcol.copy_request_id = bcsr.copy_request_id
7039: AND bcol.organization_id = mp.organization_id;
7040:

Line 7037: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui)

7033: AND bsb.assembly_item_id = cp_item_id
7034: AND bcsr.copy_request_id = cp_copy_request_id
7035: AND bsb.organization_id = bcol.organization_id
7036: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
7037: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui)
7038: AND bcol.copy_request_id = bcsr.copy_request_id
7039: AND bcol.organization_id = mp.organization_id;
7040:
7041: l_count NUMBER := 0;

Line 7120: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

7116: bom_structures_b bsb
7117: WHERE bsb.assembly_item_id = cp_item_id
7118: AND bcsr.copy_request_id = bcol.copy_request_id
7119: AND bsb.organization_id = bcol.organization_id
7120: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
7121: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui));
7122:
7123: l_count NUMBER := 0;
7124: BEGIN

Line 7121: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui));

7117: WHERE bsb.assembly_item_id = cp_item_id
7118: AND bcsr.copy_request_id = bcol.copy_request_id
7119: AND bsb.organization_id = bcol.organization_id
7120: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
7121: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui));
7122:
7123: l_count NUMBER := 0;
7124: BEGIN
7125: FOR c1_rec IN c1 (p_item_id, p_copy_request_id)

Line 7163: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =

7159: bom_structures_b bsb
7160: WHERE bcsr.copy_request_id = bcol.copy_request_id
7161: AND bsb.organization_id = bcol.organization_id
7162: AND bsb.assembly_item_id = cp_item_id
7163: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
7164: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui));
7165:
7166: l_count NUMBER := 0;
7167: BEGIN

Line 7164: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui));

7160: WHERE bcsr.copy_request_id = bcol.copy_request_id
7161: AND bsb.organization_id = bcol.organization_id
7162: AND bsb.assembly_item_id = cp_item_id
7163: AND NVL (bsb.alternate_bom_designator, bom_globals.get_primary_ui) =
7164: NVL (bcsr.trgt_structure_name, bom_globals.get_primary_ui));
7165:
7166: l_count NUMBER := 0;
7167: BEGIN
7168: FOR c1_rec IN c1 (p_item_id, p_copy_request_id)

Line 7188: bom_globals.g_skip_bomtbicx := 'Y';

7184: p_user_id IN NUMBER
7185: ,p_to_bill_sequence_id IN NUMBER )
7186: IS
7187: BEGIN
7188: bom_globals.g_skip_bomtbicx := 'Y';
7189:
7190: UPDATE bom_components_b bic
7191: SET created_by = p_user_id
7192: WHERE bic.bill_sequence_id = p_to_bill_sequence_id;

Line 7195: bom_globals.g_skip_bomtbicx := 'N';

7191: SET created_by = p_user_id
7192: WHERE bic.bill_sequence_id = p_to_bill_sequence_id;
7193:
7194: --Turn on trigger BOMTBICX
7195: bom_globals.g_skip_bomtbicx := 'N';
7196:
7197: END;
7198:
7199: /* This procedure can be used in following scenario

Line 7756: bom_globals.g_skip_bomtbicx := 'Y';

7752: x_msg_count => l_msg_count,
7753: x_msg_data => l_msg_data
7754: );
7755: --turn off the trigger BOMTBICX
7756: bom_globals.g_skip_bomtbicx := 'Y';
7757:
7758: IF l_from_eff_ctrl = 1 AND l_to_eff_ctrl = 1 THEN -- Date - Date
7759:
7760:

Line 9699: bom_globals.g_skip_bomtbicx := 'N';

9695: END IF;
9696:
9697:
9698: --Turn on the trigger BOMTBICX
9699: bom_globals.g_skip_bomtbicx := 'N';
9700:
9701: OPEN l_from_to_comps_csr (from_sequence_id, to_sequence_id, l_last_copied_comp_seq_id);
9702:
9703: FETCH l_from_to_comps_csr

Line 10071: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10067: from_org_id,
10068: rev_date
10069: ),
10070: GET_MESSAGE ('BOM_COPY_ERR_ENG_COMP_MFG_BILL',
10071: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10072: bom_globals.get_item_name(to_item_id, from_org_id)
10073: ),
10074: 'BOM_COPY',
10075: SYSDATE,

Line 10072: bom_globals.get_item_name(to_item_id, from_org_id)

10068: rev_date
10069: ),
10070: GET_MESSAGE ('BOM_COPY_ERR_ENG_COMP_MFG_BILL',
10071: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10072: bom_globals.get_item_name(to_item_id, from_org_id)
10073: ),
10074: 'BOM_COPY',
10075: SYSDATE,
10076: user_id,

Line 10173: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10169: from_org_id,
10170: rev_date
10171: ),
10172: GET_MESSAGE ('BOM_COPY_ERR_COMP_FOR_WIP_JOB',
10173: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10174: bom_globals.get_item_name(to_item_id, from_org_id)
10175: ),
10176: 'BOM_COPY',
10177: SYSDATE,

Line 10174: bom_globals.get_item_name(to_item_id, from_org_id)

10170: rev_date
10171: ),
10172: GET_MESSAGE ('BOM_COPY_ERR_COMP_FOR_WIP_JOB',
10173: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10174: bom_globals.get_item_name(to_item_id, from_org_id)
10175: ),
10176: 'BOM_COPY',
10177: SYSDATE,
10178: user_id,

Line 10272: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10268: from_org_id,
10269: rev_date
10270: ),
10271: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',
10272: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10273: bom_globals.get_item_name(to_item_id, from_org_id)
10274: ),
10275: 'BOM_COPY',
10276: SYSDATE,

Line 10273: bom_globals.get_item_name(to_item_id, from_org_id)

10269: rev_date
10270: ),
10271: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',
10272: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10273: bom_globals.get_item_name(to_item_id, from_org_id)
10274: ),
10275: 'BOM_COPY',
10276: SYSDATE,
10277: user_id,

Line 10475: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10471: rev_date
10472: ),
10473: GET_MESSAGE (
10474: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
10475: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10476: bom_globals.get_item_name(to_item_id, from_org_id)
10477: ),
10478: 'BOM_COPY',
10479: SYSDATE,

Line 10476: bom_globals.get_item_name(to_item_id, from_org_id)

10472: ),
10473: GET_MESSAGE (
10474: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
10475: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10476: bom_globals.get_item_name(to_item_id, from_org_id)
10477: ),
10478: 'BOM_COPY',
10479: SYSDATE,
10480: user_id,

Line 10494: bom_globals.check_change_policy_range(

10490: WHERE bcb.bill_sequence_id = to_sequence_id
10491: AND bcb.component_item_id = msib.inventory_item_id
10492: AND msib.organization_id = to_org_id
10493: AND 'Y' <>
10494: bom_globals.check_change_policy_range(
10495: to_item_id,
10496: to_org_id,
10497: NULL, -- p_start_revision
10498: NULL, -- p_end_revision

Line 10503: bom_globals.get_change_policy_val(to_item_id, to_org_id,

10499: NULL, -- p_start_rev_id
10500: NULL, -- p_end_rev_id
10501: bcb.effectivity_date, -- p_effective_date
10502: bcb.disable_date, -- p_disable_date
10503: bom_globals.get_change_policy_val(to_item_id, to_org_id,
10504: BOM_Revisions.Get_Item_Revision_Id_Fn('ALL','ALL',to_org_id,
10505: to_item_id,x_effectivity_date),
10506: null, -- rev id
10507: p_trgt_str_type_id), -- p_current_chg_pol

Line 10540: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10536: rev_date
10537: ),
10538: GET_MESSAGE (
10539: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
10540: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10541: bom_globals.get_item_name(to_item_id, from_org_id)
10542: ),
10543: 'BOM_COPY',
10544: SYSDATE,

Line 10541: bom_globals.get_item_name(to_item_id, from_org_id)

10537: ),
10538: GET_MESSAGE (
10539: 'BOM_CPY_REV_CHANGE_POLICY_ERR',
10540: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10541: bom_globals.get_item_name(to_item_id, from_org_id)
10542: ),
10543: 'BOM_COPY',
10544: SYSDATE,
10545: user_id,

Line 10559: bom_globals.check_change_policy_range(

10555: WHERE bcb.bill_sequence_id = to_sequence_id
10556: AND bcb.component_item_id = msib.inventory_item_id
10557: AND msib.organization_id = to_org_id
10558: AND 'Y' <>
10559: bom_globals.check_change_policy_range(
10560: to_item_id,
10561: to_org_id,
10562: NULL, -- p_start_revision
10563: NULL, -- p_end_revision

Line 10568: bom_globals.get_change_policy_val(to_item_id, to_org_id,

10564: bcb.from_end_item_rev_id, -- p_start_rev_id
10565: bcb.to_end_item_rev_id, -- p_end_rev_id
10566: NULL, -- p_effective_date
10567: NULL, -- p_disable_date
10568: bom_globals.get_change_policy_val(to_item_id, to_org_id,
10569: eco_end_item_rev_id,
10570: null, -- rev id
10571: p_trgt_str_type_id), -- p_current_chg_pol
10572: p_trgt_str_type_id, -- p_structure_type_id

Line 10611: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10607: rev_date
10608: ),
10609: GET_MESSAGE
10610: ('BOM_COPY_ERR_COMP_REV_DIFF',
10611: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10612: bom_globals.get_item_name(to_item_id, from_org_id),
10613: get_current_item_rev (bcb.component_item_id,
10614: from_org_id,
10615: rev_date

Line 10612: bom_globals.get_item_name(to_item_id, from_org_id),

10608: ),
10609: GET_MESSAGE
10610: ('BOM_COPY_ERR_COMP_REV_DIFF',
10611: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10612: bom_globals.get_item_name(to_item_id, from_org_id),
10613: get_current_item_rev (bcb.component_item_id,
10614: from_org_id,
10615: rev_date
10616: )

Line 10735: bom_globals.g_skip_bomtbicx := 'Y';

10731: END;
10732:
10733: BEGIN
10734: --Turn off trigger BOMTBICX
10735: bom_globals.g_skip_bomtbicx := 'Y';
10736:
10737: IF (to_rtg_seq_id = -1)
10738: THEN
10739: sql_stmt_num := 30;

Line 10758: bom_globals.g_skip_bomtbicx := 'N';

10754: AND bos.operation_seq_num = bic.operation_seq_num);
10755: END IF;
10756:
10757: --Turn on trigger BOMTBICX
10758: bom_globals.g_skip_bomtbicx := 'N';
10759: EXCEPTION
10760: WHEN DUP_VAL_ON_INDEX
10761: THEN
10762: RAISE overlap_error;

Line 10946: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10942: from_org_id,
10943: rev_date
10944: ),
10945: GET_MESSAGE ('BOM_COPY_ERR_NO_PLANNING_COMPS',
10946: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10947: bom_globals.get_item_name(to_item_id, from_org_id)
10948: ),
10949: 'BOM_COPY',
10950: SYSDATE,

Line 10947: bom_globals.get_item_name(to_item_id, from_org_id)

10943: rev_date
10944: ),
10945: GET_MESSAGE ('BOM_COPY_ERR_NO_PLANNING_COMPS',
10946: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10947: bom_globals.get_item_name(to_item_id, from_org_id)
10948: ),
10949: 'BOM_COPY',
10950: SYSDATE,
10951: user_id,

Line 11000: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

10996: from_org_id,
10997: rev_date
10998: ),
10999: GET_MESSAGE ('BOM_COPY_ERR_NO_OPT_MODEL_COMP',
11000: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11001: bom_globals.get_item_name(to_item_id, from_org_id)
11002: ),
11003: 'BOM_COPY',
11004: SYSDATE,

Line 11001: bom_globals.get_item_name(to_item_id, from_org_id)

10997: rev_date
10998: ),
10999: GET_MESSAGE ('BOM_COPY_ERR_NO_OPT_MODEL_COMP',
11000: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11001: bom_globals.get_item_name(to_item_id, from_org_id)
11002: ),
11003: 'BOM_COPY',
11004: SYSDATE,
11005: user_id,

Line 11055: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

11051: from_org_id,
11052: rev_date
11053: ),
11054: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_OPT_COMPS',
11055: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11056: bom_globals.get_item_name(to_item_id, from_org_id)
11057: ),
11058: 'BOM_COPY',
11059: SYSDATE,

Line 11056: bom_globals.get_item_name(to_item_id, from_org_id)

11052: rev_date
11053: ),
11054: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_OPT_COMPS',
11055: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11056: bom_globals.get_item_name(to_item_id, from_org_id)
11057: ),
11058: 'BOM_COPY',
11059: SYSDATE,
11060: user_id,

Line 11110: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

11106: from_org_id,
11107: rev_date
11108: ),
11109: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_STD_COMPS',
11110: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11111: bom_globals.get_item_name(to_item_id, from_org_id)
11112: ),
11113: 'BOM_COPY',
11114: SYSDATE,

Line 11111: bom_globals.get_item_name(to_item_id, from_org_id)

11107: rev_date
11108: ),
11109: GET_MESSAGE ('BOM_COPY_ERR_NO_ATO_STD_COMPS',
11110: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11111: bom_globals.get_item_name(to_item_id, from_org_id)
11112: ),
11113: 'BOM_COPY',
11114: SYSDATE,
11115: user_id,

Line 11166: bom_globals.get_item_name(bcb.component_item_id, from_org_id),

11162: from_org_id,
11163: rev_date
11164: ),
11165: GET_MESSAGE ('BOM_COPY_ERR_NO_PTO_COMPS',
11166: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11167: bom_globals.get_item_name(to_item_id, from_org_id)
11168: ),
11169: 'BOM_COPY',
11170: SYSDATE,

Line 11167: bom_globals.get_item_name(to_item_id, from_org_id)

11163: rev_date
11164: ),
11165: GET_MESSAGE ('BOM_COPY_ERR_NO_PTO_COMPS',
11166: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
11167: bom_globals.get_item_name(to_item_id, from_org_id)
11168: ),
11169: 'BOM_COPY',
11170: SYSDATE,
11171: user_id,

Line 11229: bom_globals.g_skip_bomtbicx := 'Y';

11225:
11226: copy_comps := copy_comps - SQL%ROWCOUNT;
11227: sql_stmt_num := 43;
11228: --Turn off trigger BOMTBICX
11229: bom_globals.g_skip_bomtbicx := 'Y';
11230:
11231: UPDATE bom_components_b bic
11232: SET bic.wip_supply_type = phantom
11233: WHERE bic.bill_sequence_id = to_sequence_id

Line 11245: bom_globals.g_skip_bomtbicx := 'N';

11241: AND msi1.inventory_item_id = to_item_id
11242: AND msi1.organization_id = to_org_id)
11243: AND bic.revised_item_sequence_id = rev_item_seq_id;
11244:
11245: bom_globals.g_skip_bomtbicx := 'N';
11246: sql_stmt_num := 44;
11247: bom_globals.g_skip_bomtbicx := 'Y';
11248:
11249: UPDATE bom_components_b bic

Line 11247: bom_globals.g_skip_bomtbicx := 'Y';

11243: AND bic.revised_item_sequence_id = rev_item_seq_id;
11244:
11245: bom_globals.g_skip_bomtbicx := 'N';
11246: sql_stmt_num := 44;
11247: bom_globals.g_skip_bomtbicx := 'Y';
11248:
11249: UPDATE bom_components_b bic
11250: SET bic.optional = 1
11251: WHERE bic.bill_sequence_id = to_sequence_id

Line 11268: bom_globals.g_skip_bomtbicx := 'N';

11264: AND msi1.organization_id = to_org_id)
11265: AND bic.revised_item_sequence_id = rev_item_seq_id;
11266:
11267: --Turn on trigger BOMTBICX
11268: bom_globals.g_skip_bomtbicx := 'N';
11269: sql_stmt_num := 46;
11270:
11271: INSERT INTO bom_reference_designators
11272: (component_reference_designator,

Line 11638: bom_globals.g_skip_bomtbicx := 'N';

11634:
11635: EXCEPTION
11636: WHEN overlap_error
11637: THEN
11638: bom_globals.g_skip_bomtbicx := 'N';
11639: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');
11640:
11641: INSERT INTO mtl_interface_errors
11642: (unique_id,

Line 11681: bom_globals.g_skip_bomtbicx := 'N';

11677: sysdate
11678: );
11679: WHEN common_error
11680: THEN
11681: bom_globals.g_skip_bomtbicx := 'N';
11682: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');
11683:
11684: INSERT INTO mtl_interface_errors
11685: (unique_id,

Line 11724: bom_globals.g_skip_bomtbicx := 'N';

11720: sysdate
11721: );
11722: WHEN OTHERS
11723: THEN
11724: bom_globals.g_skip_bomtbicx := 'N';
11725: err_msg := 'copy_bill_for_revised_item (' || sql_stmt_num || ') ' || SQLERRM;
11726: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
11727: fnd_message.set_token ('ENTITY', err_msg);
11728: ROLLBACK TO begin_revised_item_bill_copy;