eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 206: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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