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_ORDERHEADERS_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 171: FND_MSG_PUB.initialize;

167:
168: -- Initialize message list if p_init_msg_list is set to TRUE.
169: IF FND_API.to_Boolean( p_init_msg_list )
170: THEN
171: FND_MSG_PUB.initialize;
172: END IF;
173:
174:
175: -- Debug Message

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

172: END IF;
173:
174:
175: -- Debug Message
176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
177:
178:
179: -- Initialize API return status to SUCCESS
180: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

183: -- API body
184: --
185:
186: -- Debug Message
187: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_MOH_Values_To_Ids');
188:
189: -- Convert the values to ids
190: --
191: Convert_MOH_Values_To_Ids (

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

227: END IF;
228:
229:
230: -- Debug Message
231: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
232:
233:
234: -- Standard call to get message count and if count is 1, get message info.
235: FND_MSG_PUB.Count_And_Get

Line 235: FND_MSG_PUB.Count_And_Get

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

Line 245: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 255: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
253: P_API_NAME => L_API_NAME
254: ,P_PKG_NAME => G_PKG_NAME
255: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
256: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
257: ,X_MSG_COUNT => X_MSG_COUNT
258: ,X_MSG_DATA => X_MSG_DATA
259: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 306: FND_MSG_PUB.initialize;

302:
303: -- Initialize message list if p_init_msg_list is set to TRUE.
304: IF FND_API.to_Boolean( p_init_msg_list )
305: THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:
309:
310: -- Debug Message

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

307: END IF;
308:
309:
310: -- Debug Message
311: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
312:
313:
314: -- Initialize API return status to SUCCESS
315: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

318: -- API body
319: --
320:
321: -- Debug Message
322: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_MOH_Values_To_Ids');
323:
324: -- Convert the values to ids
325: --
326: Convert_MOH_Values_To_Ids (

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

359: END IF;
360:
361:
362: -- Debug Message
363: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
364:
365:
366: -- Standard call to get message count and if count is 1, get message info.
367: FND_MSG_PUB.Count_And_Get

Line 367: FND_MSG_PUB.Count_And_Get

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

Line 377: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 387: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
385: P_API_NAME => L_API_NAME
386: ,P_PKG_NAME => G_PKG_NAME
387: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
388: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
389: ,X_MSG_COUNT => X_MSG_COUNT
390: ,X_MSG_DATA => X_MSG_DATA
391: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 439: FND_MSG_PUB.initialize;

435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list )
438: THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441:
442:
443: -- Debug Message

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

440: END IF;
441:
442:
443: -- Debug Message
444: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
445:
446:
447: -- Initialize API return status to SUCCESS
448: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

451: -- API body
452: --
453:
454: -- Debug Message
455: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_MOH_Values_To_Ids');
456:
457: -- Convert the values to ids
458: --
459: Convert_MOH_Values_To_Ids (

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

492: END IF;
493:
494:
495: -- Debug Message
496: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
497:
498:
499: -- Standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get

Line 500: FND_MSG_PUB.Count_And_Get

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

Line 510: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 520: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
518: P_API_NAME => L_API_NAME
519: ,P_PKG_NAME => G_PKG_NAME
520: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
521: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
522: ,X_MSG_COUNT => X_MSG_COUNT
523: ,X_MSG_DATA => X_MSG_DATA
524: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 580: FND_MSG_PUB.initialize;

576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )
579: THEN
580: FND_MSG_PUB.initialize;
581: END IF;
582:
583:
584: -- Debug Message

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

581: END IF;
582:
583:
584: -- Debug Message
585: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
586:
587:
588: -- Initialize API return status to SUCCESS
589: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

591: --
592: -- API body
593: --
594: -- Debug Message
595: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_ORDERHEADERS');
596: /*
597: CSP_orderheaders_PVT.Get_orderheaders(
598: P_Api_Version_Number => 1.0,
599: P_Init_Msg_List => FND_API.G_FALSE,

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

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

Line 634: FND_MSG_PUB.Count_And_Get

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

Line 644: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 654: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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