DBA Data[Home] [Help]

APPS.CSP_PACKLIST_HEADERS_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 175: FND_MSG_PUB.initialize;

171:
172: -- Initialize message list if p_init_msg_list is set to TRUE.
173: IF FND_API.to_Boolean( p_init_msg_list )
174: THEN
175: FND_MSG_PUB.initialize;
176: END IF;
177:
178:
179: -- Debug Message

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

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

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

187: -- API body
188: --
189:
190: -- Debug Message
191: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLH_Values_To_Ids');
192:
193: -- Convert the values to ids
194: --
195: Convert_PLH_Values_To_Ids (

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

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

Line 239: FND_MSG_PUB.Count_And_Get

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

Line 249: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 259: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
257: P_API_NAME => L_API_NAME
258: ,P_PKG_NAME => G_PKG_NAME
259: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
260: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
261: ,X_MSG_COUNT => X_MSG_COUNT
262: ,X_MSG_DATA => X_MSG_DATA
263: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 310: FND_MSG_PUB.initialize;

306:
307: -- Initialize message list if p_init_msg_list is set to TRUE.
308: IF FND_API.to_Boolean( p_init_msg_list )
309: THEN
310: FND_MSG_PUB.initialize;
311: END IF;
312:
313:
314: -- Debug Message

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

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

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

322: -- API body
323: --
324:
325: -- Debug Message
326: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLH_Values_To_Ids');
327:
328: -- Convert the values to ids
329: --
330: Convert_PLH_Values_To_Ids (

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

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

Line 371: FND_MSG_PUB.Count_And_Get

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

Line 381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
392: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
393: ,X_MSG_COUNT => X_MSG_COUNT
394: ,X_MSG_DATA => X_MSG_DATA
395: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 443: FND_MSG_PUB.initialize;

439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446:
447: -- Debug Message

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

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

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

455: -- API body
456: --
457:
458: -- Debug Message
459: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLH_Values_To_Ids');
460:
461: -- Convert the values to ids
462: --
463: Convert_PLH_Values_To_Ids (

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

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

Line 504: FND_MSG_PUB.Count_And_Get

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

Line 514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 524: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
522: P_API_NAME => L_API_NAME
523: ,P_PKG_NAME => G_PKG_NAME
524: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
525: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
526: ,X_MSG_COUNT => X_MSG_COUNT
527: ,X_MSG_DATA => X_MSG_DATA
528: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 584: FND_MSG_PUB.initialize;

580:
581: -- Initialize message list if p_init_msg_list is set to TRUE.
582: IF FND_API.to_Boolean( p_init_msg_list )
583: THEN
584: FND_MSG_PUB.initialize;
585: END IF;
586:
587:
588: -- Debug Message

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

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

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

595: --
596: -- API body
597: --
598: -- Debug Message
599: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Packlist_Headers');
600: /*
601: CSP_packlist_headers_PVT.Get_packlist_headers(
602: P_Api_Version_Number => 2.0,
603: P_Init_Msg_List => FND_API.G_FALSE,

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

633: -- End of API body
634: --
635:
636: -- Debug Message
637: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
638:
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get

Line 641: FND_MSG_PUB.Count_And_Get

637: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
638:
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get
642: ( p_count => x_msg_count,
643: p_data => x_msg_data
644: );
645:

Line 651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 661: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
659: P_API_NAME => L_API_NAME
660: ,P_PKG_NAME => G_PKG_NAME
661: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
662: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
663: ,X_MSG_COUNT => X_MSG_COUNT
664: ,X_MSG_DATA => X_MSG_DATA
665: ,X_RETURN_STATUS => X_RETURN_STATUS);