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.AME_MULTI_TENANCY_PKG dependencies on FND_FILE

Line 21: Fnd_file.put_line(FND_FILE.LOG,'Error in enabling global context:'||sqlerrm);

17: l_proc_name := 'enable_globalcontext';
18: hr_multi_tenancy_pkg.set_context('ENT');
19: exception
20: when others then
21: Fnd_file.put_line(FND_FILE.LOG,'Error in enabling global context:'||sqlerrm);
22: logMessage(l_proc_name,'unable to set the global context');
23: end enable_globalcontext;
24: --+
25: function isSeedUser(userId in number) return varchar2 is

Line 68: Fnd_file.put_line(FND_FILE.LOG,'Error in enabling org context:'||sqlerrm);

64: l_proc_name := 'enable_orgcontext';
65: hr_multi_tenancy_pkg.set_context(g_enterprise_label);
66: exception
67: when others then
68: Fnd_file.put_line(FND_FILE.LOG,'Error in enabling org context:'||sqlerrm);
69: logMessage(l_proc_name, 'unable to set the org conext for enterprise Id:');
70: end enable_orgcontext;
71: --+
72: procedure createTxnType(cpTxnTypeIn in varchar2) is

Line 112: Fnd_file.put_line(FND_FILE.LOG,'Found existing transaction type for the enterprise');

108: fetch chkTxnType into l_application_id;
109: close chkTxnType;
110: if l_application_id is not null then
111: logMessage(l_proc_name,'Transaction Type is found');
112: Fnd_file.put_line(FND_FILE.LOG,'Found existing transaction type for the enterprise');
113: Fnd_file.put_line(FND_FILE.LOG,'AME application id:'||l_application_id);
114: g_ent_appl_id := l_application_id;
115: l_appl_name := l_seed_apl_name || ':' || g_enterprise;
116: for upd_rec in getTxnUpdDets(l_appl_name) loop

Line 113: Fnd_file.put_line(FND_FILE.LOG,'AME application id:'||l_application_id);

109: close chkTxnType;
110: if l_application_id is not null then
111: logMessage(l_proc_name,'Transaction Type is found');
112: Fnd_file.put_line(FND_FILE.LOG,'Found existing transaction type for the enterprise');
113: Fnd_file.put_line(FND_FILE.LOG,'AME application id:'||l_application_id);
114: g_ent_appl_id := l_application_id;
115: l_appl_name := l_seed_apl_name || ':' || g_enterprise;
116: for upd_rec in getTxnUpdDets(l_appl_name) loop
117: l_ovn := upd_rec.object_version_number;

Line 131: Fnd_file.put_line(FND_FILE.LOG,'Updated the existing transaction type');

127: set created_by = getSeedUser
128: ,last_updated_by = getSeedUser
129: where application_id = g_ent_appl_id
130: and language = userenv('LANG');
131: Fnd_file.put_line(FND_FILE.LOG,'Updated the existing transaction type');
132: end loop;
133: return;
134: end if;
135: open chkTxnCust(cpTxnTypeIn);

Line 140: Fnd_file.put_line(FND_FILE.LOG,'The existing transaction type has been deleted');

136: fetch chkTxnCust into l_count;
137: close chkTxnCust;
138: -- the txn has been deleted, do not create
139: if l_count > 0 then
140: Fnd_file.put_line(FND_FILE.LOG,'The existing transaction type has been deleted');
141: return;
142: end if;
143: l_appl_name := l_seed_apl_name || ':' || g_enterprise; -- check for buffer overflow
144: logMessage(l_proc_name,'Creating the transaction type with name : ' || l_appl_name);

Line 185: Fnd_file.put_line(FND_FILE.LOG,'Transaction Type has been created with AME application Id:'||g_ent_appl_id);

181: set created_by = getSeedUser
182: ,last_updated_by = getSeedUser
183: where application_id = g_ent_appl_id
184: and sysdate between start_date and nvl(end_Date,sysdate);
185: Fnd_file.put_line(FND_FILE.LOG,'Transaction Type has been created with AME application Id:'||g_ent_appl_id);
186: exception
187: when others then
188: Fnd_file.put_line(FND_FILE.LOG,'Error in createTxnType:'||sqlerrm);
189: logMessage(l_proc_name,sqlerrm);

Line 188: Fnd_file.put_line(FND_FILE.LOG,'Error in createTxnType:'||sqlerrm);

184: and sysdate between start_date and nvl(end_Date,sysdate);
185: Fnd_file.put_line(FND_FILE.LOG,'Transaction Type has been created with AME application Id:'||g_ent_appl_id);
186: exception
187: when others then
188: Fnd_file.put_line(FND_FILE.LOG,'Error in createTxnType:'||sqlerrm);
189: logMessage(l_proc_name,sqlerrm);
190: raise;
191: end createTxnType;
192: --+

Line 222: Fnd_file.put_line(FND_FILE.LOG,'Updating the configuration variable usage for the transaction type');

218: and isEntDataModified(ent.creation_date,ent.last_update_date) = ame_util.booleanFalse;
219: --
220: begin
221: l_proc_name := 'updateConfigVars';
222: Fnd_file.put_line(FND_FILE.LOG,'Updating the configuration variable usage for the transaction type');
223: for i in 1..g_seed_config_usg.count loop
224: logMessage(l_proc_name,'Setting up Config Var : ' || g_seed_config_usg(i).variable_name);
225: open checkConfigExists(g_seed_config_usg(i).variable_name);
226: fetch checkConfigExists into l_count;

Line 233: Fnd_file.put_line(FND_FILE.LOG,'Creating the configuration variable usage for:'||

229: if l_count = 0 then
230: logMessage(l_proc_name,'The Config Var is not found');
231: l_ovn := null;
232: l_config_varname := g_seed_config_usg(i).variable_name;
233: Fnd_file.put_line(FND_FILE.LOG,'Creating the configuration variable usage for:'||
234: g_seed_config_usg(i).variable_name);
235: ame_config_var_api.update_ame_config_variable
236: (p_application_id => g_ent_appl_id
237: ,p_variable_name => l_config_varname

Line 256: Fnd_file.put_line(FND_FILE.LOG,'Updating the configuration variable usage:'||

252: ,c_var_value =>g_seed_config_usg(i).variable_value) loop
253: if isSeedUser(g_seed_config_usg(i).last_updated_by) = ame_util.booleanTrue then
254: l_ovn := upd_rec.object_version_number;
255: logMessage(l_proc_name,'The Config Var is updated');
256: Fnd_file.put_line(FND_FILE.LOG,'Updating the configuration variable usage:'||
257: g_seed_config_usg(i).variable_name);
258: ame_config_var_api.update_ame_config_variable
259: (p_application_id => g_ent_appl_id
260: ,p_variable_name => g_seed_config_usg(i).variable_name

Line 278: Fnd_file.put_line(FND_FILE.LOG,'Error updateConfigVars:'||sqlerrm);

274: end if;
275: end loop;
276: exception
277: when others then
278: Fnd_file.put_line(FND_FILE.LOG,'Error updateConfigVars:'||sqlerrm);
279: logMessage(l_proc_name,l_config_varname||':'||sqlerrm);
280: raise;
281: end updateConfigVars;
282: --+

Line 321: Fnd_file.put_line(FND_FILE.LOG,'Updating the Item class usage for the transaction type');

317: and isEntDataModified(ent.creation_date,ent.last_update_date) = ame_util.booleanFalse;
318: --
319: begin
320: l_proc_name := 'updateItemClassUsage';
321: Fnd_file.put_line(FND_FILE.LOG,'Updating the Item class usage for the transaction type');
322: for i in 1..g_seed_ic_usg.count loop
323: l_item_class_id := g_seed_ic_usg(i).item_class_id;
324: logMessage(l_proc_name,'Setting up the item class usage for : ' || l_item_class_id);
325: open chkExists(l_item_class_id);

Line 334: Fnd_file.put_line(FND_FILE.LOG,'Updating the Item class id: '||l_item_class_id||' :usage');

330: for upd_rec in getUpdDetails(l_item_class_id) loop
331: if isSeedUser(g_seed_ic_usg(i).last_updated_by) = ame_util.booleanTrue then
332: l_ovn := upd_rec.object_version_number;
333: logMessage(l_proc_name,'Updating the item class usage for : ' || l_item_class_id);
334: Fnd_file.put_line(FND_FILE.LOG,'Updating the Item class id: '||l_item_class_id||' :usage');
335: ame_item_class_api.update_ame_item_class_usage
336: (p_application_id => g_ent_appl_id
337: ,p_item_class_id => l_item_class_id
338: ,p_item_id_query => g_seed_ic_usg(i).item_id_query

Line 357: Fnd_file.put_line(FND_FILE.LOG,'Creating the Item class id: '||l_item_class_id||' :usage');

353: end loop;
354: else
355: l_application_id := g_ent_appl_id;
356: logMessage(l_proc_name,'Creating the item class usage for : ' || l_item_class_id);
357: Fnd_file.put_line(FND_FILE.LOG,'Creating the Item class id: '||l_item_class_id||' :usage');
358: ame_item_class_api.create_ame_item_class_usage
359: (p_item_id_query => g_seed_ic_usg(i).item_id_query
360: ,p_item_class_order_number => g_seed_ic_usg(i).item_class_order_number
361: ,p_item_class_par_mode => g_seed_ic_usg(i).item_class_par_mode

Line 379: Fnd_file.put_line(FND_FILE.LOG,'Error in updateItemClassUsage:'||sqlerrm);

375: end if;
376: end loop;
377: exception
378: when others then
379: Fnd_file.put_line(FND_FILE.LOG,'Error in updateItemClassUsage:'||sqlerrm);
380: logMessage(l_proc_name,l_item_class_id||':'||sqlerrm);
381: raise;
382: end updateItemClassUsage;
383: --+

Line 435: Fnd_file.put_line(FND_FILE.LOG,'Error in updateMandAtrUsages:'||sqlerrm);

431: end loop;
432: end loop;
433: exception
434: when others then
435: Fnd_file.put_line(FND_FILE.LOG,'Error in updateMandAtrUsages:'||sqlerrm);
436: logMessage(l_proc_name,l_attribute_name||':'||sqlerrm);
437: raise;
438: end updateMandAtrUsages;
439: --+

Line 469: Fnd_file.put_line(FND_FILE.LOG,'Updating the attribute usage for the transaction type');

465: --
466: begin
467: l_proc_name := 'createAttrUsage';
468: updateMandAtrUsages;
469: Fnd_file.put_line(FND_FILE.LOG,'Updating the attribute usage for the transaction type');
470: for i in 1..g_seed_attr_usg.count loop
471: l_attribute_id := g_seed_attr_usg(i).attribute_id;
472: logMessage(l_proc_name,'Setting up the attribute : ' || l_attribute_id);
473: l_count := 0;

Line 483: Fnd_file.put_line(FND_FILE.LOG,'Updating the usage for the attribute:'||l_attribute_id);

479: ,g_seed_attr_usg(i).query_string
480: ,g_seed_attr_usg(i).value_set_id) loop
481: if isSeedUser(g_seed_attr_usg(i).last_updated_by) = ame_util.booleanTrue then
482: logMessage(l_proc_name,'Updating the attribute usage for : ' || l_attribute_id);
483: Fnd_file.put_line(FND_FILE.LOG,'Updating the usage for the attribute:'||l_attribute_id);
484: l_ovn := upd_rec.object_version_number;
485: ame_attribute_api.update_ame_attribute_usage
486: (p_attribute_id => l_attribute_id
487: ,p_application_id => g_ent_appl_id

Line 507: Fnd_file.put_line(FND_FILE.LOG,'Creating the usage for the attribute:'||l_attribute_id);

503: end if;
504: end loop;
505: else
506: logMessage(l_proc_name,'Creating the attribute usage for : ' || l_attribute_id);
507: Fnd_file.put_line(FND_FILE.LOG,'Creating the usage for the attribute:'||l_attribute_id);
508: ame_attribute_api.create_ame_attribute_usage
509: (p_attribute_id => l_attribute_id
510: ,p_application_id => g_ent_appl_id
511: ,p_is_static => g_seed_attr_usg(i).is_static

Line 531: Fnd_file.put_line(FND_FILE.LOG,'Error in createAttrUsage:'||sqlerrm);

527: end loop;
528: --
529: exception
530: when others then
531: Fnd_file.put_line(FND_FILE.LOG,'Error in createAttrUsage:'||sqlerrm);
532: logMessage(l_proc_name,l_attribute_id||':'||sqlerrm);
533: raise;
534: end createAttrUsage;
535: --+

Line 564: Fnd_file.put_line(FND_FILE.LOG,'Updating the action type configuration for the transaction type');

560: and sysdate between ent.start_Date and nvl(ent.end_Date,sysdate)
561: and isEntDataModified(ent.creation_date,ent.last_update_date) = ame_util.booleanFalse ;
562: begin
563: l_proc_name := 'updateActionTypeConfig';
564: Fnd_file.put_line(FND_FILE.LOG,'Updating the action type configuration for the transaction type');
565: for i in 1..g_seed_act_config.count loop
566: l_action_type_id := g_seed_act_config(i).action_type_id;
567: logMessage(l_proc_name,'Setting up the action type config: ' || l_action_type_id);
568: open chkActionTypeUsg(l_action_type_id);

Line 578: Fnd_file.put_line(FND_FILE.LOG,'Updating the action type configuration for:'||l_action_type_id);

574: ,g_seed_act_config(i).chain_ordering_mode
575: ,g_seed_act_config(i).order_number) loop
576: --call update methods
577: if isSeedUser(g_seed_act_config(i).last_updated_by) = ame_util.booleanTrue then
578: Fnd_file.put_line(FND_FILE.LOG,'Updating the action type configuration for:'||l_action_type_id);
579: logMessage(l_proc_name,'Updating up the action type config: ' || l_action_type_id);
580: l_ovn := upd_rec.object_version_number;
581: ame_action_api.update_ame_action_type_conf
582: (p_action_type_id => l_action_type_id,

Line 601: Fnd_file.put_line(FND_FILE.LOG,'Creating the action type configuration for:'||l_action_type_id);

597: end if;
598: end loop;
599: else
600: logMessage(l_proc_name,'Creating up the action type config: ' || l_action_type_id);
601: Fnd_file.put_line(FND_FILE.LOG,'Creating the action type configuration for:'||l_action_type_id);
602: ame_action_api.create_ame_action_type_conf
603: (p_action_type_id => l_action_type_id
604: ,p_application_id => g_ent_appl_id
605: ,p_voting_regime => g_seed_act_config(i).voting_regime

Line 622: Fnd_file.put_line(FND_FILE.LOG,'Error in updateActionTypeConfig:'||sqlerrm);

618: end if;
619: end loop;
620: exception
621: when others then
622: Fnd_file.put_line(FND_FILE.LOG,'Error in updateActionTypeConfig:'||sqlerrm);
623: logMessage(l_proc_name, sqlerrm);
624: raise;
625: end updateActionTypeConfig;
626: --+

Line 653: Fnd_file.put_line(FND_FILE.LOG,'Updating group configuration for:'||g_seed_group_data(i).name);

649: and isEntDataModified(ent.creation_date,ent.last_update_date) = ame_util.booleanFalse;
650: begin
651: l_proc_name := 'createAprGrpConfig';
652: logMessage(l_proc_name,'Setting up the Group Config for : ' ||g_seed_group_data(i).approval_group_id );
653: Fnd_file.put_line(FND_FILE.LOG,'Updating group configuration for:'||g_seed_group_data(i).name);
654: open chkGrpConfig(p_ent_grp_id);
655: fetch chkGrpConfig into l_count;
656: close chkGrpConfig;
657: if l_count > 0 then

Line 663: Fnd_file.put_line(FND_FILE.LOG,'Updating existing group configuration for:'||g_seed_group_data(i).name);

659: g_seed_group_data(i).order_number) loop
660: if isSeedUser(g_seed_group_data(i).config_last_updated_by) = ame_util.booleanTrue then
661: l_ovn := upd_Rec.object_version_number;
662: logMessage(l_proc_name,'Updating the approval group config : ' || g_seed_group_data(i).name);
663: Fnd_file.put_line(FND_FILE.LOG,'Updating existing group configuration for:'||g_seed_group_data(i).name);
664: ame_approver_group_api.update_approver_group_config
665: (
666: p_approval_group_id => p_ent_grp_id
667: ,p_application_id => g_ent_appl_id

Line 684: Fnd_file.put_line(FND_FILE.LOG,'Creating group configuration for:'||g_seed_group_data(i).name);

680: end if;
681: end loop;
682: else
683: logMessage(l_proc_name,'Creating the approval group config : ' || g_seed_group_data(i).name);
684: Fnd_file.put_line(FND_FILE.LOG,'Creating group configuration for:'||g_seed_group_data(i).name);
685: ame_approver_group_api.create_approver_group_config
686: (
687: p_approval_group_id => p_ent_grp_id
688: ,p_application_id => g_ent_appl_id

Line 705: Fnd_file.put_line(FND_FILE.LOG,'Error in createAprGrpConfig:'||sqlerrm);

701: end if;
702: --+
703: exception
704: when others then
705: Fnd_file.put_line(FND_FILE.LOG,'Error in createAprGrpConfig:'||sqlerrm);
706: logMessage(l_proc_name, p_ent_grp_id||':'||sqlerrm);
707: raise;
708: end createAprGrpConfig;
709: --+

Line 733: Fnd_file.put_line(FND_FILE.LOG,'Creating the transaction type group usage:'||g_seed_group_data(groupIndex).name);

729: and isEntDataModified(ent.creation_date,ent.last_update_date) = ame_util.booleanFalse;
730: begin
731: l_proc_name := 'createAprGrp';
732: logMessage(l_proc_name,'Setting up the approval group : ' || g_seed_group_data(groupIndex).name);
733: Fnd_file.put_line(FND_FILE.LOG,'Creating the transaction type group usage:'||g_seed_group_data(groupIndex).name);
734: open chkGrp(g_seed_group_data(groupIndex).name);
735: fetch chkGrp into l_current_grp_id;
736: close chkGrp;
737: if l_current_grp_id is null then

Line 739: Fnd_file.put_line(FND_FILE.LOG,'Creating the approval group:'||g_seed_group_data(groupIndex).name);

735: fetch chkGrp into l_current_grp_id;
736: close chkGrp;
737: if l_current_grp_id is null then
738: logMessage(l_proc_name,'Creating the approval group : ' || g_seed_group_data(groupIndex).name);
739: Fnd_file.put_line(FND_FILE.LOG,'Creating the approval group:'||g_seed_group_data(groupIndex).name);
740: ame_approver_group_api.create_ame_approver_group
741: (p_name => g_seed_group_data(groupIndex).name
742: --,p_description => g_enterprise||':'||g_seed_group_data(groupIndex).description
743: ,p_description => g_seed_group_data(groupIndex).description

Line 770: Fnd_file.put_line(FND_FILE.LOG,'Updating the existing approval group:'||g_seed_group_data(groupIndex).name);

766: ,c_query_string => g_seed_group_data(groupIndex).query_string) loop
767: if isSeedUser(g_seed_group_data(groupIndex).group_last_updated_by) = ame_util.booleanTrue then
768: l_ovn := upd_rec.object_version_number;
769: logMessage(l_proc_name,'Updating the approval group : ' || g_seed_group_data(groupIndex).name);
770: Fnd_file.put_line(FND_FILE.LOG,'Updating the existing approval group:'||g_seed_group_data(groupIndex).name);
771: ame_approver_group_api.update_ame_approver_group
772: (p_approval_group_id => l_current_grp_id
773: ,p_is_static => g_seed_group_data(groupIndex).is_static
774: ,p_query_string => g_seed_group_data(groupIndex).query_string

Line 796: Fnd_file.put_line(FND_FILE.LOG,'Error in createAprGrp:'||sqlerrm);

792: end loop;
793: end if;
794: exception
795: when others then
796: Fnd_file.put_line(FND_FILE.LOG,'Error in createAprGrp:'||sqlerrm);
797: logMessage(l_proc_name, g_seed_group_data(groupIndex).name||':'||sqlerrm);
798: raise;
799: end createAprGrp;
800: --+

Line 823: Fnd_file.put_line(FND_FILE.LOG,'Error in updateGroupsConfig:'||sqlerrm);

819: createAprGrp(groupIndex => i);
820: end loop;
821: exception
822: when others then
823: Fnd_file.put_line(FND_FILE.LOG,'Error in updateGroupsConfig:'||sqlerrm);
824: logMessage(l_proc_name, l_name||':'||sqlerrm);
825: raise;
826: end updateGroupsConfig;
827: --+

Line 1055: Fnd_file.put_line(FND_FILE.LOG,'Rule is created with id:'||l_current_rule_id);

1051: ,last_updated_by = getSeedUser
1052: where rule_id = l_current_rule_id
1053: and condition_id = l_conditionid;
1054: --
1055: Fnd_file.put_line(FND_FILE.LOG,'Rule is created with id:'||l_current_rule_id);
1056: if l_cond_list.count > 1 and l_current_rule_id is not null then
1057: for i in 2..l_cond_list.count loop
1058: ame_rule_api.create_ame_condition_to_rule
1059: (p_rule_id => l_current_rule_id

Line 1072: Fnd_file.put_line(FND_FILE.LOG,'Added the condition:'||l_cond_list(i));

1068: ,last_updated_by = getSeedUser
1069: where rule_id = l_current_rule_id
1070: and condition_id = l_cond_list(i)
1071: and sysdate between start_date and nvl(end_date,sysdate);
1072: Fnd_file.put_line(FND_FILE.LOG,'Added the condition:'||l_cond_list(i));
1073: end loop;
1074: end if;
1075: if l_ation_list.count > 1 and l_current_rule_id is not null then
1076: for i in 2..l_ation_list.count loop

Line 1091: Fnd_file.put_line(FND_FILE.LOG,'Added the action:'||l_action_id);

1087: ,last_updated_by = getSeedUser
1088: where rule_id = l_current_rule_id
1089: and action_id = l_action_id
1090: and sysdate between start_date and nvl(end_date,sysdate);
1091: Fnd_file.put_line(FND_FILE.LOG,'Added the action:'||l_action_id);
1092: end loop;
1093: end if;
1094: exception
1095: when others then

Line 1096: Fnd_file.put_line(FND_FILE.LOG,'Error in crtRule:'||sqlerrm);

1092: end loop;
1093: end if;
1094: exception
1095: when others then
1096: Fnd_file.put_line(FND_FILE.LOG,'Error in crtRule:'||sqlerrm);
1097: logMessage(l_proc_name,sqlerrm);
1098: raise;
1099: end crtRule;
1100: --+

Line 1147: Fnd_file.put_line(FND_FILE.LOG,'Rule found to be customized');

1143: close chkCustRule;
1144: if l_end_Date_count > 0 then
1145: -- customization found found
1146: p_custfoundOut := 'Y';
1147: Fnd_file.put_line(FND_FILE.LOG,'Rule found to be customized');
1148: return;
1149: else
1150: -- create flow
1151: crtRule(p_rule_index,l_current_rul_id);

Line 1155: Fnd_file.put_line(FND_FILE.LOG,'Error in createRules:'||sqlerrm);

1151: crtRule(p_rule_index,l_current_rul_id);
1152: end if;
1153: exception
1154: when others then
1155: Fnd_file.put_line(FND_FILE.LOG,'Error in createRules:'||sqlerrm);
1156: logMessage(l_proc_name,sqlerrm);
1157: raise;
1158: end createRules;
1159: --+

Line 1203: Fnd_file.put_line(FND_FILE.LOG,'Setting up the Rule:'||l_rule_name);

1199: for i in 1..g_seed_ame_rule.count loop
1200: l_rule_name := g_seed_ame_rule(i).description;
1201: l_seed_rule_id := g_seed_ame_rule(i).rule_id;
1202: logMessage(l_proc_name,'Setting up the Rule : ' ||l_rule_name);
1203: Fnd_file.put_line(FND_FILE.LOG,'Setting up the Rule:'||l_rule_name);
1204: open chkRulUsg(l_rule_name);
1205: fetch chkRulUsg into l_count;
1206: close chkRulUsg;
1207: if l_count > 0 then

Line 1209: Fnd_file.put_line(FND_FILE.LOG,'Rule is already found found');

1205: fetch chkRulUsg into l_count;
1206: close chkRulUsg;
1207: if l_count > 0 then
1208: logMessage(l_proc_name,'Rule is found');
1209: Fnd_file.put_line(FND_FILE.LOG,'Rule is already found found');
1210: else
1211: logMessage(l_proc_name,'Rule is not found, so creating the rule');
1212: Fnd_file.put_line(FND_FILE.LOG,'Rule not found, Creating the rule');
1213: createRules(p_rule_index => i

Line 1212: Fnd_file.put_line(FND_FILE.LOG,'Rule not found, Creating the rule');

1208: logMessage(l_proc_name,'Rule is found');
1209: Fnd_file.put_line(FND_FILE.LOG,'Rule is already found found');
1210: else
1211: logMessage(l_proc_name,'Rule is not found, so creating the rule');
1212: Fnd_file.put_line(FND_FILE.LOG,'Rule not found, Creating the rule');
1213: createRules(p_rule_index => i
1214: ,p_rule_idOut => l_current_rule_id
1215: ,p_custfoundOut => l_custom);
1216: end if;

Line 1220: Fnd_file.put_line(FND_FILE.LOG,'Error in updateRuleUsg:'||sqlerrm);

1216: end if;
1217: end loop;
1218: exception
1219: when others then
1220: Fnd_file.put_line(FND_FILE.LOG,'Error in updateRuleUsg:'||sqlerrm);
1221: logMessage(l_proc_name,l_rule_name||':'||sqlerrm);
1222: raise;
1223: end updateRuleUsg;
1224: --+

Line 1241: Fnd_file.put_line(FND_FILE.LOG,'Start reading the data for seed transaction');

1237: and application_id = c_appl_id
1238: and sysdate between start_date and nvl(end_date,sysdate);
1239: begin
1240: l_proc_name := 'fetchSeedDataFromTables';
1241: Fnd_file.put_line(FND_FILE.LOG,'Start reading the data for seed transaction');
1242: --+
1243: logMessage(l_proc_name,'Reading transaction type data for ' || g_seed_txntype);
1244: open seed_row for
1245: select *

Line 1266: Fnd_file.put_line(FND_FILE.LOG,'changing the SSHR transaction configuration variable to yes');

1262: open getAllowApprTypeConfig(0);
1263: fetch getAllowApprTypeConfig into l_app_config_val,l_ovn1;
1264: close getAllowApprTypeConfig;
1265: if l_app_config_val = 'no' then
1266: Fnd_file.put_line(FND_FILE.LOG,'changing the SSHR transaction configuration variable to yes');
1267: ame_config_var_api.update_ame_config_variable
1268: (p_application_id => g_seed_appl_id
1269: ,p_variable_name => ame_util.allowAllApproverTypesConfigVar
1270: ,p_variable_value => 'yes'

Line 1280: Fnd_file.put_line(FND_FILE.LOG,'Updated the SSHR default configuration variable to yes');

1276: set last_updated_by = getSeedUser
1277: where application_id = g_seed_appl_id
1278: and variable_name = ame_util.allowAllApproverTypesConfigVar
1279: and sysdate between start_date and nvl(end_date,sysdate);
1280: Fnd_file.put_line(FND_FILE.LOG,'Updated the SSHR default configuration variable to yes');
1281: end if;
1282: end if;
1283: end if;
1284: logMessage(l_proc_name,'Reading configuration variables data');

Line 1444: Fnd_file.put_line(FND_FILE.LOG,'Completed reading the data for seed transaction');

1440: order by acu.rule_id;
1441: fetch seed_row bulk collect into g_seed_cond_usage;
1442: close seed_row;
1443: --
1444: Fnd_file.put_line(FND_FILE.LOG,'Completed reading the data for seed transaction');
1445: exception
1446: when others then
1447: Fnd_file.put_line(FND_FILE.LOG,'Error in fetchSeedDataFromTables:'||sqlerrm);
1448: logMessage('fetchSeedDataFromTables',sqlerrm);

Line 1447: Fnd_file.put_line(FND_FILE.LOG,'Error in fetchSeedDataFromTables:'||sqlerrm);

1443: --
1444: Fnd_file.put_line(FND_FILE.LOG,'Completed reading the data for seed transaction');
1445: exception
1446: when others then
1447: Fnd_file.put_line(FND_FILE.LOG,'Error in fetchSeedDataFromTables:'||sqlerrm);
1448: logMessage('fetchSeedDataFromTables',sqlerrm);
1449: raise;
1450: end fetchSeedDataFromTables;
1451: --+

Line 1462: Fnd_file.put_line(FND_FILE.LOG,'Fatal Exception - Could not find Enterprise');

1458: logMessage(l_proc_name,'Enabling the Global Context');
1459: enable_globalcontext;
1460: if g_enterprise_id is null then
1461: logMessage(l_proc_name,'Fatal Exception - Could not find Enterprise');
1462: Fnd_file.put_line(FND_FILE.LOG,'Fatal Exception - Could not find Enterprise');
1463: return;
1464: end if;
1465: l_txnTypeName := g_seed_txntype;
1466: fetchSeedDataFromTables;

Line 1468: Fnd_file.put_line(FND_FILE.LOG,'Enabling the Org Context to copy the seed date');

1464: end if;
1465: l_txnTypeName := g_seed_txntype;
1466: fetchSeedDataFromTables;
1467: logMessage(l_proc_name,'Enabling the Org Context');
1468: Fnd_file.put_line(FND_FILE.LOG,'Enabling the Org Context to copy the seed date');
1469: enable_orgcontext;
1470: createTxnType(cpTxnTypeIn => l_txnTypeName);
1471: if g_ent_appl_id is not null then
1472: updateConfigVars;

Line 1481: Fnd_file.put_line(FND_FILE.LOG,'Error in copyEntTxnType:'||sqlerrm);

1477: updateRuleUsg;
1478: end if;
1479: exception
1480: when others then
1481: Fnd_file.put_line(FND_FILE.LOG,'Error in copyEntTxnType:'||sqlerrm);
1482: logMessage('copyEntTxnType',sqlerrm);
1483: raise;
1484: end;
1485: --+

Line 1506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy input parameter:');

1502: ,'C::'||enterprise_label
1503: from per_enterprises_vl
1504: where enterprise_id = c_enterpriseId;
1505: begin
1506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy input parameter:');
1507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'applicationIdIn:'||applicationIdIn);
1508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'enterpriseIdIn:'||enterpriseIdIn);
1509: Fnd_file.put_line(FND_FILE.LOG,'Start Copying the transaction type');
1510: logMessage('copyTxnType','param:applicationIdIn:'||applicationIdIn);

Line 1507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'applicationIdIn:'||applicationIdIn);

1503: from per_enterprises_vl
1504: where enterprise_id = c_enterpriseId;
1505: begin
1506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy input parameter:');
1507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'applicationIdIn:'||applicationIdIn);
1508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'enterpriseIdIn:'||enterpriseIdIn);
1509: Fnd_file.put_line(FND_FILE.LOG,'Start Copying the transaction type');
1510: logMessage('copyTxnType','param:applicationIdIn:'||applicationIdIn);
1511: logMessage('copyTxnType','param:enterpriseIdIn:'||enterpriseIdIn);

Line 1508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'enterpriseIdIn:'||enterpriseIdIn);

1504: where enterprise_id = c_enterpriseId;
1505: begin
1506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy input parameter:');
1507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'applicationIdIn:'||applicationIdIn);
1508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'enterpriseIdIn:'||enterpriseIdIn);
1509: Fnd_file.put_line(FND_FILE.LOG,'Start Copying the transaction type');
1510: logMessage('copyTxnType','param:applicationIdIn:'||applicationIdIn);
1511: logMessage('copyTxnType','param:enterpriseIdIn:'||enterpriseIdIn);
1512: if is_multi_tenant_system = ame_util.booleanFalse then

Line 1509: Fnd_file.put_line(FND_FILE.LOG,'Start Copying the transaction type');

1505: begin
1506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy input parameter:');
1507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'applicationIdIn:'||applicationIdIn);
1508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'enterpriseIdIn:'||enterpriseIdIn);
1509: Fnd_file.put_line(FND_FILE.LOG,'Start Copying the transaction type');
1510: logMessage('copyTxnType','param:applicationIdIn:'||applicationIdIn);
1511: logMessage('copyTxnType','param:enterpriseIdIn:'||enterpriseIdIn);
1512: if is_multi_tenant_system = ame_util.booleanFalse then
1513: Fnd_file.put_line(FND_FILE.LOG,'Current instance is not a multitenant instance, aborting the copy');

Line 1513: Fnd_file.put_line(FND_FILE.LOG,'Current instance is not a multitenant instance, aborting the copy');

1509: Fnd_file.put_line(FND_FILE.LOG,'Start Copying the transaction type');
1510: logMessage('copyTxnType','param:applicationIdIn:'||applicationIdIn);
1511: logMessage('copyTxnType','param:enterpriseIdIn:'||enterpriseIdIn);
1512: if is_multi_tenant_system = ame_util.booleanFalse then
1513: Fnd_file.put_line(FND_FILE.LOG,'Current instance is not a multitenant instance, aborting the copy');
1514: logMessage('copyTxnType','not a multitenancy instance');
1515: return;
1516: end if;
1517: open getTxnType(applicationIdIn);

Line 1523: Fnd_file.put_line(FND_FILE.LOG,'Seed Transaction type selected:'||g_seed_txntype);

1519: close getTxnType;
1520: g_enterprise_id := enterpriseIdIn;
1521: g_seed_txntype := l_txnTypeId;
1522: g_fnd_application_id := l_fnd_appl_id;
1523: Fnd_file.put_line(FND_FILE.LOG,'Seed Transaction type selected:'||g_seed_txntype);
1524: Fnd_file.put_line(FND_FILE.LOG,'Seed transaction type application id:'||g_fnd_application_id);
1525: open getEnterpriseName(enterpriseIdIn);
1526: fetch getEnterpriseName into g_enterprise,g_enterprise_label;
1527: close getEnterpriseName;

Line 1524: Fnd_file.put_line(FND_FILE.LOG,'Seed transaction type application id:'||g_fnd_application_id);

1520: g_enterprise_id := enterpriseIdIn;
1521: g_seed_txntype := l_txnTypeId;
1522: g_fnd_application_id := l_fnd_appl_id;
1523: Fnd_file.put_line(FND_FILE.LOG,'Seed Transaction type selected:'||g_seed_txntype);
1524: Fnd_file.put_line(FND_FILE.LOG,'Seed transaction type application id:'||g_fnd_application_id);
1525: open getEnterpriseName(enterpriseIdIn);
1526: fetch getEnterpriseName into g_enterprise,g_enterprise_label;
1527: close getEnterpriseName;
1528: Fnd_file.put_line(FND_FILE.LOG,'Enterprise name:'||g_enterprise);

Line 1528: Fnd_file.put_line(FND_FILE.LOG,'Enterprise name:'||g_enterprise);

1524: Fnd_file.put_line(FND_FILE.LOG,'Seed transaction type application id:'||g_fnd_application_id);
1525: open getEnterpriseName(enterpriseIdIn);
1526: fetch getEnterpriseName into g_enterprise,g_enterprise_label;
1527: close getEnterpriseName;
1528: Fnd_file.put_line(FND_FILE.LOG,'Enterprise name:'||g_enterprise);
1529: Fnd_file.put_line(FND_FILE.LOG,'Enterprise label:'||g_enterprise_label);
1530: logMessage('copyTxnType','param:g_enterprise:'||g_enterprise);
1531: logMessage('copyTxnType','param:g_enterprise_label:'||g_enterprise_label);
1532: copyEntTxnType;

Line 1529: Fnd_file.put_line(FND_FILE.LOG,'Enterprise label:'||g_enterprise_label);

1525: open getEnterpriseName(enterpriseIdIn);
1526: fetch getEnterpriseName into g_enterprise,g_enterprise_label;
1527: close getEnterpriseName;
1528: Fnd_file.put_line(FND_FILE.LOG,'Enterprise name:'||g_enterprise);
1529: Fnd_file.put_line(FND_FILE.LOG,'Enterprise label:'||g_enterprise_label);
1530: logMessage('copyTxnType','param:g_enterprise:'||g_enterprise);
1531: logMessage('copyTxnType','param:g_enterprise_label:'||g_enterprise_label);
1532: copyEntTxnType;
1533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy completed successfully');

Line 1533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy completed successfully');

1529: Fnd_file.put_line(FND_FILE.LOG,'Enterprise label:'||g_enterprise_label);
1530: logMessage('copyTxnType','param:g_enterprise:'||g_enterprise);
1531: logMessage('copyTxnType','param:g_enterprise_label:'||g_enterprise_label);
1532: copyEntTxnType;
1533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy completed successfully');
1534: exception
1535: when others then
1536: Fnd_file.put_line(FND_FILE.LOG,'Error in enabling org context:'||sqlerrm);
1537: logMessage('copyTxnType','error:'||sqlerrm);

Line 1536: Fnd_file.put_line(FND_FILE.LOG,'Error in enabling org context:'||sqlerrm);

1532: copyEntTxnType;
1533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Transaction Type copy completed successfully');
1534: exception
1535: when others then
1536: Fnd_file.put_line(FND_FILE.LOG,'Error in enabling org context:'||sqlerrm);
1537: logMessage('copyTxnType','error:'||sqlerrm);
1538: raise;
1539: end copyTxnType;
1540: --