DBA Data[Home] [Help]

APPS.INVUPD1B dependencies on INVPUOPI

Line 118: dumm_status := INVPUOPI.mtl_log_interface_err(

114: WHERE Rowid = puom.Rowid;
115: END IF;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: dumm_status := INVPUOPI.mtl_log_interface_err(
119: t_organization_id,
120: user_id,
121: login_id,
122: prog_appid,

Line 301: upd_status := INVPUOPI.mtl_log_interface_err(

297: IF upd_status <> 0 THEN --{
298: -- At least one attribute failed the dependency check.
299: -- Flag error that on-hand qties exist and related
300: -- non-updateable attribute is being updated.
301: upd_status := INVPUOPI.mtl_log_interface_err(
302: t_organization_id,
303: user_id,
304: login_id,
305: prog_appid,

Line 339: dumm_status := INVPUOPI.mtl_log_interface_err(

335: END IF; -- }
336: /* Bug 4751471 - Status Controlled attrs are relevantly updated when status is applied. Eliminating chk
337: ELSE -- } {
338: -- flag error that status controlled attribute is being modified and move to next record
339: dumm_status := INVPUOPI.mtl_log_interface_err(
340: t_organization_id,
341: user_id,
342: login_id,
343: prog_appid,

Line 356: dumm_status := INVPUOPI.mtl_log_interface_err(

352: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
353: END IF; -- } */
354: ELSE -- } {
355: -- flag error that non-updateable fields are being updated and move to next record
356: dumm_status := INVPUOPI.mtl_log_interface_err(
357: t_organization_id,
358: user_id,
359: login_id,
360: prog_appid,

Line 373: dumm_status := INVPUOPI.mtl_log_interface_err(

369: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
370: END IF; -- }
371: ELSE -- } {
372: -- flag error that costing related fields are being updated and move to next record
373: dumm_status := INVPUOPI.mtl_log_interface_err(
374: t_organization_id,
375: user_id,
376: login_id,
377: prog_appid,

Line 403: dumm_status := INVPUOPI.mtl_log_interface_err (

399: ,err_text => err_text
400: ,xset_id => xset_id);
401:
402: IF (rtn_status <> 0) THEN
403: dumm_status := INVPUOPI.mtl_log_interface_err (
404: -1,
405: user_id,
406: login_id,
407: prog_appid,

Line 425: dumm_status := INVPUOPI.mtl_log_interface_err(

421: return (ret_code);
422:
423: EXCEPTION
424: WHEN NO_DATA_FOUND THEN
425: dumm_status := INVPUOPI.mtl_log_interface_err(
426: t_organization_id,
427: user_id,
428: login_id,
429: prog_appid,

Line 1091: ret_code := INVPUOPI.mtl_pr_parse_item_number(

1087: t_trans_id := rec.transaction_id;
1088:
1089: if (rec.item_number is not NULL) then -- {
1090: error_text := NULL;
1091: ret_code := INVPUOPI.mtl_pr_parse_item_number(
1092: rec.item_number,
1093: rec.inventory_item_id,
1094: rec.transaction_id,
1095: rec.organization_id,

Line 1121: dumm_status := INVPUOPI.mtl_log_interface_err(

1117: else
1118: -- flag error that record does not exist in msi
1119: --Bug: 4937990
1120: -- Changed the error message
1121: dumm_status := INVPUOPI.mtl_log_interface_err(
1122: t_organization_id,
1123: user_id,
1124: login_id,
1125: prog_appid,

Line 1139: dumm_status := INVPUOPI.mtl_log_interface_err(

1135: end if;
1136: EXCEPTION
1137: -- if an oracle error occurred
1138: when ASS_ITEM_ERR then
1139: dumm_status := INVPUOPI.mtl_log_interface_err(
1140: t_organization_id,
1141: user_id,
1142: login_id,
1143: prog_appid,

Line 1156: dumm_status := INVPUOPI.mtl_log_interface_err(

1152: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
1153: status_code := 1;
1154:
1155: when PARSE_ITEM_ERR then
1156: dumm_status := INVPUOPI.mtl_log_interface_err(
1157: t_organization_id,
1158: user_id,
1159: login_id,
1160: prog_appid,

Line 1241: dumm_status := INVPUOPI.mtl_log_interface_err(

1237: END IF;
1238:
1239: for rec in C_inv_item_id_records loop -- {
1240:
1241: dumm_status := INVPUOPI.mtl_log_interface_err(
1242: rec.organization_id,
1243: user_id,
1244: login_id,
1245: prog_appid,

Line 1371: dumm_status := INVPUOPI.mtl_log_interface_err(

1367: if dbms_sql.is_open(DSQL_c) then -- {
1368: dbms_sql.close_cursor(DSQL_c);
1369: end if; -- }
1370:
1371: dumm_status := INVPUOPI.mtl_log_interface_err(
1372: org_id,
1373: user_id,
1374: login_id,
1375: prog_appid,

Line 4281: status := INVPUOPI.mtl_pr_parse_flex_name (

4277:
4278: --Assign Item Id
4279: FOR cr IN c_fill_Item_Id loop
4280:
4281: status := INVPUOPI.mtl_pr_parse_flex_name (
4282: cr.organization_id, 'MSTK',
4283: cr.item_number, flex_id,
4284: 0, err_text);
4285: IF status <> 0 THEN

Line 4301: dumm_status := INVPUOPI.mtl_log_interface_err(

4297: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4298: INTO tran_id
4299: FROM dual;
4300: */
4301: dumm_status := INVPUOPI.mtl_log_interface_err(
4302: cr.organization_id,
4303: user_id,
4304: login_id,
4305: prog_appid,

Line 4419: dumm_status := INVPUOPI.mtl_log_interface_err(

4415: WHERE rowid = cr.rowid;
4416:
4417: ELSE
4418:
4419: dumm_status := INVPUOPI.mtl_log_interface_err(
4420: cr.organization_id,
4421: user_id,
4422: login_id,
4423: prog_appid,

Line 4476: err_text := 'INVUPD1B.assign_item_rev_data_update: bad return status from INVPUOPI.mtl_pr_parse_flex_name, please check mtl_interface_errors with transaction_id:'||tran_id;

4472: RETURN (0);
4473:
4474: EXCEPTION
4475: WHEN ASSIGN_ERROR THEN
4476: err_text := 'INVUPD1B.assign_item_rev_data_update: bad return status from INVPUOPI.mtl_pr_parse_flex_name, please check mtl_interface_errors with transaction_id:'||tran_id;
4477: RETURN (1);
4478: WHEN LOGGING_ERROR THEN
4479: err_text := 'INVUPD1B.assign_item_rev_data_update: exception happen when calling INVPUOPI.mtl_log_interface_err'||err_text;
4480: RETURN (1);

Line 4479: err_text := 'INVUPD1B.assign_item_rev_data_update: exception happen when calling INVPUOPI.mtl_log_interface_err'||err_text;

4475: WHEN ASSIGN_ERROR THEN
4476: err_text := 'INVUPD1B.assign_item_rev_data_update: bad return status from INVPUOPI.mtl_pr_parse_flex_name, please check mtl_interface_errors with transaction_id:'||tran_id;
4477: RETURN (1);
4478: WHEN LOGGING_ERROR THEN
4479: err_text := 'INVUPD1B.assign_item_rev_data_update: exception happen when calling INVPUOPI.mtl_log_interface_err'||err_text;
4480: RETURN (1);
4481: WHEN OTHERS THEN
4482: err_text := substr('INVUPD1B.assign_item_rev_data_update: ' || SQLERRM, 1,2000);
4483: RETURN (1);