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.CS_KNOWLEDGE_AUDIT_PVT dependencies on FND_MESSAGE

Line 238: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

234:
235: BEGIN
236: -- Check params
237: IF( not p_set_id > 0 ) or (not p_element_id > 0) THEN
238: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
239: GOTO ERROR_FOUND;
240: END IF;
241:
242: --delete a row IN set_eles_audit

Line 293: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

289: BEGIN
290:
291: -- Check params
292: IF( NOT p_set_id > 0 ) OR (p_element_number IS NULL) THEN
293: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
294: GOTO ERROR_FOUND;
295: END IF;
296:
297: -- check IF element exists

Line 302: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');

298: SELECT COUNT(*) INTO l_count
299: FROM CS_KB_ELEMENTS_B
300: WHERE element_number = p_element_number;
301: IF(l_count=0) THEN
302: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
303: GOTO ERROR_FOUND;
304: END IF;
305:
306: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Get_Latest_Version_Id(p_element_number);

Line 315: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_EXIST_ERR');

311: WHERE se.set_id = p_set_id
312: AND se.element_id = eb.element_id
313: AND eb.element_number = p_element_number;
314: IF(l_count>0) THEN
315: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_EXIST_ERR');
316: GOTO ERROR_FOUND;
317: END IF;
318:
319: --check set ele type match

Line 333: FND_MESSAGE.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');

329: IF( Is_Set_Ele_Type_Valid(
330: p_set_type_id => l_set_type_id,
331: p_ele_type_id => l_ele_type_id)
332: = G_FALSE) THEN
333: FND_MESSAGE.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
334: GOTO ERROR_FOUND;
335: END IF;
336:
337: -- prepare data to insert

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 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 4248: FND_MESSAGE.set_name('CS', 'CS_KB_EXPORT_STMT_32K');

4244: END LOOP;
4245:
4246: IF l_error = 'Y' THEN
4247: -- If any of the statements failed validation add a message to the Log
4248: FND_MESSAGE.set_name('CS', 'CS_KB_EXPORT_STMT_32K');
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 );

Line 4249: FND_MESSAGE.SET_TOKEN(TOKEN => 'SOLN_NUMBER',

4245:
4246: IF l_error = 'Y' THEN
4247: -- If any of the statements failed validation add a message to the Log
4248: FND_MESSAGE.set_name('CS', 'CS_KB_EXPORT_STMT_32K');
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);

Line 4251: FND_MESSAGE.SET_TOKEN(TOKEN => 'STMT_NUMBER',

4247: -- If any of the statements failed validation add a message to the Log
4248: FND_MESSAGE.set_name('CS', 'CS_KB_EXPORT_STMT_32K');
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

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 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: