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.AMW_PROC_ORG_HIERARCHY_PVT dependencies on FND_MSG_PUB

Line 115: FND_MSG_PUB.initialize;

111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list )
114: THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: /* Temporarily commenting out the validata session code ..... */
119: -- =========================================================================

Line 281: FND_MSG_PUB.Count_And_Get(

277: --Debug Message
278: AMW_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'end');
279:
280: -- Standard call to get message count and if count is 1, get message info.
281: FND_MSG_PUB.Count_And_Get(
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );
285:

Line 291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO process_process_hierarchy_pub;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
298:
299: WHEN OTHERS THEN
300: ROLLBACK TO process_process_hierarchy_pub;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

298:
299: WHEN OTHERS THEN
300: ROLLBACK TO process_process_hierarchy_pub;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
305: END IF;
306: -- Standard call to get message count and if count=1, get the message

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

300: ROLLBACK TO process_process_hierarchy_pub;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
305: END IF;
306: -- Standard call to get message count and if count=1, get the message
307: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308: end process_process_hierarchy;

Line 307: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

303: THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
305: END IF;
306: -- Standard call to get message count and if count=1, get the message
307: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308: end process_process_hierarchy;
309:
310: -- ==============================================================================
311: -- Start of Comments

Line 603: FND_MSG_PUB.Count_And_Get(

599:
600: AMW_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'end');
601:
602: -- Standard call to get message count and if count is 1, get message info.
603: FND_MSG_PUB.Count_And_Get(
604: p_count => x_msg_count,
605: p_data => x_msg_data
606: );
607: end loop;

Line 615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO associate_process_org_pvt;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: -- Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
622:
623: WHEN OTHERS THEN
624: ROLLBACK TO associate_process_org_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

622:
623: WHEN OTHERS THEN
624: ROLLBACK TO associate_process_org_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
629: END IF;
630: -- Standard call to get message count and if count=1, get the message

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

624: ROLLBACK TO associate_process_org_pvt;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
629: END IF;
630: -- Standard call to get message count and if count=1, get the message
631: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:

Line 631: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

627: THEN
628: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
629: END IF;
630: -- Standard call to get message count and if count=1, get the message
631: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:
633: end associate_process_org;
634:
635: -- ==============================================================================

Line 714: FND_MSG_PUB.initialize;

710:
711: -- Initialize message list if p_init_msg_list is set to TRUE.
712: IF FND_API.to_Boolean( p_init_msg_list )
713: THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:
717: if p_do_insert = 'INSERT' then
718: open c_proc_org_s;

Line 991: FND_MSG_PUB.Count_And_Get(

987: -- Debug Message
988: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
989:
990: -- Standard call to get message count and if count is 1, get message info.
991: FND_MSG_PUB.Count_And_Get(
992: p_count => x_msg_count,
993: p_data => x_msg_data
994: );
995:

Line 1001: FND_MSG_PUB.Count_And_Get (

997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO insert_in_amwpo_pvt;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );

Line 1011: FND_MSG_PUB.Count_And_Get (

1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO insert_in_amwpo_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );

Line 1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1016:
1017: WHEN OTHERS THEN
1018: ROLLBACK TO insert_in_amwpo_pvt;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message

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

1018: ROLLBACK TO insert_in_amwpo_pvt;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,

Line 1025: FND_MSG_PUB.Count_And_Get (

1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );

Line 1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1239: exception
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: ROLLBACK;
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246: ROLLBACK;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1249:
1250: WHEN OTHERS THEN
1251: ROLLBACK;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1249:
1250: WHEN OTHERS THEN
1251: ROLLBACK;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1255: END IF;
1256: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1257:

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

1250: WHEN OTHERS THEN
1251: ROLLBACK;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1255: END IF;
1256: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1257:
1258: end process_amw_rcm_org;

Line 1256: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1255: END IF;
1256: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1257:
1258: end process_amw_rcm_org;
1259:
1260: procedure process_amw_acct_assoc(

Line 1314: FND_MSG_PUB.initialize;

1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: -- Initialize message list if p_init_msg_list is set to TRUE.
1312: IF FND_API.to_Boolean( p_init_msg_list )
1313: THEN
1314: FND_MSG_PUB.initialize;
1315: END IF;
1316:
1317: -------------------------dbms_output.put_line('In amw_risk_associations: p_assoc_mode: '||p_assoc_mode);
1318: -- =========================================================================

Line 1419: FND_MSG_PUB.Count_And_Get(

1415: ---AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1416: AMW_UTILITY_PVT.debug_message(l_api_name || '_end');
1417:
1418: -- Standard call to get message count and if count is 1, get message info.
1419: FND_MSG_PUB.Count_And_Get(
1420: p_count => x_msg_count,
1421: p_data => x_msg_data
1422: );
1423:

Line 1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO assoc_acct_pvt;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: -- Standard call to get message count and if count=1, get the message
1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1436:
1437: WHEN OTHERS THEN
1438: ROLLBACK TO assoc_acct_pvt;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1436:
1437: WHEN OTHERS THEN
1438: ROLLBACK TO assoc_acct_pvt;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1443: END IF;
1444: -- Standard call to get message count and if count=1, get the message

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

1438: ROLLBACK TO assoc_acct_pvt;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1443: END IF;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1446: end process_amw_acct_assoc;

Line 1445: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1443: END IF;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1446: end process_amw_acct_assoc;
1447:
1448: -- ==============================================================================
1449: -- Start of Comments

Line 1526: FND_MSG_PUB.initialize;

1522: x_return_status := FND_API.G_RET_STS_SUCCESS;
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: IF FND_API.to_Boolean( p_init_msg_list )
1525: THEN
1526: FND_MSG_PUB.initialize;
1527: END IF;
1528:
1529: -------------------------dbms_output.put_line('In amw_risk_associations: p_assoc_mode: '||p_assoc_mode);
1530: -- =========================================================================

Line 1655: FND_MSG_PUB.Count_And_Get(

1651: -- Debug Message
1652: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1653:
1654: -- Standard call to get message count and if count is 1, get message info.
1655: FND_MSG_PUB.Count_And_Get(
1656: p_count => x_msg_count,
1657: p_data => x_msg_data
1658: );
1659:

Line 1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1661: WHEN FND_API.G_EXC_ERROR THEN
1662: ROLLBACK TO assoc_risk_pvt;
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: -- Standard call to get message count and if count=1, get the message
1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1666:
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;
1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;
1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1672:
1673: WHEN OTHERS THEN
1674: ROLLBACK TO assoc_risk_pvt;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1672:
1673: WHEN OTHERS THEN
1674: ROLLBACK TO assoc_risk_pvt;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1677: THEN
1678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1679: END IF;
1680: -- Standard call to get message count and if count=1, get the message

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

1674: ROLLBACK TO assoc_risk_pvt;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1677: THEN
1678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1679: END IF;
1680: -- Standard call to get message count and if count=1, get the message
1681: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1682: end process_amw_risk_assoc;

Line 1681: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1677: THEN
1678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1679: END IF;
1680: -- Standard call to get message count and if count=1, get the message
1681: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1682: end process_amw_risk_assoc;
1683:
1684: -- ==============================================================================
1685: -- Start of Comments

Line 1759: FND_MSG_PUB.initialize;

1755:
1756: -- Initialize message list if p_init_msg_list is set to TRUE.
1757: IF FND_API.to_Boolean( p_init_msg_list )
1758: THEN
1759: FND_MSG_PUB.initialize;
1760: END IF;
1761:
1762: -- =========================================================================
1763: -- Validate Environment

Line 1872: FND_MSG_PUB.Count_And_Get(

1868: -- Debug Message
1869: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1870:
1871: -- Standard call to get message count and if count is 1, get message info.
1872: FND_MSG_PUB.Count_And_Get(
1873: p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );
1876:

Line 1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO assoc_control_pvt;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1887: -- Standard call to get message count and if count=1, get the message
1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO assoc_control_pvt;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1893: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO assoc_control_pvt;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1894: THEN
1895: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1896: END IF;
1897: -- Standard call to get message count and if count=1, get the message

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

1891: ROLLBACK TO assoc_control_pvt;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1894: THEN
1895: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1896: END IF;
1897: -- Standard call to get message count and if count=1, get the message
1898: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1899: end process_amw_control_assoc;

Line 1898: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1894: THEN
1895: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1896: END IF;
1897: -- Standard call to get message count and if count=1, get the message
1898: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1899: end process_amw_control_assoc;
1900:
1901: -- ==============================================================================
1902: -- Start of Comments

Line 1990: FND_MSG_PUB.initialize;

1986:
1987: -- Initialize message list if p_init_msg_list is set to TRUE.
1988: IF FND_API.to_Boolean( p_init_msg_list )
1989: THEN
1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:
1993: -- =========================================================================
1994: -- Validate Environment

Line 2093: FND_MSG_PUB.Count_And_Get(

2089: -- Debug Message
2090: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2091:
2092: -- Standard call to get message count and if count is 1, get message info.
2093: FND_MSG_PUB.Count_And_Get(
2094: p_count => x_msg_count,
2095: p_data => x_msg_data
2096: );
2097:

Line 2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO assoc_ap_pvt;
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: -- Standard call to get message count and if count=1, get the message
2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2104:
2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2108: -- Standard call to get message count and if count=1, get the message
2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN OTHERS THEN
2112: ROLLBACK TO assoc_ap_pvt;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2110:
2111: WHEN OTHERS THEN
2112: ROLLBACK TO assoc_ap_pvt;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2115: THEN
2116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2117: END IF;
2118: -- Standard call to get message count and if count=1, get the message

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

2112: ROLLBACK TO assoc_ap_pvt;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2115: THEN
2116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2117: END IF;
2118: -- Standard call to get message count and if count=1, get the message
2119: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2120: end process_amw_ap_assoc;

Line 2119: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2115: THEN
2116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2117: END IF;
2118: -- Standard call to get message count and if count=1, get the message
2119: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2120: end process_amw_ap_assoc;
2121:
2122: -- ==============================================================================
2123: -- Start of Comments

Line 2285: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2281:
2282: --Debug Message
2283: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || ' end');
2284: -- Standard call to get message count and if count is 1, get message info.
2285: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2286: p_data => x_msg_data);
2287:
2288: EXCEPTION
2289: WHEN fnd_api.g_exc_error THEN

Line 2293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

2289: WHEN fnd_api.g_exc_error THEN
2290: ROLLBACK TO process_hierarchy_count;
2291: x_return_status := fnd_api.g_ret_sts_error;
2292: -- Standard call to get message count and if count=1, get the message
2293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2294: p_count => x_msg_count,
2295: p_data => x_msg_data
2296: );
2297: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2301: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

2297: WHEN fnd_api.g_exc_unexpected_error THEN
2298: ROLLBACK TO process_hierarchy_count;
2299: x_return_status := fnd_api.g_ret_sts_unexp_error;
2300: -- Standard call to get message count and if count=1, get the message
2301: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data
2304: );
2305: WHEN OTHERS THEN

Line 2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2304: );
2305: WHEN OTHERS THEN
2306: ROLLBACK TO process_hierarchy_count;
2307: x_return_status := fnd_api.g_ret_sts_unexp_error;
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2309: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2310: END IF;
2311: -- Standard call to get message count and if count=1, get the message
2312: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

Line 2309: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2305: WHEN OTHERS THEN
2306: ROLLBACK TO process_hierarchy_count;
2307: x_return_status := fnd_api.g_ret_sts_unexp_error;
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2309: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2310: END IF;
2311: -- Standard call to get message count and if count=1, get the message
2312: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2313: p_count => x_msg_count,

Line 2312: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,

2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2309: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2310: END IF;
2311: -- Standard call to get message count and if count=1, get the message
2312: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2313: p_count => x_msg_count,
2314: p_data => x_msg_data
2315: );
2316: END process_hierarchy_count;

Line 2374: FND_MSG_PUB.initialize;

2370:
2371: -- Initialize message list if p_init_msg_list is set to TRUE.
2372: IF FND_API.to_Boolean( p_init_msg_list )
2373: THEN
2374: FND_MSG_PUB.initialize;
2375: END IF;
2376:
2377: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2378: check_apo_row(

Line 2401: FND_MSG_PUB.Count_And_Get(

2397: -- Debug Message
2398: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2399:
2400: -- Standard call to get message count and if count is 1, get message info.
2401: FND_MSG_PUB.Count_And_Get(
2402: p_count => x_msg_count,
2403: p_data => x_msg_data
2404: );
2405: EXCEPTION

Line 2415: FND_MSG_PUB.Count_And_Get (

2411: WHEN FND_API.G_EXC_ERROR THEN
2412: ROLLBACK TO VALIDATE_Process_pvt;
2413: x_return_status := FND_API.G_RET_STS_ERROR;
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (
2416: p_encoded => FND_API.G_FALSE,
2417: p_count => x_msg_count,
2418: p_data => x_msg_data
2419: );

Line 2425: FND_MSG_PUB.Count_And_Get (

2421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2422: ROLLBACK TO VALIDATE_Process_pvt;
2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2424: -- Standard call to get message count and if count=1, get the message
2425: FND_MSG_PUB.Count_And_Get (
2426: p_encoded => FND_API.G_FALSE,
2427: p_count => x_msg_count,
2428: p_data => x_msg_data
2429: );

Line 2434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2430:
2431: WHEN OTHERS THEN
2432: ROLLBACK TO VALIDATE_Process_pvt;
2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2435: THEN
2436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2437: END IF;
2438: -- Standard call to get message count and if count=1, get the message

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

2432: ROLLBACK TO VALIDATE_Process_pvt;
2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2435: THEN
2436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2437: END IF;
2438: -- Standard call to get message count and if count=1, get the message
2439: FND_MSG_PUB.Count_And_Get (
2440: p_encoded => FND_API.G_FALSE,

Line 2439: FND_MSG_PUB.Count_And_Get (

2435: THEN
2436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2437: END IF;
2438: -- Standard call to get message count and if count=1, get the message
2439: FND_MSG_PUB.Count_And_Get (
2440: p_encoded => FND_API.G_FALSE,
2441: p_count => x_msg_count,
2442: p_data => x_msg_data
2443: );

Line 2539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2535:
2536: WHEN OTHERS THEN
2537: -- ROLLBACK TO assoc_ap_pvt;
2538: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2540: THEN
2541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2542: END IF;
2543: ----dbms_output.put_line('EXCEPTION');

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

2537: -- ROLLBACK TO assoc_ap_pvt;
2538: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2540: THEN
2541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2542: END IF;
2543: ----dbms_output.put_line('EXCEPTION');
2544: RAISE;
2545: -- Standard call to get message count and if count=1, get the message

Line 2546: -- FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

2542: END IF;
2543: ----dbms_output.put_line('EXCEPTION');
2544: RAISE;
2545: -- Standard call to get message count and if count=1, get the message
2546: -- FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2547: /*
2548: when no_data_found then
2549: return null;
2550: when others then