DBA Data[Home] [Help]

APPS.FII_FA_CAT_C dependencies on FII_MESSAGE

Line 37: FII_MESSAGE.Func_Ent(l_calling_fn);

33:
34: BEGIN
35:
36: If g_debug_flag = 'Y' then
37: FII_MESSAGE.Func_Ent(l_calling_fn);
38: End if;
39:
40: If g_debug_flag = 'Y' then
41: FII_UTIL.Write_Log('Inserting DBI log items into FII_CHANGE_LOG');

Line 74: FII_MESSAGE.Func_Succ(l_calling_fn);

70: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' log items into FII_CHANGE_LOG');
71: End if;
72:
73: If g_debug_flag = 'Y' then
74: FII_MESSAGE.Func_Succ(l_calling_fn);
75: End if;
76:
77: EXCEPTION
78:

Line 83: FII_MESSAGE.Func_Fail(l_calling_fn);

79: WHEN OTHERS THEN
80: rollback;
81: g_retcode := -1;
82: FII_UTIL.Write_Log('Error occured in Procedure: INIT_DBI_CHANGE_LOG Message: ' || sqlerrm);
83: FII_MESSAGE.Func_Fail(l_calling_fn);
84: raise;
85:
86: END INIT_DBI_CHANGE_LOG;
87:

Line 98: FII_MESSAGE.Func_Ent(l_calling_fn);

94: l_calling_fn VARCHAR2(40) := 'FII_FA_CAT_C.GET_STRUCTURE_NAME';
95:
96: BEGIN
97: If g_debug_flag = 'Y' then
98: FII_MESSAGE.Func_Ent(l_calling_fn);
99: End if;
100:
101: g_phase := 'Getting user name for flex structure: ' || p_structure_id;
102:

Line 113: FII_MESSAGE.Func_Succ(l_calling_fn);

109: AND language = g_current_language;
110:
111: If g_debug_flag = 'Y' then
112: FII_UTIL.Write_Log('l_structure_name' || l_structure_name);
113: FII_MESSAGE.Func_Succ(l_calling_fn);
114: End if;
115:
116: return l_structure_name;
117:

Line 126: FII_MESSAGE.Func_Fail(l_calling_fn);

122: ------------------------
123: Error in Function: GET_COA_NAME
124: Phase: '||g_phase||'
125: Message: '||sqlerrm);
126: FII_MESSAGE.Func_Fail(l_calling_fn);
127: raise;
128:
129: END GET_STRUCTURE_NAME;
130:

Line 165: FII_MESSAGE.Func_Ent(l_calling_fn);

161:
162: BEGIN
163:
164: If g_debug_flag = 'Y' then
165: FII_MESSAGE.Func_Ent(l_calling_fn);
166: End if;
167:
168: If g_debug_flag = 'Y' then
169: FII_UTIL.Write_Log('Getting Category segments column information for flex structures');

Line 402: FII_MESSAGE.Func_Succ(l_calling_fn);

398: (ownname => g_fii_schema,
399: tabname => 'FII_FA_CAT_SEGMENTS');
400:
401: If g_debug_flag = 'Y' then
402: FII_MESSAGE.Func_Succ(l_calling_fn);
403: End if;
404:
405: EXCEPTION
406: WHEN NO_DATA_FOUND THEN

Line 415: FII_MESSAGE.write_log(

411: -- complete
412: -----------------------------------------------
413: l_structure_name := GET_STRUCTURE_NAME(l_flex_structure_id);
414:
415: FII_MESSAGE.write_log(
416: msg_name => 'FII_COA_SEG_NOT_FOUND',
417: token_num => 1,
418: t1 => 'COA_NAME',
419: v1 => l_structure_name);

Line 421: FII_MESSAGE.write_output(

417: token_num => 1,
418: t1 => 'COA_NAME',
419: v1 => l_structure_name);
420:
421: FII_MESSAGE.write_output(
422: msg_name => 'FII_COA_SEG_NOT_FOUND',
423: token_num => 1,
424: t1 => 'COA_NAME',
425: v1 => l_structure_name);

Line 427: FII_MESSAGE.Func_Fail(l_calling_fn);

423: token_num => 1,
424: t1 => 'COA_NAME',
425: v1 => l_structure_name);
426:
427: FII_MESSAGE.Func_Fail(l_calling_fn);
428:
429: RAISE;
430:
431: WHEN ERROR_FOUND THEN

Line 444: FII_MESSAGE.Func_Fail(l_calling_fn);

440: FII_UTIL.Write_Log('
441: ----------------------------
442: Error occured in Procedure: GET_CAT_SEGMENTS
443: Message: ' || sqlerrm);
444: FII_MESSAGE.Func_Fail(l_calling_fn);
445: RAISE;
446: END GET_CAT_SEGMENTS;
447:
448:

Line 504: FII_MESSAGE.Func_Ent(l_calling_fn);

500:
501: BEGIN
502:
503: If g_debug_flag = 'Y' then
504: FII_MESSAGE.Func_Ent(l_calling_fn);
505: End if;
506:
507: IF g_debug_flag = 'Y' then
508: FII_UTIL.Write_Log('Inserting IDs in flex structure: ' ||

Line 748: FII_MESSAGE.Func_Succ(l_calling_fn);

744:
745:
746:
747: If g_debug_flag = 'Y' then
748: FII_MESSAGE.Func_Succ(l_calling_fn);
749: End if;
750:
751: EXCEPTION
752:

Line 760: FII_MESSAGE.Func_Fail(l_calling_fn);

756: FII_UTIL.Write_Log('
757: -----------------------------
758: Error occured in Procedure: INSERT_INTO_CAT_DIM
759: Message: ' || sqlerrm);
760: FII_MESSAGE.Func_Fail(l_calling_fn);
761: raise;
762: END INSERT_INTO_CAT_DIM;
763:
764: ------------------------------------------------------------------

Line 775: FII_MESSAGE.Func_Ent(l_calling_fn);

771:
772: BEGIN
773:
774: If g_debug_flag = 'Y' then
775: FII_MESSAGE.Func_Ent(l_calling_fn);
776: End if;
777:
778: g_phase := 'Updating max CAT ID processed';
779:

Line 834: FII_MESSAGE.Func_Succ(l_calling_fn);

830: FII_UTIL.Write_Log('');
831: End if;
832:
833: If g_debug_flag = 'Y' then
834: FII_MESSAGE.Func_Succ(l_calling_fn);
835: End if;
836:
837: EXCEPTION
838: WHEN OTHERS THEN

Line 846: FII_MESSAGE.Func_Fail(l_calling_fn);

842: -------------------------------------------
843: Error occured in Procedure: RECORD_MAX_PROCESSED_CAT_ID
844: Phase: ' || g_phase || '
845: Message: ' || sqlerrm);
846: FII_MESSAGE.Func_Fail(l_calling_fn);
847: raise;
848:
849: END RECORD_MAX_PROCESSED_CAT_ID;
850:

Line 861: FII_MESSAGE.Func_Ent(l_calling_fn);

857:
858: BEGIN
859:
860: If g_debug_flag = 'Y' then
861: FII_MESSAGE.Func_Ent(l_calling_fn);
862: End if;
863:
864: g_phase := 'Identifying Max CAT ID processed';
865:

Line 897: FII_MESSAGE.Func_Succ(l_calling_fn);

893: End if;
894:
895:
896: If g_debug_flag = 'Y' then
897: FII_MESSAGE.Func_Succ(l_calling_fn);
898: End if;
899:
900: IF g_new_max_cat_id > g_max_cat_id THEN
901: RETURN TRUE;

Line 915: FII_MESSAGE.Func_Fail(l_calling_fn);

911: -------------------------------------------
912: Error occured in Function: NEW_CAT_IN_FA
913: Phase: ' || g_phase || '
914: Message: ' || sqlerrm);
915: FII_MESSAGE.Func_Fail(l_calling_fn);
916: raise;
917: END NEW_CAT_IN_FA;
918:
919:

Line 945: FII_MESSAGE.Func_Ent(l_calling_fn);

941:
942: BEGIN
943:
944: If g_debug_flag = 'Y' then
945: FII_MESSAGE.Func_Ent(l_calling_fn);
946: End if;
947:
948: g_phase := 'Identifying Max CAT ID processed';
949: If g_debug_flag = 'Y' then

Line 1087: FII_MESSAGE.Func_Succ(l_calling_fn);

1083: (ownname => g_fii_schema,
1084: tabname => 'FII_FA_CAT_DIMENSIONS');
1085:
1086: If g_debug_flag = 'Y' then
1087: FII_MESSAGE.Func_Succ(l_calling_fn);
1088: End if;
1089:
1090: EXCEPTION
1091:

Line 1118: FII_MESSAGE.Func_Fail(l_calling_fn);

1114: -----------------------------
1115: Error occured in Procedure: INSERT_NEW_CAT
1116: Phase: ' || g_phase || '
1117: Message: ' || sqlerrm);
1118: FII_MESSAGE.Func_Fail(l_calling_fn);
1119: raise;
1120:
1121: END INSERT_NEW_CAT;
1122:

Line 1156: FII_MESSAGE.Func_Ent(l_calling_fn);

1152:
1153: BEGIN
1154:
1155: If g_debug_flag = 'Y' then
1156: FII_MESSAGE.Func_Ent(l_calling_fn);
1157: End if;
1158:
1159: ----------------------------------------------
1160: -- Do set up for log file

Line 1228: FII_MESSAGE.Func_Succ(l_calling_fn);

1224: THEN NULL;
1225: END IF;
1226:
1227: If g_debug_flag = 'Y' then
1228: FII_MESSAGE.Func_Succ(l_calling_fn);
1229: End if;
1230:
1231: EXCEPTION
1232:

Line 1236: FII_MESSAGE.Func_Fail(l_calling_fn);

1232:
1233: WHEN G_NO_SLG_SETUP THEN
1234: FII_UTIL.write_log ('No source ledger setup for DBI');
1235: g_retcode := -1;
1236: FII_MESSAGE.Func_Fail(l_calling_fn);
1237: raise;
1238:
1239: WHEN G_LOGIN_INFO_NOT_AVABLE THEN
1240: FII_UTIL.Write_Log ('Can not get User ID and Login ID, program exit');

Line 1242: FII_MESSAGE.Func_Fail(l_calling_fn);

1238:
1239: WHEN G_LOGIN_INFO_NOT_AVABLE THEN
1240: FII_UTIL.Write_Log ('Can not get User ID and Login ID, program exit');
1241: g_retcode := -1;
1242: FII_MESSAGE.Func_Fail(l_calling_fn);
1243: raise;
1244:
1245: WHEN OTHERS THEN
1246: g_retcode := -1;

Line 1252: FII_MESSAGE.Func_Fail(l_calling_fn);

1248: ------------------------
1249: Error in Procedure: INITIALIZE
1250: Phase: '||g_phase||'
1251: Message: '||sqlerrm);
1252: FII_MESSAGE.Func_Fail(l_calling_fn);
1253: raise;
1254:
1255: END INITIALIZE;
1256:

Line 1280: FII_MESSAGE.Func_Ent(l_calling_fn);

1276:
1277: BEGIN
1278:
1279: If g_debug_flag = 'Y' then
1280: FII_MESSAGE.Func_Ent(l_calling_fn);
1281: End if;
1282:
1283: errbuf := NULL;
1284: retcode := 0;

Line 1375: FII_MESSAGE.Func_Succ(l_calling_fn);

1371:
1372: retcode := g_retcode;
1373:
1374: If g_debug_flag = 'Y' then
1375: FII_MESSAGE.Func_Succ(l_calling_fn);
1376: End if;
1377:
1378: EXCEPTION
1379: WHEN OTHERS THEN

Line 1388: FII_MESSAGE.Func_Fail(l_calling_fn);

1384: Error occured in Procedure: MAIN
1385: Phase: ' || g_phase || '
1386: Message: ' || sqlerrm);
1387:
1388: FII_MESSAGE.Func_Fail(l_calling_fn);
1389:
1390: retcode := g_retcode;
1391: ret_val := FND_CONCURRENT.Set_Completion_Status
1392: (status => 'ERROR', message => substr(sqlerrm,1,180));