APPS.BOM_PFI_PVT dependencies on APP_EXCEPTION

Line 108: APP_EXCEPTION.RAISE_EXCEPTION;

104: p_return_sts := 2 ;
105: l_return_err := 'BOM_PFI_PVT.Create_PF_Category: ' || l_return_err ;
106: FND_MESSAGE.set_name('BOM', 'BOM_PFI_PVT_MSG');
107: FND_MESSAGE.set_token('MSG', l_return_err);
108: APP_EXCEPTION.RAISE_EXCEPTION;
109: END IF;
110:
111: -- Proceed with insert if category does not exist (l_return_sts = 3)
112:

Line 239: APP_EXCEPTION.RAISE_EXCEPTION;

235:
236: WHEN OTHERS THEN
237: p_Cat_Create_Num := 0 ;
238: IF ( SQLCODE = -20001 ) THEN
239: APP_EXCEPTION.RAISE_EXCEPTION;
240: ELSE
241: p_return_sts := 4 ;
242: l_return_err := 'BOM_PFI_PVT.Create_PF_Category: ' || SQLERRM ;
243: raise_application_error (-20000, l_return_err);

Line 443: APP_EXCEPTION.RAISE_EXCEPTION;

439: IF ( l_return_sts = 3 ) THEN
440: p_return_sts := 3 ;
441: FND_MESSAGE.set_name('BOM', 'BOM_PFI_PVT_CAT_ASSIGN');
442: FND_MESSAGE.set_token('CAT', l_concat_segments);
443: APP_EXCEPTION.RAISE_EXCEPTION;
444: ELSIF ( l_return_sts <> 0 ) THEN
445: p_return_sts := 2 ;
446: l_return_err := 'Assign_To_Category: ' || l_return_err ;
447: FND_MESSAGE.set_name('BOM', 'BOM_PFI_PVT_MSG');

Line 449: APP_EXCEPTION.RAISE_EXCEPTION;

445: p_return_sts := 2 ;
446: l_return_err := 'Assign_To_Category: ' || l_return_err ;
447: FND_MESSAGE.set_name('BOM', 'BOM_PFI_PVT_MSG');
448: FND_MESSAGE.set_token('MSG', l_return_err);
449: APP_EXCEPTION.RAISE_EXCEPTION;
450: END IF;
451:
452: l_stmt_num := 3 ;
453:

Line 496: APP_EXCEPTION.RAISE_EXCEPTION;

492: EXCEPTION
493: WHEN OTHERS THEN
494: p_Assign_Num := 0 ;
495: IF ( SQLCODE = -20001 ) THEN
496: APP_EXCEPTION.RAISE_EXCEPTION;
497: ELSE
498: p_return_sts := 4 ;
499: l_return_err := 'BOM_PFI_PVT.Assign_To_Category: ' || SQLERRM ;
500: raise_application_error (-20000, l_return_err);

Line 635: APP_EXCEPTION.RAISE_EXCEPTION;

631: l_return_err := to_char( p_org_id );
632: FND_MESSAGE.set_name('BOM', 'BOM_PFI_PVT_NOTFOUND');
633: FND_MESSAGE.set_token('PROC', 'Get_Master_Org_ID');
634: FND_MESSAGE.set_token('ENTITY', 'ORG_ID ' || l_return_err);
635: APP_EXCEPTION.RAISE_EXCEPTION;
636:
637: WHEN OTHERS THEN
638: l_return_err := 'Get_Master_Org_ID:' || SQLERRM ;
639: raise_application_error (-20000, l_return_err);

Line 729: APP_EXCEPTION.RAISE_EXCEPTION;

725: IF ( BOM_PFI_PVT.PF_Segs_Status = BOM_PFI_PVT.G_PF_Segs_Status_Mismatch )
726: THEN
727: BOM_PFI_PVT.PF_Segs_Status := BOM_PFI_PVT.G_PF_Segs_Status_OK;
728: FND_MESSAGE.set_name('INV', 'INV_BOM_PFI_SEGS_MISMATCH');
729: APP_EXCEPTION.RAISE_EXCEPTION;
730: END IF;
731:
732: END Check_PF_Segs;
733: