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_SYSTEMS_PVT dependencies on CSI_GEN_UTILITY_PVT

Line 969: csi_gen_utility_pvt.put_line( 'get_system');

965: x_return_status := fnd_api.g_ret_sts_success;
966:
967: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
968: IF (l_debug_level > 0) THEN
969: csi_gen_utility_pvt.put_line( 'get_system');
970: END IF;
971:
972: IF (l_debug_level > 1) THEN
973: csi_gen_utility_pvt.put_line(

Line 973: csi_gen_utility_pvt.put_line(

969: csi_gen_utility_pvt.put_line( 'get_system');
970: END IF;
971:
972: IF (l_debug_level > 1) THEN
973: csi_gen_utility_pvt.put_line(
974: p_api_version ||'-'||
975: p_Commit ||'-'||
976: p_Init_Msg_list ||'-'||
977: p_Validation_level ||'-'||

Line 981: csi_gen_utility_pvt.dump_sys_query_rec(p_system_query_rec);

977: p_Validation_level ||'-'||
978: p_time_stamp ||'-'||
979: p_active_systems_only
980: );
981: csi_gen_utility_pvt.dump_sys_query_rec(p_system_query_rec);
982: END IF;
983:
984: IF
985: ( ((p_system_query_rec.system_id IS NULL) OR (p_system_query_rec.system_id = fnd_api.g_miss_num))

Line 1043: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||

1039: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE))
1040: THEN
1041: IF ((l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date))
1042: THEN
1043: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
1044: 'Please provide a valid datetime stamp.');
1045: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
1046: FND_MSG_PUB.ADD;
1047: ELSE

Line 1241: csi_gen_utility_pvt.populate_install_param_rec;

1237: BEGIN
1238: x_return_status := fnd_api.g_ret_sts_success;
1239:
1240: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1241: csi_gen_utility_pvt.populate_install_param_rec;
1242: END IF;
1243: --
1244: l_full_dump := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
1245: --

Line 2555: csi_gen_utility_pvt.put_line( 'create_system');

2551: x_return_status := fnd_api.g_ret_sts_success;
2552:
2553: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2554: IF (l_debug_level > 0) THEN
2555: csi_gen_utility_pvt.put_line( 'create_system');
2556: END IF;
2557:
2558: IF (l_debug_level > 1) THEN
2559: csi_gen_utility_pvt.put_line(

Line 2559: csi_gen_utility_pvt.put_line(

2555: csi_gen_utility_pvt.put_line( 'create_system');
2556: END IF;
2557:
2558: IF (l_debug_level > 1) THEN
2559: csi_gen_utility_pvt.put_line(
2560: p_api_version ||'-'||
2561: p_Commit ||'-'||
2562: p_Init_Msg_list ||'-'||
2563: p_Validation_level

Line 2565: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);

2561: p_Commit ||'-'||
2562: p_Init_Msg_list ||'-'||
2563: p_Validation_level
2564: );
2565: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
2566: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2567: END IF;
2568: -- invoke validation procedures
2569:

Line 2566: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

2562: p_Init_Msg_list ||'-'||
2563: p_Validation_level
2564: );
2565: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
2566: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2567: END IF;
2568: -- invoke validation procedures
2569:
2570: validate_system_id(

Line 3110: csi_gen_utility_pvt.put_line( 'update_system');

3106:
3107:
3108: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3109: IF (l_debug_level > 0) THEN
3110: csi_gen_utility_pvt.put_line( 'update_system');
3111: END IF;
3112:
3113: IF (l_debug_level > 1) THEN
3114: csi_gen_utility_pvt.put_line(

Line 3114: csi_gen_utility_pvt.put_line(

3110: csi_gen_utility_pvt.put_line( 'update_system');
3111: END IF;
3112:
3113: IF (l_debug_level > 1) THEN
3114: csi_gen_utility_pvt.put_line(
3115: p_api_version ||'-'||
3116: p_Commit ||'-'||
3117: p_Init_Msg_list ||'-'||
3118: p_Validation_level

Line 3120: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);

3116: p_Commit ||'-'||
3117: p_Init_Msg_list ||'-'||
3118: p_Validation_level
3119: );
3120: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
3121: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
3122: END IF;
3123: --
3124: IF p_system_rec.customer_id IS NULL THEN

Line 3121: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

3117: p_Init_Msg_list ||'-'||
3118: p_Validation_level
3119: );
3120: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
3121: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
3122: END IF;
3123: --
3124: IF p_system_rec.customer_id IS NULL THEN
3125: fnd_message.set_name('CSI', 'CSI_API_MANDATORY_CUSTOMER');

Line 3254: csi_gen_utility_pvt.put_line('p_system_rec.end_date_active is '||to_char(p_system_rec.end_date_active,'DD-MON-YYYY HH24:MI:SS'));

3250: RAISE fnd_api.g_exc_error;
3251: END IF;
3252: END IF;
3253: --
3254: csi_gen_utility_pvt.put_line('p_system_rec.end_date_active is '||to_char(p_system_rec.end_date_active,'DD-MON-YYYY HH24:MI:SS'));
3255: IF (p_system_rec.end_date_active IS NOT NULL
3256: AND p_system_rec.end_date_active <> fnd_api.g_miss_date
3257: AND p_system_rec.end_date_active <> nvl(l_sys_csr.end_date_active,fnd_api.g_miss_date)
3258: AND p_system_rec.end_date_active >= SYSDATE)

Line 3558: csi_gen_utility_pvt.put_line('Instance '||to_char(v_rec.instance_id)||' Already Transfered');

3554: -- srramakr Bug # 3531056
3555: -- If the child instance also belongs to the same system then the ownership would have got
3556: -- cascaded from the parent. So, there is no need to change the owner again.
3557: IF l_exists = 'Y' THEN
3558: csi_gen_utility_pvt.put_line('Instance '||to_char(v_rec.instance_id)||' Already Transfered');
3559: Raise Process_next;
3560: END IF;
3561: --
3562: l_party_tbl := l_init_party_tbl;

Line 3593: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');

3589: ,x_msg_data => x_msg_data
3590: );
3591:
3592: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3593: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PUB.. ');
3594: l_msg_index := 1;
3595: l_msg_count := x_msg_count;
3596: WHILE l_msg_count > 0
3597: LOOP

Line 3601: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3597: LOOP
3598: x_msg_data := FND_MSG_PUB.GET
3599: ( l_msg_index,
3600: FND_API.G_FALSE );
3601: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3602: l_msg_index := l_msg_index + 1;
3603: l_msg_count := l_msg_count - 1;
3604: END LOOP;
3605: RAISE FND_API.G_EXC_ERROR;

Line 3614: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);

3610: End;
3611: End Loop;
3612: --
3613: IF px_oks_txn_inst_tbl.count > 0 THEN
3614: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
3615: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
3616: --
3617: IF p_txn_rec.transaction_type_id = 3 THEN
3618: l_batch_id := p_txn_rec.source_header_ref_id;

Line 3615: csi_gen_utility_pvt.put_line('Calling OKS Core API...');

3611: End Loop;
3612: --
3613: IF px_oks_txn_inst_tbl.count > 0 THEN
3614: csi_gen_utility_pvt.dump_oks_txn_inst_tbl(px_oks_txn_inst_tbl);
3615: csi_gen_utility_pvt.put_line('Calling OKS Core API...');
3616: --
3617: IF p_txn_rec.transaction_type_id = 3 THEN
3618: l_batch_id := p_txn_rec.source_header_ref_id;
3619: l_batch_type := p_txn_rec.source_group_ref;

Line 3649: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');

3645: WHILE l_msg_count > 0 LOOP
3646: x_msg_data := FND_MSG_PUB.GET
3647: ( l_msg_index,
3648: FND_API.G_FALSE );
3649: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
3650: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3651: l_msg_index := l_msg_index + 1;
3652: l_msg_count := l_msg_count - 1;
3653: END LOOP;

Line 3650: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3646: x_msg_data := FND_MSG_PUB.GET
3647: ( l_msg_index,
3648: FND_API.G_FALSE );
3649: csi_gen_utility_pvt.put_line( 'Error from OKS_IBINT_PUB.IB_interface..');
3650: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3651: l_msg_index := l_msg_index + 1;
3652: l_msg_count := l_msg_count - 1;
3653: END LOOP;
3654: RAISE FND_API.G_EXC_ERROR;

Line 3704: csi_gen_utility_pvt.put_line('Install Location for instance '||to_char(v_install_rec.instance_id)||' already changed..');

3700: -- If the child instance also belongs to the same system then the install location
3701: -- would have got cascaded from the parent. So, there is no need to change this again.
3702: --
3703: IF l_exists = 'Y' THEN
3704: csi_gen_utility_pvt.put_line('Install Location for instance '||to_char(v_install_rec.instance_id)||' already changed..');
3705: Raise Process_next;
3706: END IF;
3707: --
3708: l_instance_rec.instance_id := v_install_rec.instance_id;

Line 3733: csi_gen_utility_pvt.put_line('Error from csi_item_instance_pvt.update_item_instance while updating Install Location.');

3729: ,p_oks_txn_inst_tbl => px_oks_txn_inst_tbl
3730: ,p_child_inst_tbl => px_child_inst_tbl
3731: );
3732: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) Then
3733: csi_gen_utility_pvt.put_line('Error from csi_item_instance_pvt.update_item_instance while updating Install Location.');
3734: l_msg_index := 1;
3735: l_msg_count := x_msg_count;
3736: While l_msg_count > 0
3737: Loop

Line 3741: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3737: Loop
3738: x_msg_data := FND_MSG_PUB.GET
3739: ( l_msg_index,
3740: FND_API.G_FALSE );
3741: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3742: l_msg_index := l_msg_index + 1;
3743: l_msg_count := l_msg_count - 1;
3744: End Loop;
3745: Raise FND_API.G_EXC_ERROR;

Line 3813: csi_gen_utility_pvt.put_line('Error from while updating Accounts.');

3809: ,x_msg_count => x_msg_count
3810: ,x_msg_data => x_msg_data
3811: );
3812: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3813: csi_gen_utility_pvt.put_line('Error from while updating Accounts.');
3814: l_msg_index := 1;
3815: l_msg_count := x_msg_count;
3816: WHILE l_msg_count > 0
3817: LOOP

Line 3821: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3817: LOOP
3818: x_msg_data := FND_MSG_PUB.GET
3819: ( l_msg_index,
3820: FND_API.G_FALSE );
3821: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3822: l_msg_index := l_msg_index + 1;
3823: l_msg_count := l_msg_count - 1;
3824: END LOOP;
3825: RAISE FND_API.G_EXC_ERROR;

Line 3910: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PVT.. ');

3906: ,x_msg_data => x_msg_data
3907: );
3908:
3909: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3910: csi_gen_utility_pvt.put_line('Error from CSI_PARTY_RELATIONSHIPS_PVT.. ');
3911: l_msg_index := 1;
3912: l_msg_count := x_msg_count;
3913: WHILE l_msg_count > 0
3914: LOOP

Line 3918: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

3914: LOOP
3915: x_msg_data := FND_MSG_PUB.GET
3916: ( l_msg_index,
3917: FND_API.G_FALSE );
3918: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
3919: l_msg_index := l_msg_index + 1;
3920: l_msg_count := l_msg_count - 1;
3921: END LOOP;
3922: RAISE FND_API.G_EXC_ERROR;

Line 4088: csi_gen_utility_pvt.put_line( 'expire_system');

4084: x_return_status := fnd_api.g_ret_sts_success;
4085:
4086: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4087: IF (l_debug_level > 0) THEN
4088: csi_gen_utility_pvt.put_line( 'expire_system');
4089: END IF;
4090:
4091: IF (l_debug_level > 1) THEN
4092: csi_gen_utility_pvt.put_line(

Line 4092: csi_gen_utility_pvt.put_line(

4088: csi_gen_utility_pvt.put_line( 'expire_system');
4089: END IF;
4090:
4091: IF (l_debug_level > 1) THEN
4092: csi_gen_utility_pvt.put_line(
4093: p_api_version ||'-'||
4094: p_Commit ||'-'||
4095: p_Init_Msg_list ||'-'||
4096: p_Validation_level

Line 4098: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

4094: p_Commit ||'-'||
4095: p_Init_Msg_list ||'-'||
4096: p_Validation_level
4097: );
4098: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4099: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
4100: END IF;
4101:
4102: OPEN systems_csr (p_system_rec.system_id);

Line 4099: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);

4095: p_Init_Msg_list ||'-'||
4096: p_Validation_level
4097: );
4098: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
4099: csi_gen_utility_pvt.dump_sys_rec(p_system_rec);
4100: END IF;
4101:
4102: OPEN systems_csr (p_system_rec.system_id);
4103: FETCH systems_csr INTO l_sys_csr;

