DBA Data[Home] [Help]

APPS.CSI_T_TXN_OUS_PVT dependencies on CSI_T_GEN_UTILITY_PVT

Line 58: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

54:
55: END IF;
56:
57: --debug info
58: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
59:
60: csi_t_gen_utility_pvt.dump_api_info(
61: p_pkg_name => g_pkg_name,
62: p_api_name => l_api_name);

Line 60: csi_t_gen_utility_pvt.dump_api_info(

56:
57: --debug info
58: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
59:
60: csi_t_gen_utility_pvt.dump_api_info(
61: p_pkg_name => g_pkg_name,
62: p_api_name => l_api_name);
63:
64: csi_t_gen_utility_pvt.add(

Line 64: csi_t_gen_utility_pvt.add(

60: csi_t_gen_utility_pvt.dump_api_info(
61: p_pkg_name => g_pkg_name,
62: p_api_name => l_api_name);
63:
64: csi_t_gen_utility_pvt.add(
65: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
66:
67: IF l_debug_level > 1 THEN
68: csi_t_gen_utility_pvt.dump_org_assgn_rec(

Line 68: csi_t_gen_utility_pvt.dump_org_assgn_rec(

64: csi_t_gen_utility_pvt.add(
65: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
66:
67: IF l_debug_level > 1 THEN
68: csi_t_gen_utility_pvt.dump_org_assgn_rec(
69: p_org_assgn_rec => p_txn_org_assgn_rec);
70: END IF;
71:
72: -- Main API code

Line 88: csi_t_gen_utility_pvt.add('Validate operating unit id failed.');

84: l_valid :=
85: csi_org_unit_vld_pvt.is_valid_operating_unit_id(
86: p_operating_unit_id => p_txn_org_assgn_rec.operating_unit_id);
87: IF NOT (l_valid) THEN
88: csi_t_gen_utility_pvt.add('Validate operating unit id failed.');
89: RAISE fnd_api.g_exc_error;
90: END IF;
91:
92: -- validate relationship_type_code

Line 98: csi_t_gen_utility_pvt.add('Validate ou relationship type code failed.');

94: csi_org_unit_vld_pvt.is_valid_rel_type_code(
95: p_relationship_type_code => p_txn_org_assgn_rec.relationship_type_code);
96:
97: IF NOT (l_valid) THEN
98: csi_t_gen_utility_pvt.add('Validate ou relationship type code failed.');
99: RAISE fnd_api.g_exc_error;
100: END IF;
101:
102: IF nvl(p_txn_org_assgn_rec.instance_ou_id,fnd_api.g_miss_num) <>

Line 133: csi_t_gen_utility_pvt.dump_api_info(

129:
130: --debug info
131: begin
132:
133: csi_t_gen_utility_pvt.dump_api_info(
134: p_api_name => 'insert_row',
135: p_pkg_name => 'csi_t_org_assignments_pkg');
136:
137: csi_t_org_assignments_pkg.insert_row(

Line 185: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN

181: IF fnd_api.To_Boolean( p_commit ) THEN
182: COMMIT WORK;
183: END IF;
184:
185: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
186: csi_t_gen_utility_pvt.set_debug_off;
187: END IF;
188:
189: -- Standard call to get message count and if count is get message info.

Line 186: csi_t_gen_utility_pvt.set_debug_off;

182: COMMIT WORK;
183: END IF;
184:
185: IF csi_t_gen_utility_pvt.g_debug = fnd_api.g_true THEN
186: csi_t_gen_utility_pvt.set_debug_off;
187: END IF;
188:
189: -- Standard call to get message count and if count is get message info.
190: fnd_msg_pub.count_and_get(

Line 284: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

280:
281: END IF;
282:
283: --debug info
284: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
285:
286: csi_t_gen_utility_pvt.dump_api_info(
287: p_pkg_name => g_pkg_name,
288: p_api_name => l_api_name);

Line 286: csi_t_gen_utility_pvt.dump_api_info(

282:
283: --debug info
284: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
285:
286: csi_t_gen_utility_pvt.dump_api_info(
287: p_pkg_name => g_pkg_name,
288: p_api_name => l_api_name);
289:
290: csi_t_gen_utility_pvt.add(

Line 290: csi_t_gen_utility_pvt.add(

286: csi_t_gen_utility_pvt.dump_api_info(
287: p_pkg_name => g_pkg_name,
288: p_api_name => l_api_name);
289:
290: csi_t_gen_utility_pvt.add(
291: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
292:
293: -- Main API code
294: IF p_txn_org_assgn_tbl.COUNT > 0 THEN

Line 300: csi_t_gen_utility_pvt.dump_org_assgn_rec(

296: FOR l_ind in p_txn_org_assgn_tbl.FIRST..p_txn_org_assgn_tbl.LAST
297: LOOP
298:
299: IF l_debug_level > 1 THEN
300: csi_t_gen_utility_pvt.dump_org_assgn_rec(
301: p_org_assgn_rec => p_txn_org_assgn_tbl(l_ind));
302: END IF;
303:
304: l_ou_rec.txn_operating_unit_id :=

Line 356: csi_t_gen_utility_pvt.add('Validate operating unit id failed.');

352: l_valid :=
353: csi_org_unit_vld_pvt.is_valid_operating_unit_id(
354: p_operating_unit_id => l_ou_rec.operating_unit_id);
355: IF NOT (l_valid) THEN
356: csi_t_gen_utility_pvt.add('Validate operating unit id failed.');
357: RAISE fnd_api.g_exc_error;
358: END IF;
359:
360: END IF;

Line 372: csi_t_gen_utility_pvt.add('Validate ou relationship type code failed.');

368: l_valid :=
369: csi_org_unit_vld_pvt.is_valid_rel_type_code(
370: p_relationship_type_code => l_ou_rec.relationship_type_code);
371: IF NOT (l_valid) THEN
372: csi_t_gen_utility_pvt.add('Validate ou relationship type code failed.');
373: RAISE fnd_api.g_exc_error;
374: END IF;
375:
376: END IF;

Line 398: csi_t_gen_utility_pvt.add('Validate instance ou id failed.');

394: l_valid :=
395: csi_org_unit_vld_pvt.is_valid_instance_ou_id(
396: p_instance_ou_id => l_ou_rec.instance_ou_id);
397: IF (l_valid) THEN
398: csi_t_gen_utility_pvt.add('Validate instance ou id failed.');
399: RAISE fnd_api.g_exc_error;
400: END IF;
401:
402: END IF;

Line 430: csi_t_gen_utility_pvt.dump_api_info(

426:
427: --debug info
428: begin
429:
430: csi_t_gen_utility_pvt.dump_api_info(
431: p_pkg_name => 'csi_t_org_assignments_pkg',
432: p_api_name => 'update_row');
433:
434: csi_t_org_assignments_pkg.update_row(

Line 579: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

575:
576: END IF;
577:
578: --debug info
579: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
580:
581: csi_t_gen_utility_pvt.dump_api_info(
582: p_pkg_name => g_pkg_name,
583: p_api_name => l_api_name);

Line 581: csi_t_gen_utility_pvt.dump_api_info(

577:
578: --debug info
579: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
580:
581: csi_t_gen_utility_pvt.dump_api_info(
582: p_pkg_name => g_pkg_name,
583: p_api_name => l_api_name);
584:
585: csi_t_gen_utility_pvt.add(

Line 585: csi_t_gen_utility_pvt.add(

581: csi_t_gen_utility_pvt.dump_api_info(
582: p_pkg_name => g_pkg_name,
583: p_api_name => l_api_name);
584:
585: csi_t_gen_utility_pvt.add(
586: p_api_version||'-'||p_commit||'-'||p_validation_level||'-'||p_init_msg_list);
587:
588: -- Main API code
589: IF p_txn_org_assgn_ids_tbl.COUNT > 0 THEN

Line 616: csi_t_gen_utility_pvt.dump_api_info(

612:
613: END IF;
614:
615: --debug info
616: csi_t_gen_utility_pvt.dump_api_info(
617: p_api_name => 'delete_row',
618: p_pkg_name => 'csi_t_org_assignments_pkg');
619:
620: csi_t_org_assignments_pkg.delete_row(

Line 649: csi_t_gen_utility_pvt.dump_api_info(

645:
646: FOR ou_rec in ou_cur (l_line_dtl_id)
647: LOOP
648:
649: csi_t_gen_utility_pvt.dump_api_info(
650: p_api_name => 'delete_row',
651: p_pkg_name => 'csi_t_org_assignments_pkg');
652:
653: csi_t_org_assignments_pkg.delete_row(