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_PVT dependencies on JTF_PLSQL_API

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

43: THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46: -- Debug Message
47: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'start');
48: -- Initialize API return status to SUCCESS
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: --
51: -- API body

Line 67: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Validate_task_part');

63: END IF;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: -- Debug message
67: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Validate_task_part');
68: -- Invoke validation procedures
69: Validate_task_part(
70: p_init_msg_list => FND_API.G_FALSE,
71: p_validation_level => p_validation_level,

Line 72: p_validation_mode => JTF_PLSQL_API.G_CREATE,

68: -- Invoke validation procedures
69: Validate_task_part(
70: p_init_msg_list => FND_API.G_FALSE,
71: p_validation_level => p_validation_level,
72: p_validation_mode => JTF_PLSQL_API.G_CREATE,
73: P_TASK_PART_Rec => P_TASK_PART_Rec,
74: x_return_status => x_return_status,
75: x_msg_count => x_msg_count,
76: x_msg_data => x_msg_data);

Line 101: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

97: -- ,x_msg_count => x_msg_count
98: -- ,x_msg_data => x_msg_data
99: -- ,x_access_flag => l_access_flag);
100: -- IF l_access_flag <> 'Y' THEN
101: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
102: -- 'API_NO_CREATE_PRIVILEGE');
103: -- END IF;
104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
105: RAISE FND_API.G_EXC_ERROR;

Line 111: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling create table handler');

107: END IF;
108: */
109: -- Hint: Add corresponding Master-Detail business logic here if necessary.
110: -- Debug Message
111: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling create table handler');
112: -- Invoke table handler(CSP_TASK_PARTS_PKG.Insert_Row)
113: CSP_TASK_PARTS_PKG.Insert_Row(
114: px_TASK_PART_ID => x_TASK_PART_ID,
115: p_PRODUCT_TASK_ID => p_TASK_PART_rec.PRODUCT_TASK_ID,

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

159: THEN
160: COMMIT WORK;
161: END IF;
162: -- Debug Message
163: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'end');
164: -- Standard call to get message count and if count is 1, get message info.
165: FND_MSG_PUB.Count_And_Get
166: ( p_count => x_msg_count,
167: p_data => x_msg_data

Line 171: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

167: p_data => x_msg_data
168: );
169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
172: P_API_NAME => L_API_NAME
173: ,P_PKG_NAME => G_PKG_NAME
174: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
175: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 175: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

171: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
172: P_API_NAME => L_API_NAME
173: ,P_PKG_NAME => G_PKG_NAME
174: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
175: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
176: ,X_MSG_COUNT => X_MSG_COUNT
177: ,X_MSG_DATA => X_MSG_DATA
178: ,X_RETURN_STATUS => X_RETURN_STATUS);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 180: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

176: ,X_MSG_COUNT => X_MSG_COUNT
177: ,X_MSG_DATA => X_MSG_DATA
178: ,X_RETURN_STATUS => X_RETURN_STATUS);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
181: P_API_NAME => L_API_NAME
182: ,P_PKG_NAME => G_PKG_NAME
183: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
184: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 184: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

180: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
181: P_API_NAME => L_API_NAME
182: ,P_PKG_NAME => G_PKG_NAME
183: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
184: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
185: ,X_MSG_COUNT => X_MSG_COUNT
186: ,X_MSG_DATA => X_MSG_DATA
187: ,X_RETURN_STATUS => X_RETURN_STATUS);
188: WHEN OTHERS THEN

Line 189: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

185: ,X_MSG_COUNT => X_MSG_COUNT
186: ,X_MSG_DATA => X_MSG_DATA
187: ,X_RETURN_STATUS => X_RETURN_STATUS);
188: WHEN OTHERS THEN
189: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
190: P_API_NAME => L_API_NAME
191: ,P_PKG_NAME => G_PKG_NAME
192: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
193: ,P_SQLCODE => SQLCODE

Line 192: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

188: WHEN OTHERS THEN
189: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
190: P_API_NAME => L_API_NAME
191: ,P_PKG_NAME => G_PKG_NAME
192: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
193: ,P_SQLCODE => SQLCODE
194: ,P_SQLERRM => SQLERRM
195: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
196: ,X_MSG_COUNT => X_MSG_COUNT

Line 195: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

191: ,P_PKG_NAME => G_PKG_NAME
192: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
193: ,P_SQLCODE => SQLCODE
194: ,P_SQLERRM => SQLERRM
195: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
196: ,X_MSG_COUNT => X_MSG_COUNT
197: ,X_MSG_DATA => X_MSG_DATA
198: ,X_RETURN_STATUS => X_RETURN_STATUS);
199: End Create_task_part;

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

273: THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276: -- Debug Message
277: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'start');
278: -- Initialize API return status to SUCCESS
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: --
281: -- Api body

Line 284: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: - Open Cursor to Select');

280: --
281: -- Api body
282: --
283: -- Debug Message
284: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: - Open Cursor to Select');
285: /*
286: Open C_Get_task_part( l_tar_TASK_PART_rec.TASK_PART_ID);
287: Fetch C_Get_task_part into
288: l_rowid,

Line 334: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: - Close Cursor');

330: Close C_Get_task_part;
331: raise FND_API.G_EXC_ERROR;
332: END IF;
333: -- Debug Message
334: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: - Close Cursor');
335: Close C_Get_task_part;
336: If (l_tar_TASK_PART_rec.last_update_date is NULL or
337: l_tar_TASK_PART_rec.last_update_date = FND_API.G_MISS_Date ) Then
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 358: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Validate_task_part');

354: raise FND_API.G_EXC_ERROR;
355: End if;
356: */
357: -- Debug message
358: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Validate_task_part');
359: -- Invoke validation procedures
360: Validate_task_part(
361: p_init_msg_list => FND_API.G_FALSE,
362: p_validation_level => p_validation_level,

Line 363: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

359: -- Invoke validation procedures
360: Validate_task_part(
361: p_init_msg_list => FND_API.G_FALSE,
362: p_validation_level => p_validation_level,
363: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
364: P_TASK_PART_Rec => P_TASK_PART_Rec,
365: x_return_status => x_return_status,
366: x_msg_count => x_msg_count,
367: x_msg_data => x_msg_data);

Line 392: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

388: -- ,x_msg_count => x_msg_count
389: -- ,x_msg_data => x_msg_data
390: -- ,x_access_flag => l_access_flag);
391: -- IF l_access_flag <> 'Y' THEN
392: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
393: -- 'API_NO_UPDATE_PRIVILEGE');
394: -- END IF;
395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
396: RAISE FND_API.G_EXC_ERROR;

Line 402: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling update table handler');

398: END IF;
399: */
400: -- Hint: Add corresponding Master-Detail business logic here if necessary.
401: -- Debug Message
402: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling update table handler');
403: -- Invoke table handler(CSP_TASK_PARTS_PKG.Update_Row)
404: CSP_TASK_PARTS_PKG.Update_Row(
405: p_TASK_PART_ID => p_TASK_PART_rec.TASK_PART_ID,
406: p_PRODUCT_TASK_ID => p_TASK_PART_rec.PRODUCT_TASK_ID,

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

446: THEN
447: COMMIT WORK;
448: END IF;
449: -- Debug Message
450: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'end');
451: -- Standard call to get message count and if count is 1, get message info.
452: FND_MSG_PUB.Count_And_Get
453: ( p_count => x_msg_count,
454: p_data => x_msg_data

Line 458: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

454: p_data => x_msg_data
455: );
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
459: P_API_NAME => L_API_NAME
460: ,P_PKG_NAME => G_PKG_NAME
461: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
462: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 462: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

458: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
459: P_API_NAME => L_API_NAME
460: ,P_PKG_NAME => G_PKG_NAME
461: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
462: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
463: ,X_MSG_COUNT => X_MSG_COUNT
464: ,X_MSG_DATA => X_MSG_DATA
465: ,X_RETURN_STATUS => X_RETURN_STATUS);
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 467: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

463: ,X_MSG_COUNT => X_MSG_COUNT
464: ,X_MSG_DATA => X_MSG_DATA
465: ,X_RETURN_STATUS => X_RETURN_STATUS);
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
468: P_API_NAME => L_API_NAME
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
471: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 471: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

467: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
468: P_API_NAME => L_API_NAME
469: ,P_PKG_NAME => G_PKG_NAME
470: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
471: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
472: ,X_MSG_COUNT => X_MSG_COUNT
473: ,X_MSG_DATA => X_MSG_DATA
474: ,X_RETURN_STATUS => X_RETURN_STATUS);
475: WHEN OTHERS THEN

Line 476: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

472: ,X_MSG_COUNT => X_MSG_COUNT
473: ,X_MSG_DATA => X_MSG_DATA
474: ,X_RETURN_STATUS => X_RETURN_STATUS);
475: WHEN OTHERS THEN
476: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
477: P_API_NAME => L_API_NAME
478: ,P_PKG_NAME => G_PKG_NAME
479: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
480: ,P_SQLCODE => SQLCODE

Line 479: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

475: WHEN OTHERS THEN
476: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
477: P_API_NAME => L_API_NAME
478: ,P_PKG_NAME => G_PKG_NAME
479: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
480: ,P_SQLCODE => SQLCODE
481: ,P_SQLERRM => SQLERRM
482: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
483: ,X_MSG_COUNT => X_MSG_COUNT

Line 482: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

478: ,P_PKG_NAME => G_PKG_NAME
479: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
480: ,P_SQLCODE => SQLCODE
481: ,P_SQLERRM => SQLERRM
482: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
483: ,X_MSG_COUNT => X_MSG_COUNT
484: ,X_MSG_DATA => X_MSG_DATA
485: ,X_RETURN_STATUS => X_RETURN_STATUS);
486: End Update_task_part;

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

516: THEN
517: FND_MSG_PUB.initialize;
518: END IF;
519: -- Debug Message
520: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'start');
521: -- Initialize API return status to SUCCESS
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: --
524: -- Api body

Line 547: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

543: -- ,x_msg_count => x_msg_count
544: -- ,x_msg_data => x_msg_data
545: -- ,x_access_flag => l_access_flag);
546: -- IF l_access_flag <> 'Y' THEN
547: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
548: -- 'API_NO_DELETE_PRIVILEGE');
549: -- END IF;
550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
551: RAISE FND_API.G_EXC_ERROR;

Line 556: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling delete table handler');

552: END IF;
553: END IF;
554: */
555: -- Debug Message
556: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling delete table handler');
557: -- Invoke table handler(CSP_TASK_PARTS_PKG.Delete_Row)
558: CSP_TASK_PARTS_PKG.Delete_Row(
559: p_TASK_PART_ID => p_TASK_PART_rec.TASK_PART_ID);
560: --

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

565: THEN
566: COMMIT WORK;
567: END IF;
568: -- Debug Message
569: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'end');
570: -- Standard call to get message count and if count is 1, get message info.
571: FND_MSG_PUB.Count_And_Get
572: ( p_count => x_msg_count,
573: p_data => x_msg_data

Line 577: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

573: p_data => x_msg_data
574: );
575: EXCEPTION
576: WHEN FND_API.G_EXC_ERROR THEN
577: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
578: P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
581: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 581: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

577: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
578: P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
581: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
582: ,X_MSG_COUNT => X_MSG_COUNT
583: ,X_MSG_DATA => X_MSG_DATA
584: ,X_RETURN_STATUS => X_RETURN_STATUS);
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 586: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 590: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

586: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
587: P_API_NAME => L_API_NAME
588: ,P_PKG_NAME => G_PKG_NAME
589: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
590: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
591: ,X_MSG_COUNT => X_MSG_COUNT
592: ,X_MSG_DATA => X_MSG_DATA
593: ,X_RETURN_STATUS => X_RETURN_STATUS);
594: WHEN OTHERS THEN

Line 595: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

591: ,X_MSG_COUNT => X_MSG_COUNT
592: ,X_MSG_DATA => X_MSG_DATA
593: ,X_RETURN_STATUS => X_RETURN_STATUS);
594: WHEN OTHERS THEN
595: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
596: P_API_NAME => L_API_NAME
597: ,P_PKG_NAME => G_PKG_NAME
598: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
599: ,P_SQLCODE => SQLCODE

Line 598: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

594: WHEN OTHERS THEN
595: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
596: P_API_NAME => L_API_NAME
597: ,P_PKG_NAME => G_PKG_NAME
598: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
599: ,P_SQLCODE => SQLCODE
600: ,P_SQLERRM => SQLERRM
601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
602: ,X_MSG_COUNT => X_MSG_COUNT

Line 601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

597: ,P_PKG_NAME => G_PKG_NAME
598: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
599: ,P_SQLCODE => SQLCODE
600: ,P_SQLERRM => SQLERRM
601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
602: ,X_MSG_COUNT => X_MSG_COUNT
603: ,X_MSG_DATA => X_MSG_DATA
604: ,X_RETURN_STATUS => X_RETURN_STATUS);
605: End Delete_task_part;

Line 614: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Begins');

610: )
611: IS
612: BEGIN
613: -- Debug Message
614: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Begins');
615: -- define all columns for CSP_TASK_PARTS view
616: dbms_sql.define_column(p_cur_get_TASK_PART, 1, P_TASK_PART_Rec.TASK_PART_ID);
617: dbms_sql.define_column(p_cur_get_TASK_PART, 2, P_TASK_PART_Rec.PRODUCT_TASK_ID);
618: dbms_sql.define_column(p_cur_get_TASK_PART, 3, P_TASK_PART_Rec.INVENTORY_ITEM_ID);

Line 647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Ends');

643: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_QUANTITY_USED);
644: dbms_sql.define_column(p_cur_get_TASK_PART, 29, P_TASK_PART_Rec.ROLLUP_TIMES_USED);
645: dbms_sql.define_column(p_cur_get_TASK_PART, 30, p_TASK_PART_Rec.SUBSTITUTE_ITEM );
646: -- Debug Message
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Define Columns Ends');
648: END Define_Columns;
649: -- This procudure gets column values by the Dynamic SQL.
650: PROCEDURE Get_Column_Values(
651: p_cur_get_TASK_PART IN NUMBER,

Line 657: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Begins');

653: )
654: IS
655: BEGIN
656: -- Debug Message
657: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Begins');
658: -- get all column values for CSP_TASK_PARTS table
659: dbms_sql.column_value(p_cur_get_TASK_PART, 1, X_TASK_PART_Rec.TASK_PART_ID);
660: dbms_sql.column_value(p_cur_get_TASK_PART, 2, X_TASK_PART_Rec.PRODUCT_TASK_ID);
661: dbms_sql.column_value(p_cur_get_TASK_PART, 3, X_TASK_PART_Rec.INVENTORY_ITEM_ID);

Line 691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Ends');

687: dbms_sql.column_value(p_cur_get_TASK_PART, 29, X_TASK_PART_Rec.ROLLUP_TIMES_USED);
688: dbms_sql.column_value(p_cur_get_TASK_PART, 30, X_TASK_PART_Rec.SUBSTITUTE_ITEM );
689:
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Get Column Values Ends');
692: END Get_Column_Values;
693: PROCEDURE Gen_TASK_PART_order_cl(
694: p_order_by_rec IN CSP_TASK_PART_PUB.TASK_PART_sort_rec_type,
695: x_order_by_cl OUT NOCOPY VARCHAR2,

Line 702: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

698: x_msg_data OUT NOCOPY VARCHAR2
699: )
700: IS
701: l_order_by_cl VARCHAR2(1000) := NULL;
702: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
703: BEGIN
704: -- Debug Message
705: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Generate Order by Begins');
706: -- Hint: Developer should add more statements according to CSP_sort_rec_type

Line 705: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Generate Order by Begins');

701: l_order_by_cl VARCHAR2(1000) := NULL;
702: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
703: BEGIN
704: -- Debug Message
705: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Generate Order by Begins');
706: -- Hint: Developer should add more statements according to CSP_sort_rec_type
707: -- Ex:
708: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
709: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';

Line 711: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Invoke JTF_PLSQL_API.Translate_OrderBy');

707: -- Ex:
708: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
709: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
710: -- Debug Message
711: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Invoke JTF_PLSQL_API.Translate_OrderBy');
712: JTF_PLSQL_API.Translate_OrderBy(
713: p_api_version_number => 1.0
714: ,p_init_msg_list => FND_API.G_FALSE
715: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 712: JTF_PLSQL_API.Translate_OrderBy(

708: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
709: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
710: -- Debug Message
711: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Invoke JTF_PLSQL_API.Translate_OrderBy');
712: JTF_PLSQL_API.Translate_OrderBy(
713: p_api_version_number => 1.0
714: ,p_init_msg_list => FND_API.G_FALSE
715: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
716: ,p_order_by_tbl => l_util_order_by_tbl

Line 727: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Generate Order by Ends');

723: ELSE
724: x_order_by_cl := NULL;
725: END IF;
726: -- Debug Message
727: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Generate Order by Ends');
728: END Gen_TASK_PART_order_cl;
729: -- This procedure bind the variables for the Dynamic SQL
730: PROCEDURE Bind(
731: P_TASK_PART_Rec IN CSP_TASK_PART_PUB.TASK_PART_Rec_Type,

Line 740: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Bind Variables Begins');

736: BEGIN
737: -- Bind variables
738: -- Only those that are not NULL
739: -- Debug Message
740: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Bind Variables Begins');
741: -- The following example applies to all columns,
742: -- developers can copy and paste them.
743: IF( (P_TASK_PART_Rec.TASK_PART_ID IS NOT NULL) AND (P_TASK_PART_Rec.TASK_PART_ID <> FND_API.G_MISS_NUM) )
744: THEN

Line 748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Bind Variables Ends');

744: THEN
745: DBMS_SQL.BIND_VARIABLE(p_cur_get_TASK_PART, ':p_TASK_PART_ID', P_TASK_PART_Rec.TASK_PART_ID);
746: END IF;
747: -- Debug Message
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: Bind Variables Ends');
749: END Bind;
750: PROCEDURE Gen_Select(
751: x_select_cl OUT NOCOPY VARCHAR2
752: )

Line 756: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Select Begins');

752: )
753: IS
754: BEGIN
755: -- Debug Message
756: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Select Begins');
757: x_select_cl := 'Select ' ||
758: 'CSP_TASK_PARTS.TASK_PART_ID,' ||
759: 'CSP_TASK_PARTS.PRODUCT_TASK_ID,' ||
760: 'CSP_TASK_PARTS.INVENTORY_ITEM_ID,' ||

Line 792: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Select Ends');

788: 'CSP_TASK_PARTS.START_DATE,' ||
789: 'CSP_TASK_PARTS.END_DATE,' ||
790: 'from CSP_TASK_PARTS';
791: -- Debug Message
792: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Select Ends');
793: END Gen_Select;
794: PROCEDURE Gen_TASK_PART_Where(
795: P_TASK_PART_Rec IN CSP_TASK_PART_PUB.TASK_PART_Rec_Type,
796: x_TASK_PART_where OUT NOCOPY VARCHAR2

Line 813: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Where Begins');

809: str_csr2 NUMBER;
810: l_operator VARCHAR2(10);
811: BEGIN
812: -- Debug Message
813: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Where Begins');
814: -- There are three examples for each kind of datatype:
815: -- NUMBER, DATE, VARCHAR2.
816: -- Developer can copy and paste the following codes for your own record.
817: -- example for NUMBER datatype

Line 885: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Where Ends');

881: x_TASK_PART_where := x_TASK_PART_where || 'P_TASK_PART_Rec.ATTRIBUTE_CATEGORY ' || l_operator || ' :p_ATTRIBUTE_CATEGORY';
882: END IF;
883: -- Add more IF statements for each column below
884: -- Debug Message
885: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Where Ends');
886: END Gen_TASK_PART_Where;
887:
888: -- Item-level validation procedures
889: PROCEDURE Validate_TASK_PART_ID (

Line 893: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

889: PROCEDURE Validate_TASK_PART_ID (
890: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
891: P_Validation_mode IN VARCHAR2,
892: P_TASK_PART_ID IN NUMBER,
893: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
894: X_Return_Status OUT NOCOPY VARCHAR2,
895: X_Msg_Count OUT NOCOPY NUMBER,
896: X_Msg_Data OUT NOCOPY VARCHAR2
897: )

Line 910: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(TASK_PART_ID)');

906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907: -- validate NOT NULL column
908: IF(p_TASK_PART_ID is NULL)
909: THEN
910: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(TASK_PART_ID)');
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: END IF;
913: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
914: THEN

Line 913: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

909: THEN
910: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(TASK_PART_ID)');
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: END IF;
913: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
914: THEN
915: -- Hint: Validate data
916: -- IF p_TASK_PART_ID is not NULL and p_TASK_PART_ID <> G_MISS_CHAR
917: -- verify if data is valid

Line 920: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

916: -- IF p_TASK_PART_ID is not NULL and p_TASK_PART_ID <> G_MISS_CHAR
917: -- verify if data is valid
918: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
919: NULL;
920: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
921: THEN
922: -- Hint: Validate data
923: -- IF p_TASK_PART_ID <> G_MISS_CHAR
924: -- verify if data is valid

Line 938: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

934: PROCEDURE Validate_PRODUCT_TASK_ID (
935: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
936: P_Validation_mode IN VARCHAR2,
937: P_PRODUCT_TASK_ID IN NUMBER,
938: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
939: X_Return_Status OUT NOCOPY VARCHAR2,
940: X_Msg_Count OUT NOCOPY NUMBER,
941: X_Msg_Data OUT NOCOPY VARCHAR2
942: )

Line 955: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(PRODUCT_TASK_ID)');

951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952: -- validate NOT NULL column
953: IF(p_PRODUCT_TASK_ID is NULL)
954: THEN
955: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(PRODUCT_TASK_ID)');
956: x_return_status := FND_API.G_RET_STS_ERROR;
957: END IF;
958: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
959: THEN

Line 958: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

954: THEN
955: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(PRODUCT_TASK_ID)');
956: x_return_status := FND_API.G_RET_STS_ERROR;
957: END IF;
958: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
959: THEN
960: -- Hint: Validate data
961: -- IF p_PRODUCT_TASK_ID is not NULL and p_PRODUCT_TASK_ID <> G_MISS_CHAR
962: -- verify if data is valid

Line 965: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

961: -- IF p_PRODUCT_TASK_ID is not NULL and p_PRODUCT_TASK_ID <> G_MISS_CHAR
962: -- verify if data is valid
963: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
964: NULL;
965: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
966: THEN
967: -- Hint: Validate data
968: -- IF p_PRODUCT_TASK_ID <> G_MISS_CHAR
969: -- verify if data is valid

Line 983: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

979: PROCEDURE Validate_INVENTORY_ITEM_ID (
980: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
981: P_Validation_mode IN VARCHAR2,
982: P_INVENTORY_ITEM_ID IN NUMBER,
983: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
984: X_Return_Status OUT NOCOPY VARCHAR2,
985: X_Msg_Count OUT NOCOPY NUMBER,
986: X_Msg_Data OUT NOCOPY VARCHAR2
987: )

Line 1000: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');

996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997: -- validate NOT NULL column
998: IF(p_INVENTORY_ITEM_ID is NULL)
999: THEN
1000: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: END IF;
1003: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1004: THEN

Line 1003: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

999: THEN
1000: JTF_PLSQL_API.Debug_Message('ERROR','CSP', 'Private task_part API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: END IF;
1003: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1004: THEN
1005: -- Hint: Validate data
1006: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1007: -- verify if data is valid

Line 1010: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1006: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1007: -- verify if data is valid
1008: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1009: NULL;
1010: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1011: THEN
1012: -- Hint: Validate data
1013: -- IF p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1014: -- verify if data is valid

Line 1028: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1024: PROCEDURE Validate_MANUAL_QUANTITY (
1025: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1026: P_Validation_mode IN VARCHAR2,
1027: P_MANUAL_QUANTITY IN NUMBER,
1028: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1029: X_Return_Status OUT NOCOPY VARCHAR2,
1030: X_Msg_Count OUT NOCOPY NUMBER,
1031: X_Msg_Data OUT NOCOPY VARCHAR2
1032: )

Line 1042: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1038: FND_MSG_PUB.initialize;
1039: END IF;
1040: -- Initialize API return status to SUCCESS
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;
1042: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1043: THEN
1044: -- Hint: Validate data
1045: -- IF p_MANUAL_QUANTITY is not NULL and p_MANUAL_QUANTITY <> G_MISS_CHAR
1046: -- verify if data is valid

Line 1049: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1045: -- IF p_MANUAL_QUANTITY is not NULL and p_MANUAL_QUANTITY <> G_MISS_CHAR
1046: -- verify if data is valid
1047: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1048: NULL;
1049: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1050: THEN
1051: -- Hint: Validate data
1052: -- IF p_MANUAL_QUANTITY <> G_MISS_CHAR
1053: -- verify if data is valid

Line 1067: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1063: PROCEDURE Validate_MANUAL_PERCENTAGE (
1064: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1065: P_Validation_mode IN VARCHAR2,
1066: P_MANUAL_PERCENTAGE IN NUMBER,
1067: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1068: X_Return_Status OUT NOCOPY VARCHAR2,
1069: X_Msg_Count OUT NOCOPY NUMBER,
1070: X_Msg_Data OUT NOCOPY VARCHAR2
1071: )

Line 1081: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1077: FND_MSG_PUB.initialize;
1078: END IF;
1079: -- Initialize API return status to SUCCESS
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1082: THEN
1083: -- Hint: Validate data
1084: -- IF p_MANUAL_PERCENTAGE is not NULL and p_MANUAL_PERCENTAGE <> G_MISS_CHAR
1085: -- verify if data is valid

Line 1088: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1084: -- IF p_MANUAL_PERCENTAGE is not NULL and p_MANUAL_PERCENTAGE <> G_MISS_CHAR
1085: -- verify if data is valid
1086: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1087: NULL;
1088: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1089: THEN
1090: -- Hint: Validate data
1091: -- IF p_MANUAL_PERCENTAGE <> G_MISS_CHAR
1092: -- verify if data is valid

Line 1106: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1102: PROCEDURE Validate_QUANTITY_USED (
1103: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1104: P_Validation_mode IN VARCHAR2,
1105: P_QUANTITY_USED IN NUMBER,
1106: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1107: X_Return_Status OUT NOCOPY VARCHAR2,
1108: X_Msg_Count OUT NOCOPY NUMBER,
1109: X_Msg_Data OUT NOCOPY VARCHAR2
1110: )

Line 1120: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1116: FND_MSG_PUB.initialize;
1117: END IF;
1118: -- Initialize API return status to SUCCESS
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1121: THEN
1122: -- Hint: Validate data
1123: -- IF p_QUANTITY_USED is not NULL and p_QUANTITY_USED <> G_MISS_CHAR
1124: -- verify if data is valid

Line 1127: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1123: -- IF p_QUANTITY_USED is not NULL and p_QUANTITY_USED <> G_MISS_CHAR
1124: -- verify if data is valid
1125: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1126: NULL;
1127: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1128: THEN
1129: -- Hint: Validate data
1130: -- IF p_QUANTITY_USED <> G_MISS_CHAR
1131: -- verify if data is valid

Line 1145: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1141: PROCEDURE Validate_ACTUAL_TIMES_USED (
1142: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1143: P_Validation_mode IN VARCHAR2,
1144: P_ACTUAL_TIMES_USED IN NUMBER,
1145: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1146: X_Return_Status OUT NOCOPY VARCHAR2,
1147: X_Msg_Count OUT NOCOPY NUMBER,
1148: X_Msg_Data OUT NOCOPY VARCHAR2
1149: )

Line 1159: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1155: FND_MSG_PUB.initialize;
1156: END IF;
1157: -- Initialize API return status to SUCCESS
1158: x_return_status := FND_API.G_RET_STS_SUCCESS;
1159: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1160: THEN
1161: -- Hint: Validate data
1162: -- IF p_ACTUAL_TIMES_USED is not NULL and p_ACTUAL_TIMES_USED <> G_MISS_CHAR
1163: -- verify if data is valid

Line 1166: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1162: -- IF p_ACTUAL_TIMES_USED is not NULL and p_ACTUAL_TIMES_USED <> G_MISS_CHAR
1163: -- verify if data is valid
1164: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1165: NULL;
1166: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1167: THEN
1168: -- Hint: Validate data
1169: -- IF p_ACTUAL_TIMES_USED <> G_MISS_CHAR
1170: -- verify if data is valid

Line 1185: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1181: PROCEDURE Validate_PRIMARY_UOM_CODE (
1182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1183: P_Validation_mode IN VARCHAR2,
1184: P_PRIMARY_UOM_CODE IN VARCHAR2,
1185: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1186: X_Return_Status OUT NOCOPY VARCHAR2,
1187: X_Msg_Count OUT NOCOPY NUMBER,
1188: X_Msg_Data OUT NOCOPY VARCHAR2
1189: )

Line 1199: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1195: FND_MSG_PUB.initialize;
1196: END IF;
1197: -- Initialize API return status to SUCCESS
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1200: THEN
1201: -- Hint: Validate data
1202: -- IF p_PRIMARY_UOM_CODE is not NULL and p_PRIMARY_UOM_CODE <> G_MISS_CHAR
1203: -- verify if data is valid

Line 1206: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1202: -- IF p_PRIMARY_UOM_CODE is not NULL and p_PRIMARY_UOM_CODE <> G_MISS_CHAR
1203: -- verify if data is valid
1204: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1205: NULL;
1206: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1207: THEN
1208: -- Hint: Validate data
1209: -- IF p_PRIMARY_UOM_CODE <> G_MISS_CHAR
1210: -- verify if data is valid

Line 1224: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1220: PROCEDURE Validate_REVISION (
1221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1222: P_Validation_mode IN VARCHAR2,
1223: P_REVISION IN VARCHAR2,
1224: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1225: X_Return_Status OUT NOCOPY VARCHAR2,
1226: X_Msg_Count OUT NOCOPY NUMBER,
1227: X_Msg_Data OUT NOCOPY VARCHAR2
1228: )

Line 1238: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1234: FND_MSG_PUB.initialize;
1235: END IF;
1236: -- Initialize API return status to SUCCESS
1237: x_return_status := FND_API.G_RET_STS_SUCCESS;
1238: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1239: THEN
1240: -- Hint: Validate data
1241: -- IF p_REVISION is not NULL and p_REVISION <> G_MISS_CHAR
1242: -- verify if data is valid

Line 1245: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1241: -- IF p_REVISION is not NULL and p_REVISION <> G_MISS_CHAR
1242: -- verify if data is valid
1243: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1244: NULL;
1245: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1246: THEN
1247: -- Hint: Validate data
1248: -- IF p_REVISION <> G_MISS_CHAR
1249: -- verify if data is valid

Line 1263: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1259: PROCEDURE Validate_START_DATE (
1260: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1261: P_Validation_mode IN VARCHAR2,
1262: P_START_DATE IN DATE,
1263: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1264: X_Return_Status OUT NOCOPY VARCHAR2,
1265: X_Msg_Count OUT NOCOPY NUMBER,
1266: X_Msg_Data OUT NOCOPY VARCHAR2
1267: )

Line 1277: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1273: FND_MSG_PUB.initialize;
1274: END IF;
1275: -- Initialize API return status to SUCCESS
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1278: THEN
1279: -- Hint: Validate data
1280: -- IF p_START_DATE is not NULL and p_START_DATE <> G_MISS_CHAR
1281: -- verify if data is valid

Line 1284: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1280: -- IF p_START_DATE is not NULL and p_START_DATE <> G_MISS_CHAR
1281: -- verify if data is valid
1282: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1283: NULL;
1284: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1285: THEN
1286: -- Hint: Validate data
1287: -- IF p_START_DATE <> G_MISS_CHAR
1288: -- verify if data is valid

Line 1302: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1298: PROCEDURE Validate_END_DATE (
1299: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1300: P_Validation_mode IN VARCHAR2,
1301: P_END_DATE IN DATE,
1302: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1303: X_Return_Status OUT NOCOPY VARCHAR2,
1304: X_Msg_Count OUT NOCOPY NUMBER,
1305: X_Msg_Data OUT NOCOPY VARCHAR2
1306: )

Line 1316: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1312: FND_MSG_PUB.initialize;
1313: END IF;
1314: -- Initialize API return status to SUCCESS
1315: x_return_status := FND_API.G_RET_STS_SUCCESS;
1316: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1317: THEN
1318: -- Hint: Validate data
1319: -- IF p_END_DATE is not NULL and p_END_DATE <> G_MISS_CHAR
1320: -- verify if data is valid

Line 1323: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1319: -- IF p_END_DATE is not NULL and p_END_DATE <> G_MISS_CHAR
1320: -- verify if data is valid
1321: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1322: NULL;
1323: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1324: THEN
1325: -- Hint: Validate data
1326: -- IF p_END_DATE <> G_MISS_CHAR
1327: -- verify if data is valid

Line 1342: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1338: PROCEDURE Validate_ROLLUP_QUANTITY_USED (
1339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1340: P_Validation_mode IN VARCHAR2,
1341: P_ROLLUP_QUANTITY_USED IN NUMBER,
1342: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1343: X_Return_Status OUT NOCOPY VARCHAR2,
1344: X_Msg_Count OUT NOCOPY NUMBER,
1345: X_Msg_Data OUT NOCOPY VARCHAR2
1346: )

Line 1356: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1352: FND_MSG_PUB.initialize;
1353: END IF;
1354: -- Initialize API return status to SUCCESS
1355: x_return_status := FND_API.G_RET_STS_SUCCESS;
1356: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1357: THEN
1358: -- Hint: Validate data
1359: -- IF p_ROLLUP_QUANTITY_USED is not NULL and p_ROLLUP_QUANTITY_USED <> G_MISS_CHAR
1360: -- verify if data is valid

Line 1363: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1359: -- IF p_ROLLUP_QUANTITY_USED is not NULL and p_ROLLUP_QUANTITY_USED <> G_MISS_CHAR
1360: -- verify if data is valid
1361: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1362: NULL;
1363: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1364: THEN
1365: -- Hint: Validate data
1366: -- IF p_ROLLUP_QUANTITY_USED <> G_MISS_CHAR
1367: -- verify if data is valid

Line 1382: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1378: PROCEDURE Validate_ROLLUP_TIMES_USED (
1379: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1380: P_Validation_mode IN VARCHAR2,
1381: P_ROLLUP_TIMES_USED IN NUMBER,
1382: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1383: X_Return_Status OUT NOCOPY VARCHAR2,
1384: X_Msg_Count OUT NOCOPY NUMBER,
1385: X_Msg_Data OUT NOCOPY VARCHAR2
1386: )

Line 1396: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1392: FND_MSG_PUB.initialize;
1393: END IF;
1394: -- Initialize API return status to SUCCESS
1395: x_return_status := FND_API.G_RET_STS_SUCCESS;
1396: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1397: THEN
1398: -- Hint: Validate data
1399: -- IF p_ROLLUP_TIMES_USED is not NULL and p_ROLLUP_TIMES_USED <> G_MISS_CHAR
1400: -- verify if data is valid

Line 1403: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1399: -- IF p_ROLLUP_TIMES_USED is not NULL and p_ROLLUP_TIMES_USED <> G_MISS_CHAR
1400: -- verify if data is valid
1401: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1402: NULL;
1403: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1404: THEN
1405: -- Hint: Validate data
1406: -- IF p_ROLLUP_TIMES_USED <> G_MISS_CHAR
1407: -- verify if data is valid

Line 1422: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1418: PROCEDURE Validate_SUBSTITUTE_ITEM (
1419: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1420: P_Validation_mode IN VARCHAR2,
1421: P_SUBSTITUTE_ITEM IN NUMBER,
1422: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1423: X_Return_Status OUT NOCOPY VARCHAR2,
1424: X_Msg_Count OUT NOCOPY NUMBER,
1425: X_Msg_Data OUT NOCOPY VARCHAR2
1426: )

Line 1436: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1432: FND_MSG_PUB.initialize;
1433: END IF;
1434: -- Initialize API return status to SUCCESS
1435: x_return_status := FND_API.G_RET_STS_SUCCESS;
1436: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1437: THEN
1438: -- Hint: Validate data
1439: -- IF p_SUBSTITUTE_ITEM is not NULL and p_SUBSTITUTE_ITEM <> G_MISS_CHAR
1440: -- verify if data is valid

Line 1443: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1439: -- IF p_SUBSTITUTE_ITEM is not NULL and p_SUBSTITUTE_ITEM <> G_MISS_CHAR
1440: -- verify if data is valid
1441: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1442: NULL;
1443: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1444: THEN
1445: -- Hint: Validate data
1446: -- IF p_SUBSTITUTE_ITEM <> G_MISS_CHAR
1447: -- verify if data is valid

Line 1460: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor

1456: END Validate_SUBSTITUTE_ITEM;
1457:
1458:
1459: -- Hint: inter-field level validation can be added here.
1460: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1461: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1462: -- stored in database table.
1463: PROCEDURE Validate_TASK_PART_rec(
1464: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1485: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'API_INVALID_RECORD');

1481: -- If data not valid
1482: -- THEN
1483: -- x_return_status := FND_API.G_RET_STS_ERROR;
1484: -- Debug Message
1485: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'API_INVALID_RECORD');
1486: -- Standard call to get message count and if count is 1, get message info.
1487: FND_MSG_PUB.Count_And_Get
1488: ( p_count => x_msg_count,
1489: p_data => x_msg_data

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

1501: IS
1502: l_api_name CONSTANT VARCHAR2(30) := 'Validate_task_part';
1503: BEGIN
1504: -- Debug Message
1505: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'start');
1506: -- Initialize API return status to SUCCESS
1507: x_return_status := FND_API.G_RET_STS_SUCCESS;
1508: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1509: -- Hint: We provide validation procedure for every column. Developer should delete

Line 1508: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN

1504: -- Debug Message
1505: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'start');
1506: -- Initialize API return status to SUCCESS
1507: x_return_status := FND_API.G_RET_STS_SUCCESS;
1508: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1509: -- Hint: We provide validation procedure for every column. Developer should delete
1510: -- unnecessary validation procedures.
1511: Validate_TASK_PART_ID(
1512: p_init_msg_list => FND_API.G_FALSE,

Line 1668: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN

1664: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1665: raise FND_API.G_EXC_ERROR;
1666: END IF;
1667: END IF;
1668: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1669: -- Hint: Inter-field level validation can be added here
1670: -- invoke record level validation procedures
1671: Validate_TASK_PART_Rec(
1672: p_init_msg_list => FND_API.G_FALSE,

Line 1682: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN

1678: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1679: raise FND_API.G_EXC_ERROR;
1680: END IF;
1681: END IF;
1682: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1683: -- invoke inter-record level validation procedures
1684: NULL;
1685: END IF;
1686: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN

Line 1686: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN

1682: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1683: -- invoke inter-record level validation procedures
1684: NULL;
1685: END IF;
1686: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1687: -- invoke inter-entity level validation procedures
1688: NULL;
1689: END IF;
1690: -- Debug Message

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

1687: -- invoke inter-entity level validation procedures
1688: NULL;
1689: END IF;
1690: -- Debug Message
1691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: ' || l_api_name || 'end');
1692: END Validate_task_part;
1693: End CSP_TASK_PART_PVT;