eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on PON_EMD_TRANSACTIONS

Line 2001: -- updating results in pon_emd_transactions

1997: IF (x_return_status =FND_API.G_RET_STS_SUCCESS AND
1998: l_deposit_out_record.deposit_trx_number IS NOT NULL AND
1999: l_deposit_out_record.deposit_trx_id IS NOT NULL) THEN
2000:
2001: -- updating results in pon_emd_transactions
2002: UPDATE pon_emd_transactions
2003: SET CUST_TRX_NUMBER = l_deposit_out_record.deposit_trx_number,
2004: CUST_TRX_ID = l_deposit_out_record.deposit_trx_id,
2005: CUST_TRX_LINE_ID = l_deposit_out_record.deposit_trx_line_id,

Line 2002: UPDATE pon_emd_transactions

1998: l_deposit_out_record.deposit_trx_number IS NOT NULL AND
1999: l_deposit_out_record.deposit_trx_id IS NOT NULL) THEN
2000:
2001: -- updating results in pon_emd_transactions
2002: UPDATE pon_emd_transactions
2003: SET CUST_TRX_NUMBER = l_deposit_out_record.deposit_trx_number,
2004: CUST_TRX_ID = l_deposit_out_record.deposit_trx_id,
2005: CUST_TRX_LINE_ID = l_deposit_out_record.deposit_trx_line_id,
2006: POSTED_TO_FINANCE = 'Y',

Line 2157: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;

2153: l_org_return_status VARCHAR2(1);
2154: l_found BOOLEAN;
2155: l_emd_transactions_info pon_emd_trx_rec;
2156:
2157: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2158: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2159: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2160: x_org_id NUMBER;
2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;

Line 2158: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;

2154: l_found BOOLEAN;
2155: l_emd_transactions_info pon_emd_trx_rec;
2156:
2157: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2158: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2159: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2160: x_org_id NUMBER;
2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;

Line 2159: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;

2155: l_emd_transactions_info pon_emd_trx_rec;
2156:
2157: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2158: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2159: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2160: x_org_id NUMBER;
2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2163: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;

Line 2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;

2157: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2158: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2159: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2160: x_org_id NUMBER;
2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2163: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2164:
2165: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;

Line 2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;

2158: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2159: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2160: x_org_id NUMBER;
2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2163: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2164:
2165: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2166: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;

Line 2163: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;

2159: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2160: x_org_id NUMBER;
2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2163: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2164:
2165: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2166: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
2167: x_party_name hz_parties.party_name%TYPE := NULL;

Line 2181: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;
2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2181: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2182: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2183:
2184: l_cm_in_record CM_INFO_IN_RECTYPE;
2185: l_cm_out_record CM_INFO_OUT_RECTYPE;

Line 2182: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;
2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2181: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2182: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2183:
2184: l_cm_in_record CM_INFO_IN_RECTYPE;
2185: l_cm_out_record CM_INFO_OUT_RECTYPE;
2186:

Line 2618: -- Updating results in pon_emd_transactions

2614: END IF;
2615:
2616: l_progress := 230;
2617: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
2618: -- Updating results in pon_emd_transactions
2619: UPDATE pon_emd_transactions
2620: SET CUST_TRX_NUMBER = l_cm_out_record.cm_trx_number,
2621: CUST_TRX_ID = l_cm_out_record.cm_customer_trx_id,
2622: CUST_TRX_LINE_ID = l_cm_out_record.cm_customer_trx_line_id,

Line 2619: UPDATE pon_emd_transactions

2615:
2616: l_progress := 230;
2617: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
2618: -- Updating results in pon_emd_transactions
2619: UPDATE pon_emd_transactions
2620: SET CUST_TRX_NUMBER = l_cm_out_record.cm_trx_number,
2621: CUST_TRX_ID = l_cm_out_record.cm_customer_trx_id,
2622: CUST_TRX_LINE_ID = l_cm_out_record.cm_customer_trx_line_id,
2623: APPLICATION_REF_ID =l_refund_activity_out_rec.APPLICATION_REF_ID,

Line 2774: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;

2770: l_org_return_status VARCHAR2(1);
2771: l_found BOOLEAN;
2772: l_emd_transactions_info pon_emd_trx_rec;
2773:
2774: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2775: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2776: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2777: x_org_id NUMBER;
2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;

Line 2775: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;

2771: l_found BOOLEAN;
2772: l_emd_transactions_info pon_emd_trx_rec;
2773:
2774: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2775: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2776: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2777: x_org_id NUMBER;
2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;

Line 2776: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;

2772: l_emd_transactions_info pon_emd_trx_rec;
2773:
2774: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2775: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2776: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2777: x_org_id NUMBER;
2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;

Line 2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;

2774: x_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2775: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2776: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2777: x_org_id NUMBER;
2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;

Line 2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;

2775: x_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2776: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2777: x_org_id NUMBER;
2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

Line 2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;

2776: x_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2777: x_org_id NUMBER;
2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;

Line 2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2789:
2790: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2791: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;

Line 2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2789:
2790: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2791: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
2792: x_party_name hz_parties.party_name%TYPE := NULL;

Line 4256: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,

4252: --End of Comments
4253: ------------------------------------------------------------------------
4254:
4255: PROCEDURE getTrxInfoFromParentTrx(p_parent_emd_transaction_id IN NUMBER,
4256: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,
4257: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,
4258: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,
4259: x_deposit_payment_type_code OUT NOCOPY VARCHAR2,
4260: x_org_id OUT NOCOPY NUMBER,

Line 4257: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,

4253: ------------------------------------------------------------------------
4254:
4255: PROCEDURE getTrxInfoFromParentTrx(p_parent_emd_transaction_id IN NUMBER,
4256: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,
4257: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,
4258: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,
4259: x_deposit_payment_type_code OUT NOCOPY VARCHAR2,
4260: x_org_id OUT NOCOPY NUMBER,
4261: x_return_status OUT NOCOPY VARCHAR2)

Line 4258: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,

4254:
4255: PROCEDURE getTrxInfoFromParentTrx(p_parent_emd_transaction_id IN NUMBER,
4256: x_parent_trx_number OUT NOCOPY pon_emd_transactions.CUST_TRX_NUMBER%TYPE,
4257: x_parent_trx_id OUT NOCOPY pon_emd_transactions.CUST_TRX_ID%TYPE,
4258: x_parent_trx_line_id OUT NOCOPY pon_emd_transactions.CUST_TRX_LINE_ID%TYPE,
4259: x_deposit_payment_type_code OUT NOCOPY VARCHAR2,
4260: x_org_id OUT NOCOPY NUMBER,
4261: x_return_status OUT NOCOPY VARCHAR2)
4262: IS

Line 4277: FROM pon_emd_transactions

4273: x_parent_trx_id,
4274: x_parent_trx_line_id,
4275: x_org_id,
4276: x_deposit_payment_type_code
4277: FROM pon_emd_transactions
4278: WHERE emd_transaction_id = p_parent_emd_transaction_id;
4279:
4280: EXCEPTION
4281: WHEN No_Data_Found THEN

Line 5458: -- pon_emd_transactions depending on the transaction_type_code when

5454: -----------------------------------------------------------------------
5455: --Start of Comments
5456: --Name: update_emd_trx_error_status
5457: --Description : procedure to update the status_lookup_code in
5458: -- pon_emd_transactions depending on the transaction_type_code when
5459: -- the transaction errors out.
5460: --Pre-reqs:
5461: --Parameters:
5462: --IN: p_emd_transaction_id

Line 5479: UPDATE pon_emd_transactions

5475: IS
5476:
5477: BEGIN
5478:
5479: UPDATE pon_emd_transactions
5480: SET status_lookup_code = Decode(transaction_type_code, G_EMD_DEPOSIT, 'RECEIVE_ERROR',
5481: G_EMD_REFUND, 'REFUND_ERROR',
5482: G_EMD_FORFEIT, 'FORFEIT_ERROR'),
5483: error_message = p_msg_data

Line 5507: UPDATE pon_emd_transactions

5503: ------------------------------------------------------------------------
5504: PROCEDURE update_trx_status_lookup_code(p_emd_transaction_id IN NUMBER)
5505: IS
5506: BEGIN
5507: UPDATE pon_emd_transactions
5508: SET status_lookup_code = Decode(transaction_type_code, G_EMD_DEPOSIT, 'RECEIVING',
5509: G_EMD_REFUND, 'REFUNDING',
5510: G_EMD_FORFEIT, 'FORFEITING'),
5511: error_message = NULL

Line 5887: UPDATE pon_emd_transactions

5883: print_log('l_trx_number'||l_trx_number);
5884:
5885: IF (l_customer_trx_id IS NOT NULL ) THEN
5886: print_log('l_trx_number'||l_trx_number);
5887: UPDATE pon_emd_transactions
5888: SET CUST_TRX_ID =l_customer_trx_id,
5889: CUST_TRX_NUMBER = l_trx_number,
5890: POSTED_TO_FINANCE = 'Y',
5891: STATUS_LOOKUP_CODE = 'FORFEITED'

Line 5926: UPDATE pon_emd_transactions

5922: END IF;
5923: concat_err_msg := concat_err_msg||fnd_global.local_chr(10)||message_text||':'||invalid_value;
5924: END LOOP;
5925: END IF;
5926: UPDATE pon_emd_transactions
5927: SET status_lookup_code = 'FORFEIT_ERROR',
5928: error_message = concat_err_msg
5929: WHERE emd_transaction_id = l_emd_transactions_info.emd_transaction_id
5930: AND emd_transaction_group_id = l_emd_transactions_info.emd_trx_group_id

Line 6062: UPDATE pon_emd_transactions

6058: FOR j IN 1 .. l_emd_transactions.Count
6059: LOOP
6060: BEGIN
6061: l_emd_transactions_info := l_emd_transactions(j);
6062: UPDATE pon_emd_transactions
6063: SET request_id = l_conc_req_id,
6064: requested_by = fnd_global.user_id,
6065: status_lookup_code = 'FORFEITING',
6066: error_message = NULL

Line 6172: UPDATE pon_emd_transactions

6168: FOR j IN 1 .. l_emd_transactions.Count
6169: LOOP
6170: BEGIN
6171: l_emd_transactions_info := l_emd_transactions(j);
6172: UPDATE pon_emd_transactions
6173: SET request_id = l_conc_req_id,
6174: requested_by = fnd_global.user_id,
6175: status_lookup_code = 'REFUNDING',
6176: error_message = NULL