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

Line 56: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

52: -- THEN
53: -- p_pvt_opp_rec.lead_source_code := p_opp_rec.lead_source_code;
54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
55: -- THEN
56: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
57: -- THEN
58: -- FND_MESSAGE.Set_Name('AS','API_ATTRIBUTE_IGNORED');
59: -- FND_MESSAGE.Set_Token('COLUMN','LEAD_SOURCE',FALSE);
60: -- FND_MSG_PUB.Add;

Line 60: -- FND_MSG_PUB.Add;

56: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
57: -- THEN
58: -- FND_MESSAGE.Set_Name('AS','API_ATTRIBUTE_IGNORED');
59: -- FND_MESSAGE.Set_Token('COLUMN','LEAD_SOURCE',FALSE);
60: -- FND_MSG_PUB.Add;
61: -- END IF;
62: -- END IF;
63: -- ELSIF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
64: -- THEN

Line 71: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

67: -- CLOSE C_Get_Lookup_Code;
68: -- p_pvt_opp_rec.lead_source_code := l_val;
69: -- IF(l_val IS NULL)
70: -- THEN
71: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
72: -- THEN
73: -- FND_MESSAGE.Set_Name('AS','API_ATTRIBUTE_CONVERSION_ERROR'
74: -- FND_MESSAGE.Set_Token('COLUMN','LEAD_SOURCE', FALSE
75: -- FND_MESSAGE.Set_Token('VALUE', p_opp_rec.lead_source, FALSE

Line 76: -- FND_MSG_PUB.Add;

72: -- THEN
73: -- FND_MESSAGE.Set_Name('AS','API_ATTRIBUTE_CONVERSION_ERROR'
74: -- FND_MESSAGE.Set_Token('COLUMN','LEAD_SOURCE', FALSE
75: -- FND_MESSAGE.Set_Token('VALUE', p_opp_rec.lead_source, FALSE
76: -- FND_MSG_PUB.Add;
77: -- END IF;
78: -- l_any_errors := TRUE;
79: -- END IF;
80: -- ELSE

Line 144: FND_MSG_PUB.initialize;

140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list )
143: THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146:
147:
148: -- Debug Message

Line 149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');

145: END IF;
146:
147:
148: -- Debug Message
149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
150:
151:
152: -- Initialize API return status to SUCCESS
153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 160: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');

156: -- API body
157: --
158:
159: -- Debug Message
160: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');
161:
162: -- Convert the values to ids
163: --
164: Convert_plsl_Values_To_Ids (

Line 204: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');

200: END IF;
201:
202:
203: -- Debug Message
204: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
205:
206:
207: -- Standard call to get message count and if count is 1, get message info.
208: FND_MSG_PUB.Count_And_Get

Line 208: FND_MSG_PUB.Count_And_Get

204: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
205:
206:
207: -- Standard call to get message count and if count is 1, get message info.
208: FND_MSG_PUB.Count_And_Get
209: ( p_count => x_msg_count,
210: p_data => x_msg_data
211: );
212:

Line 218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

214: WHEN FND_API.G_EXC_ERROR THEN
215: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
219: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 228: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
226: P_API_NAME => L_API_NAME
227: ,P_PKG_NAME => G_PKG_NAME
228: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
229: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
230: ,X_MSG_COUNT => X_MSG_COUNT
231: ,X_MSG_DATA => X_MSG_DATA
232: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 279: FND_MSG_PUB.initialize;

275:
276: -- Initialize message list if p_init_msg_list is set to TRUE.
277: IF FND_API.to_Boolean( p_init_msg_list )
278: THEN
279: FND_MSG_PUB.initialize;
280: END IF;
281:
282:
283: -- Debug Message

Line 284: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');

280: END IF;
281:
282:
283: -- Debug Message
284: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
285:
286:
287: -- Initialize API return status to SUCCESS
288: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 295: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');

291: -- API body
292: --
293:
294: -- Debug Message
295: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');
296:
297: -- Convert the values to ids
298: --
299: Convert_plsl_Values_To_Ids (

Line 336: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');

332: END IF;
333:
334:
335: -- Debug Message
336: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
337:
338:
339: -- Standard call to get message count and if count is 1, get message info.
340: FND_MSG_PUB.Count_And_Get

Line 340: FND_MSG_PUB.Count_And_Get

336: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
337:
338:
339: -- Standard call to get message count and if count is 1, get message info.
340: FND_MSG_PUB.Count_And_Get
341: ( p_count => x_msg_count,
342: p_data => x_msg_data
343: );
344:

Line 350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

346: WHEN FND_API.G_EXC_ERROR THEN
347: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
348: P_API_NAME => L_API_NAME
349: ,P_PKG_NAME => G_PKG_NAME
350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
351: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
352: ,X_MSG_COUNT => X_MSG_COUNT
353: ,X_MSG_DATA => X_MSG_DATA
354: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 360: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
358: P_API_NAME => L_API_NAME
359: ,P_PKG_NAME => G_PKG_NAME
360: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
361: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
362: ,X_MSG_COUNT => X_MSG_COUNT
363: ,X_MSG_DATA => X_MSG_DATA
364: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 412: FND_MSG_PUB.initialize;

408:
409: -- Initialize message list if p_init_msg_list is set to TRUE.
410: IF FND_API.to_Boolean( p_init_msg_list )
411: THEN
412: FND_MSG_PUB.initialize;
413: END IF;
414:
415:
416: -- Debug Message

Line 417: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');

413: END IF;
414:
415:
416: -- Debug Message
417: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
418:
419:
420: -- Initialize API return status to SUCCESS
421: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 428: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');

424: -- API body
425: --
426:
427: -- Debug Message
428: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');
429:
430: -- Convert the values to ids
431: --
432: Convert_plsl_Values_To_Ids (

Line 469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');

465: END IF;
466:
467:
468: -- Debug Message
469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
470:
471:
472: -- Standard call to get message count and if count is 1, get message info.
473: FND_MSG_PUB.Count_And_Get

Line 473: FND_MSG_PUB.Count_And_Get

469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
470:
471:
472: -- Standard call to get message count and if count is 1, get message info.
473: FND_MSG_PUB.Count_And_Get
474: ( p_count => x_msg_count,
475: p_data => x_msg_data
476: );
477:

Line 483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

479: WHEN FND_API.G_EXC_ERROR THEN
480: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
481: P_API_NAME => L_API_NAME
482: ,P_PKG_NAME => G_PKG_NAME
483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
484: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
485: ,X_MSG_COUNT => X_MSG_COUNT
486: ,X_MSG_DATA => X_MSG_DATA
487: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
495: ,X_MSG_COUNT => X_MSG_COUNT
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 553: FND_MSG_PUB.initialize;

549:
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF FND_API.to_Boolean( p_init_msg_list )
552: THEN
553: FND_MSG_PUB.initialize;
554: END IF;
555:
556:
557: -- Debug Message

Line 558: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');

554: END IF;
555:
556:
557: -- Debug Message
558: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
559:
560:
561: -- Initialize API return status to SUCCESS
562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 568: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Pack_Serial_Lots');

564: --
565: -- API body
566: --
567: -- Debug Message
568: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Pack_Serial_Lots');
569: /*
570: CSP_pack_serial_lots_PVT.Get_pack_serial_lots(
571: P_Api_Version_Number => 2.0,
572: P_Init_Msg_List => FND_API.G_FALSE,

Line 606: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');

602: -- End of API body
603: --
604:
605: -- Debug Message
606: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get

Line 610: FND_MSG_PUB.Count_And_Get

606: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: ( p_count => x_msg_count,
612: p_data => x_msg_data
613: );
614:

Line 620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

616: WHEN FND_API.G_EXC_ERROR THEN
617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
622: ,X_MSG_COUNT => X_MSG_COUNT
623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
632: ,X_MSG_COUNT => X_MSG_COUNT
633: ,X_MSG_DATA => X_MSG_DATA
634: ,X_RETURN_STATUS => X_RETURN_STATUS);