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_CUSTOMER_ACCT_PVT dependencies on FND_MSG_PUB

Line 128: FND_Msg_Pub.initialize;

124: END IF;
125:
126: -- Initialize message list if p_init_msg_list is set to TRUE.
127: IF FND_API.To_Boolean( p_init_msg_list ) THEN
128: FND_Msg_Pub.initialize;
129: END IF;
130:
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

165: COMMIT WORK;
166: END IF;
167:
168: -- Standard call to get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
173: Ibe_Util.debug('End IBE_CUSTOMER_ACCT_PVT:GetPartySiteId');

Line 180: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO CUSTACCT_GETPARTYSITEID;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
181: p_count => x_msg_count ,
182: p_data => x_msg_data);
183: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
184: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:GetPartySiteId()'|| sqlerrm);

Line 190: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO CUSTACCT_GETPARTYSITEID;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
191: p_count => x_msg_count ,
192: p_data => x_msg_data);
193: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
194: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:GetPartySiteId()' || sqlerrm);

Line 200: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

196:
197: WHEN OTHERS THEN
198: ROLLBACK TO CUSTACCT_GETPARTYSITEID;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
202: L_API_NAME);
203: END IF;
204: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 201: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

197: WHEN OTHERS THEN
198: ROLLBACK TO CUSTACCT_GETPARTYSITEID;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
202: L_API_NAME);
203: END IF;
204: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count ,

Line 204: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

200: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
202: L_API_NAME);
203: END IF;
204: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count ,
206: p_data => x_msg_data);
207: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
208: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:GetPartySiteId' || sqlerrm);

Line 258: FND_Msg_Pub.initialize;

254: END IF;
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF FND_API.To_Boolean( p_init_msg_list ) THEN
258: FND_Msg_Pub.initialize;
259: END IF;
260:
261: -- Initialize API return status to success
262: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

303: COMMIT WORK;
304: END IF;
305:
306: -- Standard call to get message count and if count is 1, get message info.
307: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
308: p_data => x_msg_data);
309:
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN

Line 314: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: ROLLBACK TO CUSTACCT_CREATEPARTYSITEUSE;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
315: p_count => x_msg_count ,
316: p_data => x_msg_data);
317: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
318: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use'|| sqlerrm);

Line 324: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK TO CUSTACCT_CREATEPARTYSITEUSE;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count ,
326: p_data => x_msg_data);
327: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
328: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use' || sqlerrm);

Line 334: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

330:
331: WHEN OTHERS THEN
332: ROLLBACK TO CUSTACCT_CREATEPARTYSITEUSE;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
335: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
336: L_API_NAME);
337: END IF;
338: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 335: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

331: WHEN OTHERS THEN
332: ROLLBACK TO CUSTACCT_CREATEPARTYSITEUSE;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
335: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
336: L_API_NAME);
337: END IF;
338: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count ,

Line 338: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

334: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
335: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
336: L_API_NAME);
337: END IF;
338: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count ,
340: p_data => x_msg_data);
341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Create_Party_Site_Use' || sqlerrm);

Line 404: FND_Msg_Pub.initialize;

400: END IF;
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.
403: IF FND_API.To_Boolean( p_init_msg_list ) THEN
404: FND_Msg_Pub.initialize;
405: END IF;
406:
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

510: IBE_Util.debug('End IBE_CUSTOMER_ACCT_PVT:create_cust_account_role');
511: END IF;
512:
513: -- Standard call to get message count and if count is 1, get message info.
514: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
515: p_data => x_msg_data);
516:
517: EXCEPTION
518:

Line 522: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

518:
519: WHEN FND_API.G_EXC_ERROR THEN
520: ROLLBACK TO CUSTACCT_CREATCUSTACCTROLE;
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count ,
524: p_data => x_msg_data);
525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
526: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:create_cust_account_role()'|| sqlerrm);

Line 532: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

528:
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: ROLLBACK TO CUSTACCT_CREATCUSTACCTROLE;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
533: p_count => x_msg_count ,
534: p_data => x_msg_data);
535: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
536: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:create_cust_account_role' || sqlerrm);

Line 542: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

538:
539: WHEN OTHERS THEN
540: ROLLBACK TO CUSTACCT_CREATCUSTACCTROLE;
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
543: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
544: L_API_NAME);
545: END IF;
546:

Line 543: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

539: WHEN OTHERS THEN
540: ROLLBACK TO CUSTACCT_CREATCUSTACCTROLE;
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
542: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
543: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
544: L_API_NAME);
545: END IF;
546:
547: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 547: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

543: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
544: L_API_NAME);
545: END IF;
546:
547: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count ,
549: p_data => x_msg_data);
550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
551: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:create_cust_account_role)' || sqlerrm);

Line 608: FND_Msg_Pub.initialize;

604: END IF;
605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.To_Boolean( p_init_msg_list ) THEN
608: FND_Msg_Pub.initialize;
609: END IF;
610:
611: -- Initialize API return status to success
612: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

664: END IF;
665:
666:
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data);
670:
671:
672: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 680: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

676: EXCEPTION
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITE;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
681: p_count => x_msg_count ,
682: p_data => x_msg_data);
683: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
684: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()'|| sqlerrm);

Line 690: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

686:
687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITE;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
691: p_count => x_msg_count ,
692: p_data => x_msg_data);
693: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
694: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()' || sqlerrm);

Line 700: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

696:
697: WHEN OTHERS THEN
698: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITE;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
701: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
702: L_API_NAME);
703: END IF;
704:

Line 701: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

697: WHEN OTHERS THEN
698: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITE;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
701: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
702: L_API_NAME);
703: END IF;
704:
705: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 705: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

701: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
702: L_API_NAME);
703: END IF;
704:
705: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
706: p_count => x_msg_count ,
707: p_data => x_msg_data);
708: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
709: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT: Create_Cust_Acct_Site()' || sqlerrm);

Line 789: FND_Msg_Pub.initialize;

785: END IF;
786:
787: -- Initialize message list if p_init_msg_list is set to TRUE.
788: IF FND_API.To_Boolean( p_init_msg_list ) THEN
789: FND_Msg_Pub.initialize;
790: END IF;
791:
792: -- Initialize API return status to success
793: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

913: END IF;
914:
915:
916: -- Standard call to get message count and if count is 1, get message info.
917: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
918: p_data => x_msg_data);
919:
920:
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 929: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITEUSE;
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
930: p_count => x_msg_count,
931: p_data => x_msg_data);
932: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
933: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()'|| sqlerrm);

Line 939: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

935:
936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
937: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITEUSE;
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
940: p_count => x_msg_count ,
941: p_data => x_msg_data);
942: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
943: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()' || sqlerrm);

Line 949: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

945:
946: WHEN OTHERS THEN
947: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITEUSE;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
950: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
951: L_API_NAME);
952: END IF;
953:

Line 950: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

946: WHEN OTHERS THEN
947: ROLLBACK TO CUSTACCT_CREATCUSTACCTSITEUSE;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
950: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
951: L_API_NAME);
952: END IF;
953:
954: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 954: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

950: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
951: L_API_NAME);
952: END IF;
953:
954: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
955: p_count => x_msg_count ,
956: p_data => x_msg_data);
957: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
958: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Create_Cust_Acct_Site_Use()' || sqlerrm);

Line 1034: FND_Msg_Pub.initialize;

1030: END IF;
1031:
1032: -- Initialize message list if p_init_msg_list is set to TRUE.
1033: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1034: FND_Msg_Pub.initialize;
1035: END IF;
1036:
1037: -- Initialize API return status to success
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1115: FND_Msg_Pub.Add;

1111: (l_cust_acct_site_id is null OR l_cust_acct_site_id = FND_API.G_MISS_NUM))
1112: THEN
1113: -- Creation Failed.
1114: FND_Message.Set_Name('IBE', 'IBE_ERR_OT_INVALID_BILLTO_ADDR');
1115: FND_Msg_Pub.Add;
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118:
1119: ELSIF (l_cust_acct_site_status <> 'A') THEN -- IF c_get_cust_site%NOTFOUND

Line 1131: FND_MSG_PUB.ADD;

1127: FND_MESSAGE.Set_Name('IBE','IBE_ERR_OT_INVALID_BILLTO_ADDR'); -- need error message
1128: ELSE
1129: FND_MESSAGE.Set_Name('IBE','IBE_ERR_OT_INVALID_SHIPTO_ADDR'); -- need error message
1130: END IF;
1131: FND_MSG_PUB.ADD;
1132: RAISE FND_API.G_EXC_ERROR;
1133:
1134: END IF; -- c_get_cust_site%NOTFOUND
1135:

Line 1173: FND_Msg_Pub.Add;

1169: (l_cust_acct_site_id is null OR l_cust_acct_site_id = FND_API.G_MISS_NUM))
1170: THEN
1171: -- Creation Failed.
1172: FND_Message.Set_Name('IBE', 'IBE_ERR_OT_INVALID_BILLTO_ADDR');
1173: FND_Msg_Pub.Add;
1174: RAISE FND_API.G_EXC_ERROR;
1175: ELSE
1176: x_siteuse_id := l_site_use_id;
1177: END IF;

Line 1194: FND_MSG_PUB.ADD;

1190: FND_MESSAGE.Set_Name('IBE','IBE_ERR_OT_INVALID_BILLTO_ADDR'); -- need error message
1191: ELSE
1192: FND_MESSAGE.Set_Name('IBE','IBE_ERR_OT_INVALID_SHIPTO_ADDR'); -- need error message
1193: END IF;
1194: FND_MSG_PUB.ADD;
1195: RAISE FND_API.G_EXC_ERROR;
1196:
1197: ELSE
1198: -- valid cust_acct_site_use_id available, so use it

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

1218: END IF;
1219:
1220:
1221: -- Standard call to get message count and if count is 1, get message info.
1222: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1223: p_data => x_msg_data);
1224:
1225:
1226: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1233: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1229:
1230: EXCEPTION
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1234: p_count => x_msg_count,
1235: p_data => x_msg_data);
1236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1237: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);

Line 1242: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1238: END IF;
1239:
1240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1242: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1243: p_count => x_msg_count,
1244: p_data => x_msg_data);
1245: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1246: IBE_Util.Debug('UnexError IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);

Line 1251: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1247: END IF;
1248:
1249: WHEN OTHERS THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1252: p_count => x_msg_count,
1253: p_data => x_msg_data);
1254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1255: IBE_Util.Debug('Others IBE_CUSTOMER_ACCT_PVT:Get_Cust_Account_Site_Use()'|| sqlerrm);

Line 1330: FND_Msg_Pub.initialize;

1326: END IF;
1327:
1328: -- Initialize message list if p_init_msg_list is set to TRUE.
1329: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1330: FND_Msg_Pub.initialize;
1331: END IF;
1332:
1333: -- Initialize API return status to success
1334: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1397: END IF;
1398:
1399:
1400: -- Standard call to get message count and if count is 1, get message info.
1401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1402: p_data => x_msg_data);
1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN

Line 1408: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO CUSTACCT_CUSTACCTSITEUSE;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1409: p_count => x_msg_count ,
1410: p_data => x_msg_data);
1411: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1412: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()'|| sqlerrm);

Line 1418: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1414:
1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: ROLLBACK TO CUSTACCT_CUSTACCTSITEUSE;
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1418: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1419: p_count => x_msg_count ,
1420: p_data => x_msg_data);
1421: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1422: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()' || sqlerrm);

Line 1428: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

1424:
1425: WHEN OTHERS THEN
1426: ROLLBACK TO CUSTACCT_CUSTACCTSITEUSE;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1429: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1430: L_API_NAME);
1431: END IF;
1432:

Line 1429: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1425: WHEN OTHERS THEN
1426: ROLLBACK TO CUSTACCT_CUSTACCTSITEUSE;
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1428: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1429: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1430: L_API_NAME);
1431: END IF;
1432:
1433: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1433: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1429: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1430: L_API_NAME);
1431: END IF;
1432:
1433: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count ,
1435: p_data => x_msg_data);
1436: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1437: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:Get_Cust_Acct_Role()' || sqlerrm);

Line 1540: FND_Msg_Pub.initialize;

1536: END IF;
1537:
1538: -- Initialize message list if p_init_msg_list is set to TRUE.
1539: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1540: FND_Msg_Pub.initialize;
1541: END IF;
1542:
1543: -- Initialize API return status to success
1544: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1573: FND_Msg_Pub.Add;

1569: open c_cust_acct_det(p_invoice_to_org_id);
1570: fetch c_cust_acct_det into lc_cust_acct_det;
1571: if(c_cust_acct_det%notfound) then
1572: FND_Message.Set_Name('IBE', 'IBE_ERR_OT_INVALID_CUST'); --need err msg
1573: FND_Msg_Pub.Add;
1574: RAISE FND_API.G_EXC_ERROR;
1575: else
1576: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1577: IBE_Util.Debug('Customer details available');

Line 1605: FND_Msg_Pub.Add;

1601: open c_customer_details(l_cust_account_id);
1602: fetch c_customer_details into lc_customer_details;
1603: if(c_customer_details%notfound) then
1604: FND_Message.Set_Name('IBE', 'IBE_ERR_OT_INVALID_CUST'); --need err msg
1605: FND_Msg_Pub.Add;
1606: RAISE FND_API.G_EXC_ERROR;
1607: else
1608: x_cust_party_id := lc_customer_details.party_id;
1609: x_cust_party_name := lc_customer_details.party_name;

Line 1694: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1690: EXCEPTION
1691: WHEN FND_API.G_EXC_ERROR THEN
1692: ROLLBACK TO CUSTACCT_CUSTOMERDATA;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1695: p_count => x_msg_count ,
1696: p_data => x_msg_data);
1697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1698: IBE_Util.Debug('Error IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()'|| sqlerrm);

Line 1704: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1700:
1701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1702: ROLLBACK TO CUSTACCT_CUSTOMERDATA;
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1705: p_count => x_msg_count ,
1706: p_data => x_msg_data);
1707: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1708: IBE_Util.Debug('UNEXPECTEDErr IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()' || sqlerrm);

Line 1714: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

1710:
1711: WHEN OTHERS THEN
1712: ROLLBACK TO CUSTACCT_CUSTOMERDATA;
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1715: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1716: L_API_NAME);
1717: END IF;
1718:

Line 1715: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1711: WHEN OTHERS THEN
1712: ROLLBACK TO CUSTACCT_CUSTOMERDATA;
1713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1714: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1715: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1716: L_API_NAME);
1717: END IF;
1718:
1719: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1719: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1715: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1716: L_API_NAME);
1717: END IF;
1718:
1719: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1720: p_count => x_msg_count ,
1721: p_data => x_msg_data);
1722: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1723: IBE_Util.Debug('OtherExc IBE_CUSTOMER_ACCT_PVT:GetCustomerAcctData()' || sqlerrm);