DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_LIST_VAL_PVT dependencies on FND_MESSAGE

Line 98: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_BG_NULL');

94:
95: -- Business group id is always required
96: IF p_emp_rec.business_group_id IS NULL THEN
97:
98: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_BG_NULL');
99: FND_MSG_PUB.Add;
100: x_return_status := FND_API.G_RET_STS_ERROR;
101:
102: END IF;

Line 107: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_AR_NULL');

103:
104: -- Audit reason is always required
105: IF p_audit_rec.audit_reason_code IS NULL THEN
106:
107: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_AR_NULL');
108: FND_MSG_PUB.Add;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110:
111: END IF;

Line 117: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_TED_NULL');

113: /*=======================================================================*
114: | Either start date or end date must be provided |
115: *=======================================================================*/
116: IF p_audit_rec.start_date IS NULL and p_audit_rec.end_date IS NULL THEN
117: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_TED_NULL');
118: FND_MSG_PUB.Add;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: END IF;
121:

Line 132: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_EMP_INFO');

128: AND p_emp_rec.employee_number IS NULL
129: AND p_emp_rec.national_identifier IS NULL
130: AND p_emp_rec.email_address IS NULL THEN
131:
132: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_EMP_INFO');
133: FND_MSG_PUB.Add;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135:
136: END IF;

Line 310: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_MULTIPLE_EMP');

306: IF l_counter >= 2 THEN
307: /*======================================================================*
308: | Employee must be uniquelly identified, several matches were found. |
309: *======================================================================*/
310: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_MULTIPLE_EMP');
311: FND_MSG_PUB.Add;
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: p_emp_rec.person_id := to_number(null);
314: ELSIF l_counter = 0 THEN

Line 318: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_EMP_MATCH');

314: ELSIF l_counter = 0 THEN
315: /*======================================================================*
316: | Employee must be uniquelly identified, no matches were found. |
317: *======================================================================*/
318: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_EMP_MATCH');
319: FND_MSG_PUB.Add;
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: p_emp_rec.person_id := to_number(null);
322: ELSE

Line 382: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_AC_MATCH');

378:
379: /*====================================================*
380: | Given audit reason is not available or not active. |
381: *====================================================*/
382: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_AC_MATCH');
383: FND_MSG_PUB.Add;
384: l_return_status1 := FND_API.G_RET_STS_ERROR;
385:
386: END IF;

Line 451: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_MISSING_ED_REC');

447: /*=======================================================================*
448: | For record with only end date provided, there must exist a open ended |
449: | record with same reason_code. This is used when an employee returns |
450: *=======================================================================*/
451: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_MISSING_ED_REC');
452: FND_MSG_PUB.Add;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454:
455: END IF;

Line 499: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_BG_NULL');

495:
496: -- Business group id is always required
497: IF p_emp_rec.business_group_id IS NULL THEN
498:
499: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_BG_NULL');
500: FND_MSG_PUB.Add;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: END IF;

Line 515: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_EMP_INFO');

511: AND p_emp_rec.employee_number IS NULL
512: AND p_emp_rec.national_identifier IS NULL
513: AND p_emp_rec.email_address IS NULL THEN
514:
515: FND_MESSAGE.SET_NAME('SQLAP','OIE_AUD_ALAPI_NO_EMP_INFO');
516: FND_MSG_PUB.Add;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518:
519: END IF;