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.OKC_UDA_TEMPLATES_UTIL dependencies on FND_LOG

Line 730: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

726:
727: BEGIN
728: l_api_name := 'copy_associations';
729:
730: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
732: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_associations');
733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
734: '101: p_new_template_code is: ' || p_new_template_code);

Line 731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

727: BEGIN
728: l_api_name := 'copy_associations';
729:
730: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
732: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_associations');
733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
734: '101: p_new_template_code is: ' || p_new_template_code);
735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

729:
730: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
732: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_associations');
733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
734: '101: p_new_template_code is: ' || p_new_template_code);
735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
736: '102: p_src_template_code is: ' || p_src_template_code);
737: END IF;

Line 735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
732: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_associations');
733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
734: '101: p_new_template_code is: ' || p_new_template_code);
735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
736: '102: p_src_template_code is: ' || p_src_template_code);
737: END IF;
738: -- Initialize message list if p_init_msg_list is set to TRUE.
739: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 769: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

765: x_errorcode => l_errorcode ,
766: x_msg_count => x_msg_count ,
767: x_msg_data => x_msg_data);
768:
769: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
770: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
771: 'EGO_EXT_FWK_PUB.Create_Association return status is: '
772: || x_return_status);
773: END IF;

Line 770: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

766: x_msg_count => x_msg_count ,
767: x_msg_data => x_msg_data);
768:
769: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
770: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
771: 'EGO_EXT_FWK_PUB.Create_Association return status is: '
772: || x_return_status);
773: END IF;
774: -------------------------------------------------------

Line 796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

792: x_return_status => x_return_status,
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data);
795:
796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
797: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
798: 'copy_uda_actions return status is: '
799: || x_return_status);
800: END IF;

Line 797: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data);
795:
796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
797: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
798: 'copy_uda_actions return status is: '
799: || x_return_status);
800: END IF;
801: -------------------------------------------------------

Line 812: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

808:
809:
810: END LOOP;
811:
812: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
814: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
815: END IF;
816:

Line 813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

809:
810: END LOOP;
811:
812: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
814: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
815: END IF;
816:
817:

Line 820: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

816:
817:
818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
822: g_module || l_api_name || '.exception',
823: 'Leaving copy_associations: FND_API.G_EXC_ERROR Exception');
824: END IF;

Line 821: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

817:
818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
822: g_module || l_api_name || '.exception',
823: 'Leaving copy_associations: FND_API.G_EXC_ERROR Exception');
824: END IF;
825: x_return_status := FND_API.G_RET_STS_ERROR;

Line 831: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
833: g_module || l_api_name || '.exception',
834: 'Leaving copy_associations: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
835: END IF;

Line 832: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

828: p_data => x_msg_data
829: );
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
832: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
833: g_module || l_api_name || '.exception',
834: 'Leaving copy_associations: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
835: END IF;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 842: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );
841: WHEN OTHERS THEN
842: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
843: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
844: g_module || l_api_name || '.exception',
845: 'Leaving copy_associations because of EXCEPTION: ' || sqlerrm);
846: END IF;

Line 843: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

839: p_data => x_msg_data
840: );
841: WHEN OTHERS THEN
842: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
843: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
844: g_module || l_api_name || '.exception',
845: 'Leaving copy_associations because of EXCEPTION: ' || sqlerrm);
846: END IF;
847: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 911: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

907:
908:
909: l_api_name := 'copy_uda_actions';
910:
911: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
912: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
913: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_uda_actions');
914: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
915: '101: p_new_template_code is: ' || p_new_template_code);

Line 912: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

908:
909: l_api_name := 'copy_uda_actions';
910:
911: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
912: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
913: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_uda_actions');
914: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
915: '101: p_new_template_code is: ' || p_new_template_code);
916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 914: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

910:
911: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
912: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
913: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_uda_actions');
914: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
915: '101: p_new_template_code is: ' || p_new_template_code);
916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
917: '102: p_src_template_code is: ' || p_src_template_code);
918: END IF;

Line 916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

912: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
913: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_uda_actions');
914: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
915: '101: p_new_template_code is: ' || p_new_template_code);
916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
917: '102: p_src_template_code is: ' || p_src_template_code);
918: END IF;
919: -- Initialize message list if p_init_msg_list is set to TRUE.
920: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 950: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

946: x_errorcode => l_errorcode,
947: x_msg_count => l_msg_count ,
948: x_msg_data => l_msg_data);
949:
950: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
952: 'EGO_EXT_FWK_PUB.Create_Action return status is: '
953: || x_return_status);
954: END IF;

Line 951: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

947: x_msg_count => l_msg_count ,
948: x_msg_data => l_msg_data);
949:
950: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
952: 'EGO_EXT_FWK_PUB.Create_Action return status is: '
953: || x_return_status);
954: END IF;
955: -------------------------------------------------------

Line 986: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

982: ,x_errorcode => l_errorcode
983: ,x_msg_count => l_msg_count
984: ,x_msg_data => l_msg_data );
985:
986: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
988: 'EGO_EXT_FWK_PUB.Create_Action_Display return status is: '
989: || x_return_status);
990: END IF;

Line 987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

983: ,x_msg_count => l_msg_count
984: ,x_msg_data => l_msg_data );
985:
986: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
988: 'EGO_EXT_FWK_PUB.Create_Action_Display return status is: '
989: || x_return_status);
990: END IF;
991: -------------------------------------------------------

Line 1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1025: ,x_errorcode => l_errorcode
1026: ,x_msg_count => l_msg_count
1027: ,x_msg_data => l_msg_data);
1028:
1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1031: 'EGO_EXT_FWK_PUB.Create_Mapping return status is: '
1032: || x_return_status);
1033: END IF;

Line 1030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1026: ,x_msg_count => l_msg_count
1027: ,x_msg_data => l_msg_data);
1028:
1029: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1030: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1031: 'EGO_EXT_FWK_PUB.Create_Mapping return status is: '
1032: || x_return_status);
1033: END IF;
1034: -------------------------------------------------------

Line 1056: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1052: IF (i = 0) THEN
1053: x_return_status := 'S';
1054: END IF;
1055:
1056: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1058: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1059: END IF;
1060:

Line 1057: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1053: x_return_status := 'S';
1054: END IF;
1055:
1056: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1058: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1059: END IF;
1060:
1061:

Line 1064: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1060:
1061:
1062: EXCEPTION
1063: WHEN FND_API.G_EXC_ERROR THEN
1064: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1065: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1066: g_module || l_api_name || '.exception',
1067: 'Leaving copy_uda_actions: FND_API.G_EXC_ERROR Exception');
1068: END IF;

Line 1065: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1061:
1062: EXCEPTION
1063: WHEN FND_API.G_EXC_ERROR THEN
1064: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1065: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1066: g_module || l_api_name || '.exception',
1067: 'Leaving copy_uda_actions: FND_API.G_EXC_ERROR Exception');
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1075: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1071: p_count => x_msg_count,
1072: p_data => x_msg_data
1073: );
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1077: g_module || l_api_name || '.exception',
1078: 'Leaving copy_uda_actions: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1079: END IF;

Line 1076: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1072: p_data => x_msg_data
1073: );
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1075: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1077: g_module || l_api_name || '.exception',
1078: 'Leaving copy_uda_actions: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1079: END IF;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1086: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1082: p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );
1085: WHEN OTHERS THEN
1086: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1087: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1088: g_module || l_api_name || '.exception',
1089: 'Leaving copy_uda_actions because of EXCEPTION: ' || sqlerrm);
1090: END IF;

Line 1087: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1083: p_data => x_msg_data
1084: );
1085: WHEN OTHERS THEN
1086: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1087: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1088: g_module || l_api_name || '.exception',
1089: 'Leaving copy_uda_actions because of EXCEPTION: ' || sqlerrm);
1090: END IF;
1091: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1142: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1138: BEGIN
1139:
1140: l_api_name := 'copy_pages';
1141:
1142: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1144: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_pages');
1145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1146: '101: p_new_template_code is: ' || p_new_template_code);

Line 1143: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1139:
1140: l_api_name := 'copy_pages';
1141:
1142: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1144: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_pages');
1145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1146: '101: p_new_template_code is: ' || p_new_template_code);
1147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1141:
1142: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1144: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_pages');
1145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1146: '101: p_new_template_code is: ' || p_new_template_code);
1147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1148: '102: p_src_template_code is: ' || p_src_template_code);
1149: END IF;

Line 1147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1143: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1144: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_pages');
1145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1146: '101: p_new_template_code is: ' || p_new_template_code);
1147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1148: '102: p_src_template_code is: ' || p_src_template_code);
1149: END IF;
1150: -- Initialize message list if p_init_msg_list is set to TRUE.
1151: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1178: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1174: ,x_msg_count => x_msg_count
1175: ,x_msg_data => x_msg_data
1176: );
1177:
1178: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1180: 'EGO_EXT_FWK_PUB.Create_Page return status is: '
1181: || x_return_status);
1182: END IF;

Line 1179: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1175: ,x_msg_data => x_msg_data
1176: );
1177:
1178: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1180: 'EGO_EXT_FWK_PUB.Create_Page return status is: '
1181: || x_return_status);
1182: END IF;
1183: -------------------------------------------------------

Line 1220: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1216: ,x_msg_count => x_msg_count
1217: ,x_msg_data => x_msg_data
1218: );
1219:
1220: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1221: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1222: 'EGO_EXT_FWK_PUB.Create_Page_Entry return status is: '
1223: || x_return_status);
1224: END IF;

Line 1221: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1217: ,x_msg_data => x_msg_data
1218: );
1219:
1220: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1221: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1222: 'EGO_EXT_FWK_PUB.Create_Page_Entry return status is: '
1223: || x_return_status);
1224: END IF;
1225: -------------------------------------------------------

Line 1237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1233: END LOOP;
1234: END LOOP;
1235:
1236:
1237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1239: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1240: END IF;
1241:

Line 1238: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1234: END LOOP;
1235:
1236:
1237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1239: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1240: END IF;
1241:
1242:

Line 1245: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1241:
1242:
1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1247: g_module || l_api_name || '.exception',
1248: 'Leaving copy_pages: FND_API.G_EXC_ERROR Exception');
1249: END IF;

Line 1246: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1242:
1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1247: g_module || l_api_name || '.exception',
1248: 'Leaving copy_pages: FND_API.G_EXC_ERROR Exception');
1249: END IF;
1250: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1256: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1252: p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1257: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1258: g_module || l_api_name || '.exception',
1259: 'Leaving copy_pages: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1260: END IF;

Line 1257: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1253: p_data => x_msg_data
1254: );
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1257: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1258: g_module || l_api_name || '.exception',
1259: 'Leaving copy_pages: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1260: END IF;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1267: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1263: p_count => x_msg_count,
1264: p_data => x_msg_data
1265: );
1266: WHEN OTHERS THEN
1267: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1269: g_module || l_api_name || '.exception',
1270: 'Leaving copy_pages because of EXCEPTION: ' || sqlerrm);
1271: END IF;

Line 1268: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1264: p_data => x_msg_data
1265: );
1266: WHEN OTHERS THEN
1267: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1269: g_module || l_api_name || '.exception',
1270: 'Leaving copy_pages because of EXCEPTION: ' || sqlerrm);
1271: END IF;
1272: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 1315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1311: BEGIN
1312:
1313: l_api_name := 'copy_template_details';
1314:
1315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1317: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_template_details');
1318: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1319: '101: p_src_uda_temp_id is: ' || To_Char(p_src_uda_temp_id));

Line 1316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1312:
1313: l_api_name := 'copy_template_details';
1314:
1315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1317: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_template_details');
1318: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1319: '101: p_src_uda_temp_id is: ' || To_Char(p_src_uda_temp_id));
1320: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 1318: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1314:
1315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1317: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_template_details');
1318: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1319: '101: p_src_uda_temp_id is: ' || To_Char(p_src_uda_temp_id));
1320: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1321: '102: p_new_uda_temp_id is: ' || To_Char(p_new_uda_temp_id));
1322: END IF;

Line 1320: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1317: '100: Entered OKC_UDA_TEMPLATES_UTIL.copy_template_details');
1318: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1319: '101: p_src_uda_temp_id is: ' || To_Char(p_src_uda_temp_id));
1320: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1321: '102: p_new_uda_temp_id is: ' || To_Char(p_new_uda_temp_id));
1322: END IF;
1323: -- Initialize message list if p_init_msg_list is set to TRUE.
1324: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1368: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1364: CLOSE c_attr_grp_details;
1365:
1366: IF (l_object_id = NULL ) THEN
1367:
1368: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1370: 'l_object_id is null ');
1371: END IF;
1372:

Line 1369: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1365:
1366: IF (l_object_id = NULL ) THEN
1367:
1368: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1370: 'l_object_id is null ');
1371: END IF;
1372:
1373: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1391: x_return_status => x_return_status,
1392: x_msg_count => x_msg_count,
1393: x_msg_data => x_msg_data);
1394:
1395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1396: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1397: 'copy_associations return status is: '
1398: || x_return_status);
1399: END IF;

Line 1396: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1392: x_msg_count => x_msg_count,
1393: x_msg_data => x_msg_data);
1394:
1395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1396: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1397: 'copy_associations return status is: '
1398: || x_return_status);
1399: END IF;
1400: -------------------------------------------------------

Line 1422: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1418: x_msg_data => x_msg_data);
1419:
1420:
1421:
1422: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1423: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1424: 'copy_pages return status is: '
1425: || x_return_status);
1426: END IF;

Line 1423: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1419:
1420:
1421:
1422: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1423: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1424: 'copy_pages return status is: '
1425: || x_return_status);
1426: END IF;
1427: -------------------------------------------------------

Line 1436: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1432: END IF;
1433: --------------------------------------------------------
1434:
1435:
1436: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1437: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1438: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1439: END IF;
1440:

Line 1437: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1433: --------------------------------------------------------
1434:
1435:
1436: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1437: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1438: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1439: END IF;
1440:
1441: EXCEPTION

Line 1443: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1439: END IF;
1440:
1441: EXCEPTION
1442: WHEN FND_API.G_EXC_ERROR THEN
1443: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1445: g_module || l_api_name || '.exception',
1446: 'Leaving copy_template_details: FND_API.G_EXC_ERROR Exception');
1447: END IF;

Line 1444: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1440:
1441: EXCEPTION
1442: WHEN FND_API.G_EXC_ERROR THEN
1443: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1445: g_module || l_api_name || '.exception',
1446: 'Leaving copy_template_details: FND_API.G_EXC_ERROR Exception');
1447: END IF;
1448:

Line 1457: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1453: p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );
1456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1457: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1458: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1459: g_module || l_api_name || '.exception',
1460: 'Leaving copy_template_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1461: END IF;

Line 1458: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1454: p_data => x_msg_data
1455: );
1456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1457: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1458: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1459: g_module || l_api_name || '.exception',
1460: 'Leaving copy_template_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1461: END IF;
1462: ROLLBACK TO copy_temp_details_PVT;

Line 1469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468: WHEN OTHERS THEN
1469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1471: g_module || l_api_name || '.exception',
1472: 'Leaving copy_template_details because of EXCEPTION: ' || sqlerrm);
1473: END IF;

Line 1470: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1466: p_data => x_msg_data
1467: );
1468: WHEN OTHERS THEN
1469: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1471: g_module || l_api_name || '.exception',
1472: 'Leaving copy_template_details because of EXCEPTION: ' || sqlerrm);
1473: END IF;
1474: ROLLBACK TO copy_temp_details_PVT;

Line 1551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1547: BEGIN
1548:
1549: l_api_name := 'delete_temp_details';
1550:
1551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1553: '100: Entered OKC_UDA_TEMPLATES_UTIL.delete_temp_uda_details');
1554: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1555: '101: p_src_uda_temp_id is: ' || To_Char(p_uda_temp_id));

Line 1552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1548:
1549: l_api_name := 'delete_temp_details';
1550:
1551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1553: '100: Entered OKC_UDA_TEMPLATES_UTIL.delete_temp_uda_details');
1554: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1555: '101: p_src_uda_temp_id is: ' || To_Char(p_uda_temp_id));
1556: END IF;

Line 1554: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1550:
1551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1553: '100: Entered OKC_UDA_TEMPLATES_UTIL.delete_temp_uda_details');
1554: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1555: '101: p_src_uda_temp_id is: ' || To_Char(p_uda_temp_id));
1556: END IF;
1557: -- Initialize message list if p_init_msg_list is set to TRUE.
1558: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1573:
1574: OPEN c_get_object_id;
1575: FETCH c_get_object_id INTO l_object_id;
1576: IF c_get_object_id%NOTFOUND THEN
1577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1579: 'Invalid template Id: ' );
1580: END IF;
1581:

Line 1578: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1574: OPEN c_get_object_id;
1575: FETCH c_get_object_id INTO l_object_id;
1576: IF c_get_object_id%NOTFOUND THEN
1577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1579: 'Invalid template Id: ' );
1580: END IF;
1581:
1582: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1582: RAISE OKC_API.G_EXCEPTION_ERROR;
1583: END IF;
1584: CLOSE c_get_object_id;
1585:
1586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1588: '102: l_object_id is: ' || To_Char(l_object_id));
1589: END IF;
1590:

Line 1587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1583: END IF;
1584: CLOSE c_get_object_id;
1585:
1586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1588: '102: l_object_id is: ' || To_Char(l_object_id));
1589: END IF;
1590:
1591:

Line 1607: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1603: ,x_msg_count => x_msg_count
1604: ,x_msg_data => x_msg_data
1605: );
1606:
1607: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1609: 'EGO_EXT_FWK_PUB.DELETE_PAGE return status is: '
1610: || x_return_status);
1611: END IF;

Line 1608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1604: ,x_msg_data => x_msg_data
1605: );
1606:
1607: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1609: 'EGO_EXT_FWK_PUB.DELETE_PAGE return status is: '
1610: || x_return_status);
1611: END IF;
1612: -------------------------------------------------------

Line 1638: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1634: x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1635: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1636: x_msg_data => x_msg_data); -- OUT NOCOPY VARCHAR2
1637:
1638: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1639: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1640: ' ego_ext_fwk_pub.Delete_Association return status is: '
1641: || x_return_status);
1642: END IF;

Line 1639: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1635: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1636: x_msg_data => x_msg_data); -- OUT NOCOPY VARCHAR2
1637:
1638: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1639: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1640: ' ego_ext_fwk_pub.Delete_Association return status is: '
1641: || x_return_status);
1642: END IF;
1643: -------------------------------------------------------

Line 1666: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1662: ,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1663: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1664: x_msg_data => x_msg_data);
1665:
1666: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1668: ' ego_ext_fwk_pub.Delete_Action return status is: '
1669: || x_return_status);
1670: END IF;

Line 1667: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1663: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1664: x_msg_data => x_msg_data);
1665:
1666: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1668: ' ego_ext_fwk_pub.Delete_Action return status is: '
1669: || x_return_status);
1670: END IF;
1671: -------------------------------------------------------

Line 1692: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1688: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1689: x_msg_data => x_msg_data);
1690:
1691:
1692: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1694: ' ego_ext_fwk_pub.Delete_Action_Display return status is: '
1695: || x_return_status);
1696: END IF;

Line 1693: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1689: x_msg_data => x_msg_data);
1690:
1691:
1692: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1694: ' ego_ext_fwk_pub.Delete_Action_Display return status is: '
1695: || x_return_status);
1696: END IF;
1697: -------------------------------------------------------

Line 1720: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1716: ,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1717: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1718: x_msg_data => x_msg_data);
1719:
1720: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1721: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1722: ' ego_ext_fwk_pub.Delete_Action_Display return status is: '
1723: || x_return_status);
1724: END IF;

Line 1721: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1717: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1718: x_msg_data => x_msg_data);
1719:
1720: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1721: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1722: ' ego_ext_fwk_pub.Delete_Action_Display return status is: '
1723: || x_return_status);
1724: END IF;
1725: -------------------------------------------------------

Line 1739: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1735: END LOOP;
1736: END IF ;
1737: END LOOP;
1738:
1739: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1740: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1741: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1742: END IF;
1743:

Line 1740: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1736: END IF ;
1737: END LOOP;
1738:
1739: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1740: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1741: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
1742: END IF;
1743:
1744: EXCEPTION

Line 1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1742: END IF;
1743:
1744: EXCEPTION
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1748: g_module || l_api_name || '.exception',
1749: 'Leaving delete_temp_details: FND_API.G_EXC_ERROR Exception');
1750: END IF;

Line 1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1743:
1744: EXCEPTION
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1748: g_module || l_api_name || '.exception',
1749: 'Leaving delete_temp_details: FND_API.G_EXC_ERROR Exception');
1750: END IF;
1751:

Line 1760: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1756: p_count => x_msg_count,
1757: p_data => x_msg_data
1758: );
1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1760: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1761: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1762: g_module || l_api_name || '.exception',
1763: 'Leaving delete_temp_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1764: END IF;

Line 1761: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1757: p_data => x_msg_data
1758: );
1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1760: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1761: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1762: g_module || l_api_name || '.exception',
1763: 'Leaving delete_temp_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1764: END IF;
1765: ROLLBACK TO del_temp_details_PVT;

Line 1772: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1768: p_count => x_msg_count,
1769: p_data => x_msg_data
1770: );
1771: WHEN OTHERS THEN
1772: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1774: g_module || l_api_name || '.exception',
1775: 'Leaving delete_temp_details because of EXCEPTION: ' || sqlerrm);
1776: END IF;

Line 1773: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1769: p_data => x_msg_data
1770: );
1771: WHEN OTHERS THEN
1772: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1774: g_module || l_api_name || '.exception',
1775: 'Leaving delete_temp_details because of EXCEPTION: ' || sqlerrm);
1776: END IF;
1777: ROLLBACK TO del_temp_details_PVT;