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_LTP_REQST_MATRL_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: l_log_error NUMBER := fnd_log.level_error;
14: l_log_unexpected NUMBER := fnd_log.level_unexpected;

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: l_log_error NUMBER := fnd_log.level_error;
14: l_log_unexpected NUMBER := fnd_log.level_unexpected;
15: -----------------------------------------------------------------

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: l_log_error NUMBER := fnd_log.level_error;
14: l_log_unexpected NUMBER := fnd_log.level_unexpected;
15: -----------------------------------------------------------------
16:

Line 13: l_log_error NUMBER := fnd_log.level_error;

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: l_log_error NUMBER := fnd_log.level_error;
14: l_log_unexpected NUMBER := fnd_log.level_unexpected;
15: -----------------------------------------------------------------
16:
17: -- Definition of private procedure.

Line 14: l_log_unexpected NUMBER := fnd_log.level_unexpected;

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: l_log_error NUMBER := fnd_log.level_error;
14: l_log_unexpected NUMBER := fnd_log.level_unexpected;
15: -----------------------------------------------------------------
16:
17: -- Definition of private procedure.
18: --

Line 135: fnd_log.string

131: AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS(
132: X_RETURN_STATUS => X_RETURN_STATUS,
133: P_VISIT_ID => p_visit_id);
134: IF (l_log_statement >= l_log_current_level)THEN
135: fnd_log.string
136: (
137: l_log_statement,
138: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
139: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS

Line 351: fnd_log.string

347:
348: BEGIN
349:
350: IF (l_log_procedure >= l_log_current_level)THEN
351: fnd_log.string
352: (
353: l_log_procedure,
354: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Insert_Planned_Matrls',
355: 'At the start of PLSQL procedure'

Line 368: fnd_log.string

364: -- Initialize API return status to success
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366: --
367: IF (l_log_statement >= l_log_current_level)THEN
368: fnd_log.string
369: (
370: l_log_statement,
371: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
372: 'Request for Create Planned Material for Visit Id : '|| p_visit_id

Line 432: fnd_log.string

428: IF l_uom_code <> l_prim_uom_code
429: THEN
430:
431: IF (l_log_statement >= l_log_current_level)THEN
432: fnd_log.string
433: (
434: l_log_statement,
435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
436: 'Primary Uom Code : '|| l_prim_uom_code

Line 438: fnd_log.string

434: l_log_statement,
435: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
436: 'Primary Uom Code : '|| l_prim_uom_code
437: );
438: fnd_log.string
439: (
440: l_log_statement,
441: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
442: 'Source Uom Code : '|| l_uom_code

Line 486: fnd_log.string

482:
483: ELSE
484:
485: IF (l_log_statement >= l_log_current_level)THEN
486: fnd_log.string
487: (
488: l_log_statement,
489: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
490: 'ELSE Primary Uom Code : '|| l_prim_uom_code

Line 492: fnd_log.string

488: l_log_statement,
489: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
490: 'ELSE Primary Uom Code : '|| l_prim_uom_code
491: );
492: fnd_log.string
493: (
494: l_log_statement,
495: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
496: 'ELSE Source Uom Code : '|| l_uom_code

Line 498: fnd_log.string

494: l_log_statement,
495: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
496: 'ELSE Source Uom Code : '|| l_uom_code
497: );
498: fnd_log.string
499: (
500: l_log_statement,
501: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
502: 'ELSE Requested quantity : '|| l_requested_quantity || ' -'||l_requested_quantity

Line 548: fnd_log.string

544: l_material_request_type := 'PLANNED';
545: END IF;
546:
547: IF (l_log_statement >= l_log_current_level)THEN
548: fnd_log.string
549: (
550: l_log_statement,
551: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
552: 'Before Insert Schedule Materials for Visit Id : '|| p_visit_id

Line 554: fnd_log.string

550: l_log_statement,
551: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
552: 'Before Insert Schedule Materials for Visit Id : '|| p_visit_id
553: );
554: fnd_log.string
555: (
556: l_log_statement,
557: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
558: 'Before Insert Schedule Materials for Visit Task Id : '|| p_visit_task_id

Line 560: fnd_log.string

556: l_log_statement,
557: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
558: 'Before Insert Schedule Materials for Visit Task Id : '|| p_visit_task_id
559: );
560: fnd_log.string
561: (
562: l_log_statement,
563: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
564: 'Before Insert Schedule Materials for Schedule Material Id : '|| l_schedule_material_id

Line 678: fnd_log.string

674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676:
677: IF (l_log_procedure >= l_log_current_level)THEN
678: fnd_log.string
679: (
680: l_log_procedure,
681: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Insert Planned Matrls.end',
682: 'At the end of PLSQL procedure'

Line 806: fnd_log.string

802:
803: BEGIN
804:
805: IF (l_log_procedure >= l_log_current_level)THEN
806: fnd_log.string
807: (
808: l_log_procedure,
809: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Planned_Materials',
810: 'At the start of PLSQL procedure'

Line 823: fnd_log.string

819: -- Initialize API return status to success
820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821: --
822: IF (l_log_statement >= l_log_current_level)THEN
823: fnd_log.string
824: (
825: l_log_statement,
826: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
827: 'Request for Update Material Number of Records : '|| l_planned_materials_tbl.COUNT

Line 845: fnd_log.string

841: IF Get_Planned_Items_cur%NOTFOUND THEN
842: FND_MESSAGE.set_name( 'AHL','AHL_LTP_SCHE_ID_INVALID' );
843: FND_MSG_PUB.add;
844: IF (l_log_error >= l_log_current_level)THEN
845: fnd_log.string
846: (
847: l_log_error,
848: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
849: 'Schedule Material id not found in ahl_schedule_materials table'

Line 867: fnd_log.string

863: THEN
864: FND_MESSAGE.set_name( 'AHL','AHL_LTP_RECORD_INVALID' );
865: FND_MSG_PUB.add;
866: IF (l_log_error >= l_log_current_level)THEN
867: fnd_log.string
868: (
869: l_log_error,
870: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
871: 'Schedule Material Record has been modified by someother user'

Line 888: fnd_log.string

884: IF Get_Inv_Item_cur%NOTFOUND THEN
885: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_INVALID' );
886: FND_MSG_PUB.add;
887: IF (l_log_error >= l_log_current_level)THEN
888: fnd_log.string
889: (
890: l_log_error,
891: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
892: 'Inventory Item doesnt exist in Mtl System Items Vl'

Line 1061: fnd_log.string

1057: COMMIT WORK;
1058: END IF;
1059:
1060: IF (l_log_procedure >= l_log_current_level)THEN
1061: fnd_log.string
1062: (
1063: l_log_procedure,
1064: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update Planned Materials.end',
1065: 'At the end of PLSQL procedure'

Line 1188: fnd_log.string

1184:
1185: BEGIN
1186:
1187: IF (l_log_procedure >= l_log_current_level)THEN
1188: fnd_log.string
1189: (
1190: l_log_procedure,
1191: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1192: 'At the start of PLSQL procedure'

Line 1205: fnd_log.string

1201: -- Initialize API return status to success
1202: x_return_status := FND_API.G_RET_STS_SUCCESS;
1203: --
1204: IF (l_log_statement >= l_log_current_level)THEN
1205: fnd_log.string
1206: (
1207: l_log_statement,
1208: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1209: 'Request for Create Task Materials for Visit Id : '|| p_visit_id

Line 1221: fnd_log.string

1217: FETCH Get_visit_tasks_cur INTO l_visit_tasks_rec;
1218: CLOSE Get_visit_tasks_cur;
1219:
1220: IF (l_log_statement >= l_log_current_level)THEN
1221: fnd_log.string
1222: (
1223: l_log_statement,
1224: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1225: ' Visit Id: ' || p_visit_id

Line 1227: fnd_log.string

1223: l_log_statement,
1224: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1225: ' Visit Id: ' || p_visit_id
1226: );
1227: fnd_log.string
1228: (
1229: l_log_statement,
1230: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1231: ' Organization Id: ' || l_visit_tasks_rec.organization_id

Line 1247: fnd_log.string

1243: AND l_dummy IS NULL) THEN
1244: -- Derive task start time
1245:
1246: IF (l_log_statement >= l_log_current_level)THEN
1247: fnd_log.string
1248: (
1249: l_log_statement,
1250: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1251: ' Visit Task Id: ' || l_visit_tasks_rec.visit_task_id

Line 1253: fnd_log.string

1249: l_log_statement,
1250: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1251: ' Visit Task Id: ' || l_visit_tasks_rec.visit_task_id
1252: );
1253: fnd_log.string
1254: (
1255: l_log_statement,
1256: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1257: ' Task Start Time: ' || l_visit_tasks_rec.start_date_time

Line 1259: fnd_log.string

1255: l_log_statement,
1256: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1257: ' Task Start Time: ' || l_visit_tasks_rec.start_date_time
1258: );
1259: fnd_log.string
1260: (
1261: l_log_statement,
1262: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1263: ' Mr Route Id: ' || l_visit_tasks_rec.mr_route_id

Line 1285: fnd_log.string

1281: l_requirement_date := l_visit_tasks_rec.start_date_time;
1282: END IF;
1283:
1284: IF (l_log_statement >= l_log_current_level)THEN
1285: fnd_log.string
1286: (
1287: l_log_statement,
1288: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1289: ' Before Calling Get Route Mtl Req, Route Id: ' || l_route_id

Line 1291: fnd_log.string

1287: l_log_statement,
1288: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1289: ' Before Calling Get Route Mtl Req, Route Id: ' || l_route_id
1290: );
1291: fnd_log.string
1292: (
1293: l_log_statement,
1294: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1295: ' Before Calling Get Route Mtl Req, Instance Id: ' || l_instance_id

Line 1301: fnd_log.string

1297:
1298: END IF;
1299:
1300: IF (l_log_procedure >= l_log_current_level) THEN
1301: fnd_log.string
1302: (
1303: l_log_procedure,
1304: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1305: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'

Line 1326: fnd_log.string

1322: x_route_mtl_req_tbl => l_route_mtl_req_tbl);
1323: END IF; --MR Route not null
1324:
1325: IF (l_log_procedure >= l_log_current_level) THEN
1326: fnd_log.string
1327: (
1328: l_log_procedure,
1329: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1330: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status

Line 1342: fnd_log.string

1338: END IF;
1339: END IF;
1340:
1341: IF (l_log_statement >= l_log_current_level)THEN
1342: fnd_log.string
1343: (
1344: l_log_statement,
1345: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1346: ' After Calling Get Route Mtl Req, l_route_mtl_req_tbl COUNT: ' || l_route_mtl_req_tbl.COUNT

Line 1379: fnd_log.string

1375: END IF; --l_route_mtl_req_tbl
1376: END IF;
1377:
1378: IF (l_log_procedure >= l_log_current_level) THEN
1379: fnd_log.string
1380: (
1381: l_log_procedure,
1382: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1383: 'After calling Insert Planned Materials, Return Status : '|| l_return_status

Line 1402: fnd_log.string

1398: COMMIT WORK;
1399: END IF;
1400:
1401: IF (l_log_procedure >= l_log_current_level)THEN
1402: fnd_log.string
1403: (
1404: l_log_procedure,
1405: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create Task Materials.end',
1406: 'At the end of PLSQL procedure'

Line 1580: fnd_log.string

1576: i_x NUMBER;
1577: BEGIN
1578:
1579: IF (l_log_procedure >= l_log_current_level)THEN
1580: fnd_log.string
1581: (
1582: l_log_procedure,
1583: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Task_Matrls',
1584: 'At the start of PLSQL procedure'

Line 1597: fnd_log.string

1593: -- Initialize API return status to success
1594: x_return_status := FND_API.G_RET_STS_SUCCESS;
1595: --
1596: IF (l_log_statement >= l_log_current_level)THEN
1597: fnd_log.string
1598: (
1599: l_log_statement,
1600: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1601: 'Request for Modify Visit Task Materials for Visit Id : '|| p_visit_id

Line 1617: fnd_log.string

1613: EXIT WHEN Deleted_Items_cur%NOTFOUND;
1614: --
1615: IF l_Deleted_Items_Rec.scheduled_material_id IS NOT NULL THEN
1616: IF (l_log_procedure >= l_log_current_level)THEN
1617: fnd_log.string
1618: (
1619: l_log_procedure,
1620: 'AHL.PLSQL.AHL_LTP_REQST_MATRL_PVT.MODIFY_VISIT_TASK_MATRLS',
1621: 'Updating the status to DELETED for Material Requirement' || l_Deleted_Items_Rec.scheduled_material_id

Line 1677: fnd_log.string

1673: END IF;
1674:
1675: --
1676: IF (l_log_statement >= l_log_current_level)THEN
1677: fnd_log.string
1678: (
1679: l_log_statement,
1680: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1681: ' After Calling Derive task times, l_Visit_Task_Route_Tbl.COUNT: ' || l_Visit_Task_Route_Tbl.COUNT

Line 1691: fnd_log.string

1687: FOR i IN l_Visit_Task_Route_Tbl.FIRST..l_Visit_Task_Route_Tbl.LAST
1688: LOOP
1689:
1690: IF (l_log_statement >= l_log_current_level)THEN
1691: fnd_log.string
1692: (
1693: l_log_statement,
1694: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1695: ' Before Calling Get Route Mtl Req, Route Id: ' || l_Visit_Task_Route_Tbl(i).route_id

Line 1697: fnd_log.string

1693: l_log_statement,
1694: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1695: ' Before Calling Get Route Mtl Req, Route Id: ' || l_Visit_Task_Route_Tbl(i).route_id
1696: );
1697: fnd_log.string
1698: (
1699: l_log_statement,
1700: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1701: ' Before Calling Get Route Mtl Req, Instance Id: ' || l_Visit_Task_Route_Tbl(i).instance_id

Line 1703: fnd_log.string

1699: l_log_statement,
1700: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1701: ' Before Calling Get Route Mtl Req, Instance Id: ' || l_Visit_Task_Route_Tbl(i).instance_id
1702: );
1703: fnd_log.string
1704: (
1705: l_log_statement,
1706: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1707: ' Before Calling Get Route Mtl Req, Task Start Time: ' || l_Visit_Task_Route_Tbl(i).task_start_date

Line 1721: fnd_log.string

1717: l_requirement_date := l_Visit_Task_Route_Tbl(i).task_start_date;
1718: END IF;
1719:
1720: IF (l_log_procedure >= l_log_current_level) THEN
1721: fnd_log.string
1722: (
1723: l_log_procedure,
1724: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1725: 'Before calling ahl ltp mtl req pvt.Get Route Mtl Req'

Line 1746: fnd_log.string

1742: p_request_type => 'PLANNED',
1743: x_route_mtl_req_tbl => l_route_mtl_req_tbl);
1744: --
1745: IF (l_log_procedure >= l_log_current_level) THEN
1746: fnd_log.string
1747: (
1748: l_log_procedure,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1750: 'After calling ahl ltp mtl req pvt.Get Route Mtl Req, Return Status : '|| l_return_status

Line 1762: fnd_log.string

1758: END IF;
1759: END IF;
1760:
1761: IF (l_log_statement >= l_log_current_level)THEN
1762: fnd_log.string
1763: (
1764: l_log_statement,
1765: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Planned_Materials',
1766: ' After Calling Get Route Mtl Req, l_route_mtl_req_tbl COUNT: ' || l_route_mtl_req_tbl.COUNT

Line 1793: fnd_log.string

1789: IF Planned_Items_cur%found THEN
1790:
1791: IF l_Planned_Items_Rec.scheduled_material_id IS NOT NULL THEN
1792: IF (l_log_procedure >= l_log_current_level)THEN
1793: fnd_log.string
1794: (
1795: l_log_procedure,
1796: 'AHL.PLSQL.AHL_LTP_REQST_MATRL_PVT.MODIFY_VISIT_TASK_MATRLS',
1797: 'Updating the status to DELETED for Material Requirement' || l_Planned_Items_Rec.scheduled_material_id

Line 1847: fnd_log.string

1843: END LOOP;
1844: END IF; --l_route_mtl_req_tbl
1845:
1846: IF (l_log_procedure >= l_log_current_level) THEN
1847: fnd_log.string
1848: (
1849: l_log_procedure,
1850: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1851: 'After calling Insert Planned Materials, Return Status : '|| l_return_status

Line 1873: fnd_log.string

1869: p_visit_id => p_visit_id,
1870: x_return_status => l_return_status);
1871:
1872: IF (l_log_procedure >= l_log_current_level) THEN
1873: fnd_log.string
1874: (
1875: l_log_procedure,
1876: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1877: 'After calling Modify_Visit_Reservations, Return Status : '|| l_return_status

Line 1899: fnd_log.string

1895: COMMIT WORK;
1896: END IF;
1897:
1898: IF (l_log_procedure >= l_log_current_level)THEN
1899: fnd_log.string
1900: (
1901: l_log_procedure,
1902: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify Visit Task Matrls.end',
1903: 'At the end of PLSQL procedure'

Line 2202: fnd_log.string

2198: --priyan end
2199: BEGIN
2200:
2201: IF (l_log_procedure >= l_log_current_level)THEN
2202: fnd_log.string
2203: (
2204: l_log_procedure,
2205: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials',
2206: 'At the start of PLSQL procedure'

Line 2221: fnd_log.string

2217: -- Initialize API return status to success
2218: x_return_status := FND_API.G_RET_STS_SUCCESS;
2219: --
2220: IF (l_log_statement >= l_log_current_level)THEN
2221: fnd_log.string
2222: (
2223: l_log_statement,
2224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2225: 'Request for Process Task Materials for Visit Id : '|| p_visit_id

Line 2227: fnd_log.string

2223: l_log_statement,
2224: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2225: 'Request for Process Task Materials for Visit Id : '|| p_visit_id
2226: );
2227: fnd_log.string
2228: (
2229: l_log_statement,
2230: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2231: 'Request for Process Task Materials for Visit Task Id : '|| p_visit_task_id

Line 2233: fnd_log.string

2229: l_log_statement,
2230: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2231: 'Request for Process Task Materials for Visit Task Id : '|| p_visit_task_id
2232: );
2233: fnd_log.string
2234: (
2235: l_log_statement,
2236: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2237: 'Request for Process Task Materials for Operation Flag : '|| p_operation_flag

Line 2251: fnd_log.string

2247: -- Added the check l_assoc_id IS NULL
2248: IF (p_visit_task_id IS NOT NULL AND l_assoc_id IS NULL AND p_visit_task_id <> FND_API.g_miss_num AND p_operation_flag = 'C' ) THEN
2249: -- if create
2250: IF (l_log_statement >= l_log_current_level)THEN
2251: fnd_log.string
2252: (
2253: l_log_statement,
2254: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2255: 'Before Calling Create Task Materials for Visit Task Id : '|| p_visit_task_id

Line 2257: fnd_log.string

2253: l_log_statement,
2254: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2255: 'Before Calling Create Task Materials for Visit Task Id : '|| p_visit_task_id
2256: );
2257: fnd_log.string
2258: (
2259: l_log_statement,
2260: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2261: 'Before Calling Create Task Materials for Operation Flag : '|| p_operation_flag

Line 2266: fnd_log.string

2262: );
2263: END IF;
2264:
2265: IF (l_log_procedure >= l_log_current_level) THEN
2266: fnd_log.string
2267: ( l_log_procedure,
2268: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2269: 'Before calling Create Task Materials'
2270: );

Line 2285: fnd_log.string

2281: x_msg_count => l_msg_count,
2282: x_msg_data => l_msg_data );
2283:
2284: IF (l_log_procedure >= l_log_current_level) THEN
2285: fnd_log.string
2286: (
2287: l_log_procedure,
2288: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2289: 'After calling Create Task Materials, Return Status : '|| l_return_status

Line 2304: fnd_log.string

2300: -- Added the check l_assoc_id IS NULL
2301: ELSIF (p_visit_id IS NOT NULL AND l_assoc_id IS NULL AND p_visit_id <> FND_API.g_miss_num AND p_operation_flag = 'U' ) THEN
2302: -- if update
2303: IF (l_log_statement >= l_log_current_level)THEN
2304: fnd_log.string
2305: (
2306: l_log_statement,
2307: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2308: 'Request for Visit Org or Start date change for Visit Id : '|| p_visit_id

Line 2310: fnd_log.string

2306: l_log_statement,
2307: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2308: 'Request for Visit Org or Start date change for Visit Id : '|| p_visit_id
2309: );
2310: fnd_log.string
2311: (
2312: l_log_statement,
2313: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2314: 'Request for Visit Org or Start date change for Operation Flag : '|| p_operation_flag

Line 2316: fnd_log.string

2312: l_log_statement,
2313: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2314: 'Request for Visit Org or Start date change for Operation Flag : '|| p_operation_flag
2315: );
2316: fnd_log.string
2317: (
2318: l_log_statement,
2319: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2320: 'Request for Visit Org or Start date change for Org Id : '|| p_org_id

Line 2322: fnd_log.string

2318: l_log_statement,
2319: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2320: 'Request for Visit Org or Start date change for Org Id : '|| p_org_id
2321: );
2322: fnd_log.string
2323: (
2324: l_log_statement,
2325: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2326: 'Request for Visit Org or Start date change for Start date : '|| p_start_date

Line 2331: fnd_log.string

2327: );
2328: END IF;
2329:
2330: IF (l_log_procedure >= l_log_current_level) THEN
2331: fnd_log.string
2332: (
2333: l_log_procedure,
2334: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2335: 'Before calling Modify Visit Task Materials'

Line 2352: fnd_log.string

2348: x_msg_count => l_msg_count,
2349: x_msg_data => l_msg_data);
2350:
2351: IF (l_log_procedure >= l_log_current_level) THEN
2352: fnd_log.string
2353: (
2354: l_log_procedure,
2355: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2356: 'After calling Create Planned Materials, Return Status : '|| l_return_status

Line 2393: fnd_log.string

2389: ELSIF (p_visit_id IS NOT NULL AND p_visit_id <> FND_API.g_miss_num AND p_operation_flag = 'R'
2390: AND p_visit_task_id IS NULL) THEN
2391: -- remove mode , with no task id
2392: IF (l_log_statement >= l_log_current_level)THEN
2393: fnd_log.string
2394: (
2395: l_log_statement,
2396: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2397: 'Request for Removing visit materials for Visit Id : '|| p_visit_id

Line 2399: fnd_log.string

2395: l_log_statement,
2396: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2397: 'Request for Removing visit materials for Visit Id : '|| p_visit_id
2398: );
2399: fnd_log.string
2400: (
2401: l_log_statement,
2402: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2403: 'Request for Remove visit materials for Operation Flag : '|| p_operation_flag

Line 2408: fnd_log.string

2404: );
2405: END IF;
2406:
2407: IF (l_log_procedure >= l_log_current_level) THEN
2408: fnd_log.string
2409: (
2410: l_log_procedure,
2411: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2412: 'Before calling Remove Visit Task Materials'

Line 2428: fnd_log.string

2424: x_msg_count => l_msg_count,
2425: x_msg_data => l_msg_data);
2426:
2427: IF (l_log_procedure >= l_log_current_level) THEN
2428: fnd_log.string
2429: (
2430: l_log_procedure,
2431: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2432: 'After calling Remove Visit Task Materials, Return Status : '|| l_return_status

Line 2448: fnd_log.string

2444: ELSIF (p_visit_task_id IS NOT NULL AND p_visit_task_id <> FND_API.g_miss_num AND p_operation_flag = 'R')
2445: THEN
2446: -- Remove mode with Task ID
2447: IF (l_log_statement >= l_log_current_level)THEN
2448: fnd_log.string
2449: (
2450: l_log_statement,
2451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2452: 'Request for Removing task materials for Visit Task Id : '|| p_visit_task_id

Line 2454: fnd_log.string

2450: l_log_statement,
2451: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2452: 'Request for Removing task materials for Visit Task Id : '|| p_visit_task_id
2453: );
2454: fnd_log.string
2455: (
2456: l_log_statement,
2457: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2458: 'Request for Removing task materials for Operation Flag : '|| p_operation_flag

Line 2463: fnd_log.string

2459: );
2460: END IF;
2461:
2462: IF (l_log_procedure >= l_log_current_level) THEN
2463: fnd_log.string
2464: (
2465: l_log_procedure,
2466: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2467: 'Before calling Remove Visit Task Materials'

Line 2485: fnd_log.string

2481: x_msg_data => l_msg_data);
2482:
2483:
2484: IF (l_log_procedure >= l_log_current_level) THEN
2485: fnd_log.string
2486: (
2487: l_log_procedure,
2488: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2489: 'After calling Remove Visit Task Materials, Return Status : '|| l_return_status

Line 2504: fnd_log.string

2500: ELSIF (p_visit_id IS NOT NULL AND p_visit_id <> FND_API.g_miss_num AND p_visit_status IN ('CLOSED', 'CANCELLED'))
2501: -- visitis in Closed or Cancelled status
2502: THEN
2503: IF (l_log_statement >= l_log_current_level)THEN
2504: fnd_log.string
2505: (
2506: l_log_statement,
2507: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2508: 'Request for Visit Closed or Cancelled Update Unplanned materials for Visit Id : '|| p_visit_id

Line 2513: fnd_log.string

2509: );
2510: END IF;
2511:
2512: IF (l_log_procedure >= l_log_current_level) THEN
2513: fnd_log.string
2514: (
2515: l_log_procedure,
2516: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2517: 'Before calling Update Unplanned Visit Materials'

Line 2532: fnd_log.string

2528: x_msg_count => l_msg_count,
2529: x_msg_data => l_msg_data);
2530:
2531: IF (l_log_procedure >= l_log_current_level) THEN
2532: fnd_log.string
2533: (
2534: l_log_procedure,
2535: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2536: 'After calling Update Unplanned Materials, Return Status : '|| l_return_status

Line 2553: fnd_log.string

2549: COMMIT WORK;
2550: END IF;
2551:
2552: IF (l_log_procedure >= l_log_current_level)THEN
2553: fnd_log.string
2554: (
2555: l_log_procedure,
2556: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Process Planned Materials.end',
2557: 'At the end of PLSQL procedure'

Line 2681: fnd_log.string

2677: l_visit_task_id NUMBER := p_visit_task_id;
2678: l_planned_order_flag VARCHAR2(1):= 'N';
2679: BEGIN
2680: IF (l_log_procedure >= l_log_current_level)THEN
2681: fnd_log.string
2682: (
2683: l_log_procedure,
2684: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2685: 'At the start of PLSQL procedure'

Line 2698: fnd_log.string

2694: -- Initialize API return status to success
2695: x_return_status := FND_API.G_RET_STS_SUCCESS;
2696:
2697: IF (l_log_statement >= l_log_current_level)THEN
2698: fnd_log.string
2699: (
2700: l_log_statement,
2701: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2702: 'Request for Remove Task Materials for Visit Id : '|| l_visit_id

Line 2704: fnd_log.string

2700: l_log_statement,
2701: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2702: 'Request for Remove Task Materials for Visit Id : '|| l_visit_id
2703: );
2704: fnd_log.string
2705: (
2706: l_log_statement,
2707: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2708: 'Request for Remove Task Materials for Visit Task Id : '|| l_visit_task_id

Line 2719: fnd_log.string

2715: FETCH visit_task_details_cur INTO l_visit_task_details_rec;
2716: CLOSE visit_task_details_cur;
2717:
2718: IF (l_log_statement >= l_log_current_level)THEN
2719: fnd_log.string
2720: (
2721: l_log_statement,
2722: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2723: ' After visit task details cur, Visit Id: ' || l_visit_id

Line 2731: fnd_log.string

2727: --Check for deleting a visit
2728: IF (l_visit_task_id IS NOT NULL AND l_visit_task_id <> fnd_api.g_miss_num)
2729: THEN
2730: IF (l_log_statement >= l_log_current_level)THEN
2731: fnd_log.string
2732: (
2733: l_log_statement,
2734: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2735: ' Before Retrieving task materials cur, Visit Task Id: ' || l_visit_task_id

Line 2755: fnd_log.string

2751: END LOOP;
2752: CLOSE visit_task_mtrls_cur;
2753: ELSE
2754: IF (l_log_statement >= l_log_current_level)THEN
2755: fnd_log.string
2756: (
2757: l_log_statement,
2758: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2759: ' Before Retrieving all visit task materials cur, For Visit Id: ' || l_visit_id

Line 2786: fnd_log.string

2782: X_RETURN_STATUS => X_RETURN_STATUS,
2783: P_VISIT_ID => p_visit_id);
2784:
2785: IF (l_log_statement >= l_log_current_level)THEN
2786: fnd_log.string
2787: (
2788: l_log_statement,
2789: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2790: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS

Line 2816: fnd_log.string

2812: COMMIT WORK;
2813: END IF;
2814:
2815: IF (l_log_procedure >= l_log_current_level)THEN
2816: fnd_log.string
2817: (
2818: l_log_procedure,
2819: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove Visit Task Matrls.end',
2820: 'At the end of PLSQL procedure'

Line 2910: fnd_log.string

2906: l_visit_mtrls_rec visit_mtrls_cur%ROWTYPE;
2907:
2908: BEGIN
2909: IF (l_log_procedure >= l_log_current_level)THEN
2910: fnd_log.string
2911: (
2912: l_log_procedure,
2913: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Unplanned_Matrls',
2914: 'At the start of PLSQL procedure'

Line 2929: fnd_log.string

2925: -- Initialize API return status to success
2926: x_return_status := FND_API.G_RET_STS_SUCCESS;
2927:
2928: IF (l_log_statement >= l_log_current_level)THEN
2929: fnd_log.string
2930: (
2931: l_log_statement,
2932: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2933: 'Request for Update Materials for Visit Id : '|| p_visit_id

Line 2958: fnd_log.string

2954: X_RETURN_STATUS => X_RETURN_STATUS,
2955: P_VISIT_ID => p_visit_id);
2956:
2957: IF (l_log_statement >= l_log_current_level)THEN
2958: fnd_log.string
2959: (
2960: l_log_statement,
2961: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2962: ' After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS ErrorMessage Status : ' || X_RETURN_STATUS

Line 2976: fnd_log.string

2972: COMMIT WORK;
2973: END IF;
2974:
2975: IF (l_log_procedure >= l_log_current_level)THEN
2976: fnd_log.string
2977: (
2978: l_log_procedure,
2979: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update Unplanned Matrls.end',
2980: 'At the end of PLSQL procedure'

Line 3072: fnd_log.string

3068: l_org_count NUMBER;
3069: l_scheduled_material_id NUMBER;
3070: BEGIN
3071: IF (l_log_procedure >= l_log_current_level)THEN
3072: fnd_log.string
3073: (
3074: l_log_procedure,
3075: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.Start',
3076: 'At the end of PLSQL procedure'

Line 3099: fnd_log.string

3095: FROM ahl_visit_tasks_b
3096: WHERE visit_id = p_visit_id);
3097:
3098: IF (l_log_statement >= l_log_current_level)THEN
3099: fnd_log.string
3100: (
3101: l_log_statement,
3102: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3103: 'l_org_count : '||l_org_count||' l_cur_org_id:'||l_cur_org_id||

Line 3124: fnd_log.string

3120: X_RETURN_STATUS => X_RETURN_STATUS,
3121: P_VISIT_ID => p_visit_id);
3122:
3123: IF (l_log_statement >= l_log_current_level)THEN
3124: fnd_log.string
3125: (
3126: l_log_statement,
3127: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3128: 'After calling AHL_RSV_RESERVATIONS_PVT.DELETE_VISIT_RESERVATIONS:X_RETURN_STATUS '||X_RETURN_STATUS

Line 3137: fnd_log.string

3133: RAISE Fnd_Api.g_exc_error;
3134: END IF;
3135: ELSE
3136: IF (l_log_statement >= l_log_current_level)THEN
3137: fnd_log.string
3138: (
3139: l_log_statement,
3140: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3141: 'In the else part of check l_prev_org_id <> l_cur_org_id'

Line 3159: fnd_log.string

3155: p_scheduled_material_id => l_scheduled_material_id
3156: );
3157:
3158: IF (l_log_statement >= l_log_current_level)THEN
3159: fnd_log.string
3160: (
3161: l_log_statement,
3162: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3163: 'After calling AHL_RSV_RESERVATIONS_PVT.Delete_Reservation:l_return_status '||l_return_status

Line 3180: fnd_log.string

3176: X_RETURN_STATUS => x_return_status,
3177: P_VISIT_ID => p_visit_id);
3178:
3179: IF (l_log_statement >= l_log_current_level)THEN
3180: fnd_log.string
3181: (
3182: l_log_statement,
3183: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations',
3184: 'After calling AHL_RSV_RESERVATIONS_PVT.Update_Visit_Reservations:x_return_status '||x_return_status

Line 3195: fnd_log.string

3191: END IF;
3192: END IF; -- IF l_prev_org_id <> l_cur_org_id
3193:
3194: IF (l_log_procedure >= l_log_current_level)THEN
3195: fnd_log.string
3196: (
3197: l_log_procedure,
3198: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Reservations.end',
3199: 'At the end of PLSQL procedure'

Line 3255: fnd_log.string( l_log_procedure,L_DEBUG_KEY ||'.begin','At the start of PL SQL procedure - Task id = '||p_visit_task_id);

3251: END IF;
3252:
3253: -- Log API entry point
3254: IF (l_log_procedure >= l_log_current_level) THEN
3255: fnd_log.string( l_log_procedure,L_DEBUG_KEY ||'.begin','At the start of PL SQL procedure - Task id = '||p_visit_task_id);
3256: END IF;
3257:
3258: IF (p_visit_task_id IS NULL) THEN
3259: IF (l_log_statement >= l_log_current_level) THEN

Line 3260: fnd_log.string( l_log_statement,L_DEBUG_KEY,'Task id is null' );

3256: END IF;
3257:
3258: IF (p_visit_task_id IS NULL) THEN
3259: IF (l_log_statement >= l_log_current_level) THEN
3260: fnd_log.string( l_log_statement,L_DEBUG_KEY,'Task id is null' );
3261: END IF;
3262: Fnd_Message.SET_NAME('AHL','AHL_VISIT_TASKID_NULL');
3263: Fnd_Msg_Pub.ADD;
3264: RAISE Fnd_Api.G_EXC_ERROR;

Line 3283: fnd_log.string(l_log_procedure,

3279: COMMIT WORK;
3280: END IF;
3281:
3282: IF (l_log_procedure >= l_log_current_level) THEN
3283: fnd_log.string(l_log_procedure,
3284: L_DEBUG_KEY ||'.end',
3285: 'No of rows updated - '||SQL%ROWCOUNT);
3286: fnd_log.string(l_log_procedure,
3287: L_DEBUG_KEY ||'.end',

Line 3286: fnd_log.string(l_log_procedure,

3282: IF (l_log_procedure >= l_log_current_level) THEN
3283: fnd_log.string(l_log_procedure,
3284: L_DEBUG_KEY ||'.end',
3285: 'No of rows updated - '||SQL%ROWCOUNT);
3286: fnd_log.string(l_log_procedure,
3287: L_DEBUG_KEY ||'.end',
3288: 'At the end of PL SQL procedure. Return Status =' || x_return_status);
3289: END IF;
3290: