246: , local_revised_line_id4 = p_entity_map_rec.local_revised_line_id4
247: , local_revised_line_id5 = p_entity_map_rec.local_revised_line_id5
248: , entity_action_status = p_entity_map_rec.entity_action_status
249: , creation_date = SYSDATE
250: , created_by = FND_GLOBAL.USER_ID
251: , last_update_date = SYSDATE
252: , last_updated_by = FND_GLOBAL.USER_ID
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
248: , entity_action_status = p_entity_map_rec.entity_action_status
249: , creation_date = SYSDATE
250: , created_by = FND_GLOBAL.USER_ID
251: , last_update_date = SYSDATE
252: , last_updated_by = FND_GLOBAL.USER_ID
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
249: , creation_date = SYSDATE
250: , created_by = FND_GLOBAL.USER_ID
251: , last_update_date = SYSDATE
252: , last_updated_by = FND_GLOBAL.USER_ID
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
250: , created_by = FND_GLOBAL.USER_ID
251: , last_update_date = SYSDATE
252: , last_updated_by = FND_GLOBAL.USER_ID
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
258: WHERE change_propagation_map_id = p_entity_map_rec.change_propagation_map_id;
251: , last_update_date = SYSDATE
252: , last_updated_by = FND_GLOBAL.USER_ID
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
258: WHERE change_propagation_map_id = p_entity_map_rec.change_propagation_map_id;
259: ELSE
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
258: WHERE change_propagation_map_id = p_entity_map_rec.change_propagation_map_id;
259: ELSE
260: SELECT eng_change_propagation_maps_s.nextval
261: INTO p_entity_map_rec.change_propagation_map_id
297: , p_entity_map_rec.revised_item_sequence_id
298: , p_entity_map_rec.local_change_id
299: , p_entity_map_rec.local_revised_item_seq_id
300: , p_entity_map_rec.LOCAL_ORGANIZATION_ID
301: , FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
302: , FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
303: , SYSDATE
304: , FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
305: , p_entity_map_rec.revised_line_type
298: , p_entity_map_rec.local_change_id
299: , p_entity_map_rec.local_revised_item_seq_id
300: , p_entity_map_rec.LOCAL_ORGANIZATION_ID
301: , FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
302: , FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
303: , SYSDATE
304: , FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
305: , p_entity_map_rec.revised_line_type
306: , p_entity_map_rec.revised_line_id1
300: , p_entity_map_rec.LOCAL_ORGANIZATION_ID
301: , FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
302: , FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
303: , SYSDATE
304: , FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
305: , p_entity_map_rec.revised_line_type
306: , p_entity_map_rec.revised_line_id1
307: , p_entity_map_rec.revised_line_id2
308: , p_entity_map_rec.revised_line_id3
315: , p_entity_map_rec.local_revised_line_id5
316: , p_entity_map_rec.ENTITY_NAME
317: , p_entity_map_rec.entity_action_status
318: , SYSDATE
319: , FND_GLOBAL.USER_ID
320: , SYSDATE
321: , FND_GLOBAL.USER_ID
322: , FND_GLOBAL.LOGIN_ID
323: );
317: , p_entity_map_rec.entity_action_status
318: , SYSDATE
319: , FND_GLOBAL.USER_ID
320: , SYSDATE
321: , FND_GLOBAL.USER_ID
322: , FND_GLOBAL.LOGIN_ID
323: );
324: END IF;
325: EXCEPTION
318: , SYSDATE
319: , FND_GLOBAL.USER_ID
320: , SYSDATE
321: , FND_GLOBAL.USER_ID
322: , FND_GLOBAL.LOGIN_ID
323: );
324: END IF;
325: EXCEPTION
326: WHEN OTHERS THEN
403: , X_revised_item_sequence_id => p_entity_map_rec.revised_item_sequence_id
404: , X_local_organization_id => p_entity_map_rec.local_organization_id
405: , X_log_text => p_entity_map_rec.message_list(i).message_text
406: , X_creation_date => SYSDATE
407: , X_created_by => FND_GLOBAL.USER_ID
408: , X_last_update_date => SYSDATE
409: , X_last_updated_by => FND_GLOBAL.USER_ID
410: , X_last_update_login => FND_GLOBAL.LOGIN_ID
411: , X_change_propagation_map_id => p_entity_map_rec.change_propagation_map_id
405: , X_log_text => p_entity_map_rec.message_list(i).message_text
406: , X_creation_date => SYSDATE
407: , X_created_by => FND_GLOBAL.USER_ID
408: , X_last_update_date => SYSDATE
409: , X_last_updated_by => FND_GLOBAL.USER_ID
410: , X_last_update_login => FND_GLOBAL.LOGIN_ID
411: , X_change_propagation_map_id => p_entity_map_rec.change_propagation_map_id
412: );
413:
406: , X_creation_date => SYSDATE
407: , X_created_by => FND_GLOBAL.USER_ID
408: , X_last_update_date => SYSDATE
409: , X_last_updated_by => FND_GLOBAL.USER_ID
410: , X_last_update_login => FND_GLOBAL.LOGIN_ID
411: , X_change_propagation_map_id => p_entity_map_rec.change_propagation_map_id
412: );
413:
414: END LOOP; -- End of 1..p_message_list.COUNT