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

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

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

Line 121: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Validate_rs_camp');

117: */
118: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
119: THEN
120: -- Debug message
121: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Validate_rs_camp');
122:
123:
124: -- Invoke validation procedures
125: Validate_rs_camp(

Line 128: p_validation_mode => JTF_PLSQL_API.G_CREATE,

124: -- Invoke validation procedures
125: Validate_rs_camp(
126: p_init_msg_list => FND_API.G_FALSE,
127: p_validation_level => p_validation_level,
128: p_validation_mode => JTF_PLSQL_API.G_CREATE,
129: P_rs_camp_Rec => P_rs_camp_Rec,
130: x_return_status => x_return_status,
131: x_msg_count => x_msg_count,
132: x_msg_data => x_msg_data);

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

138:
139: -- Hint: Add corresponding Master-Detail business logic here if necessary.
140:
141: -- Debug Message
142: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Calling create table handler');
143:
144: -- Invoke table handler(AST_RS_CAMPAIGNS_PKG.Insert_Row)
145: AST_RS_CAMPAIGNS_PKG.Insert_Row(
146: px_RS_CAMPAIGN_ID => x_RS_CAMPAIGN_ID,

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

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

Line 206: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 210: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 216: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 220: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 226: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 229: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 230: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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

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

336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338:
339: -- Debug Message
340: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: - Open Cursor to Select');
341: Open C_Get_rs_camp( l_tar_rs_camp_rec.RS_CAMPAIGN_ID);
342:
343: Fetch C_Get_rs_camp into
344: l_rowid,

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:
370: Close C_Get_rs_camp;
371:
372:

Line 398: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Validate_rs_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_rs_camp');
399:
400:
401: -- Invoke validation procedures
402: Validate_rs_camp(

Line 405: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

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

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

415:
416: -- Hint: Add corresponding Master-Detail business logic here if necessary.
417:
418: -- Debug Message
419: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Calling update table handler');
420:
421:
422: -- Invoke table handler(AST_RS_CAMPAIGNS_PKG.Update_Row)
423: AST_RS_CAMPAIGNS_PKG.Update_Row(

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

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

Line 476: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

472: END IF;
473: */
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR 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 => FND_MSG_PUB.G_MSG_LVL_ERROR
480: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 480: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 486: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 490: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 496: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 499: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 500: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

543: END IF;
544:
545:
546: -- Debug Message
547: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
548:
549:
550:
551: -- Initialize API return status to SUCCESS

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

586: RAISE FND_API.G_EXC_ERROR;
587: END IF;
588: */
589: -- Debug Message
590: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Calling delete table handler');
591:
592:
593: -- Invoke table handler(AST_RS_CAMPAIGNS_PKG.Delete_Row)
594: AST_RS_CAMPAIGNS_PKG.Delete_Row(

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

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

Line 639: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

635: END IF;
636: */
637: EXCEPTION
638: WHEN FND_API.G_EXC_ERROR THEN
639: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
640: P_API_NAME => L_API_NAME
641: ,P_PKG_NAME => G_PKG_NAME
642: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
643: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 643: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

639: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
640: P_API_NAME => L_API_NAME
641: ,P_PKG_NAME => G_PKG_NAME
642: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
643: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
644: ,X_MSG_COUNT => X_MSG_COUNT
645: ,X_MSG_DATA => X_MSG_DATA
646: ,X_RETURN_STATUS => X_RETURN_STATUS);
647:

Line 649: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 653: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

649: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
650: P_API_NAME => L_API_NAME
651: ,P_PKG_NAME => G_PKG_NAME
652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
653: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
654: ,X_MSG_COUNT => X_MSG_COUNT
655: ,X_MSG_DATA => X_MSG_DATA
656: ,X_RETURN_STATUS => X_RETURN_STATUS);
657:

Line 659: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 662: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

658: WHEN OTHERS THEN
659: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
660: P_API_NAME => L_API_NAME
661: ,P_PKG_NAME => G_PKG_NAME
662: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
663: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
664: ,X_MSG_COUNT => X_MSG_COUNT
665: ,X_MSG_DATA => X_MSG_DATA
666: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 663: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

659: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
660: P_API_NAME => L_API_NAME
661: ,P_PKG_NAME => G_PKG_NAME
662: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
663: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
664: ,X_MSG_COUNT => X_MSG_COUNT
665: ,X_MSG_DATA => X_MSG_DATA
666: ,X_RETURN_STATUS => X_RETURN_STATUS);
667: End Delete_rs_camp;

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

674: )
675: IS
676: BEGIN
677: -- Debug Message
678: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Define Columns Begins');
679:
680:
681: -- define all columns for AST_TEST view
682: dbms_sql.define_column(p_cur_get_rs_camp, 1, P_rs_camp_Rec.RS_CAMPAIGN_ID);

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

687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);
688: dbms_sql.define_column(p_cur_get_rs_camp, 7, P_rs_camp_Rec.ENABLED_FLAG, 1);
689:
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Define Columns Ends');
692:
693: END Define_Columns;
694:
695: -- This procudure gets column values by the Dynamic SQL.

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

