eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_TIMES_PVT dependencies on FND_LOG

Line 42: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

38: G_STAGES_TBL Number_Tbl_Type; -- Stores the stage offsets for visit
39: ------------------------------------
40: -- Common constants and variables --
41: ------------------------------------
42: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
43: l_log_statement NUMBER := fnd_log.level_statement;
44: l_log_procedure NUMBER := fnd_log.level_procedure;
45: l_log_error NUMBER := fnd_log.level_error;
46: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 43: l_log_statement NUMBER := fnd_log.level_statement;

39: ------------------------------------
40: -- Common constants and variables --
41: ------------------------------------
42: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
43: l_log_statement NUMBER := fnd_log.level_statement;
44: l_log_procedure NUMBER := fnd_log.level_procedure;
45: l_log_error NUMBER := fnd_log.level_error;
46: l_log_unexpected NUMBER := fnd_log.level_unexpected;
47: -----------------------------------------------------------------------

Line 44: l_log_procedure NUMBER := fnd_log.level_procedure;

40: -- Common constants and variables --
41: ------------------------------------
42: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
43: l_log_statement NUMBER := fnd_log.level_statement;
44: l_log_procedure NUMBER := fnd_log.level_procedure;
45: l_log_error NUMBER := fnd_log.level_error;
46: l_log_unexpected NUMBER := fnd_log.level_unexpected;
47: -----------------------------------------------------------------------
48: /*procedure adbug(p_msg_txt in varchar2 , p_message in date)

Line 45: l_log_error NUMBER := fnd_log.level_error;

41: ------------------------------------
42: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
43: l_log_statement NUMBER := fnd_log.level_statement;
44: l_log_procedure NUMBER := fnd_log.level_procedure;
45: l_log_error NUMBER := fnd_log.level_error;
46: l_log_unexpected NUMBER := fnd_log.level_unexpected;
47: -----------------------------------------------------------------------
48: /*procedure adbug(p_msg_txt in varchar2 , p_message in date)
49: is

Line 46: l_log_unexpected NUMBER := fnd_log.level_unexpected;

42: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
43: l_log_statement NUMBER := fnd_log.level_statement;
44: l_log_procedure NUMBER := fnd_log.level_procedure;
45: l_log_error NUMBER := fnd_log.level_error;
46: l_log_unexpected NUMBER := fnd_log.level_unexpected;
47: -----------------------------------------------------------------------
48: /*procedure adbug(p_msg_txt in varchar2 , p_message in date)
49: is
50: begin

Line 149: fnd_log.string(l_log_procedure,

145: --
146: BEGIN
147:
148: IF (l_log_procedure >= l_log_current_level) THEN
149: fnd_log.string(l_log_procedure,
150: L_DEBUG_KEY ||'.begin',
151: 'At the start of PL SQL function. Visit Id = ' || p_visit_id);
152: END IF;
153:

Line 164: fnd_log.string(l_log_procedure,

160: OPEN get_actual_start_date_csr (p_visit_id);
161: FETCH get_actual_start_date_csr INTO l_actual_start_date;
162: CLOSE get_actual_start_date_csr;
163: IF (l_log_procedure >= l_log_current_level) THEN
164: fnd_log.string(l_log_procedure,
165: L_DEBUG_KEY ||'.end',
166: 'At the end of PL SQL function. Visit Start Date = ' || l_actual_start_date);
167: END IF;
168: RETURN l_actual_start_date;

Line 173: fnd_log.string(l_log_procedure,

169:
170: -- Planning/Released/Partially Released/Cancelled
171: ELSE
172: IF (l_log_procedure >= l_log_current_level) THEN
173: fnd_log.string(l_log_procedure,
174: L_DEBUG_KEY ||'.end',
175: 'At the end of PL SQL function. Visit Start Date = ' || c_visit_rec.START_DATE_TIME);
176: END IF;
177: RETURN c_visit_rec.START_DATE_TIME;

Line 262: fnd_log.string(l_log_procedure,

258: --
259: BEGIN
260:
261: IF (l_log_procedure >= l_log_current_level) THEN
262: fnd_log.string(l_log_procedure,
263: L_DEBUG_KEY ||'.begin',
264: 'At the start of PL SQL function. Visit Id = ' || p_visit_id ||
265: ', p_use_actuals = ' || p_use_actuals);
266: END IF;

Line 473: fnd_log.string(l_log_procedure,

469:
470: SAVEPOINT calculate_task_Times_pvt;
471:
472: IF (l_log_procedure >= l_log_current_level) THEN
473: fnd_log.string(l_log_procedure,
474: L_DEBUG_KEY ||'.begin',
475: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
476: END IF;
477:

Line 611: fnd_log.string(l_log_procedure,

607: p_encoded => Fnd_Api.g_false
608: );
609:
610: IF (l_log_procedure >= l_log_current_level) THEN
611: fnd_log.string(l_log_procedure,
612: L_DEBUG_KEY ||'.end',
613: 'At the end of PL SQL procedure. RETURN Status = ' || x_return_status);
614: END IF;
615:

Line 702: fnd_log.string(l_log_procedure,

698:
699: SAVEPOINT Adjust_Task_Times_pvt;
700:
701: IF (l_log_procedure >= l_log_current_level) THEN
702: fnd_log.string(l_log_procedure,
703: L_DEBUG_KEY ||'.begin',
704: 'At the start of PL SQL procedure. Task Id = ' || p_task_id);
705: END IF;
706:

Line 770: fnd_log.string(l_log_procedure,

766: p_encoded => Fnd_Api.g_false
767: );
768:
769: IF (l_log_procedure >= l_log_current_level) THEN
770: fnd_log.string(l_log_procedure,
771: L_DEBUG_KEY ||'.end',
772: 'At the end of PL SQL procedure. RETURN Status = ' || x_return_status);
773: END IF;
774:

Line 856: fnd_log.string(l_log_procedure,

852: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
853: --
854: BEGIN
855: IF (l_log_procedure >= l_log_current_level) THEN
856: fnd_log.string(l_log_procedure,
857: L_DEBUG_KEY ||'.begin',
858: 'At the start of PL SQL procedure. Visit Task Id = ' || p_task_id);
859: END IF;
860:

Line 904: fnd_log.string(l_log_statement,

900:
901: --4. Now derive the end date
902: l_end_date := compute_date(l_start_date, l_task_dept_id, l_task_duration);
903: IF (l_log_statement >= l_log_current_level) THEN
904: fnd_log.string(l_log_statement,
905: L_DEBUG_KEY,
906: 'Start Date = ' || l_start_date ||
907: '. End Date = ' || l_end_date);
908: END IF;

Line 931: fnd_log.string(l_log_statement,

927: LOOP
928: FETCH get_child_dependency_csr INTO l_child_task_id;
929: EXIT WHEN get_child_dependency_csr%NOTFOUND;
930: IF (l_log_statement >= l_log_current_level) THEN
931: fnd_log.string(l_log_statement,
932: L_DEBUG_KEY,
933: 'Calling child task: ' || l_child_task_id);
934: END IF;
935: Adjust_Task_Times_Internal(l_child_task_id);

Line 945: fnd_log.string(l_log_procedure,

941: END IF; --end found
942: CLOSE get_task_data_csr;
943:
944: IF (l_log_procedure >= l_log_current_level) THEN
945: fnd_log.string(l_log_procedure,
946: L_DEBUG_KEY ||'.end',
947: 'At the end of PL SQL procedure.');
948: END IF;
949:

Line 999: fnd_log.string(l_log_procedure,

995: BEGIN
996: SAVEPOINT Calculate_Times_for_dept_pvt;
997:
998: IF (l_log_procedure >= l_log_current_level) THEN
999: fnd_log.string(l_log_procedure,
1000: L_DEBUG_KEY ||'.begin',
1001: 'At the start of PL SQL procedure. Dept Id = ' || p_dept_id);
1002: END IF;
1003:

Line 1024: fnd_log.string(l_log_statement,

1020: FETCH get_all_visits_csr INTO l_visit_id;
1021: EXIT WHEN get_all_visits_csr%NOTFOUND;
1022:
1023: IF (l_log_statement >= l_log_current_level) THEN
1024: fnd_log.string(l_log_statement,
1025: L_DEBUG_KEY,
1026: 'Before calling CALCULATE_TASK_TIMES.');
1027: END IF;
1028:

Line 1039: fnd_log.string(l_log_statement,

1035: x_msg_data => x_msg_data,
1036: p_visit_id => l_visit_id);
1037:
1038: IF (l_log_statement >= l_log_current_level) THEN
1039: fnd_log.string(l_log_statement,
1040: L_DEBUG_KEY,
1041: 'After calling CALCULATE_TASK_TIMES. RETURN Status = ' ||
1042: x_return_status);
1043: END IF;

Line 1047: fnd_log.string(l_log_statement,

1043: END IF;
1044:
1045: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1046: IF (l_log_statement >= l_log_current_level) THEN
1047: fnd_log.string(l_log_statement,
1048: L_DEBUG_KEY,
1049: 'Errors from CALCULATE_TASK_TIMES. Message count: ' ||
1050: x_msg_count || ', message data: ' || x_msg_data);
1051: END IF;

Line 1075: fnd_log.string(l_log_procedure,

1071: p_encoded => Fnd_Api.g_false
1072: );
1073:
1074: IF (l_log_procedure >= l_log_current_level) THEN
1075: fnd_log.string(l_log_procedure,
1076: L_DEBUG_KEY ||'.end',
1077: 'At the end of PL SQL procedure. RETURN Status = ' || x_return_status);
1078: END IF;
1079:

Line 1166: fnd_log.string(l_log_procedure,

1162: --
1163: BEGIN
1164:
1165: IF (l_log_procedure >= l_log_current_level) THEN
1166: fnd_log.string(l_log_procedure,
1167: L_DEBUG_KEY ||'.begin',
1168: 'At the start of PL SQL function. Start Date = ' || p_start_date ||
1169: ', Department Id = ' || p_dept_id || ', Duration = ' || p_duration);
1170: END IF;

Line 1229: fnd_log.string(l_log_procedure,

1225:
1226: IF (p_duration = 0) THEN
1227: -- If duration is 0, RETURN the adjusted start date.
1228: IF (l_log_procedure >= l_log_current_level) THEN
1229: fnd_log.string(l_log_procedure,
1230: L_DEBUG_KEY ||'.end',
1231: 'At the end of PL SQL function. Start Date = ' || l_start_date);
1232: END IF;
1233: RETURN l_start_date;

Line 1316: fnd_log.string(l_log_procedure,

1312: END LOOP;
1313:
1314: --RETURN the derived end date.
1315: IF (l_log_procedure >= l_log_current_level) THEN
1316: fnd_log.string(l_log_procedure,
1317: L_DEBUG_KEY ||'.end',
1318: 'At the end of PL SQL function. End Date = ' || l_end_date);
1319: END IF;
1320: RETURN l_end_date;

Line 1363: fnd_log.string(l_log_procedure,

1359: --
1360: BEGIN
1361:
1362: IF (l_log_procedure >= l_log_current_level) THEN
1363: fnd_log.string(l_log_procedure,
1364: L_DEBUG_KEY ||'.begin',
1365: 'At the start of PL SQL procedure. Department Id = ' || p_department_id);
1366: END IF;
1367: -- Get the department informations

Line 1393: fnd_log.string(l_log_procedure,

1389: END LOOP;
1390: CLOSE l_exceptions_csr;
1391:
1392: IF (l_log_procedure >= l_log_current_level) THEN
1393: fnd_log.string(l_log_procedure,
1394: L_DEBUG_KEY ||'.end',
1395: 'At the end of PL SQL procedure.');
1396: END IF;
1397:

Line 1493: fnd_log.string(l_log_procedure,

1489:
1490: BEGIN
1491: -- Log API entry point
1492: IF (l_log_procedure >= l_log_current_level) THEN
1493: fnd_log.string(l_log_procedure,
1494: L_DEBUG_KEY ||'.begin',
1495: 'At the start of function. Route Id = ' || p_route_id || ' and Task Quantity = ' || p_vst_task_qty);
1496: END IF;
1497:

Line 1500: fnd_log.string(l_log_statement,

1496: END IF;
1497:
1498: IF (p_route_id IS NULL) THEN
1499: IF (l_log_statement >= l_log_current_level)THEN
1500: fnd_log.string(l_log_statement,
1501: L_DEBUG_KEY,
1502: 'Route Id is null.');
1503: END IF;
1504: RETURN 0;

Line 1512: fnd_log.string(l_log_statement,

1508: FETCH c_get_route_time_span INTO rt_time_span;
1509: CLOSE c_get_route_time_span;
1510:
1511: IF (l_log_statement >= l_log_current_level)THEN
1512: fnd_log.string(l_log_statement,
1513: L_DEBUG_KEY,
1514: 'Route time span = ' || rt_time_span || ', Visit task Quantity = ' || l_vst_task_qty);
1515: END IF;
1516:

Line 1519: fnd_log.string(l_log_statement,

1515: END IF;
1516:
1517: IF (nvl(l_vst_task_qty,1) = 1) THEN --serialized items
1518: IF (l_log_statement >= l_log_current_level)THEN
1519: fnd_log.string(l_log_statement,
1520: L_DEBUG_KEY,
1521: 'serialized item. rt_time_span = ' || rt_time_span);
1522: END IF;
1523: RETURN rt_time_span;

Line 1577: fnd_log.string(l_log_statement,

1573: rt_final_duration := total_opr_duration;
1574: END IF; --requirements exist at route level
1575:
1576: IF (l_log_statement >= l_log_current_level)THEN
1577: fnd_log.string(l_log_statement,
1578: L_DEBUG_KEY,
1579: 'Route Duration - ' ||rt_final_duration);
1580: END IF;
1581:

Line 1584: fnd_log.string(l_log_procedure,

1580: END IF;
1581:
1582: IF (rt_time_span >= rt_final_duration) THEN
1583: IF (l_log_procedure >= l_log_current_level) THEN
1584: fnd_log.string(l_log_procedure,
1585: L_DEBUG_KEY ||'.end',
1586: 'At the end of PL SQL function. non-serialized item. rt_time_span = ' || rt_time_span);
1587: END IF;
1588: RETURN rt_time_span;

Line 1591: fnd_log.string(l_log_procedure,

1587: END IF;
1588: RETURN rt_time_span;
1589: ELSE
1590: IF (l_log_procedure >= l_log_current_level) THEN
1591: fnd_log.string(l_log_procedure,
1592: L_DEBUG_KEY ||'.end',
1593: 'At the end of PL SQL function. non-serialized item. rt_final_duration = ' || rt_final_duration);
1594: END IF;
1595: RETURN rt_final_duration;