1865: l_object_version_number NUMBER (9);
1866: l_batch_id NUMBER (15);
1867: l_count_timecards NUMBER (9);
1868: l_max_batches NUMBER
1869: := fnd_profile.VALUE ('HXT_BATCH_SIZE');
1870: -- l_max_batches NUMBER := fnd_profile.Value('OTC_BATCH_SIZE');
1871: l_batch_ref VARCHAR2 (30);
1872: l_batch_name VARCHAR2 (30);
1873: l_non_retro_batch_id NUMBER (15);
1866: l_batch_id NUMBER (15);
1867: l_count_timecards NUMBER (9);
1868: l_max_batches NUMBER
1869: := fnd_profile.VALUE ('HXT_BATCH_SIZE');
1870: -- l_max_batches NUMBER := fnd_profile.Value('OTC_BATCH_SIZE');
1871: l_batch_ref VARCHAR2 (30);
1872: l_batch_name VARCHAR2 (30);
1873: l_non_retro_batch_id NUMBER (15);
1874: l_count_batch_lines NUMBER (9);
4442: END IF;
4443:
4444: --
4445: IF ( (SQLERRM LIKE '%HXC%')
4446: AND (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'BOTH')
4447: )
4448: THEN
4449: hxc_generic_retrieval_utils.set_parent_statuses;
4450: hxc_generic_retrieval_pkg.update_transaction_status
4459: fnd_message.raise_error;
4460: ELSE
4461: p_no_otm := 'Y';
4462: END IF;
4463: ELSIF (fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS') = 'OTLR')
4464: THEN
4465: hxc_generic_retrieval_utils.set_parent_statuses;
4466: --
4467: hxc_generic_retrieval_pkg.update_transaction_status