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_AVF_PRIM_VSTS_PVT dependencies on FND_LOG

Line 10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

6:
7: ------------------------------------
8: -- Common constants and variables --
9: ------------------------------------
10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
11: l_log_statement NUMBER := fnd_log.level_statement;
12: l_log_procedure NUMBER := fnd_log.level_procedure;
13:
14: ---------------------------------------------------------------------

Line 11: l_log_statement NUMBER := fnd_log.level_statement;

7: ------------------------------------
8: -- Common constants and variables --
9: ------------------------------------
10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
11: l_log_statement NUMBER := fnd_log.level_statement;
12: l_log_procedure NUMBER := fnd_log.level_procedure;
13:
14: ---------------------------------------------------------------------
15: -- Define Record Types for record structures needed by the APIs --

Line 12: l_log_procedure NUMBER := fnd_log.level_procedure;

8: -- Common constants and variables --
9: ------------------------------------
10: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
11: l_log_statement NUMBER := fnd_log.level_statement;
12: l_log_procedure NUMBER := fnd_log.level_procedure;
13:
14: ---------------------------------------------------------------------
15: -- Define Record Types for record structures needed by the APIs --
16: ---------------------------------------------------------------------

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

218: -- Save Point declaration.
219: SAVEPOINT Save_Add_MRs;
220:
221: --------------------- Initialize -----------------------
222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
223: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY||'.begin','At the start of PLSQL procedure');
224: END IF;
225:
226: -- Printing The input Parameters

Line 223: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY||'.begin','At the start of PLSQL procedure');

219: SAVEPOINT Save_Add_MRs;
220:
221: --------------------- Initialize -----------------------
222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
223: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY||'.begin','At the start of PLSQL procedure');
224: END IF;
225:
226: -- Printing The input Parameters
227: IF (l_log_statement >= l_log_current_level) THEN

Line 228: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' p_api_version => ' || p_api_version ||

224: END IF;
225:
226: -- Printing The input Parameters
227: IF (l_log_statement >= l_log_current_level) THEN
228: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' p_api_version => ' || p_api_version ||
229: ' , p_init_msg_list => ' || p_init_msg_list ||
230: ' , p_commit => ' || p_commit ||
231: ' , p_validation_level => ' || p_validation_level ||
232: ' , p_visit_id => ' || p_visit_id ||

Line 265: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Visit Id = ' || p_visit_id);

261:
262: IF l_valid_visit_flag = 'X' THEN
263:
264: IF (l_log_statement >= l_log_current_level) THEN
265: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Visit Id = ' || p_visit_id);
266: END IF;
267: l_count_ues:= 0;
268: -- Getting the Visit details(Instance id (csi_id), Start date, End date and Visit category for the particular visit_id
269: OPEN get_visit_details(p_visit_id);

Line 292: fnd_log.string(l_log_statement,L_DEBUG_KEY,

288: -- If the MR is a parent MR and is associated with the some visit, Visit_id is returned.
289: IF l_parent_check IS NULL THEN
290:
291: IF (l_log_statement >= l_log_current_level) THEN
292: fnd_log.string(l_log_statement,L_DEBUG_KEY,
293: '(UE_ID,CATEGORY_UE,CATEGORY_VISIT) = ' || l_ue_id || ', ' || l_category_ue || ', ' || l_category_visit );
294: END IF;
295:
296: IF TO_NUMBER(l_category_visit) <= l_category_ue THEN

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

299: l_task_rec(1).task_type_code := 'PLANNED';
300: -- assign l_ue_id to p_visit_id;
301: -- Calling the API which associates.
302:
303: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
304: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);

Line 304: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);

300: -- assign l_ue_id to p_visit_id;
301: -- Calling the API which associates.
302:
303: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
304: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
308: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');

Line 305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);

301: -- Calling the API which associates.
302:
303: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
304: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
308: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
309: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: l_ue_id--@>'||'l_ue_id');

Line 306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);

302:
303: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
304: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
308: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
309: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: l_ue_id--@>'||'l_ue_id');
310: END IF;

Line 307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);

303: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
304: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
308: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
309: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: l_ue_id--@>'||'l_ue_id');
310: END IF;
311:

Line 308: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');

304: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
308: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
309: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: l_ue_id--@>'||'l_ue_id');
310: END IF;
311:
312: l_return_status := NULL;

Line 309: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: l_ue_id--@>'||'l_ue_id');

305: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
306: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
307: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
308: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
309: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: l_ue_id--@>'||'l_ue_id');
310: END IF;
311:
312: l_return_status := NULL;
313: l_msg_count := 0;

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

324: x_return_status => l_return_status,
325: x_msg_count => l_msg_count,
326: x_msg_data => l_msg_data);
327:
328: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
329: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
330: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
332: END IF;

Line 329: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);

325: x_msg_count => l_msg_count,
326: x_msg_data => l_msg_data);
327:
328: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
329: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
330: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
332: END IF;
333:

Line 330: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);

326: x_msg_data => l_msg_data);
327:
328: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
329: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
330: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
332: END IF;
333:
334: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);

327:
328: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
329: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
330: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
331: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
332: END IF;
333:
334: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
335: IF (l_log_statement >= l_log_current_level) THEN

Line 336: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while associating Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);

332: END IF;
333:
334: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
335: IF (l_log_statement >= l_log_current_level) THEN
336: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while associating Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);
337: END IF;
338: ELSE
339: IF (l_log_statement >= l_log_current_level) THEN
340: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully associated Unit effectivity '||l_ue_id||' to VISIT_ID : ' || p_visit_id);

Line 340: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully associated Unit effectivity '||l_ue_id||' to VISIT_ID : ' || p_visit_id);

336: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while associating Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);
337: END IF;
338: ELSE
339: IF (l_log_statement >= l_log_current_level) THEN
340: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully associated Unit effectivity '||l_ue_id||' to VISIT_ID : ' || p_visit_id);
341: END IF;
342: l_count_ues:=l_count_ues+1;
343: END IF;
344:

Line 347: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'UE_ID : ' || l_ue_id ||' not assigned to ' || p_visit_id || ' as category is higher ');

343: END IF;
344:
345: ELSE
346: IF (l_log_statement >= l_log_current_level) THEN
347: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'UE_ID : ' || l_ue_id ||' not assigned to ' || p_visit_id || ' as category is higher ');
348: END IF;
349: END IF;
350: ELSE
351:

Line 353: fnd_log.string(l_log_statement,L_DEBUG_KEY,

349: END IF;
350: ELSE
351:
352: IF (l_log_statement >= l_log_current_level) THEN
353: fnd_log.string(l_log_statement,L_DEBUG_KEY,
354: 'UE_ID(Parent MR) ' || l_ue_id || ' is already associated to Visit_id ' || p_visit_id);
355: END IF;
356:
357: END IF;

Line 367: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Visit Id : ' || p_visit_id);

363: END IF;
364: -- End of Bug 13707339
365: ELSE
366: IF (l_log_statement >= l_log_current_level) THEN
367: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Visit Id : ' || p_visit_id);
368: END IF;
369: Fnd_Message.SET_NAME('AHL','AHL_VISIT_ID_INVALID');
370: Fnd_Msg_Pub.ADD;
371: RAISE Fnd_Api.G_EXC_ERROR;

Line 383: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Snapshot Id = ' || p_snapshot_id);

379:
380: IF l_valid_snapshot_flag = 'X' THEN
381:
382: IF (l_log_statement >= l_log_current_level) THEN
383: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Snapshot Id = ' || p_snapshot_id);
384: END IF;
385:
386: -- Getting the start and end date of the Snapshot
387: OPEN get_dates(p_snapshot_id);

Line 398: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Process for MC_ID : ' || l_mc_id);

394: FETCH get_mc_ids INTO l_mc_id;
395: exit when get_mc_ids%NOTFOUND;
396:
397: IF (l_log_statement >= l_log_current_level) THEN
398: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Process for MC_ID : ' || l_mc_id);
399: END IF;
400:
401: -- Getting the UE_IDs for the particular MC_ID. Number of UE_IDs are retrieved.
402: OPEN get_ue_details(l_mc_id, l_start_date, l_end_date);

Line 408: fnd_log.string(l_log_statement,L_DEBUG_KEY,

404: FETCH get_ue_details INTO l_ue_id, l_due_date, l_lat_due_date, l_instance_id, l_category_ue;
405: exit when get_ue_details%NOTFOUND;
406:
407: IF (l_log_statement >= l_log_current_level) THEN
408: fnd_log.string(l_log_statement,L_DEBUG_KEY,
409: '(UE_ID, INSTANCE_ID, CATEGORY_UE, DUE_DATE, LATEST_DUE_DATE) = ' || l_ue_id || ', ' || l_instance_id ||
410: ', ' || l_category_ue || ', ' || l_due_date || ', '|| l_lat_due_date );
411: END IF;
412:

Line 420: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'UE_ID : ' || l_ue_id || ' cannot be associated to any Visit_id' );

416: LOOP
417: FETCH associating_visit INTO l_visit_id;
418: IF associating_visit%NOTFOUND THEN
419: IF (l_log_statement >= l_log_current_level) THEN
420: fnd_log.string(l_log_statement,L_DEBUG_KEY, 'UE_ID : ' || l_ue_id || ' cannot be associated to any Visit_id' );
421: END IF;
422: EXIT;
423: END IF;
424: -- Check whether the MR is a parent MR and is already associated or not. If already associated to the same visit id then it is not added.

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

433: l_task_rec(1).unit_effectivity_id := l_ue_id;
434: l_task_rec(1).task_type_code := 'PLANNED';
435: --assign l_ue_id to l_visit_id
436:
437: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
438: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);

Line 438: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);

434: l_task_rec(1).task_type_code := 'PLANNED';
435: --assign l_ue_id to l_visit_id
436:
437: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
438: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
442: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');

Line 439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);

435: --assign l_ue_id to l_visit_id
436:
437: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
438: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
442: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: visit_id--@>'||'l_visit_id');

Line 440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);

436:
437: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
438: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
442: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: visit_id--@>'||'l_visit_id');
444: END IF;

Line 441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);

437: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
438: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
442: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: visit_id--@>'||'l_visit_id');
444: END IF;
445:

Line 442: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');

438: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_api_version--@>'||L_API_VERSION);
439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
442: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: visit_id--@>'||'l_visit_id');
444: END IF;
445:
446: l_return_status := NULL;

Line 443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: visit_id--@>'||'l_visit_id');

439: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_init_msg_list--@>'||Fnd_Api.g_false);
440: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_commit--@>'||Fnd_Api.g_false);
441: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
442: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: p_module_type--@>'||'NULL');
443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Create_PUP_Tasks :: visit_id--@>'||'l_visit_id');
444: END IF;
445:
446: l_return_status := NULL;
447: l_msg_count := 0;

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

458: x_return_status => l_return_status,
459: x_msg_count => l_msg_count,
460: x_msg_data => l_msg_data);
461:
462: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
463: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
464: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
465: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
466: END IF;

Line 463: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);

459: x_msg_count => l_msg_count,
460: x_msg_data => l_msg_data);
461:
462: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
463: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
464: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
465: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
466: END IF;
467:

Line 464: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);

460: x_msg_data => l_msg_data);
461:
462: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
463: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
464: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
465: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
466: END IF;
467:
468: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 465: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);

461:
462: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
463: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_return_status--@>'||l_return_status);
464: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_count--@>'||l_msg_count);
465: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Create_PUP_Tasks :: x_msg_data--@>'||l_msg_data);
466: END IF;
467:
468: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
469: IF (l_log_statement >= l_log_current_level) THEN

Line 470: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while associating Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);

466: END IF;
467:
468: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
469: IF (l_log_statement >= l_log_current_level) THEN
470: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while associating Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);
471: END IF;
472: ELSE
473: IF (l_log_statement >= l_log_current_level) THEN
474: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully associated Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id);

Line 474: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully associated Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id);

470: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while associating Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);
471: END IF;
472: ELSE
473: IF (l_log_statement >= l_log_current_level) THEN
474: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully associated Unit effectivity '||l_ue_id||' to VISIT_ID : ' || l_visit_id);
475: END IF;
476: END IF;
477: EXIT;
478:

Line 482: fnd_log.string(l_log_statement,L_DEBUG_KEY,

478:
479: ELSE
480:
481: IF (l_log_statement >= l_log_current_level) THEN
482: fnd_log.string(l_log_statement,L_DEBUG_KEY,
483: 'UE_ID(Parent MR) ' || l_ue_id || ' is already associated to Visit_id ' || l_visit_id);
484: END IF;
485: END IF;
486:

Line 496: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Snapshot Id : ' || p_snapshot_id);

492: END LOOP; -- MC_ID loop ends
493: CLOSE get_mc_ids;
494: ELSE
495: IF (l_log_statement >= l_log_current_level) THEN
496: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Snapshot Id : ' || p_snapshot_id);
497: END IF;
498: Fnd_Message.SET_NAME('AHL','AHL_AVF_INVALID_SNAPSHOT');
499: Fnd_Msg_Pub.ADD;
500: RAISE Fnd_Api.G_EXC_ERROR;

Line 505: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Paramters ');

501: END IF;
502: ELSE
503: -- The input flag is not valid. Need to raise exception
504: IF (l_log_statement >= l_log_current_level) THEN
505: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Paramters ');
506: END IF;
507: Fnd_Message.SET_NAME('AHL','AHL_PAGE_PARAMETERS_INVALID');
508: Fnd_Msg_Pub.ADD;
509: RAISE Fnd_Api.G_EXC_ERROR;

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

509: RAISE Fnd_Api.G_EXC_ERROR;
510: END IF; -- Valid Input parameters check ends
511:
512: -------------------- finish --------------------------
513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
514: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_encoded--@>'||Fnd_Api.g_false);
515: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_count--@>'||x_msg_count);
516: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_data--@>'||x_msg_data);
517: END IF;

Line 514: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_encoded--@>'||Fnd_Api.g_false);

510: END IF; -- Valid Input parameters check ends
511:
512: -------------------- finish --------------------------
513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
514: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_encoded--@>'||Fnd_Api.g_false);
515: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_count--@>'||x_msg_count);
516: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_data--@>'||x_msg_data);
517: END IF;
518: Fnd_Msg_Pub.count_and_get (

Line 515: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_count--@>'||x_msg_count);

511:
512: -------------------- finish --------------------------
513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
514: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_encoded--@>'||Fnd_Api.g_false);
515: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_count--@>'||x_msg_count);
516: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_data--@>'||x_msg_data);
517: END IF;
518: Fnd_Msg_Pub.count_and_get (
519: p_encoded => Fnd_Api.g_false,

Line 516: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_data--@>'||x_msg_data);

512: -------------------- finish --------------------------
513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
514: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_encoded--@>'||Fnd_Api.g_false);
515: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_count--@>'||x_msg_count);
516: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Add_Planned_MRs :: p_data--@>'||x_msg_data);
517: END IF;
518: Fnd_Msg_Pub.count_and_get (
519: p_encoded => Fnd_Api.g_false,
520: p_count => x_msg_count,

Line 526: fnd_log.string(l_log_procedure,

522: );
523:
524:
525: IF (l_log_procedure >= l_log_current_level) THEN
526: fnd_log.string(l_log_procedure,
527: L_DEBUG_KEY ||'.end',
528: 'At the end of PL SQL Procedure.');
529: END IF;
530:

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

630: -- Save Point Declaration
631: SAVEPOINT Save_Cancel_visits;
632:
633: --------------------- Initialize -----------------------
634: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
635: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY||'.begin','At the start of PLSQL procedure');
636: END IF;
637:
638: -- Printing The input Parameters

Line 635: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY||'.begin','At the start of PLSQL procedure');

631: SAVEPOINT Save_Cancel_visits;
632:
633: --------------------- Initialize -----------------------
634: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
635: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY||'.begin','At the start of PLSQL procedure');
636: END IF;
637:
638: -- Printing The input Parameters
639: IF (l_log_statement >= l_log_current_level) THEN

Line 640: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' p_api_version => ' || p_api_version ||

636: END IF;
637:
638: -- Printing The input Parameters
639: IF (l_log_statement >= l_log_current_level) THEN
640: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' p_api_version => ' || p_api_version ||
641: ' , p_init_msg_list => ' || p_init_msg_list ||
642: ' , p_commit => ' || p_commit ||
643: ' , p_validation_level => ' || p_validation_level ||
644: ' , p_snapshot_id => ' || p_snapshot_id);

Line 663: fnd_log.string(l_log_procedure,

659: x_return_status := Fnd_Api.g_ret_sts_success;
660:
661: ----------------------------------------------------------
662: IF (l_log_procedure >= l_log_current_level) THEN
663: fnd_log.string(l_log_procedure,
664: L_DEBUG_KEY ||'.begin',
665: 'At the start of PL SQL procedure.');
666: END IF;
667:

Line 679: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Snapshot Id = ' || p_snapshot_id);

675:
676: IF (l_valid_flag = 'X') THEN
677: -- Getting the VISIT_IDs of the snapshot. Number of VISIT_IDs might be retrieved.
678: IF (l_log_statement >= l_log_current_level) THEN
679: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Snapshot Id = ' || p_snapshot_id);
680: END IF;
681:
682: OPEN get_visit_ids(p_snapshot_id);
683: LOOP

Line 688: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' VISIT_ID : ' || l_visit_id || ' Object Version No: ' || l_obj_ver_no);

684: FETCH get_visit_ids into l_visit_id,l_obj_ver_no;
685: EXIT WHEN get_visit_ids%NOTFOUND;
686:
687: IF (l_log_statement >= l_log_current_level) THEN
688: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' VISIT_ID : ' || l_visit_id || ' Object Version No: ' || l_obj_ver_no);
689: END IF;
690:
691: -- Calling the procedure to cancel the visit.
692:

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

689: END IF;
690:
691: -- Calling the procedure to cancel the visit.
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_api_version--@>'||L_API_VERSION);
695: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_init_msg_list--@>'||Fnd_Api.g_false);
696: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_commit--@>'||Fnd_Api.g_false);
697: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);

Line 694: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_api_version--@>'||L_API_VERSION);

690:
691: -- Calling the procedure to cancel the visit.
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_api_version--@>'||L_API_VERSION);
695: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_init_msg_list--@>'||Fnd_Api.g_false);
696: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_commit--@>'||Fnd_Api.g_false);
697: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
698: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_visit_id--@>'||l_visit_id);

Line 695: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_init_msg_list--@>'||Fnd_Api.g_false);

691: -- Calling the procedure to cancel the visit.
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_api_version--@>'||L_API_VERSION);
695: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_init_msg_list--@>'||Fnd_Api.g_false);
696: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_commit--@>'||Fnd_Api.g_false);
697: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
698: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_visit_id--@>'||l_visit_id);
699: END IF;

Line 696: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_commit--@>'||Fnd_Api.g_false);

692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_api_version--@>'||L_API_VERSION);
695: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_init_msg_list--@>'||Fnd_Api.g_false);
696: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_commit--@>'||Fnd_Api.g_false);
697: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
698: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_visit_id--@>'||l_visit_id);
699: END IF;
700:

Line 697: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);

693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
694: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_api_version--@>'||L_API_VERSION);
695: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_init_msg_list--@>'||Fnd_Api.g_false);
696: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_commit--@>'||Fnd_Api.g_false);
697: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
698: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_visit_id--@>'||l_visit_id);
699: END IF;
700:
701: l_return_status := NULL;

Line 698: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_visit_id--@>'||l_visit_id);

694: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_api_version--@>'||L_API_VERSION);
695: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_init_msg_list--@>'||Fnd_Api.g_false);
696: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_commit--@>'||Fnd_Api.g_false);
697: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_validation_level--@>'||Fnd_Api.g_valid_level_full);
698: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Calling Delete_visit :: p_visit_id--@>'||l_visit_id);
699: END IF;
700:
701: l_return_status := NULL;
702: l_msg_count := 0;

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

713: x_msg_count => l_msg_count,
714: x_msg_data => l_msg_data);
715:
716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_return_status--@>'||l_return_status);
719: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_count--@>'||l_msg_count);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_data--@>'||l_msg_data);
721: END IF;

Line 718: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_return_status--@>'||l_return_status);

714: x_msg_data => l_msg_data);
715:
716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_return_status--@>'||l_return_status);
719: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_count--@>'||l_msg_count);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_data--@>'||l_msg_data);
721: END IF;
722:

Line 719: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_count--@>'||l_msg_count);

715:
716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_return_status--@>'||l_return_status);
719: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_count--@>'||l_msg_count);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_data--@>'||l_msg_data);
721: END IF;
722:
723: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 720: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_data--@>'||l_msg_data);

716:
717: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
718: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_return_status--@>'||l_return_status);
719: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_count--@>'||l_msg_count);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Delete_visit :: x_msg_data--@>'||l_msg_data);
721: END IF;
722:
723: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
724: IF (l_log_statement >= l_log_current_level) THEN

Line 725: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while cancelling VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);

721: END IF;
722:
723: IF nvl(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
724: IF (l_log_statement >= l_log_current_level) THEN
725: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while cancelling VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);
726: END IF;
727: ELSE
728: IF (l_log_statement >= l_log_current_level) THEN
729: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully cancelled VISIT_ID : ' || l_visit_id);

Line 729: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully cancelled VISIT_ID : ' || l_visit_id);

725: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Error Occured while cancelling VISIT_ID : ' || l_visit_id || ' with x-return-status:' || l_return_status);
726: END IF;
727: ELSE
728: IF (l_log_statement >= l_log_current_level) THEN
729: FND_LOG.string(l_log_statement, L_DEBUG_KEY, ' Successfully cancelled VISIT_ID : ' || l_visit_id);
730: END IF;
731: END IF;
732:
733: END LOOP;

Line 737: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Snapshot Id : ' || p_snapshot_id);

733: END LOOP;
734: close get_visit_ids;
735: ELSE
736: IF (l_log_statement >= l_log_current_level) THEN
737: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Invalid Snapshot Id : ' || p_snapshot_id);
738: END IF;
739: Fnd_Message.SET_NAME('AHL','AHL_AVF_INVALID_SNAPSHOT');
740: Fnd_Msg_Pub.ADD;
741: RAISE Fnd_Api.G_EXC_ERROR;

Line 746: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Null Paramter ');

742: END IF;
743:
744: ELSE
745: IF (l_log_statement >= l_log_current_level) THEN
746: fnd_log.string(l_log_statement,L_DEBUG_KEY, ' Null Paramter ');
747: END IF;
748: Fnd_Message.SET_NAME('AHL','AHL_PAGE_PARAMETERS_INVALID');
749: Fnd_Msg_Pub.ADD;
750: RAISE Fnd_Api.G_EXC_ERROR;

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

749: Fnd_Msg_Pub.ADD;
750: RAISE Fnd_Api.G_EXC_ERROR;
751: END IF;
752: -------------------- finish --------------------------
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
754: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_encoded--@>'||Fnd_Api.g_false);
755: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_count--@>'||x_msg_count);
756: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_data--@>'||x_msg_data);
757: END IF;

Line 754: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_encoded--@>'||Fnd_Api.g_false);

