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 125: FND_Msg_Pub.initialize;

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

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

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

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

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

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

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

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

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

Line 198: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

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

Line 255: FND_Msg_Pub.initialize;

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

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

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

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

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

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

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

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

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

Line 332: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

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

Line 401: FND_Msg_Pub.initialize;

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

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

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

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

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

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

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

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

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

Line 540: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

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

Line 605: FND_Msg_Pub.initialize;

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

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

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

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

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

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

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

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

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

Line 698: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

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

Line 786: FND_Msg_Pub.initialize;

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

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

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

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

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

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

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

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

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

Line 947: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

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

Line 1031: FND_Msg_Pub.initialize;

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

Line 1112: FND_Msg_Pub.Add;

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

Line 1128: FND_MSG_PUB.ADD;

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

Line 1170: FND_Msg_Pub.Add;

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

Line 1191: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

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

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

Line 1327: FND_Msg_Pub.initialize;

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

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

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

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

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

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

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

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

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

Line 1426: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

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

Line 1537: FND_Msg_Pub.initialize;

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

Line 1570: FND_Msg_Pub.Add;

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

Line 1602: FND_Msg_Pub.Add;

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

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

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

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

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

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

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

Line 1712: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

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

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

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