DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on IGI_IAC_DEBUG_PKG

Line 63: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

59: RETURN TRUE;
60:
61: EXCEPTION
62: WHEN OTHERS THEN
63: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
64: RETURN FALSE;
65: END;
66:
67:

Line 111: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

107: RETURN TRUE;
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
112: RETURN FALSE;
113: END;
114:
115:

Line 158: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

154: RETURN TRUE;
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
159: RETURN FALSE;
160: END;
161:
162:

Line 183: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

179: RETURN TRUE;
180:
181: EXCEPTION
182: WHEN OTHERS THEN
183: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
184: RETURN FALSE;
185: END;
186:
187:

Line 223: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

219: RETURN TRUE ;
220:
221: EXCEPTION
222: WHEN OTHERS THEN
223: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
224: RETURN FALSE;
225: END ;
226:
227:

Line 271: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

267: RETURN TRUE ;
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
272: RETURN FALSE;
273: END ;
274:
275:

Line 304: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

300:
301: RETURN TRUE;
302: EXCEPTION
303: WHEN OTHERS THEN
304: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
305: RETURN FALSE;
306: END;
307:
308:

Line 349: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

345: END IF;
346: RETURN TRUE;
347: EXCEPTION
348: WHEN OTHERS THEN
349: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
350: RETURN FALSE;
351: END;
352:
353:

Line 412: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

408:
409: RETURN TRUE;
410: EXCEPTION
411: WHEN OTHERS THEN
412: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
413: RETURN FALSE;
414: END;
415:
416:

Line 453: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

449:
450: RETURN TRUE;
451: EXCEPTION
452: WHEN OTHERS THEN
453: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
454: RETURN FALSE;
455: END ;
456:
457:

Line 505: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

501: RETURN TRUE;
502:
503: EXCEPTION
504: WHEN OTHERS THEN
505: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
506: RETURN FALSE;
507: END ;
508:
509:

Line 547: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

543: RETURN FALSE ;
544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
548: RETURN FALSE;
549: END ;
550:
551:

Line 582: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

578: RETURN FALSE ;
579:
580: EXCEPTION
581: WHEN OTHERS THEN
582: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
583: RETURN FALSE;
584: END;
585:
586:

Line 616: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

612: RETURN FALSE ;
613:
614: EXCEPTION
615: WHEN OTHERS THEN
616: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
617: RETURN FALSE;
618: END;
619:
620:

Line 649: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

645: RETURN FALSE ;
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
650: RETURN FALSE;
651: END;
652:
653:

Line 726: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

722: RETURN TRUE ;
723:
724: EXCEPTION
725: WHEN OTHERS THEN
726: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
727: RETURN FALSE;
728: END;
729:
730: -- DMahajan End

Line 762: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

758: RETURN FALSE;
759: END IF;
760: EXCEPTION
761: WHEN OTHERS THEN
762: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
763: RETURN FALSE ;
764: END;
765:
766: FUNCTION Get_Dpis_Period_Counter (

Line 828: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

824: RETURN FALSE;
825: END IF;
826: EXCEPTION
827: WHEN OTHERS THEN
828: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
829: RETURN FALSE ;
830: END;
831:
832:

Line 874: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

870: RETURN TRUE;
871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
875: RETURN FALSE ;
876:
877: End;
878:

Line 938: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

934: close dep_cal;
935: End If;
936: Exception
937: WHEN OTHERS THEN
938: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
939: Raise_application_Error (-20000, SQLERRM);
940: End;
941:
942: for l_cat in cat LOOP

Line 963: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

959: RETURN TRUE;
960:
961: EXCEPTION
962: WHEN OTHERS THEN
963: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
964: RETURN FALSE ;
965:
966: End;
967:

Line 1000: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

996: RETURN FALSE;
997: END IF;
998: EXCEPTION
999: WHEN OTHERS THEN
1000: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1001: RETURN FALSE ;
1002: END; -- is_iac_book
1003:
1004:

Line 1130: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1126: END IF;
1127: return FALSE;
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1131: return FALSE;
1132: END Get_Latest_Transaction;
1133:
1134:

Line 1206: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1202: RETURN FALSE;
1203: End if;
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1207: RETURN FALSE;
1208: END;-- Get_Book_GL_Info;
1209:
1210: /*

Line 1252: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1248: X_segment_value := l_sel_column;
1249: RETURN TRUE ;
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1253: RETURN FALSE ;
1254: END Get_Account_Segment_Value;
1255:
1256: FUNCTION Get_Distribution_Ccid (

Line 1289: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1285: END IF;
1286: RETURN FALSE;
1287: EXCEPTION
1288: WHEN OTHERS THEN
1289: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1290: RETURN FALSE ;
1291: END;-- Get_Distribution_Ccid;
1292:
1293: FUNCTION Get_Default_Account (

Line 1316: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1312: END IF;
1313: RETURN FALSE;
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1317: RETURN FALSE ;
1318: END;-- Get_Default_Account;
1319:
1320: -- For FND logging, this function is aliased as get_account_ccid1 since this is an overloaded

Line 1502: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1498: X_asset_id,
1499: X_distribution_id,
1500: l_distribution_ccid) THEN
1501: Null;
1502: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1503: p_full_path => l_path_name,
1504: p_string => 'get distribution sucessfull ..'|| l_distribution_ccid);
1505: ELSE
1506: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1506: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1502: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1503: p_full_path => l_path_name,
1504: p_string => 'get distribution sucessfull ..'|| l_distribution_ccid);
1505: ELSE
1506: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1507: p_full_path => l_path_name,
1508: p_string => 'get distribution failed ..'|| l_distribution_ccid);
1509: Account_ccid := -1;
1510: RETURN FALSE;

Line 1517: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1513: /* get the deault ccid from fa book controls */
1514: IF get_default_account ( X_book_type_code,
1515: l_default_ccid)THEN
1516:
1517: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1518: p_full_path => l_path_name,
1519: p_string => 'get default account sucessfull ..'|| l_default_ccid);
1520: Null;
1521: ELSE

Line 1522: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1518: p_full_path => l_path_name,
1519: p_string => 'get default account sucessfull ..'|| l_default_ccid);
1520: Null;
1521: ELSE
1522: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1523: p_full_path => l_path_name,
1524: p_string => 'get default account failed..'|| l_default_ccid);
1525: Account_ccid := -1;
1526: RETURN FALSE;

Line 1535: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1531: l_set_of_books_id,
1532: l_chart_of_accounts_id,
1533: l_currency,
1534: l_precision ) THEN
1535: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1536: p_full_path => l_path_name,
1537: p_string => 'get gl info sucessfull ..'|| l_chart_of_accounts_id);
1538: Null;
1539: ELSE

Line 1540: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1536: p_full_path => l_path_name,
1537: p_string => 'get gl info sucessfull ..'|| l_chart_of_accounts_id);
1538: Null;
1539: ELSE
1540: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1541: p_full_path => l_path_name,
1542: p_string => 'get gl info failed ..'|| l_chart_of_accounts_id);
1543: Account_ccid := -1;
1544: RETURN FALSE;

Line 1562: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1558: IF NOT get_iac_category_id%FOUND THEN
1559: OPEN get_category_id;
1560: FETCH get_category_id into l_asset_category_id;
1561: IF NOT get_category_id%FOUND THEN
1562: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1563: p_full_path => l_path_name,
1564: p_string => 'get asset id failed ..'||l_asset_category_id);
1565: Close get_category_id;
1566: Account_ccid := -1;

Line 1569: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1565: Close get_category_id;
1566: Account_ccid := -1;
1567: RETURN FALSE;
1568: END IF;
1569: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1570: p_full_path => l_path_name,
1571: p_string => 'get asset id success..'||l_asset_category_id);
1572: CLOSE get_category_id;
1573: END IF;

Line 1583: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1579: l_operation_expense_ccid,
1580: l_reval_reserve_ccid,
1581: l_reval_reserve_retired_ccid;
1582: IF NOT get_category_accounts%FOUND THEN
1583: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1584: p_full_path => l_path_name,
1585: p_string => 'get account ccid form iac books failed ..'||l_account_ccid);
1586: CLOSE get_category_accounts;
1587: Account_ccid := -1;

Line 1591: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1587: Account_ccid := -1;
1588: RETURN FALSE;
1589: END IF;
1590:
1591: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1592: p_full_path => l_path_name,
1593: p_string => '+ get ccid call account type'||x_account_type);
1594:
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1591: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1592: p_full_path => l_path_name,
1593: p_string => '+ get ccid call account type'||x_account_type);
1594:
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1596: p_full_path => l_path_name,
1597: p_string => '+ get ccid call account type'||x_account_type);
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,

Line 1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1594:
1595: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1596: p_full_path => l_path_name,
1597: p_string => '+ get ccid call account type'||x_account_type);
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,
1600: p_string => '+ get ccid call get_category_accounts back log '||to_char(l_back_deprn_rsv_ccid));
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,

Line 1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1597: p_string => '+ get ccid call account type'||x_account_type);
1598: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1599: p_full_path => l_path_name,
1600: p_string => '+ get ccid call get_category_accounts back log '||to_char(l_back_deprn_rsv_ccid));
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,
1603: p_string => '+get ccid call get_category_accounts general fund '||to_char(l_general_fund_ccid));
1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1605: p_full_path => l_path_name,

Line 1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1600: p_string => '+ get ccid call get_category_accounts back log '||to_char(l_back_deprn_rsv_ccid));
1601: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1602: p_full_path => l_path_name,
1603: p_string => '+get ccid call get_category_accounts general fund '||to_char(l_general_fund_ccid));
1604: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1605: p_full_path => l_path_name,
1606: p_string => '+ get ccid call get_category_accounts oper exp'||to_char(l_operation_expense_ccid));
1607:
1608: IF X_account_Type = 'BACKLOG_DEPRN_RSV_ACCT' THEN

Line 1625: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1621: IF NOT Get_account_segment_value (l_set_of_books_id,
1622: l_account_ccid,
1623: 'GL_ACCOUNT',
1624: l_account_value) THEN
1625: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1626: p_full_path => l_path_name,
1627: p_string => '+ get gl-account failed '|| l_account_value);
1628: Account_ccid := -1;
1629: RETURN FALSE;

Line 1631: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1627: p_string => '+ get gl-account failed '|| l_account_value);
1628: Account_ccid := -1;
1629: RETURN FALSE;
1630: END IF;
1631: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1632: p_full_path => l_path_name,
1633: p_string => '+ get gl-account success '|| l_account_value);
1634:
1635: IF NOT IGI_IAC_WF_PKG.Start_process (

Line 1647: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1643: X_distribution_id => X_distribution_id,
1644: X_workflowprocess => 'IGIIACWF',
1645: X_RETURN_ccid => account_ccid ) THEN
1646:
1647: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1648: p_full_path => l_path_name,
1649: p_string => '+ get ccid call wf failed '||to_char(account_ccid));
1650:
1651: Account_ccid := -1;

Line 1654: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1650:
1651: Account_ccid := -1;
1652: RETURN FALSE;
1653: ELSE
1654: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1655: p_full_path => l_path_name,
1656: p_string => '+ get ccid call wf sucess '||to_char(account_ccid));
1657: RETURN TRUE;
1658: END IF;

Line 1690: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1686: X_distribution_id => X_distribution_id,
1687: X_workflowprocess => 'IGIIACWF',
1688: X_RETURN_ccid => account_ccid ) THEN
1689:
1690: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1691: p_full_path => l_path_name,
1692: p_string => '+ get ccid call wf failed '||to_char(account_ccid));
1693:
1694: Account_ccid := -1;

Line 1697: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1693:
1694: Account_ccid := -1;
1695: RETURN FALSE;
1696: ELSE
1697: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1698: p_full_path => l_path_name,
1699: p_string => '+ get ccid call wf sucess '||to_char(account_ccid));
1700: RETURN TRUE;
1701: END IF;

Line 1820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1816: X_rtn_ccid => account_ccid,
1817: X_concat_segs => x_concat_segs,
1818: X_return_value => x_return_value);
1819:
1820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1821: p_full_path => l_path_name,
1822: p_string => '+ get ccid call FA wf success = >'||to_char(account_ccid));
1823: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1824: p_full_path => l_path_name,

Line 1823: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1819:
1820: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1821: p_full_path => l_path_name,
1822: p_string => '+ get ccid call FA wf success = >'||to_char(account_ccid));
1823: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1824: p_full_path => l_path_name,
1825: p_string => '+ get ccid call FA wf return value = >'||to_char(x_return_value));
1826:
1827: IF (x_return_value = 0) then

Line 1936: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1932: /* get the deault ccid from fa book controls */
1933: IF get_default_account ( X_book_type_code,
1934: l_default_ccid)THEN
1935:
1936: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1937: p_full_path => l_path_name,
1938: p_string => 'get default account sucessfull ..'|| l_default_ccid);
1939: Null;
1940: ELSE

Line 1941: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1937: p_full_path => l_path_name,
1938: p_string => 'get default account sucessfull ..'|| l_default_ccid);
1939: Null;
1940: ELSE
1941: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1942: p_full_path => l_path_name,
1943: p_string => 'get default account failed..'|| l_default_ccid);
1944: Account_ccid := -1;
1945: RETURN FALSE;

Line 2102: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

2098: X_Book);
2099: return TRUE;
2100: EXCEPTION
2101: WHEN OTHERS THEN
2102: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
2103: return FALSE ;
2104: END Iac_Round;
2105:
2106: -- M Hazarika, 07-05-2002 end

Line 2145: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

2141: END IF;
2142: END IF;
2143:
2144: EXCEPTION WHEN OTHERS THEN
2145: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
2146: RETURN FALSE;
2147: END populate_iac_fa_deprn_data;
2148:
2149:

Line 2186: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2182: l_path_name := g_path||'Is_Asset_Adjustment_Done';
2183:
2184: --Fetch the current open period
2185: IF igi_iac_common_utils.get_open_period_info(X_book_type_code,l_prd_rec) THEN
2186: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2187: p_full_path => l_path_name,
2188: p_string => ' + Current Open Period counter'
2189: ||l_prd_rec.period_counter );
2190: ELSE

Line 2191: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2187: p_full_path => l_path_name,
2188: p_string => ' + Current Open Period counter'
2189: ||l_prd_rec.period_counter );
2190: ELSE
2191: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2192: p_full_path => l_path_name,
2193: p_string => ' + Error while fetching open period information
2194: + Current Open Period counter' ||l_prd_rec.period_counter );
2195: END IF;