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.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on IBE_UTIL

Line 4711: IBE_UTIL.debug('Calling Create_Hierarchy_Section for immediate section ');

4707:
4708: FOR r1 IN c1(p_src_section_id, l_master_mini_site_id) LOOP
4709: l_found := TRUE;
4710: IF (l_debug = 'Y') THEN
4711: IBE_UTIL.debug('Calling Create_Hierarchy_Section for immediate section ');
4712:
4713: IBE_UTIL.debug('parent section id:'||p_dst_parent_section_id);
4714: END IF;
4715: IF (G_ENABLE_TRACE= 'Y') THEN

Line 4713: IBE_UTIL.debug('parent section id:'||p_dst_parent_section_id);

4709: l_found := TRUE;
4710: IF (l_debug = 'Y') THEN
4711: IBE_UTIL.debug('Calling Create_Hierarchy_Section for immediate section ');
4712:
4713: IBE_UTIL.debug('parent section id:'||p_dst_parent_section_id);
4714: END IF;
4715: IF (G_ENABLE_TRACE= 'Y') THEN
4716: fnd_file.put_line(fnd_file.log,'Calling Create_Hierarchy_Section for immediate section ');
4717:

Line 4767: IBE_UTIL.debug('After Calling Create_Hierarchy_Section for immediate section ');

4763: x_msg_count => x_msg_count,
4764: x_msg_data => x_msg_data
4765: );
4766: IF (l_debug = 'Y') THEN
4767: IBE_UTIL.debug('After Calling Create_Hierarchy_Section for immediate section ');
4768: IBE_UTIL.debug('new section id:'||x_new_src_section_id);
4769:
4770: END IF;
4771: IF (G_ENABLE_TRACE= 'Y') THEN

Line 4768: IBE_UTIL.debug('new section id:'||x_new_src_section_id);

4764: x_msg_data => x_msg_data
4765: );
4766: IF (l_debug = 'Y') THEN
4767: IBE_UTIL.debug('After Calling Create_Hierarchy_Section for immediate section ');
4768: IBE_UTIL.debug('new section id:'||x_new_src_section_id);
4769:
4770: END IF;
4771: IF (G_ENABLE_TRACE= 'Y') THEN
4772: fnd_file.put_line(fnd_file.log,'After Calling Create_Hierarchy_Section for immediate section ');

Line 4865: IBE_UTIL.debug('Calling Reference_Section_Content ,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id);

4861: -----------------------------------------------------------------
4862: --------- Reference content for the copied section
4863: -----------------------------------------------------------------
4864: IF (l_debug = 'Y') THEN
4865: IBE_UTIL.debug('Calling Reference_Section_Content ,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id);
4866:
4867:
4868: END IF;
4869: IF (G_ENABLE_TRACE= 'Y') THEN

Line 4892: IBE_UTIL.debug('Calling Put_Section_Map ,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id);

4888: end if;
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4890: END IF;
4891: IF (l_debug = 'Y') THEN
4892: IBE_UTIL.debug('Calling Put_Section_Map ,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id);
4893:
4894:
4895: END IF;
4896: IF (G_ENABLE_TRACE= 'Y') THEN

Line 4932: IBE_UTIL.debug('Calling Copy_Layout_Comp_Mapping ,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id);

4928:
4929: -- 11.5.10, Copy layout component mapping during section duplication
4930: -- including center display template
4931: IF (l_debug = 'Y') THEN
4932: IBE_UTIL.debug('Calling Copy_Layout_Comp_Mapping ,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id);
4933:
4934:
4935: END IF;
4936: IF (G_ENABLE_TRACE= 'Y') THEN

Line 5019: IBE_UTIL.debug('Calling Create_Hierarchy_Section for immediate section ');

5015: FND_MSG_PUB.Add;
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: END IF;
5018: IF (l_debug = 'Y') THEN
5019: IBE_UTIL.debug('Calling Create_Hierarchy_Section for immediate section ');
5020: IBE_UTIL.debug('section id:'||l_parent_section_id);
5021:
5022: END IF;
5023: IF (G_ENABLE_TRACE= 'Y') THEN

Line 5020: IBE_UTIL.debug('section id:'||l_parent_section_id);

5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: END IF;
5018: IF (l_debug = 'Y') THEN
5019: IBE_UTIL.debug('Calling Create_Hierarchy_Section for immediate section ');
5020: IBE_UTIL.debug('section id:'||l_parent_section_id);
5021:
5022: END IF;
5023: IF (G_ENABLE_TRACE= 'Y') THEN
5024: fnd_file.put_line(fnd_file.log,'Calling Create_Hierarchy_Section for immediate section ');

Line 5075: IBE_UTIL.debug('After Calling Create_Hierarchy_Section for immediate section ');

5071: x_msg_data => x_msg_data
5072: );
5073: END IF;
5074: IF (l_debug = 'Y') THEN
5075: IBE_UTIL.debug('After Calling Create_Hierarchy_Section for immediate section ');
5076: IBE_UTIL.debug('new section id:'||l_section_id);
5077:
5078: END IF;
5079: IF (G_ENABLE_TRACE= 'Y') THEN

Line 5076: IBE_UTIL.debug('new section id:'||l_section_id);

5072: );
5073: END IF;
5074: IF (l_debug = 'Y') THEN
5075: IBE_UTIL.debug('After Calling Create_Hierarchy_Section for immediate section ');
5076: IBE_UTIL.debug('new section id:'||l_section_id);
5077:
5078: END IF;
5079: IF (G_ENABLE_TRACE= 'Y') THEN
5080: fnd_file.put_line(fnd_file.log,'After Calling Create_Hierarchy_Section for immediate section ');

Line 5125: IBE_UTIL.debug('Calling Reference_Section_Content ,copying from p_src_section :'||r2.section_id ||'to x_new_section_id:'||l_section_id);

5121: ------------------------------------- ---------------------------------------------
5122: --------------------------Reference content for the copied descendent sections
5123: --------------------------------------------------------------------------------------
5124: IF (l_debug = 'Y') THEN
5125: IBE_UTIL.debug('Calling Reference_Section_Content ,copying from p_src_section :'||r2.section_id ||'to x_new_section_id:'||l_section_id);
5126:
5127:
5128: END IF;
5129: IF (G_ENABLE_TRACE= 'Y') THEN

Line 5182: IBE_UTIL.debug('Calling Copy_Layout_Comp_Mapping ,copying from p_src_section :'||r2.section_id ||'to x_new_section_id:'||l_section_id);

5178:
5179: -- 11.5.10, Copy layout component mapping during section duplication
5180: -- including center display template
5181: IF (l_debug = 'Y') THEN
5182: IBE_UTIL.debug('Calling Copy_Layout_Comp_Mapping ,copying from p_src_section :'||r2.section_id ||'to x_new_section_id:'||l_section_id);
5183:
5184:
5185: END IF;
5186: IF (G_ENABLE_TRACE= 'Y') THEN

Line 5274: IBE_UTIL.debug(' Calling Associate_Items_To_Section to copy section items to section :'||l_section_id);

5270: l_end_date_actives(1) := r3.end_date_active;
5271: l_sort_orders(1) := r3.sort_order;
5272: l_association_reason_codes(1) := r3.association_reason_code;
5273: IF (l_debug = 'Y') THEN
5274: IBE_UTIL.debug(' Calling Associate_Items_To_Section to copy section items to section :'||l_section_id);
5275:
5276: END IF;
5277: IF (G_ENABLE_TRACE= 'Y') THEN
5278: fnd_file.put_line(fnd_file.log,' Calling Associate_Items_To_Section to copy section items to section :'||l_section_id);

Line 5337: IBE_UTIL.debug(' Calling Delete_Hierarchy_Section to delete sections if exception happens'||x_new_src_section_id );

5333: -- commenting the Rollback as we already commit for each duplicated section
5334: WHEN FND_API.G_EXC_ERROR THEN
5335: -- ROLLBACK TO COPY_SECTION_REF_CONTENT_PVT;
5336: IF (l_debug = 'Y') THEN
5337: IBE_UTIL.debug(' Calling Delete_Hierarchy_Section to delete sections if exception happens'||x_new_src_section_id );
5338:
5339: END IF;
5340: IF (G_ENABLE_TRACE= 'Y') THEN
5341: fnd_file.put_line(fnd_file.log,' Calling Delete_Hierarchy_Section to delete sections if exception happens '||x_new_src_section_id);

Line 5364: IBE_UTIL.debug(' Calling Delete_Hierarchy_Section when G_EXC_UNEXPECTED_ERROR'||x_new_src_section_id);

5360:
5361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5362: -- ROLLBACK TO COPY_SECTION_REF_CONTENT_PVT;
5363: IF (l_debug = 'Y') THEN
5364: IBE_UTIL.debug(' Calling Delete_Hierarchy_Section when G_EXC_UNEXPECTED_ERROR'||x_new_src_section_id);
5365:
5366: END IF;
5367: IF (G_ENABLE_TRACE= 'Y') THEN
5368: fnd_file.put_line(fnd_file.log,' Calling Delete_Hierarchy_Section when G_EXC_UNEXPECTED_ERROR '||x_new_src_section_id);

Line 5390: IBE_UTIL.debug(' Calling Delete_Hierarchy_Section when Other exception happens'||x_new_src_section_id);

5386: p_encoded => 'F');
5387:
5388: WHEN OTHERS THEN
5389: IF (l_debug = 'Y') THEN
5390: IBE_UTIL.debug(' Calling Delete_Hierarchy_Section when Other exception happens'||x_new_src_section_id);
5391:
5392: END IF;
5393: IF (G_ENABLE_TRACE= 'Y') THEN
5394: fnd_file.put_line(fnd_file.log,' Calling Delete_Hierarchy_Section when Other exception happens '||x_new_src_section_id);

Line 5924: IBE_UTIL.debug('Calling Get_Sect_Layout_Type');

5920: x_return_status := FND_API.g_ret_sts_success;
5921:
5922: l_idx := x_section_ids.COUNT;
5923: IF (l_debug = 'Y') THEN
5924: IBE_UTIL.debug('Calling Get_Sect_Layout_Type');
5925: IBE_UTIL.debug('section id:'||p_source_section_id);
5926:
5927: END IF;
5928:

Line 5925: IBE_UTIL.debug('section id:'||p_source_section_id);

5921:
5922: l_idx := x_section_ids.COUNT;
5923: IF (l_debug = 'Y') THEN
5924: IBE_UTIL.debug('Calling Get_Sect_Layout_Type');
5925: IBE_UTIL.debug('section id:'||p_source_section_id);
5926:
5927: END IF;
5928:
5929: IF (G_ENABLE_TRACE= 'Y') THEN

Line 5938: IBE_UTIL.debug('After Calling Get_Sect_Layout_Type');

5934: Get_Sect_Layout_Type(p_section_id => p_source_section_id,
5935: x_deliverable_id => l_source_deliverable_id,
5936: x_layout_type => l_source_layout_type);
5937: IF (l_debug = 'Y') THEN
5938: IBE_UTIL.debug('After Calling Get_Sect_Layout_Type');
5939: IBE_UTIL.debug('layout type:'||l_source_layout_type);
5940:
5941: END IF;
5942: IF (G_ENABLE_TRACE= 'Y') THEN

Line 5939: IBE_UTIL.debug('layout type:'||l_source_layout_type);

5935: x_deliverable_id => l_source_deliverable_id,
5936: x_layout_type => l_source_layout_type);
5937: IF (l_debug = 'Y') THEN
5938: IBE_UTIL.debug('After Calling Get_Sect_Layout_Type');
5939: IBE_UTIL.debug('layout type:'||l_source_layout_type);
5940:
5941: END IF;
5942: IF (G_ENABLE_TRACE= 'Y') THEN
5943: fnd_file.put_line(fnd_file.log,'After Calling Get_Sect_Layout_Type ');

Line 5950: IBE_UTIL.debug('Delete from ibe_dsp_obj_lgl_cnt_obj for section'||p_target_section_id);

5946: END IF;
5947:
5948: IF (l_source_layout_type = 'C') THEN
5949: IF (l_debug = 'Y') THEN
5950: IBE_UTIL.debug('Delete from ibe_dsp_obj_lgl_cnt_obj for section'||p_target_section_id);
5951: END IF;
5952: IF (G_ENABLE_TRACE= 'Y') THEN
5953: fnd_file.put_line(fnd_file.log,'Delete from ibe_dsp_obj_lgl_cnt_obj for section '||p_target_section_id);
5954: END IF;

Line 5986: IBE_UTIL.debug('Layout component mapping for section'||p_target_section_id);

5982: -- Component mapping except old processing and center display template
5983: FOR mapping IN c_get_component_mapping(p_source_section_id) LOOP
5984:
5985: IF (l_debug = 'Y') THEN
5986: IBE_UTIL.debug('Layout component mapping for section'||p_target_section_id);
5987: END IF;
5988: IF (G_ENABLE_TRACE= 'Y') THEN
5989: fnd_file.put_line(fnd_file.log,'Layout component mapping for section '||p_target_section_id);
5990: END IF;

Line 6132: IBE_UTIL.debug('Calling Update_Hierarchy_Layout_Map');

6128: --- Initialize API return status to success
6129: x_return_status := FND_API.g_ret_sts_success;
6130: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
6131: IF (l_debug = 'Y') THEN
6132: IBE_UTIL.debug('Calling Update_Hierarchy_Layout_Map');
6133: IBE_UTIL.debug('section id:'||p_section_id);
6134: IBE_UTIL.debug('layout id:'||p_layout_id);
6135: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6136: IBE_UTIL.debug('layout component id '||l_i||':'||p_layout_comp_id(l_i));

Line 6133: IBE_UTIL.debug('section id:'||p_section_id);

6129: x_return_status := FND_API.g_ret_sts_success;
6130: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
6131: IF (l_debug = 'Y') THEN
6132: IBE_UTIL.debug('Calling Update_Hierarchy_Layout_Map');
6133: IBE_UTIL.debug('section id:'||p_section_id);
6134: IBE_UTIL.debug('layout id:'||p_layout_id);
6135: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6136: IBE_UTIL.debug('layout component id '||l_i||':'||p_layout_comp_id(l_i));
6137: END LOOP;

Line 6134: IBE_UTIL.debug('layout id:'||p_layout_id);

6130: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
6131: IF (l_debug = 'Y') THEN
6132: IBE_UTIL.debug('Calling Update_Hierarchy_Layout_Map');
6133: IBE_UTIL.debug('section id:'||p_section_id);
6134: IBE_UTIL.debug('layout id:'||p_layout_id);
6135: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6136: IBE_UTIL.debug('layout component id '||l_i||':'||p_layout_comp_id(l_i));
6137: END LOOP;
6138: FOR l_i IN 1..p_layout_temp_id.COUNT LOOP

Line 6136: IBE_UTIL.debug('layout component id '||l_i||':'||p_layout_comp_id(l_i));

6132: IBE_UTIL.debug('Calling Update_Hierarchy_Layout_Map');
6133: IBE_UTIL.debug('section id:'||p_section_id);
6134: IBE_UTIL.debug('layout id:'||p_layout_id);
6135: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6136: IBE_UTIL.debug('layout component id '||l_i||':'||p_layout_comp_id(l_i));
6137: END LOOP;
6138: FOR l_i IN 1..p_layout_temp_id.COUNT LOOP
6139: IBE_UTIL.debug('layout template id '||l_i||':'||p_layout_temp_id(l_i));
6140: END LOOP;

Line 6139: IBE_UTIL.debug('layout template id '||l_i||':'||p_layout_temp_id(l_i));

6135: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6136: IBE_UTIL.debug('layout component id '||l_i||':'||p_layout_comp_id(l_i));
6137: END LOOP;
6138: FOR l_i IN 1..p_layout_temp_id.COUNT LOOP
6139: IBE_UTIL.debug('layout template id '||l_i||':'||p_layout_temp_id(l_i));
6140: END LOOP;
6141: FOR l_i IN 1..p_object_versions.COUNT LOOP
6142: IBE_UTIL.debug('object version id '||l_i||':'||p_object_versions(l_i));
6143: END LOOP;

Line 6142: IBE_UTIL.debug('object version id '||l_i||':'||p_object_versions(l_i));

6138: FOR l_i IN 1..p_layout_temp_id.COUNT LOOP
6139: IBE_UTIL.debug('layout template id '||l_i||':'||p_layout_temp_id(l_i));
6140: END LOOP;
6141: FOR l_i IN 1..p_object_versions.COUNT LOOP
6142: IBE_UTIL.debug('object version id '||l_i||':'||p_object_versions(l_i));
6143: END LOOP;
6144: FOR l_i IN 1..p_actionflags.COUNT LOOP
6145: IBE_UTIL.debug('action flags '||l_i||':'||p_actionflags(l_i));
6146: END LOOP;

Line 6145: IBE_UTIL.debug('action flags '||l_i||':'||p_actionflags(l_i));

6141: FOR l_i IN 1..p_object_versions.COUNT LOOP
6142: IBE_UTIL.debug('object version id '||l_i||':'||p_object_versions(l_i));
6143: END LOOP;
6144: FOR l_i IN 1..p_actionflags.COUNT LOOP
6145: IBE_UTIL.debug('action flags '||l_i||':'||p_actionflags(l_i));
6146: END LOOP;
6147: IBE_UTIL.debug('cascading flag:'||p_cascading_flag);
6148: END IF;
6149:

Line 6147: IBE_UTIL.debug('cascading flag:'||p_cascading_flag);

6143: END LOOP;
6144: FOR l_i IN 1..p_actionflags.COUNT LOOP
6145: IBE_UTIL.debug('action flags '||l_i||':'||p_actionflags(l_i));
6146: END LOOP;
6147: IBE_UTIL.debug('cascading flag:'||p_cascading_flag);
6148: END IF;
6149:
6150: -- Get the original layout of the section
6151: Get_Sect_Layout_Type(p_section_id => p_section_id,

Line 6155: IBE_UTIL.debug('org deliverable id:'||l_org_deliverable_id);

6151: Get_Sect_Layout_Type(p_section_id => p_section_id,
6152: x_deliverable_id => l_org_deliverable_id,
6153: x_layout_type => l_org_layout_type);
6154: IF (l_debug = 'Y') THEN
6155: IBE_UTIL.debug('org deliverable id:'||l_org_deliverable_id);
6156: IBE_UTIL.debug('org layout type:'||l_org_layout_type);
6157: END IF;
6158: l_new_layout_type
6159: := Get_Layout_Type(p_deliverable_id => p_layout_id);

Line 6156: IBE_UTIL.debug('org layout type:'||l_org_layout_type);

6152: x_deliverable_id => l_org_deliverable_id,
6153: x_layout_type => l_org_layout_type);
6154: IF (l_debug = 'Y') THEN
6155: IBE_UTIL.debug('org deliverable id:'||l_org_deliverable_id);
6156: IBE_UTIL.debug('org layout type:'||l_org_layout_type);
6157: END IF;
6158: l_new_layout_type
6159: := Get_Layout_Type(p_deliverable_id => p_layout_id);
6160: IF (p_layout_id = -1) THEN

Line 6166: IBE_UTIL.debug('new deliverable id:'||l_new_deliverable_id);

6162: ELSE
6163: l_new_deliverable_id := p_layout_id;
6164: END IF;
6165: IF (l_debug = 'Y') THEN
6166: IBE_UTIL.debug('new deliverable id:'||l_new_deliverable_id);
6167: IBE_UTIL.debug('new layout type:'||l_new_layout_type);
6168: END IF;
6169: x_section_ids := JTF_NUMBER_TABLE();
6170: x_layout_comp_ids := JTF_NUMBER_TABLE();

Line 6167: IBE_UTIL.debug('new layout type:'||l_new_layout_type);

6163: l_new_deliverable_id := p_layout_id;
6164: END IF;
6165: IF (l_debug = 'Y') THEN
6166: IBE_UTIL.debug('new deliverable id:'||l_new_deliverable_id);
6167: IBE_UTIL.debug('new layout type:'||l_new_layout_type);
6168: END IF;
6169: x_section_ids := JTF_NUMBER_TABLE();
6170: x_layout_comp_ids := JTF_NUMBER_TABLE();
6171: -- dbms_output.put_line('layout type:'||l_new_layout_type);

Line 6175: IBE_UTIL.debug('Updating section deliverable id');

6171: -- dbms_output.put_line('layout type:'||l_new_layout_type);
6172: -- New layout is associated with section
6173: IF (l_new_layout_type = 'C') THEN
6174: IF (l_debug = 'Y') THEN
6175: IBE_UTIL.debug('Updating section deliverable id');
6176: END IF;
6177: -- x_section_ids := JTF_NUMBER_TABLE();
6178: -- x_layout_comp_ids := JTF_NUMBER_TABLE();
6179: -- dbms_output.put_line('Before updating ibe_dsp_sections_b');

Line 6191: IBE_UTIL.debug('p_actionflags '||l_i||':'||p_actionflags(l_i));

6187: -------------------------------------
6188: -------------------------------------
6189: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6190: IF (l_debug = 'Y') THEN
6191: IBE_UTIL.debug('p_actionflags '||l_i||':'||p_actionflags(l_i));
6192: IBE_UTIL.debug('p_layout_comp_id '||l_i||':'||p_layout_comp_id(l_i));
6193: IBE_UTIL.debug('p_layout_temp_id '||l_i||':'||p_layout_temp_id(l_i));
6194: END IF;
6195: IF (p_actionflags(l_i) = 'D') THEN

Line 6192: IBE_UTIL.debug('p_layout_comp_id '||l_i||':'||p_layout_comp_id(l_i));

6188: -------------------------------------
6189: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6190: IF (l_debug = 'Y') THEN
6191: IBE_UTIL.debug('p_actionflags '||l_i||':'||p_actionflags(l_i));
6192: IBE_UTIL.debug('p_layout_comp_id '||l_i||':'||p_layout_comp_id(l_i));
6193: IBE_UTIL.debug('p_layout_temp_id '||l_i||':'||p_layout_temp_id(l_i));
6194: END IF;
6195: IF (p_actionflags(l_i) = 'D') THEN
6196: x_section_ids.extend(1);

Line 6193: IBE_UTIL.debug('p_layout_temp_id '||l_i||':'||p_layout_temp_id(l_i));

6189: FOR l_i IN 1..p_layout_comp_id.COUNT LOOP
6190: IF (l_debug = 'Y') THEN
6191: IBE_UTIL.debug('p_actionflags '||l_i||':'||p_actionflags(l_i));
6192: IBE_UTIL.debug('p_layout_comp_id '||l_i||':'||p_layout_comp_id(l_i));
6193: IBE_UTIL.debug('p_layout_temp_id '||l_i||':'||p_layout_temp_id(l_i));
6194: END IF;
6195: IF (p_actionflags(l_i) = 'D') THEN
6196: x_section_ids.extend(1);
6197: x_layout_comp_ids.extend(1);

Line 6244: IBE_UTIL.debug('after updating base section layout and mapping');

6240: END IF;
6241: END LOOP;
6242: -- Commit the change to the database
6243: IF (l_debug = 'Y') THEN
6244: IBE_UTIL.debug('after updating base section layout and mapping');
6245: END IF;
6246: ---------------------------------------
6247: IF (p_cascading_flag = 1) AND (l_new_layout_type = 'C') THEN
6248: IF (l_debug = 'Y') THEN

Line 6249: IBE_UTIL.debug('start cascading the layout mapping');

6245: END IF;
6246: ---------------------------------------
6247: IF (p_cascading_flag = 1) AND (l_new_layout_type = 'C') THEN
6248: IF (l_debug = 'Y') THEN
6249: IBE_UTIL.debug('start cascading the layout mapping');
6250: END IF;
6251: Get_Master_Mini_Site_Id(x_mini_site_id => l_master_minisite_id,
6252: x_root_section_id => l_root_section_id);
6253: FOR child_section IN c_get_child_section(p_section_id,

Line 6292: IBE_UTIL.debug('After Calling Update_Hierarchy_Layout_Map');

6288: WHERE section_id = p_section_id;
6289: END IF;
6290: END IF;
6291: IF (l_debug = 'Y') THEN
6292: IBE_UTIL.debug('After Calling Update_Hierarchy_Layout_Map');
6293: END IF;
6294: --
6295: -- End of main API body.
6296: -- Standard check of p_commit.

Line 6395: IBE_UTIL.debug('Calling Update_Section_Dlv_Ctx starts');

6391: --- Initialize API return status to success
6392: x_return_status := FND_API.g_ret_sts_success;
6393: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
6394: IF (l_debug = 'Y') THEN
6395: IBE_UTIL.debug('Calling Update_Section_Dlv_Ctx starts');
6396: IBE_UTIL.debug('Parameters:');
6397: IBE_UTIL.debug('section id:'||p_section_id);
6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);
6399: IBE_UTIL.debug('display context id:'||p_display_context_id);

Line 6396: IBE_UTIL.debug('Parameters:');

6392: x_return_status := FND_API.g_ret_sts_success;
6393: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
6394: IF (l_debug = 'Y') THEN
6395: IBE_UTIL.debug('Calling Update_Section_Dlv_Ctx starts');
6396: IBE_UTIL.debug('Parameters:');
6397: IBE_UTIL.debug('section id:'||p_section_id);
6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);
6399: IBE_UTIL.debug('display context id:'||p_display_context_id);
6400: IBE_UTIL.debug('object version number:'|| p_object_version_number);

Line 6397: IBE_UTIL.debug('section id:'||p_section_id);

6393: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
6394: IF (l_debug = 'Y') THEN
6395: IBE_UTIL.debug('Calling Update_Section_Dlv_Ctx starts');
6396: IBE_UTIL.debug('Parameters:');
6397: IBE_UTIL.debug('section id:'||p_section_id);
6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);
6399: IBE_UTIL.debug('display context id:'||p_display_context_id);
6400: IBE_UTIL.debug('object version number:'|| p_object_version_number);
6401: IBE_UTIL.debug('save ds:'|| p_saveds_flag);

Line 6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);

6394: IF (l_debug = 'Y') THEN
6395: IBE_UTIL.debug('Calling Update_Section_Dlv_Ctx starts');
6396: IBE_UTIL.debug('Parameters:');
6397: IBE_UTIL.debug('section id:'||p_section_id);
6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);
6399: IBE_UTIL.debug('display context id:'||p_display_context_id);
6400: IBE_UTIL.debug('object version number:'|| p_object_version_number);
6401: IBE_UTIL.debug('save ds:'|| p_saveds_flag);
6402: END IF;

Line 6399: IBE_UTIL.debug('display context id:'||p_display_context_id);

6395: IBE_UTIL.debug('Calling Update_Section_Dlv_Ctx starts');
6396: IBE_UTIL.debug('Parameters:');
6397: IBE_UTIL.debug('section id:'||p_section_id);
6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);
6399: IBE_UTIL.debug('display context id:'||p_display_context_id);
6400: IBE_UTIL.debug('object version number:'|| p_object_version_number);
6401: IBE_UTIL.debug('save ds:'|| p_saveds_flag);
6402: END IF;
6403: -- Get the original layout of the section

Line 6400: IBE_UTIL.debug('object version number:'|| p_object_version_number);

6396: IBE_UTIL.debug('Parameters:');
6397: IBE_UTIL.debug('section id:'||p_section_id);
6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);
6399: IBE_UTIL.debug('display context id:'||p_display_context_id);
6400: IBE_UTIL.debug('object version number:'|| p_object_version_number);
6401: IBE_UTIL.debug('save ds:'|| p_saveds_flag);
6402: END IF;
6403: -- Get the original layout of the section
6404: Get_Sect_Layout_Type(p_section_id => p_section_id,

Line 6401: IBE_UTIL.debug('save ds:'|| p_saveds_flag);

6397: IBE_UTIL.debug('section id:'||p_section_id);
6398: IBE_UTIL.debug('deliverable id:'||p_deliverable_id);
6399: IBE_UTIL.debug('display context id:'||p_display_context_id);
6400: IBE_UTIL.debug('object version number:'|| p_object_version_number);
6401: IBE_UTIL.debug('save ds:'|| p_saveds_flag);
6402: END IF;
6403: -- Get the original layout of the section
6404: Get_Sect_Layout_Type(p_section_id => p_section_id,
6405: x_deliverable_id => l_org_deliverable_id,

Line 6408: IBE_UTIL.debug('after calling Get_Sect_Layout_Type');

6404: Get_Sect_Layout_Type(p_section_id => p_section_id,
6405: x_deliverable_id => l_org_deliverable_id,
6406: x_layout_type => l_org_layout_type);
6407: IF (l_debug = 'Y') THEN
6408: IBE_UTIL.debug('after calling Get_Sect_Layout_Type');
6409: IBE_UTIL.debug('deliverable id:'||l_org_deliverable_id);
6410: IBE_UTIL.debug('layout type:'||l_org_layout_type);
6411: END IF;
6412: l_deliverable_id := p_deliverable_id;

Line 6409: IBE_UTIL.debug('deliverable id:'||l_org_deliverable_id);

6405: x_deliverable_id => l_org_deliverable_id,
6406: x_layout_type => l_org_layout_type);
6407: IF (l_debug = 'Y') THEN
6408: IBE_UTIL.debug('after calling Get_Sect_Layout_Type');
6409: IBE_UTIL.debug('deliverable id:'||l_org_deliverable_id);
6410: IBE_UTIL.debug('layout type:'||l_org_layout_type);
6411: END IF;
6412: l_deliverable_id := p_deliverable_id;
6413: IF (l_deliverable_id = -1) THEN

Line 6410: IBE_UTIL.debug('layout type:'||l_org_layout_type);

6406: x_layout_type => l_org_layout_type);
6407: IF (l_debug = 'Y') THEN
6408: IBE_UTIL.debug('after calling Get_Sect_Layout_Type');
6409: IBE_UTIL.debug('deliverable id:'||l_org_deliverable_id);
6410: IBE_UTIL.debug('layout type:'||l_org_layout_type);
6411: END IF;
6412: l_deliverable_id := p_deliverable_id;
6413: IF (l_deliverable_id = -1) THEN
6414: l_deliverable_id := NULL;

Line 6424: IBE_UTIL.debug('Before calling IBE_DSP_SECTION_GRP.Update_Section');

6420: IF (p_display_context_id = -1) THEN
6421: l_display_context_id := NULL;
6422: END IF;
6423: IF (l_debug = 'Y') THEN
6424: IBE_UTIL.debug('Before calling IBE_DSP_SECTION_GRP.Update_Section');
6425: END IF;
6426: IBE_DSP_SECTION_GRP.Update_Section
6427: ( p_api_version => 1.0,
6428: p_init_msg_list => FND_API.G_FALSE,

Line 6474: IBE_UTIL.debug('section id:'||l_lgl_ctnt_rec.Object_id);

6470: l_lgl_ctnt_rec.deliverable_id := l_deliverable_id;
6471: l_lgl_ctnt_rec.obj_lgl_ctnt_delete := FND_API.G_FALSE;
6472: l_lgl_ctnt_tbl(1) := l_lgl_ctnt_rec;
6473: IF (l_debug = 'Y') THEN
6474: IBE_UTIL.debug('section id:'||l_lgl_ctnt_rec.Object_id);
6475: END IF;
6476: IBE_LogicalContent_GRP.save_delete_lgl_ctnt(
6477: p_api_version => 1.0,
6478: x_return_status => x_return_status,

Line 6508: IBE_UTIL.debug(l_msg_data);

6504: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
6505: IF (l_debug = 'Y') THEN
6506: FOR i in 1..l_msg_count loop
6507: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
6508: IBE_UTIL.debug(l_msg_data);
6509: END LOOP;
6510: END IF;
6511: RAISE FND_API.G_EXC_ERROR;
6512: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6516: IBE_UTIL.debug(l_msg_data);

6512: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6513: IF (l_debug = 'Y') THEN
6514: FOR i in 1..l_msg_count loop
6515: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
6516: IBE_UTIL.debug(l_msg_data);
6517: END LOOP;
6518: END IF;
6519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6520: END IF;

Line 6611: IBE_UTIL.debug('start of Associate_Items_To_Section');

6607: END IF;
6608: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
6609:
6610: IF (l_debug = 'Y') THEN
6611: IBE_UTIL.debug('start of Associate_Items_To_Section');
6612: END If;
6613: -- Initialize API return status to success
6614: x_return_status := FND_API.G_RET_STS_SUCCESS;
6615: l_duplicate_association_status := FND_API.G_RET_STS_SUCCESS;

Line 6646: IBE_UTIL.debug('Parameters:l_counter='||l_counter||'inventory_item_id='||l_inventory_item_id_tbl(1)||

6642: l_end_date_active_tbl(1):=p_section_item_tbl(l_counter).end_date_active;
6643: l_sort_order_tbl(1):=p_section_item_tbl(l_counter).sort_order;
6644: l_association_reason_code_tbl(1):=p_section_item_tbl(l_counter).association_reason_code;
6645: IF (l_debug = 'Y') THEN
6646: IBE_UTIL.debug('Parameters:l_counter='||l_counter||'inventory_item_id='||l_inventory_item_id_tbl(1)||
6647: 'organization_id='||l_organization_id_tbl(1)||'start_date_active='||l_start_date_active_tbl(1)||
6648: 'end_date_active='||l_end_date_active_tbl(1)||'sort_order='||l_sort_order_tbl(1)||
6649: 'association_reason_code='||l_association_reason_code_tbl(1));
6650: END IF;

Line 6676: IBE_UTIL.debug('Internal API return_status='||x_return_status);

6672: x_section_item_out_tbl(l_counter).section_item_id :=l_section_item_id_tbl(1);
6673: x_section_item_out_tbl(l_counter).inventory_item_id :=l_inventory_item_id_tbl(1);
6674: x_section_item_out_tbl(l_counter).organization_id :=l_organization_id_tbl(1);
6675: if(l_debug='Y') then
6676: IBE_UTIL.debug('Internal API return_status='||x_return_status);
6677: end if;
6678: -- derive the API overall status
6679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)then
6680: IF (l_overall_return_status=FND_API.G_RET_STS_SUCCESS) then

Line 6685: IBE_UTIL.debug(FND_MSG_PUB.get(i,FND_API.G_FALSE));

6681: l_overall_return_status:= FND_API.G_RET_STS_ERROR;
6682: END IF;
6683: IF (l_debug = 'Y') THEN
6684: FOR i in 1..x_msg_count loop
6685: IBE_UTIL.debug(FND_MSG_PUB.get(i,FND_API.G_FALSE));
6686: END LOOP;
6687: END IF;
6688: END IF;
6689:

Line 6693: IBE_UTIL.debug('API overall status='||l_overall_return_status);

6689:
6690: END LOOP;
6691:
6692: if(l_debug='Y') then
6693: IBE_UTIL.debug('API overall status='||l_overall_return_status);
6694: end if;
6695: -- set the x_return status to the API overall status
6696: x_return_status:= l_overall_return_status;
6697: -- End of main API body.