DBA Data[Home] [Help]

APPS.ENG_SUB_COMPONENT_UTIL dependencies on ERROR_HANDLER

Line 161: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

157:
158: PROCEDURE Update_Row
159: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
160: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
161: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
162: , x_return_status OUT NOCOPY VARCHAR2
163: )
164: IS
165: l_processed BOOLEAN;

Line 170: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

166: l_sub_component_rec Bom_Bo_Pub.SUB_COMPONENT_REC_TYPE :=
167: p_sub_component_rec;
168: l_return_status VARCHAR2(200);
169: l_err_text VARCHAR2(255);
170: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
171: BEGIN
172:
173: -- Lock the row before updating the row
174: dbms_output.put_line('Within Update Row . . .');

Line 219: Error_Handler.Add_Error_Token

215:
216: WHEN NO_DATA_FOUND THEN
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: Error_Handler.Add_Error_Token
220: ( p_Message_name => 'ENG_NOT_UPDATE_ROW'
221: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
222: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
223: );

Line 238: Error_Handler.Add_Error_Token

234: 'Utility (SubStitute Component Update)' ||
235: SUBSTR(SQLERRM, 1, 100);
236: dbms_output.put_line('Update Row Unexpected Error: ' || l_err_text);
237:
238: Error_Handler.Add_Error_Token
239: ( p_Message_Name => NULL
240: , p_Message_Text => l_err_text
241: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
242: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 265: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

261: ********************************************************************/
262: PROCEDURE Insert_Row
263: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
264: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
265: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
266: , x_return_status OUT NOCOPY VARCHAR2
267: )
268: IS
269: l_processed BOOLEAN;

Line 272: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

268: IS
269: l_processed BOOLEAN;
270: l_err_text VARCHAR2(255);
271: l_return_status VARCHAR2(200);
272: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
273: BEGIN
274:
275:
276: INSERT INTO BOM_SUBSTITUTE_COMPONENTS

Line 353: Error_Handler.Add_Error_Token

349: THEN
350: l_err_text := G_PKG_NAME ||
351: 'Utility (Substitute Component Insert)' ||
352: SUBSTR(SQLERRM, 1, 100);
353: Error_Handler.Add_Error_Token
354: ( p_Message_Name => NULL
355: , p_Message_text => l_err_text
356: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
357: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 380: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

376: ( p_substitute_component_id IN NUMBER
377: , p_change_notice IN VARCHAR2
378: , p_component_sequence_id IN NUMBER
379: , p_acd_type IN NUMBER
380: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
381: , x_return_status OUT NOCOPY VARCHAR2
382: )
383: IS
384: l_processed BOOLEAN;

Line 387: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

383: IS
384: l_processed BOOLEAN;
385: l_return_status VARCHAR2(200);
386: l_err_text VARCHAR2(255);
387: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
388: BEGIN
389:
390: Bom_GLOBALS.Check_Approved_For_Process(p_change_notice,
391: Bom_GLOBALS.Get_org_id,

Line 419: Error_Handler.Add_Error_Token

415: l_err_text := G_PKG_NAME ||
416: 'Utility (Substitute Component Delete_Row)' ||
417: SUBSTR(SQLERRM, 1, 100);
418:
419: Error_Handler.Add_Error_Token
420: ( p_Message_Name => NULL
421: , p_Message_Text => l_err_text
422: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
423: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 456: l_Token_Tbl Error_Handler.Token_Tbl_Type;

452: , x_return_status OUT NOCOPY VARCHAR2
453: )
454: IS
455: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
456: l_Token_Tbl Error_Handler.Token_Tbl_Type;
457: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
458: BEGIN
459:
460: SELECT SUBSTITUTE_ITEM_QUANTITY

Line 457: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

453: )
454: IS
455: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
456: l_Token_Tbl Error_Handler.Token_Tbl_Type;
457: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
458: BEGIN
459:
460: SELECT SUBSTITUTE_ITEM_QUANTITY
461: , ATTRIBUTE_CATEGORY

Line 540: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

536:
537: PROCEDURE Perform_Writes
538: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
539: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
540: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
541: , x_Return_Status OUT NOCOPY VARCHAR2
542: )
543: IS
544: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 544: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

540: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
541: , x_Return_Status OUT NOCOPY VARCHAR2
542: )
543: IS
544: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
545: l_return_status VARCHAR2(1);
546: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
547: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
548: BEGIN