DBA Data[Home] [Help]

APPS.AMS_DMSELECTION_PVT dependencies on FND_MSG_PUB

Line 94: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

90:
91: G_STATUS_BUILDING CONSTANT VARCHAR2(30) := 'BUILDING';
92: G_STATUS_SCORING CONSTANT VARCHAR2(30) := 'SCORING';
93:
94: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
95: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
96: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
97:
98: ---- forward procedure declarations ----

Line 95: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

91: G_STATUS_BUILDING CONSTANT VARCHAR2(30) := 'BUILDING';
92: G_STATUS_SCORING CONSTANT VARCHAR2(30) := 'SCORING';
93:
94: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
95: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
96: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
97:
98: ---- forward procedure declarations ----
99:

Line 96: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

92: G_STATUS_SCORING CONSTANT VARCHAR2(30) := 'SCORING';
93:
94: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
95: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
96: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
97:
98: ---- forward procedure declarations ----
99:
100: ---------------------------------------------------------------

Line 538: FND_MSG_PUB.initialize;

534: p_log_used_by_id => p_object_id,
535: p_msg_data => L_API_NAME || ': Begin'
536: );
537:
538: FND_MSG_PUB.initialize;
539:
540: IF (AMS_DEBUG_HIGH_ON) THEN
541: AMS_Utility_PVT.debug_message ('OBJECT TYPE: ' || p_arc_object || ' OBJECT ID: ' || p_object_id);
542: END IF;

Line 726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
727: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
728: END IF;
729: END Preview_Selections;
730:

Line 727: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
727: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
728: END IF;
729: END Preview_Selections;
730:
731:

Line 781: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: */
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
783: END IF;
784: END Aggregate_Selections;
785:

Line 782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

778: */
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
783: END IF;
784: END Aggregate_Selections;
785:
786:

Line 1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: WHEN OTHERS THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1124: END IF;
1125: END populate_target_staging;
1126:

Line 1123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1120: WHEN OTHERS THEN
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1123: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1124: END IF;
1125: END populate_target_staging;
1126:
1127:

Line 1216: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: WHEN OTHERS THEN
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1218: END IF;
1219: END populate_using_sql;
1220:

Line 1217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: WHEN OTHERS THEN
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1218: END IF;
1219: END populate_using_sql;
1220:
1221:

Line 1312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: END purge_target_staging;
1316:

Line 1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: END purge_target_staging;
1316:
1317: --

Line 1394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1396: END IF;
1397: END get_customer_field;
1398:

Line 1395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1396: END IF;
1397: END get_customer_field;
1398:
1399:

Line 1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1876: END IF;
1877: END get_from_sql;
1878:

Line 1875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1876: END IF;
1877: END get_from_sql;
1878:
1879:

Line 2303: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: WHEN OTHERS THEN
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2305: END IF;
2306: END populate_targets;
2307:

Line 2304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2301: WHEN OTHERS THEN
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2304: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2305: END IF;
2306: END populate_targets;
2307:
2308:

Line 2390: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2392: END IF;
2393: END update_action_summary;
2394:

Line 2391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2392: END IF;
2393: END update_action_summary;
2394:
2395: -- Note

Line 2523: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2523: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2525: END IF;
2526: END update_source_target;
2527:

Line 2524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2523: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2525: END IF;
2526: END update_source_target;
2527:
2528:

Line 2548: l_msg_count := FND_MSG_PUB.count_msg;

2544: p_object_id => p_object_id,
2545: x_return_status => l_return_status
2546: );
2547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: l_msg_count := FND_MSG_PUB.count_msg;
2549: FOR i IN 1 .. l_msg_count LOOP
2550: AMS_Utility_PVT.create_log (
2551: x_return_status => l_return_status,
2552: p_arc_log_used_by => p_arc_object,

Line 2554: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false),

2550: AMS_Utility_PVT.create_log (
2551: x_return_status => l_return_status,
2552: p_arc_log_used_by => p_arc_object,
2553: p_log_used_by_id => p_object_id,
2554: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false),
2555: p_msg_type => 'ERROR'
2556: );
2557: END LOOP;
2558: retcode := 2;

Line 2591: l_msg_count := FND_MSG_PUB.count_msg;

2587: p_object_id => p_object_id,
2588: x_return_status => l_return_status
2589: );
2590: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2591: l_msg_count := FND_MSG_PUB.count_msg;
2592: FOR i IN 1 .. l_msg_count LOOP
2593: AMS_Utility_PVT.create_log (
2594: x_return_status => l_return_status,
2595: p_arc_log_used_by => p_arc_object,

Line 2597: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false)

2593: AMS_Utility_PVT.create_log (
2594: x_return_status => l_return_status,
2595: p_arc_log_used_by => p_arc_object,
2596: p_log_used_by_id => p_object_id,
2597: p_msg_data => FND_MSG_PUB.get(i, FND_API.g_false)
2598: );
2599: END LOOP;
2600: retcode := 2;
2601: END IF;