374: if l_error_agent_count > 20 then
375: l_error_username := l_error_username || '...';
376: end if;
377:
378: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT1_CREATED');
379: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username);
380: FND_MSG_PUB.ADD;
381: elsif l_data_change = false then
382: x_return_status := 'N'; -- indicate no data change
375: l_error_username := l_error_username || '...';
376: end if;
377:
378: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT1_CREATED');
379: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username);
380: FND_MSG_PUB.ADD;
381: elsif l_data_change = false then
382: x_return_status := 'N'; -- indicate no data change
383: end if;
585: if l_error_agent_count > 20 then
586: l_error_username := l_error_username || '...';
587: end if;
588:
589: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT1_DELETED');
590: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username);
591: FND_MSG_PUB.ADD;
592:
593: end if;
586: l_error_username := l_error_username || '...';
587: end if;
588:
589: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT1_DELETED');
590: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username);
591: FND_MSG_PUB.ADD;
592:
593: end if;
594:
600: l_error_username1 := l_error_username1 || '...';
601: end if;
602:
603:
604: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT9_DELETED');
605: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username1);
606: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);
607: FND_MSG_PUB.Add;
608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
601: end if;
602:
603:
604: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT9_DELETED');
605: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username1);
606: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);
607: FND_MSG_PUB.Add;
608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
609: end if;
602:
603:
604: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT9_DELETED');
605: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username1);
606: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);
607: FND_MSG_PUB.Add;
608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
609: end if;
610:
616: l_error_username2 := l_error_username2 || '...';
617: end if;
618:
619:
620: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT5_DELETED');
621: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username2);
622: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);
623: FND_MSG_PUB.ADD;
624:
617: end if;
618:
619:
620: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT5_DELETED');
621: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username2);
622: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);
623: FND_MSG_PUB.ADD;
624:
625: end if;
618:
619:
620: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT5_DELETED');
621: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username2);
622: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);
623: FND_MSG_PUB.ADD;
624:
625: end if;
626:
761: );
762: EXCEPTION
763: WHEN NO_DATA_FOUND THEN
764: ROLLBACK TO agntacct_by_agent_wrap;
765: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_ACCOUNT_NOT_FOUND');
766: FND_MSG_PUB.Add;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
963: if l_error_account_count > 5 then
964: l_error_email_user := l_error_email_user || '...';
965: end if;
966:
967: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT2_CREATED');
968: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user);
969: FND_MSG_PUB.ADD;
970: elsif l_data_change = false then
971: x_return_status := 'N'; -- indicate no data change
964: l_error_email_user := l_error_email_user || '...';
965: end if;
966:
967: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT2_CREATED');
968: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user);
969: FND_MSG_PUB.ADD;
970: elsif l_data_change = false then
971: x_return_status := 'N'; -- indicate no data change
972: end if;
982: );
983: EXCEPTION
984: WHEN USER_NULL_ERROR THEN
985: ROLLBACK TO create_agntacct_by_account_PVT;
986: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGENT_USER_NULL');
987: FND_MSG_PUB.Add;
988: x_return_status := FND_API.G_RET_STS_ERROR ;
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
990:
989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
990:
991: WHEN RESOURCE_INACTIVE_ERROR THEN
992: ROLLBACK TO create_agntacct_by_account_PVT;
993: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_RESOURCE_INACTIVE');
994: FND_MSG_PUB.Add;
995: x_return_status := FND_API.G_RET_STS_ERROR ;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
997:
1194: if l_error_account_count > 5 then
1195: l_error_email_user := l_error_email_user || '...';
1196: end if;
1197:
1198: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT2_DELETED');
1199: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user);
1200: FND_MSG_PUB.ADD;
1201:
1202: end if;
1195: l_error_email_user := l_error_email_user || '...';
1196: end if;
1197:
1198: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT2_DELETED');
1199: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user);
1200: FND_MSG_PUB.ADD;
1201:
1202: end if;
1203:
1208: if l_error_account_count1 > 5 then
1209: l_error_email_user1 := l_error_email_user1 || '...';
1210: end if;
1211:
1212: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT10_DELETED');
1213: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user1);
1214: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1209: l_error_email_user1 := l_error_email_user1 || '...';
1210: end if;
1211:
1212: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT10_DELETED');
1213: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user1);
1214: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1217: end if;
1210: end if;
1211:
1212: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT10_DELETED');
1213: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user1);
1214: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1217: end if;
1218:
1223: if l_error_account_count2 > 5 then
1224: l_error_email_user2 := l_error_email_user2 || '...';
1225: end if;
1226:
1227: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT6_DELETED');
1228: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user2);
1229: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);
1230: FND_MSG_PUB.ADD;
1231:
1224: l_error_email_user2 := l_error_email_user2 || '...';
1225: end if;
1226:
1227: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT6_DELETED');
1228: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user2);
1229: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);
1230: FND_MSG_PUB.ADD;
1231:
1232: end if;
1225: end if;
1226:
1227: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT6_DELETED');
1228: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user2);
1229: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);
1230: FND_MSG_PUB.ADD;
1231:
1232: end if;
1233: