DBA Data[Home] [Help]

APPS.AHL_UA_COMMON_PVT dependencies on FND_LOG

Line 202: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

198: -- Initialize API return status to success
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: -- Log API entry point
202: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
203: THEN
204: fnd_log.string
205: (
206: fnd_log.level_procedure,

Line 204: fnd_log.string

200:
201: -- Log API entry point
202: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
203: THEN
204: fnd_log.string
205: (
206: fnd_log.level_procedure,
207: L_DEBUG_MODULE||'.begin',
208: 'At the start of PLSQL procedure'

Line 206: fnd_log.level_procedure,

202: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
203: THEN
204: fnd_log.string
205: (
206: fnd_log.level_procedure,
207: L_DEBUG_MODULE||'.begin',
208: 'At the start of PLSQL procedure'
209: );
210: END IF;

Line 240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

236: END IF;
237: CLOSE check_unit_exists;
238: */
239:
240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
241: THEN
242: fnd_log.string
243: (
244: fnd_log.level_statement,

Line 242: fnd_log.string

238: */
239:
240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
241: THEN
242: fnd_log.string
243: (
244: fnd_log.level_statement,
245: L_DEBUG_MODULE,
246: 'Basic validations done'

Line 244: fnd_log.level_statement,

240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
241: THEN
242: fnd_log.string
243: (
244: fnd_log.level_statement,
245: L_DEBUG_MODULE,
246: 'Basic validations done'
247: );
248: END IF;

Line 263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

259: l_Event_Schedule_Rec.event_type := l_event_type;
260: l_Event_Schedule_Rec.event_start_time := l_event_start_time;
261: l_Event_Schedule_Rec.event_end_time := l_event_end_time;
262:
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
264: THEN
265: fnd_log.string
266: (
267: fnd_log.level_statement,

Line 265: fnd_log.string

261: l_Event_Schedule_Rec.event_end_time := l_event_end_time;
262:
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
264: THEN
265: fnd_log.string
266: (
267: fnd_log.level_statement,
268: L_DEBUG_MODULE,
269: 'adding event_id [' || l_event_id || '] ' ||

Line 267: fnd_log.level_statement,

263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
264: THEN
265: fnd_log.string
266: (
267: fnd_log.level_statement,
268: L_DEBUG_MODULE,
269: 'adding event_id [' || l_event_id || '] ' ||
270: 'event_type [' || l_event_type || '] ' ||
271: 'actual event_start_time [' || to_char(l_event_start_time,'MM-DD-YYYY HH24:MI:SS') || '] ' ||

Line 292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

288: l_Event_Schedule_Rec.event_type := l_event_type;
289: l_Event_Schedule_Rec.event_start_time := l_event_start_time;
290: l_Event_Schedule_Rec.event_end_time := l_event_end_time;
291:
292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
293: THEN
294: fnd_log.string
295: (
296: fnd_log.level_statement,

Line 294: fnd_log.string

290: l_Event_Schedule_Rec.event_end_time := l_event_end_time;
291:
292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
293: THEN
294: fnd_log.string
295: (
296: fnd_log.level_statement,
297: L_DEBUG_MODULE,
298: 'adding event_id [' || l_event_id || '] ' ||

Line 296: fnd_log.level_statement,

292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
293: THEN
294: fnd_log.string
295: (
296: fnd_log.level_statement,
297: L_DEBUG_MODULE,
298: 'adding event_id [' || l_event_id || '] ' ||
299: 'event_type [' || l_event_type || '] ' ||
300: 'est event_start_time [' || to_char(l_event_start_time,'MM-DD-YYYY HH24:MI:SS') || '] ' ||

Line 314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

310: END IF;
311: -- API body ends here
312:
313: -- Log API exit point
314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
315: THEN
316: fnd_log.string
317: (
318: fnd_log.level_procedure,

Line 316: fnd_log.string

312:
313: -- Log API exit point
314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
315: THEN
316: fnd_log.string
317: (
318: fnd_log.level_procedure,
319: L_DEBUG_MODULE||'.end',
320: 'At the end of PLSQL procedure'

Line 318: fnd_log.level_procedure,

314: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
315: THEN
316: fnd_log.string
317: (
318: fnd_log.level_procedure,
319: L_DEBUG_MODULE||'.end',
320: 'At the end of PLSQL procedure'
321: );
322: END IF;

Line 447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

443: -- Initialize API return status to success
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445:
446: -- Log API entry point
447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
448: THEN
449: fnd_log.string
450: (
451: fnd_log.level_procedure,

Line 449: fnd_log.string

445:
446: -- Log API entry point
447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
448: THEN
449: fnd_log.string
450: (
451: fnd_log.level_procedure,
452: L_DEBUG_MODULE||'.begin',
453: 'At the start of PLSQL procedure'

Line 451: fnd_log.level_procedure,

447: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
448: THEN
449: fnd_log.string
450: (
451: fnd_log.level_procedure,
452: L_DEBUG_MODULE||'.begin',
453: 'At the start of PLSQL procedure'
454: );
455: END IF;

Line 484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

480: END IF;
481: CLOSE check_unit_exists;
482: */
483:
484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
485: THEN
486: fnd_log.string
487: (
488: fnd_log.level_statement,

Line 486: fnd_log.string

482: */
483:
484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
485: THEN
486: fnd_log.string
487: (
488: fnd_log.level_statement,
489: L_DEBUG_MODULE,
490: 'Basic validations done'

Line 488: fnd_log.level_statement,

484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
485: THEN
486: fnd_log.string
487: (
488: fnd_log.level_statement,
489: L_DEBUG_MODULE,
490: 'Basic validations done'
491: );
492: END IF;

Line 647: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

643:
644: -- API body ends here
645:
646: -- Log API exit point
647: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
648: THEN
649: fnd_log.string
650: (
651: fnd_log.level_procedure,

Line 649: fnd_log.string

645:
646: -- Log API exit point
647: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
648: THEN
649: fnd_log.string
650: (
651: fnd_log.level_procedure,
652: L_DEBUG_MODULE||'.end',
653: 'At the end of PLSQL procedure'

Line 651: fnd_log.level_procedure,

647: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
648: THEN
649: fnd_log.string
650: (
651: fnd_log.level_procedure,
652: L_DEBUG_MODULE||'.end',
653: 'At the end of PLSQL procedure'
654: );
655: END IF;

Line 899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

895: -- Initialize API return status to success
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898: -- Log API entry point
899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
900: THEN
901: fnd_log.string
902: (
903: fnd_log.level_procedure,

Line 901: fnd_log.string

897:
898: -- Log API entry point
899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
900: THEN
901: fnd_log.string
902: (
903: fnd_log.level_procedure,
904: L_DEBUG_MODULE||'.begin',
905: 'At the start of PLSQL procedure'

Line 903: fnd_log.level_procedure,

899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
900: THEN
901: fnd_log.string
902: (
903: fnd_log.level_procedure,
904: L_DEBUG_MODULE||'.begin',
905: 'At the start of PLSQL procedure'
906: );
907: END IF;

Line 936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

932: END IF;
933: CLOSE check_unit_exists;
934: */
935:
936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
937: THEN
938: fnd_log.string
939: (
940: fnd_log.level_statement,

Line 938: fnd_log.string

934: */
935:
936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
937: THEN
938: fnd_log.string
939: (
940: fnd_log.level_statement,
941: L_DEBUG_MODULE,
942: 'Basic validations done'

Line 940: fnd_log.level_statement,

936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
937: THEN
938: fnd_log.string
939: (
940: fnd_log.level_statement,
941: L_DEBUG_MODULE,
942: 'Basic validations done'
943: );
944: END IF;

Line 1019: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1015: END IF;
1016: CLOSE get_visit_start_time;
1017:
1018: -- Log API exit point
1019: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1020: THEN
1021: fnd_log.string
1022: (
1023: fnd_log.level_procedure,

Line 1021: fnd_log.string

1017:
1018: -- Log API exit point
1019: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1020: THEN
1021: fnd_log.string
1022: (
1023: fnd_log.level_procedure,
1024: L_DEBUG_MODULE||'.end',
1025: 'At the end of PLSQL procedure'

Line 1023: fnd_log.level_procedure,

1019: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1020: THEN
1021: fnd_log.string
1022: (
1023: fnd_log.level_procedure,
1024: L_DEBUG_MODULE||'.end',
1025: 'At the end of PLSQL procedure'
1026: );
1027: END IF;

Line 1266: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1262: -- Initialize API return status to success
1263: x_return_status := FND_API.G_RET_STS_SUCCESS;
1264:
1265: -- Log API entry point
1266: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1267: THEN
1268: fnd_log.string
1269: (
1270: fnd_log.level_procedure,

Line 1268: fnd_log.string

1264:
1265: -- Log API entry point
1266: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1267: THEN
1268: fnd_log.string
1269: (
1270: fnd_log.level_procedure,
1271: L_DEBUG_MODULE||'.begin',
1272: 'At the start of PLSQL procedure'

Line 1270: fnd_log.level_procedure,

1266: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1267: THEN
1268: fnd_log.string
1269: (
1270: fnd_log.level_procedure,
1271: L_DEBUG_MODULE||'.begin',
1272: 'At the start of PLSQL procedure'
1273: );
1274: END IF;

Line 1304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1300: END IF;
1301: CLOSE check_unit_exists;
1302: */
1303:
1304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1305: THEN
1306: fnd_log.string
1307: (
1308: fnd_log.level_statement,

Line 1306: fnd_log.string

1302: */
1303:
1304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1305: THEN
1306: fnd_log.string
1307: (
1308: fnd_log.level_statement,
1309: L_DEBUG_MODULE,
1310: 'Basic validations done'

Line 1308: fnd_log.level_statement,

1304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1305: THEN
1306: fnd_log.string
1307: (
1308: fnd_log.level_statement,
1309: L_DEBUG_MODULE,
1310: 'Basic validations done'
1311: );
1312: END IF;

Line 1384: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1380: END IF;
1381: CLOSE get_visit_start_time;
1382:
1383: -- Log API exit point
1384: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1385: THEN
1386: fnd_log.string
1387: (
1388: fnd_log.level_procedure,

Line 1386: fnd_log.string

1382:
1383: -- Log API exit point
1384: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1385: THEN
1386: fnd_log.string
1387: (
1388: fnd_log.level_procedure,
1389: L_DEBUG_MODULE||'.end',
1390: 'At the end of PLSQL procedure'

Line 1388: fnd_log.level_procedure,

1384: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1385: THEN
1386: fnd_log.string
1387: (
1388: fnd_log.level_procedure,
1389: L_DEBUG_MODULE||'.end',
1390: 'At the end of PLSQL procedure'
1391: );
1392: END IF;

Line 1489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1485: -- Initialize API return status to success
1486: x_return_status := FND_API.G_RET_STS_SUCCESS;
1487:
1488: -- Log API entry point
1489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1490: THEN
1491: fnd_log.string
1492: (
1493: fnd_log.level_procedure,

Line 1491: fnd_log.string

1487:
1488: -- Log API entry point
1489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1490: THEN
1491: fnd_log.string
1492: (
1493: fnd_log.level_procedure,
1494: L_DEBUG_MODULE||'.begin',
1495: 'At the start of PLSQL procedure'

Line 1493: fnd_log.level_procedure,

1489: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1490: THEN
1491: fnd_log.string
1492: (
1493: fnd_log.level_procedure,
1494: L_DEBUG_MODULE||'.begin',
1495: 'At the start of PLSQL procedure'
1496: );
1497: END IF;

Line 1527: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1523: END IF;
1524: CLOSE check_unit_exists;
1525: */
1526:
1527: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1528: THEN
1529: fnd_log.string
1530: (
1531: fnd_log.level_statement,

Line 1529: fnd_log.string

1525: */
1526:
1527: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1528: THEN
1529: fnd_log.string
1530: (
1531: fnd_log.level_statement,
1532: L_DEBUG_MODULE,
1533: 'Basic validations done'

Line 1531: fnd_log.level_statement,

1527: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1528: THEN
1529: fnd_log.string
1530: (
1531: fnd_log.level_statement,
1532: L_DEBUG_MODULE,
1533: 'Basic validations done'
1534: );
1535: END IF;

Line 1669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1665: END IF;
1666: -- API body ends here
1667:
1668: -- Log API exit point
1669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1670: THEN
1671: fnd_log.string
1672: (
1673: fnd_log.level_procedure,

Line 1671: fnd_log.string

1667:
1668: -- Log API exit point
1669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1670: THEN
1671: fnd_log.string
1672: (
1673: fnd_log.level_procedure,
1674: L_DEBUG_MODULE||'.end',
1675: 'At the end of PLSQL procedure'

Line 1673: fnd_log.level_procedure,

1669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1670: THEN
1671: fnd_log.string
1672: (
1673: fnd_log.level_procedure,
1674: L_DEBUG_MODULE||'.end',
1675: 'At the end of PLSQL procedure'
1676: );
1677: END IF;

Line 1775: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1771: -- Initialize API return status to success
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773:
1774: -- Log API entry point
1775: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1776: THEN
1777: fnd_log.string
1778: (
1779: fnd_log.level_procedure,

Line 1777: fnd_log.string

1773:
1774: -- Log API entry point
1775: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1776: THEN
1777: fnd_log.string
1778: (
1779: fnd_log.level_procedure,
1780: L_DEBUG_MODULE||'.begin',
1781: 'At the start of PLSQL procedure'

Line 1779: fnd_log.level_procedure,

1775: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1776: THEN
1777: fnd_log.string
1778: (
1779: fnd_log.level_procedure,
1780: L_DEBUG_MODULE||'.begin',
1781: 'At the start of PLSQL procedure'
1782: );
1783: END IF;

Line 1813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1809: END IF;
1810: CLOSE check_unit_exists;
1811: */
1812:
1813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1814: THEN
1815: fnd_log.string
1816: (
1817: fnd_log.level_statement,

Line 1815: fnd_log.string

1811: */
1812:
1813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1814: THEN
1815: fnd_log.string
1816: (
1817: fnd_log.level_statement,
1818: L_DEBUG_MODULE,
1819: 'Basic validations done'

Line 1817: fnd_log.level_statement,

1813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1814: THEN
1815: fnd_log.string
1816: (
1817: fnd_log.level_statement,
1818: L_DEBUG_MODULE,
1819: 'Basic validations done'
1820: );
1821: END IF;

Line 1932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1928: END IF;
1929: -- API body ends here
1930:
1931: -- Log API exit point
1932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1933: THEN
1934: fnd_log.string
1935: (
1936: fnd_log.level_procedure,

Line 1934: fnd_log.string

1930:
1931: -- Log API exit point
1932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1933: THEN
1934: fnd_log.string
1935: (
1936: fnd_log.level_procedure,
1937: L_DEBUG_MODULE||'.end',
1938: 'At the end of PLSQL procedure'

Line 1936: fnd_log.level_procedure,

1932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1933: THEN
1934: fnd_log.string
1935: (
1936: fnd_log.level_procedure,
1937: L_DEBUG_MODULE||'.end',
1938: 'At the end of PLSQL procedure'
1939: );
1940: END IF;

Line 2059: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2055: -- Initialize API return status to success
2056: x_return_status := FND_API.G_RET_STS_SUCCESS;
2057:
2058: -- Log API entry point
2059: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2060: THEN
2061: fnd_log.string
2062: (
2063: fnd_log.level_procedure,

Line 2061: fnd_log.string

2057:
2058: -- Log API entry point
2059: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2060: THEN
2061: fnd_log.string
2062: (
2063: fnd_log.level_procedure,
2064: L_DEBUG_MODULE||'.begin',
2065: 'At the start of PLSQL procedure'

Line 2063: fnd_log.level_procedure,

2059: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2060: THEN
2061: fnd_log.string
2062: (
2063: fnd_log.level_procedure,
2064: L_DEBUG_MODULE||'.begin',
2065: 'At the start of PLSQL procedure'
2066: );
2067: END IF;

Line 2097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

2093: END IF;
2094: CLOSE check_unit_exists;
2095: */
2096:
2097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2098: THEN
2099: fnd_log.string
2100: (
2101: fnd_log.level_statement,

Line 2099: fnd_log.string

2095: */
2096:
2097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2098: THEN
2099: fnd_log.string
2100: (
2101: fnd_log.level_statement,
2102: L_DEBUG_MODULE,
2103: 'Basic validations done'

Line 2101: fnd_log.level_statement,

2097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2098: THEN
2099: fnd_log.string
2100: (
2101: fnd_log.level_statement,
2102: L_DEBUG_MODULE,
2103: 'Basic validations done'
2104: );
2105: END IF;

Line 2254: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

2250:
2251: -- API body ends here
2252:
2253: -- Log API exit point
2254: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2255: THEN
2256: fnd_log.string
2257: (
2258: fnd_log.level_procedure,

Line 2256: fnd_log.string

2252:
2253: -- Log API exit point
2254: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2255: THEN
2256: fnd_log.string
2257: (
2258: fnd_log.level_procedure,
2259: L_DEBUG_MODULE||'.end',
2260: 'At the end of PLSQL procedure'

Line 2258: fnd_log.level_procedure,

2254: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
2255: THEN
2256: fnd_log.string
2257: (
2258: fnd_log.level_procedure,
2259: L_DEBUG_MODULE||'.end',
2260: 'At the end of PLSQL procedure'
2261: );
2262: END IF;