APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on FND_FILE

Line 3241: FND_FILE.PUT(p_file, Encode_Text(x_Buf));

3237: WHILE (chunkPos<= x_sourceLength) AND
3238: ((x_sourceLength-chunkPos) >= chunkSize)
3239: LOOP
3240: DBMS_LOB.READ(p_clob, chunkSize, chunkPos, x_Buf);
3241: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3242: chunkPos := chunkPos + chunkSize;
3243: END LOOP;
3244:
3245: -- read the rest of CLOB

Line 3249: FND_FILE.PUT(p_file, Encode_Text(x_Buf));

3245: -- read the rest of CLOB
3246: IF ((x_sourceLength-chunkPos) < chunkSize) THEN
3247: amt := x_sourceLength-chunkPos+1;
3248: DBMS_LOB.READ(p_clob, amt, chunkPos, x_Buf);
3249: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3250: END IF;
3251:
3252: END Write_Clob_To_File;
3253:

Line 3744: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || composite_cat_name);

3740:
3741: close c1;
3742:
3743: if(contains_gt) then
3744: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || composite_cat_name);
3745: end if;
3746:
3747: return composite_cat_name;
3748:

Line 4146: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);

4142: * Query OUT All the set_ids matching the criteria
4143: *
4144: *******************************************************/
4145:
4146: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4147: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4148:
4149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4147: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);

4143: *
4144: *******************************************************/
4145:
4146: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4147: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4148:
4149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4151:

Line 4149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4145:
4146: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4147: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4148:
4149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4151:
4152: IF (p_sol_status = 'ALL')
4153: THEN

Line 4150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4146: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4147: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4148:
4149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4150: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4151:
4152: IF (p_sol_status = 'ALL')
4153: THEN
4154: SELECT /*+ index(sc) */ count(a.set_number) INTO l_soln_count

Line 4175: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_ATTEMPT') || l_soln_count);

4171: and a.status = 'PUB';
4172: END IF;
4173:
4174: IF (l_soln_count > 0) THEN
4175: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_ATTEMPT') || l_soln_count);
4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4177: END IF;
4178:
4179: l_soln_index := 1;

Line 4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4172: END IF;
4173:
4174: IF (l_soln_count > 0) THEN
4175: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_ATTEMPT') || l_soln_count);
4176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4177: END IF;
4178:
4179: l_soln_index := 1;
4180: l_success_solns := 0;

Line 4235: -- when using FND_FILE, so through exception and do not process

4231: -- If l_Num = 0 Then NO new line characters were found in the chunk
4232: IF l_Num = 0 THEN
4233: -- Validate if this is the last chunk (and that the size < 32K)
4234: -- If this is NOT the last chunk then this will cause an error
4235: -- when using FND_FILE, so through exception and do not process
4236: -- this Solution.
4237: IF l_Start < (length(StmtCheck.stmt) - l_Limit ) THEN
4238: l_Error := 'Y';
4239: IF l_Stmts is null THEN

Line 4263: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET);

4259: FND_MESSAGE.SET_TOKEN(TOKEN => 'SOLN_NUMBER',
4260: VALUE => l_set_nos(l_soln_index) );
4261: FND_MESSAGE.SET_TOKEN(TOKEN => 'STMT_NUMBER',
4262: VALUE => l_stmts );
4263: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET);
4264:
4265: ELSIF l_error = 'N' THEN
4266:
4267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');

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

4263: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET);
4264:
4265: ELSIF l_error = 'N' THEN
4266:
4267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4268:
4269: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4270: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4269: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4265: ELSIF l_error = 'N' THEN
4266:
4267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4268:
4269: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4270: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4272:
4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

Line 4270: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));

4266:
4267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4268:
4269: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4270: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4272:
4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));

Line 4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4268:
4269: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4270: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4272:
4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4269: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4270: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4272:
4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4276:
4277: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

Line 4274: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));

4270: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4272:
4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4276:
4277: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4278: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));

Line 4275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4272:
4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4276:
4277: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4278: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));
4279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4277: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4273: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4276:
4277: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4278: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));
4279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4280:
4281: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

Line 4281: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4284:
4285: -- output all categories instead of just the one specified by parameter

Line 4282: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_set_names(l_soln_index)));

4278: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));
4279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4280:
4281: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4284:
4285: -- output all categories instead of just the one specified by parameter
4286: l_cat_index := 1;

Line 4283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4280:
4281: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4284:
4285: -- output all categories instead of just the one specified by parameter
4286: l_cat_index := 1;
4287: open get_category_ids(l_set_ids(l_soln_index));

Line 4294: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4290:
4291: fetch get_category_ids INTO l_cat_ids(l_cat_index);
4292: exit when get_category_ids%NOTFOUND;
4293:
4294: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4295: FND_FILE.PUT(FND_FILE.OUTPUT, encode_text(get_category_full_name(l_cat_ids(l_cat_index), l_delim, true)));
4296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4297:
4298: l_cat_index := l_cat_index + 1;

Line 4295: FND_FILE.PUT(FND_FILE.OUTPUT, encode_text(get_category_full_name(l_cat_ids(l_cat_index), l_delim, true)));

4291: fetch get_category_ids INTO l_cat_ids(l_cat_index);
4292: exit when get_category_ids%NOTFOUND;
4293:
4294: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4295: FND_FILE.PUT(FND_FILE.OUTPUT, encode_text(get_category_full_name(l_cat_ids(l_cat_index), l_delim, true)));
4296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4297:
4298: l_cat_index := l_cat_index + 1;
4299:

Line 4296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4292: exit when get_category_ids%NOTFOUND;
4293:
4294: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4295: FND_FILE.PUT(FND_FILE.OUTPUT, encode_text(get_category_full_name(l_cat_ids(l_cat_index), l_delim, true)));
4296: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4297:
4298: l_cat_index := l_cat_index + 1;
4299:
4300: end loop;

Line 4314: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4310:
4311: fetch get_product_info INTO l_prod_names(l_prod_index),l_prod_segments;
4312: exit when get_product_info%NOTFOUND;
4313:
4314: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4315: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_prod_names(l_prod_index)));
4316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4317:
4318: l_prod_index := l_prod_index + 1;

Line 4315: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_prod_names(l_prod_index)));

4311: fetch get_product_info INTO l_prod_names(l_prod_index),l_prod_segments;
4312: exit when get_product_info%NOTFOUND;
4313:
4314: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4315: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_prod_names(l_prod_index)));
4316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4317:
4318: l_prod_index := l_prod_index + 1;
4319:

Line 4316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4312: exit when get_product_info%NOTFOUND;
4313:
4314: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4315: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_prod_names(l_prod_index)));
4316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4317:
4318: l_prod_index := l_prod_index + 1;
4319:
4320: end loop;

Line 4337: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4333:
4334: fetch get_platform_info INTO l_plat_names(l_plat_index),l_plat_segments;
4335: exit when get_platform_info%NOTFOUND;
4336:
4337: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4338: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_plat_names(l_plat_index)));
4339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4340:
4341: l_plat_index := l_plat_index + 1;

Line 4338: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_plat_names(l_plat_index)));

4334: fetch get_platform_info INTO l_plat_names(l_plat_index),l_plat_segments;
4335: exit when get_platform_info%NOTFOUND;
4336:
4337: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4338: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_plat_names(l_plat_index)));
4339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4340:
4341: l_plat_index := l_plat_index + 1;
4342:

Line 4339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4335: exit when get_platform_info%NOTFOUND;
4336:
4337: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4338: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_plat_names(l_plat_index)));
4339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4340:
4341: l_plat_index := l_plat_index + 1;
4342:
4343: end loop;

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

4360: l_elmt_names(l_elmt_index), l_elmt_descs(l_elmt_index),
4361: l_elmt_stats(l_elmt_index);
4362:
4363: exit when get_element_info%NOTFOUND;
4364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4365:
4366: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4367: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4366: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4362:
4363: exit when get_element_info%NOTFOUND;
4364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4365:
4366: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4367: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4369:
4370: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

Line 4367: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));

4363: exit when get_element_info%NOTFOUND;
4364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4365:
4366: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4367: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4369:
4370: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4371: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));

Line 4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4365:
4366: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4367: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4369:
4370: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4371: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4370: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4366: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4367: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4369:
4370: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4371: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4373:
4374: -- Determine the Value for the content type from lookups

Line 4371: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));

4367: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4369:
4370: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4371: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4373:
4374: -- Determine the Value for the content type from lookups
4375:

Line 4372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4369:
4370: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4371: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4372: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4373:
4374: -- Determine the Value for the content type from lookups
4375:
4376: select meaning

Line 4382: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4378: from cs_lookups
4379: where lookup_type = 'CS_KB_CONTENT_TYPE'
4380: and lookup_code = l_elmt_cts(l_elmt_index);
4381:
4382: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4383: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4385:
4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

Line 4383: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);

4379: where lookup_type = 'CS_KB_CONTENT_TYPE'
4380: and lookup_code = l_elmt_cts(l_elmt_index);
4381:
4382: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4383: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4385:
4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));

Line 4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4380: and lookup_code = l_elmt_cts(l_elmt_index);
4381:
4382: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4383: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4385:
4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4382: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4383: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4385:
4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4389:
4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

Line 4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));

4383: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4385:
4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4389:
4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4391: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);

Line 4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4385:
4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4389:
4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4391: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

4386: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4389:
4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4391: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393:
4394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');

Line 4391: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);

4387: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4389:
4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4391: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393:
4394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4395:

Line 4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4389:
4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4391: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393:
4394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4395:
4396: l_elmt_index := l_elmt_index + 1;

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

4390: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4391: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393:
4394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4395:
4396: l_elmt_index := l_elmt_index + 1;
4397:
4398: end loop;

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

4400: close get_element_info;
4401:
4402: -- End Querying out Statements for this Solution
4403:
4404: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4405:
4406: l_success_solns := l_success_solns + 1;
4407:
4408: --ELSE -- Solution Contains invalid content for export

Line 4424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4420: close get_solution_info_pub;
4421: END IF;
4422:
4423: IF (l_soln_count > 0) THEN
4424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4425: END IF;
4426:
4427: l_soln_index := l_soln_index - 1;
4428:

Line 4429: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_COUNT') || l_success_solns); --l_soln_index);

4425: END IF;
4426:
4427: l_soln_index := l_soln_index - 1;
4428:
4429: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_COUNT') || l_success_solns); --l_soln_index);
4430:
4431: EXCEPTION
4432:
4433: WHEN INVALID_CATEGORY_NAME

Line 4437: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || p_category_name);

4433: WHEN INVALID_CATEGORY_NAME
4434:
4435: THEN
4436:
4437: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || p_category_name);
4438: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4439: RETCODE := ERROR_STATUS;
4440:
4441: WHEN OTHERS

Line 4438: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);

4434:
4435: THEN
4436:
4437: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || p_category_name);
4438: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4439: RETCODE := ERROR_STATUS;
4440:
4441: WHEN OTHERS
4442:

Line 4445: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_UNEXP')||'-'||substrb(sqlerrm,1,100));

4441: WHEN OTHERS
4442:
4443: THEN
4444:
4445: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_UNEXP')||'-'||substrb(sqlerrm,1,100));
4446: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4447: RETCODE := ERROR_STATUS;
4448:
4449: END EXPORT_SOLUTIONS_2;

Line 4446: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);

4442:
4443: THEN
4444:
4445: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_UNEXP')||'-'||substrb(sqlerrm,1,100));
4446: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4447: RETCODE := ERROR_STATUS;
4448:
4449: END EXPORT_SOLUTIONS_2;
4450: