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.9.12020000.5 2013/01/23 08:31:14 lmai 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 726: err_text := SUBSTRB('INVPUOPI.flex_name' || statement_num || SQLERRM, 1,240);

722: EXCEPTION
723:
724: WHEN others THEN
725: flex_id := NULL;
726: err_text := SUBSTRB('INVPUOPI.flex_name' || statement_num || SQLERRM, 1,240);
727: IF l_inv_debug_level IN(101, 102) THEN
728: INVPUTLI.info( err_text);
729: END IF;
730:

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

839: EXCEPTION
840:
841: WHEN OTHERS THEN
842: item_id_out := NULL;
843: err_text := substr('INVPUOPI.trans_item: ' || SQLERRM, 1,240);
844: RETURN (SQLCODE);
845:
846: END mtl_pr_trans_prod_item;
847:

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

867: exception
868:
869: WHEN OTHERS THEN
870: org_id := NULL;
871: err_text := substr('INVPUOPI.trans_org: ' || SQLERRM , 1, 240);
872: return(SQLCODE);
873:
874: end mtl_pr_trans_org_id;
875:

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

893: exception
894:
895: WHEN OTHERS THEN
896: templ_id := NULL;
897: err_text := substr('INVPUOPI.parse_template: ' || SQLERRM, 1, 240);
898: return(SQLCODE);
899:
900: END mtl_pr_trans_template_id;
901:

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

931: dumm_status := INVUPD2B.get_message(msg_name, translated_text);
932: END IF;
933:
934: IF l_inv_debug_level IN(101, 102) THEN
935: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: msg_name = '||msg_name);
936: END IF;
937:
938: -- Bug 4052362 To display the entire error message - Anmurali
939:

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

987: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(translated_text,1,2000));
988: end if ;
989:
990: IF l_inv_debug_level IN(101, 102) THEN
991: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
992: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
993: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
994: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
995: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);

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

988: end if ;
989:
990: IF l_inv_debug_level IN(101, 102) THEN
991: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
992: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
993: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
994: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
995: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
996: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));

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

989:
990: IF l_inv_debug_level IN(101, 102) THEN
991: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
992: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
993: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
994: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
995: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
996: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
997: END IF;

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

990: IF l_inv_debug_level IN(101, 102) THEN
991: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
992: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
993: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
994: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
995: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
996: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
997: END IF;
998:

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

991: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);
992: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
993: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
994: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
995: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
996: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
997: END IF;
998:
999: RETURN (0);

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

992: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ORGANIZATION ID : ' || org_id);
993: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TABLE NAME : ' || tbl_name);
994: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: COLUMN NAME : ' || p_column_name);
995: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: MESSAGE NAME : ' || msg_name);
996: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: ERROR MESSAGE : ' || substrb(translated_text,1,2000));
997: END IF;
998:
999: RETURN (0);
1000:

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

1000:
1001: EXCEPTION
1002:
1003: WHEN others THEN
1004: err_text := SUBSTRB('INVPUOPI.mtl_log_interface_err: ' || SQLERRM, 1,240);
1005: RETURN (SQLCODE);
1006:
1007: END mtl_log_interface_err;
1008:

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

1082: EXCEPTION
1083:
1084: WHEN OTHERS THEN
1085: item_id_out := NULL;
1086: err_text := substr('INVPUOPI.trans_item: ' || SQLERRM, 1,240);
1087: RETURN (SQLCODE);
1088:
1089: END mtl_pr_parse_item_name;
1090:

Line 1148: END INVPUOPI;

1144: WHEN NO_DATA_FOUND THEN
1145: G_CHECK_SEG_NUM := null;
1146: END;
1147:
1148: END INVPUOPI;