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 978: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1000: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1001: RAISE fnd_api.g_exc_error;

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

Line 1080: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1076: p_config_rec => l_child_config_rec,
1077: x_conn_config_tbl => l_comp_conn_config_tbl,
1078: x_return_status => x_return_status);
1079:
1080: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1081: RAISE fnd_api.g_exc_error;
1082: END IF;
1083: --
1084: IF l_comp_conn_config_tbl.count > 0 THEN

Line 1081: RAISE fnd_api.g_exc_error;

1077: x_conn_config_tbl => l_comp_conn_config_tbl,
1078: x_return_status => x_return_status);
1079:
1080: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1081: RAISE fnd_api.g_exc_error;
1082: END IF;
1083: --
1084: IF l_comp_conn_config_tbl.count > 0 THEN
1085: FOR i in l_comp_conn_config_tbl.FIRST .. l_comp_conn_config_tbl.LAST

Line 1171: p_commit => fnd_api.g_false,

1167: p_config_tbl => l_config_tbl);
1168:
1169: csi_item_instance_pvt.unlock_item_instances(
1170: p_api_version => 1.0,
1171: p_commit => fnd_api.g_false,
1172: p_init_msg_list => fnd_api.g_true,
1173: p_validation_level => fnd_api.g_valid_level_full,
1174: p_config_tbl => l_config_tbl,
1175: p_unlock_all => fnd_api.g_false,

Line 1172: p_init_msg_list => fnd_api.g_true,

1168:
1169: csi_item_instance_pvt.unlock_item_instances(
1170: p_api_version => 1.0,
1171: p_commit => fnd_api.g_false,
1172: p_init_msg_list => fnd_api.g_true,
1173: p_validation_level => fnd_api.g_valid_level_full,
1174: p_config_tbl => l_config_tbl,
1175: p_unlock_all => fnd_api.g_false,
1176: x_return_status => x_return_status,

Line 1173: p_validation_level => fnd_api.g_valid_level_full,

1169: csi_item_instance_pvt.unlock_item_instances(
1170: p_api_version => 1.0,
1171: p_commit => fnd_api.g_false,
1172: p_init_msg_list => fnd_api.g_true,
1173: p_validation_level => fnd_api.g_valid_level_full,
1174: p_config_tbl => l_config_tbl,
1175: p_unlock_all => fnd_api.g_false,
1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,

Line 1175: p_unlock_all => fnd_api.g_false,

1171: p_commit => fnd_api.g_false,
1172: p_init_msg_list => fnd_api.g_true,
1173: p_validation_level => fnd_api.g_valid_level_full,
1174: p_config_tbl => l_config_tbl,
1175: p_unlock_all => fnd_api.g_false,
1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data);
1179:

Line 1180: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data);
1179:
1180: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1181: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184: EXCEPTION

Line 1182: RAISE fnd_api.g_exc_error;

1178: x_msg_data => x_msg_data);
1179:
1180: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1181: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184: EXCEPTION
1185: WHEN fnd_api.g_exc_error THEN
1186: x_return_status := fnd_api.g_ret_sts_error;

Line 1185: WHEN fnd_api.g_exc_error THEN

1181: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184: EXCEPTION
1185: WHEN fnd_api.g_exc_error THEN
1186: x_return_status := fnd_api.g_ret_sts_error;
1187: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1188: FND_MSG_PUB.Count_And_Get
1189: (p_count => x_msg_count ,

Line 1186: x_return_status := fnd_api.g_ret_sts_error;

1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184: EXCEPTION
1185: WHEN fnd_api.g_exc_error THEN
1186: x_return_status := fnd_api.g_ret_sts_error;
1187: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1188: FND_MSG_PUB.Count_And_Get
1189: (p_count => x_msg_count ,
1190: p_data => x_msg_data );

Line 1200: x_return_status := fnd_api.g_ret_sts_error;

1196: fnd_msg_pub.add;
1197: FND_MSG_PUB.Count_And_Get
1198: (p_count => x_msg_count ,
1199: p_data => x_msg_data );
1200: x_return_status := fnd_api.g_ret_sts_error;
1201: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1202: rollback to unlock_current_node;
1203: debug(l_return_message);
1204: END Unlock_Current_Node;

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

1204: END Unlock_Current_Node;
1205:
1206: PROCEDURE unlock_item_instances(
1207: p_api_version IN NUMBER,
1208: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1209: p_commit IN VARCHAR2 := FND_API.g_false,
1210: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1211: p_config_tbl IN config_tbl,
1212: x_return_status OUT NOCOPY varchar2,

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

1205:
1206: PROCEDURE unlock_item_instances(
1207: p_api_version IN NUMBER,
1208: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1209: p_commit IN VARCHAR2 := FND_API.g_false,
1210: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1211: p_config_tbl IN config_tbl,
1212: x_return_status OUT NOCOPY varchar2,
1213: x_msg_count OUT NOCOPY NUMBER,

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

1206: PROCEDURE unlock_item_instances(
1207: p_api_version IN NUMBER,
1208: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1209: p_commit IN VARCHAR2 := FND_API.g_false,
1210: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1211: p_config_tbl IN config_tbl,
1212: x_return_status OUT NOCOPY varchar2,
1213: x_msg_count OUT NOCOPY NUMBER,
1214: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1231: x_return_status := fnd_api.g_ret_sts_success;

1227: l_lock_id NUMBER;
1228:
1229: BEGIN
1230:
1231: x_return_status := fnd_api.g_ret_sts_success;
1232: api_log('unlock_item_instance');
1233:
1234: savepoint csi_cz_unlock_item;
1235:

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

1233:
1234: savepoint csi_cz_unlock_item;
1235:
1236: -- Building txn rec
1237: -- l_txn_rec.transaction_id := fnd_api.g_miss_num;
1238: l_txn_rec.transaction_date := sysdate;
1239: l_txn_rec.source_transaction_date := sysdate;
1240: l_txn_rec.transaction_type_id := 401;
1241:

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

1272: FOR l_key in p_config_tbl.FIRST .. p_config_tbl.LAST
1273: LOOP
1274: IF ( p_config_tbl(l_key).source_application_id <> 542
1275: AND
1276: p_config_tbl(l_key).source_application_id <> fnd_api.g_miss_num
1277: )
1278: AND
1279: -- In future need to make sure that lock_id is passed from other callers.
1280: ( p_config_tbl(l_key).source_txn_header_ref is NULL--lock_id is NULL

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

1278: AND
1279: -- In future need to make sure that lock_id is passed from other callers.
1280: ( p_config_tbl(l_key).source_txn_header_ref is NULL--lock_id is NULL
1281: OR
1282: p_config_tbl(l_key).source_txn_header_ref = fnd_api.g_miss_char --lock_id = fnd_api.g_miss_num
1283: )
1284: THEN
1285: fnd_message.set_name('CSI','CSI_CZ_LOCK_ID_MISS');
1286: fnd_message.set_token('CONFIG_INST_HDR_ID',p_config_tbl(l_key).config_inst_hdr_id);

Line 1290: RAISE fnd_api.g_exc_error;

1286: fnd_message.set_token('CONFIG_INST_HDR_ID',p_config_tbl(l_key).config_inst_hdr_id);
1287: fnd_message.set_token('CONFIG_INST_REV_NUM',p_config_tbl(l_key).config_inst_rev_num);
1288: fnd_message.set_token('CONFIG_INST_ITEM_ID',p_config_tbl(l_key).config_inst_item_id);
1289: fnd_msg_pub.add;
1290: RAISE fnd_api.g_exc_error;
1291: EXIT;
1292: END IF;
1293: END LOOP;
1294: END IF;

Line 1335: p_commit => fnd_api.g_false,

1331: p_config_tbl => l_all_config_tbl);
1332:
1333: csi_item_instance_pvt.unlock_item_instances(
1334: p_api_version => 1.0,
1335: p_commit => fnd_api.g_false,
1336: p_init_msg_list => fnd_api.g_true,
1337: p_validation_level => fnd_api.g_valid_level_full,
1338: p_config_tbl => l_all_config_tbl,
1339: p_unlock_all => fnd_api.g_true,

Line 1336: p_init_msg_list => fnd_api.g_true,

1332:
1333: csi_item_instance_pvt.unlock_item_instances(
1334: p_api_version => 1.0,
1335: p_commit => fnd_api.g_false,
1336: p_init_msg_list => fnd_api.g_true,
1337: p_validation_level => fnd_api.g_valid_level_full,
1338: p_config_tbl => l_all_config_tbl,
1339: p_unlock_all => fnd_api.g_true,
1340: x_return_status => x_return_status,

Line 1337: p_validation_level => fnd_api.g_valid_level_full,

1333: csi_item_instance_pvt.unlock_item_instances(
1334: p_api_version => 1.0,
1335: p_commit => fnd_api.g_false,
1336: p_init_msg_list => fnd_api.g_true,
1337: p_validation_level => fnd_api.g_valid_level_full,
1338: p_config_tbl => l_all_config_tbl,
1339: p_unlock_all => fnd_api.g_true,
1340: x_return_status => x_return_status,
1341: x_msg_count => x_msg_count,

Line 1339: p_unlock_all => fnd_api.g_true,

1335: p_commit => fnd_api.g_false,
1336: p_init_msg_list => fnd_api.g_true,
1337: p_validation_level => fnd_api.g_valid_level_full,
1338: p_config_tbl => l_all_config_tbl,
1339: p_unlock_all => fnd_api.g_true,
1340: x_return_status => x_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data);
1343:

Line 1344: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1340: x_return_status => x_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data);
1343:
1344: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1345: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1346: RAISE fnd_api.g_exc_error;
1347: END IF;
1348: END IF;

Line 1346: RAISE fnd_api.g_exc_error;

1342: x_msg_data => x_msg_data);
1343:
1344: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1345: debug('Failed csi_item_instance_pvt.unlock_item_instance');
1346: RAISE fnd_api.g_exc_error;
1347: END IF;
1348: END IF;
1349: ******** END OF COMMENT *******/
1350: ELSE

Line 1370: p_init_msg_list => fnd_api.g_true,

1366: l_config_rec.lock_id := l_lock_id;
1367: --
1368: Unlock_Current_Node(
1369: p_api_version => 1.0,
1370: p_init_msg_list => fnd_api.g_true,
1371: p_commit => fnd_api.g_false,
1372: p_validation_level => fnd_api.g_valid_level_full,
1373: p_config_rec => l_config_rec,
1374: x_conn_config_tbl => x_conn_config_tbl,

Line 1371: p_commit => fnd_api.g_false,

1367: --
1368: Unlock_Current_Node(
1369: p_api_version => 1.0,
1370: p_init_msg_list => fnd_api.g_true,
1371: p_commit => fnd_api.g_false,
1372: p_validation_level => fnd_api.g_valid_level_full,
1373: p_config_rec => l_config_rec,
1374: x_conn_config_tbl => x_conn_config_tbl,
1375: x_return_status => x_return_status,

Line 1372: p_validation_level => fnd_api.g_valid_level_full,

1368: Unlock_Current_Node(
1369: p_api_version => 1.0,
1370: p_init_msg_list => fnd_api.g_true,
1371: p_commit => fnd_api.g_false,
1372: p_validation_level => fnd_api.g_valid_level_full,
1373: p_config_rec => l_config_rec,
1374: x_conn_config_tbl => x_conn_config_tbl,
1375: x_return_status => x_return_status,
1376: x_msg_count => x_msg_count,

Line 1379: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1375: x_return_status => x_return_status,
1376: x_msg_count => x_msg_count,
1377: x_msg_data => x_msg_data);
1378:
1379: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1380: debug('Failed unlock_current_node');
1381: RAISE fnd_api.g_exc_error;
1382: END IF;
1383: --

Line 1381: RAISE fnd_api.g_exc_error;

1377: x_msg_data => x_msg_data);
1378:
1379: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1380: debug('Failed unlock_current_node');
1381: RAISE fnd_api.g_exc_error;
1382: END IF;
1383: --
1384: -- Process IJs
1385: debug('Connected to key count :'||nvl(x_conn_config_tbl.count,0));

Line 1404: p_init_msg_list => fnd_api.g_true,

1400: l_config_rec.lock_id := l_lock_id;
1401: --
1402: Unlock_Current_Node(
1403: p_api_version => 1.0,
1404: p_init_msg_list => fnd_api.g_true,
1405: p_commit => fnd_api.g_false,
1406: p_validation_level => fnd_api.g_valid_level_full,
1407: p_config_rec => l_config_rec,
1408: x_conn_config_tbl => l_conn_config_tbl, -- will not be used further

Line 1405: p_commit => fnd_api.g_false,

1401: --
1402: Unlock_Current_Node(
1403: p_api_version => 1.0,
1404: p_init_msg_list => fnd_api.g_true,
1405: p_commit => fnd_api.g_false,
1406: p_validation_level => fnd_api.g_valid_level_full,
1407: p_config_rec => l_config_rec,
1408: x_conn_config_tbl => l_conn_config_tbl, -- will not be used further
1409: x_return_status => x_return_status,

Line 1406: p_validation_level => fnd_api.g_valid_level_full,

1402: Unlock_Current_Node(
1403: p_api_version => 1.0,
1404: p_init_msg_list => fnd_api.g_true,
1405: p_commit => fnd_api.g_false,
1406: p_validation_level => fnd_api.g_valid_level_full,
1407: p_config_rec => l_config_rec,
1408: x_conn_config_tbl => l_conn_config_tbl, -- will not be used further
1409: x_return_status => x_return_status,
1410: x_msg_count => x_msg_count,

Line 1413: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1409: x_return_status => x_return_status,
1410: x_msg_count => x_msg_count,
1411: x_msg_data => x_msg_data);
1412:
1413: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1414: debug('Failed unlock_current_node for IJs...');
1415: RAISE fnd_api.g_exc_error;
1416: END IF;
1417: END IF;

Line 1415: RAISE fnd_api.g_exc_error;

1411: x_msg_data => x_msg_data);
1412:
1413: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1414: debug('Failed unlock_current_node for IJs...');
1415: RAISE fnd_api.g_exc_error;
1416: END IF;
1417: END IF;
1418: END LOOP;
1419: END IF;

Line 1435: WHEN fnd_api.g_exc_error THEN

1431: (p_count => x_msg_count ,
1432: p_data => x_msg_data );
1433:
1434: EXCEPTION
1435: WHEN fnd_api.g_exc_error THEN
1436: x_return_status := fnd_api.g_ret_sts_error;
1437: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1438: FND_MSG_PUB.Count_And_Get
1439: (p_count => x_msg_count ,

Line 1436: x_return_status := fnd_api.g_ret_sts_error;

1432: p_data => x_msg_data );
1433:
1434: EXCEPTION
1435: WHEN fnd_api.g_exc_error THEN
1436: x_return_status := fnd_api.g_ret_sts_error;
1437: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1438: FND_MSG_PUB.Count_And_Get
1439: (p_count => x_msg_count ,
1440: p_data => x_msg_data );

Line 1450: x_return_status := fnd_api.g_ret_sts_error;

1446: fnd_msg_pub.add;
1447: FND_MSG_PUB.Count_And_Get
1448: (p_count => x_msg_count ,
1449: p_data => x_msg_data );
1450: x_return_status := fnd_api.g_ret_sts_error;
1451: l_return_message := csi_t_gen_utility_pvt.dump_error_stack;
1452: rollback to csi_cz_unlock_item;
1453: debug(l_return_message);
1454:

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

1481: ORDER BY config_session_item_id;
1482:
1483: l_session_keys csi_utility_grp.config_session_keys;
1484: l_instance_tbl csi_datastructures_pub.instance_tbl;
1485: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1486:
1487: -- Added for BUg 3711457
1488: l_config_keys td_cur%ROWTYPE;
1489: l_usage_exists number;

Line 1495: x_return_status := fnd_api.g_ret_sts_success;

1491: l_error_message varchar2(2000);
1492:
1493: BEGIN
1494:
1495: x_return_status := fnd_api.g_ret_sts_success;
1496:
1497: csi_t_gen_utility_pvt.build_file_name(
1498: p_file_segment1 => 'csiczuii',
1499: p_file_segment2 => p_session_hdr_id);

Line 1535: raise fnd_api.g_exc_error;

1531: THEN
1532: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1533: fnd_message.set_token('MESSAGE', l_error_message);
1534: fnd_msg_pub.add;
1535: raise fnd_api.g_exc_error;
1536: END IF;
1537: CLOSE td_cur;
1538: END IF;
1539:

Line 1544: p_session_rev_num_new <> fnd_api.g_miss_num

1540: IF p_action = 'SAVE'
1541: AND
1542: ( p_session_rev_num_new is not null
1543: AND
1544: p_session_rev_num_new <> fnd_api.g_miss_num
1545: )
1546: THEN
1547: -- End Code Fix for 3711457
1548: -- Included new parameter for the cursor for Bug 3711457

Line 1564: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1560: p_instance_id => p_instance_id,
1561: x_instance_tbl => l_instance_tbl,
1562: x_return_status => l_return_status);
1563:
1564: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1565: raise fnd_api.g_exc_error;
1566: END IF;
1567:
1568: debug('Re-Configure from Install Base HTML User Interface successful.');

Line 1565: raise fnd_api.g_exc_error;

1561: x_instance_tbl => l_instance_tbl,
1562: x_return_status => l_return_status);
1563:
1564: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1565: raise fnd_api.g_exc_error;
1566: END IF;
1567:
1568: debug('Re-Configure from Install Base HTML User Interface successful.');
1569: END IF; -- Added for Bug 3711457

Line 1572: WHEN fnd_api.g_exc_error THEN

1568: debug('Re-Configure from Install Base HTML User Interface successful.');
1569: END IF; -- Added for Bug 3711457
1570:
1571: EXCEPTION
1572: WHEN fnd_api.g_exc_error THEN
1573:
1574: rollback to configure_from_html_ui;
1575:
1576: x_return_status := fnd_api.g_ret_sts_error;

Line 1576: x_return_status := fnd_api.g_ret_sts_error;

1572: WHEN fnd_api.g_exc_error THEN
1573:
1574: rollback to configure_from_html_ui;
1575:
1576: x_return_status := fnd_api.g_ret_sts_error;
1577: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
1578: x_msg_data := x_error_message;
1579: x_msg_count := 1;
1580: WHEN others THEN

Line 1584: x_return_status := fnd_api.g_ret_sts_error;

1580: WHEN others THEN
1581:
1582: rollback to configure_from_html_ui;
1583:
1584: x_return_status := fnd_api.g_ret_sts_error;
1585: x_error_message := substr(sqlerrm, 1, 500);
1586: x_msg_data := x_error_message;
1587: x_msg_count := 1;
1588:

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

1593: END configure_from_html_ui;
1594:
1595: Procedure CSI_CONFIG_LAUNCH_PRMS
1596: ( p_api_version IN NUMBER,
1597: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1598: p_commit IN VARCHAR2 := FND_API.g_false,
1599: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1600: x_return_status OUT NOCOPY VARCHAR2,
1601: x_msg_count OUT NOCOPY NUMBER,

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

1594:
1595: Procedure CSI_CONFIG_LAUNCH_PRMS
1596: ( p_api_version IN NUMBER,
1597: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1598: p_commit IN VARCHAR2 := FND_API.g_false,
1599: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1600: x_return_status OUT NOCOPY VARCHAR2,
1601: x_msg_count OUT NOCOPY NUMBER,
1602: x_msg_data OUT NOCOPY VARCHAR2,

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

1595: Procedure CSI_CONFIG_LAUNCH_PRMS
1596: ( p_api_version IN NUMBER,
1597: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1598: p_commit IN VARCHAR2 := FND_API.g_false,
1599: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1600: x_return_status OUT NOCOPY VARCHAR2,
1601: x_msg_count OUT NOCOPY NUMBER,
1602: x_msg_data OUT NOCOPY VARCHAR2,
1603: x_configurable OUT NOCOPY VARCHAR2,

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

1618: l_user_id := fnd_global.user_id;
1619:
1620: SAVEPOINT CSI_CONFIG_LAUNCH_PRMS;
1621: -- Standard call to check for call compatibility.
1622: /*IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1623: p_api_version ,
1624: l_api_name ,
1625: G_PKG_NAME )
1626: THEN

Line 1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1623: p_api_version ,
1624: l_api_name ,
1625: G_PKG_NAME )
1626: THEN
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END IF;*/
1629:
1630: -- Initialize message list if p_init_msg_list is set to TRUE.
1631: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1631: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END IF;*/
1629:
1630: -- Initialize message list if p_init_msg_list is set to TRUE.
1631: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1632: FND_MSG_PUB.initialize;
1633: END IF;
1634:
1635: -- Initialize API rturn status to success

Line 1636: x_return_status := FND_API.g_ret_sts_success;

1632: FND_MSG_PUB.initialize;
1633: END IF;
1634:
1635: -- Initialize API rturn status to success
1636: x_return_status := FND_API.g_ret_sts_success;
1637:
1638:
1639: l_resp_id := fnd_profile.value('RESP_ID');
1640: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

Line 1655: IF FND_API.To_Boolean( p_commit ) THEN

1651: -- get the SYSDATE
1652: x_sysdate := to_char(sysdate,'mm-dd-yyyy-hh24-mi-ss');
1653:
1654:
1655: IF FND_API.To_Boolean( p_commit ) THEN
1656: COMMIT WORK;
1657: END IF;
1658: FND_MSG_PUB.Count_And_Get
1659: ( p_encoded => FND_API.G_FALSE,

Line 1659: ( p_encoded => FND_API.G_FALSE,

1655: IF FND_API.To_Boolean( p_commit ) THEN
1656: COMMIT WORK;
1657: END IF;
1658: FND_MSG_PUB.Count_And_Get
1659: ( p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => x_msg_data
1662: );
1663: EXCEPTION

Line 1664: WHEN FND_API.G_EXC_ERROR THEN

1660: p_count => x_msg_count,
1661: p_data => x_msg_data
1662: );
1663: EXCEPTION
1664: WHEN FND_API.G_EXC_ERROR THEN
1665: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1666: x_return_status := FND_API.G_RET_STS_ERROR ;
1667: FND_MSG_PUB.Count_And_Get
1668: ( p_encoded => FND_API.G_FALSE,

Line 1666: x_return_status := FND_API.G_RET_STS_ERROR ;

1662: );
1663: EXCEPTION
1664: WHEN FND_API.G_EXC_ERROR THEN
1665: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1666: x_return_status := FND_API.G_RET_STS_ERROR ;
1667: FND_MSG_PUB.Count_And_Get
1668: ( p_encoded => FND_API.G_FALSE,
1669: p_count => x_msg_count,
1670: p_data => x_msg_data

Line 1668: ( p_encoded => FND_API.G_FALSE,

1664: WHEN FND_API.G_EXC_ERROR THEN
1665: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1666: x_return_status := FND_API.G_RET_STS_ERROR ;
1667: FND_MSG_PUB.Count_And_Get
1668: ( p_encoded => FND_API.G_FALSE,
1669: p_count => x_msg_count,
1670: p_data => x_msg_data
1671: );
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1668: ( p_encoded => FND_API.G_FALSE,
1669: p_count => x_msg_count,
1670: p_data => x_msg_data
1671: );
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1674: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: FND_MSG_PUB.Count_And_Get

Line 1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1671: );
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1674: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: FND_MSG_PUB.Count_And_Get
1677: ( p_encoded => FND_API.G_FALSE,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data

Line 1677: ( p_encoded => FND_API.G_FALSE,

1673: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: UNEXPECTED ERROR EXCEPTION ');
1674: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1676: FND_MSG_PUB.Count_And_Get
1677: ( p_encoded => FND_API.G_FALSE,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data
1680: );
1681: WHEN OTHERS THEN

Line 1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1680: );
1681: WHEN OTHERS THEN
1682: csi_gen_utility_pvt.put_line('csi_cz_int.CSI_CONFIG_LAUNCH_PRMS: OTHER EXCEPTION ');
1683: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1685: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1686: THEN
1687: FND_MSG_PUB.Add_Exc_Msg
1688: ( G_PKG_NAME,

Line 1693: ( p_encoded => FND_API.G_FALSE,

1689: l_api_name
1690: );
1691: END IF;*/
1692: FND_MSG_PUB.Count_And_Get
1693: ( p_encoded => FND_API.G_FALSE,
1694: p_count => x_msg_count,
1695: p_data => x_msg_data
1696: );
1697: /*ibe_util.disable_debug;*/

Line 1724: IF x_return_value = FND_API.G_FALSE

1720: ,x_msg_data);
1721:
1722: -- Begin of fix for Bug 2873845
1723: -- Checking whether the config keys has a Instance.
1724: IF x_return_value = FND_API.G_FALSE
1725: THEN
1726: Begin
1727: Select count(*)
1728: Into l_found

Line 1739: x_return_value := FND_API.G_TRUE;

1735: and c.config_rev_nbr = p_config_rev_nbr
1736: and c.config_item_id = p_config_item_id;
1737:
1738: IF NVL(l_found,0) > 0 Then
1739: x_return_value := FND_API.G_TRUE;
1740: ELSE
1741: x_return_value := FND_API.G_FALSE;
1742: END IF;
1743:

Line 1741: x_return_value := FND_API.G_FALSE;

1737:
1738: IF NVL(l_found,0) > 0 Then
1739: x_return_value := FND_API.G_TRUE;
1740: ELSE
1741: x_return_value := FND_API.G_FALSE;
1742: END IF;
1743:
1744: End;
1745: END IF;