[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:
1434: , p_acct_period_id => NULL
1435: );
1436:
1437: l_start_time := sysdate;
1438: CST_AccountingPeriod_PUB.open_period
1439: ( p_api_version => l_api_version
1440: , p_org_id => p_org_hierarchy_origin
1441: , p_user_id => l_user_id
1442: , p_login_id => l_login_id
1892: || ' ============================ ' );
1893: END IF;
1894:
1895: l_start_time := sysdate;
1896: CST_AccountingPeriod_PUB.open_period
1897: ( p_api_version => l_api_version
1898: , p_org_id => l_orgid
1899: , p_user_id => l_user_id
1900: , p_login_id => l_login_id
2143:
2144: IF G_DEBUG = 'Y' THEN
2145: INV_ORGHIERARCHY_PVT.Log
2146: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2147: ,' Calling CST_AccountingPeriod_PUB.verify_periodclose for Org ID '
2148: || l_orgid
2149: );
2150:
2151: INV_ORGHIERARCHY_PVT.Log
2159: -- Bug: 3590042. Initialization of variable l_verify_flag is added.
2160: -- Verify flag for verify_periodclose
2161: l_verify_flag := 'Y';
2162:
2163: CST_AccountingPeriod_PUB.VERIFY_PERIODCLOSE
2164: ( p_api_version => l_api_version
2165: , p_org_id => l_orgid
2166: , p_closing_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2167: , p_closing_end_date => l_org_acct_periods_val_open.schedule_close_date
2324: -- verify flag is 'Y'
2325: IF l_verify_flag = 'Y' THEN
2326: -- Bug#2230141 fix - check for all the pending transactions
2327: -- Bug#2386091 fix - added parameter pending_ship
2328: CST_AccountingPeriod_PUB.get_pendingtcount
2329: ( p_api_version => l_api_version
2330: , p_org_id => l_orgid
2331: , p_closing_period => l_org_acct_periods_val_open.closing_acct_period_id
2332: , p_sched_close_date => l_org_acct_periods_val_open.schedule_close_date
2393: );
2394: END IF;
2395:
2396: /* myerrams, Bug:4599201. Modified the call to
2397: * CST_AccountingPeriod_PUB.close_period because of a
2398: * change of the signature.
2399: * The following parameters are removed:
2400: * p_period_close_date
2401: * p_schedule_close_date
2404: * And the following parameters are newly added:
2405: * x_unprocessed_txns
2406: * x_rec_rpt_launch_failed
2407: */
2408: CST_AccountingPeriod_PUB.close_period
2409: ( p_api_version => l_api_version
2410: , p_org_id => l_orgid
2411: , p_user_id => l_user_id
2412: , p_login_id => l_login_id
2421:
2422: IF G_DEBUG = 'Y' THEN
2423: INV_ORGHIERARCHY_PVT.Log
2424: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2425: ,' Out of CST_AccountingPeriod_PUB.close_period for Org ID ' || l_orgid
2426: );
2427: END IF;
2428:
2429: IF (l_wip_failed) = true