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

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

65:
66:
67: -- Debug Message
68: IF l_debug THEN
69: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
70: END IF;
71:
72:
73:

Line 155: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

151: ,x_update_access_flag => l_access_flag);
152: END IF;
153:
154: IF l_access_flag <> 'Y' THEN
155: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
156: 'API_NO_UPDATE_PRIVILEGE');
157: END IF;
158:
159: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');

182: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
183: THEN
184: -- Debug message
185: IF l_debug THEN
186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');
187: END IF;
188:
189:
190: -- Invoke validation procedures

Line 194: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

190: -- Invoke validation procedures
191: Validate_obstacle(
192: p_init_msg_list => FND_API.G_FALSE,
193: p_validation_level => p_validation_level,
194: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
195: P_Obstacle_Rec => l_Obstacle_Rec,
196: x_return_status => x_return_status,
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data);

Line 209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

205: -- Hint: Add corresponding Master-Detail business logic here if necessary.
206:
207: -- Debug Message
208: IF l_debug THEN
209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
210: END IF;
211:
212:
213: AS_LEAD_OBSTACLES_PKG.Insert_Row(

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

267:
268:
269: -- Debug Message
270: IF l_debug THEN
271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
272: END IF;
273:
274:
275:

Line 308: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

304: FND_MESSAGE.Set_Name('AS', 'API_DUP_ISSUES');
305: FND_MSG_PUB.ADD;
306: END IF;
307:
308: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
309: P_MODULE => l_module
310: ,P_API_NAME => L_API_NAME
311: ,P_PKG_NAME => G_PKG_NAME
312: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 313: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

309: P_MODULE => l_module
310: ,P_API_NAME => L_API_NAME
311: ,P_PKG_NAME => G_PKG_NAME
312: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
313: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
314: ,X_MSG_COUNT => X_MSG_COUNT
315: ,X_MSG_DATA => X_MSG_DATA
316: ,X_RETURN_STATUS => X_RETURN_STATUS);
317:

Line 320: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

316: ,X_RETURN_STATUS => X_RETURN_STATUS);
317:
318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
321: P_MODULE => l_module
322: ,P_API_NAME => L_API_NAME
323: ,P_PKG_NAME => G_PKG_NAME
324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 325: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

321: P_MODULE => l_module
322: ,P_API_NAME => L_API_NAME
323: ,P_PKG_NAME => G_PKG_NAME
324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
325: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
326: ,X_MSG_COUNT => X_MSG_COUNT
327: ,X_MSG_DATA => X_MSG_DATA
328: ,X_RETURN_STATUS => X_RETURN_STATUS);
329:

Line 331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

327: ,X_MSG_DATA => X_MSG_DATA
328: ,X_RETURN_STATUS => X_RETURN_STATUS);
329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_MODULE => l_module
333: ,P_API_NAME => L_API_NAME
334: ,P_PKG_NAME => G_PKG_NAME
335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 336: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

332: P_MODULE => l_module
333: ,P_API_NAME => L_API_NAME
334: ,P_PKG_NAME => G_PKG_NAME
335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
336: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
337: ,X_MSG_COUNT => X_MSG_COUNT
338: ,X_MSG_DATA => X_MSG_DATA
339: ,X_RETURN_STATUS => X_RETURN_STATUS);
340:

Line 342: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

338: ,X_MSG_DATA => X_MSG_DATA
339: ,X_RETURN_STATUS => X_RETURN_STATUS);
340:
341: WHEN OTHERS THEN
342: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
343: P_MODULE => l_module
344: ,P_API_NAME => L_API_NAME
345: ,P_PKG_NAME => G_PKG_NAME
346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

342: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
343: P_MODULE => l_module
344: ,P_API_NAME => L_API_NAME
345: ,P_PKG_NAME => G_PKG_NAME
346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
347: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
348: ,X_MSG_COUNT => X_MSG_COUNT
349: ,X_MSG_DATA => X_MSG_DATA
350: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 347: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

343: P_MODULE => l_module
344: ,P_API_NAME => L_API_NAME
345: ,P_PKG_NAME => G_PKG_NAME
346: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
347: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
348: ,X_MSG_COUNT => X_MSG_COUNT
349: ,X_MSG_DATA => X_MSG_DATA
350: ,X_RETURN_STATUS => X_RETURN_STATUS);
351: End Create_obstacles;

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

445:
446:
447: -- Debug Message
448: IF l_debug THEN
449: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
450: END IF;
451:
452:
453:

Line 521: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

517: ,x_update_access_flag => l_access_flag);
518: END IF;
519:
520: IF l_access_flag <> 'Y' THEN
521: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
522: 'API_NO_UPDATE_PRIVILEGE');
523: END IF;
524:
525: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 548: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

544: l_OBSTACLE_rec := P_OBSTACLE_Tbl(I);
545:
546: -- Debug Message
547: IF l_debug THEN
548: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
549: END IF;
550:
551:
552: Open C_Get_obstacle( l_tar_Obstacle_rec.LEAD_OBSTACLE_ID);

Line 600: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

596: raise FND_API.G_EXC_ERROR;
597: END IF;
598: -- Debug Message
599: IF l_debug THEN
600: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
601: END IF;
602:
603: Close C_Get_obstacle;
604:

Line 630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');

626: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
627: THEN
628: -- Debug message
629: IF l_debug THEN
630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_obstacle');
631: END IF;
632:
633:
634: -- Invoke validation procedures

Line 638: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

634: -- Invoke validation procedures
635: Validate_obstacle(
636: p_init_msg_list => FND_API.G_FALSE,
637: p_validation_level => p_validation_level,
638: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
639: P_Obstacle_Rec => l_Obstacle_Rec,
640: x_return_status => x_return_status,
641: x_msg_count => x_msg_count,
642: x_msg_data => x_msg_data);

Line 653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

649: -- Hint: Add corresponding Master-Detail business logic here if necessary.
650:
651: -- Debug Message
652: IF l_debug THEN
653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
654: END IF;
655:
656:
657: -- Invoke table handler(AS_LEAD_OBSTACLES_PKG.Update_Row)

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

709:
710:
711: -- Debug Message
712: IF l_debug THEN
713: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
714: END IF;
715:
716:
717:

Line 750: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

746: FND_MESSAGE.Set_Name('AS', 'API_DUP_ISSUES');
747: FND_MSG_PUB.ADD;
748: END IF;
749:
750: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
751: P_MODULE => l_module
752: ,P_API_NAME => L_API_NAME
753: ,P_PKG_NAME => G_PKG_NAME
754: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 755: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

751: P_MODULE => l_module
752: ,P_API_NAME => L_API_NAME
753: ,P_PKG_NAME => G_PKG_NAME
754: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
755: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
756: ,X_MSG_COUNT => X_MSG_COUNT
757: ,X_MSG_DATA => X_MSG_DATA
758: ,X_RETURN_STATUS => X_RETURN_STATUS);
759:

Line 762: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

758: ,X_RETURN_STATUS => X_RETURN_STATUS);
759:
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
763: P_MODULE => l_module
764: ,P_API_NAME => L_API_NAME
765: ,P_PKG_NAME => G_PKG_NAME
766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 767: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

763: P_MODULE => l_module
764: ,P_API_NAME => L_API_NAME
765: ,P_PKG_NAME => G_PKG_NAME
766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
767: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
768: ,X_MSG_COUNT => X_MSG_COUNT
769: ,X_MSG_DATA => X_MSG_DATA
770: ,X_RETURN_STATUS => X_RETURN_STATUS);
771:

Line 773: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

769: ,X_MSG_DATA => X_MSG_DATA
770: ,X_RETURN_STATUS => X_RETURN_STATUS);
771:
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
774: P_MODULE => l_module
775: ,P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME
777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 778: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

774: P_MODULE => l_module
775: ,P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME
777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
778: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
779: ,X_MSG_COUNT => X_MSG_COUNT
780: ,X_MSG_DATA => X_MSG_DATA
781: ,X_RETURN_STATUS => X_RETURN_STATUS);
782:

Line 784: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

780: ,X_MSG_DATA => X_MSG_DATA
781: ,X_RETURN_STATUS => X_RETURN_STATUS);
782:
783: WHEN OTHERS THEN
784: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
785: P_MODULE => l_module
786: ,P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME
788: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 788: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

784: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
785: P_MODULE => l_module
786: ,P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME
788: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
789: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
790: ,X_MSG_COUNT => X_MSG_COUNT
791: ,X_MSG_DATA => X_MSG_DATA
792: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 789: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

785: P_MODULE => l_module
786: ,P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME
788: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
789: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
790: ,X_MSG_COUNT => X_MSG_COUNT
791: ,X_MSG_DATA => X_MSG_DATA
792: ,X_RETURN_STATUS => X_RETURN_STATUS);
793: End Update_obstacles;

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

844:
845:
846: -- Debug Message
847: IF l_debug THEN
848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
849: END IF;
850:
851:
852: -- Initialize API return status to SUCCESS

Line 919: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

915: ,x_update_access_flag => l_access_flag);
916: END IF;
917:
918: IF l_access_flag <> 'Y' THEN
919: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
920: 'API_NO_UPDATE_PRIVILEGE');
921: END IF;
922:
923: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 945: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

941: END IF;
942:
943: -- Debug Message
944: IF l_debug THEN
945: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
946: END IF;
947:
948:
949: AS_LEAD_OBSTACLES_PKG.Delete_Row(

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

969:
970:
971: -- Debug Message
972: IF l_debug THEN
973: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
974: END IF;
975:
976:
977:

Line 1004: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1000: END IF;
1001: */
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_ERROR THEN
1004: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1005: P_MODULE => l_module
1006: ,P_API_NAME => L_API_NAME
1007: ,P_PKG_NAME => G_PKG_NAME
1008: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1009: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1005: P_MODULE => l_module
1006: ,P_API_NAME => L_API_NAME
1007: ,P_PKG_NAME => G_PKG_NAME
1008: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1009: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1010: ,X_MSG_COUNT => X_MSG_COUNT
1011: ,X_MSG_DATA => X_MSG_DATA
1012: ,X_RETURN_STATUS => X_RETURN_STATUS);
1013:

Line 1015: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1011: ,X_MSG_DATA => X_MSG_DATA
1012: ,X_RETURN_STATUS => X_RETURN_STATUS);
1013:
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1016: P_MODULE => l_module
1017: ,P_API_NAME => L_API_NAME
1018: ,P_PKG_NAME => G_PKG_NAME
1019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1020: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1016: P_MODULE => l_module
1017: ,P_API_NAME => L_API_NAME
1018: ,P_PKG_NAME => G_PKG_NAME
1019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1020: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1021: ,X_MSG_COUNT => X_MSG_COUNT
1022: ,X_MSG_DATA => X_MSG_DATA
1023: ,X_RETURN_STATUS => X_RETURN_STATUS);
1024:

Line 1026: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1022: ,X_MSG_DATA => X_MSG_DATA
1023: ,X_RETURN_STATUS => X_RETURN_STATUS);
1024:
1025: WHEN OTHERS THEN
1026: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1027: P_MODULE => l_module
1028: ,P_API_NAME => L_API_NAME
1029: ,P_PKG_NAME => G_PKG_NAME
1030: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

Line 1030: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1026: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1027: P_MODULE => l_module
1028: ,P_API_NAME => L_API_NAME
1029: ,P_PKG_NAME => G_PKG_NAME
1030: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1031: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1032: ,X_MSG_COUNT => X_MSG_COUNT
1033: ,X_MSG_DATA => X_MSG_DATA
1034: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1031: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1027: P_MODULE => l_module
1028: ,P_API_NAME => L_API_NAME
1029: ,P_PKG_NAME => G_PKG_NAME
1030: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1031: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1032: ,X_MSG_COUNT => X_MSG_COUNT
1033: ,X_MSG_DATA => X_MSG_DATA
1034: ,X_RETURN_STATUS => X_RETURN_STATUS);
1035: End Delete_obstacles;

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

1041: PROCEDURE Validate_LEAD_OBSTACLE_ID (
1042: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1043: P_Validation_mode IN VARCHAR2,
1044: P_LEAD_OBSTACLE_ID IN NUMBER,
1045: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1046: X_Return_Status OUT NOCOPY VARCHAR2,
1047: X_Msg_Count OUT NOCOPY NUMBER,
1048: X_Msg_Data OUT NOCOPY VARCHAR2
1049: )

Line 1071: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1067:
1068: -- Initialize API return status to SUCCESS
1069: x_return_status := FND_API.G_RET_STS_SUCCESS;
1070:
1071: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1072: THEN
1073:
1074: IF (p_LEAD_OBSTACLE_ID is not NULL) and (p_LEAD_OBSTACLE_ID <> FND_API.G_MISS_NUM)
1075: THEN

Line 1080: AS_UTILITY_PVT.Set_Message(

1076: OPEN C_Lead_Obstacle_Id_Exists (p_Lead_Obstacle_Id);
1077: FETCH C_Lead_Obstacle_Id_Exists into l_val;
1078:
1079: IF C_Lead_Obstacle_Id_Exists%FOUND THEN
1080: AS_UTILITY_PVT.Set_Message(
1081: p_module => l_module,
1082: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1083: p_msg_name => 'API_DUPLICATE_LEAD_OBSTACLE_ID');
1084:

Line 1091: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1087:
1088: CLOSE C_Lead_Obstacle_Id_Exists;
1089: END IF;
1090:
1091: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1092: THEN
1093:
1094: IF (p_LEAD_OBSTACLE_ID is NULL) or (p_LEAD_OBSTACLE_ID = FND_API.G_MISS_NUM)
1095: THEN

Line 1096: AS_UTILITY_PVT.Set_Message(

1092: THEN
1093:
1094: IF (p_LEAD_OBSTACLE_ID is NULL) or (p_LEAD_OBSTACLE_ID = FND_API.G_MISS_NUM)
1095: THEN
1096: AS_UTILITY_PVT.Set_Message(
1097: p_module => l_module,
1098: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1099: p_msg_name => 'API_MISSING_LEAD_OBSTACLE_ID');
1100:

Line 1108: AS_UTILITY_PVT.Set_Message(

1104: FETCH C_Lead_Obstacle_Id_Exists into l_val;
1105:
1106: IF C_Lead_Obstacle_Id_Exists%NOTFOUND
1107: THEN
1108: AS_UTILITY_PVT.Set_Message(
1109: p_module => l_module,
1110: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1111: p_msg_name => 'API_INVALID_LEAD_OBSTACLE_ID',
1112: p_token1 => 'VALUE',

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

1132: PROCEDURE Validate_LEAD_ID (
1133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1134: P_Validation_mode IN VARCHAR2,
1135: P_LEAD_ID IN NUMBER,
1136: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1137: X_Return_Status OUT NOCOPY VARCHAR2,
1138: X_Msg_Count OUT NOCOPY NUMBER,
1139: X_Msg_Data OUT NOCOPY VARCHAR2
1140: )

Line 1167: AS_UTILITY_PVT.Debug_Message(l_module,

1163: -- validate NOT NULL column
1164: IF(p_LEAD_ID is NULL)
1165: THEN
1166: IF l_debug THEN
1167: AS_UTILITY_PVT.Debug_Message(l_module,
1168: 'ERROR',
1169: 'Private obstacle API: -Violate NOT NULL constraint(LEAD_ID)');
1170: END IF;
1171:

Line 1177: AS_UTILITY_PVT.Set_Message(

1173: END IF;
1174:
1175: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1176: THEN
1177: AS_UTILITY_PVT.Set_Message(
1178: p_module => l_module,
1179: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1180: p_msg_name => 'API_MISSING_LEAD_ID');
1181:

Line 1189: AS_UTILITY_PVT.Set_Message(

1185: FETCH C_Lead_Id_Exists into l_val;
1186:
1187: IF C_Lead_Id_Exists%NOTFOUND
1188: THEN
1189: AS_UTILITY_PVT.Set_Message(
1190: p_module => l_module,
1191: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1192: p_msg_name => 'API_INVALID_LEAD_ID',
1193: p_token1 => 'VALUE',

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

1211: PROCEDURE Validate_OBSTACLE_CODE (
1212: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1213: P_Validation_mode IN VARCHAR2,
1214: P_OBSTACLE_CODE IN VARCHAR2,
1215: -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1216: X_Return_Status OUT NOCOPY VARCHAR2,
1217: X_Msg_Count OUT NOCOPY NUMBER,
1218: X_Msg_Data OUT NOCOPY VARCHAR2
1219: )

Line 1251: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1247: OPEN C_OBSTACLE_CODE_Exists ('ISSUE', p_OBSTACLE_CODE);
1248: FETCH C_OBSTACLE_CODE_Exists into l_val;
1249:
1250: IF C_OBSTACLE_CODE_Exists%NOTFOUND THEN
1251: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1252: -- 'Private API: OBSTACLE_CODE is invalid');
1253:
1254: AS_UTILITY_PVT.Set_Message(
1255: p_module => l_module,

Line 1254: AS_UTILITY_PVT.Set_Message(

1250: IF C_OBSTACLE_CODE_Exists%NOTFOUND THEN
1251: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1252: -- 'Private API: OBSTACLE_CODE is invalid');
1253:
1254: AS_UTILITY_PVT.Set_Message(
1255: p_module => l_module,
1256: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1257: p_msg_name => 'API_INVALID_OBSTACLE_CODE',
1258: p_token1 => 'VALUE',

Line 1277: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor

1273: END Validate_OBSTACLE_CODE;
1274:
1275:
1276: -- Hint: inter-field level validation can be added here.
1277: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
1278: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1279: -- stored in database table.
1280: PROCEDURE Validate_Obstacle_rec(
1281: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1310: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');

1306: -- x_return_status := FND_API.G_RET_STS_ERROR;
1307:
1308: -- Debug Message
1309: IF l_debug THEN
1310: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1311: END IF;
1312:
1313:
1314: -- Standard call to get message count and if count is 1, get message info.

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

1335: BEGIN
1336:
1337: -- Debug Message
1338: IF l_debug THEN
1339: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1340: END IF;
1341:
1342:
1343:

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

1419:
1420:
1421: -- Debug Message
1422: IF l_debug THEN
1423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1424: END IF;
1425:
1426:
1427: END Validate_obstacle;