APPS.ENG_VALIDATE_SUB_COMPONENT dependencies on FND_MSG_PUB

Line 150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

146: IF l_rec_bit IN (1, 2, 3)
147: THEN
148: l_err_text := 'ENG_SBC_NON_STD_PARENT';
149: l_return_status := FND_API.G_RET_STS_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: --dbms_output.put_line
152: -- ('Expected Error. non-standard component . . . ');
153:
154: Error_Handler.Add_Error_Token

Line 167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

163: IF l_parent_bit = 3 THEN
164: l_Err_text := 'ENG_SBC_PLANNING_BILL';
165: l_return_status := FND_API.G_RET_STS_ERROR;
166:
167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
168: --dbms_output.put_line
169: -- ('Expected Error. planning parent. . . ');
170:
171: Error_Handler.Add_Error_Token

Line 243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

239: WHERE organization_id = p_Sub_Comp_Unexp_Rec.Organization_Id
240: AND inventory_item_id = p_Sub_Comp_Unexp_Rec.substitute_component_id;
241:
242: IF l_sbc_item_type <> 4 THEN
243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
244: Error_Handler.Add_Error_Token
245: ( x_Mesg_Token_tbl => l_Mesg_Token_Tbl
246: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
247: , p_message_name => 'ENG_SUB_COMP_NOT_STD'

Line 255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

251: END IF;
252:
253: IF l_sbc_bom_enabled_flag <> 'Y'
254: THEN
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
256: l_token_tbl(1).token_name := 'SUBSTITUTE_ITEM_NAME';
257: l_token_tbl(1).token_value :=
258: p_sub_component_rec.substitute_component_name;
259: Error_Handler.Add_Error_Token

Line 271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

267: END IF;
268:
269: IF ((l_rec_AST = 2) OR (l_rec_AST = 1 AND l_sbc_eng_item_flag = 'Y'))
270: THEN
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
272: Error_Handler.Add_Error_Token
273: ( x_Mesg_Token_tbl => l_Mesg_Token_Tbl
274: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
275: , p_message_name => 'ENG_SUB_COMP_ASSEMBLY_MFG'

Line 311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

307: AND msi.bom_item_type = 4
308: AND (bbom.assembly_type = 2 OR
309: (bbom.assembly_type = 1 AND msi.eng_item_flag = 'N')));
310:
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
312: l_token_tbl.DELETE;
313: l_Token_tbl(1).token_name := 'SUBSTITUTE_ITEM_NAME';
314: l_token_tbl(1).token_value :=
315: p_sub_component_rec.substitute_component_name;

Line 343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

339: (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_CREATE AND
340: p_Sub_Comp_Unexp_Rec.Substitute_Component_Id IN
341: (l_rec_AII,l_rec_CII))
342: THEN
343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
344: Error_Handler.Add_Error_Token
345: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
346: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
347: , p_message_name => 'ENG_SUBCOMP_SAMEAS_ITEM_COMP'

Line 369: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

365: -----------------------------------------------------------------------
366: stmt_num := 11;
367: IF l_parent_acd_type = 3 THEN
368: l_return_status := FND_API.G_RET_STS_ERROR;
369: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
370: Error_Handler.Add_Error_Token
371: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
372: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
373: , p_message_name => 'ENG_SBC_COMP_ACD_TYPE_DISABLE'

Line 439: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) Then

435: p_Sub_Comp_Unexp_Rec.Component_Sequence_Id
436: AND rev_comp.implementation_date IS NOT NULL;
437: EXCEPTION
438: WHEN NO_DATA_FOUND THEN
439: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) Then
440: l_token_tbl(1).token_name := 'SUBSTITUTE_ITEM_NAME';
441: l_token_tbl(1).token_value :=
442: p_sub_component_rec.substitute_component_name;
443: l_token_tbl(2).token_name := 'REVISED_COMPONENT_NAME';

Line 486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

482: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: --dbms_output.put_line('other unexpected Error :
485: -- stmt_num -' || to_char(stmt_num));
486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: l_err_text := G_PKG_NAME ||
489: 'Validation (Substitute Component Entity)' ||
490: SUBSTR(SQLERRM, 1, 100);

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

527:
528: IF p_sub_component_rec.substitute_item_quantity IS NOT NULL AND
529: p_sub_component_rec.substitute_item_quantity = 0
530: THEN
531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
532: THEN
533: l_token_tbl(1).token_name := 'SUBSITUTE_ITEM_NAME';
534: l_token_tbl(1).token_value :=
535: p_sub_component_rec.substitute_component_name;