750: RAISE Fnd_Api.G_EXC_ERROR;
751: END IF;
752: -------------------- finish --------------------------
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
754: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_encoded--@>'||Fnd_Api.g_false);
755: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_count--@>'||x_msg_count);
756: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_data--@>'||x_msg_data);
757: END IF;
758: Fnd_Msg_Pub.count_and_get (

Line 755: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_count--@>'||x_msg_count);

751: END IF;
752: -------------------- finish --------------------------
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
754: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_encoded--@>'||Fnd_Api.g_false);
755: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_count--@>'||x_msg_count);
756: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_data--@>'||x_msg_data);
757: END IF;
758: Fnd_Msg_Pub.count_and_get (
759: p_encoded => Fnd_Api.g_false,

Line 756: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_data--@>'||x_msg_data);

752: -------------------- finish --------------------------
753: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
754: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_encoded--@>'||Fnd_Api.g_false);
755: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_count--@>'||x_msg_count);
756: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Return Cancel_Visits :: p_data--@>'||x_msg_data);
757: END IF;
758: Fnd_Msg_Pub.count_and_get (
759: p_encoded => Fnd_Api.g_false,
760: p_count => x_msg_count,

Line 766: fnd_log.string(l_log_procedure,

762: );
763:
764:
765: IF (l_log_procedure >= l_log_current_level) THEN
766: fnd_log.string(l_log_procedure,
767: L_DEBUG_KEY ||'.end',
768: 'At the end of PL SQL Procedure.');
769: END IF;
770:

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

879: l_mr_header_dets get_mr_header_details%RowType;
880:
881: BEGIN
882: --------------------- Initialize -----------------------
883: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
884: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
885: END IF;
886:
887: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 884: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

880:
881: BEGIN
882: --------------------- Initialize -----------------------
883: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
884: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
885: END IF;
886:
887: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
888: Fnd_Msg_Pub.initialize;

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

898: END IF;
899: x_return_status := Fnd_Api.g_ret_sts_success;
900:
901: ---------------------- Validate MR Header ID ------------------------
902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
903: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validating MR Header ID');
904: END IF;
905:
906: --Validate MR

Line 903: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validating MR Header ID');

899: x_return_status := Fnd_Api.g_ret_sts_success;
900:
901: ---------------------- Validate MR Header ID ------------------------
902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
903: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validating MR Header ID');
904: END IF;
905:
906: --Validate MR
907: OPEN get_mr_header_details(p_mr_header_id);

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

916: RAISE Fnd_Api.G_EXC_ERROR;
917:
918: END IF;
919:
920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
921: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_mr_header_id--@>'||p_mr_header_id);
922: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_mr_header_id--@>'||l_mr_header_id);
923: END IF;
924:

Line 921: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_mr_header_id--@>'||p_mr_header_id);

917:
918: END IF;
919:
920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
921: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_mr_header_id--@>'||p_mr_header_id);
922: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_mr_header_id--@>'||l_mr_header_id);
923: END IF;
924:
925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 922: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_mr_header_id--@>'||l_mr_header_id);

918: END IF;
919:
920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
921: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_mr_header_id--@>'||p_mr_header_id);
922: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_mr_header_id--@>'||l_mr_header_id);
923: END IF;
924:
925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
926: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated MR Header ID');

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

921: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_mr_header_id--@>'||p_mr_header_id);
922: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_mr_header_id--@>'||l_mr_header_id);
923: END IF;
924:
925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
926: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated MR Header ID');
927: END IF;
928:
929: ---------------------- Validate Operating Organization ------------------------

Line 926: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated MR Header ID');

922: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_mr_header_id--@>'||l_mr_header_id);
923: END IF;
924:
925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
926: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated MR Header ID');
927: END IF;
928:
929: ---------------------- Validate Operating Organization ------------------------
930: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

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

926: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated MR Header ID');
927: END IF;
928:
929: ---------------------- Validate Operating Organization ------------------------
930: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
931: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validating Operating Organization');
932: END IF;
933:
934: --Validate Organization

Line 931: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validating Operating Organization');

927: END IF;
928:
929: ---------------------- Validate Operating Organization ------------------------
930: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
931: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validating Operating Organization');
932: END IF;
933:
934: --Validate Organization
935: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id

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

938: x_organization_id => l_operating_org_id,
939: x_return_status => l_return_status,
940: x_error_msg_code => l_msg_data);
941:
942: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
943: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_operating_org_id--@>'||p_operating_org_id);
944: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_operating_org_id--@>'||l_operating_org_id);
945: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_return_status--@>'||l_return_status);
946: END IF;

Line 943: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_operating_org_id--@>'||p_operating_org_id);

939: x_return_status => l_return_status,
940: x_error_msg_code => l_msg_data);
941:
942: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
943: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_operating_org_id--@>'||p_operating_org_id);
944: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_operating_org_id--@>'||l_operating_org_id);
945: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_return_status--@>'||l_return_status);
946: END IF;
947:

Line 944: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_operating_org_id--@>'||l_operating_org_id);

940: x_error_msg_code => l_msg_data);
941:
942: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
943: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_operating_org_id--@>'||p_operating_org_id);
944: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_operating_org_id--@>'||l_operating_org_id);
945: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_return_status--@>'||l_return_status);
946: END IF;
947:
948: IF NVL(l_return_status,'x') <> 'S' THEN

Line 945: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_return_status--@>'||l_return_status);

941:
942: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
943: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: p_operating_org_id--@>'||p_operating_org_id);
944: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_operating_org_id--@>'||l_operating_org_id);
945: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Org Validation :: l_return_status--@>'||l_return_status);
946: END IF;
947:
948: IF NVL(l_return_status,'x') <> 'S' THEN
949: Fnd_Message.SET_NAME('AHL','AHL_VWP_ORG_NOT_EXISTS');

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

950: Fnd_Msg_Pub.ADD;
951: RAISE Fnd_Api.G_EXC_ERROR;
952: END IF;
953:
954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
955: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated Operating Organization');
956: END IF;
957:
958: x_maintenance_org_id := NULL;

Line 955: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated Operating Organization');

951: RAISE Fnd_Api.G_EXC_ERROR;
952: END IF;
953:
954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
955: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validated Operating Organization');
956: END IF;
957:
958: x_maintenance_org_id := NULL;
959: x_maintenance_dept_id := NULL;

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

966: --Set OUT variables
967: x_maintenance_org_id := l_oper_org_dets.MAINTENANCE_ORG_ID;
968: x_maintenance_dept_id := l_oper_org_dets.MAINTENANCE_DEPT_ID;
969:
970: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
971: fnd_log.string(fnd_log.level_statement,L_DEBUG,'x_maintenance_org_id ** x_maintenance_dept_id ='||x_maintenance_org_id||' ** '||x_maintenance_dept_id);
972: END IF;
973:
974: --Commented out to leave the null situation for caller to handle :: PRAKKUM :: Bug 13589168 :: 01/16/2012

Line 971: fnd_log.string(fnd_log.level_statement,L_DEBUG,'x_maintenance_org_id x_maintenance_dept_id ='||x_maintenance_org_id||' '||x_maintenance_dept_id);

967: x_maintenance_org_id := l_oper_org_dets.MAINTENANCE_ORG_ID;
968: x_maintenance_dept_id := l_oper_org_dets.MAINTENANCE_DEPT_ID;
969:
970: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
971: fnd_log.string(fnd_log.level_statement,L_DEBUG,'x_maintenance_org_id ** x_maintenance_dept_id ='||x_maintenance_org_id||' ** '||x_maintenance_dept_id);
972: END IF;
973:
974: --Commented out to leave the null situation for caller to handle :: PRAKKUM :: Bug 13589168 :: 01/16/2012
975: /*

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

989: p_count => x_msg_count,
990: p_data => x_msg_data
991: );
992:
993: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
994: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
995: END IF;
996:
997: EXCEPTION

Line 994: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');

990: p_data => x_msg_data
991: );
992:
993: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
994: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
995: END IF;
996:
997: EXCEPTION
998: WHEN Fnd_Api.g_exc_error THEN

Line 1177: fnd_log.string

1173:
1174: BEGIN
1175:
1176: IF (l_log_procedure >= l_log_current_level)THEN
1177: fnd_log.string
1178: (
1179: l_log_procedure,
1180: 'ahl.plsql.AHL_AVF_PRIM_VSTS_PVT.Create_Primary_Visits.begin',
1181: 'At the start of PLSQL procedure, snapshot ID : ' || p_snapshot_id

Line 1210: IF (fnd_log.level_exception >= l_log_current_level)THEN

1206: IF(p_snapshot_id IS NULL OR p_snapshot_id = FND_API.G_MISS_NUM) THEN
1207: FND_MESSAGE.Set_Name('AHL','AHL_AVF_SNPSHT_INPUT_MISS');
1208: FND_MSG_PUB.ADD;
1209:
1210: IF (fnd_log.level_exception >= l_log_current_level)THEN
1211: fnd_log.string
1212: (
1213: fnd_log.level_exception,
1214: L_DEBUG_KEY,

Line 1211: fnd_log.string

1207: FND_MESSAGE.Set_Name('AHL','AHL_AVF_SNPSHT_INPUT_MISS');
1208: FND_MSG_PUB.ADD;
1209:
1210: IF (fnd_log.level_exception >= l_log_current_level)THEN
1211: fnd_log.string
1212: (
1213: fnd_log.level_exception,
1214: L_DEBUG_KEY,
1215: 'Snapshot id is mandatory but found null in input '

Line 1213: fnd_log.level_exception,

1209:
1210: IF (fnd_log.level_exception >= l_log_current_level)THEN
1211: fnd_log.string
1212: (
1213: fnd_log.level_exception,
1214: L_DEBUG_KEY,
1215: 'Snapshot id is mandatory but found null in input '
1216: );
1217: END IF;

Line 1228: IF (fnd_log.level_exception >= l_log_current_level)THEN

1224: CLOSE get_dates;
1225: FND_MESSAGE.Set_Name('AHL','AHL_AVF_SNPSHT_INPUT_INVLD');
1226: FND_MSG_PUB.ADD;
1227:
1228: IF (fnd_log.level_exception >= l_log_current_level)THEN
1229: fnd_log.string
1230: (
1231: fnd_log.level_exception,
1232: L_DEBUG_KEY,

Line 1229: fnd_log.string

1225: FND_MESSAGE.Set_Name('AHL','AHL_AVF_SNPSHT_INPUT_INVLD');
1226: FND_MSG_PUB.ADD;
1227:
1228: IF (fnd_log.level_exception >= l_log_current_level)THEN
1229: fnd_log.string
1230: (
1231: fnd_log.level_exception,
1232: L_DEBUG_KEY,
1233: 'Snapshot id is invalid '

Line 1231: fnd_log.level_exception,

1227:
1228: IF (fnd_log.level_exception >= l_log_current_level)THEN
1229: fnd_log.string
1230: (
1231: fnd_log.level_exception,
1232: L_DEBUG_KEY,
1233: 'Snapshot id is invalid '
1234: );
1235: END IF;

Line 1280: fnd_log.string

1276: CLOSE get_ue_operating_org;
1277: IF l_operating_org_id IS NOT NULL THEN
1278: -- Now call Validate_MR_Operating_Org to get the organization and department of the primary visit
1279: IF (l_log_statement >= l_log_current_level) THEN
1280: fnd_log.string
1281: ( l_log_statement,
1282: L_DEBUG_KEY,
1283: 'Before calling Validate_MR_Operating_Org, mr_header_id= '||l_primary_ue_rec.mr_header_id||', operating_org_id= '||l_operating_org_id);
1284: END IF;

Line 1299: fnd_log.string(l_log_statement,

1295: x_msg_count => l_msg_count,
1296: x_msg_data => l_msg_data
1297: );
1298: IF (l_log_statement >= l_log_current_level) THEN
1299: fnd_log.string(l_log_statement,
1300: L_DEBUG_KEY,
1301: 'After calling Validate_MR_Operating_Org l_return_status= '||l_return_status);
1302: END IF;
1303:

Line 1307: fnd_log.string(l_log_statement,

1303:
1304: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1305: x_msg_count := FND_MSG_PUB.count_msg;
1306: IF (l_log_statement >= l_log_current_level) THEN
1307: fnd_log.string(l_log_statement,
1308: L_DEBUG_KEY,
1309: 'Errors from Validate_MR_Operating_Org. Message count: ' || x_msg_count);
1310: END IF;
1311: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1320: fnd_log.string(l_log_statement,

1316: END IF; -- Return Status is not Success
1317:
1318: -- PRAKKUM :: Bug 13589168 :: 01/16/2012 :: START
1319: IF (l_log_statement >= l_log_current_level) THEN
1320: fnd_log.string(l_log_statement,
1321: L_DEBUG_KEY,
1322: 'l_maintenance_org_id ** l_maintenance_dept_id: ' || l_maintenance_org_id || ' ** '|| l_maintenance_dept_id);
1323: END IF;
1324: IF l_maintenance_org_id is NULL or l_maintenance_dept_id is NULL THEN

Line 1375: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');

1371: l_visit_rec.VISIT_CREATE_TYPE := 'PLANNING';
1372:
1373: --PRAKKUM :: 09/03/2012 :: Bug 13797431 -- Added Log Messages
1374: IF (l_log_statement >= l_log_current_level) THEN
1375: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1376: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);

Line 1376: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);

1372:
1373: --PRAKKUM :: 09/03/2012 :: Bug 13797431 -- Added Log Messages
1374: IF (l_log_statement >= l_log_current_level) THEN
1375: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1376: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);

Line 1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);

1373: --PRAKKUM :: 09/03/2012 :: Bug 13797431 -- Added Log Messages
1374: IF (l_log_statement >= l_log_current_level) THEN
1375: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1376: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));

Line 1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);

1374: IF (l_log_statement >= l_log_current_level) THEN
1375: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1376: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));

Line 1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);

1375: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1376: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);

Line 1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);

1376: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);

Line 1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));

1377: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));

Line 1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));

1378: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));

Line 1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);

1379: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1387: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);

Line 1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);

1380: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1387: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1388: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);

Line 1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));

1381: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1387: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1388: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1389: END IF;

Line 1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));

1382: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1387: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1388: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1389: END IF;
1390:

Line 1387: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);

1383: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1387: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1388: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1389: END IF;
1390:
1391: -- Now create the primary visit

Line 1388: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);

1384: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1385: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1386: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1387: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1388: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1389: END IF;
1390:
1391: -- Now create the primary visit
1392: IF (l_log_statement >= l_log_current_level) THEN

Line 1393: fnd_log.string

1389: END IF;
1390:
1391: -- Now create the primary visit
1392: IF (l_log_statement >= l_log_current_level) THEN
1393: fnd_log.string
1394: ( l_log_statement,
1395: L_DEBUG_KEY,
1396: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit');
1397: END IF;

Line 1410: fnd_log.string(l_log_statement,

1406: x_msg_count => l_msg_count,
1407: x_msg_data => l_msg_data
1408: );
1409: IF (l_log_statement >= l_log_current_level) THEN
1410: fnd_log.string(l_log_statement,
1411: L_DEBUG_KEY,
1412: 'After calling Create_Visit l_return_status= '||l_return_status
1413: ||', visit id: '||l_visit_rec.visit_id);
1414: END IF;

Line 1419: fnd_log.string(l_log_statement,

1415:
1416: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1417: x_msg_count := FND_MSG_PUB.count_msg;
1418: IF (l_log_statement >= l_log_current_level) THEN
1419: fnd_log.string(l_log_statement,
1420: L_DEBUG_KEY,
1421: 'Errors from Create_Visit. Message count: ' || x_msg_count);
1422: END IF;
1423: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1440: fnd_log.string

1436: END IF; -- Return Status is not Success
1437:
1438:
1439: IF (l_log_statement >= l_log_current_level) THEN
1440: fnd_log.string
1441: ( l_log_statement,
1442: L_DEBUG_KEY,
1443: 'Before calling AHL_VWP_TASKS_PVT.Create_PUP_Tasks, l_visit_rec.visit_id = '
1444: ||l_visit_rec.visit_id ||', unit_effectivity_id= '||l_primary_ue_rec.unit_effectivity_id);

Line 1461: fnd_log.string(l_log_statement,

1457: x_return_status => l_return_status,
1458: x_msg_count => l_msg_count,
1459: x_msg_data => l_msg_data);
1460: IF (l_log_statement >= l_log_current_level) THEN
1461: fnd_log.string(l_log_statement,
1462: L_DEBUG_KEY,
1463: 'After calling AHL_VWP_TASKS_PVT.Create_PUP_Tasks l_return_status= '||l_return_status);
1464: END IF;
1465:

Line 1469: fnd_log.string(l_log_statement,

1465:
1466: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1467: x_msg_count := FND_MSG_PUB.count_msg;
1468: IF (l_log_statement >= l_log_current_level) THEN
1469: fnd_log.string(l_log_statement,
1470: L_DEBUG_KEY,
1471: 'Errors from Create_PUP_Tasks. Message count: ' || x_msg_count);
1472: END IF;
1473: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1494: fnd_log.string(l_log_statement,

1490: x_msg_count => l_msg_count,
1491: x_msg_data => l_msg_data
1492: );
1493: IF (l_log_statement >= l_log_current_level) THEN
1494: fnd_log.string(l_log_statement,
1495: L_DEBUG_KEY,
1496: 'After calling Add_Planned_MRs l_return_status= '||l_return_status);
1497: END IF;
1498: -- l_return_status = 'V' then number of UEs for the visit is 0.

Line 1502: fnd_log.string(l_log_statement,

1498: -- l_return_status = 'V' then number of UEs for the visit is 0.
1499: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS AND l_return_status <> 'V') THEN
1500: x_msg_count := FND_MSG_PUB.count_msg;
1501: IF (l_log_statement >= l_log_current_level) THEN
1502: fnd_log.string(l_log_statement,
1503: L_DEBUG_KEY,
1504: 'Errors from Add_Planned_MRs. Message count: ' || x_msg_count);
1505: END IF;
1506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1553: fnd_log.string

1549: CLOSE get_ue_operating_org;
1550: IF l_operating_org_id IS NOT NULL THEN
1551: -- Now call Validate_MR_Operating_Org to get the organization and department of the primary visit
1552: IF (l_log_statement >= l_log_current_level) THEN
1553: fnd_log.string
1554: ( l_log_statement,
1555: L_DEBUG_KEY,
1556: 'Before calling Validate_MR_Operating_Org, mr_header_id= '||l_primary_ue_rec.mr_header_id||', operating_org_id= '||l_operating_org_id);
1557: END IF;

Line 1572: fnd_log.string(l_log_statement,

1568: x_msg_count => l_msg_count,
1569: x_msg_data => l_msg_data
1570: );
1571: IF (l_log_statement >= l_log_current_level) THEN
1572: fnd_log.string(l_log_statement,
1573: L_DEBUG_KEY,
1574: 'After calling Validate_MR_Operating_Org l_return_status= '||l_return_status);
1575: END IF;
1576:

Line 1580: fnd_log.string(l_log_statement,

1576:
1577: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1578: x_msg_count := FND_MSG_PUB.count_msg;
1579: IF (l_log_statement >= l_log_current_level) THEN
1580: fnd_log.string(l_log_statement,
1581: L_DEBUG_KEY,
1582: 'Errors from Validate_MR_Operating_Org. Message count: ' || x_msg_count);
1583: END IF;
1584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1593: fnd_log.string(l_log_statement,

1589: END IF; -- Return Status is not Success
1590:
1591: -- PRAKKUM :: Bug 13589168 :: 01/16/2012 :: START
1592: IF (l_log_statement >= l_log_current_level) THEN
1593: fnd_log.string(l_log_statement,
1594: L_DEBUG_KEY,
1595: 'l_maintenance_org_id ** l_maintenance_dept_id: ' || l_maintenance_org_id || ' ** '|| l_maintenance_dept_id);
1596: END IF;
1597: IF l_maintenance_org_id is NULL or l_maintenance_dept_id is NULL THEN

Line 1647: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');

1643: l_visit_rec.VISIT_CREATE_TYPE := 'PLANNING';
1644:
1645: --PRAKKUM :: 09/03/2012 :: Bug 13797431 -- Added Log Messages
1646: IF (l_log_statement >= l_log_current_level) THEN
1647: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1648: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);

Line 1648: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);

1644:
1645: --PRAKKUM :: 09/03/2012 :: Bug 13797431 -- Added Log Messages
1646: IF (l_log_statement >= l_log_current_level) THEN
1647: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1648: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);

Line 1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);

1645: --PRAKKUM :: 09/03/2012 :: Bug 13797431 -- Added Log Messages
1646: IF (l_log_statement >= l_log_current_level) THEN
1647: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1648: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));

Line 1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);

1646: IF (l_log_statement >= l_log_current_level) THEN
1647: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1648: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));

Line 1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);

1647: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Visit Details ..');
1648: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);

Line 1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);

1648: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_TYPE_CODE --@>'|| l_visit_rec.VISIT_TYPE_CODE);
1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);

Line 1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));

1649: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.VISIT_NAME --@>'|| l_visit_rec.VISIT_NAME);
1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));

Line 1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));

1650: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.UNIT_NAME --@>'|| l_visit_rec.UNIT_NAME);
1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));

Line 1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);

1651: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.ORGANIZATION_ID --@>'|| l_visit_rec.ORGANIZATION_ID);
1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1659: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);

Line 1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);

1652: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.DEPARTMENT_ID --@>'|| l_visit_rec.DEPARTMENT_ID);
1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1659: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1660: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);

Line 1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));

1653: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed Start Date --@>'|| to_char(l_start_date,'DD-MON-YY hh24:mi:ss'));
1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1659: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1660: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1661: END IF;

Line 1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));

1654: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_DATE --@>'|| to_char(l_visit_rec.START_DATE,'DD-MON-YY hh24:mi:ss'));
1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1659: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1660: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1661: END IF;
1662:

Line 1659: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);

1655: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_HOUR --@>'|| l_visit_rec.START_HOUR);
1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1659: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1660: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1661: END IF;
1662:
1663: IF (l_log_statement >= l_log_current_level) THEN

Line 1660: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);

1656: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.START_MIN --@>'|| l_visit_rec.START_MIN);
1657: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'Computed End Date --@>'|| to_char(l_end_date,'DD-MON-YY hh24:mi:ss'));
1658: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_DATE --@>'|| to_char(l_visit_rec.PLAN_END_DATE,'DD-MON-YY hh24:mi:ss'));
1659: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_HOUR --@>'|| l_visit_rec.PLAN_END_HOUR);
1660: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1661: END IF;
1662:
1663: IF (l_log_statement >= l_log_current_level) THEN
1664: fnd_log.string

Line 1664: fnd_log.string

1660: fnd_log.string( l_log_statement, L_DEBUG_KEY, 'l_visit_rec.PLAN_END_MIN --@>'|| l_visit_rec.PLAN_END_MIN);
1661: END IF;
1662:
1663: IF (l_log_statement >= l_log_current_level) THEN
1664: fnd_log.string
1665: ( l_log_statement,
1666: L_DEBUG_KEY,
1667: 'Before calling AHL_VWP_VISITS_PVT.Create_Visit');
1668: END IF;

Line 1681: fnd_log.string(l_log_statement,

1677: x_msg_count => l_msg_count,
1678: x_msg_data => l_msg_data
1679: );
1680: IF (l_log_statement >= l_log_current_level) THEN
1681: fnd_log.string(l_log_statement,
1682: L_DEBUG_KEY,
1683: 'After calling Create_Visit l_return_status= '||l_return_status
1684: ||', visit id: '||l_visit_rec.visit_id);
1685: END IF;

Line 1690: fnd_log.string(l_log_statement,

1686:
1687: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1688: x_msg_count := FND_MSG_PUB.count_msg;
1689: IF (l_log_statement >= l_log_current_level) THEN
1690: fnd_log.string(l_log_statement,
1691: L_DEBUG_KEY,
1692: 'Errors from Create_Visit. Message count: ' || x_msg_count);
1693: END IF;
1694: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1710: fnd_log.string

1706: -- End of logging
1707: END IF; -- Return Status is not Success
1708:
1709: IF (l_log_statement >= l_log_current_level) THEN
1710: fnd_log.string
1711: ( l_log_statement,
1712: L_DEBUG_KEY,
1713: 'Before calling AHL_VWP_TASKS_PVT.Create_PUP_Tasks, l_visit_rec.visit_id = '
1714: ||l_visit_rec.visit_id ||', unit_effectivity_id= '||l_primary_ue_rec.unit_effectivity_id);

Line 1731: fnd_log.string(l_log_statement,

1727: x_return_status => l_return_status,
1728: x_msg_count => l_msg_count,
1729: x_msg_data => l_msg_data);
1730: IF (l_log_statement >= l_log_current_level) THEN
1731: fnd_log.string(l_log_statement,
1732: L_DEBUG_KEY,
1733: 'After calling AHL_VWP_TASKS_PVT.Create_PUP_Tasks l_return_status= '||l_return_status);
1734: END IF;
1735:

Line 1739: fnd_log.string(l_log_statement,

1735:
1736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1737: x_msg_count := FND_MSG_PUB.count_msg;
1738: IF (l_log_statement >= l_log_current_level) THEN
1739: fnd_log.string(l_log_statement,
1740: L_DEBUG_KEY,
1741: 'Errors from Create_PUP_Tasks. Message count: ' || x_msg_count);
1742: END IF;
1743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1764: fnd_log.string(l_log_statement,

1760: x_msg_count => l_msg_count,
1761: x_msg_data => l_msg_data
1762: );
1763: IF (l_log_statement >= l_log_current_level) THEN
1764: fnd_log.string(l_log_statement,
1765: L_DEBUG_KEY,
1766: 'After calling Add_Planned_MRs l_return_status= '||l_return_status);
1767: END IF;
1768: -- l_return_status = 'V' then number of UEs for the visit is 0.

Line 1772: fnd_log.string(l_log_statement,

1768: -- l_return_status = 'V' then number of UEs for the visit is 0.
1769: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS AND l_return_status <> 'V') THEN
1770: x_msg_count := FND_MSG_PUB.count_msg;
1771: IF (l_log_statement >= l_log_current_level) THEN
1772: fnd_log.string(l_log_statement,
1773: L_DEBUG_KEY,
1774: 'Errors from Add_Planned_MRs. Message count: ' || x_msg_count);
1775: END IF;
1776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1815: fnd_log.string

1811: p_data => x_msg_data
1812: );
1813:
1814: IF (l_log_procedure >= l_log_current_level)THEN
1815: fnd_log.string
1816: (
1817: l_log_procedure,
1818: 'ahl.plsql.AHL_VWP_PRIM_VSTS_PVT.Create_Primary_Visits.end',
1819: 'At the end of PLSQL procedure'