Line 4132: csi_gen_utility_pvt.put_line('Inside Expire System');

4128: x_return_status => x_return_status,
4129: x_msg_count => x_msg_count,
4130: x_msg_data => x_msg_data);
4131:
4132: csi_gen_utility_pvt.put_line('Inside Expire System');
4133: IF x_return_status<>fnd_api.g_ret_sts_success THEN
4134: RAISE fnd_api.g_exc_error;
4135: END IF;
4136:

Line 4195: csi_gen_utility_pvt.put_line('Instance '||to_char(expire_csr.instance_id)||' Already expired');

4191: -- srramakr Bug # 3531056
4192: -- If the child instance also belongs to the same system then it would have got
4193: -- terminated when its parent got terminated. So, there is no need terminate it again.
4194: IF l_exists = 'Y' THEN
4195: csi_gen_utility_pvt.put_line('Instance '||to_char(expire_csr.instance_id)||' Already expired');
4196: Raise Process_next;
4197: END IF;
4198: --
4199: l_instance_rec := l_init_instance_rec; -- srramakr need to be initialized everytime.

Line 4210: csi_gen_utility_pvt.put_line('Calling Update for instance_id '||to_char(l_instance_rec.instance_id));

4206: l_instance_rec.instance_id := expire_csr.instance_id;
4207: l_instance_rec.active_end_date := l_sysdate;-- modified by sguthiva for bug 2401398 p_system_rec.end_date_active;
4208: l_instance_rec.object_version_number := expire_csr.object_version_number;
4209: --
4210: csi_gen_utility_pvt.put_line('Calling Update for instance_id '||to_char(l_instance_rec.instance_id));
4211: csi_item_instance_pub.update_item_instance
4212: (
4213: p_api_version => p_api_version
4214: ,p_commit => fnd_api.g_false

Line 5601: csi_gen_utility_pvt.put_line( 'get_system_details');

5597: x_return_status := fnd_api.g_ret_sts_success;
5598:
5599: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5600: IF (l_debug_level > 0) THEN
5601: csi_gen_utility_pvt.put_line( 'get_system_details');
5602: END IF;
5603:
5604: IF (l_debug_level > 1) THEN
5605: csi_gen_utility_pvt.put_line(

Line 5605: csi_gen_utility_pvt.put_line(

5601: csi_gen_utility_pvt.put_line( 'get_system_details');
5602: END IF;
5603:
5604: IF (l_debug_level > 1) THEN
5605: csi_gen_utility_pvt.put_line(
5606: p_api_version ||'-'||
5607: p_Commit ||'-'||
5608: p_Init_Msg_list ||'-'||
5609: p_Validation_level ||'-'||

Line 5613: csi_gen_utility_pvt.dump_sys_query_rec(p_system_query_rec);

5609: p_Validation_level ||'-'||
5610: p_time_stamp ||'-'||
5611: p_active_systems_only
5612: );
5613: csi_gen_utility_pvt.dump_sys_query_rec(p_system_query_rec);
5614: END IF;
5615:
5616: IF
5617: ( ((p_system_query_rec.system_id IS NULL) OR (p_system_query_rec.system_id = fnd_api.g_miss_num))

Line 5675: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||

5671: IF ( (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) )
5672: THEN
5673: IF ( (l_last_purge_date IS NOT NULL) AND (p_time_stamp <= l_last_purge_date) )
5674: THEN
5675: csi_gen_utility_pvt.put_line('Warning! History for this entity has already been purged for the datetime stamp passed. ' ||
5676: 'Please provide a valid datetime stamp.');
5677: FND_MESSAGE.Set_Name('CSI', 'CSI_API_HIST_AFTER_PURGE_REQ');
5678: FND_MSG_PUB.ADD;
5679: ELSE