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.IEM_AGENT_ACT_PVT dependencies on FND_MESSAGE

Line 378: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT1_CREATED');

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

Line 379: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username);

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;

Line 589: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT1_DELETED');

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;

Line 590: FND_MESSAGE.SET_TOKEN('AGENT', l_error_username);

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:

Line 604: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT9_DELETED');

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);

Line 605: FND_MESSAGE.SET_TOKEN('AGENT', 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);
609: end if;

Line 606: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);

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:

Line 620: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT5_DELETED');

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:

Line 621: FND_MESSAGE.SET_TOKEN('AGENT', 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:
625: end if;

Line 622: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_account_name);

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:

Line 765: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_ACCOUNT_NOT_FOUND');

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:

Line 967: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT2_CREATED');

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

Line 968: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user);

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;

Line 986: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGENT_USER_NULL');

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:

Line 993: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_RESOURCE_INACTIVE');

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:

Line 1198: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT2_DELETED');

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;

Line 1199: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user);

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:

Line 1212: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_AGNTACCT10_DELETED');

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);

Line 1213: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user1);

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;

Line 1214: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);

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:

Line 1227: FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_AGNTACCT6_DELETED');

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:

Line 1228: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_error_email_user2);

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;

Line 1229: FND_MESSAGE.SET_TOKEN('AGENT', l_res_name);

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:

Line 1495: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ADDED');

1491: UPDATE iem_agents set cherry_pick_flag = 'Y'
1492: WHERE resource_id=p_in_cherrypick_tbl(i)
1493: and email_account_id=p_email_account_id;
1494:
1495: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ADDED');
1496: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1497: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1498: EXCEPTION
1499: WHEN NO_DATA_FOUND THEN

Line 1496: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );

1492: WHERE resource_id=p_in_cherrypick_tbl(i)
1493: and email_account_id=p_email_account_id;
1494:
1495: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ADDED');
1496: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1497: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1498: EXCEPTION
1499: WHEN NO_DATA_FOUND THEN
1500: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_NO_DATA_ERROR');

Line 1497: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

1493: and email_account_id=p_email_account_id;
1494:
1495: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ADDED');
1496: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1497: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1498: EXCEPTION
1499: WHEN NO_DATA_FOUND THEN
1500: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_NO_DATA_ERROR');
1501: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );

Line 1500: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_NO_DATA_ERROR');

1496: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1497: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1498: EXCEPTION
1499: WHEN NO_DATA_FOUND THEN
1500: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_NO_DATA_ERROR');
1501: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1502: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1503: WHEN OTHERS THEN
1504: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_OTHERS_ERROR');

Line 1501: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );

1497: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1498: EXCEPTION
1499: WHEN NO_DATA_FOUND THEN
1500: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_NO_DATA_ERROR');
1501: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1502: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1503: WHEN OTHERS THEN
1504: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_OTHERS_ERROR');
1505: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );

Line 1502: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

1498: EXCEPTION
1499: WHEN NO_DATA_FOUND THEN
1500: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_NO_DATA_ERROR');
1501: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1502: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1503: WHEN OTHERS THEN
1504: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_OTHERS_ERROR');
1505: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1506: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

Line 1504: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_OTHERS_ERROR');

1500: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_NO_DATA_ERROR');
1501: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1502: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1503: WHEN OTHERS THEN
1504: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_OTHERS_ERROR');
1505: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1506: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1507:
1508: END;

Line 1505: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );

1501: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1502: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1503: WHEN OTHERS THEN
1504: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_OTHERS_ERROR');
1505: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1506: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1507:
1508: END;
1509:

Line 1506: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

1502: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1503: WHEN OTHERS THEN
1504: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_OTHERS_ERROR');
1505: FND_MESSAGE.SET_TOKEN('AGENT', p_in_cherrypick_tbl(i) );
1506: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1507:
1508: END;
1509:
1510: END IF; -- l_agent_acount_account<>0

Line 1537: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ADDED');

1533: UPDATE iem_agents set cherry_pick_flag = null
1534: WHERE resource_id=p_out_cherrypick_tbl(i)
1535: and email_account_id=p_email_account_id;
1536:
1537: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ADDED');
1538: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1539: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1540: EXCEPTION
1541: WHEN NO_DATA_FOUND THEN

Line 1538: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );

1534: WHERE resource_id=p_out_cherrypick_tbl(i)
1535: and email_account_id=p_email_account_id;
1536:
1537: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ADDED');
1538: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1539: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1540: EXCEPTION
1541: WHEN NO_DATA_FOUND THEN
1542: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_NO_DATA_ERROR');

Line 1539: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

1535: and email_account_id=p_email_account_id;
1536:
1537: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ADDED');
1538: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1539: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1540: EXCEPTION
1541: WHEN NO_DATA_FOUND THEN
1542: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_NO_DATA_ERROR');
1543: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );

Line 1542: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_NO_DATA_ERROR');

1538: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1539: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1540: EXCEPTION
1541: WHEN NO_DATA_FOUND THEN
1542: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_NO_DATA_ERROR');
1543: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1544: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1545: WHEN OTHERS THEN
1546: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_OTHERS_ERROR');

Line 1543: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );

1539: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1540: EXCEPTION
1541: WHEN NO_DATA_FOUND THEN
1542: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_NO_DATA_ERROR');
1543: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1544: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1545: WHEN OTHERS THEN
1546: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_OTHERS_ERROR');
1547: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );

Line 1544: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

1540: EXCEPTION
1541: WHEN NO_DATA_FOUND THEN
1542: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_NO_DATA_ERROR');
1543: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1544: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1545: WHEN OTHERS THEN
1546: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_OTHERS_ERROR');
1547: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1548: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

Line 1546: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_OTHERS_ERROR');

1542: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_NO_DATA_ERROR');
1543: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1544: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1545: WHEN OTHERS THEN
1546: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_OTHERS_ERROR');
1547: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1548: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1549:
1550: END;

Line 1547: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );

1543: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1544: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1545: WHEN OTHERS THEN
1546: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_OTHERS_ERROR');
1547: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1548: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1549:
1550: END;
1551:

Line 1548: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);

1544: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1545: WHEN OTHERS THEN
1546: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_OTHERS_ERROR');
1547: FND_MESSAGE.SET_TOKEN('AGENT', p_out_cherrypick_tbl(i) );
1548: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_email_account_id);
1549:
1550: END;
1551:
1552: END IF; -- l_agent_acount_account<>0

Line 1682: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_ADDED');

1678: UPDATE iem_agents set cherry_pick_flag = 'Y'
1679: where resource_id=p_resource_id
1680: and email_account_id=p_in_acct_chrypick_tbl(i);
1681:
1682: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_ADDED');
1683: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1684: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1685: EXCEPTION
1686: WHEN NO_DATA_FOUND THEN

Line 1683: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

1679: where resource_id=p_resource_id
1680: and email_account_id=p_in_acct_chrypick_tbl(i);
1681:
1682: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_ADDED');
1683: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1684: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1685: EXCEPTION
1686: WHEN NO_DATA_FOUND THEN
1687: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_NO_DATA_ERROR');

Line 1684: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );

1680: and email_account_id=p_in_acct_chrypick_tbl(i);
1681:
1682: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_ADDED');
1683: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1684: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1685: EXCEPTION
1686: WHEN NO_DATA_FOUND THEN
1687: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_NO_DATA_ERROR');
1688: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

Line 1687: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_NO_DATA_ERROR');

1683: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1684: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1685: EXCEPTION
1686: WHEN NO_DATA_FOUND THEN
1687: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_NO_DATA_ERROR');
1688: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1689: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1690: WHEN OTHERS THEN
1691: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_OTHERS_ERROR');

Line 1688: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

