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.WMS_POST_ALLOCATION dependencies on FND_API

Line 142: x_return_status := fnd_api.g_ret_sts_success;

138: )
139: GROUP BY mmtt.inventory_item_id;
140:
141: BEGIN
142: x_return_status := fnd_api.g_ret_sts_success;
143:
144: SAVEPOINT cr_sub_batch_sp;
145:
146: IF g_debug = 1 THEN

Line 315: RAISE fnd_api.g_exc_unexpected_error;

311: ELSE --{
312: IF g_debug = 1 THEN
313: print_debug('Invalid worker type: ' || p_mode, l_api_name);
314: END IF;
315: RAISE fnd_api.g_exc_unexpected_error;
316: END IF; --}
317:
318: IF g_debug = 1 THEN
319: print_debug('Number of sub-batches: ' || l_num_sub_batches, l_api_name);

Line 326: WHEN fnd_api.g_exc_error THEN

322:
323: COMMIT;
324:
325: EXCEPTION
326: WHEN fnd_api.g_exc_error THEN
327: ROLLBACK TO cr_sub_batch_sp;
328: x_return_status := fnd_api.g_ret_sts_error;
329: fnd_msg_pub.count_and_get
330: ( p_count => l_msg_count

Line 328: x_return_status := fnd_api.g_ret_sts_error;

324:
325: EXCEPTION
326: WHEN fnd_api.g_exc_error THEN
327: ROLLBACK TO cr_sub_batch_sp;
328: x_return_status := fnd_api.g_ret_sts_error;
329: fnd_msg_pub.count_and_get
330: ( p_count => l_msg_count
331: , p_data => l_msg_data
332: , p_encoded => fnd_api.g_false

Line 332: , p_encoded => fnd_api.g_false

328: x_return_status := fnd_api.g_ret_sts_error;
329: fnd_msg_pub.count_and_get
330: ( p_count => l_msg_count
331: , p_data => l_msg_data
332: , p_encoded => fnd_api.g_false
333: );
334: IF g_debug = 1 THEN
335: print_debug (l_msg_data, l_api_name);
336: END IF;

Line 352: x_return_status := fnd_api.g_ret_sts_unexp_error;

348: END IF;
349:
350: WHEN OTHERS THEN
351: ROLLBACK TO cr_sub_batch_sp;
352: x_return_status := fnd_api.g_ret_sts_unexp_error;
353: IF g_debug = 1 THEN
354: print_debug ('Other error: ' || SQLERRM, l_api_name);
355: END IF;
356: IF c_wpr_carton_labels%ISOPEN THEN

Line 392: x_return_status := fnd_api.g_ret_sts_success;

388: l_sub_request BOOLEAN := TRUE;
389: l_request_id NUMBER;
390:
391: BEGIN
392: x_return_status := fnd_api.g_ret_sts_success;
393:
394: -- Need to pause the parent request if doing operation plan assignment,
395: -- task type assignment, or label printing with auto-pick-confirm = Y
396: IF (p_mode = 'LABEL' AND p_auto_pick_confirm = 'Y')

Line 428: RAISE fnd_api.g_exc_unexpected_error;

424: IF g_debug = 1 THEN
425: print_debug( 'Request submission failed for worker ' || ii
426: , l_api_name);
427: END IF;
428: RAISE fnd_api.g_exc_unexpected_error;
429: ELSE
430: IF g_debug = 1 THEN
431: print_debug( 'Request ' || l_request_id ||
432: ' submitted successfully' , l_api_name);

Line 450: WHEN fnd_api.g_exc_error THEN

446: p_mode);
447: END IF;
448:
449: EXCEPTION
450: WHEN fnd_api.g_exc_error THEN
451: x_return_status := fnd_api.g_ret_sts_error;
452: fnd_msg_pub.count_and_get
453: ( p_count => l_msg_count
454: , p_data => l_msg_data

Line 451: x_return_status := fnd_api.g_ret_sts_error;

447: END IF;
448:
449: EXCEPTION
450: WHEN fnd_api.g_exc_error THEN
451: x_return_status := fnd_api.g_ret_sts_error;
452: fnd_msg_pub.count_and_get
453: ( p_count => l_msg_count
454: , p_data => l_msg_data
455: , p_encoded => fnd_api.g_false

Line 455: , p_encoded => fnd_api.g_false

451: x_return_status := fnd_api.g_ret_sts_error;
452: fnd_msg_pub.count_and_get
453: ( p_count => l_msg_count
454: , p_data => l_msg_data
455: , p_encoded => fnd_api.g_false
456: );
457: IF g_debug = 1 THEN
458: print_debug (l_msg_data, l_api_name);
459: END IF;

Line 462: x_return_status := fnd_api.g_ret_sts_unexp_error;

458: print_debug (l_msg_data, l_api_name);
459: END IF;
460:
461: WHEN OTHERS THEN
462: x_return_status := fnd_api.g_ret_sts_unexp_error;
463: IF g_debug = 1 THEN
464: print_debug ('Other error: ' || SQLERRM, l_api_name);
465: END IF;
466: END spawn_workers;

Line 505: x_return_status := fnd_api.g_ret_sts_success;

501: AND wop.enabled_flag = 'Y'
502: );
503:
504: BEGIN
505: x_return_status := fnd_api.g_ret_sts_success;
506: x_sub_requests := 'N'; --BUG10325405
507:
508: SAVEPOINT op_plan_assign_sp;
509:

Line 540: l_api_return_status := fnd_api.g_ret_sts_success;

536: print_debug('BUG10325405 in assign operations plan after setting the sub_requests value to Y', l_api_name);
537: END IF;
538:
539: IF p_create_sub_batches = 'Y' THEN --{
540: l_api_return_status := fnd_api.g_ret_sts_success;
541: create_sub_batches
542: ( p_organization_id => p_organization_id
543: , p_mo_header_id => p_mo_header_id
544: , p_batch_id => p_batch_id

Line 550: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

546: , x_return_status => l_api_return_status
547: , x_num_sub_batches => l_num_sub_batches
548: );
549:
550: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
551: IF g_debug = 1 THEN
552: print_debug('Error status from create_sub_batches: '
553: || l_api_return_status, l_api_name);
554: END IF;

Line 555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

551: IF g_debug = 1 THEN
552: print_debug('Error status from create_sub_batches: '
553: || l_api_return_status, l_api_name);
554: END IF;
555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
556: RAISE fnd_api.g_exc_error;
557: ELSE
558: RAISE fnd_api.g_exc_unexpected_error;
559: END IF;

Line 556: RAISE fnd_api.g_exc_error;

552: print_debug('Error status from create_sub_batches: '
553: || l_api_return_status, l_api_name);
554: END IF;
555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
556: RAISE fnd_api.g_exc_error;
557: ELSE
558: RAISE fnd_api.g_exc_unexpected_error;
559: END IF;
560: END IF;

Line 558: RAISE fnd_api.g_exc_unexpected_error;

554: END IF;
555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
556: RAISE fnd_api.g_exc_error;
557: ELSE
558: RAISE fnd_api.g_exc_unexpected_error;
559: END IF;
560: END IF;
561: END IF; --}
562:

Line 563: l_api_return_status := fnd_api.g_ret_sts_success;

559: END IF;
560: END IF;
561: END IF; --}
562:
563: l_api_return_status := fnd_api.g_ret_sts_success;
564: spawn_workers
565: ( p_batch_id => p_batch_id
566: , p_mode => 'OPA'
567: , p_num_workers => LEAST(l_num_sub_batches,g_num_workers)

Line 573: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

569: , p_auto_pick_confirm => 'N'
570: , x_return_status => l_api_return_status
571: );
572:
573: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
574: IF g_debug = 1 THEN
575: print_debug('Error status from spawn_workers: '
576: || l_api_return_status, l_api_name);
577: END IF;

Line 578: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

574: IF g_debug = 1 THEN
575: print_debug('Error status from spawn_workers: '
576: || l_api_return_status, l_api_name);
577: END IF;
578: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
579: RAISE fnd_api.g_exc_error;
580: ELSE
581: RAISE fnd_api.g_exc_unexpected_error;
582: END IF;

Line 579: RAISE fnd_api.g_exc_error;

575: print_debug('Error status from spawn_workers: '
576: || l_api_return_status, l_api_name);
577: END IF;
578: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
579: RAISE fnd_api.g_exc_error;
580: ELSE
581: RAISE fnd_api.g_exc_unexpected_error;
582: END IF;
583: END IF;

Line 581: RAISE fnd_api.g_exc_unexpected_error;

577: END IF;
578: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
579: RAISE fnd_api.g_exc_error;
580: ELSE
581: RAISE fnd_api.g_exc_unexpected_error;
582: END IF;
583: END IF;
584: --}
585: ELSE

Line 603: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

599: ELSE
600: IF g_debug = 1 THEN
601: print_debug ( 'Error setting cache for organization', l_api_name );
602: END IF;
603: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606: IF g_debug = 1 THEN
607: print_debug ('l_op_plan_id value: ' || l_op_plan_id, l_api_name);

Line 618: WHEN fnd_api.g_exc_error THEN

614:
615: COMMIT;
616:
617: EXCEPTION
618: WHEN fnd_api.g_exc_error THEN
619: ROLLBACK TO op_plan_assign_sp;
620: x_return_status := fnd_api.g_ret_sts_error;
621: fnd_msg_pub.count_and_get
622: ( p_count => l_msg_count

Line 620: x_return_status := fnd_api.g_ret_sts_error;

616:
617: EXCEPTION
618: WHEN fnd_api.g_exc_error THEN
619: ROLLBACK TO op_plan_assign_sp;
620: x_return_status := fnd_api.g_ret_sts_error;
621: fnd_msg_pub.count_and_get
622: ( p_count => l_msg_count
623: , p_data => l_msg_data
624: , p_encoded => fnd_api.g_false

Line 624: , p_encoded => fnd_api.g_false

620: x_return_status := fnd_api.g_ret_sts_error;
621: fnd_msg_pub.count_and_get
622: ( p_count => l_msg_count
623: , p_data => l_msg_data
624: , p_encoded => fnd_api.g_false
625: );
626: IF g_debug = 1 THEN
627: print_debug (l_msg_data, l_api_name);
628: END IF;

Line 636: x_return_status := fnd_api.g_ret_sts_unexp_error;

632: END IF;
633:
634: WHEN OTHERS THEN
635: ROLLBACK TO op_plan_assign_sp;
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: IF g_debug = 1 THEN
638: print_debug ('Other error: ' || SQLERRM, l_api_name);
639: END IF;
640:

Line 680: x_return_status := fnd_api.g_ret_sts_success;

676: AND rules.enabled_flag = 'Y'
677: );
678:
679: BEGIN
680: x_return_status := fnd_api.g_ret_sts_success;
681: x_sub_requests := 'N'; --BUG10325405
682: SAVEPOINT ttype_assign_sp;
683:
684: IF g_debug = 1 THEN

Line 713: l_api_return_status := fnd_api.g_ret_sts_success;

709: END IF;
710:
711: l_num_sub_batches := g_num_workers;
712: IF p_create_sub_batches = 'Y' THEN --{
713: l_api_return_status := fnd_api.g_ret_sts_success;
714: create_sub_batches
715: ( p_organization_id => p_organization_id
716: , p_mo_header_id => p_mo_header_id
717: , p_batch_id => p_batch_id

Line 723: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

719: , x_return_status => l_api_return_status
720: , x_num_sub_batches => l_num_sub_batches
721: );
722:
723: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
724: IF g_debug = 1 THEN
725: print_debug('Error status from create_sub_batches: '
726: || l_api_return_status, l_api_name);
727: END IF;

Line 728: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

724: IF g_debug = 1 THEN
725: print_debug('Error status from create_sub_batches: '
726: || l_api_return_status, l_api_name);
727: END IF;
728: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
729: RAISE fnd_api.g_exc_error;
730: ELSE
731: RAISE fnd_api.g_exc_unexpected_error;
732: END IF;

Line 729: RAISE fnd_api.g_exc_error;

725: print_debug('Error status from create_sub_batches: '
726: || l_api_return_status, l_api_name);
727: END IF;
728: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
729: RAISE fnd_api.g_exc_error;
730: ELSE
731: RAISE fnd_api.g_exc_unexpected_error;
732: END IF;
733: END IF;

Line 731: RAISE fnd_api.g_exc_unexpected_error;

727: END IF;
728: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
729: RAISE fnd_api.g_exc_error;
730: ELSE
731: RAISE fnd_api.g_exc_unexpected_error;
732: END IF;
733: END IF;
734: END IF; --}
735:

Line 736: l_api_return_status := fnd_api.g_ret_sts_success;

732: END IF;
733: END IF;
734: END IF; --}
735:
736: l_api_return_status := fnd_api.g_ret_sts_success;
737: spawn_workers
738: ( p_batch_id => p_batch_id
739: , p_mode => 'TTA'
740: , p_num_workers => LEAST(l_num_sub_batches,g_num_workers)

Line 746: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

742: , p_auto_pick_confirm => 'N'
743: , x_return_status => l_api_return_status
744: );
745:
746: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
747: IF g_debug = 1 THEN
748: print_debug('Error status from spawn_workers: '
749: || l_api_return_status, l_api_name);
750: END IF;

Line 751: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

747: IF g_debug = 1 THEN
748: print_debug('Error status from spawn_workers: '
749: || l_api_return_status, l_api_name);
750: END IF;
751: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
752: RAISE fnd_api.g_exc_error;
753: ELSE
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;

Line 752: RAISE fnd_api.g_exc_error;

748: print_debug('Error status from spawn_workers: '
749: || l_api_return_status, l_api_name);
750: END IF;
751: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
752: RAISE fnd_api.g_exc_error;
753: ELSE
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;
756: END IF;

Line 754: RAISE fnd_api.g_exc_unexpected_error;

750: END IF;
751: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
752: RAISE fnd_api.g_exc_error;
753: ELSE
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;
756: END IF;
757: --}
758: ELSE

Line 775: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

771: ELSE
772: IF g_debug = 1 THEN
773: print_debug ( 'Error setting cache for organization', l_api_name );
774: END IF;
775: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: IF g_debug = 1 THEN
779: print_debug ('l_ttype_id value: ' || l_ttype_id, l_api_name);

Line 790: WHEN fnd_api.g_exc_error THEN

786:
787: COMMIT;
788:
789: EXCEPTION
790: WHEN fnd_api.g_exc_error THEN
791: ROLLBACK TO ttype_assign_sp;
792: x_return_status := fnd_api.g_ret_sts_error;
793: fnd_msg_pub.count_and_get
794: ( p_count => l_msg_count

Line 792: x_return_status := fnd_api.g_ret_sts_error;

788:
789: EXCEPTION
790: WHEN fnd_api.g_exc_error THEN
791: ROLLBACK TO ttype_assign_sp;
792: x_return_status := fnd_api.g_ret_sts_error;
793: fnd_msg_pub.count_and_get
794: ( p_count => l_msg_count
795: , p_data => l_msg_data
796: , p_encoded => fnd_api.g_false

Line 796: , p_encoded => fnd_api.g_false

792: x_return_status := fnd_api.g_ret_sts_error;
793: fnd_msg_pub.count_and_get
794: ( p_count => l_msg_count
795: , p_data => l_msg_data
796: , p_encoded => fnd_api.g_false
797: );
798: IF g_debug = 1 THEN
799: print_debug (l_msg_data, l_api_name);
800: END IF;

Line 808: x_return_status := fnd_api.g_ret_sts_unexp_error;

804: END IF;
805:
806: WHEN OTHERS THEN
807: ROLLBACK TO ttype_assign_sp;
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: IF g_debug = 1 THEN
810: print_debug ('Other error: ' || SQLERRM, l_api_name);
811: END IF;
812:

Line 881: x_return_status := fnd_api.g_ret_sts_success;

877: )
878: );
879:
880: BEGIN
881: x_return_status := fnd_api.g_ret_sts_success;
882: x_sub_requests := 'N'; --BUG10325405
883: SAVEPOINT label_print_sp;
884:
885: IF g_debug = 1 THEN

Line 914: l_api_return_status := fnd_api.g_ret_sts_success;

910: print_debug('BUG10325405 in print labels after setting the sub_requests value to Y', l_api_name);
911: END IF;
912: l_num_sub_batches := g_num_workers;
913: IF p_create_sub_batches = 'Y' THEN --{
914: l_api_return_status := fnd_api.g_ret_sts_success;
915: create_sub_batches
916: ( p_organization_id => p_organization_id
917: , p_mo_header_id => p_mo_header_id
918: , p_batch_id => p_batch_id

Line 924: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

920: , x_return_status => l_api_return_status
921: , x_num_sub_batches => l_num_sub_batches
922: );
923:
924: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
925: IF g_debug = 1 THEN
926: print_debug('Error status from create_sub_batches: '
927: || l_api_return_status, l_api_name);
928: END IF;

Line 929: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

925: IF g_debug = 1 THEN
926: print_debug('Error status from create_sub_batches: '
927: || l_api_return_status, l_api_name);
928: END IF;
929: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
930: RAISE fnd_api.g_exc_error;
931: ELSE
932: RAISE fnd_api.g_exc_unexpected_error;
933: END IF;

Line 930: RAISE fnd_api.g_exc_error;

926: print_debug('Error status from create_sub_batches: '
927: || l_api_return_status, l_api_name);
928: END IF;
929: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
930: RAISE fnd_api.g_exc_error;
931: ELSE
932: RAISE fnd_api.g_exc_unexpected_error;
933: END IF;
934: END IF;

Line 932: RAISE fnd_api.g_exc_unexpected_error;

928: END IF;
929: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
930: RAISE fnd_api.g_exc_error;
931: ELSE
932: RAISE fnd_api.g_exc_unexpected_error;
933: END IF;
934: END IF;
935: END IF; --}
936:

Line 937: l_api_return_status := fnd_api.g_ret_sts_success;

933: END IF;
934: END IF;
935: END IF; --}
936:
937: l_api_return_status := fnd_api.g_ret_sts_success;
938: spawn_workers
939: ( p_batch_id => p_batch_id
940: , p_mode => 'LABEL'
941: , p_num_workers => LEAST(l_num_sub_batches,g_num_workers)

Line 947: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

943: , p_auto_pick_confirm => p_auto_pick_confirm
944: , x_return_status => l_api_return_status
945: );
946:
947: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
948: IF g_debug = 1 THEN
949: print_debug('Error status from spawn_workers: '
950: || l_api_return_status, l_api_name);
951: END IF;

Line 952: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

948: IF g_debug = 1 THEN
949: print_debug('Error status from spawn_workers: '
950: || l_api_return_status, l_api_name);
951: END IF;
952: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
953: RAISE fnd_api.g_exc_error;
954: ELSE
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;

Line 953: RAISE fnd_api.g_exc_error;

949: print_debug('Error status from spawn_workers: '
950: || l_api_return_status, l_api_name);
951: END IF;
952: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
953: RAISE fnd_api.g_exc_error;
954: ELSE
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;
957: END IF;

Line 955: RAISE fnd_api.g_exc_unexpected_error;

951: END IF;
952: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
953: RAISE fnd_api.g_exc_error;
954: ELSE
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;
957: END IF;
958: --}
959: ELSE

Line 973: WHEN fnd_api.g_exc_error THEN

969:
970: COMMIT;
971:
972: EXCEPTION
973: WHEN fnd_api.g_exc_error THEN
974: ROLLBACK TO label_print_sp;
975: x_return_status := fnd_api.g_ret_sts_error;
976: fnd_msg_pub.count_and_get
977: ( p_count => l_msg_count

Line 975: x_return_status := fnd_api.g_ret_sts_error;

971:
972: EXCEPTION
973: WHEN fnd_api.g_exc_error THEN
974: ROLLBACK TO label_print_sp;
975: x_return_status := fnd_api.g_ret_sts_error;
976: fnd_msg_pub.count_and_get
977: ( p_count => l_msg_count
978: , p_data => l_msg_data
979: , p_encoded => fnd_api.g_false

Line 979: , p_encoded => fnd_api.g_false

975: x_return_status := fnd_api.g_ret_sts_error;
976: fnd_msg_pub.count_and_get
977: ( p_count => l_msg_count
978: , p_data => l_msg_data
979: , p_encoded => fnd_api.g_false
980: );
981: IF g_debug = 1 THEN
982: print_debug (l_msg_data, l_api_name);
983: END IF;

Line 991: x_return_status := fnd_api.g_ret_sts_unexp_error;

987: END IF;
988:
989: WHEN OTHERS THEN
990: ROLLBACK TO label_print_sp;
991: x_return_status := fnd_api.g_ret_sts_unexp_error;
992: IF g_debug = 1 THEN
993: print_debug ('Other error: ' || SQLERRM, l_api_name);
994: END IF;
995:

Line 1031: l_api_return_status := fnd_api.g_ret_sts_success;

1027: 'p_worker_id => ' || TO_CHAR(p_worker_id)
1028: , l_api_name);
1029: END IF;
1030:
1031: l_api_return_status := fnd_api.g_ret_sts_success;
1032: IF p_mode = 'OPA' THEN
1033: WMS_POSTALLOC_PVT.assign_operation_plans
1034: ( p_batch_id => p_batch_id
1035: , x_return_status => l_api_return_status

Line 1051: RAISE fnd_api.g_exc_unexpected_error;

1047: ELSE
1048: IF g_debug = 1 THEN
1049: print_debug('Invalid worker type: ' || p_mode, l_api_name);
1050: END IF;
1051: RAISE fnd_api.g_exc_unexpected_error;
1052: END IF;
1053:
1054: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1055: IF g_debug = 1 THEN

Line 1054: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1050: END IF;
1051: RAISE fnd_api.g_exc_unexpected_error;
1052: END IF;
1053:
1054: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1055: IF g_debug = 1 THEN
1056: print_debug('Error status from WMS_POSTALLOC_PVT API: '
1057: || l_api_return_status, l_api_name);
1058: END IF;

Line 1059: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1055: IF g_debug = 1 THEN
1056: print_debug('Error status from WMS_POSTALLOC_PVT API: '
1057: || l_api_return_status, l_api_name);
1058: END IF;
1059: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1060: RAISE fnd_api.g_exc_error;
1061: ELSE
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;

Line 1060: RAISE fnd_api.g_exc_error;

1056: print_debug('Error status from WMS_POSTALLOC_PVT API: '
1057: || l_api_return_status, l_api_name);
1058: END IF;
1059: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1060: RAISE fnd_api.g_exc_error;
1061: ELSE
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064: END IF;

Line 1062: RAISE fnd_api.g_exc_unexpected_error;

1058: END IF;
1059: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1060: RAISE fnd_api.g_exc_error;
1061: ELSE
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064: END IF;
1065:
1066: l_conc_ret_status := fnd_concurrent.set_completion_status('NORMAL','');

Line 1071: RAISE fnd_api.g_exc_unexpected_error;

1067: IF NOT l_conc_ret_status THEN
1068: IF g_debug = 1 THEN
1069: print_debug('Error setting concurrent return status to NORMAL', l_api_name);
1070: END IF;
1071: RAISE fnd_api.g_exc_unexpected_error;
1072: END IF;
1073:
1074: EXCEPTION
1075: WHEN fnd_api.g_exc_error THEN

Line 1075: WHEN fnd_api.g_exc_error THEN

1071: RAISE fnd_api.g_exc_unexpected_error;
1072: END IF;
1073:
1074: EXCEPTION
1075: WHEN fnd_api.g_exc_error THEN
1076: fnd_msg_pub.count_and_get
1077: ( p_count => l_msg_count
1078: , p_data => l_msg_data
1079: , p_encoded => fnd_api.g_false

Line 1079: , p_encoded => fnd_api.g_false

1075: WHEN fnd_api.g_exc_error THEN
1076: fnd_msg_pub.count_and_get
1077: ( p_count => l_msg_count
1078: , p_data => l_msg_data
1079: , p_encoded => fnd_api.g_false
1080: );
1081: IF g_debug = 1 THEN
1082: print_debug (l_msg_data, l_api_name);
1083: END IF;

Line 1158: x_return_status := fnd_api.g_ret_sts_success;

1154: l_msg_count NUMBER;
1155: l_msg_data VARCHAR2(2000);
1156:
1157: BEGIN
1158: x_return_status := fnd_api.g_ret_sts_success;
1159:
1160: SAVEPOINT task_release_sp;
1161:
1162: IF g_debug = 1 THEN

Line 1186: WHEN fnd_api.g_exc_error THEN

1182:
1183: COMMIT;
1184:
1185: EXCEPTION
1186: WHEN fnd_api.g_exc_error THEN
1187: x_return_status := fnd_api.g_ret_sts_error;
1188: ROLLBACK TO task_release_sp;
1189: fnd_msg_pub.count_and_get
1190: ( p_count => l_msg_count

Line 1187: x_return_status := fnd_api.g_ret_sts_error;

1183: COMMIT;
1184:
1185: EXCEPTION
1186: WHEN fnd_api.g_exc_error THEN
1187: x_return_status := fnd_api.g_ret_sts_error;
1188: ROLLBACK TO task_release_sp;
1189: fnd_msg_pub.count_and_get
1190: ( p_count => l_msg_count
1191: , p_data => l_msg_data

Line 1192: , p_encoded => fnd_api.g_false

1188: ROLLBACK TO task_release_sp;
1189: fnd_msg_pub.count_and_get
1190: ( p_count => l_msg_count
1191: , p_data => l_msg_data
1192: , p_encoded => fnd_api.g_false
1193: );
1194: IF g_debug = 1 THEN
1195: print_debug (l_msg_data, l_api_name);
1196: END IF;

Line 1199: x_return_status := fnd_api.g_ret_sts_unexp_error;

1195: print_debug (l_msg_data, l_api_name);
1196: END IF;
1197:
1198: WHEN OTHERS THEN
1199: x_return_status := fnd_api.g_ret_sts_unexp_error;
1200: ROLLBACK TO task_release_sp;
1201: IF g_debug = 1 THEN
1202: print_debug ('Other error: ' || SQLERRM, l_api_name);
1203: END IF;

Line 1235: x_return_status := fnd_api.g_ret_sts_success;

1231: l_sub_requests VARCHAR2(1) := 'N' ; --BUG10325405
1232:
1233:
1234: BEGIN
1235: x_return_status := fnd_api.g_ret_sts_success;
1236: x_org_complete := 'N';
1237:
1238: IF g_debug = 1 THEN
1239: print_debug( 'Entered with parameters: ' || g_newline ||

Line 1261: RAISE fnd_api.g_exc_unexpected_error;

1257: THEN
1258: IF g_debug = 1 THEN
1259: print_debug('Required input is missing.', l_api_name);
1260: END IF;
1261: RAISE fnd_api.g_exc_unexpected_error;
1262: END IF;
1263:
1264: IF p_plan_tasks = 'Y' THEN
1265: g_plan_tasks := TRUE;

Line 1279: l_api_return_status := fnd_api.g_ret_sts_success;

1275: IF g_single_threaded OR
1276: p_wsh_mode IS NULL OR
1277: p_num_workers < 2
1278: THEN --{
1279: l_api_return_status := fnd_api.g_ret_sts_success;
1280: inv_pick_release_pub.call_cartonization
1281: ( p_api_version => 1.0
1282: , p_init_msg_list => FND_API.G_FALSE
1283: , p_commit => FND_API.G_FALSE

Line 1282: , p_init_msg_list => FND_API.G_FALSE

1278: THEN --{
1279: l_api_return_status := fnd_api.g_ret_sts_success;
1280: inv_pick_release_pub.call_cartonization
1281: ( p_api_version => 1.0
1282: , p_init_msg_list => FND_API.G_FALSE
1283: , p_commit => FND_API.G_FALSE
1284: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1285: , p_out_bound => 'Y'
1286: , p_org_id => p_organization_id

Line 1283: , p_commit => FND_API.G_FALSE

1279: l_api_return_status := fnd_api.g_ret_sts_success;
1280: inv_pick_release_pub.call_cartonization
1281: ( p_api_version => 1.0
1282: , p_init_msg_list => FND_API.G_FALSE
1283: , p_commit => FND_API.G_FALSE
1284: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1285: , p_out_bound => 'Y'
1286: , p_org_id => p_organization_id
1287: , p_move_order_header_id => p_mo_header_id

Line 1284: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1280: inv_pick_release_pub.call_cartonization
1281: ( p_api_version => 1.0
1282: , p_init_msg_list => FND_API.G_FALSE
1283: , p_commit => FND_API.G_FALSE
1284: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1285: , p_out_bound => 'Y'
1286: , p_org_id => p_organization_id
1287: , p_move_order_header_id => p_mo_header_id
1288: , p_grouping_rule_id => p_grouping_rule_id

Line 1289: , p_allow_partial_pick => FND_API.G_TRUE

1285: , p_out_bound => 'Y'
1286: , p_org_id => p_organization_id
1287: , p_move_order_header_id => p_mo_header_id
1288: , p_grouping_rule_id => p_grouping_rule_id
1289: , p_allow_partial_pick => FND_API.G_TRUE
1290: , x_return_status => l_api_return_status
1291: , x_msg_count => l_msg_count
1292: , x_msg_data => l_msg_data
1293: );

Line 1294: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1290: , x_return_status => l_api_return_status
1291: , x_msg_count => l_msg_count
1292: , x_msg_data => l_msg_data
1293: );
1294: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1295: IF g_debug = 1 THEN
1296: print_debug('Error status from call_cartonization: '
1297: || l_api_return_status, l_api_name);
1298: END IF;

Line 1299: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1295: IF g_debug = 1 THEN
1296: print_debug('Error status from call_cartonization: '
1297: || l_api_return_status, l_api_name);
1298: END IF;
1299: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1300: RAISE fnd_api.g_exc_error;
1301: ELSE
1302: RAISE fnd_api.g_exc_unexpected_error;
1303: END IF;

Line 1300: RAISE fnd_api.g_exc_error;

1296: print_debug('Error status from call_cartonization: '
1297: || l_api_return_status, l_api_name);
1298: END IF;
1299: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1300: RAISE fnd_api.g_exc_error;
1301: ELSE
1302: RAISE fnd_api.g_exc_unexpected_error;
1303: END IF;
1304: END IF;

Line 1302: RAISE fnd_api.g_exc_unexpected_error;

1298: END IF;
1299: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1300: RAISE fnd_api.g_exc_error;
1301: ELSE
1302: RAISE fnd_api.g_exc_unexpected_error;
1303: END IF;
1304: END IF;
1305:
1306: IF NOT g_plan_tasks THEN

Line 1307: l_api_return_status := fnd_api.g_ret_sts_success;

1303: END IF;
1304: END IF;
1305:
1306: IF NOT g_plan_tasks THEN
1307: l_api_return_status := fnd_api.g_ret_sts_success;
1308: release_tasks
1309: ( p_mo_header_id => p_mo_header_id
1310: , x_return_status => l_api_return_status
1311: );

Line 1312: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1308: release_tasks
1309: ( p_mo_header_id => p_mo_header_id
1310: , x_return_status => l_api_return_status
1311: );
1312: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1313: IF g_debug = 1 THEN
1314: print_debug('Error status from release_tasks: '
1315: || l_api_return_status, l_api_name);
1316: END IF;

Line 1317: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1313: IF g_debug = 1 THEN
1314: print_debug('Error status from release_tasks: '
1315: || l_api_return_status, l_api_name);
1316: END IF;
1317: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1318: RAISE fnd_api.g_exc_error;
1319: ELSE
1320: RAISE fnd_api.g_exc_unexpected_error;
1321: END IF;

Line 1318: RAISE fnd_api.g_exc_error;

1314: print_debug('Error status from release_tasks: '
1315: || l_api_return_status, l_api_name);
1316: END IF;
1317: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1318: RAISE fnd_api.g_exc_error;
1319: ELSE
1320: RAISE fnd_api.g_exc_unexpected_error;
1321: END IF;
1322: END IF;

Line 1320: RAISE fnd_api.g_exc_unexpected_error;

1316: END IF;
1317: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1318: RAISE fnd_api.g_exc_error;
1319: ELSE
1320: RAISE fnd_api.g_exc_unexpected_error;
1321: END IF;
1322: END IF;
1323: END IF;
1324:

Line 1344: l_api_return_status := fnd_api.g_ret_sts_success;

1340: END IF;
1341:
1342: -- Multi threaded execution: Operation Plan assignment (OPA)
1343: IF g_assign_op_plans AND p_wsh_mode IN ('PICK-SS','PICK') THEN --{
1344: l_api_return_status := fnd_api.g_ret_sts_success;
1345:
1346: assign_operation_plans
1347: ( p_organization_id => p_organization_id
1348: , p_mo_header_id => p_mo_header_id

Line 1356: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1352: , p_wsh_status => p_wsh_status
1353: , x_return_status => l_api_return_status
1354: , x_sub_requests => l_sub_requests --BUG10325405
1355: );
1356: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1357: IF g_debug = 1 THEN
1358: print_debug('Error status from assign_operation_plans: '
1359: || l_api_return_status, l_api_name);
1360: END IF;

Line 1361: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1357: IF g_debug = 1 THEN
1358: print_debug('Error status from assign_operation_plans: '
1359: || l_api_return_status, l_api_name);
1360: END IF;
1361: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1362: RAISE fnd_api.g_exc_error;
1363: ELSE
1364: RAISE fnd_api.g_exc_unexpected_error;
1365: END IF;

Line 1362: RAISE fnd_api.g_exc_error;

1358: print_debug('Error status from assign_operation_plans: '
1359: || l_api_return_status, l_api_name);
1360: END IF;
1361: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1362: RAISE fnd_api.g_exc_error;
1363: ELSE
1364: RAISE fnd_api.g_exc_unexpected_error;
1365: END IF;
1366: END IF;

Line 1364: RAISE fnd_api.g_exc_unexpected_error;

1360: END IF;
1361: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1362: RAISE fnd_api.g_exc_error;
1363: ELSE
1364: RAISE fnd_api.g_exc_unexpected_error;
1365: END IF;
1366: END IF;
1367: --
1368: -- Op plan assignment is parallelized, so skip to the end.

Line 1384: l_api_return_status := fnd_api.g_ret_sts_success;

1380: END IF; --}
1381:
1382: -- Cartonization: single threaded, starts after OPA child requests finish
1383: IF g_call_cartonization AND p_wsh_mode IN ('PICK-SS','PICK','OPA') THEN --{
1384: l_api_return_status := fnd_api.g_ret_sts_success;
1385: wms_postalloc_pvt.cartonize
1386: ( p_org_id => p_organization_id
1387: , p_move_order_header_id => p_mo_header_id
1388: , x_return_status => l_api_return_status

Line 1390: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1386: ( p_org_id => p_organization_id
1387: , p_move_order_header_id => p_mo_header_id
1388: , x_return_status => l_api_return_status
1389: );
1390: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1391: IF g_debug = 1 THEN
1392: print_debug('Error status from wms_postalloc_pvt.cartonize: '
1393: || l_api_return_status, l_api_name);
1394: END IF;

Line 1396: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1392: print_debug('Error status from wms_postalloc_pvt.cartonize: '
1393: || l_api_return_status, l_api_name);
1394: END IF;
1395: -- Continue processing even if cartonization fails
1396: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1397: -- RAISE fnd_api.g_exc_error;
1398: NULL;
1399: ELSE
1400: -- RAISE fnd_api.g_exc_unexpected_error;

Line 1397: -- RAISE fnd_api.g_exc_error;

1393: || l_api_return_status, l_api_name);
1394: END IF;
1395: -- Continue processing even if cartonization fails
1396: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1397: -- RAISE fnd_api.g_exc_error;
1398: NULL;
1399: ELSE
1400: -- RAISE fnd_api.g_exc_unexpected_error;
1401: NULL;

Line 1400: -- RAISE fnd_api.g_exc_unexpected_error;

1396: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1397: -- RAISE fnd_api.g_exc_error;
1398: NULL;
1399: ELSE
1400: -- RAISE fnd_api.g_exc_unexpected_error;
1401: NULL;
1402: END IF;
1403: END IF;
1404: END IF; --}

Line 1408: l_api_return_status := fnd_api.g_ret_sts_success;

1404: END IF; --}
1405:
1406: -- Task consolidation: single threaded
1407: IF g_consolidate_tasks AND p_wsh_mode IN ('PICK-SS','PICK','OPA') THEN --{
1408: l_api_return_status := fnd_api.g_ret_sts_success;
1409: wms_postalloc_pvt.consolidate_tasks
1410: ( p_mo_header_id => p_mo_header_id
1411: , x_return_status => l_api_return_status
1412: );

Line 1413: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1409: wms_postalloc_pvt.consolidate_tasks
1410: ( p_mo_header_id => p_mo_header_id
1411: , x_return_status => l_api_return_status
1412: );
1413: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1414: IF g_debug = 1 THEN
1415: print_debug('Error status from wms_postalloc_pvt.consolidate_tasks: '
1416: || l_api_return_status, l_api_name);
1417: END IF;

Line 1418: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1414: IF g_debug = 1 THEN
1415: print_debug('Error status from wms_postalloc_pvt.consolidate_tasks: '
1416: || l_api_return_status, l_api_name);
1417: END IF;
1418: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1419: RAISE fnd_api.g_exc_error;
1420: ELSE
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;

Line 1419: RAISE fnd_api.g_exc_error;

1415: print_debug('Error status from wms_postalloc_pvt.consolidate_tasks: '
1416: || l_api_return_status, l_api_name);
1417: END IF;
1418: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1419: RAISE fnd_api.g_exc_error;
1420: ELSE
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423: END IF;

Line 1421: RAISE fnd_api.g_exc_unexpected_error;

1417: END IF;
1418: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1419: RAISE fnd_api.g_exc_error;
1420: ELSE
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423: END IF;
1424: END IF; --}
1425:

Line 1433: l_api_return_status := fnd_api.g_ret_sts_success;

1429: l_create_sub_batches := 'N';
1430: ELSE
1431: l_create_sub_batches := 'Y';
1432: END IF;
1433: l_api_return_status := fnd_api.g_ret_sts_success;
1434:
1435: assign_task_types
1436: ( p_organization_id => p_organization_id
1437: , p_mo_header_id => p_mo_header_id

Line 1445: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1441: , p_wsh_status => p_wsh_status
1442: , x_return_status => l_api_return_status
1443: , x_sub_requests => l_sub_requests --BUG10325405
1444: );
1445: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1446: IF g_debug = 1 THEN
1447: print_debug('Error status from assign_task_types: '
1448: || l_api_return_status, l_api_name);
1449: END IF;

Line 1450: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1446: IF g_debug = 1 THEN
1447: print_debug('Error status from assign_task_types: '
1448: || l_api_return_status, l_api_name);
1449: END IF;
1450: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1451: RAISE fnd_api.g_exc_error;
1452: ELSE
1453: RAISE fnd_api.g_exc_unexpected_error;
1454: END IF;

Line 1451: RAISE fnd_api.g_exc_error;

1447: print_debug('Error status from assign_task_types: '
1448: || l_api_return_status, l_api_name);
1449: END IF;
1450: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1451: RAISE fnd_api.g_exc_error;
1452: ELSE
1453: RAISE fnd_api.g_exc_unexpected_error;
1454: END IF;
1455: END IF;

Line 1453: RAISE fnd_api.g_exc_unexpected_error;

1449: END IF;
1450: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1451: RAISE fnd_api.g_exc_error;
1452: ELSE
1453: RAISE fnd_api.g_exc_unexpected_error;
1454: END IF;
1455: END IF;
1456: -- Skip to end, and PAUSE.
1457: -- IF..END IF for BUG10325405

Line 1475: l_api_return_status := fnd_api.g_ret_sts_success;

1471: --
1472:
1473: -- Device integration: single threaded
1474: IF g_process_device_reqs AND p_wsh_mode IN ('PICK-SS','PICK','OPA','TTA') THEN --{
1475: l_api_return_status := fnd_api.g_ret_sts_success;
1476: wms_postalloc_pvt.insert_device_requests
1477: ( p_organization_id => p_organization_id
1478: , p_mo_header_id => p_mo_header_id
1479: , x_return_status => l_api_return_status

Line 1481: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1477: ( p_organization_id => p_organization_id
1478: , p_mo_header_id => p_mo_header_id
1479: , x_return_status => l_api_return_status
1480: );
1481: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1482: IF g_debug = 1 THEN
1483: print_debug('Error status from wms_postalloc_pvt.insert_device_requests: '
1484: || l_api_return_status, l_api_name);
1485: END IF;

Line 1486: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1482: IF g_debug = 1 THEN
1483: print_debug('Error status from wms_postalloc_pvt.insert_device_requests: '
1484: || l_api_return_status, l_api_name);
1485: END IF;
1486: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1487: RAISE fnd_api.g_exc_error;
1488: ELSE
1489: RAISE fnd_api.g_exc_unexpected_error;
1490: END IF;

Line 1487: RAISE fnd_api.g_exc_error;

1483: print_debug('Error status from wms_postalloc_pvt.insert_device_requests: '
1484: || l_api_return_status, l_api_name);
1485: END IF;
1486: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1487: RAISE fnd_api.g_exc_error;
1488: ELSE
1489: RAISE fnd_api.g_exc_unexpected_error;
1490: END IF;
1491: END IF;

Line 1489: RAISE fnd_api.g_exc_unexpected_error;

1485: END IF;
1486: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1487: RAISE fnd_api.g_exc_error;
1488: ELSE
1489: RAISE fnd_api.g_exc_unexpected_error;
1490: END IF;
1491: END IF;
1492: END IF; --}
1493:

Line 1496: l_api_return_status := fnd_api.g_ret_sts_success;

1492: END IF; --}
1493:
1494: -- Pick slip number assignment: single threaded
1495: IF g_assign_pick_slips AND p_wsh_mode IN ('PICK-SS','PICK','OPA','TTA') THEN --{
1496: l_api_return_status := fnd_api.g_ret_sts_success;
1497: wms_postalloc_pvt.assign_pick_slip_numbers
1498: ( p_organization_id => p_organization_id
1499: , p_mo_header_id => p_mo_header_id
1500: , p_grouping_rule_id => p_grouping_rule_id

Line 1503: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1499: , p_mo_header_id => p_mo_header_id
1500: , p_grouping_rule_id => p_grouping_rule_id
1501: , x_return_status => l_api_return_status
1502: );
1503: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1504: IF g_debug = 1 THEN
1505: print_debug('Error status from wms_postalloc_pvt.assign_pick_slip_numbers: '
1506: || l_api_return_status, l_api_name);
1507: END IF;

Line 1508: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1504: IF g_debug = 1 THEN
1505: print_debug('Error status from wms_postalloc_pvt.assign_pick_slip_numbers: '
1506: || l_api_return_status, l_api_name);
1507: END IF;
1508: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1509: RAISE fnd_api.g_exc_error;
1510: ELSE
1511: RAISE fnd_api.g_exc_unexpected_error;
1512: END IF;

Line 1509: RAISE fnd_api.g_exc_error;

1505: print_debug('Error status from wms_postalloc_pvt.assign_pick_slip_numbers: '
1506: || l_api_return_status, l_api_name);
1507: END IF;
1508: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1509: RAISE fnd_api.g_exc_error;
1510: ELSE
1511: RAISE fnd_api.g_exc_unexpected_error;
1512: END IF;
1513: END IF;

Line 1511: RAISE fnd_api.g_exc_unexpected_error;

1507: END IF;
1508: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1509: RAISE fnd_api.g_exc_error;
1510: ELSE
1511: RAISE fnd_api.g_exc_unexpected_error;
1512: END IF;
1513: END IF;
1514: END IF; --}
1515:

Line 1526: l_api_return_status := fnd_api.g_ret_sts_success;

1522: );
1523:
1524: -- Release tasks: single threaded
1525: IF NOT g_plan_tasks AND p_wsh_mode IN ('PICK-SS','PICK','OPA','TTA') THEN --{
1526: l_api_return_status := fnd_api.g_ret_sts_success;
1527: release_tasks
1528: ( p_mo_header_id => p_mo_header_id
1529: , x_return_status => l_api_return_status
1530: );

Line 1531: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1527: release_tasks
1528: ( p_mo_header_id => p_mo_header_id
1529: , x_return_status => l_api_return_status
1530: );
1531: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1532: IF g_debug = 1 THEN
1533: print_debug('Error status from release_tasks: '
1534: || l_api_return_status, l_api_name);
1535: END IF;

Line 1536: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1532: IF g_debug = 1 THEN
1533: print_debug('Error status from release_tasks: '
1534: || l_api_return_status, l_api_name);
1535: END IF;
1536: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1537: RAISE fnd_api.g_exc_error;
1538: ELSE
1539: RAISE fnd_api.g_exc_unexpected_error;
1540: END IF;

Line 1537: RAISE fnd_api.g_exc_error;

1533: print_debug('Error status from release_tasks: '
1534: || l_api_return_status, l_api_name);
1535: END IF;
1536: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1537: RAISE fnd_api.g_exc_error;
1538: ELSE
1539: RAISE fnd_api.g_exc_unexpected_error;
1540: END IF;
1541: END IF;

Line 1539: RAISE fnd_api.g_exc_unexpected_error;

1535: END IF;
1536: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1537: RAISE fnd_api.g_exc_error;
1538: ELSE
1539: RAISE fnd_api.g_exc_unexpected_error;
1540: END IF;
1541: END IF;
1542: END IF; --}
1543:

Line 1547: l_api_return_status := fnd_api.g_ret_sts_success;

1543:
1544: -- Label printing: multi-threaded. Parent process is paused
1545: -- only if we are doing auto-pick-confirm
1546: IF g_print_labels AND p_wsh_mode IN ('PICK-SS','PICK','OPA','TTA') THEN --{
1547: l_api_return_status := fnd_api.g_ret_sts_success;
1548:
1549: print_labels
1550: ( p_organization_id => p_organization_id
1551: , p_mo_header_id => p_mo_header_id

Line 1560: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1556: , p_wsh_status => p_wsh_status
1557: , x_return_status => l_api_return_status
1558: , x_sub_requests => l_sub_requests --BUG10325405
1559: );
1560: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1561: IF g_debug = 1 THEN
1562: print_debug('Error status from print_labels: '
1563: || l_api_return_status, l_api_name);
1564: END IF;

Line 1565: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1561: IF g_debug = 1 THEN
1562: print_debug('Error status from print_labels: '
1563: || l_api_return_status, l_api_name);
1564: END IF;
1565: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1566: RAISE fnd_api.g_exc_error;
1567: ELSE
1568: RAISE fnd_api.g_exc_unexpected_error;
1569: END IF;

Line 1566: RAISE fnd_api.g_exc_error;

1562: print_debug('Error status from print_labels: '
1563: || l_api_return_status, l_api_name);
1564: END IF;
1565: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1566: RAISE fnd_api.g_exc_error;
1567: ELSE
1568: RAISE fnd_api.g_exc_unexpected_error;
1569: END IF;
1570: END IF;

Line 1568: RAISE fnd_api.g_exc_unexpected_error;

1564: END IF;
1565: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1566: RAISE fnd_api.g_exc_error;
1567: ELSE
1568: RAISE fnd_api.g_exc_unexpected_error;
1569: END IF;
1570: END IF;
1571: IF g_debug = 1 THEN
1572: print_debug('BUG10325405 Before the GOTO call in label printing', l_api_name);

Line 1595: WHEN fnd_api.g_exc_error THEN

1591: <>
1592: COMMIT;
1593:
1594: EXCEPTION
1595: WHEN fnd_api.g_exc_error THEN
1596: x_return_status := fnd_api.g_ret_sts_error;
1597: fnd_msg_pub.count_and_get
1598: ( p_count => l_msg_count
1599: , p_data => l_msg_data

Line 1596: x_return_status := fnd_api.g_ret_sts_error;

1592: COMMIT;
1593:
1594: EXCEPTION
1595: WHEN fnd_api.g_exc_error THEN
1596: x_return_status := fnd_api.g_ret_sts_error;
1597: fnd_msg_pub.count_and_get
1598: ( p_count => l_msg_count
1599: , p_data => l_msg_data
1600: , p_encoded => fnd_api.g_false

Line 1600: , p_encoded => fnd_api.g_false

1596: x_return_status := fnd_api.g_ret_sts_error;
1597: fnd_msg_pub.count_and_get
1598: ( p_count => l_msg_count
1599: , p_data => l_msg_data
1600: , p_encoded => fnd_api.g_false
1601: );
1602: IF g_debug = 1 THEN
1603: print_debug (l_msg_data, l_api_name);
1604: END IF;

Line 1613: x_return_status := fnd_api.g_ret_sts_unexp_error;

1609: , p_batch_id => p_batch_id
1610: );
1611:
1612: WHEN OTHERS THEN
1613: x_return_status := fnd_api.g_ret_sts_unexp_error;
1614: IF g_debug = 1 THEN
1615: print_debug ('Other error: ' || SQLERRM, l_api_name);
1616: END IF;
1617:

Line 1712: RAISE fnd_api.g_exc_error;

1708: print_debug('Invalid number of workers: ' || g_num_workers, l_api_name);
1709: END IF;
1710: fnd_message.set_name('WMS', 'WMS_PALOC_PARALLEL_ONLY'); -- TBD
1711: fnd_msg_pub.ADD;
1712: RAISE fnd_api.g_exc_error;
1713: END IF;
1714: END IF;
1715:
1716: IF p_assign_op_plans = 2 THEN

Line 1784: RAISE fnd_api.g_exc_unexpected_error;

1780: IF g_debug = 1 THEN
1781: print_debug ('Error fetching MO header and Org attributes: '
1782: || l_error_message, l_api_name);
1783: END IF;
1784: RAISE fnd_api.g_exc_unexpected_error;
1785: END;
1786:
1787: l_batch_id := TO_NUMBER(p_pickrel_batch);
1788: IF g_debug = 1 THEN

Line 1817: RAISE fnd_api.g_exc_error;

1813: print_debug('Other running program(s) found, so return error', l_api_name);
1814: END IF;
1815: fnd_message.set_name('WMS', 'WMS_PALOC_OTHER_PROG'); -- TBD
1816: fnd_msg_pub.ADD;
1817: RAISE fnd_api.g_exc_error;
1818: EXCEPTION
1819: WHEN NO_DATA_FOUND THEN
1820: IF g_debug = 1 THEN
1821: print_debug('No conflicting programs found, so proceeding', l_api_name);

Line 1823: WHEN fnd_api.g_exc_error THEN

1819: WHEN NO_DATA_FOUND THEN
1820: IF g_debug = 1 THEN
1821: print_debug('No conflicting programs found, so proceeding', l_api_name);
1822: END IF;
1823: WHEN fnd_api.g_exc_error THEN
1824: RAISE fnd_api.g_exc_error;
1825: WHEN OTHERS THEN
1826: IF g_debug = 1 THEN
1827: print_debug( 'Error checking for conc program conflicts: ' || SQLERRM

Line 1824: RAISE fnd_api.g_exc_error;

1820: IF g_debug = 1 THEN
1821: print_debug('No conflicting programs found, so proceeding', l_api_name);
1822: END IF;
1823: WHEN fnd_api.g_exc_error THEN
1824: RAISE fnd_api.g_exc_error;
1825: WHEN OTHERS THEN
1826: IF g_debug = 1 THEN
1827: print_debug( 'Error checking for conc program conflicts: ' || SQLERRM
1828: , l_api_name);

Line 1830: RAISE fnd_api.g_exc_unexpected_error;

1826: IF g_debug = 1 THEN
1827: print_debug( 'Error checking for conc program conflicts: ' || SQLERRM
1828: , l_api_name);
1829: END IF;
1830: RAISE fnd_api.g_exc_unexpected_error;
1831: END;
1832: END IF; --}
1833: */
1834: IF l_mode IS NULL THEN --{

Line 1861: RAISE fnd_api.g_exc_error;

1857: plan_wave_error := TRUE;
1858: END IF;
1859: fnd_message.set_name('WMS', 'WMS_PALOC_NO_UNREL_TASKS'); -- TBD
1860: fnd_msg_pub.ADD;
1861: RAISE fnd_api.g_exc_error;
1862: WHEN OTHERS THEN
1863: IF g_debug = 1 THEN
1864: print_debug( 'Error when checking for unreleased tasks: ' || SQLERRM
1865: , l_api_name);

Line 1867: RAISE fnd_api.g_exc_unexpected_error;

1863: IF g_debug = 1 THEN
1864: print_debug( 'Error when checking for unreleased tasks: ' || SQLERRM
1865: , l_api_name);
1866: END IF;
1867: RAISE fnd_api.g_exc_unexpected_error;
1868: END;
1869:
1870: -- Verify there are no released tasks
1871: BEGIN

Line 1885: RAISE fnd_api.g_exc_error;

1881: print_debug('Released tasks exist, so return error', l_api_name);
1882: END IF;
1883: fnd_message.set_name('WMS', 'WMS_PALOC_RLSD_TASK'); -- TBD
1884: fnd_msg_pub.ADD;
1885: RAISE fnd_api.g_exc_error;
1886: EXCEPTION
1887: WHEN NO_DATA_FOUND THEN
1888: IF g_debug = 1 THEN
1889: print_debug('No released tasks, proceed', l_api_name);

Line 1891: WHEN fnd_api.g_exc_error THEN

1887: WHEN NO_DATA_FOUND THEN
1888: IF g_debug = 1 THEN
1889: print_debug('No released tasks, proceed', l_api_name);
1890: END IF;
1891: WHEN fnd_api.g_exc_error THEN
1892: RAISE fnd_api.g_exc_error;
1893: WHEN OTHERS THEN
1894: IF g_debug = 1 THEN
1895: print_debug( 'Error when checking for released tasks: ' || SQLERRM

Line 1892: RAISE fnd_api.g_exc_error;

1888: IF g_debug = 1 THEN
1889: print_debug('No released tasks, proceed', l_api_name);
1890: END IF;
1891: WHEN fnd_api.g_exc_error THEN
1892: RAISE fnd_api.g_exc_error;
1893: WHEN OTHERS THEN
1894: IF g_debug = 1 THEN
1895: print_debug( 'Error when checking for released tasks: ' || SQLERRM
1896: , l_api_name);

Line 1898: RAISE fnd_api.g_exc_unexpected_error;

1894: IF g_debug = 1 THEN
1895: print_debug( 'Error when checking for released tasks: ' || SQLERRM
1896: , l_api_name);
1897: END IF;
1898: RAISE fnd_api.g_exc_unexpected_error;
1899: END;
1900: END IF; --}
1901:
1902: --

Line 1926: RAISE fnd_api.g_exc_unexpected_error;

1922: IF (g_debug = 1) THEN
1923: print_debug( 'Other error when checking if bulk tasks already exist: '
1924: || sqlerrm, l_api_name );
1925: END IF;
1926: RAISE fnd_api.g_exc_unexpected_error;
1927: END;
1928:
1929: IF l_bulk_tasks_exist THEN --{
1930: OPEN c_existing_bulk_tasks(l_mo_header_id);

Line 1946: l_api_return_status := fnd_api.g_ret_sts_success;

1942: SET parent_line_id = NULL
1943: WHERE transaction_temp_id = l_child_task_id(ll);
1944:
1945: FOR ii IN l_child_task_id.FIRST .. l_child_task_id.LAST LOOP --{
1946: l_api_return_status := fnd_api.g_ret_sts_success;
1947: inv_trx_util_pub.update_parent_mmtt
1948: ( x_return_status => l_api_return_status
1949: , p_parent_line_id => l_parent_task_id(ii)
1950: , p_child_line_id => l_child_task_id(ii)

Line 1954: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

1950: , p_child_line_id => l_child_task_id(ii)
1951: , p_lot_control_code => l_lot_control_code(ii)
1952: , p_serial_control_code => l_serial_control_code(ii)
1953: );
1954: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
1955: IF g_debug = 1 THEN
1956: print_debug('Error status from inv_trx_util_pub.update_parent_mmtt: '
1957: || l_api_return_status, l_api_name);
1958: END IF;

Line 1959: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

1955: IF g_debug = 1 THEN
1956: print_debug('Error status from inv_trx_util_pub.update_parent_mmtt: '
1957: || l_api_return_status, l_api_name);
1958: END IF;
1959: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1960: RAISE fnd_api.g_exc_error;
1961: ELSE
1962: RAISE fnd_api.g_exc_unexpected_error;
1963: END IF;

Line 1960: RAISE fnd_api.g_exc_error;

1956: print_debug('Error status from inv_trx_util_pub.update_parent_mmtt: '
1957: || l_api_return_status, l_api_name);
1958: END IF;
1959: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1960: RAISE fnd_api.g_exc_error;
1961: ELSE
1962: RAISE fnd_api.g_exc_unexpected_error;
1963: END IF;
1964: END IF;

Line 1962: RAISE fnd_api.g_exc_unexpected_error;

1958: END IF;
1959: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
1960: RAISE fnd_api.g_exc_error;
1961: ELSE
1962: RAISE fnd_api.g_exc_unexpected_error;
1963: END IF;
1964: END IF;
1965: END LOOP; --}
1966: END LOOP; --}

Line 2002: l_api_return_status := fnd_api.g_ret_sts_success;

1998:
1999: COMMIT;
2000: END IF; --}
2001:
2002: l_api_return_status := fnd_api.g_ret_sts_success;
2003: launch
2004: ( p_organization_id => p_organization_id
2005: , p_mo_header_id => l_mo_header_id
2006: , p_batch_id => l_batch_id

Line 2012: , p_allow_partial_pick => fnd_api.g_true

2008: , p_auto_pick_confirm => l_auto_pick_confirm
2009: , p_wsh_status => NVL(l_wsh_status,'0')
2010: , p_wsh_mode => NVL(l_mode,'PICK')
2011: , p_grouping_rule_id => l_grouping_rule_id
2012: , p_allow_partial_pick => fnd_api.g_true
2013: , p_plan_tasks => l_plan_tasks
2014: , x_return_status => l_api_return_status
2015: , x_org_complete => l_org_complete
2016: );

Line 2017: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2013: , p_plan_tasks => l_plan_tasks
2014: , x_return_status => l_api_return_status
2015: , x_org_complete => l_org_complete
2016: );
2017: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2018: IF g_debug = 1 THEN
2019: print_debug('Error status from launch: '
2020: || l_api_return_status, l_api_name);
2021: END IF;

Line 2022: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2018: IF g_debug = 1 THEN
2019: print_debug('Error status from launch: '
2020: || l_api_return_status, l_api_name);
2021: END IF;
2022: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2023: RAISE fnd_api.g_exc_error;
2024: ELSE
2025: RAISE fnd_api.g_exc_unexpected_error;
2026: END IF;

Line 2023: RAISE fnd_api.g_exc_error;

2019: print_debug('Error status from launch: '
2020: || l_api_return_status, l_api_name);
2021: END IF;
2022: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2023: RAISE fnd_api.g_exc_error;
2024: ELSE
2025: RAISE fnd_api.g_exc_unexpected_error;
2026: END IF;
2027: END IF;

Line 2025: RAISE fnd_api.g_exc_unexpected_error;

2021: END IF;
2022: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2023: RAISE fnd_api.g_exc_error;
2024: ELSE
2025: RAISE fnd_api.g_exc_unexpected_error;
2026: END IF;
2027: END IF;
2028:
2029: EXCEPTION

Line 2030: WHEN fnd_api.g_exc_error THEN

2026: END IF;
2027: END IF;
2028:
2029: EXCEPTION
2030: WHEN fnd_api.g_exc_error THEN
2031: fnd_msg_pub.count_and_get
2032: ( p_count => l_msg_count
2033: , p_data => l_msg_data
2034: , p_encoded => fnd_api.g_false

Line 2034: , p_encoded => fnd_api.g_false

2030: WHEN fnd_api.g_exc_error THEN
2031: fnd_msg_pub.count_and_get
2032: ( p_count => l_msg_count
2033: , p_data => l_msg_data
2034: , p_encoded => fnd_api.g_false
2035: );
2036: IF g_debug = 1 THEN
2037: print_debug (l_msg_data, l_api_name);
2038: END IF;