APPS.CN_COLLECTION_AIA_OM_PUB dependencies on FND_API

Line 155: preprocess_flag = fnd_api.g_false AND

151: SELECT DISTINCT salesrep_id,
152: amt_curcy_cd,processed_date, revenue_type
153: FROM cn_aia_order_capture
154: WHERE
155: preprocess_flag = fnd_api.g_false AND
156: org_id = p_org_id
157: AND update_flag = 'N';
158:
159: type salesreps_tbl_type IS TABLE OF fetch_aia_salesreps_cur % rowtype INDEX BY pls_integer;

Line 169: x_return_status := fnd_api.g_ret_sts_success;

165: BEGIN
166: debugmsg('CN_COLLECTION_AIA_OM_PUB.oic_pre_load_data_process: start: ');
167: debugmsg('CN_COLLECTION_AIA_OM_PUB.oic_pre_load_data_process: p_org_id : ' || p_org_id);
168: SAVEPOINT oic_pre_load;
169: x_return_status := fnd_api.g_ret_sts_success;
170:
171: OPEN fetch_aia_salesreps_cur;
172: debugmsg('CN_COLLECTION_AIA_OM_PUB.oic_pre_load_data_process: inside fetch_aia_salesreps_cur: ');
173: LOOP

Line 193: --preprocess_flag = fnd_api.g_false,

189: SET employee_number = l_employee_num,
190: exchange_rate = l_exchange_rate,
191: revenue_type = l_revenue_type,
192: adjust_status = 'MANUAL',
193: --preprocess_flag = fnd_api.g_false,
194: update_flag = 'Y'
195: WHERE (salesrep_id = salesreps_tbl(indx).salesrep_id)
196: AND amt_curcy_cd = salesreps_tbl(indx).amt_curcy_cd
197: AND processed_date = salesreps_tbl(indx).processed_date

Line 200: AND preprocess_flag = fnd_api.g_false

196: AND amt_curcy_cd = salesreps_tbl(indx).amt_curcy_cd
197: AND processed_date = salesreps_tbl(indx).processed_date
198: AND nvl(revenue_type, 'REVENUE') = nvl(salesreps_tbl(indx).revenue_type, 'REVENUE')
199: AND update_flag = 'N'
200: AND preprocess_flag = fnd_api.g_false
201: AND org_id = p_org_id;
202:
203: END LOOP;
204:

Line 244: x_return_status := fnd_api.g_ret_sts_success;

240: x_return_status VARCHAR2(1);
241:
242: BEGIN
243: debugmsg('CN_COLLECTION_AIA_OM_PUB.pre_aia_om_load_process: start: ');
244: x_return_status := fnd_api.g_ret_sts_success;
245: retcode := 0;
246: errbuf := '';
247:
248: cn_cust_aia_ord_proc_pub.ct_aia_om_pre_processing(x_return_status => x_return_status);

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: debugmsg('CN_COLLECTION_AIA_OM_PUB.pre_aia_om_load_process: after cn_cust_aia_ord_proc_pub.ct_aia_om_pre_processing call: ');
251: debugmsg('CN_COLLECTION_AIA_OM_PUB.pre_aia_om_load_process: x_return_status: ' || x_return_status);
252:
253: IF(x_return_status <> 'S') THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: oic_pre_load_data_process(errbuf => errbuf,
258: retcode => retcode,

Line 266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

262: debugmsg('CN_COLLECTION_AIA_OM_PUB.pre_aia_om_load_process: after oic_pre_load_data_process call: ');
263: debugmsg('CN_COLLECTION_AIA_OM_PUB.pre_aia_om_load_process: x_return_status: ' || x_return_status);
264:
265: IF(x_return_status <> 'S') THEN
266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
267: END IF;
268:
269: EXCEPTION
270: WHEN others THEN

Line 275: --RAISE FND_API.G_EXC_ERROR;

271: x_return_status := 'F';
272: retcode := 2;
273: errbuf := errbuf || ' : ' || SQLERRM(SQLCODE());
274: debugmsg('CN_PURGE_TABLES_PUB.archive_purge_cn_tables:exception others: ' || errbuf);
275: --RAISE FND_API.G_EXC_ERROR;
276: raise_application_error (-20002,errbuf);
277:
278: END pre_aia_om_load_process;
279:

Line 292: x_return_status := fnd_api.g_ret_sts_success;

288: PROCEDURE post_aia_om_load_process(x_return_status OUT nocopy VARCHAR2) IS
289:
290: BEGIN
291:
292: x_return_status := fnd_api.g_ret_sts_success;
293:
294: END post_aia_om_load_process;
295:
296: END CN_COLLECTION_AIA_OM_PUB;