[Home] [Help]
418: p_module => 'fem.plsql.fem_gl_post_process_pkg.' ||
419: 'register_process_execution.begin',
420: p_msg_text => 'BEGIN');
421:
422: -- Call the FEM_PL_PKG.Register_Request API procedure to register
423: -- the concurrent request in FEM_PL_REQUESTS.
424:
425: FND_MSG_PUB.Initialize;
426:
423: -- the concurrent request in FEM_PL_REQUESTS.
424:
425: FND_MSG_PUB.Initialize;
426:
427: FEM_PL_PKG.Register_Request
428: (P_API_VERSION => pc_API_version,
429: P_COMMIT => 'T',
430: P_CAL_PERIOD_ID => pv_cal_period_id,
431: P_LEDGER_ID => pv_ledger_id,
458: -- the execution in FEM_PL_OBJECT_EXECUTIONS, obtaining an execution lock.
459:
460: FND_MSG_PUB.Initialize;
461:
462: FEM_PL_PKG.Register_Object_Execution
463: (P_API_VERSION => pc_API_version,
464: P_COMMIT => 'T',
465: P_REQUEST_ID => pv_req_id,
466: P_OBJECT_ID => pv_rule_obj_id,
522: -- rule version.
523:
524: FND_MSG_PUB.Initialize;
525:
526: FEM_PL_PKG.Register_Object_Def
527: (P_API_VERSION => pc_API_version,
528: P_COMMIT => 'T',
529: P_REQUEST_ID => pv_req_id,
530: P_OBJECT_ID => pv_rule_obj_id,
558: END IF;
559:
560: FND_MSG_PUB.Initialize;
561:
562: FEM_PL_PKG.Register_Table
563: (P_API_VERSION => pc_API_version,
564: P_COMMIT => 'T',
565: P_REQUEST_ID => pv_req_id,
566: P_OBJECT_ID => pv_rule_obj_id,
668: IF v_exec_lock_exists THEN
669:
670: -- Unregister the concurrent request.
671:
672: FEM_PL_PKG.Unregister_Request
673: (P_API_VERSION => pc_API_version,
674: P_COMMIT => 'T',
675: P_REQUEST_ID => pv_req_id,
676: X_MSG_COUNT => v_msg_count,
790: END IF;
791:
792: FND_MSG_PUB.Initialize;
793:
794: FEM_PL_PKG.Update_Num_of_Output_Rows
795: (P_API_VERSION => pc_API_version,
796: P_COMMIT => 'T',
797: P_REQUEST_ID => pv_req_id,
798: P_OBJECT_ID => pv_rule_obj_id,
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
813: (P_API_VERSION => pc_API_version,
814: P_COMMIT => 'T',
815: P_REQUEST_ID => pv_req_id,
816: P_OBJECT_ID => pv_rule_obj_id,
824:
825: -- Update the status of the object execution from 'RUNNING' to
826: -- 'SUCCESS', 'CANCELLED_RERUN', or 'ERROR_RERUN'.
827:
828: FEM_PL_PKG.Update_Obj_Exec_Status
829: (P_API_VERSION => pc_API_version,
830: P_COMMIT => 'T',
831: P_REQUEST_ID => pv_req_id,
832: P_OBJECT_ID => pv_rule_obj_id,
839:
840: -- Update the status of the concurrent request from 'RUNNING' to
841: -- 'SUCCESS', 'CANCELLED_RERUN', or 'ERROR_RERUN'.
842:
843: FEM_PL_PKG.Update_Request_Status
844: (P_API_VERSION => pc_API_version,
845: P_COMMIT => 'T',
846: P_REQUEST_ID => pv_req_id,
847: P_EXEC_STATUS_CODE => p_exec_status,
6592: FND_MSG_PUB.Initialize;
6593: -- Register the concurrent request in FEM_PL_REQUESTS
6594: -- Bug fix 4285337: Pass the end date of each period when
6595: -- registering the request
6596: FEM_PL_PKG.Register_Request
6597: (P_API_VERSION => pc_API_version,
6598: P_COMMIT => 'T',
6599: P_CAL_PERIOD_ID => v_cp.cal_period_id,
6600: P_LEDGER_ID => pv_ledger_id,
6629: FND_MSG_PUB.Initialize;
6630: -- Check for process locks and process overlaps, validate the execution
6631: -- mode parameter, validate the period(s), and register the execution in
6632: -- FEM_PL_OBJECT_EXECUTIONS
6633: FEM_PL_PKG.Register_Object_Execution
6634: (P_API_VERSION => pc_API_version,
6635: P_COMMIT => 'T',
6636: P_REQUEST_ID => v_req_id,
6637: P_OBJECT_ID => pv_rule_obj_id,
6695:
6696: -- Initialize the FND Message API
6697: FND_MSG_PUB.Initialize;
6698: -- Unregister the request for this Cal Period/Output Dataset
6699: FEM_PL_PKG.Unregister_Request
6700: (P_API_VERSION => pc_API_version,
6701: P_COMMIT => 'T',
6702: P_REQUEST_ID => v_req_id,
6703: X_MSG_COUNT => v_msg_count,
6998: -- Initialize the FND Message API
6999: FND_MSG_PUB.Initialize;
7000: -- Log Undo information for this Request, which will insert/update the
7001: -- table FEM_BALANCES; pass pv_stmt_type as the statement type
7002: FEM_PL_PKG.Register_Table
7003: (P_API_VERSION => pc_API_version,
7004: P_COMMIT => 'T',
7005: P_REQUEST_ID => v_req.request_id,
7006: P_OBJECT_ID => pv_rule_obj_id,
7398: THEN
7399: -- Initialize the FND Message API
7400: FND_MSG_PUB.Initialize;
7401: -- Update the number of output rows in FEM_PL_TABLES for this Request
7402: FEM_PL_PKG.Update_Num_of_Output_Rows
7403: (P_API_VERSION => pc_API_version,
7404: P_COMMIT => 'T',
7405: P_REQUEST_ID => v_req.request_id,
7406: P_OBJECT_ID => pv_rule_obj_id,
7444: -- Initialize the FND Message API
7445: FND_MSG_PUB.Initialize;
7446: -- Update the number of data errors in FEM_PL_OBJECT_EXECUTIONS for
7447: -- this Request
7448: FEM_PL_PKG.Update_Obj_Exec_Errors
7449: (P_API_VERSION => pc_API_version,
7450: P_COMMIT => 'T',
7451: P_REQUEST_ID => v_req.request_id,
7452: P_OBJECT_ID => pv_rule_obj_id,
7513: -- ------------------------------------------------------------
7514: -- Initialize the FND Message API
7515: FND_MSG_PUB.Initialize;
7516: -- Update the object execution status
7517: FEM_PL_PKG.Update_Obj_Exec_Status
7518: (P_API_VERSION => pc_API_version,
7519: P_COMMIT => 'T',
7520: P_REQUEST_ID => v_req.request_id,
7521: P_OBJECT_ID => pv_rule_obj_id,
7550: -- -------------------------------------------------------------
7551: -- Initialize the FND Message API
7552: FND_MSG_PUB.Initialize;
7553: -- Update the request execution status
7554: FEM_PL_PKG.Update_Request_Status
7555: (P_API_VERSION => pc_API_version,
7556: P_COMMIT => 'T',
7557: P_REQUEST_ID => v_req.request_id,
7558: P_EXEC_STATUS_CODE => v_exec_status,