DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on FND_MESSAGE

Line 680: FND_MESSAGE.Set_Name('INV', l_error_table(i).message_name);

676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
677: THEN
678: FOR i IN 1..l_error_table.COUNT
679: LOOP
680: FND_MESSAGE.Set_Name('INV', l_error_table(i).message_name);
681: FND_MSG_PUB.Add;
682: END loop;
683: FND_MSG_PUB.Count_And_Get(
684: p_count => x_msg_count

Line 1586: Fnd_message.set_name('ENG', 'ENG_PRP_ITM_NOT_EXISTS');

1582: from mtl_system_items_b_kfv
1583: where inventory_item_id = tolc.revised_item_id
1584: and organization_id = p_global_org_id;
1585:
1586: Fnd_message.set_name('ENG', 'ENG_PRP_ITM_NOT_EXISTS');
1587: fnd_message.set_token('ITEM', l_temp_item_name);
1588: l_message_log_text := fnd_message.get();
1589:
1590: l_eco_error_tbl(l_err_counter).Revised_item_sequence_id := p_rev_item_seq_id;

Line 1587: fnd_message.set_token('ITEM', l_temp_item_name);

1583: where inventory_item_id = tolc.revised_item_id
1584: and organization_id = p_global_org_id;
1585:
1586: Fnd_message.set_name('ENG', 'ENG_PRP_ITM_NOT_EXISTS');
1587: fnd_message.set_token('ITEM', l_temp_item_name);
1588: l_message_log_text := fnd_message.get();
1589:
1590: l_eco_error_tbl(l_err_counter).Revised_item_sequence_id := p_rev_item_seq_id;
1591: l_eco_error_tbl(l_err_counter).log_text := l_message_log_text;

Line 1588: l_message_log_text := fnd_message.get();

1584: and organization_id = p_global_org_id;
1585:
1586: Fnd_message.set_name('ENG', 'ENG_PRP_ITM_NOT_EXISTS');
1587: fnd_message.set_token('ITEM', l_temp_item_name);
1588: l_message_log_text := fnd_message.get();
1589:
1590: l_eco_error_tbl(l_err_counter).Revised_item_sequence_id := p_rev_item_seq_id;
1591: l_eco_error_tbl(l_err_counter).log_text := l_message_log_text;
1592: l_eco_error_tbl(l_err_counter).log_type := 'ERROR';

Line 1612: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');

1608: l_structure_exists_flag := 0;
1609: END;
1610: IF (l_structure_exists_flag = 0)
1611: THEN
1612: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1613: l_temp_mesg := fnd_message.get();
1614: Fnd_message.set_name('ENG', 'ENG_PRP_STRC_NOT_EXISTS');
1615: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1616: fnd_message.set_token('LINE', l_temp_mesg);

Line 1613: l_temp_mesg := fnd_message.get();

1609: END;
1610: IF (l_structure_exists_flag = 0)
1611: THEN
1612: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1613: l_temp_mesg := fnd_message.get();
1614: Fnd_message.set_name('ENG', 'ENG_PRP_STRC_NOT_EXISTS');
1615: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1616: fnd_message.set_token('LINE', l_temp_mesg);
1617: l_message_log_text := fnd_message.get();

Line 1614: Fnd_message.set_name('ENG', 'ENG_PRP_STRC_NOT_EXISTS');

1610: IF (l_structure_exists_flag = 0)
1611: THEN
1612: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1613: l_temp_mesg := fnd_message.get();
1614: Fnd_message.set_name('ENG', 'ENG_PRP_STRC_NOT_EXISTS');
1615: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1616: fnd_message.set_token('LINE', l_temp_mesg);
1617: l_message_log_text := fnd_message.get();
1618:

Line 1615: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);

1611: THEN
1612: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1613: l_temp_mesg := fnd_message.get();
1614: Fnd_message.set_name('ENG', 'ENG_PRP_STRC_NOT_EXISTS');
1615: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1616: fnd_message.set_token('LINE', l_temp_mesg);
1617: l_message_log_text := fnd_message.get();
1618:
1619: l_error_logged := 1;

Line 1616: fnd_message.set_token('LINE', l_temp_mesg);

1612: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1613: l_temp_mesg := fnd_message.get();
1614: Fnd_message.set_name('ENG', 'ENG_PRP_STRC_NOT_EXISTS');
1615: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1616: fnd_message.set_token('LINE', l_temp_mesg);
1617: l_message_log_text := fnd_message.get();
1618:
1619: l_error_logged := 1;
1620: l_eco_error_tbl(l_err_counter).Revised_item_sequence_id := p_rev_item_seq_id;

Line 1617: l_message_log_text := fnd_message.get();

1613: l_temp_mesg := fnd_message.get();
1614: Fnd_message.set_name('ENG', 'ENG_PRP_STRC_NOT_EXISTS');
1615: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1616: fnd_message.set_token('LINE', l_temp_mesg);
1617: l_message_log_text := fnd_message.get();
1618:
1619: l_error_logged := 1;
1620: l_eco_error_tbl(l_err_counter).Revised_item_sequence_id := p_rev_item_seq_id;
1621: l_eco_error_tbl(l_err_counter).log_text := l_message_log_text;

Line 1650: Fnd_message.set_name('ENG', 'ENG_PRP_COMN_BOM_BREAK');

1646: , p_from_item_id => tolc.revised_item_id);
1647:
1648: l_comn_bill_sequence_id := l_local_bill_sequence_id;
1649:
1650: Fnd_message.set_name('ENG', 'ENG_PRP_COMN_BOM_BREAK');
1651: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1652: l_message_log_text := fnd_message.get();
1653: l_eco_mesg_tbl(l_mesg_counter).Revised_item_sequence_id := p_rev_item_seq_id;
1654: l_eco_mesg_tbl(l_mesg_counter).log_text := l_message_log_text;

Line 1651: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);

1647:
1648: l_comn_bill_sequence_id := l_local_bill_sequence_id;
1649:
1650: Fnd_message.set_name('ENG', 'ENG_PRP_COMN_BOM_BREAK');
1651: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1652: l_message_log_text := fnd_message.get();
1653: l_eco_mesg_tbl(l_mesg_counter).Revised_item_sequence_id := p_rev_item_seq_id;
1654: l_eco_mesg_tbl(l_mesg_counter).log_text := l_message_log_text;
1655: l_eco_mesg_tbl(l_mesg_counter).log_type := 'INFO';

Line 1652: l_message_log_text := fnd_message.get();

1648: l_comn_bill_sequence_id := l_local_bill_sequence_id;
1649:
1650: Fnd_message.set_name('ENG', 'ENG_PRP_COMN_BOM_BREAK');
1651: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1652: l_message_log_text := fnd_message.get();
1653: l_eco_mesg_tbl(l_mesg_counter).Revised_item_sequence_id := p_rev_item_seq_id;
1654: l_eco_mesg_tbl(l_mesg_counter).log_text := l_message_log_text;
1655: l_eco_mesg_tbl(l_mesg_counter).log_type := 'INFO';
1656: l_mesg_counter := l_mesg_counter + 1;

Line 1663: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');

1659: IF (l_comn_bill_sequence_id <> l_local_bill_sequence_id
1660: AND l_transfer_item_sourced_flag = 2
1661: AND l_eng_bill_flag <> 1)
1662: THEN
1663: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1664: l_temp_mesg := fnd_message.get();
1665: Fnd_message.set_name('ENG', 'ENG_PRP_COMMON_BOM');
1666: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1667: fnd_message.set_token('LINE', l_temp_mesg);

Line 1664: l_temp_mesg := fnd_message.get();

1660: AND l_transfer_item_sourced_flag = 2
1661: AND l_eng_bill_flag <> 1)
1662: THEN
1663: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1664: l_temp_mesg := fnd_message.get();
1665: Fnd_message.set_name('ENG', 'ENG_PRP_COMMON_BOM');
1666: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1667: fnd_message.set_token('LINE', l_temp_mesg);
1668: l_message_log_text := fnd_message.get();

Line 1665: Fnd_message.set_name('ENG', 'ENG_PRP_COMMON_BOM');

1661: AND l_eng_bill_flag <> 1)
1662: THEN
1663: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1664: l_temp_mesg := fnd_message.get();
1665: Fnd_message.set_name('ENG', 'ENG_PRP_COMMON_BOM');
1666: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1667: fnd_message.set_token('LINE', l_temp_mesg);
1668: l_message_log_text := fnd_message.get();
1669:

Line 1666: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);

1662: THEN
1663: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1664: l_temp_mesg := fnd_message.get();
1665: Fnd_message.set_name('ENG', 'ENG_PRP_COMMON_BOM');
1666: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1667: fnd_message.set_token('LINE', l_temp_mesg);
1668: l_message_log_text := fnd_message.get();
1669:
1670: l_error_logged := 1;

Line 1667: fnd_message.set_token('LINE', l_temp_mesg);

1663: Fnd_message.set_name('ENG', 'ENG_ITEM_LC_PHASE_CHG_LINE');
1664: l_temp_mesg := fnd_message.get();
1665: Fnd_message.set_name('ENG', 'ENG_PRP_COMMON_BOM');
1666: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1667: fnd_message.set_token('LINE', l_temp_mesg);
1668: l_message_log_text := fnd_message.get();
1669:
1670: l_error_logged := 1;
1671: l_eco_error_tbl(l_err_counter).Revised_item_sequence_id := p_rev_item_seq_id;

Line 1668: l_message_log_text := fnd_message.get();

1664: l_temp_mesg := fnd_message.get();
1665: Fnd_message.set_name('ENG', 'ENG_PRP_COMMON_BOM');
1666: fnd_message.set_token('STRUCTURE', tolc.alternate_bom_designator);
1667: fnd_message.set_token('LINE', l_temp_mesg);
1668: l_message_log_text := fnd_message.get();
1669:
1670: l_error_logged := 1;
1671: l_eco_error_tbl(l_err_counter).Revised_item_sequence_id := p_rev_item_seq_id;
1672: l_eco_error_tbl(l_err_counter).log_text := l_message_log_text;

Line 1692: Fnd_message.set_name('ENG', 'ENG_STRUCTURE_CHG_LINE');

1688: FOR i IN 1..l_struc_line_tbl.COUNT
1689: LOOP
1690: IF (l_struc_line_tbl(i).local_bill_sequence_id <> l_struc_line_tbl(i).comn_bill_sequence_id)
1691: THEN
1692: Fnd_message.set_name('ENG', 'ENG_STRUCTURE_CHG_LINE');
1693: l_temp_mesg := fnd_message.get();
1694: l_token_tbl.delete;
1695: l_token_tbl(1).token_name := 'STRUCTURE';
1696: l_token_tbl(1).token_value := l_struc_line_tbl(i).alternate_bom_designator;

Line 1693: l_temp_mesg := fnd_message.get();

1689: LOOP
1690: IF (l_struc_line_tbl(i).local_bill_sequence_id <> l_struc_line_tbl(i).comn_bill_sequence_id)
1691: THEN
1692: Fnd_message.set_name('ENG', 'ENG_STRUCTURE_CHG_LINE');
1693: l_temp_mesg := fnd_message.get();
1694: l_token_tbl.delete;
1695: l_token_tbl(1).token_name := 'STRUCTURE';
1696: l_token_tbl(1).token_value := l_struc_line_tbl(i).alternate_bom_designator;
1697: l_token_tbl(2).token_name := 'LINE';

Line 3454: Fnd_message.set_name('ENG', 'ENG_PRP_COMP_NOT_ENABLED');

3450: THEN
3451: l_comp_exists_in_org := G_VAL_FALSE;
3452: ELSE
3453: l_comp_exists_in_org := G_VAL_TRUE;
3454: Fnd_message.set_name('ENG', 'ENG_PRP_COMP_NOT_ENABLED');
3455: fnd_message.set_token('ITEM', l_component_item_name);
3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3457: l_message_log_text := fnd_message.get();
3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');

Line 3455: fnd_message.set_token('ITEM', l_component_item_name);

3451: l_comp_exists_in_org := G_VAL_FALSE;
3452: ELSE
3453: l_comp_exists_in_org := G_VAL_TRUE;
3454: Fnd_message.set_name('ENG', 'ENG_PRP_COMP_NOT_ENABLED');
3455: fnd_message.set_token('ITEM', l_component_item_name);
3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3457: l_message_log_text := fnd_message.get();
3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3459: l_temp_mesg := fnd_message.get();

Line 3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);

3452: ELSE
3453: l_comp_exists_in_org := G_VAL_TRUE;
3454: Fnd_message.set_name('ENG', 'ENG_PRP_COMP_NOT_ENABLED');
3455: fnd_message.set_token('ITEM', l_component_item_name);
3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3457: l_message_log_text := fnd_message.get();
3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3459: l_temp_mesg := fnd_message.get();
3460: Error_Handler.Add_Error_Token(

Line 3457: l_message_log_text := fnd_message.get();

3453: l_comp_exists_in_org := G_VAL_TRUE;
3454: Fnd_message.set_name('ENG', 'ENG_PRP_COMP_NOT_ENABLED');
3455: fnd_message.set_token('ITEM', l_component_item_name);
3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3457: l_message_log_text := fnd_message.get();
3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3459: l_temp_mesg := fnd_message.get();
3460: Error_Handler.Add_Error_Token(
3461: p_Message_Name => NULL

Line 3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');

3454: Fnd_message.set_name('ENG', 'ENG_PRP_COMP_NOT_ENABLED');
3455: fnd_message.set_token('ITEM', l_component_item_name);
3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3457: l_message_log_text := fnd_message.get();
3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3459: l_temp_mesg := fnd_message.get();
3460: Error_Handler.Add_Error_Token(
3461: p_Message_Name => NULL
3462: , p_Message_Text => l_message_log_text || l_temp_mesg

Line 3459: l_temp_mesg := fnd_message.get();

3455: fnd_message.set_token('ITEM', l_component_item_name);
3456: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3457: l_message_log_text := fnd_message.get();
3458: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3459: l_temp_mesg := fnd_message.get();
3460: Error_Handler.Add_Error_Token(
3461: p_Message_Name => NULL
3462: , p_Message_Text => l_message_log_text || l_temp_mesg
3463: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3669: Fnd_message.set_name('ENG', 'ENG_PRP_SUBS_NOT_ENABLED');

3665: l_item_exits_in_org_flag := G_VAL_FALSE;
3666: ELSE
3667: l_item_exits_in_org_flag := G_VAL_TRUE;
3668:
3669: Fnd_message.set_name('ENG', 'ENG_PRP_SUBS_NOT_ENABLED');
3670: fnd_message.set_token('ITEM1', l_substitute_component_name);
3671: fnd_message.set_token('ITEM2', l_component_item_name);
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();

Line 3670: fnd_message.set_token('ITEM1', l_substitute_component_name);

3666: ELSE
3667: l_item_exits_in_org_flag := G_VAL_TRUE;
3668:
3669: Fnd_message.set_name('ENG', 'ENG_PRP_SUBS_NOT_ENABLED');
3670: fnd_message.set_token('ITEM1', l_substitute_component_name);
3671: fnd_message.set_token('ITEM2', l_component_item_name);
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();
3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');

Line 3671: fnd_message.set_token('ITEM2', l_component_item_name);

3667: l_item_exits_in_org_flag := G_VAL_TRUE;
3668:
3669: Fnd_message.set_name('ENG', 'ENG_PRP_SUBS_NOT_ENABLED');
3670: fnd_message.set_token('ITEM1', l_substitute_component_name);
3671: fnd_message.set_token('ITEM2', l_component_item_name);
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();
3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3675: l_temp_mesg := fnd_message.get();

Line 3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);

3668:
3669: Fnd_message.set_name('ENG', 'ENG_PRP_SUBS_NOT_ENABLED');
3670: fnd_message.set_token('ITEM1', l_substitute_component_name);
3671: fnd_message.set_token('ITEM2', l_component_item_name);
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();
3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3675: l_temp_mesg := fnd_message.get();
3676: Error_Handler.Add_Error_Token(

Line 3673: l_message_log_text := fnd_message.get();

3669: Fnd_message.set_name('ENG', 'ENG_PRP_SUBS_NOT_ENABLED');
3670: fnd_message.set_token('ITEM1', l_substitute_component_name);
3671: fnd_message.set_token('ITEM2', l_component_item_name);
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();
3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3675: l_temp_mesg := fnd_message.get();
3676: Error_Handler.Add_Error_Token(
3677: p_Message_Name => NULL

Line 3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');

3670: fnd_message.set_token('ITEM1', l_substitute_component_name);
3671: fnd_message.set_token('ITEM2', l_component_item_name);
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();
3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3675: l_temp_mesg := fnd_message.get();
3676: Error_Handler.Add_Error_Token(
3677: p_Message_Name => NULL
3678: , p_Message_Text => l_message_log_text || l_temp_mesg

Line 3675: l_temp_mesg := fnd_message.get();

3671: fnd_message.set_token('ITEM2', l_component_item_name);
3672: fnd_message.set_token('STRUCTURE', p_revised_item_rec.Alternate_Bom_Code);
3673: l_message_log_text := fnd_message.get();
3674: fnd_message.set_name('ENG', 'ENG_PRP_COMP_ENABLED');
3675: l_temp_mesg := fnd_message.get();
3676: Error_Handler.Add_Error_Token(
3677: p_Message_Name => NULL
3678: , p_Message_Text => l_message_log_text || l_temp_mesg
3679: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl