DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_HEADER dependencies on FND_MSG_PUB

Line 1661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1657: -- having references to the primary routing of the assembly
1658: -- which may become invalid once an alternate is created
1659:
1660: FOR rec1 IN c_Check_BOM LOOP
1661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1662: THEN
1663: Error_Handler.Add_Error_Token
1664: (p_message_name => 'BOM_ALT_RTG_REF_BOM'
1665: , p_token_tbl => l_token_tbl

Line 2015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2011: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME' ;
2012: l_token_tbl(1).token_value :=
2013: p_rtg_header_rec.assembly_item_name;
2014:
2015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2016: THEN
2017:
2018: Error_Handler.Add_Error_Token
2019: ( p_message_name =>

Line 2314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2310: THEN
2311:
2312:
2313: IF l_locator_control = 4 THEN
2314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2315: THEN
2316: l_token_tbl(1).token_name :='ASSEMBLY_ITEM_NAME';
2317: l_token_tbl(1).token_value :=
2318: p_rtg_header_rec.assembly_item_name;

Line 2329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2325: END IF;
2326:
2327: ELSIF l_locator_control = 3 THEN
2328: -- Log the Dynamic locator control message.
2329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2330: THEN
2331: l_token_tbl(1).token_name :='ASSEMBLY_ITEM_NAME';
2332: l_token_tbl(1).token_value :=
2333: p_rtg_header_rec.assembly_item_name;

Line 2346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2342: ELSIF l_locator_control = 2 THEN
2343: IF l_item_loc_restricted = 1 THEN
2344: -- if error occured when item_locator_control was
2345: -- restrcited
2346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2347: THEN
2348: l_token_tbl(1).token_name :='ASSEMBLY_ITEM_NAME';
2349: l_token_tbl(1).token_value :=
2350: p_rtg_header_rec.assembly_item_name;

Line 2366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2362: , p_Token_Tbl => g_Token_Tbl
2363: );
2364: END IF;
2365: ELSE
2366: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2367: THEN
2368: l_token_tbl(1).token_name :='ASSEMBLY_ITEM_NAME';
2369: l_token_tbl(1).token_value :=
2370: p_rtg_header_rec.assembly_item_name;

Line 2381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2377: END IF;
2378: END IF ;
2379:
2380: ELSIF l_locator_control = 1 THEN
2381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2382: THEN
2383: Error_Handler.Add_Error_Token
2384: ( p_message_name =>
2385: 'BOM_RTG_ITEM_NO_LOC_CONTROL'

Line 2400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2396:
2397: IF p_rtg_header_rec.transaction_type IN (BOM_Rtg_Globals.G_OPR_UPDATE) AND -- Added for SSOS (bug 2689249)
2398: p_rtg_header_rec.ser_start_op_seq IS NOT NULL AND
2399: l_bom_item_type IN (1,2) THEN -- If the item is a model/option class item routing
2400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2401: THEN
2402: Error_Handler.Add_Error_Token
2403: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
2404: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2433: IF FND_MSG_PUB.Check_Msg_Level

2429:
2430: IF Bom_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error in routing header Entity Validation . . .'); END IF;
2431:
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: IF FND_MSG_PUB.Check_Msg_Level
2434: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2435: THEN
2436: l_err_text := G_PKG_NAME ||
2437: ' : (Entity Validation) ' ||

Line 2434: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2430: IF Bom_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Unexpected Error in routing header Entity Validation . . .'); END IF;
2431:
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: IF FND_MSG_PUB.Check_Msg_Level
2434: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2435: THEN
2436: l_err_text := G_PKG_NAME ||
2437: ' : (Entity Validation) ' ||
2438: substrb(SQLERRM,1,200);

Line 2450: IF FND_MSG_PUB.Check_Msg_Level

2446:
2447: WHEN OTHERS THEN
2448: IF Bom_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(SQLERRM || ' ' || TO_CHAR(SQLCODE)); END IF;
2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2450: IF FND_MSG_PUB.Check_Msg_Level
2451: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2452: THEN
2453: l_err_text := G_PKG_NAME ||
2454: ' : (Entity Validation) ' ||

Line 2451: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2447: WHEN OTHERS THEN
2448: IF Bom_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug(SQLERRM || ' ' || TO_CHAR(SQLCODE)); END IF;
2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2450: IF FND_MSG_PUB.Check_Msg_Level
2451: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2452: THEN
2453: l_err_text := G_PKG_NAME ||
2454: ' : (Entity Validation) ' ||
2455: substrb(SQLERRM,1,200);

Line 2593: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2589: ;
2590:
2591: BEGIN
2592: FOR check_ssos_rec in check_ssos_cur LOOP
2593: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2594: THEN
2595: Error_Handler.Add_Error_Token
2596: ( p_message_name => 'BOM_SSOS_INVALID'
2597: , p_mesg_token_tbl => x_mesg_token_tbl

Line 2696: IF ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) )

2692:
2693: -- SSOS is required for standard/network routing of serial controlled item.
2694: IF ( ( l_ser_start_op_seq IS NULL ) OR ( l_ser_start_op_seq = FND_API.G_MISS_NUM ) ) THEN
2695:
2696: IF ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) )
2697: THEN
2698: Error_Handler.Add_Error_Token
2699: ( p_message_name => 'WSM_NTWK_SERIAL_START_OP'
2700: , p_mesg_token_tbl => x_mesg_token_tbl

Line 2718: IF ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) )

2714: x_err_msg => l_errmsg
2715: );
2716:
2717: IF (l_retval = 0) THEN
2718: IF ( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) )
2719: THEN
2720: Error_Handler.Add_Error_Token
2721: ( p_message_name => 'WSM_NTWK_SERIAL_START_OP'
2722: , p_mesg_token_tbl => x_mesg_token_tbl