318: x_msg_count => l_msg_count,
319: x_msg_data => l_msg_data
320: );
321:
322: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
323:
324: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
325: fnd_log.STRING (fnd_log.level_statement,
326: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
433: x_msg_count => l_msg_count,
434: x_msg_data => l_msg_data
435: );
436:
437: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
438:
439: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
440: fnd_log.STRING (fnd_log.level_statement,
441: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
506: x_msg_count => l_msg_count,
507: x_msg_data => l_msg_data
508: );
509:
510: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
511:
512: -- If RO is created in Draft status then
513: -- no Logistic lines are created
514:
549: x_msg_count => l_msg_count,
550: x_msg_data => l_msg_data
551: );
552:
553: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
554:
555: -- If Logistic line creation fails then rollback RO
556: Rollback To reprocess_ro_savepoint;
557:
574: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
575: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
576: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
577: p_api_version_number => 1.0,
578: p_init_msg_list => Fnd_Api.G_FALSE,
579: p_commit => Fnd_Api.G_FALSE,
580: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
581: p_repair_line_id => l_repair_line_id,
582: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
575: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
576: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
577: p_api_version_number => 1.0,
578: p_init_msg_list => Fnd_Api.G_FALSE,
579: p_commit => Fnd_Api.G_FALSE,
580: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
581: p_repair_line_id => l_repair_line_id,
582: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
583: x_return_status => l_return_status,
576: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
577: p_api_version_number => 1.0,
578: p_init_msg_list => Fnd_Api.G_FALSE,
579: p_commit => Fnd_Api.G_FALSE,
580: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
581: p_repair_line_id => l_repair_line_id,
582: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
583: x_return_status => l_return_status,
584: x_msg_count => l_msg_count,
657: x_msg_count => l_msg_count,
658: x_msg_data => l_msg_data
659: );
660:
661: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
662:
663: -- Update the record status
664:
665: Update csd_bulk_receive_items_b
693: p_msg_data => l_msg_data);
694:
695: End if;
696:
697: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
698:
699: -- Initialize the error count
700: l_ro_error_count := 0;
701:
724: x_msg_count => l_msg_count,
725: x_msg_data => l_msg_data
726: );
727:
728: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
729:
730: -- If the RO is created in Draft status then
731: -- no Logistic lines are created.
732:
766: x_msg_count => l_msg_count,
767: x_msg_data => l_msg_data
768: );
769:
770: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
771:
772: -- If Logistic line creation fails then rollback RO
773:
774: Rollback To create_ro_savepoint;
794: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
795: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
796: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
797: p_api_version_number => 1.0,
798: p_init_msg_list => Fnd_Api.G_FALSE,
799: p_commit => Fnd_Api.G_FALSE,
800: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
801: p_repair_line_id => l_repair_line_id,
802: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
795: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
796: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
797: p_api_version_number => 1.0,
798: p_init_msg_list => Fnd_Api.G_FALSE,
799: p_commit => Fnd_Api.G_FALSE,
800: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
801: p_repair_line_id => l_repair_line_id,
802: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
803: x_return_status => l_return_status,
796: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
797: p_api_version_number => 1.0,
798: p_init_msg_list => Fnd_Api.G_FALSE,
799: p_commit => Fnd_Api.G_FALSE,
800: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
801: p_repair_line_id => l_repair_line_id,
802: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
803: x_return_status => l_return_status,
804: x_msg_count => l_msg_count,
968: End if;
969:
970: EXCEPTION
971:
972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
973: -- write message to log file indicating the failure of the concurrent program,
974: -- return error retcode
975: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_BULK_RECEIVE_FAILURE');
976: retcode := c_error;
974: -- return error retcode
975: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_BULK_RECEIVE_FAILURE');
976: retcode := c_error;
977:
978: WHEN FND_API.G_EXC_ERROR THEN
979: -- write message to log file indicating the failure of the concurrent program,
980: -- return error retcode
981: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_BULK_RECEIVE_FAILURE');
982: retcode := c_error;
990:
991: -- Get the count of the Messages from the message list, if the count is 1
992: -- get the message as well
993:
994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
995: p_count => l_msg_count,
996: p_data => l_msg_data);
997:
998: IF l_msg_count = 1 THEN
1005: -- message list, retrieve the messages and write it to the log file
1006:
1007: FOR l_msg_ctr IN 1..l_msg_count
1008: LOOP
1009: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1010: fnd_file.put_line( fnd_file.log, l_msg_data);
1011: END LOOP;
1012:
1013: END IF;