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.WSMPINVL dependencies on WSMPINVL

Line 1: PACKAGE BODY WSMPINVL AS

1: PACKAGE BODY WSMPINVL AS
2: /* $Header: WSMINVLB.pls 120.7.12010000.3 2009/12/02 12:23:19 sisankar ship $ */
3:
4: /*============================================================================+
5: | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CalIFornia, USA |

Line 143: AND process_status = WSMPINVL.PENDING

139: CURSOR NO_GRP_ID_ROWS IS
140: SELECT header_id
141: FROM wsm_lot_split_merges_interface
142: WHERE group_id IS NULL
143: AND process_status = WSMPINVL.PENDING
144: AND transaction_date <= SYSDATE
145: ORDER BY transaction_date;
146:
147: Cursor txns IS

Line 154: AND process_status = WSMPINVL.PENDING

150: , organization_id -- bugfix 2832025/2841055: added orgn_id
151: FROM wsm_lot_split_merges_interface
152: WHERE nvl(group_id,-1) = nvl(p_group_id, nvl(group_id,-1) )
153: AND header_id = nvl(p_header_id, header_id)
154: AND process_status = WSMPINVL.PENDING
155: AND transaction_date <= SYSDATE
156: ORDER BY transaction_date;
157:
158: --bugfix 2624791 added cursor comp_txns, the cursor picks up same rows as txns, but select status = complete.

Line 167: AND process_status = WSMPINVL.COMPLETE

163: transaction_type_id, created_by, transaction_date
164: FROM wsm_lot_split_merges_interface
165: WHERE nvl(group_id,-1) = nvl(p_group_id, nvl(group_id,-1) )
166: AND header_id = nvl(p_header_id, header_id)
167: AND process_status = WSMPINVL.COMPLETE
168: AND transaction_date <= SYSDATE
169: ORDER BY transaction_date;
170:
171: l_header_id NUMBER;

Line 225: if (p_mode = WSMPINVL.CONCURRENT) then

221: -- which the GROUP_ID is null.
222:
223: **/
224:
225: if (p_mode = WSMPINVL.CONCURRENT) then
226: --
227: -- Populate the group_id column if null only in case of CONCURRENT mode.
228: --
229: if (p_group_id IS NULL ) then

Line 1895: o_err_message:= substr(('WSMPINVL.Validate_resulting'||SQLERRM), 1, 2000);

1891: NULL;
1892:
1893: when others THEN
1894: x_err_code := SQLCODE;
1895: o_err_message:= substr(('WSMPINVL.Validate_resulting'||SQLERRM), 1, 2000);
1896: err_status := -1;
1897: return;
1898:
1899: END;

Line 1982: o_err_message:= substr(('WSMPINVL.Validate_resulting'||SQLERRM), 1, 2000);

1978:
1979:
1980: when others THEN
1981: x_err_code := SQLCODE;
1982: o_err_message:= substr(('WSMPINVL.Validate_resulting'||SQLERRM), 1, 2000);
1983: err_status := -1;
1984: return;
1985:
1986:

Line 2524: o_err_message:= substr(('WSMPINVL.Validate_Merge: '||SQLERRM), 1, 2000);

2520: null;
2521:
2522: when others then
2523: x_err_code := SQLCODE;
2524: o_err_message:= substr(('WSMPINVL.Validate_Merge: '||SQLERRM), 1, 2000);
2525: err_status := -1;
2526: return;
2527:
2528: END;

Line 2572: o_err_message:= substr(('WSMPINVL.Validate_Merge: '||SQLERRM), 1, 2000);

2568: EXCEPTION --BBK
2569:
2570: when others then
2571: x_err_code := SQLCODE;
2572: o_err_message:= substr(('WSMPINVL.Validate_Merge: '||SQLERRM), 1, 2000);
2573: err_status := -1;
2574: return;
2575:
2576: END ;

Line 2646: o_err_message:= substr(('WSMPINVL.Validate_Merge: '||SQLERRM), 1, 2000);

2642: NULL;
2643:
2644: when others THEN
2645: x_err_code := SQLCODE;
2646: o_err_message:= substr(('WSMPINVL.Validate_Merge: '||SQLERRM), 1, 2000);
2647: err_status := -1;
2648: return;
2649:
2650: END;

Line 3309: x_err_msg := substr(('WSMPINVL.CREATE_EXTRA_RECORD('

3305: END IF;
3306: EXCEPTION
3307: WHEN NO_DATA_FOUND THEN
3308: x_err_code := SQLCODE;
3309: x_err_msg := substr(('WSMPINVL.CREATE_EXTRA_RECORD('
3310: ||l_stmt_num
3311: || '): '
3312: || SQLERRM) ,1,2000);
3313: /*BA#IIIP*/

Line 3325: x_err_msg := substr(('WSMPINVL.CREATE_EXTRA_RECORD('

3321: /*EA#IIIP*/
3322:
3323: WHEN OTHERS THEN
3324: x_err_code := SQLCODE;
3325: x_err_msg := substr(('WSMPINVL.CREATE_EXTRA_RECORD('
3326: ||l_stmt_num
3327: || '): '
3328: || SQLERRM) ,1,2000);
3329: /*BA#IIIP*/

Line 4275: ('WSMPINVL.CREATE_MTL_RECORDS('

4271:
4272: WHEN OTHERS THEN
4273: x_err_code := SQLCODE;
4274: x_err_msg := substr(
4275: ('WSMPINVL.CREATE_MTL_RECORDS('
4276: ||l_stmt_num
4277: || '): '
4278: || x_err_code
4279: ), 1, 2000);

Line 4666: ('WSMPINVL.MISC_ISSUE('

4662: EXCEPTION
4663: WHEN OTHERS THEN
4664: x_err_code := SQLCODE;
4665: x_err_msg := substr(
4666: ('WSMPINVL.MISC_ISSUE('
4667: ||l_stmt_num
4668: || '): '
4669: || SQLERRM
4670: ), 1, 2000);

Line 5055: ('WSMPINVL.MISC_RECEIPT('

5051: EXCEPTION
5052: WHEN OTHERS THEN
5053: x_err_code := SQLCODE;
5054: x_err_msg := substr(
5055: ('WSMPINVL.MISC_RECEIPT('
5056: ||l_stmt_num
5057: || '): '
5058: || SQLERRM
5059: ), 1, 2000);

Line 5407: ('WSMPINVL.SUCCESS_ALL('

5403: EXCEPTION
5404: WHEN OTHERS THEN
5405: x_err_code := SQLCODE;
5406: x_err_msg := substr(
5407: ('WSMPINVL.SUCCESS_ALL('
5408: ||l_stmt_num
5409: || '): '
5410: || SQLERRM
5411: ), 1, 2000);

Line 5520: ('WSMPINVL.ERROR_ALL('

5516: EXCEPTION
5517: WHEN OTHERS THEN
5518: x_err_num := SQLCODE;
5519: x_err_msg := substr(
5520: ('WSMPINVL.ERROR_ALL('
5521: ||l_stmt_num
5522: || '): '
5523: || SQLERRM
5524: ), 1, 2000);

Line 5633: END WSMPINVL;

5629:
5630: End writeToLog;
5631: /*EA#IIIP*/
5632: ------------------------------------------------------------------
5633: END WSMPINVL;