DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on FND_PROFILE

Line 1224: p_token1_val => to_char(p_ctr_rdg_rec.value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),

1220: ELSE
1221: csi_ctr_gen_utility_pvt.ExitWithErrMsg
1222: (p_msg_name => 'CSI_API_CTR_RDG_DATE_EXISTS',
1223: p_token1_name => 'VALUE_TIMESTAMP',
1224: p_token1_val => to_char(p_ctr_rdg_rec.value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),
1225: p_token2_name => 'MODE',
1226: p_token2_val => l_mode
1227: );
1228: END IF;

Line 1235: p_token1_val => to_char(p_ctr_rdg_rec.value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),

1231: /* end of return status fixes */
1232: csi_ctr_gen_utility_pvt.ExitWithErrMsg
1233: (p_msg_name => 'CSI_API_CTR_RDG_DATE_EXISTS',
1234: p_token1_name => 'VALUE_TIMESTAMP',
1235: p_token1_val => to_char(p_ctr_rdg_rec.value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),
1236: p_token2_name => 'MODE',
1237: p_token2_val => l_mode
1238: );
1239: END IF;

Line 1249: p_token1_val => to_char(p_ctr_rdg_rec.value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),

1245: IF p_ctr_rdg_rec.value_timestamp > sysdate THEN
1246: csi_ctr_gen_utility_pvt.ExitWithErrMsg
1247: ( p_msg_name => 'CSI_API_CTR_FUTURE_RDG_DATE',
1248: p_token1_name => 'VALUE_TIMESTAMP',
1249: p_token1_val => to_char(p_ctr_rdg_rec.value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),
1250: p_token2_name => 'MODE',
1251: p_token2_val => l_mode
1252: );
1253: END IF;

Line 1404: p_token1_val => to_char(l_rdg_lock_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')), --fix for bug 5435071

1400: csi_ctr_gen_utility_pvt.put_line('Reading Date cannot be earlier than the Reading Lock Date...');
1401: csi_ctr_gen_utility_pvt.ExitWithErrMsg
1402: ( p_msg_name => 'CSI_API_CTR_RDG_DATE_LOCKED',
1403: p_token1_name => 'LOCKED_DATE',
1404: p_token1_val => to_char(l_rdg_lock_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')), --fix for bug 5435071
1405: p_token2_name => 'MODE',
1406: p_token2_val => l_mode
1407: );
1408: END IF;

Line 1574: p_token1_val => to_char(l_next_value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))

1570:
1571: csi_ctr_gen_utility_pvt.ExitWithErrMsg
1572: ( p_msg_name => 'CSI_API_CTR_NEXT_RDG_DT_EXISTS',
1573: p_token1_name => 'NEXT_DATE',
1574: p_token1_val => to_char(l_next_value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))
1575: );
1576: END IF;
1577: -- Reset cannot happen in between. It has to be at the end
1578: IF NVL(p_ctr_rdg_rec.reset_mode,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

Line 1584: p_token1_val => to_char(l_next_value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))

1580:
1581: csi_ctr_gen_utility_pvt.ExitWithErrMsg
1582: ( p_msg_name => 'CSI_API_CTR_NEXT_RDG_DT_EXISTS',
1583: p_token1_name => 'NEXT_DATE',
1584: p_token1_val => to_char(l_next_value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))
1585: );
1586: END IF;
1587: --
1588: -- Inbetween Adjustments cannot be clubbed with other readings

Line 1596: p_token1_val => to_char(l_next_value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))

1592: csi_ctr_gen_utility_pvt.put_line('Between readings adjustments cannot be clubbed with others...');
1593: csi_ctr_gen_utility_pvt.ExitWithErrMsg
1594: ( p_msg_name => 'CSI_API_CTR_ADJ_RDG_ONLY',
1595: p_token1_name => 'NEXT_DATE',
1596: p_token1_val => to_char(l_next_value_timestamp,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))
1597: );
1598: END IF;
1599: END IF;
1600: END IF; -- Look for Next Value

Line 4630: p_token1_val => to_char(l_rdg_lock_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')), --fix for bug 5435071

4626: csi_ctr_gen_utility_pvt.put_line('Reading Date cannot be earlier than the Reading Lock Date...');
4627: csi_ctr_gen_utility_pvt.ExitWithErrMsg
4628: ( p_msg_name => 'CSI_API_CTR_RDG_DATE_LOCKED',
4629: p_token1_name => 'LOCKED_DATE',
4630: p_token1_val => to_char(l_rdg_lock_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')), --fix for bug 5435071
4631: p_token2_name => 'MODE',
4632: p_token2_val => l_mode
4633: );
4634: END IF;

Line 6479: p_token2_val => to_char(p_estimation_period_end_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))

6475: ( p_msg_name => 'CSI_API_CTR_CTRID_PRD_ENDDT',
6476: p_token1_name => 'P_COUNTER_ID',
6477: p_token1_val => to_char(p_counter_id),
6478: p_token2_name => 'P_ESTIMATION_PERIOD_END_DATE',
6479: p_token2_val => to_char(p_estimation_period_end_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS'))
6480: );
6481: END IF;
6482: IF p_avg_calculation_start_date IS NOT NULL and p_number_of_readings IS NOT NULL THEN
6483: csi_ctr_gen_utility_pvt.ExitWithErrMsg

Line 6486: p_token1_val => to_char(p_avg_calculation_start_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),

6482: IF p_avg_calculation_start_date IS NOT NULL and p_number_of_readings IS NOT NULL THEN
6483: csi_ctr_gen_utility_pvt.ExitWithErrMsg
6484: ( p_msg_name => 'CSI_API_CTR_CAL_STDT_NUM_RDGS',
6485: p_token1_name => 'P_AVG_CALCULATION_START_DATE',
6486: p_token1_val => to_char(p_avg_calculation_start_date,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY HH24:MI:SS')),
6487: p_token2_name => 'P_NUMBER_OF_READINGS',
6488: p_token2_val => to_char(p_number_of_readings)
6489: );
6490: END IF;