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_KANBAN_TRANSFER dependencies on FND_API

Line 86: p_init_msg_lst => FND_API.g_false,

82: INV_QUANTITY_TREE_PUB.CLEAR_QUANTITY_CACHE;
83:
84: INV_QUANTITY_TREE_PUB.query_quantities
85: ( p_api_version_number => 1.0 ,
86: p_init_msg_lst => FND_API.g_false,
87: x_return_status => x_retcode,
88: x_msg_count => l_msg_count,
89: x_msg_data => x_errmsg,
90: p_organization_id => p_source_organization_id,

Line 121: IF x_retcode = FND_API.G_RET_STS_SUCCESS THEN

117: 'x_msg_count = ' || l_msg_count || ', ' ||
118: 'x_msg_data = ' || x_errmsg);
119: END IF;
120:
121: IF x_retcode = FND_API.G_RET_STS_SUCCESS THEN
122:
123: x_available_to_transact := l_att;
124:
125: ELSIF l_msg_count > 1 THEN

Line 128: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

124:
125: ELSIF l_msg_count > 1 THEN
126:
127: FOR i IN 1..l_msg_count LOOP
128: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
129: END LOOP;
130:
131: END IF;
132:

Line 274: x_retcode := FND_API.G_RET_STS_SUCCESS;

270: 'p_kanban_size = ' || p_kanban_size);
271: END IF;
272:
273: -- Initialize return status to success
274: x_retcode := FND_API.G_RET_STS_SUCCESS;
275:
276:
277: l_tolerance_param := flm_kanban_config_params.get_tol_kanban_transfer(p_organization_id);
278:

Line 329: p_init_msg_list => FND_API.G_FALSE,

325: -- The Autocreate_Deliveries procedure is called to automatically create deliveries for multiple delivery lines.
326: --**************************************************************************************************************
327: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries
328: ( p_api_version_number => 1.0,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_commit => FND_API.G_FALSE,
331: x_return_status => x_retcode,
332: x_msg_count => l_msg_count,
333: x_msg_data => x_errmsg,

Line 330: p_commit => FND_API.G_FALSE,

326: --**************************************************************************************************************
327: WSH_DELIVERY_DETAILS_PUB.autocreate_deliveries
328: ( p_api_version_number => 1.0,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_commit => FND_API.G_FALSE,
331: x_return_status => x_retcode,
332: x_msg_count => l_msg_count,
333: x_msg_data => x_errmsg,
334: p_line_rows => l_delivery_ids_tbl,

Line 349: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

345: 'x_msg_data = ' || x_errmsg);
346:
347: END IF;
348:
349: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
350: x_retcode := FND_API.G_RET_STS_ERROR;
351:
352: IF l_msg_count > 1 THEN
353: FOR i IN 1..l_msg_count LOOP

Line 350: x_retcode := FND_API.G_RET_STS_ERROR;

346:
347: END IF;
348:
349: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
350: x_retcode := FND_API.G_RET_STS_ERROR;
351:
352: IF l_msg_count > 1 THEN
353: FOR i IN 1..l_msg_count LOOP
354: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 354: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

350: x_retcode := FND_API.G_RET_STS_ERROR;
351:
352: IF l_msg_count > 1 THEN
353: FOR i IN 1..l_msg_count LOOP
354: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
355: END LOOP;
356: END IF;
357:
358: RETURN;

Line 410: p_init_msg_list => FND_API.G_FALSE,

406: END IF;
407:
408: WSH_PICKING_BATCHES_PUB.create_batch
409: ( p_api_version => 1.0,
410: p_init_msg_list => FND_API.G_FALSE,
411: x_return_status => x_retcode,
412: x_msg_count => l_msg_count,
413: x_msg_data => x_errmsg,
414: p_batch_rec => l_batch_info_rec,

Line 428: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

424: 'x_msg_data = ' || x_errmsg || ', ' ||
425: 'x_batch_id = ' || l_batch_id);
426: END IF;
427:
428: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
429: x_retcode := FND_API.G_RET_STS_ERROR;
430:
431: IF l_msg_count > 1 THEN
432: FOR i IN 1..l_msg_count LOOP

Line 429: x_retcode := FND_API.G_RET_STS_ERROR;

425: 'x_batch_id = ' || l_batch_id);
426: END IF;
427:
428: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
429: x_retcode := FND_API.G_RET_STS_ERROR;
430:
431: IF l_msg_count > 1 THEN
432: FOR i IN 1..l_msg_count LOOP
433: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 433: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

429: x_retcode := FND_API.G_RET_STS_ERROR;
430:
431: IF l_msg_count > 1 THEN
432: FOR i IN 1..l_msg_count LOOP
433: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
434: END LOOP;
435: END IF;
436:
437: RETURN;

Line 453: p_init_msg_list => FND_API.G_FALSE,

449: -- Create_Batch API.
450: -- ***********************************************************************************
451: WSH_PICKING_BATCHES_PUB.release_batch
452: ( p_api_version => 1.0,
453: p_init_msg_list => FND_API.G_FALSE,
454: x_return_status => x_retcode,
455: x_msg_count => l_msg_count,
456: x_msg_data => x_errmsg,
457: p_batch_id => l_batch_id,

Line 472: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

468: 'x_msg_data = ' || x_errmsg || ', ' ||
469: 'x_request_id = ' || l_request_id);
470: END IF;
471:
472: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
473: x_retcode := FND_API.G_RET_STS_ERROR;
474: IF l_msg_count > 1 THEN
475: FOR i IN 1..l_msg_count LOOP
476: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 473: x_retcode := FND_API.G_RET_STS_ERROR;

469: 'x_request_id = ' || l_request_id);
470: END IF;
471:
472: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
473: x_retcode := FND_API.G_RET_STS_ERROR;
474: IF l_msg_count > 1 THEN
475: FOR i IN 1..l_msg_count LOOP
476: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
477: END LOOP;

Line 476: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

472: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
473: x_retcode := FND_API.G_RET_STS_ERROR;
474: IF l_msg_count > 1 THEN
475: FOR i IN 1..l_msg_count LOOP
476: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
477: END LOOP;
478: END IF;
479:
480: RETURN;

Line 512: p_init_msg_list => FND_API.G_FALSE,

508: END IF;
509:
510: INV_MOVE_ORDER_PUB.process_move_order_line
511: ( p_api_version_number => 1.0,
512: p_init_msg_list => FND_API.G_FALSE,
513: p_return_values => FND_API.G_FALSE,
514: p_commit => FND_API.G_FALSE,
515: x_return_status => x_retcode,
516: x_msg_count => l_msg_count,

Line 513: p_return_values => FND_API.G_FALSE,

509:
510: INV_MOVE_ORDER_PUB.process_move_order_line
511: ( p_api_version_number => 1.0,
512: p_init_msg_list => FND_API.G_FALSE,
513: p_return_values => FND_API.G_FALSE,
514: p_commit => FND_API.G_FALSE,
515: x_return_status => x_retcode,
516: x_msg_count => l_msg_count,
517: x_msg_data => x_errmsg,

Line 514: p_commit => FND_API.G_FALSE,

510: INV_MOVE_ORDER_PUB.process_move_order_line
511: ( p_api_version_number => 1.0,
512: p_init_msg_list => FND_API.G_FALSE,
513: p_return_values => FND_API.G_FALSE,
514: p_commit => FND_API.G_FALSE,
515: x_return_status => x_retcode,
516: x_msg_count => l_msg_count,
517: x_msg_data => x_errmsg,
518: p_trolin_tbl => l_trolin_tbl,

Line 532: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

528: 'x_msg_count = ' || l_msg_count || ', ' ||
529: 'x_msg_data = ' || x_errmsg);
530: END IF;
531:
532: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
533: x_retcode := FND_API.G_RET_STS_ERROR;
534:
535: IF l_msg_count > 1 THEN
536: FOR i IN 1..l_msg_count LOOP

Line 533: x_retcode := FND_API.G_RET_STS_ERROR;

529: 'x_msg_data = ' || x_errmsg);
530: END IF;
531:
532: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
533: x_retcode := FND_API.G_RET_STS_ERROR;
534:
535: IF l_msg_count > 1 THEN
536: FOR i IN 1..l_msg_count LOOP
537: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 537: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

533: x_retcode := FND_API.G_RET_STS_ERROR;
534:
535: IF l_msg_count > 1 THEN
536: FOR i IN 1..l_msg_count LOOP
537: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
538: END LOOP;
539: END IF;
540:
541: RETURN;

Line 562: p_init_msg_list => FND_API.G_FALSE,

558: END IF;
559:
560: INV_PICK_WAVE_PICK_CONFIRM_PUB.pick_confirm
561: ( p_api_version_number => 1.0,
562: p_init_msg_list => FND_API.G_FALSE,
563: p_commit => FND_API.G_FALSE,
564: x_return_status => x_retcode,
565: x_msg_count => l_msg_count,
566: x_msg_data => x_errmsg,

Line 563: p_commit => FND_API.G_FALSE,

559:
560: INV_PICK_WAVE_PICK_CONFIRM_PUB.pick_confirm
561: ( p_api_version_number => 1.0,
562: p_init_msg_list => FND_API.G_FALSE,
563: p_commit => FND_API.G_FALSE,
564: x_return_status => x_retcode,
565: x_msg_count => l_msg_count,
566: x_msg_data => x_errmsg,
567: p_move_order_type => l_move_order_type,

Line 585: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

581: 'x_msg_count = ' || l_msg_count || ', ' ||
582: 'x_msg_data = ' || x_errmsg);
583: END IF;
584:
585: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
586: x_retcode := FND_API.G_RET_STS_ERROR;
587:
588: IF l_msg_count > 1 THEN
589: FOR i IN 1..l_msg_count LOOP

Line 586: x_retcode := FND_API.G_RET_STS_ERROR;

582: 'x_msg_data = ' || x_errmsg);
583: END IF;
584:
585: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
586: x_retcode := FND_API.G_RET_STS_ERROR;
587:
588: IF l_msg_count > 1 THEN
589: FOR i IN 1..l_msg_count LOOP
590: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 590: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

586: x_retcode := FND_API.G_RET_STS_ERROR;
587:
588: IF l_msg_count > 1 THEN
589: FOR i IN 1..l_msg_count LOOP
590: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
591: END LOOP;
592: END IF;
593: RETURN;
594: END IF;

Line 611: p_init_msg_list => FND_API.G_FALSE,

607: END IF;
608:
609: WSH_DELIVERIES_PUB.delivery_action
610: ( p_api_version_number => 1.0,
611: p_init_msg_list => FND_API.G_FALSE,
612: x_return_status => x_retcode,
613: x_msg_count => l_msg_count,
614: x_msg_data => x_errmsg,
615: p_action_code => 'CONFIRM',

Line 640: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

636: 'x_trip_id = ' || l_trip_id || ', ' ||
637: 'x_trip_name = ' || l_trip_name);
638: END IF;
639:
640: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
641: x_retcode := FND_API.G_RET_STS_ERROR;
642: IF l_msg_count > 1 THEN
643: FOR i IN 1..l_msg_count LOOP
644: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 641: x_retcode := FND_API.G_RET_STS_ERROR;

637: 'x_trip_name = ' || l_trip_name);
638: END IF;
639:
640: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
641: x_retcode := FND_API.G_RET_STS_ERROR;
642: IF l_msg_count > 1 THEN
643: FOR i IN 1..l_msg_count LOOP
644: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
645: END LOOP;

Line 644: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

640: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
641: x_retcode := FND_API.G_RET_STS_ERROR;
642: IF l_msg_count > 1 THEN
643: FOR i IN 1..l_msg_count LOOP
644: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
645: END LOOP;
646: END IF;
647:
648: RETURN;

Line 684: x_retcode := FND_API.G_RET_STS_ERROR;

680: 'errbuf = ' || x_errmsg);
681: END IF;
682:
683: IF x_retcode <> '0' THEN
684: x_retcode := FND_API.G_RET_STS_ERROR;
685:
686: fnd_message.set_name('FLM','FLM_ITS_PROGRAM_FAILURE');
687: x_errmsg := fnd_message.get;
688: RETURN;

Line 819: x_retcode := FND_API.G_RET_STS_SUCCESS;

815: 'p_kanban_size = ' || p_kanban_size);
816: END IF;
817:
818: -- Initialize return status to success
819: x_retcode := FND_API.G_RET_STS_SUCCESS;
820:
821:
822: UPDATE mtl_txn_request_lines
823: SET quantity_detailed = NULL

Line 874: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

870: 'x_msg_count = ' || l_msg_count || ', ' ||
871: 'x_msg_data = ' || x_errmsg);
872: END IF;
873:
874: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
875: x_retcode := FND_API.G_RET_STS_ERROR;
876:
877: IF l_msg_count > 1 THEN
878: FOR i IN 1..l_msg_count LOOP

Line 875: x_retcode := FND_API.G_RET_STS_ERROR;

871: 'x_msg_data = ' || x_errmsg);
872: END IF;
873:
874: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
875: x_retcode := FND_API.G_RET_STS_ERROR;
876:
877: IF l_msg_count > 1 THEN
878: FOR i IN 1..l_msg_count LOOP
879: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 879: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

875: x_retcode := FND_API.G_RET_STS_ERROR;
876:
877: IF l_msg_count > 1 THEN
878: FOR i IN 1..l_msg_count LOOP
879: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
880: END LOOP;
881: END IF;
882:
883: fnd_message.set_name('FLM','FLM_REPLENISH_ERR');

Line 907: p_init_msg_list => FND_API.G_FALSE,

903: END IF;
904:
905: INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm
906: ( p_api_version_number => 1.0,
907: p_init_msg_list => FND_API.G_FALSE,
908: p_commit => FND_API.G_FALSE,
909: x_return_status => x_retcode,
910: x_msg_count => l_msg_count,
911: x_msg_data => x_errmsg,

Line 908: p_commit => FND_API.G_FALSE,

904:
905: INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm
906: ( p_api_version_number => 1.0,
907: p_init_msg_list => FND_API.G_FALSE,
908: p_commit => FND_API.G_FALSE,
909: x_return_status => x_retcode,
910: x_msg_count => l_msg_count,
911: x_msg_data => x_errmsg,
912: p_move_order_type => l_move_order_type,

Line 930: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

926: 'x_msg_count = ' || l_msg_count || ', ' ||
927: 'x_msg_data = ' || x_errmsg);
928: END IF;
929:
930: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
931: x_retcode := FND_API.G_RET_STS_ERROR;
932:
933: IF l_msg_count > 1 THEN
934: FOR i IN 1..l_msg_count LOOP

Line 931: x_retcode := FND_API.G_RET_STS_ERROR;

927: 'x_msg_data = ' || x_errmsg);
928: END IF;
929:
930: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
931: x_retcode := FND_API.G_RET_STS_ERROR;
932:
933: IF l_msg_count > 1 THEN
934: FOR i IN 1..l_msg_count LOOP
935: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 935: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

931: x_retcode := FND_API.G_RET_STS_ERROR;
932:
933: IF l_msg_count > 1 THEN
934: FOR i IN 1..l_msg_count LOOP
935: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
936: END LOOP;
937: END IF;
938:
939: fnd_message.set_name('FLM','FLM_PICK_RELEASE_ERR');

Line 976: p_init_msg_list => FND_API.G_FALSE,

972: END IF;
973:
974: INV_MO_ADMIN_PUB.close_order
975: ( p_api_version => 1.0,
976: p_init_msg_list => FND_API.G_FALSE,
977: p_commit => FND_API.G_FALSE,
978: p_validation_level => 'F',
979: p_header_id => p_intra_order_id,
980: x_msg_count => l_msg_count,

Line 977: p_commit => FND_API.G_FALSE,

973:
974: INV_MO_ADMIN_PUB.close_order
975: ( p_api_version => 1.0,
976: p_init_msg_list => FND_API.G_FALSE,
977: p_commit => FND_API.G_FALSE,
978: p_validation_level => 'F',
979: p_header_id => p_intra_order_id,
980: x_msg_count => l_msg_count,
981: x_msg_data => x_errmsg,

Line 994: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

990: 'x_msg_count = ' || l_msg_count || ', ' ||
991: 'x_msg_data = ' || x_errmsg);
992: END IF;
993:
994: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
995: x_retcode := FND_API.G_RET_STS_ERROR;
996:
997: IF l_msg_count > 1 THEN
998: FOR i IN 1..l_msg_count LOOP

Line 995: x_retcode := FND_API.G_RET_STS_ERROR;

991: 'x_msg_data = ' || x_errmsg);
992: END IF;
993:
994: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
995: x_retcode := FND_API.G_RET_STS_ERROR;
996:
997: IF l_msg_count > 1 THEN
998: FOR i IN 1..l_msg_count LOOP
999: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

Line 999: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;

995: x_retcode := FND_API.G_RET_STS_ERROR;
996:
997: IF l_msg_count > 1 THEN
998: FOR i IN 1..l_msg_count LOOP
999: x_errmsg := x_errmsg || fnd_msg_pub.get(i, FND_API.G_FALSE) || FND_CONST.NEWLINE;
1000: END LOOP;
1001: END IF;
1002:
1003: fnd_message.set_name('FLM','FLM_MOVE_ORDER_CLOSE_ERR');

Line 1212: x_retcode := FND_API.G_RET_STS_SUCCESS;

1208: 'p_transfer_qty = ' || p_transfer_qty);
1209: END IF;
1210:
1211: -- Initialize return status to success
1212: x_retcode := FND_API.G_RET_STS_SUCCESS;
1213:
1214:
1215: -- Validate kanban card
1216: OPEN c_kanban_detail(p_kanban_card_id);

Line 1222: x_retcode := FND_API.G_RET_STS_ERROR;

1218: CLOSE c_kanban_detail;
1219:
1220: IF l_kanban_detail_rec.kanban_card_id IS NULL THEN
1221:
1222: x_retcode := FND_API.G_RET_STS_ERROR;
1223:
1224: fnd_message.set_name('FLM','FLM_INVALID_KANBAN');
1225: x_errmsg := fnd_message.get||FND_CONST.NEWLINE;
1226:

Line 1238: x_retcode := FND_API.G_RET_STS_ERROR;

1234:
1235: -- Validate transfer quantity
1236: IF p_transfer_qty IS NULL OR p_transfer_qty <= 0 THEN
1237:
1238: x_retcode := FND_API.G_RET_STS_ERROR;
1239:
1240: fnd_message.set_name('FLM','FLM_ATTRIBUTE_INVALID');
1241: fnd_message.set_token('ATTRIBUTE', 'Transfer Quantity');
1242: x_errmsg := x_errmsg || fnd_message.get || FND_CONST.NEWLINE;

Line 1252: x_retcode := FND_API.G_RET_STS_ERROR;

1248: FETCH c_item_details INTO l_item_details_rec;
1249: CLOSE c_item_details;
1250:
1251: IF l_item_details_rec.lot_control_code <> 1 OR l_item_details_rec.serial_number_control_code <> 1 THEN
1252: x_retcode := FND_API.G_RET_STS_ERROR;
1253: fnd_message.set_name('FLM', 'FLM_EKB_LOT_SERIAL_ERR');
1254: x_errmsg := x_errmsg || fnd_message.get || FND_CONST.NEWLINE;
1255: END IF;
1256:

Line 1261: x_retcode := FND_API.G_RET_STS_ERROR;

1257: -- Validate tolerance value
1258: l_tolerance_param := flm_kanban_config_params.get_tol_kanban_transfer(l_kanban_detail_rec.organization_id);
1259: IF l_tolerance_param NOT IN (1, 2, 3) THEN
1260:
1261: x_retcode := FND_API.G_RET_STS_ERROR;
1262:
1263: fnd_message.set_name('FLM','FLM_TOLERANCE_PARAM_ERR');
1264: x_errmsg := x_errmsg || fnd_message.get || FND_CONST.NEWLINE;
1265:

Line 1271: x_retcode := FND_API.G_RET_STS_ERROR;

1267:
1268: -- Validate card status for 'Active'
1269: IF l_kanban_detail_rec.card_status <> INV_KANBAN_PVT.G_Card_Status_Active THEN
1270:
1271: x_retcode := FND_API.G_RET_STS_ERROR;
1272:
1273: fnd_message.set_name('FLM','FLM_INVALID_CARD_STATUS');
1274: x_errmsg := x_errmsg || fnd_message.get || FND_CONST.NEWLINE;
1275:

Line 1281: x_retcode := FND_API.G_RET_STS_ERROR;

1277:
1278: -- Validate source type for Inter Org / Intra Org
1279: IF l_kanban_detail_rec.source_type NOT IN (INV_KANBAN_PVT.G_Source_Type_InterOrg, INV_KANBAN_PVT.G_Source_Type_IntraOrg) THEN
1280:
1281: x_retcode := FND_API.G_RET_STS_ERROR;
1282:
1283: fnd_message.set_name('FLM','FLM_NO_KANBAN_TYPE');
1284: x_errmsg := x_errmsg || fnd_message.get || FND_CONST.NEWLINE;
1285:

Line 1288: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

1284: x_errmsg := x_errmsg || fnd_message.get || FND_CONST.NEWLINE;
1285:
1286: END IF;
1287:
1288: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
1289: RETURN;
1290: END IF;
1291:
1292:

Line 1301: x_retcode := FND_API.G_RET_STS_ERROR;

1297: CLOSE c_inter_order;
1298:
1299: IF l_inter_order_rec.order_number IS NULL THEN
1300:
1301: x_retcode := FND_API.G_RET_STS_ERROR;
1302:
1303: fnd_message.set_name('FLM','FLM_INTER_ORDERNUM_ERR');
1304: x_errmsg := fnd_message.get;
1305:

Line 1316: x_retcode := FND_API.G_RET_STS_ERROR;

1312: x_line_id :=l_inter_order_rec.line_id;
1313:
1314: IF l_tolerance_param = 2 AND p_transfer_qty <> l_kanban_detail_rec.kanban_size THEN
1315:
1316: x_retcode := FND_API.G_RET_STS_ERROR;
1317:
1318: fnd_message.set_name('FLM','FLM_SHIPMENT_DISALLOWED');
1319: fnd_message.set_token('ORDER_NUMBER', x_inter_order_num);
1320: fnd_message.set_token('TOLERANCE_QUANTITY', l_kanban_detail_rec.kanban_size);

Line 1338: x_retcode := FND_API.G_RET_STS_ERROR;

1334: END IF;
1335:
1336: IF p_transfer_qty > l_tolerance_above_size THEN
1337:
1338: x_retcode := FND_API.G_RET_STS_ERROR;
1339:
1340: fnd_message.set_name('FLM','FLM_SHIP_TOLERANCE_ERR');
1341: fnd_message.set_token('ORDER_NUMBER', x_inter_order_num);
1342: fnd_message.set_token('TOLERANCE_QUANTITY', l_tolerance_above_size);

Line 1361: x_retcode := FND_API.G_RET_STS_ERROR;

1357: CLOSE c_intra_order;
1358:
1359: IF l_intra_order_rec.request_number IS NULL THEN
1360:
1361: x_retcode := FND_API.G_RET_STS_ERROR;
1362:
1363: fnd_message.set_name('FLM','FLM_INTRA_ORDERNUM_ERR');
1364: x_errmsg := fnd_message.get;
1365:

Line 1374: x_retcode := FND_API.G_RET_STS_ERROR;

1370: x_intra_line_id := l_intra_order_rec.line_id;
1371:
1372: IF l_tolerance_param = 2 AND p_transfer_qty <> l_kanban_detail_rec.kanban_size THEN
1373:
1374: x_retcode := FND_API.G_RET_STS_ERROR;
1375:
1376: fnd_message.set_name('FLM','FLM_SHIPMENT_DISALLOWED');
1377: fnd_message.set_token('ORDER_NUMBER', x_intra_order_num);
1378: fnd_message.set_token('TOLERANCE_QUANTITY', l_kanban_detail_rec.kanban_size);

Line 1387: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

1383: END IF;
1384:
1385: END IF; -- l_kanban_detail_rec.source_type
1386:
1387: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
1388: RETURN;
1389: END IF;
1390:
1391:

Line 1426: x_retcode := FND_API.G_RET_STS_ERROR;

1422: -- Check if the Transfer Qty > Available to Transact
1423: -- ***********************************************************************************
1424: IF l_available_to_transact < p_transfer_qty OR l_available_to_transact IS NULL THEN
1425:
1426: x_retcode := FND_API.G_RET_STS_ERROR;
1427:
1428: fnd_message.set_name('FLM','FLM_TRANS_QTY_ERR');
1429: x_errmsg := x_errmsg || fnd_message.get || FND_CONST.NEWLINE;
1430:

Line 1452: x_retcode := FND_API.G_RET_STS_UNEXP_ERROR;

1448: END IF;
1449:
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: x_retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1453: x_errmsg := SQLERRM;
1454:
1455: END validate_data;
1456:

Line 1550: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN

1546: 'x_retcode = ' || x_retcode || ', ' ||
1547: 'x_errmsg = ' || x_errmsg);
1548: END IF;
1549:
1550: IF x_retcode <> FND_API.G_RET_STS_SUCCESS THEN
1551: RETURN;
1552: END IF;
1553:
1554: IF p_process_flag = 'Y' THEN

Line 1621: x_retcode := FND_API.G_RET_STS_UNEXP_ERROR;

1617:
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: ROLLBACK TO complete_process;
1621: x_retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1622: x_errmsg := SQLERRM;
1623:
1624: END complete_process;
1625: