35: porgn_code, pwhse_code);
36:
37: IF (l_iret = -21) THEN
38: FND_MESSAGE.set_name('GMI', 'INVCAL_FISCALYR_ERR');
39: APP_EXCEPTION.raise_exception;
40:
41: ELSIF (l_iret = -22) THEN
42: FND_MESSAGE.set_name('GMI', 'INVCAL_PERIOD_ERR');
43: APP_EXCEPTION.raise_exception;
39: APP_EXCEPTION.raise_exception;
40:
41: ELSIF (l_iret = -22) THEN
42: FND_MESSAGE.set_name('GMI', 'INVCAL_PERIOD_ERR');
43: APP_EXCEPTION.raise_exception;
44:
45: ELSIF (l_iret = -23) THEN
46: FND_MESSAGE.set_name('GMI', 'INVCAL_CLOSED_PERIOD_ERR');
47: APP_EXCEPTION.raise_exception;
43: APP_EXCEPTION.raise_exception;
44:
45: ELSIF (l_iret = -23) THEN
46: FND_MESSAGE.set_name('GMI', 'INVCAL_CLOSED_PERIOD_ERR');
47: APP_EXCEPTION.raise_exception;
48:
49: ELSIF (l_iret = -24) THEN
50: FND_MESSAGE.set_name('GMI', 'INVCAL_INVALIDCO_ERR');
51: APP_EXCEPTION.raise_exception;
47: APP_EXCEPTION.raise_exception;
48:
49: ELSIF (l_iret = -24) THEN
50: FND_MESSAGE.set_name('GMI', 'INVCAL_INVALIDCO_ERR');
51: APP_EXCEPTION.raise_exception;
52:
53: ELSIF (l_iret = -25) THEN
54: FND_MESSAGE.set_name('GMI', 'INVCAL_WHSE_CLOSED_ERR');
55: APP_EXCEPTION.raise_exception;
51: APP_EXCEPTION.raise_exception;
52:
53: ELSIF (l_iret = -25) THEN
54: FND_MESSAGE.set_name('GMI', 'INVCAL_WHSE_CLOSED_ERR');
55: APP_EXCEPTION.raise_exception;
56:
57: ELSIF (l_iret = -26) THEN
58: FND_MESSAGE.set_name('GMI', 'INVCAL_TRANS_DATE_ERR');
59: APP_EXCEPTION.raise_exception;
55: APP_EXCEPTION.raise_exception;
56:
57: ELSIF (l_iret = -26) THEN
58: FND_MESSAGE.set_name('GMI', 'INVCAL_TRANS_DATE_ERR');
59: APP_EXCEPTION.raise_exception;
60:
61: ELSIF (l_iret = -27) THEN
62: FND_MESSAGE.set_name('GMI', 'INVCAL_INVALIDORGN_ERR');
63: APP_EXCEPTION.raise_exception;
59: APP_EXCEPTION.raise_exception;
60:
61: ELSIF (l_iret = -27) THEN
62: FND_MESSAGE.set_name('GMI', 'INVCAL_INVALIDORGN_ERR');
63: APP_EXCEPTION.raise_exception;
64:
65: ELSIF (l_iret = -28) THEN
66: FND_MESSAGE.set_name('GMI', 'INVCAL_WHSEPARM_ERR');
67: APP_EXCEPTION.raise_exception;
63: APP_EXCEPTION.raise_exception;
64:
65: ELSIF (l_iret = -28) THEN
66: FND_MESSAGE.set_name('GMI', 'INVCAL_WHSEPARM_ERR');
67: APP_EXCEPTION.raise_exception;
68:
69: ELSIF (l_iret = -29) THEN
70: FND_MESSAGE.set_name('GMI', 'INVCAL_WHSE_ERR');
71: APP_EXCEPTION.raise_exception;
67: APP_EXCEPTION.raise_exception;
68:
69: ELSIF (l_iret = -29) THEN
70: FND_MESSAGE.set_name('GMI', 'INVCAL_WHSE_ERR');
71: APP_EXCEPTION.raise_exception;
72:
73: ELSIF (l_iret < -29) THEN
74: FND_MESSAGE.set_name('GMI', 'INVCAL_GENL_ERR');
75: APP_EXCEPTION.raise_exception;
71: APP_EXCEPTION.raise_exception;
72:
73: ELSIF (l_iret < -29) THEN
74: FND_MESSAGE.set_name('GMI', 'INVCAL_GENL_ERR');
75: APP_EXCEPTION.raise_exception;
76:
77: END IF;
78:
79: END trans_date_val;
125: pcur_uom, l_new_qty, pnew_uom, l_atomic);
126:
127: IF(l_iret = -68) THEN
128: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_HI_ERR');
129: APP_EXCEPTION.raise_exception;
130:
131: ELSIF (l_iret = -69) THEN
132: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');
133: APP_EXCEPTION.raise_exception;
129: APP_EXCEPTION.raise_exception;
130:
131: ELSIF (l_iret = -69) THEN
132: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');
133: APP_EXCEPTION.raise_exception;
134: END IF;
135:
136: END deviation_val;
137: /* =============================================
185:
186: IF (l_iret = -62) THEN
187: FND_MESSAGE.set_name('GMI', 'IC_LOCATION_ERR');
188: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
189: APP_EXCEPTION.raise_exception;
190: ELSIF (l_iret = -65) THEN
191: FND_MESSAGE.set_name('GMI', 'IC_WHSE_ERR');
192: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
193: APP_EXCEPTION.raise_exception;
189: APP_EXCEPTION.raise_exception;
190: ELSIF (l_iret = -65) THEN
191: FND_MESSAGE.set_name('GMI', 'IC_WHSE_ERR');
192: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
193: APP_EXCEPTION.raise_exception;
194: ELSIF (l_iret = -76) THEN
195: FND_MESSAGE.set_name('GMI', 'IC_WHSE_CNTLS_ERR');
196: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
197: APP_EXCEPTION.raise_exception;
193: APP_EXCEPTION.raise_exception;
194: ELSIF (l_iret = -76) THEN
195: FND_MESSAGE.set_name('GMI', 'IC_WHSE_CNTLS_ERR');
196: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
197: APP_EXCEPTION.raise_exception;
198: ELSIF (l_iret = -77) THEN
199: FND_MESSAGE.set_name('GMI', 'IC_DEFAULT_LOCT_ERR');
200: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
201: APP_EXCEPTION.raise_exception;
197: APP_EXCEPTION.raise_exception;
198: ELSIF (l_iret = -77) THEN
199: FND_MESSAGE.set_name('GMI', 'IC_DEFAULT_LOCT_ERR');
200: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
201: APP_EXCEPTION.raise_exception;
202: ELSIF (l_iret = -78) THEN
203: FND_MESSAGE.set_name('GMI', 'IC_USING_DEFAULT_LOCT_ERR');
204: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
205: APP_EXCEPTION.raise_exception;
201: APP_EXCEPTION.raise_exception;
202: ELSIF (l_iret = -78) THEN
203: FND_MESSAGE.set_name('GMI', 'IC_USING_DEFAULT_LOCT_ERR');
204: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
205: APP_EXCEPTION.raise_exception;
206: ELSIF (l_iret = -82) THEN
207: FND_MESSAGE.set_name('GMI', 'IC_NOT_LOCT_CTL_ERR');
208: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
209: APP_EXCEPTION.raise_exception;
205: APP_EXCEPTION.raise_exception;
206: ELSIF (l_iret = -82) THEN
207: FND_MESSAGE.set_name('GMI', 'IC_NOT_LOCT_CTL_ERR');
208: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
209: APP_EXCEPTION.raise_exception;
210: END IF;
211:
212: END itm_loct_validation;
213: /* =============================================