DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on FND_LOG

Line 82: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

78: l_index := p_mapping.first;
79: LOOP
80: EXIT WHEN NOT p_mapping.exists(l_index);
81: IF(p_mapping(l_index).field_name = p_field_name) THEN
82: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
83: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
84: 'hxc_self_service_time_deposit.mapping_comp_info',
85: 'Found Mapping:'||p_mapping(l_index).field_name);
86: end if;

Line 83: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

79: LOOP
80: EXIT WHEN NOT p_mapping.exists(l_index);
81: IF(p_mapping(l_index).field_name = p_field_name) THEN
82: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
83: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
84: 'hxc_self_service_time_deposit.mapping_comp_info',
85: 'Found Mapping:'||p_mapping(l_index).field_name);
86: end if;
87: p_mapping_component.field_name := p_mapping(l_index).field_name;

Line 98: if(FND_LOG.LEVEL_ERROR>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

94:
95: l_index := p_mapping.next(l_index);
96: END LOOP;
97:
98: if(FND_LOG.LEVEL_ERROR>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
99: fnd_log.string(FND_LOG.LEVEL_ERROR,
100: 'hxc_self_service_time_deposit.mapping_comp_info',
101: 'Failed to find mapping'||p_field_name);
102: end if;

Line 99: fnd_log.string(FND_LOG.LEVEL_ERROR,

95: l_index := p_mapping.next(l_index);
96: END LOOP;
97:
98: if(FND_LOG.LEVEL_ERROR>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
99: fnd_log.string(FND_LOG.LEVEL_ERROR,
100: 'hxc_self_service_time_deposit.mapping_comp_info',
101: 'Failed to find mapping'||p_field_name);
102: end if;
103:

Line 218: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

214: if(p_deposit_process_id is not null) then
215: -- cache if different than mapping already held
216: if(nvl(g_deposit_process_id,-1) <> p_deposit_process_id) then
217: -- load deposit process
218: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
220: 'HXC_SELF_SERVICE_TIME_DEPOSIT',
221: 'Loading Deposit Process');
222: end if;

Line 219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

215: -- cache if different than mapping already held
216: if(nvl(g_deposit_process_id,-1) <> p_deposit_process_id) then
217: -- load deposit process
218: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
219: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
220: 'HXC_SELF_SERVICE_TIME_DEPOSIT',
221: 'Loading Deposit Process');
222: end if;
223: g_deposit_process_id := p_deposit_process_id;

Line 226: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

222: end if;
223: g_deposit_process_id := p_deposit_process_id;
224:
225: for dep_mapping_comp in csr_deposit_mapping(p_deposit_process_id) loop
226: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
227: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
228: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CACHE_MAPPINGS',
229: 'Field Name'||dep_mapping_comp.field_name);
230: end if;

Line 227: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

223: g_deposit_process_id := p_deposit_process_id;
224:
225: for dep_mapping_comp in csr_deposit_mapping(p_deposit_process_id) loop
226: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
227: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
228: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CACHE_MAPPINGS',
229: 'Field Name'||dep_mapping_comp.field_name);
230: end if;
231:

Line 246: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

242: if(p_retrieval_process_id is not null) then
243: -- cache if different than mapping already held
244: if(nvl(g_retrieval_process_id,-1) <> p_retrieval_process_id) then
245: -- load retrieval process
246: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
247: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
248: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CACHE_MAPPINGS',
249: 'Loading Retrieval Process');
250: end if;

Line 247: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

243: -- cache if different than mapping already held
244: if(nvl(g_retrieval_process_id,-1) <> p_retrieval_process_id) then
245: -- load retrieval process
246: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
247: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
248: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CACHE_MAPPINGS',
249: 'Loading Retrieval Process');
250: end if;
251: g_retrieval_process_id := p_retrieval_process_id;

Line 254: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

250: end if;
251: g_retrieval_process_id := p_retrieval_process_id;
252:
253: for ret_mapping_comp in csr_retrieval_mapping(p_retrieval_process_id) loop
254: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
255: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
256: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CACHE_MAPPINGS',
257: 'Field Name'||ret_mapping_comp.field_name);
258: end if;

Line 255: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

251: g_retrieval_process_id := p_retrieval_process_id;
252:
253: for ret_mapping_comp in csr_retrieval_mapping(p_retrieval_process_id) loop
254: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
255: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
256: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CACHE_MAPPINGS',
257: 'Field Name'||ret_mapping_comp.field_name);
258: end if;
259:

Line 973: if(FND_LOG.LEVEL_PROCEDURE>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

969: x number;
970:
971:
972: BEGIN
973: if(FND_LOG.LEVEL_PROCEDURE>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
974: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
975: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CORRECT_UPDATE_FLAGS',
976: 'Entering');
977: end if;

Line 974: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

970:
971:
972: BEGIN
973: if(FND_LOG.LEVEL_PROCEDURE>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
974: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
975: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CORRECT_UPDATE_FLAGS',
976: 'Entering');
977: end if;
978:

Line 994: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

990: if(process_block(x,'UPDATE',p_tk) = FALSE) then
991:
992: g_timecard(x).changed:='N';
993:
994: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
995: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
996: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CORRECT_UPDATE_FLAGS',
997: 'Updating CHANGED flag for tbbid:'||g_timecard(x).time_building_block_id);
998: end if;

Line 995: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

991:
992: g_timecard(x).changed:='N';
993:
994: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
995: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
996: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CORRECT_UPDATE_FLAGS',
997: 'Updating CHANGED flag for tbbid:'||g_timecard(x).time_building_block_id);
998: end if;
999:

Line 1015: if(FND_LOG.LEVEL_PROCEDURE>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1011:
1012: -- if block will not really be updated, set the update flag to N
1013: -- as it must be the same as the orginal block
1014:
1015: if(FND_LOG.LEVEL_PROCEDURE>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1016: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1017: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CORRECT_UPDATE_FLAGS',
1018: 'Leaving');
1019: end if;

Line 1016: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

1012: -- if block will not really be updated, set the update flag to N
1013: -- as it must be the same as the orginal block
1014:
1015: if(FND_LOG.LEVEL_PROCEDURE>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1016: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1017: 'HXC_SELF_SERVICE_TIME_DEPOSIT.CORRECT_UPDATE_FLAGS',
1018: 'Leaving');
1019: end if;
1020:

Line 2049: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2045: (g_attributes(l_attribute_count).building_block_id = p_time_building_block_id)
2046: AND
2047: (g_attributes(l_attribute_count).attribute_category = p_to_check)
2048: ) THEN
2049: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2050: fnd_log.string(1,'hxc_self_service_time_deposit.attribute_check',
2051: ' Found the expected attribute');
2052: end if;
2053:

Line 2050: fnd_log.string(1,'hxc_self_service_time_deposit.attribute_check',

2046: AND
2047: (g_attributes(l_attribute_count).attribute_category = p_to_check)
2048: ) THEN
2049: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2050: fnd_log.string(1,'hxc_self_service_time_deposit.attribute_check',
2051: ' Found the expected attribute');
2052: end if;
2053:
2054: l_doesnt_exist := FALSE;

Line 2075: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2071:
2072:
2073: BEGIN
2074:
2075: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',
2077: 'Enter denormalize_block_info, mode ='||p_mode);
2078: end if;
2079:

Line 2076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',

2072:
2073: BEGIN
2074:
2075: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',
2077: 'Enter denormalize_block_info, mode ='||p_mode);
2078: end if;
2079:
2080: -- note that we denormalise measure for ALL range start_time stop_times (regardless of scope)

Line 2094: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2090:
2091: IF(g_timecard(l_index).type = 'RANGE' ) THEN
2092: g_timecard(l_index).measure:= (g_timecard(l_index).stop_time-g_timecard(l_index).start_time)*24;
2093: g_timecard(l_index).unit_of_measure:= 'HOURS';
2094: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',
2096: 'NEW MEASURE VAL '||g_timecard(l_index).measure ||
2097: ' l_timecard_id :'||g_timecard(l_index).time_building_block_id);
2098: end if;

Line 2095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',

2091: IF(g_timecard(l_index).type = 'RANGE' ) THEN
2092: g_timecard(l_index).measure:= (g_timecard(l_index).stop_time-g_timecard(l_index).start_time)*24;
2093: g_timecard(l_index).unit_of_measure:= 'HOURS';
2094: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2095: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',
2096: 'NEW MEASURE VAL '||g_timecard(l_index).measure ||
2097: ' l_timecard_id :'||g_timecard(l_index).time_building_block_id);
2098: end if;
2099: END IF;

Line 2106: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2102:
2103: IF(g_timecard(l_index).type = 'RANGE' ) THEN
2104: g_timecard(l_index).measure:= null;
2105: g_timecard(l_index).unit_of_measure:= null;
2106: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2107: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',
2108: 'NEW MEASURE VAL'||g_timecard(l_index).measure);
2109: end if;
2110: END IF;

Line 2107: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',

2103: IF(g_timecard(l_index).type = 'RANGE' ) THEN
2104: g_timecard(l_index).measure:= null;
2105: g_timecard(l_index).unit_of_measure:= null;
2106: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2107: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'HXC_DENORMALIZE_BLOCK_INFO',
2108: 'NEW MEASURE VAL'||g_timecard(l_index).measure);
2109: end if;
2110: END IF;
2111:

Line 2191: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2187: --
2188: -- Create the time attribute for security for this block
2189: -- if a security context doesn't already exist
2190: --
2191: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2192: fnd_log.string(1,'hxc_self_service_time_deposit.add_security',
2193: ' tbb '||g_timecard(l_block_count).time_building_block_id);
2194: end if;
2195:

Line 2192: fnd_log.string(1,'hxc_self_service_time_deposit.add_security',

2188: -- Create the time attribute for security for this block
2189: -- if a security context doesn't already exist
2190: --
2191: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2192: fnd_log.string(1,'hxc_self_service_time_deposit.add_security',
2193: ' tbb '||g_timecard(l_block_count).time_building_block_id);
2194: end if;
2195:
2196: l_create := attribute_check

Line 2205: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2201:
2202: IF l_create THEN
2203:
2204:
2205: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2206: fnd_log.string(1,'hxc_self_service_time_deposit.add_security',
2207: ' Creating a security attribute!');
2208: end if;
2209:

Line 2206: fnd_log.string(1,'hxc_self_service_time_deposit.add_security',

2202: IF l_create THEN
2203:
2204:
2205: if(1>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2206: fnd_log.string(1,'hxc_self_service_time_deposit.add_security',
2207: ' Creating a security attribute!');
2208: end if;
2209:
2210:

Line 4047: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4043: -- Denormalization of hours for RANGE type building blocks
4044: denormalize_time_info(p_mode=>'ADD');
4045:
4046: -- Set security information from profiles AI8
4047: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4048: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4049: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4050: 'start the set_security');
4051: end if;

Line 4048: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4044: denormalize_time_info(p_mode=>'ADD');
4045:
4046: -- Set security information from profiles AI8
4047: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4048: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4049: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4050: 'start the set_security');
4051: end if;
4052:

Line 4055: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4051: end if;
4052:
4053: set_security(p_validate_session);
4054:
4055: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4056: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4057: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4058: 'end the set_security');
4059: end if;

Line 4056: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4052:
4053: set_security(p_validate_session);
4054:
4055: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4056: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4057: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4058: 'end the set_security');
4059: end if;
4060:

Line 4067: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4063: add_security;
4064: end if;
4065:
4066: -- Correct update flags to reflect database inserts
4067: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4068: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4069: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4070: 'start the correct_update_flags');
4071: end if;

Line 4068: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4064: end if;
4065:
4066: -- Correct update flags to reflect database inserts
4067: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4068: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4069: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4070: 'start the correct_update_flags');
4071: end if;
4072:

Line 4075: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4071: end if;
4072:
4073: correct_update_flags(p_allow_error_tc);
4074:
4075: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4076: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4077: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4078: 'end the correct_update_flags');
4079: end if;

Line 4076: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4072:
4073: correct_update_flags(p_allow_error_tc);
4074:
4075: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4076: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4077: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4078: 'end the correct_update_flags');
4079: end if;
4080:

Line 4083: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4079: end if;
4080:
4081: -- Next translate the entered attributes into the real attributes, in case
4082: -- there were any aliased fields on the timecard.
4083: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4084: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4085: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4086: 'start the alias_translation');
4087: end if;

Line 4084: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4080:
4081: -- Next translate the entered attributes into the real attributes, in case
4082: -- there were any aliased fields on the timecard.
4083: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4084: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4085: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4086: 'start the alias_translation');
4087: end if;
4088:

Line 4091: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4087: end if;
4088:
4089: alias_translation;
4090:
4091: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4092: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4093: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4094: 'end the alias_translation');
4095: end if;

Line 4092: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4088:
4089: alias_translation;
4090:
4091: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4092: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4093: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4094: 'end the alias_translation');
4095: end if;
4096:

Line 4100: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4096:
4097: --
4098: -- Don't do any validation for templates!
4099: --
4100: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4101: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4102: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4103: 'g_timecard_block_oder(1)).scope :');
4104: end if;

Line 4101: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4097: --
4098: -- Don't do any validation for templates!
4099: --
4100: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4101: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4102: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4103: 'g_timecard_block_oder(1)).scope :');
4104: end if;
4105:

