[Home] [Help]
804: X_MSG_COUNT => v_msg_count,
805: X_MSG_DATA => v_msg_data,
806: X_RETURN_STATUS => v_return_status);
807:
808: -- Log the number of data errors flagged on individual input rows in the
809: -- interface table in this execution and the number of previously failed
810: -- rows successfully reprocessed in this execution.
811:
812: FEM_PL_PKG.Update_Obj_Exec_Errors
5228: -- its start date and period effective number
5229: BEGIN
5230: SELECT per.END_DATE
5231: , per.EFFECTIVE_PERIOD_NUM
5232: , (SELECT 'Y' FROM DUAL
5233: WHERE NVL(p_effective_date, per.END_DATE) BETWEEN per.START_DATE
5234: AND per.END_DATE)
5235: INTO pv_to_date
5236: , pv_to_period_eff_num
5357: BEGIN
5358:
5359: SELECT 'Y'
5360: INTO v_dummy_flag
5361: FROM DUAL
5362: WHERE EXISTS
5363: (SELECT 'Loaded'
5364: FROM FEM_DL_DIMENSIONS
5365: WHERE LEDGER_ID = pv_ledger_id
6430:
6431: BEGIN
6432: SELECT 'Y'
6433: INTO v_any_period_gap
6434: FROM DUAL
6435: WHERE EXISTS
6436: (SELECT 'Period gap exists'
6437: FROM GL_PERIOD_STATUSES
6438: WHERE LEDGER_ID = pv_ledger_id
6539: -- Bug fix 4170124: Changed to check FEM_DL_DIMENSIONS instead
6540: -- of FEM_PL_REQUESTS
6541: SELECT 'Y'
6542: INTO v_dummy_flag
6543: FROM DUAL
6544: WHERE EXISTS
6545: (SELECT 'Loaded'
6546: FROM FEM_DL_DIMENSIONS
6547: WHERE LEDGER_ID = pv_ledger_id
6574:
6575: -- Get a new request ID to register
6576: SELECT FND_CONCURRENT_REQUESTS_S.nextval
6577: INTO v_req_id
6578: FROM DUAL;
6579:
6580: -- Print the request ID to FND Log
6581: FEM_ENGINES_PKG.Tech_Message
6582: (p_severity => pc_log_level_statement,
6816: THEN
6817: BEGIN
6818: SELECT 'Y'
6819: INTO v_any_period_gap
6820: FROM DUAL
6821: WHERE EXISTS
6822: (SELECT 'Period gap exists'
6823: FROM GL_PERIOD_STATUSES
6824: WHERE LEDGER_ID = pv_ledger_id