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.AHL_LTP_REQST_MATRL_PVT dependencies on STANDARD

Line 75: -- Standard Start of API savepoint

71: l_visit_name VARCHAR2(80);
72: */
73: BEGIN
74: --------------------Initialize ----------------------------------
75: -- Standard Start of API savepoint
76: SAVEPOINT unschedule_visit;
77: -- Check if API is called in debug mode. If yes, enable debug.
78: IF G_DEBUG='Y' THEN
79: AHL_DEBUG_PUB.enable_debug;

Line 85: -- Standard call to check for call compatibility.

81: -- Debug info.
82: IF G_DEBUG='Y' THEN
83: AHL_DEBUG_PUB.debug( 'enter AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
84: END IF;
85: -- Standard call to check for call compatibility.
86: IF FND_API.to_boolean(p_init_msg_list)
87: THEN
88: FND_MSG_PUB.initialize;
89: END IF;

Line 317: --Standard local variables

313: association_type_code
314: FROM ahl_rt_oper_materials
315: WHERE rt_oper_material_id = c_rt_oper_mat_id;
316:
317: --Standard local variables
318: l_api_name CONSTANT VARCHAR2(30) := 'Update_Planned_Materials';
319: l_api_version CONSTANT NUMBER := 1.0;
320: l_msg_data VARCHAR2(2000);
321: l_return_status VARCHAR2(1);

Line 358: -- Standard start of API savepoint

354: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Insert_Planned_Matrls',
355: 'At the start of PLSQL procedure'
356: );
357: END IF;
358: -- Standard start of API savepoint
359: SAVEPOINT Insert_Planned_Matrls;
360: -- Initialize message list if p_init_msg_list is set to TRUE
361: IF FND_API.To_Boolean( l_init_msg_list) THEN
362: FND_MSG_PUB.Initialize;

Line 726: -- Standard IN Parameters :

722: -- visit, which are defined at Route Operation and Disposition level
723: -- Pre-reqs :
724: -- Parameters :
725: --
726: -- Standard IN Parameters :
727: -- p_api_version IN NUMBER Required
728: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
729: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
730: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 734: -- Standard out Parameters :

730: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
731: -- Based on this flag, the API will set the default attributes.
732: -- p_module_type In VARCHAR2 Default NULL
733: -- This will be null.
734: -- Standard out Parameters :
735: -- x_return_status OUT VARCHAR2 Required
736: -- x_msg_count OUT NUMBER Required
737: -- x_msg_data OUT VARCHAR2 Required
738: --

Line 786: --Standard local variables

782: WHERE visit_id = c_visit_id;
783:
784: -- Serial Number Resrvation Change ends
785:
786: --Standard local variables
787: l_api_name CONSTANT VARCHAR2(30) := 'Update_Planned_Materials';
788: l_api_version CONSTANT NUMBER := 1.0;
789: l_msg_data VARCHAR2(2000);
790: l_return_status VARCHAR2(1);

Line 813: -- Standard start of API savepoint

809: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Update_Planned_Materials',
810: 'At the start of PLSQL procedure'
811: );
812: END IF;
813: -- Standard start of API savepoint
814: SAVEPOINT Update_Planned_Materials;
815: -- Initialize message list if p_init_msg_list is set to TRUE
816: IF FND_API.To_Boolean( p_init_msg_list) THEN
817: FND_MSG_PUB.Initialize;

Line 1055: -- Standard check of p_commit

1051: IF x_msg_count > 0 THEN
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: -- Standard check of p_commit
1056: IF FND_API.TO_BOOLEAN(p_commit) THEN
1057: COMMIT WORK;
1058: END IF;
1059:

Line 1108: -- Standard IN Parameters :

1104: -- visit, which are defined at Route Operation and Disposition level
1105: -- Pre-reqs :
1106: -- Parameters :
1107: --
1108: -- Standard IN Parameters :
1109: -- p_api_version IN NUMBER Required
1110: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1111: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1112: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1116: -- Standard out Parameters :

1112: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1113: -- Based on this flag, the API will set the default attributes.
1114: -- p_module_type In VARCHAR2 Default NULL
1115: -- This will be null.
1116: -- Standard out Parameters :
1117: -- x_return_status OUT VARCHAR2 Required
1118: -- x_msg_count OUT NUMBER Required
1119: -- x_msg_data OUT VARCHAR2 Required
1120: --

Line 1169: --Standard local variables

1165: WHERE visit_id = C_VISIT_ID
1166: AND (organization_id IS NULL
1167: OR start_date_time IS NULL);
1168:
1169: --Standard local variables
1170: l_api_name CONSTANT VARCHAR2(30) := 'Create_Task_Materials';
1171: l_api_version CONSTANT NUMBER := 1.0;
1172: l_msg_data VARCHAR2(2000);
1173: l_return_status VARCHAR2(1);

Line 1195: -- Standard start of API savepoint

1191: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Create_Task_Materials',
1192: 'At the start of PLSQL procedure'
1193: );
1194: END IF;
1195: -- Standard start of API savepoint
1196: SAVEPOINT Create_Task_Materials;
1197: -- Initialize message list if p_init_msg_list is set to TRUE
1198: IF FND_API.To_Boolean( p_init_msg_list) THEN
1199: FND_MSG_PUB.Initialize;

Line 1396: -- Standard check of p_commit

1392: END IF;
1393: END IF;
1394:
1395:
1396: -- Standard check of p_commit
1397: IF FND_API.TO_BOOLEAN(p_commit) THEN
1398: COMMIT WORK;
1399: END IF;
1400:

Line 1449: -- Standard IN Parameters :

1445: -- visit, which are defined at Route Operation and Disposition level
1446: -- Pre-reqs :
1447: -- Parameters :
1448: --
1449: -- Standard IN Parameters :
1450: -- p_api_version IN NUMBER Required
1451: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1452: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1453: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1457: -- Standard out Parameters :

1453: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1454: -- Based on this flag, the API will set the default attributes.
1455: -- p_module_type In VARCHAR2 Default NULL
1456: -- This will be null.
1457: -- Standard out Parameters :
1458: -- x_return_status OUT VARCHAR2 Required
1459: -- x_msg_count OUT NUMBER Required
1460: -- x_msg_data OUT VARCHAR2 Required
1461: --

Line 1557: --Standard local variables

1553: OR start_date_time IS NOT NULL
1554: OR department_id IS NOT NULL
1555: );
1556:
1557: --Standard local variables
1558: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Visit_Task_Matrls';
1559: l_api_version CONSTANT NUMBER := 1.0;
1560: l_msg_data VARCHAR2(2000);
1561: l_return_status VARCHAR2(1);

Line 1587: -- Standard start of API savepoint

1583: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Modify_Visit_Task_Matrls',
1584: 'At the start of PLSQL procedure'
1585: );
1586: END IF;
1587: -- Standard start of API savepoint
1588: SAVEPOINT Modify_Visit_Task_Matrls;
1589: -- Initialize message list if p_init_msg_list is set to TRUE
1590: IF FND_API.To_Boolean( p_init_msg_list) THEN
1591: FND_MSG_PUB.Initialize;

Line 1893: -- Standard check of p_commit

1889: IF x_msg_count > 0 THEN
1890: RAISE FND_API.G_EXC_ERROR;
1891: END IF;
1892:
1893: -- Standard check of p_commit
1894: IF FND_API.TO_BOOLEAN(p_commit) THEN
1895: COMMIT WORK;
1896: END IF;
1897:

Line 1946: -- Standard IN Parameters :

1942: -- which are defined at Route Operation and Disposition level
1943: -- Pre-reqs :
1944: -- Parameters :
1945: --
1946: -- Standard IN Parameters :
1947: -- p_api_version IN NUMBER Required
1948: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1949: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1950: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1953: -- Standard out Parameters :

1949: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1950: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1951: -- Based on this flag, the API will set the default attributes.
1952: -- This will be null.
1953: -- Standard out Parameters :
1954: -- x_return_status OUT VARCHAR2 Required
1955: -- x_msg_count OUT NUMBER Required
1956: -- x_msg_data OUT VARCHAR2 Required
1957: --

Line 2011: -- Standard Start of API savepoint

2007: l_req_material_rec ahl_ltp_reqst_matrl_pub.Schedule_Mr_Rec;
2008: --
2009: BEGIN
2010: --------------------Initialize ----------------------------------
2011: -- Standard Start of API savepoint
2012: SAVEPOINT Unschedule_Task_Items;
2013: -- Check if API is called in debug mode. If yes, enable debug.
2014: IF G_DEBUG='Y' THEN
2015: AHL_DEBUG_PUB.enable_debug;

Line 2021: -- Standard call to check for call compatibility.

2017: -- Debug info.
2018: IF G_DEBUG='Y' THEN
2019: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');
2020: END IF;
2021: -- Standard call to check for call compatibility.
2022: IF FND_API.to_boolean(p_init_msg_list)
2023: THEN
2024: FND_MSG_PUB.initialize;
2025: END IF;

Line 2065: --Standard check to count messages

2061: END LOOP;
2062: CLOSE check_items_cur;
2063:
2064: ---------------------------End of Body---------------------------------------
2065: --Standard check to count messages
2066: l_msg_count := Fnd_Msg_Pub.count_msg;
2067:
2068: IF l_msg_count > 0 THEN
2069: X_msg_count := l_msg_count;

Line 2074: --Standard check for commit

2070: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2071: RAISE Fnd_Api.G_EXC_ERROR;
2072: END IF;
2073:
2074: --Standard check for commit
2075: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2076: COMMIT;
2077: END IF;
2078: -- Debug info

Line 2149: -- Standard IN Parameters :

2145: -- visit, which are defined at Route Operation and Disposition level
2146: -- Pre-reqs :
2147: -- Parameters :
2148: --
2149: -- Standard IN Parameters :
2150: -- p_api_version IN NUMBER Required
2151: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2152: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2153: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2157: -- Standard out Parameters :

2153: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2154: -- Based on this flag, the API will set the default attributes.
2155: -- p_module_type In VARCHAR2 Default NULL
2156: -- This will be null.
2157: -- Standard out Parameters :
2158: -- x_return_status OUT VARCHAR2 Required
2159: -- x_msg_count OUT NUMBER Required
2160: -- x_msg_data OUT VARCHAR2 Required
2161: --

Line 2182: --Standard local variables

2178: x_msg_count OUT NOCOPY NUMBER,
2179: x_msg_data OUT NOCOPY VARCHAR2
2180: ) IS
2181:
2182: --Standard local variables
2183: l_api_name CONSTANT VARCHAR2(30) := 'Process_Planned_Materials';
2184: l_api_version CONSTANT NUMBER := 1.0;
2185: l_msg_data VARCHAR2(2000);
2186: l_return_status VARCHAR2(1);

Line 2210: -- Standard start of API savepoint

2206: 'At the start of PLSQL procedure'
2207: );
2208: END IF;
2209:
2210: -- Standard start of API savepoint
2211: SAVEPOINT Process_Planned_Materials;
2212: -- Initialize message list if p_init_msg_list is set to TRUE
2213: IF FND_API.To_Boolean( p_init_msg_list) THEN
2214: FND_MSG_PUB.Initialize;

Line 2547: -- Standard check of p_commit

2543: RAISE FND_API.G_EXC_ERROR;
2544: END IF;
2545: END IF;
2546: END IF;
2547: -- Standard check of p_commit
2548: IF FND_API.TO_BOOLEAN(p_commit) THEN
2549: COMMIT WORK;
2550: END IF;
2551:

Line 2600: -- Standard IN Parameters :

2596: -- visit, which are defined at Route Operation and Disposition level
2597: -- Pre-reqs :
2598: -- Parameters :
2599: --
2600: -- Standard IN Parameters :
2601: -- p_api_version IN NUMBER Required
2602: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2603: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2604: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2608: -- Standard out Parameters :

2604: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2605: -- Based on this flag, the API will set the default attributes.
2606: -- p_module_type In VARCHAR2 Default NULL
2607: -- This will be null.
2608: -- Standard out Parameters :
2609: -- x_return_status OUT VARCHAR2 Required
2610: -- x_msg_count OUT NUMBER Required
2611: -- x_msg_data OUT VARCHAR2 Required
2612: --

Line 2667: --Standard local variables

2663: scheduled_quantity
2664: FROM ahl_visit_task_matrl_v
2665: WHERE visit_id = c_visit_id;
2666:
2667: --Standard local variables
2668: l_api_name CONSTANT VARCHAR2(30) := 'Remove_Visit_Task_Matrls';
2669: l_api_version CONSTANT NUMBER := 1.0;
2670: l_msg_data VARCHAR2(2000);
2671: l_return_status VARCHAR2(1);

Line 2688: -- Standard start of API savepoint

2684: 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Visit_Task_Matrls',
2685: 'At the start of PLSQL procedure'
2686: );
2687: END IF;
2688: -- Standard start of API savepoint
2689: SAVEPOINT Remove_Visit_Task_Matrls;
2690: -- Initialize message list if p_init_msg_list is set to TRUE
2691: IF FND_API.To_Boolean( p_init_msg_list) THEN
2692: FND_MSG_PUB.Initialize;

Line 2801: --Standard check to count messages

2797: END IF; --Just task deletion
2798: END IF;
2799: x_planned_order_flag := l_planned_order_flag;
2800:
2801: --Standard check to count messages
2802: l_msg_count := Fnd_Msg_Pub.count_msg;
2803:
2804: IF l_msg_count > 0 THEN
2805: X_msg_count := l_msg_count;

Line 2810: -- Standard check of p_commit

2806: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2807: RAISE Fnd_Api.G_EXC_ERROR;
2808: END IF;
2809:
2810: -- Standard check of p_commit
2811: IF FND_API.TO_BOOLEAN(p_commit) THEN
2812: COMMIT WORK;
2813: END IF;
2814:

Line 2863: -- Standard IN Parameters :

2859: -- visit, which are defined at Route Operation and Disposition level
2860: -- Pre-reqs :
2861: -- Parameters :
2862: --
2863: -- Standard IN Parameters :
2864: -- p_api_version IN NUMBER Required
2865: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
2866: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
2867: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 2871: -- Standard out Parameters :

2867: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
2868: -- Based on this flag, the API will set the default attributes.
2869: -- p_module_type In VARCHAR2 Default NULL
2870: -- This will be null.
2871: -- Standard out Parameters :
2872: -- x_return_status OUT VARCHAR2 Required
2873: -- x_msg_count OUT NUMBER Required
2874: -- x_msg_data OUT VARCHAR2 Required
2875: --

Line 2900: --Standard local variables

2896: FROM ahl_schedule_materials
2897: WHERE visit_id = c_visit_id
2898: AND status = 'ACTIVE';
2899:
2900: --Standard local variables
2901: l_api_name CONSTANT VARCHAR2(30) := 'Update_Unplanned_Matrls';
2902: l_api_version CONSTANT NUMBER := 1.0;
2903: l_msg_data VARCHAR2(2000);
2904: l_return_status VARCHAR2(1);

Line 2918: -- Standard start of API savepoint

2914: 'At the start of PLSQL procedure'
2915: );
2916: END IF;
2917:
2918: -- Standard start of API savepoint
2919: SAVEPOINT Update_Unplanned_Matrls;
2920:
2921: -- Initialize message list if p_init_msg_list is set to TRUE
2922: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 2970: -- Standard check of p_commit

2966: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2967: RAISE Fnd_Api.g_exc_error;
2968: END IF;
2969:
2970: -- Standard check of p_commit
2971: IF FND_API.TO_BOOLEAN(p_commit) THEN
2972: COMMIT WORK;
2973: END IF;
2974:

Line 3019: -- Standard out Parameters :

3015: --
3016: -- Pre-reqs :
3017: -- Parameters :
3018: --
3019: -- Standard out Parameters :
3020: -- x_return_status OUT VARCHAR2 Required
3021: --
3022: -- Modify_Visit_Reservations Parameters :
3023: -- p_visit_id IN NUMBER,Required

Line 3059: --Standard local variables

3055: WHERE external_source_code = 'AHL'
3056: AND demand_source_header_id in ( SELECT visit_task_id
3057: FROM ahl_visit_tasks_b
3058: WHERE visit_id = p_visit_id);
3059: --Standard local variables
3060: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Visit_Reservations';
3061: l_api_version CONSTANT NUMBER := 1.0;
3062: l_msg_data VARCHAR2(2000);
3063: l_return_status VARCHAR2(1);

Line 3237: -- Standard start of API savepoint

3233: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3234: l_sch_material_id NUMBER := 0;
3235:
3236: BEGIN
3237: -- Standard start of API savepoint
3238: SAVEPOINT Update_Material_Reqrs_sts;
3239:
3240: -- Initialize return status to success before any code logic/validation
3241: x_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 3243: -- Standard call to check for call compatibility

3239:
3240: -- Initialize return status to success before any code logic/validation
3241: x_return_status:= FND_API.G_RET_STS_SUCCESS;
3242:
3243: -- Standard call to check for call compatibility
3244: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3246: END IF;
3247:

Line 3277: -- Standard check of p_commit

3273: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
3274: WHERE visit_task_id = p_visit_task_id
3275: AND STATUS = 'ACTIVE';
3276:
3277: -- Standard check of p_commit
3278: IF Fnd_Api.To_Boolean (p_commit) THEN
3279: COMMIT WORK;
3280: END IF;
3281: