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_MSG_PUB

Line 676: fnd_msg_pub.initialize;

672: END IF;
673:
674: IF ((cz_pb_mgr.v_msg_tbl.COUNT > 0) AND(cz_pb_mgr.v_session_parameter = model_copy) AND(cz_pb_mgr.v_status_code = PUBLICATION_ERROR))
675: THEN
676: fnd_msg_pub.initialize;
677:
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%'))

Line 684: fnd_msg_pub.ADD;

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;
688:

Line 5677: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);

5673: l_msg_index := 1;
5674:
5675: WHILE l_msg_count > 0
5676: LOOP
5677: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
5678: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
5679: l_msg_index := l_msg_index + 1;
5680: l_msg_count := l_msg_count - 1;
5681: END LOOP;

Line 5698: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);

5694: l_msg_index := 1;
5695:
5696: WHILE l_msg_count > 0
5697: LOOP
5698: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
5699: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
5700: l_msg_index := l_msg_index + 1;
5701: l_msg_count := l_msg_count - 1;
5702: END LOOP;

Line 18681: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);

18677: l_msg_index := 1;
18678:
18679: WHILE l_msg_count > 0
18680: LOOP
18681: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
18682: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
18683: l_msg_index := l_msg_index + 1;
18684: l_msg_count := l_msg_count - 1;
18685: END LOOP;

Line 19275: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);

19271: l_msg_index := 1;
19272:
19273: WHILE l_msg_count > 0
19274: LOOP
19275: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
19276: l_msg_index := l_msg_index + 1;
19277: l_msg_count := l_msg_count - 1;
19278: END LOOP;
19279: END IF;

Line 19329: fnd_msg_pub.initialize;

19325: BEGIN
19326:
19327: --initialize the message stack depending on the input parameter
19328: IF (p_init_msg_list = FND_API.G_TRUE) THEN
19329: fnd_msg_pub.initialize;
19330: END IF;
19331:
19332: x_return_status := FND_API.G_RET_STS_SUCCESS;
19333: x_msg_count := 0;

Line 19340: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

19336:
19337: IF (l_status = PUBLICATION_ERROR)
19338: THEN
19339: x_return_status := FND_API.G_RET_STS_ERROR;
19340: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19341: END IF;
19342: END deep_model_copy;
19343:
19344: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 19384: fnd_msg_pub.initialize;

19380: AS
19381: l_log_pb_time cz_db_settings.VALUE%TYPE;
19382: l_pub_mode cz_model_publications.publication_mode%TYPE;
19383: BEGIN
19384: fnd_msg_pub.initialize;
19385: cz_pb_mgr.v_publication_id := p_publication_id;
19386: cz_pb_mgr.sequence_const := 0;
19387: cz_pb_mgr.v_ui_str := 'x';
19388: cz_pb_mgr.global_export_retcode := 0;

Line 19694: fnd_msg_pub.initialize;

19690: SELECT DISTINCT component_id
19691: FROM cz_model_ref_expls
19692: WHERE deleted_flag = '0' AND model_id = in_root_model AND ps_node_type = 263;
19693: BEGIN
19694: fnd_msg_pub.initialize;
19695:
19696: IF p_model_id IS NOT NULL THEN
19697: x_return_status := 0;
19698: x_msg_data := '';

Line 20245: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', fnd_msg_pub.get(l_msg_index, fnd_api.g_false));

20241:
20242: WHILE l_msg_count > 0
20243: LOOP
20244: cz_pb_mgr.v_err_message :=
20245: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', fnd_msg_pub.get(l_msg_index, fnd_api.g_false));
20246: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
20247: l_msg_index := l_msg_index + 1;
20248: l_msg_count := l_msg_count - 1;
20249: END LOOP;

Line 20772: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);

20768: l_msg_index := 1;
20769:
20770: WHILE l_msg_count > 0
20771: LOOP
20772: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
20773: l_msg_index := l_msg_index + 1;
20774: l_msg_count := l_msg_count - 1;
20775: END LOOP;
20776: END IF;

Line 20995: fnd_msg_pub.initialize;

20991: template_in_use EXCEPTION;
20992: cannot_del_pup EXCEPTION;
20993: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20994: BEGIN
20995: fnd_msg_pub.initialize;
20996: x_return_status := FND_API.G_RET_STS_SUCCESS;
20997: x_msg_count := 0;
20998: x_msg_data := '';
20999: fnd_msg_pub.initialize;

Line 20999: fnd_msg_pub.initialize;

20995: fnd_msg_pub.initialize;
20996: x_return_status := FND_API.G_RET_STS_SUCCESS;
20997: x_msg_count := 0;
20998: x_msg_data := '';
20999: fnd_msg_pub.initialize;
21000:
21001: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
21002: THEN
21003: l_pub_mode := cz_model_migration_pvt.mode_migration;

Line 21148: fnd_msg_pub.ADD;

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
21152: x_return_status := FND_API.G_RET_STS_ERROR;

Line 21149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
21152: x_return_status := FND_API.G_RET_STS_ERROR;
21153: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');

Line 21155: fnd_msg_pub.ADD;

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
21159: x_return_status := FND_API.G_RET_STS_ERROR;

Line 21156: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
21159: x_return_status := FND_API.G_RET_STS_ERROR;
21160: fnd_message.set_name('CZ', 'CZ_INVALID_PUB_TYPE');

Line 21161: fnd_msg_pub.ADD;

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
21165: x_msg_data := cz_utils.get_text('CZ_TEMPLATE_IN_USE');

Line 21162: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
21165: x_msg_data := cz_utils.get_text('CZ_TEMPLATE_IN_USE');
21166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 21168: fnd_msg_pub.ADD;

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
21172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 21169: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
21172: x_return_status := FND_API.G_RET_STS_ERROR;
21173: x_msg_data := SQLERRM;

Line 21194: fnd_msg_pub.initialize;

21190: cannot_disable_template EXCEPTION;
21191: cannot_disable_publication EXCEPTION;
21192: BEGIN
21193: x_return_status := FND_API.G_RET_STS_SUCCESS;
21194: fnd_msg_pub.initialize;
21195: --execute the procedure that obsoletes the records
21196: --if the target has been converted into a development
21197: --instance
21198: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

Line 21265: fnd_msg_pub.ADD;

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
21269: x_return_status := FND_API.G_RET_STS_ERROR;

Line 21266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
21269: x_return_status := FND_API.G_RET_STS_ERROR;
21270: WHEN cannot_disable_template

Line 21566: fnd_msg_pub.initialize;

21562: no_pub_found EXCEPTION;
21563: l_publication_id NUMBER;
21564: BEGIN
21565: x_return_status := FND_API.G_RET_STS_SUCCESS;
21566: fnd_msg_pub.initialize;
21567: v_application_id_tbl.DELETE;
21568: v_usage_id_tbl.DELETE;
21569: v_language_id_tbl.DELETE;
21570: --execute the procedure that obsoletes the records

Line 21651: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

21647: x_return_status := FND_API.G_RET_STS_SUCCESS;
21648: WHEN no_pub_found
21649: THEN
21650: x_return_status := FND_API.G_RET_STS_SUCCESS;
21651: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21652: WHEN OTHERS
21653: THEN
21654: x_return_status := FND_API.G_RET_STS_ERROR;
21655: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);

Line 21692: fnd_msg_pub.initialize;

21688: no_pub_found EXCEPTION;
21689: l_publication_id NUMBER;
21690: BEGIN
21691: x_return_status := FND_API.G_RET_STS_SUCCESS;
21692: fnd_msg_pub.initialize;
21693: --execute the procedure that obsoletes the records
21694: --if the target has been converted into a development
21695: --instance
21696: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

Line 21768: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

21764: x_return_status := FND_API.G_RET_STS_SUCCESS;
21765: WHEN no_pub_found
21766: THEN
21767: x_return_status := FND_API.G_RET_STS_SUCCESS;
21768: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21769: WHEN OTHERS
21770: THEN
21771: x_return_status := FND_API.G_RET_STS_ERROR;
21772: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);

Line 21810: fnd_msg_pub.initialize;

21806: no_pub_found EXCEPTION;
21807: l_publication_id NUMBER;
21808: BEGIN
21809: x_return_status := FND_API.G_RET_STS_SUCCESS;
21810: fnd_msg_pub.initialize;
21811: v_application_id_tbl.DELETE;
21812: v_usage_id_tbl.DELETE;
21813: v_language_id_tbl.DELETE;
21814: --execute the procedure that obsoletes the records

Line 22122: fnd_msg_pub.initialize;

22118: v_in_lang_id VARCHAR2(2000);
22119: v_in_usg_id VARCHAR2(2000);
22120: l_publicationidstring VARCHAR2(2000);
22121: BEGIN
22122: fnd_msg_pub.initialize;
22123: v_in_appl_id := applicationid;
22124: v_in_lang_id := languageid;
22125: v_in_usg_id := usageid;
22126: populate_app_tbl(v_in_appl_id, v_app_id_tbl);

Line 22155: fnd_msg_pub.initialize;

22151: v_link_name cz_servers.fndnam_link_name%TYPE;
22152: v_db_link VARCHAR2(255);
22153: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
22154: BEGIN
22155: fnd_msg_pub.initialize;
22156:
22157: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
22158: THEN
22159: l_pub_mode := cz_model_migration_pvt.mode_migration;

Line 22355: fnd_msg_pub.initialize;

22351: pub_overlap EXCEPTION;
22352: ui_def_id_is_deleted EXCEPTION;
22353: BEGIN
22354: x_return_status := FND_API.G_RET_STS_SUCCESS;
22355: fnd_msg_pub.initialize;
22356: --execute the procedure that obsoletes the records
22357: --if the target has been converted into a development
22358: --instance
22359: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

Line 22467: fnd_msg_pub.ADD;

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
22471: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22468: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
22471: x_return_status := FND_API.G_RET_STS_ERROR;
22472:

Line 22477: fnd_msg_pub.ADD;

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);
22481: fnd_msg_pub.ADD;

Line 22481: fnd_msg_pub.ADD;

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);
22485: WHEN model_not_upto_date

Line 22484: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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);
22485: WHEN model_not_upto_date
22486: THEN
22487: ROLLBACK;
22488: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22492: fnd_msg_pub.ADD;

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
22496: ROLLBACK;

Line 22493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
22496: ROLLBACK;
22497: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22500: fnd_msg_pub.ADD;

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
22504: ROLLBACK;

Line 22501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
22504: ROLLBACK;
22505: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22509: fnd_msg_pub.ADD;

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
22513: THEN

Line 22510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
22513: THEN
22514: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 22522: fnd_msg_pub.ADD;

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:
22526: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 22523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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:
22526: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
22527: ------procedure that resets the start and end dates

Line 22855: fnd_msg_pub.initialize;

22851: pub_overlap EXCEPTION;
22852: cannot_enable_publication EXCEPTION;
22853: BEGIN
22854: x_return_status := FND_API.G_RET_STS_SUCCESS;
22855: fnd_msg_pub.initialize;
22856: --execute the procedure that obsoletes the records
22857: --if the target has been converted into a development
22858: --instance
22859: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

Line 22971: fnd_msg_pub.ADD;

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
22975: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);

Line 22972: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
22975: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);
22976: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22979: fnd_msg_pub.ADD;

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
22983: ROLLBACK;

Line 22980: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
22983: ROLLBACK;
22984: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22987: fnd_msg_pub.ADD;

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
22991: ROLLBACK;

Line 22988: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
22991: ROLLBACK;
22992: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22996: fnd_msg_pub.ADD;

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
23000: x_return_status := FND_API.G_RET_STS_ERROR;

Line 22997: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23000: x_return_status := FND_API.G_RET_STS_ERROR;
23001: WHEN OTHERS

Line 23117: fnd_msg_pub.initialize;

23113: product_key_is_null EXCEPTION;
23114: PUB_SOURCE_FLAG CONSTANT VARCHAR2(1) := 'S';
23115: BEGIN
23116: x_return_status := FND_API.G_RET_STS_SUCCESS;
23117: fnd_msg_pub.initialize;
23118:
23119: -----check if model id passed in is not null
23120: -----if not null then check if the model exists and is
23121: -----a source model

Line 23336: fnd_msg_pub.ADD;

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
23340: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23340: x_return_status := FND_API.G_RET_STS_ERROR;
23341: fnd_message.set_name('CZ', 'cz_pb_mgr_MODEL_ID_NULL');

Line 23342: fnd_msg_pub.ADD;

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
23346: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23346: x_return_status := FND_API.G_RET_STS_ERROR;
23347: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');

Line 23349: fnd_msg_pub.ADD;

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
23353: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23353: x_return_status := FND_API.G_RET_STS_ERROR;
23354: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');

Line 23356: fnd_msg_pub.ADD;

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
23360: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23357: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23360: x_return_status := FND_API.G_RET_STS_ERROR;
23361: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');

Line 23363: fnd_msg_pub.ADD;

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
23367: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23364: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23367: x_return_status := FND_API.G_RET_STS_ERROR;
23368: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_APPL_ID');

Line 23369: fnd_msg_pub.ADD;

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
23373: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23373: x_return_status := FND_API.G_RET_STS_ERROR;
23374: fnd_message.set_name('CZ', 'PUB_OVERLAP');

Line 23376: fnd_msg_pub.ADD;

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
23380: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23377: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23380: x_return_status := FND_API.G_RET_STS_ERROR;
23381: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');

Line 23383: fnd_msg_pub.ADD;

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
23387: x_return_status := FND_API.G_RET_STS_ERROR;

Line 23384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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
23387: x_return_status := FND_API.G_RET_STS_ERROR;
23388: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');

Line 23390: fnd_msg_pub.ADD;

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:
23394: ------------------------------------------------------------------------------------------------

Line 23391: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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:
23394: ------------------------------------------------------------------------------------------------
23395: --Need to go through get_models_tobe_exported because it makes the decisions on shallow