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.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on ORG_ACCT_PERIODS

Line 149: org_acct_periods oop

145: OPEN_FLAG
146: INTO
147: l_open_flag
148: FROM
149: org_acct_periods oop
150: ,org_organization_definitions ood
151: WHERE oop.acct_period_id = p_acct_period_id
152: AND oop.organization_id = ood.organization_id
153: AND ood.organization_name = p_org;

Line 161: org_acct_periods oop

157: OPEN_FLAG
158: INTO
159: l_open_flag
160: FROM
161: org_acct_periods oop
162: ,HR_ORGANIZATION_UNITS HOU
163: WHERE oop.acct_period_id = p_acct_period_id
164: AND oop.organization_id = HOU.organization_id
165: AND HOU.name = p_org;

Line 538: org_acct_periods orgp

534: MAX( acct_period_id )
535: INTO
536: l_max_period_id
537: FROM
538: org_acct_periods orgp
539: WHERE orgp.organization_id = p_org_id
540: AND orgp.period_set_name = p_period_set_name
541: AND orgp.open_flag = 'Y' ;
542:

Line 576: , org_acct_periods orgp

572: , x_period_start_date
573: , x_period_end_date
574: FROM
575: gl_periods glp
576: , org_acct_periods orgp
577: WHERE glp.period_name = orgp.period_name
578: AND glp.period_set_name = p_period_set_name
579: AND glp.period_type = p_period_type
580: AND orgp.acct_period_id = l_max_period_id

Line 685: org_acct_periods orgp

681: MIN( acct_period_id )
682: INTO
683: l_min_period_id
684: FROM
685: org_acct_periods orgp
686: WHERE orgp.organization_id = p_org_id
687: AND orgp.period_set_name = p_period_set_name ;
688:
689: IF G_DEBUG = 'Y' THEN

Line 721: , org_acct_periods orgp

717: , x_period_start_date
718: , x_period_end_date
719: FROM
720: gl_periods glp
721: , org_acct_periods orgp
722: WHERE glp.period_name = orgp.period_name
723: AND glp.period_set_name = p_period_set_name
724: AND glp.period_type = p_period_type
725: AND orgp.acct_period_id = l_min_period_id

Line 914: l_max_open_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;

910: l_closed_if_res_recmd NUMBER := 0;
911:
912: l_allow_close varchar2(240);
913:
914: l_max_open_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;
915: l_max_open_period_start_date DATE;
916: l_max_open_period_end_date DATE;
917: l_max_period_start_date DATE;
918:

Line 948: FROM ORG_ACCT_PERIODS OAP

944: AND glp.period_type = l_sob_period_type
945: AND glp.PERIOD_SET_NAME = l_period_set_name
946: AND glp.PERIOD_NAME NOT IN
947: ( SELECT OAP.PERIOD_NAME
948: FROM ORG_ACCT_PERIODS OAP
949: WHERE OAP.PERIOD_SET_NAME = glp.PERIOD_SET_NAME
950: AND OAP.PERIOD_NAME = glp.PERIOD_NAME
951: AND OAP.organization_id = c_org_id
952: )

Line 964: CURSOR c_org_acct_periods_open IS

960: -- Select the periods from GL_PERIODS
961: -- that are eligible to be
962: -- Closed for a given Org
963:
964: CURSOR c_org_acct_periods_open IS
965: SELECT
966: orgp.rowid closing_rowid
967: , orgp.ACCT_PERIOD_ID closing_acct_period_id
968: , orgp.ORGANIZATION_ID organization_id

Line 977: org_acct_periods orgp

973: , orgp.PERIOD_NUM open_period_num
974: , orgp.PERIOD_NAME open_period_name
975: , orgp.open_flag open_flag
976: FROM
977: org_acct_periods orgp
978: WHERE orgp.period_name = p_close_period_name
979: AND orgp.organization_id = l_orgid
980: AND orgp.period_set_name = l_period_set_name ;
981:

Line 983: l_org_acct_periods_val_open c_org_acct_periods_open%ROWTYPE ;

979: AND orgp.organization_id = l_orgid
980: AND orgp.period_set_name = l_period_set_name ;
981:
982:
983: l_org_acct_periods_val_open c_org_acct_periods_open%ROWTYPE ;
984:
985: -- log error message
986: l_error_msg VARCHAR2(255);
987: --Initialization of variable l_verify_flag is removed. Bug: 3590042

Line 1012: -- FROM ORG_ACCT_PERIODS

