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.FII_FIN_CAT_MAINTAIN_PKG dependencies on FII_MESSAGE

Line 26: -- FII_MESSAGE.Func_Ent (func_name => 'Is_Table_Validated');

22:
23: BEGIN
24:
25: --if FIIDIM_Debug then
26: -- FII_MESSAGE.Func_Ent (func_name => 'Is_Table_Validated');
27: --end if;
28:
29: -- Execute statement to determine if the value set is table validated
30: BEGIN

Line 44: -- FII_MESSAGE.Func_Succ (func_name => 'Is_Table_Validated');

40: return FALSE;
41: END;
42:
43: --if FIIDIM_Debug then
44: -- FII_MESSAGE.Func_Succ (func_name => 'Is_Table_Validated');
45: --end if;
46:
47: RETURN TRUE;
48:

Line 64: -- FII_MESSAGE.Func_Ent (func_name => 'Get_Value_Set_Name');

60:
61: Begin
62:
63: -- if FIIDIM_Debug then
64: -- FII_MESSAGE.Func_Ent (func_name => 'Get_Value_Set_Name');
65: -- end if;
66:
67: select flex_value_set_name into l_vs_name
68: from fnd_flex_value_sets

Line 72: -- FII_MESSAGE.Func_Succ (func_name => 'Get_Value_Set_Name');

68: from fnd_flex_value_sets
69: where flex_value_set_id = p_vs_id;
70:
71: -- if FIIDIM_Debug then
72: -- FII_MESSAGE.Func_Succ (func_name => 'Get_Value_Set_Name');
73: -- end if;
74:
75: return l_vs_name;
76:

Line 97: -- FII_MESSAGE.Func_Ent (func_name => 'Get_Flex_Value');

93:
94: Begin
95:
96: -- if FIIDIM_Debug then
97: -- FII_MESSAGE.Func_Ent (func_name => 'Get_Flex_Value');
98: -- end if;
99:
100: select flex_value into l_flex_value
101: from fnd_flex_values

Line 105: -- FII_MESSAGE.Func_Succ (func_name => 'Get_Flex_Value');

101: from fnd_flex_values
102: where flex_value_id = p_flex_value_id;
103:
104: -- if FIIDIM_Debug then
105: -- FII_MESSAGE.Func_Succ (func_name => 'Get_Flex_Value');
106: -- end if;
107:
108: return l_flex_value;
109:

Line 257: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_VSET_NOT_FOUND',

253: FROM FII_FINANCIAL_DIMENSIONS
254: WHERE DIMENSION_SHORT_NAME = g_dimension_name;
255:
256: IF G_MASTER_VALUE_SET_ID is NULL THEN
257: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
258: token_num => 0);
259: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
260: token_num => 0);
261: RAISE FINDIM_fatal_err;

Line 259: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',

255:
256: IF G_MASTER_VALUE_SET_ID is NULL THEN
257: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
258: token_num => 0);
259: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
260: token_num => 0);
261: RAISE FINDIM_fatal_err;
262: ELSIF G_TOP_NODE_ID is NULL OR G_TOP_NODE_VALUE is NULL THEN
263: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_TNODE_NOT_FOUND',

Line 263: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_TNODE_NOT_FOUND',

259: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
260: token_num => 0);
261: RAISE FINDIM_fatal_err;
262: ELSIF G_TOP_NODE_ID is NULL OR G_TOP_NODE_VALUE is NULL THEN
263: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_TNODE_NOT_FOUND',
264: token_num => 0);
265: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_TNODE_NOT_FOUND',
266: token_num => 0);
267: RAISE FINDIM_fatal_err;

Line 265: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_TNODE_NOT_FOUND',

261: RAISE FINDIM_fatal_err;
262: ELSIF G_TOP_NODE_ID is NULL OR G_TOP_NODE_VALUE is NULL THEN
263: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_TNODE_NOT_FOUND',
264: token_num => 0);
265: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_TNODE_NOT_FOUND',
266: token_num => 0);
267: RAISE FINDIM_fatal_err;
268: END IF;
269:

Line 272: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_VSET_NOT_FOUND',

268: END IF;
269:
270: Exception
271: When NO_DATA_FOUND Then
272: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
273: token_num => 0);
274: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
275: token_num => 0);
276: RAISE FINDIM_fatal_err;

Line 274: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',

270: Exception
271: When NO_DATA_FOUND Then
272: FII_MESSAGE.write_log (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
273: token_num => 0);
274: FII_MESSAGE.write_output (msg_name => 'FII_MSTR_VSET_NOT_FOUND',
275: token_num => 0);
276: RAISE FINDIM_fatal_err;
277: When TOO_MANY_ROWS Then
278: FII_UTIL.Write_Log ('More than one master value set found for Financial Category Dimension');

Line 297: FII_MESSAGE.write_log (msg_name => 'FII_TBL_VALIDATED_VSET',

293: END IF;
294:
295: -- Check if the master value set is a table validated set.
296: If Is_Table_Validated (G_MASTER_VALUE_SET_ID) Then
297: FII_MESSAGE.write_log (msg_name => 'FII_TBL_VALIDATED_VSET',
298: token_num => 1,
299: t1 => 'VS_NAME',
300: v1 => Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
301: FII_MESSAGE.write_output (msg_name => 'FII_TBL_VALIDATED_VSET',

Line 301: FII_MESSAGE.write_output (msg_name => 'FII_TBL_VALIDATED_VSET',

297: FII_MESSAGE.write_log (msg_name => 'FII_TBL_VALIDATED_VSET',
298: token_num => 1,
299: t1 => 'VS_NAME',
300: v1 => Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
301: FII_MESSAGE.write_output (msg_name => 'FII_TBL_VALIDATED_VSET',
302: token_num => 1,
303: t1 => 'VS_NAME',
304: v1 => Get_Value_Set_Name (G_MASTER_VALUE_SET_ID));
305: RAISE FINDIM_fatal_err;

Line 327: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Initialize');

323: 'User defined error');
324: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
325: -- Rollback
326: FND_CONCURRENT.Af_Rollback;
327: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Initialize');
328: raise;
329:
330: When others then
331: FII_UTIL.Write_Log(

Line 366: FII_MESSAGE.Func_Ent ('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');

362:
363: BEGIN
364:
365: IF (FIIDIM_Debug) THEN
366: FII_MESSAGE.Func_Ent ('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
367: END IF;
368:
369: --First, copy table FII_DIM_NORM_HIERARCHY
370: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';

Line 436: FII_MESSAGE.write_log (msg_name => 'FII_TBL_VALIDATED_VSET',

432: l_vset_id := vset_rec.child_flex_value_set_id;
433:
434: -- Check if the (child) value set is a table validated set.
435: If Is_Table_Validated (l_vset_id) Then
436: FII_MESSAGE.write_log (msg_name => 'FII_TBL_VALIDATED_VSET',
437: token_num => 1,
438: t1 => 'VS_NAME',
439: v1 => Get_Value_Set_Name (l_vset_id));
440: FII_MESSAGE.write_output (msg_name => 'FII_TBL_VALIDATED_VSET',

Line 440: FII_MESSAGE.write_output (msg_name => 'FII_TBL_VALIDATED_VSET',

436: FII_MESSAGE.write_log (msg_name => 'FII_TBL_VALIDATED_VSET',
437: token_num => 1,
438: t1 => 'VS_NAME',
439: v1 => Get_Value_Set_Name (l_vset_id));
440: FII_MESSAGE.write_output (msg_name => 'FII_TBL_VALIDATED_VSET',
441: token_num => 1,
442: t1 => 'VS_NAME',
443: v1 => Get_Value_Set_Name (l_vset_id));
444: RAISE FINDIM_fatal_err;

Line 483: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');

479: 'User defined error');
480: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
481: -- Rollback
482: FND_CONCURRENT.Af_Rollback;
483: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
484: raise;
485:
486: When others then
487: FII_UTIL.Write_Log(

Line 534: FII_MESSAGE.Func_Ent ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape');

530:
531: BEGIN
532:
533: IF (FIIDIM_Debug) THEN
534: FII_MESSAGE.Func_Ent ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape');
535: END IF;
536:
537: -- check all value sets: if there is a diamond in any of them
538: -- (even values involved are not mapped for the dimension),

Line 547: FII_MESSAGE.write_log(msg_name => 'FII_DMND_SHAPE_VS_EXIST',

543:
544: l_count := l_count + 1;
545: if l_count = 1 then
546:
547: FII_MESSAGE.write_log(msg_name => 'FII_DMND_SHAPE_VS_EXIST',
548: token_num => 0);
549: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
550: token_num => 0);
551:

Line 549: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',

545: if l_count = 1 then
546:
547: FII_MESSAGE.write_log(msg_name => 'FII_DMND_SHAPE_VS_EXIST',
548: token_num => 0);
549: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
550: token_num => 0);
551:
552: FII_MESSAGE.write_output (msg_name => 'FII_DMND_SHAPE_VS_EXIST',
553: token_num => 0);

Line 552: FII_MESSAGE.write_output (msg_name => 'FII_DMND_SHAPE_VS_EXIST',

548: token_num => 0);
549: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
550: token_num => 0);
551:
552: FII_MESSAGE.write_output (msg_name => 'FII_DMND_SHAPE_VS_EXIST',
553: token_num => 0);
554: FII_MESSAGE.write_output (msg_name => 'FII_DMND_SHAPE_VS_TAB',
555: token_num => 0);
556:

Line 554: FII_MESSAGE.write_output (msg_name => 'FII_DMND_SHAPE_VS_TAB',

550: token_num => 0);
551:
552: FII_MESSAGE.write_output (msg_name => 'FII_DMND_SHAPE_VS_EXIST',
553: token_num => 0);
554: FII_MESSAGE.write_output (msg_name => 'FII_DMND_SHAPE_VS_TAB',
555: token_num => 0);
556:
557: end if;
558:

Line 577: FII_MESSAGE.Func_Succ ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape');

573:
574: END LOOP;
575:
576: IF (FIIDIM_Debug) THEN
577: FII_MESSAGE.Func_Succ ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape');
578: END IF;
579:
580: IF l_count > 0 THEN
581: RAISE FINDIM_MULT_PAR_err;

Line 626: -- FII_MESSAGE.Func_Ent ('FII_COM_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');

622: l_sort_order NUMBER(15);
623: BEGIN
624:
625: -- IF (FIIDIM_Debug) THEN
626: -- FII_MESSAGE.Func_Ent ('FII_COM_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
627: -- END IF;
628:
629: select flex_value_id, attribute_sort_order into l_flex_value_id, l_sort_order
630: from fnd_flex_values

Line 702: FII_MESSAGE.Func_Fail

698:
699: EXCEPTION
700: WHEN NO_DATA_FOUND Then
701: FII_UTIL.WRITE_LOG ('Insert Immediate child: No Data Found');
702: FII_MESSAGE.Func_Fail
703: (func_name =>
704: 'FII_DIMENSION_MAINTAIN_PKG.Fin_Insert_Imm_Child_Nodes');
705: RAISE;
706:

Line 709: FII_MESSAGE.Func_Fail

705: RAISE;
706:
707: WHEN OTHERS Then
708: FII_UTIL.WRITE_LOG( substr(SQLERRM,1,180));
709: FII_MESSAGE.Func_Fail
710: (func_name => 'FII_FIN_CAT_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');
711: RAISE;
712:
713: END INSERT_IMM_CHILD_NODES;

Line 728: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

724:
725: BEGIN
726:
727: IF (FIIDIM_Debug) THEN
728: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
729: 'Flatten_Fin_Dim_Hier');
730: END IF;
731:
732: g_phase := 'Truncate table FII_FIN_ITEM_HIER_GT';

Line 888: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

884: -- and next_level_is_leaf = 'Y';
885:
886:
887: IF (FIIDIM_Debug) THEN
888: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
889: 'Flatten_Fin_Dim_Hier');
890: END IF;
891:
892: EXCEPTION

Line 896: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

892: EXCEPTION
893:
894: WHEN NO_DATA_FOUND THEN
895: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: No Data Found');
896: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
897: 'Flatten_Fin_Dim_Hier');
898: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
899: raise;
900:

Line 903: FII_MESSAGE.Func_Fail (func_name =>

899: raise;
900:
901: WhEN FINDIM_MULT_PAR_err THEN
902: FII_UTIL.WRITE_LOG ('Flatten_Fin_Dim_Hier: Diamond Shape Detected');
903: FII_MESSAGE.Func_Fail (func_name =>
904: 'FII_DIMENSION_MAINTAIN_PKG.Flatten_Fin_Dim_Hier');
905: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
906: raise;
907:

Line 910: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

906: raise;
907:
908: WHEN OTHERS THEN
909: FII_UTIL.Write_Log('Flatten_Fin_Dim_Hier: '|| substr(sqlerrm,1,180));
910: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
911: 'Flatten_Fin_Dim_Hier');
912: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
913: raise;
914:

Line 925: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

921:
922: Begin
923:
924: IF (FIIDIM_Debug) THEN
925: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
926: 'Update_GT');
927: END IF;
928:
929: --Update the columns next_level_is_leaf, is_leaf_flag

Line 968: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

964: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows in fii_fin_item_hier_gt');
965: END IF;
966:
967: IF (FIIDIM_Debug) THEN
968: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
969: 'Update_GT');
970: END IF;
971:
972: EXCEPTION

Line 977: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

973:
974: WHEN OTHERS THEN
975: FII_UTIL.Write_Log ('Update_GT -> phase: '|| g_phase);
976: FII_UTIL.Write_Log ('Update_GT: '|| substr(sqlerrm,1,180));
977: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
978: 'Update_GT');
979: raise;
980:
981: END Update_GT;

Line 1057: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1053:
1054: Begin
1055:
1056: IF (FIIDIM_Debug) THEN
1057: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1058: 'Delete_LVS_Records');
1059: END IF;
1060:
1061: --Delete from FII_FIN_ITEM_HIER_GT for child value set not equal to

Line 1081: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1077:
1078: Update_Gt;
1079:
1080: IF (FIIDIM_Debug) THEN
1081: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1082: 'Delete_LVS_Records');
1083: END IF;
1084:
1085:

Line 1091: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1087:
1088: WHEN OTHERS THEN
1089: FII_UTIL.Write_Log ('Delete_LVS_Records -> phase: '|| g_phase);
1090: FII_UTIL.Write_Log ('Delete_LVS_Records: '|| substr(sqlerrm,1,180));
1091: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1092: 'Delete_LVS_Records');
1093: raise;
1094:
1095: END Delete_LVS_Records;

Line 1106: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1102:
1103: Begin
1104:
1105: IF (FIIDIM_Debug) THEN
1106: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1107: 'Get_FC_Mapping_GT');
1108: END IF;
1109:
1110: --First, populate FII_FIN_CAT_MAPPINGS_GT with the truncated portion

Line 1157: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Get_FC_Mapping_GT');

1153: (ownname => g_schema_name,
1154: tabname => 'FII_FIN_CAT_MAPPINGS_GT');
1155:
1156: IF (FIIDIM_Debug) THEN
1157: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Get_FC_Mapping_GT');
1158: END IF;
1159:
1160: EXCEPTION
1161:

Line 1165: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1161:
1162: WHEN OTHERS THEN
1163: FII_UTIL.Write_Log ('Get_FC_Mapping_GT -> phase: '|| g_phase);
1164: FII_UTIL.Write_Log ('Get_FC_Mapping_GT: '|| substr(sqlerrm,1,180));
1165: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1166: 'Get_FC_Mapping_GT');
1167: raise;
1168:
1169: END Get_FC_Mapping_GT;

