[Home] [Help]
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55:
56: -- Debug Message
53: END IF;
54:
55:
56: -- Debug Message
57: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
58:
59: -- Initialize API return status to SUCCESS
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
66: -- Validate Environment
67: -- ******************************************************************
68: /* IF FND_GLOBAL.User_Id IS NULL
69: THEN
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
73: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
74: FND_MSG_PUB.ADD;
70: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
71: THEN
72: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
73: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
74: FND_MSG_PUB.ADD;
75: END IF;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78:
96:
97: END IF;
98: */
99: -- Debug Message
100: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
101:
102: -- Invoke table handler(CSP_REQUIREMENT_LINES_PKG.Insert_Row)
103: FOR I IN 1..P_Requirement_Line_Tbl.COUNT LOOP
104:
165: END IF;
166: */
167:
168: -- Debug Message
169: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
170:
171:
172: -- Standard call to get message count and if count is 1, get message info.
173: /* FND_MSG_PUB.Count_And_Get
169: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
170:
171:
172: -- Standard call to get message count and if count is 1, get message info.
173: /* FND_MSG_PUB.Count_And_Get
174: ( p_count => x_msg_count,
175: p_data => x_msg_data
176: ); */
177:
179: WHEN FND_API.G_EXC_ERROR THEN
180: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
181: P_API_NAME => L_API_NAME
182: ,P_PKG_NAME => G_PKG_NAME
183: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
184: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
185: ,X_MSG_COUNT => X_MSG_COUNT
186: ,X_MSG_DATA => X_MSG_DATA
187: ,X_RETURN_STATUS => X_RETURN_STATUS);
188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
190: P_API_NAME => L_API_NAME
191: ,P_PKG_NAME => G_PKG_NAME
192: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
193: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
194: ,X_MSG_COUNT => X_MSG_COUNT
195: ,X_MSG_DATA => X_MSG_DATA
196: ,X_RETURN_STATUS => X_RETURN_STATUS);
198: Rollback to CREATE_Requirement_lines_PUB;
199: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
200: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
201: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
202: FND_MSG_PUB.ADD;
203: fnd_msg_pub.count_and_get
204: ( p_count => x_msg_count
205: , p_data => x_msg_data);
206: x_return_status := FND_API.G_RET_STS_ERROR;
199: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
200: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
201: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
202: FND_MSG_PUB.ADD;
203: fnd_msg_pub.count_and_get
204: ( p_count => x_msg_count
205: , p_data => x_msg_data);
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: End Create_requirement_lines;
284:
285: -- Initialize message list if p_init_msg_list is set to TRUE.
286: IF FND_API.to_Boolean( p_init_msg_list )
287: THEN
288: FND_MSG_PUB.initialize;
289: END IF;
290:
291:
292: -- Debug Message
289: END IF;
290:
291:
292: -- Debug Message
293: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
294:
295:
296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: -- Debug Message
300: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
301:
302: /*
303: Open C_Get_requirement_lines( l_tar_Requirement_Lines_rec.REQUIREMENT_LINE_ID);
304:
340: l_ref_Requirement_Lines_rec.ATTRIBUTE14,
341: l_ref_Requirement_Lines_rec.ATTRIBUTE15,
342:
343: If ( C_Get_requirement_lines%NOTFOUND) Then
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
345: THEN
346: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
347: FND_MESSAGE.Set_Token ('INFO', 'requirement_lines', FALSE);
348: FND_MSG_PUB.Add;
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
345: THEN
346: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
347: FND_MESSAGE.Set_Token ('INFO', 'requirement_lines', FALSE);
348: FND_MSG_PUB.Add;
349: END IF;
350: Close C_Get_requirement_lines;
351: raise FND_API.G_EXC_ERROR;
352: END IF;
350: Close C_Get_requirement_lines;
351: raise FND_API.G_EXC_ERROR;
352: END IF;
353: -- Debug Message
354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
355: Close C_Get_requirement_lines;
356:
357:
358:
357:
358:
359: If (l_tar_Requirement_Lines_rec.last_update_date is NULL or
360: l_tar_Requirement_Lines_rec.last_update_date = FND_API.G_MISS_Date ) Then
361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
362: THEN
363: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
364: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
365: FND_MSG_PUB.ADD;
361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
362: THEN
363: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
364: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
365: FND_MSG_PUB.ADD;
366: END IF;
367: raise FND_API.G_EXC_ERROR;
368: End if;
369: -- Check Whether record has been changed by someone else
367: raise FND_API.G_EXC_ERROR;
368: End if;
369: -- Check Whether record has been changed by someone else
370: If (l_tar_Requirement_Lines_rec.last_update_date <> l_ref_Requirement_Lines_rec.last_update_date) Then
371: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
372: THEN
373: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
374: FND_MESSAGE.Set_Token('INFO', 'requirement_lines', FALSE);
375: FND_MSG_PUB.ADD;
371: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
372: THEN
373: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
374: FND_MESSAGE.Set_Token('INFO', 'requirement_lines', FALSE);
375: FND_MSG_PUB.ADD;
376: END IF;
377: raise FND_API.G_EXC_ERROR;
378: End if;
379:
377: raise FND_API.G_EXC_ERROR;
378: End if;
379:
380: -- Debug message
381: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_requirement_lines');
382:
383: -- Invoke validation procedures
384: Validate_requirement_lines(
385: p_init_msg_list => FND_API.G_FALSE,
415: -- ,x_msg_data => x_msg_data
416: -- ,x_access_flag => l_access_flag);
417:
418: -- IF l_access_flag <> 'Y' THEN
419: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
420: -- 'API_NO_UPDATE_PRIVILEGE');
421: -- END IF;
422:
423:
428: END IF;
429: -- Hint: Add corresponding Master-Detail business logic here if necessary.
430: */
431: -- Debug Message
432: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
433:
434: -- Invoke table handler(CSP_REQUIREMENT_LINES_PKG.Update_Row)
435: FOR I IN 1..P_Requirement_Line_Tbl.COUNT LOOP
436: l_requirement_line_rec := p_requirement_line_tbl(I);
490: END IF;
491:
492:
493: -- Debug Message
494: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
495:
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: /* FND_MSG_PUB.Count_And_Get
494: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
495:
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: /* FND_MSG_PUB.Count_And_Get
499: ( p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502: */
504: WHEN FND_API.G_EXC_ERROR THEN
505: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
506: P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME
508: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
509: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
510: ,X_MSG_COUNT => X_MSG_COUNT
511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
514: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
515: P_API_NAME => L_API_NAME
516: ,P_PKG_NAME => G_PKG_NAME
517: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
518: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
519: ,X_MSG_COUNT => X_MSG_COUNT
520: ,X_MSG_DATA => X_MSG_DATA
521: ,X_RETURN_STATUS => X_RETURN_STATUS);
523: Rollback to UPDATE_Requirement_Lines_PUB;
524: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
525: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
526: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
527: FND_MSG_PUB.ADD;
528: fnd_msg_pub.count_and_get
529: ( p_count => x_msg_count
530: , p_data => x_msg_data);
531: x_return_status := FND_API.G_RET_STS_ERROR;
524: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
525: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
526: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
527: FND_MSG_PUB.ADD;
528: fnd_msg_pub.count_and_get
529: ( p_count => x_msg_count
530: , p_data => x_msg_data);
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: End Update_requirement_lines;
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE.
567: IF FND_API.to_Boolean( p_init_msg_list )
568: THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:
572:
573: -- Debug Message
570: END IF;
571:
572:
573: -- Debug Message
574: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
575:
576:
577: -- Initialize API return status to SUCCESS
578: x_return_status := FND_API.G_RET_STS_SUCCESS;
580: --
581: -- Api body
582: --
583: -- Debug Message
584: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
585:
586: -- Invoke table handler(CSP_REQUIREMENT_LINES_PKG.Delete_Row)
587: FOR I IN 1..P_Requirement_Line_Tbl.COUNT LOOP
588: l_requirement_line_rec := p_requirement_Line_Tbl(I);
602: END IF;
603:
604:
605: -- Debug Message
606: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
606: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get
611: ( p_count => x_msg_count,
612: p_data => x_msg_data
613: );
614:
616: WHEN FND_API.G_EXC_ERROR THEN
617: JTF_PLSQL_API.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 => JTF_PLSQL_API.G_PUB
622: ,X_MSG_COUNT => X_MSG_COUNT
623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
627: P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
630: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);
635: Rollback to DELETE_Requirement_Lines_PUB;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count
642: , p_data => x_msg_data);
643: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
637: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
638: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
639: FND_MSG_PUB.ADD;
640: fnd_msg_pub.count_and_get
641: ( p_count => x_msg_count
642: , p_data => x_msg_data);
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: End Delete_requirement_lines;
651: )
652: IS
653: BEGIN
654: -- Debug Message
655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
656:
657: -- define all columns for CSP_REQUIREMENT_LINES view
658: dbms_sql.define_column(p_cur_get_Requirement_Lines, 1, p_requirement_line_rec.REQUIREMENT_LINE_ID);
659: dbms_sql.define_column(p_cur_get_Requirement_Lines, 2, p_requirement_line_rec.REQUIREMENT_HEADER_ID);
686: dbms_sql.define_column(p_cur_get_Requirement_Lines, 29, p_requirement_line_rec.ATTRIBUTE14, 150);
687: dbms_sql.define_column(p_cur_get_Requirement_Lines, 30, p_requirement_line_rec.ATTRIBUTE15, 150);
688:
689: -- Debug Message
690: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
691: END Define_Columns;
692:
693: -- This procudure gets column values by the Dynamic SQL.
694: PROCEDURE Get_Column_Values(
697: )
698: IS
699: BEGIN
700: -- Debug Message
701: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');
702:
703: -- get all column values for CSP_REQUIREMENT_LINES table
704: dbms_sql.column_value(p_cur_get_Requirement_Lines, 1, X_Requirement_Lines_Rec.REQUIREMENT_LINE_ID);
705: dbms_sql.column_value(p_cur_get_Requirement_Lines, 2, X_Requirement_Lines_Rec.REQUIREMENT_HEADER_ID);
732: dbms_sql.column_value(p_cur_get_Requirement_Lines, 29, X_Requirement_Lines_Rec.ATTRIBUTE14);
733: dbms_sql.column_value(p_cur_get_Requirement_Lines, 30, X_Requirement_Lines_Rec.ATTRIBUTE15);
734:
735: -- Debug Message
736: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
737: END Get_Column_Values;
738:
739: PROCEDURE Gen_Requirement_Lines_order_cl(
740: p_order_by_rec IN CSP_Requirement_Lines_PUB.Requirement_Lines_sort_rec_type,
747: l_order_by_cl VARCHAR2(1000) := NULL;
748: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;
749: BEGIN
750: -- Debug Message
751: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');
752:
753: -- Hint: Developer should add more statements according to CSP_sort_rec_type
754: -- Ex:
755: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
755: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
756: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
757:
758: -- Debug Message
759: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke AS_UTILITY_PVT.Translate_OrderBy');
760:
761: AS_UTILITY_PVT.Translate_OrderBy(
762: p_api_version_number => 1.0
763: ,p_init_msg_list => FND_API.G_FALSE
774: x_order_by_cl := NULL;
775: END IF;
776:
777: -- Debug Message
778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Ends');
779: END Gen_Requirement_Lines_order_cl;
780:
781: -- This procedure bind the variables for the Dynamic SQL
782: PROCEDURE Bind(
788: BEGIN
789: -- Bind variables
790: -- Only those that are not NULL
791: -- Debug Message
792: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
793:
794: -- The following example applies to all columns,
795: -- developers can copy and paste them.
796: IF( (p_requirement_line_rec.REQUIREMENT_LINE_ID IS NOT NULL) AND (p_requirement_line_rec.REQUIREMENT_LINE_ID <> FND_API.G_MISS_NUM) )
798: DBMS_SQL.BIND_VARIABLE(p_cur_get_Requirement_Lines, ':p_REQUIREMENT_LINE_ID', p_requirement_line_rec.REQUIREMENT_LINE_ID);
799: END IF;
800:
801: -- Debug Message
802: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
803: END Bind;
804:
805: PROCEDURE Gen_Select(
806: x_select_cl OUT NOCOPY VARCHAR2
807: )
808: IS
809: BEGIN
810: -- Debug Message
811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
812:
813: x_select_cl := 'Select ' ||
814: 'CSP_REQUIREMENT_LINES.REQUIREMENT_LINE_ID,' ||
815: 'CSP_REQUIREMENT_LINES.CREATED_BY,' ||
847: 'CSP_REQUIREMENT_LINES.ATTRIBUTE14,' ||
848: 'CSP_REQUIREMENT_LINES.ATTRIBUTE15,' ||
849: 'from CSP_REQUIREMENT_LINES';
850: -- Debug Message
851: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
852:
853: END Gen_Select;
854:
855: PROCEDURE Gen_Requirement_Lines_Where(
871: str_csr2 NUMBER;
872: l_operator VARCHAR2(10);
873: BEGIN
874: -- Debug Message
875: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
876:
877: -- There are three examples for each kind of datatype:
878: -- NUMBER, DATE, VARCHAR2.
879: -- Developer can copy and paste the following codes for your own record.
957:
958: -- Add more IF statements for each column below
959:
960: -- Debug Message
961: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
962:
963: END Gen_Requirement_Lines_Where;
964:
965: -- Item-level validation procedures
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list )
980: THEN
981: FND_MSG_PUB.initialize;
982: END IF;
983:
984:
985: -- Initialize API return status to SUCCESS
1008: NULL;
1009: END IF;
1010:
1011: -- Standard call to get message count and if count is 1, get message info.
1012: FND_MSG_PUB.Count_And_Get
1013: ( p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );
1016:
1031:
1032: -- Initialize message list if p_init_msg_list is set to TRUE.
1033: IF FND_API.to_Boolean( p_init_msg_list )
1034: THEN
1035: FND_MSG_PUB.initialize;
1036: END IF;
1037:
1038:
1039: -- Initialize API return status to SUCCESS
1062: NULL;
1063: END IF;
1064:
1065: -- Standard call to get message count and if count is 1, get message info.
1066: FND_MSG_PUB.Count_And_Get
1067: ( p_count => x_msg_count,
1068: p_data => x_msg_data
1069: );
1070:
1085:
1086: -- Initialize message list if p_init_msg_list is set to TRUE.
1087: IF FND_API.to_Boolean( p_init_msg_list )
1088: THEN
1089: FND_MSG_PUB.initialize;
1090: END IF;
1091:
1092:
1093: -- Initialize API return status to SUCCESS
1116: NULL;
1117: END IF;
1118:
1119: -- Standard call to get message count and if count is 1, get message info.
1120: FND_MSG_PUB.Count_And_Get
1121: ( p_count => x_msg_count,
1122: p_data => x_msg_data
1123: );
1124:
1139:
1140: -- Initialize message list if p_init_msg_list is set to TRUE.
1141: IF FND_API.to_Boolean( p_init_msg_list )
1142: THEN
1143: FND_MSG_PUB.initialize;
1144: END IF;
1145:
1146:
1147: -- Initialize API return status to SUCCESS
1170: NULL;
1171: END IF;
1172:
1173: -- Standard call to get message count and if count is 1, get message info.
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_count => x_msg_count,
1176: p_data => x_msg_data
1177: );
1178:
1193:
1194: -- Initialize message list if p_init_msg_list is set to TRUE.
1195: IF FND_API.to_Boolean( p_init_msg_list )
1196: THEN
1197: FND_MSG_PUB.initialize;
1198: END IF;
1199:
1200:
1201: -- Initialize API return status to SUCCESS
1224: NULL;
1225: END IF;
1226:
1227: -- Standard call to get message count and if count is 1, get message info.
1228: FND_MSG_PUB.Count_And_Get
1229: ( p_count => x_msg_count,
1230: p_data => x_msg_data
1231: );
1232:
1247:
1248: -- Initialize message list if p_init_msg_list is set to TRUE.
1249: IF FND_API.to_Boolean( p_init_msg_list )
1250: THEN
1251: FND_MSG_PUB.initialize;
1252: END IF;
1253:
1254:
1255: -- Initialize API return status to SUCCESS
1271: NULL;
1272: END IF;
1273:
1274: -- Standard call to get message count and if count is 1, get message info.
1275: FND_MSG_PUB.Count_And_Get
1276: ( p_count => x_msg_count,
1277: p_data => x_msg_data
1278: );
1279:
1294:
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list )
1297: THEN
1298: FND_MSG_PUB.initialize;
1299: END IF;
1300:
1301:
1302: -- Initialize API return status to SUCCESS
1318: NULL;
1319: END IF;
1320:
1321: -- Standard call to get message count and if count is 1, get message info.
1322: FND_MSG_PUB.Count_And_Get
1323: ( p_count => x_msg_count,
1324: p_data => x_msg_data
1325: );
1326:
1341:
1342: -- Initialize message list if p_init_msg_list is set to TRUE.
1343: IF FND_API.to_Boolean( p_init_msg_list )
1344: THEN
1345: FND_MSG_PUB.initialize;
1346: END IF;
1347:
1348:
1349: -- Initialize API return status to SUCCESS
1365: NULL;
1366: END IF;
1367:
1368: -- Standard call to get message count and if count is 1, get message info.
1369: FND_MSG_PUB.Count_And_Get
1370: ( p_count => x_msg_count,
1371: p_data => x_msg_data
1372: );
1373:
1388:
1389: -- Initialize message list if p_init_msg_list is set to TRUE.
1390: IF FND_API.to_Boolean( p_init_msg_list )
1391: THEN
1392: FND_MSG_PUB.initialize;
1393: END IF;
1394:
1395:
1396: -- Initialize API return status to SUCCESS
1412: NULL;
1413: END IF;
1414:
1415: -- Standard call to get message count and if count is 1, get message info.
1416: FND_MSG_PUB.Count_And_Get
1417: ( p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );
1420:
1435:
1436: -- Initialize message list if p_init_msg_list is set to TRUE.
1437: IF FND_API.to_Boolean( p_init_msg_list )
1438: THEN
1439: FND_MSG_PUB.initialize;
1440: END IF;
1441:
1442:
1443: -- Initialize API return status to SUCCESS
1459: NULL;
1460: END IF;
1461:
1462: -- Standard call to get message count and if count is 1, get message info.
1463: FND_MSG_PUB.Count_And_Get
1464: ( p_count => x_msg_count,
1465: p_data => x_msg_data
1466: );
1467:
1482:
1483: -- Initialize message list if p_init_msg_list is set to TRUE.
1484: IF FND_API.to_Boolean( p_init_msg_list )
1485: THEN
1486: FND_MSG_PUB.initialize;
1487: END IF;
1488:
1489:
1490: -- Initialize API return status to SUCCESS
1506: NULL;
1507: END IF;
1508:
1509: -- Standard call to get message count and if count is 1, get message info.
1510: FND_MSG_PUB.Count_And_Get
1511: ( p_count => x_msg_count,
1512: p_data => x_msg_data
1513: );
1514:
1529:
1530: -- Initialize message list if p_init_msg_list is set to TRUE.
1531: IF FND_API.to_Boolean( p_init_msg_list )
1532: THEN
1533: FND_MSG_PUB.initialize;
1534: END IF;
1535:
1536:
1537: -- Initialize API return status to SUCCESS
1553: NULL;
1554: END IF;
1555:
1556: -- Standard call to get message count and if count is 1, get message info.
1557: FND_MSG_PUB.Count_And_Get
1558: ( p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561:
1576:
1577: -- Initialize message list if p_init_msg_list is set to TRUE.
1578: IF FND_API.to_Boolean( p_init_msg_list )
1579: THEN
1580: FND_MSG_PUB.initialize;
1581: END IF;
1582:
1583:
1584: -- Initialize API return status to SUCCESS
1600: NULL;
1601: END IF;
1602:
1603: -- Standard call to get message count and if count is 1, get message info.
1604: FND_MSG_PUB.Count_And_Get
1605: ( p_count => x_msg_count,
1606: p_data => x_msg_data
1607: );
1608:
1623:
1624: -- Initialize message list if p_init_msg_list is set to TRUE.
1625: IF FND_API.to_Boolean( p_init_msg_list )
1626: THEN
1627: FND_MSG_PUB.initialize;
1628: END IF;
1629:
1630:
1631: -- Initialize API return status to SUCCESS
1647: NULL;
1648: END IF;
1649:
1650: -- Standard call to get message count and if count is 1, get message info.
1651: FND_MSG_PUB.Count_And_Get
1652: ( p_count => x_msg_count,
1653: p_data => x_msg_data
1654: );
1655:
1673:
1674: -- Initialize message list if p_init_msg_list is set to TRUE.
1675: IF FND_API.to_Boolean( p_init_msg_list )
1676: THEN
1677: FND_MSG_PUB.initialize;
1678: END IF;
1679:
1680:
1681: -- Initialize API return status to SUCCESS
1686: -- THEN
1687: -- x_return_status := FND_API.G_RET_STS_ERROR;
1688:
1689: -- Debug Message
1690: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1691:
1692: -- Standard call to get message count and if count is 1, get message info.
1693: FND_MSG_PUB.Count_And_Get
1694: ( p_count => x_msg_count,
1689: -- Debug Message
1690: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1691:
1692: -- Standard call to get message count and if count is 1, get message info.
1693: FND_MSG_PUB.Count_And_Get
1694: ( p_count => x_msg_count,
1695: p_data => x_msg_data
1696: );
1697:
1710: l_api_name CONSTANT VARCHAR2(30) := 'Validate_requirement_lines';
1711: BEGIN
1712:
1713: -- Debug Message
1714: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1715:
1716:
1717: -- Initialize API return status to SUCCESS
1718: x_return_status := FND_API.G_RET_STS_SUCCESS;
1917: END IF;
1918:
1919:
1920: -- Debug Message
1921: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1922:
1923: END Validate_requirement_lines;
1924:
1925: */