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_VALIDATE_BOM_HEADER dependencies on BOM_GLOBALS

Line 66: If Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quering Assembly item ' || to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;

62: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
63: l_return_status VARCHAR2(1);
64: BEGIN
65:
66: If Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quering Assembly item ' || to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;
67: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Org: ' || to_char(p_bom_head_unexp_rec.organization_id) || ' Alt: ' || p_bom_header_rec.alternate_bom_code ); END IF;
68:
69: /* bug 4133037, For creates we need to check for existance in bom_structures_b */
70:

Line 67: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Org: ' || to_char(p_bom_head_unexp_rec.organization_id) || ' Alt: ' || p_bom_header_rec.alternate_bom_code ); END IF;

63: l_return_status VARCHAR2(1);
64: BEGIN
65:
66: If Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Quering Assembly item ' || to_char(p_bom_head_unexp_rec.assembly_item_id)); END IF;
67: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Org: ' || to_char(p_bom_head_unexp_rec.organization_id) || ' Alt: ' || p_bom_header_rec.alternate_bom_code ); END IF;
68:
69: /* bug 4133037, For creates we need to check for existance in bom_structures_b */
70:
71: If(p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE) then

Line 71: If(p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE) then

67: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Org: ' || to_char(p_bom_head_unexp_rec.organization_id) || ' Alt: ' || p_bom_header_rec.alternate_bom_code ); END IF;
68:
69: /* bug 4133037, For creates we need to check for existance in bom_structures_b */
70:
71: If(p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE) then
72: Bom_Bom_Header_Util.Query_Table_Row
73: ( p_assembly_item_id =>
74: p_bom_head_unexp_rec.assembly_item_id
75: , p_alternate_bom_code =>

Line 97: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;

93: , x_return_status => l_return_status
94: );
95: end if;
96:
97: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
98:
99: IF l_return_status = BOM_Globals.G_RECORD_FOUND AND
100: p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE
101: THEN

Line 99: IF l_return_status = BOM_Globals.G_RECORD_FOUND AND

95: end if;
96:
97: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
98:
99: IF l_return_status = BOM_Globals.G_RECORD_FOUND AND
100: p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE
101: THEN
102: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
103: l_token_tbl(1).token_value :=

Line 100: p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE

96:
97: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
98:
99: IF l_return_status = BOM_Globals.G_RECORD_FOUND AND
100: p_bom_header_rec.transaction_type = BOM_Globals.G_OPR_CREATE
101: THEN
102: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
103: l_token_tbl(1).token_value :=
104: p_bom_header_rec.assembly_item_name;

Line 112: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND

108: , p_message_name => 'BOM_ASSY_ITEM_ALREADY_EXISTS'
109: , p_token_tbl => l_token_tbl
110: );
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
113: p_bom_header_rec.transaction_type IN
114: (BOM_Globals.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE)
115: THEN
116: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';

Line 114: (BOM_Globals.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE)

110: );
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
113: p_bom_header_rec.transaction_type IN
114: (BOM_Globals.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE)
115: THEN
116: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
117: l_token_tbl(1).token_value :=
118: p_bom_header_rec.assembly_item_name;

Line 144: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN

140:
141: /* Assign the relevant transaction type for SYNC operations */
142:
143: IF p_bom_header_rec.transaction_type = 'SYNC' THEN
144: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
145: x_old_bom_header_rec.transaction_type :=
146: Bom_Globals.G_OPR_UPDATE;
147: ELSE
148: x_old_bom_header_rec.transaction_type :=

Line 146: Bom_Globals.G_OPR_UPDATE;

142:
143: IF p_bom_header_rec.transaction_type = 'SYNC' THEN
144: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
145: x_old_bom_header_rec.transaction_type :=
146: Bom_Globals.G_OPR_UPDATE;
147: ELSE
148: x_old_bom_header_rec.transaction_type :=
149: Bom_Globals.G_OPR_CREATE;
150: END IF;

Line 149: Bom_Globals.G_OPR_CREATE;