Line 1217: FII_MESSAGE.Func_Ent (func_name =>

1213:
1214: Begin
1215:
1216: IF (FIIDIM_Debug) THEN
1217: FII_MESSAGE.Func_Ent (func_name =>
1218: 'FII_FIN_CAT_MAINTAIN_PKG.check_rules_denorm');
1219: END IF;
1220:
1221: g_phase := 'check rules for Revenue';

Line 1230: FII_MESSAGE.write_log(msg_name => 'FII_INVALID_FCT_ASGN',

1226: For bad_asg_rec IN Invalid_Asg_Cur (l_rev_cat_id) LOOP
1227: l_count := l_count + 1;
1228: if l_count = 1 then
1229:
1230: FII_MESSAGE.write_log(msg_name => 'FII_INVALID_FCT_ASGN',
1231: token_num => 0);
1232: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
1233: token_num => 0);
1234:

Line 1232: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',

1228: if l_count = 1 then
1229:
1230: FII_MESSAGE.write_log(msg_name => 'FII_INVALID_FCT_ASGN',
1231: token_num => 0);
1232: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
1233: token_num => 0);
1234:
1235: FII_MESSAGE.write_output (msg_name => 'FII_INVALID_FCT_ASGN',
1236: token_num => 0);

Line 1235: FII_MESSAGE.write_output (msg_name => 'FII_INVALID_FCT_ASGN',

1231: token_num => 0);
1232: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
1233: token_num => 0);
1234:
1235: FII_MESSAGE.write_output (msg_name => 'FII_INVALID_FCT_ASGN',
1236: token_num => 0);
1237: FII_MESSAGE.write_output (msg_name => 'FII_INVALID_FCT_TAB',
1238: token_num => 0);
1239:

Line 1237: FII_MESSAGE.write_output (msg_name => 'FII_INVALID_FCT_TAB',

1233: token_num => 0);
1234:
1235: FII_MESSAGE.write_output (msg_name => 'FII_INVALID_FCT_ASGN',
1236: token_num => 0);
1237: FII_MESSAGE.write_output (msg_name => 'FII_INVALID_FCT_TAB',
1238: token_num => 0);
1239:
1240: end if;
1241:

Line 1262: FII_MESSAGE.write_log(msg_name => 'FII_CONFLICT_DR_ASGN',

1258: For bad_asg_rec IN Conflict_Asg_Cur (l_rev_cat_id, 'DR') LOOP
1259: l_count_2 := l_count_2 + 1;
1260: if l_count_2 = 1 then
1261:
1262: FII_MESSAGE.write_log(msg_name => 'FII_CONFLICT_DR_ASGN',
1263: token_num => 0);
1264: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
1265: token_num => 0);
1266:

Line 1264: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',

1260: if l_count_2 = 1 then
1261:
1262: FII_MESSAGE.write_log(msg_name => 'FII_CONFLICT_DR_ASGN',
1263: token_num => 0);
1264: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
1265: token_num => 0);
1266:
1267: FII_MESSAGE.write_output (msg_name => 'FII_CONFLICT_DR_ASGN',
1268: token_num => 0);

Line 1267: FII_MESSAGE.write_output (msg_name => 'FII_CONFLICT_DR_ASGN',

1263: token_num => 0);
1264: FII_MESSAGE.write_log(msg_name => 'FII_REFER_TO_OUTPUT',
1265: token_num => 0);
1266:
1267: FII_MESSAGE.write_output (msg_name => 'FII_CONFLICT_DR_ASGN',
1268: token_num => 0);
1269: FII_MESSAGE.write_output (msg_name => 'FII_CONFLICT_DR_TAB',
1270: token_num => 0);
1271:

Line 1269: FII_MESSAGE.write_output (msg_name => 'FII_CONFLICT_DR_TAB',

1265: token_num => 0);
1266:
1267: FII_MESSAGE.write_output (msg_name => 'FII_CONFLICT_DR_ASGN',
1268: token_num => 0);
1269: FII_MESSAGE.write_output (msg_name => 'FII_CONFLICT_DR_TAB',
1270: token_num => 0);
1271:
1272: end if;
1273:

Line 1314: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Populate_FTC_denorm');

1310:
1311: Begin
1312:
1313: IF (FIIDIM_Debug) THEN
1314: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Populate_FTC_denorm');
1315: END IF;
1316:
1317: --clean up the denorm TMP table
1318: g_phase := 'Truncate FII_FC_TYPE_ASSGNS_GT';

Line 1541: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1537: tabname => 'MLOG$_FII_FIN_CAT_TYPE_ASS');
1538: END IF;
1539:
1540: IF (FIIDIM_Debug) THEN
1541: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1542: 'Populate_FCT_denorm');
1543: END IF;
1544:
1545: EXCEPTION

Line 1549: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1545: EXCEPTION
1546:
1547: WHEN NO_DATA_FOUND THEN
1548: FII_UTIL.Write_Log('Populate_FCT_denorm : No Data Found');
1549: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1550: 'Populate_FCT_denorm');
1551: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1552: raise;
1553:

Line 1555: FII_MESSAGE.write_log( msg_name => 'FII_NO_FC_TYPE_ASGN',

1551: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1552: raise;
1553:
1554: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
1555: FII_MESSAGE.write_log( msg_name => 'FII_NO_FC_TYPE_ASGN',
1556: token_num => 0);
1557: FII_MESSAGE.write_output(msg_name => 'FII_NO_FC_TYPE_ASGN',
1558: token_num => 0);
1559: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

Line 1557: FII_MESSAGE.write_output(msg_name => 'FII_NO_FC_TYPE_ASGN',

1553:
1554: WHEN FINDIM_NO_FC_TYPE_ASGN THEN
1555: FII_MESSAGE.write_log( msg_name => 'FII_NO_FC_TYPE_ASGN',
1556: token_num => 0);
1557: FII_MESSAGE.write_output(msg_name => 'FII_NO_FC_TYPE_ASGN',
1558: token_num => 0);
1559: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1560: 'Populate_FCT_denorm');
1561: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);

Line 1559: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1555: FII_MESSAGE.write_log( msg_name => 'FII_NO_FC_TYPE_ASGN',
1556: token_num => 0);
1557: FII_MESSAGE.write_output(msg_name => 'FII_NO_FC_TYPE_ASGN',
1558: token_num => 0);
1559: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1560: 'Populate_FCT_denorm');
1561: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1562: raise;
1563:

Line 1566: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1562: raise;
1563:
1564: WHEN OTHERS THEN
1565: FII_UTIL.Write_Log('Populate_FCT_denorm: '|| substr(sqlerrm,1,180));
1566: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1567: 'Populate_FCT_denorm');
1568: FII_UTIL.Write_Log ( 'G_PHASE: ' || G_PHASE);
1569: raise;
1570:

Line 1582: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1578:
1579: Begin
1580:
1581: IF (FIIDIM_Debug) THEN
1582: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1583: 'Handle_Unenabled_DIM');
1584: END IF;
1585:
1586: FII_UTIL.truncate_table ('FII_FULL_FIN_ITEM_HIERS', 'FII', g_retcode);

Line 1594: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1590: FII_UTIL.truncate_table ('FII_FIN_ITEM_LEAF_HIERS', 'FII', g_retcode);
1591: FII_UTIL.truncate_table ('FII_FIN_CAT_LEAF_MAPS', 'FII', g_retcode);
1592:
1593: IF (FIIDIM_Debug) THEN
1594: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1595: 'Handle_Unenabled_DIM');
1596: END IF;
1597:
1598: EXCEPTION

Line 1602: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||

1598: EXCEPTION
1599:
1600: WHEN OTHERS THEN
1601: FII_UTIL.Write_Log ('Handle_Unenabled_DIM: '|| substr(sqlerrm,1,180));
1602: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.'||
1603: 'Handle_Unenabled_DIM');
1604: raise;
1605:
1606: END Handle_Unenabled_DIM;

Line 1619: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

1615:
1616: BEGIN
1617:
1618: IF (FIIDIM_Debug) THEN
1619: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
1620: END IF;
1621:
1622: --First do the initialization
1623:

Line 1976: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

1972:
1973: commit; --FND_CONCURRENT.Af_Commit;
1974:
1975: IF (FIIDIM_Debug) THEN
1976: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
1977: END IF;
1978:
1979: -- ret_val := FND_CONCURRENT.Set_Completion_Status
1980: -- (status => 'NORMAL', message => NULL);

Line 1991: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

1987: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1988: 'User defined error');
1989: -- Rollback
1990: rollback; --FND_CONCURRENT.Af_Rollback;
1991: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
1992: retcode := sqlcode;
1993: ret_val := FND_CONCURRENT.Set_Completion_Status
1994: (status => 'ERROR', message => substr(sqlerrm,1,180));
1995:

Line 2002: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

1998: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
1999: 'Diamond Shape Detected');
2000: -- Rollback
2001: rollback; --FND_CONCURRENT.Af_Rollback;
2002: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2003: retcode := sqlcode;
2004: ret_val := FND_CONCURRENT.Set_Completion_Status
2005: (status => 'ERROR', message => substr(sqlerrm,1,180));
2006:

Line 2013: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

2009: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||
2010: 'Invalid FC Type Assignment Detected');
2011: -- Rollback
2012: rollback; --FND_CONCURRENT.Af_Rollback;
2013: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2014: retcode := sqlcode;
2015: ret_val := FND_CONCURRENT.Set_Completion_Status
2016: (status => 'ERROR', message => substr(sqlerrm,1,180));
2017:

Line 2033: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

2029: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
2030: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2031: -- Rollback
2032: rollback; --FND_CONCURRENT.Af_Rollback;
2033: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2034: retcode := sqlcode;
2035: ret_val := FND_CONCURRENT.Set_Completion_Status
2036: (status => 'ERROR',
2037: message => 'No Financial Category Type assignment is done.');

Line 2045: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');

2041: FII_UTIL.Write_Log(
2042: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));
2043: -- Rollback
2044: rollback; --FND_CONCURRENT.Af_Rollback;
2045: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Init_Load');
2046: retcode := sqlcode;
2047: ret_val := FND_CONCURRENT.Set_Completion_Status
2048: (status => 'ERROR', message => NULL);
2049:

Line 2064: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Load');

2060:
2061: BEGIN
2062:
2063: IF (FIIDIM_Debug) THEN
2064: FII_MESSAGE.Func_Ent(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Load');
2065: END IF;
2066:
2067: --First do the initialization
2068:

Line 2608: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Load');

2604:
2605: commit; --FND_CONCURRENT.Af_Commit;
2606:
2607: IF (FIIDIM_Debug) THEN
2608: FII_MESSAGE.Func_Succ(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Load');
2609: END IF;
2610:
2611: -- ret_val := FND_CONCURRENT.Set_Completion_Status
2612: -- (status => 'NORMAL', message => NULL);

Line 2622: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

2618: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update'||
2619: 'User defined error');
2620: -- Rollback
2621: rollback; --FND_CONCURRENT.Af_Rollback;
2622: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2623: retcode := sqlcode;
2624: ret_val := FND_CONCURRENT.Set_Completion_Status
2625: (status => 'ERROR', message => substr(sqlerrm,1,180));
2626:

Line 2633: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

2629: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2630: 'Diamond Shape Detected');
2631: -- Rollback
2632: rollback; --FND_CONCURRENT.Af_Rollback;
2633: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2634: retcode := sqlcode;
2635: ret_val := FND_CONCURRENT.Set_Completion_Status
2636: (status => 'ERROR', message => substr(sqlerrm,1,180));
2637:

Line 2644: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

2640: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||
2641: 'Invalid FC Type Assignment Detected');
2642: -- Rollback
2643: rollback; --FND_CONCURRENT.Af_Rollback;
2644: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2645: retcode := sqlcode;
2646: ret_val := FND_CONCURRENT.Set_Completion_Status
2647: (status => 'ERROR', message => substr(sqlerrm,1,180));
2648:

Line 2654: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');

2650: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
2651: FII_UTIL.Write_Log('No Financial Category Type assignment is done.');
2652: -- Rollback
2653: rollback; --FND_CONCURRENT.Af_Rollback;
2654: FII_MESSAGE.Func_Fail(func_name => 'FII_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2655: retcode := sqlcode;
2656: ret_val := FND_CONCURRENT.Set_Completion_Status
2657: (status => 'ERROR',
2658: message => 'No Financial Category Type assignment is done.');

Line 2676: FII_MESSAGE.Func_Fail(func_name => 'II_FIN_CAT_MAINTAIN_PKG.Incre_Update');

2672: FII_UTIL.Write_Log(
2673: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
2674: -- Rollback
2675: rollback; --FND_CONCURRENT.Af_Rollback;
2676: FII_MESSAGE.Func_Fail(func_name => 'II_FIN_CAT_MAINTAIN_PKG.Incre_Update');
2677: retcode := sqlcode;
2678: ret_val := FND_CONCURRENT.Set_Completion_Status
2679: (status => 'ERROR', message => substr(sqlerrm,1,180));
2680: