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.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 51: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'Get_Period_Info_for_Counter');

47: RETURN TRUE;
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'Get_Period_Info_for_Counter');
52: RETURN FALSE;
53: END;
54:
55:

Line 83: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Non_Depreciating_Asset' ,'Non Depr Asset'||sqlerrm);

79: END IF;
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Non_Depreciating_Asset' ,'Non Depr Asset'||sqlerrm);
84: RETURN FALSE;
85:
86: END Non_Depreciating_Asset;
87:

Line 237: igi_iac_debug_pkg.debug_other_string(g_event_level,g_path||'submit_report_request','Submit Request'||l_message);

233: commit;
234: FND_MESSAGE.SET_NAME('IGI','IGI_IAC_SUBMIT_REQUEST');
235: FND_MESSAGE.SET_TOKEN('REQUEST_ID',l_request_id);
236: l_message:= fnd_message.get;
237: igi_iac_debug_pkg.debug_other_string(g_event_level,g_path||'submit_report_request','Submit Request'||l_message);
238:
239: END IF;
240: EXCEPTION
241: WHEN IGI_IAC_REQUEST_SUB_ERR then

Line 243: igi_iac_debug_pkg.debug_other_string(g_event_level,g_path||'submit_report_request','Submit Request'||l_message);

239: END IF;
240: EXCEPTION
241: WHEN IGI_IAC_REQUEST_SUB_ERR then
242: fnd_message.retrieve(l_message);
243: igi_iac_debug_pkg.debug_other_string(g_event_level,g_path||'submit_report_request','Submit Request'||l_message);
244: END submit_report_request;
245:
246: -- ===================================================================
247: -- FUNCTION Get_Price_Index_Val: get the price index value for the book,

Line 399: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Get_Reval_Prd_Dpis_Ctr' ,'Get Reval PC:'||'No Data found');

395: RETURN TRUE;
396:
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Get_Reval_Prd_Dpis_Ctr' ,'Get Reval PC:'||'No Data found');
400: RETURN FALSE;
401:
402: WHEN OTHERS THEN
403: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Reval_Prd_Dpis_Ctr','exception Raised ');

Line 403: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Reval_Prd_Dpis_Ctr','exception Raised ');

399: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Get_Reval_Prd_Dpis_Ctr' ,'Get Reval PC:'||'No Data found');
400: RETURN FALSE;
401:
402: WHEN OTHERS THEN
403: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Reval_Prd_Dpis_Ctr','exception Raised ');
404: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Reval_Prd_Dpis_Ctr','Get Reval PC:'||sqlerrm);
405: RETURN FALSE;
406:
407: END Get_Reval_Prd_Dpis_Ctr;

Line 404: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Reval_Prd_Dpis_Ctr','Get Reval PC:'||sqlerrm);

400: RETURN FALSE;
401:
402: WHEN OTHERS THEN
403: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Reval_Prd_Dpis_Ctr','exception Raised ');
404: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Reval_Prd_Dpis_Ctr','Get Reval PC:'||sqlerrm);
405: RETURN FALSE;
406:
407: END Get_Reval_Prd_Dpis_Ctr;
408:

Line 462: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Get_Next_Period_Ctr','Get Next PC: No Data Found');

458:
459: p_next_period_ctr:= (l_fiscal_yr*l_num_per_period)+l_next_period_num;
460: EXCEPTION
461: WHEN NO_DATA_FOUND THEN
462: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Get_Next_Period_Ctr','Get Next PC: No Data Found');
463: WHEN OTHERS THEN
464: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Next_Period_Ctr','Exception raised: '||sqlerrm);
465: END Get_Next_Period_Ctr;
466:

Line 464: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Next_Period_Ctr','Exception raised: '||sqlerrm);

460: EXCEPTION
461: WHEN NO_DATA_FOUND THEN
462: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Get_Next_Period_Ctr','Get Next PC: No Data Found');
463: WHEN OTHERS THEN
464: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Get_Next_Period_Ctr','Exception raised: '||sqlerrm);
465: END Get_Next_Period_Ctr;
466:
467: -- ===================================================================
468: -- FUNCTION Chk_Asset_Life: Find if the life of asset is completed in

Line 542: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Chk_Asset_Life','Check Asset Life'||sqlerrm);

538: END IF;
539:
540: EXCEPTION
541: WHEN OTHERS THEN
542: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Chk_Asset_Life','Check Asset Life'||sqlerrm);
543: raise_Application_error(-20001,SQLERRM);
544: rollback;
545: END Chk_Asset_Life;
546:

Line 1015: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Book type code: '||l_book_type_code);

1011:
1012: l_concat_cat := 'All';
1013: END IF;
1014:
1015: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Book type code: '||l_book_type_code);
1016: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','CAtegory Id: '||l_category_id);
1017: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Start period name: '||l_start_period_name);
1018: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','End Period name: '||l_end_period_name);
1019: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Revaluation Period number: '||l_reval_period_num);

Line 1016: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','CAtegory Id: '||l_category_id);

1012: l_concat_cat := 'All';
1013: END IF;
1014:
1015: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Book type code: '||l_book_type_code);
1016: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','CAtegory Id: '||l_category_id);
1017: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Start period name: '||l_start_period_name);
1018: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','End Period name: '||l_end_period_name);
1019: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Revaluation Period number: '||l_reval_period_num);
1020:

Line 1017: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Start period name: '||l_start_period_name);

1013: END IF;
1014:
1015: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Book type code: '||l_book_type_code);
1016: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','CAtegory Id: '||l_category_id);
1017: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Start period name: '||l_start_period_name);
1018: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','End Period name: '||l_end_period_name);
1019: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Revaluation Period number: '||l_reval_period_num);
1020:
1021: -- get the set of books id for the book

Line 1018: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','End Period name: '||l_end_period_name);

1014:
1015: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Book type code: '||l_book_type_code);
1016: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','CAtegory Id: '||l_category_id);
1017: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Start period name: '||l_start_period_name);
1018: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','End Period name: '||l_end_period_name);
1019: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Revaluation Period number: '||l_reval_period_num);
1020:
1021: -- get the set of books id for the book
1022: SELECT set_of_books_id

Line 1019: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Revaluation Period number: '||l_reval_period_num);

1015: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Book type code: '||l_book_type_code);
1016: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','CAtegory Id: '||l_category_id);
1017: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Start period name: '||l_start_period_name);
1018: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','End Period name: '||l_end_period_name);
1019: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc','Revaluation Period number: '||l_reval_period_num);
1020:
1021: -- get the set of books id for the book
1022: SELECT set_of_books_id
1023: INTO l_sob_id

Line 1035: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Getting assets for all IAC categories');

1031: FETCH c_get_assets_one_cat BULK COLLECT INTO l_assets_list;
1032: CLOSE c_get_assets_one_cat;
1033: ELSE
1034: -- if it is for all cats
1035: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Getting assets for all IAC categories');
1036: OPEN c_get_assets_all_cat(l_book_type_code, l_start_period_counter);
1037: FETCH c_get_assets_all_cat BULK COLLECT INTO l_assets_list;
1038: CLOSE c_get_assets_all_cat;
1039: END IF;

Line 1049: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Processing asset id: '||l_asset_id);

1045: LOOP
1046: -- get the asset position for the latest closed or depreciated period
1047: l_asset_id := l_assets_list(i);
1048:
1049: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Processing asset id: '||l_asset_id);
1050:
1051: -- get the dpis for the asset
1052: OPEN c_get_asset_dpis(l_asset_id,
1053: l_book_type_code);

Line 1085: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Exiting loop L_asset_loop');

1081: -- bug 3188025, start 2
1082: -- only inactive dists will have cost and deprn period 0 at the same time
1083: -- so filter these out now
1084: IF (l_get_asset_bal_rec.adjusted_cost = 0 AND l_get_asset_bal_rec.deprn_period = 0) THEN
1085: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Exiting loop L_asset_loop');
1086:
1087: EXIT L_asset_loop;
1088: END IF;
1089:

Line 1104: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Company: '||l_company_seg||' Cost Center: '||l_cc_seg);

1100: 'FA_COST_CTR',
1101: l_cc_seg);
1102:
1103:
1104: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Company: '||l_company_seg||' Cost Center: '||l_cc_seg);
1105:
1106: -- IF (l_fully_rsvd IS NOT NULL) THEN
1107: IF (l_get_asset_bal_rec.source_type = 'FULLRSVDFA') THEN
1108: -- asset is fully reserved

Line 1109: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Asset is fully reserved');

1105:
1106: -- IF (l_fully_rsvd IS NOT NULL) THEN
1107: IF (l_get_asset_bal_rec.source_type = 'FULLRSVDFA') THEN
1108: -- asset is fully reserved
1109: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Asset is fully reserved');
1110: l_count := l_count + 1;
1111:
1112: -- set the asset details for the projection record
1113: l_proj_rec.record_counter(l_count) := l_count;

Line 1139: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Asset is not a fully reserved asset, calculating projections');

1135: ELSE
1136: -- asset is not fully reserved
1137: -- do the projections calculations
1138:
1139: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Asset is not a fully reserved asset, calculating projections');
1140: -- initialise the period counter
1141: l_next_period_ctr := l_start_period_counter;
1142:
1143: l_prev_cost := l_get_asset_bal_rec.adjusted_cost;

Line 1158: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'The previous reval period is: ' || l_reval_period_ctr);

1154: l_get_asset_bal_rec.category_id,
1155: l_reval_period_ctr,
1156: l_prior_prd_index_val);
1157:
1158: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'The previous reval period is: ' || l_reval_period_ctr);
1159:
1160: -- calculate projections for the projection period while asset still has life
1161: -- and is not fully reserved
1162:

Line 1167: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Next period counter: '||l_next_period_ctr);

1163: WHILE ((l_next_period_ctr <= l_end_period_counter) AND
1164: chk_asset_life(l_book_type_code, l_next_period_ctr,l_asset_id, l_last_prd_counter))
1165: -- AND l_prev_cost >= 0)
1166: LOOP
1167: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Next period counter: '||l_next_period_ctr);
1168:
1169: -- increase the counter
1170: l_count := l_count + 1;
1171:

Line 1193: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Price Index Value: '||l_curr_price_index_val);

1189: l_ret_flag := get_price_index_val(l_book_type_code,
1190: l_get_asset_bal_rec.category_id,
1191: l_next_period_ctr,
1192: l_curr_price_index_val);
1193: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Price Index Value: '||l_curr_price_index_val);
1194:
1195: -- Bug 3139146, if PI is 9999.99 then do not calculate projections
1196: -- instead trap with exceptions code INVALID_PI
1197: IF (l_curr_price_index_val = 9999.99 OR l_prior_prd_index_val = 9999.99) THEN

Line 1200: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Invalid Price Index');

1196: -- instead trap with exceptions code INVALID_PI
1197: IF (l_curr_price_index_val = 9999.99 OR l_prior_prd_index_val = 9999.99) THEN
1198: -- set cost, deprn_period and ytd_deprn to 0
1199: -- set exception to INVALID_PI
1200: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Invalid Price Index');
1201: l_proj_rec.latest_reval_cost(l_count) := 0;
1202: l_proj_rec.deprn_period(l_count) := 0;
1203: l_proj_rec.deprn_ytd(l_count) := 0;
1204: l_proj_rec.asset_exception(l_count) := 'INVALID_PI';

Line 1215: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Non Depreciating IAC cost: '||l_iac_cost);

1211: l_next_period_ctr = l_start_period_counter) THEN
1212: OPEN c_iac_non_deprn(l_asset_id, l_book_type_code);
1213: FETCH c_iac_non_deprn INTO l_iac_cost;
1214: CLOSE c_iac_non_deprn;
1215: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Non Depreciating IAC cost: '||l_iac_cost);
1216: l_prev_cost := l_prev_cost + l_iac_cost;
1217: END IF;
1218:
1219: -- check if the period is a revaluation period or just a normal period

Line 1222: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'This is revaluation period number: '||l_reval_period_num);

1218:
1219: -- check if the period is a revaluation period or just a normal period
1220: -- to calculate the cost or the periodic depreciation amount
1221: IF (l_period_info_rec.period_num = l_reval_period_num) THEN
1222: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'This is revaluation period number: '||l_reval_period_num);
1223: -- this is the revaluation catchup period
1224: -- calculate the current cost
1225:
1226: l_curr_cost := l_prev_cost*(l_curr_price_index_val/l_prior_prd_index_val);

Line 1313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Before insertion into igi_iac_proj_details');

1309: END LOOP; -- end for c_get_asset_all loop
1310: END LOOP; -- end for l_asset_id loop
1311:
1312: IF (l_rec_count > 0) THEN
1313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Before insertion into igi_iac_proj_details');
1314: -- insert the projections into igi_iac_proj_details
1315: FORALL l_count IN l_proj_rec.record_counter.FIRST..l_proj_rec.record_counter.LAST
1316: INSERT INTO igi_iac_proj_details(
1317: projection_id,

Line 1350: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Insert complete');

1346: sysdate,
1347: l_user_id,
1348: sysdate,
1349: l_login_id);
1350: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Insert complete');
1351:
1352: -- submit the report
1353: igi_iac_debug_pkg.debug_other_string(g_event_level,g_path||'Do_Proj_Calc' ,'Submitted the RX Projections report');
1354: submit_report_request(p_projection_id,

Line 1353: igi_iac_debug_pkg.debug_other_string(g_event_level,g_path||'Do_Proj_Calc' ,'Submitted the RX Projections report');

1349: l_login_id);
1350: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'Do_Proj_Calc' ,'Insert complete');
1351:
1352: -- submit the report
1353: igi_iac_debug_pkg.debug_other_string(g_event_level,g_path||'Do_Proj_Calc' ,'Submitted the RX Projections report');
1354: submit_report_request(p_projection_id,
1355: l_book_type_code,
1356: l_reval_period_num,
1357: l_concat_cat,

Line 1370: igi_iac_debug_pkg.debug_other_msg(g_event_level,g_path||'Do_Proj_Calc',TRUE);

1366: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1367: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1368: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Projections completed successfully');
1369:
1370: igi_iac_debug_pkg.debug_other_msg(g_event_level,g_path||'Do_Proj_Calc',TRUE);
1371: errbuf := fnd_message.get;
1372: retcode := 0;
1373: -- ROLLBACK;
1374: EXCEPTION

Line 1377: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'Projection submission information could not be found ');

1373: -- ROLLBACK;
1374: EXCEPTION
1375: WHEN NO_PROJ_MAIN_DATA then
1376: Update_Status(p_projection_id, 'ERROR');
1377: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'Projection submission information could not be found ');
1378: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1379: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1380: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Projection submission information could not be found ');
1381:

Line 1382: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);

1378: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1379: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1380: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Projection submission information could not be found ');
1381:
1382: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1383: errbuf := fnd_message.get;
1384: retcode := 2;
1385: WHEN NO_DATA_FOUND then
1386: Update_Status(p_projection_id, 'ERROR');

Line 1387: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No data found '||sqlerrm);

1383: errbuf := fnd_message.get;
1384: retcode := 2;
1385: WHEN NO_DATA_FOUND then
1386: Update_Status(p_projection_id, 'ERROR');
1387: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No data found '||sqlerrm);
1388: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1389: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1390: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No data found '||sqlerrm);
1391:

Line 1392: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);

1388: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1389: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1390: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No data found '||sqlerrm);
1391:
1392: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1393: errbuf := fnd_message.get;
1394: retcode := 2;
1395: WHEN NO_ASSETS_FOUND then
1396: Update_Status(p_projection_id, 'ERROR');

Line 1397: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No assets are present for this book and category . Hence projections is not run ');

1393: errbuf := fnd_message.get;
1394: retcode := 2;
1395: WHEN NO_ASSETS_FOUND then
1396: Update_Status(p_projection_id, 'ERROR');
1397: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No assets are present for this book and category . Hence projections is not run ');
1398: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1399: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1400: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No assets are present for this book and category . Hence projections is not run ');
1401:

Line 1402: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);

1398: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1399: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1400: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No assets are present for this book and category . Hence projections is not run ');
1401:
1402: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1403: errbuf := fnd_message.get;
1404: retcode := 2;
1405: WHEN NO_INDEX_FOUND then
1406: Update_Status(p_projection_id, 'ERROR');

Line 1407: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No Price index value found for this calendar and price index ');

1403: errbuf := fnd_message.get;
1404: retcode := 2;
1405: WHEN NO_INDEX_FOUND then
1406: Update_Status(p_projection_id, 'ERROR');
1407: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No Price index value found for this calendar and price index ');
1408: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1409: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1410: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No Price index value found for this calendar and price index ');
1411:

Line 1412: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);

1408: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1409: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1410: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No Price index value found for this calendar and price index ');
1411:
1412: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1413: errbuf := fnd_message.get;
1414: retcode := 2;
1415: WHEN NO_ASSETS_TO_PROJECT then
1416: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No assets have been selected for Projections. Hence, report not submitted');

Line 1416: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No assets have been selected for Projections. Hence, report not submitted');

1412: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1413: errbuf := fnd_message.get;
1414: retcode := 2;
1415: WHEN NO_ASSETS_TO_PROJECT then
1416: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path||'Do_Proj_Calc' ,'No assets have been selected for Projections. Hence, report not submitted');
1417: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1418: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1419: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No assets have been selected for Projections. Hence, report not submitted');
1420:

Line 1421: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);

1417: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1418: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1419: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','No assets have been selected for Projections. Hence, report not submitted');
1420:
1421: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1422: errbuf := fnd_message.get;
1423: retcode := 0;
1424: WHEN OTHERS THEN
1425: Update_Status(p_projection_id, 'ERROR');

Line 1426: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Do_Proj_Calc' ,sqlerrm);

1422: errbuf := fnd_message.get;
1423: retcode := 0;
1424: WHEN OTHERS THEN
1425: Update_Status(p_projection_id, 'ERROR');
1426: igi_iac_debug_pkg.debug_other_string(g_unexp_level,g_path||'Do_Proj_Calc' ,sqlerrm);
1427: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1428: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1429: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',sqlerrm);
1430:

Line 1431: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);

1427: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1428: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_proj_pkg');
1429: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',sqlerrm);
1430:
1431: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'Do_Proj_Calc',FALSE);
1432: errbuf := fnd_message.get;
1433: retcode := 2;
1434: END Do_Proj_Calc;
1435: