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.INV_KANBAN_PVT dependencies on FND_MESSAGE

Line 187: FND_MESSAGE.SET_NAME('INV','INV_ORG_REQUIRED');

183: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
184: Begin
185: if p_Pull_Sequence_Rec.Organization_Id is null
186: then
187: FND_MESSAGE.SET_NAME('INV','INV_ORG_REQUIRED');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization');
189: FND_MSG_PUB.Add;
190: Raise FND_API.G_EXC_ERROR;
191: End if;

Line 188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization');

184: Begin
185: if p_Pull_Sequence_Rec.Organization_Id is null
186: then
187: FND_MESSAGE.SET_NAME('INV','INV_ORG_REQUIRED');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization');
189: FND_MSG_PUB.Add;
190: Raise FND_API.G_EXC_ERROR;
191: End if;
192:

Line 195: FND_MESSAGE.SET_NAME('INV','INV_ITEM_REQUIRED');

191: End if;
192:
193: if p_Pull_Sequence_Rec.inventory_item_id is null
194: then
195: FND_MESSAGE.SET_NAME('INV','INV_ITEM_REQUIRED');
196: FND_MSG_PUB.Add;
197: Raise FND_API.G_EXC_ERROR;
198: end if;
199:

Line 202: FND_MESSAGE.SET_NAME('INV','INV_SUBINV_REQUIRED');

198: end if;
199:
200: if p_Pull_Sequence_Rec.subinventory_name is null
201: then
202: FND_MESSAGE.SET_NAME('INV','INV_SUBINV_REQUIRED');
203: FND_MSG_PUB.Add;
204: Raise FND_API.G_EXC_ERROR;
205: end if;
206:

Line 209: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

205: end if;
206:
207: if p_Pull_Sequence_Rec.source_type is null
208: then
209: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_TYPE',TRUE);
211: FND_MSG_PUB.Add;
212: Raise FND_API.G_EXC_ERROR;
213: end if;

Line 210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_TYPE',TRUE);

206:
207: if p_Pull_Sequence_Rec.source_type is null
208: then
209: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_TYPE',TRUE);
211: FND_MSG_PUB.Add;
212: Raise FND_API.G_EXC_ERROR;
213: end if;
214:

Line 217: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

213: end if;
214:
215: if p_Pull_Sequence_Rec.kanban_plan_id is null
216: then
217: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_PLAN',TRUE);
219: FND_MSG_PUB.Add;
220: Raise FND_API.G_EXC_ERROR;
221: end if;

Line 218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_PLAN',TRUE);

214:
215: if p_Pull_Sequence_Rec.kanban_plan_id is null
216: then
217: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_PLAN',TRUE);
219: FND_MSG_PUB.Add;
220: Raise FND_API.G_EXC_ERROR;
221: end if;
222:

Line 226: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

222:
223: if p_Pull_Sequence_Rec.source_type = INV_Kanban_PVT.G_Source_type_IntraOrg
224: And p_Pull_Sequence_Rec.source_subinventory is null
225: then
226: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_SUBINV',TRUE);
228: FND_MSG_PUB.Add;
229: Raise FND_API.G_EXC_ERROR;
230: end if;

Line 227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_SUBINV',TRUE);

223: if p_Pull_Sequence_Rec.source_type = INV_Kanban_PVT.G_Source_type_IntraOrg
224: And p_Pull_Sequence_Rec.source_subinventory is null
225: then
226: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SOURCE_SUBINV',TRUE);
228: FND_MSG_PUB.Add;
229: Raise FND_API.G_EXC_ERROR;
230: end if;
231:

Line 236: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

232: /*Code modification for bug2186198*/
233: /*if p_Pull_Sequence_Rec.source_type = INV_Kanban_PVT.G_Source_type_Production
234: And p_Pull_Sequence_Rec.wip_line_id is null
235: then
236: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
238: FND_MSG_PUB.Add;
239: Raise FND_API.G_EXC_ERROR;
240: end if; */

Line 237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');

233: /*if p_Pull_Sequence_Rec.source_type = INV_Kanban_PVT.G_Source_type_Production
234: And p_Pull_Sequence_Rec.wip_line_id is null
235: then
236: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
238: FND_MSG_PUB.Add;
239: Raise FND_API.G_EXC_ERROR;
240: end if; */
241:

Line 353: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

