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_TASK_PART_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 169: FND_MSG_PUB.initialize;

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

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

170: END IF;
171:
172:
173: -- Debug Message
174: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'start');
175:
176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
177:
178: -- Initialize API return status to SUCCESS

Line 176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

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

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

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

275: END IF;
276:
277:
278: -- Debug Message
279: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'end');
280:
281: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
282:
283: -- Standard call to get message count and if count is 1, get message info.

Line 281: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

277:
278: -- Debug Message
279: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'end');
280:
281: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
282:
283: -- Standard call to get message count and if count is 1, get message info.
284: FND_MSG_PUB.Count_And_Get
285: ( p_count => x_msg_count,

Line 284: FND_MSG_PUB.Count_And_Get

280:
281: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
282:
283: -- Standard call to get message count and if count is 1, get message info.
284: FND_MSG_PUB.Count_And_Get
285: ( p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288:

Line 343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

339: WHEN FND_API.G_EXC_ERROR THEN
340: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
344: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
345: ,X_MSG_COUNT => X_MSG_COUNT
346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
355: ,X_MSG_COUNT => X_MSG_COUNT
356: ,X_MSG_DATA => X_MSG_DATA
357: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 406: FND_MSG_PUB.initialize;

402:
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: IF FND_API.to_Boolean( p_init_msg_list )
405: THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:
409:
410: -- Debug Message

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

407: END IF;
408:
409:
410: -- Debug Message
411: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'start');
412:
413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
414:
415: -- Initialize API return status to SUCCESS

Line 413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

409:
410: -- Debug Message
411: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'start');
412:
413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
414:
415: -- Initialize API return status to SUCCESS
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417:

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

419: -- API body
420: --
421:
422: -- Debug Message
423: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','AS: Public API: Convert_TASK_PART_Values_To_Ids');
424:
425: -- Convert the values to ids
426: --
427: /* Convert_TASK_PART_Values_To_Ids (

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

508: END IF;
509:
510:
511: -- Debug Message
512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'end');
513:
514: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
515:
516: -- Standard call to get message count and if count is 1, get message info.

Line 514: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

510:
511: -- Debug Message
512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'end');
513:
514: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get
518: ( p_count => x_msg_count,

Line 517: FND_MSG_PUB.Count_And_Get

513:
514: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get
518: ( p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:

Line 576: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

572: WHEN FND_API.G_EXC_ERROR THEN
573: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
574: P_API_NAME => L_API_NAME
575: ,P_PKG_NAME => G_PKG_NAME
576: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
577: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
578: ,X_MSG_COUNT => X_MSG_COUNT
579: ,X_MSG_DATA => X_MSG_DATA
580: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 586: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
588: ,X_MSG_COUNT => X_MSG_COUNT
589: ,X_MSG_DATA => X_MSG_DATA
590: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 640: FND_MSG_PUB.initialize;

636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean( p_init_msg_list )
639: THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:
643:
644: -- Debug Message

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

641: END IF;
642:
643:
644: -- Debug Message
645: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'start');
646:
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648:
649: -- Initialize API return status to SUCCESS

Line 647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

643:
644: -- Debug Message
645: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'start');
646:
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648:
649: -- Initialize API return status to SUCCESS
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:

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

653: -- API body
654: --
655:
656: -- Debug Message
657: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','AS: Public API: Convert_TASK_PART_Values_To_Ids');
658:
659: -- Convert the values to ids
660: --
661: /* Convert_TASK_PART_Values_To_Ids (

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

742: END IF;
743:
744:
745: -- Debug Message
746: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
747:
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
749:
750: -- Standard call to get message count and if count is 1, get message info.

Line 748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

744:
745: -- Debug Message
746: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
747:
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
749:
750: -- Standard call to get message count and if count is 1, get message info.
751: FND_MSG_PUB.Count_And_Get
752: ( p_count => x_msg_count,

Line 751: FND_MSG_PUB.Count_And_Get

747:
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
749:
750: -- Standard call to get message count and if count is 1, get message info.
751: FND_MSG_PUB.Count_And_Get
752: ( p_count => x_msg_count,
753: p_data => x_msg_data
754: );
755:

Line 810: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

806: WHEN FND_API.G_EXC_ERROR THEN
807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
808: P_API_NAME => L_API_NAME
809: ,P_PKG_NAME => G_PKG_NAME
810: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
812: ,X_MSG_COUNT => X_MSG_COUNT
813: ,X_MSG_DATA => X_MSG_DATA
814: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 820: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
818: P_API_NAME => L_API_NAME
819: ,P_PKG_NAME => G_PKG_NAME
820: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
821: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
822: ,X_MSG_COUNT => X_MSG_COUNT
823: ,X_MSG_DATA => X_MSG_DATA
824: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 882: FND_MSG_PUB.initialize;

878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean( p_init_msg_list )
881: THEN
882: FND_MSG_PUB.initialize;
883: END IF;
884:
885:
886: -- Debug Message

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

883: END IF;
884:
885:
886: -- Debug Message
887: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'start');
888:
889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
890:
891: -- Initialize API return status to SUCCESS

Line 889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

885:
886: -- Debug Message
887: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'start');
888:
889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
890:
891: -- Initialize API return status to SUCCESS
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:

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

894: --
895: -- API body
896: --
897: -- Debug Message
898: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: - Calling PVT.Get_TASK_PART');
899: /*
900: CSP_task_part_PVT.Get_task_part(
901: P_Api_Version_Number => 1.0,
902: P_Init_Msg_List => FND_API.G_FALSE,

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

931: -- End of API body
932: --
933:
934: -- Debug Message
935: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
936:
937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
938:
939: -- Standard call to get message count and if count is 1, get message info.

Line 937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

933:
934: -- Debug Message
935: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
936:
937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
938:
939: -- Standard call to get message count and if count is 1, get message info.
940: FND_MSG_PUB.Count_And_Get
941: ( p_count => x_msg_count,

Line 940: FND_MSG_PUB.Count_And_Get

936:
937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
938:
939: -- Standard call to get message count and if count is 1, get message info.
940: FND_MSG_PUB.Count_And_Get
941: ( p_count => x_msg_count,
942: p_data => x_msg_data
943: );
944:

Line 950: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

946: WHEN FND_API.G_EXC_ERROR THEN
947: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
948: P_API_NAME => L_API_NAME
949: ,P_PKG_NAME => G_PKG_NAME
950: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
951: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
952: ,X_MSG_COUNT => X_MSG_COUNT
953: ,X_MSG_DATA => X_MSG_DATA
954: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 960: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
958: P_API_NAME => L_API_NAME
959: ,P_PKG_NAME => G_PKG_NAME
960: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
961: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
962: ,X_MSG_COUNT => X_MSG_COUNT
963: ,X_MSG_DATA => X_MSG_DATA
964: ,X_RETURN_STATUS => X_RETURN_STATUS);