[Home] [Help]
40: --| 16-jan-2003 vjavli Bug#2754073 fix: get_pending_tcount has |
41: --| additional parameter x_released_work_orders|
42: --| introduced in invoked procedure INVTTGP4 |
43: --| 18-Jul-2003 vjavli period close enhancement: INVTTGP4 is |
44: --| replaced with CST_AccountingPeriod_PUB with|
45: --| all the procedure parameters |
46: --| 18-Jul-2003 vjavli p_api_version assigned l_api_version |
47: --| 09-Sep-2003 vjavli NOCOPY added according to pl/sql standard |
48: --| 18-Sep-2003 vjavli verify_periodclose: verifications added |
81: --| scheduling check and Period end date |
82: --| validation. |
83: --| 09-Sep-2005 myerrams Modified the call to close_period procedure|
84: --| as per procedure signature in |
85: --| CST_AccountingPeriod_PUB. Bug: 4599201 |
86: --+=======================================================================+
87: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_MGD_PRD_CONTROL_MEDIATOR';
88: g_log_level NUMBER := NULL;
89:
1420: , p_acct_period_id => NULL
1421: );
1422:
1423:
1424: CST_AccountingPeriod_PUB.open_period
1425: ( p_api_version => l_api_version
1426: , p_org_id => p_org_hierarchy_origin
1427: , p_user_id => l_user_id
1428: , p_login_id => l_login_id
1782: ,' ======== Attempt to Open Period : ' || l_gl_period_future.open_period_name
1783: || ' ============================ ' );
1784: END IF;
1785:
1786: CST_AccountingPeriod_PUB.open_period
1787: ( p_api_version => l_api_version
1788: , p_org_id => l_orgid
1789: , p_user_id => l_user_id
1790: , p_login_id => l_login_id
1940:
1941: IF G_DEBUG = 'Y' THEN
1942: INV_ORGHIERARCHY_PVT.Log
1943: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1944: ,' Calling CST_AccountingPeriod_PUB.verify_periodclose for Org ID '
1945: || l_orgid
1946: );
1947:
1948: INV_ORGHIERARCHY_PVT.Log
1956: -- Bug: 3590042. Initialization of variable l_verify_flag is added.
1957: -- Verify flag for verify_periodclose
1958: l_verify_flag := 'Y';
1959:
1960: CST_AccountingPeriod_PUB.VERIFY_PERIODCLOSE
1961: ( p_api_version => l_api_version
1962: , p_org_id => l_orgid
1963: , p_closing_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
1964: , p_closing_end_date => l_org_acct_periods_val_open.schedule_close_date
2121: -- verify flag is 'Y'
2122: IF l_verify_flag = 'Y' THEN
2123: -- Bug#2230141 fix - check for all the pending transactions
2124: -- Bug#2386091 fix - added parameter pending_ship
2125: CST_AccountingPeriod_PUB.get_pendingtcount
2126: ( p_api_version => l_api_version
2127: , p_org_id => l_orgid
2128: , p_closing_period => l_org_acct_periods_val_open.closing_acct_period_id
2129: , p_sched_close_date => l_org_acct_periods_val_open.schedule_close_date
2190: );
2191: END IF;
2192:
2193: /* myerrams, Bug:4599201. Modified the call to
2194: * CST_AccountingPeriod_PUB.close_period because of a
2195: * change of the signature.
2196: * The following parameters are removed:
2197: * p_period_close_date
2198: * p_schedule_close_date
2201: * And the following parameters are newly added:
2202: * x_unprocessed_txns
2203: * x_rec_rpt_launch_failed
2204: */
2205: CST_AccountingPeriod_PUB.close_period
2206: ( p_api_version => l_api_version
2207: , p_org_id => l_orgid
2208: , p_user_id => l_user_id
2209: , p_login_id => l_login_id
2218:
2219: IF G_DEBUG = 'Y' THEN
2220: INV_ORGHIERARCHY_PVT.Log
2221: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2222: ,' Out of CST_AccountingPeriod_PUB.close_period for Org ID ' || l_orgid
2223: );
2224: END IF;
2225:
2226: IF (l_wip_failed) = true