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 267: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,

263: | MODIFICATION HISTORY |
264: | 25-AUG-2004 Xin Wang Created. |
265: +=======================================================================*/
266: PROCEDURE update_bank (
267: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
268: p_bank_id IN NUMBER,
269: p_bank_name IN VARCHAR2,
270: p_bank_number IN VARCHAR2 DEFAULT NULL,
271: p_alternate_bank_name IN VARCHAR2 DEFAULT NULL,

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

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

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

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

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

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

Line 330: | fnd_api.g_ret_sts_unexp_error (unexpected |

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

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

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

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

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

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

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

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

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

Line 409: | fnd_api.g_ret_sts_unexp_error (unexpected |

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

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

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

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

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

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

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

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

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

Line 494: | fnd_api.g_ret_sts_unexp_error (unexpected |

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

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

498: | MODIFICATION HISTORY |
499: | 25-AUG-2004 Xin Wang Created. |
500: +=======================================================================*/
501: PROCEDURE update_bank_branch (
502: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
503: p_branch_id IN NUMBER,
504: p_branch_name IN VARCHAR2,
505: p_branch_number IN VARCHAR2 DEFAULT NULL,
506: p_branch_type IN VARCHAR2 DEFAULT NULL,

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

555: | |
556: | ARGUMENTS |
557: | IN: |
558: | p_init_msg_list Initialize message stack if it is set to |
559: | FND_API.G_TRUE. Default is fnd_api.g_false
560: | p_branch_id Party ID of the branch to be inactivated.|
561: | p_end_date Inactive date of the bank branch. |
562: | IN/OUT: |
563: | p_object_version_number Current object version number for the |

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

564: | code assignment of the bank institution|
565: | type for the bank branch. |
566: | OUT: |
567: | x_return_status Return status after the call. The status can |
568: | be FND_API.G_RET_STS_SUCCESS (success), |
569: | fnd_api.g_ret_sts_error (error), |
570: | fnd_api.g_ret_sts_unexp_error (unexpected |
571: | error). |
572: | x_msg_count Number of messages in message stack. |

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

565: | type for the bank branch. |
566: | OUT: |
567: | x_return_status Return status after the call. The status can |
568: | be FND_API.G_RET_STS_SUCCESS (success), |
569: | fnd_api.g_ret_sts_error (error), |
570: | fnd_api.g_ret_sts_unexp_error (unexpected |
571: | error). |
572: | x_msg_count Number of messages in message stack. |
573: | x_msg_data Message text if x_msg_count is 1. |

Line 570: | fnd_api.g_ret_sts_unexp_error (unexpected |

566: | OUT: |
567: | x_return_status Return status after the call. The status can |
568: | be FND_API.G_RET_STS_SUCCESS (success), |
569: | fnd_api.g_ret_sts_error (error), |
570: | fnd_api.g_ret_sts_unexp_error (unexpected |
571: | error). |
572: | x_msg_count Number of messages in message stack. |
573: | x_msg_data Message text if x_msg_count is 1. |
574: | MODIFICATION HISTORY |

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

574: | MODIFICATION HISTORY |
575: | 25-AUG-2004 Xin Wang Created. |
576: +=======================================================================*/
577: PROCEDURE set_bank_branch_end_date (
578: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
579: p_branch_id IN NUMBER,
580: p_end_date IN DATE,
581: p_object_version_number IN OUT NOCOPY NUMBER,
582: x_return_status OUT NOCOPY VARCHAR2,

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

625: | |
626: | ARGUMENTS |
627: | IN: |
628: | p_init_msg_list Initialize message stack if it is set to |
629: | FND_API.G_TRUE. Default is fnd_api.g_false |
630: | p_acct_rec Bank account record. |
631: | IN/OUT: |
632: | OUT: |
633: | x_acct_id Bank account ID. |

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

631: | IN/OUT: |
632: | OUT: |
633: | x_acct_id Bank account ID. |
634: | x_return_status Return status after the call. The status can |
635: | be FND_API.G_RET_STS_SUCCESS (success), |
636: | fnd_api.g_ret_sts_error (error), |
637: | fnd_api.g_ret_sts_unexp_error (unexpected |
638: | error). |
639: | x_msg_count Number of messages in message stack. |

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

632: | OUT: |
633: | x_acct_id Bank account ID. |
634: | x_return_status Return status after the call. The status can |
635: | be FND_API.G_RET_STS_SUCCESS (success), |
636: | fnd_api.g_ret_sts_error (error), |
637: | fnd_api.g_ret_sts_unexp_error (unexpected |
638: | error). |
639: | x_msg_count Number of messages in message stack. |
640: | x_msg_data Message text if x_msg_count is 1. |

Line 637: | fnd_api.g_ret_sts_unexp_error (unexpected |

633: | x_acct_id Bank account ID. |
634: | x_return_status Return status after the call. The status can |
635: | be FND_API.G_RET_STS_SUCCESS (success), |
636: | fnd_api.g_ret_sts_error (error), |
637: | fnd_api.g_ret_sts_unexp_error (unexpected |
638: | error). |
639: | x_msg_count Number of messages in message stack. |
640: | x_msg_data Message text if x_msg_count is 1. |
641: | MODIFICATION HISTORY |

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

641: | MODIFICATION HISTORY |
642: | 25-AUG-2004 Xin Wang Created. |
643: +=======================================================================*/
644: PROCEDURE create_bank_acct (
645: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
646: p_acct_rec IN BankAcct_rec_type,
647: x_acct_id OUT NOCOPY NUMBER,
648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,

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

661: | |
662: | ARGUMENTS |
663: | IN: |
664: | p_init_msg_list Initialize message stack if it is set to |
665: | FND_API.G_TRUE. Default is fnd_api.g_false
666: | p_acct_rec External bank account record. |
667: | IN/OUT: |
668: | p_object_version_number Current object version number for the |
669: | bank account. |

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

668: | p_object_version_number Current object version number for the |
669: | bank account. |
670: | OUT: |
671: | x_return_status Return status after the call. The status can |
672: | be FND_API.G_RET_STS_SUCCESS (success), |
673: | fnd_api.g_ret_sts_error (error), |
674: | fnd_api.g_ret_sts_unexp_error (unexpected |
675: | error). |
676: | x_msg_count Number of messages in message stack. |

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

669: | bank account. |
670: | OUT: |
671: | x_return_status Return status after the call. The status can |
672: | be FND_API.G_RET_STS_SUCCESS (success), |
673: | fnd_api.g_ret_sts_error (error), |
674: | fnd_api.g_ret_sts_unexp_error (unexpected |
675: | error). |
676: | x_msg_count Number of messages in message stack. |
677: | x_msg_data Message text if x_msg_count is 1. |

Line 674: | fnd_api.g_ret_sts_unexp_error (unexpected |

670: | OUT: |
671: | x_return_status Return status after the call. The status can |
672: | be FND_API.G_RET_STS_SUCCESS (success), |
673: | fnd_api.g_ret_sts_error (error), |
674: | fnd_api.g_ret_sts_unexp_error (unexpected |
675: | error). |
676: | x_msg_count Number of messages in message stack. |
677: | x_msg_data Message text if x_msg_count is 1. |
678: | MODIFICATION HISTORY |

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

678: | MODIFICATION HISTORY |
679: | 25-AUG-2004 Xin Wang Created. |
680: +=======================================================================*/
681: PROCEDURE update_bank_acct (
682: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
683: p_acct_rec IN BankAcct_rec_type,
684: p_object_version_number IN OUT NOCOPY NUMBER,
685: x_return_status OUT NOCOPY VARCHAR2,
686: x_msg_count OUT NOCOPY NUMBER,

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

688: );
689:
690:
691: PROCEDURE create_bank_acct_use (
692: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
693: p_acct_use_rec IN BankAcct_use_rec_type,
694: x_acct_use_id OUT NOCOPY NUMBER,
695: x_return_status OUT NOCOPY VARCHAR2,
696: x_msg_count OUT NOCOPY NUMBER,

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

698: );
699:
700:
701: PROCEDURE update_bank_acct_use (
702: p_init_msg_list IN VARCHAR2:= fnd_api.g_false,
703: p_acct_use_rec IN BankAcct_use_rec_type,
704: p_use_ovn IN OUT NOCOPY NUMBER,
705: p_ccid_ovn IN OUT NOCOPY NUMBER,
706: x_return_status OUT NOCOPY VARCHAR2,