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 92: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

88:
89: -- Validate Citibank credit card batch
90: PROCEDURE Validate_Citibank_Batch (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
93: P_MBATCH_ID IN NUMBER,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2

Line 132: if NOT FND_API.Compatible_API_Call( l_api_version,

128: BEGIN
129: -- SAVEPOINT Validate_Paymentech_Batch;
130:
131: -- Standard call to check for call compatibility
132: if NOT FND_API.Compatible_API_Call( l_api_version,
133: p_api_version,
134: l_api_name,
135: G_PKG_NAME ) then
136: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 136: raise FND_API.G_EXC_UNEXPECTED_ERROR;

132: if NOT FND_API.Compatible_API_Call( l_api_version,
133: p_api_version,
134: l_api_name,
135: G_PKG_NAME ) then
136: raise FND_API.G_EXC_UNEXPECTED_ERROR;
137: end if;
138:
139: if FND_API.To_Boolean(p_init_msg_list) then
140: FND_MSG_PUB.initialize;

Line 139: if FND_API.To_Boolean(p_init_msg_list) then

135: G_PKG_NAME ) then
136: raise FND_API.G_EXC_UNEXPECTED_ERROR;
137: end if;
138:
139: if FND_API.To_Boolean(p_init_msg_list) then
140: FND_MSG_PUB.initialize;
141: end if;
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: if FND_API.To_Boolean(p_init_msg_list) then
140: FND_MSG_PUB.initialize;
141: end if;
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: if PG_DEBUG in ('Y', 'C') then
146: null; -- iby.debug('some info');
147: end if;

Line 156: x_return_status := FND_API.G_RET_STS_ERROR;

152: from iby_batches_all
153: where mbatchid = P_MBATCH_ID;
154:
155: if l_batchid_size > 8 then
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
158: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
159: FND_MSG_PUB.add;
160: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 177: x_return_status := FND_API.G_RET_STS_ERROR;

173: l_trxn_rec.instr_owner_country,
174: l_validzip );
175:
176: if l_validzip = 'N' then
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
179: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
180: FND_MSG_PUB.add;
181: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190: l_trxn_rec.instr_owner_country,
191: l_validzip );
192:
193: if l_validzip = 'N' then
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
196: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
197: FND_MSG_PUB.add;
198: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: l_trxn_rec.shipfromcountry, -- this does NOT exist now
208: l_validzip );
209:
210: if l_validzip = 'N' then
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
213: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
214: FND_MSG_PUB.add;
215: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: l_trxn_rec.shiptocountry, -- this does NOT exist now
222: l_validzip );
223:
224: if l_validzip = 'N' then
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
227: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
228: FND_MSG_PUB.add;
229: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 249: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

245:
246: -- Validate FDCNorth credit card batch
247: PROCEDURE Validate_FDCNorth_Batch (
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
250: P_MBATCH_ID IN NUMBER,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2

Line 295: if NOT FND_API.Compatible_API_Call( l_api_version,

291: BEGIN
292: -- SAVEPOINT Validate_Paymentech_Batch;
293:
294: -- Standard call to check for call compatibility
295: if NOT FND_API.Compatible_API_Call( l_api_version,
296: p_api_version,
297: l_api_name,
298: G_PKG_NAME ) then
299: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 299: raise FND_API.G_EXC_UNEXPECTED_ERROR;

295: if NOT FND_API.Compatible_API_Call( l_api_version,
296: p_api_version,
297: l_api_name,
298: G_PKG_NAME ) then
299: raise FND_API.G_EXC_UNEXPECTED_ERROR;
300: end if;
301:
302: if FND_API.To_Boolean(p_init_msg_list) then
303: FND_MSG_PUB.initialize;

Line 302: if FND_API.To_Boolean(p_init_msg_list) then

298: G_PKG_NAME ) then
299: raise FND_API.G_EXC_UNEXPECTED_ERROR;
300: end if;
301:
302: if FND_API.To_Boolean(p_init_msg_list) then
303: FND_MSG_PUB.initialize;
304: end if;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: if FND_API.To_Boolean(p_init_msg_list) then
303: FND_MSG_PUB.initialize;
304: end if;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: if PG_DEBUG in ('Y', 'C') then
309: null; -- iby.debug('some info');
310: end if;

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: AND
409: TRUNC(batchclosedate) = l_batch_close_date;
410:
411: if l_batch_count > 9 then
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
414: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch count per merchant security code');
415: FND_MSG_PUB.add;
416: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437: * types.
438: */
439: if l_trxn_rec.reqtype not in ('ORAPMTCAPTURE', 'ORAPMTCREDIT',
440: 'ORAPMTRETURN') then
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
443: FND_MESSAGE.set_token('ERR_OBJECT', 'Transaction type');
444: FND_MSG_PUB.add;
445: 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 474: x_return_status := FND_API.G_RET_STS_ERROR;

470: l_trxn_rec.instr_owner_country,
471: l_validzip );
472:
473: if l_validzip = 'N' then
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
476: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
477: FND_MSG_PUB.add;
478: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: l_trxn_rec.shipfromcountry, -- this does NOT exist now
486: l_validzip );
487:
488: if l_validzip = 'N' then
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
491: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
492: FND_MSG_PUB.add;
493: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 503: x_return_status := FND_API.G_RET_STS_ERROR;

499: l_trxn_rec.shiptocountry, -- this does NOT exist now
500: l_validzip );
501:
502: if l_validzip = 'N' then
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
505: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
506: FND_MSG_PUB.add;
507: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 520: x_return_status := FND_API.G_RET_STS_ERROR;

516: l_trxn_rec.instr_owner_country,
517: l_validzip );
518:
519: if l_validzip = 'N' then
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
522: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
523: FND_MSG_PUB.add;
524: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: x_msg_count,
533: x_msg_data);
534: /*
535: if l_cust_trx_id = 0 then
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
538: return;
539: else
540: begin

Line 548: x_return_status := FND_API.G_RET_STS_ERROR;

544: from ar_invoice_lines_v
545: where customer_trx_id = l_cust_trx_id;
546:
547: if l_doc_line_count > 98 then
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
550: FND_MESSAGE.set_token('ERR_OBJECT', 'Invoice line count for Visa purchase card');
551: FND_MSG_PUB.add;
552: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575: l_ship_to_country,
576: l_validzip );
577:
578: if l_validzip = 'N' then
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
581: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
582: FND_MSG_PUB.add;
583: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 604: if x_return_status = FND_API.G_RET_STS_SUCCESS then

600: end loop;
601: close level2_trxn;
602:
603: -- Bug 4243738: Added
604: if x_return_status = FND_API.G_RET_STS_SUCCESS then
605: update iby_batches_all
606: set SENTCOUNTERDAILY = l_batch_count
607: where mbatchid = P_MBATCH_ID;
608: end if;

Line 617: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

613:
614: -- Validate Paymentech credit card batch
615: PROCEDURE Validate_Paymentech_Batch (
616: p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
618: P_MBATCH_ID IN NUMBER,
619: x_return_status OUT NOCOPY VARCHAR2,
620: x_msg_count OUT NOCOPY NUMBER,
621: x_msg_data OUT NOCOPY VARCHAR2

Line 658: if NOT FND_API.Compatible_API_Call( l_api_version,

654: BEGIN
655: -- SAVEPOINT Validate_Paymentech_Batch;
656:
657: -- Standard call to check for call compatibility
658: if NOT FND_API.Compatible_API_Call( l_api_version,
659: p_api_version,
660: l_api_name,
661: G_PKG_NAME ) then
662: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 662: raise FND_API.G_EXC_UNEXPECTED_ERROR;

658: if NOT FND_API.Compatible_API_Call( l_api_version,
659: p_api_version,
660: l_api_name,
661: G_PKG_NAME ) then
662: raise FND_API.G_EXC_UNEXPECTED_ERROR;
663: end if;
664:
665: if FND_API.To_Boolean(p_init_msg_list) then
666: FND_MSG_PUB.initialize;

Line 665: if FND_API.To_Boolean(p_init_msg_list) then

661: G_PKG_NAME ) then
662: raise FND_API.G_EXC_UNEXPECTED_ERROR;
663: end if;
664:
665: if FND_API.To_Boolean(p_init_msg_list) then
666: FND_MSG_PUB.initialize;
667: end if;
668:
669: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 669: x_return_status := FND_API.G_RET_STS_SUCCESS;

665: if FND_API.To_Boolean(p_init_msg_list) then
666: FND_MSG_PUB.initialize;
667: end if;
668:
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: if PG_DEBUG in ('Y', 'C') then
672: null; -- iby.debug('some info');
673: end if;

Line 682: x_return_status := FND_API.G_RET_STS_ERROR;

678: from iby_batches_all
679: where mbatchid = P_MBATCH_ID;
680:
681: if l_batchid_size > 8 then
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
684: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
685: FND_MSG_PUB.add;
686: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 702: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 720: x_return_status := FND_API.G_RET_STS_ERROR;

716: l_trxn_rec.instr_owner_country,
717: l_validzip );
718:
719: if l_validzip = 'N' then
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
722: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
723: FND_MSG_PUB.add;
724: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 735: x_return_status := FND_API.G_RET_STS_ERROR;

731: l_trxn_rec.shipfromcountry, -- this does NOT exist now
732: l_validzip );
733:
734: if l_validzip = 'N' then
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
737: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
738: FND_MSG_PUB.add;
739: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 749: x_return_status := FND_API.G_RET_STS_ERROR;

745: l_trxn_rec.shiptocountry, -- this does NOT exist now
746: l_validzip );
747:
748: if l_validzip = 'N' then
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
751: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
752: FND_MSG_PUB.add;
753: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 766: x_return_status := FND_API.G_RET_STS_ERROR;

762: l_trxn_rec.instr_owner_country,
763: l_validzip );
764:
765: if l_validzip = 'N' then
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
768: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
769: FND_MSG_PUB.add;
770: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: x_msg_count,
779: x_msg_data);
780: /*
781: if l_cust_trx_id = 0 then
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
784: return;
785: else
786: begin

Line 810: x_return_status := FND_API.G_RET_STS_ERROR;

806: l_ship_to_country,
807: l_validzip );
808:
809: if l_validzip = 'N' then
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
812: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
813: FND_MSG_PUB.add;
814: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 883: x_return_status := FND_API.G_RET_STS_SUCCESS;

879: l_swift_code ce_bank_branches_v.eft_swift_code%TYPE;
880:
881: BEGIN
882:
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
884:
885: print_debuginfo(l_dbg_mod, 'Enter:');
886:
887: print_debuginfo(l_dbg_mod, 'p_assignment_id: ' || p_assignment_id);

Line 1007: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1003:
1004: -- Validate SEPA DD batch
1005: PROCEDURE Validate_Sepa_DD_Batch (
1006: p_api_version IN NUMBER,
1007: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1008: P_MBATCH_ID IN NUMBER,
1009: x_return_status OUT NOCOPY VARCHAR2,
1010: x_msg_count OUT NOCOPY NUMBER,
1011: x_msg_data OUT NOCOPY VARCHAR2

Line 1095: if NOT FND_API.Compatible_API_Call( l_api_version,

1091: print_debuginfo(G_DEBUG_MODULE, 'Entered ... ');
1092: END IF;
1093:
1094: -- Standard call to check for call compatibility
1095: if NOT FND_API.Compatible_API_Call( l_api_version,
1096: p_api_version,
1097: l_api_name,
1098: G_PKG_NAME ) then
1099: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1099: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1095: if NOT FND_API.Compatible_API_Call( l_api_version,
1096: p_api_version,
1097: l_api_name,
1098: G_PKG_NAME ) then
1099: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1100: end if;
1101:
1102: if FND_API.To_Boolean(p_init_msg_list) then
1103: FND_MSG_PUB.initialize;

Line 1102: if FND_API.To_Boolean(p_init_msg_list) then

1098: G_PKG_NAME ) then
1099: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1100: end if;
1101:
1102: if FND_API.To_Boolean(p_init_msg_list) then
1103: FND_MSG_PUB.initialize;
1104: end if;
1105:
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1106: x_return_status := FND_API.G_RET_STS_SUCCESS;

1102: if FND_API.To_Boolean(p_init_msg_list) then
1103: FND_MSG_PUB.initialize;
1104: end if;
1105:
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107:
1108:
1109: open c_settle_trxns;
1110: loop

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120: print_debuginfo(G_DEBUG_MODULE, 'After mandate cursor ');
1121: END IF;
1122:
1123: IF (c_mandate%NOTFOUND) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MESSAGE.set_name('IBY','Active Debit Authorization is required');
1126: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1127: FND_MSG_PUB.add;
1128: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1150: x_return_status := FND_API.G_RET_STS_ERROR;

1146: AND uses.instrument_type = 'BANKACCOUNT'
1147: AND eb.branch_id = bbv.branch_party_id
1148: AND uses.instrument_payment_use_id = l_external_bank_account_use_id;
1149: EXCEPTION WHEN OTHERS THEN
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: FND_MESSAGE.set_name('IBY','iban and BIC name is required on Debit Authorization');
1152: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1153: FND_MSG_PUB.add;
1154: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1174: x_return_status := FND_API.G_RET_STS_ERROR;

1170: INTO l_payee_address, l_le_name
1171: FROM xle_firstparty_information_v
1172: WHERE legal_entity_id = l_creditor_legal_entity_id ;
1173: EXCEPTION WHEN OTHERS THEN
1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: FND_MESSAGE.set_name('IBY','LE name and payee address required on Debit Authorization');
1176: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1177: FND_MSG_PUB.add;
1178: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1188: x_return_status := FND_API.G_RET_STS_ERROR;

1184:
1185: /* checking the mandate attributes */
1186: IF(l_auth_reference_number IS NULL )
1187: THEN
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: FND_MESSAGE.set_name('IBY','Unique Authorization Reference ID is required on Enter Debit Authorization');
1190: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1191: FND_MSG_PUB.add;
1192: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1198: x_return_status := FND_API.G_RET_STS_ERROR;

1194: print_debuginfo(G_DEBUG_MODULE, 'Checking auth ref id ');
1195: END IF;
1196: ELSIF (l_auth_sign_date IS NULL )
1197: THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MESSAGE.set_name('IBY','Authorization Signing Date is required on Enter Debit Authorization');
1200: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1201: FND_MSG_PUB.add;
1202: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1208: x_return_status := FND_API.G_RET_STS_ERROR;

1204: print_debuginfo(G_DEBUG_MODULE, 'Authsign date');
1205: END IF;
1206: ELSIF (l_creditor_legal_entity_id IS NULL )
1207: THEN
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: FND_MESSAGE.set_name('IBY','Payee Legal Entity is required on Enter Debit Authorization');
1210: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1211: FND_MSG_PUB.add;
1212: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1218: x_return_status := FND_API.G_RET_STS_ERROR;

1214: print_debuginfo(G_DEBUG_MODULE, 'Payee legal entity ');
1215: END IF;
1216: ELSIF (l_payee_address IS NULL )
1217: THEN
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MESSAGE.set_name('IBY','Payee Address is required on Enter Debit Authorization');
1220: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1221: FND_MSG_PUB.add;
1222: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR;

1224: print_debuginfo(G_DEBUG_MODULE, 'Payee Address ');
1225: END IF;
1226: ELSIF (l_creditor_identifier IS NULL )
1227: THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: FND_MESSAGE.set_name('IBY','Payee Identifier is required on Enter Debit Authorization');
1230: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1231: FND_MSG_PUB.add;
1232: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1238: x_return_status := FND_API.G_RET_STS_ERROR;

1234: print_debuginfo(G_DEBUG_MODULE, 'Payee identifier');
1235: END IF;
1236: ELSIF (l_cust_addr_id IS NULL )
1237: THEN
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: FND_MESSAGE.set_name('IBY','Customer Address is required on Enter Debit Authorizationd');
1240: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1241: FND_MSG_PUB.add;
1242: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244: print_debuginfo(G_DEBUG_MODULE, 'Customer address');
1245: END IF;
1246: ELSIF (l_creditor_le_name <> l_le_name)
1247: THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: FND_MESSAGE.set_name('IBY','Payee LegalEntity Name is Invalid');
1250: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1251: FND_MSG_PUB.add;
1252: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1258: x_return_status := FND_API.G_RET_STS_ERROR;

1254: print_debuginfo(G_DEBUG_MODULE, 'Payee LE Name');
1255: END IF;
1256: ELSIF (l_iban IS NULL )
1257: THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: FND_MESSAGE.set_name('IBY','IBAN is required on Enter Debit Authorizationd');
1260: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1261: FND_MSG_PUB.add;
1262: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1268: x_return_status := FND_API.G_RET_STS_ERROR;

1264: print_debuginfo(G_DEBUG_MODULE, 'IBAN');
1265: END IF;
1266: ELSIF (l_swift_code IS NULL )
1267: THEN
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: FND_MESSAGE.set_name('IBY','BIC is required on Enter Debit Authorizationd');
1270: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1271: FND_MSG_PUB.add;
1272: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1313: x_return_status := FND_API.G_RET_STS_ERROR;

1309: CLOSE c_acct_option_vals;
1310:
1311: IF (l_ini_party_id IS NULL)
1312: THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: FND_MESSAGE.set_name('IBY','Initiating Party ID is required');
1315: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1316: FND_MSG_PUB.add;
1317: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1323: x_return_status := FND_API.G_RET_STS_ERROR;

1319: print_debuginfo(G_DEBUG_MODULE, 'Initaiting party id');
1320: END IF;
1321: ELSIF (l_ini_party_id_issuer IS NULL)
1322: THEN
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: FND_MESSAGE.set_name('IBY','Initiating Party ID Issuer is required');
1325: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1326: FND_MSG_PUB.add;
1327: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1333: x_return_status := FND_API.G_RET_STS_ERROR;

1329: print_debuginfo(G_DEBUG_MODULE, 'Init Party Id issr ');
1330: END IF;
1331: ELSIF (l_ini_party_name IS NULL)
1332: THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MESSAGE.set_name('IBY','Initiating Party Name is required');
1335: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1336: FND_MSG_PUB.add;
1337: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1343: x_return_status := FND_API.G_RET_STS_ERROR;

1339: print_debuginfo(G_DEBUG_MODULE, 'Ini Party Name');
1340: END IF;
1341: ELSIF (l_batch_booking_flag IS NULL)
1342: THEN
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344: FND_MESSAGE.set_name('IBY','Batch Booking is required');
1345: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1346: FND_MSG_PUB.add;
1347: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1353: x_return_status := FND_API.G_RET_STS_ERROR;

1349: print_debuginfo(G_DEBUG_MODULE, 'batch booking');
1350: END IF;
1351: ELSIF ((l_batch_booking_flag <> 'TRUE') AND (l_batch_booking_flag <> 'FALSE' ))
1352: THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: FND_MESSAGE.set_name('IBY','Batch Booking is Invalid');
1355: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1356: FND_MSG_PUB.add;
1357: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

Line 1399: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1395:
1396: --Active Mandate for NON SEPA Customers.
1397: PROCEDURE NonSEPA_Active_Mandate(
1398: p_api_version IN NUMBER,
1399: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1400: P_MBATCH_ID IN NUMBER,
1401: x_return_status OUT NOCOPY VARCHAR2,
1402: x_msg_count OUT NOCOPY NUMBER,
1403: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME ) THEN

1431: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1432: print_debuginfo(G_DEBUG_MODULE, 'Entered ... ');
1433: END IF;
1434: -- Standard call to check for call compatibility
1435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME ) THEN
1436: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438: IF FND_API.To_Boolean(p_init_msg_list) THEN
1439: FND_MSG_PUB.initialize;

Line 1436: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1432: print_debuginfo(G_DEBUG_MODULE, 'Entered ... ');
1433: END IF;
1434: -- Standard call to check for call compatibility
1435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME ) THEN
1436: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438: IF FND_API.To_Boolean(p_init_msg_list) THEN
1439: FND_MSG_PUB.initialize;
1440: END IF;

Line 1438: IF FND_API.To_Boolean(p_init_msg_list) THEN

1434: -- Standard call to check for call compatibility
1435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME ) THEN
1436: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438: IF FND_API.To_Boolean(p_init_msg_list) THEN
1439: FND_MSG_PUB.initialize;
1440: END IF;
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: OPEN c_settle_trxns;

Line 1441: x_return_status := FND_API.G_RET_STS_SUCCESS;

1437: END IF;
1438: IF FND_API.To_Boolean(p_init_msg_list) THEN
1439: FND_MSG_PUB.initialize;
1440: END IF;
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: OPEN c_settle_trxns;
1443: LOOP
1444: FETCH c_settle_trxns INTO l_trxnmid;
1445: EXIT

Line 1456: x_return_status := FND_API.G_RET_STS_ERROR;

1452: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1453: print_debuginfo(G_DEBUG_MODULE, 'Active mandate Reference:' || l_auth_reference_number);
1454: END IF;
1455: IF (c_mandate%NOTFOUND) THEN
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: FND_MESSAGE.set_name('IBY','No active mandate');
1458: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch:'||P_MBATCH_ID ||' Trxnmid : ' || l_trxnmid);
1459: FND_MSG_PUB.add;
1460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);