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;
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
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
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
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
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;
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 (
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
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:
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);
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);
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
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;
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 (
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
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:
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);
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);
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
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;
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 (
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
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:
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);
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);
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
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;
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,
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
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:
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);
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);