349: l_pull_Sequence_Rec.Inventory_Item_Id = FND_API.G_MISS_NUM or
350: l_pull_Sequence_Rec.Subinventory_Name is null or
351: l_pull_Sequence_Rec.Subinventory_Name = FND_API.G_MISS_CHAR )
352: then
353: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_PULL_SEQUENCE');
355: FND_MSG_PUB.Add;
356: l_return_status := FND_API.G_RET_STS_ERROR;
357:

Line 354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_PULL_SEQUENCE');

350: l_pull_Sequence_Rec.Subinventory_Name is null or
351: l_pull_Sequence_Rec.Subinventory_Name = FND_API.G_MISS_CHAR )
352: then
353: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_PULL_SEQUENCE');
355: FND_MSG_PUB.Add;
356: l_return_status := FND_API.G_RET_STS_ERROR;
357:
358: elsif (l_pull_Sequence_Rec.pull_sequence_Id is null or

Line 396: FND_MESSAGE.SET_NAME('INV','INV_NO_PULLSEQ_EXISTS');

392: l_Pull_Sequence_Rec.organization_id;
393:
394: end if;
395:
396: FND_MESSAGE.SET_NAME('INV','INV_NO_PULLSEQ_EXISTS');
397: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
398: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
399: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Pull_Sequence_Rec.Subinventory_Name);
400: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 397: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

393:
394: end if;
395:
396: FND_MESSAGE.SET_NAME('INV','INV_NO_PULLSEQ_EXISTS');
397: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
398: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
399: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Pull_Sequence_Rec.Subinventory_Name);
400: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
401: FND_MSG_PUB.Add;

Line 398: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

394: end if;
395:
396: FND_MESSAGE.SET_NAME('INV','INV_NO_PULLSEQ_EXISTS');
397: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
398: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
399: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Pull_Sequence_Rec.Subinventory_Name);
400: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
401: FND_MSG_PUB.Add;
402: l_return_status := FND_API.G_RET_STS_ERROR;

Line 399: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Pull_Sequence_Rec.Subinventory_Name);

395:
396: FND_MESSAGE.SET_NAME('INV','INV_NO_PULLSEQ_EXISTS');
397: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
398: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
399: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Pull_Sequence_Rec.Subinventory_Name);
400: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
401: FND_MSG_PUB.Add;
402: l_return_status := FND_API.G_RET_STS_ERROR;
403: When Others

Line 400: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

396: FND_MESSAGE.SET_NAME('INV','INV_NO_PULLSEQ_EXISTS');
397: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
398: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
399: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Pull_Sequence_Rec.Subinventory_Name);
400: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
401: FND_MSG_PUB.Add;
402: l_return_status := FND_API.G_RET_STS_ERROR;
403: When Others
404: Then

Line 619: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');

615: l_report_id );
616:
617: IF ( NVL(v_req_id, 0) <> 0) THEN
618: COMMIT;
619: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
620: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
621: fnd_message.set_token('PROCESS','INV_GENERATE_KANBAN_CARDS', TRUE);
622: FND_MSG_PUB.Add;
623: ELSE

Line 620: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);

616:
617: IF ( NVL(v_req_id, 0) <> 0) THEN
618: COMMIT;
619: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
620: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
621: fnd_message.set_token('PROCESS','INV_GENERATE_KANBAN_CARDS', TRUE);
622: FND_MSG_PUB.Add;
623: ELSE
624: fnd_message.set_name('INV','INV_PROCESS_FAILED');

Line 621: fnd_message.set_token('PROCESS','INV_GENERATE_KANBAN_CARDS', TRUE);

617: IF ( NVL(v_req_id, 0) <> 0) THEN
618: COMMIT;
619: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
620: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
621: fnd_message.set_token('PROCESS','INV_GENERATE_KANBAN_CARDS', TRUE);
622: FND_MSG_PUB.Add;
623: ELSE
624: fnd_message.set_name('INV','INV_PROCESS_FAILED');
625: fnd_message.set_token('PROCESS', 'INV_GENERATE_KANBAN_CARDS', TRUE);

Line 624: fnd_message.set_name('INV','INV_PROCESS_FAILED');

620: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
621: fnd_message.set_token('PROCESS','INV_GENERATE_KANBAN_CARDS', TRUE);
622: FND_MSG_PUB.Add;
623: ELSE
624: fnd_message.set_name('INV','INV_PROCESS_FAILED');
625: fnd_message.set_token('PROCESS', 'INV_GENERATE_KANBAN_CARDS', TRUE);
626: FND_MSG_PUB.Add;
627: RAISE FND_API.G_EXC_ERROR;
628: END IF;

Line 625: fnd_message.set_token('PROCESS', 'INV_GENERATE_KANBAN_CARDS', TRUE);

621: fnd_message.set_token('PROCESS','INV_GENERATE_KANBAN_CARDS', TRUE);
622: FND_MSG_PUB.Add;
623: ELSE
624: fnd_message.set_name('INV','INV_PROCESS_FAILED');
625: fnd_message.set_token('PROCESS', 'INV_GENERATE_KANBAN_CARDS', TRUE);
626: FND_MSG_PUB.Add;
627: RAISE FND_API.G_EXC_ERROR;
628: END IF;
629: END IF;

Line 663: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');

659: );
660:
661: IF ( NVL(v_req_id, 0) <> 0) THEN
662: COMMIT;
663: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
664: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
665: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);
666: FND_MSG_PUB.Add;
667: ELSE

Line 664: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);

660:
661: IF ( NVL(v_req_id, 0) <> 0) THEN
662: COMMIT;
663: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
664: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
665: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);
666: FND_MSG_PUB.Add;
667: ELSE
668: -- delete from MTL_KANBAN_CARD_PRINT_TEMP

Line 665: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);

661: IF ( NVL(v_req_id, 0) <> 0) THEN
662: COMMIT;
663: FND_MESSAGE.SET_NAME ('INV', 'INV_PROCESS');
664: Fnd_message.set_token('REQUEST_ID',to_char(v_req_id), FALSE);
665: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);
666: FND_MSG_PUB.Add;
667: ELSE
668: -- delete from MTL_KANBAN_CARD_PRINT_TEMP
669: -- where

Line 672: fnd_message.set_name('INV','INV_PROCESS_FAILED');

668: -- delete from MTL_KANBAN_CARD_PRINT_TEMP
669: -- where
670: -- report_id = l_report_id;
671: -- COMMIT;
672: fnd_message.set_name('INV','INV_PROCESS_FAILED');
673: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;

Line 673: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);

669: -- where
670: -- report_id = l_report_id;
671: -- COMMIT;
672: fnd_message.set_name('INV','INV_PROCESS_FAILED');
673: fnd_message.set_token('PROCESS', 'INV_PRINT_KANBAN_CARDS', TRUE);
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677: END IF;

Line 730: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

726: Begin
727: FND_MSG_PUB.initialize;
728:
729: IF p_Kanban_Card_Id is NULL THEN
730: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
732: FND_MSG_PUB.Add;
733: l_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_supply_status is null THEN

Line 731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');

727: FND_MSG_PUB.initialize;
728:
729: IF p_Kanban_Card_Id is NULL THEN
730: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
732: FND_MSG_PUB.Add;
733: l_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_supply_status is null THEN
735: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

Line 735: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
732: FND_MSG_PUB.Add;
733: l_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_supply_status is null THEN
735: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
736: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');
737: FND_MSG_PUB.Add;
738: l_return_status := FND_API.G_RET_STS_ERROR;
739: ELSE

Line 736: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');

732: FND_MSG_PUB.Add;
733: l_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_supply_status is null THEN
735: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
736: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');
737: FND_MSG_PUB.Add;
738: l_return_status := FND_API.G_RET_STS_ERROR;
739: ELSE
740:

Line 757: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_LOCK_KANBAN_CARD');

753: mydebug('Lock accuired for kanban card');
754: EXCEPTION
755: WHEN OTHERS THEN
756: l_return_status := FND_API.G_RET_STS_ERROR;
757: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_LOCK_KANBAN_CARD');
758: FND_MSG_PUB.ADD;
759: END;
760:
761: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 765: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_HOLD_CARD');

761: IF l_return_status = FND_API.g_ret_sts_error THEN
762: NULL;
763: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Hold ) THEN
764: l_return_status := FND_API.G_RET_STS_ERROR;
765: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_HOLD_CARD');
766: FND_MSG_PUB.ADD;
767: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
768: l_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');

Line 769: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');

765: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_HOLD_CARD');
766: FND_MSG_PUB.ADD;
767: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
768: l_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
770: FND_MSG_PUB.ADD;
771:
772: --Bug 3288422 fix.
773: ELSE

Line 815: FND_MESSAGE.SET_TOKEN('CARD_NUMBER',l_kanban_card_rec.kanban_card_number);

811: If l_kanban_card_rec.card_status in
812: (INV_Kanban_PVT.G_Card_Status_Cancel,
813: INV_Kanban_PVT.G_Card_Status_Hold)
814: then
815: FND_MESSAGE.SET_TOKEN('CARD_NUMBER',l_kanban_card_rec.kanban_card_number);
816: End If;
817: l_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Add;
819: END IF;--IF INV_KanbanCard_PKG.Supply_Status_Change_OK

Line 1254: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');

1250: if Valid_Kanban_Cards_exist(p_pull_sequence_id)
1251: then
1252: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1253: l_item_name,l_subinventory,l_loc_name);
1254: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1255: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1256: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1257: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1258: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 1255: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

1251: then
1252: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1253: l_item_name,l_subinventory,l_loc_name);
1254: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1255: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1256: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1257: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1258: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1259: return false;

Line 1256: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1252: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1253: l_item_name,l_subinventory,l_loc_name);
1254: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1255: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1256: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1257: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1258: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1259: return false;
1260: end if;

Line 1257: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);

1253: l_item_name,l_subinventory,l_loc_name);
1254: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1255: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1256: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1257: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1258: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1259: return false;
1260: end if;
1261: return TRUE;

Line 1258: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

1254: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1255: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1256: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1257: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1258: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1259: return false;
1260: end if;
1261: return TRUE;
1262:

Line 1285: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');

1281: if Valid_Kanban_Cards_exist(p_pull_sequence_id)
1282: then
1283: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1284: l_item_name,l_subinventory,l_loc_name);
1285: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1286: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1287: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1288: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1289: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 1286: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

1282: then
1283: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1284: l_item_name,l_subinventory,l_loc_name);
1285: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1286: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1287: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1288: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1289: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1290: return false;

Line 1287: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1283: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1284: l_item_name,l_subinventory,l_loc_name);
1285: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1286: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1287: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1288: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1289: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1290: return false;
1291: end if;

Line 1288: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);

1284: l_item_name,l_subinventory,l_loc_name);
1285: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1286: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1287: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1288: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1289: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1290: return false;
1291: end if;
1292: return TRUE;

Line 1289: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

1285: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1286: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1287: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1288: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1289: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1290: return false;
1291: end if;
1292: return TRUE;
1293:

Line 1373: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');

1369: from mtl_kanban_cards
1370: where kanban_card_id = p_kanban_id;
1371: exception
1372: When NO_DATA_FOUND then
1373: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');
1374: FND_MESSAGE.SET_TOKEN('CARDID',to_char(p_kanban_id) );
1375: RETURN FALSE;
1376: When OTHERS then
1377: FND_MSG_PUB.Add_Exc_Msg

Line 1374: FND_MESSAGE.SET_TOKEN('CARDID',to_char(p_kanban_id) );

1370: where kanban_card_id = p_kanban_id;
1371: exception
1372: When NO_DATA_FOUND then
1373: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');
1374: FND_MESSAGE.SET_TOKEN('CARDID',to_char(p_kanban_id) );
1375: RETURN FALSE;
1376: When OTHERS then
1377: FND_MSG_PUB.Add_Exc_Msg
1378: ( G_PKG_NAME

Line 1391: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');

1387:
1388: if ( (l_item_id = p_inv_item_id) AND (l_org_id = p_org_id) ) then
1389: l_proceed := 'Y';
1390: else
1391: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1392: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1393: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1394: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1395: RETURN FALSE;

Line 1392: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );

1388: if ( (l_item_id = p_inv_item_id) AND (l_org_id = p_org_id) ) then
1389: l_proceed := 'Y';
1390: else
1391: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1392: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1393: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1394: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1395: RETURN FALSE;
1396: end if;

Line 1393: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );

1389: l_proceed := 'Y';
1390: else
1391: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1392: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1393: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1394: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1395: RETURN FALSE;
1396: end if;
1397: if ( ( l_subinventory = p_subinventory ) AND

Line 1394: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );

1390: else
1391: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1392: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1393: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1394: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1395: RETURN FALSE;
1396: end if;
1397: if ( ( l_subinventory = p_subinventory ) AND
1398: ( l_loc_id = nvl(p_locator_id,l_loc_id)) ) then

Line 1401: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');

1397: if ( ( l_subinventory = p_subinventory ) AND
1398: ( l_loc_id = nvl(p_locator_id,l_loc_id)) ) then
1399: l_proceed := 'Y';
1400: else
1401: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1402: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1403: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1404: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1405: RETURN FALSE;

