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.

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 744: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

740: else
741: FND_MSG_PUB.initialize;
742:
743: IF p_Kanban_Card_Id is NULL THEN
744: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
746: FND_MSG_PUB.Add;
747: l_return_status := FND_API.G_RET_STS_ERROR;
748: ELSIF p_supply_status is null THEN

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

741: FND_MSG_PUB.initialize;
742:
743: IF p_Kanban_Card_Id is NULL THEN
744: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
746: FND_MSG_PUB.Add;
747: l_return_status := FND_API.G_RET_STS_ERROR;
748: ELSIF p_supply_status is null THEN
749: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

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

745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_KANBAN_CARD');
746: FND_MSG_PUB.Add;
747: l_return_status := FND_API.G_RET_STS_ERROR;
748: ELSIF p_supply_status is null THEN
749: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');
751: FND_MSG_PUB.Add;
752: l_return_status := FND_API.G_RET_STS_ERROR;
753: ELSE

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

746: FND_MSG_PUB.Add;
747: l_return_status := FND_API.G_RET_STS_ERROR;
748: ELSIF p_supply_status is null THEN
749: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_SUPPLY_STATUS');
751: FND_MSG_PUB.Add;
752: l_return_status := FND_API.G_RET_STS_ERROR;
753: ELSE
754:

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

767: mydebug('Lock accuired for kanban card');
768: EXCEPTION
769: WHEN OTHERS THEN
770: l_return_status := FND_API.G_RET_STS_ERROR;
771: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_LOCK_KANBAN_CARD');
772: FND_MSG_PUB.ADD;
773: END;
774:
775: IF l_return_status = FND_API.g_ret_sts_error THEN

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

775: IF l_return_status = FND_API.g_ret_sts_error THEN
776: NULL;
777: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Hold ) THEN
778: l_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_HOLD_CARD');
780: FND_MSG_PUB.ADD;
781: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
782: l_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');

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

779: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_HOLD_CARD');
780: FND_MSG_PUB.ADD;
781: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Cancel ) then
782: l_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
784: FND_MSG_PUB.ADD;
785: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Planned ) then
786: l_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');

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

783: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
784: FND_MSG_PUB.ADD;
785: ELSIF (l_kanban_card_rec.card_status = G_Card_Status_Planned ) then
786: l_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
788: FND_MSG_PUB.ADD;
789: --Bug 3288422 fix.
790: ELSE
791: IF INV_KanbanCard_PKG.Supply_Status_Change_OK

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

830: If l_kanban_card_rec.card_status in
831: (INV_Kanban_PVT.G_Card_Status_Cancel,
832: INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned)
833: then
834: FND_MESSAGE.SET_TOKEN('CARD_NUMBER',l_kanban_card_rec.kanban_card_number);
835: End If;
836: l_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Add;
838: END IF;--IF INV_KanbanCard_PKG.Supply_Status_Change_OK

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

1271: if Valid_Kanban_Cards_exist(p_pull_sequence_id)
1272: then
1273: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1274: l_item_name,l_subinventory,l_loc_name);
1275: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1276: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1277: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1278: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1279: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

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

1272: then
1273: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1274: l_item_name,l_subinventory,l_loc_name);
1275: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1276: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1277: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1278: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1279: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1280: return false;

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

1273: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1274: l_item_name,l_subinventory,l_loc_name);
1275: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1276: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1277: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1278: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1279: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1280: return false;
1281: end if;

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

1274: l_item_name,l_subinventory,l_loc_name);
1275: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1276: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1277: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1278: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1279: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1280: return false;
1281: end if;
1282: return TRUE;

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

1275: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_CARDS_EXIST');
1276: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1277: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1278: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1279: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1280: return false;
1281: end if;
1282: return TRUE;
1283:

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

1302: if Valid_Kanban_Cards_exist(p_pull_sequence_id)
1303: then
1304: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1305: l_item_name,l_subinventory,l_loc_name);
1306: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1307: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1308: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1309: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1310: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

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

1303: then
1304: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1305: l_item_name,l_subinventory,l_loc_name);
1306: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1307: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1308: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1309: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1310: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1311: return false;

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

1304: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,
1305: l_item_name,l_subinventory,l_loc_name);
1306: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1307: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1308: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1309: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1310: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1311: return false;
1312: end if;

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

1305: l_item_name,l_subinventory,l_loc_name);
1306: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1307: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1308: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1309: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1310: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1311: return false;
1312: end if;
1313: return TRUE;

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

1306: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_DELETE_PULLSEQ');
1307: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1308: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1309: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_subinventory);
1310: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1311: return false;
1312: end if;
1313: return TRUE;
1314:

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

1390: from mtl_kanban_cards
1391: where kanban_card_id = p_kanban_id;
1392: exception
1393: When NO_DATA_FOUND then
1394: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');
1395: FND_MESSAGE.SET_TOKEN('CARDID',to_char(p_kanban_id) );
1396: RETURN FALSE;
1397: When OTHERS then
1398: FND_MSG_PUB.Add_Exc_Msg

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

1391: where kanban_card_id = p_kanban_id;
1392: exception
1393: When NO_DATA_FOUND then
1394: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_CARD_NOT_FOUND');
1395: FND_MESSAGE.SET_TOKEN('CARDID',to_char(p_kanban_id) );
1396: RETURN FALSE;
1397: When OTHERS then
1398: FND_MSG_PUB.Add_Exc_Msg
1399: ( G_PKG_NAME

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

1408:
1409: if ( (l_item_id = p_inv_item_id) AND (l_org_id = p_org_id) ) then
1410: l_proceed := 'Y';
1411: else
1412: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1413: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1414: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1415: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1416: RETURN FALSE;

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

1409: if ( (l_item_id = p_inv_item_id) AND (l_org_id = p_org_id) ) then
1410: l_proceed := 'Y';
1411: else
1412: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1413: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1414: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1415: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1416: RETURN FALSE;
1417: end if;

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

1410: l_proceed := 'Y';
1411: else
1412: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1413: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1414: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1415: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1416: RETURN FALSE;
1417: end if;
1418: if ( ( l_subinventory = p_subinventory ) AND

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

1411: else
1412: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_ITEM_ORG');
1413: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1414: FND_MESSAGE.SET_TOKEN('ORG_CODE',x_org_code );
1415: FND_MESSAGE.SET_TOKEN('ITEM',x_item_name );
1416: RETURN FALSE;
1417: end if;
1418: if ( ( l_subinventory = p_subinventory ) AND
1419: ( l_loc_id = nvl(p_locator_id,l_loc_id)) ) then

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

1418: if ( ( l_subinventory = p_subinventory ) AND
1419: ( l_loc_id = nvl(p_locator_id,l_loc_id)) ) then
1420: l_proceed := 'Y';
1421: else
1422: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1423: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1424: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1425: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1426: RETURN FALSE;

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

1419: ( l_loc_id = nvl(p_locator_id,l_loc_id)) ) then
1420: l_proceed := 'Y';
1421: else
1422: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1423: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1424: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1425: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1426: RETURN FALSE;
1427: end if;

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

1420: l_proceed := 'Y';
1421: else
1422: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1423: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1424: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1425: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1426: RETURN FALSE;
1427: end if;
1428: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then

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

1421: else
1422: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_CMPL_DEST');
1423: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1424: FND_MESSAGE.SET_TOKEN('SUB',p_subinventory);
1425: FND_MESSAGE.SET_TOKEN('LOC',x_loc_name);
1426: RETURN FALSE;
1427: end if;
1428: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then
1429: l_proceed := 'Y';

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

1427: end if;
1428: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then
1429: l_proceed := 'Y';
1430: else
1431: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_NOT_PRODUCTION');
1432: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1433: RETURN FALSE;
1434: end if;
1435: if ( l_supply_status in (INV_KANBAN_PVT.G_Supply_Status_Empty,

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

1428: if ( l_source_type = INV_KANBAN_PVT.G_Source_Type_Production ) then
1429: l_proceed := 'Y';
1430: else
1431: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_NOT_PRODUCTION');
1432: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1433: RETURN FALSE;
1434: end if;
1435: if ( l_supply_status in (INV_KANBAN_PVT.G_Supply_Status_Empty,
1436: INV_KANBAN_PVT.G_Supply_Status_InProcess ) ) then

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

1448: Raise Too_many_rows;
1449:
1450: exception
1451: When No_data_found Then
1452: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_SUP_STATUS');
1453: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1454: return FALSE;
1455: When Too_many_rows Then
1456: return TRUE;

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

1449:
1450: exception
1451: When No_data_found Then
1452: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_INVALID_SUP_STATUS');
1453: FND_MESSAGE.SET_TOKEN('CARD_NUM',x_kanban_num );
1454: return FALSE;
1455: When Too_many_rows Then
1456: return TRUE;
1457: When Others Then

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

1532: then
1533:
1534: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1535: l_item_name,l_subinventory,l_loc_name);
1536: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1537: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1538: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1539: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1540: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

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

1533:
1534: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1535: l_item_name,l_subinventory,l_loc_name);
1536: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1537: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1538: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1539: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1540: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1541: FND_MSG_PUB.Add;

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

1534: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1535: l_item_name,l_subinventory,l_loc_name);
1536: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1537: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1538: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1539: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1540: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1541: FND_MSG_PUB.Add;
1542:

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

1535: l_item_name,l_subinventory,l_loc_name);
1536: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1537: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1538: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1539: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1540: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1541: FND_MSG_PUB.Add;
1542:
1543: l_return_status := FND_API.G_RET_STS_ERROR;

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

1536: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1537: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1538: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1539: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1540: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1541: FND_MSG_PUB.Add;
1542:
1543: l_return_status := FND_API.G_RET_STS_ERROR;
1544:

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

1550: then
1551: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1552: l_item_name,l_subinventory,l_loc_name);
1553: end if;
1554: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1555: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1556: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1557: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1558: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

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

1551: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1552: l_item_name,l_subinventory,l_loc_name);
1553: end if;
1554: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1555: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1556: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1557: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1558: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1559: FND_MSG_PUB.Add;

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

1552: l_item_name,l_subinventory,l_loc_name);
1553: end if;
1554: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1555: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1556: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1557: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1558: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1559: FND_MSG_PUB.Add;
1560: l_return_status := FND_API.G_RET_STS_ERROR;

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

1553: end if;
1554: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1555: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1556: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1557: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1558: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1559: FND_MSG_PUB.Add;
1560: l_return_status := FND_API.G_RET_STS_ERROR;
1561:

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

1554: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1555: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1556: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1557: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1558: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1559: FND_MSG_PUB.Add;
1560: l_return_status := FND_API.G_RET_STS_ERROR;
1561:
1562: end if;

Line 1620: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');

1616: select 1 into l_temp
1617: from mtl_kanban_cards
1618: where organization_id = p_Pull_Sequence_Rec.Organization_id
1619: and kanban_card_number = l_Kanban_Card_Number;
1620: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');
1621: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card Number'||l_Kanban_Card_Number);
1622: l_error_msg := FND_MESSAGE.GET;
1623: FND_MSG_PUB.Add_Exc_Msg ( 'INV_Kanban_PVT',l_error_msg );
1624: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1621: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card Number'||l_Kanban_Card_Number);

1617: from mtl_kanban_cards
1618: where organization_id = p_Pull_Sequence_Rec.Organization_id
1619: and kanban_card_number = l_Kanban_Card_Number;
1620: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');
1621: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card Number'||l_Kanban_Card_Number);
1622: l_error_msg := FND_MESSAGE.GET;
1623: FND_MSG_PUB.Add_Exc_Msg ( 'INV_Kanban_PVT',l_error_msg );
1624: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1625: exception

Line 1622: l_error_msg := FND_MESSAGE.GET;

1618: where organization_id = p_Pull_Sequence_Rec.Organization_id
1619: and kanban_card_number = l_Kanban_Card_Number;
1620: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_EXISTS');
1621: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card Number'||l_Kanban_Card_Number);
1622: l_error_msg := FND_MESSAGE.GET;
1623: FND_MSG_PUB.Add_Exc_Msg ( 'INV_Kanban_PVT',l_error_msg );
1624: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1625: exception
1626: when others then

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

1777: then
1778:
1779: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1780: l_item_name,l_subinventory,l_loc_name);
1781: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1782: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1783: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1784: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1785: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

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

1778:
1779: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1780: l_item_name,l_subinventory,l_loc_name);
1781: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1782: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1783: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1784: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1785: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1786: FND_MSG_PUB.Add;

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

1779: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1780: l_item_name,l_subinventory,l_loc_name);
1781: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1782: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1783: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1784: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1785: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1786: FND_MSG_PUB.Add;
1787:

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

1780: l_item_name,l_subinventory,l_loc_name);
1781: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1782: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1783: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1784: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1785: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1786: FND_MSG_PUB.Add;
1787:
1788: l_return_status := FND_API.G_RET_STS_ERROR;

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

1781: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_NUM_CARDS');
1782: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1783: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1784: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1785: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1786: FND_MSG_PUB.Add;
1787:
1788: l_return_status := FND_API.G_RET_STS_ERROR;
1789:

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

1795: then
1796: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1797: l_item_name,l_subinventory,l_loc_name);
1798: end if;
1799: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1800: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1801: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1802: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1803: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);

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

1796: Get_Pull_sequence_Tokens(p_pull_sequence_rec.pull_sequence_id,l_org_code,
1797: l_item_name,l_subinventory,l_loc_name);
1798: end if;
1799: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1800: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1801: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1802: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1803: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1804: FND_MSG_PUB.Add;

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

1797: l_item_name,l_subinventory,l_loc_name);
1798: end if;
1799: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1800: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1801: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1802: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1803: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1804: FND_MSG_PUB.Add;
1805: l_return_status := FND_API.G_RET_STS_ERROR;

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

1798: end if;
1799: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1800: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1801: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1802: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1803: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1804: FND_MSG_PUB.Add;
1805: l_return_status := FND_API.G_RET_STS_ERROR;
1806:

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

1799: FND_MESSAGE.SET_NAME('INV','INV_CANT_GEN_CRDS_NO_KBN_SIZE');
1800: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_org_code);
1801: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_item_name);
1802: FND_MESSAGE.SET_TOKEN('SUB_CODE',l_Subinventory);
1803: FND_MESSAGE.SET_TOKEN('LOCATOR_NAME',l_loc_name);
1804: FND_MSG_PUB.Add;
1805: l_return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: end if;

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

2399: FROM Mtl_Txn_Request_Headers MTRH
2400: WHERE MTRH.Header_id = p_kanban_card_rec_tbl(1).document_header_id;
2401:
2402: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2403: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2404: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2405: FND_MSG_PUB.Add;
2406: ELSE
2407: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');

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

2400: WHERE MTRH.Header_id = p_kanban_card_rec_tbl(1).document_header_id;
2401:
2402: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2403: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2404: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2405: FND_MSG_PUB.Add;
2406: ELSE
2407: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2408: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);

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

2403: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
2404: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2405: FND_MSG_PUB.Add;
2406: ELSE
2407: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2408: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2409: FND_MSG_PUB.Add;
2410: END IF;
2411:

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

2404: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2405: FND_MSG_PUB.Add;
2406: ELSE
2407: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
2408: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
2409: FND_MSG_PUB.Add;
2410: END IF;
2411:
2412: END IF;

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

3279: and rownum < 2;
3280: p_Kanban_Card_Rec_Tbl(1).wip_line_id := v_wip_line_id;
3281: exception
3282: when NO_DATA_FOUND then
3283: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
3284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
3285: FND_MSG_PUB.Add;
3286: Raise FND_API.G_EXC_ERROR;
3287: when others then

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

3280: p_Kanban_Card_Rec_Tbl(1).wip_line_id := v_wip_line_id;
3281: exception
3282: when NO_DATA_FOUND then
3283: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
3284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INV_WIP_LINE');
3285: FND_MSG_PUB.Add;
3286: Raise FND_API.G_EXC_ERROR;
3287: when others then
3288: FND_MSG_PUB.Add_Exc_Msg

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

3659: WHEN NO_data_FOUND Then
3660:
3661: If l_sql_stmt_no = 10
3662: Then
3663: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM RECORD');
3664: Elsif l_sql_stmt_no = 20
3665: then
3666: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
3667: Elsif l_sql_stmt_no = 30

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

3662: Then
3663: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM RECORD');
3664: Elsif l_sql_stmt_no = 20
3665: then
3666: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
3667: Elsif l_sql_stmt_no = 30
3668: Then
3669: FND_MESSAGE.SET_NAME('INV','INV-NO CALENDAR DATE');
3670: Elsif l_sql_stmt_no = 40

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

3665: then
3666: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
3667: Elsif l_sql_stmt_no = 30
3668: Then
3669: FND_MESSAGE.SET_NAME('INV','INV-NO CALENDAR DATE');
3670: Elsif l_sql_stmt_no = 40
3671: Then
3672: FND_MESSAGE.SET_NAME('INV','INV_DEFAULT_DELIVERY_LOC_REQD');
3673: Elsif l_sql_stmt_no = 50

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

3668: Then
3669: FND_MESSAGE.SET_NAME('INV','INV-NO CALENDAR DATE');
3670: Elsif l_sql_stmt_no = 40
3671: Then
3672: FND_MESSAGE.SET_NAME('INV','INV_DEFAULT_DELIVERY_LOC_REQD');
3673: Elsif l_sql_stmt_no = 50
3674: Then
3675: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3676: Elsif l_sql_stmt_no = 60

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

3671: Then
3672: FND_MESSAGE.SET_NAME('INV','INV_DEFAULT_DELIVERY_LOC_REQD');
3673: Elsif l_sql_stmt_no = 50
3674: Then
3675: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3676: Elsif l_sql_stmt_no = 60
3677: Then
3678: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3679: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));

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

3674: Then
3675: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3676: Elsif l_sql_stmt_no = 60
3677: Then
3678: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3679: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3680: End If;
3681: FND_MSG_PUB.Add;
3682: Raise FND_API.G_EXC_ERROR;

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

3675: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
3676: Elsif l_sql_stmt_no = 60
3677: Then
3678: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
3679: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
3680: End If;
3681: FND_MSG_PUB.Add;
3682: Raise FND_API.G_EXC_ERROR;
3683:

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

4067: l_assembly_item_id NUMBER := p_inventory_item_id;
4068: l_organization_id NUMBER := p_organization_id;
4069: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4070: BEGIN
4071: --fnd_message.debug('Inside eligible');
4072:
4073: IF wsmpvers.get_osfm_release_version <= '110508' THEN
4074: RETURN 'N';
4075: ELSIF l_source_type_id = inv_kanban_pvt.g_source_type_production THEN

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

4122: ELSE --source_type <> production
4123: RETURN 'N';
4124: END IF;
4125:
4126: --fnd_message.debug(' end ');
4127:
4128: EXCEPTION
4129: WHEN OTHERS THEN
4130: RETURN 'N';