1684: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1685: EXCEPTION
1686: WHEN NO_DATA_FOUND THEN
1687: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_NO_DATA_ERROR');
1688: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1689: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1690: WHEN OTHERS THEN
1691: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_OTHERS_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

Line 1689: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );

1685: EXCEPTION
1686: WHEN NO_DATA_FOUND THEN
1687: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_NO_DATA_ERROR');
1688: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1689: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1690: WHEN OTHERS THEN
1691: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_OTHERS_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1693: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i));

Line 1691: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_OTHERS_ERROR');

1687: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_NO_DATA_ERROR');
1688: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1689: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1690: WHEN OTHERS THEN
1691: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_OTHERS_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1693: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i));
1694:
1695: END;

Line 1692: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

1688: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1689: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1690: WHEN OTHERS THEN
1691: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_OTHERS_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1693: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i));
1694:
1695: END;
1696:

Line 1693: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i));

1689: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i) );
1690: WHEN OTHERS THEN
1691: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_OTHERS_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1693: FND_MESSAGE.SET_TOKEN('AGENT', p_in_acct_chrypick_tbl(i));
1694:
1695: END;
1696:
1697: END IF; -- l_agent_acount_account<>0

Line 1724: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETED');

1720: UPDATE iem_agents set cherry_pick_flag = null
1721: where resource_id=p_resource_id
1722: and email_account_id=p_out_acct_chrypick_tbl(i);
1723:
1724: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETED');
1725: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1726: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN

Line 1725: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

1721: where resource_id=p_resource_id
1722: and email_account_id=p_out_acct_chrypick_tbl(i);
1723:
1724: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETED');
1725: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1726: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN
1729: FND_MESSAGE.SET_NAME('IEM','IEM_CHRRYPICK_ACCT_DELETE_NO_DATA_ERROR');

Line 1726: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );

1722: and email_account_id=p_out_acct_chrypick_tbl(i);
1723:
1724: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETED');
1725: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1726: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN
1729: FND_MESSAGE.SET_NAME('IEM','IEM_CHRRYPICK_ACCT_DELETE_NO_DATA_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

Line 1729: FND_MESSAGE.SET_NAME('IEM','IEM_CHRRYPICK_ACCT_DELETE_NO_DATA_ERROR');

1725: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1726: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN
1729: FND_MESSAGE.SET_NAME('IEM','IEM_CHRRYPICK_ACCT_DELETE_NO_DATA_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1731: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1732: WHEN OTHERS THEN
1733: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETE_OTHERS_ERROR');

Line 1730: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

1726: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN
1729: FND_MESSAGE.SET_NAME('IEM','IEM_CHRRYPICK_ACCT_DELETE_NO_DATA_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1731: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1732: WHEN OTHERS THEN
1733: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETE_OTHERS_ERROR');
1734: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

Line 1731: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );

1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN
1729: FND_MESSAGE.SET_NAME('IEM','IEM_CHRRYPICK_ACCT_DELETE_NO_DATA_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1731: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1732: WHEN OTHERS THEN
1733: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETE_OTHERS_ERROR');
1734: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1735: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );

Line 1733: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETE_OTHERS_ERROR');

1729: FND_MESSAGE.SET_NAME('IEM','IEM_CHRRYPICK_ACCT_DELETE_NO_DATA_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1731: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1732: WHEN OTHERS THEN
1733: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETE_OTHERS_ERROR');
1734: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1735: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1736:
1737: END;

Line 1734: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);

1730: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1731: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1732: WHEN OTHERS THEN
1733: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETE_OTHERS_ERROR');
1734: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1735: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1736:
1737: END;
1738:

Line 1735: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );

1731: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1732: WHEN OTHERS THEN
1733: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETE_OTHERS_ERROR');
1734: FND_MESSAGE.SET_TOKEN('ACCOUNT', p_resource_id);
1735: FND_MESSAGE.SET_TOKEN('AGENT', p_out_acct_chrypick_tbl(i) );
1736:
1737: END;
1738:
1739: END IF; -- l_agent_acount_account<>0