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_IMP_IAC_EXCEP_INER_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 56: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_period_name ' || l_period_name);

52: IF NOT l_selOk THEN
53: RETURN FALSE;
54: END IF;
55:
56: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_period_name ' || l_period_name);
57: RETURN TRUE;
58:
59: EXCEPTION
60: WHEN OTHERS THEN

Line 61: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Exception within "get_period_name" : '|| sqlerrm);

57: RETURN TRUE;
58:
59: EXCEPTION
60: WHEN OTHERS THEN
61: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Exception within "get_period_name" : '|| sqlerrm);
62: RETURN FALSE;
63: END get_period_name;
64:
65: FUNCTION get_flex_segments (p_book IN VARCHAR2 )

Line 111: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);

107: IF NOT l_selOk THEN
108: RETURN FALSE;
109: END IF;
110:
111: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
112: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);

Line 112: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);

108: RETURN FALSE;
109: END IF;
110:
111: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
112: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
116: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fiscal_year_name ' || l_fiscal_year_name);

Line 113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);

109: END IF;
110:
111: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
112: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
116: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fiscal_year_name ' || l_fiscal_year_name);
117: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);

Line 114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);

110:
111: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
112: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
116: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fiscal_year_name ' || l_fiscal_year_name);
117: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
118:

Line 115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);

111: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
112: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
116: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fiscal_year_name ' || l_fiscal_year_name);
117: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
118:
119: l_g_loc_struct := l_loc_struct;

Line 116: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fiscal_year_name ' || l_fiscal_year_name);

112: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
116: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fiscal_year_name ' || l_fiscal_year_name);
117: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
118:
119: l_g_loc_struct := l_loc_struct;
120: l_g_asset_key_struct := l_asset_key_struct;

Line 117: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);

113: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
114: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
115: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
116: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_fiscal_year_name ' || l_fiscal_year_name);
117: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
118:
119: l_g_loc_struct := l_loc_struct;
120: l_g_asset_key_struct := l_asset_key_struct;
121: l_g_cat_struct := l_cat_struct;

Line 125: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within "get_flex_segments" : '|| sqlerrm);

121: l_g_cat_struct := l_cat_struct;
122: RETURN TRUE;
123: EXCEPTION
124: WHEN OTHERS THEN
125: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within "get_flex_segments" : '|| sqlerrm);
126: RETURN FALSE;
127:
128: END get_flex_segments;
129:

Line 293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Failed to get the Flex Segments period name - will continue.... ');

289: delete from IGI_IMP_IAC_EXCEP_REP_ITF ;
290:
291: -- mh, If get_flex_segments (p_book)THEN
292: IF NOT get_flex_segments (p_book) THEN
293: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Failed to get the Flex Segments period name - will continue.... ');
294: End If;
295:
296: -- mh, If get_period_name ( p_book, p_period)THEN
297: IF NOT get_period_name ( p_book, p_period) THEN

Line 298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Failed to get the period name - will continue.... ');

294: End If;
295:
296: -- mh, If get_period_name ( p_book, p_period)THEN
297: IF NOT get_period_name ( p_book, p_period) THEN
298: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Failed to get the period name - will continue.... ');
299: End If;
300:
301:
302: -- bug 3442275, start 2

Line 403: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

399: l_dpis_prd_counter <= l_curr_prd_counter) THEN
400:
401: -- list the asset as an exception
402: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');
403: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
404: l_message := Fnd_message.get;
405:
406: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
407: request_id,

Line 459: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

455:
456: IF l_initial_flag ='N' then
457: If C_Mhca_Book_Info_Rec.period_counter_fully_retired is not null then
458: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');
459: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
460: l_message := Fnd_message.get;
461:
462: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
463: request_id,

Line 514: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

510:
511: IF l_initial_flag ='N' then
512: If sign(C_Mhca_Book_Info_Rec.cost) = -1 then
513: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');
514: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
515: l_message := Fnd_message.get;
516:
517: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
518: request_id,

Line 569: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

565:
566: IF l_initial_flag ='N' then
567: If (C_Corp_Book_Info_Rec.life_in_months - C_Mhca_Book_Info_Rec.life_in_months )<> 0 then
568: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_LIFE');
569: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
570: l_message := Fnd_message.get;
571:
572: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
573: request_id,

Line 624: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

620:
621: IF l_initial_flag ='N' then
622: If trunc(C_Mhca_Book_Info_Rec.date_placed_in_service) <> trunc(C_Corp_Book_Info_Rec.date_placed_in_service)then
623: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_DPIS');
624: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
625: l_message := Fnd_message.get;
626:
627: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
628: request_id,

Line 679: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

675:
676: IF l_initial_flag ='N' then
677: If (C_Mhca_Book_Info_Rec.salvage_value - C_Corp_Book_Info_Rec.salvage_value) <> 0 then
678: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_SALVAGE');
679: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
680: l_message := Fnd_message.get;
681:
682: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
683: request_id,

Line 744: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

740: OR nvl(c_corp_book_info_rec.ytd_deprn,0) <> 0) THEN
741: -- bug 3464589, end 1
742:
743: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NONDEPRN_ASSET');
744: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
745: l_message := Fnd_message.get;
746:
747: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
748: request_id,

Line 806: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

802: If (abs((nvl(C_Mhca_Reval_Summary_Info_Rec.new_asset_cost,0) - nvl(C_Mhca_Reval_Summary_Info_Rec.new_reval_reserve,0))
803: - C_Corp_Book_Info_Rec.cost ) > 0.05 ) then
804:
805: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_ASSET_COST');
806: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
807: l_message := Fnd_message.get;
808:
809: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
810: request_id,

Line 879: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,TRUE);

875: l_dpis_prd_counter <= l_curr_prd_counter) THEN
876:
877: -- list the asset as an exception
878: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_DPIS_REVAL_EXCEPTION');
879: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,TRUE);
880: l_message := Fnd_message.get;
881:
882: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (
883: request_id,

Line 939: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

935: IF l_initial_flag ='N' THEN
936: -- bug 3476361, end 1
937: If C_Corp_Book_Info_Rec.period_counter_fully_retired is not null then
938: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_FULLY_RETRIED');
939: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
940: l_message := Fnd_message.get;
941:
942: insert into IGI_IMP_IAC_EXCEP_REP_ITF (
943: request_id,

Line 996: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

992:
993: IF l_initial_flag ='N' then
994: If sign(C_Corp_Book_Info_Rec.cost) = -1 then
995: FND_MESSAGE.SET_Name ('IGI', 'IGI_IMP_NEGATIVE_COST');
996: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
997: l_message := Fnd_message.get;
998:
999:
1000: insert into IGI_IMP_IAC_EXCEP_REP_ITF (

Line 1059: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);

1055: OR nvl(c_corp_book_info_rec.ytd_deprn,0) <> 0) THEN
1056:
1057:
1058: FND_MESSAGE.SET_NAME ('IGI', 'IGI_IMP_NONDEPRN_ASSET');
1059: igi_iac_debug_pkg.debug_other_msg(g_state_level,l_path,FALSE);
1060: l_message := Fnd_message.get;
1061:
1062:
1063: INSERT INTO IGI_IMP_IAC_EXCEP_REP_ITF (