DBA Data[Home] [Help]

APPS.EAM_MATERIALISSUE_PVT dependencies on FND_MESSAGE

Line 270: fnd_message.set_name('EAM', 'EAM_INV_ONHAND_NOT_DETERMINED');

266: l_ret_status_qoh = FND_API.G_RET_STS_ERROR
267: ) THEN
268:
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: fnd_message.set_name('EAM', 'EAM_INV_ONHAND_NOT_DETERMINED');
271: fnd_message.set_token('MATERIAL',l_material);
272: fnd_msg_pub.add;
273: fnd_msg_pub.Count_And_Get(
274: p_count => x_msg_count,

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

267: ) THEN
268:
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: fnd_message.set_name('EAM', 'EAM_INV_ONHAND_NOT_DETERMINED');
271: fnd_message.set_token('MATERIAL',l_material);
272: fnd_msg_pub.add;
273: fnd_msg_pub.Count_And_Get(
274: p_count => x_msg_count,
275: p_data => x_msg_data);

Line 305: fnd_message.set_name('EAM', 'EAM_INV_QUANTITY_NEGATIVE');

301:
302: IF (p_requested_quantity > l_onhand_quantity) THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: fnd_message.set_name('EAM', 'EAM_INV_QUANTITY_NEGATIVE');
306: fnd_message.set_token('OPERATION',p_operation_seq_num);
307: fnd_message.set_token('MATERIAL',l_material);
308: fnd_message.set_token('ONHAND',l_onhand_quantity);
309: fnd_msg_pub.add;

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

302: IF (p_requested_quantity > l_onhand_quantity) THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: fnd_message.set_name('EAM', 'EAM_INV_QUANTITY_NEGATIVE');
306: fnd_message.set_token('OPERATION',p_operation_seq_num);
307: fnd_message.set_token('MATERIAL',l_material);
308: fnd_message.set_token('ONHAND',l_onhand_quantity);
309: fnd_msg_pub.add;
310: fnd_msg_pub.Count_And_Get(

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

303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: fnd_message.set_name('EAM', 'EAM_INV_QUANTITY_NEGATIVE');
306: fnd_message.set_token('OPERATION',p_operation_seq_num);
307: fnd_message.set_token('MATERIAL',l_material);
308: fnd_message.set_token('ONHAND',l_onhand_quantity);
309: fnd_msg_pub.add;
310: fnd_msg_pub.Count_And_Get(
311: p_count => x_msg_count,

Line 308: fnd_message.set_token('ONHAND',l_onhand_quantity);

304: x_return_status := FND_API.G_RET_STS_ERROR;
305: fnd_message.set_name('EAM', 'EAM_INV_QUANTITY_NEGATIVE');
306: fnd_message.set_token('OPERATION',p_operation_seq_num);
307: fnd_message.set_token('MATERIAL',l_material);
308: fnd_message.set_token('ONHAND',l_onhand_quantity);
309: fnd_msg_pub.add;
310: fnd_msg_pub.Count_And_Get(
311: p_count => x_msg_count,
312: p_data => x_msg_data);

Line 337: fnd_message.set_name('EAM', 'EAM_ISSUE_TXN_NOT_OPEN_PERIOD');

333: END;
334:
335: IF (l_within_open_period<>'Y') THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: fnd_message.set_name('EAM', 'EAM_ISSUE_TXN_NOT_OPEN_PERIOD');
338: fnd_message.set_token('OPERATION',p_operation_seq_num);
339: fnd_message.set_token('MATERIAL',l_material);
340: fnd_msg_pub.add;
341: fnd_msg_pub.Count_And_Get(

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

334:
335: IF (l_within_open_period<>'Y') THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: fnd_message.set_name('EAM', 'EAM_ISSUE_TXN_NOT_OPEN_PERIOD');
338: fnd_message.set_token('OPERATION',p_operation_seq_num);
339: fnd_message.set_token('MATERIAL',l_material);
340: fnd_msg_pub.add;
341: fnd_msg_pub.Count_And_Get(
342: p_count => x_msg_count,

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

335: IF (l_within_open_period<>'Y') THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: fnd_message.set_name('EAM', 'EAM_ISSUE_TXN_NOT_OPEN_PERIOD');
338: fnd_message.set_token('OPERATION',p_operation_seq_num);
339: fnd_message.set_token('MATERIAL',l_material);
340: fnd_msg_pub.add;
341: fnd_msg_pub.Count_And_Get(
342: p_count => x_msg_count,
343: p_data => x_msg_data);

Line 369: fnd_message.set_name('EAM', 'EAM_INV_SEC_LOC_RULE');

365: );
366:
367: IF NOT (l_sec_sta_valid ) THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: fnd_message.set_name('EAM', 'EAM_INV_SEC_LOC_RULE');
370: fnd_message.set_token('OPERATION',p_operation_seq_num);
371: fnd_message.set_token('MATERIAL',l_material);
372: fnd_message.set_token('LOCATOR',l_source_locator_id);
373: fnd_msg_pub.add;

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

366:
367: IF NOT (l_sec_sta_valid ) THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: fnd_message.set_name('EAM', 'EAM_INV_SEC_LOC_RULE');
370: fnd_message.set_token('OPERATION',p_operation_seq_num);
371: fnd_message.set_token('MATERIAL',l_material);
372: fnd_message.set_token('LOCATOR',l_source_locator_id);
373: fnd_msg_pub.add;
374: fnd_msg_pub.Count_And_Get(

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

367: IF NOT (l_sec_sta_valid ) THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: fnd_message.set_name('EAM', 'EAM_INV_SEC_LOC_RULE');
370: fnd_message.set_token('OPERATION',p_operation_seq_num);
371: fnd_message.set_token('MATERIAL',l_material);
372: fnd_message.set_token('LOCATOR',l_source_locator_id);
373: fnd_msg_pub.add;
374: fnd_msg_pub.Count_And_Get(
375: p_count => x_msg_count,

Line 372: fnd_message.set_token('LOCATOR',l_source_locator_id);

368: x_return_status := FND_API.G_RET_STS_ERROR;
369: fnd_message.set_name('EAM', 'EAM_INV_SEC_LOC_RULE');
370: fnd_message.set_token('OPERATION',p_operation_seq_num);
371: fnd_message.set_token('MATERIAL',l_material);
372: fnd_message.set_token('LOCATOR',l_source_locator_id);
373: fnd_msg_pub.add;
374: fnd_msg_pub.Count_And_Get(
375: p_count => x_msg_count,
376: p_data => x_msg_data);

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

381: --fix for 3454251.raise an error message if quantity to be issued is negative or zero
382:
383: if(p_requested_quantity<=0) then
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
386: fnd_message.set_token('OPERATION',p_operation_seq_num);
387: fnd_message.set_token('MATERIAL',l_material);
388: fnd_msg_pub.add;
389: fnd_msg_pub.Count_And_Get(

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

382:
383: if(p_requested_quantity<=0) then
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
386: fnd_message.set_token('OPERATION',p_operation_seq_num);
387: fnd_message.set_token('MATERIAL',l_material);
388: fnd_msg_pub.add;
389: fnd_msg_pub.Count_And_Get(
390: p_count => x_msg_count,

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

383: if(p_requested_quantity<=0) then
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
386: fnd_message.set_token('OPERATION',p_operation_seq_num);
387: fnd_message.set_token('MATERIAL',l_material);
388: fnd_msg_pub.add;
389: fnd_msg_pub.Count_And_Get(
390: p_count => x_msg_count,
391: p_data => x_msg_data);

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

393: end if;
394: --if the transaction date is in future raise an error message
395: if(p_date > sysdate) then
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
398: fnd_message.set_token('OPERATION',p_operation_seq_num);
399: fnd_message.set_token('MATERIAL',l_material);
400: fnd_msg_pub.add;
401: fnd_msg_pub.Count_And_Get(

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

394: --if the transaction date is in future raise an error message
395: if(p_date > sysdate) then
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
398: fnd_message.set_token('OPERATION',p_operation_seq_num);
399: fnd_message.set_token('MATERIAL',l_material);
400: fnd_msg_pub.add;
401: fnd_msg_pub.Count_And_Get(
402: p_count => x_msg_count,

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

395: if(p_date > sysdate) then
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
398: fnd_message.set_token('OPERATION',p_operation_seq_num);
399: fnd_message.set_token('MATERIAL',l_material);
400: fnd_msg_pub.add;
401: fnd_msg_pub.Count_And_Get(
402: p_count => x_msg_count,
403: p_data => x_msg_data);

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

414: l_num_range_serials := inv_serial_number_pub.get_serial_diff(
415: l_fm_serial_number, l_to_serial_number);
416: if (l_num_range_serials <> p_requested_quantity) then
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
419: fnd_message.set_token('OPERATION',p_operation_seq_num);
420: fnd_message.set_token('MATERIAL',l_material);
421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);

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

415: l_fm_serial_number, l_to_serial_number);
416: if (l_num_range_serials <> p_requested_quantity) then
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
419: fnd_message.set_token('OPERATION',p_operation_seq_num);
420: fnd_message.set_token('MATERIAL',l_material);
421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);

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

416: if (l_num_range_serials <> p_requested_quantity) then
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
419: fnd_message.set_token('OPERATION',p_operation_seq_num);
420: fnd_message.set_token('MATERIAL',l_material);
421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
424: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);

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

417: x_return_status := FND_API.G_RET_STS_ERROR;
418: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
419: fnd_message.set_token('OPERATION',p_operation_seq_num);
420: fnd_message.set_token('MATERIAL',l_material);
421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
424: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
425: fnd_msg_pub.add;

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

418: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
419: fnd_message.set_token('OPERATION',p_operation_seq_num);
420: fnd_message.set_token('MATERIAL',l_material);
421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
424: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
425: fnd_msg_pub.add;
426: fnd_msg_pub.Count_And_Get(

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

419: fnd_message.set_token('OPERATION',p_operation_seq_num);
420: fnd_message.set_token('MATERIAL',l_material);
421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
424: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
425: fnd_msg_pub.add;
426: fnd_msg_pub.Count_And_Get(
427: p_count => x_msg_count,

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

420: fnd_message.set_token('MATERIAL',l_material);
421: fnd_message.set_token('QTY_RANGE',l_num_range_serials);
422: fnd_message.set_token('FM_SERIAL',l_fm_serial_number);
423: fnd_message.set_token('TO_SERIAL',l_to_serial_number);
424: fnd_message.set_token('QTY_ENTERED',p_requested_quantity);
425: fnd_msg_pub.add;
426: fnd_msg_pub.Count_And_Get(
427: p_count => x_msg_count,
428: p_data => x_msg_data);

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

445: AND LENGTH(msn.serial_number) = LENGTH(l_fm_serial_number);
446:
447: if (l_num_valid_serials <> p_requested_quantity) then
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
450: fnd_message.set_token('OPERATION',p_operation_seq_num);
451: fnd_message.set_token('MATERIAL',l_material);
452: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
453: fnd_msg_pub.add;

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

446:
447: if (l_num_valid_serials <> p_requested_quantity) then
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
450: fnd_message.set_token('OPERATION',p_operation_seq_num);
451: fnd_message.set_token('MATERIAL',l_material);
452: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
453: fnd_msg_pub.add;
454: fnd_msg_pub.Count_And_Get(

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

447: if (l_num_valid_serials <> p_requested_quantity) then
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
450: fnd_message.set_token('OPERATION',p_operation_seq_num);
451: fnd_message.set_token('MATERIAL',l_material);
452: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
453: fnd_msg_pub.add;
454: fnd_msg_pub.Count_And_Get(
455: p_count => x_msg_count,

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

448: x_return_status := FND_API.G_RET_STS_ERROR;
449: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
450: fnd_message.set_token('OPERATION',p_operation_seq_num);
451: fnd_message.set_token('MATERIAL',l_material);
452: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);
453: fnd_msg_pub.add;
454: fnd_msg_pub.Count_And_Get(
455: p_count => x_msg_count,
456: p_data => x_msg_data);

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

830: if(x_msg_data is not null) then
831: x_msg_count := 1 ;
832: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
833: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
835: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
836: FND_MSG_PUB.ADD;
837: end if;
838: end if;

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

831: x_msg_count := 1 ;
832: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
833: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: FND_MESSAGE.SET_NAME('EAM','EAM_WIP_PROCESSOR_MSG');
835: FND_MESSAGE.SET_TOKEN('WIPMSG',x_msg_data);
836: FND_MSG_PUB.ADD;
837: end if;
838: end if;
839: /* end of fix for bug no:2719414 */

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

1273:
1274: else
1275:
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: fnd_message.set_name('EAM', 'EAM_ALLOCATE_QTY_ERROR'); -- Error message to be provided
1278: x_msg_data := fnd_message.get;
1279:
1280:
1281: end if; -- End of check for quantity issued

Line 1278: x_msg_data := fnd_message.get;

1274: else
1275:
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: fnd_message.set_name('EAM', 'EAM_ALLOCATE_QTY_ERROR'); -- Error message to be provided
1278: x_msg_data := fnd_message.get;
1279:
1280:
1281: end if; -- End of check for quantity issued
1282: