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;
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;
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
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
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);
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;
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;
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;
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;
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;
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;
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
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
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);
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
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
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);