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

Line 108: FND_MSG_PUB.initialize;

104: END IF;
105:
106: -- initialize message list if p_init_msg_list is set to TRUE.
107: IF FND_API.to_boolean(p_init_msg_list) THEN
108: FND_MSG_PUB.initialize;
109: END IF;
110:
111: begin
112: do_create_address(

Line 160: FND_MSG_PUB.count_and_get(

156: commit;
157: END IF;
158:
159: -- standard call to get message count and if count is 1, get message info
160: FND_MSG_PUB.count_and_get(
161: p_encoded => FND_API.G_FALSE,
162: p_count => x_msg_count,
163: p_data => x_msg_data
164: );

Line 178: FND_MSG_PUB.count_and_get(

174: --IBE_UTIL.enable_debug();
175:
176: ROLLBACK TO create_address_pvt;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MSG_PUB.count_and_get(
179: p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data
182: );

Line 198: FND_MSG_PUB.count_and_get(

194: --IBE_UTIL.enable_debug();
195:
196: ROLLBACK TO create_address_pvt;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: FND_MSG_PUB.count_and_get(
199: p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data
202: );

Line 218: FND_MSG_PUB.count_and_get(

214: --IBE_UTIL.enable_debug();
215:
216: ROLLBACK TO create_address_pvt;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.count_and_get(
219: p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data
222: );

Line 304: FND_MSG_PUB.initialize;

300: END IF;
301:
302: -- initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_boolean(p_init_msg_list) THEN
304: FND_MSG_PUB.initialize;
305: END IF;
306:
307: --
308: -- Check if anything is changed before decide what to do

Line 735: FND_MSG_PUB.count_and_get(

731: commit;
732: END IF;
733:
734: -- standard call to get message count and if count is 1, get message info
735: FND_MSG_PUB.count_and_get(
736: p_encoded => FND_API.G_FALSE,
737: p_count => x_msg_count,
738: p_data => x_msg_data
739: );

Line 753: FND_MSG_PUB.count_and_get(

749: --IBE_UTIL.enable_debug();
750:
751: ROLLBACK TO update_address_pvt;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MSG_PUB.count_and_get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data
757: );

Line 773: FND_MSG_PUB.count_and_get(

769: --IBE_UTIL.enable_debug();
770:
771: ROLLBACK TO update_address_pvt;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.count_and_get(
774: p_encoded => FND_API.G_FALSE,
775: p_count => x_msg_count,
776: p_data => x_msg_data
777: );

Line 793: FND_MSG_PUB.count_and_get(

789: --IBE_UTIL.enable_debug();
790:
791: ROLLBACK TO update_address_pvt;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: FND_MSG_PUB.count_and_get(
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );

Line 853: FND_MSG_PUB.initialize;

849: END IF;
850:
851: -- initialize message list if p_init_msg_list is set to TRUE.
852: IF FND_API.to_boolean(p_init_msg_list) THEN
853: FND_MSG_PUB.initialize;
854: END IF;
855:
856: --
857: -- delete the address

Line 920: FND_MSG_PUB.count_and_get(

916: commit;
917: END IF;
918:
919: -- standard call to get message count and if count is 1, get message info
920: FND_MSG_PUB.count_and_get(
921: p_encoded => FND_API.G_FALSE,
922: p_count => x_msg_count,
923: p_data => x_msg_data
924: );

Line 938: FND_MSG_PUB.count_and_get(

934: --IBE_UTIL.enable_debug();
935:
936: ROLLBACK TO delete_address_pvt;
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: FND_MSG_PUB.count_and_get(
939: p_encoded => FND_API.G_FALSE,
940: p_count => x_msg_count,
941: p_data => x_msg_data
942: );

Line 958: FND_MSG_PUB.count_and_get(

954: --IBE_UTIL.enable_debug();
955:
956: ROLLBACK TO delete_address_pvt;
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: FND_MSG_PUB.count_and_get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data
962: );

Line 978: FND_MSG_PUB.count_and_get(

974: --IBE_UTIL.enable_debug();
975:
976: ROLLBACK TO delete_address_pvt;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.count_and_get(
979: p_encoded => FND_API.G_FALSE,
980: p_count => x_msg_count,
981: p_data => x_msg_data
982: );

Line 1051: FND_MSG_PUB.initialize;

1047: END IF;
1048:
1049: -- initialize message list if p_init_msg_list is set to TRUE.
1050: IF FND_API.to_boolean(p_init_msg_list) THEN
1051: FND_MSG_PUB.initialize;
1052: END IF;
1053:
1054: -- try finding an existing party site use
1055:

Line 1128: FND_MSG_PUB.count_and_get(

1124: commit;
1125: END IF;
1126:
1127: -- standard call to get message count and if count is 1, get message info
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );

Line 1146: FND_MSG_PUB.count_and_get(

1142: --IBE_UTIL.enable_debug();
1143:
1144: ROLLBACK TO set_address__usage_pvt;
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: FND_MSG_PUB.count_and_get(
1147: p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data
1150: );

Line 1166: FND_MSG_PUB.count_and_get(

1162: --IBE_UTIL.enable_debug();
1163:
1164: ROLLBACK TO set_address__usage_pvt;
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: FND_MSG_PUB.count_and_get(
1167: p_encoded => FND_API.G_FALSE,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data
1170: );

Line 1186: FND_MSG_PUB.count_and_get(

1182: --IBE_UTIL.enable_debug();
1183:
1184: ROLLBACK TO set_address__usage_pvt;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: FND_MSG_PUB.count_and_get(
1187: p_encoded => FND_API.G_FALSE,
1188: p_count => x_msg_count,
1189: p_data => x_msg_data
1190: );

Line 1394: FND_MSG_PUB.initialize;

1390: END IF;
1391:
1392: -- initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_boolean(p_init_msg_list) THEN
1394: FND_MSG_PUB.initialize;
1395: END IF;
1396:
1397: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1398: IBE_UTIL.debug('p_site_use_type = '||p_site_use_type);

Line 1470: FND_MSG_PUB.count_and_get(

1466: commit;
1467: END IF;
1468:
1469: -- standard call to get message count and if count is 1, get message info
1470: FND_MSG_PUB.count_and_get(
1471: p_encoded => FND_API.G_FALSE,
1472: p_count => x_msg_count,
1473: p_data => x_msg_data
1474: );

Line 1489: FND_MSG_PUB.count_and_get(

1485: --IBE_UTIL.enable_debug();
1486:
1487: ROLLBACK TO get_primary_addr_id_pvt;
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489: FND_MSG_PUB.count_and_get(
1490: p_encoded => FND_API.G_FALSE,
1491: p_count => x_msg_count,
1492: p_data => x_msg_data
1493: );

Line 1544: FND_MSG_PUB.initialize;

1540: END IF;
1541:
1542: -- initialize message list if p_init_msg_list is set to TRUE.
1543: IF FND_API.to_boolean(p_init_msg_list) THEN
1544: FND_MSG_PUB.initialize;
1545: END IF;
1546:
1547: BEGIN
1548: SELECT DISTINCT

Line 1581: FND_MSG_PUB.count_and_get(

1577: commit;
1578: END IF;
1579:
1580: -- standard call to get message count and if count is 1, get message info
1581: FND_MSG_PUB.count_and_get(
1582: p_encoded => FND_API.G_FALSE,
1583: p_count => x_msg_count,
1584: p_data => x_msg_data
1585: );

Line 1599: FND_MSG_PUB.count_and_get(

1595: --IBE_UTIL.enable_debug();
1596:
1597: ROLLBACK TO get_primary_address_pvt;
1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1599: FND_MSG_PUB.count_and_get(
1600: p_encoded => FND_API.G_FALSE,
1601: p_count => x_msg_count,
1602: p_data => x_msg_data
1603: );

Line 2332: FND_MSG_PUB.initialize;

2328: END IF;
2329:
2330: -- Initialize message list if p_init_msg_list is set to TRUE.
2331: IF FND_API.to_Boolean(p_init_msg_list) THEN
2332: FND_MSG_PUB.initialize;
2333: END IF;
2334:
2335: -- Initialize API return status to success
2336: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2347: FND_MSG_PUB.Add;

2343: IF (c1%NOTFOUND) THEN
2344: CLOSE c1;
2345: FND_MESSAGE.Set_Name('IBE', 'IBE_OU_GET_PSITE_COUNTRY_FAIL');
2346: FND_MESSAGE.Set_Token('PARTY_SITE_ID', p_party_site_id);
2347: FND_MSG_PUB.Add;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: CLOSE c1;
2351:

Line 2427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2423: EXCEPTION
2424:
2425: WHEN FND_API.G_EXC_ERROR THEN
2426: x_return_status := FND_API.G_RET_STS_ERROR;
2427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2428: p_data => x_msg_data,
2429: p_encoded => 'F');
2430:
2431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2433: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2429: p_encoded => 'F');
2430:
2431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2434: p_data => x_msg_data,
2435: p_encoded => 'F');
2436:
2437: WHEN OTHERS THEN

Line 2442: FND_MSG_PUB.Add;

2438: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2439: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2440: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2441: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2442: FND_MSG_PUB.Add;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444:
2445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2446: THEN

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

2441: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2442: FND_MSG_PUB.Add;
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444:
2445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2446: THEN
2447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2448: END IF;
2449:

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

2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444:
2445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2446: THEN
2447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2448: END IF;
2449:
2450: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2451: p_data => x_msg_data,

Line 2450: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2446: THEN
2447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2448: END IF;
2449:
2450: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2451: p_data => x_msg_data,
2452: p_encoded => 'F');
2453:
2454: END;

Line 2526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2522: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the expected exception block ');
2523: END IF;
2524:
2525: x_return_status := FND_API.G_RET_STS_ERROR;
2526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2527: p_data => x_msg_data,
2528: p_encoded => 'F');
2529:
2530: for k in 1 .. x_msg_count loop

Line 2531: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,

2527: p_data => x_msg_data,
2528: p_encoded => 'F');
2529:
2530: for k in 1 .. x_msg_count loop
2531: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,
2532: p_encoded => 'F');
2533:
2534: IBE_UTIL.debug('Error msg: '||substr(lx_msg_data,1,240));
2535: end loop;

Line 2544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2540: IBE_UTIL.debug('IBE_ADDRESS_V2PVT.copy_pary_site:In the unexpected exception block ');
2541: END IF;
2542:
2543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2545: p_data => x_msg_data,
2546: p_encoded => 'F');
2547:
2548: for k in 1 .. x_msg_count loop

Line 2549: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,

2545: p_data => x_msg_data,
2546: p_encoded => 'F');
2547:
2548: for k in 1 .. x_msg_count loop
2549: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,
2550: p_encoded => 'F');
2551:
2552: IBE_UTIL.debug('Error msg: '||substr(lx_msg_data,1,240));
2553: end loop;

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

2559: END IF;
2560:
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562:
2563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2564: THEN
2565: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2566: END IF;
2567:

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

2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562:
2563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2564: THEN
2565: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2566: END IF;
2567:
2568: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2569: p_data => x_msg_data,

Line 2568: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

2564: THEN
2565: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2566: END IF;
2567:
2568: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2569: p_data => x_msg_data,
2570: p_encoded => 'F');
2571: for k in 1 .. x_msg_count loop
2572: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 2572: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,

2568: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2569: p_data => x_msg_data,
2570: p_encoded => 'F');
2571: for k in 1 .. x_msg_count loop
2572: lx_msg_data := fnd_msg_pub.get( p_msg_index => k,
2573: p_encoded => 'F');
2574:
2575: IBE_UTIL.debug('Error msg: '||substr(lx_msg_data,1,240));
2576: end loop;