1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1140: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1133: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1140: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1141: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1134: -- this is the allocated receipt amount
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1140: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1141: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1142: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1135: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1140: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1141: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1142: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1143: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1136: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1140: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1141: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1142: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1143: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1144: p_called_from IN VARCHAR2 DEFAULT NULL,
1137: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1138: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1139: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1140: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1141: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
1142: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1143: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1144: p_called_from IN VARCHAR2 DEFAULT NULL,
1145: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1142: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
1143: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
1144: p_called_from IN VARCHAR2 DEFAULT NULL,
1145: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1146: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1147: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1148: -- ******* Global Flexfield parameters *******
1149: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1150: p_comments IN ar_receivable_applications.comments%TYPE,
1146: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1147: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1148: -- ******* Global Flexfield parameters *******
1149: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1150: p_comments IN ar_receivable_applications.comments%TYPE,
1151: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1152: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1147: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1148: -- ******* Global Flexfield parameters *******
1149: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1150: p_comments IN ar_receivable_applications.comments%TYPE,
1151: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1152: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1148: -- ******* Global Flexfield parameters *******
1149: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1150: p_comments IN ar_receivable_applications.comments%TYPE,
1151: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1152: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1156: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1149: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1150: p_comments IN ar_receivable_applications.comments%TYPE,
1151: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1152: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1156: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1157: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1150: p_comments IN ar_receivable_applications.comments%TYPE,
1151: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1152: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1156: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1157: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1158: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1151: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1152: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1156: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1157: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1158: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1159: p_org_id IN NUMBER DEFAULT NULL
1152: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1156: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1157: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1158: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1159: p_org_id IN NUMBER DEFAULT NULL
1160: ) IS
1153: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1156: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1157: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1158: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1159: p_org_id IN NUMBER DEFAULT NULL
1160: ) IS
1161: l_api_name CONSTANT VARCHAR2(20) := 'Apply';
1154: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1155: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1156: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1157: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1158: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1159: p_org_id IN NUMBER DEFAULT NULL
1160: ) IS
1161: l_api_name CONSTANT VARCHAR2(20) := 'Apply';
1162: l_api_version CONSTANT NUMBER := 1.0;
1208: l_global_attribute_rec global_attribute_rec_type;
1209: l_remit_bank_acct_use_id NUMBER;
1210: l_receipt_method_id NUMBER;
1211: l_gdflex_return_status VARCHAR2(1);
1212: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
1213: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1214: l_return_status VARCHAR2(1);
1215: l_msg_count NUMBER;
1216: l_msg_data VARCHAR2(2000);
1209: l_remit_bank_acct_use_id NUMBER;
1210: l_receipt_method_id NUMBER;
1211: l_gdflex_return_status VARCHAR2(1);
1212: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
1213: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1214: l_return_status VARCHAR2(1);
1215: l_msg_count NUMBER;
1216: l_msg_data VARCHAR2(2000);
1217: l_payment_set_id NUMBER;
1511:
1512: --validate and default the flexfields
1513: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
1514: l_attribute_rec,
1515: 'AR_RECEIVABLE_APPLICATIONS',
1516: l_dflex_val_return_status
1517: );
1518:
1519:
1517: );
1518:
1519:
1520: --default and validate the global descriptive flexfield
1521: jg_ar_receivable_applications.apply(
1522: p_apply_before_after => 'BEFORE',
1523: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
1524: p_set_of_books_id => arp_global.set_of_books_id,
1525: p_cash_receipt_id => l_cash_receipt_id,
1725: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1727: END IF;
1728:
1729: jg_ar_receivable_applications.apply(
1730: p_apply_before_after => 'AFTER',
1731: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
1732: p_set_of_books_id => null,
1733: p_cash_receipt_id => null,
1883: -- LLCA Parameters
1884: p_llca_type IN VARCHAR2 DEFAULT 'S',
1885: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1886: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1887: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1888: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1889: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1890: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1891: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1884: p_llca_type IN VARCHAR2 DEFAULT 'S',
1885: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1886: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1887: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1888: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1889: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1890: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1891: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1892: p_line_discount IN NUMBER DEFAULT NULL,
1885: p_llca_trx_lines_tbl IN llca_trx_lines_tbl_type DEFAULT llca_def_trx_lines_tbl_type,
1886: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1887: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1888: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1889: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1890: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1891: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1892: p_line_discount IN NUMBER DEFAULT NULL,
1893: p_tax_discount IN NUMBER DEFAULT NULL,
1886: p_group_id IN VARCHAR2 DEFAULT NULL, /* Bug 5284890 */
1887: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1888: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1889: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1890: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1891: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1892: p_line_discount IN NUMBER DEFAULT NULL,
1893: p_tax_discount IN NUMBER DEFAULT NULL,
1894: p_freight_discount IN NUMBER DEFAULT NULL,
1887: p_line_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1888: p_tax_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1889: p_freight_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1890: p_charges_amount IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1891: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1892: p_line_discount IN NUMBER DEFAULT NULL,
1893: p_tax_discount IN NUMBER DEFAULT NULL,
1894: p_freight_discount IN NUMBER DEFAULT NULL,
1895: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1891: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1892: p_line_discount IN NUMBER DEFAULT NULL,
1893: p_tax_discount IN NUMBER DEFAULT NULL,
1894: p_freight_discount IN NUMBER DEFAULT NULL,
1895: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1896: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1897: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1898: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1899: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1892: p_line_discount IN NUMBER DEFAULT NULL,
1893: p_tax_discount IN NUMBER DEFAULT NULL,
1894: p_freight_discount IN NUMBER DEFAULT NULL,
1895: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1896: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1897: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1898: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1899: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1900: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1893: p_tax_discount IN NUMBER DEFAULT NULL,
1894: p_freight_discount IN NUMBER DEFAULT NULL,
1895: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1896: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1897: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1898: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1899: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1900: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1901: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1894: p_freight_discount IN NUMBER DEFAULT NULL,
1895: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1896: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1897: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1898: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1899: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1900: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1901: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1902: p_called_from IN VARCHAR2 DEFAULT NULL,
1895: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
1896: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1897: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1898: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1899: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1900: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1901: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1902: p_called_from IN VARCHAR2 DEFAULT NULL,
1903: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1896: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
1897: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
1898: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1899: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1900: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1901: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1902: p_called_from IN VARCHAR2 DEFAULT NULL,
1903: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1904: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1900: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
1901: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N',
1902: p_called_from IN VARCHAR2 DEFAULT NULL,
1903: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
1904: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1905: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1906: -- ******* Global Flexfield parameters *******
1907: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1908: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1904: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
1905: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1906: -- ******* Global Flexfield parameters *******
1907: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1908: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1909: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1910: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1905: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1906: -- ******* Global Flexfield parameters *******
1907: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1908: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1909: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1910: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1906: -- ******* Global Flexfield parameters *******
1907: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1908: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1909: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1910: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1914: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1907: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
1908: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1909: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1910: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1914: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1915: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1908: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
1909: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1910: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1914: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1915: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1916: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1909: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
1910: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1914: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1915: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1916: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1917: p_org_id IN NUMBER DEFAULT NULL,
1910: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1914: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1915: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1916: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1917: p_org_id IN NUMBER DEFAULT NULL,
1918: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
1911: p_application_ref_id IN ar_receivable_applications.application_ref_id%TYPE DEFAULT NULL,
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1914: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1915: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1916: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1917: p_org_id IN NUMBER DEFAULT NULL,
1918: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
1919: ) IS
1912: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE DEFAULT NULL,
1913: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
1914: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
1915: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
1916: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
1917: p_org_id IN NUMBER DEFAULT NULL,
1918: p_line_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const
1919: ) IS
1920:
1974: l_global_attribute_rec global_attribute_rec_type;
1975: l_remit_bank_acct_use_id NUMBER;
1976: l_receipt_method_id NUMBER;
1977: l_gdflex_return_status VARCHAR2(1);
1978: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
1979: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1980: l_return_status VARCHAR2(1);
1981: l_msg_count NUMBER;
1982: l_msg_data VARCHAR2(2000);
1975: l_remit_bank_acct_use_id NUMBER;
1976: l_receipt_method_id NUMBER;
1977: l_gdflex_return_status VARCHAR2(1);
1978: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
1979: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
1980: l_return_status VARCHAR2(1);
1981: l_msg_count NUMBER;
1982: l_msg_data VARCHAR2(2000);
1983: l_payment_set_id NUMBER;
2009: l_llca_app_msg_count NUMBER;
2010: lfc_msg_data VARCHAR2(2000);
2011: lfc_return_status VARCHAR2(1);
2012: lfc_msg_count NUMBER;
2013: llca_ra_rec ar_receivable_applications%rowtype;
2014: l_llca_trx_lines_tbl llca_trx_lines_tbl_type;
2015: l_line_number NUMBER;
2016: l_count NUMBER;
2017: l_ad_dflex_val_return_status VARCHAR2(1);
2367:
2368: --validate and default the flexfields
2369: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
2370: l_attribute_rec,
2371: 'AR_RECEIVABLE_APPLICATIONS',
2372: l_dflex_val_return_status
2373: );
2374:
2375: IF PG_DEBUG in ('Y', 'C') THEN
2502:
2503:
2504:
2505: --default and validate the global descriptive flexfield
2506: jg_ar_receivable_applications.apply(
2507: p_apply_before_after => 'BEFORE',
2508: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
2509: p_set_of_books_id => arp_global.set_of_books_id,
2510: p_cash_receipt_id => l_cash_receipt_id,
2712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2714: END IF;
2715:
2716: jg_ar_receivable_applications.apply(
2717: p_apply_before_after => 'AFTER',
2718: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
2719: p_set_of_books_id => null,
2720: p_cash_receipt_id => null,
2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2885: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2886: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2887: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2888: p_called_from IN VARCHAR2 DEFAULT NULL,
2889: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
2890: p_org_id IN NUMBER DEFAULT NULL
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2885: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2886: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
2887: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
2888: p_called_from IN VARCHAR2 DEFAULT NULL,
2889: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
2890: p_org_id IN NUMBER DEFAULT NULL
2891: ) IS
3027: amount_applied
3028: INTO l_application_ref_type,
3029: l_secondary_app_ref_id,
3030: l_amount_applied
3031: FROM ar_receivable_applications
3032: WHERE receivable_application_id = l_receivable_application_id;
3033: IF (l_application_ref_type = 'CLAIM' AND
3034: NVL(p_called_from,'RAPI') <> 'TRADE_MANAGEMENT')
3035: THEN
3047: IF PG_DEBUG in ('Y', 'C') THEN
3048: arp_util.debug('Apply: ' || 'validation return status :'||l_val_return_status);
3049: END IF;
3050:
3051: jg_ar_receivable_applications.Unapply(
3052: l_cash_receipt_id,
3053: l_applied_payment_schedule_id,
3054: l_glob_return_status );
3055: --
4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4646: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4647: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4648: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4647: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4648: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4648: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4656: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4649: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4656: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4657: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4650: -- this is the allocated receipt amount
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4656: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4657: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4658: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4651: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4656: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4657: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4658: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4659: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4652: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4656: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4657: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4658: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4659: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4660: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
4653: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
4654: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4655: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4656: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4657: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4658: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4659: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4660: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
4661: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
4657: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
4658: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
4659: p_show_closed_invoices IN VARCHAR2 DEFAULT 'N', /* Bug fix 2462013 */
4660: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
4661: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
4662: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4663: -- ******* Global Flexfield parameters *******
4664: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4665: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
4661: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
4662: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4663: -- ******* Global Flexfield parameters *******
4664: app_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4665: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
4666: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4667: p_org_id IN NUMBER DEFAULT NULL
4668: ) IS
4669: l_cash_receipt_id NUMBER(15);
4972: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4973: -- ** OUT NOCOPY variables for Creating receipt
4974: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4975: -- Receipt application parameters
4976: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4977: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4978: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4979: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4980: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4973: -- ** OUT NOCOPY variables for Creating receipt
4974: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4975: -- Receipt application parameters
4976: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4977: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4978: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4979: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4980: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4981: -- ******* Global Flexfield parameters *******
4974: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4975: -- Receipt application parameters
4976: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4977: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4978: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4979: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4980: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4981: -- ******* Global Flexfield parameters *******
4982: app_global_attribute_rec IN global_attribute_rec_type
4975: -- Receipt application parameters
4976: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4977: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4978: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4979: app_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
4980: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4981: -- ******* Global Flexfield parameters *******
4982: app_global_attribute_rec IN global_attribute_rec_type
4983: DEFAULT global_attribute_rec_const,
4980: app_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4981: -- ******* Global Flexfield parameters *******
4982: app_global_attribute_rec IN global_attribute_rec_type
4983: DEFAULT global_attribute_rec_const,
4984: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
4985: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4986: DEFAULT NULL,
4987: p_secondary_application_ref_id IN
4988: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
4981: -- ******* Global Flexfield parameters *******
4982: app_global_attribute_rec IN global_attribute_rec_type
4983: DEFAULT global_attribute_rec_const,
4984: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
4985: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4986: DEFAULT NULL,
4987: p_secondary_application_ref_id IN
4988: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
4989: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4984: app_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
4985: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4986: DEFAULT NULL,
4987: p_secondary_application_ref_id IN
4988: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
4989: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4990: DEFAULT NULL,
4991: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
4992: p_secondary_app_ref_type IN
4985: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE
4986: DEFAULT NULL,
4987: p_secondary_application_ref_id IN
4988: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
4989: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4990: DEFAULT NULL,
4991: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
4992: p_secondary_app_ref_type IN
4993: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
4987: p_secondary_application_ref_id IN
4988: ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
4989: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4990: DEFAULT NULL,
4991: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
4992: p_secondary_app_ref_type IN
4993: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
4994: p_secondary_app_ref_num IN
4995: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
4989: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE
4990: DEFAULT NULL,
4991: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
4992: p_secondary_app_ref_type IN
4993: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
4994: p_secondary_app_ref_num IN
4995: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
4996:
4997: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4991: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
4992: p_secondary_app_ref_type IN
4993: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
4994: p_secondary_app_ref_num IN
4995: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
4996:
4997: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4998: p_org_id IN NUMBER DEFAULT NULL
4999: ) IS
5952: x_msg_data OUT NOCOPY VARCHAR2,
5953: -- Receipt application parameters.
5954: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5955: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5956: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5957: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5958: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5959: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5960: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5953: -- Receipt application parameters.
5954: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5955: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5956: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5957: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5958: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5959: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5960: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5961: -- ******* Global Flexfield parameters *******
5954: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5955: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5956: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5957: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5958: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5959: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5960: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5961: -- ******* Global Flexfield parameters *******
5962: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5955: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5956: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5957: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5958: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5959: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5960: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5961: -- ******* Global Flexfield parameters *******
5962: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5963: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5959: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
5960: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5961: -- ******* Global Flexfield parameters *******
5962: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5963: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5964: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
5965: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
5966: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5967: p_called_from IN VARCHAR2,
5960: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5961: -- ******* Global Flexfield parameters *******
5962: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5963: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5964: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
5965: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
5966: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5967: p_called_from IN VARCHAR2,
5968: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
5961: -- ******* Global Flexfield parameters *******
5962: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5963: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5964: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
5965: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
5966: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5967: p_called_from IN VARCHAR2,
5968: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
5969: p_secondary_app_ref_type IN
5962: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5963: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
5964: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
5965: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
5966: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5967: p_called_from IN VARCHAR2,
5968: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
5969: p_secondary_app_ref_type IN
5970: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5964: p_application_ref_num IN ar_receivable_applications.application_ref_num%TYPE,
5965: p_secondary_application_ref_id IN ar_receivable_applications.secondary_application_ref_id%TYPE,
5966: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5967: p_called_from IN VARCHAR2,
5968: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
5969: p_secondary_app_ref_type IN
5970: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5971: p_secondary_app_ref_num IN
5972: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5966: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
5967: p_called_from IN VARCHAR2,
5968: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
5969: p_secondary_app_ref_type IN
5970: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5971: p_secondary_app_ref_num IN
5972: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5973: p_org_id IN NUMBER DEFAULT NULL
5974: ) IS
5968: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,
5969: p_secondary_app_ref_type IN
5970: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
5971: p_secondary_app_ref_num IN
5972: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
5973: p_org_id IN NUMBER DEFAULT NULL
5974: ) IS
5975: l_api_name CONSTANT VARCHAR2(20) := 'Apply_on_acount';
5976: l_api_version CONSTANT NUMBER := 1.0;
6123:
6124: --validate and default the flexfields
6125: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
6126: l_attribute_rec,
6127: 'AR_RECEIVABLE_APPLICATIONS',
6128: l_dflex_val_return_status
6129: );
6130:
6131: IF PG_DEBUG in ('Y', 'C') THEN
6378: x_msg_data OUT NOCOPY VARCHAR2 ,
6379: -- *** Receipt Info. parameters *****
6380: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6381: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6382: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6383: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6384: p_org_id IN NUMBER DEFAULT NULL
6385: ) IS
6386: l_api_name CONSTANT VARCHAR2(20) := 'Unapply_on_account';
6379: -- *** Receipt Info. parameters *****
6380: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6381: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6382: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6383: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6384: p_org_id IN NUMBER DEFAULT NULL
6385: ) IS
6386: l_api_name CONSTANT VARCHAR2(20) := 'Unapply_on_account';
6387: l_api_version CONSTANT NUMBER := 1.0;
6686: x_msg_data OUT NOCOPY VARCHAR2 ,
6687: -- *** Receipt Info. parameters *****
6688: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6689: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6690: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6691: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6692: p_cancel_claim_flag IN VARCHAR2,
6693: p_called_from IN VARCHAR2,
6694: p_org_id IN NUMBER DEFAULT NULL
6687: -- *** Receipt Info. parameters *****
6688: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6689: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6690: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6691: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6692: p_cancel_claim_flag IN VARCHAR2,
6693: p_called_from IN VARCHAR2,
6694: p_org_id IN NUMBER DEFAULT NULL
6695: ) IS
6788: , amount_applied
6789: INTO l_applied_ps_id
6790: , l_sec_app_ref_id
6791: , l_amount_applied
6792: FROM ar_receivable_applications
6793: WHERE receivable_application_id = p_receivable_application_id;
6794:
6795: /*------------------------------------------------+
6796: | Derive the id's for the entered values. |
7058: x_msg_data OUT NOCOPY VARCHAR2,
7059: -- Receipt application parameters.
7060: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7061: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7062: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7066: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7061: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7062: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7066: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7067: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7068: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7069: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7062: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7066: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7067: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7068: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7069: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7070: -- ******* Global Flexfield parameters *******
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7066: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7067: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7068: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7069: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7070: -- ******* Global Flexfield parameters *******
7071: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7066: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
7067: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
7068: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7069: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7070: -- ******* Global Flexfield parameters *******
7071: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
7072: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
7068: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
7069: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
7070: -- ******* Global Flexfield parameters *******
7071: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
7072: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
7073: p_application_ref_type IN OUT NOCOPY
7074: ar_receivable_applications.application_ref_type%TYPE,
7075: p_application_ref_id IN OUT NOCOPY
7076: ar_receivable_applications.application_ref_id%TYPE,
7070: -- ******* Global Flexfield parameters *******
7071: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
7072: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
7073: p_application_ref_type IN OUT NOCOPY
7074: ar_receivable_applications.application_ref_type%TYPE,
7075: p_application_ref_id IN OUT NOCOPY
7076: ar_receivable_applications.application_ref_id%TYPE,
7077: p_application_ref_num IN OUT NOCOPY
7078: ar_receivable_applications.application_ref_num%TYPE,
7072: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
7073: p_application_ref_type IN OUT NOCOPY
7074: ar_receivable_applications.application_ref_type%TYPE,
7075: p_application_ref_id IN OUT NOCOPY
7076: ar_receivable_applications.application_ref_id%TYPE,
7077: p_application_ref_num IN OUT NOCOPY
7078: ar_receivable_applications.application_ref_num%TYPE,
7079: p_secondary_application_ref_id IN OUT NOCOPY
7080: ar_receivable_applications.secondary_application_ref_id%TYPE,
7074: ar_receivable_applications.application_ref_type%TYPE,
7075: p_application_ref_id IN OUT NOCOPY
7076: ar_receivable_applications.application_ref_id%TYPE,
7077: p_application_ref_num IN OUT NOCOPY
7078: ar_receivable_applications.application_ref_num%TYPE,
7079: p_secondary_application_ref_id IN OUT NOCOPY
7080: ar_receivable_applications.secondary_application_ref_id%TYPE,
7081: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7082: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7076: ar_receivable_applications.application_ref_id%TYPE,
7077: p_application_ref_num IN OUT NOCOPY
7078: ar_receivable_applications.application_ref_num%TYPE,
7079: p_secondary_application_ref_id IN OUT NOCOPY
7080: ar_receivable_applications.secondary_application_ref_id%TYPE,
7081: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7082: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7083: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7084: p_val_writeoff_limits_flag IN VARCHAR2,
7077: p_application_ref_num IN OUT NOCOPY
7078: ar_receivable_applications.application_ref_num%TYPE,
7079: p_secondary_application_ref_id IN OUT NOCOPY
7080: ar_receivable_applications.secondary_application_ref_id%TYPE,
7081: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7082: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7083: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7084: p_val_writeoff_limits_flag IN VARCHAR2,
7085: p_called_from IN VARCHAR2,
7078: ar_receivable_applications.application_ref_num%TYPE,
7079: p_secondary_application_ref_id IN OUT NOCOPY
7080: ar_receivable_applications.secondary_application_ref_id%TYPE,
7081: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7082: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7083: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7084: p_val_writeoff_limits_flag IN VARCHAR2,
7085: p_called_from IN VARCHAR2,
7086: p_netted_receipt_flag IN VARCHAR2,
7079: p_secondary_application_ref_id IN OUT NOCOPY
7080: ar_receivable_applications.secondary_application_ref_id%TYPE,
7081: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
7082: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
7083: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7084: p_val_writeoff_limits_flag IN VARCHAR2,
7085: p_called_from IN VARCHAR2,
7086: p_netted_receipt_flag IN VARCHAR2,
7087: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
7085: p_called_from IN VARCHAR2,
7086: p_netted_receipt_flag IN VARCHAR2,
7087: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
7088: p_secondary_app_ref_type IN
7089: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
7090: p_secondary_app_ref_num IN
7091: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7092: p_org_id IN NUMBER DEFAULT NULL,
7093: p_customer_reason IN
7087: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
7088: p_secondary_app_ref_type IN
7089: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
7090: p_secondary_app_ref_num IN
7091: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7092: p_org_id IN NUMBER DEFAULT NULL,
7093: p_customer_reason IN
7094: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
7095: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE
7090: p_secondary_app_ref_num IN
7091: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7092: p_org_id IN NUMBER DEFAULT NULL,
7093: p_customer_reason IN
7094: ar_receivable_applications.customer_reason%TYPE DEFAULT NULL
7095: ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE
7096: ,p_pay_alone_flag IN VARCHAR2
7097: ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE
7098: ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE
7120: ln_rec_application_id NUMBER;
7121: l_cr_date DATE;
7122: l_cr_payment_schedule_id NUMBER;
7123: l_cr_currency_code VARCHAR2(15);
7124: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7125: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7126: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7127: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7128: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7121: l_cr_date DATE;
7122: l_cr_payment_schedule_id NUMBER;
7123: l_cr_currency_code VARCHAR2(15);
7124: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7125: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7126: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7127: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7128: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7129: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7122: l_cr_payment_schedule_id NUMBER;
7123: l_cr_currency_code VARCHAR2(15);
7124: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7125: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7126: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7127: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7128: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7129: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7130: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7123: l_cr_currency_code VARCHAR2(15);
7124: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7125: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7126: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7127: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7128: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7129: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7130: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7131: l_acctd_amount_applied_from NUMBER;
7124: l_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
7125: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7126: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7127: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7128: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7129: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7130: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7131: l_acctd_amount_applied_from NUMBER;
7132: l_acctd_amount_applied_to NUMBER;
7125: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7126: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7127: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7128: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7129: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7130: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7131: l_acctd_amount_applied_from NUMBER;
7132: l_acctd_amount_applied_to NUMBER;
7133: l_org_return_status VARCHAR2(1);
7126: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
7127: l_secondary_application_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
7128: l_secondary_app_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE;
7129: l_secondary_app_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE;
7130: l_payment_set_id ar_receivable_applications.payment_set_id%TYPE;
7131: l_acctd_amount_applied_from NUMBER;
7132: l_acctd_amount_applied_to NUMBER;
7133: l_org_return_status VARCHAR2(1);
7134: l_org_id NUMBER;
7669: x_msg_data OUT NOCOPY VARCHAR2 ,
7670: -- *** Receipt Info. parameters *****
7671: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7672: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7673: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
7674: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
7675: p_called_from IN VARCHAR2,
7676: p_org_id IN NUMBER DEFAULT NULL
7677: ) IS
7670: -- *** Receipt Info. parameters *****
7671: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7672: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7673: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
7674: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
7675: p_called_from IN VARCHAR2,
7676: p_org_id IN NUMBER DEFAULT NULL
7677: ) IS
7678: l_api_name CONSTANT VARCHAR2(20) := 'Activity_unapp';
7688: l_bal_due_remaining NUMBER;
7689: l_org_return_status VARCHAR2(1);
7690: l_org_id NUMBER;
7691: l_cr_unapp_amt NUMBER; /* Bug fix 3569640 */
7692: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
7693: l_applied_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
7694: l_refund_return_status VARCHAR2(1);
7695: BEGIN
7696: /*------------------------------------+
7805:
7806: /* Refunds - check for refund and cancel if refund application */
7807: SELECT applied_payment_schedule_id, application_ref_id
7808: INTO l_applied_ps_id, l_application_ref_id
7809: FROM ar_receivable_applications
7810: WHERE receivable_application_id = l_receivable_application_id;
7811:
7812: IF (l_applied_ps_id = -8 AND p_called_from <> 'AR_REFUNDS_GRP') THEN
7813: ar_refunds_pvt.cancel_refund(
8005: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8006: x_return_status OUT NOCOPY VARCHAR2,
8007: x_msg_count OUT NOCOPY NUMBER,
8008: x_msg_data OUT NOCOPY VARCHAR2,
8009: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8010: -- Receipt application parameters.
8011: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8012: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8009: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8010: -- Receipt application parameters.
8011: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8012: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8010: -- Receipt application parameters.
8011: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8012: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8011: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8012: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8012: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8021: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8021: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8022: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8021: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8022: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8023: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8021: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8022: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8023: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8024: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8017: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8021: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8022: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8023: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8024: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8025: -- ******* Global Flexfield parameters *******
8018: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8021: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8022: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8023: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8024: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8025: -- ******* Global Flexfield parameters *******
8026: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8019: p_application_ref_type IN ar_receivable_applications.application_ref_type%TYPE DEFAULT NULL,
8020: p_application_ref_id IN OUT NOCOPY ar_receivable_applications.application_ref_id%TYPE ,
8021: p_application_ref_num IN OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE ,
8022: p_secondary_application_ref_id IN OUT NOCOPY ar_receivable_applications.secondary_application_ref_id%TYPE ,
8023: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8024: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8025: -- ******* Global Flexfield parameters *******
8026: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8027: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8023: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE DEFAULT NULL,
8024: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8025: -- ******* Global Flexfield parameters *******
8026: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8027: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8028: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8029: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8030: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8031: p_called_from IN VARCHAR2,
8024: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
8025: -- ******* Global Flexfield parameters *******
8026: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8027: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8028: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8029: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8030: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8031: p_called_from IN VARCHAR2,
8032: p_org_id IN NUMBER DEFAULT NULL
8025: -- ******* Global Flexfield parameters *******
8026: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8027: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8028: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8029: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8030: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8031: p_called_from IN VARCHAR2,
8032: p_org_id IN NUMBER DEFAULT NULL
8033: ) IS
8026: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
8027: p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
8028: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
8029: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
8030: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
8031: p_called_from IN VARCHAR2,
8032: p_org_id IN NUMBER DEFAULT NULL
8033: ) IS
8034: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Other_account';
8049: l_dflex_val_return_status VARCHAR2(1);
8050: l_attribute_rec attribute_rec_type;
8051: l_cr_currency_code VARCHAR2(15);
8052: l_receivables_trx_id NUMBER;
8053: l_applied_payment_schedule_id ar_receivable_applications.applied_payment_schedule_id%TYPE;
8054: l_gdflex_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
8055: l_global_attribute_rec global_attribute_rec_type;
8056:
8057: -- Bug # 2707702
8054: l_gdflex_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
8055: l_global_attribute_rec global_attribute_rec_type;
8056:
8057: -- Bug # 2707702
8058: l_temp_ref_id ar_receivable_applications.application_ref_id%TYPE;
8059: l_temp_ref_num ar_receivable_applications.application_ref_num%TYPE;
8060: l_claim_reason_name VARCHAR2(100);
8061: l_org_return_status VARCHAR2(1);
8062: l_org_id NUMBER;
8055: l_global_attribute_rec global_attribute_rec_type;
8056:
8057: -- Bug # 2707702
8058: l_temp_ref_id ar_receivable_applications.application_ref_id%TYPE;
8059: l_temp_ref_num ar_receivable_applications.application_ref_num%TYPE;
8060: l_claim_reason_name VARCHAR2(100);
8061: l_org_return_status VARCHAR2(1);
8062: l_org_id NUMBER;
8063:
8209:
8210: --validate and default the flexfields
8211: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
8212: l_attribute_rec,
8213: 'AR_RECEIVABLE_APPLICATIONS',
8214: l_dflex_val_return_status
8215: );
8216: arp_util.debug('Desc flexfield Validation return status :'||l_dflex_val_return_status);
8217:
8215: );
8216: arp_util.debug('Desc flexfield Validation return status :'||l_dflex_val_return_status);
8217:
8218: --default and validate the global descriptive flexfield
8219: jg_ar_receivable_applications.apply(
8220: p_apply_before_after => 'BEFORE',
8221: p_global_attribute_category => l_global_attribute_rec.global_attribute_category,
8222: p_set_of_books_id => arp_global.set_of_books_id,
8223: p_cash_receipt_id => l_cash_receipt_id,
9309: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9315: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9316: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9317: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9315: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9316: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9317: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9318: p_called_from IN VARCHAR2 ,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9315: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9316: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9317: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9318: p_called_from IN VARCHAR2 ,
9319: p_attribute_rec IN attribute_rec_type,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9315: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9316: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9317: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9318: p_called_from IN VARCHAR2 ,
9319: p_attribute_rec IN attribute_rec_type,
9320: -- ******* Global Flexfield parameters *******
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9315: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9316: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9317: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,
9318: p_called_from IN VARCHAR2 ,
9319: p_attribute_rec IN attribute_rec_type,
9320: -- ******* Global Flexfield parameters *******
9321: p_global_attribute_rec IN global_attribute_rec_type,
9318: p_called_from IN VARCHAR2 ,
9319: p_attribute_rec IN attribute_rec_type,
9320: -- ******* Global Flexfield parameters *******
9321: p_global_attribute_rec IN global_attribute_rec_type,
9322: p_comments IN ar_receivable_applications.comments%TYPE,
9323: p_org_id IN NUMBER DEFAULT NULL,
9324: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9325: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9326: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9320: -- ******* Global Flexfield parameters *******
9321: p_global_attribute_rec IN global_attribute_rec_type,
9322: p_comments IN ar_receivable_applications.comments%TYPE,
9323: p_org_id IN NUMBER DEFAULT NULL,
9324: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9325: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9326: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9327: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9328: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9321: p_global_attribute_rec IN global_attribute_rec_type,
9322: p_comments IN ar_receivable_applications.comments%TYPE,
9323: p_org_id IN NUMBER DEFAULT NULL,
9324: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9325: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9326: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9327: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9328: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9329: ) IS
9322: p_comments IN ar_receivable_applications.comments%TYPE,
9323: p_org_id IN NUMBER DEFAULT NULL,
9324: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9325: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9326: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9327: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9328: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9329: ) IS
9330: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9323: p_org_id IN NUMBER DEFAULT NULL,
9324: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9325: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9326: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9327: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9328: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9329: ) IS
9330: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9331: l_api_version CONSTANT NUMBER := 1.0;
9324: x_application_ref_num OUT NOCOPY ar_receivable_applications.application_ref_num%TYPE,
9325: x_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9326: x_applied_rec_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
9327: x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
9328: x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE
9329: ) IS
9330: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9331: l_api_version CONSTANT NUMBER := 1.0;
9332: l_cash_receipt_id NUMBER;
9333: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9334: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9335: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9336: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9337: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9338: l_cr_gl_date DATE;
9339: l_open_cr_gl_date DATE;
9340: l_cr_date DATE;
9341: l_last_receipt_date DATE;
9361: l_attribute_rec attribute_rec_type;
9362: l_global_attribute_rec global_attribute_rec_type;
9363: l_remi_bank_acct_use_id NUMBER;
9364: l_receipt_method_id NUMBER;
9365: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9366: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9367: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9362: l_global_attribute_rec global_attribute_rec_type;
9363: l_remi_bank_acct_use_id NUMBER;
9364: l_receipt_method_id NUMBER;
9365: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9366: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9367: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9363: l_remi_bank_acct_use_id NUMBER;
9364: l_receipt_method_id NUMBER;
9365: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9366: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9367: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9364: l_receipt_method_id NUMBER;
9365: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9366: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9367: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9372: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9365: l_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9366: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9367: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9372: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9373: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9366: l_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9367: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9372: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9373: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9374: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9367: l_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9372: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9373: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9374: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9375: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9368: l_application_ref_reason ar_receivable_applications.application_ref_reason%TYPE;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9372: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9373: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9374: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9375: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9376: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9369: l_customer_reference ar_receivable_applications.customer_reference%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9372: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9373: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9374: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9375: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9376: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9377: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9370: l_customer_reason ar_receivable_applications.customer_reason%TYPE;
9371: l_act_application_ref_id ar_receivable_applications.application_ref_id%TYPE;
9372: l_act_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
9373: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9374: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9375: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9376: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9377: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9378: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9373: l_act_application_ref_type ar_receivable_applications.application_ref_type%TYPE;
9374: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9375: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9376: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9377: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9378: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9379: l_open_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9380: l_return_status VARCHAR2(1);
9381: l_msg_count NUMBER;
9374: l_act_secondary_app_ref_id ar_receivable_applications.secondary_application_ref_id%TYPE;
9375: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9376: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9377: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9378: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9379: l_open_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9380: l_return_status VARCHAR2(1);
9381: l_msg_count NUMBER;
9382: l_reapply_msg_count NUMBER;
9375: l_reapply_rec_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
9376: l_netting_rec_trx_id CONSTANT ar_receivables_trx.receivables_trx_id%TYPE := -16;
9377: l_reapply_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9378: l_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9379: l_open_net_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9380: l_return_status VARCHAR2(1);
9381: l_msg_count NUMBER;
9382: l_reapply_msg_count NUMBER;
9383: l_unapply_msg_count NUMBER;
9385: l_act2_msg_count NUMBER;
9386: l_msg_data VARCHAR2(2000);
9387: l_called_from VARCHAR2(100);
9388:
9389: l_app_rec ar_receivable_applications%ROWTYPE;
9390: l_org_return_status VARCHAR2(1);
9391: l_org_id NUMBER;
9392:
9393: BEGIN
9538:
9539: --validate and default the flexfields
9540: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
9541: l_attribute_rec,
9542: 'AR_RECEIVABLE_APPLICATIONS',
9543: l_dflex_val_return_status
9544: );
9545:
9546: arp_util.debug('*****DUMPING ALL THE ENTITY HANDLER PARAMETERS ***');
9939: p_validation_level IN NUMBER,
9940: x_return_status OUT NOCOPY VARCHAR2 ,
9941: x_msg_count OUT NOCOPY NUMBER ,
9942: x_msg_data OUT NOCOPY VARCHAR2 ,
9943: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
9944: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
9945: p_called_from IN VARCHAR2,
9946: p_org_id IN NUMBER DEFAULT NULL
9947: ) IS
9940: x_return_status OUT NOCOPY VARCHAR2 ,
9941: x_msg_count OUT NOCOPY NUMBER ,
9942: x_msg_data OUT NOCOPY VARCHAR2 ,
9943: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
9944: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
9945: p_called_from IN VARCHAR2,
9946: p_org_id IN NUMBER DEFAULT NULL
9947: ) IS
9948: