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_ROUTE_CLASS_PVT dependencies on IEM_ROUTE_CLASS_PVT

Line 1: PACKAGE BODY IEM_ROUTE_CLASS_PVT AS

1: PACKAGE BODY IEM_ROUTE_CLASS_PVT AS
2: /* $Header: iemvclxb.pls 120.4 2006/06/19 14:33:40 pkesani ship $ */
3: --
4: --
5: -- Purpose: Mantain route classification related operations

Line 30: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_CLASS_PVT ';

26: -- the classification, that is to be deleted.
27: -- changed it from iem_post_mdts to iem_rt_proc_emails table.
28: -- --------- ------ ------------------------------------------
29: -- Enter procedure, function bodies as shown below
30: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_CLASS_PVT ';
31:
32: G_CLASS_ID varchar2(30) ;
33:
34: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

Line 194: --iem_route_class_pvt.delete_folder_on_classId(p_api_version_number =>p_api_version_number,

190: l_undeleted_class_name := l_undeleted_class_name||l_undeleted_class_name_1||', ';
191: else
192:
193: --First delete classification folder for all the email account that assoicated with this classification
194: --iem_route_class_pvt.delete_folder_on_classId(p_api_version_number =>p_api_version_number,
195: -- p_init_msg_list => p_init_msg_list,
196: -- p_commit => p_init_msg_list,
197: -- p_classification_id =>p_class_ids_tbl(i),
198: -- x_return_status =>l_return_status,

Line 221: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.delete_item_batch.START', logMessage);

217:
218: logMessage := '[account id ' || to_char(i)||'is
219: : ' || to_char(acct_id.email_account_id) || ']';
220:
221: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.delete_item_batch.START', logMessage);
222: end if;
223: */
224: Update iem_account_route_class ac set ac.priority=ac.priority-1
225: where ac.email_account_id=acct_id.email_account_id and ac.priority > (Select be.priority from iem_account_route_class be

Line 382: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.CREATE_ITEM_WRAP.START') then

378: --API Body
379: /*
380: FND_LOG_REPOSITORY.init(null,null);
381:
382: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.CREATE_ITEM_WRAP.START') then
383: logMessage := '[create item is called!]';
384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.CREATE_ITEM_WRAP.START', logMessage);
385: end if;
386: */

Line 384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.CREATE_ITEM_WRAP.START', logMessage);

380: FND_LOG_REPOSITORY.init(null,null);
381:
382: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.CREATE_ITEM_WRAP.START') then
383: logMessage := '[create item is called!]';
384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PVT.CREATE_ITEM_WRAP.START', logMessage);
385: end if;
386: */
387: --Now call the create_item() to create the acccount
388: if ( p_class_boolean_type_code = 'DYNAMIC' ) then

Line 395: iem_route_class_pvt.create_item_class (

391: l_return_type := FND_API.G_MISS_CHAR;
392: end if;
393:
394: --Now call the create_item() to create the acccount
395: iem_route_class_pvt.create_item_class (
396:
397: p_api_version_number=>p_api_version_number,
398: p_init_msg_list => p_init_msg_list,
399: p_commit => p_commit,

Line 425: iem_route_class_pvt.create_item_class_rules (

421:
422: FOR i IN p_rule_key_typecode_tbl.FIRST..p_rule_operator_typecode_tbl.LAST loop
423:
424:
425: iem_route_class_pvt.create_item_class_rules (
426: p_api_version_number=>p_api_version_number,
427: p_init_msg_list => p_init_msg_list,
428: p_commit => p_commit,
429: p_class_id => l_class_id,

Line 1035: iem_route_class_pvt.update_item_class(

1031: l_return_type := FND_API.G_MISS_CHAR;
1032: end if;
1033:
1034: --update iem_routes table
1035: iem_route_class_pvt.update_item_class(
1036: p_api_version_number => l_api_version_number,
1037: p_init_msg_list => FND_API.G_FALSE,
1038: p_commit => FND_API.G_FALSE,
1039: p_class_id => p_class_id,

Line 1059: iem_route_class_pvt.update_item_rule(p_api_version_number => l_api_version_number,

1055:
1056: if ( p_update_rule_ids_tbl.count <>0 ) then
1057:
1058: FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST loop
1059: iem_route_class_pvt.update_item_rule(p_api_version_number => l_api_version_number,
1060: p_init_msg_list => FND_API.G_FALSE,
1061: p_commit => FND_API.G_FALSE,
1062:
1063:

Line 1105: iem_route_class_pvt.create_item_class_rules (p_api_version_number=>p_api_version_number,

1101: end if;
1102:
1103: if ( p_new_rule_keys_tbl.count <> 0 ) then
1104: FOR i IN p_new_rule_keys_tbl.FIRST..p_new_rule_keys_tbl.LAST LOOP
1105: iem_route_class_pvt.create_item_class_rules (p_api_version_number=>p_api_version_number,
1106: p_init_msg_list => p_init_msg_list,
1107: p_commit => p_commit,
1108: p_class_id => p_class_id,
1109: p_key_type_code => p_new_rule_keys_tbl(i),

Line 1666: iem_route_class_pvt.create_item_account_class(

1662:
1663: end if;
1664:
1665:
1666: iem_route_class_pvt.create_item_account_class(
1667:
1668: p_api_version_number =>p_api_version_number,
1669: p_init_msg_list => p_init_msg_list,
1670:

Line 1698: --iem_route_class_pvt.create_folder(p_api_version_number =>p_api_version_number,

1694:
1695: end if;
1696:
1697: -- ***** Remove for 11i compliance *****
1698: --iem_route_class_pvt.create_folder(p_api_version_number =>p_api_version_number,
1699: -- p_init_msg_list => p_init_msg_list,
1700: -- p_commit => FND_API.G_FALSE,
1701: -- p_email_account_id =>p_email_account_id,
1702: -- p_classification_name => l_class_name1,

Line 2047: iem_route_class_pvt.update_account_class (p_api_version_number =>p_api_version_number,

2043:
2044: -- update first
2045: if ( p_class_ids_tbl.count <> 0 ) then
2046: FOR i IN p_class_ids_tbl.FIRST..p_class_ids_tbl.LAST LOOP
2047: iem_route_class_pvt.update_account_class (p_api_version_number =>p_api_version_number,
2048: p_init_msg_list => p_init_msg_list,
2049:
2050: p_commit => FND_API.G_TRUE,
2051:

Line 2071: iem_route_class_pvt.delete_acct_class_batch

2067:
2068: --SAVEPOINT update_wrap_acct_class_2_PVT;
2069:
2070: if ( p_delete_class_ids_tbl.count <> 0 ) then
2071: iem_route_class_pvt.delete_acct_class_batch
2072: (p_api_version_number => p_api_version_number,
2073: P_init_msg_list => p_init_msg_list,
2074:
2075: p_commit => FND_API.G_TRUE,

Line 2389: --iem_route_class_pvt.delete_folder(p_api_version_number =>p_api_version_number,

2385: else
2386:
2387: -- ***** Removed for 11i compliance *****
2388: --delete the classification folder in OES first
2389: --iem_route_class_pvt.delete_folder(p_api_version_number =>p_api_version_number,
2390: -- p_init_msg_list => p_init_msg_list,
2391: -- p_commit => FND_API.G_FALSE,
2392: -- p_email_account_id =>p_account_id,
2393: -- p_class_id => p_class_ids_tbl(i),

Line 2534: --iem_route_class_pvt.delete_folder(p_api_version_number =>p_api_version_number,

2530:
2531: --actuall API starts here
2532: FOR acct_id IN acct_id_cursor( p_classification_id ) LOOP
2533: -- ***** Remove for 11i compliance ***
2534: --iem_route_class_pvt.delete_folder(p_api_version_number =>p_api_version_number,
2535: -- p_init_msg_list => p_init_msg_list,
2536: -- p_commit => FND_API.G_FALSE,
2537: -- p_email_account_id =>acct_id.email_account_id,
2538: -- p_class_id => p_classification_id,

Line 3123: --iem_route_class_pvt.delete_folder(p_api_version_number =>p_api_version_number,

3119: -- if l_count_msg_postmdt <> 0 then
3120: -- RAISE MY_EXCP_MSG_IN_FOLDER;
3121: -- end if;
3122:
3123: --iem_route_class_pvt.delete_folder(p_api_version_number =>p_api_version_number,
3124: -- p_init_msg_list => p_init_msg_list,
3125: -- p_commit => FND_API.G_FALSE,
3126: -- p_email_account_id =>p_email_account_id,
3127: -- p_class_id => class_id.route_classification_id,

Line 3195: END IEM_ROUTE_CLASS_PVT; -- Package Body IEM_ROUTE_CLASS_PVT

3191: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
3192:
3193: END delete_association_on_acctId;
3194:
3195: END IEM_ROUTE_CLASS_PVT; -- Package Body IEM_ROUTE_CLASS_PVT