DBA Data[Home] [Help]

APPS.IEM_ROUTE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

G_created_updated_by   NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
Line: 25

G_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
Line: 27

PROCEDURE delete_acct_route_by_acct
             (p_api_version_number      IN  NUMBER,
              P_init_msg_list           IN  VARCHAR2 := null,
              p_commit                  IN  VARCHAR2 := null,
              p_email_account_id        IN  NUMBER,
              x_return_status           OUT NOCOPY VARCHAR2,
              x_msg_count               OUT NOCOPY NUMBER,
              x_msg_data                OUT NOCOPY VARCHAR2)
IS
    i                       INTEGER;
Line: 37

    l_api_name		        varchar2(30):='delete_acct_route_by_acct';
Line: 40

    IEM_ROUTE_NOT_DELETED     EXCEPTION;
Line: 44

    SAVEPOINT delete_acct_route_by_acct;
Line: 66

            DELETE
            FROM IEM_ACCOUNT_ROUTES
            WHERE email_account_id = p_email_account_id;
Line: 81

  	     ROLLBACK TO delete_acct_route_by_acct;
Line: 88

	   ROLLBACK TO delete_acct_route_by_acct;
Line: 94

	  ROLLBACK TO delete_acct_route_by_acct;
Line: 102

END delete_acct_route_by_acct;
Line: 105

PROCEDURE delete_item_batch
             (p_api_version_number      IN  NUMBER,
              P_init_msg_list           IN  VARCHAR2 := null,
              p_commit                  IN  VARCHAR2 := null,
              p_route_ids_tbl           IN  jtf_varchar2_Table_100,
              x_return_status           OUT NOCOPY VARCHAR2,
              x_msg_count               OUT NOCOPY NUMBER,
              x_msg_data                OUT NOCOPY VARCHAR2)
IS
    i                       INTEGER;
Line: 115

    l_api_name		        varchar2(30):='delete_item_batch';
Line: 119

            select email_account_id from iem_account_routes where route_id = l_route_id;
Line: 121

    IEM_ROUTE_NOT_DELETED     EXCEPTION;
Line: 127

    SAVEPOINT delete_item_batch;
Line: 150

            DELETE
            FROM IEM_ROUTES

            WHERE route_id = p_route_ids_tbl(i);
Line: 157

        raise IEM_ROUTE_NOT_DELETED;
Line: 168

               Update iem_account_routes set priority=priority-1

		  			           where  email_account_id=acct_id.email_account_id and priority > (Select priority from iem_account_routes
					           where route_id=p_route_ids_tbl(i)  and email_account_id = acct_id.email_account_id);
Line: 174

        DELETE
        FROM IEM_ACCOUNT_ROUTES
        WHERE route_id = p_route_ids_tbl(i);
Line: 179

        DELETE

        FROM IEM_ROUTE_RULES
        WHERE route_id=p_route_ids_tbl(i);
Line: 195

   WHEN IEM_ROUTE_NOT_DELETED THEN
        ROLLBACK TO delete_item_batch;
Line: 198

        FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
Line: 204

  	     ROLLBACK TO delete_item_batch;
Line: 211

	   ROLLBACK TO delete_item_batch;
Line: 217

	  ROLLBACK TO delete_item_batch;
Line: 225

END delete_item_batch;
Line: 464

    select count(*) into l_name_count from iem_routes where UPPER(name) = UPPER(p_name);
Line: 509

   	SELECT IEM_ROUTES_s1.nextval
	INTO l_seq_id
	FROM dual;
Line: 515

	INSERT INTO IEM_ROUTES
	(
	ROUTE_ID,
	NAME,
	DESCRIPTION,
	BOOLEAN_TYPE_CODE,
    PROCEDURE_NAME,
    all_email,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	)
	VALUES
	(

	l_seq_id,
	p_name,
	l_description,
	p_boolean_type_code,
    l_proc_name,
    l_all_email,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,

    NULL,

    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    decode(G_created_updated_by,null,-1,G_created_updated_by),
	sysdate,
    decode(G_created_updated_by,null,-1,G_created_updated_by),
    sysdate,
    decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)


	);
Line: 733

   	SELECT IEM_ROUTE_RULES_s1.nextval
	INTO l_seq_id
	FROM dual;
Line: 739

	INSERT INTO IEM_ROUTE_RULES
	(

	ROUTE_RULE_ID,
	ROUTE_ID,
	KEY_TYPE_CODE,
	OPERATOR_TYPE_CODE,
    VALUE,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,

	ATTRIBUTE6,
	ATTRIBUTE7,

	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    CREATED_BY,
	CREATION_DATE,

	LAST_UPDATED_BY,

	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	)
	VALUES
	(
	l_seq_id,
	p_route_id,
	p_key_type_code,
	p_operator_type_code,
    p_value,
    NULL,


    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,


    NULL,
    NULL,
    decode(G_created_updated_by,null,-1,G_created_updated_by),
	sysdate,
    decode(G_created_updated_by,null,-1,G_created_updated_by),
    sysdate,
    decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
	);
Line: 909

	SELECT IEM_ACCOUNT_ROUTES_s1.nextval
	INTO l_seq_id
	FROM dual;
Line: 913

	INSERT INTO IEM_ACCOUNT_ROUTES

	(
	ROUTE_ID,
	EMAIL_ACCOUNT_ID,
    ACCOUNT_ROUTE_ID,

    DESTINATION_GROUP_ID,
    DEFAULT_GROUP_ID,
	ENABLED_FLAG,
    PRIORITY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,

	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,

	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    CREATED_BY,
	CREATION_DATE,

	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,

	LAST_UPDATE_LOGIN
	)
   VALUES
   (
   p_route_id,
   p_email_account_id,
   l_seq_id,
   p_destination_group_id,
   p_default_grp_id,
   p_enabled_flag,

   p_priority,

   NULL,
   NULL,
   NULL,
   NULL,
   NULL,
   NULL,
   NULL,
   NULL,
   NULL,
   NULL,
   NULL,
   NULL,


   NULL,
   NULL,
   NULL,
   NULL,
   decode(G_created_updated_by,null,-1,G_created_updated_by),
   sysdate,
   decode(G_created_updated_by,null,-1,G_created_updated_by),
   sysdate,
   decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
	);
Line: 1041

PROCEDURE update_item_wrap (p_api_version_number    IN   NUMBER,
 	                         p_init_msg_list        IN   VARCHAR2 := null,
	                         p_commit	            IN   VARCHAR2 := null,
	                         p_route_id             IN   NUMBER,
  	                         p_name                 IN   VARCHAR2:= null,
  	                         p_ruling_chain	        IN   VARCHAR2:= null,
                             p_description          IN   VARCHAR2:= null,
                             p_procedure_name       IN   VARCHAR2:= null,
                             p_all_emails           IN   VARCHAR2:= null,
                             --below is the data for update
                             p_update_rule_ids_tbl IN  jtf_varchar2_Table_100,
                             p_update_rule_keys_tbl IN  jtf_varchar2_Table_100,
  	                         p_update_rule_operators_tbl IN  jtf_varchar2_Table_100,
                             p_update_rule_values_tbl IN  jtf_varchar2_Table_300,
                             --below is the data for insert
                             p_new_rule_keys_tbl IN  jtf_varchar2_Table_100,
  	                         p_new_rule_operators_tbl IN  jtf_varchar2_Table_100,
                             p_new_rule_values_tbl IN  jtf_varchar2_Table_300,
                             --below is the data to be removed
                             p_remove_rule_ids_tbl IN  jtf_varchar2_Table_100,
                             x_return_status         OUT NOCOPY VARCHAR2,
                             x_msg_count             OUT NOCOPY NUMBER,
                             x_msg_data              OUT NOCOPY VARCHAR2 )is

    l_api_name              VARCHAR2(255):='update_item_wrap';
Line: 1072

    IEM_NO_ROUTE_UPDATE         EXCEPTION;
Line: 1073

    IEM_NO_RULE_UPDATE          EXCEPTION;
Line: 1075

    IEM_RULE_NOT_DELETED        EXCEPTION;
Line: 1087

SAVEPOINT  update_item_wrap;
Line: 1114

  select count(*) into l_route from iem_routes where route_id = p_route_id;
Line: 1117

    raise IEM_NO_ROUTE_UPDATE;
Line: 1123

        l_return_type := p_update_rule_keys_tbl(1);
Line: 1138

    iem_route_pvt.update_item_route(
                                p_api_version_number => l_api_version_number,
                    	  	    p_init_msg_list => FND_API.G_FALSE,
   	                            p_commit => FND_API.G_FALSE,
			                   p_route_id => p_route_id,
  			                   p_name => p_name,
                               p_all_emails => p_all_emails,
  			                   p_description	=>l_description,
  			                   p_ruling_chain	=>p_ruling_chain,
                               p_proc_name => l_proc_name,
                               p_return_type => l_return_type,
                               x_return_status => l_return_status,
                               x_msg_count => l_msg_count,
                               x_msg_data => l_msg_data);
Line: 1160

  if ( p_update_rule_ids_tbl.count <>0 ) then

   FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST   loop
      iem_route_pvt.update_item_rule(p_api_version_number => l_api_version_number,
                      	  	    p_init_msg_list => FND_API.G_FALSE,
	                            p_commit => FND_API.G_FALSE,
  			                   p_route_rule_id => p_update_rule_ids_tbl(i),
  			                   p_key_type_code	=>p_update_rule_keys_tbl(i),
  			                   p_operator_type_code	=>p_update_rule_operators_tbl(i),
                               p_value => p_update_rule_values_tbl(i),

                               x_return_status => l_return_status,
                               x_msg_count => l_msg_count,
                               x_msg_data => l_msg_data);
Line: 1176

          raise IEM_NO_RULE_UPDATE;
Line: 1185

        DELETE
        FROM IEM_ROUTE_RULES
        WHERE route_rule_id = p_remove_rule_ids_tbl(i);
Line: 1190

        raise IEM_RULE_NOT_DELETED;
Line: 1217

    select count(*) into l_rule_count from iem_route_rules where route_id = p_route_id;
Line: 1229

      	   ROLLBACK TO update_item_wrap;
Line: 1236

        WHEN IEM_NO_ROUTE_UPDATE THEN
      	   ROLLBACK TO update_item_wrap;
Line: 1238

            FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
Line: 1243

        WHEN IEM_NO_RULE_UPDATE THEN
      	   ROLLBACK TO update_item_wrap;
Line: 1245

           FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
Line: 1250

        WHEN IEM_RULE_NOT_DELETED THEN

      	   ROLLBACK TO update_item_wrap;
Line: 1253

           FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
Line: 1260

      	   ROLLBACK TO update_item_wrap;
Line: 1268

      	   ROLLBACK TO update_item_wrap;
Line: 1276

            ROLLBACK TO update_item_wrap;
Line: 1282

            ROLLBACK TO update_item_wrap;
Line: 1288

            ROLLBACK TO update_item_wrap;
Line: 1297

END update_item_wrap;
Line: 1299

PROCEDURE update_item_route (
                 p_api_version_number   IN   NUMBER,
    	  	     p_init_msg_list        IN   VARCHAR2 := null,
    	    	 p_commit	            IN   VARCHAR2 := null,
    			 p_route_id             IN   NUMBER,
    			 p_name                 IN   VARCHAR2:= null,
    			 p_description	        IN   VARCHAR2:= null,
                 p_all_emails           IN   VARCHAR2:= null,
                 p_proc_name	        IN   VARCHAR2:= null,
                 p_return_type          IN   VARCHAR2:= null,
    			 p_ruling_chain	        IN   VARCHAR2:= null,
			     x_return_status	    OUT	NOCOPY VARCHAR2,
  		  	     x_msg_count	        OUT NOCOPY NUMBER,
	  	  	     x_msg_data	            OUT	NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='update_item_route';
Line: 1327

  SAVEPOINT		update_item_route;
Line: 1351

    select count(*) into l_name_count from iem_routes where UPPER(name) = UPPER(p_name) and route_id <> p_route_id;
Line: 1386

	update IEM_ROUTES
	set
           name=decode(p_name,null,name,p_name),
	       description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),
	       boolean_type_code=decode(p_ruling_chain,null,boolean_type_code,p_ruling_chain),
           procedure_name=decode(l_proc_name,FND_API.G_MISS_CHAR,null,null,procedure_name,l_proc_name),
           all_email=decode(p_all_emails,FND_API.G_MISS_CHAR,null,null,all_email,p_all_emails),
           LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
           LAST_UPDATE_DATE = sysdate,
           LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)

	where route_id=p_route_id;
Line: 1413

	 ROLLBACK TO update_item_route;
Line: 1418

	   ROLLBACK TO update_item_route;
Line: 1425

	   ROLLBACK TO update_item_route;
Line: 1432

	   ROLLBACK TO update_item_route;
Line: 1442

	   ROLLBACK TO update_item_route;
Line: 1452

	ROLLBACK TO update_item_route;
Line: 1469

END	update_item_route;
Line: 1472

PROCEDURE update_item_rule
                (p_api_version_number       IN  NUMBER,
     	  	     p_init_msg_list            IN  VARCHAR2 := null,
    	    	 p_commit	                IN  VARCHAR2 := null,
                 p_route_rule_id            IN  NUMBER   := null,
      			 p_key_type_code            IN  VARCHAR2:= null,
      			 p_operator_type_code	    IN  VARCHAR2:= null,
      			 p_value	                IN   VARCHAR2:= null,
			      x_return_status	        OUT	NOCOPY VARCHAR2,
  		  	      x_msg_count	            OUT NOCOPY NUMBER,
	  	  	      x_msg_data	            OUT	NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='update_item_rule';
Line: 1489

     IEM_NO_RULE_UPDATE     EXCEPTION;
Line: 1494

  SAVEPOINT		update_item_rule;
Line: 1515

  select count(*) into l_rule from iem_route_rules

  where route_rule_id = p_route_rule_id;
Line: 1520

    raise IEM_NO_RULE_UPDATE;
Line: 1541

	update IEM_ROUTE_RULES
	set
           key_type_code=decode(p_key_type_code,null,key_type_code,p_key_type_code),
	       operator_type_code=decode(p_operator_type_code,null,operator_type_code,p_operator_type_code),
	       value=decode(p_value,null,value,p_value),
           LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
           LAST_UPDATE_DATE = sysdate,
           LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
	where route_rule_id=p_route_rule_id;
Line: 1564

    WHEN IEM_NO_RULE_UPDATE THEN
    	   ROLLBACK TO update_item_rule;
Line: 1566

       FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
Line: 1574

    	   ROLLBACK TO update_item_rule;
Line: 1581

	ROLLBACK TO update_item_rule;
Line: 1590

	ROLLBACK TO update_item_rule;
Line: 1598

	ROLLBACK TO update_item_rule;
Line: 1616

 END	update_item_rule;
Line: 1648

    IEM_ACCOUNT_ROUTE_NOT_UPDATED   EXCEPTION;
Line: 1676

    select count(*) into l_route from iem_routes
        where route_id = p_route_id;
Line: 1686

    select count(*) into l_account from iem_mstemail_accounts
        where email_account_id = p_email_account_id;
Line: 1714

          raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
Line: 1749

    WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN

      	   ROLLBACK TO create_wrap_account_routes_PVT;
Line: 1752

           FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
Line: 1797

PROCEDURE update_account_routes(p_api_version_number    IN   NUMBER,
 	  	            p_init_msg_list         IN   VARCHAR2 := null,
	    	        p_commit	            IN   VARCHAR2 := null,
                    p_route_id              IN   NUMBER,
			        p_email_account_id      IN   NUMBER,
  			        p_destination_grp_id    IN   VARCHAR2:= null,
  			        p_default_grp_id	    IN   VARCHAR2:= null,
  			        p_enabled_flag	        IN   VARCHAR2:= null,
  			        p_priority	            IN   VARCHAR2:= null,
                    x_return_status	        OUT	NOCOPY VARCHAR2,
  		  	        x_msg_count	            OUT	NOCOPY NUMBER,
	  	  	        x_msg_data	            OUT	NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='update_account_routes';
Line: 1814

     l_LAST_UPDATED_BY    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
Line: 1815

     l_LAST_UPDATE_DATE    DATE:=SYSDATE;
Line: 1816

     l_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
Line: 1822

SAVEPOINT		update_account_routes_PVT;
Line: 1843

	Select count(*) into l_route_cnt from iem_routes
	where route_id=p_route_id;
Line: 1857

	Select count(*) into l_acct_cnt from iem_mstemail_accounts
	where email_account_id=p_email_account_id;
Line: 1880

	update IEM_ACCOUNT_ROUTES
	set
            destination_group_id = decode(p_destination_grp_id,null,destination_group_id,p_destination_grp_id),
	        default_group_id =decode(p_default_grp_id,null,default_group_id,p_default_grp_id),
	        enabled_flag=decode(p_enabled_flag,null,enabled_flag,p_enabled_flag),
	        priority=decode(p_priority,null,priority,p_priority),
           LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
           LAST_UPDATE_DATE = sysdate,
           LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
     where route_id = p_route_id and email_account_id = p_email_account_id;
Line: 1907

      	   ROLLBACK TO update_account_routes_PVT;
Line: 1913

	ROLLBACK TO update_account_routes_PVT;
Line: 1921

	ROLLBACK TO update_account_routes_PVT;
Line: 1929

	ROLLBACK TO update_account_routes_PVT;
Line: 1947

 END	update_account_routes;
Line: 1951

PROCEDURE delete_acct_route_batch
     (p_api_version_number      IN  NUMBER,
      P_init_msg_list           IN  VARCHAR2 := null,
      p_commit                  IN  VARCHAR2 := null,
      p_route_ids_tbl           IN  jtf_varchar2_Table_100,
      p_account_id              IN  NUMBER,
      x_return_status           OUT NOCOPY VARCHAR2,
      x_msg_count               OUT NOCOPY NUMBER,
      x_msg_data                OUT NOCOPY VARCHAR2)
IS
    i       INTEGER;
Line: 1962

    l_api_name		varchar2(30):='delete_acct_route_batch';
Line: 1965

    IEM_ACCOUNT_ROUTE_NOT_DELETED     EXCEPTION;
Line: 1971

    SAVEPOINT delete_acct_route_batch;
Line: 2000

        Update iem_account_routes set priority=priority-1
					           where email_account_id=p_account_id and priority > (Select priority from iem_account_routes
					           where route_id=p_route_ids_tbl(i) and  email_account_id=p_account_id);
Line: 2004

        DELETE
        FROM IEM_ACCOUNT_ROUTES
        WHERE route_id = p_route_ids_tbl(i) and email_account_id = p_account_id;
Line: 2024

   WHEN IEM_ACCOUNT_ROUTE_NOT_DELETED THEN
        ROLLBACK TO delete_acct_route_batch;
Line: 2029

        FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUNT_ROUTE_NOT_DELETED');
Line: 2034

	   ROLLBACK TO delete_acct_route_batch;
Line: 2041

	   ROLLBACK TO delete_acct_route_batch;
Line: 2047

	  ROLLBACK TO delete_acct_route_batch;
Line: 2056

END delete_acct_route_batch;
Line: 2061

PROCEDURE update_wrap_account_routes
                (p_api_version_number   IN   NUMBER,
 		  	     p_init_msg_list        IN   VARCHAR2 := null,
		    	 p_commit	            IN   VARCHAR2 := null,
                 p_email_account_id     IN NUMBER,
  				 p_route_ids_tbl        IN  jtf_varchar2_Table_100,
  				 p_upd_dest_ids_tbl     IN  jtf_varchar2_Table_100,

                 p_upd_default_ids_tbl  IN  jtf_varchar2_Table_100,
                 p_upd_enable_flag_tbl  IN  jtf_varchar2_Table_100,
                 --p_upd_priority_tbl IN  jtf_varchar2_Table_100,

                 p_delete_route_ids_tbl IN  jtf_varchar2_Table_100,

                 x_return_status        OUT NOCOPY VARCHAR2,
  		  	     x_msg_count	        OUT NOCOPY NUMBER,
	  	  	     x_msg_data	            OUT	NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='update_wrap_account_routes';
Line: 2089

    IEM_ACCOUNT_ROUTE_NOT_DELETED    EXCEPTION;
Line: 2090

    IEM_ACCOUNT_ROUTE_NOT_UPDATED   EXCEPTION;
Line: 2093

SAVEPOINT		update_wrap_acct_routes_1_PVT;
Line: 2119

        iem_route_pvt.update_account_routes (p_api_version_number =>p_api_version_number,
                             p_init_msg_list => FND_API.G_FALSE,
                             p_commit => FND_API.G_TRUE,


                             p_route_id =>  p_route_ids_tbl(i),
                             p_email_account_id => p_email_account_id,
                             p_destination_grp_id => p_upd_dest_ids_tbl(i),
                             p_default_grp_id =>p_upd_default_ids_tbl(i),
                             p_enabled_flag =>  p_upd_enable_flag_tbl(i),


                               x_return_status =>l_return_status,
                              x_msg_count   => l_msg_count,
                              x_msg_data => l_msg_data);
Line: 2137

            raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
Line: 2142

SAVEPOINT		update_wrap_acct_routes_2_PVT;
Line: 2147

        iem_route_pvt.delete_acct_route_batch
             (p_api_version_number   =>  p_api_version_number,
              P_init_msg_list   => FND_API.G_FALSE,

              p_commit       => FND_API.G_TRUE,
              p_route_ids_tbl =>  p_delete_route_ids_tbl,
              p_account_id => p_email_account_id,
              x_return_status =>  l_return_status,
              x_msg_count   =>   l_msg_count,
              x_msg_data    =>    l_msg_data) ;
Line: 2158

            raise IEM_ACCOUNT_ROUTE_NOT_DELETED;
Line: 2185

    WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
      	   ROLLBACK TO update_wrap_acct_routes_1_PVT;
Line: 2187

           FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
Line: 2193

    WHEN IEM_ACCOUNT_ROUTE_NOT_DELETED THEN
      	   ROLLBACK TO update_wrap_acct_routes_2_PVT;
Line: 2195

           FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_DELETED');
Line: 2200

	ROLLBACK TO update_wrap_acct_routes_2_PVT;
Line: 2210

	ROLLBACK TO update_wrap_acct_routes_2_PVT;
Line: 2218

	ROLLBACK TO update_wrap_acct_routes_2_PVT;
Line: 2237

 END	update_wrap_account_routes;