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

Line 468: p_init_msg_list => fnd_api.g_true,

464:
465: wms_engine_pvt.create_suggestions
466: (
467: p_api_version => 1.0,
468: p_init_msg_list => fnd_api.g_true,
469: p_commit => fnd_api.g_false,
470: p_validation_level => fnd_api.g_valid_level_full,
471: x_return_status => l_return_status,
472: x_msg_count => l_msg_count,

Line 469: p_commit => fnd_api.g_false,

465: wms_engine_pvt.create_suggestions
466: (
467: p_api_version => 1.0,
468: p_init_msg_list => fnd_api.g_true,
469: p_commit => fnd_api.g_false,
470: p_validation_level => fnd_api.g_valid_level_full,
471: x_return_status => l_return_status,
472: x_msg_count => l_msg_count,
473: x_msg_data => l_msg_data,

Line 470: p_validation_level => fnd_api.g_valid_level_full,

466: (
467: p_api_version => 1.0,
468: p_init_msg_list => fnd_api.g_true,
469: p_commit => fnd_api.g_false,
470: p_validation_level => fnd_api.g_valid_level_full,
471: x_return_status => l_return_status,
472: x_msg_count => l_msg_count,
473: x_msg_data => l_msg_data,
474: p_transaction_temp_id => l_line_id,

Line 476: p_suggest_serial => fnd_api.g_true,

472: x_msg_count => l_msg_count,
473: x_msg_data => l_msg_data,
474: p_transaction_temp_id => l_line_id,
475: p_reservations => l_reservations,
476: p_suggest_serial => fnd_api.g_true,
477: p_simulation_id => l_simulation_id,
478: p_simulation_mode => l_simulation_mode );
479:
480: x_return_status := l_return_status;

Line 503: , p_init_msg_lst => fnd_api.g_false

499: end if;
500:
501: inv_quantity_tree_pvt.release_lock(
502: p_api_version_number => 1.0
503: , p_init_msg_lst => fnd_api.g_false
504: , x_return_status => l_return_status_qty
505: , x_msg_count => l_msg_count
506: , x_msg_data => l_msg_data
507: , p_organization_id => l_organization_id

Line 530: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false

526: -----------------------------------------------------------------------------------
527: procedure insert_trace_header
528: (
529: p_api_version in NUMBER
530: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
531: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
532: ,x_return_status out NOCOPY VARCHAR2
533: ,x_msg_count out NOCOPY number
534: ,x_msg_data out NOCOPY varchar2

Line 531: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full

527: procedure insert_trace_header
528: (
529: p_api_version in NUMBER
530: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
531: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
532: ,x_return_status out NOCOPY VARCHAR2
533: ,x_msg_count out NOCOPY number
534: ,x_msg_data out NOCOPY varchar2
535: ,x_header_id out NOCOPY NUMBER

Line 549: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

545: -- API standard variables
546: l_api_version constant number := 1.0;
547: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
548: l_api_name constant varchar2(30) := ' insert_trace_header';
549: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
550: l_row_id VARCHAR2(20);
551: l_object_name VARCHAR2(4000);
552: l_engine_type VARCHAR2(20) := NULL;
553: l_date DATE;

Line 563: if not fnd_api.compatible_api_call( l_api_version

559:
560: begin
561:
562: -- Standard call to check for call compatibility
563: if not fnd_api.compatible_api_call( l_api_version
564: ,l_api_version
565: ,l_api_name
566: ,g_pkg_name ) then
567: raise fnd_api.g_exc_unexpected_error;

Line 567: raise fnd_api.g_exc_unexpected_error;

563: if not fnd_api.compatible_api_call( l_api_version
564: ,l_api_version
565: ,l_api_name
566: ,g_pkg_name ) then
567: raise fnd_api.g_exc_unexpected_error;
568: end if;
569:
570: -- Initialize message list if p_init_msg_list is set to TRUE
571: if fnd_api.to_boolean( p_init_msg_list ) then

Line 571: if fnd_api.to_boolean( p_init_msg_list ) then

567: raise fnd_api.g_exc_unexpected_error;
568: end if;
569:
570: -- Initialize message list if p_init_msg_list is set to TRUE
571: if fnd_api.to_boolean( p_init_msg_list ) then
572: fnd_msg_pub.initialize;
573: end if;
574:
575: IF (nvl(p_move_order_line_id,0) > 0) then

Line 632: when fnd_api.g_exc_error then

628: G_PICK_HEADER_ID := l_header_id;
629: end if ;
630: end if;
631: EXCEPTION
632: when fnd_api.g_exc_error then
633: x_return_status := fnd_api.g_ret_sts_error;
634: fnd_msg_pub.count_and_get( p_count => x_msg_count
635: ,p_data => x_msg_data );
636:

Line 633: x_return_status := fnd_api.g_ret_sts_error;

629: end if ;
630: end if;
631: EXCEPTION
632: when fnd_api.g_exc_error then
633: x_return_status := fnd_api.g_ret_sts_error;
634: fnd_msg_pub.count_and_get( p_count => x_msg_count
635: ,p_data => x_msg_data );
636:
637: when fnd_api.g_exc_unexpected_error then

Line 637: when fnd_api.g_exc_unexpected_error then

633: x_return_status := fnd_api.g_ret_sts_error;
634: fnd_msg_pub.count_and_get( p_count => x_msg_count
635: ,p_data => x_msg_data );
636:
637: when fnd_api.g_exc_unexpected_error then
638: x_return_status := fnd_api.g_ret_sts_unexp_error;
639: fnd_msg_pub.count_and_get( p_count => x_msg_count
640: ,p_data => x_msg_data );
641:

Line 638: x_return_status := fnd_api.g_ret_sts_unexp_error;

634: fnd_msg_pub.count_and_get( p_count => x_msg_count
635: ,p_data => x_msg_data );
636:
637: when fnd_api.g_exc_unexpected_error then
638: x_return_status := fnd_api.g_ret_sts_unexp_error;
639: fnd_msg_pub.count_and_get( p_count => x_msg_count
640: ,p_data => x_msg_data );
641:
642: when others then

Line 643: x_return_status := fnd_api.g_ret_sts_unexp_error;

639: fnd_msg_pub.count_and_get( p_count => x_msg_count
640: ,p_data => x_msg_data );
641:
642: when others then
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
645: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
646: end if;
647: /* fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 658: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false

654: --------------------------------------------------------------------------------------
655: procedure insert_trace_lines
656: (
657: p_api_version in NUMBER
658: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
659: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
660: ,x_return_status out NOCOPY VARCHAR2
661: ,x_msg_count out NOCOPY number
662: ,x_msg_data out NOCOPY varchar2

Line 659: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full

655: procedure insert_trace_lines
656: (
657: p_api_version in NUMBER
658: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
659: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
660: ,x_return_status out NOCOPY VARCHAR2
661: ,x_msg_count out NOCOPY number
662: ,x_msg_data out NOCOPY varchar2
663: ,p_header_id in NUMBER

Line 671: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

667: -- API standard variables
668: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
669: l_api_version constant number := 1.0;
670: l_api_name constant varchar2(30) := 'insert_trace_lines';
671: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
672: l_date DATE;
673: l_user_id NUMBER;
674: l_login_id NUMBER;
675: l_found BOOLEAN;

Line 684: if not fnd_api.compatible_api_call( l_api_version

680: l_index BINARY_INTEGER;
681: begin
682:
683: -- Standard call to check for call compatibility
684: if not fnd_api.compatible_api_call( l_api_version
685: ,p_api_version
686: ,l_api_name
687: ,g_pkg_name ) then
688: raise fnd_api.g_exc_unexpected_error;

Line 688: raise fnd_api.g_exc_unexpected_error;

684: if not fnd_api.compatible_api_call( l_api_version
685: ,p_api_version
686: ,l_api_name
687: ,g_pkg_name ) then
688: raise fnd_api.g_exc_unexpected_error;
689: end if;
690:
691: -- Initialize message list if p_init_msg_list is set to TRUE
692: if fnd_api.to_boolean( p_init_msg_list ) then

Line 692: if fnd_api.to_boolean( p_init_msg_list ) then

688: raise fnd_api.g_exc_unexpected_error;
689: end if;
690:
691: -- Initialize message list if p_init_msg_list is set to TRUE
692: if fnd_api.to_boolean( p_init_msg_list ) then
693: fnd_msg_pub.initialize;
694: end if;
695:
696: if ( nvl(p_header_id ,0 ) > 0 and nvl(p_rule_id,0) > 0 ) then

Line 763: when fnd_api.g_exc_error then

759: END LOOP;
760: x_return_status := l_return_status;
761: end if;
762: EXCEPTION
763: when fnd_api.g_exc_error then
764: x_return_status := fnd_api.g_ret_sts_error;
765: fnd_msg_pub.count_and_get( p_count => x_msg_count
766: ,p_data => x_msg_data );
767:

Line 764: x_return_status := fnd_api.g_ret_sts_error;

760: x_return_status := l_return_status;
761: end if;
762: EXCEPTION
763: when fnd_api.g_exc_error then
764: x_return_status := fnd_api.g_ret_sts_error;
765: fnd_msg_pub.count_and_get( p_count => x_msg_count
766: ,p_data => x_msg_data );
767:
768: when fnd_api.g_exc_unexpected_error then

Line 768: when fnd_api.g_exc_unexpected_error then

764: x_return_status := fnd_api.g_ret_sts_error;
765: fnd_msg_pub.count_and_get( p_count => x_msg_count
766: ,p_data => x_msg_data );
767:
768: when fnd_api.g_exc_unexpected_error then
769: x_return_status := fnd_api.g_ret_sts_unexp_error;
770: fnd_msg_pub.count_and_get( p_count => x_msg_count
771: ,p_data => x_msg_data );
772:

Line 769: x_return_status := fnd_api.g_ret_sts_unexp_error;

765: fnd_msg_pub.count_and_get( p_count => x_msg_count
766: ,p_data => x_msg_data );
767:
768: when fnd_api.g_exc_unexpected_error then
769: x_return_status := fnd_api.g_ret_sts_unexp_error;
770: fnd_msg_pub.count_and_get( p_count => x_msg_count
771: ,p_data => x_msg_data );
772:
773: when others then

Line 774: x_return_status := fnd_api.g_ret_sts_unexp_error;

770: fnd_msg_pub.count_and_get( p_count => x_msg_count
771: ,p_data => x_msg_data );
772:
773: when others then
774: x_return_status := fnd_api.g_ret_sts_unexp_error;
775: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
776: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
777: end if;
778: /*fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 1186: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false

1182: --- The data in these three tables will be used by Run Time trace form
1183:
1184: procedure insert_txn_trace_rows(
1185: p_api_version in NUMBER
1186: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
1187: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
1188: ,x_return_status out NOCOPY VARCHAR2
1189: ,x_msg_count out NOCOPY number
1190: ,x_msg_data out NOCOPY varchar2

Line 1187: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full

1183:
1184: procedure insert_txn_trace_rows(
1185: p_api_version in NUMBER
1186: ,p_init_msg_list in VARCHAR2 DEFAULT fnd_api.g_false
1187: ,p_validation_level in NUMBER DEFAULT fnd_api.g_valid_level_full
1188: ,x_return_status out NOCOPY VARCHAR2
1189: ,x_msg_count out NOCOPY number
1190: ,x_msg_data out NOCOPY varchar2
1191: ,p_txn_header_id in number

Line 1202: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1198: -- API standard variables
1199: l_api_version constant number := 1.0;
1200: g_pkg_name constant VARCHAR2(50) := 'WMS_SEARCH_ORDER_GLOBALS_PVT';
1201: l_api_name constant varchar2(30) := 'insert_txn_trace_rows';
1202: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1203: l_txn_header_id number;
1204: l_insert_lot_flag number;
1205: l_insert_serial_flag number;
1206:

Line 1215: if not fnd_api.compatible_api_call( l_api_version

1211: l_insert_serial_flag := nvl(p_insert_serial_flag,0);
1212:
1213: -- Standard call to check for call compatibility
1214:
1215: if not fnd_api.compatible_api_call( l_api_version
1216: ,l_api_version
1217: ,l_api_name
1218: ,g_pkg_name ) then
1219: raise fnd_api.g_exc_unexpected_error;

Line 1219: raise fnd_api.g_exc_unexpected_error;

1215: if not fnd_api.compatible_api_call( l_api_version
1216: ,l_api_version
1217: ,l_api_name
1218: ,g_pkg_name ) then
1219: raise fnd_api.g_exc_unexpected_error;
1220: end if;
1221:
1222: --- If transaction_header id passed is not null records inserted into following tables
1223: ---

Line 2210: when fnd_api.g_exc_error then

2206:
2207: End if;
2208:
2209: EXCEPTION
2210: when fnd_api.g_exc_error then
2211: x_return_status := fnd_api.g_ret_sts_error;
2212: fnd_msg_pub.count_and_get( p_count => x_msg_count
2213: ,p_data => x_msg_data );
2214:

Line 2211: x_return_status := fnd_api.g_ret_sts_error;

2207: End if;
2208:
2209: EXCEPTION
2210: when fnd_api.g_exc_error then
2211: x_return_status := fnd_api.g_ret_sts_error;
2212: fnd_msg_pub.count_and_get( p_count => x_msg_count
2213: ,p_data => x_msg_data );
2214:
2215: when fnd_api.g_exc_unexpected_error then

Line 2215: when fnd_api.g_exc_unexpected_error then

2211: x_return_status := fnd_api.g_ret_sts_error;
2212: fnd_msg_pub.count_and_get( p_count => x_msg_count
2213: ,p_data => x_msg_data );
2214:
2215: when fnd_api.g_exc_unexpected_error then
2216: x_return_status := fnd_api.g_ret_sts_unexp_error;
2217: fnd_msg_pub.count_and_get( p_count => x_msg_count
2218: ,p_data => x_msg_data );
2219:

Line 2216: x_return_status := fnd_api.g_ret_sts_unexp_error;

2212: fnd_msg_pub.count_and_get( p_count => x_msg_count
2213: ,p_data => x_msg_data );
2214:
2215: when fnd_api.g_exc_unexpected_error then
2216: x_return_status := fnd_api.g_ret_sts_unexp_error;
2217: fnd_msg_pub.count_and_get( p_count => x_msg_count
2218: ,p_data => x_msg_data );
2219:
2220: when others then

Line 2221: x_return_status := fnd_api.g_ret_sts_unexp_error;

2217: fnd_msg_pub.count_and_get( p_count => x_msg_count
2218: ,p_data => x_msg_data );
2219:
2220: when others then
2221: x_return_status := fnd_api.g_ret_sts_unexp_error;
2222: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2223: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2224: end if;
2225: End insert_txn_trace_rows;