DBA Data[Home] [Help]

APPS.EAM_MATERIALISSUE_PVT dependencies on FND_MESSAGE

Line 176: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');

172: --fix for 3454251.raise an error message if quantity to be issued is negative or zero
173:
174: if(p_requested_quantity<=0) then
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
177: fnd_message.set_token('OPERATION',p_operation_seq_num);
178: fnd_message.set_token('MATERIAL',l_material);
179: fnd_msg_pub.add;
180: fnd_msg_pub.Count_And_Get(

Line 177: fnd_message.set_token('OPERATION',p_operation_seq_num);

173:
174: if(p_requested_quantity<=0) then
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
177: fnd_message.set_token('OPERATION',p_operation_seq_num);
178: fnd_message.set_token('MATERIAL',l_material);
179: fnd_msg_pub.add;
180: fnd_msg_pub.Count_And_Get(
181: p_count => x_msg_count,

Line 178: fnd_message.set_token('MATERIAL',l_material);

174: if(p_requested_quantity<=0) then
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
177: fnd_message.set_token('OPERATION',p_operation_seq_num);
178: fnd_message.set_token('MATERIAL',l_material);
179: fnd_msg_pub.add;
180: fnd_msg_pub.Count_And_Get(
181: p_count => x_msg_count,
182: p_data => x_msg_data);

Line 188: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');

184: end if;
185: --if the transaction date is in future raise an error message
186: if(p_date > sysdate) then
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
189: fnd_message.set_token('OPERATION',p_operation_seq_num);
190: fnd_message.set_token('MATERIAL',l_material);
191: fnd_msg_pub.add;
192: fnd_msg_pub.Count_And_Get(

Line 189: fnd_message.set_token('OPERATION',p_operation_seq_num);

185: --if the transaction date is in future raise an error message
186: if(p_date > sysdate) then
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
189: fnd_message.set_token('OPERATION',p_operation_seq_num);
190: fnd_message.set_token('MATERIAL',l_material);
191: fnd_msg_pub.add;
192: fnd_msg_pub.Count_And_Get(
193: p_count => x_msg_count,

Line 190: fnd_message.set_token('MATERIAL',l_material);

186: if(p_date > sysdate) then
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
189: fnd_message.set_token('OPERATION',p_operation_seq_num);
190: fnd_message.set_token('MATERIAL',l_material);
191: fnd_msg_pub.add;
192: fnd_msg_pub.Count_And_Get(
193: p_count => x_msg_count,
194: p_data => x_msg_data);

Line 209: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');

205: l_num_range_serials := inv_serial_number_pub.get_serial_diff(
206: l_fm_serial_number, l_to_serial_number);
207: if (l_num_range_serials <> p_requested_quantity) then
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
210: fnd_message.set_token('OPERATION',p_operation_seq_num);
211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);

Line 210: fnd_message.set_token('OPERATION',p_operation_seq_num);

206: l_fm_serial_number, l_to_serial_number);
207: if (l_num_range_serials <> p_requested_quantity) then
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
210: fnd_message.set_token('OPERATION',p_operation_seq_num);
211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);

Line 211: fnd_message.set_token('MATERIAL',l_material);

207: if (l_num_range_serials <> p_requested_quantity) then
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
210: fnd_message.set_token('OPERATION',p_operation_seq_num);
211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);

Line 212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);

208: x_return_status := FND_API.G_RET_STS_ERROR;
209: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
210: fnd_message.set_token('OPERATION',p_operation_seq_num);
211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
216: fnd_msg_pub.add;

Line 213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);

209: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
210: fnd_message.set_token('OPERATION',p_operation_seq_num);
211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
216: fnd_msg_pub.add;
217: fnd_msg_pub.Count_And_Get(

Line 214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);

210: fnd_message.set_token('OPERATION',p_operation_seq_num);
211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
216: fnd_msg_pub.add;
217: fnd_msg_pub.Count_And_Get(
218: p_count => x_msg_count,

Line 215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);

211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
213: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
214: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
215: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
216: fnd_msg_pub.add;
217: fnd_msg_pub.Count_And_Get(
218: p_count => x_msg_count,
219: p_data => x_msg_data);

Line 240: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');

236: AND LENGTH(msn.serial_number) = LENGTH(l_fm_serial_number);
237:
238: if (l_num_valid_serials <> p_requested_quantity) then
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
241: fnd_message.set_token('OPERATION',p_operation_seq_num);
242: fnd_message.set_token('MATERIAL',l_material);
243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
244: fnd_msg_pub.add;

Line 241: fnd_message.set_token('OPERATION',p_operation_seq_num);

237:
238: if (l_num_valid_serials <> p_requested_quantity) then
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
241: fnd_message.set_token('OPERATION',p_operation_seq_num);
242: fnd_message.set_token('MATERIAL',l_material);
243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
244: fnd_msg_pub.add;
245: fnd_msg_pub.Count_And_Get(

Line 242: fnd_message.set_token('MATERIAL',l_material);

238: if (l_num_valid_serials <> p_requested_quantity) then
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
241: fnd_message.set_token('OPERATION',p_operation_seq_num);
242: fnd_message.set_token('MATERIAL',l_material);
243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
244: fnd_msg_pub.add;
245: fnd_msg_pub.Count_And_Get(
246: p_count => x_msg_count,

Line 243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);

239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
241: fnd_message.set_token('OPERATION',p_operation_seq_num);
242: fnd_message.set_token('MATERIAL',l_material);
243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
244: fnd_msg_pub.add;
245: fnd_msg_pub.Count_And_Get(
246: p_count => x_msg_count,
247: p_data => x_msg_data);

Line 607: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');

603: if(x_msg_data is not null) then
604: x_msg_count := 1 ;
605: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
606: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
607: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
608: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
609: FND_MSG_PUB.ADD;
610: end if;
611: end if;

Line 608: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);

604: x_msg_count := 1 ;
605: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
606: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
607: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
608: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
609: FND_MSG_PUB.ADD;
610: end if;
611: end if;
612: /* end of fix for bug no:2719414 */

Line 1050: fnd_message.set_name('EAM', 'EAM_ALLOCATE_QTY_ERROR'); -- Error message to be provided

1046:
1047: else
1048:
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: fnd_message.set_name('EAM', 'EAM_ALLOCATE_QTY_ERROR'); -- Error message to be provided
1051: x_msg_data := fnd_message.get;
1052:
1053:
1054: end if; -- End of check for quantity issued

Line 1051: x_msg_data := fnd_message.get;

1047: else
1048:
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: fnd_message.set_name('EAM', 'EAM_ALLOCATE_QTY_ERROR'); -- Error message to be provided
1051: x_msg_data := fnd_message.get;
1052:
1053:
1054: end if; -- End of check for quantity issued
1055: