DBA Data[Home] [Help]

APPS.EAM_REQUIREMENTS_PKG dependencies on FND_API

Line 438: l_eam_mat_req_rec.comments := FND_API.G_MISS_CHAR;

434: /*---- code added for bug 8969942 -----start --*/
435:
436:
437: IF l_prev_comments is not null and X_comments is null THEN
438: l_eam_mat_req_rec.comments := FND_API.G_MISS_CHAR;
439: ELSE
440: l_eam_mat_req_rec.comments := X_comments;
441: END IF;
442:

Line 444: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;

440: l_eam_mat_req_rec.comments := X_comments;
441: END IF;
442:
443: IF l_prev_attribute_category is not null and X_attribute_category is null THEN
444: l_eam_mat_req_rec.attribute_category := FND_API.G_MISS_CHAR;
445: ELSE
446: l_eam_mat_req_rec.attribute_category := X_attribute_category;
447: END IF;
448:

Line 450: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;

446: l_eam_mat_req_rec.attribute_category := X_attribute_category;
447: END IF;
448:
449: IF l_prev_attribute1 is not null and X_attribute1 is null THEN
450: l_eam_mat_req_rec.attribute1 := FND_API.G_MISS_CHAR;
451: ELSE
452: l_eam_mat_req_rec.attribute1 := X_attribute1;
453: END IF;
454:

Line 456: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;

452: l_eam_mat_req_rec.attribute1 := X_attribute1;
453: END IF;
454:
455: IF l_prev_attribute2 is not null and X_attribute2 is null THEN
456: l_eam_mat_req_rec.attribute2 := FND_API.G_MISS_CHAR;
457: ELSE
458: l_eam_mat_req_rec.attribute2 := X_attribute2;
459: END IF;
460:

Line 462: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;

458: l_eam_mat_req_rec.attribute2 := X_attribute2;
459: END IF;
460:
461: IF l_prev_attribute3 is not null and X_attribute3 is null THEN
462: l_eam_mat_req_rec.attribute3 := FND_API.G_MISS_CHAR;
463: ELSE
464: l_eam_mat_req_rec.attribute3 := X_attribute3;
465: END IF;
466:

Line 468: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;

464: l_eam_mat_req_rec.attribute3 := X_attribute3;
465: END IF;
466:
467: IF l_prev_attribute4 is not null and X_attribute4 is null THEN
468: l_eam_mat_req_rec.attribute4 := FND_API.G_MISS_CHAR;
469: ELSE
470: l_eam_mat_req_rec.attribute4 := X_attribute4;
471: END IF;
472:

Line 474: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;

470: l_eam_mat_req_rec.attribute4 := X_attribute4;
471: END IF;
472:
473: IF l_prev_attribute5 is not null and X_attribute5 is null THEN
474: l_eam_mat_req_rec.attribute5 := FND_API.G_MISS_CHAR;
475: ELSE
476: l_eam_mat_req_rec.attribute5 := X_attribute5;
477: END IF;
478:

Line 480: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;

476: l_eam_mat_req_rec.attribute5 := X_attribute5;
477: END IF;
478:
479: IF l_prev_attribute6 is not null and X_attribute6 is null THEN
480: l_eam_mat_req_rec.attribute6 := FND_API.G_MISS_CHAR;
481: ELSE
482: l_eam_mat_req_rec.attribute6 := X_attribute6;
483: END IF;
484:

Line 486: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;

482: l_eam_mat_req_rec.attribute6 := X_attribute6;
483: END IF;
484:
485: IF l_prev_attribute7 is not null and X_attribute7 is null THEN
486: l_eam_mat_req_rec.attribute7 := FND_API.G_MISS_CHAR;
487: ELSE
488: l_eam_mat_req_rec.attribute7 := X_attribute7;
489: END IF;
490:

Line 492: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;

488: l_eam_mat_req_rec.attribute7 := X_attribute7;
489: END IF;
490:
491: IF l_prev_attribute8 is not null and X_attribute8 is null THEN
492: l_eam_mat_req_rec.attribute8 := FND_API.G_MISS_CHAR;
493: ELSE
494: l_eam_mat_req_rec.attribute8 := X_attribute8;
495: END IF;
496:

Line 498: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;

494: l_eam_mat_req_rec.attribute8 := X_attribute8;
495: END IF;
496:
497: IF l_prev_attribute9 is not null and X_attribute9 is null THEN
498: l_eam_mat_req_rec.attribute9 := FND_API.G_MISS_CHAR;
499: ELSE
500: l_eam_mat_req_rec.attribute9 := X_attribute9;
501: END IF;
502:

Line 504: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;

500: l_eam_mat_req_rec.attribute9 := X_attribute9;
501: END IF;
502:
503: IF l_prev_attribute10 is not null and X_attribute10 is null THEN
504: l_eam_mat_req_rec.attribute10 := FND_API.G_MISS_CHAR;
505: ELSE
506: l_eam_mat_req_rec.attribute10 := X_attribute10;
507: END IF;
508:

Line 510: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;

506: l_eam_mat_req_rec.attribute10 := X_attribute10;
507: END IF;
508:
509: IF l_prev_attribute11 is not null and X_attribute11 is null THEN
510: l_eam_mat_req_rec.attribute11 := FND_API.G_MISS_CHAR;
511: ELSE
512: l_eam_mat_req_rec.attribute11 := X_attribute11;
513: END IF;
514:

Line 516: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;

512: l_eam_mat_req_rec.attribute11 := X_attribute11;
513: END IF;
514:
515: IF l_prev_attribute12 is not null and X_attribute12 is null THEN
516: l_eam_mat_req_rec.attribute12 := FND_API.G_MISS_CHAR;
517: ELSE
518: l_eam_mat_req_rec.attribute12 := X_attribute12;
519: END IF;
520:

Line 522: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;

518: l_eam_mat_req_rec.attribute12 := X_attribute12;
519: END IF;
520:
521: IF l_prev_attribute13 is not null and X_attribute13 is null THEN
522: l_eam_mat_req_rec.attribute13 := FND_API.G_MISS_CHAR;
523: ELSE
524: l_eam_mat_req_rec.attribute13 := X_attribute13;
525: END IF;
526:

Line 528: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;

524: l_eam_mat_req_rec.attribute13 := X_attribute13;
525: END IF;
526:
527: IF l_prev_attribute14 is not null and X_attribute14 is null THEN
528: l_eam_mat_req_rec.attribute14 := FND_API.G_MISS_CHAR;
529: ELSE
530: l_eam_mat_req_rec.attribute14 := X_attribute14;
531: END IF;
532:

Line 534: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;

530: l_eam_mat_req_rec.attribute14 := X_attribute14;
531: END IF;
532:
533: IF l_prev_attribute15 is not null and X_attribute15 is null THEN
534: l_eam_mat_req_rec.attribute15 := FND_API.G_MISS_CHAR;
535: ELSE
536: l_eam_mat_req_rec.attribute15 := X_attribute15;
537: END IF;
538:

Line 943: IF p_commit = FND_API.G_TRUE THEN

939:
940:
941: BEGIN
942:
943: IF p_commit = FND_API.G_TRUE THEN
944: SAVEPOINT delete_row_ss;
945: END IF;
946:
947: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 947: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

943: IF p_commit = FND_API.G_TRUE THEN
944: SAVEPOINT delete_row_ss;
945: END IF;
946:
947: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
948: FND_MSG_PUB.initialize;
949: END IF;
950:
951: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

947: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
948: FND_MSG_PUB.initialize;
949: END IF;
950:
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953:
954:
955:

Line 1030: (p_encoded => FND_API.G_FALSE,

1026: -- if validate not passed then raise error
1027: /* l_msg_count := FND_MSG_PUB.count_msg;
1028: IF l_msg_count = 1 THEN
1029: eam_execution_jsp.Get_Messages
1030: (p_encoded => FND_API.G_FALSE,
1031: p_msg_index => 1,
1032: p_msg_count => l_msg_count,
1033: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
1034: p_data => l_data,

Line 1033: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),

1029: eam_execution_jsp.Get_Messages
1030: (p_encoded => FND_API.G_FALSE,
1031: p_msg_index => 1,
1032: p_msg_count => l_msg_count,
1033: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
1034: p_data => l_data,
1035: p_msg_index_out => l_msg_index_out);
1036: x_msg_count := l_msg_count;
1037: x_msg_data := l_msg_data;

Line 1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1039: x_msg_count := l_msg_count;
1040: END IF;
1041:
1042: IF l_msg_count > 0 THEN
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046: */
1047:

Line 1044: RAISE FND_API.G_EXC_ERROR;

1040: END IF;
1041:
1042: IF l_msg_count > 0 THEN
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046: */
1047:
1048:

Line 1049: IF FND_API.TO_BOOLEAN(P_COMMIT)

1045: END IF;
1046: */
1047:
1048:
1049: IF FND_API.TO_BOOLEAN(P_COMMIT)
1050: AND x_return_status = 'S' THEN
1051: COMMIT WORK;
1052: END IF;
1053:

Line 1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1051: COMMIT WORK;
1052: END IF;
1053:
1054: EXCEPTION
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: IF p_commit = FND_API.G_TRUE THEN
1057: ROLLBACK TO delete_row_ss;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1056: IF p_commit = FND_API.G_TRUE THEN

1052: END IF;
1053:
1054: EXCEPTION
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: IF p_commit = FND_API.G_TRUE THEN
1057: ROLLBACK TO delete_row_ss;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: WHEN FND_API.G_EXC_ERROR THEN

Line 1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: IF p_commit = FND_API.G_TRUE THEN
1057: ROLLBACK TO delete_row_ss;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: IF p_commit = FND_API.G_TRUE THEN
1062: ROLLBACK TO delete_row_ss;
1063: END IF;

Line 1060: WHEN FND_API.G_EXC_ERROR THEN

1056: IF p_commit = FND_API.G_TRUE THEN
1057: ROLLBACK TO delete_row_ss;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: IF p_commit = FND_API.G_TRUE THEN
1062: ROLLBACK TO delete_row_ss;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1061: IF p_commit = FND_API.G_TRUE THEN

1057: ROLLBACK TO delete_row_ss;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: IF p_commit = FND_API.G_TRUE THEN
1062: ROLLBACK TO delete_row_ss;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: WHEN OTHERS THEN

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1060: WHEN FND_API.G_EXC_ERROR THEN
1061: IF p_commit = FND_API.G_TRUE THEN
1062: ROLLBACK TO delete_row_ss;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: WHEN OTHERS THEN
1066: IF p_commit = FND_API.G_TRUE THEN
1067: ROLLBACK TO delete_row_ss;
1068: END IF;

Line 1066: IF p_commit = FND_API.G_TRUE THEN

1062: ROLLBACK TO delete_row_ss;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: WHEN OTHERS THEN
1066: IF p_commit = FND_API.G_TRUE THEN
1067: ROLLBACK TO delete_row_ss;
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065: WHEN OTHERS THEN
1066: IF p_commit = FND_API.G_TRUE THEN
1067: ROLLBACK TO delete_row_ss;
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:
1071: END Delete_Row_SS;
1072:
1073:

Line 1144: IF p_commit = FND_API.G_TRUE THEN

1140: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
1141:
1142: BEGIN
1143:
1144: IF p_commit = FND_API.G_TRUE THEN
1145: SAVEPOINT delete_desc_row_ss;
1146: END IF;
1147:
1148: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 1148: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

1144: IF p_commit = FND_API.G_TRUE THEN
1145: SAVEPOINT delete_desc_row_ss;
1146: END IF;
1147:
1148: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1149: FND_MSG_PUB.initialize;
1150: END IF;
1151:
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1152: x_return_status := FND_API.G_RET_STS_SUCCESS;

1148: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
1149: FND_MSG_PUB.initialize;
1150: END IF;
1151:
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;
1153: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
1154:
1155:
1156: l_eam_direct_item_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line 1211: IF FND_API.TO_BOOLEAN(P_COMMIT)

1207: );
1208:
1209:
1210:
1211: IF FND_API.TO_BOOLEAN(P_COMMIT)
1212: AND x_return_status = 'S' THEN
1213: COMMIT WORK;
1214: END IF;
1215:

Line 1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1213: COMMIT WORK;
1214: END IF;
1215:
1216: EXCEPTION
1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1218: IF p_commit = FND_API.G_TRUE THEN
1219: ROLLBACK TO delete_desc_row_ss;
1220: END IF;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1218: IF p_commit = FND_API.G_TRUE THEN

1214: END IF;
1215:
1216: EXCEPTION
1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1218: IF p_commit = FND_API.G_TRUE THEN
1219: ROLLBACK TO delete_desc_row_ss;
1220: END IF;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: WHEN FND_API.G_EXC_ERROR THEN

Line 1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1218: IF p_commit = FND_API.G_TRUE THEN
1219: ROLLBACK TO delete_desc_row_ss;
1220: END IF;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: WHEN FND_API.G_EXC_ERROR THEN
1223: IF p_commit = FND_API.G_TRUE THEN
1224: ROLLBACK TO delete_desc_row_ss;
1225: END IF;

Line 1222: WHEN FND_API.G_EXC_ERROR THEN

1218: IF p_commit = FND_API.G_TRUE THEN
1219: ROLLBACK TO delete_desc_row_ss;
1220: END IF;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: WHEN FND_API.G_EXC_ERROR THEN
1223: IF p_commit = FND_API.G_TRUE THEN
1224: ROLLBACK TO delete_desc_row_ss;
1225: END IF;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1223: IF p_commit = FND_API.G_TRUE THEN

1219: ROLLBACK TO delete_desc_row_ss;
1220: END IF;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: WHEN FND_API.G_EXC_ERROR THEN
1223: IF p_commit = FND_API.G_TRUE THEN
1224: ROLLBACK TO delete_desc_row_ss;
1225: END IF;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: WHEN OTHERS THEN

Line 1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1222: WHEN FND_API.G_EXC_ERROR THEN
1223: IF p_commit = FND_API.G_TRUE THEN
1224: ROLLBACK TO delete_desc_row_ss;
1225: END IF;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: WHEN OTHERS THEN
1228: IF p_commit = FND_API.G_TRUE THEN
1229: ROLLBACK TO delete_desc_row_ss;
1230: END IF;

Line 1228: IF p_commit = FND_API.G_TRUE THEN

1224: ROLLBACK TO delete_desc_row_ss;
1225: END IF;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: WHEN OTHERS THEN
1228: IF p_commit = FND_API.G_TRUE THEN
1229: ROLLBACK TO delete_desc_row_ss;
1230: END IF;
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232:

Line 1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1227: WHEN OTHERS THEN
1228: IF p_commit = FND_API.G_TRUE THEN
1229: ROLLBACK TO delete_desc_row_ss;
1230: END IF;
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232:
1233: END Delete_Desc_Row_SS;
1234:
1235: