DBA Data[Home] [Help]

APPS.HZ_PAYMENT_METHOD_PUB dependencies on FND_MSG_PUB

Line 60: FND_MSG_PUB.initialize;

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;
64:

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 137: FND_MSG_PUB.Count_And_Get(

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);
141:

Line 145: FND_MSG_PUB.Count_And_Get(

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);
149:

Line 155: FND_MSG_PUB.ADD;

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(
157: p_encoded => FND_API.G_FALSE,
158: p_count => x_msg_count,
159: p_data => x_msg_data);

Line 156: FND_MSG_PUB.Count_And_Get(

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(
157: p_encoded => FND_API.G_FALSE,
158: p_count => x_msg_count,
159: p_data => x_msg_data);
160: END create_payment_method;

Line 212: FND_MSG_PUB.initialize;

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.
216: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 236: FND_MSG_PUB.ADD;

232: px_last_update_date = l_last_update_date ) )
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

Line 245: FND_MSG_PUB.ADD;

241: WHEN NO_DATA_FOUND THEN
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(

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 319: FND_MSG_PUB.Count_And_Get(

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);
323:

Line 327: FND_MSG_PUB.Count_And_Get(

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);
331:

Line 337: FND_MSG_PUB.ADD;

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(
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,
341: p_data => x_msg_data);

Line 338: FND_MSG_PUB.Count_And_Get(

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(
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,
341: p_data => x_msg_data);
342: END update_payment_method;

Line 366: FND_MSG_PUB.Reset;

362: FUNCTION logerror(SQLERRM VARCHAR2 DEFAULT NULL)
363: RETURN VARCHAR2 IS
364: l_msg_data VARCHAR2(2000);
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;

Line 368: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

364: l_msg_data VARCHAR2(2000);
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;

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 430: FND_MSG_PUB.ADD;

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;
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

Line 437: FND_MSG_PUB.ADD;

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;
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

Line 444: FND_MSG_PUB.ADD;

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;
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

Line 451: FND_MSG_PUB.ADD;

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;
453: END IF;
454:
455: -- check cust_account_id

Line 465: FND_MSG_PUB.ADD;

461: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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:

Line 480: FND_MSG_PUB.ADD;

476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 495: FND_MSG_PUB.ADD;

491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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:

Line 505: fnd_msg_pub.add;

501: IF NOT(p_payment_method_rec.primary_flag in ('Y','N')) THEN
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

Line 515: fnd_msg_pub.add;

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');
515: fnd_msg_pub.add;
516: raise fnd_api.g_exc_error;
517: END IF;
518: END IF;
519:

Line 531: FND_MSG_PUB.ADD;

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;
533:
534: END HZ_PAYMENT_METHOD_PUB;