145: x_old_bom_header_rec.transaction_type :=
146: Bom_Globals.G_OPR_UPDATE;
147: ELSE
148: x_old_bom_header_rec.transaction_type :=
149: Bom_Globals.G_OPR_CREATE;
150: END IF;
151: END IF;
152: l_return_status := FND_API.G_RET_STS_SUCCESS;
153:

Line 247: IF BOM_Globals.Get_STD_Item_Access IS NULL AND

243: l_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;
245:
246:
247: IF BOM_Globals.Get_STD_Item_Access IS NULL AND
248: BOM_Globals.Get_PLN_Item_Access IS NULL AND
249: BOM_Globals.Get_MDL_Item_Access IS NULL AND
250: BOM_Globals.Get_OC_Item_Access IS NULL
251: THEN

Line 248: BOM_Globals.Get_PLN_Item_Access IS NULL AND

244: END IF;
245:
246:
247: IF BOM_Globals.Get_STD_Item_Access IS NULL AND
248: BOM_Globals.Get_PLN_Item_Access IS NULL AND
249: BOM_Globals.Get_MDL_Item_Access IS NULL AND
250: BOM_Globals.Get_OC_Item_Access IS NULL
251: THEN
252: --

Line 249: BOM_Globals.Get_MDL_Item_Access IS NULL AND

245:
246:
247: IF BOM_Globals.Get_STD_Item_Access IS NULL AND
248: BOM_Globals.Get_PLN_Item_Access IS NULL AND
249: BOM_Globals.Get_MDL_Item_Access IS NULL AND
250: BOM_Globals.Get_OC_Item_Access IS NULL
251: THEN
252: --
253: -- Get respective profile values

Line 250: BOM_Globals.Get_OC_Item_Access IS NULL

246:
247: IF BOM_Globals.Get_STD_Item_Access IS NULL AND
248: BOM_Globals.Get_PLN_Item_Access IS NULL AND
249: BOM_Globals.Get_MDL_Item_Access IS NULL AND
250: BOM_Globals.Get_OC_Item_Access IS NULL
251: THEN
252: --
253: -- Get respective profile values
254: --

Line 255: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Checking item type access . . . '); END IF;

251: THEN
252: --
253: -- Get respective profile values
254: --
255: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Checking item type access . . . '); END IF;
256:
257: IF fnd_profile.value('BOM:STANDARD_ITEM_ACCESS') = '1'
258: THEN
259: BOM_Globals.Set_STD_Item_Access

Line 259: BOM_Globals.Set_STD_Item_Access

255: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Checking item type access . . . '); END IF;
256:
257: IF fnd_profile.value('BOM:STANDARD_ITEM_ACCESS') = '1'
258: THEN
259: BOM_Globals.Set_STD_Item_Access
260: ( p_std_item_access => 4);
261: ELSE
262: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('no access to standard items'); END IF;
263: BOM_Globals.Set_STD_Item_Access

Line 262: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('no access to standard items'); END IF;

258: THEN
259: BOM_Globals.Set_STD_Item_Access
260: ( p_std_item_access => 4);
261: ELSE
262: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('no access to standard items'); END IF;
263: BOM_Globals.Set_STD_Item_Access
264: (p_std_item_access => NULL);
265: END IF;
266:

Line 263: BOM_Globals.Set_STD_Item_Access

259: BOM_Globals.Set_STD_Item_Access
260: ( p_std_item_access => 4);
261: ELSE
262: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('no access to standard items'); END IF;
263: BOM_Globals.Set_STD_Item_Access
264: (p_std_item_access => NULL);
265: END IF;
266:
267: IF fnd_profile.value('BOM:MODEL_ITEM_ACCESS') = '1'

Line 269: BOM_Globals.Set_MDL_Item_Access

265: END IF;
266:
267: IF fnd_profile.value('BOM:MODEL_ITEM_ACCESS') = '1'
268: THEN
269: BOM_Globals.Set_MDL_Item_Access
270: ( p_mdl_item_access => 1);
271: BOM_Globals.Set_OC_Item_Access
272: ( p_oc_item_access => 2);
273: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Model/OC items are accessible. . . '); END IF;

Line 271: BOM_Globals.Set_OC_Item_Access

267: IF fnd_profile.value('BOM:MODEL_ITEM_ACCESS') = '1'
268: THEN
269: BOM_Globals.Set_MDL_Item_Access
270: ( p_mdl_item_access => 1);
271: BOM_Globals.Set_OC_Item_Access
272: ( p_oc_item_access => 2);
273: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Model/OC items are accessible. . . '); END IF;
274: ELSE
275: BOM_Globals.Set_MDL_Item_Access

Line 273: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Model/OC items are accessible. . . '); END IF;

269: BOM_Globals.Set_MDL_Item_Access
270: ( p_mdl_item_access => 1);
271: BOM_Globals.Set_OC_Item_Access
272: ( p_oc_item_access => 2);
273: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Model/OC items are accessible. . . '); END IF;
274: ELSE
275: BOM_Globals.Set_MDL_Item_Access
276: ( p_mdl_item_access => NULL);
277: BOM_Globals.Set_OC_Item_Access

Line 275: BOM_Globals.Set_MDL_Item_Access

271: BOM_Globals.Set_OC_Item_Access
272: ( p_oc_item_access => 2);
273: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Model/OC items are accessible. . . '); END IF;
274: ELSE
275: BOM_Globals.Set_MDL_Item_Access
276: ( p_mdl_item_access => NULL);
277: BOM_Globals.Set_OC_Item_Access
278: ( p_oc_item_access => NULL);
279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Model/OC item access denied . . . '); END IF;

Line 277: BOM_Globals.Set_OC_Item_Access

273: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Model/OC items are accessible. . . '); END IF;
274: ELSE
275: BOM_Globals.Set_MDL_Item_Access
276: ( p_mdl_item_access => NULL);
277: BOM_Globals.Set_OC_Item_Access
278: ( p_oc_item_access => NULL);
279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Model/OC item access denied . . . '); END IF;
280: END IF;
281:

Line 279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Model/OC item access denied . . . '); END IF;

275: BOM_Globals.Set_MDL_Item_Access
276: ( p_mdl_item_access => NULL);
277: BOM_Globals.Set_OC_Item_Access
278: ( p_oc_item_access => NULL);
279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(' Model/OC item access denied . . . '); END IF;
280: END IF;
281:
282: IF fnd_profile.value('BOM:PLANNING_ITEM_ACCESS') = '1'
283: THEN

Line 284: BOM_Globals.Set_PLN_Item_Access

280: END IF;
281:
282: IF fnd_profile.value('BOM:PLANNING_ITEM_ACCESS') = '1'
283: THEN
284: BOM_Globals.Set_PLN_Item_Access
285: ( p_pln_item_access => 3);
286: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item accessible. . . '); END IF;
287: ELSE
288: BOM_Globals.Set_PLN_Item_Access

Line 286: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item accessible. . . '); END IF;

282: IF fnd_profile.value('BOM:PLANNING_ITEM_ACCESS') = '1'
283: THEN
284: BOM_Globals.Set_PLN_Item_Access
285: ( p_pln_item_access => 3);
286: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item accessible. . . '); END IF;
287: ELSE
288: BOM_Globals.Set_PLN_Item_Access
289: ( p_pln_item_access => NULL);
290: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item access denied. . . '); END IF;

Line 288: BOM_Globals.Set_PLN_Item_Access

284: BOM_Globals.Set_PLN_Item_Access
285: ( p_pln_item_access => 3);
286: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item accessible. . . '); END IF;
287: ELSE
288: BOM_Globals.Set_PLN_Item_Access
289: ( p_pln_item_access => NULL);
290: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item access denied. . . '); END IF;
291: END IF;
292: END IF;

Line 290: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item access denied. . . '); END IF;

286: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item accessible. . . '); END IF;
287: ELSE
288: BOM_Globals.Set_PLN_Item_Access
289: ( p_pln_item_access => NULL);
290: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Planning item access denied. . . '); END IF;
291: END IF;
292: END IF;
293:
294: --

Line 299: ( NVL(BOM_Globals.Get_STD_Item_Access, 0),

295: -- Use BOM Item Type of the Assembly Item that is queried above
296: -- to check if user has access to it.
297: --
298: IF l_Bom_Item_Type NOT IN
299: ( NVL(BOM_Globals.Get_STD_Item_Access, 0),
300: NVL(BOM_Globals.Get_PLN_Item_Access, 0),
301: NVL(BOM_Globals.Get_OC_Item_Access, 0) ,
302: NVL(BOM_Globals.Get_MDL_Item_Access, 0),
303: BOM_Globals.G_PRODUCT_FAMILY

Line 300: NVL(BOM_Globals.Get_PLN_Item_Access, 0),

296: -- to check if user has access to it.
297: --
298: IF l_Bom_Item_Type NOT IN
299: ( NVL(BOM_Globals.Get_STD_Item_Access, 0),
300: NVL(BOM_Globals.Get_PLN_Item_Access, 0),
301: NVL(BOM_Globals.Get_OC_Item_Access, 0) ,
302: NVL(BOM_Globals.Get_MDL_Item_Access, 0),
303: BOM_Globals.G_PRODUCT_FAMILY
304: )

Line 301: NVL(BOM_Globals.Get_OC_Item_Access, 0) ,

297: --
298: IF l_Bom_Item_Type NOT IN
299: ( NVL(BOM_Globals.Get_STD_Item_Access, 0),
300: NVL(BOM_Globals.Get_PLN_Item_Access, 0),
301: NVL(BOM_Globals.Get_OC_Item_Access, 0) ,
302: NVL(BOM_Globals.Get_MDL_Item_Access, 0),
303: BOM_Globals.G_PRODUCT_FAMILY
304: )
305: THEN

Line 302: NVL(BOM_Globals.Get_MDL_Item_Access, 0),

298: IF l_Bom_Item_Type NOT IN
299: ( NVL(BOM_Globals.Get_STD_Item_Access, 0),
300: NVL(BOM_Globals.Get_PLN_Item_Access, 0),
301: NVL(BOM_Globals.Get_OC_Item_Access, 0) ,
302: NVL(BOM_Globals.Get_MDL_Item_Access, 0),
303: BOM_Globals.G_PRODUCT_FAMILY
304: )
305: THEN
306: l_Token_Tbl(1).Token_Name := 'BOM_ITEM_TYPE';

Line 303: BOM_Globals.G_PRODUCT_FAMILY

299: ( NVL(BOM_Globals.Get_STD_Item_Access, 0),
300: NVL(BOM_Globals.Get_PLN_Item_Access, 0),
301: NVL(BOM_Globals.Get_OC_Item_Access, 0) ,
302: NVL(BOM_Globals.Get_MDL_Item_Access, 0),
303: BOM_Globals.G_PRODUCT_FAMILY
304: )
305: THEN
306: l_Token_Tbl(1).Token_Name := 'BOM_ITEM_TYPE';
307: l_Token_Tbl(1).Translate := TRUE;

Line 334: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check Access returning with ' || l_return_status ); END IF;

330:
331: x_return_status := l_return_status;
332: x_mesg_token_tbl := l_mesg_token_tbl;
333:
334: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check Access returning with ' || l_return_status ); END IF;
335:
336: END Check_Access;
337:
338:

Line 367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Within Bom Header Check Attributes . . . '); END IF;

363: BEGIN
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Within Bom Header Check Attributes . . . '); END IF;
368:
369: IF p_bom_header_rec.alternate_bom_code IS NOT NULL AND
370: p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
371: AND

Line 558: IF Bom_Globals.IS_PIM_PDS_ENABLED = 'N'

554: THEN
555:
556: --
557: -- Verify If PIM_PDS profiles are enabled to create a Packaging Hierarchy
558: IF Bom_Globals.IS_PIM_PDS_ENABLED = 'N'
559: THEN
560: Error_Handler.Add_Error_Token
561: ( p_message_name => 'BOM_CREATE_PACK_HIER_NOT_ALLOW'
562: , p_mesg_token_tbl => l_Mesg_Token_Tbl

Line 595: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND

591: ---
592: -- Do not allow packaging hierarchies to be created in child orgs.
593: -- Pkg Hiers cannonly be commoned from the master org.
594: ---
595: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
596: p_bom_head_unexp_rec.source_bill_sequence_id IS NULL
597: THEN
598: SELECT master_organization_id INTO l_mater_org_id FROM mtl_parameters
599: WHERE organization_id = p_bom_head_unexp_rec.organization_id;

Line 691: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

687: END IF; -- end if l_count = 0
688: END IF; -- end if p_bom_header_rec.alternate_bom_code IS NOT NULL
689:
690: -- In update case, the new structure type must be a child of the existing one
691: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
692: AND p_bom_head_unexp_rec.structure_type_id IS NOT NULL
693: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM
694: AND p_bom_head_unexp_rec.structure_type_id <> p_old_bom_head_unexp_rec.structure_type_id )
695: THEN

Line 730: END IF; -- end if p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

726: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
727: , p_Token_Tbl => l_token_tbl
728: );
729: END IF; -- end if l_count = 0
730: END IF; -- end if p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
731:
732:
733: /** -------------------------------------------------------------
734: ** When commoning a bill, either creating or updating an existing

Line 766: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE

762: -- must not enter the value for common organization code and
763: -- common assembly item name. Providing these values would mean that
764: -- the user is attempting to update these non-updateable columns
765: --
766: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
767: AND
768: ( ( p_bom_header_rec.common_organization_code IS NOT NULL
769: AND p_bom_header_rec.common_organization_code <>
770: FND_API.G_MISS_CHAR

Line 945: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND

941:
942: --
943: -- Validation for inter-org common
944: --
945: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
946: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
947: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
948: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL AND
949: p_old_bom_head_unexp_rec.organization_id <>

Line 953: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND

949: p_old_bom_head_unexp_rec.organization_id <>
950: p_bom_head_unexp_rec.common_organization_id
951: )
952: OR
953: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
954: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
955: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
956: p_bom_head_unexp_rec.common_organization_id <>
957: p_bom_head_unexp_rec.organization_id

Line 966: DECODE(p_bom_header_rec.transaction_type, Bom_Globals.G_OPR_CREATE,

962: INTO l_dummy
963: FROM mtl_parameters mp1, mtl_parameters mp2
964: WHERE mp1.organization_id = p_bom_head_unexp_rec.organization_id
965: AND mp2.organization_id =
966: DECODE(p_bom_header_rec.transaction_type, Bom_Globals.G_OPR_CREATE,
967: p_bom_head_unexp_rec.common_organization_id,
968: Bom_Globals.G_OPR_UPDATE,
969: p_old_bom_head_unexp_rec.common_organization_id
970: )

Line 968: Bom_Globals.G_OPR_UPDATE,

964: WHERE mp1.organization_id = p_bom_head_unexp_rec.organization_id
965: AND mp2.organization_id =
966: DECODE(p_bom_header_rec.transaction_type, Bom_Globals.G_OPR_CREATE,
967: p_bom_head_unexp_rec.common_organization_id,
968: Bom_Globals.G_OPR_UPDATE,
969: p_old_bom_head_unexp_rec.common_organization_id
970: )
971: AND mp1.master_organization_id = mp2.master_organization_id;
972:

Line 1247: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND

1243: -- check to see if bill item and common item have same bom_item_type,
1244: -- pick_components_flag and replenish_to_order_flag
1245: -- Common item must have bom_enabled_flag = 'Y'
1246: --
1247: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
1248: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1249: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
1250: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL
1251: )

Line 1253: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND

1249: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
1250: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL
1251: )
1252: OR
1253: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
1254: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1255: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM
1256: )
1257: THEN