699: )
700: IS
701: BEGIN
702: -- Debug Message
703: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Get Column Values Begins');
704:
705:
706: -- get all column values for AST_TEST table
707: dbms_sql.column_value(p_cur_get_rs_camp, 1, X_rs_camp_Rec.RS_CAMPAIGN_ID);

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

712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);
713: dbms_sql.column_value(p_cur_get_rs_camp, 7, X_rs_camp_Rec.ENABLED_FLAG);
714:
715: -- Debug Message
716: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Get Column Values Ends');
717:
718: END Get_Column_Values;
719:
720: PROCEDURE Gen_rs_camp_order_cl(

Line 729: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

725: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
726: )
727: IS
728: l_order_by_cl VARCHAR2(1000) := NULL;
729: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
730: BEGIN
731: -- Debug Message
732: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generate Order by Begins');
733:

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

728: l_order_by_cl VARCHAR2(1000) := NULL;
729: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
730: BEGIN
731: -- Debug Message
732: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generate Order by Begins');
733:
734:
735: -- Hint: Developer should add more statements according to AST_sort_rec_type
736: -- Ex:

Line 741: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Invoke JTF_PLSQL_API.Translate_OrderBy');

737: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
738: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
739:
740: -- Debug Message
741: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
742:
743:
744: JTF_PLSQL_API.Translate_OrderBy(
745: p_api_version_number => 1.0

Line 744: JTF_PLSQL_API.Translate_OrderBy(

740: -- Debug Message
741: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
742:
743:
744: JTF_PLSQL_API.Translate_OrderBy(
745: p_api_version_number => 1.0
746: ,p_init_msg_list => FND_API.G_FALSE
747: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
748: ,p_order_by_tbl => l_util_order_by_tbl

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

757: x_order_by_cl := NULL;
758: END IF;
759:
760: -- Debug Message
761: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generate Order by Ends');
762:
763: END Gen_rs_camp_order_cl;
764:
765: -- This procedure bind the variables for the Dynamic SQL

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

772: BEGIN
773: -- Bind variables
774: -- Only those that are not NULL
775: -- Debug Message
776: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Bind Variables Begins');
777:
778:
779: -- The following example applies to all columns,
780: -- developers can copy and paste them.

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

785:
786: END IF;
787:
788: -- Debug Message
789: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Bind Variables Ends');
790:
791: END Bind;
792:
793: PROCEDURE Gen_Select(

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

795: )
796: IS
797: BEGIN
798: -- Debug Message
799: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generate Select Begins');
800:
801:
802: x_select_cl := 'Select ' ||
803: 'AST_TEST.RS_CAMPAIGN_ID,' ||

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

813: 'AST_TEST.LAST_UPDATE_DATE,' ||
814: 'AST_TEST.LAST_UPDATE_LOGIN,' ||
815: 'from AST_TEST';
816: -- Debug Message
817: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generate Select Ends');
818:
819:
820: END Gen_Select;
821:

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

838: str_csr2 NUMBER;
839: l_operator VARCHAR2(10);
840: BEGIN
841: -- Debug Message
842: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generate Where Begins');
843:
844:
845: -- There are three examples for each kind of datatype:
846: -- NUMBER, DATE, VARCHAR2.

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

929:
930: -- Add more IF statements for each column below
931:
932: -- Debug Message
933: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generate Where Ends');
934:
935:
936: END Gen_rs_camp_Where;
937:

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

1013: END IF;
1014:
1015:
1016: -- Debug Message
1017: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
1018:
1019:
1020:
1021: -- Initialize API return status to SUCCESS

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

1042: -- Doing this for performance. Indexes are disabled when using NVL within static SQL statement.
1043:
1044: -- Ignore condition when criteria is NULL
1045: -- Debug Message
1046: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Generating Dsql');
1047:
1048: -- Generate Select clause and From clause
1049: -- Hint: Developer should modify Gen_Select procedure.
1050: Gen_Select(l_select_cl);

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

1090:
1091:
1092:
1093: -- Debug Message
1094: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Open and Parse Cursor');
1095:
1096:
1097: l_cur_get_rs_camp := dbms_sql.open_cursor;
1098:

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

1119: Define_Columns(l_crit_rs_camp_rec, l_cur_get_rs_camp);
1120:
1121: -- Execute
1122: -- Debug Message
1123: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Execute Dsql');
1124:
1125:
1126: l_ignore := dbms_sql.execute(l_cur_get_rs_camp);
1127:

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

1125:
1126: l_ignore := dbms_sql.execute(l_cur_get_rs_camp);
1127:
1128: -- Debug Message
1129: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Fetch Results');
1130:
1131:
1132: -- This loop is here to avoid calling a function in the main
1133: -- cursor. Basically, calling this function seems to disable

Line 1145: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: found');

1141: IF((dbms_sql.fetch_rows(l_cur_get_rs_camp)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1142: OR (l_returned_rec_count 1143: THEN
1144: -- Debug Message
1145: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: found');
1146:
1147:
1148:
1149: -- Hint: Developer need to implement this part

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

1176: -- End of API body
1177: --
1178:
1179: -- Debug Message
1180: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
1181:
1182:
1183:
1184: -- Standard call to get message count and if count is 1, get message info.

Line 1192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1188: );
1189:
1190: EXCEPTION
1191: WHEN FND_API.G_EXC_ERROR THEN
1192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1193: P_API_NAME => L_API_NAME
1194: ,P_PKG_NAME => G_PKG_NAME
1195: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1196: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1196: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1192: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1193: P_API_NAME => L_API_NAME
1194: ,P_PKG_NAME => G_PKG_NAME
1195: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1196: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1197: ,X_MSG_COUNT => X_MSG_COUNT
1198: ,X_MSG_DATA => X_MSG_DATA
1199: ,X_RETURN_STATUS => X_RETURN_STATUS);
1200:

Line 1202: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1198: ,X_MSG_DATA => X_MSG_DATA
1199: ,X_RETURN_STATUS => X_RETURN_STATUS);
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1203: P_API_NAME => L_API_NAME
1204: ,P_PKG_NAME => G_PKG_NAME
1205: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1206: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1206: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1202: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1203: P_API_NAME => L_API_NAME
1204: ,P_PKG_NAME => G_PKG_NAME
1205: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1206: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1207: ,X_MSG_COUNT => X_MSG_COUNT
1208: ,X_MSG_DATA => X_MSG_DATA
1209: ,X_RETURN_STATUS => X_RETURN_STATUS);
1210:

Line 1212: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1208: ,X_MSG_DATA => X_MSG_DATA
1209: ,X_RETURN_STATUS => X_RETURN_STATUS);
1210:
1211: WHEN OTHERS THEN
1212: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1213: P_API_NAME => L_API_NAME
1214: ,P_PKG_NAME => G_PKG_NAME
1215: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1216: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1215: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1211: WHEN OTHERS THEN
1212: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1213: P_API_NAME => L_API_NAME
1214: ,P_PKG_NAME => G_PKG_NAME
1215: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1216: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1217: ,X_MSG_COUNT => X_MSG_COUNT
1218: ,X_MSG_DATA => X_MSG_DATA
1219: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1216: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1212: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1213: P_API_NAME => L_API_NAME
1214: ,P_PKG_NAME => G_PKG_NAME
1215: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1216: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1217: ,X_MSG_COUNT => X_MSG_COUNT
1218: ,X_MSG_DATA => X_MSG_DATA
1219: ,X_RETURN_STATUS => X_RETURN_STATUS);
1220: End Get_rs_camp;

Line 1227: -- 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.

1223: PROCEDURE Validate_RS_CAMPAIGN_ID (
1224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1225: P_Validation_mode IN VARCHAR2,
1226: P_RS_CAMPAIGN_ID IN NUMBER,
1227: -- 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.
1228:
1229: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1230: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1231: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1249: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(RS_CAMPAIGN_ID)');

1245:
1246: -- validate NOT NULL column
1247: IF(p_RS_CAMPAIGN_ID is NULL)
1248: THEN
1249: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(RS_CAMPAIGN_ID)');
1250:
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: END IF;
1253:

Line 1254: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1250:
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: END IF;
1253:
1254: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1255: THEN
1256: -- Hint: Validate data
1257: -- IF p_RS_CAMPAIGN_ID is not NULL and p_RS_CAMPAIGN_ID <> G_MISS_CHAR
1258: -- verify if data is valid

Line 1261: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1257: -- IF p_RS_CAMPAIGN_ID is not NULL and p_RS_CAMPAIGN_ID <> G_MISS_CHAR
1258: -- verify if data is valid
1259: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1260: NULL;
1261: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1262: THEN
1263: -- Hint: Validate data
1264: -- IF p_RS_CAMPAIGN_ID <> G_MISS_CHAR
1265: -- verify if data is valid

Line 1283: -- 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.

1279: PROCEDURE Validate_RESOURCE_ID (
1280: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1281: P_Validation_mode IN VARCHAR2,
1282: P_RESOURCE_ID IN NUMBER,
1283: -- 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.
1284:
1285: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1286: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1287: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1305: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(RESOURCE_ID)');

1301:
1302: -- validate NOT NULL column
1303: IF(p_RESOURCE_ID is NULL)
1304: THEN
1305: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(RESOURCE_ID)');
1306:
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: END IF;
1309:

Line 1310: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1306:
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: END IF;
1309:
1310: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1311: THEN
1312: -- Hint: Validate data
1313: -- IF p_RESOURCE_ID is not NULL and p_RESOURCE_ID <> G_MISS_CHAR
1314: -- verify if data is valid

Line 1317: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1313: -- IF p_RESOURCE_ID is not NULL and p_RESOURCE_ID <> G_MISS_CHAR
1314: -- verify if data is valid
1315: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1316: NULL;
1317: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1318: THEN
1319: -- Hint: Validate data
1320: -- IF p_RESOURCE_ID <> G_MISS_CHAR
1321: -- verify if data is valid

Line 1339: -- 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.

1335: PROCEDURE Validate_CAMPAIGN_ID (
1336: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1337: P_Validation_mode IN VARCHAR2,
1338: P_CAMPAIGN_ID IN NUMBER,
1339: -- 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.
1340:
1341: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1342: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1343: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1361: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(CAMPAIGN_ID)');

1357:
1358: -- validate NOT NULL column
1359: IF(p_CAMPAIGN_ID is NULL)
1360: THEN
1361: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(CAMPAIGN_ID)');
1362:
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: END IF;
1365:

Line 1366: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1362:
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: END IF;
1365:
1366: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1367: THEN
1368: -- Hint: Validate data
1369: -- IF p_CAMPAIGN_ID is not NULL and p_CAMPAIGN_ID <> G_MISS_CHAR
1370: -- verify if data is valid

Line 1373: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1369: -- IF p_CAMPAIGN_ID is not NULL and p_CAMPAIGN_ID <> G_MISS_CHAR
1370: -- verify if data is valid
1371: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1372: NULL;
1373: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1374: THEN
1375: -- Hint: Validate data
1376: -- IF p_CAMPAIGN_ID <> G_MISS_CHAR
1377: -- verify if data is valid

Line 1395: -- 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.

1391: PROCEDURE Validate_START_DATE (
1392: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1393: P_Validation_mode IN VARCHAR2,
1394: P_START_DATE IN DATE,
1395: -- 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:
1397: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1398: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1399: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1414: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1410:
1411: -- Initialize API return status to SUCCESS
1412: x_return_status := FND_API.G_RET_STS_SUCCESS;
1413:
1414: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1415: THEN
1416: -- Hint: Validate data
1417: -- IF p_START_DATE is not NULL and p_START_DATE <> G_MISS_CHAR
1418: -- verify if data is valid

Line 1421: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1417: -- IF p_START_DATE is not NULL and p_START_DATE <> G_MISS_CHAR
1418: -- verify if data is valid
1419: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1420: NULL;
1421: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1422: THEN
1423: -- Hint: Validate data
1424: -- IF p_START_DATE <> G_MISS_CHAR
1425: -- verify if data is valid

Line 1443: -- 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.

1439: PROCEDURE Validate_END_DATE (
1440: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1441: P_Validation_mode IN VARCHAR2,
1442: P_END_DATE IN DATE,
1443: -- 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:
1445: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1446: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1447: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1462: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1458:
1459: -- Initialize API return status to SUCCESS
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;
1461:
1462: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1463: THEN
1464: -- Hint: Validate data
1465: -- IF p_END_DATE is not NULL and p_END_DATE <> G_MISS_CHAR
1466: -- verify if data is valid

Line 1469: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1465: -- IF p_END_DATE is not NULL and p_END_DATE <> G_MISS_CHAR
1466: -- verify if data is valid
1467: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1468: NULL;
1469: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1470: THEN
1471: -- Hint: Validate data
1472: -- IF p_END_DATE <> G_MISS_CHAR
1473: -- verify if data is valid

Line 1491: -- 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.

1487: PROCEDURE Validate_STATUS (
1488: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1489: P_Validation_mode IN VARCHAR2,
1490: P_STATUS IN VARCHAR2,
1491: -- 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.
1492:
1493: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1494: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1495: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1513: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(STATUS)');

1509:
1510: -- validate NOT NULL column
1511: IF(p_STATUS is NULL)
1512: THEN
1513: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(STATUS)');
1514:
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: END IF;
1517:

Line 1518: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1514:
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: END IF;
1517:
1518: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1519: THEN
1520: -- Hint: Validate data
1521: -- IF p_STATUS is not NULL and p_STATUS <> G_MISS_CHAR
1522: -- verify if data is valid

Line 1525: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1521: -- IF p_STATUS is not NULL and p_STATUS <> G_MISS_CHAR
1522: -- verify if data is valid
1523: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1524: NULL;
1525: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1526: THEN
1527: -- Hint: Validate data
1528: -- IF p_STATUS <> G_MISS_CHAR
1529: -- verify if data is valid

Line 1547: -- 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.

1543: PROCEDURE Validate_ENABLED_FLAG (
1544: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1545: P_Validation_mode IN VARCHAR2,
1546: P_ENABLED_FLAG IN VARCHAR2,
1547: -- 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.
1548:
1549: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1550: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1551: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1569: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(ENABLED_FLAG)');

1565:
1566: -- validate NOT NULL column
1567: IF(p_ENABLED_FLAG is NULL)
1568: THEN
1569: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'AST', 'Private rs_camp API: -Violate NOT NULL constraint(ENABLED_FLAG)');
1570:
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: END IF;
1573:

Line 1574: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1570:
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: END IF;
1573:
1574: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1575: THEN
1576: -- Hint: Validate data
1577: -- IF p_ENABLED_FLAG is not NULL and p_ENABLED_FLAG <> G_MISS_CHAR
1578: -- verify if data is valid

Line 1581: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1577: -- IF p_ENABLED_FLAG is not NULL and p_ENABLED_FLAG <> G_MISS_CHAR
1578: -- verify if data is valid
1579: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1580: NULL;
1581: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1582: THEN
1583: -- Hint: Validate data
1584: -- IF p_ENABLED_FLAG <> G_MISS_CHAR
1585: -- verify if data is valid

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

1596: END Validate_ENABLED_FLAG;
1597:
1598:
1599: -- Hint: inter-field level validation can be added here.
1600: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1601: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1602:
1603: -- stored in database table.
1604: PROCEDURE Validate_rs_camp_rec(

Line 1631: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'API_INVALID_RECORD');

1627: -- THEN
1628: -- x_return_status := FND_API.G_RET_STS_ERROR;
1629:
1630: -- Debug Message
1631: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'API_INVALID_RECORD');
1632:
1633: -- Standard call to get message count and if count is 1, get message info.
1634: FND_MSG_PUB.Count_And_Get
1635: ( p_count => x_msg_count,

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

1651: l_api_name CONSTANT VARCHAR2(30) := 'Validate_rs_camp';
1652: BEGIN
1653:
1654: -- Debug Message
1655: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
1656:
1657:
1658:
1659: -- Initialize API return status to SUCCESS

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

1658:
1659: -- Initialize API return status to SUCCESS
1660: x_return_status := FND_API.G_RET_STS_SUCCESS;
1661:
1662: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1663: -- Hint: We provide validation procedure for every column. Developer should delete
1664: -- unnecessary validation procedures.
1665: Validate_RS_CAMPAIGN_ID(
1666: p_init_msg_list => FND_API.G_FALSE,

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

1755: END IF;
1756:
1757: END IF;
1758:
1759: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1760: -- Hint: Inter-field level validation can be added here
1761: -- invoke record level validation procedures
1762: Validate_rs_camp_Rec(
1763: p_init_msg_list => FND_API.G_FALSE,

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

1771: raise FND_API.G_EXC_ERROR;
1772: END IF;
1773: END IF;
1774:
1775: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1776: -- invoke inter-record level validation procedures
1777: NULL;
1778: END IF;
1779:

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

1776: -- invoke inter-record level validation procedures
1777: NULL;
1778: END IF;
1779:
1780: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1781: -- invoke inter-entity level validation procedures
1782: NULL;
1783: END IF;
1784:

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

1783: END IF;
1784:
1785:
1786: -- Debug Message
1787: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
1788:
1789:
1790: END Validate_rs_camp;
1791: