[Home] [Help]
558: copy_all_subcomps_flag IN VARCHAR2 DEFAULT 'N',
559: -- copy_all_compops_flag IN VARCHAR2 DEFAULT 'N',
560: copy_attach_flag IN VARCHAR2 DEFAULT 'Y',
561: -- Request Id for this copy operation. Value from BOM_COPY_STRUCTURE_REQUEST_S
562: -- To populate the errors in MTL_INTERFACE_ERRORS with this transaction id
563: p_copy_request_id IN NUMBER,
564: -- Unit number for copy to item
565: eco_end_item_rev_id IN NUMBER DEFAULT NULL,
566: -- Structure has been exploded in context of this ECO for copying
1396: IF l_error_msg_tbl.FIRST IS NOT NULL THEN
1397: l_msg_count := l_error_msg_tbl.FIRST;
1398: WHILE l_msg_count IS NOT NULL
1399: LOOP
1400: INSERT INTO mtl_interface_errors
1401: (unique_id,
1402: organization_id,
1403: transaction_id,
1404: table_name,
3741: IF l_error_msg_tbl.FIRST IS NOT NULL THEN
3742: l_msg_count := l_error_msg_tbl.FIRST;
3743: WHILE l_msg_count IS NOT NULL
3744: LOOP
3745: INSERT INTO mtl_interface_errors
3746: (unique_id,
3747: organization_id,
3748: transaction_id,
3749: table_name,
3860: );
3861:
3862: IF l_no_access_comp_cnt > 0
3863: THEN
3864: INSERT INTO mtl_interface_errors
3865: (unique_id,
3866: organization_id,
3867: transaction_id,
3868: table_name,
3957: );
3958:
3959: IF l_no_access_comp_cnt > 0
3960: THEN
3961: INSERT INTO mtl_interface_errors
3962: (unique_id,
3963: organization_id,
3964: transaction_id,
3965: table_name,
4003: AND msbk1.organization_id = from_org_id;
4004: END IF;
4005: END IF;
4006:
4007: -- Insert Error messages to MTL_INTERFACE_ERRORS for each error while copying
4008: INSERT INTO mtl_interface_errors
4009: (unique_id,
4010: organization_id,
4011: transaction_id,
4004: END IF;
4005: END IF;
4006:
4007: -- Insert Error messages to MTL_INTERFACE_ERRORS for each error while copying
4008: INSERT INTO mtl_interface_errors
4009: (unique_id,
4010: organization_id,
4011: transaction_id,
4012: table_name,
4093: -- Component Action is exclude or enable
4094: -- we need not copy.
4095: );
4096:
4097: INSERT INTO mtl_interface_errors
4098: (unique_id,
4099: organization_id,
4100: transaction_id,
4101: table_name,
4183: any unimplemented component or if there is a context eco, we need not log the message, because
4184: unimplemented components will be copied as implemented components
4185: IF ( context_eco IS NULL AND bill_or_eco = 1 )
4186: THEN
4187: INSERT INTO mtl_interface_errors
4188: (unique_id,
4189: organization_id,
4190: transaction_id,
4191: table_name,
4232: AND msbk2.organization_id = to_org_id;
4233: END IF;
4234: */
4235:
4236: INSERT INTO mtl_interface_errors
4237: (unique_id,
4238: organization_id,
4239: transaction_id,
4240: table_name,
4324: -- Component Action is exclude or enable
4325: -- we need not copy.
4326: );
4327:
4328: INSERT INTO mtl_interface_errors
4329: (unique_id,
4330: organization_id,
4331: transaction_id,
4332: table_name,
4414: ELSE
4415: l_use_eco_flag := 'Y';
4416: END IF;
4417: IF l_to_eff_ctrl = 1 THEN
4418: INSERT INTO mtl_interface_errors
4419: (unique_id,
4420: organization_id,
4421: transaction_id,
4422: table_name,
4479: p_trgt_str_type_id, -- p_structure_type_id
4480: l_use_eco_flag -- p_use_eco
4481: );
4482: ELSIF l_to_eff_ctrl = 4 THEN
4483: INSERT INTO mtl_interface_errors
4484: (unique_id,
4485: organization_id,
4486: transaction_id,
4487: table_name,
4549: -- if revision does not exist.
4550: IF l_from_eff_ctrl = 4 AND l_to_eff_ctrl = 4
4551: AND from_org_id <> to_org_id
4552: THEN
4553: INSERT INTO mtl_interface_errors
4554: (unique_id,
4555: organization_id,
4556: transaction_id,
4557: table_name,
5188: -- Log errors for multi level structure copy.
5189: IF specific_copy_flag = 'Y'
5190: THEN
5191: -- Planning bill should contain only planning components
5192: INSERT INTO mtl_interface_errors
5193: (unique_id,
5194: organization_id,
5195: transaction_id,
5196: table_name,
5241: AND msib1.inventory_item_id = bcb.component_item_id
5242: AND msib1.organization_id = to_org_id;
5243:
5244: -- Standard bill without base model cannot have Option class or Model components.
5245: INSERT INTO mtl_interface_errors
5246: (unique_id,
5247: organization_id,
5248: transaction_id,
5249: table_name,
5298: -- No ATO Optional components in PTO bill
5299: --modified the following for BOM ER 9904085
5300: if(nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
5301: then
5302: INSERT INTO mtl_interface_errors
5303: (unique_id,
5304: organization_id,
5305: transaction_id,
5306: table_name,
5352: AND msib1.inventory_item_id = bcb.component_item_id
5353: AND msib1.organization_id = to_org_id;
5354:
5355: -- No ATO standard items for PTO standard bills
5356: INSERT INTO mtl_interface_errors
5357: (unique_id,
5358: organization_id,
5359: transaction_id,
5360: table_name,
5409: end if;
5410: --end of BOM ER 9904085
5411:
5412: -- No PTO components in ATO bill
5413: INSERT INTO mtl_interface_errors
5414: (unique_id,
5415: organization_id,
5416: transaction_id,
5417: table_name,
6276: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');
6277:
6278: IF specific_copy_flag = 'Y'
6279: THEN
6280: INSERT INTO mtl_interface_errors
6281: (unique_id,
6282: organization_id,
6283: transaction_id,
6284: table_name,
6325: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');
6326:
6327: IF specific_copy_flag = 'Y'
6328: THEN
6329: INSERT INTO mtl_interface_errors
6330: (unique_id,
6331: organization_id,
6332: transaction_id,
6333: table_name,
6693: WHILE l_index IS NOT NULL
6694: LOOP
6695: IF l_item_org_assign_tbl(l_index).status <> FND_API.G_RET_STS_SUCCESS
6696: THEN
6697: INSERT INTO mtl_interface_errors
6698: ( unique_id,
6699: organization_id,
6700: transaction_id,
6701: table_name,
6771:
6772: PROCEDURE purge_processed_request_errors (p_request_status IN VARCHAR2)
6773: IS
6774: BEGIN
6775: DELETE FROM mtl_interface_errors mie
6776: WHERE EXISTS (
6777: SELECT 1
6778: FROM bom_copy_structure_request bscr
6779: WHERE bscr.copy_request_id = mie.transaction_id
7218: eco_unit_number IN VARCHAR2 DEFAULT NULL,
7219: unit_number IN VARCHAR2 DEFAULT NULL,
7220: from_item_id IN NUMBER,
7221: -- Request Id for this copy operation. Value from BOM_COPY_STRUCTURE_REQUEST_S
7222: -- To populate the errors in MTL_INTERFACE_ERRORS with this transaction id
7223: p_copy_request_id IN NUMBER,
7224: -- Unit number for copy to item
7225: eco_end_item_rev_id IN NUMBER DEFAULT NULL,
7226: -- Structure has been exploded in context of this ECO for copying
9846: );
9847:
9848: IF l_no_access_comp_cnt > 0
9849: THEN
9850: INSERT INTO mtl_interface_errors
9851: (unique_id,
9852: organization_id,
9853: transaction_id,
9854: table_name,
9975: );
9976:
9977: IF l_no_access_comp_cnt > 0
9978: THEN
9979: INSERT INTO mtl_interface_errors
9980: (unique_id,
9981: organization_id,
9982: transaction_id,
9983: table_name,
10039: );
10040: END IF;
10041: END IF;
10042:
10043: -- Insert Error messages to MTL_INTERFACE_ERRORS for each error while copying
10044: INSERT INTO mtl_interface_errors
10045: (unique_id,
10046: organization_id,
10047: transaction_id,
10040: END IF;
10041: END IF;
10042:
10043: -- Insert Error messages to MTL_INTERFACE_ERRORS for each error while copying
10044: INSERT INTO mtl_interface_errors
10045: (unique_id,
10046: organization_id,
10047: transaction_id,
10048: table_name,
10142: OR ( p_cpy_past_eff_comps = 'N' AND bcb.from_end_item_rev_id = p_end_item_rev_id ) )
10143: )
10144: );
10145:
10146: INSERT INTO mtl_interface_errors
10147: (unique_id,
10148: organization_id,
10149: transaction_id,
10150: table_name,
10241: )
10242: );
10243:
10244:
10245: INSERT INTO mtl_interface_errors
10246: (unique_id,
10247: organization_id,
10248: transaction_id,
10249: table_name,
10346: OR ( p_cpy_past_eff_comps = 'N' AND bcb.from_end_item_rev_id = p_end_item_rev_id ) )
10347: )
10348: );
10349:
10350: INSERT INTO mtl_interface_errors
10351: (unique_id,
10352: organization_id,
10353: transaction_id,
10354: table_name,
10443: );
10444:
10445: -- For Item Revision Change Policy throw the errors if the components change not allowed
10446: IF l_to_eff_ctrl = 1 THEN
10447: INSERT INTO mtl_interface_errors
10448: (unique_id,
10449: organization_id,
10450: transaction_id,
10451: table_name,
10508: p_trgt_str_type_id, -- p_structure_type_id
10509: 'Y' -- p_use_eco
10510: );
10511: ELSIF l_to_eff_ctrl = 4 THEN
10512: INSERT INTO mtl_interface_errors
10513: (unique_id,
10514: organization_id,
10515: transaction_id,
10516: table_name,
10579: -- if revision does not exist.
10580: IF l_from_eff_ctrl = 4 AND l_to_eff_ctrl = 4
10581: AND from_org_id <> to_org_id
10582: THEN
10583: INSERT INTO mtl_interface_errors
10584: (unique_id,
10585: organization_id,
10586: transaction_id,
10587: table_name,
10915: --
10916: --
10917: -- Log errors for multi level structure copy.
10918: -- Planning bill should contain only planning components
10919: INSERT INTO mtl_interface_errors
10920: (unique_id,
10921: organization_id,
10922: transaction_id,
10923: table_name,
10969: AND msib1.organization_id = to_org_id
10970: AND bcb.revised_item_sequence_id = rev_item_seq_id;
10971:
10972: -- Standard bill without base model cannot have Option class or Model components.
10973: INSERT INTO mtl_interface_errors
10974: (unique_id,
10975: organization_id,
10976: transaction_id,
10977: table_name,
11024: AND msib1.organization_id = to_org_id
11025: AND bcb.revised_item_sequence_id = rev_item_seq_id;
11026:
11027: -- No ATO Optional components in PTO bill
11028: INSERT INTO mtl_interface_errors
11029: (unique_id,
11030: organization_id,
11031: transaction_id,
11032: table_name,
11079: AND msib1.organization_id = to_org_id
11080: AND bcb.revised_item_sequence_id = rev_item_seq_id;
11081:
11082: -- No ATO standard items for PTO standard bills
11083: INSERT INTO mtl_interface_errors
11084: (unique_id,
11085: organization_id,
11086: transaction_id,
11087: table_name,
11135: AND msib1.organization_id = to_org_id
11136: AND bcb.revised_item_sequence_id = rev_item_seq_id;
11137:
11138: -- No PTO components in ATO bill
11139: INSERT INTO mtl_interface_errors
11140: (unique_id,
11141: organization_id,
11142: transaction_id,
11143: table_name,
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,
11643: organization_id,
11644: transaction_id,
11645: table_name,
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,
11686: organization_id,
11687: transaction_id,
11688: table_name,