263: * The oraInstrAdd API Creates a new payment instrument.
264: *
265: * @param p_api_version version of the API; current version is 1.0
266: * @rep:paraminfo {@rep:required}
267: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
268: * @param p_commit standard API parameter; default as FND_API.G_TRUE
269: * @param p_validation_level standard API parameter; default as
270: * FND_API.G_VALID_LEVEL_FULL
271: * @rep:paraminfo {@rep:required}
264: *
265: * @param p_api_version version of the API; current version is 1.0
266: * @rep:paraminfo {@rep:required}
267: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
268: * @param p_commit standard API parameter; default as FND_API.G_TRUE
269: * @param p_validation_level standard API parameter; default as
270: * FND_API.G_VALID_LEVEL_FULL
271: * @rep:paraminfo {@rep:required}
272: * @param p_pmtInstrRec payment instrument record
265: * @param p_api_version version of the API; current version is 1.0
266: * @rep:paraminfo {@rep:required}
267: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
268: * @param p_commit standard API parameter; default as FND_API.G_TRUE
269: * @param p_validation_level standard API parameter; default as
270: * FND_API.G_VALID_LEVEL_FULL
271: * @rep:paraminfo {@rep:required}
272: * @param p_pmtInstrRec payment instrument record
273: * @rep:paraminfo {@rep:required}
270: * FND_API.G_VALID_LEVEL_FULL
271: * @rep:paraminfo {@rep:required}
272: * @param p_pmtInstrRec payment instrument record
273: * @rep:paraminfo {@rep:required}
274: * @param x_return_status standard API parameter - output; indicates the overall
275: * status of the API call
276: * @param x_msg_count standard API parameter - output; holds the number of
277: * messages in the API message list
278: * @param x_msg_data standard API parameter - output; If the number is one,
272: * @param p_pmtInstrRec payment instrument record
273: * @rep:paraminfo {@rep:required}
274: * @param x_return_status standard API parameter - output; indicates the overall
275: * status of the API call
276: * @param x_msg_count standard API parameter - output; holds the number of
277: * messages in the API message list
278: * @param x_msg_data standard API parameter - output; If the number is one,
279: * then message data holds the message in an encoded format
280: * @param x_instr_id unique identifier for the newly created payment instrument
274: * @param x_return_status standard API parameter - output; indicates the overall
275: * status of the API call
276: * @param x_msg_count standard API parameter - output; holds the number of
277: * messages in the API message list
278: * @param x_msg_data standard API parameter - output; If the number is one,
279: * then message data holds the message in an encoded format
280: * @param x_instr_id unique identifier for the newly created payment instrument
281: * @param x_result result code of the operation
282: *
330: * The oraInstrMod API Modifies a payment instrument.
331: *
332: * @param p_api_version version of the API; current version is 1.0
333: * @rep:paraminfo {@rep:required}
334: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
335: * @param p_commit standard API parameter; default as FND_API.G_TRUE
336: * @param p_validation_level standard API parameter; default as
337: * FND_API.G_VALID_LEVEL_FULL
338: * @param p_payer_id payer identifier string
331: *
332: * @param p_api_version version of the API; current version is 1.0
333: * @rep:paraminfo {@rep:required}
334: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
335: * @param p_commit standard API parameter; default as FND_API.G_TRUE
336: * @param p_validation_level standard API parameter; default as
337: * FND_API.G_VALID_LEVEL_FULL
338: * @param p_payer_id payer identifier string
339: * @rep:paraminfo {@rep:required}
332: * @param p_api_version version of the API; current version is 1.0
333: * @rep:paraminfo {@rep:required}
334: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
335: * @param p_commit standard API parameter; default as FND_API.G_TRUE
336: * @param p_validation_level standard API parameter; default as
337: * FND_API.G_VALID_LEVEL_FULL
338: * @param p_payer_id payer identifier string
339: * @rep:paraminfo {@rep:required}
340: * @param p_pmtInstrRec payment instrument record. The Instr_Id is required.
338: * @param p_payer_id payer identifier string
339: * @rep:paraminfo {@rep:required}
340: * @param p_pmtInstrRec payment instrument record. The Instr_Id is required.
341: * @rep:paraminfo {@rep:required}
342: * @param x_return_status standard API parameter - output; indicates the overall
343: * status of the API call
344: * @param x_msg_count standard API parameter - output; holds the number of
345: * messages in the API message list
346: * @param x_msg_data standard API parameter - output; if the number is one,
340: * @param p_pmtInstrRec payment instrument record. The Instr_Id is required.
341: * @rep:paraminfo {@rep:required}
342: * @param x_return_status standard API parameter - output; indicates the overall
343: * status of the API call
344: * @param x_msg_count standard API parameter - output; holds the number of
345: * messages in the API message list
346: * @param x_msg_data standard API parameter - output; if the number is one,
347: * then message data holds the message in an encoded format
348: * @param x_result result of the operation
342: * @param x_return_status standard API parameter - output; indicates the overall
343: * status of the API call
344: * @param x_msg_count standard API parameter - output; holds the number of
345: * messages in the API message list
346: * @param x_msg_data standard API parameter - output; if the number is one,
347: * then message data holds the message in an encoded format
348: * @param x_result result of the operation
349: *
350: * @rep:scope public
395: * The oraInstrDel API Deletes a payment instrument.
396: *
397: * @param p_api_version version of the API; current version is 1.0
398: * @rep:paraminfo {@rep:required}
399: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
400: * @param p_commit standard API parameter; default as FND_API.G_TRUE
401: * @param p_validation_level standard API parameter; default as
402: * FND_API.G_VALID_LEVEL_FULL
403: * @param p_payer_id payer identifier string
396: *
397: * @param p_api_version version of the API; current version is 1.0
398: * @rep:paraminfo {@rep:required}
399: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
400: * @param p_commit standard API parameter; default as FND_API.G_TRUE
401: * @param p_validation_level standard API parameter; default as
402: * FND_API.G_VALID_LEVEL_FULL
403: * @param p_payer_id payer identifier string
404: * @rep:paraminfo {@rep:required}
397: * @param p_api_version version of the API; current version is 1.0
398: * @rep:paraminfo {@rep:required}
399: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
400: * @param p_commit standard API parameter; default as FND_API.G_TRUE
401: * @param p_validation_level standard API parameter; default as
402: * FND_API.G_VALID_LEVEL_FULL
403: * @param p_payer_id payer identifier string
404: * @rep:paraminfo {@rep:required}
405: * @param p_instr_id payment instrument unique identifier
403: * @param p_payer_id payer identifier string
404: * @rep:paraminfo {@rep:required}
405: * @param p_instr_id payment instrument unique identifier
406: * @rep:paraminfo {@rep:required}
407: * @param x_return_status standard API parameter - output; indicates the overall
408: * status of the API call
409: * @param x_msg_count standard API parameter - output; holds the number of
410: * messages in the API message list
411: * @param x_msg_data standard API parameter - output; if the number is one,
405: * @param p_instr_id payment instrument unique identifier
406: * @rep:paraminfo {@rep:required}
407: * @param x_return_status standard API parameter - output; indicates the overall
408: * status of the API call
409: * @param x_msg_count standard API parameter - output; holds the number of
410: * messages in the API message list
411: * @param x_msg_data standard API parameter - output; if the number is one,
412: * then message data holds the message in an encoded format
413: *
407: * @param x_return_status standard API parameter - output; indicates the overall
408: * status of the API call
409: * @param x_msg_count standard API parameter - output; holds the number of
410: * messages in the API message list
411: * @param x_msg_data standard API parameter - output; if the number is one,
412: * then message data holds the message in an encoded format
413: *
414: * @rep:scope public
415: * @rep:displayname Delete Payment Instrument
460: * payment instruments that a payer may have based on the payer_id.
461:
462: * @param p_api_version version of the API; current version is 1.0
463: * @rep:paraminfo {@rep:required}
464: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
465: * @param p_commit standard API parameter; default as FND_API.G_TRUE
466: * @param p_validation_level standard API parameter; default as
467: * FND_API.G_VALID_LEVEL_FULL
468: * @param p_payer_id payer identifier string
461:
462: * @param p_api_version version of the API; current version is 1.0
463: * @rep:paraminfo {@rep:required}
464: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
465: * @param p_commit standard API parameter; default as FND_API.G_TRUE
466: * @param p_validation_level standard API parameter; default as
467: * FND_API.G_VALID_LEVEL_FULL
468: * @param p_payer_id payer identifier string
469: * @rep:paraminfo {@rep:required}
462: * @param p_api_version version of the API; current version is 1.0
463: * @rep:paraminfo {@rep:required}
464: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
465: * @param p_commit standard API parameter; default as FND_API.G_TRUE
466: * @param p_validation_level standard API parameter; default as
467: * FND_API.G_VALID_LEVEL_FULL
468: * @param p_payer_id payer identifier string
469: * @rep:paraminfo {@rep:required}
470: * @param x_return_status standard API parameter - output; indicates the overall
466: * @param p_validation_level standard API parameter; default as
467: * FND_API.G_VALID_LEVEL_FULL
468: * @param p_payer_id payer identifier string
469: * @rep:paraminfo {@rep:required}
470: * @param x_return_status standard API parameter - output; indicates the overall
471: * status of the API call
472: * @param x_msg_count standard API parameter - output; holds the number of
473: * messages in the API message list
474: * @param x_msg_data standard API parameter - output; if the number is one,
468: * @param p_payer_id payer identifier string
469: * @rep:paraminfo {@rep:required}
470: * @param x_return_status standard API parameter - output; indicates the overall
471: * status of the API call
472: * @param x_msg_count standard API parameter - output; holds the number of
473: * messages in the API message list
474: * @param x_msg_data standard API parameter - output; if the number is one,
475: * then message data holds the message in an encoded format
476: * @param x_creditcard_tbl credit cards of the payer
470: * @param x_return_status standard API parameter - output; indicates the overall
471: * status of the API call
472: * @param x_msg_count standard API parameter - output; holds the number of
473: * messages in the API message list
474: * @param x_msg_data standard API parameter - output; if the number is one,
475: * then message data holds the message in an encoded format
476: * @param x_creditcard_tbl credit cards of the payer
477: * @param x_purchasecard_tbl purchase cards of the payer
478: * @param x_bankacct_tbl bank accounts of the payer
508: * key as an argument in case an instrument is encrypted.
509: *
510: * @param p_api_version version of the API; current version is 1.0
511: * @rep:paraminfo {@rep:required}
512: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
513: * @param p_commit standard API parameter; default as FND_API.G_TRUE
514: * @param p_validation_level standard API parameter; default as
515: * FND_API.G_VALID_LEVEL_FULL
516: * @param p_payer_id payer identifier string
509: *
510: * @param p_api_version version of the API; current version is 1.0
511: * @rep:paraminfo {@rep:required}
512: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
513: * @param p_commit standard API parameter; default as FND_API.G_TRUE
514: * @param p_validation_level standard API parameter; default as
515: * FND_API.G_VALID_LEVEL_FULL
516: * @param p_payer_id payer identifier string
517: * @rep:paraminfo {@rep:required}
510: * @param p_api_version version of the API; current version is 1.0
511: * @rep:paraminfo {@rep:required}
512: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
513: * @param p_commit standard API parameter; default as FND_API.G_TRUE
514: * @param p_validation_level standard API parameter; default as
515: * FND_API.G_VALID_LEVEL_FULL
516: * @param p_payer_id payer identifier string
517: * @rep:paraminfo {@rep:required}
518: * @param p_sys_sec_key instrument registration security key
515: * FND_API.G_VALID_LEVEL_FULL
516: * @param p_payer_id payer identifier string
517: * @rep:paraminfo {@rep:required}
518: * @param p_sys_sec_key instrument registration security key
519: * @param x_return_status standard API parameter - output; indicates the overall
520: * status of the API call
521: * @param x_msg_count standard API parameter - output; holds the number of
522: * messages in the API message list
523: * @param x_msg_data standard API parameter - output; if the number is one,
517: * @rep:paraminfo {@rep:required}
518: * @param p_sys_sec_key instrument registration security key
519: * @param x_return_status standard API parameter - output; indicates the overall
520: * status of the API call
521: * @param x_msg_count standard API parameter - output; holds the number of
522: * messages in the API message list
523: * @param x_msg_data standard API parameter - output; if the number is one,
524: * then message data holds the message in an encoded format
525: * @param x_creditcard_tbl credit cards of the payer
519: * @param x_return_status standard API parameter - output; indicates the overall
520: * status of the API call
521: * @param x_msg_count standard API parameter - output; holds the number of
522: * messages in the API message list
523: * @param x_msg_data standard API parameter - output; if the number is one,
524: * then message data holds the message in an encoded format
525: * @param x_creditcard_tbl credit cards of the payer
526: * @param x_purchasecard_tbl purchase cards of the payer
527: * @param x_bankacct_tbl bank accounts of the payer
578: * payer_id and instr_id.
579: *
580: * @param p_api_version version of the API; current version is 1.0
581: * @rep:paraminfo {@rep:required}
582: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
583: * @param p_commit standard API parameter; default as FND_API.G_TRUE
584: * @param p_validation_level standard API parameter; default as
585: * FND_API.G_VALID_LEVEL_FULL
586: * @param p_payer_id payer identifier string
579: *
580: * @param p_api_version version of the API; current version is 1.0
581: * @rep:paraminfo {@rep:required}
582: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
583: * @param p_commit standard API parameter; default as FND_API.G_TRUE
584: * @param p_validation_level standard API parameter; default as
585: * FND_API.G_VALID_LEVEL_FULL
586: * @param p_payer_id payer identifier string
587: * @rep:paraminfo {@rep:required}
580: * @param p_api_version version of the API; current version is 1.0
581: * @rep:paraminfo {@rep:required}
582: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
583: * @param p_commit standard API parameter; default as FND_API.G_TRUE
584: * @param p_validation_level standard API parameter; default as
585: * FND_API.G_VALID_LEVEL_FULL
586: * @param p_payer_id payer identifier string
587: * @rep:paraminfo {@rep:required}
588: * @param p_instr_id payment instrument unique identifier
586: * @param p_payer_id payer identifier string
587: * @rep:paraminfo {@rep:required}
588: * @param p_instr_id payment instrument unique identifier
589: * @rep:paraminfo {@rep:required}
590: * @param x_return_status standard API parameter - output; indicates the overall
591: * status of the API call
592: * @param x_msg_count standard API parameter - output; holds the number of
593: * messages in the API message list
594: * @param x_msg_data standard API parameter - output; if the number is one,
588: * @param p_instr_id payment instrument unique identifier
589: * @rep:paraminfo {@rep:required}
590: * @param x_return_status standard API parameter - output; indicates the overall
591: * status of the API call
592: * @param x_msg_count standard API parameter - output; holds the number of
593: * messages in the API message list
594: * @param x_msg_data standard API parameter - output; if the number is one,
595: * then message data holds the message in an encoded format
596: * @param x_pmtInstrRec payment instrument of the payer
590: * @param x_return_status standard API parameter - output; indicates the overall
591: * status of the API call
592: * @param x_msg_count standard API parameter - output; holds the number of
593: * messages in the API message list
594: * @param x_msg_data standard API parameter - output; if the number is one,
595: * then message data holds the message in an encoded format
596: * @param x_pmtInstrRec payment instrument of the payer
597: *
598: * @rep:scope public
625: * as an argument in case the instrument is encrypted.
626: *
627: * @param p_api_version version of the API; current version is 1.0
628: * @rep:paraminfo {@rep:required}
629: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
630: * @param p_commit standard API parameter; default as FND_API.G_TRUE
631: * @param p_validation_level standard API parameter; default as
632: * FND_API.G_VALID_LEVEL_FULL
633: * @param p_payer_id payer identifier string
626: *
627: * @param p_api_version version of the API; current version is 1.0
628: * @rep:paraminfo {@rep:required}
629: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
630: * @param p_commit standard API parameter; default as FND_API.G_TRUE
631: * @param p_validation_level standard API parameter; default as
632: * FND_API.G_VALID_LEVEL_FULL
633: * @param p_payer_id payer identifier string
634: * @rep:paraminfo {@rep:required}
627: * @param p_api_version version of the API; current version is 1.0
628: * @rep:paraminfo {@rep:required}
629: * @param p_init_msg_list standard API parameter; default as FND_API.G_FALSE
630: * @param p_commit standard API parameter; default as FND_API.G_TRUE
631: * @param p_validation_level standard API parameter; default as
632: * FND_API.G_VALID_LEVEL_FULL
633: * @param p_payer_id payer identifier string
634: * @rep:paraminfo {@rep:required}
635: * @param p_instr_id payment instrument unique identifier
634: * @rep:paraminfo {@rep:required}
635: * @param p_instr_id payment instrument unique identifier
636: * @rep:paraminfo {@rep:required}
637: * @param p_sys_sec_key instrument registration security key
638: * @param x_return_status standard API parameter - output; indicates the overall
639: * status of the API call
640: * @param x_msg_count standard API parameter - output; holds the number of
641: * messages in the API message list
642: * @param x_msg_data standard API parameter - output; if the number is one,
636: * @rep:paraminfo {@rep:required}
637: * @param p_sys_sec_key instrument registration security key
638: * @param x_return_status standard API parameter - output; indicates the overall
639: * status of the API call
640: * @param x_msg_count standard API parameter - output; holds the number of
641: * messages in the API message list
642: * @param x_msg_data standard API parameter - output; if the number is one,
643: * then message data holds the message in an encoded format
644: * @param x_pmtInstrRec payment instrument of the payer
638: * @param x_return_status standard API parameter - output; indicates the overall
639: * status of the API call
640: * @param x_msg_count standard API parameter - output; holds the number of
641: * messages in the API message list
642: * @param x_msg_data standard API parameter - output; if the number is one,
643: * then message data holds the message in an encoded format
644: * @param x_pmtInstrRec payment instrument of the payer
645: *
646: * @rep:scope public
664:
665: -------------------------------------------------------------------------------
666: /* UTILITY FUNCTION#1: ENCODE
667: This function returns a Base64 encoded string.
668: This function is being used temporarily as there is no standard function available
669: in 8i. It is available in 9i though. This should be discarded when used for 9i.
670: */
671: -------------------------------------------------------------------------------
672:
674:
675: -------------------------------------------------------------------------------
676: /* UTILITY FUNCTION#2: DECODE
677: This function returns a decoded string for a Base64 encoded string.
678: This function is being used temporarily as there is no standard function available
679: in 8i. It is available in 9i though. This should be discarded when used for 9i.
680: */
681: -------------------------------------------------------------------------------
682: FUNCTION decode(s IN VARCHAR2) RETURN VARCHAR2;