157: */
158:
159: ELSE
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:
158:
159: ELSE
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
169: x_install_config_rec.config_inst_rev_num := null;
170: /*
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;
168: IF NOT(l_rev_found) THEN
169: x_install_config_rec.config_inst_rev_num := null;
170: /*
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: */
169: x_install_config_rec.config_inst_rev_num := null;
170: /*
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;
412: AND czItems.config_item_id = cii.config_inst_item_id
413: AND czItems.component_instance_type = 'I' -- I = Root instance
414: AND czItems.deleted_flag = '0');
415: Exception when others then
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;
413: AND czItems.component_instance_type = 'I' -- I = Root instance
414: AND czItems.deleted_flag = '0');
415: Exception when others then
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;
414: AND czItems.deleted_flag = '0');
415: Exception when others then
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:
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);
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;
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);
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;
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);
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:
673: x_msg_data => x_msg_data);
674:
675: IF (l_lock)
676: THEN
677: fnd_message.set_name('CSI','CSI_CONFIG_KEYS_LOCKED');
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;
674:
675: IF (l_lock)
676: THEN
677: fnd_message.set_name('CSI','CSI_CONFIG_KEYS_LOCKED');
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;
675: IF (l_lock)
676: THEN
677: fnd_message.set_name('CSI','CSI_CONFIG_KEYS_LOCKED');
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;
676: THEN
677: fnd_message.set_name('CSI','CSI_CONFIG_KEYS_LOCKED');
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
700: AND oel.configuration_id = l_CONFIG_SESSION_ITEM_ID;
701:
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;
802: p_data => x_msg_data );
803: rollback to csi_cz_lock_item;
804: debug(l_return_message);
805: WHEN others THEN
806: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
807: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
808: fnd_msg_pub.add;
809: FND_MSG_PUB.Count_And_Get
810: (p_count => x_msg_count ,
803: rollback to csi_cz_lock_item;
804: debug(l_return_message);
805: WHEN others THEN
806: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
807: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
808: fnd_msg_pub.add;
809: FND_MSG_PUB.Count_And_Get
810: (p_count => x_msg_count ,
811: p_data => x_msg_data );
1190: p_data => x_msg_data );
1191: rollback to unlock_current_node;
1192: debug(l_return_message);
1193: WHEN others THEN
1194: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1195: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1196: fnd_msg_pub.add;
1197: FND_MSG_PUB.Count_And_Get
1198: (p_count => x_msg_count ,
1191: rollback to unlock_current_node;
1192: debug(l_return_message);
1193: WHEN others THEN
1194: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1195: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1196: fnd_msg_pub.add;
1197: FND_MSG_PUB.Count_And_Get
1198: (p_count => x_msg_count ,
1199: p_data => x_msg_data );
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);
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;
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);
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;
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);
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;
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);
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;
1418: END LOOP;
1419: END IF;
1420: ELSE
1421: debug('Config keys are already in unlocked status');
1422: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LOCKS');
1423: FND_MSG_PUB.Add;
1424: END IF;
1425: END LOOP;
1426: END IF;
1440: p_data => x_msg_data );
1441: rollback to csi_cz_unlock_item;
1442: debug(l_return_message);
1443: WHEN others THEN
1444: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1445: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1446: fnd_msg_pub.add;
1447: FND_MSG_PUB.Count_And_Get
1448: (p_count => x_msg_count ,
1441: rollback to csi_cz_unlock_item;
1442: debug(l_return_message);
1443: WHEN others THEN
1444: fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
1445: fnd_message.set_token('MESSAGE', 'OTHERS Error :'||substr(sqlerrm, 1, 300));
1446: fnd_msg_pub.add;
1447: FND_MSG_PUB.Count_And_Get
1448: (p_count => x_msg_count ,
1449: p_data => x_msg_data );
1528: IF l_return_value <> 1
1529: AND
1530: td_cur%ROWCOUNT > 0
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;
1529: AND
1530: td_cur%ROWCOUNT > 0
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;
1585: x_error_message := substr(sqlerrm, 1, 500);
1586: x_msg_data := x_error_message;
1587: x_msg_count := 1;
1588:
1589: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1590: fnd_message.set_token('MESSAGE', x_error_message);
1591: fnd_msg_pub.add;
1592:
1593: END configure_from_html_ui;
1586: x_msg_data := x_error_message;
1587: x_msg_count := 1;
1588:
1589: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1590: fnd_message.set_token('MESSAGE', x_error_message);
1591: fnd_msg_pub.add;
1592:
1593: END configure_from_html_ui;
1594: