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.HZ_PAYMENT_METHOD_PUB dependencies on FND_API

Line 23: -- be fnd_api.g_ret_sts_success (success),

19: -- IN:
20: -- p_payment_method_rec Payment method record.
21: -- OUT:
22: -- x_return_status Return status after the call. The status can
23: -- be fnd_api.g_ret_sts_success (success),
24: -- fnd_api.g_ret_sts_error (error),
25: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
26: -- x_msg_count Number of messages in message stack.
27: -- x_msg_data Message text if x_msg_count is 1.

Line 24: -- fnd_api.g_ret_sts_error (error),

20: -- p_payment_method_rec Payment method record.
21: -- OUT:
22: -- x_return_status Return status after the call. The status can
23: -- be fnd_api.g_ret_sts_success (success),
24: -- fnd_api.g_ret_sts_error (error),
25: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
26: -- x_msg_count Number of messages in message stack.
27: -- x_msg_data Message text if x_msg_count is 1.
28: -- x_cust_receipt_method_id Payment method Id.

Line 25: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

21: -- OUT:
22: -- x_return_status Return status after the call. The status can
23: -- be fnd_api.g_ret_sts_success (success),
24: -- fnd_api.g_ret_sts_error (error),
25: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
26: -- x_msg_count Number of messages in message stack.
27: -- x_msg_data Message text if x_msg_count is 1.
28: -- x_cust_receipt_method_id Payment method Id.
29: --

Line 38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

34: -- 14-DEC-2004 Arnold Ng Created.
35: --
36:
37: PROCEDURE create_payment_method (
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_payment_method_rec IN payment_method_rec_type,
40: x_cust_receipt_method_id OUT NOCOPY NUMBER,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,

Line 59: IF FND_API.to_Boolean(p_init_msg_list) THEN

55: p_msg_level=>fnd_log.level_procedure);
56: END IF;
57:
58: -- initialize message list if p_init_msg_list is set to TRUE.
59: IF FND_API.to_Boolean(p_init_msg_list) THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: l_pm_rec := p_payment_method_rec;

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62:
63: l_pm_rec := p_payment_method_rec;
64:
65: --Initialize API return status to success.
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: validate_payment_method(
69: p_create_update_flag => 'C'
70: ,p_payment_method_rec => l_pm_rec

Line 73: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

69: p_create_update_flag => 'C'
70: ,p_payment_method_rec => l_pm_rec
71: ,x_return_status => x_return_status );
72:
73: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;

Line 74: RAISE FND_API.G_EXC_ERROR;

70: ,p_payment_method_rec => l_pm_rec
71: ,x_return_status => x_return_status );
72:
73: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:

Line 75: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

71: ,x_return_status => x_return_status );
72:
73: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: HZ_PAYMENT_METHOD_PKG.Insert_Row (

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72:
73: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
74: RAISE FND_API.G_EXC_ERROR;
75: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: HZ_PAYMENT_METHOD_PKG.Insert_Row (
80: x_cust_receipt_method_id => l_pm_rec.cust_receipt_method_id,

Line 115: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

111: p_cust_receipt_method_id => x_cust_receipt_method_id);
112: END IF;
113:
114: -- standard call to get message count and if count is 1, get message info.
115: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
116: p_count => x_msg_count,
117: p_data => x_msg_data);
118:
119: -- Debug info.

Line 134: WHEN FND_API.G_EXC_ERROR THEN

130: p_msg_level=>fnd_log.level_procedure);
131: END IF;
132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: ROLLBACK TO create_pm_pub;
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get(
138: p_encoded => FND_API.G_FALSE,

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132:
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: ROLLBACK TO create_pm_pub;
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get(
138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data);

Line 138: p_encoded => FND_API.G_FALSE,

134: WHEN FND_API.G_EXC_ERROR THEN
135: ROLLBACK TO create_pm_pub;
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get(
138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

138: p_encoded => FND_API.G_FALSE,
139: p_count => x_msg_count,
140: p_data => x_msg_data);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: ROLLBACK TO create_pm_pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get(
146: p_encoded => FND_API.G_FALSE,

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

140: p_data => x_msg_data);
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: ROLLBACK TO create_pm_pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get(
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data);

Line 146: p_encoded => FND_API.G_FALSE,

142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: ROLLBACK TO create_pm_pub;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get(
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data);
149:
150: WHEN OTHERS THEN

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

148: p_data => x_msg_data);
149:
150: WHEN OTHERS THEN
151: ROLLBACK TO create_pm_pub;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
155: FND_MSG_PUB.ADD;
156: FND_MSG_PUB.Count_And_Get(

Line 157: p_encoded => FND_API.G_FALSE,

153: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
154: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
155: FND_MSG_PUB.ADD;
156: FND_MSG_PUB.Count_And_Get(
157: p_encoded => FND_API.G_FALSE,
158: p_count => x_msg_count,
159: p_data => x_msg_data);
160: END create_payment_method;
161:

Line 176: -- be fnd_api.g_ret_sts_success (success),

172: -- IN/OUT:
173: -- px_last_update_date Last update date of payment method record.
174: -- OUT:
175: -- x_return_status Return status after the call. The status can
176: -- be fnd_api.g_ret_sts_success (success),
177: -- fnd_api.g_ret_sts_error (error),
178: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
179: -- x_msg_count Number of messages in message stack.
180: -- x_msg_data Message text if x_msg_count is 1.

Line 177: -- fnd_api.g_ret_sts_error (error),

173: -- px_last_update_date Last update date of payment method record.
174: -- OUT:
175: -- x_return_status Return status after the call. The status can
176: -- be fnd_api.g_ret_sts_success (success),
177: -- fnd_api.g_ret_sts_error (error),
178: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
179: -- x_msg_count Number of messages in message stack.
180: -- x_msg_data Message text if x_msg_count is 1.
181: --

Line 178: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

174: -- OUT:
175: -- x_return_status Return status after the call. The status can
176: -- be fnd_api.g_ret_sts_success (success),
177: -- fnd_api.g_ret_sts_error (error),
178: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
179: -- x_msg_count Number of messages in message stack.
180: -- x_msg_data Message text if x_msg_count is 1.
181: --
182: -- NOTES

Line 189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

185: --
186: -- 14-DEC-2004 Arnold Ng Created.
187:
188: PROCEDURE update_payment_method (
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_payment_method_rec IN payment_method_rec_type,
191: px_last_update_date IN OUT NOCOPY DATE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,

Line 211: IF FND_API.to_Boolean(p_init_msg_list) THEN

207: p_msg_level=>fnd_log.level_procedure);
208: END IF;
209:
210: -- initialize message list if p_init_msg_list is set to TRUE.
211: IF FND_API.to_Boolean(p_init_msg_list) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: --Initialize API return status to success.

Line 216: x_return_status := FND_API.G_RET_STS_SUCCESS;

212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: --Initialize API return status to success.
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217:
218: -- Lock record.
219: BEGIN
220: l_pm_id := p_payment_method_rec.cust_receipt_method_id;

Line 237: RAISE FND_API.G_EXC_ERROR;

233: THEN
234: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
235: FND_MESSAGE.SET_TOKEN( 'TABLE', 'RA_CUST_RECEIPT_METHODS' );
236: FND_MSG_PUB.ADD;
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240: EXCEPTION
241: WHEN NO_DATA_FOUND THEN

Line 246: RAISE FND_API.G_EXC_ERROR;

242: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
243: FND_MESSAGE.SET_TOKEN( 'RECORD', 'RA_CUST_RECEIPT_METHODS' );
244: FND_MESSAGE.SET_TOKEN( 'VALUE', l_pm_id);
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_ERROR;
247: END;
248:
249: validate_payment_method(
250: p_create_update_flag => 'U'

Line 254: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

250: p_create_update_flag => 'U'
251: ,p_payment_method_rec => p_payment_method_rec
252: ,x_return_status => x_return_status );
253:
254: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;

Line 255: RAISE FND_API.G_EXC_ERROR;

251: ,p_payment_method_rec => p_payment_method_rec
252: ,x_return_status => x_return_status );
253:
254: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259:

Line 256: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

252: ,x_return_status => x_return_status );
253:
254: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259:
260: HZ_PAYMENT_METHOD_PKG.Update_Row(

Line 257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

253:
254: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259:
260: HZ_PAYMENT_METHOD_PKG.Update_Row(
261: x_rowid => l_rowid,

Line 297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

293: p_cust_receipt_method_id => p_payment_method_rec.cust_receipt_method_id);
294: END IF;
295:
296: -- standard call to get message count and if count is 1, get message info.
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
298: p_count => x_msg_count,
299: p_data => x_msg_data);
300:
301: -- Debug info.

Line 316: WHEN FND_API.G_EXC_ERROR THEN

312: p_msg_level=>fnd_log.level_procedure);
313: END IF;
314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO update_pm_pub;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,

Line 318: x_return_status := FND_API.G_RET_STS_ERROR;

314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO update_pm_pub;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_msg_count,
322: p_data => x_msg_data);

Line 320: p_encoded => FND_API.G_FALSE,

316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO update_pm_pub;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_msg_count,
322: p_data => x_msg_data);
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

320: p_encoded => FND_API.G_FALSE,
321: p_count => x_msg_count,
322: p_data => x_msg_data);
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO update_pm_pub;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get(
328: p_encoded => FND_API.G_FALSE,

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: p_data => x_msg_data);
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO update_pm_pub;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get(
328: p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data);

Line 328: p_encoded => FND_API.G_FALSE,

324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO update_pm_pub;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get(
328: p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data);
331:
332: WHEN OTHERS THEN

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

330: p_data => x_msg_data);
331:
332: WHEN OTHERS THEN
333: ROLLBACK TO update_pm_pub;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
336: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
337: FND_MSG_PUB.ADD;
338: FND_MSG_PUB.Count_And_Get(

Line 339: p_encoded => FND_API.G_FALSE,

335: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
336: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
337: FND_MSG_PUB.ADD;
338: FND_MSG_PUB.Count_And_Get(
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,
341: p_data => x_msg_data);
342: END update_payment_method;
343:

Line 369: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

365: BEGIN
366: FND_MSG_PUB.Reset;
367:
368: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
369: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
370: END LOOP;
371: IF (SQLERRM IS NOT NULL) THEN
372: l_msg_data := l_msg_data || SQLERRM;
373: END IF;

Line 391: -- be fnd_api.g_ret_sts_success (success),

387: -- p_create_update_flag Create or update flag.
388: -- p_payment_method_rec Payment method record.
389: -- OUT:
390: -- x_return_status Return status after the call. The status can
391: -- be fnd_api.g_ret_sts_success (success),
392: -- fnd_api.g_ret_sts_error (error),
393: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
394: --
395: -- NOTES

Line 392: -- fnd_api.g_ret_sts_error (error),

388: -- p_payment_method_rec Payment method record.
389: -- OUT:
390: -- x_return_status Return status after the call. The status can
391: -- be fnd_api.g_ret_sts_success (success),
392: -- fnd_api.g_ret_sts_error (error),
393: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
394: --
395: -- NOTES
396: --

Line 393: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

389: -- OUT:
390: -- x_return_status Return status after the call. The status can
391: -- be fnd_api.g_ret_sts_success (success),
392: -- fnd_api.g_ret_sts_error (error),
393: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
394: --
395: -- NOTES
396: --
397: -- MODIFICATION HISTORY

Line 427: IF(p_payment_method_rec.receipt_method_id IS NULL OR p_payment_method_rec.receipt_method_id = FND_API.G_MISS_NUM) THEN

423: WHERE receipt_method_id = l_rm_id
424: AND sysdate between start_date and nvl(end_date, sysdate);
425: BEGIN
426: -- check not null first
427: IF(p_payment_method_rec.receipt_method_id IS NULL OR p_payment_method_rec.receipt_method_id = FND_API.G_MISS_NUM) THEN
428: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
429: FND_MESSAGE.SET_TOKEN('COLUMN' ,'RECEIPT_METHOD_ID');
430: FND_MSG_PUB.ADD;
431: RAISE FND_API.G_EXC_ERROR;

Line 431: RAISE FND_API.G_EXC_ERROR;

427: IF(p_payment_method_rec.receipt_method_id IS NULL OR p_payment_method_rec.receipt_method_id = FND_API.G_MISS_NUM) THEN
428: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
429: FND_MESSAGE.SET_TOKEN('COLUMN' ,'RECEIPT_METHOD_ID');
430: FND_MSG_PUB.ADD;
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433:
434: IF(p_payment_method_rec.primary_flag IS NULL OR p_payment_method_rec.primary_flag = FND_API.G_MISS_CHAR) THEN
435: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 434: IF(p_payment_method_rec.primary_flag IS NULL OR p_payment_method_rec.primary_flag = FND_API.G_MISS_CHAR) THEN

430: FND_MSG_PUB.ADD;
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433:
434: IF(p_payment_method_rec.primary_flag IS NULL OR p_payment_method_rec.primary_flag = FND_API.G_MISS_CHAR) THEN
435: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
436: FND_MESSAGE.SET_TOKEN('COLUMN' ,'PRIMARY_FLAG');
437: FND_MSG_PUB.ADD;
438: RAISE FND_API.G_EXC_ERROR;

Line 438: RAISE FND_API.G_EXC_ERROR;

434: IF(p_payment_method_rec.primary_flag IS NULL OR p_payment_method_rec.primary_flag = FND_API.G_MISS_CHAR) THEN
435: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
436: FND_MESSAGE.SET_TOKEN('COLUMN' ,'PRIMARY_FLAG');
437: FND_MSG_PUB.ADD;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440:
441: IF(p_payment_method_rec.cust_account_id IS NULL OR p_payment_method_rec.cust_account_id = FND_API.G_MISS_NUM) THEN
442: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 441: IF(p_payment_method_rec.cust_account_id IS NULL OR p_payment_method_rec.cust_account_id = FND_API.G_MISS_NUM) THEN

437: FND_MSG_PUB.ADD;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440:
441: IF(p_payment_method_rec.cust_account_id IS NULL OR p_payment_method_rec.cust_account_id = FND_API.G_MISS_NUM) THEN
442: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
443: FND_MESSAGE.SET_TOKEN('COLUMN' ,'CUSTOMER_ID');
444: FND_MSG_PUB.ADD;
445: RAISE FND_API.G_EXC_ERROR;

Line 445: RAISE FND_API.G_EXC_ERROR;

441: IF(p_payment_method_rec.cust_account_id IS NULL OR p_payment_method_rec.cust_account_id = FND_API.G_MISS_NUM) THEN
442: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
443: FND_MESSAGE.SET_TOKEN('COLUMN' ,'CUSTOMER_ID');
444: FND_MSG_PUB.ADD;
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448: IF(p_payment_method_rec.start_date IS NULL or p_payment_method_rec.start_date = FND_API.G_MISS_DATE) THEN
449: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 448: IF(p_payment_method_rec.start_date IS NULL or p_payment_method_rec.start_date = FND_API.G_MISS_DATE) THEN

444: FND_MSG_PUB.ADD;
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448: IF(p_payment_method_rec.start_date IS NULL or p_payment_method_rec.start_date = FND_API.G_MISS_DATE) THEN
449: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
450: FND_MESSAGE.SET_TOKEN('COLUMN' ,'START_DATE');
451: FND_MSG_PUB.ADD;
452: RAISE FND_API.G_EXC_ERROR;

Line 452: RAISE FND_API.G_EXC_ERROR;

448: IF(p_payment_method_rec.start_date IS NULL or p_payment_method_rec.start_date = FND_API.G_MISS_DATE) THEN
449: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
450: FND_MESSAGE.SET_TOKEN('COLUMN' ,'START_DATE');
451: FND_MSG_PUB.ADD;
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454:
455: -- check cust_account_id
456: OPEN check_cust_acct_id(p_payment_method_rec.cust_account_id);

Line 466: RAISE FND_API.G_EXC_ERROR;

462: FND_MESSAGE.SET_TOKEN('FK','CUSTOMER_ID');
463: FND_MESSAGE.SET_TOKEN('COLUMN','CUST_ACCOUNT_ID');
464: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
465: FND_MSG_PUB.ADD;
466: RAISE FND_API.G_EXC_ERROR;
467: END IF;
468: CLOSE check_cust_acct_id;
469:
470: -- check site_use_id and customer_id

Line 471: IF NOT(p_payment_method_rec.site_use_id IS NULL or p_payment_method_rec.site_use_id = FND_API.G_MISS_NUM) THEN

467: END IF;
468: CLOSE check_cust_acct_id;
469:
470: -- check site_use_id and customer_id
471: IF NOT(p_payment_method_rec.site_use_id IS NULL or p_payment_method_rec.site_use_id = FND_API.G_MISS_NUM) THEN
472: OPEN check_site_use_id(p_payment_method_rec.cust_account_id, p_payment_method_rec.site_use_id);
473: FETCH check_site_use_id INTO l_dummy;
474: IF(check_site_use_id%NOTFOUND) THEN
475: CLOSE check_site_use_id;

Line 481: RAISE FND_API.G_EXC_ERROR;

477: FND_MESSAGE.SET_TOKEN('FK','SITE_USE_ID');
478: FND_MESSAGE.SET_TOKEN('COLUMN','SITE_USE_ID');
479: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_SITE_USES_ALL');
480: FND_MSG_PUB.ADD;
481: RAISE FND_API.G_EXC_ERROR;
482: END IF;
483: CLOSE check_site_use_id;
484: END IF;
485:

Line 496: RAISE FND_API.G_EXC_ERROR;

492: FND_MESSAGE.SET_TOKEN('FK','RECEIPT_METHOD_ID');
493: FND_MESSAGE.SET_TOKEN('COLUMN','RECEIPT_METHOD_ID');
494: FND_MESSAGE.SET_TOKEN('TABLE','AR_RECEIPT_METHODS');
495: FND_MSG_PUB.ADD;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: CLOSE check_receipt_method_id;
499:
500: -- check primary_flag

Line 506: raise fnd_api.g_exc_error;

502: fnd_message.set_name('AR', 'HZ_API_INVALID_LOOKUP');
503: fnd_message.set_token('COLUMN', 'PRIMARY_FLAG');
504: fnd_message.set_token('LOOKUP_TYPE', 'YES/NO');
505: fnd_msg_pub.add;
506: raise fnd_api.g_exc_error;
507: END IF;
508:
509: -- check start_date and end_date
510: IF NOT(p_payment_method_rec.end_date IS NULL or p_payment_method_rec.end_date = FND_API.G_MISS_DATE) THEN

Line 510: IF NOT(p_payment_method_rec.end_date IS NULL or p_payment_method_rec.end_date = FND_API.G_MISS_DATE) THEN

506: raise fnd_api.g_exc_error;
507: END IF;
508:
509: -- check start_date and end_date
510: IF NOT(p_payment_method_rec.end_date IS NULL or p_payment_method_rec.end_date = FND_API.G_MISS_DATE) THEN
511: IF(p_payment_method_rec.start_date > p_payment_method_rec.end_date) THEN
512: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
513: fnd_message.set_token('DATE2', 'END_DATE');
514: fnd_message.set_token('DATE1', 'START_DATE');

Line 516: raise fnd_api.g_exc_error;

512: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
513: fnd_message.set_token('DATE2', 'END_DATE');
514: fnd_message.set_token('DATE1', 'START_DATE');
515: fnd_msg_pub.add;
516: raise fnd_api.g_exc_error;
517: END IF;
518: END IF;
519:
520: EXCEPTION

Line 521: WHEN FND_API.G_EXC_ERROR THEN

517: END IF;
518: END IF;
519:
520: EXCEPTION
521: WHEN FND_API.G_EXC_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 522: x_return_status := FND_API.G_RET_STS_ERROR;

518: END IF;
519:
520: EXCEPTION
521: WHEN FND_API.G_EXC_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526:

Line 524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

520: EXCEPTION
521: WHEN FND_API.G_EXC_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526:
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

521: WHEN FND_API.G_EXC_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526:
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526:
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
531: FND_MSG_PUB.ADD;
532: END validate_payment_method;