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.CZ_PB_MGR dependencies on FND_MESSAGE

Line 682: fnd_message.set_name('CZ', 'CZ_MODEL_COPY_ERR');

678: FOR i IN cz_pb_mgr.v_msg_tbl.FIRST .. cz_pb_mgr.v_msg_tbl.LAST
679: LOOP
680: 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%'))
681: THEN
682: fnd_message.set_name('CZ', 'CZ_MODEL_COPY_ERR');
683: fnd_message.set_token('ERRORMSG', cz_pb_mgr.v_msg_tbl(i).msg_text);
684: fnd_msg_pub.ADD;
685: END IF;
686: END LOOP;

Line 683: fnd_message.set_token('ERRORMSG', cz_pb_mgr.v_msg_tbl(i).msg_text);

679: LOOP
680: 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%'))
681: THEN
682: fnd_message.set_name('CZ', 'CZ_MODEL_COPY_ERR');
683: fnd_message.set_token('ERRORMSG', cz_pb_mgr.v_msg_tbl(i).msg_text);
684: fnd_msg_pub.ADD;
685: END IF;
686: END LOOP;
687: END IF;

Line 4450: fnd_message.set_token('ERROR_TEXT', SQLERRM);

4446: THEN
4447: NULL;
4448: --bug14191479. To handle value errors.
4449: WHEN VALUE_ERROR THEN
4450: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4451: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4452: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4453: cz_pb_mgr.v_err_message := fnd_message.get;
4454: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);

Line 4451: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');

4447: NULL;
4448: --bug14191479. To handle value errors.
4449: WHEN VALUE_ERROR THEN
4450: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4451: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4452: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4453: cz_pb_mgr.v_err_message := fnd_message.get;
4454: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
4455: --bug14191479. Log message added for JRAD Doc

Line 4452: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');

4448: --bug14191479. To handle value errors.
4449: WHEN VALUE_ERROR THEN
4450: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4451: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4452: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4453: cz_pb_mgr.v_err_message := fnd_message.get;
4454: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
4455: --bug14191479. Log message added for JRAD Doc
4456: cz_pb_mgr.error_msg_populate('Jrad doc: ' ||p_old_document_name ,'cz_pb_mgr.EXPLORETREE',SQLCODE);

Line 4453: cz_pb_mgr.v_err_message := fnd_message.get;

4449: WHEN VALUE_ERROR THEN
4450: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4451: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4452: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4453: cz_pb_mgr.v_err_message := fnd_message.get;
4454: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
4455: --bug14191479. Log message added for JRAD Doc
4456: cz_pb_mgr.error_msg_populate('Jrad doc: ' ||p_old_document_name ,'cz_pb_mgr.EXPLORETREE',SQLCODE);
4457: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;

Line 4461: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');

4457: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4458: RAISE;
4459:
4460: WHEN EXPLORETREE_ERROR THEN
4461: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
4462: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4463: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4464: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4465: cz_pb_mgr.v_err_message := fnd_message.get;

Line 4462: fnd_message.set_token('ERROR_TEXT', SQLERRM);

4458: RAISE;
4459:
4460: WHEN EXPLORETREE_ERROR THEN
4461: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
4462: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4463: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4464: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4465: cz_pb_mgr.v_err_message := fnd_message.get;
4466: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);

Line 4463: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');

4459:
4460: WHEN EXPLORETREE_ERROR THEN
4461: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
4462: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4463: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4464: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4465: cz_pb_mgr.v_err_message := fnd_message.get;
4466: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
4467: --bug14151479. Log message added for JRAD Doc

Line 4464: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');

4460: WHEN EXPLORETREE_ERROR THEN
4461: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
4462: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4463: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4464: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4465: cz_pb_mgr.v_err_message := fnd_message.get;
4466: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
4467: --bug14151479. Log message added for JRAD Doc
4468: cz_pb_mgr.error_msg_populate('Jrad doc: ' ||p_old_document_name ,'cz_pb_mgr.EXPLORETREE',SQLCODE);

Line 4465: cz_pb_mgr.v_err_message := fnd_message.get;

