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_API

Line 118: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

114: X_ERR_MSG OUT NOCOPY VARCHAR2)
115: IS
116:
117: l_card_status_to NUMBER;
118: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
119: l_new_card_id number;
120: l_new_card_number number;
121: l_new_replenish_cycle_id Number;
122: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

Line 306: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

302: l_new_card_number number;
303: l_new_replenish_cycle_id Number;
304: l_pull_seq_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type;
305: l_active_cards_count number;
306: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
307: l_supply_status_to number;
308: l_current_replnsh_cycle_id number;
309: l_supply_status_code_from VARCHAR2(30);
310: l_supply_status_code_to VARCHAR2(30);

Line 454: if l_return_status = FND_API.G_RET_STS_ERROR then

450: x_supplier_id => l_supplier_id,
451: x_supplier_site_id => l_supplier_site_id,
452: x_retcode => l_return_status,
453: x_err_msg => X_ERR_MSG);
454: if l_return_status = FND_API.G_RET_STS_ERROR then
455: rollback to prior_status_change;
456: X_ERR_MSG := 'Unexpected error while fetching the supplier';
457: X_RETCODE := 'E';
458: return;

Line 525: if l_return_status = FND_API.G_RET_STS_ERROR then

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
526: rollback to prior_status_change;
527: X_ERR_MSG := 'Unexpected error while replacing the card during replenishment';
528: X_RETCODE := 'E';
529: return;

Line 585: IF l_return_status = fnd_api.g_ret_sts_error THEN

581: , p_max_replenishments => p_max_replenishments
582: , p_disable_date => p_disable_date
583: , p_replacement_flag => p_replacement_flag);
584: end if;
585: IF l_return_status = fnd_api.g_ret_sts_error THEN
586: rollback to prior_status_change;
587: X_ERR_MSG := 'Unexpected error while updating card status.';
588: X_RETCODE := 'E';
589: return;

Line 653: IF l_return_status = fnd_api.g_ret_sts_error THEN

649: , p_max_replenishments => p_max_replenishments
650: , p_disable_date => p_disable_date
651: , p_replacement_flag => p_replacement_flag);
652: end if;
653: IF l_return_status = fnd_api.g_ret_sts_error THEN
654: rollback to prior_status_change;
655: X_ERR_MSG := 'Unexpected error while updating card status.';
656: X_RETCODE := 'E';
657: return;

Line 729: if l_return_status = FND_API.G_RET_STS_ERROR then

725: , p_max_replenishments => p_max_replenishments
726: , p_disable_date => p_disable_date
727: , p_replacement_flag => p_replacement_flag);
728: end if;
729: if l_return_status = FND_API.G_RET_STS_ERROR then
730: rollback to prior_status_change;
731: X_ERR_MSG := 'Unexpected error while updating card supply status.';
732: X_RETCODE := 'E';
733: return;

Line 838: IF l_return_status = fnd_api.g_ret_sts_error THEN

834: , p_max_replenishments => p_max_replenishments
835: , p_disable_date => p_disable_date
836: , p_replacement_flag => p_replacement_flag);
837: end if;
838: IF l_return_status = fnd_api.g_ret_sts_error THEN
839: rollback to prior_status_change;
840: X_ERR_MSG := 'Unexpected error while updating card status.';
841: X_RETCODE := 'E';
842: return;

Line 914: IF l_return_status = fnd_api.g_ret_sts_error THEN

910: , p_max_replenishments => p_max_replenishments
911: , p_disable_date => p_disable_date
912: , p_replacement_flag => p_replacement_flag);
913: end if;
914: IF l_return_status = fnd_api.g_ret_sts_error THEN
915: rollback to prior_status_change;
916: X_ERR_MSG := 'Unexpected error while updating card details';
917: X_RETCODE := 'E';
918: return;

Line 961: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE,

957: -- validate_only parameter will be used to just check if kanban card status will be changed to FULL or not. It can be called from ADF UI as well.
958:
959: PROCEDURE CHANGE_CARD_STATUS_FULL(p_Kanban_Card_Id IN NUMBER ,
960: p_replenish_quantity IN NUMBER DEFAULT NULL,
961: p_validate_only IN VARCHAR2 DEFAULT FND_API.G_FALSE,
962: X_ERR_MSG OUT NOCOPY VARCHAR2,
963: X_RET_MSG_CODE OUT NOCOPY NUMBER,
964: X_RETCODE OUT NOCOPY VARCHAR2) IS
965:

Line 976: X_RETCODE := FND_API.G_RET_STS_SUCCESS;

972: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
973: l_intransit_type NUMBER;
974:
975: Begin
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');

Line 1152: if (p_validate_only = FND_API.G_FALSE) then

1148: -- check if total received qty is >= tolerance value then call above status change api to change the status to FULL
1149: -- else just return the message that kanban card status will remain unchanged.
1150: if ( l_total_received_quantity >= (l_kanban_size * l_rcv_tolerance/100) ) then
1151: mydebug('kanban card has received qty upto its tolerance level');
1152: if (p_validate_only = FND_API.G_FALSE) then
1153: mydebug('Calling update_card_status api');
1154: UPDATE_CARD_STATUS( P_KANBAN_ID => p_Kanban_Card_Id,
1155: P_SUPPLY_STATUS_TO => INV_KANBAN_PVT.G_Supply_Status_Full,
1156: P_CARD_STATUS_TO => l_kanban_card_rec.card_status,