eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVPUOPI dependencies on INVPUOPI

Line 1: PACKAGE BODY INVPUOPI AS

1: PACKAGE BODY INVPUOPI AS
2: /* $Header: INVPUP1B.pls 120.7.12010000.2 2009/03/02 21:35:56 sanmani ship $ */
3:
4: l_application_id number(10) := 401;
5: l_id_flex_code varchar2(4) := 'MSTK';

Line 86: err_text := substr('INVPUOPI.parse_item:' || SQLERRM ,1, 240);

82: RETURN 0;
83:
84: EXCEPTION
85: WHEN OTHERS THEN
86: err_text := substr('INVPUOPI.parse_item:' || SQLERRM ,1, 240);
87: return(SQLCODE);
88: END mtl_pr_parse_item_segments;
89: ---End: Bug Fix 3051653
90:

Line 238: x_err_text := substr('INVPUOPI.parse_item:' || SQLERRM ,1, 240);

234: p_segment20 := seg_value(20);
235: x_err_text := NULL;
236: EXCEPTION
237: WHEN OTHERS THEN
238: x_err_text := substr('INVPUOPI.parse_item:' || SQLERRM ,1, 240);
239: END mtl_pr_parse_item_number;
240: --End :New overloaded procedure mtl_pr_parse_item_number
241:
242: FUNCTION mtl_pr_parse_item_number

Line 410: err_text := substr('INVPUOPI.parse_item:' || SQLERRM ,1, 240);

406:
407: EXCEPTION
408:
409: WHEN OTHERS THEN
410: err_text := substr('INVPUOPI.parse_item:' || SQLERRM ,1, 240);
411: return(SQLCODE);
412:
413: END mtl_pr_parse_item_number;
414:

Line 469: ret_code := INVPUOPI.mtl_pr_trans_prod_item (

465:
466: /* Search for the item id at production item table */
467: if flex_code = 'MSTK' then
468: statement_num := 2;
469: ret_code := INVPUOPI.mtl_pr_trans_prod_item (
470: flex_name,
471: org_id,
472: flex_id,
473: err_text);

Line 707: err_text := SUBSTRB('INVPUOPI.flex_name' || statement_num || SQLERRM, 1,240);

703: EXCEPTION
704:
705: WHEN others THEN
706: flex_id := NULL;
707: err_text := SUBSTRB('INVPUOPI.flex_name' || statement_num || SQLERRM, 1,240);
708: IF l_inv_debug_level IN(101, 102) THEN
709: INVPUTLI.info( err_text);
710: END IF;
711:

Line 824: err_text := substr('INVPUOPI.trans_item: ' || SQLERRM, 1,240);

820: EXCEPTION
821:
822: WHEN OTHERS THEN
823: item_id_out := NULL;
824: err_text := substr('INVPUOPI.trans_item: ' || SQLERRM, 1,240);
825: RETURN (SQLCODE);
826:
827: END mtl_pr_trans_prod_item;
828:

Line 852: err_text := substr('INVPUOPI.trans_org: ' || SQLERRM , 1, 240);

848: exception
849:
850: WHEN OTHERS THEN
851: org_id := NULL;
852: err_text := substr('INVPUOPI.trans_org: ' || SQLERRM , 1, 240);
853: return(SQLCODE);
854:
855: end mtl_pr_trans_org_id;
856:

Line 878: err_text := substr('INVPUOPI.parse_template: ' || SQLERRM, 1, 240);

874: exception
875:
876: WHEN OTHERS THEN
877: templ_id := NULL;
878: err_text := substr('INVPUOPI.parse_template: ' || SQLERRM, 1, 240);
879: return(SQLCODE);
880:
881: END mtl_pr_trans_template_id;
882:

Line 916: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: msg_name = '||msg_name);

912: dumm_status := INVUPD2B.get_message(msg_name, translated_text);
913: END IF;
914:
915: IF l_inv_debug_level IN(101, 102) THEN
916: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: msg_name = '||msg_name);
917: END IF;
918:
919: -- Bug 4052362 To display the entire error message - Anmurali
920:

Line 972: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);

968: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(translated_text,1,2000));
969: end if ;
970:
971: IF l_inv_debug_level IN(101, 102) THEN
972: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
973: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
974: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
975: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
976: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);

Line 973: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);

969: end if ;
970:
971: IF l_inv_debug_level IN(101, 102) THEN
972: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
973: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
974: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
975: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
976: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
977: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));

Line 974: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);

970:
971: IF l_inv_debug_level IN(101, 102) THEN
972: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
973: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
974: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
975: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
976: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
977: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
978: END IF;

Line 975: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);

971: IF l_inv_debug_level IN(101, 102) THEN
972: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
973: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
974: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
975: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
976: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
977: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
978: END IF;
979:

Line 976: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);

972: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
973: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
974: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
975: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
976: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
977: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
978: END IF;
979:
980: RETURN (0);

Line 977: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));

973: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
974: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
975: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
976: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
977: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
978: END IF;
979:
980: RETURN (0);
981:

Line 985: err_text := SUBSTRB('INVPUOPI.mtl_log_interface_err: ' || SQLERRM, 1,240);

981:
982: EXCEPTION
983:
984: WHEN others THEN
985: err_text := SUBSTRB('INVPUOPI.mtl_log_interface_err: ' || SQLERRM, 1,240);
986: RETURN (SQLCODE);
987:
988: END mtl_log_interface_err;
989:

Line 1067: err_text := substr('INVPUOPI.trans_item: ' || SQLERRM, 1,240);

1063: EXCEPTION
1064:
1065: WHEN OTHERS THEN
1066: item_id_out := NULL;
1067: err_text := substr('INVPUOPI.trans_item: ' || SQLERRM, 1,240);
1068: RETURN (SQLCODE);
1069:
1070: END mtl_pr_parse_item_name;
1071:

Line 1129: END INVPUOPI;

1125: WHEN NO_DATA_FOUND THEN
1126: G_CHECK_SEG_NUM := null;
1127: END;
1128:
1129: END INVPUOPI;