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

Line 76: fnd_message.set_name('FLM', 'FLM_INV_CARD_ORG_COMB');

72: IS
73: l_kanban_card_id number;
74: BEGIN
75: if P_KANBAN_CARD_NUM is null or P_ORG_CODE is null then
76: fnd_message.set_name('FLM', 'FLM_INV_CARD_ORG_COMB');
77: X_ERR_MSG := fnd_message.get;
78: X_RETCODE := 'E';
79: return;
80: end if;

Line 77: X_ERR_MSG := fnd_message.get;

73: l_kanban_card_id number;
74: BEGIN
75: if P_KANBAN_CARD_NUM is null or P_ORG_CODE is null then
76: fnd_message.set_name('FLM', 'FLM_INV_CARD_ORG_COMB');
77: X_ERR_MSG := fnd_message.get;
78: X_RETCODE := 'E';
79: return;
80: end if;
81:

Line 129: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN');

125: BEGIN
126:
127: if p_kanban_id is null then
128: -- Invalid parameters passed to supply status APIs.
129: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN');
130: X_ERR_MSG := fnd_message.get;
131: X_RETCODE := 'E';
132: return;
133: end if;

Line 130: X_ERR_MSG := fnd_message.get;

126:
127: if p_kanban_id is null then
128: -- Invalid parameters passed to supply status APIs.
129: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN');
130: X_ERR_MSG := fnd_message.get;
131: X_RETCODE := 'E';
132: return;
133: end if;
134:

Line 137: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');

133: end if;
134:
135: if p_card_status_to is null and p_supply_status_to is null then
136: -- Invalid parameters passed to supply status APIs.
137: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');
138: X_ERR_MSG := fnd_message.get;
139: X_RETCODE := 'E';
140: return;
141: end if;

Line 138: X_ERR_MSG := fnd_message.get;

134:
135: if p_card_status_to is null and p_supply_status_to is null then
136: -- Invalid parameters passed to supply status APIs.
137: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');
138: X_ERR_MSG := fnd_message.get;
139: X_RETCODE := 'E';
140: return;
141: end if;
142:

Line 148: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');

144:
145: if l_kanban_card_rec.supply_status = nvl(p_supply_status_to,l_kanban_card_rec.supply_status) and
146: l_kanban_card_rec.card_status = nvl(p_card_status_to,l_kanban_card_rec.card_status) then
147: -- Invalid parameters passed to supply status APIs.
148: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');
149: X_ERR_MSG := fnd_message.get;
150: X_RETCODE := 'E';
151: return;
152: end if;

Line 149: X_ERR_MSG := fnd_message.get;

145: if l_kanban_card_rec.supply_status = nvl(p_supply_status_to,l_kanban_card_rec.supply_status) and
146: l_kanban_card_rec.card_status = nvl(p_card_status_to,l_kanban_card_rec.card_status) then
147: -- Invalid parameters passed to supply status APIs.
148: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');
149: X_ERR_MSG := fnd_message.get;
150: X_RETCODE := 'E';
151: return;
152: end if;
153:

Line 320: fnd_message.set_name('FLM', 'FLM_EKB_PROFILE_DISABLED');

316: l_card_status_to := p_card_status_to;
317: l_supply_status_to := p_supply_status_to;
318: l_current_replnsh_cycle_id := p_current_replnsh_cycle_id;
319: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) <> 1 then
320: fnd_message.set_name('FLM', 'FLM_EKB_PROFILE_DISABLED');
321: X_ERR_MSG := fnd_message.get;
322: X_RETCODE := 'E';
323: return;
324: end if;

Line 321: X_ERR_MSG := fnd_message.get;

317: l_supply_status_to := p_supply_status_to;
318: l_current_replnsh_cycle_id := p_current_replnsh_cycle_id;
319: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) <> 1 then
320: fnd_message.set_name('FLM', 'FLM_EKB_PROFILE_DISABLED');
321: X_ERR_MSG := fnd_message.get;
322: X_RETCODE := 'E';
323: return;
324: end if;
325: if p_supply_status <> nvl(p_supply_status_to,p_supply_status) then

Line 327: fnd_message.set_name('FLM', 'FLM_INV_CARD_STATUS');

323: return;
324: end if;
325: if p_supply_status <> nvl(p_supply_status_to,p_supply_status) then
326: if validate_status_lookup(p_supply_status_to,p_organization_id) = 1 then
327: fnd_message.set_name('FLM', 'FLM_INV_CARD_STATUS');
328: X_ERR_MSG := fnd_message.get;
329: X_RETCODE := 'E';
330: return;
331: end if;

Line 328: X_ERR_MSG := fnd_message.get;

324: end if;
325: if p_supply_status <> nvl(p_supply_status_to,p_supply_status) then
326: if validate_status_lookup(p_supply_status_to,p_organization_id) = 1 then
327: fnd_message.set_name('FLM', 'FLM_INV_CARD_STATUS');
328: X_ERR_MSG := fnd_message.get;
329: X_RETCODE := 'E';
330: return;
331: end if;
332: if p_card_status in (INV_Kanban_PVT.G_Card_Status_Hold,

Line 336: fnd_message.set_name('FLM', 'FLM_INV_CARD_STS_FOR_STS_CHG');

332: if p_card_status in (INV_Kanban_PVT.G_Card_Status_Hold,
333: INV_Kanban_PVT.G_Card_Status_Cancel,
334: INV_Kanban_PVT.G_Card_Status_Planned) then
335: -- supply status cannot be modified for cards in active,on-hold,plan cards.
336: fnd_message.set_name('FLM', 'FLM_INV_CARD_STS_FOR_STS_CHG');
337: X_ERR_MSG := fnd_message.get;
338: X_RETCODE := 'E';
339: return;
340: end if;

Line 337: X_ERR_MSG := fnd_message.get;

333: INV_Kanban_PVT.G_Card_Status_Cancel,
334: INV_Kanban_PVT.G_Card_Status_Planned) then
335: -- supply status cannot be modified for cards in active,on-hold,plan cards.
336: fnd_message.set_name('FLM', 'FLM_INV_CARD_STS_FOR_STS_CHG');
337: X_ERR_MSG := fnd_message.get;
338: X_RETCODE := 'E';
339: return;
340: end if;
341: if p_supply_status <> nvl(p_supply_status_to,p_supply_status) and

Line 343: fnd_message.set_name('FLM', 'FLM_INV_CARD_STS_AND_SUP_CHG');

339: return;
340: end if;
341: if p_supply_status <> nvl(p_supply_status_to,p_supply_status) and
342: p_card_status <> nvl(l_card_status_to,p_card_status) then
343: fnd_message.set_name('FLM', 'FLM_INV_CARD_STS_AND_SUP_CHG');
344: X_ERR_MSG := fnd_message.get;
345: X_RETCODE := 'E';
346: return;
347: end if;

Line 344: X_ERR_MSG := fnd_message.get;

340: end if;
341: if p_supply_status <> nvl(p_supply_status_to,p_supply_status) and
342: p_card_status <> nvl(l_card_status_to,p_card_status) then
343: fnd_message.set_name('FLM', 'FLM_INV_CARD_STS_AND_SUP_CHG');
344: X_ERR_MSG := fnd_message.get;
345: X_RETCODE := 'E';
346: return;
347: end if;
348: if validate_supply_status_change(p_kanban_card_id,p_supply_status,p_supply_status_to) = 1 then

Line 352: fnd_message.set_name('FLM', 'FLM_DISCARD_DISABLE_CARD');

348: if validate_supply_status_change(p_kanban_card_id,p_supply_status,p_supply_status_to) = 1 then
349: if trunc(p_supply_status_to) = INV_Kanban_PVT.G_Supply_Status_Empty then
350: if trunc(p_disable_date) <= trunc(sysdate) then
351: -- card is cancelled since it is disabled.
352: fnd_message.set_name('FLM', 'FLM_DISCARD_DISABLE_CARD');
353: X_ERR_MSG := fnd_message.get;
354: X_RETCODE := 'W';
355: X_RET_MSG_CODE := 1;
356: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;

Line 353: X_ERR_MSG := fnd_message.get;

349: if trunc(p_supply_status_to) = INV_Kanban_PVT.G_Supply_Status_Empty then
350: if trunc(p_disable_date) <= trunc(sysdate) then
351: -- card is cancelled since it is disabled.
352: fnd_message.set_name('FLM', 'FLM_DISCARD_DISABLE_CARD');
353: X_ERR_MSG := fnd_message.get;
354: X_RETCODE := 'W';
355: X_RET_MSG_CODE := 1;
356: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
357: end if;

Line 360: fnd_message.set_name('FLM', 'FLM_CANCEL_KAN_MAX_REPLENISH');

356: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
357: end if;
358: if nvl(p_max_replenishments,nvl(p_replenishment_count,0)+2) <= nvl(p_replenishment_count,0) then
359: -- card is cancelled since it has reached the maximum replenishment counts.
360: fnd_message.set_name('FLM', 'FLM_CANCEL_KAN_MAX_REPLENISH');
361: X_ERR_MSG := fnd_message.get;
362: X_RETCODE := 'W';
363: X_RET_MSG_CODE := 1;
364: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;

Line 361: X_ERR_MSG := fnd_message.get;

357: end if;
358: if nvl(p_max_replenishments,nvl(p_replenishment_count,0)+2) <= nvl(p_replenishment_count,0) then
359: -- card is cancelled since it has reached the maximum replenishment counts.
360: fnd_message.set_name('FLM', 'FLM_CANCEL_KAN_MAX_REPLENISH');
361: X_ERR_MSG := fnd_message.get;
362: X_RETCODE := 'W';
363: X_RET_MSG_CODE := 1;
364: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
365: end if;

Line 388: fnd_message.set_name('FLM', 'FLM_CANCEL_EXCEED_CARDS');

384: p_disable_date is null and
385: nvl(p_kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable) = INV_Kanban_Pvt.g_card_type_replenishable then
386: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
387: -- card is cancelled since the pull sequence definition requires less no. of cards than what is required.
388: fnd_message.set_name('FLM', 'FLM_CANCEL_EXCEED_CARDS');
389: X_ERR_MSG := fnd_message.get;
390: X_RETCODE := 'W';
391: X_RET_MSG_CODE := 1;
392: end if;

Line 389: X_ERR_MSG := fnd_message.get;

385: nvl(p_kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable) = INV_Kanban_Pvt.g_card_type_replenishable then
386: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
387: -- card is cancelled since the pull sequence definition requires less no. of cards than what is required.
388: fnd_message.set_name('FLM', 'FLM_CANCEL_EXCEED_CARDS');
389: X_ERR_MSG := fnd_message.get;
390: X_RETCODE := 'W';
391: X_RET_MSG_CODE := 1;
392: end if;
393: l_new_card_size := nvl(l_pull_seq_rec.Kanban_size,0);

Line 401: fnd_message.set_name('FLM', 'FLM_CANCEL_EXCEED_CARDS');

397: p_disable_date is null and
398: nvl(p_kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable) = INV_Kanban_Pvt.g_card_type_replenishable then
399: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
400: -- card is cancelled since the pull sequence definition requires less no. of cards than what is required.
401: fnd_message.set_name('FLM', 'FLM_CANCEL_EXCEED_CARDS');
402: X_ERR_MSG := fnd_message.get;
403: X_RETCODE := 'W';
404: X_RET_MSG_CODE := 1;
405: end if;

Line 402: X_ERR_MSG := fnd_message.get;

398: nvl(p_kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable) = INV_Kanban_Pvt.g_card_type_replenishable then
399: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
400: -- card is cancelled since the pull sequence definition requires less no. of cards than what is required.
401: fnd_message.set_name('FLM', 'FLM_CANCEL_EXCEED_CARDS');
402: X_ERR_MSG := fnd_message.get;
403: X_RETCODE := 'W';
404: X_RET_MSG_CODE := 1;
405: end if;
406: if nvl(p_verify,'N') = 'N' then

Line 519: fnd_message.set_name('FLM', 'FLM_REPLACE_KANBAN_CARD');

515: , p_replacement_flag => NULL );
516: end if;
517: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
518: -- current card is cancelled and it's replaced with new card with number and number.
519: fnd_message.set_name('FLM', 'FLM_REPLACE_KANBAN_CARD');
520: fnd_message.set_token('NUMBER',l_new_card_number);
521: X_ERR_MSG := fnd_message.get;
522: X_RETCODE := 'W';
523: X_RET_MSG_CODE := 2;

Line 520: fnd_message.set_token('NUMBER',l_new_card_number);

516: end if;
517: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
518: -- current card is cancelled and it's replaced with new card with number and number.
519: fnd_message.set_name('FLM', 'FLM_REPLACE_KANBAN_CARD');
520: fnd_message.set_token('NUMBER',l_new_card_number);
521: X_ERR_MSG := fnd_message.get;
522: X_RETCODE := 'W';
523: X_RET_MSG_CODE := 2;
524:

Line 521: X_ERR_MSG := fnd_message.get;

517: l_card_status_to := INV_Kanban_PVT.G_Card_Status_Cancel;
518: -- current card is cancelled and it's replaced with new card with number and number.
519: fnd_message.set_name('FLM', 'FLM_REPLACE_KANBAN_CARD');
520: fnd_message.set_token('NUMBER',l_new_card_number);
521: X_ERR_MSG := fnd_message.get;
522: X_RETCODE := 'W';
523: X_RET_MSG_CODE := 2;
524:
525: if l_return_status = FND_API.G_RET_STS_ERROR then

Line 593: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');

589: return;
590: END IF;
591: if X_ERR_MSG is null then
592: -- Card status for kanban Card and card_num is successfully changed.
593: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
594: fnd_message.set_token('NUMBER', p_kanban_card_number);
595: X_ERR_MSG := fnd_message.get;
596: X_RETCODE := 'S';
597: return;

Line 594: fnd_message.set_token('NUMBER', p_kanban_card_number);

590: END IF;
591: if X_ERR_MSG is null then
592: -- Card status for kanban Card and card_num is successfully changed.
593: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
594: fnd_message.set_token('NUMBER', p_kanban_card_number);
595: X_ERR_MSG := fnd_message.get;
596: X_RETCODE := 'S';
597: return;
598: end if;

Line 595: X_ERR_MSG := fnd_message.get;

591: if X_ERR_MSG is null then
592: -- Card status for kanban Card and card_num is successfully changed.
593: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
594: fnd_message.set_token('NUMBER', p_kanban_card_number);
595: X_ERR_MSG := fnd_message.get;
596: X_RETCODE := 'S';
597: return;
598: end if;
599: end if;

Line 661: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');

657: return;
658: END IF;
659: if X_ERR_MSG is null then
660: -- Card status for kanban Card and card_num is successfully changed.
661: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
662: fnd_message.set_token('NUMBER', p_kanban_card_number);
663: X_ERR_MSG := fnd_message.get;
664: X_RETCODE := 'S';
665: end if;

Line 662: fnd_message.set_token('NUMBER', p_kanban_card_number);

658: END IF;
659: if X_ERR_MSG is null then
660: -- Card status for kanban Card and card_num is successfully changed.
661: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
662: fnd_message.set_token('NUMBER', p_kanban_card_number);
663: X_ERR_MSG := fnd_message.get;
664: X_RETCODE := 'S';
665: end if;
666: end if;

Line 663: X_ERR_MSG := fnd_message.get;

659: if X_ERR_MSG is null then
660: -- Card status for kanban Card and card_num is successfully changed.
661: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
662: fnd_message.set_token('NUMBER', p_kanban_card_number);
663: X_ERR_MSG := fnd_message.get;
664: X_RETCODE := 'S';
665: end if;
666: end if;
667: -- Cannot Manually change status to consolidate.

Line 670: fnd_message.set_name('FLM', 'FLM_NO_CONS_STATUS_CHANGE');

666: end if;
667: -- Cannot Manually change status to consolidate.
668: elsif p_supply_status_to = INV_Kanban_PVT.G_Supply_Status_Consolidate then
669: -- Cannot Manually change status to consolidate.
670: fnd_message.set_name('FLM', 'FLM_NO_CONS_STATUS_CHANGE');
671: X_ERR_MSG := fnd_message.get;
672: X_RETCODE := 'E';
673: return;
674: -- other status changes.

Line 671: X_ERR_MSG := fnd_message.get;

667: -- Cannot Manually change status to consolidate.
668: elsif p_supply_status_to = INV_Kanban_PVT.G_Supply_Status_Consolidate then
669: -- Cannot Manually change status to consolidate.
670: fnd_message.set_name('FLM', 'FLM_NO_CONS_STATUS_CHANGE');
671: X_ERR_MSG := fnd_message.get;
672: X_RETCODE := 'E';
673: return;
674: -- other status changes.
675: else

Line 751: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');

747: EXCEPTION
748: WHEN OTHERS THEN
749: NULL;
750: END;
751: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');
752: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_code_from);
753: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_code_to);
754: X_ERR_MSG := fnd_message.get;
755: X_RETCODE := 'E';

Line 752: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_code_from);

748: WHEN OTHERS THEN
749: NULL;
750: END;
751: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');
752: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_code_from);
753: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_code_to);
754: X_ERR_MSG := fnd_message.get;
755: X_RETCODE := 'E';
756: return;

Line 753: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_code_to);

749: NULL;
750: END;
751: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');
752: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_code_from);
753: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_code_to);
754: X_ERR_MSG := fnd_message.get;
755: X_RETCODE := 'E';
756: return;
757: end if;

Line 754: X_ERR_MSG := fnd_message.get;

750: END;
751: fnd_message.set_name('INV', 'INV_SUPPLY_STATUS_NOT_ALLOWED');
752: fnd_message.set_token('SUPPLY_STATUS_FROM', l_supply_status_code_from);
753: fnd_message.set_token('SUPPLY_STATUS_TO', l_supply_status_code_to);
754: X_ERR_MSG := fnd_message.get;
755: X_RETCODE := 'E';
756: return;
757: end if;
758: end if;

Line 762: fnd_message.set_name('FLM', 'FLM_NO_STS_CHG_CANCEL_CARD');

758: end if;
759: if p_card_status <> nvl(l_card_status_to,p_card_status) then
760: if p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel then
761: -- Card status cannot be updated for cancelled card.
762: fnd_message.set_name('FLM', 'FLM_NO_STS_CHG_CANCEL_CARD');
763: X_ERR_MSG := fnd_message.get;
764: X_RETCODE := 'E';
765: return;
766: end if;

Line 763: X_ERR_MSG := fnd_message.get;

759: if p_card_status <> nvl(l_card_status_to,p_card_status) then
760: if p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel then
761: -- Card status cannot be updated for cancelled card.
762: fnd_message.set_name('FLM', 'FLM_NO_STS_CHG_CANCEL_CARD');
763: X_ERR_MSG := fnd_message.get;
764: X_RETCODE := 'E';
765: return;
766: end if;
767: if l_card_status_to = INV_Kanban_PVT.G_Card_Status_Planned then

Line 769: fnd_message.set_name('FLM', 'FLM_NO_STS_CHG_PLAN_CARD');

765: return;
766: end if;
767: if l_card_status_to = INV_Kanban_PVT.G_Card_Status_Planned then
768: -- Card status cannot be updated to planned once it's released.
769: fnd_message.set_name('FLM', 'FLM_NO_STS_CHG_PLAN_CARD');
770: X_ERR_MSG := fnd_message.get;
771: X_RETCODE := 'E';
772: return;
773: end if;

Line 770: X_ERR_MSG := fnd_message.get;

766: end if;
767: if l_card_status_to = INV_Kanban_PVT.G_Card_Status_Planned then
768: -- Card status cannot be updated to planned once it's released.
769: fnd_message.set_name('FLM', 'FLM_NO_STS_CHG_PLAN_CARD');
770: X_ERR_MSG := fnd_message.get;
771: X_RETCODE := 'E';
772: return;
773: end if;
774: if l_card_status_to not in (INV_Kanban_PVT.G_Card_Status_Hold,

Line 779: fnd_message.set_name('FLM', 'FLM_INVALID_CARD_STATUS');

775: INV_Kanban_PVT.G_Card_Status_Cancel,
776: INV_Kanban_PVT.G_Card_Status_Planned,
777: INV_Kanban_PVT.G_Card_Status_Active) then
778: -- Invalid Card Status.
779: fnd_message.set_name('FLM', 'FLM_INVALID_CARD_STATUS');
780: X_ERR_MSG := fnd_message.get;
781: X_RETCODE := 'E';
782: return;
783: end if;

Line 780: X_ERR_MSG := fnd_message.get;

776: INV_Kanban_PVT.G_Card_Status_Planned,
777: INV_Kanban_PVT.G_Card_Status_Active) then
778: -- Invalid Card Status.
779: fnd_message.set_name('FLM', 'FLM_INVALID_CARD_STATUS');
780: X_ERR_MSG := fnd_message.get;
781: X_RETCODE := 'E';
782: return;
783: end if;
784: if nvl(p_verify,'N') = 'N' then

Line 852: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');

848: null;
849: End;
850: if X_ERR_MSG is null then
851: -- Card status for kanban Card and card_num is successfully changed.
852: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
853: fnd_message.set_token('NUMBER', p_kanban_card_number);
854: X_ERR_MSG := fnd_message.get;
855: X_RETCODE := 'S';
856: return;

Line 853: fnd_message.set_token('NUMBER', p_kanban_card_number);

849: End;
850: if X_ERR_MSG is null then
851: -- Card status for kanban Card and card_num is successfully changed.
852: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
853: fnd_message.set_token('NUMBER', p_kanban_card_number);
854: X_ERR_MSG := fnd_message.get;
855: X_RETCODE := 'S';
856: return;
857: end if;

Line 854: X_ERR_MSG := fnd_message.get;

850: if X_ERR_MSG is null then
851: -- Card status for kanban Card and card_num is successfully changed.
852: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
853: fnd_message.set_token('NUMBER', p_kanban_card_number);
854: X_ERR_MSG := fnd_message.get;
855: X_RETCODE := 'S';
856: return;
857: end if;
858: end if;

Line 920: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');

916: X_ERR_MSG := 'Unexpected error while updating card details';
917: X_RETCODE := 'E';
918: return;
919: END IF;
920: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
921: fnd_message.set_token('NUMBER', p_kanban_card_number);
922: X_ERR_MSG := fnd_message.get;
923: X_RETCODE := 'S';
924: end if;

Line 921: fnd_message.set_token('NUMBER', p_kanban_card_number);

917: X_RETCODE := 'E';
918: return;
919: END IF;
920: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
921: fnd_message.set_token('NUMBER', p_kanban_card_number);
922: X_ERR_MSG := fnd_message.get;
923: X_RETCODE := 'S';
924: end if;
925: if X_RETCODE = 'S' then

Line 922: X_ERR_MSG := fnd_message.get;

918: return;
919: END IF;
920: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
921: fnd_message.set_token('NUMBER', p_kanban_card_number);
922: X_ERR_MSG := fnd_message.get;
923: X_RETCODE := 'S';
924: end if;
925: if X_RETCODE = 'S' then
926: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');

Line 926: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');

922: X_ERR_MSG := fnd_message.get;
923: X_RETCODE := 'S';
924: end if;
925: if X_RETCODE = 'S' then
926: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
927: fnd_message.set_token('NUMBER', p_kanban_card_number);
928: X_ERR_MSG := fnd_message.get;
929: return;
930: end if;

Line 927: fnd_message.set_token('NUMBER', p_kanban_card_number);

923: X_RETCODE := 'S';
924: end if;
925: if X_RETCODE = 'S' then
926: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
927: fnd_message.set_token('NUMBER', p_kanban_card_number);
928: X_ERR_MSG := fnd_message.get;
929: return;
930: end if;
931: EXCEPTION

Line 928: X_ERR_MSG := fnd_message.get;

924: end if;
925: if X_RETCODE = 'S' then
926: fnd_message.set_name('FLM', 'FLM_CARD_STS_CHG_SUCCESS');
927: fnd_message.set_token('NUMBER', p_kanban_card_number);
928: X_ERR_MSG := fnd_message.get;
929: return;
930: end if;
931: EXCEPTION
932: WHEN OTHERS THEN

Line 980: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN');

976: X_RETCODE := FND_API.G_RET_STS_SUCCESS;
977:
978: if p_Kanban_Card_Id is null then
979: -- Invalid parameters passed to supply status APIs.
980: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN');
981: X_ERR_MSG := fnd_message.get;
982: X_RETCODE := 'E';
983: return;
984: end if;

Line 981: X_ERR_MSG := fnd_message.get;

977:
978: if p_Kanban_Card_Id is null then
979: -- Invalid parameters passed to supply status APIs.
980: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN');
981: X_ERR_MSG := fnd_message.get;
982: X_RETCODE := 'E';
983: return;
984: end if;
985:

Line 994: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_NOCHANGE');

990: l_kanban_card_rec := inv_kanbancard_pkg.query_row(p_Kanban_Card_Id => p_Kanban_Card_Id);
991:
992: -- if kanban card supply status is already full and receiving more qty or doing a return then return a message no status change
993: if (trunc(l_kanban_card_rec.supply_status) = INV_KANBAN_PVT.G_Supply_Status_Full or l_replenish_quantity < 0) then
994: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_NOCHANGE');
995: X_ERR_MSG := fnd_message.get;
996: X_RETCODE := 'S';
997: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
998: return;

Line 995: X_ERR_MSG := fnd_message.get;

991:
992: -- if kanban card supply status is already full and receiving more qty or doing a return then return a message no status change
993: if (trunc(l_kanban_card_rec.supply_status) = INV_KANBAN_PVT.G_Supply_Status_Full or l_replenish_quantity < 0) then
994: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_NOCHANGE');
995: X_ERR_MSG := fnd_message.get;
996: X_RETCODE := 'S';
997: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
998: return;
999: end if;

Line 1162: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_FULL');

1158: X_RET_MSG_CODE => X_RET_MSG_CODE,
1159: X_ERR_MSG => X_ERR_MSG);
1160: mydebug('After update_card_status api: X_RETCODE='||X_RETCODE||', X_RET_MSG_CODE='||X_RET_MSG_CODE||', X_ERR_MSG='||X_ERR_MSG);
1161: else
1162: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_FULL');
1163: X_ERR_MSG := fnd_message.get;
1164: X_RETCODE := 'S';
1165: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
1166: end if;

Line 1163: X_ERR_MSG := fnd_message.get;

1159: X_ERR_MSG => X_ERR_MSG);
1160: mydebug('After update_card_status api: X_RETCODE='||X_RETCODE||', X_RET_MSG_CODE='||X_RET_MSG_CODE||', X_ERR_MSG='||X_ERR_MSG);
1161: else
1162: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_FULL');
1163: X_ERR_MSG := fnd_message.get;
1164: X_RETCODE := 'S';
1165: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
1166: end if;
1167: else

Line 1168: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_NOCHANGE');

1164: X_RETCODE := 'S';
1165: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
1166: end if;
1167: else
1168: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_NOCHANGE');
1169: X_ERR_MSG := fnd_message.get;
1170: X_RETCODE := 'S';
1171: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
1172: end if;

Line 1169: X_ERR_MSG := fnd_message.get;

1165: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
1166: end if;
1167: else
1168: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_NOCHANGE');
1169: X_ERR_MSG := fnd_message.get;
1170: X_RETCODE := 'S';
1171: mydebug('X_RETCODE='||X_RETCODE||', X_ERR_MSG='||X_ERR_MSG);
1172: end if;
1173: