DBA Data[Home] [Help]

APPS.AHL_AMP_WORKBENCH_PVT dependencies on FND_LOG

Line 13: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
10: ------------------------------------
11: -- Common constants and variables --
12: ------------------------------------
13: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
14: l_log_statement NUMBER := fnd_log.level_statement;
15: l_log_procedure NUMBER := fnd_log.level_procedure;
16: l_log_error NUMBER := fnd_log.level_error;
17: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 14: l_log_statement NUMBER := fnd_log.level_statement;

10: ------------------------------------
11: -- Common constants and variables --
12: ------------------------------------
13: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
14: l_log_statement NUMBER := fnd_log.level_statement;
15: l_log_procedure NUMBER := fnd_log.level_procedure;
16: l_log_error NUMBER := fnd_log.level_error;
17: l_log_unexpected NUMBER := fnd_log.level_unexpected;
18:

Line 15: l_log_procedure NUMBER := fnd_log.level_procedure;

11: -- Common constants and variables --
12: ------------------------------------
13: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
14: l_log_statement NUMBER := fnd_log.level_statement;
15: l_log_procedure NUMBER := fnd_log.level_procedure;
16: l_log_error NUMBER := fnd_log.level_error;
17: l_log_unexpected NUMBER := fnd_log.level_unexpected;
18:
19: -- constants for WHO Columns

Line 16: l_log_error NUMBER := fnd_log.level_error;

12: ------------------------------------
13: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
14: l_log_statement NUMBER := fnd_log.level_statement;
15: l_log_procedure NUMBER := fnd_log.level_procedure;
16: l_log_error NUMBER := fnd_log.level_error;
17: l_log_unexpected NUMBER := fnd_log.level_unexpected;
18:
19: -- constants for WHO Columns
20: -- Added by Prithwi as a part of Public API cleanup

Line 17: l_log_unexpected NUMBER := fnd_log.level_unexpected;

13: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
14: l_log_statement NUMBER := fnd_log.level_statement;
15: l_log_procedure NUMBER := fnd_log.level_procedure;
16: l_log_error NUMBER := fnd_log.level_error;
17: l_log_unexpected NUMBER := fnd_log.level_unexpected;
18:
19: -- constants for WHO Columns
20: -- Added by Prithwi as a part of Public API cleanup
21:

Line 550: fnd_log.string(l_log_procedure,

546: -- Standard Start of API savepoint
547: SAVEPOINT GET_ORG_SCH_GRAPH;
548:
549: IF (l_log_procedure >= l_log_current_level) THEN
550: fnd_log.string(l_log_procedure,
551: l_debug_key ||'.begin',
552: ' At the start of PL SQL function. '||
553: ' Org Id = ' || p_org_sch_search_rec.ORG_ID ||
554: ' Dept Name = ' || p_org_sch_search_rec.DEPARTMENT_NAME||

Line 583: fnd_log.string(l_log_statement,

579:
580: IF(p_org_sch_search_rec.ORG_ID IS NULL) OR
581: (p_org_sch_search_rec.DISPLAY_WINDOW IS NULL) THEN
582: IF (l_log_statement >= l_log_current_level) THEN
583: fnd_log.string(l_log_statement,
584: L_DEBUG_KEY,
585: 'Passed Mandatory fields Org id or Display window is null');
586: END IF;
587: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_ORG_MANDATORY');

Line 615: fnd_log.string(l_log_procedure,

611: l_loop_start_date := p_org_sch_search_rec.START_BEFORE_DATE - l_loop_window + 1;
612: END IF;
613:
614: IF (l_log_procedure >= l_log_current_level) THEN
615: fnd_log.string(l_log_procedure,
616: l_debug_key ||'.middle',
617: ' Before looping through rows. '||
618: ' Loop Start date = ' || l_loop_start_date||
619: ' Filter Criteria' ||l_filter_criteria);

Line 673: fnd_log.string(l_log_statement,

669:
670: l_msg_count := Fnd_Msg_Pub.count_msg;
671: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
672: IF (l_log_statement >= l_log_current_level) THEN
673: fnd_log.string(l_log_statement,
674: L_DEBUG_KEY,
675: 'Errors from GET_VISITS_FOR_DATE_ORG. Message count: ' ||
676: l_msg_count || ', Message data: ' || l_msg_data);
677: END IF;

Line 685: fnd_log.string(l_log_procedure,

681: END IF;
682:
683: x_return_status := Fnd_Api.g_ret_sts_success;
684: IF (l_log_procedure >= l_log_current_level) THEN
685: fnd_log.string(l_log_procedure,
686: L_DEBUG_KEY || '.end',
687: 'Return Status = ' || x_return_status);
688: END IF;
689:

Line 818: fnd_log.string(l_log_procedure,

814: -- Standard Start of API savepoint
815: SAVEPOINT GET_VISITS_FOR_DATE_ORG;
816:
817: IF (l_log_procedure >= l_log_current_level) THEN
818: fnd_log.string(l_log_procedure,
819: l_debug_key ||'.begin',
820: ' At the start of PL SQL function. '||
821: ' Org Id = ' || p_org_sch_search_rec.ORG_ID ||
822: ' Dept Id = ' || p_org_sch_search_rec.DEPARTMENT_ID||

Line 852: fnd_log.string(l_log_statement,

848: (p_org_sch_search_rec.DEPARTMENT_ID IS NULL) OR
849: (p_org_sch_search_rec.START_FROM_DATE IS NULL) OR
850: (p_org_sch_search_rec.DISPLAY_WINDOW IS NULL) THEN
851: IF (l_log_statement >= l_log_current_level) THEN
852: fnd_log.string(l_log_statement,
853: L_DEBUG_KEY,
854: 'One of the Passed Mandatory fields is null');
855: END IF;
856: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_ORG_MANDATORY');

Line 932: fnd_log.string(l_log_statement,

928:
929: l_msg_count := Fnd_Msg_Pub.count_msg;
930: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
931: IF (l_log_statement >= l_log_current_level) THEN
932: fnd_log.string(l_log_statement,
933: L_DEBUG_KEY,
934: 'Errors from GET_VISITS_FOR_DATE_ORG. Message count: ' ||
935: l_msg_count || ', Message data: ' || l_msg_data);
936: END IF;

Line 944: fnd_log.string(l_log_procedure,

940: END IF;
941:
942: x_return_status := Fnd_Api.g_ret_sts_success;
943: IF (l_log_procedure >= l_log_current_level) THEN
944: fnd_log.string(l_log_procedure,
945: L_DEBUG_KEY || '.end',
946: 'Return Status = ' || x_return_status);
947: END IF;
948:

Line 1061: fnd_log.string(l_log_procedure,

1057: -- Standard Start of API savepoint
1058: SAVEPOINT GET_FLT_SCH_GRAPH;
1059:
1060: IF (l_log_procedure >= l_log_current_level) THEN
1061: fnd_log.string(l_log_procedure,
1062: l_debug_key ||'.begin',
1063: ' At the start of PL SQL function. '||
1064: ' Fleet Id = ' || p_flt_sch_search_rec.FLEET_ID ||
1065: ' Unit Name = ' || p_flt_sch_search_rec.UNIT_NAME||

Line 1095: fnd_log.string(l_log_statement,

1091:
1092: IF(p_flt_sch_search_rec.FLEET_ID IS NULL) OR
1093: (p_flt_sch_search_rec.DISPLAY_WINDOW IS NULL) THEN
1094: IF (l_log_statement >= l_log_current_level) THEN
1095: fnd_log.string(l_log_statement,
1096: L_DEBUG_KEY,
1097: 'Passed Mandatory fields Org id or Display window is null');
1098: END IF;
1099: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_FLEET_MANDATORY');

Line 1133: fnd_log.string(l_log_procedure,

1129: END IF;
1130: END IF;
1131:
1132: IF (l_log_procedure >= l_log_current_level) THEN
1133: fnd_log.string(l_log_procedure,
1134: l_debug_key ||'.middle',
1135: ' Before looping through rows. '||
1136: ' Loop Start date = ' || l_loop_start_date ||
1137: ' End date = ' || l_end_date ||

Line 1184: fnd_log.string(l_log_statement,

1180:
1181: l_msg_count := Fnd_Msg_Pub.count_msg;
1182: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1183: IF (l_log_statement >= l_log_current_level) THEN
1184: fnd_log.string(l_log_statement,
1185: L_DEBUG_KEY,
1186: 'Errors from GET_VISITS_FOR_DATE_FLT. Message count: ' ||
1187: l_msg_count || ', Message data: ' || l_msg_data);
1188: END IF;

Line 1196: fnd_log.string(l_log_procedure,

1192: END IF;
1193:
1194: x_return_status := Fnd_Api.g_ret_sts_success;
1195: IF (l_log_procedure >= l_log_current_level) THEN
1196: fnd_log.string(l_log_procedure,
1197: L_DEBUG_KEY || '.end',
1198: 'Return Status = ' || x_return_status);
1199: END IF;
1200:

Line 1331: fnd_log.string(l_log_procedure,

1327: -- Standard Start of API savepoint
1328: SAVEPOINT GET_VISITS_FOR_DATE_FLT;
1329:
1330: IF (l_log_procedure >= l_log_current_level) THEN
1331: fnd_log.string(l_log_procedure,
1332: l_debug_key ||'.begin',
1333: ' At the start of PL SQL function. '||
1334: ' Unit Id = ' || p_flt_sch_search_rec.UNIT_ID ||
1335: ' Minimum Duration in hours = ' || p_flt_sch_search_rec.MINIMUM_DURATION||

Line 1363: fnd_log.string(l_log_statement,

1359: (p_flt_sch_search_rec.MINIMUM_DURATION IS NULL) OR
1360: (p_flt_sch_search_rec.START_FROM_DATE IS NULL) OR
1361: (p_flt_sch_search_rec.DISPLAY_WINDOW IS NULL) THEN
1362: IF (l_log_statement >= l_log_current_level) THEN
1363: fnd_log.string(l_log_statement,
1364: L_DEBUG_KEY,
1365: 'One of the Passed Mandatory fields is null');
1366: END IF;
1367: Fnd_Message.set_name(G_APP_NAME, 'AHL_AMP_FLEET_MANDATORY');

Line 1424: fnd_log.string(l_log_statement,

1420:
1421: l_msg_count := Fnd_Msg_Pub.count_msg;
1422: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1423: IF (l_log_statement >= l_log_current_level) THEN
1424: fnd_log.string(l_log_statement,
1425: L_DEBUG_KEY,
1426: 'Errors from GET_VISITS_FOR_DATE_FLT. Message count: ' ||
1427: l_msg_count || ', Message data: ' || l_msg_data);
1428: END IF;

Line 1436: fnd_log.string(l_log_procedure,

1432: END IF;
1433:
1434: x_return_status := Fnd_Api.g_ret_sts_success;
1435: IF (l_log_procedure >= l_log_current_level) THEN
1436: fnd_log.string(l_log_procedure,
1437: L_DEBUG_KEY || '.end',
1438: 'Return Status = ' || x_return_status);
1439: END IF;
1440: