DBA Data[Home] [Help]

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_T_GEN_UTILITY_PVT

Line 156: csi_t_gen_utility_pvt.g_debug_level := 10;

152: BEGIN
153:
154: fnd_file.put_line(fnd_file.log, p_message);
155:
156: csi_t_gen_utility_pvt.g_debug_level := 10;
157:
158: csi_t_gen_utility_pvt.build_file_name(
159: p_file_segment1 => 'csisynclog',
160: p_file_segment2 => to_char(sysdate, 'mmddyy'));

Line 158: csi_t_gen_utility_pvt.build_file_name(

154: fnd_file.put_line(fnd_file.log, p_message);
155:
156: csi_t_gen_utility_pvt.g_debug_level := 10;
157:
158: csi_t_gen_utility_pvt.build_file_name(
159: p_file_segment1 => 'csisynclog',
160: p_file_segment2 => to_char(sysdate, 'mmddyy'));
161:
162: csi_t_gen_utility_pvt.add(p_message);

Line 162: csi_t_gen_utility_pvt.add(p_message);

158: csi_t_gen_utility_pvt.build_file_name(
159: p_file_segment1 => 'csisynclog',
160: p_file_segment2 => to_char(sysdate, 'mmddyy'));
161:
162: csi_t_gen_utility_pvt.add(p_message);
163:
164: csi_t_gen_utility_pvt.g_debug_level := 0;
165:
166: END log;

Line 164: csi_t_gen_utility_pvt.g_debug_level := 0;

160: p_file_segment2 => to_char(sysdate, 'mmddyy'));
161:
162: csi_t_gen_utility_pvt.add(p_message);
163:
164: csi_t_gen_utility_pvt.g_debug_level := 0;
165:
166: END log;
167:
168: --

Line 176: csi_t_gen_utility_pvt.g_debug_level := 10;

172: BEGIN
173:
174: fnd_file.put_line(fnd_file.output, p_message);
175:
176: csi_t_gen_utility_pvt.g_debug_level := 10;
177:
178: csi_t_gen_utility_pvt.build_file_name(
179: p_file_segment1 => 'csisyncout',
180: p_file_segment2 => to_char(sysdate, 'mmddyy'));

Line 178: csi_t_gen_utility_pvt.build_file_name(

174: fnd_file.put_line(fnd_file.output, p_message);
175:
176: csi_t_gen_utility_pvt.g_debug_level := 10;
177:
178: csi_t_gen_utility_pvt.build_file_name(
179: p_file_segment1 => 'csisyncout',
180: p_file_segment2 => to_char(sysdate, 'mmddyy'));
181:
182: csi_t_gen_utility_pvt.add(p_message);

Line 182: csi_t_gen_utility_pvt.add(p_message);

178: csi_t_gen_utility_pvt.build_file_name(
179: p_file_segment1 => 'csisyncout',
180: p_file_segment2 => to_char(sysdate, 'mmddyy'));
181:
182: csi_t_gen_utility_pvt.add(p_message);
183:
184: csi_t_gen_utility_pvt.g_debug_level := 0;
185:
186: END out;

Line 184: csi_t_gen_utility_pvt.g_debug_level := 0;

180: p_file_segment2 => to_char(sysdate, 'mmddyy'));
181:
182: csi_t_gen_utility_pvt.add(p_message);
183:
184: csi_t_gen_utility_pvt.g_debug_level := 0;
185:
186: END out;
187:
188: --

Line 207: csi_t_gen_utility_pvt.g_debug_level := 0;

203: BEGIN
204: fnd_profile.put('CSI_DEBUG_LEVEL',0);
205: fnd_profile.put('CSE_DEBUG_OPTION','N');
206: fnd_profile.put('OKS_DEBUG','N');
207: csi_t_gen_utility_pvt.g_debug_level := 0;
208: END debug_off;
209:
210: --
211: PROCEDURE stack_message(

Line 1360: l_msg_data := csi_t_gen_utility_pvt.dump_error_stack;

1356:
1357: EXCEPTION
1358: WHEN fnd_api.g_exc_error THEN
1359: rollback to forward_sync;
1360: l_msg_data := csi_t_gen_utility_pvt.dump_error_stack;
1361: log('Error in forward_sync : '||fs_rec.instance_id||' : '||l_msg_data);
1362: END;
1363: END IF;
1364:

Line 3184: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

3180:
3181: EXCEPTION
3182: WHEN fnd_api.g_exc_error THEN
3183: rollback to pump_txn_error;
3184: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
3185: log(' Error: '||l_error_message);
3186: END pump_txn_error;
3187:
3188: PROCEDURE decode_queue is

Line 5671: csi_t_gen_utility_pvt.build_file_name(

5667: BEGIN
5668:
5669: IF p_mode = 'ALL' THEN
5670:
5671: csi_t_gen_utility_pvt.build_file_name(
5672: p_file_segment1 => 'csisrl',
5673: p_file_segment2 => to_char(sysdate, 'hh24miss'));
5674:
5675: out(' *****************************************************************************');

Line 5691: csi_t_gen_utility_pvt.build_file_name(

5687: END LOOP;
5688:
5689: ELSIF p_mode = 'FIXABLE' THEN
5690:
5691: csi_t_gen_utility_pvt.build_file_name(
5692: p_file_segment1 => 'csisrlfix',
5693: p_file_segment2 => to_char(sysdate, 'hh24miss'));
5694:
5695: report_header;

Line 5707: csi_t_gen_utility_pvt.build_file_name(

5703: END LOOP;
5704:
5705: ELSIF p_mode = 'NONFIXABLE' THEN
5706:
5707: csi_t_gen_utility_pvt.build_file_name(
5708: p_file_segment1 => 'csisrlnofix',
5709: p_file_segment2 => to_char(sysdate, 'hh24miss'));
5710:
5711: report_header;

Line 5723: csi_t_gen_utility_pvt.build_file_name(

5719: END LOOP;
5720:
5721: ELSIF p_mode = 'ERRORS' THEN
5722:
5723: csi_t_gen_utility_pvt.build_file_name(
5724: p_file_segment1 => 'csisrlerr',
5725: p_file_segment2 => to_char(sysdate, 'hh24miss'));
5726:
5727: out(' *****************************************************************************');

Line 6157: l_msg_data := csi_t_gen_utility_pvt.dump_error_stack;

6153: x_return_status => l_return_status,
6154: x_msg_count => l_msg_count,
6155: x_msg_data => l_msg_data );
6156:
6157: l_msg_data := csi_t_gen_utility_pvt.dump_error_stack;
6158: log(' create status :'||l_return_status||' '||l_msg_data);
6159:
6160: -- For Bug 4057183
6161: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 6178: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;

6174: EXCEPTION
6175: WHEN fnd_api.g_exc_error THEN
6176: rollback to create_instance;
6177: x_return_status := fnd_api.g_ret_sts_error;
6178: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
6179: END create_instance;
6180:
6181: PROCEDURE update_instance(
6182: p_txn_rec IN csi_datastructures_pub.transaction_rec,

Line 6318: l_msg_data := csi_t_gen_utility_pvt.dump_error_stack;

6314: x_return_status => l_return_status,
6315: x_msg_count => l_msg_count,
6316: x_msg_data => l_msg_data);
6317:
6318: l_msg_data := csi_t_gen_utility_pvt.dump_error_stack;
6319: log(' update status :'||l_return_status||' '||l_msg_data);
6320:
6321: -- For Bug 4057183
6322: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 6354: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;

6350: EXCEPTION
6351: WHEN fnd_api.g_exc_error THEN
6352: rollback to update_instance;
6353: x_return_status := fnd_api.g_ret_sts_error;
6354: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
6355: END update_instance;
6356:
6357: PROCEDURE fix_soiship(
6358: p_diag_txn_rec IN diag_txn_rec,

Line 6758: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

6754:
6755: EXCEPTION
6756: WHEN fnd_api.g_exc_error THEN
6757: rollback to stage_soiship_instances;
6758: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
6759: UPDATE csi_diagnostics_temp
6760: SET process_flag = 'E',
6761: temporary_message = l_error_message
6762: WHERE mtl_txn_id = txn_rec.mtl_txn_id;

Line 7768: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;

7764: -- For Bug 4057183
7765: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN
7766: IF l_return_status not in (fnd_api.g_ret_sts_success,'W') THEN
7767: x_return_status := l_return_status;
7768: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
7769: RAISE user_error;
7770: END IF;
7771:
7772: ELSE

Line 8084: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;

8080: -- For Bug 4057183
8081: -- IF l_return_status <> fnd_api.g_ret_sts_success THEN
8082: IF l_return_status not in (fnd_api.g_ret_sts_success,'W') THEN
8083: x_return_status := l_return_status;
8084: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
8085: END IF;
8086:
8087: ELSE
8088:

Line 8427: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;

8423: END IF;
8424: EXCEPTION
8425: WHEN fnd_api.g_exc_error THEN
8426: x_return_status := fnd_api.g_ret_sts_error;
8427: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
8428: log(' error: '||x_error_message);
8429: END;
8430: END LOOP;
8431:

Line 9267: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;

9263: fill(to_char(srl_rec.serial_code), 2)||
9264: fill(to_char(srl_rec.lot_code), 2));
9265: log(l_skip_error);
9266: WHEN fnd_api.g_exc_error THEN
9267: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
9268: log(fill(srl_rec.serial_number, 15)||
9269: fill(to_char(srl_rec.inventory_item_id), 9)||
9270: fill(to_char(srl_rec.organization_id), 9)||
9271: fill(to_char(srl_rec.serial_code), 2)||

Line 13653: csi_t_gen_utility_pvt.build_file_name(

13649: process_next EXCEPTION;
13650: comp_error EXCEPTION;
13651: --
13652: BEGIN
13653: csi_t_gen_utility_pvt.build_file_name(
13654: p_file_segment1 => 'csinonsy',
13655: p_file_segment2 => to_char(sysdate, 'hh24miss'));
13656: --
13657: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 14588: csi_t_gen_utility_pvt.build_file_name(

14584: --
14585: process_next EXCEPTION;
14586: comp_error EXCEPTION;
14587: BEGIN
14588: csi_t_gen_utility_pvt.build_file_name(
14589: p_file_segment1 => 'csinonsy',
14590: p_file_segment2 => to_char(sysdate, 'hh24miss'));
14591: --
14592: -- Get the Transaction Type ID for Txn Type MIGRATED

Line 15305: csi_t_gen_utility_pvt.build_file_name(

15301: AND d.inventory_item_id <> a.inventory_item_id
15302: AND e.organization_id = nvl(a.last_vld_organization_id, a.inv_master_organization_id)
15303: AND e.serial_number_type = 3;
15304: BEGIN
15305: csi_t_gen_utility_pvt.build_file_name(
15306: p_file_segment1 => 'csisrlun',
15307: p_file_segment2 => to_char(sysdate, 'hh24miss'));
15308: --
15309: FOR uniq_rec IN uniq_cur

Line 15437: csi_t_gen_utility_pvt.add(p_message);

15433:
15434: PROCEDURE debug(p_message IN varchar2)
15435: IS
15436: BEGIN
15437: csi_t_gen_utility_pvt.add(p_message);
15438: END debug;
15439:
15440: BEGIN
15441: