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.AML_TIMEFRAME_PVT dependencies on AS_UTILITY_PVT

Line 78: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

74:
75: -- Debug Message
76: IF (AS_DEBUG_LOW_ON) THEN
77:
78: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
79: END IF;
80:
81:
82: -- Initialize API return status to SUCCESS

Line 116: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

112:
113: -- Debug message
114: IF (AS_DEBUG_LOW_ON) THEN
115:
116: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
117: 'Pvt API: ' || l_timeframe_rec.DECISION_TIMEFRAME_CODE);
118: END IF;
119:
120:

Line 124: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

120:
121:
122: Validate_DECN_TIMEFRAME_CODE(
123: p_init_msg_list => FND_API.G_FALSE,
124: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
125: p_decision_timeframe_code => l_timeframe_rec.DECISION_TIMEFRAME_CODE,
126: x_return_status => x_return_status,
127: x_msg_count => x_msg_count,
128: x_msg_data => x_msg_data);

Line 138: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,

134:
135: -- Check the timeframe days
136: Validate_TIMEFRAME_DAYS(
137: P_Init_Msg_List => FND_API.G_FALSE,
138: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
139: p_timeframe_days => l_timeframe_rec.timeframe_days,
140: X_Return_Status => x_return_status,
141: X_Msg_Count => x_msg_count,
142: X_Msg_Data => x_msg_data

Line 153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

149:
150: -- Debug Message
151: IF (AS_DEBUG_LOW_ON) THEN
152:
153: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
154: 'Private API: Calling create table handler');
155: END IF;
156:
157: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Insert_Row)

Line 193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

189:
190: -- Debug Message
191: IF (AS_DEBUG_LOW_ON) THEN
192:
193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
194: END IF;
195:
196:
197: -- Standard call to get message count and if count is 1, get message info.

Line 205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

201: );
202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
209: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 209: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 215: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);
223:
224: WHEN OTHERS THEN
225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
226: P_API_NAME => L_API_NAME
227: ,P_PKG_NAME => G_PKG_NAME
228: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
229: ,P_SQLCODE => SQLCODE

Line 228: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

224: WHEN OTHERS THEN
225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
226: P_API_NAME => L_API_NAME
227: ,P_PKG_NAME => G_PKG_NAME
228: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
229: ,P_SQLCODE => SQLCODE
230: ,P_SQLERRM => SQLERRM
231: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
232: ,X_MSG_COUNT => X_MSG_COUNT

Line 231: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

227: ,P_PKG_NAME => G_PKG_NAME
228: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
229: ,P_SQLCODE => SQLCODE
230: ,P_SQLERRM => SQLERRM
231: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.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_timeframe;

Line 306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

302:
303: -- Debug Message
304: IF (AS_DEBUG_LOW_ON) THEN
305:
306: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
307: END IF;
308:
309:
310:

Line 322: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

318:
319: -- Debug Message
320: IF (AS_DEBUG_LOW_ON) THEN
321:
322: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
323: 'Private API: - Open Cursor to Select');
324: END IF;
325:
326:

Line 351: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

347:
348: -- Debug message
349: IF (AS_DEBUG_LOW_ON) THEN
350:
351: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
352: 'Private API: Validate_timeframe');
353: END IF;
354:
355: -- Invoke validation procedures

Line 368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

364: IF (AS_DEBUG_LOW_ON) THEN
365:
366:
367:
368: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
369: 'Private API: Validate_timeframe');
370:
371: END IF;
372:

Line 377: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

373:
374:
375: Validate_DECN_TIMEFRAME_CODE(
376: p_init_msg_list => FND_API.G_FALSE,
377: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
378: p_decision_timeframe_code => l_tar_timeframe_rec.DECISION_TIMEFRAME_CODE,
379: x_return_status => x_return_status,
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data);

Line 391: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,

387:
388: -- Check the timeframe days
389: Validate_TIMEFRAME_DAYS(
390: P_Init_Msg_List => FND_API.G_FALSE,
391: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
392: p_timeframe_days => l_tar_timeframe_rec.timeframe_days,
393: X_Return_Status => x_return_status,
394: X_Msg_Count => x_msg_count,
395: X_Msg_Data => x_msg_data

Line 426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

422:
423: -- Debug Message
424: IF (AS_DEBUG_LOW_ON) THEN
425:
426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
427: 'Private API: Calling update table handler');
428: END IF;
429:
430: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Update_Row)

Line 458: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

454:
455: -- Debug Message
456: IF (AS_DEBUG_LOW_ON) THEN
457:
458: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
459: END IF;
460:
461:
462: -- Standard call to get message count and if count is 1, get message info.

Line 470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

466: );
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN
470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
471: P_API_NAME => L_API_NAME
472: ,P_PKG_NAME => G_PKG_NAME
473: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
474: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 474: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
471: P_API_NAME => L_API_NAME
472: ,P_PKG_NAME => G_PKG_NAME
473: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
474: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
475: ,X_MSG_COUNT => X_MSG_COUNT
476: ,X_MSG_DATA => X_MSG_DATA
477: ,X_RETURN_STATUS => X_RETURN_STATUS);
478:

Line 480: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

476: ,X_MSG_DATA => X_MSG_DATA
477: ,X_RETURN_STATUS => X_RETURN_STATUS);
478:
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
481: P_API_NAME => L_API_NAME
482: ,P_PKG_NAME => G_PKG_NAME
483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
484: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 484: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 490: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

486: ,X_MSG_DATA => X_MSG_DATA
487: ,X_RETURN_STATUS => X_RETURN_STATUS);
488:
489: WHEN OTHERS THEN
490: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
494: ,P_SQLCODE => SQLCODE

Line 493: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

489: WHEN OTHERS THEN
490: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
494: ,P_SQLCODE => SQLCODE
495: ,P_SQLERRM => SQLERRM
496: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
497: ,X_MSG_COUNT => X_MSG_COUNT

Line 496: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
494: ,P_SQLCODE => SQLCODE
495: ,P_SQLERRM => SQLERRM
496: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
497: ,X_MSG_COUNT => X_MSG_COUNT
498: ,X_MSG_DATA => X_MSG_DATA
499: ,X_RETURN_STATUS => X_RETURN_STATUS);
500: End Update_timeframe;

Line 549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

545:
546: -- Debug Message
547: IF (AS_DEBUG_LOW_ON) THEN
548:
549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
550: END IF;
551:
552:
553: -- Initialize API return status to SUCCESS

Line 584: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

580:
581: -- Debug Message
582: IF (AS_DEBUG_LOW_ON) THEN
583:
584: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AML_SALES_LEAD_TIMEFRAMES_PKG.Delete_Row)

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

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

Line 617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

613: );
614:
615: EXCEPTION
616: WHEN FND_API.G_EXC_ERROR THEN
617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
621: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 621: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

617: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
621: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
622: ,X_MSG_COUNT => X_MSG_COUNT
623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);
625:

Line 627: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
631: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 631: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

627: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
631: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
632: ,X_MSG_COUNT => X_MSG_COUNT
633: ,X_MSG_DATA => X_MSG_DATA
634: ,X_RETURN_STATUS => X_RETURN_STATUS);
635:

Line 637: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

633: ,X_MSG_DATA => X_MSG_DATA
634: ,X_RETURN_STATUS => X_RETURN_STATUS);
635:
636: WHEN OTHERS THEN
637: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
638: P_API_NAME => L_API_NAME
639: ,P_PKG_NAME => G_PKG_NAME
640: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
641: ,P_SQLCODE => SQLCODE

Line 640: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

636: WHEN OTHERS THEN
637: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
638: P_API_NAME => L_API_NAME
639: ,P_PKG_NAME => G_PKG_NAME
640: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
641: ,P_SQLCODE => SQLCODE
642: ,P_SQLERRM => SQLERRM
643: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
644: ,X_MSG_COUNT => X_MSG_COUNT

Line 643: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

639: ,P_PKG_NAME => G_PKG_NAME
640: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
641: ,P_SQLCODE => SQLCODE
642: ,P_SQLERRM => SQLERRM
643: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
644: ,X_MSG_COUNT => X_MSG_COUNT
645: ,X_MSG_DATA => X_MSG_DATA
646: ,X_RETURN_STATUS => X_RETURN_STATUS);
647: End Delete_timeframe;

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

651: PROCEDURE Validate_TIMEFRAME_ID (
652: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
653: P_Validation_mode IN VARCHAR2,
654: P_TIMEFRAME_ID IN NUMBER,
655: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
656: X_Return_Status OUT NOCOPY VARCHAR2,
657: X_Msg_Count OUT NOCOPY NUMBER,
658: X_Msg_Data OUT NOCOPY VARCHAR2
659: )

Line 673: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

669:
670: -- Initialize API return status to SUCCESS
671: x_return_status := FND_API.G_RET_STS_SUCCESS;
672:
673: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
674: THEN
675: -- Hint: Validate data
676: -- IF p_TIMEFRAME_ID is not NULL and p_TIMEFRAME_ID <> G_MISS_CHAR
677: -- verify if data is valid

Line 680: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

676: -- IF p_TIMEFRAME_ID is not NULL and p_TIMEFRAME_ID <> G_MISS_CHAR
677: -- verify if data is valid
678: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
679: NULL;
680: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
681: THEN
682: -- Hint: Validate data
683: -- IF p_TIMEFRAME_ID <> G_MISS_CHAR
684: -- verify if data is valid

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

699: PROCEDURE Validate_DECN_TIMEFRAME_CODE (
700: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
701: P_Validation_mode IN VARCHAR2,
702: P_DECISION_TIMEFRAME_CODE IN VARCHAR2,
703: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
704: X_Return_Status OUT NOCOPY VARCHAR2,
705: X_Msg_Count OUT NOCOPY NUMBER,
706: X_Msg_Data OUT NOCOPY VARCHAR2
707: )

Line 738: AS_UTILITY_PVT.Set_Message(

734: FETCH C_Lookup_Exists into l_val;
735:
736: IF C_Lookup_Exists%NOTFOUND
737: THEN
738: AS_UTILITY_PVT.Set_Message(
739: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: p_msg_name => 'API_INVALID_ID',
741: p_token1 => 'COLUMN',
742: p_token1_value => 'DECISION TIMEFRAME_CODE',

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

763: PROCEDURE Validate_TIMEFRAME_DAYS (
764: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
765: P_Validation_mode IN VARCHAR2,
766: P_TIMEFRAME_DAYS IN NUMBER,
767: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
768: X_Return_Status OUT NOCOPY VARCHAR2,
769: X_Msg_Count OUT NOCOPY NUMBER,
770: X_Msg_Data OUT NOCOPY VARCHAR2
771: )

Line 788: AS_UTILITY_PVT.Set_Message(

784:
785: IF (p_timeframe_days is NOT NULL
786: AND p_timeframe_days < 0 ) THEN
787:
788: AS_UTILITY_PVT.Set_Message(
789: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
790: p_msg_name => 'API_INVALID_ID',
791: p_token1 => 'COLUMN',
792: p_token1_value => 'TIMEFRAME_DAYS',