[Home] [Help]
249: l_taxdtls2_in_batch + l_taxdtls3_in_batch +
250: l_uda_in_batch ;
251:
252: /* This procedure also initializes the post count columns to zero */
253: UPDATE pos_imp_batch_summary
254: SET suppliers_in_batch = l_suppliers_in_batch,
255: sites_in_batch = l_supp_sites_in_batch,
256: contacts_in_batch = l_sup_contact_in_batch,
257: buss_class_in_batch = l_bus_class_in_batch,
335: ----------------
336: -- do validation
337: ----------------
338:
339: -- batch id must be a valid batch id in pos_imp_batch_summary table
340: BEGIN
341: SELECT batch_id,
342: original_system
343: INTO l_batch_id,
341: SELECT batch_id,
342: original_system
343: INTO l_batch_id,
344: l_original_system
345: FROM pos_imp_batch_summary
346: WHERE batch_id = p_batch_id;
347:
348: EXCEPTION
349: WHEN no_data_found THEN
349: WHEN no_data_found THEN
350: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
351: fnd_message.set_token('FK', 'p_batch_id');
352: fnd_message.set_token('COLUMN', 'batch_id');
353: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
354: fnd_msg_pub.add;
355: x_return_status := fnd_api.g_ret_sts_error;
356: END;
357:
362: -- batch id must be a valid batch for processing
363: BEGIN
364: SELECT batch_id
365: INTO l_batch_id
366: FROM pos_imp_batch_summary
367: WHERE batch_id = p_batch_id
368: AND nvl(batch_status, 'ACTIVE') NOT IN
369: ('PURGED',
370: 'REJECTED',
387: -- update the batch summary table
388: ---------------------------------
389:
390: -- update the batch record
391: UPDATE pos_imp_batch_summary
392: SET batch_status = 'ACTIVE',
393: last_updated_by = hz_utility_v2pub.last_updated_by,
394: last_update_date = hz_utility_v2pub.last_update_date,
395: last_update_login = hz_utility_v2pub.last_update_login
450: p_batch_id IN VARCHAR2
451: ) IS
452: i NUMBER;
453: l_error_message VARCHAR2(2000);
454: l_status pos_imp_batch_summary.main_conc_status%TYPE;
455: BEGIN
456:
457: /* Check for 8i database */
458: BEGIN
499: /* Batch is Processing */
500: BEGIN
501: SELECT main_conc_status
502: INTO l_status
503: FROM pos_imp_batch_summary
504: WHERE batch_id = p_batch_id;
505:
506: IF l_status = 'PROCESSING' THEN
507: RAISE fnd_api.g_exc_error;
556:
557: fnd_file.put_line(fnd_file.log, ' Purged Interface Tables ... ');
558:
559: fnd_file.put_line(fnd_file.log,
560: ' Update pos_imp_batch_summary table (+)');
561: -- Update pos_imp_batch_summary table.
562: UPDATE pos_imp_batch_summary
563: SET batch_status = 'PURGED',
564: purge_date = SYSDATE,
557: fnd_file.put_line(fnd_file.log, ' Purged Interface Tables ... ');
558:
559: fnd_file.put_line(fnd_file.log,
560: ' Update pos_imp_batch_summary table (+)');
561: -- Update pos_imp_batch_summary table.
562: UPDATE pos_imp_batch_summary
563: SET batch_status = 'PURGED',
564: purge_date = SYSDATE,
565: purged_by_user_id = hz_utility_v2pub.user_id
558:
559: fnd_file.put_line(fnd_file.log,
560: ' Update pos_imp_batch_summary table (+)');
561: -- Update pos_imp_batch_summary table.
562: UPDATE pos_imp_batch_summary
563: SET batch_status = 'PURGED',
564: purge_date = SYSDATE,
565: purged_by_user_id = hz_utility_v2pub.user_id
566: WHERE batch_id = p_batch_id;
566: WHERE batch_id = p_batch_id;
567: COMMIT;
568:
569: fnd_file.put_line(fnd_file.log,
570: ' Update pos_imp_batch_summary table (-)');
571: EXCEPTION
572: WHEN OTHERS THEN
573: ROLLBACK WORK;
574: fnd_file.put_line(fnd_file.log, SQLERRM);
608: ----------------
609: -- do validation
610: ----------------
611:
612: -- batch id must be a valid batch id in pos_imp_batch_summary table and hz_imp_batch_summary
613: BEGIN
614: SELECT pos.batch_id,
615: pos.original_system
616: INTO l_batch_id,
614: SELECT pos.batch_id,
615: pos.original_system
616: INTO l_batch_id,
617: l_original_system
618: FROM pos_imp_batch_summary pos,
619: hz_imp_batch_summary hz
620: WHERE pos.batch_id = hz.batch_id
621: AND pos.batch_id = p_batch_id;
622:
624: WHEN no_data_found THEN
625: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
626: fnd_message.set_token('FK', 'p_batch_id');
627: fnd_message.set_token('COLUMN', 'batch_id');
628: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
629: fnd_msg_pub.add;
630: x_return_status := fnd_api.g_ret_sts_error;
631: END;
632:
637: /* -- batch id must be a valid batch for processing
638: BEGIN
639: SELECT pos.batch_id
640: INTO l_batch_id
641: FROM pos_imp_batch_summary pos, hz_imp_batch_summary hz
642: WHERE pos.batch_id = hz.batch_id
643: and pos.batch_id = p_batch_id
644: AND nvl(pos.batch_status,'ACTIVE') NOT IN
645: ('PURGED',
677: last_update_date = hz_utility_v2pub.last_update_date,
678: last_update_login = hz_utility_v2pub.last_update_login
679: WHERE batch_id = p_batch_id;
680:
681: UPDATE pos_imp_batch_summary
682: SET batch_status = 'REJECTED',
683: import_status = 'REJECTED',
684: last_updated_by = hz_utility_v2pub.last_updated_by,
685: last_update_date = hz_utility_v2pub.last_update_date,
788: --------------------------------------------
789: -- insert the record with batch id
790: --------------------------------------------
791:
792: INSERT INTO pos_imp_batch_summary
793: (batch_id,
794: batch_name,
795: description,
796: original_system,