DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on FND_MESSAGE

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

243:
244: BEGIN
245: -- Check params
246: IF( not p_set_id > 0 ) or (not p_element_id > 0) THEN
247: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
248: GOTO ERROR_FOUND;
249: END IF;
250:
251: --delete a row IN set_eles_audit

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

298: BEGIN
299:
300: -- Check params
301: IF( NOT p_set_id > 0 ) OR (p_element_number IS NULL) THEN
302: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
303: GOTO ERROR_FOUND;
304: END IF;
305:
306: -- check IF element exists

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

307: SELECT COUNT(*) INTO l_count
308: FROM CS_KB_ELEMENTS_B
309: WHERE element_number = p_element_number;
310: IF(l_count=0) THEN
311: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
312: GOTO ERROR_FOUND;
313: END IF;
314:
315: l_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Get_Latest_Version_Id(p_element_number);

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

320: WHERE se.set_id = p_set_id
321: AND se.element_id = eb.element_id
322: AND eb.element_number = p_element_number;
323: IF(l_count>0) THEN
324: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_EXIST_ERR');
325: GOTO ERROR_FOUND;
326: END IF;
327:
328: --check set ele type match

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

338: IF( Is_Set_Ele_Type_Valid(
339: p_set_type_id => l_set_type_id,
340: p_ele_type_id => l_ele_type_id)
341: = G_FALSE) THEN
342: FND_MESSAGE.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
343: GOTO ERROR_FOUND;
344: END IF;
345:
346: -- prepare data to insert

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

4254: END LOOP;
4255:
4256: IF l_error = 'Y' THEN
4257: -- If any of the statements failed validation add a message to the Log
4258: FND_MESSAGE.set_name('CS', 'CS_KB_EXPORT_STMT_32K');
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 );

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

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

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

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

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