4461: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
4462: fnd_message.set_token('ERROR_TEXT', SQLERRM);
4463: fnd_message.set_token('PKG_NAME', 'cz_pb_mgr');
4464: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
4465: cz_pb_mgr.v_err_message := fnd_message.get;
4466: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPLORETREE', SQLCODE);
4467: --bug14151479. Log message added for JRAD Doc
4468: cz_pb_mgr.error_msg_populate('Jrad doc: ' ||p_old_document_name ,'cz_pb_mgr.EXPLORETREE',SQLCODE);
4469: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;

Line 21147: fnd_message.set_name('CZ', 'CZ_NO_LINK_NAME');

21143: EXCEPTION
21144: WHEN no_link_name
21145: THEN
21146: x_return_status := FND_API.G_RET_STS_ERROR;
21147: fnd_message.set_name('CZ', 'CZ_NO_LINK_NAME');
21148: fnd_msg_pub.ADD;
21149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21150: WHEN cannot_del_pup
21151: THEN

Line 21153: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');

21149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21150: WHEN cannot_del_pup
21151: THEN
21152: x_return_status := FND_API.G_RET_STS_ERROR;
21153: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');
21154: fnd_message.set_token('PUBID', publicationid);
21155: fnd_msg_pub.ADD;
21156: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21157: WHEN invalid_object_type

Line 21154: fnd_message.set_token('PUBID', publicationid);

21150: WHEN cannot_del_pup
21151: THEN
21152: x_return_status := FND_API.G_RET_STS_ERROR;
21153: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');
21154: fnd_message.set_token('PUBID', publicationid);
21155: fnd_msg_pub.ADD;
21156: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21157: WHEN invalid_object_type
21158: THEN

Line 21160: fnd_message.set_name('CZ', 'CZ_INVALID_PUB_TYPE');

21156: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21157: WHEN invalid_object_type
21158: THEN
21159: x_return_status := FND_API.G_RET_STS_ERROR;
21160: fnd_message.set_name('CZ', 'CZ_INVALID_PUB_TYPE');
21161: fnd_msg_pub.ADD;
21162: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21163: WHEN template_in_use
21164: THEN

Line 21167: fnd_message.set_name('CZ', 'CZ_TEMPLATE_IN_USE');

21163: WHEN template_in_use
21164: THEN
21165: x_msg_data := cz_utils.get_text('CZ_TEMPLATE_IN_USE');
21166: x_return_status := FND_API.G_RET_STS_ERROR;
21167: fnd_message.set_name('CZ', 'CZ_TEMPLATE_IN_USE');
21168: fnd_msg_pub.ADD;
21169: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21170: WHEN OTHERS
21171: THEN

Line 21262: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');

21258: WHEN cannot_disable_publication
21259: THEN
21260: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
21261: x_return_status := FND_API.G_RET_STS_ERROR;
21262: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
21263: fnd_message.set_token('STATUS', v_export_status);
21264: fnd_message.set_token('PUBID', publicationid);
21265: fnd_msg_pub.ADD;
21266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 21263: fnd_message.set_token('STATUS', v_export_status);

21259: THEN
21260: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
21261: x_return_status := FND_API.G_RET_STS_ERROR;
21262: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
21263: fnd_message.set_token('STATUS', v_export_status);
21264: fnd_message.set_token('PUBID', publicationid);
21265: fnd_msg_pub.ADD;
21266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21267: WHEN pub_maybe_obsoleted

Line 21264: fnd_message.set_token('PUBID', publicationid);

21260: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
21261: x_return_status := FND_API.G_RET_STS_ERROR;
21262: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
21263: fnd_message.set_token('STATUS', v_export_status);
21264: fnd_message.set_token('PUBID', publicationid);
21265: fnd_msg_pub.ADD;
21266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21267: WHEN pub_maybe_obsoleted
21268: THEN

Line 22464: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');

22460: WHEN pub_overlap
22461: THEN
22462: ROLLBACK;
22463: x_return_status := FND_API.G_RET_STS_ERROR;
22464: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22465: fnd_message.set_token('PUBID', p_publication_id);
22466: fnd_message.set_token('PUBSTR', v_publicationidstring);
22467: fnd_msg_pub.ADD;
22468: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22465: fnd_message.set_token('PUBID', p_publication_id);

22461: THEN
22462: ROLLBACK;
22463: x_return_status := FND_API.G_RET_STS_ERROR;
22464: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22465: fnd_message.set_token('PUBID', p_publication_id);
22466: fnd_message.set_token('PUBSTR', v_publicationidstring);
22467: fnd_msg_pub.ADD;
22468: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22469: WHEN ui_def_id_is_deleted

Line 22466: fnd_message.set_token('PUBSTR', v_publicationidstring);

22462: ROLLBACK;
22463: x_return_status := FND_API.G_RET_STS_ERROR;
22464: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22465: fnd_message.set_token('PUBID', p_publication_id);
22466: fnd_message.set_token('PUBSTR', v_publicationidstring);
22467: fnd_msg_pub.ADD;
22468: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22469: WHEN ui_def_id_is_deleted
22470: THEN

Line 22475: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');

22471: x_return_status := FND_API.G_RET_STS_ERROR;
22472:
22473: IF (l_ui_name IS NOT NULL)
22474: THEN
22475: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
22476: fnd_message.set_token('UIDEFID', l_ui_name);
22477: fnd_msg_pub.ADD;
22478: ELSE
22479: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');

Line 22476: fnd_message.set_token('UIDEFID', l_ui_name);

22472:
22473: IF (l_ui_name IS NOT NULL)
22474: THEN
22475: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
22476: fnd_message.set_token('UIDEFID', l_ui_name);
22477: fnd_msg_pub.ADD;
22478: ELSE
22479: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
22480: fnd_message.set_token('UIDEFID', v_source_pb_record.ui_def_id);

Line 22479: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');

22475: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
22476: fnd_message.set_token('UIDEFID', l_ui_name);
22477: fnd_msg_pub.ADD;
22478: ELSE
22479: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
22480: fnd_message.set_token('UIDEFID', v_source_pb_record.ui_def_id);
22481: fnd_msg_pub.ADD;
22482: END IF;
22483:

Line 22480: fnd_message.set_token('UIDEFID', v_source_pb_record.ui_def_id);

22476: fnd_message.set_token('UIDEFID', l_ui_name);
22477: fnd_msg_pub.ADD;
22478: ELSE
22479: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
22480: fnd_message.set_token('UIDEFID', v_source_pb_record.ui_def_id);
22481: fnd_msg_pub.ADD;
22482: END IF;
22483:
22484: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22489: fnd_message.set_name('CZ', 'CZ_REPUB_MODEL_NOT_UP_TO_DATE');

22485: WHEN model_not_upto_date
22486: THEN
22487: ROLLBACK;
22488: x_return_status := FND_API.G_RET_STS_ERROR;
22489: fnd_message.set_name('CZ', 'CZ_REPUB_MODEL_NOT_UP_TO_DATE');
22490: fnd_message.set_token('PUBID', p_publication_id);
22491: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
22492: fnd_msg_pub.ADD;
22493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22490: fnd_message.set_token('PUBID', p_publication_id);

22486: THEN
22487: ROLLBACK;
22488: x_return_status := FND_API.G_RET_STS_ERROR;
22489: fnd_message.set_name('CZ', 'CZ_REPUB_MODEL_NOT_UP_TO_DATE');
22490: fnd_message.set_token('PUBID', p_publication_id);
22491: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
22492: fnd_msg_pub.ADD;
22493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22494: WHEN get_params_exception

Line 22491: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);

22487: ROLLBACK;
22488: x_return_status := FND_API.G_RET_STS_ERROR;
22489: fnd_message.set_name('CZ', 'CZ_REPUB_MODEL_NOT_UP_TO_DATE');
22490: fnd_message.set_token('PUBID', p_publication_id);
22491: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
22492: fnd_msg_pub.ADD;
22493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22494: WHEN get_params_exception
22495: THEN

Line 22498: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');

22494: WHEN get_params_exception
22495: THEN
22496: ROLLBACK;
22497: x_return_status := FND_API.G_RET_STS_ERROR;
22498: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
22499: fnd_message.set_token('PUBID', p_publication_id);
22500: fnd_msg_pub.ADD;
22501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22502: WHEN expstatus_exception

Line 22499: fnd_message.set_token('PUBID', p_publication_id);

22495: THEN
22496: ROLLBACK;
22497: x_return_status := FND_API.G_RET_STS_ERROR;
22498: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
22499: fnd_message.set_token('PUBID', p_publication_id);
22500: fnd_msg_pub.ADD;
22501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22502: WHEN expstatus_exception
22503: THEN

Line 22506: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');

22502: WHEN expstatus_exception
22503: THEN
22504: ROLLBACK;
22505: x_return_status := FND_API.G_RET_STS_ERROR;
22506: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
22507: fnd_message.set_token('PUBID', p_publication_id);
22508: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
22509: fnd_msg_pub.ADD;
22510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22507: fnd_message.set_token('PUBID', p_publication_id);

22503: THEN
22504: ROLLBACK;
22505: x_return_status := FND_API.G_RET_STS_ERROR;
22506: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
22507: fnd_message.set_token('PUBID', p_publication_id);
22508: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
22509: fnd_msg_pub.ADD;
22510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22511: cz_pb_mgr.v_republish_model := no_mode;

Line 22508: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);

22504: ROLLBACK;
22505: x_return_status := FND_API.G_RET_STS_ERROR;
22506: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
22507: fnd_message.set_token('PUBID', p_publication_id);
22508: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
22509: fnd_msg_pub.ADD;
22510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22511: cz_pb_mgr.v_republish_model := no_mode;
22512: WHEN pub_maybe_obsoleted

Line 22519: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');

22515: WHEN OTHERS
22516: THEN
22517: ROLLBACK;
22518: x_return_status := fnd_api.g_ret_sts_unexp_error;
22519: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
22520: fnd_message.set_token('PUBID', p_publication_id);
22521: fnd_message.set_token('SQLERRM', SQLERRM);
22522: fnd_msg_pub.ADD;
22523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22520: fnd_message.set_token('PUBID', p_publication_id);

22516: THEN
22517: ROLLBACK;
22518: x_return_status := fnd_api.g_ret_sts_unexp_error;
22519: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
22520: fnd_message.set_token('PUBID', p_publication_id);
22521: fnd_message.set_token('SQLERRM', SQLERRM);
22522: fnd_msg_pub.ADD;
22523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22524: END create_republish_publication;

Line 22521: fnd_message.set_token('SQLERRM', SQLERRM);

22517: ROLLBACK;
22518: x_return_status := fnd_api.g_ret_sts_unexp_error;
22519: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
22520: fnd_message.set_token('PUBID', p_publication_id);
22521: fnd_message.set_token('SQLERRM', SQLERRM);
22522: fnd_msg_pub.ADD;
22523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22524: END create_republish_publication;
22525:

Line 22968: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');

22964: WHEN cannot_enable_publication
22965: THEN
22966: x_return_status := FND_API.G_RET_STS_ERROR;
22967: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
22968: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
22969: fnd_message.set_token('STATUS', v_export_status);
22970: fnd_message.set_token('PUBID', publicationid);
22971: fnd_msg_pub.ADD;
22972: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22969: fnd_message.set_token('STATUS', v_export_status);

22965: THEN
22966: x_return_status := FND_API.G_RET_STS_ERROR;
22967: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
22968: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
22969: fnd_message.set_token('STATUS', v_export_status);
22970: fnd_message.set_token('PUBID', publicationid);
22971: fnd_msg_pub.ADD;
22972: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22973: WHEN cannot_enable_template

Line 22970: fnd_message.set_token('PUBID', publicationid);

22966: x_return_status := FND_API.G_RET_STS_ERROR;
22967: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
22968: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
22969: fnd_message.set_token('STATUS', v_export_status);
22970: fnd_message.set_token('PUBID', publicationid);
22971: fnd_msg_pub.ADD;
22972: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22973: WHEN cannot_enable_template
22974: THEN

Line 22977: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_TEMPL');

22973: WHEN cannot_enable_template
22974: THEN
22975: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);
22976: x_return_status := FND_API.G_RET_STS_ERROR;
22977: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_TEMPL');
22978: fnd_message.set_token('PUBID', publicationid);
22979: fnd_msg_pub.ADD;
22980: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22981: WHEN get_params_exception

Line 22978: fnd_message.set_token('PUBID', publicationid);

22974: THEN
22975: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);
22976: x_return_status := FND_API.G_RET_STS_ERROR;
22977: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_TEMPL');
22978: fnd_message.set_token('PUBID', publicationid);
22979: fnd_msg_pub.ADD;
22980: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22981: WHEN get_params_exception
22982: THEN

Line 22985: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');

22981: WHEN get_params_exception
22982: THEN
22983: ROLLBACK;
22984: x_return_status := FND_API.G_RET_STS_ERROR;
22985: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
22986: fnd_message.set_token('PUBID', publicationid);
22987: fnd_msg_pub.ADD;
22988: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22989: WHEN pub_overlap

Line 22986: fnd_message.set_token('PUBID', publicationid);

22982: THEN
22983: ROLLBACK;
22984: x_return_status := FND_API.G_RET_STS_ERROR;
22985: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
22986: fnd_message.set_token('PUBID', publicationid);
22987: fnd_msg_pub.ADD;
22988: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22989: WHEN pub_overlap
22990: THEN

Line 22993: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');

22989: WHEN pub_overlap
22990: THEN
22991: ROLLBACK;
22992: x_return_status := FND_API.G_RET_STS_ERROR;
22993: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22994: fnd_message.set_token('PUBID', publicationid);
22995: fnd_message.set_token('PUBSTR', l_publicationidstring);
22996: fnd_msg_pub.ADD;
22997: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22994: fnd_message.set_token('PUBID', publicationid);

22990: THEN
22991: ROLLBACK;
22992: x_return_status := FND_API.G_RET_STS_ERROR;
22993: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22994: fnd_message.set_token('PUBID', publicationid);
22995: fnd_message.set_token('PUBSTR', l_publicationidstring);
22996: fnd_msg_pub.ADD;
22997: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22998: WHEN pub_maybe_obsoleted

Line 22995: fnd_message.set_token('PUBSTR', l_publicationidstring);

22991: ROLLBACK;
22992: x_return_status := FND_API.G_RET_STS_ERROR;
22993: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22994: fnd_message.set_token('PUBID', publicationid);
22995: fnd_message.set_token('PUBSTR', l_publicationidstring);
22996: fnd_msg_pub.ADD;
22997: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22998: WHEN pub_maybe_obsoleted
22999: THEN

Line 23335: fnd_message.set_name('CZ', 'CZ_PRODUCT_KEY_IS_NULL');

23331: EXCEPTION
23332: WHEN product_key_is_null
23333: THEN
23334: x_return_status := FND_API.G_RET_STS_ERROR;
23335: fnd_message.set_name('CZ', 'CZ_PRODUCT_KEY_IS_NULL');
23336: fnd_msg_pub.ADD;
23337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23338: WHEN no_model_id
23339: THEN

Line 23341: fnd_message.set_name('CZ', 'cz_pb_mgr_MODEL_ID_NULL');

23337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23338: WHEN no_model_id
23339: THEN
23340: x_return_status := FND_API.G_RET_STS_ERROR;
23341: fnd_message.set_name('CZ', 'cz_pb_mgr_MODEL_ID_NULL');
23342: fnd_msg_pub.ADD;
23343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23344: WHEN no_model_exists
23345: THEN

Line 23347: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');

23343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23344: WHEN no_model_exists
23345: THEN
23346: x_return_status := FND_API.G_RET_STS_ERROR;
23347: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');
23348: fnd_message.set_token('MODELID', p_model_id);
23349: fnd_msg_pub.ADD;
23350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23351: WHEN no_ui_exists

Line 23348: fnd_message.set_token('MODELID', p_model_id);

23344: WHEN no_model_exists
23345: THEN
23346: x_return_status := FND_API.G_RET_STS_ERROR;
23347: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');
23348: fnd_message.set_token('MODELID', p_model_id);
23349: fnd_msg_pub.ADD;
23350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23351: WHEN no_ui_exists
23352: THEN

Line 23354: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');