Line 1402: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );

1398: ( l_loc_id = nvl(p_locator_id,l_loc_id)) ) then
1399: l_proceed := 'Y';
1400: else
1401: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1402: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1403: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1404: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1405: RETURN FALSE;
1406: end if;

Line 1403: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);

1399: l_proceed := 'Y';
1400: else
1401: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1402: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1403: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1404: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1405: RETURN FALSE;
1406: end if;
1407: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then

Line 1404: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);

1400: else
1401: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1402: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1403: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1404: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1405: RETURN FALSE;
1406: end if;
1407: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then
1408: l_proceed := 'Y';

Line 1410: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_NOT_PRODUCTION');

1406: end if;
1407: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then
1408: l_proceed := 'Y';
1409: else
1410: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_NOT_PRODUCTION');
1411: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1412: RETURN FALSE;
1413: end if;
1414: if ( l_supply_status in (INV_KANBAN_PVT.G_Supply_Status_Empty,

Line 1411: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );

1407: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then
1408: l_proceed := 'Y';
1409: else
1410: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_NOT_PRODUCTION');
1411: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1412: RETURN FALSE;
1413: end if;
1414: if ( l_supply_status in (INV_KANBAN_PVT.G_Supply_Status_Empty,
1415: INV_KANBAN_PVT.G_Supply_Status_InProcess ) ) then

Line 1431: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_SUP_STATUS');

1427: Raise Too_many_rows;
1428:
1429: exception
1430: When No_data_found Then
1431: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_SUP_STATUS');
1432: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1433: return FALSE;
1434: When Too_many_rows Then
1435: return TRUE;

Line 1432: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );

1428:
1429: exception
1430: When No_data_found Then
1431: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_SUP_STATUS');
1432: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1433: return FALSE;
1434: When Too_many_rows Then
1435: return TRUE;
1436: When Others Then

Line 1511: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');

1507: then
1508:
1509: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1510: l_item_name,l_subinventory,l_loc_name);
1511: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1512: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1513: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1514: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1515: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 1512: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

1508:
1509: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1510: l_item_name,l_subinventory,l_loc_name);
1511: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1512: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1513: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1514: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1515: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1516: FND_MSG_PUB.Add;

Line 1513: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1509: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1510: l_item_name,l_subinventory,l_loc_name);
1511: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1512: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1513: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1514: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1515: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1516: FND_MSG_PUB.Add;
1517:

Line 1514: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);

1510: l_item_name,l_subinventory,l_loc_name);
1511: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1512: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1513: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1514: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1515: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1516: FND_MSG_PUB.Add;
1517:
1518: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1515: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

1511: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1512: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1513: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1514: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1515: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1516: FND_MSG_PUB.Add;
1517:
1518: l_return_status := FND_API.G_RET_STS_ERROR;
1519:

Line 1529: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');

1525: then
1526: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1527: l_item_name,l_subinventory,l_loc_name);
1528: end if;
1529: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1530: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1531: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1532: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1533: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

Line 1530: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);

1526: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1527: l_item_name,l_subinventory,l_loc_name);
1528: end if;
1529: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1530: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1531: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1532: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1533: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1534: FND_MSG_PUB.Add;

Line 1531: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);

1527: l_item_name,l_subinventory,l_loc_name);
1528: end if;
1529: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1530: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1531: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1532: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1533: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1534: FND_MSG_PUB.Add;
1535: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1532: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);

1528: end if;
1529: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1530: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1531: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1532: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1533: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1534: FND_MSG_PUB.Add;
1535: l_return_status := FND_API.G_RET_STS_ERROR;
1536:

Line 1533: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

1529: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1530: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1531: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1532: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1533: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1534: FND_MSG_PUB.Add;
1535: l_return_status := FND_API.G_RET_STS_ERROR;
1536:
1537: end if;

Line 2076: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');

2072: FROM Mtl_Txn_Request_Headers MTRH
2073: WHERE MTRH.Header_id = p_kanban_card_rec_tbl(1).document_header_id;
2074:
2075: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2076: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2077: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2078: FND_MSG_PUB.Add;
2079: ELSE
2080: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');

Line 2077: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);

2073: WHERE MTRH.Header_id = p_kanban_card_rec_tbl(1).document_header_id;
2074:
2075: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2076: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2077: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2078: FND_MSG_PUB.Add;
2079: ELSE
2080: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2081: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);

Line 2080: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');

2076: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2077: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2078: FND_MSG_PUB.Add;
2079: ELSE
2080: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2081: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2082: FND_MSG_PUB.Add;
2083: END IF;
2084:

Line 2081: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);

2077: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2078: FND_MSG_PUB.Add;
2079: ELSE
2080: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2081: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2082: FND_MSG_PUB.Add;
2083: END IF;
2084:
2085: END IF;

Line 2887: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

2883: and rownum < 2;
2884: p_Kanban_Card_Rec_Tbl(1).wip_line_id := v_wip_line_id;
2885: exception
2886: when NO_DATA_FOUND then
2887: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
2889: FND_MSG_PUB.Add;
2890: Raise FND_API.G_EXC_ERROR;
2891: when others then

Line 2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');

2884: p_Kanban_Card_Rec_Tbl(1).wip_line_id := v_wip_line_id;
2885: exception
2886: when NO_DATA_FOUND then
2887: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
2888: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
2889: FND_MSG_PUB.Add;
2890: Raise FND_API.G_EXC_ERROR;
2891: when others then
2892: FND_MSG_PUB.Add_Exc_Msg

Line 3264: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM RECORD');

3260: WHEN NO_data_FOUND Then
3261:
3262: If l_sql_stmt_no = 10
3263: Then
3264: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM RECORD');
3265: Elsif l_sql_stmt_no = 20
3266: then
3267: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
3268: Elsif l_sql_stmt_no = 30

Line 3267: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');

3263: Then
3264: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM RECORD');
3265: Elsif l_sql_stmt_no = 20
3266: then
3267: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
3268: Elsif l_sql_stmt_no = 30
3269: Then
3270: FND_MESSAGE.SET_NAME('INV','INV-NO CALENDAR DATE');
3271: Elsif l_sql_stmt_no = 40

Line 3270: FND_MESSAGE.SET_NAME('INV','INV-NO CALENDAR DATE');

3266: then
3267: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
3268: Elsif l_sql_stmt_no = 30
3269: Then
3270: FND_MESSAGE.SET_NAME('INV','INV-NO CALENDAR DATE');
3271: Elsif l_sql_stmt_no = 40
3272: Then
3273: FND_MESSAGE.SET_NAME('INV','INV_DEFAULT_DELIVERY_LOC_REQD');
3274: Elsif l_sql_stmt_no = 50

Line 3273: FND_MESSAGE.SET_NAME('INV','INV_DEFAULT_DELIVERY_LOC_REQD');

3269: Then
3270: FND_MESSAGE.SET_NAME('INV','INV-NO CALENDAR DATE');
3271: Elsif l_sql_stmt_no = 40
3272: Then
3273: FND_MESSAGE.SET_NAME('INV','INV_DEFAULT_DELIVERY_LOC_REQD');
3274: Elsif l_sql_stmt_no = 50
3275: Then
3276: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3277: Elsif l_sql_stmt_no = 60

Line 3276: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');

3272: Then
3273: FND_MESSAGE.SET_NAME('INV','INV_DEFAULT_DELIVERY_LOC_REQD');
3274: Elsif l_sql_stmt_no = 50
3275: Then
3276: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3277: Elsif l_sql_stmt_no = 60
3278: Then
3279: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3280: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));

Line 3279: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');

3275: Then
3276: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3277: Elsif l_sql_stmt_no = 60
3278: Then
3279: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3280: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3281: End If;
3282: FND_MSG_PUB.Add;
3283: Raise FND_API.G_EXC_ERROR;

Line 3280: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));

3276: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3277: Elsif l_sql_stmt_no = 60
3278: Then
3279: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3280: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3281: End If;
3282: FND_MSG_PUB.Add;
3283: Raise FND_API.G_EXC_ERROR;
3284:

Line 3670: --fnd_message.debug('Inside eligible');

3666: l_assembly_item_id NUMBER := p_inventory_item_id;
3667: l_organization_id NUMBER := p_organization_id;
3668: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3669: BEGIN
3670: --fnd_message.debug('Inside eligible');
3671:
3672: IF wsmpvers.get_osfm_release_version <= '110508' THEN
3673: RETURN 'N';
3674: ELSIF l_source_type_id = inv_kanban_pvt.g_source_type_production THEN

Line 3725: --fnd_message.debug(' end ');

3721: ELSE --source_type <> production
3722: RETURN 'N';
3723: END IF;
3724:
3725: --fnd_message.debug(' end ');
3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN
3729: RETURN 'N';