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.AHL_VWP_VISIT_CST_PR_PVT dependencies on FND_LOG

Line 85: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

81: WHERE list_header_id = p_price_list_id;
82:
83: -- Begin Procedure code
84: BEGIN
85: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
86: fnd_log.string
87: (
88: fnd_log.level_procedure,
89: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details.begin',

Line 86: fnd_log.string

82:
83: -- Begin Procedure code
84: BEGIN
85: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
86: fnd_log.string
87: (
88: fnd_log.level_procedure,
89: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details.begin',
90: 'At the start of PLSQL procedure'

Line 88: fnd_log.level_procedure,

84: BEGIN
85: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
86: fnd_log.string
87: (
88: fnd_log.level_procedure,
89: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details.begin',
90: 'At the start of PLSQL procedure'
91: );
92: END IF;

Line 115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

111: END IF;
112:
113: l_cost_price_rec:= p_x_cost_price_rec;
114:
115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string
117: (
118: fnd_log.level_statement,
119: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 116: fnd_log.string

112:
113: l_cost_price_rec:= p_x_cost_price_rec;
114:
115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string
117: (
118: fnd_log.level_statement,
119: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
120: 'Got request for cost record of Visit ID : ' || p_x_cost_price_rec.visit_id

Line 118: fnd_log.level_statement,

114:
115: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
116: fnd_log.string
117: (
118: fnd_log.level_statement,
119: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
120: 'Got request for cost record of Visit ID : ' || p_x_cost_price_rec.visit_id
121: );
122: fnd_log.string

Line 122: fnd_log.string

118: fnd_log.level_statement,
119: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
120: 'Got request for cost record of Visit ID : ' || p_x_cost_price_rec.visit_id
121: );
122: fnd_log.string
123: (
124: fnd_log.level_statement,
125: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
126: 'Got request for update visit cost details of mr session ID : ' || p_x_cost_price_rec.mr_session_id

Line 124: fnd_log.level_statement,

120: 'Got request for cost record of Visit ID : ' || p_x_cost_price_rec.visit_id
121: );
122: fnd_log.string
123: (
124: fnd_log.level_statement,
125: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
126: 'Got request for update visit cost details of mr session ID : ' || p_x_cost_price_rec.mr_session_id
127: );
128: fnd_log.string

Line 128: fnd_log.string

124: fnd_log.level_statement,
125: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
126: 'Got request for update visit cost details of mr session ID : ' || p_x_cost_price_rec.mr_session_id
127: );
128: fnd_log.string
129: (
130: fnd_log.level_statement,
131: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
132: 'Got request for update visit cost details of cost session ID : ' || p_x_cost_price_rec.cost_session_id

Line 130: fnd_log.level_statement,

126: 'Got request for update visit cost details of mr session ID : ' || p_x_cost_price_rec.mr_session_id
127: );
128: fnd_log.string
129: (
130: fnd_log.level_statement,
131: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
132: 'Got request for update visit cost details of cost session ID : ' || p_x_cost_price_rec.cost_session_id
133: );
134: END IF;

Line 140: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

136: -- make sure that visit id is present in the input
137: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
138: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
139: FND_MSG_PUB.ADD;
140: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
141: fnd_log.string
142: (
143: fnd_log.level_exception,
144: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 141: fnd_log.string

137: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
138: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
139: FND_MSG_PUB.ADD;
140: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
141: fnd_log.string
142: (
143: fnd_log.level_exception,
144: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
145: 'Visit id is mandatory but found null in input '

Line 143: fnd_log.level_exception,

139: FND_MSG_PUB.ADD;
140: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
141: fnd_log.string
142: (
143: fnd_log.level_exception,
144: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
145: 'Visit id is mandatory but found null in input '
146: );
147: END IF;

Line 162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

158:
159: IF (visit_info_csr%NOTFOUND)THEN
160: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
161: FND_MSG_PUB.ADD;
162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
163: fnd_log.string
164: (
165: fnd_log.level_exception,
166: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 163: fnd_log.string

159: IF (visit_info_csr%NOTFOUND)THEN
160: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
161: FND_MSG_PUB.ADD;
162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
163: fnd_log.string
164: (
165: fnd_log.level_exception,
166: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
167: 'Visit id not found in ahl_visits_b table'

Line 165: fnd_log.level_exception,

161: FND_MSG_PUB.ADD;
162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
163: fnd_log.string
164: (
165: fnd_log.level_exception,
166: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
167: 'Visit id not found in ahl_visits_b table'
168: );
169: END IF;

Line 185: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

181: FETCH customer_id_csr INTO l_cost_price_rec.customer_id;
182: IF(customer_id_csr%NOTFOUND)THEN
183: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SR_ID');
184: FND_MSG_PUB.ADD;
185: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
186: fnd_log.string
187: (
188: fnd_log.level_unexpected,
189: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 186: fnd_log.string

182: IF(customer_id_csr%NOTFOUND)THEN
183: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SR_ID');
184: FND_MSG_PUB.ADD;
185: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
186: fnd_log.string
187: (
188: fnd_log.level_unexpected,
189: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
190: 'Service request associated is invalid as record not found : l_cost_price_rec.service_request_id : '||l_cost_price_rec.service_request_id

Line 188: fnd_log.level_unexpected,

184: FND_MSG_PUB.ADD;
185: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
186: fnd_log.string
187: (
188: fnd_log.level_unexpected,
189: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
190: 'Service request associated is invalid as record not found : l_cost_price_rec.service_request_id : '||l_cost_price_rec.service_request_id
191: );
192: END IF;

Line 220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

216:
217: IF(price_list_name_csr%NOTFOUND)THEN
218: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
219: FND_MSG_PUB.ADD;
220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 221: fnd_log.string

217: IF(price_list_name_csr%NOTFOUND)THEN
218: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
219: FND_MSG_PUB.ADD;
220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
225: 'List name not found for stored list id'

Line 223: fnd_log.level_error,

219: FND_MSG_PUB.ADD;
220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
221: fnd_log.string
222: (
223: fnd_log.level_error,
224: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
225: 'List name not found for stored list id'
226: );
227: END IF;

Line 257: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

253: x_return_status => x_return_status
254: );
255:
256: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
257: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
258: fnd_log.string
259: (
260: fnd_log.level_exception,
261: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 258: fnd_log.string

254: );
255:
256: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
257: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
258: fnd_log.string
259: (
260: fnd_log.level_exception,
261: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
262: 'AHL_VWP_COST_PVT.Calculate_WO_Cost API threw error : x_return_status : ' || x_return_status

Line 260: fnd_log.level_exception,

256: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
257: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
258: fnd_log.string
259: (
260: fnd_log.level_exception,
261: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
262: 'AHL_VWP_COST_PVT.Calculate_WO_Cost API threw error : x_return_status : ' || x_return_status
263: );
264: END IF;

Line 281: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

277: x_return_status => x_return_status
278: );
279:
280: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
281: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
282: fnd_log.string
283: (
284: fnd_log.level_exception,
285: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 282: fnd_log.string

278: );
279:
280: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
281: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
282: fnd_log.string
283: (
284: fnd_log.level_exception,
285: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
286: 'AHL_VWP_COST_PVT.Calculate_Visit_Cost API threw error : x_return_status : ' || x_return_status

Line 284: fnd_log.level_exception,

280: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
281: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
282: fnd_log.string
283: (
284: fnd_log.level_exception,
285: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
286: 'AHL_VWP_COST_PVT.Calculate_Visit_Cost API threw error : x_return_status : ' || x_return_status
287: );
288: END IF;

Line 306: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

302: );
303: END IF;
304:
305: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
306: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
307: fnd_log.string
308: (
309: fnd_log.level_exception,
310: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',

Line 307: fnd_log.string

303: END IF;
304:
305: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
306: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
307: fnd_log.string
308: (
309: fnd_log.level_exception,
310: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
311: 'AHL_VWP_COST_PVT.Get_Profit_or_Loss API threw error : x_return_status : ' || x_return_status

Line 309: fnd_log.level_exception,

305: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
306: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
307: fnd_log.string
308: (
309: fnd_log.level_exception,
310: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
311: 'AHL_VWP_COST_PVT.Get_Profit_or_Loss API threw error : x_return_status : ' || x_return_status
312: );
313: END IF;

Line 357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

353: p_x_cost_price_rec.workorder_id := l_cost_price_rec.workorder_id;
354: p_x_cost_price_rec.visit_start_date := l_cost_price_rec.visit_start_date;
355: p_x_cost_price_rec.visit_end_date := l_cost_price_rec.visit_end_date;
356:
357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
358: fnd_log.string
359: (
360: fnd_log.level_procedure,
361: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details.end',

Line 358: fnd_log.string

354: p_x_cost_price_rec.visit_start_date := l_cost_price_rec.visit_start_date;
355: p_x_cost_price_rec.visit_end_date := l_cost_price_rec.visit_end_date;
356:
357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
358: fnd_log.string
359: (
360: fnd_log.level_procedure,
361: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details.end',
362: 'At the end of PLSQL procedure'

Line 360: fnd_log.level_procedure,

356:
357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
358: fnd_log.string
359: (
360: fnd_log.level_procedure,
361: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details.end',
362: 'At the end of PLSQL procedure'
363: );
364: END IF;

Line 453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

449: FOR UPDATE OF object_version_number;
450: visit_rec update_visit_csr%ROWTYPE;
451:
452: BEGIN
453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
454: fnd_log.string
455: (
456: fnd_log.level_procedure,
457: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details.begin',

Line 454: fnd_log.string

450: visit_rec update_visit_csr%ROWTYPE;
451:
452: BEGIN
453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
454: fnd_log.string
455: (
456: fnd_log.level_procedure,
457: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details.begin',
458: 'At the start of PLSQL procedure'

Line 456: fnd_log.level_procedure,

452: BEGIN
453: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
454: fnd_log.string
455: (
456: fnd_log.level_procedure,
457: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details.begin',
458: 'At the start of PLSQL procedure'
459: );
460: END IF;

Line 474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

470: -- Initialize API return status to success
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: l_cost_price_rec := p_x_cost_price_rec;
473:
474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
475: fnd_log.string
476: (
477: fnd_log.level_statement,
478: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 475: fnd_log.string

471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: l_cost_price_rec := p_x_cost_price_rec;
473:
474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
475: fnd_log.string
476: (
477: fnd_log.level_statement,
478: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
479: 'Got request for update visit cost details of Visit ID : ' || p_x_cost_price_rec.visit_id

Line 477: fnd_log.level_statement,

473:
474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
475: fnd_log.string
476: (
477: fnd_log.level_statement,
478: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
479: 'Got request for update visit cost details of Visit ID : ' || p_x_cost_price_rec.visit_id
480: );
481: fnd_log.string

Line 481: fnd_log.string

477: fnd_log.level_statement,
478: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
479: 'Got request for update visit cost details of Visit ID : ' || p_x_cost_price_rec.visit_id
480: );
481: fnd_log.string
482: (
483: fnd_log.level_statement,
484: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
485: 'outside party flag : ' || p_x_cost_price_rec.outside_party_flag

Line 483: fnd_log.level_statement,

479: 'Got request for update visit cost details of Visit ID : ' || p_x_cost_price_rec.visit_id
480: );
481: fnd_log.string
482: (
483: fnd_log.level_statement,
484: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
485: 'outside party flag : ' || p_x_cost_price_rec.outside_party_flag
486: );
487: fnd_log.string

Line 487: fnd_log.string

483: fnd_log.level_statement,
484: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
485: 'outside party flag : ' || p_x_cost_price_rec.outside_party_flag
486: );
487: fnd_log.string
488: (
489: fnd_log.level_statement,
490: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
491: 'Price List Name : ' || p_x_cost_price_rec.price_list_name

Line 489: fnd_log.level_statement,

485: 'outside party flag : ' || p_x_cost_price_rec.outside_party_flag
486: );
487: fnd_log.string
488: (
489: fnd_log.level_statement,
490: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
491: 'Price List Name : ' || p_x_cost_price_rec.price_list_name
492: );
493: END IF;

Line 499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

495: -- Make sure that visit id is present in the input
496: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
497: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
498: FND_MSG_PUB.ADD;
499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
500: fnd_log.string
501: (
502: fnd_log.level_exception,
503: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 500: fnd_log.string

496: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
497: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
498: FND_MSG_PUB.ADD;
499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
500: fnd_log.string
501: (
502: fnd_log.level_exception,
503: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
504: 'Visit id is mandatory but found null in input '

Line 502: fnd_log.level_exception,

498: FND_MSG_PUB.ADD;
499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
500: fnd_log.string
501: (
502: fnd_log.level_exception,
503: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
504: 'Visit id is mandatory but found null in input '
505: );
506: END IF;

Line 514: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

510: --make sure outside party flag is valid
511: IF (NVL(p_x_cost_price_rec.outside_party_flag,'N') NOT IN ('Y','N'))THEN
512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_OSP_INV');
513: FND_MSG_PUB.ADD;
514: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
515: fnd_log.string
516: (
517: fnd_log.level_exception,
518: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 515: fnd_log.string

511: IF (NVL(p_x_cost_price_rec.outside_party_flag,'N') NOT IN ('Y','N'))THEN
512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_OSP_INV');
513: FND_MSG_PUB.ADD;
514: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
515: fnd_log.string
516: (
517: fnd_log.level_exception,
518: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
519: 'Input OSP Flag is invalid : ' || p_x_cost_price_rec.outside_party_flag

Line 517: fnd_log.level_exception,

513: FND_MSG_PUB.ADD;
514: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
515: fnd_log.string
516: (
517: fnd_log.level_exception,
518: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
519: 'Input OSP Flag is invalid : ' || p_x_cost_price_rec.outside_party_flag
520: );
521: END IF;

Line 538: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

534: FND_MSG_PUB.ADD;
535: CLOSE visit_info_csr;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537:
538: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
539: fnd_log.string
540: (
541: fnd_log.level_exception,
542: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 539: fnd_log.string

535: CLOSE visit_info_csr;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537:
538: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
539: fnd_log.string
540: (
541: fnd_log.level_exception,
542: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
543: 'Visit id not found in ahl_visits_b table'

Line 541: fnd_log.level_exception,

537:
538: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
539: fnd_log.string
540: (
541: fnd_log.level_exception,
542: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
543: 'Visit id not found in ahl_visits_b table'
544: );
545: END IF;

Line 553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

549: FND_MSG_PUB.ADD;
550: CLOSE visit_info_csr;
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552:
553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
554: fnd_log.string
555: (
556: fnd_log.level_error,
557: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 554: fnd_log.string

550: CLOSE visit_info_csr;
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552:
553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
554: fnd_log.string
555: (
556: fnd_log.level_error,
557: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
558: 'Visit is closed so can not update outside party flag or price list'

Line 556: fnd_log.level_error,

552:
553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
554: fnd_log.string
555: (
556: fnd_log.level_error,
557: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
558: 'Visit is closed so can not update outside party flag or price list'
559: );
560: END IF;

Line 568: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

564: FND_MSG_PUB.ADD;
565: CLOSE visit_info_csr;
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567:
568: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
569: fnd_log.string
570: (
571: fnd_log.level_error,
572: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 569: fnd_log.string

565: CLOSE visit_info_csr;
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567:
568: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
569: fnd_log.string
570: (
571: fnd_log.level_error,
572: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
573: 'No service request is attached to visit so can not update outside party flag or price list'

Line 571: fnd_log.level_error,

567:
568: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
569: fnd_log.string
570: (
571: fnd_log.level_error,
572: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
573: 'No service request is attached to visit so can not update outside party flag or price list'
574: );
575: END IF;

Line 588: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

584: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_OSP_FLAG_MOD');
585: FND_MSG_PUB.ADD;
586: RAISE FND_API.G_EXC_ERROR;
587:
588: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
589: fnd_log.string
590: (
591: fnd_log.level_error,
592: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 589: fnd_log.string

585: FND_MSG_PUB.ADD;
586: RAISE FND_API.G_EXC_ERROR;
587:
588: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
589: fnd_log.string
590: (
591: fnd_log.level_error,
592: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
593: 'Can not modify outside party flag because tasks has already been created'

Line 591: fnd_log.level_error,

587:
588: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
589: fnd_log.string
590: (
591: fnd_log.level_error,
592: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
593: 'Can not modify outside party flag because tasks has already been created'
594: );
595: END IF;

Line 611: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

607: THEN
608:
609: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_MAND');
610: FND_MSG_PUB.ADD;
611: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
612: fnd_log.string
613: (
614: fnd_log.level_error,
615: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 612: fnd_log.string

608:
609: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_MAND');
610: FND_MSG_PUB.ADD;
611: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
612: fnd_log.string
613: (
614: fnd_log.level_error,
615: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
616: 'Price List is mandatory'

Line 614: fnd_log.level_error,

610: FND_MSG_PUB.ADD;
611: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
612: fnd_log.string
613: (
614: fnd_log.level_error,
615: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
616: 'Price List is mandatory'
617: );
618: END IF;

Line 630: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

626: x_price_list_id => l_cost_price_rec.price_list_id,
627: x_return_status => x_return_status
628: );
629: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
630: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
631: fnd_log.string
632: (
633: fnd_log.level_error,
634: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 631: fnd_log.string

627: x_return_status => x_return_status
628: );
629: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
630: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
631: fnd_log.string
632: (
633: fnd_log.level_error,
634: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
635: 'AHL_VWP_RULES_PVT.Check_Price_List_Name_Or_Id API Threw error'

Line 633: fnd_log.level_error,

629: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
630: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
631: fnd_log.string
632: (
633: fnd_log.level_error,
634: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
635: 'AHL_VWP_RULES_PVT.Check_Price_List_Name_Or_Id API Threw error'
636: );
637: END IF;

Line 644: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

640: ELSIF(l_cost_price_rec.outside_party_flag = 'N' AND l_cost_price_rec.price_list_name IS NOT NULL)THEN
641: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_OSP_VISIT_PR_LIST');
642: -- Please select check box 'Visit for outside party' or remove price list from LOV.
643: FND_MSG_PUB.ADD;
644: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
645: fnd_log.string
646: (
647: fnd_log.level_error,
648: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 645: fnd_log.string

641: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_OSP_VISIT_PR_LIST');
642: -- Please select check box 'Visit for outside party' or remove price list from LOV.
643: FND_MSG_PUB.ADD;
644: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
645: fnd_log.string
646: (
647: fnd_log.level_error,
648: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
649: 'Price List is mandatory'

Line 647: fnd_log.level_error,

643: FND_MSG_PUB.ADD;
644: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
645: fnd_log.string
646: (
647: fnd_log.level_error,
648: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
649: 'Price List is mandatory'
650: );
651: END IF;

Line 679: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

675: (TRUNC(l_price_list_active_end_date) < TRUNC(l_start_date_time)) THEN
676:
677: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_STR');
678: FND_MSG_PUB.ADD;
679: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
680: fnd_log.string
681: (
682: fnd_log.level_error,
683: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 680: fnd_log.string

676:
677: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_STR');
678: FND_MSG_PUB.ADD;
679: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
680: fnd_log.string
681: (
682: fnd_log.level_error,
683: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
684: 'Price List is not active on visit start date'

Line 682: fnd_log.level_error,

678: FND_MSG_PUB.ADD;
679: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
680: fnd_log.string
681: (
682: fnd_log.level_error,
683: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
684: 'Price List is not active on visit start date'
685: );
686: END IF;

Line 700: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

696: (TRUNC(l_price_list_active_end_date) < TRUNC(l_close_date_time)) THEN
697:
698: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_END');
699: FND_MSG_PUB.ADD;
700: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
701: fnd_log.string
702: (
703: fnd_log.level_error,
704: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 701: fnd_log.string

697:
698: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_END');
699: FND_MSG_PUB.ADD;
700: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
701: fnd_log.string
702: (
703: fnd_log.level_error,
704: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
705: 'Price List is not active on visit end date'

Line 703: fnd_log.level_error,

699: FND_MSG_PUB.ADD;
700: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
701: fnd_log.string
702: (
703: fnd_log.level_error,
704: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
705: 'Price List is not active on visit end date'
706: );
707: END IF;

Line 722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

718:
719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_SYS');
720: -- CHANGE THIS MESSAGE TEST AND NAME TOO -- IMPORTANT
721: FND_MSG_PUB.ADD;
722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
723: fnd_log.string
724: (
725: fnd_log.level_error,
726: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',

Line 723: fnd_log.string

719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_SYS');
720: -- CHANGE THIS MESSAGE TEST AND NAME TOO -- IMPORTANT
721: FND_MSG_PUB.ADD;
722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
723: fnd_log.string
724: (
725: fnd_log.level_error,
726: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
727: 'Price List is not active on current todays date'

Line 725: fnd_log.level_error,

721: FND_MSG_PUB.ADD;
722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
723: fnd_log.string
724: (
725: fnd_log.level_error,
726: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details',
727: 'Price List is not active on current todays date'
728: );
729: END IF;

Line 818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

814: IF FND_API.TO_BOOLEAN(p_commit) THEN
815: COMMIT WORK;
816: END IF;
817:
818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
819: fnd_log.string
820: (
821: fnd_log.level_procedure,
822: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details.end',

Line 819: fnd_log.string

815: COMMIT WORK;
816: END IF;
817:
818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
819: fnd_log.string
820: (
821: fnd_log.level_procedure,
822: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details.end',
823: 'At the end of PLSQL procedure'

Line 821: fnd_log.level_procedure,

817:
818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
819: fnd_log.string
820: (
821: fnd_log.level_procedure,
822: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.update_visit_cost_details.end',
823: 'At the end of PLSQL procedure'
824: );
825: END IF;

Line 889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

885: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
886:
887: BEGIN
888:
889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
890: fnd_log.string
891: (
892: fnd_log.level_procedure,
893: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost.begin',

Line 890: fnd_log.string

886:
887: BEGIN
888:
889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
890: fnd_log.string
891: (
892: fnd_log.level_procedure,
893: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost.begin',
894: 'At the start of PLSQL procedure'

Line 892: fnd_log.level_procedure,

888:
889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
890: fnd_log.string
891: (
892: fnd_log.level_procedure,
893: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost.begin',
894: 'At the start of PLSQL procedure'
895: );
896: END IF;

Line 920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

916: END IF;
917:
918: l_cost_price_rec:= p_x_cost_price_rec;
919:
920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
921: fnd_log.string
922: (
923: fnd_log.level_statement,
924: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',

Line 921: fnd_log.string

917:
918: l_cost_price_rec:= p_x_cost_price_rec;
919:
920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
921: fnd_log.string
922: (
923: fnd_log.level_statement,
924: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
925: 'Got request for estimating cost of Visit ID : ' || p_x_cost_price_rec.visit_id

Line 923: fnd_log.level_statement,

919:
920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
921: fnd_log.string
922: (
923: fnd_log.level_statement,
924: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
925: 'Got request for estimating cost of Visit ID : ' || p_x_cost_price_rec.visit_id
926: );
927:

Line 928: fnd_log.string

924: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
925: 'Got request for estimating cost of Visit ID : ' || p_x_cost_price_rec.visit_id
926: );
927:
928: fnd_log.string
929: (
930: fnd_log.level_statement,
931: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
932: 'input mr session id : ' || p_x_cost_price_rec.mr_session_id

Line 930: fnd_log.level_statement,

926: );
927:
928: fnd_log.string
929: (
930: fnd_log.level_statement,
931: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
932: 'input mr session id : ' || p_x_cost_price_rec.mr_session_id
933: );
934:

Line 935: fnd_log.string

931: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
932: 'input mr session id : ' || p_x_cost_price_rec.mr_session_id
933: );
934:
935: fnd_log.string
936: (
937: fnd_log.level_statement,
938: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
939: 'input cost session id : ' || p_x_cost_price_rec.cost_session_id

Line 937: fnd_log.level_statement,

933: );
934:
935: fnd_log.string
936: (
937: fnd_log.level_statement,
938: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
939: 'input cost session id : ' || p_x_cost_price_rec.cost_session_id
940: );
941: END IF;

Line 949: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

945: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
946: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
947: FND_MSG_PUB.ADD;
948:
949: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
950: fnd_log.string
951: (
952: fnd_log.level_exception,
953: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',

Line 950: fnd_log.string

946: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
947: FND_MSG_PUB.ADD;
948:
949: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
950: fnd_log.string
951: (
952: fnd_log.level_exception,
953: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
954: 'Visit id is mandatory but found null in input '

Line 952: fnd_log.level_exception,

948:
949: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
950: fnd_log.string
951: (
952: fnd_log.level_exception,
953: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
954: 'Visit id is mandatory but found null in input '
955: );
956: END IF;

Line 969: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

965:
966: -- Release visit if required
967: IF l_release_visit_required ='Y' THEN
968:
969: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
970: fnd_log.string
971: (
972: fnd_log.level_procedure,
973: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 970: fnd_log.string

966: -- Release visit if required
967: IF l_release_visit_required ='Y' THEN
968:
969: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
970: fnd_log.string
971: (
972: fnd_log.level_procedure,
973: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
974: 'Before calling ahl vwp proj prod pvt.release visit'

Line 972: fnd_log.level_procedure,

968:
969: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
970: fnd_log.string
971: (
972: fnd_log.level_procedure,
973: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
974: 'Before calling ahl vwp proj prod pvt.release visit'
975: );
976: END IF;

Line 989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

985: x_return_status => l_return_status,
986: x_msg_count => l_msg_count,
987: x_msg_data => l_msg_data);
988:
989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
990: fnd_log.string
991: (
992: fnd_log.level_procedure,
993: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',

Line 990: fnd_log.string

986: x_msg_count => l_msg_count,
987: x_msg_data => l_msg_data);
988:
989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
990: fnd_log.string
991: (
992: fnd_log.level_procedure,
993: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
994: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status

Line 992: fnd_log.level_procedure,

988:
989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
990: fnd_log.string
991: (
992: fnd_log.level_procedure,
993: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
994: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status
995: );
996: END IF;

Line 1021: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

1017: x_return_status => x_return_status
1018: );
1019:
1020: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1021: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1022: fnd_log.string
1023: (
1024: fnd_log.level_exception,
1025: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',

Line 1022: fnd_log.string

1018: );
1019:
1020: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1021: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1022: fnd_log.string
1023: (
1024: fnd_log.level_exception,
1025: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
1026: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status

Line 1024: fnd_log.level_exception,

1020: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1021: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1022: fnd_log.string
1023: (
1024: fnd_log.level_exception,
1025: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
1026: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status
1027: );
1028: END IF;

Line 1048: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1044: p_x_cost_price_rec.Is_Cst_Struc_updated := l_cost_price_rec.Is_Cst_Struc_updated;
1045: p_x_cost_price_rec.cost_session_id := l_cost_price_rec.cost_session_id;
1046: p_x_cost_price_rec.mr_session_id := l_cost_price_rec.mr_session_id;
1047:
1048: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1049: fnd_log.string
1050: (
1051: fnd_log.level_procedure,
1052: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost.end',

Line 1049: fnd_log.string

1045: p_x_cost_price_rec.cost_session_id := l_cost_price_rec.cost_session_id;
1046: p_x_cost_price_rec.mr_session_id := l_cost_price_rec.mr_session_id;
1047:
1048: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1049: fnd_log.string
1050: (
1051: fnd_log.level_procedure,
1052: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost.end',
1053: 'At the end of PLSQL procedure'

Line 1051: fnd_log.level_procedure,

1047:
1048: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1049: fnd_log.string
1050: (
1051: fnd_log.level_procedure,
1052: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost.end',
1053: 'At the end of PLSQL procedure'
1054: );
1055: END IF;

Line 1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1130: l_msg_data VARCHAR2(2000);
1131: l_msg_count NUMBER;
1132:
1133: BEGIN
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string
1136: (
1137: fnd_log.level_procedure,
1138: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price.begin',

Line 1135: fnd_log.string

1131: l_msg_count NUMBER;
1132:
1133: BEGIN
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string
1136: (
1137: fnd_log.level_procedure,
1138: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price.begin',
1139: 'At the start of PLSQL procedure'

Line 1137: fnd_log.level_procedure,

1133: BEGIN
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string
1136: (
1137: fnd_log.level_procedure,
1138: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price.begin',
1139: 'At the start of PLSQL procedure'
1140: );
1141: END IF;

Line 1199: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1195: );
1196:
1197: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1198:
1199: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1200: fnd_log.string
1201: (
1202: fnd_log.level_error,
1203: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price',

Line 1200: fnd_log.string

1196:
1197: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1198:
1199: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1200: fnd_log.string
1201: (
1202: fnd_log.level_error,
1203: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price',
1204: 'AHL_VWP_MR_CST_PR_PVT.Estimate_MR_Price API Threw error'

Line 1202: fnd_log.level_error,

1198:
1199: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1200: fnd_log.string
1201: (
1202: fnd_log.level_error,
1203: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price',
1204: 'AHL_VWP_MR_CST_PR_PVT.Estimate_MR_Price API Threw error'
1205: );
1206: END IF;

Line 1270: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1266: );
1267:
1268: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1269:
1270: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1271: fnd_log.string
1272: (
1273: fnd_log.level_error,
1274: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_SR_price',

Line 1271: fnd_log.string

1267:
1268: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1269:
1270: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1271: fnd_log.string
1272: (
1273: fnd_log.level_error,
1274: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_SR_price',
1275: 'AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price API Threw error'

Line 1273: fnd_log.level_error,

1269:
1270: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1271: fnd_log.string
1272: (
1273: fnd_log.level_error,
1274: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_SR_price',
1275: 'AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price API Threw error'
1276: );
1277: END IF;

Line 1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1304:
1305: p_x_cost_price_rec.estimated_price:=l_estimated_price;
1306: p_x_cost_price_rec.actual_price:=l_actual_price;
1307:
1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_procedure,
1312: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price.end',

Line 1309: fnd_log.string

1305: p_x_cost_price_rec.estimated_price:=l_estimated_price;
1306: p_x_cost_price_rec.actual_price:=l_actual_price;
1307:
1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_procedure,
1312: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price.end',
1313: 'At the end of PLSQL procedure'

Line 1311: fnd_log.level_procedure,

1307:
1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1309: fnd_log.string
1310: (
1311: fnd_log.level_procedure,
1312: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.Estimate_SR_Price.end',
1313: 'At the end of PLSQL procedure'
1314: );
1315: END IF;

Line 1424: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1420: l_error_msg_code VARCHAR2(240);
1421: l_valid_flag VARCHAR2(1);
1422:
1423: BEGIN
1424: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1425: fnd_log.string
1426: (
1427: fnd_log.level_procedure,
1428: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price.begin',

Line 1425: fnd_log.string

1421: l_valid_flag VARCHAR2(1);
1422:
1423: BEGIN
1424: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1425: fnd_log.string
1426: (
1427: fnd_log.level_procedure,
1428: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price.begin',
1429: 'At the start of PLSQL procedure'

Line 1427: fnd_log.level_procedure,

1423: BEGIN
1424: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1425: fnd_log.string
1426: (
1427: fnd_log.level_procedure,
1428: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price.begin',
1429: 'At the start of PLSQL procedure'
1430: );
1431: END IF;

Line 1454: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1450: END IF;
1451:
1452: l_cost_price_rec:= p_x_cost_price_rec;
1453:
1454: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1455: fnd_log.string
1456: (
1457: fnd_log.level_statement,
1458: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1455: fnd_log.string

1451:
1452: l_cost_price_rec:= p_x_cost_price_rec;
1453:
1454: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1455: fnd_log.string
1456: (
1457: fnd_log.level_statement,
1458: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1459: 'Got request for estimating of Visit ID : ' || p_x_cost_price_rec.visit_id

Line 1457: fnd_log.level_statement,

1453:
1454: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1455: fnd_log.string
1456: (
1457: fnd_log.level_statement,
1458: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1459: 'Got request for estimating of Visit ID : ' || p_x_cost_price_rec.visit_id
1460: );
1461: END IF;

Line 1468: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

1464:
1465: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
1466: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
1467: FND_MSG_PUB.ADD;
1468: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1469: fnd_log.string
1470: (
1471: fnd_log.level_exception,
1472: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1469: fnd_log.string

1465: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
1466: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
1467: FND_MSG_PUB.ADD;
1468: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1469: fnd_log.string
1470: (
1471: fnd_log.level_exception,
1472: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1473: 'Visit id is mandatory but found null in input '

Line 1471: fnd_log.level_exception,

1467: FND_MSG_PUB.ADD;
1468: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1469: fnd_log.string
1470: (
1471: fnd_log.level_exception,
1472: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1473: 'Visit id is mandatory but found null in input '
1474: );
1475: END IF;

Line 1488: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

1484:
1485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
1486: FND_MSG_PUB.ADD;
1487:
1488: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1489: fnd_log.string
1490: (
1491: fnd_log.level_exception,
1492: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1489: fnd_log.string

1485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
1486: FND_MSG_PUB.ADD;
1487:
1488: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1489: fnd_log.string
1490: (
1491: fnd_log.level_exception,
1492: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1493: 'visit info not found for input visit id'

Line 1491: fnd_log.level_exception,

1487:
1488: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1489: fnd_log.string
1490: (
1491: fnd_log.level_exception,
1492: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1493: 'visit info not found for input visit id'
1494: );
1495: END IF;

Line 1508: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1504: IF(l_cost_price_rec.outside_party_flag <> 'Y')THEN
1505: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_PR_EST');
1506: FND_MSG_PUB.ADD;
1507:
1508: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1509: fnd_log.string
1510: (
1511: fnd_log.level_error,
1512: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1509: fnd_log.string

1505: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_PR_EST');
1506: FND_MSG_PUB.ADD;
1507:
1508: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1509: fnd_log.string
1510: (
1511: fnd_log.level_error,
1512: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1513: 'Price estimation is restricted to outside party visit only '

Line 1511: fnd_log.level_error,

1507:
1508: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1509: fnd_log.string
1510: (
1511: fnd_log.level_error,
1512: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1513: 'Price estimation is restricted to outside party visit only '
1514: );
1515: END IF;

Line 1519: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1515: END IF;
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518:
1519: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1520: fnd_log.string
1521: (
1522: fnd_log.level_error,
1523: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1520: fnd_log.string

1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518:
1519: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1520: fnd_log.string
1521: (
1522: fnd_log.level_error,
1523: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1524: 'Before release_visit cursor'

Line 1522: fnd_log.level_error,

1518:
1519: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1520: fnd_log.string
1521: (
1522: fnd_log.level_error,
1523: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1524: 'Before release_visit cursor'
1525: );
1526: END IF;

Line 1543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1539: x_msg_count => l_msg_count,
1540: x_msg_data => l_msg_data);
1541:
1542:
1543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1544: fnd_log.string
1545: (
1546: fnd_log.level_procedure,
1547: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',

Line 1544: fnd_log.string

1540: x_msg_data => l_msg_data);
1541:
1542:
1543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1544: fnd_log.string
1545: (
1546: fnd_log.level_procedure,
1547: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1548: 'After calling ahl vwp task cost pvt.Estimate Task cost Return Status : '|| l_return_status

Line 1546: fnd_log.level_procedure,

1542:
1543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1544: fnd_log.string
1545: (
1546: fnd_log.level_procedure,
1547: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1548: 'After calling ahl vwp task cost pvt.Estimate Task cost Return Status : '|| l_return_status
1549: );
1550: END IF;

Line 1569: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1565:
1566: --- Populate pricing attributes
1567:
1568: -- find out customer id
1569: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1570: fnd_log.string
1571: (
1572: fnd_log.level_error,
1573: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1570: fnd_log.string

1566: --- Populate pricing attributes
1567:
1568: -- find out customer id
1569: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1570: fnd_log.string
1571: (
1572: fnd_log.level_error,
1573: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1574: 'Before customer cursor'

Line 1572: fnd_log.level_error,

1568: -- find out customer id
1569: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1570: fnd_log.string
1571: (
1572: fnd_log.level_error,
1573: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1574: 'Before customer cursor'
1575: );
1576: END IF;

Line 1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1581: IF(customer_id_csr%NOTFOUND)THEN
1582: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SRVREQ_NOCUST');
1583: FND_MSG_PUB.ADD;
1584:
1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string
1587: (
1588: fnd_log.level_error,
1589: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1586: fnd_log.string

1582: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SRVREQ_NOCUST');
1583: FND_MSG_PUB.ADD;
1584:
1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string
1587: (
1588: fnd_log.level_error,
1589: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1590: 'Customer id not found for service request'

Line 1588: fnd_log.level_error,

1584:
1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string
1587: (
1588: fnd_log.level_error,
1589: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1590: 'Customer id not found for service request'
1591: );
1592: END IF;

Line 1610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1606: IF l_cost_price_rec.currency IS NULL THEN
1607: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
1608: FND_MSG_PUB.ADD;
1609:
1610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1611: fnd_log.string
1612: (
1613: fnd_log.level_error,
1614: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,

Line 1611: fnd_log.string

1607: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
1608: FND_MSG_PUB.ADD;
1609:
1610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1611: fnd_log.string
1612: (
1613: fnd_log.level_error,
1614: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
1615: 'No curency is defined for the organization of the visit'

Line 1613: fnd_log.level_error,

1609:
1610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1611: fnd_log.string
1612: (
1613: fnd_log.level_error,
1614: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
1615: 'No curency is defined for the organization of the visit'
1616: );
1617: END IF;

Line 1629: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1625:
1626: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
1627: FND_MSG_PUB.add;
1628:
1629: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1630: fnd_log.string
1631: (
1632: fnd_log.level_error,
1633: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 1630: fnd_log.string

1626: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
1627: FND_MSG_PUB.add;
1628:
1629: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1630: fnd_log.string
1631: (
1632: fnd_log.level_error,
1633: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1634: 'Price list not found for Visit'

Line 1632: fnd_log.level_error,

1628:
1629: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1630: fnd_log.string
1631: (
1632: fnd_log.level_error,
1633: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1634: 'Price list not found for Visit'
1635: );
1636: END IF;

Line 1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1640: l_cost_price_rec.PRICE_LIST_ID:=l_visit_rec.price_list_id;
1641: l_cost_price_rec.Organization_Id:=l_visit_rec.organization_id;
1642:
1643:
1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1645:
1646: fnd_log.string
1647: (
1648: fnd_log.level_statement,

Line 1646: fnd_log.string

1642:
1643:
1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1645:
1646: fnd_log.string
1647: (
1648: fnd_log.level_statement,
1649: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1650: 'Customer Id : ' || l_cost_price_rec.customer_id

Line 1648: fnd_log.level_statement,

1644: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1645:
1646: fnd_log.string
1647: (
1648: fnd_log.level_statement,
1649: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1650: 'Customer Id : ' || l_cost_price_rec.customer_id
1651: );
1652:

Line 1653: fnd_log.string

1649: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1650: 'Customer Id : ' || l_cost_price_rec.customer_id
1651: );
1652:
1653: fnd_log.string
1654: (
1655: fnd_log.level_statement,
1656: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1657: 'Visit Id : ' || l_cost_price_rec.visit_id

Line 1655: fnd_log.level_statement,

1651: );
1652:
1653: fnd_log.string
1654: (
1655: fnd_log.level_statement,
1656: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1657: 'Visit Id : ' || l_cost_price_rec.visit_id
1658: );
1659:

Line 1660: fnd_log.string

1656: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1657: 'Visit Id : ' || l_cost_price_rec.visit_id
1658: );
1659:
1660: fnd_log.string
1661: (
1662: fnd_log.level_statement,
1663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1664: 'Currency : ' || l_cost_price_rec.currency

Line 1662: fnd_log.level_statement,

1658: );
1659:
1660: fnd_log.string
1661: (
1662: fnd_log.level_statement,
1663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1664: 'Currency : ' || l_cost_price_rec.currency
1665: );
1666:

Line 1667: fnd_log.string

1663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1664: 'Currency : ' || l_cost_price_rec.currency
1665: );
1666:
1667: fnd_log.string
1668: (
1669: fnd_log.level_statement,
1670: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1671: 'Price List Id : ' || l_cost_price_rec.PRICE_LIST_ID

Line 1669: fnd_log.level_statement,

1665: );
1666:
1667: fnd_log.string
1668: (
1669: fnd_log.level_statement,
1670: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1671: 'Price List Id : ' || l_cost_price_rec.PRICE_LIST_ID
1672: );
1673:

Line 1674: fnd_log.string

1670: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1671: 'Price List Id : ' || l_cost_price_rec.PRICE_LIST_ID
1672: );
1673:
1674: fnd_log.string
1675: (
1676: fnd_log.level_statement,
1677: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1678: 'Organization ID : ' || l_cost_price_rec.Organization_Id

Line 1676: fnd_log.level_statement,

1672: );
1673:
1674: fnd_log.string
1675: (
1676: fnd_log.level_statement,
1677: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1678: 'Organization ID : ' || l_cost_price_rec.Organization_Id
1679: );
1680:

Line 1694: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1690:
1691:
1692: --- Check job status
1693:
1694: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1695: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1696: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
1697: 'before check job status');
1698: END IF;

Line 1695: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1691:
1692: --- Check job status
1693:
1694: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1695: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1696: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': ',
1697: 'before check job status');
1698: END IF;
1699:

Line 1716: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1712: END IF;
1713: END IF;
1714:
1715:
1716: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1717: fnd_log.string
1718: (
1719: fnd_log.level_error,
1720: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1717: fnd_log.string

1713: END IF;
1714:
1715:
1716: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1717: fnd_log.string
1718: (
1719: fnd_log.level_error,
1720: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1721: 'Before Summary TAsk cursor '

Line 1719: fnd_log.level_error,

1715:
1716: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1717: fnd_log.string
1718: (
1719: fnd_log.level_error,
1720: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1721: 'Before Summary TAsk cursor '
1722: );
1723: END IF;

Line 1771: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1767: );
1768:
1769: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1770:
1771: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1772: fnd_log.string
1773: (
1774: fnd_log.level_error,
1775: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1772: fnd_log.string

1768:
1769: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1770:
1771: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1772: fnd_log.string
1773: (
1774: fnd_log.level_error,
1775: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1776: 'AHL_VWP_MR_CST_PR_PVT.Estimate_MR_Price API Threw error'

Line 1774: fnd_log.level_error,

1770:
1771: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1772: fnd_log.string
1773: (
1774: fnd_log.level_error,
1775: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1776: 'AHL_VWP_MR_CST_PR_PVT.Estimate_MR_Price API Threw error'
1777: );
1778: END IF;

Line 1828: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1824: );
1825:
1826: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1827:
1828: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1829: fnd_log.string
1830: (
1831: fnd_log.level_error,
1832: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1829: fnd_log.string

1825:
1826: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1827:
1828: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1829: fnd_log.string
1830: (
1831: fnd_log.level_error,
1832: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1833: 'Estimate_SR_Price API Threw error'

Line 1831: fnd_log.level_error,

1827:
1828: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1829: fnd_log.string
1830: (
1831: fnd_log.level_error,
1832: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1833: 'Estimate_SR_Price API Threw error'
1834: );
1835: END IF;

Line 1899: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

1895: );
1896:
1897: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1898:
1899: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1900: fnd_log.string
1901: (
1902: fnd_log.level_error,
1903: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',

Line 1900: fnd_log.string

1896:
1897: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1898:
1899: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1900: fnd_log.string
1901: (
1902: fnd_log.level_error,
1903: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1904: 'AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price API Threw error'

Line 1902: fnd_log.level_error,

1898:
1899: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1900: fnd_log.string
1901: (
1902: fnd_log.level_error,
1903: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price',
1904: 'AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price API Threw error'
1905: );
1906: END IF;

Line 2062: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2058: IF FND_API.TO_BOOLEAN(p_commit) THEN
2059: COMMIT WORK;
2060: END IF;
2061:
2062: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2063: fnd_log.string
2064: (
2065: fnd_log.level_procedure,
2066: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price.end',

Line 2063: fnd_log.string

2059: COMMIT WORK;
2060: END IF;
2061:
2062: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2063: fnd_log.string
2064: (
2065: fnd_log.level_procedure,
2066: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price.end',
2067: 'At the end of PLSQL procedure'

Line 2065: fnd_log.level_procedure,

2061:
2062: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2063: fnd_log.string
2064: (
2065: fnd_log.level_procedure,
2066: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_price.end',
2067: 'At the end of PLSQL procedure'
2068: );
2069: END IF;

Line 2163: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2159: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
2160:
2161: BEGIN
2162:
2163: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2164: fnd_log.string
2165: (
2166: fnd_log.level_procedure,
2167: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot.begin',

Line 2164: fnd_log.string

2160:
2161: BEGIN
2162:
2163: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2164: fnd_log.string
2165: (
2166: fnd_log.level_procedure,
2167: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot.begin',
2168: 'At the start of PLSQL procedure'

Line 2166: fnd_log.level_procedure,

2162:
2163: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2164: fnd_log.string
2165: (
2166: fnd_log.level_procedure,
2167: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot.begin',
2168: 'At the start of PLSQL procedure'
2169: );
2170: END IF;

Line 2194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2190: THEN
2191: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2192: END IF;
2193:
2194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2195: fnd_log.string
2196: (
2197: fnd_log.level_statement,
2198: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',

Line 2195: fnd_log.string

2191: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2192: END IF;
2193:
2194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2195: fnd_log.string
2196: (
2197: fnd_log.level_statement,
2198: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',
2199: 'Got request for tasking a price snapshot of Visit ID : ' || p_visit_id

Line 2197: fnd_log.level_statement,

2193:
2194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2195: fnd_log.string
2196: (
2197: fnd_log.level_statement,
2198: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',
2199: 'Got request for tasking a price snapshot of Visit ID : ' || p_visit_id
2200: );
2201: END IF;

Line 2210: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2206:
2207: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2208: FND_MSG_PUB.ADD;
2209:
2210: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2211: fnd_log.string
2212: (
2213: fnd_log.level_exception,
2214: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',

Line 2211: fnd_log.string

2207: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2208: FND_MSG_PUB.ADD;
2209:
2210: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2211: fnd_log.string
2212: (
2213: fnd_log.level_exception,
2214: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',
2215: 'Visit id is mandatory but found null in input '

Line 2213: fnd_log.level_exception,

2209:
2210: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2211: fnd_log.string
2212: (
2213: fnd_log.level_exception,
2214: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',
2215: 'Visit id is mandatory but found null in input '
2216: );
2217: END IF;

Line 2234: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2230: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);
2231: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2232: FND_MSG_PUB.ADD;
2233:
2234: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2235: fnd_log.string
2236: (
2237: fnd_log.level_error,
2238: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',

Line 2235: fnd_log.string

2231: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2232: FND_MSG_PUB.ADD;
2233:
2234: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2235: fnd_log.string
2236: (
2237: fnd_log.level_error,
2238: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',
2239: 'Price not found for task id : ' || other_tasks_rec.visit_task_id

Line 2237: fnd_log.level_error,

2233:
2234: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2235: fnd_log.string
2236: (
2237: fnd_log.level_error,
2238: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot',
2239: 'Price not found for task id : ' || other_tasks_rec.visit_task_id
2240: );
2241: END IF;

Line 2333: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2329: IF FND_API.TO_BOOLEAN(p_commit) THEN
2330: COMMIT WORK;
2331: END IF;
2332:
2333: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2334: fnd_log.string
2335: (
2336: fnd_log.level_procedure,
2337: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot.end',

Line 2334: fnd_log.string

2330: COMMIT WORK;
2331: END IF;
2332:
2333: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2334: fnd_log.string
2335: (
2336: fnd_log.level_procedure,
2337: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot.end',
2338: 'At the end of PLSQL procedure'

Line 2336: fnd_log.level_procedure,

2332:
2333: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2334: fnd_log.string
2335: (
2336: fnd_log.level_procedure,
2337: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_price_snapshot.end',
2338: 'At the end of PLSQL procedure'
2339: );
2340: END IF;

Line 2444: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2440: L_API_NAME CONSTANT VARCHAR2(30) := 'create_cost_snapshot';
2441: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
2442:
2443: BEGIN
2444: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2445: fnd_log.string
2446: (
2447: fnd_log.level_procedure,
2448: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot.begin',

Line 2445: fnd_log.string

2441: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
2442:
2443: BEGIN
2444: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2445: fnd_log.string
2446: (
2447: fnd_log.level_procedure,
2448: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot.begin',
2449: 'At the start of PLSQL procedure'

Line 2447: fnd_log.level_procedure,

2443: BEGIN
2444: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2445: fnd_log.string
2446: (
2447: fnd_log.level_procedure,
2448: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot.begin',
2449: 'At the start of PLSQL procedure'
2450: );
2451: END IF;

Line 2474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2470: END IF;
2471:
2472: l_cost_price_rec := p_x_cost_price_rec;
2473:
2474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2475: fnd_log.string
2476: (
2477: fnd_log.level_statement,
2478: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',

Line 2475: fnd_log.string

2471:
2472: l_cost_price_rec := p_x_cost_price_rec;
2473:
2474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2475: fnd_log.string
2476: (
2477: fnd_log.level_statement,
2478: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2479: 'Got request for tasking a cost snapshot of Visit ID : ' || p_x_cost_price_rec.visit_id

Line 2477: fnd_log.level_statement,

2473:
2474: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2475: fnd_log.string
2476: (
2477: fnd_log.level_statement,
2478: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2479: 'Got request for tasking a cost snapshot of Visit ID : ' || p_x_cost_price_rec.visit_id
2480: );
2481: END IF;

Line 2487: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2483: -- make sure that visit id is present in the input
2484: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
2485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2486: FND_MSG_PUB.ADD;
2487: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2488: fnd_log.string
2489: (
2490: fnd_log.level_exception,
2491: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',

Line 2488: fnd_log.string

2484: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
2485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2486: FND_MSG_PUB.ADD;
2487: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2488: fnd_log.string
2489: (
2490: fnd_log.level_exception,
2491: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2492: 'Visit id is mandatory but found null in input '

Line 2490: fnd_log.level_exception,

2486: FND_MSG_PUB.ADD;
2487: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2488: fnd_log.string
2489: (
2490: fnd_log.level_exception,
2491: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2492: 'Visit id is mandatory but found null in input '
2493: );
2494: END IF;

Line 2513: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN

2509: x_return_status => x_return_status
2510: );
2511:
2512: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2513: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2514: fnd_log.string
2515: (
2516: fnd_log.level_exception,
2517: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',

Line 2514: fnd_log.string

2510: );
2511:
2512: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2513: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2514: fnd_log.string
2515: (
2516: fnd_log.level_exception,
2517: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2518: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status

Line 2516: fnd_log.level_exception,

2512: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2513: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2514: fnd_log.string
2515: (
2516: fnd_log.level_exception,
2517: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2518: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status
2519: );
2520: END IF;

Line 2542: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2538:
2539: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2540: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2541: FND_MSG_PUB.ADD;
2542: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2543: fnd_log.string
2544: (
2545: fnd_log.level_error,
2546: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',

Line 2543: fnd_log.string

2539: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2540: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2541: FND_MSG_PUB.ADD;
2542: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2543: fnd_log.string
2544: (
2545: fnd_log.level_error,
2546: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2547: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :summary: x_return_status : ' || x_return_status

Line 2545: fnd_log.level_error,

2541: FND_MSG_PUB.ADD;
2542: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2543: fnd_log.string
2544: (
2545: fnd_log.level_error,
2546: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2547: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :summary: x_return_status : ' || x_return_status
2548: );
2549: END IF;

Line 2610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2606:
2607: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2608: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2609: FND_MSG_PUB.ADD;
2610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string
2612: (
2613: fnd_log.level_error,
2614: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',

Line 2611: fnd_log.string

2607: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2608: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2609: FND_MSG_PUB.ADD;
2610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string
2612: (
2613: fnd_log.level_error,
2614: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2615: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :other: x_return_status : ' || x_return_status

Line 2613: fnd_log.level_error,

2609: FND_MSG_PUB.ADD;
2610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string
2612: (
2613: fnd_log.level_error,
2614: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2615: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :other: x_return_status : ' || x_return_status
2616: );
2617: END IF;

Line 2672: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2668: IF FND_API.TO_BOOLEAN(p_commit) THEN
2669: COMMIT WORK;
2670: END IF;
2671:
2672: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2673: fnd_log.string
2674: (
2675: fnd_log.level_procedure,
2676: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot.end',

Line 2673: fnd_log.string

2669: COMMIT WORK;
2670: END IF;
2671:
2672: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2673: fnd_log.string
2674: (
2675: fnd_log.level_procedure,
2676: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot.end',
2677: 'At the end of PLSQL procedure'

Line 2675: fnd_log.level_procedure,

2671:
2672: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2673: fnd_log.string
2674: (
2675: fnd_log.level_procedure,
2676: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot.end',
2677: 'At the end of PLSQL procedure'
2678: );
2679: END IF;

Line 2803: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2799: CONNECT BY originating_task_id = PRIOR visit_task_id;
2800: --
2801: BEGIN
2802:
2803: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2804: fnd_log.string
2805: (
2806: fnd_log.level_procedure,
2807: l_module_name,

Line 2804: fnd_log.string

2800: --
2801: BEGIN
2802:
2803: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2804: fnd_log.string
2805: (
2806: fnd_log.level_procedure,
2807: l_module_name,
2808: 'Start of '||l_api_name

Line 2806: fnd_log.level_procedure,

2802:
2803: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2804: fnd_log.string
2805: (
2806: fnd_log.level_procedure,
2807: l_module_name,
2808: 'Start of '||l_api_name
2809: );
2810: END IF;

Line 2828: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2824: END IF;
2825:
2826: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2827:
2828: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2829: fnd_log.string
2830: (
2831: fnd_log.level_statement,
2832: l_module_name,

Line 2829: fnd_log.string

2825:
2826: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2827:
2828: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2829: fnd_log.string
2830: (
2831: fnd_log.level_statement,
2832: l_module_name,
2833: 'Request to get items without price for Visit ID : ' || l_cost_price_rec.visit_id

Line 2831: fnd_log.level_statement,

2827:
2828: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2829: fnd_log.string
2830: (
2831: fnd_log.level_statement,
2832: l_module_name,
2833: 'Request to get items without price for Visit ID : ' || l_cost_price_rec.visit_id
2834: );
2835: END IF;

Line 2844: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2840: l_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
2841: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');
2842: FND_MSG_PUB.ADD;
2843:
2844: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2845: fnd_log.string
2846: (
2847: fnd_log.level_error,
2848: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2845: fnd_log.string

2841: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');
2842: FND_MSG_PUB.ADD;
2843:
2844: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2845: fnd_log.string
2846: (
2847: fnd_log.level_error,
2848: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2849: 'Visit id is mandatory but found null in input '

Line 2847: fnd_log.level_error,

2843:
2844: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2845: fnd_log.string
2846: (
2847: fnd_log.level_error,
2848: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2849: 'Visit id is mandatory but found null in input '
2850: );
2851: END IF;

Line 2879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2875:
2876:
2877: IF l_release_visit_required ='Y' THEN
2878:
2879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2880: fnd_log.string
2881: (
2882: fnd_log.level_statement,
2883: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2880: fnd_log.string

2876:
2877: IF l_release_visit_required ='Y' THEN
2878:
2879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2880: fnd_log.string
2881: (
2882: fnd_log.level_statement,
2883: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2884: 'Before calling ahl vwp proj prod pvt.release visit'

Line 2882: fnd_log.level_statement,

2878:
2879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2880: fnd_log.string
2881: (
2882: fnd_log.level_statement,
2883: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2884: 'Before calling ahl vwp proj prod pvt.release visit'
2885: );
2886: END IF;

Line 2901: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2897: x_msg_data =>x_msg_data,
2898: p_visit_id =>l_visit_rec.visit_id
2899: );
2900:
2901: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2902: fnd_log.string
2903: (
2904: fnd_log.level_statement,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2902: fnd_log.string

2898: p_visit_id =>l_visit_rec.visit_id
2899: );
2900:
2901: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2902: fnd_log.string
2903: (
2904: fnd_log.level_statement,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2906: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status

Line 2904: fnd_log.level_statement,

2900:
2901: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2902: fnd_log.string
2903: (
2904: fnd_log.level_statement,
2905: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2906: 'After calling ahl vwp proj prod pvt.Release Visit task wo Return Status : '|| l_return_status
2907: );
2908: END IF;

Line 2945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2941:
2942: END IF;
2943:
2944:
2945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2946: fnd_log.string
2947: (
2948: fnd_log.level_statement,
2949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2946: fnd_log.string

2942: END IF;
2943:
2944:
2945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2946: fnd_log.string
2947: (
2948: fnd_log.level_statement,
2949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2950: 'Price List ID :' ||l_cost_price_rec.price_list_id

Line 2948: fnd_log.level_statement,

2944:
2945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2946: fnd_log.string
2947: (
2948: fnd_log.level_statement,
2949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2950: 'Price List ID :' ||l_cost_price_rec.price_list_id
2951: );
2952: END IF;

Line 2956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2952: END IF;
2953:
2954: l_cost_price_rec.organization_id:=l_visit_rec.organization_id;
2955:
2956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2957: fnd_log.string
2958: (
2959: fnd_log.level_statement,
2960: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2957: fnd_log.string

2953:
2954: l_cost_price_rec.organization_id:=l_visit_rec.organization_id;
2955:
2956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2957: fnd_log.string
2958: (
2959: fnd_log.level_statement,
2960: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2961: 'Organization ID :' ||l_cost_price_rec.organization_id

Line 2959: fnd_log.level_statement,

2955:
2956: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2957: fnd_log.string
2958: (
2959: fnd_log.level_statement,
2960: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2961: 'Organization ID :' ||l_cost_price_rec.organization_id
2962: );
2963: END IF;

Line 2972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2968: Open c_customer_csr(l_visit_rec.service_request_id);
2969: fetch c_customer_csr into l_cost_price_rec.customer_id;
2970: close c_customer_csr;
2971:
2972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2973: fnd_log.string
2974: (
2975: fnd_log.level_statement,
2976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 2973: fnd_log.string

2969: fetch c_customer_csr into l_cost_price_rec.customer_id;
2970: close c_customer_csr;
2971:
2972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2973: fnd_log.string
2974: (
2975: fnd_log.level_statement,
2976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2977: 'Customer ID :' ||l_cost_price_rec.customer_id

Line 2975: fnd_log.level_statement,

2971:
2972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2973: fnd_log.string
2974: (
2975: fnd_log.level_statement,
2976: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2977: 'Customer ID :' ||l_cost_price_rec.customer_id
2978: );
2979: END IF;

Line 2993: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

2989: -- Error handling
2990: IF l_cost_price_rec.currency IS NULL THEN
2991: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
2992: FND_MSG_PUB.ADD;
2993: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2994: fnd_log.string
2995: (
2996: fnd_log.level_error,
2997: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,

Line 2994: fnd_log.string

2990: IF l_cost_price_rec.currency IS NULL THEN
2991: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
2992: FND_MSG_PUB.ADD;
2993: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2994: fnd_log.string
2995: (
2996: fnd_log.level_error,
2997: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
2998: 'No curency is defined for the organization of the visit'

Line 2996: fnd_log.level_error,

2992: FND_MSG_PUB.ADD;
2993: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2994: fnd_log.string
2995: (
2996: fnd_log.level_error,
2997: 'ahl.plsql.'||G_PKG_NAME||'.'||L_API_NAME,
2998: 'No curency is defined for the organization of the visit'
2999: );
3000: END IF;

Line 3004: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3000: END IF;
3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003:
3004: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3005: fnd_log.string
3006: (
3007: fnd_log.level_statement,
3008: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3005: fnd_log.string

3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003:
3004: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3005: fnd_log.string
3006: (
3007: fnd_log.level_statement,
3008: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3009: 'Currency Code :' ||l_cost_price_rec.currency

Line 3007: fnd_log.level_statement,

3003:
3004: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3005: fnd_log.string
3006: (
3007: fnd_log.level_statement,
3008: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3009: 'Currency Code :' ||l_cost_price_rec.currency
3010: );
3011: END IF;

Line 3014: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3010: );
3011: END IF;
3012:
3013:
3014: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3015: fnd_log.string
3016: (
3017: fnd_log.level_statement,
3018: l_module_name,

Line 3015: fnd_log.string

3011: END IF;
3012:
3013:
3014: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3015: fnd_log.string
3016: (
3017: fnd_log.level_statement,
3018: l_module_name,
3019: 'Before Call to AHL_VWP_RULES_PVT.Check_Job_Status'

Line 3017: fnd_log.level_statement,

3013:
3014: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3015: fnd_log.string
3016: (
3017: fnd_log.level_statement,
3018: l_module_name,
3019: 'Before Call to AHL_VWP_RULES_PVT.Check_Job_Status'
3020: );
3021: END IF;

Line 3039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3035: RAISE FND_API.G_EXC_ERROR;
3036: END IF;
3037: END IF;
3038:
3039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3040: fnd_log.string
3041: (
3042: fnd_log.level_statement,
3043: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3040: fnd_log.string

3036: END IF;
3037: END IF;
3038:
3039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3040: fnd_log.string
3041: (
3042: fnd_log.level_statement,
3043: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3044: 'Job Status :' ||l_job_status_code

Line 3042: fnd_log.level_statement,

3038:
3039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3040: fnd_log.string
3041: (
3042: fnd_log.level_statement,
3043: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3044: 'Job Status :' ||l_job_status_code
3045: );
3046: END IF;

Line 3055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3051: LOOP
3052: FETCH c_summary_tasks_csr into l_summary_recs;
3053: EXIT WHEN c_summary_tasks_csr%notfound;
3054:
3055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3056: fnd_log.string(
3057: fnd_log.level_statement,
3058: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3059: 'Current Task ID: ' || l_summary_recs.visit_task_id

Line 3056: fnd_log.string(

3052: FETCH c_summary_tasks_csr into l_summary_recs;
3053: EXIT WHEN c_summary_tasks_csr%notfound;
3054:
3055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3056: fnd_log.string(
3057: fnd_log.level_statement,
3058: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3059: 'Current Task ID: ' || l_summary_recs.visit_task_id
3060: );

Line 3057: fnd_log.level_statement,

3053: EXIT WHEN c_summary_tasks_csr%notfound;
3054:
3055: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3056: fnd_log.string(
3057: fnd_log.level_statement,
3058: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3059: 'Current Task ID: ' || l_summary_recs.visit_task_id
3060: );
3061: END IF;

Line 3069: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3065: FETCH get_summary_task_times_csr INTO l_cost_price_rec.Task_Start_Date,
3066: l_cost_price_rec.Task_END_Date;
3067: CLOSE get_summary_task_times_csr;
3068:
3069: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3070: fnd_log.string
3071: (
3072: fnd_log.level_statement,
3073: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3070: fnd_log.string

3066: l_cost_price_rec.Task_END_Date;
3067: CLOSE get_summary_task_times_csr;
3068:
3069: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3070: fnd_log.string
3071: (
3072: fnd_log.level_statement,
3073: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3074: 'task_start_date : ' ||l_cost_price_rec.task_start_date

Line 3072: fnd_log.level_statement,

3068:
3069: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3070: fnd_log.string
3071: (
3072: fnd_log.level_statement,
3073: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3074: 'task_start_date : ' ||l_cost_price_rec.task_start_date
3075: );
3076: END IF;

Line 3078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3074: 'task_start_date : ' ||l_cost_price_rec.task_start_date
3075: );
3076: END IF;
3077:
3078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3079: fnd_log.string
3080: (
3081: fnd_log.level_statement,
3082: l_module_name,

Line 3079: fnd_log.string

3075: );
3076: END IF;
3077:
3078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3079: fnd_log.string
3080: (
3081: fnd_log.level_statement,
3082: l_module_name,
3083: 'Before Call to AHL_VWP_MR_CST_PR_PVT.get_mr_items_no_price'

Line 3081: fnd_log.level_statement,

3077:
3078: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3079: fnd_log.string
3080: (
3081: fnd_log.level_statement,
3082: l_module_name,
3083: 'Before Call to AHL_VWP_MR_CST_PR_PVT.get_mr_items_no_price'
3084: );
3085: END IF;

Line 3103: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3099: x_cost_price_tbl =>l_cost_price_tbl1
3100: );
3101:
3102:
3103: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3104: fnd_log.string
3105: (
3106: fnd_log.level_statement,
3107: l_module_name,

Line 3104: fnd_log.string

3100: );
3101:
3102:
3103: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3104: fnd_log.string
3105: (
3106: fnd_log.level_statement,
3107: l_module_name,
3108: 'After Call to AHL_VWP_MR_CST_PR_PVT.get_mr_items_no_price'

Line 3106: fnd_log.level_statement,

3102:
3103: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3104: fnd_log.string
3105: (
3106: fnd_log.level_statement,
3107: l_module_name,
3108: 'After Call to AHL_VWP_MR_CST_PR_PVT.get_mr_items_no_price'
3109: );
3110: END IF;

Line 3138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3134: LOOP
3135: FETCH c_task_csr into l_task_csr_rec;
3136: EXIT WHEN c_task_csr%NOTFOUND;
3137:
3138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3139: fnd_log.string(
3140: fnd_log.level_statement,
3141: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3142: 'Current Task ID: ' || l_task_csr_rec.visit_task_id

Line 3139: fnd_log.string(

3135: FETCH c_task_csr into l_task_csr_rec;
3136: EXIT WHEN c_task_csr%NOTFOUND;
3137:
3138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3139: fnd_log.string(
3140: fnd_log.level_statement,
3141: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3142: 'Current Task ID: ' || l_task_csr_rec.visit_task_id
3143: );

Line 3140: fnd_log.level_statement,

3136: EXIT WHEN c_task_csr%NOTFOUND;
3137:
3138: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3139: fnd_log.string(
3140: fnd_log.level_statement,
3141: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3142: 'Current Task ID: ' || l_task_csr_rec.visit_task_id
3143: );
3144: END IF;

Line 3153: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3149: FETCH get_summary_task_times_csr INTO l_cost_price_rec.Task_Start_Date,
3150: l_cost_price_rec.Task_END_Date;
3151: CLOSE get_summary_task_times_csr;
3152:
3153: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3154: fnd_log.string
3155: (
3156: fnd_log.level_statement,
3157: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3154: fnd_log.string

3150: l_cost_price_rec.Task_END_Date;
3151: CLOSE get_summary_task_times_csr;
3152:
3153: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3154: fnd_log.string
3155: (
3156: fnd_log.level_statement,
3157: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3158: 'task_start_date : ' ||l_cost_price_rec.task_start_date

Line 3156: fnd_log.level_statement,

3152:
3153: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3154: fnd_log.string
3155: (
3156: fnd_log.level_statement,
3157: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3158: 'task_start_date : ' ||l_cost_price_rec.task_start_date
3159: );
3160: END IF;

Line 3162: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3158: 'task_start_date : ' ||l_cost_price_rec.task_start_date
3159: );
3160: END IF;
3161:
3162: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3163: fnd_log.string
3164: (
3165: fnd_log.level_statement,
3166: l_module_name,

Line 3163: fnd_log.string

3159: );
3160: END IF;
3161:
3162: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3163: fnd_log.string
3164: (
3165: fnd_log.level_statement,
3166: l_module_name,
3167: 'Before Call to AHL_VWP_TASK_CST_PR_PVt.get_task_items_no_price'

Line 3165: fnd_log.level_statement,

3161:
3162: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3163: fnd_log.string
3164: (
3165: fnd_log.level_statement,
3166: l_module_name,
3167: 'Before Call to AHL_VWP_TASK_CST_PR_PVt.get_task_items_no_price'
3168: );
3169: END IF;

Line 3185: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3181: p_cost_price_rec =>l_cost_price_rec,
3182: x_cost_price_tbl =>l_cost_price_tbl1
3183: );
3184:
3185: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3186: fnd_log.string
3187: (
3188: fnd_log.level_statement,
3189: l_module_name,

Line 3186: fnd_log.string

3182: x_cost_price_tbl =>l_cost_price_tbl1
3183: );
3184:
3185: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3186: fnd_log.string
3187: (
3188: fnd_log.level_statement,
3189: l_module_name,
3190: 'After Call to AHL_VWP_TASK_CST_PR_PVt.get_task_items_no_price'

Line 3188: fnd_log.level_statement,

3184:
3185: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3186: fnd_log.string
3187: (
3188: fnd_log.level_statement,
3189: l_module_name,
3190: 'After Call to AHL_VWP_TASK_CST_PR_PVt.get_task_items_no_price'
3191: );
3192: END IF;

Line 3224: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3220: END IF;
3221:
3222: x_cost_price_tbl:=l_cost_price_tbl;
3223:
3224: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3225: fnd_log.string
3226: (
3227: fnd_log.level_statement,
3228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3225: fnd_log.string

3221:
3222: x_cost_price_tbl:=l_cost_price_tbl;
3223:
3224: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3225: fnd_log.string
3226: (
3227: fnd_log.level_statement,
3228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3229: 'Total number of items w/o price for the MR: ' || x_cost_price_tbl.count

Line 3227: fnd_log.level_statement,

3223:
3224: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3225: fnd_log.string
3226: (
3227: fnd_log.level_statement,
3228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3229: 'Total number of items w/o price for the MR: ' || x_cost_price_tbl.count
3230: );
3231: END IF;

Line 3237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3233: IF FND_API.TO_BOOLEAN(p_commit) THEN
3234: COMMIT;
3235: END IF;
3236:
3237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3238: fnd_log.string
3239: (
3240: fnd_log.level_procedure,
3241: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3238: fnd_log.string

3234: COMMIT;
3235: END IF;
3236:
3237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3238: fnd_log.string
3239: (
3240: fnd_log.level_procedure,
3241: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3242: 'At the end of the procedure');

Line 3240: fnd_log.level_procedure,

3236:
3237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3238: fnd_log.string
3239: (
3240: fnd_log.level_procedure,
3241: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3242: 'At the end of the procedure');
3243: END IF;
3244:

Line 3341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

3337: l_dummy NUMBER;
3338:
3339: BEGIN
3340:
3341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3343: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
3344: 'At the start of the procedure');
3345: END IF;

Line 3342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3338:
3339: BEGIN
3340:
3341: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3343: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin API',
3344: 'At the start of the procedure');
3345: END IF;
3346:

Line 3353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3349: OPEN c_visit_csr(p_visit_id);
3350: FETCH c_visit_csr into l_any_task_chg_flag, l_visit_status_code;
3351: CLOSE c_visit_csr;
3352:
3353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3354: fnd_log.string
3355: (
3356: fnd_log.level_statement,
3357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3354: fnd_log.string

3350: FETCH c_visit_csr into l_any_task_chg_flag, l_visit_status_code;
3351: CLOSE c_visit_csr;
3352:
3353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3354: fnd_log.string
3355: (
3356: fnd_log.level_statement,
3357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3358: '.any_task_chg_flag : ' || l_any_task_chg_flag

Line 3356: fnd_log.level_statement,

3352:
3353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3354: fnd_log.string
3355: (
3356: fnd_log.level_statement,
3357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3358: '.any_task_chg_flag : ' || l_any_task_chg_flag
3359: );
3360:

Line 3363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3359: );
3360:
3361: END IF;
3362:
3363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3364: fnd_log.string
3365: (
3366: fnd_log.level_statement,
3367: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3364: fnd_log.string

3360:
3361: END IF;
3362:
3363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3364: fnd_log.string
3365: (
3366: fnd_log.level_statement,
3367: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3368: '.visit status code : ' || l_visit_status_code

Line 3366: fnd_log.level_statement,

3362:
3363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3364: fnd_log.string
3365: (
3366: fnd_log.level_statement,
3367: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3368: '.visit status code : ' || l_visit_status_code
3369: );
3370:

Line 3393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3389: OPEN c_get_master_wo_cur(p_visit_id);
3390: FETCH c_get_master_wo_cur INTO l_master_wo_rec;
3391: CLOSE c_get_master_wo_cur;
3392:
3393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3394: fnd_log.string
3395: (
3396: fnd_log.level_statement,
3397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3394: fnd_log.string

3390: FETCH c_get_master_wo_cur INTO l_master_wo_rec;
3391: CLOSE c_get_master_wo_cur;
3392:
3393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3394: fnd_log.string
3395: (
3396: fnd_log.level_statement,
3397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3398: 'Visit Master Workorder Id : ' || l_master_wo_rec.workorder_id

Line 3396: fnd_log.level_statement,

3392:
3393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3394: fnd_log.string
3395: (
3396: fnd_log.level_statement,
3397: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3398: 'Visit Master Workorder Id : ' || l_master_wo_rec.workorder_id
3399: );
3400: END IF;

Line 3424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3420: OPEN c_check_wo_exists_cur(l_visit_tasks_rec.visit_task_id);
3421: FETCH c_check_wo_exists_cur INTO l_dummy;
3422:
3423: IF c_check_wo_exists_cur%NOTFOUND THEN
3424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3425: fnd_log.string
3426: (
3427: fnd_log.level_statement,
3428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3425: fnd_log.string

3421: FETCH c_check_wo_exists_cur INTO l_dummy;
3422:
3423: IF c_check_wo_exists_cur%NOTFOUND THEN
3424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3425: fnd_log.string
3426: (
3427: fnd_log.level_statement,
3428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3429: 'workorder not exist for visit task '||l_visit_tasks_rec.visit_task_id

Line 3427: fnd_log.level_statement,

3423: IF c_check_wo_exists_cur%NOTFOUND THEN
3424: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3425: fnd_log.string
3426: (
3427: fnd_log.level_statement,
3428: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3429: 'workorder not exist for visit task '||l_visit_tasks_rec.visit_task_id
3430: );
3431: END IF;

Line 3447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

3443: CLOSE c_get_visit_tasks_cur;
3444: END IF; -- released visit flag
3445:
3446: x_release_visit_required := l_release_visit_required;
3447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3448: fnd_log.string
3449: (
3450: fnd_log.level_statement,
3451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3448: fnd_log.string

3444: END IF; -- released visit flag
3445:
3446: x_release_visit_required := l_release_visit_required;
3447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3448: fnd_log.string
3449: (
3450: fnd_log.level_statement,
3451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3452: 'x_release_visit_required: '||x_release_visit_required

Line 3450: fnd_log.level_statement,

3446: x_release_visit_required := l_release_visit_required;
3447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3448: fnd_log.string
3449: (
3450: fnd_log.level_statement,
3451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3452: 'x_release_visit_required: '||x_release_visit_required
3453: );
3454: END IF;

Line 3456: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3452: 'x_release_visit_required: '||x_release_visit_required
3453: );
3454: END IF;
3455:
3456: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3457: fnd_log.string
3458: (
3459: fnd_log.level_statement,
3460: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 3457: fnd_log.string

3453: );
3454: END IF;
3455:
3456: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3457: fnd_log.string
3458: (
3459: fnd_log.level_statement,
3460: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3461: 'At the end of the procedure'

Line 3459: fnd_log.level_statement,

3455:
3456: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3457: fnd_log.string
3458: (
3459: fnd_log.level_statement,
3460: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3461: 'At the end of the procedure'
3462: );
3463: END IF;