APPS.AP_WEB_AUDIT_LIST_VAL_PVT dependencies on FND_API

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44:
45: BEGIN
46:
47: -- Initialize API return status to success
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: -- Validate employee info
51: Validate_Employee(p_emp_rec,
52: l_emp_return_status);

Line 54: IF l_required_return_status <> FND_API.G_RET_STS_SUCCESS OR

50: -- Validate employee info
51: Validate_Employee(p_emp_rec,
52: l_emp_return_status);
53:
54: IF l_required_return_status <> FND_API.G_RET_STS_SUCCESS OR
55: l_emp_return_status <> FND_API.G_RET_STS_SUCCESS THEN
56:
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: END IF;

Line 55: l_emp_return_status <> FND_API.G_RET_STS_SUCCESS THEN

51: Validate_Employee(p_emp_rec,
52: l_emp_return_status);
53:
54: IF l_required_return_status <> FND_API.G_RET_STS_SUCCESS OR
55: l_emp_return_status <> FND_API.G_RET_STS_SUCCESS THEN
56:
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: END IF;
59:

Line 57: x_return_status := FND_API.G_RET_STS_ERROR;

53:
54: IF l_required_return_status <> FND_API.G_RET_STS_SUCCESS OR
55: l_emp_return_status <> FND_API.G_RET_STS_SUCCESS THEN
56:
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: END IF;
59:
60: END Validate_Employee_Info;
61:

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89:
90: BEGIN
91:
92: -- Initialize API return status to success
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: -- Business group id is always required
96: IF p_emp_rec.business_group_id IS NULL THEN
97:

Line 100: x_return_status := FND_API.G_RET_STS_ERROR;

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;
103:
104: -- Audit reason is always required

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

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;
112:
113: /*=======================================================================*

Line 119: x_return_status := FND_API.G_RET_STS_ERROR;

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:
122: /*======================================================================*
123: | If all required parameters were provided, then at least one employee |

Line 126: IF x_return_status = FND_API.G_RET_STS_SUCCESS

122: /*======================================================================*
123: | If all required parameters were provided, then at least one employee |
124: | criteria is required. |
125: *======================================================================*/
126: IF x_return_status = FND_API.G_RET_STS_SUCCESS
127: AND p_emp_rec.person_id IS NULL
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

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

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;
137:
138: END Validate_Required_Input;

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168: l_emp_return_status VARCHAR2(1);
169: BEGIN
170:
171: -- Initialize API return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: -- Try to match the criteria to a single employee
175: Find_Employee(p_emp_rec, l_emp_return_status);
176:

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

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
315: /*======================================================================*
316: | Employee must be uniquelly identified, no matches were found. |

Line 320: x_return_status := FND_API.G_RET_STS_ERROR;

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
323: p_emp_rec.person_id := l_person_id;
324: END IF;

Line 384: l_return_status1 := FND_API.G_RET_STS_ERROR;

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;
387:
388: CLOSE reason_cur;

Line 392: IF (l_return_status1 = FND_API.G_RET_STS_ERROR OR l_return_status2 = FND_API.G_RET_STS_ERROR) THEN

388: CLOSE reason_cur;
389:
390: Validate_Audit_dates(p_emp_rec, p_audit_rec, l_return_status2);
391:
392: IF (l_return_status1 = FND_API.G_RET_STS_ERROR OR l_return_status2 = FND_API.G_RET_STS_ERROR) THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: END IF;
395:
396: END Validate_Audit_Info;

Line 393: x_return_status := FND_API.G_RET_STS_ERROR;

389:
390: Validate_Audit_dates(p_emp_rec, p_audit_rec, l_return_status2);
391:
392: IF (l_return_status1 = FND_API.G_RET_STS_ERROR OR l_return_status2 = FND_API.G_RET_STS_ERROR) THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: END IF;
395:
396: END Validate_Audit_Info;
397:

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

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;
456:
457: CLOSE open_cur;

Line 494: x_return_status := FND_API.G_RET_STS_SUCCESS;

490:
491: BEGIN
492:
493: -- Initialize API return status to success
494: x_return_status := FND_API.G_RET_STS_SUCCESS;
495:
496: -- Business group id is always required
497: IF p_emp_rec.business_group_id IS NULL THEN
498:

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

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;
504:
505: /*======================================================================*

Line 509: IF x_return_status = FND_API.G_RET_STS_SUCCESS

505: /*======================================================================*
506: | If all required parameters were provided, then at least one employee |
507: | criteria is required. |
508: *======================================================================*/
509: IF x_return_status = FND_API.G_RET_STS_SUCCESS
510: AND p_emp_rec.person_id IS NULL
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

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

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;
520:
521: END Validate_Required_Input;