DBA Data[Home] [Help]

APPS.CSP_PRODUCT_TASK_PVT dependencies on JTF_PLSQL_API

Line 67: p_validation_mode => JTF_PLSQL_API.G_CREATE,

63: -- Invoke validation procedures
64: Validate_product_task(
65: p_init_msg_list => FND_API.G_FALSE,
66: p_validation_level => p_validation_level,
67: p_validation_mode => JTF_PLSQL_API.G_CREATE,
68: P_PROD_TASK_Rec => P_PROD_TASK_Rec,
69: x_return_status => x_return_status,
70: x_msg_count => x_msg_count,
71: x_msg_data => x_msg_data);

Line 124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

120: p_data => x_msg_data
121: );
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
125: P_API_NAME => L_API_NAME
126: ,P_PKG_NAME => G_PKG_NAME
127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

124: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
125: P_API_NAME => L_API_NAME
126: ,P_PKG_NAME => G_PKG_NAME
127: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
128: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
129: ,X_MSG_COUNT => X_MSG_COUNT
130: ,X_MSG_DATA => X_MSG_DATA
131: ,X_RETURN_STATUS => X_RETURN_STATUS);
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 133: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

129: ,X_MSG_COUNT => X_MSG_COUNT
130: ,X_MSG_DATA => X_MSG_DATA
131: ,X_RETURN_STATUS => X_RETURN_STATUS);
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
134: P_API_NAME => L_API_NAME
135: ,P_PKG_NAME => G_PKG_NAME
136: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
137: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 137: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

133: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
134: P_API_NAME => L_API_NAME
135: ,P_PKG_NAME => G_PKG_NAME
136: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
137: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
138: ,X_MSG_COUNT => X_MSG_COUNT
139: ,X_MSG_DATA => X_MSG_DATA
140: ,X_RETURN_STATUS => X_RETURN_STATUS);
141: WHEN OTHERS THEN

Line 142: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

138: ,X_MSG_COUNT => X_MSG_COUNT
139: ,X_MSG_DATA => X_MSG_DATA
140: ,X_RETURN_STATUS => X_RETURN_STATUS);
141: WHEN OTHERS THEN
142: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
143: P_API_NAME => L_API_NAME
144: ,P_PKG_NAME => G_PKG_NAME
145: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
146: ,P_SQLCODE => SQLCODE

Line 145: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

141: WHEN OTHERS THEN
142: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
143: P_API_NAME => L_API_NAME
144: ,P_PKG_NAME => G_PKG_NAME
145: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
146: ,P_SQLCODE => SQLCODE
147: ,P_SQLERRM => SQLERRM
148: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
149: ,X_MSG_COUNT => X_MSG_COUNT

Line 148: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

144: ,P_PKG_NAME => G_PKG_NAME
145: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
146: ,P_SQLCODE => SQLCODE
147: ,P_SQLERRM => SQLERRM
148: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
149: ,X_MSG_COUNT => X_MSG_COUNT
150: ,X_MSG_DATA => X_MSG_DATA
151: ,X_RETURN_STATUS => X_RETURN_STATUS);
152: End Create_product_task;

Line 301: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

297: -- Invoke validation procedures
298: Validate_product_task(
299: p_init_msg_list => FND_API.G_FALSE,
300: p_validation_level => p_validation_level,
301: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
302: P_PROD_TASK_Rec => P_PROD_TASK_Rec,
303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data);

Line 356: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

352: p_data => x_msg_data
353: );
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
357: P_API_NAME => L_API_NAME
358: ,P_PKG_NAME => G_PKG_NAME
359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
360: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 360: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

356: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
357: P_API_NAME => L_API_NAME
358: ,P_PKG_NAME => G_PKG_NAME
359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
360: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
361: ,X_MSG_COUNT => X_MSG_COUNT
362: ,X_MSG_DATA => X_MSG_DATA
363: ,X_RETURN_STATUS => X_RETURN_STATUS);
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 365: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

361: ,X_MSG_COUNT => X_MSG_COUNT
362: ,X_MSG_DATA => X_MSG_DATA
363: ,X_RETURN_STATUS => X_RETURN_STATUS);
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
366: P_API_NAME => L_API_NAME
367: ,P_PKG_NAME => G_PKG_NAME
368: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
369: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 369: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

