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.CST_EAMJOB_ACTESTIMATE dependencies on FND_API

Line 115: := FND_API.G_FALSE,

111: ----------------------------------------------------------------------------
112: PROCEDURE Get_DeptCostCatg (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2
115: := FND_API.G_FALSE,
116: p_commit IN VARCHAR2
117: := FND_API.G_FALSE,
118: p_validation_level IN NUMBER
119: := FND_API.G_VALID_LEVEL_FULL, p_debug IN VARCHAR2 := 'N',

Line 117: := FND_API.G_FALSE,

113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2
115: := FND_API.G_FALSE,
116: p_commit IN VARCHAR2
117: := FND_API.G_FALSE,
118: p_validation_level IN NUMBER
119: := FND_API.G_VALID_LEVEL_FULL, p_debug IN VARCHAR2 := 'N',
120:
121: p_department_id IN NUMBER := NULL,

Line 119: := FND_API.G_VALID_LEVEL_FULL, p_debug IN VARCHAR2 := 'N',

115: := FND_API.G_FALSE,
116: p_commit IN VARCHAR2
117: := FND_API.G_FALSE,
118: p_validation_level IN NUMBER
119: := FND_API.G_VALID_LEVEL_FULL, p_debug IN VARCHAR2 := 'N',
120:
121: p_department_id IN NUMBER := NULL,
122: p_organization_id IN NUMBER := NULL,
123:

Line 138: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

134:
135: l_api_name CONSTANT VARCHAR2(30) := 'Get_DeptCostCatg';
136: l_api_version CONSTANT NUMBER := 1.0;
137: l_api_message VARCHAR2(10000);
138: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
139:
140: l_organization_id NUMBER;
141:
142: l_msg_count NUMBER := 0;

Line 159: IF NOT fnd_api.compatible_api_call (

155:
156: -------------------------------------------------------------------------
157: -- standard call to check for call compatibility
158: -------------------------------------------------------------------------
159: IF NOT fnd_api.compatible_api_call (
160: l_api_version,
161: p_api_version,
162: l_api_name,
163: G_PKG_NAME ) then

Line 165: RAISE fnd_api.g_exc_unexpected_error;

161: p_api_version,
162: l_api_name,
163: G_PKG_NAME ) then
164:
165: RAISE fnd_api.g_exc_unexpected_error;
166:
167: END IF;
168: -------------------------------------------------------------------------
169: -- Initialize message list if p_init_msg_list is set to TRUE

Line 174: IF FND_API.to_Boolean(p_init_msg_list) THEN

170: -------------------------------------------------------------------------
171:
172: l_stmt_num := 10;
173:
174: IF FND_API.to_Boolean(p_init_msg_list) THEN
175: FND_MSG_PUB.initialize;
176: END IF;
177:
178:

Line 182: x_return_status := fnd_api.g_ret_sts_success;

178:
179: -------------------------------------------------------------------------
180: -- initialize api return status to success
181: -------------------------------------------------------------------------
182: x_return_status := fnd_api.g_ret_sts_success;
183:
184: -- assign to local variables
185:
186: l_stmt_num := 15;

Line 236: RAISE FND_API.g_exc_error;

232: ||TO_CHAR(p_department_id);
233: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'Get_DeptCostCatg('
234: ||TO_CHAR(l_stmt_num)
235: ||'): ', l_api_message);
236: RAISE FND_API.g_exc_error;
237:
238: END IF;
239:
240: l_stmt_num := 50;

Line 246: IF FND_API.to_Boolean(p_commit) THEN

242: ---------------------------------------------------------------------------
243: -- Standard check of p_commit
244: ---------------------------------------------------------------------------
245:
246: IF FND_API.to_Boolean(p_commit) THEN
247: COMMIT WORK;
248: END IF;
249:
250: ---------------------------------------------------------------------------

Line 261: WHEN fnd_api.g_exc_error THEN

257:
258:
259: EXCEPTION
260:
261: WHEN fnd_api.g_exc_error THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263:
264: -- Get message count and data
265: fnd_msg_pub.count_and_get

Line 262: x_return_status := fnd_api.g_ret_sts_error;

258:
259: EXCEPTION
260:
261: WHEN fnd_api.g_exc_error THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263:
264: -- Get message count and data
265: fnd_msg_pub.count_and_get
266: ( p_count => x_msg_count

Line 270: WHEN fnd_api.g_exc_unexpected_error THEN

266: ( p_count => x_msg_count
267: , p_data => x_msg_data
268: );
269: --
270: WHEN fnd_api.g_exc_unexpected_error THEN
271: x_return_status := fnd_api.g_ret_sts_unexp_error ;
272:
273: -- Get message count and data
274: fnd_msg_pub.count_and_get

Line 271: x_return_status := fnd_api.g_ret_sts_unexp_error ;

267: , p_data => x_msg_data
268: );
269: --
270: WHEN fnd_api.g_exc_unexpected_error THEN
271: x_return_status := fnd_api.g_ret_sts_unexp_error ;
272:
273: -- Get message count and data
274: fnd_msg_pub.count_and_get
275: ( p_count => x_msg_count

Line 280: x_return_status := fnd_api.g_ret_sts_unexp_error ;

276: , p_data => x_msg_data
277: );
278: --
279: WHEN OTHERS THEN
280: x_return_status := fnd_api.g_ret_sts_unexp_error ;
281: --
282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
283: THEN
284: fnd_msg_pub.add_exc_msg

Line 319: := FND_API.G_FALSE,

315: ----------------------------------------------------------------------------
316: PROCEDURE Compute_Activity_Estimate (
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2
319: := FND_API.G_FALSE,
320: p_commit IN VARCHAR2
321: := FND_API.G_FALSE,
322: p_validation_level IN NUMBER
323: := FND_API.G_VALID_LEVEL_FULL,

Line 321: := FND_API.G_FALSE,

317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2
319: := FND_API.G_FALSE,
320: p_commit IN VARCHAR2
321: := FND_API.G_FALSE,
322: p_validation_level IN NUMBER
323: := FND_API.G_VALID_LEVEL_FULL,
324: p_debug IN VARCHAR2 := 'N',
325:

Line 323: := FND_API.G_VALID_LEVEL_FULL,

319: := FND_API.G_FALSE,
320: p_commit IN VARCHAR2
321: := FND_API.G_FALSE,
322: p_validation_level IN NUMBER
323: := FND_API.G_VALID_LEVEL_FULL,
324: p_debug IN VARCHAR2 := 'N',
325:
326: p_activity_item_id IN NUMBER,
327: p_organization_id IN NUMBER,

Line 363: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

359: l_cost_group_id NUMBER := 0;
360: l_primary_cost_method NUMBER := 0;
361: l_maint_cost_category NUMBER := 0;
362: l_eam_cost_element NUMBER := 0;
363: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
364: l_api_message VARCHAR2(10000);
365: l_stmt_num NUMBER;
366: l_dept_id NUMBER := 0;
367: l_dummy NUMBER := 0;

Line 582: IF NOT fnd_api.compatible_api_call (

578: -- standard call to check for call compatibility
579: -------------------------------------------------------------------------
580: l_stmt_num := 5;
581:
582: IF NOT fnd_api.compatible_api_call (
583: l_api_version,
584: p_api_version,
585: l_api_name,
586: G_PKG_NAME ) then

Line 588: RAISE fnd_api.g_exc_unexpected_error;

584: p_api_version,
585: l_api_name,
586: G_PKG_NAME ) then
587:
588: RAISE fnd_api.g_exc_unexpected_error;
589:
590: END IF;
591:
592: -------------------------------------------------------------------------

Line 596: IF FND_API.to_Boolean(p_init_msg_list) THEN

592: -------------------------------------------------------------------------
593: -- Initialize message list if p_init_msg_list is set to TRUE
594: -------------------------------------------------------------------------
595:
596: IF FND_API.to_Boolean(p_init_msg_list) THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600:

Line 604: x_return_status := fnd_api.g_ret_sts_success;

600:
601: -------------------------------------------------------------------------
602: -- initialize api return status to success
603: -------------------------------------------------------------------------
604: x_return_status := fnd_api.g_ret_sts_success;
605:
606: -- assign to local variables
607:
608: -------------------------------------------------------------------------

Line 628: RAISE FND_API.g_exc_error;

624:
625: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('
626: ||TO_CHAR(l_stmt_num)
627: ||'): ', l_api_message);
628: RAISE FND_API.g_exc_error;
629:
630: END IF;
631:
632: -------------------------------------------------------------------------

Line 686: RAISE FND_API.g_exc_error;

682:
683: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('
684: ||TO_CHAR(l_stmt_num)
685: ||'): ', l_api_message);
686: RAISE FND_API.g_exc_error;
687:
688: ELSE
689:
690: l_stmt_num := 35;

Line 768: IF l_return_status <> FND_API.g_ret_sts_success THEN

764:
765: x_msg_count => l_msg_count,
766: x_msg_data => l_msg_data );
767:
768: IF l_return_status <> FND_API.g_ret_sts_success THEN
769:
770: l_api_message := 'Get_DeptCostCatg returned error';
771: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_Activty_Estimate('
772: ||TO_CHAR(l_stmt_num)

Line 774: RAISE FND_API.g_exc_error;

770: l_api_message := 'Get_DeptCostCatg returned error';
771: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_Activty_Estimate('
772: ||TO_CHAR(l_stmt_num)
773: ||'): ', l_api_message);
774: RAISE FND_API.g_exc_error;
775:
776: END IF;
777:
778: l_stmt_num := 50;

Line 791: RAISE FND_API.g_exc_error;

787: l_api_message := 'Get_eamCostElement returned error';
788: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_JOB_ESTIMATES('
789: ||TO_CHAR(l_stmt_num)
790: ||'): ', l_api_message);
791: RAISE FND_API.g_exc_error;
792:
793: END IF;
794:
795: IF (p_debug = 'Y') THEN

Line 920: IF l_return_status <> FND_API.g_ret_sts_success THEN

916: x_return_status => l_return_status,
917: x_msg_count => l_msg_count,
918: x_msg_data => l_msg_data );
919:
920: IF l_return_status <> FND_API.g_ret_sts_success THEN
921:
922: l_api_message := 'Get_DeptCostCatg returned error';
923:
924: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOAB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('

Line 927: RAISE FND_API.g_exc_error;

923:
924: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOAB_ACTESTIMATE', 'COMPUTE_ACTIVITY_EST('
925: ||TO_CHAR(l_stmt_num)
926: ||'): ', l_api_message);
927: RAISE FND_API.g_exc_error;
928:
929: END IF;
930:
931: l_stmt_num := 85;

Line 944: RAISE FND_API.g_exc_error;

940:
941: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'COMPUTE_ACTIVITY_ESTIMATE('
942: ||TO_CHAR(l_stmt_num)
943: ||'): ', l_api_message);
944: RAISE FND_API.g_exc_error;
945:
946: END IF;
947:
948: IF (p_debug = 'Y') THEN

