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 FND_FILE

Line 4478: fnd_file.put_line(fnd_file.log,'Calling copy_section_ref_content ');

4474: if p_enable_trace = 'Y' then
4475: G_ENABLE_TRACE := 'Y';
4476: end if;
4477: IF G_ENABLE_TRACE = 'Y' then
4478: fnd_file.put_line(fnd_file.log,'Calling copy_section_ref_content ');
4479: fnd_file.put_line(fnd_file.log,'section id:'||p_source_section_id);
4480: fnd_file.put_line(fnd_file.log,'dest section id:'||p_dest_parent_section_id);
4481: END IF;
4482:

Line 4479: fnd_file.put_line(fnd_file.log,'section id:'||p_source_section_id);

4475: G_ENABLE_TRACE := 'Y';
4476: end if;
4477: IF G_ENABLE_TRACE = 'Y' then
4478: fnd_file.put_line(fnd_file.log,'Calling copy_section_ref_content ');
4479: fnd_file.put_line(fnd_file.log,'section id:'||p_source_section_id);
4480: fnd_file.put_line(fnd_file.log,'dest section id:'||p_dest_parent_section_id);
4481: END IF;
4482:
4483: copy_section_ref_content (

Line 4480: fnd_file.put_line(fnd_file.log,'dest section id:'||p_dest_parent_section_id);

4476: end if;
4477: IF G_ENABLE_TRACE = 'Y' then
4478: fnd_file.put_line(fnd_file.log,'Calling copy_section_ref_content ');
4479: fnd_file.put_line(fnd_file.log,'section id:'||p_source_section_id);
4480: fnd_file.put_line(fnd_file.log,'dest section id:'||p_dest_parent_section_id);
4481: END IF;
4482:
4483: copy_section_ref_content (
4484: p_api_version =>1.0,

Line 4504: fnd_file.put_line(fnd_file.log,'After Calling copy_section_ref_content ');

4500: retcode := -1;
4501: errbuf := x_msg_data;
4502: end if;
4503: IF G_ENABLE_TRACE = 'Y' then
4504: fnd_file.put_line(fnd_file.log,'After Calling copy_section_ref_content ');
4505: fnd_file.put_line(fnd_file.log,'return Code:'||retcode);
4506: fnd_file.put_line(fnd_file.log,'Return Status:'||errbuf);
4507: END IF;
4508: END batch_duplicate_section;

Line 4505: fnd_file.put_line(fnd_file.log,'return Code:'||retcode);

4501: errbuf := x_msg_data;
4502: end if;
4503: IF G_ENABLE_TRACE = 'Y' then
4504: fnd_file.put_line(fnd_file.log,'After Calling copy_section_ref_content ');
4505: fnd_file.put_line(fnd_file.log,'return Code:'||retcode);
4506: fnd_file.put_line(fnd_file.log,'Return Status:'||errbuf);
4507: END IF;
4508: END batch_duplicate_section;
4509:

Line 4506: fnd_file.put_line(fnd_file.log,'Return Status:'||errbuf);

4502: end if;
4503: IF G_ENABLE_TRACE = 'Y' then
4504: fnd_file.put_line(fnd_file.log,'After Calling copy_section_ref_content ');
4505: fnd_file.put_line(fnd_file.log,'return Code:'||retcode);
4506: fnd_file.put_line(fnd_file.log,'Return Status:'||errbuf);
4507: END IF;
4508: END batch_duplicate_section;
4509:
4510:

Line 4664: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');

4660: (p_src_section_id <= 0) OR
4661: (p_src_section_id = FND_API.G_MISS_NUM))
4662: THEN
4663: if G_ENABLE_TRACE = 'Y' then
4664: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');
4665: else
4666: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_COPY_SRC_SCT');
4667: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4668: FND_MSG_PUB.Add;

Line 4681: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');

4677: THEN
4678:
4679:
4680: if G_ENABLE_TRACE = 'Y' then
4681: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');
4682: else
4683: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_COPY_DST_SCT');
4684: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4685: FND_MSG_PUB.Add;

Line 4716: fnd_file.put_line(fnd_file.log,'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:
4718: fnd_file.put_line(fnd_file.log,'parent section id:'||p_dst_parent_section_id);
4719: END IF;
4720:

Line 4718: fnd_file.put_line(fnd_file.log,'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:
4718: fnd_file.put_line(fnd_file.log,'parent section id:'||p_dst_parent_section_id);
4719: END IF;
4720:
4721: Create_Hierarchy_Section
4722: (

Line 4772: fnd_file.put_line(fnd_file.log,'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 ');
4773: fnd_file.put_line(fnd_file.log,'new section id:'||x_new_src_section_id);
4774:
4775: END IF;
4776: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 4773: fnd_file.put_line(fnd_file.log,'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 ');
4773: fnd_file.put_line(fnd_file.log,'new section id:'||x_new_src_section_id);
4774:
4775: END IF;
4776: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4777: if G_ENABLE_TRACE = 'Y' then

Line 4778: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Create_Hierarchy_Section');

4774:
4775: END IF;
4776: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4777: if G_ENABLE_TRACE = 'Y' then
4778: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Create_Hierarchy_Section');
4779:
4780: else
4781: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
4782: FND_MSG_PUB.Add;

Line 4788: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Create_Hierarchy_Section');

4784: end if;
4785: RAISE FND_API.G_EXC_ERROR;
4786: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4787: if G_ENABLE_TRACE = 'Y' then
4788: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Create_Hierarchy_Section');
4789: else
4790: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
4791: FND_MSG_PUB.Add;
4792:

Line 4870: fnd_file.put_line(fnd_file.log,'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
4870: fnd_file.put_line(fnd_file.log,'Calling Reference_Section_Content,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id );
4871:
4872: END IF;
4873: Reference_Section_Content(
4874: p_old_section_id =>p_src_section_id,

Line 4882: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Reference_Section_Content');

4878: x_msg_data =>x_msg_data);
4879:
4880: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4881: if G_ENABLE_TRACE = 'Y' then
4882: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Reference_Section_Content');
4883: end if;
4884: RAISE FND_API.G_EXC_ERROR;
4885: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4886: if G_ENABLE_TRACE = 'Y' then

Line 4887: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Reference_Section_Content');

4883: end if;
4884: RAISE FND_API.G_EXC_ERROR;
4885: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4886: if G_ENABLE_TRACE = 'Y' then
4887: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Reference_Section_Content');
4888: end if;
4889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4890: END IF;
4891: IF (l_debug = 'Y') THEN

Line 4897: fnd_file.put_line(fnd_file.log,'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
4897: fnd_file.put_line(fnd_file.log,'Calling Put_Section_Map,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id );
4898:
4899: END IF;
4900:
4901: Put_Section_Map

Line 4911: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');

4907: );
4908:
4909: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4910: if G_ENABLE_TRACE = 'Y' then
4911: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4912: end if;
4913: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4914: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4915: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);

Line 4920: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');

4916: FND_MSG_PUB.Add;
4917: RAISE FND_API.G_EXC_ERROR;
4918: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4919: if G_ENABLE_TRACE = 'Y' then
4920: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4921: end if;
4922: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4923: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4924: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);

Line 4937: fnd_file.put_line(fnd_file.log,'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
4937: fnd_file.put_line(fnd_file.log,'Calling Copy_Layout_Comp_Mapping,copying from p_src_section :'||p_src_section_id ||'to x_new_section_id:'||x_new_src_section_id );
4938:
4939: END IF;
4940: Copy_Layout_Comp_Mapping(
4941: p_api_version => 1.0,

Line 4952: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Copy_Layout_Comp_Mapping');

4948: x_msg_count => x_msg_count,
4949: x_msg_data => x_msg_data);
4950: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4951: if G_ENABLE_TRACE = 'Y' then
4952: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Copy_Layout_Comp_Mapping');
4953: end if;
4954: RAISE FND_API.G_EXC_ERROR;
4955: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4956: if G_ENABLE_TRACE = 'Y' then

Line 4957: fnd_file.put_line(fnd_file.log,'get RET_STS_UNEXP_ERROR in Copy_Layout_Comp_Mapping');

4953: end if;
4954: RAISE FND_API.G_EXC_ERROR;
4955: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4956: if G_ENABLE_TRACE = 'Y' then
4957: fnd_file.put_line(fnd_file.log,'get RET_STS_UNEXP_ERROR in Copy_Layout_Comp_Mapping');
4958: end if;
4959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4960: END IF;
4961:

Line 4970: fnd_file.put_line(fnd_file.log,'get G_IBE_DSP_COPY_SRC_SCT_NOT_FOUND error');

4966: END LOOP; -- end for r1 in c1
4967:
4968: IF (l_found = FALSE) THEN
4969: if G_ENABLE_TRACE = 'Y' then
4970: fnd_file.put_line(fnd_file.log,'get G_IBE_DSP_COPY_SRC_SCT_NOT_FOUND error');
4971: end if;
4972: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_COPY_SRC_SCT_NOT_FOUND');
4973: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4974: FND_MSG_PUB.Add;

Line 5001: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR error in Get_Section_Map for descendants of parent section ');

4997: );
4998:
4999: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5000: if G_ENABLE_TRACE = 'Y' then
5001: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR error in Get_Section_Map for descendants of parent section ');
5002: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5003: end if;
5004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5005: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);

Line 5002: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');

4998:
4999: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5000: if G_ENABLE_TRACE = 'Y' then
5001: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR error in Get_Section_Map for descendants of parent section ');
5002: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5003: end if;
5004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5005: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);
5006: FND_MSG_PUB.Add;

Line 5010: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR error in Get_Section_Map for descendants of parent section ');

5006: FND_MSG_PUB.Add;
5007: RAISE FND_API.G_EXC_ERROR;
5008: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5009: if G_ENABLE_TRACE = 'Y' then
5010: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR error in Get_Section_Map for descendants of parent section ');
5011: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5012: end if;
5013: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5014: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);

Line 5011: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');

5007: RAISE FND_API.G_EXC_ERROR;
5008: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5009: if G_ENABLE_TRACE = 'Y' then
5010: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR error in Get_Section_Map for descendants of parent section ');
5011: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5012: end if;
5013: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5014: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);
5015: FND_MSG_PUB.Add;

Line 5024: fnd_file.put_line(fnd_file.log,'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 ');
5025: fnd_file.put_line(fnd_file.log,'section id:'||l_parent_section_id);
5026:
5027: END IF;
5028: Create_Hierarchy_Section

Line 5025: fnd_file.put_line(fnd_file.log,'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 ');
5025: fnd_file.put_line(fnd_file.log,'section id:'||l_parent_section_id);
5026:
5027: END IF;
5028: Create_Hierarchy_Section
5029: (

Line 5080: fnd_file.put_line(fnd_file.log,'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 ');
5081: fnd_file.put_line(fnd_file.log,'new section id:'||l_section_id);
5082:
5083: END IF;
5084: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 5081: fnd_file.put_line(fnd_file.log,'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 ');
5081: fnd_file.put_line(fnd_file.log,'new section id:'||l_section_id);
5082:
5083: END IF;
5084: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5085: if G_ENABLE_TRACE = 'Y' then

Line 5086: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Create_Hierarchy_Section');

5082:
5083: END IF;
5084: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5085: if G_ENABLE_TRACE = 'Y' then
5086: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Create_Hierarchy_Section');
5087: end if;
5088: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
5089: FND_MSG_PUB.Add;
5090: RAISE FND_API.G_EXC_ERROR;

Line 5093: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Create_Hierarchy_Section');

5089: FND_MSG_PUB.Add;
5090: RAISE FND_API.G_EXC_ERROR;
5091: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5092: if G_ENABLE_TRACE = 'Y' then
5093: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Create_Hierarchy_Section');
5094: end if;
5095: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
5096: FND_MSG_PUB.Add;
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5130: fnd_file.put_line(fnd_file.log,'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
5130: fnd_file.put_line(fnd_file.log,'Calling Reference_Section_Content,copying from p_src_section :'||r2.section_id ||'to x_new_section_id:'||l_section_id );
5131:
5132: END IF;
5133: Reference_Section_Content(
5134: p_old_section_id =>r2.section_id,

Line 5142: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Reference_Section_Content');

5138: x_msg_data =>x_msg_data);
5139:
5140: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5141: if G_ENABLE_TRACE = 'Y' then
5142: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Reference_Section_Content');
5143: end if;
5144: RAISE FND_API.G_EXC_ERROR;
5145: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5146: if G_ENABLE_TRACE = 'Y' then

Line 5147: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Reference_Section_Content');

5143: end if;
5144: RAISE FND_API.G_EXC_ERROR;
5145: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5146: if G_ENABLE_TRACE = 'Y' then
5147: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Reference_Section_Content');
5148: end if;
5149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5150: END IF;
5151:

Line 5162: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');

5158: );
5159:
5160: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5161: if G_ENABLE_TRACE = 'Y' then
5162: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5163: end if;
5164: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5165: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5166: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);

Line 5171: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');

5167: FND_MSG_PUB.Add;
5168: RAISE FND_API.G_EXC_ERROR;
5169: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5170: if G_ENABLE_TRACE = 'Y' then
5171: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5172: end if;
5173: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5174: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5175: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);

Line 5187: fnd_file.put_line(fnd_file.log,'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
5187: fnd_file.put_line(fnd_file.log,'Calling Copy_Layout_Comp_Mapping,copying from p_src_section :'||r2.section_id ||'to x_new_section_id:'||l_section_id );
5188:
5189: END IF;
5190: Copy_Layout_Comp_Mapping(
5191: p_api_version => 1.0,

Line 5202: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Copy_Layout_Comp_Mapping');

5198: x_msg_count => x_msg_count,
5199: x_msg_data => x_msg_data);
5200: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5201: if G_ENABLE_TRACE = 'Y' then
5202: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Copy_Layout_Comp_Mapping');
5203: end if;
5204: RAISE FND_API.G_EXC_ERROR;
5205: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5206: if G_ENABLE_TRACE = 'Y' then

Line 5207: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Copy_Layout_Comp_Mapping');

5203: end if;
5204: RAISE FND_API.G_EXC_ERROR;
5205: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5206: if G_ENABLE_TRACE = 'Y' then
5207: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Copy_Layout_Comp_Mapping');
5208: end if;
5209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5210: END IF;
5211: /* An idea ahead of its time ...

Line 5278: fnd_file.put_line(fnd_file.log,' Calling Associate_Items_To_Section to copy section items to section :'||l_section_id);

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);
5279:
5280: END IF;
5281: Associate_Items_To_Section
5282: (

Line 5303: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Associate_Items_To_Section');

5299: );
5300:
5301: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5302: if G_ENABLE_TRACE = 'Y' then
5303: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Associate_Items_To_Section');
5304: end if;
5305: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_ITMS_TO_SCT_FAIL');
5306: FND_MSG_PUB.Add;
5307: RAISE FND_API.G_EXC_ERROR;

Line 5310: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Associate_Items_To_Section');

5306: FND_MSG_PUB.Add;
5307: RAISE FND_API.G_EXC_ERROR;
5308: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5309: if G_ENABLE_TRACE = 'Y' then
5310: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Associate_Items_To_Section');
5311: end if;
5312: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_ITMS_TO_SCT_FAIL');
5313: FND_MSG_PUB.Add;
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5341: fnd_file.put_line(fnd_file.log,' Calling Delete_Hierarchy_Section to delete sections if exception happens '||x_new_src_section_id);

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);
5342:
5343: END IF;
5344: Delete_Hierarchy_Section(p_api_version =>1.0,
5345: p_init_msg_list=> FND_API.G_FALSE,

Line 5368: fnd_file.put_line(fnd_file.log,' Calling Delete_Hierarchy_Section when G_EXC_UNEXPECTED_ERROR '||x_new_src_section_id);

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);
5369:
5370: END IF;
5371: Delete_Hierarchy_Section(p_api_version =>1.0,
5372: p_init_msg_list=> FND_API.G_FALSE,

Line 5394: fnd_file.put_line(fnd_file.log,' Calling Delete_Hierarchy_Section when Other exception happens '||x_new_src_section_id);

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);
5395:
5396: END IF;
5397: -- ROLLBACK TO COPY_SECTION_REF_CONTENT_PVT;
5398: Delete_Hierarchy_Section(p_api_version =>1.0,

Line 5840: fnd_file.put_line(fnd_file.log,'Calling Cascade_Layout_Comp_Mapping ');

5836: x_root_section_id => l_root_section_id);
5837:
5838: FOR child_section IN c_get_child_section(to_number(p_section_id),l_master_minisite_id) LOOP
5839: IF G_ENABLE_TRACE = 'Y' then
5840: fnd_file.put_line(fnd_file.log,'Calling Cascade_Layout_Comp_Mapping ');
5841: fnd_file.put_line(fnd_file.log,'section id:'||child_section.child_section_id);
5842: END IF;
5843: Cascade_Layout_Comp_Mapping
5844: (p_api_version => 1.0,

Line 5841: fnd_file.put_line(fnd_file.log,'section id:'||child_section.child_section_id);

5837:
5838: FOR child_section IN c_get_child_section(to_number(p_section_id),l_master_minisite_id) LOOP
5839: IF G_ENABLE_TRACE = 'Y' then
5840: fnd_file.put_line(fnd_file.log,'Calling Cascade_Layout_Comp_Mapping ');
5841: fnd_file.put_line(fnd_file.log,'section id:'||child_section.child_section_id);
5842: END IF;
5843: Cascade_Layout_Comp_Mapping
5844: (p_api_version => 1.0,
5845: p_init_msg_list => FND_API.G_FALSE,

Line 5930: fnd_file.put_line(fnd_file.log,'Calling Get_Sect_Layout_Type ');

5926:
5927: END IF;
5928:
5929: IF (G_ENABLE_TRACE= 'Y') THEN
5930: fnd_file.put_line(fnd_file.log,'Calling Get_Sect_Layout_Type ');
5931: fnd_file.put_line(fnd_file.log,'section id:'||p_source_section_id);
5932:
5933: END IF;
5934: Get_Sect_Layout_Type(p_section_id => p_source_section_id,

Line 5931: fnd_file.put_line(fnd_file.log,'section id:'||p_source_section_id);

5927: END IF;
5928:
5929: IF (G_ENABLE_TRACE= 'Y') THEN
5930: fnd_file.put_line(fnd_file.log,'Calling Get_Sect_Layout_Type ');
5931: fnd_file.put_line(fnd_file.log,'section id:'||p_source_section_id);
5932:
5933: END IF;
5934: Get_Sect_Layout_Type(p_section_id => p_source_section_id,
5935: x_deliverable_id => l_source_deliverable_id,

Line 5943: fnd_file.put_line(fnd_file.log,'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 ');
5944: fnd_file.put_line(fnd_file.log,'layout type:'||l_source_layout_type);
5945:
5946: END IF;
5947:

Line 5944: fnd_file.put_line(fnd_file.log,'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 ');
5944: fnd_file.put_line(fnd_file.log,'layout type:'||l_source_layout_type);
5945:
5946: END IF;
5947:
5948: IF (l_source_layout_type = 'C') THEN

Line 5953: fnd_file.put_line(fnd_file.log,'Delete from ibe_dsp_obj_lgl_cnt_obj for section '||p_target_section_id);

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;
5955: DELETE FROM ibe_dsp_obj_lgl_ctnt obj
5956: WHERE obj.object_id = p_target_section_id
5957: AND obj.object_type = 'S'

Line 5989: fnd_file.put_line(fnd_file.log,'Layout component mapping for section '||p_target_section_id);

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;
5991: UPDATE ibe_dsp_obj_lgl_ctnt
5992: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
5993: ITEM_ID = mapping.item_id,

Line 6032: fnd_file.put_line(fnd_file.log,'get G_EXC_ERROR in Cascade_Layout_Comp_Mapping');

6028: p_encoded => 'F');
6029: EXCEPTION
6030: WHEN FND_API.G_EXC_ERROR THEN
6031: if G_ENABLE_TRACE = 'Y' then
6032: fnd_file.put_line(fnd_file.log,'get G_EXC_ERROR in Cascade_Layout_Comp_Mapping');
6033: end if;
6034: ROLLBACK TO cascade_layout_comp_mapping;
6035: x_return_status := FND_API.G_RET_STS_ERROR;
6036: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 6041: fnd_file.put_line(fnd_file.log,'get G_EXC_UNEXPECTED_ERROR in Cascade_Layout_Comp_Mapping');

6037: p_data => x_msg_data,
6038: p_encoded => 'F');
6039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6040: if G_ENABLE_TRACE = 'Y' then
6041: fnd_file.put_line(fnd_file.log,'get G_EXC_UNEXPECTED_ERROR in Cascade_Layout_Comp_Mapping');
6042: end if;
6043: ROLLBACK TO cascade_layout_comp_mapping;
6044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6045: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 6050: fnd_file.put_line(fnd_file.log,'get OTHERS Exception in Cascade_Layout_Comp_Mapping');

6046: p_data => x_msg_data,
6047: p_encoded => 'F');
6048: WHEN OTHERS THEN
6049: if G_ENABLE_TRACE = 'Y' then
6050: fnd_file.put_line(fnd_file.log,'get OTHERS Exception in Cascade_Layout_Comp_Mapping');
6051: end if;
6052:
6053: ROLLBACK TO cascade_layout_comp_mapping;
6054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;