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

544: g_token_tbl(1).token_name := 'REVISED_ITEM_NAME';
545: g_token_tbl(1).token_value :=
546: p_bom_header_rec.assembly_item_name;
547:
548: Error_Handler.Add_Error_Token
549: ( p_message_name => 'BOM_REV_ITEM_BOM_NOT_ENABLED'
550: , p_mesg_token_tbl => l_Mesg_Token_Tbl
551: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
552: , p_token_tbl => g_token_tbl

Line 569: Error_Handler.Add_Error_Token

565: l_return_status := FND_API.G_RET_STS_ERROR;
566: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
567: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;
568: IF l_dummy = 'E' THEN
569: Error_Handler.Add_Error_Token
570: ( p_message_name => 'BOM_ENG_ITEM_MANF_BILL'
571: , p_token_tbl => l_token_tbl
572: , p_mesg_token_tbl => l_mesg_token_tbl
573: , x_mesg_token_tbl => l_mesg_token_tbl

Line 576: Error_Handler.Add_Error_Token

572: , p_mesg_token_tbl => l_mesg_token_tbl
573: , x_mesg_token_tbl => l_mesg_token_tbl
574: );
575: /* ELSE
576: Error_Handler.Add_Error_Token
577: ( p_message_name => 'BOM_MANF_ITEM_ENG_BILL'
578: , p_token_tbl => l_token_tbl
579: , p_mesg_token_tbl => l_mesg_token_tbl
580: , x_mesg_token_tbl => l_mesg_token_tbl

Line 597: Error_Handler.Add_Error_Token

593: --
594: -- Verify If PIM_PDS profiles are enabled to create a Packaging Hierarchy
595: IF Bom_Globals.IS_PIM_PDS_ENABLED = 'N'
596: THEN
597: Error_Handler.Add_Error_Token
598: ( p_message_name => 'BOM_CREATE_PACK_HIER_NOT_ALLOW'
599: , p_mesg_token_tbl => l_Mesg_Token_Tbl
600: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
601: );

Line 619: Error_Handler.Add_Error_Token

615: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;
616: l_token_tbl(2).token_name := 'STRUCTURE_TYPE';
617: l_token_tbl(2).token_value := p_bom_header_rec.Structure_Type_Name;
618:
619: Error_Handler.Add_Error_Token
620: ( p_Message_Name => 'BOM_STRUCTNAMEANDTYPE_INVALID'
621: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
622: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
623: , p_Token_Tbl => l_token_tbl

Line 638: Error_Handler.Add_Error_Token

634: THEN
635: SELECT master_organization_id INTO l_mater_org_id FROM mtl_parameters
636: WHERE organization_id = p_bom_head_unexp_rec.organization_id;
637: IF (p_bom_head_unexp_rec.organization_id <> l_mater_org_id) THEN
638: Error_Handler.Add_Error_Token
639: ( p_message_name => 'BOM_PKG_HIERARCHY_IN_CHILD_ORG'
640: , p_mesg_token_tbl => l_Mesg_Token_Tbl
641: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
642: );

Line 678: Error_Handler.Add_Error_Token

674: l_token_tbl(1).token_name :=
675: 'ASSEMBLY_ITEM_NAME';
676: l_token_tbl(1).token_value :=
677: p_bom_header_rec.assembly_item_name;
678: Error_Handler.Add_Error_Token
679: ( p_message_name =>
680: 'BOM_CANNOT_ADD_ALTERNATE'
681: , p_token_tbl => l_token_tbl
682: , p_mesg_token_tbl => l_mesg_token_tbl

Line 718: Error_Handler.Add_Error_Token

714: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;
715: l_token_tbl(2).token_name := 'STRUCTURE_TYPE';
716: l_token_tbl(2).token_value := p_bom_header_rec.Structure_Type_Name;
717:
718: Error_Handler.Add_Error_Token
719: ( p_Message_Name => 'BOM_STRUCTNAMEANDTYPE_INVALID'
720: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
721: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
722: , p_Token_Tbl => l_token_tbl

Line 760: Error_Handler.Add_Error_Token

756:
757: l_token_tbl(2).token_name := 'NEW_STRTYPE';
758: l_token_tbl(2).token_value := p_bom_header_rec.structure_type_name;
759:
760: Error_Handler.Add_Error_Token
761: ( p_Message_Name => 'BOM_UPDATE_STRTYPE_INVALID'
762: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
763: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
764: , p_Token_Tbl => l_token_tbl

Line 824: Error_Handler.Add_Error_Token

820:
821: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
822: l_token_tbl(1).token_value :=
823: p_bom_header_rec.assembly_item_name;
824: Error_Handler.Add_Error_Token
825: ( p_message_name =>
826: 'BOM_COMMON_ORG_ASSY_NONUPD'
827: , p_token_tbl => l_token_tbl
828: , p_mesg_token_tbl => l_mesg_token_tbl

Line 851: Error_Handler.Add_Error_Token

847: THEN
848: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
849: l_token_tbl(1).token_value :=
850: p_bom_header_rec.assembly_item_name;
851: Error_Handler.Add_Error_Token
852: ( p_message_name =>
853: 'BOM_ASSY_COMMON_REF_COMMON'
854: , p_token_tbl => l_token_tbl
855: , p_mesg_token_tbl => l_mesg_token_tbl

Line 890: Error_Handler.Add_Error_Token

886: p_bom_header_rec.common_assembly_item_name;
887: l_token_tbl(2).token_name := 'ASSEMBLY_ITEM_NAME';
888: l_token_tbl(2).token_value :=
889: p_bom_header_rec.assembly_item_name;
890: Error_Handler.Add_Error_Token
891: ( p_message_name =>
892: 'BOM_ASSY_COMMON_OTHER_ASSY'
893: , p_token_tbl => l_token_tbl
894: , p_mesg_token_tbl => l_mesg_token_tbl

Line 936: Error_Handler.Add_Error_Token

932: l_token_tbl(2).token_name :=
933: 'COMMON_ASSEMBLY_ITEM_NAME';
934: l_token_tbl(2).token_value :=
935: p_bom_header_rec.common_assembly_item_name;
936: Error_Handler.Add_Error_Token
937: ( p_message_name =>
938: 'BOM_COMMON_ASSY_TYPE_MISMATCH'
939: , p_token_tbl => l_token_tbl
940: , p_mesg_token_tbl => l_mesg_token_tbl

Line 970: Error_Handler.Add_Error_Token

966: l_token_tbl(4).token_value := p_bom_header_rec.organization_code;
967: l_token_tbl(5).token_name := 'ASSEMBLY_ITEM_NAME1';
968: l_token_tbl(5).token_value := p_bom_header_rec.assembly_item_name;
969:
970: Error_Handler.Add_Error_Token
971: ( p_message_name =>
972: 'BOM_COMMON_OPN_INVALID'
973: , p_token_tbl => l_token_tbl
974: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1031: Error_Handler.Add_Error_Token

1027: l_token_tbl(4).token_name := 'COMMON_ORG_CODE';
1028: l_token_tbl(4).token_value :=
1029: p_bom_header_rec.common_organization_code;
1030:
1031: Error_Handler.Add_Error_Token
1032: ( p_message_name =>
1033: 'BOM_COMMON_MASTER_ORG_MISMATCH'
1034: , p_token_tbl => l_token_tbl
1035: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1061: Error_Handler.Add_Error_Token

1057: l_token_tbl(3).token_value := p_bom_header_rec.common_organization_code;
1058: l_token_tbl(4).token_name := 'DEST_ORG';
1059: l_token_tbl(4).token_value := p_bom_header_rec.organization_code;
1060:
1061: Error_Handler.Add_Error_Token
1062: ( p_message_name =>
1063: 'BOM_COMMON_OPN_INVALID'
1064: , p_token_tbl => l_token_tbl
1065: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1184: Error_Handler.Add_Error_Token

1180: l_token_tbl(3).token_name := 'COMMON_ORG_CODE';
1181: l_token_tbl(3).token_value :=
1182: p_bom_header_rec.common_organization_code;
1183:
1184: Error_Handler.Add_Error_Token
1185: ( p_message_name => 'BOM_COMMON_COMP_PROP_MISMATCH'
1186: , p_token_tbl => l_token_tbl
1187: , p_mesg_token_tbl => l_mesg_token_tbl
1188: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1210: Error_Handler.Add_Error_Token

1206: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;
1207: l_token_tbl(2).token_name := 'ORG_CODE';
1208: l_token_tbl(2).token_value := p_bom_header_rec.organization_code;
1209:
1210: Error_Handler.Add_Error_Token
1211: ( p_message_name => 'BOM_SRC_COMP_FIXED_REV'
1212: , p_token_tbl => l_token_tbl
1213: , p_mesg_token_tbl => l_mesg_token_tbl
1214: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1309: Error_Handler.Add_Error_Token

1305: l_token_tbl(3).token_name := 'COMMON_ORG_CODE';
1306: l_token_tbl(3).token_value :=
1307: p_bom_header_rec.common_organization_code;
1308:
1309: Error_Handler.Add_Error_Token
1310: ( p_message_name => 'BOM_COMMON_SCOMP_NOTINALLORG'
1311: , p_token_tbl => l_token_tbl
1312: , p_mesg_token_tbl => l_mesg_token_tbl
1313: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1408: Error_Handler.Add_Error_Token

1404: l_token_tbl(2).token_name := 'COMMON_ORG_CODE';
1405: l_token_tbl(2).token_value :=
1406: p_bom_header_rec.common_organization_code;
1407:
1408: Error_Handler.Add_Error_Token
1409: ( p_message_name => 'BOM_SAME_ORG_COMMON_PROP_MIS'
1410: , p_token_tbl => l_token_tbl
1411: , p_mesg_token_tbl => l_mesg_token_tbl
1412: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1469: Error_Handler.Add_Error_Token

1465: l_token_tbl(2).token_name := 'COMMON_ORG_CODE';
1466: l_token_tbl(2).token_value :=
1467: p_bom_header_rec.common_organization_code;
1468:
1469: Error_Handler.Add_Error_Token
1470: ( p_message_name => 'BOM_COMMON_SCOMP_PROP_MIS'
1471: , p_token_tbl => l_token_tbl
1472: , p_mesg_token_tbl => l_mesg_token_tbl
1473: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1528: Error_Handler.Add_Error_Token

1524: p_bom_header_rec.common_organization_code;
1525: l_token_tbl(3).token_name := 'ORG_CODE';
1526: l_token_tbl(3).token_value := p_bom_header_rec.organization_code;
1527:
1528: Error_Handler.Add_Error_Token
1529: ( p_message_name => 'BOM_COMMON_ATOPTO_MISMATCH'
1530: , p_token_tbl => l_token_tbl
1531: , p_mesg_token_tbl => l_mesg_token_tbl
1532: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1546: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1542:
1543:
1544: PROCEDURE Check_Entity_Delete
1545: ( x_return_status IN OUT NOCOPY VARCHAR2
1546: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1547: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
1548: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1549: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1550: )

Line 1552: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

1548: , p_bom_head_Unexp_Rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1549: , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1550: )
1551: IS
1552: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1553: l_bom_head_unexp_rec Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
1554: := p_bom_head_Unexp_Rec;
1555: Cursor CheckGroup is
1556: SELECT description,

Line 1570: Error_Handler.Add_Error_Token

1566:
1567: IF p_bom_header_rec.Delete_Group_Name IS NULL OR
1568: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR
1569: THEN
1570: Error_Handler.Add_Error_Token
1571: ( p_message_name => 'BOM_DG_NAME_MISSING'
1572: , p_mesg_token_tbl => l_mesg_token_tbl
1573: , x_mesg_token_tbl => x_mesg_token_tbl
1574: );

Line 1582: Error_Handler.Add_Error_Token

1578:
1579: For c_CheckGroup in CheckGroup
1580: LOOP
1581: If c_CheckGroup.delete_type <> 2 /* Bill */ then
1582: Error_Handler.Add_Error_Token
1583: ( p_message_name => 'BOM_DUPLICATE_DELETE_GROUP'
1584: , p_mesg_token_tbl=>l_mesg_token_tbl
1585: , x_mesg_token_tbl=>x_mesg_token_tbl
1586: );

Line 1603: Error_Handler.Add_Error_Token

1599: END LOOP;
1600:
1601: IF l_bom_head_unexp_rec.DG_sequence_id IS NULL
1602: THEN
1603: Error_Handler.Add_Error_Token
1604: ( p_message_name => 'NEW_DELETE_GROUP'
1605: , p_message_type => 'W'
1606: , p_mesg_token_tbl => l_mesg_token_tbl
1607: , x_mesg_token_tbl => x_mesg_token_tbl