3801: WHEN document_is_null
3802: THEN
3803: NULL;
3804: WHEN EXPLORETREE_ERROR THEN
3805: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
3806: fnd_message.set_token('ERROR_TEXT', SQLERRM);
3807: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
3808: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
3809: cz_pb_mgr.v_err_message := fnd_message.get;
3802: THEN
3803: NULL;
3804: WHEN EXPLORETREE_ERROR THEN
3805: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
3806: fnd_message.set_token('ERROR_TEXT', SQLERRM);
3807: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
3808: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
3809: cz_pb_mgr.v_err_message := fnd_message.get;
3810: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
3803: NULL;
3804: WHEN EXPLORETREE_ERROR THEN
3805: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
3806: fnd_message.set_token('ERROR_TEXT', SQLERRM);
3807: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
3808: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
3809: cz_pb_mgr.v_err_message := fnd_message.get;
3810: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
3811: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3804: WHEN EXPLORETREE_ERROR THEN
3805: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
3806: fnd_message.set_token('ERROR_TEXT', SQLERRM);
3807: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
3808: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
3809: cz_pb_mgr.v_err_message := fnd_message.get;
3810: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
3811: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3812:
3805: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
3806: fnd_message.set_token('ERROR_TEXT', SQLERRM);
3807: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
3808: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
3809: cz_pb_mgr.v_err_message := fnd_message.get;
3810: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
3811: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3812:
3813: RAISE;
6102: FOR i IN cz_pb_mgr.v_msg_tbl.FIRST .. cz_pb_mgr.v_msg_tbl.LAST
6103: LOOP
6104: IF ((cz_pb_mgr.v_msg_tbl(i).msg_text IS NOT NULL) AND(cz_pb_mgr.v_msg_tbl(i).msg_text NOT LIKE '%publication%'))
6105: THEN
6106: fnd_message.set_name('CZ', 'CZ_MODEL_COPY_ERR');
6107: fnd_message.set_token('ERRORMSG', cz_pb_mgr.v_msg_tbl(i).msg_text);
6108: fnd_msg_pub.ADD;
6109: END IF;
6110: END LOOP;
6103: LOOP
6104: IF ((cz_pb_mgr.v_msg_tbl(i).msg_text IS NOT NULL) AND(cz_pb_mgr.v_msg_tbl(i).msg_text NOT LIKE '%publication%'))
6105: THEN
6106: fnd_message.set_name('CZ', 'CZ_MODEL_COPY_ERR');
6107: fnd_message.set_token('ERRORMSG', cz_pb_mgr.v_msg_tbl(i).msg_text);
6108: fnd_msg_pub.ADD;
6109: END IF;
6110: END LOOP;
6111: END IF;
19934: EXCEPTION
19935: WHEN no_link_name
19936: THEN
19937: x_return_status := FND_API.G_RET_STS_ERROR;
19938: fnd_message.set_name('CZ', 'CZ_NO_LINK_NAME');
19939: fnd_msg_pub.ADD;
19940: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19941: WHEN cannot_del_pup
19942: THEN
19940: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19941: WHEN cannot_del_pup
19942: THEN
19943: x_return_status := FND_API.G_RET_STS_ERROR;
19944: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');
19945: fnd_message.set_token('PUBID', publicationid);
19946: fnd_msg_pub.ADD;
19947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19948: WHEN invalid_object_type
19941: WHEN cannot_del_pup
19942: THEN
19943: x_return_status := FND_API.G_RET_STS_ERROR;
19944: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');
19945: fnd_message.set_token('PUBID', publicationid);
19946: fnd_msg_pub.ADD;
19947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19948: WHEN invalid_object_type
19949: THEN
19947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19948: WHEN invalid_object_type
19949: THEN
19950: x_return_status := FND_API.G_RET_STS_ERROR;
19951: fnd_message.set_name('CZ', 'CZ_INVALID_PUB_TYPE');
19952: fnd_msg_pub.ADD;
19953: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19954: WHEN template_in_use
19955: THEN
19954: WHEN template_in_use
19955: THEN
19956: x_msg_data := cz_utils.get_text('CZ_TEMPLATE_IN_USE');
19957: x_return_status := FND_API.G_RET_STS_ERROR;
19958: fnd_message.set_name('CZ', 'CZ_TEMPLATE_IN_USE');
19959: fnd_msg_pub.ADD;
19960: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19961: WHEN OTHERS
19962: THEN
20049: WHEN cannot_disable_publication
20050: THEN
20051: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
20052: x_return_status := FND_API.G_RET_STS_ERROR;
20053: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
20054: fnd_message.set_token('STATUS', v_export_status);
20055: fnd_message.set_token('PUBID', publicationid);
20056: fnd_msg_pub.ADD;
20057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20050: THEN
20051: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
20052: x_return_status := FND_API.G_RET_STS_ERROR;
20053: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
20054: fnd_message.set_token('STATUS', v_export_status);
20055: fnd_message.set_token('PUBID', publicationid);
20056: fnd_msg_pub.ADD;
20057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20058: WHEN pub_maybe_obsoleted
20051: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
20052: x_return_status := FND_API.G_RET_STS_ERROR;
20053: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
20054: fnd_message.set_token('STATUS', v_export_status);
20055: fnd_message.set_token('PUBID', publicationid);
20056: fnd_msg_pub.ADD;
20057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20058: WHEN pub_maybe_obsoleted
20059: THEN
21251: WHEN pub_overlap
21252: THEN
21253: ROLLBACK;
21254: x_return_status := FND_API.G_RET_STS_ERROR;
21255: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21256: fnd_message.set_token('PubId', p_publication_id);
21257: fnd_message.set_token('PUBSTR', v_publicationidstring);
21258: fnd_msg_pub.ADD;
21259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21252: THEN
21253: ROLLBACK;
21254: x_return_status := FND_API.G_RET_STS_ERROR;
21255: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21256: fnd_message.set_token('PubId', p_publication_id);
21257: fnd_message.set_token('PUBSTR', v_publicationidstring);
21258: fnd_msg_pub.ADD;
21259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21260: WHEN ui_def_id_is_deleted
21253: ROLLBACK;
21254: x_return_status := FND_API.G_RET_STS_ERROR;
21255: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21256: fnd_message.set_token('PubId', p_publication_id);
21257: fnd_message.set_token('PUBSTR', v_publicationidstring);
21258: fnd_msg_pub.ADD;
21259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21260: WHEN ui_def_id_is_deleted
21261: THEN
21262: x_return_status := FND_API.G_RET_STS_ERROR;
21263:
21264: IF (l_ui_name IS NOT NULL)
21265: THEN
21266: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
21267: fnd_message.set_token('UIDEFID', l_ui_name);
21268: fnd_msg_pub.ADD;
21269: ELSE
21270: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
21263:
21264: IF (l_ui_name IS NOT NULL)
21265: THEN
21266: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
21267: fnd_message.set_token('UIDEFID', l_ui_name);
21268: fnd_msg_pub.ADD;
21269: ELSE
21270: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
21271: fnd_message.set_token('UIDEFID', v_source_pb_record.ui_def_id);
21266: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
21267: fnd_message.set_token('UIDEFID', l_ui_name);
21268: fnd_msg_pub.ADD;
21269: ELSE
21270: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
21271: fnd_message.set_token('UIDEFID', v_source_pb_record.ui_def_id);
21272: fnd_msg_pub.ADD;
21273: END IF;
21274:
21267: fnd_message.set_token('UIDEFID', l_ui_name);
21268: fnd_msg_pub.ADD;
21269: ELSE
21270: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
21271: fnd_message.set_token('UIDEFID', v_source_pb_record.ui_def_id);
21272: fnd_msg_pub.ADD;
21273: END IF;
21274:
21275: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21276: WHEN model_not_upto_date
21277: THEN
21278: ROLLBACK;
21279: x_return_status := FND_API.G_RET_STS_ERROR;
21280: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
21281: fnd_message.set_token('PubId', p_publication_id);
21282: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
21283: fnd_msg_pub.ADD;
21284: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21277: THEN
21278: ROLLBACK;
21279: x_return_status := FND_API.G_RET_STS_ERROR;
21280: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
21281: fnd_message.set_token('PubId', p_publication_id);
21282: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
21283: fnd_msg_pub.ADD;
21284: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21285: WHEN get_params_exception
21278: ROLLBACK;
21279: x_return_status := FND_API.G_RET_STS_ERROR;
21280: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
21281: fnd_message.set_token('PubId', p_publication_id);
21282: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
21283: fnd_msg_pub.ADD;
21284: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21285: WHEN get_params_exception
21286: THEN
21285: WHEN get_params_exception
21286: THEN
21287: ROLLBACK;
21288: x_return_status := FND_API.G_RET_STS_ERROR;
21289: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
21290: fnd_message.set_token('PubId', p_publication_id);
21291: fnd_msg_pub.ADD;
21292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21293: WHEN expstatus_exception
21286: THEN
21287: ROLLBACK;
21288: x_return_status := FND_API.G_RET_STS_ERROR;
21289: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
21290: fnd_message.set_token('PubId', p_publication_id);
21291: fnd_msg_pub.ADD;
21292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21293: WHEN expstatus_exception
21294: THEN
21293: WHEN expstatus_exception
21294: THEN
21295: ROLLBACK;
21296: x_return_status := FND_API.G_RET_STS_ERROR;
21297: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
21298: fnd_message.set_token('PubId', p_publication_id);
21299: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
21300: fnd_msg_pub.ADD;
21301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21294: THEN
21295: ROLLBACK;
21296: x_return_status := FND_API.G_RET_STS_ERROR;
21297: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
21298: fnd_message.set_token('PubId', p_publication_id);
21299: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
21300: fnd_msg_pub.ADD;
21301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21302: cz_pb_mgr.v_republish_model := no_mode;
21295: ROLLBACK;
21296: x_return_status := FND_API.G_RET_STS_ERROR;
21297: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
21298: fnd_message.set_token('PubId', p_publication_id);
21299: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
21300: fnd_msg_pub.ADD;
21301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21302: cz_pb_mgr.v_republish_model := no_mode;
21303: WHEN pub_maybe_obsoleted
21306: WHEN OTHERS
21307: THEN
21308: ROLLBACK;
21309: x_return_status := fnd_api.g_ret_sts_unexp_error;
21310: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
21311: fnd_message.set_token('PubId', p_publication_id);
21312: fnd_message.set_token('SQLERRM', SQLERRM);
21313: fnd_msg_pub.ADD;
21314: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21307: THEN
21308: ROLLBACK;
21309: x_return_status := fnd_api.g_ret_sts_unexp_error;
21310: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
21311: fnd_message.set_token('PubId', p_publication_id);
21312: fnd_message.set_token('SQLERRM', SQLERRM);
21313: fnd_msg_pub.ADD;
21314: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21315: END create_republish_publication;
21308: ROLLBACK;
21309: x_return_status := fnd_api.g_ret_sts_unexp_error;
21310: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
21311: fnd_message.set_token('PubId', p_publication_id);
21312: fnd_message.set_token('SQLERRM', SQLERRM);
21313: fnd_msg_pub.ADD;
21314: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21315: END create_republish_publication;
21316:
21755: WHEN cannot_enable_publication
21756: THEN
21757: x_return_status := FND_API.G_RET_STS_ERROR;
21758: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
21759: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
21760: fnd_message.set_token('STATUS', v_export_status);
21761: fnd_message.set_token('PUBID', publicationid);
21762: fnd_msg_pub.ADD;
21763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21756: THEN
21757: x_return_status := FND_API.G_RET_STS_ERROR;
21758: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
21759: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
21760: fnd_message.set_token('STATUS', v_export_status);
21761: fnd_message.set_token('PUBID', publicationid);
21762: fnd_msg_pub.ADD;
21763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21764: WHEN cannot_enable_template
21757: x_return_status := FND_API.G_RET_STS_ERROR;
21758: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
21759: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
21760: fnd_message.set_token('STATUS', v_export_status);
21761: fnd_message.set_token('PUBID', publicationid);
21762: fnd_msg_pub.ADD;
21763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21764: WHEN cannot_enable_template
21765: THEN
21764: WHEN cannot_enable_template
21765: THEN
21766: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);
21767: x_return_status := FND_API.G_RET_STS_ERROR;
21768: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_TEMPL');
21769: fnd_message.set_token('PUBID', publicationid);
21770: fnd_msg_pub.ADD;
21771: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21772: WHEN get_params_exception
21765: THEN
21766: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);
21767: x_return_status := FND_API.G_RET_STS_ERROR;
21768: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_TEMPL');
21769: fnd_message.set_token('PUBID', publicationid);
21770: fnd_msg_pub.ADD;
21771: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21772: WHEN get_params_exception
21773: THEN
21772: WHEN get_params_exception
21773: THEN
21774: ROLLBACK;
21775: x_return_status := FND_API.G_RET_STS_ERROR;
21776: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
21777: fnd_message.set_token('PUBID', publicationid);
21778: fnd_msg_pub.ADD;
21779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21780: WHEN pub_overlap
21773: THEN
21774: ROLLBACK;
21775: x_return_status := FND_API.G_RET_STS_ERROR;
21776: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
21777: fnd_message.set_token('PUBID', publicationid);
21778: fnd_msg_pub.ADD;
21779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21780: WHEN pub_overlap
21781: THEN
21780: WHEN pub_overlap
21781: THEN
21782: ROLLBACK;
21783: x_return_status := FND_API.G_RET_STS_ERROR;
21784: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21785: fnd_message.set_token('PUBID', publicationid);
21786: fnd_message.set_token('PUBSTR', l_publicationidstring);
21787: fnd_msg_pub.ADD;
21788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21781: THEN
21782: ROLLBACK;
21783: x_return_status := FND_API.G_RET_STS_ERROR;
21784: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21785: fnd_message.set_token('PUBID', publicationid);
21786: fnd_message.set_token('PUBSTR', l_publicationidstring);
21787: fnd_msg_pub.ADD;
21788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21789: WHEN pub_maybe_obsoleted
21782: ROLLBACK;
21783: x_return_status := FND_API.G_RET_STS_ERROR;
21784: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21785: fnd_message.set_token('PUBID', publicationid);
21786: fnd_message.set_token('PUBSTR', l_publicationidstring);
21787: fnd_msg_pub.ADD;
21788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21789: WHEN pub_maybe_obsoleted
21790: THEN
22122: EXCEPTION
22123: WHEN product_key_is_null
22124: THEN
22125: x_return_status := FND_API.G_RET_STS_ERROR;
22126: fnd_message.set_name('CZ', 'CZ_PRODUCT_KEY_IS_NULL');
22127: fnd_msg_pub.ADD;
22128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22129: WHEN no_model_id
22130: THEN
22128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22129: WHEN no_model_id
22130: THEN
22131: x_return_status := FND_API.G_RET_STS_ERROR;
22132: fnd_message.set_name('CZ', 'cz_pb_mgr_MODEL_ID_NULL');
22133: fnd_msg_pub.ADD;
22134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22135: WHEN no_model_exists
22136: THEN
22134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22135: WHEN no_model_exists
22136: THEN
22137: x_return_status := FND_API.G_RET_STS_ERROR;
22138: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');
22139: fnd_message.set_token('MODELID', p_model_id);
22140: fnd_msg_pub.ADD;
22141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22142: WHEN no_ui_exists
22135: WHEN no_model_exists
22136: THEN
22137: x_return_status := FND_API.G_RET_STS_ERROR;
22138: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');
22139: fnd_message.set_token('MODELID', p_model_id);
22140: fnd_msg_pub.ADD;
22141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22142: WHEN no_ui_exists
22143: THEN
22141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22142: WHEN no_ui_exists
22143: THEN
22144: x_return_status := FND_API.G_RET_STS_ERROR;
22145: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');
22146: fnd_message.set_token('MODELID', p_model_id);
22147: fnd_msg_pub.ADD;
22148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22149: WHEN invalid_pb_mode
22142: WHEN no_ui_exists
22143: THEN
22144: x_return_status := FND_API.G_RET_STS_ERROR;
22145: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');
22146: fnd_message.set_token('MODELID', p_model_id);
22147: fnd_msg_pub.ADD;
22148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22149: WHEN invalid_pb_mode
22150: THEN
22148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22149: WHEN invalid_pb_mode
22150: THEN
22151: x_return_status := FND_API.G_RET_STS_ERROR;
22152: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');
22153: fnd_message.set_token('PBMODE', l_publication_mode);
22154: fnd_msg_pub.ADD;
22155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22156: WHEN no_appl_id
22149: WHEN invalid_pb_mode
22150: THEN
22151: x_return_status := FND_API.G_RET_STS_ERROR;
22152: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');
22153: fnd_message.set_token('PBMODE', l_publication_mode);
22154: fnd_msg_pub.ADD;
22155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22156: WHEN no_appl_id
22157: THEN
22155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22156: WHEN no_appl_id
22157: THEN
22158: x_return_status := FND_API.G_RET_STS_ERROR;
22159: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_APPL_ID');
22160: fnd_msg_pub.ADD;
22161: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22162: WHEN pub_overlap
22163: THEN
22161: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22162: WHEN pub_overlap
22163: THEN
22164: x_return_status := FND_API.G_RET_STS_ERROR;
22165: fnd_message.set_name('CZ', 'PUB_OVERLAP');
22166: fnd_message.set_token('PUB_OVERLAP', v_publicationidstring);
22167: fnd_msg_pub.ADD;
22168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22169: WHEN model_not_upto_date
22162: WHEN pub_overlap
22163: THEN
22164: x_return_status := FND_API.G_RET_STS_ERROR;
22165: fnd_message.set_name('CZ', 'PUB_OVERLAP');
22166: fnd_message.set_token('PUB_OVERLAP', v_publicationidstring);
22167: fnd_msg_pub.ADD;
22168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22169: WHEN model_not_upto_date
22170: THEN
22168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22169: WHEN model_not_upto_date
22170: THEN
22171: x_return_status := FND_API.G_RET_STS_ERROR;
22172: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
22173: fnd_message.set_token('UPTODATESTR', v_upto_date_status);
22174: fnd_msg_pub.ADD;
22175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22176: WHEN OTHERS
22169: WHEN model_not_upto_date
22170: THEN
22171: x_return_status := FND_API.G_RET_STS_ERROR;
22172: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
22173: fnd_message.set_token('UPTODATESTR', v_upto_date_status);
22174: fnd_msg_pub.ADD;
22175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22176: WHEN OTHERS
22177: THEN
22175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22176: WHEN OTHERS
22177: THEN
22178: x_return_status := FND_API.G_RET_STS_ERROR;
22179: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
22180: fnd_message.set_token('ERROR', SQLERRM);
22181: fnd_msg_pub.ADD;
22182: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22183: END create_publication_request;
22176: WHEN OTHERS
22177: THEN
22178: x_return_status := FND_API.G_RET_STS_ERROR;
22179: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
22180: fnd_message.set_token('ERROR', SQLERRM);
22181: fnd_msg_pub.ADD;
22182: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22183: END create_publication_request;
22184: