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_PACKLIST_LINES_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 166: FND_MSG_PUB.initialize;

162:
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean( p_init_msg_list )
165: THEN
166: FND_MSG_PUB.initialize;
167: END IF;
168:
169:
170: -- Debug Message

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

167: END IF;
168:
169:
170: -- Debug Message
171: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
172:
173:
174: -- Initialize API return status to SUCCESS
175: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

178: -- API body
179: --
180:
181: -- Debug Message
182: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLL_Values_To_Ids');
183:
184: -- Convert the values to ids
185: --
186: Convert_PLL_Values_To_Ids (

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

222: END IF;
223:
224:
225: -- Debug Message
226: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
227:
228:
229: -- Standard call to get message count and if count is 1, get message info.
230: FND_MSG_PUB.Count_And_Get

Line 230: FND_MSG_PUB.Count_And_Get

226: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
227:
228:
229: -- Standard call to get message count and if count is 1, get message info.
230: FND_MSG_PUB.Count_And_Get
231: ( p_count => x_msg_count,
232: p_data => x_msg_data
233: );
234:

Line 240: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

236: WHEN FND_API.G_EXC_ERROR THEN
237: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
238: P_API_NAME => L_API_NAME
239: ,P_PKG_NAME => G_PKG_NAME
240: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
241: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
242: ,X_MSG_COUNT => X_MSG_COUNT
243: ,X_MSG_DATA => X_MSG_DATA
244: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 250: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
248: P_API_NAME => L_API_NAME
249: ,P_PKG_NAME => G_PKG_NAME
250: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
251: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
252: ,X_MSG_COUNT => X_MSG_COUNT
253: ,X_MSG_DATA => X_MSG_DATA
254: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 301: FND_MSG_PUB.initialize;

297:
298: -- Initialize message list if p_init_msg_list is set to TRUE.
299: IF FND_API.to_Boolean( p_init_msg_list )
300: THEN
301: FND_MSG_PUB.initialize;
302: END IF;
303:
304:
305: -- Debug Message

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

302: END IF;
303:
304:
305: -- Debug Message
306: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
307:
308:
309: -- Initialize API return status to SUCCESS
310: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

313: -- API body
314: --
315:
316: -- Debug Message
317: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLL_Values_To_Ids');
318:
319: -- Convert the values to ids
320: --
321: Convert_PLL_Values_To_Ids (

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

354: END IF;
355:
356:
357: -- Debug Message
358: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
359:
360:
361: -- Standard call to get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get

Line 362: FND_MSG_PUB.Count_And_Get

358: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
359:
360:
361: -- Standard call to get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366:

Line 372: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

368: WHEN FND_API.G_EXC_ERROR THEN
369: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
370: P_API_NAME => L_API_NAME
371: ,P_PKG_NAME => G_PKG_NAME
372: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
373: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
374: ,X_MSG_COUNT => X_MSG_COUNT
375: ,X_MSG_DATA => X_MSG_DATA
376: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
380: P_API_NAME => L_API_NAME
381: ,P_PKG_NAME => G_PKG_NAME
382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
383: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
384: ,X_MSG_COUNT => X_MSG_COUNT
385: ,X_MSG_DATA => X_MSG_DATA
386: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 434: FND_MSG_PUB.initialize;

430:
431: -- Initialize message list if p_init_msg_list is set to TRUE.
432: IF FND_API.to_Boolean( p_init_msg_list )
433: THEN
434: FND_MSG_PUB.initialize;
435: END IF;
436:
437:
438: -- Debug Message

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

435: END IF;
436:
437:
438: -- Debug Message
439: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
440:
441:
442: -- Initialize API return status to SUCCESS
443: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

446: -- API body
447: --
448:
449: -- Debug Message
450: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLL_Values_To_Ids');
451:
452: -- Convert the values to ids
453: --
454: Convert_PLL_Values_To_Ids (

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

487: END IF;
488:
489:
490: -- Debug Message
491: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
492:
493:
494: -- Standard call to get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get

Line 495: FND_MSG_PUB.Count_And_Get

491: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
492:
493:
494: -- Standard call to get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get
496: ( p_count => x_msg_count,
497: p_data => x_msg_data
498: );
499:

Line 505: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

501: WHEN FND_API.G_EXC_ERROR THEN
502: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
503: P_API_NAME => L_API_NAME
504: ,P_PKG_NAME => G_PKG_NAME
505: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
506: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
507: ,X_MSG_COUNT => X_MSG_COUNT
508: ,X_MSG_DATA => X_MSG_DATA
509: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
512: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME
515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
516: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
517: ,X_MSG_COUNT => X_MSG_COUNT
518: ,X_MSG_DATA => X_MSG_DATA
519: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 575: FND_MSG_PUB.initialize;

571:
572: -- Initialize message list if p_init_msg_list is set to TRUE.
573: IF FND_API.to_Boolean( p_init_msg_list )
574: THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578:
579: -- Debug Message

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

576: END IF;
577:
578:
579: -- Debug Message
580: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
581:
582:
583: -- Initialize API return status to SUCCESS
584: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

586: --
587: -- API body
588: --
589: -- Debug Message
590: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_PACKLIST_LINES');
591: /*
592: CSP_packlist_lines_PVT.Get_packlist_lines(
593: P_Api_Version_Number => 2.0,
594: P_Init_Msg_List => FND_API.G_FALSE,

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

624: -- End of API body
625: --
626:
627: -- Debug Message
628: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
629:
630:
631: -- Standard call to get message count and if count is 1, get message info.
632: FND_MSG_PUB.Count_And_Get

Line 632: FND_MSG_PUB.Count_And_Get

628: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
629:
630:
631: -- Standard call to get message count and if count is 1, get message info.
632: FND_MSG_PUB.Count_And_Get
633: ( p_count => x_msg_count,
634: p_data => x_msg_data
635: );
636:

Line 642: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

638: WHEN FND_API.G_EXC_ERROR THEN
639: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
640: P_API_NAME => L_API_NAME
641: ,P_PKG_NAME => G_PKG_NAME
642: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
643: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
644: ,X_MSG_COUNT => X_MSG_COUNT
645: ,X_MSG_DATA => X_MSG_DATA
646: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
650: P_API_NAME => L_API_NAME
651: ,P_PKG_NAME => G_PKG_NAME
652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
653: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
654: ,X_MSG_COUNT => X_MSG_COUNT
655: ,X_MSG_DATA => X_MSG_DATA
656: ,X_RETURN_STATUS => X_RETURN_STATUS);