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_API

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198: AND T.LANGUAGE = L.LANGUAGE_CODE
199: );
200:
201: WHEN TOO_MANY_ROWS THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END;
204: END IF; -- AG found
205: END IF; -- function found
206: END;

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207:
208: EXCEPTION
209: WHEN OTHERS THEN
210: debug_msg('UPLOAD_ACTIONS: in exception ' ||SQLERRM);
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212:
213: END UPLOAD_ACTIONS;
214:
215: PROCEDURE UPLOAD_ACTIONS_NLS

Line 297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

293:
294: EXCEPTION
295: WHEN OTHERS THEN
296: debug_msg('UPLOAD_ACTIONS_NLS: in exception ' ||SQLERRM);
297: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298:
299:
300: END UPLOAD_ACTIONS_NLS ;
301:

Line 403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

399: 0
400: );
401:
402: WHEN TOO_MANY_ROWS THEN
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END;
405: END IF; -- Action found
406: END IF; -- AG found
407: END;

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407: END;
408: EXCEPTION
409: WHEN OTHERS THEN
410: debug_msg('UPLOAD_ACTION_DL: in exception ' ||SQLERRM);
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412:
413: END UPLOAD_ACTION_DL;
414:
415: PROCEDURE UPLOAD_ACTION_DISPLAYS

Line 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: 0
530: );
531:
532: WHEN TOO_MANY_ROWS THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END;
535: END IF; -- Action Found
536: END IF; -- AG found
537: END;

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: END;
538: EXCEPTION
539: WHEN OTHERS THEN
540: debug_msg('UPLOAD_ACTION_DISPLAYS: in exception ' ||SQLERRM);
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END UPLOAD_ACTION_DISPLAYS;
543:
544: PROCEDURE UPLOAD_FUNCTION_MAPPINGS
545: (

Line 699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

695: END;
696: EXCEPTION
697: WHEN OTHERS THEN
698: debug_msg('UPLOAD_FUNCTION_MAPPINGS: in exception ' ||SQLERRM);
699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
700: END UPLOAD_FUNCTION_MAPPINGS;
701:
702: PROCEDURE copy_associations(p_api_version IN NUMBER,
703: p_init_msg_list IN VARCHAR2,

Line 739: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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
740: FND_MSG_PUB.initialize;
741: END IF;
742:
743: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 743: x_return_status := FND_API.G_RET_STS_SUCCESS;

739: IF FND_API.to_Boolean( p_init_msg_list ) THEN
740: FND_MSG_PUB.initialize;
741: END IF;
742:
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744:
745: FOR c_get_assoc_csr_rec IN c_get_assoc_csr LOOP
746:
747: OPEN c_gen_association_id;

Line 786: p_init_msg_list => FND_API.G_FALSE,

782:
783: -- copy actions
784:
785: copy_uda_actions(p_api_version => 1.0,
786: p_init_msg_list => FND_API.G_FALSE,
787: p_commit => FND_API.G_FALSE,
788: p_attr_group_id => c_get_assoc_csr_rec.attr_group_id,
789: p_new_template_code => p_new_template_code,
790: p_src_template_code => p_src_template_code,

Line 787: p_commit => FND_API.G_FALSE,

783: -- copy actions
784:
785: copy_uda_actions(p_api_version => 1.0,
786: p_init_msg_list => FND_API.G_FALSE,
787: p_commit => FND_API.G_FALSE,
788: p_attr_group_id => c_get_assoc_csr_rec.attr_group_id,
789: p_new_template_code => p_new_template_code,
790: p_src_template_code => p_src_template_code,
791: p_object_id => p_object_id,

Line 819: WHEN FND_API.G_EXC_ERROR THEN

815: END IF;
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');

Line 823: 'Leaving copy_associations: FND_API.G_EXC_ERROR 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;
826: FND_MSG_PUB.Count_And_Get(
827: p_count => x_msg_count,

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

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;
826: FND_MSG_PUB.Count_And_Get(
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );

Line 830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

826: FND_MSG_PUB.Count_And_Get(
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');

Line 834: 'Leaving copy_associations: FND_API.G_EXC_UNEXPECTED_ERROR Exception');

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;
837: FND_MSG_PUB.Count_And_Get(
838: p_count => x_msg_count,

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
837: FND_MSG_PUB.Count_And_Get(
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

849: p_token1 => G_SQLCODE_TOKEN,
850: p_token1_value => sqlcode,
851: p_token2 => G_SQLERRM_TOKEN,
852: p_token2_value => sqlerrm);
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: FND_MSG_PUB.Count_And_Get(
855: p_count => x_msg_count,
856: p_data => x_msg_data
857: );

Line 920: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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
921: FND_MSG_PUB.initialize;
922: END IF;
923:
924: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 924: x_return_status := FND_API.G_RET_STS_SUCCESS;

920: IF FND_API.to_Boolean( p_init_msg_list ) THEN
921: FND_MSG_PUB.initialize;
922: END IF;
923:
924: x_return_status := FND_API.G_RET_STS_SUCCESS;
925:
926: FOR c_src_action_ids_rec IN c_src_action_ids(p_attr_group_id, p_src_template_code, p_object_id) LOOP
927:
928: FOR c_src_record_rec IN c_src_record(c_src_action_ids_rec.action_id) LOOP

Line 942: p_init_msg_list => fnd_api.g_FALSE ,

938: p_description => c_src_record_rec.DESCRIPTION ,
939: p_function_id => c_src_record_rec.FUNCTION_ID , -- ignored for now
940: p_enable_key_attrs => c_src_record_rec.ENABLE_KEY_ATTRIBUTES , -- ignored for now
941: p_security_privilege_id => c_src_record_rec.SECURITY_PRIVILEGE_ID ,
942: p_init_msg_list => fnd_api.g_FALSE ,
943: p_commit => fnd_api.g_FALSE ,
944: x_action_id => l_action_id ,
945: x_return_status => l_return_status ,
946: x_errorcode => l_errorcode,

Line 943: p_commit => fnd_api.g_FALSE ,

939: p_function_id => c_src_record_rec.FUNCTION_ID , -- ignored for now
940: p_enable_key_attrs => c_src_record_rec.ENABLE_KEY_ATTRIBUTES , -- ignored for now
941: p_security_privilege_id => c_src_record_rec.SECURITY_PRIVILEGE_ID ,
942: p_init_msg_list => fnd_api.g_FALSE ,
943: p_commit => fnd_api.g_FALSE ,
944: x_action_id => l_action_id ,
945: x_return_status => l_return_status ,
946: x_errorcode => l_errorcode,
947: x_msg_count => l_msg_count ,

Line 979: ,p_init_msg_list => fnd_api.g_FALSE

975: ,p_prompt_message_name => c_src_action_display_rec.PROMPT_MESSAGE_NAME
976: ,p_visibility_flag => c_src_action_display_rec.VISIBILITY_FLAG
977: ,p_prompt_function_id => c_src_action_display_rec.PROMPT_FUNCTION_ID
978: ,p_visibility_func_id => c_src_action_display_rec.VISIBILITY_FUNC_ID
979: ,p_init_msg_list => fnd_api.g_FALSE
980: ,p_commit => fnd_api.g_FALSE
981: ,x_return_status => l_return_status
982: ,x_errorcode => l_errorcode
983: ,x_msg_count => l_msg_count

Line 980: ,p_commit => fnd_api.g_FALSE

976: ,p_visibility_flag => c_src_action_display_rec.VISIBILITY_FLAG
977: ,p_prompt_function_id => c_src_action_display_rec.PROMPT_FUNCTION_ID
978: ,p_visibility_func_id => c_src_action_display_rec.VISIBILITY_FUNC_ID
979: ,p_init_msg_list => fnd_api.g_FALSE
980: ,p_commit => fnd_api.g_FALSE
981: ,x_return_status => l_return_status
982: ,x_errorcode => l_errorcode
983: ,x_msg_count => l_msg_count
984: ,x_msg_data => l_msg_data );

Line 1022: ,p_init_msg_list => fnd_api.g_FALSE

1018: ,p_mapping_value => c_src_func_mappings_rec.MAPPED_ATTRIBUTE
1019: ,p_mapped_uom_parameter => c_src_func_mappings_rec.MAPPED_UOM_PARAMETER
1020: ,p_value_uom_source => c_src_func_mappings_rec.VALUE_UOM_SOURCE
1021: ,p_fixed_uom => c_src_func_mappings_rec.FIXED_UOM
1022: ,p_init_msg_list => fnd_api.g_FALSE
1023: ,p_commit => fnd_api.g_FALSE
1024: ,x_return_status => l_return_status
1025: ,x_errorcode => l_errorcode
1026: ,x_msg_count => l_msg_count

Line 1023: ,p_commit => fnd_api.g_FALSE

1019: ,p_mapped_uom_parameter => c_src_func_mappings_rec.MAPPED_UOM_PARAMETER
1020: ,p_value_uom_source => c_src_func_mappings_rec.VALUE_UOM_SOURCE
1021: ,p_fixed_uom => c_src_func_mappings_rec.FIXED_UOM
1022: ,p_init_msg_list => fnd_api.g_FALSE
1023: ,p_commit => fnd_api.g_FALSE
1024: ,x_return_status => l_return_status
1025: ,x_errorcode => l_errorcode
1026: ,x_msg_count => l_msg_count
1027: ,x_msg_data => l_msg_data);

Line 1063: WHEN FND_API.G_EXC_ERROR THEN

1059: END IF;
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');

Line 1067: 'Leaving copy_uda_actions: FND_API.G_EXC_ERROR 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;
1070: FND_MSG_PUB.Count_And_Get(
1071: p_count => x_msg_count,

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1070: FND_MSG_PUB.Count_And_Get(
1071: p_count => x_msg_count,
1072: p_data => x_msg_data
1073: );

Line 1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1070: FND_MSG_PUB.Count_And_Get(
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');

Line 1078: 'Leaving copy_uda_actions: FND_API.G_EXC_UNEXPECTED_ERROR Exception');

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;
1081: FND_MSG_PUB.Count_And_Get(
1082: p_count => x_msg_count,

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1081: FND_MSG_PUB.Count_And_Get(
1082: p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );

Line 1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1093: p_token1 => G_SQLCODE_TOKEN,
1094: p_token1_value => sqlcode,
1095: p_token2 => G_SQLERRM_TOKEN,
1096: p_token2_value => sqlerrm);
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: FND_MSG_PUB.Count_And_Get(
1099: p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );

Line 1151: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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
1152: FND_MSG_PUB.initialize;
1153: END IF;
1154:
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1155: x_return_status := FND_API.G_RET_STS_SUCCESS;

1151: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1152: FND_MSG_PUB.initialize;
1153: END IF;
1154:
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156:
1157: FOR c_get_pages_csr_rec IN c_get_pages_csr LOOP
1158:
1159: EGO_EXT_FWK_PUB.Create_Page

Line 1169: ,p_init_msg_list => fnd_api.g_FALSE

1165: ,p_internal_name => c_get_pages_csr_rec.internal_name
1166: ,p_display_name => c_get_pages_csr_rec.display_name
1167: ,p_description => c_get_pages_csr_rec.description
1168: ,p_sequence => c_get_pages_csr_rec.sequence
1169: ,p_init_msg_list => fnd_api.g_FALSE
1170: ,p_commit => fnd_api.g_FALSE
1171: ,x_page_id => l_create_page_id
1172: ,x_return_status => x_return_status
1173: ,x_errorcode => l_errorcode

Line 1170: ,p_commit => fnd_api.g_FALSE

1166: ,p_display_name => c_get_pages_csr_rec.display_name
1167: ,p_description => c_get_pages_csr_rec.description
1168: ,p_sequence => c_get_pages_csr_rec.sequence
1169: ,p_init_msg_list => fnd_api.g_FALSE
1170: ,p_commit => fnd_api.g_FALSE
1171: ,x_page_id => l_create_page_id
1172: ,x_return_status => x_return_status
1173: ,x_errorcode => l_errorcode
1174: ,x_msg_count => x_msg_count

Line 1202: RAISE FND_API.G_EXC_ERROR;

1198: AND assoc.ATTR_GROUP_ID = c_get_page_entries_csr_rec.attr_group_id;
1199:
1200: EXCEPTION
1201: WHEN No_Data_Found THEN
1202: RAISE FND_API.G_EXC_ERROR;
1203: END;
1204:
1205: EGO_EXT_FWK_PUB.Create_Page_Entry
1206: (

Line 1212: ,p_init_msg_list => fnd_api.g_FALSE

1208: ,p_page_id => l_create_page_id
1209: ,p_association_id => l_association_id
1210: ,p_sequence => c_get_page_entries_csr_rec.sequence
1211: ,p_classification_code => p_new_template_code
1212: ,p_init_msg_list => fnd_api.g_FALSE
1213: ,p_commit => fnd_api.g_FALSE
1214: ,x_return_status => x_return_status
1215: ,x_errorcode => l_errorcode
1216: ,x_msg_count => x_msg_count

Line 1213: ,p_commit => fnd_api.g_FALSE

1209: ,p_association_id => l_association_id
1210: ,p_sequence => c_get_page_entries_csr_rec.sequence
1211: ,p_classification_code => p_new_template_code
1212: ,p_init_msg_list => fnd_api.g_FALSE
1213: ,p_commit => fnd_api.g_FALSE
1214: ,x_return_status => x_return_status
1215: ,x_errorcode => l_errorcode
1216: ,x_msg_count => x_msg_count
1217: ,x_msg_data => x_msg_data

Line 1244: WHEN FND_API.G_EXC_ERROR THEN

1240: END IF;
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');

Line 1248: 'Leaving copy_pages: FND_API.G_EXC_ERROR 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;
1251: FND_MSG_PUB.Count_And_Get(
1252: p_count => x_msg_count,

Line 1250: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1251: FND_MSG_PUB.Count_And_Get(
1252: p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );

Line 1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1251: FND_MSG_PUB.Count_And_Get(
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');

Line 1259: 'Leaving copy_pages: FND_API.G_EXC_UNEXPECTED_ERROR Exception');

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;
1262: FND_MSG_PUB.Count_And_Get(
1263: p_count => x_msg_count,

Line 1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1262: FND_MSG_PUB.Count_And_Get(
1263: p_count => x_msg_count,
1264: p_data => x_msg_data
1265: );

Line 1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1274: p_token1 => G_SQLCODE_TOKEN,
1275: p_token1_value => sqlcode,
1276: p_token2 => G_SQLERRM_TOKEN,
1277: p_token2_value => sqlerrm);
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279: FND_MSG_PUB.Count_And_Get(
1280: p_count => x_msg_count,
1281: p_data => x_msg_data
1282: );

Line 1324: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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
1325: FND_MSG_PUB.initialize;
1326: END IF;
1327:
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1328: x_return_status := FND_API.G_RET_STS_SUCCESS;

1324: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1325: FND_MSG_PUB.initialize;
1326: END IF;
1327:
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329:
1330: -- Standard Start of API savepoint
1331: SAVEPOINT copy_temp_details_PVT;
1332:

Line 1386: p_init_msg_list => FND_API.G_FALSE,

1382: --copy associations
1383: --This will inturn copy actions and action mappings
1384:
1385: copy_associations(p_api_version => 1.0,
1386: p_init_msg_list => FND_API.G_FALSE,
1387: p_commit => FND_API.G_FALSE,
1388: p_new_template_code => l_new_template_code,
1389: p_src_template_code => l_src_template_code,
1390: p_object_id => l_object_id,

Line 1387: p_commit => FND_API.G_FALSE,

1383: --This will inturn copy actions and action mappings
1384:
1385: copy_associations(p_api_version => 1.0,
1386: p_init_msg_list => FND_API.G_FALSE,
1387: p_commit => FND_API.G_FALSE,
1388: p_new_template_code => l_new_template_code,
1389: p_src_template_code => l_src_template_code,
1390: p_object_id => l_object_id,
1391: x_return_status => x_return_status,

Line 1411: p_init_msg_list => FND_API.G_FALSE,

1407:
1408: --copy pages
1409:
1410: copy_pages (p_api_version => 1.0,
1411: p_init_msg_list => FND_API.G_FALSE,
1412: p_commit => FND_API.G_FALSE,
1413: p_new_template_code => l_new_template_code,
1414: p_src_template_code => l_src_template_code,
1415: p_object_id => l_object_id,

Line 1412: p_commit => FND_API.G_FALSE,

1408: --copy pages
1409:
1410: copy_pages (p_api_version => 1.0,
1411: p_init_msg_list => FND_API.G_FALSE,
1412: p_commit => FND_API.G_FALSE,
1413: p_new_template_code => l_new_template_code,
1414: p_src_template_code => l_src_template_code,
1415: p_object_id => l_object_id,
1416: x_return_status => x_return_status,

Line 1442: WHEN FND_API.G_EXC_ERROR THEN

1438: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
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');

Line 1446: 'Leaving copy_template_details: FND_API.G_EXC_ERROR 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:
1449: ROLLBACK TO copy_temp_details_PVT;
1450:

Line 1451: x_return_status := FND_API.G_RET_STS_ERROR;

1447: END IF;
1448:
1449: ROLLBACK TO copy_temp_details_PVT;
1450:
1451: x_return_status := FND_API.G_RET_STS_ERROR;
1452: FND_MSG_PUB.Count_And_Get(
1453: p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );

Line 1456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1452: FND_MSG_PUB.Count_And_Get(
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');

Line 1460: 'Leaving copy_template_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');

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;
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: FND_MSG_PUB.Count_And_Get(

Line 1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: FND_MSG_PUB.Count_And_Get(
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1477: p_token1 => G_SQLCODE_TOKEN,
1478: p_token1_value => sqlcode,
1479: p_token2 => G_SQLERRM_TOKEN,
1480: p_token2_value => sqlerrm);
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get(
1483: p_count => x_msg_count,
1484: p_data => x_msg_data
1485: );

Line 1558: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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
1559: FND_MSG_PUB.initialize;
1560: END IF;
1561:
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1562: x_return_status := FND_API.G_RET_STS_SUCCESS;

1558: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1559: FND_MSG_PUB.initialize;
1560: END IF;
1561:
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;
1563:
1564: -- Standard Start of API savepoint
1565: SAVEPOINT del_temp_details_PVT;
1566:

Line 1599: ,p_init_msg_list => fnd_api.g_FALSE

1595: EGO_EXT_FWK_PUB.DELETE_PAGE
1596: (
1597: p_api_version => 1.0
1598: ,p_page_id => c_pages_rec.page_id
1599: ,p_init_msg_list => fnd_api.g_FALSE
1600: ,p_commit => fnd_api.g_FALSE
1601: ,x_return_status => x_return_status
1602: ,x_errorcode => l_errorcode
1603: ,x_msg_count => x_msg_count

Line 1600: ,p_commit => fnd_api.g_FALSE

1596: (
1597: p_api_version => 1.0
1598: ,p_page_id => c_pages_rec.page_id
1599: ,p_init_msg_list => fnd_api.g_FALSE
1600: ,p_commit => fnd_api.g_FALSE
1601: ,x_return_status => x_return_status
1602: ,x_errorcode => l_errorcode
1603: ,x_msg_count => x_msg_count
1604: ,x_msg_data => x_msg_data

Line 1630: p_init_msg_list => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE

1626: --deleting assiociations from ego tables.
1627: ego_ext_fwk_pub.Delete_Association(
1628: p_api_version => 1.0, -- IN NUMBER
1629: p_association_id => association_ids_rec.association_id, -- IN NUMBER
1630: p_init_msg_list => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1631: p_commit => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1632: p_force => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1633: x_return_status => x_return_status, -- OUT NOCOPY VARCHAR2
1634: x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER

Line 1631: p_commit => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE

1627: ego_ext_fwk_pub.Delete_Association(
1628: p_api_version => 1.0, -- IN NUMBER
1629: p_association_id => association_ids_rec.association_id, -- IN NUMBER
1630: p_init_msg_list => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1631: p_commit => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1632: p_force => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1633: x_return_status => x_return_status, -- OUT NOCOPY VARCHAR2
1634: x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1635: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER

Line 1632: p_force => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE

1628: p_api_version => 1.0, -- IN NUMBER
1629: p_association_id => association_ids_rec.association_id, -- IN NUMBER
1630: p_init_msg_list => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1631: p_commit => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1632: p_force => fnd_api.g_FALSE, -- IN VARCHAR2 := fnd_api.g_FALSE
1633: x_return_status => x_return_status, -- OUT NOCOPY VARCHAR2
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

Line 1659: ,p_init_msg_list => fnd_api.g_FALSE

1655:
1656: ego_ext_fwk_pub.Delete_Action (
1657: p_api_version => 1.0
1658: ,p_action_id => c_get_action_id_rec.action_id
1659: ,p_init_msg_list => fnd_api.g_FALSE
1660: ,p_commit => fnd_api.g_FALSE
1661: ,x_return_status => x_return_status
1662: ,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1663: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER

Line 1660: ,p_commit => fnd_api.g_FALSE

1656: ego_ext_fwk_pub.Delete_Action (
1657: p_api_version => 1.0
1658: ,p_action_id => c_get_action_id_rec.action_id
1659: ,p_init_msg_list => fnd_api.g_FALSE
1660: ,p_commit => fnd_api.g_FALSE
1661: ,x_return_status => x_return_status
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);

Line 1684: ,p_init_msg_list => fnd_api.g_FALSE

1680:
1681: ego_ext_fwk_pub.Delete_Action_Display (
1682: p_api_version => 1.0
1683: ,p_action_id => c_get_action_id_rec.action_id
1684: ,p_init_msg_list => fnd_api.g_FALSE
1685: ,p_commit => fnd_api.g_FALSE
1686: ,x_return_status => x_return_status
1687: ,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1688: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER

Line 1685: ,p_commit => fnd_api.g_FALSE

1681: ego_ext_fwk_pub.Delete_Action_Display (
1682: p_api_version => 1.0
1683: ,p_action_id => c_get_action_id_rec.action_id
1684: ,p_init_msg_list => fnd_api.g_FALSE
1685: ,p_commit => fnd_api.g_FALSE
1686: ,x_return_status => x_return_status
1687: ,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1688: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER
1689: x_msg_data => x_msg_data);

Line 1713: ,p_init_msg_list => fnd_api.g_FALSE

1709: p_api_version => 1.0
1710: ,p_function_id => c_get_action_id_rec.function_id
1711: ,p_mapped_obj_type => 'A' -- hardcoded to 'A'
1712: ,p_mapped_obj_pk1_value => c_get_action_id_rec.action_id
1713: ,p_init_msg_list => fnd_api.g_FALSE
1714: ,p_commit => fnd_api.g_FALSE
1715: ,x_return_status => x_return_status
1716: ,x_errorcode => l_errorcode, -- OUT NOCOPY NUMBER
1717: x_msg_count => x_msg_count, -- OUT NOCOPY NUMBER

Line 1714: ,p_commit => fnd_api.g_FALSE

1710: ,p_function_id => c_get_action_id_rec.function_id
1711: ,p_mapped_obj_type => 'A' -- hardcoded to 'A'
1712: ,p_mapped_obj_pk1_value => c_get_action_id_rec.action_id
1713: ,p_init_msg_list => fnd_api.g_FALSE
1714: ,p_commit => fnd_api.g_FALSE
1715: ,x_return_status => x_return_status
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);

Line 1745: WHEN FND_API.G_EXC_ERROR THEN

1741: 'Leaving OKC_UDA_TEMPLATES_UTIL.'||l_api_name);
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');

Line 1749: 'Leaving delete_temp_details: FND_API.G_EXC_ERROR 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:
1752: ROLLBACK TO del_temp_details_PVT;
1753:

Line 1754: x_return_status := FND_API.G_RET_STS_ERROR;

1750: END IF;
1751:
1752: ROLLBACK TO del_temp_details_PVT;
1753:
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: FND_MSG_PUB.Count_And_Get(
1756: p_count => x_msg_count,
1757: p_data => x_msg_data
1758: );

Line 1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1755: FND_MSG_PUB.Count_And_Get(
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');

Line 1763: 'Leaving delete_temp_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');

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;
1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1767: FND_MSG_PUB.Count_And_Get(

Line 1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1767: FND_MSG_PUB.Count_And_Get(
1768: p_count => x_msg_count,
1769: p_data => x_msg_data
1770: );

Line 1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1780: p_token1 => G_SQLCODE_TOKEN,
1781: p_token1_value => sqlcode,
1782: p_token2 => G_SQLERRM_TOKEN,
1783: p_token2_value => sqlerrm);
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_count => x_msg_count,
1787: p_data => x_msg_data
1788: );