156: )
157: IS
158: l_proc_name VARCHAR2(30) := 'import_metadata';
159:
160: l_token_table ERROR_HANDLER.Token_Tbl_Type;
161:
162: l_error_message_name VARCHAR2(240);
163: l_error_row_identifier NUMBER;
164:
193: END IF;
194: Write_Debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Setup Global variables');
195:
196: --======================--
197: -- ERROR_HANDLER SET-UP --
198: --======================--
199:
200: ERROR_HANDLER.Initialize();
201: Write_Debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Initialized Error Handler');
196: --======================--
197: -- ERROR_HANDLER SET-UP --
198: --======================--
199:
200: ERROR_HANDLER.Initialize();
201: Write_Debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Initialized Error Handler');
202:
203: /* Based on Concurrent Program's parameters, call the individual entity's import APIs. */
204:
197: -- ERROR_HANDLER SET-UP --
198: --======================--
199:
200: ERROR_HANDLER.Initialize();
201: Write_Debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Initialized Error Handler');
202:
203: /* Based on Concurrent Program's parameters, call the individual entity's import APIs. */
204:
205: /* Process Value Sets*/
243: -- logged both into mtl_interface_errors table and --
244: -- concurrent program log file. --
245: -------------------------------------------------------------------
246: Write_Debug(G_PKG_NAME||'.'||l_proc_name||'->'||'Calling Log_Error Procedure');
247: ERROR_HANDLER.Log_Error(
248: p_write_err_to_inttable => 'Y'
249: ,p_write_err_to_conclog => 'Y'
250: );
251:
297: ,x_return_status OUT NOCOPY VARCHAR2
298: )
299: IS
300: l_proc_name VARCHAR2(30) := 'Get_Lock_Info';
301: l_token_table ERROR_HANDLER.Token_Tbl_Type;
302: l_appl_name VARCHAR2(3) := 'EGO';
303: l_entity_code VARCHAR2(30) := NULL ;
304: l_table_name VARCHAR2(30) := NULL ;
305:
362: x_return_status := G_RET_STS_ERROR;
363: l_token_table(1).token_name := 'ENTITY';
364: l_token_table(1).token_value := 'LOCK';
365:
366: ERROR_HANDLER.Add_Error_Message(
367: p_message_name => 'EGO_REQ_COLMS_MISSING'
368: ,p_application_id => l_appl_name
369: --,p_row_identifier => transaction_id
370: ,p_token_tbl => l_token_table
407: ,x_return_status OUT NOCOPY VARCHAR2
408: )
409: IS
410: l_proc_name VARCHAR2(30) := 'Lock_Unlock_Object';
411: l_token_table ERROR_HANDLER.Token_Tbl_Type;
412: l_sysdate DATE := SYSDATE;
413: l_appl_name VARCHAR2(3) := 'EGO';
414: l_entity_code VARCHAR2(30) := NULL ;
415: l_table_name VARCHAR2(30) := NULL ;
452: x_return_status := G_RET_STS_ERROR;
453: l_token_table(1).token_name := 'ENTITY';
454: l_token_table(1).token_value := 'LOCK';
455:
456: ERROR_HANDLER.Add_Error_Message(
457: p_message_name => 'EGO_REQ_COLMS_MISSING'
458: ,p_application_id => l_appl_name
459: --,p_row_identifier => transaction_id
460: ,p_token_tbl => l_token_table