145: END IF;
146:
147: x_return_status := FND_API.g_ret_sts_success;
148:
149: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
150: l_created_by := NVL(FND_GLOBAL.user_id,-1);
151: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
152:
153: l_post_to_gl := l_sys_parameters_rec.post_to_gl; -- Bug 4760420
146:
147: x_return_status := FND_API.g_ret_sts_success;
148:
149: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
150: l_created_by := NVL(FND_GLOBAL.user_id,-1);
151: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
152:
153: l_post_to_gl := l_sys_parameters_rec.post_to_gl; -- Bug 4760420
154:
147: x_return_status := FND_API.g_ret_sts_success;
148:
149: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
150: l_created_by := NVL(FND_GLOBAL.user_id,-1);
151: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
152:
153: l_post_to_gl := l_sys_parameters_rec.post_to_gl; -- Bug 4760420
154:
155: --bugfix 4743804
323: ,l_last_updated_by -- LAST_UPDATED_BY
324: ,SYSDATE -- CREATION_DATE
325: ,l_created_by -- CREATED_BY
326: ,l_last_update_login -- LAST_UPDATE_LOGIN
327: ,FND_GLOBAL.CONC_REQUEST_ID -- REQUEST_ID
328: ,FND_GLOBAL.PROG_APPL_ID -- PROGRAM_APPLICATION_ID
329: ,SYSDATE -- PROGRAM_UPDATE_DATE
330: ,FND_GLOBAL.CONC_PROGRAM_ID -- PROGRAM_ID
331: ,l_sys_parameters_rec.created_from -- CREATED_FROM
324: ,SYSDATE -- CREATION_DATE
325: ,l_created_by -- CREATED_BY
326: ,l_last_update_login -- LAST_UPDATE_LOGIN
327: ,FND_GLOBAL.CONC_REQUEST_ID -- REQUEST_ID
328: ,FND_GLOBAL.PROG_APPL_ID -- PROGRAM_APPLICATION_ID
329: ,SYSDATE -- PROGRAM_UPDATE_DATE
330: ,FND_GLOBAL.CONC_PROGRAM_ID -- PROGRAM_ID
331: ,l_sys_parameters_rec.created_from -- CREATED_FROM
332: ,l_post_to_gl
326: ,l_last_update_login -- LAST_UPDATE_LOGIN
327: ,FND_GLOBAL.CONC_REQUEST_ID -- REQUEST_ID
328: ,FND_GLOBAL.PROG_APPL_ID -- PROGRAM_APPLICATION_ID
329: ,SYSDATE -- PROGRAM_UPDATE_DATE
330: ,FND_GLOBAL.CONC_PROGRAM_ID -- PROGRAM_ID
331: ,l_sys_parameters_rec.created_from -- CREATED_FROM
332: ,l_post_to_gl
333: ,l_transfer_to_gl
334: ,l_sys_parameters_rec.ap_payment_term_id
774: END IF;
775:
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777:
778: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
779: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
780:
781: ----------------------- validate ----------------------
782: IF g_debug THEN
775:
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777:
778: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
779: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
780:
781: ----------------------- validate ----------------------
782: IF g_debug THEN
783: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
852: ,object_version_number = l_object_version_number
853: ,last_update_date = SYSDATE
854: ,last_updated_by = l_last_updated_by
855: ,last_update_login = l_last_update_login
856: ,request_id = FND_GLOBAL.CONC_REQUEST_ID
857: ,program_application_id = FND_GLOBAL.PROG_APPL_ID
858: ,program_update_date = SYSDATE
859: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID
860: ,created_from = l_sys_parameters_rec.created_from
853: ,last_update_date = SYSDATE
854: ,last_updated_by = l_last_updated_by
855: ,last_update_login = l_last_update_login
856: ,request_id = FND_GLOBAL.CONC_REQUEST_ID
857: ,program_application_id = FND_GLOBAL.PROG_APPL_ID
858: ,program_update_date = SYSDATE
859: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID
860: ,created_from = l_sys_parameters_rec.created_from
861: ,post_to_gl = l_sys_parameters_rec.post_to_gl
855: ,last_update_login = l_last_update_login
856: ,request_id = FND_GLOBAL.CONC_REQUEST_ID
857: ,program_application_id = FND_GLOBAL.PROG_APPL_ID
858: ,program_update_date = SYSDATE
859: ,program_id = FND_GLOBAL.CONC_PROGRAM_ID
860: ,created_from = l_sys_parameters_rec.created_from
861: ,post_to_gl = l_sys_parameters_rec.post_to_gl
862: ,transfer_to_gl_in = l_sys_parameters_rec.transfer_to_gl_in
863: ,ap_payment_term_id = l_sys_parameters_rec.ap_payment_term_id