DBA Data[Home] [Help]

APPS.CE_BANK_PUB dependencies on FND_API

Line 168: | FND_API.G_TRUE. Default is fnd_api.g_false

164: | |
165: | ARGUMENTS |
166: | IN: |
167: | p_init_msg_list Initialize message stack if it is set to |
168: | FND_API.G_TRUE. Default is fnd_api.g_false
169: | p_country_code Country code of the bank. |
170: | p_bank_name Bank name. |
171: | p_bank_number Bank number. |
172: | p_alternate_bank_name Alternate bank name. |

Line 181: | be FND_API.G_RET_STS_SUCCESS (success), |

177: | IN/OUT: |
178: | OUT: |
179: | x_bank_id Party ID for the bank. |
180: | x_return_status Return status after the call. The status can |
181: | be FND_API.G_RET_STS_SUCCESS (success), |
182: | fnd_api.g_ret_sts_error (error), |
183: | fnd_api.g_ret_sts_unexp_error (unexpected |
184: | error). |
185: | x_msg_count Number of messages in message stack. |

Line 182: | fnd_api.g_ret_sts_error (error), |

178: | OUT: |
179: | x_bank_id Party ID for the bank. |
180: | x_return_status Return status after the call. The status can |
181: | be FND_API.G_RET_STS_SUCCESS (success), |
182: | fnd_api.g_ret_sts_error (error), |
183: | fnd_api.g_ret_sts_unexp_error (unexpected |
184: | error). |
185: | x_msg_count Number of messages in message stack. |
186: | x_msg_data Message text if x_msg_count is 1. |

Line 183: | fnd_api.g_ret_sts_unexp_error (unexpected |

179: | x_bank_id Party ID for the bank. |
180: | x_return_status Return status after the call. The status can |
181: | be FND_API.G_RET_STS_SUCCESS (success), |
182: | fnd_api.g_ret_sts_error (error), |
183: | fnd_api.g_ret_sts_unexp_error (unexpected |
184: | error). |
185: | x_msg_count Number of messages in message stack. |
186: | x_msg_data Message text if x_msg_count is 1. |
187: | MODIFICATION HISTORY |

Line 191: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

187: | MODIFICATION HISTORY |
188: | 25-AUG-2004 Xin Wang Created. |
189: +=======================================================================*/
190: PROCEDURE create_bank (
191: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
192: p_country_code IN VARCHAR2,
193: p_bank_name IN VARCHAR2,
194: p_bank_number IN VARCHAR2 DEFAULT NULL,
195: p_alternate_bank_name IN VARCHAR2 DEFAULT NULL,

Line 244: | FND_API.G_TRUE. Default is fnd_api.g_false

240: | |
241: | ARGUMENTS |
242: | IN: |
243: | p_init_msg_list Initialize message stack if it is set to |
244: | FND_API.G_TRUE. Default is fnd_api.g_false
245: | p_bank_id Party ID of the bank to be updated. |
246: | p_bank_name Bank name. |
247: | p_bank_number Bank number. |
248: | p_alternate_bank_name Alternate bank name. |

Line 257: | be FND_API.G_RET_STS_SUCCESS (success), |

253: | IN/OUT: |
254: | p_object_version_number Current object version number for the bank|
255: | OUT: |
256: | x_return_status Return status after the call. The status can |
257: | be FND_API.G_RET_STS_SUCCESS (success), |
258: | fnd_api.g_ret_sts_error (error), |
259: | fnd_api.g_ret_sts_unexp_error (unexpected |
260: | error). |
261: | x_msg_count Number of messages in message stack. |

Line 258: | fnd_api.g_ret_sts_error (error), |

254: | p_object_version_number Current object version number for the bank|
255: | OUT: |
256: | x_return_status Return status after the call. The status can |
257: | be FND_API.G_RET_STS_SUCCESS (success), |
258: | fnd_api.g_ret_sts_error (error), |
259: | fnd_api.g_ret_sts_unexp_error (unexpected |
260: | error). |
261: | x_msg_count Number of messages in message stack. |
262: | x_msg_data Message text if x_msg_count is 1. |

Line 259: | fnd_api.g_ret_sts_unexp_error (unexpected |

255: | OUT: |
256: | x_return_status Return status after the call. The status can |
257: | be FND_API.G_RET_STS_SUCCESS (success), |
258: | fnd_api.g_ret_sts_error (error), |
259: | fnd_api.g_ret_sts_unexp_error (unexpected |
260: | error). |
261: | x_msg_count Number of messages in message stack. |
262: | x_msg_data Message text if x_msg_count is 1. |
263: | MODIFICATION HISTORY |

Line 270: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

266: | to enable or disable the country specific |
267: | validation.(Bug #8286747) |
268: +=======================================================================*/
269: PROCEDURE update_bank (
270: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
271: p_bank_id IN NUMBER,
272: p_bank_name IN VARCHAR2,
273: p_bank_number IN VARCHAR2 DEFAULT NULL,
274: p_alternate_bank_name IN VARCHAR2 DEFAULT NULL,

Line 324: | FND_API.G_TRUE. Default is fnd_api.g_false

320: | |
321: | ARGUMENTS |
322: | IN: |
323: | p_init_msg_list Initialize message stack if it is set to |
324: | FND_API.G_TRUE. Default is fnd_api.g_false
325: | p_bank_id Party ID of the bank to be updated. |
326: | p_end_date End date of the bank. |
327: | IN/OUT: |
328: | p_object_version_number Current object version number for the code|

Line 332: | be FND_API.G_RET_STS_SUCCESS (success), |

328: | p_object_version_number Current object version number for the code|
329: | assignment for the bank institution type. |
330: | OUT: |
331: | x_return_status Return status after the call. The status can |
332: | be FND_API.G_RET_STS_SUCCESS (success), |
333: | fnd_api.g_ret_sts_error (error), |
334: | fnd_api.g_ret_sts_unexp_error (unexpected |
335: | error). |
336: | x_msg_count Number of messages in message stack. |

Line 333: | fnd_api.g_ret_sts_error (error), |

329: | assignment for the bank institution type. |
330: | OUT: |
331: | x_return_status Return status after the call. The status can |
332: | be FND_API.G_RET_STS_SUCCESS (success), |
333: | fnd_api.g_ret_sts_error (error), |
334: | fnd_api.g_ret_sts_unexp_error (unexpected |
335: | error). |
336: | x_msg_count Number of messages in message stack. |
337: | x_msg_data Message text if x_msg_count is 1. |

Line 334: | fnd_api.g_ret_sts_unexp_error (unexpected |

330: | OUT: |
331: | x_return_status Return status after the call. The status can |
332: | be FND_API.G_RET_STS_SUCCESS (success), |
333: | fnd_api.g_ret_sts_error (error), |
334: | fnd_api.g_ret_sts_unexp_error (unexpected |
335: | error). |
336: | x_msg_count Number of messages in message stack. |
337: | x_msg_data Message text if x_msg_count is 1. |
338: | MODIFICATION HISTORY |

Line 342: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

338: | MODIFICATION HISTORY |
339: | 25-AUG-2004 Xin Wang Created. |
340: +=======================================================================*/
341: PROCEDURE set_bank_end_date (
342: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
343: p_bank_id IN NUMBER,
344: p_end_date IN DATE,
345: p_object_version_number IN OUT NOCOPY NUMBER,
346: x_return_status OUT NOCOPY VARCHAR2,

Line 396: | FND_API.G_TRUE. Default is fnd_api.g_false

392: | |
393: | ARGUMENTS |
394: | IN: |
395: | p_init_msg_list Initialize message stack if it is set to |
396: | FND_API.G_TRUE. Default is fnd_api.g_false
397: | p_bank_party_id Party ID of the bank that the branch |
398: | belongs. |
399: | p_branch_name Bank branch name. |
400: | p_branch_number Bank branch number. |

Line 411: | be FND_API.G_RET_STS_SUCCESS (success), |

407: | IN/OUT: |
408: | OUT: |
409: | x_branch_id Party ID for the bank branch. |
410: | x_return_status Return status after the call. The status can |
411: | be FND_API.G_RET_STS_SUCCESS (success), |
412: | fnd_api.g_ret_sts_error (error), |
413: | fnd_api.g_ret_sts_unexp_error (unexpected |
414: | error). |
415: | x_msg_count Number of messages in message stack. |

Line 412: | fnd_api.g_ret_sts_error (error), |

408: | OUT: |
409: | x_branch_id Party ID for the bank branch. |
410: | x_return_status Return status after the call. The status can |
411: | be FND_API.G_RET_STS_SUCCESS (success), |
412: | fnd_api.g_ret_sts_error (error), |
413: | fnd_api.g_ret_sts_unexp_error (unexpected |
414: | error). |
415: | x_msg_count Number of messages in message stack. |
416: | x_msg_data Message text if x_msg_count is 1. |

Line 413: | fnd_api.g_ret_sts_unexp_error (unexpected |

409: | x_branch_id Party ID for the bank branch. |
410: | x_return_status Return status after the call. The status can |
411: | be FND_API.G_RET_STS_SUCCESS (success), |
412: | fnd_api.g_ret_sts_error (error), |
413: | fnd_api.g_ret_sts_unexp_error (unexpected |
414: | error). |
415: | x_msg_count Number of messages in message stack. |
416: | x_msg_data Message text if x_msg_count is 1. |
417: | MODIFICATION HISTORY |

Line 421: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

417: | MODIFICATION HISTORY |
418: | 25-AUG-2004 Xin Wang Created. |
419: +=======================================================================*/
420: PROCEDURE create_bank_branch (
421: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
422: p_bank_id IN NUMBER,
423: p_branch_name IN VARCHAR2,
424: p_branch_number IN VARCHAR2 DEFAULT NULL,
425: p_branch_type IN VARCHAR2 DEFAULT NULL,

Line 475: | FND_API.G_TRUE. Default is fnd_api.g_false

471: | |
472: | ARGUMENTS |
473: | IN: |
474: | p_init_msg_list Initialize message stack if it is set to |
475: | FND_API.G_TRUE. Default is fnd_api.g_false
476: | p_branch_id Party ID of the branch to be updated. |
477: | p_branch_name Bank branch name. |
478: | p_branch_number Bank branch number. |
479: | p_branch_type Bank branch type. |

Line 496: | be FND_API.G_RET_STS_SUCCESS (success), |

492: | p_eft_object_version_number Current object version number for |
493: | BIC(EFT) contact point. |
494: | OUT: |
495: | x_return_status Return status after the call. The status can |
496: | be FND_API.G_RET_STS_SUCCESS (success), |
497: | fnd_api.g_ret_sts_error (error), |
498: | fnd_api.g_ret_sts_unexp_error (unexpected |
499: | error). |
500: | x_msg_count Number of messages in message stack. |

Line 497: | fnd_api.g_ret_sts_error (error), |

493: | BIC(EFT) contact point. |
494: | OUT: |
495: | x_return_status Return status after the call. The status can |
496: | be FND_API.G_RET_STS_SUCCESS (success), |
497: | fnd_api.g_ret_sts_error (error), |
498: | fnd_api.g_ret_sts_unexp_error (unexpected |
499: | error). |
500: | x_msg_count Number of messages in message stack. |
501: | x_msg_data Message text if x_msg_count is 1. |

Line 498: | fnd_api.g_ret_sts_unexp_error (unexpected |

494: | OUT: |
495: | x_return_status Return status after the call. The status can |
496: | be FND_API.G_RET_STS_SUCCESS (success), |
497: | fnd_api.g_ret_sts_error (error), |
498: | fnd_api.g_ret_sts_unexp_error (unexpected |
499: | error). |
500: | x_msg_count Number of messages in message stack. |
501: | x_msg_data Message text if x_msg_count is 1. |
502: | MODIFICATION HISTORY |

Line 509: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

505: | to enable or disable the country specific |
506: | validation.(Bug #8286747) |
507: +=======================================================================*/
508: PROCEDURE update_bank_branch (
509: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
510: p_branch_id IN NUMBER,
511: p_branch_name IN VARCHAR2,
512: p_branch_number IN VARCHAR2 DEFAULT NULL,
513: p_branch_type IN VARCHAR2 DEFAULT NULL,

Line 567: | FND_API.G_TRUE. Default is fnd_api.g_false

563: | |
564: | ARGUMENTS |
565: | IN: |
566: | p_init_msg_list Initialize message stack if it is set to |
567: | FND_API.G_TRUE. Default is fnd_api.g_false
568: | p_branch_id Party ID of the branch to be inactivated.|
569: | p_end_date Inactive date of the bank branch. |
570: | IN/OUT: |
571: | p_object_version_number Current object version number for the |

Line 576: | be FND_API.G_RET_STS_SUCCESS (success), |

572: | code assignment of the bank institution|
573: | type for the bank branch. |
574: | OUT: |
575: | x_return_status Return status after the call. The status can |
576: | be FND_API.G_RET_STS_SUCCESS (success), |
577: | fnd_api.g_ret_sts_error (error), |
578: | fnd_api.g_ret_sts_unexp_error (unexpected |
579: | error). |
580: | x_msg_count Number of messages in message stack. |

Line 577: | fnd_api.g_ret_sts_error (error), |

573: | type for the bank branch. |
574: | OUT: |
575: | x_return_status Return status after the call. The status can |
576: | be FND_API.G_RET_STS_SUCCESS (success), |
577: | fnd_api.g_ret_sts_error (error), |
578: | fnd_api.g_ret_sts_unexp_error (unexpected |
579: | error). |
580: | x_msg_count Number of messages in message stack. |
581: | x_msg_data Message text if x_msg_count is 1. |

Line 578: | fnd_api.g_ret_sts_unexp_error (unexpected |

574: | OUT: |
575: | x_return_status Return status after the call. The status can |
576: | be FND_API.G_RET_STS_SUCCESS (success), |
577: | fnd_api.g_ret_sts_error (error), |
578: | fnd_api.g_ret_sts_unexp_error (unexpected |
579: | error). |
580: | x_msg_count Number of messages in message stack. |
581: | x_msg_data Message text if x_msg_count is 1. |
582: | MODIFICATION HISTORY |

Line 586: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

582: | MODIFICATION HISTORY |
583: | 25-AUG-2004 Xin Wang Created. |
584: +=======================================================================*/
585: PROCEDURE set_bank_branch_end_date (
586: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
587: p_branch_id IN NUMBER,
588: p_end_date IN DATE,
589: p_object_version_number IN OUT NOCOPY NUMBER,
590: x_return_status OUT NOCOPY VARCHAR2,

Line 637: | FND_API.G_TRUE. Default is fnd_api.g_false |

633: | |
634: | ARGUMENTS |
635: | IN: |
636: | p_init_msg_list Initialize message stack if it is set to |
637: | FND_API.G_TRUE. Default is fnd_api.g_false |
638: | p_acct_rec Bank account record. |
639: | IN/OUT: |
640: | OUT: |
641: | x_acct_id Bank account ID. |

Line 643: | be FND_API.G_RET_STS_SUCCESS (success), |

639: | IN/OUT: |
640: | OUT: |
641: | x_acct_id Bank account ID. |
642: | x_return_status Return status after the call. The status can |
643: | be FND_API.G_RET_STS_SUCCESS (success), |
644: | fnd_api.g_ret_sts_error (error), |
645: | fnd_api.g_ret_sts_unexp_error (unexpected |
646: | error). |
647: | x_msg_count Number of messages in message stack. |

Line 644: | fnd_api.g_ret_sts_error (error), |

640: | OUT: |
641: | x_acct_id Bank account ID. |
642: | x_return_status Return status after the call. The status can |
643: | be FND_API.G_RET_STS_SUCCESS (success), |
644: | fnd_api.g_ret_sts_error (error), |
645: | fnd_api.g_ret_sts_unexp_error (unexpected |
646: | error). |
647: | x_msg_count Number of messages in message stack. |
648: | x_msg_data Message text if x_msg_count is 1. |

Line 645: | fnd_api.g_ret_sts_unexp_error (unexpected |

641: | x_acct_id Bank account ID. |
642: | x_return_status Return status after the call. The status can |
643: | be FND_API.G_RET_STS_SUCCESS (success), |
644: | fnd_api.g_ret_sts_error (error), |
645: | fnd_api.g_ret_sts_unexp_error (unexpected |
646: | error). |
647: | x_msg_count Number of messages in message stack. |
648: | x_msg_data Message text if x_msg_count is 1. |
649: | MODIFICATION HISTORY |

Line 653: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

649: | MODIFICATION HISTORY |
650: | 25-AUG-2004 Xin Wang Created. |
651: +=======================================================================*/
652: PROCEDURE create_bank_acct (
653: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
654: p_acct_rec IN BankAcct_rec_type,
655: x_acct_id OUT NOCOPY NUMBER,
656: x_return_status OUT NOCOPY VARCHAR2,
657: x_msg_count OUT NOCOPY NUMBER,

Line 673: | FND_API.G_TRUE. Default is fnd_api.g_false

669: | |
670: | ARGUMENTS |
671: | IN: |
672: | p_init_msg_list Initialize message stack if it is set to |
673: | FND_API.G_TRUE. Default is fnd_api.g_false
674: | p_acct_rec External bank account record. |
675: | IN/OUT: |
676: | p_object_version_number Current object version number for the |
677: | bank account. |

Line 680: | be FND_API.G_RET_STS_SUCCESS (success), |

676: | p_object_version_number Current object version number for the |
677: | bank account. |
678: | OUT: |
679: | x_return_status Return status after the call. The status can |
680: | be FND_API.G_RET_STS_SUCCESS (success), |
681: | fnd_api.g_ret_sts_error (error), |
682: | fnd_api.g_ret_sts_unexp_error (unexpected |
683: | error). |
684: | x_msg_count Number of messages in message stack. |

Line 681: | fnd_api.g_ret_sts_error (error), |

677: | bank account. |
678: | OUT: |
679: | x_return_status Return status after the call. The status can |
680: | be FND_API.G_RET_STS_SUCCESS (success), |
681: | fnd_api.g_ret_sts_error (error), |
682: | fnd_api.g_ret_sts_unexp_error (unexpected |
683: | error). |
684: | x_msg_count Number of messages in message stack. |
685: | x_msg_data Message text if x_msg_count is 1. |

Line 682: | fnd_api.g_ret_sts_unexp_error (unexpected |

678: | OUT: |
679: | x_return_status Return status after the call. The status can |
680: | be FND_API.G_RET_STS_SUCCESS (success), |
681: | fnd_api.g_ret_sts_error (error), |
682: | fnd_api.g_ret_sts_unexp_error (unexpected |
683: | error). |
684: | x_msg_count Number of messages in message stack. |
685: | x_msg_data Message text if x_msg_count is 1. |
686: | MODIFICATION HISTORY |

Line 690: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

686: | MODIFICATION HISTORY |
687: | 25-AUG-2004 Xin Wang Created. |
688: +=======================================================================*/
689: PROCEDURE update_bank_acct (
690: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
691: p_acct_rec IN BankAcct_rec_type,
692: p_object_version_number IN OUT NOCOPY NUMBER,
693: x_return_status OUT NOCOPY VARCHAR2,
694: x_msg_count OUT NOCOPY NUMBER,

Line 700: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

696: );
697:
698:
699: PROCEDURE create_bank_acct_use (
700: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
701: p_acct_use_rec IN BankAcct_use_rec_type,
702: x_acct_use_id OUT NOCOPY NUMBER,
703: x_return_status OUT NOCOPY VARCHAR2,
704: x_msg_count OUT NOCOPY NUMBER,

Line 710: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

706: );
707:
708:
709: PROCEDURE update_bank_acct_use (
710: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
711: p_acct_use_rec IN BankAcct_use_rec_type,
712: p_use_ovn IN OUT NOCOPY NUMBER,
713: p_ccid_ovn IN OUT NOCOPY NUMBER,
714: x_return_status OUT NOCOPY VARCHAR2,

Line 731: | FND_API.G_TRUE. Default is fnd_api.g_false|

727: | |
728: | ARGUMENTS |
729: | IN: |
730: | p_init_msg_list Initialize message stack if it is set to |
731: | FND_API.G_TRUE. Default is fnd_api.g_false|
732: | p_bank_acct_id ID of the Internal Bank account to be |
733: | inactivated. |
734: | p_end_date Inactive date of the bank account |
735: | |

Line 742: | be FND_API.G_RET_STS_SUCCESS (success), |

738: | p_object_version_number Current object version number for the |
739: | bank account. |
740: | OUT: |
741: | x_return_status Return status after the call. The status can |
742: | be FND_API.G_RET_STS_SUCCESS (success), |
743: | fnd_api.g_ret_sts_error (error), |
744: | fnd_api.g_ret_sts_unexp_error (unexpected |
745: | error). |
746: | x_msg_count Number of messages in message stack. |

Line 743: | fnd_api.g_ret_sts_error (error), |

739: | bank account. |
740: | OUT: |
741: | x_return_status Return status after the call. The status can |
742: | be FND_API.G_RET_STS_SUCCESS (success), |
743: | fnd_api.g_ret_sts_error (error), |
744: | fnd_api.g_ret_sts_unexp_error (unexpected |
745: | error). |
746: | x_msg_count Number of messages in message stack. |
747: | x_msg_data Message text if x_msg_count is 1. |

Line 744: | fnd_api.g_ret_sts_unexp_error (unexpected |

740: | OUT: |
741: | x_return_status Return status after the call. The status can |
742: | be FND_API.G_RET_STS_SUCCESS (success), |
743: | fnd_api.g_ret_sts_error (error), |
744: | fnd_api.g_ret_sts_unexp_error (unexpected |
745: | error). |
746: | x_msg_count Number of messages in message stack. |
747: | x_msg_data Message text if x_msg_count is 1. |
748: | MODIFICATION HISTORY |

Line 752: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

748: | MODIFICATION HISTORY |
749: | 18-MAY-2011 vnetan Created. |
750: +=======================================================================*/
751: PROCEDURE set_bank_acct_end_date (
752: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
753: p_bank_acct_id IN NUMBER,
754: p_end_date IN DATE,
755: p_object_version_number IN OUT NOCOPY NUMBER,
756: x_return_status OUT NOCOPY VARCHAR2,