eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on FND_MESSAGE

Line 141: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');

137: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
138:
139: p_count_of_errored := sql%rowcount;
140:
141: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
142: fnd_message.set_token('ENTITY1', 'ORGANIZATION_ID');
143: fnd_message.set_token('ENTITY2', 'ORGANIZATION_CODE');
144: add_error(p_txn_ids => enums,
145: p_err_col => 'ORGANIZATION_ID/CODE',

Line 142: fnd_message.set_token('ENTITY1', 'ORGANIZATION_ID');

138:
139: p_count_of_errored := sql%rowcount;
140:
141: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
142: fnd_message.set_token('ENTITY1', 'ORGANIZATION_ID');
143: fnd_message.set_token('ENTITY2', 'ORGANIZATION_CODE');
144: add_error(p_txn_ids => enums,
145: p_err_col => 'ORGANIZATION_ID/CODE',
146: p_err_msg => fnd_message.get);

Line 143: fnd_message.set_token('ENTITY2', 'ORGANIZATION_CODE');

139: p_count_of_errored := sql%rowcount;
140:
141: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
142: fnd_message.set_token('ENTITY1', 'ORGANIZATION_ID');
143: fnd_message.set_token('ENTITY2', 'ORGANIZATION_CODE');
144: add_error(p_txn_ids => enums,
145: p_err_col => 'ORGANIZATION_ID/CODE',
146: p_err_msg => fnd_message.get);
147:

Line 146: p_err_msg => fnd_message.get);

142: fnd_message.set_token('ENTITY1', 'ORGANIZATION_ID');
143: fnd_message.set_token('ENTITY2', 'ORGANIZATION_CODE');
144: add_error(p_txn_ids => enums,
145: p_err_col => 'ORGANIZATION_ID/CODE',
146: p_err_msg => fnd_message.get);
147:
148: load_errors;
149:
150: END organization_id;

Line 215: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

211: )
212: ))
213: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
214:
215: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
216: fnd_message.set_token('ENTITY', 'WIP_ENTITY_ID - WIP_ENTITY_NAME');
217: add_error(p_txn_ids => enums,
218: p_err_col => 'WIP_ENTITY_ID/NAME',
219: p_err_msg => fnd_message.get);

Line 216: fnd_message.set_token('ENTITY', 'WIP_ENTITY_ID - WIP_ENTITY_NAME');

212: ))
213: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
214:
215: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
216: fnd_message.set_token('ENTITY', 'WIP_ENTITY_ID - WIP_ENTITY_NAME');
217: add_error(p_txn_ids => enums,
218: p_err_col => 'WIP_ENTITY_ID/NAME',
219: p_err_msg => fnd_message.get);
220:

Line 219: p_err_msg => fnd_message.get);

215: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
216: fnd_message.set_token('ENTITY', 'WIP_ENTITY_ID - WIP_ENTITY_NAME');
217: add_error(p_txn_ids => enums,
218: p_err_col => 'WIP_ENTITY_ID/NAME',
219: p_err_msg => fnd_message.get);
220:
221: -- Derive ENTITY_TYPE and PRIMARY_ITEM_ID from WIP_ENTITY_ID
222: UPDATE wip_move_txn_interface wmti
223: SET (wmti.entity_type, wmti.primary_item_id) =

Line 243: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');

239: AND wmti.process_status = WIP_CONSTANTS.RUNNING
240: AND wmti.primary_item_id IS NULL
241: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
242:
243: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');
244: add_error(p_txn_ids => enums,
245: p_err_col => 'WIP_ENTITY_ID/NAME',
246: p_err_msg => fnd_message.get);
247:

Line 246: p_err_msg => fnd_message.get);

242:
243: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');
244: add_error(p_txn_ids => enums,
245: p_err_col => 'WIP_ENTITY_ID/NAME',
246: p_err_msg => fnd_message.get);
247:
248: /************************
249: * Start Repetitive Check
250: ************************/

Line 289: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');

285: )
286: ))
287: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
288:
289: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
290: add_error(p_txn_ids => enums,
291: p_err_col => 'LINE_ID/CODE',
292: p_err_msg => fnd_message.get);
293:

Line 292: p_err_msg => fnd_message.get);

288:
289: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
290: add_error(p_txn_ids => enums,
291: p_err_col => 'LINE_ID/CODE',
292: p_err_msg => fnd_message.get);
293:
294: -- derive the first transactable schedule if REPETITIVE_SCHEDULE_ID is null
295: UPDATE wip_move_txn_interface wmti
296: SET wmti.repetitive_schedule_id =

Line 331: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');

327: AND wmti.entity_type = WIP_CONSTANTS.REPETITIVE
328: AND wmti.repetitive_schedule_id IS NULL
329: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
330:
331: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
332: add_error(p_txn_ids => enums,
333: p_err_col => 'LINE_ID/CODE',
334: p_err_msg => fnd_message.get);
335:

Line 334: p_err_msg => fnd_message.get);

330:
331: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
332: add_error(p_txn_ids => enums,
333: p_err_col => 'LINE_ID/CODE',
334: p_err_msg => fnd_message.get);
335:
336: /************************
337: * End Repetitive Check
338: ************************/

Line 358: fnd_message.set_name('WIP', 'WIP_NULL_LINE_ID');

354: wmti.line_code IS NOT NULL OR
355: wmti.repetitive_schedule_id IS NOT NULL)
356: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
357:
358: fnd_message.set_name('WIP', 'WIP_NULL_LINE_ID');
359: add_error(p_txn_ids => enums,
360: p_err_col => 'WIP_ENTITY_ID/NAME',
361: p_err_msg => fnd_message.get);
362:

Line 361: p_err_msg => fnd_message.get);

357:
358: fnd_message.set_name('WIP', 'WIP_NULL_LINE_ID');
359: add_error(p_txn_ids => enums,
360: p_err_col => 'WIP_ENTITY_ID/NAME',
361: p_err_msg => fnd_message.get);
362:
363: /************************
364: * End Discrete Check
365: ************************/

Line 395: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');

391: AND wdj.status_type IN (WIP_CONSTANTS.RELEASED,
392: WIP_CONSTANTS.COMP_CHRG))))
393: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
394:
395: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
396: add_error(p_txn_ids => enums,
397: p_err_col => 'WIP_ENTITY_ID/NAME',
398: p_err_msg => fnd_message.get);
399:

Line 398: p_err_msg => fnd_message.get);

394:
395: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
396: add_error(p_txn_ids => enums,
397: p_err_col => 'WIP_ENTITY_ID/NAME',
398: p_err_msg => fnd_message.get);
399:
400: -- reset enums table
401: enums.delete;
402: -- If job/schedule specified has no routing, error out

Line 417: fnd_message.set_name('WIP', 'WIP_ROUTING_NOT_FOUND');

413: AND NVL(wo.repetitive_schedule_id, -1) =
414: NVL(wmti.repetitive_schedule_id, -1))
415: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
416:
417: fnd_message.set_name('WIP', 'WIP_ROUTING_NOT_FOUND');
418: fnd_message.set_token('ROUTINE', 'for Job/Schedule specified');
419: add_error(p_txn_ids => enums,
420: p_err_col => 'WIP_ENTITY_ID/NAME',
421: p_err_msg => fnd_message.get);

Line 418: fnd_message.set_token('ROUTINE', 'for Job/Schedule specified');

414: NVL(wmti.repetitive_schedule_id, -1))
415: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
416:
417: fnd_message.set_name('WIP', 'WIP_ROUTING_NOT_FOUND');
418: fnd_message.set_token('ROUTINE', 'for Job/Schedule specified');
419: add_error(p_txn_ids => enums,
420: p_err_col => 'WIP_ENTITY_ID/NAME',
421: p_err_msg => fnd_message.get);
422:

Line 421: p_err_msg => fnd_message.get);

417: fnd_message.set_name('WIP', 'WIP_ROUTING_NOT_FOUND');
418: fnd_message.set_token('ROUTINE', 'for Job/Schedule specified');
419: add_error(p_txn_ids => enums,
420: p_err_col => 'WIP_ENTITY_ID/NAME',
421: p_err_msg => fnd_message.get);
422:
423: END wip_entity_id;
424:
425: -- validate transaction_type. If the callers did not provide this info,

Line 456: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

452: WIP_CONSTANTS.COMP_TXN,
453: WIP_CONSTANTS.RET_TXN)
454: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
455:
456: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
457: fnd_message.set_token('ENTITY', 'TRANSACTION_TYPE');
458: add_error(p_txn_ids => enums,
459: p_err_col => 'TRANSACTION_TYPE',
460: p_err_msg => fnd_message.get);

Line 457: fnd_message.set_token('ENTITY', 'TRANSACTION_TYPE');

453: WIP_CONSTANTS.RET_TXN)
454: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
455:
456: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
457: fnd_message.set_token('ENTITY', 'TRANSACTION_TYPE');
458: add_error(p_txn_ids => enums,
459: p_err_col => 'TRANSACTION_TYPE',
460: p_err_msg => fnd_message.get);
461:

Line 460: p_err_msg => fnd_message.get);

456: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
457: fnd_message.set_token('ENTITY', 'TRANSACTION_TYPE');
458: add_error(p_txn_ids => enums,
459: p_err_col => 'TRANSACTION_TYPE',
460: p_err_msg => fnd_message.get);
461:
462: -- reset enums table
463: enums.delete;
464: -- Error out if easy completion/return and the assembly is under serial

Line 486: fnd_message.set_name('WIP', 'WIP_EZ_NO_SERIAL_CONTROL2');

482: AND msi.serial_number_control_code IN (WIP_CONSTANTS.FULL_SN,
483: WIP_CONSTANTS.DYN_RCV_SN))
484: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
485:
486: fnd_message.set_name('WIP', 'WIP_EZ_NO_SERIAL_CONTROL2');
487: add_error(p_txn_ids => enums,
488: p_err_col => 'TRANSACTION_TYPE',
489: p_err_msg => fnd_message.get);
490:

Line 489: p_err_msg => fnd_message.get);

485:
486: fnd_message.set_name('WIP', 'WIP_EZ_NO_SERIAL_CONTROL2');
487: add_error(p_txn_ids => enums,
488: p_err_col => 'TRANSACTION_TYPE',
489: p_err_msg => fnd_message.get);
490:
491: -- reset enums table
492: enums.delete;
493: -- Error out if easy completion/return and no default completion subinventory

Line 521: fnd_message.set_name('WIP', 'WIP_EZ_NO_SUBINV_DEFAULT2');

517: AND wdj.organization_id = wmti.organization_id
518: AND wdj.completion_subinventory IS NULL)))
519: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
520:
521: fnd_message.set_name('WIP', 'WIP_EZ_NO_SUBINV_DEFAULT2');
522: add_error(p_txn_ids => enums,
523: p_err_col => 'TRANSACTION_TYPE',
524: p_err_msg => fnd_message.get);
525:

Line 524: p_err_msg => fnd_message.get);

520:
521: fnd_message.set_name('WIP', 'WIP_EZ_NO_SUBINV_DEFAULT2');
522: add_error(p_txn_ids => enums,
523: p_err_col => 'TRANSACTION_TYPE',
524: p_err_msg => fnd_message.get);
525:
526: -- reset enums table
527: enums.delete;
528: -- Error out if item revision does not exist as a BOM revision

Line 571: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');

567: AND (wdj.bom_revision IS NULL OR
568: mir.revision = wdj.bom_revision))))
569: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
570:
571: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
572: add_error(p_txn_ids => enums,
573: p_err_col => 'TRANSACTION_TYPE',
574: p_err_msg => fnd_message.get);
575:

Line 574: p_err_msg => fnd_message.get);

570:
571: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
572: add_error(p_txn_ids => enums,
573: p_err_col => 'TRANSACTION_TYPE',
574: p_err_msg => fnd_message.get);
575:
576: -- reset enums table
577: enums.delete;
578: -- Error out if easy completion /return for repetitive schedule

Line 596: fnd_message.set_name('WIP', 'WIP_EZ_NO_REP_LOT_CONTROL2');

592: AND msi.organization_id = wmti.organization_id
593: AND msi.lot_control_code = WIP_CONSTANTS.LOT)
594: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
595:
596: fnd_message.set_name('WIP', 'WIP_EZ_NO_REP_LOT_CONTROL2');
597: add_error(p_txn_ids => enums,
598: p_err_col => 'TRANSACTION_TYPE',
599: p_err_msg => fnd_message.get);
600:

Line 599: p_err_msg => fnd_message.get);

595:
596: fnd_message.set_name('WIP', 'WIP_EZ_NO_REP_LOT_CONTROL2');
597: add_error(p_txn_ids => enums,
598: p_err_col => 'TRANSACTION_TYPE',
599: p_err_msg => fnd_message.get);
600:
601: -- reset enums table
602: enums.delete;
603: -- Error out if easy completion /return for Discrete job and the assembly

Line 628: fnd_message.set_name('WIP', 'WIP_EZ_NO_JOB_LOT_DEFAULT2');

624: AND wdj.wip_entity_id = wmti.wip_entity_id
625: AND wdj.lot_number IS NULL)
626: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
627:
628: fnd_message.set_name('WIP', 'WIP_EZ_NO_JOB_LOT_DEFAULT2');
629: add_error(p_txn_ids => enums,
630: p_err_col => 'TRANSACTION_TYPE',
631: p_err_msg => fnd_message.get);
632:

Line 631: p_err_msg => fnd_message.get);

627:
628: fnd_message.set_name('WIP', 'WIP_EZ_NO_JOB_LOT_DEFAULT2');
629: add_error(p_txn_ids => enums,
630: p_err_col => 'TRANSACTION_TYPE',
631: p_err_msg => fnd_message.get);
632:
633: -- reset enums table
634: enums.delete;
635: -- Error out if easy completion to the new lot number and and either this

Line 668: fnd_message.set_name('WIP', 'WIP_LOT_ATTR_NOT_ALLOW');

664: wmti.organization_id, -- p_organization_id
665: wmti.primary_item_id) -- p_inventory_item_id
666: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
667:
668: fnd_message.set_name('WIP', 'WIP_LOT_ATTR_NOT_ALLOW');
669: add_error(p_txn_ids => enums,
670: p_err_col => 'TRANSACTION_TYPE',
671: p_err_msg => fnd_message.get);
672:

Line 671: p_err_msg => fnd_message.get);

667:
668: fnd_message.set_name('WIP', 'WIP_LOT_ATTR_NOT_ALLOW');
669: add_error(p_txn_ids => enums,
670: p_err_col => 'TRANSACTION_TYPE',
671: p_err_msg => fnd_message.get);
672:
673: -- reset enums table
674: enums.delete;
675: -- Error out if easy completion to the new lot number and lot expiration date

Line 704: fnd_message.set_name('WIP', 'WIP_USER_DEF_EXP_NOT_ALLOW');

700: AND mln.organization_id = wmti.organization_id
701: AND mln.lot_number = wdj.lot_number)
702: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
703:
704: fnd_message.set_name('WIP', 'WIP_USER_DEF_EXP_NOT_ALLOW');
705: add_error(p_txn_ids => enums,
706: p_err_col => 'TRANSACTION_TYPE',
707: p_err_msg => fnd_message.get);
708:

Line 707: p_err_msg => fnd_message.get);

703:
704: fnd_message.set_name('WIP', 'WIP_USER_DEF_EXP_NOT_ALLOW');
705: add_error(p_txn_ids => enums,
706: p_err_col => 'TRANSACTION_TYPE',
707: p_err_msg => fnd_message.get);
708:
709: END transaction_type;
710:
711: -- validate transaction_date. Transaction date must be less than or equal

Line 726: fnd_message.set_name('WIP', 'WIP_NO_FORWARD_DATING');

722: AND wmti.process_status = WIP_CONSTANTS.RUNNING
723: AND wmti.transaction_date > SYSDATE
724: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
725:
726: fnd_message.set_name('WIP', 'WIP_NO_FORWARD_DATING');
727: add_error(p_txn_ids => enums,
728: p_err_col => 'TRANSACTION_DATE',
729: p_err_msg => fnd_message.get);
730:

Line 729: p_err_msg => fnd_message.get);

725:
726: fnd_message.set_name('WIP', 'WIP_NO_FORWARD_DATING');
727: add_error(p_txn_ids => enums,
728: p_err_col => 'TRANSACTION_DATE',
729: p_err_msg => fnd_message.get);
730:
731: /* Fix for bug 5685099 : Validate if TRANSACTION_DATE falls in open accounting period. */
732: -- reset enums table
733: enums.delete;

Line 753: fnd_message.set_name('WIP', 'WIP_DATE_IN_OPEN_PERIOD');

749: ))
750: BETWEEN OAP.PERIOD_START_DATE AND OAP.SCHEDULE_CLOSE_DATE)
751: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
752:
753: fnd_message.set_name('WIP', 'WIP_DATE_IN_OPEN_PERIOD');
754: add_error(p_txn_ids => enums,
755: p_err_col => 'TRANSACTION_DATE',
756: p_err_msg => fnd_message.get);
757:

Line 756: p_err_msg => fnd_message.get);

752:
753: fnd_message.set_name('WIP', 'WIP_DATE_IN_OPEN_PERIOD');
754: add_error(p_txn_ids => enums,
755: p_err_col => 'TRANSACTION_DATE',
756: p_err_msg => fnd_message.get);
757:
758: /* end fix for bug 5685099 */
759:
760: -- reset enums table

Line 786: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');

782: AND wdj.organization_id = wmti.organization_id
783: AND wdj.date_released > wmti.transaction_date)))
784: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
785:
786: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');
787: add_error(p_txn_ids => enums,
788: p_err_col => 'TRANSACTION_DATE',
789: p_err_msg => fnd_message.get);
790:

Line 789: p_err_msg => fnd_message.get);

785:
786: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');
787: add_error(p_txn_ids => enums,
788: p_err_col => 'TRANSACTION_DATE',
789: p_err_msg => fnd_message.get);
790:
791: -- Derive ACCT_PERIOD_ID from TRANSACTION_DATE
792: UPDATE wip_move_txn_interface wmti
793: SET wmti.acct_period_id =

Line 836: fnd_message.set_name('WIP', 'WIP_NO_BALANCE');

832: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,
833: WIP_CONSTANTS.COMP_CHRG))))))
834: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
835:
836: fnd_message.set_name('WIP', 'WIP_NO_BALANCE');
837: add_error(p_txn_ids => enums,
838: p_err_col => 'TRANSACTION_DATE',
839: p_err_msg => fnd_message.get);
840:

Line 839: p_err_msg => fnd_message.get);

835:
836: fnd_message.set_name('WIP', 'WIP_NO_BALANCE');
837: add_error(p_txn_ids => enums,
838: p_err_col => 'TRANSACTION_DATE',
839: p_err_msg => fnd_message.get);
840:
841: END transaction_date;
842:
843: -- validate fm_operation_seq_num. From operation must be a valid operation.

Line 889: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');

885: AND NVL(wo.repetitive_schedule_id, -1) =
886: NVL(wmti.repetitive_schedule_id, -1))))
887: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
888:
889: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
890: add_error(p_txn_ids => enums,
891: p_err_col => 'FM_OPERATION_SEQ_NUM',
892: p_err_msg => fnd_message.get);
893:

Line 892: p_err_msg => fnd_message.get);

888:
889: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
890: add_error(p_txn_ids => enums,
891: p_err_col => 'FM_OPERATION_SEQ_NUM',
892: p_err_msg => fnd_message.get);
893:
894: -- reset enums table
895: enums.delete;
896: -- Error out if TRANSACTION_TYPE is EZ Return and FM_OPERATION_SEQ_NUM

Line 914: fnd_message.set_name('WIP', 'WIP_EZ_FM_LAST_OP');

910: NVL(wmti.repetitive_schedule_id, -1)
911: AND wo.next_operation_seq_num IS NULL)
912: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
913:
914: fnd_message.set_name('WIP', 'WIP_EZ_FM_LAST_OP');
915: add_error(p_txn_ids => enums,
916: p_err_col => 'FM_OPERATION_SEQ_NUM',
917: p_err_msg => fnd_message.get);
918: END fm_operation;

Line 917: p_err_msg => fnd_message.get);

913:
914: fnd_message.set_name('WIP', 'WIP_EZ_FM_LAST_OP');
915: add_error(p_txn_ids => enums,
916: p_err_col => 'FM_OPERATION_SEQ_NUM',
917: p_err_msg => fnd_message.get);
918: END fm_operation;
919:
920: -- validate fm_intraoperation_step_type. From step must be valid.
921: -- If easy return transaction, from step must be "To move". If easy complete,

Line 967: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

963: (wvis.record_creator = 'SYSTEM' AND
964: wo.next_operation_seq_num IS NULL)))))
965: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
966:
967: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
968: fnd_message.set_token('ENTITY', 'FM_INTRAOPERATION_STEP_TYPE');
969: add_error(p_txn_ids => enums,
970: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
971: p_err_msg => fnd_message.get);

Line 968: fnd_message.set_token('ENTITY', 'FM_INTRAOPERATION_STEP_TYPE');

964: wo.next_operation_seq_num IS NULL)))))
965: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
966:
967: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
968: fnd_message.set_token('ENTITY', 'FM_INTRAOPERATION_STEP_TYPE');
969: add_error(p_txn_ids => enums,
970: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
971: p_err_msg => fnd_message.get);
972:

Line 971: p_err_msg => fnd_message.get);

967: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
968: fnd_message.set_token('ENTITY', 'FM_INTRAOPERATION_STEP_TYPE');
969: add_error(p_txn_ids => enums,
970: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
971: p_err_msg => fnd_message.get);
972:
973: -- reset enums table
974: enums.delete;
975: -- Error out if FM_OPERATION_SEQ_NUM/FM_INTRAOPERATION_STEP_TYPE has

Line 1026: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');

1022: AND wsc.status_move_flag = WIP_CONSTANTS.NO
1023: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
1024: AND rownum = 1;
1025:
1026: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
1027: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1028: add_error(p_txn_id => enums(i),
1029: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1030: p_err_msg => fnd_message.get);

Line 1027: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

1023: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
1024: AND rownum = 1;
1025:
1026: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
1027: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1028: add_error(p_txn_id => enums(i),
1029: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1030: p_err_msg => fnd_message.get);
1031: end loop;

Line 1030: p_err_msg => fnd_message.get);

1026: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
1027: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1028: add_error(p_txn_id => enums(i),
1029: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1030: p_err_msg => fnd_message.get);
1031: end loop;
1032: end if;
1033:
1034: -- reset enums table

Line 1055: fnd_message.set_name('WIP', 'WIP_EZ_NO_CMP_LAST_OP2');

1051: NVL(wmti.repetitive_schedule_id, -1)
1052: AND wo.next_operation_seq_num IS NULL)
1053: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1054:
1055: fnd_message.set_name('WIP', 'WIP_EZ_NO_CMP_LAST_OP2');
1056: add_error(p_txn_ids => enums,
1057: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1058: p_err_msg => fnd_message.get);
1059:

Line 1058: p_err_msg => fnd_message.get);

1054:
1055: fnd_message.set_name('WIP', 'WIP_EZ_NO_CMP_LAST_OP2');
1056: add_error(p_txn_ids => enums,
1057: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1058: p_err_msg => fnd_message.get);
1059:
1060: -- reset enums table
1061: enums.delete;
1062: -- Error out if TRANSACTION_TYPE is EZ Return and

Line 1073: fnd_message.set_name('WIP', 'WIP_EZ_FM_LAST_STEP');

1069: AND wmti.transaction_type = WIP_CONSTANTS.RET_TXN
1070: AND wmti.fm_intraoperation_step_type <> WIP_CONSTANTS.TOMOVE
1071: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1072:
1073: fnd_message.set_name('WIP', 'WIP_EZ_FM_LAST_STEP');
1074: add_error(p_txn_ids => enums,
1075: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1076: p_err_msg => fnd_message.get);
1077: END fm_step;

Line 1076: p_err_msg => fnd_message.get);

1072:
1073: fnd_message.set_name('WIP', 'WIP_EZ_FM_LAST_STEP');
1074: add_error(p_txn_ids => enums,
1075: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
1076: p_err_msg => fnd_message.get);
1077: END fm_step;
1078:
1079: -- validate to_operation_seq_num. To operation must be a valid operation.
1080: -- For easy complete transaction, To operation must be the last operation.

Line 1142: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');

1138: AND NVL(wo.repetitive_schedule_id, -1) =
1139: NVL(wmti.repetitive_schedule_id, -1))))
1140: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1141:
1142: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
1143: add_error(p_txn_ids => enums,
1144: p_err_col => 'TO_OPERATION_SEQ_NUM',
1145: p_err_msg => fnd_message.get);
1146:

Line 1145: p_err_msg => fnd_message.get);

1141:
1142: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
1143: add_error(p_txn_ids => enums,
1144: p_err_col => 'TO_OPERATION_SEQ_NUM',
1145: p_err_msg => fnd_message.get);
1146:
1147: -- reset enums table
1148: enums.delete;
1149: -- Error out if TRANSACTION_TYPE is EZ Ccmplete and TO_OPERATION_SEQ_NUM

Line 1167: fnd_message.set_name('WIP', 'WIP_EZ_TO_LAST_OP');

1163: NVL(wmti.repetitive_schedule_id, -1)
1164: AND wo.next_operation_seq_num IS NULL)
1165: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1166:
1167: fnd_message.set_name('WIP', 'WIP_EZ_TO_LAST_OP');
1168: add_error(p_txn_ids => enums,
1169: p_err_col => 'TO_OPERATION_SEQ_NUM',
1170: p_err_msg => fnd_message.get);
1171: END to_operation;

Line 1170: p_err_msg => fnd_message.get);

1166:
1167: fnd_message.set_name('WIP', 'WIP_EZ_TO_LAST_OP');
1168: add_error(p_txn_ids => enums,
1169: p_err_col => 'TO_OPERATION_SEQ_NUM',
1170: p_err_msg => fnd_message.get);
1171: END to_operation;
1172:
1173: -- validate to_intraoperation_step_type. To step must be valid.
1174: -- If easy complete transaction, to step must be "To move". If easy return,

Line 1239: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

1235: wvis.step_lookup_type = WIP_CONSTANTS.QUEUE))))))
1236:
1237: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1238:
1239: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1240: fnd_message.set_token('ENTITY', 'TO_INTRAOPERATION_STEP_TYPE');
1241: add_error(p_txn_ids => enums,
1242: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1243: p_err_msg => fnd_message.get);

Line 1240: fnd_message.set_token('ENTITY', 'TO_INTRAOPERATION_STEP_TYPE');

1236:
1237: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1238:
1239: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1240: fnd_message.set_token('ENTITY', 'TO_INTRAOPERATION_STEP_TYPE');
1241: add_error(p_txn_ids => enums,
1242: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1243: p_err_msg => fnd_message.get);
1244:

Line 1243: p_err_msg => fnd_message.get);

1239: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1240: fnd_message.set_token('ENTITY', 'TO_INTRAOPERATION_STEP_TYPE');
1241: add_error(p_txn_ids => enums,
1242: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1243: p_err_msg => fnd_message.get);
1244:
1245: -- reset enums table
1246: enums.delete;
1247: -- Error out if users try to move to the same operation and step as the

Line 1258: fnd_message.set_name('WIP', 'WIP_SAME_OP_AND_STEP');

1254: AND wmti.fm_operation_seq_num = wmti.to_operation_seq_num
1255: AND wmti.fm_intraoperation_step_type = wmti.to_intraoperation_step_type
1256: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1257:
1258: fnd_message.set_name('WIP', 'WIP_SAME_OP_AND_STEP');
1259: add_error(p_txn_ids => enums,
1260: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1261: p_err_msg => fnd_message.get);
1262:

Line 1261: p_err_msg => fnd_message.get);

1257:
1258: fnd_message.set_name('WIP', 'WIP_SAME_OP_AND_STEP');
1259: add_error(p_txn_ids => enums,
1260: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1261: p_err_msg => fnd_message.get);
1262:
1263: -- reset enums table
1264: enums.delete;
1265: -- Error out if TRANSACTION_TYPE is EZ Complete and

Line 1276: fnd_message.set_name('WIP', 'WIP_EZ_TO_LAST_STEP');

1272: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
1273: AND wmti.to_intraoperation_step_type <> WIP_CONSTANTS.TOMOVE
1274: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1275:
1276: fnd_message.set_name('WIP', 'WIP_EZ_TO_LAST_STEP');
1277: add_error(p_txn_ids => enums,
1278: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1279: p_err_msg => fnd_message.get);
1280:

Line 1279: p_err_msg => fnd_message.get);

1275:
1276: fnd_message.set_name('WIP', 'WIP_EZ_TO_LAST_STEP');
1277: add_error(p_txn_ids => enums,
1278: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1279: p_err_msg => fnd_message.get);
1280:
1281: -- reset enums table
1282: enums.delete;
1283: -- Error out if user try to easy complete job/schedule that has No Move shop

Line 1326: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');

1322: AND wsc.status_move_flag = WIP_CONSTANTS.NO
1323: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
1324: and rownum = 1;
1325:
1326: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
1327: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1328: add_error(p_txn_id => enums(i),
1329: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1330: p_err_msg => fnd_message.get);

Line 1327: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

1323: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
1324: and rownum = 1;
1325:
1326: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
1327: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1328: add_error(p_txn_id => enums(i),
1329: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1330: p_err_msg => fnd_message.get);
1331: end loop;

Line 1330: p_err_msg => fnd_message.get);

1326: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
1327: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1328: add_error(p_txn_id => enums(i),
1329: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1330: p_err_msg => fnd_message.get);
1331: end loop;
1332: end if;
1333:
1334: -- reset enums table

Line 1373: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');

1369: into l_sf_status
1370: from wip_move_txn_interface wmti
1371: where wmti.transaction_id = enums(i)
1372: and wmti.process_status = WIP_CONSTANTS.ERROR;
1373: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
1374: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1375: add_error(p_txn_id => enums(i),
1376: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1377: p_err_msg => fnd_message.get);

Line 1374: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

1370: from wip_move_txn_interface wmti
1371: where wmti.transaction_id = enums(i)
1372: and wmti.process_status = WIP_CONSTANTS.ERROR;
1373: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
1374: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1375: add_error(p_txn_id => enums(i),
1376: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1377: p_err_msg => fnd_message.get);
1378: end loop;

Line 1377: p_err_msg => fnd_message.get);

1373: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
1374: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1375: add_error(p_txn_id => enums(i),
1376: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
1377: p_err_msg => fnd_message.get);
1378: end loop;
1379: end if;
1380: END to_step;
1381:

Line 1397: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');

1393: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1394: AND wmti.transaction_quantity <= 0
1395: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1396:
1397: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1398: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1399: fnd_message.set_token('ENTITY2', 'zero');
1400: add_error(p_txn_ids => enums,
1401: p_err_col => 'TRANSACTION_QUANTITY',

Line 1398: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');

1394: AND wmti.transaction_quantity <= 0
1395: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1396:
1397: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1398: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1399: fnd_message.set_token('ENTITY2', 'zero');
1400: add_error(p_txn_ids => enums,
1401: p_err_col => 'TRANSACTION_QUANTITY',
1402: p_err_msg => fnd_message.get);

Line 1399: fnd_message.set_token('ENTITY2', 'zero');

1395: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1396:
1397: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1398: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1399: fnd_message.set_token('ENTITY2', 'zero');
1400: add_error(p_txn_ids => enums,
1401: p_err_col => 'TRANSACTION_QUANTITY',
1402: p_err_msg => fnd_message.get);
1403:

Line 1402: p_err_msg => fnd_message.get);

1398: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1399: fnd_message.set_token('ENTITY2', 'zero');
1400: add_error(p_txn_ids => enums,
1401: p_err_col => 'TRANSACTION_QUANTITY',
1402: p_err_msg => fnd_message.get);
1403:
1404: END transaction_qty;
1405:
1406:

Line 1426: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

1422: AND miuv.inventory_item_id = wmti.primary_item_id
1423: AND miuv.uom_code = wmti.transaction_uom)
1424: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1425:
1426: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1427: fnd_message.set_token('ENTITY', 'TRANSACTION_UOM');
1428: add_error(p_txn_ids => enums,
1429: p_err_col => 'TRANSACTION_UOM',
1430: p_err_msg => fnd_message.get);

Line 1427: fnd_message.set_token('ENTITY', 'TRANSACTION_UOM');

1423: AND miuv.uom_code = wmti.transaction_uom)
1424: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1425:
1426: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1427: fnd_message.set_token('ENTITY', 'TRANSACTION_UOM');
1428: add_error(p_txn_ids => enums,
1429: p_err_col => 'TRANSACTION_UOM',
1430: p_err_msg => fnd_message.get);
1431:

Line 1430: p_err_msg => fnd_message.get);

1426: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1427: fnd_message.set_token('ENTITY', 'TRANSACTION_UOM');
1428: add_error(p_txn_ids => enums,
1429: p_err_col => 'TRANSACTION_UOM',
1430: p_err_msg => fnd_message.get);
1431:
1432: END transaction_uom;
1433:
1434: -- validate overcompletion_transaction_qty. This is an optional info.

Line 1454: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');

1450: AND wmti.overcompletion_transaction_qty IS NOT NULL
1451: AND wmti.overcompletion_transaction_qty <= 0
1452: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1453:
1454: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1455: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_TRANSACTION_QTY');
1456: fnd_message.set_token('ENTITY2', 'zero');
1457: add_error(p_txn_ids => enums,
1458: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',

Line 1455: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_TRANSACTION_QTY');

1451: AND wmti.overcompletion_transaction_qty <= 0
1452: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1453:
1454: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1455: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_TRANSACTION_QTY');
1456: fnd_message.set_token('ENTITY2', 'zero');
1457: add_error(p_txn_ids => enums,
1458: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1459: p_err_msg => fnd_message.get);

Line 1456: fnd_message.set_token('ENTITY2', 'zero');

1452: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1453:
1454: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1455: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_TRANSACTION_QTY');
1456: fnd_message.set_token('ENTITY2', 'zero');
1457: add_error(p_txn_ids => enums,
1458: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1459: p_err_msg => fnd_message.get);
1460:

Line 1459: p_err_msg => fnd_message.get);

1455: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_TRANSACTION_QTY');
1456: fnd_message.set_token('ENTITY2', 'zero');
1457: add_error(p_txn_ids => enums,
1458: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1459: p_err_msg => fnd_message.get);
1460:
1461: -- reset enums table
1462: enums.delete;
1463: -- Error out if OVERCOMPLETION_TRANSACTION_QTY is greater than

