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_FIN_CAT_MAINTAIN_PKG

Line 1: PACKAGE BODY FII_FIN_CAT_MAINTAIN_PKG AS

1: PACKAGE BODY FII_FIN_CAT_MAINTAIN_PKG AS
2: /* $Header: FIIFICMB.pls 120.7 2006/09/26 12:42:43 arcdixit ship $ */
3:
4: G_MASTER_VALUE_SET_ID NUMBER(15) := NULL;
5: G_TOP_NODE_ID NUMBER(15) := NULL;

Line 183: FII_UTIL.initialize('FII_FIN_CAT_MAINTAIN_PKG.log',

179: -- FII_UTIL.initialize will get profile options FII_DEBUG_MODE
180: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
181: -- the log files and output files are written to
182: ----------------------------------------------------------------
183: FII_UTIL.initialize('FII_FIN_CAT_MAINTAIN_PKG.log',
184: 'FII_FIN_CAT_MAINTAIN_PKG.out',l_dir, 'FII_FIN_CAT_MAINTAIN_PKG');
185:
186: -- --------------------------------------------------------
187: -- Check source ledger setup for DBI

Line 184: 'FII_FIN_CAT_MAINTAIN_PKG.out',l_dir, 'FII_FIN_CAT_MAINTAIN_PKG');

180: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
181: -- the log files and output files are written to
182: ----------------------------------------------------------------
183: FII_UTIL.initialize('FII_FIN_CAT_MAINTAIN_PKG.log',
184: 'FII_FIN_CAT_MAINTAIN_PKG.out',l_dir, 'FII_FIN_CAT_MAINTAIN_PKG');
185:
186: -- --------------------------------------------------------
187: -- Check source ledger setup for DBI
188: -- --------------------------------------------------------

Line 322: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Initialize : '||

318: --Let the main program to handle this
319: raise;
320:
321: When FINDIM_fatal_err then
322: FII_UTIL.Write_Log('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;

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 478: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP: '||

474:
475: Exception
476:
477: When FINDIM_fatal_err then
478: FII_UTIL.Write_Log('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;

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 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 587: FII_UTIL.Write_Log ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape: '||

583:
584: Exception
585:
586: When FINDIM_MULT_PAR_err then
587: FII_UTIL.Write_Log ('FII_FIN_CAT_MAINTAIN_PKG.Detect_Diamond_Shape: '||
588: 'diamond shape detected!');
589: RAISE;
590:
591: When others then

Line 710: (func_name => 'FII_FIN_CAT_MAINTAIN_PKG.INSERT_IMM_CHILD_NODES');

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;
714:

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 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 1218: 'FII_FIN_CAT_MAINTAIN_PKG.check_rules_denorm');

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';
1222:

Line 1289: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.check_rules_denorm: '||

1285:
1286: Exception
1287:
1288: When FINDIM_Invalid_FC_ASG_err then
1289: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.check_rules_denorm: '||
1290: 'invalid FC Type assignment detected!');
1291: raise;
1292:
1293: When others then

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 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 1987: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||

1983: EXCEPTION
1984:
1985: WHEN FINDIM_fatal_err THEN
1986: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
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');

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 1998: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||

1994: (status => 'ERROR', message => substr(sqlerrm,1,180));
1995:
1996: WHEN FINDIM_MULT_PAR_err THEN
1997: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
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');

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 2009: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Init_Load: '||

2005: (status => 'ERROR', message => substr(sqlerrm,1,180));
2006:
2007: WHEN FINDIM_Invalid_FC_ASG_err then
2008: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
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');

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 2042: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Init_Load: ' || substr(sqlerrm,1,180));

2038:
2039: WHEN OTHERS THEN
2040: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
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;

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 2618: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update'||

2614: -- Exception handling
2615: EXCEPTION
2616: WHEN FINDIM_fatal_err THEN
2617: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
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');

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 2629: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||

2625: (status => 'ERROR', message => substr(sqlerrm,1,180));
2626:
2627: WHEN FINDIM_MULT_PAR_err THEN
2628: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
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');

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 2640: FII_UTIL.Write_Log('FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: '||

2636: (status => 'ERROR', message => substr(sqlerrm,1,180));
2637:
2638: WHEN FINDIM_Invalid_FC_ASG_err then
2639: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
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');

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 2673: 'Other error in FII_FIN_CAT_MAINTAIN_PKG.Incre_Update: ' || substr(sqlerrm,1,180));

2669:
2670: WHEN OTHERS THEN
2671: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
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;

Line 2683: END FII_FIN_CAT_MAINTAIN_PKG;

2679: (status => 'ERROR', message => substr(sqlerrm,1,180));
2680:
2681: END Incre_Update;
2682:
2683: END FII_FIN_CAT_MAINTAIN_PKG;