APPS.EAM_CONSTRUCTION_EST_PUB dependencies on FND_API

Line 41: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

37: END EXPLODE_INITIAL_ESTIMATE;
38:
39: PROCEDURE INSERT_PARENT_WO_LINE(
40: p_api_version IN NUMBER := 1.0
41: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42: , p_commit IN VARCHAR2
43: , p_estimate_id IN NUMBER
44: , p_parent_wo_line_rec IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
45: , x_return_status OUT NOCOPY VARCHAR2

Line 67: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

63: END INSERT_PARENT_WO_LINE;
64:
65: PROCEDURE DELETE_WO_LINE(
66: p_api_version IN NUMBER := 1.0
67: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: , p_commit IN VARCHAR2
69: , p_work_order_line_id IN NUMBER
70: , x_return_status OUT NOCOPY VARCHAR2
71: , x_msg_count OUT NOCOPY NUMBER

Line 91: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

87: END DELETE_WO_LINE;
88:
89: PROCEDURE CREATE_CU_WORKORDERS(
90: p_api_version IN NUMBER := 1.0
91: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
93: ,p_estimate_id IN NUMBER
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER

Line 92: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

88:
89: PROCEDURE CREATE_CU_WORKORDERS(
90: p_api_version IN NUMBER := 1.0
91: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
93: ,p_estimate_id IN NUMBER
94: ,x_return_status OUT NOCOPY VARCHAR2
95: ,x_msg_count OUT NOCOPY NUMBER
96: ,x_msg_data OUT NOCOPY VARCHAR2

Line 133: RAISE FND_API.G_EXC_ERROR;

129:
130: IF nvl(x_return_status,'S') <> 'S' THEN
131: -- Log error, but continue processing
132: x_return_status := 'E';
133: RAISE FND_API.G_EXC_ERROR;
134: END IF; -- nvl(l_return_status,'S') <> 'S'
135:
136: -- Now that work orders are created, need to handle condition
137: -- where work order number was not provided, but assigned

Line 141: IF NVL(l_est_wo_rec.ESTIMATE_WORK_ORDER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

137: -- where work order number was not provided, but assigned
138: -- automaticially by the work order API
139: FOR l_est_wo_rec IN EST_WORKORDERS
140: LOOP
141: IF NVL(l_est_wo_rec.ESTIMATE_WORK_ORDER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
142: -- Find the wip entity name for the estimate work order id
143: OPEN GET_WOKRODER_NAME(l_est_wo_rec.ESTIMATE_WORK_ORDER_ID);
144: FETCH GET_WOKRODER_NAME INTO l_wip_name_rec;
145: CLOSE GET_WOKRODER_NAME;

Line 153: END IF; -- NVL(l_est_wo_rec.ESTIMATE_WORK_ORDER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM

149: WHERE ESTIMATE_ID = p_estimate_id
150: AND ORGANIZATION_ID = p_organization_id
151: AND ESTIMATE_WORK_ORDER_ID = l_est_wo_rec.ESTIMATE_WORK_ORDER_ID;
152:
153: END IF; -- NVL(l_est_wo_rec.ESTIMATE_WORK_ORDER_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
154: END LOOP; -- FOR l_est_wo_rec IN EST_WORKORDERS
155:
156: IF NVL(p_commit,'F') = 'T' THEN
157: COMMIT;

Line 162: WHEN FND_API.G_EXC_ERROR THEN

158: END IF;
159:
160: x_return_status := 'S';
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163: x_return_status := 'E';
164: WHEN OTHERS THEN
165: x_return_status := 'E';
166: END CREATE_CU_WORKORDERS;

Line 170: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

166: END CREATE_CU_WORKORDERS;
167:
168: PROCEDURE INSERT_ALL_WO_LINES(
169: p_api_version IN NUMBER := 1.0
170: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
171: , p_commit IN VARCHAR2
172: , p_estimate_id IN NUMBER
173: , p_eam_ce_wo_lines_tbl IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
174: , x_return_status OUT NOCOPY VARCHAR2