Line 4110: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4106: if (instr(g_timecard(
4107: g_timecard_block_order(1)).scope,'TIMECARD_TEMPLATE') < 1) then
4108:
4109: -- Don't do the validation for save!
4110: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4111: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4112: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4113: 'p_mode :'||p_mode);
4114: end if;

Line 4111: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4107: g_timecard_block_order(1)).scope,'TIMECARD_TEMPLATE') < 1) then
4108:
4109: -- Don't do the validation for save!
4110: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4111: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4112: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4113: 'p_mode :'||p_mode);
4114: end if;
4115:

Line 4257: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4253: -- Call OTL Specific validation, to make sure everything is set up
4254: -- to use for the time store. We do this on SAVE as well as
4255: -- submit.
4256: --
4257: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4258: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4259: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4260: 'g_app_attributes step ');
4261: end if;

Line 4258: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4254: -- to use for the time store. We do this on SAVE as well as
4255: -- submit.
4256: --
4257: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4258: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4259: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4260: 'g_app_attributes step ');
4261: end if;
4262:

Line 4269: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4265: ,p_deposit_process_id => l_deposit_process_id --AI3
4266: ,p_for_time_attributes => TRUE);
4267:
4268:
4269: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4270: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4271: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4272: 'HXC_SETUP_VALIDATION_PKG.EXECUTE_OTC_VALIDATION step ');
4273: end if;

Line 4270: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4266: ,p_for_time_attributes => TRUE);
4267:
4268:
4269: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4270: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4271: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4272: 'HXC_SETUP_VALIDATION_PKG.EXECUTE_OTC_VALIDATION step ');
4273: end if;
4274: /*

Line 4433: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4429:
4430: l_block := g_timecard_block_order.first;
4431:
4432:
4433: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4434: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4435: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4436: 'l_block :'||l_block);
4437: end if;

Line 4434: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4430: l_block := g_timecard_block_order.first;
4431:
4432:
4433: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4434: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4435: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4436: 'l_block :'||l_block);
4437: end if;
4438:

Line 4489: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4485: -- error messages, rather just one message, because
4486: -- the user should never see an error from this API
4487:
4488: BEGIN
4489: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4490: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4491: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4492: 'process 2 ');
4493: end if;

Line 4490: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4486: -- the user should never see an error from this API
4487:
4488: BEGIN
4489: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4490: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4491: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4492: 'process 2 ');
4493: end if;
4494:

Line 4531: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4527:
4528: end if;
4529: end if;
4530:
4531: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4532: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4533: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4534: 'l_time_building_block_id :'||l_time_building_block_id||
4535: ' l_object_version_number :'||l_object_version_number);

Line 4532: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4528: end if;
4529: end if;
4530:
4531: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4532: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4533: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4534: 'l_time_building_block_id :'||l_time_building_block_id||
4535: ' l_object_version_number :'||l_object_version_number);
4536: end if;

Line 4559: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4555: --
4556: IF l_max_ovn < l_object_version_number THEN
4557: l_max_ovn := l_object_version_number;
4558: END IF;
4559: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4560: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4561: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4562: 'l_max_ovn :'||l_max_ovn);
4563: end if;

Line 4560: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4556: IF l_max_ovn < l_object_version_number THEN
4557: l_max_ovn := l_object_version_number;
4558: END IF;
4559: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4560: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4561: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4562: 'l_max_ovn :'||l_max_ovn);
4563: end if;
4564: --

Line 4570: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4566: -- instances of other building blocks which pointed to this one
4567: -- as the parent, and update those records to point to the newly
4568: -- db created building block
4569: --
4570: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4571: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4572: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4573: 'z :');
4574: end if;

Line 4571: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4567: -- as the parent, and update those records to point to the newly
4568: -- db created building block
4569: --
4570: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4571: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4572: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4573: 'z :');
4574: end if;
4575:

Line 4642: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

4638: AND
4639: (NOT process_block(x,'DELETE',p_allow_error_tc))
4640: ) THEN
4641: BEGIN
4642: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4643: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4644: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4645: 'process :'||g_timecard(x).time_building_block_id);
4646: end if;

Line 4643: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

4639: (NOT process_block(x,'DELETE',p_allow_error_tc))
4640: ) THEN
4641: BEGIN
4642: if(FND_LOG.LEVEL_STATEMENT>=FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4643: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
4644: 'hxc_self_service_time_deposit.start_deposit_wrapper',
4645: 'process :'||g_timecard(x).time_building_block_id);
4646: end if;
4647: