399: l_pmtInstrTab IBY_PAYINSTR_PUB.pmtInstrTabType;
400:
401: /* used to record manual payments */
402: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
403: l_pmts_tab IBY_PAYGROUP_PUB.paymentTabType;
404: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
405:
406: /* used to store access types for manual payment */
407: l_process_func_rec IBY_PROCESS_FUNCTIONS%ROWTYPE;
932: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
933: print_debuginfo(l_module_name, 'Invoking payment recording logic ..');
934:
935: END IF;
936: IBY_PAYGROUP_PUB.getNextPaymentID(l_payment_id);
937:
938: --print_debuginfo(l_module_name, 'Got the payment id as: ' || IBY_PAYGROUP_PUB.getNextPaymentID(l_payment_id));
939:
940: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
934:
935: END IF;
936: IBY_PAYGROUP_PUB.getNextPaymentID(l_payment_id);
937:
938: --print_debuginfo(l_module_name, 'Got the payment id as: ' || IBY_PAYGROUP_PUB.getNextPaymentID(l_payment_id));
939:
940: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
941: print_debuginfo(l_module_name, 'Before calling initialize_pmt_table..');
942:
940: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
941: print_debuginfo(l_module_name, 'Before calling initialize_pmt_table..');
942:
943: END IF;
944: IBY_PAYGROUP_PUB.delete_pmtTable; --Bug 16100903 Deleting PMT table before initializing
945: IBY_PAYGROUP_PUB.initialize_pmt_table(l_trx_pmt_index);
946:
947: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
948: print_debuginfo(l_module_name, 'Successfully came out of the call initialize_pmt_table..');
941: print_debuginfo(l_module_name, 'Before calling initialize_pmt_table..');
942:
943: END IF;
944: IBY_PAYGROUP_PUB.delete_pmtTable; --Bug 16100903 Deleting PMT table before initializing
945: IBY_PAYGROUP_PUB.initialize_pmt_table(l_trx_pmt_index);
946:
947: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
948: print_debuginfo(l_module_name, 'Successfully came out of the call initialize_pmt_table..');
949:
947: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
948: print_debuginfo(l_module_name, 'Successfully came out of the call initialize_pmt_table..');
949:
950: END IF;
951: FOR l_trx_pmt_index IN nvl(IBY_PAYGROUP_PUB.pmtTable.payment_id.FIRST,0) .. nvl(IBY_PAYGROUP_PUB.pmtTable.payment_id.LAST,-99)
952: LOOP
953:
954: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
955: print_debuginfo(l_module_name, 'Inside the for loop for manual payments ..');
953:
954: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
955: print_debuginfo(l_module_name, 'Inside the for loop for manual payments ..');
956: END IF;
957: IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_pmt_index) := l_payment_id;
958:
959: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
960: print_debuginfo(l_module_name, 'l_payment_id is ' || IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_pmt_index));
961:
956: END IF;
957: IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_pmt_index) := l_payment_id;
958:
959: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
960: print_debuginfo(l_module_name, 'l_payment_id is ' || IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_pmt_index));
961:
962: END IF;
963: /*
964: * Fix for bug 4956141:
964: * Fix for bug 4956141:
965: *
966: * Provide payment reference number for manual payments.
967: */
968: IBY_PAYGROUP_PUB.pmtTable.
969: payment_reference_number(l_trx_pmt_index) := provide_pmt_reference_num();
970:
971: IF (IBY_PAYGROUP_PUB.pmtTable.payment_reference_number(l_trx_pmt_index) = -1) THEN
972:
967: */
968: IBY_PAYGROUP_PUB.pmtTable.
969: payment_reference_number(l_trx_pmt_index) := provide_pmt_reference_num();
970:
971: IF (IBY_PAYGROUP_PUB.pmtTable.payment_reference_number(l_trx_pmt_index) = -1) THEN
972:
973: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
974: print_debuginfo(l_module_name, 'Unable to provide payment '
975: || 'reference for manual payment.'
990: RETURN;
991:
992: END IF;
993:
994: IBY_PAYGROUP_PUB.pmtTable.payment_method_code(l_trx_pmt_index) := p_payment_method_cd;
995: IBY_PAYGROUP_PUB.pmtTable.payment_service_request_id(l_trx_pmt_index) := l_payreq_id;
996: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'MANUAL';
997:
998: /*
991:
992: END IF;
993:
994: IBY_PAYGROUP_PUB.pmtTable.payment_method_code(l_trx_pmt_index) := p_payment_method_cd;
995: IBY_PAYGROUP_PUB.pmtTable.payment_service_request_id(l_trx_pmt_index) := l_payreq_id;
996: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'MANUAL';
997:
998: /*
999: * The final status of the manual payment is dependant
992: END IF;
993:
994: IBY_PAYGROUP_PUB.pmtTable.payment_method_code(l_trx_pmt_index) := p_payment_method_cd;
995: IBY_PAYGROUP_PUB.pmtTable.payment_service_request_id(l_trx_pmt_index) := l_payreq_id;
996: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'MANUAL';
997:
998: /*
999: * The final status of the manual payment is dependant
1000: * upon whether it is an printed or an electronic
1000: * upon whether it is an printed or an electronic
1001: * payment.
1002: */
1003: IF (l_profile_attribs.processing_type = 'PRINTED') THEN
1004: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) := PMT_STATUS_ISSUED;
1005: ELSE
1006: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) := PMT_STATUS_FORMATTED;
1007: END IF;
1008:
1002: */
1003: IF (l_profile_attribs.processing_type = 'PRINTED') THEN
1004: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) := PMT_STATUS_ISSUED;
1005: ELSE
1006: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) := PMT_STATUS_FORMATTED;
1007: END IF;
1008:
1009: IBY_PAYGROUP_PUB.pmtTable.payment_function(l_trx_pmt_index) := p_payment_function;
1010: IBY_PAYGROUP_PUB.pmtTable.payment_amount(l_trx_pmt_index) := p_payment_amount;
1005: ELSE
1006: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) := PMT_STATUS_FORMATTED;
1007: END IF;
1008:
1009: IBY_PAYGROUP_PUB.pmtTable.payment_function(l_trx_pmt_index) := p_payment_function;
1010: IBY_PAYGROUP_PUB.pmtTable.payment_amount(l_trx_pmt_index) := p_payment_amount;
1011: IBY_PAYGROUP_PUB.pmtTable.payment_currency_code(l_trx_pmt_index) := p_payment_currency;
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1006: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) := PMT_STATUS_FORMATTED;
1007: END IF;
1008:
1009: IBY_PAYGROUP_PUB.pmtTable.payment_function(l_trx_pmt_index) := p_payment_function;
1010: IBY_PAYGROUP_PUB.pmtTable.payment_amount(l_trx_pmt_index) := p_payment_amount;
1011: IBY_PAYGROUP_PUB.pmtTable.payment_currency_code(l_trx_pmt_index) := p_payment_currency;
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1007: END IF;
1008:
1009: IBY_PAYGROUP_PUB.pmtTable.payment_function(l_trx_pmt_index) := p_payment_function;
1010: IBY_PAYGROUP_PUB.pmtTable.payment_amount(l_trx_pmt_index) := p_payment_amount;
1011: IBY_PAYGROUP_PUB.pmtTable.payment_currency_code(l_trx_pmt_index) := p_payment_currency;
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1015: IBY_PAYGROUP_PUB.pmtTable.legal_entity_id(l_trx_pmt_index) := p_legal_entity_id;
1008:
1009: IBY_PAYGROUP_PUB.pmtTable.payment_function(l_trx_pmt_index) := p_payment_function;
1010: IBY_PAYGROUP_PUB.pmtTable.payment_amount(l_trx_pmt_index) := p_payment_amount;
1011: IBY_PAYGROUP_PUB.pmtTable.payment_currency_code(l_trx_pmt_index) := p_payment_currency;
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1015: IBY_PAYGROUP_PUB.pmtTable.legal_entity_id(l_trx_pmt_index) := p_legal_entity_id;
1016: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'Y';
1009: IBY_PAYGROUP_PUB.pmtTable.payment_function(l_trx_pmt_index) := p_payment_function;
1010: IBY_PAYGROUP_PUB.pmtTable.payment_amount(l_trx_pmt_index) := p_payment_amount;
1011: IBY_PAYGROUP_PUB.pmtTable.payment_currency_code(l_trx_pmt_index) := p_payment_currency;
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1015: IBY_PAYGROUP_PUB.pmtTable.legal_entity_id(l_trx_pmt_index) := p_legal_entity_id;
1016: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'Y';
1017: IBY_PAYGROUP_PUB.pmtTable.ext_payee_id(l_trx_pmt_index) := IBY_DISBURSE_SUBMIT_PUB_PKG.
1010: IBY_PAYGROUP_PUB.pmtTable.payment_amount(l_trx_pmt_index) := p_payment_amount;
1011: IBY_PAYGROUP_PUB.pmtTable.payment_currency_code(l_trx_pmt_index) := p_payment_currency;
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1015: IBY_PAYGROUP_PUB.pmtTable.legal_entity_id(l_trx_pmt_index) := p_legal_entity_id;
1016: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'Y';
1017: IBY_PAYGROUP_PUB.pmtTable.ext_payee_id(l_trx_pmt_index) := IBY_DISBURSE_SUBMIT_PUB_PKG.
1018: derivePayeeIdFromContext(
1011: IBY_PAYGROUP_PUB.pmtTable.payment_currency_code(l_trx_pmt_index) := p_payment_currency;
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1015: IBY_PAYGROUP_PUB.pmtTable.legal_entity_id(l_trx_pmt_index) := p_legal_entity_id;
1016: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'Y';
1017: IBY_PAYGROUP_PUB.pmtTable.ext_payee_id(l_trx_pmt_index) := IBY_DISBURSE_SUBMIT_PUB_PKG.
1018: derivePayeeIdFromContext(
1019: p_payee_party_id,
1012: IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(l_trx_pmt_index) := p_internal_bank_account_id;
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1015: IBY_PAYGROUP_PUB.pmtTable.legal_entity_id(l_trx_pmt_index) := p_legal_entity_id;
1016: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'Y';
1017: IBY_PAYGROUP_PUB.pmtTable.ext_payee_id(l_trx_pmt_index) := IBY_DISBURSE_SUBMIT_PUB_PKG.
1018: derivePayeeIdFromContext(
1019: p_payee_party_id,
1020: p_payee_party_site_id,
1013: IBY_PAYGROUP_PUB.pmtTable.org_id(l_trx_pmt_index) := p_organization_id;
1014: IBY_PAYGROUP_PUB.pmtTable.org_type(l_trx_pmt_index) := p_organization_type;
1015: IBY_PAYGROUP_PUB.pmtTable.legal_entity_id(l_trx_pmt_index) := p_legal_entity_id;
1016: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'Y';
1017: IBY_PAYGROUP_PUB.pmtTable.ext_payee_id(l_trx_pmt_index) := IBY_DISBURSE_SUBMIT_PUB_PKG.
1018: derivePayeeIdFromContext(
1019: p_payee_party_id,
1020: p_payee_party_site_id,
1021: p_supplier_site_id,
1022: p_organization_id,
1023: p_organization_type,
1024: p_payment_function
1025: );
1026: IBY_PAYGROUP_PUB.pmtTable.payee_party_id(l_trx_pmt_index) := p_payee_party_id;
1027: IBY_PAYGROUP_PUB.pmtTable.party_site_id(l_trx_pmt_index) := p_payee_party_site_id;
1028: IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_pmt_index) := p_supplier_site_id;
1029: IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_pmt_index) := p_pay_process_profile_id;
1030: IBY_PAYGROUP_PUB.pmtTable.payment_date(l_trx_pmt_index) := p_payment_date;
1023: p_organization_type,
1024: p_payment_function
1025: );
1026: IBY_PAYGROUP_PUB.pmtTable.payee_party_id(l_trx_pmt_index) := p_payee_party_id;
1027: IBY_PAYGROUP_PUB.pmtTable.party_site_id(l_trx_pmt_index) := p_payee_party_site_id;
1028: IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_pmt_index) := p_supplier_site_id;
1029: IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_pmt_index) := p_pay_process_profile_id;
1030: IBY_PAYGROUP_PUB.pmtTable.payment_date(l_trx_pmt_index) := p_payment_date;
1031: IBY_PAYGROUP_PUB.pmtTable.anticipated_value_date(l_trx_pmt_index) := p_anticipated_value_date;
1024: p_payment_function
1025: );
1026: IBY_PAYGROUP_PUB.pmtTable.payee_party_id(l_trx_pmt_index) := p_payee_party_id;
1027: IBY_PAYGROUP_PUB.pmtTable.party_site_id(l_trx_pmt_index) := p_payee_party_site_id;
1028: IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_pmt_index) := p_supplier_site_id;
1029: IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_pmt_index) := p_pay_process_profile_id;
1030: IBY_PAYGROUP_PUB.pmtTable.payment_date(l_trx_pmt_index) := p_payment_date;
1031: IBY_PAYGROUP_PUB.pmtTable.anticipated_value_date(l_trx_pmt_index) := p_anticipated_value_date;
1032:
1025: );
1026: IBY_PAYGROUP_PUB.pmtTable.payee_party_id(l_trx_pmt_index) := p_payee_party_id;
1027: IBY_PAYGROUP_PUB.pmtTable.party_site_id(l_trx_pmt_index) := p_payee_party_site_id;
1028: IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_pmt_index) := p_supplier_site_id;
1029: IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_pmt_index) := p_pay_process_profile_id;
1030: IBY_PAYGROUP_PUB.pmtTable.payment_date(l_trx_pmt_index) := p_payment_date;
1031: IBY_PAYGROUP_PUB.pmtTable.anticipated_value_date(l_trx_pmt_index) := p_anticipated_value_date;
1032:
1033: /*
1026: IBY_PAYGROUP_PUB.pmtTable.payee_party_id(l_trx_pmt_index) := p_payee_party_id;
1027: IBY_PAYGROUP_PUB.pmtTable.party_site_id(l_trx_pmt_index) := p_payee_party_site_id;
1028: IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_pmt_index) := p_supplier_site_id;
1029: IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_pmt_index) := p_pay_process_profile_id;
1030: IBY_PAYGROUP_PUB.pmtTable.payment_date(l_trx_pmt_index) := p_payment_date;
1031: IBY_PAYGROUP_PUB.pmtTable.anticipated_value_date(l_trx_pmt_index) := p_anticipated_value_date;
1032:
1033: /*
1034: * Fix for bug 5727990:
1027: IBY_PAYGROUP_PUB.pmtTable.party_site_id(l_trx_pmt_index) := p_payee_party_site_id;
1028: IBY_PAYGROUP_PUB.pmtTable.supplier_site_id(l_trx_pmt_index) := p_supplier_site_id;
1029: IBY_PAYGROUP_PUB.pmtTable.payment_profile_id(l_trx_pmt_index) := p_pay_process_profile_id;
1030: IBY_PAYGROUP_PUB.pmtTable.payment_date(l_trx_pmt_index) := p_payment_date;
1031: IBY_PAYGROUP_PUB.pmtTable.anticipated_value_date(l_trx_pmt_index) := p_anticipated_value_date;
1032:
1033: /*
1034: * Fix for bug 5727990:
1035: *
1036: * If the payment type is electronic then set the
1037: * paper document number to null (instead of -1).
1038: */
1039: IF (l_profile_attribs.processing_type = 'ELECTRONIC' AND p_paper_document_number = -1) THEN
1040: IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index) := NULL;
1041: ELSE
1042: IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index) := p_paper_document_number;
1043: END IF;
1044:
1038: */
1039: IF (l_profile_attribs.processing_type = 'ELECTRONIC' AND p_paper_document_number = -1) THEN
1040: IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index) := NULL;
1041: ELSE
1042: IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index) := p_paper_document_number;
1043: END IF;
1044:
1045: IBY_PAYGROUP_PUB.pmtTable.maturity_date(l_trx_pmt_index) := p_maturity_date;
1046: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) := p_bill_payable_flag;
1041: ELSE
1042: IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index) := p_paper_document_number;
1043: END IF;
1044:
1045: IBY_PAYGROUP_PUB.pmtTable.maturity_date(l_trx_pmt_index) := p_maturity_date;
1046: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) := p_bill_payable_flag;
1047: IBY_PAYGROUP_PUB.pmtTable.attribute_category(l_trx_pmt_index) := p_attribute_category;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1042: IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index) := p_paper_document_number;
1043: END IF;
1044:
1045: IBY_PAYGROUP_PUB.pmtTable.maturity_date(l_trx_pmt_index) := p_maturity_date;
1046: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) := p_bill_payable_flag;
1047: IBY_PAYGROUP_PUB.pmtTable.attribute_category(l_trx_pmt_index) := p_attribute_category;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1043: END IF;
1044:
1045: IBY_PAYGROUP_PUB.pmtTable.maturity_date(l_trx_pmt_index) := p_maturity_date;
1046: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) := p_bill_payable_flag;
1047: IBY_PAYGROUP_PUB.pmtTable.attribute_category(l_trx_pmt_index) := p_attribute_category;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1044:
1045: IBY_PAYGROUP_PUB.pmtTable.maturity_date(l_trx_pmt_index) := p_maturity_date;
1046: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) := p_bill_payable_flag;
1047: IBY_PAYGROUP_PUB.pmtTable.attribute_category(l_trx_pmt_index) := p_attribute_category;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1045: IBY_PAYGROUP_PUB.pmtTable.maturity_date(l_trx_pmt_index) := p_maturity_date;
1046: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) := p_bill_payable_flag;
1047: IBY_PAYGROUP_PUB.pmtTable.attribute_category(l_trx_pmt_index) := p_attribute_category;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1046: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) := p_bill_payable_flag;
1047: IBY_PAYGROUP_PUB.pmtTable.attribute_category(l_trx_pmt_index) := p_attribute_category;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1047: IBY_PAYGROUP_PUB.pmtTable.attribute_category(l_trx_pmt_index) := p_attribute_category;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1048: IBY_PAYGROUP_PUB.pmtTable.attribute1(l_trx_pmt_index) := p_attribute1;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1049: IBY_PAYGROUP_PUB.pmtTable.attribute2(l_trx_pmt_index) := p_attribute2;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1050: IBY_PAYGROUP_PUB.pmtTable.attribute3(l_trx_pmt_index) := p_attribute3;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1051: IBY_PAYGROUP_PUB.pmtTable.attribute4(l_trx_pmt_index) := p_attribute4;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1052: IBY_PAYGROUP_PUB.pmtTable.attribute5(l_trx_pmt_index) := p_attribute5;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1060: IBY_PAYGROUP_PUB.pmtTable.attribute13(l_trx_pmt_index) := p_attribute13;
1053: IBY_PAYGROUP_PUB.pmtTable.attribute6(l_trx_pmt_index) := p_attribute6;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1060: IBY_PAYGROUP_PUB.pmtTable.attribute13(l_trx_pmt_index) := p_attribute13;
1061: IBY_PAYGROUP_PUB.pmtTable.attribute14(l_trx_pmt_index) := p_attribute14;
1054: IBY_PAYGROUP_PUB.pmtTable.attribute7(l_trx_pmt_index) := p_attribute7;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1060: IBY_PAYGROUP_PUB.pmtTable.attribute13(l_trx_pmt_index) := p_attribute13;
1061: IBY_PAYGROUP_PUB.pmtTable.attribute14(l_trx_pmt_index) := p_attribute14;
1062: IBY_PAYGROUP_PUB.pmtTable.attribute15(l_trx_pmt_index) := p_attribute15;
1055: IBY_PAYGROUP_PUB.pmtTable.attribute8(l_trx_pmt_index) := p_attribute8;
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1060: IBY_PAYGROUP_PUB.pmtTable.attribute13(l_trx_pmt_index) := p_attribute13;
1061: IBY_PAYGROUP_PUB.pmtTable.attribute14(l_trx_pmt_index) := p_attribute14;
1062: IBY_PAYGROUP_PUB.pmtTable.attribute15(l_trx_pmt_index) := p_attribute15;
1063:
1056: IBY_PAYGROUP_PUB.pmtTable.attribute9(l_trx_pmt_index) := p_attribute9;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1060: IBY_PAYGROUP_PUB.pmtTable.attribute13(l_trx_pmt_index) := p_attribute13;
1061: IBY_PAYGROUP_PUB.pmtTable.attribute14(l_trx_pmt_index) := p_attribute14;
1062: IBY_PAYGROUP_PUB.pmtTable.attribute15(l_trx_pmt_index) := p_attribute15;
1063:
1064: END LOOP;
1057: IBY_PAYGROUP_PUB.pmtTable.attribute10(l_trx_pmt_index) := p_attribute10;
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1060: IBY_PAYGROUP_PUB.pmtTable.attribute13(l_trx_pmt_index) := p_attribute13;
1061: IBY_PAYGROUP_PUB.pmtTable.attribute14(l_trx_pmt_index) := p_attribute14;
1062: IBY_PAYGROUP_PUB.pmtTable.attribute15(l_trx_pmt_index) := p_attribute15;
1063:
1064: END LOOP;
1065:
1058: IBY_PAYGROUP_PUB.pmtTable.attribute11(l_trx_pmt_index) := p_attribute11;
1059: IBY_PAYGROUP_PUB.pmtTable.attribute12(l_trx_pmt_index) := p_attribute12;
1060: IBY_PAYGROUP_PUB.pmtTable.attribute13(l_trx_pmt_index) := p_attribute13;
1061: IBY_PAYGROUP_PUB.pmtTable.attribute14(l_trx_pmt_index) := p_attribute14;
1062: IBY_PAYGROUP_PUB.pmtTable.attribute15(l_trx_pmt_index) := p_attribute15;
1063:
1064: END LOOP;
1065:
1066: --l_pmts_tab(l_pmts_tab.COUNT) := l_pmt_rec;
1068: /*
1069: * Insert manual payment into IBY_PAYMENTS_ALL
1070: * table.
1071: */
1072: IBY_PAYGROUP_PUB.insertPayments;
1073:
1074: /*
1075: * Fix for bug 5727990:
1076: *
1076: *
1077: * Invoke auditPaymentData(..) to populate bank
1078: * related information on the payment record.
1079: */
1080: IBY_PAYGROUP_PUB.auditPaymentData(l_trx_pmt_index);
1081:
1082: IBY_PAYGROUP_PUB.updatePayments();
1083:
1084: /*
1078: * related information on the payment record.
1079: */
1080: IBY_PAYGROUP_PUB.auditPaymentData(l_trx_pmt_index);
1081:
1082: IBY_PAYGROUP_PUB.updatePayments();
1083:
1084: /*
1085: * Fix for bug 5337475:
1086: *
1149: print_debuginfo(l_module_name, 'Manual payment '
1150: || 'has been recorded in IBY with payment id '
1151: || l_payment_id
1152: || ' [pmt reference number = '
1153: || IBY_PAYGROUP_PUB.pmtTable.payment_reference_number(l_trx_pmt_index)
1154: || ']'
1155: || ' [paper document number = '
1156: || IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index)
1157: || ']'
1152: || ' [pmt reference number = '
1153: || IBY_PAYGROUP_PUB.pmtTable.payment_reference_number(l_trx_pmt_index)
1154: || ']'
1155: || ' [paper document number = '
1156: || IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index)
1157: || ']'
1158: );
1159:
1160: END IF;
1161: /* return back the payment id to the caller */
1162: x_payment_id := l_payment_id;
1163:
1164: /* Bug 7330978 - return back the payment reference number and paper document number to the caller */
1165: x_pmt_ref_num := IBY_PAYGROUP_PUB.pmtTable.payment_reference_number(l_trx_pmt_index);
1166: x_paper_doc_num := IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index);
1167:
1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1162: x_payment_id := l_payment_id;
1163:
1164: /* Bug 7330978 - return back the payment reference number and paper document number to the caller */
1165: x_pmt_ref_num := IBY_PAYGROUP_PUB.pmtTable.payment_reference_number(l_trx_pmt_index);
1166: x_paper_doc_num := IBY_PAYGROUP_PUB.pmtTable.paper_document_number(l_trx_pmt_index);
1167:
1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1170: /*
1551: || 'for payment request '
1552: || l_payreq_id);
1553:
1554: END IF;
1555: IBY_PAYGROUP_PUB.createPayments(
1556: l_payreq_id,
1557: l_payment_rejection_level,
1558: l_review_proposed_pmts_flag,
1559: p_override_pmt_complete_pt,