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.AMS_ACT_LIST_PVT dependencies on FND_MESSAGE

Line 199: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');

195: IF (AMS_DEBUG_HIGH_ON) THEN
196: AMS_Utility_PVT.debug_message('FROM:' || l_found);
197: END IF;
198: IF l_found = 'N' THEN
199: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
200: FND_MSG_PUB.Add;
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:

Line 222: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');

218: IF (AMS_DEBUG_HIGH_ON) THEN
219: AMS_Utility_PVT.debug_message('MASTER_TYPE:' || l_found);
220: END IF;
221: IF nvl(l_found,'N') = 'N' THEN
222: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
223: FND_MSG_PUB.Add;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226: END IF;

Line 239: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');

235:
236:
237: EXCEPTION
238: WHEN FND_API.G_EXC_ERROR THEN
239: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
240: FND_MSG_PUB.Add;
241: -- Check if reset of the status is required
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243: FND_MSG_PUB.count_and_get(

Line 249: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');

245: p_count => x_msg_count,
246: p_data => x_msg_data);
247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
250: FND_MSG_PUB.Add;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: FND_MSG_PUB.count_and_get(
253: p_encoded => FND_API.g_false,

Line 258: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');

254: p_count => x_msg_count,
255: p_data => x_msg_data);
256:
257: WHEN OTHERS THEN
258: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CREATE_LIST_ERROR');
259: FND_MSG_PUB.Add;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261: FND_MSG_PUB.count_and_get(
262: p_encoded => FND_API.g_false,

Line 436: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');

432: IF l_action_type <> FND_API.G_MISS_CHAR
433: AND l_action_type IS NOT NULL THEN
434: IF(l_action_type <>'INCLUDE')THEN
435: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
436: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
437: FND_MSG_PUB.Add;
438: END IF;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: RAISE FND_API.G_EXC_ERROR;

Line 875: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');

871: IF l_action_type <> FND_API.G_MISS_CHAR
872: AND l_action_type IS NOT NULL THEN
873: IF(l_action_type <>'INCLUDE')THEN
874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
875: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
876: FND_MSG_PUB.Add;
877: END IF;
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: RAISE FND_API.G_EXC_ERROR;

Line 1161: FND_MESSAGE.set_name('AMS', 'AMS_DELETE_TARGET');

1157: END IF;
1158:
1159: -- Invoke table handler(AMS_ACT_LISTS_PKG.Delete_Row)
1160: if l_char = 'x' then
1161: FND_MESSAGE.set_name('AMS', 'AMS_DELETE_TARGET');
1162: FND_MSG_PUB.add;
1163: RAISE FND_API.g_exc_error;
1164: else
1165: AMS_ACT_LISTS_PKG.Delete_Row(

Line 1296: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1292:
1293: IF (c_Act_List%NOTFOUND) THEN
1294: CLOSE c_Act_List;
1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1296: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1297: FND_MSG_PUB.add;
1298: END IF;
1299: RAISE FND_API.g_exc_error;
1300: END IF;

Line 1458: FND_MESSAGE.set_token('MISS_FIELD',

1454: IF p_act_list_rec.list_header_id = FND_API.g_miss_num OR
1455: p_act_list_rec.list_header_id IS NULL THEN
1456: AMS_Utility_PVT.Error_Message(p_message_name =>
1457: 'AMS_API_MISSING_FIELD');
1458: FND_MESSAGE.set_token('MISS_FIELD',
1459: 'LIST_HEADER_ID' );
1460: x_return_status := FND_API.g_ret_sts_error;
1461: RETURN;
1462: END IF;

Line 1478: FND_MESSAGE.set_token('MISS_FIELD',

1474: IF p_act_list_rec.list_used_by = FND_API.g_miss_char OR
1475: p_act_list_rec.list_used_by IS NULL THEN
1476: AMS_Utility_PVT.Error_Message(p_message_name =>
1477: 'AMS_API_MISSING_FIELD');
1478: FND_MESSAGE.set_token('MISS_FIELD',
1479: 'LIST_USED_BY' );
1480: x_return_status := FND_API.g_ret_sts_error;
1481: RETURN;
1482: END IF;

Line 1487: FND_MESSAGE.set_token('MISS_FIELD',

1483: IF p_act_list_rec.list_act_type = FND_API.g_miss_char OR
1484: p_act_list_rec.list_act_type IS NULL THEN
1485: AMS_Utility_PVT.Error_Message(p_message_name =>
1486: 'AMS_API_MISSING_FIELD');
1487: FND_MESSAGE.set_token('MISS_FIELD',
1488: 'LIST_ACT_TYPE' );
1489: x_return_status := FND_API.g_ret_sts_error;
1490: RETURN;
1491: END IF;

Line 1499: FND_MESSAGE.set_token('MISS_FIELD',

1495: /* Update Record */
1496: IF p_act_list_rec.act_list_header_id IS NULL THEN
1497: AMS_Utility_PVT.Error_Message(p_message_name =>
1498: 'AMS_API_MISSING_FIELD');
1499: FND_MESSAGE.set_token('MISS_FIELD',
1500: 'ACT_LIST_HEADER_ID' );
1501: x_return_status := FND_API.g_ret_sts_error;
1502: RETURN;
1503: END IF;

Line 1576: FND_MESSAGE.set_name('AMS', 'AMS_SCHEDULE_ID_MISSING');

1572:
1573: ELSE
1574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1575: THEN
1576: FND_MESSAGE.set_name('AMS', 'AMS_SCHEDULE_ID_MISSING');
1577: FND_MSG_PUB.Add;
1578: END IF;
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: RAISE FND_API.G_EXC_ERROR;

Line 1612: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ID_MISSING');

1608:
1609: ELSE
1610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1611: THEN
1612: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ID_MISSING');
1613: FND_MSG_PUB.Add;
1614: END IF;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: RAISE FND_API.G_EXC_ERROR;

Line 1640: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');

1636: ) = FND_API.g_false
1637: THEN
1638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1639: THEN
1640: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1641: FND_MESSAGE.set_token('LIST_ACT_TYPE',
1642: p_act_list_rec.list_act_type);
1643: FND_MSG_PUB.add;
1644: END IF;

Line 1641: FND_MESSAGE.set_token('LIST_ACT_TYPE',

1637: THEN
1638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1639: THEN
1640: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1641: FND_MESSAGE.set_token('LIST_ACT_TYPE',
1642: p_act_list_rec.list_act_type);
1643: FND_MSG_PUB.add;
1644: END IF;
1645:

Line 1661: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');

1657: ) = FND_API.g_false
1658: THEN
1659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1660: THEN
1661: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1662: FND_MESSAGE.set_token('LIST_ACT_TYPE', p_act_list_rec.list_action_type);
1663: FND_MSG_PUB.add;
1664: END IF;
1665:

Line 1662: FND_MESSAGE.set_token('LIST_ACT_TYPE', p_act_list_rec.list_action_type);

1658: THEN
1659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1660: THEN
1661: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_TYPE_INVALID');
1662: FND_MESSAGE.set_token('LIST_ACT_TYPE', p_act_list_rec.list_action_type);
1663: FND_MSG_PUB.add;
1664: END IF;
1665:
1666: x_return_status := FND_API.g_ret_sts_error;

Line 1957: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

1953:
1954: -- Debug Message
1955: /*
1956: IF (AMS_DEBUG_HIGH_ON) THEN
1957: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1958: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
1959: FND_MSG_PUB.Add;
1960: END IF;
1961: */

Line 1958: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);

1954: -- Debug Message
1955: /*
1956: IF (AMS_DEBUG_HIGH_ON) THEN
1957: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
1958: FND_MESSAGE.Set_Token('TEXT', 'AMS_ListGeneration_PKG.cerate_list: Start', TRUE);
1959: FND_MSG_PUB.Add;
1960: END IF;
1961: */
1962: -- Initialize API return status to success

Line 2019: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');

2015: -- Success Message
2016: -- MMSG
2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2018: THEN
2019: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2020: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2021: FND_MSG_PUB.Add;
2022: END IF;
2023:

Line 2020: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');

2016: -- MMSG
2017: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2018: THEN
2019: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2020: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2021: FND_MSG_PUB.Add;
2022: END IF;
2023:
2024:

Line 2026: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2022: END IF;
2023:
2024:
2025: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2026: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2027: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2028: FND_MSG_PUB.Add;
2029: END IF; */
2030: FND_MSG_PUB.count_and_get(

Line 2027: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');

2023:
2024:
2025: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2026: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2027: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2028: FND_MSG_PUB.Add;
2029: END IF; */
2030: FND_MSG_PUB.count_and_get(
2031: p_encoded => FND_API.g_false,

Line 2038: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2034: );
2035:
2036: EXCEPTION
2037: WHEN FND_API.G_EXC_ERROR THEN
2038: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2039: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2040: FND_MSG_PUB.Add;
2041: -- Check if reset of the status is required
2042: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2039: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

2035:
2036: EXCEPTION
2037: WHEN FND_API.G_EXC_ERROR THEN
2038: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2039: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2040: FND_MSG_PUB.Add;
2041: -- Check if reset of the status is required
2042: x_return_status := FND_API.G_RET_STS_ERROR ;
2043: FND_MSG_PUB.count_and_get(

Line 2049: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2045: p_count => x_msg_count,
2046: p_data => x_msg_data);
2047:
2048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2049: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2050: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2051: FND_MSG_PUB.Add;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2053: FND_MSG_PUB.count_and_get(

Line 2050: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

2046: p_data => x_msg_data);
2047:
2048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2049: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2050: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2051: FND_MSG_PUB.Add;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2053: FND_MSG_PUB.count_and_get(
2054: p_encoded => FND_API.g_false,

Line 2059: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2055: p_count => x_msg_count,
2056: p_data => x_msg_data);
2057:
2058: WHEN OTHERS THEN
2059: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2060: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2061: FND_MSG_PUB.Add;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2063: FND_MSG_PUB.count_and_get(

Line 2060: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

2056: p_data => x_msg_data);
2057:
2058: WHEN OTHERS THEN
2059: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2060: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2061: FND_MSG_PUB.Add;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2063: FND_MSG_PUB.count_and_get(
2064: p_encoded => FND_API.g_false,

Line 2477: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

2473:
2474: -- Debug Message
2475: /* ckapoor
2476: IF (AMS_DEBUG_HIGH_ON) THEN
2477: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2478: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: Start', TRUE);
2479: FND_MSG_PUB.Add;
2480: END IF; */
2481:

Line 2478: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: Start', TRUE);

2474: -- Debug Message
2475: /* ckapoor
2476: IF (AMS_DEBUG_HIGH_ON) THEN
2477: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2478: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: Start', TRUE);
2479: FND_MSG_PUB.Add;
2480: END IF; */
2481:
2482: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2526: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');

2522: RAISE FND_API.G_EXC_ERROR;
2523: end if;
2524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2525: THEN
2526: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2527: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Entry_PVT.Update_ListEntry_Source_Code', TRUE);
2528: FND_MSG_PUB.Add;
2529: END IF;
2530:

Line 2527: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Entry_PVT.Update_ListEntry_Source_Code', TRUE);

2523: end if;
2524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2525: THEN
2526: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
2527: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Entry_PVT.Update_ListEntry_Source_Code', TRUE);
2528: FND_MSG_PUB.Add;
2529: END IF;
2530:
2531:

Line 2533: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');

2529: END IF;
2530:
2531:
2532: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2533: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2534: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: END', TRUE);
2535: FND_MSG_PUB.Add;
2536: END IF; */
2537:

Line 2534: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: END', TRUE);

2530:
2531:
2532: /* ckapoor IF (AMS_DEBUG_HIGH_ON) THEN
2533: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2534: FND_MESSAGE.Set_Token('ROW', 'Update_Source_Code: END', TRUE);
2535: FND_MSG_PUB.Add;
2536: END IF; */
2537:
2538:

Line 2943: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2939: p_level =>'LOW');*/
2940: end if;
2941: -- --------------------------------------------------------
2942: IF (AMS_DEBUG_HIGH_ON) THEN
2943: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2944: FND_MESSAGE.Set_Token('TEXT', 'AMS_LISTGENERATION_PKG.cerate_list: Start', TRUE);
2945: FND_MSG_PUB.Add;
2946: END IF;
2947: write_to_act_log(p_msg_data => 'Target Group available ' ,

Line 2944: FND_MESSAGE.Set_Token('TEXT', 'AMS_LISTGENERATION_PKG.cerate_list: Start', TRUE);

2940: end if;
2941: -- --------------------------------------------------------
2942: IF (AMS_DEBUG_HIGH_ON) THEN
2943: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2944: FND_MESSAGE.Set_Token('TEXT', 'AMS_LISTGENERATION_PKG.cerate_list: Start', TRUE);
2945: FND_MSG_PUB.Add;
2946: END IF;
2947: write_to_act_log(p_msg_data => 'Target Group available ' ,
2948: p_arc_log_used_by => 'LIST',

Line 2966: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');

2962: -- Success Message
2963: -- MMSG
2964: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2965: THEN
2966: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2967: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2968: FND_MSG_PUB.Add;
2969: END IF;
2970:

Line 2967: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');

2963: -- MMSG
2964: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2965: THEN
2966: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
2967: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
2968: FND_MSG_PUB.Add;
2969: END IF;
2970:
2971: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2972: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2968: FND_MSG_PUB.Add;
2969: END IF;
2970:
2971: IF (AMS_DEBUG_HIGH_ON) THEN
2972: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2973: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2974: FND_MSG_PUB.Add;
2975: END IF;
2976: FND_MSG_PUB.count_and_get(

Line 2973: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');

2969: END IF;
2970:
2971: IF (AMS_DEBUG_HIGH_ON) THEN
2972: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2973: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
2974: FND_MSG_PUB.Add;
2975: END IF;
2976: FND_MSG_PUB.count_and_get(
2977: p_encoded => FND_API.g_false,

Line 2984: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2980: );
2981:
2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2984: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2985: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2986: FND_MSG_PUB.Add;
2987: -- Check if reset of the status is required
2988: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2985: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

2981:
2982: EXCEPTION
2983: WHEN FND_API.G_EXC_ERROR THEN
2984: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2985: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2986: FND_MSG_PUB.Add;
2987: -- Check if reset of the status is required
2988: x_return_status := FND_API.G_RET_STS_ERROR ;
2989: FND_MSG_PUB.count_and_get(

Line 2995: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

2991: p_count => x_msg_count,
2992: p_data => x_msg_data);
2993:
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2996: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2997: FND_MSG_PUB.Add;
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2999: FND_MSG_PUB.count_and_get(

Line 2996: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

2992: p_data => x_msg_data);
2993:
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
2996: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
2997: FND_MSG_PUB.Add;
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2999: FND_MSG_PUB.count_and_get(
3000: p_encoded => FND_API.g_false,

Line 3005: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

3001: p_count => x_msg_count,
3002: p_data => x_msg_data);
3003:
3004: WHEN OTHERS THEN
3005: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3006: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3007: FND_MSG_PUB.Add;
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3009: FND_MSG_PUB.count_and_get(

Line 3006: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

3002: p_data => x_msg_data);
3003:
3004: WHEN OTHERS THEN
3005: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3006: FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3007: FND_MSG_PUB.Add;
3008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3009: FND_MSG_PUB.count_and_get(
3010: p_encoded => FND_API.g_false,

Line 3079: FND_MESSAGE.Set_Name('AMS','AMS_GENERATING');

3075: OPEN c_status ;
3076: FETCH c_status INTO l_status_code;
3077: CLOSE c_status ;
3078: IF l_status_code = 'GENERATING' THEN
3079: FND_MESSAGE.Set_Name('AMS','AMS_GENERATING');
3080: FND_MSG_PUB.Add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: END IF;
3083:

Line 3119: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');

3115: -- Success Message
3116: -- MMSG
3117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3118: THEN
3119: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
3120: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
3121: FND_MSG_PUB.Add;
3122: END IF;
3123:

Line 3120: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');

3116: -- MMSG
3117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3118: THEN
3119: FND_MESSAGE.Set_Name('AMS', 'AMS_API_SUCCESS');
3120: FND_MESSAGE.Set_Token('ROW', 'AMS_ACT_LIST.list_creation: ');
3121: FND_MSG_PUB.Add;
3122: END IF;
3123:
3124: /*

Line 3126: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

3122: END IF;
3123:
3124: /*
3125: IF (AMS_DEBUG_HIGH_ON) THEN
3126: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3127: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
3128: FND_MSG_PUB.Add;
3129: END IF;
3130: */

Line 3127: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');

3123:
3124: /*
3125: IF (AMS_DEBUG_HIGH_ON) THEN
3126: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3127: FND_MESSAGE.Set_Token('TEXT', 'AMS_ACT_LIST.list_act_creation: END');
3128: FND_MSG_PUB.Add;
3129: END IF;
3130: */
3131: FND_MSG_PUB.count_and_get(

Line 3138: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

3134: p_data => x_msg_data
3135: );
3136: EXCEPTION
3137: WHEN FND_API.G_EXC_ERROR THEN
3138: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3139: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3140: --FND_MSG_PUB.Add;
3141: -- Check if reset of the status is required
3142: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3139: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

3135: );
3136: EXCEPTION
3137: WHEN FND_API.G_EXC_ERROR THEN
3138: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3139: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3140: --FND_MSG_PUB.Add;
3141: -- Check if reset of the status is required
3142: x_return_status := FND_API.G_RET_STS_ERROR ;
3143: FND_MSG_PUB.count_and_get(

Line 3149: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

3145: p_count => x_msg_count,
3146: p_data => x_msg_data);
3147:
3148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3149: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3150: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3151: --FND_MSG_PUB.Add;
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: FND_MSG_PUB.count_and_get(

Line 3150: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

3146: p_data => x_msg_data);
3147:
3148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3149: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3150: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3151: --FND_MSG_PUB.Add;
3152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3153: FND_MSG_PUB.count_and_get(
3154: p_encoded => FND_API.g_false,

Line 3159: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

3155: p_count => x_msg_count,
3156: p_data => x_msg_data);
3157:
3158: WHEN OTHERS THEN
3159: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3160: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3161: --FND_MSG_PUB.Add;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3163: FND_MSG_PUB.count_and_get(

Line 3160: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);

3156: p_data => x_msg_data);
3157:
3158: WHEN OTHERS THEN
3159: --FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');
3160: --FND_MESSAGE.Set_Token('TEXT', sqlerrm||' '||sqlcode);
3161: --FND_MSG_PUB.Add;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3163: FND_MSG_PUB.count_and_get(
3164: p_encoded => FND_API.g_false,

Line 3599: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');

3595: x_position =>l_from_position,
3596: x_counter => l_from_counter) ;
3597:
3598: if l_found = 'N' then
3599: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
3600: FND_MSG_PUB.Add;
3601: RAISE FND_API.G_EXC_ERROR;
3602: end if;
3603: write_to_act_log('Process_all_sql: FROM Position ->'|| l_from_position ||

Line 3618: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');

3614: x_found=> l_found,
3615: x_source_object_name => l_source_object_name,
3616: x_source_object_pk_field => l_source_object_pk_field);
3617: if l_found = 'N' then
3618: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
3619: FND_MSG_PUB.Add;
3620: RAISE FND_API.G_EXC_ERROR;
3621: end if;
3622: --write_to_act_log('Process_all_sql: Master Type->'|| l_master_type ||'<--' );