1008: -- For this reason, this validation is transferred at backend.
1009: -- IF p_open_or_close_flag = 'C' THEN
1010: -- SELECT count(*)
1011: -- INTO l_count
1012: -- FROM ORG_ACCT_PERIODS
1013: -- WHERE SCHEDULE_CLOSE_DATE > SYSDATE
1014: -- AND PERIOD_NAME = p_close_period_name
1015: -- AND ORGANIZATION_ID = p_org_hierarchy_origin;
1016:

Line 1037: -- The periods for Closing are selected from the ORG_ACCT_PERIODS

1033:
1034: -- The API's return status details the process outcome , which is
1035: -- inserted into the PL/SQL table and later printed as Log report
1036:
1037: -- The periods for Closing are selected from the ORG_ACCT_PERIODS
1038: -- and the periods to Open are retreived from GL_PERIODS
1039:
1040: G_LOG_REPORT_TABLE.DELETE ;
1041:

Line 1922: FOR l_org_acct_periods_val_open IN c_org_acct_periods_open

1918: END IF; -- process only for child organizations
1919:
1920:
1921: IF p_open_or_close_flag = 'C' THEN
1922: FOR l_org_acct_periods_val_open IN c_org_acct_periods_open
1923: LOOP
1924: IF l_org_acct_periods_val_open.open_flag = 'Y'
1925: THEN
1926: -- The period close is first verified if it can be Opened

Line 1924: IF l_org_acct_periods_val_open.open_flag = 'Y'

1920:
1921: IF p_open_or_close_flag = 'C' THEN
1922: FOR l_org_acct_periods_val_open IN c_org_acct_periods_open
1923: LOOP
1924: IF l_org_acct_periods_val_open.open_flag = 'Y'
1925: THEN
1926: -- The period close is first verified if it can be Opened
1927: -- If YES, the Close period Inventory API is called
1928:

Line 1951: l_org_acct_periods_val_open.open_period_name ||

1947:
1948: INV_ORGHIERARCHY_PVT.Log
1949: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1950: ,' Org ID ' || l_orgid || ' for period ' ||
1951: l_org_acct_periods_val_open.open_period_name ||
1952: ' Schedule Close Date:' || l_org_acct_periods_val_open.schedule_close_date
1953: );
1954: END IF;
1955:

Line 1952: ' Schedule Close Date:' || l_org_acct_periods_val_open.schedule_close_date

1948: INV_ORGHIERARCHY_PVT.Log
1949: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1950: ,' Org ID ' || l_orgid || ' for period ' ||
1951: l_org_acct_periods_val_open.open_period_name ||
1952: ' Schedule Close Date:' || l_org_acct_periods_val_open.schedule_close_date
1953: );
1954: END IF;
1955:
1956: -- Bug: 3590042. Initialization of variable l_verify_flag is added.

Line 1963: , p_closing_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

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
1965: , x_open_period_exists => l_open_period_exists
1966: , x_proper_order => l_proper_order
1967: , x_end_date_is_past => l_end_date_is_past

Line 1964: , p_closing_end_date => l_org_acct_periods_val_open.schedule_close_date

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
1965: , x_open_period_exists => l_open_period_exists
1966: , x_proper_order => l_proper_order
1967: , x_end_date_is_past => l_end_date_is_past
1968: , x_download_in_process => l_download_in_process

Line 2028: IF (l_org_acct_periods_val_open.period_start_date > l_le_sysdate) THEN

2024: AND HOI.organization_id = l_orgid;
2025:
2026: l_le_sysdate := INV_LE_TIMEZONE_PUB.GET_LE_SYSDATE_FOR_OU(
2027: l_legal_entity);
2028: IF (l_org_acct_periods_val_open.period_start_date > l_le_sysdate) THEN
2029: FND_MESSAGE.SET_NAME('BOM','CST_CLOSE_FUTURE_PERIOD');
2030: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2031: IF G_DEBUG = 'Y' THEN
2032: INV_ORGHIERARCHY_PVT.Log

Line 2042: l_org_acct_periods_val_open.schedule_close_date + .99999,

2038: ELSE
2039: -- Convert Period end date into server time zone. Adding .99999 becasue
2040: -- Period end date does not store time factor.
2041: l_period_end_date := INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(
2042: l_org_acct_periods_val_open.schedule_close_date + .99999,
2043: l_legal_entity);
2044: -- Get remaining hours from sysdate
2045: l_hours_remaining := round((l_period_end_date - sysdate) * 24);
2046:

