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_PRODUCT_TASK_PVT dependencies on FND_MSG_PUB

Line 43: FND_MSG_PUB.initialize;

39: END IF;
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41: IF FND_API.to_Boolean( p_init_msg_list )
42: THEN
43: FND_MSG_PUB.initialize;
44: END IF;
45: -- Initialize API return status to SUCCESS
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: --

Line 55: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

51: -- Validate Environment
52: -- ******************************************************************
53: IF FND_GLOBAL.User_Id IS NULL
54: THEN
55: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
56: THEN
57: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
58: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
59: FND_MSG_PUB.ADD;

Line 59: FND_MSG_PUB.ADD;

55: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
56: THEN
57: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
58: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
59: FND_MSG_PUB.ADD;
60: END IF;
61: RAISE FND_API.G_EXC_ERROR;
62: END IF;
63: -- Invoke validation procedures

Line 118: FND_MSG_PUB.Count_And_Get

114: THEN
115: COMMIT WORK;
116: END IF;
117: -- Standard call to get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: EXCEPTION

Line 127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

123: WHEN FND_API.G_EXC_ERROR THEN
124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
125: P_API_NAME => L_API_NAME
126: ,P_PKG_NAME => G_PKG_NAME
127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
129: ,X_MSG_COUNT => X_MSG_COUNT
130: ,X_MSG_DATA => X_MSG_DATA
131: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 136: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
134: P_API_NAME => L_API_NAME
135: ,P_PKG_NAME => G_PKG_NAME
136: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
137: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
138: ,X_MSG_COUNT => X_MSG_COUNT
139: ,X_MSG_DATA => X_MSG_DATA
140: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 221: FND_MSG_PUB.initialize;

217:
218: -- Initialize message list if p_init_msg_list is set to TRUE.
219: IF FND_API.to_Boolean( p_init_msg_list )
220: THEN
221: FND_MSG_PUB.initialize;
222: END IF;
223: -- Initialize API return status to SUCCESS
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225: --

Line 261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

257: l_ref_PROD_TASK_rec.LAST_UPDATE_DATE,
258: l_ref_PROD_TASK_rec.LAST_UPDATE_LOGIN;
259:
260: If ( C_Get_product_task%NOTFOUND) Then
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
262: THEN
263: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
264: FND_MESSAGE.Set_Token ('INFO', 'product_task', FALSE);
265: FND_MSG_PUB.Add;

Line 265: FND_MSG_PUB.Add;

261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
262: THEN
263: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
264: FND_MESSAGE.Set_Token ('INFO', 'product_task', FALSE);
265: FND_MSG_PUB.Add;
266: END IF;
267: Close C_Get_product_task;
268: raise FND_API.G_EXC_ERROR;
269: END IF;

Line 274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

270: Close C_Get_product_task;
271:
272: If (l_tar_PROD_TASK_rec.last_update_date is NULL or
273: l_tar_PROD_TASK_rec.last_update_date = FND_API.G_MISS_Date ) Then
274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
275: THEN
276: DBMS_OUTPUT.PUT_LINE('UPDATE DATE2 '||l_tar_PROD_TASK_rec.last_update_date);
277: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
278: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line 279: FND_MSG_PUB.ADD;

275: THEN
276: DBMS_OUTPUT.PUT_LINE('UPDATE DATE2 '||l_tar_PROD_TASK_rec.last_update_date);
277: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
278: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
279: FND_MSG_PUB.ADD;
280: END IF;
281: raise FND_API.G_EXC_ERROR;
282: End if;
283:

Line 286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

282: End if;
283:
284: -- Check Whether record has been changed by someone else
285: If (l_tar_PROD_TASK_rec.last_update_date <> l_ref_PROD_TASK_rec.last_update_date) Then
286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
287: THEN
288: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
289: FND_MESSAGE.Set_Token('INFO', 'product_task', FALSE);
290: FND_MSG_PUB.ADD;

Line 290: FND_MSG_PUB.ADD;

286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
287: THEN
288: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
289: FND_MESSAGE.Set_Token('INFO', 'product_task', FALSE);
290: FND_MSG_PUB.ADD;
291: END IF;
292: raise FND_API.G_EXC_ERROR;
293: End if;
294:

Line 350: FND_MSG_PUB.Count_And_Get

346: THEN
347: COMMIT WORK;
348: END IF;
349: -- Standard call to get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354: EXCEPTION

Line 359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

355: WHEN FND_API.G_EXC_ERROR THEN
356: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
357: P_API_NAME => L_API_NAME
358: ,P_PKG_NAME => G_PKG_NAME
359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
360: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
361: ,X_MSG_COUNT => X_MSG_COUNT
362: ,X_MSG_DATA => X_MSG_DATA
363: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 368: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
366: P_API_NAME => L_API_NAME
367: ,P_PKG_NAME => G_PKG_NAME
368: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
369: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
370: ,X_MSG_COUNT => X_MSG_COUNT
371: ,X_MSG_DATA => X_MSG_DATA
372: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 414: FND_MSG_PUB.initialize;

410: END IF;
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.to_Boolean( p_init_msg_list )
413: THEN
414: FND_MSG_PUB.initialize;
415: END IF;
416: -- Initialize API return status to SUCCESS
417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418: --

Line 433: FND_MSG_PUB.Count_And_Get

429: THEN
430: COMMIT WORK;
431: END IF;
432: -- Standard call to get message count and if count is 1, get message info.
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437: EXCEPTION

Line 442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

438: WHEN FND_API.G_EXC_ERROR THEN
439: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
440: P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
443: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
449: P_API_NAME => L_API_NAME
450: ,P_PKG_NAME => G_PKG_NAME
451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
453: ,X_MSG_COUNT => X_MSG_COUNT
454: ,X_MSG_DATA => X_MSG_DATA
455: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 687: FND_MSG_PUB.initialize;

683: BEGIN
684: -- Initialize message list if p_init_msg_list is set to TRUE.
685: IF FND_API.to_Boolean( p_init_msg_list )
686: THEN
687: FND_MSG_PUB.initialize;
688: END IF;
689: -- Initialize API return status to SUCCESS
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691: -- validate NOT NULL column

Line 712: FND_MSG_PUB.Count_And_Get

708: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
709: NULL;
710: END IF;
711: -- Standard call to get message count and if count is 1, get message info.
712: FND_MSG_PUB.Count_And_Get
713: ( p_count => x_msg_count,
714: p_data => x_msg_data
715: );
716: END Validate_PRODUCT_TASK_ID;

Line 731: FND_MSG_PUB.initialize;

727: BEGIN
728: -- Initialize message list if p_init_msg_list is set to TRUE.
729: IF FND_API.to_Boolean( p_init_msg_list )
730: THEN
731: FND_MSG_PUB.initialize;
732: END IF;
733: -- Initialize API return status to SUCCESS
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735: -- validate NOT NULL column

Line 756: FND_MSG_PUB.Count_And_Get

752: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
753: NULL;
754: END IF;
755: -- Standard call to get message count and if count is 1, get message info.
756: FND_MSG_PUB.Count_And_Get
757: ( p_count => x_msg_count,
758: p_data => x_msg_data
759: );
760: END Validate_PRODUCT_ID;

Line 775: FND_MSG_PUB.initialize;

771: BEGIN
772: -- Initialize message list if p_init_msg_list is set to TRUE.
773: IF FND_API.to_Boolean( p_init_msg_list )
774: THEN
775: FND_MSG_PUB.initialize;
776: END IF;
777: -- Initialize API return status to SUCCESS
778: x_return_status := FND_API.G_RET_STS_SUCCESS;
779: -- validate NOT NULL column

Line 800: FND_MSG_PUB.Count_And_Get

796: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
797: NULL;
798: END IF;
799: -- Standard call to get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804: END Validate_TASK_TEMPLATE_ID;

Line 819: FND_MSG_PUB.initialize;

815: BEGIN
816: -- Initialize message list if p_init_msg_list is set to TRUE.
817: IF FND_API.to_Boolean( p_init_msg_list )
818: THEN
819: FND_MSG_PUB.initialize;
820: END IF;
821: -- Initialize API return status to SUCCESS
822: x_return_status := FND_API.G_RET_STS_SUCCESS;
823: -- validate NOT NULL column

Line 844: FND_MSG_PUB.Count_And_Get

840: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
841: NULL;
842: END IF;
843: -- Standard call to get message count and if count is 1, get message info.
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );
848: END Validate_AUTO_MANUAL;

Line 863: FND_MSG_PUB.initialize;

859: BEGIN
860: -- Initialize message list if p_init_msg_list is set to TRUE.
861: IF FND_API.to_Boolean( p_init_msg_list )
862: THEN
863: FND_MSG_PUB.initialize;
864: END IF;
865: -- Initialize API return status to SUCCESS
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 883: FND_MSG_PUB.Count_And_Get

879: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
880: NULL;
881: END IF;
882: -- Standard call to get message count and if count is 1, get message info.
883: FND_MSG_PUB.Count_And_Get
884: ( p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887: END Validate_ACTUAL_TIMES_USED;

Line 902: FND_MSG_PUB.initialize;

898: BEGIN
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list )
901: THEN
902: FND_MSG_PUB.initialize;
903: END IF;
904: -- Initialize API return status to SUCCESS
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 922: FND_MSG_PUB.Count_And_Get

918: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
919: NULL;
920: END IF;
921: -- Standard call to get message count and if count is 1, get message info.
922: FND_MSG_PUB.Count_And_Get
923: ( p_count => x_msg_count,
924: p_data => x_msg_data
925: );
926: END Validate_TASK_PERCENTAGE;

Line 944: FND_MSG_PUB.initialize;

940: BEGIN
941: -- Initialize message list if p_init_msg_list is set to TRUE.
942: IF FND_API.to_Boolean( p_init_msg_list )
943: THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946: -- Initialize API return status to SUCCESS
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948: -- Hint: Validate data

Line 954: FND_MSG_PUB.Count_And_Get

950: -- THEN
951: -- x_return_status := FND_API.G_RET_STS_ERROR;
952: -- Debug Message
953: -- Standard call to get message count and if count is 1, get message info.
954: FND_MSG_PUB.Count_And_Get
955: ( p_count => x_msg_count,
956: p_data => x_msg_data
957: );
958: END Validate_PROD_TASK_Rec;