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

Line 83: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

79: l_material VARCHAR2(40);
80: BEGIN
81: SAVEPOINT fork_logic;
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
84: l_api_name, G_PKG_NAME ) THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

81: SAVEPOINT fork_logic;
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
84: l_api_name, G_PKG_NAME ) THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;

Line 88: IF FND_API.to_Boolean( p_init_msg_list ) THEN

84: l_api_name, G_PKG_NAME ) THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: -- Initialize API return status to success
92: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: -- Initialize API return status to success
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- API body
95: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
96: 'Start of ' || l_full_name || '('

Line 130: if (l_project_id is null) then l_project_id := fnd_api.G_MISS_NUM;

126: and organization_id=p_organization_id;
127: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
128: 'l_material_issue_by_mo=' || l_material_issue_by_mo);
129: end if;
130: if (l_project_id is null) then l_project_id := fnd_api.G_MISS_NUM;
131: end if;
132: if (l_task_id is null) then l_task_id := fnd_api.G_MISS_NUM;
133: end if;
134: if (l_material_issue_by_mo = 'N') then

Line 132: if (l_task_id is null) then l_task_id := fnd_api.G_MISS_NUM;

128: 'l_material_issue_by_mo=' || l_material_issue_by_mo);
129: end if;
130: if (l_project_id is null) then l_project_id := fnd_api.G_MISS_NUM;
131: end if;
132: if (l_task_id is null) then l_task_id := fnd_api.G_MISS_NUM;
133: end if;
134: if (l_material_issue_by_mo = 'N') then
135: l_issue_by_mo := false;
136: end if;

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171:
172: --fix for 3454251.raise an error message if quantity to be issued is negative or zero
173:
174: if(p_requested_quantity<=0) then
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: fnd_message.set_name('EAM', 'EAM_REQUESTED_QUAN_NEG_ZERO');
177: fnd_message.set_token('OPERATION',p_operation_seq_num);
178: fnd_message.set_token('MATERIAL',l_material);
179: fnd_msg_pub.add;

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183: return;
184: end if;
185: --if the transaction date is in future raise an error message
186: if(p_date > sysdate) then
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: fnd_message.set_name('EAM', 'EAM_TRANS_DATE_FUTURE');
189: fnd_message.set_token('OPERATION',p_operation_seq_num);
190: fnd_message.set_token('MATERIAL',l_material);
191: fnd_msg_pub.add;

Line 208: x_return_status := FND_API.G_RET_STS_ERROR;

204: else
205: l_num_range_serials := inv_serial_number_pub.get_serial_diff(
206: l_fm_serial_number, l_to_serial_number);
207: if (l_num_range_serials <> p_requested_quantity) then
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: fnd_message.set_name('EAM', 'EAM_SERIAL_RANGE_QTY_MISMATCH');
210: fnd_message.set_token('OPERATION',p_operation_seq_num);
211: fnd_message.set_token('MATERIAL',l_material);
212: fnd_message.set_token('QTY_RANGE',l_num_range_serials);

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: AND msn.serial_number between l_fm_serial_number and l_to_serial_number
236: AND LENGTH(msn.serial_number) = LENGTH(l_fm_serial_number);
237:
238: if (l_num_valid_serials <> p_requested_quantity) then
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.set_name('EAM', 'EAM_N_SERIALS_UNAVAILABLE');
241: fnd_message.set_token('OPERATION',p_operation_seq_num);
242: fnd_message.set_token('MATERIAL',l_material);
243: fnd_message.set_token('NUM_UNAVAILABLE', p_requested_quantity - l_num_valid_serials);

Line 308: x_return_status := FND_API.G_RET_STS_ERROR;

304:
305:
306: if (x_err_flag = 1) then
307: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => x_error_msg);
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: return;
310: elsif (x_err_flag = 2) then
311: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_CANNOT_DELETE_RESOURCE',
312: p_token1=>'EAM_RET_MAT_PROCESS_MESSAGE', p_value1=>x_error_msg);

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: return;
310: elsif (x_err_flag = 2) then
311: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_CANNOT_DELETE_RESOURCE',
312: p_token1=>'EAM_RET_MAT_PROCESS_MESSAGE', p_value1=>x_error_msg);
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: return;
315: end if; -- end of x_error_flag check
316:
317: exception

Line 319: x_return_status := fnd_api.g_ret_sts_unexp_error;

315: end if; -- end of x_error_flag check
316:
317: exception
318: when others then --some unhandled exception occurred. rollback everything.
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320: rollback to before_insert_mti;
321: return ;
322: end;
323:

Line 444: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR

440: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
441: 'INV_TXN_MANAGER_PUB finished with return status='|| x_wip_ret_status);
442: end if;
443:
444: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR
445: x_wip_ret_status = FND_API.G_RET_STS_ERROR
446: ) then
447: rollback to before_insert_mti;
448: x_return_status := x_wip_ret_status;

Line 445: x_wip_ret_status = FND_API.G_RET_STS_ERROR

441: 'INV_TXN_MANAGER_PUB finished with return status='|| x_wip_ret_status);
442: end if;
443:
444: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR
445: x_wip_ret_status = FND_API.G_RET_STS_ERROR
446: ) then
447: rollback to before_insert_mti;
448: x_return_status := x_wip_ret_status;
449: if x_error_mssg1 is not null then

Line 457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

453: return;
454: --fix for 3454251.error out even if the return code is -1
455: elsif(l_txmgr_ret_code=-1) then
456: rollback to before_insert_mti;
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: if x_error_mssg1 is not null then
459: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_API_MESG',
460: p_token1=>'MESG', p_value1=>x_error_mssg1);
461: end if;

Line 480: IF FND_API.To_Boolean( p_commit )

476: end if;
477: -- End of API body.
478:
479: -- Standard check of p_commit.
480: IF FND_API.To_Boolean( p_commit )
481: AND x_return_status = FND_API.g_RET_STS_SUCCESS THEN
482: COMMIT WORK;
483: END IF;
484: -- Standard call to get message count and if count is 1, get message info.

Line 481: AND x_return_status = FND_API.g_RET_STS_SUCCESS THEN

477: -- End of API body.
478:
479: -- Standard check of p_commit.
480: IF FND_API.To_Boolean( p_commit )
481: AND x_return_status = FND_API.g_RET_STS_SUCCESS THEN
482: COMMIT WORK;
483: END IF;
484: -- Standard call to get message count and if count is 1, get message info.
485: FND_MSG_PUB.Count_And_Get(

Line 494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

490: ROLLBACK TO fork_logic;
491: if (l_log) then
492: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured' );
493: end if;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
498: END IF;

Line 542: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

538: end if;
539: -- Standard Start of API savepoint
540: SAVEPOINT PROCESS_MMTT;
541: -- Standard call to check for call compatibility.
542: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
543: l_api_name, G_PKG_NAME )
544: THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;

Line 545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

541: -- Standard call to check for call compatibility.
542: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
543: l_api_name, G_PKG_NAME )
544: THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;

Line 548: IF FND_API.to_Boolean( p_init_msg_list ) THEN

544: THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 552: x_return_status := FND_API.G_RET_STS_SUCCESS;

548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551: -- Initialize API return status to success
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: -- API body
555: l_msg_data := NULL;
556: l_return_status := NULL;

Line 591: p_initMsgList => fnd_api.G_TRUE,

587: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
588: 'Calling wip_mtlTempProc_grp.processTemp. p_txnHdrID=' || l_header_id);
589: end if;
590: wip_mtlTempProc_grp.processTemp(
591: p_initMsgList => fnd_api.G_TRUE,
592: p_processInv => fnd_api.G_TRUE, --whether or not to call inventory TM
593: p_txnHdrID => l_header_id,
594: x_returnStatus => x_return_status,
595: x_errorMsg => x_msg_data);

Line 592: p_processInv => fnd_api.G_TRUE, --whether or not to call inventory TM

588: 'Calling wip_mtlTempProc_grp.processTemp. p_txnHdrID=' || l_header_id);
589: end if;
590: wip_mtlTempProc_grp.processTemp(
591: p_initMsgList => fnd_api.G_TRUE,
592: p_processInv => fnd_api.G_TRUE, --whether or not to call inventory TM
593: p_txnHdrID => l_header_id,
594: x_returnStatus => x_return_status,
595: x_errorMsg => x_msg_data);
596: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 600: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

596: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
597: 'wip_mtlTempProc_grp.processTemp returned. x_returnStatus='||x_return_status
598: ||', x_errorMsg=' || REPLACE(x_msg_data, CHR(0), ' '));
599: end if;
600: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
601: ROLLBACK TO PROCESS_MMTT;
602: /* Fix for bug no :2719414 */
603: if(x_msg_data is not null) then
604: x_msg_count := 1 ;

Line 621: IF FND_API.To_Boolean( p_commit ) THEN

617: end if;
618: -- End of API body.
619:
620: -- Standard check of p_commit.
621: IF FND_API.To_Boolean( p_commit ) THEN
622: COMMIT WORK;
623: END IF;
624: -- Standard call to get message count and if count is 1, get message info.
625: FND_MSG_PUB.Count_And_Get(

Line 632: x_return_status := FND_API.G_RET_STS_ERROR;

628: EXCEPTION
629: /* Added for bug 4041420 - Start */
630: WHEN NO_ACCT_PERIOD_EXC THEN
631: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_TRANSACTION_DATE_INVALID');
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: /* Added for bug 4041420 - End */
634: WHEN OTHERS THEN
635: ROLLBACK TO PROCESS_MMTT;
636: if (l_log) then

Line 639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

635: ROLLBACK TO PROCESS_MMTT;
636: if (l_log) then
637: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured');
638: end if;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
643: END IF;

Line 811: IF NOT fnd_api.compatible_api_call(

807:
808: SAVEPOINT cancel_alloc_matl_del;
809:
810: -- Standard call to check for call compatibility.
811: IF NOT fnd_api.compatible_api_call(
812: l_api_version
813: ,p_api_version
814: ,l_api_name
815: ,g_pkg_name) THEN

Line 816: RAISE fnd_api.g_exc_unexpected_error;

812: l_api_version
813: ,p_api_version
814: ,l_api_name
815: ,g_pkg_name) THEN
816: RAISE fnd_api.g_exc_unexpected_error;
817: END IF;
818:
819: -- Initialize message list if p_init_msg_list is set to TRUE.
820: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 820: IF fnd_api.to_boolean(p_init_msg_list) THEN

816: RAISE fnd_api.g_exc_unexpected_error;
817: END IF;
818:
819: -- Initialize message list if p_init_msg_list is set to TRUE.
820: IF fnd_api.to_boolean(p_init_msg_list) THEN
821: fnd_msg_pub.initialize;
822: END IF;
823:
824: -- Initialize API return status to success

Line 825: x_return_status := fnd_api.g_ret_sts_success; -- line 892

821: fnd_msg_pub.initialize;
822: END IF;
823:
824: -- Initialize API return status to success
825: x_return_status := fnd_api.g_ret_sts_success; -- line 892
826:
827: -- API body
828:
829:

Line 849: IF fnd_api.to_boolean(p_commit) THEN

845:
846: -- End of API body.
847: -- Standard check of p_commit.
848:
849: IF fnd_api.to_boolean(p_commit) THEN
850: COMMIT WORK;
851: END IF;
852:
853: -- l_stmt_num := 999;

Line 860: WHEN fnd_api.g_exc_error THEN

856: fnd_msg_pub.count_and_get(
857: p_count => x_msg_count,
858: p_data => x_msg_data);
859: EXCEPTION
860: WHEN fnd_api.g_exc_error THEN
861: ROLLBACK TO cancel_alloc_matl_del;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_msg_pub.count_and_get(
864: -- p_encoded => FND_API.g_false

Line 862: x_return_status := fnd_api.g_ret_sts_error;

858: p_data => x_msg_data);
859: EXCEPTION
860: WHEN fnd_api.g_exc_error THEN
861: ROLLBACK TO cancel_alloc_matl_del;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_msg_pub.count_and_get(
864: -- p_encoded => FND_API.g_false
865: p_count => x_msg_count
866: ,p_data => x_msg_data);

Line 864: -- p_encoded => FND_API.g_false

860: WHEN fnd_api.g_exc_error THEN
861: ROLLBACK TO cancel_alloc_matl_del;
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_msg_pub.count_and_get(
864: -- p_encoded => FND_API.g_false
865: p_count => x_msg_count
866: ,p_data => x_msg_data);
867: WHEN fnd_api.g_exc_unexpected_error THEN
868: ROLLBACK TO cancel_alloc_matl_del;

Line 867: WHEN fnd_api.g_exc_unexpected_error THEN

863: fnd_msg_pub.count_and_get(
864: -- p_encoded => FND_API.g_false
865: p_count => x_msg_count
866: ,p_data => x_msg_data);
867: WHEN fnd_api.g_exc_unexpected_error THEN
868: ROLLBACK TO cancel_alloc_matl_del;
869: x_return_status := fnd_api.g_ret_sts_unexp_error;
870:
871: fnd_msg_pub.count_and_get(

Line 869: x_return_status := fnd_api.g_ret_sts_unexp_error;

865: p_count => x_msg_count
866: ,p_data => x_msg_data);
867: WHEN fnd_api.g_exc_unexpected_error THEN
868: ROLLBACK TO cancel_alloc_matl_del;
869: x_return_status := fnd_api.g_ret_sts_unexp_error;
870:
871: fnd_msg_pub.count_and_get(
872: p_count => x_msg_count
873: ,p_data => x_msg_data);

Line 876: x_return_status := fnd_api.g_ret_sts_unexp_error;

872: p_count => x_msg_count
873: ,p_data => x_msg_data);
874: WHEN OTHERS THEN
875: ROLLBACK TO cancel_alloc_matl_del;
876: x_return_status := fnd_api.g_ret_sts_unexp_error;
877: IF fnd_msg_pub.check_msg_level(
878: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
879: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;

Line 946: IF NOT fnd_api.compatible_api_call(

942: -- Standard Start of API savepoint
943: SAVEPOINT comp_alloc_chng_qty;
944:
945: -- Standard call to check for call compatibility.
946: IF NOT fnd_api.compatible_api_call(
947: l_api_version
948: ,p_api_version
949: ,l_api_name
950: ,g_pkg_name) THEN

Line 951: RAISE fnd_api.g_exc_unexpected_error;

947: l_api_version
948: ,p_api_version
949: ,l_api_name
950: ,g_pkg_name) THEN
951: RAISE fnd_api.g_exc_unexpected_error;
952: END IF;
953:
954: -- Initialize message list if p_init_msg_list is set to TRUE.
955: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 955: IF fnd_api.to_boolean(p_init_msg_list) THEN

951: RAISE fnd_api.g_exc_unexpected_error;
952: END IF;
953:
954: -- Initialize message list if p_init_msg_list is set to TRUE.
955: IF fnd_api.to_boolean(p_init_msg_list) THEN
956: fnd_msg_pub.initialize;
957: END IF;
958:
959: -- Initialize API return status to success

Line 960: x_return_status := fnd_api.g_ret_sts_success;

956: fnd_msg_pub.initialize;
957: END IF;
958:
959: -- Initialize API return status to success
960: x_return_status := fnd_api.g_ret_sts_success;
961:
962: -- API body
963:
964: if (l_plog) then

Line 1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1045:
1046:
1047: else
1048:
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: fnd_message.set_name('EAM', 'EAM_ALLOCATE_QTY_ERROR'); -- Error message to be provided
1051: x_msg_data := fnd_message.get;
1052:
1053:

Line 1078: p_init_msg_list => fnd_api.g_false ,

1074: l_allocate_comp_inc_rec.end_serial := null;
1075: l_allocate_comp_inc_tbl(1) := l_allocate_comp_inc_rec;
1076:
1077: EAM_MATERIAL_request_PVT.allocate(p_api_version => 1.0,
1078: p_init_msg_list => fnd_api.g_false ,
1079: p_commit => fnd_api.g_false,
1080: p_validation_level => fnd_api.g_valid_level_full,
1081: x_return_status => l_return_status,
1082: x_msg_count => l_msg_count,

Line 1079: p_commit => fnd_api.g_false,

1075: l_allocate_comp_inc_tbl(1) := l_allocate_comp_inc_rec;
1076:
1077: EAM_MATERIAL_request_PVT.allocate(p_api_version => 1.0,
1078: p_init_msg_list => fnd_api.g_false ,
1079: p_commit => fnd_api.g_false,
1080: p_validation_level => fnd_api.g_valid_level_full,
1081: x_return_status => l_return_status,
1082: x_msg_count => l_msg_count,
1083: x_msg_data => l_msg_data,

Line 1080: p_validation_level => fnd_api.g_valid_level_full,

1076:
1077: EAM_MATERIAL_request_PVT.allocate(p_api_version => 1.0,
1078: p_init_msg_list => fnd_api.g_false ,
1079: p_commit => fnd_api.g_false,
1080: p_validation_level => fnd_api.g_valid_level_full,
1081: x_return_status => l_return_status,
1082: x_msg_count => l_msg_count,
1083: x_msg_data => l_msg_data,
1084: x_request_number => l_request_number,

Line 1107: IF fnd_api.to_boolean(p_commit) THEN

1103:
1104: -- End of API body.
1105: -- Standard check of p_commit.
1106:
1107: IF fnd_api.to_boolean(p_commit) THEN
1108: COMMIT WORK;
1109: END IF;
1110:
1111: -- l_stmt_num := 999;

Line 1118: WHEN fnd_api.g_exc_error THEN

1114: fnd_msg_pub.count_and_get(
1115: p_count => x_msg_count
1116: ,p_data => x_msg_data);
1117: EXCEPTION
1118: WHEN fnd_api.g_exc_error THEN
1119: ROLLBACK TO comp_alloc_chng_qty;
1120: x_return_status := fnd_api.g_ret_sts_error;
1121: fnd_msg_pub.count_and_get(
1122: -- p_encoded => FND_API.g_false

Line 1120: x_return_status := fnd_api.g_ret_sts_error;

1116: ,p_data => x_msg_data);
1117: EXCEPTION
1118: WHEN fnd_api.g_exc_error THEN
1119: ROLLBACK TO comp_alloc_chng_qty;
1120: x_return_status := fnd_api.g_ret_sts_error;
1121: fnd_msg_pub.count_and_get(
1122: -- p_encoded => FND_API.g_false
1123: p_count => x_msg_count
1124: ,p_data => x_msg_data);

Line 1122: -- p_encoded => FND_API.g_false

1118: WHEN fnd_api.g_exc_error THEN
1119: ROLLBACK TO comp_alloc_chng_qty;
1120: x_return_status := fnd_api.g_ret_sts_error;
1121: fnd_msg_pub.count_and_get(
1122: -- p_encoded => FND_API.g_false
1123: p_count => x_msg_count
1124: ,p_data => x_msg_data);
1125: WHEN fnd_api.g_exc_unexpected_error THEN
1126: ROLLBACK TO comp_alloc_chng_qty;

Line 1125: WHEN fnd_api.g_exc_unexpected_error THEN

1121: fnd_msg_pub.count_and_get(
1122: -- p_encoded => FND_API.g_false
1123: p_count => x_msg_count
1124: ,p_data => x_msg_data);
1125: WHEN fnd_api.g_exc_unexpected_error THEN
1126: ROLLBACK TO comp_alloc_chng_qty;
1127: x_return_status := fnd_api.g_ret_sts_unexp_error;
1128:
1129: fnd_msg_pub.count_and_get(

Line 1127: x_return_status := fnd_api.g_ret_sts_unexp_error;

1123: p_count => x_msg_count
1124: ,p_data => x_msg_data);
1125: WHEN fnd_api.g_exc_unexpected_error THEN
1126: ROLLBACK TO comp_alloc_chng_qty;
1127: x_return_status := fnd_api.g_ret_sts_unexp_error;
1128:
1129: fnd_msg_pub.count_and_get(
1130: p_count => x_msg_count
1131: ,p_data => x_msg_data);

Line 1134: x_return_status := fnd_api.g_ret_sts_unexp_error;

1130: p_count => x_msg_count
1131: ,p_data => x_msg_data);
1132: WHEN OTHERS THEN
1133: ROLLBACK TO comp_alloc_chng_qty;
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135: IF fnd_msg_pub.check_msg_level(
1136: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1137: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1138: END IF;

Line 1193: IF NOT fnd_api.compatible_api_call(

1189:
1190: SAVEPOINT comp_alloc_new_mat;
1191:
1192: -- Standard call to check for call compatibility.
1193: IF NOT fnd_api.compatible_api_call(
1194: l_api_version
1195: ,p_api_version
1196: ,l_api_name
1197: ,g_pkg_name) THEN

Line 1198: RAISE fnd_api.g_exc_unexpected_error;

1194: l_api_version
1195: ,p_api_version
1196: ,l_api_name
1197: ,g_pkg_name) THEN
1198: RAISE fnd_api.g_exc_unexpected_error;
1199: END IF;
1200:
1201: -- Initialize message list if p_init_msg_list is set to TRUE.
1202: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1202: IF fnd_api.to_boolean(p_init_msg_list) THEN

1198: RAISE fnd_api.g_exc_unexpected_error;
1199: END IF;
1200:
1201: -- Initialize message list if p_init_msg_list is set to TRUE.
1202: IF fnd_api.to_boolean(p_init_msg_list) THEN
1203: fnd_msg_pub.initialize;
1204: END IF;
1205:
1206: -- Initialize API return status to success

Line 1207: x_return_status := fnd_api.g_ret_sts_success;

1203: fnd_msg_pub.initialize;
1204: END IF;
1205:
1206: -- Initialize API return status to success
1207: x_return_status := fnd_api.g_ret_sts_success;
1208:
1209: -- API body
1210:
1211: l_wip_entity_id := p_wip_entity_id;

Line 1265: p_init_msg_list => fnd_api.g_false ,

1261:
1262: l_allocate_comp_inc_tbl(1) := l_allocate_comp_inc_rec;
1263:
1264: EAM_MATERIAL_request_PVT.allocate(p_api_version => 1.0,
1265: p_init_msg_list => fnd_api.g_false ,
1266: p_commit => fnd_api.g_false,
1267: p_validation_level => fnd_api.g_valid_level_full,
1268: x_return_status => l_return_status,
1269: x_msg_count => l_msg_count,

Line 1266: p_commit => fnd_api.g_false,

1262: l_allocate_comp_inc_tbl(1) := l_allocate_comp_inc_rec;
1263:
1264: EAM_MATERIAL_request_PVT.allocate(p_api_version => 1.0,
1265: p_init_msg_list => fnd_api.g_false ,
1266: p_commit => fnd_api.g_false,
1267: p_validation_level => fnd_api.g_valid_level_full,
1268: x_return_status => l_return_status,
1269: x_msg_count => l_msg_count,
1270: x_msg_data => l_msg_data,

Line 1267: p_validation_level => fnd_api.g_valid_level_full,

1263:
1264: EAM_MATERIAL_request_PVT.allocate(p_api_version => 1.0,
1265: p_init_msg_list => fnd_api.g_false ,
1266: p_commit => fnd_api.g_false,
1267: p_validation_level => fnd_api.g_valid_level_full,
1268: x_return_status => l_return_status,
1269: x_msg_count => l_msg_count,
1270: x_msg_data => l_msg_data,
1271: x_request_number => l_request_number,

Line 1288: IF fnd_api.to_boolean(p_commit) THEN

1284:
1285: -- End of API body.
1286: -- Standard check of p_commit.
1287:
1288: IF fnd_api.to_boolean(p_commit) THEN
1289: COMMIT WORK;
1290: END IF;
1291:
1292: -- l_stmt_num := 999;

Line 1299: WHEN fnd_api.g_exc_error THEN

1295: fnd_msg_pub.count_and_get(
1296: p_count => x_msg_count
1297: ,p_data => x_msg_data);
1298: EXCEPTION
1299: WHEN fnd_api.g_exc_error THEN
1300: ROLLBACK TO comp_alloc_new_mat;
1301: x_return_status := fnd_api.g_ret_sts_error;
1302: fnd_msg_pub.count_and_get(
1303: -- p_encoded => FND_API.g_false

Line 1301: x_return_status := fnd_api.g_ret_sts_error;

1297: ,p_data => x_msg_data);
1298: EXCEPTION
1299: WHEN fnd_api.g_exc_error THEN
1300: ROLLBACK TO comp_alloc_new_mat;
1301: x_return_status := fnd_api.g_ret_sts_error;
1302: fnd_msg_pub.count_and_get(
1303: -- p_encoded => FND_API.g_false
1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);

Line 1303: -- p_encoded => FND_API.g_false

1299: WHEN fnd_api.g_exc_error THEN
1300: ROLLBACK TO comp_alloc_new_mat;
1301: x_return_status := fnd_api.g_ret_sts_error;
1302: fnd_msg_pub.count_and_get(
1303: -- p_encoded => FND_API.g_false
1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO comp_alloc_new_mat;

Line 1306: WHEN fnd_api.g_exc_unexpected_error THEN

1302: fnd_msg_pub.count_and_get(
1303: -- p_encoded => FND_API.g_false
1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO comp_alloc_new_mat;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:
1310: fnd_msg_pub.count_and_get(

Line 1308: x_return_status := fnd_api.g_ret_sts_unexp_error;

1304: p_count => x_msg_count
1305: ,p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO comp_alloc_new_mat;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:
1310: fnd_msg_pub.count_and_get(
1311: p_count => x_msg_count
1312: ,p_data => x_msg_data);

Line 1315: x_return_status := fnd_api.g_ret_sts_unexp_error;

1311: p_count => x_msg_count
1312: ,p_data => x_msg_data);
1313: WHEN OTHERS THEN
1314: ROLLBACK TO comp_alloc_new_mat;
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316: IF fnd_msg_pub.check_msg_level(
1317: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1319: END IF;

Line 1371: IF NOT fnd_api.compatible_api_call(

1367:
1368: SAVEPOINT alloc_at_release_cancel;
1369:
1370: -- Standard call to check for call compatibility.
1371: IF NOT fnd_api.compatible_api_call(
1372: l_api_version
1373: ,p_api_version
1374: ,l_api_name
1375: ,g_pkg_name) THEN

Line 1376: RAISE fnd_api.g_exc_unexpected_error;

1372: l_api_version
1373: ,p_api_version
1374: ,l_api_name
1375: ,g_pkg_name) THEN
1376: RAISE fnd_api.g_exc_unexpected_error;
1377: END IF;
1378:
1379: -- Initialize message list if p_init_msg_list is set to TRUE.
1380: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1380: IF fnd_api.to_boolean(p_init_msg_list) THEN

1376: RAISE fnd_api.g_exc_unexpected_error;
1377: END IF;
1378:
1379: -- Initialize message list if p_init_msg_list is set to TRUE.
1380: IF fnd_api.to_boolean(p_init_msg_list) THEN
1381: fnd_msg_pub.initialize;
1382: END IF;
1383:
1384: -- Initialize API return status to success

Line 1385: x_return_status := fnd_api.g_ret_sts_success;

1381: fnd_msg_pub.initialize;
1382: END IF;
1383:
1384: -- Initialize API return status to success
1385: x_return_status := fnd_api.g_ret_sts_success;
1386:
1387: -- API body
1388: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start');
1389: end if;

Line 1447: IF fnd_api.to_boolean(p_commit) THEN

1443: end if;
1444:
1445: -- End of API body.
1446: -- Standard check of p_commit.
1447: IF fnd_api.to_boolean(p_commit) THEN
1448: COMMIT WORK;
1449: END IF;
1450:
1451: -- Standard call to get message count and if count is 1, get message info.

Line 1458: WHEN fnd_api.g_exc_error THEN

1454: fnd_msg_pub.count_and_get(
1455: p_count => x_msg_count
1456: ,p_data => x_msg_data);
1457: EXCEPTION
1458: WHEN fnd_api.g_exc_error THEN
1459: ROLLBACK TO alloc_at_release_cancel;
1460: x_return_status := fnd_api.g_ret_sts_error;
1461: fnd_msg_pub.count_and_get(
1462: -- p_encoded => FND_API.g_false

Line 1460: x_return_status := fnd_api.g_ret_sts_error;

1456: ,p_data => x_msg_data);
1457: EXCEPTION
1458: WHEN fnd_api.g_exc_error THEN
1459: ROLLBACK TO alloc_at_release_cancel;
1460: x_return_status := fnd_api.g_ret_sts_error;
1461: fnd_msg_pub.count_and_get(
1462: -- p_encoded => FND_API.g_false
1463: p_count => x_msg_count
1464: ,p_data => x_msg_data);

Line 1462: -- p_encoded => FND_API.g_false

1458: WHEN fnd_api.g_exc_error THEN
1459: ROLLBACK TO alloc_at_release_cancel;
1460: x_return_status := fnd_api.g_ret_sts_error;
1461: fnd_msg_pub.count_and_get(
1462: -- p_encoded => FND_API.g_false
1463: p_count => x_msg_count
1464: ,p_data => x_msg_data);
1465: WHEN fnd_api.g_exc_unexpected_error THEN
1466: ROLLBACK TO alloc_at_release_cancel;

Line 1465: WHEN fnd_api.g_exc_unexpected_error THEN

1461: fnd_msg_pub.count_and_get(
1462: -- p_encoded => FND_API.g_false
1463: p_count => x_msg_count
1464: ,p_data => x_msg_data);
1465: WHEN fnd_api.g_exc_unexpected_error THEN
1466: ROLLBACK TO alloc_at_release_cancel;
1467: x_return_status := fnd_api.g_ret_sts_unexp_error;
1468:
1469: fnd_msg_pub.count_and_get(

Line 1467: x_return_status := fnd_api.g_ret_sts_unexp_error;

1463: p_count => x_msg_count
1464: ,p_data => x_msg_data);
1465: WHEN fnd_api.g_exc_unexpected_error THEN
1466: ROLLBACK TO alloc_at_release_cancel;
1467: x_return_status := fnd_api.g_ret_sts_unexp_error;
1468:
1469: fnd_msg_pub.count_and_get(
1470: p_count => x_msg_count
1471: ,p_data => x_msg_data);

Line 1474: x_return_status := fnd_api.g_ret_sts_unexp_error;

1470: p_count => x_msg_count
1471: ,p_data => x_msg_data);
1472: WHEN OTHERS THEN
1473: ROLLBACK TO alloc_at_release_cancel;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: IF fnd_msg_pub.check_msg_level(
1476: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1477: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1478: END IF;