DBA Data[Home] [Help]

APPS.FLM_KANBAN_PLANNING_UTIL dependencies on FND_MESSAGE

Line 959: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

955: and kanban_plan_id = -1;
956: exception
957: when others then
958: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
959: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
960: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pull_Sequence_Id');
961: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
962: l_error_count := l_error_count+1;
963: end;

Line 960: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pull_Sequence_Id');

956: exception
957: when others then
958: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
959: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
960: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pull_Sequence_Id');
961: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
962: l_error_count := l_error_count+1;
963: end;
964: else

Line 961: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

957: when others then
958: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
959: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
960: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pull_Sequence_Id');
961: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
962: l_error_count := l_error_count+1;
963: end;
964: else
965: if l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is null and

Line 968: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

964: else
965: if l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is null and
966: l_flm_kanban_demand_intf(l_counter).ITEM_SEGMENTS is null then
967: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
968: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
970: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
971: l_error_count := l_error_count+1;
972: elsif l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is null and

Line 969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');

965: if l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is null and
966: l_flm_kanban_demand_intf(l_counter).ITEM_SEGMENTS is null then
967: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
968: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
970: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
971: l_error_count := l_error_count+1;
972: elsif l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is null and
973: l_flm_kanban_demand_intf(l_counter).ITEM_SEGMENTS is not null then

Line 970: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

966: l_flm_kanban_demand_intf(l_counter).ITEM_SEGMENTS is null then
967: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
968: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
970: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
971: l_error_count := l_error_count+1;
972: elsif l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is null and
973: l_flm_kanban_demand_intf(l_counter).ITEM_SEGMENTS is not null then
974: l_flm_kanban_demand_intf(l_counter).inventory_item_id := get_item_id (l_flm_kanban_demand_intf(l_counter).organization_id,

Line 978: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

974: l_flm_kanban_demand_intf(l_counter).inventory_item_id := get_item_id (l_flm_kanban_demand_intf(l_counter).organization_id,
975: l_flm_kanban_demand_intf(l_counter).ITEM_SEGMENTS);
976: if l_flm_kanban_demand_intf(l_counter).inventory_item_id is null then
977: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
978: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
980: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
981: l_error_count := l_error_count+1;
982: end if;

Line 979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');

975: l_flm_kanban_demand_intf(l_counter).ITEM_SEGMENTS);
976: if l_flm_kanban_demand_intf(l_counter).inventory_item_id is null then
977: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
978: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
980: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
981: l_error_count := l_error_count+1;
982: end if;
983: elsif l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is not null then

Line 980: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

976: if l_flm_kanban_demand_intf(l_counter).inventory_item_id is null then
977: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
978: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
980: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
981: l_error_count := l_error_count+1;
982: end if;
983: elsif l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID is not null then
984: begin

Line 992: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

988: and inventory_item_id = l_flm_kanban_demand_intf(l_counter).INVENTORY_ITEM_ID;
989: exception
990: when others then
991: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
992: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
994: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
995: l_error_count := l_error_count+1;
996: end;

Line 993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');

989: exception
990: when others then
991: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
992: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
994: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
995: l_error_count := l_error_count+1;
996: end;
997: end if;

Line 994: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

990: when others then
991: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
992: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item');
994: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
995: l_error_count := l_error_count+1;
996: end;
997: end if;
998:

Line 1001: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

997: end if;
998:
999: if l_flm_kanban_demand_intf(l_counter).subinventory is null then
1000: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1001: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');
1003: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1004: l_error_count := l_error_count+1;
1005: else

Line 1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');

998:
999: if l_flm_kanban_demand_intf(l_counter).subinventory is null then
1000: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1001: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');
1003: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1004: l_error_count := l_error_count+1;
1005: else
1006: begin

Line 1003: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

999: if l_flm_kanban_demand_intf(l_counter).subinventory is null then
1000: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1001: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');
1003: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1004: l_error_count := l_error_count+1;
1005: else
1006: begin
1007: select 1 into l_temp

Line 1014: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

1010: AND organization_id = l_flm_kanban_demand_intf(l_counter).organization_id;
1011: exception
1012: when others then
1013: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1014: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');
1016: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1017: l_error_count := l_error_count+1;
1018: end;

Line 1015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');

1011: exception
1012: when others then
1013: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1014: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');
1016: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1017: l_error_count := l_error_count+1;
1018: end;
1019: end if;

Line 1016: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1012: when others then
1013: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1014: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Subinventory');
1016: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1017: l_error_count := l_error_count+1;
1018: end;
1019: end if;
1020: if l_flm_kanban_demand_intf(l_counter).locator_id is null and

Line 1026: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

1022: l_flm_kanban_demand_intf(l_counter).locator_id := get_locator_id(l_flm_kanban_demand_intf(l_counter).organization_id,
1023: l_flm_kanban_demand_intf(l_counter).LOCATOR_SEGMENTS);
1024: if l_flm_kanban_demand_intf(l_counter).locator_id is null then
1025: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1026: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');
1028: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1029: l_error_count := l_error_count+1;
1030: end if;

Line 1027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');

1023: l_flm_kanban_demand_intf(l_counter).LOCATOR_SEGMENTS);
1024: if l_flm_kanban_demand_intf(l_counter).locator_id is null then
1025: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1026: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');
1028: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1029: l_error_count := l_error_count+1;
1030: end if;
1031: elsif l_flm_kanban_demand_intf(l_counter).locator_id is not null then

Line 1028: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1024: if l_flm_kanban_demand_intf(l_counter).locator_id is null then
1025: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1026: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');
1028: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1029: l_error_count := l_error_count+1;
1030: end if;
1031: elsif l_flm_kanban_demand_intf(l_counter).locator_id is not null then
1032: begin

Line 1040: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

1036: AND organization_id = l_flm_kanban_demand_intf(l_counter).organization_id;
1037: exception
1038: when others then
1039: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1040: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');
1042: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1043: l_error_count := l_error_count+1;
1044: end;

Line 1041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');

1037: exception
1038: when others then
1039: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1040: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');
1042: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1043: l_error_count := l_error_count+1;
1044: end;
1045: end if;

Line 1042: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1038: when others then
1039: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1040: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Locator');
1042: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1043: l_error_count := l_error_count+1;
1044: end;
1045: end if;
1046: begin

Line 1057: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

1053: and kanban_plan_id = -1;
1054: exception
1055: when others then
1056: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1057: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item/Subinventory/Locator');
1059: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1060: l_error_count := l_error_count+1;
1061: end;

Line 1058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item/Subinventory/Locator');

1054: exception
1055: when others then
1056: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1057: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item/Subinventory/Locator');
1059: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1060: l_error_count := l_error_count+1;
1061: end;
1062: end if;

Line 1059: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1055: when others then
1056: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1057: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Item/Subinventory/Locator');
1059: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1060: l_error_count := l_error_count+1;
1061: end;
1062: end if;
1063: if l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is null and

Line 1066: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

1062: end if;
1063: if l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is null and
1064: l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is null then
1065: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1066: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand');
1068: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1069: l_error_count := l_error_count+1;
1070: elsif l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is not null then

Line 1067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand');

1063: if l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is null and
1064: l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is null then
1065: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1066: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand');
1068: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1069: l_error_count := l_error_count+1;
1070: elsif l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is not null then
1071: if l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is not null then

Line 1068: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1064: l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is null then
1065: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1066: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand');
1068: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1069: l_error_count := l_error_count+1;
1070: elsif l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is not null then
1071: if l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is not null then
1072: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;

Line 1073: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');

1069: l_error_count := l_error_count+1;
1070: elsif l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is not null then
1071: if l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is not null then
1072: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1073: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Average Demand');
1075: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1076: end if;
1077: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is not null then

Line 1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Average Demand');

1070: elsif l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY is not null then
1071: if l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is not null then
1072: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1073: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Average Demand');
1075: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1076: end if;
1077: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is not null then
1078: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;

Line 1075: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1071: if l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is not null then
1072: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1073: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Average Demand');
1075: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1076: end if;
1077: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is not null then
1078: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1079: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');

Line 1079: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');

1075: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1076: end if;
1077: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is not null then
1078: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1079: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1080: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date');
1081: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1082: end if;
1083: if l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is not null then

Line 1080: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date');

1076: end if;
1077: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is not null then
1078: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1079: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1080: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date');
1081: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1082: end if;
1083: if l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is not null then
1084: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;

Line 1081: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1077: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is not null then
1078: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1079: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1080: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date');
1081: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1082: end if;
1083: if l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is not null then
1084: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1085: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');

Line 1085: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');

1081: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1082: end if;
1083: if l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is not null then
1084: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1085: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand End Date');
1087: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1088: end if;
1089: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is null then

Line 1086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand End Date');

1082: end if;
1083: if l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is not null then
1084: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1085: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand End Date');
1087: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1088: end if;
1089: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is null then
1090: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;

Line 1087: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1083: if l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is not null then
1084: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1085: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_DEM_QTY');
1086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand End Date');
1087: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1088: end if;
1089: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is null then
1090: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1091: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

Line 1091: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

1087: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1088: end if;
1089: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is null then
1090: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1091: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');
1093: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1094: l_error_count := l_error_count+1;
1095: end if;

Line 1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');

1088: end if;
1089: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is null then
1090: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1091: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');
1093: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1094: l_error_count := l_error_count+1;
1095: end if;
1096: l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE := l_flm_kanban_demand_intf(l_counter).DEMAND_DATE;

Line 1093: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1089: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is null then
1090: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1091: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');
1093: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1094: l_error_count := l_error_count+1;
1095: end if;
1096: l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE := l_flm_kanban_demand_intf(l_counter).DEMAND_DATE;
1097: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE := l_flm_kanban_demand_intf(l_counter).DEMAND_DATE;

Line 1102: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_AVG_DEMAND');

1098: l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND := l_flm_kanban_demand_intf(l_counter).DEMAND_QUANTITY;
1099: elsif l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is not null then
1100: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is not null then
1101: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1102: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_AVG_DEMAND');
1103: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');
1104: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1105: end if;
1106: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is null or

Line 1103: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');

1099: elsif l_flm_kanban_demand_intf(l_counter).AVERAGE_DEMAND is not null then
1100: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is not null then
1101: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1102: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_AVG_DEMAND');
1103: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');
1104: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1105: end if;
1106: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is null or
1107: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is null or

Line 1104: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1100: if l_flm_kanban_demand_intf(l_counter).DEMAND_DATE is not null then
1101: l_flm_kanban_demand_intf(l_counter).process_status := WARNING;
1102: FND_MESSAGE.SET_NAME('FLM','FLM_IGNORE_ATTR_AVG_DEMAND');
1103: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Date');
1104: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1105: end if;
1106: if l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE is null or
1107: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is null or
1108: l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE >

Line 1111: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

1107: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE is null or
1108: l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE >
1109: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE then
1110: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1111: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date/Demand End Date');
1113: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1114: l_error_count := l_error_count+1;
1115: end if;

Line 1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date/Demand End Date');

1108: l_flm_kanban_demand_intf(l_counter).DEMAND_START_DATE >
1109: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE then
1110: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1111: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date/Demand End Date');
1113: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1114: l_error_count := l_error_count+1;
1115: end if;
1116: end if;

Line 1113: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;

1109: l_flm_kanban_demand_intf(l_counter).DEMAND_END_DATE then
1110: l_flm_kanban_demand_intf(l_counter).process_status := ERROR;
1111: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Demand Start Date/Demand End Date');
1113: l_flm_kanban_demand_intf(l_counter).error := l_flm_kanban_demand_intf(l_counter).error||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1114: l_error_count := l_error_count+1;
1115: end if;
1116: end if;
1117: