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

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63: AND ctlx.config_inst_baseline_rev_num = ctd.config_inst_rev_num);
64:
65: BEGIN
66:
67: x_return_status := fnd_api.g_ret_sts_success;
68: --Initializing the lock status
69: x_install_config_rec.lock_status := 0;
70:
71:

Line 164: RAISE fnd_api.g_exc_error;

160:
161: fnd_message.set_name('CSI', 'CSI_UNSUPPORTED_INST_LEVEL');
162: fnd_message.set_token('INST_LVL', px_instance_level);
163: fnd_msg_pub.add;
164: RAISE fnd_api.g_exc_error;
165:
166: END IF;
167:
168: IF NOT(l_rev_found) THEN

Line 175: RAISE fnd_api.g_exc_error;

171: fnd_message.set_name('CSI','CSI_CONFIG_REV_NOT_FOUND');
172: fnd_message.set_token('LEVEL', l_instance_level);
173: fnd_message.set_token('INST_HDR_ID', p_config_header_id);
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_error;
176: */
177: END IF;
178:
179: EXCEPTION

Line 180: WHEN fnd_api.g_exc_error THEN

176: */
177: END IF;
178:
179: EXCEPTION
180: WHEN fnd_api.g_exc_error THEN
181: x_return_status := fnd_api.g_ret_sts_error;
182: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
183: END get_configuration_revision;
184:

Line 181: x_return_status := fnd_api.g_ret_sts_error;

177: END IF;
178:
179: EXCEPTION
180: WHEN fnd_api.g_exc_error THEN
181: x_return_status := fnd_api.g_ret_sts_error;
182: x_return_message := csi_t_gen_utility_pvt.dump_error_stack;
183: END get_configuration_revision;
184:
185: --

Line 271: x_return_status := fnd_api.g_ret_sts_success;

267: l_obj_item_id number;
268:
269: BEGIN
270:
271: x_return_status := fnd_api.g_ret_sts_success;
272:
273: IF p_config_query_table.COUNT > 0 THEN
274:
275: FOR l_ind IN p_config_query_table.FIRST .. p_config_query_table.LAST

Line 420: RAISE fnd_api.g_exc_error;

416: fnd_message.set_name('CSI','CSI_CONFIG_REV_NOT_FOUND');
417: fnd_message.set_token('LEVEL', 'INSTALLED');
418: fnd_message.set_token('INST_HDR_ID', l_conn_hdr_id);
419: fnd_msg_pub.add;
420: RAISE fnd_api.g_exc_error;
421: End;
422:
423: l_found := FALSE;
424: IF x_config_pair_table.count > 0 THEN

Line 514: WHEN fnd_api.g_exc_error THEN

510:
511: END IF;
512:
513: EXCEPTION
514: WHEN fnd_api.g_exc_error THEN
515: x_return_status := fnd_api.g_ret_sts_error;
516: END get_connected_configurations;
517:
518: Function check_item_instance_lock (

Line 515: x_return_status := fnd_api.g_ret_sts_error;

511: END IF;
512:
513: EXCEPTION
514: WHEN fnd_api.g_exc_error THEN
515: x_return_status := fnd_api.g_ret_sts_error;
516: END get_connected_configurations;
517:
518: Function check_item_instance_lock (
519: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 519: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

515: x_return_status := fnd_api.g_ret_sts_error;
516: END get_connected_configurations;
517:
518: Function check_item_instance_lock (
519: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
520: p_config_rec IN config_rec,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_msg_count OUT NOCOPY NUMBER,
523: x_msg_data OUT NOCOPY VARCHAR2)

Line 528: x_return_status := fnd_api.g_ret_sts_success;

524: RETURN BOOLEAN is
525:
526: l_locked BOOLEAN := FALSE;
527: Begin
528: x_return_status := fnd_api.g_ret_sts_success;
529:
530: l_locked := csi_item_instance_pvt.check_item_instance_lock(
531: p_config_inst_hdr_id => p_config_rec.config_inst_hdr_id,
532: p_config_inst_item_id => p_config_rec.config_inst_item_id,

Line 538: WHEN fnd_api.g_exc_error THEN

534: p_instance_id => p_config_rec.instance_id);
535: Return l_locked;
536:
537: EXCEPTION
538: WHEN fnd_api.g_exc_error THEN
539: x_return_status := fnd_api.g_ret_sts_error;
540: Return TRUE;
541: END check_item_instance_lock;
542:

Line 539: x_return_status := fnd_api.g_ret_sts_error;

535: Return l_locked;
536:
537: EXCEPTION
538: WHEN fnd_api.g_exc_error THEN
539: x_return_status := fnd_api.g_ret_sts_error;
540: Return TRUE;
541: END check_item_instance_lock;
542:
543: PROCEDURE lock_item_instances(

Line 545: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

541: END check_item_instance_lock;
542:
543: PROCEDURE lock_item_instances(
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
546: p_commit IN VARCHAR2 := FND_API.g_false,
547: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
548: px_config_tbl IN OUT NOCOPY config_tbl,
549: x_return_status OUT NOCOPY varchar2,

Line 546: p_commit IN VARCHAR2 := FND_API.g_false,

542:
543: PROCEDURE lock_item_instances(
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
546: p_commit IN VARCHAR2 := FND_API.g_false,
547: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
548: px_config_tbl IN OUT NOCOPY config_tbl,
549: x_return_status OUT NOCOPY varchar2,
550: x_msg_count OUT NOCOPY NUMBER,

Line 547: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

543: PROCEDURE lock_item_instances(
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
546: p_commit IN VARCHAR2 := FND_API.g_false,
547: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
548: px_config_tbl IN OUT NOCOPY config_tbl,
549: x_return_status OUT NOCOPY varchar2,
550: x_msg_count OUT NOCOPY NUMBER,
551: x_msg_data OUT NOCOPY VARCHAR2 )

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

561: l_CONFIG_SESSION_ITEM_ID NUMBER;
562: l_txn_rec csi_datastructures_pub.transaction_rec;
563: l_flag NUMBER;
564: l_csi_debug_level NUMBER;
565: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
566: l_msg_count NUMBER;
567: l_msg_data VARCHAR2(2000);
568: l_return_message VARCHAR2(2000);
569:

Line 598: x_return_status := fnd_api.g_ret_sts_success;

594: -- This routine checks if ib is active
595: csi_utility_grp.check_ib_active;
596:
597: -- Initialize API return status to success
598: x_return_status := fnd_api.g_ret_sts_success;
599:
600: csi_t_gen_utility_pvt.build_file_name(
601: p_file_segment1 => 'csilock',
602: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));

Line 610: -- l_txn_rec.transaction_id := fnd_api.g_miss_num;

606: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
607: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
608:
609: -- Building txn rec
610: -- l_txn_rec.transaction_id := fnd_api.g_miss_num;
611: l_txn_rec.transaction_date := sysdate;
612: l_txn_rec.source_transaction_date := sysdate;
613: l_txn_rec.transaction_type_id := 51;
614:

Line 630: px_config_tbl(l_key).source_application_id = fnd_api.g_miss_num

626: debug('src Appln Id('||l_key||') :'||px_config_tbl(l_key).source_application_id);
627:
628: IF ( px_config_tbl(l_key).source_application_id is null
629: OR
630: px_config_tbl(l_key).source_application_id = fnd_api.g_miss_num
631: )
632: OR
633: ( px_config_tbl(l_key).source_txn_header_ref is null
634: OR

Line 635: px_config_tbl(l_key).source_txn_header_ref = fnd_api.g_miss_num

631: )
632: OR
633: ( px_config_tbl(l_key).source_txn_header_ref is null
634: OR
635: px_config_tbl(l_key).source_txn_header_ref = fnd_api.g_miss_num
636: )
637: THEN
638: fnd_message.set_name('CSI','CSI_CZ_LOCK_DTLS_MISS');
639: fnd_message.set_token('APPLN_ID',px_config_tbl(l_key).source_application_id);

Line 642: RAISE fnd_api.g_exc_error;

638: fnd_message.set_name('CSI','CSI_CZ_LOCK_DTLS_MISS');
639: fnd_message.set_token('APPLN_ID',px_config_tbl(l_key).source_application_id);
640: fnd_message.set_token('HEADER_REF',px_config_tbl(l_key).source_txn_header_ref);
641: fnd_msg_pub.add;
642: RAISE fnd_api.g_exc_error;
643: END IF;
644:
645: FOR sess_rec IN sess_cur(px_config_tbl(l_key).config_inst_hdr_id,
646: px_config_tbl(l_key).config_inst_rev_num,

Line 669: p_init_msg_list => fnd_api.g_true,

665: l_config_rec.config_inst_item_id := sess_rec.CONFIG_INST_ITEM_ID;
666:
667: -- checking for the config keys if they are locked alreday.
668: l_lock := check_item_instance_lock (
669: p_init_msg_list => fnd_api.g_true,
670: p_config_rec => l_config_rec,
671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data);

Line 682: RAISE fnd_api.g_exc_error;

678: fnd_message.set_token('CONFIG_INST_HDR_ID',l_config_rec.config_inst_hdr_id);
679: fnd_message.set_token('CONFIG_INST_ITEM_ID',l_config_rec.config_inst_item_id);
680: fnd_message.set_token('CONFIG_INST_REV_NUM',l_config_rec.config_inst_rev_num);
681: fnd_msg_pub.add;
682: RAISE fnd_api.g_exc_error;
683: Exit;
684: ELSE
685: /*
686: -- Populating the order line details onto the key rec

Line 706: RAISE fnd_api.g_exc_error;

702: EXCEPTION
703: WHEN NO_DATA_FOUND Then
704: fnd_message.set_name('CSI','CSI_CZ_KEY_INVAL_OREDER');
705: fnd_msg_pub.add;
706: RAISE fnd_api.g_exc_error;
707: Exit;
708: END;
709: */
710: -- Populating the instance_id onto the key rec

Line 713: -- l_config_rec.instance_id = fnd_api.g_miss_num

709: */
710: -- Populating the instance_id onto the key rec
711: -- IF l_config_rec.instance_id is null
712: -- OR
713: -- l_config_rec.instance_id = fnd_api.g_miss_num
714: -- THEN
715: BEGIN
716: SELECT instance_id
717: INTO l_config_tbl(l_child_ind).instance_id

Line 751: p_commit => fnd_api.g_false,

747:
748: -- Call to core API for Locking
749: csi_item_instance_pvt.lock_item_instances(
750: p_api_version => 1.0,
751: p_commit => fnd_api.g_false,
752: p_init_msg_list => fnd_api.g_true,
753: p_validation_level => fnd_api.g_valid_level_full,
754: px_config_tbl => l_config_tbl,
755: x_return_status => x_return_status,

Line 752: p_init_msg_list => fnd_api.g_true,

748: -- Call to core API for Locking
749: csi_item_instance_pvt.lock_item_instances(
750: p_api_version => 1.0,
751: p_commit => fnd_api.g_false,
752: p_init_msg_list => fnd_api.g_true,
753: p_validation_level => fnd_api.g_valid_level_full,
754: px_config_tbl => l_config_tbl,
755: x_return_status => x_return_status,
756: x_msg_count => x_msg_count,

Line 753: p_validation_level => fnd_api.g_valid_level_full,

749: csi_item_instance_pvt.lock_item_instances(
750: p_api_version => 1.0,
751: p_commit => fnd_api.g_false,
752: p_init_msg_list => fnd_api.g_true,
753: p_validation_level => fnd_api.g_valid_level_full,
754: px_config_tbl => l_config_tbl,
755: x_return_status => x_return_status,
756: x_msg_count => x_msg_count,
757: x_msg_data => x_msg_data);

Line 759: IF x_return_status <> fnd_api.g_ret_sts_success THEN

755: x_return_status => x_return_status,
756: x_msg_count => x_msg_count,
757: x_msg_data => x_msg_data);
758:
759: IF x_return_status <> fnd_api.g_ret_sts_success THEN
760: debug('Failed csi_item_instance_pvt.lock_item_instance');
761: RAISE fnd_api.g_exc_error;
762: END IF;
763:

Line 761: RAISE fnd_api.g_exc_error;

757: x_msg_data => x_msg_data);
758:
759: IF x_return_status <> fnd_api.g_ret_sts_success THEN
760: debug('Failed csi_item_instance_pvt.lock_item_instance');
761: RAISE fnd_api.g_exc_error;
762: END IF;
763:
764: -- Assigningrequired values to px_config keys
765: IF px_config_tbl.count > 0

Line 797: WHEN fnd_api.g_exc_error THEN

793: (p_count => x_msg_count ,
794: p_data => x_msg_data );
795:
796: EXCEPTION
797: WHEN fnd_api.g_exc_error THEN
798: x_return_status := fnd_api.g_ret_sts_error;
799: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
800: FND_MSG_PUB.Count_And_Get
801: (p_count => x_msg_count ,

Line 798: x_return_status := fnd_api.g_ret_sts_error;

794: p_data => x_msg_data );
795:
796: EXCEPTION
797: WHEN fnd_api.g_exc_error THEN
798: x_return_status := fnd_api.g_ret_sts_error;
799: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
800: FND_MSG_PUB.Count_And_Get
801: (p_count => x_msg_count ,
802: p_data => x_msg_data );

Line 812: x_return_status := fnd_api.g_ret_sts_error;

808: fnd_msg_pub.add;
809: FND_MSG_PUB.Count_And_Get
810: (p_count => x_msg_count ,
811: p_data => x_msg_data );
812: x_return_status := fnd_api.g_ret_sts_error;
813: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
814: rollback to csi_cz_lock_item;
815: debug(l_return_message);
816: END lock_item_instances;

Line 853: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

849: p_config_rec IN config_rec,
850: x_conn_config_tbl OUT NOCOPY config_tbl,
851: x_return_status OUT NOCOPY varchar2)
852: IS
853: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
854: l_parent_hdr_id number;
855: l_parent_rev_num number;
856: l_parent_item_id number;
857: l_ind number := 0;

Line 891: x_return_status := fnd_api.g_ret_sts_success;

887: BEGIN
888:
889: api_log('populate_connected_tbl');
890:
891: x_return_status := fnd_api.g_ret_sts_success;
892: l_parent_hdr_id := p_config_rec.config_inst_hdr_id;
893: l_parent_rev_num := p_config_rec.config_inst_rev_num;
894: l_parent_item_id := p_config_rec.config_inst_item_id;
895:

Line 976: x_return_status := fnd_api.g_ret_sts_success;

972: AND lock_status <> 0;
973:
974: BEGIN
975:
976: x_return_status := fnd_api.g_ret_sts_success;
977: api_log('unlock_current_node');
978:
979: savepoint unlock_current_node;
980:

Line 998: IF x_return_status <> fnd_api.g_ret_sts_success THEN

994: p_config_rec => l_config_rec,
995: x_conn_config_tbl => x_conn_config_tbl,
996: x_return_status => x_return_status);
997:
998: IF x_return_status <> fnd_api.g_ret_sts_success THEN
999: RAISE fnd_api.g_exc_error;
1000: END IF;
1001:
1002:

Line 999: RAISE fnd_api.g_exc_error;

995: x_conn_config_tbl => x_conn_config_tbl,
996: x_return_status => x_return_status);
997:
998: IF x_return_status <> fnd_api.g_ret_sts_success THEN
999: RAISE fnd_api.g_exc_error;
1000: END IF;
1001:
1002:
1003: -- If any of the neighbours of the fulfilled INstance is in Locked status

Line 1076: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1072: p_config_rec => l_child_config_rec,
1073: x_conn_config_tbl => l_comp_conn_config_tbl,
1074: x_return_status => x_return_status);
1075:
1076: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1077: RAISE fnd_api.g_exc_error;
1078: END IF;
1079: --
1080: IF l_comp_conn_config_tbl.count > 0 THEN

Line 1077: RAISE fnd_api.g_exc_error;

1073: x_conn_config_tbl => l_comp_conn_config_tbl,
1074: x_return_status => x_return_status);
1075:
1076: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1077: RAISE fnd_api.g_exc_error;
1078: END IF;
1079: --
1080: IF l_comp_conn_config_tbl.count > 0 THEN
1081: FOR i in l_comp_conn_config_tbl.FIRST .. l_comp_conn_config_tbl.LAST

Line 1130: p_commit => fnd_api.g_false,

1126: p_config_tbl => l_config_tbl);
1127:
1128: csi_item_instance_pvt.unlock_item_instances(
1129: p_api_version => 1.0,
1130: p_commit => fnd_api.g_false,
1131: p_init_msg_list => fnd_api.g_true,
1132: p_validation_level => fnd_api.g_valid_level_full,
1133: p_config_tbl => l_config_tbl,
1134: p_unlock_all => fnd_api.g_false,

Line 1131: p_init_msg_list => fnd_api.g_true,

1127:
1128: csi_item_instance_pvt.unlock_item_instances(
1129: p_api_version => 1.0,
1130: p_commit => fnd_api.g_false,
1131: p_init_msg_list => fnd_api.g_true,
1132: p_validation_level => fnd_api.g_valid_level_full,
1133: p_config_tbl => l_config_tbl,
1134: p_unlock_all => fnd_api.g_false,
1135: x_return_status => x_return_status,

Line 1132: p_validation_level => fnd_api.g_valid_level_full,

1128: csi_item_instance_pvt.unlock_item_instances(
1129: p_api_version => 1.0,
1130: p_commit => fnd_api.g_false,
1131: p_init_msg_list => fnd_api.g_true,
1132: p_validation_level => fnd_api.g_valid_level_full,
1133: p_config_tbl => l_config_tbl,
1134: p_unlock_all => fnd_api.g_false,
1135: x_return_status => x_return_status,
1136: x_msg_count => x_msg_count,

Line 1134: p_unlock_all => fnd_api.g_false,

1130: p_commit => fnd_api.g_false,
1131: p_init_msg_list => fnd_api.g_true,
1132: p_validation_level => fnd_api.g_valid_level_full,
1133: p_config_tbl => l_config_tbl,
1134: p_unlock_all => fnd_api.g_false,
1135: x_return_status => x_return_status,
1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138:

Line 1139: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1135: x_return_status => x_return_status,
1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138:
1139: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1140: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1141: RAISE fnd_api.g_exc_error;
1142: END IF;
1143: EXCEPTION

Line 1141: RAISE fnd_api.g_exc_error;

1137: x_msg_data => x_msg_data);
1138:
1139: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1140: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1141: RAISE fnd_api.g_exc_error;
1142: END IF;
1143: EXCEPTION
1144: WHEN fnd_api.g_exc_error THEN
1145: x_return_status := fnd_api.g_ret_sts_error;

Line 1144: WHEN fnd_api.g_exc_error THEN

1140: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1141: RAISE fnd_api.g_exc_error;
1142: END IF;
1143: EXCEPTION
1144: WHEN fnd_api.g_exc_error THEN
1145: x_return_status := fnd_api.g_ret_sts_error;
1146: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1147: FND_MSG_PUB.Count_And_Get
1148: (p_count => x_msg_count ,

Line 1145: x_return_status := fnd_api.g_ret_sts_error;

1141: RAISE fnd_api.g_exc_error;
1142: END IF;
1143: EXCEPTION
1144: WHEN fnd_api.g_exc_error THEN
1145: x_return_status := fnd_api.g_ret_sts_error;
1146: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1147: FND_MSG_PUB.Count_And_Get
1148: (p_count => x_msg_count ,
1149: p_data => x_msg_data );

Line 1159: x_return_status := fnd_api.g_ret_sts_error;

1155: fnd_msg_pub.add;
1156: FND_MSG_PUB.Count_And_Get
1157: (p_count => x_msg_count ,
1158: p_data => x_msg_data );
1159: x_return_status := fnd_api.g_ret_sts_error;
1160: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1161: rollback to unlock_current_node;
1162: debug(l_return_message);
1163: END Unlock_Current_Node;

Line 1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1163: END Unlock_Current_Node;
1164:
1165: PROCEDURE unlock_item_instances(
1166: p_api_version IN NUMBER,
1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1168: p_commit IN VARCHAR2 := FND_API.g_false,
1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1170: p_config_tbl IN config_tbl,
1171: x_return_status OUT NOCOPY varchar2,

Line 1168: p_commit IN VARCHAR2 := FND_API.g_false,

1164:
1165: PROCEDURE unlock_item_instances(
1166: p_api_version IN NUMBER,
1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1168: p_commit IN VARCHAR2 := FND_API.g_false,
1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1170: p_config_tbl IN config_tbl,
1171: x_return_status OUT NOCOPY varchar2,
1172: x_msg_count OUT NOCOPY NUMBER,

Line 1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1165: PROCEDURE unlock_item_instances(
1166: p_api_version IN NUMBER,
1167: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1168: p_commit IN VARCHAR2 := FND_API.g_false,
1169: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1170: p_config_tbl IN config_tbl,
1171: x_return_status OUT NOCOPY varchar2,
1172: x_msg_count OUT NOCOPY NUMBER,
1173: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1190: x_return_status := fnd_api.g_ret_sts_success;

1186: l_lock_id NUMBER;
1187:
1188: BEGIN
1189:
1190: x_return_status := fnd_api.g_ret_sts_success;
1191: api_log('unlock_item_instance');
1192:
1193: savepoint csi_cz_unlock_item;
1194:

Line 1196: -- l_txn_rec.transaction_id := fnd_api.g_miss_num;

1192:
1193: savepoint csi_cz_unlock_item;
1194:
1195: -- Building txn rec
1196: -- l_txn_rec.transaction_id := fnd_api.g_miss_num;
1197: l_txn_rec.transaction_date := sysdate;
1198: l_txn_rec.source_transaction_date := sysdate;
1199: l_txn_rec.transaction_type_id := 401;
1200:

Line 1235: p_config_tbl(l_key).source_application_id <> fnd_api.g_miss_num

1231: FOR l_key in p_config_tbl.FIRST .. p_config_tbl.LAST
1232: LOOP
1233: IF ( p_config_tbl(l_key).source_application_id <> 542
1234: AND
1235: p_config_tbl(l_key).source_application_id <> fnd_api.g_miss_num
1236: )
1237: AND
1238: -- In future need to make sure that lock_id is passed from other callers.
1239: ( p_config_tbl(l_key).source_txn_header_ref is NULL--lock_id is NULL

Line 1241: p_config_tbl(l_key).source_txn_header_ref = fnd_api.g_miss_char --lock_id = fnd_api.g_miss_num

1237: AND
1238: -- In future need to make sure that lock_id is passed from other callers.
1239: ( p_config_tbl(l_key).source_txn_header_ref is NULL--lock_id is NULL
1240: OR
1241: p_config_tbl(l_key).source_txn_header_ref = fnd_api.g_miss_char --lock_id = fnd_api.g_miss_num
1242: )
1243: THEN
1244: fnd_message.set_name('CSI','CSI_CZ_LOCK_ID_MISS');
1245: fnd_message.set_token('CONFIG_INST_HDR_ID',p_config_tbl(l_key).config_inst_hdr_id);

Line 1249: RAISE fnd_api.g_exc_error;

1245: fnd_message.set_token('CONFIG_INST_HDR_ID',p_config_tbl(l_key).config_inst_hdr_id);
1246: fnd_message.set_token('CONFIG_INST_REV_NUM',p_config_tbl(l_key).config_inst_rev_num);
1247: fnd_message.set_token('CONFIG_INST_ITEM_ID',p_config_tbl(l_key).config_inst_item_id);
1248: fnd_msg_pub.add;
1249: RAISE fnd_api.g_exc_error;
1250: EXIT;
1251: END IF;
1252: END LOOP;
1253: END IF;

Line 1294: p_commit => fnd_api.g_false,

1290: p_config_tbl => l_all_config_tbl);
1291:
1292: csi_item_instance_pvt.unlock_item_instances(
1293: p_api_version => 1.0,
1294: p_commit => fnd_api.g_false,
1295: p_init_msg_list => fnd_api.g_true,
1296: p_validation_level => fnd_api.g_valid_level_full,
1297: p_config_tbl => l_all_config_tbl,
1298: p_unlock_all => fnd_api.g_true,

Line 1295: p_init_msg_list => fnd_api.g_true,

1291:
1292: csi_item_instance_pvt.unlock_item_instances(
1293: p_api_version => 1.0,
1294: p_commit => fnd_api.g_false,
1295: p_init_msg_list => fnd_api.g_true,
1296: p_validation_level => fnd_api.g_valid_level_full,
1297: p_config_tbl => l_all_config_tbl,
1298: p_unlock_all => fnd_api.g_true,
1299: x_return_status => x_return_status,

Line 1296: p_validation_level => fnd_api.g_valid_level_full,

1292: csi_item_instance_pvt.unlock_item_instances(
1293: p_api_version => 1.0,
1294: p_commit => fnd_api.g_false,
1295: p_init_msg_list => fnd_api.g_true,
1296: p_validation_level => fnd_api.g_valid_level_full,
1297: p_config_tbl => l_all_config_tbl,
1298: p_unlock_all => fnd_api.g_true,
1299: x_return_status => x_return_status,
1300: x_msg_count => x_msg_count,

Line 1298: p_unlock_all => fnd_api.g_true,

1294: p_commit => fnd_api.g_false,
1295: p_init_msg_list => fnd_api.g_true,
1296: p_validation_level => fnd_api.g_valid_level_full,
1297: p_config_tbl => l_all_config_tbl,
1298: p_unlock_all => fnd_api.g_true,
1299: x_return_status => x_return_status,
1300: x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data);
1302:

Line 1303: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1299: x_return_status => x_return_status,
1300: x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data);
1302:
1303: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1304: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1305: RAISE fnd_api.g_exc_error;
1306: END IF;
1307: END IF;

Line 1305: RAISE fnd_api.g_exc_error;

1301: x_msg_data => x_msg_data);
1302:
1303: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1304: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1305: RAISE fnd_api.g_exc_error;
1306: END IF;
1307: END IF;
1308: ******** END OF COMMENT *******/
1309: ELSE

Line 1329: p_init_msg_list => fnd_api.g_true,

1325: l_config_rec.lock_id := l_lock_id;
1326: --
1327: Unlock_Current_Node(
1328: p_api_version => 1.0,
1329: p_init_msg_list => fnd_api.g_true,
1330: p_commit => fnd_api.g_false,
1331: p_validation_level => fnd_api.g_valid_level_full,
1332: p_config_rec => l_config_rec,
1333: x_conn_config_tbl => x_conn_config_tbl,

Line 1330: p_commit => fnd_api.g_false,

1326: --
1327: Unlock_Current_Node(
1328: p_api_version => 1.0,
1329: p_init_msg_list => fnd_api.g_true,
1330: p_commit => fnd_api.g_false,
1331: p_validation_level => fnd_api.g_valid_level_full,
1332: p_config_rec => l_config_rec,
1333: x_conn_config_tbl => x_conn_config_tbl,
1334: x_return_status => x_return_status,

Line 1331: p_validation_level => fnd_api.g_valid_level_full,

1327: Unlock_Current_Node(
1328: p_api_version => 1.0,
1329: p_init_msg_list => fnd_api.g_true,
1330: p_commit => fnd_api.g_false,
1331: p_validation_level => fnd_api.g_valid_level_full,
1332: p_config_rec => l_config_rec,
1333: x_conn_config_tbl => x_conn_config_tbl,
1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,

Line 1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data);
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1339: debug('Failed unlock_current_node');
1340: RAISE fnd_api.g_exc_error;
1341: END IF;
1342: --

Line 1340: RAISE fnd_api.g_exc_error;

1336: x_msg_data => x_msg_data);
1337:
1338: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1339: debug('Failed unlock_current_node');
1340: RAISE fnd_api.g_exc_error;
1341: END IF;
1342: --
1343: -- Process IJs
1344: debug('Connected to key count :'||nvl(x_conn_config_tbl.count,0));

Line 1363: p_init_msg_list => fnd_api.g_true,

1359: l_config_rec.lock_id := l_lock_id;
1360: --
1361: Unlock_Current_Node(
1362: p_api_version => 1.0,
1363: p_init_msg_list => fnd_api.g_true,
1364: p_commit => fnd_api.g_false,
1365: p_validation_level => fnd_api.g_valid_level_full,
1366: p_config_rec => l_config_rec,
1367: x_conn_config_tbl => l_conn_config_tbl, -- will not be used further

Line 1364: p_commit => fnd_api.g_false,

1360: --
1361: Unlock_Current_Node(
1362: p_api_version => 1.0,
1363: p_init_msg_list => fnd_api.g_true,
1364: p_commit => fnd_api.g_false,
1365: p_validation_level => fnd_api.g_valid_level_full,
1366: p_config_rec => l_config_rec,
1367: x_conn_config_tbl => l_conn_config_tbl, -- will not be used further
1368: x_return_status => x_return_status,

Line 1365: p_validation_level => fnd_api.g_valid_level_full,

1361: Unlock_Current_Node(
1362: p_api_version => 1.0,
1363: p_init_msg_list => fnd_api.g_true,
1364: p_commit => fnd_api.g_false,
1365: p_validation_level => fnd_api.g_valid_level_full,
1366: p_config_rec => l_config_rec,
1367: x_conn_config_tbl => l_conn_config_tbl, -- will not be used further
1368: x_return_status => x_return_status,
1369: x_msg_count => x_msg_count,

Line 1372: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1368: x_return_status => x_return_status,
1369: x_msg_count => x_msg_count,
1370: x_msg_data => x_msg_data);
1371:
1372: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1373: debug('Failed unlock_current_node for IJs...');
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376: END IF;

Line 1374: RAISE fnd_api.g_exc_error;

1370: x_msg_data => x_msg_data);
1371:
1372: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1373: debug('Failed unlock_current_node for IJs...');
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376: END IF;
1377: END LOOP;
1378: END IF;

Line 1394: WHEN fnd_api.g_exc_error THEN

1390: (p_count => x_msg_count ,
1391: p_data => x_msg_data );
1392:
1393: EXCEPTION
1394: WHEN fnd_api.g_exc_error THEN
1395: x_return_status := fnd_api.g_ret_sts_error;
1396: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1397: FND_MSG_PUB.Count_And_Get
1398: (p_count => x_msg_count ,

Line 1395: x_return_status := fnd_api.g_ret_sts_error;

1391: p_data => x_msg_data );
1392:
1393: EXCEPTION
1394: WHEN fnd_api.g_exc_error THEN
1395: x_return_status := fnd_api.g_ret_sts_error;
1396: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1397: FND_MSG_PUB.Count_And_Get
1398: (p_count => x_msg_count ,
1399: p_data => x_msg_data );

Line 1409: x_return_status := fnd_api.g_ret_sts_error;

1405: fnd_msg_pub.add;
1406: FND_MSG_PUB.Count_And_Get
1407: (p_count => x_msg_count ,
1408: p_data => x_msg_data );
1409: x_return_status := fnd_api.g_ret_sts_error;
1410: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1411: rollback to csi_cz_unlock_item;
1412: debug(l_return_message);
1413:

Line 1444: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1440: ORDER BY config_session_item_id;
1441:
1442: l_session_keys csi_utility_grp.config_session_keys;
1443: l_instance_tbl csi_datastructures_pub.instance_tbl;
1444: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1445:
1446: -- Added for BUg 3711457
1447: l_config_keys td_cur%ROWTYPE;
1448: l_usage_exists number;

Line 1454: x_return_status := fnd_api.g_ret_sts_success;

1450: l_error_message varchar2(2000);
1451:
1452: BEGIN
1453:
1454: x_return_status := fnd_api.g_ret_sts_success;
1455:
1456: csi_t_gen_utility_pvt.build_file_name(
1457: p_file_segment1 => 'csiczuii',
1458: p_file_segment2 => p_session_hdr_id);

Line 1494: raise fnd_api.g_exc_error;

1490: THEN
1491: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1492: fnd_message.set_token('MESSAGE', l_error_message);
1493: fnd_msg_pub.add;
1494: raise fnd_api.g_exc_error;
1495: END IF;
1496: CLOSE td_cur;
1497: END IF;
1498:

Line 1503: p_session_rev_num_new <> fnd_api.g_miss_num

1499: IF p_action = 'SAVE'
1500: AND
1501: ( p_session_rev_num_new is not null
1502: AND
1503: p_session_rev_num_new <> fnd_api.g_miss_num
1504: )
1505: THEN
1506: -- End Code Fix for 3711457
1507: -- Included new parameter for the cursor for Bug 3711457

Line 1523: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1519: p_instance_id => p_instance_id,
1520: x_instance_tbl => l_instance_tbl,
1521: x_return_status => l_return_status);
1522:
1523: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1524: raise fnd_api.g_exc_error;
1525: END IF;
1526:
1527: debug('Re-Configure from Install Base HTML User Interface successful.');

Line 1524: raise fnd_api.g_exc_error;

1520: x_instance_tbl => l_instance_tbl,
1521: x_return_status => l_return_status);
1522:
1523: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1524: raise fnd_api.g_exc_error;
1525: END IF;
1526:
1527: debug('Re-Configure from Install Base HTML User Interface successful.');
1528: END IF; -- Added for Bug 3711457

Line 1531: WHEN fnd_api.g_exc_error THEN

1527: debug('Re-Configure from Install Base HTML User Interface successful.');
1528: END IF; -- Added for Bug 3711457
1529:
1530: EXCEPTION
1531: WHEN fnd_api.g_exc_error THEN
1532:
1533: rollback to configure_from_html_ui;
1534:
1535: x_return_status := fnd_api.g_ret_sts_error;

Line 1535: x_return_status := fnd_api.g_ret_sts_error;

1531: WHEN fnd_api.g_exc_error THEN
1532:
1533: rollback to configure_from_html_ui;
1534:
1535: x_return_status := fnd_api.g_ret_sts_error;
1536: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1537: x_msg_data := x_error_message;
1538: x_msg_count := 1;
1539: WHEN others THEN

Line 1543: x_return_status := fnd_api.g_ret_sts_error;

1539: WHEN others THEN
1540:
1541: rollback to configure_from_html_ui;
1542:
1543: x_return_status := fnd_api.g_ret_sts_error;
1544: x_error_message := substr(sqlerrm, 1, 500);
1545: x_msg_data := x_error_message;
1546: x_msg_count := 1;
1547:

Line 1556: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1552: END configure_from_html_ui;
1553:
1554: Procedure CSI_CONFIG_LAUNCH_PRMS
1555: ( p_api_version IN NUMBER,
1556: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1557: p_commit IN VARCHAR2 := FND_API.g_false,
1558: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1559: x_return_status OUT NOCOPY VARCHAR2,
1560: x_msg_count OUT NOCOPY NUMBER,

Line 1557: p_commit IN VARCHAR2 := FND_API.g_false,

1553:
1554: Procedure CSI_CONFIG_LAUNCH_PRMS
1555: ( p_api_version IN NUMBER,
1556: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1557: p_commit IN VARCHAR2 := FND_API.g_false,
1558: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1559: x_return_status OUT NOCOPY VARCHAR2,
1560: x_msg_count OUT NOCOPY NUMBER,
1561: x_msg_data OUT NOCOPY VARCHAR2,

Line 1558: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1554: Procedure CSI_CONFIG_LAUNCH_PRMS
1555: ( p_api_version IN NUMBER,
1556: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1557: p_commit IN VARCHAR2 := FND_API.g_false,
1558: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1559: x_return_status OUT NOCOPY VARCHAR2,
1560: x_msg_count OUT NOCOPY NUMBER,
1561: x_msg_data OUT NOCOPY VARCHAR2,
1562: x_configurable OUT NOCOPY VARCHAR2,

Line 1581: /*IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1577: l_user_id := fnd_global.user_id;
1578:
1579: SAVEPOINT CSI_CONFIG_LAUNCH_PRMS;
1580: -- Standard call to check for call compatibility.
1581: /*IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1582: p_api_version ,
1583: l_api_name ,
1584: G_PKG_NAME )
1585: THEN

Line 1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1582: p_api_version ,
1583: l_api_name ,
1584: G_PKG_NAME )
1585: THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: END IF;*/
1588:
1589: -- Initialize message list if p_init_msg_list is set to TRUE.
1590: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1590: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1587: END IF;*/
1588:
1589: -- Initialize message list if p_init_msg_list is set to TRUE.
1590: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1591: FND_MSG_PUB.initialize;
1592: END IF;
1593:
1594: -- Initialize API rturn status to success

Line 1595: x_return_status := FND_API.g_ret_sts_success;

1591: FND_MSG_PUB.initialize;
1592: END IF;
1593:
1594: -- Initialize API rturn status to success
1595: x_return_status := FND_API.g_ret_sts_success;
1596:
1597:
1598: l_resp_id := fnd_profile.value('RESP_ID');
1599: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

Line 1614: IF FND_API.To_Boolean( p_commit ) THEN

1610: -- get the SYSDATE
1611: x_sysdate := to_char(sysdate,'mm-dd-yyyy-hh24-mi-ss');
1612:
1613:
1614: IF FND_API.To_Boolean( p_commit ) THEN
1615: COMMIT WORK;
1616: END IF;
1617: FND_MSG_PUB.Count_And_Get
1618: ( p_encoded => FND_API.G_FALSE,

Line 1618: ( p_encoded => FND_API.G_FALSE,

1614: IF FND_API.To_Boolean( p_commit ) THEN
1615: COMMIT WORK;
1616: END IF;
1617: FND_MSG_PUB.Count_And_Get
1618: ( p_encoded => FND_API.G_FALSE,
1619: p_count => x_msg_count,
1620: p_data => x_msg_data
1621: );
1622: EXCEPTION

Line 1623: WHEN FND_API.G_EXC_ERROR THEN

1619: p_count => x_msg_count,
1620: p_data => x_msg_data
1621: );
1622: EXCEPTION
1623: WHEN FND_API.G_EXC_ERROR THEN
1624: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1625: x_return_status := FND_API.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get
1627: ( p_encoded => FND_API.G_FALSE,

Line 1625: x_return_status := FND_API.G_RET_STS_ERROR ;

1621: );
1622: EXCEPTION
1623: WHEN FND_API.G_EXC_ERROR THEN
1624: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1625: x_return_status := FND_API.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get
1627: ( p_encoded => FND_API.G_FALSE,
1628: p_count => x_msg_count,
1629: p_data => x_msg_data

Line 1627: ( p_encoded => FND_API.G_FALSE,

1623: WHEN FND_API.G_EXC_ERROR THEN
1624: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1625: x_return_status := FND_API.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get
1627: ( p_encoded => FND_API.G_FALSE,
1628: p_count => x_msg_count,
1629: p_data => x_msg_data
1630: );
1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1627: ( p_encoded => FND_API.G_FALSE,
1628: p_count => x_msg_count,
1629: p_data => x_msg_data
1630: );
1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1632: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1633: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1635: FND_MSG_PUB.Count_And_Get

Line 1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1630: );
1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1632: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1633: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1635: FND_MSG_PUB.Count_And_Get
1636: ( p_encoded => FND_API.G_FALSE,
1637: p_count => x_msg_count,
1638: p_data => x_msg_data

Line 1636: ( p_encoded => FND_API.G_FALSE,

1632: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1633: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1635: FND_MSG_PUB.Count_And_Get
1636: ( p_encoded => FND_API.G_FALSE,
1637: p_count => x_msg_count,
1638: p_data => x_msg_data
1639: );
1640: WHEN OTHERS THEN

Line 1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1639: );
1640: WHEN OTHERS THEN
1641: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: OTHER EXCEPTION ');
1642: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1644: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1645: THEN
1646: FND_MSG_PUB.Add_Exc_Msg
1647: ( G_PKG_NAME,

Line 1652: ( p_encoded => FND_API.G_FALSE,

1648: l_api_name
1649: );
1650: END IF;*/
1651: FND_MSG_PUB.Count_And_Get
1652: ( p_encoded => FND_API.G_FALSE,
1653: p_count => x_msg_count,
1654: p_data => x_msg_data
1655: );
1656: /*ibe_util.disable_debug;*/

Line 1683: IF x_return_value = FND_API.G_FALSE

1679: ,x_msg_data);
1680:
1681: -- Begin of fix for Bug 2873845
1682: -- Checking whether the config keys has a Instance.
1683: IF x_return_value = FND_API.G_FALSE
1684: THEN
1685: Begin
1686: Select count(*)
1687: Into l_found

Line 1698: x_return_value := FND_API.G_TRUE;

1694: and c.config_rev_nbr = p_config_rev_nbr
1695: and c.config_item_id = p_config_item_id;
1696:
1697: IF NVL(l_found,0) > 0 Then
1698: x_return_value := FND_API.G_TRUE;
1699: ELSE
1700: x_return_value := FND_API.G_FALSE;
1701: END IF;
1702:

Line 1700: x_return_value := FND_API.G_FALSE;

1696:
1697: IF NVL(l_found,0) > 0 Then
1698: x_return_value := FND_API.G_TRUE;
1699: ELSE
1700: x_return_value := FND_API.G_FALSE;
1701: END IF;
1702:
1703: End;
1704: END IF;