146: */
147:
148: for cr in cc loop
149:
150: status := INVPUOPI.mtl_pr_parse_flex_name (
151: cr.organization_id,
152: 'MSTK',
153: cr.item_number,
154: flex_id,
172: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
173: into tran_id
174: from dual;
175: */
176: dumm_status := INVPUOPI.mtl_log_interface_err(
177: cr.organization_id,
178: user_id,
179: login_id,
180: prog_appid,
302: i.transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
303: WHERE i.rowid = rec.rowid
304: RETURNING i.transaction_id INTO tran_id ;
305:
306: dumm_status := INVPUOPI.mtl_log_interface_err(
307: rec.organization_id,
308: user_id,
309: login_id,
310: prog_appid,
348: when OTHERS then
349: --Bug 13813134
350: error_msg := substr('INVPAGI3.assign_item_revs:' || SQLERRM , 1, 240);
351: err_text := error_msg;
352: dumm_status := INVPUOPI.mtl_log_interface_err(
353: org_id,
354: user_id,
355: login_id,
356: prog_appid,