Line 987: IF FND_API.to_Boolean(p_commit) THEN

983: ---------------------------------------------------------------------------
984: -- Standard check of p_commit
985: ---------------------------------------------------------------------------
986:
987: IF FND_API.to_Boolean(p_commit) THEN
988: COMMIT WORK;
989: END IF;
990:
991: ---------------------------------------------------------------------------

Line 1001: WHEN fnd_api.g_exc_error THEN

997: p_data => x_msg_data );
998:
999: EXCEPTION
1000:
1001: WHEN fnd_api.g_exc_error THEN
1002: x_return_status := fnd_api.g_ret_sts_error;
1003:
1004: -- Get message count and data
1005: fnd_msg_pub.count_and_get

Line 1002: x_return_status := fnd_api.g_ret_sts_error;

998:
999: EXCEPTION
1000:
1001: WHEN fnd_api.g_exc_error THEN
1002: x_return_status := fnd_api.g_ret_sts_error;
1003:
1004: -- Get message count and data
1005: fnd_msg_pub.count_and_get
1006: ( p_count => x_msg_count

Line 1010: WHEN fnd_api.g_exc_unexpected_error THEN

1006: ( p_count => x_msg_count
1007: , p_data => x_msg_data
1008: );
1009: --
1010: WHEN fnd_api.g_exc_unexpected_error THEN
1011: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1012:
1013: -- Get message count and data
1014: fnd_msg_pub.count_and_get

Line 1011: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1007: , p_data => x_msg_data
1008: );
1009: --
1010: WHEN fnd_api.g_exc_unexpected_error THEN
1011: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1012:
1013: -- Get message count and data
1014: fnd_msg_pub.count_and_get
1015: ( p_count => x_msg_count

Line 1020: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1016: , p_data => x_msg_data
1017: );
1018: --
1019: WHEN OTHERS THEN
1020: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1021: --
1022: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1023: THEN
1024: fnd_msg_pub.add_exc_msg

Line 1060: := FND_API.G_FALSE,

1056: ----------------------------------------------------------------------------
1057: PROCEDURE Get_Activity_Estimate (
1058: p_api_version IN NUMBER,
1059: p_init_msg_list IN VARCHAR2
1060: := FND_API.G_FALSE,
1061: p_commit IN VARCHAR2
1062: := FND_API.G_FALSE,
1063: p_validation_level IN NUMBER
1064: := FND_API.G_VALID_LEVEL_FULL,

Line 1062: := FND_API.G_FALSE,

1058: p_api_version IN NUMBER,
1059: p_init_msg_list IN VARCHAR2
1060: := FND_API.G_FALSE,
1061: p_commit IN VARCHAR2
1062: := FND_API.G_FALSE,
1063: p_validation_level IN NUMBER
1064: := FND_API.G_VALID_LEVEL_FULL,
1065: p_debug IN VARCHAR2 := 'N',
1066:

Line 1064: := FND_API.G_VALID_LEVEL_FULL,

1060: := FND_API.G_FALSE,
1061: p_commit IN VARCHAR2
1062: := FND_API.G_FALSE,
1063: p_validation_level IN NUMBER
1064: := FND_API.G_VALID_LEVEL_FULL,
1065: p_debug IN VARCHAR2 := 'N',
1066:
1067: p_activity_item_id IN NUMBER,
1068: p_organization_id IN NUMBER,

Line 1089: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1085:
1086: l_api_name CONSTANT VARCHAR2(30) := 'Compute_Activity_Estimate';
1087: l_api_version CONSTANT NUMBER := 1.0;
1088: l_api_message VARCHAR2(10000);
1089: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1090:
1091: l_stmt_num NUMBER;
1092: l_msg_count NUMBER := 0;
1093: l_msg_data VARCHAR2(8000) := '';

Line 1111: IF NOT fnd_api.compatible_api_call (

1107: -- standard call to check for call compatibility
1108: -------------------------------------------------------------------------
1109: l_stmt_num := 5;
1110:
1111: IF NOT fnd_api.compatible_api_call (
1112: l_api_version,
1113: p_api_version,
1114: l_api_name,
1115: G_PKG_NAME ) then

Line 1117: RAISE fnd_api.g_exc_unexpected_error;

1113: p_api_version,
1114: l_api_name,
1115: G_PKG_NAME ) then
1116:
1117: RAISE fnd_api.g_exc_unexpected_error;
1118:
1119: END IF;
1120:
1121: -------------------------------------------------------------------------

Line 1125: IF FND_API.to_Boolean(p_init_msg_list) THEN

1121: -------------------------------------------------------------------------
1122: -- Initialize message list if p_init_msg_list is set to TRUE
1123: -------------------------------------------------------------------------
1124:
1125: IF FND_API.to_Boolean(p_init_msg_list) THEN
1126: FND_MSG_PUB.initialize;
1127: END IF;
1128:
1129:

Line 1133: x_return_status := fnd_api.g_ret_sts_success;

1129:
1130: -------------------------------------------------------------------------
1131: -- initialize api return status to success
1132: -------------------------------------------------------------------------
1133: x_return_status := fnd_api.g_ret_sts_success;
1134:
1135: -- assign to local variables
1136:
1137: Compute_Activity_Estimate (

Line 1158: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

1154: x_return_status => l_return_status,
1155: x_msg_count => l_msg_count,
1156: x_msg_data => l_msg_data ) ;
1157:
1158: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
1159:
1160: l_api_message := 'Compute_Activity_Estimate returned error';
1161:
1162: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'GET_ACTIVITY_EST('

Line 1165: RAISE FND_API.g_exc_error;

1161:
1162: FND_MSG_PUB.ADD_EXC_MSG('CST_EAMJOB_ACTESTIMATE', 'GET_ACTIVITY_EST('
1163: ||TO_CHAR(l_stmt_num)
1164: ||'): ', l_api_message);
1165: RAISE FND_API.g_exc_error;
1166:
1167: END IF;
1168:
1169: IF l_ActivityEstimateTable.EXISTS(1) THEN

Line 1231: IF FND_API.to_Boolean(p_commit) THEN

1227: ---------------------------------------------------------------------------
1228: -- Standard check of p_commit
1229: ---------------------------------------------------------------------------
1230:
1231: IF FND_API.to_Boolean(p_commit) THEN
1232: COMMIT WORK;
1233: END IF;
1234:
1235: ---------------------------------------------------------------------------

Line 1246: WHEN fnd_api.g_exc_error THEN

1242:
1243:
1244: EXCEPTION
1245:
1246: WHEN fnd_api.g_exc_error THEN
1247: x_return_status := fnd_api.g_ret_sts_error;
1248:
1249: -- Get message count and data
1250: fnd_msg_pub.count_and_get

Line 1247: x_return_status := fnd_api.g_ret_sts_error;

1243:
1244: EXCEPTION
1245:
1246: WHEN fnd_api.g_exc_error THEN
1247: x_return_status := fnd_api.g_ret_sts_error;
1248:
1249: -- Get message count and data
1250: fnd_msg_pub.count_and_get
1251: ( p_count => x_msg_count

Line 1255: WHEN fnd_api.g_exc_unexpected_error THEN

1251: ( p_count => x_msg_count
1252: , p_data => x_msg_data
1253: );
1254: --
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1257:
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get

Line 1256: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1252: , p_data => x_msg_data
1253: );
1254: --
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1257:
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get
1260: ( p_count => x_msg_count

Line 1265: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1261: , p_data => x_msg_data
1262: );
1263: --
1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1266: --
1267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1268: THEN
1269: fnd_msg_pub.add_exc_msg