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 4949: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);

4945: l_msg_index := 1;
4946:
4947: WHILE l_msg_count > 0
4948: LOOP
4949: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
4950: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
4951: l_msg_index := l_msg_index + 1;
4952: l_msg_count := l_msg_count - 1;
4953: END LOOP;

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

4960: l_msg_index := 1;
4961:
4962: WHILE l_msg_count > 0
4963: LOOP
4964: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
4965: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
4966: l_msg_index := l_msg_index + 1;
4967: l_msg_count := l_msg_count - 1;
4968: END LOOP;

Line 6100: fnd_msg_pub.initialize;

6096: END IF;
6097:
6098: 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))
6099: THEN
6100: fnd_msg_pub.initialize;
6101:
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%'))

Line 6108: fnd_msg_pub.ADD;

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

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

17534: l_msg_index := 1;
17535:
17536: WHILE l_msg_count > 0
17537: LOOP
17538: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
17539: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
17540: l_msg_index := l_msg_index + 1;
17541: l_msg_count := l_msg_count - 1;
17542: END LOOP;

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

18128: l_msg_index := 1;
18129:
18130: WHILE l_msg_count > 0
18131: LOOP
18132: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
18133: l_msg_index := l_msg_index + 1;
18134: l_msg_count := l_msg_count - 1;
18135: END LOOP;
18136: END IF;

Line 18186: fnd_msg_pub.initialize;

18182: BEGIN
18183:
18184: --initialize the message stack depending on the input parameter
18185: IF (p_init_msg_list = FND_API.G_TRUE) THEN
18186: fnd_msg_pub.initialize;
18187: END IF;
18188:
18189: x_return_status := FND_API.G_RET_STS_SUCCESS;
18190: x_msg_count := 0;

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

18193:
18194: IF (l_status = PUBLICATION_ERROR)
18195: THEN
18196: x_return_status := FND_API.G_RET_STS_ERROR;
18197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18198: END IF;
18199: END deep_model_copy;
18200:
18201: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 18247: fnd_msg_pub.initialize;

18243: AS
18244: l_log_pb_time cz_db_settings.VALUE%TYPE;
18245: l_pub_mode cz_model_publications.publication_mode%TYPE;
18246: BEGIN
18247: fnd_msg_pub.initialize;
18248: cz_pb_mgr.v_publication_id := p_publication_id;
18249: cz_pb_mgr.sequence_const := 0;
18250: cz_pb_mgr.v_ui_str := 'x';
18251: cz_pb_mgr.global_export_retcode := 0;

Line 18557: fnd_msg_pub.initialize;

18553: SELECT DISTINCT component_id
18554: FROM cz_model_ref_expls
18555: WHERE deleted_flag = '0' AND model_id = in_root_model AND ps_node_type = 263;
18556: BEGIN
18557: fnd_msg_pub.initialize;
18558:
18559: IF p_model_id IS NOT NULL THEN
18560: x_return_status := 0;
18561: x_msg_data := '';

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

19056:
19057: WHILE l_msg_count > 0
19058: LOOP
19059: cz_pb_mgr.v_err_message :=
19060: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', fnd_msg_pub.get(l_msg_index, fnd_api.g_false));
19061: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
19062: l_msg_index := l_msg_index + 1;
19063: l_msg_count := l_msg_count - 1;
19064: END LOOP;

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

19568: l_msg_index := 1;
19569:
19570: WHILE l_msg_count > 0
19571: LOOP
19572: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
19573: l_msg_index := l_msg_index + 1;
19574: l_msg_count := l_msg_count - 1;
19575: END LOOP;
19576: END IF;

Line 19787: fnd_msg_pub.initialize;

19783: template_in_use EXCEPTION;
19784: cannot_del_pup EXCEPTION;
19785: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
19786: BEGIN
19787: fnd_msg_pub.initialize;
19788: x_return_status := FND_API.G_RET_STS_SUCCESS;
19789: x_msg_count := 0;
19790: x_msg_data := '';
19791: fnd_msg_pub.initialize;

Line 19791: fnd_msg_pub.initialize;

19787: fnd_msg_pub.initialize;
19788: x_return_status := FND_API.G_RET_STS_SUCCESS;
19789: x_msg_count := 0;
19790: x_msg_data := '';
19791: fnd_msg_pub.initialize;
19792:
19793: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
19794: THEN
19795: l_pub_mode := cz_model_migration_pvt.mode_migration;

Line 19939: fnd_msg_pub.ADD;

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

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

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

Line 19946: fnd_msg_pub.ADD;

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

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

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

Line 19952: fnd_msg_pub.ADD;

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

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

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

Line 19959: fnd_msg_pub.ADD;

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

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

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

Line 19985: fnd_msg_pub.initialize;

19981: cannot_disable_template EXCEPTION;
19982: cannot_disable_publication EXCEPTION;
19983: BEGIN
19984: x_return_status := FND_API.G_RET_STS_SUCCESS;
19985: fnd_msg_pub.initialize;
19986: --execute the procedure that obsoletes the records
19987: --if the target has been converted into a development
19988: --instance
19989: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

Line 20056: fnd_msg_pub.ADD;

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

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

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

Line 20357: fnd_msg_pub.initialize;

20353: no_pub_found EXCEPTION;
20354: l_publication_id NUMBER;
20355: BEGIN
20356: x_return_status := FND_API.G_RET_STS_SUCCESS;
20357: fnd_msg_pub.initialize;
20358: v_application_id_tbl.DELETE;
20359: v_usage_id_tbl.DELETE;
20360: v_language_id_tbl.DELETE;
20361: --execute the procedure that obsoletes the records

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

20438: x_return_status := FND_API.G_RET_STS_SUCCESS;
20439: WHEN no_pub_found
20440: THEN
20441: x_return_status := FND_API.G_RET_STS_SUCCESS;
20442: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20443: WHEN OTHERS
20444: THEN
20445: x_return_status := FND_API.G_RET_STS_ERROR;
20446: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);

Line 20483: fnd_msg_pub.initialize;

20479: no_pub_found EXCEPTION;
20480: l_publication_id NUMBER;
20481: BEGIN
20482: x_return_status := FND_API.G_RET_STS_SUCCESS;
20483: fnd_msg_pub.initialize;
20484: --execute the procedure that obsoletes the records
20485: --if the target has been converted into a development
20486: --instance
20487: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

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

20555: x_return_status := FND_API.G_RET_STS_SUCCESS;
20556: WHEN no_pub_found
20557: THEN
20558: x_return_status := FND_API.G_RET_STS_SUCCESS;
20559: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20560: WHEN OTHERS
20561: THEN
20562: x_return_status := FND_API.G_RET_STS_ERROR;
20563: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);

Line 20601: fnd_msg_pub.initialize;

20597: no_pub_found EXCEPTION;
20598: l_publication_id NUMBER;
20599: BEGIN
20600: x_return_status := FND_API.G_RET_STS_SUCCESS;
20601: fnd_msg_pub.initialize;
20602: v_application_id_tbl.DELETE;
20603: v_usage_id_tbl.DELETE;
20604: v_language_id_tbl.DELETE;
20605: --execute the procedure that obsoletes the records

Line 20913: fnd_msg_pub.initialize;

20909: v_in_lang_id VARCHAR2(2000);
20910: v_in_usg_id VARCHAR2(2000);
20911: l_publicationidstring VARCHAR2(2000);
20912: BEGIN
20913: fnd_msg_pub.initialize;
20914: v_in_appl_id := applicationid;
20915: v_in_lang_id := languageid;
20916: v_in_usg_id := usageid;
20917: populate_app_tbl(v_in_appl_id, v_app_id_tbl);

Line 20946: fnd_msg_pub.initialize;

20942: v_link_name cz_servers.fndnam_link_name%TYPE;
20943: v_db_link VARCHAR2(255);
20944: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20945: BEGIN
20946: fnd_msg_pub.initialize;
20947:
20948: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
20949: THEN
20950: l_pub_mode := cz_model_migration_pvt.mode_migration;

Line 21146: fnd_msg_pub.initialize;

21142: pub_overlap EXCEPTION;
21143: ui_def_id_is_deleted EXCEPTION;
21144: BEGIN
21145: x_return_status := FND_API.G_RET_STS_SUCCESS;
21146: fnd_msg_pub.initialize;
21147: --execute the procedure that obsoletes the records
21148: --if the target has been converted into a development
21149: --instance
21150: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

Line 21258: fnd_msg_pub.ADD;

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;

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

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:

Line 21268: fnd_msg_pub.ADD;

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

Line 21272: fnd_msg_pub.ADD;

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

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

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;

Line 21283: fnd_msg_pub.ADD;

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

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

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

Line 21291: fnd_msg_pub.ADD;

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

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

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

Line 21300: fnd_msg_pub.ADD;

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

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

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

Line 21313: fnd_msg_pub.ADD;

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

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

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

Line 21646: fnd_msg_pub.initialize;

21642: pub_overlap EXCEPTION;
21643: cannot_enable_publication EXCEPTION;
21644: BEGIN
21645: x_return_status := FND_API.G_RET_STS_SUCCESS;
21646: fnd_msg_pub.initialize;
21647: --execute the procedure that obsoletes the records
21648: --if the target has been converted into a development
21649: --instance
21650: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);

Line 21762: fnd_msg_pub.ADD;

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

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

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

Line 21770: fnd_msg_pub.ADD;

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

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

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

Line 21778: fnd_msg_pub.ADD;

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

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

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

Line 21787: fnd_msg_pub.ADD;

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

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

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

Line 21908: fnd_msg_pub.initialize;

21904: product_key_is_null EXCEPTION;
21905: PUB_SOURCE_FLAG CONSTANT VARCHAR2(1) := 'S';
21906: BEGIN
21907: x_return_status := FND_API.G_RET_STS_SUCCESS;
21908: fnd_msg_pub.initialize;
21909:
21910: -----check if model id passed in is not null
21911: -----if not null then check if the model exists and is
21912: -----a source model

Line 22127: fnd_msg_pub.ADD;

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

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

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

Line 22133: fnd_msg_pub.ADD;

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

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

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

Line 22140: fnd_msg_pub.ADD;

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

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

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

Line 22147: fnd_msg_pub.ADD;

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

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

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

Line 22154: fnd_msg_pub.ADD;

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

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

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

Line 22160: fnd_msg_pub.ADD;

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

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

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

Line 22167: fnd_msg_pub.ADD;

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

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

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

Line 22174: fnd_msg_pub.ADD;

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

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

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

Line 22181: fnd_msg_pub.ADD;

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

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

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