DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PVT dependencies on FND_MESSAGE

Line 70: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');

66: /* IF FND_GLOBAL.User_Id IS NULL
67: THEN
68: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
69: THEN
70: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
71: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
72: FND_MSG_PUB.ADD;
73: END IF;
74: RAISE FND_API.G_EXC_ERROR;

Line 71: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

67: THEN
68: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
69: THEN
70: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
71: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
72: FND_MSG_PUB.ADD;
73: END IF;
74: RAISE FND_API.G_EXC_ERROR;
75: END IF;

Line 205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203: WHEN OTHERS THEN
204: Rollback to CREATE_Requirement_headers_PUB;
205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get

Line 206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203: WHEN OTHERS THEN
204: Rollback to CREATE_Requirement_headers_PUB;
205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count

Line 207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

203: WHEN OTHERS THEN
204: Rollback to CREATE_Requirement_headers_PUB;
205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count
211: , p_data => x_msg_data);

Line 365: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');

361:
362: If ( C_Get_requirement_headers%NOTFOUND) Then
363: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
364: THEN
365: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
366: FND_MESSAGE.Set_Token ('INFO', 'requirement_headers', FALSE);
367: FND_MSG_PUB.Add;
368: END IF;
369: Close C_Get_requirement_headers;

Line 366: FND_MESSAGE.Set_Token ('INFO', 'requirement_headers', FALSE);

362: If ( C_Get_requirement_headers%NOTFOUND) Then
363: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
364: THEN
365: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
366: FND_MESSAGE.Set_Token ('INFO', 'requirement_headers', FALSE);
367: FND_MSG_PUB.Add;
368: END IF;
369: Close C_Get_requirement_headers;
370: raise FND_API.G_EXC_ERROR;

Line 382: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');

378: /* If (l_tar_REQUIREMENT_HEADER_rec.last_update_date is NULL or
379: l_tar_REQUIREMENT_HEADER_rec.last_update_date = FND_API.G_MISS_Date ) Then
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
381: THEN
382: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
383: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
384: FND_MSG_PUB.ADD;
385: END IF;
386: raise FND_API.G_EXC_ERROR;

Line 383: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

379: l_tar_REQUIREMENT_HEADER_rec.last_update_date = FND_API.G_MISS_Date ) Then
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
381: THEN
382: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
383: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
384: FND_MSG_PUB.ADD;
385: END IF;
386: raise FND_API.G_EXC_ERROR;
387: End if;

Line 392: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');

388: -- Check Whether record has been changed by someone else
389: If (l_tar_REQUIREMENT_HEADER_rec.last_update_date <> l_ref_REQUIREMENT_HEADER_rec.last_update_date) Then
390: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
391: THEN
392: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
393: FND_MESSAGE.Set_Token('INFO', 'requirement_headers', FALSE);
394: FND_MSG_PUB.ADD;
395: END IF;
396: raise FND_API.G_EXC_ERROR;

Line 393: FND_MESSAGE.Set_Token('INFO', 'requirement_headers', FALSE);

389: If (l_tar_REQUIREMENT_HEADER_rec.last_update_date <> l_ref_REQUIREMENT_HEADER_rec.last_update_date) Then
390: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
391: THEN
392: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
393: FND_MESSAGE.Set_Token('INFO', 'requirement_headers', FALSE);
394: FND_MSG_PUB.ADD;
395: END IF;
396: raise FND_API.G_EXC_ERROR;
397: End if;

Line 505: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

501: ,X_MSG_DATA => X_MSG_DATA
502: ,X_RETURN_STATUS => X_RETURN_STATUS);
503: WHEN OTHERS THEN
504: Rollback to UPDATE_Requirement_headers_PUB;
505: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
506: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
507: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
508: FND_MSG_PUB.ADD;
509: fnd_msg_pub.count_and_get

Line 506: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

502: ,X_RETURN_STATUS => X_RETURN_STATUS);
503: WHEN OTHERS THEN
504: Rollback to UPDATE_Requirement_headers_PUB;
505: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
506: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
507: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
508: FND_MSG_PUB.ADD;
509: fnd_msg_pub.count_and_get
510: ( p_count => x_msg_count

Line 507: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

503: WHEN OTHERS THEN
504: Rollback to UPDATE_Requirement_headers_PUB;
505: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
506: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
507: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
508: FND_MSG_PUB.ADD;
509: fnd_msg_pub.count_and_get
510: ( p_count => x_msg_count
511: , p_data => x_msg_data);

Line 616: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

612: ,X_MSG_DATA => X_MSG_DATA
613: ,X_RETURN_STATUS => X_RETURN_STATUS);
614: WHEN OTHERS THEN
615: Rollback to DELETE_Requirement_headers_PUB;
616: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
617: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
618: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get

Line 617: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);

613: ,X_RETURN_STATUS => X_RETURN_STATUS);
614: WHEN OTHERS THEN
615: Rollback to DELETE_Requirement_headers_PUB;
616: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
617: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
618: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get
621: ( p_count => x_msg_count

Line 618: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);

614: WHEN OTHERS THEN
615: Rollback to DELETE_Requirement_headers_PUB;
616: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
617: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
618: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get
621: ( p_count => x_msg_count
622: , p_data => x_msg_data);