DBA Data[Home] [Help]

APPS.PA_ASSET_ALLOCATION_PVT dependencies on PA_ASSET_ALLOCATION_PVT

Line 1: PACKAGE BODY PA_ASSET_ALLOCATION_PVT AS

1: PACKAGE BODY PA_ASSET_ALLOCATION_PVT AS
2: /* $Header: PACASALB.pls 120.4.12010000.2 2008/08/06 11:31:07 atshukla ship $ */
3:
4: l_mrc_flag VARCHAR2(1) := paapimp_pkg.get_mrc_flag;
5: PROCEDURE ALLOCATE_UNASSIGNED

Line 96: asset_basis_table PA_ASSET_ALLOCATION_PVT.ASSET_BASIS_TABLE_TYPE;

92: wbs_branch_tasks_rec wbs_branch_tasks_cur%ROWTYPE;
93:
94:
95:
96: asset_basis_table PA_ASSET_ALLOCATION_PVT.ASSET_BASIS_TABLE_TYPE;
97:
98: v_common_project VARCHAR2(1) := 'N';
99: v_common_task VARCHAR2(1) := 'N';
100: v_common_lowest_task VARCHAR2(1) := 'N';

Line 1100: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1096: x_err_asset_id := 0;
1097: x_error_code := 'NO_ASSIGNMENTS';
1098: x_return_status := 'E';
1099: x_msg_count := x_msg_count + 1;
1100: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1101: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1102: p_error_text => SUBSTRB(x_msg_data,1,240));
1103: RETURN;
1104:

Line 1139: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1135: x_err_asset_id := v_project_asset_id;
1136: x_error_code := 'ASSET_INVALID_FOR_PROJECT';
1137: x_return_status := 'E';
1138: x_msg_count := x_msg_count + 1;
1139: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1140: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1141: p_error_text => SUBSTRB(x_msg_data,1,240));
1142: RETURN;
1143:

Line 1152: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1148: x_err_asset_id := v_project_asset_id;
1149: x_error_code := 'ASSET_NO_GENERATION';
1150: x_return_status := 'E';
1151: x_msg_count := x_msg_count + 1;
1152: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1153: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1154: p_error_text => SUBSTRB(x_msg_data,1,240));
1155: RETURN;
1156:

Line 1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1161: x_err_asset_id := v_project_asset_id;
1162: x_error_code := 'ASSET_NO_DPIS';
1163: x_return_status := 'E';
1164: x_msg_count := x_msg_count + 1;
1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1166: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1167: p_error_text => SUBSTRB(x_msg_data,1,240));
1168: RETURN;
1169:

Line 1178: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1174: x_err_asset_id := v_project_asset_id;
1175: x_error_code := 'ASSET_TYPE_MISMATCH';
1176: x_return_status := 'E';
1177: x_msg_count := x_msg_count + 1;
1178: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1179: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1180: p_error_text => SUBSTRB(x_msg_data,1,240));
1181: RETURN;
1182:

Line 1191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1187: x_err_asset_id := 0;
1188: x_error_code := 'ZERO_TOTAL_BASIS';
1189: x_return_status := 'E';
1190: x_msg_count := x_msg_count + 1;
1191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1192: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1193: p_error_text => SUBSTRB(x_msg_data,1,240));
1194: x_return_status := 'E';
1195: RETURN;

Line 1205: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1201: x_err_asset_id := 0;
1202: x_error_code := 'NEGATIVE_TOTAL_BASIS';
1203: x_return_status := 'E';
1204: x_msg_count := x_msg_count + 1;
1205: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1206: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1207: p_error_text => SUBSTRB(x_msg_data,1,240));
1208: RETURN;
1209:

Line 1218: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1214: x_err_asset_id := 0;
1215: x_error_code := 'NULL_TOTAL_BASIS';
1216: x_return_status := 'E';
1217: x_msg_count := x_msg_count + 1;
1218: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1219: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1220: p_error_text => SUBSTRB(x_msg_data,1,240));
1221: RETURN;
1222:

Line 1231: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1227: x_err_asset_id := v_project_asset_id;
1228: x_error_code := 'NULL_ASSET_BASIS';
1229: x_return_status := 'E';
1230: x_msg_count := x_msg_count + 1;
1231: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1232: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1233: p_error_text => SUBSTRB(x_msg_data,1,240));
1234: x_return_status := 'E';
1235: RETURN;

Line 1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1241: x_err_asset_id := v_project_asset_id;
1242: x_error_code := 'NEGATIVE_ASSET_BASIS';
1243: x_return_status := 'E';
1244: x_msg_count := x_msg_count + 1;
1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1246: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1247: p_error_text => SUBSTRB(x_msg_data,1,240));
1248: RETURN;
1249:

Line 1258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1254: x_err_asset_id := 0;
1255: x_error_code := 'INCONSISTENT_TOTAL_BASIS';
1256: x_return_status := 'E';
1257: x_msg_count := x_msg_count + 1;
1258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1259: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1260: p_error_text => SUBSTRB(x_msg_data,1,240));
1261: x_return_status := 'E';
1262: RETURN;

Line 1272: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1268: x_err_asset_id := 0;
1269: x_error_code := 'ASSET_BASIS_SUM';
1270: x_return_status := 'E';
1271: x_msg_count := x_msg_count + 1;
1272: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1273: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1274: p_error_text => SUBSTRB(x_msg_data,1,240));
1275: RETURN;
1276:

Line 1285: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1281: x_err_asset_id := v_project_asset_id;
1282: x_error_code := 'STANDARD_COST_MISSING';
1283: x_return_status := 'E';
1284: x_msg_count := x_msg_count + 1;
1285: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1286: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1287: p_error_text => SUBSTRB(x_msg_data,1,240));
1288: RETURN;
1289:

Line 1295: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1291: WHEN error_calling_update_cost THEN
1292: x_return_status := 'U';
1293: x_msg_count := x_msg_count + 1;
1294: x_msg_data := v_err_code||' Error calling update_asset_cost for project asset id '||v_project_asset_id||' '||SQLERRM;
1295: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1296: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1297: p_error_text => SUBSTRB(x_msg_data,1,240));
1298: ROLLBACK;
1299: RAISE;

Line 1306: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',

1302: WHEN OTHERS THEN
1303: x_return_status := 'U';
1304: x_msg_count := x_msg_count + 1;
1305: x_msg_data := 'Unexpected '||SQLCODE||' '||SQLERRM||' in ALLOCATE_UNASSIGNED for PROJECT ID: '||p_project_id;
1306: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSET_ALLOCATION_PVT',
1307: p_procedure_name => 'ALLOCATE_UNASSIGNED',
1308: p_error_text => SUBSTRB(x_msg_data,1,240));
1309: ROLLBACK;
1310: RAISE;

Line 1315: END PA_ASSET_ALLOCATION_PVT;

1311:
1312: END ALLOCATE_UNASSIGNED;
1313:
1314:
1315: END PA_ASSET_ALLOCATION_PVT;