[Home] [Help]
249: tran_id := 0;
250: raise ASS_ITEM_ERR;
251: else
252: if rtn_status = -9999 then
253: dumm_status := INVPUOPI.mtl_log_interface_err(
254: 0,
255: user_id,
256: login_id,
257: prog_appid,
290: tran_id := 0;
291: raise ASS_ITEM_ERR;
292: else
293: if rtn_status = -9999 then
294: dumm_status := INVPUOPI.mtl_log_interface_err(
295: 0,
296: user_id,
297: login_id,
298: prog_appid,
331: l_Itemid_error := TRUE;
332: END;
333:
334: IF l_Itemid_error THEN
335: dumm_status := INVPUOPI.mtl_log_interface_err(
336: -1,
337: user_id,
338: login_id,
339: prog_appid,
408: ,x_return_status => l_ret_status
409: ,x_msg_count => l_msg_count
410: ,x_msg_data => l_msg_data );
411: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
412: dumm_status := INVPUOPI.mtl_log_interface_err(
413: 0,
414: user_id,
415: login_id,
416: prog_appid,
452: RETURNING transaction_id BULK COLLECT INTO transaction_table;
453:
454: IF transaction_table.COUNT > 0 THEN
455: FOR j IN transaction_table.FIRST .. transaction_table.LAST LOOP
456: dumm_status := INVPUOPI.mtl_log_interface_err(
457: org_id,
458: user_id,
459: login_id,
460: prog_appid,
486: ,cp_organization_id => org_table(i));
487: FETCH c_get_style INTO l_style_item_id;
488:
489: IF c_get_style%NOTFOUND THEN
490: dumm_status := INVPUOPI.mtl_log_interface_err(
491: 0,
492: user_id,
493: login_id,
494: prog_appid,
566:
567: loop
568: if dbms_sql.fetch_rows(DSQL_ff_c) > 0 then
569: dbms_sql.column_value(DSQL_ff_c,1,DSQL_ff_transaction_id);
570: dumm_status := INVPUOPI.mtl_log_interface_err(
571: -1,
572: user_id,
573: login_id,
574: prog_appid,
607: if dbms_sql.is_open(DSQL_ff_c) then
608: dbms_sql.close_cursor(DSQL_ff_c);
609: end if;
610: err_text:= 'assign_item_header DSQL 1 '|| SQLERRM;
611: dumm_status := INVPUOPI.mtl_log_interface_err(
612: l_org_id,
613: user_id,
614: login_id,
615: prog_appid,
681: validation_check_status := 0;
682: dumm_status := NULL;
683:
684: if cr.item_number is not NULL then
685: rtn_status := INVPUOPI.mtl_pr_parse_item_number(
686: cr.item_number,
687: cr.inventory_item_id,
688: cr.transaction_id,
689: cr.organization_id,
713: cr.segment15 is NULL and cr.segment16 is NULL and
714: cr.segment17 is NULL and cr.segment18 is NULL and
715: cr.segment19 is NULL and cr.segment20 is NULL and
716: l_item_num_gen <> 'F') then
717: dumm_status := INVPUOPI.mtl_log_interface_err(
718: 0,
719: user_id,
720: login_id,
721: prog_appid,
893: FND_MESSAGE.SET_NAME ('INV', 'INV_NO_OP_UNIT_FOR_ORG');
894: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', l_org_name);
895: l_msg_text := FND_MESSAGE.GET;
896: err_text := 'No Operating Unit Found for the Organization';
897: dumm_status := INVPUOPI.mtl_log_interface_err(
898: cr.organization_id,
899: user_id,
900: login_id,
901: prog_appid,
1006: if dbms_sql.is_open(DSQL_c) then
1007: dbms_sql.close_cursor(DSQL_c);
1008: end if;
1009: err_text:= 'assign_item_header DSQL 2 '|| SQLERRM;
1010: dumm_status := INVPUOPI.mtl_log_interface_err(
1011: l_org_id,
1012: user_id,
1013: login_id,
1014: prog_appid,
1106:
1107: if msiicount = 0 then
1108: error_msg := 'Orphan detected. This item has no parent in MSI';
1109: validation_check_status := -1;
1110: dumm_status := INVPUOPI.mtl_log_interface_err(
1111: cr.organization_id,
1112: user_id,
1113: login_id,
1114: prog_appid,
1627: --Start 2861248 :Populate Item Id for default revision only
1628: ---Start: Bug fix 3051653
1629: l_item_id := NULL;
1630: IF cr.item_number IS NULL THEN
1631: rtn_status := INVPUOPI.mtl_pr_parse_item_segments(p_row_id =>cr.rowid
1632: ,item_number =>l_item_number
1633: ,item_id =>l_item_id
1634: ,err_text => err_text);
1635: cr.item_number := l_item_number;
1638: end if;
1639:
1640: --Bug: 5512333
1641: IF cr.item_number IS NOT NULL THEN
1642: rtn_status := INVPUOPI.mtl_pr_parse_item_number(cr.item_number
1643: ,cr.inventory_item_id
1644: ,cr.transaction_id
1645: ,cr.organization_id
1646: ,err_text
1668: --Passing item number and organization_id to cursor for bug 3051653
1669: FOR c_revision_record IN c_get_revisions(l_item_number,
1670: cr.revision,cr.organization_id) LOOP
1671: IF l_item_id IS NULL THEN
1672: dumm_status := INVPUOPI.mtl_pr_parse_flex_name (
1673: c_revision_record.organization_id,
1674: 'MSTK', c_revision_record.item_number,
1675: flex_id, 0, err_temp);
1676: ELSE
1803: where rowid = cr.rowid ;
1804:
1805: if rtn_status <> 0 then
1806: if rtn_status=1403 then
1807: rtn_status := INVPUOPI.mtl_log_interface_err(
1808: l_org_id,
1809: user_id,
1810: login_id,
1811: prog_appid,
1817: 'MTL_SYSTEM_ITEMS_INTERFACE',
1818: 'INV_DESC_ITEM_ERROR',
1819: err_text);
1820: else
1821: rtn_status := INVPUOPI.mtl_log_interface_err(
1822: cr.organization_id,
1823: user_id,
1824: login_id,
1825: prog_appid,
1836: raise LOGGING_ERR;
1837: end if;
1838: end if;
1839: else --org_flag <> 0
1840: dumm_status := INVPUOPI.mtl_log_interface_err(
1841: l_org_id,
1842: user_id,
1843: login_id,
1844: prog_appid,
1866: return(0);
1867:
1868: exception
1869: when ASS_ITEM_ERR then
1870: dumm_status := INVPUOPI.mtl_log_interface_err(
1871: l_org_id,
1872: user_id,
1873: login_id,
1874: prog_appid,
1885: when LOGGING_ERR then
1886: return(dumm_status);
1887: when OTHERS then
1888: err_text := 'INVPAGI2.assign_item_header_recs:' || SQLERRM;
1889: dumm_status := INVPUOPI.mtl_log_interface_err(
1890: l_org_id ,
1891: user_id,
1892: login_id,
1893: prog_appid,