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_PICK_SERIAL_LOTS_PVT dependencies on FND_MSG_PUB

Line 59: FND_MSG_PUB.initialize;

55:
56: -- Initialize message list if p_init_msg_list is set to TRUE.
57: IF FND_API.to_Boolean( p_init_msg_list )
58: THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62:
63: -- Debug Message

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

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

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

92: -- Validate Environment
93: -- ******************************************************************
94: IF FND_GLOBAL.User_Id IS NULL
95: THEN
96: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
99: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
100: FND_MSG_PUB.ADD;

Line 100: FND_MSG_PUB.ADD;

96: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
99: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
100: FND_MSG_PUB.ADD;
101: END IF;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:

Line 122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Validate_pick_serial_lots');

118:
119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Validate_pick_serial_lots');
123:
124: -- Invoke validation procedures
125: Validate_pick_serial_lots(
126: p_init_msg_list => FND_API.G_FALSE,

Line 142: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', '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, 'csp', 'Private API: Calling create table handler');
143:
144: IF l_created_by IS NULL THEN
145: l_created_by := G_USER_ID;
146: END IF;

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

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

Line 198: FND_MSG_PUB.Count_And_Get

194: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
195:
196:
197: -- Standard call to get message count and if count is 1, get message info.
198: FND_MSG_PUB.Count_And_Get
199: ( p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202:

Line 225: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

221: WHEN FND_API.G_EXC_ERROR THEN
222: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
223: P_API_NAME => L_API_NAME
224: ,P_PKG_NAME => G_PKG_NAME
225: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
226: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
227: ,X_MSG_COUNT => X_MSG_COUNT
228: ,X_MSG_DATA => X_MSG_DATA
229: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
233: P_API_NAME => L_API_NAME
234: ,P_PKG_NAME => G_PKG_NAME
235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
236: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
237: ,X_MSG_COUNT => X_MSG_COUNT
238: ,X_MSG_DATA => X_MSG_DATA
239: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 310: FND_MSG_PUB.initialize;

306:
307: -- Initialize message list if p_init_msg_list is set to TRUE.
308: IF FND_API.to_Boolean( p_init_msg_list )
309: THEN
310: FND_MSG_PUB.initialize;
311: END IF;
312:
313:
314: -- Debug Message

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

311: END IF;
312:
313:
314: -- Debug Message
315: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'start');
316:
317:
318: -- Initialize API return status to SUCCESS
319: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355: */
356: -- Debug Message
357: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: - Open Cursor to Select');
358:
359: /*
360: Open C_Get_pick_serial_lots( l_tar_psl_rec.PICKLIST_SERIAL_LOT_ID);
361:

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

374: l_ref_psl_rec.LOT_NUMBER,
375: l_ref_psl_rec.SERIAL_NUMBER;
376:
377: If ( C_Get_pick_serial_lots%NOTFOUND) Then
378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
379: THEN
380: FND_MESSAGE.Set_Name('csp', 'API_MISSING_UPDATE_TARGET');
381: FND_MESSAGE.Set_Token ('INFO', 'pick_serial_lots', FALSE);
382: FND_MSG_PUB.Add;

Line 382: FND_MSG_PUB.Add;

378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
379: THEN
380: FND_MESSAGE.Set_Name('csp', 'API_MISSING_UPDATE_TARGET');
381: FND_MESSAGE.Set_Token ('INFO', 'pick_serial_lots', FALSE);
382: FND_MSG_PUB.Add;
383: END IF;
384: raise FND_API.G_EXC_ERROR;
385: END IF;
386: -- Debug Message

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

383: END IF;
384: raise FND_API.G_EXC_ERROR;
385: END IF;
386: -- Debug Message
387: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: - Close Cursor');
388: Close C_Get_pick_serial_lots;
389: */
390:
391:

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

390:
391:
392: If (l_tar_psl_rec.last_update_date is NULL or
393: l_tar_psl_rec.last_update_date = FND_API.G_MISS_Date ) Then
394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: FND_MESSAGE.Set_Name('csp', 'API_MISSING_ID');
397: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
398: FND_MSG_PUB.ADD;

Line 398: FND_MSG_PUB.ADD;

394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: FND_MESSAGE.Set_Name('csp', 'API_MISSING_ID');
397: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
398: FND_MSG_PUB.ADD;
399: END IF;
400: raise FND_API.G_EXC_ERROR;
401: End if;
402: -- Check Whether record has been changed by someone else

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

400: raise FND_API.G_EXC_ERROR;
401: End if;
402: -- Check Whether record has been changed by someone else
403: If (l_tar_psl_rec.last_update_date <> l_ref_psl_rec.last_update_date) Then
404: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
405: THEN
406: FND_MESSAGE.Set_Name('csp', 'API_RECORD_CHANGED');
407: FND_MESSAGE.Set_Token('INFO', 'pick_serial_lots', FALSE);
408: FND_MSG_PUB.ADD;

Line 408: FND_MSG_PUB.ADD;

404: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
405: THEN
406: FND_MESSAGE.Set_Name('csp', 'API_RECORD_CHANGED');
407: FND_MESSAGE.Set_Token('INFO', 'pick_serial_lots', FALSE);
408: FND_MSG_PUB.ADD;
409: END IF;
410: raise FND_API.G_EXC_ERROR;
411: End if;
412:

Line 416: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Validate_pick_serial_lots');

412:
413: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
414: THEN
415: -- Debug message
416: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Validate_pick_serial_lots');
417:
418: -- Invoke validation procedures
419: Validate_pick_serial_lots(
420: p_init_msg_list => FND_API.G_FALSE,

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

432:
433: -- Hint: Add corresponding Master-Detail business logic here if necessary.
434:
435: -- Debug Message
436: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Calling update table handler');
437:
438: -- Invoke table handler(CSP_PICKLIST_SERIAL_LOTS_PKG.Update_Row)
439: CSP_PICKLIST_SERIAL_LOTS_PKG.Update_Row(
440: p_PICKLIST_SERIAL_LOT_ID => p_psl_rec.PICKLIST_SERIAL_LOT_ID,

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

460: END IF;
461:
462:
463: -- Debug Message
464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
465:
466:
467: -- Standard call to get message count and if count is 1, get message info.
468: FND_MSG_PUB.Count_And_Get

Line 468: FND_MSG_PUB.Count_And_Get

464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
465:
466:
467: -- Standard call to get message count and if count is 1, get message info.
468: FND_MSG_PUB.Count_And_Get
469: ( p_count => x_msg_count,
470: p_data => x_msg_data
471: );
472:

Line 496: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 506: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
504: P_API_NAME => L_API_NAME
505: ,P_PKG_NAME => G_PKG_NAME
506: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
507: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
508: ,X_MSG_COUNT => X_MSG_COUNT
509: ,X_MSG_DATA => X_MSG_DATA
510: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 559: FND_MSG_PUB.initialize;

555:
556: -- Initialize message list if p_init_msg_list is set to TRUE.
557: IF FND_API.to_Boolean( p_init_msg_list )
558: THEN
559: FND_MSG_PUB.initialize;
560: END IF;
561:
562:
563: -- Debug Message

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

560: END IF;
561:
562:
563: -- Debug Message
564: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'start');
565:
566:
567: -- Initialize API return status to SUCCESS
568: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604: */
605: -- Debug Message
606: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Calling delete table handler');
607:
608: -- Invoke table handler(CSP_PICKLIST_SERIAL_LOTS_PKG.Delete_Row)
609: CSP_PICKLIST_SERIAL_LOTS_PKG.Delete_Row(
610: p_PICKLIST_SERIAL_LOT_ID => p_psl_rec.PICKLIST_SERIAL_LOT_ID);

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

619: END IF;
620:
621:
622: -- Debug Message
623: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
624:
625:
626: -- Standard call to get message count and if count is 1, get message info.
627: FND_MSG_PUB.Count_And_Get

Line 627: FND_MSG_PUB.Count_And_Get

623: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
624:
625:
626: -- Standard call to get message count and if count is 1, get message info.
627: FND_MSG_PUB.Count_And_Get
628: ( p_count => x_msg_count,
629: p_data => x_msg_data
630: );
631:

Line 655: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

651: WHEN FND_API.G_EXC_ERROR THEN
652: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
653: P_API_NAME => L_API_NAME
654: ,P_PKG_NAME => G_PKG_NAME
655: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
656: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
657: ,X_MSG_COUNT => X_MSG_COUNT
658: ,X_MSG_DATA => X_MSG_DATA
659: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME
664: ,P_PKG_NAME => G_PKG_NAME
665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
666: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
667: ,X_MSG_COUNT => X_MSG_COUNT
668: ,X_MSG_DATA => X_MSG_DATA
669: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

687: )
688: IS
689: BEGIN
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Begins');
692:
693: -- define all columns for CSP_PICKLIST_SERIAL_LOTS_V view
694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);

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

699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);
700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);
701:
702: -- Debug Message
703: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Ends');
704: END Define_Columns;
705:
706: -- This procudure gets column values by the Dynamic SQL.
707: PROCEDURE Get_Column_Values(

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

710: )
711: IS
712: BEGIN
713: -- Debug Message
714: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Begins');
715:
716: -- get all column values for CSP_PICKLIST_SERIAL_LOTS_V table
717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);
718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);

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

723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);
724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);
725:
726: -- Debug Message
727: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Ends');
728: END Get_Column_Values;
729:
730: PROCEDURE Gen_psl_order_cl(
731: p_order_by_rec IN csp_pick_serial_lots_PUB.psl_sort_rec_type,

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

738: l_order_by_cl VARCHAR2(1000) := NULL;
739: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
740: BEGIN
741: -- Debug Message
742: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Order by Begins');
743:
744: -- Hint: Developer should add more statements according to csp_sort_rec_type
745: -- Ex:
746: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

Line 750: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Invoke JTF_PLSQL_API.Translate_OrderBy');

746: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
747: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
748:
749: -- Debug Message
750: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
751:
752: JTF_PLSQL_API.Translate_OrderBy(
753: p_api_version_number => 1.0
754: ,p_init_msg_list => FND_API.G_FALSE

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

765: x_order_by_cl := NULL;
766: END IF;
767:
768: -- Debug Message
769: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Order by Ends');
770: END Gen_psl_order_cl;
771:
772: -- This procedure bind the variables for the Dynamic SQL
773: PROCEDURE Bind(

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

779: BEGIN
780: -- Bind variables
781: -- Only those that are not NULL
782: -- Debug Message
783: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Bind Variables Begins');
784:
785: -- The following example applies to all columns,
786: -- developers can copy and paste them.
787: IF( (P_psl_Rec.PICKLIST_SERIAL_LOT_ID IS NOT NULL) AND (P_psl_Rec.PICKLIST_SERIAL_LOT_ID <> FND_API.G_MISS_NUM) )

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

789: DBMS_SQL.BIND_VARIABLE(p_cur_get_psl, ':p_PICKLIST_SERIAL_LOT_ID', P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
790: END IF;
791:
792: -- Debug Message
793: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Bind Variables Ends');
794: END Bind;
795:
796: PROCEDURE Gen_Select(
797: x_select_cl OUT NOCOPY VARCHAR2

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

798: )
799: IS
800: BEGIN
801: -- Debug Message
802: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Select Begins');
803:
804: x_select_cl := 'Select ' ||
805: 'CSP_PICKLIST_SERIAL_LOTS_V.ROW_ID,' ||
806: 'CSP_PICKLIST_SERIAL_LOTS_V.PICKLIST_SERIAL_LOT_ID,' ||

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

816: 'CSP_PICKLIST_SERIAL_LOTS_V.LOT_NUMBER,' ||
817: 'CSP_PICKLIST_SERIAL_LOTS_V.SERIAL_NUMBER,' ||
818: 'from CSP_PICKLIST_SERIAL_LOTS_V';
819: -- Debug Message
820: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Select Ends');
821:
822: END Gen_Select;
823:
824: PROCEDURE Gen_psl_Where(

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

840: str_csr2 NUMBER;
841: l_operator VARCHAR2(10);
842: BEGIN
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Where Begins');
845:
846: -- There are three examples for each kind of datatype:
847: -- NUMBER, DATE, VARCHAR2.
848: -- Developer can copy and paste the following codes for your own record.

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

926:
927: -- Add more IF statements for each column below
928:
929: -- Debug Message
930: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Where Ends');
931:
932: END Gen_psl_Where;
933:
934: -- Item-level validation procedures

Line 950: FND_MSG_PUB.initialize;

946:
947: -- Initialize message list if p_init_msg_list is set to TRUE.
948: IF FND_API.to_Boolean( p_init_msg_list )
949: THEN
950: FND_MSG_PUB.initialize;
951: END IF;
952:
953:
954: -- Initialize API return status to SUCCESS

Line 960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_SERIAL_LOT_ID)');

956:
957: -- validate NOT NULL column
958: IF(p_PICKLIST_SERIAL_LOT_ID is NULL)
959: THEN
960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_SERIAL_LOT_ID)');
961: x_return_status := FND_API.G_RET_STS_ERROR;
962: END IF;
963:
964: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 981: FND_MSG_PUB.Count_And_Get

977: NULL;
978: END IF;
979:
980: -- Standard call to get message count and if count is 1, get message info.
981: FND_MSG_PUB.Count_And_Get
982: ( p_count => x_msg_count,
983: p_data => x_msg_data
984: );
985:

Line 1004: FND_MSG_PUB.initialize;

1000:
1001: -- Initialize message list if p_init_msg_list is set to TRUE.
1002: IF FND_API.to_Boolean( p_init_msg_list )
1003: THEN
1004: FND_MSG_PUB.initialize;
1005: END IF;
1006:
1007:
1008: -- Initialize API return status to SUCCESS

Line 1014: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_LINE_ID)');

1010:
1011: -- validate NOT NULL column
1012: IF(p_PICKLIST_LINE_ID is NULL)
1013: THEN
1014: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_LINE_ID)');
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: END IF;
1017:
1018: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1035: FND_MSG_PUB.Count_And_Get

1031: NULL;
1032: END IF;
1033:
1034: -- Standard call to get message count and if count is 1, get message info.
1035: FND_MSG_PUB.Count_And_Get
1036: ( p_count => x_msg_count,
1037: p_data => x_msg_data
1038: );
1039:

Line 1058: FND_MSG_PUB.initialize;

1054:
1055: -- Initialize message list if p_init_msg_list is set to TRUE.
1056: IF FND_API.to_Boolean( p_init_msg_list )
1057: THEN
1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061:
1062: -- Initialize API return status to SUCCESS

Line 1068: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(ORGANIZATION_ID)');

1064:
1065: -- validate NOT NULL column
1066: IF(p_ORGANIZATION_ID is NULL)
1067: THEN
1068: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: END IF;
1071:
1072: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1089: FND_MSG_PUB.Count_And_Get

1085: NULL;
1086: END IF;
1087:
1088: -- Standard call to get message count and if count is 1, get message info.
1089: FND_MSG_PUB.Count_And_Get
1090: ( p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093:

Line 1112: FND_MSG_PUB.initialize;

1108:
1109: -- Initialize message list if p_init_msg_list is set to TRUE.
1110: IF FND_API.to_Boolean( p_init_msg_list )
1111: THEN
1112: FND_MSG_PUB.initialize;
1113: END IF;
1114:
1115:
1116: -- Initialize API return status to SUCCESS

Line 1122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');

1118:
1119: -- validate NOT NULL column
1120: IF(p_INVENTORY_ITEM_ID is NULL)
1121: THEN
1122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: END IF;
1125:
1126: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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 pick_serial_lots API: -Violate NOT NULL constraint(QUANTITY)');

1172:
1173: -- validate NOT NULL column
1174: IF(p_QUANTITY is NULL)
1175: THEN
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(QUANTITY)');
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 1317: FND_MSG_PUB.initialize;

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

Line 1330: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'API_INVALID_RECORD');

1326: -- THEN
1327: -- x_return_status := FND_API.G_RET_STS_ERROR;
1328:
1329: -- Debug Message
1330: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'API_INVALID_RECORD');
1331:
1332: -- Standard call to get message count and if count is 1, get message info.
1333: FND_MSG_PUB.Count_And_Get
1334: ( p_count => x_msg_count,

Line 1333: FND_MSG_PUB.Count_And_Get

1329: -- Debug Message
1330: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'API_INVALID_RECORD');
1331:
1332: -- Standard call to get message count and if count is 1, get message info.
1333: FND_MSG_PUB.Count_And_Get
1334: ( p_count => x_msg_count,
1335: p_data => x_msg_data
1336: );
1337:

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

1350: l_api_name CONSTANT VARCHAR2(30) := 'Validate_pick_serial_lots';
1351: BEGIN
1352:
1353: -- Debug Message
1354: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'start');
1355:
1356:
1357: -- Initialize API return status to SUCCESS
1358: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1473: END IF;
1474:
1475:
1476: -- Debug Message
1477: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
1478:
1479: END Validate_pick_serial_lots;
1480:
1481: End csp_pick_serial_lots_PVT;