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_ORDERLINES_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 160: FND_MSG_PUB.initialize;

156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF FND_API.to_Boolean( p_init_msg_list )
159: THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162:
163:
164: -- Debug Message

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

161: END IF;
162:
163:
164: -- Debug Message
165: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
166:
167:
168: -- Initialize API return status to SUCCESS
169: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

172: -- API body
173: --
174:
175: -- Debug Message
176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_mol_Values_To_Ids');
177:
178: -- Convert the values to ids
179: --
180: Convert_mol_Values_To_Ids (

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

216: END IF;
217:
218:
219: -- Debug Message
220: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
221:
222:
223: -- Standard call to get message count and if count is 1, get message info.
224: FND_MSG_PUB.Count_And_Get

Line 224: FND_MSG_PUB.Count_And_Get

220: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
221:
222:
223: -- Standard call to get message count and if count is 1, get message info.
224: FND_MSG_PUB.Count_And_Get
225: ( p_count => x_msg_count,
226: p_data => x_msg_data
227: );
228:

Line 234: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

230: WHEN FND_API.G_EXC_ERROR THEN
231: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
232: P_API_NAME => L_API_NAME
233: ,P_PKG_NAME => G_PKG_NAME
234: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
236: ,X_MSG_COUNT => X_MSG_COUNT
237: ,X_MSG_DATA => X_MSG_DATA
238: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
242: P_API_NAME => L_API_NAME
243: ,P_PKG_NAME => G_PKG_NAME
244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
246: ,X_MSG_COUNT => X_MSG_COUNT
247: ,X_MSG_DATA => X_MSG_DATA
248: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 295: FND_MSG_PUB.initialize;

291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.
293: IF FND_API.to_Boolean( p_init_msg_list )
294: THEN
295: FND_MSG_PUB.initialize;
296: END IF;
297:
298:
299: -- Debug Message

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

296: END IF;
297:
298:
299: -- Debug Message
300: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
301:
302:
303: -- Initialize API return status to SUCCESS
304: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

307: -- API body
308: --
309:
310: -- Debug Message
311: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_mol_Values_To_Ids');
312:
313: -- Convert the values to ids
314: --
315: Convert_mol_Values_To_Ids (

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

348: END IF;
349:
350:
351: -- Debug Message
352: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
353:
354:
355: -- Standard call to get message count and if count is 1, get message info.
356: FND_MSG_PUB.Count_And_Get

Line 356: FND_MSG_PUB.Count_And_Get

352: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
353:
354:
355: -- Standard call to get message count and if count is 1, get message info.
356: FND_MSG_PUB.Count_And_Get
357: ( p_count => x_msg_count,
358: p_data => x_msg_data
359: );
360:

Line 366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

362: WHEN FND_API.G_EXC_ERROR THEN
363: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
364: P_API_NAME => L_API_NAME
365: ,P_PKG_NAME => G_PKG_NAME
366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
367: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
368: ,X_MSG_COUNT => X_MSG_COUNT
369: ,X_MSG_DATA => X_MSG_DATA
370: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 376: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
374: P_API_NAME => L_API_NAME
375: ,P_PKG_NAME => G_PKG_NAME
376: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
377: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
378: ,X_MSG_COUNT => X_MSG_COUNT
379: ,X_MSG_DATA => X_MSG_DATA
380: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 428: FND_MSG_PUB.initialize;

424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.
426: IF FND_API.to_Boolean( p_init_msg_list )
427: THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431:
432: -- Debug Message

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

429: END IF;
430:
431:
432: -- Debug Message
433: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
434:
435:
436: -- Initialize API return status to SUCCESS
437: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

440: -- API body
441: --
442:
443: -- Debug Message
444: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_mol_Values_To_Ids');
445:
446: -- Convert the values to ids
447: --
448: Convert_mol_Values_To_Ids (

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

481: END IF;
482:
483:
484: -- Debug Message
485: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
486:
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get

Line 489: FND_MSG_PUB.Count_And_Get

485: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
486:
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get
490: ( p_count => x_msg_count,
491: p_data => x_msg_data
492: );
493:

Line 499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

495: WHEN FND_API.G_EXC_ERROR THEN
496: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
500: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
501: ,X_MSG_COUNT => X_MSG_COUNT
502: ,X_MSG_DATA => X_MSG_DATA
503: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 509: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
507: P_API_NAME => L_API_NAME
508: ,P_PKG_NAME => G_PKG_NAME
509: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
510: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
511: ,X_MSG_COUNT => X_MSG_COUNT
512: ,X_MSG_DATA => X_MSG_DATA
513: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 569: FND_MSG_PUB.initialize;

565:
566: -- Initialize message list if p_init_msg_list is set to TRUE.
567: IF FND_API.to_Boolean( p_init_msg_list )
568: THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:
572:
573: -- Debug Message

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

570: END IF;
571:
572:
573: -- Debug Message
574: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
575:
576:
577: -- Initialize API return status to SUCCESS
578: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

580: --
581: -- API body
582: --
583: -- Debug Message
584: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_ORDERLINES');
585: /*
586: CSP_orderlines_PVT.Get_orderlines(
587: P_Api_Version_Number => 2.0,
588: P_Init_Msg_List => FND_API.G_FALSE,

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

618: -- End of API body
619: --
620:
621: -- Debug Message
622: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
623:
624:
625: -- Standard call to get message count and if count is 1, get message info.
626: FND_MSG_PUB.Count_And_Get

Line 626: FND_MSG_PUB.Count_And_Get

622: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
623:
624:
625: -- Standard call to get message count and if count is 1, get message info.
626: FND_MSG_PUB.Count_And_Get
627: ( p_count => x_msg_count,
628: p_data => x_msg_data
629: );
630:

Line 636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

632: WHEN FND_API.G_EXC_ERROR THEN
633: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
634: P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
637: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
638: ,X_MSG_COUNT => X_MSG_COUNT
639: ,X_MSG_DATA => X_MSG_DATA
640: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
644: P_API_NAME => L_API_NAME
645: ,P_PKG_NAME => G_PKG_NAME
646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
647: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
648: ,X_MSG_COUNT => X_MSG_COUNT
649: ,X_MSG_DATA => X_MSG_DATA
650: ,X_RETURN_STATUS => X_RETURN_STATUS);