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.AST_GRP_CAMP_PVT dependencies on JTF_PLSQL_API

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

63: END IF;
64:
65:
66: -- Debug Message
67: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'start');
68:
69:
70: -- Initialize API return status to SUCCESS
71: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 125: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Validate_grp_camp');

121:
122: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
123: THEN
124: -- Debug message
125: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Validate_grp_camp');
126:
127: -- Invoke validation procedures
128: Validate_grp_camp(
129: p_init_msg_list => FND_API.G_FALSE,

Line 131: p_validation_mode => JTF_PLSQL_API.G_CREATE,

127: -- Invoke validation procedures
128: Validate_grp_camp(
129: p_init_msg_list => FND_API.G_FALSE,
130: p_validation_level => p_validation_level,
131: p_validation_mode => JTF_PLSQL_API.G_CREATE,
132: P_grp_camp_Rec => P_grp_camp_Rec,
133: x_return_status => x_return_status,
134: x_msg_count => x_msg_count,
135: x_msg_data => x_msg_data);

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

141:
142: -- Hint: Add corresponding Master-Detail business logic here if necessary.
143:
144: -- Debug Message
145: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Calling create table handler');
146:
147: -- Invoke table handler(AST_GRP_CAMPAIGNS_PKG.Insert_Row)
148: AST_GRP_CAMPAIGNS_PKG.Insert_Row(
149: px_GROUP_CAMPAIGN_ID => x_GROUP_CAMPAIGN_ID,

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

175: END IF;
176:
177:
178: -- Debug Message
179: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'end');
180:
181:
182: -- Standard call to get message count and if count is 1, get message info.
183: FND_MSG_PUB.Count_And_Get

Line 207: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

203: END IF;
204: */
205: EXCEPTION
206: WHEN FND_API.G_EXC_ERROR THEN
207: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
208: P_API_NAME => L_API_NAME
209: ,P_PKG_NAME => G_PKG_NAME
210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
211: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 211: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

207: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
208: P_API_NAME => L_API_NAME
209: ,P_PKG_NAME => G_PKG_NAME
210: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
211: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
212: ,X_MSG_COUNT => X_MSG_COUNT
213: ,X_MSG_DATA => X_MSG_DATA
214: ,X_RETURN_STATUS => X_RETURN_STATUS);
215:

Line 217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

213: ,X_MSG_DATA => X_MSG_DATA
214: ,X_RETURN_STATUS => X_RETURN_STATUS);
215:
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
218: P_API_NAME => L_API_NAME
219: ,P_PKG_NAME => G_PKG_NAME
220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
218: P_API_NAME => L_API_NAME
219: ,P_PKG_NAME => G_PKG_NAME
220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
222: ,X_MSG_COUNT => X_MSG_COUNT
223: ,X_MSG_DATA => X_MSG_DATA
224: ,X_RETURN_STATUS => X_RETURN_STATUS);
225:

Line 227: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

223: ,X_MSG_DATA => X_MSG_DATA
224: ,X_RETURN_STATUS => X_RETURN_STATUS);
225:
226: WHEN OTHERS THEN
227: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
228: P_API_NAME => L_API_NAME
229: ,P_PKG_NAME => G_PKG_NAME
230: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
231: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 230: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

226: WHEN OTHERS THEN
227: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
228: P_API_NAME => L_API_NAME
229: ,P_PKG_NAME => G_PKG_NAME
230: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
231: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
232: ,X_MSG_COUNT => X_MSG_COUNT
233: ,X_MSG_DATA => X_MSG_DATA
234: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 231: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

227: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
228: P_API_NAME => L_API_NAME
229: ,P_PKG_NAME => G_PKG_NAME
230: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
231: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
232: ,X_MSG_COUNT => X_MSG_COUNT
233: ,X_MSG_DATA => X_MSG_DATA
234: ,X_RETURN_STATUS => X_RETURN_STATUS);
235: End Create_grp_camp;

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

294: END IF;
295:
296:
297: -- Debug Message
298: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'start');
299:
300:
301: -- Initialize API return status to SUCCESS
302: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337: */
338: -- Debug Message
339: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: - Open Cursor to Select');
340:
341:
342: Open C_Get_grp_camp( l_tar_grp_camp_rec.GROUP_CAMPAIGN_ID);
343:

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

364: END IF;
365: raise FND_API.G_EXC_ERROR;
366: END IF;
367: -- Debug Message
368: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: - Close Cursor');
369: Close C_Get_grp_camp;
370:
371:
372:

Line 398: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Validate_grp_camp');

394: */
395: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
396: THEN
397: -- Debug message
398: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Validate_grp_camp');
399:
400: -- Invoke validation procedures
401: Validate_grp_camp(
402: p_init_msg_list => FND_API.G_FALSE,

Line 404: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

400: -- Invoke validation procedures
401: Validate_grp_camp(
402: p_init_msg_list => FND_API.G_FALSE,
403: p_validation_level => p_validation_level,
404: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
405: P_grp_camp_Rec => P_grp_camp_Rec,
406: x_return_status => x_return_status,
407: x_msg_count => x_msg_count,
408: x_msg_data => x_msg_data);

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

414:
415: -- Hint: Add corresponding Master-Detail business logic here if necessary.
416:
417: -- Debug Message
418: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Calling update table handler');
419:
420: -- Invoke table handler(AST_GRP_CAMPAIGNS_PKG.Update_Row)
421: AST_GRP_CAMPAIGNS_PKG.Update_Row(
422: p_GROUP_CAMPAIGN_ID => p_grp_camp_rec.GROUP_CAMPAIGN_ID,

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

441: END IF;
442:
443:
444: -- Debug Message
445: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'end');
446:
447:
448: -- Standard call to get message count and if count is 1, get message info.
449: FND_MSG_PUB.Count_And_Get

Line 474: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

470: END IF;
471: */
472: EXCEPTION
473: WHEN FND_API.G_EXC_ERROR THEN
474: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
475: P_API_NAME => L_API_NAME
476: ,P_PKG_NAME => G_PKG_NAME
477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
478: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 478: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

474: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
475: P_API_NAME => L_API_NAME
476: ,P_PKG_NAME => G_PKG_NAME
477: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
478: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
479: ,X_MSG_COUNT => X_MSG_COUNT
480: ,X_MSG_DATA => X_MSG_DATA
481: ,X_RETURN_STATUS => X_RETURN_STATUS);
482:

Line 484: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

480: ,X_MSG_DATA => X_MSG_DATA
481: ,X_RETURN_STATUS => X_RETURN_STATUS);
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
485: P_API_NAME => L_API_NAME
486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
488: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 488: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

484: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
485: P_API_NAME => L_API_NAME
486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
488: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
489: ,X_MSG_COUNT => X_MSG_COUNT
490: ,X_MSG_DATA => X_MSG_DATA
491: ,X_RETURN_STATUS => X_RETURN_STATUS);
492:

Line 494: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

490: ,X_MSG_DATA => X_MSG_DATA
491: ,X_RETURN_STATUS => X_RETURN_STATUS);
492:
493: WHEN OTHERS THEN
494: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
495: P_API_NAME => L_API_NAME
496: ,P_PKG_NAME => G_PKG_NAME
497: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
498: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 497: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

493: WHEN OTHERS THEN
494: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
495: P_API_NAME => L_API_NAME
496: ,P_PKG_NAME => G_PKG_NAME
497: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
498: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
499: ,X_MSG_COUNT => X_MSG_COUNT
500: ,X_MSG_DATA => X_MSG_DATA
501: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 498: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

494: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
495: P_API_NAME => L_API_NAME
496: ,P_PKG_NAME => G_PKG_NAME
497: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
498: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
499: ,X_MSG_COUNT => X_MSG_COUNT
500: ,X_MSG_DATA => X_MSG_DATA
501: ,X_RETURN_STATUS => X_RETURN_STATUS);
502: End Update_grp_camp;

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

541: END IF;
542:
543:
544: -- Debug Message
545: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'start');
546:
547:
548: -- Initialize API return status to SUCCESS
549: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584: */
585: -- Debug Message
586: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Calling delete table handler');
587:
588:
589:
590: -- Invoke table handler(AST_GRP_CAMPAIGNS_PKG.Delete_Row)

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

601: END IF;
602:
603:
604: -- Debug Message
605: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'end');
606:
607:
608: -- Standard call to get message count and if count is 1, get message info.
609: FND_MSG_PUB.Count_And_Get

Line 634: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

630: END IF;
631: */
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
635: P_API_NAME => L_API_NAME
636: ,P_PKG_NAME => G_PKG_NAME
637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
638: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 638: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

634: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
635: P_API_NAME => L_API_NAME
636: ,P_PKG_NAME => G_PKG_NAME
637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
638: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
639: ,X_MSG_COUNT => X_MSG_COUNT
640: ,X_MSG_DATA => X_MSG_DATA
641: ,X_RETURN_STATUS => X_RETURN_STATUS);
642:

Line 644: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 648: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

644: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
645: P_API_NAME => L_API_NAME
646: ,P_PKG_NAME => G_PKG_NAME
647: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
648: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
649: ,X_MSG_COUNT => X_MSG_COUNT
650: ,X_MSG_DATA => X_MSG_DATA
651: ,X_RETURN_STATUS => X_RETURN_STATUS);
652:

Line 654: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

650: ,X_MSG_DATA => X_MSG_DATA
651: ,X_RETURN_STATUS => X_RETURN_STATUS);
652:
653: WHEN OTHERS THEN
654: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
655: P_API_NAME => L_API_NAME
656: ,P_PKG_NAME => G_PKG_NAME
657: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
658: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 657: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

653: WHEN OTHERS THEN
654: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
655: P_API_NAME => L_API_NAME
656: ,P_PKG_NAME => G_PKG_NAME
657: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
658: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
659: ,X_MSG_COUNT => X_MSG_COUNT
660: ,X_MSG_DATA => X_MSG_DATA
661: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 658: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

654: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
655: P_API_NAME => L_API_NAME
656: ,P_PKG_NAME => G_PKG_NAME
657: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
658: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
659: ,X_MSG_COUNT => X_MSG_COUNT
660: ,X_MSG_DATA => X_MSG_DATA
661: ,X_RETURN_STATUS => X_RETURN_STATUS);
662: End Delete_grp_camp;

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

669: )
670: IS
671: BEGIN
672: -- Debug Message
673: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Define Columns Begins');
674:
675: -- define all columns for AST_GRP_TEST view
676: dbms_sql.define_column(p_cur_get_grp_camp, 1, P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);

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

680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);
681: dbms_sql.define_column(p_cur_get_grp_camp, 6, P_grp_camp_Rec.ENABLED_FLAG, 1);
682:
683: -- Debug Message
684: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Define Columns Ends');
685: END Define_Columns;
686:
687: -- This procudure gets column values by the Dynamic SQL.
688: PROCEDURE Get_Column_Values(

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

691: )
692: IS
693: BEGIN
694: -- Debug Message
695: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Get Column Values Begins');
696:
697: -- get all column values for AST_GRP_TEST table
698: dbms_sql.column_value(p_cur_get_grp_camp, 1, X_grp_camp_Rec.GROUP_CAMPAIGN_ID);
699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);

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

702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);
703: dbms_sql.column_value(p_cur_get_grp_camp, 6, X_grp_camp_Rec.ENABLED_FLAG);
704:
705: -- Debug Message
706: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Get Column Values Ends');
707: END Get_Column_Values;
708:
709: PROCEDURE Gen_grp_camp_order_cl(
710: p_order_by_rec IN ast_grp_camp_PUB.grp_camp_sort_rec_type,

Line 718: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

714: x_msg_data OUT VARCHAR2
715: )
716: IS
717: l_order_by_cl VARCHAR2(1000) := NULL;
718: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
719: BEGIN
720: -- Debug Message
721: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Order by Begins');
722:

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

717: l_order_by_cl VARCHAR2(1000) := NULL;
718: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
719: BEGIN
720: -- Debug Message
721: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Order by Begins');
722:
723: -- Hint: Developer should add more statements according to ast_sort_rec_type
724: -- Ex:
725: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

Line 729: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Invoke JTF_PLSQL_API.Translate_OrderBy');

725: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
726: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
727:
728: -- Debug Message
729: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
730:
731: JTF_PLSQL_API.Translate_OrderBy(
732: p_api_version_number => 1.0
733: ,p_init_msg_list => FND_API.G_FALSE

Line 731: JTF_PLSQL_API.Translate_OrderBy(

727:
728: -- Debug Message
729: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
730:
731: JTF_PLSQL_API.Translate_OrderBy(
732: p_api_version_number => 1.0
733: ,p_init_msg_list => FND_API.G_FALSE
734: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
735: ,p_order_by_tbl => l_util_order_by_tbl

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

744: x_order_by_cl := NULL;
745: END IF;
746:
747: -- Debug Message
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Order by Ends');
749: END Gen_grp_camp_order_cl;
750:
751: -- This procedure bind the variables for the Dynamic SQL
752: PROCEDURE Bind(

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

758: BEGIN
759: -- Bind variables
760: -- Only those that are not NULL
761: -- Debug Message
762: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Bind Variables Begins');
763:
764: -- The following example applies to all columns,
765: -- developers can copy and paste them.
766: IF( (P_grp_camp_Rec.GROUP_CAMPAIGN_ID IS NOT NULL) AND (P_grp_camp_Rec.GROUP_CAMPAIGN_ID <> FND_API.G_MISS_NUM) )

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

768: DBMS_SQL.BIND_VARIABLE(p_cur_get_grp_camp, ':p_GROUP_CAMPAIGN_ID', P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
769: END IF;
770:
771: -- Debug Message
772: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Bind Variables Ends');
773: END Bind;
774:
775: PROCEDURE Gen_Select(
776: x_select_cl OUT VARCHAR2

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

777: )
778: IS
779: BEGIN
780: -- Debug Message
781: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Select Begins');
782:
783: x_select_cl := 'Select ' ||
784: 'AST_GRP_TEST.GROUP_CAMPAIGN_ID,' ||
785: 'AST_GRP_TEST.GROUP_ID,' ||

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

793: 'AST_GRP_TEST.CREATED_BY,' ||
794: 'AST_GRP_TEST.CREATION_DATE,' ||
795: 'from AST_GRP_TEST';
796: -- Debug Message
797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Select Ends');
798:
799: END Gen_Select;
800:
801: PROCEDURE Gen_grp_camp_Where(

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

817: str_csr2 NUMBER;
818: l_operator VARCHAR2(10);
819: BEGIN
820: -- Debug Message
821: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Where Begins');
822:
823: -- There are three examples for each kind of datatype:
824: -- NUMBER, DATE, VARCHAR2.
825: -- Developer can copy and paste the following codes for your own record.

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

903:
904: -- Add more IF statements for each column below
905:
906: -- Debug Message
907: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generate Where Ends');
908:
909: END Gen_grp_camp_Where;
910:
911: PROCEDURE Get_grp_camp(

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

986: END IF;
987:
988:
989: -- Debug Message
990: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'start');
991:
992:
993: -- Initialize API return status to SUCCESS
994: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1017: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generating Dsql');

1013: -- Generate Dynamic SQL based on criteria passed in.
1014: -- Doing this for performance. Indexes are disabled when using NVL within static SQL statement.
1015: -- Ignore condition when criteria is NULL
1016: -- Debug Message
1017: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Generating Dsql');
1018: -- Generate Select clause and From clause
1019: -- Hint: Developer should modify Gen_Select procedure.
1020: Gen_Select(l_select_cl);
1021:

Line 1059: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Open and Parse Cursor');

1055: -- Generate order by clause
1056: Gen_grp_camp_order_cl(p_order_by_rec, l_order_by_cl, l_return_status, x_msg_count, x_msg_data);
1057:
1058: -- Debug Message
1059: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Open and Parse Cursor');
1060:
1061: l_cur_get_grp_camp := dbms_sql.open_cursor;
1062:
1063: -- Hint: concatenate all where clause (include flex field/line level if any applies)

Line 1085: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Execute Dsql');

1081: Define_Columns(l_crit_grp_camp_rec, l_cur_get_grp_camp);
1082:
1083: -- Execute
1084: -- Debug Message
1085: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Execute Dsql');
1086:
1087: l_ignore := dbms_sql.execute(l_cur_get_grp_camp);
1088:
1089: -- Debug Message

Line 1090: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Fetch Results');

1086:
1087: l_ignore := dbms_sql.execute(l_cur_get_grp_camp);
1088:
1089: -- Debug Message
1090: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Fetch Results');
1091:
1092: -- This loop is here to avoid calling a function in the main
1093: -- cursor. Basically, calling this function seems to disable
1094: -- index, but verification is needed. This is a good

Line 1105: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: found');

1101: IF((dbms_sql.fetch_rows(l_cur_get_grp_camp)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1102: OR (l_returned_rec_count 1103: THEN
1104: -- Debug Message
1105: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: found');
1106:
1107: -- Hint: Developer need to implement this part
1108: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1109: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);

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

1133: -- End of API body
1134: --
1135:
1136: -- Debug Message
1137: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'end');
1138:
1139:
1140: -- Standard call to get message count and if count is 1, get message info.
1141: FND_MSG_PUB.Count_And_Get

Line 1148: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1144: );
1145:
1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1149: P_API_NAME => L_API_NAME
1150: ,P_PKG_NAME => G_PKG_NAME
1151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1152: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1152: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1148: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1149: P_API_NAME => L_API_NAME
1150: ,P_PKG_NAME => G_PKG_NAME
1151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1152: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1153: ,X_MSG_COUNT => X_MSG_COUNT
1154: ,X_MSG_DATA => X_MSG_DATA
1155: ,X_RETURN_STATUS => X_RETURN_STATUS);
1156:

Line 1158: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1154: ,X_MSG_DATA => X_MSG_DATA
1155: ,X_RETURN_STATUS => X_RETURN_STATUS);
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1159: P_API_NAME => L_API_NAME
1160: ,P_PKG_NAME => G_PKG_NAME
1161: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1162: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1162: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1158: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1159: P_API_NAME => L_API_NAME
1160: ,P_PKG_NAME => G_PKG_NAME
1161: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1162: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1163: ,X_MSG_COUNT => X_MSG_COUNT
1164: ,X_MSG_DATA => X_MSG_DATA
1165: ,X_RETURN_STATUS => X_RETURN_STATUS);
1166:

Line 1168: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1164: ,X_MSG_DATA => X_MSG_DATA
1165: ,X_RETURN_STATUS => X_RETURN_STATUS);
1166:
1167: WHEN OTHERS THEN
1168: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1169: P_API_NAME => L_API_NAME
1170: ,P_PKG_NAME => G_PKG_NAME
1171: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1172: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1171: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1167: WHEN OTHERS THEN
1168: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1169: P_API_NAME => L_API_NAME
1170: ,P_PKG_NAME => G_PKG_NAME
1171: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1172: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1173: ,X_MSG_COUNT => X_MSG_COUNT
1174: ,X_MSG_DATA => X_MSG_DATA
1175: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1172: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1168: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1169: P_API_NAME => L_API_NAME
1170: ,P_PKG_NAME => G_PKG_NAME
1171: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1172: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1173: ,X_MSG_COUNT => X_MSG_COUNT
1174: ,X_MSG_DATA => X_MSG_DATA
1175: ,X_RETURN_STATUS => X_RETURN_STATUS);
1176: End Get_grp_camp;

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

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

Line 1206: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(GROUP_CAMPAIGN_ID)');

1202:
1203: -- validate NOT NULL column
1204: IF(p_GROUP_CAMPAIGN_ID is NULL)
1205: THEN
1206: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(GROUP_CAMPAIGN_ID)');
1207:
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: END IF;
1210:

Line 1211: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1207:
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: END IF;
1210:
1211: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1212: THEN
1213: -- Hint: Validate data
1214: -- IF p_GROUP_CAMPAIGN_ID is not NULL and p_GROUP_CAMPAIGN_ID <> G_MISS_CHAR
1215: -- verify if data is valid

Line 1218: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1214: -- IF p_GROUP_CAMPAIGN_ID is not NULL and p_GROUP_CAMPAIGN_ID <> G_MISS_CHAR
1215: -- verify if data is valid
1216: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1217: NULL;
1218: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1219: THEN
1220: -- Hint: Validate data
1221: -- IF p_GROUP_CAMPAIGN_ID <> G_MISS_CHAR
1222: -- verify if data is valid

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

1236: PROCEDURE Validate_GROUP_ID (
1237: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1238: P_Validation_mode IN VARCHAR2,
1239: P_GROUP_ID IN NUMBER,
1240: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1241:
1242: X_Return_Status OUT VARCHAR2,
1243: X_Msg_Count OUT NUMBER,
1244: X_Msg_Data OUT VARCHAR2

Line 1262: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(GROUP_ID)');

1258:
1259: -- validate NOT NULL column
1260: IF(p_GROUP_ID is NULL)
1261: THEN
1262: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(GROUP_ID)');
1263:
1264: x_return_status := FND_API.G_RET_STS_ERROR;
1265: END IF;
1266:

Line 1267: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1263:
1264: x_return_status := FND_API.G_RET_STS_ERROR;
1265: END IF;
1266:
1267: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1268: THEN
1269: -- Hint: Validate data
1270: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
1271: -- verify if data is valid

Line 1274: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1270: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
1271: -- verify if data is valid
1272: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1273: NULL;
1274: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1275: THEN
1276: -- Hint: Validate data
1277: -- IF p_GROUP_ID <> G_MISS_CHAR
1278: -- verify if data is valid

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

1292: PROCEDURE Validate_CAMPAIGN_ID (
1293: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1294: P_Validation_mode IN VARCHAR2,
1295: P_CAMPAIGN_ID IN NUMBER,
1296: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1297:
1298: X_Return_Status OUT VARCHAR2,
1299: X_Msg_Count OUT NUMBER,
1300: X_Msg_Data OUT VARCHAR2

Line 1318: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(CAMPAIGN_ID)');

1314:
1315: -- validate NOT NULL column
1316: IF(p_CAMPAIGN_ID is NULL)
1317: THEN
1318: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(CAMPAIGN_ID)');
1319:
1320: x_return_status := FND_API.G_RET_STS_ERROR;
1321: END IF;
1322:

Line 1323: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1330: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1326: -- IF p_CAMPAIGN_ID is not NULL and p_CAMPAIGN_ID <> G_MISS_CHAR
1327: -- verify if data is valid
1328: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1329: NULL;
1330: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1331: THEN
1332: -- Hint: Validate data
1333: -- IF p_CAMPAIGN_ID <> G_MISS_CHAR
1334: -- verify if data is valid

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

1348: PROCEDURE Validate_START_DATE (
1349: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1350: P_Validation_mode IN VARCHAR2,
1351: P_START_DATE IN DATE,
1352: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1353:
1354: X_Return_Status OUT VARCHAR2,
1355: X_Msg_Count OUT NUMBER,
1356: X_Msg_Data OUT VARCHAR2

Line 1371: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1367:
1368: -- Initialize API return status to SUCCESS
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;
1370:
1371: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1372: THEN
1373: -- Hint: Validate data
1374: -- IF p_START_DATE is not NULL and p_START_DATE <> G_MISS_CHAR
1375: -- verify if data is valid

Line 1378: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1374: -- IF p_START_DATE is not NULL and p_START_DATE <> G_MISS_CHAR
1375: -- verify if data is valid
1376: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1377: NULL;
1378: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1379: THEN
1380: -- Hint: Validate data
1381: -- IF p_START_DATE <> G_MISS_CHAR
1382: -- verify if data is valid

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

1396: PROCEDURE Validate_END_DATE (
1397: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1398: P_Validation_mode IN VARCHAR2,
1399: P_END_DATE IN DATE,
1400: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1401:
1402: X_Return_Status OUT VARCHAR2,
1403: X_Msg_Count OUT NUMBER,
1404: X_Msg_Data OUT VARCHAR2

Line 1419: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1415:
1416: -- Initialize API return status to SUCCESS
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418:
1419: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1420: THEN
1421: -- Hint: Validate data
1422: -- IF p_END_DATE is not NULL and p_END_DATE <> G_MISS_CHAR
1423: -- verify if data is valid

Line 1426: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1422: -- IF p_END_DATE is not NULL and p_END_DATE <> G_MISS_CHAR
1423: -- verify if data is valid
1424: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1425: NULL;
1426: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1427: THEN
1428: -- Hint: Validate data
1429: -- IF p_END_DATE <> G_MISS_CHAR
1430: -- verify if data is valid

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

1444: PROCEDURE Validate_ENABLED_FLAG (
1445: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1446: P_Validation_mode IN VARCHAR2,
1447: P_ENABLED_FLAG IN VARCHAR2,
1448: -- Hint: You may add 'X_Item_Property_Rec OUT JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1449:
1450: X_Return_Status OUT VARCHAR2,
1451: X_Msg_Count OUT NUMBER,
1452: X_Msg_Data OUT VARCHAR2

Line 1470: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(ENABLED_FLAG)');

1466:
1467: -- validate NOT NULL column
1468: IF(p_ENABLED_FLAG is NULL)
1469: THEN
1470: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'ast', 'Private grp_camp API: -Violate NOT NULL constraint(ENABLED_FLAG)');
1471:
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: END IF;
1474:

Line 1475: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1471:
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: END IF;
1474:
1475: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1476: THEN
1477: -- Hint: Validate data
1478: -- IF p_ENABLED_FLAG is not NULL and p_ENABLED_FLAG <> G_MISS_CHAR
1479: -- verify if data is valid

Line 1482: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1478: -- IF p_ENABLED_FLAG is not NULL and p_ENABLED_FLAG <> G_MISS_CHAR
1479: -- verify if data is valid
1480: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1481: NULL;
1482: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1483: THEN
1484: -- Hint: Validate data
1485: -- IF p_ENABLED_FLAG <> G_MISS_CHAR
1486: -- verify if data is valid

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

1497: END Validate_ENABLED_FLAG;
1498:
1499:
1500: -- Hint: inter-field level validation can be added here.
1501: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1502: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1503:
1504:
1505: -- stored in database table.

Line 1533: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'API_INVALID_RECORD');

1529: -- THEN
1530: -- x_return_status := FND_API.G_RET_STS_ERROR;
1531:
1532: -- Debug Message
1533: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'API_INVALID_RECORD');
1534:
1535: -- Standard call to get message count and if count is 1, get message info.
1536: FND_MSG_PUB.Count_And_Get
1537: ( p_count => x_msg_count,

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

1553: l_api_name CONSTANT VARCHAR2(30) := 'Validate_grp_camp';
1554: BEGIN
1555:
1556: -- Debug Message
1557: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'start');
1558:
1559:
1560: -- Initialize API return status to SUCCESS
1561: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1559:
1560: -- Initialize API return status to SUCCESS
1561: x_return_status := FND_API.G_RET_STS_SUCCESS;
1562:
1563: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1564: -- Hint: We provide validation procedure for every column. Developer should delete
1565: -- unnecessary validation procedures.
1566: Validate_GROUP_CAMPAIGN_ID(
1567: p_init_msg_list => FND_API.G_FALSE,

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

1642: END IF;
1643:
1644: END IF;
1645:
1646: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1647: -- Hint: Inter-field level validation can be added here
1648: -- invoke record level validation procedures
1649: Validate_grp_camp_Rec(
1650: p_init_msg_list => FND_API.G_FALSE,

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

1658: raise FND_API.G_EXC_ERROR;
1659: END IF;
1660: END IF;
1661:
1662: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1663: -- invoke inter-record level validation procedures
1664: NULL;
1665: END IF;
1666:

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

1663: -- invoke inter-record level validation procedures
1664: NULL;
1665: END IF;
1666:
1667: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1668: -- invoke inter-entity level validation procedures
1669: NULL;
1670: END IF;
1671:

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

1670: END IF;
1671:
1672:
1673: -- Debug Message
1674: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: ' || l_api_name || 'end');
1675:
1676: END Validate_grp_camp;
1677: End ast_grp_camp_PVT;