APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on FND_FILE

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

3227: WHILE (chunkPos<= x_sourceLength) AND
3228: ((x_sourceLength-chunkPos) >= chunkSize)
3229: LOOP
3230: DBMS_LOB.READ(p_clob, chunkSize, chunkPos, x_Buf);
3231: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3232: chunkPos := chunkPos + chunkSize;
3233: END LOOP;
3234:
3235: -- read the rest of CLOB

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

3235: -- read the rest of CLOB
3236: IF ((x_sourceLength-chunkPos) < chunkSize) THEN
3237: amt := x_sourceLength-chunkPos+1;
3238: DBMS_LOB.READ(p_clob, amt, chunkPos, x_Buf);
3239: FND_FILE.PUT(p_file, Encode_Text(x_Buf));
3240: END IF;
3241:
3242: END Write_Clob_To_File;
3243:

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

3730:
3731: close c1;
3732:
3733: if(contains_gt) then
3734: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || composite_cat_name);
3735: end if;
3736:
3737: return composite_cat_name;
3738:

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

4132: * Query OUT All the set_ids matching the criteria
4133: *
4134: *******************************************************/
4135:
4136: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4137: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4138:
4139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4133: *
4134: *******************************************************/
4135:
4136: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4137: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4138:
4139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4141:

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

4135:
4136: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4137: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4138:
4139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4141:
4142: IF (p_sol_status = 'ALL')
4143: THEN

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

4136: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_CAT')|| p_category_name);
4137: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_STATUS')|| p_sol_status);
4138:
4139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4140: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4141:
4142: IF (p_sol_status = 'ALL')
4143: THEN
4144: SELECT /*+ index(sc) */ count(a.set_number) INTO l_soln_count

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

4161: and a.status = 'PUB';
4162: END IF;
4163:
4164: IF (l_soln_count > 0) THEN
4165: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_ATTEMPT') || l_soln_count);
4166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4167: END IF;
4168:
4169: l_soln_index := 1;

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

4162: END IF;
4163:
4164: IF (l_soln_count > 0) THEN
4165: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_ATTEMPT') || l_soln_count);
4166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4167: END IF;
4168:
4169: l_soln_index := 1;
4170: l_success_solns := 0;

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

4221: -- If l_Num = 0 Then NO new line characters were found in the chunk
4222: IF l_Num = 0 THEN
4223: -- Validate if this is the last chunk (and that the size < 32K)
4224: -- If this is NOT the last chunk then this will cause an error
4225: -- when using FND_FILE, so through exception and do not process
4226: -- this Solution.
4227: IF l_Start < (length(StmtCheck.stmt) - l_Limit ) THEN
4228: l_Error := 'Y';
4229: IF l_Stmts is null THEN

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

4249: FND_MESSAGE.SET_TOKEN(TOKEN => 'SOLN_NUMBER',
4250: VALUE => l_set_nos(l_soln_index) );
4251: FND_MESSAGE.SET_TOKEN(TOKEN => 'STMT_NUMBER',
4252: VALUE => l_stmts );
4253: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET);
4254:
4255: ELSIF l_error = 'N' THEN
4256:
4257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');

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

4253: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET);
4254:
4255: ELSIF l_error = 'N' THEN
4256:
4257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4258:
4259: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4260: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4255: ELSIF l_error = 'N' THEN
4256:
4257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4258:
4259: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4260: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4262:
4263: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

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

4256:
4257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4258:
4259: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4260: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4262:
4263: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4264: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));

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

4257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4258:
4259: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4260: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4262:
4263: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4264: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4259: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4260: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4262:
4263: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4264: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4266:
4267: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

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

4260: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_nos(l_soln_index));
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4262:
4263: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4264: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4266:
4267: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4268: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));

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

4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4262:
4263: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4264: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4266:
4267: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4268: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));
4269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4263: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4264: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_type_names(l_soln_index));
4265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4266:
4267: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4268: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));
4269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4270:
4271: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

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

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

4268: FND_FILE.PUT(FND_FILE.OUTPUT, l_set_vis(l_soln_index));
4269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4270:
4271: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274:
4275: -- output all categories instead of just the one specified by parameter
4276: l_cat_index := 1;

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

4269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4270:
4271: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4274:
4275: -- output all categories instead of just the one specified by parameter
4276: l_cat_index := 1;
4277: open get_category_ids(l_set_ids(l_soln_index));

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

4280:
4281: fetch get_category_ids INTO l_cat_ids(l_cat_index);
4282: exit when get_category_ids%NOTFOUND;
4283:
4284: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4285: FND_FILE.PUT(FND_FILE.OUTPUT, encode_text(get_category_full_name(l_cat_ids(l_cat_index), l_delim, true)));
4286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4287:
4288: l_cat_index := l_cat_index + 1;

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

4281: fetch get_category_ids INTO l_cat_ids(l_cat_index);
4282: exit when get_category_ids%NOTFOUND;
4283:
4284: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4285: FND_FILE.PUT(FND_FILE.OUTPUT, encode_text(get_category_full_name(l_cat_ids(l_cat_index), l_delim, true)));
4286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4287:
4288: l_cat_index := l_cat_index + 1;
4289:

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

4282: exit when get_category_ids%NOTFOUND;
4283:
4284: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4285: FND_FILE.PUT(FND_FILE.OUTPUT, encode_text(get_category_full_name(l_cat_ids(l_cat_index), l_delim, true)));
4286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4287:
4288: l_cat_index := l_cat_index + 1;
4289:
4290: end loop;

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

4300:
4301: fetch get_product_info INTO l_prod_names(l_prod_index),l_prod_segments;
4302: exit when get_product_info%NOTFOUND;
4303:
4304: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4305: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_prod_names(l_prod_index)));
4306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4307:
4308: l_prod_index := l_prod_index + 1;

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

4301: fetch get_product_info INTO l_prod_names(l_prod_index),l_prod_segments;
4302: exit when get_product_info%NOTFOUND;
4303:
4304: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4305: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_prod_names(l_prod_index)));
4306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4307:
4308: l_prod_index := l_prod_index + 1;
4309:

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

4302: exit when get_product_info%NOTFOUND;
4303:
4304: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4305: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_prod_names(l_prod_index)));
4306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4307:
4308: l_prod_index := l_prod_index + 1;
4309:
4310: end loop;

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

4323:
4324: fetch get_platform_info INTO l_plat_names(l_plat_index),l_plat_segments;
4325: exit when get_platform_info%NOTFOUND;
4326:
4327: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4328: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_plat_names(l_plat_index)));
4329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4330:
4331: l_plat_index := l_plat_index + 1;

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

4324: fetch get_platform_info INTO l_plat_names(l_plat_index),l_plat_segments;
4325: exit when get_platform_info%NOTFOUND;
4326:
4327: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4328: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_plat_names(l_plat_index)));
4329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4330:
4331: l_plat_index := l_plat_index + 1;
4332:

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

4325: exit when get_platform_info%NOTFOUND;
4326:
4327: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4328: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_plat_names(l_plat_index)));
4329: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4330:
4331: l_plat_index := l_plat_index + 1;
4332:
4333: end loop;

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

4350: l_elmt_names(l_elmt_index), l_elmt_descs(l_elmt_index),
4351: l_elmt_stats(l_elmt_index);
4352:
4353: exit when get_element_info%NOTFOUND;
4354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4355:
4356: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4357: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4352:
4353: exit when get_element_info%NOTFOUND;
4354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4355:
4356: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4357: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4359:
4360: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

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

4353: exit when get_element_info%NOTFOUND;
4354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4355:
4356: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4357: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4359:
4360: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4361: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));

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

4354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4355:
4356: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4357: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4359:
4360: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4361: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4356: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4357: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4359:
4360: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4361: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4363:
4364: -- Determine the Value for the content type from lookups

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

4357: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_nos(l_elmt_index));
4358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4359:
4360: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4361: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4363:
4364: -- Determine the Value for the content type from lookups
4365:

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

4358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4359:
4360: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4361: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_dists(l_elmt_index));
4362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4363:
4364: -- Determine the Value for the content type from lookups
4365:
4366: select meaning

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

4368: from cs_lookups
4369: where lookup_type = 'CS_KB_CONTENT_TYPE'
4370: and lookup_code = l_elmt_cts(l_elmt_index);
4371:
4372: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4373: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4375:
4376: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

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

4369: where lookup_type = 'CS_KB_CONTENT_TYPE'
4370: and lookup_code = l_elmt_cts(l_elmt_index);
4371:
4372: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4373: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4375:
4376: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4377: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));

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

4370: and lookup_code = l_elmt_cts(l_elmt_index);
4371:
4372: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4373: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4375:
4376: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4377: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4372: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4373: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4375:
4376: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4377: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4379:
4380: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');

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

4373: FND_FILE.PUT(FND_FILE.OUTPUT, l_elmt_content_type);
4374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4375:
4376: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4377: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4379:
4380: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4381: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);

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

4374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4375:
4376: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4377: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4379:
4380: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4381: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

4376: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4377: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4379:
4380: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4381: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4383:
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');

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

4377: FND_FILE.PUT(FND_FILE.OUTPUT, Encode_Text(l_elmt_names(l_elmt_index)));
4378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4379:
4380: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4381: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4383:
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4385:

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

4378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4379:
4380: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4381: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4383:
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4385:
4386: l_elmt_index := l_elmt_index + 1;

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

4380: FND_FILE.PUT(FND_FILE.OUTPUT, ' ' || '');
4381: Write_Clob_To_File(l_elmt_descs(l_elmt_index), FND_FILE.OUTPUT);
4382: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4383:
4384: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4385:
4386: l_elmt_index := l_elmt_index + 1;
4387:
4388: end loop;

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

4390: close get_element_info;
4391:
4392: -- End Querying out Statements for this Solution
4393:
4394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ' || '');
4395:
4396: l_success_solns := l_success_solns + 1;
4397:
4398: --ELSE -- Solution Contains invalid content for export

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

4410: close get_solution_info_pub;
4411: END IF;
4412:
4413: IF (l_soln_count > 0) THEN
4414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4415: END IF;
4416:
4417: l_soln_index := l_soln_index - 1;
4418:

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

4415: END IF;
4416:
4417: l_soln_index := l_soln_index - 1;
4418:
4419: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_COUNT') || l_success_solns); --l_soln_index);
4420:
4421: EXCEPTION
4422:
4423: WHEN INVALID_CATEGORY_NAME

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

4423: WHEN INVALID_CATEGORY_NAME
4424:
4425: THEN
4426:
4427: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || p_category_name);
4428: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4429: RETCODE := ERROR_STATUS;
4430:
4431: WHEN OTHERS

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

4424:
4425: THEN
4426:
4427: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_INVCAT') || p_category_name);
4428: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4429: RETCODE := ERROR_STATUS;
4430:
4431: WHEN OTHERS
4432:

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

4431: WHEN OTHERS
4432:
4433: THEN
4434:
4435: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_UNEXP')||'-'||substrb(sqlerrm,1,100));
4436: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4437: RETCODE := ERROR_STATUS;
4438:
4439: END EXPORT_SOLUTIONS_2;

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

4432:
4433: THEN
4434:
4435: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_UNEXP')||'-'||substrb(sqlerrm,1,100));
4436: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET_STRING('CS','CS_KB_EXPORT_RETST')|| ERROR_STATUS);
4437: RETCODE := ERROR_STATUS;
4438:
4439: END EXPORT_SOLUTIONS_2;
4440: