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

Line 46: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

42:
43: -- Validate Citibank credit card batch
44: PROCEDURE Validate_Citibank_Batch (
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
47: P_MBATCH_ID IN NUMBER,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2

Line 86: if NOT FND_API.Compatible_API_Call( l_api_version,

82: BEGIN
83: -- SAVEPOINT Validate_Paymentech_Batch;
84:
85: -- Standard call to check for call compatibility
86: if NOT FND_API.Compatible_API_Call( l_api_version,
87: p_api_version,
88: l_api_name,
89: G_PKG_NAME ) then
90: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 90: raise FND_API.G_EXC_UNEXPECTED_ERROR;

86: if NOT FND_API.Compatible_API_Call( l_api_version,
87: p_api_version,
88: l_api_name,
89: G_PKG_NAME ) then
90: raise FND_API.G_EXC_UNEXPECTED_ERROR;
91: end if;
92:
93: if FND_API.To_Boolean(p_init_msg_list) then
94: FND_MSG_PUB.initialize;

Line 93: if FND_API.To_Boolean(p_init_msg_list) then

89: G_PKG_NAME ) then
90: raise FND_API.G_EXC_UNEXPECTED_ERROR;
91: end if;
92:
93: if FND_API.To_Boolean(p_init_msg_list) then
94: FND_MSG_PUB.initialize;
95: end if;
96:
97: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: if FND_API.To_Boolean(p_init_msg_list) then
94: FND_MSG_PUB.initialize;
95: end if;
96:
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: if PG_DEBUG in ('Y', 'C') then
100: null; -- iby.debug('some info');
101: end if;

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: from iby_batches_all
107: where mbatchid = P_MBATCH_ID;
108:
109: if l_batchid_size > 8 then
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
112: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
113: FND_MSG_PUB.add;
114: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: l_trxn_rec.instr_owner_country,
128: l_validzip );
129:
130: if l_validzip = 'N' then
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
133: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
134: FND_MSG_PUB.add;
135: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144: l_trxn_rec.instr_owner_country,
145: l_validzip );
146:
147: if l_validzip = 'N' then
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
150: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
151: FND_MSG_PUB.add;
152: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: l_trxn_rec.shipfromcountry, -- this does NOT exist now
162: l_validzip );
163:
164: if l_validzip = 'N' then
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
167: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
168: FND_MSG_PUB.add;
169: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

175: l_trxn_rec.shiptocountry, -- this does NOT exist now
176: l_validzip );
177:
178: if l_validzip = 'N' then
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
181: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
182: FND_MSG_PUB.add;
183: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 203: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

199:
200: -- Validate FDCNorth credit card batch
201: PROCEDURE Validate_FDCNorth_Batch (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
204: P_MBATCH_ID IN NUMBER,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2

Line 248: if NOT FND_API.Compatible_API_Call( l_api_version,

244: BEGIN
245: -- SAVEPOINT Validate_Paymentech_Batch;
246:
247: -- Standard call to check for call compatibility
248: if NOT FND_API.Compatible_API_Call( l_api_version,
249: p_api_version,
250: l_api_name,
251: G_PKG_NAME ) then
252: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 252: raise FND_API.G_EXC_UNEXPECTED_ERROR;

248: if NOT FND_API.Compatible_API_Call( l_api_version,
249: p_api_version,
250: l_api_name,
251: G_PKG_NAME ) then
252: raise FND_API.G_EXC_UNEXPECTED_ERROR;
253: end if;
254:
255: if FND_API.To_Boolean(p_init_msg_list) then
256: FND_MSG_PUB.initialize;

Line 255: if FND_API.To_Boolean(p_init_msg_list) then

251: G_PKG_NAME ) then
252: raise FND_API.G_EXC_UNEXPECTED_ERROR;
253: end if;
254:
255: if FND_API.To_Boolean(p_init_msg_list) then
256: FND_MSG_PUB.initialize;
257: end if;
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

255: if FND_API.To_Boolean(p_init_msg_list) then
256: FND_MSG_PUB.initialize;
257: end if;
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: if PG_DEBUG in ('Y', 'C') then
262: null; -- iby.debug('some info');
263: end if;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344: TRUNC(batchclosedate) = l_batch_close_date
345: ;
346:
347: if l_batch_count > 9 then
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
350: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch count per merchant security code');
351: FND_MSG_PUB.add;
352: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373: * types.
374: */
375: if l_trxn_rec.reqtype not in ('ORAPMTCAPTURE', 'ORAPMTCREDIT',
376: 'ORAPMTRETURN') then
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
379: FND_MESSAGE.set_token('ERR_OBJECT', 'Transaction type');
380: FND_MSG_PUB.add;
381: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388: l_trxn_rec.instr_owner_country,
389: l_validzip );
390:
391: if l_validzip = 'N' then
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
394: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
395: FND_MSG_PUB.add;
396: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 410: x_return_status := FND_API.G_RET_STS_ERROR;

406: l_trxn_rec.instr_owner_country,
407: l_validzip );
408:
409: if l_validzip = 'N' then
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
412: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
413: FND_MSG_PUB.add;
414: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: l_trxn_rec.shipfromcountry, -- this does NOT exist now
422: l_validzip );
423:
424: if l_validzip = 'N' then
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
427: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
428: FND_MSG_PUB.add;
429: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435: l_trxn_rec.shiptocountry, -- this does NOT exist now
436: l_validzip );
437:
438: if l_validzip = 'N' then
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
441: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
442: FND_MSG_PUB.add;
443: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452: l_trxn_rec.instr_owner_country,
453: l_validzip );
454:
455: if l_validzip = 'N' then
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
458: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
459: FND_MSG_PUB.add;
460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 472: x_return_status := FND_API.G_RET_STS_ERROR;

468: x_msg_count,
469: x_msg_data);
470: /*
471: if l_cust_trx_id = 0 then
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
474: return;
475: else
476: begin

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: from ar_invoice_lines_v
481: where customer_trx_id = l_cust_trx_id;
482:
483: if l_doc_line_count > 98 then
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
486: FND_MESSAGE.set_token('ERR_OBJECT', 'Invoice line count for Visa purchase card');
487: FND_MSG_PUB.add;
488: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

511: l_ship_to_country,
512: l_validzip );
513:
514: if l_validzip = 'N' then
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
517: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
518: FND_MSG_PUB.add;
519: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 540: if x_return_status = FND_API.G_RET_STS_SUCCESS then

536: end loop;
537: close level2_trxn;
538:
539: -- Bug 4243738: Added
540: if x_return_status = FND_API.G_RET_STS_SUCCESS then
541: update iby_batches_all
542: set SENTCOUNTERDAILY = l_batch_count
543: where mbatchid = P_MBATCH_ID;
544: end if;

Line 553: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

549:
550: -- Validate Paymentech credit card batch
551: PROCEDURE Validate_Paymentech_Batch (
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
554: P_MBATCH_ID IN NUMBER,
555: x_return_status OUT NOCOPY VARCHAR2,
556: x_msg_count OUT NOCOPY NUMBER,
557: x_msg_data OUT NOCOPY VARCHAR2

Line 593: if NOT FND_API.Compatible_API_Call( l_api_version,

589: BEGIN
590: -- SAVEPOINT Validate_Paymentech_Batch;
591:
592: -- Standard call to check for call compatibility
593: if NOT FND_API.Compatible_API_Call( l_api_version,
594: p_api_version,
595: l_api_name,
596: G_PKG_NAME ) then
597: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 597: raise FND_API.G_EXC_UNEXPECTED_ERROR;

593: if NOT FND_API.Compatible_API_Call( l_api_version,
594: p_api_version,
595: l_api_name,
596: G_PKG_NAME ) then
597: raise FND_API.G_EXC_UNEXPECTED_ERROR;
598: end if;
599:
600: if FND_API.To_Boolean(p_init_msg_list) then
601: FND_MSG_PUB.initialize;

Line 600: if FND_API.To_Boolean(p_init_msg_list) then

596: G_PKG_NAME ) then
597: raise FND_API.G_EXC_UNEXPECTED_ERROR;
598: end if;
599:
600: if FND_API.To_Boolean(p_init_msg_list) then
601: FND_MSG_PUB.initialize;
602: end if;
603:
604: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 604: x_return_status := FND_API.G_RET_STS_SUCCESS;

600: if FND_API.To_Boolean(p_init_msg_list) then
601: FND_MSG_PUB.initialize;
602: end if;
603:
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605:
606: if PG_DEBUG in ('Y', 'C') then
607: null; -- iby.debug('some info');
608: end if;

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613: from iby_batches_all
614: where mbatchid = P_MBATCH_ID;
615:
616: if l_batchid_size > 8 then
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
619: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
620: FND_MSG_PUB.add;
621: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 637: x_return_status := FND_API.G_RET_STS_ERROR;

633: l_trxn_rec.instr_owner_country,
634: l_validzip );
635:
636: if l_validzip = 'N' then
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
639: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
640: FND_MSG_PUB.add;
641: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651: l_trxn_rec.instr_owner_country,
652: l_validzip );
653:
654: if l_validzip = 'N' then
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
657: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
658: FND_MSG_PUB.add;
659: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666: l_trxn_rec.shipfromcountry, -- this does NOT exist now
667: l_validzip );
668:
669: if l_validzip = 'N' then
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
672: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
673: FND_MSG_PUB.add;
674: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: l_trxn_rec.shiptocountry, -- this does NOT exist now
681: l_validzip );
682:
683: if l_validzip = 'N' then
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
686: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
687: FND_MSG_PUB.add;
688: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 701: x_return_status := FND_API.G_RET_STS_ERROR;

697: l_trxn_rec.instr_owner_country,
698: l_validzip );
699:
700: if l_validzip = 'N' then
701: x_return_status := FND_API.G_RET_STS_ERROR;
702: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
703: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
704: FND_MSG_PUB.add;
705: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713: x_msg_count,
714: x_msg_data);
715: /*
716: if l_cust_trx_id = 0 then
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
719: return;
720: else
721: begin

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: l_ship_to_country,
742: l_validzip );
743:
744: if l_validzip = 'N' then
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
747: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
748: FND_MSG_PUB.add;
749: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);