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_BUDGET_FORECAST_C dependencies on FND_CONCURRENT

Line 147: FND_CONCURRENT.Af_Commit;

143:
144: END IF;
145:
146: -- Commit everything to database before returning
147: FND_CONCURRENT.Af_Commit;
148:
149: IF (FIIBUUP_DEBUG) THEN
150: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.Purge_All');
151: END IF;

Line 158: FND_CONCURRENT.Af_Rollback;

154: -- Exception handling
155: EXCEPTION
156: WHEN FIIBUUP_fatal_err THEN
157:
158: FND_CONCURRENT.Af_Rollback;
159:
160: FII_MESSAGE.Write_Log
161: (msg_name => 'FII_ERR_ENC_ROUT',
162: token_num => 1,

Line 177: FND_CONCURRENT.Af_Rollback;

173: RETURN FALSE;
174:
175: WHEN OTHERS THEN
176:
177: FND_CONCURRENT.Af_Rollback;
178:
179: FII_MESSAGE.Write_Log
180: (msg_name => 'FII_ERROR',
181: token_num => 2,

Line 452: FND_CONCURRENT.Af_Commit;

448: v2 => 'FII_BUDGET_BASE');
449: END IF;
450:
451: -- Commit all work
452: FND_CONCURRENT.Af_Commit;
453:
454: IF (FIIBUUP_DEBUG) THEN
455: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.Purge_Partial');
456: END IF;

Line 463: FND_CONCURRENT.Af_Rollback;

459: -- Exception handling
460: EXCEPTION
461: WHEN FIIBUUP_fatal_err THEN
462:
463: FND_CONCURRENT.Af_Rollback;
464:
465: FII_MESSAGE.Write_Log
466: (msg_name => 'FII_ERR_ENC_ROUT',
467: token_num => 1,

Line 481: FND_CONCURRENT.Af_Rollback;

477: RETURN FALSE;
478:
479: WHEN OTHERS THEN
480:
481: FND_CONCURRENT.Af_Rollback;
482:
483: FII_MESSAGE.Write_Log
484: (msg_name => 'FII_ERROR',
485: token_num => 2,

Line 674: FND_CONCURRENT.Af_Commit;

670:
671: END IF;
672:
673: -- Commit everything to database before returning
674: FND_CONCURRENT.Af_Commit;
675:
676: IF (FIIBUUP_DEBUG) THEN
677: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.Purge_Eff_Date');
678: END IF;

Line 685: FND_CONCURRENT.Af_Rollback;

681: -- Exception handling
682: EXCEPTION
683: WHEN FIIBUUP_fatal_err THEN
684:
685: FND_CONCURRENT.Af_Rollback;
686:
687: FII_MESSAGE.Write_Log
688: (msg_name => 'FII_ERR_ENC_ROUT',
689: token_num => 1,

Line 704: FND_CONCURRENT.Af_Rollback;

700: RETURN FALSE;
701:
702: WHEN OTHERS THEN
703:
704: FND_CONCURRENT.Af_Rollback;
705:
706: FII_MESSAGE.Write_Log
707: (msg_name => 'FII_ERROR',
708: token_num => 2,

Line 940: FND_CONCURRENT.Af_Commit;

936: ' rows into fii_budget_stg');
937: END IF;
938:
939: -- Need to commit after inserting data into base in parallel mode
940: FND_CONCURRENT.Af_Commit;
941:
942: -- Psi_Insert_Stg is completed, return with success.
943: IF (FIIBUUP_DEBUG) THEN
944: FII_MESSAGE.Write_Log

Line 961: FND_CONCURRENT.Af_Rollback;

957:
958: -- Exception handling
959: EXCEPTION
960: WHEN FIIBUUP_fatal_err THEN
961: FND_CONCURRENT.Af_Rollback;
962:
963: FII_MESSAGE.Write_Log
964: (msg_name => 'FII_ERR_ENC_ROUT',
965: token_num => 1,

Line 977: FND_CONCURRENT.Af_Rollback;

973: 'Error: ' || sqlerrm);
974: RETURN FALSE;
975:
976: WHEN OTHERS THEN
977: FND_CONCURRENT.Af_Rollback;
978:
979: FII_MESSAGE.Write_Log
980: (msg_name => 'FII_ERROR',
981: token_num => 2,

Line 1158: FND_CONCURRENT.Af_Commit;

1154: ' rows into fii_budget_stg');
1155: END IF;
1156:
1157: -- Need to commit after inserting data into base in parallel mode
1158: FND_CONCURRENT.Af_Commit;
1159:
1160: -- Psi_Carry_Forward is completed, return with success.
1161: IF (FIIBUUP_DEBUG) THEN
1162: FII_MESSAGE.Write_Log

Line 1179: FND_CONCURRENT.Af_Rollback;

1175:
1176: -- Exception handling
1177: EXCEPTION
1178: WHEN FIIBUUP_fatal_err THEN
1179: FND_CONCURRENT.Af_Rollback;
1180:
1181: FII_MESSAGE.Write_Log
1182: (msg_name => 'FII_ERR_ENC_ROUT',
1183: token_num => 1,

Line 1195: FND_CONCURRENT.Af_Rollback;

1191: 'Error: ' || sqlerrm);
1192: RETURN FALSE;
1193:
1194: WHEN OTHERS THEN
1195: FND_CONCURRENT.Af_Rollback;
1196:
1197: FII_MESSAGE.Write_Log
1198: (msg_name => 'FII_ERROR',
1199: token_num => 2,

Line 1303: FND_CONCURRENT.Af_Commit;

1299: ' rows into fii_budget_stg');
1300: END IF;
1301:
1302: -- Need to commit
1303: FND_CONCURRENT.Af_Commit;
1304:
1305: -- PSI Budget Extraction is completed, return with success.
1306: IF (FIIBUUP_DEBUG) THEN
1307: FII_MESSAGE.Write_Log

Line 1324: FND_CONCURRENT.Af_Rollback;

1320:
1321: -- Exception handling
1322: EXCEPTION
1323: WHEN FIIBUUP_fatal_err THEN
1324: FND_CONCURRENT.Af_Rollback;
1325:
1326: FII_MESSAGE.Write_Log
1327: (msg_name => 'FII_ERR_ENC_ROUT',
1328: token_num => 1,

Line 1340: FND_CONCURRENT.Af_Rollback;

1336: 'Error: ' || sqlerrm);
1337: RETURN FALSE;
1338:
1339: WHEN OTHERS THEN
1340: FND_CONCURRENT.Af_Rollback;
1341:
1342: FII_MESSAGE.Write_Log
1343: (msg_name => 'FII_ERROR',
1344: token_num => 2,

Line 1477: FND_CONCURRENT.Af_Commit;

1473: ' rows from fii_budget_base');
1474: END IF;
1475:
1476: -- Need to commit
1477: FND_CONCURRENT.Af_Commit;
1478:
1479: -- PSI Budget Extraction is completed, return with success.
1480: IF (FIIBUUP_DEBUG) THEN
1481: FII_MESSAGE.Write_Log

Line 1498: FND_CONCURRENT.Af_Rollback;

1494:
1495: -- Exception handling
1496: EXCEPTION
1497: WHEN FIIBUUP_fatal_err THEN
1498: FND_CONCURRENT.Af_Rollback;
1499:
1500: FII_MESSAGE.Write_Log
1501: (msg_name => 'FII_ERR_ENC_ROUT',
1502: token_num => 1,

Line 1514: FND_CONCURRENT.Af_Rollback;

1510: 'Error: ' || sqlerrm);
1511: RETURN FALSE;
1512:
1513: WHEN OTHERS THEN
1514: FND_CONCURRENT.Af_Rollback;
1515:
1516: FII_MESSAGE.Write_Log
1517: (msg_name => 'FII_ERROR',
1518: token_num => 2,

Line 1654: FND_CONCURRENT.Af_Commit;

1650: ' rows into fii_budget_base');
1651: END IF;
1652:
1653: -- Need to commit
1654: FND_CONCURRENT.Af_Commit;
1655:
1656: -- PSI Budget Extraction is completed, return with success.
1657: IF (FIIBUUP_DEBUG) THEN
1658: FII_MESSAGE.Write_Log

Line 1675: FND_CONCURRENT.Af_Rollback;

1671:
1672: -- Exception handling
1673: EXCEPTION
1674: WHEN FIIBUUP_fatal_err THEN
1675: FND_CONCURRENT.Af_Rollback;
1676:
1677: FII_MESSAGE.Write_Log
1678: (msg_name => 'FII_ERR_ENC_ROUT',
1679: token_num => 1,

Line 1691: FND_CONCURRENT.Af_Rollback;

1687: 'Error: ' || sqlerrm);
1688: RETURN FALSE;
1689:
1690: WHEN OTHERS THEN
1691: FND_CONCURRENT.Af_Rollback;
1692:
1693: FII_MESSAGE.Write_Log
1694: (msg_name => 'FII_ERROR',
1695: token_num => 2,

Line 2004: FND_CONCURRENT.Af_Rollback;

2000: -- Exception handling
2001: EXCEPTION
2002: WHEN FIIBUUP_fatal_err THEN
2003:
2004: FND_CONCURRENT.Af_Rollback;
2005:
2006: FII_MESSAGE.Write_Log
2007: (msg_name => 'FII_ERR_ENC_ROUT',
2008: token_num => 1,

Line 2022: FND_CONCURRENT.Af_Rollback;

2018: retcode := 'E';
2019:
2020: WHEN OTHERS THEN
2021:
2022: FND_CONCURRENT.Af_Rollback;
2023:
2024: FII_MESSAGE.Write_Log
2025: (msg_name => 'FII_ERROR',
2026: token_num => 2,

Line 2335: FND_CONCURRENT.Af_Rollback;

2331: -- Exception handling
2332: EXCEPTION
2333: WHEN FIIBUUP_fatal_err THEN
2334:
2335: FND_CONCURRENT.Af_Rollback;
2336:
2337: FII_MESSAGE.Write_Log
2338: (msg_name => 'FII_ERR_ENC_ROUT',
2339: token_num => 1,

Line 2353: FND_CONCURRENT.Af_Rollback;

2349: RETURN FALSE;
2350:
2351: WHEN OTHERS THEN
2352:
2353: FND_CONCURRENT.Af_Rollback;
2354:
2355: FII_MESSAGE.Write_Log
2356: (msg_name => 'FII_ERROR',
2357: token_num => 2,

Line 3872: FND_CONCURRENT.Af_Commit;

3868: CLOSE verDateCursorYr;
3869: END IF;
3870:
3871: -- We need to commit here for status_code
3872: FND_CONCURRENT.Af_Commit;
3873:
3874: -- Bug fix 4943332: Changed to return 1 if any error row exists
3875: BEGIN
3876: SELECT 1

Line 3912: FND_CONCURRENT.Af_Rollback;

3908:
3909: -- Exception handling
3910: EXCEPTION
3911: WHEN FIIBUUP_fatal_err THEN
3912: FND_CONCURRENT.Af_Rollback;
3913:
3914: FII_MESSAGE.Write_Log
3915: (msg_name => 'FII_ERR_ENC_ROUT',
3916: token_num => 1,

Line 3929: FND_CONCURRENT.Af_Rollback;

3925: retcode := 'E';
3926: RETURN;
3927:
3928: WHEN OTHERS THEN
3929: FND_CONCURRENT.Af_Rollback;
3930:
3931: FII_MESSAGE.Write_Log
3932: (msg_name => 'FII_ERROR',
3933: token_num => 2,

Line 4403: FND_CONCURRENT.Af_Commit;

4399: t2 => 'ACTION',
4400: v2 => 'Prior_version done...');
4401: END IF;
4402:
4403: FND_CONCURRENT.Af_Commit;
4404:
4405: IF (FIIBUUP_DEBUG) THEN
4406: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.Prior_version' ||
4407: version_date);

Line 4413: FND_CONCURRENT.Af_Rollback;

4409: RETURN TRUE;
4410:
4411: EXCEPTION
4412: WHEN FIIBUUP_fatal_err THEN
4413: FND_CONCURRENT.Af_Rollback;
4414:
4415: FII_MESSAGE.Write_Log
4416: (msg_name => 'FII_ERR_ENC_ROUT',
4417: token_num => 1,

Line 4429: FND_CONCURRENT.Af_Rollback;

4425: 'Error: ' || sqlerrm);
4426: RETURN FALSE;
4427:
4428: WHEN OTHERS THEN
4429: FND_CONCURRENT.Af_Rollback;
4430:
4431: -- SQL error occurs. Print out the error
4432: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
4433: token_num => 2,

Line 4739: FND_CONCURRENT.Af_Commit;

4735: t2 => 'ACTION',
4736: v2 => 'Prior_version done...');
4737: END IF;
4738:
4739: FND_CONCURRENT.Af_Commit;
4740:
4741: IF (FIIBUUP_DEBUG) THEN
4742: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.Prior_version');
4743: END IF;

Line 4748: FND_CONCURRENT.Af_Rollback;

4744: RETURN TRUE;
4745:
4746: EXCEPTION
4747: WHEN FIIBUUP_fatal_err THEN
4748: FND_CONCURRENT.Af_Rollback;
4749:
4750: FII_MESSAGE.Write_Log
4751: (msg_name => 'FII_ERR_ENC_ROUT',
4752: token_num => 1,

Line 4764: FND_CONCURRENT.Af_Rollback;

4760: 'Error: ' || sqlerrm);
4761: RETURN FALSE;
4762:
4763: WHEN OTHERS THEN
4764: FND_CONCURRENT.Af_Rollback;
4765:
4766: -- SQL error occurs. Print out the error
4767: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
4768: token_num => 2,

Line 5133: FND_CONCURRENT.Af_Commit;

5129: t2 => 'ACTION',
5130: v2 => 'Staging done...');
5131: END IF;
5132:
5133: FND_CONCURRENT.Af_Commit;
5134:
5135: IF (FIIBUUP_DEBUG) THEN
5136: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.stage');
5137: END IF;

Line 5142: FND_CONCURRENT.Af_Rollback;

5138: RETURN TRUE;
5139:
5140: EXCEPTION
5141: WHEN FIIBUUP_fatal_err THEN
5142: FND_CONCURRENT.Af_Rollback;
5143:
5144: FII_MESSAGE.Write_Log
5145: (msg_name => 'FII_ERR_ENC_ROUT',
5146: token_num => 1,

Line 5158: FND_CONCURRENT.Af_Rollback;

5154: 'Error: ' || sqlerrm);
5155: RETURN FALSE;
5156:
5157: WHEN OTHERS THEN
5158: FND_CONCURRENT.Af_Rollback;
5159:
5160: -- SQL error occurs. Print out the error
5161: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
5162: token_num => 2,

Line 5546: FND_CONCURRENT.Af_Commit;

5542: t2 => 'ACTION',
5543: v2 => 'adjust_amount done...');
5544: END IF;
5545:
5546: FND_CONCURRENT.Af_Commit;
5547:
5548: IF (FIIBUUP_DEBUG) THEN
5549: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.adjust_amount');
5550: END IF;

Line 5555: FND_CONCURRENT.Af_Rollback;

5551: RETURN TRUE;
5552:
5553: EXCEPTION
5554: WHEN FIIBUUP_fatal_err THEN
5555: FND_CONCURRENT.Af_Rollback;
5556:
5557: FII_MESSAGE.Write_Log
5558: (msg_name => 'FII_ERR_ENC_ROUT',
5559: token_num => 1,

Line 5571: FND_CONCURRENT.Af_Rollback;

5567: 'Error: ' || sqlerrm);
5568: RETURN FALSE;
5569:
5570: WHEN OTHERS THEN
5571: FND_CONCURRENT.Af_Rollback;
5572:
5573: -- SQL error occurs. Print out the error
5574: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
5575: token_num => 2,

Line 5844: FND_CONCURRENT.Af_Commit;

5840: t2 => 'ACTION',
5841: v2 => 'rollup_stage done...');
5842: END IF;
5843:
5844: FND_CONCURRENT.Af_Commit;
5845:
5846: IF (FIIBUUP_DEBUG) THEN
5847: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.rollup_stage');
5848: END IF;

Line 5853: FND_CONCURRENT.Af_Rollback;

5849: RETURN TRUE;
5850:
5851: EXCEPTION
5852: WHEN FIIBUUP_fatal_err THEN
5853: FND_CONCURRENT.Af_Rollback;
5854:
5855: FII_MESSAGE.Write_Log
5856: (msg_name => 'FII_ERR_ENC_ROUT',
5857: token_num => 1,

Line 5869: FND_CONCURRENT.Af_Rollback;

5865: 'Error: ' || sqlerrm);
5866: RETURN FALSE;
5867:
5868: WHEN OTHERS THEN
5869: FND_CONCURRENT.Af_Rollback;
5870:
5871: -- SQL error occurs. Print out the error
5872: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
5873: token_num => 2,

Line 6052: FND_CONCURRENT.Af_Rollback;

6048: RETURN TRUE;
6049:
6050: EXCEPTION
6051: WHEN FIIBUUP_fatal_err THEN
6052: FND_CONCURRENT.Af_Rollback;
6053:
6054: FII_MESSAGE.Write_Log
6055: (msg_name => 'FII_ERR_ENC_ROUT',
6056: token_num => 1,

Line 6068: FND_CONCURRENT.Af_Rollback;

6064: 'Error: ' || sqlerrm);
6065: RETURN FALSE;
6066:
6067: WHEN OTHERS THEN
6068: FND_CONCURRENT.Af_Rollback;
6069:
6070: -- SQL error occurs. Print out the error
6071: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
6072: token_num => 2,

Line 6261: FND_CONCURRENT.Af_Commit;

6257: v2 => 'Merging forecast records into fii_budget_base...');
6258: END IF;
6259:
6260: -- Bug 4674640: Added commit after enabling parallel dml
6261: FND_CONCURRENT.Af_Commit;
6262:
6263: g_phase := 'Execute the built SQL l_tmpstmt';
6264: IF (FIIBUUP_FORECAST_TIME_UNIT = 'P') THEN
6265: l_per_type_id := 32;

Line 6288: FND_CONCURRENT.Af_Commit;

6284: t2 => 'TABLE',
6285: v2 => 'FII_BUDGET_BASE');
6286: END IF;
6287:
6288: FND_CONCURRENT.Af_Commit;
6289:
6290: IF (FIIBUUP_DEBUG) THEN
6291: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.merge');
6292: END IF;

Line 6297: FND_CONCURRENT.Af_Rollback;

6293: RETURN TRUE;
6294:
6295: EXCEPTION
6296: WHEN FIIBUUP_fatal_err THEN
6297: FND_CONCURRENT.Af_Rollback;
6298:
6299: FII_MESSAGE.Write_Log
6300: (msg_name => 'FII_ERR_ENC_ROUT',
6301: token_num => 1,

Line 6313: FND_CONCURRENT.Af_Rollback;

6309: 'Error: ' || sqlerrm);
6310: RETURN FALSE;
6311:
6312: WHEN OTHERS THEN
6313: FND_CONCURRENT.Af_Rollback;
6314:
6315: -- SQL error occurs. Print out the error
6316: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
6317: token_num => 2,

Line 6472: FND_CONCURRENT.Af_Commit;

6468: t2 => 'TABLE',
6469: v2 => 'FII_BUDGET_BASE');
6470: END IF;
6471:
6472: FND_CONCURRENT.Af_Commit;
6473:
6474: IF (FIIBUUP_DEBUG) THEN
6475: FII_MESSAGE.Func_Succ('FII_BUDGET_FORECAST_C.adjust_ver_date');
6476: END IF;

Line 6481: FND_CONCURRENT.Af_Rollback;

6477: RETURN TRUE;
6478:
6479: EXCEPTION
6480: WHEN FIIBUUP_fatal_err THEN
6481: FND_CONCURRENT.Af_Rollback;
6482:
6483: FII_MESSAGE.Write_Log
6484: (msg_name => 'FII_ERR_ENC_ROUT',
6485: token_num => 1,

Line 6497: FND_CONCURRENT.Af_Rollback;

6493: 'Error: ' || sqlerrm);
6494: RETURN FALSE;
6495:
6496: WHEN OTHERS THEN
6497: FND_CONCURRENT.Af_Rollback;
6498:
6499: -- SQL error occurs. Print out the error
6500: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
6501: token_num => 2,

Line 6667: l_ret_status := FND_CONCURRENT.Set_Completion_Status

6663: -- GL Budget Extraction program has failed.
6664: raise FIIBUUP_fatal_err;
6665: ELSIF (l_ret_code = 'W') THEN
6666: -- GL Budget Extraction program ends with warnings.
6667: l_ret_status := FND_CONCURRENT.Set_Completion_Status
6668: (status => 'WARNING', message => NULL);
6669:
6670: RETURN;
6671: ELSE

Line 6677: l_ret_status := FND_CONCURRENT.Set_Completion_Status

6673: IF (FIIBUUP_DEBUG) THEN
6674: FII_MESSAGE.Func_Succ(func_name => 'FII_BUDGET_FORECAST_C.Main');
6675: END IF;
6676:
6677: l_ret_status := FND_CONCURRENT.Set_Completion_Status
6678: (status => 'COMPLETE', message => NULL);
6679:
6680: RETURN;
6681: END IF;

Line 6710: l_ret_status := FND_CONCURRENT.Set_Completion_Status

6706: -- GL Budget Extraction program has failed.
6707: raise FIIBUUP_fatal_err;
6708: ELSIF (l_ret_code = 'W') THEN
6709: -- GL Budget Extraction program ends with warnings.
6710: l_ret_status := FND_CONCURRENT.Set_Completion_Status
6711: (status => 'WARNING', message => NULL);
6712:
6713: RETURN;
6714: ELSE

Line 6720: l_ret_status := FND_CONCURRENT.Set_Completion_Status

6716: IF (FIIBUUP_DEBUG) THEN
6717: FII_MESSAGE.Func_Succ(func_name => 'FII_BUDGET_FORECAST_C.Main');
6718: END IF;
6719:
6720: l_ret_status := FND_CONCURRENT.Set_Completion_Status
6721: (status => 'COMPLETE', message => NULL);
6722:
6723: RETURN;
6724: END IF;

Line 7010: l_ret_status := FND_CONCURRENT.Set_Completion_Status

7006: raise FIIBUUP_fatal_err;
7007:
7008: ELSIF (l_ret_code = 'W') THEN
7009: -- PSI Budget Extraction program ends with warnings.
7010: l_ret_status := FND_CONCURRENT.Set_Completion_Status
7011: (status => 'WARNING', message => NULL);
7012:
7013: RETURN;
7014:

Line 7020: l_ret_status := FND_CONCURRENT.Set_Completion_Status

7016: IF (FIIBUUP_DEBUG) THEN
7017: FII_MESSAGE.Func_Succ(func_name => 'FII_BUDGET_FORECAST_C.Main');
7018: END IF;
7019:
7020: l_ret_status := FND_CONCURRENT.Set_Completion_Status
7021: (status => 'COMPLETE', message => NULL);
7022: RETURN;
7023: END IF;
7024: END IF;

Line 7275: FND_CONCURRENT.Af_Commit;

7271: END IF;
7272:
7273: END IF;
7274:
7275: FND_CONCURRENT.Af_Commit;
7276:
7277: IF (l_time_unit_changed) THEN
7278: raise FIIBUUP_fatal_err;
7279: END IF;

Line 7320: FND_CONCURRENT.Af_Commit;

7316:
7317: g_phase := 'Truncate the staging table FII_BUDGET_STG';
7318: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);
7319:
7320: FND_CONCURRENT.Af_Commit;
7321:
7322: -- Check if there is anything to upload. If nothing,
7323: -- exit normally.
7324:

Line 7341: l_ret_status := FND_CONCURRENT.Set_Completion_Status

7337: IF (FIIBUUP_DEBUG) THEN
7338: FII_MESSAGE.Func_Succ(func_name => 'FII_BUDGET_FORECAST_C.Main');
7339: END IF;
7340:
7341: l_ret_status := FND_CONCURRENT.Set_Completion_Status
7342: (status => 'COMPLETE', message => NULL);
7343:
7344: RETURN;
7345: END IF;

Line 7378: l_ret_status := FND_CONCURRENT.Set_Completion_Status

7374: IF (FIIBUUP_DEBUG) THEN
7375: FII_MESSAGE.Func_Succ(func_name => 'FII_BUDGET_FORECAST_C.Main');
7376: END IF;
7377:
7378: l_ret_status := FND_CONCURRENT.Set_Completion_Status
7379: (status => 'WARNING', message => NULL);
7380: RETURN;
7381: END IF;
7382:

Line 7566: FND_CONCURRENT.Af_Commit;

7562: END IF;
7563: END IF;
7564: END IF;
7565:
7566: FND_CONCURRENT.Af_Commit;
7567:
7568: -- Bug 4674640: Added gather stats for the budget base table
7569: FND_STATS.gather_table_stats
7570: (ownname => l_fii_schema,

Line 7579: l_ret_status := FND_CONCURRENT.Set_Completion_Status

7575: IF (FIIBUUP_DEBUG) THEN
7576: FII_MESSAGE.Func_Succ(func_name => 'FII_BUDGET_FORECAST_C.Main');
7577: END IF;
7578:
7579: l_ret_status := FND_CONCURRENT.Set_Completion_Status
7580: (status => 'COMPLETE', message => NULL);
7581:
7582: EXCEPTION
7583: WHEN FIIBUUP_fatal_err THEN

Line 7585: FND_CONCURRENT.Af_Rollback;

7581:
7582: EXCEPTION
7583: WHEN FIIBUUP_fatal_err THEN
7584:
7585: FND_CONCURRENT.Af_Rollback;
7586:
7587: FII_MESSAGE.Write_Log
7588: (msg_name => 'FII_ERR_ENC_ROUT',
7589: token_num => 1,

Line 7598: l_ret_status := FND_CONCURRENT.Set_Completion_Status

7594:
7595: fii_util.put_line ('Phase: ' || g_phase ||
7596: 'Error: ' || sqlerrm);
7597:
7598: l_ret_status := FND_CONCURRENT.Set_Completion_Status
7599: (status => 'ERROR', message => substr(sqlerrm,1,180));
7600:
7601: WHEN OTHERS THEN
7602:

Line 7603: FND_CONCURRENT.Af_Rollback;

7599: (status => 'ERROR', message => substr(sqlerrm,1,180));
7600:
7601: WHEN OTHERS THEN
7602:
7603: FND_CONCURRENT.Af_Rollback;
7604:
7605: FII_MESSAGE.Write_Log(msg_name => 'FII_ERROR',
7606: token_num => 2,
7607: t1 => 'FUNCTION',

Line 7617: l_ret_status := FND_CONCURRENT.Set_Completion_Status

7613:
7614: fii_util.put_line ('Phase: ' || g_phase ||
7615: 'Error: ' || sqlerrm);
7616:
7617: l_ret_status := FND_CONCURRENT.Set_Completion_Status
7618: (status => 'ERROR', message => substr(sqlerrm,1,180));
7619: END Main;
7620:
7621: -------------------------------------------------------------------------------