Line 2055: , p_period => l_org_acct_periods_val_open.open_period_name

2051: );
2052: END IF;
2053: ADD_ITEM
2054: ( p_org => NULL
2055: , p_period => l_org_acct_periods_val_open.open_period_name
2056: , p_status => 'Warning'
2057: , p_reason => 'Remaining hours to close period : ' || l_hours_remaining
2058: , p_request_id => NULL
2059: , p_closed => NULL

Line 2060: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2056: , p_status => 'Warning'
2057: , p_reason => 'Remaining hours to close period : ' || l_hours_remaining
2058: , p_request_id => NULL
2059: , p_closed => NULL
2060: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2061: );
2062: END IF; --IF (l_period_open_date > l_le_sysdate)
2063:
2064:

Line 2111: , p_period => l_org_acct_periods_val_open.open_period_name

2107: -- insert error log on the report
2108: IF l_verify_flag = 'N' THEN
2109: ADD_ITEM
2110: ( p_org => NULL
2111: , p_period => l_org_acct_periods_val_open.open_period_name
2112: , p_status => 'Ignore'
2113: , p_reason => l_error_msg
2114: , p_request_id => NULL
2115: , p_closed => 'N'

Line 2116: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2112: , p_status => 'Ignore'
2113: , p_reason => l_error_msg
2114: , p_request_id => NULL
2115: , p_closed => 'N'
2116: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2117: );
2118: END IF;
2119:
2120: -- Proceed further to close the period only if the

Line 2128: , p_closing_period => l_org_acct_periods_val_open.closing_acct_period_id

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
2130: , x_pend_receiving => l_pend_receiving
2131: , x_unproc_matl => l_unproc_matl
2132: , x_pend_matl => l_pend_matl

Line 2129: , p_sched_close_date => l_org_acct_periods_val_open.schedule_close_date

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
2130: , x_pend_receiving => l_pend_receiving
2131: , x_unproc_matl => l_unproc_matl
2132: , x_pend_matl => l_pend_matl
2133: , x_uncost_matl => l_uncost_matl

Line 2153: (cst_periodcloseoption_pub.get_shippingtxnhook_value(p_org_id => l_orgid, p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id) = 1

2149: OR
2150: ( p_close_if_res_recmd = 'Y' AND l_pend_receiving >= 0 AND l_pend_matl >= 0
2151: AND l_pend_move >= 0 AND l_released_work_orders >= 0 AND
2152: (l_pending_ship = 0 OR
2153: (cst_periodcloseoption_pub.get_shippingtxnhook_value(p_org_id => l_orgid, p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id) = 1
2154: AND l_pending_ship >= 0)
2155: )
2156: )
2157: )

Line 2189: l_org_acct_periods_val_open.open_period_name

2185: INV_ORGHIERARCHY_PVT.Log
2186: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2187: ,' Calling CLOSE_PERIOD for Org ID '
2188: || l_orgid || ' for period ' ||
2189: l_org_acct_periods_val_open.open_period_name
2190: );
2191: END IF;
2192:
2193: /* myerrams, Bug:4599201. Modified the call to

Line 2210: , p_closing_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

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
2210: , p_closing_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2211: , x_wip_failed => l_wip_failed
2212: , x_close_failed => l_close_failed
2213: , x_req_id => l_req_id
2214: , x_unprocessed_txns => l_unprocessed_txns

Line 2237: , p_period => l_org_acct_periods_val_open.open_period_name

2233: ) ;
2234: END IF;
2235: ADD_ITEM
2236: ( p_org => NULL
2237: , p_period => l_org_acct_periods_val_open.open_period_name
2238: , p_status => 'Failed'
2239: , p_reason => 'WIP Failed'
2240: , p_request_id => l_req_id
2241: , p_closed => 'N'

Line 2242: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2238: , p_status => 'Failed'
2239: , p_reason => 'WIP Failed'
2240: , p_request_id => l_req_id
2241: , p_closed => 'N'
2242: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2243: );
2244:
2245: END IF;
2246:

Line 2258: , p_period => l_org_acct_periods_val_open.open_period_name

2254: );
2255: END IF;
2256: ADD_ITEM
2257: ( p_org => NULL
2258: , p_period => l_org_acct_periods_val_open.open_period_name
2259: , p_status => 'Failed'
2260: , p_reason => 'Download Failed'
2261: , p_request_id => l_req_id
2262: , p_closed => 'N'

Line 2263: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2259: , p_status => 'Failed'
2260: , p_reason => 'Download Failed'
2261: , p_request_id => l_req_id
2262: , p_closed => 'N'
2263: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2264: );
2265:
2266: END IF;
2267:

Line 2305: , p_period => l_org_acct_periods_val_open.open_period_name

2301: END IF;
2302:
2303: ADD_ITEM
2304: ( p_org => NULL
2305: , p_period => l_org_acct_periods_val_open.open_period_name
2306: , p_status => 'Failed'
2307: , p_reason => 'Close Failed'
2308: , p_request_id => l_req_id
2309: , p_closed => 'N'

Line 2310: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2306: , p_status => 'Failed'
2307: , p_reason => 'Close Failed'
2308: , p_request_id => l_req_id
2309: , p_closed => 'N'
2310: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2311: );
2312:
2313: ROLLBACK ;
2314: ELSE --IF ( l_close_failed ) = true

Line 2328: , ' WARNING : There are pending transactions with resolutions recommended for '||l_org_acct_periods_val_open.open_period_name||

2324: l_closed_if_res_recmd := 1;
2325: IF G_DEBUG = 'Y' THEN
2326: INV_ORGHIERARCHY_PVT.Log
2327: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2328: , ' WARNING : There are pending transactions with resolutions recommended for '||l_org_acct_periods_val_open.open_period_name||
2329: ' in '||l_orgid
2330: );
2331: END IF;
2332: ADD_ITEM

Line 2334: , p_period => l_org_acct_periods_val_open.open_period_name

2330: );
2331: END IF;
2332: ADD_ITEM
2333: ( p_org => NULL
2334: , p_period => l_org_acct_periods_val_open.open_period_name
2335: , p_status => 'Warning'
2336: , p_reason => 'There are pending transactions with resolutions recommended'
2337: , p_request_id => NULL
2338: , p_closed => 'N'

Line 2339: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2335: , p_status => 'Warning'
2336: , p_reason => 'There are pending transactions with resolutions recommended'
2337: , p_request_id => NULL
2338: , p_closed => 'N'
2339: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2340: );
2341: END IF;
2342: ADD_ITEM
2343: ( p_org => NULL

Line 2344: , p_period => l_org_acct_periods_val_open.open_period_name

2340: );
2341: END IF;
2342: ADD_ITEM
2343: ( p_org => NULL
2344: , p_period => l_org_acct_periods_val_open.open_period_name
2345: , p_status => 'Processing'
2346: , p_reason => NULL
2347: , p_request_id => l_req_id
2348: , p_closed => 'N'

Line 2349: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2345: , p_status => 'Processing'
2346: , p_reason => NULL
2347: , p_request_id => l_req_id
2348: , p_closed => 'N'
2349: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2350: );
2351: COMMIT ;
2352: END IF; --IF ( l_close_failed ) = true
2353:

Line 2363: , p_period => l_org_acct_periods_val_open.open_period_name

2359: );
2360: END IF;
2361: ADD_ITEM
2362: ( p_org => NULL
2363: , p_period => l_org_acct_periods_val_open.open_period_name
2364: , p_status => 'Ignore'
2365: , p_reason => 'Pending transactions exists'
2366: , p_request_id => NULL
2367: , p_closed => 'N'

Line 2368: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2364: , p_status => 'Ignore'
2365: , p_reason => 'Pending transactions exists'
2366: , p_request_id => NULL
2367: , p_closed => 'N'
2368: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2369: );
2370: END IF ; -- check for pending transaction
2371:
2372: -- verify_periodclose failed

Line 2394: , p_period => l_org_acct_periods_val_open.open_period_name

2390: /* Commented following code for showing details of only eligible
2391: periods in Summary report. Bug: 3555234
2392: ADD_ITEM
2393: ( p_org => NULL
2394: , p_period => l_org_acct_periods_val_open.open_period_name
2395: , p_status => 'Ignore'
2396: , p_reason => 'Not Open'
2397: , p_request_id => NULL
2398: , p_closed => 'N'

Line 2399: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id

2395: , p_status => 'Ignore'
2396: , p_reason => 'Not Open'
2397: , p_request_id => NULL
2398: , p_closed => 'N'
2399: , p_acct_period_id => l_org_acct_periods_val_open.closing_acct_period_id
2400: );*/
2401:
2402: END IF; -- open flag check
2403: END LOOP;