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 ERROR_HANDLER

Line 30: g_token_tbl Error_Handler.Token_Tbl_Type;

26: -- 20-Jun-05 Vani Hymavathi Validations for to OPM convergence project
27: -- 13-JUL-06 Bhavnesh Patel Added support for Structure Type
28: ****************************************************************************/
29: G_Pkg_Name VARCHAR2(30) := 'BOM_Validate_Bom_Header';
30: g_token_tbl Error_Handler.Token_Tbl_Type;
31:
32:
33: /*******************************************************************
34: * Procedure : Check_Existence

Line 57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

53: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
54: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
55: , x_old_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
56: , x_old_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
58: , x_return_status IN OUT NOCOPY VARCHAR2
59: )
60: IS
61: l_token_tbl Error_Handler.Token_Tbl_Type;

Line 61: l_token_tbl Error_Handler.Token_Tbl_Type;

57: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
58: , x_return_status IN OUT NOCOPY VARCHAR2
59: )
60: IS
61: l_token_tbl Error_Handler.Token_Tbl_Type;
62: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
63: l_return_status VARCHAR2(1);
64: BEGIN
65:

Line 62: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

58: , x_return_status IN OUT NOCOPY VARCHAR2
59: )
60: IS
61: l_token_tbl Error_Handler.Token_Tbl_Type;
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;

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 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 105: Error_Handler.Add_Error_Token

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;
105: Error_Handler.Add_Error_Token
106: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
107: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
108: , p_message_name => 'BOM_ASSY_ITEM_ALREADY_EXISTS'
109: , p_token_tbl => l_token_tbl

Line 119: Error_Handler.Add_Error_Token

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;
119: Error_Handler.Add_Error_Token
120: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
121: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
122: , p_message_name => 'BOM_ASSY_ITEM_DOESNOT_EXISTS'
123: , p_token_tbl => l_token_tbl

Line 128: Error_Handler.Add_Error_Token

124: );
125: l_return_status := FND_API.G_RET_STS_ERROR;
126: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
127: THEN
128: Error_Handler.Add_Error_Token
129: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
130: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
131: , p_message_name => NULL
132: , p_message_text =>

Line 178: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type

174: PROCEDURE Check_Access
175: ( p_assembly_item_id IN NUMBER
176: , p_alternate_bom_code IN VARCHAR2
177: , p_organization_id IN NUMBER
178: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
179: := Error_Handler.G_MISS_MESG_TOKEN_TBL
180: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
181: , x_return_status IN OUT NOCOPY VARCHAR2
182: )

Line 179: := Error_Handler.G_MISS_MESG_TOKEN_TBL

175: ( p_assembly_item_id IN NUMBER
176: , p_alternate_bom_code IN VARCHAR2
177: , p_organization_id IN NUMBER
178: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
179: := Error_Handler.G_MISS_MESG_TOKEN_TBL
180: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
181: , x_return_status IN OUT NOCOPY VARCHAR2
182: )
183: IS

Line 180: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

176: , p_alternate_bom_code IN VARCHAR2
177: , p_organization_id IN NUMBER
178: , p_mesg_token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
179: := Error_Handler.G_MISS_MESG_TOKEN_TBL
180: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
181: , x_return_status IN OUT NOCOPY VARCHAR2
182: )
183: IS
184: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 185: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type :=

181: , x_return_status IN OUT NOCOPY VARCHAR2
182: )
183: IS
184: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
185: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type :=
186: p_mesg_token_tbl;
187: l_bom_item_type NUMBER;
188: l_assembly_type NUMBER;
189: l_tracking_qty_ind VARCHAR2(30);

Line 191: l_token_tbl Error_Handler.Token_Tbl_Type;

187: l_bom_item_type NUMBER;
188: l_assembly_type NUMBER;
189: l_tracking_qty_ind VARCHAR2(30);
190: l_OPM_org VARCHAR2(1);
191: l_token_tbl Error_Handler.Token_Tbl_Type;
192:
193: BEGIN
194:
195: SELECT bom_item_type, decode(eng_item_flag, 'N', 1, 2)

Line 214: Error_Handler.Add_Error_Token

210: --
211:
212: /*IF l_assembly_type = 2 -- Engineering Item
213: THEN
214: Error_Handler.Add_Error_Token
215: ( p_Message_name => 'BOM_ASSEMBLY_TYPE_ENG'
216: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
217: , x_mesg_token_tbl => l_mesg_token_tbl
218: );

Line 226: Error_Handler.Add_Error_Token

222: /* Validations for OPM Convergence Project
223: Model/Option class bills are not allowed in OPM organizations*/
224:
225: IF (l_OPM_org='Y' and l_bom_item_type in (1,2))THEN
226: Error_Handler.Add_Error_Token
227: ( p_Message_name => 'BOM_OPM_ORG_MODEL_OC'
228: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
229: , x_mesg_token_tbl => l_mesg_token_tbl
230: );

Line 238: Error_Handler.Add_Error_Token

234: /* Validations for OPM Convergence Project
235: Dual UOM controlled items should not be allowed*/
236:
237: IF (l_tracking_qty_ind<>'P' )THEN
238: Error_Handler.Add_Error_Token
239: ( p_Message_name => 'BOM_DUAL_UOM_ITEMS'
240: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
241: , x_mesg_token_tbl => l_mesg_token_tbl
242: );

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 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 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 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 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 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 322: Error_Handler.Add_Error_Token

318: THEN
319: l_Token_Tbl(1).Token_Value := 'BOM_STANDARD';
320: END IF;
321:
322: Error_Handler.Add_Error_Token
323: ( p_Message_Name => 'BOM_ASSY_ITEM_ACCESS_DENIED'
324: , p_Mesg_Token_Tbl => l_mesg_token_tbl
325: , x_Mesg_Token_Tbl => l_mesg_token_tbl
326: , p_Token_Tbl => l_token_tbl

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 352: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

348: * revised item attrbiute in its entirety.
349: **********************************************************************/
350: PROCEDURE Check_Attributes
351: ( x_return_status IN OUT NOCOPY VARCHAR2
352: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
353: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
354: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
355: , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
356: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type

Line 360: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

356: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
357: )
358: IS
359: l_err_text VARCHAR2(2000) := NULL;
360: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
361: l_Token_Tbl Error_Handler.Token_Tbl_Type;
362:
363: BEGIN
364:

Line 361: l_Token_Tbl Error_Handler.Token_Tbl_Type;

357: )
358: IS
359: l_err_text VARCHAR2(2000) := NULL;
360: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
361: l_Token_Tbl Error_Handler.Token_Tbl_Type;
362:
363: BEGIN
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 388: Error_Handler.Add_Error_Token

384: l_token_tbl(1).token_name :=
385: 'ALTERNATE_BOM_CODE';
386: l_token_tbl(1).token_value :=
387: p_bom_header_rec.alternate_bom_code;
388: Error_Handler.Add_Error_Token
389: ( p_token_tbl => l_token_tbl
390: , p_message_name =>
391: 'BOM_ALTERNATE_DESG_INVALID'
392: , p_mesg_token_tbl => l_mesg_token_tbl

Line 409: Error_Handler.Add_Error_Token

405: p_bom_header_rec.assembly_item_name;
406: l_token_tbl(2).token_name := 'ASSEMBLY_TYPE';
407: l_token_tbl(2).token_value :=
408: p_bom_header_rec.assembly_type;
409: Error_Handler.Add_Error_Token
410: ( p_message_name => 'BOM_ASSEMBLY_TYPE_INVALID'
411: , p_token_tbl => l_token_tbl
412: , p_mesg_token_tbl => l_mesg_token_tbl
413: , x_mesg_token_tbl => l_mesg_token_tbl

Line 431: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

427: * Purpose :
428: **********************************************************************/
429: PROCEDURE Check_Required
430: ( x_return_status IN OUT NOCOPY VARCHAR2
431: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
432: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
433: )
434: IS
435: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 435: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

431: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
432: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
433: )
434: IS
435: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
436: l_Token_Tbl Error_Handler.Token_Tbl_Type;
437: BEGIN
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:

Line 436: l_Token_Tbl Error_Handler.Token_Tbl_Type;

432: , p_bom_header_Rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
433: )
434: IS
435: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
436: l_Token_Tbl Error_Handler.Token_Tbl_Type;
437: BEGIN
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440: IF ( p_bom_header_rec.common_organization_code IS NOT NULL AND

Line 457: Error_Handler.Add_Error_Token

453: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
454: l_token_tbl(1).token_value :=
455: p_bom_header_rec.assembly_item_name;
456:
457: Error_Handler.Add_Error_Token
458: ( p_message_name => 'BOM_COMMON_ASSY_REQUIRED'
459: , p_token_tbl => l_Token_tbl
460: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
461: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 491: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

487: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
488: , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
489: , p_old_bom_head_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
490: , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
491: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
492: , x_return_status IN OUT NOCOPY VARCHAR2
493: )
494: IS
495: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 496: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

492: , x_return_status IN OUT NOCOPY VARCHAR2
493: )
494: IS
495: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
496: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
497: l_Token_Tbl Error_Handler.Token_Tbl_Type;
498: l_dummy VARCHAR2(1);
499: l_valid_op_seq VARCHAR2(1);
500: bit NUMBER;

Line 497: l_Token_Tbl Error_Handler.Token_Tbl_Type;

493: )
494: IS
495: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
496: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
497: l_Token_Tbl Error_Handler.Token_Tbl_Type;
498: l_dummy VARCHAR2(1);
499: l_valid_op_seq VARCHAR2(1);
500: bit NUMBER;
501: base_id NUMBER;

Line 537: Error_Handler.Add_Error_Token

533: g_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
534: g_token_tbl(1).token_value :=
535: p_bom_header_rec.assembly_item_name;
536:
537: Error_Handler.Add_Error_Token
538: ( p_message_name => 'BOM_REV_ITEM_BOM_NOT_ENABLED'
539: , p_mesg_token_tbl => l_Mesg_Token_Tbl
540: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
541: , p_token_tbl => g_token_tbl

Line 560: Error_Handler.Add_Error_Token

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
563: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
564: );

Line 582: Error_Handler.Add_Error_Token

578: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;
579: l_token_tbl(2).token_name := 'STRUCTURE_TYPE';
580: l_token_tbl(2).token_value := p_bom_header_rec.Structure_Type_Name;
581:
582: Error_Handler.Add_Error_Token
583: ( p_Message_Name => 'BOM_STRUCTNAMEANDTYPE_INVALID'
584: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
585: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
586: , p_Token_Tbl => l_token_tbl

Line 601: Error_Handler.Add_Error_Token

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;
600: IF (p_bom_head_unexp_rec.organization_id <> l_mater_org_id) THEN
601: Error_Handler.Add_Error_Token
602: ( p_message_name => 'BOM_PKG_HIERARCHY_IN_CHILD_ORG'
603: , p_mesg_token_tbl => l_Mesg_Token_Tbl
604: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
605: );

Line 641: Error_Handler.Add_Error_Token

637: l_token_tbl(1).token_name :=
638: 'ASSEMBLY_ITEM_NAME';
639: l_token_tbl(1).token_value :=
640: p_bom_header_rec.assembly_item_name;
641: Error_Handler.Add_Error_Token
642: ( p_message_name =>
643: 'BOM_CANNOT_ADD_ALTERNATE'
644: , p_token_tbl => l_token_tbl
645: , p_mesg_token_tbl => l_mesg_token_tbl

Line 681: Error_Handler.Add_Error_Token

677: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;
678: l_token_tbl(2).token_name := 'STRUCTURE_TYPE';
679: l_token_tbl(2).token_value := p_bom_header_rec.Structure_Type_Name;
680:
681: Error_Handler.Add_Error_Token
682: ( p_Message_Name => 'BOM_STRUCTNAMEANDTYPE_INVALID'
683: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
684: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
685: , p_Token_Tbl => l_token_tbl

Line 723: Error_Handler.Add_Error_Token

719:
720: l_token_tbl(2).token_name := 'NEW_STRTYPE';
721: l_token_tbl(2).token_value := p_bom_header_rec.structure_type_name;
722:
723: Error_Handler.Add_Error_Token
724: ( p_Message_Name => 'BOM_UPDATE_STRTYPE_INVALID'
725: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
726: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
727: , p_Token_Tbl => l_token_tbl

Line 787: Error_Handler.Add_Error_Token

783:
784: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
785: l_token_tbl(1).token_value :=
786: p_bom_header_rec.assembly_item_name;
787: Error_Handler.Add_Error_Token
788: ( p_message_name =>
789: 'BOM_COMMON_ORG_ASSY_NONUPD'
790: , p_token_tbl => l_token_tbl
791: , p_mesg_token_tbl => l_mesg_token_tbl

Line 810: Error_Handler.Add_Error_Token

806: THEN
807: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
808: l_token_tbl(1).token_value :=
809: p_bom_header_rec.assembly_item_name;
810: Error_Handler.Add_Error_Token
811: ( p_message_name =>
812: 'BOM_ASSY_COMMON_REF_COMMON'
813: , p_token_tbl => l_token_tbl
814: , p_mesg_token_tbl => l_mesg_token_tbl

Line 849: Error_Handler.Add_Error_Token

845: p_bom_header_rec.common_assembly_item_name;
846: l_token_tbl(2).token_name := 'ASSEMBLY_ITEM_NAME';
847: l_token_tbl(2).token_value :=
848: p_bom_header_rec.assembly_item_name;
849: Error_Handler.Add_Error_Token
850: ( p_message_name =>
851: 'BOM_ASSY_COMMON_OTHER_ASSY'
852: , p_token_tbl => l_token_tbl
853: , p_mesg_token_tbl => l_mesg_token_tbl

Line 895: Error_Handler.Add_Error_Token

891: l_token_tbl(2).token_name :=
892: 'COMMON_ASSEMBLY_ITEM_NAME';
893: l_token_tbl(2).token_value :=
894: p_bom_header_rec.common_assembly_item_name;
895: Error_Handler.Add_Error_Token
896: ( p_message_name =>
897: 'BOM_COMMON_ASSY_TYPE_MISMATCH'
898: , p_token_tbl => l_token_tbl
899: , p_mesg_token_tbl => l_mesg_token_tbl

Line 929: Error_Handler.Add_Error_Token

925: l_token_tbl(4).token_value := p_bom_header_rec.organization_code;
926: l_token_tbl(5).token_name := 'ASSEMBLY_ITEM_NAME1';
927: l_token_tbl(5).token_value := p_bom_header_rec.assembly_item_name;
928:
929: Error_Handler.Add_Error_Token
930: ( p_message_name =>
931: 'BOM_COMMON_OPN_INVALID'
932: , p_token_tbl => l_token_tbl
933: , p_mesg_token_tbl => l_mesg_token_tbl

Line 990: Error_Handler.Add_Error_Token

986: l_token_tbl(4).token_name := 'COMMON_ORG_CODE';
987: l_token_tbl(4).token_value :=
988: p_bom_header_rec.common_organization_code;
989:
990: Error_Handler.Add_Error_Token
991: ( p_message_name =>
992: 'BOM_COMMON_MASTER_ORG_MISMATCH'
993: , p_token_tbl => l_token_tbl
994: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1020: Error_Handler.Add_Error_Token

1016: l_token_tbl(3).token_value := p_bom_header_rec.common_organization_code;
1017: l_token_tbl(4).token_name := 'DEST_ORG';
1018: l_token_tbl(4).token_value := p_bom_header_rec.organization_code;
1019:
1020: Error_Handler.Add_Error_Token
1021: ( p_message_name =>
1022: 'BOM_COMMON_OPN_INVALID'
1023: , p_token_tbl => l_token_tbl
1024: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1119: Error_Handler.Add_Error_Token

1115: l_token_tbl(3).token_name := 'COMMON_ORG_CODE';
1116: l_token_tbl(3).token_value :=
1117: p_bom_header_rec.common_organization_code;
1118:
1119: Error_Handler.Add_Error_Token
1120: ( p_message_name => 'BOM_COMMON_COMP_PROP_MISMATCH'
1121: , p_token_tbl => l_token_tbl
1122: , p_mesg_token_tbl => l_mesg_token_tbl
1123: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1145: Error_Handler.Add_Error_Token

1141: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;
1142: l_token_tbl(2).token_name := 'ORG_CODE';
1143: l_token_tbl(2).token_value := p_bom_header_rec.organization_code;
1144:
1145: Error_Handler.Add_Error_Token
1146: ( p_message_name => 'BOM_SRC_COMP_FIXED_REV'
1147: , p_token_tbl => l_token_tbl
1148: , p_mesg_token_tbl => l_mesg_token_tbl
1149: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1231: Error_Handler.Add_Error_Token

1227: l_token_tbl(3).token_name := 'COMMON_ORG_CODE';
1228: l_token_tbl(3).token_value :=
1229: p_bom_header_rec.common_organization_code;
1230:
1231: Error_Handler.Add_Error_Token
1232: ( p_message_name => 'BOM_COMMON_SCOMP_NOTINALLORG'
1233: , p_token_tbl => l_token_tbl
1234: , p_mesg_token_tbl => l_mesg_token_tbl
1235: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1286: Error_Handler.Add_Error_Token

1282: p_bom_header_rec.common_organization_code;
1283: l_token_tbl(3).token_name := 'ORG_CODE';
1284: l_token_tbl(3).token_value := p_bom_header_rec.organization_code;
1285:
1286: Error_Handler.Add_Error_Token
1287: ( p_message_name => 'BOM_COMMON_ATOPTO_MISMATCH'
1288: , p_token_tbl => l_token_tbl
1289: , p_mesg_token_tbl => l_mesg_token_tbl
1290: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1304: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1300:
1301:
1302: PROCEDURE Check_Entity_Delete
1303: ( x_return_status IN OUT NOCOPY VARCHAR2
1304: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1305: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1306: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1307: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1308: )

Line 1310: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

1306: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1307: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1308: )
1309: IS
1310: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1311: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1312: := p_bom_head_Unexp_Rec;
1313: Cursor CheckGroup is
1314: SELECT description,

Line 1328: Error_Handler.Add_Error_Token

1324:
1325: IF p_bom_header_rec.Delete_Group_Name IS NULL OR
1326: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR
1327: THEN
1328: Error_Handler.Add_Error_Token
1329: ( p_message_name => 'BOM_DG_NAME_MISSING'
1330: , p_mesg_token_tbl => l_mesg_token_tbl
1331: , x_mesg_token_tbl => x_mesg_token_tbl
1332: );

Line 1340: Error_Handler.Add_Error_Token

1336:
1337: For c_CheckGroup in CheckGroup
1338: LOOP
1339: If c_CheckGroup.delete_type <> 2 /* Bill */ then
1340: Error_Handler.Add_Error_Token
1341: ( p_message_name => 'BOM_DUPLICATE_DELETE_GROUP'
1342: , p_mesg_token_tbl=>l_mesg_token_tbl
1343: , x_mesg_token_tbl=>x_mesg_token_tbl
1344: );

Line 1361: Error_Handler.Add_Error_Token

1357: END LOOP;
1358:
1359: IF l_bom_head_unexp_rec.DG_sequence_id IS NULL
1360: THEN
1361: Error_Handler.Add_Error_Token
1362: ( p_message_name => 'NEW_DELETE_GROUP'
1363: , p_message_type => 'W'
1364: , p_mesg_token_tbl => l_mesg_token_tbl
1365: , x_mesg_token_tbl => x_mesg_token_tbl