Line 1474: fnd_message.set_name('MFG', 'MFG_GREATER_OR_EQUAL');

1470: AND wmti.overcompletion_transaction_qty IS NOT NULL
1471: AND wmti.overcompletion_transaction_qty > wmti.transaction_quantity
1472: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1473:
1474: fnd_message.set_name('MFG', 'MFG_GREATER_OR_EQUAL');
1475: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1476: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
1477: add_error(p_txn_ids => enums,
1478: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',

Line 1475: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');

1471: AND wmti.overcompletion_transaction_qty > wmti.transaction_quantity
1472: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1473:
1474: fnd_message.set_name('MFG', 'MFG_GREATER_OR_EQUAL');
1475: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1476: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
1477: add_error(p_txn_ids => enums,
1478: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1479: p_err_msg => fnd_message.get);

Line 1476: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');

1472: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1473:
1474: fnd_message.set_name('MFG', 'MFG_GREATER_OR_EQUAL');
1475: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1476: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
1477: add_error(p_txn_ids => enums,
1478: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1479: p_err_msg => fnd_message.get);
1480:

Line 1479: p_err_msg => fnd_message.get);

1475: fnd_message.set_token('ENTITY1', 'TRANSACTION_QUANTITY');
1476: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
1477: add_error(p_txn_ids => enums,
1478: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1479: p_err_msg => fnd_message.get);
1480:
1481: -- reset enums table
1482: enums.delete;
1483: -- Error out if user try to do over Return

Line 1493: fnd_message.set_name('WIP', 'WIP_NO_OC_RET');

1489: AND wmti.transaction_type = WIP_CONSTANTS.RET_TXN
1490: AND wmti.overcompletion_transaction_qty IS NOT NULL
1491: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1492:
1493: fnd_message.set_name('WIP', 'WIP_NO_OC_RET');
1494: add_error(p_txn_ids => enums,
1495: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1496: p_err_msg => fnd_message.get);
1497:

Line 1496: p_err_msg => fnd_message.get);

1492:
1493: fnd_message.set_name('WIP', 'WIP_NO_OC_RET');
1494: add_error(p_txn_ids => enums,
1495: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1496: p_err_msg => fnd_message.get);
1497:
1498: -- reset enums table
1499: enums.delete;
1500: -- Error out if user try to do over Return from Scrap/Return from Reject

Line 1511: fnd_message.set_name('WIP', 'WIP_NO_OC_SCR_REJ');

1507: WIP_CONSTANTS.REJECT)
1508: AND wmti.overcompletion_transaction_qty IS NOT NULL
1509: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1510:
1511: fnd_message.set_name('WIP', 'WIP_NO_OC_SCR_REJ');
1512: add_error(p_txn_ids => enums,
1513: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1514: p_err_msg => fnd_message.get);
1515:

Line 1514: p_err_msg => fnd_message.get);

1510:
1511: fnd_message.set_name('WIP', 'WIP_NO_OC_SCR_REJ');
1512: add_error(p_txn_ids => enums,
1513: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1514: p_err_msg => fnd_message.get);
1515:
1516: -- reset enums table
1517: enums.delete;
1518: -- Error out if OVERCOMPLETION_TRANSACTION_QTY is specified for backward

Line 1532: fnd_message.set_name('WIP', 'WIP_NO_OC_REV_MOVE');

1528: wmti.fm_intraoperation_step_type))
1529: AND wmti.overcompletion_transaction_qty IS NOT NULL
1530: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1531:
1532: fnd_message.set_name('WIP', 'WIP_NO_OC_REV_MOVE');
1533: add_error(p_txn_ids => enums,
1534: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1535: p_err_msg => fnd_message.get);
1536:

Line 1535: p_err_msg => fnd_message.get);

1531:
1532: fnd_message.set_name('WIP', 'WIP_NO_OC_REV_MOVE');
1533: add_error(p_txn_ids => enums,
1534: p_err_col => 'OVERCOMPLETION_TRANSACTION_QTY',
1535: p_err_msg => fnd_message.get);
1536:
1537: END ocpl_txn_qty;
1538:
1539: -- validate transaction_id against the one in WIP_MOVE_TRANSACTIONS, and

Line 1553: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

1549: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1550: AND wmti.transaction_id IS NULL;
1551:
1552: -- Set Error Message
1553: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1554: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
1555: l_errMsg := substrb(fnd_message.get, 1, 240);
1556:
1557: INSERT INTO wip_txn_interface_errors(

Line 1554: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');

1550: AND wmti.transaction_id IS NULL;
1551:
1552: -- Set Error Message
1553: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1554: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
1555: l_errMsg := substrb(fnd_message.get, 1, 240);
1556:
1557: INSERT INTO wip_txn_interface_errors(
1558: transaction_id,

Line 1555: l_errMsg := substrb(fnd_message.get, 1, 240);

1551:
1552: -- Set Error Message
1553: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1554: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
1555: l_errMsg := substrb(fnd_message.get, 1, 240);
1556:
1557: INSERT INTO wip_txn_interface_errors(
1558: transaction_id,
1559: error_message,

Line 1739: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');

1735:
1736: /* End of bug fix 5000113.
1737:
1738: -- Set Error Message
1739: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1740: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1741: fnd_message.set_token('ENTITY2', 'zero');
1742: l_errMsg := substrb(fnd_message.get, 1, 240);
1743:

Line 1740: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');

1736: /* End of bug fix 5000113.
1737:
1738: -- Set Error Message
1739: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1740: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1741: fnd_message.set_token('ENTITY2', 'zero');
1742: l_errMsg := substrb(fnd_message.get, 1, 240);
1743:
1744: -- Error out if PRIMARY_QUANTITY is zero

Line 1741: fnd_message.set_token('ENTITY2', 'zero');

1737:
1738: -- Set Error Message
1739: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1740: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1741: fnd_message.set_token('ENTITY2', 'zero');
1742: l_errMsg := substrb(fnd_message.get, 1, 240);
1743:
1744: -- Error out if PRIMARY_QUANTITY is zero
1745: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update

Line 1742: l_errMsg := substrb(fnd_message.get, 1, 240);

1738: -- Set Error Message
1739: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
1740: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1741: fnd_message.set_token('ENTITY2', 'zero');
1742: l_errMsg := substrb(fnd_message.get, 1, 240);
1743:
1744: -- Error out if PRIMARY_QUANTITY is zero
1745: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1746: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will

Line 1781: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');

1777: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1778: AND wmti.primary_quantity = 0;
1779:
1780: -- Set Error Message
1781: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1782: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1783: fnd_message.set_token('ENTITY2', 'TRANSACTION_QUANTITY');
1784: l_errMsg := substrb(fnd_message.get, 1, 240);
1785:

Line 1782: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');

1778: AND wmti.primary_quantity = 0;
1779:
1780: -- Set Error Message
1781: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1782: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1783: fnd_message.set_token('ENTITY2', 'TRANSACTION_QUANTITY');
1784: l_errMsg := substrb(fnd_message.get, 1, 240);
1785:
1786: -- Error out if PRIMARY_QUANTITY is not consistent with TRANSACTION_QUANTITY

Line 1783: fnd_message.set_token('ENTITY2', 'TRANSACTION_QUANTITY');

1779:
1780: -- Set Error Message
1781: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1782: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1783: fnd_message.set_token('ENTITY2', 'TRANSACTION_QUANTITY');
1784: l_errMsg := substrb(fnd_message.get, 1, 240);
1785:
1786: -- Error out if PRIMARY_QUANTITY is not consistent with TRANSACTION_QUANTITY
1787: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update

Line 1784: l_errMsg := substrb(fnd_message.get, 1, 240);

1780: -- Set Error Message
1781: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1782: fnd_message.set_token('ENTITY1', 'PRIMARY_QUANTITY');
1783: fnd_message.set_token('ENTITY2', 'TRANSACTION_QUANTITY');
1784: l_errMsg := substrb(fnd_message.get, 1, 240);
1785:
1786: -- Error out if PRIMARY_QUANTITY is not consistent with TRANSACTION_QUANTITY
1787: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
1788: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will

Line 1836: fnd_message.set_name('WIP', 'WIP_MIN_XFER_QTY');

1832: condition
1833: */
1834:
1835: /*
1836: fnd_message.set_name('WIP', 'WIP_MIN_XFER_QTY');
1837: l_errMsg := substrb(fnd_message.get, 1, 240);
1838:
1839: -- Error out if PRIMARY_QUANTITY less than MININUM_TRANSFER_QUANTITY
1840: -- defined at FM_OPERATION_SEQ_NUM and transactions are not Scrap/Reject

Line 1837: l_errMsg := substrb(fnd_message.get, 1, 240);

1833: */
1834:
1835: /*
1836: fnd_message.set_name('WIP', 'WIP_MIN_XFER_QTY');
1837: l_errMsg := substrb(fnd_message.get, 1, 240);
1838:
1839: -- Error out if PRIMARY_QUANTITY less than MININUM_TRANSFER_QUANTITY
1840: -- defined at FM_OPERATION_SEQ_NUM and transactions are not Scrap/Reject
1841: INSERT INTO wip_txn_interface_errors(

Line 1886: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');

1882:
1883:
1884: */
1885: -- Set Error Message
1886: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
1887: l_errMsg := substrb(fnd_message.get, 1, 240);
1888:
1889: -- User cannot do easy return more than available quantity if
1890: -- organization do not allow negative balance. (Discrete/OSFM)

Line 1887: l_errMsg := substrb(fnd_message.get, 1, 240);

1883:
1884: */
1885: -- Set Error Message
1886: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
1887: l_errMsg := substrb(fnd_message.get, 1, 240);
1888:
1889: -- User cannot do easy return more than available quantity if
1890: -- organization do not allow negative balance. (Discrete/OSFM)
1891: FOR l_availQty IN c_availQty

Line 1995: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');

1991: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1992: AND wmti.primary_uom IS NULL;
1993:
1994: -- Set Error Message
1995: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1996: fnd_message.set_token('ENTITY1', 'PRIMARY_UOM');
1997: fnd_message.set_token('ENTITY2', 'PRIMARY_ITEM_ID');
1998: l_errMsg := substrb(fnd_message.get, 1, 240);
1999:

Line 1996: fnd_message.set_token('ENTITY1', 'PRIMARY_UOM');

1992: AND wmti.primary_uom IS NULL;
1993:
1994: -- Set Error Message
1995: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1996: fnd_message.set_token('ENTITY1', 'PRIMARY_UOM');
1997: fnd_message.set_token('ENTITY2', 'PRIMARY_ITEM_ID');
1998: l_errMsg := substrb(fnd_message.get, 1, 240);
1999:
2000: -- If caller provide PRIMARY_UOM, it must be consistent with

Line 1997: fnd_message.set_token('ENTITY2', 'PRIMARY_ITEM_ID');

1993:
1994: -- Set Error Message
1995: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1996: fnd_message.set_token('ENTITY1', 'PRIMARY_UOM');
1997: fnd_message.set_token('ENTITY2', 'PRIMARY_ITEM_ID');
1998: l_errMsg := substrb(fnd_message.get, 1, 240);
1999:
2000: -- If caller provide PRIMARY_UOM, it must be consistent with
2001: -- primary_item_id provided

Line 1998: l_errMsg := substrb(fnd_message.get, 1, 240);

1994: -- Set Error Message
1995: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
1996: fnd_message.set_token('ENTITY1', 'PRIMARY_UOM');
1997: fnd_message.set_token('ENTITY2', 'PRIMARY_ITEM_ID');
1998: l_errMsg := substrb(fnd_message.get, 1, 240);
1999:
2000: -- If caller provide PRIMARY_UOM, it must be consistent with
2001: -- primary_item_id provided
2002: INSERT INTO wip_txn_interface_errors(

Line 2068: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');

2064:
2065: -- End of bug fix 5000113.
2066:
2067: -- Set Error Message
2068: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
2069: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2070: fnd_message.set_token('ENTITY2', 'zero');
2071: l_errMsg := substrb(fnd_message.get, 1, 240);
2072:

Line 2069: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');

2065: -- End of bug fix 5000113.
2066:
2067: -- Set Error Message
2068: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
2069: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2070: fnd_message.set_token('ENTITY2', 'zero');
2071: l_errMsg := substrb(fnd_message.get, 1, 240);
2072:
2073: -- Error out if OVERCOMPLETION_PRIMARY_QTY is zero

Line 2070: fnd_message.set_token('ENTITY2', 'zero');

2066:
2067: -- Set Error Message
2068: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
2069: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2070: fnd_message.set_token('ENTITY2', 'zero');
2071: l_errMsg := substrb(fnd_message.get, 1, 240);
2072:
2073: -- Error out if OVERCOMPLETION_PRIMARY_QTY is zero
2074: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update

Line 2071: l_errMsg := substrb(fnd_message.get, 1, 240);

2067: -- Set Error Message
2068: fnd_message.set_name('MFG', 'MFG_GREATER_THAN');
2069: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2070: fnd_message.set_token('ENTITY2', 'zero');
2071: l_errMsg := substrb(fnd_message.get, 1, 240);
2072:
2073: -- Error out if OVERCOMPLETION_PRIMARY_QTY is zero
2074: -- Insert error record into WIP_TXN_INTERFACE_ERRORS. Do not update
2075: -- WMTI.PROCESS_STATUS to Error because it is a minor issue. We will

Line 2110: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');

2106: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2107: AND wmti.overcompletion_primary_qty = 0;
2108:
2109: -- Set Error Message
2110: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2111: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2112: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
2113: l_errMsg := substrb(fnd_message.get, 1, 240);
2114:

Line 2111: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');

2107: AND wmti.overcompletion_primary_qty = 0;
2108:
2109: -- Set Error Message
2110: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2111: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2112: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
2113: l_errMsg := substrb(fnd_message.get, 1, 240);
2114:
2115: -- If caller provide this info, it must be consistent with

Line 2112: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');

2108:
2109: -- Set Error Message
2110: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2111: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2112: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
2113: l_errMsg := substrb(fnd_message.get, 1, 240);
2114:
2115: -- If caller provide this info, it must be consistent with
2116: -- overcompletion_transaction_qty provided

Line 2113: l_errMsg := substrb(fnd_message.get, 1, 240);

2109: -- Set Error Message
2110: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2111: fnd_message.set_token('ENTITY1', 'OVERCOMPLETION_PRIMARY_QTY');
2112: fnd_message.set_token('ENTITY2', 'OVERCOMPLETION_TRANSACTION_QTY');
2113: l_errMsg := substrb(fnd_message.get, 1, 240);
2114:
2115: -- If caller provide this info, it must be consistent with
2116: -- overcompletion_transaction_qty provided
2117: INSERT INTO wip_txn_interface_errors(

Line 2166: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

2162: PROCEDURE ocpl_txn_id IS
2163: l_errMsg VARCHAR2(240);
2164: BEGIN
2165: -- Set Error Message
2166: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2167: fnd_message.set_token('ENTITY', 'OVERCOMPLETION_TRANSACTION_ID');
2168: l_errMsg := substrb(fnd_message.get, 1, 240);
2169:
2170: -- This value must be null because New Move Processor will be the one

Line 2167: fnd_message.set_token('ENTITY', 'OVERCOMPLETION_TRANSACTION_ID');

2163: l_errMsg VARCHAR2(240);
2164: BEGIN
2165: -- Set Error Message
2166: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2167: fnd_message.set_token('ENTITY', 'OVERCOMPLETION_TRANSACTION_ID');
2168: l_errMsg := substrb(fnd_message.get, 1, 240);
2169:
2170: -- This value must be null because New Move Processor will be the one
2171: -- who insert child record and populate this value

Line 2168: l_errMsg := substrb(fnd_message.get, 1, 240);

2164: BEGIN
2165: -- Set Error Message
2166: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2167: fnd_message.set_token('ENTITY', 'OVERCOMPLETION_TRANSACTION_ID');
2168: l_errMsg := substrb(fnd_message.get, 1, 240);
2169:
2170: -- This value must be null because New Move Processor will be the one
2171: -- who insert child record and populate this value
2172: INSERT INTO wip_txn_interface_errors(

Line 2227: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');

2223: AND wmti.reason_id IS NULL
2224: AND wmti.reason_name IS NOT NULL;
2225:
2226: -- Set Error Message
2227: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2228: fnd_message.set_token('ENTITY1', 'REASON_ID');
2229: fnd_message.set_token('ENTITY2', 'REASON_NAME');
2230: l_errMsg := substrb(fnd_message.get, 1, 240);
2231:

Line 2228: fnd_message.set_token('ENTITY1', 'REASON_ID');

2224: AND wmti.reason_name IS NOT NULL;
2225:
2226: -- Set Error Message
2227: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2228: fnd_message.set_token('ENTITY1', 'REASON_ID');
2229: fnd_message.set_token('ENTITY2', 'REASON_NAME');
2230: l_errMsg := substrb(fnd_message.get, 1, 240);
2231:
2232: -- If caller provide REASON_ID, it must be consistent with

Line 2229: fnd_message.set_token('ENTITY2', 'REASON_NAME');

2225:
2226: -- Set Error Message
2227: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2228: fnd_message.set_token('ENTITY1', 'REASON_ID');
2229: fnd_message.set_token('ENTITY2', 'REASON_NAME');
2230: l_errMsg := substrb(fnd_message.get, 1, 240);
2231:
2232: -- If caller provide REASON_ID, it must be consistent with
2233: -- REASON_NAME provided

Line 2230: l_errMsg := substrb(fnd_message.get, 1, 240);

2226: -- Set Error Message
2227: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2228: fnd_message.set_token('ENTITY1', 'REASON_ID');
2229: fnd_message.set_token('ENTITY2', 'REASON_NAME');
2230: l_errMsg := substrb(fnd_message.get, 1, 240);
2231:
2232: -- If caller provide REASON_ID, it must be consistent with
2233: -- REASON_NAME provided
2234: INSERT INTO wip_txn_interface_errors(

Line 2283: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

2279: l_scrap_flag NUMBER;
2280: l_errMsg VARCHAR2(240);
2281: BEGIN
2282: -- Set Error Message
2283: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2284: fnd_message.set_token('ENTITY', 'SCRAP_ACCOUNT_ID');
2285: l_errMsg := substrb(fnd_message.get, 1, 240);
2286:
2287: INSERT INTO wip_txn_interface_errors(

Line 2284: fnd_message.set_token('ENTITY', 'SCRAP_ACCOUNT_ID');

2280: l_errMsg VARCHAR2(240);
2281: BEGIN
2282: -- Set Error Message
2283: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2284: fnd_message.set_token('ENTITY', 'SCRAP_ACCOUNT_ID');
2285: l_errMsg := substrb(fnd_message.get, 1, 240);
2286:
2287: INSERT INTO wip_txn_interface_errors(
2288: transaction_id,

Line 2285: l_errMsg := substrb(fnd_message.get, 1, 240);

2281: BEGIN
2282: -- Set Error Message
2283: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2284: fnd_message.set_token('ENTITY', 'SCRAP_ACCOUNT_ID');
2285: l_errMsg := substrb(fnd_message.get, 1, 240);
2286:
2287: INSERT INTO wip_txn_interface_errors(
2288: transaction_id,
2289: error_message,

Line 2375: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');

2371: AND wmti.last_updated_by IS NULL
2372: AND wmti.last_updated_by_name IS NOT NULL;
2373:
2374: -- Set Error Message
2375: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2376: fnd_message.set_token('ENTITY1', 'LAST_UPDATED_BY');
2377: fnd_message.set_token('ENTITY2', 'LAST_UPDATED_BY_NAME');
2378: l_errMsg := substrb(fnd_message.get, 1, 240);
2379:

Line 2376: fnd_message.set_token('ENTITY1', 'LAST_UPDATED_BY');

2372: AND wmti.last_updated_by_name IS NOT NULL;
2373:
2374: -- Set Error Message
2375: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2376: fnd_message.set_token('ENTITY1', 'LAST_UPDATED_BY');
2377: fnd_message.set_token('ENTITY2', 'LAST_UPDATED_BY_NAME');
2378: l_errMsg := substrb(fnd_message.get, 1, 240);
2379:
2380: -- Error out if LAST_UPDATED_BY is not consistent with LAST_UPDATED_BY_NAME

Line 2377: fnd_message.set_token('ENTITY2', 'LAST_UPDATED_BY_NAME');

2373:
2374: -- Set Error Message
2375: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2376: fnd_message.set_token('ENTITY1', 'LAST_UPDATED_BY');
2377: fnd_message.set_token('ENTITY2', 'LAST_UPDATED_BY_NAME');
2378: l_errMsg := substrb(fnd_message.get, 1, 240);
2379:
2380: -- Error out if LAST_UPDATED_BY is not consistent with LAST_UPDATED_BY_NAME
2381: INSERT INTO wip_txn_interface_errors(

Line 2378: l_errMsg := substrb(fnd_message.get, 1, 240);

2374: -- Set Error Message
2375: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2376: fnd_message.set_token('ENTITY1', 'LAST_UPDATED_BY');
2377: fnd_message.set_token('ENTITY2', 'LAST_UPDATED_BY_NAME');
2378: l_errMsg := substrb(fnd_message.get, 1, 240);
2379:
2380: -- Error out if LAST_UPDATED_BY is not consistent with LAST_UPDATED_BY_NAME
2381: INSERT INTO wip_txn_interface_errors(
2382: transaction_id,

Line 2437: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');

2433: AND wmti.created_by IS NULL
2434: AND wmti.created_by_name IS NOT NULL;
2435:
2436: -- Set Error Message
2437: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2438: fnd_message.set_token('ENTITY1', 'CREATED_BY');
2439: fnd_message.set_token('ENTITY2', 'CREATED_BY_NAME');
2440: l_errMsg := substrb(fnd_message.get, 1, 240);
2441:

Line 2438: fnd_message.set_token('ENTITY1', 'CREATED_BY');

2434: AND wmti.created_by_name IS NOT NULL;
2435:
2436: -- Set Error Message
2437: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2438: fnd_message.set_token('ENTITY1', 'CREATED_BY');
2439: fnd_message.set_token('ENTITY2', 'CREATED_BY_NAME');
2440: l_errMsg := substrb(fnd_message.get, 1, 240);
2441:
2442: -- Error out if CREATED_BY is not consistent with CREATED_BY_NAME

Line 2439: fnd_message.set_token('ENTITY2', 'CREATED_BY_NAME');

2435:
2436: -- Set Error Message
2437: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2438: fnd_message.set_token('ENTITY1', 'CREATED_BY');
2439: fnd_message.set_token('ENTITY2', 'CREATED_BY_NAME');
2440: l_errMsg := substrb(fnd_message.get, 1, 240);
2441:
2442: -- Error out if CREATED_BY is not consistent with CREATED_BY_NAME
2443: INSERT INTO wip_txn_interface_errors(

Line 2440: l_errMsg := substrb(fnd_message.get, 1, 240);

2436: -- Set Error Message
2437: fnd_message.set_name('WIP', 'WIP_ID_CODE_COMBINATION');
2438: fnd_message.set_token('ENTITY1', 'CREATED_BY');
2439: fnd_message.set_token('ENTITY2', 'CREATED_BY_NAME');
2440: l_errMsg := substrb(fnd_message.get, 1, 240);
2441:
2442: -- Error out if CREATED_BY is not consistent with CREATED_BY_NAME
2443: INSERT INTO wip_txn_interface_errors(
2444: transaction_id,

Line 2495: fnd_message.set_name('WIP', 'WIP_PO_MOVE_LOCATION');

2491: PROCEDURE osp_validation IS
2492: l_errMsg VARCHAR2(240);
2493: BEGIN
2494: -- Set Error Message
2495: fnd_message.set_name('WIP', 'WIP_PO_MOVE_LOCATION');
2496: l_errMsg := substrb(fnd_message.get, 1, 240);
2497:
2498: -- Error out if user try to move into a queue of OSP operation and the
2499: -- department associated to that operation does not have a location

Line 2496: l_errMsg := substrb(fnd_message.get, 1, 240);

2492: l_errMsg VARCHAR2(240);
2493: BEGIN
2494: -- Set Error Message
2495: fnd_message.set_name('WIP', 'WIP_PO_MOVE_LOCATION');
2496: l_errMsg := substrb(fnd_message.get, 1, 240);
2497:
2498: -- Error out if user try to move into a queue of OSP operation and the
2499: -- department associated to that operation does not have a location
2500: -- for PO_RECEIVE. For PO_MOVE the department associated with

Line 2579: fnd_message.set_name('WIP', 'WIP_VALID_EMPLOYEE');

2575: AND wo2.department_id = bd.department_id
2576: AND bd.location_id IS NULL);
2577:
2578: -- Set Error Message
2579: fnd_message.set_name('WIP', 'WIP_VALID_EMPLOYEE');
2580: l_errMsg := substrb(fnd_message.get, 1, 240);
2581:
2582: -- Error out if the user who try to do OSP transaction is not an employee
2583: INSERT INTO wip_txn_interface_errors(

Line 2580: l_errMsg := substrb(fnd_message.get, 1, 240);

2576: AND bd.location_id IS NULL);
2577:
2578: -- Set Error Message
2579: fnd_message.set_name('WIP', 'WIP_VALID_EMPLOYEE');
2580: l_errMsg := substrb(fnd_message.get, 1, 240);
2581:
2582: -- Error out if the user who try to do OSP transaction is not an employee
2583: INSERT INTO wip_txn_interface_errors(
2584: transaction_id,

Line 2678: fnd_message.set_name('WIP', 'WIP_MOVE_CROSS_START_OP');

2674: (wmti.fm_operation_seq_num = wdj.serialization_start_op AND
2675: wmti.fm_intraoperation_step_type <> WIP_CONSTANTS.QUEUE)))))
2676: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2677:
2678: fnd_message.set_name('WIP', 'WIP_MOVE_CROSS_START_OP');
2679: add_error(p_txn_ids => enums,
2680: p_err_col => 'FM/TO_STEP, FM/TO_OP',
2681: p_err_msg => fnd_message.get);
2682:

Line 2681: p_err_msg => fnd_message.get);

2677:
2678: fnd_message.set_name('WIP', 'WIP_MOVE_CROSS_START_OP');
2679: add_error(p_txn_ids => enums,
2680: p_err_col => 'FM/TO_STEP, FM/TO_OP',
2681: p_err_msg => fnd_message.get);
2682:
2683: -- Comment out the validation below because Express Move can be done for more
2684: -- then one quantity. Moreover, this validation was already done through the
2685: -- UI(mobile and MES), and we do not support serilized move in the background.

Line 2710: fnd_message.set_name('WIP', 'WIP_INVALID_SERIAL_QTY');

2706: AND wmti.to_operation_seq_num >= wdj.serialization_start_op
2707: AND wmti.primary_quantity <> 1)
2708: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2709:
2710: fnd_message.set_name('WIP', 'WIP_INVALID_SERIAL_QTY');
2711: add_error(p_txn_ids => enums,
2712: p_err_col => 'TRANSACTION/PRIMARY_QUANTITY',
2713: p_err_msg => fnd_message.get);
2714: */

Line 2713: p_err_msg => fnd_message.get);

2709:
2710: fnd_message.set_name('WIP', 'WIP_INVALID_SERIAL_QTY');
2711: add_error(p_txn_ids => enums,
2712: p_err_col => 'TRANSACTION/PRIMARY_QUANTITY',
2713: p_err_msg => fnd_message.get);
2714: */
2715:
2716: -- reset enums table
2717: enums.delete;

Line 2747: fnd_message.set_name('WIP', 'WIP_SERIAL_INFO_NOT_ALLOW');

2743: FROM wip_serial_move_interface wsmi
2744: WHERE wsmi.transaction_id = wmti.transaction_id)
2745: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2746:
2747: fnd_message.set_name('WIP', 'WIP_SERIAL_INFO_NOT_ALLOW');
2748: add_error(p_txn_ids => enums,
2749: p_err_col => 'WSMI.ASSEMBLY_SERIAL_NUMBER',
2750: p_err_msg => fnd_message.get);
2751:

Line 2750: p_err_msg => fnd_message.get);

2746:
2747: fnd_message.set_name('WIP', 'WIP_SERIAL_INFO_NOT_ALLOW');
2748: add_error(p_txn_ids => enums,
2749: p_err_col => 'WSMI.ASSEMBLY_SERIAL_NUMBER',
2750: p_err_msg => fnd_message.get);
2751:
2752:
2753: -- reset enums table
2754: enums.delete;

Line 2801: fnd_message.set_name('WIP', 'WIP_SERIAL_QTY_MISSMATCH');

2797: mog.object_id = we.gen_object_id))
2798: AND mog.end_date_active IS NULL)
2799: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2800:
2801: fnd_message.set_name('WIP', 'WIP_SERIAL_QTY_MISSMATCH');
2802: add_error(p_txn_ids => enums,
2803: p_err_col => 'WSMI.ASSEMBLY_SERIAL_NUMBER',
2804: p_err_msg => fnd_message.get);
2805:

Line 2804: p_err_msg => fnd_message.get);

2800:
2801: fnd_message.set_name('WIP', 'WIP_SERIAL_QTY_MISSMATCH');
2802: add_error(p_txn_ids => enums,
2803: p_err_col => 'WSMI.ASSEMBLY_SERIAL_NUMBER',
2804: p_err_msg => fnd_message.get);
2805:
2806: -- reset enums table
2807: enums.delete;
2808: -- if user try to do serialized transaction, the status of the serial

Line 2846: fnd_message.set_name('WIP', 'WIP_INVALID_SERIAL_STATUS');

2842: msn.current_status IN (WIP_CONSTANTS.DEF_NOT_USED,
2843: WIP_CONSTANTS.OUT_OF_STORES))))
2844: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2845:
2846: fnd_message.set_name('WIP', 'WIP_INVALID_SERIAL_STATUS');
2847: add_error(p_txn_ids => enums,
2848: p_err_col => 'WSMI.ASSEMBLY_SERIAL_NUMBER',
2849: p_err_msg => fnd_message.get);
2850:

Line 2849: p_err_msg => fnd_message.get);

2845:
2846: fnd_message.set_name('WIP', 'WIP_INVALID_SERIAL_STATUS');
2847: add_error(p_txn_ids => enums,
2848: p_err_col => 'WSMI.ASSEMBLY_SERIAL_NUMBER',
2849: p_err_msg => fnd_message.get);
2850:
2851: END serial_validation;
2852:
2853: -- If there are some errors occur, this routine will set

Line 2903: fnd_message.set_name('INV', 'INV_INT_ITMEXP');

2899: AND (msi.inventory_item_flag = 'N' OR
2900: msi.mtl_transactions_enabled_flag = 'N'))
2901: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
2902:
2903: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2904: add_error(p_txn_ids => enums,
2905: p_err_col => 'PRIMARY_ITEM_ID',
2906: p_err_msg => fnd_message.get);
2907:

Line 2906: p_err_msg => fnd_message.get);

2902:
2903: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2904: add_error(p_txn_ids => enums,
2905: p_err_col => 'PRIMARY_ITEM_ID',
2906: p_err_msg => fnd_message.get);
2907:
2908: END assembly_validation;
2909:
2910:

Line 3199: fnd_message.set_name('WIP', 'WIP_NO_BALANCE');

3195: AND wpb.wip_entity_id = wmti.wip_entity_id
3196: AND wpb.organization_id = wmti.organization_id))
3197: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
3198:
3199: fnd_message.set_name('WIP', 'WIP_NO_BALANCE');
3200: add_error(p_txn_ids => enums,
3201: p_err_col => 'TRANSACTION_DATE',
3202: p_err_msg => fnd_message.get);
3203:

Line 3202: p_err_msg => fnd_message.get);

3198:
3199: fnd_message.set_name('WIP', 'WIP_NO_BALANCE');
3200: add_error(p_txn_ids => enums,
3201: p_err_col => 'TRANSACTION_DATE',
3202: p_err_msg => fnd_message.get);
3203:
3204: -- Fixed bug 5310474
3205: -- reset enums table
3206: enums.delete;

Line 3258: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');

3254: AND wsc.status_move_flag = WIP_CONSTANTS.NO
3255: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
3256: AND rownum = 1;
3257:
3258: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
3259: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3260: add_error(p_txn_id => enums(i),
3261: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
3262: p_err_msg => fnd_message.get);

Line 3259: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

3255: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
3256: AND rownum = 1;
3257:
3258: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
3259: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3260: add_error(p_txn_id => enums(i),
3261: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
3262: p_err_msg => fnd_message.get);
3263: end loop;

Line 3262: p_err_msg => fnd_message.get);

3258: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN1');
3259: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3260: add_error(p_txn_id => enums(i),
3261: p_err_col => 'FM_INTRAOPERATION_STEP_TYPE',
3262: p_err_msg => fnd_message.get);
3263: end loop;
3264: end if;
3265: -- reset enums table
3266: enums.delete;

Line 3310: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');

3306: AND wsc.status_move_flag = WIP_CONSTANTS.NO
3307: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
3308: and rownum = 1;
3309:
3310: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
3311: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3312: add_error(p_txn_id => enums(i),
3313: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
3314: p_err_msg => fnd_message.get);

Line 3311: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

3307: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE
3308: and rownum = 1;
3309:
3310: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
3311: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3312: add_error(p_txn_id => enums(i),
3313: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
3314: p_err_msg => fnd_message.get);
3315: end loop;

Line 3314: p_err_msg => fnd_message.get);

3310: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
3311: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3312: add_error(p_txn_id => enums(i),
3313: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
3314: p_err_msg => fnd_message.get);
3315: end loop;
3316: -- End of fix for bug 5310474
3317: end if;
3318:

Line 3359: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');

3355: into l_sf_status
3356: from wip_move_txn_interface wmti
3357: where wmti.transaction_id = enums(i)
3358: and wmti.process_status = WIP_CONSTANTS.ERROR;
3359: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
3360: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3361: add_error(p_txn_id => enums(i),
3362: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
3363: p_err_msg => fnd_message.get);

Line 3360: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

3356: from wip_move_txn_interface wmti
3357: where wmti.transaction_id = enums(i)
3358: and wmti.process_status = WIP_CONSTANTS.ERROR;
3359: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
3360: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3361: add_error(p_txn_id => enums(i),
3362: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
3363: p_err_msg => fnd_message.get);
3364: end loop;

Line 3363: p_err_msg => fnd_message.get);

3359: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
3360: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
3361: add_error(p_txn_id => enums(i),
3362: p_err_col => 'TO_INTRAOPERATION_STEP_TYPE',
3363: p_err_msg => fnd_message.get);
3364: end loop;
3365: end if;
3366:
3367: -- Do OSP related validation.