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.IBY_BANKACCXFR_PUB dependencies on IBY_NETUTILS_PVT

Line 72: l_names IBY_NETUTILS_PVT.v240_tbl_type;

68:
69: l_url VARCHAR2(30000) ;
70: l_html VARCHAR2(32767) ;
71:
72: l_names IBY_NETUTILS_PVT.v240_tbl_type;
73: l_values IBY_NETUTILS_PVT.v240_tbl_type;
74:
75: --The following 3 variables are meant for output of
76: --unpack_results_url procedure.

Line 73: l_values IBY_NETUTILS_PVT.v240_tbl_type;

69: l_url VARCHAR2(30000) ;
70: l_html VARCHAR2(32767) ;
71:
72: l_names IBY_NETUTILS_PVT.v240_tbl_type;
73: l_values IBY_NETUTILS_PVT.v240_tbl_type;
74:
75: --The following 3 variables are meant for output of
76: --unpack_results_url procedure.
77: l_status NUMBER := 0;

Line 138: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);

134:
135: -----------------------
136: -- get iPayment URL
137: -----------------------
138: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
139: l_url := l_get_baseurl;
140: l_url := rtrim(l_url,'?');
141:
142: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();

Line 142: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();

138: IBY_NETUTILS_PVT.get_baseurl(l_get_baseurl);
139: l_url := l_get_baseurl;
140: l_url := rtrim(l_url,'?');
141:
142: l_db_nls := IBY_NETUTILS_PVT.get_local_nls();
143: l_ecapp_nls := NULL; -- not passed in this api??
144:
145: -------------------------
146: -- create temporary clob

Line 153: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_post_body, l_db_nls, l_ecapp_nls);

149:
150: -----------------------------
151: -- reading header level data
152: -----------------------------
153: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_post_body, l_db_nls, l_ecapp_nls);
154: IBY_NETUTILS_PVT.check_mandatory('OapfECAppId', to_char(p_ecapp_id), l_post_body, l_db_nls, l_ecapp_nls);
155: -- Payee ID
156: IBY_NETUTILS_PVT.check_mandatory('OapfStoreId', p_payee_ID, l_post_body, l_db_nls, l_ecapp_nls);
157:

Line 154: IBY_NETUTILS_PVT.check_mandatory('OapfECAppId', to_char(p_ecapp_id), l_post_body, l_db_nls, l_ecapp_nls);

150: -----------------------------
151: -- reading header level data
152: -----------------------------
153: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_post_body, l_db_nls, l_ecapp_nls);
154: IBY_NETUTILS_PVT.check_mandatory('OapfECAppId', to_char(p_ecapp_id), l_post_body, l_db_nls, l_ecapp_nls);
155: -- Payee ID
156: IBY_NETUTILS_PVT.check_mandatory('OapfStoreId', p_payee_ID, l_post_body, l_db_nls, l_ecapp_nls);
157:
158: -- the mode has to be mandatory as per the specifications

Line 156: IBY_NETUTILS_PVT.check_mandatory('OapfStoreId', p_payee_ID, l_post_body, l_db_nls, l_ecapp_nls);

152: -----------------------------
153: IBY_NETUTILS_PVT.check_mandatory('OapfAction', l_oapf_action, l_post_body, l_db_nls, l_ecapp_nls);
154: IBY_NETUTILS_PVT.check_mandatory('OapfECAppId', to_char(p_ecapp_id), l_post_body, l_db_nls, l_ecapp_nls);
155: -- Payee ID
156: IBY_NETUTILS_PVT.check_mandatory('OapfStoreId', p_payee_ID, l_post_body, l_db_nls, l_ecapp_nls);
157:
158: -- the mode has to be mandatory as per the specifications
159:
160: IBY_NETUTILS_PVT.check_mandatory('OapfMode', l_pmt_mode, l_post_body, l_db_nls, l_ecapp_nls);

Line 160: IBY_NETUTILS_PVT.check_mandatory('OapfMode', l_pmt_mode, l_post_body, l_db_nls, l_ecapp_nls);

156: IBY_NETUTILS_PVT.check_mandatory('OapfStoreId', p_payee_ID, l_post_body, l_db_nls, l_ecapp_nls);
157:
158: -- the mode has to be mandatory as per the specifications
159:
160: IBY_NETUTILS_PVT.check_mandatory('OapfMode', l_pmt_mode, l_post_body, l_db_nls, l_ecapp_nls);
161: IBY_NETUTILS_PVT.check_mandatory('OapfOrgId', p_batch_req_rec.Org_ID, l_post_body, l_db_nls, l_ecapp_nls);
162: IBY_NETUTILS_PVT.check_mandatory('OapfBatchId', p_batch_req_rec.ECBatch_ID, l_post_body, l_db_nls, l_ecapp_nls);
163:
164: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', p_batch_req_rec.PmtInstrType, l_post_body, l_db_nls, l_ecapp_nls);

Line 161: IBY_NETUTILS_PVT.check_mandatory('OapfOrgId', p_batch_req_rec.Org_ID, l_post_body, l_db_nls, l_ecapp_nls);

157:
158: -- the mode has to be mandatory as per the specifications
159:
160: IBY_NETUTILS_PVT.check_mandatory('OapfMode', l_pmt_mode, l_post_body, l_db_nls, l_ecapp_nls);
161: IBY_NETUTILS_PVT.check_mandatory('OapfOrgId', p_batch_req_rec.Org_ID, l_post_body, l_db_nls, l_ecapp_nls);
162: IBY_NETUTILS_PVT.check_mandatory('OapfBatchId', p_batch_req_rec.ECBatch_ID, l_post_body, l_db_nls, l_ecapp_nls);
163:
164: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', p_batch_req_rec.PmtInstrType, l_post_body, l_db_nls, l_ecapp_nls);
165: IBY_NETUTILS_PVT.check_mandatory('OapfBatchSize', p_accxfr_trxn_tbl.count, l_post_body, l_db_nls, l_ecapp_nls);

Line 162: IBY_NETUTILS_PVT.check_mandatory('OapfBatchId', p_batch_req_rec.ECBatch_ID, l_post_body, l_db_nls, l_ecapp_nls);

158: -- the mode has to be mandatory as per the specifications
159:
160: IBY_NETUTILS_PVT.check_mandatory('OapfMode', l_pmt_mode, l_post_body, l_db_nls, l_ecapp_nls);
161: IBY_NETUTILS_PVT.check_mandatory('OapfOrgId', p_batch_req_rec.Org_ID, l_post_body, l_db_nls, l_ecapp_nls);
162: IBY_NETUTILS_PVT.check_mandatory('OapfBatchId', p_batch_req_rec.ECBatch_ID, l_post_body, l_db_nls, l_ecapp_nls);
163:
164: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', p_batch_req_rec.PmtInstrType, l_post_body, l_db_nls, l_ecapp_nls);
165: IBY_NETUTILS_PVT.check_mandatory('OapfBatchSize', p_accxfr_trxn_tbl.count, l_post_body, l_db_nls, l_ecapp_nls);
166:

Line 164: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', p_batch_req_rec.PmtInstrType, l_post_body, l_db_nls, l_ecapp_nls);

160: IBY_NETUTILS_PVT.check_mandatory('OapfMode', l_pmt_mode, l_post_body, l_db_nls, l_ecapp_nls);
161: IBY_NETUTILS_PVT.check_mandatory('OapfOrgId', p_batch_req_rec.Org_ID, l_post_body, l_db_nls, l_ecapp_nls);
162: IBY_NETUTILS_PVT.check_mandatory('OapfBatchId', p_batch_req_rec.ECBatch_ID, l_post_body, l_db_nls, l_ecapp_nls);
163:
164: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', p_batch_req_rec.PmtInstrType, l_post_body, l_db_nls, l_ecapp_nls);
165: IBY_NETUTILS_PVT.check_mandatory('OapfBatchSize', p_accxfr_trxn_tbl.count, l_post_body, l_db_nls, l_ecapp_nls);
166:
167:
168: --reading trxn detail data

Line 165: IBY_NETUTILS_PVT.check_mandatory('OapfBatchSize', p_accxfr_trxn_tbl.count, l_post_body, l_db_nls, l_ecapp_nls);

161: IBY_NETUTILS_PVT.check_mandatory('OapfOrgId', p_batch_req_rec.Org_ID, l_post_body, l_db_nls, l_ecapp_nls);
162: IBY_NETUTILS_PVT.check_mandatory('OapfBatchId', p_batch_req_rec.ECBatch_ID, l_post_body, l_db_nls, l_ecapp_nls);
163:
164: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrType', p_batch_req_rec.PmtInstrType, l_post_body, l_db_nls, l_ecapp_nls);
165: IBY_NETUTILS_PVT.check_mandatory('OapfBatchSize', p_accxfr_trxn_tbl.count, l_post_body, l_db_nls, l_ecapp_nls);
166:
167:
168: --reading trxn detail data
169: IBY_NETUTILS_PVT.check_mandatory('OapfPmtRegId', p_batch_req_rec.Payee_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);

Line 169: IBY_NETUTILS_PVT.check_mandatory('OapfPmtRegId', p_batch_req_rec.Payee_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);

165: IBY_NETUTILS_PVT.check_mandatory('OapfBatchSize', p_accxfr_trxn_tbl.count, l_post_body, l_db_nls, l_ecapp_nls);
166:
167:
168: --reading trxn detail data
169: IBY_NETUTILS_PVT.check_mandatory('OapfPmtRegId', p_batch_req_rec.Payee_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);
170:
171:
172: -- set security token
173: --

Line 175: IBY_NETUTILS_PVT.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),

171:
172: -- set security token
173: --
174: iby_security_pkg.store_credential(l_post_body,l_sec_cred);
175: IBY_NETUTILS_PVT.check_mandatory('OapfSecurityToken', TO_CHAR(l_sec_cred),
176: l_post_body, l_db_nls, l_ecapp_nls);
177:
178:
179: -- write to CLOB

Line 189: IBY_NETUTILS_PVT.check_mandatory('OapfPayerId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Name, l_post_body, l_db_nls, l_ecapp_nls);

185: WHILE (l_curr_index <= p_accxfr_trxn_tbl.last) LOOP
186:
187: l_post_body := '';
188:
189: IBY_NETUTILS_PVT.check_mandatory('OapfPayerId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Name, l_post_body, l_db_nls, l_ecapp_nls);
190: IBY_NETUTILS_PVT.check_mandatory('OapfPayerInstrId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);
191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);
192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);

Line 190: IBY_NETUTILS_PVT.check_mandatory('OapfPayerInstrId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);

186:
187: l_post_body := '';
188:
189: IBY_NETUTILS_PVT.check_mandatory('OapfPayerId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Name, l_post_body, l_db_nls, l_ecapp_nls);
190: IBY_NETUTILS_PVT.check_mandatory('OapfPayerInstrId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);
191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);
192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);

Line 191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);

187: l_post_body := '';
188:
189: IBY_NETUTILS_PVT.check_mandatory('OapfPayerId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Name, l_post_body, l_db_nls, l_ecapp_nls);
190: IBY_NETUTILS_PVT.check_mandatory('OapfPayerInstrId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);
191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);
192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);

Line 192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);

188:
189: IBY_NETUTILS_PVT.check_mandatory('OapfPayerId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Name, l_post_body, l_db_nls, l_ecapp_nls);
190: IBY_NETUTILS_PVT.check_mandatory('OapfPayerInstrId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);
191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);
192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);

Line 193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);

189: IBY_NETUTILS_PVT.check_mandatory('OapfPayerId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Name, l_post_body, l_db_nls, l_ecapp_nls);
190: IBY_NETUTILS_PVT.check_mandatory('OapfPayerInstrId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);
191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);
192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);
197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);

Line 194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);

190: IBY_NETUTILS_PVT.check_mandatory('OapfPayerInstrId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Payer_Instr_ID, l_post_body, l_db_nls, l_ecapp_nls);
191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);
192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);
197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);
198: IBY_NETUTILS_PVT.check_mandatory('OapfTrxnCurr-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Currency_Code, l_post_body, l_db_nls, l_ecapp_nls);

Line 195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);

191: IBY_NETUTILS_PVT.check_mandatory('OapfPmtInstrSubType-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).PmtInstrSubType, l_post_body, l_db_nls, l_ecapp_nls);
192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);
197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);
198: IBY_NETUTILS_PVT.check_mandatory('OapfTrxnCurr-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Currency_Code, l_post_body, l_db_nls, l_ecapp_nls);
199: IBY_NETUTILS_PVT.check_optional('OapfNLSLang-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).NLS_LANG, l_post_body, l_db_nls, l_ecapp_nls);

Line 196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);

192: IBY_NETUTILS_PVT.check_mandatory('OapfOrderId-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_ID, l_post_body, l_db_nls, l_ecapp_nls);
193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);
197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);
198: IBY_NETUTILS_PVT.check_mandatory('OapfTrxnCurr-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Currency_Code, l_post_body, l_db_nls, l_ecapp_nls);
199: IBY_NETUTILS_PVT.check_optional('OapfNLSLang-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).NLS_LANG, l_post_body, l_db_nls, l_ecapp_nls);
200:

Line 197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);

193: IBY_NETUTILS_PVT.check_mandatory('OapfPrice-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Tangible_Amount, l_post_body, l_db_nls, l_ecapp_nls);
194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);
197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);
198: IBY_NETUTILS_PVT.check_mandatory('OapfTrxnCurr-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Currency_Code, l_post_body, l_db_nls, l_ecapp_nls);
199: IBY_NETUTILS_PVT.check_optional('OapfNLSLang-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).NLS_LANG, l_post_body, l_db_nls, l_ecapp_nls);
200:
201: --

Line 198: IBY_NETUTILS_PVT.check_mandatory('OapfTrxnCurr-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Currency_Code, l_post_body, l_db_nls, l_ecapp_nls);

194: IBY_NETUTILS_PVT.check_optional('OapfMemo-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Memo, l_post_body, l_db_nls, l_ecapp_nls);
195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);
197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);
198: IBY_NETUTILS_PVT.check_mandatory('OapfTrxnCurr-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Currency_Code, l_post_body, l_db_nls, l_ecapp_nls);
199: IBY_NETUTILS_PVT.check_optional('OapfNLSLang-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).NLS_LANG, l_post_body, l_db_nls, l_ecapp_nls);
200:
201: --
202: -- Customer reference / debtors reference

Line 199: IBY_NETUTILS_PVT.check_optional('OapfNLSLang-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).NLS_LANG, l_post_body, l_db_nls, l_ecapp_nls);

195: IBY_NETUTILS_PVT.check_optional('OapfRefNumber-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).RefInfo, l_post_body, l_db_nls, l_ecapp_nls);
196: IBY_NETUTILS_PVT.check_mandatory('OapfSchedDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).Settlement_Date,'YYYY-MM-DD'),l_post_body, l_db_nls, l_ecapp_nls);
197: IBY_NETUTILS_PVT.check_mandatory('OapfIssueDate-'|| l_index,to_char(p_accxfr_trxn_tbl(l_curr_index).IssueDate,'YYYY-MM-DD'), l_post_body, l_db_nls, l_ecapp_nls);
198: IBY_NETUTILS_PVT.check_mandatory('OapfTrxnCurr-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).Currency_Code, l_post_body, l_db_nls, l_ecapp_nls);
199: IBY_NETUTILS_PVT.check_optional('OapfNLSLang-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).NLS_LANG, l_post_body, l_db_nls, l_ecapp_nls);
200:
201: --
202: -- Customer reference / debtors reference
203: --

Line 204: IBY_NETUTILS_PVT.check_optional('OapfCustomerRef-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).customerRef, l_post_body, l_db_nls, l_ecapp_nls);

200:
201: --
202: -- Customer reference / debtors reference
203: --
204: IBY_NETUTILS_PVT.check_optional('OapfCustomerRef-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).customerRef, l_post_body, l_db_nls, l_ecapp_nls);
205:
206: -- Adder for new fields ordermedium and EFTAuthMethod
207: IBY_NETUTILS_PVT.check_optional('OapfOrderMedium-'||l_index,p_accxfr_trxn_tbl(l_curr_index).OrderMedium, l_post_body, l_db_nls, l_ecapp_nls);
208: IBY_NETUTILS_PVT.check_optional('OapfEftAuthMethod-'||l_index,p_accxfr_trxn_tbl(l_curr_index).EFTAuthMethod, l_post_body, l_db_nls, l_ecapp_nls);

Line 207: IBY_NETUTILS_PVT.check_optional('OapfOrderMedium-'||l_index,p_accxfr_trxn_tbl(l_curr_index).OrderMedium, l_post_body, l_db_nls, l_ecapp_nls);

203: --
204: IBY_NETUTILS_PVT.check_optional('OapfCustomerRef-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).customerRef, l_post_body, l_db_nls, l_ecapp_nls);
205:
206: -- Adder for new fields ordermedium and EFTAuthMethod
207: IBY_NETUTILS_PVT.check_optional('OapfOrderMedium-'||l_index,p_accxfr_trxn_tbl(l_curr_index).OrderMedium, l_post_body, l_db_nls, l_ecapp_nls);
208: IBY_NETUTILS_PVT.check_optional('OapfEftAuthMethod-'||l_index,p_accxfr_trxn_tbl(l_curr_index).EFTAuthMethod, l_post_body, l_db_nls, l_ecapp_nls);
209:
210: l_index := l_index + 1;
211: l_curr_index := p_accxfr_trxn_tbl.next(l_curr_index);

Line 208: IBY_NETUTILS_PVT.check_optional('OapfEftAuthMethod-'||l_index,p_accxfr_trxn_tbl(l_curr_index).EFTAuthMethod, l_post_body, l_db_nls, l_ecapp_nls);

204: IBY_NETUTILS_PVT.check_optional('OapfCustomerRef-'|| l_index,p_accxfr_trxn_tbl(l_curr_index).customerRef, l_post_body, l_db_nls, l_ecapp_nls);
205:
206: -- Adder for new fields ordermedium and EFTAuthMethod
207: IBY_NETUTILS_PVT.check_optional('OapfOrderMedium-'||l_index,p_accxfr_trxn_tbl(l_curr_index).OrderMedium, l_post_body, l_db_nls, l_ecapp_nls);
208: IBY_NETUTILS_PVT.check_optional('OapfEftAuthMethod-'||l_index,p_accxfr_trxn_tbl(l_curr_index).EFTAuthMethod, l_post_body, l_db_nls, l_ecapp_nls);
209:
210: l_index := l_index + 1;
211: l_curr_index := p_accxfr_trxn_tbl.next(l_curr_index);
212: --dbms_output.put_line('IBY_BANKACCXFR_PUB : '||l_pos);

Line 227: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_tempclob,l_names,l_values, l_status, l_errcode, l_errmessage);

223: -- sending POST request and unpacking the results
224: ---------------------------------------------------
225:
226: --dbms_output.put_line('Length : '||DBMS_LOB.GETLENGTH(l_tempclob));
227: IBY_NETUTILS_PVT.POST_REQUEST(l_url,l_tempclob,l_names,l_values, l_status, l_errcode, l_errmessage);
228:
229: -- Release temporary blobs
230: DBMS_LOB.FreeTemporary(l_tempclob);
231: