eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_ORDERLINES_PVT dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

49:
50: -- Initialize message list if p_init_msg_list is set to TRUE.
51: IF FND_API.to_Boolean( p_init_msg_list )
52: THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56:
57: -- Debug Message

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

54: END IF;
55:
56:
57: -- Debug Message
58: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
59:
60:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

86: -- Validate Environment
87: -- ******************************************************************
88: IF FND_GLOBAL.User_Id IS NULL
89: THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
91: THEN
92: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
93: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
94: FND_MSG_PUB.ADD;

Line 94: FND_MSG_PUB.ADD;

90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
91: THEN
92: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
93: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
94: FND_MSG_PUB.ADD;
95: END IF;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:

Line 117: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderlines');

113: */
114: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
115: THEN
116: -- Debug message
117: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderlines');
118:
119: -- Invoke validation procedures
120: Validate_orderlines(
121: p_init_msg_list => FND_API.G_FALSE,

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

133:
134: -- Hint: Add corresponding Master-Detail business logic here if necessary.
135:
136: -- Debug Message
137: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling create table handler');
138:
139: -- Invoke table handler(CSP_MOVEORDER_LINES_PKG.Insert_Row)
140: CSP_MOVEORDER_LINES_PKG.Insert_Row(
141: p_LINE_ID => p_mol_rec.LINE_ID,

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

185: END IF;
186:
187:
188: -- Debug Message
189: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
190:
191:
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_Get

Line 193: FND_MSG_PUB.Count_And_Get

189: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
190:
191:
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_Get
194: ( p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197:

Line 220: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

216: WHEN FND_API.G_EXC_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_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);

Line 230: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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 => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
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 321: FND_MSG_PUB.initialize;

317:
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF FND_API.to_Boolean( p_init_msg_list )
320: THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323:
324:
325: -- Debug Message

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

322: END IF;
323:
324:
325: -- Debug Message
326: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
327:
328:
329: -- Initialize API return status to SUCCESS
330: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

366:
367: */
368:
369: -- Debug Message
370: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
371:
372: /*
373: Open C_Get_orderlines( l_tar_mol_rec.LINE_ID);
374:

Line 407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

403: l_ref_mol_rec.ATTRIBUTE14,
404: l_ref_mol_rec.ATTRIBUTE15;
405:
406: If ( C_Get_orderlines%NOTFOUND) Then
407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
408: THEN
409: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
410: FND_MESSAGE.Set_Token ('INFO', 'orderlines', FALSE);
411: FND_MSG_PUB.Add;

Line 411: FND_MSG_PUB.Add;

407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
408: THEN
409: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
410: FND_MESSAGE.Set_Token ('INFO', 'orderlines', FALSE);
411: FND_MSG_PUB.Add;
412: END IF;
413: raise FND_API.G_EXC_ERROR;
414: END IF;
415: -- Debug Message

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

412: END IF;
413: raise FND_API.G_EXC_ERROR;
414: END IF;
415: -- Debug Message
416: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Close Cursor');
417: Close C_Get_orderlines;
418: */
419:
420: /* commented out by klou, 01/07/00

Line 423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

419:
420: /* commented out by klou, 01/07/00
421: If (l_tar_mol_rec.last_update_date is NULL or
422: l_tar_mol_rec.last_update_date = FND_API.G_MISS_Date ) Then
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN
425: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
426: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
427: FND_MSG_PUB.ADD;

Line 427: FND_MSG_PUB.ADD;

423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN
425: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
426: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
427: FND_MSG_PUB.ADD;
428: END IF;
429: raise FND_API.G_EXC_ERROR;
430: End if;
431:

Line 434: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

430: End if;
431:
432: -- Check Whether record has been changed by someone else
433: If (l_tar_mol_rec.last_update_date <> l_ref_mol_rec.last_update_date) Then
434: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
435: THEN
436: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
437: FND_MESSAGE.Set_Token('INFO', 'orderlines', FALSE);
438: FND_MSG_PUB.ADD;

Line 438: FND_MSG_PUB.ADD;

434: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
435: THEN
436: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
437: FND_MESSAGE.Set_Token('INFO', 'orderlines', FALSE);
438: FND_MSG_PUB.ADD;
439: END IF;
440: raise FND_API.G_EXC_ERROR;
441: End if;
442: */

Line 446: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderlines');

442: */
443: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
444: THEN
445: -- Debug message
446: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderlines');
447:
448: -- Invoke validation procedures
449: Validate_orderlines(
450: p_init_msg_list => FND_API.G_FALSE,

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

462:
463: -- Hint: Add corresponding Master-Detail business logic here if necessary.
464:
465: -- Debug Message
466: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
467:
468: -- Invoke table handler(CSP_MOVEORDER_LINES_PKG.Update_Row)
469: CSP_MOVEORDER_LINES_PKG.Update_Row(
470: p_LINE_ID => p_mol_rec.LINE_ID,

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

506: END IF;
507:
508:
509: -- Debug Message
510: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
511:
512:
513: -- Standard call to get message count and if count is 1, get message info.
514: FND_MSG_PUB.Count_And_Get

Line 514: FND_MSG_PUB.Count_And_Get

510: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
511:
512:
513: -- Standard call to get message count and if count is 1, get message info.
514: FND_MSG_PUB.Count_And_Get
515: ( p_count => x_msg_count,
516: p_data => x_msg_data
517: );
518:

Line 542: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

538: WHEN FND_API.G_EXC_ERROR THEN
539: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
540: P_API_NAME => L_API_NAME
541: ,P_PKG_NAME => G_PKG_NAME
542: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
543: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
544: ,X_MSG_COUNT => X_MSG_COUNT
545: ,X_MSG_DATA => X_MSG_DATA
546: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 552: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
550: P_API_NAME => L_API_NAME
551: ,P_PKG_NAME => G_PKG_NAME
552: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
553: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
554: ,X_MSG_COUNT => X_MSG_COUNT
555: ,X_MSG_DATA => X_MSG_DATA
556: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 605: FND_MSG_PUB.initialize;

601:
602: -- Initialize message list if p_init_msg_list is set to TRUE.
603: IF FND_API.to_Boolean( p_init_msg_list )
604: THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607:
608:
609: -- Debug Message

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

606: END IF;
607:
608:
609: -- Debug Message
610: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
611:
612:
613: -- Initialize API return status to SUCCESS
614: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

648: RAISE FND_API.G_EXC_ERROR;
649: END IF;
650: */
651: -- Debug Message
652: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
653:
654: -- Invoke table handler(CSP_MOVEORDER_LINES_PKG.Delete_Row)
655: CSP_MOVEORDER_LINES_PKG.Delete_Row(
656: p_LINE_ID => p_mol_rec.LINE_ID);

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

665: END IF;
666:
667:
668: -- Debug Message
669: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
670:
671:
672: -- Standard call to get message count and if count is 1, get message info.
673: FND_MSG_PUB.Count_And_Get

Line 673: FND_MSG_PUB.Count_And_Get

669: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
670:
671:
672: -- Standard call to get message count and if count is 1, get message info.
673: FND_MSG_PUB.Count_And_Get
674: ( p_count => x_msg_count,
675: p_data => x_msg_data
676: );
677:

Line 701: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

697: WHEN FND_API.G_EXC_ERROR THEN
698: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
699: P_API_NAME => L_API_NAME
700: ,P_PKG_NAME => G_PKG_NAME
701: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
702: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
703: ,X_MSG_COUNT => X_MSG_COUNT
704: ,X_MSG_DATA => X_MSG_DATA
705: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 711: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
709: P_API_NAME => L_API_NAME
710: ,P_PKG_NAME => G_PKG_NAME
711: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
712: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
713: ,X_MSG_COUNT => X_MSG_COUNT
714: ,X_MSG_DATA => X_MSG_DATA
715: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

733: )
734: IS
735: BEGIN
736: -- Debug Message
737: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
738:
739: -- define all columns for CSP_MOVEORDER_LINES_V view
740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);
741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);

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

762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);
763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);
764:
765: -- Debug Message
766: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
767: END Define_Columns;
768:
769: -- This procudure gets column values by the Dynamic SQL.
770: PROCEDURE Get_Column_Values(

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

773: )
774: IS
775: BEGIN
776: -- Debug Message
777: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
778:
779: -- get all column values for CSP_MOVEORDER_LINES_V table
780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);
781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);

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

