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.

[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on POS_IMP_BATCH_SUMMARY

Line 1700: UPDATE pos_imp_batch_summary

1696: SET status = 'PROCESSED'
1697: WHERE vendor_interface_id = p_vendor_rec.vendor_interface_id
1698: AND sdh_batch_id = p_batch_id;
1699:
1700: UPDATE pos_imp_batch_summary
1701: SET total_records_imported = total_records_imported + 1,
1702: total_inserts = total_inserts + 1,
1703: suppliers_inserted = suppliers_inserted + 1,
1704: suppliers_imported = suppliers_imported + 1

Line 2484: UPDATE pos_imp_batch_summary

2480: SET status = 'PROCESSED'
2481: WHERE vendor_interface_id = vendor_rec.vendor_interface_id
2482: AND sdh_batch_id = p_batch_id;
2483:
2484: UPDATE pos_imp_batch_summary
2485: SET total_records_imported = total_records_imported + 1,
2486: total_updates = total_updates + 1,
2487: suppliers_updated = suppliers_updated + 1,
2488: suppliers_imported = suppliers_imported + 1

Line 2672: UPDATE pos_imp_batch_summary

2668: SET status = 'PROCESSED'
2669: WHERE vendor_site_interface_id = p_site_rec.vendor_site_interface_id
2670: AND sdh_batch_id = p_batch_id;
2671:
2672: UPDATE pos_imp_batch_summary
2673: SET total_records_imported = total_records_imported + 1,
2674: total_inserts = total_inserts + 1,
2675: sites_inserted = sites_inserted + 1,
2676: sites_imported = sites_imported + 1

Line 3515: UPDATE pos_imp_batch_summary

3511: WHERE vendor_site_interface_id =
3512: site_rec.vendor_site_interface_id
3513: AND sdh_batch_id = p_batch_id;
3514:
3515: UPDATE pos_imp_batch_summary
3516: SET total_records_imported = total_records_imported + 1,
3517: total_updates = total_updates + 1,
3518: sites_updated = sites_updated + 1,
3519: sites_imported = sites_imported + 1

Line 4221: UPDATE pos_imp_batch_summary

4217: l_insert_update_flag := 'U';
4218: END;
4219:
4220: IF (l_insert_update_flag = 'I') THEN
4221: UPDATE pos_imp_batch_summary
4222: SET total_records_imported = total_records_imported + 1,
4223: total_inserts = total_inserts + 1,
4224: contacts_inserted = contacts_inserted + 1,
4225: contacts_imported = contacts_imported + 1

Line 4228: UPDATE pos_imp_batch_summary

4224: contacts_inserted = contacts_inserted + 1,
4225: contacts_imported = contacts_imported + 1
4226: WHERE batch_id = p_batch_id;
4227: ELSE
4228: UPDATE pos_imp_batch_summary
4229: SET total_records_imported = total_records_imported + 1,
4230: total_updates = total_updates + 1,
4231: contacts_updated = contacts_updated + 1,
4232: contacts_imported = contacts_imported + 1

Line 5123: UPDATE pos_imp_batch_summary

5119: SET status = 'PROCESSED'
5120: WHERE ps_interface_id = vendor_int_prod_srv_rec.ps_interface_id
5121: AND sdh_batch_id = p_batch_id;
5122:
5123: UPDATE pos_imp_batch_summary
5124: SET total_records_imported = total_records_imported + 1,
5125: total_inserts = total_inserts + 1,
5126: prod_serv_inserted = prod_serv_inserted + 1,
5127: prod_serv_imported = prod_serv_imported + 1

Line 5257: UPDATE pos_imp_batch_summary

5253: SET status = 'PROCESSED'
5254: WHERE ps_interface_id = vendor_int_prod_srv_rec.ps_interface_id
5255: AND sdh_batch_id = p_batch_id;
5256:
5257: UPDATE pos_imp_batch_summary
5258: SET total_records_imported = total_records_imported + 1,
5259: total_updates = total_updates + 1,
5260: prod_serv_updated = prod_serv_updated + 1,
5261: prod_serv_imported = prod_serv_imported + 1

Line 5807: UPDATE pos_imp_batch_summary

5803: WHERE business_class_interface_id =
5804: vendor_int_buss_class_rec.business_class_interface_id
5805: AND sdh_batch_id = p_batch_id;
5806:
5807: UPDATE pos_imp_batch_summary
5808: SET total_records_imported = total_records_imported + 1,
5809: total_inserts = total_inserts + 1,
5810: buss_class_inserted = buss_class_inserted + 1,
5811: buss_class_imported = buss_class_imported + 1

Line 5880: UPDATE pos_imp_batch_summary

5876: WHERE business_class_interface_id =
5877: vendor_int_buss_class_rec.business_class_interface_id
5878: AND sdh_batch_id = p_batch_id;
5879:
5880: UPDATE pos_imp_batch_summary
5881: SET total_records_imported = total_records_imported + 1,
5882: total_updates = total_updates + 1,
5883: buss_class_updated = buss_class_updated + 1,
5884: buss_class_imported = buss_class_imported + 1

Line 7630: UPDATE pos_imp_batch_summary

7626: .tax_profile_interface_id
7627: AND batch_id = p_batch_id;
7628:
7629: IF (l_tax_profile_rec_tab(cntr).insert_update_flag = 'I') THEN
7630: UPDATE pos_imp_batch_summary
7631: SET total_records_imported = total_records_imported + 1,
7632: total_inserts = total_inserts + 1,
7633: tax_dtls_inserted = tax_dtls_inserted + 1,
7634: tax_dtls_imported = tax_dtls_imported + 1

Line 7637: UPDATE pos_imp_batch_summary

7633: tax_dtls_inserted = tax_dtls_inserted + 1,
7634: tax_dtls_imported = tax_dtls_imported + 1
7635: WHERE batch_id = p_batch_id;
7636: ELSE
7637: UPDATE pos_imp_batch_summary
7638: SET total_records_imported = total_records_imported + 1,
7639: total_updates = total_updates + 1,
7640: tax_dtls_updated = tax_dtls_updated + 1,
7641: tax_dtls_imported = tax_dtls_imported + 1

Line 7784: UPDATE pos_imp_batch_summary

7780: WHERE tax_reg_interface_id = l_tax_reg_rec_tab(cntr)
7781: .tax_reg_interface_id
7782: AND batch_id = p_batch_id;
7783:
7784: UPDATE pos_imp_batch_summary
7785: SET total_records_imported = total_records_imported + 1,
7786: total_updates = total_updates + 1,
7787: tax_dtls_updated = tax_dtls_updated + 1,
7788: tax_dtls_imported = tax_dtls_imported + 1

Line 7809: UPDATE pos_imp_batch_summary

7805: WHERE tax_reg_interface_id = l_tax_reg_rec_tab(cntr)
7806: .tax_reg_interface_id
7807: AND batch_id = p_batch_id;
7808:
7809: UPDATE pos_imp_batch_summary
7810: SET total_records_imported = total_records_imported + 1,
7811: total_inserts = total_inserts + 1,
7812: tax_dtls_inserted = tax_dtls_inserted + 1,
7813: tax_dtls_imported = tax_dtls_imported + 1

Line 7961: UPDATE pos_imp_batch_summary

7957: WHERE fiscal_class_interface_id = l_fiscal_class_rec_tab(cntr)
7958: .fiscal_class_interface_id
7959: AND batch_id = p_batch_id;
7960:
7961: UPDATE pos_imp_batch_summary
7962: SET total_records_imported = total_records_imported + 1,
7963: total_inserts = total_inserts + 1,
7964: tax_dtls_inserted = tax_dtls_inserted + 1,
7965: tax_dtls_imported = tax_dtls_imported + 1

Line 7981: UPDATE pos_imp_batch_summary

7977: WHERE fiscal_class_interface_id = l_fiscal_class_rec_tab(cntr)
7978: .fiscal_class_interface_id
7979: AND batch_id = p_batch_id;
7980:
7981: UPDATE pos_imp_batch_summary
7982: SET total_records_imported = total_records_imported + 1,
7983: total_updates = total_updates + 1,
7984: tax_dtls_updated = tax_dtls_updated + 1,
7985: tax_dtls_imported = tax_dtls_imported + 1

Line 9662: UPDATE pos_imp_batch_summary

9658: bank_account_dtls_rec.bank_account_interface_id
9659: AND batch_id = p_batch_id;
9660:
9661: IF (bank_account_dtls_rec.insert_update_flag = 'I') THEN
9662: UPDATE pos_imp_batch_summary
9663: SET total_records_imported = total_records_imported + 1,
9664: total_inserts = total_inserts + 1,
9665: bank_detls_inserted = bank_detls_inserted + 1,
9666: bank_detls_imported = bank_detls_imported + 1

Line 9669: UPDATE pos_imp_batch_summary

9665: bank_detls_inserted = bank_detls_inserted + 1,
9666: bank_detls_imported = bank_detls_imported + 1
9667: WHERE batch_id = p_batch_id;
9668: ELSE
9669: UPDATE pos_imp_batch_summary
9670: SET total_records_imported = total_records_imported + 1,
9671: total_updates = total_updates + 1,
9672: bank_detls_updated = bank_detls_updated + 1,
9673: bank_detls_imported = bank_detls_imported + 1

Line 9965: UPDATE pos_imp_batch_summary

9961: WHERE bank_acct_owner_interface_id =
9962: account_owners_rec.bank_acct_owner_interface_id
9963: AND batch_id = p_batch_id;
9964:
9965: UPDATE pos_imp_batch_summary
9966: SET total_records_imported = total_records_imported + 1,
9967: total_inserts = total_inserts + 1,
9968: bank_detls_inserted = bank_detls_inserted + 1,
9969: bank_detls_imported = bank_detls_imported + 1

Line 10046: UPDATE pos_imp_batch_summary

10042: IF (p_import_uda_only = 'N') THEN
10043:
10044: /*IF (p_import_run_option <> 'CONTINUE') THEN*/
10045: -- set the processing status appropriately
10046: UPDATE pos_imp_batch_summary
10047: SET import_status = 'PROCESSING',
10048: main_conc_status = 'PROCESSING',
10049: batch_status = 'PROCESSING',
10050: import_req_id = l_request_id

Line 10067: UPDATE pos_imp_batch_summary

10063: ' From pre_processing API.');
10064: errbuf := 'WARNING****** Unexpected error occured in pre_processing.';
10065: retcode := 1;
10066:
10067: UPDATE pos_imp_batch_summary
10068: SET import_status = 'COMPL_ERRORS',
10069: main_conc_status = 'COMPLETED',
10070: batch_status = 'ACTION_REQUIRED'
10071: WHERE batch_id = p_batch_id;

Line 10084: UPDATE pos_imp_batch_summary

10080: fnd_file.put_line(fnd_file.log,
10081: ' Message: Inside PROCEDURE IMPORT_BATCH' ||
10082: ' p_import_run_option = CONTINUE');
10083:
10084: UPDATE pos_imp_batch_summary
10085: SET import_status = 'PENDING',
10086: main_conc_status = 'PENDING',
10087: batch_status = 'PROCESSING',
10088: import_req_id = l_request_id

Line 10108: UPDATE pos_imp_batch_summary

10104: 'Error Message Count: ' || l_msg_count ||
10105: ' Error Message Data: ' || l_msg_data ||
10106: ' From validate_vendor API.');
10107:
10108: UPDATE pos_imp_batch_summary
10109: SET import_status = 'PENDING',
10110: main_conc_status = 'COMPLETED',
10111: batch_status = 'PENDING'
10112: WHERE batch_id = p_batch_id;

Line 10148: UPDATE pos_imp_batch_summary

10144: 'l_batch_status : ' || l_batch_status ||
10145: ' l_import_status : ' || l_import_status);
10146:
10147: IF (l_batch_status <> 'COMPLETED') THEN
10148: UPDATE pos_imp_batch_summary
10149: SET import_status = 'PENDING',
10150: main_conc_status = 'PENDING',
10151: batch_status = 'PROCESSING',
10152: import_req_id = l_request_id

Line 10234: UPDATE pos_imp_batch_summary

10230: finnumbers_updated
10231: WHERE batch_id = p_batch_id;
10232:
10233: -- Set the processing status appropriately
10234: UPDATE pos_imp_batch_summary
10235: SET import_status = 'PROCESSING',
10236: main_conc_status = 'PROCESSING',
10237: batch_status = 'PROCESSING'
10238: WHERE batch_id = p_batch_id;

Line 10253: UPDATE pos_imp_batch_summary

10249: ' From enable_party_as_supplier API.');
10250: errbuf := 'WARNING****** Unexpected error occured in enabling party as supplier program.';
10251: retcode := 1;
10252:
10253: UPDATE pos_imp_batch_summary
10254: SET import_status = 'COMPL_ERRORS',
10255: main_conc_status = 'COMPLETED',
10256: batch_status = 'ACTION_REQUIRED'
10257: WHERE batch_id = p_batch_id;

Line 10550: UPDATE pos_imp_batch_summary

10546: 'Total error count is : ' || l_tot_err_count);
10547:
10548: -- Set the processing status appropriately
10549: IF (l_tot_err_count = 0) THEN
10550: UPDATE pos_imp_batch_summary
10551: SET import_status = 'COMPLETED',
10552: main_conc_status = 'COMPLETED',
10553: batch_status = 'COMPLETED',
10554: total_records_imported = total_records_imported + l_uda_imported_count

Line 10557: UPDATE pos_imp_batch_summary

10553: batch_status = 'COMPLETED',
10554: total_records_imported = total_records_imported + l_uda_imported_count
10555: WHERE batch_id = p_batch_id;
10556: ELSE
10557: UPDATE pos_imp_batch_summary
10558: SET import_status = 'COMPL_ERRORS',
10559: main_conc_status = 'COMPLETED',
10560: batch_status = 'ACTION_REQUIRED',
10561: total_records_imported = total_records_imported + l_uda_imported_count

Line 10566: UPDATE pos_imp_batch_summary

10562: WHERE batch_id = p_batch_id;
10563: END IF;
10564:
10565: ELSIF (l_batch_status = 'PROCESSING') THEN
10566: UPDATE pos_imp_batch_summary
10567: SET import_status = 'PENDING',
10568: main_conc_status = 'PENDING',
10569: batch_status = 'PROCESSING',
10570: total_records_imported = total_records_imported + l_uda_imported_count

Line 10576: UPDATE pos_imp_batch_summary

10572:
10573: RETURN;
10574: ELSIF (l_batch_status = 'ACTION_REQUIRED') THEN
10575:
10576: UPDATE pos_imp_batch_summary
10577: SET import_status = 'PENDING',
10578: main_conc_status = 'PENDING',
10579: batch_status = 'PENDING',
10580: total_records_imported = total_records_imported + l_uda_imported_count