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.

APPS.CSI_COUNTER_TEMPLATE_PUB dependencies on CSI_CTR_GEN_UTILITY_PVT

Line 74: -- csi_ctr_gen_utility_pvt.check_ib_active;

70: SAVEPOINT create_counter_group;
71:
72: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
73:
74: -- csi_ctr_gen_utility_pvt.check_ib_active;
75:
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call (l_api_version,
78: p_api_version,

Line 94: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: -- Read the debug profiles values in to global variable 7197402
94: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
95:
96: -- Check the profile option debug_level for debug message reporting
97: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
98:

Line 100: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

96: -- Check the profile option debug_level for debug message reporting
97: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
98:
99: -- If debug_level = 1 then dump the procedure name
100: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
101: csi_ctr_gen_utility_pvt.put_line( 'create_counter_group');
102: END IF;
103:
104: -- If the debug level = 2 then dump all the parameters values.

Line 101: csi_ctr_gen_utility_pvt.put_line( 'create_counter_group');

97: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
98:
99: -- If debug_level = 1 then dump the procedure name
100: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
101: csi_ctr_gen_utility_pvt.put_line( 'create_counter_group');
102: END IF;
103:
104: -- If the debug level = 2 then dump all the parameters values.
105: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 105: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

101: csi_ctr_gen_utility_pvt.put_line( 'create_counter_group');
102: END IF;
103:
104: -- If the debug level = 2 then dump all the parameters values.
105: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
106: csi_ctr_gen_utility_pvt.put_line( 'create_counter_group' ||
107: p_api_version ||'-'||
108: p_commit ||'-'||
109: p_init_msg_list ||'-'||

Line 106: csi_ctr_gen_utility_pvt.put_line( 'create_counter_group' ||

102: END IF;
103:
104: -- If the debug level = 2 then dump all the parameters values.
105: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
106: csi_ctr_gen_utility_pvt.put_line( 'create_counter_group' ||
107: p_api_version ||'-'||
108: p_commit ||'-'||
109: p_init_msg_list ||'-'||
110: p_validation_level );

Line 111: csi_ctr_gen_utility_pvt.dump_ctr_grp_rec(p_counter_groups_rec);

107: p_api_version ||'-'||
108: p_commit ||'-'||
109: p_init_msg_list ||'-'||
110: p_validation_level );
111: csi_ctr_gen_utility_pvt.dump_ctr_grp_rec(p_counter_groups_rec);
112: END IF;
113:
114: -- Calling Customer Pre-processing Hook
115: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' ) ) then

Line 136: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_COUNTER_GROUP_PRE API ');

132: x_msg_data := FND_MSG_PUB.GET
133: ( l_msg_index,
134: FND_API.G_FALSE
135: );
136: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_COUNTER_GROUP_PRE API ');
137: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
138: l_msg_index := l_msg_index + 1;
139: l_msg_count := l_msg_count - 1;
140: END LOOP;

Line 137: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

133: ( l_msg_index,
134: FND_API.G_FALSE
135: );
136: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_COUNTER_GROUP_PRE API ');
137: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
138: l_msg_index := l_msg_index + 1;
139: l_msg_count := l_msg_count - 1;
140: END LOOP;
141: RAISE FND_API.G_EXC_ERROR;

Line 167: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_PRE API ');

163: x_msg_data := FND_MSG_PUB.GET
164: ( l_msg_index,
165: FND_API.G_FALSE
166: );
167: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_PRE API ');
168: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
169: l_msg_index := l_msg_index + 1;
170: l_msg_count := l_msg_count - 1;
171: END LOOP;

Line 168: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

164: ( l_msg_index,
165: FND_API.G_FALSE
166: );
167: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_PRE API ');
168: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
169: l_msg_index := l_msg_index + 1;
170: l_msg_count := l_msg_count - 1;
171: END LOOP;
172: RAISE FND_API.G_EXC_ERROR;

Line 196: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_GROUP');

192: WHILE l_msg_count > 0 LOOP
193: x_msg_data := FND_MSG_PUB.GET
194: (l_msg_index,
195: FND_API.G_FALSE );
196: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_GROUP');
197: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
198: l_msg_index := l_msg_index + 1;
199: l_msg_count := l_msg_count - 1;
200: END LOOP;

Line 197: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

193: x_msg_data := FND_MSG_PUB.GET
194: (l_msg_index,
195: FND_API.G_FALSE );
196: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_GROUP');
197: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
198: l_msg_index := l_msg_index + 1;
199: l_msg_count := l_msg_count - 1;
200: END LOOP;
201: RAISE FND_API.G_EXC_ERROR;

Line 207: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.CREATE_COUNTER_GROUP_Post ..');

203:
204: -- Calling Post Customer User Hook
205: BEGIN
206: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
207: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.CREATE_COUNTER_GROUP_Post ..');
208: CSI_COUNTER_TEMPLATE_CUHK.CREATE_COUNTER_GROUP_Post
209: (
210: p_api_version => 1.0
211: ,p_commit => fnd_api.g_false

Line 239: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

235: --
236: END IF;
237: EXCEPTION
238: WHEN OTHERS THEN
239: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
240: RAISE FND_API.G_EXC_ERROR;
241: END;
242: --
243: -- Calling Post Vertical User Hook

Line 247: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_Post ..');

243: -- Calling Post Vertical User Hook
244: BEGIN
245:
246: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
247: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_Post ..');
248: CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_Post
249: (
250: p_api_version => 1.0
251: ,p_commit => fnd_api.g_false

Line 268: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_Post API ');

264: WHILE l_msg_count > 0 LOOP
265: x_msg_data := FND_MSG_PUB.GET
266: ( l_msg_index,
267: FND_API.G_FALSE );
268: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_Post API ');
269: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
270: l_msg_index := l_msg_index + 1;
271: l_msg_count := l_msg_count - 1;
272: END LOOP;

Line 269: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

265: x_msg_data := FND_MSG_PUB.GET
266: ( l_msg_index,
267: FND_API.G_FALSE );
268: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_Post API ');
269: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
270: l_msg_index := l_msg_index + 1;
271: l_msg_count := l_msg_count - 1;
272: END LOOP;
273: RAISE FND_API.G_EXC_ERROR;

Line 279: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

275: --
276: END IF;
277: EXCEPTION
278: WHEN OTHERS THEN
279: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
280: RAISE FND_API.G_EXC_ERROR;
281: END;
282: -- End of POST User Hooks
283:

Line 292: csi_ctr_gen_utility_pvt.put_line('inside item association..p_ctr_groups_rec = '||to_char(p_counter_groups_rec.counter_group_id));

288: LOOP
289: IF p_ctr_item_associations_tbl.EXISTS(tab_row) THEN
290: p_ctr_item_associations_tbl(tab_row).group_id := p_counter_groups_rec.counter_group_id;
291:
292: csi_ctr_gen_utility_pvt.put_line('inside item association..p_ctr_groups_rec = '||to_char(p_counter_groups_rec.counter_group_id));
293: csi_ctr_gen_utility_pvt.put_line('item group id = '||to_char(p_ctr_item_associations_tbl(tab_row).group_id));
294:
295: create_item_association
296: (

Line 293: csi_ctr_gen_utility_pvt.put_line('item group id = '||to_char(p_ctr_item_associations_tbl(tab_row).group_id));

289: IF p_ctr_item_associations_tbl.EXISTS(tab_row) THEN
290: p_ctr_item_associations_tbl(tab_row).group_id := p_counter_groups_rec.counter_group_id;
291:
292: csi_ctr_gen_utility_pvt.put_line('inside item association..p_ctr_groups_rec = '||to_char(p_counter_groups_rec.counter_group_id));
293: csi_ctr_gen_utility_pvt.put_line('item group id = '||to_char(p_ctr_item_associations_tbl(tab_row).group_id));
294:
295: create_item_association
296: (
297: p_api_version => p_api_version

Line 314: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');

310: WHILE l_msg_count > 0 LOOP
311: x_msg_data := FND_MSG_PUB.GET
312: (l_msg_index,
313: FND_API.G_FALSE);
314: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
315: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
316: l_msg_index := l_msg_index + 1;
317: l_msg_count := l_msg_count - 1;
318: END LOOP;

Line 315: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

311: x_msg_data := FND_MSG_PUB.GET
312: (l_msg_index,
313: FND_API.G_FALSE);
314: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
315: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
316: l_msg_index := l_msg_index + 1;
317: l_msg_count := l_msg_count - 1;
318: END LOOP;
319: RAISE FND_API.G_EXC_ERROR;

Line 416: -- csi_ctr_gen_utility_pvt.check_ib_active;

412: SAVEPOINT create_item_association;
413:
414: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
415:
416: -- csi_ctr_gen_utility_pvt.check_ib_active;
417:
418: -- Standard call to check for call compatibility.
419: IF NOT FND_API.Compatible_API_Call (l_api_version,
420: p_api_version,

Line 436: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

432: -- Initialize API return status to success
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434:
435: -- Read the debug profiles values in to global variable 7197402
436: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
437:
438: -- Check the profile option debug_level for debug message reporting
439: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
440:

Line 442: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

438: -- Check the profile option debug_level for debug message reporting
439: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
440:
441: -- If debug_level = 1 then dump the procedure name
442: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
443: csi_ctr_gen_utility_pvt.put_line( 'create_item_association');
444: END IF;
445:
446: -- If the debug level = 2 then dump all the parameters values.

Line 443: csi_ctr_gen_utility_pvt.put_line( 'create_item_association');

439: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
440:
441: -- If debug_level = 1 then dump the procedure name
442: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
443: csi_ctr_gen_utility_pvt.put_line( 'create_item_association');
444: END IF;
445:
446: -- If the debug level = 2 then dump all the parameters values.
447: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 447: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

443: csi_ctr_gen_utility_pvt.put_line( 'create_item_association');
444: END IF;
445:
446: -- If the debug level = 2 then dump all the parameters values.
447: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
448: csi_ctr_gen_utility_pvt.put_line('create_item_association' ||
449: p_api_version ||'-'||
450: p_commit ||'-'||
451: p_init_msg_list ||'-'||

Line 448: csi_ctr_gen_utility_pvt.put_line('create_item_association' ||

444: END IF;
445:
446: -- If the debug level = 2 then dump all the parameters values.
447: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
448: csi_ctr_gen_utility_pvt.put_line('create_item_association' ||
449: p_api_version ||'-'||
450: p_commit ||'-'||
451: p_init_msg_list ||'-'||
452: p_validation_level );

Line 453: csi_ctr_gen_utility_pvt.dump_ctr_item_assoc_rec(p_ctr_item_associations_rec);

449: p_api_version ||'-'||
450: p_commit ||'-'||
451: p_init_msg_list ||'-'||
452: p_validation_level );
453: csi_ctr_gen_utility_pvt.dump_ctr_item_assoc_rec(p_ctr_item_associations_rec);
454: END IF;
455:
456: -- Calling Customer Pre-processing Hook
457: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then

Line 477: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_PRE API ');

473: x_msg_data := FND_MSG_PUB.GET
474: ( l_msg_index,
475: FND_API.G_FALSE
476: );
477: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_PRE API ');
478: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
479: l_msg_index := l_msg_index + 1;
480: l_msg_count := l_msg_count - 1;
481: END LOOP;

Line 478: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

474: ( l_msg_index,
475: FND_API.G_FALSE
476: );
477: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_PRE API ');
478: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
479: l_msg_index := l_msg_index + 1;
480: l_msg_count := l_msg_count - 1;
481: END LOOP;
482: RAISE FND_API.G_EXC_ERROR;

Line 507: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_PRE API ');

503: x_msg_data := FND_MSG_PUB.GET
504: ( l_msg_index,
505: FND_API.G_FALSE
506: );
507: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_PRE API ');
508: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
509: l_msg_index := l_msg_index + 1;
510: l_msg_count := l_msg_count - 1;
511: END LOOP;

Line 508: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

504: ( l_msg_index,
505: FND_API.G_FALSE
506: );
507: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_PRE API ');
508: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
509: l_msg_index := l_msg_index + 1;
510: l_msg_count := l_msg_count - 1;
511: END LOOP;
512: RAISE FND_API.G_EXC_ERROR;

Line 536: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_ITEM_ASSOCIATION');

532: WHILE l_msg_count > 0 LOOP
533: x_msg_data := FND_MSG_PUB.GET
534: (l_msg_index,
535: FND_API.G_FALSE );
536: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_ITEM_ASSOCIATION');
537: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
538: l_msg_index := l_msg_index + 1;
539: l_msg_count := l_msg_count - 1;
540: END LOOP;

Line 537: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

533: x_msg_data := FND_MSG_PUB.GET
534: (l_msg_index,
535: FND_API.G_FALSE );
536: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_ITEM_ASSOCIATION');
537: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
538: l_msg_index := l_msg_index + 1;
539: l_msg_count := l_msg_count - 1;
540: END LOOP;
541: RAISE FND_API.G_EXC_ERROR;

Line 547: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_Post ..');

543:
544: -- Calling Post Customer User Hook
545: BEGIN
546: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
547: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_Post ..');
548: CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_Post
549: (
550: p_api_version => 1.0
551: ,p_commit => fnd_api.g_false

Line 578: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

574: --
575: END IF;
576: EXCEPTION
577: WHEN OTHERS THEN
578: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
579: RAISE FND_API.G_EXC_ERROR;
580: END;
581: --
582: -- Calling Post Vertical User Hook

Line 586: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_Post ..');

582: -- Calling Post Vertical User Hook
583: BEGIN
584:
585: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
586: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_Post ..');
587: CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_Post
588: (
589: p_api_version => 1.0
590: ,p_commit => fnd_api.g_false

Line 606: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_Post API ');

602: WHILE l_msg_count > 0 LOOP
603: x_msg_data := FND_MSG_PUB.GET
604: ( l_msg_index,
605: FND_API.G_FALSE );
606: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_Post API ');
607: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
608: l_msg_index := l_msg_index + 1;
609: l_msg_count := l_msg_count - 1;
610: END LOOP;

Line 607: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

603: x_msg_data := FND_MSG_PUB.GET
604: ( l_msg_index,
605: FND_API.G_FALSE );
606: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_Post API ');
607: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
608: l_msg_index := l_msg_index + 1;
609: l_msg_count := l_msg_count - 1;
610: END LOOP;
611: RAISE FND_API.G_EXC_ERROR;

Line 617: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

613: --
614: END IF;
615: EXCEPTION
616: WHEN OTHERS THEN
617: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
618: RAISE FND_API.G_EXC_ERROR;
619: END;
620: -- End of POST User Hooks
621:

Line 721: -- csi_ctr_gen_utility_pvt.check_ib_active;

717: SAVEPOINT create_counter_template ;
718:
719: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
720:
721: -- csi_ctr_gen_utility_pvt.check_ib_active;
722:
723: -- Standard call to check for call compatibility.
724: IF NOT FND_API.Compatible_API_Call (l_api_version,
725: p_api_version,

Line 741: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

737: -- Initialize API return status to success
738: x_return_status := FND_API.G_RET_STS_SUCCESS;
739:
740: -- Read the debug profiles values in to global variable 7197402
741: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
742:
743: -- Check the profile option debug_level for debug message reporting
744: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
745:

Line 747: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

743: -- Check the profile option debug_level for debug message reporting
744: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
745:
746: -- If debug_level = 1 then dump the procedure name
747: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
748: csi_ctr_gen_utility_pvt.put_line( 'create_counter_template');
749: END IF;
750:
751: -- If the debug level = 2 then dump all the parameters values.

Line 748: csi_ctr_gen_utility_pvt.put_line( 'create_counter_template');

744: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
745:
746: -- If debug_level = 1 then dump the procedure name
747: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
748: csi_ctr_gen_utility_pvt.put_line( 'create_counter_template');
749: END IF;
750:
751: -- If the debug level = 2 then dump all the parameters values.
752: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 752: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

748: csi_ctr_gen_utility_pvt.put_line( 'create_counter_template');
749: END IF;
750:
751: -- If the debug level = 2 then dump all the parameters values.
752: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
753: csi_ctr_gen_utility_pvt.put_line( 'create_counter_template' ||
754: p_api_version ||'-'||
755: p_commit ||'-'||
756: p_init_msg_list ||'-'||

Line 753: csi_ctr_gen_utility_pvt.put_line( 'create_counter_template' ||

749: END IF;
750:
751: -- If the debug level = 2 then dump all the parameters values.
752: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
753: csi_ctr_gen_utility_pvt.put_line( 'create_counter_template' ||
754: p_api_version ||'-'||
755: p_commit ||'-'||
756: p_init_msg_list ||'-'||
757: p_validation_level );

Line 758: csi_ctr_gen_utility_pvt.dump_ctr_template_rec(p_counter_template_rec);

754: p_api_version ||'-'||
755: p_commit ||'-'||
756: p_init_msg_list ||'-'||
757: p_validation_level );
758: csi_ctr_gen_utility_pvt.dump_ctr_template_rec(p_counter_template_rec);
759: END IF;
760:
761: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
762: CSI_COUNTER_TEMPLATE_CUHK.create_counter_template_pre

Line 785: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_counter_template_pre API ');

781: x_msg_data := FND_MSG_PUB.GET
782: ( l_msg_index,
783: FND_API.G_FALSE
784: );
785: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_counter_template_pre API ');
786: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
787: l_msg_index := l_msg_index + 1;
788: l_msg_count := l_msg_count - 1;
789: END LOOP;

Line 786: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

782: ( l_msg_index,
783: FND_API.G_FALSE
784: );
785: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_counter_template_pre API ');
786: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
787: l_msg_index := l_msg_index + 1;
788: l_msg_count := l_msg_count - 1;
789: END LOOP;
790: RAISE FND_API.G_EXC_ERROR;

Line 819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_pre API ');

815: x_msg_data := FND_MSG_PUB.GET
816: ( l_msg_index,
817: FND_API.G_FALSE
818: );
819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_pre API ');
820: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
821: l_msg_index := l_msg_index + 1;
822: l_msg_count := l_msg_count - 1;
823: END LOOP;

Line 820: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

816: ( l_msg_index,
817: FND_API.G_FALSE
818: );
819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_pre API ');
820: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
821: l_msg_index := l_msg_index + 1;
822: l_msg_count := l_msg_count - 1;
823: END LOOP;
824: RAISE FND_API.G_EXC_ERROR;

Line 848: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_TEMPLATE');

844: WHILE l_msg_count > 0 LOOP
845: x_msg_data := FND_MSG_PUB.GET
846: (l_msg_index,
847: FND_API.G_FALSE );
848: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_TEMPLATE');
849: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
850: l_msg_index := l_msg_index + 1;
851: l_msg_count := l_msg_count - 1;
852: END LOOP;

Line 849: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

845: x_msg_data := FND_MSG_PUB.GET
846: (l_msg_index,
847: FND_API.G_FALSE );
848: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_TEMPLATE');
849: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
850: l_msg_index := l_msg_index + 1;
851: l_msg_count := l_msg_count - 1;
852: END LOOP;
853: RAISE FND_API.G_EXC_ERROR;

Line 859: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post ..');

855:
856: -- Calling Post Customer User Hook
857: BEGIN
858: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
859: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post ..');
860: CSI_COUNTER_TEMPLATE_CUHK.create_counter_template_Post
861: (
862: p_api_version => 1.0
863: ,p_commit => fnd_api.g_false

Line 894: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

890: --
891: END IF;
892: EXCEPTION
893: WHEN OTHERS THEN
894: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
895: RAISE FND_API.G_EXC_ERROR;
896: END;
897: --
898: -- Calling Post Vertical User Hook

Line 902: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post ..');

898: -- Calling Post Vertical User Hook
899: BEGIN
900:
901: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
902: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post ..');
903: CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post
904: (
905: p_api_version => 1.0
906: ,p_commit => fnd_api.g_false

Line 926: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post API ');

922: WHILE l_msg_count > 0 LOOP
923: x_msg_data := FND_MSG_PUB.GET
924: ( l_msg_index,
925: FND_API.G_FALSE );
926: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post API ');
927: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
928: l_msg_index := l_msg_index + 1;
929: l_msg_count := l_msg_count - 1;
930: END LOOP;

Line 927: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

923: x_msg_data := FND_MSG_PUB.GET
924: ( l_msg_index,
925: FND_API.G_FALSE );
926: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post API ');
927: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
928: l_msg_index := l_msg_index + 1;
929: l_msg_count := l_msg_count - 1;
930: END LOOP;
931: RAISE FND_API.G_EXC_ERROR;

Line 937: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

933: --
934: END IF;
935: EXCEPTION
936: WHEN OTHERS THEN
937: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
938: RAISE FND_API.G_EXC_ERROR;
939: END;
940: -- End of POST User Hooks
941:

Line 968: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');

964: WHILE l_msg_count > 0 LOOP
965: x_msg_data := FND_MSG_PUB.GET
966: (l_msg_index,
967: FND_API.G_FALSE);
968: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
969: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
970: l_msg_index := l_msg_index + 1;
971: l_msg_count := l_msg_count - 1;
972: END LOOP;

Line 969: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

965: x_msg_data := FND_MSG_PUB.GET
966: (l_msg_index,
967: FND_API.G_FALSE);
968: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
969: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
970: l_msg_index := l_msg_index + 1;
971: l_msg_count := l_msg_count - 1;
972: END LOOP;
973: RAISE FND_API.G_EXC_ERROR;

Line 1004: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');

1000: WHILE l_msg_count > 0 LOOP
1001: x_msg_data := FND_MSG_PUB.GET
1002: (l_msg_index,
1003: FND_API.G_FALSE);
1004: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');
1005: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1006: l_msg_index := l_msg_index + 1;
1007: l_msg_count := l_msg_count - 1;
1008: END LOOP;

Line 1005: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1001: x_msg_data := FND_MSG_PUB.GET
1002: (l_msg_index,
1003: FND_API.G_FALSE);
1004: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');
1005: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1006: l_msg_index := l_msg_index + 1;
1007: l_msg_count := l_msg_count - 1;
1008: END LOOP;
1009: RAISE FND_API.G_EXC_ERROR;

Line 1018: csi_ctr_gen_utility_pvt.put_line(' Inside formula validation ');

1014:
1015: IF p_counter_template_rec.counter_type = 'FORMULA' AND
1016: p_counter_template_rec.derive_function IS NULL THEN
1017:
1018: csi_ctr_gen_utility_pvt.put_line(' Inside formula validation ');
1019: csi_ctr_gen_utility_pvt.put_line(' tbl count = '||to_char(p_counter_relationships_tbl.count));
1020: IF nvl(p_counter_relationships_tbl.count,0) = 0 THEN
1021: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_REQ_FORMULA_REF');
1022: END IF;

Line 1019: csi_ctr_gen_utility_pvt.put_line(' tbl count = '||to_char(p_counter_relationships_tbl.count));

1015: IF p_counter_template_rec.counter_type = 'FORMULA' AND
1016: p_counter_template_rec.derive_function IS NULL THEN
1017:
1018: csi_ctr_gen_utility_pvt.put_line(' Inside formula validation ');
1019: csi_ctr_gen_utility_pvt.put_line(' tbl count = '||to_char(p_counter_relationships_tbl.count));
1020: IF nvl(p_counter_relationships_tbl.count,0) = 0 THEN
1021: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_REQ_FORMULA_REF');
1022: END IF;
1023: END IF;

Line 1021: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_REQ_FORMULA_REF');

1017:
1018: csi_ctr_gen_utility_pvt.put_line(' Inside formula validation ');
1019: csi_ctr_gen_utility_pvt.put_line(' tbl count = '||to_char(p_counter_relationships_tbl.count));
1020: IF nvl(p_counter_relationships_tbl.count,0) = 0 THEN
1021: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_REQ_FORMULA_REF');
1022: END IF;
1023: END IF;
1024:
1025: IF (p_counter_relationships_tbl.count > 0) THEN

Line 1050: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');

1046: WHILE l_msg_count > 0 LOOP
1047: x_msg_data := FND_MSG_PUB.GET
1048: (l_msg_index,
1049: FND_API.G_FALSE);
1050: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');
1051: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1052: l_msg_index := l_msg_index + 1;
1053: l_msg_count := l_msg_count - 1;
1054: END LOOP;

Line 1051: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1047: x_msg_data := FND_MSG_PUB.GET
1048: (l_msg_index,
1049: FND_API.G_FALSE);
1050: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');
1051: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1052: l_msg_index := l_msg_index + 1;
1053: l_msg_count := l_msg_count - 1;
1054: END LOOP;
1055: RAISE FND_API.G_EXC_ERROR;

Line 1088: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_DERIVED_FILTERS');

1084: WHILE l_msg_count > 0 LOOP
1085: x_msg_data := FND_MSG_PUB.GET
1086: (l_msg_index,
1087: FND_API.G_FALSE);
1088: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_DERIVED_FILTERS');
1089: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1090: l_msg_index := l_msg_index + 1;
1091: l_msg_count := l_msg_count - 1;
1092: END LOOP;

Line 1089: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1085: x_msg_data := FND_MSG_PUB.GET
1086: (l_msg_index,
1087: FND_API.G_FALSE);
1088: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_DERIVED_FILTERS');
1089: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1090: l_msg_index := l_msg_index + 1;
1091: l_msg_count := l_msg_count - 1;
1092: END LOOP;
1093: RAISE FND_API.G_EXC_ERROR;

Line 1188: -- csi_ctr_gen_utility_pvt.check_ib_active;

1184: SAVEPOINT create_ctr_property_template;
1185:
1186: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
1187:
1188: -- csi_ctr_gen_utility_pvt.check_ib_active;
1189:
1190: -- Standard call to check for call compatibility.
1191: IF NOT FND_API.Compatible_API_Call (l_api_version,
1192: p_api_version,

Line 1208: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1204: -- Initialize API return status to success
1205: x_return_status := FND_API.G_RET_STS_SUCCESS;
1206:
1207: -- Read the debug profiles values in to global variable 7197402
1208: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1209:
1210: -- Check the profile option debug_level for debug message reporting
1211: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1212:

Line 1214: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

1210: -- Check the profile option debug_level for debug message reporting
1211: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1212:
1213: -- If debug_level = 1 then dump the procedure name
1214: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
1215: csi_ctr_gen_utility_pvt.put_line( 'create_ctr_property_template');
1216: END IF;
1217:
1218: -- If the debug level = 2 then dump all the parameters values.

Line 1215: csi_ctr_gen_utility_pvt.put_line( 'create_ctr_property_template');

1211: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1212:
1213: -- If debug_level = 1 then dump the procedure name
1214: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
1215: csi_ctr_gen_utility_pvt.put_line( 'create_ctr_property_template');
1216: END IF;
1217:
1218: -- If the debug level = 2 then dump all the parameters values.
1219: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 1219: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

1215: csi_ctr_gen_utility_pvt.put_line( 'create_ctr_property_template');
1216: END IF;
1217:
1218: -- If the debug level = 2 then dump all the parameters values.
1219: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
1220: csi_ctr_gen_utility_pvt.put_line( 'create_ctr_property_template' ||
1221: p_api_version ||'-'||
1222: p_commit ||'-'||
1223: p_init_msg_list ||'-'||

Line 1220: csi_ctr_gen_utility_pvt.put_line( 'create_ctr_property_template' ||

1216: END IF;
1217:
1218: -- If the debug level = 2 then dump all the parameters values.
1219: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
1220: csi_ctr_gen_utility_pvt.put_line( 'create_ctr_property_template' ||
1221: p_api_version ||'-'||
1222: p_commit ||'-'||
1223: p_init_msg_list ||'-'||
1224: p_validation_level );

Line 1225: csi_ctr_gen_utility_pvt.dump_ctr_property_template_rec(p_ctr_property_template_rec);

1221: p_api_version ||'-'||
1222: p_commit ||'-'||
1223: p_init_msg_list ||'-'||
1224: p_validation_level );
1225: csi_ctr_gen_utility_pvt.dump_ctr_property_template_rec(p_ctr_property_template_rec);
1226: END IF;
1227:
1228: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
1229: CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_pre

Line 1248: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_pre API ');

1244: x_msg_data := FND_MSG_PUB.GET
1245: ( l_msg_index,
1246: FND_API.G_FALSE
1247: );
1248: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_pre API ');
1249: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1250: l_msg_index := l_msg_index + 1;
1251: l_msg_count := l_msg_count - 1;
1252: END LOOP;

Line 1249: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1245: ( l_msg_index,
1246: FND_API.G_FALSE
1247: );
1248: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_pre API ');
1249: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1250: l_msg_index := l_msg_index + 1;
1251: l_msg_count := l_msg_count - 1;
1252: END LOOP;
1253: RAISE FND_API.G_EXC_ERROR;

Line 1278: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_pre API ');

1274: x_msg_data := FND_MSG_PUB.GET
1275: ( l_msg_index,
1276: FND_API.G_FALSE
1277: );
1278: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_pre API ');
1279: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1280: l_msg_index := l_msg_index + 1;
1281: l_msg_count := l_msg_count - 1;
1282: END LOOP;

Line 1279: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1275: ( l_msg_index,
1276: FND_API.G_FALSE
1277: );
1278: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_pre API ');
1279: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1280: l_msg_index := l_msg_index + 1;
1281: l_msg_count := l_msg_count - 1;
1282: END LOOP;
1283: RAISE FND_API.G_EXC_ERROR;

Line 1307: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_CTR_PROPERTY_TEMPLATE');

1303: WHILE l_msg_count > 0 LOOP
1304: x_msg_data := FND_MSG_PUB.GET
1305: (l_msg_index,
1306: FND_API.G_FALSE );
1307: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_CTR_PROPERTY_TEMPLATE');
1308: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1309: l_msg_index := l_msg_index + 1;
1310: l_msg_count := l_msg_count - 1;
1311: END LOOP;

Line 1308: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1304: x_msg_data := FND_MSG_PUB.GET
1305: (l_msg_index,
1306: FND_API.G_FALSE );
1307: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_CTR_PROPERTY_TEMPLATE');
1308: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1309: l_msg_index := l_msg_index + 1;
1310: l_msg_count := l_msg_count - 1;
1311: END LOOP;
1312: RAISE FND_API.G_EXC_ERROR;

Line 1318: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_Post ..');

1314:
1315: -- Calling Post Customer User Hook
1316: BEGIN
1317: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
1318: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_Post ..');
1319: CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_Post
1320: (
1321: p_api_version => 1.0
1322: ,p_commit => fnd_api.g_false

Line 1349: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

1345: --
1346: END IF;
1347: EXCEPTION
1348: WHEN OTHERS THEN
1349: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
1350: RAISE FND_API.G_EXC_ERROR;
1351: END;
1352: --
1353: -- Calling Post Vertical User Hook

Line 1357: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_Post ..');

1353: -- Calling Post Vertical User Hook
1354: BEGIN
1355:
1356: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
1357: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_Post ..');
1358: CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_Post
1359: (
1360: p_api_version => 1.0
1361: ,p_commit => fnd_api.g_false

Line 1377: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_Post API ');

1373: WHILE l_msg_count > 0 LOOP
1374: x_msg_data := FND_MSG_PUB.GET
1375: ( l_msg_index,
1376: FND_API.G_FALSE );
1377: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_Post API ');
1378: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1379: l_msg_index := l_msg_index + 1;
1380: l_msg_count := l_msg_count - 1;
1381: END LOOP;

Line 1378: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1374: x_msg_data := FND_MSG_PUB.GET
1375: ( l_msg_index,
1376: FND_API.G_FALSE );
1377: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_Post API ');
1378: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1379: l_msg_index := l_msg_index + 1;
1380: l_msg_count := l_msg_count - 1;
1381: END LOOP;
1382: RAISE FND_API.G_EXC_ERROR;

Line 1388: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

1384: --
1385: END IF;
1386: EXCEPTION
1387: WHEN OTHERS THEN
1388: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
1389: RAISE FND_API.G_EXC_ERROR;
1390: END;
1391: -- End of POST User Hooks
1392:

Line 1482: -- csi_ctr_gen_utility_pvt.check_ib_active;

1478: SAVEPOINT create_counter_relationship;
1479:
1480: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
1481:
1482: -- csi_ctr_gen_utility_pvt.check_ib_active;
1483:
1484: -- Standard call to check for call compatibility.
1485: IF NOT FND_API.Compatible_API_Call (l_api_version,
1486: p_api_version,

Line 1502: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1498: -- Initialize API return status to success
1499: x_return_status := FND_API.G_RET_STS_SUCCESS;
1500:
1501: -- Read the debug profiles values in to global variable 7197402
1502: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1503:
1504: -- Check the profile option debug_level for debug message reporting
1505: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1506:

Line 1508: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

1504: -- Check the profile option debug_level for debug message reporting
1505: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1506:
1507: -- If debug_level = 1 then dump the procedure name
1508: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
1509: csi_ctr_gen_utility_pvt.put_line( 'create_counter_relationship');
1510: END IF;
1511:
1512: -- If the debug level = 2 then dump all the parameters values.

Line 1509: csi_ctr_gen_utility_pvt.put_line( 'create_counter_relationship');

1505: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1506:
1507: -- If debug_level = 1 then dump the procedure name
1508: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
1509: csi_ctr_gen_utility_pvt.put_line( 'create_counter_relationship');
1510: END IF;
1511:
1512: -- If the debug level = 2 then dump all the parameters values.
1513: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 1513: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

1509: csi_ctr_gen_utility_pvt.put_line( 'create_counter_relationship');
1510: END IF;
1511:
1512: -- If the debug level = 2 then dump all the parameters values.
1513: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
1514: csi_ctr_gen_utility_pvt.put_line( 'create_counter_relationship' ||
1515: p_api_version ||'-'||
1516: p_commit ||'-'||
1517: p_init_msg_list ||'-'||

Line 1514: csi_ctr_gen_utility_pvt.put_line( 'create_counter_relationship' ||

1510: END IF;
1511:
1512: -- If the debug level = 2 then dump all the parameters values.
1513: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
1514: csi_ctr_gen_utility_pvt.put_line( 'create_counter_relationship' ||
1515: p_api_version ||'-'||
1516: p_commit ||'-'||
1517: p_init_msg_list ||'-'||
1518: p_validation_level );

Line 1519: csi_ctr_gen_utility_pvt.dump_ctr_relationship_rec(p_counter_relationships_rec);

1515: p_api_version ||'-'||
1516: p_commit ||'-'||
1517: p_init_msg_list ||'-'||
1518: p_validation_level );
1519: csi_ctr_gen_utility_pvt.dump_ctr_relationship_rec(p_counter_relationships_rec);
1520: END IF;
1521:
1522: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
1523: CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_pre

Line 1542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_pre API ');

1538: x_msg_data := FND_MSG_PUB.GET
1539: ( l_msg_index,
1540: FND_API.G_FALSE
1541: );
1542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_pre API ');
1543: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1544: l_msg_index := l_msg_index + 1;
1545: l_msg_count := l_msg_count - 1;
1546: END LOOP;

Line 1543: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1539: ( l_msg_index,
1540: FND_API.G_FALSE
1541: );
1542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_pre API ');
1543: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1544: l_msg_index := l_msg_index + 1;
1545: l_msg_count := l_msg_count - 1;
1546: END LOOP;
1547: RAISE FND_API.G_EXC_ERROR;

Line 1572: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_pre API ');

1568: x_msg_data := FND_MSG_PUB.GET
1569: ( l_msg_index,
1570: FND_API.G_FALSE
1571: );
1572: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_pre API ');
1573: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1574: l_msg_index := l_msg_index + 1;
1575: l_msg_count := l_msg_count - 1;
1576: END LOOP;

Line 1573: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1569: ( l_msg_index,
1570: FND_API.G_FALSE
1571: );
1572: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_pre API ');
1573: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1574: l_msg_index := l_msg_index + 1;
1575: l_msg_count := l_msg_count - 1;
1576: END LOOP;
1577: RAISE FND_API.G_EXC_ERROR;

Line 1601: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP');

1597: WHILE l_msg_count > 0 LOOP
1598: x_msg_data := FND_MSG_PUB.GET
1599: (l_msg_index,
1600: FND_API.G_FALSE );
1601: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP');
1602: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1603: l_msg_index := l_msg_index + 1;
1604: l_msg_count := l_msg_count - 1;
1605: END LOOP;

Line 1602: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1598: x_msg_data := FND_MSG_PUB.GET
1599: (l_msg_index,
1600: FND_API.G_FALSE );
1601: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP');
1602: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1603: l_msg_index := l_msg_index + 1;
1604: l_msg_count := l_msg_count - 1;
1605: END LOOP;
1606: RAISE FND_API.G_EXC_ERROR;

Line 1612: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_Post ..');

1608:
1609: -- Calling Post Customer User Hook
1610: BEGIN
1611: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
1612: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_Post ..');
1613: CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_Post
1614: (
1615: p_api_version => 1.0
1616: ,p_commit => fnd_api.g_false

Line 1643: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

1639: --
1640: END IF;
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
1644: RAISE FND_API.G_EXC_ERROR;
1645: END;
1646: --
1647: -- Calling Post Vertical User Hook

Line 1651: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_Post ..');

1647: -- Calling Post Vertical User Hook
1648: BEGIN
1649:
1650: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
1651: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_Post ..');
1652: CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_Post
1653: (
1654: p_api_version => 1.0
1655: ,p_commit => fnd_api.g_false

Line 1671: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_Post API ');

1667: WHILE l_msg_count > 0 LOOP
1668: x_msg_data := FND_MSG_PUB.GET
1669: ( l_msg_index,
1670: FND_API.G_FALSE );
1671: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_Post API ');
1672: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1673: l_msg_index := l_msg_index + 1;
1674: l_msg_count := l_msg_count - 1;
1675: END LOOP;

Line 1672: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1668: x_msg_data := FND_MSG_PUB.GET
1669: ( l_msg_index,
1670: FND_API.G_FALSE );
1671: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_Post API ');
1672: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1673: l_msg_index := l_msg_index + 1;
1674: l_msg_count := l_msg_count - 1;
1675: END LOOP;
1676: RAISE FND_API.G_EXC_ERROR;

Line 1682: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

1678: --
1679: END IF;
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
1683: RAISE FND_API.G_EXC_ERROR;
1684: END;
1685: -- End of POST User Hooks
1686:

Line 1771: -- csi_ctr_gen_utility_pvt.check_ib_active;

1767: SAVEPOINT create_derived_filters;
1768:
1769: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
1770:
1771: -- csi_ctr_gen_utility_pvt.check_ib_active;
1772:
1773: -- Standard call to check for call compatibility.
1774: IF NOT FND_API.Compatible_API_Call (l_api_version,
1775: p_api_version,

Line 1791: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

1787: -- Initialize API return status to success
1788: x_return_status := FND_API.G_RET_STS_SUCCESS;
1789:
1790: -- Read the debug profiles values in to global variable 7197402
1791: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1792:
1793: -- Check the profile option debug_level for debug message reporting
1794: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1795:

Line 1797: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

1793: -- Check the profile option debug_level for debug message reporting
1794: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1795:
1796: -- If debug_level = 1 then dump the procedure name
1797: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
1798: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');
1799: END IF;
1800:
1801: -- If the debug level = 2 then dump all the parameters values.

Line 1798: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');

1794: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1795:
1796: -- If debug_level = 1 then dump the procedure name
1797: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
1798: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');
1799: END IF;
1800:
1801: -- If the debug level = 2 then dump all the parameters values.
1802: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 1802: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

1798: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');
1799: END IF;
1800:
1801: -- If the debug level = 2 then dump all the parameters values.
1802: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
1803: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters' ||
1804: p_api_version ||'-'||
1805: p_commit ||'-'||
1806: p_init_msg_list ||'-'||

Line 1803: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters' ||

1799: END IF;
1800:
1801: -- If the debug level = 2 then dump all the parameters values.
1802: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
1803: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters' ||
1804: p_api_version ||'-'||
1805: p_commit ||'-'||
1806: p_init_msg_list ||'-'||
1807: p_validation_level );

Line 1808: csi_ctr_gen_utility_pvt.dump_ctr_derived_filters_tbl(p_ctr_derived_filters_tbl);

1804: p_api_version ||'-'||
1805: p_commit ||'-'||
1806: p_init_msg_list ||'-'||
1807: p_validation_level );
1808: csi_ctr_gen_utility_pvt.dump_ctr_derived_filters_tbl(p_ctr_derived_filters_tbl);
1809: END IF;
1810:
1811: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
1812: CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_pre

Line 1831: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_pre API ');

1827: x_msg_data := FND_MSG_PUB.GET
1828: ( l_msg_index,
1829: FND_API.G_FALSE
1830: );
1831: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_pre API ');
1832: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1833: l_msg_index := l_msg_index + 1;
1834: l_msg_count := l_msg_count - 1;
1835: END LOOP;

Line 1832: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1828: ( l_msg_index,
1829: FND_API.G_FALSE
1830: );
1831: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_pre API ');
1832: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1833: l_msg_index := l_msg_index + 1;
1834: l_msg_count := l_msg_count - 1;
1835: END LOOP;
1836: RAISE FND_API.G_EXC_ERROR;

Line 1861: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_pre API ');

1857: x_msg_data := FND_MSG_PUB.GET
1858: ( l_msg_index,
1859: FND_API.G_FALSE
1860: );
1861: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_pre API ');
1862: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1863: l_msg_index := l_msg_index + 1;
1864: l_msg_count := l_msg_count - 1;
1865: END LOOP;

Line 1862: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1858: ( l_msg_index,
1859: FND_API.G_FALSE
1860: );
1861: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_pre API ');
1862: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1863: l_msg_index := l_msg_index + 1;
1864: l_msg_count := l_msg_count - 1;
1865: END LOOP;
1866: RAISE FND_API.G_EXC_ERROR;

Line 1890: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');

1886: WHILE l_msg_count > 0 LOOP
1887: x_msg_data := FND_MSG_PUB.GET
1888: (l_msg_index,
1889: FND_API.G_FALSE );
1890: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
1891: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1892: l_msg_index := l_msg_index + 1;
1893: l_msg_count := l_msg_count - 1;
1894: END LOOP;

Line 1891: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1887: x_msg_data := FND_MSG_PUB.GET
1888: (l_msg_index,
1889: FND_API.G_FALSE );
1890: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
1891: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1892: l_msg_index := l_msg_index + 1;
1893: l_msg_count := l_msg_count - 1;
1894: END LOOP;
1895: RAISE FND_API.G_EXC_ERROR;

Line 1901: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_Post ..');

1897:
1898: -- Calling Post Customer User Hook
1899: BEGIN
1900: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
1901: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_Post ..');
1902: CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_Post
1903: (
1904: p_api_version => 1.0
1905: ,p_commit => fnd_api.g_false

Line 1932: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

1928: --
1929: END IF;
1930: EXCEPTION
1931: WHEN OTHERS THEN
1932: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
1933: RAISE FND_API.G_EXC_ERROR;
1934: END;
1935: --
1936: -- Calling Post Vertical User Hook

Line 1940: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_Post ..');

1936: -- Calling Post Vertical User Hook
1937: BEGIN
1938:
1939: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
1940: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_Post ..');
1941: CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_Post
1942: (
1943: p_api_version => 1.0
1944: ,p_commit => fnd_api.g_false

Line 1960: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_Post API ');

1956: WHILE l_msg_count > 0 LOOP
1957: x_msg_data := FND_MSG_PUB.GET
1958: ( l_msg_index,
1959: FND_API.G_FALSE );
1960: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_Post API ');
1961: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1962: l_msg_index := l_msg_index + 1;
1963: l_msg_count := l_msg_count - 1;
1964: END LOOP;

Line 1961: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

1957: x_msg_data := FND_MSG_PUB.GET
1958: ( l_msg_index,
1959: FND_API.G_FALSE );
1960: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_Post API ');
1961: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1962: l_msg_index := l_msg_index + 1;
1963: l_msg_count := l_msg_count - 1;
1964: END LOOP;
1965: RAISE FND_API.G_EXC_ERROR;

Line 1971: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

1967: --
1968: END IF;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
1972: RAISE FND_API.G_EXC_ERROR;
1973: END;
1974: -- End of POST User Hooks
1975: -- End of API body

Line 2077: -- csi_ctr_gen_utility_pvt.check_ib_active;

2073: SAVEPOINT update_counter_group;
2074:
2075: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2076:
2077: -- csi_ctr_gen_utility_pvt.check_ib_active;
2078:
2079: -- Standard call to check for call compatibility.
2080: IF NOT FND_API.Compatible_API_Call (l_api_version,
2081: p_api_version,

Line 2097: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2093: -- Initialize API return status to success
2094: x_return_status := FND_API.G_RET_STS_SUCCESS;
2095:
2096: -- Read the debug profiles values in to global variable 7197402
2097: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2098:
2099: -- Check the profile option debug_level for debug message reporting
2100: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2101:

Line 2103: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

2099: -- Check the profile option debug_level for debug message reporting
2100: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2101:
2102: -- If debug_level = 1 then dump the procedure name
2103: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
2104: csi_ctr_gen_utility_pvt.put_line( 'update_counter_group');
2105: END IF;
2106:
2107: -- If the debug level = 2 then dump all the parameters values.

Line 2104: csi_ctr_gen_utility_pvt.put_line( 'update_counter_group');

2100: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2101:
2102: -- If debug_level = 1 then dump the procedure name
2103: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
2104: csi_ctr_gen_utility_pvt.put_line( 'update_counter_group');
2105: END IF;
2106:
2107: -- If the debug level = 2 then dump all the parameters values.
2108: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 2108: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

2104: csi_ctr_gen_utility_pvt.put_line( 'update_counter_group');
2105: END IF;
2106:
2107: -- If the debug level = 2 then dump all the parameters values.
2108: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
2109: csi_ctr_gen_utility_pvt.put_line( 'update_counter_group' ||
2110: p_api_version ||'-'||
2111: p_commit ||'-'||
2112: p_init_msg_list ||'-'||

Line 2109: csi_ctr_gen_utility_pvt.put_line( 'update_counter_group' ||

2105: END IF;
2106:
2107: -- If the debug level = 2 then dump all the parameters values.
2108: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
2109: csi_ctr_gen_utility_pvt.put_line( 'update_counter_group' ||
2110: p_api_version ||'-'||
2111: p_commit ||'-'||
2112: p_init_msg_list ||'-'||
2113: p_validation_level );

Line 2114: csi_ctr_gen_utility_pvt.dump_ctr_grp_rec(p_counter_groups_rec);

2110: p_api_version ||'-'||
2111: p_commit ||'-'||
2112: p_init_msg_list ||'-'||
2113: p_validation_level );
2114: csi_ctr_gen_utility_pvt.dump_ctr_grp_rec(p_counter_groups_rec);
2115: END IF;
2116:
2117: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
2118: CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre

Line 2138: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre API ');

2134: x_msg_data := FND_MSG_PUB.GET
2135: ( l_msg_index,
2136: FND_API.G_FALSE
2137: );
2138: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre API ');
2139: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2140: l_msg_index := l_msg_index + 1;
2141: l_msg_count := l_msg_count - 1;
2142: END LOOP;

Line 2139: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2135: ( l_msg_index,
2136: FND_API.G_FALSE
2137: );
2138: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre API ');
2139: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2140: l_msg_index := l_msg_index + 1;
2141: l_msg_count := l_msg_count - 1;
2142: END LOOP;
2143: RAISE FND_API.G_EXC_ERROR;

Line 2169: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_pre API ');

2165: x_msg_data := FND_MSG_PUB.GET
2166: ( l_msg_index,
2167: FND_API.G_FALSE
2168: );
2169: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_pre API ');
2170: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2171: l_msg_index := l_msg_index + 1;
2172: l_msg_count := l_msg_count - 1;
2173: END LOOP;

Line 2170: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2166: ( l_msg_index,
2167: FND_API.G_FALSE
2168: );
2169: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_pre API ');
2170: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2171: l_msg_index := l_msg_index + 1;
2172: l_msg_count := l_msg_count - 1;
2173: END LOOP;
2174: RAISE FND_API.G_EXC_ERROR;

Line 2198: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_GROUP');

2194: WHILE l_msg_count > 0 LOOP
2195: x_msg_data := FND_MSG_PUB.GET
2196: (l_msg_index,
2197: FND_API.G_FALSE );
2198: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_GROUP');
2199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2200: l_msg_index := l_msg_index + 1;
2201: l_msg_count := l_msg_count - 1;
2202: END LOOP;

Line 2199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2195: x_msg_data := FND_MSG_PUB.GET
2196: (l_msg_index,
2197: FND_API.G_FALSE );
2198: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_GROUP');
2199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2200: l_msg_index := l_msg_index + 1;
2201: l_msg_count := l_msg_count - 1;
2202: END LOOP;
2203: RAISE FND_API.G_EXC_ERROR;

Line 2209: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post ..');

2205:
2206: -- Calling Post Customer User Hook
2207: BEGIN
2208: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
2209: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post ..');
2210: CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post
2211: (
2212: p_api_version => 1.0
2213: ,p_commit => fnd_api.g_false

Line 2241: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

2237: --
2238: END IF;
2239: EXCEPTION
2240: WHEN OTHERS THEN
2241: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
2242: RAISE FND_API.G_EXC_ERROR;
2243: END;
2244: --
2245: -- Calling Post Vertical User Hook

Line 2249: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post ..');

2245: -- Calling Post Vertical User Hook
2246: BEGIN
2247:
2248: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
2249: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post ..');
2250: CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post
2251: (
2252: p_api_version => 1.0
2253: ,p_commit => fnd_api.g_false

Line 2270: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post API ');

2266: WHILE l_msg_count > 0 LOOP
2267: x_msg_data := FND_MSG_PUB.GET
2268: ( l_msg_index,
2269: FND_API.G_FALSE );
2270: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post API ');
2271: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2272: l_msg_index := l_msg_index + 1;
2273: l_msg_count := l_msg_count - 1;
2274: END LOOP;

Line 2271: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2267: x_msg_data := FND_MSG_PUB.GET
2268: ( l_msg_index,
2269: FND_API.G_FALSE );
2270: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post API ');
2271: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2272: l_msg_index := l_msg_index + 1;
2273: l_msg_count := l_msg_count - 1;
2274: END LOOP;
2275: RAISE FND_API.G_EXC_ERROR;

Line 2281: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

2277: --
2278: END IF;
2279: EXCEPTION
2280: WHEN OTHERS THEN
2281: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
2282: RAISE FND_API.G_EXC_ERROR;
2283: END;
2284: -- End of POST User Hooks
2285:

Line 2315: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');

2311: WHILE l_msg_count > 0 LOOP
2312: x_msg_data := FND_MSG_PUB.GET
2313: (l_msg_index,
2314: FND_API.G_FALSE);
2315: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
2316: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;
2317: l_msg_count := l_msg_count - 1;
2318: END LOOP;
2319: RAISE FND_API.G_EXC_ERROR;

Line 2316: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;

2312: x_msg_data := FND_MSG_PUB.GET
2313: (l_msg_index,
2314: FND_API.G_FALSE);
2315: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
2316: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;
2317: l_msg_count := l_msg_count - 1;
2318: END LOOP;
2319: RAISE FND_API.G_EXC_ERROR;
2320: END IF;

Line 2346: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');

2342: WHILE l_msg_count > 0 LOOP
2343: x_msg_data := FND_MSG_PUB.GET
2344: (l_msg_index,
2345: FND_API.G_FALSE);
2346: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
2347: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;
2348: l_msg_count := l_msg_count - 1;
2349: END LOOP;
2350: RAISE FND_API.G_EXC_ERROR;

Line 2347: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;

2343: x_msg_data := FND_MSG_PUB.GET
2344: (l_msg_index,
2345: FND_API.G_FALSE);
2346: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
2347: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;
2348: l_msg_count := l_msg_count - 1;
2349: END LOOP;
2350: RAISE FND_API.G_EXC_ERROR;
2351: END IF;

Line 2374: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');

2370: WHILE l_msg_count > 0 LOOP
2371: x_msg_data := FND_MSG_PUB.GET
2372: (l_msg_index,
2373: FND_API.G_FALSE);
2374: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
2375: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2376: l_msg_index := l_msg_index + 1;
2377: l_msg_count := l_msg_count - 1;
2378: END LOOP;

Line 2375: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2371: x_msg_data := FND_MSG_PUB.GET
2372: (l_msg_index,
2373: FND_API.G_FALSE);
2374: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
2375: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2376: l_msg_index := l_msg_index + 1;
2377: l_msg_count := l_msg_count - 1;
2378: END LOOP;
2379: RAISE FND_API.G_EXC_ERROR;

Line 2477: -- csi_ctr_gen_utility_pvt.check_ib_active;

2473: SAVEPOINT update_item_association;
2474:
2475: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2476:
2477: -- csi_ctr_gen_utility_pvt.check_ib_active;
2478:
2479: -- Standard call to check for call compatibility.
2480: IF NOT FND_API.Compatible_API_Call (l_api_version,
2481: p_api_version,

Line 2500: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2496: -- Check the profile option debug_level for debug message reporting
2497: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2498:
2499: -- Read the debug profiles values in to global variable 7197402
2500: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2501:
2502: -- If debug_level = 1 then dump the procedure name
2503: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
2504: csi_ctr_gen_utility_pvt.put_line( 'update_item_association');

Line 2503: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

2499: -- Read the debug profiles values in to global variable 7197402
2500: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2501:
2502: -- If debug_level = 1 then dump the procedure name
2503: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
2504: csi_ctr_gen_utility_pvt.put_line( 'update_item_association');
2505: END IF;
2506:
2507: -- If the debug level = 2 then dump all the parameters values.

Line 2504: csi_ctr_gen_utility_pvt.put_line( 'update_item_association');

2500: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2501:
2502: -- If debug_level = 1 then dump the procedure name
2503: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
2504: csi_ctr_gen_utility_pvt.put_line( 'update_item_association');
2505: END IF;
2506:
2507: -- If the debug level = 2 then dump all the parameters values.
2508: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 2508: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

2504: csi_ctr_gen_utility_pvt.put_line( 'update_item_association');
2505: END IF;
2506:
2507: -- If the debug level = 2 then dump all the parameters values.
2508: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
2509: csi_ctr_gen_utility_pvt.put_line( 'update_item_association' ||
2510: p_api_version ||'-'||
2511: p_commit ||'-'||
2512: p_init_msg_list ||'-'||

Line 2509: csi_ctr_gen_utility_pvt.put_line( 'update_item_association' ||

2505: END IF;
2506:
2507: -- If the debug level = 2 then dump all the parameters values.
2508: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
2509: csi_ctr_gen_utility_pvt.put_line( 'update_item_association' ||
2510: p_api_version ||'-'||
2511: p_commit ||'-'||
2512: p_init_msg_list ||'-'||
2513: p_validation_level );

Line 2514: csi_ctr_gen_utility_pvt.dump_ctr_item_assoc_rec(p_ctr_item_associations_rec);

2510: p_api_version ||'-'||
2511: p_commit ||'-'||
2512: p_init_msg_list ||'-'||
2513: p_validation_level );
2514: csi_ctr_gen_utility_pvt.dump_ctr_item_assoc_rec(p_ctr_item_associations_rec);
2515: END IF;
2516:
2517: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
2518: CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre

Line 2537: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre API ');

2533: x_msg_data := FND_MSG_PUB.GET
2534: ( l_msg_index,
2535: FND_API.G_FALSE
2536: );
2537: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre API ');
2538: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2539: l_msg_index := l_msg_index + 1;
2540: l_msg_count := l_msg_count - 1;
2541: END LOOP;

Line 2538: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2534: ( l_msg_index,
2535: FND_API.G_FALSE
2536: );
2537: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre API ');
2538: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2539: l_msg_index := l_msg_index + 1;
2540: l_msg_count := l_msg_count - 1;
2541: END LOOP;
2542: RAISE FND_API.G_EXC_ERROR;

Line 2567: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_pre API ');

2563: x_msg_data := FND_MSG_PUB.GET
2564: ( l_msg_index,
2565: FND_API.G_FALSE
2566: );
2567: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_pre API ');
2568: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2569: l_msg_index := l_msg_index + 1;
2570: l_msg_count := l_msg_count - 1;
2571: END LOOP;

Line 2568: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2564: ( l_msg_index,
2565: FND_API.G_FALSE
2566: );
2567: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_pre API ');
2568: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2569: l_msg_index := l_msg_index + 1;
2570: l_msg_count := l_msg_count - 1;
2571: END LOOP;
2572: RAISE FND_API.G_EXC_ERROR;

Line 2596: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ITEM_ASSOCIATION');

2592: WHILE l_msg_count > 0 LOOP
2593: x_msg_data := FND_MSG_PUB.GET
2594: (l_msg_index,
2595: FND_API.G_FALSE );
2596: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ITEM_ASSOCIATION');
2597: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2598: l_msg_index := l_msg_index + 1;
2599: l_msg_count := l_msg_count - 1;
2600: END LOOP;

Line 2597: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2593: x_msg_data := FND_MSG_PUB.GET
2594: (l_msg_index,
2595: FND_API.G_FALSE );
2596: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ITEM_ASSOCIATION');
2597: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2598: l_msg_index := l_msg_index + 1;
2599: l_msg_count := l_msg_count - 1;
2600: END LOOP;
2601: RAISE FND_API.G_EXC_ERROR;

Line 2607: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post ..');

2603:
2604: -- Calling Post Customer User Hook
2605: BEGIN
2606: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
2607: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post ..');
2608: CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post
2609: (
2610: p_api_version => 1.0
2611: ,p_commit => fnd_api.g_false

Line 2638: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

2634: --
2635: END IF;
2636: EXCEPTION
2637: WHEN OTHERS THEN
2638: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
2639: RAISE FND_API.G_EXC_ERROR;
2640: END;
2641: --
2642: -- Calling Post Vertical User Hook

Line 2646: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post ..');

2642: -- Calling Post Vertical User Hook
2643: BEGIN
2644:
2645: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
2646: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post ..');
2647: CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post
2648: (
2649: p_api_version => 1.0
2650: ,p_commit => fnd_api.g_false

Line 2666: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post API ');

2662: WHILE l_msg_count > 0 LOOP
2663: x_msg_data := FND_MSG_PUB.GET
2664: ( l_msg_index,
2665: FND_API.G_FALSE );
2666: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post API ');
2667: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2668: l_msg_index := l_msg_index + 1;
2669: l_msg_count := l_msg_count - 1;
2670: END LOOP;

Line 2667: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2663: x_msg_data := FND_MSG_PUB.GET
2664: ( l_msg_index,
2665: FND_API.G_FALSE );
2666: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post API ');
2667: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2668: l_msg_index := l_msg_index + 1;
2669: l_msg_count := l_msg_count - 1;
2670: END LOOP;
2671: RAISE FND_API.G_EXC_ERROR;

Line 2677: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

2673: --
2674: END IF;
2675: EXCEPTION
2676: WHEN OTHERS THEN
2677: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
2678: RAISE FND_API.G_EXC_ERROR;
2679: END;
2680: -- End of POST User Hooks
2681: -- End of API body

Line 2780: -- csi_ctr_gen_utility_pvt.check_ib_active;

2776: SAVEPOINT update_counter_template ;
2777:
2778: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2779:
2780: -- csi_ctr_gen_utility_pvt.check_ib_active;
2781:
2782: -- Standard call to check for call compatibility.
2783: IF NOT FND_API.Compatible_API_Call (l_api_version,
2784: p_api_version,

Line 2800: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

2796: -- Initialize API return status to success
2797: x_return_status := FND_API.G_RET_STS_SUCCESS;
2798:
2799: -- Read the debug profiles values in to global variable 7197402
2800: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2801:
2802: -- Check the profile option debug_level for debug message reporting
2803: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2804:

Line 2806: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

2802: -- Check the profile option debug_level for debug message reporting
2803: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2804:
2805: -- If debug_level = 1 then dump the procedure name
2806: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
2807: csi_ctr_gen_utility_pvt.put_line( 'update_counter_template');
2808: END IF;
2809:
2810: -- If the debug level = 2 then dump all the parameters values.

Line 2807: csi_ctr_gen_utility_pvt.put_line( 'update_counter_template');

2803: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2804:
2805: -- If debug_level = 1 then dump the procedure name
2806: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
2807: csi_ctr_gen_utility_pvt.put_line( 'update_counter_template');
2808: END IF;
2809:
2810: -- If the debug level = 2 then dump all the parameters values.
2811: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 2811: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

2807: csi_ctr_gen_utility_pvt.put_line( 'update_counter_template');
2808: END IF;
2809:
2810: -- If the debug level = 2 then dump all the parameters values.
2811: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
2812: csi_ctr_gen_utility_pvt.put_line( 'update_counter_template' ||
2813: p_api_version ||'-'||
2814: p_commit ||'-'||
2815: p_init_msg_list ||'-'||

Line 2812: csi_ctr_gen_utility_pvt.put_line( 'update_counter_template' ||

2808: END IF;
2809:
2810: -- If the debug level = 2 then dump all the parameters values.
2811: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
2812: csi_ctr_gen_utility_pvt.put_line( 'update_counter_template' ||
2813: p_api_version ||'-'||
2814: p_commit ||'-'||
2815: p_init_msg_list ||'-'||
2816: p_validation_level );

Line 2817: csi_ctr_gen_utility_pvt.dump_ctr_template_rec(p_counter_template_rec);

2813: p_api_version ||'-'||
2814: p_commit ||'-'||
2815: p_init_msg_list ||'-'||
2816: p_validation_level );
2817: csi_ctr_gen_utility_pvt.dump_ctr_template_rec(p_counter_template_rec);
2818: END IF;
2819:
2820: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
2821: CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre

Line 2844: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre API ');

2840: x_msg_data := FND_MSG_PUB.GET
2841: ( l_msg_index,
2842: FND_API.G_FALSE
2843: );
2844: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre API ');
2845: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2846: l_msg_index := l_msg_index + 1;
2847: l_msg_count := l_msg_count - 1;
2848: END LOOP;

Line 2845: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2841: ( l_msg_index,
2842: FND_API.G_FALSE
2843: );
2844: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre API ');
2845: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2846: l_msg_index := l_msg_index + 1;
2847: l_msg_count := l_msg_count - 1;
2848: END LOOP;
2849: RAISE FND_API.G_EXC_ERROR;

Line 2878: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_pre API ');

2874: x_msg_data := FND_MSG_PUB.GET
2875: ( l_msg_index,
2876: FND_API.G_FALSE
2877: );
2878: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_pre API ');
2879: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2880: l_msg_index := l_msg_index + 1;
2881: l_msg_count := l_msg_count - 1;
2882: END LOOP;

Line 2879: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2875: ( l_msg_index,
2876: FND_API.G_FALSE
2877: );
2878: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_pre API ');
2879: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2880: l_msg_index := l_msg_index + 1;
2881: l_msg_count := l_msg_count - 1;
2882: END LOOP;
2883: RAISE FND_API.G_EXC_ERROR;

Line 2909: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_TEMPLATE');

2905: WHILE l_msg_count > 0 LOOP
2906: x_msg_data := FND_MSG_PUB.GET
2907: (l_msg_index,
2908: FND_API.G_FALSE );
2909: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_TEMPLATE');
2910: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2911: l_msg_index := l_msg_index + 1;
2912: l_msg_count := l_msg_count - 1;
2913: END LOOP;

Line 2910: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2906: x_msg_data := FND_MSG_PUB.GET
2907: (l_msg_index,
2908: FND_API.G_FALSE );
2909: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_TEMPLATE');
2910: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2911: l_msg_index := l_msg_index + 1;
2912: l_msg_count := l_msg_count - 1;
2913: END LOOP;
2914: RAISE FND_API.G_EXC_ERROR;

Line 2920: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post ..');

2916:
2917: -- Calling Post Customer User Hook
2918: BEGIN
2919: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
2920: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post ..');
2921: CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post
2922: (
2923: p_api_version => 1.0
2924: ,p_commit => fnd_api.g_false

Line 2955: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

2951: --
2952: END IF;
2953: EXCEPTION
2954: WHEN OTHERS THEN
2955: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
2956: RAISE FND_API.G_EXC_ERROR;
2957: END;
2958: --
2959: -- Calling Post Vertical User Hook

Line 2963: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post ..');

2959: -- Calling Post Vertical User Hook
2960: BEGIN
2961:
2962: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
2963: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post ..');
2964: CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post
2965: (
2966: p_api_version => 1.0
2967: ,p_commit => fnd_api.g_false

Line 2987: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post API ');

2983: WHILE l_msg_count > 0 LOOP
2984: x_msg_data := FND_MSG_PUB.GET
2985: ( l_msg_index,
2986: FND_API.G_FALSE );
2987: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post API ');
2988: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2989: l_msg_index := l_msg_index + 1;
2990: l_msg_count := l_msg_count - 1;
2991: END LOOP;

Line 2988: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

2984: x_msg_data := FND_MSG_PUB.GET
2985: ( l_msg_index,
2986: FND_API.G_FALSE );
2987: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post API ');
2988: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2989: l_msg_index := l_msg_index + 1;
2990: l_msg_count := l_msg_count - 1;
2991: END LOOP;
2992: RAISE FND_API.G_EXC_ERROR;

Line 2998: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

2994: --
2995: END IF;
2996: EXCEPTION
2997: WHEN OTHERS THEN
2998: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
2999: RAISE FND_API.G_EXC_ERROR;
3000: END;
3001: -- End of POST User Hooks
3002:

Line 3031: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');

3027: WHILE l_msg_count > 0 LOOP
3028: x_msg_data := FND_MSG_PUB.GET
3029: (l_msg_index,
3030: FND_API.G_FALSE);
3031: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
3032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3033: l_msg_index := l_msg_index + 1;
3034: l_msg_count := l_msg_count - 1;
3035: END LOOP;

Line 3032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3028: x_msg_data := FND_MSG_PUB.GET
3029: (l_msg_index,
3030: FND_API.G_FALSE);
3031: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
3032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3033: l_msg_index := l_msg_index + 1;
3034: l_msg_count := l_msg_count - 1;
3035: END LOOP;
3036: RAISE FND_API.G_EXC_ERROR;

Line 3057: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');

3053: WHILE l_msg_count > 0 LOOP
3054: x_msg_data := FND_MSG_PUB.GET
3055: (l_msg_index,
3056: FND_API.G_FALSE);
3057: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
3058: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3059: l_msg_index := l_msg_index + 1;
3060: l_msg_count := l_msg_count - 1;
3061: END LOOP;

Line 3058: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3054: x_msg_data := FND_MSG_PUB.GET
3055: (l_msg_index,
3056: FND_API.G_FALSE);
3057: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
3058: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3059: l_msg_index := l_msg_index + 1;
3060: l_msg_count := l_msg_count - 1;
3061: END LOOP;
3062: RAISE FND_API.G_EXC_ERROR;

Line 3096: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');

3092: WHILE l_msg_count > 0 LOOP
3093: x_msg_data := FND_MSG_PUB.GET
3094: (l_msg_index,
3095: FND_API.G_FALSE);
3096: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');
3097: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3098: l_msg_index := l_msg_index + 1;
3099: l_msg_count := l_msg_count - 1;
3100: END LOOP;

Line 3097: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3093: x_msg_data := FND_MSG_PUB.GET
3094: (l_msg_index,
3095: FND_API.G_FALSE);
3096: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');
3097: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3098: l_msg_index := l_msg_index + 1;
3099: l_msg_count := l_msg_count - 1;
3100: END LOOP;
3101: RAISE FND_API.G_EXC_ERROR;

Line 3122: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_CTR_PROPERTY_TEMPLATE');

3118: WHILE l_msg_count > 0 LOOP
3119: x_msg_data := FND_MSG_PUB.GET
3120: (l_msg_index,
3121: FND_API.G_FALSE);
3122: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_CTR_PROPERTY_TEMPLATE');
3123: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3124: l_msg_index := l_msg_index + 1;
3125: l_msg_count := l_msg_count - 1;
3126: END LOOP;

Line 3123: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3119: x_msg_data := FND_MSG_PUB.GET
3120: (l_msg_index,
3121: FND_API.G_FALSE);
3122: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_CTR_PROPERTY_TEMPLATE');
3123: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3124: l_msg_index := l_msg_index + 1;
3125: l_msg_count := l_msg_count - 1;
3126: END LOOP;
3127: RAISE FND_API.G_EXC_ERROR;

Line 3138: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_REQ_FORMULA_REF');

3134: IF p_counter_template_rec.counter_type = 'FORMULA' AND
3135: p_counter_template_rec.derive_function IS NULL THEN
3136:
3137: IF nvl(p_counter_relationships_tbl.count,0) = 0 THEN
3138: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_REQ_FORMULA_REF');
3139: END IF;
3140: END IF;
3141:
3142: IF (p_counter_relationships_tbl.count > 0) THEN

Line 3170: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');

3166: WHILE l_msg_count > 0 LOOP
3167: x_msg_data := FND_MSG_PUB.GET
3168: (l_msg_index,
3169: FND_API.G_FALSE);
3170: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');
3171: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3172: l_msg_index := l_msg_index + 1;
3173: l_msg_count := l_msg_count - 1;
3174: END LOOP;

Line 3171: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3167: x_msg_data := FND_MSG_PUB.GET
3168: (l_msg_index,
3169: FND_API.G_FALSE);
3170: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');
3171: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3172: l_msg_index := l_msg_index + 1;
3173: l_msg_count := l_msg_count - 1;
3174: END LOOP;
3175: RAISE FND_API.G_EXC_ERROR;

Line 3198: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_COUNTER_RELATIONSHIP');

3194: WHILE l_msg_count > 0 LOOP
3195: x_msg_data := FND_MSG_PUB.GET
3196: (l_msg_index,
3197: FND_API.G_FALSE);
3198: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_COUNTER_RELATIONSHIP');
3199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3200: l_msg_index := l_msg_index + 1;
3201: l_msg_count := l_msg_count - 1;
3202: END LOOP;

Line 3199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3195: x_msg_data := FND_MSG_PUB.GET
3196: (l_msg_index,
3197: FND_API.G_FALSE);
3198: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_COUNTER_RELATIONSHIP');
3199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3200: l_msg_index := l_msg_index + 1;
3201: l_msg_count := l_msg_count - 1;
3202: END LOOP;
3203: RAISE FND_API.G_EXC_ERROR;

Line 3237: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_DERIVED_FILTERS');

3233: WHILE l_msg_count > 0 LOOP
3234: x_msg_data := FND_MSG_PUB.GET
3235: (l_msg_index,
3236: FND_API.G_FALSE);
3237: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_DERIVED_FILTERS');
3238: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3239: l_msg_index := l_msg_index + 1;
3240: l_msg_count := l_msg_count - 1;
3241: END LOOP;

Line 3238: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3234: x_msg_data := FND_MSG_PUB.GET
3235: (l_msg_index,
3236: FND_API.G_FALSE);
3237: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_DERIVED_FILTERS');
3238: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3239: l_msg_index := l_msg_index + 1;
3240: l_msg_count := l_msg_count - 1;
3241: END LOOP;
3242: RAISE FND_API.G_EXC_ERROR;

Line 3336: -- csi_ctr_gen_utility_pvt.check_ib_active;

3332: SAVEPOINT update_ctr_property_template;
3333:
3334: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
3335:
3336: -- csi_ctr_gen_utility_pvt.check_ib_active;
3337:
3338: -- Standard call to check for call compatibility.
3339: IF NOT FND_API.Compatible_API_Call (l_api_version,
3340: p_api_version,

Line 3356: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3352: -- Initialize API return status to success
3353: x_return_status := FND_API.G_RET_STS_SUCCESS;
3354:
3355: -- Read the debug profiles values in to global variable 7197402
3356: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3357:
3358: -- Check the profile option debug_level for debug message reporting
3359: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3360:

Line 3362: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

3358: -- Check the profile option debug_level for debug message reporting
3359: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3360:
3361: -- If debug_level = 1 then dump the procedure name
3362: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
3363: csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template');
3364: END IF;
3365:
3366: -- If the debug level = 2 then dump all the parameters values.

Line 3363: csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template');

3359: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3360:
3361: -- If debug_level = 1 then dump the procedure name
3362: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
3363: csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template');
3364: END IF;
3365:
3366: -- If the debug level = 2 then dump all the parameters values.
3367: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 3367: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

3363: csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template');
3364: END IF;
3365:
3366: -- If the debug level = 2 then dump all the parameters values.
3367: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
3368: csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template' ||
3369: p_api_version ||'-'||
3370: p_commit ||'-'||
3371: p_init_msg_list ||'-'||

Line 3368: csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template' ||

3364: END IF;
3365:
3366: -- If the debug level = 2 then dump all the parameters values.
3367: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
3368: csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template' ||
3369: p_api_version ||'-'||
3370: p_commit ||'-'||
3371: p_init_msg_list ||'-'||
3372: p_validation_level );

Line 3373: csi_ctr_gen_utility_pvt.dump_ctr_property_template_rec(p_ctr_property_template_rec);

3369: p_api_version ||'-'||
3370: p_commit ||'-'||
3371: p_init_msg_list ||'-'||
3372: p_validation_level );
3373: csi_ctr_gen_utility_pvt.dump_ctr_property_template_rec(p_ctr_property_template_rec);
3374: END IF;
3375:
3376: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
3377: CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre

Line 3396: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre API ');

3392: x_msg_data := FND_MSG_PUB.GET
3393: ( l_msg_index,
3394: FND_API.G_FALSE
3395: );
3396: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre API ');
3397: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3398: l_msg_index := l_msg_index + 1;
3399: l_msg_count := l_msg_count - 1;
3400: END LOOP;

Line 3397: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3393: ( l_msg_index,
3394: FND_API.G_FALSE
3395: );
3396: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre API ');
3397: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3398: l_msg_index := l_msg_index + 1;
3399: l_msg_count := l_msg_count - 1;
3400: END LOOP;
3401: RAISE FND_API.G_EXC_ERROR;

Line 3426: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_pre API ');

3422: x_msg_data := FND_MSG_PUB.GET
3423: ( l_msg_index,
3424: FND_API.G_FALSE
3425: );
3426: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_pre API ');
3427: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3428: l_msg_index := l_msg_index + 1;
3429: l_msg_count := l_msg_count - 1;
3430: END LOOP;

Line 3427: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3423: ( l_msg_index,
3424: FND_API.G_FALSE
3425: );
3426: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_pre API ');
3427: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3428: l_msg_index := l_msg_index + 1;
3429: l_msg_count := l_msg_count - 1;
3430: END LOOP;
3431: RAISE FND_API.G_EXC_ERROR;

Line 3455: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_CTR_PROPERTY_TEMPLATE');

3451: WHILE l_msg_count > 0 LOOP
3452: x_msg_data := FND_MSG_PUB.GET
3453: (l_msg_index,
3454: FND_API.G_FALSE );
3455: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_CTR_PROPERTY_TEMPLATE');
3456: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3457: l_msg_index := l_msg_index + 1;
3458: l_msg_count := l_msg_count - 1;
3459: END LOOP;

Line 3456: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3452: x_msg_data := FND_MSG_PUB.GET
3453: (l_msg_index,
3454: FND_API.G_FALSE );
3455: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_CTR_PROPERTY_TEMPLATE');
3456: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3457: l_msg_index := l_msg_index + 1;
3458: l_msg_count := l_msg_count - 1;
3459: END LOOP;
3460: RAISE FND_API.G_EXC_ERROR;

Line 3466: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post ..');

3462:
3463: -- Calling Post Customer User Hook
3464: BEGIN
3465: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
3466: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post ..');
3467: CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post
3468: (
3469: p_api_version => 1.0
3470: ,p_commit => fnd_api.g_false

Line 3497: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

3493: --
3494: END IF;
3495: EXCEPTION
3496: WHEN OTHERS THEN
3497: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
3498: RAISE FND_API.G_EXC_ERROR;
3499: END;
3500: --
3501: -- Calling Post Vertical User Hook

Line 3505: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post ..');

3501: -- Calling Post Vertical User Hook
3502: BEGIN
3503:
3504: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
3505: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post ..');
3506: CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post
3507: (
3508: p_api_version => 1.0
3509: ,p_commit => fnd_api.g_false

Line 3525: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post API ');

3521: WHILE l_msg_count > 0 LOOP
3522: x_msg_data := FND_MSG_PUB.GET
3523: ( l_msg_index,
3524: FND_API.G_FALSE );
3525: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post API ');
3526: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3527: l_msg_index := l_msg_index + 1;
3528: l_msg_count := l_msg_count - 1;
3529: END LOOP;

Line 3526: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3522: x_msg_data := FND_MSG_PUB.GET
3523: ( l_msg_index,
3524: FND_API.G_FALSE );
3525: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post API ');
3526: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3527: l_msg_index := l_msg_index + 1;
3528: l_msg_count := l_msg_count - 1;
3529: END LOOP;
3530: RAISE FND_API.G_EXC_ERROR;

Line 3536: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

3532: --
3533: END IF;
3534: EXCEPTION
3535: WHEN OTHERS THEN
3536: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
3537: RAISE FND_API.G_EXC_ERROR;
3538: END;
3539: -- End of POST User Hooks
3540:

Line 3630: -- csi_ctr_gen_utility_pvt.check_ib_active;

3626: SAVEPOINT update_counter_relationship;
3627:
3628: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
3629:
3630: -- csi_ctr_gen_utility_pvt.check_ib_active;
3631:
3632: -- Standard call to check for call compatibility.
3633: IF NOT FND_API.Compatible_API_Call (l_api_version,
3634: p_api_version,

Line 3650: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3646: -- Initialize API return status to success
3647: x_return_status := FND_API.G_RET_STS_SUCCESS;
3648:
3649: -- Read the debug profiles values in to global variable 7197402
3650: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3651:
3652: -- Check the profile option debug_level for debug message reporting
3653: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3654:

Line 3656: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

3652: -- Check the profile option debug_level for debug message reporting
3653: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3654:
3655: -- If debug_level = 1 then dump the procedure name
3656: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
3657: csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship');
3658: END IF;
3659:
3660: -- If the debug level = 2 then dump all the parameters values.

Line 3657: csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship');

3653: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3654:
3655: -- If debug_level = 1 then dump the procedure name
3656: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
3657: csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship');
3658: END IF;
3659:
3660: -- If the debug level = 2 then dump all the parameters values.
3661: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 3661: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

3657: csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship');
3658: END IF;
3659:
3660: -- If the debug level = 2 then dump all the parameters values.
3661: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
3662: csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship' ||
3663: p_api_version ||'-'||
3664: p_commit ||'-'||
3665: p_init_msg_list ||'-'||

Line 3662: csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship' ||

3658: END IF;
3659:
3660: -- If the debug level = 2 then dump all the parameters values.
3661: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
3662: csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship' ||
3663: p_api_version ||'-'||
3664: p_commit ||'-'||
3665: p_init_msg_list ||'-'||
3666: p_validation_level );

Line 3667: csi_ctr_gen_utility_pvt.dump_ctr_relationship_rec(p_counter_relationships_rec);

3663: p_api_version ||'-'||
3664: p_commit ||'-'||
3665: p_init_msg_list ||'-'||
3666: p_validation_level );
3667: csi_ctr_gen_utility_pvt.dump_ctr_relationship_rec(p_counter_relationships_rec);
3668: END IF;
3669:
3670: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
3671: CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre

Line 3690: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre API ');

3686: x_msg_data := FND_MSG_PUB.GET
3687: ( l_msg_index,
3688: FND_API.G_FALSE
3689: );
3690: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre API ');
3691: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3692: l_msg_index := l_msg_index + 1;
3693: l_msg_count := l_msg_count - 1;
3694: END LOOP;

Line 3691: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3687: ( l_msg_index,
3688: FND_API.G_FALSE
3689: );
3690: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre API ');
3691: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3692: l_msg_index := l_msg_index + 1;
3693: l_msg_count := l_msg_count - 1;
3694: END LOOP;
3695: RAISE FND_API.G_EXC_ERROR;

Line 3720: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_pre API ');

3716: x_msg_data := FND_MSG_PUB.GET
3717: ( l_msg_index,
3718: FND_API.G_FALSE
3719: );
3720: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_pre API ');
3721: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3722: l_msg_index := l_msg_index + 1;
3723: l_msg_count := l_msg_count - 1;
3724: END LOOP;

Line 3721: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3717: ( l_msg_index,
3718: FND_API.G_FALSE
3719: );
3720: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_pre API ');
3721: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3722: l_msg_index := l_msg_index + 1;
3723: l_msg_count := l_msg_count - 1;
3724: END LOOP;
3725: RAISE FND_API.G_EXC_ERROR;

Line 3749: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP');

3745: WHILE l_msg_count > 0 LOOP
3746: x_msg_data := FND_MSG_PUB.GET
3747: (l_msg_index,
3748: FND_API.G_FALSE );
3749: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP');
3750: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3751: l_msg_index := l_msg_index + 1;
3752: l_msg_count := l_msg_count - 1;
3753: END LOOP;

Line 3750: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3746: x_msg_data := FND_MSG_PUB.GET
3747: (l_msg_index,
3748: FND_API.G_FALSE );
3749: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP');
3750: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3751: l_msg_index := l_msg_index + 1;
3752: l_msg_count := l_msg_count - 1;
3753: END LOOP;
3754: RAISE FND_API.G_EXC_ERROR;

Line 3760: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post ..');

3756:
3757: -- Calling Post Customer User Hook
3758: BEGIN
3759: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
3760: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post ..');
3761: CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post
3762: (
3763: p_api_version => 1.0
3764: ,p_commit => fnd_api.g_false

Line 3791: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

3787: --
3788: END IF;
3789: EXCEPTION
3790: WHEN OTHERS THEN
3791: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
3792: RAISE FND_API.G_EXC_ERROR;
3793: END;
3794: --
3795: -- Calling Post Vertical User Hook

Line 3799: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post ..');

3795: -- Calling Post Vertical User Hook
3796: BEGIN
3797:
3798: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
3799: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post ..');
3800: CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post
3801: (
3802: p_api_version => 1.0
3803: ,p_commit => fnd_api.g_false

Line 3819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post API ');

3815: WHILE l_msg_count > 0 LOOP
3816: x_msg_data := FND_MSG_PUB.GET
3817: ( l_msg_index,
3818: FND_API.G_FALSE );
3819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post API ');
3820: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3821: l_msg_index := l_msg_index + 1;
3822: l_msg_count := l_msg_count - 1;
3823: END LOOP;

Line 3820: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3816: x_msg_data := FND_MSG_PUB.GET
3817: ( l_msg_index,
3818: FND_API.G_FALSE );
3819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post API ');
3820: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3821: l_msg_index := l_msg_index + 1;
3822: l_msg_count := l_msg_count - 1;
3823: END LOOP;
3824: RAISE FND_API.G_EXC_ERROR;

Line 3830: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

3826: --
3827: END IF;
3828: EXCEPTION
3829: WHEN OTHERS THEN
3830: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
3831: RAISE FND_API.G_EXC_ERROR;
3832: END;
3833: -- End of POST User Hooks
3834: -- End of API body

Line 3923: -- csi_ctr_gen_utility_pvt.check_ib_active;

3919: SAVEPOINT update_derived_filters;
3920:
3921: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
3922:
3923: -- csi_ctr_gen_utility_pvt.check_ib_active;
3924:
3925: -- Standard call to check for call compatibility.
3926: IF NOT FND_API.Compatible_API_Call (l_api_version,
3927: p_api_version,

Line 3943: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

3939: -- Initialize API return status to success
3940: x_return_status := FND_API.G_RET_STS_SUCCESS;
3941:
3942: -- Read the debug profiles values in to global variable 7197402
3943: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
3944:
3945: -- Check the profile option debug_level for debug message reporting
3946: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3947:

Line 3949: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

3945: -- Check the profile option debug_level for debug message reporting
3946: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3947:
3948: -- If debug_level = 1 then dump the procedure name
3949: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
3950: csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters');
3951: END IF;
3952:
3953: -- If the debug level = 2 then dump all the parameters values.

Line 3950: csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters');

3946: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3947:
3948: -- If debug_level = 1 then dump the procedure name
3949: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
3950: csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters');
3951: END IF;
3952:
3953: -- If the debug level = 2 then dump all the parameters values.
3954: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 3954: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

3950: csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters');
3951: END IF;
3952:
3953: -- If the debug level = 2 then dump all the parameters values.
3954: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
3955: csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters' ||
3956: p_api_version ||'-'||
3957: p_commit ||'-'||
3958: p_init_msg_list ||'-'||

Line 3955: csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters' ||

3951: END IF;
3952:
3953: -- If the debug level = 2 then dump all the parameters values.
3954: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
3955: csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters' ||
3956: p_api_version ||'-'||
3957: p_commit ||'-'||
3958: p_init_msg_list ||'-'||
3959: p_validation_level );

Line 3960: csi_ctr_gen_utility_pvt.dump_ctr_derived_filters_tbl(p_ctr_derived_filters_tbl);

3956: p_api_version ||'-'||
3957: p_commit ||'-'||
3958: p_init_msg_list ||'-'||
3959: p_validation_level );
3960: csi_ctr_gen_utility_pvt.dump_ctr_derived_filters_tbl(p_ctr_derived_filters_tbl);
3961: END IF;
3962:
3963: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
3964: CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre

Line 3983: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');

3979: x_msg_data := FND_MSG_PUB.GET
3980: ( l_msg_index,
3981: FND_API.G_FALSE
3982: );
3983: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');
3984: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3985: l_msg_index := l_msg_index + 1;
3986: l_msg_count := l_msg_count - 1;
3987: END LOOP;

Line 3984: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3980: ( l_msg_index,
3981: FND_API.G_FALSE
3982: );
3983: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');
3984: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3985: l_msg_index := l_msg_index + 1;
3986: l_msg_count := l_msg_count - 1;
3987: END LOOP;
3988: RAISE FND_API.G_EXC_ERROR;

Line 4013: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');

4009: x_msg_data := FND_MSG_PUB.GET
4010: ( l_msg_index,
4011: FND_API.G_FALSE
4012: );
4013: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');
4014: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4015: l_msg_index := l_msg_index + 1;
4016: l_msg_count := l_msg_count - 1;
4017: END LOOP;

Line 4014: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4010: ( l_msg_index,
4011: FND_API.G_FALSE
4012: );
4013: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');
4014: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4015: l_msg_index := l_msg_index + 1;
4016: l_msg_count := l_msg_count - 1;
4017: END LOOP;
4018: RAISE FND_API.G_EXC_ERROR;

Line 4043: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS');

4039: WHILE l_msg_count > 0 LOOP
4040: x_msg_data := FND_MSG_PUB.GET
4041: (l_msg_index,
4042: FND_API.G_FALSE );
4043: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS');
4044: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4045: l_msg_index := l_msg_index + 1;
4046: l_msg_count := l_msg_count - 1;
4047: END LOOP;

Line 4044: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4040: x_msg_data := FND_MSG_PUB.GET
4041: (l_msg_index,
4042: FND_API.G_FALSE );
4043: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS');
4044: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4045: l_msg_index := l_msg_index + 1;
4046: l_msg_count := l_msg_count - 1;
4047: END LOOP;
4048: RAISE FND_API.G_EXC_ERROR;

Line 4054: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post ..');

4050:
4051: -- Calling Post Customer User Hook
4052: BEGIN
4053: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
4054: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post ..');
4055: CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post
4056: (
4057: p_api_version => 1.0
4058: ,p_commit => fnd_api.g_false

Line 4085: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

4081: --
4082: END IF;
4083: EXCEPTION
4084: WHEN OTHERS THEN
4085: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
4086: RAISE FND_API.G_EXC_ERROR;
4087: END;
4088: --
4089: -- Calling Post Vertical User Hook

Line 4093: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post ..');

4089: -- Calling Post Vertical User Hook
4090: BEGIN
4091:
4092: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
4093: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post ..');
4094: CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post
4095: (
4096: p_api_version => 1.0
4097: ,p_commit => fnd_api.g_false

Line 4113: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post API ');

4109: WHILE l_msg_count > 0 LOOP
4110: x_msg_data := FND_MSG_PUB.GET
4111: ( l_msg_index,
4112: FND_API.G_FALSE );
4113: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post API ');
4114: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4115: l_msg_index := l_msg_index + 1;
4116: l_msg_count := l_msg_count - 1;
4117: END LOOP;

Line 4114: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4110: x_msg_data := FND_MSG_PUB.GET
4111: ( l_msg_index,
4112: FND_API.G_FALSE );
4113: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post API ');
4114: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4115: l_msg_index := l_msg_index + 1;
4116: l_msg_count := l_msg_count - 1;
4117: END LOOP;
4118: RAISE FND_API.G_EXC_ERROR;

Line 4124: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

4120: --
4121: END IF;
4122: EXCEPTION
4123: WHEN OTHERS THEN
4124: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
4125: RAISE FND_API.G_EXC_ERROR;
4126: END;
4127: -- End of POST User Hooks
4128:

Line 4212: -- csi_ctr_gen_utility_pvt.check_ib_active;

4208: SAVEPOINT create_estimation_method;
4209:
4210: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4211:
4212: -- csi_ctr_gen_utility_pvt.check_ib_active;
4213:
4214: -- Standard call to check for call compatibility.
4215: IF NOT FND_API.Compatible_API_Call (l_api_version,
4216: p_api_version,

Line 4232: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

4228: -- Initialize API return status to success
4229: x_return_status := FND_API.G_RET_STS_SUCCESS;
4230:
4231: -- Read the debug profiles values in to global variable 7197402
4232: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
4233:
4234: -- Check the profile option debug_level for debug message reporting
4235: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4236:

Line 4238: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

4234: -- Check the profile option debug_level for debug message reporting
4235: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4236:
4237: -- If debug_level = 1 then dump the procedure name
4238: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
4239: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');
4240: END IF;
4241:
4242: -- If the debug level = 2 then dump all the parameters values.

Line 4239: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');

4235: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4236:
4237: -- If debug_level = 1 then dump the procedure name
4238: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
4239: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');
4240: END IF;
4241:
4242: -- If the debug level = 2 then dump all the parameters values.
4243: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 4243: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

4239: csi_ctr_gen_utility_pvt.put_line( 'create_derived_filters');
4240: END IF;
4241:
4242: -- If the debug level = 2 then dump all the parameters values.
4243: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
4244: csi_ctr_gen_utility_pvt.put_line( 'create_estimation_method ' ||
4245: p_api_version ||'-'||
4246: p_commit ||'-'||
4247: p_init_msg_list ||'-'||

Line 4244: csi_ctr_gen_utility_pvt.put_line( 'create_estimation_method ' ||

4240: END IF;
4241:
4242: -- If the debug level = 2 then dump all the parameters values.
4243: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
4244: csi_ctr_gen_utility_pvt.put_line( 'create_estimation_method ' ||
4245: p_api_version ||'-'||
4246: p_commit ||'-'||
4247: p_init_msg_list ||'-'||
4248: p_validation_level );

Line 4249: csi_ctr_gen_utility_pvt.dm_ctr_estimation_methods_rec(p_ctr_estimation_rec);

4245: p_api_version ||'-'||
4246: p_commit ||'-'||
4247: p_init_msg_list ||'-'||
4248: p_validation_level );
4249: csi_ctr_gen_utility_pvt.dm_ctr_estimation_methods_rec(p_ctr_estimation_rec);
4250: END IF;
4251:
4252: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
4253: CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_pre

Line 4272: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_pre API ');

4268: x_msg_data := FND_MSG_PUB.GET
4269: ( l_msg_index,
4270: FND_API.G_FALSE
4271: );
4272: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_pre API ');
4273: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4274: l_msg_index := l_msg_index + 1;
4275: l_msg_count := l_msg_count - 1;
4276: END LOOP;

Line 4273: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4269: ( l_msg_index,
4270: FND_API.G_FALSE
4271: );
4272: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_pre API ');
4273: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4274: l_msg_index := l_msg_index + 1;
4275: l_msg_count := l_msg_count - 1;
4276: END LOOP;
4277: RAISE FND_API.G_EXC_ERROR;

Line 4302: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_pre API ');

4298: x_msg_data := FND_MSG_PUB.GET
4299: ( l_msg_index,
4300: FND_API.G_FALSE
4301: );
4302: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_pre API ');
4303: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4304: l_msg_index := l_msg_index + 1;
4305: l_msg_count := l_msg_count - 1;
4306: END LOOP;

Line 4303: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4299: ( l_msg_index,
4300: FND_API.G_FALSE
4301: );
4302: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_pre API ');
4303: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4304: l_msg_index := l_msg_index + 1;
4305: l_msg_count := l_msg_count - 1;
4306: END LOOP;
4307: RAISE FND_API.G_EXC_ERROR;

Line 4331: csi_ctr_gen_utility_pvt.put_line( ' Error from csi_counter_template_pvt.create_estimation_method');

4327: WHILE l_msg_count > 0 LOOP
4328: x_msg_data := FND_MSG_PUB.GET
4329: (l_msg_index,
4330: FND_API.G_FALSE );
4331: csi_ctr_gen_utility_pvt.put_line( ' Error from csi_counter_template_pvt.create_estimation_method');
4332: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4333: l_msg_index := l_msg_index + 1;
4334: l_msg_count := l_msg_count - 1;
4335: END LOOP;

Line 4332: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4328: x_msg_data := FND_MSG_PUB.GET
4329: (l_msg_index,
4330: FND_API.G_FALSE );
4331: csi_ctr_gen_utility_pvt.put_line( ' Error from csi_counter_template_pvt.create_estimation_method');
4332: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4333: l_msg_index := l_msg_index + 1;
4334: l_msg_count := l_msg_count - 1;
4335: END LOOP;
4336: RAISE FND_API.G_EXC_ERROR;

Line 4342: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_post ..');

4338:
4339: -- Calling Post Customer User Hook
4340: BEGIN
4341: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
4342: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_post ..');
4343: CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_post
4344: (
4345: p_api_version => p_api_version
4346: ,p_init_msg_list => p_init_msg_list

Line 4373: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

4369: --
4370: END IF;
4371: EXCEPTION
4372: WHEN OTHERS THEN
4373: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
4374: RAISE FND_API.G_EXC_ERROR;
4375: END;
4376: --
4377: -- Calling Post Vertical User Hook

Line 4381: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_post ..');

4377: -- Calling Post Vertical User Hook
4378: BEGIN
4379:
4380: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
4381: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_post ..');
4382: CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_post
4383: ( p_api_version => p_api_version
4384: ,p_init_msg_list => p_init_msg_list
4385: ,p_commit => p_commit

Line 4400: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_post ');

4396: WHILE l_msg_count > 0 LOOP
4397: x_msg_data := FND_MSG_PUB.GET
4398: ( l_msg_index,
4399: FND_API.G_FALSE );
4400: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_post ');
4401: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4402: l_msg_index := l_msg_index + 1;
4403: l_msg_count := l_msg_count - 1;
4404: END LOOP;

Line 4401: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4397: x_msg_data := FND_MSG_PUB.GET
4398: ( l_msg_index,
4399: FND_API.G_FALSE );
4400: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_post ');
4401: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4402: l_msg_index := l_msg_index + 1;
4403: l_msg_count := l_msg_count - 1;
4404: END LOOP;
4405: RAISE FND_API.G_EXC_ERROR;

Line 4411: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

4407: --
4408: END IF;
4409: EXCEPTION
4410: WHEN OTHERS THEN
4411: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
4412: RAISE FND_API.G_EXC_ERROR;
4413: END;
4414: -- End of POST User Hooks
4415:

Line 4498: -- csi_ctr_gen_utility_pvt.check_ib_active;

4494: SAVEPOINT update_estimation_method;
4495:
4496: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4497:
4498: -- csi_ctr_gen_utility_pvt.check_ib_active;
4499:
4500: -- Standard call to check for call compatibility.
4501: IF NOT FND_API.Compatible_API_Call (l_api_version,
4502: p_api_version,

Line 4518: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

4514: -- Initialize API return status to success
4515: x_return_status := FND_API.G_RET_STS_SUCCESS;
4516:
4517: -- Read the debug profiles values in to global variable 7197402
4518: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
4519:
4520: -- Check the profile option debug_level for debug message reporting
4521: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4522:

Line 4524: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

4520: -- Check the profile option debug_level for debug message reporting
4521: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4522:
4523: -- If debug_level = 1 then dump the procedure name
4524: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
4525: csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method');
4526: END IF;
4527:
4528: -- If the debug level = 2 then dump all the parameters values.

Line 4525: csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method');

4521: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4522:
4523: -- If debug_level = 1 then dump the procedure name
4524: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
4525: csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method');
4526: END IF;
4527:
4528: -- If the debug level = 2 then dump all the parameters values.
4529: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 4529: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

4525: csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method');
4526: END IF;
4527:
4528: -- If the debug level = 2 then dump all the parameters values.
4529: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
4530: csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method ' ||
4531: p_api_version ||'-'||
4532: p_commit ||'-'||
4533: p_init_msg_list ||'-'||

Line 4530: csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method ' ||

4526: END IF;
4527:
4528: -- If the debug level = 2 then dump all the parameters values.
4529: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
4530: csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method ' ||
4531: p_api_version ||'-'||
4532: p_commit ||'-'||
4533: p_init_msg_list ||'-'||
4534: p_validation_level );

Line 4535: csi_ctr_gen_utility_pvt.dm_ctr_estimation_methods_rec(p_ctr_estimation_rec);

4531: p_api_version ||'-'||
4532: p_commit ||'-'||
4533: p_init_msg_list ||'-'||
4534: p_validation_level );
4535: csi_ctr_gen_utility_pvt.dm_ctr_estimation_methods_rec(p_ctr_estimation_rec);
4536: END IF;
4537:
4538: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
4539: CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre

Line 4558: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');

4554: x_msg_data := FND_MSG_PUB.GET
4555: ( l_msg_index,
4556: FND_API.G_FALSE
4557: );
4558: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
4559: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4560: l_msg_index := l_msg_index + 1;
4561: l_msg_count := l_msg_count - 1;
4562: END LOOP;

Line 4559: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4555: ( l_msg_index,
4556: FND_API.G_FALSE
4557: );
4558: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
4559: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4560: l_msg_index := l_msg_index + 1;
4561: l_msg_count := l_msg_count - 1;
4562: END LOOP;
4563: RAISE FND_API.G_EXC_ERROR;

Line 4588: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');

4584: x_msg_data := FND_MSG_PUB.GET
4585: ( l_msg_index,
4586: FND_API.G_FALSE
4587: );
4588: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
4589: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4590: l_msg_index := l_msg_index + 1;
4591: l_msg_count := l_msg_count - 1;
4592: END LOOP;

Line 4589: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4585: ( l_msg_index,
4586: FND_API.G_FALSE
4587: );
4588: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
4589: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4590: l_msg_index := l_msg_index + 1;
4591: l_msg_count := l_msg_count - 1;
4592: END LOOP;
4593: RAISE FND_API.G_EXC_ERROR;

Line 4618: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ESTIMATION_METHOD');

4614: WHILE l_msg_count > 0 LOOP
4615: x_msg_data := FND_MSG_PUB.GET
4616: (l_msg_index,
4617: FND_API.G_FALSE );
4618: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ESTIMATION_METHOD');
4619: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4620: l_msg_index := l_msg_index + 1;
4621: l_msg_count := l_msg_count - 1;
4622: END LOOP;

Line 4619: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4615: x_msg_data := FND_MSG_PUB.GET
4616: (l_msg_index,
4617: FND_API.G_FALSE );
4618: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ESTIMATION_METHOD');
4619: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4620: l_msg_index := l_msg_index + 1;
4621: l_msg_count := l_msg_count - 1;
4622: END LOOP;
4623: RAISE FND_API.G_EXC_ERROR;

Line 4629: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');

4625:
4626: -- Calling Post Customer User Hook
4627: BEGIN
4628: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
4629: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');
4630: CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post
4631: (
4632: p_api_version => p_api_version
4633: ,p_init_msg_list => p_init_msg_list

Line 4660: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

4656: --
4657: END IF;
4658: EXCEPTION
4659: WHEN OTHERS THEN
4660: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
4661: RAISE FND_API.G_EXC_ERROR;
4662: END;
4663: --
4664: -- Calling Post Vertical User Hook

Line 4668: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');

4664: -- Calling Post Vertical User Hook
4665: BEGIN
4666:
4667: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
4668: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');
4669: CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post
4670: (
4671: p_api_version => p_api_version
4672: ,p_init_msg_list => p_init_msg_list

Line 4688: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post API ');

4684: WHILE l_msg_count > 0 LOOP
4685: x_msg_data := FND_MSG_PUB.GET
4686: ( l_msg_index,
4687: FND_API.G_FALSE );
4688: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post API ');
4689: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4690: l_msg_index := l_msg_index + 1;
4691: l_msg_count := l_msg_count - 1;
4692: END LOOP;

Line 4689: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4685: x_msg_data := FND_MSG_PUB.GET
4686: ( l_msg_index,
4687: FND_API.G_FALSE );
4688: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post API ');
4689: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4690: l_msg_index := l_msg_index + 1;
4691: l_msg_count := l_msg_count - 1;
4692: END LOOP;
4693: RAISE FND_API.G_EXC_ERROR;

Line 4699: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

4695: --
4696: END IF;
4697: EXCEPTION
4698: WHEN OTHERS THEN
4699: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
4700: RAISE FND_API.G_EXC_ERROR;
4701: END;
4702: -- End of POST User Hooks
4703: -- End of API body

Line 4833: -- csi_ctr_gen_utility_pvt.check_ib_active;

4829: SAVEPOINT autoinstantiate_counters;
4830:
4831: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4832:
4833: -- csi_ctr_gen_utility_pvt.check_ib_active;
4834:
4835: -- Standard call to check for call compatibility.
4836: IF NOT FND_API.Compatible_API_Call (l_api_version,
4837: p_api_version,

Line 4853: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

4849: -- Initialize API return status to success
4850: x_return_status := FND_API.G_RET_STS_SUCCESS;
4851:
4852: -- Read the debug profiles values in to global variable 7197402
4853: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
4854:
4855: -- Check the profile option debug_level for debug message reporting
4856: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4857:

Line 4859: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

4855: -- Check the profile option debug_level for debug message reporting
4856: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4857:
4858: -- If debug_level = 1 then dump the procedure name
4859: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
4860: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');
4861: END IF;
4862:
4863: -- If the debug level = 2 then dump all the parameters values.

Line 4860: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');

4856: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4857:
4858: -- If debug_level = 1 then dump the procedure name
4859: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
4860: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');
4861: END IF;
4862:
4863: -- If the debug level = 2 then dump all the parameters values.
4864: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 4864: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

4860: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');
4861: END IF;
4862:
4863: -- If the debug level = 2 then dump all the parameters values.
4864: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
4865: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters' ||
4866: p_api_version ||'-'||
4867: p_commit ||'-'||
4868: p_init_msg_list ||'-'||

Line 4865: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters' ||

4861: END IF;
4862:
4863: -- If the debug level = 2 then dump all the parameters values.
4864: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
4865: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters' ||
4866: p_api_version ||'-'||
4867: p_commit ||'-'||
4868: p_init_msg_list ||'-'||
4869: l_validation_level );

Line 4870: -- csi_ctr_gen_utility_pvt.dump_instantiate_ctr_rec(p_);

4866: p_api_version ||'-'||
4867: p_commit ||'-'||
4868: p_init_msg_list ||'-'||
4869: l_validation_level );
4870: -- csi_ctr_gen_utility_pvt.dump_instantiate_ctr_rec(p_);
4871: END IF;
4872:
4873: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
4874: CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_pre

Line 4899: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_pre API ');

4895: x_msg_data := FND_MSG_PUB.GET
4896: ( l_msg_index,
4897: FND_API.G_FALSE
4898: );
4899: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_pre API ');
4900: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4901: l_msg_index := l_msg_index + 1;
4902: l_msg_count := l_msg_count - 1;
4903: END LOOP;

Line 4900: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4896: ( l_msg_index,
4897: FND_API.G_FALSE
4898: );
4899: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_pre API ');
4900: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4901: l_msg_index := l_msg_index + 1;
4902: l_msg_count := l_msg_count - 1;
4903: END LOOP;
4904: RAISE FND_API.G_EXC_ERROR;

Line 4934: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_pre API ');

4930: x_msg_data := FND_MSG_PUB.GET
4931: ( l_msg_index,
4932: FND_API.G_FALSE
4933: );
4934: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_pre API ');
4935: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4936: l_msg_index := l_msg_index + 1;
4937: l_msg_count := l_msg_count - 1;
4938: END LOOP;

Line 4935: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

4931: ( l_msg_index,
4932: FND_API.G_FALSE
4933: );
4934: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_pre API ');
4935: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4936: l_msg_index := l_msg_index + 1;
4937: l_msg_count := l_msg_count - 1;
4938: END LOOP;
4939: RAISE FND_API.G_EXC_ERROR;

Line 4955: csi_ctr_gen_utility_PVT.ExitWithErrMsg('CSI_API_CTR_INVALID_ITEM','ITEM',l_item);

4951: AND organization_id = p_organization_id --cs_std.get_item_valdn_orgzn_id
4952: AND (NVL(COMMS_NL_TRACKABLE_FLAG,'N') = 'Y' or NVL(service_item_flag,'N') = 'Y');
4953: EXCEPTION
4954: WHEN NO_DATA_FOUND THEN
4955: csi_ctr_gen_utility_PVT.ExitWithErrMsg('CSI_API_CTR_INVALID_ITEM','ITEM',l_item);
4956: END;
4957:
4958: IF l_COMMS_NL_TRACKABLE_FLAG = 'Y' THEN
4959: l_source_object_cd := 'CP';

Line 4990: csi_ctr_gen_utility_pvt.put_line( ' EAM Item Type = '||to_char(l_eam_item_type));

4986: NULL;
4987: END;
4988: END IF;
4989: /* End of checking*/
4990: csi_ctr_gen_utility_pvt.put_line( ' EAM Item Type = '||to_char(l_eam_item_type));
4991: csi_ctr_gen_utility_pvt.put_line( ' Maint organization id = '||to_char(l_curr_maint_org_id));
4992:
4993: -- For each counter property, counter belonging to the counter group
4994: -- attched to the source_object_id_template, call Create_Ctr_Prop_Instance,

Line 4991: csi_ctr_gen_utility_pvt.put_line( ' Maint organization id = '||to_char(l_curr_maint_org_id));

4987: END;
4988: END IF;
4989: /* End of checking*/
4990: csi_ctr_gen_utility_pvt.put_line( ' EAM Item Type = '||to_char(l_eam_item_type));
4991: csi_ctr_gen_utility_pvt.put_line( ' Maint organization id = '||to_char(l_curr_maint_org_id));
4992:
4993: -- For each counter property, counter belonging to the counter group
4994: -- attched to the source_object_id_template, call Create_Ctr_Prop_Instance,
4995: -- Create_Counter_Instance and Create_Ctr_Grp_Instance.

Line 5008: csi_ctr_gen_utility_PVT.ExitWithErrMsg('CSI_API_CTR_ITEM_HAS_NO_CTRS','ITEM',l_item);

5004: WHEN NO_DATA_FOUND THEN
5005: -- This item does not have any counters. Raise a warning message that
5006: -- no counters were instantiated but do not error out. Return control
5007: -- to the caller.
5008: csi_ctr_gen_utility_PVT.ExitWithErrMsg('CSI_API_CTR_ITEM_HAS_NO_CTRS','ITEM',l_item);
5009: END;
5010: */
5011:
5012: FOR item_rec in ctr_item_assoc(p_source_object_id_template)

Line 5038: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate_Counters');

5034: WHILE l_msg_count > 0 LOOP
5035: x_msg_data := FND_MSG_PUB.GET
5036: (l_msg_index,
5037: FND_API.G_FALSE );
5038: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate_Counters');
5039: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5040: l_msg_index := l_msg_index + 1;
5041: l_msg_count := l_msg_count - 1;
5042: END LOOP;

Line 5039: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5035: x_msg_data := FND_MSG_PUB.GET
5036: (l_msg_index,
5037: FND_API.G_FALSE );
5038: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate_Counters');
5039: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5040: l_msg_index := l_msg_index + 1;
5041: l_msg_count := l_msg_count - 1;
5042: END LOOP;
5043: RAISE FND_API.G_EXC_ERROR;

Line 5078: csi_ctr_gen_utility_pvt.put_line('Old Group id template = '||to_char(x_ctr_grp_id_template));

5074: );
5075:
5076: x_ctr_grp_id_template := grp_rec.group_id;
5077:
5078: csi_ctr_gen_utility_pvt.put_line('Old Group id template = '||to_char(x_ctr_grp_id_template));
5079: csi_ctr_gen_utility_pvt.put_line('New Group id template = '||to_char(x_ctr_grp_id_instance));
5080:
5081: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5082: l_msg_index := 1;

Line 5079: csi_ctr_gen_utility_pvt.put_line('New Group id template = '||to_char(x_ctr_grp_id_instance));

5075:
5076: x_ctr_grp_id_template := grp_rec.group_id;
5077:
5078: csi_ctr_gen_utility_pvt.put_line('Old Group id template = '||to_char(x_ctr_grp_id_template));
5079: csi_ctr_gen_utility_pvt.put_line('New Group id template = '||to_char(x_ctr_grp_id_instance));
5080:
5081: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5082: l_msg_index := 1;
5083: l_msg_count := x_msg_count;

Line 5089: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate Group Counters');

5085: WHILE l_msg_count > 0 LOOP
5086: x_msg_data := FND_MSG_PUB.GET
5087: (l_msg_index,
5088: FND_API.G_FALSE );
5089: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate Group Counters');
5090: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5091: l_msg_index := l_msg_index + 1;
5092: l_msg_count := l_msg_count - 1;
5093: END LOOP;

Line 5090: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5086: x_msg_data := FND_MSG_PUB.GET
5087: (l_msg_index,
5088: FND_API.G_FALSE );
5089: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate Group Counters');
5090: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5091: l_msg_index := l_msg_index + 1;
5092: l_msg_count := l_msg_count - 1;
5093: END LOOP;
5094: RAISE FND_API.G_EXC_ERROR;

Line 5102: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_Post ..');

5098:
5099: -- Calling Post Customer User Hook
5100: BEGIN
5101: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
5102: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_Post ..');
5103: CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_Post
5104: (
5105: p_api_version => p_api_version
5106: ,p_init_msg_list => p_init_msg_list

Line 5138: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

5134: --
5135: END IF;
5136: EXCEPTION
5137: WHEN OTHERS THEN
5138: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
5139: RAISE FND_API.G_EXC_ERROR;
5140: END;
5141: --
5142: -- Calling Post Vertical User Hook

Line 5146: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_Post ..');

5142: -- Calling Post Vertical User Hook
5143: BEGIN
5144:
5145: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
5146: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_Post ..');
5147: CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_Post
5148: (
5149: p_api_version => p_api_version
5150: ,p_init_msg_list => p_init_msg_list

Line 5171: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_Post API ');

5167: WHILE l_msg_count > 0 LOOP
5168: x_msg_data := FND_MSG_PUB.GET
5169: ( l_msg_index,
5170: FND_API.G_FALSE );
5171: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_Post API ');
5172: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5173: l_msg_index := l_msg_index + 1;
5174: l_msg_count := l_msg_count - 1;
5175: END LOOP;

Line 5172: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5168: x_msg_data := FND_MSG_PUB.GET
5169: ( l_msg_index,
5170: FND_API.G_FALSE );
5171: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_Post API ');
5172: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5173: l_msg_index := l_msg_index + 1;
5174: l_msg_count := l_msg_count - 1;
5175: END LOOP;
5176: RAISE FND_API.G_EXC_ERROR;

Line 5182: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

5178: --
5179: END IF;
5180: EXCEPTION
5181: WHEN OTHERS THEN
5182: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
5183: RAISE FND_API.G_EXC_ERROR;
5184: END;
5185: -- End of POST User Hooks
5186: -- End of API body

Line 5335: -- csi_ctr_gen_utility_pvt.check_ib_active;

5331: SAVEPOINT instantiate_counters;
5332:
5333: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5334:
5335: -- csi_ctr_gen_utility_pvt.check_ib_active;
5336:
5337: -- Standard call to check for call compatibility.
5338: IF NOT FND_API.Compatible_API_Call (l_api_version,
5339: p_api_version,

Line 5355: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

5351: -- Initialize API return status to success
5352: x_return_status := FND_API.G_RET_STS_SUCCESS;
5353:
5354: -- Read the debug profiles values in to global variable 7197402
5355: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
5356:
5357: -- Check the profile option debug_level for debug message reporting
5358: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5359:

Line 5361: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

5357: -- Check the profile option debug_level for debug message reporting
5358: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5359:
5360: -- If debug_level = 1 then dump the procedure name
5361: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
5362: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');
5363: END IF;
5364:
5365: -- If the debug level = 2 then dump all the parameters values.

Line 5362: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');

5358: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5359:
5360: -- If debug_level = 1 then dump the procedure name
5361: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
5362: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');
5363: END IF;
5364:
5365: -- If the debug level = 2 then dump all the parameters values.
5366: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 5366: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

5362: csi_ctr_gen_utility_pvt.put_line( 'autoinstantiate_counters');
5363: END IF;
5364:
5365: -- If the debug level = 2 then dump all the parameters values.
5366: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
5367: csi_ctr_gen_utility_pvt.put_line( 'instantiate_counters' ||
5368: p_api_version ||'-'||
5369: p_commit ||'-'||
5370: p_init_msg_list ||'-'||

Line 5367: csi_ctr_gen_utility_pvt.put_line( 'instantiate_counters' ||

5363: END IF;
5364:
5365: -- If the debug level = 2 then dump all the parameters values.
5366: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
5367: csi_ctr_gen_utility_pvt.put_line( 'instantiate_counters' ||
5368: p_api_version ||'-'||
5369: p_commit ||'-'||
5370: p_init_msg_list ||'-'||
5371: l_validation_level );

Line 5372: -- csi_ctr_gen_utility_pvt.dump_instantiate_ctr_rec(p_);

5368: p_api_version ||'-'||
5369: p_commit ||'-'||
5370: p_init_msg_list ||'-'||
5371: l_validation_level );
5372: -- csi_ctr_gen_utility_pvt.dump_instantiate_ctr_rec(p_);
5373: END IF;
5374:
5375: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' )) then
5376: CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_pre

Line 5398: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_pre API ');

5394: x_msg_data := FND_MSG_PUB.GET
5395: ( l_msg_index,
5396: FND_API.G_FALSE
5397: );
5398: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_pre API ');
5399: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5400: l_msg_index := l_msg_index + 1;
5401: l_msg_count := l_msg_count - 1;
5402: END LOOP;

Line 5399: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5395: ( l_msg_index,
5396: FND_API.G_FALSE
5397: );
5398: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_pre API ');
5399: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5400: l_msg_index := l_msg_index + 1;
5401: l_msg_count := l_msg_count - 1;
5402: END LOOP;
5403: RAISE FND_API.G_EXC_ERROR;

Line 5431: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_pre API ');

5427: x_msg_data := FND_MSG_PUB.GET
5428: ( l_msg_index,
5429: FND_API.G_FALSE
5430: );
5431: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_pre API ');
5432: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5433: l_msg_index := l_msg_index + 1;
5434: l_msg_count := l_msg_count - 1;
5435: END LOOP;

Line 5432: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5428: ( l_msg_index,
5429: FND_API.G_FALSE
5430: );
5431: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_pre API ');
5432: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5433: l_msg_index := l_msg_index + 1;
5434: l_msg_count := l_msg_count - 1;
5435: END LOOP;
5436: RAISE FND_API.G_EXC_ERROR;

Line 5465: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.INSTANTIATE_COUNTERS');

5461: WHILE l_msg_count > 0 LOOP
5462: x_msg_data := FND_MSG_PUB.GET
5463: (l_msg_index,
5464: FND_API.G_FALSE );
5465: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.INSTANTIATE_COUNTERS');
5466: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5467: l_msg_index := l_msg_index + 1;
5468: l_msg_count := l_msg_count - 1;
5469: END LOOP;

Line 5466: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5462: x_msg_data := FND_MSG_PUB.GET
5463: (l_msg_index,
5464: FND_API.G_FALSE );
5465: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.INSTANTIATE_COUNTERS');
5466: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5467: l_msg_index := l_msg_index + 1;
5468: l_msg_count := l_msg_count - 1;
5469: END LOOP;
5470: RAISE FND_API.G_EXC_ERROR;

Line 5476: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_Post ..');

5472:
5473: -- Calling Post Customer User Hook
5474: BEGIN
5475: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
5476: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_Post ..');
5477: CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_Post
5478: (
5479: p_api_version => p_api_version
5480: ,p_init_msg_list => p_init_msg_list

Line 5510: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

5506: --
5507: END IF;
5508: EXCEPTION
5509: WHEN OTHERS THEN
5510: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
5511: RAISE FND_API.G_EXC_ERROR;
5512: END;
5513:
5514: --

Line 5519: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_Post ..');

5515: -- Calling Post Vertical User Hook
5516: BEGIN
5517:
5518: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
5519: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_Post ..');
5520: CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_Post
5521: (
5522: p_api_version => p_api_version
5523: ,p_init_msg_list => p_init_msg_list

Line 5542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_Post API ');

5538: WHILE l_msg_count > 0 LOOP
5539: x_msg_data := FND_MSG_PUB.GET
5540: ( l_msg_index,
5541: FND_API.G_FALSE );
5542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_Post API ');
5543: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5544: l_msg_index := l_msg_index + 1;
5545: l_msg_count := l_msg_count - 1;
5546: END LOOP;

Line 5543: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5539: x_msg_data := FND_MSG_PUB.GET
5540: ( l_msg_index,
5541: FND_API.G_FALSE );
5542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_Post API ');
5543: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5544: l_msg_index := l_msg_index + 1;
5545: l_msg_count := l_msg_count - 1;
5546: END LOOP;
5547: RAISE FND_API.G_EXC_ERROR;

Line 5553: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

5549: --
5550: END IF;
5551: EXCEPTION
5552: WHEN OTHERS THEN
5553: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
5554: RAISE FND_API.G_EXC_ERROR;
5555: END;
5556: -- End of POST User Hooks
5557: -- End of API body

Line 5663: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

5659: -- Initialize API return status to success
5660: x_return_status := FND_API.G_RET_STS_SUCCESS;
5661:
5662: -- Read the debug profiles values in to global variable 7197402
5663: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
5664:
5665: -- Check the profile option debug_level for debug message reporting
5666: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5667:

Line 5669: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN

5665: -- Check the profile option debug_level for debug message reporting
5666: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5667:
5668: -- If debug_level = 1 then dump the procedure name
5669: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
5670: csi_ctr_gen_utility_pvt.put_line( 'delete_item_association');
5671: END IF;
5672:
5673: -- If the debug level = 2 then dump all the parameters values.

Line 5670: csi_ctr_gen_utility_pvt.put_line( 'delete_item_association');

5666: -- l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5667:
5668: -- If debug_level = 1 then dump the procedure name
5669: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
5670: csi_ctr_gen_utility_pvt.put_line( 'delete_item_association');
5671: END IF;
5672:
5673: -- If the debug level = 2 then dump all the parameters values.
5674: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

Line 5674: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN

5670: csi_ctr_gen_utility_pvt.put_line( 'delete_item_association');
5671: END IF;
5672:
5673: -- If the debug level = 2 then dump all the parameters values.
5674: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
5675: csi_ctr_gen_utility_pvt.put_line('delete_item_association' ||
5676: p_api_version ||'-'||
5677: p_commit ||'-'||
5678: p_init_msg_list ||'-'||

Line 5675: csi_ctr_gen_utility_pvt.put_line('delete_item_association' ||

5671: END IF;
5672:
5673: -- If the debug level = 2 then dump all the parameters values.
5674: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
5675: csi_ctr_gen_utility_pvt.put_line('delete_item_association' ||
5676: p_api_version ||'-'||
5677: p_commit ||'-'||
5678: p_init_msg_list ||'-'||
5679: p_validation_level );

Line 5703: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_PRE API ');

5699: x_msg_data := FND_MSG_PUB.GET
5700: ( l_msg_index,
5701: FND_API.G_FALSE
5702: );
5703: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
5704: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5705: l_msg_index := l_msg_index + 1;
5706: l_msg_count := l_msg_count - 1;
5707: END LOOP;

Line 5704: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5700: ( l_msg_index,
5701: FND_API.G_FALSE
5702: );
5703: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
5704: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5705: l_msg_index := l_msg_index + 1;
5706: l_msg_count := l_msg_count - 1;
5707: END LOOP;
5708: RAISE FND_API.G_EXC_ERROR;

Line 5733: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_PRE API ');

5729: x_msg_data := FND_MSG_PUB.GET
5730: ( l_msg_index,
5731: FND_API.G_FALSE
5732: );
5733: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
5734: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5735: l_msg_index := l_msg_index + 1;
5736: l_msg_count := l_msg_count - 1;
5737: END LOOP;

Line 5734: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5730: ( l_msg_index,
5731: FND_API.G_FALSE
5732: );
5733: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
5734: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5735: l_msg_index := l_msg_index + 1;
5736: l_msg_count := l_msg_count - 1;
5737: END LOOP;
5738: RAISE FND_API.G_EXC_ERROR;

Line 5762: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.DELETE_ITEM_ASSOCIATION');

5758: WHILE l_msg_count > 0 LOOP
5759: x_msg_data := FND_MSG_PUB.GET
5760: (l_msg_index,
5761: FND_API.G_FALSE );
5762: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.DELETE_ITEM_ASSOCIATION');
5763: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5764: l_msg_index := l_msg_index + 1;
5765: l_msg_count := l_msg_count - 1;
5766: END LOOP;

Line 5763: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5759: x_msg_data := FND_MSG_PUB.GET
5760: (l_msg_index,
5761: FND_API.G_FALSE );
5762: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.DELETE_ITEM_ASSOCIATION');
5763: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5764: l_msg_index := l_msg_index + 1;
5765: l_msg_count := l_msg_count - 1;
5766: END LOOP;
5767: RAISE FND_API.G_EXC_ERROR;

Line 5773: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post ..');

5769:
5770: -- Calling Post Customer User Hook
5771: BEGIN
5772: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
5773: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post ..');
5774: CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post
5775: (
5776: p_api_version => 1.0
5777: ,p_commit => fnd_api.g_false

Line 5804: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');

5800: --
5801: END IF;
5802: EXCEPTION
5803: WHEN OTHERS THEN
5804: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
5805: RAISE FND_API.G_EXC_ERROR;
5806: END;
5807: --
5808: -- Calling Post Vertical User Hook

Line 5812: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.DELTE_ITEM_ASSOCIATION_Post ..');

5808: -- Calling Post Vertical User Hook
5809: BEGIN
5810:
5811: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
5812: csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.DELTE_ITEM_ASSOCIATION_Post ..');
5813: CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post
5814: (
5815: p_api_version => 1.0
5816: ,p_commit => fnd_api.g_false

Line 5832: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post API ');

5828: WHILE l_msg_count > 0 LOOP
5829: x_msg_data := FND_MSG_PUB.GET
5830: ( l_msg_index,
5831: FND_API.G_FALSE );
5832: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post API ');
5833: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5834: l_msg_index := l_msg_index + 1;
5835: l_msg_count := l_msg_count - 1;
5836: END LOOP;

Line 5833: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

5829: x_msg_data := FND_MSG_PUB.GET
5830: ( l_msg_index,
5831: FND_API.G_FALSE );
5832: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post API ');
5833: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5834: l_msg_index := l_msg_index + 1;
5835: l_msg_count := l_msg_count - 1;
5836: END LOOP;
5837: RAISE FND_API.G_EXC_ERROR;

Line 5843: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');

5839: --
5840: END IF;
5841: EXCEPTION
5842: WHEN OTHERS THEN
5843: csi_ctr_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
5844: RAISE FND_API.G_EXC_ERROR;
5845: END;
5846: -- End of POST User Hooks
5847: