DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_PVT dependencies on FND_MESSAGE

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

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

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

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

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

195: ,X_MSG_DATA => X_MSG_DATA
196: ,X_RETURN_STATUS => X_RETURN_STATUS);
197: WHEN OTHERS THEN
198: Rollback to CREATE_Requirement_lines_PUB;
199: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
200: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
201: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
202: FND_MSG_PUB.ADD;
203: fnd_msg_pub.count_and_get

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

196: ,X_RETURN_STATUS => X_RETURN_STATUS);
197: WHEN OTHERS THEN
198: Rollback to CREATE_Requirement_lines_PUB;
199: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
200: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
201: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
202: FND_MSG_PUB.ADD;
203: fnd_msg_pub.count_and_get
204: ( p_count => x_msg_count

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

197: WHEN OTHERS THEN
198: Rollback to CREATE_Requirement_lines_PUB;
199: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
200: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
201: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
202: FND_MSG_PUB.ADD;
203: fnd_msg_pub.count_and_get
204: ( p_count => x_msg_count
205: , p_data => x_msg_data);

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

342:
343: If ( C_Get_requirement_lines%NOTFOUND) Then
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
345: THEN
346: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
347: FND_MESSAGE.Set_Token ('INFO', 'requirement_lines', FALSE);
348: FND_MSG_PUB.Add;
349: END IF;
350: Close C_Get_requirement_lines;

Line 347: FND_MESSAGE.Set_Token ('INFO', 'requirement_lines', FALSE);

343: If ( C_Get_requirement_lines%NOTFOUND) Then
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
345: THEN
346: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
347: FND_MESSAGE.Set_Token ('INFO', 'requirement_lines', FALSE);
348: FND_MSG_PUB.Add;
349: END IF;
350: Close C_Get_requirement_lines;
351: raise FND_API.G_EXC_ERROR;

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

359: If (l_tar_Requirement_Lines_rec.last_update_date is NULL or
360: l_tar_Requirement_Lines_rec.last_update_date = FND_API.G_MISS_Date ) Then
361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
362: THEN
363: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
364: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
365: FND_MSG_PUB.ADD;
366: END IF;
367: raise FND_API.G_EXC_ERROR;

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

360: l_tar_Requirement_Lines_rec.last_update_date = FND_API.G_MISS_Date ) Then
361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
362: THEN
363: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
364: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
365: FND_MSG_PUB.ADD;
366: END IF;
367: raise FND_API.G_EXC_ERROR;
368: End if;

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

369: -- Check Whether record has been changed by someone else
370: If (l_tar_Requirement_Lines_rec.last_update_date <> l_ref_Requirement_Lines_rec.last_update_date) Then
371: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
372: THEN
373: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
374: FND_MESSAGE.Set_Token('INFO', 'requirement_lines', FALSE);
375: FND_MSG_PUB.ADD;
376: END IF;
377: raise FND_API.G_EXC_ERROR;

Line 374: FND_MESSAGE.Set_Token('INFO', 'requirement_lines', FALSE);

370: If (l_tar_Requirement_Lines_rec.last_update_date <> l_ref_Requirement_Lines_rec.last_update_date) Then
371: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
372: THEN
373: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
374: FND_MESSAGE.Set_Token('INFO', 'requirement_lines', FALSE);
375: FND_MSG_PUB.ADD;
376: END IF;
377: raise FND_API.G_EXC_ERROR;
378: End if;

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

520: ,X_MSG_DATA => X_MSG_DATA
521: ,X_RETURN_STATUS => X_RETURN_STATUS);
522: WHEN OTHERS THEN
523: Rollback to UPDATE_Requirement_Lines_PUB;
524: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
525: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
526: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
527: FND_MSG_PUB.ADD;
528: fnd_msg_pub.count_and_get

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

521: ,X_RETURN_STATUS => X_RETURN_STATUS);
522: WHEN OTHERS THEN
523: Rollback to UPDATE_Requirement_Lines_PUB;
524: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
525: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
526: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
527: FND_MSG_PUB.ADD;
528: fnd_msg_pub.count_and_get
529: ( p_count => x_msg_count

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

522: WHEN OTHERS THEN
523: Rollback to UPDATE_Requirement_Lines_PUB;
524: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
525: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
526: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
527: FND_MSG_PUB.ADD;
528: fnd_msg_pub.count_and_get
529: ( p_count => x_msg_count
530: , p_data => x_msg_data);

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

632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN OTHERS THEN
635: Rollback to DELETE_Requirement_Lines_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get

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

633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN OTHERS THEN
635: Rollback to DELETE_Requirement_Lines_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count

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

634: WHEN OTHERS THEN
635: Rollback to DELETE_Requirement_Lines_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count
642: , p_data => x_msg_data);