DBA Data[Home] [Help]

APPS.CZ_UIOA_PVT dependencies on FND_API

Line 495: l_msg_data := fnd_msg_pub.GET(l_msg_index,fnd_api.g_false);

491: l_msg_index := 1;
492: l_msg_count := fnd_msg_pub.COUNT_MSG();
493: DEBUG(p_prefix||' '||TO_CHAR(l_msg_count)||' error messages .');
494: WHILE l_msg_count > 0 LOOP
495: l_msg_data := fnd_msg_pub.GET(l_msg_index,fnd_api.g_false);
496: DEBUG(p_prefix||l_msg_data);
497: l_msg_index := l_msg_index + 1;
498: l_msg_count := l_msg_count - 1;
499: END LOOP;

Line 511: cz_security_pvt.lock_model(1.0,p_model_id,FND_API.G_TRUE,FND_API.G_FALSE,

507: l_msg_count NUMBER;
508: l_msg_data VARCHAR2(4000);
509: BEGIN
510:
511: cz_security_pvt.lock_model(1.0,p_model_id,FND_API.G_TRUE,FND_API.G_FALSE,
512: p_locked_entities_tbl,
513: l_lock_status,l_msg_count,l_msg_data);
514: COMMIT;
515: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 515: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN

511: cz_security_pvt.lock_model(1.0,p_model_id,FND_API.G_TRUE,FND_API.G_FALSE,
512: p_locked_entities_tbl,
513: l_lock_status,l_msg_count,l_msg_data);
514: COMMIT;
515: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN
516: RAISE FAILED_TO_LOCK_MODEL;
517: END IF;
518: END lock_Model;
519:

Line 528: p_commit_flag => FND_API.G_FALSE,

524: l_msg_data VARCHAR2(4000);
525: BEGIN
526: cz_security_pvt.unlock_model(p_api_version => 1.0,
527: p_models_to_unlock => p_locked_entities_tbl,
528: p_commit_flag => FND_API.G_FALSE,
529: p_init_msg_list => FND_API.G_FALSE,
530: x_return_status => l_lock_status,
531: x_msg_count => l_msg_count,
532: x_msg_data => l_msg_data);

Line 529: p_init_msg_list => FND_API.G_FALSE,

525: BEGIN
526: cz_security_pvt.unlock_model(p_api_version => 1.0,
527: p_models_to_unlock => p_locked_entities_tbl,
528: p_commit_flag => FND_API.G_FALSE,
529: p_init_msg_list => FND_API.G_FALSE,
530: x_return_status => l_lock_status,
531: x_msg_count => l_msg_count,
532: x_msg_data => l_msg_data);
533: COMMIT;

Line 603: p_commit_flag => FND_API.G_FALSE,

599: END IF;
600: l_templates_to_lock_tbl(1) := p_template_id;
601: cz_security_pvt.lock_template(p_api_version => 1.0,
602: p_templates_to_lock => l_templates_to_lock_tbl,
603: p_commit_flag => FND_API.G_FALSE,
604: p_init_msg_list => FND_API.G_FALSE,
605: x_locked_templates => l_locked_templates_tbl,
606: x_return_status => l_lock_status,
607: x_msg_count => l_msg_count,

Line 604: p_init_msg_list => FND_API.G_FALSE,

600: l_templates_to_lock_tbl(1) := p_template_id;
601: cz_security_pvt.lock_template(p_api_version => 1.0,
602: p_templates_to_lock => l_templates_to_lock_tbl,
603: p_commit_flag => FND_API.G_FALSE,
604: p_init_msg_list => FND_API.G_FALSE,
605: x_locked_templates => l_locked_templates_tbl,
606: x_return_status => l_lock_status,
607: x_msg_count => l_msg_count,
608: x_msg_data => l_msg_data);

Line 611: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN

607: x_msg_count => l_msg_count,
608: x_msg_data => l_msg_data);
609: COMMIT;
610:
611: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS) THEN
612: RAISE FAILED_TO_LOCK_TEMPLATE;
613: END IF;
614: IF l_locked_templates_tbl.COUNT>0 THEN
615: px_needs_to_be_unlocked := TRUE;

Line 636: p_commit_flag => FND_API.G_FALSE,

632: p_template_ui_def_id IS NULL) AND p_needs_to_be_unlocked THEN
633: l_templates_to_unlock_tbl(1) := p_template_id;
634: cz_security_pvt.unlock_template(p_api_version => 1.0,
635: p_templates_to_unlock => l_templates_to_unlock_tbl,
636: p_commit_flag => FND_API.G_FALSE,
637: p_init_msg_list => FND_API.G_FALSE,
638: x_return_status => l_lock_status,
639: x_msg_count => l_msg_count,
640: x_msg_data => l_msg_data);

Line 637: p_init_msg_list => FND_API.G_FALSE,

633: l_templates_to_unlock_tbl(1) := p_template_id;
634: cz_security_pvt.unlock_template(p_api_version => 1.0,
635: p_templates_to_unlock => l_templates_to_unlock_tbl,
636: p_commit_flag => FND_API.G_FALSE,
637: p_init_msg_list => FND_API.G_FALSE,
638: x_return_status => l_lock_status,
639: x_msg_count => l_msg_count,
640: x_msg_data => l_msg_data);
641: COMMIT;

Line 752: x_return_status := FND_API.G_RET_STS_SUCCESS;

748: x_msg_data OUT NOCOPY VARCHAR2) IS
749: BEGIN
750: g_MSG_COUNT := 0 ;
751: fnd_msg_pub.initialize;
752: x_return_status := FND_API.G_RET_STS_SUCCESS;
753: x_msg_count := 0;
754: x_msg_data := NULL;
755: Initialize_Sequences();
756: g_ui_def_nodes_tbl.DELETE;

Line 782: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN

778: fnd_msg_pub.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
779: END IF;
780: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
781: p_data => g_MSG_DATA);
782: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
783: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
784: ELSE
785: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
786: END IF;

Line 783: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

779: END IF;
780: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
781: p_data => g_MSG_DATA);
782: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
783: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
784: ELSE
785: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
786: END IF;
787:

Line 785: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

781: p_data => g_MSG_DATA);
782: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
783: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
784: ELSE
785: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
786: END IF;
787:
788: END add_Error_Message;
789:

Line 807: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN

803: fnd_msg_pub.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
804: END IF;
805: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
806: p_data => g_MSG_DATA);
807: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
808: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
809: ELSE
810: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
811: END IF;

Line 808: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

804: END IF;
805: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
806: p_data => g_MSG_DATA);
807: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
808: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
809: ELSE
810: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
811: END IF;
812: END add_Error_Message;

Line 810: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

806: p_data => g_MSG_DATA);
807: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
808: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
809: ELSE
810: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
811: END IF;
812: END add_Error_Message;
813:
814: PROCEDURE add_Error_Message(p_message_name IN VARCHAR2,

Line 839: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN

835: END IF;
836:
837: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
838: p_data => g_MSG_DATA);
839: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
840: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
841: ELSE
842: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
843: END IF;

Line 840: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

836:
837: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
838: p_data => g_MSG_DATA);
839: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
840: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
841: ELSE
842: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
843: END IF;
844: END add_Error_Message;

Line 842: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

838: p_data => g_MSG_DATA);
839: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
840: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
841: ELSE
842: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
843: END IF;
844: END add_Error_Message;
845:
846: PROCEDURE add_Error_Message(p_message_name IN VARCHAR2,

Line 877: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN

873: END IF;
874:
875: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
876: p_data => g_MSG_DATA);
877: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
878: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
879: ELSE
880: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
881: END IF;

Line 878: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

874:
875: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
876: p_data => g_MSG_DATA);
877: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
878: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
879: ELSE
880: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
881: END IF;
882: END add_Error_Message;

Line 880: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

876: p_data => g_MSG_DATA);
877: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
878: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
879: ELSE
880: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
881: END IF;
882: END add_Error_Message;
883:
884: PROCEDURE add_Error_Message(p_message_name IN VARCHAR2,

Line 927: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN

923: END IF;
924:
925: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
926: p_data => g_MSG_DATA);
927: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
928: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
929: ELSE
930: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
931: END IF;

Line 928: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

924:
925: FND_MSG_PUB.count_and_get(p_count => g_MSG_COUNT,
926: p_data => g_MSG_DATA);
927: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
928: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
929: ELSE
930: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
931: END IF;
932: END add_Error_Message;

Line 930: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

926: p_data => g_MSG_DATA);
927: IF p_fatal_error OR g_RETURN_STATUS=FND_API.G_RET_STS_ERROR THEN
928: g_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
929: ELSE
930: g_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
931: END IF;
932: END add_Error_Message;
933:
934: --

Line 5407: p_init_msg_list => FND_API.G_FALSE,

5403:
5404: IF NVL(k.seeded_flag,G_NO_FLAG)=G_NO_FLAG THEN
5405: CZ_DEVELOPER_UTILS_PVT.copy_Rule
5406: (p_rule_id => k.rule_id,
5407: p_init_msg_list => FND_API.G_FALSE,
5408: p_ui_def_id => p_ui_def_id,
5409: p_ui_page_id => p_ui_page_id,
5410: p_ui_page_element_id => p_ui_element_id,
5411: x_out_new_rule_id => x_rule_id,

Line 17467: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17463:
17464: IF g_MSG_COUNT>0 THEN
17465: x_return_status := G_RETURN_STATUS;
17466: x_msg_count := g_MSG_COUNT;
17467: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17468: END IF;
17469:
17470: unlock_model(l_locked_models);
17471:

Line 17474: x_return_status := FND_API.G_RET_STS_ERROR;

17470: unlock_model(l_locked_models);
17471:
17472: EXCEPTION
17473: WHEN FAILED_TO_LOCK_MODEL THEN
17474: x_return_status := FND_API.G_RET_STS_ERROR;
17475: x_msg_count := 1;
17476: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17477: DEBUG(x_msg_data);
17478: WHEN WRONG_UI_TEMPLATE THEN

Line 17476: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17472: EXCEPTION
17473: WHEN FAILED_TO_LOCK_MODEL THEN
17474: x_return_status := FND_API.G_RET_STS_ERROR;
17475: x_msg_count := 1;
17476: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17477: DEBUG(x_msg_data);
17478: WHEN WRONG_UI_TEMPLATE THEN
17479: x_return_status := FND_API.G_RET_STS_ERROR;
17480: x_msg_count := g_MSG_COUNT;

Line 17479: x_return_status := FND_API.G_RET_STS_ERROR;

17475: x_msg_count := 1;
17476: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17477: DEBUG(x_msg_data);
17478: WHEN WRONG_UI_TEMPLATE THEN
17479: x_return_status := FND_API.G_RET_STS_ERROR;
17480: x_msg_count := g_MSG_COUNT;
17481: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17482: DEBUG(x_msg_data);
17483: WHEN WRONG_EXT_PS_TYPE THEN

Line 17481: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17477: DEBUG(x_msg_data);
17478: WHEN WRONG_UI_TEMPLATE THEN
17479: x_return_status := FND_API.G_RET_STS_ERROR;
17480: x_msg_count := g_MSG_COUNT;
17481: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17482: DEBUG(x_msg_data);
17483: WHEN WRONG_EXT_PS_TYPE THEN
17484: x_return_status := FND_API.G_RET_STS_ERROR;
17485: x_msg_count := 1;

Line 17484: x_return_status := FND_API.G_RET_STS_ERROR;

17480: x_msg_count := g_MSG_COUNT;
17481: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17482: DEBUG(x_msg_data);
17483: WHEN WRONG_EXT_PS_TYPE THEN
17484: x_return_status := FND_API.G_RET_STS_ERROR;
17485: x_msg_count := 1;
17486: x_msg_data := 'Internal Error : extended ps node type of node with ps_node_id='||
17487: TO_CHAR(g_WRONG_PS_NODE_ID)||' is not defined.';
17488: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'create_UI', x_msg_data);

Line 17491: x_return_status := FND_API.G_RET_STS_ERROR;

17487: TO_CHAR(g_WRONG_PS_NODE_ID)||' is not defined.';
17488: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'create_UI', x_msg_data);
17489: DEBUG(x_msg_data);
17490: WHEN UNREACH_UI_NODE THEN
17491: x_return_status := FND_API.G_RET_STS_ERROR;
17492: x_msg_count := g_MSG_COUNT;
17493: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17494: DEBUG(x_msg_data);
17495: WHEN OTHERS THEN

Line 17493: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17489: DEBUG(x_msg_data);
17490: WHEN UNREACH_UI_NODE THEN
17491: x_return_status := FND_API.G_RET_STS_ERROR;
17492: x_msg_count := g_MSG_COUNT;
17493: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17494: DEBUG(x_msg_data);
17495: WHEN OTHERS THEN
17496: x_return_status := FND_API.G_RET_STS_ERROR;
17497: x_msg_count := g_MSG_COUNT;

Line 17496: x_return_status := FND_API.G_RET_STS_ERROR;

17492: x_msg_count := g_MSG_COUNT;
17493: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17494: DEBUG(x_msg_data);
17495: WHEN OTHERS THEN
17496: x_return_status := FND_API.G_RET_STS_ERROR;
17497: x_msg_count := g_MSG_COUNT;
17498: IF g_MSG_COUNT>0 THEN
17499: x_msg_count := g_MSG_COUNT;
17500: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

Line 17500: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17496: x_return_status := FND_API.G_RET_STS_ERROR;
17497: x_msg_count := g_MSG_COUNT;
17498: IF g_MSG_COUNT>0 THEN
17499: x_msg_count := g_MSG_COUNT;
17500: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17501: ELSE
17502: x_msg_count := 1;
17503: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
17504: END IF;

Line 17689: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17685:
17686: IF g_MSG_COUNT>0 THEN
17687: x_return_status := G_RETURN_STATUS;
17688: x_msg_count := g_MSG_COUNT;
17689: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17690: END IF;
17691:
17692: EXCEPTION
17693: WHEN FAILED_TO_LOCK_MODEL THEN

Line 17694: x_return_status := FND_API.G_RET_STS_ERROR;

17690: END IF;
17691:
17692: EXCEPTION
17693: WHEN FAILED_TO_LOCK_MODEL THEN
17694: x_return_status := FND_API.G_RET_STS_ERROR;
17695: x_msg_count := 1;
17696: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17697: DEBUG(x_msg_data);
17698: WHEN WRONG_UI_TO_REFRESH THEN

Line 17696: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17692: EXCEPTION
17693: WHEN FAILED_TO_LOCK_MODEL THEN
17694: x_return_status := FND_API.G_RET_STS_ERROR;
17695: x_msg_count := 1;
17696: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17697: DEBUG(x_msg_data);
17698: WHEN WRONG_UI_TO_REFRESH THEN
17699: x_return_status := FND_API.G_RET_STS_ERROR;
17700: x_msg_count := 1;

Line 17699: x_return_status := FND_API.G_RET_STS_ERROR;

17695: x_msg_count := 1;
17696: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17697: DEBUG(x_msg_data);
17698: WHEN WRONG_UI_TO_REFRESH THEN
17699: x_return_status := FND_API.G_RET_STS_ERROR;
17700: x_msg_count := 1;
17701: x_msg_data := 'Internal Error : Wrong UI to refresh.';
17702: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'refresh_UI', x_msg_data);
17703: DEBUG(x_msg_data);

Line 17705: x_return_status := FND_API.G_RET_STS_ERROR;

17701: x_msg_data := 'Internal Error : Wrong UI to refresh.';
17702: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'refresh_UI', x_msg_data);
17703: DEBUG(x_msg_data);
17704: WHEN WRONG_UI_TEMPLATE THEN
17705: x_return_status := FND_API.G_RET_STS_ERROR;
17706: x_msg_count := g_MSG_COUNT;
17707: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17708: DEBUG(x_msg_data);
17709: WHEN WRONG_EXT_PS_TYPE THEN

Line 17707: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17703: DEBUG(x_msg_data);
17704: WHEN WRONG_UI_TEMPLATE THEN
17705: x_return_status := FND_API.G_RET_STS_ERROR;
17706: x_msg_count := g_MSG_COUNT;
17707: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17708: DEBUG(x_msg_data);
17709: WHEN WRONG_EXT_PS_TYPE THEN
17710: x_return_status := FND_API.G_RET_STS_ERROR;
17711: x_msg_count := 1;

Line 17710: x_return_status := FND_API.G_RET_STS_ERROR;

17706: x_msg_count := g_MSG_COUNT;
17707: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17708: DEBUG(x_msg_data);
17709: WHEN WRONG_EXT_PS_TYPE THEN
17710: x_return_status := FND_API.G_RET_STS_ERROR;
17711: x_msg_count := 1;
17712: x_msg_data := 'Internal Error : extended ps node type of node with ps_node_id='||
17713: TO_CHAR(g_WRONG_PS_NODE_ID)||' is not defined.';
17714: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'create_UI', x_msg_data);

Line 17717: x_return_status := FND_API.G_RET_STS_ERROR;

17713: TO_CHAR(g_WRONG_PS_NODE_ID)||' is not defined.';
17714: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'create_UI', x_msg_data);
17715: DEBUG(x_msg_data);
17716: WHEN UNREACH_UI_NODE THEN
17717: x_return_status := FND_API.G_RET_STS_ERROR;
17718: x_msg_count := g_MSG_COUNT;
17719: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17720: DEBUG(x_msg_data);
17721: WHEN OTHERS THEN

Line 17719: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17715: DEBUG(x_msg_data);
17716: WHEN UNREACH_UI_NODE THEN
17717: x_return_status := FND_API.G_RET_STS_ERROR;
17718: x_msg_count := g_MSG_COUNT;
17719: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17720: DEBUG(x_msg_data);
17721: WHEN OTHERS THEN
17722: x_return_status := FND_API.G_RET_STS_ERROR;
17723: x_msg_count := g_MSG_COUNT;

Line 17722: x_return_status := FND_API.G_RET_STS_ERROR;

17718: x_msg_count := g_MSG_COUNT;
17719: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17720: DEBUG(x_msg_data);
17721: WHEN OTHERS THEN
17722: x_return_status := FND_API.G_RET_STS_ERROR;
17723: x_msg_count := g_MSG_COUNT;
17724: IF g_MSG_COUNT>0 THEN
17725: x_msg_count := g_MSG_COUNT;
17726: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

Line 17726: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

17722: x_return_status := FND_API.G_RET_STS_ERROR;
17723: x_msg_count := g_MSG_COUNT;
17724: IF g_MSG_COUNT>0 THEN
17725: x_msg_count := g_MSG_COUNT;
17726: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
17727: ELSE
17728: x_msg_count := 1;
17729: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
17730: END IF;

Line 18922: x_return_status := FND_API.G_RET_STS_ERROR;

18918:
18919:
18920: EXCEPTION
18921: WHEN WRONG_UI_TEMPLATE THEN
18922: x_return_status := FND_API.G_RET_STS_ERROR;
18923: x_msg_count := g_MSG_COUNT;
18924: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
18925: --DEBUG(x_msg_data);
18926: WHEN OTHERS THEN

Line 18924: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

18920: EXCEPTION
18921: WHEN WRONG_UI_TEMPLATE THEN
18922: x_return_status := FND_API.G_RET_STS_ERROR;
18923: x_msg_count := g_MSG_COUNT;
18924: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
18925: --DEBUG(x_msg_data);
18926: WHEN OTHERS THEN
18927: x_return_status := FND_API.G_RET_STS_ERROR;
18928: x_msg_count := 1;

Line 18927: x_return_status := FND_API.G_RET_STS_ERROR;

18923: x_msg_count := g_MSG_COUNT;
18924: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
18925: --DEBUG(x_msg_data);
18926: WHEN OTHERS THEN
18927: x_return_status := FND_API.G_RET_STS_ERROR;
18928: x_msg_count := 1;
18929: x_msg_data := SQLERRM;
18930: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Subtree', x_msg_data);
18931: --DEBUG(x_msg_data);

Line 18985: x_return_status := FND_API.G_RET_STS_ERROR;

18981: WHERE target_page_ui_def_id = p_ui_def_id AND target_page_id = p_ui_page_id AND
18982: deleted_flag = '0' AND element_signature_id = G_PAGE_INCL_REGION_SIGNATURE;
18983: EXCEPTION
18984: WHEN OTHERS THEN
18985: x_return_status := FND_API.G_RET_STS_ERROR;
18986: x_msg_count := 1;
18987: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
18988: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Page', x_msg_data);
18989: DEBUG(x_msg_data);

Line 19072: x_return_status := FND_API.G_RET_STS_ERROR;

19068: END IF;
19069:
19070: EXCEPTION
19071: WHEN OTHERS THEN
19072: x_return_status := FND_API.G_RET_STS_ERROR;
19073: x_msg_count := 1;
19074: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
19075: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Page_Ref', x_msg_data);
19076: DEBUG(x_msg_data);

Line 19163: x_return_status := FND_API.G_RET_STS_ERROR;

19159: deleted_flag=G_NO_FLAG;
19160:
19161: EXCEPTION
19162: WHEN WRONG_UI_TEMPLATE THEN
19163: x_return_status := FND_API.G_RET_STS_ERROR;
19164: x_msg_count := g_MSG_COUNT;
19165: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19166: DEBUG(x_msg_data);
19167: WHEN OTHERS THEN

Line 19165: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

19161: EXCEPTION
19162: WHEN WRONG_UI_TEMPLATE THEN
19163: x_return_status := FND_API.G_RET_STS_ERROR;
19164: x_msg_count := g_MSG_COUNT;
19165: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19166: DEBUG(x_msg_data);
19167: WHEN OTHERS THEN
19168: x_return_status := FND_API.G_RET_STS_ERROR;
19169: x_msg_count := 1;

Line 19168: x_return_status := FND_API.G_RET_STS_ERROR;

19164: x_msg_count := g_MSG_COUNT;
19165: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19166: DEBUG(x_msg_data);
19167: WHEN OTHERS THEN
19168: x_return_status := FND_API.G_RET_STS_ERROR;
19169: x_msg_count := 1;
19170: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
19171: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_Local_Template', x_msg_data);
19172: DEBUG('delete_Local_Template() : '||x_msg_data);

Line 19241: x_return_status := FND_API.G_RET_STS_ERROR;

19237: p_attribute_value => p_element_id,
19238: p_in_user_attributes => G_YES_FLAG );
19239:
19240: IF xmldom.isNull(l_xml_node) THEN
19241: x_return_status := FND_API.G_RET_STS_ERROR;
19242: x_msg_count := 1;
19243: x_msg_data := 'Element with element_id="'||p_element_id||'" does exist.';
19244: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_Local_Template_Elem', 'Element with element_id="'||
19245: p_element_id||'" does exist.');

Line 19291: x_return_status := FND_API.G_RET_STS_ERROR;

19287: unlock_UI_Template( p_template_id, p_template_ui_def_id, l_needs_to_be_unlocked );
19288:
19289: EXCEPTION
19290: WHEN WRONG_UI_TEMPLATE THEN
19291: x_return_status := FND_API.G_RET_STS_ERROR;
19292: x_msg_count := g_MSG_COUNT;
19293: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19294: DEBUG(x_msg_data);
19295: --

Line 19293: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

19289: EXCEPTION
19290: WHEN WRONG_UI_TEMPLATE THEN
19291: x_return_status := FND_API.G_RET_STS_ERROR;
19292: x_msg_count := g_MSG_COUNT;
19293: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19294: DEBUG(x_msg_data);
19295: --
19296: -- unlock source UI Template
19297: --

Line 19301: x_return_status := FND_API.G_RET_STS_ERROR;

19297: --
19298: unlock_UI_Template( p_template_id, p_template_ui_def_id, l_needs_to_be_unlocked );
19299:
19300: WHEN OTHERS THEN
19301: x_return_status := FND_API.G_RET_STS_ERROR;
19302: x_msg_count := 1;
19303: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
19304: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_Local_Template_Elem', x_msg_data);
19305: DEBUG('delete_Local_Template_Elem() : '||x_msg_data);

Line 19622: x_return_status := FND_API.G_RET_STS_SUCCESS;

19618: Close_Parser();
19619:
19620:
19621: IF g_MSG_COUNT>0 THEN
19622: x_return_status := FND_API.G_RET_STS_SUCCESS;
19623: x_msg_count := g_MSG_COUNT;
19624: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19625: END IF;
19626:

Line 19624: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

19620:
19621: IF g_MSG_COUNT>0 THEN
19622: x_return_status := FND_API.G_RET_STS_SUCCESS;
19623: x_msg_count := g_MSG_COUNT;
19624: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19625: END IF;
19626:
19627:
19628: EXCEPTION

Line 19630: x_return_status := FND_API.G_RET_STS_ERROR;

19626:
19627:
19628: EXCEPTION
19629: WHEN WRONG_UI_TEMPLATE THEN
19630: x_return_status := FND_API.G_RET_STS_ERROR;
19631: x_msg_count := g_MSG_COUNT;
19632: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19633: DEBUG(x_msg_data);
19634: WHEN OTHERS THEN

Line 19632: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

19628: EXCEPTION
19629: WHEN WRONG_UI_TEMPLATE THEN
19630: x_return_status := FND_API.G_RET_STS_ERROR;
19631: x_msg_count := g_MSG_COUNT;
19632: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19633: DEBUG(x_msg_data);
19634: WHEN OTHERS THEN
19635: x_return_status := FND_API.G_RET_STS_ERROR;
19636: x_msg_count := 1;

Line 19635: x_return_status := FND_API.G_RET_STS_ERROR;

19631: x_msg_count := g_MSG_COUNT;
19632: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19633: DEBUG(x_msg_data);
19634: WHEN OTHERS THEN
19635: x_return_status := FND_API.G_RET_STS_ERROR;
19636: x_msg_count := 1;
19637: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
19638: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'copy_UI_Subtree', x_msg_data);
19639: DEBUG('copy_UI_Subtree() : '||x_msg_data);

Line 19931: x_return_status := FND_API.G_RET_STS_SUCCESS;

19927: --
19928: Close_Parser();
19929:
19930: IF g_MSG_COUNT>0 THEN
19931: x_return_status := FND_API.G_RET_STS_SUCCESS;
19932: x_msg_count := g_MSG_COUNT;
19933: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19934: END IF;
19935:

Line 19933: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

19929:
19930: IF g_MSG_COUNT>0 THEN
19931: x_return_status := FND_API.G_RET_STS_SUCCESS;
19932: x_msg_count := g_MSG_COUNT;
19933: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19934: END IF;
19935:
19936: EXCEPTION
19937: WHEN WRONG_UI_TEMPLATE THEN

Line 19938: x_return_status := FND_API.G_RET_STS_ERROR;

19934: END IF;
19935:
19936: EXCEPTION
19937: WHEN WRONG_UI_TEMPLATE THEN
19938: x_return_status := FND_API.G_RET_STS_ERROR;
19939: x_msg_count := g_MSG_COUNT;
19940: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19941: DEBUG(x_msg_data);
19942: WHEN OTHERS THEN

Line 19940: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

19936: EXCEPTION
19937: WHEN WRONG_UI_TEMPLATE THEN
19938: x_return_status := FND_API.G_RET_STS_ERROR;
19939: x_msg_count := g_MSG_COUNT;
19940: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19941: DEBUG(x_msg_data);
19942: WHEN OTHERS THEN
19943: x_return_status := FND_API.G_RET_STS_ERROR;
19944: x_msg_count := 1;

Line 19943: x_return_status := FND_API.G_RET_STS_ERROR;

19939: x_msg_count := g_MSG_COUNT;
19940: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
19941: DEBUG(x_msg_data);
19942: WHEN OTHERS THEN
19943: x_return_status := FND_API.G_RET_STS_ERROR;
19944: x_msg_count := 1;
19945: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
19946: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'copy_UI_Page', x_msg_data);
19947: DEBUG('copy_UI_Page() : '||x_msg_data);

Line 20119: x_return_status := FND_API.G_RET_STS_ERROR;

20115: END LOOP;
20116:
20117: EXCEPTION
20118: WHEN OTHERS THEN
20119: x_return_status := FND_API.G_RET_STS_ERROR;
20120: x_msg_count := 1;
20121: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
20122: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'delete_UI_Subtree', x_msg_data);
20123: DEBUG('copy_UI_Page_Ref() : '||x_msg_data);

Line 20295: x_return_status := FND_API.G_RET_STS_ERROR;

20291: unlock_UI_Template( p_source_template_id, p_source_ui_def_id, l_needs_to_be_unlocked );
20292:
20293: EXCEPTION
20294: WHEN WRONG_UI_TEMPLATE THEN
20295: x_return_status := FND_API.G_RET_STS_ERROR;
20296: x_msg_count := g_MSG_COUNT;
20297: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20298: DEBUG(x_msg_data);
20299: --

Line 20297: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

20293: EXCEPTION
20294: WHEN WRONG_UI_TEMPLATE THEN
20295: x_return_status := FND_API.G_RET_STS_ERROR;
20296: x_msg_count := g_MSG_COUNT;
20297: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20298: DEBUG(x_msg_data);
20299: --
20300: -- unlock source UI Template
20301: --

Line 20304: x_return_status := FND_API.G_RET_STS_ERROR;

20300: -- unlock source UI Template
20301: --
20302: unlock_UI_Template( p_source_template_id, p_source_ui_def_id, l_needs_to_be_unlocked );
20303: WHEN OTHERS THEN
20304: x_return_status := FND_API.G_RET_STS_ERROR;
20305: x_msg_count := 1;
20306: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
20307: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'copy_Local_Template', x_msg_data);
20308: DEBUG('copy_Local_Template() : '||x_msg_data);

Line 20365: x_return_status := FND_API.G_RET_STS_ERROR;

20361: Close_Parser();
20362:
20363: EXCEPTION
20364: WHEN WRONG_UI_TEMPLATE THEN
20365: x_return_status := FND_API.G_RET_STS_ERROR;
20366: x_msg_count := g_MSG_COUNT;
20367: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20368: DEBUG(x_msg_data);
20369: WHEN OTHERS THEN

Line 20367: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

20363: EXCEPTION
20364: WHEN WRONG_UI_TEMPLATE THEN
20365: x_return_status := FND_API.G_RET_STS_ERROR;
20366: x_msg_count := g_MSG_COUNT;
20367: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20368: DEBUG(x_msg_data);
20369: WHEN OTHERS THEN
20370: x_return_status := FND_API.G_RET_STS_ERROR;
20371: x_msg_count := 1;

Line 20370: x_return_status := FND_API.G_RET_STS_ERROR;

20366: x_msg_count := g_MSG_COUNT;
20367: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20368: DEBUG(x_msg_data);
20369: WHEN OTHERS THEN
20370: x_return_status := FND_API.G_RET_STS_ERROR;
20371: x_msg_count := 1;
20372: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
20373: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'copy_JRAD_Document', x_msg_data);
20374: DEBUG('copy_JRAD_Document() : '||x_msg_data);

Line 20589: x_return_status := FND_API.G_RET_STS_ERROR;

20585: unlock_UI_Template( p_source_template_id, p_source_ui_def_id, l_needs_to_be_unlocked );
20586:
20587: EXCEPTION
20588: WHEN WRONG_UI_TEMPLATE THEN
20589: x_return_status := FND_API.G_RET_STS_ERROR;
20590: x_msg_count := g_MSG_COUNT;
20591: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20592: DEBUG(x_msg_data);
20593: --

Line 20591: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

20587: EXCEPTION
20588: WHEN WRONG_UI_TEMPLATE THEN
20589: x_return_status := FND_API.G_RET_STS_ERROR;
20590: x_msg_count := g_MSG_COUNT;
20591: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20592: DEBUG(x_msg_data);
20593: --
20594: -- unlock source UI Template
20595: --

Line 20599: x_return_status := FND_API.G_RET_STS_ERROR;

20595: --
20596: unlock_UI_Template( p_source_template_id, p_source_ui_def_id, l_needs_to_be_unlocked );
20597:
20598: WHEN OTHERS THEN
20599: x_return_status := FND_API.G_RET_STS_ERROR;
20600: x_msg_count := 1;
20601: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
20602: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'copy_Local_Template_Elem', x_msg_data);
20603: DEBUG('copy_Local_Template_Elem() : '||x_msg_data);

Line 20906: x_return_status := FND_API.G_RET_STS_ERROR;

20902: unlock_UI_Template( p_template_id, p_template_ui_def_id, l_needs_to_be_unlocked );
20903:
20904: EXCEPTION
20905: WHEN WRONG_UI_TEMPLATE THEN
20906: x_return_status := FND_API.G_RET_STS_ERROR;
20907: x_msg_count := g_MSG_COUNT;
20908: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20909: DEBUG(x_msg_data);
20910: --

Line 20908: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

20904: EXCEPTION
20905: WHEN WRONG_UI_TEMPLATE THEN
20906: x_return_status := FND_API.G_RET_STS_ERROR;
20907: x_msg_count := g_MSG_COUNT;
20908: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
20909: DEBUG(x_msg_data);
20910: --
20911: -- unlock source UI Template
20912: --

Line 20916: x_return_status := FND_API.G_RET_STS_ERROR;

20912: --
20913: unlock_UI_Template( p_template_id, p_template_ui_def_id, l_needs_to_be_unlocked );
20914:
20915: WHEN OTHERS THEN
20916: x_return_status := FND_API.G_RET_STS_ERROR;
20917: x_msg_count := 1;
20918: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
20919: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'create_Region_From_Template', x_msg_data);
20920: DEBUG('create_Region_From_Template() : '||x_msg_data);

Line 21142: x_return_status := FND_API.G_RET_STS_ERROR;

21138: unlock_UI_Template( p_template_id, p_template_ui_def_id, l_needs_to_be_unlocked );
21139:
21140: EXCEPTION
21141: WHEN WRONG_UI_TEMPLATE THEN
21142: x_return_status := FND_API.G_RET_STS_ERROR;
21143: x_msg_count := g_MSG_COUNT;
21144: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
21145: DEBUG(x_msg_data);
21146: --

Line 21144: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

21140: EXCEPTION
21141: WHEN WRONG_UI_TEMPLATE THEN
21142: x_return_status := FND_API.G_RET_STS_ERROR;
21143: x_msg_count := g_MSG_COUNT;
21144: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
21145: DEBUG(x_msg_data);
21146: --
21147: -- unlock source UI Template
21148: --

Line 21152: x_return_status := FND_API.G_RET_STS_ERROR;

21148: --
21149: unlock_UI_Template( p_template_id, p_template_ui_def_id, l_needs_to_be_unlocked );
21150:
21151: WHEN OTHERS THEN
21152: x_return_status := FND_API.G_RET_STS_ERROR;
21153: x_msg_count := 1;
21154: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
21155: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'add_Template_To_Template', x_msg_data);
21156: DEBUG('create_Region_From_Template() : '||x_msg_data);

Line 21568: x_return_status := FND_API.G_RET_STS_ERROR;

21564: end if;
21565:
21566: EXCEPTION
21567: WHEN WRONG_UI_TEMPLATE THEN
21568: x_return_status := FND_API.G_RET_STS_ERROR;
21569: x_msg_count := g_MSG_COUNT;
21570: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
21571: DEBUG(x_msg_data);
21572: WHEN OTHERS THEN

Line 21570: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);

21566: EXCEPTION
21567: WHEN WRONG_UI_TEMPLATE THEN
21568: x_return_status := FND_API.G_RET_STS_ERROR;
21569: x_msg_count := g_MSG_COUNT;
21570: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
21571: DEBUG(x_msg_data);
21572: WHEN OTHERS THEN
21573: x_return_status := FND_API.G_RET_STS_ERROR;
21574: x_msg_count := 1;

Line 21573: x_return_status := FND_API.G_RET_STS_ERROR;

21569: x_msg_count := g_MSG_COUNT;
21570: x_msg_data := fnd_msg_pub.GET(g_MSG_COUNT,fnd_api.g_false);
21571: DEBUG(x_msg_data);
21572: WHEN OTHERS THEN
21573: x_return_status := FND_API.G_RET_STS_ERROR;
21574: x_msg_count := 1;
21575: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
21576: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'convert_Template_Reference', x_msg_data);
21577: DEBUG('convert_Template_Reference() : '||x_msg_data);

Line 21836: x_return_status := FND_API.G_RET_STS_ERROR;

21832: element_signature_id = G_PAGE_INCL_REGION_SIGNATURE;
21833:
21834: EXCEPTION
21835: WHEN OTHERS THEN
21836: x_return_status := FND_API.G_RET_STS_ERROR;
21837: x_msg_count := 1;
21838: x_msg_data := SUBSTR(DBMS_UTILITY.format_error_backtrace,1,4000);
21839: fnd_msg_pub.add_exc_msg('CZ_UIOA_PVT', 'update_UI_Reference', x_msg_data);
21840: DEBUG('update_UI_Reference() : '||x_msg_data);