DBA Data[Home] [Help]

APPS.CSTPUMEC dependencies on FND_MESSAGE

Line 796: -- fnd_message utilities.

792: -- shrinkage_rate/BOR conflicts and defaulted_flag conflicts
793: l_nonzero_shrinkage NUMBER; -- the number of such items
794:
795: -- The next three variables are used to print a warning message with the
796: -- fnd_message utilities.
797: l_orgcode mtl_parameters.organization_code%TYPE := NULL;
798: l_costtype cst_cost_types.cost_type%TYPE := NULL;
799: l_itemname mtl_system_items_kfv.concatenated_segments%TYPE;
800:

Line 987: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_NOTE');

983:
984: if (i_bor_flag = 1 OR i_bor_flag = 3) then
985: -- Based On Rollup may have been updated to YES, print a NOTE message
986: fnd_file.put_line(fnd_file.log,'');
987: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_NOTE');
988: fnd_file.put_line(fnd_file.log, fnd_message.get);
989: end if;
990:
991: if (i_lotsz_lov = 2 OR (i_lotsz_lov = 1 AND i_lot_size IS NOT NULL)) then

Line 988: fnd_file.put_line(fnd_file.log, fnd_message.get);

984: if (i_bor_flag = 1 OR i_bor_flag = 3) then
985: -- Based On Rollup may have been updated to YES, print a NOTE message
986: fnd_file.put_line(fnd_file.log,'');
987: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_NOTE');
988: fnd_file.put_line(fnd_file.log, fnd_message.get);
989: end if;
990:
991: if (i_lotsz_lov = 2 OR (i_lotsz_lov = 1 AND i_lot_size IS NOT NULL)) then
992: -- Update CICD usage rate and basis factor with new lot size information

Line 1088: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_TO_ZERO');

1084:
1085: if (l_nonzero_shrinkage > 0) then
1086: -- print a warning message to the log file and set the request status to WARNING - yellow highlight
1087: fnd_file.put_line(fnd_file.log,'');
1088: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_TO_ZERO');
1089: fnd_message.set_token('NUMBER', to_char(l_nonzero_shrinkage));
1090:
1091: select organization_code
1092: into l_orgcode

Line 1089: fnd_message.set_token('NUMBER', to_char(l_nonzero_shrinkage));

1085: if (l_nonzero_shrinkage > 0) then
1086: -- print a warning message to the log file and set the request status to WARNING - yellow highlight
1087: fnd_file.put_line(fnd_file.log,'');
1088: fnd_message.set_name('BOM', 'CST_SCC_SHRINKAGE_TO_ZERO');
1089: fnd_message.set_token('NUMBER', to_char(l_nonzero_shrinkage));
1090:
1091: select organization_code
1092: into l_orgcode
1093: from mtl_parameters

Line 1095: fnd_message.set_token('ORG', l_orgcode);

1091: select organization_code
1092: into l_orgcode
1093: from mtl_parameters
1094: where organization_id = i_org_id;
1095: fnd_message.set_token('ORG', l_orgcode);
1096:
1097: select cost_type
1098: into l_costtype
1099: from cst_cost_types

Line 1101: fnd_message.set_token('CT', l_costtype);

1097: select cost_type
1098: into l_costtype
1099: from cst_cost_types
1100: where cost_type_id = i_cost_type;
1101: fnd_message.set_token('CT', l_costtype);
1102: fnd_file.put_line(fnd_file.log, fnd_message.get);
1103:
1104: FOR i in 1..l_nonzero_shrinkage LOOP
1105: select concatenated_segments

Line 1102: fnd_file.put_line(fnd_file.log, fnd_message.get);

1098: into l_costtype
1099: from cst_cost_types
1100: where cost_type_id = i_cost_type;
1101: fnd_message.set_token('CT', l_costtype);
1102: fnd_file.put_line(fnd_file.log, fnd_message.get);
1103:
1104: FOR i in 1..l_nonzero_shrinkage LOOP
1105: select concatenated_segments
1106: into l_itemname

Line 1188: fnd_message.set_name('BOM', 'CST_SCC_CANT_UPDT_DEFAULT');

1184:
1185: -- print warning CANNOT UPDATE DEFAULT_FLAG!!!!
1186: if (l_items.COUNT > 0) then
1187: fnd_file.put_line(fnd_file.log,'');
1188: fnd_message.set_name('BOM', 'CST_SCC_CANT_UPDT_DEFAULT');
1189: fnd_message.set_token('NUMBER', to_char(l_items.COUNT));
1190:
1191: if (l_orgcode IS NULL) then
1192: select organization_code

Line 1189: fnd_message.set_token('NUMBER', to_char(l_items.COUNT));

1185: -- print warning CANNOT UPDATE DEFAULT_FLAG!!!!
1186: if (l_items.COUNT > 0) then
1187: fnd_file.put_line(fnd_file.log,'');
1188: fnd_message.set_name('BOM', 'CST_SCC_CANT_UPDT_DEFAULT');
1189: fnd_message.set_token('NUMBER', to_char(l_items.COUNT));
1190:
1191: if (l_orgcode IS NULL) then
1192: select organization_code
1193: into l_orgcode

Line 1197: fnd_message.set_token('ORG', l_orgcode);

1193: into l_orgcode
1194: from mtl_parameters
1195: where organization_id = i_org_id;
1196: end if;
1197: fnd_message.set_token('ORG', l_orgcode);
1198:
1199: if (l_costtype IS NULL) then
1200: select cost_type
1201: into l_costtype

Line 1205: fnd_message.set_token('CT', l_costtype);

1201: into l_costtype
1202: from cst_cost_types
1203: where cost_type_id = i_cost_type;
1204: end if;
1205: fnd_message.set_token('CT', l_costtype);
1206: fnd_file.put_line(fnd_file.log, fnd_message.get);
1207:
1208: FOR i in 1..l_items.COUNT LOOP
1209: select concatenated_segments

Line 1206: fnd_file.put_line(fnd_file.log, fnd_message.get);

1202: from cst_cost_types
1203: where cost_type_id = i_cost_type;
1204: end if;
1205: fnd_message.set_token('CT', l_costtype);
1206: fnd_file.put_line(fnd_file.log, fnd_message.get);
1207:
1208: FOR i in 1..l_items.COUNT LOOP
1209: select concatenated_segments
1210: into l_itemname