365: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
366: P_API_NAME => L_API_NAME
367: ,P_PKG_NAME => G_PKG_NAME
368: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
369: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
370: ,X_MSG_COUNT => X_MSG_COUNT
371: ,X_MSG_DATA => X_MSG_DATA
372: ,X_RETURN_STATUS => X_RETURN_STATUS);
373: WHEN OTHERS THEN

Line 374: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

370: ,X_MSG_COUNT => X_MSG_COUNT
371: ,X_MSG_DATA => X_MSG_DATA
372: ,X_RETURN_STATUS => X_RETURN_STATUS);
373: WHEN OTHERS THEN
374: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME
376: ,P_PKG_NAME => G_PKG_NAME
377: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
378: ,P_SQLCODE => SQLCODE

Line 377: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

373: WHEN OTHERS THEN
374: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME
376: ,P_PKG_NAME => G_PKG_NAME
377: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
378: ,P_SQLCODE => SQLCODE
379: ,P_SQLERRM => SQLERRM
380: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
381: ,X_MSG_COUNT => X_MSG_COUNT

Line 380: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

376: ,P_PKG_NAME => G_PKG_NAME
377: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
378: ,P_SQLCODE => SQLCODE
379: ,P_SQLERRM => SQLERRM
380: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
381: ,X_MSG_COUNT => X_MSG_COUNT
382: ,X_MSG_DATA => X_MSG_DATA
383: ,X_RETURN_STATUS => X_RETURN_STATUS);
384: End Update_product_task;

Line 439: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

435: p_data => x_msg_data
436: );
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
440: P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
443: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 443: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

439: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
440: P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
443: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
449: P_API_NAME => L_API_NAME
450: ,P_PKG_NAME => G_PKG_NAME
451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

448: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
449: P_API_NAME => L_API_NAME
450: ,P_PKG_NAME => G_PKG_NAME
451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
452: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
453: ,X_MSG_COUNT => X_MSG_COUNT
454: ,X_MSG_DATA => X_MSG_DATA
455: ,X_RETURN_STATUS => X_RETURN_STATUS);
456: WHEN OTHERS THEN

Line 457: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

453: ,X_MSG_COUNT => X_MSG_COUNT
454: ,X_MSG_DATA => X_MSG_DATA
455: ,X_RETURN_STATUS => X_RETURN_STATUS);
456: WHEN OTHERS THEN
457: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
458: P_API_NAME => L_API_NAME
459: ,P_PKG_NAME => G_PKG_NAME
460: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
461: ,P_SQLCODE => SQLCODE

Line 460: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

456: WHEN OTHERS THEN
457: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
458: P_API_NAME => L_API_NAME
459: ,P_PKG_NAME => G_PKG_NAME
460: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
461: ,P_SQLCODE => SQLCODE
462: ,P_SQLERRM => SQLERRM
463: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
464: ,X_MSG_COUNT => X_MSG_COUNT

Line 463: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

459: ,P_PKG_NAME => G_PKG_NAME
460: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
461: ,P_SQLCODE => SQLCODE
462: ,P_SQLERRM => SQLERRM
463: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
464: ,X_MSG_COUNT => X_MSG_COUNT
465: ,X_MSG_DATA => X_MSG_DATA
466: ,X_RETURN_STATUS => X_RETURN_STATUS);
467: End Delete_product_task;

Line 696: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

692: IF(p_PRODUCT_TASK_ID is NULL)
693: THEN
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: END IF;
696: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
697: THEN
698: -- Hint: Validate data
699: -- IF p_PRODUCT_TASK_ID is not NULL and p_PRODUCT_TASK_ID <> G_MISS_CHAR
700: -- verify if data is valid

Line 703: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

699: -- IF p_PRODUCT_TASK_ID is not NULL and p_PRODUCT_TASK_ID <> G_MISS_CHAR
700: -- verify if data is valid
701: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
702: NULL;
703: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
704: THEN
705: -- Hint: Validate data
706: -- IF p_PRODUCT_TASK_ID <> G_MISS_CHAR
707: -- verify if data is valid

Line 740: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

736: IF(p_PRODUCT_ID is NULL)
737: THEN
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: END IF;
740: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
741: THEN
742: -- Hint: Validate data
743: -- IF p_PRODUCT_ID is not NULL and p_PRODUCT_ID <> G_MISS_CHAR
744: -- verify if data is valid

Line 747: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

743: -- IF p_PRODUCT_ID is not NULL and p_PRODUCT_ID <> G_MISS_CHAR
744: -- verify if data is valid
745: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
746: NULL;
747: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
748: THEN
749: -- Hint: Validate data
750: -- IF p_PRODUCT_ID <> G_MISS_CHAR
751: -- verify if data is valid

Line 784: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

780: IF(p_TASK_TEMPLATE_ID is NULL)
781: THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;
784: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
785: THEN
786: -- Hint: Validate data
787: -- IF p_TASK_TEMPLATE_ID is not NULL and p_TASK_TEMPLATE_ID <> G_MISS_CHAR
788: -- verify if data is valid

Line 791: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

787: -- IF p_TASK_TEMPLATE_ID is not NULL and p_TASK_TEMPLATE_ID <> G_MISS_CHAR
788: -- verify if data is valid
789: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
790: NULL;
791: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
792: THEN
793: -- Hint: Validate data
794: -- IF p_TASK_TEMPLATE_ID <> G_MISS_CHAR
795: -- verify if data is valid

Line 828: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

824: IF(p_AUTO_MANUAL is NULL)
825: THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: END IF;
828: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
829: THEN
830: -- Hint: Validate data
831: -- IF p_AUTO_MANUAL is not NULL and p_AUTO_MANUAL <> G_MISS_CHAR
832: -- verify if data is valid

Line 835: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

831: -- IF p_AUTO_MANUAL is not NULL and p_AUTO_MANUAL <> G_MISS_CHAR
832: -- verify if data is valid
833: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
834: NULL;
835: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
836: THEN
837: -- Hint: Validate data
838: -- IF p_AUTO_MANUAL <> G_MISS_CHAR
839: -- verify if data is valid

Line 867: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

863: FND_MSG_PUB.initialize;
864: END IF;
865: -- Initialize API return status to SUCCESS
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
868: THEN
869: -- Hint: Validate data
870: -- IF p_ACTUAL_TIMES_USED is not NULL and p_ACTUAL_TIMES_USED <> G_MISS_CHAR
871: -- verify if data is valid

Line 874: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

870: -- IF p_ACTUAL_TIMES_USED is not NULL and p_ACTUAL_TIMES_USED <> G_MISS_CHAR
871: -- verify if data is valid
872: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
873: NULL;
874: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
875: THEN
876: -- Hint: Validate data
877: -- IF p_ACTUAL_TIMES_USED <> G_MISS_CHAR
878: -- verify if data is valid

Line 906: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

902: FND_MSG_PUB.initialize;
903: END IF;
904: -- Initialize API return status to SUCCESS
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
907: THEN
908: -- Hint: Validate data
909: -- IF p_TASK_PERCENTAGE is not NULL and p_TASK_PERCENTAGE <> G_MISS_CHAR
910: -- verify if data is valid

Line 913: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

909: -- IF p_TASK_PERCENTAGE is not NULL and p_TASK_PERCENTAGE <> G_MISS_CHAR
910: -- verify if data is valid
911: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
912: NULL;
913: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
914: THEN
915: -- Hint: Validate data
916: -- IF p_TASK_PERCENTAGE <> G_MISS_CHAR
917: -- verify if data is valid

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

969: l_api_name CONSTANT VARCHAR2(30) := 'Validate_product_task';
970: BEGIN
971: -- Initialize API return status to SUCCESS
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
974: -- Hint: We provide validation procedure for every column. Developer should delete
975: -- unnecessary validation procedures.
976: Validate_PRODUCT_TASK_ID(
977: p_init_msg_list => FND_API.G_FALSE,

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

1039: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1040: raise FND_API.G_EXC_ERROR;
1041: END IF;
1042: END IF;
1043: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1044: -- Hint: Inter-field level validation can be added here
1045: -- invoke record level validation procedures
1046: Validate_PROD_TASK_Rec(
1047: p_init_msg_list => FND_API.G_FALSE,

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

1053: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1054: raise FND_API.G_EXC_ERROR;
1055: END IF;
1056: END IF;
1057: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1058: -- invoke inter-record level validation procedures
1059: NULL;
1060: END IF;
1061: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN

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

1057: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1058: -- invoke inter-record level validation procedures
1059: NULL;
1060: END IF;
1061: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1062: -- invoke inter-entity level validation procedures
1063: NULL;
1064: END IF;
1065: END Validate_product_task;