23350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23351: WHEN no_ui_exists
23352: THEN
23353: x_return_status := FND_API.G_RET_STS_ERROR;
23354: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');
23355: fnd_message.set_token('MODELID', p_model_id);
23356: fnd_msg_pub.ADD;
23357: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23358: WHEN invalid_pb_mode

Line 23355: fnd_message.set_token('MODELID', p_model_id);

23351: WHEN no_ui_exists
23352: THEN
23353: x_return_status := FND_API.G_RET_STS_ERROR;
23354: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');
23355: fnd_message.set_token('MODELID', p_model_id);
23356: fnd_msg_pub.ADD;
23357: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23358: WHEN invalid_pb_mode
23359: THEN

Line 23361: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');

23357: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23358: WHEN invalid_pb_mode
23359: THEN
23360: x_return_status := FND_API.G_RET_STS_ERROR;
23361: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');
23362: fnd_message.set_token('PBMODE', l_publication_mode);
23363: fnd_msg_pub.ADD;
23364: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23365: WHEN no_appl_id

Line 23362: fnd_message.set_token('PBMODE', l_publication_mode);

23358: WHEN invalid_pb_mode
23359: THEN
23360: x_return_status := FND_API.G_RET_STS_ERROR;
23361: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');
23362: fnd_message.set_token('PBMODE', l_publication_mode);
23363: fnd_msg_pub.ADD;
23364: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23365: WHEN no_appl_id
23366: THEN

Line 23368: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_APPL_ID');

23364: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23365: WHEN no_appl_id
23366: THEN
23367: x_return_status := FND_API.G_RET_STS_ERROR;
23368: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_APPL_ID');
23369: fnd_msg_pub.ADD;
23370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23371: WHEN pub_overlap
23372: THEN

Line 23374: fnd_message.set_name('CZ', 'PUB_OVERLAP');

23370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23371: WHEN pub_overlap
23372: THEN
23373: x_return_status := FND_API.G_RET_STS_ERROR;
23374: fnd_message.set_name('CZ', 'PUB_OVERLAP');
23375: fnd_message.set_token('PUB_OVERLAP', v_publicationidstring);
23376: fnd_msg_pub.ADD;
23377: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23378: WHEN model_not_upto_date

Line 23375: fnd_message.set_token('PUB_OVERLAP', v_publicationidstring);

23371: WHEN pub_overlap
23372: THEN
23373: x_return_status := FND_API.G_RET_STS_ERROR;
23374: fnd_message.set_name('CZ', 'PUB_OVERLAP');
23375: fnd_message.set_token('PUB_OVERLAP', v_publicationidstring);
23376: fnd_msg_pub.ADD;
23377: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23378: WHEN model_not_upto_date
23379: THEN

Line 23381: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');

23377: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23378: WHEN model_not_upto_date
23379: THEN
23380: x_return_status := FND_API.G_RET_STS_ERROR;
23381: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
23382: fnd_message.set_token('UPTODATESTR', v_upto_date_status);
23383: fnd_msg_pub.ADD;
23384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23385: WHEN OTHERS

Line 23382: fnd_message.set_token('UPTODATESTR', v_upto_date_status);

23378: WHEN model_not_upto_date
23379: THEN
23380: x_return_status := FND_API.G_RET_STS_ERROR;
23381: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
23382: fnd_message.set_token('UPTODATESTR', v_upto_date_status);
23383: fnd_msg_pub.ADD;
23384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23385: WHEN OTHERS
23386: THEN

Line 23388: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');

23384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23385: WHEN OTHERS
23386: THEN
23387: x_return_status := FND_API.G_RET_STS_ERROR;
23388: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
23389: fnd_message.set_token('ERROR', SQLERRM);
23390: fnd_msg_pub.ADD;
23391: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23392: END create_publication_request;

Line 23389: fnd_message.set_token('ERROR', SQLERRM);

23385: WHEN OTHERS
23386: THEN
23387: x_return_status := FND_API.G_RET_STS_ERROR;
23388: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
23389: fnd_message.set_token('ERROR', SQLERRM);
23390: fnd_msg_pub.ADD;
23391: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23392: END create_publication_request;
23393: