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.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FND_API

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

196: --
197: -------------------------------------------------------------------------------
198: PROCEDURE Remove_Results(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
202: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,

Line 201: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

197: -------------------------------------------------------------------------------
198: PROCEDURE Remove_Results(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
202: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,

Line 202: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,

198: PROCEDURE Remove_Results(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
202: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_preview_obj_def_id IN NUMBER)

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: p_msg_text => 'Begin Procedure');
241: END IF;
242:
243: -- Initialize return status to unexpected error
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245:
246: -- Check for call compatibility.
247: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
248: p_api_version,

Line 247: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

243: -- Initialize return status to unexpected error
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245:
246: -- Check for call compatibility.
247: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
248: p_api_version,
249: C_API_NAME,
250: G_PKG_NAME)
251: THEN

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION
257: ||') not compatible with '
258: ||'passed in version ('||p_api_version||')');
259: END IF;
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262:
263: -- Initialize FND message queue
264: IF p_init_msg_list = FND_API.G_TRUE then

Line 264: IF p_init_msg_list = FND_API.G_TRUE then

260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: END IF;
262:
263: -- Initialize FND message queue
264: IF p_init_msg_list = FND_API.G_TRUE then
265: FND_MSG_PUB.Initialize;
266: END IF;
267:
268: -- Log procedure param values

Line 301: p_init_msg_list => FND_API.G_FALSE,

297:
298: -- Remove process locks and temporary tables created by Preview execution
299: FEM_UD_PKG.Remove_Process_Locks(
300: p_api_version => 1.0,
301: p_init_msg_list => FND_API.G_FALSE,
302: p_commit => FND_API.G_FALSE,
303: p_encoded => p_encoded,
304: x_return_status => x_return_status,
305: x_msg_count => x_msg_count,

Line 302: p_commit => FND_API.G_FALSE,

298: -- Remove process locks and temporary tables created by Preview execution
299: FEM_UD_PKG.Remove_Process_Locks(
300: p_api_version => 1.0,
301: p_init_msg_list => FND_API.G_FALSE,
302: p_commit => FND_API.G_FALSE,
303: p_encoded => p_encoded,
304: x_return_status => x_return_status,
305: x_msg_count => x_msg_count,
306: x_msg_data => x_msg_data,

Line 310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

306: x_msg_data => x_msg_data,
307: p_request_id => prvw_execs.request_id,
308: p_object_id => v_preview_obj_id);
309:
310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
311: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
312: FEM_ENGINES_PKG.TECH_MESSAGE(
313: p_severity => FND_LOG.level_unexpected,
314: p_module => C_MODULE,

Line 356: x_return_status := FND_API.G_RET_STS_SUCCESS;

352: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,
353: p_count => x_msg_count,
354: p_data => x_msg_data);
355:
356: x_return_status := FND_API.G_RET_STS_SUCCESS;
357:
358: IF (p_commit = FND_API.G_TRUE) THEN
359: COMMIT;
360: END IF;

Line 358: IF (p_commit = FND_API.G_TRUE) THEN

354: p_data => x_msg_data);
355:
356: x_return_status := FND_API.G_RET_STS_SUCCESS;
357:
358: IF (p_commit = FND_API.G_TRUE) THEN
359: COMMIT;
360: END IF;
361:
362: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,
401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: --
406: END Remove_Results;
407: -------------------------------------------------------------------------------
408:

Line 428: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

424: --
425: -------------------------------------------------------------------------------
426: PROCEDURE Pre_Process(
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
429: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
430: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,

Line 429: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

425: -------------------------------------------------------------------------------
426: PROCEDURE Pre_Process(
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
429: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
430: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,
433: x_msg_data OUT NOCOPY VARCHAR2,

Line 430: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,

426: PROCEDURE Pre_Process(
427: p_api_version IN NUMBER,
428: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
429: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
430: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,
433: x_msg_data OUT NOCOPY VARCHAR2,
434: p_preview_obj_def_id IN NUMBER,

Line 481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

477: p_msg_text => 'Begin Procedure');
478: END IF;
479:
480: -- Initialize return status to unexpected error
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: -- Check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
485: p_api_version,

Line 484: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

480: -- Initialize return status to unexpected error
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: -- Check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
485: p_api_version,
486: C_API_NAME,
487: G_PKG_NAME)
488: THEN

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION
494: ||') not compatible with '
495: ||'passed in version ('||p_api_version||')');
496: END IF;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: -- Initialize FND message queue
501: IF p_init_msg_list = FND_API.G_TRUE then

Line 501: IF p_init_msg_list = FND_API.G_TRUE then

497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: -- Initialize FND message queue
501: IF p_init_msg_list = FND_API.G_TRUE then
502: FND_MSG_PUB.Initialize;
503: END IF;
504:
505: -- Log procedure param values

Line 560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

556: p_severity => FND_LOG.level_unexpected,
557: p_module => C_MODULE,
558: p_msg_text => 'Preview does not support Factor Table rules!');
559: END IF;
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562:
563: -- Counter for number of temp objects being created
564: v_temp_table_seq := 0;

Line 680: x_return_status := FND_API.G_RET_STS_SUCCESS;

676: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,
677: p_count => x_msg_count,
678: p_data => x_msg_data);
679:
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682: IF (p_commit = FND_API.G_TRUE) THEN
683: COMMIT;
684: END IF;

Line 682: IF (p_commit = FND_API.G_TRUE) THEN

678: p_data => x_msg_data);
679:
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682: IF (p_commit = FND_API.G_TRUE) THEN
683: COMMIT;
684: END IF;
685:
686: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

720: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,
721: p_count => x_msg_count,
722: p_data => x_msg_data);
723:
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
725: --
726: END Pre_Process;
727: -------------------------------------------------------------------------------
728:

Line 746: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

742: --
743: -------------------------------------------------------------------------------
744: PROCEDURE Post_Process(
745: p_api_version IN NUMBER,
746: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
747: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
748: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,

Line 747: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

743: -------------------------------------------------------------------------------
744: PROCEDURE Post_Process(
745: p_api_version IN NUMBER,
746: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
747: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
748: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,

Line 748: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,

744: PROCEDURE Post_Process(
745: p_api_version IN NUMBER,
746: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
747: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
748: p_encoded IN VARCHAR2 DEFAULT FND_API.G_TRUE,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: p_preview_obj_def_id IN NUMBER,

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

785: p_msg_text => 'Begin Procedure');
786: END IF;
787:
788: -- Initialize return status to unexpected error
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790:
791: -- Check for call compatibility.
792: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
793: p_api_version,

Line 792: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,

788: -- Initialize return status to unexpected error
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790:
791: -- Check for call compatibility.
792: IF NOT FND_API.Compatible_API_Call (C_API_VERSION,
793: p_api_version,
794: C_API_NAME,
795: G_PKG_NAME)
796: THEN

Line 805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

801: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION
802: ||') not compatible with '
803: ||'passed in version ('||p_api_version||')');
804: END IF;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: -- Initialize FND message queue
809: IF p_init_msg_list = FND_API.G_TRUE then

Line 809: IF p_init_msg_list = FND_API.G_TRUE then

805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: -- Initialize FND message queue
809: IF p_init_msg_list = FND_API.G_TRUE then
810: FND_MSG_PUB.Initialize;
811: END IF;
812:
813: -- Log procedure param values

Line 881: x_return_status := FND_API.G_RET_STS_SUCCESS;

877: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,
878: p_count => x_msg_count,
879: p_data => x_msg_data);
880:
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882:
883: IF (p_commit = FND_API.G_TRUE) THEN
884: COMMIT;
885: END IF;

Line 883: IF (p_commit = FND_API.G_TRUE) THEN

879: p_data => x_msg_data);
880:
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882:
883: IF (p_commit = FND_API.G_TRUE) THEN
884: COMMIT;
885: END IF;
886:
887: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

921: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,
922: p_count => x_msg_count,
923: p_data => x_msg_data);
924:
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: --
927: END Post_Process;
928: -------------------------------------------------------------------------------
929:

Line 1018: p_init_msg_list => FND_API.G_FALSE,

1014:
1015: -- First get a unique temp table name
1016: FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name(
1017: p_api_version => 1.0,
1018: p_init_msg_list => FND_API.G_FALSE,
1019: p_commit => FND_API.G_FALSE,
1020: p_encoded => FND_API.G_TRUE,
1021: x_return_status => v_return_status,
1022: x_msg_count => v_msg_count,

Line 1019: p_commit => FND_API.G_FALSE,

1015: -- First get a unique temp table name
1016: FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name(
1017: p_api_version => 1.0,
1018: p_init_msg_list => FND_API.G_FALSE,
1019: p_commit => FND_API.G_FALSE,
1020: p_encoded => FND_API.G_TRUE,
1021: x_return_status => v_return_status,
1022: x_msg_count => v_msg_count,
1023: x_msg_data => v_msg_data,

Line 1020: p_encoded => FND_API.G_TRUE,

1016: FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name(
1017: p_api_version => 1.0,
1018: p_init_msg_list => FND_API.G_FALSE,
1019: p_commit => FND_API.G_FALSE,
1020: p_encoded => FND_API.G_TRUE,
1021: x_return_status => v_return_status,
1022: x_msg_count => v_msg_count,
1023: x_msg_data => v_msg_data,
1024: p_temp_type => 'TABLE',

Line 1030: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1026: p_object_id => p_preview_obj_id,
1027: p_table_seq => p_temp_table_seq,
1028: x_temp_name => x_temp_table_name);
1029:
1030: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1031: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1032: FEM_ENGINES_PKG.TECH_MESSAGE(
1033: p_severity => FND_LOG.level_unexpected,
1034: p_module => C_MODULE,

Line 1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1036: ||' FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name'
1037: ||' failed with return status: '||v_return_status);
1038: END IF;
1039:
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: END IF;
1042:
1043: -- Then build the SQL to create the temporary SQL
1044: GetSelectClause(

Line 1072: p_init_msg_list => FND_API.G_FALSE,

1068:
1069: -- Create the temp table
1070: FEM_DATABASE_UTIL_PKG.Create_Temp_Table(
1071: p_api_version => 1.0,
1072: p_init_msg_list => FND_API.G_FALSE,
1073: p_commit => FND_API.G_FALSE,
1074: p_encoded => FND_API.G_TRUE,
1075: x_return_status => v_return_status,
1076: x_msg_count => v_msg_count,

Line 1073: p_commit => FND_API.G_FALSE,

1069: -- Create the temp table
1070: FEM_DATABASE_UTIL_PKG.Create_Temp_Table(
1071: p_api_version => 1.0,
1072: p_init_msg_list => FND_API.G_FALSE,
1073: p_commit => FND_API.G_FALSE,
1074: p_encoded => FND_API.G_TRUE,
1075: x_return_status => v_return_status,
1076: x_msg_count => v_msg_count,
1077: x_msg_data => v_msg_data,

Line 1074: p_encoded => FND_API.G_TRUE,

1070: FEM_DATABASE_UTIL_PKG.Create_Temp_Table(
1071: p_api_version => 1.0,
1072: p_init_msg_list => FND_API.G_FALSE,
1073: p_commit => FND_API.G_FALSE,
1074: p_encoded => FND_API.G_TRUE,
1075: x_return_status => v_return_status,
1076: x_msg_count => v_msg_count,
1077: x_msg_data => v_msg_data,
1078: p_request_id => p_request_id,

Line 1085: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1081: p_table_name => x_temp_table_name,
1082: p_table_def => 'AS '||v_select_clause||' '
1083: ||v_from_clause||' '||v_where_clause);
1084:
1085: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1086: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1087: FEM_ENGINES_PKG.TECH_MESSAGE(
1088: p_severity => FND_LOG.level_unexpected,
1089: p_module => C_MODULE,

Line 1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1091: ||' FEM_DATABASE_UTIL_PKG.Create_Temp_Table'
1092: ||' failed with return status: '||v_return_status);
1093: END IF;
1094:
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: END IF;
1097:
1098: -- First see if there are any index columns
1099: FOR index_col IN c_index_cols(cv_table_name => p_fact_table_name) LOOP

Line 1112: p_init_msg_list => FND_API.G_FALSE,

1108:
1109: -- Get a unique temp index name before creating it
1110: FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name(
1111: p_api_version => 1.0,
1112: p_init_msg_list => FND_API.G_FALSE,
1113: p_commit => FND_API.G_FALSE,
1114: p_encoded => FND_API.G_TRUE,
1115: x_return_status => v_return_status,
1116: x_msg_count => v_msg_count,

Line 1113: p_commit => FND_API.G_FALSE,

1109: -- Get a unique temp index name before creating it
1110: FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name(
1111: p_api_version => 1.0,
1112: p_init_msg_list => FND_API.G_FALSE,
1113: p_commit => FND_API.G_FALSE,
1114: p_encoded => FND_API.G_TRUE,
1115: x_return_status => v_return_status,
1116: x_msg_count => v_msg_count,
1117: x_msg_data => v_msg_data,

Line 1114: p_encoded => FND_API.G_TRUE,

1110: FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name(
1111: p_api_version => 1.0,
1112: p_init_msg_list => FND_API.G_FALSE,
1113: p_commit => FND_API.G_FALSE,
1114: p_encoded => FND_API.G_TRUE,
1115: x_return_status => v_return_status,
1116: x_msg_count => v_msg_count,
1117: x_msg_data => v_msg_data,
1118: p_temp_type => 'INDEX',

Line 1124: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1120: p_object_id => p_preview_obj_id,
1121: p_table_seq => p_temp_table_seq,
1122: x_temp_name => v_index_name);
1123:
1124: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1125: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1126: FEM_ENGINES_PKG.TECH_MESSAGE(
1127: p_severity => FND_LOG.level_unexpected,
1128: p_module => C_MODULE,

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130: ||' FEM_DATABASE_UTIL_PKG.Get_Unique_Temp_Name'
1131: ||' failed with return status: '||v_return_status);
1132: END IF;
1133:
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: FEM_DATABASE_UTIL_PKG.Create_Temp_Index(
1138: p_api_version => 1.0,

Line 1139: p_init_msg_list => FND_API.G_FALSE,

1135: END IF;
1136:
1137: FEM_DATABASE_UTIL_PKG.Create_Temp_Index(
1138: p_api_version => 1.0,
1139: p_init_msg_list => FND_API.G_FALSE,
1140: p_commit => FND_API.G_FALSE,
1141: p_encoded => FND_API.G_TRUE,
1142: x_return_status => v_return_status,
1143: x_msg_count => v_msg_count,

Line 1140: p_commit => FND_API.G_FALSE,

1136:
1137: FEM_DATABASE_UTIL_PKG.Create_Temp_Index(
1138: p_api_version => 1.0,
1139: p_init_msg_list => FND_API.G_FALSE,
1140: p_commit => FND_API.G_FALSE,
1141: p_encoded => FND_API.G_TRUE,
1142: x_return_status => v_return_status,
1143: x_msg_count => v_msg_count,
1144: x_msg_data => v_msg_data,

Line 1141: p_encoded => FND_API.G_TRUE,

1137: FEM_DATABASE_UTIL_PKG.Create_Temp_Index(
1138: p_api_version => 1.0,
1139: p_init_msg_list => FND_API.G_FALSE,
1140: p_commit => FND_API.G_FALSE,
1141: p_encoded => FND_API.G_TRUE,
1142: x_return_status => v_return_status,
1143: x_msg_count => v_msg_count,
1144: x_msg_data => v_msg_data,
1145: p_request_id => p_request_id,

Line 1153: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1149: p_index_name => v_index_name,
1150: p_index_columns => v_index_columns,
1151: p_unique_flag => 'Y');
1152:
1153: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1154: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1155: FEM_ENGINES_PKG.TECH_MESSAGE(
1156: p_severity => FND_LOG.level_unexpected,
1157: p_module => C_MODULE,

Line 1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1159: ||' FEM_DATABASE_UTIL_PKG.Create_Temp_Index'
1160: ||' failed with return status: '||v_return_status);
1161: END IF;
1162:
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164: END IF;
1165:
1166: END IF; -- IF v_index_columns IS NOT NULL
1167:

Line 1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1628: p_severity => FND_LOG.level_unexpected,
1629: p_module => C_MODULE,
1630: p_msg_text => 'x_output_match_temp_table should NOT be NULL!');
1631: END IF;
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: END IF;
1634:
1635: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1636: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1815: p_init_msg_list => FND_API.G_FALSE,

1811: p_fact_table_name => p_fact_table_name,
1812: p_table_alias => G_FACT_ALIAS,
1813: p_Ledger_Flag => 'N',
1814: p_api_version => 1.0,
1815: p_init_msg_list => FND_API.G_FALSE,
1816: p_commit => FND_API.G_FALSE,
1817: p_encoded => FND_API.G_TRUE);
1818:
1819: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1816: p_commit => FND_API.G_FALSE,

1812: p_table_alias => G_FACT_ALIAS,
1813: p_Ledger_Flag => 'N',
1814: p_api_version => 1.0,
1815: p_init_msg_list => FND_API.G_FALSE,
1816: p_commit => FND_API.G_FALSE,
1817: p_encoded => FND_API.G_TRUE);
1818:
1819: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1820: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1817: p_encoded => FND_API.G_TRUE);

1813: p_Ledger_Flag => 'N',
1814: p_api_version => 1.0,
1815: p_init_msg_list => FND_API.G_FALSE,
1816: p_commit => FND_API.G_FALSE,
1817: p_encoded => FND_API.G_TRUE);
1818:
1819: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1820: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1821: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 1819: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1815: p_init_msg_list => FND_API.G_FALSE,
1816: p_commit => FND_API.G_FALSE,
1817: p_encoded => FND_API.G_TRUE);
1818:
1819: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1820: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1821: FEM_ENGINES_PKG.TECH_MESSAGE(
1822: p_severity => FND_LOG.level_statement,
1823: p_module => C_MODULE,

Line 1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1828: END IF;
1829:
1830: -- Assembler API should always generate some WHERE clause
1831: IF x_where_clause IS NULL THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834:
1835: ELSE
1836: -- If the table is a Statistic table and the row group is DRIVER,

Line 1873: p_init_msg_list => FND_API.G_FALSE,

1869:
1870: IF v_stat_cond_obj_def_id IS NOT NULL THEN
1871: FEM_CONDITIONS_API.generate_condition_predicate(
1872: p_api_version => 1.0,
1873: p_init_msg_list => FND_API.G_FALSE,
1874: p_commit => FND_API.G_FALSE,
1875: p_encoded => FND_API.G_TRUE,
1876: p_condition_obj_id => FEM_BUSINESS_RULE_PVT.GetObjectId(
1877: p_obj_def_id => v_stat_cond_obj_def_id),

Line 1874: p_commit => FND_API.G_FALSE,

1870: IF v_stat_cond_obj_def_id IS NOT NULL THEN
1871: FEM_CONDITIONS_API.generate_condition_predicate(
1872: p_api_version => 1.0,
1873: p_init_msg_list => FND_API.G_FALSE,
1874: p_commit => FND_API.G_FALSE,
1875: p_encoded => FND_API.G_TRUE,
1876: p_condition_obj_id => FEM_BUSINESS_RULE_PVT.GetObjectId(
1877: p_obj_def_id => v_stat_cond_obj_def_id),
1878: p_rule_effective_date => v_effective_date,

Line 1875: p_encoded => FND_API.G_TRUE,

1871: FEM_CONDITIONS_API.generate_condition_predicate(
1872: p_api_version => 1.0,
1873: p_init_msg_list => FND_API.G_FALSE,
1874: p_commit => FND_API.G_FALSE,
1875: p_encoded => FND_API.G_TRUE,
1876: p_condition_obj_id => FEM_BUSINESS_RULE_PVT.GetObjectId(
1877: p_obj_def_id => v_stat_cond_obj_def_id),
1878: p_rule_effective_date => v_effective_date,
1879: p_input_fact_table_name => p_fact_table_name,

Line 1889: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1885: x_msg_count => v_msg_count,
1886: x_msg_data => v_msg_data,
1887: x_predicate_string => v_condition_filter);
1888:
1889: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1890: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1891: FEM_ENGINES_PKG.TECH_MESSAGE(
1892: p_severity => FND_LOG.level_statement,
1893: p_module => C_MODULE,

Line 1904: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1900: -- the Condition API can return with error even if the issue
1901: -- is that a dimension/column does not exist on the table that
1902: -- the condition applied to. This is not an error condition from
1903: -- the CCE perspective.
1904: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: END IF;
1907: END IF;
1908:

Line 1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1901: -- is that a dimension/column does not exist on the table that
1902: -- the condition applied to. This is not an error condition from
1903: -- the CCE perspective.
1904: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: END IF;
1907: END IF;
1908:
1909: -- Only append if condition filter is not null

Line 1929: p_init_msg_list => FND_API.G_FALSE,

1925: -- Get if one exists
1926: IF v_preview_cond_obj_id IS NOT NULL THEN
1927: FEM_CONDITIONS_API.generate_condition_predicate(
1928: p_api_version => 1.0,
1929: p_init_msg_list => FND_API.G_FALSE,
1930: p_commit => FND_API.G_FALSE,
1931: p_encoded => FND_API.G_TRUE,
1932: p_condition_obj_id => v_preview_cond_obj_id,
1933: p_rule_effective_date => v_effective_date,

Line 1930: p_commit => FND_API.G_FALSE,

1926: IF v_preview_cond_obj_id IS NOT NULL THEN
1927: FEM_CONDITIONS_API.generate_condition_predicate(
1928: p_api_version => 1.0,
1929: p_init_msg_list => FND_API.G_FALSE,
1930: p_commit => FND_API.G_FALSE,
1931: p_encoded => FND_API.G_TRUE,
1932: p_condition_obj_id => v_preview_cond_obj_id,
1933: p_rule_effective_date => v_effective_date,
1934: p_input_fact_table_name => p_fact_table_name,

Line 1931: p_encoded => FND_API.G_TRUE,

1927: FEM_CONDITIONS_API.generate_condition_predicate(
1928: p_api_version => 1.0,
1929: p_init_msg_list => FND_API.G_FALSE,
1930: p_commit => FND_API.G_FALSE,
1931: p_encoded => FND_API.G_TRUE,
1932: p_condition_obj_id => v_preview_cond_obj_id,
1933: p_rule_effective_date => v_effective_date,
1934: p_input_fact_table_name => p_fact_table_name,
1935: p_table_alias => G_FACT_ALIAS,

Line 1944: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1940: x_msg_count => v_msg_count,
1941: x_msg_data => v_msg_data,
1942: x_predicate_string => v_condition_filter);
1943:
1944: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1945: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1946: FEM_ENGINES_PKG.TECH_MESSAGE(
1947: p_severity => FND_LOG.level_statement,
1948: p_module => C_MODULE,

Line 1959: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1955: -- the Condition API can return with error even if the issue
1956: -- is that a dimension/column does not exist on the table that
1957: -- the condition applied to. This is not an error condition from
1958: -- the CCE perspective.
1959: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962: END IF;
1963:

Line 1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1956: -- is that a dimension/column does not exist on the table that
1957: -- the condition applied to. This is not an error condition from
1958: -- the CCE perspective.
1959: IF v_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962: END IF;
1963:
1964: -- Only append if condition filter is not null

Line 2131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2127: p_module => C_MODULE,
2128: p_msg_text => 'Unsupported output table type: '||v_map_table_type);
2129: END IF;
2130:
2131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2132:
2133: END IF;
2134:
2135: -- Finally, add the WHERE keyword

Line 2393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2389: ||' FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'
2390: ||' to get LEDGER_FUNCTIONAL_CRNCY_CODE attribute'
2391: ||' information failed with return code: '||v_return_code);
2392: END IF;
2393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2394: END IF;
2395:
2396: SELECT dim_attribute_varchar_member
2397: INTO x_functional_currency

Line 2411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2407: p_module => C_MODULE,
2408: p_msg_text => 'Functional currency does not exist for the ledger'
2409: ||' id: '||p_ledger_id);
2410: END IF;
2411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2412: END IF;
2413:
2414: --
2415: -- Then get calendar period end date.

Line 2439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2435: ||' FEM_DIMENSION_UTIL_PKG.get_dim_attr_id_ver_id'
2436: ||' to get CAL_PERIOD_END_DATE attribute'
2437: ||' information failed with return code: '||v_return_code);
2438: END IF;
2439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2440: END IF;
2441:
2442: SELECT date_assign_value
2443: INTO v_cal_per_end_date

Line 2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2453: p_module => C_MODULE,
2454: p_msg_text => 'Calendar Period End Date does not exist for this'
2455: ||' calendar period: '||p_cal_period_id);
2456: END IF;
2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF;
2459:
2460: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2461: FEM_ENGINES_PKG.Tech_Message(

Line 2497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2493: p_module => C_MODULE,
2494: p_msg_text => 'Amount column is null for this preview group: '
2495: ||p_preview_row_group);
2496: END IF;
2497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2498: END IF;
2499:
2500: ELSE
2501:

Line 2509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2505: p_module => C_MODULE,
2506: p_msg_text => 'Unexpected table classification type: '
2507: ||p_map_table_type);
2508: END IF;
2509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2510:
2511: END IF; -- IF p_map_table_type = G_LEDGER_TYPE THEN
2512:
2513: --

Line 2813: (p_encoded => FND_API.G_FALSE,

2809: END IF;
2810:
2811: -- lookup the global value set combination id tied to the ledger
2812: v_global_vs_combo_id := FEM_DIMENSION_UTIL_PKG.global_vs_combo_id
2813: (p_encoded => FND_API.G_FALSE,
2814: x_return_status => v_return_status,
2815: x_msg_count => v_msg_count,
2816: x_msg_data => v_msg_data,
2817: p_ledger_id => p_ledger_id);

Line 2819: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2815: x_msg_count => v_msg_count,
2816: x_msg_data => v_msg_data,
2817: p_ledger_id => p_ledger_id);
2818:
2819: IF v_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2820: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2821: FEM_ENGINES_PKG.TECH_MESSAGE(
2822: p_severity => FND_LOG.level_statement,
2823: p_module => C_MODULE,