802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);
803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);
804:
805: -- Debug Message
806: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
807: END Get_Column_Values;
808:
809: PROCEDURE Gen_mol_order_cl(
810: p_order_by_rec IN CSP_ORDERLINES_PUB.mol_sort_rec_type,

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

817: l_order_by_cl VARCHAR2(1000) := NULL;
818: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
819: BEGIN
820: -- Debug Message
821: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
822:
823: -- Hint: Developer should add more statements according to CSP_sort_rec_type
824: -- Ex:
825: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

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

825: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
826: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
827:
828: -- Debug Message
829: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
830:
831: JTF_PLSQL_API.Translate_OrderBy(
832: p_api_version_number => 1.0
833: ,p_init_msg_list => FND_API.G_FALSE

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

844: x_order_by_cl := NULL;
845: END IF;
846:
847: -- Debug Message
848: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
849: END Gen_mol_order_cl;
850:
851: -- This procedure bind the variables for the Dynamic SQL
852: PROCEDURE Bind(

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

858: BEGIN
859: -- Bind variables
860: -- Only those that are not NULL
861: -- Debug Message
862: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Begins');
863:
864: -- The following example applies to all columns,
865: -- developers can copy and paste them.
866: IF( (P_mol_Rec.LINE_ID IS NOT NULL) AND (P_mol_Rec.LINE_ID <> FND_API.G_MISS_NUM) )

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

868: DBMS_SQL.BIND_VARIABLE(p_cur_get_mol, ':p_LINE_ID', P_mol_Rec.LINE_ID);
869: END IF;
870:
871: -- Debug Message
872: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
873: END Bind;
874:
875: PROCEDURE Gen_Select(
876: x_select_cl OUT NOCOPY VARCHAR2

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

877: )
878: IS
879: BEGIN
880: -- Debug Message
881: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
882:
883: x_select_cl := 'Select ' ||
884: 'CSP_MOVEORDER_LINES_V.LINE_ID,' ||
885: 'CSP_MOVEORDER_LINES_V.CREATED_BY,' ||

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

910: 'CSP_MOVEORDER_LINES_V.ATTRIBUTE14,' ||
911: 'CSP_MOVEORDER_LINES_V.ATTRIBUTE15,' ||
912: 'from CSP_MOVEORDER_LINES_V';
913: -- Debug Message
914: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
915:
916: END Gen_Select;
917:
918: PROCEDURE Gen_mol_Where(

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

934: str_csr2 NUMBER;
935: l_operator VARCHAR2(10);
936: BEGIN
937: -- Debug Message
938: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Begins');
939:
940: -- There are three examples for each kind of datatype:
941: -- NUMBER, DATE, VARCHAR2.
942: -- Developer can copy and paste the following codes for your own record.

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

1020:
1021: -- Add more IF statements for each column below
1022:
1023: -- Debug Message
1024: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1025:
1026: END Gen_mol_Where;
1027:
1028: -- Item-level validation procedures

Line 1046: FND_MSG_PUB.initialize;

1042:
1043: -- Initialize message list if p_init_msg_list is set to TRUE.
1044: IF FND_API.to_Boolean( p_init_msg_list )
1045: THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:
1049:
1050: -- Initialize API return status to SUCCESS

Line 1056: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(LINE_ID)');

1052:
1053: -- validate NOT NULL column
1054: IF(p_LINE_ID is NULL)
1055: THEN
1056: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(LINE_ID)');
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: END IF;
1059:
1060: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1096: FND_MSG_PUB.Count_And_Get

1092: NULL;
1093: END IF;
1094:
1095: -- Standard call to get message count and if count is 1, get message info.
1096: FND_MSG_PUB.Count_And_Get
1097: ( p_count => x_msg_count,
1098: p_data => x_msg_data
1099: );
1100:

Line 1119: FND_MSG_PUB.initialize;

1115:
1116: -- Initialize message list if p_init_msg_list is set to TRUE.
1117: IF FND_API.to_Boolean( p_init_msg_list )
1118: THEN
1119: FND_MSG_PUB.initialize;
1120: END IF;
1121:
1122:
1123: -- Initialize API return status to SUCCESS

Line 1143: FND_MSG_PUB.Count_And_Get

1139: NULL;
1140: END IF;
1141:
1142: -- Standard call to get message count and if count is 1, get message info.
1143: FND_MSG_PUB.Count_And_Get
1144: ( p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1147:

Line 1166: FND_MSG_PUB.initialize;

1162:
1163: -- Initialize message list if p_init_msg_list is set to TRUE.
1164: IF FND_API.to_Boolean( p_init_msg_list )
1165: THEN
1166: FND_MSG_PUB.initialize;
1167: END IF;
1168:
1169:
1170: -- Initialize API return status to SUCCESS

Line 1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(HEADER_ID)');

1172:
1173: -- validate NOT NULL column
1174: IF(p_HEADER_ID is NULL)
1175: THEN
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(HEADER_ID)');
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: END IF;
1179:
1180: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1197: FND_MSG_PUB.Count_And_Get

1193: NULL;
1194: END IF;
1195:
1196: -- Standard call to get message count and if count is 1, get message info.
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_count => x_msg_count,
1199: p_data => x_msg_data
1200: );
1201:

Line 1220: FND_MSG_PUB.initialize;

1216:
1217: -- Initialize message list if p_init_msg_list is set to TRUE.
1218: IF FND_API.to_Boolean( p_init_msg_list )
1219: THEN
1220: FND_MSG_PUB.initialize;
1221: END IF;
1222:
1223:
1224: -- Initialize API return status to SUCCESS

Line 1244: FND_MSG_PUB.Count_And_Get

1240: NULL;
1241: END IF;
1242:
1243: -- Standard call to get message count and if count is 1, get message info.
1244: FND_MSG_PUB.Count_And_Get
1245: ( p_count => x_msg_count,
1246: p_data => x_msg_data
1247: );
1248:

Line 1267: FND_MSG_PUB.initialize;

1263:
1264: -- Initialize message list if p_init_msg_list is set to TRUE.
1265: IF FND_API.to_Boolean( p_init_msg_list )
1266: THEN
1267: FND_MSG_PUB.initialize;
1268: END IF;
1269:
1270:
1271: -- Initialize API return status to SUCCESS

Line 1291: FND_MSG_PUB.Count_And_Get

1287: NULL;
1288: END IF;
1289:
1290: -- Standard call to get message count and if count is 1, get message info.
1291: FND_MSG_PUB.Count_And_Get
1292: ( p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );
1295:

Line 1314: FND_MSG_PUB.initialize;

1310:
1311: -- Initialize message list if p_init_msg_list is set to TRUE.
1312: IF FND_API.to_Boolean( p_init_msg_list )
1313: THEN
1314: FND_MSG_PUB.initialize;
1315: END IF;
1316:
1317:
1318: -- Initialize API return status to SUCCESS

Line 1338: FND_MSG_PUB.Count_And_Get

1334: NULL;
1335: END IF;
1336:
1337: -- Standard call to get message count and if count is 1, get message info.
1338: FND_MSG_PUB.Count_And_Get
1339: ( p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );
1342:

Line 1361: FND_MSG_PUB.initialize;

1357:
1358: -- Initialize message list if p_init_msg_list is set to TRUE.
1359: IF FND_API.to_Boolean( p_init_msg_list )
1360: THEN
1361: FND_MSG_PUB.initialize;
1362: END IF;
1363:
1364:
1365: -- Initialize API return status to SUCCESS

Line 1385: FND_MSG_PUB.Count_And_Get

1381: NULL;
1382: END IF;
1383:
1384: -- Standard call to get message count and if count is 1, get message info.
1385: FND_MSG_PUB.Count_And_Get
1386: ( p_count => x_msg_count,
1387: p_data => x_msg_data
1388: );
1389:

Line 1408: FND_MSG_PUB.initialize;

1404:
1405: -- Initialize message list if p_init_msg_list is set to TRUE.
1406: IF FND_API.to_Boolean( p_init_msg_list )
1407: THEN
1408: FND_MSG_PUB.initialize;
1409: END IF;
1410:
1411:
1412: -- Initialize API return status to SUCCESS

Line 1432: FND_MSG_PUB.Count_And_Get

1428: NULL;
1429: END IF;
1430:
1431: -- Standard call to get message count and if count is 1, get message info.
1432: FND_MSG_PUB.Count_And_Get
1433: ( p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );
1436:

Line 1458: FND_MSG_PUB.initialize;

1454:
1455: -- Initialize message list if p_init_msg_list is set to TRUE.
1456: IF FND_API.to_Boolean( p_init_msg_list )
1457: THEN
1458: FND_MSG_PUB.initialize;
1459: END IF;
1460:
1461:
1462: -- Initialize API return status to SUCCESS

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

1467: -- THEN
1468: -- x_return_status := FND_API.G_RET_STS_ERROR;
1469:
1470: -- Debug Message
1471: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1472:
1473: -- Standard call to get message count and if count is 1, get message info.
1474: FND_MSG_PUB.Count_And_Get
1475: ( p_count => x_msg_count,

Line 1474: FND_MSG_PUB.Count_And_Get

1470: -- Debug Message
1471: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1472:
1473: -- Standard call to get message count and if count is 1, get message info.
1474: FND_MSG_PUB.Count_And_Get
1475: ( p_count => x_msg_count,
1476: p_data => x_msg_data
1477: );
1478:

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

1491: l_api_name CONSTANT VARCHAR2(30) := 'Validate_orderlines';
1492: BEGIN
1493:
1494: -- Debug Message
1495: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
1496:
1497:
1498: -- Initialize API return status to SUCCESS
1499: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1627: END IF;
1628:
1629:
1630: -- Debug Message
1631: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
1632:
1633: END Validate_orderlines;
1634:
1635: End CSP_ORDERLINES_PVT;